Analysis of the sales numbers to management

Assignment Help Database Management System

Reference no: EM13771227

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: EM13771227

Questions Cloud

Present a causal analysis of the given problem : Present a causal analysis of the problem that establishes the seriousness or stakes of the problem and leads logically to your proposed response.

Laws define discrimination based on sexual orientation : How do those laws define discrimination based on sexual orientation? What remedy do those laws provide when there has been discrimination based on sexual orientation?

Elements of an effective safety training program : What are the elements of an effective safety training program? Describe what you think the best type of training method is and why. When designing safety training, how would you evaluate it for effectiveness?

Example of a health care capital expenditure : Provide an example of a health care capital expenditure. Why is the capital expenditure budgeting process important? What concepts should be considered when evaluating a capital expenditure?

Analysis of the sales numbers to management : 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.

What statement he or she wished to make with the act : How he or she came to be involved with the terrorist organization, What statement he or she wished to make with the act, How the act was carried out, The effects of the terrorist act

Tax issues associated with financial planning : Understanding the tax consequences of your financial planning decisions is very important. These decisions may sometimes have life-long consequences in addition to a one-time result.

Space age furniture company : Assignment for an article by the name of "Space Age Furniture Company." Need the Materials Requirement Planning (MRP) Calculations.

An economys level of output : In the long run, an economy's level of output

User Account

All Pages