I solved this question and mostly everything is correct but the part b uncollected amount is incorrect. I got $28900 first but that was incorrect too. I tried my best but its all incorrect.

Saved Help ter 4 Save & Exit Check my Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March April May $ 43,000 June 49,000 July 38,000 August $ 47,000 55,000 57,000 Sales in January and February were $46,000 and $45,000 respectively. Experience has shown that 10 percent of total sales are uncollectible 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale, a. Prepare a monthly cash receipts schedule for the firm for March through August January 46000 May Ed's Waterbeds Cash Receipts Schedule February March $ 45000 $ 43000 15050 20250 4600 Sales Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier 380 April $ 49000 17150 19350 4500 133 220 43 Total cash receipts $ 39900 $ 41000 5 398 Prev 1 of 2 !!! Ne ercent are collected in the month of sale, 45 percent are after sale. August Ed's Waterbeds Cash Receipts Schedule February March $ 45000 $ 43000 15050 20250 4600 April $ 49000 17150 19350 4500 May $ 38000 13300 22050 4300 June $ 47000 16450 17100 4900 July 55000 19250 21150 3800 August $ 57000 19950 24750 4700 $ 39900 $ 41000 $ 39650 $ 38450 44200 $ 49400 Prey 1 of 2 Next > Ed's Waterbeds Cash Receipts Schedule March $ 43000 January 46000 February 45000 April 49009 Sales $ $ Collections of current sales 15050 17150 20250 19350 Collections of prior month's sales Collections of sales 2 months earlier 4600 450 Total cash receipts $ 39990 $ 41800 b. Of the sales expected to be made during the six months from March to August, how much will still be uncollected at the end of August? How much of this is expected to be collected later? ho Amount 38000 Uncollected $ Expected to be collected $ 3685e Prev 1 of 2 !!! Next >