Formulate a linear programming model to determine how many containers of each product to produce to maximize total profit and solve it using Excel's Solver.

A company makes four juice products using orange, grapefruit, and pineapple juices. The selling price, cost and supply quantities are as follows: Product Selling price per liter container Orange juice $1.50 Grapefruit juice $1.30 Pineapple juice $1.25 All-in-one juice $1.55 Product Cost per liter Supply in liters Orange juice $0.50 1600 Grapefruit juice $0.40 1200 Pineapple juice $0.45 1500 The All-in-One juice has equal portions of orange, grapefruit, and pineapple juice (so each juice has 1/3 of the total volume). Each product is produced and sold as a one- liter size container. Each type of juice has limited supply as specified in the above table. In addition, the manager Ms. Mary wants grapefruit juice containers to be no more than 30 percent of all containers produced