Formulate the LP model for the product mixing
problem discussed in class today and solve it using either
AMPL or EXCEL SOLVER.
Show transcribed image text
2. Product Mix Problem EX: A company makes 4 types of juice using orange, grapefruit, and pineapple. The following table shows the price and cost er quart of juice (one container of juice) as well as the no. of ilograms of fruits required to produce one quart of juice. Product Price/quartCostquart Fruit needed 1 Kg. 2 Kg. 1.25 Kg 0.25 Kg each Orange juice 3 Grapefruit juice Pineapple juice All -in – one 2 0.5 2.5 1.5 4 2 10