Monthly sales by product, Using the ABC Technologies Inc.,

Monthly sales by product

Reference no: EM13758222

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:- q1_2012_sales_week.xls

Reference no: EM13758222

Questions Cloud

Essay about that two companies mio and powerade zero drops : Write an essay about that two companies Mio and Powerade Zero Drops Advertisement/Billboard jam - this jam will take an advertisement (often in magazines) orbillboard and jam it with Photoshop or similar programs.

What are the various threats to information security : What are the various threats to information security in your view? Are you doing your share to protect your information? Why and why not? What can you do to improve your information security practices?

Effects of management information systems : Write a two-page paper (minimum length) describing the following effects of management information systems on organizational functions: Executive-level decision making

Draft us a proposal regarding the dissertation : Can you please let us know if it is possible by you to draft us a proposal regarding the dissertation in order to send it for approval and to continue for the rest (proposal, Dissertation) - Risk management in new technology deployment projects

Monthly sales by product : 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

Discuss character of oedipus in oedipus rex as a tragic : Discuss the character of Oedipus in Oedipus Rex as a tragic hero in an argumentative paper following all guidelines below. Length should be 3 or more pages (including the works cited page).

Problem related to sovereign immunity : On December 21, 1988, Pan Am Flight 103 exploded 31,000 feet in the air over Lockerbie, Scotland, killing all 259 passengers and crew on board and 11 people on the ground.

Compute the tracking signal : Sales of tablet computers at Ted Glickman's electronic store in Washinton D.C over the past 10 weeks are shown in the table below". Forecast demand for each week including week 10, using exponential smoothing with a=.5 (initial forecast=20) Compute t..

Actions relate to functional-dysfunctional conflict scenario : When Allan Mulally, a former Boeing executive, was appointed CEO of Ford Motor Company, many wondered if an “airplane guy” could run a car company. Fortune magazine named him Executive of the Year in 2010. Use the Internet to research Mulally’s actio..

User Account

All Pages