Solve the problem clearly, accurately, and completed using excel.

The Budget Director of Rosa Inc., in consultation with other members of executive management, has gathered the following data for use in developing a master budget for operations and a cash budget for December. Use the following data to set up, in good form, the following budgets for December for Rosa Inc. . . Sales Budget Production Budget Direct Materials Purchases Budget Direct Labor Cost Budget Cost of Goods Sold Budget Budgeted Income Statement Cash Budget Be sure each budget has a heading identifying the company name, the budget title, and the time period. Estimated sales for December Product Y Z Units Sell Price per Unit 35,000 33 25,000 68 Estimated Inventories, December 1 Material A B Pounds 4,000 3,500 Product Y Z Units 3,000 2,700 Cost per Unit 18 37 Cost of Work In Process 12/1$ 36,800 Estimated Inventories, December 31 Material Pounds 3,000 2,500 B Product IY IZ Units 2,500 2,000 Cost per Unit 18 37 Cost of Work in Process, 12/31 $ 37,930 Direct Materials used in production Material Pounds per Pounds per unit of Y unit of z 0.7 1.2 A 3.5 1.8 B Unit costs for direct materials Cost per Material pound 9 A B 4 Direct labor requirements Product Y IZ Department 1 Department 2 Hours per unit Rate per hour Hours per unit S Rate per hour 0.4 12 0.15 16 0.6 12 0.25 16 Factory overhead actual costs Estimated total $ 295,000 Operating expenses Estimated total $ 632,500 Estimated income tax rate 20% 8,200 80% 80% 90% Cash estimates for December: Estimated cash balance, 12/1$ Sales expected to be collected in cash in December Direct materials purchases expected to be paid in December Direct labor costs expected to be paid in December Factory overhead costs expected to be paid in December Operating expenses expected to be paid in December Income taxes expected to be paid in December No other cash receipts or payments expected in December Desired cash balance, 12/31 $ 75% 70% 30% 90,000