Melrose Fiscal Year Budget

Download as pdf or txt
Download as pdf or txt
You are on page 1of 67

05/04/2017 10:01 |CITY OF MELROSE v10.

5 |P 1

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
112 ALDERMANIC

____________________________________________
51 SALARIES

011121 511000 S & W 119,485.64 123,596.30 134,038.26 117,108.62 123,596.30 112,455.81 -9.0%

TOTAL SALARIES 119,485.64 123,596.30 134,038.26 117,108.62 123,596.30 112,455.81 -9.0%

____________________________________________
52 CONTRACTUAL

011122 520500 ADVERTIS .00 125.00 125.00 .00 125.00 125.00 .0%

011122 521000 PRINTING 47.00 500.00 500.00 139.99 500.00 500.00 .0%

011122 523100 EXPENSES 11,000.00 11,000.00 11,000.00 8,666.76 11,000.00 11,000.00 .0%

011122 525308 IQM2 CONTR 10,080.00 10,080.00 10,080.00 10,080.00 10,080.00 10,080.00 .0%

011122 525401 WEBSITE .00 .00 35,000.00 .00 .00 7,000.00 .0%

TOTAL CONTRACTUAL 21,127.00 21,705.00 56,705.00 18,886.75 21,705.00 28,705.00 32.3%

TOTAL ALDERMANIC 140,612.64 145,301.30 190,743.26 135,995.37 145,301.30 141,160.81 -2.8%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 2

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
121 MAYOR

____________________________________________
51 SALARIES

011211 511000 S & W 252,178.16 269,731.82 269,731.82 229,612.30 269,731.82 268,042.68 -.6%

TOTAL SALARIES 252,178.16 269,731.82 269,731.82 229,612.30 269,731.82 268,042.68 -.6%

____________________________________________
52 CONTRACTUAL

011212 521000 PRINTING 1,495.00 750.00 750.00 333.00 750.00 750.00 .0%

011212 523100 EXP ACCT 7,000.24 7,000.00 7,000.00 6,057.90 7,000.00 7,000.00 .0%

011212 529000 PROF SERV 5,280.00 5,900.00 5,900.00 3,960.00 5,900.00 5,900.00 .0%

TOTAL CONTRACTUAL 13,775.24 13,650.00 13,650.00 10,350.90 13,650.00 13,650.00 .0%

____________________________________________
54 OTHER CHARGES

011212 540500 DUES/MEMB 16,852.00 16,900.00 16,900.00 16,649.00 16,900.00 16,900.00 .0%

011212 540600 EDUC/SEMIN 861.13 2,134.00 2,134.00 1,075.00 2,599.13 2,134.00 .0%

011212 548950 COMM OUTRE 14,230.50 13,500.00 13,500.00 10,035.66 13,500.00 13,500.00 .0%

TOTAL OTHER CHARGES 31,943.63 32,534.00 32,534.00 27,759.66 32,999.13 32,534.00 .0%

TOTAL MAYOR 297,897.03 315,915.82 315,915.82 267,722.86 316,380.95 314,226.68 -.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 3

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
135 AUDITOR

____________________________________________
51 SALARIES

011351 511000 S & W 341,011.97 308,564.52 308,946.86 260,485.06 308,564.52 309,274.33 .2%

011351 513000 OVERTIME .00 125.00 125.00 304.30 125.00 .00 -100.0%

TOTAL SALARIES 341,011.97 308,689.52 309,071.86 260,789.36 308,689.52 309,274.33 .2%

____________________________________________
52 CONTRACTUAL

011352 528600 AUDIT SERV 35,640.00 41,640.00 41,640.00 31,640.00 49,608.00 41,640.00 .0%

011352 529000 PROF SERV 699.00 7,000.00 7,000.00 6,725.00 20,750.00 3,500.00 -50.0%

TOTAL CONTRACTUAL 36,339.00 48,640.00 48,640.00 38,365.00 70,358.00 45,140.00 -7.2%

____________________________________________
54 OTHER CHARGES

011352 540500 DUES/MEMB 85.00 200.00 200.00 35.00 200.00 200.00 .0%

011352 540600 EDUC/SEMIN 425.85 500.00 500.00 421.92 500.00 500.00 .0%

TOTAL OTHER CHARGES 510.85 700.00 700.00 456.92 700.00 700.00 .0%

TOTAL AUDITOR 377,861.82 358,029.52 358,411.86 299,611.28 379,747.52 355,114.33 -.8%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 4

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
141 ASSESSORS

____________________________________________
51 SALARIES

011411 511000 S & W 196,675.94 187,052.72 188,605.71 159,019.93 187,052.72 198,146.32 5.9%

TOTAL SALARIES 196,675.94 187,052.72 188,605.71 159,019.93 187,052.72 198,146.32 5.9%

____________________________________________
52 CONTRACTUAL

011412 521000 PRINTING 82.00 250.00 250.00 22.96 250.00 250.00 .0%

011412 523000 MILEAGE 237.00 250.00 250.00 299.65 250.00 250.00 .0%

011412 528000 FEES .00 300.00 300.00 .00 300.00 300.00 .0%

011412 529000 PROF SERV 894.95 40,500.00 40,500.00 .00 40,500.00 50,500.00 24.7%

011412 529300 REVAL 138,933.96 97,500.00 97,500.00 53,901.67 126,450.00 87,500.00 -10.3%

TOTAL CONTRACTUAL 140,147.91 138,800.00 138,800.00 54,224.28 167,750.00 138,800.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

011412 530200 COPY SUP 99.00 200.00 200.00 .00 200.00 200.00 .0%

TOTAL SUPPLIES AND MATERIA 99.00 200.00 200.00 .00 200.00 200.00 .0%

____________________________________________
54 OTHER CHARGES

011412 540500 DUES/MEMB 170.00 350.00 350.00 305.00 350.00 350.00 .0%

011412 540600 EDUC/SEMIN 1,397.15 2,000.00 2,000.00 30.00 2,000.00 2,000.00 .0%

011412 540700 SEMINARS 50.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%

TOTAL OTHER CHARGES 1,617.15 3,350.00 3,350.00 335.00 3,350.00 3,350.00 .0%

TOTAL ASSESSORS 338,540.00 329,402.72 330,955.71 213,579.21 358,352.72 340,496.32 3.4%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 5

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
145 TREASURER/COLLECTOR

____________________________________________
51 SALARIES

011451 511000 S & W 291,972.98 308,465.41 310,756.79 263,635.69 308,465.41 338,661.51 9.8%

TOTAL SALARIES 291,972.98 308,465.41 310,756.79 263,635.69 308,465.41 338,661.51 9.8%

____________________________________________
52 CONTRACTUAL

011452 521000 PRINTING 4,160.22 10,000.00 10,000.00 1,180.42 14,000.00 10,000.00 .0%

011452 521500 POSTAGE 35,483.31 40,000.00 40,000.00 37,390.75 42,087.42 40,000.00 .0%

011452 521801 FOLD MAINT 1,084.00 1,200.00 1,200.00 1,138.00 1,200.00 1,200.00 .0%

011452 527600 OFFICE EQU 760.24 1,900.00 1,900.00 2,042.16 1,900.00 1,900.00 .0%

011452 528002 TITLE FEES 9,348.66 4,000.00 4,000.00 75.00 4,387.08 4,000.00 .0%

011452 529000 PROF SERV 7,770.00 10,000.00 10,000.00 4,727.50 10,000.00 10,000.00 .0%

TOTAL CONTRACTUAL 58,606.43 67,100.00 67,100.00 46,553.83 73,574.50 67,100.00 .0%

____________________________________________
54 OTHER CHARGES

011452 540500 DUES/MEMB 100.00 235.00 235.00 100.00 235.00 235.00 .0%

011452 540600 EDUC/SEMIN 405.92 500.00 500.00 .00 500.00 500.00 .0%

011452 544100 SURETY 655.00 800.00 800.00 655.00 800.00 800.00 .0%

TOTAL OTHER CHARGES 1,160.92 1,535.00 1,535.00 755.00 1,535.00 1,535.00 .0%

TOTAL TREASURER/COLLECTOR 351,740.33 377,100.41 379,391.79 310,944.52 383,574.91 407,296.51 8.0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 6

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
151 CITY SOLICITOR

____________________________________________
51 SALARIES

011511 511000 S & W 197,113.12 207,574.69 213,351.80 181,028.46 207,574.69 281,407.13 35.6%

TOTAL SALARIES 197,113.12 207,574.69 213,351.80 181,028.46 207,574.69 281,407.13 35.6%

____________________________________________
52 CONTRACTUAL

011512 523100 EXPENSES 3,920.46 2,475.00 2,475.00 148.00 2,475.00 2,475.00 .0%

011512 529000 PROF SERV 3,416.49 2,475.00 17,475.00 16,457.86 2,475.00 5,000.00 102.0%

TOTAL CONTRACTUAL 7,336.95 4,950.00 19,950.00 16,605.86 4,950.00 7,475.00 51.0%

____________________________________________
53 SUPPLIES AND MATERIA

011512 534200 BOOKS 471.00 495.00 495.00 448.00 495.00 495.00 .0%

011512 534250 ELECT MASS 2,772.29 2,970.00 2,970.00 2,269.06 3,167.71 3,200.00 7.7%

TOTAL SUPPLIES AND MATERIA 3,243.29 3,465.00 3,465.00 2,717.06 3,662.71 3,695.00 6.6%

____________________________________________
54 OTHER CHARGES

011512 540500 DUES/MEMB 905.00 1,980.00 1,980.00 1,109.00 1,980.00 2,710.00 36.9%

011512 540600 EDUC/SEMIN 685.00 990.00 990.00 955.00 990.00 990.00 .0%

011512 544310 PROP INS 460,790.00 487,619.38 487,619.38 479,299.63 487,619.38 512,000.35 5.0%

011512 544500 SUITSCLAIM 5,006.31 10,000.00 10,000.00 3,700.00 15,500.00 10,000.00 .0%

TOTAL OTHER CHARGES 467,386.31 500,589.38 500,589.38 485,063.63 506,089.38 525,700.35 5.0%

____________________________________________
56 MISCELLANEOUS

011512 591015 APFY15 6,901.00 .00 .00 .00 .00 .00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 7

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________

TOTAL MISCELLANEOUS 6,901.00 .00 .00 .00 .00 .00 .0%

TOTAL CITY SOLICITOR 681,980.67 716,579.07 737,356.18 685,415.01 722,276.78 818,277.48 14.2%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 8

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
152 HUMAN RESOURCES

____________________________________________
51 SALARIES

011521 511000 S & W 116,514.28 123,797.43 123,797.43 116,855.57 123,797.43 124,971.84 .9%

TOTAL SALARIES 116,514.28 123,797.43 123,797.43 116,855.57 123,797.43 124,971.84 .9%

____________________________________________
52 CONTRACTUAL

011522 520500 ADVERTISE 4,892.60 3,000.00 3,000.00 3,067.29 3,000.00 3,000.00 .0%

011522 521000 PRINTING 75.09 100.00 100.00 .00 100.00 100.00 .0%

011522 529000 TEACHERS 6,282.96 .00 .00 .00 3,075.00 .00 .0%

TOTAL CONTRACTUAL 11,250.65 3,100.00 3,100.00 3,067.29 6,175.00 3,100.00 .0%

____________________________________________
54 OTHER CHARGES

011522 540500 DUES/MEMB 250.00 250.00 250.00 250.00 250.00 250.00 .0%

011522 540702 TRAINING 1,500.00 .00 .00 .00 .00 .00 .0%

