Homework: HW-7 Score of SP22-2 similar to) 103 cm r ese che Improved Learning Cash Budget For the Year Ended December 31, 2019 First Second Quarter Quarter 43,000 $ 40,600 533,400 403,200 576.400 443,800 Third Quarter Total Fourth Quarter 40,165 $ 636,800 40,350 827,200 43,000 2,400,600 867,550 676,965 2,443,600 Beginning cash balance Cash receipts Cash available Cash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (de ciency) Financing Borrowing Principal repayments Total effects of financing 45.000 188,600 156,600 143,100 69,000 3.500 0 605,800 (29,400) (40,000) (69,400) 45,000 176,700 97,200 133 200 55,800 3,500 1,050 512,450 (68,650) (40,000) (108,650) 183,580 113,400 135,900 61,800 3,500 90,000 792.880 576,000 564,000 265,200 14.000 244,000 208,800 151,800 78,600 3,500 2,685 689,385 178,165 (40,000) 138,165 615 4,350 498,795 2,306,430 178,170 (40,000) 137,170 (40,000) 138,170 97,170 70,000 109,000 179,000 (179,000) (138,000) (41.000) 70,000 40,600 $ 109,000 40,350 S (138,000) 40,165 S (41.000) 137,170 Ending cash balance 137,170 Print [Done] Suppose a change in the receipt of cash from sales on account is as follows: (Click the icon to view the revised receipt of cash information) Read the requirements yox is not used in the table, leave the box empty, do not enter a zero. Round your answers to the nearest dolar) Reference * More Info 60% in the quarter of the sale 20% in quarter after the sale 19% two quarters after the sale 1% never collected Improved Learning Sales Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter 1300 8005 300 $ 720,000 $ 200,000 $ 1.040.000 $ Total 350 Fourth Quarter 850 800 5 680,000 $ Print Budgeted tablets to be sold Sales price per unit Total sales Done 2.720.000 Print Done Homework: HW-7 Score: 0 of 1 pt SP22-2 (similar to) 1 of 3 (0 complete) Improved Learning had prepared the following sales budget, schedule of budgeted cash receipts and cash budget for 2019 Click the icon to view the original budgets) Improved Learning decided to revise its sales budget to show fourth quarter sales of 850 tables due to the expectation of increased holiday sales Click the icon to view the revised sales budget) Suppose a change in Pe receipt of ca Click the icon to view the revised Read the green Requirement 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts a box is not used in the tableave the box emply do not nerazer Schule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter 720000 200000 1040000 480000 First Second Third Fourth Quarter Quarter Quarter Quarter Cash Rereits from Customers Accounts Receivate balance December 31, 2018 0 Requirements 1st -Cash sales ist on Credit sales collected in t he 1. Revise the schedule of bugeted cash recepto include the increase in ist Or d sales colected in and the fourth quarter sales and the change in the wing of customer recept 2. How will the changes in cash recipes afect the cash budget? ist Cases corded 2nd Cash 2nd obedeceded in 2nd 2nd QtrCondt sales colected in aedah 2nd Credit sales collected in the 3rd Cash sales 3rd Credit ses colected in edhe 3rd Credit sales collected in the 4th Cash sales 4th Our Credit sales collected in the Total cash receipts from customers Pont Done Enter any number in the edit fields and then click Check Answer 1