GF - Exp — File 202900

01/30/2017 10:12 |City of Somerville |P 1 icody |2016 |glytdbud FOR 2017 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ 0111251 BD OF ALDERMAN PERSONAL SE 455,923 .00 455,923.00 227,460.78 .00 228,462.22 49.9% 0111252 BD OF ALDERMAN ORDINARY MA 40,660 .00 40,660.00 17,250.00 2,750.00 20,660.00 49.2% 0111351 CLRK OF COMM PERSONAL SERV 74,244 .00 74,244.00 36,140.53 .00 38,103.47 48.7% 0111352 CLRK OF COMM ORDINARY MAIN 1,000 .00 1,000.00 .00 .00 1,000.00 .0% 0112151 EXEC ADMIN PERSONAL SERVIC 617,683 .00 617,683.00 245,390.87 .00 372,292.13 39.7% 0112152 EXEC ADMIN ORDINARY MAINT 62,900 .00 62,900.00 14,792.77 .00 48,107.23 23.5% 0112160 EXEC ADMIN SPECIAL ITEMS 216,500 .00 216,500.00 99,438.33 .00 117,061.67 45.9% 0112251 EXEC-SOMER PERSONAL SERVIC 372,092 .00 372,092.00 126,217.44 .00 245,874.56 33.9% 0112252 EXEC-SOMER ORDINARY MAINT 23,800 .00 23,800.00 -732.00 .00 24,532.00 -3.1% 0112351 EXEC-CPM PERSONAL SERVICES 438,919 .00 438,919.00 173,763.92 .00 265,155.08 39.6% 0112352 EXEC-CPM ORDINARY MAINTENA 32,495 .00 32,495.00 12,355.96 4,490.40 15,648.64 51.8% 0112358 EXEC-CPM CAPITAL OUTLAY 225,000 .00 225,000.00 4,520.00 118,300.00 102,180.00 54.6% 0112451 EXEC-ARTS CNCL PERSONAL SE 340,459 .00 340,459.00 143,964.99 .00 196,494.01 42.3% 0112452 EXEC-ARTS CNCL ORDINARY MA 154,125 .00 154,125.00 77,604.61 9,667.11 66,853.28 56.6% 0112551 EXEC-CONSTITUENT PERSONAL 640,017 .00 640,017.00 255,725.44 .00 384,291.56 40.0% 0112552 EXEC-CONSTITUENT ORDINARY 61,250 .00 61,250.00 17,908.11 11,806.60 31,535.29 48.5% 0112651 EXEC-OS ENV PERSONAL SERVI 220,148 .00 220,148.00 82,879.59 .00 137,268.41 37.6% 0112652 EXEC-OS ENV ORDINARY MAINT 103,550 .00 103,550.00 3,185.95 397.05 99,967.00 3.5% 0112751 EXEC-COA PERSONAL SERVICES 378,345 .00 378,345.00 138,936.23 .00 239,408.77 36.7% 0112752 EXEC-COA ORDINARY MAINTENA 99,227 .00 99,227.00 -46,440.09 1,080.12 144,586.97 -45.7% 0112851 EXEC-SOMER PROM PERSONAL S 79,157 .00 79,157.00 33,466.42 .00 45,690.58 42.3% 0112852 EXEC-SOMER PROM ORDINARY 120,320 .00 120,320.00 33,813.77 73,296.23 13,210.00 89.0% 0113551 AUDITING PERSONAL SERVICES 790,935 -23,295.00 767,640.00 331,171.20 .00 436,468.80 43.1% 0113552 AUDITING ORDINARY MAINTENA 112,325 23,295.00 135,620.00 2,559.20 11,413.80 121,647.00 10.3% 0113651 GRANTS DEV PERSONAL SERVIC 149,299 .00 149,299.00 62,730.80 .00 86,568.20 42.0% 0113652 GRANTS DEV ORDINARY MAINT 5,776 .00 5,776.00 1,704.71 .00 4,071.29 29.5% 0113851 PURCHASING PERSONAL SERVIC 395,044 .00 395,044.00 145,619.92 .00 249,424.08 36.9% 0113852 PURCHASING ORDINARY MAINT 38,050 .00 38,050.00 15,787.43 8,965.64 13,296.93 65.1% 0114151 BD OF ASSESSORS PERSONAL S 538,953 -11,173.00 527,780.00 238,561.60 .00 289,218.40 45.2% 0114152 BD OF ASSESSORS ORDINARY M 121,890 11,173.00 133,063.00 40,879.28 35,384.40 56,799.32 57.3% 0114551 TREAS/COLL PERSONAL SERVIC 662,214 .00 662,214.00 260,056.08 .00 402,157.92 39.3% 0114552 TREAS/COLL ORDINARY MAINT 264,990 .00 264,990.00 79,843.61 41,155.36 143,991.03 45.7% 0115151 LAW PERSONAL SERVICES 696,862 .00 696,862.00 291,177.49 .00 405,684.51 41.8% 0115152 LAW ORDINARY MAINTENANCE 175,275 140,000.00 315,275.00 243,980.84 30,279.31 41,014.85 87.0% 0115251 PERSONNEL PERSONAL SERVICE 796,646 .00 796,646.00 328,127.21 .00 468,518.79 41.2% 0115252 PERSONNEL ORDINARY MAINT 318,700 .00 318,700.00 43,644.48 53,601.34 221,454.18 30.5% 0115260 PERSONNEL SPECIAL ITEMS 60,000 .00 60,000.00 4,738.00 .00 55,262.00 7.9% 0115551 INFO TECH PERSONAL SERVICE 733,595 .00 733,595.00 248,909.46 .00 484,685.54 33.9% 0115552 INFO TECH ORDINARY MAINTEN 1,593,934 .00 1,593,934.00 495,741.78 325,876.29 772,315.93 51.5% 0115751 COMMUNICATIONS PERSONAL SV 335,596 .00 335,596.00 137,464.19 .00 198,131.81 41.0% 0115752 COMMUNICATIONS ORDINARY MA 23,125 .00 23,125.00 6,652.63 5,573.07 10,899.30 52.9% 0116151 CITY CLERK PERSONAL SERVIC 431,782 .00 431,782.00 181,880.14 .00 249,901.86 42.1% 0116152 CITY CLERK ORDINARY MAINT 153,737 .00 153,737.00 80,759.55 60,105.67 12,871.78 91.6% 0116251 ELECTIONS PERSONAL SERVICE 506,774 .00 506,774.00 242,020.79 .00 264,753.21 47.8%

