june july usage 2021 to 2023.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Meter	2021-06 Usage	2021-07 Usage	2022-06 Usage	2022-07 Usage	2023-06 Usage	2023-07 Usage	2021-06 per day 28	2021-07 per day 34	2022-06 per day 30	2022-07 per day 34	2023-06 per day 36	2023-07 per day 29
2	Water	20222011M	790	879	376	858	1088	373	28.2143	25.8529	12.5333	25.2353	30.2222	12.8621
3	Irrigation	20032781LM	62	150	10	163	137	168	2.2143	4.4118	0.3333	4.7941	3.8056	5.7931
4	Water	20032769LM	253	487	681	892	486	318	9.0357	14.3235	22.7000	26.2353	13.5000	10.9655
5	Water	20052113LM	11	8	1	9	12	159	0.3929	0.2353	0.0333	0.2647	0.3333	5.4828
6	Water	98240049LM	462	624	0	0	0	0	16.5000	18.3529	0.0000	0.0000	0.0000	0.0000
7	Water	20032777LM	20	34	89	150	102	420	0.7143	1.0000	2.9667	4.4118	2.8333	14.4828
8	Water	20032780LM	1	7	4	8	16	106	0.0357	0.2059	0.1333	0.2353	0.4444	3.6552
9	Sewer		480	663	537	627	770	548	17.1429	19.5000	17.9000	18.4412	21.3889	18.8966
10			2079	2852	1698	2707	2611	2092	74.25	83.88	56.60	79.62	72.53	72.14
11							Monthly Cost		$ 15,734	$ 21,950	$ 14,776	$ 22,327	$ 23,161	$ 18,940
12							Average Daily Cost		$ 562	$ 646	$ 493	$ 657	$ 643	$ 653
13								Usage	June 21	July 21	June 22	July 22	June 23	July 23
14								Water	54.8929	59.9706	38.3667	56.3824	47.3333	47.4483
15								Irrigation	2.2143	4.4118	0.3333	4.7941	3.8056	5.7931
16				Rate per CCF	Annual Increase	3-year Increase		Sewer	17.1429	19.5000	17.9000	18.4412	21.3889	18.8966
17			July-20	5.593				Total	74.2500	83.8824	56.6000	79.6176	72.5278	72.1379
18			July-21	6.029	7.80%
19			July-22	6.493	7.70%
20			July-23	7.006	7.90%	25.3%
21
22				Sewer Rate
23			July-20	11.365
24			July-21	11.723	3.15%
25			July-22	12.172	3.83%
26			July-23	12.787	5.05%	12.5%
27
28
29
30
31
32
33
34
35					Comparison			Usage
36					Water 2021 and 2023			-17.5%
37					Irrigation 2021 and 2023			44.9%
38					Sewer 2021 and 2023			9.9%
39					Total Usage 2021 and 2023			-8.5%	7.4%	Total cost increase
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