Professor Burnside has a side mail order business called Burnside Storage which sells storage kits and other items used in backyards. Professor Burnside has been keeping the inventory figures manually. He has decided that a spreadsheet application can help him keep better tabs on the inventory and allow him to analyze how will the company is doing selling each unit. He has entered all of last years sales data in a workbook named Burnside Storage.xlsx. Download the Burnside Storage workbook from the course project link.

Professor Burnside needs the worksheet to provide the following analysis:

1. Professor Burnside needs to know the cost of the inventory, the annual sales, cost of goods sold, annual gross profit and markup percentage for each item.

2. Professor Burnside wants to know the sum, average, maximum and minimum for cost of the inventory, annual sales, cost of goods sold, and annual gross profit.

3. Professor Burnside wants the worksheet to flag any item that has a markup of 25% or less so he can decide if the price needs readjustment. The formula for Markup is =(Price-Cost)/Cost

4. Professor Burnside wants to identify the top five best selling items.

5. Professor Burnside wants to see a pie chart showing the percentages each item makes up of gross profit margin. Move to a separate worksheet. Name the sheet.

6. Professor Burnside wants a line chart comparing the inventory costs of the items. Move to a separate worksheet. Name the sheet.

7. Professor Burnside needs a bar chart that compares Cost of Goods Sold with Annual Sales. Move to a separate worksheet. Name the sheet.

8. Professor Burnside wants a pivot table of the data. The column heading is type. The value to be averaged is Annual Gross Profit.

9. Professor Burnside wants a pivot chart of the data by type. Professor Burnside wants a slicer to be able to change the Type for closer inspection.

All dollar values are to be formatted to currency. All columns that have percentages are to be formatted using percentage with two decimal places. The header of the worksheet must include the business name and be date/time stamped. The footer must contain the name of the creator of the workbook.

The questions.

Source for the Data: Explain the source of the data that will serve as the basis of your data analysis.

Type of Analysis: Explain the type of data analysis that you will be performing. Explain the decision that your team wants to arrive at. Describe the type of charts that you will create.