week 1

profileneedhelp1
it261r2_normalization_data_1.xls
Home>Business & Finance homework help>Economics homework help>week 1

Invoice

Date Customer No Customer Name Employee ID Sales person Part No Description Quanitity Price
6/1/07 5 Customer 5 6 Employee 6 8 Part 8 28 441.08
6/10/07 3 Customer 3 6 Employee 6 23 Part 23 69 433.42
6/17/07 2 Customer 2 9 Employee 9 14 Part 14 22 347.63
6/25/07 1 Customer 1 5 Employee 5 26 Part 26 74 107.99
7/2/07 9 Customer 9 2 Employee 2 3 Part 3 77 504.07
7/12/07 6 Customer 6 3 Employee 3 12 Part 12 35 56.92
7/17/07 6 Customer 6 2 Employee 2 14 Part 14 3 347.63
7/23/07 3 Customer 3 1 Employee 1 11 Part 11 46 0.63
7/30/07 5 Customer 5 2 Employee 2 7 Part 7 60 273.47
8/3/07 7 Customer 7 6 Employee 6 9 Part 9 30 67.25
8/12/07 2 Customer 2 4 Employee 4 16 Part 16 27 8.95
8/14/07 8 Customer 8 4 Employee 4 4 Part 4 47 451.43
8/23/07 7 Customer 7 8 Employee 8 7 Part 7 35 273.47
9/1/07 2 Customer 2 9 Employee 9 13 Part 13 29 3.83
9/8/07 8 Customer 8 8 Employee 8 15 Part 15 77 535.85
9/18/07 1 Customer 1 2 Employee 2 25 Part 25 43 107.99
9/27/07 7 Customer 7 8 Employee 8 24 Part 24 8 93.96
10/4/07 2 Customer 2 8 Employee 8 8 Part 8 56 441.08
10/5/07 3 Customer 3 8 Employee 8 6 Part 6 45 302.8
10/13/07 8 Customer 8 8 Employee 8 21 Part 21 21 289.34
10/14/07 5 Customer 5 7 Employee 7 17 Part 17 34 66.25
10/15/07 2 Customer 2 7 Employee 7 18 Part 18 59 36.3
10/23/07 8 Customer 8 4 Employee 4 13 Part 13 51 3.83
10/23/07 7 Customer 7 10 Employee 10 10 Part 10 15 319.54
10/30/07 6 Customer 6 2 Employee 2 10 Part 10 59 319.54
11/2/07 6 Customer 6 4 Employee 4 18 Part 18 15 36.3
11/7/07 7 Customer 7 5 Employee 5 19 Part 19 13 505.9
11/10/07 6 Customer 6 7 Employee 7 2 Part 2 21 196.91
11/18/07 6 Customer 6 5 Employee 5 25 Part 25 15 107.99
11/26/07 7 Customer 7 2 Employee 2 5 Part 5 80 450.74
12/3/07 2 Customer 2 1 Employee 1 12 Part 12 14 56.92
12/6/07 2 Customer 2 8 Employee 8 1 Part 1 14 310.49
12/7/07 6 Customer 6 3 Employee 3 23 Part 23 2 433.42
12/11/07 9 Customer 9 3 Employee 3 16 Part 16 42 8.95
12/13/07 8 Customer 8 5 Employee 5 22 Part 22 57 289.58
12/14/07 2 Customer 2 5 Employee 5 7 Part 7 78 273.47
12/19/07 8 Customer 8 10 Employee 10 5 Part 5 24 450.74
12/22/07 7 Customer 7 10 Employee 10 20 Part 20 75 100.39
12/28/07 9 Customer 9 2 Employee 2 17 Part 17 15 66.25
12/31/07 5 Customer 5 8 Employee 8 22 Part 22 28 289.58
1/7/08 2 Customer 2 9 Employee 9 25 Part 25 6 107.99
1/10/08 3 Customer 3 5 Employee 5 10 Part 10 13 319.54
1/11/08 7 Customer 7 8 Employee 8 25 Part 25 75 107.99
1/16/08 2 Customer 2 1 Employee 1 7 Part 7 20 273.47
1/25/08 2 Customer 2 5 Employee 5 2 Part 2 1 196.91
1/26/08 8 Customer 8 7 Employee 7 17 Part 17 67 66.25
1/27/08 5 Customer 5 1 Employee 1 6 Part 6 8 302.8
1/30/08 9 Customer 9 3 Employee 3 24 Part 24 47 93.96
2/5/08 5 Customer 5 7 Employee 7 12 Part 12 74 56.92
2/8/08 2 Customer 2 8 Employee 8 21 Part 21 8 289.34
2/15/08 7 Customer 7 7 Employee 7 23 Part 23 25 433.42
2/17/08 9 Customer 9 9 Employee 9 3 Part 3 3 504.07
2/25/08 2 Customer 2 2 Employee 2 25 Part 25 54 107.99
3/1/08 2 Customer 2 2 Employee 2 13 Part 13 25 3.83
3/2/08 3 Customer 3 8 Employee 8 22 Part 22 51 289.58
3/10/08 7 Customer 7 10 Employee 10 18 Part 18 4 36.3
3/12/08 6 Customer 6 8 Employee 8 17 Part 17 65 66.25
3/20/08 2 Customer 2 7 Employee 7 21 Part 21 36 289.34
3/29/08 1 Customer 1 3 Employee 3 14 Part 14 43 347.63
4/1/08 7 Customer 7 1 Employee 1 7 Part 7 28 273.47
4/8/08 4 Customer 4 8 Employee 8 12 Part 12 30 56.92
4/13/08 10 Customer 10 6 Employee 6 23 Part 23 23 433.42
4/21/08 9 Customer 9 3 Employee 3 20 Part 20 63 100.39
4/30/08 6 Customer 6 3 Employee 3 8 Part 8 7 441.08
5/4/08 1 Customer 1 5 Employee 5 15 Part 15 13 535.85
5/12/08 10 Customer 10 5 Employee 5 21 Part 21 80 289.34
5/19/08 5 Customer 5 3 Employee 3 19 Part 19 8 505.9
5/24/08 4 Customer 4 8 Employee 8 5 Part 5 18 450.74
5/28/08 9 Customer 9 5 Employee 5 18 Part 18 77 36.3
6/4/08 9 Customer 9 2 Employee 2 19 Part 19 32 505.9
6/8/08 6 Customer 6 3 Employee 3 10 Part 10 63 319.54
6/15/08 9 Customer 9 10 Employee 10 15 Part 15 26 535.85
6/20/08 3 Customer 3 6 Employee 6 15 Part 15 65 535.85
6/24/08 6 Customer 6 8 Employee 8 8 Part 8 50 441.08
7/2/08 2 Customer 2 8 Employee 8 15 Part 15 41 535.85
7/7/08 9 Customer 9 8 Employee 8 22 Part 22 16 289.58
7/9/08 3 Customer 3 3 Employee 3 2 Part 2 52 196.91
7/9/08 8 Customer 8 5 Employee 5 13 Part 13 51 3.83
7/13/08 6 Customer 6 6 Employee 6 23 Part 23 43 433.42
7/21/08 3 Customer 3 2 Employee 2 4 Part 4 7 451.43
7/25/08 4 Customer 4 8 Employee 8 4 Part 4 24 451.43
7/28/08 4 Customer 4 9 Employee 9 9 Part 9 77 67.25
8/4/08 2 Customer 2 8 Employee 8 2 Part 2 42 196.91
8/13/08 3 Customer 3 2 Employee 2 7 Part 7 41 273.47
8/18/08 4 Customer 4 2 Employee 2 2 Part 2 52 196.91
8/18/08 2 Customer 2 8 Employee 8 8 Part 8 72 441.08
8/26/08 8 Customer 8 8 Employee 8 16 Part 16 26 8.95
8/31/08 5 Customer 5 6 Employee 6 15 Part 15 66 535.85
9/4/08 3 Customer 3 2 Employee 2 10 Part 10 76 319.54
9/10/08 7 Customer 7 9 Employee 9 7 Part 7 65 273.47
9/14/08 4 Customer 4 2 Employee 2 26 Part 26 58 107.99
9/23/08 6 Customer 6 7 Employee 7 9 Part 9 22 67.25
10/2/08 9 Customer 9 3 Employee 3 5 Part 5 14 450.74
10/2/08 10 Customer 10 2 Employee 2 8 Part 8 69 441.08
10/2/08 6 Customer 6 2 Employee 2 26 Part 26 54 107.99
10/10/08 1 Customer 1 3 Employee 3 24 Part 24 8 93.96
10/18/08 7 Customer 7 8 Employee 8 20 Part 20 73 100.39
10/28/08 9 Customer 9 8 Employee 8 1 Part 1 41 310.49
11/3/08 7 Customer 7 2 Employee 2 15 Part 15 11 535.85
11/8/08 8 Customer 8 7 Employee 7 21 Part 21 54 289.34
11/13/08 2 Customer 2 2 Employee 2 15 Part 15 61 535.85
11/18/08 3 Customer 3 1 Employee 1 10 Part 10 71 319.54
11/24/08 8 Customer 8 4 Employee 4 12 Part 12 60 56.92
11/27/08 6 Customer 6 8 Employee 8 26 Part 26 2 107.99
12/1/08 10 Customer 10 3 Employee 3 22 Part 22 16 289.58
12/7/08 9 Customer 9 9 Employee 9 10 Part 10 32 319.54
12/9/08 6 Customer 6 8 Employee 8 4 Part 4 64 451.43
12/11/08 7 Customer 7 4 Employee 4 18 Part 18 53 36.3
12/15/08 9 Customer 9 7 Employee 7 13 Part 13 7 3.83
12/25/08 3 Customer 3 3 Employee 3 21 Part 21 45 289.34
1/1/09 3 Customer 3 8 Employee 8 13 Part 13 2 3.83
1/9/09 6 Customer 6 3 Employee 3 18 Part 18 56 36.3
1/12/09 5 Customer 5 8 Employee 8 15 Part 15 42 535.85
1/13/09 9 Customer 9 9 Employee 9 1 Part 1 14 310.49
1/17/09 9 Customer 9 6 Employee 6 5 Part 5 46 450.74
1/23/09 2 Customer 2 1 Employee 1 12 Part 12 33 56.92
1/29/09 4 Customer 4 7 Employee 7 1 Part 1 61 310.49
1/29/09 8 Customer 8 2 Employee 2 18 Part 18 38 36.3
2/1/09 5 Customer 5 1 Employee 1 21 Part 21 36 289.34

