Question: PLEASE ANSWER WITH WORK SHOWN AND EXCEL WORK SHOWN Computer Assignment #3: Spartan Glory Tire LP Problem (1) Use SOLVER in Excel to solve the

PLEASE ANSWER WITH WORK SHOWN AND EXCEL WORK SHOWN

PLEASE ANSWER WITH WORK SHOWN AND EXCEL WORK
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!)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!