Question

read question carefully thanks

Mergea Center Formatting Table Styles Clipboard Alignment A B C D E Quesbon 4 F G I J MNOPQR Instructions: H Question 5 Fiscal YR 2017 1/28/2018 K Question 6 Fiscal Y 2016 1/31/2017 Fiscal Year ending Fiscal YR 2018 1/27/2019 Cum in ons, except turn and per store of SQ FT) in shaded cells If you did all the work in Excel, The cell 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 formula if need be, do not write Sales 44,000 41.500 1000% Total Sales growth% 5.7% EEN TITEL TE 4309 150 12 COGS GMS out 24.750 LLL LLLL SG& AS 16,000 39.0% will calc when Q6 answered 80020.09 18 Operating Income Not Income . VU NU I ranye ure wayuut ur URSS . # you do it will not link to the Summary sheet and I will not be able to award full credit for 19 - 20 21 45 46 47 48 Answer Summary 21- 3048 07. 9Q 10-14 Ready

Answer 1

Financial YR 2016

Operating Income = 20% of sales i.e $8,800

Therefore Sales = $44,000

COGS = 45% of sales

= $19,800

Gross Margin (in $) = Sales - COGS

= $44,000 - $19,800

= $24,200

Gross Margin (in %) = 1 - COGS %

= 1 - 0.45

= 0.55 or 55 %

SG & A (in $) = Gross margin - Operating Income

= $24,200 - $8,800

= $15,400

SG & A (in %) = SG & A / Sales

= $15,400 / $44,000

= 0.35 or 35 %

Fiscal YR 2017

Sales = $41,500

Gross Margin = $24,750

Gross Margin (in %) = Gross Margin / Sales

= $24,750 / $41,500

= 59.64%

COGS (in $) = Sales - Gross Margin

= $41,500 - $24,750

= $16,750

COGS (in %) = 1 - Gross Margin %

= 1 - 0.5964

= 0.4036 or 40.36%

SG & A = 39% of sales

SG & A = $16,185

Operating Income (in $) = Gross Margin - SG & A

= $24,750 - $16,185

= $8,565

Operating Income (in %) = Operating Income / Sales

= $8,565 / $41,500

= 0.2064 or 20.64%

Total Sales growth = (Current year Sales - Previous year sales) / Current Year Sales

= ($41,500 - $44,000) / $41,500

= -6.02%

Fiscal Year 2018

Sales = $44,000

COGS = 43% of sales

= $18,920

Gross Margin (in $) = Sales - COGS

= $44,000 - $18920

= $25,080

Gross Margin (in %) = 1 - COGS %

= 1 - 0.43

= 0.57 or 57 %

SG & A = $16,000

SG & A (in %) = SG & A / Sales

= $16,000 / $44,000

= 0.3636 or 36.36%

Operating Income (in $) = Gross Margin - SG & A

= $25,080 - $16,000

= $9,080

Operating Income (in %) = Operating Income / Sales

= $9,080 / $44,000

= 0.2064 or 20.64%