i need help making a master budget

OFF ExcelCase-1 Home Insert Draw Page Layout Formulas Data Review View Tell me Default Ruler Formula Bar Zoom 100% Keep Exit New Options Normal Page Break Page Custom Gridlines Headings 100 Zoom to 100% Zoom to Preview Layout Views Selection 15 + XV fx B C D E G H J Wayne Corporation Master Budget WN D Year Ended December 2022 Sales Budget 2022 November December January February March April May 7 Expected Sales (units) 93,000 83,00 1,00 92,000 94,000 102,000 112,000 Sellings Price/Unit $27.65 $27.65 $27.65 27.65 $27.65 $27.65 $27.65 9 Sales ($) $2,571,450.00 $2,294,950.00 $2,516,150.00 $2,543,800.00 $2,599,100.00 $2,820,300.00 $3,096,800.00 10 11 Production Budget 2022 12 November December January February March April May 13 Expected Sales (units) 93,000 83,000 91,000 92,000 94,000 102,000 112,000 14 Desired Ending Inventoy (units) 15 Required Inventory (units) 16 Expected Beginning Inventory 17 Production Requirement (units) 18 19 Direct Materials Budget 2022 20 Q1 Q2 Q3 Q4 Total 21 Production Requrement (units) 22 Raw Material #Reqd/FGUnit 23 Raw Materials Required (Pounds (#)) 24 Desired Ending Raw Mats Inv (#) 25 Required Raw Mats Inv (#) 26 Expected Beg Raw Mats Inv (#) 27 Raw Materials Purchases Required (#) 28 Cost per Pound 29 Total Cost of Direct Materials Purchase 30 31 Direct Labor Budget 2022 32 Q1 Q2 Q3 Q4 Total 33 Production Requirement in Units 34 Required Labor/Units (Hours) 35 Budgeted Direct Labor ( Hours) 36 Direct Labor Cost per Hour 37 Budgeted Direct Labor Cost 38 39 Manufacturing Overhead Budget 40 2022 Q1 Q2 03 Q4 41 Budget Direct Labor (Hours) Total 42 Manufacturing Overhead Rate/DLHour 43 Budgeted Manufacturing Overhead 4 Instructions Facts Student Solution + Ready esc 888 F3 F4 F5 F6The facts for this problem are presented on the Facts tab of this workbook. Instructions - Your solutions should be clearly labeled on the Solutions tab of this workbook. For the first quarter of 2022, do the following. (a) Prepare a sales budget. This is similar to Illustration 22-3 in your textbook. (b) Prepare a production budget. This is similar to Illustration 22-5 in your textbook. (c) Prepare a direct materials budget. (Round to nearest dollar) This is similar to Illustration 22-9 in your textbook. (d) Prepare a direct labor budget. (For calculations, round to the nearest hour.) This is similar to Illustration 22-11 in your textbook. (e) Prepare a manufacturing overhead budget. (Round intermediate amounts to the nearest dollar.) This is similar to Illustration 22-12 in your textbook. (f) Prepare a selling and administrative budget. This is similar to Illustration 22-11 in your textbook. (g) Prepare a budgeted income statement. (Round intermediate calculations to the nearest dollar.) This is similar to Illustration 22-15 in your textbook. (h) Prepare a cash budget. This is similar to Illustration 22-19 in your textbook. You will need to prepare schedules for expected collections from customers and expected payments to vendors first. See Illustrations 22-17 and 22-18 in your textbook for guidance. pok. You will also need to prepare schedules to support your calculation of amounts borrowed, interest expense, and loan repayments. These should be well labeled and formatted so that I may follow your work.O OFF ~ HE 6 5 : Exc me Insert Draw Page Layout Formulas Data Review View Tell me efault Ruler Formula Bar Zoom Keep Exit New : Options Normal Page Break Page Custom Gridlines Headings 100 Zoon Keep Sheet View Preview Layout Views X V fx =CONCATENATE(Instructions!B2," Master Budget Project") B C D E F G 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 93,000 Actual December, 2021 83,000 Actual 00 January, 2022 91,000 Planned 9 February, 2022 92,000 Planned 10 March, 2022 94,000 Planned Grading guidelines are on the instructions tab. 11 April, 2022 102,000 Planned 12 May, 2022 112,000 Planned 13 Unit selling price $ 27.65 14 15 Finished Goods Inventory Planning 16 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 90% 22 Month after Sale 10% 23 Balance at 12/31/21 $ 185,000.00 24 25 Materials Inventory Costs & Planning 26 Direct Materials Amount Used per Unit Cost Ingredient 2 1b $ 1.16 1b 28 The company likes to keep 12% of the material needed for the next month's production in raw materials ending inventory. 29 30 Accounts Payable & Disbursements 31 Purchases on Account 100% 32 Payment Activity 33 Month of Purchase 60% 34 Month after Purchase 40% 35 Balance at 12/31/21 $ 120,000 36 37 Direct Labor & Costs 38 Time per Unit Production 30 minutes 39 Pay Rate/Hour 20.00 40 41 Manufacturing Overhead Costs Instructions Facts Student Solution + Ready