JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
Community Development AIO004
CD RIVERWALK PROJECT
8,932,352.00
5,235,808.06
3,831,009.00
272,338.56
1,040,837.20
2,517,833.24
AIO016
CD Dunlawton Walk Light
82,440.00
14,111.24
82,440.00
14,111.24
7,638.76
60,690.00
AIO017
CD CITY ENTRANCE SIGN DEV
75,000.00
7,500.00
75,000.00
7,500.00
5,000.00
62,500.00
AIO022
CD Dnlwtn Medians Ph I&II
312,500.00
16,650.00
306,950.00
11,100.00
1,850.00
294,000.00
AIO026
CD S.RidgewoodAve Irrgtn
187,000.00
0.00
187,000.00
0.00
0.00
187,000.00
AIO027
CD S.RidgewoodAveLandscpe
5,000.00
0.00
5,000.00
0.00
0.00
5,000.00
DIP057
CD Ridgewd CorrDrn&PubSpc
0.00
0.00
0.00
0.00
0.00
0.00
20,880.00
18,680.00
10,000.00
7,800.00
0.00
2,200.00
5,500.00
0.00
5,500.00
0.00
0.00
5,500.00
11,000.00
0.00
11,000.00
0.00
0.00
11,000.00
9,631,672.00
5,292,749.30
4,513,899.00
312,849.80
1,055,325.96
3,145,723.24
IMI008
CD TrafCtrlImpr SunsetCv
IMI010
CD Herbert/NovaInterLghtg
ZMI046
CD LED TRAFFIC LIGHT REPL Community Development Total:
City Management AIO013
CM CITY HALL RENOVATION
120,747.00
108,182.00
59,902.00
47,337.60
12,236.34
328.06
AIO014
CM OLD PD RENOVATIONS
400,000.00
0.00
400,000.00
0.00
0.00
400,000.00
AIO021
CM YOUTH ADVISORY BOARD
AIO023
CM City Manager Search
AIO024 AIO025
494.00
0.00
494.00
0.00
0.00
494.00
50,001.00
12,950.39
49,050.00
12,000.13
4,917.00
32,132.87
CM CHGC Renovations
784,957.00
594,547.73
784,957.00
594,547.73
190,409.27
0.00
CM CHGC Clubhouse Renovtn
465,043.00
12,100.00
465,043.00
12,100.00
3,900.00
449,043.00
CDBG04
CM CDBG AQUIRE PROPERTY
208,134.00
208,033.50
0.00
0.00
100.00
CDBG05
CM CDBG DEMO PROPERTY
19,479.00
17,979.00
19,479.00
17,979.00
1,500.00
0.00
CDBG06
CM CDBG ROAD REPAIR
221,296.00
150,802.52
221,296.00
150,802.52
70,420.81
72.67
ZCV002
CM HISTORIC TREE MITIGATN
233,161.00
27,281.15
116,331.00
1,875.00
0.00
114,456.00
ZMI003
CM CITY TELEVISION STA
385,388.00
185,031.36
49,728.00
11,897.96
0.00
37,830.04
2,888,700.00
1,316,907.65
2,166,280.00
848,439.94
283,383.42
1,034,456.64
City Management Total:
8/10/2015 / 2:44 PM / 1 of 7
(100.00)
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager
JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
Fire FIR001
F EMS TRAINING PROGRAMS
FIR002
F SHARPS PROGRAM
19,442.00
14,388.95
7,320.00
2,269.41
0.00
5,050.59
3,812.00
2,292.00
1,970.00
450.00
0.00
1,520.00
FIR005
F THERMAL IMAGING CAMERAS
28,490.00
28,135.00
354.00
0.00
0.00
354.00
FIR007
F RADIO REPLC P-25 COMPLY
62,554.00
26,377.14
36,176.00
0.00
7,107.18
29,068.82
FIR011
F FIRE BUNKER GEAR
68,922.00
41,773.54
36,004.00
8,856.89
7,187.82
19,959.29
FIR012
F Relocate EOC to New PD Fire Total:
25,000.00
0.00
25,000.00
0.00
0.00
25,000.00
208,220.00
112,966.63
106,824.00
11,576.30
14,295.00
80,952.70
95,900.00
0.00
95,900.00
0.00
0.00
95,900.00
Finance ZMI047
FN INTERACTIVE VOICE RECO
ZMI053
FN CS Scanner / Printers Finance Total:
15,000.00
10,332.00
15,000.00
10,332.00
0.00
4,668.00
110,900.00
10,332.00
110,900.00
10,332.00
0.00
100,568.00
25,000.00
17,800.00
16,100.00
8,900.00
0.00
7,200.00
25,000.00
17,800.00
16,100.00
8,900.00
0.00
7,200.00
Human Resources AIO019
HR COMPENSATION STUDY Human Resources Total:
8/10/2015 / 2:44 PM / 2 of 7
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager
JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
Information Technology ZMI013
IP LARGE FORMAT PRINTERS
14,997.00
8,997.00
6,000.00
0.00
0.00
6,000.00
ZMI015
IP MUNICIPAL NETWORK
241,517.00
187,553.42
77,963.00
0.00
0.00
77,963.00
ZMI016
IP COMPUTER HARDWARE
255,899.00
187,873.88
72,260.00
9,863.79
0.00
62,396.21
ZMI018
IP E-GOVT BASED SERVICES
7,500.00
0.00
7,500.00
0.00
0.00
7,500.00
ZMI029
IP FIBER OPTIC PROJ PH 2
8,822.00
3,615.00
5,206.00
0.00
0.00
5,206.00
ZMI032
IT PublicSafetyLaptopRplc
164,153.00
119,703.38
59,304.00
24,164.38
12,655.44
22,484.18
ZMI036
IT PCI COMPLIANCE PROJECT
45,964.00
36,816.70
3,213.00
0.00
0.00
3,213.00
ZMI037
IT Doc Collbrtn EOC Softw
48,000.00
0.00
48,000.00
0.00
0.00
48,000.00
ZMI038
IT StratPln/RiskAsmntRfrs
91,000.00
27,000.00
64,000.00
0.00
0.00
64,000.00
ZMI040
IT VIDEO SECURITY SYSTEM
166,139.00
138,109.00
28,030.00
0.00
16,995.29
11,034.71
ZMI042
IP HTE SOFTWARE UPGRADES
93,315.00
88,074.21
5,240.00
0.00
0.00
5,240.00
ZMI045
IT HTE UTILITIES IMAGING
20,040.00
13,840.75
6,198.00
0.00
0.00
6,198.00
ZMI049
IT BARCODE HARDW/SORFTWR
0.00
0.00
0.00
0.00
0.00
0.00
ZMI050
IT NETWRK CORE SWITCH UPD
83,521.00
79,667.83
83,521.00
79,667.83
0.00
3,853.17
ZMI051
IT PD Impound Surveillanc
16,479.00
16,479.00
16,479.00
16,479.00
0.00
0.00
ZMI052
IT Council Chambers A/V
36,500.00
0.00
36,500.00
0.00
36,113.45
386.55
ZMI054
IT EnterpriseFinancialSys
1,000,000.00
0.00
1,000,000.00
0.00
0.00
1,000,000.00
50,000.00
6,360.00
50,000.00
6,360.00
9,540.00
34,100.00
0.00
0.00
0.00
0.00
0.00
0.00
2,343,846.00
914,090.17
1,569,414.00
136,535.00
75,304.18
1,357,574.82
ZMI055
IT Fiber OpticNetwrk Expn
ZMI056
IT NewEmploy Hardwr/Sftwr Information Technology Total:
Law Enforcement AIO020
LE PET SMART GRANT
CNE009
LE PUB SAFETY TRAIN FACIL Law Enforcement Total:
8/10/2015 / 2:44 PM / 3 of 7
18,000.00
12,400.99
5,599.00
0.00
0.00
5,599.00
1,100,000.00
4,050.00
1,095,950.00
0.00
31,050.00
1,064,900.00
1,118,000.00
16,450.99
1,101,549.00
0.00
31,050.00
1,070,499.00
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager
JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
Public Works AIO028
P City Hall ElevatorRehab
BNE001
P MISC BIKE PATHS
15,000.00
0.00
15,000.00
0.00
0.00
15,000.00
949,917.00
894,625.61
36,190.00
0.00
0.00
36,190.00
DIP001
P MISC DRAINAGE PROJECTS
789,131.00
495,400.40
15,312.00
15,312.00
0.00
0.00
DIP021
P B23 CANAL GRANT PHASE 1
1,916,892.00
1,738,170.45
9,690.00
1,260.00
8,430.00
0.00
DIP033
P MISC RELINE DRAIN PIPES
2,279,490.00
2,332,593.33
53,417.00
49,305.00
3,139.00
973.00
DIP044
P STORM SEWER RECONSTRUC
13,387.00
5,489.38
13,387.00
5,489.38
0.00
7,897.62
DIP048
P DUNLAWTON DRAINAGE IMPV
3,657,811.00
3,657,805.95
0.00
0.00
0.00
0.00
DIP053
P CAMBRIDGE STABILIZATION
1,494,349.00
1,480,938.16
18,420.00
5,010.00
13,409.26
0.74
DIP055
P Stormwater Master Plan
225,000.00
0.00
225,000.00
0.00
0.00
225,000.00
DIP056
P Cambridge Stablztn PhII
1,297,500.00
0.00
1,297,500.00
0.00
796,126.00
501,374.00
DIP058
P Ditch Clearing-Drainage
83,121.00
0.00
83,121.00
0.00
0.00
83,121.00
DIP059
P Virginia/MonroeDrainIm
94,000.00
0.00
94,000.00
0.00
93,340.00
660.00
DIP060
P SleepyHollow Drain.Impr
189,000.00
0.00
189,000.00
0.00
189,000.00
0.00
DIP062
P Ryanwood Drain Imprvmnt
97,000.00
0.00
97,000.00
0.00
0.00
97,000.00
DIP063
P Cypress Cove Pipe Rplcm
270,000.00
0.00
270,000.00
0.00
0.00
270,000.00
DIP064
P Asset Mgmt Software Sys
60,000.00
0.00
60,000.00
0.00
0.00
60,000.00
DIP065
P CityHall Retention Pond
42,000.00
0.00
42,000.00
0.00
0.00
42,000.00
DIP066
P Pipe Culvert Niver etc.
IMI001
P SIGNAGE
IMI002
P STREET STRIPING
IMI003
P EMG TRAFFIC CONTROL SYS
27,700.00
IMI006
P GUARDRAIL REPAIRS
50,397.00
OBM001
P CITY HALL EXTERIOR
50,154.00
46,550.00
3,604.00
0.00
0.00
3,604.00
OBM002
P PUBLIC WORKS BLD MAINT
1,500.00
0.00
1,500.00
0.00
0.00
1,500.00
OBM004
P CUS SVC STAGE ADA COMP
25,000.00
21,920.00
3,080.00
0.00
0.00
3,080.00
OMI001
P OAK ST RR CROSSING
135,095.00
88,077.74
51,701.00
1,701.00
0.00
50,000.00
OMI002
P CHARLES ST RR CROSSING
202,801.00
146,936.95
51,701.00
1,701.00
0.00
50,000.00
OMI007
P SIDEWALK MAINTENANCE
1,279,658.00
1,182,433.30
204,081.00
139,348.25
64,732.25
0.50
OMI014
P SP CREEK RD - SO TRAIL
400,692.00
182,602.12
367,549.00
149,459.95
166,643.31
51,445.74
OMI015
P CLYDE MORRIS SIDEWALK
40,832.00
0.00
40,832.00
0.00
0.00
40,832.00
8/10/2015 / 2:44 PM / 4 of 7
29,000.00
0.00
29,000.00
0.00
0.00
29,000.00
458,330.00
416,036.11
63,405.00
29,942.60
0.00
33,462.40
1,469,394.00
1,380,624.42
98,610.00
16,970.42
0.00
81,639.58
0.00
35,000.00
0.00
0.00
35,000.00
15,397.00
35,000.00
0.00
0.00
35,000.00
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager
JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
OMI016
P HERBERT SHOULDER/SWALK
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
4,022.00
1,336.04
2,685.00
0.00
0.00
2,685.00
OMI017
P SP CREEK SIDEWALK
8,049.00
44.26
8,004.00
0.00
0.00
8,004.00
OMI018
P VICTORIA GRD SIDEWALK
6,872.00
35.52
6,836.00
0.00
0.00
6,836.00
OMI019
P MCDONALD RD SIDEWALK
OMI020
P FUELING SYSTEM
8,252.00
108.87
8,143.00
0.00
0.00
8,143.00
280,665.00
284,751.57
10,924.00
0.00
0.00
10,924.00
OMI022
P HERBERT SIDEWALK EAST
9,125.00
0.00
9,125.00
0.00
0.00
9,125.00
OMI023
P WILLOW RUN SIDEWALK SO
7,994.00
0.00
7,994.00
0.00
0.00
7,994.00
OMI024
P MISC NEW SIDEWALKS
4,057.00
2,504.25
1,552.00
0.00
0.00
1,552.00
OMI025
P SOUTHWINDS SIDEWALKS
82,826.00
82,826.00
65,176.00
65,176.00
0.00
0.00
OMI026
P FS73 EmerGenFuelTankRpl
39,819.00
0.00
39,819.00
0.00
39,639.40
179.60
OMI027
P Fleet Asset Mgmt System
22,500.00
0.00
22,500.00
0.00
0.00
22,500.00
2,015,300.00
290,299.93
1,725,000.00
0.00
0.00
1,725,000.00
213,495.00
0.00
213,495.00
0.00
0.00
213,495.00
PNC007
P YORKTOWNE MDL SEGMENT
PNC008
P DUNLAWTON/TAYLOR/YORKTO
PNC011
P YORKTOWNE SO SEGMENT
2,536,117.00
2,404,430.80
131,686.00
0.00
0.00
131,686.00
PNC014
P HERBERT ST RGT TURN LN
352,028.00
32,370.64
345,501.00
25,844.14
759.70
318,897.16
POL021
P TOWN WEST/WILLIAMSON
786,396.00
450,492.73
709,437.00
373,453.55
284,632.15
51,351.30
POL039
P FY15 Paving Program Public Works Total:
8/10/2015 / 2:44 PM / 5 of 7
623,422.00
0.00
623,422.00
0.00
618,250.33
5,171.67
24,645,090.00
17,634,801.53
7,435,399.00
879,973.29
2,278,101.40
4,277,324.31
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager
JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
Parks and Recreation QPC020
R YMCA REPAIRS
QPC045
R SCOREBOARD REPLACEMENT
402,215.00
383,760.83
39,116.00
11,325.00
24,521.00
3,270.00
87,260.00
55,960.00
31,300.00
0.00
26,664.00
4,636.00
QPC046
R Veteran'sPrkBrick/TreeP
5,811.00
1,570.14
4,996.00
755.79
2,300.00
1,940.21
QPC049
R YMCA AC REPLACEMENTS
35,065.00
10,065.00
25,000.00
0.00
24,991.00
9.00
QPC052
R SOCCER FIELD RE-LEVEL
387,253.00
341,386.20
378,713.00
332,846.20
45,866.80
0.00
QPC054
R PARKS FURNISHINGS
26,500.00
26,419.80
3,931.00
3,851.04
0.00
79.96
QPC055
R Coraci Athl Compl PHIII
154,598.00
153,505.50
1,092.00
0.00
1,092.00
0.00
QPC056
R YMCA Pool Deck Replace
315,575.00
315,193.49
17,549.00
17,168.00
0.00
381.00
QPC058
R YMCA RENOVATIONS PH II
248,000.00
244,984.52
248,000.00
244,984.52
0.00
3,015.48
QPC059
R ParksFoundationCreation
3,201.00
0.00
3,201.00
0.00
0.00
3,201.00
QPC060
R YMCA Reno Phase III
158,500.00
2,997.00
158,500.00
2,997.00
1,998.00
153,505.00
QPC061
R Coraci Athl Compl PHIV
600,000.00
191,398.19
600,000.00
191,398.19
151,275.66
257,326.15
QPC062
R Causeway Dock Refurbish
39,000.00
0.00
39,000.00
0.00
0.00
39,000.00
QPC063
R SP CRK Bsktball Ct Reno
24,000.00
0.00
24,000.00
0.00
0.00
24,000.00
QPC064
R Lakeside Center Carpet
7,000.00
6,786.10
7,000.00
6,786.10
0.00
213.90
QPC065
R Outdoor Public Art
XSG007
R GAMBLE LAUNCH VOPO-0360 Parks and Recreation Total:
500.00
0.00
500.00
0.00
0.00
500.00
359,935.00
214,931.34
50,000.00
0.00
0.00
50,000.00
2,854,413.00
1,948,958.11
1,631,898.00
812,111.84
278,708.46
541,077.70
Comm. Redevelopment TIF002
T TWN CTR MEDIAN IMPRV
405,946.00
225,323.86
204,621.00
23,999.94
8,000.08
172,620.98
TIF004
T EASTPORT ENTRY SIGNAGE
61,910.00
33,846.00
28,064.00
0.00
0.00
28,064.00
TIF006
T Pie Guy Incentive
23,090.00
0.00
23,090.00
0.00
0.00
23,090.00
TIF007
T Penna Court Motel Prope
0.00
100.00
0.00
100.00
0.00
490,946.00
259,269.86
255,775.00
24,099.94
8,000.08
Comm. Redevelopment Total:
8/10/2015 / 2:44 PM / 6 of 7
(100.00) 223,674.98
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager
JUL-15 Project Manager Summary Report (Run on 8/7/15) Sorted and Totaled by Manager Proj #
Proj Description
PTD Budget
PTD Total
YTD Budget
YTD Total
EN
YTD Balance
(Total Project to Date Budget)
(Total Project Actuals thru 7/31/15 excluding EN's)
(FY15 Budget)
(FY15 Actuals excluding EN's)
(FY15 Encumbrances)
(FY15 Available Balance)
Public Utilities EFM001
U Forestry Management
MME001
U Machinery & Equipment
MME003
U Telemetry I & C
1,616,448.00
1,286,932.75
302,107.00
68,756.04
91,843.75
141,507.21
545,598.00
506,526.36
48,860.00
32,060.00
0.00
16,800.00
1,065,012.00
943,821.71
72,841.00
10,157.50
0.00
62,683.50
MMM101 U LARGE METER REPLACEMENT
608,892.00
603,690.27
3,870.00
3,870.00
0.00
0.00
MMP001
911,633.00
836,156.49
31,639.00
26,199.78
5,439.00
0.22
U Utility Mapping
MPL001
U Utilities Master Plan
RIM005
U Reservoir Outfall
256,453.00
224,537.16
0.00
0.00
0.00
0.00
2,995,479.00
842,289.16
2,668,528.00
515,339.28
1,939,872.33
213,316.39
SLS002
U R & R Lift Station
4,682,275.00
4,252,501.35
7,721.00
7,713.35
0.00
7.65
SLS003
U WB Regional PumpStation
1,503,749.00
0.00
1,503,749.00
0.00
1,422,788.00
80,961.00
SSP002
U Sewer Plant Replacement
6,353,986.00
5,666,122.91
635,373.00
135,079.26
57,071.00
443,222.74
SSP008
U Rec Wtr Plnt Imprv 2014
38,823.00
38,820.54
3,809.00
3,808.47
0.00
0.53
SSP009
U BioSolidsTrtmnt/Compost
50,000.00
14,237.50
50,000.00
14,237.50
2,512.50
33,250.00
UCP001
U Cost Participation,
2,472,181.00
2,269,156.78
96,665.00
62,423.05
24,520.00
9,721.95
UET001
U Extension, Water System
563,209.00
541,059.86
1,509.00
1,144.10
0.02
364.88
UET002
U Extension, Sewer System
1,428,807.00
1,339,414.66
4,328.00
0.00
0.00
4,328.00
UET022
U White Acres Improvement
775,417.00
74,999.21
702,452.00
2,034.25
9,417.79
690,999.96
URF001
U Reinforcement, WA Sys
452,705.00
398,007.99
44,343.00
21,040.13
URH001
U Sewer Sys Rehabilitatn
7,510,806.00
7,223,186.53
57,631.00
9,247.00
43,950.00
4,434.00
URL005
U Williamson Util Rel S
4,658,755.00
4,658,043.96
129,911.00
129,910.77
0.00
0.23
URL007
U Misc Util Coordination
285,627.00
259,348.18
26,272.00
0.00
0.00
26,272.00
URP001
U Replacement, WA System
3,751,438.00
3,278,618.96
178,998.00
156,132.98
URP010
U S Atlantic JPA w/Vol Co
834,288.00
17,159.00
834,288.00
17,159.00
27,555.00
789,574.00
WWP003 U Water Plant Improvement
5,695,562.00
4,920,023.45
645,287.00
47,187.68
456,084.55
142,014.77
WWP006 U GWP Rehabilitation 2013
1,255,825.00
1,365,369.08
3,810.00
3,810.00
0.00
0.00
450,506.00
353,849.92
96,654.00
0.00
0.00
96,654.00
WWW002 U WW Repairs/Maint ZMI044
U METER REPLACEMENT PRG
(0.01)
(0.01)
23,302.88
22,865.03
3,857,323.00
3,338,256.87
1,634,068.00
1,114,203.84
7,398.00
512,466.16
Public Utilities Total:
54,620,797.00
45,252,130.65
9,784,713.00
2,381,513.98
4,088,451.92
3,314,747.10
Total:
98,937,584.00
72,776,456.89
28,692,751.00
5,426,332.09
8,112,620.42
15,153,798.49
145 PROJECTS
8/10/2015 / 2:44 PM / 7 of 7
JUL‐15 Project Manager Summary 8‐7‐15 / Sorted and Totaled by Manager