Reference no: EM133167464

Mister Lee prepares a Payroll Budget Estimate every week. The software is currently installing upgrades for the next several hours and is not available, so he asked you to do the calculations for the Payroll Budget Estimate right now. Mister Lee has recorded the scheduled hours by name, position, and hourly rate for the week of April 18, 2022. His forecasted sales for the week are $56,675.00 and his payroll cost percentage goal is 34%. Complete the payroll estimate and calculate the actual payroll percentage.

Payroll Information

The payroll includes the following staff:

$

1 Exécutive Chef @ 38

1 Sous-Chef    @30

1 Chef @ 25

4 Cooks @ 20

3 Dishwashers @18

8 Servers @15

3 Assistant Servers@15

The chef works an average 40 hours per week, while the cooks work 36 hours. 2 Dishwashers work 36 hours while one works 24 hours.  1 server works 30 hours, 4 servers work 28 hours while 1 server works 24 hours. The assistant servers work 26 hours per week.

Allowances are added to the costs as:  Allowance for health insurance, vacations, & sick days-estimate is 30% of total wages.

Task

• Complete the payroll estimate and calculate the actual payroll percentage.