011522 543000 PHYSICAL 3,295.00 7,100.00 7,100.00 6,181.80 7,100.00 7,100.00 .0%

TOTAL OTHER CHARGES 5,045.00 7,350.00 7,350.00 6,431.80 7,350.00 7,350.00 .0%

TOTAL HUMAN RESOURCES 132,809.93 134,247.43 134,247.43 126,354.66 137,322.43 135,421.84 .9%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 9

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
155 INFORMATION TECHNOLOGY

____________________________________________
51 SALARIES

011551 511000 S & W 227,638.54 244,600.97 244,600.97 204,917.46 244,600.97 276,896.45 13.2%

TOTAL SALARIES 227,638.54 244,600.97 244,600.97 204,917.46 244,600.97 276,896.45 13.2%

____________________________________________
52 CONTRACTUAL

011552 522000 TELEPHONE 140,924.33 146,130.56 146,130.56 92,269.15 146,130.56 146,130.56 .0%

011552 522004 WAN COMMUN 5,909.71 4,000.00 4,000.00 235.92 4,000.00 4,000.00 .0%

011552 525105 COMP MAINT 2,240.10 4,000.00 4,000.00 3,791.66 4,000.00 4,000.00 .0%

011552 525106 TEL MAINT 110.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%

011552 525203 NET SERVIC 3,129.99 5,000.00 5,000.00 5,438.97 9,236.35 5,000.00 .0%

011552 525301 MUNIS SUPP 69,643.38 69,643.38 69,643.38 69,643.38 69,643.38 69,643.38 .0%

011552 525303 LICENSES 12,160.21 18,920.00 18,920.00 4,900.00 28,624.04 18,920.00 .0%

011552 525309 OSDBA .00 14,400.00 14,400.00 .00 14,400.00 14,400.00 .0%

011552 529000 PROF SERV 7,888.00 10,000.00 10,000.00 18,726.05 21,350.62 10,000.00 .0%

TOTAL CONTRACTUAL 242,005.72 273,093.94 273,093.94 195,005.13 298,384.95 273,093.94 .0%

____________________________________________
53 SUPPLIES AND MATERIA

011552 530110 COMP PAPER .00 3,000.00 3,000.00 1,977.59 3,000.00 3,000.00 .0%

011552 530120 COMP MISC 3,647.08 2,000.00 2,000.00 2,751.90 2,000.00 2,000.00 .0%

TOTAL SUPPLIES AND MATERIA 3,647.08 5,000.00 5,000.00 4,729.49 5,000.00 5,000.00 .0%

____________________________________________
54 OTHER CHARGES

011552 540700 SEMINARS 400.00 9,500.00 9,500.00 .00 23,594.00 9,500.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 10

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________

TOTAL OTHER CHARGES 400.00 9,500.00 9,500.00 .00 23,594.00 9,500.00 .0%

____________________________________________
56 MISCELLANEOUS

011552 591015 APFY15 32,655.38 .00 .00 .00 .00 .00 .0%

011552 591016 AP FY16 .00 .00 18,000.00 10,710.99 .00 .00 .0%

TOTAL MISCELLANEOUS 32,655.38 .00 18,000.00 10,710.99 .00 .00 .0%

TOTAL INFORMATION TECHNOLOGY 506,346.72 532,194.91 550,194.91 415,363.07 571,579.92 564,490.39 6.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 11

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
161 CITY CLERK

____________________________________________
51 SALARIES

011611 511000 S & W 237,031.37 247,251.30 248,157.62 217,298.30 247,251.30 276,778.54 11.9%

011611 513000 OVERTIME 7,796.35 4,350.00 4,350.00 9,687.19 4,350.00 4,350.00 .0%

TOTAL SALARIES 244,827.72 251,601.30 252,507.62 226,985.49 251,601.30 281,128.54 11.7%

____________________________________________
52 CONTRACTUAL

011612 520500 ADVERTISE 100.35 326.92 326.92 179.44 326.92 326.92 .0%

011612 521000 PRINTING 1,255.13 1,500.00 1,500.00 642.52 1,500.00 1,500.00 .0%

011612 525109 DOG MAINT 535.90 800.00 800.00 669.87 800.00 1,000.00 25.0%

011612 529000 PROF SERV 12,329.25 13,650.00 13,650.00 8,381.00 13,650.00 .00 -100.0%

011612 529301 RECODE -11,120.79 4,000.00 4,000.00 3,897.40 19,120.79 4,000.00 .0%

011612 529400 BINDING 300.43 300.00 300.00 254.77 300.00 300.00 .0%

TOTAL CONTRACTUAL 3,400.27 20,576.92 20,576.92 14,025.00 35,697.71 7,126.92 -65.4%

____________________________________________
53 SUPPLIES AND MATERIA

011612 534200 BOOKS .00 100.00 100.00 77.00 100.00 100.00 .0%

TOTAL SUPPLIES AND MATERIA .00 100.00 100.00 77.00 100.00 100.00 .0%

____________________________________________
54 OTHER CHARGES

011612 540500 DUES/MEMB 50.00 150.00 150.00 110.00 150.00 150.00 .0%

011612 540600 EDUC/SEMIN .00 500.00 500.00 100.00 500.00 500.00 .0%

011612 544100 SURETY 100.00 100.00 100.00 100.00 100.00 100.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 12

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________

TOTAL OTHER CHARGES 150.00 750.00 750.00 310.00 750.00 750.00 .0%

____________________________________________
56 MISCELLANEOUS

011612 560100 VITAL STAT 589.25 800.00 800.00 793.25 800.00 800.00 .0%

TOTAL MISCELLANEOUS 589.25 800.00 800.00 793.25 800.00 800.00 .0%

TOTAL CITY CLERK 248,967.24 273,828.22 274,734.54 242,190.74 288,949.01 289,905.46 5.9%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 13

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
162 ELECTION/REGISTRAR

____________________________________________
51 SALARIES

011621 511000 S & W 4,566.12 4,566.12 4,566.12 3,805.10 4,566.12 4,566.12 .0%

011621 512000 PT S&W 42,225.05 50,000.00 48,719.00 39,964.62 50,000.00 25,000.00 -50.0%

TOTAL SALARIES 46,791.17 54,566.12 53,285.12 43,769.72 54,566.12 29,566.12 -45.8%

____________________________________________
52 CONTRACTUAL

011622 521000 PRINTING 7,499.39 5,500.00 5,500.00 4,413.27 5,500.00 8,000.00 45.5%

011622 521500 POSTAGE 4,522.56 6,500.00 6,500.00 5,735.35 8,257.44 7,500.00 15.4%

011622 525102 ACCU MAINT 7,421.45 7,500.00 7,500.00 4,533.00 7,500.00 4,200.00 -44.0%

011622 525201 PROGRAMMER 6,500.00 3,000.00 3,000.00 2,285.00 3,000.00 2,500.00 -16.7%

011622 529000 PROF SERV 7,668.75 7,700.00 7,700.00 6,303.00 7,700.00 7,700.00 .0%

TOTAL CONTRACTUAL 33,612.15 30,200.00 30,200.00 23,269.62 31,957.44 29,900.00 -1.0%

____________________________________________
53 SUPPLIES AND MATERIA

011622 530506 ELEC SUPP 373.41 800.00 2,081.00 2,041.93 818.62 800.00 .0%

TOTAL SUPPLIES AND MATERIA 373.41 800.00 2,081.00 2,041.93 818.62 800.00 .0%

____________________________________________
54 OTHER CHARGES

011622 540500 DUES/MEMB 150.00 150.00 150.00 150.00 150.00 150.00 .0%

011622 540600 EDUC/SEMIN 487.10 700.00 700.00 257.40 700.00 700.00 .0%

TOTAL OTHER CHARGES 637.10 850.00 850.00 407.40 850.00 850.00 .0%

TOTAL ELECTION/REGISTRAR 81,413.83 86,416.12 86,416.12 69,488.67 88,192.18 61,116.12 -29.3%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 14

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
165 LIQUOR COMMISSION

____________________________________________
52 CONTRACTUAL

011652 529000 PROF SERV 136.65 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%

011652 529027 COMPLIANCE .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%

TOTAL CONTRACTUAL 136.65 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0%

TOTAL LIQUOR COMMISSION 136.65 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 15

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
171 CONSERVATION

____________________________________________
51 SALARIES

011711 511000 SALARIES 8,378.72 9,500.00 9,500.00 7,606.57 9,500.00 9,500.00 .0%

TOTAL SALARIES 8,378.72 9,500.00 9,500.00 7,606.57 9,500.00 9,500.00 .0%

____________________________________________
52 CONTRACTUAL

011712 520500 ADVERTISE 83.50 150.00 150.00 .00 150.00 150.00 .0%

011712 521000 PRINTING 248.40 250.00 250.00 248.40 250.00 250.00 .0%

011712 528810 CONSERV -4,900.00 9,925.00 9,925.00 .00 24,450.00 9,925.00 .0%

TOTAL CONTRACTUAL -4,568.10 10,325.00 10,325.00 248.40 24,850.00 10,325.00 .0%

____________________________________________
54 OTHER CHARGES

011712 540500 DUES/MEMB 630.00 645.00 645.00 643.00 645.00 645.00 .0%

011712 540600 EDUC/SEMIN 135.00 355.00 355.00 152.50 355.00 355.00 .0%

TOTAL OTHER CHARGES 765.00 1,000.00 1,000.00 795.50 1,000.00 1,000.00 .0%

TOTAL CONSERVATION 4,575.62 20,825.00 20,825.00 8,650.47 35,350.00 20,825.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 16

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
175 PLANNING BOARD

____________________________________________
51 SALARIES

011751 511000 S & W 191,123.38 198,553.45 198,553.45 169,299.58 198,553.45 202,793.55 2.1%

TOTAL SALARIES 191,123.38 198,553.45 198,553.45 169,299.58 198,553.45 202,793.55 2.1%

____________________________________________
52 CONTRACTUAL

011752 520500 ADVERTISE 730.00 730.00 730.00 .00 730.00 730.00 .0%

011752 521000 PRINTING 1,030.00 1,030.00 1,030.00 1,030.00 1,030.00 1,030.00 .0%

011752 529000 PROF SERV -25,260.00 .00 20,000.00 .00 25,260.00 .00 .0%

011752 529026 MESSINA AR 4,400.00 10,000.00 10,000.00 2,800.00 15,600.00 10,000.00 .0%

TOTAL CONTRACTUAL -19,100.00 11,760.00 31,760.00 3,830.00 42,620.00 11,760.00 .0%

____________________________________________
54 OTHER CHARGES

011752 540500 DUES/MEMB 300.00 300.00 300.00 .00 300.00 300.00 .0%

011752 540600 EDUC/SEMIN 50.00 50.00 50.00 .00 50.00 50.00 .0%

TOTAL OTHER CHARGES 350.00 350.00 350.00 .00 350.00 350.00 .0%

TOTAL PLANNING BOARD 172,373.38 210,663.45 230,663.45 173,129.58 241,523.45 214,903.55 2.0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 17

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
196 ENERGY COMMISSION

____________________________________________
52 CONTRACTUAL

011962 529000 PROF SERV 2,500.00 2,500.00 2,500.00 1,553.37 2,500.00 2,500.00 .0%

TOTAL CONTRACTUAL 2,500.00 2,500.00 2,500.00 1,553.37 2,500.00 2,500.00 .0%

TOTAL ENERGY COMMISSION 2,500.00 2,500.00 2,500.00 1,553.37 2,500.00 2,500.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 18

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
211 POLICE

____________________________________________
51 SALARIES

