Calculate the current contribution margins of each product

Assignment Help Corporate Finance

Reference no: EM131756100

Johnson Manufacturing Company

Peter Johnson and Lily Brown own Johnson Manufacturing Company (Johnson). Johnson produced storage sheds in three primary models (A, B, and C). The industry was dominated by Coleman, Phoenix, and Meco, which made several of types of sheds. Johnson was a small player in the industry with a solid customer base and a profitable business over last few years. This year was a little different - their profit was significantly lower than the prior years. The company's 2017 financials are provided in Exhibit 1.

The company produces 3 products - let's call them Shed A, B and C for simplicity. The standard costs for these three products are provided in Exhibit 2. The Selling, general, and administrative (SG&A), other costs, interest income, and interest expense are likely to remain the same no matter which product-line combinations the company produced.

The company is thinking about the future and has provided a preliminary proforma 2018 sales budget in Exhibit 3.

Favorable preliminary 2018 forecasts lead management to believe there will be excess cash flow in 2018. Management has requested that a consultant be hired to provide an analysis of several proposed 2018 investments. The details of the proposed investments are provided in Exhibit 4.

The company hires your services as their consultant. They believe that they can improve their bottom-line (net profits) by changing the product mix, pricing and advertising decisions.

Given that the plant currently runs at full capacity, examine the following independent scenarios:

1. Calculate the current contribution margins of each product.

2. What is the effect of discontinuing Shed A?

3. Calculate the net change in profits if the company focuses more on selling Shed C instead of Shed A. Such an action would result in a decrease of 10,000 unit sales of Shed A and an increase of 10,000 unit sales of Shed C.

4. What is the effect if Shed C is decreased by $5 and the volume of Shed C increases by 10%?

5. Prepare a purchases and cash receipts budget for September, October, and November using the 2018 sales budget provided in Exhibit 3.

6. Rank the proposed investments in Exhibit 4 using the net present value criteria and the accounting rate of return on initial investment. Assume the organization's cost of capital is 12%. Which investment would you recommend?

Attachment:- Assignment File.rar

Reference no: EM131756100

Questions Cloud

Calculate the amount of revenue and gross profit : Calculate the amount of revenue and gross profit to be recognized in each of the three years assuming the following costs incurred

Define indirect and mutual holding affiliation structures : Distinguish between indirect holding affiliation structures and mutual holding affiliation structures. Are the treasury stock and conventional approaches.

Calculate the portfolio variance and standard deviation : MFE 6000 - What is the probability a student will pass the course and Calculate the portfolio variance and standard deviation

Marketing strategy for fitness supplements : Marketing strategy for Fitness supplements. Controls for Fitness supplements – Briefly summarize – how will you determine when you meet your objectives?

Calculate the current contribution margins of each product : Peter Johnson and Lily Brown own Johnson Manufacturing Company (Johnson). Calculate the current contribution margins of each product

What are the total production cost when collars are produced : Doggie Pals produces 80,000 dog collars each month that give off a fresh scent to keep your dog smelling clean between baths.

Calculate the income tax liability using the tax rates : Calculate the income tax liability using the tax rates for December 2015 for each of the following unrelated C Corporations

New product innovation department will also be in attendance : Dyson's CEO and the head of Dyson's New Product Innovation department will also be in attendance.

Project evaluation and microsoft solutions framework : Analyze the relationship between a Feasibility Study and a Cost-Benefit Analysis. Investigate the main reasons why both of these evaluations.

User Account

All Pages