1. Projects main finding(s). Keep in mind that this entire deliverable is an executive summary. Without going into details about how you arrived at the final findings, explain the final conclusions that you arrived as the result of your analysis.
2. Recommendations. In this section, you offers action items as next steps based on what your analysis revealed.
3. Submit your Executive Summary

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.

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.