Question

In: Accounting

You have been hired as a consultant for Wrigley a well-known and loved worldwide manufacturer of...

You have been hired as a consultant for Wrigley a well-known and loved worldwide manufacturer of chewing gum. Three of these brands - Juicy Fruit®, Wrigley's Spearmint® and Altoids® - have heritages stretching back more than a century. Wrigley sells its products in more than 180 countries around the world. The CEO of Wrigley, William Perez is in charge of a recent acquisition of a manufacturer of organic chewing gum, Natural Mint, Inc. which is located in Portland, Oregon. The company has one main product which is made in five flavors. He has asked you to prepare a preliminary cost-volume-profit analysis to determine whether changes should be made to the cost structure of selling expenditures.

The following information was presented for use in the analysis:

Fixed costs:

Variable Costs (per unit):

Administrative Costs: $245,000

Direct Materials: $0.075

Selling Costs: $260,000

Direct Labor: $0.055

Fixed Overhead Costs: $230,000

Variable Overhead: $0.035

Variable Selling: $0.010

Selling price per unit: $2.00

Questions (each question is independent of the others):


1. What is the current break-even point in units and in dollars? Also compute the margin of safety.

2. Assume the company sold 500,000 packs of gum last year. What is Natural Mint's operating leverage? If sales decreased 10%, by what % will Net Income decrease? Create a contribution margin income statement to prove that your calculations are correct.

3. What is the break-even point in units if variable selling costs are increased to 0.05 per unit? Would you recommend this change to the CEO if the expected sales level is 520,000 packages? Explain - consider the breakeven point and profit.

4. Independent of Question 3, what is the break-even point in dollars if the variable selling is eliminated and replaced with an increase to Fixed Selling costs of $200,000? Would you recommend this change to the CEO if the expected sales level is 550,000 units? Explain - consider the breakeven point margin of safety and profit.

Solutions

Expert Solution

Answer 1.
SP Per Unit                     2.000
Variable Cost per Unit:
Direct Materials                     0.075
Direct Labor                     0.055
Variable Overhead                     0.035
Variable Selling                     0.010
Total Variable Cost per Unit                     0.175
Contribution per Unit                     1.825
Contribution Margin Ratio 91.25%
Fixed Costs:
Administrative Costs        245,000.000
Selling Costs        260,000.000
Fixed Overhead        230,000.000
Total Fixed Costs        735,000.000
BEP (In Units) = Fixed Costs / Contribution Margin per Unit
BEP (In Units) = $735,000 / $1.825
BEP (In Units) = 402,739.73 or say 402,794 Units
BEP (In $) = Fixed Costs / Contribution Margin Ratio
BEP (In $) = $735,000 / 91.25%
BEP (In $) = $805,479.452 or say $805,480 (Approx.)
Margin of Safety = Sales - BEP (In $)
Margin of Safety = $1,000,000 - $805,480 = $194,520
Assume Company Sold 500,000 Packs of Gums
Answer 2.
Operating Leverage = Contribution / Net Operating Income
Operating Leverage = $912,500 / $177,500
Operating Leverage = 5.14 (Approx.)
Contribution = $1.825 X 500,000 = $912,500
Net Operating Income = $912,500 - $735,000 = $177,500
If sales Decrease by 10%
Net Income decrease by = 10% X 5.14
Net Income decrease by = 51.41%
Income Statement
Contribution - $1.825 X 450,000 Units          821,250.00
Fixed Costs          735,000.00
Net Income            86,250.00
Net Income decrease by = ($177,500 - $86,250) / $177,500
Net Income decrease by = 51.41%
Answer 3.
SP Per Unit                     2.000
Variable Cost per Unit:
Direct Materials                     0.075
Direct Labor                     0.055
Variable Overhead                     0.035
Variable Selling                     0.050
Total Variable Cost per Unit                     0.215
Contribution per Unit                     1.785
Contribution Margin Ratio 89.25%
BEP (In Units) = $735,000 / $1.785
BEP (In Units) = 411,764.71 or say 411,765 Units (Approx.)
Income Statement
Contribution Margin - $1.785 X 520,000 Nos        928,200.000
Fixed Costs        735,000.000
Net Operating Income        193,200.000
Yes, the changes should be made as it will increase the Net Operating to $193,200
Answer 4.
SP Per Unit                     2.000
Variable Cost per Unit:
Direct Materials                     0.075
Direct Labor                     0.055
Variable Overhead                     0.035
Total Variable Cost per Unit                     0.165
Contribution per Unit                     1.835
Contribution Margin Ratio 91.75%
Fixed Costs:
Administrative Costs        245,000.000
Selling Costs        460,000.000
Fixed Overhead        230,000.000
Total Fixed Costs        935,000.000
BEP (In Units) = Fixed Costs / Contribution Margin per Unit
BEP (In Units) = $935,000 / $1.835
BEP (In Units) = 509,536.78 or say 509,537 Units
Margin of Safety = Sales - BEP (In $)
Margin of Safety = $1,100,000 - $1,019,074 = $80,926
Income Statement
Contribution Margin - $1.835 X 550,000 Nos    1,009,250.000
Fixed Costs        935,000.000
Net Operating Income          74,250.000
No, the change should not be made,a s it will decrease the net operating income to $74,250

