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

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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