Scribd
Upload
6 views3 pages

Optimal Product Mix for TVs and Stereos

Uploaded by

carnellzhou1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views3 pages

Optimal Product Mix for TVs and Stereos

Uploaded by

carnellzhou1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Example: 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 pro5table mix of products to build. See our Tutorial Online
for step-by-step instruc*ons on formula*ng this linear programming model.

TV Set Stereo Speaker


100 100 100
Part Name Inventory No. Used
Chassis 450 200 1 1 0
Picture Tube 250 100 1 0 0
Speaker Cone 800 500 2 2 1
Power Supply 450 200 1 1 0
Electronics 600 400 2 1 1
Pro5ts:
By Product $75 $50 $35
Total 16000

To 5nd the op*mal solu*on click the Run bu>on in the upper right of the Add-in.
The op*mal solu*on will appear within the worksheet. Press the Reports bu>on to generate an Answer and Sensi*v
The reports will be added as new worksheets in your workbook.
o generate an Answer and Sensi*vity report.

You might also like