How you would use the integration features of ms office

Reference no: EM13265090

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.

Reference no: EM13265090

Questions Cloud

Explain maleic anhydride and 2,3-dimethylbutadiene : You weighed out 204 mg of maleic anhydride. Which volume of 2,3-dimethylbutadiene will you need to add? The answer should be in mL with three digits after the decimal point.

Write a function that takes inputs of quarts and pints : Use appropriate parameter passing and return mechanisms. Use appropriate datatypes. For example, with inputs of 4 quarts and 4 pints, the result would be 1.5 gallons. Use proper code formatting techniques. Do not write a main routine. Your functio..

Comput the after-tax cost of each component of capital : The Mortgage bonds are currently selling for $1,073.61. The bonds are 7%, $1,000 par and pay interest annually. They will mature in 10 years.

The silver-silver chloride reference electrode in a solution : A cell composed of a platinum indicator electrode and a silver-silver chloride reference electrode in a solution containing both Fe2 and Fe3 has a cell voltage of 0.725 V. If the silver-silver chloride electrode is replaced with a saturated calome..

How you would use the integration features of ms office : 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.

Determine what is the output of the statement : Given the following array declaration, if the array is stored starting at address 1000, what is the output of the following statement? Assume the code is for a 32 bit processor such as a Pentium.

What ethics means for my work : Reflect on the relevance of ethics in your future professional life which in this case is accounting.

Important to marketing health care products and services : How and why is pricing critically important to marketing health care products and services? What factors play a role in the pricing decision?

Discuss and list six cultural factors : Discuss and list six cultural factors that can impede the success of a merger or acquisition between two companies after all legal and financial arrangements are finalized and the M & A is completed.

User Account

All Pages