Loading...
GF Expenditures.033118 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 111 CITY COUNCIL _________________________________________ 11111 CITY COUNCIL-PS 133,673 0 133,673 84,184.22 .00 49,488.78 63.0% 11112 CITY COUNCIL-OM 51,400 0 51,400 50,104.52 .00 1,295.48 97.5% TOTAL CITY COUNCIL 185,073 0 185,073 134,288.74 .00 50,784.26 72.6% 121 MAYOR _________________________________________ 11211 MAYOR-PS 435,782 1,620 437,402 305,879.69 .00 131,522.31 69.9% 11212 MAYOR-OM 18,062 1,380 19,442 12,178.27 .00 7,263.73 62.6% TOTAL MAYOR 453,844 3,000 456,844 318,057.96 .00 138,786.04 69.6% 135 AUDITOR _________________________________________ 11351 AUDITOR-PS 289,417 0 289,417 202,062.61 .00 87,354.39 69.8% 11352 AUDITOR-OM 5,280 4,820 10,100 2,787.65 .00 7,312.35 27.6% TOTAL AUDITOR 294,697 4,820 299,517 204,850.26 .00 94,666.74 68.4% 141 ASSESSOR _________________________________________ 11411 ASSESSOR-PS 152,963 0 152,963 108,952.46 .00 44,010.54 71.2% 11412 ASSESSOR-OM 89,850 100,118 189,968 56,539.05 .00 133,428.95 29.8% TOTAL ASSESSOR 242,813 100,118 342,931 165,491.51 .00 177,439.49 48.3% 146 COLLECTOR _________________________________________ 11461 COLLECTOR-PS 341,502 0 341,502 237,743.34 .00 103,758.66 69.6% 11462 COLLECTOR-OM 201,185 0 201,185 131,044.80 .00 70,140.20 65.1% TOTAL COLLECTOR 542,687 0 542,687 368,788.14 .00 173,898.86 68.0% 151 LEGAL SERVICES _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 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 76,106.16 .00 198,893.84 27.7% TOTAL LEGAL SERVICES 275,000 0 275,000 76,106.16 .00 198,893.84 27.7% 152 HUMAN RESOURCES _________________________________________ 11521 HUMAN RESOURCES-PS 245,595 0 245,595 163,198.41 .00 82,396.59 66.5% 11522 HUMAN RESOURCES-OM 5,550 0 5,550 2,164.01 .00 3,385.99 39.0% TOTAL HUMAN RESOURCES 251,145 0 251,145 165,362.42 .00 85,782.58 65.8% 155 INFORMATION TECHNOLOGY _________________________________________ 11551 INFORMATION TECHNOLOGY - PS 323,474 0 323,474 195,873.11 .00 127,600.89 60.6% 11552 INFORMATION TECHNOLOGY - OM 436,975 0 436,975 419,773.50 13,285.61 3,915.89 99.1% TOTAL INFORMATION TECHNOLOGY 760,449 0 760,449 615,646.61 13,285.61 131,516.78 82.7% 161 CITY CLERK _________________________________________ 11611 CITY CLERK-PS 191,371 0 191,371 127,225.71 .00 64,145.29 66.5% 11612 CITY CLERK-OM 75,425 0 75,425 42,773.36 .00 32,651.64 56.7% TOTAL CITY CLERK 266,796 0 266,796 169,999.07 .00 96,796.93 63.7% 175 PLANNING & SUSTAINABILITY _________________________________________ 11751 PLANNING & SUSTAINABILITY - P 316,207 540 316,747 217,980.28 .00 98,766.72 68.8% 11752 PLANNING & SUSTAINABILITY -OM 44,023 -480 43,543 28,278.04 .00 15,264.96 64.9% TOTAL PLANNING & SUSTAINABILITY 360,230 60 360,290 246,258.32 .00 114,031.68 68.4% 192 CENTRAL SERVICES _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 192 CENTRAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11921 CENTRAL SERVICES-PS 552,549 -9,530 543,019 342,267.56 .00 200,751.44 63.0% 11922 CENTRAL SERVICES-OM 953,913 21,080 974,993 623,240.36 .00 351,752.24 63.9% TOTAL CENTRAL SERVICES 1,506,462 11,550 1,518,012 965,507.92 .00 552,503.68 63.6% 210 POLICE _________________________________________ 12101 POLICE-PS 5,401,637 -58,025 5,343,612 3,329,824.23 .00 2,013,787.77 62.3% 12102 POLICE-OM 500,966 82,380 583,346 285,739.75 .00 297,606.34 49.0% 12103 POLICE-CAP 315,475 53,999 369,474 162,369.49 .00 207,104.86 43.9% TOTAL POLICE 6,218,078 78,354 6,296,432 3,777,933.47 .00 2,518,498.97 60.0% 211 PARKING ENFORCEMENT _________________________________________ 12111 PARKING ENFORCEMENT-PS 194,718 -3,700 191,018 122,046.48 .00 68,971.52 63.9% 12112 PARKING ENFORCEMENT-OM 8,500 3,700 12,200 5,311.93 .00 6,888.07 43.5% TOTAL PARKING ENFORCEMENT 203,218 0 203,218 127,358.41 .00 75,859.59 62.7% 212 PUBLIC SAFETY COMM CENTER _________________________________________ 12121 PUBLIC SAFETY COMM CTR-PS 533,374 -2,475 530,899 352,845.36 .00 178,053.64 66.5% 12122 PUBLIC SAFETY COMM CTR-OM 47,180 2,475 49,655 41,898.31 .00 7,756.69 84.4% TOTAL PUBLIC SAFETY COMM CENTER 580,554 0 580,554 394,743.67 .00 185,810.33 68.0% 220 FIRE RESCUE DEPARTMENT _________________________________________ 12201 FIRE RESCUE - PS 5,325,548 -53,970 5,271,578 3,604,387.92 .00 1,667,190.08 68.4% 12202 FIRE RESCUE - OM 640,930 74,574 715,504 339,564.86 .00 375,939.08 47.5% TOTAL FIRE RESCUE DEPARTMENT 5,966,478 20,604 5,987,082 3,943,952.78 .00 2,043,129.16 65.9% 241 BUILDING INSPECTORS _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 241 BUILDING INSPECTORS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 12411 BUILDING INSPECTORS-PS 425,794 1,800 427,594 261,649.53 .00 165,944.47 61.2% 12412 BUILDING INSPECTORS-OM 26,500 -1,800 24,700 10,008.09 .00 14,691.91 40.5% TOTAL BUILDING INSPECTORS 452,294 0 452,294 271,657.62 .00 180,636.38 60.1% 291 EMERGENGY MANAGEMENT _________________________________________ 12911 EMERGENCY MANAGEMENT-PS 6,000 0 6,000 4,500.00 .00 1,500.00 75.0% 12912 EMERGENCY MANAGEMENT-OM 1,550 0 1,550 .00 .00 1,550.00 .0% TOTAL EMERGENGY MANAGEMENT 7,550 0 7,550 4,500.00 .00 3,050.00 59.6% 411 ENGINEERING _________________________________________ 14111 ENGINEERING-PS 138,561 0 138,561 93,151.90 .00 45,409.10 67.2% 14112 ENGINEERING-OM 11,900 0 11,900 8,901.36 .00 2,998.64 74.8% TOTAL ENGINEERING 150,461 0 150,461 102,053.26 .00 48,407.74 67.8% 421 DPW-ADMINISTRATION _________________________________________ 14211 DPW ADMINISTRATION-PS 96,044 261 96,305 68,948.39 .00 27,356.61 71.6% 14212 DPW ADMINISTRATION-OM 17,811 -261 17,550 12,303.51 .00 5,246.49 70.1% TOTAL DPW-ADMINISTRATION 113,855 0 113,855 81,251.90 .00 32,603.10 71.4% 422 HIGHWAYS _________________________________________ 14221 HIGHWAYS-PS 942,698 1,236 943,934 544,590.59 .00 399,343.41 57.7% 14222 HIGHWAYS-OM 536,251 86,046 622,297 284,183.14 .00 338,114.02 45.7% 14223 HIGHWAYS-CAP 150,000 111,925 261,925 52,370.94 .00 209,554.36 20.0% TOTAL HIGHWAYS 1,628,949 199,207 1,828,156 881,144.67 .00 947,011.79 48.2% 423 SNOW & ICE _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 423 SNOW & ICE APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 14231 SNOW & ICE-PS 131,000 0 131,000 218,196.77 .00 -87,196.77 166.6% 14232 SNOW & ICE-OM 340,500 0 340,500 450,020.05 .00 -109,520.05 132.2% TOTAL SNOW & ICE 471,500 0 471,500 668,216.82 .00 -196,716.82 141.7% 481 PARKING _________________________________________ 14811 PARKING-PS 207,229 -3,000 204,229 145,324.09 .00 58,904.91 71.2% 14812 PARKING-OM 240,521 3,000 243,521 110,697.65 .00 132,823.35 45.5% 14813 PARKING-CAP 53,500 0 53,500 39,108.11 .00 14,391.89 73.1% TOTAL PARKING 501,250 0 501,250 295,129.85 .00 206,120.15 58.9% 491 CEMETERY _________________________________________ 14911 CEMETERY-PS 163,696 0 163,696 115,142.95 .00 48,553.05 70.3% 14912 CEMETERY-OM 38,500 0 38,500 24,736.27 .00 13,763.73 64.3% TOTAL CEMETERY 202,196 0 202,196 139,879.22 .00 62,316.78 69.2% 492 DPW PARKS & RECREATION _________________________________________ 14921 DPW PARKS & RECREATION-PS 272,036 0 272,036 191,650.70 .00 80,385.30 70.5% 14922 DPW PARKS & RECREATION-OM 142,700 0 142,700 76,228.90 .00 66,471.10 53.4% 14923 DPW PARKS & RECREATION-CAP 0 17,676 17,676 .00 .00 17,675.62 .0% TOTAL DPW PARKS & RECREATION 414,736 17,676 432,412 267,879.60 .00 164,532.02 62.0% 511 HEALTH DEPARTMENT _________________________________________ 15111 HEALTH DEPARTMENT - PS 237,756 2,160 239,916 156,803.17 .00 83,112.83 65.4% 15112 HEALTH DEPARTMENT - OM 35,870 -2,160 33,710 22,804.83 .00 10,905.17 67.7% TOTAL HEALTH DEPARTMENT 273,626 0 273,626 179,608.00 .00 94,018.00 65.6% 541 SENIOR SERVICES _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 541 SENIOR SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 15411 SENIOR SERVICES -PS 219,691 0 219,691 195,654.73 .00 24,036.27 89.1% 15412 SENIOR SERVICES - OM 10,264 0 10,264 9,993.77 .00 270.23 97.4% TOTAL SENIOR SERVICES 229,955 0 229,955 205,648.50 .00 24,306.50 89.4% 543 VETERANS' SERVICE _________________________________________ 15431 VETERANS' SERVICE-PS 168,823 1,080 169,903 111,024.45 .00 58,878.55 65.3% 15432 VETERANS' SERVICE-OM 756,703 -1,080 755,623 488,464.49 .00 267,158.51 64.6% TOTAL VETERANS' SERVICE 925,526 0 925,526 599,488.94 .00 326,037.06 64.8% 610 FORBES LIBRARY _________________________________________ 16101 FORBES LIBRARY-PS 1,087,436 0 1,087,436 996,816.37 .00 90,619.63 91.7% 16102 FORBES LIBRARY-OM 185,749 0 185,749 174,865.98 .00 10,883.02 94.1% TOTAL FORBES LIBRARY 1,273,185 0 1,273,185 1,171,682.35 .00 101,502.65 92.0% 611 LILLY LIBRARY _________________________________________ 16111 LILLY LIBRARY-PS 234,788 0 234,788 215,222.37 .00 19,565.63 91.7% 16112 LILLY LIBRARY-OM 83,518 0 83,518 76,558.13 .00 6,959.87 91.7% TOTAL LILLY LIBRARY 318,306 0 318,306 291,780.50 .00 26,525.50 91.7% 630 PARKS & RECREATION DEPARTMENT _________________________________________ 16301 PARKS & RECREATION - PS 212,122 1,320 213,442 191,800.55 .00 21,641.45 89.9% 16302 PARKS & RECREATION-OM 19,320 -1,320 18,000 15,008.57 .00 2,991.43 83.4% TOTAL PARKS & RECREATION DEPARTMENT 231,442 0 231,442 206,809.12 .00 24,632.88 89.4% 699 ARTS AND CULTURE _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 699 ARTS AND CULTURE APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 16991 ARTS & CULTURE-PS 50,155 540 50,695 36,192.06 .00 14,502.94 71.4% 16992 ARTS & CULTURE-OM 15,790 -540 15,250 13,250.00 .00 2,000.00 86.9% TOTAL ARTS AND CULTURE 65,945 0 65,945 49,442.06 .00 16,502.94 75.0% 710 MUNICIPAL INDEBTEDNESS _________________________________________ 17103 MUNICIPAL DEBT SERVICE 4,259,100 0 4,259,100 3,076,600.00 .00 1,182,500.00 72.2% TOTAL MUNICIPAL INDEBTEDNESS 4,259,100 0 4,259,100 3,076,600.00 .00 1,182,500.00 72.2% 750 INTEREST ON DEBT _________________________________________ 17503 INTEREST ON MUNICIPAL DEBT 1,095,450 0 1,095,450 666,061.05 .00 429,388.95 60.8% TOTAL INTEREST ON DEBT 1,095,450 0 1,095,450 666,061.05 .00 429,388.95 60.8% 911 CONTRIBUTORY RETIREMENT _________________________________________ 19111 CONTRIBUTORY RETIREMENT-PS 5,686,580 0 5,686,580 5,675,846.26 .00 10,733.74 99.8% 19112 CONTRIBUTORY RETIREMENT-OM 10,000 0 10,000 9,550.00 .00 450.00 95.5% TOTAL CONTRIBUTORY RETIREMENT 5,696,580 0 5,696,580 5,685,396.26 .00 11,183.74 99.8% 912 WORKERS' COMP INSURANCE _________________________________________ 19121 WORKERS' COMP INSURANCE 448,315 0 448,315 446,227.30 .00 2,087.70 99.5% 19122 WORKERS' COMP INSURANCE 200,405 0 200,405 192,844.00 .00 7,561.00 96.2% TOTAL WORKERS' COMP INSURANCE 648,720 0 648,720 639,071.30 .00 9,648.70 98.5% 913 UNEMPLOYMENT INSURANCE _________________________________________ 19131 UNEMPLOYMENT INSURANCE 105,000 0 105,000 25,543.77 .00 79,456.23 24.3% 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 8 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 19132 UNEMPLOYMENT INSURANCE 12,000 0 12,000 8,240.00 .00 3,760.00 68.7% TOTAL UNEMPLOYMENT INSURANCE 117,000 0 117,000 33,783.77 .00 83,216.23 28.9% 914 MEDICAL INSURANCE _________________________________________ 19141 MEDICAL INSURANCE 11,157,372 247,905 11,405,277 8,071,938.49 .00 3,333,338.51 70.8% 19142 MEDICAL INSURANCE 15,000 0 15,000 .00 .00 15,000.00 .0% TOTAL MEDICAL INSURANCE 11,172,372 247,905 11,420,277 8,071,938.49 .00 3,348,338.51 70.7% 919 OTHER EMPLOYEE BENEFITS _________________________________________ 19191 OTHER EMPLOYEE BENEFITS 1,233,016 0 1,233,016 817,435.26 .00 415,580.74 66.3% TOTAL OTHER EMPLOYEE BENEFITS 1,233,016 0 1,233,016 817,435.26 .00 415,580.74 66.3% 920 CHERRY SHEET ASSESSMENTS _________________________________________ 19202 CHERRY SHEET ASSESSMENTS 3,511,716 -30,283 3,481,433 2,630,930.00 .00 850,503.00 75.6% TOTAL CHERRY SHEET ASSESSMENTS 3,511,716 -30,283 3,481,433 2,630,930.00 .00 850,503.00 75.6% 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 312,500 8,142,362 8,454,862 2,231,086.81 40,000.00 6,183,775.42 26.9% TOTAL CAPITAL IMPROVEMENTS 312,500 8,142,362 8,454,862 2,231,086.81 40,000.00 6,183,775.42 26.9% 943 RESERVE FOR PERSONNEL _________________________________________ 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 9 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 943 RESERVE FOR PERSONNEL APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 19491 RESERVE FOR PERSONNEL 185,000 0 185,000 65,904.81 .00 119,095.19 35.6% TOTAL RESERVE FOR PERSONNEL 185,000 0 185,000 65,904.81 .00 119,095.19 35.6% 945 GENERAL LIABILITY INS. _________________________________________ 19452 GENERAL LIABILITY INSURANCE 372,817 0 372,817 357,649.00 .00 15,168.00 95.9% TOTAL GENERAL LIABILITY INS. 372,817 0 372,817 357,649.00 .00 15,168.00 95.9% GRAND TOTAL 53,999,693 8,795,373 62,795,066 41,393,496.60 53,285.61 21,348,284.08 66.0% ** END OF REPORT - Generated by Susan Wright ** 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 10 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Field # Total Page Break Sequence 1 3 Y N Sequence 2 9 Y N Sequence 3 0 N N Sequence 4 0 N N Report title: THIRD QUARTER - EXPENDITURES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2018/ 9 Print Full or Short description: F Print MTD Version: N Print full GL account: N Format type: 1 Roll projects to object: N Double space: N Carry forward code: 1 Suppress zero bal accts: Y Include requisition amount: N Print Revenues-Version headings: N Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: N Print journal detail: N From Yr/Per: 2016/ 9 To Yr/Per: 2016/ 9 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: D Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Fund 0100 FUNCTION <>3 DEPARTMENT DOE BUDGET CAT LOCATION CURR/GRANT GRADE Character Code Org Object Project Account type Expense 04/11/2018 15:42 |CITY OF NORTHAMPTON, MA - LIVE |P 11 1281swri |THIRD QUARTER - EXPENDITURES |glytdbud GENERAL FUND REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code