Week 7 Homework.xlsx - Scheduling Homework Problem An...

• 6

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 6 pages.

Scheduling Homework ProblemFTPT8-124269-100010-200011-307712-40001-50114108-99-1010-11 11-12 12-11-22-33-44-58-126662444449-100000000010-200000000011-300077770012-40000000001-5000001111Available666911121255>=>=>=>=>=>=>=>=>=Min required6449119655Total Employees14An office supply store is trying to develop of schedule for a typicabusiness is not seasonal, and each day's volume is similar, so theevery day they are open.The have determined that the number ohour they are open are as follows:8a-9a=6; 9a-10a=4; 10a-11a=2p=9; 2p-3p=6; 3p-4p=5; 4p-5p=5.Their company policy is that ftake a lunch break at 11:00 for one hour.All other employees mupart-time shifts then are: 8a-12p, 9a-1p, 10a-2p, 11a-3p, 12p-4p,not want to hire any more people than is necessary.Determine thshift need to be hired to minimize the number of employees.A. Set up and solve the problem to minimize the number of emploB. Set up and complete a one-way SolverTable.Change the numfrom 8a-9a from 6 to 10 to see the impact on the number of FT emof employees.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
NoProfessor
Tags
12 000, Full time, 10 000, 8 000, YEEs