012111 511000 S & W 3,456,276.51 3,711,237.75 3,915,449.05 3,301,403.88 3,711,237.75 3,900,377.08 5.1%

012111 513000 OVERTIME 457,013.26 282,000.00 426,047.79 384,552.72 282,000.00 332,000.00 17.7%

012111 514000 COURT TIME 25,832.60 30,000.00 30,000.00 36,457.79 30,000.00 30,000.00 .0%

TOTAL SALARIES 3,939,122.37 4,023,237.75 4,371,496.84 3,722,414.39 4,023,237.75 4,262,377.08 5.9%

____________________________________________
52 CONTRACTUAL

012112 521000 PRINTING 1,340.50 500.00 500.00 1,497.20 500.00 500.00 .0%

012112 521500 POSTAGE 1,407.08 950.00 950.00 1,652.63 950.00 1,400.00 47.4%

012112 523500 LAUNDRY 291.00 300.00 300.00 129.00 300.00 300.00 .0%

012112 525103 LEAPS 730.00 1,240.00 1,240.00 1,240.00 1,240.00 1,240.00 .0%

012112 525108 GENERATOR 307.00 580.00 580.00 198.00 580.00 580.00 .0%

012112 525202 COMP SUPP 18,565.00 16,428.50 16,428.50 16,575.74 16,428.50 18,428.50 12.2%

012112 527305 RADIO SYS 12,441.92 15,800.00 19,125.00 14,381.29 17,871.89 15,800.00 .0%

012112 527601 COPY MAINT 4,365.00 4,395.00 4,395.00 4,290.00 4,395.00 4,395.00 .0%

012112 527700 BLDGREPAIR .00 .00 260.00 1,250.00 .00 .00 .0%

012112 529000 PROF SERV 789.00 200.00 1,120.00 .00 200.00 200.00 .0%

TOTAL CONTRACTUAL 40,236.50 40,393.50 44,898.50 41,213.86 42,465.39 42,843.50 6.1%

____________________________________________
53 SUPPLIES AND MATERIA

012112 530120 COMP MISC 130.08 250.00 250.00 .00 250.00 250.00 .0%

012112 530202 FILM SUP .00 590.00 590.00 .00 590.00 590.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 19

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
012112 530501 MISC SUP 1,181.81 1,600.00 1,600.00 2,352.26 9,600.00 1,600.00 .0%

012112 530505 RADAR 755.50 960.00 960.00 139.36 960.00 960.00 .0%

012112 533400 ACCREDIT 1,250.00 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0%

012112 534200 BOOKS 462.95 1,200.00 1,200.00 437.99 1,200.00 1,200.00 .0%

012112 535400 FOOD 313.45 400.00 400.00 157.15 400.00 400.00 .0%

012112 535500 UNIFORMS 62,967.10 58,750.00 62,132.83 63,084.19 58,750.00 58,750.00 .0%

012112 535600 NARCAN .00 .00 2,000.00 .00 1,000.00 2,000.00 .0%

012112 535700 AMMUNITION 4,736.00 3,000.00 3,000.00 2,838.40 3,500.00 3,750.00 25.0%

TOTAL SUPPLIES AND MATERIA 71,796.89 68,250.00 73,632.83 69,009.35 77,750.00 71,000.00 4.0%

____________________________________________
54 OTHER CHARGES

012112 540500 DUES/MEMB 9,398.95 6,000.00 6,000.00 10,043.00 6,000.00 6,000.00 .0%

012112 540702 TRAINING 20,886.14 25,000.00 28,259.29 14,670.40 25,465.13 25,000.00 .0%

TOTAL OTHER CHARGES 30,285.09 31,000.00 34,259.29 24,713.40 31,465.13 31,000.00 .0%

TOTAL POLICE 4,081,440.85 4,162,881.25 4,524,287.46 3,857,351.00 4,174,918.27 4,407,220.58 5.9%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 20

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
221 FIRE

____________________________________________
51 SALARIES

012211 511000 S & W 3,446,033.22 3,596,442.22 4,180,941.63 3,437,229.80 3,596,442.22 3,754,438.59 4.4%

012211 513000 OVERTIME 479,695.74 315,000.00 448,007.89 523,993.43 315,000.00 365,000.00 15.9%

012211 515000 MUTUAL AID .00 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0%

TOTAL SALARIES 3,925,728.96 3,912,942.22 4,630,449.52 3,961,223.23 3,912,942.22 4,120,938.59 5.3%

____________________________________________
52 CONTRACTUAL

012212 521000 PRINTING 207.50 250.00 250.00 99.00 250.00 250.00 .0%

012212 522000 TELEPHONE .00 400.00 400.00 .00 400.00 .00 -100.0%

012212 526000 WAT COOLER 39.28 700.00 700.00 .00 700.00 .00 -100.0%

012212 527305 RADIO SYS 2,665.62 3,500.00 3,500.00 1,170.13 3,679.53 3,500.00 .0%

012212 527311 LIFE/SAFET 9,314.65 8,900.00 8,900.00 9,012.30 8,900.00 8,900.00 .0%

012212 527500 VEHICLEREP 88,940.33 35,000.00 75,000.00 42,722.92 35,784.81 55,000.00 57.1%

012212 527601 COPY MAINT 708.63 1,050.00 1,050.00 545.10 1,050.00 1,050.00 .0%

012212 527605 FIRE CONTR 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 .0%

012212 527606 RADIO CONT 5,320.45 6,000.00 6,000.00 1,395.87 6,000.00 6,000.00 .0%

012212 527801 RADIO REP 1,841.26 2,000.00 2,000.00 74.20 2,000.00 2,000.00 .0%

012212 529000 PROF SERV 900.00 400.00 400.00 325.00 400.00 400.00 .0%

TOTAL CONTRACTUAL 112,437.72 60,700.00 100,700.00 57,844.52 61,664.34 79,600.00 31.1%

____________________________________________
53 SUPPLIES AND MATERIA

012212 530100 COMP PURCH 1,556.03 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 21

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
012212 530503 PREVENTSUP 972.69 1,000.00 1,000.00 964.53 1,000.00 1,000.00 .0%

012212 531000 GAS & OIL 59.20 500.00 500.00 .00 500.00 500.00 .0%

012212 531200 TIRES 2,367.30 3,000.00 3,000.00 4,071.11 3,000.00 3,000.00 .0%

012212 531500 BATTERIES 416.96 500.00 500.00 450.00 500.00 500.00 .0%

012212 532000 CLEAN SUP 4,802.20 4,800.00 4,800.00 4,369.68 4,800.00 4,800.00 .0%

012212 533000 PAINTS 100.00 100.00 100.00 25.08 100.00 100.00 .0%

012212 533200 ELECTR SUP 364.01 500.00 500.00 59.00 500.00 500.00 .0%

012212 533300 ALARM SYS 3,967.27 5,000.00 5,000.00 3,063.23 6,032.73 5,000.00 .0%

012212 533500 TOOLS 961.74 2,400.00 2,400.00 1,434.15 2,400.00 2,400.00 .0%

012212 534200 BOOKS 406.09 400.00 400.00 .00 400.00 400.00 .0%

012212 535500 UNIFORMS 52,100.00 52,100.00 52,100.00 52,100.00 52,100.00 52,100.00 .0%

012212 535501 CLOTHING 209.00 500.00 500.00 .00 500.00 500.00 .0%

012212 535502 PROTECT CL 1,729.46 2,400.00 2,400.00 1,944.00 2,460.00 2,400.00 .0%

012212 535505 TURNOUT 18,500.00 20,000.00 20,000.00 14,024.75 20,000.00 20,000.00 .0%

TOTAL SUPPLIES AND MATERIA 88,511.95 95,200.00 95,200.00 82,505.53 96,292.73 95,200.00 .0%

____________________________________________
54 OTHER CHARGES

012212 540500 DUES/MEMB 624.00 625.00 625.00 239.00 625.00 625.00 .0%

012212 540600 EDUC/SEMIN 270.00 500.00 500.00 705.00 500.00 500.00 .0%

012212 540700 SEMINARS 438.00 500.00 500.00 69.00 500.00 500.00 .0%

TOTAL OTHER CHARGES 1,332.00 1,625.00 1,625.00 1,013.00 1,625.00 1,625.00 .0%

____________________________________________
56 MISCELLANEOUS

012212 560200 ED REIMB 13,975.60 24,356.00 24,356.00 16,786.45 34,101.00 24,356.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 22

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
012212 568000 FIRE HOSE 2,178.00 3,700.00 3,700.00 208.87 5,022.00 3,700.00 .0%

TOTAL MISCELLANEOUS 16,153.60 28,056.00 28,056.00 16,995.32 39,123.00 28,056.00 .0%

TOTAL FIRE 4,144,164.23 4,098,523.22 4,856,030.52 4,119,581.60 4,111,647.29 4,325,419.59 5.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 23

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
241 INSPECTION SERVICES

____________________________________________
51 SALARIES

012411 511000 S & W 214,633.44 224,730.65 225,681.38 190,657.33 224,730.65 232,975.57 3.7%

012411 513000 OVERTIME 1,149.37 267.70 1,367.70 1,165.85 267.70 267.70 .0%

TOTAL SALARIES 215,782.81 224,998.35 227,049.08 191,823.18 224,998.35 233,243.27 3.7%

____________________________________________
52 CONTRACTUAL

012412 521000 PRINTING 331.25 400.00 400.00 400.00 400.00 400.00 .0%

012412 529000 PROF SERV 21,575.00 21,459.00 25,459.00 22,950.00 21,459.00 21,459.00 .0%

TOTAL CONTRACTUAL 21,906.25 21,859.00 25,859.00 23,350.00 21,859.00 21,859.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

012412 530502 W & M SUP 185.00 250.00 250.00 85.00 250.00 250.00 .0%

012412 534200 BOOKS .00 383.00 1,383.00 207.45 383.00 383.00 .0%

TOTAL SUPPLIES AND MATERIA 185.00 633.00 1,633.00 292.45 633.00 633.00 .0%

____________________________________________
54 OTHER CHARGES

012412 540500 DUES/MEMB 385.00 325.00 525.00 455.00 325.00 325.00 .0%

012412 540600 EDUC/SEMIN 400.00 676.42 676.42 115.00 676.42 676.42 .0%

012412 540700 SEMINARS 210.00 300.00 900.00 280.00 300.00 300.00 .0%

TOTAL OTHER CHARGES 995.00 1,301.42 2,101.42 850.00 1,301.42 1,301.42 .0%

TOTAL INSPECTION SERVICES 238,869.06 248,791.77 256,642.50 216,315.63 248,791.77 257,036.69 3.3%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 24

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
291 EMERGENCY MANAGEMENT

____________________________________________
52 CONTRACTUAL

012912 521000 PRINTING 311.96 350.00 350.00 .00 350.00 350.00 .0%

012912 521500 POSTAGE .00 100.00 100.00 22.95 100.00 100.00 .0%

TOTAL CONTRACTUAL 311.96 450.00 450.00 22.95 450.00 450.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

012912 530703 RADIO .00 1,000.00 1,000.00 1,253.43 2,712.00 1,000.00 .0%

012912 535501 CLOTHING 1,088.00 1,800.00 1,800.00 .00 1,800.00 1,800.00 .0%

TOTAL SUPPLIES AND MATERIA 1,088.00 2,800.00 2,800.00 1,253.43 4,512.00 2,800.00 .0%

____________________________________________
54 OTHER CHARGES

012912 540500 DUES/MEMB .00 150.00 150.00 .00 150.00 150.00 .0%

012912 540702 TRAINING 1,028.00 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0%

