Keywords

bis 221
uop bis 221 week 2
bis 221 help
uop bis 221 tutorials
uop bis 221 week 5
uop bis 221 week 4
uop bis 221 week 3
uop bis 221 week 1
uop bis 221 entire course
uop bis 221 complete course
uop bis 221
bis 221 assignments


Authorizations, license

Visible by: Everyone
All rights reserved

4 visits

UOP BIS 221 Week 4 Sales Analysis Spreadsheet


UOP BIS 221 Week 4 Sales Analysis Spreadsheet This doc cannot be viewed.

UOP BIS 221 Week 4 Sales Analysis Spreadsheet

Check this A+ tutorial guideline at
www.assignmentclick.com/bis-221/bis-221-week-4-sales-analysis-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

Click the Assignment Files tab to submit your assignment.



For more classes visit

www.assignmentclick.com

Comments