Prepare a merchandise purchases budget

Assignment Help Financial Accounting
Reference no: EM13789419

Welnor Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:

o Sales are budgeted at $320,000 for November, $340,000 for December, and $330,000 for January.

o Collections are expected to be 75% in the month of sale, 20% in the month following the sale, and 5% uncollectible.

o The cost of goods sold is 65% of sales.

o The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase.

o Other monthly expenses to be paid in cash are $21,000.

o Monthly depreciation is $16,000.

o Ignore taxes.

Statement of Financial Position

October 31

Assets  

Cash      $22,000

Accounts receivable (net of allowance for uncollectible accounts)             $82,000

Merchandise inventory                 $166,400

Property, plant and equipment (net of $658,000 accumulated depreciation)        $1,170,000

Total assets        $1,440,400

Liabilities and Stockholders' Equity          

Accounts payable            $199,000

Common stock $840,000

Retained Earnings            $401,400

Total liabilities and stockholders' equity                 $1,440,400

Required:

a. Prepare a Schedule of Expected Cash Collections for November and December.

b. Prepare a Merchandise Purchases Budget for November and December.

c. Prepare Cash Budgets for November and December.

d. Prepare Budgeted Income Statements for November and December.

 

e. Prepare a Budgeted Balance Sheet for the end of December.

Reference no: EM13789419

Questions Cloud

Local government can enforce a price-control law : If the local government can enforce a price-control law that sets the maximum price of $2.00, will there be a surplus or a shortage
History of conflict with female employees : Leonard Bailey is one of several partners in a medium sized (50 employees) CPA firm. Wilma Lawrence is the controller of ABC Manufacturing, one of Leonard’s clients. She has been with the company for 28 years and is very protective of what she consid..
The market structure is an oligopoly : Respond to the following questions: •You have just been hired by a company as an economist and strategic planner. Your company has asked you to generate a report explaining the consequences of the market structure in which the company operates. Assum..
Prepare the schools planning budget : Cecere Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Prepare the school's planning budget for Feb..
Prepare a merchandise purchases budget : Welnor Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $320,000 for November, $340,000 for December, and $330,000 for January. Prepare a Schedul..
Product adaptation is required in all exports true or false : Product adaptation is required in all exports . True or false?
What methods of concealment and fraud did he use : In ZZZZZ Best, Inc. Barry Minkow wowed Wall Street with his carpet cleaning company. What methods of concealment and fraud did he use? How could this fraud have been prevented? Discuss the safeguards that need to be implemented to avoid this manipula..
What are the tax planning considerations : What are the tax concepts involved in completing the Schedule A and Form 2441? Explain in detail. What are the tax planning considerations you took into account while completing the Schedule? What are the various steps and the calculations for each s..
Prepare the selling and administrative expense budget : The selling and administrative expense budget of Fenley Corporation is based on the number of units sold, which are budgeted to be 2,500 units in January. The variable selling and administrative expense is $4.40 per unit. Prepare the selling and admi..

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is the price variance for direct materials

Downward Inc. manufactures and sells a product, Z30. The per unit standards for the direct costs of product Z30 are as follows.

  Calculate dobbs total standard cost per unit

Manufacturing overhead: Overhead is applied at a rate of $6 per direct labor hour. Calculate Dobbs's total standard cost per unit. (Round computations and final answer to 2 decimal places

  Find the market price of the bonds be

Sinking fund payments for issue of debentures - Which of the two methods should Carter use to meet the current sinking-fund payment due shortly and find the market price of the bonds be?

  Explain how much revenue will circuittown recognize

CircuitTown considers gift cards to be “broken” (not redeemable) 10 months after sale. (For purposes of this question, assume that gift-card sales occur halfway through each month on average.). Explain how much revenue will CircuitTown recognize wi..

  Evaluation of market value of bond

Evaluation of Market value of bond at various rates and How much is it worth at a market rate of 8 percent?

  Problemwhile reviewing the march 31 2012 balance sheet of

problemwhile reviewing the march 31 2012 balance sheet of business solutions santana rey notes that the business has

  Cash basis accounting system

Are adjusting entries used in an accrual basis accounting system or in a cash basis accounting system?

  Liquidity and solvency of the company

The question is about ratio analysis finding out liquidity and solvency of the company - relative profitability of the companies by computing the net income and earnings per share for each company for 2007.

  Purchases nutritional supplements from a supplier

ABC Corporation regularly purchases nutritional supplements from a supplier in Japan with the invoice price denominated in Japanese Yen. ABC has experienced several foreign exchange losses in the past year due to increase in the U.S. dollar price to ..

  Calculate the ebit-eps indifference pointmorton industries

calculate the ebit-eps indifference point.morton industries is considering opening a new subsidiary in boston to be

  Which outlines key arguments and defines key terms

Discussion around a topic is not answering the question. It is often a helpful technique to use the essay question as part of your essay structure.

  Under the cash and the accrual basis of accounting

On April 1 Ivy Corp began operating a service company with an initial cash investment by shareholders of $1,000,000. The company provided $3,200,000 of services in April and received full payment in May. Ivy also incurred expenses of $1,500,000 in Ap..

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