TOTAL OTHER CHARGES 1,028.00 1,650.00 1,650.00 .00 1,650.00 1,650.00 .0%

TOTAL EMERGENCY MANAGEMENT 2,427.96 4,900.00 4,900.00 1,276.38 6,612.00 4,900.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 25

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
296 PARKING

____________________________________________
51 SALARIES

012961 511000 S & W 7,836.00 9,125.00 9,125.00 9,965.00 9,125.00 14,260.00 56.3%

TOTAL SALARIES 7,836.00 9,125.00 9,125.00 9,965.00 9,125.00 14,260.00 56.3%

____________________________________________
52 CONTRACTUAL

012962 521000 PRINTING 1,971.87 2,000.00 2,000.00 2,000.00 2,000.00 3,500.00 75.0%

012962 527310 TRAIN STAT 394.46 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 .0%

012962 527950 GROV/MYRTL 18,000.00 18,000.00 18,000.00 18,000.00 18,000.00 30,000.00 66.7%

012962 529000 PROF SERV 22,842.80 32,900.00 32,900.00 32,900.00 42,957.20 32,900.00 .0%

012962 529303 TRAFF CODE .00 1,000.00 1,000.00 127.00 1,000.00 1,000.00 .0%

TOTAL CONTRACTUAL 43,209.13 54,900.00 54,900.00 54,027.00 64,957.20 68,400.00 24.6%

TOTAL PARKING 51,045.13 64,025.00 64,025.00 63,992.00 74,082.20 82,660.00 29.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 26

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
300 SCHOOL

____________________________________________
51 SALARIES

013001 511000 S & W .00 25,725,638.90 25,725,638.90 .00 25,725,638.90 26,497,409.00 3.0%

TOTAL SALARIES .00 25,725,638.90 25,725,638.90 .00 25,725,638.90 26,497,409.00 3.0%

TOTAL SCHOOL .00 25,725,638.90 25,725,638.90 .00 25,725,638.90 26,497,409.00 3.0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 27

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
399 REGIONAL SCHOOL ASSESSMENT

____________________________________________
54 OTHER CHARGES

013012 547100 REGION SCH 897,132.00 930,779.00 930,779.00 698,084.25 930,779.00 792,284.00 -14.9%

013012 547300 ESSEX AGRI 93,215.00 109,692.00 109,692.00 105,306.00 109,692.00 109,692.00 .0%

TOTAL OTHER CHARGES 990,347.00 1,040,471.00 1,040,471.00 803,390.25 1,040,471.00 901,976.00 -13.3%

TOTAL REGIONAL SCHOOL ASSESS 990,347.00 1,040,471.00 1,040,471.00 803,390.25 1,040,471.00 901,976.00 -13.3%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 28

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
401 PW ADMINISTRATION/ ENGINEERING

____________________________________________
51 SALARIES

014011 511000 S & W 502,995.64 572,329.20 576,309.96 520,179.76 572,329.20 612,711.68 7.1%

014011 512000 PT S&W 15,913.00 21,840.00 21,840.00 14,467.00 21,840.00 21,840.00 .0%

014011 513000 OVERTIME 8,966.15 8,500.00 8,500.00 6,722.51 8,500.00 9,300.00 9.4%

TOTAL SALARIES 527,874.79 602,669.20 606,649.96 541,369.27 602,669.20 643,851.68 6.8%

____________________________________________
52 CONTRACTUAL

014012 520500 ADVERTIS 1,749.30 4,000.00 4,000.00 2,703.08 4,000.00 4,000.00 .0%

014012 521000 PRINTING 445.35 3,800.00 3,800.00 553.80 7,343.52 3,800.00 .0%

014012 521500 POSTAGE 283.30 3,800.00 3,800.00 209.70 7,316.70 4,250.00 11.8%

014012 527601 COPY MAINT 3,161.57 6,400.00 6,400.00 976.38 6,487.19 6,400.00 .0%

014012 529000 PROF SERV 6,893.60 36,000.00 36,000.00 23,120.12 65,296.40 32,000.00 -11.1%

014012 529024 PROF BUILD .00 .00 75,000.00 .00 .00 .00 .0%

01401772 529025 SCH OUTRCH 6,362.89 3,500.00 3,500.00 .00 3,500.00 3,500.00 .0%

TOTAL CONTRACTUAL 18,896.01 57,500.00 132,500.00 27,563.08 93,943.81 53,950.00 -6.2%

____________________________________________
53 SUPPLIES AND MATERIA

014012 530200 COPY SUP 852.02 1,850.00 1,850.00 785.44 2,496.12 1,850.00 .0%

014012 533502 PROF TOOLS 1,373.71 5,000.00 5,000.00 847.56 10,246.37 5,000.00 .0%

014012 533503 OPER TOOLS 10,390.82 13,000.00 13,000.00 6,257.56 15,617.12 13,000.00 .0%

014012 535501 CLOTHING 22,782.94 39,015.00 39,015.00 23,119.24 45,826.39 39,015.00 .0%

TOTAL SUPPLIES AND MATERIA 35,399.49 58,865.00 58,865.00 31,009.80 74,186.00 58,865.00 .0%

____________________________________________
54 OTHER CHARGES

014012 540704 PROF DEVEL 2,213.41 10,500.00 10,500.00 1,278.35 31,210.08 10,500.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 29

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________

TOTAL OTHER CHARGES 2,213.41 10,500.00 10,500.00 1,278.35 31,210.08 10,500.00 .0%

TOTAL PW ADMINISTRATION/ ENG 584,383.70 729,534.20 808,514.96 601,220.50 802,009.09 767,166.68 5.2%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 30

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
402 PW FACILITY MAINTENANCE

____________________________________________
51 SALARIES

014021 511000 S & W 129,820.52 97,148.40 97,148.40 99,095.75 97,148.40 100,680.00 3.6%

014021 513000 OVERTIME 31,154.22 15,500.00 15,500.00 15,202.52 15,500.00 16,275.00 5.0%

01402531 512002 LIBR PART 24,119.00 21,875.00 21,875.00 19,071.00 21,875.00 22,969.00 5.0%

01402771 511041 SAL CUSTOD 525,181.85 586,151.00 586,151.00 461,024.14 586,151.00 583,136.84 -.5%

01402771 511042 SAL MAINT 97,122.62 174,033.62 174,033.62 127,646.39 174,033.62 175,930.44 1.1%

01402771 512003 SCH PART 136,860.85 47,000.00 47,000.00 120,687.00 47,000.00 47,000.00 .0%

01402771 513000 OT SCH BLD -4,093.26 74,200.00 74,200.00 22,847.47 74,200.00 77,910.00 5.0%

01402771 513008 OT F GREEN 5,816.07 7,980.00 7,980.00 3,031.48 7,980.00 8,379.00 5.0%

TOTAL SALARIES 945,981.87 1,023,888.02 1,023,888.02 868,605.75 1,023,888.02 1,032,280.28 .8%

____________________________________________
52 CONTRACTUAL

014022 522525 ESCO PROJ 156,850.84 161,303.00 161,303.00 80,651.25 210,868.84 183,831.00 14.0%

014022 522526 ESCO QC -18,716.88 16,621.00 16,621.00 .00 50,006.00 16,621.00 .0%

014022 527700 MUNBLD REP 143,074.11 79,750.00 125,550.00 110,404.72 95,653.00 88,500.00 11.0%

014022 527702 CONTRACT .00 .00 15,200.00 25,271.07 20,000.00 .00 .0%

014022 527759 MUN MAJ CL 16,284.18 21,500.00 21,500.00 6,592.11 26,715.00 21,500.00 .0%

01402502 522506 CH ELECTR 30,973.53 58,000.00 58,000.00 11,504.27 103,000.00 58,000.00 .0%

01402502 522611 CH HEAT 9,465.20 18,700.00 18,700.00 6,214.41 28,892.20 18,700.00 .0%

01402512 522507 STR LIGHTS 201,067.13 233,400.00 233,400.00 104,088.38 376,162.68 195,000.00 -16.5%

01402522 522509 COA ELECT 6,658.05 6,800.00 6,800.00 5,678.41 6,800.00 6,800.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 31

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
01402522 522613 COA HEAT 2,878.41 4,251.00 4,251.00 2,061.89 5,906.48 4,676.00 10.0%

01402532 522510 LIBRARY EL 20,003.79 23,923.00 23,923.00 8,743.76 33,923.00 23,923.00 .0%

01402532 522614 LIBR HEAT 7,769.60 10,350.00 10,350.00 5,384.05 13,173.35 10,350.00 .0%

01402542 522511 POLICE ELE 15,188.93 15,500.00 15,500.00 12,151.18 15,500.00 18,500.00 19.4%

01402542 522615 POL HEAT 3,812.76 5,800.00 5,800.00 5,281.64 6,087.24 5,800.00 .0%

01402552 522512 FIRE ELEC 21,659.41 21,000.00 21,000.00 22,405.44 21,000.00 24,500.00 16.7%

01402552 522616 FIRE HEAT 13,798.97 23,700.00 23,700.00 9,447.56 33,700.00 27,255.00 15.0%

01402552 527707 FR MN BLDG .00 .00 .00 2,594.66 8,587.68 .00 .0%

01402582 522515 PARK ELECT 22,080.99 26,500.00 26,500.00 14,431.36 26,510.55 26,500.00 .0%

01402592 522516 CEM ELECT 3,623.80 5,750.00 5,750.00 1,883.14 14,021.92 5,750.00 .0%

01402592 522619 CEM HEAT 2,048.07 4,250.00 4,250.00 1,402.45 6,451.93 4,250.00 .0%

01402602 522508 OPER ELECT 20,745.29 40,200.00 40,200.00 17,966.12 51,231.21 40,200.00 .0%

01402602 522612 OPER HEAT 29,565.01 30,000.00 30,000.00 25,703.51 30,000.00 30,000.00 .0%

01402772 522524 SCH ELECT 622,747.57 734,885.00 734,885.00 501,777.54 852,645.53 752,885.00 2.4%

01402772 522627 SCH HEAT 231,791.64 341,253.00 341,253.00 199,365.13 455,828.26 361,253.00 5.9%

01402772 527550 SCH CLEAN 81,189.00 225,000.00 225,000.00 85,420.00 388,574.00 225,000.00 .0%

01402772 527551 SCH GROUND 990.32 15,000.00 15,000.00 8,494.04 29,009.68 15,000.00 .0%

01402772 527552 SCH EQUIP 33,817.65 45,000.00 45,000.00 38,622.81 45,000.00 47,500.00 5.6%

01402772 527553 SCH SYSTEM 12,817.25 21,800.00 21,800.00 20,558.59 24,482.75 21,800.00 .0%

TOTAL CONTRACTUAL 1,692,184.62 2,190,236.00 2,251,236.00 1,334,099.49 2,979,731.30 2,234,094.00 2.0%

____________________________________________
53 SUPPLIES AND MATERIA

014022 533100 CLEAN SUP 13,820.62 13,125.00 13,125.00 8,739.63 13,153.07 14,500.00 10.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 32

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
014022 533107 CLEAN EQUI .00 12,500.00 12,500.00 6,481.74 12,500.00 12,500.00 .0%

01402772 531825 SCH CONTR 395,812.23 430,500.00 468,500.00 354,136.38 504,962.58 430,500.00 .0%

01402772 533115 SC CUSTOD 107,676.88 109,500.00 109,500.00 105,696.65 109,500.00 120,450.00 10.0%

01402772 533116 SCH MAINT 44,361.44 68,250.00 72,450.00 73,277.33 79,633.14 76,500.00 12.1%

