Approach to setting up your worksheets-organizing data

Assignment Help Other Subject

Reference no: EM13295362

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 visually representations need to be concise and clear by 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.

Reference no: EM13295362

Questions Cloud

Critical value approach to test the hypothesis : Use the critical value approach to test the hypothesis that proportion of full-time college student in the State of NY who are employed is different from the national norm of 46%. Use the .05 level of significance.

What is the present value of the benefits from year 4 : The project will reduce annual cash payments for maintenance by $25,000 per year over the next five years. At the end of five years the machinery can be sold for $10,000. MMW has a tax rate of 30% and a discount rate of 6%.

What is the internal rate of return of this project : Arlington Industries is considering a project with a cost today of $58,346 and benefits of $15,000 per year for the next five years.

What is a source of nursing research : The research problem can be developed from many sources. What is a source of nursing research? Identify a potential research study example from that source.

Approach to setting up your worksheets-organizing data : 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 ca..

Ultimately prepare a detailed report with recommendations : Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.

Previous encounters with the patient : Why is it beneficial to the provider that the Chief Complaint, Present Illness, Review of Systems, Examination, Procedure, Other Treatment, and Follow-up/Reminder areas of the OV screen display additional notes from previous encounters with the patie..

Calculate total production for the entire company each week : You've just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures only one product, the gizmo. It comes in two sizes, the mini-gizmo and the magna-gizmo. Both are difficult to manufacture, and consequently, the company ..

What sports casue equal development : What are some activities or sports that would cause unequal development of the shoulder joint? What sports casue equal development?

User Account

All Pages