Prepare cash budget for the year-review financial statements

Assignment Help Cost Accounting
Reference no: EM13325872

Question 1 Relevant Costing

The Claypot division of Housewear Products Inc. makes ceramic pots that are used to hold large decorative plants. During 2012, the division produced 10,000 pots and incurred the following costs:

Unit-level materials costs (10,000 ® $15)                                                $150,000

Unit-level labor costs (10,000 ® $20)                                                           200,000

Unit•level overhead costs (10,000 ® $16)                                                 160,000

Depreciation expenses on equipment*                                                         30,000

Other manufacturing overhead**                                                                  36,000

*The equipment was purchased for $170,000 and has a current book value of $140,000, remaining useful life of four years, and a $20,000 salvage value at the end of its useful life. If the company does not use the existing equipment, it can be leased to another company for $20,000 per year for the next four years.

**Includes supervisors' salaries and rent for manufacturing plant.

Required:

The division is considering replacing the equipment used to manufacture its ceramic pots. Replacement equipment can be purchased at a price of $240,000. The new equipment, which is expected to last 4 years and have a salvage value of $40,000, will reduce unit-level labor costs by 40 percent.

(a) Assuming the division desires to maintain its production and sales at 10,000 ceramic pots per year, prepare a schedule that shows the relevant cost of operating the existing equipment versus the cost of operating the new equipment for a four year time period.

(b) Should the existing equipment be replaced based upon your quantitative analysis? Explain your answer.

(c) Discuss several other qualitative and/or quantitative factors that could influence the decision whether to replace the old equipment with the new equipment at this time. Be as specific as possible.

Question 2 Budgeting

Linda Johnson and Torn Scott recently graduated from Northeastern University. After graduation they decided not to work for their previous coop employers but, rather, to start their own small business hoping they could have more flexibility in their personal lives for a few years. Linda's family has operated Mexican restaurants and taco-trucks for the past twenty years, and Linda noticed there were no taco-truck services in the Boston, close to Northeastern. To reduce the amount they would need for an initial investment, they decided to start a business operating a taco-cart rather than a taco-truck, from which they would cook and serve traditional Mexican styled street food.

They started their business on September 1, 2012. The first thing they bought was a used tacocart for $15,000. This cost, along with the cost for supplies to get started, a business license, and street vendor license brought their initial expenditures to $20,000. Five-thousand dollars came from personal savings they had accumulated by working on coop assignments during college, and they borrowed $15,000 from Linda's parents. They agreed to pay interest on the outstanding loan balance each month based on an annual rate of 6 percent. They will repay the principal over the next few years as cash becomes available. They were able to rent space in The Camden Street parking lot near Northeastern's campus, believing that the students would welcome their food as an alternative to the typical fast food that was currently available in the student center.

After two months in business, September and October, they had average monthly revenues of $20,000 and out of pocket costs of $16,000 for rent, ingredients, paper supplies, and so on, but not interest. Torn thinks they should repay some of the money they borrowed, but Linda thinks they should prepare a set of forecasted financial statements for their first year in business before deciding whether or not to repay any principal on the loan. She remembers a bit about budgeting from the managerial accounting course she took and thinks the results from their first two months in business can be extended over the next 10 months to prepare the budget they need.

They estimate the cart will last at least five years, after which they expect to sell it for $5,000 and move on to something else in their lives. Linda agrees to prepare a forecasted (proforma) income statement and balance sheet, along with a cash budget for their first year in business, which includes the two months already passed.

Required:

a. Prepare the annual pro forma financial statements (income statement and balance sheet) that you would expect Linda to prepare based on her comments about her expectations for the business. Assume no principal will be repaid on the loan. The accounting period begins on September 1, 2012 through August 31, 2013.

b. Prepare a cash budget for the year for the period September 1, 2012 through August 31, 2013. Would Linda and Tom be able to afford upgrading their taco cart to a taco truck at an additional cost of $45,000?

c. Review the financial statements and cash budget prepared above. What are some reasons that the actual results may not appear the same as the budgeted financial statements?

