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?

Hint: Use the attached file – “FinalExam_Optimization_ScreenShot.jpg” – which will provide you clues on how to build the solution.

Solution

1) The variables are clearly the number of TVs, stereos and speakers to build. In your worksheet, they

should be given the name Number_to_build.

2) The constraints specify that the number of parts used cannot exceed the supply. This leads to

ORDER A PLAGIARISM FREE PAPER NOW

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 should be defined as Total_profit.

NEED THE COMPLETED EXCEL FILE TO SUBMIT THE ASSIGNMENT