Adding Data Entry to Management

Only available on StudyMode
  • Download(s) : 124
  • Published : February 27, 2013
Open Document
Text Preview
Adding Value to Data for Management Decision Making
Team Assignment – Paige Phillips, Mark Webb
Bus 140-006 R. McLeish

1. Which are the best performing sales regions by Total Sales? Query1|
Sales Region| Total Sales|
East| $529,124.80|
South| $234,595.05|
North| $233,832.75|

2. Which are the best performing stores by Total Sales?
Query2|
Store No| Total Sales|
6| $267,648.90|
7| $170,040.85|
5| $158,334.00|
8| $91,435.05|
1| $90,281.10|
3| $90,051.25|
4| $75,498.75|
2| $54,262.70|

3. What are the best-selling products by Total Sales?

Query1|
Item Description| Total Sales|
Desktop CPU| $833,800.95|
17" Monitor| $139,461.00|
101 Keyboard| $18,294.15|
PC Mouse| $5,996.50|

4. Which are the best performing sales regions by Units Sold?

Query1|
Sales Region| SumOfUnits Sold|
East| 1532|
North| 882|
South| 763|

5. Which are the best performing stores by Units Sold?

Query1|
Store No| SumOfUnits Sold|
6| 727|
5| 615|
7| 548|
1| 325|
3| 306|
4| 267|
8| 257|
2| 132|

6. What are the best-selling products by Units Sold?

Query1|
Item Description| SumOfUnits Sold|
Desktop CPU| 981|
101 Keyboard| 917|
PC Mouse| 670|
17" Monitor| 609|

7. Which are the best performing sales regions by Weekly Sales? (Sort by weeks, then by total sales)

Query1|
Sales Region| Week Ending| Total Sales|
East| 12/29/2006| $186,218.55|
East| 11/24/2006| $181,965.35|
East| 10/27/2006| $160,940.90|
North| 11/24/2006| $81,578.90|
South| 10/27/2006| $79,203.95|
South| 11/24/2006| $78,416.80|
North| 10/27/2006| $77,577.90|
South| 12/29/2006| $76,974.30|
North| 12/29/2006| $74,675.95|

8. What are the best-selling products by Weekly Sales? (Sort by weeks, then by total sales)

Query1|
Item Description| Week Ending| Total Sales|
Desktop...
tracking img