Monthly sales by region and by sales people

Assignment Help Management Information Sys

Reference no: EM13761429

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.

Attachment:- data.xlsx

Reference no: EM13761429

Questions Cloud

Write the equation first by inserting the given binomials : Write the equation first by inserting the given binomials into the Pythagorean Theorem. Once you have your equation written, go ahead and solve it using the methods from section 5.6 of Elementary and Intermediate Algebra.

How are investments analyzed for performance : Your task for this module's project piece is to conduct research to determine what investors want to know about their investments on a daily basis and over time. How are investments analyzed for performance

Price elasticity of demand for stock : Price elasticity of demand for stock is 1.5. This means that foe every 10% increase in stock prices, the quantity demanded will decline by 15 %. Does this make sense? Explain.

Issues information technology : Locate a news article based on a recent event on ethical issues related to information technology. For example, Wikileaks, Snowden, etc...

Monthly sales by region and by sales people : 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

Write a paper about the economic principles : You will have to choose a recent article from a newspaper of magazine. This article must be from the last three months and relate to economics in some way.

The organization of economic activity : Economics Systems. Discuss how your college education could be considered an investment in human capital. What is the opportunity cost of your degree

Corporate formation and liquidation : You have been hired by a U.S. corporation that wants to form a foreign corporation through the transfer of property. Propose a strategy for the client to transfer property into the foreign corporation that will help the client to avoid or mitigate..

Write paper on a theme motif and symbol from catcher in rye : Write a Literary Analysis paper on a Theme, Motif, and Symbol from The Catcher in the Rye.

User Account

All Pages