Project Proposal regarding the project attached below:

• Project Description: In two to three paragraphs in your words, what is the situation that you will undertake.
• Source for the Data: what is the source of the data that will serve as the basis of your data analysis. The data may originate from other applications and be imported into Excel.
• Type of Analysis: what is the type of data analysis that you will be performing. Describe the type of charts that you will create. Again, this is subject to change as you learn about Excel and go through the exercises planned for the course. See the section titled Features of Excel to Be Utilized in Your Analysis (near the end of this document) for a list of features that we will work with in this course.

The Project is called : Burnside Storage (attached to serve as a reference)

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. Burnside's Storage sells the following items:

Inventory Type

Number Description

B003 8' Picnic Table Table

B007 8' x 4' Steel Shed Shed

B008 6' x 4' Steel Shed Shed

B009 Bending Trellis Trellis

B010 12' Wishing Fount Fount

B011 10' x 16' Aluminum Outbuilding Outbuilding

B012 Burnside's Better Trellis Trellis

B014 8' x 6' Steel Shed Shed

B016 8' x 10' Picnic Table Table

B017 10' x 14' Steel Shed Shed

B018 8' x 10' Aluminum Outbuilding Outbuilding

B019 4' Aerogenerator Aerogenerator

B022 8' x 10' Pine Shed Shed B023 6' x 20' Covered Span Span

B025 12' Square Pine Gazebo Gazebo

B026 12' x 20' Steel Shed Shed

B031 12' Pine Rotunda Rotunda

B033 8' x 10' Steel Outbuilding Outbuilding B034 6' x 6' Pine Garden Shack Shack

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.

1. Professor Burnside wants a pivot table of the data. The column heading is type. The value to be averaged is Annual Gross Profit.
2. 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.
3. Create a dashboard that shows the KPI (Key Performance Indicators).
4. Create a menu system that allows Professor Burnside to move to any worksheet in the workbook and back to the menu.

Professor Burnside has provided the following data from last year for you to test your workbook.

On

Inventory Hand Sales

Number Cost Price Quantity per year

B003 211 350 44 157 B007 425 700.75 50 215

B008 310 520.99 50 241 B009 50 57 20 100

B010 131 195.99 25 147

B011 810 1075.99 10 67 B012 770 850 25 70 B014 150 200 50 500

B016 270.99 399.99 50 299 B017 650 1200 20 250 B018 540 805 50 600 B019 31 46 300 201 B022 1140 1800 72 100 B023 1250 1401 42 75 B025 2500 3000 71 144 B026 1393.56 1950.99 32 65 B031 2970 3500 15 39

B033 840.47 1050.99 80 210 B034 880 951 120 330

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.