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 X2 + 12.5 X22. The manufacturer of the toaster ovens can supply at most 1000 units for the two models. It typically takes ½ hour to sell the Minitoaster and 2/5 hour for the Deluxe. The Sales Department has 500 hours available. What is the linear programming (mathematical) model for this problem? Develop a spreadsheet model and find the optimal solution using Excel Solver. How many toaster ovens of each model should Great Pacific sell? What is the total profit contribution that Great Pacific can earn with the optimal sales quantities?
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 X2 + 12.5 X22. The manufacturer of the toaster ovens can supply at most 1000 units for the two models. It typically takes ½ hour to sell the Minitoaster and 2/5 hour for the Deluxe. The Sales Department has 500 hours available. What is the linear programming (mathematical) model for this problem? Develop a spreadsheet model and find the optimal solution using Excel Solver. How many toaster ovens of each model should Great Pacific sell? What is the total profit contribution that Great Pacific can earn with the optimal sales quantities?
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Topic Video
Question
100%
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 X2 + 12.5 X22.
The manufacturer of the toaster ovens can supply at most 1000 units for the two models.
It typically takes ½ hour to sell the Minitoaster and 2/5 hour for the Deluxe. The Sales Department has 500 hours available.
- What is the linear programming (mathematical) model for this problem?
- Develop a spreadsheet model and find the optimal solution using Excel Solver. How many toaster ovens of each model should Great Pacific sell?
- What is the total profit contribution that Great Pacific can earn with the optimal sales quantities?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
