Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Section B Analysis & Critical Thinking Jan Feb Jun 120 40 48 58 36 May 40 20 24 || |||| U Location Central Central Central
Section B Analysis & Critical Thinking Jan Feb Jun 120 40 48 58 36 May 40 20 24 || |||| U Location Central Central Central South South South Central Mar 60 66 79 95 Outlet Product Anton Kedai Runcit Kopi AXZ (Powder) Anton Kedai Runcit White coffee BYZ (Powder) Anton Kedai Runcit WZ Pretty drink cans Kedai Ali Kopi AXZ (Powder) Kedai All White coffee BYZ (Powder) Kedai Ali WZ Pretty drink cans Anton Kedai Runcit Energy drink FYZ cans Apr 42 16.8 20 24 50 70 84 43 75 69 83 29 35 101 121 90 114 29 69 52 95 24 29 101 48 13 66 17 20 98 58 36 7 70 South Central South Kedai Ali ABC Koko drink cans Anton Kedai Runcit Energy drink FYZ cans Kedai Ali ABC Koko drink cans 100 69 73 125 87 16 27 118 10 20 14 8 10 118 Table 1: Customer sales data Jan-Jun 2021 1) Based on table 1 above, analyze the sales data of the past 6 months in 2021 and identify the following: i. The selling trend of powder vs cans products Top 2 products that are the best seller 2) Combining your research with your learnings from the video above, in your opinion what could influence sales result over the past 6 months. Note: Please provide your answer in Excel or slide format (not more than 3 slides) and provide your answer in point form. Section B Analysis & Critical Thinking Jan Feb Jun 120 40 48 58 36 May 40 20 24 || |||| U Location Central Central Central South South South Central Mar 60 66 79 95 Outlet Product Anton Kedai Runcit Kopi AXZ (Powder) Anton Kedai Runcit White coffee BYZ (Powder) Anton Kedai Runcit WZ Pretty drink cans Kedai Ali Kopi AXZ (Powder) Kedai All White coffee BYZ (Powder) Kedai Ali WZ Pretty drink cans Anton Kedai Runcit Energy drink FYZ cans Apr 42 16.8 20 24 50 70 84 43 75 69 83 29 35 101 121 90 114 29 69 52 95 24 29 101 48 13 66 17 20 98 58 36 7 70 South Central South Kedai Ali ABC Koko drink cans Anton Kedai Runcit Energy drink FYZ cans Kedai Ali ABC Koko drink cans 100 69 73 125 87 16 27 118 10 20 14 8 10 118 Table 1: Customer sales data Jan-Jun 2021 1) Based on table 1 above, analyze the sales data of the past 6 months in 2021 and identify the following: i. The selling trend of powder vs cans products Top 2 products that are the best seller 2) Combining your research with your learnings from the video above, in your opinion what could influence sales result over the past 6 months. Note: Please provide your answer in Excel or slide format (not more than 3 slides) and provide your answer in point form
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started