LP Problem 2

Two products are made by blending three raw materials according to these specifications:

	Material			Price/Pound
Product
	1	2	3
A	10%	30%	80%	$12.00
B	30%	20%	60%	$15.00
Matl Avail	4000	6000	10,000
Matl Cost	$3.00	$2.00	$1.00

All manufacturing costs, other than material, are assumed to be $2.00 per pound regardless of the product or blend. Determine the blend to use for each product and the quantities of each to produce each week to obtain maximum profits.

Questions:

Many business situations call for us to make the best decisions on how to use limited resources. Linear Programming can often provide the solution

1. Write the standard problem formulation
2. Solve the problem using Excel
3. Analyze the results
4. Describe a practical way of achieving more, if it was needed, along with your rationale for that particular choice
5. Document 2a-2d in a Microsoft Word file, showing all relevant detail