dolution

A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets have a profit margin of $60 each. To produce each item, a setup cost is incurred. This setup cost is $300 for widgets and $600 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 700 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 $45 each and gadgets have a profit margin of $60 each. To produce each item, a setup cost is incurred. This setup cost is $300 for widgets and $600 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 700 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.

Fill in A-C

A. The manufacturer (will produce) or (will not produce) widgets and (will produce) or (will not produce) gadgets.

B. The manufacturer will produce (blank) widgets and (blank) gadgets

C. The manufacturers profit will be (blank)

(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.)

(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.)