The Big Bang Novelty Company (BBNC) makes 3 types of noise?makers: Toot, Wheet, and Honk. A Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 20 minutes, has two feathers, and is sprinkled with 0.5 ounces of sequin powder. The Honk requires 30 minutes, three feathers, and 1 ounce of sequin powder. The unit profits are $0.45 per Toot, $0.55 per Wheet, and $0.70 per Honk. The following resources are available: 80 hours of labor, 360 feathers, and 90 ounces of sequin powder. BBNC would like to maximize the overall profit from the noise-makers. (a) Write the linear programming model. Express labor time in minutes in LP formulationb) Solve using Excel Solver. How much of the resources (labor, feathers, and sequin powder) will be used by the optimal solution? If the availability of labor increases by 10 hours, what is the optimal total profit? If the unit profit of Wheet is actually only $0.30 instead of $0.55, will this change the solution? How many of each product would you make in this case? (Assume the labor availability is back at the original 80 hours.)
The Big Bang Novelty Company (BBNC) makes 3 types of noise?makers: Toot, Wheet, and Honk. A Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 20 minutes, has two feathers, and is sprinkled with 0.5 ounces of sequin powder. The Honk requires 30 minutes, three feathers, and 1 ounce of sequin powder. The unit profits are $0.45 per Toot, $0.55 per Wheet, and $0.70 per Honk. The following resources are available: 80 hours of labor, 360 feathers, and 90 ounces of sequin powder. BBNC would like to maximize the overall profit from the noise-makers. (a) Write the linear programming model. Express labor time in minutes in LP formulationb) Solve using Excel Solver. How much of the resources (labor, feathers, and sequin powder) will be used by the optimal solution? If the availability of labor increases by 10 hours, what is the optimal total profit? If the unit profit of Wheet is actually only $0.30 instead of $0.55, will this change the solution? How many of each product would you make in this case? (Assume the labor availability is back at the original 80 hours.)
Note:-
- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
- Answer completely.
- You will get up vote for sure.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 17 images
