A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets have a profit margin of $35 each. To produce each item, a setup cost is incurred. This setup cost of $500 for widgets and $400 for gadgets. Widgets consume 4 units of raw material A and 5 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.
Set up the problem in Excel and find the optimal solution. What is the maximum profit possible?
A) $3,500
B) $4,500
C) $5,500
D) $6,500
E) $7,500

Question

Quizplus · Accepted Answer

The Answer of A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets have a profit margin of $35 each. To produce each item, a setup cost is incurred. This setup cost of $500 for widgets and $400 for gadgets. Widgets consume 4 units of raw material A and 5 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.
Set up the problem in Excel and find the optimal solution. What is the maximum profit possible?
A) $3,500
B) $4,500
C) $5,500
D) $6,500
E) $7,500

A Manufacturer Produces Both Widgets and Gadgets