QUESTION 3: Sensitivity Analysis (24 points) The Excel spreadsheet formulation and Solver output to Question 2 is provided below: Solution Cost per person Trained Trained Trained Trained tec Inicine teclmicians tecimicia tec Inicians Trainees Trainee Trainee T mainees available at available at available available trained in trained trained trained start of start of at start of at start of March in April in May in June March April Max June Si S3 S4 TI T2 T3 14 35000 346.15 328.85 384 62 13.65 0.00 72 21 0.00 Total 4000 4000 4000 4000 20001 2000 2000 2000 S 5,810,192.31 LHS 130 -90 44271. 1540000 130 90 45000.00 45000 130 -90 36250.96 > 35000 1301 50000.00 50000 350.00 - 350 -095 0.00= -0.93 0.00 -0.95 RHS Staffing needs in March Staffine needs in April Staffing needs in May Staffing needs in June Woricforce balance in March Workforce balance in April Workforce balance in Max Workforce balance in Jun a od QUESTION 3: Sensitivity Analysis (24 points) The Excel spreadsheet formulation and Solver output to Question 2 is provided below: Solution Cost per person Trained Trained Trained Trained tec Inicine teclmicians tecimicia tec Inicians Trainees Trainee Trainee T mainees available at available at available available trained in trained trained trained start of start of at start of at start of March in April in May in June March April Max June Si S3 S4 TI T2 T3 14 35000 346.15 328.85 384 62 13.65 0.00 72 21 0.00 Total 4000 4000 4000 4000 20001 2000 2000 2000 S 5,810,192.31 LHS 130 -90 44271. 1540000 130 90 45000.00 45000 130 -90 36250.96 > 35000 1301 50000.00 50000 350.00 - 350 -095 0.00= -0.93 0.00 -0.95 RHS Staffing needs in March Staffine needs in April Staffing needs in May Staffing needs in June Woricforce balance in March Workforce balance in April Workforce balance in Max Workforce balance in Jun a od