use excel solver Question $1$

A company manufactures three components for vintage stereo systems: turntables, tape decks, and CD

players. The sale price and the manufacturing cost of each item is shown in the table below.

The sales department has indicated that it ca sell up to$,$ but not more than, $150,000$ turntables, $100,000$

tape decks, and $90,000$ CD Players. They also know that they will need at least $50,000$ of each device.

Assuming that you only have $450,000$ hours of available assembly time, how many of each type of unit

should you build to maximize profits and meet minimum demand?