Explore BrainMass

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

    Solution Summary

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