Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10.a. Receive adjusted (Period 13) O&M June 2013 Year-End Financial Statements
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 13 August 15, 2013 TO: THE BOARD OF DIRECTORS VIA: THEA VASSALLO FROM: JAMIE KING QJ" SUBJECT: O & M Expense Variance Analysis The following are brief year -to -date variance explanations at major category levels through period ending June, 2013 10,a. Expense Favorable /(Unfavorable) Categories Budgeted Actual Variance Explanation Total Labor Charges 49,015,294 49,795,221 (779,927) Labor charges are higher due to the unbudgeted increase in wages. The variance includes negotiated retro payments for general employees for eight months. Utilities 3,906,150 3,845,835 60,315 Close to budget as we moved expense related to cogen accident to Self- Insurance fund. The reclass of electrical expense was $968K. Repairs & Maintenance 3,644,811 3,151,127 493,684 Moved cogen expense to Self- Insurance fund. Outside Services 3,248,970 2,158,593 1,090,377 Variance from lower than budgeted furnace testing cost as a result of a lower bid from a different vendor than in the budget, less than budgeted consulting fees for Standard Operating Procedure and COPEPOD expenditure, and from air quality modeling and health risk assessment expenditures budgeted for but not required this year. Additional variance from moving cogen expense to Self- Insurance fund. Savings partially offset by unbudgeted expense for Accountemps for Environmental Services division audit. Other Expenses 2,296,774 1,727,270 569,504 Technical Training, Conference and Training expense lower than budget. Public information expense savings from lower pipeline expense due to lower bids, Prop 218 savings from lower mailing and printing expenses than anticipated and fewer joint projects with other agencies than anticipated. QS C F CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 13 August 15, 2013 TO: THE BOARD OF DIRECTORS VIA: THEA VASSALLO FROM: JAMIE KING 9 SUBJECT: Sewer Constructiorf Revenue Variance Analysis The following are brief year -to -date variance explanations at major category levels through period ending June, 2013: Revenue Favorable /(Unfavorable) Categories Budgeted Actual Variance Explanation Facilities Capacity Fees 4,417,000 5,426,301 1,009,301 Payments from new apartment projects in Martinez, Walnut Creek, and Danville. Interest Income 350,000 230,054 (119,946) Interest rates continue to be at historically low levels, reducing our income. Other Gov't Rev - Concord 3,833,000 3,616,771 (216,229) Less revenue due to less POD expense. 0 FINANCIAL STATEMENT SUMMARY Period 13, 2013 O & M Revenue Jun -13 Actual Budget Variance O & M Expenses 5,817 5,922 105 1.8% Year- to- date Favorable Variance > $10K: Total Labor Charges Directors Fees & Expenses Chemicals Utilities Repairs & Maintenance Hauling & Disposal Professional & Legal Outside Services Materials & Supplies Other Expenses Year- to- date Unfavorable Variance > $10K: Total Labor Charges Chemicals Utilities Repairs & Maintenance Hauling & Disposal Professional & Legal Outside Services Materials & Supplies Self- Insurance Expense Other Expenses Sewer Construction Prepared by: T. Smithey YEAR -TO -DATE Actual Budget Variance 70,848 70,236 612 0.9% YEAR -TO -DATE Actual Budget Variance 66,966 68,306 1,340 ' 2.0% Variance 0 46 . 0 60 ' 494 0 0 1,090 0 570 2,260 (780) 0 0 0 (48) . (87) . 0 0 0 0 1,345 Revenue 22,282 Expense 26,759 Over /Under (4,477) SG ddb .,a k +,6 .. TEMPORARY INVESTMENTS: Held in District LAW Account, Commercial Papers and CD's; LAW yield as of June, 2013 was 0.244 %. 03 Central Contra Costa Sanitary District August 7, 2013 TO: FINANCIAL STATEMENT RECIPIENTS FROM: TODD SMITHEY, FINANCE ADMINISTRATOR SUBJECT: PRE -AUDIT (PERIOD 13) JUNE 2013 FINANCIAL STATEMENTS Several entries to the 2012 -2013 books have been made in preparation for the upcoming year -end audit. We make these adjustments in what we call our pre -audit adjustment period (Period 13) in the SunGard system. The attached financials contain the results that our external auditors will receive when they are on -site this month. Please focus on the year -to -date information provided. Figures in the month -to -date columns only reflect adjustments made in the pre -audit period 13. The following reports are provided: • Spreadsheets showing differences between Issued Period 12 and Period 13 June pre -audit financial statements • Statement of Net Assets (Balance Sheets) • Revenue Summaries • Expense at District level l • Expense at Department level • Expense at Department/Division level • Salary & Benefit Reports • Capital Improvement Budget Reports • Temporary Investments Our external auditors may choose to propose audit adjustments if significant, which will be reflected in the official audited financial statements. If you have any questions, please call me at ext. 106. N :ACCOUNTING \GMTEMP1TINANCIALS AND CLOSINGULINE PER 13 MEMO 2013.DOC CENTRAL CONTRA COSTA SANITARY DISTRICT COMPARISON OF FINANCIAL STATEMENTS & YEAR -END RESULTS OPERATIONS AND MAINTENANCE (RUNNING EXPENSE FUND) PRELIMINARY JUNE 30, 2013 ISSUED ON 07/16113 TO PRE -AUDIT JUNE 2013 ISSUED ON 08/7/13 Month of June Results PERIOD 13 REVENUE ADJUSTMENTS: Accounts Receivable: final billing adjustments (Concord, HHW, Recycled H2O and all other) June 2013 issued 07116113 June 2013 issued 08107113 40,986 All Other PERIOD 12 PERIOD 13 VARIANCE Operations & Maintenance $ 319,983 <a> PERIOD 13 EXPENSE ADJUSTMENTS: REVENUE: $ 70 527,828 $ 70 847,811 $ 319,983 <a> EXPENSE: 258,260 Materials & Supplies 126,420 ADMIN $ 20,809,763 20,920,708 $ 110,945 ENG 8,525,608 8,680, 940 155,332 CSO 11, 053, 982 11, 278,661 224,679 POD 23,651, 835 23, 035, 950 $ (615, 885) PS 2,983,792 3 049 274 65,482 TOTAL $ 67,024,980 $ 66,965,533 $ (59,447) <b> REVENUE OVER EXPENSE $ 3,502 848 $ 3,882,278 $ 379,430 Variance Explanations PERIOD 13 REVENUE ADJUSTMENTS: Accounts Receivable: final billing adjustments (Concord, HHW, Recycled H2O and all other) $ 281,059 Interest Income (Interest earned on the balance left from Prefunding to CCCERA) 40,986 All Other (2,060) Rounding (2) $ 319,983 <a> PERIOD 13 EXPENSE ADJUSTMENTS: Additional Expense Accruals & Adjustments: Salary and Benefits $ - Repairs & Maintenance 258,260 Materials & Supplies 126,420 Hauling & Disposal 91,287 Outside Services 68,372 Professional & Legal Services 61,873 Other Expenses 22,324 Director Fees & Expenses 1,468 Chemicals & Utilities (Largely from Cogen Reimbursement) (689,446) Rounding (5) $ (59,447) <b> Budgeted Revenue over Expense Actual Revenue over Expense ance - Budget to Actual O &M Year -To -Date Bottom -line Results See detail on Budget to Actual Results page PERIOD 12 PERIOD 13 1,929,836 $ 1,929,836 3,502,848 $ 3.882.278 $ 1,573,012 $ 1,952,442 Favorable Savings from Budget 1/24/13 10 -Year Financial Plan projected revenue over expense to be $2.9 million, which differs from actual Period 13 results of $3.9 lion. This results in a favorable variance of $1.0 million 8/7/201311:20 AM NAACCOUNTING \GMTEMPITinancials and Closing \Per 12 to Per 13 2013 O CENTRAL CONTRA COSTA SANITARY DISTRICT COMPARISON OF FINANCIAL STATEMENTS & YEAR -END RESULTS SEWER CONSTRUCTION FUND PRELIMINARY JUNE 30, 2013 ISSUED ON 07/16/13 TO PRE -AUDIT JUNE 2013 ISSUED ON 08/7/13 (Month of June June 2013 issued 07116113 June 2013 issued 08107113 PERIOD 12 PERIOD 13 VARIANCE (REVENUE: $ 21,930,216 $ 22,281,642 $ 351,426 <a> (CAPITAL EXPENDITURES: $ 25,914,657 $ 26 758,648 $ 843,991 <b> REVENUE OVER EXPENDITURE $ (3,984,441) $ (4,477,006) $ (492,565) Variance Explanations PERIOD 13 REVENUE ADJUSTMENTS: Adjust Concord Capital Bill accrual from Period 12 $ 116,771 Tax Revenue Adjustment 228,000 All Other 6,656 Rounding (1) $ 351,426 <a> PERIOD 13 EXPENSE ADJUSTMENTS: All Other Project Charges: TP Projects 240,395 CS Projects 389,140 GI Projects 212,883 RW Projects 1,574 Roundind (1) $ 843,991 <b> Capital Year -To -Date Bottom -line Results See detail on Budget to Actual Results page PERIOD 12 PERIOD 13 Budgeted Revenue over Expense $ (10,556,000) $ (10,556,000) Actual Revenue over Expense $ (3,984,441) $ (4,477,006) riance - Budget to Actual $ 6,571,559 $ 6,078,994 Favorable Savings from Budget The 1/24/13 10 -Year Financial Plan projected revenue over expense to be -$10.5 million, which differs from actual Period 13 results of -$4.5 million. This results in a favorable variance of $6.0 million 8/7/201311:22 AM N:\A000UNTING\GMTEMPI \Financials and Closing \Per 12 to Per 13 2013 9 CENTRAL CONTRA COSTA SANITARY DISTRICT COMPARISON OF FINANCIAL STATEMENTS & YEAR -END RESULTS BUDGET TO ACTUAL RESULTS June 30, 2013 Month of June Results - Period 13 Pre -audit BUDGET ACTUAL VARIANCE 10 -YEAR PLAN VARIANCE Operations & Maintenance REVENUE: $ 70,236,300 $ 70,847,811 $ 611,511 $ 73,108,217 $ (2,260,406) EXPENSE $ 68,306,464 $ 66,965,533 $ (1,340,931) $ 70,221,247 $ (3,255.714 REVENUE OVER EXPENSE $____l_,929 836 $ 3,882 278 $ 1,952,442 $ 2,886 970 $ 995,308 Month of June Results - Period 13 Pre -audit BUDGET ACTUAL VARIANCE 10 -YEAR PLAN VARIANCE Sewer Construction Fund REVENUE: $ 21,787,000 $ 22,281,642 $ 494,642 $ 21,877,563 $ 404,079 CAPITAL EXPENDITURES: $ 32,343,000 $ 26,758,648 $ (5,584,352) $ 32,344,000 $ (5,585,352 REVENUE OVER EXPENDITURES $ (10,556,000) $ (4,477,006) $ 6,078,994 $ 10,466 437 $ 5,989,431 817/201311:20 AM N:W000UNTING \GMTEMP1 Tinancials and Closing \Per 12 to Per 13 2013 0 PREPARED 8/07/13, 14:00:36, 2013 STATEMENT OF NET ASSETS PAGE I PROGRAM /GM263L ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT AS OF -- -- -- - - -- -- -- - -- - -- -- ------ - -- - -- - - - --- - ---- ---- -- - - -- - - - --- - - ----- ------------------- ----- ---- ---- ---- -------- - --- -- - --- 001 RUNNING EXPENSE --------------- ---- ---- ---- --- --- ------ -- --- -- -- -- - - -- - - - - -- ------------------------ ---- -- ----- --- ---- --- -- - --- -- - -- ------ --- - -- CURRENT ASSETS CASH 2,964,844.65 PETTY CASH 3,300.00 PAYROLL CLEARING 1,500.00 ACCOUNTS RECEIVABLE 11,764,370.59 ALLOWANCE FOR UNCOLL A/R .00 OVERTIME INSPECTION A/R 671.25 ACCOUNTS RECEIVABLE -COBRA 1,417.82 A /R -SSC DIRECT BILL 7,085.18 COMPUTER PURCHASE PROGRAM 15,521.02 DEPOSITS TO BANK ESCROW 100,.741.95 PREPAID INSURANCE 158,842.07 PREPAID EXPENSES 1,021,552.60 PREPAID RETIREMENT 1,023,814.86 SUPPLIES & MATERIAL INV 2,005,740.86 DUE FROM SIC 116,465,947.39 DUE FROM S/I 1,763,763.66 DUE FROM DEBT FUND 187,119.25 TOTAL CURRENT ASSETS --- ---------- 137,486,233.15 NET PROPERTY, PLANT & EQUIPMENT - LAND 17,262,248.91 INTANGIBLE ASSETS 4.,596,467.00 ACCUM DEPR - INTANGIBLE 135,315.72 - BUILDINGS 36,120,719.95 ACC DEPR- BUILDINGS 8,059,167.55 - TREATMENT PLANT 299,830,466.06 ACC DEPR - TREATMENT PLANT 180,670,823.91 - PUMPING STATIONS 54,412,729.93 ACC DEPR - PUMPING STATIONS 24,342,929.15 - SEWAGE COLLECTION FACIL 311,633,989.21 OUTFALL SEWERS 11,338,934.72 FURNITURE & EQUIPMENT 15,651,212.16 - ACC DEPR -FURN & EQUIP 11,851,588.19 - VEHICLES 6,558,064.91 ACC DEPR- VEHICLES 4,100,982.35 - RECY WATER INFRASTRUCTURE 13,515,026.00 ACCUM DEPRC -RELY WATER 5,898,342.72 - ACC DEPR- SEWAGE COL SYS 53,103,663.00 - ACC DEPR - OUTFALL 3,012,480.78 - CONTRIBUTED SEWER LINES 150,834,929.81 ACC DEPR- CONTRIB ASSETS 51,127,280.04 - CONSTRUCTION IN PROGRESS 24,533,253.67 TOTAL NET PROPERTY, PLANT & EQUIPMENT 603,985,468.92 TOTAL ASSETS 741,471,702.07 ------ -- - - - --- ------------ LIABILITIES DUE TO SIC 74,244,584.37- Ed PREPARED 8/07/13, 14:00:36 2013 STATEMENT OF NET ASSETS PAGE 2 PROGRAM /GM263L CENTRAL CONTRA COSTA SANITARY DISTRICT - -- ---- -------- ACCOUNTING PERIOD 13/2013 AS OF --- - - - - -- - - - 001 RUNNING EXPENSE - - -- - ----- -- --- - - - - -- - -- -- - - -- ---- - - -- - --- - --- - -- - -- ------- ----- L--------------------- DUE TO S/I 1,667,479.30 - DUE TO DEBT FUND 54,365,590.62 - ACCOUNTS PAYABLE 1,696,276.57 - SALES TAX PAYABLE 5,786.47 - ACCRUED WAGES PAYABLE 877,809.00- FEDERAL WITHHOLDING _00 CALIFORNIA WITHHOLDING .00 MEDICARE WITHHOLDING ,00 STATE DISABILITY INS W/H .00 HARTFORD .00 NATIONAL DEFERRED .00 ICMA _00 RETIREMENT CONTRIB W/H .00 UNION DUES WITHHELD .00 OTHER PAYROLL WITHHOLDING .00 WELLNESS PAYMENTS .00 KAISER PERMANENTE _ 2,841.13 HEALTH NET 1,.110.37 OCCUPATIONAL HEALTH 3.76 DISABILITY INS 126.44 - LIFE INS 6.51 - DELTA DENTAL 91.94 POST EMP. BENEFIT -OPEB 1,553,637.77 CAFETERIA PLAN PAYABLE 67,686.53 - PERMIT CLEARING .00 WORKERS' COMP INS PAYABLE .00 ACCRUED COMPENSATED ABS. 3,833,244.68 - REFUNDABLE DEPOSITS 81,479.32- • ACCRUED INTEREST PAYABLE .00 MISC DEPOSITS /LIABILITIES 101,538.96 - REIMBURSEMENT FEES 138,770.00- TOTAL LIABILITIES FUND EQUITY RESERVE FOR ENCUMBRANCES CONTRIBUTED SEWER LINES CAPITAL COST SHARING STATE & FED CAPITAL GRANT GENERAL FIXED ASSET GROUP AVAILABLE FUND BALANCE EXPENDITURE SUMMARY REVENUE SUMMARY TOTAL FUND EQUITY TOTAL LIABILITIES AND FUND EQUITY .00 150,834,929.81 - 93,824,554.51- 75,301,279.00- 273,399,534.67- 8,706,412.61- 66,965,515.12 70,847,812,79- 135,522,693.80- 605,949,008.27- -------------- 741,471,702.07- 0 PREPARED 8/06/13, 13:47 :27 REVENUE SUMMARY REPORT PAGE 1 PROGRAM /GM270L 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: _ ------ - -- - -------- - - - - -- ----------------- - - - -- - -- - - - -bCQh; -- - - - - -� - ------------------------------------ FUND 001 RUNNING EXPENSE OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ESTIMATE ACTUAL VARIANCE ESTIMATE ACTUAL VARIANCE % ESTIMATE % 2200 SEWER SVC CHARGE - COUNTER 15,774 0 15,774- 100.0- 189,200 207,219 18,019 9.5 189,200 109.5 2300 SEWER SVC CHRG - COUNTY 1,104,000 0 1,104,000- 100.0- 55,197,600 55,629,407 431,807 .8 55,197,600 100,8 2400 SEWER SVC CHRG- DIRECT 0 0 0 .0 841,000 945,144 104,144 12.4 841,000 112.4 2500 SEWER SVC CHRG -PRIOR YEAR 1,862- 0 1,862 100.0- 22,300- 10,786- 11,514 51.6- 22,300- 48.4 SEWER SERVICE CHARGES 1,117,912 0 1,117,912- 100.0- 56,205,500 56,770,984 565,484 1.0 56,205,500 101.0 2600 SERVICE CHARGES- CONCORD 10,800,000 233,421 10,566,579- 97.8- 10,800,000 10,483,421 316,579- 2.9- 10,800,000 97.1 SERVICE CHARGES - CONCORD 10,800,000 233,421 10,566,579- 97.8- 10,800,000 10,483,421 316,579- 2.9- 10,800,000 97.1 1000 PERMIT /APPLICATION FEES 17,000 0 17,000- 100.0- 204,000 282,851 78,851 38.7 204,000 138.7 1700 SEPTIC TANK DUMPING 5,424 0 5,424 - 100.0- 65,000 90,168 25,168 38.7 65,000 138.7 1900 OVERTIME INSPECTION 1,000 0 1,000 - 100.0- 12,000 8,441 3,559- 29.7- 12,000 70.3 2000 SIDE SEWER INSPECTION 35,000 622- 35,622- 101.8- 420,000 568,370 148,370 35.3 420,000 135.3 2700 SALES 174 0 174 - 100.0- 2,000 4,140 2,140 107.0 2,000 207.0 2900 OTHER SERVICE CHARGES 62,500 0 62,500- 100.0- 145,000 210,098 65,098 44.9 145,000 144.9 3000 INDUSTRIAL PERMIT FEES 25,000 0 25,000- 100.0- 100,000 67,247 32,753- 32.8- 100,000 67.2 3200 NEW INDUSTRY PERMIT FEES 750 0 750- 100.0- 9,000 10,503 1,503 16.7 9,000 116.7 3301 POLLUTION PREVENTION 6,000 1,064- 7,064- 117.7- 24,000 23,432 568- 2.4- 24,000 97.6 3500 LEASE RENTAL INCOME 42,000 0 42,000- 100.0- 689,000 747,740 58,740 8.5 689,000 108.5 3600 PRETREATMENT PROGRAM FINE 2,000 0 2,000- 100..0- 2,000 35,000 33,000 650.0 2,000 750.0 3801 RECYCLED WATER 59,170 11,846 47,324- 80.0- 355,000 128,352 226,648- 63.8- 355,000 36.2 4300 ANNEXATION CHARGES 1,500 0 1,500- 100.0- 18,000 30,164 12,164 67.6 18,000 167.6 4500 INTEREST INCOME 143,000 40,986 102,014- 71.3- 143,000 131,614 11,386- B_0- 143,000 92.0 4600 TAX REVENUE 0 0 0 .0 0 0 0 .0 0 .0 4700 OTHER AGENCY REIMB-MISC 0 0 0 .0 0 0 0 .0 0 _0 5500 STORMWATER PROGRAM 53,750 3,491 50,259- 93.5- 215,000 262,219 47,219 22.0 215,000 122.0 5600 HOUSE HAZARD WASTE REIMB 792,800 32,923 759,877- 95.8- 825,800 866,303 40,503 4.9 825,800 104.9 6000 MISCELLANEOUS INCOME 0 996- 996- .0 0 126,516 126,516 _0 0 .0 6300 PARTNERING 0 0 0 .0 0 0 0 .0 0 .0 6400 RIGHT -OF -WAY FEES 174 0 174- 100.0- 2,000 248 1,752- 87.6- 2,000 12,4 OTHER REVENUES 1,247,242 86,564 1,160,678- 93.1- 3,230,800 3,593,406 362,606 11.2 3,230,800 111.2 FUND TOTALS 13,165,154 319,985 12,845,169- 97.6- 70,236,300 70,847,811 611,511 .9 70,236,300 100.9 /o PREPARED 8/06/13, 13:47:48 EXPENSE SUMMARY REPORT BY DISTRICT PAGE 1 PROGRAM /GM275L 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: b- -- OBJ - --------------- - - - - -- ------- - - - ------ - -- - - - - - -- MONTH -TO- DATE------- - - - - - - -- - -�------------------------------------------------------ - ------ - - - - -- -YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE BUDGET e 0101 SALARIES & WAGES- MGMNT. 142,086 0 142,086 100.0 1,704,493 1,563,134 141,359 8.3 1,704,493 91.7 0102 SALARIES & WAGES -NON MGMT 1,793,382 0 1,793,382 100.0 21,518,263 21,350,770 167,493 .8 21,518,263 99.2 0103 SALARIES & WAGES -COMP ABS 25,000 0 25,000 100.0 300,000 290,572 9,428 3.1 300,000 96.9 0105 OVERTIME 69,465 0 69,465 100.0 831,292 910,817 79,525- 9.6- 831,292 109.6 0106 STANDBY PAID 18,906 0 18,906 100.0 226,498 218,543 7,955 3.5 226,498 96.5 0110 SALARY VACANCY 57,446- 0 57,446 -100.0 689,000- 0 689,000 -100.0 689,000- .0 SALARIES & WAGES 1,991,393 0 1,991,393 100.0 23,891,546 24,333,836 442,290- 1.9- 23,891,546 101.9 0201 WORKERS COMPENSATION INS 40,913 0 40,913 100.0 488,734 346,295 142,439 29.1 488,734 70 -9 0202 STATE UNEMPLOYMENT INSUR 7,500 0 7,500 100.0 30,000 28,422 1,578 5.3 30,000 94.7 0203 FEDERAL MEDICARE TAX 27,604 0 27,604 100.0 328,905 337,813 8,908- 2.7- 328,905 102.7 0204 MEDICAL & HEALTH INSUR 758,016 0 758,016 100.0 9,093,475 8,787,816 305,659 3.4 9,093,475 96.6 0205 RETIREMENT CONTRIBUTION 1,129,270 0 1,129,270 100.0 13,548,600 12,673,276 875,324 6.5 13,548,600 93.5 0206 . DEFERRED COMP. CONTRIB 114,580 0 114,580 100.0 1,372,232 ,1,399,355 27,123- 2.0- 1,372,232 102.0 0207 DENTAL INSURANCE 71,869 0 71,869 100.0 860,371 866,880 6,509- .8- 860,371 100.8 0208 LONG -TERM DISABILITY INS 6,040 0 6,040 100.0 70,489 64,968 5,521 7.8 70,489 92.2 0209 LIFE INSURANCE 13,880 0 13,880 100.0 163,942 158,035 5,907 3.6 163,942 96 -4 0211 ACCRUED COMPENSATED ABS 360,000 0 360,000 100.0 360,000 768,030 408,030- 113.3- 360,000 213.3 0212 BENEFIT VACANCY 100,348- 0 100,348 -100.0 1,204,000- 0 1,204,000 -100.0 1,204,000- .0 0213 OPEB CONTRIBUTION 0 0 0 .0 3,767,000 3,476,904 290,096 7.7 3,767.,000 92.3 EMPLOYEE BENEFITS 2,429,324 0 2,429,324 100.0 28,879,748 28,907,794 28,046- .1- 28,879,748 100.1 0250 CAPITALIZED ADM OVERHEAD 313,077- 0 313,077 -100.0 3,756,000- 3,446,409- 309,591- 8.2 3,756,000- 91.8 CAPITALIZED ADM OVERHEAD 313,077- 0 313,077 -100.0 3,756,000- 3,446,409- 309,591- 8.2 3,756,000- 91.8 TOTAL LABOR CHARGES 4,107,640 0 4,107,640 100.0 49,015,294 49,795,221 779,927- 1.6- 49,015,294 101.6 0301 DIRECTOR MEETING FEES 5,028 0 5,028 100.0 60,325 56,709 3,616 6.0 60,325 94.0 0302 BOARD TRAINING AND CONF 3,837 1,468 2,369 61.7 46,000 15,874 30,126 65.5 46,000 34.5 0303 BOARD HEALTH BENEFITS 4,639 0 4,639 100.0 55,635 43,297 12,338 22.2 55,635 77.8 DIRECTOR FEES & EXPENSES 13,504 1,468 12,036 89.1 161,960 115,880 46,080 28.5 161,960 71.5 0402 LIME 17,174 19,618 2,444- 14.2- 206,000 352,796 146,796- 71.3- 206,000 171.3 0403 POLYMER 40,424 56,573 16,149- 39.9- 485,000 495,530 10,530- 2.2- 485,000 102.2 0404 BOILER CHEMICALS 4,837 0 4,837 100.0 58,000 43,561 14,439 24.9 58,000 75.1 0406 OTHER CHEMICALS 43,674 13,515 30,159 69.1 524,000 492,187 31,813 6.1 524,000 93.9 0407 HYPOCHLORITE 25,674 20,985 4,689 18.3 308,000 190,880 117,120 38.0 308,000 62.0 CHEMICALS 131,783 110,691 21,092 16.0 1,581,000 1,574,954 6,046 .4 1,581,000 99.6 0501 ELECTRICAL 118,666 851,652- 970,318 817.7 -966,000 850,713 115,287 11,9 966,000 88.1 0502 NATURAL GAS 345,889 5,050 340,839 98.5 2,090,500 2,218,675 128,175- 6.1- 2,090,500 106.1 0503 LAND -FILL GAS 39,587 39,201 386 1.0 475,000 443,535 31,465 6.6 475,000 93.4 0504 WATER 7,503 257 7,246 96.6 89,750 81,226 8,524 9.5 89,750 90.5 0505 TELEPHONE 23,760 7,007 16.,753 70.5 284,900 251,686 33,214 11.7 284,900 88.3 UTILITIES 535,405 800,137- 1,335,542 249.4 3,906,150 3,845,835 60,315 1.5 3,906,150 98.5 PREPARED 8/06/13, 13:47:48 EXPENSE SUMMARY REPORT BY DISTRICT PAGE 2 PROGRAM /GM275L 1001 OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -------------------------------- PERIOD ENDING: t6ho /r3 OBJ- --- ---- --- ----------- ------- - - - - -- --- -- - -- - ------------------------------------------------------------------- -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ------------------------------------------------------------------------------------------- ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL ----- ----------- VARIANCE --- e ------ BUDGET - - -- -- - -- 1 - - - - -- 0601 OUTSIDE VEH /EQUIP REPAIR 9,693 4,109 5,584 57.6 116,250 70,760 45,490 39.1 116,250 60.9 0602 VEHIC /EQUIP REPAIR MAINT 7,500 4,941 2,559 34.1 90,000 122,601 32,601- 36.2- 90,000 136.2 0603 GENERAL REPAIRS & MAINT 78,805 41,016 37,789 48.0 945,000 1,006,602 61,602- 6.5- 945,000 106.5 0604 OUTSIDE REPAIRS 6, MAINT. 164,936 207,351 42,415- 25.7- 1,976,150 1,464,234 511,916 25.9 1,976,150 74.1 0605 COMPUTER REPAIRS & MAINT 39,733 43 39,690 99.9 477,411 461,732 15,679 3.3 477,411 96.7 0606 REAL PROPERTY REPAIRS 3,337 800 2,537 76.0 40,000 25,198 14,802 37.0 40,000 63.0 REPAIRS & MAINTENANCE 304,004 258,260 45,744 15.0 3,644,811 3,151,127 493,684 13.5 3,644,811 86.5 0701 ASH REMOVAL 13,337 0 13,337 100.0 160,000 136,237 23,763 14.9 160,000 85.1 0702 SLUDGE REMOVAL 837 0 837 100.0 10,000 0 10,000 100.0 10,000 .0 0703 GRIT REMOVAL 6,674 5,863 811 12.2 80,000 92,804 12,804- 16.0- 80,000 116.0 0704 JANITORIAL & REFUSE REMOV 20,757 2,340 18,417 88.7 248,600 278,913 30,313- 12.2- 248,600 112.2 0705 SPOILS REMOVAL 2,500 0 2,500 100.0 30,000 29,518 482 1.6 30,000 98.4 0706 HAZARDOUS WASTE DISPOSAL 115,948 83,084 32,864 28.3 511,200 550,822 39,622- 7.8- 511,200 107.8 0707 MOBILE COLLECTION -HHW 0 0 0 .D 0 0 0 .0 0 _0 HAULING & DISPOSAL 160,053 91,287 68,766 43.0 1,039,800 1,088,294 48,494- 4.7- 1,039,800 104.7 0801 PROFESSIONAL SERVICES 14,248 780 13,468 94.5 170,800 209,994 39,194- 22.9- 170,800 122.9 0802 LEGAL SERVICES -BOARD _ 5,174 12,348 7,174- 138.7- 62,000 78,298 16,298- 26.3- 62,000 126.3 0803 LEGAL SERVICES -STAFF 37,359 48,745 11,386- 30.5- 358,100 389,753 31,653- 8.8- 358,100 108.8 PROFESSIONAL & LEGAL SERV 56,781 61,873 5,092- 9.0- 590,900 678,045 87,145- 14.7- 590,900 114.7 0901 OUTSIDE SAFETY SERVICES 8,323 5,869 2,454 29.5 84,200 69,916 14,284 17.0 84,200 83.0 0902 TECHNICAL SERVICES 238,303 61,257 177,046 74.3 2,737,920 1,658,102 1,079,818 39.4 2,737,920 60.6 0903 DATA PROCESSING SERVICES 0 0 0 .0 400 0 400 100.0 400 .0 0904 OTHER PUBLIC AGENCY SERVS 3,174 0 3,174 100.0 309,750 289,174 20,576 6.6 309,750 93.4 0905 REPROGRAPHIC SERVICES 1,573 0 1,573 100.0 18,700 2,167 16,533 88.4 18,700 11.6 0906 RECRUITMENT 8,174 1,246 6,928 84.8 98,000 139,234 41,234- 42.1- 98,000 142.1 OUTSIDE SERVICES 259,547 68,372 191,175 73.7 3,248,970 2,158,593 1,090,377 33.6 3,248,970 66.4 1001 SELF - INSURANCE EXPENSE 0 0 0 .0 850,000 850,000 0 .0 850,000 100.0 SELF - INSURANCE EXPENSE 0 0 0 .0 850,000 850,000 0 .0 850,000 100.0 1101 OFFICE EQUIPMENT /SUPPLIES 17,597 1,558 16,039 91.1 210,460 150,232 60,228 28.6 210,460 71.4 1102 GASOLINE, OIL & FUEL 21,456 12,111 9,345 43.6 257,450 306,140 48,690- 18.9- 257,450 118.9 1103 OPERATING SUPPLIES 96,994 60,749 36,245 37.4 1,175,900 1,211,424 35,524- 3.0- 1,175,900 103.0 1104 OPERATING FUEL 3,174 0 3,174 100.0 38,000 18,,425 19,575 51.5 38,000 48..5 1105 LABORATORY SUPPLIES 12,174 7,535 4,639 38.1 146,000 185,393 39,393- 27.0- 146,000 127.0 1106 SAFETY SUPPLIES 12,595 6,314 6,281 49.9 142,995 108,700 34,295 24.0 142,995 76.0 1108 INVENTORY OVER /SHORT 0 38,153 38,153- .0 0 0 0 _0 0 .0 MATERIALS & SUPPLIES 163,990 126,420 37,570 22.9 1,970,805 1,980,314 9,509- .5- 1,970,805 100.5 1201 RENTS & LEASES 19,965 2,525 17,440 87.4 213,150 153,499 59,651 28.0 213,150 72.0 1202 PUBLIC AGENCY FEES 20,293 80 20,213 99.6 427,035 400,367 26,668 6.2 427,035 93.B 1203 PUBLIC INFORMATION 72,105 0 72,105 100.0 438,000 279,032 158,968 36.3 438,000 63.7 ,z PREPARED 8/06/13, 13:47:48 EXPENSE SUMMARY REPORT BY DISTRICT PAGE 3 PROGRAM /GM275L 100°% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 6/go/1,3 t OBS ----------------------- - --- ---- -- --------------- ------ - - - - - -- --- - - - -- - -- MONTH -TO- DATE------- - - - - -- - ------- ----- --- - - - - - - -- -- - -------------------- - -- YEAR -TO- DATE -------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET $ 1204 TUITION REIMBURSEMENT 5,262 154 5,108 97.1 44,550 8,404 36,146 81.1 44,550 18 -9 1205 TECH TRAIN, CONF & MEETS 29,280 12,554 16,726 57.1 334,170 248,749 85,421 25.6 334,170 74.4 1206 CERTIFICATION & LICENSES 1,666 958 708 42.5 19,541 13,674 5,867 30.0 19,541 70.0 1207 CLAIMS 436 0 436 100.0 5,100 668 4,432 86.9 5,100 13.1 1208 SUBSCRIPTION /PUBLICATION 2,852 744 2,108 73.9 33,948 18,800 15,148 44.6 33,948 55.4 1209 MILEAGE REIMBURSEMENTS 672 168 504 75.0 7,140 8,032 892- 12.5- 7,140 112.5 1210 PUBLIC NOTICES 504 2,632 2,128- 422.2- 5,850 6,530 680- 11.6- 5,850 111.6 1211 OUTSIDE ORGANIZATION FEES 22,241 0 22,241 100.0 278,000 258,680 19,320 6.9 278,000 93.1 1212 EMPLOYEE MEMBERSHIPS 3,199 1,797 1,402 43.8 39,145 33,719 5,426 13.9 39,145 86.1 1213 MISCELLANEOUS 3,107 712 2,395 77.1 36,030 22,557 13,473 37.4 36,030 62.6 1214 ELECTION EXPENSE 0 0 0 .0 350,000 272,772 77,228 22.1 350,000 77.9 1216 PROFESSIONAL EXP REIMB 7,940 0 7,940 100.0 65,115 1,787 63,328 97.3 65,115 2.7 OTHER EXPENSES 189,522 22,324 167,198 88.2 2,296,774 1,727,270 569,504 24.8 2,296,774 75.2 NET EXPENSES 5,922,229 59,442- 5,981,671 101.0 68,306,464 66,965,533 1,340,931 2.0 68,306,464 98.0 TOTAL EXPENSE 5,922,229 59,442- 5,981,671 101.0 68,306,464 66,965,533 1,340,931 2.0 68,306,464 98.0 /3 PREPARED 8/06/13, 13:47:52 EXPENSE SUMMARY REPORT BY DEPT (SUMMARY) PAGE 2 PROGRAM /GM278L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 4,30/1 -- - - ---- --- ---'-' -- ------------- MONTH -TO- DATE ------------- - -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET > PLANT OPERATIONS SALARIES & WAGES EMPLOYEE BENEFITS CAPITALIZED ADM OVERHEAD CHEMICALS UTILITIES REPAIRS & MAINTENANCE HAULING & DISPOSAL OUTSIDE SERVICES MATERIALS & SUPPLIES OTHER EXPENSES PUMP STATIONS FUND TOTALS 2,264,472 615,883- 2,880,355 127.2 25,272,977 23,035,950 2,237,027 8.9 25,272,977 91.1 71,003 0 71,003 100.0 851,794 894,930 43,136- 5.1- 851,794 105.1 53,566 0 53,566 100.0. 642,363 686,147 43,784- 6.8- 642,363 106.8 470- 0 470 -100.0 5,563- 0 5,563 -100.0 5,563- .0 33,337 13,515 19,822 59.5 400,000 430,279 30,279- 7.6- 400,000 107.6 81,513 40,535 40,978 50.3 520,450 479,394 41,056 7.9 520,450 92.1 20,587 91088 11,499 55.9 247,000 402,142 155,142- 62.8- 247,000 162.8 1,525 0 1,525 100.0 - 18,300 19,134 834- 4.6- 18,300 104.6 6,205 0 6,205 100.0 58,850 52,952 5,898 10.0 58,850 90.0 3,724 803 2,921 78.4 44,600 51,975 7,375- 16.5- 44,600 116.5 3,340 1,542. 1,798 53.8 39,739 32,321 7,418 18.7 39,739 81.3 274,330 65,483 208,847 76.1 2,817,533 3,049,274 231,741- 8.2- 2,817,533 108.2 5,922,229 59,442- 5,981,671 101.0 68,306,464 66,965,533 1,340,931 2.0 68,306,464 98.0 ON PREPARED 8/06/13, 13:47:52_ EXPENSE SUMMARY REPORT BY DEPT (SUMMARY) PAGE 1 PROGRAM /GM278L RUNNING EXPEN�v FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY --------------------- --- - - - --- DISTRICT - -- -- PERIOD ENDING: L/20��2 1.2 s! -- -- ------------- - -- MONTH -TO- DATE------- - - - - -- ----------------------------------------------------- ---- -- --- -- --- YEAR -TO- DATE--- ----- ------ ANNUAL ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET o SALARIES & WAGES 369,879 0 369,879 100.0 4,437,393 4,412,199 25,194 .6 4,437,393 99.4 EMPLOYEE BENEFITS 1,020,808 0 1,020,808 100.0 11,991,592 12,477,144 485,552- 4.0- 11,991,592 104.0 CAPITALIZED ADM OVERHEAD 4,063- 0 4,063 -100.0 48,690- 21,699- 26,991- 55.4 48,690- 44.6 DIRECTOR FEES & EXPENSES 13,504 1,468 12,036 B9.1 161,960 115,880 46,080 28.5 161,960 71.5 UTILITIES 14,736 2,522 12,214 82.9 176,700 149,283 27,417 15.5 176,700 84.5 REPAIRS & MAINTENANCE 41,855 5,323 36,532 87.3 500,300 429,567 70,733 14,1 500,300 85.9 PROFESSIONAL & LEGAL SERV 37,070 41,115 4,045- 10.9- 434,800 549,980 115,180- 26.5- 434,800 126.5 OUTSIDE SERVICES 98,494 10,920 87,574 88.9 1,353,550 1,094,797 258,753 19.1 1,353,550 80.9 SELF - INSURANCE EXPENSE 0 0 0 .0 850,000 850,000 0 .0 850,000 100.0 MATERIALS & SUPPLIES - 18,991 42,865 23,874 - 125.7- 238,725 149,507 89,218 37.4 238,725 62.6 OTHER EXPENSES 98,158 6,738 91,420 93.1 1,027,415 714,050 313,365 30.5 1,027,415 69.5 ADMINISTRATION 1,709,432 110,951 1,598,481 93..5 21,123,745 20,920,708 203,037 1.0 21,123,745 99.0 SALARIES & WAGES 450,202 0 450,202 100.0 5,401,830 5,594,312 192,482- 3.6- 5,401.,830 103.6 EMPLOYEE BENEFITS 382,700 0 382,700 100.0 4,588,990 4,596,838 7,848- .2- 4,588,990 100.2 CAPITALIZED ADM OVERHEAD 290,877- 0 290,877 -100.0 3,490,194- 3,255,448- 234,746- 6.7 3,490,194- 93.3 UTILITIES 5,821 5,213 608 10.4 69,500 67,422 2,078 3.0 69,500 97.0 REPAIRS & MAINTENANCE 8,690- 1,160 7,530 86.7 103,961 81,522 22,439 21.6 103,961 78.4 HAULING & DISPOSAL PROFESSIONAL & LEGAL SERV 116,785 14,700 84,041 19,996 32,744 5,296- 28.0 36.0- 521,200 96,100 570,665 122,722 49,465- 26,622- 9.5- 27.7- 521,200 96,100 109.5 127.7 I _ OUTSIDE SERVICES 38,909 26,118 12,791 32.9 446,600 534,715 88,115- 19.7- 446,600 119.7 5 MATERIALS & SUPPLIES 16,163 11,380 4,783 29.6 193,010 203,936 10,926- 5.7- 193,010 105.7 OTHER EXPENSES 21,958 7,421 14,537 66.2 255,767 164,256 91,511 35.8 255,767 64.2 ENGINEERING 765,051 155,329 609,722 79.7 8,186,764 8,680,940 494,176- 6.0- 8,166,764 106.0 SALARIES & WAGES 394,548 0 394,548 100.0 4,733,212 5,074,422 341,210- 7.2- 4,733,212 107.2 EMPLOYEE BENEFITS 360,088 0 360,088 100.0 4,316,425 4,365,835 49,410- 1.1- 4,316,425 101.1 CAPITALIZED ADM OVERHEAD 9,021- 0 9,021 -100.0 108,164- 49,878- 58,286- 53.9 108,164- 46.1 UTILITIES 10,598 10,958 360- 3.4- 127,000 136,388 9,388- 7..4- 127,000 107.4 REPAIRS & MAINTENANCE 59,539 155,480 95,941- 161.1- 714,050 623,001 91,049 12.8 714,050 87.2 HAULING & DISPOSAL 7,536 0 7,536 100.0 90,300 109,788 19,488- 21.6- 90,300 121.6 PROFESSIONAL & LEGAL SERV 837 428 409 48.9 10,000 2,036 7,964 79.6 10,000 20.4 OUTSIDE SERVICES 8,061 12,000 3,939- 48.9- 96,270 58,230 38,040 39.5 96,270 60.5 MATERIALS & SUPPLIES 59,896 42,297 17,599 29.4 713,770 784,056 70,286- 9.8- 713,770 109.8 OTHER EXPENSES 16,862 3,515 13,347 79.2 212,582 174,783 37,799 17.8 212,582 82.2 COLLECTION SYSTEM OPS. 908,944 224,678 684,266 75.3 10,905,445 11,278,661 373,216- 3.4- 10,905,445 103.4 SALARIES & WAGES 705,761 0 705,761 100.0 8,467,317 8,357,973 109,344 1.3 8,467,317 98.7 EMPLOYEE BENEFITS 612,162 0 612,162 100.0 7,340,378 6,781,830 558,548 7.6 7,340,378 92.4 CAPITALIZED ADM OVERHEAD 8,646- 0 8,646 -100.0 103,389- 119,384- 15,995 15.5- 103,389 -115.5 CHEMICALS 98,446 97,176 1,270 1.3 1,181,000 1,144,675 ,36,325 3.1 1,181,000 96.9 UTILITIES 422,737 859,365- 1,282,102 303.3 3,012,500 3,013,348 848- ,0 3,012,500 100.0 REPAIRS & MAINTENANCE 173,333 87,209 86,124 49.7 2,079,500 1,614,895 464,605 22.3 2,079,500 77.7 HAULING & DISPOSAL 34,207 7,246 26,961 78.B 410,000 388,707 21,293 5.2 410,000 94.8 PROFESSIONAL & LEGAL SERV 4,174 334 3,840 92.0 50,000 3,307 46,693 93.4 50,000 6.6 OUTSIDE SERVICES 107,878 19,334 88,544 82.1 1,293,700 417,899 875,801 67.7 1,293,700 32.3 MATERIALS & SUPPLIES 65,216 29,075 36,141 55..4 780,700 790,840 10,140- 1.3- 780,700 101.3 OTHER EXPENSES 49,204 3,108 46,096 93.7 761,271 641,860 119,411 15.7 761,271 84.3 PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 1 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT --- -- -- ---------- -- PERIOD ENDING:__ � `3D L a -- -- -- DEPARTMENT 01 ADMINISTRATION --------- - - - - -- - - ---------------------------------------------------- OBJ - -- -- --- -----MONTH-TO- DATE-- -- --- - - - --- -- -- -------- -- YEAR-TO- DATE-------- - - - - -- ANNUAL NO -- - ACCOUNT TITLE -------------------------------- BUDGET ---- -- ------ ACTUAL --- -------- VARIANCE - -- ---- - ---- BUDGET - - - - -- - ----- ACTUAL ---------------------------------------------- VARIANCE e BUDGET e 0101 SALARIES & WAGES- MGMNT. 73,155 0 73,155 100.0 877,552 963,905 86,353- 9.8- 877,552 109.8 0102 SALARIES & WAGES -NON MGMT 274,301 0 274,301 100.0 3,291,161 3,169,927 121,234 3.7 3,291,161 96.3 0103 COMP ABS- ACCRUAL PAYMENTS 25,000 0 25,000 100.0 300,000 216,582 83,418 27.8 300,000 72.2 0105 OVERTIME 7,260 0 7,260 100.0 86,680 61,785 24,895 28.7 86,680 71.3 0110 SALARY VACANCY 9,837- 0 9,837 -100.0 118,000- 0 118,000 -100.0 118,000- .0 SALARIES & WAGES 369,879 0 369,879 100.0 4,437,393 4,412,199 25,194 .6 4,437,393 99.4 0201 WORKERS' COMPENSATION INS 1,796 0 1,796 100.0 21,068 14,932 6,136 29.1 21,068 70.9 0202 STATE UNEMPLOYMENT INSUR 7,500 0 7,500 100.0 30,000 28,422 1,578 5.3 30,000 94.7 0203 FEDERAL MEDICARE TAX 5,048 0 5,048 100.0 59,784 60,230 446- .7- 59,784 100.7 0204 MEDICAL & HEALTH INSUR 415,882 0 415,882 100.0 4,989,737 5,101,988 112,251- 2.2- 4,989,737 102.2 0205 RETIREMENT CONTRIBUTION 205,704 0 205,704 100.0 2,467,722 2,211,663 256,059 10.4 2,467,722 89.6 0206 DEFERRED COMP. CONTRIB 19,997 0 19,997 100.0 239,084 235,064 4,020 1.7 239,084 98.3 0207 DENTAL INSURANCE 39,582 0 39,582 100.0 474,533 456,487 18,046 3.8 474,533 96.2 0208 LONG -TERM DISABILITY INS 965 0 965 100.0 11,173 10,092 1,081 9.7 11,173 90.3 0209 LIFE INSURANCE 6,008 0 6,008 100.0 71,491 113,332 41,841- 58.5- 71,491 158.5 0211 ACCRUED COMPENSATED ABS. 360,000 0 360,000 100.0 360,000 768,030 408,030- 113.3- 360,000 213.3 0212 BENEFIT VACANCY 41,674- 0 41,674 -100.0 500.,000- 0 500,000 -100.0 500,000- .0 0213 OPEB CONTRIBUTION 0 0 0 .0 3,767,000 3,476,904 290,096 7.7 3,767,000 92.3 EMPLOYEE BENEFITS 1,020,808 0 1,020,808 100.0 11,991,592 12,477,144 485,552- 4.0- 11,991,592 104.0 0250 CAPITALIZED ADM OVERHEAD 4,063- 0 4,063 -100.0 48,690- 21,699- 26,991- 55.4 48,690- 44.6 CAPITALIZED ADM OVERHEAD 4,063- 0 4,063 -100.0 48,690- 21,699- 26,991- 55.4 48,690- 44.6 0301 DIRECTOR MEETING FEES 5,028 0 5,028 100.0 60,325 56,709 3,616 6.0 60,325 94.0 0302 BOARD TRAINING AND CONF 3,837 1,468 2,369 61.7 46,000 15,874 30,126 65.5 46,000 34.5 0303 BOARD HEALTH BENEFITS 4,639 0 4,639 100.0 55,635 43,297 12,338 22.2 55,635 77.8 DIRECTOR FEES & EXPENSES 13,504 1,468 12,036 89.1 161,960 115,880 46,080 28.5 161,960 71.5 0501 ELECTRICAL 6,250 8,878 2,628- 42.0- 75,000 89,143 14,143- 18.9- 75,000 118.9 0502 NATURAL GAS 924 806 118 12.8 11,000 11,733 733- 6.7- 11,000 106.7 0504 WATER 337 0 337 100.0 4,000 4,881 881- 22.0- 4,000 122.0 0505 TELEPHONE 7,225 7,162- 14,387 199.1 86,700 43,526 43,174 49.8 86,700 50.2 UTILITIES 14,736 2,522 12,214 82.9 176,700 149,283 27,417 15.5 176,700 84.5 0603 GENERAL REPAIRS & MAINT 424 2,152 1,728- 407.5- 5,000 5,718 718- 14.4- 5,000 114.4 0604 OUTSIDE REPAIRS & MAINT 6,045 2,328 3,717 61.5 70,800 21,155 - 49,645 70.1 70,800 29.9 0605 COMPUTER REPAIRS & MAINT 32,049 43 32,006 99.9 384,500 377,496 7,004 1.8 384,500 98.2 0606 REAL PROPERTY REPAIRS 3,337 800 2,537 76.0 40,000 25,198 14,802 37.0 40,000 63.0 REPAIRS & MAINTENANCE 41,855 5,323 36,532 87.3 500,300 429,567 70,733 14.1 500,300 85.9 0801 PROFESSIONAL SERVICES 14,248 780 13,468 94.5 170,800 209,994 39,194- 22.9- 170,800 122.9 0802 LEGAL SERVICES -BOARD 5,174 12,348 7,174- 138.7- 62,000 78,298 16,298- 26.3- 62,000 126.3 0803 LEGAL SERVICES -STAFF 17,648 27,987 10,339- 58.6- 202,000 261,688 59,688- 29.5- 202,000 129.5 0/6 PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 2 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -- - - PERIOD ENDING: 16/341-3 --- - --- ------ ----- ---- - - - - --- --- ---------- - --------------- - DEPARTMENT O1 ADMINISTRATION OBJ - -- -- -- - - -- -- MONTH -TO- DATE------- - - ---- ------ -- -- --- -YEAR -TO- DATE------- -- ---- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET °s --------------------------------------------------------------- ------- --------- ---- ---- - ----- - --- ----- -- ----- -- -- -- - - --- - -- - - - --- PROFESSIONAL & LEGAL SERV 0901 OUTSIDE SAFETY SERVICES 0902 TECHNICAL SERVICES 0903 DATA PROCESSING SERVICES 0904 OTHER PUBLIC AGENCY SERVS 0905 REPROGRAPHIC SERVICES 0906 RECRUITMENT OUTSIDE SERVICES 1001 SELF - INSURANCE EXPENSE SELF - INSURANCE EXPENSE 1101 OFFICE EQUIPMENT /SUPPLIES 1103 OPERATING SUPPLIES 1106 SAFETY SUPPLIES 1108 INVENTORY OVER /SHORT MATERIALS & SUPPLIES 1201 RENTS & LEASES 1202 PUBLIC AGENCY FEES 1203 PUBLIC INFORMATION 1204 TUITION REIMBURSEMENT 1205 TECH TRAIN, CONF & MEETS 1206 CERTIFICATION & LICENSES 1207 CLAIMS 1208 SUBSCRIPTION /PUBLICATION 1209 MILEAGE REIMBURSEMENTS 1210 PUBLIC NOTICES 1211 OUTSIDE ORGANIZATION FEES 1212 EMPLOYEE MEMBERSHIPS 1213 MISCELLANEOUS 1214 ELECTION EXPENSE 1216 PROFESSIONAL EXP REIMB OTHER EXPENSES DEPARTMENT NET EXPENSES 37,070 41,115 4,045- 10.9- 434,800 549,980 115,180- 26.5- 434,800 126.5 4,587 5,869 1,282- 27.9- 55,000 35,875 19,125 34.8 55,000 65.2 84,233 3,805 80,428 95.5 1,010,400 749,952 260,448 25.8 1,010,400 74.2 0 0 0 .0 400 0 400 100.0 400 .0 250 0 250 100.0 174,750 167,569 7,181 4.1 174,750 95.9 1,250 0 1,250 100.0 15,000 2,167 12,833 85.6 15,000 14.4 8,174 1,246 6,928 84.8 98,000 139,234 41,234- 42.1- 98,000 142.1 98,494 10,920 87,574 88.9 1,353,550 1,094,797 258,753 19.1 1,353,550 80.9 0 0 0 .0 850,000 850,000 0 .0 850,000 100.0 0 0 0 .0 850,000 850,000 0 .0 850,000 100.0 10,283 260 10,023 97.5 123,000 64,219 58,781 47.8 123,000 52.2 4,667 4 4,663 99.9 69,450 55,199 14,251 20.5 69,450 79.5 4,041 4,448 407- 10.1- 46,275 30,089 16,186 35.0 46,275 65.0 0 38,153 38,153- .0 0 0 0 .0 0 .0 18,991 42,865 23,874- 125.7- 238,725 149,507 89,218 37.4 238,725 62,6 5,072 2,406 2,666 52.6 35,600 22,339 13,261 37.3 35,600 62.8 212 0 212 100.0 2,500 154 2,346 93.8 2,500 6.2 71,170 0 71,170 100.0 427,000 278,978 148,022 34.7 427,000 65.3 935 0 935 100.0 11,000 2,000 9,000 81.8 11,000 18.2 8,791 2,167 6,624 75.3 86,450 69,953 16,497 19.1 86,450 80.9 161 200 39- 24.2- 1,800 200 1,600 88.9 1,800 11.1 424 0 424 100.0 5,000 668 4,332 86.6 5,000 13.4 592 563 29 4.9 7,785 6,199 1,586 20.4 7,785 79.6 365 168 197 54.0 4,050 4,057 7- .2- 4,050 100.2 68 426 358 - 526.5- 750 1,268 518- 69.1- 750 169.1 2,437 0 2,437 100.0 29,200 32,647 3,447- 11.8- 29,200 111.8 588 280 308 52.4 8,715 7,175 1,540 17.7 8,715 82.3 1,365 528 837 61.3 15,950 15,640 310 1.9 15,950 98.1 0 0 0 .0 350,000 272,772 77,228 22.1 350,000 77.9 5,978 0 5,978 100.0 41,615 0 41,615 100.0 41,615 .0 98,158 6,738 91,420 93.1 1,027,415 714,050 313,365 30.5 1,027,415 69.5 1,709,432 110,951 1,598,481 93.5 21,123,745 20,920,708 203,037 1.0 21,123,745 99.0 17 PREPARED 8/06/13, 13 :48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT - PAGE 3 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY -- -- -- DISTRICT PERIOD ENDING- 6/30/1,3 - --- --- - -- - -- DEPARTMENT 02 ENGINEERING - - ------------------------------------------------------ OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE e BUDGET ACTUAL VARIANCE % BUDGET s 0101 SALARIES & WAGES- MGMNT. 24,796 0 24,796 100.0 297,497 160,702 136,795 46.0 297,497 54.0 0102 SALARIES & WAGES -NON MGMT 434,232 0 434,232 100.0 5,210,333 5,329,422 119,089- 2.3- 5,210,333 102.3 . 0103 SALARIES & WAGES -COMP ABS 0 0 0 .0 0 30,837 30,837- .0 0 .0 0105 OVERTIME 4,935 0 4,935 100.0 59,000 73,351 14,351- 24.3- 59,000 124.3 0110 SALARY VACANCY 13,761- 0 13,761 -100.0 165,000- 0 165,000 -100.0 165,000- .0 SALARIES & WAGES 450,202 0 450,202 100.0 5,401,830 5,594,312 192,482- 3.6- 5,401,830 103.6 0201 WORKERS, COMPENSATION INS 5,882 0 5,882 100.0 70,133 50,164 19,969 28.5 70,133 71.5 0203 FEDERAL MEDICARE TAX 6,321 0 6,321 100.0 75,346 75,911 565- .7- 75,346 100.7 0204 MEDICAL & HEALTH INSUR 87,976 0 87,976 100.0 1,055,206 1,007,503 47,703 4.5 1,055,206 95.5 0205 RETIREMENT CONTRIBUTION 259,850 0 259,850 100.0 3,117,716 2,988,632 129,084 4.1 3,117,716 95.9 0206 DEFERRED COMP. CONTRIB 26,000 0 26,000 100.0 311,582 331,371 19,789- 6.4- 311,582 106.4 0207 DENTAL INSURANCE 8,948 0 8,948 100.0 107,024 115,869 8,845- 8.3- 107,024 108.3 0208 LONG -TERM DISABILITY INS 1,392 0 1,392 100.0 16,495 14,918 1,577 9.6 16,495 90.4 0209 LIFE INSURANCE 2,255 0 2,255 100.0 26,488 12,470 14,018 52.9 26,488 47.1 0211 ACCRUED COMPENSATED ABS. 0 0 0 .0 0 0 0 .0 0 _0 0212 BENEFIT VACANCY 15,924- 0 15,924 - 100.0 191,000- 0 191,000 -100.0 191,000- .0 EMPLOYEE BENEFITS 382,700 0 382,700 100.0 4,588,990 4,596,838 7,848- .2- 4,588,990 100.2 0250 CAPITALIZED ADM OVERHEAD 290,877- 0 290,877 -100.0 3,490,194- 3,255,448- 234,746- 6.7 3,490,194- 93.3 CAPITALIZED ADM OVERHEAD 290,877- 0 290,877 -100.0 3,490,194- 3,255,448- 234,746- 6.7 3,490,194- 93.3 0501 ELECTRICAL 1,211 657 554 45.7 14,400 8,104 6,296 43.7 14,400 56.3 0502 NATURAL GAS 125 16 109 87.2 1,500 1,332 168 11.2 1,500 88.8 0504 WATER 174 0 174 100.0 2,000 1,975 25 1.3 2,000 98.8 0505 TELEPHONE 4,311 4,540 229- 5.3- 51,600 56,011 4,411- 8.5- 51,600 108.5 UTILITIES 5,821 5,213 608 10.4 69,500 67,422 2,078 3.0 69,500 97,0 0604 OUTSIDE REPAIRS & MAINT. 4,354 1,160 3,194 73.4 52,050 29,467 22,583 43.4 52,050 56.6 0605 COMPUTER REPAIRS & MAINT 4,336 0 4,336 100.0 51,911 52,055 144- .3- 51,911 100.3 REPAIRS & MAINTENANCE 8,690 1,160 7,530 86.7 103,961 81,522 22,439 21.6 103,961 78.4 0704 JANITORIAL & REFUSE REMOV 1,761 957 804 45.7 21,000 21,092 92- .4- 21.,000 100.4 0706 HAZARDOUS WASTE DISPOSAL 115,024 83,084 31,940 27.8 500,200 549,573 49,373- 9.9- 500,200 109.9 0707 MOBILE COLLECTION -HHW 0 0 0 .0 0 0 0 .0 0 .0 HAULING & DISPOSAL 116,785 84,041 32,744 28.0 521,200 570,665 49,465- 9.5- 521,200 109.5 0803 LEGAL SERVICES -STAFF 14,700 19,996 5,296- 36.0- 96,100 122,722 26,622- 27.7- 96,100 127.7 PROFESSIONAL & LEGAL SERV 14,700 19,996 5,296- 36.0- 96,100 122,722 26,622- 27.7- 96,100 127.7 0902 TECHNICAL SERVICES 36,185 26,118 10,067 27.8 314,.000 416,219 102,219- 32.6- 314,000 132.6 0904 OTHER PUBLIC AGENCY SERVS 2,500 0 2,500 100.0 130,000 118,496 11,504 8.8 130,000 91.2 0905 REPROGRAPHIC SERVICES 224 0 224 100.0 2,600 0 2,600 100.0 2,600 .0 10` PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 4 PROGRAM /GM279D RUNNING EXPENSE 534,715 ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -- - --- -------- -- -- ------- --- --- -- /gUND - - -- PERIOD ENDING_ f']�I�2 l�1 # 33 ----------------------------------------- 55,960 DEPARTMENT 02 ENGINEERING 16, 9,791 9,443 348 OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET - -- -- - -- -- -- -- - --- -----------------------------`---------------------------------------------- ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE BUDGET < ---- ------ -- ------- ---- --- - -- ---- OUTSIDE SERVICES 1101 OFFICE EQUIPMENT /SUPPLIES 1103 OPERATING SUPPLIES 1106 SAFETY SUPPLIES MATERIALS & SUPPLIES 1201 RENTS & LEASES 1202 PUBLIC AGENCY FEES 1203 PUBLIC INFORMATION 1204 TUITION REIMBURSEMENT 1205 TECH TRAIN, CONF & MEETS 1206 CERTIFICATION & LICENSES 1208 SUBSCRIPTION /PUBLICATION 1209 MILEAGE REIMBURSEMENTS 1210 PUBLIC NOTICES 1211 OUTSIDE ORGANIZATION FEES 1212 EMPLOYEE MEMBERSHIPS 1213 MISCELLANEOUS 1216 PROFESSIONAL EXP REIMB OTHER EXPENSES 38,909 26,118 12,791 32.9 446,600 534,715 4,678 1,088 3,590 76.7 55,960 53,075 9,791 9,443 348 3.6 117,250 136,773 1,694 849 845 49.9 19,800 14,088 16,163 11,380 4,783 29.6 193,010 203,936 673 424 935 3,085 11,163 268 1,747 159 436 668 968 970 462 21,958 0 0 0 0 4,526 0 100 0 2,206 0 589 0 0 7,421 673 100.0 424 100.0 935 100.0 3,085 100.0 6,637 59.5 268 100.0 1,647 94.3 159 100.0 1,770- 406.0- 668 100.0 379 39.2 970 100.0 462 100.0 14,537 66.2 7,900 5,000 11,000 18,800 135,660 3,095 20,513 1,490 5,100 19,300 11,209 11,200 5,500 255,767 7,563 8,459 54 3,136 91,064 1,007 11,136 1,969 5,262 21,528 9,879 3,199 0 164,256 88,115- 19.7 2,885 5.2 19,523- 16.7- 5,712 28.8 10,926- 5.7- 337 4.3 3.,459- 69.2 - 10,946 99.5 15,664 83.3 44,596 32.9 2,088 67.5 9,377 45.7 479- 32.1- 162- 3.2- 2,228- 11.5- 1,330 11.9 8,001 71.4 51500 100.0 91,511 35.8 446,600 119.7 55,960 94.8 117,250 116.7 19,800 71.2 193,010 105.7 7,900 95.7 5,000 169.2 11,000 .5 18,800 16.7 135,660 67.1 3,095 32.5 20,513 54.3 1,490 132.1 5,100 103.2 19,300 111.5 11,209 88.1 11,200 28.6 5.500 .0 255,767 64.2 DEPARTMENT NET EXPENSES 765,051 155,329 609,722 79.7 8,186,764 8,680,940 494,176- 6.0- 8,186,764 106.0 l9 PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 5 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT ------ --------- ---- ------- - -- -- ---- --- ------ PERIOD ENDING: - ----° L� ------------------------------------------------------ DEPARTMENT 03 COLLECTION SYSTEM OPS. OBJ ------- - - - - -- MONTH -TO- DATE- ------ - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE -- - - - -- -- -- -- - --- - -- - --- ---- ------- BUDGET -- -- -- -- ACTUAL -- ---- VARIANCE - -- --------------------------------------------------------------------------- % BUDGET ACTUAL VARIANCE BUDGET 0101 SALARIES & WAGES- MGMNT. 16,368 0 16,368 100.0 196,361 291,974 95,613- 48.7- 196,361 148.7 0102 SALARIES & WAGES -NON MGMT 365,077 0 365,077 100.0 4,380,275 4,421,831 41,556- .9- 4,380,275 100.9 0103 SALARIES & WAGES COMP ABS 0 0 0 .0 0 8,152 8,152- .0 0 .0 0105 OVERTIME 19,027 0 19,027 100.0 227,576 292,570 64,994- 28.6- 227,576 128,6 0106 STANDBY PAID 5,500 0 5,500 100.0 66,000 59,895 6,105 9.3 66,000 90.8 0110 SALARY VACANCY 11,424- 0 11,424 -100.0 137,000- 0 137,000 -100.0 137,000- .0 SALARIES & WAGES 394,548 0 394,548 100.0 4,733,212 5,074,422 341,210- 7.2- 4,733,212 107.2 0201 WORKERS' COMPENSATION INS 11,691 0 11,691 100.0 139,577 102,683 36,894 26.4 139,577 73.6 0203 FEDERAL MEDICARE TAX 5,346 0 5,346 100.0 63,624 68,461 4,837- 7.6- 63,624 107,6 0204 MEDICAL & HEALTH INSUR 94,908 0 94,908 100.0 1,138,181 11068,508 69,673 6.1 1,138,181 93,9 0205 RETIREMENT CONTRIBUTION 227,544 0 227,544 100.0 2,730,011 2,672,328 57,683 2.1 2,730,011 97.9 0206 DEFERRED COMP. CONTRIB 23,691 0 23,691 100.0 283,731 309,232 25,501- 9.0- 283,731 109.0 0207 DENTAL INSURANCE 8,654 0 8,654 100.0 103,298 119,629 16,331- 15.8- 103,298 115.8 0208 LONG -TERM DISABILITY INS 1,308 0 1,308 100.0 15,179 14,675 504 3.3 15,179 96.7 0209 LIFE INSURANCE 1,946 0 1,946 100.0 22,824 10,319 12,505 54.8 22,824 45.2 0212 BENEFIT VACANCY 15,000- 0 15,000 -100.0 180,000- 0 180,000 -100.0 180,000- .0 EMPLOYEE BENEFITS 360,088 0 360,088 100.0 4,316,425 4,365,835 49,410- 1.1- 4,316,425 101.1 0250 CAPITALIZED ADM OVERHEAD 9,021- 0 9,021 -100.0 108,164- 49,878- 58,286- 53.9 108,164- 46.1 CAPITALIZED ADM OVERHEAD 9,021- 0 9,021 -100.0 108,164- 49,878- 58,286- 53.9 108,164- 46.1 0501 ELECTRICAL 4,674 6,279 1,605- 34.3- 56,000 61,043 5,043- 9.0- 56,000 109.0 0502 NATURAL GAS 1,500 336 1,164 77.6 18,000 9,308 8,692 48.3 18,000 51.7 0504 WATER 674 0 674 100.0 8,000 12.,843 4,843- 60.5- 81000 160.5 0505 TELEPHONE 3,750 4,343 593- 15.8- 45,000 53,194 8,194- 18.2- 45,000 118.2 UTILITIES 10,598 10,958 360- 3.4- 127,000 136,388 9,388- 7.4- 127,000 107.4 0601 OUTSIDE VEH /EQUIP REPAIR 9,693 4,109 5,584 57.6 116,250 70,760 45,490 39.1 116,250 60.9 0602 VEHIC /EQUIP REPAIR MAINT 7,500 4,941 2,559 34.1 90,000 122,601 32,601- 36.2- 90,000 136.2 0603 GENERAL REPAIRS & MAINT 250 0 250 100.0 3,000 216 2,784 92.8 3,000 7.2 0604 OUTSIDE REPAIRS & MAINT 42,096 146,430 104,334- 247.8- 504,800 429,424 75,376 14.9 504,800 85.1 REPAIRS & MAINTENANCE 59,539 155,480 95,941- 161.1- 714,050 623,001 91,049 12.8 714,050 87,2 0704 JANITORIAL & REFUSE REMOV 5,036 0 5,036 100.0 60,300 80,270 19,970- 33.1- 60,300 133.1 0705 SPOILS REMOVAL 2,500 0 2,500 100.0 30,000 29,518 482 1.6 30,000 98.4 HAULING & DISPOSAL 7,536 0 7,536 100.0 90,300 109,788 19,488- 21.6- 90,300 121.6 0803 LEGAL SERVICES -STAFF 837 428 409 48.9 10,000 2,036 7,964 79.6 10,000 20.4 PROFESSIONAL & LEGAL SERV 837 428 409 48.9 10,000 2,036 7,964 79.6 10,000 20.4 0901 OUTSIDE SAFETY SERVICES 337 0 337 100.0 4,000 8,569 4,569- 114.2- 4,000 214.2 0902 TECHNICAL SERVICES 7,712 12,000 4,288- 55.6- 92,170 49,661 42,509 46.1 92,170 53.9 2U PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 6 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT ---------------------------------- PERIOD ENDING: DEPARTMENT 03 COLLECTION SYSTEM - - - - -- - OPS. - - - -- -3a ------ - - - - ------------------------------------------ OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE e BUDGET ; 0905 REPROGRAPHIC SERVICES 12 0 12 100.0 100 0 100 10010 100 .0 OUTSIDE SERVICES 8,061 12,000 3,939- 48.9- 96,270 58,230 38,040 39.5 96,270 60.5 1101 OFFICE EQUIPMENT /SUPPLIES 886 0 886 100.0 10,500 8,353 2,147 20.4 10,500 79.6 1102 GASOLINE, OIL & FUEL 21,456 12,111 9,345 43.6 257,450 306,140 48,690- 18.9- 257,450 118.9 1103 OPERATING SUPPLIES 33,757 29,367 4,390 13.0 404,600 443,187 38,587- 9.5- 404,600 109.5 1106 SAFETY SUPPLIES 3,797 819 2,978 78.4 41,220 26,376 14,844 36.0 41,220 64.0 MATERIALS & SUPPLIES 59,896 42,297 17,599 29.4 713,770 784,056 70,286- 9.8- 713,770 109.8 1201 RENTS & LEASES 9,839 65 9,774 99.3 117,650 87,576 30,074 25.6 117,650 74.4 1202 PUBLIC AGENCY FEES 1,750 80 1,670 95.4 32,250. 24,049 8,201 25.4 32,250 74.6 1204 TUITION REIMBURSEMENT 174 0 174 100.0 2,000 1,299 701 35.1 2,000 65.0 1205 TECH TRAIN, CONF & MEETS 3,453 3,316 137 4.0 41,370 42,622 1,252- 3.0- 41,370 103.0 1206 CERTIFICATION & LICENSES 417 0 417 100.0 4,883 5,241 358- 7.3- 4,883 107.3 1207 CLAIMS 12 0 12 100.0 100 0 100 100.0 100 .0 1208 SUBSCRIPTION /PUBLICATION 62 0 62 100.0 700 905 205- 29.3- 700 129.3 1209 MILEAGE REIMBURSEMENTS 75 0 75 100.0 900 1,585 685- 76.1- 900 176.1 1212 EMPLOYEE MEMBERSHIPS 618 0 618 100.0 7,229 7,455 226- 3.1- 7,229 103.1 1213 MISCELLANEOUS 212 54 158 74.5 2,540 2,264 236 9.4 2,500 90.6 1216 PROFESSIONAL EXP REIMB 250 0 250 100.0 3,000 1,787 1,213 40.4 3,000 59.6 OTHER EXPENSES 16,862 3,515 13,347 79.2 212,582 174,763 37,799 17.8 212,582 82.2 DEPARTMENT NET EXPENSES 908,944 224,678 684,266 75.3 10,905,445 11,278,661 373,216- 3.4- 10,905,445 103.4 PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 7 PROGRAM /GM279D RUNNING EXPENSE F'.TND/ ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - -- -- - -- PERIOD ENDING_ r f -- --- ----- --- --- ----- DEPARTMENT 04 PLANT OPERATIONS ----- - - ----- - - ,2 --- - -- -- -- - -- --- -- - - - --- - - - -- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ------------------------`----------------- ACCOUNT TITLE BUDGET ACTUAL -`--- ---- -- ---- VARIANCE -- ------- % ----- - BUDGET ------ -- - --- ACTUAL - --------------------------------------------- VARIANCE BUDGET o 0101 SALARIES & WAGES- MGMNT. 27,767 0 27,767 100.0 333,083 146,553 186,530 56.0 333,083 44.0 0102 SALARIES & WAGES -NON MGMT 657,573 0 657,573 100.0 7,890,227 7,680,553 209,674 2.7 7,890,227 97.3 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 35,001 35,001- .0 0 .0 0105 OVERTIME 35,939 0 35,939 100.0 430,509 441,094 10,585- 2.5- 430,509 102.5 0106 STANDBY PAID 5,069 0 5,069 100.0 60,498 54,772 5,726 9.5 60,498 90.5 0110 SALARY VACANCY 20,587- 0 20,587 -100.0 247,000- 0 247,000 -100.0 247,000- .0 SALARIES & WAGES 705,761 0 705,761 100.0 8,467,317 8,357,973 109,344 1.3 8,467,317 98.7 0201 WORKERS COMPENSATION INS 19,444 0 19,444 100.0 232,800 160,439 72,361 31.1 232,800 68.9 0203 FEDERAL MEDICARE TAX 9,963 0 9,963 100.0 119,039 120,253 1,214- 1.0- 119,039 101.0 0204 MEDICAL & HEALTH INSUR 148,251 0 148,251 100.0 1,778,374 1,499,934 278,440 15.7 1,778,374 84.3 0205 RETIREMENT CONTRIBUTION 399,712 0 399,712 100.0 4,795,708 4,325,173 470,535 9.8 4,795,708 90.2 0206 DEFERRED COMP. CONTRIB 41,135 0 41,135 100.0 492,817 470,968 21,849 4.4 492,817 95.6 0207 DENTAL INSURANCE 13,613 0 13,613 100.0 162,696 162,158 538 .3 162,696 99.7 0208 LONG -TERM DISABILITY INS 2,159 0 2,159 100.0 25,171 22,912 2,259 9.0 25,171 91.0 0209 LIFE INSURANCE 3,385 0 3,385 100.0 39,773 19,993 19,780 49.7 39,773 50.3 0211 ACCRUED COMPENSATED ABS 0 0 0 .0 0 0 0 .0 0 .0 0212 BENEFIT VACANCY 25,500- 0 25,500 -100.0 306,000- 0 306,000 -100.0 306,000- .0 EMPLOYEE BENEFITS 612,162 - 0 612,162 100.0 7,340,378 6,781,830 558,548 7.6 7,340,378 92.4 0250 CAPITALIZED ADM OVERHEAD 8,646- 0 8,646 -100.0 103,389- 119,384- 15,995 15.5- 103,389 -115.5 CAPITALIZED ADM OVERHEAD 8,646- 0 8,646 -100.0 103,389- 119,384- 15,995 15.5- 103,389 -115.5 0402 LIME 17,174 19,618 2,444- 14.2- 206,000 352,796 146,796- 71.3- 206,000 171.3 0403 POLYMER 40,424 56,573 16,149- 39 -9- 485,000 495,530 10,530- 2.2- 485,000 102.2 0404 BOILER CHEMICALS 4,837 0 4,837 100.0 58,000 43,561 14,439 24.9 58,000 75.1 0406 OTHER CHEMICALS 10,337 0 10,337 100.0 124,000 61,908 62,092 50.1 124,000 49.9 0407 HYPOCHLORITE 25,674 20,985 4,689 18.3 308,000 190,880 117,.120 38.0 308,000 62.0 CHEMICALS 98,446 97,176 1,270 1.3 1,181,000 1,144,675 36,325 3.1 1,181,000 96.9 0501 ELECTRICAL 30,261 907,150- 937,411 97.8 363,000 268,002 94,998 26.2 363,000 73.8 0502 NATURAL GAS 343,340 3,892 339,448 98.9 2,060,000 2,196,302 136,302- 6.6- 2,060,000 106.6 0503 LAND -FILL GAS 39,587 39,201 386 1.0 475,000 443,535 31,465 6.6 475,000 93.4 0504 WATER 5,000 62 4,938 98.8 60,000 49,746 10,254 17.1 60,000 82.9 0505 TELEPHONE 4,549 4,630 81- 1.8- 54,500 55,763 1,263- 2.3- 54,500 102.3 UTILITIES 422,737 859,365- 1,282,102 303.3 3,012,500 3,013,348 848- .0 3,012,500 100.0 0603 GENERAL REPAIRS & MAINT 75,044 31,679 43,365 57.8 900,000 930,624 30,624- 3.4- 900,000 103.4 0604 OUTSIDE REPAIRS & MAINT 94,941 55,530 39,411 41.5 1,138,500 652,090 486,410 42.7 1,138,500 57.3 0605 COMPUTER REPAIRS & MAINT 3,348 0 3,348 100.0 41,000 32,181 8,819 21.5 41,000 78.5 REPAIRS & MAINTENANCE 173,333 87,209 86,124 49.7 2,079,500 1,614,895 464,605 22.3 2,079,500 77.7 0701 ASH REMOVAL 13,337 0 13,337 100.0 160,000 136,237 23,763 14.9 160,000 65.1 0702 SLUDGE REMOVAL 837 0 837 100.0 10,000 0 10,000 100.0 10,000 .0 7z PREPARED 8/06/13, 13:48 :23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 8 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: ------------------------------- - - - - -- 3 �3- DEPARTMENT 04 PLANT OPERATIONS OBJ ------- - - - - -- MONTH -TO- DATE------ - - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE a BUDGET ACTUAL VARIANCE % BUDGET % 0703 GRIT REMOVAL 0704 JANITORIAL & REFUSE REMOV 0706 HAZARDOUS WASTE DISPOSAL HAULING & DISPOSAL 0803 LEGAL SERVICES -STAFF PROFESSIONAL & LEGAL SERV 0901 OUTSIDE SAFETY SERVICES 0902 TECHNICAL SERVICES 0904 OTHER PUBLIC AGENCY SERVS 0905 REPROGRAPHIC SERVICES OUTSIDE SERVICES 1101 OFFICE EQUIPMENT /SUPPLIES 1103 OPERATING SUPPLIES 1104 OPERATING FUEL 1105 LABORATORY SUPPLIES 1106 SAFETY SUPPLIES MATERIALS & SUPPLIES 1201 RENTS & LEASES 1202 PUBLIC AGENCY FEES 1204 TUITION REIMBURSEMENT 1205 TECH TRAIN, CONF & MEETS 1206 CERTIFICATION & LICENSES 1208 SUBSCRIPTION /PUBLICATION 1209 MILEAGE REIMBURSEMENTS 1211 OUTSIDE ORGANIZATION FEES 1212 EMPLOYEE MEMBERSHIPS 1213 MISCELLANEOUS 1216 PROFESSIONAL EXP REIMB OTHER EXPENSES DEPARTMENT NET EXPENSES 6,674 5,863 811 12.2 80,000 92,804 12,804- 16.0- 80,000 116.0 12,435 1,383 11,052 88.9 14.9,000 158,417 9,417- 6.3- 149,000 106.3 924 0 924 100.0 11,000 1,249 9,751 88.6 11,000 11.4 34,207 7,246 26,961- 78.8 410,000 388,707 21,293 5.2 410,000 94.8 4,174 334 3,840 92.0 50,000 3,307 46,693 93.4 50,000 6.6 4,174 334 3,840 92.0 50,000 3,307 46,693 93.4 50,000 6.6 1,424 0 1,424 100.0 17,000 15,889 1,111 6.5 17.,000 93.5 105,943 19,334 86,609 81.8 1,270,700 398,901 871,799 68.6 1,270,700 31.4 424 0 424 100.0 5,000 3,109 1,891 37.8 5,000 62.2 87 0 87 100.0 1,000 0 11000 100.0 1,000 .0 107,878 19,334 88,544 82.1 1,293,70.0 417,899 875,801 67.7 1,293,700 32.3 1,750 210 1,540 88.0 21,000 24,585 3,585- 17.1- 21,000 117.1 46,979 21,132 25,847 55.0 563,000_ 545,537 17,463 3.1 563,000 96.9 1,674 0 1,674 100.0 20,000 0 20,000 100.0 20,000 .0 12,174 7,535 4,639 38.1 146,000 185,393 39,393- 27.0- 146,000 127.0 2,639 198 2,441 92.5 30,700 35,325 4,625- 15.1- 30,700 115.1 65,216 29,075 36,141 55.4 780,700 790,840 10,140- 1.3- 780,700 101.3 4,169 0 4,169 100.0 49,590 34.,998 14,502 29,3 49,500 70.7 16,274 0 16,274 100.0 367,700 349,879 17,821 4.8 367,700 95.2 837 154 683 81.6 10,000 1,969 8,031 60.3 10,000 19.7 4,872 1,057 3,815 78.3 58,700 33,942 24,758 42.2 58,700 57_B - 728 758 30- 4.1- 8,703 6,551 2,152 24,7 8,703 75.3 427 81 346 81.0 4,750 560 4,190 88.2 4,750 11.8 49 0 49 100.0 500 322 178 35.6 500 64.4 19,136 0 19,136 100.0 229,500 204,505 24,995 10.9 229,500 89.1 927 928 1- .1- 10,838 7,693 3,145 29.0 10,838 71.0 535 130 405 75.7 6,080 1,441 4,639 76,3 6,080 23.7 1,250 0 1,250 100.0 15,000 0 15,000 100.0 15,000 .0 49,204 3,108 46,096 93.7 761,271 641,860 119,411 15.7 761,271 84.3 2,264,472 615,883- 2,880,355 127.2 25,272,977 23,035,950 2,237,027 8.9 25,272,977 91.1 G PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 9 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - - -- -- -- - - -- - -- PERIOD ENDING: 613011-1> ( -- -------- -- DEPARTMENT 05 PUMP STATIONS - -- - -- ------------------------------------------------------ OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE - ----- --- ------ -- ---- -- - --- - -- - BUDGET --- - - - -- - ACTUAL ------- ------ VARIANCE ------ --------------------------------------------------------------------- % BUDGET ACTUAL VARIANCE % BUDGET 0102 SALARIES & WAGES -NON MGMT 62,199 0 62,199 100.0 746,267 749,037 2,770- .4- 746,267 100.4 0103 SALARIES & WAGES -COMP ABS 0 0 0 .0 0 0 0 .0 0 .0 0105 OVERTIME 2,304 0 2,304 100.0 27,527 42,017 14,490- 52.6- 27,527 152.6 0106 STANDBY PAID 8,337 0 8,337 100.0 100,000 103,876 3,876- 3.9- 100,000 103.9 0110 SALARY VACANCY 1,837- 0 1,837 -100.0 22,000- 0 22,000 -100.0 22,000- .0 SALARIES & WAGES 71,003 0 71,003 1.00.0 851,794 894,930 43,136- 5.1- 851,794 105.1 0201 WORKERS' COMPENSATION INS 2,100 0 2,100 100.0 25,156 18,077 7,079 28.1 25,156 71.9 0203 FEDERAL MEDICARE TAX 926 0 926 100.0 11,112 12,958 1,846- 16.6- 11,112 116.6 0204 MEDICAL & HEALTH INSUR 10,999 0 10,999 100.0 131,977 109,883 22,094 16.7 131,977 83.3 0205 RETIREMENT CONTRIBUTION 36,460 0 36,460 100.0 437,443 475,480 38,037- 8.7- 437,443 108.7 0206 DEFERRED COMP. CONTRIB 3,757 0 3,757 100.0 45,018 52,720 7,702- 17.1- 45,018 117.1 0207 DENTAL INSURANCE 1,072 0 1,072 100.0 12,820 12,737 83 .6 12,820 99.4 0208 LONG -TERM DISABILITY INS 216 0 216 100.0 2,471 2,371 100 4.0 2,471 96.0 0209 LIFE INSURANCE 286 0 2B6 100.0 3,366 1,921 1,445 42.9 3,366 57.1 0211 ACCRUED COMPENSATED ABS 0 0 0 .0 0 0 0 .0 0 .0 0212 BENEFIT VACANCY 2,250- 0 2,250 -100.0 27,000- 0 27,000 -100.0 27,000- .0 EMPLOYEE BENEFITS 53,566 0 53,566 100.0 642,363 686,147 43,784- 6.8- 642,363 106.8 0250 CAPITALIZED ADM OVERHEAD 470- 0 470 -100.0 5,563- 0 5,563 -100.0 5,563- .0 CAPITALIZED ADM OVERHEAD 470- 0 470 -100.0 5,563- 0 5,563 -100.0 5,563- .0 0406 OTHER CHEMICALS 33,337 13,515 19,622 59.5 400,000 430,279 30,279- 7.6- 400,000 107.6 CHEMICALS 33,337 13,515 19,822 59.5 400,000 430,279 30,279- 7.6- 400,000 107.6 0501 ELECTRICAL 76,270 39,684 36,586 48.0 457,600 424,421 33,179 7.3 457,600 92.7 0504 WATER 1,318 195 1,123 85.2 15,750 11,781 3,969 25.2 15,750 74.8 0505 TELEPHONE _ 3,925 656 3,269 83.3 47,100 43,192 31908 8.3 47,100 91.7 UTILITIES 81,513 40,535 40,978 50.3 520,450 479,394 41,056 7.9 520,450 92.1 0603 GENERAL REPAIRS & MAINT 3,087 7,185 4,098- 132.8- 37,000 70,044 33,044- 89.3- 37,000 189.3 0604 OUTSIDE REPAIRS & MAINT. 17,500 1,903 15,597 89.1 210,000 332,098 122,098- 58.1- 210,000 158.1 REPAIRS & MAINTENANCE 20,587 9,088 11,499 55.9 247,000 402,142 155,142- 62.8- 247,000 162.8 0704 JANITORIAL & REFUSE REMOV 1,525 0 1,525 100.0 18,300 19,134 834- 4.6- 18,300 104.6 HAULING & DISPOSAL 1,525 -0 1,525 100.0 18,300 19,134 834- 4.6- 18,300 104.6 0901 OUTSIDE SAFETY SERVICES 11975 0 1,975 100.0 8,200 9,583 1,383- 16.9- 8,200 116.9 0902 TECHNICAL SERVICES 4,230 0 4,230 100.0 50,650 43,369 7,281 14.4 50,650 85.6 OUTSIDE SERVICES 6,205 0 6,205 100.0 58,850 52,952 5,898 10.0 58,850 90.0 1103 OPERATING SUPPLIES 1,800 803 997 55.4 21,600 30,728 9,128- 42.3- 21,600 142.3 �y PREPARED 8/06/13, 13:48:23 EXPENSE SUMMARY REPORT BY DEPARTMENT PAGE 10 PROGRAM /GM279D RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY ---------------------------- DISTRICT PERIOD ENDING: 613a �3 - DEPARTMENT 05 PUMP STATIONS - - - -- -- ---------- - - - - -- - ------------------------------------------------------ OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ---- ------ - - ---- - ------ ---- ----- BUDGET ---- ---- -- ----- ACTUAL - - - -- VARIANCE -- --- -------- % ------ BUDGET -- -- - - -- - ------------------------------------------------ ACTUAL VARIANCE % BUDGET 1104 OPERATING FUEL 1,500 0 1,500 100.0 18,000 18,425 425- 2.4- 18,000 102.4 1106 SAFETY SUPPLIES 424 0 424 100.0 5,000 2,822 2,178 43.6 5,000 56.4 MATERIALS & SUPPLIES 3,724 803 2,921 78.4 44,600 51,975 7,375- 16.5- 44,600 116.5 1201 RENTS & LEASES 212 54 158 74.5 2,500 1,023 1,477 59.1 2,500 40.9 1202 PUBLIC AGENCY FEES 1,633 0 1,633 100.0 19,585 17,826 1,759 9.0 19,585 91.0 1204 TUITION REIMBURSEMENT 231 0 231 100.0 2,750 0 2,750 100.0 2,750 .0 1205 TECH TRAIN, CONF & MEETS 1,001 1,488 487- 48.7- 11,990 11,168 822 6.9 11,990 93.1 1206 CERTIFICATION & LICENSES 92 0 92 100.0 1,060 675 385 36.3 1,060 63.7 1208 SUBSCRIPTION /PUBLICATION 24 0 24 100.0 200 0 200 100.0 200 .0 1209 MILEAGE REIMBURSEMENTS 24 0 24 100.0 200 99 101 50.5 200 49.5 1212 EMPLOYEE MEMBERSHIPS 98 0 98 100.0 1,154 1.,517 363- 31.5- 1,154 131.5 1213 MISCELLANEOUS 25 0 25 100.0 300 13 287 95.7 300 4.3 OTHER EXPENSES 3,340 1,542 1,796 53.8 39,739 32,321 7,418 18.7 39,739 81.3 DEPARTMENT NET EXPENSES 274,330 65,483 208,847 76.1 2,917,533 3,049,274 231,741- 8.2- 2,817,533 108.2 2s PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 1 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - - - PERIOD ENDING_ t,/.30//-3 - - - - -- - - - - - -- - - - - -- - - - - - - - DEPARTMENT 01 ADMINISTRATION - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ------------ ACCOUNT TITLE --- ----- --- ------ --- BUDGET - - -- - -- ----- ACTUAL - - ---- --- VARIANCE --- ---- - --- %; - - - - -- BUDGET --- -- -- --- ACTUAL - --------------------------------------------- VARIANCE % BUDGET o 0101 SALARIES & WAGES- MGMNT. 30,659 0 - 30,659 100.0 367,787 434,371 66,584- 18.1- 367,787 118.1 0102 SALARIES & WAGES -NON MGMT 43,269 0 43,269 100.0 519,184 435,180 84,004 16.2 519,184 83.8 0103 COMP ASS - ACCRUAL PAYMENTS 25,000 0 25,000 100.0 300,000 216,431 83,569 27.9 300,000 72.1 0105 OVERTIME 75 0 75 100.0 900 2,673 1,773 - 197.0- 900 297.0 0110 SALARY VACANCY 9,837- 0 9,837 -100.0 118,000- 0 118,000 -100.0 118,000- .0 SALARIES & WAGES 89,166 0 89,166 100.0 1,069,871 110881655 18,784- 1.8- 1,069,871 101.8 0201 WORKERS' COMPENSATION INS 190 0 190 100.0 2,214 1,937 277 12.5 2,214 87.5 0202 STATE UNEMPLOYMENT INSUR 7,500 0 7,500 100.0 30,000 28,422 1,578 5.3 30,000 94.7 6203 FEDERAL MEDICARE TAX 1,072 0 1,072 100.0 12,787 13,538 751- 5.9- 12,787 105.9 0204 MEDICAL & HEALTH INSUR 18,103 0 18,103 100.0 217,225 150,867 66,358 30.5 217,225 69.5 0205 RETIREMENT CONTRIBUTIONS 44,269 0 44,269 100.0 531,019 431,440 99,579 18.8 531,019 81.2 0206 DEFERRED COMP. CONTRIB 3,701 0 3,701 100.0 44,258 38,103 6,155 13.9 44,258 86.1 0207 DENTAL INSURANCE 1,364 0 1,364 100.0 16,236 13,911 2,325 14.3 16,236 85.7 0208 LONG -TERM DISABILITY INS 154 0 154 100.0 1,826 1,474 352 19.3 1,826 80.7 0209 LIFE INSURANCE 610 0 610 100.0 7,243 4,079 3,164 43.7 7,243 56.3 0211 ACCRUED COMPENSATED ABS. 360,000 0 360,000 100.0 360,000 768,030 408,030- 113.3- 360,000 213.3 0212 BENEFIT VACANCY 41,674- 0 41,674 -100.0 500,000- 0 500,000 -100.0 500,000- .0 EMPLOYEE BENEFITS 395,289 0 395,289 100.0 722,808 1,451,801 728,993- 100.9- 722,808 200.9 0301 DIRECTOR MEETING FEES 5,028 0 5,028 100.0 60,325 56,709 3,616 6.0 60,325 94.0 0302 BOARD TRAINING AND CONF 3,837 1,468 2,369 61.7 46,000 15,874 30,126 65.5 46,000 34.5 0303 BOARD HEALTH BENEFITS 4,639 0 4,639 100.0 55,635 43,297 12,338 22.2 55,635 77.8 DIRECTOR FEES & EXPENSES 13,504 1,468 12,036 89.1 161,960 115,880 46,080 28.5 161,960 71.5 0604 OUTSIDE REPAIRS & MAINT 114. 0 114 100.0 800 426 374 46.8 800 53.3 0605 COMPUTER REPAIRS & MAINT 875 0 875 100.0 10,500 6,489 4,011 38.2 10,500 61.8 REPAIRS & MAINTENANCE 989 0 989 100.0 11,300 6,915 4,385 38.8 11,300 61.2 0801 PROFESSIONAL SERVICES 0 0 0 .0 0 0 0 .0 0 .0 0802 LEGAL SERVICES -BOARD 5,174 12,348 7,174- 138.7- 62,000 78,298 16,298- 26.3- 62,000 126.3 0803 LEGAL SERVICES -STAFF 2,087 6,838 4,751- 227.6- 25,000 35,019 10,019- 40.1- 25,000 140.1 PROFESSIONAL & LEGAL SERV 7,261 19,186 11,925- 164.2- 87,000 113,317 26,317- 30.2- 87,000 130.2 0902 TECHNICAL SERVICES 1,250 0 1,250 100.0 15,000 37,486 22,486 - 149.9- 15,000 249.9 0904 OTHER PUBLIC AGENCY SERVS 0 0 0 .0 45,250 45,982 732- 1.6- 45,250 101.6 OUTSIDE SERVICES 1,250 0 1,250 100.0 60,250 83,468 23,218- 38.5- 60,250 138.5 1101 OFFICE EQUIPMENT /SUPPLIES 2,924 0 2,924 100.0 35,000 17,305 17,695 50.6 35,000 49.4 1103 OPERATING SUPPLIES 475 0 475 100.0 5,700 4,231 1,469 25.8 5,700 74.2 1106 SAFETY SUPPLIES 100 0 100 100.0 100 119 19- 19.0- 100 119.0 MATERIALS & SUPPLIES 3,499 0 3,499 100.0 40,800 21,655 19,145 46.9 40,800 53.1 e(o PREPARED 8/06/13, 13:48 :36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 2 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING 6���f2 DEPARTMENT 01 ADMINISTRATION --------- - - - - -- - - -- ------------------------------------------------- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ---- - - - --- -- - - ----- - ---- ---- BUDGET ---------- -- ACTUAL ------ - - - --- VARIANCE % - -- ----- ---- ----- BUDGET ---- -------- ACTUAL -- --- - -- - - VARIANCE --- -- - --- - - % BUDGET - --- -- - - ----- - --- -- 1201 RENTS & LEASES 1,674 1,280 394 23.5 20,000 11,525 8,475 42.4 20,000 57.6 1204 TUITION REIMBURSEMENT 87 0 87 100.0 1,000 0 1,000 100.0 1,000 _0 1205 TECH TRAIN, CONF & MEETS 1,506 0 1,506 100.0 18,050 12,215 5,835 32.3 18,050 67.7 1208 SUBSCRIPTION /PUBLICATION 191 516 325- 170.2- 2,270 706 1,564 68.9 2,270 31.1 1209 MILEAGE REIMBURSEMENTS 30 82 52- 173.3- 250 1,136 886 - 354.4- 250 454.4 1210 PUBLIC NOTICES 68 426 358 - 526.5- 750 1,268 518- 69.1- 750 169.1 1211 OUTSIDE ORGANIZATION FEES 2,437 0 2,437 100.0 29,200 32,647 3,447- 11.8- 29,200 111.8 1212 EMPLOYEE MEMBERSHIPS 180 0 180 100.0 2,050 1,045 1,005 49.0 2,050 51.0 1213 MISCELLANEOUS 674 78 596 88.4 8,000 8,205 205- 2.6- 8,000 102.6 1214 ELECTION EXPENSE 0 0 0 .0 3.50,000 272,772 77,228 22.1 350,0.00 77.9 1216 PROFESSIONAL EXP REIMB 1,500 0 1,500 100.0 18,000 0 18,000 100.0 18,000 .0 OTHER EXPENSES 8,347 2,382 5,965 71.5 449,570 341,519 108,051 24.0 449,570 76.0 0100 CENTRAL SERVICES 519,305 23,036 496,269 95.6 2,603,559 3,223,210 619,651- 23.8- 2,603,559 123.8 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 3 PROGRAM /GM279L RUNNING EXPENSE] FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY ------------------- DISTRICT PERIOD ENDING: b o 113 43,107 -- --- --- -- DEPARTMENT 01 ADMINISTRATION - ------ ------ ------- - -- ------ ---- -- - - - -- -- -------- --- ----- ------- -- ------ - --------------- - OBS ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE - ---- --- ---- -- -- -- - --- - ------------------------------------------------------------------------------ BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE ------- ---- --- ------ BUDGET --- - - --- -- 0101 SALARIES & WAGES- MGMNT. 0102 SALARIES & WAGES -NON MGMT 0103 COMP ABS- ACCRUAL PAYMENTS 0105 OVERTIME SALARIES & WAGES 0201 WORKERS' COMPENSATION INS 0203 FEDERAL MEDICARE TAX 0204 MEDICAL & HEALTH INSUR 0205 RETIREMENT CONTRIBUTIONS 0206 DEFERRED COMP. CONTRIB 0207 DENTAL INSURANCE 0208 LONG -TERM DISABILITY INS 0209 LIFE INSURANCE EMPLOYEE BENEFITS 0604 OUTSIDE REPAIRS & MAINT REPAIRS & MAINTENANCE 0801 PROFESSIONAL SERVICES 0803 LEGAL SERVICES -STAFF PROFESSIONAL & LEGAL SERV 0902 TECHNICAL SERVICES 0903 DATA PROCESSING SERVICES 0904 OTHER PUBLIC AGENCY SERVS OUTSIDE SERVICES 1101 OFFICE EQUIPMENT /SUPPLIES MATERIALS & SUPPLIES 1204 TUITION REIMBURSEMENT 1205 TECH TRAIN, CONF & MEETS 1208 SUBSCRIPTION /PUBLICATION 1209 MILEAGE REIMBURSEMENTS 1212 EMPLOYEE MEMBERSHIPS 1213 MISCELLANEOUS 1216 PROFESSIONAL EXP REIMS OTHER EXPENSES 0110 FINANCE & ACCOUNTING 10,913 0 10,913 100.0 130,912 140,494 9,582- 7.3- 130,912 107.3 43,107 0 43,107 100.0 517,284 581,367 64,083- 12.4- 517,284 112.4 0 0 0 .0 0 0 0 .0 0 .0 2,522 0 2,522 100.0 30,154 22,262 7,892 26.2 30,154 73.8 56,542 0 56,542 100.0 678,350 744,123 65,773- 9.7- 678,350 109.7 129 0 129 100.0 1,537 1,394 143 9.3 1,537 90.7 725 0 725 100.0 8,568 9,344 776- 9.1- 8,568 109.1 9,773 0 9,773 100..0 117,111 125,956 8,845- 7.6- 117,111 107.6 32,713 0 32,713 100.0 392,435 390,811 1,624 .4 392,435 99.6 3,442 0 3,442 100.0 41,139 45,133 3,994- 9.7- 41,139 109.7 1,051 0 1,051 100.0 12,601 14,755 2,154- 17.1- 12,601 117,1 162 0 162 100.0 1,856 1,849 7 .4 1,856 99.6 401 0 401 10.0.0 4,680 2,838 1,842 39.4 4,680 60.6 48,396 0 48,396 100.0 579,927 592,080 12,153- 2.1- 579,927 102.1 87 0 87 100.0 1,000 0 1,000 100.0 1,000 .0 87 0 87 100,0 1,000 0 1,000 100.0 1,000 .0 9,674 0 9,674 100.0 116,000 157,799 41,799- 36.0- 116,000.136.0 1,250 '0 1,250 100.0 15,000 5,669 9,331 62.2 15,000 37.8 10,924 0 10,924 100.0 131,000 163,468 32,468- 24.8- 131,000 124.8 9,974 0 9,974 100.0 119,600 107,104 12,496 10.4 119,600 89.6 0 0 0 .0 400 0 400 100.0 400 .0 0 0 0 ,0 126,500 119,569 6,931 5.5 126,500 94.5 9,974 0 9,974 100.0 246,500 226,673 19,827 8.0 246,500 92.0 750 0 750 100.0 9,000 8,360 640 7.1 9,000 92.9 750 0 750 100.0 9,000 8,360 640 7.1 9,000 92.9 337 0 337 100.0 4,000 2,000 2,000 50.0 4,000 50.0 2,000 0 2,000 100.0 5,200 5,251 51- 1.0- 5,200 101.0 149 47 102 68.5 1,700 1,969 269- 15.8- 1,700 115.8 50 0 50 100.0 600 969 369- 61.5- 600 161.5 127 280 153- 120.5- 1,480 1,618 138- 9.3- 1,480 109.3 100 0 100 100,0 1,100 1,504 404- 36.7- 1,100 136.7 250 0 250 100.0 3,000 0 3,000 100.0 3,000 .0 3,013 327 2,686 89.1 17,080 13,311 3,769 22.1 17,080 77.9 129,686 327 129,359 99.7 1,662,857 1,748,015 85,158- 5.1- 1,662,857 105.1 0.28 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 4 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - PERIOD ENDING_ 6 / 3o1 o - - ----- - - - --- --- --- - - - - - -- L 9 J DEPARTMENT 01 ADMINISTRATION OBJ ---- - - - ---- --MONTH -TO- DATE-- --- -- -- -- -- --- --------- -- YEAR -TO-DATE-- -- -- -- - -- --- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE a BUDGET ACTUAL VARIANCE % BUDGET % - ------ - ----- - ------- -- ----- ---- ---- --- -- -- -- - --- --- -- ---- - --- --- - -- -- -- -- --- - - ----- ------------- ---------- --- --- -- ---- --- ---- -- 0101 SALARIES & WAGES- MGMNT. 0102 SALARIES & WAGES -NON MGMT 0103 COMP ABS- ACCRUAL PAYMENTS 0105 OVERTIME SALARIES & WAGES 0201 WORKERS' COMPENSATION INS 0203 FEDERAL MEDICARE TAX 0204 MEDICAL & HEALTH INSUR 0205 RETIREMENT CONTRIBUTION 0206. DEFERRED COMP. CONTRIB 0207 DENTAL INSURANCE 0208 LONG -TERM DISABILITY INS 0209 LIFE INSURANCE 0213 OPEB CONTRIBUTION EMPLOYEE BENEFITS 0801 PROFESSIONAL SERVICES 0803 LEGAL SERVICES -STAFF PROFESSIONAL & LEGAL SERV 0902 TECHNICAL SERVICES 0906 RECRUITMENT OUTSIDE SERVICES 1101 OFFICE EQUIPMENT /SUPPLIES 1103 OPERATING SUPPLIES 1106 SAFETY SUPPLIES MATERIALS & SUPPLIES 1204 TUITION REIMBURSEMENT 1205 TECH TRAIN, CONF & MEETS 1208 SUBSCRIPTION /PUBLICATION 1209 MILEAGE REIMBURSEMENTS 1212 EMPLOYEE MEMBERSHIPS 1213 MISCELLANEOUS 1216 PROFESSIONAL EXP REIMB OTHER EXPENSES 0120 HUMAN RESOURCES 10,008 0 10,008 100.0 120,074 116,638 3,436 2.9 120,074 97.1 21,754 0 21,754 100.0 260,960 245,116 15,844 6.1 260,960 93.9 0 0 0 .0 0 151 151- .0 0 .0 837 0 837 100.0 10,000 6,324 3,676 36.8 10,000 63.2 32,599 0 32,599 100.0 391,034 368,229 22,805 5.8 391,034 94.2 86 0 86 100.0 889 705 184 20.7 889 79.3 471 0 471 100.0 5,575 5,436 139 2.5 5,575 97.5 346,235 0 346,235 100.0 4,154,622 4,390,516 235,894- 5.7- 4,154,622 105.7 18,990 0 18,990 100.0 227,847 204,955 22,892 10.0 227,847 90.0 1,932 0 1,932 100.0 22,986 24,517 1,531- 6.7- 22,986 106.7 33,184 0 33,184 100.0 398,142 381,399 16,743 4.2 398,142 95.8 78 0 78 100.0 936 798 138 14.7 936 85.3 3,873 0 3,873 100.0 46,322 99,475 53,153- 114.7- 46,322 214.7 0 0 0 .0 3,767,000 3,476,904 290,096 7.7 3,767,000 92.3 404,849 0 404,849 100.0 8,624,319 8,584,705 39,614 .5 8,624,319 99.5 824 0 824 100.0 9,800 11,196 1,396- 14.2- 9,800 114.2 10,424 20,387 9,963- 95.6- 125,000 211,686 86,686- 69.3- 125,000 169.3 11,248 20,387 9,139- 81.3- 134,800 222,882 88,082- 65.3- 134,800 165.3 10,074 0 10,074 100.0 120,800 29,197 91,603 75.8 120,800 24.2 8,174 1,246 6,928 84.8 98,000 139,234 41,234- 42.1- 98,000 142.1 18,248 1,246 17,002 93.2 218,800 168,431 50,369 23.0 218,800 77.0 674 0 674 100.0 8,000 10,519 2,519- 31.5- 8,000 131.5 0 0 0 .0 13,600 13,242 358 2.6 13,600 97.4 0 0 0 .0 0 0 0 .0 0 .0 674 0 674 100.0 21,600 23,761 2,161- 10.0- 21,600 110.0 424 0 424 100.0 5,000 0 5,000 100.0 5,000 .0 1;437 0 1,437 100.0 17,200 11,691 5,509 32.0 17,200 68.0 0 0 0 .0 0 0 0 .0 0 .0 49 0 49 100.0 500 349 151 30.2 500 69.8 105 0 105 100.0 1,260 1,489 229- 18.2- 1,260 118.2 50 0 50 100.0 600 113 487 81.2 600 18.8 478 0 478 100.0 5,615 0 5,615 100.0 5,615 .0 2,543 0 2,543 100.0 30,175 13,642 16,533 54.8 30,175 45.2 470,161 21,633 448,528 95.4 9,420,728 9,381,650 39,078 .4 9,420,728 99.6 z� PREPARED B/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 5 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - - - -- - - - PERIOD ENDING: ---------------- - - - - -- __6 -,�-- -------------------------------------------------------- 01 ADMINISTRATION OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET 0101 SALARIES & WAGES- MGMNT. 0102 SALARIES & WAGES -NON MGMT 0103 COMP ABS- ACCRUAL PAYMENTS 0105 OVERTIME SALARIES & WAGES 0201 WORKERS' COMPENSATION INS 0203 FEDERAL MEDICARE TAX 0204 MEDICAL & HEALTH INSUR 0205 RETIREMENT CONTRIBUTIONS 0206 DEFERRED COMP. CONTRIB 0207 DENTAL INSURANCE 0208 LONG -TERM DISABILITY INS 0209 LIFE INSURANCE EMPLOYEE BENEFITS 0501 ELECTRICAL 0502 NATURAL GAS 0504 WATER UTILITIES 0604 OUTSIDE REPAIRS & MAINT 0605 COMPUTER REPAIRS & MAINT 0606 REAL PROPERTY REPAIRS REPAIRS & MAINTENANCE 0803 LEGAL SERVICES -STAFF PROFESSIONAL & LEGAL SERV 0902 TECHNICAL SERVICES 0904 OTHER PUBLIC AGENCY SERVS OUTSIDE SERVICES 1101 OFFICE EQUIPMENT /SUPPLIES 1103 OPERATING SUPPLIES 1106 SAFETY SUPPLIES 1108 INVENTORY OVER /SHORT MATERIALS & SUPPLIES 1201 RENTS & LEASES 1204 TUITION REIMBURSEMENT 1205 TECH TRAIN, CONF & MEETS 1206 CERTIFICATION & LICENSES 10,792 43,344 0 1,211 55,347 507 813 14,638 31,826 3,175 1,220 150 361 52,690 6,250 924 337 7,511 250 1,837 3,337 5,424 2,250 2,250 7,837 250 8,087 1,924 837 170 0 2,931 2,500 87 837 112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10,792 100.0 43,344 100.0 0 .0 1,211 100.0 55,347 100.0 507 100.0 813 100.0 14,638 100.0 31,826 100.0 3,175 100.0 1,220 100.0 150 100.0 361 100.0 52,690 100.0 8,878 2,628- 42.0- 806 118 12.8 0 337 100.0 9,684 2,173- 28.9- 0 250 100.0 0 1,837 100.0 800 2,537 76.0 800 428 428 0 0 0 0 0 0 38,153 38,153 0 0 0 200 4,624 85.3 1,822 81.0 1,822 81.0 7,837 100.0 250 100.0 8,087 100.0 1,924 100.0 837 100.0 170 100.0 38,153- .0 35,222 -201.7 2,500 100.0 87 100.0 837 100.0 88- 78.6- 129,449 520,062 0 14,444 663,955 5,974 9,569 175,480 381,769 37,968 14,574 1,767 4,233 631,334 75,000 11,000 4,,000 90,000 3,000 22,000 40,000 65,000 27,000 27,000 94,000 3,000 97,000 23,000 10,000 1,000 0 34,000 5,000 1,000 10,000 1,300 136,257 570,856 0 5,545 712,658 5,136 10,286 150,548 379,014 39,257 13,911 1,848 2,447 602,447 89,143 11,733 4,881 105,757 281 18,852 25,198 44,331 7,157 7,157 17,907 2,018 19,925 517 12,450 0 0 12,967 5,425 0 3,309 200 6,808- 5.3- 50,794- 9.8- 0 .0 8,899 61.6 48,703- 7.3- 838 14.0 717- 7.5- 24,932 14.2 2,755 .7 1,289- 3.4- 663 4.5 81- 4.6- 1,786 42.2 28,887 4.6 14,143- 18.9- 733- 6.7- 881- 22.0- 15,757- 17.5- 2,719 90.6 3,148 14.3 14,802 37.0 20,669 31.8 19,843 73.5 19,843 73.5 76,093 81.0 982 32.7 77,075 79.5 22,483 97.8 2,450- 24.5- 1,000 100.0 0 .0 21,033 61.9 425- 8.5- 1,000 100.0 6,691 66.9 1,100 84.6 129,449 105.3 520,062 109.8 0 .0 14,444 38.4 663,955 107.3 5,974 86.0 9,569 107.5 175,480 85.8 381,769 99.3 37,968 103.4 14,574 95.5 1,767 104.6 4,233 57.8 631,334 95.4 75,000 118.9 11,000 106.7 4,000 122.0 90,000 117.5 3,000 9.4 22,000 85.7 40,000 63.0 65,000 68.2 27,000 26.5 27.000 26.5 94,000 19.1 3,000 67.3 97,000 20.5 23,000 2.2 10,000 124.5 1,000 _0 0 .0 34,000 38.1 5,000 108.5 1,000 .0 10,000 33.1 1.300 15.4 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 6 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 6/ 30// 3- _ - -_ -__ J - DEPARTMENT 01 ADMINISTRATION OBJ -- ----- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE --------------------------------------------------------------------------------------------------------------------- BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET % 1208 SUBSCRIPTION /PUBLICATION 0 0 0 .0 500 693 193- 38.6- 500 138.6 1209 MILEAGE REIMBURSEMENTS 12 0 12 100.0 100 0 100 100.0 100 .0 1211 OUTSIDE ORGANIZATION FEES 0 0 0 .0 0 0 0 .0 0 .0 1212 EMPLOYEE MEMBERSHIPS 0 - 0 0 .0 2,000 1,955 45 2.3 2,000 97.8 1213 MISCELLANEOUS 12 450 438 - 650.0- 100 450 350- 350.0- 100 450.0 1216 PROFESSIONAL EXP REIMB 3,000 0 3,000 100.0 6,000 0 6,000 100.0 6,000 .0 OTHER EXPENSES 6,560 650 5,910 90.1 26,000 12,032 13,968 53.7 26,000 46.3 0140 PURCHASING 140,800 49,715 91,085 64.7 1,634,289 1,517,274 117,015 7.2 1,634,289 92.8 3/ PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 7 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: (-/3o ) f 1- - ----------------------------------- DEPARTMENT 01 ADMINISTRATION --------------- ---- ------ ------ ----_______"'--'-'----------'----'------'---- OBS - ------- - - - - -- MONTH -TO- DATE------- - - - - -- ------- - - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ------------------------------------------------`----------------------------------------------------------------------- BUDGET ACTUAL VARIANCE % . BUDGET ACTUAL VARIANCE % BUDGET % 0102 SALARIES d, WAGES -NON MGMT 25,428 0 25,428 100.0 305,015 235,729 69,286 22.7 305,015 77.3 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 0 0 .0 0 .0 0105 OVERTIME 836 0 836 100.0 91999 106 9,893 98.9 9,999 1.1 SALARIES & WAGES 26,264 0 26,264 100.0 315,014 235,835 79,179 25.1 315,014 74.9 0201 WORKERS` COMPENSATION INS. 624 0 624 100.0 7,466 3,393 4,073 54.6 7,466 45.4 0203 FEDERAL MEDICARE TAX 387 0 387 100.0 4,545 3,472 1,.073 23.6 4,545 76.4 0204 MEDICAL & HEALTH INSUR 5,480 0 5,480 100.0 65,650 52,772 12,878 19.6 65,650 80.4 0205 RETIREMENT CONTRIBUTION 14,842 - 0 14,842 100.0 177,994 128,929 - 49,065 27.6 177,994 72.4 0206 DEFERRED COMP. CONTRIB 1,512 0 1,512 100.0 18,078 13,569 4,509 24.9 18,078 75.1 0207 DENTAL INSURANCE 537 0 537 100.0 6,433 5,847 586 9.1 6,433 90.9 0208 LONG -TERM DISABILITY INS 86 0 86 100.0 944 707 237 25.1 944 74.9 0209 LIFE INSURANCE 138 0 138 100.0 1,656 608 1,048 63.3 1,656 36.7 EMPLOYEE BENEFITS 23,606 0 23,606 100.0 282,766 209,297 73,469 26.0 282,766 74.0 0604 OUTSIDE REPAIRS & MAINT 3,337 2,328 1,009 30.2 40,000 14,561 25,439 63.6 40,000 36.4 REPAIRS & MAINTENANCE 3,337 2,328 1,009 30.2 40,000 14,561 25,439 63.6 40,000 36.4 0801 PROFESSIONAL SERVICES 3,750 780 2,970 79.2 45,000 40,999 4,001 8.9 45,000 91.1 0803 LEGAL SERVICES -STAFF 1,637 334 1,303 79.6 10,000 2,157 7,843 78.4 10,000 21.6 PROFESSIONAL & LEGAL SERV 5,387 1,114 4,273 79.3 55,000 43,156 11,844 21.5 55,000 78.5 0901 OUTSIDE SAFETY SERVICES 4,587 5,869 1,282- 27.9- 55,000 35,875 19,125 34.8 55,000 65.2 0902 TECHNICAL SERVICES 20,837 3,805 17,032 81.7 250,000 210,785 39,215 15.7 250,000 84.3 OUTSIDE SERVICES 25,424 9,674 15,750 61.9 305,000 246,660 58,340 19.1 305,000 80.9 1001 SELF - INSURANCE EXPENSE 0 0 0 .0 850,000 - 650,000 0 .0 850,000 100.0 SELF- INSURANCE EXPENSE 0 0 0 .0 850,000 850,000 0 .0 850,000 100.0 1101 OFFICE EQUIPMENT /SUPPLIES 250 49 201 80.4 3,000 2,020 980 32.7 3,000 67.3 1106 SAFETY SUPPLIES 3,750 4,448 698- 18.6- 45,000 29,785 15,215 33.8 45,000 66.2 MATERIALS & SUPPLIES 4,000 4,497 497- 12.4- 48,000 31,805 16,195 33.7 48,000 66.3 1201 RENTS & LEASES 424 1,013 589- 138.9- 5,000 3,143 1,857 37.1 5,000 62.9 1202 PUBLIC AGENCY FEES 212 0 212 100.0 2,500 154 2,346 93.8 2,500 6.2 1205 TECH TRAIN, CONF & MEETS 837 28 809 96.7 10,000 7,720 2,280 22.8 10,000 77.2 1206 CERTIFICATION & LICENSES 49 0 49 100.0 500 0 500 100.0 500 .0 1207 CLAIMS 424 0 424 100.0 5,000 668 4,332 86.6 5,000 13.4 1208 SUBSCRIPTION /PUBLICATION 174 0 174 100.0 2,000 2,235 235- 11.8- 2,000 111.8 1209 MILEAGE REIMBURSEMENTS 87 0 87 100.0 1,000 487 513 51.3 1,000 48.7 1212 EMPLOYEE MEMBERSHIPS 115 0 115 100.0 1,325 485 840 63.4 1,325 36.6 1213 MISCELLANEOUS 424 0 424 100.0 5,000 4,621 379 7.6 5,000 92.4 OTHER EXPENSES 2,746 1,041 1,705 62.1 32,325 19,513 12,812 39.6 32,325 60.4 9 PREPARED 8/06/13, 13:48:36 - EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 8 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT — — — — PERIOD ENDING- ��-; 3 — --- --- — - --- — -- — ----- ----- -- -------------- — ------- --- --------- --- DEPARTMENT 01 ADMINISTRATION OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE e BUDGET % -----------------------------------------`------------------------------------------------ ------ -- ------- --- -- --- -- - -- --- 0150 SAFETY & RISK MANAGEMENT 90,764 18,654 72,110 79.4 1,928,105 1,650,827 277,278 14.4 1,928,105 85.6 33 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 9 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -- ----- PERIOD ENDING: b12, D I ---- -- -- - - -- --------------- DEPARTMENT 01 ADMINISTRATION -------- --- ----- ---- ----- - - -- -- r ----------------------------------------------------- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE - ---- --- ---- -- ------ - -- --- - ------ BUDGET ----- -- --- ACTUAL -- --- -- ---- VARIANCE - --- -- - ------------------------------ e BUDGET ACTUAL -- ---- VARIANCE -------- -- --- ---- BUDGET - - -- -- - - -- % - - - -- 0101 SALARIES & WAGES- MGMNT. 10,783 0 10,783 100.0 129,330 136,145 6,815- 5.3- 129,330 105.3 0102 SALARIES & WAGES -NON MGMT 38,566 0 38,566 100.0 462,781 510,254 47,473- 10.3- 462,781 110.3 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 0 0 .0 0 .0 0105 OVERTIME 317 0 317 100.0 3,683 845 2,838 77.1 3,683 22.9 SALARIES & WAGES 49,666 0 49,666 100.0 595,794 647,244 51,450- 8.6- 595,794 108.6 0201 WORKERS' COMPENSATION INS 122 0 122 100.0 1,365 1,214 151 11.1 1,365 88.9 0203 FEDERAL MEDICARE TAX 726 0 726 100.0 8,580 9,256 676- 7.9- 8,580 107.9 0204 MEDICAL & HEALTH INSUR 12,172 0 12,172 100.0 145,943 129,021 16,922 11.6 145,943 88.4 0205 RETIREMENT CONTRIBUTIONS 29,474 0 29,474 100.0 353,655 361,889 8,234- 2.3- 353,655 102.3 0206 DEFERRED COMP. CONTRIB 2,870 0 2,870 100.0 34,308 36,947 2,639- 7.7- 34,308 107.7 0207 DENTAL INSURANCE 1,043 0 1,043 100.0 12,461 12,562 101- .8- 12,461 100.8 0208 LONG -TERM DISABILITY INS 142 0 142 100.0 1,583 1,666 83- 5.2- 1,583 105.2 0209 LIFE INSURANCE 375 0 375 100.0 4,379 2,895 1,484 33.9 4,379 66.1 EMPLOYEE BENEFITS 46,924 0 46,924 100.0 562,274 555,450 6,824 1.2 562,274 98.8 0250 CAPITALIZED ADM OVERHEAD 4,063- 0 4,063 -100.0 48,690- 21,699- 26,991- 55.4 48,690- 44.6 CAPITALIZED ADM OVERHEAD 4,063- 0 4,063 -100.0 48,690- 21,699- 26,991- 55.4 48,690- 44.6 0604 OUTSIDE REPAIRS & MAINT 170 0 170 100.0 1,000 102 89B 89.8 1,000 10.2 REPAIRS & MAINTENANCE 170 0 170 100.0 1,000 102 898 89.8 1,000 10.2 0902 TECHNICAL SERVICES 28,337 0 28,337 100.0 340,000 314,831 25,169 7.4 340,000 92.6 0905 REPROGRAPHIC SERVICES 1,250 0 1,250 100.0 15,000 2,167 12,833 85.6 15,000 14.4 OUTSIDE SERVICES 29,587 0 29,587 100.0 355,000 316,998 38,002 10.7 355,000 89.3 1101 OFFICE EQUIPMENT /SUPPLIES 3,549 41 3,508 98.8 42,500 22,045 20,455 48.1 42,500 51.9 1103 OPERATING SUPPLIES 3,337 0 3,337 100.0 40,000 24,910 15,090 37.7 40,000 62.3 1106 SAFETY SUPPLIES 21 0 21 100.0 175 185 10- 5.7- 175 105.7 MATERIALS &. SUPPLIES 6,907 41 6,866 99.4 82,675 47,140 35,535 43.0 82,675 57.0 1203 PUBLIC INFORMATION 71,170 0 71,170 100.0 427,000 278,978 148,022 34.7 427,000 65.3 1205 TECH TRAIN, CONF & MEETS 500 0 500 100.0 6,000 3,667 2,333 3B.9 6,000 61.1 1208 SUBSCRIPTION /PUBLICATION 78 0 78 100.0 815 417 398 48.8 BIS 51.2 1209 MILEAGE REIMBURSEMENTS 87 86 1 1.1 1,000 812 188 18.8 1,000 81.2 1212 EMPLOYEE MEMBERSHIPS 27 0 27 100.0 225 228 3- 1.3- 225 101.3 1213 MISCELLANEOUS 87 0 87 100.0 1,000 504 496 49.6 1,000 50.4 1216 PROFESSIONAL EXP REIMB 7S0 0 750 100.0 9,000 0 9,000 100.0 9,000 .0 OTHER EXPENSES 72,699 86 72,613 99.9 445,040 284,606 160,434 36.0 445,040 64.0 0170 COMMUNICATION SERVICES 201,890 127 201,763 99.9 1,993,093 1,829,841 163,252 8.2 1,993,093 91.8 PREPARED 8/06113, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 10 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: - ------ - - ---- - -- -- - - -- - -- .2 F -- ---- - '- -'-- ---- - -- - - - --'- DEPARTMENT 01 ADMINISTRATION OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE -------------------- ---- --- --- --- BUDGET ---- ---- --- ACTUAL - - -- --- - - --- VARIANCE - - - --- - ------------------------------------------------------------'------ % BUDGET ACTUAL VARIANCE % BUDGET %_ 0102 SALARIES & WAGES -NON MGMT 58,833 0 58,833 100.0 705,875 591,425 114,450 16.2 705,875 03.8 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 0 0 .0 0 .0 0105 OVERTIME 1,462 0 1,462 100.0 17,500 24,030 6,530- 37.3- 17,500 137.3 SALARIES & WAGES 60,295 0 60,295 100.0 723,375 615,455 107,920 14.9 723,375 85.1 0201 WORKERS' COMPENSATION INS 138 0 138 100.0 1,623 1,153 470 29.0 1,623 71.0 0203 FEDERAL MEDICARE TAX 854 0 854 100.0 10,160 8,898 1,262 12.4 10,160 87.6 0204 MEDICAL & HEALTH INSUR 9,481 0 9,481 100.0 113,706 102,308 - 11,398 10.0 113,706 90.0 0205 RETIREMENT CONTRIBUTION 33,590 0 33,590 100.0 403,003 314,625 88,378 21.9 403,003 78.1 0206 DEFERRED COMP. CONTRIB 3,365 0 3,365 100.0 40,347 37,538 2,809 7.0 40,347 93.0 0207 DENTAL INSURANCE 1,183 0 1,183 100.0 14,086 14,102 16- .1- 14,086 100.1 0208 LONG -TERM DISABILITY INS 193 0 193 100.0 2,261 1,750 511 22.6 2,261 77.4 0209 LIFE INSURANCE 250 0 250 100.0 2,978 990 1.,988 66.8 2,978 33.2 EMPLOYEE BENEFITS 49,054 0 49,054 100.0 588,164 481,364 106,800 18.2 588,164 81.8 0505 TELEPHONE 7,225 7,162- 14,387 199.1 86,700 43,526 43,174 49.8 86,700 50.2 UTILITIES 7,225 7,162- 14,387 199.1 86,700 43,526 43,174 49.8 06,700 50.2 0603 GENERAL REPAIRS & MAINT 424 2,152 1,728- 407.5- 5,000 $,718 718- 14.4- 5,000 114.4 0604 OUTSIDE REPAIRS & MAINT 2,087 0 2,087 100.0 25,000 5,785 19,215. 76.9 25,000 23.1 0605 COMPUTER REPAIRS & MAINT 29,337 43 29,294 99.9 352,000 352,155 155- .0 352,000 100.0 REPAIRS & MAINTENANCE 31,848 2,195 29,653 93.1 382,000 363,658 18,342 4.8 382,000 95.2 0902 TECHNICAL SERVICES 5,924 0 5,924 100.0 71,000 32,642 38,358 54.0 71,000 46.0 OUTSIDE SERVICES 5,924 0 5,924 100.0 71,000 32,642 38,358 54.0 71,000 46.0 1101 OFFICE EQUIPMENT /SUPPLIES 212 170 42 19.8 2,500 3,453 953- 38.1- 2,500 138.1 1103 OPERATING SUPPLIES 18 4 14 77.8 150 366 216 - 144.0- 150 244.0 MATERIALS & SUPPLIES 230 174 56 24.3 2,650 3,819 1,169- 44.1- 2,650 144.1 1201 RENTS & LEASES 474 113 361 76.2 5,600 2,246 3,354 59.9 5,600 40.1 1205 TECH TRAIN, CONF & MEETS 1,674 2,139 465- 27.8- 20,000 26,100 6,100- 30.5- 20,000 130.5 1208 SUBSCRIPTION /PUBLICATION 0 0 0 .0 500 179 321 64.2 500 35.8 1209 MILEAGE REIMBURSEMENTS 50 0 50 100.0 600 304 296 49.3 600 50.7 1212 EMPLOYEE MEMBERSHIPS 34 0 34 100.0 375 355 20 5.3 375 94.7 1213 MISCELLANEOUS 18 0 18 100.0 150 243 93- 62.0- 150 162.0 OTHER EXPENSES 2,250 2,252 2- .1- 27,225 29,427 2,202- 8.1- 27,225 108.1 0180 IT 156,826 2,541- 159,367 101.6 1,881,114 1,569,891 311,223 16.5 1,881,114 83.5 05) PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 11 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL - - CONTRA COSTA SANITARY DISTRICT PERIOD END ------- ------ - - - -- -------- - -- - - -------- ---- - - - - - - - - -- - -- ING b�3 DEPARTMENT O1 ADMINISTRATION OBJ ------- - - - - -- MONTH -TO- DATE------ - - - - - -- -------------- YEAR-TO-DATE -------------- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET °s ------------------------------------------ -- -- ----- --- ------ ---- --- -- - --- — ----- --- ---- - - -- — -------- --- -------- -- --- --- ---- -- - --- -- DEPARTMENT NET EXPENSES 1,709,432 110,951 1,598,481 93.5 21,123,745 20,920,708 203,037 1.0 21,123,745 99.0 3G PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 12 PROGRAM /GM279L RUNNING EXPENSR FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: b .� lj -- ------------------- - - ---- -- ---- ------- ---- -- ---- ---- - --- -- --- -- ------------------`---------`--------------------- DEPARTMENT 02 ENGINEERING OBIT ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - --- YEAR -TO- DATE-------- - - - - -- ANNUAL. NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE %_ BUDGET % --- --- --- --- -- ---- -- ---- --- --- ----- -- -- --------- -- -- -- ------------ ---- -- --- ------- ------ - ----- - --- ------- ---- ----- -- - --- ----- -- 0101 SALARIES & WAGES- MGMNT. 0102 SALARIES & WAGES -NON MGMT 0103 SALARIES & WAGES -COMP ABS 0105 OVERTIME 0110 SALARY VACANCY SALARIES & WAGES 0201 WORKERS' COMPENSATION INS 0203 FEDERAL MEDICARE TAX 0204 MEDICAL & HEALTH INSUR 0205 RETIREMENT CONTRIBUTION 0206 DEFERRED COMP. CONTRIB 0207 DENTAL INSURANCE 0208 LONG -TERM DISABILITY INS 0209 LIFE INSURANCE 0211 ACCRUED COMPENSATED ABS. 0212 BENEFIT VACANCY EMPLOYEE BENEFTIS 0250 CAPITALIZED ADM OVERHEAD CAPITALIZED ADM OVERHEAD 0501 ELECTRICAL 0502 NATURAL GAS 0504 WATER 0505 TELEPHONE UTILITIES 0604 OUTSIDE REPAIRS & MAINT 0605 COMPUTER REPAIRS & MAINT REPAIRS & MAINTENANCE 0704 JANITORIAL & REFUSE REMOV 0706 HAZARDOUS WASTE DISPOSAL 0707 MOBILE COLLECTION -HHW HAULING & DISPOSAL 0803 LEGAL SERVICES -STAFF PROFESSIONAL & LEGAL SERV 0902 TECHNICAL SERVICES 0904 OTHER PUBLIC AGENCY SERVS 0905 REPROGRAPHIC SERVICES 17,771 295,655 0 4,011 9.424- 308,013 5,448 4,221 57,631 176,948 17,758 6,138 953 1,478 0 10,837- 259,738 113,708 113,708 1,211 125 174 1,912 3,422 4,299 587 4,886 1,761 115,024 0 116,785 14,688 14,688 34,424 2,500 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17,771 100.0 295,655 100.0 0 .0 4,011 100.0 9,424 -100.0 308,013 100.0 5,448 100.0 4,221 100.0 57,631 100.0 176,948 100.0 17,758 100.0 6,138 100.0 953 100.0 1,478 100.0 0 .0 10,837 -100.0 259,738 100.0 113,708 -100.0 113,708 -100.0 657 554 45.7 16 109 87.2 0 174 100.0 2,473 561- 29.3- 3,146 1,160 0 1,160 957 83,084 0 84,041 19,996 19,996 25,366 0 0 276 8.1 3,139 73.0 587 100.0 3,726 76.3 804 45.7 31,940 27.8 0 .0 32,744 28.0 5,308- 36.1- 5,308- 36.1- 9,058 26.3 2,500 100.0 125 100.0 213,241 87,263 3,547,552 3,826,357 0 19,299 48,000 72,305 113.000- 0 3,695,793 4,005,224 65,101 47,067 50,234 53,502 691,275 697,179 2,123,035 2,134,355 212,931 243,452 73,403 82,319 11,304 10,960 17,406 8,201 0 0 130,000- 0 3,114,689 3,277,035 1,364,320- 1,325,553- 1,364,320- 1,325,553- 14,400 1,500 2,000 22,900 40,800 51,500 7,000 58,500 21,000 500,200 0 521,200 96,000 96,000 293,000 130,000 1,500 8,104 1,332 1,975 28,727 40,138 28,557 11,315 39,872 21,092 549,573 0 570,665 122,722 122,722 405,711 118,496 0 125,978 59.1 213,241 40.9 278,805- 7.9- 3,547,552 107.9 19,299- .0 0 .0 24,305- 50.6- 48,000 150.6 113.000 -100.0 113.000- .0 309,431- 8.4- 3,695,793 108.4 18,034 27.7 65,101 72.3 3,268- 6.5- 50,234 106.5 5,904- .9- 691,275 100.9 11,320- .5- 2,123,035 100.5 30,521- 14.3- 212,931 114.3 8,916- 12.1- 73,403 112.1 344 3.0 11,304 97.0 9,205 52,9 17,406 47.1 0 .0 0 .0 130,000 -100.0 130,000- .0 162,346- 5.2- 3,114,689 105.2 38,767- 2.B 1,364,320- 97.2 38,767 - 2.8 1,364,320- 97.2 6,296 43.7 14,400 56.3 168 11.2 1,500 88.8 25 1.3 2,000 98.8 5,827- 25.4- 22,900 125.4 662 1.6 40,800 98.4 22,943 44.5 51,500 55.5 4,315- 61.6- 7,000 161.6 18,628 31.8 58,500 68.2 92- .4- 21,000 100.4 49,373- 9.9- 500,200 109.9 0 .0 0 .0 49,465- 9.5- 521,200 109.5 26,722- 27.8- 96,000 127.8 26,722- 27.8- 96,000 127.8 112,711- 38.5- 293,000 138.5 11,504 8.8 130,000 91.2 1,500 100.0 1,500 .0 37 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 13 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY ------------------------------- DISTRICT- PERIOD ENDING: k/13----------------------------------------------------- DEPARTMENT 02 ENGINEERING - - - - -- - ---------- - - - - -b OBS ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO -- ------- ACCOUNT TITLE ------- - --- -- - ------------ BUDGET -- ---- ACTUAL --- -- -- ------- VARIANCE --- --- -- -- % - -- -- --- BUDGET ---- -- ------- ACTUAL ------ - ------------------------------------ VARIANCE % BUDGET ; OUTSIDE SERVICES 37,049 25,366 11,683 31.5 424,500 524,207 99,707- 23.5- 424,500 123.5 1101 OFFICE EQUIPMENT /SUPPLIES 2,274 576 1,698 74.7 27,200 37,378 10,178- 37.4- 27,200 137.4 1103 OPERATING SUPPLIES 9,704 9,443 261 2.7 116,250 127,340 11,090- 9.5- 116,250 109.5 1106 SAFETY SUPPLIES 1,340 226 1,114 83.1 15,750 11,653 4,097 26.0 15,750 74.0 MATERIALS & SUPPLIES 13,318 10,245 3,073 23.1 159,200 176,371 17,171- 10.8- 159,200 110.8 1201 RENTS & LEASES 661 0 661 100.0 7,800 7,563 237 3.0 7,800 97,0 1202 PUBLIC AGENCY FEES 424 0 424 100.0 5,000 8,459 3,459- 69.2- 5,000 169.2 1203 PUBLIC INFORMATION 935 0 935 100.0 11,000 54 10,946 99.5 11,000 .5 1204 TUITION REIMBURSEMENT 911 0 911 100.0 10,800 3,136 7;664 71.0 10,800 29.0 1205 TECH TRAIN, CONF & MEETS 6,061 2,087 3,974 65.6 74,590 65,131 9,459 12.7 74,590 87.3 1206 CERTIFICATION & LICENSES 143 0 143 100.0 1,595 547 1,048 65.7 1,595 34.3 1208 SUBSCRIPTION /PUBLICATION 1,316 70 1,246 94.7 15,638 9,619 6,019 38.5 15,638 61.5 1209 MILEAGE REIMBURSEMENTS 110 0 110 100.0 1,100 1,800 700- 63.6- 1,100 163.6 1210 PUBLIC NOTICES 436 2,206 1,770- 406.0- 5,100 5,262 162- 3.2- 5,100 103.2 1211 OUTSIDE ORGANIZATION FEES 637 0 637 100.0 18,950 21,528 2,578- 13.6- 18,950 113.6 1212 EMPLOYEE MEMBERSHIPS 719 239 480 66.8 8,419 6,566 1,853 22.0 8,419 78.0 1213 MISCELLANEOUS 553 0 553 100.0 6,350 2,615 3,735 58.8 6,350 41.2 1216 PROFESSIONAL EXP REIMB 250 0 250 100.0 3,000 0 3,000 100.0 3,000 .0 OTHER EXPENSES 13,156 4,602 8,554 65.0 169,342 132,280 37,062 21.9 169,342 78.1 0200 ENVIRONMENTAL SERVICES 657,347 148,556 508,791 77.4 6,915,704 7,562,961 647,257- 9.4- 6,915,704 109.4 MR. PREPARED 8/06113, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 14 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: - - QI a //�----------------------------------------------------- ------------------------------------------------------------ - - -- / DEPARTMENT 02 ENGINEERING OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------------- YEAR -TO- DATE--------------- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE BUDGET ACTUAL VARIANCE % BUDGET 0101 SALARIES & WAGES- MGMNT. 0102 SALARIES & WAGES -NON MGMT 0103 SALARIES & WAGES -COMP ABS 0105 OVERTIME 0110 SALARY VACANCY SALARIES & WAGES 0201 WORKERS' COMPENSATION INS 0203 FEDERAL MEDICARE TAX 0204 MEDICAL & HEALTH INSUR 0205 RETIREMENT CONTRIBUTION 0206 DEFERRED COMP. CONTRIB 0207 DENTAL INSURANCE 0208 LONG -TERM DISABILITY INS 0209 LIFE INSURANCE 0212 BENEFIT VACANCY EMPLOYEE BENEFITS 0250 CAPITALIZED ADM OVERHEAD CAPITALIZED ADM OVERHEAD 0505 TELEPHONE UTILITIES 0604 OUTSIDE REPAIRS & MAINT. 0605 COMPUTER REPAIRS & MAINT REPAIRS & MAINTENANCE 0803 LEGAL SERVICES -STAFF PROFESSIONAL & LEGAL SERV 0902 TECHNICAL SERVICES 0905 REPROGRAPHIC SERVICES OUTSIDE SERVICES 1101 OFFICE EQUIPMENT /SUPPLIES 1103 OPERATING SUPPLIES 1106 SAFETY SUPPLIES MATERIALS & SUPPLIES 1201 RENTS & LEASES 1204 TUITION REIMBURSEMENT 7,025 0 7,025 100.0 84,256 73,439 138,577 0 138,577 100.0 1,662,781 1,503,065 0 0 0 .0 0 11,538 924 0 924 100.0 11,000 1,046 4,337- 0 4,337 -100.0 52,000- 0 142,189 0 142,189 100.0 1,706,037 1,589,088 434 0 434 100.0 5,032 3,097 2,100 0 2,100 100.0 25,112 22,409 30,345 0 30,345 100.0 363,931 310,324 82,902 0 82,902 100.0 994,681 854,277 8,242 0 8,242 100.0 98,651 87,919 2,810 0 2,810 100.0 33,621 33,550 439 0 439 100.0 5,191 3,958 777 0 777 100.0 9,082 4,269 5,087- 0 5,087 -100.0 61,000- 0 122,962 0 122,962 100.0 1,474,301 1,319,803 177,169- 0 177,169 -100.0 2,125,874- 1,929,895- 177,169- 0 177,169 -100.0 2,125,874- 1,929,895- 2,399 2,067 332 13.8 28,700 27,284 2,399 2,067 332 13.8 28,700 27,284 55 0 55 100.0 550 910 3,749 0 3,749 100.0 44,911 40,740 3,804 0 3,804 100.0 45,461 41,650 12 0 12 100.0 100 0 12 0 12 100.0 100 0 1,761 752 1,009 57.3 21,000 10,508 99 0 99 100.0 1,100 0 1,860 752 1,108 59.6 22,100 10,508 2,404 512 1,892 78.7 28,760 15,697 87 0 87 100.0 11000 9,433 354 623 269- 76.0- 4,050 2,435 2,845 1,135 1,710 60.1 33,810 27,565 12 0 12 100.0 100 0 2,174 0 2,174 100.0 8,000 0 10,817 12.8 159,716 9.6 11,538- .0 9,954 90.5 52,000 -100.0 116,949 6 -9 1,935 38.5 2,703 10.8 53,607 14.7 140,404 14.1 10,732 10.9 71 .2 1,233 23.8 4,813 53.0 61,000 -100.0 154.498 10.5 195,979- 9.2 195,979- 9.2 1,416 4.9 1,416 4.9 360- 65.5- 4,171 9.3 3,811 8.4 100 100.0 100 100.0 10,492 50.0 1,100 100.0 11,592 52.5 13,063 45.4 8,433-843.3- 1.615 39.9 6,245 18.5 100 100.0 8,000 100.0 84,256 87.2 1,662,781 90.4 0 .0 11,000 9.5 52,000- 0 1,706,037 93.1 5,032 61.5 25,112 89.2 363,931 85.3 994,681 85.9 98,651 89.1 33,621 99.8 5,191 76.2 9,082 47.0 61,000- .0 1.474.301 89.5 2,125,874- 90.8 2,125,874- 90.8 28,700 95.1 28,700 95.1 550 165.5 44,911 90.7 45,461 91.6 100 .0 100 .0 21,000 50.0 1,100 .0 22,100 47.5 28,760 54.6 1,000 943.3 4,050 60.1 33,810 81.5 100 .0 8.000 .0 39 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 15 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL, CONTRA COSTA SANITARY - --- - ------------------ DISTRICT PERIOD ENDING: - /jO/ / -j --------- DEPARTMENT 02 ENGINEERING -- ---------- ---- - ----- - -- - - --- -- -6 -------- -- --------- --- ------- ---- -- - --- - -- -- - OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET 1205 TECH TRAIN, CONF & MEETS 5,102 2,439 2,663 52.2 61,070 25,933 35,137 57.5 61,070 42.5 1206 CERTIFICATION & LICENSES 125 0 125 100.0 1,500 460 1,040 69.3 1,500 30.7 1208 SUBSCRIPTION /PUBLICATION 431 30 401 93.0 4,875 1,517 3,358 68.9 4,875 31.1 1209 MILEAGE REIMBURSEMENTS 49 0 49 100.0 390 169 221 56.7 390 43.3 1211 OUTSIDE ORGANIZATION FEES 31 0 31 100.0 350 0 350 100.0 350 .0 1212 EMPLOYEE MEMBERSHIPS 249 350 101- 40.6- 2,790 3,313 S23- 18.7- 2,790 118.7 1213 MISCELLANEOUS 417 0 417 100,0 4,850 584 4,266 88.0 4,850 12.0 1216 PROFESSIONAL EXP REIMS 212 0 212 100.0 2,500 0 2,500 100.0 2,500 .0 OTHER EXPENSES 8,802 2,819 5,983 68.0 86,425 31,976 54,449 63.0 86,425 37.0 0250 CAPITAL PROJECTS 107,704 6,773 100,931 93.7 1,271,060 1,117,979 153,081 12.0 1,271,060 88.0 oyo PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 16 PROGRAM /GM279L RUNNING EXPENSE 13 FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: - (v o /��----------------------------------------------------- -- -------- -- -- -- ------ ---- ---- ------ --- --- ---- -- ----- -- ------ - DEPARTMENT 02 ENGINEERING OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- ----- --- - - - - -- YEAR -TO- DATE -------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE BUDGET ACTUAL VARIANCE % BUDGET $ -- ---- -------- - - -- ------ ---- ---- ------- - --- ----- - --- --- ------ - - - ------- -- -- --- - -- -- -- ----- --------- ------ -- -- ------- -- - - -- DEPARTMENT NET EXPENSES 765,051 155,329 609,722 79.7 8,186,764 8,680;940 494,176- 6.0- 8,186,764 106.0 8 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 17 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - ----- PERIOD ENDING: J/ 911-3 - - ---- - - --- --- ---- ----------- DEPARTMENT 03 COLLECTION SYSTEM ---' OPS. - - _- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ------- ACCOUNT TITLE ------ -- -- -- ----- -------- BUDGET ------ - -------------------- ACTUAL VARIANCE -- ---- $ ----- ---- BUDGET -- ---- -- --- ACTUAL - ---- - - - -- - VARIANCE --------------------------------- BUDGET $ 0101 SALARIES & WAGES- MGMNT, 16,368 0 16,368 100.0 196,361 291,974 95,613- 48.7- 196,361 148.7 0102 SALARIES & WAGES- NON -MGMT 64,456 0 64,456 100.0 773,230 833,791 60,561- 7.8- 773,230 107.8 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 8,152 8,152- .0 0 _0 0105 OVERTIME 3,062 0 3,062 100.0 36,403 20,605 15,798 43.4 36,403 56.6 0106 STANDBY PAID 0 0 0 _0 0 0 0 .0 0 .0 0110 SALARY VACANCY 11,424- 0 11,424 -100.0 137,000- 0 137,000 -100.0 137,000- .0 SALARIES & WAGES 72,462 0 72,462 100.0 868,994 1,154,522 285,528- 32.9- 868,994 132.9 0201 WORKERS' COMPENSATION INS 1,517 0 1,517 100.0 17,962 16,712 1,250 7.0 17,962 93.0 0203 FEDERAL MEDICARE TAX 987 0 987 100,0 11,580 13,667 2,087- 18.0- 11,580 118.0 0204 MEDICAL & HEALTH INSUR 16,897 0 16,897 100.0 202,313 206,862 4,549- 2.2- 202,313 102.2 0205 RETIREMENT CONTRIBUTION 48,292 0 48,292 100.0 579,251 658,195 78,944- 13.6- 579,251 113.6 0206 DEFERRED COMP. CONTRIB 4,811 0 4,811 100.0 57,457 69,282 11,825- 20.6- 57,457 120.6 0207 DENTAL INSURANCE 1,482 0 1,482 100.0 17,399 21,641 4,242- 24.4- 17,399 124.4 0208 LONG -TERM DISABILITY INS 233 0 233 100.0 2,631 2,570 61 2.3 2,631 97.7 0209 LIFE INSURANCE 521 0 521 100.0 5,933 4,188 1,745 29.4 5,933 70.6 0212 BENEFIT VACANCY 15,000- 0 15,000 -100.0 180,000- 0 180,000 -100.0 180,000- .0 EMPLOYEE BENEFITS 59,740 0 59,740 100.0 714,526 993,117 278,591- 39.0- 714,526 139.0 0250 CAPITALIZED ADM OVERHEAD 7,112- 0 7,112 -100.0 85,344- 25,717- 59,627- 69.9 85,344- 30.1 CAPITALIZED ADM OVERHEAD 7,112- 0 7,112 -100.0 85,344- 25,717- 59,627- 69.9 85,344- 30.1 0501 ELECTRICAL 4,674 6,279 1,605- 34.3- 56,000 61,043 5,043- 9.0- 56,000 109.0 0502 NATURAL GAS 11500 336 1,164 77.6 18,000 9,308 8,692 4B.3 18,000 51.7 0504 WATER - 674 0 674 100.0 8,000 12,843 4,843- 60.5- 8,000 160.5 0505 TELEPHONE 3,750 4,343 593- 15.8- 45,000 53,194 8,194- 18.2- 45,000 118.2 UTILITIES 10,598 10,958 360- 3.4- 127,000 136,388 9,388- 7.4- 127,000 107.4 0601 OUTSIDE VEH /EQUIP REPAIR 9,693 4,109 5,584 57.6 116,250 70,760 45,490 39.1 116,250 60.9 0602 VEHIC /EQUIP REPAIR MAINT 7,500 4,941 2,559 34.1 90,000 122,601 32,601- 36.2- 90,000 136.2 0603 GENERAL REPAIRS & MAINT 250 0 250 100.0 3,000 216 2,784 92.8 3,000 7.2 0604 OUTSIDE REPAIRS & MAINT. 3,223 0 3,223 100.0 38,500 17,484 21,016 54.6 38,500 45.4 REPAIRS & MAINTENANCE 20,666 9,050 11,616 56.2 247,750 211,061 36,689 14.8 247,750 85.2 0704 JANITORIAL & REFUSE REMOV 5,036 0 5,036 100.0 60,300 80,270 19,970- 33.1- 60,300 133.1 HAULING & DISPOSAL 5,036 0 5,036 100.0 60,300 80,270 19,970- 33.1- 60,300 133.1 0803 LEGAL SERVICES -STAFF 837 428 409 48.9 10,000 2,036 7,964 79.6 10,000 20.4 PROFESSIONAL & LEGAL SERV 837 428 409 48.9 10,000 2,036 7,964 79.6 10,000 20.4 0901 OUTSIDE SAFETY SERVICES 337 0 337 100.0 4,000 8,569 4,569- 114.2- 4,000 214.2 0902 TECHNICAL SERVICES 5,026 12,000 6,974- 138.8- 60,070 42,493 17,577 29.3 60,070 70.7 0905 REPROGRAPHIC SERVICES 12 0 12 100.0 100 0 100 100.0 100 .0 42 PREPARED 8/06/13, 13 :48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 18 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT ----- - - --- --- -- - - PERIOD ENDING: 11h ✓ O�/ 1 - -- - ------ DEPARTMENT 03 COLLECTION SYSTEM ----- ------ CPS. - - ----- - ----- -- - -- -- - - -_ - - - -- - - - -- ------------------------------------------ OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ------- ------- -- ----------- ---- BUDGET - - - --- - ------------- ACTUAL ----------- VARIANCE ------ % ------- BUDGET ---- --- - ACTUAL ----------------------------------------------- VARIANCE % BUDGET s OUTSIDE SERVICES - 5,375 12,000 6,625- 123.3- 64,170 51,062 13,108 20.4 64,170 79.6 1101 OFFICE EQUIPMENT /SUPPLIES 886 0 886 100.0 10,500 8,353 2,147 20.4 10,500 79.6 1102 GASOLINE, OIL & FUEL 21,456 12,111 9,345 43.6 257,450 306,140 48,690- 18.9- 257,450 118.9 1103 OPERATING SUPPLIES 2,547 5,243 2,696- 105.9- 30,300 50,178 19,878- 65.6- 30,300 165.6 1106 SAFETY SUPPLIES 3,797 819 2,978 78.4 41,220 26,376 14,844 36.0 41,220 64.0 MATERIALS & SUPPLIES 28,686 18,173 10,513 36.6 339,470 391,047 51,577- 15.2- 339,470 115.2 1201 RENTS & LEASES 8,866 65 8,801 99.3 106,150 85,790 20,360 19.2 106,150 80.8 1202 PUBLIC AGENCY FEES 250 80 170 68.0 14,250 14,962 712- 5.0- 14,250 105.0 1204 TUITION REIMBURSEMENT 174 0 174 100.0 2,000 1,299 701 35.1 2,000 65.0 1205 TECH TRAIN, CONF & MEETS 3,453 3,316 137 4.0 41,370 42,622 1,252- 3.0- 41,370 103.0 1206 CERTIFICATION & LICENSES 417 0 417 100.0 _4,883 5,241 358- 7.3- 4,883 107.3 1207 CLAIMS 12 0 12 100.0 100 0 100 100.0 100 .0 1208 SUBSCRIPTION /PUBLICATION 62 0 62 100.0 700 905 205- 29.3- 700 129.3 1209 MILEAGE REIMBURSEMENTS 75 0 75 100.0 900 1,585 685- 76.1- 900 176.1 1212 EMPLOYEE MEMBERSHIPS 618 0 618 100.0 7,229 7,455 226- 3.1- 7,229 103.1 1213 MISCELLANEOUS 212 54 158 74.5 2,500 2,264 236 9.4 2,500 90.6 1216 PROFESSIONAL EXP REIMB 250 0 250 100.0 3,000 1,787 1,213 40.4 3,000 59.6 OTHER EXPENSES 14,389 3,5.15 10,874 75.6 183,082 163,910 19,172 10.5 183,082 89.5 0300 OPERATIONS SUPPORT 210,677 54,124 156,553 74.3 2,529,948 3,157,696 627,748- 24.8- 2,529,948 124.8 D-3 ( PREPARED B/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 19 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -- - -- ------ --------- --- ---- PERIOD ENDING: 6130 .3 --- ------ DEPARTMENT 03 COLLECTION SYSTEM - ---- ------ OPS_ -- -- -- - -- -- - - -- -- -------------------- ---- ---- -- -- ------- ---- --- ----- -- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ------------------------------------------------- BUDGET ACTUAL -- --- VARIANCE --- ----- --- ---- % --- BUDGET -- - --- -- - ---- ACTUAL - --- ---- ------- VARIANCE - -- -- -- % - --------------- BUDGET - - -- -- 0102 SALARIES & WAGES -NON MGMT 300,621 0 300,621 100.0 3,607,045 3,588,040 19,005 .5 3,607,045 99.5 0103 SALARIES & WAGES COMP ABS 0 0 0 .0 0 0 0 _0 0 .0 0105 OVERTIME 15,965 0 15,965 100.0 191,173 271,965 80,792- 42.3- 191,173 142.3 0106 STANDBY PAID 5,500 0 5,500 100.0 66,000 59,895 6,105 9.3 66,000 90.8 SALARIES & WAGES 322,086 0 322,086 100.0 3,864,218 3,919,900 55,682- 1.4- 3,864,218 101.4 0201 WORKERS, COMPENSATION INS 10,174 0 10,174 100.0 121,615 85,971 35,644 29.3 121,615 70.7 0203 FEDERAL MEDICARE TAX 4,359 0 4,359 100.0 52,044 54,794 2,750- 5.3- 52,044 105.3 0204 MEDICAL & HEALTH INSUR 78,011 0 78,011 100.0 935,868 861,646 74,222 7.9 935,868 92.1 0205 RETIREMENT CONTRIBUTION 179,252 0 179,252 100.0 2,150,760 2,014,133 136,627 6.4 2,150,760 93.6 0206 DEFERRED COMP. CONTRIB 18,880 0 18,880 100.0 226,274 239,950 13,676- 6.0- 226,274 106.0 0207 DENTAL INSURANCE 7,172 0 7,172 100.0 85,899 97,988 12,089- 14 -1- 85,899 114.1 0208 LONG -TERM DISABILITY INS 1,075 0 1,075 100.0 12,548 12,105 443 3.5 12,548 96.5 0209 LIFE INSURANCE 1,425 0 1,425 100,0 16,891 6,131 10,760 63.7 16,891 36.3 EMPLOYEE BENEFITS 300,348 0 300,348 100.0 3,601,899 3,372,716 229,181 6.4 3,601,899 93.6 0250 CAPITALIZED ADM OVERHEAD 1,.909- 0 1,909 -100.0 22,820- 24,161- 1,341 5.9- 22,820 -105.9 CAPITALIZED ADM OVERHEAD 11909- 0 1,909 -100.0 2.2,820- 24,161- 1,341 5.9- 22,820 -105.9 0604 OUTSIDE REPAIRS & MAINT 38,873 146,430 107,557 - 276.7- 466,300 411,940 54,360 11.7 466,300 B8.3 REPAIRS & MAINTENANCE 38,873 146,430 107,557- 276.7- 466,300 411,940 54,360 11.7 466,300. 88.3 yy 0705 SPOILS REMOVAL 2,500 0 2,500 100.0 30,000 29,518 482 1.6 30,000 98.4 HAULING & DISPOSAL 2,500 0 2,500 100.0 30,000 29,518 482 1.6 30,000 98.4 0902 TECHNICAL SERVICES 2,686 0 2,686 100.0 32,100 7,168 24,932 77.7 32,100 22.3 OUTSIDE SERVICES 2,666 0 2,686 100.0 32,100 7,168 24,932 77.7 32,100 22.3 1103 OPERATING SUPPLIES 31,210 24,124 7,OB6 22.7 374,300 393,009 18,709- 5.0- 374,300 105.0 MATERIALS & SUPPLIES 31,210 24,124 7,086 22.7 374,300 393,009 18,709- 5.0- 374,300 105.0 1201 RENTS & LEASES 973 0 973 100.0 11,500 1,786 9,714 84.5 11,500 15.5 1202 PUBLIC AGENCY FEES 1,500 0 1,500 100.0 18,000 9,087 8,913 49.5 18,000 50.5 OTHER EXPENSES 2,473 0 2,473 100.0 29,500 10,873 18,627 63.1 29,500 36.9 0310 FIELD OPERATIONS 698,267 170,554 527,713 75.6 8,375,497 8,120,965 254,532 3.0 8,375,497 97.0 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 20 PROGRAM /GM279L RUNNING EXPEN.SR FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: G.�] O�`? X77 •7 --- -- ---- ------------------------------ --- DEPARTMENT 03 COLLECTION SYSTEM OPS. -------- ------- ------- -- ' -- -- ----------------------------------------------------- OBJ ----- - - - - -- -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET -----------------------------------------------------------------`-------------------------------------------------------- ACTUAL VARIANCE s BUDGET ACTUAL VARIANCE % BUDGET $ DEPARTMENT NET EXPENSES 908,944 224,678 684,266 75.3 10,905,445 11,278,661 373,216- 3.4- 10,905,445 103.4 YS PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 21 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT --------------------- PERIOD ENDINGc �/� O / /�---------------- - -- --- -- DEPARTMENT 04 PLANT OPERATIONS -- ---- ----- - --- - - - - -- ------------------------------ OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE -------- - - - - -- ANNUAL NO ACCOUNT TITLE ---- --- -- ---- - - -- -- - --- ------- BUDGET ------ -- - --- ACTUAL -- --------------- VARIANCE ---- % -- -- --- ----- BUDGET ---- --- - - ACTUAL - - -- - --- - ---- VARIANCE ---- --- % ---- - - - -- BUDGET - ---- - % - - -- -- 0101 SALARIES & WAGES- MGMNT. 27,767 0 27,767 100.0 333,083 146,553 186,530 56.0 333,083 44.0 0102 SALARIES & WAGES -NON MGMT 16,927 0 16,927 100.0 203,014 258,182 55,168- 27.2- 203,014 127.2 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 18,693 18,693- .0 0 .0 0105 OVERTIME 57 0 57 100.0 673 5.57 116 17.2 673 82.8 0106 STANDBY PAID 0 0 0 .0 0 0 0 .0 0 .0 0110 SALARY VACANCY 20,587- 0 20,587 -100.0 247,000- 0 247,000 -100.0 247,000- .0 SALARIES & WAGES 24,164 0 24,164 100.0 289,770 429,985 134,215- 46.3- 289,770 146.3 0201 WORKERS COMPENSATION INS 570 0 570 100.0 6,807 6,941 134- 2.0- 6,807 102.0 0203 FEDERAL MEDICARE TAX 648 0 648 100.0 7,644 7,492 152 2.0 7,644 98.0 0204 MEDICAL & HEALTH INSUR 7,144 0 7,144 100.0 85,596 62,852 22,744 26.6 85,596 73.4 0205 RETIREMENT CONTRIBUTION 26,807 0 26,807 100.0 321,662 189,269 132,393 41.2 321,662 58.8 0206 DEFERRED COMP. CONTRIB 2,153 0 2,153 100.0 25,649 19,981 5,668 22.1 25,649 77.9 0207 DENTAL INSURANCE 828 0 828 100.0 9,782 10,998 1,216- 12.4- 9,782 112.4 0208 LONG -TERM DISABILITY INS 62 0 62 100.0 722 859 137- 19.0- 722 119.0 0209 LIFE INSURANCE 424 0 424 100.0 4,956 1,787 3,169 63.9 4,956 36.1 0212 BENEFIT VACANCY 25,500- 0 25,500 -100.0 306,000- 0 306,000 -100.0 306,000- .0 EMPLOYEE BENEFITS 13,136 0 13,136 100.0 156,818 300,179 143,361- 91.4- 156,818 191.4 0250 CAPITALIZED ADM OVERHEAD 411- 0 411 -100.0 4,844- 0 4,844 -100.0 4,844- .0 CAPITALIZED ADM OVERHEAD 411- 0 411 -100.0 4,844- 0 4,844 -100.0 4,844- .0 0505 TELEPHONE 4,549 4,630 81- 1.8- 54,500 55,763 1,263- 2.3- 54,500 102.3 UTILITIES 4,549 4,630 81- 1.8- 54,500 55,763 1,263- 2.3- 54,500 102.3 0603 GENERAL REPAIRS & MAINT 87 0 87 100.0 1,000 0 11000 100.0 1,000 .0 0604 OUTSIDE REPAIRS & MAINT 2,223 3,926 1,703- 76.6- 26,500 14,804 11,696 44.1 26,500 55.9 REPAIRS & MAINTENANCE 2,310 3,926 1,616- 70.0- 27,500 14,804 12,696 46.2 27,500 53.8 0704 JANITORIAL & REFUSE REMOV 87 0 87 100.0 1,000 0 1,000 100.0 1,000 .0 0706 HAZARDOUS WASTE DISPOSAL 837 0 837 100.0 10,000 891 9,109 91.1 10,000 819 HAULING & DISPOSAL 924 0 924 100.0 11,000 891 10,109 91.9 11,000 8.1 0803 LEGAL SERVICES -STAFF 4,174 334 3,840 92.0 50,000 3,307 46,693 93.4 50,000 6.6 PROFESSIONAL & LEGAL SERV 4,174 334 3,840 92.0 50,000 3,307 46,693 93.4 50,000 6.6 0901 OUTSIDE SAFETY SERVICES 1,424 0 1,424 100.0 17,000 15,889 1,111 6.5 17,000 93.5 0902 TECHNICAL SERVICES 14,674 10,905 3,769 25.7 176,000 36,120 139,880 79.5 176,000 20.5 OUTSIDE SERVICES 16,098 10,905 5,193 32.3 193,000 52,009 140,991 73.1 193,000 26.9 1101 OFFICE EQUIPMENT /SUPPLIES 1,250 192 1,058 84.6 15,000 19,642 4,642- 30.9- 15,000 130.9 1103 OPERATING SUPPLIES 87 0 87 100.0 1,000 227 773 77.3 1,000 22.7 V� PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 22 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY ----------- DISTRICT PERIOD ENDING: 0 ---------------------- DEPARTMENT 04 PLANT OPERATIONS - - - - -- - - - - - -- - ---------------------------------------------------- OBJ -- -- ------ ---MONTH- TO-DATE- ------ - - - --- -------------- YEAR.-TO-DATE -------------- ANNUAL NO ACCOUNT TITLE -- --- ---- --------- - - - --- --------- BUDGET ---- -- -------- ACTUAL -- ----- VARIANCE -- -- - ----- % - ------ BUDGET ------ --- ------ ACTUAL ---- -- --- ------ VARIANCE - ---- % - - - -- BUDGET --- - -- ---- °s - ---- 1106 SAFETY SUPPLIES 874 3 871 99.7 10,400 20,434 10,034- 96.5- 10,400 196.5 MATERIALS & SUPPLIES 2,211 195 2,016 91.2 26,400 40,303 13,903- 52.7- 26,400 152.7 1201 RENTS & LEASES 136 0 136 100.0 1,500 0 1,500 100.0 1,500 .0 1202 PUBLIC AGENCY FEES 15,399 0 15,399 100.0 357,200 339,624 17,576 4.9 357,200 95.1 1204 TUITION REIMBURSEMENT 837 154 683 81.6 10,000 1,969 8,031 80.3 10,000 19.7 1205 TECH TRAIN, CONF & MEETS 649 1,057 408- 62.9- 8,200 3,240 4,960 60.5 8,200 39.5 1206 CERTIFICATION & LICENSES 728 758 30- 4.1- 8,703 6,551 2,152 24.7 8,703 75.3 1208 SUBSCRIPTION /PUBLICATION 92 0 92 100.0 950 0 950 1.00.0 950 .0 1209 MILEAGE REIMBURSEMENTS 49 0 49 100.0 500 322 178 35.6 500 64.4 1211 OUTSIDE ORGANIZATION FEES 18,712 0 18,712 100.0 224,500 204,505 19,995 8.9 224,500 91.1 1212 EMPLOYEE MEMBERSHIPS 62 0 62 100.0 700 493 207 29.6 - 700 70.4 1213 MISCELLANEOUS 136 130 6 4.4 1,500 1,177 323 21.5 1,500 78.5 1216 PROFESSIONAL EXP REIMB 1,250 0 1,250 100.0 15,000 0 15,000 100.0 15,000 .0 OTHER EXPENSES 38,050 2,099 35,951 94.5 628,753 557,881 70,872 11.3 628,753 88.7 0400 MANAGEMENT 105,205 22,089 83,116 79.0 1,432,897 1,449,122 16,225- 1.1- 1,432,897 101.1 y7 I PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 23 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT --- -------- ---- PERIOD ENDING: b/3 O/I ----------- -- ------- DEPARTMENT 04 PLANT OPERATIONS - `-- --- -- - --- --- ------------- ..................................................... OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE %- BUDGET ACTUAL VARIANCE BUDGET % 0102 SALARIES & WAGES -NON MGMT 371,998 0 371,998 100.0 4,463,811 4,317,799 146,012 3.3 4,463,811 96.7 0103 SALARIES & WAGES -COMP ABS 0 0 0 .0 0 975 975- .0 0 .0 0105 OVERTIME 26,565 0 26,565 100.0 318,417 301,664 16,753 5.3 318,417 94.7 0106 STANDBY PAID 0 0 0 .0 0 0 0 .0 0 .0 SALARIES & WAGES 398,563 0 398,563 100.0 4,782,228 4,620,438 161,790 3.4 4,782,228 96.6 0201 WORKERS' COMPENSATION INS 10,639 0 10,639 100.0 127,393 85,232 42,161 33.1 127,393 66.9 0203 FEDERAL MEDICARE TAX 5,573 0 5,573 100.0 66,755 65,285 1,470 2.2 66,755 97.8 0204 MEDICAL & HEALTH INSUR 81,384 0 81,384 100.0 976,498 829,539 146,959 15.0 976,498 85.0 0205 RETIREMENT CONTRIBUTION 214,217 0 214,217 100.0 2,570,263 2,376,529 193,734 7.5 2,570,263 92.5 0206 DEFERRED COMP. CONTRIB 22,545 0 22,545 100.0 270,364 258,045 12,319 4.6 270.,364 95.4 0207 DENTAL INSURANCE 7,432 0 7,432 100.0 88,920 88,797 123 .1 88,920 99.9 0208 LONG -TERM DISABILITY INS 1,172 0 1,172 100.0 13,.800 12,490 1,310 9.5 13,800 90.5 0209 LIFE INSURANCE 1,689 0 1,689 100.0 19,971 12,168 7,783 39.0 19,971 61.0 0211 ACCRUED COMPENSATED ABS 0 0 0 .0 0 0 0 .0 0 .0 EMPLOYEE BENEFITS 344,651 0 344,651 100.0 4,133,964 3,728,105 405,859 9.8 4,133,964 90.2 0250 CAPITALIZED ADM OVERHEAD 3,182- 0 3,182 -100.0 38,151- 87,.639- 49,488 129.7- 38,151 -229.7 CAPITALIZED ADM OVERHEAD 3,182- 0 3,182 -100.0 38,151- 87,639- 49,488 129.7- 38,151 -229.7 0402 LIME 17,174 19,618 2,444- 14.2- 206,000 352,796 146,796- 71.3- 206,000 171.3 0403 POLYMER 40,424 56,573 16,149- 39.9- 485,000 495,530 10,530- 2.2- 485,000 102.2 0404 BOILER CHEMICALS 4,837 0 4,837 100.0 58,000 43,561 14,439 24.9 58,000 75.1 0406 OTHER CHEMICALS 10,337 0 10,337 100.0 124,000 61,908 62,092 50.1 124,000 49.9 0407 HYPOCHLORITE 25,674 20,985 4,689 18.3 308,000 190,880 117,120 38.0 308,000 62.0 CHEMICALS 98,446 97,176 1,270 1.3 1,181,000 1,144,675 36,325 3.1 1,181,000 96.9 0501 ELECTRICAL 30,261 907,150- 937,411 97.8 363,000 268,002 94,998 26.2 363,000 73.8 0502 NATURAL GAS 343,340 3,892 339,448 98.9 2,060,000 2,196,302 136,302- 6.6- 2,060,000 106.6 0503 LAND -FILL GAS 39,587 39,201 386 1.0 475,000 443,535 31,465 6.6 475,000 93.4 0504 WATER 5,000 62 4,938 98.8 60,000 49,746 10,254 17.1 60,000 82.9 UTILITIES 418,188 863,995- 1,282,183 306.6 2,958,000 2,957,585 415 .0 2,.958,000 100.0 0603 GENERAL REPAIRS & MAINT 1,424 0 1,424 100.0 17,000 4,448 12,552 73.8 17,000 26.2 0604 OUTSIDE REPAIRS & MAINT 4,348 298 4,050 93.1 52,000 25,570 26,430 50.8 52,000 49.2 0605 COMPUTER REPAIRS & MAINT 3,348 0 3,348 100.0 40,000 32,181 7,819 19.5 40,000 80.5 REPAIRS & MAINTENANCE 9,120 298 8,822 96.7 109,000 62.,199 46,801 42.9 109,000 57.1 0701 ASH REMOVAL 13,337 0 13,337 100.0 160,000 136,237 23,763 14.9 160,000 85.1 0702 SLUDGE REMOVAL 837 0 837 100.0 10,000 0 10,000 100.0 10,000 .0 0703 GRIT REMOVAL 6,674 5,863 811 12.2 80,000 92,804 12,804- 16.0- 80,000 116.0 0704 JANITORIAL & REFUSE REMOV 4,000 1,383 2,617 65.4 48,000 47,613 387 .8 48,000 99.2 0706 HAZARDOUS WASTE DISPOSAL 87 0 87 100.0 1,000 358 642 64.2 1,000 35.8 HAULING & DISPOSAL 24,935 7,246 17,689 70.9 299,000 277,012 21,988 7.4 299,000 92.6 YS PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 24 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY ------ -- --------- -- - DISTRICT PERIOD- ENDING: 6 /]✓ /,� DEPARTMENT 04 PLANT OPERATIONS - - - - - -- - -- - - -- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ------- -- -- -- - ----- - -------------- BUDGET ---- ----- ACTUAL ----- ------- VARIANCE ---- - -- - % ---------- BUDGET `---- ------ ACTUAL - - - --- - ----- VARIANCE -- -- -- -- -- --- --- BUDGET --- `--- -- - - - - -- - 0902 TECHNICAL SERVICES 81,410 3,439 77,971 95.8 976,700 387,542 589,158 60.3 976,700 39.7 0905 REPROGRAPHIC SERVICES 87 0 87 100.0 1,000 0 1,000 100.0 1,000 .0 OUTSIDE SERVICES 81,497 3,439 78,058 95.8 977,700 387,542 590,158 60.4 977,700 39.6 1103 OPERATING SUPPLIES 10,772 5,131 5,641 52.4 129,000 114,104 14,896 11.5 129,000 88.5 1104 OPERATING FUEL 1,674 0 1,674 100.0 20,000 0 20,000 100.0 20,000 .0 1105 LABORATORY SUPPLIES 12,174 7,535 4,639 38.1 146,000 185,393 39,393- 27.0- 146,000 127.0 1106 SAFETY SUPPLIES 871 0 871 100.0 10,100 7,221 2,879 28.5 10,100 71.5 MATERIALS & SUPPLIES 25,491 12,666 12,825 50.3 305,100 306,118 1,618- .5- 305,100 100.5 1201 RENTS & LEASES 386 0 386 100.0 4,500 0 4,500 100.0 4,500 .0 1202 PUBLIC AGENCY FEES 875 0 875 100.0 10,500 10,255 245 2.3 10,500 97.7 1205 TECH TRAIN, CONF & MEETS 3,099 0 3,099 100.0 37,100 20,748 16,352 44.1 37,100 55.9 1206 CERTIFICATION & LICENSES 0 0 0 .0 0 0 0 .0 0 .0 1208 SUBSCRIPTION /PUBLICATION 224 0 224 100.0 2,600 479 2,121 81.6 2,600 18.4 1211 OUTSIDE ORGANIZATION FEES 424 0 424 100.0 5,000 0 5,000 100.0 5,000 . .0 1212 EMPLOYEE MEMBERSHIPS 517 788 271- 52.4- 6,138 3,592 2,546 41.5 6,138 58.5 1213 MISCELLANEOUS 263 0 263 100.0 3,080 257 2,823 91.7 3,080 8.3 OTHER EXPENSES 5,788 788 5,000 86.4 68,918 35,331 33,587 48.7 68,918 51.3 0420 OPERATIONS 1,403,497 742,382- 2,145,879 152.9 14,776,759 13,431,966 1,344,793 9.1 14,776,759 90.9 0 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 25 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -------------------------------------------------------------------- PERIOD ENDING: 6 O � DEPARTMENT 04 PLANT OPERATIONS - - -L3- ---3 ----------------------------------------------------- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET 0102 SALARIES & WAGES -NON MGMT 268,648 0 268,648 100.0 3,223,402 3,104,572 118,830 3.7 3,223,402 96.3 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 15,333 15,333- .0 0 .0 0105 OVERTIME 9,317 0 9,317 100.0 111,419 138,873 27,454- 24.6- 111,419 124.6 0106 STANDBY PAID 5,069 0 5,069 100.0 60,498 54,772 5,726 9.5 60,498 90.5 SALARIES & WAGES 283,034 0 283,034 100.0 3,395,319 3,313,550 81,769 2.4 3,395,319 97.6 0201 WORKERS' COMPENSATION INS 8,235 0 8,235 100..0 98,600 68,266 30,334 30.8 98,600 69.2 0203 FEDERAL MEDICARE TAX 3,742 0 3,742 100.0 44,640 47,476 2,836- 6.4- 44,640 106.4 0204 MEDICAL & HEALTH INSUR 59,723 0 59,723 100.0 716,280 607,543 108,737 15.2 716,280 84.8 0205 RETIREMENT CONTRIBUTION- 158,688 0 158,688 100.0 1,903,783 1,759,375 144,408 7.6 1,903,783 92.4 0206 DEFERRED COMP. CONTRIB 16,437 0 16,437 100.0 196,804 192,942 3,862 2.0 196,804 98.0 0207 DENTAL INSURANCE 5,353 0 5,353 100.0 63,994 62,363 1,631 2.5 63,994 97.5 0208 LONG -TERM DISABILITY INS 925 0 925 100.0 10,649 9,563 1,086 10.2 10,649 89.8 0209 LIFE INSURANCE 1,272 0 1,272 100.0 14,846 6,018 8,828 59.5 14,846 40.5 EMPLOYEE BENEFITS 254,375 0 254,375 100.0 3,049,596 2,753,546 296,050 9.7 3,049,596 90.3 0250 CAPITALIZED ADM OVERHEAD 5,053- 0 5,053 -100.0 60,394- 31,745- 28,649- 47.4 60,394- 52.6 CAPITALIZED ADM OVERHEAD 5,053- 0 5,053 -100.0 60,394- 31,745- 28,649- 47.4 60,394- 52.6 0603 GENERAL REPAIRS & MAINT 73,533 31,679 41,854 56.9 882,000 926,176 44,176- 5.0- 882,000 105.0 0604 OUTSIDE REPAIRS & MAINT 88,370 51,306 37,064 41.9 1,060,000 611,716 448,284 42.3 1,060,000 57.7 0605 COMPUTER REPAIRS & MAINT 0 0 0 .0 1,000 0 1,000 100.0 1,000 .0 REPAIRS & MAINTENANCE 161,903 82,985 78,918 48.7 1,943,000 1,537,892 405,108 20.8 1,943,000 79.2 0704 JANITORIAL & REFUSE REMOV 8,348 0 8,348 100.0 100,000 110,804 10,804- 10.B- 100,000 110.8 HAULING & DISPOSAL 8,348 0 8,348 100.0 100,000 110,804 10,804- 10.8- 100,000 110.8 0902 TECHNICAL SERVICES 9,859 4,990 4,869 49.4 118,000 24,761- 142,761 121.0 118,000 21.0- 0904 OTHER PUBLIC AGENCY SERVS 424 0 424 100.0 5,000 3,109 1,891 37.8 5,000 62.2 OUTSIDE SERVICES 10,283 4,990 5,293 51.5 123,000 21,652- 144,652 117.6 123,000 17.6- 1101 OFFICE EQUIPMENT /SUPPLIES 500 18 482 96.4 6,000 4,943 1,051 17.6 6,000 82.4 1103 OPERATING SUPPLIES 36,120 16,001 20,119 55.7 433,000 431,206 1,794 .4 433,000 99.6 1106 SAFETY SUPPLIES 894 195 699 78.2 10,200 7,670 2,530 24.8 10,200 75.2 MATERIALS & SUPPLIES 37,514 16,214 21,300 56.8 449,200 443,819 5,381 1.2 449,200 98.8 1201 RENTS & LEASES 3,647 0 3,649 100.0 43,500 34,998 8,502 19.5 43,500 80.5 1205 TECH TRAIN, CONF & MEETS 1,124 0 1,124 100.0 13,400 9,954 3,446 25.7 13,400 74.3 1208 SUBSCRIPTION /PUBLICATION ill 81 30 27.0 1,200 81 1,119 93.3 1,200 6.8 1212 EMPLOYEE MEMBERSHIPS 348 140 208 59.8 -4,000 3,608 392 9.8 4,000 90.2 1213 MISCELLANEOUS 136 0 136 100.0 1,500 7 1,493 99.5 1,500 .5 OTHER EXPENSES 5,366 221 5,145 95.9 63,600 48,648 14,952 23 -5 63,600 76.5 50 PREPARED 8106/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 26 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: / 3 13 - -- --------- ---- ---- ------- ----- - - --- --- ------- ----------- ----- - -- --- -- ------------- - ---- --- ----- -- - - --------------- ------ DEPARTMENT 04 PLANT OPERATIONS OBS ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET % -- -- ------- --- -- -- - ------------------ ------ --- -- ---- -- --- --- - - - - --- --------- ------- -------- ----- -- -- - ----- - -- ----- - ----- -- - - - --- 0440 MAINTENANCE 755,770 104,410 651,360 86.2 9,063,321 8,154,862 908,459 10.0 9,063,321 90.0 PREPARED 8/06/13, 13:48 :36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 27 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING_ 6/1 D113 ------------ --- --- --- -- ---- -- ---- --- - - - - --- -- ---- --- ---- ---- -- - -- — ---- -- --- ---------- -- — - - -- DEPARTMENT 04 PLANT OPERATIONS OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------------- YEAR- TO- DAT£-------------- ANNUAL NO ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET s - -- — -------------- ---- --- ----- ------------ - ---- -- ----------------------------- ----- ----- ------- ----- -- - - --- ------ - - -- -- --- - -- --- DEPARTMENT NET EXPENSES 2,264,472 615,883- 2,880,355 127.2 25,272,977 23,035,950 2,237,027 8.9 25,272,977 91.1 (�7-9 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 28 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013' CENTRAL CONTRA COSTA SANITARY DISTRICT --- -- --- PERIOD ENDING:-- & 3 O /'3 --- --- --- ---- - - - -- DEPARTMENT 05 PUMP STATIONS - -- ! ( - - ------------------------------------------- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE- -- - - -- - - - - -- ANNUAL NO ACCOUNT TITLE ---------------------------------------------------------- BUDGET ACTUAL VARIANCE ----- -- % ---- ---- BUDGET -- -- ---- - -- ACTUAL --------- ---- --- VARIANCE ---- --- % -- - - - - -- - BUDGET --- ----- s -- - - -- 0102 SALARIES & WAGES -NON MGMT 62,199 0 62,199 100.0 746,267 749,037 2,770- .4- 746,267 100.4 0103 SALARIES & WAGES -COMP ABS 0 0 0 .0 0 0 0 .0 0 .0 0105 OVERTIME 2,304 0 2,304 100.0 27,527 42,017 14,490- 52.6- 27,527 152.6 0106 STANDBY PAID 8,337 0 8,337 100.0 100,000 103,876 .3,876- 3.9- _ 100,000 103.9 0110 SALARY VACANCY 1,837- 0 1,837 -100.0 22,000- 0 22,000 -100.0 22,000- .0 SALARIES & WAGES 71,003 0 71,003 100.0 851,794 894,930 43,136- 5.1- 851,794 105.1 0201 WORKERS' COMPENSATION INS 2,100 0 2,100 100.0 25,156 18,077 7,079 28.1 25,156 71.9 0203 FEDERAL MEDICARE TAX 926 0 926 100.0 11,112 12,958 1,846- 16.6- 11,112 116.6 0204 MEDICAL & HEALTH INSUR 10,999 0 10,999 100.0 131,977 109,883 22,094 16.7 131,977 83.3 0205 RETIREMENT CONTRIBUTION 36,460 0 36,460 100.0 437,443 475,480 38,037- 8.7- 437,443 108.7 0206 DEFERRED COMP. CONTRIB 3,757 0 3,757 100.0 45,018 - 52,720 7,702- 17.1- 45,018 117.1 0207 DENTAL INSURANCE 1,072 0 1,072 100.0 12,820 12,737 83 .6 12,820 99.4 0208 LONG -TERM DISABILITY INS 216 0 216 100.0 2,471 2,371 100 4.0 2,471 96.0 0209 LIFE INSURANCE 286 0 286 100.0 3,366 1,921 1,445 42.9 3,366 57.1 0211 ACCRUED COMPENSATED ABS 0 0 0 .0 0 0 0 .0 0 .0 0212 BENEFIT VACANCY 2,250- 0 2,250 -100.0 27,000- 0 27,000 -100.0 27,000- .0 EMPLOYEE BENEFITS 53,566 0 53,566 100.0 642,363 686,147 43,784- 6.8- 642,363 106.8 0250 CAPITALIZED ADM OVERHEAD 470- 0 470 -100.0 5,563- 0 5,563 -100.0 5,563- .0 CAPITALIZED ADM OVERHEAD 470- 0 470 -100.0 5,563- 0 5,563 -100.0 5,563- .0 0406 OTHER CHEMICALS 33,337 13,515 19,822 59.5 400,000 430,279 30,279- 7.6- 400,000 107.6 v CHEMICALS 33,337 13,515 19,822 59.5 400,000 430,279 30,279- 7.6- 400,000 107.6 0501 ELECTRICAL 76,270 39,684 36,586 4B.0 457,600 424,421 33,179 7.3 457,600 92.7 0504 WATER 1,318 195 1,123 85.2 15,750 11,781 3,969 25.2 15,750 74.8 0505 TELEPHONE 3,925 656 3,269 83.3 47,100 43,192 3,908 8.3 47,100 91.7 UTILITIES 81,513 40,535 40,978 50.3 520,450 479,394 41,056 7.9 520,450 92.1 0603 GENERAL REPAIRS & MAINT 3,087 7,185 4,098- 132.8- 37,000 70,044 33,044- 89.3- 37,000 189.3 0604 OU'T'SIDE REPAIRS & MAINT. 17,500 1,903 15,597 89.1 210,000 332,098 122,098- 58.1- 210,000 158.1 REPAIRS & MAINTENANCE 20,587 9,088 11,499 55.9 247,000 402,142 155,142- 62.8- 247,000 162.8 0704 JANITORIAL & REFUSE REMOV 1,525 0 1,525 100.0 18,300 19,134 834- 4.6- 18,300 104.6 HAULING & DISPOSAL 1,525 0 1,525 100.0 18,300 19,134 834- 4.6- 18,300 104.6 0901 OUTSIDE SAFETY SERVICES 1,975 0 1,975 100.0 8,200 9,583 1,383- 16.9- 8,200 116.9 0902 TECHNICAL SERVICES 4,230 0 4,230 100.0 50,650 43,369 7,281 14.4 50,650 85.6 OUTSIDE SERVICES 6,205 0 6,205 100.0 58,850 52,952 5,898 10.0 58,850 90.0 1103 OPERATING SUPPLIES 1,800 803 997 55.4 21,600 30,728 9,128- 42.3- 21,600 142.3 PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 29 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING-- -p/3 p 1-3------_--------------------------------------------- DEPARTMENT 05 PUMP STATIONS - - OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ---- -- -- - - ---- - -------------------------------------------------------------------------------------------------------------------- BUDGET ACTUAL VARIANCE % BUDGET ACTUAL VARIANCE % BUDGET 1104 OPERATING FUEL 11500 0 1,500 100.0 18,000 18,425 425- 2 -4- 18,000 102.4 1106 SAFETY SUPPLIES 424 0 424 100.0 5,000 2,822 2,178 43.6 5,000 56.4 MATERIALS & SUPPLIES 3,724 803 2,921 78.4 44,600 51,975 7,375- 16.5- 44,600 116.5 1201 RENTS & LEASES 212 54 158 74.5 2,500 1,023 1,477 59.1 2,500 40.9 1202 PUBLIC AGENCY FEES 1,633 0 1,633 100.0 19.,585 17,826 1,759 9.0 19,585 91.0 1204 TUITION REIMBURSEMENT 231 0 231 100.0 2,750 0 2,750 100.0 2,750 .0 1205 TECH TRAIN, CONF & MEETS 1,001 1,488 487- 48.7- 11,990 11,168 822 6.9 11,990 93.1 1206 CERTIFICATION & LICENSES 92 0 92 100.0 1,060 675 385 36.3 1,060 63.7 1208 SUBSCRIPTION /PUBLICATION 24 0 24 100.0 200 0 200 100.0 200 .0 1209 MILEAGE REIMBURSEMENTS 24 0 24 100.0 200 99 101 50.5 200 49.5 1212 EMPLOYEE MEMBERSHIPS 98 0 98 100.0 1,154 1,517 363- 31.5- 1,154 131.5 1213 MISCELLANEOUS 25 0 25 100.0 300 13 287 95.7 300 4.3 OTHER EXPENSES 3,340 1,542 1,798 53.8 39,739 32,321 7,418 18.7 39,739 81.3 0500 PUMP STATIONS 274,330 65,483 208,847 76.1 2,817,533 3,049,274 231,741- 8.2- 2,817,533 108.2 5`/ PREPARED 8/06/13, 13:48:36 EXPENSE SUMMARY REPORT BY DEPARTMENT /DIVISION PAGE 30 PROGRAM /GM279L RUNNING EXPENSE FUND ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 6/30_��- DEPARTMENT 05 PUMP STATIONS ------- - - - - -- OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE -------------`------------------------------------- BUDGET ACTUAL VARIANCE -- -------- -- ---- o BUDGET ---- ---- --- - -- — ------------------------------------------------- ACTUAL VARIANCE % BUDGET DEPARTMENT NET EXPENSES 274,330 65,483 208,847 76.1 2,817,533 3,049,274 231,741- B.2- 2,817,533 108.2 i.J S . PREPARED 8/06/13, 13:52 :33 SALARY & BENEFITS SUMMARY REPORT BY DISTRICT PAGE 1 PROGRAM /GM276L RUNNING EXPENSE & SEWER CONTRUCTION FUNDS ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 6/� O /, OBJ ------ ----- --MONTH -TO- DATE-- ---- -- --- -- - - - -_ - ------ --- --- -YEAR -TO -DATE- - ----- ANNUAL NO ------------------------------------------------------------------------------------------ ACCOUNT TITLE BUDGET ACTUAL VARIANCE % BUDGET ACTUAL --- -- --- VARIANCE --- -- --------- % ------ BUDGET - -- - --- $ -- - --- 0101 SALARIES & WAGES- MGMNT. 142,086 0 142,086 100.0 1,704,493 1,563,134 141,359 8.3 1,704,493 91.7 0102 SALARIES & WAGES -NON MGMT 1,793,382 0 1,793,382 100.0 21,518,263 21,350,770 167,493 .8 21,518,263 99.2 0103 SALARIES & WAGES -COMP ABS 25,000 0 25,000 100.0- 30.0,000 290,572 9,428 3.1 300,000 96.9 0105 OVERTIME 69,465 0 69,465 100.0 831,292 910,817 79,525- 9.6- 831,292 109.6 0106 STANDBY PAID 18,906 0 18,906 100.0 226,498 218,543 7,955 3.5 226,498 96.5 0110 SALARY VACANCY 57,446- 0 57,446 -100.0 689,000- 0 689,000 -100.0 689,000- .0 0150 CAPITALIZED SALARIES 250,065 0 250,065 100.0 2,999,812 2,631,645 368,167 12.3 2,999,812 87.7 0151 OVERTIME 11,457 0 11,457 100.0 136,846 60,864 75,982 55.5 136,846 44.5 0152 SALARY VACANCY 6,924- 0 6,924 -100.0 83,000- 0 83,000 -100.0 83,000- .0 SALARIES & WAGES 2,245,991 0 2,245,991 100.0 26,945,204 27,026,345 81,141- .3- 26,945,204 100.3 0201 WORKERS' COMPENSATION INS 42,922 0 42,922 100.0 511,698 363,170 148,528 29.0 511,698 71.0 0202 STATE UNEMPLOYMENT INSUR 7,500 0 7,500 100.0 30,000 28,422 1,578 5.3 30,000 94.7 0203 FEDERAL MEDICARE TAX 31,086 0 31,086 100.0 369,666 375,530 5,864- 1.6- 369,666 101.6 0204 MEDICAL & HEALTH INSUR 801,162 0 801,162 100.0 9,610,325 9,213,137 397,188 4.1 9,610,325. 95.9 0205 RETIREMENT CONTRIBUTION 1,273,016 0 1,273,016 100.0 15,272,771 14,029,778 1,242,993 8.1 15,272,771 91.9 0206 DEFERRED COMP. CONTRIB 128,892 0 128,892 100.0 1,542,799 1,546,318 3,519- .2- 1,542,799 100.2 0207 DENTAL INSURANCE 76,315 0 76,315 100.0 912,678 912,539 139 .0 912,678 100.0 0208 LONG-TERM DISABILITY INS 6,853 0 6,853 100.0 79,321 73,323 5,998 7.6 79,321 92.4 0209 LIFE INSURANCE 15,150 0 15,150 100.0 178,093 169,565 8,528 4.8 178,093 95.2 0211 ACCRUED COMPENSATED ABS 360,000 0 360,000 100.0 360,000 768,030 408,030- 113.3- 360,000 213.3 0212 BENEFIT VACANCY 100,348- D 100,348 -100.0 1,204,000- 0 1,204,000 -100.0 1,204,000- .0 0213 OPEB CONTRIBUTION 0 0 0 .0 3,767,000 3,476,904 290,096 7.7 3,767,000 92.3 EMPLOYEE BENEFITS 2,642,548 TOTAL SALARY AND BENEFITS 4,888,539 0 2,642,548 100.0 31,430,351 30,956,716 473,635 1.5 31,430,351 98.5 0 4,888,539 100.0 58,375,555 57,983,061 392,494 .7 58,375,555 99.3 F-6) PREPARED 8/06/13, 13:52:45 SALARY & BENEFITS BY DEPARTMENT PAGE 1 PROGRAM /GM279DS RUNNING EXPENSE & SEWER CONSTRUCTION FUNDS ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: ----------------------- - - - - -- ------- - - - - -- DEPARTMENT 01 ADMINISTRATION - - - - - - -- - - - ---- - - - - -- ---------------------------------------------------- OBJ ----- -- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - -- -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE BUDGET - - - - -------- --- - -- - -- ---------- - ------ - ACTUAL VARIANCE ------ - --------- ---- ------- % BUDGET ACTUAL VARIANCE --- -- ---- --- --- - --- - - --- ----- ----- --- --------- BUDGET o - - ---- - - - 0101 SALARIES & WAGES- MGMNT. 0102 SALARIES & WAGES -NON MGMT 0103 COMP ABS- ACCRUAL PAYMENTS 0105 OVERTIME 0110 SALARY VACANCY 0150 CAPITALIZED SALARIES 0151 OVERTIME SALARIES & WAGES 0201 WORKERS' COMPENSATION INS 0202 STATE UNEMPLOYMENT INSUR 0203 FEDERAL MEDICARE TAX 0204 MEDICAL & HEALTH INSUR 0205 RETIREMENT CONTRIBUTION 0206 DEFERRED COMP. CONTRIB 0207 DENTAL INSURANCE 0208 LONG -TERM DISABILITY INS 0209 LIFE INSURANCE 0211 ACCRUED COMPENSATED ABS. 0212 BENEFIT VACANCY 0213 OPEB CONTRIBUTION EMPLOYEE BENEFITS DEPARTMENT NET EXPENSES 73,155 274,301 25,000 7,260 9,837- 3,278 29 373,186 1,810 7,500 5,102 416,769 207,675 20,197 39,673 977 6,034 360,000 41,674- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,024,063 0 1,397,249 0 73,155 100.0 274,301 100.0 25,000 100.0 7,260 100.0 9,837 -100.0 3,278 100.0 29 100.0 373,186 100.0 1,810 100.0 7,500 100.0 5,102 100.0 416,769 100.0 207,675 100.0 20,197 100.0 39,673 100.0 977 100.0 6,034 100.0 360,000 100.0 41,674 -100.0 0 .0 877,552 3,291,161 300,000 86,680 118,000- 39,270 315 4,476,978 21,159 30,000 60,355 5,000,326 2,491,275 241,473 475,625 11,306 71,715 360,000 500,000- 3,767,000 963,905 3,169,927 216,582 61,785 0 16,811 142 4,429,152 14,978 28,422 60,476 5,106,400 2,221,579 236,115 456,956 10,154 113,425 768,030 0 3,476,904 1,024,063 100.0 12,030,234 12,493,439 1,397,249 100.0 16,507,212 16,922,591 86,353- 9.8- 877,552 109.8 121,234 3.7 3,291,161 96.3 83,418 27.8 300,000 72.2 24,895 28.7 86,680 71.3 118,000 -100.0 118,000- .0 22,459 57.2 39,270 42.8 173 54.9 315 45.1 47,826 1.1 4,476,978 98.9 6,181 29.2 21,159 70.8 1,578 5.3 30,000 94.7 121- .2- 60,355 100.2 106,074- 2.1- 5,000,326 102.1 269,696 10.8 2,491,275 89.2 5,358 2.2 241,473 97.8 18,669 3.9 475,625 96.1 1,152 10.2 11,306 89.8 41,710- 58.2- 71,715 158.2 408,030- 113.3- 360,000 213.3 500,000 -100.0 500,000- _0 290,096 7.7 3,767,000 92.3 463,205- 3.9- 12,030,2.34 103.9 415,379- 2.5- 16,507,212 102.5 S7 PREPARED 8/06/13, 13:52:45 SALARY & BENEFITS BY DEPARTMENT PAGE 2 PROGRAM /GM279DS RUNNING EXPENSE & SEWER CONSTRUCTION FUNDS ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT ------ -- ------ PERIOD ENDING: b /3D Jp / --- - - ----- DEPARTMENT 02 ENGINEERING -_- -- - - --- --- --- - ---------' --- --- - ---'-- ---'-- '--- ---- - - ---'-- OBS ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO -- ------ ACCOUNT TITLE --- --- --- --- -- - ------ ----- BUDGET -- -- - ------------------------------- ACTUAL VARIANCE % BUDGET -- ------------ ACTUAL -- -- ------ -- -- VARIANCE - -- - - --------------- % BUDGET ---- o -- - - -- 0101 SALARIES & WAGES- MGMNT. 24,796 0 24,796 100.0 297,497 160,702 136,795 46.0 297,497 54.0 0102 SALARIES & WAGES -NON MGMT 434,232 0 434,232 100.0 5,210,333 5,329,422 119,089- 2,3- 5,210,333 102.3 0103 SALARIES & WAGES -COMP ABS 0 0 0 .0 0 30,837 30,837- .0 0 .0 0105 OVERTIME 4,935 0 4,935 100.0 59,000 73,351 14,351- 24.3- 59,000 124.3 0110 SALARY VACANCY 13,761- 0 13,761 -100.0 165,000- 0 165,000 -100.0 165,000- .0 0150 CAPITALIZED SALARIES 232,572 0 232,572 100.0 2,790,556 2,489,625 300,931 10.8 2,790,556 89.2 0151 OVERTIME 10,848 0 10,848 100.0 130,000 53,695 76,305 58.7 130,000 41.3 0152 SALARY VACANCY 6,924- 0 6,924 -100.0 83,000- 0 83,000 -100.0 83,000- .0 SALARIES & WAGES 686,698 0 686,698 100.0 8,239,386 8,137,632 101,754 1.2 ,8,239,386 98.8 0201 WORKERS' COMPENSATION INS 7,609 0 7,609 100.0 90,417 64,919 25,498 28.2 90,417 71.8 0203 FEDERAL MEDICARE TAX 9,500 0 9,500 100.0 113,098 111,532 1,566 1.4 113,098 98.6 0204 MEDICAL & HEALTH INSUR 127,115 0 127,115 100.0 1,524,544 1,405,211 119,333 7.8 1,524,544 92.2 0205 RETIREMENT CONTRIBUTION 393,016 0 393,016 100.0 4,715,367 4,266,526 448,841 9.5 4,715,367 90.5 0206 DEFERRED COMP. CONTRIB 39,266 0 39,266 100.0 470,312 470,368 56- .0 470,312 100.0 0207 DENTAL INSURANCE 12,958 0 12,958 100.0 154,704 158,883 4,179- 2.7- 154,704 102.7 0208 LONG -TERM DISABILITY INS 2,104 0 2,104 100.0 24,731 22,779 1,952 7.9 24,731 92.1 0209 LIFE INSURANCE 3,382 0 3,382 100.0 39,638 23,398 16,240 41.0 39,638 59.0 0211 ACCRUED COMPENSATED ABS. 0 0 0 .0 0 0 0 .0 0 .0 0212 BENEFIT VACANCY 15,924- 0 15,924 -100.0 191,000- 0 191,000 -100.0 191,000- .0 EMPLOYEE BENEFITS 579,026 DEPARTMENT NET EXPENSES 1,265,724 0 579,026 100.0 6,941,811 6,523,616 418,195 6.0 6,941,811 94.0 0 1,265,724 100.0 15,181,197 14,661,248 519,949 3.4 15,181,197 96.6 101 PREPARED 8/06/13, 13 :52:45 .SALARY & BENEFITS BY DEPARTMENT PAGE 3 PROGRAM /GM279DS RUNNING EXPENSE & SEWER CONSTRUCTION FUNDS ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDINGr -6/30//_3 � 2 DEPARTMENT 03 COLLECTION SYSTEM _- OPS. - ___________________________________________________ OBJ ------- - - - - -- MONTH -TO- DATE-- ----- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ------ -- -- ---- ------ -- ---- - - ---- BUDGET - - - ---- --- ACTUAL -- - - ---- ---- VARIANCE -- ------ ------ %; ----- BUDGET --- ---- --- ACTUAL --------------------------------------------- VARIANCE % BUDGET e 0101 SALARIES & WAGES- MGMNT. 16,368 0 16,368 100.0 196,361 291,974 95,613- 48.7- 196,361 148.7 0102 SALARIES & WAGES -NON MGMT 365,077 0 365,077 100.0 4,380,275 4,421,831 41,556- .9- 4,380,275 100.9 0103 SALARIES & WAGES COMP ABS 0 0 0 _0 0 8,152 8,152- .0 0 .0 0105 OVERTIME 19,027 0 19,027 100.0- 227,576 292,570 64,994- 28.6- 227,576 128.6 0106 STANDBY PAID 5,500 0 5,500 100.0 66,000 59,895 6,105 9.3 66,000 90.8 0110 SALARY VACANCY 11,424- 0 11,424 -100.0 137,000- 0 137,000 -100.0 137,000- .0 0150 CAPITALIZED SALARIES 7,042 0 7,042 100.0 84,361 37,427 46,934 55.6 84,361 44.4 0151 OVERTIME 310 0 310 100.0 3,577 1,541 2,036 56.9 3,577 43.1 SALARIES & WAGES 401,900 0 401,900 100.0 4,821,150 5,113,390 292,240- 6.1- 4,821,150 106.1 0201 WORKERS' COMPENSATION INS 11,770 0 11,770 100.0 140,393 103,343 37,050 26.4 140,393 73.6 0203 FEDERAL MEDICARE TAX 5,460 0 5,460 100.0 64,893 69,026 4,133- 6.4- 64,893 106.4 0204 MEDICAL & HEALTH INSUR 96,361 0 96,361 100.0 1,155,529 1,076,796 78,733 6.8 1,155,529 93.2 0205 RETIREMENT CONTRIBUTION 231,786 0 231,786 100.0 2,780,838 2,693,810 87,028 3.1 2,780,838 96.9 0206 DEFERRED COMP. CONTRIB 24,081 0 24,081 100.0 288,279 311,460 23,.181- 8.0- 288,279 108.0 0207 DENTAL INSURANCE 8,810 0 8,810 100.0 105,005 120,402 15,397- 14.7- 105,005 114.7 0208 LONG -TERM DISABILITY INS 1,342 0 1,342 100.0 15,411 14,810 601 3.9 15,411 96.1 0209 LIFE INSURANCE 1,981 0 1,981 100.0 23,178 10,472 12,706 54.6 23,.178 45.2 0212 BENEFIT VACANCY 15,000- 0 15,000 -100.0 180,000- 0 180,000 -100.0 180,000- .0 EMPLOYEE BENEFITS 366,591 0 366,591 100.0 4,393,526 4,400,119 6,593- .2- 4,393,526 100.2 DEPARTMENT NET EXPENSES 768,491 0 768,491 100.0 9,214,676 9,513,509 298,833- 3.2- 9,214,676 103.2 59 PREPARED 8/06/13, 13;52:45 SALARY & BENEFITS BY DEPARTMENT PAGE 4 PROGRAM /GM279DS RUNNING EXPENSE & SEWER CONSTRUCTION FUNDS ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT --------- ---------- ------------ --- - - -- PERIOD ENDING: (0,3 � //� l - - - _ -- --' --- DEPARTMENT 04 PLANT OPERATIONS OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ----------------------------------------------- ACCOUNT TITLE BUDGET ACTUAL --- ---- ---------- VARIANCE ------ % -- BUDGET - ----- - -- ----- ACTUAL -- - - - - -- - VARIANCE ----------------------------------- % BUDGET , 0101 SALARIES & WAGES- MGMNT. 27,767 0 27,767 100.0 333,083' 146,553 186,530 56-0 333,083 44.0 0102 SALARIES & WAGES -NON MGMT 657,573 0 657,573 100.0 7,890,227 7,680,553 209,674 2.7 7,890,227 97.3 0103 COMP ABS- ACCRUAL PAYMENTS 0 0 0 .0 0 35,001 35,001- .0 0 .0 0105 OVERTIME 35,939 0 35,939 100.0 430,509 441,094 10,585- 2.5- 430,509 102.5 0106 STANDBY PAID 5,069 0 5,069 100.0 60,498 54,772 5,726 9.5 60,498 90.5 0110 SALARY VACANCY 20,587- 0 20,587 -100.0 247,000- 0 247,000 -100.0 247,000- .0 0150 CAPITALIZED SALARIES 6,807 0 61807 100.0 81,266 87,782 6,516- 8.0- 81,266 108.0 0151 OVERTIME 249 0 249 100.0 2,790 5,486 2,696- 96.6- 2,790 196.6 SALARIES & WAGES 712,817 0 712,817 100.0 8,551,373 8,451,241 100,132 1.2 8,551,373 98.8 0201 WORKERS COMPENSATION INS 19,618 0 19,618 100.0 234,426 161,853 72,573 31.0 234,426 69.0 0203 FEDERAL MEDICARE TAX 10,088 0 10,088 100.0 120,143 121,538 1,395- 1.2- 120,143 101.2 0204 MEDICAL & HEALTH INSUR 149,884 0 149,884 100.0 1,797,574 1,514,847 282,727 1.5.7 1,797,574 84.3 0205 RETIREMENT CONTRIBUTION 403,859 0 403,859 100.0 4,845,219 4,372,383 472,836 9.8 4,845,219 90.2 0206 DEFERRED COMP. CONTRIB 41,560 0 41,560 100.0 497,444 475,655 21,789 4.4 497,444 95.6 0207 DENTAL INSURANCE 13,796 0 13,796 100.0 164,485 163,561 924 .6 164,485 99.4 0208 LONG -TERM DISABILITY INS 2,212 0 2,212 100.0 25,389 23,209 2,180 8.6 25,389 91.4 0209 LIFE INSURANCE 3,456 0 3,456 100.0 40,174 20,349 19,825 49.3 40,174 50.7 0211 ACCRUED COMPENSATED ABS 0 0 0 .0 0 0 0 _0 0 .D 0212 BENEFIT VACANCY 25,500- 0 25,500 -100.0 306,000- 0 306,000 -100.0 306,000- .0 EMPLOYEE BENEFITS 618,973 0 618,973 100.0 7,418,854 6,853,395 565,459 7.6 7,418,854 92.4 DEPARTMENT NET EXPENSES 1,331,790 0 1,331,790 100.0 15,970,227 15,304,636 665,591 4.2 15,970,227 95.8 O PREPARED 8/06/13, 13:52 :45 SALARY & BENEFITS BY DEPARTMENT PAGE 5 PROGRAM /GM2791)S RUNNING EXPENSE & SEWER CONSTRUCTION FUNDS ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 613011 X lf ' - -- ----- ---- -- --- DEPARTMENT 05 PUMP STATIONS - --- -- - -- - -- --- - ---- -3 -- --- --- -- -- ---- - ------------------------- OBJ ------------- MONTH- TO-DATE ------------- ----- -- ---- -- -YEAR -TO- DATE-------------- ANNUAL NO ACCOUNT TITLE - ---------- - - -- -- - --- -------- - - BUDGET - -- - - ----- ACTUAL - -- --- -- ---- VARIANCE - - -- - ---- o -- ---- BUDGET -- -- ------ ----- ACTUAL - --- -- --- VARIANCE --- - ----- $ --- --- BUDGET - ----------- - - 0102 SALARIES & WAGES -NON MGMT 62,199 0 62,199 100.0 746,267 749,037 2,770- .4- 746,267 100.4 0103 SALARIES & WAGES -COMP ABS 0 0 0 .0 0 0 0 _0 0 .0 0105 OVERTIME 2,304 0 2,304 100.0 27,527 42,017 14,490- 52.6- 27,527 152.6 0106 STANDBY PAID 8,337 0 8,337 100.0 100,000 103,876 3,876- 3.9- 100,000 103.9 0110 SALARY VACANCY 1,837- 0 1,837 -100.0 22,000- 0 22,000 -100.0 22,000- .0 0150 CAPITALIZED SALARIES 366 0 366 100.0 4,359 0 4,359 100.0 4,359 .0 0151 OVERTIME 21 0 21 100.0 164 0 164 100.0 164 .0 SALARIES & WAGES 71,390 0 71,390 100.0 856,317 894,930 38,613- 4.5- 856,317 104.5 0201 WORKERS' COMPENSATION INS 2,115 0 2,115 100.0 25,303 18,077 7,226 28.6 25,303 71.4 0203 FEDERAL MEDICARE TAX 936 0 936 100.0 11,177 12,958 1,781- 15.9- 11,177 115.9 0204 MEDICAL & HEALTH INSUR 11,033 0 11,033 100.0 132,352 109,883 22,469 17.0 132,352 83.0 0205 RETIREMENT CONTRIBUTION 36,680 0 36,680 100.0 440,072 475,480 35,408- 8.0- 440,072 108.0 0206 DEFERRED COMP. CONTRIB 3,788 0 3,788 100.0 45,291 52,720 7,429- 16.4- 45,291 116.4 0207 DENTAL INSURANCE 1,078 0 1,078 100.0 12,859 12,737 122 .9 12,859 99.1 0208 LONG -TERM DISABILITY INS 218 0 218 100.0 2,484 2,371 113 4.5 2,484 95.5 0209 LIFE INSURANCE 297 0 297 100.0 3,388 1,921 1,467 43.3 3,388 56.7 0211 ACCRUED COMPENSATED ABS 0 0 0 .0 0 0 0 .0 0 .0 0212 BENEFIT VACANCY 2,250- 0 2,250 -100.0 27,000- 0 27,000 -100.0 27,000- .0 EMPLOYEE BENEFITS 53,895 0 53,895 100.0 645,926 686,147 40,221- 6.2- 645,926 106.2 DEPARTMENT NET EXPENSES 125,285 0 125,285 100.0 1,502,243 1,581,077 78,834- 5.2- 1,502,243 105.2 �l PREPARED 8/07/13, 14:00:36 2013 STATEMENT OF NET ASSETS PAGE 3 PROGRAM /GM263LJ //� ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT AS OF wl "_ - -- -- - - - - -- - ------------------------------------------ --------- - - - - -- -------------------------------------- ----------------------- 002 SEWER CONSTRUCTION CURRENT ASSETS CASH 690,561.16 INTANGIBLE ASSETS REVENUE BOND INVESTMENTS ACCUM DEPR - INTANGIBLE .00 TEMPORARY INVESTMENTS 49,700,000.00 ACC DEPR- BUILDINGS ACCOUNTS RECEIVABLE 3,76D,182.41 .00 ALLOWANCE FOR UNCOLL A/R .00 .00 ACCRUED INTEREST A/R 26,487.59 .00 BOND ACCRUED INTEREST A/R .00 .00 CAD RECEIVABLE 434,395.84 .00 AVAD - ALHAMBRA VLY AR 1,655,065.46 VEHICLES DUE FROM R/E 74,244,584.37 .00 DUE FROM S/I 43,026.09 ACCUM DEPRC -RECY WATER DUE FROM DEBT FUND 15,488,141.62 .00 TOTAL CURRENT ASSETS 146,042,444.54 NET PROPERTY, PLANT & EQUIPMENT LAND .00 INTANGIBLE ASSETS .00 ACCUM DEPR - INTANGIBLE .00 BUILDINGS .00 ACC DEPR- BUILDINGS .00 TREATMENT PLANT .00 ACC DEPR- TREATMENT PLANT .00 PUMPING STATIONS .00 ACC DEPR - PUMPING STATIONS .00 SEWAGE COLLECTION FACIL .00 OUTFALL SEWERS .00 FURNITURE & EQUIPMENT .00 ACC DEPR -FURN & EQUIP .00 VEHICLES .00 ACC DEPR- VEHICLES .00 RECY WATER INFRASTRUCTURE .00 ACCUM DEPRC -RECY WATER .00 - CONTRIBUTED SEWER LINES .00 ACC DEPR - CONTRIB ASSETS .00 CONSTRUCTION IN PROGRESS .00 TOTAL NET PROPERTY, PLANT & EQUIPMENT .00 TOTAL ASSETS 146,042,444.54 LIABILITIES DUE TO R/E 116,465,947.39 - DUE TO S/I 33,460.76 - DUE TO DEBT FUND 744,818.33 - ACCOUNTS PAYABLE 2,212,922.37 - SALES TAX PAYABLE 12,893.29- 9 PREPARED 8/07/13, 14:00:36 2013 STATEMENT OF NET ASSETS PAGE 4 PROGRAM /GM263L ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT AS OF % ---------------------------- ------------- 002 SEWER CONSTRUCTION -------------------------------------`------------------------------------- --- -- ------- -- - --------- - -------------------------------------------------- ---- --- --------- --------- -- - --- - -- --- ----- ----- - - - - -- - - REFUNDABLE CONTT BONDS 15B,419.49- UNEARNED INTEREST 364.58 - PROJECT RETENTION PAYABLE 314,273.37 - TOTAL LIABILITIES 119,943,099.58 - FUND EQUITY RESERVE FOR ENCUMBRANCES .00 AVAILABLE FUND BALANCE 3,817,702.37 - EXPENDITURE SUMMARY .00 REVENUE SUMMARY 22,281,642.59 - TOTAL FUND EQUITY 26,099,344.96 - TOTAL LIABILITIES AND FUND EQUITY --- -- --- -- - --- 146,042,444.54 - -------------- -------------- e PREPARED 8/06/13, 13:47:27 REVENUE SUMMARY REPORT PAGE 2 PROGRAM /GM270L 100% OF YEAP T.APSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - - - PERIOD - ENDING: ------- ------ - ----- -------- - - - - -- F- 3O". �------------------------------------------------ - - - - -- FUND 002 SEWER CONSTRUCTION OBJ ------- - - - - -- MONTH -TO- DATE------- - - - - -- -------- - - - - -- YEAR -TO- DATE-------- - - - - -- ANNUAL NO ACCOUNT TITLE ESTIMATE ACTUAL VARIANCE ESTIMATE ACTUAL VARIANCE % ESTIMATE °s - - -------------------------------------- -- ------ -- --- -- ---------- --- - -- - ---------------------------- -- ----- ------- --- --- --- ------- 2301 SEWER SVC CHRG- COUNTY SEWER SERVICE CHARGES 1500 MAIN LINES INSPECTION 1600 PLAN REVIEW 1900 OVERTIME INSPECTION 2100 TV REINSPECTION 3800 RECYCLED WATER 4000 FACILITIES CAPACITY FEES 4100 REBATES TO DISTRICT 4200 PUMP ZONE FEES 4400 CAPACITY USE CHARGE 4501 INTEREST INCOME 4600 TAX REVENUE 4700 OTHER AGENCY REIMB -MISC 4800 OTHER GOVT REV -CAL TRANS 5400 OTHER GOVT REV - CONCORD 6000 MISCELLANEOUS INCOME 6125 CAD REIMBURSEMENT 6507 ALHAMBRA VLY ASSESSMENTS OTHER REVENUES FUND TOTALS 88,600 88,600 16,674 7,087 2,337 87 40,668 368,087 87 53,087 15,837 29,174 1,234,000 0 0 3,833,000 1,674 0 0 5,601,799 5,690,399 0 0 0 0 0 0 16,008 8,688 - 0 0 0 664- 228,000 0 0 116,771 0 0 0 351,427 88,600 - 100.0- 4,430,000 4,384,376 88,600 - 100.0- 4,430,000 4,384,376 16,674- 100.0- 200,000 7,087 - 100.0- 85,000 2,337 - 100.0- 28,000 87- 100.0- 1,000 24,660- 60.6- 61,000 376,775- 102.4- 4,417,000 87- 100.0- 1,000 53,087- 100.0- 637,000 15,837- 100.0- 190,000 29,838- 102.3- 350,000 1,006,000- 81.5- 7,534,000 0 .0 0 0 .0 0 3,716,229- 97,0- 3,833,000 1,674- 100.0- 20,000 0 .0 0 0 .0 0 146,109 47,597 8,527 0 246,008 5,426,301 1,137 553,778 111,450 230,054 7,471,518 0 0 3,616,771 0 0 38,016 5,250,372- 93.7- 17,357,000 17,897,266 45,624- 1.0- 4,430,000 99.0 45,624- 1.0- 4,430,000 99.0 53,891- 26.9- 200,000 73.1 37,403- 44.0- 85,000 56.0 19,473- 69.5- 28,000 30.5 1,000- 100.0- 1,000 .0 185,008 303.3 61,000 403.3 1,009,301 22.9 4,417,000 122.9 137 13.7 1,000 113.7 83,222- 13.1- 637,000 86.9 78,550- 41.3- 190,000 58.7 119,946- 34.3- 350,000 65.7 62,482- .8- 7,534,000 99.2 0 .0 0 .0 0 .0 0 .0 216,229- 5.6- 3,833,000 94.4 20,000- 100.0- 20,000 .0 0 .0 0 .o 38,016 .0 0 .0 540,266 3.1 17,357,000 103.1 351,427 5,338,972- 93.8- 21,787,000 22,281,642 494,642 2.3 21,787,000 102.3 100 PREPARED 8/06/13, 13:54:54 CAPITAL IMPROVEMENT BUDGET PAGE 1 PROGRAM /GM185L4 100% OF FISCAL YEAR ELAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT_ PERIOD ENDING: .7 ------- TYPE _------ _----- _-------- _ ___ TP Treatment Plant _ ____ ________ _ TOTAL TOTAL PROJECT PCT EXPENDED PCT EXPENDED REMAINING PROJ ALLOCATED PROJECT EXPENDED EXP CIB EST THIS EXP THIS ALLOCATED NO _______________________________________________________________________________________________________________________________________ PROJECT TITLE BUDGET COST EST TO DATE PTO THIS £Y YEAR YTD MONTH BUDGET REGULATORY COMPL 4 SAFETY 7283 FIRE PROT SYS IMPRVMT 318,000 358,000 180,394 57 30,000 152,414 508 52,148 137,606 7284 TP HAZARD ID /REMEDIATION 125,000 868,000 117,821 94 80,000 4,591 6 .0 7,179 7287 TP MASTER PLAN UPDATE 467,000 356,700 368,979 79 51000. 117,242 345 0 98,021 7301 TREATMENT PLANT PLANNING 11666,000 3,233,600 1,103,446 66 810,000 1,064,836 132 191675 562,554 SUB -TOTAL : 2,576,000 4,816,300 1,770,640 69 925,000 1,339,083 145 71,823 805,360 ONE -TIME RENOVATION 7272 ELECTRIC BLOWER RENOV 474,000 1,447,400 422,329 89 150,000 0 0 0 51,671 7285 PRIMARY TREATMENT RENOV 4,460,000 13,500,000 1,276,276 29 5,400,000 944,041 18 1,467 3,183,724 7289 POB SEISMIC UPGRADE 190,000 1,297,100 135,741 71 1,000 15,624 562 0 54,259 7291 PUMP /BLOWER SEISMIC UPGRD 405,000 31800,000 295,815 73 850.000 37,367 4 3,221 109,185 7292 SWITCHGEAR REFURBISHMT -P2 300,000 1,536,500 106,759 36 200,000 5,286 3 0 193,241 7294 SEC PROCESS IMPS 50,000 1,429,500 47,403 95 45,000 14,107 31 0 2,597 7295 AUX BOILER BURNER UPGRADE 215,000 230,000 139,216 65 100,000 88,742 89 910 75,784 7296 SEISMIC UPGRADES FOR SCB 150,000 133,700 137,690 92 5,000 10,057 201 0 12,310 7297 WET /DRY SCRUBBER REPLCMT 25,000 6,622,000 964 4 51,000 110 0 0 24,036 7302 PE PUMP REFURB, PH 2 25,000 70,000 16,843 67 1,000 6,575 658 0 8,157 7304 INSTR E, CNTRL -PLC UPGRADE 60,000 800,000 38,720 65 80,000 38,720 48 0 21,280 7308 COGEN RENOVATION 100,000 800,000 1,823 2 400,000 1,823 1 0 98,177 7309 DAF TANKS RENOVATION 100,000 100,000 7,475 8 100,000 7,475 8 0 92,525 SUB -TOTAL : 6,554,000 31,766,200 2,627,054 40 7,383,000 1,169,927 16 5,598 3,926,946 - RECURRING RENOVATION 7254 TP CATHODIC PROT SYS REPL 600,000 600,000 540,670 90 5,000 13,285 266 0 59,330 7265 TP EQUIPMENT REPLACEMENT 1,250,000 1,202,000 1,021,806 82 50,000 286,145 572 4,244 228,194 7268 TP FACILITIES RENOV 250,000 3,950,000 220,016 88 87,000 28,711 33 0 29,984 7269 TP ASSET MANAGEMENT 1,184,000 964,100 660,753 56 150,000 36,208 24 0 523,247 7298 PIPING RENOVATION, PH7 1,417,000 1,016,000 1,298,472 92 5,000 1,236,182 724 158,730 118.528 SUB -TOTAL : 4,701,000 7,732,100 3,741,717 80 297,000 1,600,531 539 162,974 959,283 SUBSTANTIALLY COMPLETE 7241 WET WEATHER BYPASS IMPS 3,320,000 3,320,000 3,277,386 99 10,000 8,915 89 0 42,614 SUB -TOTAL : 3,320,000 3,320,000 3,277,386 99 10,000 8,915 89 0 42,614 COMPLETED PROJECTS 7255 PRIMARY STRUCTURE DEMO 1,537,102 1,537,102 1,537,099 100 0 600,791 0 0 3 7256 ALTERNATIVE ENERGY STUDY 706,240 706,240 706,242 100 0 63,180 0 0 2- 7276 PIPING RENOVATIONS, PH 5 2,484,926 2,484,926 2,484,924 100 0 1,382 0 0 2 7288 PIPING RENOV PH 6 2,267,250 2,267,250 2,267,259 100 0 293,803 0 0 9- PREPARED 8/06/13, 13:54:54 CAPITAL IMPROVEMENT 13UDGET PAGE 2 PROGRAM /GM185L4 100% OF FISCAL YEAR ELAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT_____ PERIOD ENDING ?___ // 1, A b ! J�_____________ _______________________________ _______ _______________________________ TYPE TP Treatment Plant ___ _ _ __ _ _ TOTAL TOTAL PROJECT PCT EXPENDED PCT EXPENDED REMAINING PROS ALLOCATED PROJECT EXPENDED EXP CIB EST THIS EXP THIS ALLOCATED NO PROJECT TITLE ________________________________________________________________________________________________________ BUDGET COST EST TO DATE PTO THIS FY YEAR YTD _______________________________ MONTH BUDGET 7290 OUTFALL IMPROVEMENTS -PH 6 3,525,608 3,525,608 3,525,615 100 0 2,747,870 0 0 7- SUB -TOTAL : 10,521,126 10,521,126 10,521,139 100 0 3,707,026 0 0 13- UNALLOCATED AUTHORIZATIONS 725,874 0 PROGRAM CONTINGENCY 215,000 0 Treatment Plant 28,613,000 58,155,726 21,937,936 77 8,615,000 7,825,482 91 240,395 6,675,064 PREPARED 8/06/13, 13:54:54 CAPITAL IMPROVEMENT BUDGET PAGE 3 PROGRAM /GM185L4 1004 OF FISCAL YEAR ELAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: b / ____________________________ TYPE _______________________________ CS Collection System _____- _____ -_�?� TOTAL TOTAL PROJECT PCT EXPENDED PCT EXPENDED REMAINING PROJ ALLOCATED PROJECT EXPENDED EXP CIB EST THIS EXP THIS ALLOCATED NO ________________________________________________________________________________________________________ PROJECT TITLE BUDGET COST EST TO DATE PTD THIS FY YEAR YTD _______________________________ MONTH BUDGET RENOVATION 5948 SEWER TV INSPECTION, PH2 1,200,000 8,401,000 1,129,628 94 800,000 329,108 41 1,304 70,372 5955 SUSPENDED PIPE SUPPORT 392,000 274,000 186,237 48 40,000 117,099 293 1,415 205,763 5976 DIABLO RENOVATIONS PH2 700,000 2,736,000 706,092 101 1,500,000 631,226 42 0 6,892- 5982 PIPE BURST BLANKET 828,000 623,500 362,415 44 100,000 38,738 39 0 465,585 5991 P.H. SEWER RENOV PH 2 400,000 2,383,300 133,017 33 200,000 0 0 0 266,983 5993 FORCEMAIN ASSESSMENT 127,000 177,000 79,257 62 50,000 17,825 36 0 47,743 5999 CIPP BLANKET CONTRAST 92,200 213,000 47,303 51 100,000 44,069 44 1,460 44,897 8404 LAFAYETTE SEWER RENOV PHS 2,304,500 2,619,000 1,234,787 54 11500,000 926,805 62 215,113 1,069,713 8405 2013 CIPP PROJECT 1,010,000 4,928.000 717,078 71 2,500,000 577,681 23 0 292,922 8410 CATHODIC PROT SYS REPL 200,000 1,000,000 6,864 3 50,000 6,864 14 0 193,136 8411 NO.ORINDA SEWER REM. PH 5 450,000 2,650,000 455,270 101 550,000 447,732 81 - 14,160 5,270- 8413 WCK SEWER REN., PH 10 329,000 2,600,000 273,694 83 11000,000 273,694 27 0 55,306 8415 MARTINEZ PH 4 SEWER REN. 150,000 2,060,000 26,357 18 250,000 26,357 11 0 123,643 8417 SURVEY MONUMENT INSTALL 50,000 500,000 50,700 101 50,000 50,700 101 2,508 700 - SUB -TOTAL : 8,232.700 31,164,800 5,409,499 66 8,690,000 3,487,898 40 235,960 2,823,201 REGL /COMP /URGNT /PLNG /SAFE 5962 MANHOLE REMOT LVL MONITOR 250,000 325,500 130,933 52 100,000 55,208 55 0 119,067 SUB -TOTAL 250,000 325,500 130,933 52 100,000 55,208 55 0 119,067 EXPANSION 5773 SMITH ROAD CAD 121,000 0 53,914 45 0 53,914 0 0 67,086 5937 ALHAMBRA VALLEY ASSMT DST 200,000 134,600 129,002 65 5,000 3,479 70 0 70,998 8412 PH GRAYSON CREEK TRUNK SW 500,000 2,900,000 388,975 78 800,000 381,089 48 0 111,025 8418 COL.SYS. MODELING UPGRADE 100,000 550,000 1,059 1 250,000 11059 0 0 98,941 SUB -TOTAL : 921,000 3,584,600 572,950 62 1,055,000 439,541 42 0 348,050 PUMPING STATIONS 5941 PS EQUIP & PIPING REPL 640,000 845,500 547,824 86 75,000 77,029 103 0 92,176 5995 SR AND MTZ BYPASS PUMPS 55,000 74,000 44,391 B1 5,000 118 2 0 10,609 6003 SR PUMPING STATION UPGRAD 402,000 458,000 370,798 92 5,000 318,215 364 0 31,202 8403 BUCHANAN AIR PUMP ST REPL 50,000 451,000 83 0 400,000 83 0 0 49,917 8406 PUMP STATION SAFETY IMPS 60,000 540,000 0 0 60,000 0 0 0 60,000 8407 MARTINEZ BYPASS PUMP 200,000 78,500 91,684 46 1,000 89,225 923 0 108,316 8409 PS SCADA O&M MANUAL 20,000 20,000 12,480 62 10,000 12,480 125 0 7,520 8414 MOR PUMPG ST.CHOPPER PUMP 100,000 400,000 19,964 20 200,000 19,964 10 0 80,036 SUB -TOTAL : 1,527,000 2,867,000 1,087,224 71 756,000 517,114 68 0 439,776 SUBSTANTIALLY COMPLETE 67 PREPARED 8/06/13, 13:54:54 CAPITAL IMPROVEMENT BUDGET PAGE 4 PROGRAM /GM185L4 1003 OF FISCAL YEAR ELAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT- ------------------------------ PERIOD ENDING: TYPE CS Collection System - - - - -- - - - - - - -- - TOTAL TOTAL PROJECT PCT EXPENDED PCT EXPENDED REMAINING PROJ ALLOCATED PROJECT EXPENDED EXP CIB EST THIS EXP THIS ALLOCATED NO --------------------------------------------------------------------------------------------------------------------------------------- PROJECT TITLE BUDGET COST EST TO DATE PTO THIS FY YEAR YTD MONTH BUDGET 5973 NO ORINDA SEWER REN PH 4 21589,000 2,589,000 2,579,690 100 10,000 1,582,614 826 0 9,310 8401 WC SEWER RENOV PH9 3,088,000 3,088,000 3,043,972 99 1,000 2,474,624 462 153,180 44,028 SUB -TOTAL : 5,677,000 5,677,000 5,623,662 99 11,000 4,057,238 884 153,180 53,338 COMPLETED PROJECTS 5965 COLLECTION SYSTM PLANNING 1,219,494 1,219,494 1,219,492 100 0 131,548 0 0 2 5967 A -LINE EASEMENT ACQUIS P2 1,356,788 1,356,788 1,356,786 100 0 18,935 0 0 2 5987 CS CATHODIC PROT SYS REPL 349,392 349,392 349,393 100 0 117,635 0 0 1- 5989 S ORINDA SEWER REN PH5 2,904,199 2,167,800 2,904,206 100 0 10,635 0 0 7- 5992 W CREEK SEWER REN, PH 8 2,104,896 2,030,000 2,104,898 100 0 1,003 0 0 - 2- 6476 SUNNYBROOK ROAD CAD 156,744 - 156,744 156,744 100 0 17,538 0 0 0 6513 ST. MARY'S ROAD CAD 386,660 386,660 386,660 100 0 386,660 0 0 0 8416 2012 -13 DEVELPMNT SEWERAG 822,990 822,990 822,995 100 0 822,995 0 0 5- SUB -TOTAL : 9,301,163 8,489,868 9,301,174 100 0 1,506,949 0 0 11- UNALLOCATED AUTHORIZATIONS 724,387 0 PROGRAM CONTINGENCY 350,550 0 Collection System 26,983,800 52,108,768 22,125,442 82 10,612,000 10,063,948 95 389,140 4,8$8,358 • f � PREPARED 8/06/13, 13 :54:54 CAPITAL IMPROVEMENT BUDGET PAGE 5 PROGRAM /GM185L4 1002 OF FISCAL YEAR ELAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING, b 3b1:. ------------------------------------------ - - - - -- - - - - -- TYPE GI General improvements TOTAL TOTAL PROJECT PCT EXPENDED PCT EXPENDED REMAINING PROJ ALLOCATED PROJECT EXPENDED EXP CIB EST THIS EXP THIS ALLOCATED NO PROJECT TITLE --------------------------------------------------------------------------------------------------------------------------------------- BUDGET COST EST TO DATE PTD THIS FY YEAR YTD MONTH BUDGET MANAGEMENT INFO SYSTEMS 8195 INFO TECHNOLOGY DEVELOPMT 6,646,000 5,485,000 6,017,285 91 1,100,000 983,480 89 6,454 628,715 8227 GDI TREATMENT PLANT 500,000 525,800 222,444 45 150,000 1,496 1 0 277,556 8232 GDI /SMMS REPLACEMENT 750,000 833,000 251,148 34 450,000 163,453 36 0 498,852 SUB -TOTAL 7,896,000 6,843,800 6,490,877 82 11700,000 1,148,429 68 6,454 1,405,123 PROJECTS 8207 GENERAL SECURITY ACCESS 60,000 73,000 47,616. 79 10,000 0 0 0 12,384 8217 CAP IMP PLAN 6, BUDGET 753,000 1,021,000 729,429 97 90,000 87,791 98 0 23,571 8223 DISTRICT PROP SAFETY IMP 219,000 174,000 198,912 91 60,000 165,532 309 0 20,088 8225 IMHOFF TRIANGLE DEVLPMENT 63,000 55,100 43,545 69 5,000 0 0 0 19,455 8226 SEISMIC IMPROVEMENTS HOB 5,716,000 5,221,000 3,209,358 56 1,800,000 2,423,961 135 165,272 2,506,642 8229 MARTINEZ EASEMENT ACQUIS 130,000 144,000 114,576 88 5,000 1,340 27 0 15,424 8230 CAPITAL LEGAL SERVICES 210,000 465,000 74,531 36 70,000 12,924 19 0 135,469 8233 CSOD FACILITY IMPROVEMENT 137,000 350,000 136,884 100 30,000 136,884 456 41,157 116 8234 BOB IMPROVEMENTS 234,000 1,385,000 159,555 68 160,000 159,555 100 0 74,445 9999 CAPITAL PROJECT CLEARING 0 36,500 2 0 1,000 0 0 0 2- SUB -TOTAL : 7,522,000 9,924,600 4,714,408 63 2,231,000 3,007,987 135 206,429 2,807,592 SUBSTANTIALLY COMPLETE 8513 2012 -13 EQUIP 6 VEHICLES 956,654 956,654 804,830 84 956,654 804,830 84 0 151,824 SUB -TOTAL : 956,654 956,654 804,830 84 956,654 804,830 84 0 151,824 COMPLETED PROJECTS 8210 KIEWIT PARCEL DEVELOPMENT 147,528 147,528 147,529 100 0 11,367 0 0 1- 8219 HOB IMPROVEMENTS 781,916 781,916 781,916 100 0 153,040 0 0 0 8221 POD IMPROVEMENTS PROGRAM 150,901 150,903 150,903 100 0 21,659 0 0 2- 8224 DIST RENTAL PROPERTY IMP $69,496 569,496 569,496 100 0 529,056 0 0 0 8228 DISTRICT EASEMENT ACQUIS 740,018 740,018 740,022 100 0 332,281 0 0 4- 8231 SEISMIC IMPS - RENTAL PROP 375,823 375,823 375,821 100 0 309,472 0 0 2 8512 2011 -12 EQUIP s VEHICLES 234,874 234,874 234,874 100 0 26,215 0 0 0 SUB -TOTAL : 3,000,556 31000,558 3,000,561 100 0 1,383,090 0 0 5- UNALLOCATED AUTHORIZATIONS 1,255,720 0 PROGRAM CONTINGENCY 426,000 0 General Improvements 21,056,930 20,725,612 15,010,676 71 4,887,654 6,344,336 130 212,883 6,046,254 PREPARED 8/06/13, 13:54:54 CAPITAL IMPROVEMENT BUDGET PAGE 6 PROGRAM /GM185L4 1001 OF FISCAL YEAR ELAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: ______________________________________________ TYPE RW Recycled Water ___ __________________ _________. TOTAL TOTAL PROJECT PCT EXPENDED PCT EXPENDED REMAINING PROD ALLOCATED PROJECT EXPENDED EXP CIB EST THIS EXP THIS ALLOCATED NO PROJECT TITLE BUDGET COST EST TO DATE PTD THIS FY YEAR YTD MONTH BUDGET URBAN LANDSCAPING 7259 RECYCLED WATER PLANNING 1,657,500 1,759,000 1,456,283 88 105,000 371,222 354 0 201,217 7261 RW CATHODIC PROTECTION 20,000 34,700 - 10,084 SD 5,000 0 0 0 9,916 7279 CONCORD NAVAL WEAPONS REW 280,000 321,000 264,153 94 5,000 13,879 278 0 15,847 7299 CONCORD LANDSCAPE PROJECT 3,915,000 4,336,000 2,218,429 57 3,060,000 1,933,246 63 1,574 1,696,571 7300 REFINERY RECYCLED WATER 150,000 406,100 56,344 38 100,.000 50,271 50 0 93,656 SUB -TOTAL : 6,022,500 61856,800 4,005,293 67 3,275,000 2,368,618 72 1,574 2,017,207 COMPLETED PROJECTS 7303 RW LINE CONCO /MALTBY RPR 179,729 179,731 179,731 100 0 156,264 0 0 2- SUB -TOTAL : 179,729 179,731 179,731 100 0 156,264 0 0 2- UNALLOCATED AUTHORIZATIONS 16,229- 0 PROGRAM CONTINGENCY 208,500 0 Recycled Water 6,394,500 7,036,531 4,185,024 65 3,275,000 2,524,882 77 1,574 2,209,476 GRAND TOTAL 83,048,230 138,026,637 63,259,078 0 27,389,654 26,758,648 0 843,992 19,789,152 PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 1 PROGRAM /GM185L3 100°% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING 6 J_S _ /� � _____________________________ __ --- ----- -- -- -- ---- ----- -- -- - -- -- -- DEPARTMENT 1100 FINANCE & ACCOUNTING - _____________________ TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROD ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE -`--- ---- -- --- ---- --- - ----------- --- BUDGET -- ------------- COST EST ------------- TO DATE -- --- ---- - ----- PTD -- -- --- FY YEAR - ----- - -- --- MONTH - -- -- -------- BUDGET - --- - -- -- ---- 8207 GENERAL SECURITY ACCESS 60,000 73,000 47,616 79 0 0 12,384 8223 DISTRICT PROP SAFETY IMP 219,000 174,000 198,912 91 185,532 0 20,088 8512 2011 -12 EQUIP & VEHICLES 234,874 234,874 234,874 100 26,215 0 0 8513 2012 -13 EQUIP & VEHICLES 956,654 956,654 804,830 84 804,830 0 151,824 9999 CAPITAL PROJECT CLEARING 0 36,500 2 0 - 0 0 2- DEPARTMENT 1100 TOTALS 1,470,528 1,475,028 1,286,234 88 1,016,577 0 184,294 0 PREPARED 8/06/13, 13:54:38 PROGRAM /GM185L3 CENTRAL CONTRA COSTA SANITARY DISTRICT CAPITAL PROJECT LISTING BY COST CENTER 100: OF YEAR LAPSED PERIOD ENDING: 6J Q f/3 --- -- - - - --- s7 J --------------------------------------------------- ACCOUNTING PAGE 2 PERIOD 13/2013 ------------------------------------------ DEPARTMENT 1400 PURCHASING ---------- -- --- --- TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE -------------------------------------------- BUDGET ------ COST EST -- -- ------ ------ TO DATE --- --- - -- - ---------------- PTD FY YEAR -- ---- --- -------- MONTH -- ---- - BUDGET - - - -- - - --- -- -- 8225 IMHOFF TRIANGLE DEVLPMENT 63,000 55,100 43,545 69 0 0 19,455 DEPARTMENT 1400 TOTALS 63,000 55,100 43,545 69 0 0 19,455 9 PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 3 PROGRAM /GM18SL3 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -------------------- PERIOD ENDING: 6130113 - - - --- ----------------------- - DEPARTMENT 1840 MANAGEMENT INFO SYSTEMS ------------------------ TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE BUDGET -------- -- --- -- -- ---- ---- -- ----- - - - ---- - - -- --- COST EST --- - --------------------------------------------- TO DATE PTD FY YEAR -------------- MONTH --- ------- BUDGET - - - - -- - - -- 8195 INFO TECHNOLOGY DEVELOPMT 6,646,000 5,485,000 6,017,285 91 983,480 6,454 628,715 DEPARTMENT 1840 TOTALS 6,646,000 5,485,000 6,017,285 91 983,480 6,454 628,715 73 PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 4 PROGRAM /GM185L3 100$ OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT -- ----- -- ------ --- ----- PERIOD ENDING: J - - -- -- DEPARTMENT 2042 SERVICES (ES) - / - -- - - --' --- - - - - -- - -- - - - - -- -- -- ---- --- -- TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE ---------------------------- ------ BUDGET ------ ------ --- COST EST ----- - --- - -- -- TO DATE --- ---- --- ----- PTD ----- - - - --- FY YEAR ----------------------------------------- MONTH BUDGET 5773 SMITH ROAD CAD 121,000 0 53,914 45 53,914 0 67,086 5937 ALHAMBRA VALLEY ASSMT DST 200,000 134,.600 129,002 65 3,479 0 70,998 5965 COLLECTION SYSTM PLANNING 1,219,494 1,219,494 1,219,492 100 131,548 0 2 5967 A -LINE EASEMENT ACQUIS P2 1,356,788 1,356,788 1,356,786 100 18,935 0 2 5993 FORCEMAIN ASSESSMENT 127,000 177,000 79,257 62 17,825 0 47,743 6476 SUNNYBROOK ROAD CAD 156,744 156,744 156,744 100 17,538 0 0 6513 ST. MARY'S ROAD CAD 386,660 386,660 386,660 100 386,660 0 0 7256 ALTERNATIVE ENERGY STUDY 706,240 706,240 706,242 100 63,180 0 2- 7259 RECYCLED WATER PLANNING 1,657,500 1,759,000 1,456,283 88 371,222 0 201,217 7279 CONCORD NAVAL WEAPONS REW 280,000 321,000 264,153 94 13,879 0 15,847 7287 TP MASTER PLAN UPDATE 467,000 356,700 368,979 79 117,242 0 98,021 7299 CONCORD LANDSCAPE PROJECT 3,915,000 4,336,000 2,218,429 57 1,933,246 1,574 1,696,571 7300 REFINERY RECYCLED WATER 150,000 406,100 56,344 38 50,271 0 93,656 7301 TREATMENT PLANT PLANNING 1,666,000 3,233,.600 1,103,446 66 1,064,836 19,675 562,554 8217 CAP IMP PLAN & BUDGET 753,000 1,021,000 729,429 97 87,791 0 23,571 8221 POD IMPROVEMENTS PROGRAM 150,901 150,903 150,903 100 21,659 0 2- 8228. DISTRICT EASEMENT ACQUIS 740,018 740,018 740,022 100 332,281 0 4- 8229 MARTINEZ EASEMENT ACQUIS 130,000 144,000 114,576 88 1,340 0 15,424 8230 CAPITAL LEGAL SERVICES 210,000 465,000 74,531 36 12,924 0 135,469 8403 BUCHANAN AIR PUMP ST REPL 50,000 451,000 83 0 83 0 49,917 8416 2012 -13 DEVELPMNT SEWERAG 822,990 822,990 822,995 100 822,995 0 5- 8417 SURVEY MONUMENT INSTALL 50,000 500,000 50,700 101 50,700 2,508 700 - DEPARTMENT 2042 TOTALS 15,316,335 18,844,837 12,238,970 80 5,573,548 23,757 3,077,365 �'Y PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 5 PROGRAM /GM185L3 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: _ 3 ----------------------------- DEPARTMENT 2541 MANAGEMENT (CP) -_- --------- --- ------ --- ----- ---------------------- TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE --- ---- -- - ----- --- -- - ---- -- - -- - -- BUDGET - ----- -- - - COST EST -- - - - --- - - -- --- TO DATE -- -- --- - - ----- -- PTD ------ ------- FY YEAR - ---- ----- MONTH -- - - ----- - - BUDGET - - ----------- 8210 KIEWIT PARCEL DEVELOPMENT 147,528 147,528 147,529 100 11,367 0 1- DEPARTMENT 2541 TOTALS 147,528 147,528 147,529 100 11,367 0 1- 7s PREPARED 8/06113, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 6 PROGRAM /GM185L3 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT - - I ? PERIOD ENDING: '-ho L J - -- ---- -- - - - - --- --- ------- - -- DEPARTMENT 2547 DESIGN / CONTTR GROUP - -- IV CP - - -- -- -- ---- - --- --- - - - - -- - - -'- - -- -- -- - ---° TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO - --- --- PROJECT TITLE -- - -- ---- - -- ---- - - -- - - - ----- BUDGET -- ------- COST EST --- ------ - - ---- TO DATE - --- ---------- PTD ---- -- - FY YEAR -- - - ----- -- - -- MONTH - - ---- ----- BUDGET - --- -- -- - -- - -- 5948 SEWER TV INSPECTION, PH2 1,200,000 8,401,000 1,129,628 94 329,108 1,304 70,372 5955 SUSPENDED PIPE SUPPORT 392,000 274,000 186,237 48 117,099 1,415 205,763 5962 MANHOLE REMOT LVL MONITOR 250,000 325,500 130,933 52 55,208 0 119,067 5973 NO ORINDA SEWER REN PH 4 2,589,000 2,589,000 2,579,690 100 1,582,614 0 9,310 5976 DIABLO RENOVATIONS PH2 700,000 2,736,000 706,892 101 631,226 0 6,892- 5982 PIPE BURST BLANKET 828,000 623,500 362,415 44 38,738 0 465,585 5987 CS CATHODIC PROT SYS REPL 349,392 349,392 349,393 100 117,635 0 1- 5989 S ORINDA SEWER REN PHS 2,904,199 2,167,800 2,904,206 100 10,635 0 7- 5991 P.H. SEWER RENOV PH 2 400,000 2,383,300 133,017 33 0 0 266,983 5992 W CREEK SEWER REN, PH 8 2,104,896 2,030,000 2,104,898 100 1,003 0 2- 5995 SR AND MTZ BYPASS PUMPS 55,000 74,000 44,391 81 118 0 10,609 5999 CIPP BLANKET CONTRAST 92,200 213,000 47,303 51 44,069 1,460 44,897 6003 SR PUMPING STATION UPGRAD 402,000 458,000 370,798 92 318,215 0 31,202 7241 WET WEATHER BYPASS IMPS 3,320,000 3,320,000 3,277,386 99 8,915 0 42,614 7254 TP CATHODIC PROT SYS REPL 600,000 600,000 540,670 90 13,285 0 59,330 7255 PRIMARY STRUCTURE DEMO 1,537,102 1,537,102 1,537,099 100 600,791 0 3 7261 RW CATHODIC PROTECTION 20,000 34,700 10,084 50 0 0 9,916 7265 TP EQUIPMENT REPLACEMENT 1,250,000 1,202,000 1,021,806 82 286,145 4,244 228,194 7268 TP FACILITIES RENOV 250,000 3,950,000 220,016 88 28,711 0 29,984 7269 TP ASSET MANAGEMENT 1,184,000 964,100 660,753 56 36,208 0 523,247 7272 ELECTRIC BLOWER RENOV 474,000 1,447,400 422,329 89 0 0 51,671 7276 PIPING RENOVATIONS, PH 5 2,484,926 2,484,926 2,484,924 100 1,382 0 2 7283 FIRE PROT SYS IMPRVMT 318,000 358,000 180,394 57 152,414 52,148 137,606 7284 TP HAZARD ID /REMEDIATION 125,000 868,000 117,821 94 4,591 0 7,179 7285 PRIMARY TREATMENT RENOV 4,460,000 13,500,000 1,276,276 29 944,041 1,467 3,183,724 728 PIPING RENOV PH 6 2,267,250 2,267,250 2,267,259 100 293,803 0 9- 7289 POB SEISMIC UPGRADE 190,000 1,297,100 135,741 71 15,624 0 54,259 7290 OUTFALL IMPROVEMENTS -PH 6 3,525,608 3,525,608 3,525,615 100 2,747,870 0 7- 7291 PUMP /BLOWER SEISMIC UPGRD 405,000 3,800,000 295,815 73 37,367 3,221 109,185 7292 SWITCHGEAR REFURBISHMT -P2 300,000 1,536,500 106,759 36 5,286 0 193,241 7294 SEC PROCESS IMPS 50,000 1,429,500 47,403 95 14,107 0 2,597 7295 AUX BOILER BURNER UPGRADE 215,000 230,000 139,216 65 88,742 910 75,784 7296 SEISMIC UPGRADES FOR SCB 150,000 133,700 137,690 92 10,057 0 12,310 7297 WET /DRY SCRUBBER REPLCMT 25,000 6,622,000 964 4 110 0 24,036 7298 PIPING RENOVATION, PH7 1,417,000 1,016,000 1,298,472 92 1,236,182 158,730 118,528 7302 PE PUMP REFURB, PH 2 25,000 70,000 16,843 67 6,575 0 8,157 7303 RW LINE CONCO /MALTBY RPR 179,729 179,731 179,731 100 156,264 0 2- 7309 DAF TANKS RENOVATION 100,000 100,000 7,475 8 7,475 0 92,525. 8219 HOB IMPROVEMENTS 781,916 781,916 781,916 100 153,040 0 0 8224 DIST RENTAL PROPERTY IMP 569,496 569,496 569,496 100 529,056 0 0 6226 SEISMIC IMPROVEMENTS HOB 5,716,000 6,221,000 3,209,358 56 2,423,961 165,272 2,506,642 8231 SEISMIC IMPS - RENTAL PROP 375,823 375,823 375,821 100 309,472 0 2 8233 CSOD FACILITY IMPROVEMENT 137,000 350,000 136,884 100 136,884 41,157 116 8234 HOB IMPROVEMENTS 234,000 1,385,000 159,555 68 159,555 0 74,445 8401 WC SEWER RENOV PH9 3,088,000 3,088,000 3,043,972 99 2,474,624 153,180 44,028 8404 LAFAYETTE SEWER RENOV PH8 2,304,500 2,619,000 1,234,787 54 926,805 215,113 1,069,713 8405 2013 CIPP PROJECT 1,010,000 4,928,000 717,078 71 577,681 0 292,922 8407 MARTINEZ BYPASS PUMP 200,000 78,500 91,684 46 89,225 0 108,316 8410 CATHODIC PROT SYS REPL 200,000 1,000,000 6,864 3 6,864 0 193,136 191 PREPARED 8/06/13, 13:54 :38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 7 PROGRAM /GM1851,3 10016 OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT / PERIOD ENDING: (p /A a� /? .2 lL�a --------------- -- ------- ------- -- ---- DEPARTMENT 2547 DESIGN / CONTTR GROUP - - - - -- IV CP ---- - — -------- ----- - ----- — ---------------------------- TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE - ------------ --- -- ---- ----- - -- — -- ------ BUDGET - - - - -- COST EST — ------------------------------------------------ TO DATE PTD FY YEAR ------ - MONTH -- ---- --- ------ BUDGET --- ------ - -- -- 8411 NO.ORINDA SEWER REN. PH 5 450,000 2,650,000 455,270 101 - 447,732 14,160 5,270- 8412 PH GRAYSON CREEK TRUNK SW 590,000 2,900,000 388,975 78 381,089 0 111,025 8413 WCK SEWER REN., PH 10 329,000 2,600,000 273,694 83 273,694 0 55,306 6414 MOR PUMPG ST.CHOPPER PUMP 100,000 400,000 19,964 20 19,964 0 80,036 8415 MARTINEZ PH 4 SEWER REN. 150,000 2,060,000 26,357 18 26,357 0 123,643 8418 COL.SYS. MODELING UPGRADE 100,000 550,000 11059 1 1,059 0 98,941 DEPARTMENT 2547 TOTALS 53,385,037 107,654,844 42,451,076 80 18,878,675 813,781 10,933,961 PREPARED 8/06/13, 13:54 :38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 8 PROGRAM /GM185L3 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: - 6 �� h �/ - - - -- - - -- - -- - - -- -- -- - -- --- -------------------------------- ------- DEPARTMENT 2555 ENGINEERING SUPPORT ----------- (CP) ---- --- - ---- TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE -- -- - --------- -- -- --------- -- ----- -- BUDGET -- - - -- ---- COST EST - - --- - -- - ---- TO DATE --- ----- ---- -- -- PTD --- --- -- - FY YEAR --------- ----- MONTH ------ -- -- ---- BUDGET - -- -- -- - - -- --- 8227 GDI TREATMENT PLANT 500,000 525,800 222,444 45 1,496 0 277,556 8232 GDI /SMMS REPLACEMENT 750,000 833,000 251,148 34 163,453 0 498,852 DEPARTMENT 2555 TOTALS 1,250,000 1,358,800 473,592 38 164,949 0 776,408 PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 9 PROGRAM /GM185L3 1001 OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 012 bj------------------------------------------------------ ---- - -- J 3 -------------------------------------------------------------- DEPARTMENT 4276 PROCESS CONTROL - TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROJ ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE ----------------------- ---- ---- -- ---- ---- BUDGET ----- COST EST -- -- - --- — ---------------------------------------------------------------------------- TO DATE PTD FY YEAR MONTH BUDGET 7304 INSTR & CNTRL -PLC UPGRADE, 60,000 800,000 38,720 65 38,720 0 21,280 DEPARTMENT 4276 TOTALS 60,000 800,000 38,720 65 38,720 0 21,280 PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING BY COST CENTER PAGE 10 PROGRAM /GM185L3 100°% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING_ 613b 13 ---------------------------------------------------- -------------------- - - - - -- - DEPARTMENT 4486 MAINTENANCE ENGINEERING TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROS ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE ------------------------------------------------ BUDGET COST EST -- ---- ---------- TO DATE ----- - - - --- - - PTD -- --- -------- FY YEAR -- - --- - --------------------------------- MONTH BUDGET 7308 COGEN RENOVATION 100,000 800,000 1,823 2 1,823 0 98,177 DEPARTMENT 4486 TOTALS 100,000 800,000 1,823 2 1,823 0 98,177 m PREPARED 8/06/13, 13:54:38 CAPITAL PROJECT LISTING SY COST CENTER PAGE 11 PROGRAM /GM185L3 100% OF YEAR LAPSED ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT- PERIOD ENDING_- L�� 0 13---------------------------------------------------- -------------------------------- - - DEPARTMENT 5093 PUMP STATIONS - - -- - - - TOTAL TOTAL EXPENDED PCT EXPENDED EXPENSED REMAINING PROD ALLOCATED PROJECT PROJECT EXP THIS THIS ALLOCATED NO PROJECT TITLE - - --- --- -- -- ---- -- - --------------------------------------------------------------------------------------------------------------- BUDGET COST EST TO DATE PTD FY YEAR MONTH BUDGET 5941 PS EQUIP & PIPING REPL 640,000 845,500 547,824 86 77,029 0 92,176 8406 PUMP STATION SAFETY IMPS 60,000 540,000 0 0 0 0 60,000 8409 PS SCADA O &M MANUAL 20,000 20,000 12,480 62 12,480 0 7,520 DEPARTMENT 5093 TOTALS 720,000 1,405,500 560,304 78 89,509 0 159,696 GRAND TOTALS 79,158,428 138,026,637 63,259,078 80 26,758,648 843,992 15,899,350 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS JUNE, 2013 AUDIT WORKPAPER - C12 (4) 53,692,910 54.700.000 (5,000.000) 49.700.000 49,709.334 100.00% 10,200.10 85,610.50 95,810.60 (3) (5) (6) (0.03) 32,520.50 32,520.47 10, 200.07 118.131.00 128.331.07 NOTE: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The yield as of June, 2013 was 0.244 %. Q (3) The face value indicates the value of the investment if held until maturity, which is the usual District practice. y (4) The weighted average yield of the total Sewer Construction portfolio is 0.2347 %. (5) The market value of the portfolio on June 30, 2013 was $49,709,334. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. (6) The District has sufficient funds to cover six months of cash flow needs. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M. % of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE (MATURITY) FACE VALUE MKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAIF 8/86 -2/90 — 1 (1) 39,200,000 40,200,000 0 39,200,000 39,210,710 78.87% 7,968.44 78,613.82 86,582.26 (1,000,000) 893 UBS Comm Pa 12/21112 06/21113 0 0.285 3,994,237 4,000,000 (4,000,000) 0 0.00% 633.33 5,130.01 5,763.34 894 BNP Paribas YCD 04/26/13 07126/13 26 0.240 3,500,000 3,500,000 3,500,000 3,500,190 7.040/6 723.33 816.67 1,540.00 895 Union Bank of Ca. NCD 04/26113 07/26113 26 0.150 3,500,000 3,500,000 3,500,000 3,499,945 7.04% 437.50 525.00 962.50 896 Bank of Nova Scotia Comm Pa 04/26/13 07/26113 26 0.150 3,498,673 3,500,000 3,500,000 3,498,488 7.04°A 437.50 525.00 962.50 (4) 53,692,910 54.700.000 (5,000.000) 49.700.000 49,709.334 100.00% 10,200.10 85,610.50 95,810.60 (3) (5) (6) (0.03) 32,520.50 32,520.47 10, 200.07 118.131.00 128.331.07 NOTE: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The yield as of June, 2013 was 0.244 %. Q (3) The face value indicates the value of the investment if held until maturity, which is the usual District practice. y (4) The weighted average yield of the total Sewer Construction portfolio is 0.2347 %. (5) The market value of the portfolio on June 30, 2013 was $49,709,334. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. (6) The District has sufficient funds to cover six months of cash flow needs. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. PREPARED 8/07/13, 14:00:36 2013 STATEMENT OF NET ASSETS PAGE 5 PROGRAM /GM263L ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT AS OF 6/,40/ 13 ------------------------------------------------------------------------------------------------------------------------------------ 003 SELF-INSURANCE -------------------------------------------------------------------------------------------------------------------------------------- 1,427,333.42 - CURRENT ASSETS .00 CASH 72,273.62 TEMPORARY INVESTMENTS 3,800,000.00 ACCRUED INTEREST AIR 2,348.71 SUBROGATION RECOVERY AIR 968,301.12 DUE FROM R/E 1,667,479.30 DUE FROM SIC 33,460.76 DUE FROM DEBT FUND .00 TOTAL ASSETS -------------- 6,543,863.51 LIABILITIES DUE TO R/E 1,763,763.66 - DUE TO SIC 43,026.09 - DUE TO DEBT FUND .00 ACCOUNTS PAYABLE 54,432.96 - SALES TAX PAYABLE .00 GASBID ACTUARIAL RESERVE 1,000,000.00 - UNEARNED INTEREST .00 UNAMORTIZED DISCOUNT .00 TOTAL LIABILITIES 2,861,222.71- FUND EQUITY RESERVE FOR ENCUMBRANCES .00 GENERAL LIABILITY .00 EMPLOYMENT/POLLUTION RISK 2,400,000.00- INS PREMS/CLAIMS/LAWSUITS 1,427,333.42 - AVAILABLE FUND BALANCE .00 EXPENDITURE SUMMARY 2,380,466.36 REVENUE SUMMARY 2,235,773.74- TOTAL FUND EQUITY 3,682,640.80 -------------- TOTAL LIABILITIES AND FUND EQUITY 6,543,863.51- PREPARED owvvzvo, m.sr.zz comrmL com,R` COSTA SAmzT^ox ozsTnzcr PAGE � rxoavAM. GMno`L vccoomT BALANCE LIST 2013 FROM ^ccoomr. 03-0000-300.00-00 rouo ^ccvnmT. 03-0000-399.99-99 --- — -- ' —' �m�' ----------'------ DESCRIPTION --' -- —' -- BUDGET — —'------ ----'--' ACTUAL — --' '— — -- BALANCE ------' —'-----'--'------ 003'0000'301.45'01 zmTouos` --------------'—'----'---'——--'--'—'-----'— 4,000 .00 3,313.84 686 -16 003-0000-301.73 -01 soa000Arznm aocvvouzou 003-0000-301.74-01 comrozonTzom FROM nm^ 003-0000-302.45-01 rmroaEar 9,600 .00 7,952 .83 1,647-17 003-0000-302.73-01 soamoovrzow oscovouzoo 003-0000-302.74-01 comTazonTzom FROM oay 003-0000-303.45-01 zwroaooT 4,900 .00 ^.noz.,u v,o�oz 003-0000-303.73-01 a00000xTrnm aEzovEarEo 1,349,321 .96 1'349.321.96 003-0000-303.74-61 comTnzsnTzom FROM oue 850,000 .00 850.000,00 003-0000-303-75-01 zmaouANcE ,oco"oor xvw 31,500 -00 21'183.13 10,316 .87 TOTALS: 900.000.00 2.235'773.74 1,335,773 .74- dol.l-.2013 )c4f- friSaraACe- e7 en en c� PREPARED 08/07/2013, 10:57:36 CENTRAL CONTRA COSTA SANITARY DISTRICT PAGE 1 PROGRAM: GM365L ACCOUNT BALANCE LIST 2013 FROM ACCOUNT: 03-0000-900.00-00 THRU ACCOUNT: 03-0000-999.99-99 ------------ - -- --------------------------------------------- ACCOUNT DESCRIPTION -- -- - --- - ---------------- BUDGET ------------------- ACTUAL - -- --------- - ------- - ------- BALANCE ------------------------------------------------------------------------------------------------------------------------------------ 003-0000-991.14-20 LOSSES 250,000.00 59,969.31 190,030.69 003-0000-991.14-21 LEGAL SERVICES 15,000.00 34,178.34 19,178.34- 003 -0000- 991.14 -22 TECHNICAL SERVICES 40,000,00 24,856.09 15,143.91 003-0000-992.14-20 LOSSES 003-0000-992.14-21 LEGAL SERVICES 235,000.00 223,241.96 11,758.04 003-0000-992.14-22 TECHNICAL SERVICES 60,000.00 60,000.00 003-0000-993.14-20 LOSSES 381,020.84 381,020.84- 003- 0000- 993.14 -21 LEGAL SERVICES 10,000.00 9,480.17 519.83 003-0000-993.14-22 TECHNICAL SERVICES 5,000.00 5,000.00 003-0000-993.14-23 LIABILITY INSURANCE 375,500.00 302,572.82 72,927.18 003-0000-993.14-24 PROPERTY INSURANCE 100,000.00 121,845.71 21,845.71- 003 -0000- 993.14 -25 INSURANCE CONSULTING SVS 5,000.00 5,000.00 003-0000-993.14-26 CLAIMS ADJUSTMENT 1,500.00 1,218,301.12 1,216,801.12- TOTALS: 1,097,000.00 2,380,466.36 1,283,466,36- muI'll, m CENTRAL CONTRA COSTA SANITARY DISTRICT SELF - INSURANCE FUND TEMPORARY INVESTMENTS JUNE, 2013 AUDIT WORKPAPER - C12 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M % of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE (MATURITY) FACE VALUE MARKET VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAW 10199- -- 1 (1) 3,800,000 3,800,000 3,800,000 3,801,038 100.00% 762.08 10,872.70 11,634.78 (3) 3,800,000 3,800,000 0 3,800,000 3,801,038 100.00% 762.08 10,872.70 11,634.78 (2) (125.63) (125.63) 762.08 10,747.07 11,509.15 NOTE: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The yield as of June, 2013 was 0.244 %. (2) The face value indicates the value of the investment if held until maturity, which is the usual District Practice. t (3) The weighted average yield of the total Self - Insurance portfolio is 0.244 %. (4) The market value of the portfolio on June, 2013 was $3,801,038. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. PREPARED 8/07/13, 14:00:36 2013 STATEMENT OF NET ASSETS PAGE 6 PROGRAM /GM263L ACCOUNTING PERIOD 13/2013 CENTRAL CONTRA COSTA SANITARY DISTRICT AS OF 61301t3 -- ---- - - - - -- - ------- - - - - -- - --------------------------------------------------------------- ------ -- -- -- --- ------- -- - - ---- -- - - - - - -- 004 DEBT SERVICE CURRENT ASSETS DEPOSIT W /TRUSTEE - RESERVE 5,412,500.00 BOND ISSUANCE COSTS 315,286.56 REVENUE BOND RESERVE CASH 19,445.10 - ACCRUED INTEREST A/R 36,484.28 DUE FROM R/E 54,365,590.62 DUE FROM SIC 744,818.33 DUE FROM S/I .00 TOTAL ASSETS 60,855,234.69 LIABILITIES DUE TO R/E 187,119.25 - DUE TO SIC 15,488,141.62 - DUE TO S/I .00 ACCOUNTS PAYABLE .00 UNEARNED INTEREST .00 RECYCLED WATER LOAN 866,827,15 - BONDS PAYABLE 43,595,000.00 - BOND ACR INTEREST PAYABLE 718,146.67 - DEFERRAL -BOND REFUNDING .00 TOTAL LIABILITIES 60,855,234.69 - FUND EQUITY RESERVE FOR ENCUMBRANCES .00 AVAILABLE FUND BALANCE 3,765,411.19 EXPENDITURE SUMMARY 1,802,084.60 REVENUE SUMMARY 5,567,495.79 - TOTAL FUND EQUITY .00 TOTAL LIABILITIES AND FUND EQUITY 60,855,234.69- PREe^noo vo/oo/zozs. 13.57.19 comzaaL comTuA COSTA svazTAR, ozorazrr vvoo z ,ovoaAM. owao,L AccvomT BALANCE LIST aoz` FROM vccvnmT. 04-0000-300-00-00 z,nv uCconwT. 04-0000-300.99-99 —— ----' ACCOUNT ----' -- ---'—'--'-----' DESCRIPTION --' -----'------'--- BUDGET ACTUAL -------— BALANCE '----'-----'--------'---------'--'----------------'------------ 004-0000-300.23-00 uovoa SVr caos'coomTx 004-0000-300.45-52 nuc,c a20 Lo^m zmr zmcoyo 004-0000-300.45-53 zvoy oouo zmzonEaT zmcmxu 217,630 .00 zv',so re 189,093 .21 004-0000-300.46-00 TAX REVENUE 5'349'866.00 5,538,959 .00 189.0e3.00 TOTALS. 5'567'496.00 S,567,495 .79 zz pREs^noo on/oa/zozs' 13.sn.03 CENTRAL comTu^ cooTx SANITARY ozoTazcT PAGE I p^nGn^m. GM365L xccoUmT ovL^mcE LIST 2013 FROM *ccno*T. 04-0000-888.00-00 zHoo ^CcovmT. 04-0000-888,99-95 — — --—'—'---'--'----- — ACCOUNT DESCRIPTION — --'------ —'-- BUDGET ------------'---'— ACTUAL ----- ----' ----'''—'--'------- BALANCE -------' ---'—'--' --'- -----'--------' 00*'0000'on8 zz',z mEcxc xau zmTEooaz oxp — 26,70B.00 26,708 .19 �19' 004'0000'888.12'53 zove oomo DEBT oxro^oE 1.775.37o vv 1.77s.376,41 .41' TOTALS: 1,802,084 .00 1,802,084 .60 oo'