Loading...
HomeMy WebLinkAboutMINUTES - 02041986 - 2.1 TO: ABOARD OF SUPERVISORS ' t FROM: �./vI tra Phil Batchelor, Costa County Administrator DATE: February 4, 1986 SUBJECT: MID-YEAR BUDGET STATUS REPORT SPECIFIC REQUEST(S) OR RECOMMENDATION(S) a BACKGROUND AND JUSTIFICATION RECOMMENDATIONS 1. Approve appropriation adjustments totalling $800,000 for the Auditor Controller, Assessor and Treasurer-Tax Collector, which reflect the loss of revenue from reimbursement of costs related to the Supplemen- tal Property Tax Roll. 2. Approve appropriation adjustment for the Auditor-Controller of $16,850, and authorize the addition of two new permanent positions and the conversion of two temporary positions to permanent in the Auditor- Controller' s Office, to address a backlog of enrollments related to the Supplemental Property Tax Roll, in order to ensure adequate revenue receipts by the end of the fiscal year. 3. Approve an increase totalling $816,85-0 in revenues for the Federal Revenue Sharing program to offset the revenue reductions and expendi- ture increases noted above. 4. Direct the County Administrator to work with selected departments to develop and implement a balancing plan for their budgets which will assure a positive fund balance for those departments by the end of the fiscal year. 5. Authorize the County Administrator to implement a selective freeze on spending as required to protect the year-end fund balance. 6. Review and approve productivity indicators for the Probation, Health Services and Social Services departments and authorize the County Administrator to continue working with the remaining departments, using the same basis for review as was used with the first three departments. BACKGROUND: I . OVERVIEW On a quarterly basis, the County Administrator' s staff prepares a report which details the activity within each budget and provides CONTINUED ON ATTACHMENT: )L- YES SIGNATURE: Z RECOMMENDATION OF COUNTY ADMINISTRATOR RECOMMENDATION OF BOARD COMMITTEE APPROVE J OTHER SIGNATURE(S): p ACTION OF BOARD ON O APPROVED AS RECOMMENDED OTHER VOTE OF SUPERVISORS 1 HEREBY CERTIFY THAT THIS IS A TRUE UNANIMOUS (ABSENT AND CORRECT COPY OF AN ACTION TAKEN AYES: NOES: AND ENTERED ON THE MINUTES OF THE BOARD ABSENT: ABSTAIN: OF SUPERVISORS ON THE DATE SHOWN. CC: County Administrator ATTESTED Auditor-%Controller PHIL BATCHELOR, CL RK OF THE BOARD OF Personnel SUPERVISORS AND COUNTY ADMINISTRATOR BY ,DEPUTY M382/7-83 suumary information on the status of the budget. Actions which are necessary to ensure a healthy budget status at the end of the fiscal year are recommended in the quarterly budget status reports. Other items which have major fiscal impacts are also reviewed as part of the quarterly review. This second quarter report consists of three major sections: The first section summarizes information for the budget as a whole, discusses the impact of state and federal actions on the budget, recommends specific actions to be taken, and highlights items which merit further review. The second section, contained on Attachment 1, includes detailed discussions of budgets which appear to be experienc- ing unusual revenue or expenditure patterns for the half-year period, and makes projections about the budgets' status by the end of the year. The third section is a review of the first efforts related to developing productivity indicators for each department. The Proba- tion, Social Services, and Health Services Departments indicators are discussed in detail on Attachment 2. Overall, it appears that if corrective actions are taken in certain budgets, and expenditures as well as revenues are closely monitored in those budgets which currently project positive fund balances, the County will end the fiscal year with a positive fund balance. How- ever, it appears that the fund balance will not reach last year' s levels, which means that there will be less financing available to fund the following fiscal year' s budget. II. EFFECTS OF FEDERAL AND STATE ACTIONS ON CONTRA COSTA COUNTY A. Federal Impacts Overall, it appears that federal budget balancing actions will have a multi-million dollar impact on the county' s finances. Some of that impact will be felt in the 1985-86 fiscal year. The Graham-Rudman Deficit Reduction Act requires that reductions be made in all but a few protected programs in order to balance the federal budget by 1990. The first item directly affecting counties, which appears to be a target of this year' s efforts to balance the budget, is federal revenue sharing. Although Congress did extend revenue sharing for one quarter more than originally budgeted, there are already discussions underway which would result in a 5% reduction of the April payment due to the County. Any actions taken relative to appropriating additional funding from this source should remain conservative, due to the still-uncertain nature of a portion of these revenues. Other impacts in certain health and social services programs, as well as housing, employment and other community services, may also be felt before this fiscal year is completed. More specific information will be provided as it is developed. -2- B. State Impacts 1. „Governor' s Proposed Budget The j; California economy is predicted to be strong next fiscal year, with building activity up and unemployment down. Increases in major revenue sources are expected with an overall increase of 7% projected. The ",Governor' s proposed State budget does not address any major County financial issues, although some cost of living allowances which were not allowed in the past have been included in this year' s proposed budget. * All statutory cost of living adjustments are fully funded, representing a 4. 9% increase for affected programs. * No discretionary cost-of-living adjustments are included, except community mental health, which will get 2%. * Welfare caseload growth is fully funded. * No increase in medically indigent adult is funded, beyond the augmentation provided in the current year. What this amounts to for Contra Costa County is a continuation of the problems experienced in recent years of having to provide increased mandated services without adequate financial resources. When cost- of-living adjustments are not granted but services must be maintained, the ', county must use its limited discretionary money to make up the losses. This reduces the funding available to fund local priorities and further reduces the Board of Supervisors ' flexibility in making decisions. It also erodes fund balance levels, which are used to finance subsequent years budgets. 2. Legislation a. IIAB 19 (Chapter 1607, Statues of 1985) Assembly Bill 19 places in statute a mechanism for having the State provide a block grant to each County for each Superior/Municipal court judge in exchange for which the County gives up its fine and forfei- ture revenue. The bill provides that this mechanism only becomes effective when funded in the State budget or other statute. The Governor' s Office has indicated that it will not support funding for Assembly Bill 19 unless a package of court reforms is implemented. The courts have indicated that some of the proposed reforms are objectionable to them because of the principal of separation of the various branches of government. The °'Judicial Council has estimated that the cost of fully implementing this legislation would be $500 million state-wide. The Department of Finance estimates that a maximum of $150 million would be made avail- able. County staff is currently analyzing the County' s potential net loss or gain based upon these two figures, and will provide more information to the Board as its impact is determined. -3- IV b. ` AB 2206 (Cortese) On January 21, the Board of Supervisors went on record opposing Assembly Bill 2206. This is the legislation which transfers responsibility for determining agreements on exchange of property tax revenue from the counties and cities to the Local Agency Formation Commission. It is expected that Assemblyman Cortese is resolute about getting a law enacted which would curb the abuses which have occurred in his home county of Santa Clara and in other counties. Staff is working with the County' s lobbyist and CSAC to try to deter- mine a compromise which would leave the Board of Supervisors with the maximum flexibility possible. Amendments to the bill which might make it more acceptable to the County could be longer waiting periods before LAFCO is asked to decide on an issue, a later effective date, or a requirement that all revenues be taken into account in deciding upon what transfer will take place. c. Senate Bill 580 This bill would restore reimbursment for administrative costs related to the supplemental roll. It is another item which the County' s lobbyist and CSAC are working on to find an author before the deadline for introduction of new bills on February 21. CSAC is also researching the kind of language which the Governor would consider signing, related to the 1986 version of Senate Bill 580. The problem is that a bill which reimburses the counties for its costs by definition takes funds away from cities, districts and schools. The State' s interest is primarily in the schools revenues because the State must make up any losses to schools through the State' s General Fund. At this time, although efforts will continue to get legislation enacted to reimburse for supplemental roll costs, it is not expected that the County' s efforts will be successful. . d. Senate Bill 1091 Senate Bill 1091 is the 1985 bill which provided that property tax funding would be removed from some counties and provided to no-and-low property tax cities in those counties. This bill is still under consideration in the legislature and is a major item for the County' s lobbyist. Last year' s bill included an increase in motor-vehicle-in lieu revenues which went first to offset the County' s losses. This aspect of the bill was defeated along with the no-and-low property tax issue during last year' s legislative session. However, it is expected that it will move again during the 1986 session. At this time, the County is not budgeting a loss from a 1986 version of Senate Bill 1091. However, it should be noted that some action reducing revenues may be necessary if this bill enjoys success during the 1986 session. C. Summary This glimpse of what State and Federal actions might mean to Contra Costa County makes the judicious use of this years' funding even more important. It also underscores the importance of protecting and nurturing the fund balance from year to year. -4- III". BUDGET UNIT REVIEW: A. Assessor, Auditor-Controller, and Treasurer-Tax Collector Earlier this fiscal year, the Governor vetoed Senate Bill 580, which was the legislation authorizing reimbursement for the County' s cost related to the collection of the supplemental property tax roll. This veto resulted in the loss of $800,000 of budgeted revenue in three departments, as follows: Assessor - $591,000; Auditor-Controller - $98,000; and Treasurer-Tax Collector - $111,000. When news of the veto became known, the Board indicated its intention to continue to fully fund the County' s costs related to collection of the supplemental roll, upon the identification of other revenue sources. The Board' s intended action is important because the County , has over $3 million in supplemental roll revenues budgeted for the General Fund in fiscal year 1985-86. These projections cannot be met without adequate funding to process the many enrollments related to the supplemental roll. As a result, . it is recommended that the Revenue Sharing increases be used to offset the amount revenue decreases in the three affected departments, to leave these departments "whole" . Additionally, to ensure the realization of budgeted supplemental roll revenues, four permanent account clerk positions are being recommended for the Auditor' s office; two new positions and the conversion of two current temporary positions to permanent. The Auditor' s office has attempted to process the supplemental roll with only two temporary staff. Their preference was to not request permanent staff until the workload demands were known. Analysis of their workload over the past six months indicates that five positions are needed to process the roll timely and meet the budgeted revenue projections. Because the staffing has not been adequate to complete the supplemental roll, there is currently a five-month backlog of enrollments. If no action is taken, an anticipated shortfall of up to $2 million in supplemental roll revenues could be expected. At the newly recommended staffing level, it is expected that the Auditor' s activity will be current by June 30, 1986. B. Health Services Department In the first quarter budget status report, the Health Services Depart- ment was predicting a deficit of $350,000, annualized. This was later increased to a range of $400,000 to $900 ,000. This range appears to be holding based upon an analysis of six month actuals. The potential deficit is primarily attributable to the following: * Low inpatient census during the first six months of activity - 113 actual versus 120 budgeted. * Decline of approximately 15% in Medicare discharges from the last fiscal year. * Decline in AFDC enrollments in the Health Plan of 5.2% compared with last year. -5- 4 *--Home Health Agency revenue underrealization of 30. 0% due to decreases in the demand for service. * Detention Facility funding problem related to jail population, representing approximately $200,000 of the projected deficit. No appropriation adjustments related to the projected budget deficit are recommended at this time. Instead, the County Administrator requests authorization to work with the Health Services Department to develop and implement a balancing plan which will not affect the services provided to indigent clients of the department. The Administrator' s Office prefers to identify those areas which are not mandated services or service levels, and implement reductions in those areas, as opposed to taking funds from other budgets to balance at this level of activity. If action is not taken to reduce activity, the deficit which is "made up" this year will carry forward into the following fiscal year, where the resources are not available to provide continued funding. It should be noted that the department' s projections are based upon an average daily census of 120 for the remainder of the fiscal year. If these estimates are not borne out, the department projects further problems. Additionally, it should be noted that $99,000 was added to the Health Services Department budget earlier this year to address dental and pharmacy staffing. Other similar issues may be identified during the third quarter which may require Board action. C. General Assistance The general assistance budget provides relief to indigents who are not eligible for other forms of financial aid. Costs are completely borne by the County. In August, the Board approved an average increase of 15.2 percent in general assistance payments. No increase in the appropriation was made at that time based upon a trend of lower caseloads. During the second quarter, there was an increase in the total number of cases when compared with historical averages. If this trend continues, a shortfall of several hundred thousand dollars may be experienced. If the caseloads remain at the originally projected level for the remainder of this fiscal year, a shortfall of up to $100, 000 could be expected. No action is recommended at this time, pending further refinement of actual figures. D. General County Revenues Projections for general County revenues for this fiscal year appear to be matching budgeted amounts. Based upon the first payment of proper- ty taxes, this revenue source will be within one percent of the budgeted amounts. Supplemental Roll Property taxes, which are cur rently behind projections, should meet the budgeted level because of staffing additions recommended for the Auditor-Controller' s Office. Motor-vehicle-in-lieu taxes are ahead of projections but it is expected that this excess is primarily attributable to seasonable variations. Finally, interest earnings are on par with the budgeted amount, with interest rates and average daily balances reflecting the -6- levels anticipated when the budget was prepared. Overall, this budget appears to be healthy through the first half of the fiscal year and no projected deficits are anticipated for the remainder of the fiscal year. E. Other Operating Budgets Several operating budgets have projected negative fund balances at this time. The Administrative Office staff will be working with the affected departments to implement balancing plans. More specific information about those budgets with problems will be provided with the third quarter report. IV. DEPARTMENTAL PERFORMANCE DATA Performance data submitted by the Probation, Social Services, and Health Services Department are included as Attachment 2. A review of the data reveals no clear patterns of departments' position relative to other counties. Rather, mixed performance ratings are revealed depending on the various indicators. A more complete discussion of each indicator is included on Attachment 2. -7- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT GENERAL FUND * Budget Unit 0001: Board of Supervisors Expenditures: Budgeted $955,471 Percent Expended: 57% Expenses are high because of high costs in occupancy and also because of an oversight during budget preparation. Funding for the cost of auditing services from Peat, Marwick and Mitchell were erroneously left out of the recommended and adopted budget. An appropriation of $25,000 may have to be made later this year if the error cannot be offset by savings elsewhere in the budget. Revenues: Budgeted $4,000 Percent Received: 400 Revenues from the sale of maps and documents were budgeted on the basis of the high level of activity in the latter part of fiscal year 1984-85. Though revenues are materializing slowly at this time, receipt of the budget amount is expected by the end of this fiscal year. * Budget Unit 0002: Clerk of the Board Revenues: Budgeted $2,000 Percent Received: 34% Revenues for the Clerk of the Board are generated by the sale of maps and documents and weekly Board calendar subscriptions. These revenues are received sporadically and are, therefore, difficult to project. It appears that revenues may not be fully realized by the end of the fiscal year, however, this will not have a significant impact on the Clerk of the Board' s total budget. * Budget Unit 0003 : County Administrator Revenues: Budgeted $157 ,748 Percent Received: 4% The low amount received to date is due to charges being only recently made to agencies and special districts for services provided by the office. These revenues will probably not materialize until the next quarterly report. It is anticipated that the budgeted revenues will be realized by the end of the fiscal year. * Budget Unit 0005: General County Revenues Revenues: Budgeted $139,384,000 Percent Received: 870 Revenues appear high because 100% of the expected property tax reve- nues are credited in the second quarter, even though a portion of the taxes are not received until later in the year. Revenues for the year -8- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0005: General County Revenues (continued) appear on target, considering the first payment of property taxes, the status of motor-vehicle-in-lieu revenues and the interest earnings received to date. * Budget Unit 0010: Auditor - Controller Expenditures: Budgeted $3 ,078,772 Percent Expended: 53% The Auditor' s office has been experiencing significantly high expenses in Data Processing Services. These expenses have been incurred due to retroactive payrolls, development of the supplemental property tax system, mandated changes in the personnel system, and extraordinary training costs. These expenses were unknown at the time of budget preparation and, unless offset by savings elsewhere in the budget, will result in a deficit by the end of the fiscal year. Revenues: Budgeted $1,020,870 Percent Received: 63% Revenues appear to be high because of certain fees charged only in the first half of the year. Receipt of revenues should level off towards the end of the year. Also, $98,000 of revenue budgeted for Senate Bill 580, reimbursement for supplemental property tax administration, will not be realized due to the Governor' s veto earlier this fiscal year. * Budget Unit 0015: Treasurer - Tax Collector Revenues: Budgeted $566,256 Percent Received: 31% Revenues in the Treasurer - Tax Collector' s office consist of $258,500 commission for tax and assessment collections; $111,000 for supplemen- tal property tax administrative costs; $150,250 for charges to special districts; and other miscellaneous revenues. Revenues appear to be low because of charges which have not yet been made to other depart- ments. These charges are typically made at the end of the fiscal year. Also, $111,000 of revenue budgeted for the supplemental roll administration reimbursement will not be realized due to the Gover- nor' s veto of Senate Bill 580. * Budget Unit 0016: Assessor Revenues: Budgeted $645,900 Percent Received: 3% The budgeted revenues included $591,000 in reimbursement for supple- mental roll administrative costs. However, the revenues will not be realized since the Governor vetoed legislation which would have provided for the reimbursement. -9- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0025: Management Information System Expenditures: Budgeted $339,414 Percent Expended: 32% Expenditures have lagged in this program because of delays in setting policies and procedures to review requests. During the third quarter, these protocols will be in place and a Steering Committee will review and recommend action on all pending automation requests. * Budget Unit 0026: Revenue Collections Expenditures: Budgeted $849,062 Percent Expended: 36% Expenditures appear low because a large equipment lease and substan- tial data processing programming costs will be incurred during the third quarter. These two expenditure items should place the expendi- ture level to approximately $50,000 below the budgeted level by year' s end. * Budget Unit 0030: County Counsel Revenues: Budgeted $463,300 Percent Received: 34% Revenues for County Counsel predictably lag behind the budgeted amount until the fourth quarter, when a budgeted lump of revenues are trans- ferred in from the Special District Augmentation Fund. The annual contract with the Contra Costa Community College District for $20,000 was cancelled this year, but the department expects to make up the loss by concentrating efforts in other areas, such as the Housing Authority. * Budget Unit 0043: Elections Revenues: Budgeted $519,050 Percent Received: 5% The Election division' s revenues consist of $59,600 of State reim- bursement for mandated expenditures; $452,950 for election services and $6, 500 for sale of maps and documents. State reimbursement for this fiscal year may be received before July, but will most likely be received in fiscal year 1986-87 . Over $400,000 in revenues have been received for election services, but have not been entered into the financial system. Other revenues will be realized as budgeted. * Budget Unit 0111: Plant Acquisition - General Fund Expenditures: Budgeted $10,012,428 Percent Expended: 46% Expenditures in this budget are for various capital projects. Funds are accumulated year-to-year for certain projects and expended as -10- ATTACHMENT 1 ' 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0111: Plant Acquisition - General Fund (continued) project schedules proceed. The allocation includes major sums for the new jail and for the continuation of the purchase of the Southern Pacific right-of-way property. Based upon current activity, it is expected that appropriations will be fully spent by the end of the fiscal year. Revenues: Budgeted $4,040, 536 Percent Received: 75% Typically, revenues for capital projects do not follow straight line projections. The high revenue receipts are a result of State funds received for the Southern Pacific right-of-way project. * Budget Unit 0135: Economic Development Expenditures: Budgeted $77,000 Percent Expended: 0% A contract of $77 ,000 for services provided by the Concord Convention and Visitors Bureau was approved by the Board on January 7, 1986 . Payment has been made according to the agreement, but the expenditure has not yet been entered into the finance system. * Budget Unit 0150: Insurance Expenditures: Budgeted $2,000,000 Percent Expended: 62% The expenditures exceed straight line projections because some policy premiums have been charged to this account and not yet distributed to departments. This budget will be fully expended by year end as charges are allocated and funds transferred to the Liability Trust Fund. * Budget Unit 0211: Bay Municipal Court Expenditures: Budgeted $2,674,200 Percent Expended: 52% Expenditures for this budget exceed straight line expectations primar- ily because the services and supplies account will be overspent at year-end. Several budgeted items exceeded their estimated costs, such as the expenses of painting three courtrooms, cost of installing six bench computer terminals, and travel expenses for temporary assigned judges. If no corrective action is taken, it is expected that expen- ditures will exceed the budget by the end of the year. Revenues: Budgeted $1,049,660 Percent Received: 470 The Court' s total revenue will be slightly under budget at year-end. At the present collection rate, vehicle code and general fines will be -11- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0211: Bay Municipal Court (continued) lower than expected. This revenue shortfall will be partly offset if the jury fee reimbursement from the State is received in this fiscal year. Also, the revenue account has been augmented by fines collected from Financial Responsibility Law violators (VC-16028) from July 1, 1985 to December 5, 1985. This source of revenue is temporarily suspended pending a review of the law' s constitutionality. * Budget Unit 0214: Walnut Creek - Danville Municipal Court Revenues: Budgeted $1,345,800 Percent Received: 47% The Court' s total mid-year revenue receipts are below budget expecta- tions primarily because vehicle code and general fines are under- realized. Recovery is expected during the last half of the year due to a greater number of driving-under-the-influence dispositions. The revenue shortfall is partly offset by fines collected for Financial Responsibility Law violations (VC-16028) during the first five months of the fiscal year. Failure-to-appear fines and driver education fees are also slightly above budget.- All budgeted revenues should be fully realized by year-end. * Budget Unit 0235: Law & Justice Systems Development Expenditures: Budgeted $410,675 Percent Expended: 21% Expenditures are understated because Data Processing costs for pro- gramming the Superior Court Criminal Calendaring System to date have not yet been fully charged to this budget unit. * Budget Unit 0238: Grand Jury Expenditures: Budgeted $65,000 Percent Expended: 73% Most of the County audit expenses are charged during the first half of the year. Increased meeting activity of Grand Jury could lead to overexpenditure by year-end. * Budget Unit 0240: County Clerk Revenues: Budgeted $1,803 ,700 Percent Received: 45% Revenues are not materializing as anticipated because of the lower- than-projected volume of court filings. Expenditures for this depart- ment are also running lower than projected. This department' s budget will be closely monitored so that any negative impact of the lower revenues can be minimized. -12- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD 50 PERCENT * Budget Unit 0242: District Attorney Revenues: Budgeted $1,078,952 Percent Received: 230 Total revenues are understated because of delays in receiving monthly reimbursements from two State grants. Quarterly reimbursements from State Subvention Program funds have not yet been credited. These revenues are expected to be fully realized by year-end. Fines, and penalties from consumer fraud/environmental law violations appear higher than anticipated. * Budget Unit 0243: Public Defender Revenues: Budgeted $84,279 Percent Received: 5% Revenue is understated because quarterly reimbursements from State Subvention Program funds have not yet been credited. It is expected that budgeted revenue will be realized by year-end. * Budget Unit 0245: District Attorney - Family Support Revenues: Budgeted $3,744, 382 Percent Received: 12% The second quarter' s State reimbursement of 70% of administrative costs has not yet been applied to the budget unit. Incentive fund revenues are understated because the collection-disbursement-claim filing process takes three months before State payment can occur. The department appears to be generating incentive fund revenues as budgeted. * Budget Unit 0255: Sheriff Revenues: Budgeted $6,048,000 Percent Received: 47% Revenue is slightly understated since some reimbursement from contract cities has not yet been received. All revenue is expected to be realized by the end of the fiscal year. * Budget Unit 0257: Sheriff - Delta Regional Communications Center Revenues: Budgeted $820, 010 Percent Received: 24% Revenue realized to date by this budget represents first quarter reimbursement from participating agencies and is, thus, understated. All budgeted revenue is expected to be received by the close of the fiscal year. -13- 4 ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0266 : Marshal - Municipal Court Expenditures: Budgeted $1,986,370 Percent Expended: 510 The department' s total expenditures will be over budget at year-end. Salary accounts are exceeding budget allocations due to an unexpected need for temporary clerical help and a sizeable vacation pay off of a retiring employee. Professional services are overspent because lease management costs for the Marshal' s move to a new Concord location are greatly exceeding the budget estimate. Part of the expenditure overage will be offset by above budget revenue collections from civil process service fees. * Budget Unit 0300: Sheriff - Detention Revenues: Budgeted $1,042,061 Percent Received: 62% Revenue in some accounts have been higher than anticipated due to State payment of prior claims and increased reimbursement rates. while it is not expected that revenue will continue to be received at the same rate, all budgeted revenue should be realized by the end of the year. * Budget Unit 0301: Health Services - Detention Inmates Expenditures: Budgeted $1,802,361 Expended: 55% Expenditures are exceeding the straight line projection level. Expenditures for temporary and overtime salaries for the first six months have already exceeded the annual appropriation amount. These high expenditures are a result of increased staffing required to serve the increased inmate population. On an annualized basis, it is anticipated that expenditures will exceed the budgeted appropriation amount by approximately $200,000 . Revenues: Budgeted $143 ,000 Percent Received: 0% Budgeted revenues are from State Aid for Justice Systems - AB 90 which is an annual allocation that has not yet been received. These funds are expected to be received later in this fiscal year. * Budget Unit 0308: Probation Revenues: Budgeted $1,950,600 Percent Received: 21% The department' s total mid-year revenue receipts are greatly under- stated because reimbursements from State Subvention funds for the first two quarters have not yet been credited. These funds represent -14- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0308: Probation (continued) almost half of the department' s revenue. It is expected that all revenue from this source will be fully realized by the end of the fiscal year. Total yearly revenue collections are expected to be sightly over budget primarily because parental reimbursement fees for juvenile institutional care are exceeding budget estimates. * Budget Unit 0325: Justice System Programs Expenditures: Budgeted $290,755 Percent Expended: 20% This budget unit consists of three contracts which are paid after demands are received. This causes delays in entering expenditures into the finance system. Expenditures are being made in a consistent manner, which should result in the allocation being fully utilized. Revenues: Budgeted $249,281 Percent Received: 6% Revenues for this budget consist entirely of State Justice System Subvention Funds, which are not credited until expenditures are made. State payments are advanced quarterly and held in trust by the Audi- tor. Revenues are thus understated in the budget print out but will be fully realized by June 30, 1986. * Budget Unit 0330: Flood Control Revenues: Budgeted $28,080 Percent Received: 26% The revenue for this budget unit is derived from a contract with the City of Richmond. The City reimburses the County for costs related to maintenance of the North Richmond Pump Station. Additional revenues will be received as the City is billed for such services. * Budget Unit 0335: Agriculture - Weights and Measures Revenues: Budgeted $698,012 Percent Received: 30% Most of the department' s revenue comes from State reimbursements. The reimbursement schedule for the State contracts vary. For example, the State reimburses on a monthly basis for one major contract. However, there is an approximate 60 day reimbursement lag. In two other major contracts, lump sum reimbursements are received in May of each year. Therefore, revenues will continue to appear understated for a majority of the fiscal year. -15- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0340: Building Inspection Expenditures: Budgeted $2,619,055 Percent Expended: 51% Expenditures are just slightly ahead of a straight line expenditure projection. Review of the detailed expenditures indicates that some large one-time expenses in the Services and Supplies Accounts are the cause of the slight over-expenditure. It is fully anticipated that expenditures will be within the budgeted level for the full year. * Budget Unit 0347: Land Information System Revenues: Budgeted $16,000 Percent Received: 36% Revenue is received from several cities which have joined the Land Information System. The budgeted revenues will be realized during the year as the cities contract payments become due. * Budget Unit 0355: Recorder Revenues: Budgeted $1,090,420 Percent Received: 61% Revenues are materializing at a much higher level than projected due primarily to the new fee related to the change of ownership report. In addition, the low interest rates have produced a favorable real estate market which has generated a large number of transactions. The larger volume of documents being recorded has also led to higher revenues. * Budget Unit 0356: Local Agency Formation Commission Expenditures: Budgeted $160,104 Percent Expended: 12% The bulk of the expenses for this budget unit are charged from various County departments. To date County departments have not made charges to the Local Agency Formation Commission for services provided. It is anticipated that charges from County departments will equal the budgeted amount by the end of the fiscal year. Revenues: Budgeted $25,450 Percent Received: 69% Revenues for this department come from filing fees for applications to create new governmental entities or modify the boundaries of existing agencies. Application fees for the first half of the year have exceeded expectations. However, it is believed that this application level will not continue for the balance of the year and that the revenue for the year will be close to the budgeted amount. -16- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0357: Community Development Department Expenditures: Budgeted $1,345,868 Percent Expended: 71% The significant overexpenditure for the first half of the year is a direct result of charges to other departments not being up-to-date. Charges for services provided on behalf of other departments or agencies will gradually catch up with expenditures so that the net expenditures for this budget unit will be brought into line with the budgeted amount by the end of the year. Revenues: Budgeted $702,130 Percent Received: 65% To date revenue received from the issuance of permits is exceeding the budgeted level. If this trend continues, revenues are likely to exceed the budgeted amount for the fiscal year. * Budget Unit 0358: Planning Projects Expenditures: Budgeted $522,136 Percent Expended: 37% This budget unit includes funds for preparation of environmental impact reports and for several special projects. To date, expenditures are a little behind a straight line projection. However, as outstand- ing environmental impact reports are completed, expenditures will increase to budgeted level. Revenues: Budgeted $180,000 Percent Received: 187% The revenues for this budget unit will fluctuate significantly depend- ing upon the volume of environmental impact reports which must be prepared. To date, more EIRs than originally anticipated have been undertaken. The cost of these reports are paid by developers. * Budget Unit 0359: Sheriff-Coroner Revenues: Budgeted $14,000 Percent Received: 41% Napa County has decided not to continue its contract with the Coroner and will use local morticians instead. Revenue will, therefore, be underrealized. However, expenditure savings should offset this so that a negative fund balance does not occur. -17- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0361: Energy Conservation/Coordination Expenditures: Budgeted $118,408 Percent Expended: 39% The amount of funds expended relates directly to the status of the energy program funded by P.G. &. E. Additionally, earlier this year, the budget unit was augmented for new positions, the costs of which have not yet been incurred. Revenues: Budgeted $56,740 Percent Received: 17% Revenues are transferred in as needed from grant funds and are, therefore, expected to meet budgeted amounts by the end of the year. * Budget Unit 0362: Emergency Services Expenditures: Budgeted $342,223 Percent Expended: 57% Expenditures for this budget unit appear to be ahead of expectations. The reason for this apparent over-expenditure is that certain expendi- tures related to Budget Unit 0363 (Hazardous Materials Management) have erroneously been charged to this budget unit. The error will be corrected by adjustments between the two budget units. On a combined basis, the two budgets units have spent 49 percent of the budgeted amounts. Revenues: Budgeted $158,339 Percent Expended: 19% Budgeted revenues include Federal funds transmitted through the State of California to the County, and contract payments from cities for services provided by Emergency Services. There is a lag of six to twelve months from the time the revenue is claimed until it is re- ceived. Additionally, the Department does not bill the cities for services rendered until late in the fiscal year. It is anticipated that the budgeted revenues will be received by the end of the fiscal year. * Budget Unit 0363 : Hazardous Materials Management Expenditures: Budgeted $180,631 Percent Expended: 34% Expenditures for this budget unit appear to be less than expected at this point in the fiscal year. This is the result of certain expendi- tures being erroneously charged against Budget Unit 0362 (Emergency Services) . The errors will be corrected by adjustments between the budget units. -18- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0363 : Hazardous Materials Management (continued) Revenues: Budgeted $55,888 Percent Received: 6% Budgeted revenues consist entirely of Federal subventions. As dis- cussed in Budget Unit 0362 (Emergency Services) there is a substantial lag time in the receipt of funds. Additionally, Federal funds re- ceived to date have been credited to Budget Unit 0362 and will be transferred to this budget unit as appropriate later in the year. * Budget Unit 0364: Public Administrator Revenues: Budgeted $23 ,000 Percent Received: 1130 Revenue is high because several large estates were settled early in the year. Revenue is not expected to continue to be realized at the same rate for the remainder of the year. * Budget Unit 0450: Health Services - Public Health Revenues: Budgeted $4,320,962 Percent Received: 30% Revenues for this budget unit cannot be projected on a monthly straight line basis since a large portion of revenues are attributable to State revenues, the majority of which are submitted on a quarterly basis. First quarter claims for the period of July 1 - September 30, 1985 were submitted in November, 1985. Reimbursements for these claims have not yet been received. Second quarter claims for expenses incurred for the period of October 1, 1985- December 31, 1985 are now being prepared for submission. Additionally, year end projections indicate that revenues will be lower than anticipated due to a de- crease in revenues for a major program. However, expenditures in this program have also decreased. On an annualized basis, it is antici- pated that the 1985-86 net County costs for this budget unit will be within the approved appropriation level. * Budget Unit 0452: Health Services - Environmental Health Revenues: Budgeted $924,000 Percent Received: 140 Revenues for this budget unit cannot be projected on a straight line basis since over 85% of the revenues are from permits and licenses due in March and April of each year. However, based upon 1984-1985 actual revenues, it is anticipated that the budgeted revenues will be real- ized on an annualized basis. -19- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0453 : Toxic Waste - Spill Cleanup Expenditures: Budgeted $0 Percent Expended: 100+% Since it is not feasible to predetermine the amount of funds required for toxic waste spill cleanup, no specific 1985-1986 appropriation was approved. The funds expended represent the County costs incurred to date for toxic waste spill cleanup. Identified parties responsible for the toxic waste spills are required to reimburse the County for incurred costs. However, there is a lag time between the cleanup, identification of responsible parties, and invoicing the actual receipt of reimbursement. In the event no responsible party is identified, the cleanup remains a County cost. * Budget Unit 0460 - California Children' s Services Revenues: Budgeted $1,670,377 Percent Received: 22% Revenues for this budget unit cannot be projected on a straight line basis since over 95% of the revenues are attributable to State reim- bursement submitted to the State on a quarterly basis. The revenues received to date reflect receipt of reimbursement for first quarter claims (July 1, 1985 - September 30, 1985) . Reimbursement claims for the second quarter period of October 1, 1986 - December 31, 1985 are now being prepared and will be submitted within the next few weeks. On an annualized basis, it is anticipated that the 1985-86 net County costs for this budget unit will be within the approved appropriation level. * Budget Unit 0467: Alcohol/Drug Abuse/Mental Health Revenues: Budgeted $19,151,402 Percent Received: 23% State reimbursement for alcoholism, drug abuse, and mental health programs are delayed pending the state receipt of narrative informa- tion in regards to the claims. The narrative information has been submitted and it is anticipated that the revenues will be received soon. * Budget Unit 0470: State Hospital Expenditures: Budgeted $750,000 Percent Expended: 0% Expenditures for the current fiscal year are not yet reflected in this budget unit, however, there is a credit of $44,200 which is an adjust- ment to prior year expenditures. The expenditures for this budget unit are incurred and included in Mental Health claims within Budget Unit 0467 - Alcohol/Drug Abuse/Mental Health. The Auditor- -20- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0470: State Hospital (continued) Controller' s office then transfers the state hospital costs to this budget unit. There has been a delay in the transfer of these costs to this budget unit. It is anticipated this transfer will be completed before the next quarter ends. * Budget Unit 0472: General Sewer Planning Expenditures: Budgeted $30,000 Percent Expended: 15% This budget unit includes funds for staff of the Environmental Manage- ment Division of the Community Development Department who provide technical and administrative services related to water sewer and other environmental issues. It is fully anticipated that the total amount budgeted will be spent during the fiscal year. Charges will be made against this account as staff time is devoted to these types of environmental issues. * Budget Unit 0473: Solid Waste Management Expenditures: Budgeted $170,400 Percent Expended: 53% Expenditures are running slightly ahead of budget indicating that more than anticipated staff time is being devoted to Solid Waste Management issues. Revenues: Budgeted $189,700 Percent Received: 77% The fact that revenues are running ahead of the budgeted level re- flects fees charged to solid waste landfill applicants for staff services devoted to review of the related land use zoning requests. * Budget Unit 0500: Social Services Revenues: Budgeted $24,489,123 Percent Received: 20% There is a lag in revenues due to the State' s delay in reimbursing claims. At this time last year with 50% of the fiscal year elapsed, 17% of budget revenues were received. As of this date a majority of the 1984-85 fourth quarter claims and the entire 1985-86 first quarter claims remains outstanding. In addition, reimbursement for specific items included in claims for the first three quarters of 1984-85 remains outstanding. The matter of the reimbursement lag time has been followed up by the Social Services Department, County Auditor Controller' s Office, and County Administrator' s Office. In addition, the County has requested the assistance of our legislative representa- tive in resolving this problem. However, there has not been -21- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0500: Social Services (continued) significant improvement in reducing the reimbursement lag time. Annualized projections indicate this budget will be within the net County support level, even though the revenues received to date do not support this conclusion. * Budget Unit 0516: Aid to Families with Dependent Children (AFDC) Expenditures: Budgeted $63 ,761,000 Percent Expended: 580 The budget statement ending January 13, 1986 includes AFDC grants issued for January, 1986. Therefore, the expenditures are really 58% period instead of 50%. Using this basis, expenditures are within projections. * Budget Unit 0518 : Aid to Families with Dependent Children - Foster Care (AFDC-FC) Expenditures: Budgeted $12,029,000 Percent Expended: 550 Similar to the AFDC budget, expenditures for the period ending January 13, 1986 includes AFDC-FC grants issued for January, 1986. Therefore, expenditures are for a 58% period instead of 50%. Using 58% basis, expenditures are within the projected straight line level. * Budget Unit 0519: Adoption Assistance Program Expenditures: Budgeted $267 ,600 Percent Expended: 630 This program is 100% federally and State funded. If expenditures continue to run at a higher rate than originally projected, an in- crease in the appropriation and corresponding revenues will be re- quired. Revenues: Budgeted $267,600 Percent Received: 0% Reimbursement claims for this program are submitted to the State on a monthly basis. The most recent reimbursement received was in August, 1985 for January - March, 1985 claims. The lack of revenues for 1985-1986 reflects the lag in the State reimbursement process. * Budget Unit 0522: Aid to Adults Expenditures: Budgeted $122,600 Percent Expended: 36% This program is 100% State funded. The expenses in this budget unit are not incurred on a straight line basis since the expenditures are for emergency and special needs payments to adults receiving Supple- mental Security Income (SSI/SSP) . -22- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0522: Aid to Adults (continued) Revenues: Budgeted $122,600 Percent Received: 0% This program is 100% State funded. Reimbursement claims are submitted on a monthly basis. The State is over one year behind in reimburse- ment for this program. The most recent reimbursement received was in May, 1985 for July - September, 1984 costs. * Budget Unit 0524: Aid to Refugees Revenues: Budgeted $1,635,500 Percent Received: 38% Reimbursement claims are submitted to the state on a monthly basis. As of this date the most recent reimbursement received in December 1985 was for the period ending September 30, 1985. The reimbursement process reflects the lag time between costs incurred, submittal of reimbursements claims and receipt of revenues. * Budget Unit 0579: Veterans Resources Center Revenues: Budgeted $27,849 Percent Received: 50% Although the revenues received to date are within the straight line projection level, the revenues received are actually 1984-85 revenues which inadvertently were not accrued at the end of the last fiscal year. The revenues for this budget unit are reimbursements from the State Department of Veterans Affairs based on the number of claims filed. The Auditor submits claims for reimbursement after the first six months of expenditures and at end of the fiscal year. Therefore reimbursement claims for the period of July 1, 1985 - December 31, 1985 will be submitted this month. The total revenues received in 1985-86 will exceed the budgeted amount due to the inclusion of the 1984-85 revenues. * Budget Unit 0588: Community Services Department Expenditures: Budgeted $2,668,797 Percent Expended: 39% Expenditures in this budget unit reflect the seasonal nature of a major program - the Weatherization Program. Historically, work in the Weatherization Program is slower during the fourth quarter of each year. It is anticipated that the level of weatherization work will increase during the remaining six months of this fiscal year. -23- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0588: Community Services Department (continued) Revenues: Budgeted $2,541,527 Percent Received: 39% Although the revenues are lower than the straight line projection level, revenues received to date are consistent with expenditure levels. It is anticipated that revenues will increase as expenditure levels increase. * Budget Unit 0590: Community Development Revenues: Budgeted $325,000 Percent Received: 13% Revenues consist of Federal funds which are "drawn down" against a federal letter of credit. Sufficient funds have been requested and received, however, there is a lag time of approximately one quarter in which journal entries are made for the transactions. It is antici- pated that all revenues will be requested and received by the end of the fiscal year. * Budget Unit 0591: Housing Rehabilitation Expenditures: Budgeted $1,082,681 Percent Expended: 580 This budget unit provides for the housing rehabilitation program administered by the Building Inspection Department. The level of expenditures represents a high level of activity during the second quarter. It is expected that this budget unit will end the year at the budgeted level. Revenues: Budgeted $1,080,000 Percent Received: 31% This budget unit is funded with Community Development Block Grants. The amount of funds "drawn down" is directly related to the demand for services. As with Community Development, there is a lag time of approximately one quarter in which journal entries are made for the transactions. * Budget Unit 0650: Public Works Expenditures: Budgeted $5,729,032 Percent Expended: 38% Expenditures in all budget categories are running somewhat below the budgeted level. One contributing factor is reduced personnel costs due to a larger than anticipated number of vacant positions. Revenues: Budgeted $5,087,520 Percent Received: 39% Revenues will increase as road services provided to other agencies will generate revenues during the Spring and early Summer months. -24- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0701: Parks Administration Expenditures: Budgeted $97,355 Percent Expended: 0% This budget unit serves to accumulate funds until sufficient funds are available to build park for off-road vehicle recreation. Expenses, usually not exceeding $500 per year, are incurred for services provi- ded by the Community Development Department. Budget Unit 0712: Small Parks * Expenditures: Budgeted $41,804 Percent Expended: 0% The funds appropriated to Small Parks will be used to develop parks in the Oakley area. However, plans to build a park have been postponed. Revenues: Budgeted $41,500 Percent Received: 43% The revenue consists of a balance of funds transferred from former County Service Area LIB-11 and State grant funds. Due to postponement of the park last year, revenues were put in a trust fund and will remain there until the project commences. * Budget Unit 0790: Notes and Warrants Interest Expenditures: Budgeted $4,686,010 Percent Expended: 270 The low amount of expenditure to date is because a large loan payment is to be made in the fourth quarter. Even with this payment, it is anticipated that a portion of the budgeted amount may not be spent in this budget unit by the end of the year. NON-GENERAL FUND * Budget Unit 0006: General Road Fund Revenues Revenues: Budgeted $8,818,000 Percent Received: 62% Increased revenues are being realized as a result of increased State assistance for road projects made available through Senate Bill 300. Revenues are expected to be above budgeted amounts by the end of the year. * Budget Unit 0007 : Federal Revenue Sharing Revenues: Budgeted $3,719,100 Percent Received: 63% Revenues appear to be higher than a straight line projection because the County anticipated receiving funds only for the first three -25- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0007: Federal Revenue Sharing (continued) quarters of the fiscal year. Funding for the fourth quarter has been approved and the County can expect to receive another $1,187, 500. The additional revenue will be used to offset losses from the veto of Senate Bill 580, and other shortfalls. * Budget Unit 0008: County Library Taxes Revenues: Budgeted $5,934, 850 Percent Received: 94% The receipt of revenues for this budget unit appears to be ahead of expectations. However, the amount received to date reflects the fact that the largest single element of property tax revenues has been credited to the Library. The other elements of the property tax revenues will be credited throughout the year as they are realized. Property tax revenues are not subject to straight line projections. It is anticipated that revenues will be short of the budgeted amount by approximately $120,000 due to adjustments and errors in the esti- mated amounts of the various categories of property taxes. The largest single problem is related to an $80,000 over estimate for supplemental property taxes. The Administrative Office will work with the Library to implement expenditure reduction measures to balance its budget by the end of the fiscal year. * Budget Unit 0119: Criminal Justice Facilities Construction Fund Expenditures: Budgeted $1,170,457 Percent Expended: 30 The funds allocated to this budget are for criminal justice projects for which planning is currently underway. Expenditures will increase later in the year as the projects proceed. Revenues: Budgeted $610,000 Percent Received: 56% The revenues from the court fines credited to this account are slight- ly ahead of projections. Low charges such as the mandatory evidence of insurance provision have contributed to the increase. * Budget Unit 0120: Plant Acquisition - San Crainte Drainage Fund Expenditures: Budgeted $47,663 Percent Expended: 3% The expenditure level is a result of the low level of activity on the design work for the flood control project in the area. Further design work will result in increased expenditures later in the year. -26- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0120: Plant Acquisition - San Crainte Drainage Fund (continued) Revenues: Budgeted $3,500 Percent Received: 44% Revenues are derived from drainage fees charged to developers and from interest earnings on the fund. Lower interest earnings have resulted in the reduced percentage at mid-year. * Budget Unit 0122: Courthouse Construction Fund Expenditures: Budgeted $848,798 Percent Expended: 14% Funds budgeted in this account are being used for design of the Superior Court Annex and represent those architectural fees. The expenditures will not follow a straight line projection in this account. Revenues: Budgeted $450,000 Percent Received: 62% The higher revenue percentage represents increased court activity and conservative budget estimates. * Budget Unit 0124: East County Airport Capital Project Expenditures: Budgeted $33 ,950 Percent Expended: 65% The expenditures are a result of the continuation of the study activi- ty for the East County Airport Project. No new funds were added for 1985-1986. Revenues: Budgeted $33,950 Percent Received: 50% Revenues are State reimbursed based upon expenditures and claiming. No new revenues were budgeted for 1985-1986. * Budget Unit 0125: Buchanan Airport Improvement Project Expenditures: Budgeted $1,433,510 Percent Expended: 30% Expenditures for this budget are for a variety of improvements to the airport. Funding is 90% Federal and 10% Airport Enterprise Fund. The expenditure level indicates the progress on the various improvements. Revenues: Budgeted $1,433,510 Percent Received: 21% Revenues from federal grants for the airport projects are received only after expenditures are incurred. Revenues realized this fiscal year reflect claims for prior year activity as well as for current projects. Revenues will increase as projects proceed further into construction later in the year. -27- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0161: Survey Monument Preservation Expenditures: Budgeted $143,818 Percent Expended: 9% The low expenditures reflect the low level of activity devoted to this function. Maintenance of historical land division lines have become a lower priority among the many responsibilities of Public Works and forces have been diverted to higher priority programs so far this fiscal year. * Budget Unit 0236: Court Records Automation Expenditures: Budgeted $31,006 Percent Expended: 0% This budget unit was created from an additional $1 filing fee author- ized by the Board for collection January 1, 1984. Funds have been accumulating since then for the purchase of an automated civil system for the Municipal Courts. Expenditure from this fund will occur when sufficient revenue is available for the purchase of a system. * Budget Unit 0237: Clerk Records Automation Revenues: Budgeted $22,000 Percent Received: 47% Revenues are being realized slight under the budgeted amount because of a lower volume of court filings than projected during budget formulation. * Budget Unit 0256: Controlled Substance Analysis Revenues: Budgeted $4,900 Percent Received: 97% This program is supported entirely by fines from Health and Safety Code Section 11372. 5 convictions (substance abuse) . Monies may only be used for training of criminalists in the Crime Laboratory (or equipment related thereto) . Revenue for this budget should exceed the allocation. If not used this year, it will be encumbered and carried forward. * Budget Unit 0353: Recorder Micrographics/Modernization Revenues: Budgeted $242,479 Percent Received: 138% Revenues were projected at a much higher level than the budgeted amount, but were not budgeted at the higher level since the additional revenues were not anticipated to be spent this year. The actual revenues expectation for this budget unit is $675,000. Revenues received above the amount budgeted will remain in this fund and be appropriated as necessary. -28- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0367: Game Protection Expenditures: Budgeted $21,301 Percent Expended: 0% The use of this fund is restricted to fish and game related activi- ties. The Board recently approved a $5,000 donation to the Alexander Lindsay Junior Museum for its wildlife rescue program. The Sheriff has also requested that some or all of the remaining funds be used to support the Sheriff ' s Marine Patrol, which enforces fish and game Taws. Revenues: Budgeted $6,707 Percent Received: 710 One half of the fines levied for violations of the California Fish and Game Code must be deposited in the Game Protection Fund. Over the past few years, there has been a decreasing trend in receipt of these fines. However, it appears that revenues during the first half of the year are at a favorable level. An increase in revenues might also be expected if game protection funds to be used to support the Sheriff' s Marine Patrol result in increased law enforcement in the County' s waterways. * Budget Unit 0531: General Assistance - Revenue Sharing Expenditures: Budgeted $4,941,064 Percent Expended: 58% The expenditures for the period ending January 13 , 1986 include January, 1986 general assistance grant payments. Therefore, expendi- tures are for a 58% period instead of 50%. Although on a straight line basis, expenditures are within projected levels, there has been an increase in general assistance cases within the past month. This increase is consistent with historical trends which show General Assistance cases increasing from December through February. In addition to the caseload increases, the Board of Supervisors approved an average 15% general assistance benefits adjustment increase effec- tive September 1, 1985. The approved 1985-86 budget did not include any payment adjustment increase. It is expected that additional support will be required for this program by the end of the fiscal year. * Budget Unit 0662: Road Construction - Road Fund Expenditures: Budgeted $1,373, 372 Percent Expended: 17% Expenditures in this budget unit are seasonal, reflecting the fact that the major road projects are undertaken during the Spring and Summer months. Expenditures will increase significantly during the second half of the fiscal year. Expenditures will be within budgeted amounts by the end of the year. -29- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0673 : Delta Ferry Subsidy - Road Fund Expenditures: Budgeted $100,000 Percent Expended: 580 Expenditures to date reflect some one-time costs for ferry slip repair work. It is fully anticipated that total annual expenditures will remain within the budgeted amount. Revenues: Budgeted $43 ,000 Percent Received: 0% Revenue for this budget unit consists of County property taxes col- lected within the M-1 Service Area. These tax revenues will be credited to this budget unit later during the fiscal year. * Budget Unit 0674: Miscellaneous Property - Road Fund Revenues: Budgeted $73,500 Percent Received: 38% Revenues are derived from rental income on County-owned structures which lie within County right-of-ways. Revenues will increase during the year as rental income is received. * Budget Unit 0676: General Road Planning - Administration - Road Fund Revenues: Budgeted $166,600 Percent Received: 13% Revenues include abandonment request fees and reimbursement work for staff work associated with the development of fee benefit areas and other project development. Additional revenues will be realized as costs are accumulated and charged against the available revenue sources. * Budget Unit 0841: Buchanan Field Airport Revenues: Budgeted $776,690 Percent Received: 83% Increase usage of airport facilities and development of airport property is resulting in increased revenues. It is anticipated that total revenues for the fiscal year will significantly exceed the budgeted amount. * Budget Unit 0842: Airport - Special Aviation Expenditures: Budgeted $24,520 Percent Expended: 3% This budget unit provides for a special airport and aviation projects, including the repair or replacement of capital improvements. There were no planned major projects for this year. To date, only inciden- tal expenses have been incurred. -30- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0842: Airport - Special Aviation (continued) Revenues: Budgeted $5, 500 Percent Received: 94% Budgeted revenue consists of an annual $5,000 State grant and $500 from earnings and investments. The State grant was received during the first quarter of the fiscal year. * Budget Unit 0843: Airport Fixed Assets Expenditures: Budgeted $150,900 Percent Expended: 4% This budget unit provides for the purchase of fixed assets and capital improvements required at Buchanan Field Airport. There are several major improvement projects scheduled for this year. Expenditures will increase as the projects are completed. It is anticipated that construction will occur during the Spring and early Summer months. It is anticipated that most, if not all, of these funds will be spent by the end of the fiscal year. Revenues: Budgeted $140,900 Percent Received: 0% This budget unit is funded via the transfer of money from budget unit 0841 - Buchanan Field Airport. All of the budgeted expenditures are funded with available money within the Airport Enterprise Fund. * Budget Unit 0853: Hospital Fixed Assets Expenditures: Budgeted $6881004 Percent Expended: 33% The expenditures in this budget unit are not expended on a straight line basis, but rather according to need and departmental priorities. In addition, beginning this fiscal year, principal payments on capi- talized equipment leases are now being shown in this budget unit. On an annualized basis, it is anticipated that expenditures will exceed the budgeted level, unless corrective action is taken. Revenues: Budgeted $362,854 Percent Received: 20% The revenue to this budget unit is part of the County subsidy to the hospital. It is expected to be transferred by a journal entry by the end of the fiscal year. * Budget Unit 0863 : Health Plan Fixed Assets Revenues: Budgeted $7,146 Percent Received: 0% The revenue to this budget unit is part of the County subsidy to the health Plan. It is expected to be transferred by a journal entry by the end of the fiscal year. -31- ATTACHMENT 1 1985-86 MID-YEAR BUDGET STATUS EXCEPTION REPORT ELAPSED BUDGET PERIOD: 50 PERCENT * Budget Unit 0997: Contingency Reserve - Airport Expenditures: Budgeted: , $0 Percent Expended: >0% A small amount of expenditures for prior year commitments have been charged to this budget unit. Revenues: Budgeted $41,210 Percent Received: 100% The revenue in this budget unit actually consists of Airport Enter- prise Funds not required to meet ongoing operating needs. These funds are being held in reserve and will be expended only as required to meet emergency needs. -32- ATTACHMENT 2 SUMMARY OF PERFORMANCE DATA FOR THE PROBATION DEPARTMENT The Probation Department submitted much more performance data than requested. The data along with a detailed narrative is enclosed for your review. A summary of the data formated by eight performance indicators is presented below. Quantity or Workload Indicators Rank Number of Counties 1. Number of adult Probation 3 12 Investigators per DPO. (highest to lowest) 4. Average number of adult cases 7 12 supervised per DPO. (highest to lowest) 7 . Number of juvenile referrals, 5 12 investigations and cases (highest to lowest) supervised per DPO. Efficiency Indicators 2. Average service hours per 5 9 adult municipal court case ( lowest to highest) investigated. 5. Average service hours per 1 5 adult case supervised. ( lowest to highest) 9. Annual utilization rate 9 12 of Juvenile Hall. (highest to lowest) 10. Annual cost per bed of 11 11 Juvenile Hall. (lowest to highest) Qualitative Indicators 3 . Percent of adult probations 6 12 violated per year. ( lowest to highest) -33- Probation Department Gerald S. Suck p Contra County Probation Officer AdministrIative Offices Coda 10th Floor County RECEIVED Contra Costa County Administration Building 651 Pine Street JAIL 13 .1986 (Martinez, California 94553 (415) 372-2700 Office of 0� _Inf�,, .,kdministrator To: Phil Batchelor, Date: January 10, 1986 County Administrator Attn: Tony Enea From: Gerald S. Buck, Subject: Performance Data Guide to County Probation Officer Locating Indicators Requested r In that I have provided more data than requested, the following guide is provided for your assistance: Function Indicator Table or Reference Adult Services 1. No. Prob. Investigations Tables 5 & 6 Investigation per DPO. 2. Average service hours Table 6 per case investigated. Adult Services 3. Percent of probationers Table 1 , Page 2 Supervision violated per year. 4. Average number of cases Tables 5 & 6 supervised per DPO. 5. Average service hours Table 6 per case supervised. (Note: Average DPO caseload _ 1.25 = approx. hours of service per case in any Dept. ; i .e. , CCC - 152 cases/DPO = 125 = 1.2 hrs/mo. Juvenile Services a6. Percent of probationers This data is not violated per year. available for any Department. 7. Number of referrals, Table 7 investigations and cases supervised per DPO. -34- . Phil- Batchelor - 2 January 10, 1986 8. Average service hours Hours per work unit is per case investigated not available - see and supervised. note on Item 5 above. Institutions 9. Annual utilization rate. Tables 3 & 4 10. Annual cost per bed. Tables 3 & 4 GSB:ds Attachments —35— Probation Department Gerald S. Buck p Contra County Probation Officer Administrative Offices Costa 10th Floor County Administration Building `, 651 Pine Street Martinez, California 94553 (415) 372-2700 Oa � To: Phil Batchelor, �� Date: January 10, 1986 County Administrator From: Gerald S. Buck, Subject: Probation Department Performance County Probation Officer Data - Productivity Plan Pursuant to your.. request, we are submitting indices of Probation .fu.nction per- formance. Indices have been depicted on the following attached tables. TABLE NO. 1 (2 pages) - These are general indices of data pulled from the 1984 report "Criminal Justice Profi.,le" of the State Bureau of Criminal Statistics. Caution should be taken regarding the accuracy of this data. Notable .Obseryations: 1. Arrest rates for. both adults and juveniles in'Contra Costa County are among the lowest of compared counties. 2.'. The .rate of .juveniles referred to Probation in'Contra Costa County is 'at the mid-point of compared counties. 3. Juveniles are petitioned to Court in'Contra Costa Countywith greater frequency than in most other counties studied. 4. The rate of Juvenile and Adult Probation caseloads to population in'Contra Costa County is at about'. the mid=point of the counties studied'. 5. The Adult Probation caseload in'Contra Costa County is 'made up. of a greater percentage of Municipal Court probationers than other counties, with the exception of Fresno. 6. Adult Probation violation removals as a percentage of the caseload is'lower than 6 of the 12 counties studied. TABLE: NO: 2 (l page) - This ' table depicts percent change of selected indices from 1983 to 1984. Notable .Observations: 1. The decline of .juvenile arrests (-14.3%) was greatest of the counties studied which ranged from +26.2% to -14.3%. -36- Phil Batchelor - 2 - January 10,. 1986 2. Juvenile referrals to Probation also dropped the most in Contra Costa (-10. 7%). The range was from +20.5% to -10.`7%. 3. Juveniles petitioned to Court in Contra Costa County dropped 15.4%, surpassed in decline only by San Francisco. 4. Juvenile Probation caseload change varied- from +14.4% to -10.4%. In Contra Costa County a drop of only -1.2% was observed. : 5. All buttwo counties experienced an increase in'Adult Probation caseloads. The range of increase was from -2.9% to +47:.5%. Contra Costa County rose by 10.4%. 6. Adult Probation violations changed very little in Contra Costa County (=.7%) while the range for others was from 75.2% to +44:8%. TABLE NO. 3 (1 page)- - 'Juvenile Halls - Data available for this performance factor are from 1982-83, the latest available. Several criteria must be viewed to analyze the complex issue of institutional cost. Based on occupancy, an overcrowded facility has a lower per capita cost, but other problems ensue with overcrowding. As the population is ' kept in check, the cost per capita rises-. Another major factor in costs is salary level and staff to child ratio. Departments do not control salar.ies, .but'.a higher, ratio'of staff. to children is'desirable for safe, secure confinement. Notable :Observations: 1. Budgeted capacity is less than rated capacity. in'6 of the 12 counties-, including Contra Costa County. 2. The Average Daily Population is less than budgeted capacity in 11 of the 12 counties (Los Angeles is the exception). 3. The .Juveniie Hall utilization .rate for Contra Costa County is 78%. There are three counties with lower rates and eight with higher rates. 4. Contra Costa County is'one of only five :Juvenile Halls which have medical staff in' their'budgets and only Santa Clara has more medical staff than Contra Costa County. 5. Weighted salaries paid' is computed by salaries of direct service staff.. Contra Costa County has the highest weighted salary rate of all counties studied`. 6. Staff to child ratios range from .38 staff for each child to '.73 staff for each child. In Contra Costa County the ratio is ' .53 staff, per child based' on average daily population. —37— Phil Batchelor - 3 - January 10,' 1986 7. Budgeted cost per day per child in'Contra Costa County is '$71 (excluding noted cost factors). This is the highest per day cost of the counties studied. A daily cost of $92 based on average daily population is also highest in Contra Costa County. TABLE NO. . 4 (2 pages) - .Juvenile Facilities - As can be seen, each of the counties has at least one treatment facility of from 19 to 200 beds. Los Angeles has 15, Contra Costa County has 3. Nearly all are budgeted at their rated capacity. The same cost anomalies which apply to Juvenile Halls also apply to the operation of camps, ranches and schools by Probation Departments. Notable Observations: 1. Only Contra Costa County and Los Angeles have utilization rates for all facilities at 94% or more The range of utilization is from 69% to 101%. 2.' As a rule, the cost of operating an unlocked facility .such as a ranch is less than a locked facility such as the Boys' Center. Similarly, locked facilities ave a higher staff to child ratio. 3. The cost per day per child based on average daily population is $43 at the Contra Costa County Ranch. With few exceptions, this is .the lowest cost (Santa Clara is' $.36 and $35). 4. Again; the weighted salaries paid in Contra Costa County rank among the highest with exceptions in'Sacramento .and Santa Clara. TABLE NO.: 5 - Adult Probation Services - This table depicts basic functions of .i.nvestigation and supervision. It.should be noted that the types of investigations done, .their complexity; size- and format of reports, and quality of ,product is not possible to compare in'this 'fo'rmat. Further caution should be given to. assessment of ..supervision caseloads as varia- ti.ons in caseload size, specialization and types of cases included' in the data vary extensively as is seen by the myriad of footnotes. Due. to. the difficulties of comparing unlike operations, we. have used a staff to work factor on this table which -can.be used to. assess the quantitative relationship between deputies available and work product output in the most general sense. This is ' shown for investigation and all of Adult Services combined. Notable .Observations: 1. Contra Costa County has the third highest of 12 Departments staff. to work factor for investigations. This implies that we produce a. higher number of ,investigations and, reports for the staff we: have when compared to the 11 other Departments. —38— Phil Batchelor - 4 - January 10, 1986 2. The average Adult supervision caseload per Deputy Probation Officer in Contra Costa County is the seventh highest among the 12 Depart- ments. As noted in' the footnotes, this ' is not a very good indicator of productivity. 3. The work to staff, factor for all Adult Probation Services in Contra Costa County is*the seventhhighest among the 12 Departments. This indicates we are in the mid-range of assigning staff in accordance with the Adult Probation functions listed. TABLE NO. 6 - Adult Probation Standards - This table depictsthe hours of service standards for investigations and the average number of investigations . completed per month per deputy. Standards for hours of supervision service per month per-.case are shown, but only five Departments have .such standards as Contra Costa County has. Notable :Observations: 1. Superior Court investigations and .reports .are one of the. most important and complex .fu.nctions performed- by a Probation Department. :Few counties'.have conducted scientific time studies to assign hours of service averages, to this `fu.nction as Contra Costa. Probation has done. In comparing our'. standard, we find four' Departments .which allot more time and four, Departments: which allot less time to this :fu.nction. 2.' Municipal Court investigation and report standards also vary and ours are the product of a time study'. Three Departments allot less- time, .than we do and two (Orange and San Mateo) allot more time. Similarly, three Departments have Deputy .Probation Officer caseloads that are .Higher and seven Departments have lower per month caseloads. 3. It is'significant that few (five of.the 12 Departments) have hours/ month standards fo'r .supervision service according to case classifica- tion. Of these five,' Contra Costa County allotsthe least service for maximum..supervision cases although all are in' the same range at .about two and one-half hours of .service per month. TABLE NO. ' 7 -*Juvenile Probation Services - This table depicts basic'.Juvenile Services of intake dispositions, original petition investigations and cases supervised. As with Adult Services, it' is necessary to. express comparisons with a "staff, to work factor" which is quantitative and does' not reflect quality of service or other variables, such as the availa- bility of special or intensive supervision caseloads. Notable :Observations: 1. The :number of- juvenile investigations for Court per month per Deputy Probation Officer in'Contra Costa. County is 11.1. All but. one (Ventura) assign more investigations per Deputy. Probation Officer per month. —39— Phil Batchelor 5 - January 10, 1986 2.' Contra Costa County has an average supervision caseload per Deputy. Probation Officer of 69. Eight other Departments have higher caseloads and three have lower caseloads. 3. The staff. to work factor for Contra Costa County is 43.5. Four Depart- ments have higher factors (more work units per staff) and four. have lower factors. The average of _the twelve .Departments is .47.1. GSB:ds Attachments —40— ♦ N N N N j T , o c + rt z p v 3 + Z C 1 d 3 T CD N Z I t0 D J fD n d z -5 CD y m P w a o r fD av J i rD a rp I rD O I y c i d Q. O '2. o"o (D r 0 7 O C7 Z J N j W I Oi ! .V.. j O 1 I v CD I �p ( cn I .r M M OD I cc ! O ! O+ v t0 O C N V 1 rwv J O+ cn w �o cn d. coN N O W j r m Cn rt rt j O 1 O , O O ; O j O O O O CD I O �« O O I O o 0 0 o O o 0 C, n � � 0 Z A D O N ( m S, V�O NIn A A .0 C0 A t0 N � V (n A m {n Oi Im -S p N Cn A •-' O A O A m p A V V1 C+ W m N A O, O, m N W co m V N N rt C+ fD A d W rt A A W l71 V7 (n A (n V m W (D a n aa, co A to O A co cn t0 10 m O N w i o co W Ln ko to � w i to Im C, oh� z COr A O W �-' O� 01 V V V W (71 D C 1 Z < O N Cl �0 N A i (Nn V A A O O rt N O V �0 I A O m N j fD O � Z to rt E O n � � n d ]C rtc r •-' ►� -D Dc O -1z < D m V ON m O V m m V W r m —Z (D v O V N V C0 V N a% O O fD O A t0 10 V O O CT 01 V A CJ1 N O N 1 I{I C=) O O . O m N 1 O co —i fD cO _ Z A W V V V 10 m v W O A `-' 10 CTM+.Cr N r-. A O O r w m O m m c ID d a CDI cn vn m m m O O cn CD J z < o J. fll ID j � 3 N V1 W N Oi 01 V1 Ol A N 10 Ln Vl O Z V A I m I m Q, Cn O O m C n N O Z (n m N W Cn O, d O O O CD O Cn m t0 �D A rN.. A W t0 I W O t]1 O T w 1 Cl Cn O 10 Cn �0 Ln Z O i ON I Wm V rN-. I W A i N j N i w 1 I t I o o j V cy, i O w I O c.n I t0 j O 1 CD O O+ J -41- iv d Ln w cam, A o z o o 7 ( 7 n < ' o v m ( a 7 J c d 3 T W + i D rD z j a � r�r ori z m 7 7 7 n n o, o a m a N n O 4 1 I tOii i I n I y 0 j N C-)-0L r W I �--• N N N W OD �-' W �-' N O G O W r,3 W H no a, co co A N Ol t 7 Wr N Ol W W i V CO (n cn O Ln O d -' a O fD 7 v L I I CD a O< _ 0 N N N �+ N N W W W N N O Cti O N N V W A V7 OD Cil A V A O OrY N O (n O �--• m �••' 1D V W N N O (D 'OHO O Z M j Q T N I i--• �-' N V �••' �•' 7 n rn N (31 co p W co c cn rn kc n 0 c1 A�+ 4 01 n-• A N I O N W I cT A to CT O'-' O N W W O W W T -W T W T W T W T W T i W T W T W T co T W T I CO T (D —.O (Da mw mw ow rDa mcW mDu (D n, J MW CD 01 I mo, Cl. mm is�. . an l. nn aQ.n an I an Cl.nn Cl. nn I nn mrD V rD 7 i l I W r i-•' N N N N N N W i--• V N 01 W V i N V (jl O O O1 A W t0 �D t0 t0 O� Ln A i0 Cn O O rD M CL N O W co D -i 0 0 N O O O W Un O, W �p tp <�• nr o 70 l� r N A a�D o N N A W A V W t0 07 CTt I t0 j A I N O a r• V O V i0 O O� V Gn i W Obi m O U1 N to V1 w j Ln [n V1 Ln V V (n 1. -+ •-w n o cn 7 m LnC., W W N A Ol CJ1 A W tN-. tD O rD l0 �O W lD tD W N A rt c co rn v w I A I .�-• Qt O W m v 3 O N ? N N W 01 i �p f7 C o I z 7 J o Q n •P Q1 Ol N W W A A Ql 01 W I V �O O M W O r0 w v 1 V A W A j O co O �-' V I N W W w W V A O O O I 1I � N I O O A I w i co I p I Q1 + O Oi -a i rn W I j I c W � .-• N �- .-• .-• � w OD A N W N W (n VOt Q tG O A O W j O �p cT �--• t0 j tD W Oi �' • 2 -42- * C N N N N N ;Q O r -n D C) n N (D 0) w 0.1 Q) iy -+• O - J O O O O O O A < w to (D 0) O C C C+ C+ -11 W Gni 'S to D O (D Z C+ A •S 1w Z (D N (D O O Q 0) L< 1 (D 0) C•) r+ 11 O A lw c+ M O O J Z J. -5 O (D to r� Gr 1/1 tZ N C+ A 000 0 4::b o I J. I i (y + 1 1 + + + + I + I 1 1 D J H� C) -S D 00 U•1 V N tD tD N 1-' W IJ S 'S Q L Ar (D C C IJ N (17 W CT lD CS) A ? CT1 0 •--+ N C+ Ch Ch fD J. A (D O O C- + + + 1 + 1 + + + 1 + 1 1 D C p-4 N IJ C-) -5 < (D tD A O m Ul OD W I.- W 00 1Z N O V V N N N tD V tD W O A N W O In -+• N 1•+ C+ (D (D s1 tt (D co m 'D o0 00) + 1 1 I 1 + + + a 0 c W I + 1 1 o c D> C) W P U 1 �-' •A O W ? O =r 'D • �-•+ 01y Z �-' O -y W t + CJ) tp U) P V W 0) V V O Q ;Lo M ko 2 C•) (D 'fi W 0 O 7C ►-,o tD D J 00 O o\\� ---i L -P�- N 1 + i 1 + I + + 1 + 1 1 O C F--I IJ 1--+ FJ C7 < C-) Z 0) V W to F-' O W W V V A Ut OS Op SD D •A O C - Z C7 t/tLo Z (D m m C+ CD c+ c+ m cn A N o\� C7 C- + 1 1 1 1 I 1 1 + + + 1 0) C �. �. I.- C7 N < p t-+ N O 00 Ut Cr 4:z- tD 4-- 1--+ =r (D 01 J 00 00 F-' N O U1 A ►-' tD N O 0Llr) (D Q-0 A F+-+ n CL N N N+ + + 1 + Q I-•I + 11 C 00 N N (3) CT V N O C) N J • � (D C+ OD d �•-' tD � N I--' f-' •A V1 lD ? (L -•-� O O N !1 C (D Q.a D C D W c J, Q- + + + I + + 1 + 1 + + 1 O C m V m N 1-•+ 4�b r I.- C7 J J Z (7) 00 V N -A 4:b 1"' Ln CT N Ul =7- 0) c+ CO Ar r+ N V 00 O N (D O O N � -43- c v+ v+ j Ln I N (n a i - z I o z I I o o I; I c I a 3 m I m I a I v+ 0 O N N x A i •• X O n b0 c 03 j i v"o N O P O 1 N w I `•' I N N N N N w N N W �-+ b X i F'SW V N •�+V (n O O O c n a O N O C MCDd N N N A F•+ N a— O ti N O W V N Cfl (n O ao W N A O 7 c (D Ln %0 O (n O ID ON (7� N O C7 m tv tG C -{m 0 7 G (n a fp V m I I O N�•-� G �•- b Df a�•-� --' A W A V W Cn N Oo O A -i r D �•tA n O m oR o z p�• N O C N D G m p (D 'o V V I CO (D m O (0 O v tD V CD a b �D A t••• A coO at O W (n (1T OD C D N O a bE 2E bE i dE 3E 3e 3E S2 22 3@ 22 38 p m Z �• 0 l J f f I a z v IA (D , I� R I c o < w O a m D n c z R n i m w o I c m r o c n ts+ v+ to w+ ts+ t� t to tis tt+ H+ r+ v v v m Z CD o A ACh i O) + rn A A L"(n rn I (79 Vt v Cl)m �~ z c v w (n cn o, w m cn N w r m z n x b 3 ^i O 13- m lr- T Lo v a I v{ • N "in D m N R W W car to to ts+ to to A^ 64 ts+ I tr+ to* v+ tss D m v m O) (n (O V m (n (n m 0) m (.n (D b=c n < W (D N V N A W N w O1 N b O T m CD O Ln •C N p I < a+ (D I CO Z N co i i m w CI I I I mTnn co W W (n W (O (n OD r CD N Cn -i T D O (n N W (Jl N O N (n O (T A T m m T r r... co O O (A M 10 (M yW co I cn OoO n c� �•' W (D V W �D �+ r O� N w I NOD (71 O co O�2 Oi A A O1 -<m i C) D �noco 'm m (n A i (n V I (n ! W Cn to A VT A (n C", N ; Chi w I co I m I A ! I v w vrvw o i r � O I -44- <r rlC.1d I L t/ o 3' =:m 7c'210W Aio ' E'm r-C-') I m=coo Tn 0000 7 b n n O,d C cD �O-0�d til d N 0�T�9 010 <* DO c CiniNbv i! clo rn) 'I .=5 -S J7 � a �!�7 NId,fD ! ( i !D n G'+� �+ d G Q'7r n N O 3 , fD O 7�7 A !C n O ICS G I-+•��!7 II fD �G r'S 7 'ci�7I �C J I.�. ry{rr I - n r..{ 7 O d I N T C fD n fp d N < n jN�l I (p d IN n O A I N lI N n N 7 N ct n d I � 7r N Z �,� i i 1 Y Y YNYYY YIY, +O ;tDicTi Ot � CD O O O O ��-j�Dlo O+ I Ip tG IYtN V a.x� O ;rn[l11 O 011+tsi to O c,nll cn O U�cT'i O O tT O N{I W O ; O�•' i I IO O A (•'f C < o IWv,rn i tDo 00000 0. Ytoo rn WW �- a+ acs O O cn O I C) Gn Cts V7 V�O O L'Cl ry CT O rm ' �m <D —'c—:) YY 1•..Y Y YY Y Y a V cn c J I A O t o O O c 0 C.0 ID 0 0 O W O t T CO t T Y O t {C-D m I V V tV co O SI C) .n 0-%D�--W�o W w w rn co�c cn :r- C<am m z 0 m � A a I I I m r z V V to co m to cD tO tD ID t0 cD t0 t0O c0 cD co tD W J cD W cocDO OD^NN" O W •+! Y Ln'•-� cT cn V c0 tD Ln V cD Y A cD D,W co N c0 (n A -�Y D T a-e ae ae)ae as ae ae ae>e e•e ae ae aA ae ae ae ae ae ae re ae ae a•e�;Q m--4 n c. a o c v v z m a z n r -+ m .. T z ` 77 C) D C O m w to +4 Cl m cn m fT A Vt cn AAAOI AA CTA W V TOi cT CTA A W A V A A-i r V r co V A t0 Y Y N W O tD CT Ol A W�•-'Y m Ol w Y A D a m W <d m 3 t N D Z n v m D a z n o m� D n �b4 I M to b4 lA D A-i N m 01 T Ot O+ V A A Q,A A CTA A V m m cn CTA cn W o) 01 V A vm N co O V cTW NOY(nANOV cnW t0 Wto Vf W •Ov co D m T �O < co co C+ Y ^j W W W W AW W VIW W OW WOOtV CJ1A W N N N YYN N i Y W A O N V v tO L1 V V V Co V Ot Y O t0 W V O� N Qt O NN T W W W Vl I Y VVAU'IV WN - Tm ' v I �! T —,--�r--�Y Y,.-. Y 1--.�•+Y Y Y Y IW WWIW coWW W W W WW W W WW W,W W V ! OCD I OY r-M ! II A A AA A A A A A A A A A A A tT O t0 W tD O D S co W�W co Y Y Y Y�--. W 1N W Ito�0 0 .'c-1 i} <m v i I f O O x m ;.n Z"cTIA IQ1 N N A�N�N A N N W'Ln tT A111-1 A I (N A A cT N v r� W A i W NI W I Qt t0 to A! tD M c0 tD V 1.-�of Ln�W W O , W O t0 m N •D O � �I �nD•1 n 1 1 � ! I ! I O r v m z a I ( I o ,D ! liljj j o Oj!r,Oj jr!Oi Oi r,O o�r;r�rlr�p O ijr ipi0 j�rIr pI��o i � n -45- 'N ;NN d d I1d { d j Ocz•• Cov') 'oOz!jOf0ofI�crd ii1I�IN•a��S*InJ�Vz3i � 1 roc jl3 �rzJ�(Q••1,dnTo I�I Os.�jI�fIzfNOC >IMO(>dC + ccA��Nz�C mNnz jlyr�\0 d N d 1Ic') ofd i do CDo = dd - e+ a : m m n n :' Z N X JA O c—Z1 3 J vn n I J o O 3 G C' 3 d d N X 0 NIW IA NON 1lrn N Its A N O V D -d P NIIIV NOD�CD0 ijA im ' IOI00 i 00 AO �C--+3 O Opo G j l i I � I �C3 I c 0 J o d o N W b NON 'IN N N W N A 01 ID O W N N V N co O O C" .1C.O I O O O 4b O m a c <o z V d G ( C) N ry O N O C D C N �•••� C A W�-•• N V G Lm O W 14 r D m V W O AV MN N W Oto OWN NV D•--�.� j7 f 2 cm LA otAn o c C+ a c o •. sr cam-. c NN LD N-44. N V w V� NSD N c C? Z i bk 2OD�e aNe She ave 2A-e ,aAe aNe W0 3AR aa-e 3Z-e 2AE a'R c. v m 0 11 n � C+ n d rr � 0 0_ o n +� co n c «A I 4�+ 64 4A !A I p m 7 A A A cn W W T W A P.A —{ N 0) M r A A ( N A Ln N N (n W N N n O co 7 r+ v+ I v+ erg a m < (n Ln A Ln W W I A to O \ cD �--•N %D ID(n O) If A co O1 V U'1 01 01 O co O co O 1 <p O Z S O _ d +--• r �-•N N y .-•• N W N N N N N N N V N A W T O cn Cn N (D rn V O V V 01 V A'D T m T �-'�•' N iV N N , 1 N N '-'�•-•�--' N�N N m V N (r , �-+f-• 170 OD V V NIf-• Oi V r W m f� 1 W N V 01 U t W O �--' N N C o A l D D S O cn N N%D V N - A Oi <m v I o v n a AW W WNN ��W N WI(nN C+N AN �D I IW WNW I IA NON OW NV Tp � ( �1 r-• ( i � I I D-� D I � r C> im jC�u IO i0!0(0 Iio i o i OI r�O �i0!o 1101,0 i\ iA N j O n -46- G Ln N N Ln N .'a O r- 1 D n CD 07 d AJ 0) A) O Z O O O O O C) < w N (D A, O Ln c 0) 3 -n co 0) -5 Ca D CD- `1 n (D. -5 0) z (D a N (D O Q 0) O (D 01. n c+ 0) -5 (D (M C -� (D O 06. (D n -fi 0) O n N c+ (D J O c+ O 0) N L1 N c+ c+ 0) O O O O C+ CD N Z V) r V r N N W r c+ W I.- W I.-+ (D -0 N N r 41 r •P V D V Cn N O O O a) N ( ) 00 r r < 00 V 4�:-- N z n O Cfl •A CO Gn V N Ar N W N 00 c+ -5 -+• N C•+ J . 3 c O) N W ( N N N Z Cn r co LT) (D �. \ v v W 'D l0 r O D co W O O O O Ln %D %0 N W V r 110 •P z n O Ln Ln 00 O V Ln a) N O (+ -5 N L•+ r ;0 W O r fD Z co N O O O O O O D O m O -P. 'S �• O 1 I 1 1 I 1 I N O CO CI• N r Ln N O p -0 V O CTI N 4.'t- CTI 4 Z r m r V < C+ C .� \ (D a C-O to N r CTI W m D O) O CO V (A -+ -100 N N r a) N •P 4�:,- al Ln W r O -+ ;0► -� O O co Z D :E: Ln ►-a m O C+ O �v N N 5 0) < Z -n CT Wn t0 L n r 01 7r --h N N 0D l0 W •P a) •F� O W O O O N 't'1 Cc+ m 3 Ar c+ • � D n O C Z Ch o >f n m z m z r O Ln LO c co n N r Ln r r D 4:�-m W U) O CO V A CO 1.0 V N m (D 0_ X Ln 'S O Cn Cn O 00 00 W 0o r N Cn r W < J O m 00 co N N O V r LO CTI N C+ O O O LO N a) O Ln U) •P O M N N a) Ln 4:::- W N r (D C1 n D r U'I r N r r r W lD r r A+ < N P. O N W (n O CO a) N 9.0 Ln N (D Cn m N Nn C) � O m O N O N J O Ln A) C ca- m 1m 00 V a) V CO V \ r W N a) (D N ---i a) Ln N V N O CTI D N O W V z O < � CL• CTI CJ) CTI N �• iZ O n c J (D J N C+ G Ln N r r Z N a) r r O (+ -1 W CD m 4:�b r t71 l0 D W W W W 77 O O Cn CJ) N W W N V "n J (- W c+ m no >f C+ >F (n o x z -47- )F )+ CT Ul Jy -n • O < < C W C-) C7 2 (D (D -S A �-- tO 00 N J:% ? ).- v to r-- 00 0) a) p N (A n .r v V) Vt --i C+ C+ (D 4�:b U1 V Ul N V •A I--) -Pb U1 O's )-•Ul -1 W CT (D (D r n J. J. •. -;N Ul V p W 00 -4 4::�CT M U7 •A OD W —V J -+ N (.0 tO f-' V V t0 m QJ IN O OO .A p N tO Cn tO -P.. O O 0) 0) 0) 0) c+ C+ v nnnnn nn Cl) nnn nnnnn CS C1 J. J, rD a) 0) a) w 0) 0) 0) 0) 0) w 0) 0) a) co of 0) Vi O O 'S N N (A N V) V) N V) N L) fn N V) V1 V) N J• O :5 V1 rD (D (D (D rD rD rD CD (D (D (D rD (D (D rD rD S L) V) O V) V1 N V) V) U) N V) V) N N V) N N V) V) n 0) J VI (A N L) W V) N (A N V) (n V) N N V) V) C to rD rD - ' C C C C C C C C C C C C C C C C 0- (D V) rD (D (D (D (D rD (D rD rD rD (D rD rD rD (D rD N OD C -5 Z -S Z Z -5 Z -5 Z 'S -5 Z -5 Z Z -5 U1 O O -5 < < < < < < < < < < < < < < < < -h G J. J. J. J. J. J. J• J. J. J. J. J. J. J. J. J. J• (-+ C+ C+ (D N N V) V) V) V) (A H N V) V1 N V) N V) V1 -5 O S S tC (D rD rD rD (D rD rD (D (D rD (D (D rD (D (D (D V) "CS .F O C1 C1 Ca. C1 C1. C1 CL C1. C1 C1 0. C1 C1 fl. C1. Q C+ C7) -h a)-0) 0) W W sv W ¢ ry fl) 0) Q) O NO C+ C+ c+ c+ C+ C+ r+ C+ C+ C+ C+ C+ r+ C+ C+ C+ J• C) (+ nnn nn nnnn nnnnn (D ((DD (n in =r a) a) a) a) 0) a) a) a) 0) a 0) a) a) 0) a) 0) C (D N V) V) V) V) N V) (A (A VI N 0 N N V) V) C7 "O 0) "5 (D (D (D (D rD (D (D (D rD rD (D (D (D (D rD rD C O (D (n J J J J J J H-A -10 I VI a) 0 0 0 0 0 00 0000 0 0 0 0 0 C) C J• (D a) (L a) 0) a) 0) 0) 0) 0) 0) 0) CL CL (L a) 0) : V J. to "O C1 Q Q 0. O. Q- Q C1 Cl CL 0. Q CZ Ca. C1 0- S V) a) N V) (A V) (n (A V) V) N N V) (A N V) N to J• CT O C1 C+ 00000 00 0000 00000 = O a -h -h -h -+) -h '-h -h -h -+) -h -h -h -h fi -h -h 7r c+ (D w (D n O -Pb tO )-- N W W W 1-1 U7 CTI � )✓ Ut Co N -5 C1 0) C+ .Pr-+ . .. N l0C) C ) Nmm A I--' 4�:-Olfl (D V) r-•y (n F--• V W tO -P 1D CTI •P U1 OD )-' V n rD O • C3 V CD -0 _0 '0 CT a) -' < rD -0 V V-0 -0 -0 _0 (D T7 _0 rD -0 -0 (D -0 a) N O rD (D (D (D rD (D -5 (D CD 'S (D (D 'S (D (D 0) V) -S 'o _0 Z -5 Z 'S 'S Z -5 Z Z 7r --' -+ � C) "S Z C7 C7 u C7 -0 C7 d C7 C7 "0 CD C1 (L •M LO p -a -0 'v 'v -0 O -v -0 O 'v -0 Q -0 C1 0) • CD 7C7p CD C) O p0 CDC) - C) -+• Vt -v p O C CD O C7 (n L "d rD a) • O C1 (n n V) (y J• V) (D J (D O Q w Q 1,y V) O O D -h CL C J C+ p C) •. O N C) C:) O -48- (D t1 t1 0) 0) 0) 0 r -TI -5O 'S 0 O C-) < Ll1 N (D 0) :3 C 3 �1 v7 N �5 to D ((D Z n C7 C+ •S (D -+• CD (a O Cr C (D O : O 0_ (D 0) O 0 (L C+ (D O C+ 0) N CLO V1 RC+� O O N S C V) \ 4t:- t + O CD 00 W (•n m t.0 O \ n n C-) -s 00 W 0) r+ V) (D H (.7 t) a to n t✓ Z �-' �-' F+ i-' �-' tJ N N (D C O \ N 00 Cn tT 00 O -Pb O Cn N N r- -0 D OD � tJt 3 C+ O O J. -0 co O O ;a D (n W H n O O Z rri Z Z 00 m W 01% 41% 00 N N Z A 7C 3 D D lO CTi cTi D tT C-) 'S Ni(Z) to c+ D m (D Z CD H D z C7 H 0) N n to to m Z Z i-' N W N W Ul N N N (D rt N W t7l V V Ol O O V N t0 n n \m 00 W N W N 3 w O c+ O C �O S N Z Z A W Z Z N Z Z Z N 3 N v, O C+ D n D D D D D W N C N N Z Z N Z Z Z 3 (D n > rn o < J. LA • D 30 r crt D 00 D > D cn z t— m (D tT (D J -49- ' CLn N N N N O r -n D C') (D w pF sL nF a 5 0 -1 o O O 0 O 0 < sv N rD n+ O c a 3 -n W Z ca D LA (D -5 c-) FF FE 0) s rD N (D O 0. 0) O (L C) C+ Ol S (D t0 SL C F-4 N •--' (D : O 0 Q (D C7 0 O AF O 0 AF c+ (D - O �+ < C J• 'S O (D ut (D N Vf CL Vf C+ N C'1 n .�• SL c t(D O O J. • O co • Di r+ D J.rD J. 0 Vf Cil 00 N V F-• 00 l0 00 1� 00 4::b 4::- VF C N w w w w O < O O co O tD N W N W W -Pb 00 -P. N -a OF O tTF O V UD V I.- Cil 00 W V W (D -+ O -' V W 00 W 4tb 4�::- tD 00 -ob -P�- C+ F--+ I J. VF O C+ C � • O 'T (A c+(D —lf < O C rD Z V) N y J. (D F-' N W F + r-+ Ul f-' W �-' C+t0 N'O M V J• C AF 1.- LI) lD tD V W V O V O Lo 'O Z O 00 N W Ln Mr V 0) Cil N GF '0 rD C+ O lD V N N W 4t:l, N V O O c+ rD Z 3 ". C+ < rD 0 . J. O N C+ VF Cr co N C D O C —I N z O (� n C C, V1 N W N FJ N N N W 00 t-+ W VF rD < m 0 (D V rD -s (D m i--• O W N W V lD tp N Cil -0 -0 O 00 N Cil O 00 N F.- FJ 00 -P Cl t0 O —+• J• m D 0) N rn 00 00 V 0o to Ul O cn O 0) (n O ;o 0_ 0_ J• rD co —i O D 3 •r —i m «-+ z -v z o C� vi C N m �+ < O � o ut W V Cn V 00 m Ln Ln W 00 -P -O C ;a VF 00 O O CD F-' A i-' 00 •.� 00 v t0 -0 O F- + 3 J• -S VF n Dr. ca to W o m z o 0- N C-) (D 0) : * m a. C+ O CC) p C� C C m < 3 N (D O O 0 F-•� J. N F-' F•-' N F'-' 1--• F--• N N N F--• I--• C-+ r-• Ln Lrl to 4::- Cn 00 F-• 1-+ m v 1-• ? < rD (D N O I1 CS1 W F-� V1 D � v O N nC D SL -o < Vi (D (D O tD (.il -P O 00 C71 to Ln 00 V Cil rD "5 Z O W Cn 00 O N N N O ILn O l0 -+ < Ai O -.(M O rD 0• J. 0 Ln T SU W 4�b N N A W Cil O0 Z V .L,- .lA 0) -i)--A F� W V tD Na W O N n N W 101+ --h O + . FJ N C7 !J l0 N CS1 F-' F--+ lD U7 O C+ CD -I 'S O —+ D x o m z x- v -50- ATTACHMENT 2 SUMMARY OF PERFORMANCE DATA FOR THE SOCIAL SERVICES DEPARTMENT Intake Actions Per Eligibility Worker This indicator measures the monthly degree of eligibility determina- tions for grants per worker in each of the counties surveyed. As such, it measures the relative workload per intake worker in the areas of AFDC, Food Stamps and Medi-Cal. The data reveals Contra Costa county placed in the top, middle and bottom groups in the three areas surveyed. Of the 13 counties listed, Contra Costa was the twelfth highest in intake actions for AFDC, Number 3 for Medi-Cal and Number 6 in Food Stamps for the time period indicated. Continuing Cases Per Eligibility Worker This indicator basically reflects the monthly caseload handled by a eligibility worker to maintain a grant. Of the 13 counties listed, Contra Costa ranked tenth highest in AFDC caseloads, Number 7 in Food Stamps and Number 1 in Medi-Cal for the time period indicated. Again, these data reflect mixed results in relationships to other counties. Dollar Error Rates This indicator measures the quality of work performed in terms of the amount of dollar errors committed while processing applications. Relative to the other counties, Contra Costa experienced very low error rates in two of three program areas. Of the 13 counties sur- veyed, Contra Costa ranked Number 4 in AFDC, Number 9 in Food Stamps and Number 2 in Medi-Cal for the time period indicated. -51- Y C to U1 (n to W M �O O ri ni n > n n (D Pi P► P) P) P) P) Fl- K O K O F- O O H ::% 0 ::S. :� 0 :J 0 C P) to (D 0 P) :j > rt rt K (D ::I Ul rt �l rt to r- a 3 ro 0 to P) K 4 3:o 0 K (D rt K t-+ K P, K r• (D 3 U) (D O W a tri a F- m a Q a A. (D 0 a � o a o 0 0 a rt (D F- O m F' N K • K O (D U) P) m a (n rt rt n N Pi fv o : OD O O 00 a) rt H N h-' N J F-' ro 'C p U, W M J O O 00 v O lD U'i J F-' 0o J O H oD to J ko Oo Ln J O J W al m ko W W Ln .P OD N Ow .P . % . a Ul w N N .a OD lQ D 00 , O J .A 00 rt O O o 0 0 0 0 0 0 0 0 0 o F,• O Co o 0 0 0 0 0 0 0 0 0 0 O N W N NJ N W N In N W W N N C4 ro >'H > J F' W M 00 J 00 N J .P .P al 00 P) (D n ::1 N . � Krtrt d O lTi J Q\ O I-' a1 I ' OG J W O lJ, N P) rJ W 1✓ Fl J W .p a% .p N H J •I til O .Pv 3 � a (D ro a cn tai K x1 ro O [F- W t1i H N F-' F- 1-' F- FJ F' F- H H N F� F- C., ro n n z - Cn W ,p .p .R .P W Ln N lI J A�- M P) (D P) O d H %D (n %D In W N %D O 00 al W Ln .7 K U) H .F W Ul �o O W l0 al F-' .0 OD 'N la •1 til U) N• > a) m J .t, In N J .p J oo O HO H a s✓ O F- 00 u, to H W W .t. N N N Nv N F- N W OiARO En O �(] F✓ N �o .P O al In 00 OD Oo U, W OD rt tri n o\o K Fl- P) O N 1-' K U) OD ;a (D i rt C 3 N 1 P) 0 K -(D in [F- - (D 10ort n . t —52— C cn U) va v) cn O r ro 0 > r) � m w a w w a a r n o n 0 0 0 rt w 3 ' d tz� w n w > 0 n (D rt n i r n w n r- (D �3 (n (D �3 o Pi a w t1i w F�� (DD( 0 w 0 0 R. ( (D D 0 w C) SD n ° N•° n o ° (D u °, P) m a In rt rt 0 r- a a 0 ° ° o 00 rn � rt Fl N N N J H ro K 0 Ln w m J O O m O w to J H �] OD J O F-A OD Ul J %�D OD In J O J O w m O\ %o W w U1 bP oD N O w pt. F� O P) 0 In kD N N bP 0D kD co ,p O J *P 00 rt O O O O O O Co O O O O O O P. U) O O O Co O O O O O O O O O O H ro tJ F-' I ' F-' F✓ ro J tD J O H W H O In Ui Co W 00 G ro > H tri .P F-' rte. O w In N w W U7 W Ol w w (D 0 ",.7' Zd . n rtrt ni N 01 N N �D J N W W lD 01 J 01 P. w O %D H U7 H lD N F-j U7 N %D lD kD .P •1 [11 0 tv a (n ti l7 N H [(L)n D z oe H f') H N N W N N N N N H W P N W C-4 ro C 1 O H 00 N O W Ul OD H I'D N W Ul H w (D w 0 5a �D ,P w (n W W W W OD H J H O :j " (n �:% U) . (D rt _ Do ;n Do ,P 01 00 N J ;P J Wil, O N •1 m W P. �] J lD oo Ql �P O N 00 J OD Ol O x : z a G O ]t r z �J i > E LOHW (1)HU) y C1 N H H F-i F- N Fl O fA PO C2i U) N m dl1-' I-' O W U" 00 Ol F ' �D n O . w rt m 0 J �] �] F_ W O OD O �] OD OD . " r• off° fS w O H F� fi w U) OTO (D .P w n 1 rt C 3 N r. w 0 L()C)F- rt -53- > C to to to to to to O r m 0 > n .• (D a w a a w a n O n o l- o O H O 0 0 :� a 0 0 0 w N z � �D cwt rt w 3 17i C w 01 n w > a n 0 rt n K Fr• (D cn (D 0 0 a a a t7i a r) rt a (D n (D H- a • (D fr (D :3 w 0 :3 ao N C2 n N IaO-S P. O Fi O mm N UI rt a 0 a W N O 00 M O 0 � F..- O rn C rt m �C U) N N F-•` N J N ro P) o C In w m J O O OD J O w w J 1-r Q1 OD J O 1--` w In J %D w In J O J G Fr tD On m %D w W In .P OD N O w .P F-' . . . . . . . . ¢1 a to %D tv N .p OD 00 .c O J .l- 00 rt tr O Cl O O O O %D O O O O O O P- 1--i Co o 0 0 0 0 0 0 0 0 Co 0 0 0 (D o 3 d H 1 r) 0) J Oj OD M In Vi rn N In to J ON Ca ro > H Y F-A to OD .p J J w M M Ln rn W Orn a (D 0 p ty DD N W Ou .0 O 1-r • F'• W b w 00 O O N w F•r In F-• In W J Co 1 m O ;' ti] 3 E O (D Pd a m ►� n o [F' W OD CEJ H z d H - f7 d= w w N w N .p N .p C a rola (7 H OD J \D N it. O w w w w m iU (D 10) O 0 m m w N m m O O W 1"i O :3 'j • !D rt En w W In J OD Qn O N •1 M U1 Fr- OD N m w In W OD Ln w I.- O In m3 � a c n[LCno U1O 0 N a r to (D N L4 FflFi O O z O. F-' N J Ln N O N O N (7 C Fr- w y ow ri fD O to H Ft UD _ d OD �U tD W a b >F rt rt fD -54- ATTACHMENT 2 SUMMARY OF PERFORMANCE DATA FOR THE HEALTH DEPARTMENT The Health Department has had no success in receiving comparable data from other counties. As a result, the Department has submitted historical data comparing performance over various time periods. The Department will continue to survey othercounties for comparable data. The data submitted covers the last five months of 1985 and includes the application of productive hours and paid hours to clinic; hospital; acute mental health; medical staff; alcohol, drug abuse and mental health; and detention operations. Productive hours are the hours spent on the job exclusive of sick leave, vacations and personal leaves. Paid hours refers to the number of hours employees have been compensated in a given program. Few discernible trends can be gleaned from the five month reporting period. However, the following patterns are worthy of note: 1. Total productive hours for acute mental health and medical staff are on the increase; and 2. Total paid hours for medical staff are on the increase. -55- CONTRA COSTA COUNTY HEALTH SERVICES DEPARTMENT To: Tony Enea Date: January 24, 1986 From: Paul I ngel s Subject: Productivity Indicators Sorry it took so long for me to get this to you. Considerable time was spent attempting to provide prior year comparable data for EFI. Because of the conversion, new payroll reports developed for 1985/86 and a number of other reasons, I have been unable to do so. For EFI , I have attached a number of the comparative monthly graphs and figures we use internally to access impacts of changes in volume. The diverse nature of health care delivery necessitates we measure activity with a number of different factors. Figures for Public Health are also attached. I 've also attached a sheet which shows both productive and non-productive hours per unit of service. Public Health and Environmental Health have both been working on obtaining comparative data from other counties. To date they have had no success. I 'll keep you posted. As I indicated to you Wednesday, this submission represents our first attempt, on relatively short notice, to provide you the data you wish to see. I 'm sure refinements will be needed over time. Feel free to give me a call should you have any questions. PI/dc Attachments (11)PI —56— A-41 8/81 m D> C-+;o D C7 C=) O C7 --1• r -�C C C'7 S C7 C) mCO M0." CO N N x t ;:o N C-) m N m 3 r > v cS v z A m p 0 m O mC C z m N -v N m -n 3 70 m H m n --i z m z r H z H Z m z m -n D H N H � •-� n -< m C r z N Z H H Q C7 n N N 1--' 00 C O N O N Ch C N O N V CD CD 00 C1 N O CD 3 m o � v �-• m S W N N • • —� C N L" W 00 m z N I-� O 4P 00 3 H .� W —I m corD T CJn N o m o � � C H C-) C+ 3 m o o -� C+ o C+ C1 � N O C7o s v w N ko m m ►-� \ .� co a cn C) N O t.0 C m V N CT co Do m \ 00 cn m N UD n M N 00 V 3 00 is co p 00 m co Ln -57- 1985 >o f C 00 4 f i rn iODp l z O C c / Frl C z m ° s mC i /u m , ` � 1 b 00 a rnC n f � t ! } -58- E 1985 D t 00 < i o ul (AT o D o v I C c `Q � � D -0 00 M0 � o no - t C r c f Ti C 1 � fel 1 I i MMo 0 W M .- 0 l t -59- HOURS J V J J -6 O N W .i* N 0! V m 0 O 0 O 0 0 0 00 00 00 0 0 0 } 0 0 0 O O 0 0 0 0 O 0 1� 1 > ! t C I o > Q > cCn .� � C f W -i D =� m T 1 00 U) �i o o C ! v 0 m 0 J r -0 Z -i o < T D n Q D o m c / o X / c oo C / N m fel 7OD cn M 1 \ C i i td ° ! M ; C t i -60- HOURS I 0 t®J� t�J N O Ell N0 0 O O O 0 0 0 0 O O O O 0 {{{ O O 0 0 O 0 0 0 0 0 O l � d i C C c cn � Y 1 I \ J F `n c \ T -u > \ bo � F 1 rn _ 1 I /p r i ! / � K c aJ C E 1 Z / .— < \ 00 R \ cn I o f M > > C 1 I 3 t -61- , HOURS N N W W �►. O to O U O W O O 0 0 0 0 0 0 0 0 i D r D f > fc I � D J c I c � o I U) rTl T0 OD D Cil • 0 r 0 D 0i �j , z / 0 mO I z / c i K 0 / ;o 4 c cn s } 0 -- < co 1 \ OD Cil I � \ 1 , rTi C 4 -62- HOURS 0 0 01 o cis o o 0 0 0 0 0 °o 1 d � o NY � rri o OD Cf01 ) o r o ° --� / w c cZ c Y z f < \ 00 ! 01m Z ' O tr c a �u i 4 -63- • Y 2_r`l 0 1 7,4/ � rPOSITION ADJUSTMENT REQUEST No. D ..rr Date: Dept. No./ R 43 }! ` Copers Department Auditor—Controller Budget Unit o. 01 Org.J No. 1004 Agency No. 10 Action Requested: Add four 40/40 Account Clerk positions in the Auditor— Controller' s Office. Proposed Effective Date: Explain why adjustment is needed: To process enrollments of the supplemental propert tax and maintain the supplemental roll. Classification Questionnaire attached: Yes No Estimated cost of adjustment: $ 16,850 Cost is within department's budget: Yes [] No If not within budget, use reverse side to explain how costs are to be fun d Department must initiate necessary appropriation adjustment, r� Use additional sheets for further explanations or comments. for a rtment d Personnel Department Recommendation Date: January 23, 1986 Classify four (4) 40/40 Account Clerk-Beginning Level positions at the Basic Salary Level eF C5-/0;)j Amend Resolution 71/17 establishing positions and resolutions allocating classes to the Basic/Exempt Salary Schedule, as described above. Effective: O�ay following Board action. Date for Direct of Personnel County Administrator Recommendation Date: I�23/2�6 prove Recommendation of Director of Personnel Disapprove Recommendation of Director of Personnel Other: for County Administrator bard of Supervisors Action FEB 4 1986 Phil Batchelor, Clerk of the Board of adjustment APPROVED/ on Supervisors and County Administrator late: kdr _FEB 41986 By: PPROVAL OF THIS ADJUSTMENT CONSTITUTES A PERSONNEL/SALARY RESOLUTION AMENDMENT. 300 (M347) 2/85 1985-1986 costs are to be funded from dollars that have been set aside for salary increases. See Appropriation Adjustment # g t IJ f • f CONTRA COSTA COUNTY APPROPRIATION ADJUSTMENT T/C 27 I. DEPARTMENT OR ORGANIZATION UNIT: ACCOUNT CODING AUDITOR-CONTROLLER 0010 ORGANIZATION SUB-OBJECT 2. OBJECT OF EXPENSE OR FIXED ASSET ITEM DECREAS> INCREASE 1004 1011 Permanent Salaries 12 ,640. 0( 1004 1042 F. I .C.A. 1,000. 0( 1004 1044 Retirement Expense 1, 265 . 0( 1004 1060 Group Insurance 1, 830 . 0( 1004 1063 Unemployment Insurance 65 .0( 1004 1070 workers ' Compensation 50 . 0( 0145 1611 Permanent Salaries 16 , 850 . 00 APPROVED 3. EXPLANATION OF REQUEST AUDITOR-CONTR04ER To fund account clerk positions in the Auditor- ,- i. ' S�N241985 Controller' s Office in the supplemental roll section for the remainder of 1985-86 . COUNTY ADMINISTRATOR U By: r � c� 2A_12� Date /7-2h BOARD OF SUPERVISORS Supervisors Powers,Fanden, YES: Schroder,McPeak,Torlakson NO: rEB 4 1(.34- On ph;' r. -. .. ... ., Board of 4, /y� �J V r"liirliiRlJlratOr eN URE TITL& DATE By: �2 R APPROPRIATION ADJ. JOURNAL NO. (M 129 Rev.4/83') SEE INSTRUCTIONS ON REVERSE SIDE CONTRA COSTA COUNTY APPROPRIATION ADJUSTMENT T/C 2 7 I. DEPARTMENT OR ORGANIZATION UNIT: ACCOUNT CODING Auditor-Controller 0010 ORGANIZATION SUB-OBJECT 2. OBJECT OF EXPENSE OR FIXED ASSET ITEM <ECREAS> INCREASE 0010 1011 Permanent Salaries 12,640. 0( 0010 1042 F. I.C.A. 1, 000. 0( 0010 1044 Retirement Expense 1, 265. 0( 0010 1060 Group Insurance 1, 830 . 0( 0010 1063 Unemployment Insurance 65 . 0( 0010 1070 [corkers' Compensation 50 . 0( 0990 6301 Reserve for Contingency 16 ,850 . 00 0990 6301 Appropriable New Revenue 16, 850 . 0( APPROVED 3. EXPLANATION OF REQUEST AUDIT - NTROLLER To fund account clerk positions in the Auditor- .Z/3/8• Controller' s Office in the supplemental roll ey Auditor- Date section for the remainder of FY 1985-86. COUNTY ADMINISTRATOR By: — ate �3/� BOARD OF SUPERVISORS Supervisors Powers, Fanden, YE S: Schroder,McPeak,Torlaksaa NO: FEB 4' 199 6, On Phi! R-a a�(�r. CterF r,°the Board of �+�:��o�i�i:�lU 1:�i±%:y r.uiiiiCi.°ilydfOr4. SIGNATURE / TITLE DATE By: APPROPRIATION A POO 5152 ADJ. JOURNAL NO. (M 129 Rev.4/83) SEE INSTRUCTIONS ON REVERSE SIDE CONTRA COSTA COUNTY ESTIMATED REVENUE ADJUSTMENT T/C 2 4 ACCOUNT COOING I.DEPARTNENT OR ORGANIZATION UNIT Auditor, Treasurer-Tax Collector, and Assessor ORGANIZATION ACCOUNT 2 REVENUE DESCRIPTION INCREASE <DECREASE> 0010 9608 Supplemental Poll Charges 98,000. 00 0015 9608 Supplemental Roll Charges 111,000 . 00 0016 9608 Supplemental Roll Charges 591,000 . 00 General County Revenue 0005 9895 Miscellaneous Current Services 816 , 850 . 00 APPROVED 3. EXPLANATION OF REQUEST AU01T0 - NTRC�LER Supplemental roll administrative costs can no longer be charged in FY 1985-86. The Revenue B Dote' Sharing trust fund will be billed henceforth for related services . COUNTY ADMINISTRATOR '7 By � Date BOARD OF SUPERVISORS Suoervis^rs Powers,Fanden, YES: Sch,oder,&AcPeak,Torlakson FEB 4 986 NO: Dote of the Board of .Sli @rvis;:suiidCountyAdminiStrator SIO ATURE TITLE DATE By: REVENUE ADJ. R A 0 0 JOURNAL No. (M 8134 IR�v. 11/8I)