please answer the below question step by step neatly and organized. plese also show the work.

Scenario Question 2 (10 Points): Mexico City Bank of Commerce and Industry is a busy bank that has requirements for between 10 and 18 tellers depending on the time of day. Lunctime, from noon to 2.00 P>M is usually heaviest. The following table indicate the workers needed at various hours that the bank is open Time Period Time Period Number of Tellers Required 10 Number of Tellers Required 18 900 AM - 10:00 AM 10:00 AM - 11:00 AM 12 17 1.00 PM -2.00 PM 2.00 PM-3:00 PM 3.00 PM -4.00 PM 4:00 PM 5:00 PM 11:00 AM -noon 14 15 Noon-1.00 PM 16 10 The bank now employs 12 full-time tellers but many people are on its roster of available part-time employees. A part-time employee must put in exactly 4 hour per day but can start anytime between 9 AM and 1PM Part-timers are a fairly inexpensive labor pool because no retirement or luch benefits are provided them. Full-timers on the other hand, work from 9 AM to 5 PM but are allowed 1 hour for lunch (Half the full-timers eat at 11 AM the other half at noon.) Full-timers thus provided 35 hours per week of productive labor time By corporate policy, the bank limits part-time hours to a maximum of 50% of the day's total requirement. Part-timers eam 56 per hour (or S24 per day) on average whereas full-timers earn $75 per day in salary and benefits on average The bank would like to set a schedule, using LP that would minimize its total manpower costs. It will release 1 or more of its full-time tollers If it is profitable to do so. We can let Fful-time tells P1-part-timers starting at 9 AM (leaving at 1 PM) P2-part-timers starting at 10 AM (leaving at 2 PM) P3-part-timers starting at 11 AM leaving at 3PM.) P4-part-timers starting at noon leaving at 6PM) P5-part-timers starting at 1 PM (leaving at 5PM) D H 7 Part a 2 points) Write down the Objective Function Part b 2 points) Write down the constraint for the time period 9 AM to 10 AM Parte 2 points) Write down the constraint for Part-time worker-hours cannot exceed 50% of total hours required each day (which is the sum of the tellers need each hour) Part d2 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 11 AM to noon is 50, which allowable increase of and allowable decrease of 3. How to interpret it AB c G Solution Time: 90209846.464 Seconds 3 Iterations: 12 Subproblems 9 Solver Options 10 Max Time Unlimited, iterations Unlimited, Precision 15-06 11 Max Subproblems Unlimited, Max Integer Sols Unlimited Integer Tolerance 1%, Solve Without integer Constraints, Assume NonNegative 12 13 14 Objective Cell Min) 15 Cell Name Original Value Final Value 16 $0$17 Objective 0 17 1086 RASAAROR 19 Variable Cells 20 Cell Name 21 $B$3 F 22 $C$3 P1 23 $D$3 P2 24 SES3 P3 25 $F$ 34 26 $G$3 PS Original Value Final Value Integer 0 10 Contin 0 O Contin 0 7 Contin 0 2 Contin 0 5 Contin 0 O Contin Name 29 Constraints 30 Cell 11 $B$10 F $B$11 F Cell Value Formula Status 24 $a$10-$D$10 Not Binding 17 $8$11>$D$11 Binding Slack 6 Original Value 0 0 0 0 0 0 Final Value Integer 10 Contin O Contin 7 Contin 2 Contin 5 Contin O Contin 19 Variable Cells 20 Cell Name 21 $B$3 F 22 $C$3 P1 23 $D$3 P2 24 $E$3 P3 25 $F$3 P4 26 $G$3 P5 27 28 29 Constraints 30 Cell Name 31 $B$10 F 32 $B$11 F 33 $B$12 F 34 $B$13 F 35 $B$14 F 36 $B$15 F 37 $B$6 Constraints F 38 $B$7 F 39 $B$8 F 40 $B$ 9F Cell Value Formula Status Slack 24 $B$10>=$D$10 Not Binding 6 17 $B$11>=$D$11 Binding 0 15 $B$12>=$D$12 Binding 0 10 $B$13>$D$13 Binding 0 10 $B$14=$D$6 Binding 0 17 $B$7>=$D$7 Not Binding 5 14 $B$8>=$D$8 Binding 0 19 $B$9>=$D$9 Not Binding 3 41