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! How can I solve this using Excel? - can you please include

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

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!