Question

2 sensitivity report of buying in a grocery store. coke, pepsi, Gatorade and water for the minimum possible cost requiring a minimum volume, weight, and number of bottles. Answer the questions below the output based on this report. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 Coke 1.20.181818182 $c$2 Pepsi 1E30 $D$2 Gatorade 1. 5 1E+30 $E$2 Water 0.50.333333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$4 Volume 401.379310345 $F$5 weight $F$6 bottles

Answer 1

13)
2 * 1.2 + 8*0.7 {sumproduct of final value * objective coefficient}
= 2.4 + 5.6
= 8

14)
coke = 2 {final value and row coke}

15)
water = 8

16)
gatorade = 0

Please give me a thumbs-up if this helps you out. Thank you! :)

By HOMEWORKLIB RULES, we have to answer only first 4 sub-parts in multiple sub-parts

Please post rest questions again as separate post if you want the solution to them too