Calculate break-even in units and sales for the company

Assignment Help Accounting Basics
Reference no: EM131539443

Accounting Project -

Green Thumb, Inc. has a factory that produces custom greenhouses and other garden related items.  It has multiple product lines.

Materials and labor for the green houses are determined by each job.  To simplify the assignment, we will assume the following average costs.

The company estimates that it will have 30,000 direct labor hours in total for the green houses.

The materials include $1,200 on a per job basis.  It requires 15 hours of labor on average for a custom greenhouse. The hourly rate is $10. The sales price will be set at a markup of 75%.

It assumes 2,000 units are sold on average per year.  A breakdown of estimated yearly costs related to the greenhouses follows. Please note that the amounts are per year unless identified otherwise:

Salaries- office & administrative

 $600,000

Salaries for factory supervisors and janitors

 $120,000

Office Rent

 $120,000

Factory Rent

 $90,000

Office Utilities and Misc office expenses(based on units sold)

 $20,000

Sales Travel(based on units sold)

 $24,000

Insurance - office

 $14,000

Depreciation - office equipment

 $45,000

Depreciation for factory equipment

 $55,000

Advertising

 $100,000

Sales commissions(based on units sold)

 $80,000

Factory Property taxes                      

 $10,000

Maintenance for factory equipment

 $60,000

QUESTIONS:

1. Please identify the following classifications for all costs above:  variable and fixed costs; product and period costs.  I would recommend that you show a schedule for each area on a yearly basis.  For the variable costs, also, show them on a per unit (2,000 units)  

How does a company identify each type of cost?  Can a cost classification be changed over time? If yes, explain how and give at least one example.  If no, explain why?

2. Determine the average cost of manufacturing one custom greenhouse assuming the units given. 

Assume the MOH costs are allocated based on the direct labor hours per unit.  Please show all calculations and round to the nearest dollar.   I would recommend that you calculate the MOH per greenhouse first.  You should calculate an Overhead rate with 2 decimal points. 

Discuss other options (at least 2) for the activity base and the importance of the MOH allocation.   Do multiple product lines impact the MOH allocation? What happens if MOH is not allocated correctly to a product?

3. Prepare a Job Order Cost sheet for the following custom green house:  Materials $2,500 and 20 hours of labor. What is the customer price?

What other factors would impact the sales price for this type of company? Can a company rely on setting price based on just a % on cost?

4. What is the Contribution Margin (CM) in total and per unit dollars, and CM% for the sale of 2,000 greenhouses?

Explain the importance of CM and how it can be used by companies to predict future income.  Create some examples with numbers to show how it can be used (this area could be completed in excel).

5. Prepare a traditional Income Statement assuming a volume of 2,000 units.  For the cost of goods sold, please use the per unit cost you calculated in #2 multiplied by number of units sold.  You do not have to prepare any additional schedules.  I would use a similar format to exhibit 16-8 on page 737 or from your lecture notes.  I recommend that you list out all operating expenses given above.  Do not use just Selling and General/Administrative Expenses for your categories.  Points will be lost by not listing out all period costs. You can ignore interest and income tax expense.

6. Prepare three Cost Volume Profit (CVP) Income Statements using the following yearly volumes:  1,500, 2,000 and 2,400. Keep in mind how variable and fixed costs behave. The traditional income statement from #5 should be about the same net income as the 2,000 units for the CVP format.

a) Calculate Break-even in units and sales $ for the company

b) Calculate units and sales $ if the company wants a profit of $1,000,000.

c) Margin of safety for 2,000 units.

Discuss the importance of these calculations to a company.  Fully discuss the differences(at least 3) between the traditional vs CVP format.  Give examples supported by numbers of how you would use these calculations as the CFO of the company.

7. If the following changes were to be made, calculate a new CVP Income Statement:  Direct Material costs decrease by 10%; fixed costs increase by 50% and sales price would increase by 5%.  Assume you are selling the 2,000 units.

Should the company consider these changes? Why or why not?  This question is not just based on the new net income.  Please review the full income statement for changes.  What if the sales volume changes?  Does this change your answer?  I would recommend using volumes higher and lower to see how the changes impact your answer.  Include any CVP income statements that are needed to support your answer.

