PLEASE LET ME KNOW IF THE WORK I DID WAS RIGHT. PLEASE ANSWER THE ENTIRE ASSIGNMENT USING YOUR OWN WORK SO I CAN COMPARE AGAINST MINE.

Computer Assignment #3: Spartan Glory Tire LP Problem (1) Use SOLVER in Excel to solve the Spartan Glory Tire Linear Programming Problem (2) What is the optimal plan for tire production? (Provide the solution values of the decision variables.) What is the Total Cost of this plan? (3) One of the workers is planning to take 100 hours of unpaid vacation | 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.) (4) 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? (5) The time it takes to assemble an Invincible tire will increase from 1.5 hours to 1.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.25 (1.5 hrs. x $5.50) to approximately $9.00 . What effect, if any, will this have on the objective function value (Total Cost)? (THIS IS A CHALLENGE QUESTIONY!)