Prepare a schedule of cash collections from sales by month

Reference no: EM13598431

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 $25 per unit. The estimated sales volume for the next six months is as follows:

September 13,000 units
October 12,000 units
November 14,000 units
December 20,000 units
January 9,000 units
February 10,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 $211,000 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,600 units.

To make one unit of finished product, 5 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 25,200 pounds on September 30, 2010.

The cost per pound of raw material is $2, 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 $37,980 on September 30, 2010.

Required:
(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.)

October November December Total
Expected sales in units
Selling price per unit $ $ $ $
Total sales $ $ $ $

(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.)
Cash collections from: October November December Total

September sales $ $
October sales $
November sales $
December sales

Total cash collections $ $ $ $

Reference no: EM13598431

Questions Cloud

What arguments can be advanced in favor of treating fixed : what arguments can be advanced in favor of treating fixed manufacturing overhead costs as product costs? what arguments

Calculate the number of pounds of raw materials to be : osage inc.. has actual sales for june and july and forecast sales for august september october and november as follows

Assume that supermart inc has decided to surface and : assume that supermart inc. has decided to surface and maintain for 10 years a vacant lot next to one of its

Choose two competitor companies that are us gaap publicly : choose two competitor companies that are u.s. gaap publicly traded companies. determine and compare their net profit

Prepare a schedule of cash collections from sales by month : rolen inc. is in the process of preparing the fourth quarter budget for 2010 and the following data have been

The patent was acquired in january 2010 and has a useful : p9-4b the intangible assets section of the balance sheet for gore company at december 31 2010 is presented here.patents

Investors and creditors are interested in the probability : 1. investors and creditors are interested in the probability that their original investment or loan will eventually be

The buildings are estimated to have a 40-year life and no : at december 312010 kretsinger corporation reported these plant assets.land 4000000buildings 28500000less accumulated

The concepts principles and standards specifying the : 1. which of the following is not characteristic of financial accounting? a. information used in financial statements is

User Account

All Pages