Discuss real examples of cost increases for fixed costs (at least 2) and decreases for direct materials (at least 2) that could be implemented for this business. Can the company increase price?  What other areas might be impacted due to the price increase?  You are the CFO of this business what is important to consider?  Give 2 industry specific details that can impact this discussion.

8. Explain what will happen to the MOH costs on a per unit basis if fewer units are sold.  Could it impact per unit cost? (keep in mind the type of costs that MOH represents for this company)    If another product line that would share the current MOH costs (no additional MOH costs) was added, how would it impact the MOH costs in total and on a per unit basis?

Additional information for another product line

Assume another product line is also being considered - DIY (do it yourself) greenhouses.  Only use this information for the questions listed directly below.

  • Higher skilled workers would be required which will result in paying them $15 per hour.
  • Additional MOH costs for the year will be $150,000. These costs will be in addition to the costs already being incurred. These costs are due to the additional product line and also related to the current product lines for additional production abilities. The two lines will share all MOH costs.

1. Should the company consider using ABC? Discuss why or why not?  Areas to include in the discussion but not limited to the following:  impact on product cost, implications of not using the right allocation and its impact on price if any, etc....

2. How specifically would ABC help allocate MOH costs?

Reference no: EM131539443

Questions Cloud

Auditor certifies reasonable basis-types of engagements : The auditor certifies reasonable basis has been provided in standard reports for which of types of engagements? Compilation reports may include.
What are the major aca changes will you make or repeal : You are the President of the Unites States of America. What are the major ACA changes will you make/or repeal and why?
Is this a good control system for dp : Is this a good control system for DP? Whyor why not? Does it also represent a good control point for company projects using DP to accomplish one portion.
Agreed-upon procedures to prospective financial statements : An auditor is considering accepting an engagement to apply agreed-upon procedures to prospective financial statements.
Calculate break-even in units and sales for the company : Prepare three Cost Volume Profit (CVP) Income Statements using the following yearly volumes: 1,500, 2,000 and 2,400
What types of direct communication would you utilize : What types of direct communication would you utilize? Explain. How will you effectively evacuate the necessary populations? Explain.
What is the black and scholes value of option : What is the Black and Scholes value of this option? What should be the value of a put option with the same strike price and the same time to maturity?
Employee portfolio be worth after working for the company : How much will an employee’s portfolio be worth after working for the company 30 years more?
Calculate the price elasticity coefficient : Suppose the quantity of fish purchased by mr. singh's family is 22 kilos per year. When the price is $10.50 per kilo and 18 kilo per year when the price is $10.

Reviews

len1539443

6/22/2017 12:39:45 AM

Solutions should be MBA level Please follow the strict guidelines in the file and the project needs professional excel spreadsheet with calculations and formulas. The structure of the paper should include an opening paragraph about the company in a word document. The discussion questions should be answered in the order listed (questions are in italics). However, do not number the questions. Instead, the discussion should flow from one topic to the next and include as a minimum the questions identified. Please use a memo format for the paper and address it to the Board of Directors.

len1539443

6/22/2017 12:39:37 AM

The calculations should be included as schedules in excel which are numbered and referenced to each discussion. A discussion without referring to the numbers will not be considered complete. Do not discuss/explain your calculations. Answer the questions related to your calculations. All schedules should be included in excel and use formulas with professional formatting. A person who is reading the excel schedules should not have any questions on what is being calculated so numbers and schedules should be clearly labeled. Not using formulas will result in a minimum 1 grade reduction. I recommend linking the schedules.

len1539443

6/22/2017 12:39:30 AM

You should be thinking about all of the concepts that you have learned from this course and their importance to a business owner or investor. I should finish reading your paper and see the concepts and some industry knowledge demonstrated through the discussion and the analysis. Finally, the closing paragraph(s) should summarize the paper. Plan to devote time to writing and reviewing the paper. Groups can have significant grade reductions for papers that are not well written (spelling, grammar etc..) I would recommend that the paper be no more than 6 pages.

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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