Get your original paper written from scratch starting at just $10 per page with a plagiarism report and free revisions included!
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.
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
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
The aim of our service is to provide you with top-class essay help when you ask us to write my paper; we do not collect or share any of your personal data. We use the email you provide us to send you drafts, final papers, and the occasional promotion and discount code, but that’s it!Order Now