pc project 1.xlsx

	A	B	C	D	E	F	G	H	I
1
2
3	Sum of SALES	STATUS
4	PRODUCTLINE		Cancelled	Disputed	In Process	On Hold	Resolved	Shipped	Grand Total
5		19305663.19							19305663.19
6	Classic Cars		59242.81	26012.87	57760.66	49039.65	25799.34	3701760.33	3919615.66
7	Motorcycles			31821.9		4992.61		1129573.83	1166388.34
8	Planes		35432.71	3843.84		34727.53	34532.92	866466.57	975003.57
9	Ships		56665.65	3070.4		23664.61	39863.71	591172.76	714437.13
10	Trains		5082.42			5808.48		215352.57	226243.47
11	Trucks and Buses				43026.41	20193.29	20472.75	1044097.39	1127789.84
12	Vintage Cars		38063.89	7463.85	43942.89	40553.02	30049.56	1743077.63	1903150.84
13	Grand Total	19305663.19	194487.48	72212.86	144729.96	178979.19	150718.28	9291501.08	29338292.04
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100