01/30/2017 10:12 |City of Somerville |P 2 icody |2016 |glytdbud FOR 2017 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ 0116252 ELECTIONS ORDINARY MAINTEN 120,145 .00 120,145.00 26,889.87 13,357.63 79,897.50 33.5% 0116551 LICENSING COMM PERSONAL SE 10,800 .00 10,800.00 5,400.00 .00 5,400.00 50.0% 0118151 OSPCD-PLANNING PERSONAL SV 801,820 .00 801,820.00 303,367.87 .00 498,452.13 37.8% 0118152 OSPCD-PLANNING ORDINARY MA 302,338 .00 302,338.00 33,850.75 47,519.00 220,968.25 26.9% 0118251 OSPCD-ADMIN PERSONAL SERVI 326,295 .00 326,295.00 136,798.17 .00 189,496.83 41.9% 0118252 OSPCD-ADMIN ORDINARY MAINT 23,550 .00 23,550.00 1,467.66 .00 22,082.34 6.2% 0118351 OSPCD-HOUSING PERSONAL SVC 455,550 .00 455,550.00 175,531.99 .00 280,018.01 38.5% 0118352 OSPCD-HOUSING ORDINARY MAI 54,450 .00 54,450.00 1,186.50 5,720.00 47,543.50 12.7% 0118451 REDEV AUTH PERSONAL SERVIC 18,000 .00 18,000.00 6,832.26 .00 11,167.74 38.0% 0118551 OSPCD-TRANS PERSONAL SERVI 386,121 55,577.00 441,698.00 131,679.40 .00 310,018.60 29.8% 0118552 OSPCD-TRANS ORDINARY MAINT 113,280 .00 113,280.00 8,893.14 790.47 103,596.39 8.5% 0118651 OSPCD-EC DEV PERSONAL SERV 404,033 .00 404,033.00 132,551.29 .00 271,481.71 32.8% 0118652 OSPCD-EC DEV ORDINARY MAIN 151,300 .00 151,300.00 1,515.65 305.00 149,479.35 1.2% 0118660 OSPSD - EC DEVELOPMENT 15,000 .00 15,000.00 .00 .00 15,000.00 .0% 0118751 OSPCD-ISD PERSONAL SERVICE 1,975,407 .00 1,975,407.00 789,944.85 .00 1,185,462.15 40.0% 0118752 OSPCD-ISD ORDINARY MAINTEN 300,800 .00 300,800.00 113,411.27 86,751.25 100,637.48 66.5% 0121051 POLICE PERSONAL SERVICES 14,374,700 -113,596.00 14,261,104.00 6,070,730.36 .00 8,190,373.64 42.6% 0121052 POLICE ORDINARY MAINTENANC 667,616 -36,969.00 630,647.00 159,371.63 100,760.47 370,514.90 41.2% 0121060 POLICE SPECIAL ITEMS 51,314 .00 51,314.00 25,200.00 10,800.00 15,314.00 70.2% 0121151 POLICE-E911 PERSONAL SERVI 846,914 .00 846,914.00 294,637.12 .00 552,276.88 34.8% 0122051 FIRE PERSONAL SERVICES 15,629,168 19,613.00 15,648,781.00 6,476,381.58 .00 9,172,399.42 41.4% 0122052 FIRE ORDINARY MAINTENANCE 458,600 .00 458,600.00 142,539.57 153,082.15 162,978.28 64.5% 0122060 FIRE DEPT SPECIAL ITEMS 2,500 .00 2,500.00 .00 924.00 1,576.00 37.0% 0122951 FIRE ALARM PERSONAL SERVIC 996,523 .00 996,523.00 448,854.08 .00 547,668.92 45.0% 0129151 EMERG MGMT PERSONAL SERVIC 20,747 .00 20,747.00 8,823.17 .00 11,923.83 42.5% 0129152 EMERG MGMT ORDINARY MAINT 5,700 .00 5,700.00 .00 2,682.60 3,017.40 47.1% 0129251 POLICE-ANIMAL CTL PERSONAL 104,581 .00 104,581.00 43,092.98 .00 61,488.02 41.2% 0129252 POLICE-ANIMAL CTL ORD MAIN 19,050 .00 19,050.00 1,406.88 1,988.12 15,655.00 17.8% 0129351 TRAFFIC & PARKING PERSONAL 2,561,292 .00 2,561,292.00 1,050,939.50 .00 1,510,352.50 41.0% 0129352 TRAFFIC & PARKING ORD MAIN 1,543,701 .00 1,543,701.00 508,123.75 359,057.54 676,519.71 56.2% 0129358 TRAFFIC AND PARKING CAPITA 0 50,629.00 50,629.00 .00 .00 50,629.00 .0% 0140151 DPW-ADMIN PERSONAL SERVICE 621,347 .00 621,347.00 214,477.91 .00 406,869.09 34.5% 0140152 DPW-ADMIN ORDINARY MAINT 921,600 .00 921,600.00 250,690.81 255,013.24 415,895.95 54.9% 0140251 DPW-ELEC PERSONAL SERVICES 344,924 .00 344,924.00 133,396.22 .00 211,527.78 38.7% 0140252 DPW-ELEC ORDINARY MAINT 233,500 .00 233,500.00 3,799.92 28,742.38 200,957.70 13.9% 0140351 DPW-ENGINEERING PERSONAL S 178,757 .00 178,757.00 64,369.39 .00 114,387.61 36.0% 0140352 DPW-ENGINEERING ORDINARY M 255,588 .00 255,588.00 30,616.03 110,052.81 114,919.16 55.0% 0140452 DPW-SNOW REMVL ORDINARY MA 1,286,000 .00 1,286,000.00 199,249.07 1,149,832.94 -63,082.01 104.9% 0140551 DPW HIGHWAY PERSONAL SERVC 2,320,697 146,300.00 2,466,997.00 1,067,697.75 .00 1,399,299.25 43.3% 0140552 DPW HIGHWAY ORDINARY MAINT 1,353,095 36,969.00 1,390,064.00 404,142.30 481,742.22 504,179.48 63.7% 0140652 DPW-SANITATION ORDINARY MA 5,675,208 .00 5,675,208.00 1,618,454.95 3,334,547.72 722,205.33 87.3% 0140751 DPW-BLGD&GRNDS PERSONAL SV 2,161,895 .00 2,161,895.00 952,279.28 .00 1,209,615.72 44.0% 0140752 DPW-BLGD&GRNDS ORDINARY MA 8,989,531 .00 8,989,531.00 2,677,146.60 1,788,564.65 4,523,819.75 49.7% 0141151 DPW-SCHL CUSTDN PERSONAL S 1,865,892 .00 1,865,892.00 732,457.26 .00 1,133,434.74 39.3%

