Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
03B02 Public Works
U) sZ (n Cost '+ cQ C (p -. 0 5N5� O � v Ch 5� v F (n �Sv O -, �zr0(D CL(D cn n v O C (DD cOnrt 0 (D 'O -0 (D CQ C 0 U' (n 0 Cl) v , cQ Sll� r+ (D O O ; 0 v,(n(D v 0 CD 0E 0 cQ 0- te r,- 0O 10 CD O O - h * n O 3 0 O O CD C<D v p �' O C) 0-,< m (n CD O o CD O CD m U) sZ (n < '+ cQ C (p -. 0 cn � (D O � v Ch cn v F (n �Sv O -, �zr0(D CL(D cn n O C (DD cOnrt 0 (D 'O -0 (D CQ C 0 U' (n 0 Cl) v , cQ Sll� r+ (D O O ; 0 v,(n(D v 0 CD 0E 0 cQ 0- te r,- 0O 10 CD O O - h * O cr) O 3 O O O CD C<D p �' O C) 0-,< �(D (n CD O o CD O CD S \ (D m (n O — r� 0 w ` ( O hu 3 '< C/) O COD -0 (Q Q CD O O oi3(a9-oo C) (D c(nCDQm iii w(n 0�.3CD:�OQ(n:3 (D -6 3 (n (n CQ -, —' c o 0 -O * � -00 ((D U (D �. O DoCDCD��,��(D3 w w 0 3 Q CD n M (D 3 U)Q zT (D O" O 3' O O `< CD Zr � I < o Z3 00 (Q<M CD CD Uricc �. Sy O-� iv < cn n O a (n (n cD 0 — v Cl< cc o �� zszQ� (yam cn (D r+ v CD (n O (D CSD M;=i:O -a O N VOi Cr O O S p< O 0 (D O 3 cn O (Q O � O 0 N O h 00 n WCD ZT O C:) O O O cyl cn (n (D m ;w3CD33'-. Cn (D (D w 0 3 (n a (D �. n sll w sz CD sz m CD o oo�o�� CD CD CD h{ N �� CD (2 co -D..0 Q �' tV O N C QOcn CD—CD O -+-O + CSD cn O O O Q < C — CD �(D3,�3�n'� W v FD 6,: m =r CD C1 C CD CD (3D 0 < C rr O O CD Csli O C O (CD n U (D C= O O h cn W O i -0 O O (D N 0 C) CCD Sll CQ 0-0 CD CD 3 — Sv cn_C = 0- (D - O Q m00�-,3 M sv co CD (D 3 O = CD W CD Q zT O sll O (D O Sll CD 3 < COD' (=CD ► O (D AliC O TLS' O CD O O m CD < CD Q. , lV. 0 "S 0 X cn W O N O y a1 CL 0 00 O V m (DD CD 0 3 CD C2 CD Q. O CD �a a� n (D (D rt {-A 'O N C 3 rt O Q CD m3r --� O O O O (D (D a n' 0 U) * Z 5' O (D T (D (n .Q CD C �. 3 W -0 (D N 3 C CD 3 3= sv v CD cr cn Q O 0 CD CD O Q Q O CD � � Q O 3 ho ZT (Dm_0 CD W O C 0 CDm3 v 3 CD O N O n N 0 O C C � � Q C (D O O � Cn p -n a, rt 0 O CD • • a 0 ro rt SU Om d M C- D c- = �O o3 v o M O 3 PD cD v C CD n CD N O rr O cn CD (D CD ((D rr `G no COD 3CD Q (D 3 n 3 n O D v o N O O n O Cy O Cost m m o 1$ `$, �o K � r n m ✓� o v o✓ D CD N 10 �O r� O h 00 n WCD ZT O C:) O O O cyl cn (n (D m ;w3CD33'-. Cn (D (D w 0 3 (n a (D �. n sll w sz CD sz m CD o oo�o�� CD CD CD h{ N �� CD (2 co -D..0 Q �' tV O N C QOcn CD—CD O -+-O + CSD cn O O O Q < C — CD �(D3,�3�n'� W v FD 6,: m =r CD C1 C CD CD (3D 0 < C rr O O CD Csli O C O (CD n U (D C= O O h cn W O i -0 O O (D N 0 C) CCD Sll CQ 0-0 CD CD 3 — Sv cn_C = 0- (D - O Q m00�-,3 M sv co CD (D 3 O = CD W CD Q zT O sll O (D O Sll CD 3 < COD' (=CD ► O (D AliC O TLS' O CD O O m CD < CD Q. , lV. 0 "S 0 X cn W O N O y a1 CL 0 00 O V m (DD CD 0 3 CD C2 CD Q. O CD �a a� n (D (D rt {-A 'O N C 3 rt O Q CD m3r --� O O O O (D (D a n' 0 U) * Z 5' O (D T (D (n .Q CD C �. 3 W -0 (D N 3 C CD 3 3= sv v CD cr cn Q O 0 CD CD O Q Q O CD � � Q O 3 ho ZT (Dm_0 CD W O C 0 CDm3 v 3 CD O N O n N 0 O C C � � Q C (D O O � Cn p -n a, rt 0 O CD • • a 0 ro rt SU Om d M C- D c- = �O o3 v o M O 3 PD cD v C CD n CD N O rr O cn CD (D CD ((D rr `G no COD 3CD Q (D 3 n 3 n O D v o N O O n O Cy O m CD n CD v O Q O rZ cn CD 0 - CD m < (D 0- w w `< -h -i � (D Cf) co:'Fn— -- (Q ((D 0 v < --I cinCD.m3w _ �' CD m 0 (n m cn 3 v Q(D (D Q_ :3 C37 CD o-0 Q� z3 ( Q h (QQ� mo m h< O c 0 (n N v � Q l< 3-0 O o U cn Q 0 (Q h0-3 o\ N (D m -L_ (D O O —hQ (DA v m CD Q 0 m �(�• m T r� Z U) V �`< �. 3 cn O < n : (D CL Mm Q cnO o 0 Z) O (' a \ n (D (D O v, Ea N cr m CD �-D -;N-'< o Z Q (D O O _n.m ZTCnm Off_ cl) 0 CD < cn o v CQ O _O _� fn O m (D (D 3 m CD (Q w O _ 3 m Z3 X- Z3 � (.0 0 0) cD (n (D cn CCD -i CL (DFD(D zr o o Q Q h m FD* - m a' Q D o <Aw v h -0 cD cn r* Ov Z;v Q—'c < --I CD, m cn (D �• m 0 (n m cn 3 v m m (p zT �� Q� z3 ( _ Cl) -. 0 v v 3 (a w (D3N�,c Q �' �' O C) O (D CD O O C: (D O < OO p C) m ��cn C� �`< (n p O '" (n Z-3 (p o O (D CD o Q cnO o 0 Z) CD CD 3m c cn o Q" 3 CD C� Q O C) o Z Q C CD cl) 0 CD h x n h u> CD CD 3 m CD (Q w O ., h 3 m Z3 CD Z3 � (.0 " n O I (Q "s, cost Sr _8N 8W AA 8 O O O O O O 0 o v m < �< C/) < --I CD, m cn cn v m v Q m m (p zT m v v m v v v "m — o a Q �' �'� o Q �. o -F cn -EO 1-1 Z.('olo m -� m(' o n,m n Q77 Z) (�D O C� mo (n p O '" (n y Q Cn (D CD O O O O s Z - - 0 Z) � — , fn CDQ c p V: C� Q O o C O3 n h u> CD 3 � 3 m CD (Q w O O Cn (Q p O O _� " n O < m 7. CD m m Q O O o Q Q h m in m a' Q O- I (n o 3 00 < m CD O (D cn v hs 0 (D < '� O =� :3 (D O CD O O omvm -� O� h0CD((D (D CD m 7v�ccD3O�3(n cD cn m m o 0 n cn o 3 �' O .� � Q m M(Q (ham CD N Q a cn v < (D O Q (D m (D (E) l<CL �G �" ml . m : ; o 0 0� G m; (DD " O i w � ((D Cn (rD O (D CCD O Q O Q (Q O (D(aQOM m < (D 0- O m (n Oh rr � -+ O �' m o OZ o O N W Z3 zT c m w (� CD cr m m con o l J cn N N p pA N Opp Oo _O YL CD CD O � ON 00 00 pO 00 g0 O 3CD /=3 /o Is CD �$� m — O CD fD � (D Q w : ?OJ O J fD ,--r CD 0- - � (D r QcnM r) (D �o - J� s m 3 _ Q CD r+ °J� (� 0 CT W CD m N cn m m CD (n � ,y � JD rD � -% Q O o 0'o !r m O O Z Q 'O (D Q jOJ R1 �CC 0 O 6 jOJ C Q Q � �t w r'1• > d�J� _ suv� o m Q m (D N i n X, C --I 0 3 C7 1p C7 co W (D < `< Cn -69 '< 'a w Cn �-0 p< n CD (D p O o cin v O p-0 C— 3 (D `n -m ;v CD _oQ-•° �C p 3 N) (D Q �•p h < — C 3 `< CD (n C (D CD n< CD -i n m 77 N n I o O ° C CD cn CD to C"Q�' O SU C O Cm Q � - O O cc CD C CD (Cn (n O Q �-, E n n n O � `< c°n O" C Q < 00 (n O W (Q O CD — Sll fn (n N C 3 C :3 C O = C (D (D (D C Q (n -— 5.0 CD Cn (D S2 — O Sll O -53"O O p O CD (D CD (D < CD S2 N O O N o MC/) 5 (D :E 0 (n M p CS v* E C (n :ECD U) W (D C -Ca W-0 o n °(z(m-'v(D � �3= (a�0-m rn C) Cn T (D ChD C3D -o c (Q O O `Z n CD (a � —' Q (<D O O o (D (D ° c CD � < m 3 0 D o v c�D m m� c 0 ° CD QQ j (D C ° 0 �' v cQ ;7 :3 cn cn < (D Cn O O CD cn (D v (D o 6 O c O CD ChD 3 O 3 O v(n� o��3m(D°Q�m��� `�ocnchn�o�cD Q�•o� CD O CD .n� (p n v CD v CC O � — (D v zT (D C (D `< M � O rt CD �_ (D (� T, :3- C n_ 0 (Q �' (D _ O 3 cn O CD C �' (D CD CD CSD O -' (D (D 0 h �r (n -0 � CD (7 O p Q p O r+ p < O h CD 'a N CD (D O• CA Cn (D CD (7 Q n , < � � w r" O ZT SU (D SU n ZT 0 CT O C C w (D CD 3 rt =h �__ 3 C2c cn +Sv O -0O O (D h — cn iU Cn n w (n zT M r w `G `G Q CD (D w CD n CD O CD O � � � -� Q � � O (D � w � � � n cn 0 < CD p- � Cn CO � � (n o � � o O (D w cn C �, � O CD 0 � (n � � CD ° C O v O Q T: n T. rr S n -� � O w cn C w n , Cn _ CD CD CD CD iv (D CD T (D Cn �. O O (n cn 0 o- CD O O (D ccn � C -0' � v (n ch—D - M C. v (n p' O CD �,, Q O C 0- CD CD C O (D O O Q p c C � W (D O (D O � CSD � ZT � r r �r O fn' n (�D (D � °chi cD sll m CD zTp —m �v cn � �� ° nio m �0� cnooc � h°Qh (D mm-0o3�3 Co ,.,2 Qm CDD 0� ccnn"o ° C7� om v O (D O� p (CD cost 0 zT 7 v ncl) C CD (D (D < �(D err �� N�� �_� rr(n W (D CD (� a O O 8 8 8 8 o Q QA C) D� (D C,-- —I C O 0000082525 (D (7 O O o p (cnp C �$ CD O ° .� (D O O 9 (D O 5. O � Q ? 3 E O N O (D v N 0 CQ Efl n' w ✓o C � 0 Cn ZT r r CD O (D n f2 (Q T . - to CD ccn O (D (D m (D O % I ori O� iS ZS r r (D N (D O °✓ Q (D CD v (Q w Cn 0-3 < CD 1� 8 0 �_ (D CD O N CD n Sll % O (° O SD (n (D p s (DQ 00 Q < �Q• (D 3 ro✓ CU p m 0 3 �' CD Cn 3 -z °✓' CD(DD m (D < cn C < 0 °✓ h n m m M (D O 'O T T, (D C '=t (Q (D (Q CD(n. cn 0 `� CD C37 C Q_ (Q (D (D 0- 0 C O (D v ChD O Q_ p CA (n' () Q" 4fl n -- N � '" � 4fl ffl cn (D Q_ _. (D v :E O v v p 0, O� � -1 � C O Nn C N c m cn m =� _ Sv �'�n -t C<D � 0 CD Cn (D _ O ; T O Zr fn 0-- CD- M CD O � Cn h CD = CD (n (D 3 Q CD (D (OD h M (D ro CD `< O CD W O O O cn cn CD CD O CQ CD O 3 n y v CD (p , (D (D m _ O. CQ cD (Q (DCD CD �I CD h v Q O Q W co y O 0 3 (D (D C<D CD CD CO _ 0 � � N Q (D " p O - Q O =- :3 (D p - Q_ C Oh CQ p- Q —_ (D ZS Q -t, p Q O O 3 O(0 O Q 0-(C zT (D X,_ O (D cn v CD O C] NCD , p "p C: O O n O w _ n 3 �. (D O p 0 h CSD fD O CD (D Q cn `< O w� O n CD O O Q_ � Z� CO N CD O - t, O G O O O .Q-� , SU CD cn v Q Q p c CQ o --1 N CD Vfcn . • cn CD W cn D _0 N v hO zT Ut O O 3 C 0 O 0 ZT Fn p (D aQ O O D -,I CD CD n D M n CD CD D _0 DL O (D 0 QN0 O D O n"w �+3 �0;7O QD Q_w zT (n CD D Q_ CD O cn - v v<hQ_ O < O Q h vcn OQ -, �p p �O O wQ h fn (D r r w O p 0 C17 � h (n (D Cost O O CD SU rF N m O v O (D CD (D 0888800 A W r� ::� O n $� CostzT �$ (D �• o o go 9 Ol Z3 CD �� dojo (D 2 0r✓ CD n Q(Q 00, M o w O I rp U)qi� (D O�0(7 8 io (D CD p �0 (D v 3 0 `'0 �`' Ln rs O (D 10 206 = ,--t CD _D- `'y 10 h 2 110 � Q 0- Q_ � O v —� 0-0 CTD v(D (D Q_ _. (D v :E O w CD v (D —0- v (Q 3 O 0 7c < m CD O � CD < . Q O (D Q CD _0 V) n rr 0- h C S < �' O (D `, f Sv CD Q O p Q S Q (D -0 O (D 0 ; O O CD cn -h (n Q O h -p 0• o h 3 W (D = W p cin cn cn = —I 0 s <r e Mc00 h CD = CD (n (D 3 Q D O n (D ro CD `< ((DD O =5 {o `GzT 3 '- W (D CD �. O ((D O (nn n (D CD 0 O 0_ (n Op � O cr 0- cn Q" 3 O (DD h (D O —I CD 3 Q (D fD _0cn CSD --, (D Will = Z3 cD (Q (DCD CD cn (0 r� O Q� O CD h 0 � O Cr -, rt O -0 cn zr N CD cn 0- cn O. 11 (D zT (D QQ CL O 6 X, n (D O zT O (D O O 0- 4 =3 0 - CD O CDLO i►i h En zT CD cn CCD CDD O cn O O (n CD CD � Q (D (D � Q CD O (D O N zT Q CD WW h D o (0 r -r• 0 O n y 0. -n U) � =.(D v v o� (D v m CD a 3— cn CD CD o CD ::� w Sv -CO CD = cD 0 3 CD 0 -P CnCD m r+ •O -I w O 1 cn CD W I C (n w 77 -+ CD 'a p CD =— CD O !y CD I -', O cn x- O -- O Q. n O n CD Sv W CD a (p O N :3 cn -a CD cQ" 00 5 r` ' N 3 O Q p v CL CD CD Cn CD D � C =r� s O (CD CD ;7-, O cn CD v CD v o v � C7 co CD CD CDC ((DD cOn Q Q�.CD C � n O cn Qom' O 3 h0hho_ CD O to O 3 3 (D CD + c zr 3 00 O Zr O CD O Q � CD 7 O CD Cp Q O ,� O CD m Cr CD CD � 3 Q Q M z CD CD O -�' cn CD O CD CD cn - 3 cD C' n Q COAD : � O O CD h O O (Q v in � 3 Q CL cc p (D CD = CCD -y, O 3 -O " h CD O0 M C CCD CD -0 0 M O =3 -, CD O --s n n v N o O CD (a' CCD �+ O CD O 0 CD CD :3 M "a CS- ,-O (D CL N CD. CD CD =:3 (n CD 0 CD `� Om CD CZ O N cn O 0 0 O n y 0. Budget Comparison Report 7/19/2019 12:41:57 PM Page 21 of 32 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % _ Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jul Department: 31- STREET MAINTENANCE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 448,326.39 507,539.22 236,950.65 500,120.00 509,415.00 9,295.00 1.86% 524,700.00 15,285.00 3.00% 4110 - OVERTIME F. T. 26,476.62 20,043.78 18,254.16 30,155.00 31,405.00 1,250.00 4.15% 31,405.00 0.00 0.00% 4120-SAL-P,T./TEMP 54,844.76 65,123.50 32,717.06 55,460.00 76,480.00 21,020.00 37.90% 76,480.00 0.00 0.00% 4141- PERA 34,357.88 38,620.50 20,214.10 41,095.00 40,560.00 -535.00 -1.30% 41,800.00 1,240.00 3.06% 4142 - FICA 36,373.29 39,780.35 20,780.50 44,810.00 47,225.00 2,415.00 5.39% 48,642.00 1,417.00 3.00% 4144 -HEALTH INSURANCE 90,549.96 98,040.00 46,905.81 80,410.00 73,455.00 -6,955.00 -8.65% 75,700.00 2,245.00 3.06% 4147 -UNEMPLOYMENT 1,198.70 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4148- WORKERS COMP 40,299.96 47,919.96 31,056.69 53,240.00 55,510.00 2,270.00 4.26% 55,510.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 732,427.56 817,067.31 406,878.97 805,290.00 834,050.00 28,760.00 3.579 854,237.00 20,187.00 2.42% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 10,554.32 13,543.74 4,253.84 10,150.00 10,250.00 100.00 0.999 10,350.00 100.00 0.989 4211- MOTOR FUELS 39,569.51 49,797.47 20,454.86 55,000.00 50,000.00 -5,000.00 -9.099 50,500.00 500.00 1.009 4212 - LUB/ADD 0.00 0.00 0.00 0.00 0.00 0.00 0.009 0.00 0.00 0.009 4216-FERTILIZER/CHEM 4,144.17 7,544.31 6,570.60 10,000.00 10,100.00 100.00 1.009 10,200.00 100.00 0.999 4217-CLOTHING/UNIFORM 7,378.21 5,977.80 4,568.55 7,700.00 7,800.00 100.00 1.309 7,850.00 50.00 0.649 4231- SMALL TOOLS 1,534.61 1,134.53 63.91 1,600.00 1,620.00 20.00 1.259 1,630.00 10.00 0.629 4270 - OP SUP-VEH/EQ 0.00 270.74 0.00 0.00 0.00 0.00 0.009 0.00 0.00 0.009 4271 -OP SUP -OTHER IMP 174,365.20 173,725.42 76,545.76 198,900.00 200,000.00 1,100.00 0.559 202,000.00 2,000.00 1.009 4280 - CAPITAL OUTLAY <$5,000 559.95 0.00 5,514.14 3,000.00 0.00 -3,000.00 -100.009 0.00 0.00 0.009 Total Category: 4200 - COMMODITIES: 238,105.97 251,994.01 117,971.66 286,350.00 279,770.00 -6,580.00 -2.309 282,530.00 2,760.00 0.999 Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 1,025.72 3,190.44 734.64 6,200.00 4,000.00 -2,200.00 -35.489 4,200.00 200.00 5.009 4301- ENGINEERING SVS 3,496.91 14,616.19 607.50 8,300.00 8,383.00 83.00 1.009 8,470.00 87.00 1.049 4305 - FEES FOR SERVICE 24,207.07 30,668.58 15,145.73 23,500.00 22,220.00 -1,280.00 -5.459 22,440.00 220.00 0,999 4310 -COMMUNICATION 2,694.63 2,740.36 1,514.70 2,500.00 2,530.00 30.00 1.209 2,550.00 20.00 0,799 4340 -PRINTING 0.00 0.00 78.50 300.00 0.00 -300.00 -100.009 0.00 0.00 0.009 4341-ADVER/PUBLISH 494.80 299.45 0.00 400.00 400.00 0.00 0.009 410.00 10.00 2.509 4350 - INSURANCE CHARGE 11,499.96 11,700.00 6,825.00 11,700.00 11,820.00 120.00 1.039 11,930.00 110.00 0.939 4370 - MAINT-REPAIR/EQ 0.00 0.00 729.08 0.00 0.00 0.00 0.009 0.00 0.00 0.009 4371-MAINT-REPAIR/OTH 233.31 6,899.92 3,761.92 12,300.00 8,000.00 -4,300.00 -34.969 8,080.00 80.00 1.009 4375 - CHARGE -FLEET MNT 199,396.58 235,499.05 67,902.67 276,000.00 278,760.00 2,760.00 1.009 281,520.00 2,760.00 0.999 4380-RENTAL/LEASE 36,280.00 48,939.80 4,454.00 11,900.00 12,020.00 120.00 1,019 12,140.00 120.00 1.009 4401- DUES & SUBS 180.00 138.00 244.25 200.00 200.00 0.00 0.009 200.00 0.00 0.009 4403-TRAVEL/TRAIN/CON 4,373.05 6,562.20 5,847.89 9,200.00 6,000.00 -3,200.00 -34.789 6,100.00 100.00 1.679 4405 - CLEAN/WASTE REMV 16,575.08 19,059.22 22,500.00 15,200.00 21,000.00 5,800.00 38.169 21,230.00 230.00 1.109 7/19/2019 12:41:57 PM Page 21 of 32 Budget Comparison Report Total Department: 31- STREET MAINTENANCE: 1,271,830.64 1,449,931.86 2017 2018 2019 Parent Budget Total Activity Total Activity YTD Activity Object 2021 fall 2019 Budget Through Jul 4449 - OTHER CONTRACT 70.00 557.33 0.00 Total Category: 4300 - CONTRACTUAL SERVICES: 300,527.11 380,870.54 130,345.88 Category: 4500 - CAPITAL OUTLAY 610.00 10.00 1.67% 4530- MACH & EQUIPMENT 770.00 0.00 0.00 Total Category: 4500 - CAPITAL OUTLAY: 770.00 0.00 0.00 Total Department: 31- STREET MAINTENANCE: 1,271,830.64 1,449,931.86 Comparison 2 Comparison 2 Budget Comparison 1 Comparison 1 Parent Budget Budget to Parent Increase / 2021 fall 2019 Budget 2019 2020 Increase / 379,880.00 2019 2020 (Decrease) 0.00 600.00 610.00 10.00 1.67% 378,300.00 375,943.00 -2,357.00 -0.62% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00% Comparison 2 Comparison 2 Budget to Comparison 1 Budget 2021 Increase / 2021 fall 2019 (Decrease) 610.00 0.00 0.00% 379,880.00 3,937.00 1.05% 0.00 0.00 0.00% 0.00 0.00 0.00% 655,196.51 1,469,940.00 1,489,763.00 19,823.00 1.35% 1,516,647.00 26,884.00 1.80% 7/19/2019 12:41:57 PM Page 22 of 32 Budget Comparison Report Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jul Department: 32 - TRAFFIC SIGNAGE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 77,085.57 70,805.32 35,813.34 76,255.00 74,415.00 -1,840.00 -2.41% 76,700.00 2,285.00 3.07% 4110 - OVERTIME F. T. 1,389.40 1,618.47 748.44 2,805.00 2,710.00 -95.00 -3.39% 2,710.00 0.00 0.00% 4120-SAL-P.T./TEMP 9,840.00 6,941.00 9,202.00 14,560.00 15,680.00 1,120.00 7.69% 15,680.00 0.00 0.00% 4141- PERA 5,915.93 5,350.06 2,896.03 7,255.00 7,260.00 5.00 0.07% 7,500.00 240.00 3.31% 4142 -FICA 5,789.30 4,976.36 3,146.07 7,160.00 7,405.00 245.00 3.42% 7,650.00 245.00 3.31% 4144 -HEALTH INSURANCE 20,900.04 20,900.04 11,433.31 19,600.00 15,900.00 -3,700.00 -18.88% 16,400.00 500.00 3.14% 4148 - WORKERS COMP 7,100.04 7,550.04 4,964.19 8,510.00 8,670.00 160.00 1.88% 8,670.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 128,020.28 118,141.29 68,203.38 136,145.00 132,040.00 -4,105.00 -3.02% 135,310.00 3,270.00 2.48% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 29,581.01 21,575.75 4,105.42 30,100.00 28,300.00 -1,800.00 -5.98% 28,580.00 280.00 0,99% 4211- MOTOR FUELS 3,423.04 2,952.89 999.93 5,200.00 3,000.00 -2,200.00 -42.31% 3,030.00 30.00 1,00% 4217-CLOTHING/UNIFORM 482.98 412.50 0.00 600.00 580.00 -20.00 -3.33% 580.00 0.00 0.00% 4231- SMALL TOOLS 488.15 684.23 60.84 700.00 710.00 10.00 1.43% 720.00 10.00 1.41% 4280 - CAPITAL OUTLAY <$5,000 0.00 2,333.85 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 33,975.18 27,959.22 5,166.19 36,600.00 32,590.00 -4,010.00 -10.96% 32,910.00 320.00 0.98% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 82.00 0.00 100.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4305 - FEES FOR SERVICE 69,065.04 56,009.50 27,672.25 53,400.00 56,000.00 2,600.00 4.87% 56,560.00 560.00 1.00% 4310 -COMMUNICATION 341.86 420.00 227.50 400.00 400.00 0.00 0.00% 410.00 10.00 2.50% 4340 - PRINTING 0.00 0.00 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% 4350 - INSURANCE CHARGE 99.96 200.04 116.69 200.00 200.00 0.00 0.00% 210.00 10.00 5.00% 4370 - MAINT-REPAIR/EQ 0.00 0.00 11,981.00 0.00 0.00 0.00 0,00% 0.00 0.00 0.00% 4375 - CHARGE -FLEET MNT 10,630.39 6,506.82 2,450.02 9,500.00 9,600.00 100.00 1.05% 9,690.00 90.00 0.94% 4401- DUES & SUBS 19.00 5.10 0.00 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 239.50 447.64 72.00 600.00 800.00 200.00 33.33% 850.00 50.00 6.25% 4449 - OTHER CONTRACT 0.00 64.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 80,477.75 63,653.10 42,619.46 64,400.00 67,000.00 2,600.00 4.04% 67,720.00 720.00 1.07% Total Department: 32 -TRAFFIC SIGNAGE: 242,473.21 209,753.61 115,989.03 237,145.00 231,630.00 -5,515.00 -2.33% 235,940.00 4,310.00 1.86% 7/19/2019 12:41:57 PM Page 23 of 32 Budget Comparison Report Category: 4200 - COMMODITIES Comparison 1 Comparison 1 Comparison 2 Comparison 2 4210 -OP SUPPLY -OTHER 219,380.25 205,776.36 204,030.20 Parent Budget Budget to Parent % Budget to Comparison 0.00% 4211- MOTOR FUELS 30,046.34 48,605.51 44,234.52 39,000.00 49,000.00 Budget 25.64% 49,490.00 1 Budget 1.00% 4271- OP SUP -OTHER IMP 2017 2018 2019 2019 2020 Increase / 0.00% 2021 Increase / 0.00% Total Category: 4200 - COMMODITIES: Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 11.15% 2021 fall 2019 (Decrease) 0.16% Object Through Jul Department: 34 - SNOWPLOWING 0.00 0,00 546.00 600.00 610.00 10.00 1.67% 610.00 0.00 0.00% Category: 4100 - PERSONAL SERVICES 0.00 0,00 0.00 300.00 0.00 -300.00 -100,00% 0.00 0.00 0.00% 4100 -SALARY -FULL TIME 41,538.12 89,761.69 92,703.59 126,910,00 160,560.00 33,650.00 26.51% 165,400.00 4,840.00 3.01% 4110 -OVERTIME F. T. 34,959.24 100,687.44 95,277.94 63,000,00 70,315.00 7,315,00 11.61% 72,450.00 2,135.00 3.04% 4120-SAL-P.T./TEMP 1,329,00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141-PERA 6,293.37 14,484.42 14,218,86 14,720.00 17,315.00 2,595.00 17.63% 17,850.00 535.00 3,09% 4142 -FICA 5,768.85 13,500,93 13,150.00 14,530.00 17,660.00 3,130.00 21,54% 18,200.00 540.00 3.06% 4144 -HEALTH INSURANCE 0.00 0.00 0.00 0.00 20,675.00 20,675.00 0.00% 20,675,00 0,00 0.00% 4148 - WORKERS COMP _ 13,299.96 14,000.04 10,071.25 17,265.00 17,600.00 335.00 1.94% 17,600,00 0,00 0.00% Total Category: 4100 - PERSONAL SERVICES: 103,188.54 232,434.52 225,421.64 236,425,00 304,125.00 67,700.00 28.63% 312,175.00 8,050.00 2.65% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 219,380.25 205,776.36 204,030.20 230,000.00 250,000.00 20,000.00 8.70% 250,000.00 0.00 0.00% 4211- MOTOR FUELS 30,046.34 48,605.51 44,234.52 39,000.00 49,000.00 10,000.00 25.64% 49,490.00 490.00 1.00% 4271- OP SUP -OTHER IMP 0,00 0.00 650.00 0.00 0.00 0.00 0.00% 0.00 0,00 0.00% Total Category: 4200 - COMMODITIES: 249,426.59 254,381.87 248,914.72 269,000.00 299,000.00 30,000.00 11.15% 299,490.00 490.00 0.16% Category: 4300 - CONTRACTUAL SERVICES 4305 - FEES FOR SERVICE 0.00 0,00 546.00 600.00 610.00 10.00 1.67% 610.00 0.00 0.00% 4340 -PRINTING 0.00 0,00 0.00 300.00 0.00 -300.00 -100,00% 0.00 0.00 0.00% 4350 - INSURANCE CHARGE 7,500.00 7,500,00 4,375.00 7,500.00 7,580.00 80.00 1.07% 7,650.00 70.00 0.92% 4370 - MAINT-REPAIR/EQ 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4375 - CHARGE -FLEET MNT 160,640.70 187,417.67 140,486.02 160,000.00 161,600.00 1,600.00 1.00% 163,200.00 1,600.00 0.99% 4380 - RENTAL/LEASE 0.00 2,690.00 0.00 2,500,00 2,530.00 30.00 1.20% 2,550.00 20.00 0.79% 4403-TRAVEL/TRAIN/CON 2,022.09 2,300.00 0.00 2,600.00 2,630.00 30.00 1.15% 2,650.00 20.00 0.76% Total Category: 4300 - CONTRACTUAL SERVICES: 170,162.79 199,907.67 145,407.02 173,500.00 174,950.00 1,450.00 0.84% 176,660.00 1,710.00 0.98% Total Department: 34 -SNOWPLOWING: 522,777.92 686,724.06 619,743.38 678,925.00 778,075.00 99,150.00 14.60% 788,325.00 10,250.00 1.32% 7/19/2019 12:41:57 PM Page 24 of 32 Budget Comparison Report 7/19/2019 12:41:57 PM Page 25 of 32 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % _ Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jul Department: 35 - PUBLIC WORKS ADMINISTRATION Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 300,406.01 301,024.13 131,866.05 305,510.00 325,260.00 19,750.00 6.46% 335,000.00 9,740.00 2.99% 4110 -OVERTIME F. T. 4,885.62 6,685.56 3,404.86 5,175.00 5,860.00 685.00 13.24% 6,000.00 140.00 2.39% 4141- PERA 22,405.62 22,923.05 10,480.45 24,080.00 24,835.00 755.00 3.14% 25,600.00 765.00 3,08% 4142 - FICA 21,661.89 22,188.00 10,238.54 23,770.00 25,330.00 1,560.00 6.56% 26,100.00 770.00 3.04% 4144 -HEALTH INSURANCE 40,400.04 40,275.00 22,181.25 38,025.00 39,640.00 1,615.00 4.25% 40,900.00 1,260.00 3.18% 4148 - WORKERS COMP 2,100.00 2,160.00 1,227.94 2,105.00 2,150.00 45.00 2.14% 2,150.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 391,859.18 395,255.74 179,399.09 398,665.00 423,075.00 24,410.00 6.12% 435,750.00 12,675.00 3.00% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 3,425.94 4,057.53 1,208.11 5,200.00 4,200.00 -1,000.00 -19.23% 4,300.00 100.00 2.38% 4210 - OP SUPPLY -OTHER 6,689.98 5,845.97 3,382.43 6,500.00 6,570.00 70.00 1.08% 6,630.00 60.00 0.91% 4211- MOTOR FUELS 3,431.13 4,680.64 1,050.44 5,200.00 4,800.00 -400.00 -7.69% 4,850.00 50.00 1.04% 4217-CLOTHING/UNIFORM 0.00 138.67 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4271 -OP SUP -OTHER IMP 0.00 37.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4272-OPSUP-BUILDINGS 666.81 1,592.73 298.94 3,200.00 2,000.00 -1,200.00 -37.50% 2,000.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 14,213.86 16,352.54 5,939.92 20,100.00 17,570.00 -2,530.00 -12.59% 17,780.00 210.00 1.20% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 40.00 190.60 0.00 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% 4301- ENGINEERING SVS 5,760.00 2,666.78 0.00 1,000.00 1,010.00 10.00 1.00% 1,020.00 10.00 0.99% 4305 - FEES FOR SERVICE 16,460.88 14,298.49 8,140.63 17,000.00 17,170.00 170.00 1.00% 17,340.00 170.00 0.99% 4310 -COMMUNICATION 1,151.20 1,005.52 352.47 1,800.00 1,820.00 20.00 1.11% 1,840.00 20.00 1.10% 4311- POSTAGE 544.92 915.20 18.75 1,300.00 1,000.00 -300.00 -23.08% 1,100.00 100.00 10.00% 4321- DATA PROCESSING 33,976.63 30,000.00 18,375.00 31,500.00 31,820.00 320.00 1.02% 32,130.00 310.00 0.97% 4340 -PRINTING 178.00 105.00 0.00 700.00 200.00 -500.00 -71.43% 200.00 0.00 0.00% 4341-ADVER/PUBLISH 98.00 0.00 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4350- INSURANCE CHARGE 7,500.00 7,500.00 4,375.00 7,500.00 7,580.00 80.00 1.07% 7,650.00 70.00 0.92% 4360 -UTILITIES 44,961.30 47,530.70 21,172.69 50,300.00 50,800.00 500.00 0.99% 51,310.00 510.00 1.00% 4370 - MAINT-REPAIR/EQ 3,501.44 1,579.37 7,291.47 3,000.00 3,030.00 30.00 1.00% 3,060.00 30.00 0.99% 4371-MAINT-REPAIR/0TH 1,280.00 52.99 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4372-MAINT-REPAIR/BLD 20,850.60 14,736.97 10,628.30 24,900.00 23,650.00 -1,250.00 -5.02% 23,890.00 240.00 1.01% 4375 - CHARGE -FLEET MNT 11,079.70 12,998.79 713.39 12,400.00 5,000.00 -7,400.00 -59.68% 5,600.00 600.00 12,00% 4380 - RENTAL/LEASE 6,524.94 5,529.43 2,423.54 5,800.00 5,860.00 60.00 1.03% 5,920.00 60.00 1.02% 4401- DUES & SUBS 52.14 450.00 44.00 700.00 710.00 10.00 1.43% 710.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 2,628.30 1,545.72 1,032.00 2,000.00 3,500.00 1,500.00 75.00% 3,500.00 0.00 0.00% 4405 - CLEAN/WASTE REMV 16,457.80 22,092.70 8,188.60 19,200.00 14,000.00 -5,200.00 -27.08% 14,000.00 0.00 0.00% 4449 - OTHER CONTRACT 0.00 64.00 0.00 1,000.00 0.00 -1,000.00 -100.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 173,045.85 163,262.26 82,755.84 180,400.00 167,450.00 -12,950.00 -7.18% 169,570.00 2,120.00 1.27% 7/19/2019 12:41:57 PM Page 25 of 32 Budget Comparison Report Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent / Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jul Category: 4500 - CAPITAL OUTLAY 4520 - FURN & OFF EQUIP 0.00 0.00 314.07 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 314.07 0.00 0.00 Total Department: 35 - PUBLIC WORKS ADMINISTRATION: 579,118.89 574,870.54 268,408.92 599,165.00 608,095.00 0.00 0.00% 0.00 0.00 0.00% 8,930.00 1.49% 623,100.00 15,005.00 2.47% 7/19/2019 12:41:57 PM Page 26 of 32 Budget Comparison Report Category: 4300 - CONTRACTUAL SERVICES 4300- PROF SERVICES 4301- ENGINEERING SVS 4305 - FEES FOR SERVICE 4310 -COMMUNICATION 4340- PRINTING 4341- ADVER/PUBLISH 4350 -INSURANCE CHARGE 4371- MAINT-REPAIR/OTH 4375 - CHARGE -FLEET MNT 4380 - RENTAL/LEASE 4401- DUES & SUBS 4403 - TRAVEL/TRAIN/CON 4438 - PRO/MISC RESALE 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: 517.50 133.52 100.00 200.00 200.00 Comparison 1 Comparison 1 200.00 Comparison 2 Comparison 2 336.00 0.00 0.00 0.00 0.00 Parent Budget Budget to Parent % Budget to Comparison 104,013.15 24,261.60 98,000.00 100,000.00 2,000.00 2.04% 101,000.00 Budget 1.00% 752.62 1 Budget 437.56 800.00 2017 2018 2019 2019 2020 Increase / 24.00 2021 Increase / 0.00 0.00 Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 20.91 2021 fall 2019 (Decrease) 0.00 Object 0.00% 0.00 Through Jul 0.00% 500.04 500.04 291.69 500.00 500.00 0.00 Department: 36 - FORESTRY 500.00 0.00 0,00% 0.00 0.00 0.00 3,100.00 0.00 -3,100.00 -100.00% Category: 4100 - PERSONAL SERVICES 0.00 0.00% 7,281.37 3,897.46 4,668.81 13,100.00 11,000.00 -2,100.00 -16.03% 11,000.00 4100 -SALARY -FULL TIME 83,196.41 57,835.38 28,471.60 69,600.00 74,570.00 4,970.00 7.14% 76,800.00 2,230.00 2.99% 4110 -OVERTIME F. T. 1,462.88 714.20 1,006.85 1,575.00 2,640.00 1,065.00 67.62% 2,640.00 0.00 0.00% 4120-SAL-P.T./TEMP 9,849.44 15,785.25 5,841.50 15,680.00 15,680.00 0.00 0.00% 15,900.00 220.00 1.40% 4141-PERA 5,759.12 4,371.64 2,325.48 4,375.00 5,245.00 870.00 19.89% 5,400.00 155.00 2.96% 4142 -FICA 6,542.74 5,190.06 2,553.21 6,645.00 7,105.00 460.00 6.92% 7,300.00 195.00 2.74% 4144 -HEALTH INSURANCE 24,900.00 9,000.00 4,299.19 7,370.00 9,175.00 1,805.00 24.49% 9,450.00 275.00 3.00% 4147 -UNEMPLOYMENT 568.78 1,990.73 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4148 - WORKERS COMP 3,939.96 3,470.04 2,508.31 4,300.00 4,370.00 70.00 1.63% 4,370.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 136,219.33 98,357.30 47,006.14 109,545.00 118,785.00 9,240.00 8.43% 121,860.00 3,075.00 2.59% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 6,984.37 6,986.41 4,411.07 10,400.00 10,500.00 100.00 0.96% 10,610.00 110.00 1.05% 4211- MOTOR FUELS 1,593.10 1,453.60 432.63 3,000.00 1,500.00 -1,500.00 -50.00% 1,515.00 15.00 1.00% 4217-CLOTHING/UNIFORM 980.03 470.36 199.74 600.00 610.00 10.00 1.67% 610.00 0.00 0.00% 4231- SMALL TOOLS 3,927.88 634.24 223.11 1,600.00 1,620.00 20.00 1.25% 1,630.00 10.00 0.62% Total Category: 4200 - COMMODITIES: 13,485.38 9,544.61 5,266.55 15,600.00 14,230.00 -1,370.00 -8.78% 14,365.00 135.00 0.95% Category: 4300 - CONTRACTUAL SERVICES 4300- PROF SERVICES 4301- ENGINEERING SVS 4305 - FEES FOR SERVICE 4310 -COMMUNICATION 4340- PRINTING 4341- ADVER/PUBLISH 4350 -INSURANCE CHARGE 4371- MAINT-REPAIR/OTH 4375 - CHARGE -FLEET MNT 4380 - RENTAL/LEASE 4401- DUES & SUBS 4403 - TRAVEL/TRAIN/CON 4438 - PRO/MISC RESALE 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: 517.50 133.52 100.00 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% 336.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 98,338.40 104,013.15 24,261.60 98,000.00 100,000.00 2,000.00 2.04% 101,000.00 1,000.00 1.00% 752.62 840.12 437.56 800.00 810.00 10.00 1.25% 820.00 10.00 1.23% 24.00 181.58 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 20.91 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 500.04 500.04 291.69 500.00 500.00 0.00 0.00% 500.00 0.00 0,00% 0.00 0.00 0.00 3,100.00 0.00 -3,100.00 -100.00% 0.00 0.00 0.00% 7,281.37 3,897.46 4,668.81 13,100.00 11,000.00 -2,100.00 -16.03% 11,000.00 0.00 0.00% 5,680.00 0.00 0.00 2,500.00 2,530.00 30.00 1.20% 2,550.00 20.00 0.79% 145.00 45.00 163.11 400.00 400.00 0.00 0.00% 410.00 10.00 2.50% 2,697.60 3,002.71 923.00 2,700.00 2,730.00 30.00 1.11% 2,750.00 20.00 0.73% 0.00 0.00 0.00 5,200.00 0.00 -5,200.00 -100.00% 0.00 0.00 0.00% 108,452.25 163,533.54 96,746.00 114,200.00 115,340.00 1,140.00 1.00% 116,500.00 1,160.00 1.01% 224,724.78 276,168.03 127,591.77 240,700.00 233,510.00 -7,190.00 -2.99% 235,730.00 2,220.00 0.95% Total Department: 36 - FORESTRY: 374,429.49 384,069.94 179,864.46 365,845.00 366,525.00 680.00 0.19% 371,955.00 5,430.00 1.48% 7/19/2019 12:41:57 PM Page 27 of 32 Budget Comparison Report 7/19/2019 3:18:37 PM Page 2 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Fund: 215 - RECYCLING Department: 54 - RECYCLING Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 21,683.04 19,785.00 0.00 22,100.00 25,840.00 3,740.00 16.92% 25,840.00 0.00 0.00% 4141-PERA 1,694.50 1,484.00 0.00 1,710.00 1,940.00 230.00 13.45% 1,940.00 0.00 0.00% 4142 - FICA 1,658.76 1,514.00 0.00 1,690.00 1,980.00 290.00 17.16% 1,980.00 0.00 0.00% 4144 -HEALTH INSURANCE 4,500.00 4,635.00 0.00 0.00 4,105.00 4,105.00 0.00% 4,105.00 0.00 0.00% 4148 - WORKERS COMP 399.96 399.96 79.98 160.00 170.00 10.00 6.25% 170.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 29,936.26 27,817.96 79.98 25,660.00 34,035.00 8,375.00 32.64% 34,035.00 0.00 0.00% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 512.94 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4210 - OP SUPPLY -OTHER 1,979.73 30,484.93 3,695.91 7,600.00 7,680.00 80.00 1.05% 7,750.00 70.00 0.91% Total Category: 4200 - COMMODITIES: 2,492.67 30,484.93 3,695.91 7,600.00 7,680.00 80.00 1.05% 7,750.00 70.00 0.91% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4305 - FEES FOR SERVICE 0.00 0.00 0.00 3,070.00 3,100.00 30.00 0.98% 3,130.00 30.00 0.97% 4311- POSTAGE 0.00 0.00 0.00 1,000.00 1,010.00 10.00 1.00% 1,020.00 10.00 0.99% 4341-ADVER/PUBLISH 0.00 0.00 0.00 1,000.00 1,010.00 10.00 1.00% 1,020.00 10.00 0.99% 4380 - RENTAL/LEASE 7,000.00 7,000.00 7,000.00 7,000.00 7,070.00 70.00 1.00% 7,140.00 70.00 0.99% 4401- DUES & SUBS 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 0.00 27.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4434 - SPECIAL EVENTS 3,525.00 4,080.00 0.00 8,460.00 8,540.00 80.00 0.95% 8,630.00 90.00 1.05% Total Category: 4300 - CONTRACTUAL SERVICES: 10,525.00 11,107.00 7,000.00 20,530.00 20,730.00 200.00 0.97% 20,940.00 210.00 1.01% Category: 4500 - CAPITAL OUTLAY 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Department: 54 - RECYCLING: 42,953.93 69,409.89 10,775.89 53,790.00 62,445.00 8,655.00 16.09% 62,725.00 280.00 0.45% Total Fund: 215 - RECYCLING: 42,953.93 69,409.89 10,775.89 53,790.00 62,445.00 8,655.00 16.09% 62,725.00 280.00 0.45% 7/19/2019 3:18:37 PM Page 2 of 38 Budget Comparison Report Object Fund: 230 - SURFACE WATER MANAGEMENT Department: 60 - STORM WATER -MAINTENANCE Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110- OVERTIME F. T. 4120 - SAL-P.T./TEMP 4141- PERA 4142 - FICA 4144 - HEALTH INSURANCE 4148- WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES 4210 - OP SUPPLY -OTHER 4211- MOTOR FUELS 4217 - CLOTHING/UNIFORM 4231- SMALL TOOLS 4271- OP SUP -OTHER IMP Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 4301- ENGINEERING SVS 4305 - FEES FOR SERVICE 4307 -WATERSHED DISTRICT STORM FEE 4310 -COMMUNICATION 4341- ADVER/PUBLISH 4371- MAINT-REPAIR/OTH 4375 - CHARGE -FLEET MNT 4380 - RENTAL/LEASE 4403 - TRAVEL/TRAIN/CON 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: Category: 4500 - CAPITAL OUTLAY 4530- MACH & EQUIPMENT 4550 -PROJECT -CONTRACT Total Category: 4500 - CAPITAL OUTLAY: Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison 5,515.00 Budget 7,866.21 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Through Jun 7,520.00 5,200.00 8,000.00 177,584.69 186,051.95 98,385.51 180,350.00 182,985.00 2,635.00 1.46% 188,500.00 5,515.00 3.01% 7,866.21 9,445.15 18,187.35 9,000.00 9,000.00 0.00 0.00% 10,000.00 1,000.00 11.11% 4,543.50 7,520.00 5,200.00 8,000.00 15,680.00 7,680.00 96.00% 16,000.00 320.00 2.04% 14,119.15 14,480.42 8,982.07 14,675.00 14,400.00 -275.00 -1.87% 14,850.00 450.00 3.13% 13,203.45 13,886.56 8,678.85 15,600.00 15,885.00 285.00 1.83% 16,400.00 515.00 3.24% 9,900.00 9,350.04 7,369.98 14,740.00 16,580.00 1,840.00 12.48% 17,100.00 520.00 3.14% 15,900.00 16,670.04 8,860.02 17,720.00 18,000.00 280.00 1.58% 18,000.00 0.00 0.00% 243,117.00 257,404.16 155,663.78 260,085.00 272,530.00 12,445.00 4.78% 280,850.00 8,320.00 3.05% 3,005.54 2,429.50 2,002,09 1,200.00 4,000.00 2,800.00 233.33% 5,000.00 1,000.00 25.00% 2,508.56 2,393.89 884.96 2,500.00 2,500.00 0.00 0.00% 2,525.00 25.00 1.00% 0.00 1,089.58 0.00 1,200.00 1,210.00 10.00 0.83% 1,220.00 10.00 0.83% 260.44 79.80 31.46 600.00 610.00 10.00 1.67% 610.00 0.00 0.00% 3,940.32 103.46 1,169.96 20,400.00 8,000.00 -12,400.00 -60.78% 8,000.00 0.00 0.00% 9,714.86 6,096.23 4,088.47 25,900.00 16,320.00 -9,580.00 -36.99% 17,355.00 1,035.00 6.34% 2,950.00 5,605.40 792.04 6,300.00 6,360.00 60.00 0.95% 6,430.00 70.00 1.10% 21,798.66 39,342.97 10,219.00 51,000.00 51,510.00 510.00 1.00% 52,020.00 510.00 0.99% 18,815.95 9,565.31 13,408.40 10,000.00 13,500.00 3,500.00 35.00% 13,500.00 0.00 0.00% 0.00 0.00 0.00 3,400.00 0.00 -3,400.00 -100.00% 0.00 0.00 0.00% 534.42 420.12 210.06 1,200.00 1,210.00 10.00 0.83% 840.00 -370.00 -30.58% 146.00 146.00 0.00 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% 83,154.31 30,696.31 28,629.07 102,000.00 103,020.00 1,020.00 1.00% 104,040.00 1,020.00 0.99% 3,675.02 8,523.85 7,328.10 6,000.00 7,500.00 1,500.00 25.00% 6,120.00 -1,380.00 -18.40% 220.00 247.95 0.00 1,000.00 1,010.00 10.00 1.00% 1,020.00 10.00 0,99% 0.00 1,395.00 0.00 400.00 780.00 380.00 95.00% 800.00 20.00 2.56% 0.00 32.00 0.00 1,000.00 1,010.00 10.00 1,00% 1,020.00 10.00 0.99% 131,294.36 95,974.91 60,586.67 182,500.00 186,100.00 3,600.00 1.97% 185,990.00 -110.00 -0.06% 0.00 0.00 13,354.06 11,000.00 0.00 -11,000.00 -100.00% 0.00 0.00 0.00% 0.00 26,097.45 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 26,097.45 13,354.06 11,000.00 0.00 -11,000.00 -100.00% 0.00 0.00 0.00% 7/19/2019 3:18:37 PM Page 3 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 4 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Category: 4999 - TRANSFERS OUT 4700 -TRANSFERS OUT 258,371.03 41,300.04 20,650.02 41,300.00 41,300.00 0.00 0.00% 41,300.00 0.00 0.00% Total Category: 4999 - TRANSFERS OUT: 258,371.03 41,300.04 20,650.02 41,300.00 41,300.00 0.00 0.00% 41,300.00 0.00 0.00% Total Department: 60 - STORM WATER -MAINTENANCE: 642,497.25 426,872.79 254,343.00 520,785.00 516,250.00 -4,535.00 -0.87% 525,495.00 9,245.00 1.79% 7/19/2019 3:18:37 PM Page 4 of 38 Budget Comparison Report Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Department: 61- STORM WATER ADMINSITRATION Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 4,176.91 -110.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 312.84 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4142 - FICA 311.95 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4144 -HEALTH INSURANCE 1,200.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 6,001.70 -110.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 0.00 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 0.00 0.00 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 945.50 943.53 463.90 800.00 810.00 10.00 1.25% 820.00 10.00 1.23% 4305 - FEES FOR SERVICE 3,157.77 3,506.51 2,581.47 3,400.00 3,440.00 40.00 1.18% 3,470.00 30.00 0.87% 4309 - CREDIT CARD FEES 5,120.43 6,140.64 3,294.83 3,100.00 6,000.00 2,900.00 93.55% 6,000.00 0.00 0.00% 4311- POSTAGE 4,838.84 5,263.15 2,861.66 5,900.00 5,960.00 60.00 1.02% 6,020.00 60.00 1.01% 4321- DATA PROCESSING 25,245.55 30,812.04 16,919.00 22,260.00 24,280.00 2,020.00 9.07% 26,710.00 2,430.00 10.01% 4340 -PRINTING 4,487.85 4,552.50 2,127.34 4,500.00 4,550.00 50.00 1.11% 4,590.00 40.00 0.88% Total Category: 4300 - CONTRACTUAL SERVICES: 43,795.94 51,218.37 28,248.20 39,960.00 45,040.00 5,080.00 12.71% 47,610.00 2,570.00 5.71% Total Department: 61- STORM WATER ADMINSITRATION: 49,797.64 51,108.37 28,248.20 40,060.00 45,140.00 5,080.00 12.68% 47,710.00 2,570.00 5.69% Total Fund: 230 - SURFACE WATER MANAGEMENT: 692,294.89 477,981.16 282,591.20 560,845.00 561,390.00 545.00 0.10% 573,205.00 11,815.00 2.10% 7/19/2019 3:18:37 PM Page 5 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 20 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Department: 70 - WATER -DISTRIBUTION Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 377,426.95 427,915.03 198,701.63 415,600.00 441,485.00 25,885.00 6.23% 454,750.00 13,265.00 3.00% 4110 - OVERTIME F. T. 40,990.52 50,936.59 32,295.18 33,750.00 56,250.00 22,500.00 66.67% 57,950.00 1,700.00 3.02% 4120-SAL-P.T./TEMP 9,604.25 17,766.00 11,853.00 17,940.00 30,600.00 12,660.00 70.57% 30,600.00 0.00 0.00% 4140 - PENSIONS 45,013.00 22,626.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 30,606.35 33,777.89 18,036.49 34,825.00 37,330.00 2,505.00 7.19% 38,500.00 1,170.00 3.13% 4142- FICA 29,147.48 33,595.75 17,332.11 35,750.00 40,420.00 4,670.00 13.06% 41,650.00 1,230.00 3,04% 4144 -HEALTH INSURANCE 34,647.00 41,397.04 21,310.02 42,620.00 58,710.00 16,090.00 37.75% 60,480.00 1,770.00 3.01% 4148 - WORKERS COMP 13,700.04 15,080.04 9,730.02 19,460.00 19,520.00 60.00 0.31% 19,520.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 581,135.59 643,094.34 309,258.45 599,945.00 684,315.00 84,370.00 14.06% 703,450.00 19,135.00 2.80% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 0.00 211.05 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4210 -OP SUPPLY -OTHER 462,194.03 456,356.00 55,907.88 103,000.00 113,000.00 10,000.00 9.71% 114,100.00 1,100.00 0.97% 4211- MOTOR FUELS 13,995.78 16,826.87 6,914.83 22,000.00 17,000.00 -5,000.00 -22.73% 17,170.00 170.00 1.00% 4216-FERTILIZER/CHEM 12,740.15 3,937.90 5,207.12 25,500.00 18,000.00 -7,500.00 -29.41% 20,000.00 2,000.00 11.11% 4217-CLOTHING/UNIFORM 2,960.21 4,226.77 2,292.94 2,900.00 3,480.00 580.00 20.00% 3,480.00 0.00 0.00% 4231- SMALL TOOLS 617.43 1,820.30 229.87 1,500.00 1,520.00 20.00 1.33% 1,530.00 10.00 0.66% 4271- OP SUP -OTHER IMP 34,564.16 20,225.69 12,608.80 35,000.00 35,350.00 350.00 1.00% 35,700.00 350.00 0.99% 4272-OPSUP-BUILDINGS 483.68 0.00 0.00 14,100.00 14,240.00 140.00 0.99% 14,380.00 140.00 0.98% 4280 - CAPITAL OUTLAY <$5,000 0.00 0.00 2,068.73 7,100.00 7,170.00 70.00 0.99% 7,240.00 70.00 0.98% Total Category: 4200 - COMMODITIES: 527,555.44 503,393.53 85,441.22 211,100.00 209,760.00 -1,340.00 -0.63% 213,600.00 3,840.00 1.83% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 39,442.50 10,520.47 86,981.62 107,500.00 60,580.00 -46,920.00 -43.65% 34,650.00 -25,930.00 -42.80% 4301- ENGINEERING SVS 107,903.16 62,548.60 6,253.10 73,400.00 74,140.00 740.00 1.01% 74,870.00 730.00 0.98% 4302 - LEGAL SERVICE 1,087.50 0.00 0.00 1,600.00 1,620.00 20.00 1.25% 1,630.00 10.00 0.62% 4305 - FEES FOR SERVICE 30,894.65 58,778.10 5,010.97 36,000.00 44,110.00 8,110.00 22.53% 45,000.00 890.00 2.02% 4310 -COMMUNICATION 5,078.55 6,544.85 3,486.09 5,300.00 5,350.00 50.00 0.94% 6,345.00 995.00 18.60% 4311- POSTAGE 0.00 0.00 0.00 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 4340 - PRINTING 0.00 130.00 0.00 300.00 300.00 0.00 0.00% 310.00 10.00 3.33% 4341- ADVER/PUBLISH 1,112.63 319.26 69.70 500.00 510.00 10.00 2.00% 510.00 0.00 0.00% 4350 - INSURANCE CHARGE 8,000.04 8,000.04 4,000.02 8,000.00 8,080.00 80.00 1.00% 8,160.00 80.00 0.99% 4360 -UTILITIES 220,018.02 286,946.05 99,346.30 239,700.00 242,100.00 2,400.00 1.00% 244,500.00 2,400.00 0.99% 4370 - MAINT-REPAIR/EQ 0.00 4,741.00 1,335.00 0.00 4,500.00 4,500.00 0.00% 4,550.00 50.00 1.11% 4371-MAINT-REPAIR/OTH 68,596.30 113,259.60 23,341.76 162,800.00 160,000.00 -2,800.00 -1.72% 161,160.00 1,160.00 0.73% 4372-MAINT-REPAIR/BLD 9,544.95 12,477.78 357.75 7,200.00 7,270.00 70.00 0.97% 7,340.00 70.00 0.96% 4375 - CHARGE -FLEET MNT 27,551.80 34,969.76 11,622.02 20,000.00 30,000.00 10,000.00 50.00% 20,400.00 -9,600.00 -32.00% 4380 - RENTAL/LEASE 0.00 0.00 184.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4401- DUES & SUBS 1,911.00 2,029.00 4,021.00 2,400.00 2,420.00 20.00 0,83% 2,450.00 30.00 1.24% 7/19/2019 3:18:37 PM Page 20 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 21 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent 9 Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun 4403-TRAVEL/TRAIN/CON 3,492.63 8,495.84 6,380.15 5,700.00 5,760.00 60.00 1.05% 5,810.00 50.00 0.87% 4405 - CLEAN/WASTE REMV 1,528.30 2,817.84 587.46 1,200.00 1,200.00 0.00 0,00% 1,220.00 20.00 1.67% 4438 - PRO/MISC RESALE 0.00 0.00 0.00 56,200.00 56,760.00 560.00 1,00% 57,320.00 560.00 0.99% 4449 - OTHER CONTRACT 0.00 224.00 500.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 526,162.03 612,802.19 253,476.94 728,100.00 704,800.00 -23,300.00 -3.20% 676,325.00 -28,475.00 -4.04% Category: 4500 - CAPITAL OUTLAY 4530- MACH & EQUIPMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 153,000.00 56,500.00 -96,500.00 -63.07% 0.00 -56,500.00 -100.00% 4551 -PROJECT -ENGINEER 0.00 0.00 2,154.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 2,154.00 153,000.00 56,500.00 -96,500.00 -63.07% 0.00 -56,500.00 -100.00% Category: 4999 - TRANSFERS OUT 4700 -TRANSFERS OUT 251,622.65 171,800.04 93,000.00 186,000.00 186,000.00 0.00 0.00% 186,000.00 0.00 0.00% Total Category: 4999 - TRANSFERS OUT: 251,622.65 171,800.04 93,000.00 186,000.00 186,000.00 0.00 0.00% 186,000.00 0.00 0.00% Total Department: 70 - WATER -DISTRIBUTION: 1,886,475.71 1,931,090.10 743,330.61 1,878,145.00 1,841,375.00 -36,770.00 -1.969 1,779,375.00 -62,000.00 -3.37% 7/19/2019 3:18:37 PM Page 21 of 38 Budget Comparison Report Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 16udget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Department: 71- WATER -ADMINISTRATION Category: 4100 - PERSONAL SERVICES 4100-SALARY-FULLTIME 56,576.87 54,426.90 26,754,42 56,225.00 57,920,00 1,695.00 3.01% 59,660,00 1,740.00 3.00% 4110 - OVERTIME F. T. 0.00 270.27 0.00 0.00 0.00 0.00 0,00% 0.00 0.00 0.00% 4141-PERA 4,241.04 3,933.31 2,114.73 4,360.00 4,345.00 -15.00 -0.34% 4,475.00 130.00 2,99% 4142 - FICA 4,247.46 3,822.92 1,944.78 4,300.00 4,430.00 130.00 3.02% 4,600.00 170.00 3,84% 4144 - HEALTH INSURANCE 8,365,00 7,790,04 3,685.02 7,370,00 13,060.00 5,690,00 77.20% 13,060.00 0.00 0.00% 4148 - WORKERS COMP 350,04 369.96 202,50 405.00 400.00 -5,00 -1.23% 400.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 73,780.41 70,613.40 34,701.45 72,660.00 80,155.00 7,495.00 10.32% 82,195.00 2,040.00 2.55% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 41.68 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% 4210 - OP SUPPLY -OTHER 0.00 0.00 0.00 200.00 0.00 -200.00 -100.00% 0.00 0,00 0.00% Total Category: 4200 - COMMODITIES: 0.00 41.68 0.00 300.00 0,00 -300.00 -100.00% 0.00 0.00 0.00% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 25,089.35 943.57 463.93 10,000.00 10,100.00 100.00 1.00% 10,200.00 100.00 0,99% 4305 - FEES FOR SERVICE 15,502.98 18,463.95 10,665,95 18,400.00 18,590.00 190.00 1.03% 18,770,00 180.00 0.97% 4309 - CREDIT CARD FEES 5,120.44 6,140.68 3,294,85 5,300.00 5,350.00 50.00 0.94% 5,410.00 60.00 1.12% 4311- POSTAGE 18,329.96 20,073.00 9,856.00 22,100.00 22,320.00 220.00 1.00% 22,540,00 220.00 0.99% 4321- DATA PROCESSING 87,890.18 122,565.96 64,868.00 83,400.00 96,330.00 12,930.00 15.50% 105,965.00 9,635.00 10.00% 4340 -PRINTING 16,758.00 15,504.00 9,880.00 17,300.00 17,470.00 170.00 0.98% 17,640.00 170.00 0.97% 4370 - MAINT-REPAIR/EQ 0.00 0.00 0.00 500.00 0.00 -500.00 -100.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 0.00 15.00 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 168,690.91 183,706.16 99,028.73 157,100.00 170,160.00 13,060.00 8.31% 180,525,00 10,365.00 6.09% Total Department: 71- WATER -ADMINISTRATION: 242,471.32 254,361.24 133,730.18 230,060.00 250,315.00 20,255.00 8.80% 262,720,00 12,405.00 4.96% Total Fund: 610 - WATER OPERATING: 3,042,738.13 3,142,874.14 877,060.79 2,108,205.00 2,091,690.00 -16,515,00 -0.78% 2,042,095.00 -49,595.00 -2.37% 7/19/2019 3:18:37 PM Page 22 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 24 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Department: 80 - SEWER -DISTRIBUTION Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 68,292.10 86,585.48 31,440.20 151,600.00 115,110.00 -36,490.00 -24,07% 118,600.00 3,490.00 3.03% 4110 -OVERTIME F. T. 4,080.86 2,339.29 817.54 3,150.00 3,280.00 130.00 4.13% 3,300.00 20.00 0.61% 4120-SAL-P.T./TEMP 0.00 0.00 0.00 2,600.00 0.00 -2,600.00 -100.00% 0.00 0.00 0.00% 4140 - PENSIONS -5,787.00 24,460.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 5,339.62 6,558.24 2,560.95 11,995.00 8,880.00 -3,115.00 -25.97% 9,150.00 270.00 3.04% 4142 - FICA 4,989.49 6,236.29 2,403.38 12,040.00 9,290.00 -2,750.00 -22.84% 9,600.00 310.00 3.34% 4144 -HEALTH INSURANCE 12,534.96 14,583.04 6,570.00 13,140.00 10,780.00 -2,360.00 -17.96% 11,100.00 320.00 2.97% 4147 -UNEMPLOYMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 6,560.00 6,560.00 0.00% 4148 - WORKERS COMP 5,300.04 5,820.00 3,484.98 6,970.00 6,560.00 -410.00 -5.88% 0.00 -6,560.00 -100.00% Total Category: 4100 - PERSONAL SERVICES: 94,750.07 146,582.34 47,277.05 201,495.00 153,900.00 -47,595.00 -23.62% 158,310.00 4,410.00 2.87% Category: 4200 - COMMODITIES 4210 - OP SUPPLY -OTHER 3,158.53 13,285.58 116.96 3,440.00 3,470.00 30.00 0,87% 3,510.00 40.00 1.15% 4211- MOTOR FUELS 3,484.20 3,515.76 864.75 5,000.00 3,600.00 -1,400.00 -28.00% 3,640.00 40.00 1.11% 4216-FERTILIZER/CHEM 4,995.00 0.00 0.00 3,200.00 3,230.00 30.00 0.94% 3,270.00 40.00 1.24% 4217-CLOTHING/UNIFORM 0.00 229.90 0.00 1,000.00 1,160.00 160.00 16.00% 1,160.00 0.00 0.00% 4231 -SMALL TOOLS 0.00 499.00 0.00 700.00 710.00 10.00 1.43% 710.00 0.00 0.00% 4271 -OP SUP -OTHER IMP 5,194.51 0.00 762.11 2,500.00 2,530.00 30.00 1.20% 2,550.00 20.00 0.79% Total Category: 4200 - COMMODITIES: 16,832.24 17,530.24 1,743.82 15,840.00 14,700.00 -1,140.00 -7.20% 14,840.00 140.00 0.95% Category: 4300 - CONTRACTUAL SERVICES 4300- PROF SERVICES 9,241.50 12,386.35 11,193.54 11,000.00 11,110.00 110.00 1.00% 11,220.00 110.00 0.99% 4301- ENGINEERING SVS 44,559.41 18,310.76 8,310.25 25,000.00 25,250.00 250.00 1.00% 25,500.00 250.00 0.99% 4305 - FEES FOR SERVICE 162.00 162.00 2,287.60 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4310 -COMMUNICATION 420.12 420.12 210.06 500.00 510.00 10.00 2.00% 420.00 -90.00 -17.65% 4341-ADVER/PUBLISH 332.04 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4350- INSURANCE CHARGE 17,000.04 17,000.04 8,500.02 17,000,00 17,000.00 0.00 0.00% 17,000.00 0.00 0.00% 4360 -UTILITIES 1,610.79 2,307.72 720.97 2,200.00 2,220.00 20.00 0.91% 2,240.00 20.00 0.90% 4363 - MWCC SERVICE 1,845,641.28 1,814,217.48 953,829.42 1,907,700.00 2,020,595.00 112,895.00 5.92% 2,040,800.00 20,205.00 1.00% 4370 - MAINT-REPAIR/EQ 0.00 0.00 500.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4371-MAINT-REPAIR/OTH 140,294.91 86,283.97 131,671.71 183,600.00 185,440.00 1,840.00 1.00% 187,270.00 1,830.00 0.99% 4375 - CHARGE -FLEET MNT 8,423.99 9,060.59 977.52 12,000.00 12,000.00 0.00 0.00% 12,000.00 0.00 0.00% 4380 - RENTAL/LEASE 0.00 0.00 0.00 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 4401- DUES & SUBS 0.00 0.00 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 1,420.00 0.00 1,560.00 4,600.00 4,650.00 50.00 1.09% 4,690.00 40.00 0.86% 4449 - OTHER CONTRACT 0.00 32.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 2,069,106.08 1,960,181.03 1,119,761.09 2,164,000.00 2,278,875.00 114,875.00 5.31% 2,301,240.00 22,365.00 0.98% 7/19/2019 3:18:37 PM Page 24 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 25 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0.00 0.00 0.00 87,000.00 87,000.00 0.00 0.00% 0.00 -87,000.00 -100.00% 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 178,500.00 180,000.00 1,500.00 0.84% 180,000,00 0.00 0,00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 0.00 265,500,00 267,000.00 1,500.00 0.56% 180,000.00 -87,000.00 -32.58% Total Department: 80 - SEWER -DISTRIBUTION: 2,180,688.39 2,124,293.61 1,168,781.96 2,646,835.00 2,714,475.00 67,640.00 2.56% 2,654,390.00 -60,085.00 -2.21% 7/19/2019 3:18:37 PM Page 25 of 38 Budget Comparison Report Object Department: 81- SEWER -ADMINISTRATION Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110 -OVERTIME F.T. 4141-PERA 4142 - FICA 4144 - HEALTH INSURANCE 4148 - WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES 4200- OFFICE SUPPLIES 4210 -OP SUPPLY -OTHER Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 4305 - FEES FOR SERVICE 4309 - CREDIT CARD FEES 4311 -POSTAGE 4321- DATA PROCESSING 4340 - PRINTING 4370 - MAINT-REPAIR/EQ 4403 - TRAVEL/TRAIN/CON Total Category: 4300 - CONTRACTUAL SERVICES: Total Department: 81- SEWER -ADMINISTRATION: Total Fund: 620 - SEWER OPERATING: Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % 1,740.00 Budget 0.00 1 Bud et 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Through Jun 3,932.76 2,114.43 4,360.00 56,576.93 54,426.78 26,754.39 56,225.00 57,920.00 1,695.00 3.01% 59,660.00 1,740.00 3,00% 0.00 270.27 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4,240.92 3,932.76 2,114.43 4,360.00 4,345.00 -15.00 -0.34% 4,475.00 130.00 2.99% 4,247.33 3,821.87 1,944.23 4,300.00 4,430.00 130.00 3.02% 4,600.00 170.00 3.84% 8,364.00 7,790.04 3,685.02 7,370.00 13,060.00 5,690.00 77.20% 13,450.00 390.00 2.99% 350.04 369.96 202.50 405.00 400.00 -5.00 -1.23% 400.00 0.00 0,00% 73,779.22 70,611.68 34,700.57 72,660.00 80,155.00 7,495.00 10.32% 82,585.00 2,430.00 3.03% 0.00 41.67 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% 0.00 0.00 0.00 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 0.00 41.67 0.00 300.00 0.00 -300.00 -100.00% 0.00 0.00 0.00% 24,001.81 943.57 463.93 9,400.00 9,490.00 90.00 0.96% 9,590.00 100.00 1.05% 12,638.00 14,100.00 8,950.00 13,200.00 13,330.00 130.00 0.98% 13,460.00 130.00 0.98% 5,120.44 6,140.68 3,294.85 5,200.00 5,250.00 50.00 0.96% 5,300.00 50.00 0.95% 18,329.96 20,073.00 9,856.00 22,100.00 22,320,00 220.00 1.00% 22,540.00 220.00 0.99% 87,890.18 111,216.00 60,318.02 74,300.00 83,350.00 9,050.00 12.18% 75,790.00 -7,560.00 -9.07% 17,957.00 18,152.00 9,880.00 17,300.00 17,470.00 170.00 0.98% 17,650.00 180.00 1.03% 0.00 0.00 0.00 500.00 0.00 -500.00 -100.00% 0.00 0.00 0,00% 0.00 0.00 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% 165,937.39 170,625.25 92,762.80 142,100.00 151,210.00 9,110.00 6.41% 144,330.00 -6,880.00 -4.55% 239,716.61 241,278.60 127,463.37 215,060.00 231,365.00 16,305.00 7.58% 226,915.00 -4,450.00 -1.92% 3,382,140.93 3,059,074.32 1,392,545.33 3,054,495.00 3,138,440.00 83,945.00 2.75% 3,073,905.00 -64,535.00 -2.06% 7/19/2019 3:18:37 PM Page 26 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 27 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent /o Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Fund: 630 - STREET LIGHTS Department: 00 - UNDEFINED Category: 4720 - DEPRECIATION 4721- DEPRECIATION -PURCHASED 167,999.57 180,228.64 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 167,999.57 180,228.64 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4999 -TRANSFERS OUT 4700 - TRANSFERS OUT 130,962.27 47,220.00 24,325.02 48,650.00 48,650.00 0.00 0.00% 48,650.00 0.00 0,00% Total Category: 4999 - TRANSFERS OUT: 130,962.27 47,220.00 24,325.02 48,650.00 48,650.00 0.00 0.00% 48,650.00 0.00 0.00% Total Department: 00 - UNDEFINED: 298,961.84 227,448.64 24,325.02 48,650.00 48,650.00 0.00 0.00% 48,650.00 0.00 0.00% 7/19/2019 3:18:37 PM Page 27 of 38 Budget Comparison Report Object Department: 75 - STREET LIGHTS Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110- OVERTIME F. T. 4120 - SAL-P.T/TEMP 4140 - PENSIONS 4141-PERA 4142 - FICA 4144 -HEALTH INSURANCE 4148 - WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES Comparison 1 Comparison 1 Comparison 2 Comparison 2 4210 -OP SUPPLY -OTHER 10,795.21 Parent Budget Budget to Parent % Budget to Comparison % 110.00 0.99% 4211- MOTOR FUELS 3,256.58 4,070.27 Budget 6,000.00 4,200.00 1 Budget -3000% 2017 2018 2019 2019 2020 Increase / 419.99 2021 Increase / -20.00 Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 804.93 2021 fall 2019 (Decrease) 810.00 10.00 1.25% Through Jun 10.00 1.23% 4270 - OP SUP-VEH/EQ 280.81 0.00 301.94 200.00 63,131.31 53,597.48 28,548.03 88,060.00 54,140.00 -33,920.00 -38.52% 55,750.00 1,610.00 2,97% 5,510.19 3,605.70 935.72 3,600.00 3,055.00 -545.00 -15.14% 3,150.00 95.00 3,11% 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 11,257.00 -16,419.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 5,270.16 4,237.67 2,328.16 7,100.00 4,290.00 -2,810.00 -39.58% 2,900.00 -1,390.00 -32.40% 4,814.57 3,589.29 1,916.32 7,110.00 4,375.00 -2,735.00 -38.47% 45,000.00 40,625.00 928.57% 8,376.00 9,220.04 5,160.00 10,320.00 7,645.00 -2,675.00 -25.92% 7,900.00 255.00 3.34% 5,700.00 6,050.04 4,320.00 8,640.00 8,260.00 -380.00 -4.40% 8,260.00 0.00 0.00% 104,059.23 63,881.22 43,208.23 124,830.00 81,765.00 -43,065.00 -34.50% 122,960.00 41,195.00 50.38% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 10,795.21 15,926.48 16,616.39 11,000.00 11,110.00 110.00 1.00% 11,220.00 110.00 0.99% 4211- MOTOR FUELS 3,256.58 4,070.27 2,277.37 6,000.00 4,200.00 -1,800.00 -3000% 4,240.00 40.00 0.95% 4217-CLOTHING/UNIFORM 524.96 584.86 419.99 600.00 580.00 -20.00 -3.33% 580.00 0.00 0.00% 4231 -SMALL TOOLS 320.76 804.93 315.22 800.00 810.00 10.00 1.25% 820.00 10.00 1.23% 4270 - OP SUP-VEH/EQ 280.81 0.00 301.94 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 4271- OP SUP -OTHER IMP 51,723.76 44,073.51 24,104.10 51,000.00 60,510.00 9,510.00 18.65% 52,020.00 -8,490.00 -14.03% 4280 - CAPITAL OUTLAY <$5,000 34,762.02 0.00 1,750.80 3,700.00 3,740.00 40.00 1.08% 3,770.00 30.00 0.80% Total Category: 4200 - COMMODITIES: 101,664.10 65,460.05 45,785.81 73,300.00 80,950.00 7,650.00 10.44% 72,650.00 -8,300.00 -10.25% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 945.50 943.51 692.40 1,500.00 1,520.00 20.00 1.33% 1,530.00 10.00 0.66% 4301- ENGINEERING SVS 8,382.25 42,179.45 3,223.00 5,100.00 5,200.00 100.00 1.96% 5,200.00 0.00 0.00% 4305 - FEES FOR SERVICE 19,676.81 10,919.79 10,708.74 17,300.00 17,473.00 173.00 1.00% 17,646.00 173.00 0.99% 4309 - CREDIT CARD FEES 5,120.39 6,140.61 3,294.82 3,500.00 6,300.00 2,800.00 80.00% 6,300.00 0.00 0.00% 4310 -COMMUNICATION 1,320.21 1,267.71 210.06 900.00 910.00 10.00 1.11% 920.00 10.00 1.10% 4311 -POSTAGE 4,880.00 5,010.00 2,464.00 5,200.00 5,250.00 50.00 0.96% 5,300.00 50.00 0.95% 4321- DATA PROCESSING 21,762.13 28,607.43 15,690.87 19,800.00 21,760.00 1,960.00 9.90% 23,935.00 2,175.00 10.00% 4340 -PRINTING 4,191.00 4,214.00 2,124.00 4,300.00 4,340.00 40.00 0.93% 4,390.00 50.00 1.15% 4341-ADVER/PUBLISH 183.23 0.00 219.56 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4350 - INSURANCE CHARGE 8,000.04 8,000.04 4,000.02 8,000,00 8,080.00 80.00 1.00% 8,160.00 80.00 0.99% 4360 -UTILITIES 152,672.79 146,547.64 49,471.01 177,000.00 155,590.00 -21,410.00 -12.10% 156,870.00 1,280.00 0.82% 4361- NSP STREET LIGHT 69,634.40 79,271.55 31,818.32 95,700.00 83,000.00 -12,700.00 -13.27% 84,000.00 1,000.00 1.20% 4370 - MAINT-REPAIR/EQ 0.00 0.00 0.00 300.00 0.00 -300.00 -100.00% 0.00 0.00 0.00% 4371-MAINT-REPAIR/OTH 127,298.53 185,352.85 120,813.35 160,100.00 161,700.00 1,600.00 1.00% 163,300.00 1,600.00 0.99% 4375- CHARGE -FLEET MNT 4,694.51 4,663.90 4,147.52 8,600.00 8,690.00 90.00 1.05% 8,770.00 80.00 0.92% 4401- DUES & SUBS 53.00 10.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 346.67 1,027.40 0.00 900.00 1,000.00 100.00 11.11% 1,000.00 0.00 0.00% 4438 - PRO/MISC RESALE 69,760.00 154,521.89 149,505.00 150,000.00 151,500.00 1,500.00 1.00% 153,000.00 1,500.00 0.99% 7/19/2019 3:18:37 PM Page 28 of 38 Budget Comparison Report Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 0.00 0.00 Comparison 1 Comparison 1 716,386.79 Comparison 2 Comparison 2 856,330.00 795,028.00 Total Fund: 630 - STREET LIGHTS: 1,015,348.63 1,035,483.68 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun 4449 - OTHER CONTRACT 11,742.00 16.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0,00% Total Category: 4300 - CONTRACTUAL SERVICES: 510,663.46 678,693.77 398,382.67 658,200.00 632,313.00 -25,887.00 -3.93% 640,321.00 8,008.00 1.27% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 0.00 0.00 0.00 Total Department: 75 - STREET LIGHTS: 716,386.79 808,035.04 487,376.71 856,330.00 795,028.00 Total Fund: 630 - STREET LIGHTS: 1,015,348.63 1,035,483.68 511,701.73 904,980.00 843,678.00 0.00 0.00% 0.00 0.00 0.00% -61,302.00 -7.16% 835,931.00 40,903.00 5.14% -61,302.00 -6.77% 884,581.00 40,903.00 4.85% 7/19/2019 3:18:37 PM Page 29 of 38 Budget Comparison Report Object Fund: 710 - FLEET MAINTENANCE Department: 33 - AUTO SERVICE Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110 - OVERTIME F. T. 4120 - SAL-P.T./TEMP 4140 - PENSIONS 4141-PERA 4142 - FICA 4144 -HEALTH INSURANCE 4148 - WORKERS COMP Total Category: 4100 - PERSONAL SERVICES Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % 8,730.00 Budget 12,464.94 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Through Jun 0.00 0.00 0.00 255,999.66 262,436.65 117,732.86 273,060.00 288,870.00 15,810.00 5.79% 297,600.00 8,730.00 3,02% 12,464.94 27,139.91 18,841.12 17,820.00 17,820.00 0.00 0.00% 17,820.00 0.00 0.00% 55.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 12,069.00 -8,935.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 20,329.79 21,232.20 10,719.42 22,545.00 23,000.00 455.00 2.02% 23,700.00 700.00 3.04% 18,786.02 20,659.66 10,088.70 22,250.00 23,460.00 1,210.00 5.44% 24,200.00 740.00 3.15% 31,668.04 37,197.04 14,740.02 29,480.00 30,585.00 1,105.00 3.75% 31,500.00 915.00 2,99% 11,199.96 11,600.04 5,305.02 10,610.00 11,000.00 390.00 3.68% 11,000.00 0.00 0.00% 362,572.41 371,330.50 177,427.14 375,765.00 394,735.00 18,970.00 5.05% 405,820.00 11,085.00 2.81% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 4,645.93 2,903.43 2,068.99 9,100.00 9,190.00 90.00 0.99% 7,000.00 -2,190.00 -23.83% 4211- MOTOR FUELS 241,188.30 298,607.51 144,136.03 371,100.00 374,810.00 3,710.00 1.00% 310,000.00 -64,810.00 -17.29% 4212 - LUB/ADD 18,726.39 12,064.70 1,074.50 16,500.00 16,665.00 165.00 1.00% 16,830.00 165.00 0.99% 4217 - CLOTHING/UNIFORM 1,466.74 3,463.56 1,531.78 4,500.00 4,545.00 45.00 1.00% 4,590.00 45.00 0.99% 4231- SMALL TOOLS 2,073.12 4,584.10 3,437.27 5,100.00 5,150.00 50.00 0.98% 5,200.00 50.00 0.97% 4270 - OP SUP-VEH/EQ 248,014.10 295,623.78 115,972.20 245,000.00 247,450.00 2,450.00 1.00% 249,900.00 2,450.00 0.99% 4271- OP SUP -OTHER IMP 380.99 457.37 1,445.32 500.00 505.00 5.00 1.00% 510.00 5.00 0.99% 4272 - OP SUP -BUILDINGS 536.13 90.00 0.00 500.00 0.00 -500.00 -100.00% 0.00 0.00 0.00% 4280 - CAPITAL OUTLAY <$5,000 3,541.62 17,233.46 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 520,573.32 635,027.91 269,666.09 652,300.00 658,315.00 6,015.00 0.92% 594,030.00 -64,285.00 -9.77% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 708.40 609.42 2,178.52 2,600.00 2,620.00 20.00 0.77% 2,650.00 30.00 1.15% 4305 - FEES FOR SERVICE 2,732.35 9,600.78 1,718.88 5,900.00 5,960.00 60.00 1.02% 6,020.00 60.00 1.01% 4310 -COMMUNICATION 2,020.99 2,098.46 1,141.59 2,000.00 2,020.00 20.00 1.00% 2,040.00 20.00 0.99% 4321- DATA PROCESSING 20,825.09 20,605.00 12,134.00 18,900.00 20,620.00 1,720.00 9.10% 22,680.00 2,060.00 9.99% 4341-ADVER/PUBLISH 59.00 334.45 155.00 400.00 400.00 0.00 0.00% 410.00 10.00 2.50% 4350 - INSURANCE CHARGE 1,400.04 1,412.91 700.02 1,400.00 1,400.00 0.00 0.00% 1,400.00 0.00 0.00% 4370 - MAINT-REPAIR/EQ 68,864.96 57,956.33 108,909.41 73,700.00 77,140.00 3,440.00 4.67% 79,880.00 2,740.00 3.55% 4371-MAINT-REPAIR/OTH 4,009.77 373.50 1,542.44 4,000.00 1,000.00 -3,000.00 -75.00% 1,000.00 0.00 0.00% 4372-MAINT-REPAIR/BLD 1,102.67 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4401- DUES & SUBS 0.00 0.00 0.00 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 593.75 2,881.87 10.41 3,000.00 3,830.00 830.00 27.67% 3,060.00 -770.00 -20.10% 4445 - SALES TAX 5,133.37 6,505.08 3,923.52 6,000.00 6,060.00 60.00 1.00% 6,120.00 60.00 0.99% 4449 - OTHER CONTRACT 0.00 32.00 103.62 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 107,450.39 102,409.80 132,517.41 118,300.00 121,050.00 2,750.00 2.32% 125,260.00 4,210.00 3.48% 7/19/2019 3:18:37 PM Page 34 of 38 Budget Comparison Report 7/19/2019 3:18:37 PM Page 35 of 38 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison Budget 1 Budget 2017 2018 2019 2019 2020 Increase / 2021 Increase / Total Activity Total Activity YTD Activity 2019 2020 (Decrease) 2021 fall 2019 (Decrease) Object Through Jun Category: 4500 - CAPITAL OUTLAY 4520- FURN & OFF EQUIP 0.00 0.00 906.22 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4530- MACH & EQUIPMENT 0.00 0.00 0.00 24,000.00 0.00 -24,000.00 -100.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 906.22 24,000.00 0.00 -24,000.00 -100.00% 0.00 0.00 0.00% Category: 4720 - DEPRECIATION 4721 -DEPRECIATION -PURCHASED 36,639.52 42,833.44 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 36,639.52 42,833.44 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Department: 33 - AUTO SERVICE: 1,027,235.64 1,151,601.65 580,516.86 1,170,365.00 1,174,100.00 3,735.00 0.32% 1,125,110.00 -48,990.00 -4.17% Total Fund: 710 - FLEET MAINTENANCE: 1,027,235.64 1,151,601.65 580,516.86 1,170,365.00 1,174,100.00 3,735.00 0.32% 1,125,110.00 -48,990.00 -4.17% 7/19/2019 3:18:37 PM Page 35 of 38