i just need the last picture solved. the rest are information for you to solve it

0 2021 8,500 units 6,700 units 8,500 units 5300 units 8.300 units 1 Okay Co. Master Budget 2 3 January 4 February 5 March 6 Aril 7 May 8 SALES BUDGET 10 11 Budgeted sales (units) Selling price per unit 13 Total sales 14 1 SCHEDULE OF EXPECTED CASH COLLECTIONS January February March 8.500 61,700 59 59 501,500 395,300 8.500 59 501.500 Quarter Anl 23,700 59 1 398,300 May 5.300 59 317,700 6,300 59 371,700 16 January March February 0 325,075 175 525 18 Accounts receivable beginning balance 11 April sales 20 April 21 May 22 May sales 23 May 34 June 25 June sales June 27 Total cash collections 2 25 PRODUCTION BUDGET Quarter 0 0 325875 176,525 0 256,945 138,355 0 325,975 1.222 775 $ 256.945 138 355 325,075 464.330 325975 432 470 1.222.775 11 January February March Quarter April May Instructions A Input A Template Parts B, C and D Beady January 6,300 29 PRODUCTION BUDGET 30 11 12 Budgeted sales Add desired ending inventory 34 Total needs Less beginning inventory 36 Required production 37 3. DIRECT MATERIALS BUDGET February 8,500 1,675 10,175 0 10.175 March 6,700 2.125 8,825 1.675 7,150 8,500 1325 9,825 2.125 7.700 Quarter Apri 23,700 1,325 25,025 0 25.025 May 5,300 1576 6.875 1325 5,550 1,325 (1,325) May 5,550 7 38 BSO (1325 7 (0275) March 7,150 7 50.050 8.085 58.135 7.50B 50428 7.700 7 53.900 5828 59 720 8,085 51 543 Quarter April 25025 7 175, 175 5,828 181.003 0 181.003 27339 27887 40 January February 41 Required production in units 10.175 Raw materials per unit (pounds) 7 - Production needs (pounds) 71.225 Add desired ending inventory (pounds) 7500 45 Total needs (pounds) 78,733 4 Less beginning inventory (pounds) 0 -> raw materials to be purchased (pounds) 78.733 - Cost of raw materials to be purchased at $0.40 per pound 42 516 SCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR MATERIAL January February 33 Accounts payable beginning balance April purchases April 25,500 May 1 May purchases MAY Instructions Anot A Template Parts B. Gand D 97741 March 0 Quarter o o 25,509 17 000 0 5 WE 17.006 1640 + March Quarter Olo SS 17.006 25,509 17,006 0 16,403 10,936 16,403 59 10,936 50 SCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR MATERIAL 51 52 January February 59 Accounts payable beginning balance 0 54 April purchases: April 25,509 56 May 57 May purchases: SA May June 30 June purchases: June 62 Total cash disbursements for materials 25,509 63 64 DIRECT LABOR BUDGET 65 January February * Required production 10.175 Direct labor-hours per unit 1 Total direct labor-hours needed 6,105 70 Direct labor cost per hour 15 71 Total direct labor cost 91,575 72 - MANUFACTURING OVEHEAD BUDGET 61 16,732 27.668 16,732 86,587 33,410 0 66 March 7,150 1 Quarter 25,025 1 15,015 15 225 225 7,700 1 4,620 15 69,300 4.290 15 64,350 74 75 7 Budgeted direct labor-hours 7 Variable manufacturing overhead rate 78 Variable manufacturing overhead >> Fixed manufacturing overhead 10 Total manufacturing overhead Instructions A. Input A. Template Ready January February March 6,105 4.290 3 3 20,147 14,157 92.000 92,000 112.147 106,157 Parts B, C and D + 4,620 3 15,246 92.000 107246 Quarter 15,015 3 49,550 276,000 325.550 7 MANUFACTURING OVERHEAD BUDGET 14 January March 75 February 6,105 4.290 3 3 20,147 14,157 92000 92.000 112,147 106,157 16,000 16.000 95.147 90.157 4,620 3 15.246 92000 107 246 16,000 01.246 Quarter 15,015 3 49.550 276,000 325,550 48.000 277,550 Budgeted direct labor-hours Variable manufacturing overhead rate Variable manufacturing overhead Foxed manufacturing overhead 0 Total manufacturing overhead Less depreciation Cash disbursements for manufacturing overhead 11 16 ENDING FINISHED GOODS INVENTORY BUDGET BS * Computation of absorption unit product cost Direct materials * Direct labor Manufacturing overhead Unt product cost Total 4 Quantity pounds 1 hours 1 hours Cost 1 per pound 15 per hour 22 per hour 9 13 26 93 4 Predetermined Overhead Rate 22 Total manufacturing overhead Total direct labor hours 325550 15 015 35 Budgeted ending finished goods inventory Ending finished goods inventory in units Unit product cost Ending finished goods inventory in dollars 101 SELLING AND ADMINISTRATIVE EXPENSE BUDGET structions A Template Parts . Cand 1,325 20 14.170 A Quarter 23,700 8,500 1 10,200 63,000 73,200 9,000 28.440 189.000 217.440 9,000 64,200 208,440 202 SELLING AND ADMINISTRATIVE EXPENSE BUDGET 101 March 104 January February 105 Budgeted sales in units 8,500 6,700 1 1 104 Variable selling and administrative expense per unit 107 Variable selling and administrative expense 10.200 8,040 3:00 Fixed selling and administrative expense 63,000 63,000 109 Total selling and administrative expense 73,200 71,040 110 Less depreciation 9,000 9,000 Cash disbursements for selling and administrative 111 expenses 64 200 62,040 112 113 CASH BUDGET 116 Royal Company 115 Cash Budget 110 For the Quarter Ending June 30 117 111 January February March 110 Cash balance, beginning 18.000 81,544 1:20 Add receipts: 131 Cash collections 325,975 432 470 122 Total cash available 343,975 514,014 122 124 Less disbursements: 125 Direct materials 25,500 33410 125 Direct labor 91,575 64 350 27 Manufacturing overhead 96,147 90,157 120 Selling & administrative 64 200 62040 128 Equipment purchases 144.000 110 Dividends 35 000 131 Total disbursements 312431 393 957 Instructions A. Input A. Template Parts B. Cand D + Quarter 18,000 120,058 464,330 584,388 1,222,775 1,240.775 27,668 69,300 91 246 84200 152,000 86,587 225 225 277,550 208 440 295.000 35 000 1.126.801 404414 D 115 116 117 Royal Company Cash Budget For the Quarter Ending June 30 January March February 18,000 Quarter 18,000 81,544 120 058 325,975 343,975 432 470 514,014 464,330 584,388 1,222,775 1,240,775 119 Cash balance, beginning 120 Add receipts: 121 Cash collections 122 Total cash available 123 224 Less disbursements: Direct materials 126 Direct labor 127 Manufacturing overhead Selling & administrative Equipment purchases Dividends Total disbursements 125 25,509 91,575 96 147 64 200 + 33,410 64,350 90,157 62,040 144,000 27,668 69,300 91246 64,200 152,000 86,587 225225 277,550 208,440 296,000 35,000 1,128,801 129 230 35,000 312.431 393,957 404.414 132 13 Excess (deficiency) of cash available over disbursements 31,544 120 058 179,974 111,974 134 136 50,000 135 Financing Borrowings 137 Repayments Interest 219 Total financing 140 141 Cash balance, ending 50,000 (50,000) (2.250) (2,250) (50,000) (2.250) (52 250) 138 50.000 0 81,544 120,058 127 724 109.724 50.000 0.25 143 Interest 144 2.250 Instructions A. Input A. Template Parts B, C and D + Ready 14. BUDGETED INCOME STATEMENT 147 1,398,300 611,199 787 101 217440 569,661 2.250 567411 Computation of net sales Sales Less uncollectible amounts a Net sales 143 Okay Co 149 Budgeted Income Statement 150 For the Quarter Ending March 31 151 193 Net sales 353 Cost of goods sold 14 Gross margin 155 Seiling & administrative expenses 154 Net operating Income 353 Interest expense 15 Net Income 159 360 161 30 16 164 BEGINNING BALANCE SHEET 1.398 300 0 1,398,300 Computation of cost of goods sold Budgeted sales (units) Unit product cost Cost of goods sold 23.700 26 611,199 (Based on information given, beginning balances and calculations) Okay Co Balance Sheet 31-Mar 18,000 164 SET 16 ic To Current assets 121 Cash 122 Accounts receivable Raw materials inventory 174 Finished goods inventory 1. Plant and equipment 170 Land Instructions A input 18,000 400,000 Parts , and + A. Template 164 BEGINNING BALANCE SHEET 165 (Based on information given, beginning balances and calculations) 166 167 Okay Co Balance Sheet 31-Mar 18,000 168 169 170 Current assets: 171 Cash 172 Accounts receivable 173 Raw materials inventory 174 Finished goods Inventory 17s Plant and equipment: Land 177 Buildings and equipment Accumulated depreciation 179 Total assets 18,000 176 400,000 1,610,000 (750,000) 178 1,260,000 1,278,000 180 12 1 Liabilities: Accounts payable 10 Stockholders' equity Common stock 1 Retained earnings 1 Total liabilities and stockholders' equity 184 200,000 1,143,200 1,343,200 1,343,200 187 188 Okay Co. Budgeted Balance Sheet 30 Jun 189 190 191 13 Current assets 193 Cash 194 Accounts receivable Instructions Ready 127 724 175,525 Parts B. Cand D + A Input A Template 22 @ NE sty AMA 187 188 189 Okay Co. Budgeted Balance Sheet 30-Jun 190 191 127,724 175,525 3,147 34,170 340,5 400,000 1,906,000 (807,000) 1.499,000 1,839,566 192 Current assets: 193 Cash 194 Accounts recevable 195 Raw materials inventory 196 Finished goods inventory 192 Plant and equipment: 198 Land 199 Buildings and equipment 200 Accumulated depreciation 201 Total assets 202 203 Llabilities: 204 Accounts payable 205 Stockholders' equity Common stock Retained earnings 200 Total liabilities and stockholders' equity 209 210 211 212 11.155 200 207 200,000 1,675,611 1,875,611 1,886,766 210 214 Instructions A. Input A. Template Parts B, C and D M N 0 A1 1 x fx Part 1 (Chapter 22) 8 C D E 1 G H 14 Sauny a couple Terre 15 16 Requirement B 12 1. What are the budgeted sales for February? 18 2. What are the expected cash collections for February? 19 3. What is the accounts receivable balance at the end of March? 20 4. What is the estimated cost of raw materials purchases for February 21 5. What is the estimated accounts payable balance at the end of March? 22 6. What is the estimated finished goods inventory balance at the end of March? 23 7 What is the estimated cost of goods sold and gross margin for March? 24 8. What is the estimated total selling and administrative expense for February? 25 9. What is the estimated net operating Income for March? 26 10. What is the estimated retained eamings balance for March? 27 24 Part 1 Chapter 25) 29 Requirement C This question is assignment version specifc. Please refer to the assignment document for further 30 details 31 12 Requirement D This question is assignment version specife. Please refer to the assignment document for further 31 details 36 35 36 1 39 40 41