Assignment #3 Company Sales Analysis
|# OF SOURCES||N/A|
|# OF PAGES & WORD COUNT||3≈ 825 WORDS|
|Assignment #3 Company Sales Analysis (15%)|
Due by 11pm on Tuesday, April 20th
Post completed assignment into the BB Grade book.
Review the Quarter 3 (Q3), 2020 reports below for a Canadian retailer that has 7 brick and mortar stores in malls and an online business. Q3 started Aug 2 and finished Oct 31. They sell women’s apparel that is moderately priced and their primary customers are 19 – 35 years of age. The Buyers and senior team are reviewing the results for Q3 2020 to help them strategize for Q3 2021.
(note: in this assignment there is no pandemic impacting sales in either year)
Round all percentages to 2 decimal places.
#1. This report shows results by classification for Q3, 2020 and 2019.
Classification Sales $ 2020 Sales $ 2019 Sales % Change
% of Total Sales $ 2020 *Sell Thru % 2020
Knit Tops $398,767 $348,850 45.57%
Woven Tops $114,861 $108,584 36.81%
Casual Bottoms $78,439 $77,235 22.41%
Dress Bottoms $51,225 $45,691 28.46%
Skirts $84,119 $79,979 35.05%
Jackets $66,063 $63,997 22.02%
Sweaters $65,581 $69,949 42.59%
Total Q3 $859,055 $794,285 39.01%
*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.
#2. This report shows Q3 2020 & 2019 results by week for the same retailer.
Week Sales $ 2020 Sales $ 2019 Total Sold (units) 2020 Total On Hand (units) 2020 Total Received (units) 2020 *Sell Thru % 2020
*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.
1.Calculate the Total Received in Units by week and for Q3 total. (in chart)
#3. This report shows Q3 2020 and 2019 results by store.
Selling Store Sales $ 2020 % to Total
Questions (5 marks)
#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)
Assignment #3 Company Sales Analysis, please click on https://academicessayist.com/orders/ordernow