Data Analytics Problem DAPS.1 Data Analytics Wheels and Skis Inc. is a seasonal business that sells...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/03/65f40dc9e3674_12965f40dc9c8118.jpg)
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.
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these accounting questions
-
An FI offers a $2,500 minimum balance NOW account paying 4 percent annual interest, and there are no service charges as long as the customer maintains the minimum balance. The customer maintains a...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Homework-2 DECISION ANALYSIS PROBLEMS Problem-1: Kenneth Brown is the principal owner of Brown Oil, Inc. After quitting his university teaching job, Ken has been able to increase his annual salary by...
-
1/ You just started working and you planned to save $5,000 every year in your retirement account. How much money will you have in your retirement account once you retire in 40 years? Your retirement...
-
Find the domain of each function. (a) (b) (c) Vet 1 (x+ x
-
Do you think that Brad Smith is a good leader? Why?
-
Statement No. 138 allows companies to account for certain hedges of existing foreign currency- denominated receivables and payables as cash flow hedges. Under Statement No. 133, hedges of existing...
-
A location analysis for Temponi Control, a small manufacturer of parts for high-technology cable systems, has been narrowed down to four locations. Temponi will need to train assemblers, testers, and...
-
Give a couple of numeral examples to show how coverage ratios help to identify the risk or coverage ability on risk. Hint: Times interest earned, EBITDA coverage ratio, cash flow operations to total...
-
Consider the 2013 declined loan data from LendingClub titled RejectStatsB2013 from the Connect website. Similar to the analysis done in the chapter, lets scrub the risk score data. First, because our...
-
5 FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available for sale during the year: Beginning inventory 37 units at $43 Sale 29 units at $62 First purchase...
-
Jimmy Joe-Bob Hicky is the district commander for the mostly-rural Spud Valley highway patrol district in western Idaho. Hes attempting to assign highway patrol cars to different road segments in his...
-
Its important to have a holistic view of all the businesses combined and ensure that the desired levels of risk management and return generation are being pursued. Agree or disagree
-
(3pts each) During a trip to a casino, Adam Horovitz plays his favorite casino game 10 times. Each time he plays, he has a 41% chance of winning. Assume plays of the game are independent. a. What is...
-
An epidemiologist plans to conduct a survey to estimate the percentage of women who give birth. How many women must be surveyed in order to be 95% confident that the estimated percentage is in error...
-
Statement of financial position as at 31 December 2014 ASSETS Non-current assets Property, plant and equipment Delivery van at cost 12,000 Depreciation (2,500) 9,500 Current assets Inventories...
-
View Policies Current Attempt in Progress Wildhorse Co. purchased land as a factory site for $520,000. The process of tearing down two old buildings on the site and constructing the factory required...
-
Discrete sample spaces: suppose there are N cable cars in San Francisco, numbered sequentially from 1 to N. You see a cable car at random; it is numbered 203. You wish to estimate N. (See Goodman,...
-
How do you participate in the debate on state ownership versus private ownership?
-
Wolves are the planets most widespread land-based large mammals. They used to be humans most direct competitors for meat. As a result, the Big Bad Wolf occupied a center stage in our psyche as a...
-
You are a Peruvian national who serves as head of the Brazilian subsidiary of a large US multinational. While Brazil is theoretically attractive, the going has been tough and chances for becoming...
-
Given the following project (all times are in days): LO6 Act- Prede- Normal Normal Crash Crash ivity cessor Time Cost Time Cost a 5 $50 3 $150 b 4 40 2 200 c b 7 70 6 160 d a, c 2 20 1 50 e a, c 3...
-
Given the project shown in Figure 5-10 of Chapter 5, assume that a facility used by activities c and d is scarce. To which activity would you assign the facility first, given the following rules: LO6...
-
Given the following project to landscape a new building site: Activity LO6 Immediate Duration Resource Activity Predecessor (days) Used A 2 X, Y B A 2X C A 3X D B, C 4 X, Y E D 3 W, X F D 1 W, X, Y...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App