(B) You currently work for an automotive parts supply store. Your company is gro

Question

(B) You currently work for an automotive parts supply store.  Your company is growing and is considering expansion.  The company currently has three locations (North, South, and Central) in one state.  Each parts supply store carries inventory in four categories.  You have been presented with the sales figures for the last three years for each location and inventory category by store.  Based on this information, you're tasked with analyzing current sales for each store by category and overall total sales by store and category.

Note: This is a four part question.

1.) Explain your approach to setting up your worksheets and organizing the data.

2.) Explain how you will visually represent the data for the total sales of the individual inventory categories for each location for the time periods shown.

3.) Explain how you will visually represent the consolidated data for the sales of all stores and all inventory categories for all time periods in one chart or graph.

4.) Once you have finished the above tasks, you plan to send the Excel workbook to your manager for evaluation.  Your manger is presenting your findings to the Board of Directors for justification for additional capital expenditures.  The visual representations need to be concise and clearly able to support the requested expenditures.  Explain how you would use the integration features of MS Office to incorporate the Excel information into other presentation media.

Explanation / Answer

Your question contains a project rather than pertaining to questions . In excel , you can use your stored date and Pivot table , a friendly user tool , if you make, by going to Insert Menu and click pivot tab, then you have all the data arranged in to a whichever fashion you like. You have to have formula skills or using skills of functions, fx according to your needs. after aranging your tables, then you could use conditinal formating tab, in the Style menu, conditional format table , There you could select the type of table, with colours and design, by selecting the Table range including headings. These simply makes perfect oriented presentation. You could use Chart Wizard from pivot table to impress upon your boss, as a picture easily depicts a story better than words.
Regarding organising data , first you have to get all the stores data and combine them in a separate sheet and from then you could prepare your pivot table, you could choose, where to have the colums, row the data have to represent, irrespective of the actual excel data in original sheet and its friendly wizard will do the rest. You could sum, count, give subtotal etc using pivot table
You could still more analyse the data with analysis tool pak, where you could make intrinsic statistical calculations on data. This , you could add to your excel , by going to Office Excel Menu, the Big menu at the main excel, and then selecting Excel Options, select Adds in, and then on the bottom, Select Excel adds in and click on "GO". You will be presented with analyis tool pak, and you could click to install, it will install and will be found in the Data Tab at the far right end. You could use it by clicking and it shows variety of statistical functions like correlation of multiple range of cells.
Best of luck

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.