01/30/2017 10:12 |City of Somerville |P 3 icody |2016 |glytdbud FOR 2017 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 0001 CITY GENERAL FUND APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ 0141152 SCHL CUSTO ORDINARY MAINTE 888,502 .00 888,502.00 369,960.00 517,944.00 598.00 99.9% 0142951 DPW-WEIGHTS&MEAS PERSONAL 0 .00 .00 313.90 .00 -313.90 100.0% 0151251 BOARD OF HEALTH PERSONAL S 2,062,712 .00 2,062,712.00 792,539.08 .00 1,270,172.92 38.4% 0151252 BOARD OF HEALTH ORDINARY M 471,942 .00 471,942.00 118,479.00 232,615.75 120,847.25 74.4% 0154351 VETERANS BENEFITS PERSONAL 121,294 .00 121,294.00 51,207.16 .00 70,086.84 42.2% 0154352 VETERANS BENEFITS ORDINARY 634,035 .00 634,035.00 243,959.61 .00 390,075.39 38.5% 0161051 LIBRARIES PERSONAL SERVICE 1,781,994 .00 1,781,994.00 760,126.28 .00 1,021,867.72 42.7% 0161052 LIBRARIES ORDINARY MAINTEN 339,911 .00 339,911.00 186,884.29 110,211.69 42,815.02 87.4% 0163051 REC/YOUTH PROG PERSONAL SV 630,811 .00 630,811.00 288,572.77 .00 342,238.23 45.7% 0163052 REC/YOUTH PROG ORDINARY MA 201,550 .00 201,550.00 68,800.46 18,442.08 114,307.46 43.3% 0163351 RECREATION - FIELDS 67,760 .00 67,760.00 .00 .00 67,760.00 .0% 0163352 RECREATION - FIELDS 260,000 .00 260,000.00 .00 110,000.00 150,000.00 42.3% 0170059 DEBT SERVICE 10,748,066 .00 10,748,066.00 3,656,348.15 .00 7,091,717.85 34.0% 0182052 STATE & COUNTY ASSESSMENTS 14,033,137 1,864.00 14,035,001.00 3,874,939.00 .00 10,160,062.00 27.6% 0190151 HEALTH & LIFE INS PERSONAL 21,764,950 .00 21,764,950.00 10,729,878.97 .00 11,035,071.03 49.3% 0190152 HEALTH & LIFE INS ORDINARY 290,000 .00 290,000.00 116,652.75 19,830.37 153,516.88 47.1% 0190251 LIFE INS & FLEX SPEND PS 99,443 .00 99,443.00 37,708.20 2,725.25 59,009.55 40.7% 0190351 MEDICARE & SSI PS 1,535,000 .00 1,535,000.00 694,275.38 .00 840,724.62 45.2% 0191051 WORKERS COMP PERSONAL SVC 454,043 .00 454,043.00 188,453.47 .00 265,589.53 41.5% 0191052 WORKERS COMP ORDINARY MAIN 364,700 .00 364,700.00 77,290.45 54,814.60 232,594.95 36.2% 0191551 UNEMPLOYMENT COMP PERSONAL 125,000 .00 125,000.00 79,761.66 .00 45,238.34 63.8% 0192052 PENSION/NON-CONTRIB ORD MA 121,265 .00 121,265.00 59,617.97 .00 61,647.03 49.2% 0192151 PENSION ACCUM FUND PERSONL 13,711,675 .00 13,711,675.00 13,711,675.00 .00 .00 100.0% 0194352 BUILDING INSUR ORDINARY MA 460,058 .00 460,058.00 407,810.29 7,595.61 44,652.10 90.3% 0197059 OTHER FINANCING USES 199,000 .00 199,000.00 .00 .00 199,000.00 .0% 0199052 DAMAGE TO PERSON & PROPERT 175,000 -140,000.00 35,000.00 20,273.74 .00 14,726.26 57.9% 0199851 BENEFITS REIMBURSEMENT 0 .00 .00 -73,005.54 .00 73,005.54 100.0% 0199951 CONTINGENCY ACCOUNT 1,322,449 -107,894.00 1,214,555.00 42,230.95 .00 1,172,324.05 3.5% TOTAL CITY GENERAL FUND 155,476,942 52,493.00 155,529,435.00 67,134,605.78 9,800,555.93 78,594,273.29 49.5%

01/30/2017 10:12 |City of Somerville |P 4 icody |2016 |glytdbud FOR 2017 06 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ GRAND TOTAL 155,476,942 52,493.00 155,529,435.00 67,134,605.78 9,800,555.93 78,594,273.29 49.5% ** END OF REPORT - Generated by Ida Cody **

01/30/2017 10:12 |City of Somerville |P 5 icody |2016 |glytdbud REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Field # Total Page Break Sequence 1 1 Y Y Sequence 2 9 Y N Sequence 3 0 N N Sequence 4 0 N N Report title: 2016 Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2017/ 6 Print Full or Short description: S Print MTD Version: N Print full GL account: N Format type: 2 Roll projects to object: N Double space: N Carry forward code: 2 Suppress zero bal accts: Y Include requisition amount: N Print Revenues-Version headings: N Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: N Print journal detail: N From Yr/Per: 2015/13 To Yr/Per: 2015/13 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: F Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Fund 0001 Func Year Prog/DOEFunc Dept/Loc SDeptSubject Rev DOEPrg Budget Ctrl Character Code Org Object Project Account type Expense

01/30/2017 10:12 |City of Somerville |P 6 icody |2016 |glytdbud REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code