A small store is open from 8:00 am to midnight and needs to be staffe
Strategic Management and Strategic Competitiveness
September 21, 202020 Excellent Topics on the Dangers of Antibiotics for a Critical Essay
September 22, 2020A small store is open from 8:00 am to midnight and needs to be staffe
A small store is open from 8:00 am to midnight and needs to be staffed to meet the following requirements for each of four time periods:
| Time of the Day | Minimum Number of Employees |
| 8:00 to Noon | 6 |
| Noon to 4:00 pm | 8 |
| 4:00 pm to 8:00 pm | 12 |
| 8:00 pm to Midnight | 6 |
The owner of the store can hire either full-time employees or part-time employees. Full-time employees work for 8 consecutive hours and hence can be hired for the following shifts: 8:00 am to 4:00 pm (Shift 1), Noon to 8:00 pm (Shift 2), 4:00 pm to Midnight (Shift 3). Each full-time employee is paid $14 per hour. Part-time employees can be hired to cover any of the four time periods listed in the table above. Each part-time employee is paid $12 per hour. In addition to the minimum number of employees (full-time or part-time) for each of the four time periods given above, the owner also wants to make sure that there are at least two full-time employees for every part-time employee on duty.
The owner wants to determine how many full-time and part-time employees to hire for each shift/time period that will minimize the overall cost.
1. What are are the decision variables and constraints?
2. Upload a screenshot of your spreadsheet setup.
Need assistance with this?