Customer

Customer No Customer Name Main Address Main Address 2 Main City Main State Main Zip Contact Name Contact Phone Pricing Tier
1 Customer 1 Main Street 2227 Main Street Dallas TX 99111 Contact 1 469-3774032- 3
2 Customer 2 Ruben Avenue 575 Ruben Avenue Baton Rouge LA 72271 Contact 2 647-0038678- 2
3 Customer 3 State Street 2796 State Street Suite 92 Miami FL 91171 Contact 3 144-6252284- 2
4 Customer 4 Lewiston Drive 1559 Lewiston Drive Boston MA 48546 Contact 4 405-7058632- 2
5 Customer 5 Anderson Place 1565 Anderson Place Newport VT 16959 Contact 5 705-5234227- 2
6 Customer 6 Civic Boulevard 1736 Civic Boulevard Suite 126 Helena MT 63457 Contact 6 188-5834350- 3
7 Customer 7 Bond Street 1617 Bond Street Provo UT 72120 Contact 7 766-3617376- 3
8 Customer 8 Park Place 1872 Park Place San Francisco CA 73379 Contact 8 384-6799452- 2
9 Customer 9 Mountain Creek Drive 679 Mountain Creek Drive Suite 7 Sisters OR 60354 Contact 9 951-0467581- 3
10 Customer 10 Wall Street 612 Wall Street Suite 26 Peoria IL 62181 Contact 10 390-1547826- 2

