Jenkins_Overcharges.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Invoice Date	Nbr	Street	Hours	Rate	Auth Rate	Billed Amt	Auth Amt
2	6/11/2022	136	Elkan	2	175	80	350	160
3	5/3/2022	509	Teston	3	100	80	300	240
4	5/3/2022	300	Rand	3	175	80	525	240
5	5/3/2022	102	Fermo	3	175	80	525	240
6	5/3/2022	5815	Weeks	3	175	80	525	240
7	5/3/2022	20	S Barat	3	175	80	525	240
8	5/3/2022	6159	Emerald	3	115	80	345	240
9	5/3/2022	812	Ford	3	175	80	525	240
10	5/3/2022	529	Teston	3	62	62	186	186
11	6/3/2022	509	Teston	3	100	80	300	240
12	6/3/2022	300	Rand	3	175	80	525	240
13	6/3/2022	102	Fermo	3	175	80	525	240
14	6/3/2022	5816	Weeks	3	175	80	525	240
15	6/3/2022	20	S Barat	3	175	80	525	240
16	6/3/2022	6159	Emerald	3	115	80	345	240
17	6/3/2022	812	Ford	3	175	80	525	240
18	6/3/2022	526	Teston	3	62	62	186	186
19	6/11/2022	5153	Wallingford	5	125	80	625	400
20	6/11/2022	5101	Rockingham	2	62	62	124	124
21	6/11/2022	233	Ruggles	5	125	80	625	400
22	6/11/2022	102	Fermo	2	62	62	124	124
23	6/11/2022	141	Elkan	3	125	80	375	240
24	6/11/2022	621	Ferguson	2	175	80	350	160
25	6/11/2022	606	Belmont	3	150	80	450	240
26	6/11/2022	311	Wiegel	2	62	62	124	124
27	6/11/2022	136	Elkan	2	175	80	350	160
28	6/11/2022	7585	Blanding	3	150	80	450	240
29	6/11/2022	128	Anabel	3	125	80	375	240
30	6/22/2022	621	Ferguson	2	62	62	124	124
31	6/22/2022	139	S Hartnett	2	75	75	150	150
32	6/22/2022	115	S Hartnett	2	100	80	200	160
33	6/22/2022	1013	Clearfield	2	150	80	300	160
34	6/22/2022	526	Ford	4.5	125	80	562.5	360
35	6/22/2022	24	N Marguerite	3	175	80	525	240
36	6/22/2022	2	Belleville	1.5	125	80	187.5	120
37	6/22/2022	122	Paul	2.5	175	80	437.5	200
38	6/22/2022	1514	Nesbit	1	145	80	145	80
39	6/22/2022	315	Coppinger	2	115	80	230	160
40	6/22/2022	216	N Harvey	1	80	80	80	80
41	6/22/2022	385	S Harvey	1.5	85	80	127.5	120
42	6/22/2022	38	Lee	1.5	100	80	150	120
43	7/6/2022	202	LaMotte	3	115	80	345	240
44	7/6/2022	416	Ballman	2	125	80	250	160
45	7/6/2022	424	Millman	2	175	80	350	160
46	7/6/2022	58	Barat	1.5	160	80	240	120
47	7/6/2022	925	Robert	2.5	115	80	287.5	200
48	7/6/2022	26	S Barat	1.25	90	80	112.5	100
49	7/6/2022	315	Coppinger	1.25	80	80	100	100
50	7/6/2022	14	Forestwood	2.5	150	80	375	200
51	7/6/2022	208	N Harvey	5	160	80	800	400
52	7/6/2022	321	Ballman	3	225	80	675	240
53	7/7/2022	14	Patricia	2	200	80	400	160
54	7/7/2022	414	N Florissant	2	150	80	300	160
55	7/7/2022	8428	Hawkesbury	2.25	110	80	247.5	180
56	7/7/2022	5990	Dupree	2	225	80	450	160
57	7/7/2022	2	S Clark	1.25	80	80	100	100
58	7/7/2022	529	Ford	2	175	80	350	160
59	7/7/2022	130	Anabel	2	175	80	350	160
60	7/7/2022	135	Paul	2	115	80	230	160
61			TOTAL				$ 20,416	$ 11,578	$ 8,838	<= Total overcharge amount
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