The Pyrotec Company produces three small kitchen appliances – waffle makers, egg cookers, and toasters. The three products have the following requirements: Resource Requirements Metal Materials/unit Plastic Materials /unit Labor hours/unit Waffle maker 3.1 lb 0.5 lb .7 Egg cooker 1.5 lb 0.7 lb 1 Toaster 2.0 lb 0.3 lb .5 Resource costs are $3 per pound of metal, $2.90 per pound of plastic and $10.00 per hour for labor. Available resources are 200 pounds of metal, 250 pounds of plastic and 350 hours of labor. Based on market research, the company expects the maximum demand for waffle makers is 50 and for egg cookers is 75. The company has a contract to supply 25 toasters to a local department store. Waffle makers will be sold for 24.99, egg cookers will be sold for 19.99 and Toasters will sell for 14.99 The company wants to know the optimal product mix that will maximize profit. Part A. Write the Linear Programming formulation for this problem to help determine the best production mix of the three appliances that will maximize profit.
Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary).
The Pyrotec Company produces three small kitchen appliances – waffle makers, egg cookers, and toasters. The three products have the following requirements:
|
Resource Requirements |
|
|
|
Metal Materials/unit |
Plastic Materials /unit |
Labor hours/unit |
Waffle maker |
3.1 lb |
0.5 lb |
.7 |
Egg cooker |
1.5 lb |
0.7 lb |
1 |
Toaster |
2.0 lb |
0.3 lb |
.5 |
Resource costs are $3 per pound of metal, $2.90 per pound of plastic and $10.00 per hour for labor.
Available resources are 200 pounds of metal, 250 pounds of plastic and 350 hours of labor.
Based on
Waffle makers will be sold for 24.99, egg cookers will be sold for 19.99 and Toasters will sell for 14.99
The company wants to know the optimal product mix that will maximize profit.
Part A. Write the Linear Programming formulation for this problem to help determine the best production mix of the three appliances that will maximize profit.
Step by step
Solved in 4 steps with 10 images