TOTAL SUPPLIES AND MATERIA 561,671.17 633,875.00 676,075.00 548,331.73 719,748.79 654,450.00 3.2%

TOTAL PW FACILITY MAINTENANC 3,199,837.66 3,847,999.02 3,951,199.02 2,751,036.97 4,723,368.11 3,920,824.28 1.9%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 33

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
422 PUBLIC WORKS HIGHWAY

____________________________________________
51 SALARIES

014221 511000 S & W 194,382.98 217,617.89 217,617.89 176,655.58 217,617.89 215,156.63 -1.1%

014221 513000 OVERTIME 29,660.13 31,050.00 31,050.00 22,168.93 31,050.00 32,603.00 5.0%

TOTAL SALARIES 224,043.11 248,667.89 248,667.89 198,824.51 248,667.89 247,759.63 -.4%

____________________________________________
52 CONTRACTUAL

014222 520200 TRAF SIG 552.54 17,000.00 32,400.00 18,042.48 37,392.36 17,000.00 .0%

014222 520450 LIGHT MAIN 39,952.00 21,400.00 21,400.00 8,361.96 59,994.16 21,400.00 .0%

014222 524000 HIRE EQUIP 29,355.99 25,000.00 25,000.00 34,814.40 25,000.00 32,500.00 30.0%

014222 526900 TRAF MRKNG 20,316.20 31,500.00 31,500.00 23,960.47 42,315.36 35,000.00 11.1%

014222 527100 CATCH BSN .00 24,000.00 24,000.00 .00 33,500.00 24,000.00 .0%

014222 527101 NPDES DRAI 7,030.00 21,500.00 21,500.00 .00 59,728.24 21,500.00 .0%

014222 527102 DRAINMAINT 16,510.02 15,250.00 15,250.00 28,677.54 15,250.00 15,250.00 .0%

014222 527307 SIDEWK REP 66,511.81 29,800.00 29,800.00 15,201.05 30,000.00 32,500.00 9.1%

014222 529012 ST SWEEP 39,551.92 45,000.00 45,000.00 41,122.20 49,816.51 45,000.00 .0%

TOTAL CONTRACTUAL 219,780.48 230,450.00 245,850.00 170,180.10 352,996.63 244,150.00 5.9%

____________________________________________
53 SUPPLIES AND MATERIA

014222 533000 PAINTS 4,202.02 5,400.00 5,400.00 215.44 7,475.10 6,250.00 15.7%

014222 533500 TOOLS .00 .00 .00 75.53 .00 .00 .0%

014222 533504 BARRICADE 1,319.60 2,100.00 2,100.00 .00 2,100.00 2,100.00 .0%

014222 535800 BUT PATCH 22,091.69 38,500.00 38,500.00 21,631.83 61,817.79 41,500.00 7.8%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 34

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
014222 536000 CEM&CONCR 2,266.23 3,480.00 3,480.00 .00 4,601.27 4,200.00 20.7%

014222 536210 ROAD STRUC 235.00 7,200.00 7,200.00 .00 17,561.00 7,200.00 .0%

014222 537200 LUMBER 255.40 2,400.00 2,400.00 474.06 6,500.00 2,400.00 .0%

014222 538000 SIGN MAT 12,889.71 12,500.00 17,300.00 5,507.23 13,049.19 13,438.00 7.5%

TOTAL SUPPLIES AND MATERIA 43,259.65 71,580.00 76,380.00 27,904.09 113,104.35 77,088.00 7.7%

TOTAL PUBLIC WORKS HIGHWAY 487,083.24 550,697.89 570,897.89 396,908.70 714,768.87 568,997.63 3.3%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 35

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
423 PUBLIC WORKS SNOW REMOVAL

____________________________________________
51 SALARIES

014231 511000 S & W .00 .00 .00 3,053.00 .00 .00 .0%

014231 513000 OVERTIME 99,016.02 75,000.00 195,000.00 175,696.94 75,000.00 75,000.00 .0%

0142311 513007 SCH OT 14,034.72 .00 .00 16,503.19 .00 .00 .0%

TOTAL SALARIES 113,050.74 75,000.00 195,000.00 195,253.13 75,000.00 75,000.00 .0%

____________________________________________
52 CONTRACTUAL

014232 524000 HIRE EQUIP 214,721.96 173,508.24 423,508.24 443,760.42 173,508.24 173,508.24 .0%

014232 529015 YOUTH SNOW .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%

014232 529220 WEATHER 2,076.44 2,300.00 2,300.00 2,076.44 2,300.00 2,300.00 .0%

TOTAL CONTRACTUAL 216,798.40 176,808.24 426,808.24 445,836.86 176,808.24 176,808.24 .0%

____________________________________________
53 SUPPLIES AND MATERIA

014232 531000 GAS&OIL 8,533.47 15,000.00 15,000.00 15,576.12 15,000.00 15,000.00 .0%

014232 531201 TIRE CHAIN 89.22 2,000.00 2,000.00 772.80 2,000.00 2,000.00 .0%

014232 531203 PLOW PARTS 21,772.84 30,000.00 30,000.00 26,993.50 32,550.99 30,000.00 .0%

014232 531800 PARTS&REP 33,822.69 35,000.00 35,000.00 52,747.24 42,065.97 35,000.00 .0%

014232 533500 TOOLS 1,699.58 2,000.00 2,000.00 4,921.27 2,026.85 2,000.00 .0%

014232 534900 SALT 228,744.36 83,000.00 443,000.00 442,506.98 83,000.00 108,000.00 30.1%

014232 535000 SAND&GRAVE 3,709.33 15,000.00 15,000.00 8,222.23 15,000.00 15,000.00 .0%

014232 535401 SNOW MEALS 3,715.55 2,000.00 2,000.00 6,044.30 2,000.00 2,000.00 .0%

TOTAL SUPPLIES AND MATERIA 302,087.04 184,000.00 544,000.00 557,784.44 193,643.81 209,000.00 13.6%

____________________________________________
55 CAPITAL OUTLAY

014233 551093 PW EQU LEA 108,107.00 114,191.76 114,191.76 114,191.76 114,191.76 114,191.76 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 36

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________

TOTAL CAPITAL OUTLAY 108,107.00 114,191.76 114,191.76 114,191.76 114,191.76 114,191.76 .0%

TOTAL PUBLIC WORKS SNOW REMO 740,043.18 550,000.00 1,280,000.00 1,313,066.19 559,643.81 575,000.00 4.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 37

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
433 PUBLIC WORKS SANITATION

____________________________________________
51 SALARIES

014331 511000 S & W 94,235.30 100,792.52 100,792.52 84,718.62 100,792.52 103,574.24 2.8%

014331 512000 PT S&W 7,507.00 7,500.00 7,500.00 4,800.00 7,500.00 7,500.00 .0%

014331 513000 OVERTIME 48,001.92 53,230.00 53,230.00 39,509.05 53,230.00 55,892.00 5.0%

TOTAL SALARIES 149,744.22 161,522.52 161,522.52 129,027.67 161,522.52 166,966.24 3.4%

____________________________________________
52 CONTRACTUAL

014332 522700 TRASH DISP 368,003.31 495,500.00 495,500.00 291,630.79 652,019.48 495,500.00 .0%

014332 522702 HAZARD COL -2,731.00 2,500.00 2,500.00 -4,120.00 11,285.28 2,500.00 .0%

014332 522710 TRASH/RECY 425,058.41 575,000.00 575,000.00 470,872.58 664,500.00 650,000.00 13.0%

014332 524000 HIRE EQUIP 11,659.44 21,000.00 21,000.00 2,566.56 40,140.41 24,500.00 16.7%

TOTAL CONTRACTUAL 801,990.16 1,094,000.00 1,094,000.00 760,949.93 1,367,945.17 1,172,500.00 7.2%

TOTAL PUBLIC WORKS SANITATIO 951,734.38 1,255,522.52 1,255,522.52 889,977.60 1,529,467.69 1,339,466.24 6.7%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 38

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
475 PW PARK & FORESTRY

____________________________________________
51 SALARIES

014751 511000 S & W 410,436.24 462,023.76 462,023.76 366,160.80 462,023.76 482,749.18 4.5%

014751 512000 PT S&W 960.00 24,000.00 24,000.00 8,270.00 24,000.00 24,000.00 .0%

014751 513000 OVERTIME 49,491.67 35,250.00 35,250.00 33,987.65 35,250.00 37,013.00 5.0%

TOTAL SALARIES 460,887.91 521,273.76 521,273.76 408,418.45 521,273.76 543,762.18 4.3%

____________________________________________
52 CONTRACTUAL

014752 524000 HIRE EQUIP .00 .00 .00 2,249.45 .00 .00 .0%

014752 524006 FRST HIRED 9,945.27 15,800.00 60,800.00 18,620.02 33,396.00 18,500.00 17.1%

014752 524007 PARK HIRED 22,675.89 21,000.00 21,000.00 16,592.46 45,383.99 22,500.00 7.1%

014752 527400 IRRIG REP 8,844.30 8,500.00 8,500.00 6,110.22 8,500.00 8,500.00 .0%

014752 527806 PLYGRND RE 105.05 5,800.00 5,800.00 4,958.59 14,899.02 6,500.00 12.1%

014752 528802 TREE MAINT .00 .00 .00 60.99 .00 .00 .0%

014752 528805 MOW&MAINT 27,632.00 50,800.00 71,800.00 31,230.00 76,508.23 52,350.00 3.1%

TOTAL CONTRACTUAL 69,202.51 101,900.00 167,900.00 79,821.73 178,687.24 108,350.00 6.3%

____________________________________________
53 SUPPLIES AND MATERIA

014752 531800 PARTS&REP 13.90 .00 .00 .00 .00 .00 .0%

014752 531826 EQUIP PART 3,092.93 6,500.00 6,500.00 3,426.11 10,187.62 6,500.00 .0%

014752 533050 FLD MRKNG 5,394.68 3,450.00 3,450.00 3,397.78 3,450.00 3,623.00 5.0%

014752 533505 LAND EQUIP .00 6,500.00 6,500.00 323.24 6,500.00 6,500.00 .0%

014752 535200 LANDSC SUP 28,685.86 43,250.00 43,250.00 28,317.07 60,473.62 45,413.00 5.0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 39

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
014752 537300 FENCE MAT 2,078.34 4,200.00 4,200.00 3,498.00 8,218.45 4,200.00 .0%

014752 537610 BEN&BARR 2,956.05 4,200.00 4,200.00 5,177.28 4,200.00 4,200.00 .0%

TOTAL SUPPLIES AND MATERIA 42,221.76 68,100.00 68,100.00 44,139.48 93,029.69 70,436.00 3.4%

TOTAL PW PARK & FORESTRY 572,312.18 691,273.76 757,273.76 532,379.66 792,990.69 722,548.18 4.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 40

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
485 PW AUTOMOTIVE

____________________________________________
51 SALARIES

014851 511000 S & W 154,099.54 165,739.16 165,739.16 138,447.34 165,739.16 169,937.88 2.5%

014851 513000 OVERTIME 4,263.69 6,500.00 6,500.00 3,838.83 6,500.00 6,825.00 5.0%

TOTAL SALARIES 158,363.23 172,239.16 172,239.16 142,286.17 172,239.16 176,762.88 2.6%

____________________________________________
53 SUPPLIES AND MATERIA

014852 531000 GAS & OIL 48,165.37 169,565.00 169,565.00 26,741.33 259,197.32 169,565.00 .0%

014852 531200 TIRES 14,666.82 19,750.00 19,750.00 17,507.59 24,484.59 20,738.00 5.0%

