please solve it on page

solve part 2a

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 280Question 2a What is the total cost of producing and transporting the sauce? Burger 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