A manufacturer produces both widgets and gadgets. Widgets generate a profit of $$60$ each and gadgets have a profit margin of $$70$

each. To produce each item, a setup cost is incurred. This setup cost is $$400$ for widgets and $$400$ for gadgets. Widgets consume $5$

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$.$ The manufacturer

$($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 manufacturer's profit will be