please help
rose.angel13Using 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
- 9 years ago
- 20
Answer(5)
Purchase the answer to view it
NOT RATED
- bis221_r1_abc_technologies_inc_q1_2012_sales_week4-2.xls
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
Purchase the answer to view it
NOT RATED
- sales_analysis_spreadsheet_1.xlsx
Bids(0)
other Questions(10)
- Rhetoric in Contemporary Culture - Using Rogerian Approach
- types and style of presenting
- BSHS/325 BSHS 325 Week 3 Physical Development in Middle Adulthood
- BSHS/325 BSHS 325 Week 2 Adolescent Self-Portrait
- Product X is a consumer product with a retail price of $9.95. Retailer’s margins on the product are 40% (based on the selling price to consumers) and wholesaler’s margins are 8% (based on the selling price to retailers).
- Bermudez Leasing Company purchased specialized equipment from Holmes Company on December 31, 2009 for $400,000.
- Health Information Technology
- For Trevian
- hw
- MAT/222 MAT 222 MAT222 Week 2 - Individual Discussion Question Board - A+ & Original Guaranteed!