Question: please answer this question fully and in detail show all steps neatly. Scenario Question 2 (10 Pointa): Marco City Bank of Commerce and Industry a
please answer this question fully and in detail show all steps neatly.
Scenario Question 2 (10 Pointa): Marco City Bank of Commerce and Industry a busy bank that has requirements de beteren 70 und 18 salers depending on the time of day. Lunchme, from noon to 2:00 PM, usually heaviest. The following table indicate the workers needed svartous hours that the banks open Time Period Time Period Number of The Required fo 1122 Number of Tees Recured 18 9:00 AM-10:00 AM 10.00 AM 11 00 AM 100 AM 11:00 PM-200 PM P2.00 PM 3:00 PM 117 14 OPM 400 PU 15 Noon: 1:00 PM 16 -00 PM 5:00 PM 10 The bank now employs 12 full-time taiers but many people are on its roster of available parime employees. A pan-time employers pointy 4 hour per day but can start anytime between 9 AM and 1PM Part-timers are a fully inexpensive labor pool because no retirement or ich benefits are provided sem unnecher hand, work from DAM SPM but are alowed 1 hour for lunch (Half the full-timers eat at 11 AM the other half at noon) Ful-imers thus provided 35 hours per week of producte abortime By corporate policy the bank mito part-time hours to a maximum of 60% of the day total requirement. Part-timers can s per hour or per day) average, whereas full-timers can $75 per day in salary and benets on average The benk would like to schedule, using LP that would minines total marpower costs. It will for more of a new profitable to do so We can het Fumetti P1-part-timers starting at 9 AM (aving at 1 PM) P2-part-timers starting at 10AM. Deaving art2PM) P3-part-timers staring at 11 AM (eaving at 3PM) Perpart-timers staring at noon leaving at 4PM) PS part-timers staring at 1 PM leaving at 5PM.) Porta (points) Write down the Objective Function Part b 2 points). Write down the constraint for the time period 9 AM to 10 AM Parte 12 points) Write down the constraint for Part time worker Hours carnal words of tot ourqind each day that we were echowy Part 2 points). Based on the Excel Solver Answer Report below. How many Full-time workers are hired? And what is the optimal cost? Parte 2 points). The Shadow Price for the RH. Side Constraint of RAM to noon is 50, which alowable increase of and allowable decrease of 2. How to interpretit 7 Solution Time: 90209846.464 Seconde # Iteration 12 Subproblem: Solver Option 10 Man Time Unlimited, iterations Unlimited, Precision E-06 Max Subproblems Unlimited, Max integer Solis Unlimited, meger Tolerance 2, Solve without integer Constraints, Assume Norliegative 12 1 14 Objective Call (MI) 15 Name Original Value Final Value 16 $B$17 Objective 1086 Gul Original Value 0 0 0 Final Vale Integer 10 Conti Contin 7 Cortin 2 Contin 5 Con Conti 0 18 19 Variable Calls 20 Cell Name 21 $853F 22 5053 23 $D$ 32 24 SES3 PB 25 ST$3N 26 $G$3 PS 27 23 29 Constraints 30 Call Name 11 $B$10 F 2 58511 33 $B$12 14 $0$13 35 $B$14 36 $B$15 F 32 $856 Constraints 38 $B$7F 39 SBSHF S859 Call Value Formula Status Slack 24 $B$10-$0$10 Not Binding 17 5851150$11 Binding o 15 58$12$0$12 Binding 10 $B$1350$13 binding 0 10 $B$4:$0$14 Not Binding 2 56 $B$150-50515 Binding 0 10 $8565056 Binding 0 17 58$75057 Not Bindir 5 14 $BSD5058 Binding 0 19 500 Not Binding Scenario Question 2 (10 Pointa): Marco City Bank of Commerce and Industry a busy bank that has requirements de beteren 70 und 18 salers depending on the time of day. Lunchme, from noon to 2:00 PM, usually heaviest. The following table indicate the workers needed svartous hours that the banks open Time Period Time Period Number of The Required fo 1122 Number of Tees Recured 18 9:00 AM-10:00 AM 10.00 AM 11 00 AM 100 AM 11:00 PM-200 PM P2.00 PM 3:00 PM 117 14 OPM 400 PU 15 Noon: 1:00 PM 16 -00 PM 5:00 PM 10 The bank now employs 12 full-time taiers but many people are on its roster of available parime employees. A pan-time employers pointy 4 hour per day but can start anytime between 9 AM and 1PM Part-timers are a fully inexpensive labor pool because no retirement or ich benefits are provided sem unnecher hand, work from DAM SPM but are alowed 1 hour for lunch (Half the full-timers eat at 11 AM the other half at noon) Ful-imers thus provided 35 hours per week of producte abortime By corporate policy the bank mito part-time hours to a maximum of 60% of the day total requirement. Part-timers can s per hour or per day) average, whereas full-timers can $75 per day in salary and benets on average The benk would like to schedule, using LP that would minines total marpower costs. It will for more of a new profitable to do so We can het Fumetti P1-part-timers starting at 9 AM (aving at 1 PM) P2-part-timers starting at 10AM. Deaving art2PM) P3-part-timers staring at 11 AM (eaving at 3PM) Perpart-timers staring at noon leaving at 4PM) PS part-timers staring at 1 PM leaving at 5PM.) Porta (points) Write down the Objective Function Part b 2 points). Write down the constraint for the time period 9 AM to 10 AM Parte 12 points) Write down the constraint for Part time worker Hours carnal words of tot ourqind each day that we were echowy Part 2 points). Based on the Excel Solver Answer Report below. How many Full-time workers are hired? And what is the optimal cost? Parte 2 points). The Shadow Price for the RH. Side Constraint of RAM to noon is 50, which alowable increase of and allowable decrease of 2. How to interpretit 7 Solution Time: 90209846.464 Seconde # Iteration 12 Subproblem: Solver Option 10 Man Time Unlimited, iterations Unlimited, Precision E-06 Max Subproblems Unlimited, Max integer Solis Unlimited, meger Tolerance 2, Solve without integer Constraints, Assume Norliegative 12 1 14 Objective Call (MI) 15 Name Original Value Final Value 16 $B$17 Objective 1086 Gul Original Value 0 0 0 Final Vale Integer 10 Conti Contin 7 Cortin 2 Contin 5 Con Conti 0 18 19 Variable Calls 20 Cell Name 21 $853F 22 5053 23 $D$ 32 24 SES3 PB 25 ST$3N 26 $G$3 PS 27 23 29 Constraints 30 Call Name 11 $B$10 F 2 58511 33 $B$12 14 $0$13 35 $B$14 36 $B$15 F 32 $856 Constraints 38 $B$7F 39 SBSHF S859 Call Value Formula Status Slack 24 $B$10-$0$10 Not Binding 17 5851150$11 Binding o 15 58$12$0$12 Binding 10 $B$1350$13 binding 0 10 $B$4:$0$14 Not Binding 2 56 $B$150-50515 Binding 0 10 $8565056 Binding 0 17 58$75057 Not Bindir 5 14 $BSD5058 Binding 0 19 500 Not Binding
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