014852 531204 POL TIRES 2,795.45 3,000.00 3,000.00 1,905.00 3,000.00 3,150.00 5.0%

014852 531205 WELD SUPP 1,724.06 1,850.00 1,850.00 1,217.45 2,418.80 1,943.00 5.0%

014852 531500 BATTERIES 968.87 3,850.00 3,850.00 3,142.27 5,498.32 4,043.00 5.0%

014852 531800 PARTS&REP 72,470.41 81,250.00 81,250.00 59,925.94 96,660.98 89,375.00 10.0%

014852 532000 CLEAN&DISF 3,818.31 3,200.00 3,200.00 1,509.10 3,200.00 3,360.00 5.0%

014852 533500 TOOLS .00 .00 .00 .00 .00 4,500.00 .0%

01485542 531804 POL MV RP 17,028.08 25,650.00 25,650.00 12,588.01 30,286.55 25,650.00 .0%

01485772 531814 ALL SCH MV 2,645.82 8,400.00 8,400.00 5,516.18 15,069.99 8,400.00 .0%

TOTAL SUPPLIES AND MATERIA 164,283.19 316,515.00 316,515.00 130,052.87 439,816.55 330,724.00 4.5%

TOTAL PW AUTOMOTIVE 322,646.42 488,754.16 488,754.16 272,339.04 612,055.71 507,486.88 3.8%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 41

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
491 CEMETERY

____________________________________________
51 SALARIES

014911 511000 S & W 157,281.61 175,316.56 175,316.56 141,793.55 175,316.56 179,041.92 2.1%

014911 512000 PT S&W 8,528.00 20,600.00 20,600.00 15,704.00 20,600.00 24,650.00 19.7%

014911 513000 OVERTIME 21,365.54 16,250.00 16,250.00 12,269.69 16,250.00 17,063.00 5.0%

TOTAL SALARIES 187,175.15 212,166.56 212,166.56 169,767.24 212,166.56 220,754.92 4.0%

____________________________________________
52 CONTRACTUAL

014912 524000 HIRE EQUIP 25,884.19 2,400.00 20,900.00 2,157.80 3,416.31 4,800.00 100.0%

014912 526000 WAT COOLER 2.69 100.00 100.00 .00 100.00 100.00 .0%

014912 527700 BLDG REP 4,981.63 .00 .00 .00 1,018.37 .00 .0%

014912 528801 LANDSCAPE 1,426.77 .00 .00 .00 2,485.00 .00 .0%

014912 529000 PROF SERV .00 .00 20,000.00 6,500.00 .00 .00 .0%

TOTAL CONTRACTUAL 32,295.28 2,500.00 41,000.00 8,657.80 7,019.68 4,900.00 96.0%

____________________________________________
53 SUPPLIES AND MATERIA

014912 530704 CEM MARK 189.21 1,000.00 1,000.00 99.28 2,105.00 2,500.00 150.0%

014912 531205 WELD SUPP 338.14 850.00 850.00 274.91 850.00 850.00 .0%

014912 532000 CLEAN&DISF 561.89 900.00 900.00 .00 900.00 900.00 .0%

014912 533500 TOOLS 9,647.80 .00 .00 38.10 14,210.12 .00 .0%

014912 535200 LANDSC SUP 5,515.82 9,500.00 9,500.00 8,794.56 11,201.99 15,000.00 57.9%

014912 536000 CEM&CONCR 15.98 2,500.00 2,500.00 39.90 4,350.00 4,500.00 80.0%

014912 536100 PIPES&FITT 1,184.24 1,500.00 1,500.00 480.18 4,666.00 1,500.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 42

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
014912 537300 FENCE MAT .00 200.00 200.00 .00 200.00 200.00 .0%

TOTAL SUPPLIES AND MATERIA 17,453.08 16,450.00 16,450.00 9,726.93 38,483.11 25,450.00 54.7%

____________________________________________
54 OTHER CHARGES

014912 544310 PROP INS 2,309.00 2,400.00 2,400.00 2,314.00 2,400.00 2,400.00 .0%

TOTAL OTHER CHARGES 2,309.00 2,400.00 2,400.00 2,314.00 2,400.00 2,400.00 .0%

TOTAL CEMETERY 239,232.51 233,516.56 272,016.56 190,465.97 260,069.35 253,504.92 8.6%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 43

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
511 HEALTH

____________________________________________
51 SALARIES

015111 511000 S & W 652,401.26 813,940.08 797,721.01 597,044.61 813,940.08 823,175.51 1.1%

TOTAL SALARIES 652,401.26 813,940.08 797,721.01 597,044.61 813,940.08 823,175.51 1.1%

____________________________________________
52 CONTRACTUAL

015112 520500 ADVERTISE 242.25 200.00 200.00 .00 200.00 200.00 .0%

015112 521000 PRINTING -150.37 496.00 496.00 517.49 496.00 496.00 .0%

015112 522711 SHARPS 1,610.00 1,680.00 1,680.00 1,470.00 1,820.00 1,680.00 .0%

015112 523000 MILEAGE 1,131.41 1,000.00 1,000.00 547.62 1,000.00 1,000.00 .0%

015112 524500 PEST CONTR 14,713.75 11,771.00 11,771.00 11,771.00 11,771.00 11,771.00 .0%

015112 529000 PROF SERV 8,085.26 10,366.00 10,366.00 9,105.00 10,366.00 10,366.00 .0%

015112 529031 ANIM SHELT 2,779.17 .00 .00 .00 .00 3,000.00 .0%

015112 529032 INTERFACE .00 .00 12,500.00 6,250.00 .00 6,250.00 .0%

TOTAL CONTRACTUAL 28,411.47 25,513.00 38,013.00 29,661.11 25,653.00 34,763.00 36.3%

____________________________________________
53 SUPPLIES AND MATERIA

015112 530501 MISC SUP 321.25 558.00 558.00 400.92 10,558.00 558.00 .0%

015112 532100 MEDICALSUP 3,253.97 6,000.00 6,000.00 5,200.85 6,000.00 6,000.00 .0%

015112 533500 TOOLS 563.83 600.00 600.00 149.95 600.00 600.00 .0%

015112 535501 CLOTHING 250.00 250.00 250.00 250.00 250.00 250.00 .0%

TOTAL SUPPLIES AND MATERIA 4,389.05 7,408.00 7,408.00 6,001.72 17,408.00 7,408.00 .0%

____________________________________________
54 OTHER CHARGES

015112 540500 DUES/MEMB 255.00 250.00 250.00 355.00 250.00 250.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 44

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
015112 540700 SEMINARS 648.63 950.00 950.00 511.00 950.00 950.00 .0%

015112 547000 RIVERSIDE 6,200.00 6,200.00 6,200.00 6,200.00 6,200.00 6,200.00 .0%

015112 547001 EMARC 8,460.00 8,460.00 8,460.00 4,230.00 8,460.00 8,460.00 .0%

TOTAL OTHER CHARGES 15,563.63 15,860.00 15,860.00 11,296.00 15,860.00 15,860.00 .0%

TOTAL HEALTH 700,765.41 862,721.08 859,002.01 644,003.44 872,861.08 881,206.51 2.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 45

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
540 BEEBE ESTATE

____________________________________________
52 CONTRACTUAL

015402 522505 BEEBE ELEC 1,393.87 1,800.00 1,800.00 1,087.49 1,800.00 1,800.00 .0%

015402 522605 BEEBE GAS 4,498.62 3,900.00 3,900.00 3,868.18 3,900.00 3,900.00 .0%

015402 527700 BLDGREPAIR 1,807.51 2,000.00 2,000.00 2,744.33 2,000.00 2,000.00 .0%

TOTAL CONTRACTUAL 7,700.00 7,700.00 7,700.00 7,700.00 7,700.00 7,700.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

015402 530501 MISC SUP 200.00 200.00 200.00 108.75 200.00 200.00 .0%

TOTAL SUPPLIES AND MATERIA 200.00 200.00 200.00 108.75 200.00 200.00 .0%

TOTAL BEEBE ESTATE 7,900.00 7,900.00 7,900.00 7,808.75 7,900.00 7,900.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 46

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
541 COUNCIL ON AGING

____________________________________________
51 SALARIES

015411 511000 S & W 169,056.01 179,788.52 180,268.13 145,896.23 179,788.52 183,647.80 2.1%

TOTAL SALARIES 169,056.01 179,788.52 180,268.13 145,896.23 179,788.52 183,647.80 2.1%

____________________________________________
52 CONTRACTUAL

015412 521000 PRINTING 450.00 50.00 50.00 254.35 50.00 50.00 .0%

015412 523000 MILEAGE .00 100.00 100.00 .00 100.00 100.00 .0%

015412 527304 FIRE ALARM .00 300.00 300.00 .00 300.00 300.00 .0%

TOTAL CONTRACTUAL 450.00 450.00 450.00 254.35 450.00 450.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

015412 530200 COPY SUP 308.27 150.00 150.00 136.00 150.00 150.00 .0%

015412 532500 HOUSE SUP 41.73 150.00 150.00 176.94 150.00 150.00 .0%

015412 534200 BOOKS .00 50.00 50.00 40.00 50.00 50.00 .0%

TOTAL SUPPLIES AND MATERIA 350.00 350.00 350.00 352.94 350.00 350.00 .0%

____________________________________________
54 OTHER CHARGES

015412 540500 DUES/MEMB 100.00 100.00 100.00 .00 100.00 100.00 .0%

015412 540600 EDUC/SEMIN 94.00 94.00 94.00 160.99 94.00 100.00 6.4%

TOTAL OTHER CHARGES 194.00 194.00 194.00 160.99 194.00 200.00 3.1%

TOTAL COUNCIL ON AGING 170,050.01 180,782.52 181,262.13 146,664.51 180,782.52 184,647.80 2.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 47

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
542 WOMEN'S COMMISSION

____________________________________________
54 OTHER CHARGES

015422 540000 OTH CHGEXP .00 2,000.00 2,000.00 1,441.46 2,000.00 2,000.00 .0%

TOTAL OTHER CHARGES .00 2,000.00 2,000.00 1,441.46 2,000.00 2,000.00 .0%

TOTAL WOMEN'S COMMISSION .00 2,000.00 2,000.00 1,441.46 2,000.00 2,000.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 48

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
543 VETERANS

____________________________________________
51 SALARIES

015431 511000 S & W 145,965.05 150,575.66 150,575.66 115,953.49 150,575.66 149,966.38 -.4%

TOTAL SALARIES 145,965.05 150,575.66 150,575.66 115,953.49 150,575.66 149,966.38 -.4%

____________________________________________
52 CONTRACTUAL

015432 523000 MILEAGE 526.53 500.00 500.00 450.58 500.00 500.00 .0%

015432 525303 LICENSES .00 .00 .00 .00 .00 450.00 .0%

015432 527803 WAR MEM 1,839.89 4,000.00 4,000.00 1,011.28 4,000.00 4,000.00 .0%

TOTAL CONTRACTUAL 2,366.42 4,500.00 4,500.00 1,461.86 4,500.00 4,950.00 10.0%

____________________________________________
54 OTHER CHARGES

015432 540500 DUES 170.00 120.00 120.00 103.95 120.00 160.00 33.3%

015432 540600 EDUC/SEMIN 999.96 1,000.00 1,000.00 703.38 1,000.00 2,000.00 100.0%

015432 542501 RENT VETS 775.00 1,550.00 1,550.00 .00 1,550.00 1,550.00 .0%

015432 544000 VET BENE 358,663.21 420,000.00 320,000.00 259,122.14 420,351.66 400,000.00 -4.8%

