Product mix problem

Your company manufactures TVs, stereos and speakers, using a common parts inventory
of power supplies, speaker cones, etc. Parts are in limited supply and you must determine
the most profitable mix of products to build.

			TV set	Stereo	Speaker
	Number to Build->		0	0	0
Part Name	Inventory	No. Used
Chassis	450	0	1	1	0
Picture Tube	250	0	1	0	0
Speaker Cone	800	0	2	2	1
Power Supply	450	0	1	1	0
Electronics	600	0	2	1	1
			Profits:
		By Product	$0	$0	$0
		Total	$0


Problem
Your company builds TVs, stereos and speakers, using a common parts inventory of power supplies,
speaker cones, etc. Parts are in limited supply. What is the best combination of products to build
that maximizes profit?

Solution
1) The variables are clearly the number of TVs, stereos and speakers to build. In this worksheet, they
are given the name Number_to_build.
2) The constraints specify that the number of parts used cannot exceed the supply. This leads to
	Number_used <= Number_available
There is also the logical constraint
	Number_to_build >= 0 via the Assume Non-Negative option
3) The objective is to maximize profit. In the ProductMix worksheet this is defined as Total_profit.

Remarks
Although this is a good example of a product mix problem, bear in mind the limitations of the
model. For example, market demand and price elasticity is not included in the model -- we assume
that it doesn't matter how many TVs we build, we will always be able to sell them. Nor are there any
pre-specified minimum or maximum of products that need to be made. The effect of introducing
these restrictions can be studied by examining a Sensitivity Report, which you can select from the
dialog appears with the message 'Solver found a solution.'

Product mix problem

We're Here to Help