EXCEL SPREADSHHET
Budget: $100 – $150 USD
Based on the data, describe your company's typical customer.
1. Does this differ based on location?
2. Which store location is most popular? (you have data for Sales outlets: 3, 5, and 8)
3. What products sell the best at each location (Sales outlets:3, 5, and 8) and overall across the company?
4. Which products would you recommend discontinuing?
5. Did the locations make their unit sales goals? (Sales outlets 3, 5, and 8)
One additional data point that you feel feels would be relevant to the leadership team
Use a minimum of 3 Charts/Graphs to visually showcase the data that helped you answer the above questions
Use a minimum of 5 functions and/or formulas to arrive at the answers to the questions above.
1. Does this differ based on location?
2. Which store location is most popular? (you have data for Sales outlets: 3, 5, and 8)
3. What products sell the best at each location (Sales outlets:3, 5, and 8) and overall across the company?
4. Which products would you recommend discontinuing?
5. Did the locations make their unit sales goals? (Sales outlets 3, 5, and 8)
One additional data point that you feel feels would be relevant to the leadership team
Use a minimum of 3 Charts/Graphs to visually showcase the data that helped you answer the above questions
Use a minimum of 5 functions and/or formulas to arrive at the answers to the questions above.