Sales Analysis Spreadsheet
gjkrdUsing 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
- 15
Answer(4)
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(2)
other Questions(10)
- how did hubert humphery oppose the vietnam war?
- Find, In parametric form the line of intersection between: x+2y-z=1 2x-y-z=2
- Chad went to the store to buy a large drink and pack of gum.The drink cost three times as much...
- business Law Case Number : 2
- 3.86*4.0 with the work please
- Analyzing the ability to pay liabilities
- -5(3-2x)-(1-x)=4(x-3)
- Can all Catholics receive the Eucharist at any time?
- what are the answers to thank you m'am page 24 in the language of literature book
- The E________ S________ is an organ system that works with the circulatory system to remove waste from the blood which...