015432 544020 OUTREACH 1,618.10 950.00 950.00 1,134.60 950.00 2,000.00 110.5%

TOTAL OTHER CHARGES 362,226.27 423,620.00 323,620.00 261,064.07 423,971.66 405,710.00 -4.2%

TOTAL VETERANS 510,557.74 578,695.66 478,695.66 378,479.42 579,047.32 560,626.38 -3.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 49

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
544 HUMAN RIGHTS

____________________________________________
52 CONTRACTUAL

015442 521000 PRINTING .00 525.00 525.00 .00 845.79 525.00 .0%

015442 529000 PROF SERV 2,679.21 2,475.00 2,475.00 1,619.34 2,475.00 2,475.00 .0%

TOTAL CONTRACTUAL 2,679.21 3,000.00 3,000.00 1,619.34 3,320.79 3,000.00 .0%

TOTAL HUMAN RIGHTS 2,679.21 3,000.00 3,000.00 1,619.34 3,320.79 3,000.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 50

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
611 LIBRARY

____________________________________________
51 SALARIES

016111 511000 S & W 767,305.09 800,875.62 800,875.62 690,147.14 800,875.62 810,571.65 1.2%

016111 513000 OVERTIME 13,719.33 15,000.00 15,000.00 13,825.12 15,000.00 15,000.00 .0%

TOTAL SALARIES 781,024.42 815,875.62 815,875.62 703,972.26 815,875.62 825,571.65 1.2%

____________________________________________
52 CONTRACTUAL

016112 521000 PRINTING 1,410.58 2,000.00 2,000.00 374.38 2,000.00 1,000.00 -50.0%

016112 521500 POSTAGE 1,399.60 2,500.00 2,500.00 1,231.99 2,500.00 1,500.00 -40.0%

016112 522000 TELEPHONE 3,149.08 3,000.00 3,000.00 2,185.60 3,000.00 3,000.00 .0%

016112 523000 MILEAGE 694.73 650.00 650.00 522.15 650.00 650.00 .0%

016112 525104 NOBLE 43,431.69 42,500.00 42,500.00 38,195.85 42,500.00 46,950.00 10.5%

016112 527702 CONTRACT 10,344.00 9,785.00 9,785.00 9,164.50 9,785.00 11,785.00 20.4%

TOTAL CONTRACTUAL 60,429.68 60,435.00 60,435.00 51,674.47 60,435.00 64,885.00 7.4%

____________________________________________
53 SUPPLIES AND MATERIA

016112 530100 COMP PURCH 257.73 1,500.00 1,500.00 911.79 1,500.00 1,500.00 .0%

016112 530500 OFFICE SUP 6,556.94 8,000.00 8,000.00 4,959.33 8,000.00 8,000.00 .0%

016112 534100 AUDIO MAT 7,419.63 5,000.00 5,000.00 3,800.63 5,000.00 5,000.00 .0%

016112 534150 VIDEO FORM 6,789.39 5,400.00 5,400.00 7,545.38 5,400.00 5,400.00 .0%

016112 534200 BOOKS 56,957.65 46,500.00 61,500.00 56,901.98 46,500.00 46,500.00 .0%

016112 534210 ELECTRONIC 3,615.00 2,500.00 2,500.00 5,164.00 2,500.00 2,500.00 .0%

016112 534220 NETWRK ECO 6,489.00 4,500.00 4,500.00 8,835.00 4,500.00 8,000.00 77.8%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 51

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
016112 534230 DOWNLOAD 1,584.49 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0%

016112 534240 ELECTR DAT 12,635.00 12,000.00 12,000.00 15,139.00 12,000.00 15,500.00 29.2%

016112 534300 LIB PASSES 2,190.00 2,000.00 2,000.00 2,290.00 2,000.00 2,000.00 .0%

016112 534800 RECRE SUP 1,405.17 2,000.00 2,000.00 352.89 2,000.00 1,000.00 -50.0%

TOTAL SUPPLIES AND MATERIA 105,900.00 90,900.00 105,900.00 105,900.00 90,900.00 96,900.00 6.6%

____________________________________________
54 OTHER CHARGES

016112 540500 DUES/MEMB 355.00 300.00 300.00 377.00 300.00 300.00 .0%

016112 540600 EDUC/SEMIN 40.00 500.00 500.00 500.00 500.00 500.00 .0%

016112 542700 RECPROGRAM 3,005.00 2,600.00 2,600.00 1,525.00 2,600.00 2,600.00 .0%

TOTAL OTHER CHARGES 3,400.00 3,400.00 3,400.00 2,402.00 3,400.00 3,400.00 .0%

TOTAL LIBRARY 950,754.10 970,610.62 985,610.62 863,948.73 970,610.62 990,756.65 2.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 52

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
631 RECREATION

____________________________________________
51 SALARIES

016311 511000 S & W 44,130.18 44,130.18 44,130.18 46,116.14 44,130.18 44,130.18 .0%

TOTAL SALARIES 44,130.18 44,130.18 44,130.18 46,116.14 44,130.18 44,130.18 .0%

____________________________________________
54 OTHER CHARGES

016312 542702 EMARAC 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 3,600.00 .0%

016312 542704 REC SCHOLR 4,000.00 4,000.00 4,000.00 1,000.00 4,000.00 4,000.00 .0%

016312 548950 COMM OUTRE 2,500.00 2,500.00 2,500.00 3,308.50 2,500.00 2,500.00 .0%

TOTAL OTHER CHARGES 10,100.00 10,100.00 10,100.00 7,908.50 10,100.00 10,100.00 .0%

____________________________________________
55 CAPITAL OUTLAY

016312 551067 TEEN CTR 9,800.00 9,800.00 9,800.00 8,820.00 9,800.00 9,800.00 .0%

TOTAL CAPITAL OUTLAY 9,800.00 9,800.00 9,800.00 8,820.00 9,800.00 9,800.00 .0%

TOTAL RECREATION 64,030.18 64,030.18 64,030.18 62,844.64 64,030.18 64,030.18 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 53

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
652 PINE BANKS

____________________________________________
51 SALARIES

016521 511000 S & W 126,027.18 150,139.95 160,999.33 140,096.96 151,560.60 194,896.00 29.8%

016521 512000 PT S&W 27,651.52 32,203.00 32,203.00 11,005.12 32,203.00 .00 -100.0%

016521 513000 OVERTIME 2,341.73 4,331.00 4,331.00 381.99 4,331.00 5,622.00 29.8%

TOTAL SALARIES 156,020.43 186,673.95 197,533.33 151,484.07 188,094.60 200,518.00 7.4%

____________________________________________
52 CONTRACTUAL

016522 522000 TELEPHONE 2,499.96 2,500.00 2,500.00 2,083.30 2,500.00 2,500.00 .0%

016522 522500 ELECTRIC 13,000.00 13,000.00 13,000.00 10,300.00 13,000.00 13,000.00 .0%

016522 527500 MV REPAIRS 3,999.96 2,500.00 2,500.00 2,083.30 2,500.00 2,500.00 .0%

016522 527700 BLDGREPAIR 10,000.00 10,000.00 10,000.00 8,000.00 10,000.00 10,000.00 .0%

016522 528600 AUDIT SERV 5,000.04 8,000.00 8,000.00 6,666.70 8,000.00 8,000.00 .0%

016522 528804 ATH FIELD 925.00 3,300.00 3,300.00 2,750.00 3,300.00 3,300.00 .0%

016522 529000 PROF SERV 5,000.04 5,000.00 5,000.00 4,166.70 5,000.00 5,000.00 .0%

TOTAL CONTRACTUAL 40,425.00 44,300.00 44,300.00 36,050.00 44,300.00 44,300.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

016522 530500 OFFICE SUP 999.96 500.00 500.00 416.70 500.00 500.00 .0%

016522 530800 HEAT FUEL 4,500.00 4,500.00 4,500.00 3,700.00 4,500.00 4,500.00 .0%

016522 531000 GAS & OIL 3,999.96 3,500.00 3,500.00 2,916.70 3,500.00 3,500.00 .0%

016522 532000 CLEAN SUP 1,000.00 500.00 500.00 416.70 500.00 500.00 .0%

016522 533000 PAINTS 1,000.00 500.00 500.00 416.70 500.00 500.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 54

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
016522 533500 TOOLS 1,000.00 500.00 500.00 416.70 500.00 500.00 .0%

016522 534800 RECRE SUP .00 1,850.00 1,850.00 1,850.00 1,850.00 .00 -100.0%

016522 535100 PARK SUP 11,500.04 30,000.00 30,000.00 24,000.00 30,000.00 30,000.00 .0%

016522 537200 LUMBER 1,000.00 500.00 500.00 416.70 500.00 500.00 .0%

016522 537300 FENCE MAT .00 3,250.00 3,250.00 3,250.00 3,250.00 .00 -100.0%

TOTAL SUPPLIES AND MATERIA 24,999.96 45,600.00 45,600.00 37,800.20 45,600.00 40,500.00 -11.2%

____________________________________________
54 OTHER CHARGES

016522 543201 WCINS PINE 4,225.00 4,225.00 4,225.00 3,876.58 4,225.00 4,225.00 .0%

016522 544320 FIRE INS 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0%

016522 544325 PB LIAB IN .00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 .0%

016522 544330 AUTO INS 2,500.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 .0%

TOTAL OTHER CHARGES 8,725.00 9,225.00 9,225.00 8,876.58 9,225.00 9,225.00 .0%

____________________________________________
55 CAPITAL OUTLAY

016523 551095 PB EQUIP 22,938.50 .00 .00 .00 .00 48,500.00 .0%

TOTAL CAPITAL OUTLAY 22,938.50 .00 .00 .00 .00 48,500.00 .0%

TOTAL PINE BANKS 253,108.89 285,798.95 296,658.33 234,210.85 287,219.60 343,043.00 20.0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 55

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
692 COMMUNITY EVENTS

____________________________________________
56 MISCELLANEOUS

016922 560300 CELEB EXP 6,000.00 6,000.00 6,000.00 .00 6,000.00 6,000.00 .0%

016922 560301 CELEB VET 2,000.00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0%

TOTAL MISCELLANEOUS 8,000.00 8,000.00 8,000.00 .00 8,000.00 8,000.00 .0%

TOTAL COMMUNITY EVENTS 8,000.00 8,000.00 8,000.00 .00 8,000.00 8,000.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 56

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
693 MEMORIAL BUILDING

____________________________________________
51 SALARIES

016931 511000 S & W 115,818.52 136,178.58 136,178.58 95,252.98 136,178.58 134,679.45 -1.1%

TOTAL SALARIES 115,818.52 136,178.58 136,178.58 95,252.98 136,178.58 134,679.45 -1.1%

____________________________________________
52 CONTRACTUAL

016932 522500 ELECTRIC 22,330.70 20,700.00 20,700.00 13,885.26 24,135.58 20,700.00 .0%

016932 522600 GAS HEAT 14,898.97 12,500.00 12,500.00 8,428.81 15,906.39 12,500.00 .0%

016932 527303 ELEVATOR 3,869.76 4,024.56 4,024.56 3,987.84 4,024.56 4,185.00 4.0%

016932 527700 BLDGREPAIR 6,907.93 6,031.79 6,031.79 5,825.56 6,031.79 6,031.79 .0%

016932 529000 PROF SERV 14,761.99 15,000.00 15,000.00 6,925.00 15,000.00 15,000.00 .0%

TOTAL CONTRACTUAL 62,769.35 58,256.35 58,256.35 39,052.47 65,098.32 58,416.79 .3%

____________________________________________
53 SUPPLIES AND MATERIA

