Question: The bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operation of the bank,

The bank is working to develop an efficient workThe bank is working to develop an efficient workThe bank is working to develop an efficient workThe bank is working to develop an efficient workThe bank is working to develop an efficient workThe bank is working to develop an efficient work

The bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operation of the bank, including adequate customer serv 9:00 A.M. to 7:00 P.M. The number of tellers necessary to provide adequate customer service during each hour of operation is summarized here. Time No. of Tellers Time | 9:00 a.m.-10:00 a.m. | 0 6 10:00 a.m.-11:00 a.m. No. of Tellers 2:00 p.m.-3:00 p.m. 3:00 p.m.-4:00 p.m. 4:00 p.m.-5:00 p.m. 5:00 p.m.-6:00 p.m. 0 11:00 a.m.-Noon 0 Noon-1:00 p.m. N 1:00 p.m.-2:00 p.m. 11 6:00 p.m.-7:00 p.m. + Formulate an integer programming model that can be used to develop a schedule that will satisfy customer service needs at a minimum employee cost. (Hint: Let xi = number of full-time en number of part-time employees coming on duty at the beginning of hour j.) If your answer is zero enter "O" and if the constant is "1" it must be entered in the box. Min + ygt + + X10 + + + Y10 + 911 + Y12 + + Y1 + sit + + + + + *10 + X11 + + X9 + yg + Y10 + Y11 + Y12 - Select + Y1 + Ixto + + + + X11 + + X9 + Jyio + + Y11 + Y12 + | - Select + Yi + + + + + + + X9 + X11 + + Y11 + + Yi + - Select AAAA + + + + + + X9 X11 + + Y11 + + Y12 + Yi + - Select + + + + + + + X11 + X9 + V11 + + Y12 + Yi + - Select + + + + + X9 + + + X11 + Y11 + Y12 + - Select Y1 + + + + + + + + X9 + + X11 + Y11 + Y12 + + Yi + - Select + + + + X10 + + + Y10 + Y11 + Y12 + - Select Yi + + + + + + + xa X10 + X11 + Y10 + Y11 + + Y12 + + Yi + - Select + + + + + X9 + + X10 + X11 Y10 + + Y11 + Y12 + Y1 + - Select Xi, Y; 2 0 and integer for i = 9, 10, 11 and j = 9, 10, 11, 12, 1, 2, 3 3 - Select your answer - Time (9:00 a.m.-10:00 a.m.) 5 ( - Select your answer - 4 Time (10:00 a.m.-11:00 a.m.) 3 - Select your answer - Time (11:00 a.m.-Noon.) - Select your answer - Time (Noon.-1:00 p.m.) - Select your answer - 4 Time (1:00 p.m.-2:00 p.m.) 5 ( - Select your answer - 4 Time (2:00 p.m.-3:00 p.m.) 5 ( - Select your answer - Time (3:00 p.m.-4:00 p.m.) 5 ( - Select your answer - Time (4:00 p.m.-5:00 p.m.) Time (5:00 p.m.-6:00 p.m.) 5 ( - Select your answer - 5 ( - Select your answer - Time (6:00 p.m.-7:00 (b) Solve the LP Relaxation of your model in part (a). If required, round your answers to the nearest whole number. If your answer is zero enter "0". X9 X10 X 11 y9 Y10 Y11 Y12 Y3 Total Cost: $ (c) Solve for the optimal schedule of tellers. If your answer is zero enter "O". No. of Full-time No. of Part-time employees employees Time 9:00 a.m.-10:00 a.m. 10:00 a.m.-11:00 a.m. 11:00 a.m.-Noon Noon1:00 p.m. 1:00 p.m.-2:00 p.m. 2:00 p.m.-3:00 p.m. 3:00 p.m.-4:00 p.m. 4:00 p.m.-5:00 p.m. 5:00 p.m.-6:00 p.m. 6:00 p.m.-7:00 p.m. Comment on the solution. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (d) After reviewing the solution to part (c), the bank manager realized that some additional requirements must be specified. Specifically, she wants to ensure that one full-time employee is employees. Revise your model to incorporate these additional requirements, and solve for the optimal solution. The new optimal solution is as follows: No. of Full-time No. of Part-time employees employees Time 9:00 a.m.-10:00 a.m. 10:00 a.m.-11:00 a.m. 11:00 a.m.-Noon Noon-1:00 p.m. 1:00 p.m.-2:00 p.m. 2:00 p.m.-3:00 p.m. 3:00 p.m.-4:00 p.m. 4:00 p.m.-5:00 p.m. 5:00 p.m.-6:00 p.m. 6:00 p.m.-7:00 p.m. Total Cost: $

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!