Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
06.b. New version of Monthly Financial Statements
60bo Central San January 18, 2017 TO: FINANCE COMMITTEE VIA: ROGER S. BAILEY, GENERAL MANAGER PHIL LEIBER, DIRECTOR OF FINANCE & ADMINISTRATION FROM: CHRIS THOMAS, FINANCE ADMINISTRATOR SUBJECT: NEW VERSION OF MONTHLY FINANCIAL STATEMENTS The District has recently entered into an agreement with LPA Software Solutions to assist in the implementation of Cognos BI which is report writing software. This tool is to be used to help various divisions extract data from Sun,gard and present it in an easily consumable fashion to management, committee members, and the Board. After several months of working with LPA, the Finance division would like to present updated versions of the following financial statements: 1. Balance Sheet 2. Revenue Report (Month-to-Date and Quarter-to-Date) 3. Expense Report— District Summary (Month-to-Date and Quarter-to-Date) 4. Expense Report— By Department (Month-to-Date and Quarter-to-Date) 5. Expense Report— By Division (Month-to-Date and Year-to-Date) Please review these reports and communicate any changes or improvements you would like to be implemented to the Finance division. CT CENTRAL CONTRA COSTA SANITARY DISTRICT January 12, 2017 TO: THE BOARD OF DIRECTORS VIA, THEA VASSALLO > FROM: JAMIE KING SUBJECT: O&M Variance Analis The following are brief year-to-date variance explanations through period ending December, 2016: YTD YTD Favl(Unfav) 0&M Revenues: Budgeted Actual Variance Explanation The percentage of sewer service charge received in the first installment in December varies year to year. We budgeted 55%this year for the first installment. The actual amount received was 52.9% resulting in an unfavorable variance. We anticipate to receive a larger than budgeted Total 41,140,138 40,455,831 (684:30 7) percentage in April- 0& M Expenses(variances>$100K): Total Labor Charges 333476,238 31,776,669 1,699,569 Expenses are typically lower in the beginning of the year. Some positions budgeted are filled later in the fiscal year resulting in savings. Chemicals 924,992 812.192 112,800 Chemical is purchased sporadically throughout the year rather than monthly I -end. as is budgeted. The variance should be reduced by year Repairs &Maintenance 2,146,708 1,660,542 486,166 Lower due to major expenses are typically incurred in the spring time while budget is spread out throughout the year. Professional& Legal Svc 306,243 163,158 143,085 Delay in legal bills in addition to budgeted legal expenses not yet incurred. Outside Services 1,9261991 1,389,922 537,069 Mainly due to Technical Services expense being lower than budgeted thus far in the fiscal year. Materials&Supplies 1,025,154 912?067 113,087 All line items with the exception of Operating Supplies have been underspent thus far. We anticipate the usage to be higher in the second half of the fiscal year. All Other 4,6611178 4,542,838 118,340 Multiple account categories. Lower than budgeted expenses thus far for Utilities, Hauling& Disposal, and Other Expenses. Total 44,467,504 41,257P388 31210)116 CENTRAL CONTRA COSTA SANITARY DISTRICT January 12, 2017 TO- THE BOARD OF DIRECTORS VIA: THEAVASSALLOC— FROM- JAMIE KING /it le SUBJECT.- Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending December 31, 2016- S/C Revenues: YTD YTD Fav/(Unfav) Budgeted Actual Variance Explanation The percentage of property tax received in December is lower than what was budgeted for the first installment resulting in a negative variance. We anticipate the second Total 16,322,686 141707,672 (1,615,014) installment in April to be greater than budgeted. S/C Expenses: FY YTD FY Budget Actual Remaining % Spent Total 3618081756 151710?121 21,098,635 Excludes 15116 carry-over($3,084,886) Central Contra Costa Sanitary District Protecting publk heafth and the environment Balance Sheet Fund:001-RUNNING EXPENSE December 2016 Fiscal Period 6/2017 Summarized by Account Report Generated on Jan 11,2017 2:27.-08 PM Page 1 TOTAL ASSETS Current Assets CASH ACCOUNTS I CASH $660,243.54 CASH ACCOUNTS I PAYROLL CLEARING $22.972-82 CASH ACCOUNTS I PETTY CASH $3,400-00 DUE FROM I DUE FROM S,'C S68,037,095.38 DUE FROM i DUE FROM 811 $920,000.00 INVENTORY/SUPPLIES&MATERIAL INV $2,051.552-94 PREPAID ACCOUNTS i PREPAID CAFETERIA PLAN $46:103,79 PREPAID ACCOUNTS i PREPAID EXPENSES S969,137.15 PREPAID ACCOUNTS I PREPAID INSURANCE $11,437.00 PREPAID ACCOUNTS I PREPAID RETIREMENT S 12.746.082 57 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $857,248.04 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $219,401,06 RECEIVABLE ACCOUNTS I ACCOUNTS RECEIVABLE-COBRA $4,808.87 RECEIVABLE ACCOUNTS I COMPUTER PURCHASE PROGRAM $9,494,32 RECEIVABLE ACCOUNTS I DEPOSITS TO BANK ESCROW $100.105.35 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $3,934,50 Current Assets $86,663,017.33 Net Property,Plant and Equipment CONTRIBUTED FIXED ASSETS I ACC DEPR-CONTRI B ASSETS ($57,268,866.48) CONTRIBUTED FIXED ASSETS I CONTRIBUTED SEWER LINES $154,863,631 63 FIXED ASSETS-C.I.P.I CONSTRUCTION IN PROGRESS $24,480,981.92 FIXED ASSETS I ACC DE PR-SU I LDI NGS ($11,617.824-76) FIXED ASSETS I ACC DEPR-FUR N&EQUIP ($8,188,889-52) FIXED ASSETS/ACC DEPR-OUTFALL ($3,465,586-41) FIXED ASSETS I ACC DEPR-PUMPING STATIONS ($30,884,104.11) FIXED ASSETS/ACC DEPIR-SEWAGE COL SYS ($64,587,613.32) FIXED ASSETS/ACC DEPR-TREATMENT PLANT ($210,866,708.43) FIXED ASSETS/ACC DEPR-VEHICLES ($4,705,437.44) FIXED ASSETS I ACCUM DEPRC-RECY WATER ($8,060,810.19) FIXED ASSETS I BUILDINGS $42,412,647-95 FIXED ASSETS/FURNITURE&EQUIPMENT $12,627,565 89 FIXED ASSETS I INTANGIBLE ASSETS $4,936.407.00 FIXED ASSETS I LAND $17,320,569.91 FIXED ASSETS/OUTFALL SEWERS 511.371,573-72 FIXED ASSETS i PUMPING STATIONS $56.270.148.93 FIXED ASSETS f RECY WATER INFRASTRUCTURE 519.215,3:50.00 FIXED ASSETS f SEWAGE COLLECTION FACIL $341,412,323.21 FIXED ASSETS/TREATMENT PLANT $323,360,945-06 FIXED ASSETS I VEHICLES $7,378,730-14 Net Property,Plant and Equipment $616,005,034.70 TOTAL ASSETS $702.668,052.03 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($14,646,83) CURRENT LIABILITIES I ACCOUNTS PAYABLE ($170,331.23) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($4.406,525.42) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE (51,106.808-27) CURRENT LIABILITIES I CAFETERIA PLAN PAYABLE ($36,530.80) CURRENT LIABILITIES/M ISC DEPOSITS/LIABI LITI ES ($103.538.96) CURRENT LIABILITIES I OTHER PAYROLL WITHHOLDING ($5,15800) CURRENT LIABILITIES 1PERMIT CLEARING ($319.00) CURRENT LIABILITIES 1 REFUNDABLE DEPOSITS ($36,830.00) Central Contra Costa Sanitary District 0- M- Bala nce Sheet Fund:001-RUNNING EXPENSE December 2016 Fiscal Period 612017 Summarized by Account Report Generated on Jan 11,2017 2,27-.08 PM Page 2 CURRENT LIABILITIESI RETIREMENT CONTRI B W/H ($1.730,819.89) CURRENT LIABILITIES/WORKERS COMP INS PAYABLE 5178,359,52 DEF.COMP.CONTRIB W/H/ICMA ($2,690,46) DUE TO f DUE TO DEST FUND (S3,748,310.00) DUE TO I DUE TO SIC ($61,152.653.48) DUE TO I DUE TO Sil (5920,000.00) LIABILITIES-LONG TERM IPENSICNJIINFLOW/OUTFLOVV ($88,679,765.00) MEDICAL LIABILITIES I DELTA DENTAL (S561.70) MEDICAL LIABILITIES/DISABILITY INS ($54073) MEDICAL LIABILITIES 1HEALTH NET ($098) MEDICAL LIABILITIES I KAISER PERMANENTE ($4,308.43) MEDICAL LIABILITIES I LIFE INS ($153.37) MEDICAL LIABILITIES I OCCUPATIONAL HEALTH $3,281-04 MEDICAL LIABILITIES I POST EMP,BENEFIT-OPEB (5156.105-71) REIMBURSEMENT FEES ($116,478.31) Total Liabilities ($162,211,436.01) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE ($20,723,314.72) FUND EQUITY I CAPITAL COST SHARING (51174,214,795.51) FUND EQUITY/CONTRIBUTED SEWER LINES ($154,863,631.39) FUND EQUITY I EXPENDITURE SUMMARY $41,257,377.99 FUND EQUITY I GENERAL FIXED ASSET GROUP ($186,155,142.02) FUND EQUITY I STATE&FED CAPITAL GRANT ($75.301,27900) YEAR TO DATE REVENUES/REVENUE SUMMARY ($40.455.831.37) Total Fund Equity ($540,456,616.02) TOTAL LIABILITIES AND FUND EQUITY ($702,668.052.03) Central Contra Costa Sanitary District Protecting publfr health and the envif-onmeni Balance Sheet Fund:002-SEWER CONSTRUCTION December 2016 Fiscal Period 6/2017 Summarized by Account Report Generated on Jan 11,2017 2:27:08 PM Page 3 TOTAL ASSETS Current Assets CAD RECEIVABLE I AVAD-ALHAMBRA VLY AR $1,139,610.36 CASH ACCOUNTS I CASH $851,907.82 CASH ACCOUNTS I TEMPORARY INVESTMENTS 568,600,000.00 DUE FROM I DUE FROM DEBT FUND $3,188.570-00 DUE FROM/DUE FROM RIE $61,152,653-48 RECEIVABLE ACCOUNTS I ACCOUNTS RECEIVABLE S63.847.87 RECEIVABLE ACCOUNTS I ACCRUED INTEREST AIR $64,439.08 RECEIVABLE ACCOUNTS;CAD RECEIVABLE $252.093-97 Current Assets $135,313,122.58 Net Property,Plant and Equipment FIXED ASSETS-C.I.P.I CONSTRUCTION IN PROGRESS $15,710,105-23 Net Property,Plant and Equipment $15,710,105.23 TOTAL ASSETS $151,023,227.81 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($2,671.80) CURRENT LIABILITIES)ACCOUNTS PAYABLE ($124,492.77) CURRENT LIABILITIES I PROJECT RETENTION PAYABLE ($550,590.02) CURRENT LIABILITIES I REFUNDABLE CONST BONDS ($335,215,30) DUE TO/DUE TO DEBT FUND ($64,742,00) DUE TO I DUE TO RIE ($68,037,095,38) LIABILITIES I UNEARNED INTEREST ($208,930,58) Total Liabilities ($69,323,737.85) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($15,710,105.23) FUND EQUITY/AVAILABLE FUND BALANCE ($66,991,817-30) FUND EQUITY I EXPENDITURE SUMMARY $15710,10523 YEAR TO DATE REVENUES/REVENUE SUMMARY ($14,707,67Z66) Total Fund Equity ($81,699,489.96) TOTAL LIABILITIES AND FUND EQUITY ($151,023,227.81) Central Contra Costa Sanitary District .- Balance Sheet Fund:403-SELF-INSURANCE December 2615 Fiscal Period 612017 Summarized by Account Report Generated on Jan 11.2017 2:27:08 PM Page 4 TOTAL ASSETS Current Assets CASH ACCOUNTS J CASH $495,203.30 CASH ACCOUNTS!TEMPORARY INVESTMENTS $6,200,000.00 DUE FROM/DUE FROM RYE $920,000.00 RECEIVABLE ACCOUNTS ACCRUED INTEREST A!R $9,559.1 0 Current Assets $7,624,762.40 TOTAL ASSETS $7,624,762.40 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES 1 ACCOUNTS PAYABLE ($3,308,59) CURRENT LIABILITIES I GASB10 ACTUARIAL RESERVE (51,500,000-00) DUE TO!DUE TO RIE ($920,000.00) Total Liabilities ($2,423,308.59) Total Fund Equity FUND EQUITY 1 EMPLOYMENT/POLLUTION RISK ($5,000,000.00) FUND EQUITY 1 EXPENDITURE SUMMARY $575,535,89 FUND EQUITY 1 INS PREMS/CLAIMSILAWSUITS 5161,061.15 YEAR TO DATE REVENUES/REVENUE SUMMARY (5938,050,85) Total Fund Equity ($5,201,453.81) TOTAL LIABILITIES AND FUND EQUITY ($7,624,762.40) CinJLral Contra Costa Sanitary District 7 Balance Sheet Fund:004-DEBT SERVICE December 2016 Fiscal Period 6/2017 Summarized by Account Report Generated on Jan 11,2017 2:27-08 PM Page 5 TOTAL ASSETS Current Assets DUE FROM f DUE FROM RIE $3,748,310.00 DUE FROM I DUE FROM SIC $64.742.oc L.T.DEBT ACCOUNTING I DEPOSIT W/TRUSTEE-RESERVE $4,856,450.00 RECEIVABLE ACCOUNTS/ACCRUED INTEREST AIR $99.180.70 Current Assets $8,768,682.70 TOTAL ASSETS $8,768.682.70 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/RECYCLED WATER LOAN ($360,133.27) DUE TO/DUE TO SIC ($3,188.570.00) L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE $0.00 L T DEBT ACCOUNTING I BONDS PAYABLE ($31.500,000,00) Total Liabilities ($35,048,703.27) Total Fund Equity FUND EQUITY I AVAILABLE FUND BALANCE $29,796,882.57 FUND EQUITY I EXPENDITURE SUMMARY $231,448.00 YEAR TO DATE REVENUES IREVENUE SUMMARY ($3,748,310,00) Total Fund Equity $26,280,020.57 TOTAL LIABILITIES AND FUND EQUITY ($8,768,682.70) jjCentral Contra Costa Sanitary District ---------- Revenue Report MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 612017 Report Generated on Jan 11,2017 2-.44:47 PM Page 1 Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Sewer $38,446,334 $37,015,164 -3.7% $39,594,254 $38,748,181 -2.1% $71,100,000 $32,351,819 54.5% Concord $0 $0 0.0% $0 $0 0.0% $14,790,000 $14,790,000 0.0% H H W $7,000 $2,817 -59.8% $42,000 $35,178 -16.2% $888,000 $852,822 4.0% Other $452,297 $216,926 -52.0% $1,503,884 $1,672,472 11.2% $3,039,200 $1,366,728 55.0% Total Revenue $38,9050631 $37,234,907 -4.3% $41,140,138 $40,455,831 -1.7% $89,817,200 $49,361,369 45.0% Admi Central Contra Costa Sanitary District ................... ...... ................................ Revenue Report MTD Fund: 002-SEWER CONSTRUCTION December 2016 Fiscal Period 612017 Report Generated on Jan 11, 2017 2-44:47 PM Page 2 Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Sewer $6,501,000 $6,151,208 -5.4% $6,501,000 $6,173,592 -5.0% $11,820,000 $5,646,408 52.2% Concord $0 $0 0.0% $0 $0 0.0% $4,550,000 $4,550,000 0.0% Other $6,015,281 $4,612,13© -23.3% $9,821,686 $8,534,080 -13.1% $18,535,400 $10,001,320 46.0% Total Revenue $12,516,281 $10,763,338 -14.0% $16,322,686 $14,707,673 -9.9% $34,905,400 $20,197,727 42.1% Centraf Contra Costa Sanitary District - ------------ Revenue Report MTD Fund: 003 -SELF-INSURANCE December 2016 Fiscal Period 6/2017 Report Generated on Jan 11, 2017 2-44-47 PM Page 3 Category MTD Estimate MTD Actual MTD%Rev► YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $1,032 $3,453 234.6% $926,192 $938,051 1.3% $1,005,375 $67,324 93.3% Total Revenue $1,032 $3,453 234.6% $926,192 $938,051 1.3% $1,005,375 $67,324 93.3% Central Contra Costa sanitary District Revenue Report MTD Fund: 004 - DEBT SERVICE December 2016 Fiscal Period £12017 Report Generated on Jan 11, 2017 2.44.47 PM Page 4 Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $3,748,310 $3,748,310 0.0% $3,748.310 $3.743,310 0.0% $3,790,807 $42,497 98.9% Total Revenue $3,748,310 $3,748,310 0.0% $30748,310 $3,748,310 0.0% $397901807 $42,497 98.9% Central Contra Costa Sanitary District Expense Report - District Summary MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:41:38 PM Page 1 Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,763,192 $2,617,167 $146,025 5.3% $16,579,152 $15,690,337 $888,815 5.4% $33,158,707 47.3% EMPLOYEE BENEFITS $2,706,774 $2,643,425 $63,349 2.3% $18,769,344 $17,909,514 $859,830 4.6% $37,511,904 47.7% CAPITALIZED ADM OVERHEAD ($312,043) ($287,805) ($24,238) 7.8% ($1,872,258) ($1,823,185) ($49,073) 2.6% ($3,744,593) 48.7% DIRECTOR FEES&EXPENSES $14,045 $8,711 $5,334 38.0% $84,270 $65,434 $18.836 22.4% $168,555 38.8% CHEMICALS $124,882 $84,344 $40,538 32.5% $924,992 $812,193 $112,799 12.2% $1,920,000 42.3% UTILITIES $359,642 $362,491 ($2,849) -0.8% $1,991,186 $1.961,920 $29,266 1.5% $4,315,790 45.5% REPAIRS&MAINTENANCE $435,215 $314,687 $120,528 27.7% $2,146,708 $1,660,542 $486,166 22.6% $5,222,852 31.8% HAULING&DISPOSAL $69,149 $48,609 $20,540 29.7% $432,494 $413,839 $18,655 4.3% $941,050 44.0% PROFESSIONAL&LEGAL SERV $54,221 $37,957 $16,264 30.0% $306,243 $163,158 $143,085 46.7% $630,750 25.9% OUTSIDE SERVICES $413,991 $265,884 $148,107 35,8% $1,926,991 $1,389,919 $537.072 27.9% $3,980,175 34.9% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $920,000 $920,000 $0 0.0% $920,000 100.0% MATERIALS&SUPPLIES $174,970 $124,028 $50,942 29.1% $1,025,154 $912,065 $113,089 11.0% $2,100,025 43.4% OTHER EXPENSES $166,620 $277,293 ($110,673) -66.4% $1,233,228 $1,181,642 $51,586 4.2% $2,685,703 44.0% Fund#001-Total Expenses $6,970,658 $6,496,791 $473,867 6.8% $44,467,504 $41,257,378 $3,210)126 7.2% $89,810,918 45.9% Color Key: 10% under budget or less 0 to 10% over budget > 10%over budget Central Contra Costa Sanitary District Expense Report - District Summary MTD Fund: 003 -SELF-INSURANCE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11 2017 2:41:38 PM Page 2 Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget INSURANCE&OTHER EXP $2,249 $0 $2,249 100.0% $588,494 $540,592 $47,902 8,1% $602,000 89.8% GENERAL&AUTO LIABILITY $95,832 S5,391 $90,441 94.4% $574,992 $34,643 $540,349 94.0% $1,150,000 3.0% EMP RELATED&POLLUTION $13,749 $0 $13,749 100.0% $82,494 $301 $82.193 99.6% $165,000 0.2% Fund#003-Total Expenses $111,830 $5,391 $106,439 95.2% $1,245,980 $575,536 $6701444 53.8% $17917P000 30.0% Color Key- 10% under budget or less 0 to 10% over budget > 10% over budget Central Contra Costa Sanitary District ---------- ------------ ------ Expense Report - District Summary MTD Fund: 004-DEBT SERVICE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11 2017 2:41:38 PM Page 3 Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget OTHER EXPENSES $0 $0 $0 0.0% $231,448 $231,448 $0 0.0% $1,313,051 17.6% Fund#004-Total Expenses $0 $0 $0 0.0% $2311448 $231,448 $0 0.0% $1,313,051 17.6% Total Expenses $7,082,488 $6,502$182 $580,306 8.2% $451944,932 $42,064,362 $3,880,570 8.4% $93,040,969 45.2% Color Key: 10% under budget or less 0 to 10% over budget > 10%over budget jetI PFL Central Contra Costa Sanitary District .j Expense Report- District Summary QTD Fund:001 -RUNNING EXPENSE December 2016 Fiscal Period 0612017 Report Generated on Jan 11,2017 2:43:14 PM Page 1 Category QTD Budget QTD Actual QTD Variance % YTD Budget YTD Actual YTD Variance % Annual %Used Remaining/(Over) Remaining/ Budget (Over) SALARIES&WAGES $8,289,576 $7,790,244 $499,332 6.0% $16,579,152 $15,690,337 $888,815 5.4% $33,158,707 47.3% EMPLOYEE BENEFITS $8,120,322 $7,626,462 $493,860 6.1% $18,769,344 517,909,514 $859,830 4.6% $37,511,904 47.7% CAPITALIZED ADM OVERHEAD ($936,129) ($916.267) ($19,862) 2.1% ($1,872,258) ($1,823,185) ($49,073) 2.6% ($3,744,593) 48.7% DIRECTOR FEES&EXPENSES $42,135 $31,255 $10,880 25.8% $84,270 $65,434 $18,836 22.4% $168,555 38.8% CHEMICALS $444,846 $377,207 $67,639 15.2% $924,992 S812,193 $112,799 12.2% $1,920,000 42.3% UTILITIES $1,078,926 $1,067,555 $11,371 1.1% $1,991,186 $1,961,920 $29,266 1.5% $4,315,790 45.5% REPAIRS&MAINTENANCE $1.305,645 $924,721 $380,924 29.2% $2,146,708 $1,660,542 $486,166 22,6% $5,222,852 31.8% HAULING&DISPOSAL $221,347 $243,259 ($21,912) (9.9%) $432,494 $413,839 $18,655 4.3% $941,050 44.0% PROFESSIONAL&LEGAL SERV $157,663 $107,165 $50,498 32.0% $306,243 $163,158 5143,085 46.7% $630,750 25.9% OUTSIDE SERVICES $1,028,995 $634,666 $394,329 38.3% $1,926,991 $1,389,919 $537,072 27.9% $3,980,175 34.9% SELF-INSURANCE EXPENSE $0 so $0 5920,000 $920,000 $0 0.0% $920,000 100,0% MATERIALS&SUPPLIES $524,910 $501,332 $23,578 4.5% $1,025,154 $912,065 $113,089 11.0% $2,100,025 43.4% OTHER EXPENSES $533.060 $589,533 ($56,473) (10.6%) $1,233,228 $1,181,642 $51,586 4.2% $2,685,703 44.0% Fund#001 Total Expenses $20,811,296 $18,977,132 $1,834,164 8.8% $44,467,504 $41,257,378 $3,210,126 7.2% $89,810,918 45.9% Color Key: 10% under budget or less 0 to 10%over budget > 10%over budget AM Central Contra Costa Sanitary District ---------- Expense Report- District Summary CTD Fund: 003-SELF-INSURANCE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:43:14 PM Page 2 Category OTD Budget OTD Actual QTD Variance % YTD Budget YTD Actual YTD Variance % Annual %Used Remaining/(Over} Remaining/ Budget (Over) INSURANCE&OTHER EXP $6,747 $0 $6,747 106 o% $588,494 $540,592 $47,902 8.1% $602,000 89.8% GENERAL&AUTO LIABILITY $287,496 $19,363 $268,133 93.3% $574,992 $34,643 $540,349 94.0% $1,150,000 3.0% EMP RELATED&POLLUTION $41,247 $268 $40,979 99.4% $82,494 $301 $82,193 99.6% $165,000 0.2% Fund#003 Total Expenses $336,490 $19,631 $315,859 94.1% $1,245,980 $576,536 $670,444 53.8% $1,917,000 30.0% Color Key-. 10% under budget or less 0 to 10%over budget > 10%over budget Central Contra Costa Sanitary D*Istr'['ct Expense Report- District Summary QTD Fund:004-DEBT SERVICE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2-43:14 PM Page 3 Category QTD Budget QTD Actual QTD Variance % YTD Budget YTD Actual YTD Variance % Annual %Used Remaining/(Over) Remaining/ Budget (Over) OTHER EXPENSES $0 $o $0, $231,448 $231,448 $0 0,0% $1,313,051 17.6% Fund#004 Total Expenses $0 $0 $0 $23'1,448 $231,448 $0 0.0% $1,313,051 17.6% Total Expenses $21,146,786 $18,996,763 $2,150,023 10.2% $45,944,932 $42,064,362 $3,880,570 8.4% $93,040,969 45,2% Color Key: 10% under budget or less 0 to 10%over budget > 10%over budget - Central Contra Costa San eta ry District . -------------- - ------------ Expense Report - By Department MTD Fund: 801 -RUNNING EXPENSE ReportGenerated on Jan 11, 2017 2:30:07 PM December 2016 Fiscal Period 06/2017Page 1 $2,500,000 [ Period Budgets. `$15,000,000 YTD'Budget* []Period Actual © YTD Actual $2,000,000 $10,000,000 $1,500,000 $1,000,000 $5,000,000 $500,000 r gk t g �. a � � ��-�'� G 4 ----------------------- Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $1,775,603 $1,719,837 $55,766 $14,051,819 $12,864,995 $1,186,824 ENGINEERING $1,393,637 $17238,547 $155,090 $8,053,867 $714281262 $625,605 COLLECTION SYSTEM OPS. $1,205,953 $1,053,631 $1523322 $6,933,226 $6,416,533 $515,693 PLANT OPERATIONS $2,198783 $1,975,938 $219,845 $13,037500 $12,619,290 $418,210 PUMP STATIONS $2501141 $253,865 ($13,724) $1,480,846 $1,483,847 ($3,001) RECYCLED WATER $146,541 $241,973 ($95,432) $910,246 $444,450 $4651796 Totals $69970,658 $69496,791 $473,867 $445467$504 $41,257,378 $392107126 Central Contra Costa sanitary District Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE December 2010 Fiscal Period 0612017 Report Generated on Jan 11, 2017 2:30:07 PM Page 2 Department: ADMINISTRATION i i • •i i i i #i V-w e once rITO B. i! TID Actual Variance YO Annualr Budget ---- ------------- MOM& SALARIES&WAGES $544,985 $523,494 $21,491 3.9% $3,269,910 $3.094,401 $175,509 5.4% $6,539,925 47.3% EMPLOYEE BENEFITS $886,984 $907,488 ($20,504) -2.3% $7,850,604 $7,350,425 $490,179 6.2% $15,673,019 47.0% CAPITALIZED ADM OVERHEAD ($3,597) ($2,919) ($678) 18.8°/0 ($21,582) ($15,251) ($6,331) 29.3% ($43,166) 35.3% DIRECTOR FEES&EXPENSES $14,045 $8,711 $5,334 38.0% $84,270 $65,434 $18,836 22.4% $168,555 38.8% UTILITIES $7,920 $9,168 ($1,248) -15.8% $47,524 $49,317 ($1,797) 10_04!'A $95,040 51.9% REPAIRS&MAINTENANCE $69,866 $151,543 ($81,677) -116.9% $419,196 $387,893 $31,303 7.5% $838,450 46.3% PROFESSIONAL&LEGAL SERV $42,017 $24,964 $17,053 40.6% $233,019 $109,792 $123,227 52.9% $484,250 22.7% OUTSIDE SERVICES $130,729 $75,088 $55,641 42.6% $828,874 $641,573 $187,301 22.6% $1,769,800 35.4% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $920,000 $920,000 $0 0.0% $929,000 100.0% MATERIALS&SUPPLIES $19,731 $9,245 $10,486 53.1% $118,386 $66,584 $51,802 43.8% $236,825 28.1% OTHER EXPENSES $62,923 $13,056 $49,867 79.3% $301,622 $184,825 $116.797 38.7%° $1,155,295 16.0% ADMINISTRATION Total Expenses $11775,603 $1,719,837 $55,76+6 31% $14,051,819 $12,864,995 $1,186,824 8.4% $27,828,993 46.2% Department: ENGINEERING s SALARIES&WAGES $748,077 $732,387 $15,690 2.1% $4,488,462 $4,329,908 $158,554 3.5% $8,976,971 48.2% EMPLOYEE BENEFITS $579,172 $566,392 $12,780 2.2% $3,475,032 $3,425,764 $49,268 1.4% $6,950,521 49.3% CAPITALIZED ADM OVERHEAD ($282,846) {$277,236} ($5,610) 2.0% ($1,697,076) ($1,731,983) $34,907 ($3,394,165) 51.0% UTILITIES $14,757 $14,538 $119 0.8% $88,542 $81,596 $6,946 7.8% $177,100 46.1% REPAIRS&MAINTENANCE $15,446 $1,468 $13,978 90.5% $92,676 $29,248 $63,428 68.4% $185,400 15.8% HAULING&DISPOSAL $25,915 $8,261 $17,654 68.1% $173,490 $188,715 ($15,225) $423,000 44.6% PROFESSIONAL&LEGAL SERV $10,081 $10,956 ($875) -8.7% $50,486 $35,055 $25,430 42.0% $121,000 29.0% OUTSIDE SERVICES $224,284 $157,168 $67,116 29.9% $744,249 $550,383 $193,865 26.0% $1,511,525 36.4% MATERIALS&SUPPLIES $29,705 $19,638 $10,067 33.9% $178,230 $130,989 $47,241 26.5% $356,550 36.7% OTHER EXPENSES $29,046 $4,875 $24,171 83.2°x° $449,776 $388.586 $61,190 13.6% S591,238 65.7% ENGINEERING Total Expenses $1,393,637 $1,238,547 ,$155,090 11.1% $8,053,867 $7,428,262 $625,605 7.8% $15,899,140 46.7% Color Key: 10% under budget or less 0 to 10% over budget > 10% over budget Central Contra Costa Sanitary District i Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:30:€7 PM Page 3 Department: COLLECTION SYSTEM OPS. SALARIES&WAGES $508,992 $475,169 $33,823 6.6% $3,053,952 $2,814,669 $239,283 7.8% $8,107,988 46.1% EMPLOYEE BENEFITS $457,075 $430,473 $26,602 5.8% $2,742,450 $2,539,356 $203,094 7.4% $5,485,22.9 46.3% CAPITALIZED ADM OVERHEAD ($4,320) ($674) ($3,646) 84.4% ($25,920) ($14,425) ($11,495) 44.3% a ($51,854) 27. IC 8 UTILITIES $11,615 $14,074 ($2,459) _21.2% $69,690 $65,135 $4,555 6.5% $139,4003 46.7% REPAIRS&MAINTENANCE $135,957 $33,634 $102,323 75.3% $530,742 $455,310 $75,432 14.2% $1,631,502 27.9% HAULING&DISPOSAL $10,916 $8,826 $2,090 19.1% $65,496 $44,417 $21,079 32.2% $131,000 33.9% PROFESSIONAL&LEGAL SERV $416 $1,822 ($1,406) -338.0% $2,496 $2,387 $109 4.4% $5,000 47.7% OUTSIDE SERVICES $8,890 $12.453 ($3,573) -40.2% $53,340 $80,339 ($26,999) $106,700 75.3% MATERIALS&SUPPLIES $64,507 $59,149 $5,358 8.3% $364,376 $363,495 $881 0.2% $774,150 47.0% OTHER EXPENSES $11,905 $18,694 ($6,789) -57.0% $76,604 $65,851 $10,753 14.0% $142,938 46.1% COLLECTION SYSTEM OPS.Total $17205,953 $1,053,631 $152,322 12.6% $6,933,226 $6,416,533 $516,693 7.5% $14,472,053 44.3% Expenses Color Key: 10% under budget or less 0 to 10%over budget > 10%over budget Central Contra Costa Sanitary District Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE December 2016 Fiscal Period 0612017 Deport Generated on Jan 11, 2017 2:30:07 PM Page 4 Department: PLANT OPERATIONS r - SALARIES&WAGES $8201842 $736,536 $84,306 10.3% $4,925,052 $4,802,196 $122,856 2.5% $9,850,196 48.8% EMPLOYEE BENEFITS $689,709 $612,047 $77,662 11.3% $4,138,254 $4,108,071 $30,183 0.7% $8,277,040 49.6% CAPITALIZED ADM OVERHEAD ($21,280) ($6,976) ($14,304) 67.2°/° /�, 0 ($127,680) ($61,526) ($66,154) 51.8 ($255,408) 24.1/° CHEMICALS $82,050 $403039 $42,011 51.2% $668,000 $558.571 $149,429 16.4% $1,406,000 39.7% UTILITIES $267,556 $210,922 $56,634 21.2% $1,438,670 $1,432,420 $6,250 0.4% $3,210,700 44.6% REPAIRS&MAINTENANCE $184,424 $87,873 $96,551 52.4% $946,962 $694,641 $2512,321 26.6% $2,213,200 31 A% HAULING&DISPOSAL $31,585 $30,732 $853 2.7% $189,110 $175,966 $13,144 7.0% $37$,250 45,5% PROFESSIONAL&LEGAL SERV $541 $215 $326 60.2% $3,246 $947 $2,299 70.8% $6,500 14.6% OUTSIDE SERVICES $26,874 $17,415 $9,459 35.2% $161,244 $77,781 $83,463 51.8°60 $322,550 24.1% MATERIALS&SUPPLIES $57,073 $34,467 $22,606 39.6% $340,438 $333,985 $6,452 1.9% $685,000 48.8% OTHER EXPENSES $59,409 $215,668 ($156,259) -263.0% $354,204 $496,238 ($142,034) = $713,149 69.6% PLANT OPERATIONS Total Expenses $2,198,783 $1,978,938 $219,845 10.0% $13,+037,500 $12,619,290 $418,210 3.2% $2618075177 47.1% Department: PUMP STATIONS � 4 SALARIES&WAGES $76,706 $78,719 ($2,013) -2.6% $460,236 $469,402 ($9,166) $920,480 51.0% EMPLOYEE BENEFITS $54,076 $60,491 ($6,415) -11.9% $324,456 $373,920 ' ($49,464) $648,947 57.5°/0 CAPITALIZED ADM OVERHEAD $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% CHEMICALS $35,833 $39,501 ($3,668) -10.2% $214,998 $218,789 ($3,791) $430,000 50.9% UTILITIES $43,211 $38,943 $4,268 9.9% 5259,266 $258,705 $561 0.2% $518,550 49.9% REPAIRS&MAINTENANCE $27,024 $40,142 ($13,118) -48.5% $142,144 $93,609 $50,535 35.6% $324,300 28.2% HAULING&DISPOSAL $733 $790 ($57) -7.8% $4,398 $4,742 ($344) $8,800 53.9% OUTSIDE SERVICES $6,341 $3,750 $2,591 40.9% $38,046 $28,574 $9,472 24.9% $76,100 37.5% MATERIALS&SUPPLIES $3,466 $1,529 $1,937 55.9% $20,796 $16,965 $3,831 18.4% $41,600 40.8% OTHER EXPENSES $2,751 $0 $2,751 100.0% $16,506 $21,142 ($4,636) = $33,059 64.0% PUMP STATIONS Total Expenses $250,141 $2631865 ($13,724) -5.5% $1,480,846 $1,483,847 ° ° ($3,001� -0.2./a $3,001,$36 49.4�� Color Key:. 10% under budget or less 0 to 10% over budget - 10°1 over budget M Central Contra Costa Sanitary District ------------ Expense Report - By Department MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 0612017 Report Generated on Jan 11, 2017 2:30:07 PM Page 5 Department: RECYCLED WATER SALARIES&WAGES $63,590 $70,863 ($7,273) -11.4% $381,544 $179,761 $201,779 52.9% $763,147 23.6% EMPLOYEE BENEFITS $39,758 $66,535 ($26,777) -67.3% $238,548 $101,978 $136,570 57.3% $477,148 21.4% CHEMICALS $6.999 $4,804 $2,195 31.4°/0 $41,994 $34,832 $7,162 17.1% $84,000 41.5°f0 UTILITIES $14,583 $74,746 ($60,163) -412.6% $87,498 $74,746 $12,752 14.6% $175,000 42.7% REPAIRS&MAINTENANCE $2,498 $26 $2,472 99.0% $14,988 $1,842 $13,146 87.7% $30,000 6.1% PROFESSIONAL&LEGAL SERV $1,166 $0 $1,166 100.0% $6,996 $14,976 ($7,980) = $14,000 107.0% OUTSIDE SERVICES $16,873 $0 $16,873 100.0% $101,238 $11,258 389,970 88.9% $202,500 5.6% MATERIALS&SUPPLIES $488 $0 $488 100.0% $2,928 $47 $2,881 98.4% $5,900 0.8% OTHER EXPENSES $586 $25,000 ($24,414) -4,165.2%0 $34,516 $25,000 $9,516 27.6% $50,024 50.0% RECYCLED WATER Total Expenses $146,541 $241,973 ($95,432) -65.1% $9107246 $444450 $465,796 51,2%0 $1,801,719 24.7% Fund x#001 -Total Expenses $6,970,658 $65496,791 $473,867 6.8% $44,467,504 $41,257,378 $31210,126 7.2% $89,810,918 45.9% Calor Key: 10%© under budget or less 0 to 10%over budget > 10% over budget Central Contra Costa Sanitary District Expense Report - By Department MTD Fund: 003 -SELF-INSURANCE December 2016 Fiscal Period 0612017 Report Generated on Jan 11, 2917 2:39:07 PM Page 5 $120,000 Period Budget' `S1,400,000- YTD Budget Period Actual 0 YTD Actual $100,000 $1,200,000 $1,000,000 $80,000 ; $800,000 $60,000 S600,000- $40,000 } 1 $400.QOQ { $20,000 $200,000 I $0 _s . $0 --- Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $1111830 $5,391 $195,439 $1,245,980 $575,536 $670,444 Totals $111I830 $59391 $1069439 $19245,980 $575,536 $5709444 AMCentral Contra Costa Sanitary District Expense Report - By Department MTD Fund: 003 -SELF-INSURANCE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:30:07 PM Page 7 Department: 9z IM M. 119 A a , INSURANCE&OTHER EXP $2,249 $0 $2,249 100.0% $588,494 $540,592 $47,902 8.1% $602,000 89.8% GENERAL&AUTO LIABILITY $95,832 $5,391 $90,441 94.4% $574,992 $34,643 $540,849 94.0% $1,150,000 3.0'10 EMP RELATED&POLLUTION $13,749 $0 $13,749 100.0% $82,494 $301 $82,193 99.6% $165,000 0.2% Total Expenses $111,830 $5,391 $106,439 95.2% $1,245,980 $575,536 $670,444 53.8% $1,917,000 30,0% Fund#003-Total Expenses $111,830 $5,391 $106,439 95.2% $1,245,980 $575,536 $670,444 53.8% $1,917,000 30.0% Calor Key: 10% under budget or less 0 to 10% over budget > 10%over budget Central Contra Costa sanitary District Expense Report - By Department MTD Fund: 004-DEBT SERVICE December 2016 Fiscal Period 0812017 Report Generated on Jan 11, 2017 2:80:07 PM Page 8 $1 [3[ Period Budget $ 50,000 - YTD Budget' © Period Actual © YTD Actual $200,000 j. $0 $150,000 $0- $100,000 ($0)- $50,000 $0) $50,000 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $0 $0 $0 $2311448 $2311448 $0 Totals $0 $0 $0 $2315448 $23'1,448 $0 AMIN ------ central Contra Costa unitary District Expense Report - By Department MTD Fund: 004- DEBT SERVICE December 2016 Fiscal Period 0012017 Report Generated on Jan 11, 2017 2:303:07 PM Page 9 Department: r OTHER EXPENSES $0 $0 $0 0.0% $231,448 $231,448 $0 0.0% $1,313,051 17.6% Total Expenses $0 $0 $0 0.0% $231,448 $2315448 $0 0.0% $1,313,051 17.6%Q Fund#004-Total Expenses $0 $0 $0 0.0%0 $231,448 $231,44$ $0 0.0% $1,313,051 17.6% Total Expenses $7,082,488 $6,502,182 $580,306 8.2% $45,944,932 $42,064,362 $3,880,570 8.4% $93,040,969 45.2% Color Keir: 10% under budget or less 0 to 10%over budget > 10%over budget Central Contra Costa Sanitary District Expense Report - By Division MTD Fund: 001 ..RUNNING EXPENSE December 2016 Fiscal Period 0612017 Report Generated on Jan 11, 2517 2:33:32 PM Page 1 '• MTD YTD$2,500,000 Period Budget $15,000,000 YTD Budget ❑ Period Actual ❑ YTD Actual $2.000,000 I ' 1 l $10,000,000 { $1,500,000 4 $1,000,000 r $5,000,000 $500,000 1 f • J $0 GV Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD variance ADMINISTRATION $11775,603 $1,719,837 $55,765 $14,551,819 $12,854,995 $1,186,824 ENGINEERING $1,393,537 $1,238,547 $155,090 $8,0531867 $71428,252 $5251605 COLLECTION SYSTEM OPS. $1,205,953 $1,0531631 $152,322 $5,933,225 $6,416,533 $5161693 PLANT OPERATIONS $2,198,783 $1,978,938 $219,845 $131537,505 $12,519,290 $418,210 PUMP STATIONS $2541141 $253,855 ($13,724) $11480,845 $1,483,847 ($3,001) RECYCLED WATER $146,541 $241,973 ($95,432) $910,245 $444,450 $455,795 Totals $65970,658 $6,4969791 $473,867 $4434679504 $41,2571378 $39210J26 Centra[Contra Costa sanitary District -JAN Expense Report - By Division MTD Fund: 001 -RUNNING EXPENSE December 2015 Fiscal Period 106/2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 2 Department: ADMINISTRATION Division: CENTRAL SERVICES ago gig �: w SALARIES&WAGES $125,193 $122,206 $2,987 2.4% - $751,158 3731,577 $19,581 2.6°/4 $1,502,326 48.7% EMPLOYEE BENEFITS $80,597 $86,366 ($5,769) (7,2%) $463,582 $448,696 $34,886 7.2% $967,263 46.4% DIRECTOR FEES 8r EXPENSES $14,045 $8,711 $5,334 38.0% $84,270 $65,434 $18,836 22.4% $168,555 38,8% REPAIRS&MAINTENANCE $899 $0 $899 100.0% $5,394 $857 $4,537 84.1% $10,800 7.9% PROFESSIONAL&LEGAL SERV $12,083 $12,101 ($18) (0.2%) $72,498 838,503 $33,995 46.9% $145,000 26.6% OUTSIDE SERVICES $15,500 $472 $15,028 97.010 $137,500 $67,640 $69,860 50.8% $246,000 27.5% MATERIALS&SUPPLIES $1,678 $1,404 8274 16.3% $10,068 $8,425 $1,643 16.3% $20,150 41.8% OTHER EXPENSES $13,323 $2,990 $10,333 77.6% $78,438 $28,907 $49,531 63.1% $559,905 5.2% CENTRAL SERVICES Total $263,318 $234,251 $29,067 11.0% $1,622,908 $1,390,040 $232,868 14.3% $3,619,999 38.4% Expenses Division: FINANCE&ACCOUNTING wow.. ! SALARIES&WAGES $96,266 $90,058 $6,208 6.4% $577,596 $515,425 $62,171 10.8% $1,1551209 44.6% EMPLOYEE BENEFITS $81,430 $73,235 $8,195 10.1% $488,580 $430,305 $58,275 11,9014 $977,212 44.0% REPAIRS&MAINTENANCE $83 $0 $83 100.0% $498 $0 $498 100.0% $1,000 0.0% PROFESSIONAL&LEGAL SERV $9,478 $10,000 ($522) (5.5%) $47,785 $27,162 $20,623 43.2% $113,750 23.9% OUTSIDE SERVICES $7,625 $9,529 ($1.904) (25.0%) $45,750 $65,197 ($19,447) (42.5%) $223,500 29.2% MATERIALS a&SUPPLIES $816 $1,395 ($579) (71.04/x) $4,896 $7,112 (Q� • ,r p 2 y0 (`�-2t�1�� ' $9,800 72,6/0 OTHER EXPENSES $2,241 $819 $1,422 63.5% $13,446 $4,260 $9,186 68.3% $26,930 15.8% FINANCE&ACCOUNTING Total $197,939 $185,037 $12,902 6.5% $1,178,551 $1,049,461 $129,090 11.0% $2,507,4101 41.9% Expenses Division: HUMAN RESOURCES r ! SALARIES&WAGES $60,655 $51,344 $9,311 15.4% $3$8,930 $308,273 $55,657 15.3% $727,877 42A% Color Key: 10% under budget or less 0 to 10%over budget > 10%over budget Afc4k� Central Contra Costa Sanitary District MMU-0416 11, A Jill 21111 M I Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06!2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 3 ids%= EMPLOYEE BENEFITS $494,673 $525,101 ($30,428) (6.2%) $5,496,738 $5,130,182 $368,556 6.7% $10,964,872 48.8% PROFESSIONAL&LEGAL SERV $10,508 $2,243 $8,265 78.7% $63,048 $36,585 $26,463 42.0% $126,100 29.0% OUTSIDE SERVICES $20,774 $31,087 ($10,313) (49.6%) $124,644 $155,326 ($30,682) (24.6%) $249,300 62.3% MATERIALS&SUPPLIES $1,500 $785 $715 47.7% $9,000 $17,469 ($8,469) (94.1%) $18,000 97.0% OTHER EXPENSES $1,508 $0 $1,508 100.0% $9.048 $21,425 '+ Q ($12,377} $18,115 118.3 7a HUMAN RESOURCES Total $589,618 $610,560 ($20,942) (3.6%) $6,066,40$ $5,6£9,260 $397,148 6.5% $12,104,264 46.8% Expenses Division: PURCHASING YTD Budget YTD Actual YTD Variance % Annual %Used Category Period Budget Period Actual Period Variance L 0% ■ f Budget Aww SALARIES&WAGES $71,466 $69,212 $2,254 3.2% $428,796 $420,892 $7,904 1.8% $857,600 - 49.1% EMPLOYEE BENEFITS $65,211 $58,261 $6,950 10.7% $391,266 $358,346 $32,920 8.4% $782,607 45.8% REPAIRS&MAINTENANCE $1,916 $10,000 ($8,084) (421.9%) $11,495 $10,192 $1,304 11.3% $23,000 44.3% PROFESSIONAL&LEGAL SERV $2,916 $344 $2.572 88.2% $17,496 $1,135 $16,361 93.5% $35,000 3.2% OUTSIDE SERVICES $2,416 $0 $2,416 100.0% $14,496 $1,172 $13,324 91.9% $29,000 4.0% MATERIALS&SUPPLIES $1,166 $1,122 $44 3.7% $6,996 $554 $6,442 92.1% $14,000 4.0% OTHER EXPENSES $1,822 ($8) $1,830 100.4%d $10,932 $1,110 $9,822 89.8% $21,900 5.1% PURCHASING Total $146,913 $138,931 $7,982 5.4% $881,478 $793,401 $88,077 10.0% $1,763,107 45.0% Expenses Division: RISC(MANAGEMENT Category Mod BuI r IPeriod % Budget ! Variance % Annual % I Remaining/ Budget SALARIES&WAGES $19,911 $19,116 $795 4.0% $119,466 $114,767 $4,699 3.9% $238,944 48.0% EMPLOYEE BENEFITS $19,029 $17,911 $1,118 5.9% $114,174 $118,989 ($4,815) $228,392 52.1% REPAIRS&MAINTENANCE $2,916 $0 $2.9161 100.0% $17,4961 $531 $€6,955 97.0°70 $35,000 1.5% PROFESSIONAL&LEGAL SERV $6,816 $275 $6,541 96.0% $30,896 $5,403 $25,493 82.5% $61.800 8.7% OUTSIDE SERVICES $133,999 $19,822 $14 177 41.7°Ia 0 0 , $203,994 $117.783 $86,211 42.3 70 $405,0043 28.9 l° SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $920,000 $920,000 $0 0.0% $920,000 100.0% MATERIAL'S&SUPPLIES $8,583 $54 $8,529 99.4% $51.498 $938 $50,560 98.2% $103,000 0.9°'a Calor Key: 10%under budget or fess 0 to 10%over budget > 10%over budget Central Contra Costa sanitary District Oil Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 4 PlUffod Budget Wdd -*61 Period V01WV66"' NOT,ktt M• Y OTHER EXPENSESr � '- $1,135 $647 $488 43.01fl $6,810 $5,935 $875 12.9% $13,650 43.5% RISK MANAGEMENT Total $92,389 $57,826 $34,563 37,4% $1,464,334 $1,284,344 $179,990 12.3% $2,048,786 63.9% Expenses Division: COMMUNICATION SERVICES Category TeT cZaT"OedodVaria nce 7 ff WD I Ku'd-g e t YTD Actual YTD Variance % Annual %Usedillilli Period 806'et 2/0 Remaining/et #Y SALARIES&WAGES $55,34+6 $54,467 $879 1.6% $332,076 $323,866 $8,210 2.5% $664,176 48.8%70 CAPITALIZED ADM OVERHEAD ($3,597) ($2,919) ($678) 18,8% ($21,582) ($15,251) ($6,331) 29.3% ($43,166) 35.3% EMPLOYEE BENEFITS $46,408 $45,033 $1,375 3.0% $278,448 $276,227 $2,221 0.$°7a $556,970 49.6°70 REPAIRS&MAINTENANCE $83 $0 $83 100.0% $498 $0 $498 100.0% $1,000 0.0% PROFESSIONAL$LEGAL SERV $216 $0 6216 100.0% $1,296 $1,404 $292 22.5% 62,600 38.6% OUTSIDE SERVICES $34,082 $1,790 $32,292 94.7% $204,492 $155,925 $48,567 23.8% $409,000 38.1% MATERIALS$SUPPLIES $5,138 $2,439 $2,699 52.5% 530,828 $17,809 $13,019 42,2% $61,675 28.9% OTHER EXPENSES $39,349 $8,528 $30,821 78.3% $161,678 $114,239 $47,439 29,3% $472,230 24.2% COMMUNICATION SERVICES Total $177,025 $109,337 $67,688 38.2% $987,734 $873,819 $113,915 11.5% $2,124,485 41.1% Expenses Division: IT CategoryAMP Avow P=Budget#i a# oiV:riance YTI)IRidget YTD Actual YTD Variance ` Budget SALARIES&WAGES $116,148 $117,090 ($942) (0.8%) $696,888 $679,601 $17,287 2.5% $1,393,793 48.8% EMPLOYEE BENEFITS $99,636 $101,580 ($1,944) (2.0%) $597,816 $597,681 $135 0.0% $1,195,703 50.0% UTILITIES $7,920 $9,168 ($1,248) (15.8%) 647,520 $49,317 ($1,797) $95,040 51.9% REPAIRS&MAINTENANCE $63,969 $141,543 ($77,574) (121.3%) $383,814 $376,313 $7,501 2.0% $767,650 49.0% OUTSIDE SERVICES $16,333 $12,388 $3,945 24.2% $97,998 $78,532 $19,466 19.9% $196,000 40.1% MATERIALS&SUPPLIES $850 $2,046 ($1,196) (140.70/a �', % ,) $5,100 $14,277 ($9,177) $1x,200 140. /0 0 OTHER EXPENSES $3,545 $81 $3,464 97.7% $21,.270 $8,948 $12,322 57.9% $42,565 21.0% IT Total Expenses $308,401 $383,895 ($75,494) (24.5%) $1,850,406 $1,804,669 $45,737 2.5%, $3,700,951 48.8% ADMINISTRATION Total Expenses $1,775,603 $1,719,837 $55,766 3.1% $14,051,819 $12,864,995 $1,186,824 8.4% $27,828,993 46.2% Department: ENGINEERING Color Ivey: 10% under budget or less 0 to 10%over budget > 10%over budget _ Central Contra Costa Sanitary District r Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 5 Division: PLANNING&DEVELOPMENT SV SALARIES&WAGES $307,087 $313,937 ($6,850) (2.2%) $1,842,522 $1,874,801 ($32,279) ;.6 $3,685,044 50.9% CAPITALIZED ADM OVERHEAD ($83,436) ($87,320) $3,884 (4.7%) ($500,616) ($541,265) S40,649 (8.1% ($1,001,227) 54.1% EMPLOYEE BENEFITS $231,006 $234,142 ($3,136) (1.4%) $1,386,036 $1,449,920 ($63,884) .6 , $2,772,153 52.3% UTILITIES $10,033 $11,843 ($1,810) (18.0%) $60,198 $67,255 ($7,057) $120,400 55.9% REPAIRS&MAINTENANCE $4,949 $26 $4,923 99,5% $29,694 $5,311 $23,383 78.7% $59,400 10.6% PROFESSIONAL&LEGAL SERV $9.582 $10,956 ($1,374) (14.3%) $57,492 $35,056 $22,436 39.0°70 '$115,000 30.5% OUTSIDE SERVICES $149,385 $117,483 $31,902 21,4%0 $282,740 $168,057 $114,683 40.6% $579,100 29.0% MATERIALS&SUPPLIES $3,128 $2,643 $485 15.5% $18,768 $12,135 $6,533 35.3% '$37,550 32.3% OTHER EXPENSES $15,519 $1,149 $14,370 92.6%0 $48,614 $20,406 $28,208 58.0% $88,474 23.1% PLANNING&DEVELOPMENT SV $647,253 $604,859 $42,394 6.5% $3,225,448 $3,092,676 $132,772 4.1% $6,455,+894 47.9% Total Expenses Division: CAPITAL PROJECTS i w ii SALARIES&WAGES $155,605 $147,993 $8,612 5.5% $939,630 $819,410 $120,220 -12.8% $1,879,280 43.6% CAPITALIZED ADM[OVERHEAD ($193,653) ($189,916) ($3,737) 1.9% (51,161,918) ($1,190,719) $28,801 ($2,323,853) 51.2% EMPLOYEE BENEFITS $119,679 $114,236 $5,443 4,5010 $718,074 $643,238 $74,836 10.4% $1,436,327 44.8% UTILITIES $2,+000 $1,529 $471 23.6% $12,000 $7,562 $4,438 37.0% $24,000 31.5% REPAIRS&MAINTENANCE $1,623 $0 $1,623 100.0% $9,738 $0 $9,738 100.0%Q $19,500 0.0% PROFESSIONAL&LEGAL SERV $0 $0 $0 0.0% $0 $0 $0 $0 OUTSIDE SERVICES $6,100 $1.176 $4.924 80.7% $31,915 $15,616 $15,299 51.1% $73,225 21.3°/0 MATERIALS&SUPPLIES $2,689 $1,041 $1,648 61.3%4 $167,134 $6,281 $9,853 61.1% $32,300 19.4% OTHER EXPENSES $4,924 $2,085 $2,835 57.6% $29,520 $8,893 $20,627 69.9% $59,125 15.0% CAPITAL PROJECTS Total $99,963 $78,144 $21,819 21.8 $595,093 $310,2$1 $284,812 47.9°14 $1,199,904 25.9010 Expenses Division: ENVIRON® COMPLIANCE Color Key: 10% under budget or less 0 to 10%over budget > 10%Over budget Aim Central Contra Costa Sanitary Distr*et Expense Report- By division MTD Fund: 001 -RUNNING EXPENSE December 2316 Fiscal Period 0612017 Report Generated on Jan 11, 2017 2:33:32 PM page 0 r SALARIES&WAGES $284,385 $270,457 $13,928 4.9% $1,706,310 $1,635,698 $70,612 4.1% $3,412,647 47.9% CAPITALIZED ADM OVERHEAD ($5,757) $0 ($5,757) 100.0% ($34,542) SO {$34,542} 100.0% ($69,085) 0.0% EMPLOYEE BENEFITS $228,487 $218,013 $10,474 4.6% $1,370,922 $1,332,607 $38,315 2.8% $2,742,041 48.6% UTILITIES $2,724 $1,267 $1,457 53.5% $16,344 $6,779 $9,565 58.5% $32 ° ,700 20. /4 7 REPAIRS&MAINTENANCE $8,874 $1,442 $7,432 83.7% $53,244 $22,937 $30,307 56.9% $106,500 21.5% HAULING&DISPOSAL $25,915 $8,261 $17,654 68.1% $173,490 $188,715 ($15,225) $423,000 44.6% PROFESSIONAL&LEGAL SERF $499 $0 '$499 100.0°r° $2,994 $0 $2,994 100.0°1a $6,00() 0.0% OUTSIDE SERVICES $68,799 $38,509 $30,290 44.0% ° ° $429,594 $356,710 $62,884 14. Ja 5 $859,200 42.7Ia MATERIALS&SUPPLIES $23,888 $15,954 $7,934 33.2% $143,328 $312,573 $30,755 21.5% $286,700 39.3% OTHER EXPENSES $8,607 $1,641 $6,966 80.9% $371,642 $359,287 $12,355 3.3°x° $443,639 81.0% ENVIRON® COMPLIANCE '$646,421 $555,54.4 $90,877 14.1% $4,233,326 $4,425,306 $208,020 4.9% $8,243,342 48.8% Total Expenses ENGINEERING Total Expenses $1,393,637 $1,238,547 $155,090 11.1% $8,053,867 $7,428,262 $625,605 7.8% $15,899,144 46.7% Department: COLLECTION SYSTEM OPS. Division: OPERATIONS SUPPORT r r ! SALARIES&WAGES $96,995 $87,516 $9,479 9.8% $581,970 $530,676 $51,294 8.8% $1,163,981 45.6% CAPITALIZED ADM OVERHEAD ($1,624) $0 ($11624) 100.0% ($9,744) $0 ($9,744) 100.0% ($19,494) 0.0% EMPLOYEE BENEFITS $77,143 $79,125 ($1,982) (2.6%) $$462,858 $491,607 ($28,749) --• $925,860 53.1% UTILITIES $11,615 $14,074 ($2,459) (21.2%) $69,690 $65,135 $4,555 6.5% $139,400 46.7% REPAIRS&MAINTENANCE $27,541 $10,865 $16,676 60.5% $165,246 $104,453 $60,793 36.8°fid $330,500 31.6°/0 HAULING&DISPOSAL $7,583 $8.826 {$1,243} (16.4%) $45,498 $43,703 $1,795 3.9% $91.000 48.0% PROFESSIONAL&LEGAL SERV $416 $1,822 ($1,406) (338.0%) $2,496 $2,387 $109 4,4% $5,000 47.7% OUTSIDE SERVICES $7,899 $12,349 ($4,450) (56.3%) $47,394 $68,199 ($20,805) •", $94,800 71.9% MATERIALS&SUPPLIES $29,084 $12,503 $16,582 57.0% $151,838 $101,578 $50,160 33.0% $349,050 29.1% OTHER EXPENSES $9,532 $17,126 ($7,494) (77.8%) $62.956 $60,323 $2,643 4.2% $115,638 52.2% OPERATIONS SUPPORT Total $266,284 $244,206 $22,078 8.3% $1,580,212 $1,468,161 $112.051 7.1% $3,195,735 45.9% Expenses Color Key; 10% under budget or leas 0 to 10%over budget > 10%over budget Central Contra Costa Sanitary District Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06/2017Repan Generated on Jan 11, 2017 2:33:32 PM Page 7 Division: FIELD OPERATIONS w !! SALARIES&WAGES $411,997 $387,653 $24,344 5.9% $2,471,982 $2,283,992 $187,990 7.6% $4,944,007 46.2% CAPITALIZED ADM OVERHEAD ($2,696) ($674) ($2,022) 75.0% ($16,176) ($14,425) ($1,751) 10.8% ($32,360) 44.6% EMPLOYEE BENEFITS $379,932 $351,349 $28,583 7,5% $2,279,592 $2,047,748 $231,844 10.2% $4,559,369 44.9% REPAIRS&MAINTENANCE $108,416 $22,769 $85,647 79.0% $365,496 $350,857 $14,639 4.0°fa $1,301,002 27.0% HAULING&DISPOSAL $3,333 $0 $3,333 100.0% $19,998 $714 $19,284 96.4% $40,000 1.8% OUTSIDE SERVICES $991 $114 $877 88.5% $5,945 $12,140 ($6,194) % $11,900 102,0°6° MATERIALS&SUPPLIES $35,423 $46,647 ($11,224) (31.7%) $212,538 $261,817 ($49,279), '• $425,100 61.6% OTHER EXPENSES $2,273 $1,568 $705 31.0% $13,638 $5,528 $8,110 59.5% $27,300 20.20/c FIELD OPERATIONS Total $939,669 $809,426 $130,243 13.9% $5,353,014 $4,948,372 $404,642 7.6°x° $11,276,318 43.9% Expenses COLLECTION SYSTEM OPS.Total $1,205,953 $1,053,$31 $152,322 12.6% $6,933,226 Expenses $6,416,533 $516,693 7.5°/° $14,472,053 44.3"60 Department: PLANT OPERATIONS Division: MANAGEMENT r , i SALARIES&WAGES $93,536 $145,268 ($11,732) (12.5%) $561,216 $602,348 ($41,132) $1,122,445 53.7% CAPITALIZED ADM OVERHEAD ($1,884) $0 ($1,884) 100.0°I° ($11,304) $Q ($11,304) 100.00/° ($22,618) 0.0°Ia EMPLOYEE BENEFITS $65,908 $78,550 {$12,642} (19.2%) $395,448 $474,007 ($78,559) 'r $791,027 59.9% UTILITIES $5,058 $3,628 $1,430 28.3% $30,348 $16,973 $13,375 44.1% $60,700 28.0% REPAIRS&MAINTENANCE $5,932 $292 $5,640 95.1% $35,592 $16,994 $18,598 52.3% $71,200 23.9% HAULING&DISPOSAL $853 $0 $853 100.0% $5,118 $6,392 ($1,274) � •% $10,250 62,4% PROFESSIONAL&LEGAL SERV $541 $215 $326 60,2% $3,246 $947 $2,299 70,8% $6,500 14.6% OUTSIDE SERVICES $10,499 $0 $10,499 100.0% $62,994 $27,097 $35,897 57.0% $126,000 21.5% MATERIALS&SUPPLIES $4,573 $1,125 $3,448 75.4% $25,438 $17,717 $7,721 30.4% $54,900 32.3% OTHER EXPENSES $47,889 $208,929 ($161,1340) (336.3%) $285,084 $447,356 ($162,272) ''. $574,785 77.8% MANAGEMENT Total $232,905 $398,006 ($165,101) (70.9%) $1,393,180 $1,609,830 ($216,650) (15.6%) $2,795,189 57.6% Expenses Color Key- 10% under budget or less 0 to 10%over budget > 10%over budget FL Central Contra Costa.Sanitary District Jim Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 0612017 Report Generated on Jan 11, 2017 2:33:32 PM Page 8 Division: OPERATIONS r r � SALARIES&WAGES $365,742 $324,449 $41,293 11.3% $2,194,452 $2,153,058 $41,394 1.9% $4,388,925 49.1% CAPITALIZED ADM OVERHEAD ($13,317) ($2,180) ($11,137) 83.6% ($79,902) ($:21,143) ($58,759) 73.5% ($159,813) 13.2% EMPLOYEE BENEFITS $308,834 $256,811 $52,023 16.8% $1,853,004 $1,834,171 $18,833 1.0% $3,706,090 49.5% CHEMICALS $82.050 $40,039 $42,011 51.2% $668.000 $558,571 $109,429 16.4% $1,406,000 39.7%° UTILITIES $262,498 $207,294 $55,244 21.0% $1,408,322 $1,415,447 ($7,125) $3,150,000 44.9% REPAIRS&MAINTENANCE $4,156 $5,882 ($1,716) (41.2%0) $24,996 $19,704 $5,292 21.2%° $50,000 39.4%° HAULING&DISPOSAL $19,899 $18,802 $1,097 5.5% $11€3,994 $97,997 $20,997 17.6% $238,000 41.2% OUTSIDE SERVICES $2,916 $1,073 $1,843 63.2%° $17,496 $1,073 $16,423 93.9% $35,000 3.1% MATERIALS&SUPPLIES $11,040 $8,988 $2,052 18.6% $66,240 $56,280 $9,960 15.0% $132,500 42.5'%0 OTHER EXPENSES $2,615 $0 $2,615 100.0% $15,690 $10,988 $4,702 30.0% $31,422 35.0% OPERATIONS Total $1,046,443 $861,157 $185,286 17.7% $6,287,292 $6,126,146 $161,146 2.6% $12,978,124 47.2% Expenses Division: MAINTENANCE - w SALARIES&WAGES $361,564 $306,820 $54,744 15.1% $2,169,384 $2,046,790 $122,594 5.7% $4,338,826 47.2% CAPITALIZED ADM OVERHEAD ($6,079) ($4,796) ($1,283) 21.1% ($36,474) ($40,383) $3,909 + ($72,977) 55.3% EMPLOYEE BENEFITS $314,967 $276,687 $38,2801 12.2% $1,889,802 $1,799,892 $89,910 4.8% $3,779,923 47.6% REPAIRS&MAINTENANCE $174,326 $81,700 $92,626 53.1% $886,374 $657,942 $228,432 25.8% $2,092,000 31.5%° HAULING&DISPOSAL $10,833 $11,930 ($1,097) (10.1%) $64,998 $71,577 ($6,579) i $130,000 55.1% OUTSIDE SERVICES $13,459 $16,343 {$2,884} (21.4%) $80,754 $49,611 $31,143 38.6% $161,550 30.7% MATERIALS&SUPPLIES $41,460 $24,354 $17,106 41.3°Io $248,760 $259,990 ($11,2317) $497,600 52.2°/° OTHER EXPENSES $8,905 $6,739 $2,166 24.3% $53.430 $37,894 $15,536 29.1%° $106,942 35.4%4 MAINTENANCE Total $919,435 $719,775 $199,660 21.7% $5,3571028 $4,883,314 $473,714 8.8% $11,033,864 44.3% Expenses PLANT OPERATIONS Total Expenses $2,198,783 $1,978,938 $219,845 10.0% $13,037,500 $12,619,290 $418,210 3.2% $26,807,177 47.1% Department: PUMP STATIONS Division: PUMP STATIONS Color Ivey: 10% under budget or less 0 to 10%over budget > 10%over budget Central Contra Costa Sanitary District s � Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11,2017 2:33:32 PI'S Page g oil r w w SALARIES&WAGES $76,706 $78,719 {$2,013 2.6% } ( ) $460,236 $469,402 ($9,166) $920,480 51.0% CAPITALIZED ADM OVERHEAD $0 $0 $0 0.0% $0 $0 $0 $0 EMPLOYEE BENEFITS $54,076 $60,491 ($6,415) (11.9%) $324,456 $373,920 ($49,464) $648,947 57.6% CHEMICALS $35,833 $39,501 ($3,668) (10.2%) $214,998 $218,785 ($3,791) $430,000 50.9% UTILITIES $43,211 $38,943 $4,268 9.9% $259,266 $258,705 $5611 0.2% $518,550 49.9% REPAIRS&MAINTENANCE $27,024 $40,142 ($13,118) (48.5%) $142,144 $91,609 $50,535 35,6% $324,300 28.2% HAULING&DISPOSAL $733 $790 ($57) (7.8%) $4,398 $4,742 ($344) $8,800 53.9% OUTSIDE SERVICES $6,341 $3,750 $2,591 40.9% $38.046 $28,574 $9,472 24.9% $76,100 37.5% MATERIALS&SUPPLIES $3,466 $1,529 $1,937 55.9% $20,796 $16,955 $3,831 18.4% $41,500 40.8% OTHER EXPENSES $2,751 $0 $2,751 100.0%D $16,506 $21,142 ($4,636) $33,059 64.0% PUMP STATIONS Total $250,141 $263,865 ($13,724) (5.5%) $1,480,846 $1,483,847 ($3,001) (0.2%) $3,001,836 49.4% Expenses PUMP STATIONS Total Expenses $250,141 $263,865 {$13,724} (5.5%) $1,480,846 $1.483,847 ($3,001) (4.2%) $3,001,836 49.4°/6 Department: RECYCLED WATER Division:TREATMENT PLANT i SALARIES&WAGES $16,949 $65,019 ($48,070) (283.6%) $101,694 $65,019 $36,675 36.1% $203,404 32.0% EMPLOYEE BENEFITS $16,522 $63,719 ($47,197) (285.7%) $99,132 $63,719 $35,413 35.7°fo $198,275 32.100 CHEMICALS $6,999 $4,804 $2,195 31.4% $41,994 $34,832 $7,162 17.1% $84,000 41.5% UTILITIES $14,583 $74,745 ($60,163) (412.6%) $87,498 $74,746 $12,752 14.6% $175,000 42.7% REPAIRS&MAINTENANCE $582 $26 $556 95.6% $3,492 $1,842 $1,650 47.2% $7,000 26.3% OUTSIDE SERVICES $41 $0 $41 100.0% $246 $0 $246 100.0% $5030 0.0% MATERIALS&SUPPLIES $82 $0 $82 100.0% $492 $0 $492 100.0% $1,000 0.0% TREATMENT PLANT Total $55,758 $208,314 ($152,556) (273.6%) $334,548 $240,158 $94,390 28.2% $6693175 35.9% Expenses Division: DISTRIBUTION SYSTEM Color Key: 10%under budget or less 0 to 10%over budget - 10%over budget �. OILCentral Contra Costa Sanitary District Expense Report- By Division MTD Fund: 001 -RUNNING EXPENSE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 10 SALARIES&WAGES $9,074 $4,433 $4,641 51.1% $54,444- $25,993 $28,451 52.3% $108,900 23.910 EMPLOYEE BENEFITS $7,518 $2,381 $5,137 68.3% $45,108 $14,320 $30.788 68.3% $90,225 15.9% REPAIRS$MAINTENANCE $1,916 $0 $1,916 100.0% $11,496 $0 $11,496 100.0% $23,000 0.0% PROFESSIONAL&LEGAL SERV $166 $0 $166 100.0% $996 $0 $996 100.0% $2,000 0.0% OUTSIDE SERVICES $12,665 $0 $12,666 100.0% $75,996 $11,268 $64,728 85.2% $152,000 7.4% MATERIALS&SUPPLIES $406 $0 $406 100.0% $2,436 $47 $2,389 98.1% $4,900 0.9% OTHER EXPENSES $503 $25,D00 ($24,497) (4,870.2%) $34,018 $25,000 $9,018 26.5°fo $49,024 51.0°i'o DISTRIBUTION SYSTEM Total $32,249 $431,814 $4316 1.4% $224,494 $76,627 $147,867 65.9% $430,049 17,8%a Expenses Division: RESIDENTIAL FILL STATION w w SALARIES&IMAGES $30,214 $734 $29,480 97.6% $181,284 $69,742 $111,542 61.5% $362,597 19.2% EMPLOYEE BENEFITS $8,692 ($94) $8.786 101,1% $52,152 $7,907 $44,245 84.8% $104,323 7.6% OTHER EXPENSES $83 $0 $83 100.0% $498 $0 $498 100.0% $1,000 0.0% RESIDENTIAL FILL STATION Total $38,989 $639 $38,350 98.4% $233,934 $77,649 $156,285 66.8% $467,920 16.6% Expenses Division: SWRF w + s SALARIES&WAGES $7,353 $677 $6,676 90.8% $441118 $19,008 $25,110 56.9% $88,250 21.5% EMPLOYEE BENEFITS $7,026 $529 $6,497 92.5% $42,156 $16,032 $26,124 62.0% $84,325 19.0% PROFESSIONAL&LEGAL SERV $1,000 $0 $1,000 100.0% $6,000 $14,976 ($8,975) •• .', $12,000 124.8% OUTSIDE SERVICES $4,166 $0 $4,166 100.0% $24,996 $0 $24,996 100.0% $50,000 0.0% SWRF Total Expenses $19,545 $1,206 $18,339 93.8% $117,270 $50,016 $67,254 57.3%a $234,575 21.3% RECYCLED WATER Total Expenses $146,541 $241,973 ($95,432) (55.1%0) $910,246 $444,450 $465,796 51.2%Q $1,801,719 24.7% Fund#001 Total Expenses $6,970,658 $6,496,791 $473,867 6.8% $44,467,504 $41,257,378 $3,210,1.2+6 7.2%, $89,810,918 45.9% Color Key: 10% under budget or less 0 to 10%over budget } 10%over budget Agm Central Contra Costa Sanitary District Expense Report - By Division MTD Fund: 403 -SELF-INSURANCE December 2018 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 11 MTD YTD $120,000 ® Period Budget $1,400,000 YTD Budget Period Actual [ YTD Actual $100,000 $1,200,000 $1,000,000 $80,000 $800,000 $60,000 a $600,000 $40,000 ` $400,000 $20,000 F a $200,000 k Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $111,834 $5,391 $106,439 $1,245,980 $575,535 $570,444 Totals $111,830 $5,341 $1067439 $1, 45t980 $5759536 $670,444 Central Contra Costa Sanitary District Expense Report- By Division MTD Fund': 003-SELF-INSURANCE December 2016 Fiscal Period 06/2017 Report Generated on Jan 11, 2017 2:33:32 PM Page 12 Department: Division: w EMR RELATED&POLLUTION $13,749 $0 $13,749 100.0% $82,494 $301 $82,193 99.6% $165,000 0.2% GENERAL&AUTO LIABILITY $95,832 $5,391 $90,441 94.4% $574,992 $34,1643 $540,349 94,0% $1,150,000 3.0% INSURANCE&OTHER EXP $2,249 $0 $2,249 100.0% $588,494 $540,592 $47,902 8.1% $602,000 89.8% Tata!Expenses $111,830 $5,391 $106,439 95.2% $1,245,984 $575,536 $670,444 53.8% $1,917,000 30.0% Total Expenses $111,830 $5,391 $106,439 95.2%4 $1124.5,980 $575,536 $670,444 53.8% $1,917,000 30.0% Fund#-003 Total Expenses $111,830 $5,391 $106,439 95.2% $1,24.5,980 $575,536 $670,444 53.8%u $1,917,000 30.0% Color'Key- 10%under budget or fess 0 to 10%over budget > 10%over budget Ad M-- Central Contra Costa Sanitary District Expense Report - By Division MTD Fund: 004- DEBT SERVICE December 2018 Fiscal Period 06/2017 Deport Generated on Jan 11, 2017 2:33:32 PM Page 13 ' MTD f.. � YTD $1 Period Budget $250,000- ( YTD Budget []Period Actual 0 YTD Actual $200,000- $0 200,000--- $0 $150,000 $0- $100,000 ($0) $50,000 a 1 14 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $0 $0 $0 $231,448 $2311448 $0 Totals $0 0 $0 $231,448 $2319448 $0 Central Contra Costa Sanitary District fromil Expense Report- By Division MTD Fund: 014-DEET SERVICE Report Generated an Jan 11, 2017 2:33:3 December 2016 Fiscal Period 06120'i?PM Page 14 Department: r t ## OTHER EXPENSES $0 $0 $0 0.0% $231,448 $231,448 $0 0.0% $11313,051 17.6% Total Expenses $0 $0 $0 0.0% $231,448 $231,448 $0 0.0% $1,313,051 17.6% Total Expenses $0 $0 $0 0.0% $231,448 $231,448 $0 0.0% $1,313,051 17.6% Fund#044 Total Expenses $0 $0 $0 0.0% $231,448 $231,448 $0 0.0% $1,313,051 17.6% Total Expenses $7,082,488 $6,502,152 $580,306 8.2% $45,944,932 $42,064,3+62 $3,880,570 8.4% $93,040,969 45.2% Calor Ivey: 10% under budget or Fess 0 to 10%over budget > 10%over budget