Describe how to represent comparison of total annual sales

Reference no: EM1367679

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, and wants to consider expanding within the same state. You have been presented with the sales figures for the last three years for each of your locations. Based on this information, you're tasked with analyzing current sales.

You have decided to compare the performance of the three stores to get a better idea of where expansion might be most beneficial. Respond fully to the following questions regarding this task.

A - The data has been provided to you in one .csv file showing weekly sales for all three stores for the last three years. Explain the tasks you must complete in preparing the data for your analysis.

B - Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. Remember that you have only weekly sales totals for each store in the data.

C - Explain how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performer (the North store) stand out.

D - Once you have finished the above tasks, your Excel workbook will be placed on your company server so that all of the managers can view it. You know that they may have questions regarding your work, and want them to know that you created the workbook so that they can contact you. Describe how you will convey the information regarding worksheet creation.

Reference no: EM1367679

Questions Cloud

Changes to the edication of nursing : In this world of advanced technology and an ever growing knowledge base of nursing it is essential for schools of nursing to assess the way nursing is taught.

Relevant and irrelevant costs : Illustrate and fully describe using an example of relevant cost (a cost whose value does affect the optimal decision) and an example of irrelevant cost (a cost whose value does not affect the optimal decision) to the business regarding this decisi..

What is the area of leaf : If, instead, the gold is drawn out into a cylindrical fiber of radius 1.5µm, what is the length of fiber.

Define absolute and comparative advantage in your own words : Define absolute and comparative advantage in your own words. Elucidate how absolute and comparative advantages were used in your simulation.

Describe how to represent comparison of total annual sales : Describe how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performer (the North store) stand out.

Multiple choice questions on purchasing power parity : Smith identify that if the forward rate is lower than what interest rate parity indicates, the appropriate strategy would be to lend:

Show output for different combinations of labour and capital : Assume you are looking at data for an economy that uses only two inputs, physical capital and labour. Table shows output for different combinations of labour and capital.

Scientific management theory-routines in health care : Based on the scientific management theory, write down some of the routines in health care that seem to be inefficient?

Prepare a form for abc partnership : Prepare a form 1065 for ABC Partnership, including the Schedule K-1 for the partners and all other required schedules - information is missing make reasonable assumptions and attach a listing of those assumptions

User Account

All Pages