Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Trustees of Osgood HIll
TOWN OF NORTH ANDOVER,MASSACHUSETTS OFFICE OF TOWN ACCOUNTANT 120 MAIN STREET, 01845 Lyne M Savage Telephone(978)688-9523 Finance Director Town Accountant email Isava (Rownoffiorthando.K MEMORANDUM To: Melissa Murphy Rodrigues, Town Manager From: Lyne M Savage, Finance Dhector own Accountant Subject*. Budget Status Reports—as of December 31, 2020 Date: January 20, 20�21 Enclosed please find the Budget Status Reports for Revenue and Expenses as of the end of the second quarter of Fiscal 2021 and the cash balance report as, of December 3,1, 202O�. If you have any comments or concerns, please do not hesitate to call. General Fund 0 Revenue. Property Tax Revenue: collections are at 47'.4 % year to date which Is in line with this same period last year which was 49.9%., • Motor Vehicle Excise Taxes-, collections through six months are running at 15.14% which is Lip slightly from,this same time last year. The majority of Motor Vehicle Excise taxes are billed in the month of February with the collection occurring in the months of March and April • Meals Tax: collections are running at 25%, which was anticipated due to the current environment due to the corona virus. • Ambulance Services: collections are at 58.15%year to date comp. tired to last year when collections were 56.56% of budget. Inspections Fees (Bldg. /Plum. /Elec.): collections are at 54,.751%which is up from this same time last year which was 44.99%. Interest Income: collections continue tracking below budget. Currently they are at I I A� 391.2%,of budget. Treasurer Collector continues to reinvest tunds into higher 0 0 11 interest-bearing accounts, so at this,point in the fiscal year I see no *issues witti bringing this %ofcollection up to meet budget. Local Receipts: when Motor Vehicle Excise Tax is factored out of Local Receipts revenue are tracking at 54.4%of budget. Although some revenues are still not reflecting any collections at this time in the fiscal year, for example Payment in Lieu and Cable Fees are collected in, March, as, this is normal- some revenues, are collected at, specific times within,the fiscal year and are not typically col,lected on a monthly basis,. At this,point in the fiscal year all revenues are tracking, and I expect we will meet budget. Expenses: All departmental budgets, factoring out the encumbrances are running at approximately 46.8% of target at this point m the fiscal year which is right on track,with what is expected for thin time of year. There are no areas of'concern currently. As more information becomes available, I will update you as needed. 0 .Enterprise AP Arp Funds.. Wtiter"Sewero. 0 Water revenue collections are at 5 5.5,1%,of bud het its expe nd'itures factoring out encumbrances it is running at 37.43% of budget. Sewer revenues collections are at 45.28,%, of'budget with expenditures factoring out encumbrances is running at 36.55% of budget. Based on normal operations this is not unusual for this time in the fiscal year and is 'in line with the same period last year. Stevens Estate, Stevens Estate collections are at 17.33%. compared to this same time last year the revenue collections were at 36.9,6%, a decrease of 19�.63%, or $104,066 and expenditures excluding encumbrances are running at 34.5 1% of budget. With the restrictions still, 'in place due to the COVID 19 crisis we will not meet the budgeted revenues for this year, which has been addressed when setting the tax rate December. I will continue monitor the activity eery closely an will report,back. I hope the above information is helpful, and if you have any question,or concems,please do not hesitate to contact me. \\ _ 01 2 Q 2 Q21 08:59 Town of North n v r P 90521sav lYTD BUDGE" REVENUES iglytdbud FOR 2021 06 ORIGINAL T NPRS REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 10 PROPERTY TAXES 1001 22 411012 Personal Pry _ .0 -728-88 .00 728.88 100.0% 10 10022 411013 Personal Proper .00 -28 . 8 286.78 100.0-06 10 10022 411014 Personal Pry er .8 .0 -2 ..75 20.75 100.0% 10010022 411019 Personal Proper .00 -25 .35 �00 256.35 1 0.0 10010022 411020 Personal Pry r .0 ,0 24,5 2.5 24,502.50 1 0. % 1122 41121 Personal P ` r -3,5411 599.63 -3 541F,599. 3 -1, 1 , 21. 8 -�, 3 , 78.55 45.5 Tax .00 .0 -3, 48.82 .00 3,648.82 100.0% 10010022 41201S Real Estate Tax ,8 .00 _80 -3,8 6.4 31806.40 100.. 1001 22 412018 Real Estate Tax .. 302.60 -302.60 1 . %* 10010022 412019 Real Estate Tax _ 173,895.88 .. -173,8 5..88 1 * 10 10022 412020 Real EstateTax -445, 2 . 445,026.06 100,8 Estate Tax -80t5861378.53 3 545 t 667.'70 -7 ,0401 710.83 -35,967,565. -41., 73,145.83 4 _ * 10010022 1420 Tax Title .0 -3 8, 1 ,23 308,716.23 ..t . 001002 TOTAL PROPERTY TAXES -8 ,58 ,3 8.53 4, 8. '7 -8 ,582,31 .4 -381 1 3,252.3 -42,38 , 58,1 47.4 g TOTAL REVENUES -8 ,58 ,3 8.53 4,0 8.07 -8 ,582,311.4 -38,1 3,252.36 -42,38 , 58.1t 15 MOTOR VEHICLE EXCISE 10010022 41SO06 MVX Taxes - 200 .00 -14.38 14.38 100.0% 10010022 415007 MVX Taxes - 200 .00 -28.75 .00 28.75 1 0. 10010022 41SO 8 MVX Taxes - 200 .00 .8 -28; 5 28.75 100.0% 10010022 415010 MVX Taxes - 201 . .00 .00 -17..5 .00 17.5 100.0% 1 1 22 415 �1 � e - 201 .00 .0 -35 .25 356.25 1 . % 10010022 415012 X Taxes 201 .0 -4 5.41 465.41 100.0% 10010022 415013 _ X Taxes - 201 -2 1.25 .00 271.25 100.0% 10010022 41SO14 MVX Taxes - 201 .00 -38 .25 .00 38 .25 10 . 10010022 415015 MVX Taxes 201 .8 -420.83 420.83 10 .. 10010022 415O 6 MVX Taxes - 201 .. -11425.21 .00 1,425.21 100.0% 10010022 415O17 MVX Taxes 201 .00 -1,85°7.52 1,85'7..52 100.0% /00/0022 415018 MVX Taxes 201 .0 .0 -81366.91 .00 8t366.91 100.0% 10010022 415 19 MVX Taxes 20 .00 .00 -34,412. 1 .00 34,412.. 1 100.0% 10 10022 415020 MVX Taxes - 202 .0 .0 -670,999.03 .00 670,999.03 100.0% 10010022 415021 MVX Taxes - 202 -4f8001000.00 -4180 , 0 . 3. -4,80 , 0Q. B * 10010022 4151 0 MVX Clear Fee .00 -7t6OO.00 .00 7, 8 . 100.0% TOTAL MOTOR VEHICLE EXCISE -4,8 ,O .00 -41 80 , .. -726, 5 .95 -4 1 0 73,34 . 5 15.1 TOTAL, REVENUES -4,800t000.00 .00 -4,800,000. -72 , 5 -95 -41 073,34 . 5 E ESP W -0-NIN \ \ \ \ \\\ \ 01/20/2021 08:59 Town of North Andover P 2 90521sav lYTD BUDGET REVENUES 1glytdbud FOR 2021 06 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 16 OTHER EXCISE AP PROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 16 OTHER EXCISE 10010022 418800 Mecals Tax -602,715.00 120,715.00 -482,000-00 -12 0 1 170.3 7 .00 -361,829-63 24.9%* 10010022 418900 Hotel Occupancy .00 -00 .00 -729.50 .00 729.50 100.0% TOTAL OTHER EXCISE -602,715.00 120,715.00 -482,000.00 �1201899.87 .00 -361,100.13 25.1-0o TOTAL REVENUES -602,715.00 120,71S.00 -482,000.00 -120,899-87 .00 -361,100.13 20 PENALITIES/INTEREST 1001002211) 414600 Tax rjTitle Redem .00 .00 .00 -18,059.10 .00 181OS9.10 100.0% 1001002-2 417100 Perri-Int On Prop -11S1400.00 .00 -11S1400.00 -222,057.50 .00 106,657-50 192.4% 10010022 4172DQ PerL`z int Qn Moto -28,000.00 .00 -28,000.00 -24,159*93 .00 -3,840.07 86.3%* fax -129,000.00 .00 -129,000-00 -1591224.34 .00 30,224.34 123.4% 10010022 417SOO OverZunder .00 .00 .00 63.S4 .00 -63-54 100.0%* 10010022 417600 Return check_ec Ac .00 .00 '00 21306.87 .00 -21306.87 100.0%* i-0010022 432100 Lien CeIrtificat -4S,000.00 .00 -45,000.00 -S7tS35.00 .00 12,535-00 127.9% 100100-12 478-3Q0 Treasures Deman -135,000-00 .00 -13S,000.00 -104t941.64 .00 -301OS8.36 77.7-0,* TOTAL PENALITIES/INTEREST -4S2,400.00 .00 -452,400.00 -S83,607.10 .00 131,207.10 129-0-0o TOTAL REVENUES -4S2,400.00 .00 g4S21400.00 -583r6O7.10 .00 1311207.10 21 PAYMENT IN LIEU 100100222 41B100 Da merit In Le -29,720.00 -10,000.00 -39t720.00 .00 .00 -39,720-00 0 10010022��l 200 Payment in Leui �86,280.00 86,280.00 .00 -43,140.00 .00 43,140.00 100.0% TOTAL PAYMENT IN LIEU -116,000-00 76,280.00 -39,720.00 -43,140.00 .00 31420.00 108.6% TOTAL REVENUES -116,000.00 76,280.00 -39f720.00 -43,140-00 .00 31420.00 2S REFUSE 10010075 424100 Host Community -11622,277.96 -20,000.00 -11642,277.96 -769 1 190.3 9 .00 -873,087.57 46.8-o* TOTAL REFUSE -11622,277.96 -20tOOO.00 -11642,277.96 -769,190*39 .00 -873,087.57 46.8% TOTAL REVENUES -11622t277*96 -20tOOO.00 -11642,277.96 -769,190.39 .00 -873tO87.S7 26 OTHER CHAGRES 01/20/2 21 08:59 Town of North Andover P 3 9452Isv lYTD BUDGET REVENUES iglytdbud FOR 2021 C ORIGINAL T FRS/ REVISED AVAILABLE PCT 26 OTHER CHAGRES APPR P ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED /00/0052 427100 Ambulance Se -97 , .0 -301 0 -1., ,0 . 0 -581,460.55 .00 - 1 ,S 5 1 * TOTAL OTHER CHAGRES -97 , - 0,0 .0 -11 , 0. -581,460.5 - 1 ,539..4S 58.1 TOTAL REVS -9 , .. -3 , -11 0 $ 0 -581,460.55 .00 -4181539.45 27 MEDICAID REIMBRSMENT 10010 6S 43E9OO Medici Re 1 .. .00 - , - 1 97,345- 1 100.0% TOTAL MEDICAID REIMERSMENT .00 .00 -9 ,3 5.91 .00 97,3 S. 1 100.0% TOTAL REVENUES 0 .00 - ,3 5.9 I 9 ,3 5- I 30 FEES 10010 07 433700 Cable Fees -311 -3110 . -3 1 10010014 468700 Sate Exterided -6,3 7 . 6,372.00 100.0% 10010031 4--3470Q Violation Fees -2,1 -2110 . 4 -1,6 O. 21, * 10010031 1800 Pass Fees -31, 00. -31,8 -0t1 -31.,8 * 1001003S 4322200 Conservation e - 1 . - -1 1. -31. . 3 .2 * 10010042 432300 Planning Board -30,000.00 .00 -3 , - -12,002.40 .00 -17,997.60 * 10010048 432000 Police Fee s -211 ®211 -1,006.00 .00 -1,094.00 47.9%* -8 , -21, 1, -830,500.00 -492,897. .00 -33 7,6 2. * 10010OS7 433400 Plumbing In $p cc -I I, 0 . -1 , -III, . -33,939.34 .00 -77fO6O.66 3 . * 10010057 43 500 Ell Ins -1 , 0 . -1 3, -72,409.91 -80, 9 -0 4 .3 * 10010061 433200 Sealer jj b - ,2 0 $0 -312 -4, 59-0 .00 859.00 126. 1001007 30400 Oil .00 -1. ..00 1..50 1 -0-0. 10010075 430700 Tin & A1um num 0 -76. .00 76.00 10 , 10010075 439100 Recyc Fee s -3 , - 3, . - ,15 .0 .00 -24,844.00 2 . * 'DOTAL FEES -112 ,2 -31,5 -1,27 ,'7 -6 21211.50 - 1 ,48 _ 51, TOTAL REVS -11 45,2 -31,5 .00 -1127 , -662,211.50 .00 -614,488.50 32 LIBRARY REVENUE 10010104 478200 Library ilne -2 5. 3 .00 255.83 100.0% 01/20/2021 08:59 Town of North Andover p 4 9521sav YTS GET REVENUES 1glytdbud FOR 2021 06 ORIGINAL T NFRS REVISED AVAILABLE PC' 32 LIBRARY REVENUE APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED TOTAL LIBRARY REVENUE . . . -25S.83 .00 25S.83 100.0% TOTAL REVENUES .00 -2 S. 3 .00 2SS.83 33 RECREATION REVENUE /00/0082 438800 BAthinqBeach, R -31, . -1 , . -41,000-00 8,209.00 . -49,209.00 - . * TOTAL RECREATION REV -31, . -1 , -41,000-00 8,209.00 . -49,2 9. -20.0-6 TOTAL REVENUES -31, .0 -1 , oo. -41,000400 81209.00 . -49,209.00 40 OTHER REVENUE 1 D10007 4371 Miser Dept Revere . .00 . -S 2. .00 582.50 100.0% 10010007 483400 Cell -lower Leas -12 , 12 , 0. -29,360.60 .00 -98t 639.40 22. * 10010018 417900 Misc Dept Revere . . - '7 . .00 575.00100.0% 10010022 437900 Misc Dept Revere . -1 0. .00 1 0 100.00-1 100/003/ 437900 Mist Dept Revere . . . -41 3 .17 .00 41430.17 100.0% 10010048 432 700 P l c 10% Ad -87,000.00 S,000.00 - 2,000. -1 ,430.S9 .00 -63, 69.41 22. * 32700 Firg 1Q min -S, . - , 0 . -S98.62 .0 - ,401.3 12.. * 10010OS2 437900 Mist DeDt Revere -111 .00 111 100.0% Y00100S2 445700 Fire Alarm Box -1 , .00 -1 , - , - ,550.00 44.S%* 10010066 43 200 Mist De t Revere . .0 - 6.1 .00 S6.16 100.0% TOTAL OTHER REVENUE -251,400.00 S,O . -2 6, . -81,990.43 . --16 4, 9-5 .3 TOTAL REVENUES -251,400.00 5,000.00 -2 6, . -81,990.43 . -1641409.S7 50 LICENSES AND PERMITS 10010031 4q6100 Burial Permits i41 0 - .00 a , . O -11 775.0 . -21625.00 . * 100100 1 4410 L guox-, Licenses -134,000.00 .00 -13 , . -121,7 . 0 . -12,300.00 90. * v y v y vv v vvv\ 01/20/2021 08-059 Town of North Andover P 5 90521sav IYTD BUGET REVENUES iglytdbud FOR 2021 0 ORIGINAL T FRS/ REVISED AVAILABLE PCT 50 LICENSES AND PERMITS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 1 -2, _ -21 a818 .00 850.00 128.8 1001 031 442100 Mist Licenses -101400.00 -1 ,4 -8, S . .0 -119 81.3 1001 Car -6t6OO.00 .00 -61 -81 4'7 . lt875.00 128.4 10010OS7 433800 Gas Pf=its -41, - 1, �28,11 - -20,890.00 49.0%* /00/0066 434g O Fiat. -�, .8 , � -1, � -8132 .8 11. /00/0086 432500 Health Dept Fee -49,000.00 S1000.00 -4 , -16,260.00 -2717 .. 3 . TOTAL LICENSES AND PERMITS -312tlSO.00 5, -8 ,15 - -211,737.15 0 -95,412.85 68.9% TOTAL REVENUES -812,15 . 5,000.00 -8 '7,1 -211,73 .1 -95,412.85 1 FINES AND FOR ITS, 10010048 '7800 Parking Fines -9,800.00 4,600.00 - ,2 -11 7 5.4 .. -8,4 4.6 83.8 100100411,18 478100 -ours Fines - 8,8 ,8 1. 0 -8 , -18,8S7.. .. -2 ,142. 8 4 � r Fin - 12 ,1 -211 n2,1 .0 TOTAL FINES AND FORFITS -57,800.00 11,500.00 -4 ,8 -2 , 1 .1 -2 ,68 .86 44.S% TOTAL REVENUES -57,800.00 11,500.00 -46,300.00 -2 ,613 1 .00 -25 686.86 60 INVESTMENT INCOME 1001 22 482000 Interest Income - 1 , - 8,71S. -659t7lS.00 -2S8, 88. S -4 1,12 . 5 89. TOTAL INVESTMENT INCOME -619, - 0,715. 0 - 5 ,71 . -258, 88. .00 -4 1,12 ..95 89� TOTAL REVENUES -6 9,0 a -4 ,715. 0 -6 ,71 . -2 8,S88. .00 -401,126.95 65 MISCELLANEOUS REVENU 10010075 42 300 Host C mun y -810,7 6. 8 -81 ,$7 .. 8 -162,862-52 .00 6148,384.16 52. TOTAL MISCELLANEOUS REVENU -31 ,74 .68 .00 -31 , 4 .68 -162,362.. 2 .00 -148 38 ..16 52.2% TOTAL REVENUES -31 ,746.68 -81 , 4 . 8 -1 2, 2.52 -1 8,384.1 70 MISC NON RECURRING 1 _ -7 78, 2 7. 8 .00 778,627.03 100.0% 011/20/2 21 0 : 9 Town of North Andover P 90521sav IYTD BUDGET REVENUES iglytdbud FOR 2021 ORIGINAL FRS/ REVISED AVAILABLE PC'T 70 MISC NON RECURRING APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 10010022 39 00 Miser Non Recurs . -3,6 5. .00 316 5.I I0 . TOTAL MISC NON RECURRING . . -7 2,232.I9 .00 782,232.19 100.0% TOTAL REVS . - 2,232.I 782,232.19 75 STATE AID 1 -72,SI6. 1,300.00 - ,2I6. -41764.00 . -6614S2.00 6. !Q010014 462100 School Cha tee -9,16 , 97. 0 - ,16 , 7.00 - ,S , 6. -4f58010S1.00 50.01, 10010014 462200 Charter S h Tu -17,I33. - S,I27.00 - 2,26 . 0 - ,I 2.0 . -43,068.00 17. I_ 014 466700 Veterans Benefi -I63,7 .00 -27, SS.00 -190,755.00 -84,269.. . -106,486.00 4 . 10010014 467100 Un r d Ge -2,I ,1 6. .0 -211 , 86- - , 8 ,O .. -11088,098.00 SO.0'-01* 10010014 467400 State Owned Lan -26I1951. 0 -61 I6. -2 ,767. 0 -I3 ,3 6. . -I38, II. 48. TOTAL STATE AID -I1, ., 3, -6 ,69 . -II,91 ,2 I.0 -51 , I5. . -61022,566.00 49.S% TOTAL REVENUES SI.I, I, -67,698.00 =II, ,2 I. - ,8 ,7 S. . -6,022,S66-00 80 TRANSFER/OTHER USES 10010004 497300 Transfer from S -15 ,17 .86 -I 4,I . 6 -I ,I7 . 10010004 497500 4 00 Transfer Fr -4 I .5 .2 .00 -49I,S I£2 -2 '7, . -245,77S.63 50.00-.* 10010004 497500 4SOO transfer r- -1, , 4 . I . - .,0 , 4 . -522,2 3. . - 22,2 73. 3 50.. TOTAL TRANSFER/OTHER USE - , 5 ,2 01. 6 0 -11759,201-06 , ;.14 ..0 '"" , S 1 .. 2 .. TOTAL REVENUES -I17 9,2 I. 6 . -1, 59,2 I. -7 ,0 9. .. -99I1I I. 2 GRAND TOTAL -10 ,S ,8 2.2 22,65 .0 -I ,S6S,2 2.I6 -49,9 21 9 .. .. - , 13, 09.0 END F REPORT - Generated by Lyre Savage \ \ \\ 01/20/2021 090-01 Town of North Andover 90521sdv 1YTD BUDGET EXPENSE 1glytdbud FOR 2021 06 ORIGINAL T FRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 1 General Government 114 Town Moderator 5 ; .00 850.00 500.00 .00 3 123 Town Manager 444, 3 7.8 .00 4441637.80 240,161.66 1951166.62 91309.52 "7. 131 Finance Committee 8 345. .00 455.00 43.1 0135 Town Accountant 236,618.92 .00 236,618.92 12 , 3 .88 104,176.78 3,909.26 98.3 o 1141 Assessors 3391949.81 339,949.81 163,1 3 162,823.55 131962.47 . 1 145 Treasurer / Collector 441,3 9.15 441,359.15 246,099.02 165,219.03 3 , 41 1 3. 151 Legal Services 182,854.81 182,854.81 61,23S.83 4 ,336-69 81,282-29 5S.5% 152 Human Resources 218,092.26 .00 218,092-26 101,611.28 90,779.24 25,701.74 161 Town Clerk 384,60S.21 384,E 5.21 189,76S.67 90,841.80 103,997.74 73. 171 Conservation 128,849.33 .00 12 , 49-33 66,718.81 5311 2. ,978 2 93.0 01'74 Community Development 275,775.05 7S,7 S. 5 97,312.1 71, 45-5 / 6, 17-32 61.3% 17 Planning 198,566.14 198,566.14 9411 1.33 85,866-50 18,538.31 9 .7 0176 Board Of Appeals 21, 2 . 21,72S.00 10,002.92 814 6. 2 3131S 36 84.7% TOTAL Genera. Government 21874,683.48 .00 21874,683.48 11 3, ,61 -3 1,068,414.48 406,658.63 S.9 2 Public Safety 0210 Police 5,417,13 8.4 0 .00 5,417,138.40 2t752,113.90 11825,760.95 839,263.S5 4, 0220 Fire 51880,387.30 .00 51 8 ,387-3 311 '7,S3 . 1, 2 ,219.4 89S,629-90 84.8% 0225 Public Safety Salary Rene 52,122. .00 .00 2,122. . 41 Inspectional Services 324,4 3,12 -00 3241453.12 163,173.03 139tO77.27 22t202-82 93.2% 0291 Emergency Management 34t974.41 341974.41 41 "7. 41 4 4.08 25t832-44 2 .1 TOTAL Public Safety 11,709,075.23 .00 11,709tO7S.23 610771422.82 31796,601.70 1,83S,OSO.7184.3-06 3 Education 1 System Wide 51712,827.23 814tO32.86 61526t860.09 ,764,376.S5 21 44,39 .25 818,085.29 87.5-0, 0002 Central Office 11287,716.00 69S,198.98 11 2, 14. 1, 4 . 3 826,684.14 264,482..11E 0010 High School 11, 4,3 -6S4,066.32 11,200,239468 416011467.24 61278,663.35 320,109.09 '7.1 11 Systemwide - High School 3,380.00 719SS.00 11,33S.00 101764.67 .00 570.33 0020 Middle h l , '7,3 .00 -96,113.05 81911,194.95 31687,438.69 51156,514.69 67,241.57 .2 21 Systemwide Middle School 4,2 5.00 23,84 .64 281133.64 26,898.68 11234.9 5�6-06 0030 All. Elementary 1 t 328 1 305.00 -339,586.87 988t718.13 422,62 .24 545t121.64 2 , 1-25 7. SO Atkinson 2,9071462.0 -100,950.26 218 ,5/1,74 1 1 108 t 679.49 1 1 609,4S7.00 88,375.2S 6. 01/20/202 09.01 Town of North Andover P 2 0521s v IYTD BUGET EXPENSE 1glytdbud, FOR 2021 0 ORIGINAL T_ FRS/ REVISED AVAILABLE PC PPRO ' ADJSTMTS BUDGET Y\D EXPENDED ENCUMBRANCES BUDGET USED 51 Systemwide Atkinson 21 ,000.00 7,630.00 51 7 .0 211 71 7 0060 Franklin 3,S18,629.00 92,551.37 3,611,180.37 1,486,388.31 2t0701089.86 54,702.20 61 Systemwide Franklin 11 4 . 1,500.00 2,948.00 21 76_ 0 71.5 0062 Early Childhood Center ,2 ,1 144,101.62 4,392,210.62 1,794,804.39 2,543,841.84 53,564*39 9 , 0070 Kittredge 2,270,290.00 -115,911. 3 2,lS4,378.57 890,181,281,230,419.56 33,777.73 1 Systemwide Kittridge 11500. 210 31 1,8 1,640.00 3.1 0080 Thomson , 51, 83. , 21 92,1 1. 1, 72, 7 . E 1,517,550.78 102,051.69 96.2% 1 Systemwide Thomson 11 43 . 1,500.00 21932.0021408.65 .00 523-3S 82.2% 0090 Sargent 31 8 ,4 -283,196.9S 31 S 2S . 1,492,32 10 21 2, .7 62,362..21 . 1 Systemwide Sargent 2,000.00 1,500.00 31500.001,37S. 2,12 3 . 0099 Out Of District 4,30811S1.36 -23 ,961. 2 4, 6 ,1 9.74 1,709,894.84 2,12 ,30 ..9 230,985.96 . TOTAL Education 52,9 1, 17.S . 0 52,991,817.S9 21,973,762.92 28t892,620.79 2,125, 3. _0 04 Public Works 0410 DPW Administration 550,689-00 , 263tSO6.04 21 , 7 . 9..1 7.. 0420 DPW Streets And Sidewalks 11 1,9 11 541,995.4610,006.77 472,188.74 ,79 . 7 .2 0423 DPW Snow Removal 1,000,000.00 11 ,0 i 144t295.32 200,051.44 655,653-24 0430 DPW Refuse And Recycling 11 1 , 0 . 11 1 ,9 586t597.02 5 , 1. 2 6 ,'7 1; 6 95.1 83 DPW Fleet Maintenance 4 7,7 71. 447t771.00 1411070.S8 231,913-63 74,786.79 8 4 2 DPW Structures And Grounds 384,400.00 .00 384,400.00 121t388.40 207,163.29 55,848.31 8 5. TOTAL Public Works 513 ,'75S. 5,33 ,7S5.40 1, 66,8 1 2,084,441.98 113 84,44 9.29 7 .1 05 Health & Human Services OS10 Health Department 261,603.07 261,603.07 143,438-08 117, 2.2 22-73 99.7% 41 Elder Services 292,1S9.54 .00 292tl59.S4 146f977.SO 118,639.99 26,S42. 5 90.90-1 542 Youth and Recreation Servi 401t729.40 .00 401,729.40 21S,141.00 141,974.68 44,613.72 88.9% 543 Veterans Services 42411S5.86 .00 424,155.8E 143,703. 43,976.5S 236f476.23 4.2 TOTAL Health & Human Services 1,3 79,647.87 .00 1,379,647.87 64912S9.66 422,033.48 308,354.73 Culture & Recreations 0610 Library 1115 , '7. 11156, 97. 618,899.38 440t942.43 971 S 3 91.6% TOTAL Culture & Recreations 11156,897. 1,156 t 897.84 618,899.38 440,942.43 97,056.03 91. \ \ 01 20/2021 09 01 Town. of North Andover 9052 IYTD BUDGET EXPENSE lvtdbud FOR 2021 46 ORIGINAL T NFRS REVISED AVAILABLE PCT 7 Support Services APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 7 Support Services 0136 A gin Support 137,517.3 .00 137,517.30 6S,747.04 5 , 11.25 15,759. 1 88 5 149 Auditing S0,000.00 .88 50,0 B.Q 45,000.00 5,53 .8 -S30-00 1 1.1% 155 Information Technology 1,393,971-38 .00 1,393,971.3 0 902,431.43 118,622..88 372,91 .99 73 o 495 Facilities 345,938.9 .00 34S,938.96 133,309.02 144,705.70 67,924.24 8 .4% TOTAL Support Services 11 927,427.5 .00 1,927,427-S6 1,146,487.49 324,869.83 4S6,070.24 7 6. 8 Debt Services 0710 Principal Long Term 415741382 43 41 S74,382.43 697,SOO.00 .00 31876,882..43 15.E 751 Interest Lang Term 1,146,002.88 11 146,002.88 59 ,1 8. 5 555,834.83 51. TOTAL Debt Services 5,72 0,385.31 .00 51720,385,31 1,287, 8 O5 .00 4,432,717.2 22.. 89 Employee Benefits 911 County Retirement 5,8 1,8 2. .00 5,861,862.00 518 1,8 2. ,88 .00 1 8. 912 Workers Compensation. 29 ,38 . .00 290,386.00 322,621.00 -32,235-00 111.1 913 Unemployment 90, 0 . 90,000.00 87,0 2.67 2,997-33 .00 1 0.. % 914 Group Insurance 1 ,732,95 488 4 00 1 17 2,95 .88 5,347,283.43 918,982.69 4146 ,684.7 58.46 915 Medicare Expense 885,605.00 ..00 885,605.00 477, 50.5 4 8,554.58 5 .9 0916 Employee Beneftis 32,000.00 .00 32,000.00 32fOOO.00 .00 .00 100.0% 0946 Pollee/Fare Aeeidenti l In 2 8, 15. 268,015.00 134,128.68 29, 44.92 184,241.40 1.10 TOTAL Employee Benefits 18,1 ,818*88 .00 18,1 0,818.88 12,2 1,948.28 951,624..94 4t947,24S.66 72.8 10 Liability Insurance 945 Liability Insurance 3 1,373. 361,373.00 3 9,794.0 .00 -81421.0 1 2.3 TOTAL Liability Insurance 361,373.00 361,373.00 3 9,794,8 ..00 -81421.00 1 2.3 11 Capital and Reserves we W 01/20 `2021 09:01 Town of North Andover P 4 90521sav IYTD BUDGET EXPENSE 1glytdbud FOR 2021 0 ORIGINAL `FRS/ REVISED AVAILABLE PCB' 11 Capital and Reserves AFF OF ADJSTMTS BUDGE` YTD EXPENDED ENCUMBRANCES BUDGET USED 0000 Undesignated 68t926.00 - 8, 2 .00 .00 .00 .00 .00 0131 Finance Committee 1,5 , 5- .00 1,5 , 5.3 .00 .00 lt566,69S.38 .0% 0990 Transfers S,770,310.00 568,926.00 ,3 ,2 6.00 6 1 270 13 10.00 .00 68,926.00 98, 0991 Salary Reserves 350r63S.27 .00 350,635.27 .00 .00 350,635.27 .0 TOTAL Capital and Reserves 7,75 ,5 6- 5 500,000.00 8t256,566.6S 1270, 10-00 .00 11 986,25 .65 75. 12 State Assessments 0820 State Assessments S891691.00 54,004.00 643,695.00 302,937.00 .00 340,758.00 47. TOTAL State Assessments 589,691.00 54,004.00 643,695.00 302,937.00 .00 340,758.00 47.E 13 Regional Assessments 0947 Regional School Assessment 70 ,022.40 .00 70 ,022.40 601,041.00 242,221.40 -140,240 00 1.1 . TOTAL Regional Assessments 70 ,022.40 .00 70 ,022.40 601,041 00 242,221.40 -1401240.00 11 . GRAND TOTAL 110,667,1 2.21 554,004.00 111,221,1 6.21 54,826t005E10 38,223t771.03 1 ,171,3 0.0 .7 END OF REPORT - Generated. by Lyn Lyne Savage Ay v \ \ v,yv yyyA\\yy yy,Av y 01/20/2021 09:00 Town of North Andover P 2 90521sav IYTD BUDGET REVENUES 1glytdbud FOR 2021 0 ACCOUNTS FOR ORIGINAL T RS/ REVISED AVAILABLE PC' 6501 Water Operating APPR P ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 1 INTEREST/PENALTIES 6S 10004 421200 Int On OyerduQ -21,336.91 s -21,336,91 -9,S81.18 .00 -11,7SS.73 44. 02 USER CHARGES 65010004 421100 Water User Char - , 42,8 .3 -4, 4 , .36 2199 , 7.3 -1, 44, . 2 61. E 3 140 KUP 6SO10004 434000 Water Hook U -76,316.25 - 6,316.2 - ,2 -69,066.25 9.5 4 OTHER. FEES 6SO10004 417419 Water Lien Int -2.OS 2.05 100.0% 6 01 0 4 � Lien IntAdded .00 -1, 27, .00 1,427.56 100.0% 65010004 4 2235 0 ate � �� .0 -10, .5 .00 10,836.54 1 � 6SO1000 4223521 Water Liens - 2 -6 7°7,1 1.6 7 .00 -6 7,1 1.67 -884.69 .00 - 7 ,216;9 .1 65010004 441319 Mist Water Lien -3- 1 3.91 1 t . 650100 441320 Mist Water Lien .0 -1,48 ..1 1,484.15 100.0% 65010004 441321 Mist Water j n .00 -1 6. 9 106.49 1 . 5010004 453900 Flow pest Chars .00 -200.00 .00 200.00 100.0% .00 40 OTHER REVENUE '7 �� .. 60 INVESTMENT INCOME 65010004 82000 Interest Income -2 ,1 1.64 _ -226,1 1.6 -23,2 7. 1 .00 -202,894.13 1 .3% TOTAL Water Operating -5, 43, 1 3 3 .0 5, 3, 13. -3,244118 . 1 .00 -2,599,627.32 S .S TOTAL REVENUES - , 43, 1 , 3 -5 43, 13. -3,244,1 .S1 -21599,627.32 v\\v v v A A _ y A A v A\\ y v v v v v v y\y y y A y - y 01 20/2021 09 03 Town of North Andover 90521sav IYTD BUDGET EXPENSE iglytdbud FOR 2021 0 ACCOUNTS ORIGINAL T NPRS/ REVISED AVAILABLE PC'' E501 Water Operating APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 1 Salary 6SO10005 S11100 Salaries Fell 915, 54,55 915, 54.55 471,427.59 388,401.63 S6,025.33 9 .9¢ 65010005 512000 Salaries @ Part 9,250.00 .00 9,25 . 0 .00 9f250.00 . % 6SO10005 S12300 Salary Reserve 80,147.14 .00 80,147.14 . 80,147.14 . -0, 6SO1000S S13000 Overtime 7, 00, 0 .00 67,000.00 62,12 ..8 4, 7 .2 92.7 6SO10005 514000 Loncrevitv 31218.7S .00 31218.75 21518.75 7 0.. t 7 . TOTAL Salary 1, 175,47 ..44 .00 1107S,470.44 536,070.14 388f401.63 150,998.67 86. o 2 Expense 51 , . 510,000-00 154,45 .97 175,549.03 180,000.00 4.7% 65010006 S21300 Heating Fuel 5, 0 .00 .00 65,000-00 8f215.4353,734.57 , 5 . 95. 6S 10 06 534100 Telephone 1 ,45 . 10,4SO400 1.1 997.5c 1,51 .14 61942.36 33.6% 65010006 538700 Storm eater Per 75, 75, .00 75, . 65010006 548200 Vehicle Fuel 71 - .00 71 .0 ..00 .00 71 . 6501 06 559600 Uniform C10 71937.5 71937.50 71937.5 .00 00 100.0% 65010006 S78000 Other Cha ct s A 4, 0 .0 41 7, 7 19 41142.19 -71212. 28 . % 6501000-6-a85600 Vehicle 67,000.00 .00 67,000-0065,707.10 11292.90 9 .1 6SO10006 S91000 LTD Principal 433,682.00 433,682.00 22f5OO.00 .00 411,182.00 5.2 65010006 591100 PA Principal 289,301.00 .00 289,301.00 289, 1.0 . 1 -0 0-0 65010006 591SOO LTD 1nteIrest 5 ,74 .1 .00 561746.16 28,584.02 28,1 2.14 50.4 65010006 591600 P T Interest 46,803.73 .00 46,803.73 24,848.37 21,955.36 5 .1 65010009 596100 Transfer To Gen 11 044,54 .91 1,044,54 .91 522127 .4 522,27 .4 5 0. 65O100 9 596300 Transfer To Cap 21030,000.00 21030,000.00 2, 3 , 0.. .00 100.0% 6S100020 524000 s And Mai 110,000.00 .00 110,000.00 47,125.27 15,724.73 47,15 0.0 0 57.1 65100020 530200 L a m 42,000.00 42,000.00 14,012.47 17,9 7-5 10, 2 . 7 .1 65100020 531100 Advert sin 11 0 .0 11 0 .0 1,000.00 . 65100020 S31600 Contract Servic 741 .00 74,000.00 41,059.66 27,82 ..34 51120.00 9 3,1 96 65100020 5321-200 Training An d 9, C .0 91000.00 21325.00 675-00 61000.00 .3 6510002'0 5 42 0 Postage 11000.00 11000.00 298.6E .00 701.34 29.9 65100020 539100 Outside Details 800.00 .00 800.00 192. .00 608.00 24. % 651QO020 542000 Office Supplies 4,5 41500.00 11919..9 11797.02 783.05 2, 65100020 5422 Materials �And S 62,000.00 .00 62,000-00 7,939.47 21, 74.53 32,186.004 .1 6S100020 5S4500 Chemicals 225,000.00 .00 225, 83,371.81 55,591.23 86,036o961. 6S100020 571100 Auto M1lea e 200.00 200.00 200.00 . 65100020 573000 Dues And Member 118 11 294.00 115 1 . 65100020 S78000 Other Charges A 11,5 - .00 11,500.00 11,5 6510 020 555100 Capital Purchas 260r660.00 .00 260,660.00 81208.00 .00 252,452..Q #1 \ \ \ A v v v\\ v v\y y vy v v v yv y v \ y y\ \ \y 01/20/2021 09:03 Town of North Andover P 3 9052 sav IYTD BUDGET EXPENSE 1glytdbud FOR 2021 06 ACCOUNTS FOR ORIGINAL T FRS REVISED AVAILABLE PCT 6501 Water Operating AFPR P ADJSTMTS BUDGET YTD, EXPENDED ENCUMBRANCES BUDGET USED 65100040 523900 Enq_Lneerinq Ser 25,40 . .00 25, 0 . .a .00 25,0 . 1 6S100040 524000 Repairs And Mai 8 , 0 . .00 80,000.00 40,357.29 23,157471 16,485.00 7 .4 6S100040 531600 Contract S ry c 3 8, { -1,000.00 387f000.00 10,580.29 103,74S.14 272, 74..57 2 . 6510 40 532200 Training And Ed 1,600.00 .00 1,600.00 . 1,600.00 . 0 65100040 539100 Outside Details ,5 . .00 9,500.00 4, 8 . .00 5,420.00 2.. 65100040 542000 Off 1 se Sg 1 s 3,500.00 .00 3,5 . 0 455.94 11 672. 1,371.10 . 65100040 5 22 0 Materials And S 5 ,0Q . .00 50,000.00 23,348.03 14,813.25 11,838.72 76. 6510OQ40 573000 Dues And Member 600.00 .00 600-00294.00 . o 651 040 578000 Other Charges A 41000-00 1,000.00 5,000.00 ,8 . 7 156.53 . TOTAL Expense 6,014,127.3 0 .00 6,014,127.30 , 87,58 .75 5 5,776.47 2,040 t 761.08 66-10-,o TOTAL Water Operating 7,089,597.74 7,089,597.74 3,923,659.89 974,178.102,191,75 .75 .1 TOTAL EXPENSES 71 ,5 7.7 .00 71 8 ,5 7.7 31923,6S9.89 974,178.10 2,1 1,75 .75 \ \ t 1 2 0/2 0 21 a 9:0 0 Town of North Andover 9521v IYTD BUDGET REVENUES 1glytdbud FOR 2021 06 ACCOUNTS FOR. ORIGINAL T FR REVISED AVAILABLE PC 6001 Sewer Operating APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 01 INTEREST/PENALTIES 60010003 4215OO Int On Overdue 22, ; 2 . -22,03 _ 2 -11,290.28 .00 -1 ,74 .. 4 51. 2 USER CHARGES 60010 Q3 421400 Sewer User Char -41477, 01.81 -41477, 1. 1 -21 7, 1.52 . -21240, 7 .2 5 0..0 0 03 HOOKUPS 60010003 433900 Sewer Hooker �-8 , 4 . .00 - , 4 . 0 -7, - .0 -73, 4 .0 .7 4 OTHER FEES 60010003 417420 Lien Int Added . . . -2, 73. 3 , 73. 3 1 0. 60010003 417421 Sewer Lien In . .0 -4 . 4 43.24 100.0% 60010003 422800 Water and Sewer . . -1 . 16-00 1 0.. 60010003 423020 Sewer Liens - 2 .00 .0 . -1 , 8 .53 .00 18,989.53 100.0% 60010003 423 021 Sewer Liens - 2 -303,742.52 .00 -3 0 ,742.5, -665472 . - 3,t 7 8 .2 60010003 441200 Sewer-H harm .0 -11 7 . 2 .00 1,970.02 1 0. 60010003 476020 Sewer Assmnt Ad .00 . -47 . 8 .00 470.68 100.0% 60010003 476220 Sewer Comma Ina .. -48.. .00 48.03 1 t .0 60 INVESTMENT INCOME 60010003 482000 Interest Income -21 .,464. . - 11,4 4. -27,1 3..5 . --1 4,271. 1 . TOTAL Sewer Operating -51 5,4 .83 -51 095,4 96.8 - ,3 7,092.1 I .00 - , f , 0 6 5... TOTAL REVENUES -5, 5,4 . -5, 5,4 .83 -21 7, 2-17 -21 7 ,4 4.6 vy vv v\y \ v v y \v y 01/20/2021 090-03 Town of North Andover F 1 90521sav 1YTD BUDGET EXPENSE 1glytdbud FOR 2021 06 ACCOUNTS FOR. ORIGINAL T FRS/ REVISED AVAILABLE PCT 001 Sewer Operating A PR P ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 1 Salary 60010004 511/ 0 Salaries Fell 35 ,5 . .00 35 ,5 17S,438.63 1591084.32 25,061.05 3. 60010004 512300 Salary Reserve 32,2 2.5 .00 32,242.50 . .00 32,242.50 60010004 5 3000 Overtime 40,000.00 .00 40,000.00 10, . 3 .00 29,591.17 2 . 60Q10004 514000 L ggy t- 1,668.75 � 0 1,66 _ 5 1,668.75 . .00 100.0% TOTAL Salary 433,49S.25 .00 433,495.25 187,516.21 15 , .32 86,894.72 80.0% 2 Expense 60010005 55960Q P d �lo 21 3 .5 21 7.5 ,5 7.5 -800.00 129.2 �_a asmen 2,800,000.00 2,800,000.00 lt097,336.92 1,0971337.. 6 5,326.. 7 . 60010005 578000 Other 11500.00 .00 11500.00 171 _ 41142.17 -11,355.2 7. 60 10005 59 000 LTD Princival - 591,5 8 1.5 7 .00 59115 1.5'7 . .00 5 1,5 1.57 . 6 -incinal 113,116. .00 113,116.00 113,116.13 00 -.13 1 .. * 6001000 78t9O6.84 .00 78,906.84 39,453.42 - 0 391453.42 5 .. 60010008 S96100 Transfer To Gen 491,551.2 .00 491,551.29 245,775. 6 245,775.63 5 . 6001 008 596300 Transfer To Cap 5001000.00 .00 5001000.00 S001000.00 .00 100.0% 60/00120 521000 E1 c ri ity 106,000.00 , 40,467.38 65,532.62 .00 100.0% 60100120 521300 Heating Fuel 10,000.00 .00 10,000.00 . 1 112.. 4 3,2SO.00 67.5-0, 601 0120 524000 Repairs And Mai 65, 65,000.00 12,048.57 14,111.43 38t840.00 40.2-0. t ry c 1S,000.00 .00 1S1000.00 4,825.69 ,9 7. 1 S,176.90 5..5 60100/20 S341 0 Telephone , . .00 41 . 11171.33 1,326.55 1150 .12 62.4 60100120 539100 Outside Dg a 1s 11000.00 .00 1, 0 . . .00 1,000.00 . 60100120 542200 to als And S 361000.00 .00 36,000.005t430.29 1, 35.5'7 281934.14 19. 6 1001 0 573000 Dues And Member 2 . .00 2 . . _ 60100120 585000 Coal Punch s 11,000.00 111000.00 .00 111000.00 . �t S ry c 10,000.00 .00 10,000.00 5,55 . .00 4,442. 55. 6,000.00 .00 6,000.00 . 51160.00 1 . 610100140 542200 Materials And S 13,500.00 13,500.00 11023.11 904.73 11IS72.16 14.3 TOTAL Expense 41 5 , .2 , 5 , 9 .2 2,1 1,133. 11196,1 1,662,459.94 66.S% TOTAL Sewer Operating 5,3 3,188.45 .00 5,39311 .45 2,288,649.27 11355,1 4.52 1,749135 . 7. T TAL EXPENSES S,393,188.45 .00 5,393,188.45 2,288f649.27 1,355tl84.52 11749,354.66 \ \ \\ gi 01/2 Q 2 Q 2 l 09:00 Town of North Andover 9 0 5 21 s v IYTDBUDGET REVENUESlvtdbud FOR 2021 06 ACCOUNTS FOR {ORIGINAL T NFRS/ REVISED AVAILABLE PCT 6901 Stevens Estate Operating APPROF ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 8 STEVENS EST RECEIPTS 006 4-A4200 Osgood Hill R c -3SS,000.00 .00 - SS, -61t714.35 .00 -2 3, 8 .6 2 . 60 INVESTMENT INCOME 69010006 2 00 Interest Income - ,38 . .0 - , -3 8., - , 8- 11.8% TOTAL Stevens Estate Operating -358,386.26 .00 -35 , 8 .2 -62,1 2. -296,273.66 1 TOTAL REVENUES -3S8,386.26 .00 - 5 , .2 - 2, 12. -296,273.66 \\\\\ 01/20/2021 09 03 Town of North Andover P 90521sv IYTD BUDGET EXPENSE 1glytdbud FOR 2021 06 ACCOUNTS FOR: ORIGINAL \_ RS/ REVISED AVAILABLE PCT 6901 Stevens Estate Operating APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 1 Salary 69010007 511100 Salaries � Full 79,865.12 .00 79,8 5.12 43,004.23 36,860.79 .10 100.0% 69010007 512000 Salaries - Pert 73,5 - 73,SOO.00 5, 91.53 .00 67,508.478.2-06 69010007 514000 Longevitv 11273 75 .00 1,273.75 1,27 75 100.0% TOTAL Salary 154,638.87 154,63 .87 S01269.51 36,860.79 67,SO8.57 5 . Expense 690/0008 5 10 0 1 ct 1cit 13,500.00 13,500.00 2,436.89 51063.11 610 55. 690/0008 521300 HgAtinc Fuel 19,000.00 19i000.00 21651-9914,381.97 1,966.04 89.7-0o 69010008 524000 Re s d Mai 16, 3 . g215O . 14,330.00 3,7 2.77 634.00 9, 13.2 3 0$ 6901000 5270 Equipment Renter 22, 22,000.00 11,61 15S.00 1 ,235. 53..5 69010008 527200 Laundry Service 1 10,000.00 11052.73 7.27 8,000.00 2 < 69010008 5 1100 Marketing 23,2 23,260.00 13f003.60 3170S.00 ,551. 71. 010008 531600 Contract Servic 8,950.00 .00 81950.001,1 1. 71789.00 13; 690100018 533000 Refunds .. 1 ,72 .5 -1 ,722-5 1 . 69 10008 533SOO Ll a �Z r'Win, 3 ,00 . 30,000-00 6, 53..3 7,2 1. 2 16,66S.62 4 . 69- 1000 534100 Tel-eg phone 31000.00 3,000-00 11006.71 1,493.29 500.00 83.3 690/0008 540000 Bank Service--Ch 31600.00 .00 31600.00637.87 1962.1 69 1 00 54 0 0 0 Office U 1 es 21575... .00 2t575.00 1,22 .61 810.08 541.31 7 , 69010008 542200 Materials And S S,000.00 .00 51 31164.34 585.82 112 ...84 75. 69010008 S42800 Cleaning Seryic 51000.00 51 11 6 . 940.00 211 58-00-0 6901 008 545600 u l in d G Q, , 11,6 ,2 1,359.3017,56 ..4 4 . 6901 008 571100 Auto Mileage 3 .0-0. 690100085717 0 L£ mass 111 1,1 -00 1,100.00 690/0008 574800 Licenses And Pe 100.00 .00 100.00 .00 100.00 69010008578000 Other Charges .4 97S.00 215 .0 31 75. ,952.5 1,2S3.34 269.16 92.E 'DOTAL Expense 2 5,7 205,790.00 74,100.13 381609.20 93,080.67 5 . TOTAL Stevens Estate Operating 360,428.87 360,42B.87 1241369.64 7S,469.99 160,589424 55. TOTAL EXPENSES 360,428.87 , 2 . 7 124,369.64 75,469.99 160,589.24 FY22 CASH BALANCES AS OF DECEMBER 3,1, 2020 ACC IT NAME BALANCE To�tal D sc,ription Cash General, Fund $ 15,0500344.49 $ 1S,050,344 General and Cash CPA $ 10,474,fO28.07 $ 10�,474,028 CPA Cash-Circuit IBreaker $ 1.00 Cash-Bullet Proof Vest $ 13,391.02 Cash Traffic Enforcement Grant $ 824,.29 Cash-Fire Safe Grant $ 206.17 Cash-Fire Haz,mat Grant $ 3151 .70 Cash-Osgood Andover Grant $ 51083.31 Cash Elder Serer Affaris Grant $ (3 315 8 0.12) Cash Library State Aid $ 87,332.46 Cash N A Arts Council $ 1,515.57 Cash Ped/Bicy Enforc Grant $ 254.22 Cash, En, Effic Consry Grant $ 144.619 Cash State 911 Supirt/Inct G�rt $ (18,025.00)1 Cash Fire Safe Girt-Seniors $ 724.08 Cash B,ig Yellow School Bus Grt $ 5001.00 Cash Fuel up to Play 610 $ 673.15 Cash Police Outside Details, $ (47,467.80) Cash Fire Outside Details $ (41729.57) Caish Recycle Bins $ 1,579.01 Cash Home C posting Bins $ 1001.00 Cash Host Comm,-Pl,annniinig $ 114,436.55 Cash Host Com-Traf Enforcmnt $ 991467.49 Cash Health, Food Consultant $ 490006.72 Cash Health Septic Consultant $1 48,467.83 Cash Field Maintenance $ 1,0001.00 Cash Health Dept Revolving $ 28,724.35 Cash Youth Services $ 316,354.67 Cash Elder Services Revolvini,g $ 19,927.24 Cash Board of Appeals-Postaig $ 58.45 Cash Athlectic Revolving $ 42,138.08 Cash Community,Programs $ 80,732-35 Cash All Day Kindergarten $ 238.01 Cash Preschool Revolving, $ 9,014.43 Cash Custodial Overtime $ 319.95 Cash Rental Fees, $ 22,442.11 Clash Paid Busing Transport'atio $ 87,514.03 Cash High Sch Citizen's Donatio $ 433.53 Cash H/S Shakespl ear e Drama Clbi $; 1,453.90 Cash Middle Bch Citizens Dant $ 201.00 Cash M/S After Sch Prog,ra,ms $ 11035-00 Cash Briadst Citizens Donations, $ 3,233.76 Cash Non Resident,Spec Ed $ 171065.10 Cash Extra Stipens-School $1 1 2,f 9 2 1.45 Cash Urarest School Donatons $ 11935.,05 Cash School Lunch Program $ 3921670.90 Cash Damage Reimb,-Thrift Shop $ 22,481.02 Cash Wetlands Filing Fees $ 90,r246.85 Cash Insurance Reimb-Police $ 2169 .53 FY22 CASH BALANCES AS OF DECEMBER 31., 2020 ACCOUNT NAME BALANCE Total L escription Cash Insurance Reimb-DPW $ 4p953.02 Cash Appellant Tax Br d Appeal $ 740393.00 Cash Jared/Sh,erwood Drive $ 15,450.20 Cash GLSD-Public Safety $ .1 .86 Cash State 911 Training Grant $ (21026.34) Cash CRAG Program $ 701.29 Cash CDB,G Program $ 17p624.79 Cash Federal Home Invest Rehab $ 498.05 Cash Osgood Roof&Gutters $ 161225.00 Cash Machine Shop Village $ 11666.66 Cash MA Travel Historical Grt $ 361040.77 Cash Comcast Donations $ 18,1019.74 Caish Family Co-op Donations $ 338.44 Cash Flag Fund; $ 5,464.0�7 Cash Stevens Grant-Half mile $ 11,687.501 Cash Public,Land Grn:t-Half Mil $ 10,1000.010 Cash Stevens Grnt Cullen Prop $ 5,1231.07 Cash Town Clerk Census $ 60 .00 Cash Conservation Tree Resto ra $ 100930.43 Cash Police Helmets $ 693.78 Cash Student Academy gnat $ 122.31 Cash Sidewalk Construction $ 20000.00 i 7�O� 3 Cash Foxwood Subd'ivisiloin $ 1 71.1 Cash Solid'Wate Advisory $ 301430.36 Cash Sewer Mitigation $ 2981577.55 Cash Elder Services Donations $ 61171.93 Cash Elder Sery Nutri Donation, $ 63.16 Cash.1 Herman Youth Center $ 7,F880.36 Cash Veterans Sup the Troops $ 2�771.14 Cash Elder Sery Water Donation $ 154.03 Cash Festival Committee $ 169.20 Cash Recreation Prograrn $ 81697.14 Cash Schneider Elec Donations $ 400.45 Cash Project Lifesaver $1 300-00 Cash PEG Grant $ 36,1652.63 Cash Fire Eq,uip Donations 31.7,7 Cash Police Donations $ 8 .19 Cash Merrimack Condos, $ 15,000.00 Cash New Fields $ 400�301.25 Cash Stevens Mem Lib Donations $ 61618.3,2 Cash Harold Diushame Memorial $ 77.010, Cash Kittridge Sch Gym Donatio, $ 101,0100.00 Cash NA Water Conservation $ 3,11,748.48 Cash Handicap Parking Viol $ 21000.00 Cash Modular Classrooms, $ 31751-58 Cash Support The Femal:Troops $ 9127.7'5 Cash-ComntyCompact $ 161250.001 Cash MassHumanities Grant $ 8 -00 Cash Green Community Grt $ 26o192.41 Cash PLC W Grant $ 5501-00 Cash Res Debt-Bond Premium GP $ 71705.42 2 FY22 CASH BALANCES AS OF DECEMBER 31, 2O2,0 ACCOUNT NAME BALANCE Total Description C,ash-School Curriculm $ (148,551.97) Cash-Shlawn Gallagher Mermorial $ 1,015 .44 Cash .STD Grant $ 139.32 Cash, Res Debt Premium Water $ 1,338.24 Cash MM,ARS Grant $ 22.00 Cash TNC Surchg,Municipal Dist $ 21,215.90 Cash Literacy Grant $ 7,016.12 Cash STEM Grant $ 8,083.47 Cash Fire Dept(21,E Reim,b) $ 4,794.29 Cash Recycling Dividends P'r gm, $ 5,741.9�7 Cash Business-Re,covery Grt Prg $ 291881.17 Calshi Soft Surface Columbia Gas $ 1,295.,080.00 Cash MassWorks Rte 125 Grt $ 30�1804.87 Cash SMRP Grant $ 7.33 Cash Columbi�a Gas Claiims $ (320.00) Cash Mental Wealth First Aid G $ 21,500.00 Cash Rec Complex MultiGenerati $ 25,249.00 Cash Sutton St Mitigation GLSD $ 301000.0:01 Cash COVID19 CARES CvRF $ 1P7401498.00 Cash COVID19 FEMA $ (21707,679.01) Cash ESSER Grant (3,815.25) Cash CTCL Grant $ 3,850.63 Cash B,Kody"s Memor,ia,l Fund $ 1,0201.00 Cash ESSA Gira,nt $ (41.32) Cash META Grant $ (70175.00) Cash MV P Gra�nit $ 19,605-88 Cals1 Sustainable Materials Rec $ 111700,.00 Cash MassDOT Rte125/Mass Ave $ (17,0189.20) Cash Remote Learing Gran t 1,18 $ 5,966.60 Cash CvRF School Grant $ 131790.311 Cash M'APC-COV'ID19 $ 10,845-66 Cash COVID Smalll Biz Assistanc $ 150,000.00 Cash FPS Grant $ 50,000-010 Cash MassDot Street Shared Girt $ 200,926-001 Cash Rte 125 Corridor Grainit $ 251,000.00 Cash Summer,&Vac Learning Grant $ 11067.001 Cash PL-94-142 Grant $ (991634.48) Cash PAL 94-142 Early Childhood $ (10477. 2) Cas H-Health Grant $1 13,333.83 Cas,h'Title One Grant $ (1215913.06) Cash Title IV,, Part A $ 2,729.30, Cash History&Social Science $1 0.01 Cash Acad Support Service-Wntr $ 10750-00 $ 3,494,,3,99 Special Reven use Cash Revenue bill:ing Sys 2011 $ 117'68.72 Cash EngEfficl'mp 20,14 $ 11759.56 Cash 170 Sutton St Thrift Shop $ 1431309.27 Cash Wat&HighStlntersecFY17 $ 458.56 Cash Facilities Master 20,18 $ 182,07.50 Cash Roadway Imp,rov 2018 $ 8,757.28 Cash Sidewalks 20,18 $ 16,1292.51 3 FY22 CASH BALANCES " AS OF DECEMBER 31, 20,20 ACCOUNT NAME BALANCE Total Description Cash Facilities Master Plan 19 $ 4,,9 7 2,1912.8 2 Cash Roadway Improv 2019 $ 32�126.82 Cash Sidewalks 2019 $ 121995.72 Cash Recreation Complex $ 1,500,000.00 Cash Facilities Mast I FY201 $ 750,. ,01.00 Cash Facilities M�stPllainill FY20 $ 131851.81 Cash Playground Imp FY20 $ 3.,298.33 Cash Municipal IT FY20 $ 146.57 Cash Roof Replacements $ 49,543.501 Cash Vehcille Carport&Storage $ 382,160.00 Cash Replace Engine "ruck $ 90856.16 Cash Roadway Improv FY20 $ 176,707.58 Cash Sidewalks FY201 $ 143,447.40 Cash Building Main FY20 $ 1,667.95 Cash Columbia Gas Roadway $ 916111,320.15 Cash ColIumbial:Gas P,ropRestor $ 4,300.00 Cash FacilitiesMaster Flare Phl $ 30000,000.001 Cash,Comm Dev Vehicle $ 420.00 Cash Playground Improv F 21 $ 501000.001 Cash Roadway Improv FY21 $ 30!5,760.10 Cash Sidewalks FY21 $ 250,000.00 Cash 6 Wheel Dump Truck $ 2001 .00 Cash Building Main FY21 285,7013. 7 Cash Ambulance $ 30911,73.00 Cash,Command Vehicle Fire $ 15,671.20 Cash Municipal IT FY21 $ 13,1551.33 Cash Police AED's $ 2j780.00 Cash Police Mobile Radios, $ 11971.2,8 Cash Police Veh Carport FY21 $ 200p000.00 Cash AC Sys Dispatch Area $ 1410075.00 Cash Districtwide Paving $ 39,383-18 Cash,School' IIT FY21 $ 20010100.00 Cash School Drainage $ 780.00 $ 23,035,317 Capital Projects, Cash MA 5 913 $ (17,776.55) $ (17,777), Chapter 90 Cash Sewer Operati�ng $ 5, 24,7 2.44 $ 5,824,782, S wer Operating Cash,Sewer Sys E'xt Watershed $ 6,1211.06 Cash Sewer GP,R 111-2005 $ 8,973.58 Cash N Main St Sewer 1,9196 $ 415,81.40 Cash Sewer Sys Improv $ 12J12.95 Cash Johnson Circle Pump St $ 41#7'40.00 Cash New Bonny Lane Pump St $ 16,240.00 Cash Sutton St Sewer Imvp $ 30 20.72 Cash SchStBunkerHill Swr 2013 $ 1,145.06 Cash SchStBunkerHill Swr 2014 $ 98,2016-95 Cash Impr to Various Pump Stat $ '7t983.05 Cash Commonwealth Ave Sewer $ 50,361-13 Cash ImprovPumpSt FY17 $ 39,787.10 Cash Improv Pump St 2018 $ 94,157.08 4 I BALANCES AS OF E ER ., 2020 ACCOUNT NSAME BALANCE Total Description Cash Im rou var PiumpSt 19 $ 84,318.98 Cash Improve various Pu.umpSt $ 1000000.00 Cash Sewer Collections Sys imp $' 7o331.95 Cash Sewer Line-Osgood Street $ 1149% 4 . ' Cash, Impr v vaU r Pumps mps Y21 $ 250110010.00 Cash Sewer Collection System 246,5001.00 $ 2,5135,312 Sewer Capital Cash Water Operating $ 5,4240641w65 5,424,642 Water Operating Cash Rosemont Booser Pump 2010 $ 250690.34 Cash Meter Replacemenit-2011 $ L327.31 Cash I" e ua veer Air,Cond'Eq:uip,2012 $ 44,045.04 4 Cash Via IveI~~~ydRe l/Inst aall2 1 $ 2,712.24 Cash EmergPiowerUpgradle WT 2 14 $ 9421.00 Cash WTP I rocessCon r lCo uau 11, 13.35, Cash Corrosion Study dy W a erl i e $ 86,920.20 Cash Chemical Storage Tank $ 5o992.52 Cash, Practise Con roll.System 36,5i12.50 Cash,Chemical Storage Tk FY17 Cash Ozone System-2018 $ 22,810.36 Cash Chemical Storage Tk 2018 90603.28 Cash Chemical S or Tank 2019 317,537. Cash Water Main RepI 2019 $ 102,865.71 Cash Water Dist Trk 20,19 $ 1,152.E , Cash Chemical Storage Tian 200,0100.00 Cash Interconniletio us 73,857.0101 Calsh Bradford Standpipe 1501000.001 Cash Backwash Tank Ex $ 325,,000.001 Cash Backwash Tank Ex $1 1,400,000.0101 Cash Valve&Hydrant Re 1c $ 94,24 7.3 Cash WTP Lab Renovations 5010100.0,01 Cash Sedimentation ation ,a�si n Imp 300, 0 - 0 Cash WTP Sludge Collection Sys $ 1800000.10,01 3,489,444 'eater Capital Cash Stevens Estate Operating $1 380521.601 3 ,"2,2 Stevens Est Operating Cash Main House Boller r& Plumb $ 35,269.32 Cash Main House Boiler/Plum19 $' 75,000.010 Cash Mal in House Bathroom Irrupr $ 43,760.331 167,693 Stevens Est Capital Cash Conservation 25,,605.42 Cash Law Truant-State 47,168.88 Cash Law Trust-Federal 37", 4.41 Cash Drug Free School:Truest 10531.15 Cash Armitage Welfare $ 37,985.10 Cash Taylor llor Welfare $ 7 3. 7 Cush Moses Towne School $ 9)438.57 Cash Sarah Barker School $1 10,006.23 5 FY22 CASH BALANCES AS OF DECEM BER 31, 2020 ACCOUNT NAME BALANCE Total Description Cash Sewer Pump Trust 47,693.86 Cash Hym,a�n Koker Cernetary $ 480.60 Cash Flag Pole Trust $ 41#988.25 Cash Helen Coolidge Trust $ 20 .37 Cash.1&S Stone Welfare $ 161569.83 Cash Taylor Fund $ 78.00 Cash Sewer Pump Trust $ 10,583.72 Cash Flag Pole Trust, $ 78-95 Cash Stone Income Fund 160614-83 Cash Elder&Disabled Tax Fund $ 58,923.75 Cash Special Purpose Fund $ 2450450.43 Cash Student Activity $ 427o840.26 Cash Hi�ghway Bonds $ 217p850-38 Cash Conservation Escrow $ 31261)510.11 Cash Passbook Planning $ 97,502.62 Cash Passbook Conservation $ 131751.85 Cash Library Trust $ 902,309.05 Cash Health Is Trust $ 266,158.58 Cash Affordable Housing Trust $ 7721165.87 $ 6,,533,3911 Trust and Agency Funds Cash Stabilization $ 511770401,.30 Cash Capital Stabilization Fun $ 110128,016.86 Cash Stabilization SPED $ 7611660.20 $ 6,,967..07'8 Stabilization Funds Cash OP"EB Trust Fund $ 4,807,463.14 $, 4,807,,463 OPEB Trust $ 87,824,639 6