Hotel Directors Meeting March 2020

QGH Hotel - 2019 HOURLY PAID Payroll Costs

Weeks

5

4

4

5

4

4

5

4

4

5

4

4

Weekly Average (SALES) Sales

127,036.00

140,738.00

-

-

-

-

-

-

-

-

-

-

Hours (TOTAL)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Kitchen

1,137.25 1,305.00 2,338.25

898.25

Housekeeping

1,146.00 1,715.00

F & B

Gross Pay (TOTAL) Kitchen

8,614.66 10,898.71 17,492.02

7,966.06 9,569.59 13,014.40

Housekeeping

F & B

Weekly Average (HOURS) Kitchen

227.45 261.00 467.65

224.56 286.50 428.75

- - - - - -

- - - - - -

- - - - - -

- - - - - -

- - - - - -

- - - - - -

- - - - - -

- - - - - -

- - - - - -

- - - - - -

Housekeeping

F & B

Weekly Average (GROSS PAY) Kitchen

1,722.93 2,179.74 3,498.40

1,991.52 2,392.40 3,253.60

Housekeeping

F & B

Weekly Average (HOURLY RATE) Kitchen

7.57 8.35 7.48

8.87 8.35 7.59

Housekeeping

F & B

Gross Pay (% of SALES) Kitchen

6.8% 8.6%

5.7% 6.8%

Housekeeping

F & B 9.2% N.B. Payroll Costs are as per the SAGE monthly payroll costing which will usually include 2 weeks payroll data of the previous month 13.8%