Given the following information in the table for four products, find the profit-maximizing price for each product. (Please show excel and solver steps.)

low Medium High Lowest Medium High Price Price Price Unit Product Price Price Price Demand Demand Demand cost Product 1 $1.40 $2.20 $3.00 100 40 S $1.10 Product 2 $2.20 $3.00 $4.00 200 130 25 $1.50 Product 3 $45 $75 $95 400 300 130 540 Product 4 $200 $250 $300 600 300 50 $120