Loading...
Expenditures - General Fund - Second Quarter 01/16/2018 11:43 |City of Northampton |P 1 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 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 52,116.36 .00 81,556.64 39.0% 11112 CITY COUNCIL-OM 51,400 0 51,400 47,676.80 .00 3,723.20 92.8% TOTAL CITY COUNCIL 185,073 0 185,073 99,793.16 .00 85,279.84 53.9% 121 MAYOR _________________________________________ 11211 MAYOR-PS 435,782 1,620 437,402 204,502.82 .00 232,899.18 46.8% 11212 MAYOR-OM 18,062 1,380 19,442 10,729.50 .00 8,712.50 55.2% TOTAL MAYOR 453,844 3,000 456,844 215,232.32 .00 241,611.68 47.1% 135 AUDITOR _________________________________________ 11351 AUDITOR-PS 289,417 0 289,417 135,842.72 .00 153,574.28 46.9% 11352 AUDITOR-OM 5,280 4,820 10,100 1,807.65 .00 8,292.35 17.9% TOTAL AUDITOR 294,697 4,820 299,517 137,650.37 .00 161,866.63 46.0% 141 ASSESSOR _________________________________________ 11411 ASSESSOR-PS 152,963 0 152,963 73,026.29 .00 79,936.71 47.7% 11412 ASSESSOR-OM 89,850 100,118 189,968 49,374.35 .00 140,593.65 26.0% TOTAL ASSESSOR 242,813 100,118 342,931 122,400.64 .00 220,530.36 35.7% 146 COLLECTOR _________________________________________ 11461 COLLECTOR-PS 341,502 0 341,502 160,211.60 .00 181,290.40 46.9% 11462 COLLECTOR-OM 201,185 0 201,185 87,909.11 .00 113,275.89 43.7% TOTAL COLLECTOR 542,687 0 542,687 248,120.71 .00 294,566.29 45.7% 151 LEGAL SERVICES _________________________________________ 01/16/2018 11:43 |City of Northampton |P 2 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 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 40,757.79 .00 234,242.21 14.8% TOTAL LEGAL SERVICES 275,000 0 275,000 40,757.79 .00 234,242.21 14.8% 152 HUMAN RESOURCES _________________________________________ 11521 HUMAN RESOURCES-PS 245,595 0 245,595 141,231.65 .00 104,363.35 57.5% 11522 HUMAN RESOURCES-OM 5,550 0 5,550 1,905.37 .00 3,644.63 34.3% TOTAL HUMAN RESOURCES 251,145 0 251,145 143,137.02 .00 108,007.98 57.0% 155 INFORMATION TECHNOLOGY _________________________________________ 11551 INFORMATION TECHNOLOGY - PS 323,474 0 323,474 133,410.49 .00 190,063.51 41.2% 11552 INFORMATION TECHNOLOGY - OM 436,975 0 436,975 237,776.78 116,634.07 82,564.15 81.1% TOTAL INFORMATION TECHNOLOGY 760,449 0 760,449 371,187.27 116,634.07 272,627.66 64.1% 161 CITY CLERK _________________________________________ 11611 CITY CLERK-PS 191,371 0 191,371 86,107.88 .00 105,263.12 45.0% 11612 CITY CLERK-OM 75,425 0 75,425 32,284.59 .00 43,140.41 42.8% TOTAL CITY CLERK 266,796 0 266,796 118,392.47 .00 148,403.53 44.4% 162 ELECTIONS _________________________________________ 11621 ELECTIONS-PS 0 0 0 .00 .00 .00 .0% 11622 ELECTIONS-OM 0 0 0 3,413.70 .00 -3,413.70 100.0% TOTAL ELECTIONS 0 0 0 3,413.70 .00 -3,413.70 100.0% 175 PLANNING & SUSTAINABILITY _________________________________________ 01/16/2018 11:43 |City of Northampton |P 3 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 175 PLANNING & SUSTAINABILITY APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11751 PLANNING & SUSTAINABILITY - P 316,207 540 316,747 146,468.23 .00 170,278.77 46.2% 11752 PLANNING & SUSTAINABILITY -OM 44,023 -480 43,543 21,184.91 .00 22,358.09 48.7% TOTAL PLANNING & SUSTAINABILITY 360,230 60 360,290 167,653.14 .00 192,636.86 46.5% 192 CENTRAL SERVICES _________________________________________ 11921 CENTRAL SERVICES-PS 552,549 -9,530 543,019 309,793.80 .00 233,225.20 57.1% 11922 CENTRAL SERVICES-OM 953,913 21,080 974,993 438,419.51 .00 536,573.09 45.0% TOTAL CENTRAL SERVICES 1,506,462 11,550 1,518,012 748,213.31 .00 769,798.29 49.3% 210 POLICE _________________________________________ 12101 POLICE-PS 5,401,637 -58,025 5,343,612 2,311,741.89 .00 3,031,870.11 43.3% 12102 POLICE-OM 500,966 82,380 583,346 198,525.54 .00 384,820.55 34.0% 12103 POLICE-CAP 315,475 53,999 369,474 64,715.97 .00 304,758.38 17.5% TOTAL POLICE 6,218,078 78,354 6,296,432 2,574,983.40 .00 3,721,449.04 40.9% 211 PARKING ENFORCEMENT _________________________________________ 12111 PARKING ENFORCEMENT-PS 194,718 -3,700 191,018 82,832.99 .00 108,185.01 43.4% 12112 PARKING ENFORCEMENT-OM 8,500 3,700 12,200 4,140.19 .00 8,059.81 33.9% TOTAL PARKING ENFORCEMENT 203,218 0 203,218 86,973.18 .00 116,244.82 42.8% 212 PUBLIC SAFETY COMM CENTER _________________________________________ 12121 PUBLIC SAFETY COMM CTR-PS 533,374 -2,475 530,899 213,977.03 .00 316,921.97 40.3% 12122 PUBLIC SAFETY COMM CTR-OM 47,180 2,475 49,655 32,377.60 .00 17,277.40 65.2% TOTAL PUBLIC SAFETY COMM CENTER 580,554 0 580,554 246,354.63 .00 334,199.37 42.4% 220 FIRE RESCUE DEPARTMENT _________________________________________ 01/16/2018 11:43 |City of Northampton |P 4 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 220 FIRE RESCUE DEPARTMENT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 12201 FIRE RESCUE - PS 5,325,548 -53,970 5,271,578 2,571,517.10 .00 2,700,060.90 48.8% 12202 FIRE RESCUE - OM 640,930 74,574 715,504 224,183.25 .00 491,320.69 31.3% TOTAL FIRE RESCUE DEPARTMENT 5,966,478 20,604 5,987,082 2,795,700.35 .00 3,191,381.59 46.7% 241 BUILDING INSPECTORS _________________________________________ 12411 BUILDING INSPECTORS-PS 425,794 1,800 427,594 177,877.95 .00 249,716.05 41.6% 12412 BUILDING INSPECTORS-OM 26,500 -1,800 24,700 6,436.66 .00 18,263.34 26.1% TOTAL BUILDING INSPECTORS 452,294 0 452,294 184,314.61 .00 267,979.39 40.8% 291 EMERGENGY MANAGEMENT _________________________________________ 12911 EMERGENCY MANAGEMENT-PS 6,000 0 6,000 3,000.00 .00 3,000.00 50.0% 12912 EMERGENCY MANAGEMENT-OM 1,550 0 1,550 .00 .00 1,550.00 .0% TOTAL EMERGENGY MANAGEMENT 7,550 0 7,550 3,000.00 .00 4,550.00 39.7% 411 ENGINEERING _________________________________________ 14111 ENGINEERING-PS 138,561 0 138,561 69,526.74 .00 69,034.26 50.2% 14112 ENGINEERING-OM 11,900 0 11,900 7,940.78 .00 3,959.22 66.7% TOTAL ENGINEERING 150,461 0 150,461 77,467.52 .00 72,993.48 51.5% 421 DPW-ADMINISTRATION _________________________________________ 14211 DPW ADMINISTRATION-PS 96,044 261 96,305 46,910.82 .00 49,394.18 48.7% 14212 DPW ADMINISTRATION-OM 17,811 -261 17,550 8,177.91 .00 9,372.09 46.6% TOTAL DPW-ADMINISTRATION 113,855 0 113,855 55,088.73 .00 58,766.27 48.4% 422 HIGHWAYS _________________________________________ 01/16/2018 11:43 |City of Northampton |P 5 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 422 HIGHWAYS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 14221 HIGHWAYS-PS 942,698 1,236 943,934 385,069.98 .00 558,864.02 40.8% 14222 HIGHWAYS-OM 536,251 86,046 622,297 189,813.52 .00 432,483.64 30.5% 14223 HIGHWAYS-CAP 150,000 111,925 261,925 41,897.18 .00 220,028.12 16.0% TOTAL HIGHWAYS 1,628,949 199,207 1,828,156 616,780.68 .00 1,211,375.78 33.7% 423 SNOW & ICE _________________________________________ 14231 SNOW & ICE-PS 131,000 0 131,000 46,353.11 .00 84,646.89 35.4% 14232 SNOW & ICE-OM 340,500 0 340,500 101,812.80 .00 238,687.20 29.9% TOTAL SNOW & ICE 471,500 0 471,500 148,165.91 .00 323,334.09 31.4% 481 PARKING _________________________________________ 14811 PARKING-PS 207,229 -3,000 204,229 95,590.97 .00 108,638.03 46.8% 14812 PARKING-OM 240,521 3,000 243,521 87,890.17 .00 155,630.83 36.1% 14813 PARKING-CAP 53,500 0 53,500 31,694.68 .00 21,805.32 59.2% TOTAL PARKING 501,250 0 501,250 215,175.82 .00 286,074.18 42.9% 491 CEMETERY _________________________________________ 14911 CEMETERY-PS 163,696 0 163,696 77,551.92 .00 86,144.08 47.4% 14912 CEMETERY-OM 38,500 0 38,500 14,413.01 .00 24,086.99 37.4% TOTAL CEMETERY 202,196 0 202,196 91,964.93 .00 110,231.07 45.5% 492 DPW PARKS & RECREATION _________________________________________ 14921 DPW PARKS & RECREATION-PS 272,036 0 272,036 132,763.40 .00 139,272.60 48.8% 14922 DPW PARKS & RECREATION-OM 142,700 0 142,700 59,058.81 .00 83,641.19 41.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 191,822.21 .00 240,589.41 44.4% 511 HEALTH DEPARTMENT _________________________________________ 01/16/2018 11:43 |City of Northampton |P 6 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 511 HEALTH DEPARTMENT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 15111 HEALTH DEPARTMENT - PS 237,756 2,160 239,916 101,873.24 .00 138,042.76 42.5% 15112 HEALTH DEPARTMENT - OM 35,870 -2,160 33,710 18,806.36 .00 14,903.64 55.8% TOTAL HEALTH DEPARTMENT 273,626 0 273,626 120,679.60 .00 152,946.40 44.1% 541 SENIOR SERVICES _________________________________________ 15411 SENIOR SERVICES -PS 219,691 0 219,691 132,186.52 .00 87,504.48 60.2% 15412 SENIOR SERVICES - OM 10,264 0 10,264 9,480.06 .00 783.94 92.4% TOTAL SENIOR SERVICES 229,955 0 229,955 141,666.58 .00 88,288.42 61.6% 543 VETERANS' SERVICE _________________________________________ 15431 VETERANS' SERVICE-PS 168,823 1,080 169,903 75,399.47 .00 94,503.53 44.4% 15432 VETERANS' SERVICE-OM 756,703 -1,080 755,623 274,104.21 .00 481,518.79 36.3% TOTAL VETERANS' SERVICE 925,526 0 925,526 349,503.68 .00 576,022.32 37.8% 610 FORBES LIBRARY _________________________________________ 16101 FORBES LIBRARY-PS 1,087,436 0 1,087,436 634,337.69 .00 453,098.31 58.3% 16102 FORBES LIBRARY-OM 185,749 0 185,749 131,334.02 .00 54,414.98 70.7% TOTAL FORBES LIBRARY 1,273,185 0 1,273,185 765,671.71 .00 507,513.29 60.1% 611 LILLY LIBRARY _________________________________________ 16111 LILLY LIBRARY-PS 234,788 0 234,788 136,959.69 .00 97,828.31 58.3% 16112 LILLY LIBRARY-OM 83,518 0 83,518 48,718.81 .00 34,799.19 58.3% TOTAL LILLY LIBRARY 318,306 0 318,306 185,678.50 .00 132,627.50 58.3% 630 PARKS & RECREATION DEPARTMENT _________________________________________ 01/16/2018 11:43 |City of Northampton |P 7 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 630 PARKS & RECREATION DEPARTMENT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 16301 PARKS & RECREATION - PS 212,122 1,320 213,442 128,889.70 .00 84,552.30 60.4% 16302 PARKS & RECREATION-OM 19,320 -1,320 18,000 6,788.94 .00 11,211.06 37.7% TOTAL PARKS & RECREATION DEPARTMENT 231,442 0 231,442 135,678.64 .00 95,763.36 58.6% 699 ARTS AND CULTURE _________________________________________ 16991 ARTS & CULTURE-PS 50,155 540 50,695 24,482.88 .00 26,212.12 48.3% 16992 ARTS & CULTURE-OM 15,790 -540 15,250 3,250.00 .00 12,000.00 21.3% TOTAL ARTS AND CULTURE 65,945 0 65,945 27,732.88 .00 38,212.12 42.1% 710 MUNICIPAL INDEBTEDNESS _________________________________________ 17103 MUNICIPAL DEBT SERVICE 4,259,100 0 4,259,100 2,921,600.00 .00 1,337,500.00 68.6% TOTAL MUNICIPAL INDEBTEDNESS 4,259,100 0 4,259,100 2,921,600.00 .00 1,337,500.00 68.6% 750 INTEREST ON DEBT _________________________________________ 17503 INTEREST ON MUNICIPAL DEBT 1,095,450 0 1,095,450 535,714.80 .00 559,735.20 48.9% TOTAL INTEREST ON DEBT 1,095,450 0 1,095,450 535,714.80 .00 559,735.20 48.9% 911 CONTRIBUTORY RETIREMENT _________________________________________ 19111 CONTRIBUTORY RETIREMENT-PS 5,686,580 0 5,686,580 5,668,119.16 .00 18,460.84 99.7% 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,677,669.16 .00 18,910.84 99.7% 912 WORKERS' COMP INSURANCE _________________________________________ 19121 WORKERS' COMP INSURANCE 448,315 0 448,315 446,227.30 .00 2,087.70 99.5% 01/16/2018 11:43 |City of Northampton |P 8 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 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 26,720.77 .00 78,279.23 25.4% 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 34,960.77 .00 82,039.23 29.9% 914 MEDICAL INSURANCE _________________________________________ 19141 MEDICAL INSURANCE 11,157,372 247,905 11,405,277 5,490,027.91 .00 5,915,249.09 48.1% 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 5,490,027.91 .00 5,930,249.09 48.1% 919 OTHER EMPLOYEE BENEFITS _________________________________________ 19191 OTHER EMPLOYEE BENEFITS 1,233,016 0 1,233,016 441,477.26 .00 791,538.74 35.8% TOTAL OTHER EMPLOYEE BENEFITS 1,233,016 0 1,233,016 441,477.26 .00 791,538.74 35.8% 920 CHERRY SHEET ASSESSMENTS _________________________________________ 19202 CHERRY SHEET ASSESSMENTS 3,511,716 -30,283 3,481,433 1,746,488.00 .00 1,734,945.00 50.2% TOTAL CHERRY SHEET ASSESSMENTS 3,511,716 -30,283 3,481,433 1,746,488.00 .00 1,734,945.00 50.2% 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% 01/16/2018 11:43 |City of Northampton |P 9 1281swri |EXPENDITURES |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 930 CAPITAL IMPROVEMENTS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 930 CAPITAL IMPROVEMENTS _________________________________________ 19303 CAPITAL IMPROVEMENTS 312,500 5,334,188 5,646,688 2,052,610.75 .00 3,594,076.99 36.4% TOTAL CAPITAL IMPROVEMENTS 312,500 5,334,188 5,646,688 2,052,610.75 .00 3,594,076.99 36.4% 943 RESERVE FOR PERSONNEL _________________________________________ 19491 RESERVE FOR PERSONNEL 185,000 0 185,000 42,664.04 .00 142,335.96 23.1% TOTAL RESERVE FOR PERSONNEL 185,000 0 185,000 42,664.04 .00 142,335.96 23.1% 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 5,987,199 59,986,892 31,397,410.45 116,634.07 28,472,847.28 52.5% ** END OF REPORT - Generated by Susan Wright ** 01/16/2018 11:43 |City of Northampton |P 10 1281swri |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: EXPENDITURES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2018/ 6 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 01/16/2018 11:43 |City of Northampton |P 11 1281swri |EXPENDITURES |glytdbud GENERAL FUND REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code