Question: this question is need to be done on Excel. up will total order amounts above $100. 4 Hens Inc. require farm workers from 6 AM

this question is need to be done on Excel.
up will total order amounts above $100. 4 Hens Inc. require farm workers from 6 AM to 6 PM. Full-time staff work 8 hours and start either at 6 AM or 10 AM. Part-time staff work 4 hours per shift and start either at 10 AM or 2 PM. The company pays full-time workers $175 per shift and part-time workers $80 per shift. Hens Inc. can schedule no more than 4 part-time workers each day. The company needs to schedule the number of workers required for each 4-hour block as shown below. Develop a linear Solver model to determine how the company can minimize daily labour costs. 4-Hour Block 6 AM 10 AM 10 AM - 2 PM 2 PM - 6 PM Required 8 12 9Step 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
