A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 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 $400 for gadgets. Widgets consume 3 units of raw material A and 4 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.

Max P= 45 x₁ + 75 x₂ 400 y₁ 400 y₂ s.t. 3x₁ + 6x₂ 400 {Raw material A} 4x₁ + 2x₂ 400 {Raw material B} 9999y₁ x₁ {Widget Setup Cost} 9999y₂ x₂ {Gadget Setup Cost}

x₁ , x₂ 0 and y_1, y₂ = 0,1 (Binary)

Set up the problem in Excel and find the optimal solution.

a. The manufacturer .......... widgets and ......... gadgets. (Leave no cells blank be certain to enter "0" wherever required. Round your answers to 2 decimal places.) b. The manufacturer will produce ........... widgets and .........gadgets (Round your answer to 2 decimal places.) c. The manufacturers profit will be ............