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

Reviews

Write a Review

Accounting Basics Questions & Answers

  Claudia sells property for a sales price of 170000 in

claudia sells property for a sales price of 170000. in addition karma the buyer pays 5000 in property taxes that had

  Discount-mart issues 19 million in bonds on january 1 2012

1. tony hawks adventure tha issued callable bonds on january 1 2012. thas accountant has projected the following

  Length of the firm cash conversion cycle

For the Cook County Company, the average age of accounts receivable is 60 days, the average age of accounts payable is 45 days, and the average age of inventory is 72 days. Assuming a 365-day year, what is the length of the firm's cash conversion ..

  Determine the inventories direct material costs

JD Enterprises applies factry overhead based on dirct labor costs. The company incurred the following costs during 2003: dirct materials costs, $650000; direct labor costs, $3,000,000; and factory overhead costs applied, $1,800,000.

  Robertson inc prepares its financial statments according to

robertson inc. prepares its financial statments according to international financial reporting standards. at the end of

  A retailer purchases merchandise with a catalog list price

a retailer purchases merchandise with a catalog list price of 15000. the retailer receives a 15 trade discount and

  Determining foreign tax credit and total tax liability

Suppose a US corporation (tax rate 34%) with $2,500,000 of domestic income sets up a branch in Japan earning $800,000, where the tax rate is 50%. Also, assume I earned another $100,000 in interest revenue in a country with a 10% income tax rate.....

  Many companies publish their annual reports on their

many companies publish their annual reports on their website usually in an investor relations section. visit several

  Explain how the company should present this difference in

q1. when a company exchanges a note for property goods or services what value does it place on the notea. if it bears

  Determine the amounts that should be debited to land

Determine the amounts that should be debited to Land, to Buildings, and to Machinery and Equipment. Assume the benefits of capitalizing interest during construction exceed the cost of implementation.

  On august 1 2010 dambro co acquired 200 1000 9 bonds at 97

on august 1 2010 dambro co acquired 200 1000 9 bonds at 97 plus accrued interest. the bonds will be added to dambros

  Relevant measure of the value of equipment

When the balance sheet was prepared, the value of the equipment later rose to $22,000. What is the relevant measure of the value of the equipment?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd