apter 13 AssignmentXmHide FeedbackxxIncorrect8Icon Keyyo +xx9x10e to searchX10x10 +x10X10✪x10X10 +x10Xir yj 20 and integer for/= 9, 10, 11 and j = 9, 10, 11, 12, 1, 2, 3X10x₁1 +X**x11XxxProblem 13-15 Algo (Solving Integer Optimization Problems with Excel Solver)][va +(b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution.Total Cost: $ 950 ×vo +yg +yg +8***XX(c) Solve for the optimal schedule of tellers. Enter the total number of full-time and part-time employees required.If your answer is zero enter "0".Total Number of Full-Time Employees:Total Number of Part-Time Employees:J'*V10y10+VID +Y10y10+Y10y10y10y11|y11y12(99+12+V₁2+y12 +y12 +V₁2+y12y12+ +Ⓡyz*X*Xy3y3×X*13y33...p(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 on duty at all times and that there is a staff of at least four full-time employees. Revise your model to incorporate these additional requirements, andsolve for the optimal solution. Enter the total number of full-time and part-time employees required and the total cost under the revised optimal solution.If required, round your answers to the nearest whole number. If your answer is zero enter "0".Total Number of Full-Time Employees:Total Number of Part-Time Employees:Total Cost: $- Select your answer- Select your answerSelect your answer - V- Select your answerSelect your answer - V- Select your answer VSelect your answer - V- Select your answer - VSelect your answerVXX×X×X×XTime (10:00 a.m.-11:00 a.m.)Time (11:00 a.m.-Noon.)Time (Noon.-1:00 p.m.)Time (1:00 p.m.-2:00 p.m.)Time (2:00 p.m.-3:00 p.m.)Time (3:00 p.m.-4:00p.m.)Time (4:00 p.m.-5:00p.m.)Time (5:00 p.m.-6:00 p.m.)Time (6:00 p.m.-7:00 p.m.)ARD74°F Haze>SaveHint(s) Check My WorkQuestion 4 of 5Submit Assignment for Grading10:39 AM2/23/2023XA-ZبینA+(2) ons Problem 13-15 Algo (Solving Integer Optimization Problems with Excel Solver)The Northside Bank 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 service, employee breaks, and so on. On Fridays, the bank open from 9:00 A.M. to 7:00 P.M. The number of tellers necessary to provideadequate customer service during each hour of operation is summarized here.TimeTime9:00 a.m.-10:00 a.m.2:00 p.m.-3:00 p.m.10:00 a.m.-11:00 a.m.3:00 p.m.-4:00p.m.11:00 a.m.-Noon4:00 p.m.-5:00p.m.Noon-1:00 p.m.5:00 p.m.-6:00 p.m.1:00 p.m.-2:00 p.m.6:00 p.m.-7:00p.m.Each full-time employee starts on the hour and works a 4-hour shift, followed by a 1-hour break and then a 3-hour shift. Part-time employees work one 4-hour shift beginning on the hour. Considering salary and fringe benefits, full-time employees cost the bank $15 per hour ($105 a day), and part-time employees cost the bank $8 perhour ($32 per day).s.t.No. of Tellersx96yoOsearch57119*x10(a) 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 x = number of full-time employees coming on duty at the beginning of hour i and yj = number of part-time employees coming on duty at the beginning of hour j.)If your answer is zero enter "0" and if the constant is "1" it must be entered in the box.MinX10 +X✔x10×x10 +X10x10X10x10 +X10 +X10No. of TellersX10 +6*x117175*Yox11Xir yj z 0 and integer for i= 9, 10, 11 and j = 9, 10, 11, 12, 1, 2, 3x11 +ⓇX11x11 +yg +yg +y⁹(b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution.×Total Cost: $ 950y10y10y10+y10V10y10+y10y10+y10+y103y10+HH+(c) Solve for the optimal schedule of tellers. Enter the total number of full-time and part-time employees required.If your answer is zero enter "0".Total Number of Full-Time Employees:Total Number of Part-Time Employees:+y₁₁ +y₁1 +y₁₁ +y11 +99+y12y12 +y12 +y12 +V₁2+V₁2+y12y12 +12+y121X₂+y₁ +0√₂ +*√₂ +3y₂ +*v₂*v₂6y3y3y3 - Select your answerSelect your answer - VV3V3Select your answerSelect your answery3 - Select your answerV3- Select your answerSelect your answerY3V3V✓Select your answer - VSelect your answery3 - Select your answerVVXxXXXXXXXQuestion 4 of 5 ▸XHint(s) Check My WorkTime (9:00 a.m.-10:00 a.m.)Time (10:00 a.m.-11:00 a.m.)Time (11:00 a.m.-Noon.)Time (Noon.-1:00 p.m.)Time (1:00 p.m.-2:00 p.m.)Time (2:00 p.m.-3:00 p.m.)Time (3:00 p.m.-4:00 p.m.)Time (4:00 p.m.-5:00p.m.)Time (5:00 p.m.-6:00 p.m.)Time (6:00 p.m.-7:00p.m.)74°F Haze10:39 AM2/23/20232A-ZoبینO

39 m 29 x 10 Total Number of Full-Time Employees Total Number of Part-Time Employees 10 mo 10 10 Total Number of Full-Time Employees: Total Number of Part-Time Employees Ⓡ Total Cost - X10 X10 ya 0 and integer for 9, 10, 11 and/9, 10, 11, 12, 1, 2, 3 11 L Ⓡ (3 n ✪ no no b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution. Total Cost: 950 950 n9 10 yo yo Y10 10 y10 c) Solve for the optimal schedule of tellers. Enter the total number of full-time and part-time employees required. yo - Эл yil yil yuu yil ₁- y11 ₁² 12 y2₂ y12 y12 y12 ₁² 12 'n Ⓡ 'n . . . 'n 12 n n 'n 3. Ⓡ3₂ n n 3. -Select your answer - -Select your answer- -Select your answer -Select your answer Select your answer- -Select your answer Select your answer. -Select your answer Select your answer Ⓡ3 Ⓡ 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 on duty at all times and that there is a staff of at least four full-time employees. Revise your model to incorporate these additional requirements, and solve for the optimal solution. Enter the total number of full-time and part-time employees required and the total cost under the revised optimal solution. of required, round your answers to the nearest whole number of your answer is zero enter"0" Time (10:00am-11:00 am) Time (11:00 am/Noon.) Time (Noon-1:00p.m.) Time (1:00 pm-2:00p.m.) Time (2:00 pm-3:00p.m.) Time (3:00 pm.-4:00p.m.) Time (4:00 pm-5:00p.m.) Time (3:00 pm.-6:00p.m.) Time (6:00 pm-7:00p.m.)

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...