Prepare a merchandise purchases budget

Assignment Help Financial Accounting
Reference no: EM13789260

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. 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: EM13789260

Questions Cloud

What are some of the elements of sarbanes-oxley : From a practical perspective, what are some of the elements of Sarbanes-Oxley and Which of the following would be classified as tangible personal property, as opposed to other property categories, such as fixtures or intangible property
Social perceptions of the ethical fabric of entrepreneurs : Social perceptions of the ethical fabric of entrepreneurs is typically mixed. While entrepreneurs are many times seen as individuals who will stop at nothing as long as they achieve their goals, they also have a reputation to keep in their communi..
Equipment that cost-disposal under the assumptions : Vermeer's has equipment that cost $40,000 and that has been depreciated $29,000. Record the disposal under the following assumptions.
Rationale behind the different vesting schedules : Discuss the rationale behind the different vesting schedules and explain why an employer might choose one vesting schedule over another
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..
Types of biometrics issues : What are some of the limitations or challenges of your chosen biometrics related to criminal investigations?
What is the role of accounting in society : What is the role of accounting in society? Is accounting complete? Does it provide all of the information that investors and creditors need for rationale decision making?
Discussion of how project management software : Explain why IT projects (such as Web site development or redesign) are less likely to be delivered on time and within budget than large building construction projects.
Prepare a budgeted contribution margin income statement : Prepare a budgeted contribution margin income statement for 2015. Your reportshould show the budgeted (estimated) operating income based on the information provided above and in C3. Will the changes improve operating income sufficiently? Explain?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Within the relevant range

Within the relevant range: variable cost per unit decreases as production decreases. fixed cost per unit increases as production decreases. variable cost per unit increases as production decreases. fixed cost per unit decreases as production decrease..

  Effects on the accounts and financial statements

Illustrate the effects on the accounts and financial statements of the January 29 and May 31 transactions.

  Financial condition of bellwether garden supply

Analyze the financial condition of Bellwether Garden Supply, and interpret the result for company leaders.

  Compute grossfeld company receivables turnover

In 2012, Grossfeld Company has net credit sales of $1,600,000 for the year. It had a beginning accounts receivable (net) balance of $108,000 and an ending accounts receivable (net) balance of $120,000.

  Misstatement plus incremental allowance for sampling risk

Assume that you found one recorded amount of $4,863 that had an audited balance of $8,463. What is the projected misstatement plus incremental allowance for sampling risk? Show this in tabular form

  Prepare the journal entry for the issuance of the bonds

Intel Inc. is the pioneer in the manufacture of microprocessor for computers. The company's fiscal year runs from April 1 to March 31. On 4/1/2013, Intel Issued $5,000,000 of 11% Bonds due in 10 years.

  Compare additional effort associated with each modification

Modify the Excel Solver model solverRM2.xls and the AMPL model to account for the new situation and determine the optimum solution. Compare additional effort associated with each modification.

  Analyze the accounting for corporation requirements

Analyze the accounting for corporation requirements related to stock valuation, dividends, and retained earnings and determine how to value investments and how to report them based on that valuation.

  Show how such a payment will be treated

Show the likelihood of these payments being treated as constructive dividends. If a payment is deemed to be a constructive dividend, show how such a payment will be treated.

  What are the journal entry to record payroll tax expense

Assume earnings subject to state and federal unemployment compensation taxes are $5,250 at the federal rate of 0.8% and state rate of 5.4%. What are the journal entry to record the payroll tax expense for the period.

  Purpose journal entries to account for the foreign currency

Purpose journal entries to account for the foreign currency option, import purchase and firm commitment.

  Calculate a complete dupont analysis

Find their most recent annual report. Calculate a complete DuPont analysis calculating the ROE, ROA, the profit margin, total asset turnover and equity multiplier. Critique the differences between the two corporations in approximately 100 words.

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