MANAGEMENT SCIENCE SENSITIVITY EXAMPLE: THE PLUTO AUTO COMPANY The Pluto auto company makes two models of their Zippy sport car, a Regular model and a Turbo model. The only difference between the two cars is their engines, all the rest of the parts for either car costs $10,000. The Zippy Regular sells for $15,000, the Zippy Turbo sells for $17,000. Pluto currently has 30 regular engines and 25 turbo engines in stock. Pluto can purchase additional regular engines for $2,000 and additional turbo engines for $3.400. The factory line can only assemble a total of 100 cars this month. Pluto already has orders for 50 Turbo models which must be filled. Given the formulation and Excel output below, answer the following independent questions. R: number of regular models to assemble and sell this month T: number of turbo models to assemble and sell this month RE: number of additional regular engines to buy this month TE: number of additional turbo engines to buy this month The linear programming model? 13050-(0600 /12000-10060 Mayimine ooo R + 2080T - 2000 RE - 3uo0 TE R -LELZO T-TELLS R+T Zoo T 250 R, T.RE, TE ZO2 . 1 How much will total profit change if the factory line becomes more efficient and can assemble 10 more cars this month ?\\ b. If only 40 previous orders for turbo models had to be filled , how much would total profit change ? C . Pluto is considering increasing the selling price for regular cars . At what minimum increased selling price would Pluto consider changing its production plan ? d . Pluto's quality control inspector has just found flaws in 5 of the 25 turbo engines on stock , which means that these 5 engines cannot be used . What will the total profit be under these conditions ?!Microsoft Excel Answer Report Target Cell ( Max ) Cell Name Original Value Final Value SG$3 Obj. ( max ) 487000 Adjustable Cells Cell Name Original Value Final Value SB$ 2 R 30 $ C$ 2 O 10 SD$ 2 RE O O SE$ 2 TE 45 Constraints Cell Name Cell Value Formula Status Slack $G$ 4 RE Stock 30 SG$ 4 = $187 Not Binding 20Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB$ 2 R 30 5000 600 1400 $C$ 2 I 70 O 7000 1400 500 $D$ 2 RE O - 600 - 2000 600 I E + 30 SE$2 TE 45 O - 3400 1400 600 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R. H . Side Increase Decrease SG$4 RE Stock 30 1400 30 20 30 SG$5 TE Stock 25 3400 25 45 I E + 30 SG$6 Capacity 100 3600 100 I E + 30 20 SG$7 T Orders 70 O 50 20 I E + 30