Please do all parts

selow is the Sensitivity Report from the Excel Solver work used in question 9; Variable Cells Cell 5855 Job 1 Hours 58s6 Job 2 Hours 5857 Job 3 Hours Final Reduced Onjective Aloewable Alowable Ve Cost Coefficient ecrease Decreae 5 1+30 3JE+30 10 13 25 IE 30 Constraints Cell 58510 Job 1 Hours 10 58511 Job 2 Hours c 20 SBS12 Job 2 Hours+ Job 3 Hours 3o Final Shadow Constraint Allowable Allowable Value Price R.H Side Increase Decrease 20 25 20 1E 30 0 1E 30 3s 2 25 58513 Total Hours Masimum 35 25 a) How much of changed in the optimal solution? a raise would be needed at Job 2 so that the final values of the decision variables would be b) If the student was willing to increase the increase for each additional hour? Total Hours Maximum constraint, how much would income c) If the student was willing to increase the 'Job 2 Hours 20 constraint, how much would income increase for each additional hour? d) if the Right Hand Side value of the '3ob 1 Hours >e 10 constraint was changed from 10 to 15, what would be the change in income? e) How should you treat the value E.30 when seen on a Sensitivity Report? selow is the Sensitivity Report from the Excel Solver work used in question 9; Variable Cells Cell 5855 Job 1 Hours 58s6 Job 2 Hours 5857 Job 3 Hours Final Reduced Onjective Aloewable Alowable Ve Cost Coefficient ecrease Decreae 5 1+30 3JE+30 10 13 25 IE 30 Constraints Cell 58510 Job 1 Hours 10 58511 Job 2 Hours c 20 SBS12 Job 2 Hours+ Job 3 Hours 3o Final Shadow Constraint Allowable Allowable Value Price R.H Side Increase Decrease 20 25 20 1E 30 0 1E 30 3s 2 25 58513 Total Hours Masimum 35 25 a) How much of changed in the optimal solution? a raise would be needed at Job 2 so that the final values of the decision variables would be b) If the student was willing to increase the increase for each additional hour? Total Hours Maximum constraint, how much would income c) If the student was willing to increase the 'Job 2 Hours 20 constraint, how much would income increase for each additional hour? d) if the Right Hand Side value of the '3ob 1 Hours >e 10 constraint was changed from 10 to 15, what would be the change in income? e) How should you treat the value E.30 when seen on a Sensitivity Report