Question

Schedule of Cash Receipts

Del Spencer is the owner and founder of Del Spencer's Men's Clothing Store. Del Spencer's has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern:

15 percent of credit sales are paid in the month of sale.
65 percent of credit sales are paid in the first month following the sale.
14 percent of credit sales are paid in the second month following the sale.
6 percent of credit sales are never collected.

Credit sales that have not been paid until the second month following the sale are considered overdue and are subject to a 3 percent late charge.

Del Spencer's has developed the following sales forecast:

May	$60,000
June	53,000
July	45,000
August	57,000
September	84,000

Required:

Prepare a schedule of cash receipts for August and September. Round all amounts to the nearest dollar.

Del Spencer's Men's Clothing Store
Schedule of Cash Receipts
For the Months of August and September
	August	September
Cash sales	$	$
Received from sales in:
June:
July:
August:
September:
Total cash receipts	$	$

Answer 1

all cash receivable and late fee calculations are shown with workings.

Del Spencer's Men's Clothing Store Schedule of Cash Receipts For the Months of August and September August September Cash sales $ 5,700 $ 8,400 (57000*10%) (84000*10%) Received from sales in: June: Normal Sale (53000*14%*90%) $ 6,678 $ - June: Late fee(53000*14%*90%*3%) 200 July:(45000*65%*90%) collected in August $ 26,325 July:(45000*14%*90%) collected in September $ 5,670 July:(45000*14%*90%*3%) late collected $ 170 August:(57000*15%*90%) collected in August $ 7,695 August:(57000*65%*90%) collected in Sepetmber $ 33,345 September:(84000*15%*90%) collected in September 11,340 Total cash receipts 46,598 $ 58,925