- B 15 Points Suppose You Set Up The Lp Model In Excel And Here Is The Result Of The Sensitivity Report Variable Cells 1 (241.66 KiB) Viewed 33 times
day you can purchase at most 150L of fresh milk. To make 1L of
vanilla yogurt, you need exactly 0.75L of fresh milk. To make 1L of
blueberry yogurt, you need exactly 0.5L of fresh milk. Vanilla
yogurt sells for $150/L, and blueberry yogurt sells for $180/L.
You have committed to selling 30L of vanilla yogurt and 15L of
blueberry yogurt to NYU. Your yogurt is popular in the market and
current demand far exceeeds your production capacity. Any yogurt
produced beyond the above requirements can be sold at your own
yogurt store.
You want to maximize your revenue. You construct a LP and use
Solver to find the optimal solution.
a. Write down the linear program to determine the optimal
production plan
question b is shown in the pic
c. Suppose you want to make the blueberry flavor as a
limited edition product. You decide that at most 20% of all yogurt
sold in total are in blueberry flavor. Write a constraint to
reflect this restriction on your production mix.
b. (15 points) Suppose you set up the LP model in Excel and here is the result of the sensitivity report: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 vanilla yogurt x1 30 0 150 120 1E+30 $C$3 blueberry yogurt x2 255 0 180 1E+30 80 Constraints Cell Name $D$8 Fresh Milk LHS $D$9 Supply 1 LHS $D$10 Supply 2 LHS Final Value 150 30 255 Shadow Price 360 -120 0 Constraint Allowable Allowable R.H. Side Increase Decrease 150 1E+30 120 30 160 30 15 240 1E+30 i. ii. iii. What will the production plan and revenue become if the revenue of vanilla yogurt is $160/L, instead of $150/L? Do you detect the existence of multiple optimal solutions? Suppose you find a new freah milk supplier who can provides additional 100L of fresh milk every day. How will this change the optimal revenue?