Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales.

Sales in January and February were $13,500 and $13,000 respectively.
Experience has shown that 10 percent oftotal sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale.
Prepare a monthly cash receipts schedule for the firm for March through August. 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?

Transcribed Image Text:

March $14,000 $12,000 June April May July 16,000 17,000 10,000 August 18,000