Home /
Expert Answers /
Operations Management /
2part-prob-nbsp-part1-formulate-lp-modelpart2-create-spreadhseet-use-solver-4-problem-nbsp-on-exce-pa671
(Solved): 2PaRt PrOB. part1 FORMULATE LP modeLpart2 create spreadhseet use solver 4 problem. on EXce ...
2PaRt PrOB.
part1 FORMULATE LP modeL
part2 create spreadhseet use solver 4 problem.
on EXcel please
Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park, employees do not like to work shifts of fewer than eight hours. These eight- heir shifts start every four hours throughout the day. The number of maintenance workers needed at different times throughout the day varies. The following table summarizes the minimum number of employees needed in each four-hour time period. Time Period 12 a.m. 4 a.m. 4 a.m. 8 a.m. 8 a.m. – 12 p.m. 12 p.m. - 4 p.m. 4 p.m. - 8 p.m. 8 p.m. 12 a.m. Minimum Employees Needed 80 210 245 160 295 120 The maintenance supervisor wants to determine the minimum number of employees to schedule that meets the minimum staffing requirements. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the problem.
Expert Answer
solution: Let the new no. of employees joining from 12 am to 4 am be X1, from 4 am to 8 am be X2, and so on Hence, we get the decision variables as X1, X2, X3, X4, X5, X6 since there are 6 slots of 4 hours each. Total no. of employees = X1 + X2 + X3