Loading...
HomeMy WebLinkAboutMINUTES - 02132007 - SD.4 TO: BOARD OF SUPERVISORS -...L''O� Contra FROM: JOHN CULLEN, - _ •• COUNTYADMINISTRATOR Costa DATE: February 13,`,2007 sTA cevK` County SUBJECT: 2006-07 FY MID-YEAR BUDGET STATUS REPORT SPECIFIC REQUEST(S)OR RECOMMENDATION(S)&BACKGROUND AND JUSTIFICATION D RECOMMENDATIONS: ACCEPT this report regarding the mid-year status of the 2006-07 County Budget. BACKGROUND: The Administrator's Office annually reports the status of the County Budget as of December 31 to determine whether departmental expenses and revenues to date are consistent with the spending plan adopted, and amended from time to time, by the Board of Supervisors. Mid-year reviews provide an opportunity to identify variances from anticipated expenditures and revenue receipts, and permit budget staff to confer with departments regarding the potential need for budgetary adjustments. The mid-year budget status report is particularly important in that (a) it is based on a sufficient amount of experience during the budget year to permit a reasonably accurate assessment of how closely actual expenses and revenues are likely to track with the approved budget, and (b) it permits a relatively accurate prediction of year-end fund balance available for budget planning for the ensuing fiscal year. Our review of departmental budgets at this mid-year juncture suggests that departmental expenditures and revenues are performing substantially in accord with the approved budget. We are not asking the Board to take any corrective action at this time. This assessment could change based on intervening factors — e.g., revenue curtailments or program shifts by the State —that could affect current year costs and revenues, or that could substantially impact in a negative way our outlook for the ensuring fiscal year. [DISCUSSION This report provides an overview of the status of the County's FY 2006-2007 Budget as of December 31, 2006. Included in this report are tables that summarize the County's General Fund mid-year fiscal condition (Attachment A). CONTINUED ON ATTACHMENT: ,YES SIGNATURE: RECOMMENDATION OF COUNTY ADMINISTRATOR RECOMMENDATION OF BOARD COMMITTEE APPROVE OTHER SIGNATURE(S): --------------------------------------------------------------------------------------------------------------------------------------------------------------ACTION OF BOARD ON J r Z PROVE AS RECOMMENDED OTHER VOTE OF SUPERVISORS '.. I HEREBY CERTIFY THAT THIS IS A TRUE AND CORRECT COPY OF AN ACTION TAKEN UNANIMOUS(ABSENT. ) AND ENTERED ON THE MINUTES OF THE BOARD OF SUPERVISORS ON THE DATE AYES: NOES: SHOWN. ABSENT: ABSTAIN: � ATTESTED 44 ) O CONTACT: JOHN CULLEN,CLERK OF TFJ BOARD/OF SUPE ISORS AND COUNTY ADMINISTRATOR CC: County Administrator Auditor-Controller All County Departments BY O DEPUTY 2006/07 Mid-Year Budget Status Report February 13,2007 Page Two (2) The County's implementation of its Board-approved FY 2006-07 adjusted spending plan is proceeding as anticipated. As of December 31, 2006, with 50% of the fiscal year having passed, actual expenditures for all County funds totaled 43.8% of planned spending, while actual revenues totaled 45.5% of amounts anticipated for the year. These figures compare favorably to 42.6% and 44.2% respectively for the same period last year. For the General Fund alone, actual expenditures totaled 47.0% of planned spending, and actual revenues totaled 39.7% of amounts anticipated for the year. These figures compare favorably to our experience for the same period last year, 46.4% and 38.6% respectively. The specific dollar amounts were as follows: ALL FUNDS Second Quarter Summary Budget Actual Percent Expenditures $2,114,475,255 $,925,804,021 43.8% Revenues $ 1,964,427,546 $893,275,296 45.5% GENERALFUND Second Quarter Summary Budget Actual Percent Expenditures $1,275,416,085 $ 599,879,672 47.0% Revenues $1,239,577,366 $492,605,574 39.7% GENERALFUND Second Quarter Expenditure Summary Budget Actual Percent Wages& Benefits $ 647,850,837 $316,510,107 48.9% Services & Supplies 478,864,233 221,752,903 46.3% Other Charges 269,412,066 127,727,042 47.4% Fixed Assets 38,378,353 9,494,227 24.7% Inter-departmental Charges -159,089,404 -75,604,607 47.5% .Total Expenses $1,275,416,085 $599,879,672 47.0% GENERALFUND Second Quarter Revenue Summary Budget Actual Percent Taxes $ 286,899,747 $175,627,187 61.2% Licenses, Permits, Franchises 14,005,013 2,978,555 21.3% Fines, Forfeitures, Penalties 13,840,242 2,248;638 16.2%. Use of Money& Property 4,521,295 1,580,503 35.0% Federal/State Assistance 622,724,259 192,879,603 31.0% Charges for Current Services 208,317,574 84,932,680 40.8% Other Revenue 89,269,236 32,358,408 36.2% Total Revenues $1,239,577,366 $492,605,574 39.7% As noted above, County expenditures and revenues at mid-year were within acceptable parameters given the Board approved. budget. The difference between budgeted expenditures and revenues, $150.0 million and $35.8 million for all funds and general fund respectively, is a combination of fund balances and prior year encumbrances. Specifically, the general fund includes $9.5 million in fund balance and $26.3 million in prior year.encumbrances ($21.3 million of which is Capital projects). Although significant variances in anticipated expenses and revenue receipts are noted at the mid-year, the majority of these variances were anticipated due to labor negotiations and are noted below. 2006/07 Mid-Year Budget Status Report February 13, 2007 Page Three (3) Revenues ❑ Revenue from State and federal sources are typically late in being realized because much of it is based on expenditure claims paid in arrears. Therefore, departments that rely on State and federal revenue experience a two-to three-month lag in revenues. Expenditures ❑ Salary costs are generally understated at mid-year because salary appropriations in the budget include cost-of living adjustments, and the relatively few COLA's granted were not effective until the beginning of the second quarter, October 1, 2006. Unanticipated vacant positions also lessen salary costs, though vacancy savings continue to lag behind prior years. Some reduction in permanent salary costs is anticipated in the second half of the fiscal year due to retirements, which tend to occur in March, however, the majority of this savings is spent in retiree pay-outs. ❑ The most notable exceptional salary cost was the $1500 lump sum payment to the majority of employees, which occurred in November. The majority of departments, the exceptions are noted below, were able to absorb this one-time cost into their current year appropriations. ❑ Employee benefit costs are understated at mid-year because the budget includes appropriations for health insurance cost increases that did not become effective until the end of the second quarter, December 31, 2006. Actual expenses for employee health insurance will increase the second half of the year. ❑ Service and supplies costs are generally understated throughout most of the fiscal year because of the time required to process payments to vendors and contractors. This payment cycle averages about one month in arrears. Additionally, in very tight fiscal years departments tend to wait later in the year to make purchases to ensure that resources are not needed elsewhere. We continue to experience this phenomenon. General County Revenue General Purpose budgeted revenues total $320 million spread over approximately 50 accounts. It consists primarily of $259.7 million in taxes for current property $88.5 million of which is from Property Tax in Lieu of Vehicle License Fees (from non-realignment vehicle license fees) and $11 million in sales tax. Based on six months of experience, General Purpose Revenues will exceed the budget target. Revenues will exceed budget due to conservative budgeting of property tax revenue. In Summary, although the over-all County General Fund budget is balanced and a modest departmental balance is anticipated, the following six departments are currently projected to exceed their General Fund allocations: Animal Services The Animal Services Department is projected to under realize revenue by approximately $200,000; due almost entirely to a decrease in licensing revenue. Additionally, the department is unable to absorb $25,000 of the combination of the increase to management longevity and the department-wide lump sum payment. Clerk-Recorder The Clerk Recorder Department is projected to under realize revenue by $1.1 million and is projected to be below budgeted expenditures by 653,329, resulting in an increased net county cost of approximately $490,000. The decline in revenue is the result of a sharp drop in recording activity compared to last year. 2006/07 Mid-Year Budget Status Report February 13, 2007 Page Four (4) Health Services The Health Services Department (including Enterprise Funds) is projected to exceed its General Fund allocation by $11.9 million. The anticipated shortfall includes an additional $10.8 million County General Fund needed for employee cost of living adjustment costs. Additionally, healthcare costs for inmates are projected to be $1.1 million over the $14.7 million County General Fund budget for this area. The cost increase is due to higher inmate patient acuity and an increase in the number of inmates needing care. While the overall number of inmates is not increasing, inmates are tending to be older and have greater medical needs. The 2006-07 budget reflected a Medi-Cal rate adjustment for CCHP that would increase revenues by $3 million. However, CCHP has not yet received official notification of the rate adjustment. If the revenue from the rate adjustment is less then budgeted the current year shortfall will increase. The Contra Costa Regional Medical Center is undergoing significant changes associated with recent federal licensing issues and deficiencies. The changes required were not considered during 2006-07 budget deliberations, but will result in current year and budget year cost increases. Further information on the additional costs will be available after final federal survey results in early March. Office of Revenue Collection The Office of Revenue Collection is projected to exceed its net County cost allocation by $250,000, due to unrealized collections anticipated from the Hospital and the change in collection policy with Employment and Human Services. Public Defender The Public Defender Department is projected to exceed its General Fund allocation by $690,000. This shortfall primarily results from the impact of pay-outs for the retirement Tier II to Tier III conversion buy-back program. Retirement Expense is projecting a $520,000 shortfall due to the requirement that departments cover the County's contribution to the Retirement's buy-back program. During the first six months of the fiscal year, the Public Defender absorbed $185,671 of unbudgeted Retirement Expense as six employees completed their contributions to the buy-back program. These unbudgeted charges can be expected to continue for the remainder of the year. The Public Defender was able to absorb a significant pay equity adjustment for several classifications retroactive to July 2006, and the $1,500 per employee lump sum payment. Sheriff-Coroner The Sheriff-Coroner Department is projected to exceed its General Fund allocation by approximately $4 million. This estimate can be wholly attributed to recently negotiated labor agreements with retroactive effective dates to October 2006. Specifically, terms of the labor agreement that will impact the Sheriff's budget in FY 06/07 are: 2% COLA and a 6% increased subvention towards Retirement Expense, both retroactive to October 1, 2006; and a one-time only $250 payment made to sworn employees in December 2006. The current budget projection assumes that Proposition 172 (sales tax for public protection) revenue will come in as budgeted by year end. However, the first five payments received through January 2007 indicate that annual receipts could fall short of the $73 million Countywide budgeted level by $5 million, which would negatively impact both the Sheriff and District Attorney fiscal positions. CONCLUSION Although each of these departments will be monitored closely throughout the reminder of the fiscal year, it is unlikely that they can balance without an increased General Fund allocation. However, as noted previously, the overall General Fund budget is balanced. The County Administrator's Office is pleased with our short term progress and is cautiously optimistic for the longer term. It continues to appear that in FY 2007/08 the County will be in a position to fund the increased annual cost of services without relying heavily on service 2006/07 Mid-Year Budget Status Report February.13, 2007 Page Five (5) reductions. As was stated in our FY 2005/06 Close-Out Report, this possibility has been significantly enhanced by reaching agreement with our Labor Unions on compensation changes that are cognizant of our need to restore our fiscal health in order to improve future service delivery. These trends notwithstanding, the County will continue to face fiscal challenges, the largest of which is the rising cost of retiree health care. The County has retained an investment bank and an actuarial firm to work with the Other Post Employment Benefits (OPEB) Task Force to evaluate options for dealing with this liability. The next OPEB report is scheduled for the Board in March 2007; at which time recommendations will be presented. Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date 100300 0001 DEPARTMENT OF SUPERVISORS E1000 Salaries and Benefits 2,555,108 1,149,492 E2000 Services and Supplies 3,350,523 704,722 E3000 Other Charges 169,128 300 E5000 Expenditure Transfers 123,250 14,944 TOTEXP Total Expenditures 6,198,009 1,869,458 R9200 LICENSE/PERMIT/FRANCHISES 169,000 76,628 R9600 CHARGES FOR SERVICES 356,579 114,905 R9800 MISCELLANEOUS REVENUE 752 TOTREV Gross Revenue 525,579 192,285 NETCOST NET COUNTY COST(NCC) 5,672,430 1;677,173 100300 0007 BOARD MITIGATION PROGRAMS E1000 Salaries and Benefits 181,376 97,682 E2000 Services and Supplies 1,615,754 942,064 E3000 Other Charges 194,000 10,520 TOTEXP Total Expenditures 1,991,130 1,050,266 R9100 TAXES OTHER THAN CUR PROP 410,000 185,274 R9200 LICENSE/PERMIT/FRANCHISES 1,056,934 R9600 CHARGES FOR SERVICES 933,821 TOTREV Gross Revenue 1,466,934 1,119,095 NETCOST NET COUNTY COST(NCC) 524,196 -68,829 100300 0036 PERSONNEL MERIT BOARD E1000 Salaries and Benefits 49,030 6,749 E2000 Services and Supplies 47,946 10,183 TOTEXP Total Expenditures 96,976 16,931 R9600 CHARGES FOR SERVICES 30,959 R9800 MISCELLANEOUS REVENUE 450 TOTREV Gross Revenue 30,959 450 NETCOST NET COUNTY COST (NCC) 66,017 16,481 100300 0025 MANAGEMENT INFORMATION SYSTEM E1000 Salaries and Benefits 309,087 121,696 E2000 Services and Supplies 747,966 49,325 E3000 Other Charges 64,000 23,928 E4000 Fixed Assets 28,335 E5000 Expenditure Transfers -100,000 TOTEXP Total Expenditures 1,021,053 223,284 R9600 CHARGES FOR SERVICES 250,000 TOTREV Gross Revenue 250,000 NETCOST NET COUNTY COST(NCC) 771,053 223,284 100300 0135 ECONOMIC PROMOTION E1000 Salaries and Benefits 176 E2000 Services and Supplies 67,332 21,630 TOTEXP Total Expenditures 67,332 21,806 R9500 INTERGOVERNMENTAL REVENUE 10,000 TOTREV Gross Revenue 10,000 NETCOST NET COUNTY COST(NCC) 57,332 21,806 100300 0145 EMPLOYEE/RETIREE BENEFITS E1000 Salaries and Benefits 995,716 445,244 Page 1 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date E2000 Services and Supplies 1,577,502 489,198 E4000 Fixed Assets 73,500 TOTEXP Total Expenditures 2,646,718 934,442 R9800 MISCELLANEOUS REVENUE 20,743 TOTREV Gross Revenue . 20,743 NETCOST NET COUNTY COST(NCC) 2,646,718 913,699 100300 0150 INSURANCE AND RISK MGMT E1000 Salaries and Benefits 3,769,165 1,719,796 E2000 Services and Supplies 5,002,269 451,165 E3000 Other Charges 3,099,721 E4000 Fixed Assets 73,393 TOTEXP Total Expenditures 11,944,548 2,170,961 R9200 LICENSE/PERMIT/FRANCHISES 468,000 213,193 R9800 MISCELLANEOUS REVENUE 5,948,057 1,787,502 TOTREV Gross Revenue 6,416,057, 2,000,696 NETCOST NET COUNTY COST(NCC) 5,528,491 170,265 100300 0790 NOTES &WARRANTS INTEREST E2000 Services and Supplies 100,000 47,689 E3000 Other Charges -2,180,932 TOTEXP Total Expenditures 100,000 -2,133,243 NETCOST NET COUNTY COST(NCC) 100,000 -2,133,243 135000 0791 RETIREMENT UAAL BOND FUND E2000 Services and Supplies 2,570,137 2,000 E3000 Other Charges 52,061,000 15,383,000 TOTEXP Total Expenditures 54,631,137 15,385,000 R9400 USE OF MONEY& PROPERTY 842,000 176,347 R9800 MISCELLANEOUS REVENUE 52,060,000 24,899,180 TOTREV Gross Revenue 52,902,000 25,075,527 NETCOST NET FUND COST(NCC) 1,729,137 -9,690,527 115000 0792 NOTES &WARRANTS INTEREST E2000 Services and Supplies -497 E3000 Other Charges 250 -173,260 TOTEXP Total Expenditures 250 -173,757 NETCOST NET FUND COST(NCC) 250 -173,757 135200 0793 RET LITGTN STLMNT DBT SVC E3000 Other Charges 2,759,912 TOTEXP Total Expenditures 2,759,912 R9800 MISCELLANEOUS REVENUE 2,759,912 1,379,956 TOTREV Gross Revenue 2,759,912 1,379,956 NETCOST NET FUND COST(NCC) 0 -1,379,956 100300 0002 CLERK OF THE BOARD E1000 Salaries and Benefits 543,548 300,256 E2000 Services and Supplies 66,747 20,015 E5000 Expenditure Transfers -9 TOTEXP Total Expenditures 610,295 320,262 R9200 LICENSE/PERMIT/FRANCHISES 58,000 26,421 R9600 CHARGES FOR SERVICES 100,500 . 27,064 Page 2 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTREV Gross Revenue 158,500 53,486 NETCOST NET COUNTY COST(NCC) 451,795 266,776 100300 0003 COUNTY ADMINISTRATOR E1000 Salaries and Benefits 4,008,566 1,920,853 E2000 Services and Supplies 1,364,727 561,097 E3000 Other Charges 188 E4000 Fixed Assets 25,000 E5000 Expenditure Transfers -975,558 -148,547 TOTEXP Total Expenditures 41422,735 2,333,591 R9200 LICENSE/PERMIT/FRANCHISES 105,000 6,833 R9500 INTERGOVERNMENTAL REVENUE 382,000 R9600 CHARGES FOR SERVICES 308,666 84,658 R9800 MISCELLANEOUS REVENUE 93,500 92,398 TOTREV Gross Revenue 889,166 183,889 NETCOST NET COUNTY COST(NCC) 3,533,569 2,149,702 100300 0004 CROCKETT-RODEO REVENUES E2000 Services and Supplies 282,032 E3000 Other Charges 309,288 TOTEXP Total Expenditures 591,320 NETCOST NET COUNTY COST(NCC) 591,320 0 100300 0018 COUNTY-STATE-WCCHCD IGT E3000 Other Charges 10,000,000 6,000,000 TOTEXP Total Expenditures 10,000,000 6,000,000 TOTREV Gross Revenue 10,000,000 NETCOST NET COUNTY COST(NCC) 0 6,000,000 100300 0026 REVENUE COLLECTIONS E1000 Salaries and Benefits 2,815,742 1,328,992 E2000 Services and Supplies 670,670. 311,993 E3000 Other Charges 100 -1,240 E4000 Fixed Assets 16,910 E5000 Expenditure Transfers -584,000 -194,412 TOTEXP Total Expenditures 2,919,422 1,445,334 R9300 FINES/FORFEITS/PENALTIES 230,000 92,637 R9600 CHARGES FOR SERVICES 2,413,000 867,724 TOTREV Gross Revenue 2,643,000 960,361 .NETCOST NET COUNTY COST(NCC) 276,422 484,973 100300 0059 COMMUNITY ACCESS TV E2000 Services and Supplies 691,295 217,129 TOTEXP Total Expenditures 691,295 217,129 R9200 LICENSE/PERMIT/FRANCHISES 670,000 128,066 R9600 CHARGES FOR SERVICES 1,308,996 R9800 MISCELLANEOUS REVENUE 372,075 TOTREV Gross Revenue 670,000 1,809,137 NETCOST NET COUNTY COST(NCC) 21,295• -1,592,008 100300 0147 INFORMATION TECHNOLOGY E1000 Salaries and Benefits 8,130,733 4,005,267 E2000 Services and Supplies 2,777,262 1,332,095 Page 3 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date E3000 Other Charges 527,604 277,416 E4000 Fixed Assets 53,000 28,359 E5000 Expenditure Transfers -8,469,416 -3,974,514 TOTEXP Total Expenditures 3,019,183 1,668,623 R9600 CHARGES FOR SERVICES 2,984,168 1,364,114 R9800 MISCELLANEOUS REVENUE 10 TOTREV Gross Revenue 2,984,168 1,364,124 NETCOST NET COUNTY COST(NCC) 35,015 304,499 100300 0060 TELECOMMUNICATIONS E1000 Salaries and Benefits 2,406,247 1,142,771 E2000 Services and Supplies 3,780,330 1,590,146 E3000 Other Charges 633,300 324,505 E4000 Fixed Assets 38,200 22,234 E5000 Expenditure Transfers -4,055,394 -2,001,317 TOTEXP Total Expenditures 2,802,683 1,078,339 R9400 USE OF MONEY& PROPERTY 542,746 334,208 R9600 CHARGES FOR SERVICES 2,158,295 1,024,344 R9800 MISCELLANEOUS REVENUE 43,980 TOTREV Gross Revenue 2,745,021 1,358,551 NETCOST NET COUNTY COST(NCC) 57,662 -280,212 100300 0235 LAW &JUSTICE SYSTEMS DEV E1000 Salaries and Benefits 250,098 76,771 E2000 Services and Supplies 202,599 88,565 E5000 Expenditure Transfers -53,900 TOTEXP Total Expenditures 398,797 165,336 R9600 CHARGES FOR SERVICES 146,300 -22,460 R9800 MISCELLANEOUS REVENUE 28,780 TOTREV Gross Revenue 175,080 -22,460 NETCOST NET COUNTY COST(NCC) 223,717 187,796 134000 0272 AVA SERVICE AUTHORITY E2000 Services and Supplies 982,258 376,366 E5000 Expenditure Transfers 78,947 TOTEXP Total Expenditures 982,258 455,313 R9500 INTERGOVERNMENTAL REVENUE 878,000 458,752 TOTREV Gross Revenue 878,000 458,752 NETCOST NET FUND COST(NCC) 104,258 -3,439 100300 0356 LOCAL AGENCY FORMATION E1000 Salaries and Benefits 21,430 E2000 Services and Supplies 450 E3000 Other Charges. 205,401 205,401 TOTEXP Total Expenditures 205,401 227,281 NETCOST NET COUNTY COST(NCC) 205,401 227,281 100300 0581 ZERO TLRNCE DOM VIOL INIT E2000 Services and Supplies 2,050,617 317,605 E5000 Expenditure Transfers -42,000 TOTEXP' Total Expenditures 2,050,617 275,605 R9500 INTERGOVERNMENTAL REVENUE 475,000 67,008 TOTREV Gross Revenue 475,000 67,008 Page 4 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date NETCOST NET COUNTY COST(NCC) 1,575,617 208,597 112700 0586 ZERO TOLRNCE-DOM VIOLENCE E1000 Salaries and Benefits 86,249 E2000 Services and Supplies 211,806 21,239 E3000 Other Charges 40,273 2,066 TOTEXP Total Expenditures 252,079 109,554 R9400 USE OF MONEY& PROPERTY 1,165 R9600 CHARGES FOR SERVICES 175,272 93,228 TOTREV Gross Revenue 175,272 94,394 NETCOST NET FUND COST(NCC) 76,807 15,160 100300 0005 REVENUE- GENERAL COUNTY E3000 Other Charges 265 TOTEXP Total Expenditures 265 R9000 TAXES CURRENT PROPERTY 259,670,000 166,470,972 R9100 TAXES OTHER THAN CUR PROP 26,729,747 8,970,941 R9200 LICENSE/PERMIT/FRANCHISES 8,050,000 1,335,309 R9300 FINES/FORFEITS/PENALTIES 9,500,000 192,655 R9400 USE OF MONEY& PROPERTY 2,700,000 832,173 R9500 INTERGOVERNMENTAL REVENUE 4,170,000 2,731,721 R9600 CHARGES FOR SERVICES 8,380,000 -15,329 R9800 MISCELLANEOUS REVENUE 764,995 811,674 TOTREV Gross Revenue 320,081,822 181,330,116 NETCOST NET COUNTY COST(NCC) -320,081,822 -181,329,851 100300 0035 HUMAN RESOURCES E1000 Salaries and Benefits 5,091,769 2,105,020 E2000 Services and Supplies 3,947,738 1,501,263 E5000 Expenditure Transfers -635,486 -124,718 TOTEXP Total Expenditures 8,404,021 3,481,566 R9200 LICENSE/PERMIT/FRANCHISES 181,246 82,565 R9600 CHARGES FOR SERVICES 2,655,061 678,921 R9800 MISCELLANEOUS REVENUE 2,981,714 1,241,448 TOTREV Gross Revenue 5,818,021 2,002,934 NETCOST NET COUNTY COST(NCC) 2,586,000 1,478,632 100300 0038 CHILD CARE E2000 Services and Supplies 950,393 E5000 Expenditure Transfers -15,507 TOTEXP :.._ Total Expenditures 950,393 -15,507 R9600 CHARGES FOR SERVICES 11,000 5,771 R9800 MISCELLANEOUS REVENUE 6,500 TOTREV Gross Revenue 17,500 5,771 NETCOST NET COUNTY COST(NCC) 932,893 -21,278 115000 0009 REVENUE-AUTOMATED SYS DEV R9400 USE OF MONEY& PROPERTY 70,000 232,235 TOTREV Gross Revenue 70,000 232,235 NETCOST NET FUND COST(NCC) -70,000 -232,235 100300 0010 AUDITOR-CONTROLLER E1000 Salaries and Benefits 6,901,946 3,082,903 Page 5 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date E2000 Services and Supplies 1,660,122 893,208 E3000 Other Charges 300 E5000 Expenditure Transfers -803,071 -336,614 TOTEXP Total Expenditures 7,758,997 3,639,797 R9600 CHARGES FOR SERVICES 4,041,738 2,033,599 R9800 MISCELLANEOUS REVENUE 170,000 147 TOTREV Gross Revenue 4,211,738 2,033,746 NETCOST NET COUNTY COST(NCC) 3,547,259 1,606,051 115000 0011 AUTOMATED SYSTEMS DVLPMNT E5000 Expenditure Transfers 170,000 TOTEXP Total Expenditures 170,000 NETCOST NET FUND COST (NCC) 170,000 0 115200 0012 VLF SECURITIZATION E3000 Other Charges 314 TOTEXP. Total Expenditures 314 R9400 USE OF MONEY& PROPERTY 82,114 TOTREV Gross Revenue 82,114 NETCOST NET FUND COST(NCC) 0 -81,800 100300 0080 MINOR CAP IMPROVEMENTS E2000 Services and Supplies 533,237 33,352 TOTEXP Total Expenditures 533,237 33,352 NETCOST NET COUNTY COST(NCC) 533,237 33,352 100300 0111 PLANT ACQUIS-GENERAL FUND E2000 Services and Supplies 39,273 E4000 Fixed Assets 30,076,905 6,688,834 TOTEXP Total Expenditures 30,076,905 6,728,108 R9300 FINES/FORFEITS/PENALTIES 1,300 R9600 CHARGES FOR SERVICES 62 R9800 MISCELLANEOUS REVENUE -330,232 TOTREV Gross Revenue -328,870 NETCOST NET COUNTY COST(NCC) 30,076,905 7,056,978 110600 0119 CRIM JUST FACILITY CNSTRN E2000 Services and Supplies 4,994,580 E3000 Other Charges 586,637 TOTEXP Total Expenditures 5,581,217 R9300 FINES/FORFEITS/PENALTIES 1,278,000 538,557 R9400 USE OF MONEY& PROPERTY 120,000 51,587 TOTREV Gross Revenue 1,398,000 590,144 NETCOST NET FUND COST(NCC) 4,183,217 -590,144 110700 0122 COURTHOUSE CONSTRUCTION E3000 Other Charges 1,397,500 996,717 TOTEXP Total Expenditures 1,397,500 996,717 R9300 FINES/FORFEITS/PENALTIES 1,070,000 451,780 R9400 USE OF MONEY& PROPERTY -1,413 R9500 INTERGOVERNMENTAL REVENUE 327,500 TOTREV Gross Revenue 1,397,500 450,366 NETCOST NET FUND COST(NCC) 0 546,351 Page 6 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date 105800 0128 JUVENILE HALL-CAP PRJ E2000 Services and Supplies 70,684 TOTEXP Total Expenditures 70,684 R9400 USE OF MONEY&PROPERTY 860 TOTREV Gross Revenue 860 NETCOST NET FUND COST(NCC) 70,684 -860 100300 0015 TREASURER-TAX COLLECTOR E1000 Salaries and Benefits 3,660,697 1,692,963 E2000 Services and Supplies 1,410,151 795,979 E3000 Other Charges 9,000 13,923 E4000 Fixed Assets 99,712 99,712 TOTEXP Total Expenditures 5,179,560 2,602,577 R9300 FINES/FORFEITS/PENALTIES 290,000 39,020 R9600 CHARGES FOR SERVICES 1,953,000 1,496,651 R9800 MISCELLANEOUS REVENUE 498,000 34,252 TOTREV Gross Revenue 2,741,000 1,569,923 NETCOST NET COUNTY COST(NCC) 2,438,560 1,032,654 100300 0016 ASSESSOR E1000 Salaries and Benefits 14,140,061 6,648,175 E2000 Services and Supplies 2,038,558 1,175,422 E3000 Other Charges 4,900 1,250 E4000 Fixed Assets 10,000 E5000 Expenditure Transfers -300,000 -1,353 TOTEXP Total Expenditures 15,893,519 7,823,494 R9600 CHARGES FOR SERVICES 1,132,900 274,525 R9800 MISCELLANEOUS REVENUE 58,000 15,707 TOTREV Gross Revenue 1,190,900 290,232 NETCOST NET COUNTY COST(NCC) 14,702,619 7,533,262 115100 0017 PROPERTY TAX ADMIN E5000 Expenditure Transfers 4,727,873 TOTEXP Total Expenditures 4,727,873 R9400 USE OF MONEY & PROPERTY 32,938 R9600 CHARGES FOR SERVICES 2,022,000 TOTREV Gross Revenue 2,022,000 32,938 NETCOST NET FUND COST(NCC) 2,705,873 -32,938 100300 0030 COUNTY COUNSEL E1000 Salaries and Benefits 7,152,433 3,321,889 E2000 Services and Supplies 698,258 239,083 E5000 Expenditure Transfers -3,527,866 -1,538,997 TOTEXP Total Expenditures 4,322,825 2,021,975 R9600 CHARGES FOR SERVICES 2,508,983 1,095,973 TOTREV Gross Revenue 2,508,983 1,095,973 NETCOST NET COUNTY COST(NCC) 1,813,842 926,002 100300 0301 HLTH SVCS-DETENTION INMATES E10.00 Salaries and Benefits 9,103,395 4,856,232 E2000 Services and Supplies 6,995,129 4,108,083 E5000 Expenditure Transfers -1,009,679 -656,840 Page 7 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTEXP Total Expenditures 15,088,845 8,307,475 R9500 INTERGOVERNMENTAL REVENUE 214,185 58,522 R9600 CHARGES FOR SERVICES 1,379 R9800 MISCELLANEOUS REVENUE 136,698 70,800 TOTREV Gross Revenue 350,883 130,700 NETCOST NET COUNTY COST (NCC) 14,737,962 8,176,775 100300 0450 HEALTH SVCS-PUBLIC HEALTH E1000 Salaries and Benefits 31,903,781 15,901,671 E2000 Services and Supplies 8,273,845 4,807,338 E4000 Fixed Assets 105,000 8,498 E5000 Expenditure Transfers -3,674,671 -1,636,158 TOTEXP Total Expenditures 36,607,955 19,081,349 R9200 LICENSE/PERMIT/FRANCHISES 40,809 11,529 R9300 FINES/FORFEITS/PENALTIES 8,520 3,946 R9400 USE OF MONEY & PROPERTY 9,845 9,734 R9500 INTERGOVERNMENTAL REVENUE 18,736,669 7,945,587 R9600 CHARGES FOR SERVICES 4,620,309 2,352,700 R9800 MISCELLANEOUS REVENUE 1,273,448 1,004,555 TOTREV Gross Revenue 24,689,600 11,328,051 NETCOST NET COUNTY COST (NCC) 11,918,355 7,753,298 100300 0451 CONSERVATOR/GUARDIANSHIP E1000 Salaries and Benefits 1,550,525 792,579 E2000 Services and Supplies 237,850 110,615 E5000 Expenditure Transfers -12,680 TOTEXP Total Expenditures 1,775,695 903,194 R9500 INTERGOVERNMENTAL REVENUE 50,000 285,128 R9600 CHARGES FOR SERVICES 143,675 60,661 R9800 MISCELLANEOUS REVENUE 2,458 1,585 TOTREV Gross Revenue 196,133 347,374 NETCOST NET COUNTY COST (NCC) 1,579,562 555,820 100300 0452 HEALTH SVCS-ENVIRON HLTH E1000 Salaries and Benefits 10,894,875 5,181,742 E2000 Services and Supplies 4,075,766 1,610,601 E3000 Other Charges 600 E4000 Fixed Assets 47,039 E5000 Expenditure Transfers 323 TOTEXP Total Expenditures 15,017,680 6,793,266 R9200 LICENSE/PERMIT/FRANCHISES 109,194 37,934 R9300 FINES/FORFEITS/PENALTIES 72,111 241,456 R9500 INTERGOVERNMENTAL REVENUE 62,549 70,834 R9600 CHARGES FOR SERVICES 14,827,517 10,042,571 R9800 MISCELLANEOUS REVENUE 238,715 64,650 TOTREV Gross Revenue 15,310,086 10,457,446 NETCOST NET COUNTY COST (NCC) -292,406 -3,664,180 100300 0460 HLTH SVC-CALIF CHILD SVCS E1000 Salaries and Benefits 6,642,799 3,280,253 E2000 Services and Supplies 951,322 462,574 TOTEXP Total Expenditures 7,594,121 3,742,827 R9500 INTERGOVERNMENTAL REVENUE 5,939,026 1,341,156 Page 8 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9600 CHARGES FOR SERVICES 282,214 220,721 R9800 MISCELLANEOUS REVENUE 116 70 TOTREV Gross Revenue 6,221,356 1,561,947 NETCOST NET COUNTY COST(NCC) 1,372,765 2,180,880 100300 0463 HSD HOMELESS PROGRAM E1000 Salaries and Benefits 461,794 221,986 E2000 Services and Supplies 3,579,942 1,713,211 E5000 Expenditure Transfers -398,020 -93,563 TOTEXP Total Expenditures 3,643,716 1,841,633 R9200 LICENSE/PERMIT/FRANCHISES 5,000 R9400 USE OF MONEY& PROPERTY 47,280 1,800 R9500 INTERGOVERNMENTAL REVENUE . 2,771,014 -66,252 R9800 MISCELLANEOUS REVENUE 109,182 104,548 TOTREV Gross Revenue 2,932,476 40,096 NETCOST NET COUNTY COST(NCC) 711,240 1,801,537 100300 0465 HLTH SVS-HOSPITAL SUBSIDY E3000 Other Charges 50,280,360 25,140,180 TOTEXP Total Expenditures 50,280,360 25,140,180 NETCOST NET COUNTY COST(NCC) 50,280,360 25,140,180 100300 0466 ALCOHOL &OTHER DRUGS SVC E1000 Salaries and Benefits 5,037,581 2,286,162 E2000 Services and Supplies 12,896,426 5,260,407 E3000 Other Charges 33,736 10,636 E5000 Expenditure Transfers -1,209,216 -189,538 TOTEXP Total Expenditures 16,758,527 7,367,667 R9300 FINES/FORFEITS/PENALTIES 441,869 203,847 R9400 USE OF MONEY& PROPERTY 158,160 88,849 R9500 INTERGOVERNMENTAL REVENUE 9,834,113 4,688,884 R9600 CHARGES FOR SERVICES 3,599,029 2,001,383 R9800 MISCELLANEOUS REVENUE 2,357,893 293,250 TOTREV Gross Revenue 16,391,064 7,276,213 NETCOST NET COUNTY COST(NCC) 367,463 91,454 100300 0467 HLTH SERVICES-MNTL HLTH E1000 Salaries and Benefits 31,725,018 14,732,892 E2000 Services and Supplies 78,154,627 33,092,213 E3000 Other Charges 1,053,358 564,721 E4000 Fixed Assets 57,963 E5000 Expenditure Transfers -2,238,177 -609,977 TOTEXP Total Expenditures 108,752,789 47,779,848 R9200. LICENSE/PERMIT/FRANCHISES 70,000 26,864 R9400 USE OF MONEY& PROPERTY 291,584 21,700 R9500 INTERGOVERNMENTAL REVENUE 58,594,693 27,545,634 R9600 CHARGES FOR SERVICES 38,765,434 14,217,377 R9800 MISCELLANEOUS REVENUE 2,535,564 87,717 TOTREV Gross Revenue 100,257,275 41,899,290 NETCOST NET COUNTY COST(NCC) 8,495,514 5,880,558 113700 0468 HLTH SVCS-CHIP AB75 TOBACCO E2000 Services and Supplies 56,975 -48,301 Page 9 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTEXP Total Expenditures 56,975 -48,301 R9400 USE OF MONEY& PROPERTY 2,811 R9500 INTERGOVERNMENTAL REVENUE 55,170 0 TOTREV Gross Revenue 55,170 2,811 NETCOST NET FUND COST(NCC) 1,805 -51,112 113700 0469 HLTH-CHIP/AB75 TOBACCO E2000 Services and Supplies 848,383 TOTEXP Total Expenditures 848,383 R9500 INTERGOVERNMENTAL REVENUE 848,383 167,725 TOTREV . Gross Revenue 848,383 167,725 NETCOST NET FUND COST(NCC) 0 -167,725 113500 0471 EMERGENCY MEDICAL SVCS E2000 Services and Supplies 1,431,469 382,009 TOTEXP Total Expenditures 1,431,469 382,009 R9300 FINES/FORFEITS/PENALTIES 1,430,061 481,914 R9400 USE OF MONEY& PROPERTY 1,167 1,042 R9800 MISCELLANEOUS REVENUE 35 TOTREV Gross Revenue 1,431,228 482,991 NETCOST NET FUND COST(NCC) 241 -100,982 113600 0470 PROP 36-SUB ABUSE CP ACT E2000 Services and Supplies 802,196 E3000 Other Charges 184,493 E5000 Expenditure Transfers 3,102,962 629,227 TOTEXP Total Expenditures 4,089,651 629,227 R9400 USE OF MONEY & PROPERTY 40,000 27,445 R9500 INTERGOVERNMENTAL REVENUE 2,838,358 2,608,757 TOTREV Gross Revenue 2,878,358 2,636,202 NETCOST NET FUND COST(NCC) 1,211,293 -2,006,975 145000 0540 HLTH SVS-HOSPITAL ENTRPSE E1000 Salaries and Benefits 220,063,655 113,637,680 E2000 Services and Supplies 86,334,315 43,451,816 E3000 Other Charges 12,200,000 E4000 Fixed Assets 0 TOTEXP Total Expenditures 318,597,970 157,089,495 TOTREV Gross Revenue 318,597,970 172,105,736 NETCOST NET FUND COST(NCC) 0 -15,016,241 112500 0585 DOM VIOLENCE VICTIM ASIST E5000 Expenditure Transfers 148,682 0 TOTEXP Total Expenditures 148,682 0 R9200 LICENSE/PERMIT/FRANCHISES 98,008 0 R9300 FINES/FORFEITS/PENALTIES 36,000 3,938 TOTREV Gross Revenue 134,008 3,938 NETCOST NET FUND COST(NCC) 14,674 -3,938 145000 0853 HOSPITIAL FIXED ASSETS E3000 . Other Charges 5,665,022 2,841,787 E4000 Fixed Assets 9,314,978 276,895 TOTEXP Total Expenditures 14,980,000 3,118,681 Page 10 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTREV Gross Revenue 14,980,000 4,665,000 NETCOST NET FUND. COST (NCC) 0 -1,546,319 146000 0860 CONTRA COSTA HEALTH PLAN E1000 Salaries and Benefits 9,573,209 5,008,090 E2000 Services and Supplies 51,371,078 30,200,824 E3000 Other Charges 3,756,018 1,717,323 TOTEXP Total Expenditures 64,700,305 36,926,237 TOTREV Gross Revenue 64,700,305 26,689,969 NETCOST NET FUND COST(NCC) 0 10,236,268 146100 0861 CCHP-COMMUNITY PLAN E2000 Services and Supplies 87,469,228 39,783,354 TOTEXP Total Expenditures 87,469,228 39,783,354 TOTREV Gross Revenue 87,469,228 34,594,587 NETCOST NET FUND COST (NCC) 0 5,188,767 146200 0862 MAJOR RISK MED INS BD PRGM E2000 Services and Supplies 1,233,645 1,263,326 TOTEXP Total Expenditures 1,233,645 1,263,326 TOTREV Gross Revenue 1,233,645 706,525 NETCOST NET FUND COST (NCC) 0 556,801 146000 0863 HEALTH PLAN FIXED ASSETS E3000 Other Charges 25,000 E4000 Fixed Assets 50,000 TOTEXP Total Expenditures 75,000 TOTREV Gross Revenue 75,000 100300 0535 SERVICE INTEGRATION E1000 Salaries and Benefits 14,856 E2000 Services and Supplies 486,026 140,077 E4000 Fixed Assets 5,000 E5000 Expenditure Transfers -3,750 TOTEXP Total Expenditures 491,026 151,183 R9500 INTERGOVERNMENTAL REVENUE 0 R9800 MISCELLANEOUS REVENUE 333,581 280,825 TOTREV Gross Revenue 333,581 280,825 NETCOST NET COUNTY COST(NCC) 157,445 -129,642 100300 0501 EHSD ADMINISTRATIVE SERVICES E1000 Salaries and Benefits 22,645,208 12,742,430 E2000 Services and Supplies 14,341,585 7,345,905 E3000 Other Charges 752,398 8,092 E4000 Fixed Assets 135,483 E5000 Expenditure Transfers -32,934,867 -18,903,270 TOTEXP Total Expenditures 4,939,807 1,193,157 R9500 INTERGOVERNMENTAL REVENUE 4,760,235 13,576,758 R9600 CHARGES FOR SERVICES 43,116 R9800 MISCELLANEOUS REVENUE 868 TOTREV Gross Revenue 4,760,235 13,620,742 NETCOST NET COUNTY COST(NCC) 179,572 -12,427,585 Pagel 1 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date 100300 0502 EHSD CHILDREN & FAMILY SERVICES E1000 Salaries and Benefits 40,409,306 20,837,597 E2000 Services and Supplies 28,809,442 15,413,777 E3000 Other Charges 50,727,153 25,159,096 E5000 Expenditure Transfers -100,000 -599,971 TOTEXP Total Expenditures 119,845,901 60,810,499 R9200 LICENSE/PERMIT/FRANCHISES 159,000 72,431 R9500 INTERGOVERNMENTAL REVENUE 93,027,348 25,440,079 R9600 CHARGES FOR SERVICES 9,840 R9800 MISCELLANEOUS REVENUE 191,345 251,994 TOTREV Gross Revenue 93,377,693 25,774,344 NETCOST NET COUNTY COST(NCC) 26,468,208 35,036,155 100300 0503 EHSD AGING &ADULT SERVICES E1000 Salaries and Benefits 29,914,432 15,653,115 E2000 Services and Supplies 42,075,018 21,602,813 E3000 Other Charges 14,039,336 8,313,971 E5000 Expenditure Transfers -1,590,191 -377,651 TOTEXP Total Expenditures 84,438,595 45,192,248 R9200 LICENSE/PERMIT/FRANCHISES 0 R9400 USE OF MONEY & PROPERTY 78,000 45,185 R9500 INTERGOVERNMENTAL REVENUE 86,193,994 15,624,654 R9600 CHARGES FOR SERVICES 261,295 69,471 R9800 MISCELLANEOUS REVENUE 276,000 122,411 TOTREV Gross Revenue 86,809,289 15,861,721 NETCOST NET COUNTY COST(NCC) -2,370,694 29,330,527 100300 0504 EHSD WORKFORCE SERVICES E1000 Salaries and Benefits 43,522,963 21,378,295 E2000 Services and Supplies 36,434,069 14,282,178 E3000 Other Charges 75,366,709 39,977,597 E5000 Expenditure Transfers -17,087,944 -7,761,939 TOTEXP Total Expenditures 138,235,797 67,876,130 R9400 USE OF MONEY& PROPERTY 342,437 92,496 R9500 INTERGOVERNMENTAL REVENUE 132,297,841 35,976,812 R9800 MISCELLANEOUS REVENUE 565,229 33,016 TOTREV Gross Revenue 133,205,507 36,102,324 NETCOST NET COUNTY COST(NCC) 5,030,290 31,773,806 132800 0505 COUNTY CHILDRENS E2000 Services and Supplies 166,720 24,248 TOTEXP Total Expenditures 166,720 24,248 R9600 CHARGES FOR SERVICES 201,579 155,264 TOTREV Gross Revenue 201,579 155,264 NETCOST NET FUND COST(NCC) -34,859 -131,016 100300 0507 ANN ADLER CHILD & FAMILY E2000 Services and Supplies 92,461 5,036 TOTEXP Total Expenditures 92,461 5,036 R9800 MISCELLANEOUS REVENUE 92,461 124,763 TOTREV Gross Revenue 92,461 124,763 NETCOST NET COUNTY COST (NCC) 0 -119,727 Page 12 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date 115500 0508 IHSS PUBLIC AUTHORITY E1000 Salaries and Benefits 1,228,385 647,991 E2000 Services and Supplies 169,590 159,848 E3000 Other Charges 136,370 131,669 TOTEXP Total Expenditures 1,534,345 939,508 R9500 INTERGOVERNMENTAL REVENUE 1,115,775 22,753 R9800 MISCELLANEOUS REVENUE 409,809 TOTREV Gross Revenue 1,525,584 -22,753 NETCOST NET FUND COST(NCC) 8,761 962,261 100300 0583 EHSD WFRC INVESTMENT BOAR E1000 Salaries and Benefits 1,807,641 360,831 E2000 Services and Supplies 4,223,131 1,939,987 E3000 Other Charges 33,474 E5000 Expenditure Transfers -2,999 TOTEXP Total Expenditures 6,030,772 2,331,293 R9400 USE OF MONEY & PROPERTY 27 R9500 INTERGOVERNMENTAL REVENUE 6,019,953 909,559 R9800 MISCELLANEOUS REVENUE 10,819 89,762 TOTREV Gross Revenue 6,030,772 999,348 NETCOST NET COUNTY COST(NCC) 0 1,331,945 100300 0202 TRIAL COURT PROGRAMS E1000 Salaries and Benefits 132,618 E2000 Services and Supplies 2,771,000 1,358,356 E3000 Other Charges 17,721,590 8,047,587 TOTEXP Total Expenditures 20,492,590 9,538,560 R9200 LICENSE/PERMIT/FRANCHISES 25,000 10,485 R9300 FINES/FORFEITS/PENALTIES 2,773,742 1,258,433 R9500 INTERGOVERNMENTAL REVENUE 100,000 40,803 R9600 CHARGES FOR SERVICES 6,304,444 2,700,380 TOTREV Gross Revenue 9,203,186 4,010,101 NETCOST NET COUNTY COST(NCC) 11,289,404 5,528,459 100300 0238 CIVIL GRAND JURY E2000 Services and Supplies 146,710 42,733 E3000 Other Charges 129 TOTEXP Total Expenditures 146,710 42,862 NETCOST NET COUNTY COST(NCC) 146,710 42,862 100300 0239 CRIMINAL GRAND JURY E2000 Services and Supplies 50,000 5,081 TOTEXP Total Expenditures 50,000 5,081 NETCOST NET COUNTY COST(NCC) 50,000 5,081 100300 0246 DISPUTE RESOLUTION PROGRAM E2000 Services and Supplies 367,647 60,061 TOTEXP Total Expenditures 367,647 60,061 R9600 CHARGES FOR SERVICES 220,000 -34,400 TOTREV Gross Revenue 220,000 -34,400 NETCOST NET COUNTY COST(NCC) 147,647 94,461 100300' 0248 CONFLICT DEFENSE SERVICES Page 13 of 37 Attachment A Mid-Year Budget Status Report Current Year Total .Fund Adjusted Budget Year-to-Date E2000 Services and Supplies 2,077,045 1,055,744 TOTEXP Total Expenditures 2,077,045 1,055,744 NETCOST NET COUNTY COST(NCC) 2,077,045 1,055,744 114000 0260 AUTOMATED ID &WARRANT E2000 Services and Supplies 2,036,563 2,477 E3000 Other Charges 175,000 29,908 E4000 Fixed Assets 1,192,678 E5000 Expenditure Transfers 28,780 TOTEXP Total Expenditures 3,433,021 32,385 R9300 FINES/FORFEITS/PENALTIES 390,000 160,627 R9600 CHARGES FOR SERVICES 225,000 260,000 R9800 MISCELLANEOUS REVENUE 60,000 TOTREV Gross Revenue 675,000 420,627 NETCOST NET FUND COST(NCC) 2,758,021 -388,242 114300 0264 SLESF-FRONT LINE ENF-CITY E3000 Other Charges 2,300,000 2,152,543 TOTEXP Total Expenditures 2,300,000 2,152,543 R9500 INTERGOVERNMENTAL REVENUE 2,300,000 2,394,741 TOTREV Gross Revenue 2,300,000 2,394,741 NETCOST NET FUND COST(NCC) 0 -242,198 100300 0265 VEHICLE THEFT PROGRAM E2000 Services and Supplies 1,395,059 TOTEXP Total Expenditures 1,395,059 R9500 INTERGOVERNMENTAL REVENUE 910,000 458,834 TOTREV Gross Revenue 910,000 458,834 NETCOST NET COUNTY COST(NCC) 485,059 -458,834 114400 0267 LOCAL LAW ENF BJP 2748 E2000 Services and Supplies 256,482 TOTEXP Total Expenditures 256,482 R9400 USE OF.MONEY & PROPERTY 1 TOTREV Gross Revenue 1 NETCOST NET FUND COST(NCC) 256,482 -1 114400 0269 LOCAL LAW ENF BJP 4006 E2000 Services and Supplies -256,376 TOTEXP Total Expenditures -256,376 NETCOST NET FUND COST(NCC) -256,376 0 115600 0275 DNA IDENTIFICATION FUND E2000 Services and Supplies 187,962 TOTEXP Total Expenditures 187,962 R9300 FINES/FORFEITS/PENALTIES 84,500 44,993 TOTREV Gross Revenue 84,500 44,993 NETCOST NET FUND COST(NCC) 103,462 -44,993 100300 0325 JUSTICE SYSTEM PROGRAMS E2000 Services and Supplies 91,600 26,326 E3000 Other Charges 64,534 13,648 E5000 Expenditure Transfers 50,000 Page 14 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date TOTEXP Total Expenditures 206,134 39,974 R9500 INTERGOVERNMENTAL REVENUE 146,134 54,603 TOTREV Gross Revenue 146,134 54,603 NETCOST NET COUNTY COST(NCC) 60,000 -14,629 100300 0043 ELECTIONS E1000 Salaries and Benefits 3,094,534 1,671,644 E2000 Services and Supplies 4,630,752 3,446,768 E3000 Other Charges 6,575 E4000 Fixed Assets 4,003,533 TOTEXP Total Expenditures 11,728,819 5,124,987 R9500 INTERGOVERNMENTAL REVENUE 1,831,520 R9600 CHARGES FOR SERVICES 7,119,037 789,498 R9800 MISCELLANEOUS REVENUE 15,000 14,655 TOTREV Gross Revenue 7,134,037 2,635,673 NETCOST NET COUNTY COST(NCC) 4,594,782 2,489,314 110100 0237 CLERK RECORDS AUTOMATION E2000 Services and Supplies 6 E3000 Other Charges 12 TOTEXP Total Expenditures 18 R9600 CHARGES FOR SERVICES 24 TOTREV Gross Revenue 24 NETCOST NET FUND COST(NCC) 18 -24 110000 0353 RECORDER MICRO/MOD E1000 Salaries and Benefits 1,065,328 525,841 E2000 Services and Supplies 10,976,196 849,899 E3000 Other Charges 193,157 205,873 . E4000 Fixed Assets 5,522,275 381,237 TOTEXP Total Expenditures 17,756,956 1,962,849 R9600 CHARGES FOR SERVICES 2,352,500 1,492,212 R9800 MISCELLANEOUS REVENUE 3,969 TOTREV Gross Revenue 2,352,500 1,496,180 NETCOST NET FUND COST(NCC) 15,404,456 466,669 100300 0355 RECORDER E1000 Salaries and Benefits 3,253,291 1,484,192 E2000 Services and Supplies 1,055,219 360,868 E3000 Other Charges 300 E4000 Fixed Assets 11,000 E5000 Expenditure Transfers -5,000 -475 TOTEXP Total Expenditures 4,314,510 1,844,885 R9100 TAXES OTHER THAN CUR PROP 90,000 R9600 CHARGES FOR SERVICES 6,122,313 2,560,934 R9800 MISCELLANEOUS REVENUE 50,000 12,871 TOTREV Gross Revenue 6,262,313 2,573,806 NETCOST NET COUNTY COST(NCC) -1,947,803 -728,921 105600 0126 CO LAW ENF COMPTR CAP-PRJ E2000 Services and Supplies 2,341,152 -25 E3000 Other Charges 209 TOTEXP Total Expenditures 2,341,152 184 Page 15 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date R9400 USE OF MONEY& PROPERTY 96,050 R9500 INTERGOVERNMENTAL REVENUE 3,520,087 R9600 CHARGES FOR SERVICES 100 TOTREV Gross Revenue 3,616,237 NETCOST NET FUND COST(NCC) 2,341,152 -3,616,053 105600 0129 CO LAW ENF COMM CAP-PROJ E2000 Services and Supplies 2,617,769 TOTEXP Total Expenditures 2,617,769 R9600 CHARGES FOR SERVICES 51,000 103,194 R9800 MISCELLANEOUS REVENUE 120,000 84,715 TOTREV Gross Revenue 171,000 187,909 NETCOST NET FUND COST (NCC) 2,446,769 -187,909 105600 0131 CO LAW ENF HLCPTR CAP PRJ E2000 Services and Supplies 545,176 TOTEXP Total Expenditures 545,176 R9800 MISCELLANEOUS REVENUE 82,000 61,783 TOTREV Gross Revenue 82,000 61,783 NETCOST NET FUND COST (NCC) 463,176 -61,783 114200 0252 SHER FORFEIT-FED-DOJ E2000 Services and Supplies 162,410 E3000 Other Charges 25 TOTEXP Total Expenditures 162,410 25 R9400 USE OF MONEY & PROPERTY 2,000 . 2,546 R9800 MISCELLANEOUS REVENUE 14,616 TOTREV Gross Revenue 2,000 17,161 NETCOST NET FUND COST(NCC) 160,410 -17,136 114100 0253 SHER NARC FRFEIT-ST/LOCAL E2000 Services and Supplies 299,995 0 E3000 Other Charges 330 240 TOTEXP Total Expenditures 300,325 240 R9400 USE OF MONEY& PROPERTY 8,456 R9800 MISCELLANEOUS REVENUE 45,000 32,299 TOTREV Gross Revenue 45,000 40,755 NETCOST NET FUND COST (NCC) 255,325 -40,515 100300 0255 SHERIFF E1000 Salaries and Benefits 86,626,103 42,508,532 E2000 Services and Supplies 10,017,539 5,357,597 E3000 Other Charges - 9,932 159,463 E4000 Fixed Assets 594,057 265,148 E5000 Expenditure Transfers -1,023,699 105,673 TOTEXP Total Expenditures 96,223,932 48,396,414 R9200 LICENSE/PERMIT/FRANCHISES 474,214 25,107 R9300 FINES/FORFEITS/PENALTIES 209,000 96,511 R9400 USE OF MONEY & PROPERTY 38,192 R9500 INTERGOVERNMENTAL REVENUE 34,998,458 11,017,397 R9600 CHARGES FOR SERVICES 34,936,577 10,942,169 R9800 MISCELLANEOUS REVENUE 2,638,377 218,907 TOTREV Gross Revenue 73,256,626 22,338,283 Page 16 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date NETCOST NET COUNTY COST (NCC) 22,967,306 26,058,131 110400 0256 CRIMINALISTIC LAB FUND E2000 Services and Supplies 131,414 1,450 E3000 Other Charges 2,400 1,783 TOTEXP Total Expenditures 133,814 3,234 R9300 FINES/FORFEITS/PENALTIES 50,000 7,623 R9400 USE OF MONEY &PROPERTY 1,240 TOTREV Gross Revenue 50,000 8,863 NETCOST NET FUND COST(NCC) 83,814 -5,629 142000 0258 SHERIFF LAW ENF TRNG CNTR E1000 Salaries and Benefits 803,384 619,188 E2000 Services and Supplies 256,086 97,980 E3000 Other Charges 86,352 52,085 TOTEXP. Total Expenditures 1,145,822 769,253 R9500 INTERGOVERNMENTAL REVENUE 380,000 165,937 R9600 CHARGES FOR SERVICES 765,822 364,097 TOTREV Gross Revenue 1,145,822 530,034 NETCOST NET FUND COST (NCC) 0 239,219 114300 0262 SLESF-JAIL CONSTR & OPS E2000 Services and Supplies 38,616 E3000 Other Charges 325,000 849 E5000 Expenditure Transfers 250,000 TOTEXP Total Expenditures 613,616 849 R9500 INTERGOVERNMENTAL REVENUE 334,457 339,424 TOTREV Gross Revenue 334,457 339,424 NETCOST NET FUND COST(NCC) 279,159 -338,575 114300 0263 SLESF-FRONT LINE ENF-CO E3000 Other Charges 95,145 912 E5000 Expenditure Transfers 124,293 TOTEXP Total Expenditures 219,438 912 R9400 USE OF MONEY& PROPERTY 75,941 R9500 INTERGOVERNMENTAL REVENUE 294,195 317,468 TOTREV Gross Revenue 294,195 393,409 NETCOST NET FUND COST (NCC) -74,757 -392,497 114500 0268 SHER FORFEIT-FED TREASURY E2000 Services and Supplies 142,967 E3000 Other Charges 25 TOTEXP Total Expenditures 142,967 25 R9400 USE OF MONEY& PROPERTY 1,806 TOTREV Gross Revenue 1,806 NETCOST NET FUND COST (NCC) 142,967 -1,781 136000 0270 CENTRAL IDENTIFY BUREAU E2000 Services and Supplies 1,429,804 E3000 Other Charges 1,000 184 E5000 Expenditure Transfers 1,505,222 TOTEXP Total Expenditures 2,936,026 184 R9400 USE OF MONEY& PROPERTY 50,000 57,136 Page 17 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9500 INTERGOVERNMENTAL REVENUE 965,000 741,879 R9800 MISCELLANEOUS REVENUE 137,871 TOTREV Gross Revenue 1,015,000 936,886 NETCOST NET FUND COST(NCC) 1,921,026 -936,702 133400 0271 CO-WIDE GANG AND DRUG E2000 Services and Supplies 812,252 E3000 Other Charges 1,125 112 TOTEXP Total Expenditures 813,377 112 R9400 USE OF MONEY& PROPERTY 5,000 17,592 R9500 INTERGOVERNMENTAL REVENUE 100,000 38,397 TOTREV Gross Revenue 105,000 55,989 NETCOST NET FUND COST(NCC) 708,377 -55,877 114700 0273 PRISONERS WELFARE E1000 Salaries and Benefits 461,677 237,849 E2000 Services and Supplies 2,499,167 478,471 E3000 Other Charges 4,860 13,426 E4000 Fixed Assets 28,352 28,353 E5000 Expenditure Transfers 5,000 TOTEXP Total Expenditures 2,994,056 763,099 R9400 USE OF MONEY& PROPERTY 6,000 _ 34,825 R9600 CHARGES.FOR SERVICES 23,000 23,263 R9800 MISCELLANEOUS REVENUE 1,510,600 568,013 TOTREV Gross Revenue 1,539,600 626,101 NETCOST NET FUND COST(NCC) 1,454,456 136,998 136000 0274 AB 879 R9500 INTERGOVERNMENTAL REVENUE 458,710 TOTREV Gross Revenue 458,710 NETCOST NET FUND COST(NCC) 0 -458,710 100300 0300 CUSTODY SERVICES BUREAU E1000 Salaries and Benefits 61,991,303 30,678,551 E2000 Services and Supplies 5,691,016 2,956,519 E3000 Other Charges 6,625 E4000 Fixed Assets 40,000 E5000 Expenditure Transfers -180,000 -94,203 TOTEXP Total Expenditures 67,542,319 33,547,492 R9300 FINES/FORFEITS/PENALTIES 164 R9500 INTERGOVERNMENTAL REVENUE 26,578,928. 8,165,702 R9600 CHARGES FOR SERVICES 17,594,106 1,077,082 R9800 MISCELLANEOUS REVENUE 5,000 3,894 TOTREV Gross Revenue 44,178,034 9,246,841 NETCOST NET COUNTY COST(NCC) 23,364,285 24,300,651 100300 0359 CORONER E1000 Salaries and Benefits 1,538,307 770,075 E2000 Services and Supplies 928,160 629,776 TOTEXP Total Expenditures 2,466,467 1,399,851 R9600 CHARGES FOR SERVICES 54,000 43,165 R9800 MISCELLANEOUS REVENUE 12,000 10,498 TOTREV Gross Revenue 66,000 53,663 Page 18 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date NETCOST NET COUNTY COST(NCC) 2,400,467 1,346,188 100300 0362 EMERGENCY SERVICES E1000 Salaries and Benefits 5,265,985 2,230,739 E2000 Services and Supplies 2,021,346 1,826,453 E3000 Other Charges 535 E4000 Fixed Assets 1,126,285 1,436,180 E5000 Expenditure Transfers -1,219,089 -443,898 TOTEXP Total Expenditures 7,194,527 5,050,009 R9500 INTERGOVERNMENTAL REVENUE 1,878,037 848,593 R9600 CHARGES FOR SERVICES 10,000 2,855 R9800 MISCELLANEOUS REVENUE 25,000 26,487 TOTREV Gross Revenue 1,913,037 877,935 NETCOST NET COUNTY COST(NCC) 5,281,490 4,172,074 113900 0368 . TRAFFIC SAFETY E2000 Services and Supplies 81,932 112 E3000 Other Charges 66,006 26 E4000 Fixed Assets . 71,655 TOTEXP Total Expenditures 219,593 138 R9300 FINES/FORFEITS/PENALTIES 15,000 9,908 R9400 USE OF MONEY & PROPERTY 2,652 R9600 CHARGES FOR SERVICES 2,511 TOTREV Gross Revenue 15,000 15,072 NETCOST NET FUND COST (NCC) 204,593 -14,934 100300 0308 PROBATION PROGRAMS E1000 Salaries and Benefits 24,346,607 11,891,426 E2000 Services and Supplies 1,845,511. 903,447 E3000 Other Charges 44,500 41,870 E5000 Expenditure Transfers -863,974. -73,370 TOTEXP Total Expenditures 25,372,644 12,763,372 R9500 INTERGOVERNMENTAL REVENUE 6,791,061 1,421,111 R9600 CHARGES FOR SERVICES 1,165,844 289,678 R9800 MISCELLANEOUS REVENUE 3,523,876 1,158,225 TOTREV Gross Revenue 11,480,781 2,869,014 NETCOST NET COUNTY COST(NCC) 13,891,863 9,894,358 100300 0309 PROBATION FACILITIES E1000 Salaries and Benefits 23,855,328 12,068,473 E2000 Services and Supplies 2,172,544 1,192,555 E3000 Other Charges 12,100 1,044 E5000 Expenditure Transfers -197,000 -50,600 TOTEXP Total Expenditures 25,842,972 13,211,473 R9500 INTERGOVERNMENTAL REVENUE 7,118,125 2,242,923 R9600 CHARGES FOR SERVICES 135,470 79,346 R9800 MISCELLANEOUS REVENUE 432,332 93,592 TOTREV Gross Revenue 7,685,927 2,415,861 NETCOST NET COUNTY COST(NCC) 18,157,045 10,795,612 100300 0310 PROB CARE OF COURT WARDS E2000 Services and Supplies 1,017,479 504,846 E3000 Other Charges 6,139,050 2,496,664 Page 19 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget . Year-to-Date TOTEXP Total Expenditures 7,156,529 3,001,510 R9500 INTERGOVERNMENTAL REVENUE 2,910,283 1,115,070 TOTREV Gross Revenue 2,91.0,283 1,115,070 NETCOST NET COUNTY COST(NCC) 4,246,246 1,886,440 114300 0311 SLESF-PROBATION E5000 Expenditure Transfers 3,589,483 891,591 TOTEXP Total Expenditures 3,589,483 891,591 R9400 USE OF MONEY & PROPERTY 40,000 R9500 INTERGOVERNMENTAL REVENUE 2,788,203 3,287,763 TOTREV Gross Revenue 2,828,203 3,287,763 NETCOST NET FUND COST(NCC) 761,280 -2,396,172 114900 0313 PROBATION OFFICERS SPECIAL FUND E2000 Services and Supplies 117,103 7,518 TOTEXP Total Expenditures 117,103 7,518 R9800 MISCELLANEOUS REVENUE 33,000 15,520 TOTREV Gross Revenue 33,000 15,520 NETCOST NET FUND COST (NCC) 84,103 -8,002 100300 0335 AGRICULTURE-WEIGHTS/MEAS E1000 Salaries and Benefits 3,935,688 1,880,127 E2000 Services and Supplies 550,733 258,112 TOTEXP Total Expenditures 4,486,421 2,138,239 R9300 FINES/FORFEITS/PENALTIES 10,000 26,965 R9500 INTERGOVERNMENTAL REVENUE 2,193,840 246,048 R9600 CHARGES FOR SERVICES 683,192 220,041 R9800 MISCELLANEOUS REVENUE 40,000 16,895 TOTREV Gross Revenue 2,927,032 509,950 NETCOST NET COUNTY COST (NCC) 1,559,389 1,628,289 110300 0341 BLDG INSP LAND DEVLPMNT E1000 Salaries and Benefits 13,318,755 6,020,977 E2000 Services and Supplies 26,119,658 987,251 E3000 Other Charges 1,318,185 802,109 E4000 Fixed Assets 398,627 196,630 E5000 Expenditure Transfers -179,328 -18,061 TOTEXP Total Expenditures 40,975,897 7,988,906 R9200 LICENSE/PERMIT/FRANCHISES 14,044,020 13,094,030 R9400 USE OF MONEY & PROPERTY 133,123 391,312 R9600 CHARGES FOR SERVICES 355,850 122,234 R9800 MISCELLANEOUS REVENUE 1,901,435 633,599 TOTREV Gross Revenue 16,434,428 14,241,175 NETCOST NET FUND COST (NCC) 24,541,469 -6,252,269 100300 0591 HOUSING REHABILITATION E1000 Salaries and Benefits 389,847 204,348 E2000 Services and Supplies 40,830 11,128 TOTEXP Total Expenditures 430,677 215,475 R9200 LICENSE/PERMIT/FRANCHISES 14,267 R9500 INTERGOVERNMENTAL REVENUE 430,677 R9800 MISCELLANEOUS REVENUE 23,917 TOTREV Gross Revenue 430,677 38,184 Page 20 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date NETCOST NET COUNTY COST (NCC) 0 177,291 111900 0351 . USED OIL RECYCLING GRANT E2000 Services and Supplies 100,000 8,649 E3000 Other Charges 23,000 22 E5000 Expenditure Transfers 27,000 2,300 TOTEXP Total Expenditures 150,000 10,971 R9400 USE OF MONEY& PROPERTY1,500 330 R9500 INTERGOVERNMENTAL REVENUE 148,500 30,024 R9800 MISCELLANEOUS REVENUE -4,098 TOTREV Gross Revenue 150,000 26,256 NETCOST NET FUND COST(NCC) 0 -15,285 110300 0352 COMM DEV-LAND DEVELOPMENT E2000 Services and Supplies 6,484,771 685,975 E3000 Other Charges 138,000 22,238 E4000 Fixed Assets 95,000 E5000 Expenditure Transfers 5,351,601 2,490,242 TOTEXP Total Expenditures 12,069,372 3,198,455 R9200 LICENSE/PERMIT/F=RANCHISES 2,094,656 1,687,324 R9400 USE OF MONEY& PROPERTY 250,000 189,930 R9500 INTERGOVERNMENTAL REVENUE 46,000 R9600 CHARGES FOR SERVICES 5,230,114 14,357,827 R9800 MISCELLANEOUS REVENUE 860,000 202,778 TOTREV Gross Revenue 8,480,770 16,437,859 NETCOST NET FUND COST(NCC) 3,588,602 -13,239,404 100300 0357 COMMUNITY DEVELOPMENT E1000 Salaries and Benefits 8,276,147 4,000,730 E2000 Services and Supplies 2,026,816 735,683 E3000 Other Charges 250,000 E4000 Fixed Assets 198,896 E5000 Expenditure Transfers -1,117,949 -482,576 TOTEXP Total Expenditures 9,383,910 4,503,837 R9600 CHARGES FOR SERVICES 129,693 32,139 R9800 MISCELLANEOUS REVENUE 8,254,552 3,479,020 TOTREV Gross Revenue 8,384,245 3,511,159 NETCOST NET COUNTY COST.(NCC) 999,665 992,678 110200 0367 GAME PROTECTION E2000 Services and Supplies 141,365 2,696 E3000 Other Charges 863 118 E5000 Expenditure Transfers 3,000 20,625 TOTEXP Total Expenditures 145,228 23,439 R9300 FINES/FORFEITS/PENALTIES 7,000 7,251 R9800 MISCELLANEOUS REVENUE 50,000 24,500 TOTREV Gross Revenue 57,000 31,751 NETCOST NET FUND COST(NCC) 88,228 =8,312 133700 0370 LIVABLE COMMUNITIES E3000 Other Charges 1,583,961 TOTEXP Total Expenditures 1,583,961 R9400 USE OF MONEY & PROPERTY 20,000 12,900 Page 21 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9600 CHARGES FOR SERVICES 500,000 128,000 TOTREV Gross Revenue 520,000 140,900 NETCOST NET FUND COST(NCC) 1,063,961 -140,900 100300 0472 GENERAL SEWER PLANNING E2000 Services and Supplies 20,272 20,272 TOTEXP Total Expenditures 20,272 20,272 NETCOST NET COUNTY COST(NCC) 20,272 20,272 134700 0582 CDBG SM BUS&MICROENT LOAN E2000 Services and Supplies 267,041 TOTEXP Total Expenditures 267,041 R9400 USE OF MONEY& PROPERTY 2,297 R9500 INTERGOVERNMENTAL REVENUE 80,000 37,687 TOTREV Gross Revenue 80,000 39,983 NETCOST NET FUND COST(NCC) 187,041 -39,983 100300 0590 HOPWA GRANT E2000 Services and Supplies 494,193 8,476 TOTEXP Total Expenditures 494,193 8,476 R9500 INTERGOVERNMENTAL REVENUE 494,193 -15,474 TOTREV Gross Revenue 494,193 -15,474 NETCOST NET COUNTY COST(NCC) 0 23,950 100300 0592 HUD BLOCK GRANT E2000 Services and Supplies 5,415,236 853,428 E3000 Other Charges 500,000 1,848 TOTEXP Total Expenditures 5,915,236 855,276 R9500 INTERGOVERNMENTAL REVENUE 5,892,236 949,533 R9800 MISCELLANEOUS REVENUE 23,000 22,022 TOTREV Gross Revenue 5,915,236 971,555 NETCOST NET COUNTY COST(NCC) 0 -116,279 100300 0593 HUD EMERGENCY SHELTER GRT E1000 Salaries and Benefits 491 E2000 Services and Supplies 151,254 7,997 TOTEXP Total Expenditures 151,254 8,488 R9500 INTERGOVERNMENTAL REVENUE 151,254 7,436 TOTREV. Gross Revenue 151,254 7,436 NETCOST NET COUNTY COST(NCC) 0 1,052 100300 0594 HUD HOME BLOCK GRANT E2000 Services and Supplies 6,182,719 4,445,320 TOTEXP Total Expenditures 6,182,719 4,445,320 R9500 INTERGOVERNMENTAL REVENUE 6,182,719 4,410,498 R9800 MISCELLANEOUS REVENUE 45 TOTREV Gross Revenue 6,182,719 4,410,544 NETCOST NET COUNTY COST(NCC) 0 34,776 111100 0595 PRIVATE ACTIVITY BOND E2000 Services and Supplies 2,943,763 38,066 E3000 Other Charges 604,600 9,497 E5000 Expenditure Transfers 600,000 43,148 Page 22 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTEXP Total Expenditures 4,148,363 90,711 R9400 USE OF MONEY& PROPERTY 130,000 79,590 R9600 CHARGES FOR SERVICES 515,000 124,059 R9800 MISCELLANEOUS REVENUE 1,000 TOTREV Gross Revenue 646,000 203,650 NETCOST NET FUND COST(NCC) 3,502,363 . -112,939 111300 0596 AFFORDABLE HOUSING E2000 Services and Supplies 2,124,428 E3000 Other Charges 350 77 TOTEXP Total Expenditures 2,124,778 77 R9400 USE OF MONEY& PROPERTY 203,000 46,063 TOTREV Gross Revenue 203,000 46,063 NETCOST NET FUND COST(NCC) 1,921,778 -45,986 134900 0597 HUD BLDG INSP NPP E2000 Services and Supplies 1,240,495 389,151 E3000 Other Charges. 315,000 E5000 Expenditure Transfers 15,000 13,785 TOTEXP Total Expenditures 1,570,495 402,936 R9400 USE OF MONEY& PROPERTY 15,000 10,976 R9500 INTERGOVERNMENTAL REVENUE 1,000,000 6,544,970 R9600 CHARGES FOR SERVICES 500,000 TOTREV Gross Revenue 1,515,000 6,555,946 NETCOST NET FUND COST(NCC) 55,495 -6,153,010 134800 0598 CDBG 1ST-TIME HMBHR LOAN E2000 Services and Supplies 384,377 29,644 E5000 Expenditure Transfers 8,000 8,237 TOTEXP Total Expenditures 392,377 37,881 R9400 USE OF MONEY&PROPERTY 8,000 1,388 R9500 INTERGOVERNMENTAL REVENUE 262,949 78,545 TOTREV Gross Revenue 270,949 79,933 NETCOST NET FUND COST(NCC) 121,428 -42,052 110900 0663 TRANSPRTATN IMPV MEASURE C E3000 Other Charges 2,250,001 52,754 E5000 Expenditure Transfers 1,710 TOTEXP Total Expenditures 2,250,001 54,464 R9400 USE OF MONEY &PROPERTY 100,000 66,141 R9500 INTERGOVERNMENTAL REVENUE 2,150,000 5,873,266 TOTREV Gross Revenue 2,250,000 5,939,407 NETCOST NET FUND COST(NCC) 1 -5,884,943 113200 0664 PH BART GREENSPACE MTCE E2000 Services and Supplies 153,752 E3000 Other Charges 29,333 TOTEXP Total Expenditures 153,752 29,333 R9400 USE OF MONEY&PROPERTY 9,000 2,841 TOTREV Gross Revenue 9,000 2,841 NETCOST NET FUND COST(NCC) 144,752 26,492 100300 0701 PARKS ADMINISTRATION Page 23 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9500 INTERGOVERNMENTAL REVENUE 42,743 TOTREV Gross Revenue 42,743 NETCOST NET COUNTY COST (NCC) 0 -42,743 100300 0366 ANIMAL SERVICES E1000 Salaries and Benefits 7,730,148 3,706,042 E2000 Services and Supplies 1,909,274 951,692 E3000 Other Charges 2,332 E4000 Fixed Assets 15,439 7,439 TOTEXP Total Expenditures 9,654,861 4,667,506 R9200 LICENSE/PERMIT/FRANCHISES 1,926,070 798,653 R9600 CHARGES FOR SERVICES 3,675,868 2,078,661 R9800 MISCELLANEOUS REVENUE 30,625 12,684 TOTREV Gross Revenue 5,632,563 2,889,997 NETCOST NET COUNTY COST (NCC) 4,022,298 1,777,509 133200 0369 ANIMAL BENEFIT E2000 Services and Supplies 406,818 TOTEXP Total Expenditures 406,818 R9400 USE OF MONEY & PROPERTY 4,830 R9800 MISCELLANEOUS REVENUE 15,000 16,071 TOTREV Gross Revenue 15,000 20,901 NETCOST NET FUND COST (NCC) 391,818 -20,901 113400 0249 CCC DEPT CHILD SPPRT SVCS E1000 Salaries and Benefits 17,170,252 7,750,276 E2000 Services and Supplies 1,577,488 586,932 E3000 Other Charges 1,083,835 476,728 E4000 Fixed Assets 5,000 5,175 TOTEXP Total Expenditures 19,836,575 8,819,111 R9400 USE OF MONEY& PROPERTY -5,047 R9500 INTERGOVERNMENTAL REVENUE 19,233,160 2,675,675 R9600 _ CHARGES FOR SERVICES 167,928 1,292 R9800 MISCELLANEOUS REVENUE 7,171 TOTREV Gross Revenue 19,401,088 2,679,091 NETCOST NET FUND COST (NCC) 435,487 6,140,020 113300 0233 RESTATE FRAUD PROSECUTE E5000 Expenditure Transfers 2,285,018 TOTEXP Total Expenditures 2,285,018 R9600 CHARGES FOR SERVICES 375,380 219,998 TOTREV Gross Revenue 375,380 219,998 NETCOST NET FUND COST (NCC) 1,909,638 -219,998 113100 0234 DA FORFEITURE-FED-DOJ E2000 Services and Supplies 66,904 5,615 TOTEXP Total Expenditures 66,904 5,615 R9400 USE OF MONEY& PROPERTY 811 R9500 INTERGOVERNMENTAL REVENUE 3,400 TOTREV Gross Revenue 4,211 NETCOST NET FUND COST (NCC) 66,904 1,404 114300 0241 SLESF-CRIM PROSECUTION Page 24 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date E1000 Salaries and Benefits 539,125 146,517 E2000 Services and Supplies 134 395 E3000 Other Charges 8,501 5,404 TOTEXP Total Expenditures 547,760 152,316 R9500 INTERGOVERNMENTAL REVENUE 285,660 339,424 TOTREV Gross Revenue 285,660 339,424 NETCOST NET FUND COST(NCC) 262,100 -187,108 100300 0242 DISTRICT ATTORNEY E1000 Salaries and Benefits 24,981,998 11,063,075 E2000 Services and Supplies 2,587,531 1,162,878 E3000 Other Charges 20,125 E5000 Expenditure Transfers -1,007,425 TOTEXP Total Expenditures 26,562,104 12,246,078 R9300 FINES/FORFEITS/PENALTIES 305,000 91,704 R9500 INTERGOVERNMENTAL REVENUE 14,928,627 4,736,927 R9800 MISCELLANEOUS REVENUE 626,530 23,394 TOTREV Gross Revenue 15,860,157 4,852,025 NETCOST NET COUNTY COST(NCC) 10,701,947 7,394,053 112900 0244 D A REVENUE NARCOTICS E1000 Salaries and Benefits 86,224 44,894 E2000 Services and Supplies 3,000 155 E3000 Other Charges 33 E5000 Expenditure Transfers 215,150 TOTEXP Total Expenditures 304,374 45,082 R9600 CHARGES FOR SERVICES 6,850 R9800 MISCELLANEOUS REVENUE 304,374 59,554 TOTREV Gross Revenue 304,374 66,404 NETCOST NET FUND COST(NCC) 0 -21,322 100300 0245 D A WELFARE FRAUD E1000 Salaries and Benefits 416,233 174,140 E2000 Services and Supplies 101,703 36,178 E3000 Other Charges 300 E5000 Expenditure Transfers -517,936 -90,209 TOTEXP Total Expenditures 0 120,409 NETCOST NET COUNTY COST(NCC) 0 120,409 112400 0247 DA CONSUMER PROTECTION E2000 Services and Supplies 220,806 .TOTEXP Total Expenditures 220,806 NETCOST NET FUND COST(NCC) 220,806 0 100300 0364 PUBLIC ADMINISTRATOR E1000 Salaries and Benefits 242,440 125,012 E2000 Services and Supplies 20,286 11,096 TOTEXP Total Expenditures 262,726 136,108 R9600 CHARGES FOR SERVICES 100,000 126,632 TOTREV Gross Revenue 100,000 126,632 NETCOST NET COUNTY COST(NCC) 162,726 9,476 113000 0251 DA ENVIRON/OSHA Page 25 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date E2000 Services and Supplies 44,218 888 TOTEXP Total Expenditures 44,218 888 NETCOST NET FUND COST(NCC) 44,218 888 100300 0243 PUBLIC DEFENDER E1000 Salaries and Benefits 17,636,540 9,059,043 E2000 Services and Supplies 2,447,668 1,241,248 E3000 Other Charges 5,000 E5000 Expenditure Transfers -269,936 -28,333 TOTEXP Total Expenditures 19,814,272 10,276,958 R9500 . INTERGOVERNMENTAL REVENUE 50,057 18,704 R9600 CHARGES FOR SERVICES 3,182,058 520,315 R9800 MISCELLANEOUS REVENUE 1,025 TOTREV Gross Revenue 3,232,115 540,044 NETCOST NET COUNTY COST(NCC) 16,582,157 9,736,914 114800 0584 COMM COLL CHILD DEV-DEPT E1000 Salaries and Benefits 162,992 125,863 E2000 Services and Supplies 205,112 715 E3000 Other Charges 308 134 E5000 Expenditure Transfers 1,340,446 714,528 TOTEXP Total Expenditures 1,708,858 841,240 R9500 INTERGOVERNMENTAL REVENUE 1,242,457 408,507 R9800 MISCELLANEOUS REVENUE 423,773 83,781 TOTREV Gross Revenue 1,666,230 492,288 NETCOST NET FUND COST(NCC) 42,628 348,952 100300 0588 COMMUNITY SERVICES . E1000 Salaries and Benefits 15,237,953 7,364,986 E2000 Services and Supplies 8,074,652 5,004,808 E3000 Other Charges 440 E4000 Fixed Assets 9,945 9,945 E5000 Expenditure Transfers 8,434,784 2,900,942 TOTEXP Total Expenditures 31,757,334 15,281,122 R9400 USE OF MONEY& PROPERTY 1 243,855 22,280 R9500 INTERGOVERNMENTAL REVENUE 21,670,810 7,649,929 R9800 MISCELLANEOUS REVENUE 9,605,689 5,067,819 TOTREV Gross Revenue 31,520,354 12,740,027 NETCOST NET COUNTY COST(NCC) 236,980 2,541,095 111600 0589 CHILD DEV-DEPT E1000 Salaries and Benefits 5,926,416 2,763,705 E2000 Services and Supplies 1,468,292 554,853 E3000 Other Charges 48,435 25,810 E4000 Fixed Assets 120,000 E5000 Expenditure Transfers 6,612,799 3,345,571 TOTEXP Total Expenditures 14,175,942 6,689,939 R9400 USE OF MONEY& PROPERTY 8,295 -19,510 R9500 INTERGOVERNMENTAL REVENUE 7,815,930 3,927,021 R9800 MISCELLANEOUS REVENUE 6,362,062 2,664,552 TOTREV Gross Revenue 14,186,287 6,572,062 NETCOST NET FUND COST(NCC) -10,345 117,877 Page 26 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date 110800 0006 GENERAL ROAD FUND REVENUE R9400 USE OF MONEY & PROPERTY 50,000 142,766 R9500 INTERGOVERNMENTAL REVENUE 18,650,000 12,285,243 TOTREV Gross Revenue 18,700,000 12,428,008 NETCOST NET FUND COST (NCC) -18,700,000 712,428,008 111000 0120 PLANT ACQ-SNS CRNT DRN FD E2000 Services and Supplies 83,917 E3000 Other Charges 114,011 49 TOTEXP Total Expenditures 224,686 49 R9200 LICENSE/PERMIT/FRANCHISES 9,000 3,413 R9400 USE OF MONEY & PROPERTY 4,080 5,103 TOTREV Gross Revenue 13,080 8,516 NETCOST NET FUND COST (NCC) 211,606 -8,467 110500 0161 SURVEY MONUMENT PRESERVTN E2000 Services and Supplies 505,949 E3060 Other Charges 600 63 E5000 Expenditure Transfers 123,300 36,426 TOTEXP Total Expenditures 629,849 36,489 R9400 USE OF MONEY& PROPERTY 8,000 11,915 R9600 CHARGES FOR SERVICES 96,000 38,160 TOTREV Gross Revenue 104,000 50,075 NETCOST NET FUND COST (NCC) 525,849 -13,586 100300 0330 CO DRAINAGE MAINTENANCE E2000 Services and Supplies 581,650 395,029 E3000 Other Charges 50 32 E5000 Expenditure Transfers 500 391 TOTEXP Total Expenditures 582,200 395,453 R9600 CHARGES FOR SERVICES 7,594 R9800 MISCELLANEOUS REVENUE 578,600 TOTREV Gross Revenue 578,600 7,594 NETCOST NET COUNTY COST(NCC) 3,600 387,859 112100 0350 CDD/PWD JOINT REVIEW FEE E2000 Services and Supplies 0 E3000 Other Charges 2,000 578 E5000 Expenditure Transfers 705,000 -27,399 TOTEXP Total Expenditures 707,000 -26,821 R9400 USE OF MONEY & PROPERTY 12,000 15,645 R9600 CHARGES FOR SERVICES 695,000 1,342,755 TOTREV Gross Revenue 707,000 1,358,399 NETCOST NET FUND COST (NCC) 0 -1,385,220 123100 0631 HERCUL/RODEO/CROCK A OF B E2000 Services and Supplies 50,000 E3000 Other Charges 250 51 E5000 Expenditure Transfers 44,000 103 TOTEXP Total Expenditures 99,250 154 R9400 USE OF MONEY &PROPERTY 3,000 4,290 R9600 CHARGES FOR SERVICES 40,000 9,888 R9800 MISCELLANEOUS REVENUE 155,703 Page 27 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTREV Gross Revenue 198,703 14,178 NETCOST NET FUND COST(NCC) -99,453 -14,024 123200 0632 WEST COUNTY AREA OF BENEF E3000 Other Charges 4 1 E5000 Expenditure Transfers 22,093 7,1.21 TOTEXP Total Expenditures 22,097 7,122 R9400 USE OF MONEY& PROPERTY 40 25 R9600 CHARGES FOR SERVICES 20,000 10,733 TOTREV Gross Revenue 20,040 10,758 NETCOST NET FUND COST(NCC) 2,057 -3,636 123400 0634 NORTH RICHMOND AOB E2000 Services and Supplies 10,000 126 E3000 Other Charges 300 132 E5000 Expenditure Transfers 3,000 124 TOTEXP Total Expenditures 14,300 382 R9400 USE OF MONEY & PROPERTY 6,000 13,248 R9600 CHARGES FOR SERVICES 75,000 249,049 TOTREV Gross Revenue 81,000 262,298 NETCOST NET FUND COST(NCC) -66,700 -261,916 124000 0635 MARTINEZ AREA OF BENEFIT E2000 Services and Supplies 50,000 E3000 Other Charges 500 258 E5000 Expenditure Transfers 109,000 11,501 TOTEXP Total Expenditures 174,500 11,759 R9400 USE OF MONEY & PROPERTY 25,000 34,857 R9600 CHARGES FOR SERVICES 87,000 107,366 R9800 MISCELLANEOUS REVENUE 155,704 TOTREV Gross Revenue 267,704 142,223 NETCOST NET FUND COST(NCC) -93,204 -130,464 124100 0636 BRIONES AREA OF BENEFIT E3000 Other Charges 250 61 E5000 Expenditure Transfers 467,113 TOTEXP Total Expenditures 467,363 61 R9400 USE OF MONEY & PROPERTY 10,000 8,675 R9600 CHARGES FOR SERVICES 4,600 TOTREV Gross Revenue 10,000 13,275 NETCOST NET FUND COST(NCC) 457,363 -13,214 124200 0637 CENTRAL CO AREA/BENEFIT E2000 Services and Supplies 50,000 -104 E3000 Other Charges 500 339 E5000 Expenditure Transfers 45,000 124 TOTEXP Total Expenditures 101,500 359 R9400 USE OF MONEY & PROPERTY 75,000 95,110 R9600 CHARGES FOR SERVICES 58,000 20,762 R9800 MISCELLANEOUS REVENUE 155,705 TOTREV Gross Revenue 288,705 115,872 NETCOST NET FUND COST(NCC) -187,205 -115,513 Page 28 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date 124300 0638 SO WAL CRK AREA OF BENEFT E3000 Other Charges 4 21 E5000 Expenditure Transfers 28,000 24,934 TOTEXP Total Expenditures 28,004 24,955 R9400 USE OF MONEY& PROPERTY 75 136 R9600 CHARGES FOR SERVICES 21,462 33,426 TOTREV Gross Revenue 21,537 33,562 NETCOST NET FUND COST(NCC) 6,467 -8,607 126000 0641 ALAMO AREA OF BENEFIT E2000 Services and Supplies 150,000 E3000 Other Charges 1,000 202 E5000 Expenditure Transfers 506,000 30,803 TOTEXP Total Expenditures 707,000 31,004 R9400 USE OF MONEY& PROPERTY 30,000 33,970 R9600 CHARGES FOR SERVICES 224,000 135,890 TOTREV Gross Revenue 254,000 169,860 NETCOST NET FUND COST(NCC) 453,000 -138,856 127000 0642 SOUTH CO AREA OF BENEFIT E2000 Services and Supplies 100,000 E3000 Other Charges 500 218 E5000 Expenditure Transfers 264,500 51,543 TOTEXP Total Expenditures 391,000 51,761 R9400 USE OF MONEY& PROPERTY 12,000 35,040 R9600 CHARGES FOR SERVICES 200,000 411,695 R9800 MISCELLANEOUS REVENUE 20,000 TOTREV Gross Revenue 232,000 446,735 NETCOST NET FUND COST(NCC) 159,000 -394,974 128000 0643 PITTS/ANTIOCH AREA/BENEFT E5000 Expenditure Transfers 7,001 TOTEXP Total Expenditures 7,001 R9600 CHARGES FOR SERVICES 5,000 TOTREV Gross Revenue 5,000 NETCOST NET FUND COST(NCC) 2,001 0 128100 0644 MARSH CRK AREA OF BENEFIT E2000 Services and Supplies 10,000 E3000 Other Charges 4 2 E5000 Expenditure Transfers 1,000 72 TOTEXP Total Expenditures 11,004 74 R9400 USE OF MONEY & PROPERTY 550 484 R9600 CHARGES FOR SERVICES 4,500 53 TOTREV Gross Revenue 5,050 537 NETCOST NET FUND COST(NCC) 5,954 -463 128200 0645 EAST COUNTY AREA OF BEN EF E2000 Services and Supplies 20,000 E3000 Other Charges 1,001 407 E5000 Expenditure Transfers 40,000 30,194 TOTEXP Total Expenditures 65,001 30,601 . R9400 USE OF MONEY & PROPERTY 50,500 109,476 Page 29 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9600 CHARGES FOR SERVICES 504,000 183,620 TOTREV Gross Revenue 554,500 293,096 NETCOST NET FUND COST(NCC) -489,499 -262,495 128300 0646 BRENTWOOD AREA OF BENEFIT E2000 Services and Supplies 6,813 E3000 Other Charges 4 1 E5000 Expenditure Transfers 1,000 TOTEXP Total Expenditures 7,817 1 R9400 USE OF MONEY& PROPERTY 94 87 TOTREV Gross Revenue 94 87 NETCOST NET FUND COST(NCC) 7,723 -86 112200 0648 DRAINAGE DEFICIENCY E2000 Services and Supplies 4,588,776 E3000 Other Charges 1,549,000 406 E5000 Expenditure Transfers 2,050,000 TOTEXP Total Expenditures 8,187,776 406. R9200 LICENSE/PERMIT/FRANCHISES 1,550,000 208,825 R9400 USE OF MONEY & PROPERTY 150,000 156,162 TOTREV Gross Revenue 11700,000 364,988 NETCOST NET FUND COST(NCC) 6,487,776 -364,582 112300 0649 PUBLIC WORKS E3000 Other Charges 7,000 33,396 E5000 Expenditure Transfers 7,993,000 -156,501 TOTEXP Total Expenditures 8,000,000 -123,105 R9400 USE OF MONEY& PROPERTY 150,000 364,659 R9600 CHARGES FOR SERVICES 71850,000 18,907,723 TOTREV Gross Revenue 81000,000 19,272,382 NETCOST NET FUND COST(NCC) 0 -19,395,487 100300 0650 PUBLIC WORKS E1000 Salaries and Benefits 31,967,622 15,118,101 E2000 Services and Supplies 9,858,374 3,373,832 E3000 Other Charges 75,000 22,038 E4000 Fixed Assets 190,000 E5000 Expenditure Transfers -8,361,430 -1,997,662 TOTEXP Total Expenditures 33,729,566 16,516,309 R9400 USE OF MONEY& PROPERTY 5,196 R9500 INTERGOVERNMENTAL REVENUE 200 36,900 R9600 CHARGES FOR SERVICES 922,690 114,916 R9800 MISCELLANEOUS REVENUE 32,612,304 14,269,789 TOTREV Gross Revenue 33,535,194 14,426,801 NETCOST NET COUNTY COST(NCC) 194,372 2,089,508 110300 0651 PUB WKS-LAND DEVELOPMENT E2000 Services and Supplies 1,813,000 476,202 E3000 Other Charges 300,000 61,393 E5000 Expenditure Transfers 5,000,000 2,526,373 TOTEXP Total Expenditures 7,113,000 3,063,967 R9200 LICENSE/PERMIT/FRANCHISES 680,000 149,846 R9600 CHARGES FOR SERVICES 1,050,000 861,844 Page 30 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9800 MISCELLANEOUS REVENUE 5,383,000 -329,366 TOTREV Gross Revenue 7,113,000 682,324 NETCOST NET FUND COST(NCC) 0 2,381,643 129000 0653 BETHEL ISLAND AREA OF BENEFT E2000 Services and Supplies 79,533 E3000 Other Charges 112 204 E5000 Expenditure Transfers 540,000 238 TOTEXP Total Expenditures 619,645 442 R9400 USE OF MONEY& PROPERTY 1,000 9,940 R9600 CHARGES FOR SERVICES 100,000 3,347 TOTREV Gross Revenue 101,000 13,287 NETCOST NET FUND COST(NCC) 518,645 -12,845 100300 0661 ROAD CONSTRUCTION E2000 Services and Supplies 62,285,340 20,167,103 E3000 Other Charges 3,506,000 340,284 TOTEXP Total.Expenditures 65,791,340 20,507,387 R9400 USE OF MONEY& PROPERTY 14,000 R9500 INTERGOVERNMENTAL REVENUE 65,635,000 11,366,343 R9600 CHARGES FOR SERVICES 138,000 4,212,757 R9800 MISCELLANEOUS REVENUE 9,006 TOTREV Gross Revenue 65,787,000 15,588,106 NETCOST NET COUNTY COST(NCC) 4,340 4,919,281 110800 0662 ROAD CONSTRUCTION-RD FUND E2000 Services and Supplies 15,844,872 2,358,269 E3000 Other Charges 2,265,000 60,986 E5000 Expenditure Transfers 3,500,000 1,598,534 TOTEXP Total Expenditures 21,609,872 4,017,788 R9400 USE OF MONEY& PROPERTY 527 R9500 INTERGOVERNMENTAL REVENUE 5,218,400 -111,276 R9600 CHARGES FOR SERVICES 3,334,027 115,920 R9800 MISCELLANEOUS REVENUE 4,849,973 476,186 TOTREV Gross Revenue 13,402,400 481,356 NETCOST NET FUND COST(NCC) 8,207,472 3,536,432 110800 0672 ROAD MAINTENANCE-RD FUND E2000 Services and Supplies 2,329,549 2,600,209 E3000 Other Charges 2,454,800 966,155 E4000 Fixed Assets 377,691 143,882 E5000 Expenditure Transfers 9,484,691 4,816,346 TOTEXP Total Expenditures 14,646,731 8,526,592 . R9400 USE OF MONEY& PROPERTY 2,553 R9500 INTERGOVERNMENTAL REVENUE 30,000 -48,834 R9600 CHARGES FOR SERVICES 15,000 98,452 R9800 MISCELLANEOUS REVENUE 1,924,500 116,925 TOTREV Gross Revenue 1,969,500 169,096 NETCOST NET FUND COST(NCC) 12,677,231 8,357,496 110800 0674 MISCEL PROPERTY-ROAD FUND E2000 Services and Supplies 2,000 E3000 Other Charges 2,500 180 Page 31 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget Year-to-Date E5000 Expenditure Transfers 11,000 6,722 TOTEXP Total Expenditures 15,500 6,902 R9400 USE OF MONEY & PROPERTY 13,000 3,500 TOTREV Gross Revenue 13,000 3,500 NETCOST NET FUND COST (NCC) 2,500 3,402 110800 0676 GEN ROAD PLAN/ADM-RD FUND E2000 Services and Supplies 454,000 165,668 E3000 Other Charges 897,500 204,767 E5000 Expenditure Transfers 2,713,221 1,509,073 TOTEXP Total Expenditures 4,064,721 1,879,508 R9400 'USE OF MONEY & PROPERTY 36 . R9500 INTERGOVERNMENTAL REVENUE 20,000 R9600 CHARGES FOR SERVICES 314,500 43,981 R9800 MISCELLANEOUS REVENUE 497,500 82,529 TOTREV Gross Revenue 832,000 126,546 NETCOST NET FUND COST (NCC) 3,232,721 1,752,962 138800 0678 SPRW FUND E2000 Services and Supplies 4,635,820 2,091 E3000 Other Charges 360,000 106,908 E5000 Expenditure Transfers 1,353 TOTEXP Total Expenditures 4,995,820 110,352 R9400 USE OF MONEY & PROPERTY 225,000 242,921 R9600 CHARGES FOR SERVICES 2,000 TOTREV Gross Revenue 227,000 242,921 NETCOST NET FUND COST(NCC) 4,768,820 -132,569 138900 0679 EAST/CENT TRAVEL CORRIDOR E2000 Services and Supplies 10,000 E3000 Other Charges 10 4 E5000 Expenditure Transfers 2,000 TOTEXP Total Expenditures 12,010 4 R9400 USE OF MONEY & PROPERTY 1,400 1,031 TOTREV Gross Revenue 1,400 1,031 NETCOST NET FUND COST (NCC) 10,610 -1,027 139000 0680 RD DVLPMNT DISCOVERY BAY E2000 Services and Supplies 9,999 E3000 Other Charges 300 55 E5000 Expenditure Transfers 5,000 62 TOTEXP Total Expenditures 16,299 117 R9400 USE OF-MONEY & PROPERTY 6,000 5,850 R9600 CHARGES FOR SERVICES 6,000 2,280 TOTREV Gross Revenue 12,000 8,130 ,NETCOST NET FUND COST (NCC) 4,299 -8,013 139200 0682 ROAD IMPRVMNT FEE E2000 Services and Supplies 5,110,000 704,929 E3000 Other Charges 3,500 1,486 E5000 Expenditure Transfers 847,000 506,799 TOTEXP Total Expenditures 6,160,500 1,213,214 R9400 USE OF MONEY & PROPERTY 230,000 571,073 Page 32 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9500 INTERGOVERNMENTAL REVENUE 100,000 356,428 R9600 CHARGES FOR SERVICES 3,525,000 151,872 R9800 MISCELLANEOUS REVENUE 300,000 TOTREV Gross Revenue 4,155,000 1,079,373 NETCOST NET FUND COST(NCC) 2,005,500 133,841 139400 0684 RD DEVLPMNT RICH/EL SOBRT E2000 Services and Supplies 30,000 E3000 Other Charges 200 100 E5000 Expenditure Transfers 329,500 33,657 TOTEXP Total Expenditures 389,700 83,757 R9400 USE OF MONEY.& PROPERTY 10,000 8,216 R9600 CHARGES FOR SERVICES 122,000 31,157 TOTREV Gross Revenue 132,000 39,373 NETCOST NET FUND COST(NCC) 257,700 -5,616 139500 0685 RD DEVLPMT BAY POINT AREA E2000 Services and Supplies 20,000 E3000 Other Charges 430 78 E5000 Expenditure Transfers 45,500 1,826 TOTEXP Total Expenditures 75,800 1,904 R9400 USE OF MONEY& PROPERTY 10,000 6,373 R9600 CHARGES FOR SERVICES 101,000 12,749 TOTREV Gross Revenue 111,000 19,122 NETCOST NET FUND COST(NCC) -35,200 -17,218 139600 0686 RD DEVELOP CROW CANYON R9400 USE OF MONEY& PROPERTY 10,116 TOTREV Gross Revenue 10,116 NETCOST NET FUND COST(NCC) 0 -10,116 139900 0687 RD DEVLPMNT PACHECO AREA E2000 Services and Supplies 10,000 E3000 Other Charges 300 64 E5000 Expenditure Transfers 38,000 422 TOTEXP Total Expenditures 52,300 486 R9400 USE OF MONEY & PROPERTY 10,000 10,283 R9600 CHARGES FOR SERVICES 8,000 TOTREV Gross Revenue 18,000 10,283 NETCOST NET FUND COST(NCC) 34,300 -9,797 111400 0697 NAVY TRANS MITIGATION E2000 Services and Supplies 8,215,890 E5000 Expenditure Transfers 95,000 TOTEXP Total Expenditures 8,310,890 R9400 USE OF MONEY & PROPERTY 112,000 99,986 TOTREV Gross Revenue 112,000 99,986 NETCOST NET FUND COST(NCC) 8,198,890 -99,986 111700 0698 TRANS IMPRVMNT-RODEO/CRKT E2000 Services and Supplies 4,433 E3000 Other Charges 600 265 E5000 Expenditure Transfers 1,934,973 Page 33 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTEXP Total Expenditures 1,940,006 265 R9400 USE OF MONEY & PROPERTY 60,000 34,196 TOTREV Gross Revenue 60,000 34,196 NETCOST NET FUND COST(NCC) 1,880,006 -33,931 111500 0699 TOSCO/SOLANO TRANS MTGTN E2000 Services and Supplies 50,000 E3000 Other Charges 800 502 E5000 Expenditure Transfers 60,000 -144,227 TOTEXP Total Expenditures 115,800 -143,725 R9400 USE OF MONEY& PROPERTY 70,000 115,790 TOTREV Gross Revenue 70,000 115,790 NETCOST NET FUND COST(NCC) 45,800 -259,515 140100 0841 AIRPORT OPERATIONS E1000 Salaries and Benefits 1,885,390 961,239 E2000 Services and Supplies 947,845 480,088 E3000 Other Charges 557,279 201,570 E5000 Expenditure Transfers 163,000 83,904 TOTEXP Total Expenditures 3,553,514 1,726,800 R9400 USE OF MONEY& PROPERTY 3,200,695 1,823,882 R9600 CHARGES FOR SERVICES 7,855 R9800 MISCELLANEOUS REVENUE 350,900 303,226 TOTREV Gross Revenue 3,551,595 2,134,963 NETCOST NET FUND COST(NCC) 1,919 -408,163 140100 0843 AIRPORT FIXED ASSETS E3000 Other Charges 408 E4000 Fixed Assets 1,942,368 297,814 TOTEXP Total Expenditures 1,942,368 298,223 R9500 INTERGOVERNMENTAL REVENUE 1,944,287 977,388 TOTREV Gross Revenue 1,944,287 977,388 NETCOST NET FUND COST(NCC) -1,919 -679,165 100300 0020 PURCHASING E1000 Salaries and Benefits 876,643 438,162 E2000 Services and Supplies 142,713 76,867 E5000. Expenditure Transfers -145,286 -56,166 TOTEXP Total Expenditures 874,070 458,863 R9600 CHARGES FOR SERVICES . 136,631 68,310 R9800 MISCELLANEOUS REVENUE 92,450 441 TOTREV Gross Revenue 229,081 68,751 NETCOST NET COUNTY COST(NCC) 644,989 390,112 100300 0063 FLEET SERVICES E1000 Salaries and Benefits 1,849,254 726,822 E2000 Services and Supplies 8,224,417 3,770,920 E3000 Other Charges 2,350,316 467,957 E4000 Fixed Assets 1,372,093 899,542 E5000 Expenditure Transfers -10,057,049 -4,707,303 TOTEXP Total Expenditures 3,739,031 1,157,938 R9500 INTERGOVERNMENTAL REVENUE 30,000 R9600 CHARGES FOR SERVICES 2,112,131 894,799 Page 34 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date R9800 MISCELLANEOUS REVENUE 2,500 1,590 TOTREV Gross Revenue 2,144,631 896,388 NETCOST NET COUNTY COST(NCC) 1,594,400 261,550 100300 0077 GEN CO BLG OCCUPANCY COST E2000 Services and Supplies 15,467,749 8,644,616 E3000 Other Charges 150 E5000 Expenditure Transfers -75,642 -77,961 TOTEXP Total Expenditures 15,392,107 8,566,805 R9400 USE OF MONEY& PROPERTY 93,388 88,163 R9600 CHARGES FOR SERVICES 192,000 142,935 R9800 MISCELLANEOUS REVENUE 1,509,736 762,288 TOTREV Gross Revenue 1,795,124 993,385 NETCOST NET COUNTY COST(NCC) 13,596,983 7,573,420 100300 0079 BUILDING MAINTENANCE E1000 Salaries and Benefits 19,985,724 9,286,241 E2000 Services and Supplies 36,143,788 25,386,123 E3000 Other Charges 31,492,969 11,944,929 E5000 Expenditure Transfers -56,311,571 -27,922,435 TOTEXP Total Expenditures 31,310,910 18,694,859 R9400 USE OF MONEY&PROPERTY 500 R9600 CHARGES FOR SERVICES 31,000,778 17,414,598 R9800 MISCELLANEOUS REVENUE 303,000 524,561 TOTREV Gross Revenue 31,303,778 17,939,659 NETCOST NET COUNTY COST(NCC) 7,132 755,200 100300 0148 PRINT& MAIL SERVICES E1000 Salaries and Benefits 1,500,604 715,840 E2000 Services and Supplies 1,998,316 1,229,273 E3000 Other Charges 26,533 12,416 E5000 Expenditure Transfers -2,903,333 -1,828,955 TOTEXP Total Expenditures 622,120 128,574 R9600 CHARGES FOR SERVICES 622,120 271,323 R9800 MISCELLANEOUS REVENUE 524 TOTREV Gross Revenue 622,120 271,846 NETCOST NET COUNTY COST(NCC) 0 -143,272 100300 0149 GENERAL SERVICES ADMIN E1000 Salaries and Benefits 3,341,137, 1,356,459 E2000 Services and Supplies 340,896 171,534 E3000 Other Charges 562 E5000 Expenditure Transfers -3,681,483 -1,559,095 TOTEXP Total Expenditures 550 -30,540 R9800 MISCELLANEOUS REVENUE 550 127 TOTREV Gross Revenue 550 127 NETCOST NET COUNTY COST(NCC) 0 -30,667 100300 0473 KELLER SRCHRGE/MITGN PROG E2000 Services and Supplies 489,873 346,539 TOTEXP Total Expenditures 489,873 346,539 R9200 LICENSE/PERMIT/FRANCHISES 437,546 112,269 R9800 MISCELLANEOUS REVENUE 54,000 26,395 Page 35 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adjusted Budget Year-to-Date TOTREV Gross Revenue 491,546 138,665 NETCOST NET COUNTY COST(NCC) -1,673 207,874 120600 0008 REVENUE CO LIBRARY TAXES R9000 TAXES CURRENT PROPERTY 18,409,850 18,737,872 R9100 TAXES OTHER THAN CUR PROP -190,000 7,276 R9400 USE OF MONEY &PROPERTY 500 R9500 INTERGOVERNMENTAL REVENUE 422,700 204,716 TOTREV Gross Revenue 18,643,050 18,949,863 NETCOST NET FUND COST(NCC) -18,643,050 -18,949,863 120600 0113 PLANT ACQUIS-LIBRARY FUND E4000 Fixed Assets 1,038,767 85,747 TOTEXP Total Expenditures 1,038,767 85,747 NETCOST NET FUND COST(NCC) 11038,767 85,747 120600 0620 LIBRARY-ADMIN & SUPPORT SVCS E1000 Salaries and Benefits 7,040,696 3,220,304 E2000 Services and Supplies 4,895,510 1,363,874 E3000 Other Charges 943,729 413,441 E4000 Fixed Assets 30,000 19,471 TOTEXP Total Expenditures 12,909,935 5,017,090 R9400 USE OF MONEY & PROPERTY 76,000 24,576 R9500 INTERGOVERNMENTAL REVENUE 424,015 110,684 R9600 CHARGES FOR SERVICES 92,100 R9800 MISCELLANEOUS REVENUE 1,208,150 123,627 TOTREV Gross Revenue 1,800,265 258,886 NETCOST NET FUND COST(NCC) 11,109,670 4,758,204 120600 0621 LIBRARY-COMMUNITY SERVICES E1000 Salaries and Benefits 11,387,095 5,502,962 E2000 Services and Supplies 2,037,948 911,297 E3000 Other Charges 1,445,945 958,948 E4000 Fixed Assets 252,000 248,917 TOTEXP Total Expenditures 15,122,988 7,622,124 R9400 USE OF MONEY & PROPERTY 160 R9500 INTERGOVERNMENTAL REVENUE 2,356,000 24,937 R9600 CHARGES FOR SERVICES 864,185 310,077 R9800 MISCELLANEOUS REVENUE 315,500 241,140 TOTREV Gross Revenue 3,535,685 576,314 NETCOST NET FUND COST(NCC) 11,587,303 7,045,810 120700 0622 CASEY LIBRARY GIFT E3000 Other Charges - 236,198 50 TOTEXP Total Expenditures 236,198 50 R9400 USE OF MONEY& PROPERTY 8,000 10,016 TOTREV Gross Revenue 8,000 10,016 NETCOST NET FUND COST(NCC) 228,198 -9,966 100300 0579 VETERANS SERVICE OFFICE E1000 Salaries and Benefits 650,229 315,694 E2000 Services and Supplies 86,477 34,144 TOTEXP Total Expenditures 736,706 349,838 Page 36 of 37 Attachment A Mid-Year Budget Status Report Current Year Total Fund Adiusted Budget .Year-to-Date R9500 INTERGOVERNMENTAL REVENUE 95,000 37,374 . R9600 CHARGES FOR SERVICES 50,000 50,000 TOTREV Gross Revenue 145,000 87,374 NETCOST NET COUNTY COST (NCC) 591,706 262,464 100300 0630 COOPERATIVE EXTENSION SVC E1000 Salaries and Benefits 280,532 109,777 E2000 Services and Supplies 49,826 14,075 TOTEXP Total Expenditures 330,358 123,852 NETCOST NET COUNTY COST (NCC) 330,358 123,852 Page 37 of 37 List of Funds 100300 General Fund 115000 Automated Sys Dvlpmnt 105600 County Law Enforcement - Capital Project 115100 Property Tax Admin 105800 Juvenile Hall - Capital Project 115200 VLF Securitization Fund 110000 Recorder Modernization 115500 IHSS Public Authority 110100 Court/Clerk Automation 115600 DNA Identification Fund 110200 Fish and Game 120600 County Library 110300 Land Development Fund 120700 Casey Library Gift 110400 Criminalistics Laboratory 123100 Hercul/Rodeo Crock A of B 110500 Survey Monument Preservation 123200 West County Area of Benef 110600 Crim Justice Facility Construction 123400 North Richmond AoB 110700 Courthouse Construction 124000 Martinez Area of Benefit 110800 Road 124100 Briones Area of Benefit 110900 Transportation Improvement 124200 Central Co Area/Benefit 111000 Sans Crainte Drainage, 124300 So Wal Crk Area of Benefit 111100 Private Activity Bond 126000 Alamo Area of Benefit 111300 Affordable Housing Spec Rev 127000 South Co Area of Benefit 111400 Navy Trans Mitigation 128000 Pitts/Antioch Area of Benefit 111500 Tosco/Solano Trns Mitigation 128100 Marsh Crk Area of Benefit 111600 Child Development Fund 128200 East County Area of Benefit 111700 Trans Imprvmnt-Rodeo/Crockett 128300 Brentwood Area of Benefit 111900 Used Oil Recycling Grant 129000 Bethel Isl Area of Benefit 112100 CDD/PWD Joint Review Fee 132800 County Childrens 112200 Drainage Deficiency 133200 Animal Benefit 112300 Public Works 133400 Co-Wide Gang and Drug 112400 DA Consumer Protection 133700 Livable Communities Fund 112500 Domestic Violence Victim Asst 134000 AVA Service Authority 112700 Zero Tolerance - Domesic Violence 134700 CDBG Sm Bus & Microent Loan 112900 DA Revenue Narcotics 134800 CDB 1st-time Hmebyr Loan 113000 DA Environment/OSHA 134900 HUD Bldg Insp NPP 113100 DA Forfeiture-Fed-DOJ 135000 Retirement UAAL Bond Fund 113200 PH Bart Greensace Mtce 135200 Ret Litgtn Stlmnt Dbt Svc 113300 R/Estate Fraud Prosecution 136000 Central Identify Bureau 113400 CCC Dept Child Spprt Svcs 138800 SPRW Fund 113500 Emergency Med Svcs Fund 138900 East/Cent Travel Corridor 113600 Prop 36-Sub Abuse Cp Act 139000 Rd Dvlpmnt Discovery Bay 113700 AB75 Tobacco Tax Fund 139200 Road Imprvmnt Fee 113900 Traffic Safety Fund 139400 Rd Dvlpmnt Rich/El Sobrt 114000 Pub Protect-Spec Rev Fund 139500 Road Development Bay Point 114100 Sheriff Narc Forfeit-St/Local 139600 Rd Develop Crow Canyon 114200 Sheriff Forfeit-Fed-DOJ 139900 Rd Devlpmnt Pacheco Area 114300 Sup Law Enforcement Svcs 140100 Airport Enterprise 114400 Local Law Enforcement BJP 142000 Sheriff Law Enf Trng Cntr 114500 Sheriff Forfeit-Fed Treasury 145000 Hospital Enterprise 114700 Prisoners Welfare Fund 146000 HMO Enterprise 114800 Comm Col Child Dev-Fund 146100 HMO Enterprise-Comm Plan 114900 . Probation Officers Special Fund 146200 Major Risk Med Insur Ent Qtr 2 - General Fund/Expenditures Qtr 2 - General Fund/Revenues (fn Millions) (In Millions) Budget Actual Percent Budget Actual Percent Wages&Benefits $ 647.8 $316.5 48.9% Taxes $ 286.9 $ 175.6 61.2% Services&Supplies 478.9 221.7 46.3% Licenses,Permits,Franchises 14.0 3.0 21.3% Other Charges 269.4 127.7 47.4% Fines,Forfeitures,Penalties 13.8 2.2 16.2% Fixed Assets 38.4 9.5 24.7% Use of Money 4.5 1.6 35.0% Inter-departmental Charges 159.1 -75.6 47.5% Federal/State Asst 622.7 192.9 31.0% Total Expenses $1,275.4 $599.9 47.0% Charges for Current Services 208.3 84.9 40.8% Other Revenue 1 89.3 32.4 36.2% Total Revenue $1,239.6 $ 492.6 39.7% Summary Conclusion • Over-all County General Fund budget is • Continue to monitor departments closely balanced and a modest departmental balance is anticipated • Continue to expect to meet our FY • Six departments may exceed their budgets, due 2006/07 reserve goal almost entirely to anticipated variances from • Contito towards bringing a labor negotiations nue o work g g -Animal Services balanced FY 2006/07 budget to your -Clerk-Recorder Board on April 17 -Health Services Continue to work towards an Other Post -Office of Revenue Collections - Public Defender Employee Benefit funding plan -Sheriff-Coroner • No action of the Board currently requested 2 Actual Data - December 31 • Annual report Mid-Year Status Report • Performing substantially in accord with approved budget FY 2006/07 z Qtr 2 - All Funds Qtr 2 - General Fund (In Millions) (In Millions) Budget Actual Percent Budget Actual Percent Expenditures $2,114 $925 43.8% Expenditures $1,275 $600 47.0% Revenues $1,964 $893 45.5% Revenues $1,240 $493 39.7% 1 C') ro CD 0 CD 03 co 7z CD CD 3 AP CD Ln CD 9� CD 7= 0 (n CD W (n -0 s CD "cam L co CD c) 0 CD Cc ik -A 0 (P a 1A CD 0 o cp co m (b CO Nco CD N -A C) 7� k CD 0 ✓ NN T Co. C) CD 0 '—PI CD co CD 7:5 CD CD 0 co 4- CD CD ti0 77 CD UI ti IE co 0 0 -71 td Qi (D N 4 C36. (h O to 0 --CA U- 13) 0 0 r- CO t4 co 10 0 W r- 0 71 0) U 0 O 0-(JD 0 0 LO (1) 0 -IT ce) C14 e N \If`,CD w V .t... 0 ILO N o - o cd C-3 cr- O w O N CD CL- Z L CO CO ;H� tv 00 \� m O un 4 o Q \ 4 } 1 1 \ 1 r oDQ �Omo � Q CD m co3 x m o0m00 _. 3 m 3 3 UIQ . ° � Q � CD00 D � � d � d Q N m m CDD h� 0 CDoamtz ' o. N m ,UQ m 0 C)n 2 w 3 D o0 mQ ? + N Q. m< O py m a,3d CDD _D C3 m m O - m m 3 'tr C N n r 3 = 13 C3 @ ❑G1 m 0. m . m C7 3 � � � Z' < c Ct m m m a Q. m a J CP CL a CD Ut: Ir I •J n � nnQ ry m Q N @ r tq 3 Si N O r to 3 -o •a d ❑❑ (D nn w t Q N 0 CL �+ Y m m m