Class Example

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 8

RowNumber VendorName FName LName PhoneNumber Address State

1 Oster DeShawn Williams (907)961-4917 1535 N Hickory St Owosso


2 Black and Decker Milton Armstrong (844) 986-0858 1000 Stanley Dr Concord
3 KitchenAid Chiyo Tanaka 3605659487 1701 Kitchen Aid Way Greenville
4 Black and Decker M. Anderson (844) 986-0858 1000 Stanley Dr Concord
5 Black and Decker Milton Armstrong (844) 986-0858 1000 Stanley Dr Concord
6 Panasonic Maryam Ahmad (551) 7779393 7625 Panasonic Way SanDiego
7 B&D Milton G. Armstrong (844) 986-0858 1000 Stanley Dr Concord
8 Panasonic Maryam Ahmad (551) 7779393 7625 Panasonic Way SanDiego
9 KitchenAid Chiyo Tanaka 3605659487 1701 Kitchen Aid Way Greenville
10 Oster DeShawn Williams (907)961-4917 1535 N Hickory St Owosso
11 Oster DeShawn Williams (907)961-4917 1535 N Hickory St Owosso
12 Honeywell Latesha Henson (790)447-1783 20750 Midust Dr Louisville
13 Calphalon Jacobsen Sofia (933) 937-5654 (208) 20750 Midust Dr Bowling Green
14 B&D Milton Armstrong (844) 986-0858 1000 Stanley Dr Concord
15 Honeywell Latesha Henson (790)447-1783 20750 Midust Dr Louisville
16 Black and Decker Milton Armstrong (801) 473-5329 1000 Stanley Dr Concord
17 Panasonic Maryam Ahmad (551) 7779393 7625 Panasonic Way SanDiego
City ZipCode EarlyPayDiscount ProdCat ProdID UnitsPurch TotalCosts AvgCostPerUnit
MI 48867 2/10 N30 1 3 186 2068.32 € 0.0899
NC 94519 2/10 N30 1 3 227 $ 2,270.06 € 0.1022
OH 45331 1 2 210 $ 40,849.20 € 0.0051
NC 94519 2/10 N30 3 1 273 $ 10,851.75 € 0.0052
NC 94519 2/10 N30 2.00 2 80 568 € 0.1408
CA 92154 2/10 N15 1 2 51 7893.5 € 0.0065
NC 94519 2/10 N30 2.00 1 281 2591.5 € 0.1111
CA 92154 2/10 N15 2.00 2 386 5693.5 € 0.0678
OH 45331 1 3 171 2433.33 € 0.0703
MI 48867 2/10 N30 1 1 263 5067.75 € 0.0519
MI 48867 2/10 N30 1 2 248 $ 20,889.04 € 0.0119
KY 40258-1893 1/10 N30 2.00 2 54 $ 621.00 € 0.0870
OH 43042-9215 1 1 261 $ 19,509.75 € 0.0134
NC 94519 2/10 N30 1 2 262 $ 15,895.00 € 0.0707
KY 40258-1893 1/10 N30 2.00 1 346 $ 4,839.90 € 0.0761
NC 94519 2/10 N30 3 2 122 $ 2,172.82 € 0.0561
CA 92154 2/10 N15 1 2 51 $ 7,882.56 € 0.0065
3-Apr-82
03/Apr/1982
04/03/82
03/04/82
04/03/1982
03/04/1982
Apr 03, 1982
April 03, 1982
4/3/1982
03/04/1982
82/04/03
1982/04/03
Sat, Apr 03
Saturday, April 03, 1982
82/04/03
1982/04/03
30044
30,044
30,044
3004400%
3.00E+04
Data Data
VendorName Sum of UnitsPurch Sum of TotalCosts Sum oSum of TotalCosts
B&D 543 $ 18,486.50 3472 $ 152,096.98
Black and Decker 702 $ 15,862.63
Calphalon 261 $ 19,509.75
Honeywell 400 $ 5,460.90
KitchenAid 381 $ 43,282.53
Oster 697 $ 28,025.11
Panasonic 488 $ 21,469.56
Sum of TotalCosts ProdCat
VendorName 1.00 2.00 3.00
B&D $ 15,895.00 $ 2,591.50
Black and Decker $ 2,270.06 $ 568.00 $ 13,024.57
Calphalon $ 19,509.75
Honeywell $ 5,460.90
KitchenAid $ 43,282.53
Oster $ 28,025.11
Panasonic $ 15,776.06 $ 5,693.50
VendorName ProdCat Sum of TotalCosts
B&D 1.00 $ 15,895.00
2.00 $ 2,591.50
Black and Decker 1.00 $ 2,270.06
2.00 $ 568.00
3.00 $ 13,024.57
Calphalon 1.00 $ 19,509.75
Honeywell 2.00 $ 5,460.90
KitchenAid 1.00 $ 43,282.53
Oster 1.00 $ 28,025.11
Panasonic 1.00 $ 15,776.06
2.00 $ 5,693.50
RowNumber EarlyPayDiscount DiscountRate DiscountDays BalanceDueDays
1 2/10 N30 2 10 30
2 2/10 N30 2 10 30
3
4 2/10 N30 2 10 30
5 2/10 N30 2 10 30
6 2/10 N15 2 10 15
7 2/10 N30 2 10 30
8 2/10 N15 2 10 15
9
10 2/10 N30 2 10 30
11 2/10 N30 2 10 30
12 1/10 N30 1 10 30
13
14 2/10 N30 2 10 30
15 1/10 N30 1 10 30
16 2/10 N30 2 10 30
17 2/10 N15 2 10 15
RowNumber VendorName FName LName Full Name ProdCat ProdID ProdCatID
1 Oster DeShawn Williams DeShawn Williams 1 3 1-3
2 Black and Decker Milton Armstrong Milton Armstrong 1 3 1-3
3 KitchenAid Chiyo Tanaka Chiyo Tanaka 1 2 1-2
4 Black and Decker M. Anderson M. Anderson 3 1 3-1
5 Black and Decker Milton Armstrong Milton Armstrong 2.00 2 2-2
6 Panasonic Maryam Ahmad Maryam Ahmad 1 2 1-2
7 B&D Milton G. Armstrong Milton G. Armstron 2.00 1 2-1
8 Panasonic Maryam Ahmad Maryam Ahmad 2.00 2 2-2
9 KitchenAid Chiyo Tanaka Chiyo Tanaka 1 3 1-3
10 Oster DeShawn Williams DeShawn Williams 1 1 1-1
11 Oster DeShawn Williams DeShawn Williams 1 2 1-2
12 Honeywell Latesha Henson Latesha Henson 2.00 2 2-2
13 Calphalon Jacobsen Sofia Jacobsen Sofia 1 1 1-1
14 B&D Milton Armstrong Milton Armstrong 1 2 1-2
15 Honeywell Latesha Henson Latesha Henson 2.00 1 2-1
16 Black and Decker Milton Armstrong Milton Armstrong 3 2 3-2
17 Panasonic Maryam Ahmad Maryam Ahmad 1 2 1-2

You might also like