Question

please read carefully the instructions thanks

Home Insert Arial B IU. Page Layout -11-AA == . .A IEEE Wrap Text Mergea Center General - % . Conditional Formatas Cell Formatting Table Styles Insert Delete Format aboard Font Alignment 8 x F G I L M N O P R S T Instructions: Question 1 Fiscal YR 2018 1/27/2019 H Question 2 Fiscal YR 2017 1/28/2018 K Question 3 Fiscal YR 2016 1/31/2012 Fiscal Year ending minions, except turn and per store of SOFT) 24500 24 000 Fill in shaded cells If you did all the work in Excel The cel should show your answer. But leave the formulas you used in the cells. This is so I can try to determine what might be misunderstood I will look at the background formulated be do not write out Sales This cell will calculate whe Q3 answered Total Sales growth % 20% 10001 COGS GMS 10.535 13,965 435 5709 TILL SGS AS SI DO NOT change the layout of these sheets. If you do it will not link to the Summary sheet and I will not be able to award full credit for correct answers, 17 LILIT Operating Income Net Income -9 1014

Answer 1

To make the explanations easy, let us solve the question step by step

Financial YR 2016

COGS = $10,000 (i.e. 45% of sales)

Therefore, sales can be computed as = COGS / 0.45

= $10,000 / 0.45

= $22,222.22

Gross Margin (in $) = Sales - COGS

= $22,222.22 - $10,000

= $12,222.22

Gross Margin (in %) = 1 - COGS %

= 1 - 0.45

= 0.55 or 55%

Financial YR 2017

Sales = $24,000

COGS = 44%

COGS = 44% of Sales

= $10,560

Gross Margin (in $) = Sales - COGS

= $24,000 - $10,560

= $12,440

Gross Margin (in %) = 1 - COGS %

= 1 - 0.44

= 0.56 or 56%

Total Growth in sales = (Sales in current year - Sales in previous year) / Sales in previous year

= ($24,000 - $22,222.22) / $22,222.22

= 0.08 or 8%

Financial YR 2018

Sales = $24,500

Gross Margin = 57%

Gross Margin = 57% of sales

= $13,965

COGS (in $) = Sales - Gross Margin

= $24,500 - $13.965

= $10,535

COGS (in %) = 1 - Gross Margin %

= 1 - 0.57

= 0.43 or 43%