Related Solutions

You have been hired as a consultant for Medicals Inc., manufacturer of medical devices. The company...
You have been hired as a consultant for Medicals Inc., manufacturer of medical devices. The company projects unit sales for a new dental implant as follows: Year                 Unit Sales 1                     73,000 2                      86,000 3                      97,000 4                      68,000            Additional information: • Production of the implants will require €1,500,000 in net working capital immediately, all of which will be recovered at the end of the project. • Total fixed costs are €4,200,000 per year, variable production costs are €255 per unit, and the units are priced at...
You are working as a consultant and have been hired by a company to assist in...
You are working as a consultant and have been hired by a company to assist in creating a company Code of Ethics in order to attract and retain more customers to your products and to prove the company’s ethical conduct & practices. This smaller, private company sells footwear for the Canadian and American marketplaces. The company has made the decision to do business with a supplier in Brazil. The initial product quality has been very good, and the delivery of...
assume that you have been hired as a consultant for the World Bank to prepare a...
assume that you have been hired as a consultant for the World Bank to prepare a Witten report on the macroeconomic impact of COVID-19 on a chosen country. The report should include the following: a) What are the macroeconomic effect of Covid-19? b) What are the proposed solution to address the macroeconomic impacts identified in (a)? c) In your opinion, what are the challenges to overcome this problem from a macroeconomic perspective? d) What is the impact of the policy...
You have been hired as a consultant by a college foundation to conduct a survey of...
You have been hired as a consultant by a college foundation to conduct a survey of graduates. The foundation wants to estimate the mean amount of all charitable contributions their graduates make annually. What is the minimum number of graduates that should be surveyed if the foundation wants to be 98% confident that the sample mean is within $50 of the actual population mean? (Based on results of a pilot study, assume the true standard deviation of annual charitable contributions...
You have been hired as a financial consultant to a company with securities listed on the...
You have been hired as a financial consultant to a company with securities listed on the Australian stock exchange. From a review of the company’s share register you have ascertained that the majority of its shareholders are resident overseas and are unable to utilise Australian imputation credits. The company is evaluating the relocation of its manufacturing plant from New South Wales to South Australia to produce its line of electronic components that are purchased by vehicle manufacturers. This new plant...
You have been hired by a company as a Statistical Consultant, for the purpose of determining...
You have been hired by a company as a Statistical Consultant, for the purpose of determining whether there is a significant difference in the number of units produced by workers on Mondays and Fridays at their factory. The following table indicate the number of units produced by three groups of eight workers randomly sampled from each of the relevant days. Using manual computation, perform the appropriate hypothesis test at α = 0.05 Mondays Fridays 43 24 27 16 25 33...
You have been hired as a consultant to assess the impact of a spill of 10...
You have been hired as a consultant to assess the impact of a spill of 10 kg of chlorobenzene in a river adjacent to a small town. The average width is 20m, average depth is 2.4m, and has a discharge of 8.7 m3/s. The average water temperature is 22 °C, the average air temperature is 27 °C, and the average wind speed is 4.25 m/s. The suspended solids concentration has been measured at 7 mg/L, Kd for chlorobenzene is 4.27...
Assume that you have been hired as a consultant by Clabber Girl, a major producer of...
Assume that you have been hired as a consultant by Clabber Girl, a major producer of home kitchen goods, to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Liabilities and Equity (Reduced for simplicity; shows book-values only) Long-term debt (40,000 bonds, $1,000 par value) $40,000,000 Common stock (10,000,000 shares) $30,000,000 The stock is currently selling for $15.25 per share, and its noncallable $1,000 par value, 20-year, 1.70% bonds with semiannual...
You have been hired as a consultant to a major health insurancecompany to help identify...
You have been hired as a consultant to a major health insurance company to help identify ways to reduce payments for healthcare benefits. Please identify some possible methods that may be useful in cutting costs.
As a consultant specializing in economics, you have been hired by the small island nation of...
As a consultant specializing in economics, you have been hired by the small island nation of Petrolo. Although Petrolo’s landmass is small (about the size of Florida), it enjoys enormous oil reserves that rank number five in the world for high grade petroleum. To date Petrolo has not found it necessary to drill into its substantial but at a higher production cost of offshore reserves that are within the 18 mile territorial limit. Petrolo has prospered by pumping enough onshore...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT