I need help with my master budget.

1. Prepare a sales budget.
2. Prepare a production budget.
3. Prepare a direct materials budget.
4. Prepare a direct labor budget.
5. Prepare a manufacturing overhead budget.
6. Prepare a selling and administrative budget.
7. Prepare a budgeted income statement.
8. Prepare a cash budget.

Wayne Corporation Master Budget Project The company is preparing its budget for the coming year, 2022. The first step is to plan for the first quarter of that coming year. The following information has been gathered from their managers. Sales Information Period Units November, 2021 102,000 Actual December, 2021 91,000 Actual January, 2022 100,000 Planned February, 2022 101,000 Planned March, 2022 103,000 Planned Grading guidelines are on the instru April, 2022 112,000 Planned May, 2022 123,000 Planned Unit selling price 30.70 5 Finished Goods Inventory Planning 6 The company likes to keep 15% of the next quarter's unit sales in finished goods ending Inventory. 17 18 Accounts Receivable & Collections 19 Sales on Account 100% 20 Collections Activity 21 Month of Sale BOX 22 Month after Sale 20% 23 Balance at 12/31/21 S 185,000.00 24 25 Materials Inventory Costs & Planning 26 Direct Moteriols Amount Used per Unit Cost 27 Ingredient 2 1b S 1.18 1b 28 The company likes to keep 12% of the material needed for the next month's production In raw materials ending inventory.The company likes to keep 12% of the material needed for the next month's production in raw materials ending inventory. Accounts Payable & Disbursements Purchases on Account 100% Payment Activity Month of Purchase 40% Month after Purchase 60% Balance at 12/31/21 120,000 Direct Labor & Costs Time per Unit Production 30 minutes 9 Pay Rate/Hour 20.00 41 Manufacturing Overhead Costs 42 Variable costs per direct labor hour 43 Indirect materials 0.25 44 Indirect labor 0.35 45 . Utlities 0.45 46 Maintenance 0.25 47 Fixed costs per month 48 Salaries S 42,000 49 Depreciation 16,800 50 Property taxes 2,675 51 Insurance 1,200 52 Janitorial 1,300 53 54 Selling and Administrative Costs 55 Varlable costs per unit sold 1.20 56 Fixed costs per month 57 Advertising 15,000 58 Insurance 14,000Variable costs per unit sold S 1.20 red costs per month Advertising 15,000 Insurance 14,000 Salaries 72,000 Depreciation 25,000 Other fixed costs 3,000 Income Taxes Accrued on Monthly Net Income 45% rounded to nearest dollar Amounts Accrued Q4 2021 paid January 2022 S 200,000 Cash and Financing Matters Cash Balance, 12/31/2021 145,000 2022 Minimum Balance Required 795,000 Monthly Dividends S 1.80 per share Outstanding Shares 5,000 Line of Credit Limit 1,200,000 + 6 Borrowing Increment Required 1,000 17 Annual Interest Rate 10% '8 Borrowings occur on the First of Month 79 Repayments occur on the Last of Month 80 Interest accrues on the loan balance from the date of borrowing. Interest accrued is paid first with each repayment. 81 82 Additional Item 83 Fixed Asset Purchase 361,000 84 Month January