Reference no: EM13325872

Questions Cloud

Explain the molecular nature of matter and change problem : The Molecular Nature of Matter and Change problem 78p I am stuck on the standard heats of reactions. I do not know what those are, but they are crucial for the problem
Prepare a schedule that shows the relevant cost : Prepare a schedule that shows the relevant cost of operating the existing equipment versus the cost of operating the new equipment for a four year time period - Should the existing equipment be replaced based upon your quantitative analysis? Explai..
Compute the value of x that makes the two alternatives equ : If the MAAR is 12 percent, compute the value of X that makes the two alternatives equally desirable.
Demonstrate qualitative and quantitative reasoning : Demonstrate qualitative and quantitative reasoning
Prepare cash budget for the year-review financial statements : ACCT 2301 Summer 2, 2013a. Prepare the annual proforma financial statements that you would expect Linda to prepare based on her comments about her expectations for the business.
Sodium carbonate is used to neutralize the sulfuric acid : Sodium carbonate (Na2CO3) is used to neutralize the sulfuric acid spill. How many kilograms of sodium carbonate must be added to neutralize 2.01×10^3kg of sulfuric acid solution
Please explain the reasons that we have to check : Please explain the reasons that we have to check "heteroskedasticity robust standard errors" when we have heteroskedasticity issue?
How much work is done by such proteins : Biological muscle cells can be thought of as nanomotors that use the chemical energy of ATP to produce mechanical work. How much work is done by such proteins
Evaluate theph at the equivalence point in titrating : Calculate thePH at the equivalence point in titrating 0.100 M solutions of each of the following with 9.0×10?2 M NaOH for hydrobromic acid (HBr). HCLO2 chlorous acid, C6H5COOH benzoic acid

Reviews

Write a Review

Cost Accounting Questions & Answers

  Estimate an appropriate option pricing model

Two million options were forfeited when an executive resigned in 2012. All other options were exercised on 12th July, 2015, when the stock's price jumped unexpectedly to $19 per share.

  Calculate the balance in ending work in process

Calculate the balance in ending work in process and cost of goods sold before any adjustments for under- or overallocated overhead and calculate under- or overallocated overhead.

  What are the relevant factors in the decision

What are the relevant factors in the decision and which alternative is in the best interest of the company over the next two years? Show your calculations.

  How the advanced cost accounting focuses on the significance

The study of advanced Cost accounting focuses on the significance of analyzing and managing costs; activity-based management, process costing and cost allocation; planning and decisions making, and evaluating and managing performance.

  Capitalize on a unique investment opportunity

The bank will charge a 2 % finance charge on the amount of receivables transferred. The bank will collect receivables straight from customers. The sale criteria are met.

  How many units must howell industries sell

Howell Industries has total fixed costs of $150,000 and the company's contribution margin represents 60% of revenue per unit, Last year, Howell Industries earned $50,000 pre-tax, and this year it would like to improve that figure by 20%.

  Compute net present value of both projects

Big Shot Market is considering two investment projects: Project A Project B Initial Cost 250,000 200,000 Number of Periods 5 5 Yearly Net Cash Flow 75,000 60,000 Cost of Capital (WACC) 5% 5%

  What is the balance in cartwrights capital account

What is the balance in Cartwright's capital account at the end of that year?

  What is the breakeven point in sales units

What is the breakeven point in (a) sales units and (b) sales dollars and how many units must Peerless Company sell to earn a profit of $600,000 per year?

  Prepare easy fictitious financial statements

Evaluate the detail information - Prepare easy fictitious financial statements and write notes for the fictitious annual report.

  Unfavorable labor rate variance

An unfavorable labor rate variance can occur if workers with high hourly wage rates are assigned to work on products whose standards assume workers with low hourly wage rates.Throughput time is the amount of time required to process raw materials i..

  Define internal control deficiencies

For each of the subsequent items, reply A (Agree) or D (Disagree) indicating whether the item shows an internal control deficiency.

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