CREATE A SPREADSHEET
DLife85Using 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
- 5
Answer(3)
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_4.xls
Purchase the answer to view it
NOT RATED
- sales_analysis_spreadsheet.xlsx
Bids(1)
other Questions(10)
- History- Lynn Hunt, The Making of the West MCQs
- Accounting- Holly Manufacturing Company
- In a 20 slide PowerPoint presentation (excluding title and reference slides) provide information as well as analyze the roles of the following areas in criminal justice leadership strategies and practices: Organizational culture Behavioral theor
- ACC 206 Week 1 DQ
- Defense Electronics
- http://nationalparalegal.edu/Students/EditAssignment.aspx?item=question&intAssignmentID=1236
- non-controlling interest
- Research paper on related international logistics and supply chain management.
- Due 1/21/14 , Must be in simple mid-level terms formed in your own words with proper APA format!!!
- DQ2-A diversity within psychology