November EC Meeting 2019

QGH Hotel - 2019 HOURLY PAID Payroll Costs

Weeks

5

4

4

5

4

4

5

4

4

5

4

4

Weekly Average (SALES) Sales

19,878.20

27,021.00

26,974.25

27,530.80

34,468.00

47,080.50

36,652.80

53,944.25

45,078.75

31,520.00

-

-

Hours (TOTAL)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Kitchen

1,262.00

1,086.50

1,083.75

1,183.25

1,370.00

917.00 727.50

1,217.00 1,190.75 1,497.00

1,080.75 1,154.00 2,160.15

893.25

975.50

Housekeeping

652.50

656.50

671.50

861.50

786.75

1,113.00 2,061.20

1,437.75 2,321.00

F & B

1,812.00

1,194.82

1,287.00

1,612.00

1,501.75

1,675.75

Gross Pay (TOTAL) Kitchen

9,926.72 4,954.30 13,602.79

8,833.98 4,969.58 8,833.98

8,560.90 5,084.66 9,469.50

9,434.85 6,716.72 12,005.91

8,628.16 6,167.91 10,929.46

7,584.17 5,728.95 12,570.98

9,218.65 9,356.40 10,472.36

8,173.16 9,192.69 16,124.60

7,883.35 9,009.61 15,653.64

8,600.29 11,812.54 17,542.92

Housekeeping

F & B

Weekly Average (HOURS) Kitchen

252.40 130.50 362.40

271.63 164.13 298.71

270.94 167.88 321.75

236.65 172.30 322.40

342.50 196.69 375.44

229.25 181.88 418.94

243.40 238.15 299.40

270.19 288.50 540.04

223.31 278.25 515.30

195.10 287.55 464.20

- - - - - -

- - - - - -

Housekeeping

F & B

Weekly Average (GROSS PAY) Kitchen

1,985.34

2,208.50 1,242.40 2,208.50

2,140.23 1,271.17 2,367.38

1,886.97 1,343.34 2,401.18

2,157.04 1,541.98 2,732.37

1,896.04 1,432.24 3,142.75

1,843.73 1,871.28 2,094.47

2,043.29 2,298.17 4,031.15

1,970.84 2,252.40 3,913.41

1,720.06 2,362.51 3,508.58

Housekeeping

990.86

F & B

2,720.56

Weekly Average (HOURLY RATE) Kitchen

7.87 7.59 7.51

8.13 7.57 7.39

7.90 7.57 7.36

7.97 7.80 7.45

6.30 7.84 7.28

8.27 7.87 7.50

7.57 7.86 7.00

7.56 7.97 7.46

8.83 8.09 7.59

8.82 8.22 7.56

Housekeeping

F & B

Gross Pay (% of SALES) Kitchen

49.9% 32.7% 31.7% 34.3% 25.0% 16.1% 25.2% 15.2% 17.5% 27.3% 24.9% 18.4% 18.9% 24.4% 17.9% 12.2% 25.5% 17.0% 20.0% 37.5%

Housekeeping

F & B 68.4% 32.7% 35.1% 43.6% 31.7% 26.7% 28.6% 29.9% 34.7% 55.7% N.B. Payroll Costs are as per the SAGE monthly payroll costing which will usually include 2 weeks payroll data of the previous month