Data Analytics Problem DAPS.1 Data Analytics Wheels and Skis Inc. is a seasonal business that sells...

Transcribed Image Text:

Data Analytics Problem DAPS.1 Data Analytics Wheels and Skis Inc. is a seasonal business that sells bikes and skis. Offering products for both summer and winter outdoor activities allows sales to be more evenly spread over the year. The key period for selling skis is from October to December and for selling bikes is from April to August. The company is looking to gather some historical data regarding inventory turnover and has collected monthly sales and inventory data for both the bikes and skis categories. The company is hoping to use this data to manage Inventories a bit better. You are the newly hired data analyst for the company and have been asked to do the following: a. Create a pivot table (using Excel) showing the following: (1) year, (2) average value of inventory for each year, and (3) cost of goods sold for the year. b. Calculate average turnover for each year and add to the pivot table. c. Create a bar chart showing turnover for the past five years. d. What Information does this visualization tell you about turnover over the past five years? e. Create a line chart showing cost of goods sold versus inventory for the past year. f. What information does this visualization tell you about monthly sales and inventory levels? Instructions Go to Wiley's course resources for additional Instructions and material to complete this question. Data Analytics Problem DAPS.1 Data Analytics Wheels and Skis Inc. is a seasonal business that sells bikes and skis. Offering products for both summer and winter outdoor activities allows sales to be more evenly spread over the year. The key period for selling skis is from October to December and for selling bikes is from April to August. The company is looking to gather some historical data regarding inventory turnover and has collected monthly sales and inventory data for both the bikes and skis categories. The company is hoping to use this data to manage Inventories a bit better. You are the newly hired data analyst for the company and have been asked to do the following: a. Create a pivot table (using Excel) showing the following: (1) year, (2) average value of inventory for each year, and (3) cost of goods sold for the year. b. Calculate average turnover for each year and add to the pivot table. c. Create a bar chart showing turnover for the past five years. d. What Information does this visualization tell you about turnover over the past five years? e. Create a line chart showing cost of goods sold versus inventory for the past year. f. What information does this visualization tell you about monthly sales and inventory levels? Instructions Go to Wiley's course resources for additional Instructions and material to complete this question.

Answer rating: 100% (QA)

a To create the pivot table in Excel you would follow these steps 1 Open Excel and import your sales ... View the full answer