Linear regression analyzing total overhead cost

Reference no: EM131147351

Case - Performance Drinks -A further study of: Regression Analysis

Background:

Performance Drinks, LLC is owned by Dave N. Port. Performance Drinks produces a variety of sports centered drinks. They began operations in 1993 shortly after Mr. Port graduated with his M.B.A. from Davenport University. The company saw early success as sports and fitness nutritional products gained new popularity in the 1990's. Financially the company is sound and has been wise in controlling their growth over the years. However, within the last 18 months Mr. Port has noticed a drop in overall company profitability. This is especially troubling considering that the company has continued to experience top-line growth. Mr. Port and his management team have been considering developing a new product line. However, those plans have been put on hold until they can figure out why their profits are shrinking.

Performance Drinks makes four different kinds of sports drinks. Those drinks are as follows:
- Basic
- Hydration
- Intensity
- Post-Workout

Each of these drinks contains a slightly different nutritional profile and is targeted for different users and uses. The Basic drink has the least nutritional benefit and is targeted for general consumption. The Hydration product targets endurance athletes and specializes in hydration replacement. The Intensity product was designed with energy enhancement in mind. It serves the needs of extreme athletes who need long durations of sustained energy. Lastly, the Post-Workout product is a nutritional replacement product that is generally used following exertion.

Requirement #1

Using the data above, 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.

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

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

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:

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:

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.

Attachment:- case performance.rar

Reference no: EM131147351

Questions Cloud

Briefly describe how the american legal profession : Are female lawyers more likely to be promoted to partner in small firms or large firms? Why? Are they as successful as male lawyers with similar qualifications? Why or why not? Suggest three ways in which private legal practice has changed in the l..

Operative and state consequences for the parties concerned : The plaintiff agrees to supply the defendant's building company with 2 tonnes of cement. During the negotiations the plaintiff agreed to supply at the price of $ 800 per tonne. The sales contract, prepared by the plaintiff, inadvertently states that ..

Character trait that both aristotle and buddhism describe : What are two differences between how virtues are described by Aristotle versus how they are described in Buddlism?

How will you price your product compared to your competition : How will you price your product compared to your competition? Explain your pricing strategy? Will your price leave you with the appropriate profit margin? What should your profit margin be?

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

Calculate the standard deviation of the slope : Construct a spread sheet and use it to draw a calibration curve for NADH.

The percentage of inventory disappearance : For a given month Konway Kola Kompany produced 93,872 cases of product (24 bottles each case) per the Production Department. What was the inventory disappearance, per accounting numbers? What was our empty bottle variance for the month – calculate bo..

Considering prospective investment-venture capitalists : Before considering a prospective investment, venture capitalists and other investors often want to hear what they call the elevator pitch. This is the concise description of the company, its product or service, its market(s), and its competitive adva..

Budgets play critical role in management activities : Budgets play a critical role in management activities such as planning, controlling and motivating employees. Used effectively, budgets can help a company achieve its goals and reate a productive work environment. In contrast, budgets can also create..

User Account

All Pages