Save a copy of your original model to a new spreadsheet called supplier cost increase. Say...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Save a copy of your original model to a new spreadsheet called "supplier cost increase". Say the supplier is expected to increase the cost of the products by 20%. What is the new operating income? What is the new WACM%? What is the new MOS%? Briefly explain your findings to the client. Operating income WACM percentage MOS% NEW ORIGINAL $ 900.00 48% 38% Change ASSUMPTIONS Product #1: Sales price per unit Variable costs per unit: Commision Launch cost per unit Shipping and handling Total variable cost per unit Monthly volume Product #2: Sales price per unit Variable costs per unit: Commison Treat cost per unit Shipping and handling Total variable cost per unit Monthly volume Fixed costs per month: Salary Entry fee Total fixed costs per month Target profit per month Expected change in volume (%) Product #1 Unit CM Launch-it $ 10.00 CM % Breakeven point: $ 1.00 -in units $ 1.00 -in sales revenue $ 2.00 $ 4.00 Target profit volume: -in units $ 200.00 -in sales revenue Treat-time $ 30.00 Product #2 Unit CM $ 3.00 CM % $ 7.00 Breakeven point: $ 8.00 -in units $ 18.00 -in sales revenue $ 100.00 Target profit volume: -in units -in sales revenue $ 1,000.00 $ 500.00 $ 1,500.00 $ 8,000.00 5.00% Launch-it $ $ $ $ $ Treat-time $ $ S $ S Jake's Pet Supplies Pro Forma Contribution Margin Income Statement For the month ending June 30 Product #1 Product #2 2,000.00 $ 3,000.00 $ $ Sales revenue minus variable costs: Commisions $ Shipping and handling $ Purchase cost $ Total Variable costs $ 200.00 $ 400.00 $ 200.00 $ 800.00 $ 300.00 $ 800.00 $ 700.00 $ 1,800.00 $ Contribution Margin $ 1,200.00 S 1,200.00 $ Fixed costs: Entry fees $ Salary $ Total fixed costs: $ Operating income 6.00 60% 250.00 2,500.00 1,583.33 15,833.33 12.00 40% 125.00 3,750.00 791.67 23,750.00 WACM% $ Contribution Margin Sales units Contribution Margin Total 5,000.00 WACM/Unit 500.00 1,200.00 900.00 2,600.00 Multiproduct Breakeven point: Units 2,400.00 Breakeven units Price per unit Sales revenue at breakeven 500.00 1,000.00 1,500.00 Multiproduct Target profit point: Units Target profit 900.00 Price per unit Sales revenue at target profit 48% $ Calculation of Weighted average CM per unit Product #1 S Product #1 $ $ $ Product #2 1,200.00 $ 1,200.00 $ 200 100 6.00 $ 12.00 $ 100.00 Product #2 200.00 $ $ 125.00 $ 63.00 $ 10.00 $ 30.00 1,250.00 $ 1,890.00 $ Product #2 200.00 $ 792.00 $ 10.00 $ 7,920.00 $ 100.00 S 396.00 $ 30.00 $ 11,880.00 $ $ 1,860.00 37.20% $ 2.67 13.33% S Product #1 $ $ $ $ Margin of Safety (in $) Margin of Safety % Operating Leverage Factor Expected % change in operating income (%) Total Total Total 2,400.00 300 8.00 300.00 188.00 3,140.00 300.00 1,188.00 40.00 19,800.00 Save a copy of your original model to a new spreadsheet called "supplier cost increase". Say the supplier is expected to increase the cost of the products by 20%. What is the new operating income? What is the new WACM%? What is the new MOS%? Briefly explain your findings to the client. Operating income WACM percentage MOS% NEW ORIGINAL $ 900.00 48% 38% Change ASSUMPTIONS Product #1: Sales price per unit Variable costs per unit: Commision Launch cost per unit Shipping and handling Total variable cost per unit Monthly volume Product #2: Sales price per unit Variable costs per unit: Commison Treat cost per unit Shipping and handling Total variable cost per unit Monthly volume Fixed costs per month: Salary Entry fee Total fixed costs per month Target profit per month Expected change in volume (%) Product #1 Unit CM Launch-it $ 10.00 CM % Breakeven point: $ 1.00 -in units $ 1.00 -in sales revenue $ 2.00 $ 4.00 Target profit volume: -in units $ 200.00 -in sales revenue Treat-time $ 30.00 Product #2 Unit CM $ 3.00 CM % $ 7.00 Breakeven point: $ 8.00 -in units $ 18.00 -in sales revenue $ 100.00 Target profit volume: -in units -in sales revenue $ 1,000.00 $ 500.00 $ 1,500.00 $ 8,000.00 5.00% Launch-it $ $ $ $ $ Treat-time $ $ S $ S Jake's Pet Supplies Pro Forma Contribution Margin Income Statement For the month ending June 30 Product #1 Product #2 2,000.00 $ 3,000.00 $ $ Sales revenue minus variable costs: Commisions $ Shipping and handling $ Purchase cost $ Total Variable costs $ 200.00 $ 400.00 $ 200.00 $ 800.00 $ 300.00 $ 800.00 $ 700.00 $ 1,800.00 $ Contribution Margin $ 1,200.00 S 1,200.00 $ Fixed costs: Entry fees $ Salary $ Total fixed costs: $ Operating income 6.00 60% 250.00 2,500.00 1,583.33 15,833.33 12.00 40% 125.00 3,750.00 791.67 23,750.00 WACM% $ Contribution Margin Sales units Contribution Margin Total 5,000.00 WACM/Unit 500.00 1,200.00 900.00 2,600.00 Multiproduct Breakeven point: Units 2,400.00 Breakeven units Price per unit Sales revenue at breakeven 500.00 1,000.00 1,500.00 Multiproduct Target profit point: Units Target profit 900.00 Price per unit Sales revenue at target profit 48% $ Calculation of Weighted average CM per unit Product #1 S Product #1 $ $ $ Product #2 1,200.00 $ 1,200.00 $ 200 100 6.00 $ 12.00 $ 100.00 Product #2 200.00 $ $ 125.00 $ 63.00 $ 10.00 $ 30.00 1,250.00 $ 1,890.00 $ Product #2 200.00 $ 792.00 $ 10.00 $ 7,920.00 $ 100.00 S 396.00 $ 30.00 $ 11,880.00 $ $ 1,860.00 37.20% $ 2.67 13.33% S Product #1 $ $ $ $ Margin of Safety (in $) Margin of Safety % Operating Leverage Factor Expected % change in operating income (%) Total Total Total 2,400.00 300 8.00 300.00 188.00 3,140.00 300.00 1,188.00 40.00 19,800.00
Expert Answer:
Answer rating: 100% (QA)
Assumptions Product 1 Sales per unit Variable per unit Product Cost Shipping Sales Commission Total ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these business communication questions
-
After taking business classes, Jake, an avid dog-lover, decided to start selling unique pet supplies at trade shows. He has two products: Product 1: "Launch-it"- a tennis ball thrower that will sell...
-
After taking business classes, Bob, an avid cat-lover, decided to start selling unique supplies at trade shows. He has two products: Product 1: "Throw-it"- a tennis ball thrower that will sell for...
-
Now a days you can see young people are more and more into the idea of entrepreneurship. It could be the lifestyle, freedom at workplace, the flexibility in the working hours, or the freedom of...
-
A triangular truss structure is shown below. If all truss members are 2.0 m long (a, b, & c in the sketch) and forces L and Rare both 8.0 kN, then what is the force in truss member a? Assume that the...
-
On January 1, 2009, Affordable Financial, Inc., purchased the assets of Bisko Insurance Co. for $65,000,000, a price reflecting a $10,000,000 goodwill premium. On December 31, 2012, Affordable...
-
Perform the indicated base conversions: a. 548 to base 5 b. 3124 to base 7 c. 5206 to base 7 d. 122123 to base 9
-
Which class of stockholders takes the greater investment risk? a. Common b. Preferred c. Neither; bondholders take the most risk d. Both preferred and common take equal risk
-
The following information relates to three possible capital expenditure projects. Because of capital rationing only one project can be accepted. The company estimates its cost of capital is 18 per...
-
Q. 1 Clearly describe what is meant for a neural network to be completely connected? Also, describe what a weight coefficient (e.g., WA) refers to in a neural network (This Q adapted from DKD Q2) Q....
-
Bill and Kate Theil are not only husband and wife but entrepreneurs who have established three successful businesses. The proposed plan for their latest effort involves a series of international...
-
If f(x) = 5x1, and g(x) is x, determine the value of (fog)(4).
-
Explain characteristics of the emerging Social Age.
-
Describe the process for developing routine business messages.
-
Analyze presentation audiences in terms of message benefits, learning styles, and communicator styles.
-
Describe how delivering routine messages impacts credibility.
-
Describe how planning your presentations leads to credibility.
-
Income statement for the year ended 31 December. 2021 '000 2022 '000 Turnover 14,006.00 22,410.00 Cost of sales (7,496.00) (11,618.00) Gross profit 6,510.00 10,792.00 Operating expenses (4,410.00)...
-
After graduating from college and working a few years at a small technology firm. Preet scored a high-level job in the logistics department at Amex Corporation. Amex sells high-quality electronic...
-
What four components should MACS designers consider when addressing the relevance of the systems information?
-
What are sunk costs? Explain whether they are relevant costs.
-
What are the pros and cons of building slack into the budget from (1) the point of view of the employee building in slack and (2) from a senior managers point of view?
-
Describe, in your own words, the various uses of QuickBooks Accountant.
-
List the four basic features of QuickBooks Accountant.
-
Suppose a Super Comics location suffered a fire loss and needs to estimate the cost of the goods destroyed. Beginning inventory was \(\$ 50,000\), net purchases totalled \(\$ 300,000\), and sales...
Study smarter with the SolutionInn App