Formulate the LP model for the product mixing problem discussed in class today and solve it using either AMPL or EXCEL SOLVER.

( SCREENSHOT)

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 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