Watts Lighting Stores made the following sales projection for the next six months. All sales are credit sales.

March	$	38,000	June	$ 42,000
April		44,000	July	50,000
May		33,000	August	52,000

Sales in January and February were $41,000 and $40,000, respectively. Experience has shown that of total sales, 10 percent 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.

Watt's Lighting Stores Cash Receipts Schedule

January

February

March

April

May

June

July

August

Credit sales

$

$

$

$

$

$

$

$

Collections:

In month of sale

$

$

$

$

$

$

One month after sale

Two months after sale

Total cash receipts

$

$

$

$

$

$

b.	Of the sales expected to be made during the six months from March through August, how much will still be uncollected at the end of August? How much of the uncollected amount does the firm actually expect to collect? (Leave no cells blank - be certain to enter "0" wherever required.)

Watts Lighting Stores Cash Receipts Schedule
Month of sale	Sales	Uncollected %	Uncollected $	Expect to collect %	Expect to collect $
August	$	%	$	%	$
July
June
May
April
March
		Totals:	$		$