Computer Assignment #$3$: Spartan Glory Tire LP Problem

$$Use SO VER in Excel to solve the Spartan Glory Tire Linear$$Programming Problem

$$What is the optimal plan for tire production? $($Provide the solution values of the decision variables.$)$ What is the Total Cost of this plan?

$$One of the workers is planning to take $100$ hours of unpaid vacation I April. What would be the impact on the objective function value $($Total Cost$)$ if his vacation plan is approved? $($Use sensitivity analysis to determine. Show your work.$)$

$$Instead of taking the vacation in April, the worker in question #$3$ wants to take his vacation in June. What is the impact on the objective function value $($Total Cost$)$ if his vacation is approved for June?

$$The time it takes to assemble an Invincible tire will increase from $1\mathrm{.}5$hours to $1\mathrm{.}64$ hours beginning in June due to a re$-$engineering of the assembly process causing an increase in the per unit production cost of the tire from $$8\mathrm{.}25(1\mathrm{.}5$ hrs$.$ x $$5\mathrm{.}50)$ to approximately $$9\mathrm{.}00.$ What effect, if any, will this have on the objective function value