Question: Problem 9 Time Period Tellers Needed 9-10 10 10-11 12 11-12 14 Mexico City Bank of Commerce is open from 9 am to 5 pm

Problem 9 Time Period Tellers Needed 9-10 10

Problem 9 Time Period Tellers Needed 9-10 10 10-11 12 11-12 14 Mexico City Bank of Commerce is open from 9 am to 5 pm and needs the number of tellers in the table to the right at various hours of the day: They would like to know the staffing schedule that minimizes costs. They can use a mix of full timers and part timers. Full timers work from 9 to 5. The full timers can take a lunch break either from 12-1 or from 1-2 and they can be split between the two in any way that the bank wants.. Part timers work 4 hour schedules (without break) and can start at any hour but must work 4 consecutive hours. Part timers cost $40 day per 4-hour day and full timers earn $70 per day. Formulate a linear program to produce the optimal schedule that minimizes cost. Solve the problem using Solver. 12-1 12 1-2 13 2-3 17 3-4 15 4-5 10

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!