Question: Solve this using excel solver The store is open daily, from 8 a.m. to 5 p.m. Staffing requirements are shown in the table. 5 permanent
Solve this using excel solver 
The store is open daily, from 8 a.m. to 5 p.m. Staffing requirements are shown in the table. 5 permanent employees work all day. Part-time employees work 4-hour shifts. What is the minimum number of part-time employees needed to meet staffing requirements? - Xi= integer number of part-time workers that start on the ith 4-hour shift ( i=1 for 8 a.m., ..., i=6 for 1 p.m.) - Constraints: For each hour, we need to ensure that the total number of part-time employees who work that hour is at least as large as the minimum requirements. At least two (X>=2) part time workers should be allocated for each 4-hour shift
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
