Question: How can I solve this using Excel? - can you please include a screenshot of the excel formulas used to solve so I can create
How can I solve this using Excel? - can you please include a screenshot of the excel formulas used to solve so I can create my own workbook. Thank you! 
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are: Suppose that each part-time worker can work only 3 days, but the days must be consecutive. Formulate and solve this workforce scheduling problem as a Linear Program and solve it using POM for Windows. Your objective is to minimize total slack capacity. What is the minimum number of loaders needed now? Hint: Read Supplement D before doing this problem. Let x1 be the number of workers working a particular 3-day schedule, such as Tuesday through Thursday. The optimal schedule indicates that the minimum number of loaders needed is loaders. (Enter your response as a whole number.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
