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...
-
Epoxy Corporation is evaluating whether to lease or purchase needed equipment at a cost of $10,000. If the equipment is leased, the lease would not have to be capitalized. The company's balance sheet...
-
On January 3, 2013, Matteson Corporation acquired 40 percent of the outstanding common stock of O'Toole Company for $1,160,000. This acquisition gave Matteson the ability to exercise significant...
-
Gardner (1990) identified the following tasks that leaders perform: A. Representing the group by speaking on its behalf. B. serving as a symbol by acting in ways that convey the values of the group...
-
The Louisiana Land and Cattle Company (LL&CC) is one of the largest cattle buyers in the country. It has buyers at all the major cattle auctions throughout the U.S. Southeast who buy on the companys...
-
Bank Reconciliation When should this be done? Who should prepare this report? Why do we prepare this report? What does it show?
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
According to AASB 121, the currency in which an entity primarily generates and expends cash is considered to be the a) economic currency b) presentation currency c) domestic currency d) functional...
-
In car painting the spray gun is charged positively. Therefore paint particles become positively charged. When the paint is sprayed particles repel each other. Also the car is grounded. Grounding...
-
Given the information answer the question. Stock proceeds: $7,500 Debt payment: ($5,000) From the above information: What is the cash flow from financial activities?
-
Two alpha particles (mass = 6.6 x 1027 kg & charge = 3.2 x 10-19 C), separated by an enormous distance, approach each other along a "head-on" collision path. Each has a speed of 3.0 x 10 m/s...
-
The following angles are given in degrees. Convert them to radians: a. 20 b. 35 c. 80 d. 270
-
A college student realized that he was spending too much money on movies. For the remaining 5 months of the year his goal is to spend a mean of $40 a month towards movies. How much can he spend in...
-
2. Individual demand and consumer surplus Consider the market for antique cars. The market price of each antique car is $300,000, and each buyer demands no more than one antique car. Suppose that...
-
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?
-
Navarro, Inc., issued \(\$ 250,000\) of eight percent, 20 -year bonds at 98 on June 30, 2012. Interest is payable semiannually on December 31 and June 30. Through June 30, 2018, Navarro amortized...
-
Determine which of the following transactions represent contingent liabilities for June Leasing and indicate the proper accounting treatment at the company's fiscal year-end, by placing the letter of...
-
On December 31, 2017, James, Inc., borrowed \(\$ 300,000\) on a six percent, 20 -year mortgage note payable. The note is to be repaid in equal semiannual installments of \(\$ 12,979\) (beginning July...
Study smarter with the SolutionInn App