016932 530501 MISC SUP .00 5,169.85 5,169.85 4,393.14 5,169.85 5,169.85 .0%

016932 530508 MARKET SUP 746.79 800.00 800.00 408.94 800.00 800.00 .0%

016932 532000 CLEAN SUP 5,223.06 .00 .00 .00 .00 .00 .0%

TOTAL SUPPLIES AND MATERIA 5,969.85 5,969.85 5,969.85 4,802.08 5,969.85 5,969.85 .0%

____________________________________________
56 MISCELLANEOUS

016932 591015 APFY15 3,012.80 .00 .00 .00 .00 .00 .0%

TOTAL MISCELLANEOUS 3,012.80 .00 .00 .00 .00 .00 .0%

TOTAL MEMORIAL BUILDING 187,570.52 200,404.78 200,404.78 139,107.53 207,246.75 199,066.09 -.7%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 57

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
711 MUNICIPAL DEBT

____________________________________________
56 MISCELLANEOUS

017112 565000 MUNI DEBT 2,380,000.00 2,533,950.00 2,533,950.00 2,533,950.00 2,533,950.00 2,439,900.00 -3.7%

017112 565010 EX PRINC 1,214,909.00 1,125,959.35 1,125,959.35 1,125,959.45 1,125,959.35 1,295,009.00 15.0%

TOTAL MISCELLANEOUS 3,594,909.00 3,659,909.35 3,659,909.35 3,659,909.45 3,659,909.35 3,734,909.00 2.0%

TOTAL MUNICIPAL DEBT 3,594,909.00 3,659,909.35 3,659,909.35 3,659,909.45 3,659,909.35 3,734,909.00 2.0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 58

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
751 MUNICIPAL DEBT INTEREST

____________________________________________
54 OTHER CHARGES

017512 549102 MUNI INT 871,568.34 965,482.51 965,482.51 873,047.88 965,482.51 873,995.34 -9.5%

017512 549103 EXEMPT INT 832,217.54 781,661.01 781,661.01 781,661.13 781,661.01 617,391.50 -21.0%

TOTAL OTHER CHARGES 1,703,785.88 1,747,143.52 1,747,143.52 1,654,709.01 1,747,143.52 1,491,386.84 -14.6%

TOTAL MUNICIPAL DEBT INTERES 1,703,785.88 1,747,143.52 1,747,143.52 1,654,709.01 1,747,143.52 1,491,386.84 -14.6%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 59

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
752 PROJECTED DEBT & TEMP INTEREST

____________________________________________
54 OTHER CHARGES

017522 549100 PROJ DEBT 132,664.55 205,495.42 166,497.57 161,993.96 205,495.42 370,850.00 80.5%

TOTAL OTHER CHARGES 132,664.55 205,495.42 166,497.57 161,993.96 205,495.42 370,850.00 80.5%

TOTAL PROJECTED DEBT & TEMP 132,664.55 205,495.42 166,497.57 161,993.96 205,495.42 370,850.00 80.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 60

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
911 PENSION WEEKLY

____________________________________________
51 SALARIES

019111 511000 S & W 23,043.80 23,846.95 23,846.95 18,255.86 23,846.95 .00 -100.0%

019111 511010 CONTRIB 5,515,958.00 5,662,138.00 5,662,138.00 5,667,138.00 5,667,138.00 5,882,522.00 3.9%

TOTAL SALARIES 5,539,001.80 5,685,984.95 5,685,984.95 5,685,393.86 5,690,984.95 5,882,522.00 3.5%

TOTAL PENSION WEEKLY 5,539,001.80 5,685,984.95 5,685,984.95 5,685,393.86 5,690,984.95 5,882,522.00 3.5%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 61

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
912 WORKER'S COMPENSATION

____________________________________________
54 OTHER CHARGES

019122 543100 W C MED 68,322.43 103,125.00 103,125.00 40,553.57 103,125.00 93,125.00 -9.7%

019122 543101 W C EXP 21,190.00 26,875.00 26,875.00 27,624.56 26,875.00 26,875.00 .0%

019122 543102 W C BENE 83,806.11 130,000.00 130,000.00 76,737.12 130,000.00 120,000.00 -7.7%

019122 543200 INDEMN 34,722.16 80,000.00 60,000.00 34,088.76 80,000.00 70,000.00 -12.5%

TOTAL OTHER CHARGES 208,040.70 340,000.00 320,000.00 179,004.01 340,000.00 310,000.00 -8.8%

TOTAL WORKER'S COMPENSATION 208,040.70 340,000.00 320,000.00 179,004.01 340,000.00 310,000.00 -8.8%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 62

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
913 UNEMPLOYMENT

____________________________________________
54 OTHER CHARGES

019132 544400 UNEMP EXP 88,587.89 140,000.00 140,000.00 90,919.01 142,642.82 130,000.00 -7.1%

TOTAL OTHER CHARGES 88,587.89 140,000.00 140,000.00 90,919.01 142,642.82 130,000.00 -7.1%

TOTAL UNEMPLOYMENT 88,587.89 140,000.00 140,000.00 90,919.01 142,642.82 130,000.00 -7.1%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 63

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
914 HEALTH CONTRACTUAL

____________________________________________
51 SALARIES

019141 511000 S & W 79,825.23 84,703.62 84,703.62 71,645.99 84,703.62 66,769.16 -21.2%

TOTAL SALARIES 79,825.23 84,703.62 84,703.62 71,645.99 84,703.62 66,769.16 -21.2%

____________________________________________
54 OTHER CHARGES

019142 540702 TRAIN ACA 1,837.82 .00 .00 209.04 .00 .00 .0%

019142 542911 COOK ACA 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 .00 -100.0%

019142 549201 GROUP HEAL 10,031,577.93 10,711,640.38 10,291,640.38 8,339,661.87 10,711,640.38 10,622,244.00 -.8%

019142 549212 MEDICARE D -165,642.86 .00 .00 -175,587.84 .00 .00 .0%

019142 549214 LIFE INS P 81,265.25 85,000.00 85,000.00 74,733.73 85,000.00 94,500.00 11.2%

019142 549215 SENTINEL F 11,961.00 14,000.00 14,000.00 10,809.00 15,094.50 16,000.00 14.3%

019142 549216 BENEFIT TR .00 .00 .00 900.00 .00 .00 .0%

019142 549217 PART B 70% 499,324.00 640,000.00 590,000.00 547,198.96 640,000.00 630,000.00 -1.6%

019142 549218 PART B PEN 45,860.50 58,000.00 58,000.00 39,506.50 58,000.00 55,500.00 -4.3%

019142 549222 C32B S9 7,459.33 10,000.00 10,000.00 .00 10,000.00 .00 -100.0%

019142 549223 HIATUS 2,516.33 .00 .00 2,741.36 .00 .00 .0%

019142 549224 OPT OUT 176,459.00 220,001.28 220,001.28 323,960.19 220,001.28 480,000.00 118.2%

TOTAL OTHER CHARGES 10,697,618.30 11,743,641.66 11,273,641.66 9,169,132.81 11,744,736.16 11,898,244.00 1.3%

TOTAL HEALTH CONTRACTUAL 10,777,443.53 11,828,345.28 11,358,345.28 9,240,778.80 11,829,439.78 11,965,013.16 1.2%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 64

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
916 MEDICARE TAX CITY PORTION

____________________________________________
54 OTHER CHARGES

019162 548000 MED TX CTY 644,450.87 650,000.00 650,000.00 530,693.97 655,549.13 680,000.00 4.6%

TOTAL OTHER CHARGES 644,450.87 650,000.00 650,000.00 530,693.97 655,549.13 680,000.00 4.6%

TOTAL MEDICARE TAX CITY PORT 644,450.87 650,000.00 650,000.00 530,693.97 655,549.13 680,000.00 4.6%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 65

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
930 DEPARTMENTAL EQUIPMENT

____________________________________________
52 CONTRACTUAL

019302 525305 IT COM NOT 10,405.00 10,800.00 10,800.00 13,825.74 10,800.00 10,800.00 .0%

019302 527602 IT COPY LE 13,395.00 13,000.00 13,000.00 8,969.58 13,000.00 13,000.00 .0%

TOTAL CONTRACTUAL 23,800.00 23,800.00 23,800.00 22,795.32 23,800.00 23,800.00 .0%

____________________________________________
53 SUPPLIES AND MATERIA

019302 530100 IT COMP PU 28,000.00 28,000.00 28,000.00 11,941.57 141,737.30 28,000.00 .0%

019302 530103 IT PRINTER 3,046.01 2,000.00 2,000.00 705.84 4,453.99 2,000.00 .0%

019302 530500 OFFICE SUP 28,318.41 24,000.00 24,000.00 20,980.23 26,930.62 24,000.00 .0%

TOTAL SUPPLIES AND MATERIA 59,364.42 54,000.00 54,000.00 33,627.64 173,121.91 54,000.00 .0%

____________________________________________
55 CAPITAL OUTLAY

019303 551059 PERMIT SFT 41,571.77 75,000.00 75,000.00 32,789.40 75,696.35 75,000.00 .0%

TOTAL CAPITAL OUTLAY 41,571.77 75,000.00 75,000.00 32,789.40 75,696.35 75,000.00 .0%

TOTAL DEPARTMENTAL EQUIPMENT 124,736.19 152,800.00 152,800.00 89,212.36 272,618.26 152,800.00 .0%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 66

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
931 CAPITAL OUTLAY

____________________________________________
55 CAPITAL OUTLAY

019313 551002 PW VEH&EQU 8,189.96 .00 .00 .00 .00 .00 .0%

019313 551044 PB BLFLD#1 50,000.00 .00 .00 .00 .00 .00 .0%

019313 551049 POL VEHICL 53,930.32 56,125.08 143,302.05 136,756.81 56,125.08 134,606.24 139.8%

019313 551058 PB BLFLD#2 65,662.78 .00 .00 .00 .00 .00 .0%

019313 551087 ROUTE 99 -25,000.00 .00 .00 .00 25,000.00 .00 .0%

019313 551098 CTY IT TEC 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 .0%

019313 551099 PB PROJECT .00 101,294.18 101,294.18 101,294.18 101,294.18 101,294.18 .0%

01931773 551097 SCH IT TEC 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 .0%

TOTAL CAPITAL OUTLAY 452,783.06 457,419.26 544,596.23 538,050.99 482,419.26 535,900.42 17.2%

TOTAL CAPITAL OUTLAY 452,783.06 457,419.26 544,596.23 538,050.99 482,419.26 535,900.42 17.2%

05/04/2017 10:01 |CITY OF MELROSE v10.5 |P 67

kgolden |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION: 2018 FY18 GENERAL FUND BUDGET FOR PERIOD 99

ACCOUNTS FOR:

2016 2017 2017 2017 2017 2018 PCT

GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DEPARTMENT CHANGE

____________________________________________________________________________________________________________________________________
____________________________________________
942 STABILIZATION FUNDS

____________________________________________
56 MISCELLANEOUS

019422 561300 STABIL TRT .00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 .0%

019422 561400 OPEB TRUST .00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 .0%

TOTAL MISCELLANEOUS .00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 .0%

TOTAL STABILIZATION FUNDS .00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 .0%

TOTAL GENERAL FUND 46,065,142.89 75,328,574.79 77,082,370.93 43,370,094.39 77,358,807.27 77,397,009.19 2.7%

GRAND TOTAL 46,065,142.89 75,328,574.79 77,082,370.93 43,370,094.39 77,358,807.27 77,397,009.19 2.7%

** END OF REPORT - Generated by Kerriann Golden **

You might also like