Question: please solve 2b only Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$6 Factory A Store 1 240 0

 please solve 2b only Variable Cells Final Reduced Objective Allowable AllowableCell Name Value Cost Coefficient Increase Decrease $B$6 Factory A Store 1240 0 15 5 1E+30 $C$6 Factory A Store 2 200 -116 1 1E+30 $D$6 Factory A Store 3 60 0 18 2

please solve 2b only

$B$7 Factory B Store 1 0 5 22 1E+30 5 $C$7 FactoryB Store 2 160 O 19 1E+30 1 $D$7 Factory B Store3 60 0 20 1 2 Constraints Final Shadow Constraint Allowable AllowableCell Name Value Price R.H. Side Increase Decrease $B$8 Store 1 240

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$6 Factory A Store 1 240 0 15 5 1E+30 $C$6 Factory A Store 2 200 -1 16 1 1E+30 $D$6 Factory A Store 3 60 0 18 2 $B$7 Factory B Store 1 0 5 22 1E+30 5 $C$7 Factory B Store 2 160 O 19 1E+30 1 $D$7 Factory B Store 3 60 0 20 1 2 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$8 Store 1 240 17 240 60 60 $C$8 Store 2 360 19 360 280 160 $D$8 Store 3 120 20 120 140 60 $E$6 Factory A 500 -2 500 60 60 $E$7 Factory B 220 0 500 1E+30 280Burger Rush's new burger sauce now needs to be distributed to its stores. It has two factories, A and B, which supply its three stores (1, 2 and 3). Each factory can produce up to 500 litres of sauce per week, while the demands of the three stores are 240, 360, and 120 litres per week, respectively. The production cost of the sauce in factory A is $10 / litre, while in B the cost is $12 / litre. Furthermore, there are transport restrictions of 200 litres per week from factory A to store 2, and from factory B to store 3. Transportation costs are shown in the table below. $ / litre Store 1 Store 2 Store 3 Factory A 5 6 8 Factory B 10 7 8An Excel model has been formulated to find the least cost way of producing and transporting the sauce, while meeting the weekly demand. Output from this model is shown below. A B C D E F G Store 1 Store 2 Store 3 2 Factory A 15 16 18 3 Factory B 22 19 20 12120 4 5 Store 1 Store 2 Store 3 6 Factory A 240 200 60 500 500 7 Factory B 0 160 60 220

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 Economics Questions!