Problem: Elm Company makes a product that has peak sales in September of each year. The company has prepared a sales budget for the third quarter of 2003, as shown below.
July August September
Budgeted sales $500,000 $600,000 $750,000
The company is in the process of preparing a cash budget for the third quarter and must determine the cash collections by month. Collections on sales are expected to be as follows.
70% in the month of sale
20% in the month following the month of sale
8% in the second month following the month of sale
2% uncollictible
The accounts receivable balance as of June 30 is $195,000, of which $45,000 represents uncollected May sales and $150,000 represents uncollected June sales.
a. What were the total sales for May and June?
b. What are the expected cash collections for each month of the third quarter.