Using the abc technologies inc q1 2012 sales spreadsheet


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

Request for Solution File

Ask an Expert for Answer!!
Finance Basics: Using the abc technologies inc q1 2012 sales spreadsheet
Reference No:- TGS01011378

Expected delivery within 24 Hours