Create a contribution formatted income statement

Assignment Help Financial Accounting
Reference no: EM13504419

Requirement #1

Using the data, which has also been provided electronically in Excel, run the following regression analyses:

• Linear regression analyzing total overhead cost and units sold
• Linear regression analyzing total overhead cost and machine hours used
• Multiple regression analysis analyzing total overhead cost along with both units sold and machine hours used

Requirement #2

Based on the results from the three regression analyses determine which correlation provides the best estimate of the total cost equation. Explain why you selected the correlation that you did.

Requirement #3

Write out the total cost equation using the results from the multiple regression test.

Requirement #4

Create a "Contribution" formatted income statement using the results from the multiple regression test. Your selling price per unit and your direct material cost per unit and your direct labor cost per unit and your fringe benefits all come from the original "Traditional" income statement. Use the following additional information regarding machine hours, used by each product, to compute variable overhead.

1961_table 1.png


Reference the following sales volumes, by product, for your cost allocation related to units sold. This data will help you calculate variable overhead.

752_table 2.png

Use the following template as a guide for the format of your "Contribution" Income Statement:

1944_table 3.png


Requirement #5

Compute the following:

• Break-even point in units
• Break-even point in sales dollars
• Targeted profit point in units (use $50,000 as your targeted profit point)
• Margin of Safety

Requirement #6

A new customer has surfaced. That customer has asked you to consider producing a special one-time order for them. This special order would require a modification to the recipe that will slightly increase the variable cost per unit. Furthermore, there would be a small fixed cost addition. The details for the order as follows:

839_table 4.png


Conduct a differential analysis regarding this special order. Would you accept this order under the conditions provided? Explain and defend your position.

Requirement #7:

Your management team has asked you to consider investing in a new piece of equipment. The details of that investment opportunity are following:

1975_table 5.png


The discount rate for this project is 5%. Compute the following:
• Net Present Value
• Internal Rate of Return

Would you recommend investing in this new piece of equipment? Explain and defend your position.

Clarification on format and data:

Clear communication and professionalism are important. Defending your answer with data is important.

• An electronic copy of this Case (this document) is available within Blackboard. Additionally, an Excel file, containing the necessary data for the case will be available within Blackboard.

• Create one professional report, in Word, that contains all of answers. In that report you should clearly label all of your answers. Make your answers easy to read and find. Imagine you were giving this report to your boss. Further imagine you have to lead your boss and the executive team through your findings. You will then have one Word document as your final product. You will also have one Excel file.

• Grading is based on both accuracy (see rubric) and your ability to communicate your answers professionally and clearly.

• Use the following naming structure for your files: last name_first initial_case3.docx. Of course your Excel file will have an .xls suffix.

• Double space your report.

• Put good thought into how you organize your Excel document. Part of your grade will be based upon the usability and layout of your Excel file. Imagine that have to give the electronic copy of your Excel file to your boss, or a peer, to work with. Imagine that you could not coach them at all on how to use your file. Is your file organized and labeled so clearly that anyone could use it, easily, without instructions from you? You want to strive for that kind of clarity in your work.

• Your report should have a title page. Use APA 6th edition for guidance on title pages.

• You will physically hand-in your report. You will also upload to Blackboard both your Word document and your Excel file.

• Late submissions will result in the following: 10% reduction in score for each 24 hour period of being late (up to 3 days). After 3 days late zero credit will be earned.

• As always please come to me with learning questions. This project is a learning experience.

Reference no: EM13504419

Questions Cloud

Find the thermal energy transfer : An ideal monatomic gas expands isothermally from 0.600 m3 to 1.25 m3 at a constant temperature of 800 K. If the initial pressure is 8.00 10^4 Pa. Find the thermal energy transfer Q
Acquisition of a conditioned response-extinction : Ivan Petrovich Pavlov: Briefly describe the following: acquisition of a conditioned response, extinction, spontaneous recovery, generalization, discrimination, and higher-order conditioning.
How much heat is gained by the cup and the water : An unknown mass of tin is heated to a temperature of 202 C. It is placed into 200 g of water which is in a 100 g copper cup initially at 10 C. How much heat is gained by the cup and the water
Estimate the final temperature of the water : A 50.5 g ice cube, initially at 0°C, is dropped into a Styrofoam cup containing 360 g of water, initially at 19.2°C. What is the final temperature of the water
Create a contribution formatted income statement : Use the following additional information regarding machine hours, used by each product, to compute variable overhead.
Describe the characteristics of the adulthood stage : According to Eirk Erikson, Describe the characteristics of the adulthood stage (e.g key terms,definitions, age.) Also give practical examples of behaviors/cognitions that mark this stage , also describe the influence of heredity and environment here ..
Calculate the equilibrium concentration of dissolved oxygen : Calculate the equilibrium concentration of dissolved oxygen in 15celcius dgree water at 1atm and again at 3,000m elevation Using Henry's law, P vs z equation
Summarize the nature of animal research prior : Edward Lee Thorndike: Summarize the nature of animal research prior to Thorndikeâ's efforts. In what way was Thorndikeâ's research different from that which preceded it? Include in or your answer a discussion of Morganâs canon.
Compute how long will it take for the wheel to come to rest : When a 19.7 kg wheel with an angular speed of 2.30 rad/s is disconnected from a motor, a 0.219 N · m frictional torque slows the wheel to a stop. how long will it take for the wheel to come to rest

Reviews

Write a Review

Financial Accounting Questions & Answers

  Explain why the management accounting information from

explain why the management accounting information from the traditional responsibility accounting system fails

  Examine the requirements for measuring assets at fair value

Examine the requirements for measuring assets at fair value in the following accounting standards.

  Describe why the interest rate for the loan

Describe why the interest rate for the loan that needs a review report is lower than that for the loan that did not require a review. Describe why the interest rate for the loan that needs an audit report is lower than the interest rate for the ot..

  Explains these terms and critically examines

You are required to prepare a report for your client which explains these terms and critically examines their significance in the context of the accounts published by the Lloyds Banking Group for the half-year to June 2012.

  Create the journal entries necessary in 2013

The service period related to these restricted shares is 3 years. Vesting occurs if the upper level executives stay with Lebron Corp for 3 years.

  What could be the expected operating income per week

What could be the expected Operating Income per week? When both machines are working how many of each unit should OSC produce?

  Calculate the financial ratios for both fiscal years

Fundamentals of Corporate Finance After you have completed your income statement and balance sheet, calculate the subsequent financial ratios for both fiscal years

  What value the random variable

What value the random variable will assume for each of the experimental outcomes and list the experimental outcomes associated with performing the blood analysis

  Question on 1st january 2013 lauras living company has the

question on 1st january 2013 lauras living company has the subsequent defined benefit pension plan balances.projected

  Illustrate what is rich fixed overhead budget variance

Rich Company uses a standard cost system- budgeted $800000 of fixed overhead when 50,000 machine hours were anticipated. Illustrate w hat is Rich's fixed overhead budget variance?

  Question the comparative year-end balance sheets of sign

question the comparative year-end balance sheets of sign graphics inc. revealed the subsequent activity in the companys

  Purpose the bank reconciliation for september

Purpose the bank reconciliation for September 2009 in good form. Purpose the necessary journal entries in the books of Frank Industries as at Septembet 30, 2009 as necessitated by the bank reconciliation.

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