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 Solve this using excel solver The store is open daily, from 8

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!