Loading...
HomeMy WebLinkAbout06. (Handout) Capital Improvements Budget Report dated October 31, 2016PROGRAM /GM185L4 - Modified in Excel CENTRAL CONTRA COSTA SANITARY DISTRICT PROJ NO PROJECT TITLE TYPE CS Collection System TYPE TP Treatment Plant TYPE GI General Improvements TYPE RW Recycled Water CIB Contin : en TOTAL DISTRICT tel; PROJECT BUDGETS PYS (FY 2015-16) $ 18,753,213 27,396,360 6,604,612 1,262,977 (F (a .1, CAPITAL IMPROVEMENT BUDGET REPORT PERIOD ENDING: 10/31/2016 TOTAL EXPENDITURES PYS (FY 2015-16) 17,317,686 26,422,055 6,129,558 1,062,977 TOTAL PROJECT CARRY-FORWAROI 1,435,527 974,305 475,054 200,000 $ 54,017,162 50,932,276 3,084,886 FY 2016-17 Approved Budget 17,925,105 13,125,000 3,808,651 500,000 1,450,000 36,808,756 $ Budget Adjustments FY 2016-17 D+E) TOTAL BUDGET -TO -DATE THRU FY 2016-17 19,360,632 14,099,305 4,283,705 700,000 1,450,000 39,893,642 C:/Users/CBradley/AppData/Local/Microsoft/Windows/Temporary Internet Files/Content.Outlook/JQSWOXOQ/Capital Project report - Period 4 FY 16 17.xlsx Oct 16 item b. (Committee Handout) ACCOUNTING PERIOD 4/2017 TOTAL SPENT IN FY 2016-17 6,371,450 2,741,285 782,804 144,937 $ 10,040,476 $ H IF -G) TOTAL REMAINING BUDGET 12,989,160 11,358,016 3,500,905 555,061 1,450,000 29,853,142 PROGRAM /GM185L4 - Modified in Excel :CENTRAL CONTRA COSTA SANITARY DISTRICT PROJ NO PROJECT TITLE TYPE �oflection System 5941 PS Equipment Piping Replacement 5982 Pipe Burst Blanket Contract 5991 PH Sewer Renovation Phase 2 5999 CIPP Blanket Contract 6602 South Jackson CAD 8403* Buchannan Air Pump St Replacement 8412 PH Grayson Creek Trunk 8414* Moraga P5 Chopper Pump 8415 Martinez Ph 4 Sewer Renovation 8417 Survey Monument install 8418 Collection System Modeling 8419 Collection System Planning LT 8420 Development Sewerage 8422 WC Sewer Renovation Phase 11 8423 N. Orinda Sewer Renovation Phase 6 8426 Lafayette Sewer Renovation Phase 10 8429 Fairview Maltby 8430 Lafayette Sewer Renovation Phase 11 8431 Collection System Master Plan 8433 5. Orinda Sewer Renovation Phase 6 8434 Urgent Projects 8435 WC Sewer Renovation Phase 12 8436 Moraga/ Crossroads P5 Project 8437 Martinez Sewer Renovation Phase 5 Rounding CAPITAL IMPROVEMENT BUDGET REPORT PERIOD ENDING: 10/31/2016 ACCOUNTING PERIOD 4/2017 A B C A -B PROJECT TOTAL 1 TOTAL BUDGETS EXPENDITURES I1 PROJECT PYS (FY 2015-19 PYS (FY 2015-16) IICARRY-FORWARD $ 740,000 708,000 150,000 472,000 80,000 83 2,824,408 19,964 3,922,000 200,000 1,041,600 470,000 3,071,102 340,000 1,258,500 2,505,000 150,000 540,556 60,000 50,000 150,000 657,800 702,031 139,878 446,296 29,602 83 2,219,040 19,964 3,844,257 185,918 1,040,070 462,421 3,071,102 232,403 974,916 2,504, 597 135,650 540,556 57,887 27,677 25,538 82,200 5,969 10,122 25,704 50,398 605,368 77,743 14,082 1,530 7,579 107,597 283,584 403 1 f 14,350 2,113 22,323 124,462 0 FY 2016-17 Approved Budfet 10,000 150,000 253,867 8,900,000 5,000 50,000 200,000 200,000 800,000 545,000 2,154,000 2,250,238 350,000 500,000 670,000 12,000 150,000 400,000 325,000 F C+O+E Budget IITOTAL Adjustments i BUDGET -TO -DATE FY 2016-17 i TH RU FY 2016-17 175,000 300,000 500,000 (5,000)1 (100,000) (1,225r23�8 (175,000) 90,238 440,000 267,200 305,969 160,122 25,704 304,265 10,005,368 77,743 64,082 201,530 207,579 800,000 652,597 2,337,584 1,025,403 175,000 514,350 670,000 102,238 442,113 150,000 422,323 449,462 G TOTAL SPENT IN FY 2016-17 86,608 2,924 30,129 11,197 24,284 3,192,093 7,171 195 2,690 47,200 444,801 113,522 1,317,277 733,805 148,672 7,239 90,721 7,914 103,008 H(F-G) TOTAL REMAINING BUDGET 180,592 303,045 129,993 14,507 279,981 .4I 6,813,2754' 70,572 63,887 198,840 160,379 355,199 539,075 1,020,307 291,598 175,000 365,678 670,000 94,999 351,392 150,000 414,409 346,454 (22) Total FY 2016-17 CS Amount 18,753,213 17,317,686 * 1ntalic ,Projects open but not in CIB for Cevit-itec T. ori) 0 i apt164rt- N:/Accounting/GMTEMPI/Financials and Closing/2017 Financials/Capital Project report 1,435,527 17,925,105 Period 4 FY 16 17.xlsx Oct 16 19,360,632 6,371,450 12,989,160 PROGRAM /GM185L4 - Modified in Excel CENTRAL CONTRA COSTA SANITARY DISTRICT PROJ NO PROJECT TITLE TYPE TP Treatment Plant 7285 7286 7291 7292 7297 7301 7304 7310 7311 7312 7314 7315 7317 7319 7320 7322 7324 7326 7327 7329 7330 7339 7341 7343 7348 Primary Treatment Renovation Centrifuge & Cake Pumps Pump & Blower Bldg Seismic Upgrade Switchgear Refubishment - Ph 2 Caustic Addition to MHF Treament Plant Planning Instr & Controls PLC Upgrade Piping Renovations - Phase 9 (Closed in FY 2015-16) TP Safety Enhancement Ph 4 Ask Facility Improvements Urgent Repairs Applied Research and Innovations Plant Control System Network Upgrades Laboratory Upgrades & Repair Plant Energy Optimization Fire Protection System Ph 2 Sub 16 Switchgear Replacement Equipment Replacement FY 15 -FY 24 Headwork's Screening MHF Burner Upgrade Piping Renovation Phase 9 Plant Control System I/O Replacement WC/Grayson Creek Levee Rehab TP Master Plan Wet Scrubber Replacement - LT Rounding Total FY 2016-17 TP Amount CAPITAL IMPROVEMENT BUDGET REPORT PERIOD ENDING: 10/31/2016 A 11 CIA -B) TOTAL BUDGETS EXPENDITURES PROJECT PYS (FY 2015-16) PYS (FY 2015-16) CARRY-FORWARC PROJECT TOTAL $ 14,868,112 128,000 695,000 320,000 1,421,600 2,601,464 335,000 1,569,410 340,000 90,000 5,000 232,274 160,000 471,500 90,000 240,000 688,000 406,000 14,695,729 900,000 100,000 20,000 1,715,000 86,061 678,125 280,596 1,377,126 2,601,464 272,662 1,569,410 338,945 81,956 195,738 134,860 357,180 ACCOUNTING PERIOD 4/2017 0 E FC+D+E) - dila H 1 . ...... FY 2016-17 Budget TOTAL TOTAL TOTAL Approved Adjustments BUDGET -TO -DATE SPENT IN REMAINING Budget FY 2016-17 THRU FY 2016-17 FY 2016-17 BUDGET 172,383 41,939 16,875 39,404 44,474 62,338 1,055 8,044 5,000 36,536 25,140 . 114,320 91,179 88,898 687,472 356,898 756,172 (1,179) 46,385 12,631 1,712,568 $ 27,396,360 26,422,055 151,102 528 49,102 143,828 53,615 7,369 2,432 50,000 500,000 2,900,000 100,000 50,000 350,000 100,000 25,000 150,000 800,000 110,000 175,000 100,000 700,000 50,000 600,000 2,144,000 460,000 1,600,000 270,000 241,000 300,000 150,000 800,000 400,000 974,305 13,125,000 (2frortAit",-. ed.-) c--k-4ccit � �.-✓ 222,383 161,464 541,939 76,824 2,916,875 102,716 139,404 751 (50,000) 44,474 7,371 350,000 133,431 162,338 12,353 (25.000) - - 151,055 128 808,044 3,212 115,000 1,863 211,536 2,472 125,140 5,085 814,320 688,381 578,000 626,821 26,757 751,102 92,736 (188,000) 1,956,528 1,230,252 509,102 63,582 1,743,828 25,888 323,615 36,754 241,000 69,689 307,369 434 150,000 - (315,000) 487,432 (858) mio 400,000 14,099,305 2,741,285 C:/Users/CBradley/AppData/Local/Microsoft/Windows/Temporary Internet Files/Content.Outlook/JQSWOXOQ/Capital Project report - Period 4 FY 16 17.xlsx Oct 16 60,919 465,115 2,814,159 138,653 37,103 216,569 149,985 150,927 804,832 113,137 209,064 120,055 125,939 600,064 658,366 726,276 445,520 1,717,940 286,861 171,311 306,935 150,000 488,290 400,000 (4) 11,358,016 PROGRAM /GM185L4 - Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 10/31/2016 ACCOUNTING PERIOD 4/2017 PROJECT TOTAL TOTAL FY 2016-17 PROJ BUDGETS EXPENDITURES PROJECT Approved NO PROJECT TITLE PYS (FY 2015-10 PYS (FY 2015-16) CARRY-FORWARU, Budget TYPE GI Genera! Improvements 8207 General Security and Access $ 47,616.0 47,616 8227 GDI Treatment Plant 222,444 222,444 - 42,556 8230 Capital Legal Services 118,665 118,665 - 20,000 8232 GDI SMMS Replacement (Closed Project FY 2015-16) 973,222 973,222 - 4,665 8233 CSOD Facility Improvements 173,697 173,697 25,000 8234 HOB Improvements 637,025 637,025 - 447,000 8236 District Easements 123,382 123,382 - 15,000 8237 Buffer and Rental Improvements 266,816 266,816 - 50,000 8238 Asset Management 1,047,921 1,047,921 - 800,000 8239 POD Office Improvements 477,356 477,356 - 120,410 8240 IT Development 1,518,794 1,132,628 386,166 900,000 8242 CMMS Replacement 385,470 385,470 - 134,020 8243 Server Room Relocation 102,204 102,204 - 650,000 8516 District Equipment Acquisition 450,000 421,112 28,888 76,000 8517 Vehicle Replacement Program - - - 524,000 9999 Capital Project Clearing (Accounting Use Only)** Rounding 60,000 60,000 Budget TOTAL Adjustments BUDGET -TO -DATE FY 201E-17 I THRU FY 2016-17 (4,665) 4,665 42,556 20,000 25,000 447,000 19,665 50,000 800,000 120,410 1,286,166 134,020 650,000 104,888 524,000 60,000 TOTAL SPENT IN FY 2016-17 4,301 TOTAL REMAINING BUDGET 42,556 15,699 25,000 306,514 140,486 2,921 16,744 10,969 39,031 273,902 526,098 120,410 111,895 1,174,271 33,444 100,576 6,352 643,648 32,509 72,379 524,000 60,003 4 (3) Total FY 2016-17 GI Amount 6,604,612 6,129,558 475,054 3,808,651 4,283,705 782,804 3,500,905 ** To record beginning balance of activity as part of capital reporting change at YE 15/16 \At- I- 'Cane"' (A-1.1,‘ cc -0 \--).e C:/Users/CBradley/AppData/Local/Microsoft/Windows/Temporary Internet Files/Content.Outlook/JQSWOXOQ/Capital Project report - Period 4 FY 16 17.xlsx Oct 16 [R0GRAM /GM185L4 - Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT -CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 10/31/2016 ACCOUNTING PERIOD 4/2017 C(A-B D E F (C+D+E) G H F -G PROJECT TOTAL TOTAL PROD BUDGETS EXPENDITURES PROJECT NO PROJECT TITLE PYS (FY 2015-10 PYS (FY 2015-16) CARRY-FORWAR9 TYPE RW Rcled Water 7300 Refinery REW 7306 Zone 1 Recycled Water 7344 Recycled Water Planning 7345 Filter Plant 7346 Surge Analysis 16-17 7347 Rew Automated Fill Station 7350 Residential Fill Station Improv Rounding $ 354,536 354,536 430,079 430,079 108,681 108,681 87,327 87,327 282,354 82,354 200,000 FY 2016-17 Approved Budget Total FY 2016-17 RW Amount 1,262,977 1,062,977 200,000 40,000 37,815 102,185 200,000 55,000 15,000 50,000 500,000 Budget TOTAL Adjustments BUDGET -TO -DATE FY 2016-17 THRU FY 2016-17 TOTAL SPENT IN FY 2016-17 40,000 5,764 37,815 11,806 102,185 6,886 200,000 55,000 15,000 32,421 250,000 88,060 TOTAL REMAINING BUDGET 700,1)00 144,937 34,236 26,009 95,299 200,000 55,000 (17,421) 161,940 (2) 555,061 CONTINGENCY - ALL PROGRAMS 1,450,000 1,450,000 1,450,000 1 GRAND TOTAL 54,017,162 50,932,276 3,084,886 36,808,756 39,893,642 10,040,476 29,853,142 C:\Users\CBradley\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\lQSWOXOQ\Capital Project report - Period 4 FY 16 17.xlsx Oct 16