Notes_Lab_3

Notes_Lab_3 - Solver Example Product mix problem Your...

This preview shows pages 1–2. Sign up to view the full content.

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-> 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 \$75 \$50 \$35 Total \$0 This model provides data for several products using common parts, each with a different profit margin per unit. Parts are limited, so your problem is to determine the number of each product to build from the inventory on hand in order to maximize profits. Problem Specifications Target Cell D18 Goal is to maximize profit. Changing cells D9:F9 Units of each product to build. Constraints C11:C15<=B11:B15 Number of parts used must be less than or equal to the number of parts in inventory. D9:F9>=0

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 13

Notes_Lab_3 - Solver Example Product mix problem Your...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online