WATER — File 202900

02/08/2017 11:38 |City of Somerville |P 1 icody |2016 |glytdbud FOR 2017 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 6000 ENTERPRISE FUND - WATER APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ 60004 WATER REVENUES _________________________________________ 60004 414200 WTR TT -30,000 30,000.00 .00 -22,624.40 .00 22,624.40 100.0% 60004 414202 WTR LIEN -250,000 250,000.00 .00 -5,062.40 .00 5,062.40 100.0% 60004 417004 INT TT -3,000 3,000.00 .00 -7,222.48 .00 7,222.48 100.0% 60004 417008 P&I USER -70,000 70,000.00 .00 -38,570.06 .00 38,570.06 100.0% 60004 417011 PEN WS FEE -40,500 40,500.00 .00 -1,058.65 .00 1,058.65 100.0% 60004 421001 WTR USAGE -12,630,048 480,048.00 -12,150,000.00 -6,806,260.98 .00 -5,343,739.02 56.0% 60004 421500 BASE CHARG 0 -940,848.00 -940,848.00 -318,620.62 .00 -622,227.38 33.9%* 60004 422005 HYDRANT -20,000 20,000.00 .00 -48,546.07 .00 48,546.07 100.0% 60004 422006 WTR FINAL -20,000 20,000.00 .00 -11,825.00 .00 11,825.00 100.0% 60004 422008 FIRE SUP -750,000 .00 -750,000.00 .00 .00 -750,000.00 .0%* 60004 468013 CC SURVEY -52,000 52,000.00 .00 -29,800.00 .00 29,800.00 100.0% 60004 482000 INTEREST -300 300.00 .00 -140.44 .00 140.44 100.0% 60004 484000 MISC REV -100,000 -25,000.00 -125,000.00 -48,885.00 .00 -76,115.00 39.1%* TOTAL WATER REVENUES -13,965,848 .00 -13,965,848.00 -7,338,616.10 .00 -6,627,231.90 52.5% 600051 WATER PERSONAL SERVICES _________________________________________ 600051 511000 SALARIES 689,772 .00 689,772.00 274,237.63 .00 415,534.37 39.8% 600051 511004 SAL CONTIN 60,782 .00 60,782.00 .00 .00 60,782.00 .0% 600051 511300 WAGES 383,819 .00 383,819.00 131,442.66 .00 252,376.34 34.2% 600051 513000 OT 15,000 .00 15,000.00 7,629.79 .00 7,370.21 50.9%* 600051 513002 OT - LABOR 100,000 .00 100,000.00 64,140.03 .00 35,859.97 64.1%* 600051 514006 LONGEVITY 3,950 .00 3,950.00 1,975.00 .00 1,975.00 50.0%* 600051 514008 OOG LABOR 5,000 .00 5,000.00 1,890.07 .00 3,109.93 37.8% 600051 514009 LONG LABOR 3,750 .00 3,750.00 1,350.00 .00 2,400.00 36.0% 600051 514015 OTHR DIFF 20,316 .00 20,316.00 4,884.76 .00 15,431.24 24.0% 600051 515006 HOL NON U 2,191 .00 2,191.00 .00 .00 2,191.00 .0% 600051 515011 HOL SMEA 4,452 .00 4,452.00 .00 .00 4,452.00 .0% 600051 515012 PERF ATTND 0 .00 .00 600.00 .00 -600.00 100.0%* 600051 519004 UNIF ALLOW 4,730 .00 4,730.00 3,680.00 .00 1,050.00 77.8%* 600051 519015 AUTO ALLOW 880 .00 880.00 142.08 .00 737.92 16.1% TOTAL WATER PERSONAL SERVICES 1,294,642 .00 1,294,642.00 491,972.02 .00 802,669.98 38.0% 600052 WATER ORDNARY MAINTENANCE _________________________________________ 600052 524003 R&M VEH 5,000 .00 5,000.00 333.23 4,666.77 .00 100.0%*

