Matters ▸ Attachment
SEWER — File 202900
02/08/2017 11:39
|City of Somerville
|P 1
icody
|2016
|glytdbud
FOR 2017 06
ACCOUNTS FOR:
ORIGINAL
TRANFRS/
REVISED
AVAILABLE
PCT
6400 ENTERPRISE FUND - SEWER APPROP
ADJSTMTS
BUDGET
YTD ACTUAL
ENCUMBRANCES
BUDGET
USED
____________________________________________________________________________________________________________________________________
64004 SEWER REVENUE
_________________________________________
64004 414200 SWR TT
-45,151 45,151.00 .00 -32,727.81 .00 32,727.81 100.0%
64004 414202 SWR LIEN
-475,000 475,000.00 .00 -8,118.14 .00 8,118.14 100.0%
64004 417004 INT TT
-11,500 11,500.00 .00 -12,003.22 .00 12,003.22 100.0%
64004 417008 P&I USER
-135,000 135,000.00 .00 -60,859.74 .00 60,859.74 100.0%
64004 421001 SWR USAGE
-21,112,949 1,212,949.00 -19,900,000.00 -10,304,717.03 .00 -9,595,282.97 51.8%
64004 421500 BASE CHARG
0 -1,880,000.00 -1,880,000.00 -636,692.01 .00 -1,243,307.99 33.9%*
64004 482000 INTEREST
-400 400.00 .00 -210.67 .00 210.67 100.0%
TOTAL SEWER REVENUE -21,780,000 .00 -21,780,000.00 -11,055,328.62 .00 -10,724,671.38 50.8%
640051 SEWER PERSONAL SERVICES
_________________________________________
640051 511000 SALARIES
139,005 .00 139,005.00 47,190.09 .00 91,814.91 33.9%
640051 511004 SAL CONTIN
23,102 .00 23,102.00 .00 .00 23,102.00 .0%
640051 511300 WAGES
252,857 .00 252,857.44 108,327.12 .00 144,530.32 42.8%
640051 513000 OT
5,000 .00 5,000.00 2,838.68 .00 2,161.32 56.8%*
640051 513002 OT - LABOR
50,000 .00 50,000.00 12,451.66 .00 37,548.34 24.9%
640051 514008 OOG LABOR
4,000 .00 4,000.00 1,848.60 .00 2,151.40 46.2%
640051 514009 LONG LABOR
2,100 .00 2,100.00 1,050.00 .00 1,050.00 50.0%
640051 514015 OTHR DIFF
9,499 .00 9,499.29 3,752.25 .00 5,747.04 39.5%
640051 515006 HOL NON U
446 .00 446.00 .00 .00 446.00 .0%
640051 515011 HOL SMEA
1,607 .00 1,607.47 .00 .00 1,607.47 .0%
640051 515012 PERF ATTND
0 .00 .00 500.00 .00 -500.00 100.0%*
640051 519004 UNIF ALLOW
1,930 .00 1,930.00 1,580.00 .00 350.00 81.9%*
640051 519015 AUTO ALLOW
330 .00 330.00 96.25 .00 233.75 29.2%
TOTAL SEWER PERSONAL SERVICES 489,877 .00 489,877.20 179,634.65 .00 310,242.55 36.7%
640052 SEWER ORDINARY MAINTENANCE
_________________________________________
640052 524003 R&M VEH
40,000 .00 40,000.00 6,481.72 29,516.91 4,001.37 90.0%*
640052 524013 R&M TL&EQ
500 .00 500.00 .00 .00 500.00 .0%
640052 527006 LEASE COPY
4,361 .00 4,361.00 1,128.36 2,563.36 669.28 84.7%*
640052 529003 RUBSH RMVL
25,000 .00 25,000.00 8,235.00 6,765.00 10,000.00 60.0%*
640052 529012 DSP C BASN
85,000 .00 85,000.00 .00 .00 85,000.00 .0%
640052 530000 PROF&TECH
565,000 -23,787.50 541,212.50 18,595.00 223,535.00 299,082.50 44.7%
02/08/2017 11:39
|City of Somerville
|P 2
icody
|2016
|glytdbud
FOR 2017 06
ACCOUNTS FOR:
ORIGINAL
TRANFRS/
REVISED
AVAILABLE
PCT
6400 ENTERPRISE FUND - SEWER APPROP
ADJSTMTS
BUDGET
YTD ACTUAL
ENCUMBRANCES
BUDGET
USED
____________________________________________________________________________________________________________________________________
640052 530008 EE TRAIN
1,300 .00 1,300.00 .00 .00 1,300.00 .0%
640052 530018 POL DETL
60,000 .00 60,000.00 38,118.10 1,242.82 20,639.08 65.6%*
640052 530026 BANK CHGS
2,000 .00 2,000.00 936.28 .00 1,063.72 46.8%
640052 542000 OFF SUPP
500 .00 500.00 .00 .00 500.00 .0%
640052 542001 PRINT&STAT
1,000 .00 1,000.00 30.00 .00 970.00 3.0%
640052 542005 OFF EQUIP
0 2,487.50 2,487.50 2,487.50 .00 .00 100.0%*
640052 543003 TOOLS
2,000 .00 2,000.00 .00 .00 2,000.00 .0%
640052 543007 PAINT
750 .00 750.00 .00 .00 750.00 .0%
640052 543011 HW SM TOOL
7,000 .00 7,000.00 2,229.18 622.02 4,148.80 40.7%
640052 548001 MOTOR G&O
37,950 .00 37,950.00 .00 .00 37,950.00 .0%
640052 548006 MOTOR P&A
10,000 21,300.00 31,300.00 21,299.87 5,000.00 5,000.13 84.0%*
640052 553002 BITUM SUPP
25,000 .00 25,000.00 4,903.06 96.94 20,000.00 20.0%
640052 553003 READY MIX
10,000 .00 10,000.00 .00 .00 10,000.00 .0%
640052 553005 PIPE SUPP
20,000 .00 20,000.00 .00 8,000.00 12,000.00 40.0%
640052 553006 MASONRY
25,000 .00 25,000.00 7,840.45 7,159.55 10,000.00 60.0%*
640052 553007 FOUNDRY
25,000 .00 25,000.00 .00 .00 25,000.00 .0%
640052 578007 REIM LIC
330 .00 330.00 255.00 .00 75.00 77.3%*
TOTAL SEWER ORDINARY MAINTENAN 947,691 .00 947,691.00 112,539.52 284,501.60 550,649.88 41.9%
640058 SEWER CAPITAL OUTLAY
_________________________________________
640058 580010 CAP IMPVMT
200,000 -200,000.00 .00 .00 .00 .00 .0%
640058 582003 BLDG IMP
10,000 .00 10,000.00 .00 .00 10,000.00 .0%
640058 585000 EQUIPMT
15,000 .00 15,000.00 .00 .00 15,000.00 .0%
640058 588002 STREET REP
75,000 -75,000.00 .00 .00 .00 .00 .0%
640058 588007 SWR CL REP
200,000 275,000.00 475,000.00 464,871.40 10,128.60 .00 100.0%*
TOTAL SEWER CAPITAL OUTLAY 500,000 .00 500,000.00 464,871.40 10,128.60 25,000.00 95.0%
640059 SEWER DEBT SERVICE / OFU
_________________________________________
640059 591000 PRINC LTD
630,342 .00 630,342.00 265,051.10 .00 365,290.90 42.0%
640059 591500 INT ON LTD
50,037 .00 50,037.00 26,068.13 .00 23,968.87 52.1%*
640059 592500 INT ON N/B
7,000 .00 7,000.00 .00 .00 7,000.00 .0%
TOTAL SEWER DEBT SERVICE / OFU 687,379 .00 687,379.00 291,119.23 .00 396,259.77 42.4%
640060 SEWER SPECIAL ITEMS
_________________________________________
640060 523003 MWRA
16,020,502 .00 16,020,502.00 7,959,017.50 .00 8,061,484.50 49.7%
02/08/2017 11:39
|City of Somerville
|P 3
icody
|2016
|glytdbud
FOR 2017 06
ACCOUNTS FOR:
ORIGINAL
TRANFRS/
REVISED
AVAILABLE
PCT
6400 ENTERPRISE FUND - SEWER APPROP
ADJSTMTS
BUDGET
YTD ACTUAL
ENCUMBRANCES
BUDGET
USED
____________________________________________________________________________________________________________________________________
640060 596010 INDIRECTS
655,701 .00 655,701.00 .00 .00 655,701.00 .0%
640060 596011 OPEB
500,000 .00 500,000.00 .00 .00 500,000.00 .0%
TOTAL SEWER SPECIAL ITEMS 17,176,203 .00 17,176,203.00 7,959,017.50 .00 9,217,185.50 46.3%
TOTAL ENTERPRISE FUND - SEWER -1,978,850 .00 -1,978,849.80 -2,048,146.32 294,630.20 -225,333.68 88.6%
TOTAL REVENUES -21,780,000 .00 -21,780,000.00 -11,055,328.62 .00 -10,724,671.38
TOTAL EXPENSES 19,801,150 .00 19,801,150.20 9,007,182.30 294,630.20 10,499,337.70
02/08/2017 11:39
|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,978,850 .00 -1,978,849.80 -2,048,146.32 294,630.20 -225,333.68 88.6%
** END OF REPORT - Generated by Ida Cody **
02/08/2017 11:39
|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
6400
Func
Year
Prog/DOEFunc
Dept/Loc
SDeptSubject
Rev DOEPrg
Budget Ctrl
Character Code
Org
Object
Project
Account type
02/08/2017 11:39
|City of Somerville
|P 6
icody
|2016
|glytdbud
REPORT OPTIONS
____________________________________________________________________________________________________________________________________
Account status
Rollup Code