undefined

A small shipping company sends engines to two different plants, determining the amount they send based on demand from the plants, shipping space restrictions, and rebate requirements. Their goal is to minimize costs. Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient increase Decrease $B$12 #Engines to P1 62 0 20 32.5 20 $B$13 N Engines to P2 27 0 35 1+30 21.66666667 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SESC Plant 1 Demand Usage 62 0 50 12 1E+30 SES? Plant 2 Demand Usage 27 21.66666667 27 18 27 SE$8 Shipping Restrictions Usage 80 0 105 15:30 16 SE$9 Rebate Requirements User 1200 1.333333333 1200 240 180 How much will it cost the company to send engines to plants 1 and 2 in the optimal scenario above? O $1.440 O $5.500 O $1,378 O $2,185 A small shipping company sends engines to two different plants, determining the amount they send based on demand from the plants, shipping space restrictions, and rebate requirements. Their goal is to minimize costs. Variable Cells Final Value Cell Name 56512 W Engines to P1 - $&$13 Engines to P2 Reduced Cost 0 0 Objective Allowable Allowable Coefficient increase Decrease 20 32.520 1E+30 21.06666667 27 Constraints Name SE$6 Plant Demand Usage SE$7 Plant 2 Dentand Usage SESB Shipping Restrictions Usage SES9 Rebate Requirements Ussee Final Shadow Value Price 0 27 21.66666667 89 1200 1.333333333 Constraint Allowable RH. Side Increase 50 12 27 105 17:30 1200 240 Allowable Decrease 1E-30 - 27 16 180 What is the least amount that it could cost to ship engines to plant 2 before the optimal solution would change? $8.00 O $13.33 O $12.50 O $5.33 A small shipping comparty sends engines to two different plants, determining the amount they send based on demand from the plants, shipping space restrictions, and rebate requirements. Their goal is to minimize costs, Varices Final Value Cell Name $E$17 Frigines to PI $E$13 A Engines to P2 Reduced Cout 0 Objective Aliwale Allowate Coatfident increase 30 12.5 1+30 7 27 Centre Cell Name $L$O Plant 1 Demande SES? Pt2 Demand Usage SES8 Shipping Restions Usap SES9 Reste Requirements Final Shadow Constraint Alowable Allowable Vale Price RM. Side Increase Decrease 62 0 SU 32 1430 27 2166667 18 22 89 0 105 15:30 10 15 1200 1111111133 1200 240 180 The constraint for Plant 2 Demand Usage tells us that the shipping company should send at least 27 engines to plant 2. What does the shadow price for this constraint mean? The company has the potential to earn $21.67 in profit from each additional engine they send to plant 2 The company has the potential to save $21.67 per engine if they reduce the minimum number of engines needing to be sent to plant 2. The company did not meet their requirements for plant 2, only sending 21.57 engines to plant 2 rather than 27 engines. The company can send 21.67 more engines to plant 2 without changing their total costs. | A small shipping company sends engines to two different plants, determining the amount they send based on demand from the plants, shipping space restrictions, and rebate requirements. Their goal is to minimize costs. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cout Coefficient increase Decrease $B$12 8 Engines to PI 0 20 32.5 20 $B$13 Engines to P2 - 27 0 35 1E+30 21.66666667 62 Contraints Cel Name SES Plant 1 Demand Us SE57 Plant 2 Demand USA SES8 Shipping Restrictions SESO Reba Rumah Final Shadow Valve Price 62 0 27 21.66666667 80 0 1200 1.33333333 Constraint Allowable R.H. Side Increase SO 12 27 18 105 1E +30 1200 240 Allowable Decrease 1E +30 27 16 180 For what values of Rebate Requirements Usage does the given shadow price of $1.33 remain valid? 180 to 240 0 to 1200 O 1020 to 1440 1200 to 1440