A manufacturer produces both widgets and gadgets. Widgets generate a profit of $25 each and gadgets have a profit margin of $75 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $300 for gadgets. Widgets consume 6 units of raw material A and 8 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 400 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. The manufacturer will produce .......widgets and ...... gadgets the manufacturer's profit will be .....
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $25 each and gadgets have a profit margin of $75 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $300 for gadgets. Widgets consume 6 units of raw material A and 8 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 400 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.
The manufacturer will produce .......widgets and ...... gadgets
the manufacturer's profit will be ......
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
