Prepare a direct materials budget for geico compound by

Assignment Help Accounting Basics
Reference no: EM13566992

Crydon, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget:

a.

The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins):


The selling price of the swim fins is $11 per pair.





  July

5,100  

  October

3,100  

  August

6,100  

  November

2,100  

  September

4,100  

  December

2,100  

b.

All sales are on account. Based on past experience, sales are expected to be collected in the following pattern:

43%

  in the month of sale

47%

  in the month following sale

10%

  uncollectible

The beginning accounts receivable balance (excluding uncollectible amounts) on July 1 will be $138,000.

c.

The company maintains finished goods inventories equal to 10% of the following month's sales. The inventory of finished goods on July 1 will be 510 pairs.

d.

Each pair of swim fins requires 2 pounds of geico compound. To prevent shortages, the company would like the inventory of geico compound on hand at the end of each month to be equal to 20% of the following month's production needs. The inventory of geico compound on hand on July 1 will be 2,080 pounds.

e. Geico compound costs $3.00 per pound. Crydon pays for 55% of its purchases in the month of purchase; the remainder is paid for in the following month. The accounts payable balance for geico compound purchases will be $10,900 on July 1.

Required:

1a: Prepare a sales budget, by month and in total, for the third quarter.

  July

   August

     September

    Quarter - Total

Total budgeted sales

$      

$      

$     

$    

1b.

Prepare a schedule of expected cash collections, by month and in total, for the third quarter. (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations.)

Schedule of Expected Cash Collections

Accounts receivable, beginning balance





July sales





August sales





September sales





Total cash collections





              July August September October

2.

Prepare a production budget for each of the months July through October.

(Input all amounts as positive values.)

Production Budget


    July

     Augus

September

    October

Production Budget


    July

     August

     September

    October

  Budgeted sales (pairs)





  :






  Total needs





  :






  Required production (pairs)






Budgeted sales (pairs)

3a.

Prepare a direct materials budget for geico compound, by month and in total, for the third quarter.(Do not round intermediate calculations. Round your answers to the nearest dollar amount. Input all amounts as positive values.)

Direct Materials Budget


    July

      August

       September

     Quarter - Total

  Production needs (lbs.)





  :






  Total needs





  :






  Raw materials to be purchased






  Cost of raw materials to be purchased

$  

$  

$  

$  


3b.

Prepare a schedule of expected cash disbursements for geico compound, by month and in total, for the third quarter. (Do not round intermediate calculations. Round your answers to the nearest dollar amount. Leave no cells blank - be certain to enter "0" wherever required.)

Schedule of Expected Cash Disbursements


     July

        August

        September

      Quarter - Total

Accounts payable, beginning balance

$  

$  

$  

$  

July purchases





August purchases





September purchases






Total cash payments

$   

$  

$  

$  





Reference no: EM13566992

Questions Cloud

Which of the following journal entries is correct for smith : which of the following journal entries is correct for smith company when smith issues 10000 shares of 20 par value
The isberg company just paid a dividend of 075 per share : the isberg company just paid a dividend of 0.75 per share and that dividend is expected to grow at a constant rate of
Market price of the outstanding shares on december 31 was : a corporation was formed on january 1 and was authorized to issue 400000 shares of common stock at 2 par value. during
Outline descartes ontological argument for the existence of : each essay is between 250-400 words. extensive quotes do not count toward this. if you cannot answer a question in
Prepare a direct materials budget for geico compound by : crydon inc. manufactures an advanced swim fin for scuba divers. management is now preparing detailed budgets for the
The second is a preferred stock 100 par value that sells : the second is a preferred stock 100 par value that sells for 80 and pays an annual dividend of 12 and your required
Eectricity costs are 1200 per month plus 08 per car : auto lavage is a canadian company that owns and operates a large automatic carwash facility near quebec. the following
Sarp and townson had capital balances of 60000 and 120000 : sharp and townson had capital balances of 60000 and 120000 respectively on january 1 of the current year. on may 8
Rick thomas corp just issued a dividend of 240 per share on : rick thomas corp. just issued a dividend of 2.40 per share on its common stock. the company is expected to maintain a

Reviews

Write a Review

Accounting Basics Questions & Answers

  Balance in eve prepaid insurance

Eve's Apples opened business on January 1, 2010, and paid for two insurance policies effective that date. The liability policy was $36,000 for eighteen-months, and the crop damage policy was $12,000 for a two-year term. What was the balance in Eve..

  Assuming that nick and jolene have total allowable itemized

nick and jolene are married. nick is 61 and retired in 2011 from his job with amalgamated company. jolene is 56 and

  What is normans earnings per share

Norman Corporation had 250,000 shares of common stock outstanding during the year. Norman declared and paid cash dividends of $200,000 on the common stock and $160,000 on the preferred stock. Net income for the year was $880,000. What is Norman's ..

  Overhead applied to standard using activity-based costing

Donkey Company manufactures two products, Standard and DeLuxe. Donkey's overhead costs consist of machining, $2,000,000; and assembling, $1,000,000. Information on the two products is:

  Purchase price in the consolidated financial statement

How should you account for the difference between the carrying value and the purchase price in the consolidated financial statements for 2011?

  Problem related to beginning balance

If Cash has debit postings of $52,000, credit postings of $39,000, and a normal ending balance of $22,000, what was its beginning balance?

  What is the connection between cost of the ring major

what is the connection between cost of the ring major materialslabor overhead and the items price to a

  Regulatory requirements exist should articulate with the law

Policies in those areas where regulatory requirements exist should articulate with the law. Explain the process you would follow to ensure this, using the example of privacy (privacy policy and privacy laws).

  Williams corporation purchased a depreciable asset for

williams corporation purchased a depreciable asset for 400000 on january 1 2010. the estimated salvage value is 40000

  Total expenses for the year

Retained Earnings had a beginning balance of $2,758,000 and an ending balance of $3,885,700. Total revenues for the year were 3,790,800.

  An auditor must not only appear to be independent but must

an auditor must not only appear to be independent but must also be independent in fact. research the concept of

  At one time circle k was the second-largest convenience

at one time circle k was the second-largest convenience store chain in the united states. at its peak circle k operated

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