Johnson Manufacturing Company Peter Johnson and Lily Brown own Johnson Manufacturing Company (Johnson). Johnson produced storage...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Johnson Manufacturing Company Peter Johnson and Lily Brown own Johnson Manufacturing Company (Johnson). Johnson produced storage sheds in three primary models (A, 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 Exhibi 4. The company hires your services as their consultant. They believe that they can improve their bottom-line (net profits) by changing the product miv nricing and advertising decisione 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? Exhibit 1 Johnson Manufacturing Company Income Statement as of December 31, 2017 $40,582,500 21.150.000 $19,432,500 Sales Less: costs of products sold Gross margin SG&A Other costs Operating income Less: Interest expense Plus: Interest income Income before tax Income taxes Net income Planned units Per unit Sales price Direct costs: Materials Labor Subtotal Indirect cost: Supplies Labor Energy Exhibit 2 Johnson Manufacturing Company Standard Costs as of December 31, 2017 Grill A Grill B Grill C Notes 75,000 100,000 205,000 $158 2 17 21 9,350,000 2.100.000 $7,982,500 $38 420,000 150,000 $7,712,500 2.699.375 $5.013 125 7 10 12 $116 10 16 $26 2 8 6 $84 7 directly related to volume 4 directly related to volume $11 1 directly related to volume 4 50% variable, the rest is fixed 4 50% variable, the rest is fixed PX W Materials Labor Subtotal Indirect cost: Supplies Labor Energy Supervision Depreciation Accounting/Legal/IT su Other Fixed Costs Subtotal Total cost Profitability 17 21 $38 7 10 12 8 22 12 11 10 16 $26 2863762 $82 $34 $120 $60 $38 $56 7 directly related to volume 4 directly related to volume $11 1 directly related to volume 4 50% variable, the rest is fixed 4 50% variable, the rest is fixed 1 unrelated to volume 5 unrelated to volume 3 unrelated to volume 1 unrelated to volume $19 $30 $54 Month January February March April May June July August Exhibit 3 Johnson Manufacturing Company Proforma Sales Budget 2018 September October November December Total Budgeted Budgeted Cash Sales Credit Sales 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 976,500 2,278,500 1,008,000 2,352,000 913,500 2,131,500 1,197,000 2,793,000 1,134,000 2,646,000 11,844,000 27,636,000 Total Budgeted 3,150,000 3,150,000 3,150,000 3,150,000 3,150,000 3,150,000 3,150,000 3,255,000 3,360,000 3,045,000 3,990,000 3,780,000 39,480,000 -The gross profit rate is 55% and the desired inventory level is 30% of next month's cost of sales. -Management estimates that 5% of credit sales are not collectible. -Of the credit sales that are collectible, 60% are collected in the month of sale and the remainder in the m -Cost of purchases of inventory each month is 70% of the next month's projected total sales. -All purchases of inventory are on account; 25% are paid in the month of purchase, and the remainder is p Exhibit 4 Johnson Manufacturing Company 2010 Exhibit 4 Johnson Manufacturing Company Proposed Investments for 2018 Initial investment Cash flow from operations Year 1 Year 2 Year 3 Disinvestment Life (years) Proposal A 57,000 50,000 6,000 29,000 3 years Proposal B 57,000 30,000 30,000 25,000 3 years PX Proposal C 57,000 57,000 1 year A Johnson Manufacturing Company Peter Johnson and Lily Brown own Johnson Manufacturing Company (Johnson). Johnson produced storage sheds in three primary models (A, 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 Exhibi 4. The company hires your services as their consultant. They believe that they can improve their bottom-line (net profits) by changing the product miv nricing and advertising decisione 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? Exhibit 1 Johnson Manufacturing Company Income Statement as of December 31, 2017 $40,582,500 21.150.000 $19,432,500 Sales Less: costs of products sold Gross margin SG&A Other costs Operating income Less: Interest expense Plus: Interest income Income before tax Income taxes Net income Planned units Per unit Sales price Direct costs: Materials Labor Subtotal Indirect cost: Supplies Labor Energy Exhibit 2 Johnson Manufacturing Company Standard Costs as of December 31, 2017 Grill A Grill B Grill C Notes 75,000 100,000 205,000 $158 2 17 21 9,350,000 2.100.000 $7,982,500 $38 420,000 150,000 $7,712,500 2.699.375 $5.013 125 7 10 12 $116 10 16 $26 2 8 6 $84 7 directly related to volume 4 directly related to volume $11 1 directly related to volume 4 50% variable, the rest is fixed 4 50% variable, the rest is fixed PX W Materials Labor Subtotal Indirect cost: Supplies Labor Energy Supervision Depreciation Accounting/Legal/IT su Other Fixed Costs Subtotal Total cost Profitability 17 21 $38 7 10 12 8 22 12 11 10 16 $26 2863762 $82 $34 $120 $60 $38 $56 7 directly related to volume 4 directly related to volume $11 1 directly related to volume 4 50% variable, the rest is fixed 4 50% variable, the rest is fixed 1 unrelated to volume 5 unrelated to volume 3 unrelated to volume 1 unrelated to volume $19 $30 $54 Month January February March April May June July August Exhibit 3 Johnson Manufacturing Company Proforma Sales Budget 2018 September October November December Total Budgeted Budgeted Cash Sales Credit Sales 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 945,000 2,205,000 976,500 2,278,500 1,008,000 2,352,000 913,500 2,131,500 1,197,000 2,793,000 1,134,000 2,646,000 11,844,000 27,636,000 Total Budgeted 3,150,000 3,150,000 3,150,000 3,150,000 3,150,000 3,150,000 3,150,000 3,255,000 3,360,000 3,045,000 3,990,000 3,780,000 39,480,000 -The gross profit rate is 55% and the desired inventory level is 30% of next month's cost of sales. -Management estimates that 5% of credit sales are not collectible. -Of the credit sales that are collectible, 60% are collected in the month of sale and the remainder in the m -Cost of purchases of inventory each month is 70% of the next month's projected total sales. -All purchases of inventory are on account; 25% are paid in the month of purchase, and the remainder is p Exhibit 4 Johnson Manufacturing Company 2010 Exhibit 4 Johnson Manufacturing Company Proposed Investments for 2018 Initial investment Cash flow from operations Year 1 Year 2 Year 3 Disinvestment Life (years) Proposal A 57,000 50,000 6,000 29,000 3 years Proposal B 57,000 30,000 30,000 25,000 3 years PX Proposal C 57,000 57,000 1 year A
Expert Answer:
Answer rating: 100% (QA)
A 1 Sol 1 Contribution margin of each product 2 Particulars Grill A 3 Units ... View the full answer
Related Book For
Foundations of Finance The Logic and Practice of Financial Management
ISBN: 978-0132994873
8th edition
Authors: Arthur J. Keown, John D. Martin, J. William Petty
Posted Date:
Students also viewed these general management questions
-
Her doctor is considering taking her off antihypertensive medications but wants to be fairly certain that her true DBP is less than 90 mm Hg. Use a statistical approach to answer this question....
-
Annie is planning a large surprise party for her sister Gwendolyn. She has developed the plan below, including estimates of the time (in hours) and cost necessary to perform each of the activities...
-
Annie Hays recently sold a condominium she had bought and lived in while she was a college student over 15 years ago. She received $150,000 for the condominium and is considering two investment...
-
Measuring the height of a California redwood tree is very difficult because these trees grow to heights over 300 feet. People familiar with these trees understand that the height of a California...
-
For each of the following pairs of goods, which has the higher price elasticity of demand? (a) Airline travel in the short run or airline travel in the long run (b) Television sets or Sony television...
-
If a surfboard is produced this year but not sold until next year, how is it counted in this years GDP and not next years?
-
If the radius of a wire stretched by a load is doubled. then Young's modulus of elasticity will be (a) Doubled (b) Halved (c) Four times (d) Unaffected
-
Financial information for CNG Inc. follows: The company estimate bad debts for financial reporting purposes at 3 percent of credit sales. The balance in allowance for doubtful accounts as of January...
-
What role does tray efficiency play in the overall performance of a distillation column, and what factors contribute to deviations from theoretical stage efficiency ?
-
Consider the evaporator and control system in Figure 13.6. (a) Should each control valve be air-to-open (AO) or air-to-close (AC)? (b) Should each PI controller be direct-acting or reverse-acting?...
-
When a company is domiciled in one state but is subject to income tax in multiple states, business income is generally allocated under the Uniform Division of Income for Tax Purposes Act (UDITPA) on...
-
For internal audits, a group responsible for performing audits should consist of ...?
-
What account is credited when an interest-bearing note replaces an overdue account from a customer?
-
Could you elucidate the ways in which the novelist utilizes structural ambiguity and narrative fragmentation to depict the existential conflict between individual agency and societal determinism?
-
1 . Define the term "micromanager". 2 . Develop a list of the characteristics and behaviors of micromanagers. 3 . Write up three ways that the items in your list from question 2 can hurt company...
-
How does the novelist intricately sculpt the protagonist's psyche through a nuanced portrayal of internal conflict, utilizing subtle gestures and psychological depth to render a character of profound...
-
Dunder Mifflin started the month of June with $ 1 2 2 , 8 8 9 in assets. During the month of June, they bought $ 7 0 , 0 6 4 worth of paper on account and received $ 2 4 , 7 4 1 from a customer on...
-
Find the center of mass of a thin triangular plate bounded by the y-axis and the lines y = x and y = 2 - x if (x, y) = 6x + 3y + 3.
-
Tri- State Enterprises plans to issue commercial paper for the first time in the firms 35- year history. The firm plans to issue $500,000 in 180- day maturity notes. The paper will carry a 10 1/ 2...
-
Trico bonds have an annual coupon rate of 8 percent and a par value of $ 1,000 and will mature in 20 years. If you require a return of 7 percent, what price would you be willing to pay for the bond?...
-
The common stock of NCP paid $ 1.32 in dividends last year. Dividends are expected to grow at an 8 percent annual rate for an indefinite number of years. a. If NCPs current market price is $ 23.50...
-
Tesco plc is one of the worlds largest food retailers. Fiscal year 2014 (the year ended February 28, 2015) was a rocky year for the retailer. The companys sales and margins had come under pressure as...
-
Exhibit P2 displays a selected set of financial ratios for the years 20152017 of three fashion retailers: USbased Gap, UK-based Next, and Japan-based Uniqlo (Fast Retailing). Using this set of...
-
In 2009, following the worldwide credit crisis, several US-based car manufacturers, such as Chrysler and General Motors, approached bankruptcy and needed to be bailed out by the US government and...
Study smarter with the SolutionInn App