The Excel spreadsheet formulation and Solver output to Question 2 is provided below: 12 36 EF 2 Trained Tre Trumed Trained technicimus technicom technicim technici Trans Trime Trees Trees silable wil bleible slabe trained in trained tred tried Start of start of start of a sort of March April in Mime March M S 52 SU 1 TI Setter 3500 3455 338 35452 000 ood Tot 4 od pe Red and 55.810,1923 LHS RO Sonne in Nage 230 4271.1540000 Sais 45000 3500 Being red JER Sa 50000 50000 Warfarce lance in March 550 0.00 Whe Wordable 0.00 Microsoft Excel Answer Report Objective Cell (Min) Original Cell Name Value Final Value 36250350 3 Stod 0.00 $ SISS Cost per person Total Variable Cells 55 810.192.31 Cell Name 5854 Solution 1 5054 Solution 2 SD54 Solution 3 SES4 Solutions SE54 Solution 5554 Bolution SHA Solutions SISA Solution Con Cell Nam Worverein Mare SIS2 LHS Sworforce AHS 534 Workforce in My 5195 Wardoccine- Original Value 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DO Final Value Integer 350.00 Contin 346.15 Contin 328.35 Contin 334 52Contin 12.55 Contin 0100 Contin 722Contin 0.00 Contin Ce Value Formula Status Slack 350 651552-51552 000 SI 1551 D5152451334 000 SISLES$15 0 Bins C d $$ Stance MLS Starting NO int 411 15 55155 9000 550 Sise 423115 3.00 NE Soni May SISSA 1635053.0 30000052511 25036 000 Microsoft Excel Sensitivity Report Cell Name $B$4 Solution S1 SCS4 Solution S2 $D$4 Solution S3 SES4 Solution S4 SF$4 Solution T1 $G$4 Solution T2 SH$4 Solution T3 $1$4 Solution T4 Final Value 350.00 346.15 328.85 38462 13.65 0.00 Reduced Cost 0.00 0.00 0.00 0.00 0.00 9635.00 0.00 6153.85 Objective Allowable Allowable Coefficient Increase Decrease 4000 1E+30 1E+30 4000 1E-30 7995.00 4000 1E+30 5812.30 4000 1E+30 6000.00 2000 1E+30 7995.00 2000 9635.00 2000 6118:21 6000.00 2000 6153.85 72.21 0.00 Constraints Cell Name $J$12 Workforce balance in March LHS 51513 Workforce balance in April LHS $J$14 Workforce balance in May LHS $I$15 Workforce balance in June LHS $J$8 Staffing needs in March LHS $1$9 Staffing needs in April LH5 $JS10 Staffing needs in May LHS SIS11 Staffing needs in June CHS Final Value 350.00 0.00 0.00 0.00 44271.15 45000.00 36250.95 50000.00 Shadow Price 2100 -2000 2100 -2000 0 61 50 Constraint Allowable Allowable R.H. Side Increase Decrease 350 14.37 19.82 0 13.65 47.46 0 76.01 5.80 0 72.21 13.90 40000 427115 IE-30 45000 6169.44 794.36 35000 1250 56 JE 30 50000 1806.94 9387.50 46.15 Answer all of the questions below. For the purpose of these questions assume that fractional values of decision variables make sense. Two decimal places accuracy is fine. Note that each question below is to be considered independently of all others, (a) What is the optimal value of the objective function and what are the optimal values of the decision variables? (3 points) b) If the salary cost to train a trainee during the month of May has increased to $3000, what would be the impact on the optimal solution and its cost? Justify points) (a) What the allowable increase for the anables T2 and T4, the cost to train a trainee during April and June (I have deleted these number from the table) Why? 4 points) (d) Power Generation Inc. has underestimated staffing needs in March by 2000 hours, thus staffing needs for March should have been 42.000 hours. What would be the impact on the optimal solution? Justify (3 points) e) As a result of successful sales efforts the staffing needs have increased in April to 48,000 hours. However, in June, it is expected to drop by 1000 hours resulting in a staffing needs of 49,000 hours in June. No other changes have occurred in the formulation. If you can determine what the new optimal value of the objective function is then do so explaining why your approach is correct. If you cannot determine the new optimal value of the objective function, explain why (6 points) Staffing needs in June have increased by 3000 to a value of 53.000. This is the only change in the formulation is the new optimal value of the objective function above or below $5.850,000 Defend your answer (points) objective