95 Supply Chain and Freight Analytics Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	Month	Day	Load	Tonnage	Customer Type	Destination	Rate	Truck	Insurance	Fuel	Diesel Exhaust Fluid	Advance	Warehouse	Repairs	Tolls	Fundings	Driver Name	Odometer	Miles	Rate Per Miles	Extra Stops	Extra Pay	Costs Driver Paid	Total Expenses	First condition type	Shipment cost sub-items	ERE Stage	Basic freight	Final Amount
2	Jan	1	Wood	11.0	Retaining Customer	Nunavut.	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Alessandro Smith	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
3	Jan	3	Wood	21.3	Retaining Customer	British Columbia	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Beauregard Mike	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
4	Jan	13	Wood	22.0	Retaining Customer	Manitoba	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Jean Bartholomew	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
5	Feb	4	Sand	14.5	Retaining Customer	British Columbia	$4,567	Freightliner Sprinter	$132	$333	$51	$250	$134	$65	$134	$6	Alessandro Smith	295	354	$248	$100	$23	$55	$1,531	$594	$913	$776	$1,142	$1,370
6	Feb	5	Sand	18.0	Retaining Customer	Manitoba	$4,567	Freightliner Sprinter	$132	$333	$52	$250	$134	$65	$134	$6	Beauregard Mike	295	354	$248	$100	$23	$55	$1,532	$594	$913	$776	$1,142	$1,370
7	Feb	6	Sand	19.0	Retaining Customer	New Brunswick	$4,567	Freightliner Sprinter	$132	$333	$53	$250	$134	$65	$134	$6	Jean Bartholomew	295	354	$248	$100	$23	$55	$1,533	$594	$913	$776	$1,142	$1,370
8	Feb	14	Sand	20.0	Retaining Customer	Nunavut	$4,567	Freightliner Sprinter	$132	$333	$54	$250	$134	$65	$134	$6	Jaison Augustine	295	354	$248	$100	$23	$55	$1,534	$594	$913	$776	$1,142	$1,370
9	Mar	2	Iron	21.0	Retaining Customer	Manitoba	$3,458	Freightliner Sprinter	$132	$453	$55	$250	$121	$32	$56	$56	Alessandro Smith	295	333	$233	$100	$24	$56	$1,568	$450	$692	$588	$865	$1,037
10	Mar	3	Iron	22.0	New Customer	British Columbia	$3,458	Freightliner Sprinter	$132	$453	$56	$250	$121	$32	$56	$56	Beauregard Mike	295	333	$233	$100	$24	$56	$1,569	$450	$692	$588	$865	$1,037
11	Mar	7	Sand	22.7	New Customer	Manitoba	$3,458	Freightliner Sprinter	$132	$453	$57	$250	$121	$32	$56	$56	Jaison Augustine	295	333	$233	$100	$24	$56	$1,570	$450	$692	$588	$865	$1,037
12	Mar	8	Iron	12.0	Retaining Customer	New Brunswick	$3,458	Freightliner Sprinter	$132	$453	$58	$250	$121	$32	$56	$56	Jaison Augustine	295	333	$233	$100	$24	$56	$1,571	$450	$692	$588	$865	$1,037
13	Mar	9	Wood	13.0	New Customer	Alberta	$3,458	Freightliner Sprinter	$132	$453	$59	$250	$121		$56	$56	Alessandro Smith	295	333	$233	$100	$24	$56	$1,540	$450	$692	$588	$865	$1,037
14	Apr	12	Wood	16.0	Retaining Customer	Yukon	$6,433	Chevrolet Express	$132	$399	$72	$250	$134		$134	$6	Beauregard Mike	295	343	$240	$100	$25	$57	$1,549	$836	$1,287	$1,094	$1,608	$1,930
15	Apr	16	Sand	17.0	New Customer	Nova Scotia	$6,433	Chevrolet Express	$132	$399	$73	$250	$134	$65	$134	$6	Jean Bartholomew	295	343	$240	$100	$25	$57	$1,615	$836	$1,287	$1,094	$1,608	$1,930
16	Apr	22	Wood	18.0	New Customer	Manitoba	$6,433	Chevrolet Express	$132	$399	$74	$250	$134	$65	$134	$6	Jaison Augustine	295	343	$240	$100	$25	$57	$1,616	$836	$1,287	$1,094	$1,608	$1,930
17	May	5	Sand	11.0	Retaining Customer	Nunavut	$8,765	Chevrolet Express	$132	$387	$50	$250	$128	$34	$128	$46	Alessandro Smith	333	343	$240	$100	$26	$58	$1,579	$1,139	$1,753	$1,490	$2,191	$2,630
18	May	13	Sand	21.0	Retaining Customer	Nova Scotia	$8,765	Chevrolet Express	$132	$387	$50	$250	$128	$34	$128	$46	Beauregard Mike	333	343	$240	$100	$26	$58	$1,579	$1,139	$1,753	$1,490	$2,191	$2,630
19	May	14	Sand	22.0	Retaining Customer	New Brunswick	$8,765	Chevrolet Express	$132	$387	$50	$250	$128	$34	$128	$46	Jean Bartholomew	333	343	$240	$100	$26	$58	$1,579	$1,139	$1,753	$1,490	$2,191	$2,630
20	May	15	Iron	23.0	New Customer	Nunavut	$8,765	Chevrolet Express	$132	$387	$50	$250	$128	$34	$128	$46	Jaison Augustine	333	343	$240	$100	$26	$58	$1,579	$1,139	$1,753	$1,490	$2,191	$2,630
21	Jun	17	Iron	12.9	Retaining Customer	Manitoba	$5,432	Chevrolet Express	$132	$245	$50	$250	$120		$120	$66	Alessandro Smith	295	343	$240	$100	$27	$59	$1,409	$706	$1,086	$923	$1,358	$1,630
22	Jun	18	Iron	12.9	Retaining Customer	New Brunswick	$5,432	Chevrolet Express	$132	$245	$50	$250	$120		$120	$66	Beauregard Mike	295	343	$240	$100	$27	$59	$1,409	$706	$1,086	$923	$1,358	$1,630
23	Jun	18	Iron	21.0	Retaining Customer	Nova Scotia	$5,432	Chevrolet Express	$132	$245	$50	$250	$120		$120	$66	Jean Bartholomew	295	343	$240	$100	$27	$59	$1,409	$706	$1,086	$923	$1,358	$1,630
24	Jun	24	Iron	22.0	New Customer	Nova Scotia	$5,432	Chevrolet Express	$132	$245	$50	$250	$120		$120	$66	Jaison Augustine	295	343	$240	$100	$27	$59	$1,409	$706	$1,086	$923	$1,358	$1,630
25	Jul	7	Wood	23.0	New Customer	British Columbia	$6,778	RAM ProMaster	$132	$400	$50	$250	$134		$134	$6	Alessandro Smith	295	377	$264	$100	$28	$60	$1,558	$881	$1,356	$1,152	$1,695	$2,033
26	Jul	19	Wood	12.0	New Customer	Manitoba	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Beauregard Mike	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
27	Jul	19	Wood	13.0	Retaining Customer	New Brunswick	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Jean Bartholomew	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
28	Jul	20	Wood	14.0	Retaining Customer	Nunavut	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Jaison Augustine	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
29	Jul	21	Wood	15.0	Retaining Customer	Alberta	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Alessandro Smith	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
30	Jul	25	Wood	16.0	Retaining Customer	Nunavut	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Beauregard Mike	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
31	Jul	7	Wood	23.0	New Customer	British Columbia	$6,778	RAM ProMaster	$132	$400	$50	$250	$134		$134	$6	Jean Bartholomew	295	377	$264	$100	$28	$60	$1,558	$881	$1,356	$1,152	$1,695	$2,033
32	Jul	19	Wood	12.0	New Customer	Manitoba	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Jaison Augustine	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
33	Jul	19	Wood	13.0	Retaining Customer	New Brunswick	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Alessandro Smith	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
34	Jul	20	Wood	14.0	Retaining Customer	Nunavut	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Beauregard Mike	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
35	Jul	21	Wood	15.0	Retaining Customer	Alberta	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Jean Bartholomew	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
36	Jul	25	Wood	16.0	Retaining Customer	Nunavut	$6,778	RAM ProMaster	$132	$400	$50	$250	$134	$65	$134	$6	Jaison Augustine	295	377	$264	$100	$28	$60	$1,623	$881	$1,356	$1,152	$1,695	$2,033
37	Aug	8	Sand	17.0	Retaining Customer	Nova Scotia	$6,543	RAM ProMaster	$132	$400	$50	$250	$121		$51	$51	Alessandro Smith	295	389	$272	$100	$29	$61	$1,517	$851	$1,309	$1,112	$1,636	$1,963
38	Aug	20	Sand	18.0	Retaining Customer	Alberta	$6,543	RAM ProMaster	$132	$400	$50	$250	$121		$51	$51	Beauregard Mike	295	389	$272	$100	$29	$61	$1,517	$851	$1,309	$1,112	$1,636	$1,963
39	Aug	22	Sand	12.9	Retaining Customer	British Columbia	$6,543	RAM ProMaster	$132	$400	$50	$250	$121	$33	$51	$51	Jean Bartholomew	295	389	$272	$100	$29	$61	$1,550	$851	$1,309	$1,112	$1,636	$1,963
40	Aug	23	Sand	12.9	Retaining Customer	Manitoba	$6,543	RAM ProMaster	$132	$400	$50	$250	$121	$33	$51	$51	Jaison Augustine	295	389	$272	$100	$29	$61	$1,550	$851	$1,309	$1,112	$1,636	$1,963
41	Sep	25	Wood	12.9	Retaining Customer	Manitoba	$8,633	RAM ProMaster	$132	$400	$50	$250	$134		$134	$6	Jean Bartholomew	295	234	$164	$100	$23	$55	$1,448	$1,122	$1,727	$1,468	$2,158	$2,590
42	Sep	26	Wood	18.0	Retaining Customer	New Brunswick	$8,633	RAM ProMaster	$132	$400	$50	$250	$134		$134	$6	Jean Bartholomew	295	234	$164	$100	$23	$55	$1,448	$1,122	$1,727	$1,468	$2,158	$2,590
43	Sep	27	Wood	19.0	Retaining Customer	Nunavut	$8,633	RAM ProMaster	$132	$400	$50	$250	$134		$134	$6	Jean Bartholomew	295	234	$164	$100	$23	$55	$1,448	$1,122	$1,727	$1,468	$2,158	$2,590
44	Sep	27	Wood	20.0	Retaining Customer	Nunavut	$8,633	RAM ProMaster	$132	$400	$50	$250	$134		$134	$6	Jean Bartholomew	295	234	$164	$100	$23	$55	$1,448	$1,122	$1,727	$1,468	$2,158	$2,590
45	Oct	1	Wood	21.0	Retaining Customer	Nunavut	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Alessandro Smith	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
46	Oct	2	Wood	22.0	Retaining Customer	Nunavut	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Alessandro Smith	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
47	Oct	10	Wood	23.0	Retaining Customer	Nunavut	$6,433	Chevrolet Express	$132	$399	$50	$250	$134		$134	$6	Beauregard Mike	295	343	$240	$100	$25	$57	$1,527	$836	$1,287	$1,094	$1,608	$1,930
48	Oct	10	Sand	12.9	Retaining Customer	Nunavut	$3,456	Nissan NV2500	$132	$400	$50	$250	$128	$65	$134	$6	Jaison Augustine	295	343	$240	$100	$24	$56	$1,585	$449	$691	$588	$864	$1,037
49	Oct	11	Wood	13.0	Retaining Customer	Nunavut	$6,433	Chevrolet Express	$132	$399	$50	$250	$134		$134	$6	Beauregard Mike	295	343	$240	$100	$25	$57	$1,527	$836	$1,287	$1,094	$1,608	$1,930
50	Oct	28	Sand	14.0	Retaining Customer	Nunavut	$3,456	Nissan NV2500	$132	$400	$50	$250	$128		$134	$6	Jaison Augustine	295	343	$240	$100	$24	$56	$1,520	$449	$691	$588	$864	$1,037
51	Oct	28	Sand	15.0	Retaining Customer	Nunavut	$3,456	Nissan NV2500	$132	$400	$50	$250	$128		$134	$6	Jaison Augustine	295	343	$240	$100	$24	$56	$1,520	$449	$691	$588	$864	$1,037
52	Oct	29	Sand	16.0	Retaining Customer	Nunavut	$3,456	Nissan NV2500	$132	$400	$50	$250	$128		$134	$6	Jaison Augustine	295	343	$240	$100	$24	$56	$1,520	$449	$691	$588	$864	$1,037
53	Oct	1	Wood	21.0	Retaining Customer	Nunavut	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Alessandro Smith	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
54	Oct	2	Wood	22.0	Retaining Customer	Nunavut	$5,556	Freightliner Sprinter	$132	$400	$50	$250	$120	$65	$134	$6	Alessandro Smith	295	343	$240	$100	$22	$54	$1,573	$722	$1,111	$945	$1,389	$1,667
55	Nov	29	Iron	18.0	Retaining Customer	Nunavut	$4,782	Nissan NV2500	$132	$400	$50	$250	$120	$65	$134	$6	Jaison Augustine	295	399	$279	$100	$25	$57	$1,618	$622	$956	$813	$1,196	$1,435
56	Nov	11	Iron	17.0	Retaining Customer	Nunavut	$4,782	Nissan NV2500	$132	$400	$50	$250	$120	$65	$134	$6	Jaison Augustine	295	399	$279	$100	$25	$57	$1,618	$622	$956	$813	$1,196	$1,435
57	Nov	23	Iron	18.0	Retaining Customer	Nunavut	$4,782	Nissan NV2500	$132	$400	$50	$250	$120	$65	$134	$6	Jaison Augustine	295	399	$279	$100	$25	$57	$1,618	$622	$956	$813	$1,196	$1,435
58	Nov	23	Iron	18.0	Retaining Customer	Nunavut	$4,782	Nissan NV2500	$132	$400	$50	$250	$120	$65	$134	$6	Jaison Augustine	295	399	$279	$100	$25	$57	$1,618	$622	$956	$813	$1,196	$1,435
59	Nov	29	Iron	18.0	Retaining Customer	Nunavut	$4,782	Nissan NV2500	$132	$400	$50	$250	$120	$65	$134	$6	Jaison Augustine	295	399	$279	$100	$25	$57	$1,618	$622	$956	$813	$1,196	$1,435
60	Dec	12	Wood	12.9	Retaining Customer	Nunavut	$5,287	Nissan NV2500	$132	$400	$50	$250	$134		$134	$6	Jaison Augustine	295	343	$240	$100	$26	$58	$1,530	$687	$1,057	$899	$1,322	$1,586
61	Dec	24	Wood	18.0	Retaining Customer	Nunavut	$5,287	Nissan NV2500	$132	$400	$50	$250	$134		$134	$6	Jaison Augustine	295	343	$240	$100	$26	$58	$1,530	$687	$1,057	$899	$1,322	$1,586
62	Dec	25	Wood	18.0	Retaining Customer	Nunavut	$5,287	Nissan NV2500	$132	$400	$50	$250	$134		$134	$6	Jaison Augustine	295	343	$240	$100	$26	$58	$1,530	$687	$1,057	$899	$1,322	$1,586
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