Purchase Solution

LPP:Blending problem

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.