Analysis of the sales numbers to management

Assignment Help Business Management

Reference no: EM13774632

Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following

Monthly sales by Region
Quarter One sales by Region
Monthly sales by Product
Quarter One sales by Product
Monthly sales by Region, by Sales people
Quarter One sales by Region, by Sales people
Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc...

Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:

Use the SUM function
The date function
An additional math or statistical function of your choice
Fill colors to differential areas of your spreadsheet
Border lines to differential area of your spreadsheet

Reference no: EM13774632

Questions Cloud

Write an essay paper on legalizing same-sex marriages : Write an essay paper on Legalizing Same-Sex Marriages.

Work breakdown structure and network diagram : According to the PMBOK Guide, "the WBS is a deliverable-oriented hierarchical decomposition of the work to be executed by the project team, to accomplish the project objectives and create the required deliverables." In other words, it lists the pr..

Create and describe two fictional public organizations : Create and describe two fictional public organizations. One organization should be structured around the closed organizational model, while the second should be structured around the open organizational model

Well-designed activity-based costing system : 1) A well-designed activity-based costing system starts with __________.

Analysis of the sales numbers to management : Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:

Describe the house of old : Describe the House of Old. Why did Jonas choose to do his volunteer hours in a variety of places? What does this demonstrate about him?

Fire detection and protection systems : What recommendations would you make relative to fire detection and protection systems?

Provide a definition of the terms felony : Using the assigned reading material, provide a definition of the terms felony and misdemeanor as they relate to criminal acts. Using one of the resources in the Week 2 category found in the Webliography of this course, examine the elements of four di..

Develop a two level work breakdown structure : Develop a two level Work Breakdown Structure. Develop a network diagram and determine the critical path. Use your expanded MS Project to illustrate how quality and scope management are related.

User Account

All Pages