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...
-
a. After sampling 1,000 members of a normal population, you find x = 15,500 and s = 9,950. Estimate the population mean with 90% confidence. b. Repeat part (a) assuming that you know that the...
-
A union that trains and restricts supply has an effect on the supply curve that moves it to the ______ and, at a point, makes it _______. a. Left; vertical b. Left; horizontal c. Right; vertical d....
-
Which of the following reasons would indicate that a company should consider using departmental overhead rates rather than using a single plantwide overhead rate? a. Each product is in each...
-
Fortunado, Inc., uses activity-based costing to account for its chrome bumper manufacturing process. Company managers have identified four manufacturing activities: materials handling, machine setup,...
-
11. 12. The product formed in the first step of the reaction of Br CH3-CH2-CH-CH2-CH-CH3 with excess Mg/ Et2O (Et = C2H5) is: Br (A) CH3-CH2-CH-CH2-CH-CH3 H3C-CH-CH2-CH-CH2-CH3 CH2 (B) CH3-CH CH-CH3...
-
This is a new manufacturing corporation that issued $50000 common stock for cash on the first day. All overhead expenses are paid immediately by cash. To make it easy, there are no other operating...
-
Provide a capability audit to UAEs local organization. Focus on how Technology and management is effecting or effected by the capability factors, to be in alignment with OD. - Apply the concept of...
-
Match the following normalized impedances with points A, B, C, D, and E on the Smith chart of Figure 11.44. (i) 0 + j0 (ii) 1+ j0 (iii) 0 j1 (iv) 0 + j1 (v) + j (vi) [Zin / Z]min (vii) [Zin / Z]max...
-
Well, its my job that brought us here in the first place I am going to have to make a decision to stick with this assignment and hope I can work things out, or to return to the United States and...
-
The success of Japans Olympus was based largely on the corporate leadership system consensus driven, government supported, and rife with cronyismthat was successful when Japan was one of the...
-
Choose a company following a conglomerate diversification corporate strategy, such as Berkshire Hathaway, Reliance Industries, or Alibaba. Identify the extent to which its diversification strategy...
-
The above statements truly reflect HSBC Holdings (hereafter HSBC) massive and distinct operations in 2012 that maintained 89 million customers worldwide. Originally known as Hong Kong Shanghai...
-
Davis Inc has the following inventory data: July 1 July 7 July 22 Beginning inventory 30 units at 8 105 units at Purchases $12 Purchases 15 units at $13 A physical count of merchandise inventory on...
-
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?
-
Figure 5 shows a scatterplot for the variables number of farms and mean farm size in the United States. Each dot represents data from a single year between 1950 and 2000; on this diagram, the earlier...
-
The scatterplots in Figure 6 show two weeks of data comparing the actual high temperature for the day with the same-day forecast (part a) and the three-day forecast (part b). Estimate the correlation...
-
Youve conducted a study to determine how the number of calories a person consumes in a day correlates with time spent in vigorous bicycling. Your sample consisted of ten women cyclists, all of...
Study smarter with the SolutionInn App