Question: PROBLEM A 1. Refer to the Product-Mix Problem (Juice Problem) that we discussed in the first lecture. Both the mathematical formulation and the Excel Solver
PROBLEM A 1. Refer to the Product-Mix Problem (Juice Problem) that we discussed in the first lecture. Both the mathematical formulation and the Excel Solver solution to that problem are posted on iLearn. Now assume that the products are produced in one-gallon containers instead. All other parameters of the problem stay the same except the retail price for each type of product, given in Table 1 below: Product Retail Price Per Gallon Orange Juice $3.00 Grapefruit juice $2.70 Pineapple juice $2.40 All-in-One $3.30 Table 1: Retail price for each juice product sold in gallon size containers. Please note that the retail price of the new gallon-size products is three times the price of the old quart-size products. The cost per gallon of each type of juice however stays the same. Do you expect to make more profit or less profit? Explain your answer without re-solving the problem. This step allows you to do some sanity check on the optimal solution that you will obtain later on, using Excel Solver.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
