Sales Analysis spread sheet
damnwaUsing 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 (as described in the 7 ways above). 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 differentiate areas of your spreadsheet
- 9 years ago
- 5
Answer(6)
Purchase the answer to view it
NOT RATED
- bis221_r1_abc_technologies_inc_q1_2012_sales_week4-2_1.xls
Purchase the answer to view it
NOT RATED
- sales_analysis.xlsx
Purchase the answer to view it
NOT RATED
- bis221_week_4_sales_analysis_spreadsheet.xlsx
Purchase the answer to view it
NOT RATED
- bis_221_week_4_sales_analysis_spreadsheet.xls
Purchase the answer to view it
NOT RATED
- abc_technologies_inc.xls
Purchase the answer to view it
NOT RATED
- bis_221_week_4_sales_analysis_spreadsheet_4.xls
Bids(0)
other Questions(10)
- law
- 100-200 Word Summary-2
- cancelled.
- A corporation is evaluating an extra dividend versus an open market share repurchase
- MGT 465 Week 1 DQ 1, DQ 2 and DQ 3
- LTC 310 Week 3 Community Newsletter Outline
- Hum111 assignment 2. professor uses TURNITIN.COM so i need plagiarism free work. 3 pages APA style.
- History Essay and discussion
- DSIM 370 JU
- Binary numbers