The Great Pacific Appliance Company sells two models of toaster ovens, the Minitoaster (X1) and the Deluxe Toaster Oven (X2). The firm earns a profit of P1400 for each Minitoaster regardless of the number sold. Profits for the Deluxe model, however, increase as more units are sold because of fixed overhead. Profit contribution on this model is given by the expression 1050 X₂ + 12.5 (X₂₎².

1. The manufacturer of the toaster ovens can supply at most 1000 units for the two models.
2. It typically takes ½ hour to sell the Minitoaster and 2/5 hour for the Deluxe. The Sales Department has 500 hours available.
3. What is the linear programming (mathematical) model for this problem?
4. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many toaster ovens of each model should Great Pacific sell?
5. What is the total profit contribution that Great Pacific can earn with the optimal sales quantities?

Answer rating: 100% (QA)

Step 1 Step 2 Step 3 05 is the pivotal element Let the number of Mini toaster sold x N... View the full answer