Create a graph or chart that compares the data

Reference no: EM13760620

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

Questions Cloud

The internet - how is it changing the economy : Provide a "Reference" section at the end of your paper with at least 3 references including reference to a scholarly book or a scholarly journal - How is it Changing the Economy

What would be the level of income in country : What would be the level of income in country - the institutions view holds and that institutions improve.

Estimate of the cost of equity capital for amgel : What is your estimate of the cost of equity capital for Amgel (based on the CAPM)? If Amgel's marginal tax rate is 35%, what is the firm's overall weighted average cost of capital (WACC)?

Ethical to record the revenue transaction : Journalize the revenue transaction, and indicate how recording this revenue in December would affect the current ratio.

Create a graph or chart that compares the data : Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet.

Disposition of accounts receivables : 1. How would you describe the entries to record the disposition of accounts receivables? What is their function? 2. How are bad debts accounted for under the direct write-off method? What are the disadvantages of this method?

Explain the difference between a normal distribution : Explain the difference between a normal Distribution and a binomial distribution. How do we know which one to use?

The scratch wheel is divided into 12 slices : 1. During a promotion, Christina's department store offers a mailing "scratch a winner - discount savings." After customers select the items they wish to purchase, they scratch their discount sticker from the mailing to determine the discount they wi..

Who are the stakeholders in scenario : Who are the stakeholders in scenario (both internal and external) - What is the impact to the various stakeholders of acquiring a surgical robot unit?

User Account

All Pages