02/08/2017 11:38 |City of Somerville |P 2 icody |2016 |glytdbud FOR 2017 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 6000 ENTERPRISE FUND - WATER APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ 600052 524013 R&M TL&EQ 2,500 .00 2,500.00 .00 2,487.55 12.45 99.5%* 600052 524017 R&M EQUIP 25,000 -25,000.00 .00 .00 .00 .00 .0% 600052 524034 R&M SVC CN 1,000 25,000.00 26,000.00 39.00 .00 25,961.00 .2% 600052 527018 POST MACH 800 .00 800.00 .00 .00 800.00 .0% 600052 529003 RUBSH RMVL 35,000 .00 35,000.00 15,900.00 1,225.00 17,875.00 48.9% 600052 530000 PROF&TECH 250,000 -42,487.50 207,512.50 14,500.00 6,500.00 186,512.50 10.1% 600052 530008 EE TRAIN 5,000 .00 5,000.00 .00 .00 5,000.00 .0% 600052 530011 ADVERTISNG 250 .00 250.00 55.00 .00 195.00 22.0% 600052 530018 POL DETL 150,000 .00 150,000.00 9,721.12 .00 140,278.88 6.5% 600052 530026 BANK CHGS 1,200 .00 1,200.00 461.15 .00 738.85 38.4% 600052 534003 POSTAGE 2,000 .00 2,000.00 215.00 .00 1,785.00 10.8% 600052 534008 WEB SITE 10,500 .00 10,500.00 10,500.00 .00 .00 100.0%* 600052 542000 OFF SUPP 3,055 .00 3,055.00 995.48 4.52 2,055.00 32.7% 600052 542001 PRINT&STAT 40,000 .00 40,000.00 23,047.50 13,818.85 3,133.65 92.2%* 600052 542005 OFF EQUIP 0 2,487.50 2,487.50 2,487.50 .00 .00 100.0%* 600052 542006 OFF FURN 2,000 .00 2,000.00 .00 .00 2,000.00 .0% 600052 543002 PLMB SUPP 400 .00 400.00 .00 .00 400.00 .0% 600052 543003 TOOLS 6,000 -1,924.10 4,075.90 .00 .00 4,075.90 .0% 600052 543007 PAINT 1,000 .00 1,000.00 784.00 .00 216.00 78.4%* 600052 543011 HW SM TOOL 7,500 1,924.10 9,424.10 7,116.58 2,307.52 .00 100.0%* 600052 545000 MAINT SUPP 2,500 .00 2,500.00 .00 .00 2,500.00 .0% 600052 546003 SAND GRAV 750 .00 750.00 .00 .00 750.00 .0% 600052 548001 MOTOR G&O 37,950 .00 37,950.00 .00 .00 37,950.00 .0% 600052 548004 TIRE&TUBES 3,000 .00 3,000.00 .00 3,000.00 .00 100.0%* 600052 548006 MOTOR P&A 2,500 10,000.00 12,500.00 9,986.00 2,500.00 14.00 99.9%* 600052 551004 BOOKS 1,000 .00 1,000.00 .00 .00 1,000.00 .0% 600052 553001 SIGN&CONES 5,000 .00 5,000.00 .00 .00 5,000.00 .0% 600052 553002 BITUM SUPP 25,000 .00 25,000.00 4,951.30 48.70 20,000.00 20.0% 600052 553003 READY MIX 12,500 .00 12,500.00 .00 .00 12,500.00 .0% 600052 553004 LUMBR&WOOD 2,000 .00 2,000.00 .00 .00 2,000.00 .0% 600052 553007 FOUNDRY 5,000 .00 5,000.00 .00 .00 5,000.00 .0% 600052 558006 UNIFORMS 1,000 .00 1,000.00 .00 .00 1,000.00 .0% 600052 569000 PMT TO MA 40,080 .00 40,080.00 .00 .00 40,080.00 .0% 600052 571000 IN ST TRAV 100 .00 100.00 .00 .00 100.00 .0% 600052 573000 DUES&MEMBR 1,000 .00 1,000.00 .00 .00 1,000.00 .0% 600052 578007 REIM LIC 1,000 .00 1,000.00 295.00 .00 705.00 29.5% 600052 588508 MTR INSTL 0 30,000.00 30,000.00 .00 30,000.00 .00 100.0%* TOTAL WATER ORDNARY MAINTENANC 688,585 .00 688,585.00 101,387.86 66,558.91 520,638.23 24.4% 600058 WATER CAPITAL OUTLAY _________________________________________ 600058 580010 CAP IMPVMT 200,000 -190,646.75 9,353.25 .00 .00 9,353.25 .0%