Inventory

Part No Description Last Received Date Retail Price Last Sold Price Cost Units in Stock
1 Part 1 12/21/07 375.6 310.49 276.07 192
2 Part 2 3/8/08 224.78 196.91 136.16 238
3 Part 3 9/5/08 504.39 504.07 492.79 517
4 Part 4 7/20/08 551.65 451.43 341.55 411
5 Part 5 3/3/08 533.26 450.74 317.76 255
6 Part 6 2/25/08 309.42 302.8 241.1 948
7 Part 7 9/8/08 360.56 273.47 243.61 566
8 Part 8 7/30/08 529.65 441.08 370.66 612
9 Part 9 8/7/08 86.78 67.25 45.33 747
10 Part 10 12/13/07 368.61 319.54 253.21 383
11 Part 11 9/5/08 0.7 0.63 0.61 5
12 Part 12 3/17/08 59.75 56.92 45.6 364
13 Part 13 4/17/08 3.9 3.83 2.23 46
14 Part 14 1/19/08 389.65 347.63 200.8 365
15 Part 15 5/12/08 538.36 535.85 366.11 923
16 Part 16 12/17/07 9.42 8.95 7.6 110
17 Part 17 12/31/07 70.58 66.25 45.86 959
18 Part 18 12/5/07 43.32 36.3 33.62 993
19 Part 19 8/7/08 574.24 505.9 470.67 485
20 Part 20 5/10/08 101.28 100.39 73.7 460
21 Part 21 1/10/08 363.7 289.34 254.3 415
22 Part 22 1/28/08 364.86 289.58 250.09 510
23 Part 23 7/6/08 475.9 433.42 425.86 327
24 Part 24 11/15/07 96.89 93.96 82.11 880
25 Part 25 12/4/07 119.5 107.99 68.69 581
11/15/07

Employee

Employee ID Name Region State Hire Date
1 Employee 1 West ID 5/13/06
2 Employee 2 North IL 10/29/05
3 Employee 3 East MA 10/13/04
4 Employee 4 South TX 10/19/06
5 Employee 5 West CA 3/13/05
6 Employee 6 North MT 7/13/06
7 Employee 7 East NY 4/12/04
8 Employee 8 South LA 9/8/04
9 Employee 9 West OR 10/31/05
10 Employee 10 East NJ 2/27/06
1/1/04

Region

Region Name State Sales Totals
West ID 49740.05
West UT 71190.89
West WA 47549.73
West OR 2466.31
West CA 30790.24
West NV 31196.62
East NY 65893.77
East NJ 54097.72
East PA 37203.03
East ME 74375.28
East MA 86251.32
East VT 99242.75
North MT 62548.19
North WA 78265.35
North ND 89956.44
North MN 23661.52
North SD 80629.72
North IL 21903.6
South FL 93523.04
South AR 63523.18
South TX 67239.16
South NM 85130.21
South LA 60038.32
South GA 71416.38