AutoSave OFF Home Insert Draw Page Layout Formulas Data Review Excel Case Due July 17 - Saved to my Mac View Tell me Paste Calibri (Body) BI U v 11 x ' ' General $ % 9 Conditional Format Formatting as Table Styles Cell Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? C37 : x fx n D F G H 1 . K L MA N 1 2 Wayne Corporation Sol 3 For the Year Ending December 31, 2122 4 Quarter 5 6 January Feburary March Year 7 Expected sales 8 Unit selling pr 'S 9 To 100000 30.70 1,000,044.31 101,000 30.70 $ 3,100,340.75 304,000 30.706 3,141,733.645 30.70 9,313,000 20 11 13 13 14 15 Expected sales units 17 Add Desired ending finished good units 18 Total required units Beginning ngunit 20 Required production 21 Wayne Corporation Product Burge For the Year Ending December 31, 2027 22 23 24 25 25 27 Unites to be produced 21 Direct materials units per unit produced 29 Total pounds required 30 Act desired ending direct materials 31 Total materials 32 less beginning materials 31 34 Cost Per Pound 35 Direct meterials punched Total Cost of Direct 35 37 Quarter1 January Feburary March 100000 15150 101,000 imm 1500 15460 17040 47,640 115.150 116490 120.000 351640 15000 100.150 15150 15450 45000 101,300 104.590 306040 Wayne Corporation Direct Material Bages For the Year Ending December 31, 2022 Quarter January Leberare March Year 100.150 101 300 104,590 306040 200.900 202,600 200,180 24313 612030 251014 73449 2246:2 327.12 322,817 24036 24312 251016 200578 339 197.710 55205 73448.6 1200 118 S 1.18 1.18 $ 118 236,679 239.999.73 233,296.375 722,254 40 HAO 0 Insert Delete Format v WEI Share Comments Sort & Filter Find & Select Analyze Data Yes No P R R - V Apri Expected sales 112000 Add: Desired ending finished good units Total required uns 16800 113,000 Les: Teginning finished goods units Required procation 10 56,183 AutoSave DFF Excel Case Due July 17 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) v 11 v ' ' ab General BI U $ % Paste C37 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? x fx Cell Conditional Format Formatting as Table Styles 37 A D Way Carpation Direct labor budget For the Year Ending December 31, 2022 Quarter G H Jamary " Expunere March 100.190 101,300 104.590 50075 2000 1,001,100.00 50660 20.00 1,011,000.003 52295 20.00 S 1,045,900.003 305,040 153020 60.00 9,181,300.00 38 39 40 41 42 Units to be produced 41 Direct labor time ( 44 Total Required Direct Labor Hours 45 Direct labor cost per hour 'S total Direct labor 47 48 19 Wayne Corporation Manufacturing Overhead Budget For the Year Ending December 31,323 50 Quer 51 52 January 53 Educ March Year Direct labor hours 54 Indred materia 52293 153,025 3 25 D35 0.35 55 Indirect labor . 56 clicies 0.35 C45 0.45 57 Maintenance 0.25 0.25 0.25 total variable cost per direct labor Hour 15 130-3 1.303 1.30 59 Variable Cost-trea 5,097.50 60 Salaries 45,845.00 47,483.50 198,936.00 42,000.00 42,000.00 42,000.00 61 Depreciation 126,000.00 16000 16800 62 Property taxes 16000 2675 2675 2675 50400 8025 G 04 Insurance Janitor 1300 1300 1300 1300 1300 1300 65 Total Manufacturing 3900 125072.50 129,820.00 $ 133.958.50 350,851.00 GE MOH $2.55 67 68 70 72 73 74 Variable amis p 75 Variable Seling Exper 25 Advertising Wayne Corporation Selling and Administrative get For the Year Ending December 31, 20022 Quarter January Extrac March $1.30 12000 $130 121.200 15000 $130 1210 Year 51.30 36-400 45030 1 HAI Share Comments Insert Delete + Format Sort & Filter Find & Select Analyze Data Yes No 1 K L M N P R R T V AutoSave DFF Home Insert Draw Page Layout Formulas Data Review Paste Calibri (Body) BIU v 11 v ' ' Excel Case Due July 17 - Saved to my Mac View Tell me ab General $ % 9 Conditional Format Formatting as Table Styles Cell C37 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? : x fx D F G 6 A 70 71 72 23 24 Variable costs per units sold 75 Variable Selling Expres Adverting 77 Insurance 28 Salaries 29 Duration 80 Other foed co Total Selling and Amateu 82 83 31 86 87 Sales 88 Cost of Goods Sold Gres Pratt 90 Seling and Admis Income from up 92 Interest Expense 93 Income Before Income Tax peme 35 Net In 95 97 98 99 101 102 103 Opening Cash 10 115 106 Expected Collection from customer Availash bela payments 107 Cash dividend 108 109 Fled assets purchased expected payment to vendors Way Corporation Selling and Administrative Budget For the Year Ending December 31, 2022 Que H Jum March $1.20 120000 $1.20 $1.20 121.200 123.600 15000 15000 15000 34000 $1.20 364.800 42000 34030 3433 2000 22000 25000 25000 3000 3000 $289,000.00 $250,200.00 $250,000.00 25000 3000 43,000.00 216000 35000 9000 $751,900.00 Wayne Corporation Budgeted Income Statement For the Year Ending December 31, 3033 1 January Ex 3.060,644.31 3.100.340.756 Marsh 3.161,788.645 9.332,800.00 Wayne Corporation C For the Year Ending December 31, 20122 January Feburary March Year 1 K L MA N HAO 0 Share Comments Insert Delete Format Sort & Filter Find & Select Analyze Data Yes No P R R V AutoSave OFF Home Insert Draw Page Layout Formulas Data Review Paste Calibri (Body) BI U v 11 v ' ' Excel Case Due July 17 - Saved to my Mac View Tell me General $ % 9 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? C106 fx less:payments A A D G H Cell Conditional Format Formatting as Table Styles 1 1 K L MA N 95 97 98 99 100 101 102 103 Opening Cush 104 105 Expected Collection from customers. Available cash balance 106 107 Cash did 108 109 110 111 112 Fiad asists purchased expected payment to vendors direct labor cost manufacturing heads alling and ad 113 nat cash balance 114 add borrowings 115 less prindpol repaid 116 117 interest reald dosingh balanc 118 119 120 121 122 123 124 125 1510 127 128 129 130 131 122 133 134 135 136 137 138 159 140 Wayne Corporation Cash Budget For the Year Ending December 31, 2022 January Laburary March HA 0 Share Comments Insert Delete Format v Sort & Filter Find & Select Analyze Data Yes No P Q R - V 00 AutoSave DFF Home Insert Draw Design Layout References Calibri (Bo... v 10.5 ' ' Aav Paste B I U ab x, x' A Page 1 of 3 617 words English (United States) Document2 Mailings Review View Tell me v 2 Share Comments AaBbCcDdte AaBbCcDdEe AaBbCcDc AaBbCcDdE. AaBb( Normal No Spacing Heading 1 Heading 2 Title Styles Editor Pane 5 6 The company preparing for the coming year, 2022. The first step is to plan for the first quarter that coming year. The following information how been gathered from their managers The facts for this problem are presented on the Facts tab of this workbook Instructions - Your solutions should be clearly labeled on the Solutions of this worldbook For the first quarter of 2002, (2) Prepare a sales budget. This is rustration 22-3 in your textbook (b) Prepare a production budget. This is station 22-5 in your textbook (c) Pract bound to do)22-your botto (Preparator budget. For subtions, round to the nearest hour. This smart 22-11 in your textbook ration (e) Prepare a manufacturing overhead budget (Round intermediate amounts to the nearest dollar. This is stration 22-12 in your textbook Presland ministrative bag. This station 22-11 in your b (Prepare a budgeted income statement (Round Intermediate calculations to the nearest dollar. This is sation 22-15 in your textbook Prepare budget. This is girl glustration 22-19 in your book You will need to prep checks for expected collections from att vendors first. Seeustrations 12-17 and 22-18 in your book for guid You will also need to prepare schedules to support your cakulation of amours borrowed, interest expense, and loan repayments. These should be well labeled and formatted so that I may follow your work ***requesting help for BUDGETED INCOME AND CASH BUDGET. Chege just let me downiced the not of what had completed. Thank you so very much formuan bad appreciate*** Sales Information Period Units Member, 2021 102,000 2021 91,000 Actual Actua 22 300,000 Planned Cebu 2122 101,000 Planned March, 20122 10:00 Planned And 3:02 112,000 Planned 2022 123,000 Planned Uniting price $30.70 Focus + 72% AutoSave DFF Document2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments Calibri (Bo... v 10.5 ' ' Aav AaBbCcDdte AaBbCcDdEe AaBbCcDc AaBbCcDdE. AaBb( Paste B I U ab x, x' A Normal No Spacing Heading 1 Heading 2 Title Styles Editor Pane Page 2 of 3 617 words x English (United States) 2 5 6 Finished Goods Inventory The company lives to 15% of the next quarter's unit sales infinished goods ending inventory. Accountable & Collecti Salmon 100% Collections Activity Morth of Sale 80% Month after 20 Balance 12/31/21 $185,00000 Mory & Direct Mar Ingredient 2 b The company lives to ending inventory 51.18 Cast 12% of the material needed for the next month's production in raw materials Accu Payable & Dements Purches Account 100% Payment Activity Morth of Purchase 40% Morth after Purchase 60% Balance at 12/31/21 $120,000 Production Direct Later & Co Time per Pay $20.00 Manufacturing Overhead Costs Variable costs per direct labor hour Ind 50.25 Indirect 0.35 UB45 Martere 0135 Floed costs per mo Salaries $42.000 Depreciation 16,800 Property 265 Insurance 1,200 Janitorial 1,300 Selling and Administrative Costs Variable costs per un sold Food costs per mon Advert Saberies 72,000 $15,000 14,000 Depreciation 75,000 Other Fixed costs Income Ta 3,000 10 minutes 51.20 Accrued on Monthly Net Incom rounded to adul Focus + 72% AutoSave DFF Home Insert Draw Design Layout References Calibri (Bo... v 10.5 ' ' Aav Paste B I U ab x, x' A Page 2 of 3 617 words x English (United States) Document2 Mailings Review View Tell me Share Comments AaBbCcDdte AaBbCcDdEe AaBbCcDc AaBbCcDdE. AaBb( Normal No Spacing Heading 1 Heading 2 Title Styles Editor Pane Food costs per mo Advertising $15,000 Insurance 14,000 Salaries 72,000 Depreciation 25,000 Other fixed cos 3,000 Income Taes Accrued on Monthly Net Income 456 rounded to nearest dollar Amounts Accrued Q4 2021 paid January 2022 $200,000 Cash and Financing Matters 12/31/2021 $145,000 2122 Minimum re 75,000 Monthly Dividends Outstanding Shares $1.00 per share 5,000 6 Line of Credit Limit $1,200,000 Normwingiemant $1,000 Annual Interest Rate 10% Borrowings occur on the First of Month Repayments occur on the Last of Month Interes: accrues on the loan balance from the date of borrowing interest accrued is paid first with each Additional hem Food Asset Purchase Month January $361,000 Focus + 72%