02/08/2017 11:38 |City of Somerville |P 3 icody |2016 |glytdbud FOR 2017 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 6000 ENTERPRISE FUND - WATER APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ 600058 588002 STREET REP 0 20,500.00 20,500.00 .00 20,324.43 175.57 99.1% 600058 588501 WTR MTR 70,000 14,046.75 84,046.75 76,351.00 7,695.75 .00 100.0%* 600058 588502 HYDRANTS 30,000 -2,500.00 27,500.00 26,469.50 27.00 1,003.50 96.4%* 600058 588503 LEAK DET 20,000 -10,000.00 10,000.00 .00 .00 10,000.00 .0% 600058 588504 PIPE FITTN 75,000 -40,000.00 35,000.00 23,429.88 .00 11,570.12 66.9%* 600058 588505 WTR SV REP 37,000 245,100.00 282,100.00 241,377.72 35,722.28 5,000.00 98.2%* 600058 588506 WTR RECON 38,000 -30,500.00 7,500.00 .00 .00 7,500.00 .0% 600058 588508 MTR INSTL 30,000 -6,000.00 24,000.00 .00 .00 24,000.00 .0% TOTAL WATER CAPITAL OUTLAY 500,000 .00 500,000.00 367,628.10 63,769.46 68,602.44 86.3% 600059 WATER DEBT SERVICE / OFU _________________________________________ 600059 591000 PRINC LTD 1,388,044 .00 1,388,044.00 822,305.30 .00 565,738.70 59.2%* 600059 591500 INT ON LTD 101,473 .00 101,473.00 55,298.75 .00 46,174.25 54.5%* 600059 592500 INT ON N/B 5,000 .00 5,000.00 .00 .00 5,000.00 .0% TOTAL WATER DEBT SERVICE / OFU 1,494,517 .00 1,494,517.00 877,604.05 .00 616,912.95 58.7% 600060 WATER SPECIAL ITEMS _________________________________________ 600060 523003 MWRA 7,688,467 .00 7,688,467.00 3,829,145.00 .00 3,859,322.00 49.8% 600060 596010 INDIRECTS 631,696 .00 631,696.00 .00 .00 631,696.00 .0% 600060 596011 OPEB 500,000 .00 500,000.00 .00 .00 500,000.00 .0% TOTAL WATER SPECIAL ITEMS 8,820,163 .00 8,820,163.00 3,829,145.00 .00 4,991,018.00 43.4% TOTAL ENTERPRISE FUND - WATER -1,167,941 .00 -1,167,941.00 -1,670,879.07 130,328.37 372,609.70 131.9% TOTAL REVENUES -13,965,848 .00 -13,965,848.00 -7,338,616.10 .00 -6,627,231.90 TOTAL EXPENSES 12,797,907 .00 12,797,907.00 5,667,737.03 130,328.37 6,999,841.60

02/08/2017 11:38 |City of Somerville |P 4 icody |2016 |glytdbud FOR 2017 06 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED ____________________________________________________________________________________________________________________________________ GRAND TOTAL -1,167,941 .00 -1,167,941.00 -1,670,879.07 130,328.37 372,609.70 131.9% ** END OF REPORT - Generated by Ida Cody **

02/08/2017 11:38 |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: N 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 6000 Func Year Prog/DOEFunc Dept/Loc SDeptSubject Rev DOEPrg Budget Ctrl Character Code Org Object Project Account type

02/08/2017 11:38 |City of Somerville |P 6 icody |2016 |glytdbud REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code