Scenarios and Solver Grader Project : Excel 2016
Blacksmith G
Alhadad_e05ch10_grader_h1_Schedule.xlsxSchedule
| Sch. | Days off | Employees | Sun | Mon | Tue | Wed | Thu | Fri | Sat | ||
| A | Sunday, Monday | 4 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | ||
| B | Monday, Tuesday | 4 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | ||
| C | Tuesday, Wed. | 4 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | ||
| D | Wed., Thursday | 6 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | ||
| E | Thursday, Friday | 6 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | ||
| F | Friday, Saturday | 4 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | ||
| G | Saturday, Sunday | 4 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | ||
| Schedule Totals: | |||||||||||
| Total Needed: | 22 | 17 | 13 | 14 | 15 | 18 | 24 | ||||
| Total shifts schedule | |||||||||||
| Pay/Employee/Day: | $80.00 | ||||||||||
| Payroll/Week: | |||||||||||
&F
Part-Time Expenses
| Expenses | ||||
| Average Part-time hours | 210600 | |||
| Average Hourly Rate | $10.30 | |||
| Benefit % | 28.00% | |||
| Total PT Wage Expense |
&F
