ZuoTi.Pro
Question

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 Th Su Day Requirements Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note:If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) The minimum number of workers isworkers. (Enter your response as a whole number)

PLEASE SHOW ALL WORK/INCLUDE FORMULAS NEEDED

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Will work on day-Yes?No? 2 Starting Day M Fr Su 6 Th 1 1 1 1 1 1 1 1 9 Su 1 Decision Variables 11 Number of workers who start work on each day 12 Starting Day No.of worker 13 M 14 T 15 W 16 Th 17 Fr 18 S 19 Su

20 21 Minimize the total number of workers 22 SUM(B13:B19) 23 24-SUMPRODUCT(B13:B19,B3:B9) 25 SUMPRODUCT(B13:B19,C3:C9) 26 SUMPRODUCT(B13:B19,D3:D9) 27 SUMPRODUCT(B13:B19,E3:E9) 28 -SUMPRODUCT(B13:B19,F3:F9) 29 -SUMPRODUCT B13:B19,G3:G9) 30 SUMPRODUCT(B13:B19,H3:H9) 31 32 Objective function Constraints 4 2 5

F40 20 Objective function 21 Minimize the total number of workers C) Constraints 23 24 25 26 27 28 29 30 31 32 0 x 0 x 0 x 0 x 0 x 0 x 0 x 4

Solver Parameters SAS22 Set Objective To: O Max By Changing aiable Cells: Value Of: SBS13:SBS19 Subject to the Constraints: SAS24:SAS30SCS24:SCS30 SBS13:SBS190 Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a SolvingSimplex LP Method: Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

014 Decision Variables 10 11 Number of workers who start work on each day 12 Starting Da No.of worker 16 | 17 18 Su Objective function Minimize the total number of workers 23 Constraints 4 4 25 4 27 30

0 0
Add a comment
Know the answer?
Add Answer to:
PLEASE SHOW ALL WORK/INCLUDE FORMULAS NEEDED Gerald Glynn manages the Michaels Distribution Center. After careful examination...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has...

    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 Day Th Requirements4 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference o...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT