Given the tables provided . Help Coastal Accessories maximize profit by deciding what products to produce. the inventory represents the most they can buy for the per part price. they have a max demands listed. you can make fewer than the demand the same amount but not more than the max demand. The second graph depics what each product needs to be crafted. The assembly price is listed to make each product and what each product sells for. Use solver to help depict the maximum profit and highlight your inputs, outputs along with the objective cell and your constraints.

Coastal Accessories Insert Function name Monitor Headset 300 Party Speaker 350 400 products Max Demand Number of Parts Used LED Display Speaker Cone Power Supply Amplifier Electronics 1 2 1 2 2. 1 1 1 1 1 1 5 7 Product 3 Monitor 9 Headset 10 Party Speaker 11 12 13 Inventory 14 Part Cost 15 16 17 Selling Price 18 Assembly Cost 19 20 LED Display Speaker Cone Power Supply Amplifier Electronics 1,200 500 350 1,100 parts 90 $ 8 $ 15 $ 4 $ 5 per part 400 $ Monitor Headset $ 219 $ $ 35 $ Party Speaker 93 $ 39 per item 25 $ 10 per item