A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $45 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $500 for gadgets. Widgets consume 5 units of raw material A and 6 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 500 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. Set up the problem in Excel and find the optimal solution.
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $45 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $500 for gadgets. Widgets consume 5 units of raw material A and 6 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 500 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets.
Set up the problem in Excel and find the optimal solution.
(Leave no cells blank — be certain to enter "0" wherever required. Round your answers to 2 decimal places.)
(Round your answer to 2 decimal places.)
Step by step
Solved in 4 steps with 6 images
