Any help with these excel formulas would be greatly appreciated NIKE is deciding

Question

Any help with these excel formulas would be greatly appreciated

NIKE is deciding whether to produce a new sneaker designed for long-distance runners. In order to make a final decision, NIKE needs you to create a CVP income statement using the following information Sales Revenue Cost of Goods Sold Gross Profit Selling and Admin Expenses Net Operating Income $34,350,000 19,038,000 15,312,000 10,563,000 $4,749,000 COGS Fixed Cost Percentage S& A Fixed Cost Percentage 55% 6096 Requirement #1-Complete the CVP income statement. $34,350,000.00 Sales Revenue Variable Cost Contribution Margin Fixed Cost Net Operating Income #DIV/0! $16,808,700.00 $4,749,000.00 Requirement #2-Calculate the Contribution Margin Ratio. (Show as a percentage, round to O decimals) Contribution Margin Ratio #DIV/0! Requirement #3-Calculate the Degree of Operation Leverage. Round to 2 decimals) Degree of Operating Leverage

Explanation / Answer

1) Complete the CVP income statement :

2) Contribution margin ratio = Contribution margin*100/sales= 21557700*100/34350000 = 63%

3) Degree of operating leverage = Contribution margin/Income from operations = 21557700/4749000 = 4.54

Sales revenue 34350000 Variable cost (19038000*45%+10563000*40%) (12792300) Contribution margin 21557700 Fixed cost (19038000*55%+10563000*60%) (16808700) Net operating income 4749000

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.