Assignment #3 Company Sales Analysis

*Sell Thru % for a season (6 months) is considered good when it is 80%. Because a quarter is only 3 months, sell thru over 40% is therefore considered good.
Questions (3 marks)
1. Calculate (in chart) the Sales % change for each classification between 2019 and 2020. (in chart)
2. Calculate the % of total Sales $ for each classification. (in chart)
3. Which Classification had the highest % of Total Sales $?
4. Which Classification had the highest sales % change between 2019 and 2020?
5. Which classification was the most successful for Q3, 2020? Explain why?

#2. This report shows Q3 2020 & 2019 results by week for the same retailer.
Product and Promotional Activity
Weeks 27-30 – Summer clearance
Weeks 30-31 – New fall orders were received and merchandised on selling floor
Week 31 – Back to School promotion 25% off new styles
Weeks 37-38 – Promotion 25% off all Tops

Week   Sales $ 2020 Sales $ 2019 Total Sold (units) 2020 Total On Hand (units) 2020 Total Received (units) 2020 *Sell Thru % 2020
27 Aug 4 $41,482 $48,850  1,269 1,772    
28 Aug 11 $54,861 $58,584  1,531 1,941    
29 Aug 18 $58,439 $57,901  1,739 2,208    
30 Aug 25 $51,225 $55,691  1,348 2,678    
31 Sep 1 $84,119 $49,979  2,227 3,415    
32 Sep 8 $56,064 $43,997  1,256 2,898    
33 Sep 15 $65,580 $59,649  1,689 2,756    
34 Sep 22 $59,152 $61,805  1,365 2,154    
35 Sep 29 $62,760 $52,797  1,418 2,145    
36 Oct 6 $83,061 $75,064  1,808 2,557    
37 Oct 13 $99,715 $83,891  2246 3,165    
38 Oct 20 $89,912 $70,983  2,110 2,988    
39 Oct 27 $52,685 $75,094  1,255 2,562    
Total Q3   $859,055 $794,285  21,261 33,239    

*Sell Thru % for a season (6 months) is considered good when it is 80%. Because a quarter is only 3 months, sell thru over 40% is also considered good. On Hand units are for the end of the quarter.
Questions (4 marks)

1.Calculate the Total Received in Units by week and for Q3 total. (in chart)
2.Calculate the Sell Thru % for each week and for Q3 total. (in chart)
3.Which 2 weeks had the highest Sell Thru %. Explain one reason why sell thru % might have been so high then.
4.In 2020 Back to School was set up in Weeks 30-31. Should they bring their product in earlier in 2021? Explain 1 reason why?

#3. This report shows Q3 2020 and 2019 results by store.

Selling Store   Sales $ 2020 % to Total
2020 Sales $ 2019 % to Total 2019 Sales % Change Sell Thru %
2020
Total ALL $859,055   $794,285     39.01%
1963 *E-commerce $258,033 30.0% $240,518 30.3% 7.3% 34.50%
1560 Toronto downtown $131,319 15.3% $121,541 15.3% 8.0% 51.46%
1101 Vancouver $101,106 11.8% $104,004 13.1% -2.8% 53.30%
1601 Montreal $97,442 11.3% $105,044 13.2% -7.2% 39.41%
1125 Edmonton $86,464 10.1% $96,504 12.1% -10.4% 36.01%
1144 Calgary $72,518 8.4% $68,517 8.6% 5.8% 40.94%
1554 Yorkdale $62,150 7.2% $58,157 7.3% 6.9% 26.45%
1112 Saskatoon $50,023 5.8% $0 0.0% new 30.34%
  Comparable Sales            
*The E-commerce channel is considered a store in this report and included in calculation of all your answers.

Questions (5 marks)
1. What is the Sales % change between 2020 and 2019? (in chart)
2. Which store had the highest sales increase between 2020 and 2019?
3. What were the “Comp” sales $ for 2019 and 2020? What was the “comp” sales % change between 2020 and 2019? (in chart)

#4 Create 1 graph (line, bar or pie) with your choice of relevant Sales $ data from Report #1 or from Report #3. Indicate in writing which report you used. The graph should be accurate, visually appealing and be the appropriate choice for the data. Write 1-2 sentences highlighting something significant about the data being shown which a buyer would notice. Add your graph here. (3 marks)