Loading...
GF Expenses.123119 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 111 CITY COUNCIL _________________________________________ 11111 CITY COUNCIL-PS 136,580 1,506 138,086 67,770.00 .00 70,316.00 49.1% 11112 CITY COUNCIL-OM 55,500 0 55,500 27,322.68 .00 28,177.32 49.2% TOTAL CITY COUNCIL 192,080 1,506 193,586 95,092.68 .00 98,493.32 49.1% 121 MAYOR _________________________________________ 11211 MAYOR-PS 476,918 7,619 484,537 230,846.03 .00 253,690.97 47.6% 11212 MAYOR-OM 16,442 0 16,442 6,888.02 .00 9,553.98 41.9% TOTAL MAYOR 493,360 7,619 500,979 237,734.05 .00 263,244.95 47.5% 135 AUDITOR _________________________________________ 11351 AUDITOR-PS 332,390 5,098 337,488 161,021.04 .00 176,466.96 47.7% 11352 AUDITOR-OM 5,280 0 5,280 1,095.19 .00 4,184.81 20.7% TOTAL AUDITOR 337,670 5,098 342,768 162,116.23 .00 180,651.77 47.3% 141 ASSESSOR _________________________________________ 11411 ASSESSOR-PS 178,229 3,525 181,754 86,295.81 .00 95,458.19 47.5% 11412 ASSESSOR-OM 124,350 70,248 194,598 125,166.62 .00 69,431.38 64.3% TOTAL ASSESSOR 302,579 73,773 376,352 211,462.43 .00 164,889.57 56.2% 146 COLLECTOR _________________________________________ 11461 COLLECTOR-PS 391,070 7,772 398,842 187,234.08 .00 211,607.92 46.9% 11462 COLLECTOR-OM 276,435 0 276,435 88,801.90 .00 187,633.10 32.1% TOTAL COLLECTOR 667,505 7,772 675,277 276,035.98 .00 399,241.02 40.9% 151 LEGAL SERVICES _________________________________________ 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 151 LEGAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11512 LEGAL SERVICES-OM 275,000 0 275,000 126,633.40 .00 148,366.60 46.0% TOTAL LEGAL SERVICES 275,000 0 275,000 126,633.40 .00 148,366.60 46.0% 152 HUMAN RESOURCES _________________________________________ 11521 HUMAN RESOURCES-PS 315,443 -30,011 285,432 133,242.65 .00 152,189.35 46.7% 11522 HUMAN RESOURCES-OM 19,550 35,000 54,550 3,791.24 .00 50,758.76 7.0% TOTAL HUMAN RESOURCES 334,993 4,989 339,982 137,033.89 .00 202,948.11 40.3% 155 INFORMATION TECHNOLOGY _________________________________________ 11551 INFORMATION TECHNOLOGY - PS 433,926 8,772 442,698 210,154.10 .00 232,543.90 47.5% 11552 INFORMATION TECHNOLOGY - OM 565,259 34,610 599,869 360,619.34 188,556.29 50,693.37 91.5% TOTAL INFORMATION TECHNOLOGY 999,185 43,382 1,042,567 570,773.44 188,556.29 283,237.27 72.8% 161 CITY CLERK _________________________________________ 11611 CITY CLERK-PS 272,850 2,433 275,283 120,669.95 .00 154,613.05 43.8% 11612 CITY CLERK-OM 32,525 0 32,525 15,457.65 .00 17,067.35 47.5% TOTAL CITY CLERK 305,375 2,433 307,808 136,127.60 .00 171,680.40 44.2% 175 PLANNING & SUSTAINABILITY _________________________________________ 11751 PLANNING & SUSTAINABILITY - P 352,564 7,391 359,955 161,459.43 .00 198,495.57 44.9% 11752 PLANNING & SUSTAINABILITY -OM 55,923 0 55,923 23,748.13 .00 32,174.87 42.5% TOTAL PLANNING & SUSTAINABILITY 408,487 7,391 415,878 185,207.56 .00 230,670.44 44.5% 192 CENTRAL SERVICES _________________________________________ 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 192 CENTRAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11921 CENTRAL SERVICES-PS 655,150 17,937 673,087 334,893.74 .00 338,193.26 49.8% 11922 CENTRAL SERVICES-OM 1,046,160 46,432 1,092,592 404,128.81 .00 688,463.25 37.0% TOTAL CENTRAL SERVICES 1,701,310 64,369 1,765,679 739,022.55 .00 1,026,656.51 41.9% 210 POLICE _________________________________________ 12101 POLICE-PS 5,546,919 263,301 5,810,220 2,483,023.72 .00 3,327,196.28 42.7% 12102 POLICE-OM 604,244 15,000 619,244 234,522.71 .00 384,721.29 37.9% 12103 POLICE-CAP 305,360 0 305,360 9,184.71 .00 296,175.29 3.0% TOTAL POLICE 6,456,523 278,301 6,734,824 2,726,731.14 .00 4,008,092.86 40.5% 211 PARKING ENFORCEMENT _________________________________________ 12111 PARKING ENFORCEMENT-PS 209,106 0 209,106 96,485.10 .00 112,620.90 46.1% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 4,185.37 .00 8,014.63 34.3% TOTAL PARKING ENFORCEMENT 221,306 0 221,306 100,670.47 .00 120,635.53 45.5% 212 PUBLIC SAFETY COMM CENTER _________________________________________ 12121 PUBLIC SAFETY COMM CTR-PS 635,984 13,645 649,629 235,201.42 .00 414,427.58 36.2% 12122 PUBLIC SAFETY COMM CTR-OM 47,003 0 47,003 31,779.40 .00 15,223.60 67.6% TOTAL PUBLIC SAFETY COMM CENTER 682,987 13,645 696,632 266,980.82 .00 429,651.18 38.3% 220 FIRE RESCUE DEPARTMENT _________________________________________ 12201 FIRE RESCUE - PS 5,659,075 0 5,659,075 2,719,525.33 .00 2,939,549.67 48.1% 12202 FIRE RESCUE - OM 711,600 8,815 720,415 201,526.97 .00 518,888.03 28.0% TOTAL FIRE RESCUE DEPARTMENT 6,370,675 8,815 6,379,490 2,921,052.30 .00 3,458,437.70 45.8% 241 BUILDING INSPECTORS _________________________________________ 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 241 BUILDING INSPECTORS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 12411 BUILDING INSPECTORS-PS 490,322 9,401 499,723 242,934.51 .00 256,788.49 48.6% 12412 BUILDING INSPECTORS-OM 24,700 0 24,700 7,975.28 695.10 16,029.62 35.1% TOTAL BUILDING INSPECTORS 515,022 9,401 524,423 250,909.79 695.10 272,818.11 48.0% 421 DPW-ADMIN & ENGINEERING _________________________________________ 14211 DPW ADMINISTRATION-PS 239,306 4,457 243,763 116,749.80 .00 127,013.20 47.9% 14212 DPW ADMINISTRATION-OM 32,375 0 32,375 15,006.37 .00 17,368.63 46.4% TOTAL DPW-ADMIN & ENGINEERING 271,681 4,457 276,138 131,756.17 .00 144,381.83 47.7% 422 HIGHWAYS _________________________________________ 14221 HIGHWAYS-PS 795,741 21,095 816,836 350,443.63 .00 466,392.37 42.9% 14222 HIGHWAYS-OM 403,750 30,500 434,250 156,883.76 .00 277,366.24 36.1% 14223 HIGHWAYS-CAP 185,000 193,358 378,358 232,540.96 .00 145,817.34 61.5% TOTAL HIGHWAYS 1,384,491 244,953 1,629,444 739,868.35 .00 889,575.95 45.4% 423 SNOW & ICE _________________________________________ 14231 SNOW & ICE-PS 131,000 0 131,000 80,682.11 .00 50,317.89 61.6% 14232 SNOW & ICE-OM 369,000 0 369,000 107,140.48 .00 261,859.52 29.0% TOTAL SNOW & ICE 500,000 0 500,000 187,822.59 .00 312,177.41 37.6% 481 PARKING _________________________________________ 14811 PARKING-PS 226,527 0 226,527 92,727.21 .00 133,799.79 40.9% 14812 PARKING-OM 225,974 0 225,974 60,180.03 .00 165,793.97 26.6% 14813 PARKING-CAP 90,000 0 90,000 40,294.14 .00 49,705.86 44.8% TOTAL PARKING 542,501 0 542,501 193,201.38 .00 349,299.62 35.6% 492 DPW FORESTRY, PARKS & REC _________________________________________ 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 492 DPW FORESTRY, PARKS & REC APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 14921 DPW FORESTRY, PARKS & REC-PS 971,108 16,917 988,025 465,974.95 .00 522,050.05 47.2% 14922 DPW FORESTRY, PARKS & REC-OM 276,000 0 276,000 117,354.80 .00 158,645.20 42.5% 14923 DPW FORESTRY, PARKS & REC-CAP 75,000 16,154 91,154 36,387.30 .00 54,767.07 39.9% TOTAL DPW FORESTRY, PARKS & REC 1,322,108 33,071 1,355,179 619,717.05 .00 735,462.32 45.7% 511 HEALTH DEPARTMENT _________________________________________ 15111 HEALTH DEPARTMENT - PS 267,145 5,457 272,602 137,640.63 .00 134,961.37 50.5% 15112 HEALTH DEPARTMENT - OM 33,710 0 33,710 10,100.85 .00 23,609.15 30.0% TOTAL HEALTH DEPARTMENT 300,855 5,457 306,312 147,741.48 .00 158,570.52 48.2% 541 SENIOR SERVICES _________________________________________ 15411 SENIOR SERVICES -PS 262,745 13,717 276,462 166,919.32 .00 109,542.68 60.4% 15412 SENIOR SERVICES - OM 46,264 0 46,264 35,264.63 .00 10,999.37 76.2% TOTAL SENIOR SERVICES 309,009 13,717 322,726 202,183.95 .00 120,542.05 62.6% 543 VETERANS' SERVICE _________________________________________ 15431 VETERANS' SERVICE-PS 192,804 3,563 196,367 93,522.06 .00 102,844.94 47.6% 15432 VETERANS' SERVICE-OM 735,603 0 735,603 236,105.73 .00 499,497.27 32.1% TOTAL VETERANS' SERVICE 928,407 3,563 931,970 329,627.79 .00 602,342.21 35.4% 610 FORBES LIBRARY _________________________________________ 16101 FORBES LIBRARY-PS 1,165,989 0 1,165,989 680,160.25 .00 485,828.75 58.3% 16102 FORBES LIBRARY-OM 184,733 0 184,733 126,690.02 .00 58,042.98 68.6% TOTAL FORBES LIBRARY 1,350,722 0 1,350,722 806,850.27 .00 543,871.73 59.7% 611 LILLY LIBRARY _________________________________________ 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 611 LILLY LIBRARY APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 16111 LILLY LIBRARY-PS 254,788 0 254,788 148,626.31 .00 106,161.69 58.3% 16112 LILLY LIBRARY-OM 86,413 0 86,413 50,407.56 .00 36,005.44 58.3% TOTAL LILLY LIBRARY 341,201 0 341,201 199,033.87 .00 142,167.13 58.3% 630 PARKS & RECREATION DEPARTMENT _________________________________________ 16301 PARKS & RECREATION - PS 289,255 6,758 296,013 157,101.21 .00 138,911.79 53.1% 16302 PARKS & RECREATION-OM 33,500 0 33,500 15,148.02 .00 18,351.98 45.2% TOTAL PARKS & RECREATION DEPARTMENT 322,755 6,758 329,513 172,249.23 .00 157,263.77 52.3% 699 ARTS AND CULTURE _________________________________________ 16991 ARTS & CULTURE-PS 61,115 2,647 63,762 29,751.40 .00 34,010.60 46.7% 16992 ARTS & CULTURE-OM 16,000 0 16,000 14,350.00 .00 1,650.00 89.7% TOTAL ARTS AND CULTURE 77,115 2,647 79,762 44,101.40 .00 35,660.60 55.3% 710 MUNICIPAL INDEBTEDNESS _________________________________________ 17103 MUNICIPAL DEBT SERVICE 5,069,900 0 5,069,900 3,009,900.00 .00 2,060,000.00 59.4% TOTAL MUNICIPAL INDEBTEDNESS 5,069,900 0 5,069,900 3,009,900.00 .00 2,060,000.00 59.4% 750 INTEREST ON DEBT _________________________________________ 17503 INTEREST ON MUNICIPAL DEBT 1,018,050 0 1,018,050 516,177.98 .00 501,872.02 50.7% TOTAL INTEREST ON DEBT 1,018,050 0 1,018,050 516,177.98 .00 501,872.02 50.7% 911 CONTRIBUTORY RETIREMENT _________________________________________ 19111 CONTRIBUTORY RETIREMENT-PS 6,333,238 0 6,333,238 6,317,472.20 .00 15,765.80 99.8% 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 19112 CONTRIBUTORY RETIREMENT-OM 10,000 0 10,000 .00 .00 10,000.00 .0% TOTAL CONTRIBUTORY RETIREMENT 6,343,238 0 6,343,238 6,317,472.20 .00 25,765.80 99.6% 912 WORKERS' COMP INSURANCE _________________________________________ 19121 WORKERS' COMP INSURANCE 500,000 0 500,000 500,000.00 .00 .00 100.0% 19122 WORKERS' COMP INSURANCE 217,000 0 217,000 213,325.00 .00 3,675.00 98.3% TOTAL WORKERS' COMP INSURANCE 717,000 0 717,000 713,325.00 .00 3,675.00 99.5% 913 UNEMPLOYMENT INSURANCE _________________________________________ 19131 UNEMPLOYMENT INSURANCE 100,000 0 100,000 3,961.39 .00 96,038.61 4.0% 19132 UNEMPLOYMENT INSURANCE 10,000 0 10,000 8,240.00 .00 1,760.00 82.4% TOTAL UNEMPLOYMENT INSURANCE 110,000 0 110,000 12,201.39 .00 97,798.61 11.1% 914 MEDICAL INSURANCE _________________________________________ 19141 MEDICAL INSURANCE 11,132,800 206,350 11,339,150 5,339,550.77 .00 5,999,598.93 47.1% 19142 MEDICAL INSURANCE 15,000 0 15,000 .00 .00 15,000.00 .0% TOTAL MEDICAL INSURANCE 11,147,800 206,350 11,354,150 5,339,550.77 .00 6,014,598.93 47.0% 919 OTHER EMPLOYEE BENEFITS _________________________________________ 19191 OTHER EMPLOYEE BENEFITS 1,425,815 0 1,425,815 802,679.84 .00 623,135.16 56.3% TOTAL OTHER EMPLOYEE BENEFITS 1,425,815 0 1,425,815 802,679.84 .00 623,135.16 56.3% 920 CHERRY SHEET ASSESSMENTS _________________________________________ 19202 CHERRY SHEET ASSESSMENTS 3,782,462 44,014 3,826,476 1,872,615.00 .00 1,953,861.00 48.9% 01/15/2020 13:48 |CITY OF NORTHAMPTON, MA - LIVE |P 8 1281swri |CITY OF NORTHAMPTON |glytdbud EXPENSE -GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 920 CHERRY SHEET ASSESSMENTS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ TOTAL CHERRY SHEET ASSESSMENTS 3,782,462 44,014 3,826,476 1,872,615.00 .00 1,953,861.00 48.9% 925 OTHER ASSESSMENTS _________________________________________ 19252 GOVERNMENTAL ASSESSMENTS 27,122 0 27,122 27,122.00 .00 .00 100.0% TOTAL OTHER ASSESSMENTS 27,122 0 27,122 27,122.00 .00 .00 100.0% 930 CAPITAL IMPROVEMENTS _________________________________________ 19303 CAPITAL IMPROVEMENTS 340,000 8,373,110 8,713,110 2,627,982.43 20,714.30 6,064,413.27 30.4% TOTAL CAPITAL IMPROVEMENTS 340,000 8,373,110 8,713,110 2,627,982.43 20,714.30 6,064,413.27 30.4% 943 RESERVE FOR PERSONNEL _________________________________________ 19491 RESERVE FOR PERSONNEL 428,000 -428,000 0 58,582.53 .00 -58,582.53 100.0% TOTAL RESERVE FOR PERSONNEL 428,000 -428,000 0 58,582.53 .00 -58,582.53 100.0% 945 GENERAL LIABILITY INS. _________________________________________ 19452 GENERAL LIABILITY INSURANCE 405,000 0 405,000 343,235.00 .00 61,765.00 84.7% TOTAL GENERAL LIABILITY INS. 405,000 0 405,000 343,235.00 .00 61,765.00 84.7% GRAND TOTAL 58,729,289 9,038,591 67,767,880 34,558,582.00 209,965.69 32,999,332.74 51.3% ** END OF REPORT - Generated by Susan Wright **