Assignment #3 Company Sales Analysis
ORDER # | 100045 |
PAPER TYPE | ESSAY |
WRITING LEVEL | UNDERGRADUATE |
WRITING STYLE | APA |
# 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