Rolen, Inc., is in the process of preparing the fourth quarter budget for 2010, and the following data have been assembled:
| • |
The company sells a single product at a price of $51 per unit. The estimated sales volume for the next six months is as follows:
|
|
|
| September |
11,700 units |
| October |
10,800 units |
| November |
12,600 units |
| December |
18,000 units |
| January |
8,100 units |
| February |
9,000 units |
|
| • |
All sales are on account. The company's collection experience has been that 30% of a month's sales are collected in the month of sale, 68% are collected in the month following the sale, and 2% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts receivable less allowance for uncollectible accounts) will be $405,756 on September 30, 2010.
|
| • |
Management's policy is to maintain ending finished goods inventory each month at a level equal to 30% of the next month's budgeted sales. The finished goods inventory on September 30, 2010, is expected to be 3,240 units.
|
| • |
To make one unit of finished product, 4 pounds of materials are required. Management's policy is to have enough materials on hand at the end of each month to equal 40% of the next month's estimated usage. The raw materials inventory is expected to be 18,144 pounds on September 30, 2010.
|
| • |
The cost per pound of raw material is $4, and 70% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. The accounts payable for raw material purchases is expected to be $54,691 on September 30, 2010.
|
| (a) |
Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2010. (Omit the "$" sign in your response.)
|
| (b) |
Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2010.(Omit the "$" sign in your response.)
|