i only need the last picture solved. The rest is just information to help you solve it.

input sheet:

master budget sheet

problem i need solved

1 Master Budget Okay Co. 2 Input Section 3 4 6 5 Sales Budget Expected unit sales in the first quarter 7 January 8 February 9 March 10 April 11 May 8,500 6,700 8,500 5,300 6,300 12 13 $ 59.00 Selling price 14 15 Cash Collections 16 Beginning Balance 17 Collected in month of sale 18 Collected in the month following sale 19 Uncollectible amount $ 65% 35% 0% 20 21 Production Budget 22 % of next month's 25% sales 0 units 23 Desired ending inventory Beginning Inventory 24 25 Raw Materials Budget 26 Raw materials per unit 27 Cost per pound 28 Desired ending inventory 29 Beginning inventory 30 31 Cash payments Instructions $ 7 pounds 0.54 15% 0 pounds A. Innut 31 Cash payments 32 Beginning balance Pald in month of purchase Paid in the month following purchase 0 60% 40% 33 34 35 36 Direct Labor Budget 37 Direct labor hours per unit Direct labor cost per hour 0.60 38 $ 15.00 39 41 40 Manufacturing Overhead Budget Variable Manufacturing Overhead Rate Fixed Manufacturing Overhead Rate Depreciation 42 $ $ $ 3.30 per hour 92,000 per month 16,000 per month 43 44 46 45 Selling and Administrative Expense Budget + Variable Selling & Admin Rate Fixed Selling & Admin Rate $ Depreciation $ 47 1.20 per unit 63,000 per month 9,000 per month 48 49 51 $ 50 Cash Budget Beginning balance 52 Dividends 53 Purchase of equipment 54 Purchase of equipment 55 Interest Rate A la $ $ $ 18,000 35,000 first month 144,000 Isecond month 152,000 third month 18% 56 57 58 59 60 61 52 Instructions Innut A Tomato Dosta Master Budget 2021 1 Okay Co. 2 3 January 4 February 5 March 6 April 7 May 8.800 units 6,700 units 8.500 units 5.300 units 6.300 units January February 8,500 59 501 500 March 6.700 59 395 300 8,500 59 501,500 Quarter April 23,700 59 1,398,300 May 5,300 59 312,700 6300 59 371,700 Quarter March January SALES BUDGET 10 11 Budgeted sales (units) 12 Selling price per unit 1 Total sales 14 15 SCHEDULE OF EXPECTED CASH COLLECTIONS 16 17 Accounts receivable beginning balance 15 April sales 20 April 21 May 22 May sales May 24 June 25 June sales 35 June * Total cash collections February 0 325975 o 325,975 175,525 175,525 21 256,945 138,355 256.945 138,355 O 325.975 1.222,775 $ 325,975 464 330 325,975 432 470 1,222,775 * PRODUCTION BUDGET 31 February March Quarter April May January Parts B, C and D Instructions A Input A. Template + G March 6.300 6,700 2.125 8,825 1,875 7,150 8.500 1,325 9.825 2,125 7,700 Quarter April 23.700 1325 25.025 0 25.025 May 5.300 1,575 6.875 1325 5,550 1325 (1.325 25 PRODUCTION BUDGET 30 31 January February Budgeted sales 8.500 30 Add desired ending Inventory 1,675 3 Total needs 10,175 35 Less beginning inventory 0 36 Required production 10,175 17 30 DIRECT MATERIALS BUDGET 39 40 January February 4. Required production in units 10.175 4 Raw materials per unit (pounds) 7 4 Production needs (pounds) 71225 Add desired ending Inventory (pounds) 7508 45 Total needs (pounds) 78,733 44 Less beginning inventory (pounds) 0 Raw materials to be purchased (pounds) 76.733 Cost of raw materials to be purchased at $0.40 per pound 42516 40 sSCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR MATERIAL April March 7,150 May 5.550 7 38.850 (1325) 7 (9275) 50050 8085 58,138 7508 50620 Quarter 25025 7 175 175 5828 181,003 0 181,003 7,700 7 53,900 5828 59,728 8,085 51.643 27339 27 287 97 741 January February 0 March 52 Accounts payable beginning balance April purchases: 55 Apri May 37 May purchases Mav Instructions A input A. Template 25 100 Quarter 0 0 25,809 17 006 0 16402 17 000 1R 403 Parts B, C and D T March Quarter 0 0 25,509 17,006 o 16,403 10,936 17.006 16,403 10,936 SO SCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR MATERIAL 51 52 January February 0 53 Accounts payable beginning balance 54 April purchases: 55 April 25,509 56 May 57 May purchases S8 May 59 June 50 June purchases: 61 June 62 Total cash disbursements for materials 25,509 63 64 DIRECT LABOR BUDGET 65 66 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 91575 16,732 27,660 16,732 86,587 33.410 0 March 7,150 1 4,290 15 64,350 7.700 1 4,620 15 69,300 Quarter 25,025 1 15,015 15 225,225 22 MANUFACTURING OVERHEAD BUDGET 74 75 76 Budgeted direct labor-hours 7 Variable manufacturing overhead rate 78 Variable manufacturing overhead 72 Fixed manufacturing overhead 10 Total manufacturing overhead Instructions A. Input A. Template January February 6105 3 20.147 92.000 112.147 Parts B, C and D March 4,290 3 14,157 92,000 106.157 4,620 3 15.246 92.000 107 246 Quarter 15.015 3 49,550 276.000 325 550 + C D E F 7 MANUFACTURING OVERHEAD BUDGET 70 75 January February 6,105 3 20,147 92,000 112,147 16,000 95,147 March 4.290 3 14,157 92.000 106.157 16.000 90,157 4,620 3 15 246 92,000 107246 18,000 91 246 Quarter 15.015 3 49,350 276,000 325,550 48.000 277.550 76 Budgeted direct labor-hours 77 Variable manufacturing overhead rate 7 Variable manufacturing overhead Fbed manufacturing overhead 80 Total manufacturing overhead 21 Loss depreciation - Cash disbursements for manufacturing overhead 83 34 ENDING FINISHED GOODS INVENTORY BUDGET 85 e Computation of absorption unit product cost: RT Direct materials 89. Direct labor 10 Manufacturing overhead Unit product cost Total Quantity 7 pounds 1 hours 1 hours 4 Cost 1. per pound 15 per hour 22 per hour 9 12 26 92 Predetermined Overhead Rate Total manufacturing overhead Total direct labor hours 22 325,550 15.018 90 Budgeted ending finished goods inventory * Ending finished goods Inventory in units - Unit product cost 100 Ending finished goods inventory in dollars 101 101 SELLING AND ADMINISTRATIVE EXPENSE BUDGET 1325 20 34,170 Instructions A. Input A. Template Parts B, C and D + Ready 033 X-32% Input 1522 C D 8.500 1 10.200 63,000 73 200 9.000 Quarter 23,700 1 28.440 189.000 217440 9,000 102 SELLING AND ADMINISTRATIVE EXPENSE BUDGET 103 104 January February March 105 Budgeted sales in units 8.500 6.700 106 Variable selling and administrative expense per unit 11 1 107 Variable selling and administrative expense 10,200 8040 100 Fbred selling and administrative expense 63.000 63.000 100 Total selling and administrative expense 73,200 71,040 110 Loss depreciation 9,000 9,000 Cash disbursements for selling and administrative 111 expenses 64 200 62.040 112 113 CASH BUDGET 114 Royal Company 115 Cash Budget 116) For the Quarter Ending June 30 117 118 January February March 119 Cash balance, beginning 18.000 81.544 120 Add receipts: 121 Cash collections 5 325,975 432470 122 Total cash available 343.975 514,014 64,200 208.440 Quarter 18,000 120,058 464,330 584,388 1222.775 1240.775 124 Less disbursements: 325 Direct materials 126 Direct labor 127 Manufacturing overhead 120 Selling & administrative 129 Equipment purchases 130 Dividends 131 Total disbursements Instructions A. Input 25,509 91575 96 147 84200 33 410 64,350 90,157 62.040 144 000 27,668 69,300 91.246 84200 152.000 86,587 225 225 277,550 208.440 298,000 35,000 1,128 801 35,000 312431 Parts B, C and D + 393,957 404414 A. Template Ready D 114 115 Royal Company Cash Budget For the Quarter Ending June 30 116 117 January March February 18,000 Quarter 18,000 81,544 120,058 325,975 343 975 432,470 514,014 464330 584,388 1222,775 1.240.775 119 Cash balance, beginning 120 Add receipts: 121 Cash collections 122 Total cash available 123 124 Less disbursements: 125 Direct materials 126 Direct labor 127 Manufacturing overhead 128 Selling & administrative 125 Equipment purchases Dividends 121 Total disbursements 132 25,509 91,575 98,147 64,200 33.410 64,350 90,157 62,040 144,000 27,668 69,300 91,246 64 200 152,000 86,587 225, 225 277,550 208 440 298,000 35,000 1,128,801 130 35,000 312431 393,957 404.414 120,058 179,974 111,974 133 Excess (deficiency) of cash available over disbursements 31,544 134 135 Financing D3G Borrowings 50,000 137 Repayments 138 Interest 139 Total financing 140 14 Cash balance, ending 81544 142 14 Interest 50 000 Instructions A. Input A Template Parts B, C and D + Ready (50,000) (2 250) (52.250) 50,000 50,000) (2.250) (2.250) 50p 0 120,058 127,724 109,724 0 0.25 2.250 TE 146 BUDGETED INCOME STATEMENT 147 140 Oksy Co. 149 Budgeted Income Statement 150 For the Quarter Ending March 31 151 152 Net sales 153 Cost of goods sold 154 Gross margin iss Selling & administrative expenses 156 Net operating Income 157 Interest expense 1s Net Income 156 360 161 162 1,398,300 611,199 787 101 217 440 569.661 2.250 567411 Computation of net sales Sales Less uncollectible amounts Net sales 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 164 BEGINNING BALANCE SHEET 165 (Based on information given, beginning balances and calculations) 167 Okay Co. Balance Shoot 31-Mar 18,000 - - 168 169 170 Current assets: 171 Cash 122 Accounts receivable 171 Raw materials inventory 14 Finished goods inventory 17 Plant and equipment: IN Land Instructions A Input Ready 18.000 400,000 Parts B, C and D + A. Template O 164 BEGINNING BALANCE SHEET Based on information given, beginning balances and calculations) 165 166 Okay Co. 167 Balance Sheer 168 31-Mar 169 170 Current assets: 171 Cash 18,000 122 Accounts receivable 173 Raw materials inventory 174 Finished goods inventory 18,000 17 Plant and equipment: Land 400,000 177 Buildings and equipment 1,610,000 178 Accumulated depreciation (750,000) 1,260.000 179 Total assets 1,278.000 150 181 Llabilities: 132 Accounts payable 183 Stockholders' equity 134 Common stock 200,000 185 Retained earnings 1,143,200 1,343,200 186 Total liabilities and stockholders' equity 1,343,200 182 180 Okay Co. 189 Budgeted Balance Sheet 30-Jun 190 150 Current assets: Cash 194 Accounts receivable Instructions Ready 127,724 175,525 Parts B, C and D + A. Input A. Template 127,724 175,525 3,147 34,170 196 340,566 188 Okay Co. 189 Budgeted Balance Sheet 190 30-Jun 191 192 Current assets: 193 Cash 194 Accounts receivable 195 Raw materials inventory Finished goods inventory 197 Plant and equipment: 198 Land 199 Buildings and equipment 200 Accumulated depreciation 201 Total assets 202 203 Llabilities: 204 Accounts payable 205 Stockholders' equity 206 Common stock 207 Retained earnings 204 Total liabilities and stockholders' equity 209 210 211 212 400,000 1,906,000 (807,000) 1,499,000 1,839,566 11,155 200,000 1,675,611 1,875,611 1,886,766 4 213 214 Instructions A. Input A. Template Parts B, C and D + + D 14 15 Requirement This question is assignment version specific. Please refer to the assignment document for further detalls. Reference the DATA from your master budget. 12 11 19 -20 21 22 21 24 25 26 27 25 29 Decision 30 23 12 23 Requirement This question is assignment version specific. Please refer to the assignment document for further details. Reference the DATA from your master budget. 15 35 17 39 40 41 46 46 Decision 48 50 51 52 50 Instructions A. Input A. Template Parts B, C and D + Ready News earnings balance to Part II (Chapter 25) (50 points) C. Assume that Okay expects to produce and sell 95,000 units during the current year. One of Okay's sales representatives has found a new customer that is willing to buy 9,000 additional units for a price of $44 per unit. If they accept the customer's offer, it will decrease unit sales to regular customers by 5,000 units. Should they accept this special order? Show all work/calculations to justify your decision. D. Assume that Okay expects to produce and sell 22,000 units during the current quarter. A supplier has offered to manufacture and deliver 22,000 units for a price of $28 per unit. Should Okay accept this offer? How much will profit's increase or decrease? Show all work/calculations to justify your decision