Explore BrainMass

# LPP:Blending problem

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

A drink company plans to make new drink consisiting of a mixture of fruit juice and soda:
each ounce of juice contains 0.25mg of sugar and 3mg of VitaminC and costs 3p to produce.
each ounce of soda contains 0.5mg of sugar and 1mg of Vitamin C and costs 1p to produce.
the drink is to be sold in 10 ounce bottles and must contain at least 10mg of Vitamin C and no more than 4mg of Sugar.

Calculate what mixture of the two ingredients will satisfy these constraints at minimum cost.

1. Model the problem as a linear programming problem. What are the constraints?
2. Use Excel's Solver to find the quantities of the two ingredients (in ounces).

© BrainMass Inc. brainmass.com June 3, 2020, 7:24 pm ad1c9bdddf
https://brainmass.com/statistics/general-linear-model/lpp-blending-problem-calculations-96911

#### Solution Summary

The expert examines LPP blending calculations. Excel solves are used to find the quantities of two ingredients.

\$2.19