A) Complete a cash collections schedule from the given information:

	July	August	September	Total
Budgeted Sales	$300,000	$400,000	$500,000	$1,200,000

Beginning A/R balance for July is $125,000. Collections pattern is 65% in the month of sale, 35% the month following sale.

	July	August	September	Total
Beginning A/R
July Sales
August Sales
September Sales
Total

B) Complete a production budget from the given information:

	July	August	September	Total
Budgeted Sales in units	60,000	40,000	70,000	170,000

The company desires an ending inventory balance of 20% of the following months budgeted sales. The beginning inventory balance at the start of July was 12,000 units. Budgeted sales for October is 50,000 units.

	July	August	September	Total
Budgeted Sales
+Desired ending inv.
= total needs
-Beginning inv.
=Total Production