Final Project.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	QUANTITYORDERED	PRICEEACH	SALES	Year	Product	CUSTOMERNAME	CITY	COUNTRY	FullName	Tax	Profit
2	30	95.7	2871	2003	Motorcycles	Land of Toys Inc.	NYC	USA	Kwai Yu	57.42	2813.58
3	34	81.35	2765.9	2003	Motorcycles	Reims Collectables	Reims	France	Paul Henriot	55.318	2710.582
4	41	94.74	3884.34	2003	Motorcycles	Lyon Souveniers	Paris	France	Daniel Da Cunha	77.6868	3806.6532
5	45	83.26	3746.7	2003	Motorcycles	Toys4GrownUps.com	Pasadena	USA	Julie Young	74.934	3671.766
6	49	100	5205.27	2003	Motorcycles	Corporate Gift Ideas Co.	San Francisco	USA	Julie Brown	104.1054	5101.1646
7	36	96.66	3479.76	2003	Motorcycles	Technics Stores Inc.	Burlingame	USA	Juri Hirano	69.5952	3410.1648
8	29	86.13	2497.77	2003	Motorcycles	Daedalus Designs Imports	Lille	France	Martine Rance	49.9554	2447.8146
9	48	100	5512.32	2003	Motorcycles	Herkku Gifts	Bergen	Norway	Veysel Oeztan	110.2464	5402.0736
10	22	98.57	2168.54	2003	Motorcycles	Mini Wheels Co.	San Francisco	USA	Julie Murphy	43.3708	2125.1692
11	41	100	4708.44	2004	Motorcycles	Auto Canal Petit	Paris	France	Dominique Perrier	94.1688	4614.2712
12	37	100	3965.66	2004	Motorcycles	Australian Collectors, Co.	Melbourne	Australia	Peter Ferguson	79.3132	3886.3468
13	23	100	2333.12	2004	Motorcycles	Vitachrome Inc.	NYC	USA	Michael Frick	46.6624	2286.4576
14	28	100	3188.64	2004	Motorcycles	Tekni Collectables Inc.	Newark	USA	William Brown	63.7728	3124.8672
15	34	100	3676.76	2004	Motorcycles	Gift Depot Inc.	Bridgewater	USA	Julie King	73.5352	3603.2248
16	45	92.83	4177.35	2004	Motorcycles	La Rochelle Gifts	Nantes	France	Janine Labrune	83.547	4093.803
17	36	100	4099.68	2004	Motorcycles	Marta's Replicas Co.	Cambridge	USA	Marta Hernandez	81.9936	4017.6864
18	23	100	2597.39	2004	Motorcycles	Toys of Finland, Co.	Helsinki	Finland	Matti Karttunen	51.9478	2545.4422
19	41	100	4394.38	2004	Motorcycles	Baane Mini Imports	Stavern	Norway	Jonas Bergulfsen	87.8876	4306.4924
20	46	94.74	4358.04	2004	Motorcycles	Diecast Classics Inc.	Allentown	USA	Kyung Yu	87.1608	4270.8792
21	42	100	4396.14	2004	Motorcycles	Land of Toys Inc.	NYC	USA	Kwai Yu	87.9228	4308.2172
22	41	100	7737.93	2004	Motorcycles	Salzburg Collectables	Salzburg	Austria	Georg Pipps	154.7586	7583.1714
23	20	72.55	1451	2004	Motorcycles	Souveniers And Things Co.	Chatswood	Australia	Adrian Huxley	29.02	1421.98
24	21	34.91	733.11	2005	Motorcycles	La Rochelle Gifts	Nantes	France	Janine Labrune	14.6622	718.4478
25	42	76.36	3207.12	2005	Motorcycles	FunGiftIdeas.com	New Bedford	USA	Violeta Benitez	64.1424	3142.9776
26	24	100	2434.56	2005	Motorcycles	UK Collectables, Ltd.	Liverpool	UK	Elizabeth Devon	48.6912	2385.8688
27	66	100	7516.08	2005	Motorcycles	Euro Shopping Channel	Madrid	Spain	Diego Freyre	150.3216	7365.7584
28	26	100	5404.62	2003	Classic Cars	Baane Mini Imports	Stavern	Norway	Jonas Bergulfsen	108.0924	5296.5276
29	29	100	7209.11	2003	Classic Cars	Volvo Model Replicas, Co	Lule	Sweden	Christina Berglund	144.1822	7064.9278
30	38	100	7329.06	2003	Classic Cars	Corrida Auto Replicas, Ltd	Madrid	Spain	Mart¡n Sommer	146.5812	7182.4788
31	37	100	7374.1	2003	Classic Cars	Technics Stores Inc.	Burlingame	USA	Juri Hirano	147.482	7226.618
32	45	100	10993.5	2003	Classic Cars	Dragon Souveniers, Ltd.	Singapore	Singapore	Eric Natividad	219.87	10773.63
33	21	100	4860.24	2003	Classic Cars	Classic Legends Inc.	NYC	USA	Maria Hernandez	97.2048	4763.0352
34	34	100	8014.82	2003	Classic Cars	Australian Gift Network, Co	South Brisbane	Australia	Tony Calaghan	160.2964	7854.5236
35	23	100	5372.57	2003	Classic Cars	Classic Gift Ideas, Inc	Philadelphia	USA	Francisca Cervantes	107.4514	5265.1186
36	42	100	7290.36	2003	Classic Cars	Saveley & Henriot, Co.	Lyon	France	Mary Saveley	145.8072	7144.5528
37	47	100	9064.89	2003	Classic Cars	Canadian Gift Exchange Network	Vancouver	Canada	Yoshi Tannamuri	181.2978	8883.5922
38	35	100	6075.3	2004	Classic Cars	West Coast Collectables Co.	Burbank	USA	Steve Thompson	121.506	5953.794
39	29	100	6463.23	2004	Classic Cars	Cambridge Collectables Co.	Cambridge	USA	Kyung Tseng	129.2646	6333.9654
40	34	100	6120.34	2004	Classic Cars	Super Scale Inc.	New Haven	USA	Leslie Murphy	122.4068	5997.9332
41	32	100	7680.64	2004	Classic Cars	Tokyo Collectables, Ltd	Minato-ku	Japan	Akiko Shimamura	153.6128	7527.0272
42	21	100	4905.39	2004	Classic Cars	Souveniers And Things Co.	Chatswood	Australia	Adrian Huxley	98.1078	4807.2822
43	34	100	8014.82	2004	Classic Cars	Amica Models & Co.	Torino	Italy	Paolo Accorti	160.2964	7854.5236
44	37	100	7136.19	2004	Classic Cars	Scandinavian Gift Ideas	Boras	Sweden	Maria Larsson	142.7238	6993.4662
45	47	100	10172.7	2004	Classic Cars	Auto Assoc. & Cie.	Versailles	France	Daniel Tonini	203.454	9969.246
46	48	100	11623.7	2004	Classic Cars	Mini Gifts Distributors Ltd.	San Rafael	USA	Valarie Nelson	232.474	11391.226
47	40	100	6000.4	2004	Classic Cars	Online Diecast Creations Co.	Nashua	USA	Valarie Young	120.008	5880.392
48	26	100	3003	2004	Classic Cars	Mini Wheels Co.	San Francisco	USA	Julie Murphy	60.06	2942.94
49	30	100	3944.7	2004	Classic Cars	Australian Collectors, Co.	Melbourne	Australia	Peter Ferguson	78.894	3865.806
50	32	100	5691.84	2004	Classic Cars	Mini Gifts Distributors Ltd.	San Rafael	USA	Valarie Nelson	113.8368	5578.0032
51	41	100	4514.92	2005	Classic Cars	Collectables For Less Inc.	Brickhaven	USA	Allen Nelson	90.2984	4424.6216
52	36	100	8254.8	2005	Classic Cars	Corporate Gift Ideas Co.	San Francisco	USA	Julie Brown	165.096	8089.704
53	24	100	2416.56	2005	Classic Cars	Anna's Decorations, Ltd	North Sydney	Australia	Anna O'Hara	48.3312	2368.2288
54	23	100	4140.23	2005	Classic Cars	Quebec Home Shopping Network	Montreal	Canada	Jean Fresnisre	82.8046	4057.4254
55	50	100	12001	2005	Classic Cars	Euro Shopping Channel	Madrid	Spain	Diego Freyre	240.02	11760.98
56	39	99.91	3896.49	2003	Motorcycles	Land of Toys Inc.	NYC	USA	Kwai Yu	77.9298	3818.5602
57	29	96.34	2793.86	2003	Motorcycles	Australian Collectors, Co.	Melbourne	Australia	Peter Ferguson	55.8772	2737.9828
58	27	100	3307.77	2003	Motorcycles	Lyon Souveniers	Paris	France	Daniel Da Cunha	66.1554	3241.6146
59	37	100	5192.95	2003	Motorcycles	Toys4GrownUps.com	Pasadena	USA	Julie Young	103.859	5089.091
60	37	100	5016.83	2003	Motorcycles	Corporate Gift Ideas Co.	San Francisco	USA	Julie Brown	100.3366	4916.4934
61	27	100	3660.93	2003	Motorcycles	Technics Stores Inc.	Burlingame	USA	Juri Hirano	73.2186	3587.7114
62	42	100	4695.6	2003	Motorcycles	Daedalus Designs Imports	Lille	France	Martine Rance	93.912	4601.688
63	38	96.34	3660.92	2003	Motorcycles	Herkku Gifts	Bergen	Norway	Veysel Oeztan	73.2184	3587.7016
64	24	100	3025.92	2003	Motorcycles	Mini Wheels Co.	San Francisco	USA	Julie Murphy	60.5184	2965.4016
65	23	100	3009.09	2004	Motorcycles	Osaka Souveniers Co.	Osaka	Japan	Mory Kentary	60.1818	2948.9082
66	47	100	5422.39	2004	Motorcycles	Australian Collectors, Co.	Melbourne	Australia	Peter Ferguson	108.4478	5313.9422
67	22	100	2852.08	2004	Motorcycles	Motor Mint Distributors Inc.	Philadelphia	USA	Rosa Hernandez	57.0416	2795.0384
68	44	100	5756.52	2004	Motorcycles	Tekni Collectables Inc.	Newark	USA	William Brown	115.1304	5641.3896
69	40	100	4472	2004	Motorcycles	Gift Depot Inc.	Bridgewater	USA	Julie King	89.44	4382.56
70	22	100	2904.44	2004	Motorcycles	La Rochelle Gifts	Nantes	France	Janine Labrune	58.0888	2846.3512
71	47	100	6484.59	2004	Motorcycles	Marta's Replicas Co.	Cambridge	USA	Marta Hernandez	129.6918	6354.8982
72	39	96.34	3757.26	2004	Motorcycles	Atelier graphique	Nantes	France	Carine Schmitt	75.1452	3682.1148
73	34	100	4043.96	2004	Motorcycles	Mini Classics	White Plains	USA	Steve Frick	80.8792	3963.0808
74	45	100	5566.5	2004	Motorcycles	Diecast Classics Inc.	Allentown	USA	Kyung Yu	111.33	5455.17
75	20	100	3176	2004	Motorcycles	Land of Toys Inc.	NYC	USA	Kwai Yu	63.52	3112.48
76	40	68.92	2756.8	2004	Motorcycles	Tokyo Collectables, Ltd	Minato-ku	Japan	Akiko Shimamura	55.136	2701.664
77	26	51.15	1329.9	2004	Motorcycles	Souveniers And Things Co.	Chatswood	Australia	Adrian Huxley	26.598	1303.302
78	39	100	5288.01	2005	Motorcycles	Australian Gift Network, Co	South Brisbane	Australia	Tony Calaghan	105.7602	5182.2498
79	50	44.51	2225.5	2005	Motorcycles	FunGiftIdeas.com	New Bedford	USA	Violeta Benitez	44.51	2180.99
80	45	100	5833.8	2005	Motorcycles	Auto Canal Petit	Paris	France	Dominique Perrier	116.676	5717.124
81	45	100	5887.35	2005	Motorcycles	Euro Shopping Channel	Madrid	Spain	Diego Freyre	117.747	5769.603
82	27	100	6065.55	2003	Motorcycles	Land of Toys Inc.	NYC	USA	Kwai Yu	121.311	5944.239
83	46	100	9264.86	2003	Motorcycles	Australian Collectors, Co.	Melbourne	Australia	Peter Ferguson	185.2972	9079.5628
84	31	100	7023.98	2003	Motorcycles	Lyon Souveniers	Paris	France	Daniel Da Cunha	140.4796	6883.5004
85	33	100	5176.38	2003	Motorcycles	Toys4GrownUps.com	Pasadena	USA	Julie Young	103.5276	5072.8524
86	22	100	4132.7	2003	Motorcycles	Corporate Gift Ideas Co.	San Francisco	USA	Julie Brown	82.654	4050.046
87	20	100	4183	2003	Motorcycles	Technics Stores Inc.	Burlingame	USA	Juri Hirano	83.66	4099.34
88	41	100	8892.9	2003	Motorcycles	Daedalus Designs Imports	Lille	France	Martine Rance	177.858	8715.042
89	45	100	8714.7	2003	Motorcycles	Herkku Gifts	Bergen	Norway	Veysel Oeztan	174.294	8540.406
90	49	100	8065.89	2003	Motorcycles	Mini Wheels Co.	San Francisco	USA	Julie Murphy	161.3178	7904.5722
91	34	100	6123.4	2004	Motorcycles	Osaka Souveniers Co.	Osaka	Japan	Mory Kentary	122.468	6000.932
92	49	100	9774.03	2004	Motorcycles	Australian Collectors, Co.	Melbourne	Australia	Peter Ferguson	195.4806	9578.5494
93	39	100	7023.9	2004	Motorcycles	Vitachrome Inc.	NYC	USA	Michael Frick	140.478	6883.422
94	43	100	7078.23	2004	Motorcycles	Tekni Collectables Inc.	Newark	USA	William Brown	141.5646	6936.6654
95	41	100	8336.94	2004	Motorcycles	Gift Depot Inc.	Bridgewater	USA	Julie King	166.7388	8170.2012
96	36	100	6901.92	2004	Motorcycles	La Rochelle Gifts	Nantes	France	Janine Labrune	138.0384	6763.8816
97	27	100	5438.07	2004	Motorcycles	Marta's Replicas Co.	Cambridge	USA	Marta Hernandez	108.7614	5329.3086
98	29	100	6683.34	2004	Motorcycles	Toys of Finland, Co.	Helsinki	Finland	Matti Karttunen	133.6668	6549.6732
99	20	100	4570.4	2004	Motorcycles	Mini Classics	White Plains	USA	Steve Frick	91.408	4478.992
100	37	100	7667.14	2004	Motorcycles	Diecast Classics Inc.	Allentown	USA	Kyung Yu	153.3428	7513.7972