A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $50 each. To produce each item, a setup cost is incurred. This setup cost is $600 for widgets and $300 for gadgets. Widgets consume 6 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 600 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 a. manufacturer will produce widgets and will not produce gadgets. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) 3,600.00 widgets and b. The manufacturer will produce 1,800.00 gadgets (Round your answer to 2 decimal places.) The manufacturer's profit will C. be 2,800.00