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

  The manufacturing overhead budget of lewison corporation is

the manufacturing overhead budget of lewison corporation is based on budgeted direct labor-hours. the june direct labor

  Which one of the following assumptions or principles most

1. under current gaap most resources of a business entity are to be valued in its financial statements ata. a value

  City shoes insurance expense for the year totaled 6300 and

city shoes insurance expense for the year totaled 6300 and is to be allocated on the basis of the book value of

  Abc auto insurance classifies drivers as good medium or

abc auto insurance classifies drivers as good medium or poor risks. drivers who apply to them for insurance fall into

  Gigi leblanc founded a company to produce a special bicycle

gigi leblanc founded a company to produce a special bicycle suspension system several years ago after her son who

  What is an intangible asset should all intangible assets

what is an intangible asset? should all intangible assets be subject to amortization? explain why or why not. why is

  Prepare schedules for expected collections

Prepare schedules for expected collections from customers and expected payments for direct materials purchases - prepare a cash budget for January and February in columnar form.

  Accounting objective questions

objective questions: Kovacic Company purchased a computer that cost $10,000. It had an estimated useful life of five years and residual value of $0. The computer was depreciated by the straight-line method and was sold at the end of the fourth year o..

  What is the effect of refund on yellow 2006 tax liability

The Yellow Appliance Company, an accrual basis taxpayer, sold goods in December 2005 for $10,000 under terms which allowed the customer to return the goods and receive a refund within 60 days of the sale.

  A company wishes to buy new equipment for 85000 the

a company wishes to buy new equipment for 85000. the equipment is expected to generate an additional 35000 in cash

  Francis corporation purchased an asset at a cost of 69700

francis corporation purchased an asset at a cost of 69700 on march 1 2012. the asset has a useful life of 8 years and a

  Implement scorecard in the norwalk pharmaceutical division

Are there any parts that should be excluded or cannot be made operational? What are the scorecard measures you would use to implement your scorecard in the Norwalk Pharmaceutical Division? What are the new measures that need to be developed, and h..

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