A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets have a profit margin of $75 each. To produce each item, a setup cost is incurred. This setup cost is $600 for widgets and $400 for gadgets. Widgets consume 7 units of raw material A and 7 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.

(Round your answer to 2 decimal places.)

b.

The manufacturer will produce

widgets and

gadgets

c.

The manufacturers profit will be

A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets have a profit margin of $75 each. To produce each item, a setup cost is incurred. This setup cost is $600 for widgets and $400 for gadgets. Widgets consume 7 units of raw material A and 7 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 not produce widgets and will produce a. gadgets. (Leave no cells blank be certain to enter "O" wherever required. Round your answers to 2 decimal places.) b. The manufacturer will produce widgets and gadgets