The Northside Bank is working to develop an efficient work schedule for full-time and part-time tellers....
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ff52167f23_129664ff52106836.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ff5221c508_129664ff521b0546.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664ff522b7ac0_130664ff522585f5.jpg)
Transcribed Image Text:
The Northside Bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operat is open from 9:00 A.M. to 7:00 PM. The number of tellers necessary to provide adequate customer service during each hour of operation is summari Time No. of Tellers Time No. of Tellers 9:00 a.m.-10:00a.m. 2:00 p.m.-3:00 p.m. 8 10:00 a.m.-11:00a.m. 4 3:00 p.m.-4:00p.m. 5 11:00 a.m.-Noon 8 4:00 p.m.-5:00 p.m. 8 Noon-1:00 p.m. 9 5:00 p.m.-6:00 p.m. 6 1:00 p.m.-2:00 p.m. 8 6:00 p.m.-7:00 p.m. 7 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 o the bank $15 per hour ($105 a day), and part-time employees cost the bank $8 per hour ($32 per day). (a) Formulate an integer programming model that can be used to develop a schedule that will satisfy customer service needs at a minimum employe 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. Min x9 + x10 + X11 + y9+ V10 + Y11+ Y12+ y1 5.t. x9 + X10+ X11+ y9 + Y10+ Y11+ Y12+ Y x9 + x10 + X11+ y9+ Y10+ Y11 + Y12+ y1 x9 + x10 + X11+ y9+ Y10+ Y11 + Y12+ y1 x9 + x10 + X11+ y9+ Y10+ Y11+ Y12+ y1 x9 + x10+ X11 + y9+ Yto+ Y11+ Y12+ y1 E A Aug 18 12:38 0 Min your answer is zero enter "u" and if the constant is "I it must be entered in the box. x9 + x10+ *11+ s.t. y9+ Y10+ x9 + Y11+ X10+ Y12 + y X11+ y9+ Y10+ X9+ Y11 + x10 + Y12+1 *11 + yi yg + Y10+ x9 + Y11 + Y12+ x10 + 11 + yi 19+ Y10+ x9 + Y11 + x10 + Y12+1 *11 + y9+ Y10+ x9 + Y11+ x10 + Y12+ y1 *11+ y9+ Y10+ Y11+ x9 + x10 + Y12 + yi *11+ y9+ x9 + Yio+y11 + Y12+ X10+ X11+ y9+ Y10+ Y11+ x9 + Y12 + 10+ y *11+ y9+ Y10+ Y11 + X9+ Y12+ X10+ Y X11+ y9+ Y10+ Y11+ x9 + Y12+ *10+ 11+ yo + Y10+ x, yj z 0 and integer for 9, 10, 11 and 9, 10, 11, 12, 1, 2, 3 V11+ Y12+ y (b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution. Total Cost: $ (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: Assignment (b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution. Total Cost: $ (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: (d) After reviewing the solution to part (c), the bank manager realized that some additional requirements must be specified. Specifically, she wan time employees. Revise your model to incorporate these additional requirements, and solve for the optimal solution. Enter the total number of 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: $ Check My Work The Northside Bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operat is open from 9:00 A.M. to 7:00 PM. The number of tellers necessary to provide adequate customer service during each hour of operation is summari Time No. of Tellers Time No. of Tellers 9:00 a.m.-10:00a.m. 2:00 p.m.-3:00 p.m. 8 10:00 a.m.-11:00a.m. 4 3:00 p.m.-4:00p.m. 5 11:00 a.m.-Noon 8 4:00 p.m.-5:00 p.m. 8 Noon-1:00 p.m. 9 5:00 p.m.-6:00 p.m. 6 1:00 p.m.-2:00 p.m. 8 6:00 p.m.-7:00 p.m. 7 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 o the bank $15 per hour ($105 a day), and part-time employees cost the bank $8 per hour ($32 per day). (a) Formulate an integer programming model that can be used to develop a schedule that will satisfy customer service needs at a minimum employe 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. Min x9 + x10 + X11 + y9+ V10 + Y11+ Y12+ y1 5.t. x9 + X10+ X11+ y9 + Y10+ Y11+ Y12+ Y x9 + x10 + X11+ y9+ Y10+ Y11 + Y12+ y1 x9 + x10 + X11+ y9+ Y10+ Y11 + Y12+ y1 x9 + x10 + X11+ y9+ Y10+ Y11+ Y12+ y1 x9 + x10+ X11 + y9+ Yto+ Y11+ Y12+ y1 E A Aug 18 12:38 0 Min your answer is zero enter "u" and if the constant is "I it must be entered in the box. x9 + x10+ *11+ s.t. y9+ Y10+ x9 + Y11+ X10+ Y12 + y X11+ y9+ Y10+ X9+ Y11 + x10 + Y12+1 *11 + yi yg + Y10+ x9 + Y11 + Y12+ x10 + 11 + yi 19+ Y10+ x9 + Y11 + x10 + Y12+1 *11 + y9+ Y10+ x9 + Y11+ x10 + Y12+ y1 *11+ y9+ Y10+ Y11+ x9 + x10 + Y12 + yi *11+ y9+ x9 + Yio+y11 + Y12+ X10+ X11+ y9+ Y10+ Y11+ x9 + Y12 + 10+ y *11+ y9+ Y10+ Y11 + X9+ Y12+ X10+ Y X11+ y9+ Y10+ Y11+ x9 + Y12+ *10+ 11+ yo + Y10+ x, yj z 0 and integer for 9, 10, 11 and 9, 10, 11, 12, 1, 2, 3 V11+ Y12+ y (b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution. Total Cost: $ (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: Assignment (b) Solve the LP Relaxation of your model in part (a). Enter the total cost value under the optimal solution. Total Cost: $ (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: (d) After reviewing the solution to part (c), the bank manager realized that some additional requirements must be specified. Specifically, she wan time employees. Revise your model to incorporate these additional requirements, and solve for the optimal solution. Enter the total number of 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: $ Check My Work
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Find each limit in Problems 3760. Note that LHpitals rule does not apply to every problem, and some problems will require more than one application of LHpitals rule. lim x 3 x + 3xx - 3 X x + 6x + 9
-
Consider a game with two players, 1 and 2. They play the extensive-form game summarized in the game tree below: a. Suppose Player 1 is choosing between the gray and black for his second move. Which...
-
Refer to the information given in Exercise 8-13. Assume that Pet-Care actually produced 120,000 bags of BasicDiet and 100,000 of SpecDiet. The actual overhead costs incurred were: Maintenance $...
-
State SAT scores. We want to compare the distributions of average SAT Math and Verbal scores for the states and the District of Columbia. We enter these data into a computer with the names SATM for...
-
Consider the following time series data: Using the nave method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b....
-
This year, its pension actuary informed Gear-It-Up Bicycles, Inc., that its required annual contribution to the company\ defined benefit pension plan needs to be significantly higher than last year.\...
-
The Metallica Heavy Metal Mining (MHMM) Corporation wants to diversify its operations. Some recent financial information for the company is shown here: 40 Stock price $ Number of 30,000 shares Total...
-
Based on the case, Insights Analytics: Technology for a Knowledge Management Program attached . Please explain all 8 points. Explanation of each point should be 300words . Please attach the reference...
-
When women were finally allowed to become pilots of fighter jets, engineers needed to redesign the ejection seats because they had been originally designed for men only. The ejection seats were...
-
What will be the output of the following code snippet? with open ("hello.txt", "w") as f: f.write("Hello World how are you today") with open('hello.txt', 'r') as f: data = f.readlines () for line in...
-
Assume that females have pulse rates that are normally distributed with a mean of p = 72.0 beats per minute and a standard deviation of o = 12.5 beats per minute. Complete parts (a) through (c)...
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
Adrian's communications business began as a one- person operation, but Adrian soon found that he had more work than he could do himself. Although it was not in his plan to hire any subcontractors...
-
In Exercises 1-2, rewrite each verbal statement as an equation. Then decide whether the statement is true or false. Justify your answer. 1. The logarithm of the difference of two numbers is equal to...
-
Jamie Lee has decided to purchase a certified, preowned vehicle. What might she expect as far as reliability and a warranty on the used car?
-
What daily spending items are amounts that might be reduced or eliminated to allow for higher savings amounts?
-
Jamie Lee is attracted to the low monthly payment advertised for a vehicle lease. She may well be able to afford a more expensive car than she originally thought. Jamie Lee really needs to think this...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App