Module 03 Lab Worksheet (2) [Compatibility Model Word RE HOME NSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW ADD-INS Follow these instructions to install a Solver Add-in to Microsoft Excel: rt office.com/en-us/article/Load-the-Solver Add-in-612926fc-d53b-46b4-872c. e24772 f078ca See the Additional Resources page for this Module for alternate spreadsheet programs and solvers) Optimization is the mathematical process of finding an ideal (optimal) solution to aresource- constrained problem. Let's look at an example: An electronics company produces three products: LCD TVs, Stereos and Speakers. Here is the breakdown of what parts are required to produce each product: Part Requirements by LCD TVs Part Name Stereos Speakers 1 1 0 Chassis 1 0 0 LCD Screen 2 1 Speakers 1 1 0 Power Supply 2 1 1 Electronics Here's what they have in inventory for each part Part Name Chassis 450 250 LCD Screen 8000 Speakers Power Supply 450 6000 Electronics PAGE 1 OF 2 260 woRDs E Jeff Hersey l's 4:03 PM 1211/2016