Managements policy is to maintain ending finished goods

Assignment Help Accounting Basics

Reference no: EM13589238

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.

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: EM13589238

Questions Cloud

A new textbook is published in the spring of 2014 your : a new textbook is published in the spring of 2014. your campus bookstore buys 445 copies at 77 each in june an

Taking the negative direction to be downward what is the : question a 0.410-kg ball is dropped from rest at a point 4.30 m above the floor. the ball rebounds straight upward to a

Rockland corporation earned net income of 321000 in 2012 : rockland corporation earned net income of 321000 in 2012 and had 100000 shares of common stock outstanding throughout

Two capacitors one 120 microf and the other of unknown : two capacitors one 12.0 microf and the other of unknown capacitance are connected in parallel across a battery of emf

Managements policy is to maintain ending finished goods : rolen inc. is in the process of preparing the fourth quarter budget for 2010 and the following data have been

Explain a specific contribution this group made to american : in 1908 playwright israel zangwill referred to america as a melting pot. zangwills concept of the united states as a

Ellison inc a manufacturer of steel school lockers plans to : ellison inc. a manufacturer of steel school lockers plans to purchase a new punch press for use in its manufacturing

In living tissue about one out of every 10-12 carbon atoms : in living tissue about one out of every 10-12 carbon atoms are the 14c isotope. if you were to discover a human bone

Superior corporation acquired taylor corporation pursuant : superior corporation acquired taylor corporation pursuant to a statutory merger under state law. as a result of the

User Account

All Pages