2. Production budpet (in sets): 3. Rowmaterial purchases: 4. Direct-labor budget: 5. Build a sproudsheer: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: each set sells for $55 and the direct-labor cost per hour is \$21. Empire Polymer Development produces three produets using three different continuous processes. The products are Yarex. Darol, and Norex. Projected sales in gallons for the three products for the years 202 and 203 are as follows: Sebolastie Furniture, Ine, manufactures a variety of desks, chairs, tables, and sheif units that are sold to publie school syatems throughout the Midwest. The controller of the compary's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. Each desk-andehair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $20 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finishedsoods inventory to cover 20 percent of the next month's sales