Loading...
HomeMy WebLinkAboutBOARD STANDING COMMITTEES - 11062023 - Finance Cte Agenda PktAGENDA CONTRA COSTA COUNTY Finance Committee 11780 San Pablo Avenue, Suite D El Cerrito |190 East 4th Street, Pittsburg | https://cccounty-us.zoom.us/j/863823695 20 | Call in: (888) 278-0254 Conference code: 894519 8:30 AMMonday, November 6, 2023 1.The public may attend this meeting in person at either above location. The public may also attend this meeting remotely via Zoom or call-in. 2.Agenda Items: Items may be taken out of order based on the business of the day and preference of the Committee. 3.Introductions 4.RECEIVE report on Countywide Single Audit for the Fiscal Year ending June 30, 2022 23-762 FY21-22 Single Audit ReportAttachments: 5.RECEIVE report on Capital Projects Updates 23-763 2023 Capital Projects Presentation 2023 Capital Projects Report Attachments: 6.Public comment on any item under the jurisdiction of the Committee and not on this agenda (speakers may be limited to two (2) minutes). 7.The next meeting is currently scheduled for December 4, 2023. 8.Adjourn Page 1 of 2 1 Finance Committee AGENDA November 6, 2023 General Information This meeting provides reasonable accommodations for persons with disabilities planning to attend a the meetings. Contact the staff person listed below at least 72 hours before the meeting. Any disclosable public records related to an open session item on a regular meeting agenda and distributed by the County to a majority of members of the Committee less than 96 hours prior to that meeting are available for public inspection at 1025 Escobar St., 4th Floor, Martinez, during normal business hours. Staff reports related to items on the agenda are also accessible on line at www.co.contra-costa.ca.us. HOW TO PROVIDE PUBLIC COMMENT: Persons who wish to address the Committee during public comment on matters within the jurisdiction of the Committee that are not on the agenda, or who wish to comment with respect to an item on the agenda, may comment in person, via Zoom, or via call-in. Those participating in person should offer comments when invited by the Committee Chair. Those participating via Zoom should indicate they wish to speak by using the “raise your hand” feature in the Zoom app. Those calling in should indicate they wish to speak by pushing *9 on their phones. Public comments generally will be limited to two (2) minutes per speaker. In the interest of facilitating the business of the Board Committee, the total amount of time that a member of the public may use in addressing the Board Committee on all agenda items is 10 minutes. Your patience is appreciated. Public comments may also be submitted to Committee staff before the meeting by email or by voicemail. Comments submitted by email or voicemail will be included in the record of the meeting but will not be read or played aloud during the meeting. Page 2 of 2 2 CONTRA COSTA COUNTY Staff Report 1025 ESCOBAR STREET MARTINEZ, CA 94553 File #:23-762 Agenda Date:11/6/2023 Agenda #:4. FINANCE COMMITTEE Meeting Date: 11/6/23 Subject: Countywide Single Audit for The Fiscal Year Ending June 30, 2022 Submitted For: Bob Campbell, Auditor-Controller Department: Auditor Controller Referral No: N/A Referral Name: Single Audit Review Presenter: Sandi Bewley, Internal Audits Manager Referral History: On November 8, 1999, the Board established a policy and procedure for addressing the annual findings and recommendations of the County's external auditors. The procedure directs that the Board refer the annual Single Audit findings to the Finance Committee, and that the County Administrator make a report to the Finance Committee on the current- and prior-year audit findings and recommendations that identifies what corrective action has been taken or is planned to be taken on each recommendation. Inasmuch as the current year Single Audit report encompasses all unresolved or pending audit issues from prior-year audits, this report responds directly to the current-year Single Audit report (FY ending June 30, 2022). Internal Control Over Financial Reporting. Government Auditing standards require the external auditor to obtain reasonable assurance that the general-purpose financial statements are free of material misstatement. The external auditor found no instances of material misstatement. Internal Control Over Compliance. Government Auditing Standards and OMB Circular A-133 (which is applicable to federal programs) require the external auditor to report on both compliance with and internal controls over the major federal programs carried out by the County. The external auditor found a material weakness in internal control and an instance of noncompliance (Finding 2022-001). Referral Update: FY21-22 Single Audit Finding 2022-001 The external auditor examined the Employment and Human Services Department’s Federal Funding and Transparency Act (FFATA) reporting for the Head Start Cluster for the year ended June 30, 2022 and found that the required FFATA reporting submissions pertaining to subrecipient awards were not made. Passthrough payments to subrecipients subject to FFATA reporting were $6,172,353. Failure to report subawards greater than $30,000 under FFATA is considered noncompliance with the transparency requirement established by the federal government. CONTRA COSTA COUNTY Printed on 11/1/2023Page 1 of 3 powered by Legistar™3 File #:23-762 Agenda Date:11/6/2023 Agenda #:4. Recommendations The Employment and Human Services Department will comply with Appendix A (I)(a) of 2 CFR Part 170 to report each obligating action greater than or equal to $30,000 in Federal funds for a subaward to a non-Federal entity no later than the end of the month following the month in which the obligation was made. When applicable, the Employment and Human Services Department will require that its subrecipient provide their executive total compensation. The Employment and Human Services Department will report the information per 2 CFR 170 Appendix A, and the grant award instructions. The Employment and Human Services Department’s fiscal management will work with fiscal staff to develop a FFATA tracking tool for designated fiscal staff to use to meet the reporting requirement of Head Start. EHSD designated fiscal staff will be trained on the tracking tool and reporting requirement for completeness, accuracy and timeliness in accordance with 2 CFR 170 Appendix A, and the grant award instructions. Finding 2021-001 - Accuracy of the Schedule of Expenditures of Federal Awards Significant Deficiency U.S. Code of Federal Regulations, Title 2, Part 200, section 510(b) Schedule of Expenditures of Federal Awards requires recipients of federal awards to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the entity’s financial statements to accurately reflect federal awards expended and amounts provided to subrecipients for individual federal programs by assistance listing (AL) numbers. During the audit, various misstatements were identified in the County’s SEFA for the year ended June 30, 2021. This was due to the coronavirus pandemic and staffing challenges. In addition to turnover of staff, there was a need to allocate substantial County resources to address public health and safety needs while managing the significant inflow of new federal funds from the Coronavirus Aid, Relief, and Economic Security (CARES) Act. The County subsequently corrected the expenditure amounts reported in its fiscal year 2021 SEFA prior to its issuance. Recommendations The County should reevaluate its process and controls for the preparation of the SEFA to ensure the completeness and accuracy of the SEFA. Considerations may include: ·Providing training or reference materials to personnel responsible for communicating federal expenditures and related information to the Office of the Auditor-Controller, to enhance understanding of SEFA reporting requirements; ·Enhancing reviews by the grant-administering departments prior to submission of program expenditures and related information to the Office of the Auditor-Controller; and CONTRA COSTA COUNTY Printed on 11/1/2023Page 2 of 3 powered by Legistar™4 File #:23-762 Agenda Date:11/6/2023 Agenda #:4. ·Strengthening the review and monitoring functions, such as more detailed analytical reviews and/or reconciliations to supporting documents on a sampled basis. Status:Corrected. Finding 2018-001-Wage Rate Requirements (Significant Deficiency in Internal Control Over Compliance) Highway Planning and Construction (HPC) Program Assistance Listing Number 20.205 Public Works identified procedure and documentation improvements to ensure compliance with the Wage Rate Requirement and that all certified payroll is received prior to the issuance of payment to the contractor. The “checklist” utilized in the review and approval process of invoices will be revised to include certified payroll for both the primary contractor and all subcontractors. Invoices are not approved for payment until the checklist is completed. We have identified two opportunities to include additional notation to the contractor regarding the requirement for certified payroll. A specific notice will be made to the front of the Special Provisions to point out Section 7-1.03K(3) Certified Payroll Records of the Caltrans Standard Specifications to the contractor’s attention, specifying the requirement for weekly certified payroll, including all subcontractors, as part of the invoicing process and prior to any approval for payments. An additional item will be added on the Preconstruction Checklist to the contractor regarding the requirement of certified payroll. As of June 30, 2021, modifications to the forms identified, training for staff, and implementation was still in progress. Implementation, including finalizing updated forms, was completed in September 2019. However, additional staff training, including updating staff procedures manual, and procedure modifications were identified to ensure implementation of corrective action. In November 2021, corrective action included updating contract language to incorporate a note to the Special Notices section of the Special Provisions, updating the staff procedures manual, and annual training of project managers and resident engineers. Also, additional documentation is required for subcontractors and a 10% deduction for an omission of a certified payroll report to ensure implementation of corrective action. Status:Corrected,as of June 30, 2022 Recommendation(s)/Next Step(s): Accept attached report regarding the Countywide Single Audit for the Fiscal Year Ending June 30, 2022. Fiscal Impact (if any): Not applicable. CONTRA COSTA COUNTY Printed on 11/1/2023Page 3 of 3 powered by Legistar™5 COUNTY OF CONTRA COSTA, CALIFORNIA Single Audit Reports For the Year Ended June 30, 2022 6 COUNTY OF CONTRA COSTA, CALIFORNIA Single Audit Reports For the Year Ended June 30, 2022 Table of Contents Page Independent Auditor’s Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance With Government Auditing Standards ......................................................... 1 Independent Auditor’s Report on Compliance for Each Major Federal Program; Report on Internal Control Over Compliance; Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance; Schedule of Expenditures of Federal and State Awards Provided by the California Department of Aging; Schedule of Child Nutritional Program Revenues; and Schedules of Revenue and Expenditures Provided by the California Department of Community Services and Development ......................................................................... 3 Schedule of Expenditures of Federal Awards ............................................................................................... 7 Notes to the Schedule of Expenditures of Federal Awards ......................................................................... 13 Schedule of Findings and Questioned Costs ............................................................................................... 16 Supplemental Schedules: Schedule of Expenditures of Federal and State Awards Provided by the California Department of Aging .......................................................................... 19 Schedule of Child Nutritional Program Revenues ............................................................................... 20 Schedules of Revenue and Expenditures Provided by the California Department of Community Services and Development ............................................... 21 Corrective Action Plan ................................................................................................................................ 37 Summary Schedule of Prior Year Findings ................................................................................................ 38 7 www.mgocpa.com Macias Gini & O’Connell LLP 2121 N. California Boulevard, Suite 750 Walnut Creek, CA 94596 1 Independent Auditor’s Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance With Government Auditing Standards To the Board of Supervisors of the County of Contra Costa Martinez, California We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States (Government Auditing Standards), the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the County of Contra Costa, California (County), as of and for the year ended June 30, 2022, and the related notes to the financial statements, which collectively comprise the County’s basic financial statements, and have issued our report thereon dated January 27, 2023. Our report includes an emphasis of matter paragraph regarding the County’s adoption of Governmental Accounting Standards Board Statement No. 87, Leases. Our report includes a reference to other auditors who audited the financial statements of the First 5 Contra Costa Children and Families Commission, the Housing Authority of the County of Contra Costa, and the Contra Costa County Employees’ Retirement Association, as described in our report on the County’s financial statements. This report does not include the results of the other auditors’ testing of internal control over financial reporting or compliance and other matters that are reported on separately by those auditors. Report on Internal Control Over Financial Reporting In planning and performing our audit of the financial statements, we considered the County’s internal control over financial reporting (internal control) as a basis for designing audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the County’s internal control. Accordingly, we do not express an opinion on the effectiveness of the County’s internal control. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected, on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or significant deficiencies. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. However, material weaknesses or significant deficiencies may exist that were not identified. 8   2 Report on Compliance and Other Matters As part of obtaining reasonable assurance about whether the County’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the financial statements. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. Purpose of This Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose. Walnut Creek, California January 27, 2023 9 www.mgocpa.com Macias Gini & O’Connell LLP 2121 N. California Boulevard, Suite 750 Walnut Creek, CA 94596   3 Independent Auditor’s Report on Compliance for Each Major Federal Program; Report on Internal Control Over Compliance; Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance; Schedule of Expenditures of Federal and State Awards Provided by the California Department of Aging; Schedule of Child Nutritional Program Revenues; and Schedules of Revenue and Expenditures Provided by the California Department of Community Services and Development To the Board of Supervisors of the County of Contra Costa Martinez, California Report on Compliance for Each Major Federal Program Opinion on Each Major Federal Program We have audited the County of Contra Costa’s, California (County), compliance with the types of compliance requirements identified as subject to audit in the OMB Compliance Supplement that could have a direct and material effect on each of the County’s major federal programs for the year ended June 30, 2022. The County’s major federal programs are identified in the summary of auditor’s results section of the accompanying schedule of findings and questioned costs. In our opinion, the County complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on each of its major federal programs for the year ended June 30, 2022. Basis for Opinion on Each Major Federal Program We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America (GAAS); the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States (Government Auditing Standards); and the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Our responsibilities under those standards and the Uniform Guidance are further described in the Auditor’s Responsibilities for the Audit of Compliance section of our report. We are required to be independent of the County and to meet our other ethical responsibilities, in accordance with relevant ethical requirements relating to our audit. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our opinion on compliance for each major federal program. Our audit does not provide a legal determination of the County’s compliance with the compliance requirements referred to above. Other Matter – Federal Expenditures Not Included in the Compliance Audit The County’s basic financial statements include the operations of the Housing Authority of the County of Contra Costa (Housing Authority), which expended $202,529,755 in federal awards which is not included in the County’s schedule of expenditures of federal awards during the year ended June 30, 2022. Our compliance audit, described in the Opinion on Each Major Federal Program, does not include the operations of the Housing Authority because the Housing Authority engaged other auditors to perform an audit of compliance. 10   4 Responsibilities of Management for Compliance Management is responsible for compliance with the requirements referred to above and for the design, implementation, and maintenance of effective internal control over compliance with the requirements of laws, statutes, regulations, rules and provisions of contracts or grant agreements applicable to the County’s federal programs. Auditor’s Responsibilities for the Audit of Compliance Our objectives are to obtain reasonable assurance about whether material noncompliance with the compliance requirements referred to above occurred, whether due to fraud or error, and express an opinion on the County’s compliance based on our audit. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with GAAS, Government Auditing Standards, and the Uniform Guidance will always detect material noncompliance when it exists. The risk of not detecting material noncompliance resulting from fraud is higher than for that resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Noncompliance with the compliance requirements referred to above is considered material, if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report on compliance about the County’s compliance with the requirements of each major federal program as a whole. In performing an audit in accordance with GAAS, Government Auditing Standards, and the Uniform Guidance, we:  Exercise professional judgment and maintain professional skepticism throughout the audit.  Identify and assess the risks of material noncompliance, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the County’s compliance with the compliance requirements referred to above and performing such other procedures as we considered necessary in the circumstances.  Obtain an understanding of the County’s internal control over compliance relevant to the audit in order to design audit procedures that are appropriate in the circumstances and to test and report on internal control over compliance in accordance with the Uniform Guidance, but not for the purpose of expressing an opinion on the effectiveness of the County’s internal control over compliance. Accordingly, no such opinion is expressed. We are required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit and any significant deficiencies and material weaknesses in internal control over compliance that we identified during the audit. Other Matters The results of our auditing procedures disclosed an instance of noncompliance which is required to be reported in accordance with the Uniform Guidance and which is described in the accompanying schedule of findings and questioned costs as item 2022-001. Our opinion on each major federal program is not modified with respect to this matter. Government Auditing Standards requires the auditor to perform limited procedures on the County’s response to the noncompliance finding identified in our compliance audit described in the accompanying schedule of findings and questioned costs. The County’s response was not subjected to the other auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response. 11 5 Report on Internal Control Over Compliance Our consideration of internal control over compliance was for the limited purpose described in the Auditor’s Responsibilities for the Audit of Compliance section above and was not designed to identify all deficiencies in internal control over compliance that might be material weaknesses or significant deficiencies in internal control over compliance and therefore, material weaknesses or significant deficiencies may exist that were not identified. However, as discussed below, we did identify a deficiency in internal control over compliance that we consider to be a material weakness. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in internal control over compliance, yet important enough to merit attention by those charged with governance. We consider the deficiency in internal control over compliance described in the accompanying schedule of findings and questioned costs as item 2022-001 to be a material weakness. Our audit was not designed for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, no such opinion is expressed. Government Auditing Standards requires the auditor to perform limited procedures on the County’s response to the noncompliance finding identified in our compliance audit described in the accompanying schedule of findings and questioned costs. The County’s response was not subjected to the other auditing procedures applied in the audit of compliance and, accordingly, we express no opinion on the response. The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal control over compliance and the results of that testing based on the requirements of the Uniform Guidance. Accordingly, this report is not suitable for any other purpose. Report on Schedule of Expenditures of Federal Awards Required by the Uniform Guidance; Schedule of Expenditures of Federal and State Awards Provided by the California Department of Aging; Schedule of Child Nutritional Program Revenues; and Schedules of Revenue and Expenditures Provided by the California Department of Community Services and Development We have audited the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the County as of and for the year ended June 30, 2022, and the related notes to the financial statements, which collectively comprise the County’s basic financial statements. We issued our report thereon dated January 27, 2023, which contained unmodified opinions on those financial statements. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the basic financial statements. The accompanying schedule of expenditures of federal awards, schedule of expenditures of federal and state awards provided by the California Department of Aging, schedule of child nutritional program revenues, and schedules of revenue and expenditures provided by the California Department of Community Services and Development (collectively, Supplemental Schedules), as listed in the table of contents, are presented for the purposes of additional analysis as required by the Uniform Guidance and the State of California, respectively, and are not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly 12 6 to the underlying accounting and other records used to prepare the basic financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the Supplemental Schedules are fairly stated in all material respects in relation to the basic financial statements as a whole. Walnut Creek, California March 30, 2023 13 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Expenditures of Federal Awards For the Year Ended June 30, 2022 Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing (AL) Number Grant Identifying Number Federal Expenditures Amount Passed to Subrecipients U.S. Department of Agriculture Supplemental Nutrition Assistance Program (SNAP) Cluster: Passed through State of California Department of Public Health Supplemental Nutrition Assistance Program 10.551 18-10551 167,428$ -$ Supplemental Nutrition Assistance Program 10.551 19-10353 933,844 305,590 Subtotal 1,101,272 305,590 Passed through State of California Department of Aging State Administrative Matching Grants for the Supplemental Nutrition Assistance Program 10.561 SP-2122-07 116,484 95,803 Passed through State of California Department of Social Services State Administrative Matching Grants for the Supplemental Nutrition Assistance Program 10.561 CalFresh Admin CFL 21/22-30, 21/22-49, 21/22-62, 21/22-92, CFET 21/22-100 25,943,464 - Subtotal 26,059,948 95,803 Cluster Subtotal 27,161,220 401,393 Passed through State of California Department of Education Child Nutrition Cluster: National School Lunch Program 10.555 N/A 131,824 - COVID-19 National School Lunch Program 10.555 N/A 7,614 - Cluster Subtotal 139,438 - Child and Adult Care Food Program 10.558 07-1195-1J 515,897 - Passed through State of California Department of Public Health WIC Special Supplemental Nutrition Program for Women, Infants, and Children 10.557 19-10143 A01,A02 & A03 4,641,676 - Passed through State of California Department of Food and Agriculture Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP21PPQFO000C176 71,266 - Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP20PPQFO000C460, AP21PPQFO000C297 280,773 - Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP21PPQFO000C001 235,019 - Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP20PPQFO000C540 10,204 - Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP19PPQFO000C448, AP20PPQFO000C550, AP21PPQFO000C393 194,952 - Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP20PPQFO000C368, AP21PPQFO000C411 11,606 - Plant and Animal Disease, Pest Control, and Animal Care 10.025 AP19PPQFO000C447, AP21PPQFO000C061 1,191,021 - Subtotal 1,994,841 - Total U.S. Department of Agriculture 34,453,072 401,393 U.S. Department of Commerce Direct Program Office for Coastal Management 11.473 N/A 1,400,000 - Total U.S. Department of Commerce 1,400,000 - U.S. Department of Housing and Urban Development Direct Program(s) CDBG - Entitlement Grants Cluster: Community Development Block Grants / Entitlement Grants 14.218 B-16-UC-060002 25,239 25,239 Community Development Block Grants / Entitlement Grants 14.218 B-17-UC-060002 32,327 - Community Development Block Grants / Entitlement Grants 14.218 B-18-UC-060002 1,689,807 114,305 Community Development Block Grants / Entitlement Grants 14.218 B-19-UC-060002 219,987 215,349 Community Development Block Grants / Entitlement Grants 14.218 B-20-UC-060002 412,273 412,273 Community Development Block Grants / Entitlement Grants 14.218 B-21-UC-060002 3,976,655 698,146 COVID-19 Community Development Block Grants / Entitlement Grants 14.218 B-20-UW-060002 934,354 674,555 Cluster Subtotal 7,290,642 2,139,867 Emergency Solutions Grant Program 14.231 E-21-UC-060002 341,870 110,373 Emergency Solutions Grant Program 14.231 E-20-UC-060002 84,560 84,560 COVID-19 Emergency Solutions Grant Program 14.231 E-20-UW-060002 6,766,583 - Subtotal 7,193,013 194,933 Home Investment Partnerships Program 14.239 M-18-DC-060231 1,332 - Home Investment Partnerships Program 14.239 M-19-DC-060231 32,488 - Home Investment Partnerships Program 14.239 M-20-DC-060231 20,413 - Home Investment Partnerships Program 14.239 M-21-DC-060231 323,596 - Home Investment Partnerships Program 14.239 M-21-DP-060231 4,663 - Subtotal 382,492 - Continuum of Care Program 14.267 CA1070L9T052009 175,596 - Continuum of Care Program 14.267 CA0189L9T052012 212,783 - Continuum of Care Program 14.267 CA1651L9T051902 206,612 - Continuum of Care Program 14.267 CA1651L9T052003 385,630 - Continuum of Care Program 14.267 CA1837L9T051900 230,657 - Continuum of Care Program 14.267 CA1921L9T052000 291,018 - Continuum of Care Program 14.267 CA1394L9T052005 403,852 - Continuum of Care Program 14.267 CA1548L9T052004 310,935 - Continuum of Care Program 14.267 CA1548L9T051903 471,124 - Continuum of Care Program 14.267 CA1394L9T051904 214,214 - Continuum of Care Program 14.267 CA1071L9T051907 214,733 201,346 Continuum of Care Program 14.267 CA1071L9T052008 313,335 72,571 Subtotal 3,430,489 273,917 See accompanying notes to the Schedule of Expenditures of Federal Awards. 7 14 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing (AL) Number Grant Identifying Number Federal Expenditures Amount Passed to Subrecipients U.S. Department of Housing and Urban Development (Continued) Passed through State of California Department of Housing and Community Development Emergency Solutions Grant Program 14.231 18-ESG-12333 74,193$ -$ Emergency Solutions Grant Program 14.231 19-ESG-13114 163,306 110,111 Emergency Solutions Grant Program 14.231 20-ESG-15560 65,062 65,062 COVID-19 Emergency Solutions Grant Program 14.231 20-ESGCV1-00006 5,839,810 - Subtotal 6,142,371 175,173 Passed through City of Oakland Housing Opportunities for Persons with AIDS 14.241 CA-H20-F001 152,659 - COVID-19 Housing Opportunities for Persons with AIDS 14.241 CA-H20-FHW001 124,888 - Housing Opportunities for Persons with AIDS 14.241 CA-H21-F001 371,335 284,780 Subtotal 648,882 284,780 Total U.S. Department of Housing and Urban Development 25,087,889 3,068,670 U.S. Department of Justice Direct Program(s) Services for Trafficking Victims 16.320 N/A 101,546 101,546 Services for Trafficking Victims 16.320 2018-VT-BX-K090 236,690 - Subtotal 338,236 101,546 Enhanced Training and Services to End Violence and Abuse of Women Later in Life 16.528 N/A 87,227 57,962 National Institute of Justice Research, Evaluation, and Development Project Grants 16.560 2020-DN-BX-0157 39,880 19,631 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program 16.590 N/A 102,692 102,692 DNA Backlog Reduction Program 16.741 N/A 186,194 - DNA Backlog Reduction Program 16.741 N/A 212,057 - Subtotal 398,251 - Edward Byrne Memorial Justice Assistance Grant Program 16.738 N/A 98,512 65,532 Edward Byrne Memorial Justice Assistance Grant Program 16.738 N/A 49,974 23,137 Edward Byrne Memorial Justice Assistance Grant Program 16.738 N/A 44,339 42,127 Edward Byrne Memorial Justice Assistance Grant Program 16.738 N/A 46,515 44,189 Subtotal 239,340 174,985 Equitable Sharing Program 16.922 N/A 1,034 - Passed through California Board of State and Community Corrections COVID-19 Coronavirus Emergency Supplemental Funding Program 16.034 BSCC 103-200 570,209 312,232 Edward Byrne Memorial Justice Assistance Grant Program 16.738 BSCC 0008-18-MH 62,781 - Edward Byrne Memorial Justice Assistance Grant Program 16.738 BSCC 614-19 766,969 325,842 Subtotal 829,750 325,842 Passed through State of California Office of Emergency Services Crime Victim Assistance 16.575 XC20 03 0070 341,366 126,347 Crime Victim Assistance 16.575 XC21 04 0070 64,027 60,626 Crime Victim Assistance 16.575 XE20 03 0070 167,782 - Crime Victim Assistance 16.575 XE21 04 0070 13,759 - Crime Victim Assistance 16.575 VW20390070 316,769 - Crime Victim Assistance 16.575 VW21400070 700,000 - Crime Victim Assistance 16.575 UV20050070 95,604 - Crime Victim Assistance 16.575 UV2160070 11,573 - Crime Victim Assistance 16.575 HA20030070 74,137 - Crime Victim Assistance 16.575 HA21040070 23,456 - Subtotal 1,808,473 186,973 Paul Coverdell Forensic Sciences Improvement Grant Program 16.742 CQ20160070 66,146 - Paul Coverdell Forensic Sciences Improvement Grant Program 16.742 CQ21170070 7,764 - Subtotal 73,910 - Total U.S. Department of Justice 4,489,002 1,281,863 U.S. Department of Labor Passed through State of California Employment Development Department COVID-19 WIOA National Dislocated Worker Grants/WIA National Emergency Grants 17.277 AA011003 288,205 288,205 Workforce Innovation and Opportunity Act (WIOA) Cluster: WIOA Adult Program 17.258 AA011003 212,502 - WIOA Adult Program 17.258 AA111003 270,842 - WIOA Adult Program 17.258 AA211003 1,444,514 696,933 Subtotal 1,927,858 696,933 WIOA Youth Activities 17.259 AA111003 416,010 190,474 WIOA Youth Activities 17.259 AA211003 1,209,473 825,274 Subtotal 1,625,483 1,015,748 WIOA Dislocated Worker Formula Grants 17.278 AA111003 693,721 105,799 WIOA Dislocated Worker Formula Grants 17.278 AA211003 1,832,827 667,272 Subtotal 2,526,548 773,071 Cluster Subtotal 6,079,889 2,485,752 Total U.S. Department of Labor 6,368,094 2,773,957 See accompanying notes to the Schedule of Expenditures of Federal Awards. 8 15 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing (AL) Number Grant Identifying Number Federal Expenditures Amount Passed to Subrecipients U.S. Department of Transportation Direct Program(s) Airport Improvement Program 20.106 AIP 3-06-0050-030-2021 666,128$ -$ COVID-19 Airport Improvement Program 20.106 AIP 3-06-0050-031-2021 148,000 - Airport Improvement Program 20.106 AIP 3-06-0050-028-2021 3,682,971 - COVID-19 Airport Improvement Program 20.106 AIP 3-06-0008-017-2021 32,000 - Subtotal 4,529,099 - Passed through State of California Department of Transportation Highway Planning and Construction Cluster: Highway Planning and Construction 20.205 BRLS-5928 (125) 418,783 - Highway Planning and Construction 20.205 HSIPL-5928 (156) 779,364 - Highway Planning and Construction 20.205 BRLS-5928 (154) 139,939 - Highway Planning and Construction 20.205 BPMP-5928 (155) 16,121 - Highway Planning and Construction 20.205 HSIPL-5928 (157) 1,152,745 - Highway Planning and Construction 20.205 BRLS-5928 (128) 6,690,267 - Highway Planning and Construction 20.205 ATPL-5928 (136) 2,419,096 - Highway Planning and Construction 20.205 ATPLNI-5928 (147) 46,824 - Highway Planning and Construction 20.205 HSIPL-5928 (140) 136,724 - Highway Planning and Construction 20.205 HSIPL-5928 (143) 13,714 - Highway Planning and Construction 20.205 HSPIL-5928 (142) 1,351 - Highway Planning and Construction 20.205 ATPL-5928 (151) 1,788,455 - Highway Planning and Construction 20.205 ER-32L0 (517) 443,310 - Highway Planning and Construction 20.205 ER-3210 (550) 415,375 - Highway Planning and Construction 20.205 BRLS-5928 (104) 188,136 - Highway Planning and Construction 20.205 CMLNI-5928 (153) 70,988 - Cluster Subtotal 14,721,192 - Passed through State of California Office of Traffic Safety Minimum Penalties for Repeat Offenders for Driving While Intoxicated 20.608 AL21001 76,834 - Minimum Penalties for Repeat Offenders for Driving While Intoxicated 20.608 AL22009 259,303 - Subtotal 336,137 - Highway Safety Cluster: National Priority Safety Programs 20.616 DI21001 21,513 - National Priority Safety Programs 20.616 DI22001 51,184 - National Priority Safety Programs 20.616 OP21003, OP22004 36,370 - Cluster Subtotal 109,067 - Total U.S. Department of Transportation 19,695,495 - U.S. Department of Treasury Direct Program Equitable Sharing 21.016 N/A 4 - COVID-19 Coronavirus State and Local Fiscal Recovery Funds 21.027 N/A 79,214,397 - Passed through State of California Department of Housing and Community Development COVID-19 Emergency Rental Assistance Program 21.023 20-ERAP-00004 469,448 417,600 COVID-19 Emergency Rental Assistance Program 21.023 21-ERAP-10004 134,537 28,692 Subtotal 603,985 446,292 Total U.S. Department of Treasury 79,818,386 446,292 Environmental Protection Agency Direct Program(s) Geographic Programs - San Francisco Bay Water Quality Improvement Fund 66.126 N/A 751,055 - Environmental Justice Government-to-Government (EJG2G) Program 66.312 98T29501-2 30,480 30,480 Total Environmental Protection Agency 781,535 30,480 U.S. Department of Energy Passed through State of California Department of Community Services and Development Weatherization Assistance for Low-Income Persons 81.042 20C-6004 (FY 2021) (15,035) - Weatherization Assistance for Low-Income Persons 81.042 20C-6004 (FY 2022) 35,247 - Total U.S. Department of Energy 20,212 - U.S. Department of Education Passed through State of California Department of Rehabilitation Rehabilitation Services Vocational Rehabilitation Grants to States 84.126 31769 705,374 - Total Department of Education 705,374 - See accompanying notes to the Schedule of Expenditures of Federal Awards. 9 16 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing (AL) Number Grant Identifying Number Federal Expenditures Amount Passed to Subrecipients U.S. Department of Health and Human Services Direct Program(s) Health Center Program Cluster: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care)93.224 6 H80CS00050-20-03 1,667,894$ -$ Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care)93.224 6 H80CS00050-21-01 1,884,134 - COVID-19 Health Center Program (Community Health Centers, Migrant Health Centers, Health Care fo the Homeless, and Public Housing Primary Care)93.224 1H8FCS41183-01-00 1,108,700 - Cluster Subtotal 4,660,728 - COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution 93.498 N/A 1,490,219 - Grants to Provide Outpatient Early Intervention Services with Respect to HIV Disease 93.918 N/A 335,153 54,620 Head Start Cluster: Head Start 93.600 09CH010862-04-02 25,134,216 6,172,353 COVID-19 Head Start 93.600 09HE000903-01-00 280,512 - Cluster Subtotal 25,414,728 6,172,353 Passed through California Health Advocates Special Programs for the Aging, Title IV, and Title II , Discretionary Projects 93.048 90MPPG0019-03-00 6,500 - Passed through State of California Department of Aging Aging Cluster: Special Programs for the Aging, Title VII, Chapter 3, Programs for Prevention of Elder Abuse, Neglect, and Exploitation 93.041 AP-2122-07 14,966 14,966 Special Programs for the Aging, Title VII, Chapter 2, Long Term Care Ombudsman Services for Older Individuals 93.042 AP-2122-07 58,124 58,124 Special Programs for the Aging, Title III, Part D, Disease Prevention and Health Promotion Services 93.043 AP-2122-07 48,049 48,049 Special Programs for the Aging, Title III, Part B, Grants for Supportive Services and Senior Centers 93.044 AP-2122-07 1,044,447 465,733 COVID-19 Special Programs for the Aging, Title III, Part B, Grants for Supportive Services and Senior Centers 93.044 CARES-07 176,802 115,039 Subtotal 1,221,249 580,772 Special Programs for the Aging, Title III, Part C, Nutrition Services 93.045 AP-2122-07 2,119,338 1,292,673 COVID-19 Special Programs for the Aging, Title III, Part C, Nutrition Services 93.045 AP-2122-07 427,469 - COVID-19 Special Programs for the Aging, Title III, Part C, Nutrition Services 93.045 CARES-07 509,964 - Subtotal 3,056,771 1,292,673 National Family Caregiver Support, Title III, Part E 93.052 AP-2122-07 549,620 501,296 COVID-19 National Family Caregiver Support, Title III, Part E 93.052 CARES-07 121,216 38,497 Subtotal 670,836 539,793 Nutrition Services Incentive Program 93.053 AP-2122-07 433,545 - Cluster Subtotal 5,503,540 2,534,377 Medicare Enrollment Assistance Program 93.071 MI-2122-07 35,148 - State Health Insurance Assistance Program 93.324 HI-2122-07 106,050 - Passed through State of California Department of Health and Human Services Temporary Assistance for Needy Families 93.558 N/A 24,315,816 2,166,618 HIV Care Formula Grants 93.917 H18-10866 628,691 45,737 Passed through State of California Department of Social Services Guardianship Assistance 93.090 CFL 11/12-18; CFL 21/22-10 1,649,995 - Community-Based Child Abuse Prevention Grants 93.590 ACIN I-16-22 63,632 - Adoption and Legal Guardianship Incentive Payments 93.603 CFL 21/22-17 142,698 Stephanie Tubbs Jones Child Welfare Services Program 93.645 N/A 554,631 - Foster Care Title IV-E 93.658 CFL 21/22-21, CFL 21/22-83 90,894 - Foster Care Title IV-E 93.658 CFL 11/12-18 6,434,399 61,201 Foster Care Title IV-E 93.658 CFL 21/22-43 13,980 - Foster Care Title IV-E 93.658 N/A 476,618 - Foster Care Title IV-E 93.658 CFL 21/22-45 27,989 - Foster Care Title IV-E 93.658 N/A 31,124 - Foster Care Title IV-E 93.658 CFL 11/12-18, CFL 21/22-60 1,669,415 - Foster Care Title IV-E 93.658 CFL 21/22-45 147,666 - Foster Care Title IV-E 93.658 CFL 21/22-69 275,657 - Foster Care Title IV-E 93.658 CFL 11/12-18, CFL 21/22-60 367,190 44,212 Foster Care Title IV-E 93.658 CFL 20/21-110 98,226 - Foster Care Title IV-E 93.658 CFL 21/22-69 3,760 - Foster Care Title IV-E 93.658 CFL 21/22-28, CFL 21/22-102 599 - Foster Care Title IV-E 93.658 N/A 3,106 - Foster Care Title IV-E 93.658 CFL 21/22-60 3,509,302 - Subtotal 13,149,925 105,413 Adoption Assistance 93.659 CFL 11/12-18 10,519,483 - Adoption Assistance 93.659 N/A 987,880 - Subtotal 11,507,363 - Social Services Block Grant 93.667 N/A 4,694,177 - Social Services Block Grant 93.667 CFL 20/21-60 540,087 - Social Services Block Grant 93.667 CFL 21/22-60 1,231,420 - Social Services Block Grant 93.667 N/A 33,274 - Subtotal 6,498,958 - See accompanying notes to the Schedule of Expenditures of Federal Awards. 10 17 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing (AL) Number Grant Identifying Number Federal Expenditures Amount Passed to Subrecipients U.S. Department of Health and Human Services (Continued) John H. Chafee Foster Care Program for Successful Transition to Adulthood 93.674 CFL 11/12-18; CFL 21/22-40 335,604$ -$ MaryLee Allen Promoting Safe and Stable Families Program 93.556 CFL 21/22-24 10,622 - MaryLee Allen Promoting Safe and Stable Families Program 93.556 CFL 21/22-25 687,822 459,171 Subtotal 698,444 459,171 Temporary Assistance for Needy Families 93.558 N/A 15,593,917 - Temporary Assistance for Needy Families 93.558 CFL 21/22-60 4,697,669 - Subtotal 20,291,586 - Refugee and Entrant Assistance State/Replacement Designee Administered Programs 93.566 N/A 661,298 - Refugee and Entrant Assistance State/Replacement Designee Administered Programs 93.566 21-07-90893-00 72,428 - Refugee and Entrant Assistance State/Replacement Designee Administered Programs 93.566 21-07-90899-00 186,754 - Subtotal 920,480 - Medicaid Cluster: COVID-19 Medical Assistance Program 93.778 CFL 21/22-37 2,208 - Medical Assistance Program 93.778 CFL 21/22-37 1,156,075 - Medical Assistance Program 93.778 N/A 1,716,305 - Medical Assistance Program 93.778 CFL 11/12-18 2,405,746 - Medical Assistance Program 93.778 CFL 21/22-42 10,735,572 - Cluster Subtotal 16,015,906 - Passed through California Department of Health Care Services Projects for Assistance in Transition from Homelessness (PATH)93.150 1X06SM083731-01 143,788 143,788 HIV Prevention Activities Health Department Based 93.940 18-10759 421,557 26,760 National Bioterrorism Hospital Preparedness Program 93.889 17-10150 246,203 - Passed through State of California Department of Child Support Services Child Support Enforcement 93.563 2101CACSES 12,197,264 - Passed through State of California Department of Community Services and Development Low-Income Home Energy Assistance 93.568 20B-2005 (WX) 129 - Low-Income Home Energy Assistance 93.568 20B-2005 (EHA 16) 79,454 - COVID-19 Low-Income Home Energy Assistance 93.568 20U-2554 CARES (EHA 16) 111,563 - Low-Income Home Energy Assistance 93.568 21B-5005 (WX) 592,801 - Low-Income Home Energy Assistance 93.568 21B-5005 (EHA16) 424,243 - Low-Income Home Energy Assistance 93.568 21V-5554 (EHA 16) 419,078 - Low-Income Home Energy Assistance 93.568 22B-4005 (WX) 887,635 - Low-Income Home Energy Assistance 93.568 22B-4005 (EHA 16) 179,776 - Subtotal 2,694,679 - COVID-19 Community Services Block Grant 93.569 20F-3646 633,645 539,128 COVID-19 Community Services Block Grant 93.569 20F-3646 Discretionary 18,695 18,695 Community Services Block Grant 93.569 21F-4007 (FY 2021) 60,420 - Community Services Block Grant 93.569 21F-4007 (FY 2022) 640,291 326,180 Community Services Block Grant 93.569 21F-4408 Discretionary 25,836 23,812 Subtotal 1,378,887 907,815 Passed through State of California Department of Education - Child Development Program CCDF Program Cluster: Child Care and Development Block Grant 93.575 CAPP0010 1,309,874 - Child Care and Development Block Grant 93.575 CAPP1009 1,916,489 - Child Care and Development Block Grant 93.575 C2AP1008 1,206,983 - Child Care and Development Block Grant 93.575 CCTR1028 1,572,038 - Subtotal 6,005,384 - Child Care Mandatory and Matching Funds of the Child Care and Development Fund 93.596 CAPP0010 208,605 - Child Care Mandatory and Matching Funds of the Child Care and Development Fund 93.596 CAPP1009 408,649 - Child Care Mandatory and Matching Funds of the Child Care and Development Fund 93.596 CCTR1028 884,078 - Subtotal 1,501,332 - Cluster Subtotal 7,506,716 - Passed through State of California Department of Public Health Public Health Emergency Preparedness 93.069 17-10150 978,475 - COVID-19 Public Health Emergency Reponses: Cooperative Agreement for Emergency Response: Public Health Crisis Response 93.354 1 NU90TP922174-01-00 99,162 - Project Grants and Cooperative Agreements for Tuberculosis Control Programs 93.116 2107FSIE00 & 2107ADDF00 163,836 - Disabilities Prevention 93.184 29-338-27 697,715 - Substance Abuse and Mental Health Services Projects of Regional and National Significance 93.243 H79T1084555 202,204 - Immunization Cooperative Agreements 93.268 17-10316-A03 388,512 - COVID-19 Immunization Cooperative Agreements 93.268 17-10316-A03 (Round 3) 2,680,576 - COVID-19 Immunization Cooperative Agreements 93.268 17-10316-A03 (Round 4) 2,111,456 - Subtotal 5,180,544 - COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC)93.323 COVID-19 ELC66 13,398,648 - COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC)93.323 COVID-19 ELC08 2,201,872 - Subtotal 15,600,520 - Affordable Care Act (ACA) Maternal, Infant, and Early Childhood Home Visiting Program 93.505 CHVP21-07 919,650 3,950 See accompanying notes to the Schedule of Expenditures of Federal Awards. 11 18 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing (AL) Number Grant Identifying Number Federal Expenditures Amount Passed to Subrecipients U.S. Department of Health and Human Services (Continued) Medicaid Cluster: Medical Assistance Program 93.778 29-338-27 83,855$ -$ Medical Assistance Program 93.778 20-10517 141,654 - Medical Assistance Program 93.778 N/A 6,369,043 - Medical Assistance Program 93.778 MCAC 2020-2101 26,581,526 - Medical Assistance Program 93.778 AGMT 202107 1,001,234 - Cluster Subtotal 34,177,312 - Opioid STR 93.788 19-10752 429,710 76,079 Assistance Prorgrams for Chronic Disease Prevention and Control 93.945 6NU58DP007068-01-01 69,864 19,358 Sexually Transmitted Diseases (STD) Prevention and Control Grants 93.977 21-10550 34,800 - Passed through Heluna Health COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC)93.323 6NU50CK000539-01 234,789 - COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC)93.323 6NU50CK000539-01-08 5,814 5,583 Subtotal 240,603 5,583 Passed through County of Alameda HIV Emergency Relief Project Grants 93.914 H8900018 1,820,895 143,377 Passed through Public Health Foundation Enterprise Inc. Emerging Infections Programs 93.317 65U50CK000482 139,539 - Antimicrobial Resistance Surveillance In Retail Food Specimens 93.876 5UO1FD007141-02 108,040 - Passed through State of California Department of Health Care Services Block Grants for Community Mental Health Services 93.958 1B09SM085337-01 24,458 - Block Grants for Community Mental Health Services 93.958 21-10349 2,036 - COVID-19 Block Grants for Community Mental Health Services 93.958 1B09SM083945-01 26,974 21,007 Block Grants for Community Mental Health Services 93.958 1B09SM085984-01 2,641,286 796,210 Subtotal 2,694,754 817,217 Passed through State of California Department of Alcohol and Drug Programs Block Grants for Prevention and Treatment of Substance Abuse 93.959 07-NNA-07 6,002,314 4,603,743 COVID-19 Block Grants for Prevention and Treatment of Substance Abuse 93.959 07-NNA-07 185,547 137,187 6,187,861 4,740,930 Passed through State of California Department of Public Health Maternal and Child Health Services Block Grant to the States 93.994 AGMT 202107 320,205 8,050 Total U.S. Department of Health and Human Services 228,980,578 18,431,196 U.S. Department of Homeland Security Direct Program(s) Staffing for Adequate Fire and Emergency Response (SAFER)97.083 N/A 410,779 - Staffing for Adequate Fire and Emergency Response (SAFER)97.083 N/A 753,155 - Subtotal 1,163,934 - Passed through State of California Natural Resources Boating Safety Financial Assistance 97.012 C1870614 8,728 - Passed through State of California Office of Emergency Services COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters)97.036 N/A 342,336 - COVID-19 Disaster Grants - Public Assistance (Presidentially Declared Disasters)97.036 N/A 2,805,170 - Subtotal 3,147,506 - Hazard Mitigation Grant 97.039 PJ0146 123,939 - Emergency Management Performance Grants 97.042 2020-0006 140,286 18,000 Emergency Management Performance Grants 97.042 2021-0015 947 - Subtotal 141,233 18,000 Homeland Security Grant Program 97.067 2020-0095 73,700 23,950 Homeland Security Grant Program 97.067 2019-0035 1,014,445 456,471 Passed through City and County of San Francisco Homeland Security Grant Program 97.067 2020-0095 533,398 299,250 Homeland Security Grant Program 97.067 2019-0035 472,991 - Subtotal 2,094,534 779,671 Total U.S. Department of Homeland Security 6,679,874 797,671 Total Expenditures of Federal Awards 408,479,511$ 27,231,522$ See accompanying notes to the Schedule of Expenditures of Federal Awards. 12 19 COUNTY OF CONTRA COSTA, CALIFORNIA Notes to the Schedule of Expenditures of Federal Awards For the Year Ended June 30, 2022 13 1. REPORTING ENTITY The financial reporting entity, as defined by the Governmental Accounting Standards Board (GASB), consists of the primary government, which is the County of Contra Costa, California (County), organizations for which the primary government is financially accountable, and other organizations for which the nature and significance of their relationship with the primary government are such that exclusion would cause the reporting entity’s financial statements to be misleading or incomplete. 2. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A. Basis of Accounting Funds received under the various grant programs have been recorded within the general fund, special revenue funds, capital projects fund, and enterprise funds of the County. The County utilizes the modified accrual method of accounting for the general fund, special revenue funds, and capital projects fund and full accrual basis of accounting for the enterprise funds. The accompanying schedule of expenditures of federal awards (SEFA) is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the SEFA may differ from amounts presented in, or used in, the preparation of the County’s basic financial statements. B. Schedule of Expenditures of Federal Awards The accompanying SEFA presents the activity of all federal financial assistance programs of the County, except for the awards related to the County of Contra Costa Housing Authority (Housing Authority) that conducted a separate single audit in accordance with the Uniform Guidance. Federal financial assistance received directly from federal agencies, as well as any federal financial assistance passed through the State of California and other agencies, is included in the SEFA. The SEFA was prepared from only the accounts of various grant programs and therefore does not present the financial position, changes in fund balances/net position, or results of operations of the County. During the year ended June 30, 2022, adjustments were made relating to prior year expenditures as part of close out report preparation. As a result, Assistance Listing numbers 81.042 and 93.569 have FY 2021 and FY 2022 expenditures. The SEFA also includes the grant identifying number as provided by the federal or pass-through grantors. If no such number was provided, the County denotes “N/A” on the SEFA. C. Loan Programs The County has provided loans under several U.S. Department of Housing and Urban Development programs. These loans are made to carry out activities for affordable housing and economic development. The programs are administered both internally and by servicing and trust arrangements with financial institutions to collect loan repayments. The funds will be returned to the County programs upon repayment of the principal and interest and will be recorded as program income at that time. Loans extended under the Community Development Block Grants/Entitlement Grants (CDBG) and the Home Investment Partnerships Program (HOME) by the County are not considered loans as described in 2 CFR section 200.502(b) Loans and loan guarantees (loans). 20 COUNTY OF CONTRA COSTA, CALIFORNIA Notes to the Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 14 2. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) D. Other Cluster Designated by the State of California The SEFA includes the State-designated Aging Cluster, which is different than Part 5 of the 2022 OMB Compliance Supplement, as permitted by the Uniform Guidance in 2 CFR 200.1. The State-designated Aging Cluster includes Assistance Listing numbers 93.041, 93.042, 93.043, 93.044, 93.045, 93.052, and 93.053. 3. SUMMARY OF FEDERAL EXPENDITURES OF THE HOUSING AUTHORITY The Housing Authority’s federal expenditures are excluded from the accompanying SEFA because they are separately audited by other auditors. Expenditures of federal awards of the Housing Authority for the fiscal year ended March 31, 2022, were as follows: 4. INDIRECT COSTS The County did not elect to use the 10% de minimis cost rate as covered in 2 CFR section 200.414 Indirect (F&A) costs, with the exception of the Health Services Department’s Continuum of Care Program (Assistance Listing number 14.267). Federal Grantor Assistance Listing Number Federal Expenditures Department of Housing and Urban Development (HUD): Housing Choice Voucher Cluster Section 8 Housing Choice Vouchers 14.871 182,505,842$ Mainstream Vouchers 14.879 2,697,523 Emergency Housing Vouchers 14.EHV 91,750 Total Housing Voucher Cluster 185,295,115 Continuum of Care Program 14.267 6,795,102 Public and Indian Housing 14.850 7,226,695 Public Housing Capital Fund Program 14.872 3,032,366 Family Self Sufficiency Program 14.896 180,477 Total expenditures of federal awards 202,529,755$ 21 COUNTY OF CONTRA COSTA, CALIFORNIA Notes to the Schedule of Expenditures of Federal Awards (Continued) For the Year Ended June 30, 2022 15 5. PROGRAM TOTALS The following table summarizes programs funded by various sources or grants whose totals are not shown on the SEFA. Federal Grantor/ Pass-Through Entity/ Federal Program Title Assistance Listing Number Federal Expenditures Emergency Solutions Grant Program Direct from U.S. Department of Housing and Urban Development 14.231 426,430$ Direct from U.S. Department of Housing and Urban Development (COVID-19)14.231 6,766,583 Passed through State of California Department of Housing and Community Development 14.231 302,561 Passed through State of California Departmnet of Housing and Community Development (COVID-19)14.231 5,839,810 Total Emergency Solutions Grant Program 13,335,384$ Edward Byrne Memorial Justice Assistance Grant Program Direct from U.S. Department of Justice 16.738 239,340$ Passed through California Board of State and Community Corrections 16.738 829,750 Total Edward Byrne Memorial Justice Assistance Grant Program 1,069,090$ COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Passed through State of California Department Public Health 93.323 15,600,520$ Passed through Heluna Health 93.323 240,603 Total COVID-19 ELC 15,841,123$ Temporary Assistance for Needy Families Passed through State of California Department of Health and Human Services 93.558 24,315,816$ Passed through State of California Department of Social Service s 93.558 20,291,586 Total Temporary Assistance for Needy Families 44,607,402$ Medicaid Cluster Medical Assistance Program: Passed through State of California Department of Social Service s 93.778 16,013,698$ Passed through State of California Department of Social Service s (COVID-19)93.778 2,208 Passed through State of California Department of Public Health 93.778 34,177,312 Total Medical Assistance Program 50,193,218$ 22 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Findings and Questioned Costs For the Year Ended June 30, 2022 16 Section I Summary of Audit Results Financial Statements: Type of auditor’s report issued on whether the financial statements audited were prepared in accordance with GAAP: Unmodified Internal control over financial reporting:  Material weakness(es) identified? No  Significant deficiency(ies) identified ? None reported Noncompliance material to financial statements noted? No Federal Awards: Internal control over major programs:  Material weakness(es) identified? Yes  Significant deficiency(ies) identified? None reported Type of auditor’s report issued on compliance with major federal programs: Unmodified Any audit findings disclosed that are required to be reported in accordance with section 2 CFR 200.516(a)? Yes Identification of major programs: Assistance Listing Name of Federal Program or Cluster Number(s) (1) Emergency Solutions Grant Program .............................................. 14.231 (2) Continuum of Care Program ........................................................... 14.267 (3) Workforce Innovation and Opportunity Act (WIOA) Cluster: WIOA Adult Program ..................................................................... 17.258 WIOA Youth Activities ................................................................... 17.259 WIOA Dislocated Worker Formula Grants ..................................... 17.278 (4) Coronavirus State and Local Fiscal Recovery Funds ...................... 21.027 (5) Aging Cluster: Special Programs for the Aging, Title VII, Chapter 3, Programs for Prevention of Elder Abuse, Neglect, and Exploitation ........... 93.041 Special Programs for the Aging, Title VII, Chapter 2, Long Term Care Ombudsman Services for Older Individuals ............... 93.042 Special Programs for the Aging, Title III, Part D, Disease Prevention and Health Promotion Services .................................. 93.043 Special Programs for the Aging, Title III, Part B, Grants for Supportive Services and Senior Centers ....................................... 93.044 23 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Findings and Questioned Costs For the Year Ended June 30, 2022 17 Special Programs for the Aging, Title III, Part C, Nutrition Services ......................................................................................... 93.045 National Family Caregiver Support, Title III, Part E ...................... 93.052 Nutrition Services Incentive Program ............................................. 93.053 (6) Immunization Cooperative Agreements .......................................... 93.268 (7) Head Start Cluster ............................................................................ 93.600 (8) Foster Care Tilte IV-E ..................................................................... 93.658 (9) Adoption Assistance ........................................................................ 93.659 (10) Block Grants for Prevention and Treatment of Substance Abuse ... 93.959 Dollar threshold used to distinguish between type A and type B programs: $3,000,000 Auditee qualified as low-risk auditee? Yes Section II Financial Statement Findings None reported. Section III Federal Award Findings and Questioned Costs Reference Number: 2022-001 Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Head Start Cluster Assistance Listing Number: 93.600 Federal Award Numbers: 09CH010862-04-02 and 09HE000903-01-00 Category of Finding: Reporting Type of Finding: Material Weakness in Internal Control over Compliance and Instance of Noncompliance Criteria Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter I – Office of Management and Budget Government-wide Guidance for Grants and Agreements. Part 170 – Reporting Subaward and Executive Compensation Information, Appendix A to Part 170, Section I(a) (a) Reporting of first-tier subawards. 1. Applicability. Unless you are exempt as provided in paragraph d. of this award term, you must report each action that equals or exceeds $30,000 in Federal funds for a subaward to a non-Federal entity or Federal agency. 24 COUNTY OF CONTRA COSTA, CALIFORNIA Schedule of Findings and Questioned Costs For the Year Ended June 30, 2022 18 2. Where and when to report. i. The non-Federal entity or Federal agency must report each obligating action described in paragraph a.1. of this award term to http://www.fsrs.gov. ii. For subaward information, report no later than the end of the month following the month in which the obligation was made. Condition We examined the Federal Funding Accountability and Transparency Act (FFATA) reporting for the Head Start Cluster for the year ended June 30, 2022. The required FFATA reporting submissions pertaining to subrecipient awards were not made. Cause The County did not submit FFATA reporting because they were not aware of the reporting requirements. Questioned Costs No questioned costs were identified. Context Expenditures for the fiscal year 2021-22 totaled $25,414,728. Pass through payments to subrecipients subject to FFATA reporting were $6,172,353. Effect Failure to report subawards greater than $30,000 under FFATA is considered noncompliance with the transparency requirement established by the federal government. Recommendation We recommend that the County update its current practices for managing subaward reporting under the FFATA to ensure that applicable subawards are identified and the required submissions are made timely. Views of Responsible Officials and Corrective Action Plan Management’s response is reported in “Corrective Action Plan” included in a separate section at the end of this report. 25 Federal Grantor Pass-through Grantor Assistance State Federal Program Title Listing Number Grant/Contract Number Expenditures Expenditures Federal and State Awards U.S. Department of Health and Human Services Aging Cluster 93.041 AP-2122-07 100,000$             14,966$               93.042 AP-2122-07 ‐                        58,124                 93.043 AP-2122-07 ‐                        48,049                 93.044 AP-2122-07 298,074               1,044,447            Special Programs for the Aging, Title III, Part C, Nutrition Services 93.045 AP-2122-07 1,002,231            2,119,338            National Family Caregiver Support, Title III, Part E 93.052 AP-2122-07 ‐                        549,620               Nutrition Services Incentive Program 93.053 AP-2122-07 - 433,545               93.044 CARES-07 - 176,802               93.045 CARES-07 - 509,964               COVID-19 National Family Caregiver Support, Title III, Part E 93.052 CARES-07 - 121,216               93.045 AP-2122-07 - 427,469               Subtotal Aging Cluster 1,400,305 5,503,540 Other Aging Programs 10.561 SP-2122-07 ‐                        116,484               State Health Insurance Assistance Program (HICAP) 93.324 HI-2122-07 264,293               106,050               Medicare Enrollment Assistance Program 93.071 MI-2122-07 ‐                        35,148                 Total Expenditures of Federal and State Awards 1,664,598$ 5,761,222$ State Awards California Department of Aging Special Deposit Fund (SDF)-State Facilities Citation Penalties NA AP-2122-07 41,984$               Skilled Nursing Facility Quality and Accountability (SNFQAF) NA AP-2122-07 48,303                 Public Health L & C Program Fund (PH L&C) NA AP-2122-07 14,689                 Total Expenditures State Awards 104,976$ Special Programs for the Aging, Title III, Part B, Grants for Supportive Services and Senior Centers State Administrative Matching Grants for Supplemental Nutrition Assistance Program- SNAP-Ed COUNTY OF CONTRA COSTA, CALIFORNIA Supplemental Schedule of Expenditures of Federal and State Awards Provided by the California Department of Aging For the Year Ended June 30, 2022 Special Programs for the Aging, Title VII, Chapter 3, Programs for Prevention of Elder Abuse, Neglect, and Exploitation Special Programs for the Aging, Title VII, Chapter 2, Long Term Care Ombudsman Services for Older Individuals Special Programs for the Aging, Title III, Part D, Disease Prevention and Health Promotion Services COVID-19 Special Programs for the Aging, Title III, Part B, Grants for Supportive Services and Senior Centers COVID-19 Special Programs for the Aging, Title III, Part C, Nutrition Services COVID-19 Special Programs for the Aging, Title III, Part C, Nutrition Services 19 26 COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Child Nutritional Program Revenues For the Year Ended June 30, 2022 Child and Adult Care Food Program (CACFP) Assistance Listing number 10.558 Total Federal Assistance State Funded Programs: General Child Care Program 91,926$ CA State Preschool Program 314,529 Head Start and Early Head Start 109,442 Total Federal Assistance 515,897$ The Child and Adult Care Food Program revenue represents the assistance received from the Federal government in relation to the maintenance of a subsidized food program. The following is a summary of the total assistance received by the County and the various child development programs to which the funds were allocated for the year ended June 30, 2022. 20 27 21 1-Jul-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 297,295$ 633,645$ 930,940$ 1,189,181$ Total Revenue:297,295 633,645 930,940 1,189,181 EXPENDITURES Administrative Costs Salaries & Wages 17,092 15,626 32,718 32,718 30,877 Fringe Benefits 9,706 6,290 15,996 15,996 22,539 Other Costs - - - - Total Administrative Costs 26,798 21,916 48,714 48,714 53,416 Program Costs Salaries & Wages 27,418 31,892 59,310 59,310 54,733 Fringe Benefits 15,586 27,748 43,334 43,334 39,954 Operating Expenses - 12,961 12,961 12,961 44,089 Out-of-State Travel - - - - - Subcontractor/Consultant Services 142,820 539,128 681,948 681,948 996,989 Total Program Costs 185,824 611,729 797,553 797,553 1,135,765 Total Expenses:212,622$ 633,645$ 846,267$ 846,267$ 1,189,181$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 20F-3646 CARES (Assistance Listing No. 93.569) For the Period July 1, 2020 through June 30, 2022 28 22 1-Jul-20 1-Jul-22 Total Total through through Audited Reported Total 30-Jun-21 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue -$ 18,695$ 18,695$ 40,370$ Total Revenue:- 18,695 18,695 40,370 EXPENDITURES Program Costs Salaries & Wages - - - - - Fringe Benefits - - - - - Subcontractor/Consultant Services - 18,695 18,695 18,695 40,370 Total Program Costs - 18,695 18,695 18,695 40,370 Total Expenses:-$ 18,695$ 18,695$ 18,695$ 40,370$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 20F-3646 CARES Discretionary (Assistance Listing No. 93.569) For the Period July 1, 2020 through June 30, 2022 29 23 1-Jul-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 31-May-22 Costs Expenses Budget REVENUE Grant Revenue -$ 25,836$ 25,836$ 28,250$ Total Revenue:- 25,836 25,836 28,250 EXPENDITURES Program Costs Salaries & Wages - 1,170 1,170 1,170 1,170 Fringe Benefits - 854 854 854 854 Subcontractor/Consultant Services - 23,812 23,812 23,812 26,226 Total Program Costs - 25,836 25,836 25,836 28,250 Total Expenses:-$ 25,836$ 25,836$ 25,836$ 28,250$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 21F-4408 Discretionary (Assistance Listing No. 93.569) For the Period July 1, 2020 through May 31, 2022 30 24 1-Jul-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 31-May-22 Costs Expenses Budget REVENUE Grant Revenue 219,213$ 663,585$ 882,798$ 882,798$ Total Revenue:219,213 663,585 882,798 882,798 EXPENDITURES Administrative Costs Salaries & Wages 3,184 16,420 19,604 19,604 19,561 Fringe Benefits 70 11,704 11,774 11,774 14,279 Other Costs - 70,500 70,500 70,500 70,500 Total Administrative Costs 3,254 98,624 101,878 101,878 104,340 Program Costs Salaries & Wages 78,469 147,374 225,843 225,843 233,217 Fringe Benefits 56,494 62,053 118,547 118,547 108,134 Operating Expenses 6,915 6,058 12,973 12,973 28,058 Out-of-State Travel - - - - - Subcontractor/Consultant Services 23,480 386,602 410,082 410,082 409,049 Total Program Costs 165,358 602,087 767,445 767,445 778,458 Total Expenses:168,612$ 700,711$ 869,323$ 869,323$ 882,798$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 21F-4007 (Assistance Listing No. 93.569) For the Period July 1, 2020 through May 31, 2022 31 25 1-Jan-22 Total Total through Audited Reported Total 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue -$ -$ 873,970$ Total Revenue:- - 873,970 EXPENDITURES Administrative Costs Salaries & Wages - - - 15,818 Fringe Benefits - - - 11,547 Other Costs - - - 70,500 Total Administrative Costs - - - 97,865 Program Costs Salaries & Wages - - - 246,256 Fringe Benefits - - - 115,167 Operating Expenses - - - 5,682 Subcontractor/Consultant Services - - - 409,000 Total Program Costs - - - 776,105 Total Expenses:-$ -$ -$ 873,970$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 22F-5007 Discretionary (Assistance Listing No. 93.569) For the Period January 1, 2022 through June 30, 2022 32 26 1-Nov-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 245,110$ 424,423$ 669,533$ 923,290$ Total Revenue:245,110 424,423 669,533 923,290 EXPENDITURES Assurance 16 Costs Assurance 16 80,443 152,267 232,710 232,710 233,954 Administrative Costs Administrative Costs 26,210 75,889 102,099 102,099 233,954 Total A-16/Administration Costs 106,653 228,156 334,809 334,809 467,908 Program Support Costs Intake 66,482 67,843 134,325 134,325 224,153 Outreach 56,293 83,803 140,096 140,096 140,096 Training & Technical Assistance 15,682 15,187 30,869 30,869 56,038 Total Program Support Costs 138,457 166,833 305,290 305,290 420,287 Program Services Costs ECIP Emergency Heating and Cooling Services - 29,254 29,254 29,254 35,095 Total Expenses:245,110$ 424,243$ 669,353$ 669,353$ 923,290$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 21B-5005 (EHA16) (Assistance Listing No. 93.568) For the Period November 1, 2020 through June 30, 2022 33 27 1-Nov-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 529,846$ 592,801$ 1,122,647$ 1,162,508$ Total Revenue:529,846 592,801 1,122,647 1,162,508 EXPENDITURES Weatherization Program Costs Intake 15,987 29,318 45,305 45,305 93,001 Outreach 8,729 15,321 24,050 24,050 58,125 Training and Technical Assistance 6,500 24,144 30,644 30,644 58,125 Total Program Costs:31,216 68,783 99,999 99,999 209,251 Weatherization Direct Program Costs Weatherization Activity Expenditures 498,630 524,017 1,022,647 1,022,647 953,257 Total Expenses:529,846$ 592,801$ 1,122,647$ 1,122,647$ 1,162,508$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 21B-5005 (WX) (Assistance Listing No. 93.568) For the Period November 1, 2020 through June 30, 2022 34 28 1-Nov-21 Total Total through Audited Reported Total 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 887,635$ 887,635$ 889,005$ Total Revenue:887,635 887,635 889,005 EXPENDITURES Weatherization Program Costs Intake 35,361 35,361 35,361 71,120 Outreach 17,701 17,701 17,701 44,450 Training and Technical Assistance 29,128 29,128 29,128 44,450 Total Program Costs:82,190 82,190 82,190 160,020 Weatherization Direct Program Costs Weatherization Activity Expenditures 805,445 805,445 805,445 728,985 Total Expenses:887,635$ 887,635$ 887,635$ 889,005$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 22B-4005 (WX) (Assistance Listing No. 93.568) For the Period November 1, 2021 through June 30, 2022 35 29 1-Nov-21 Total Total through Audited Reported Total 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 179,776$ 179,776$ 786,244$ Total Revenue:179,776 179,776 786,244 EXPENDITURES Assurance 16 Costs Assurance 16 58,434 58,434 58,434 178,876 Administrative Costs Administrative Costs 34,661 34,661 34,661 178,876 Total A-16/Administration Costs 93,095 93,095 93,095 357,752 Program Support Costs Intake 43,701 43,701 43,701 171,397 Outreach 35,136 35,136 35,136 107,123 Training & Technical Assistance 7,844 7,844 7,844 42,849 Total Program Support Costs 86,681 86,681 86,681 321,369 Program Services Costs ECIP Emergency Heating and Cooling Services - - - 107,123 Total Expenses:179,776$ 179,776$ 179,776$ 786,244$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 22B-4005 (EHA16) (Assistance Listing No. 93.568) For the Period November 1, 2021 through June 30, 2022 36 30 1-Aug-21 Total Total through Audited Reported Total 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 419,078$ 419,078$ 1,247,985$ Total Revenue:419,078 419,078 1,247,985 EXPENDITURES Assurance 16 Costs Assurance 16 142,206 142,206 142,206 240,631 Administrative Costs Administrative Costs 59,204 59,204 59,204 322,473 Total A-16/Administration Costs 201,410 201,410 201,410 563,104 Program Support Costs Intake 99,041 99,041 99,041 327,937 Outreach 99,478 99,478 99,478 204,960 Training & Technical Assistance 19,149 19,149 19,149 81,984 Automation Costs 30,000 Total Program Support Costs 217,668 217,668 217,668 644,881 Program Services Costs ECIP Emergency Heating and Cooling Services - - - 40,000 Total Expenses:419,078$ 419,078$ 419,078$ 1,247,985$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 21V-5554 (EHA16) (Assistance Listing No. 93.568) For the Period August 1, 2021 through March 31, 2023 37 31 1-Jul-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 31-Dec-21 Costs Expenses Budget REVENUE Grant Revenue 201,360$ 111,563$ 312,923$ 317,141$ Total Revenue:201,360 111,563 312,923 317,141 EXPENDITURES Assurance 16 Costs Assurance 16 58,712 - 58,712 58,712 58,712 Administrative Costs Administrative Costs 21,955 36,757 58,712 58,712 58,712 Total A-16/Administration Costs 80,667 36,757 117,424 117,424 117,424 Program Support Costs Intake 58,412 21,437 79,849 79,849 79,849 Outreach 46,765 3,141 49,906 49,906 49,906 Training & Technical Assistance 15,516 4,446 19,962 19,962 19,962 Business Continuation Plan Costs - 45,782 45,782 45,782 50,000 Total Program Support Costs 120,693 74,806 195,499 195,499 199,717 Total Expenses:201,360$ 111,563$ 312,923$ 312,923$ 317,141$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 20U-2554 CARES (EHA16) (Assistance Listing No. 93.568) For the Period July 1, 2020 through December 31, 2021 38 32 1-Oct-19 1-Jul-20 1-Jul-21 Total Total through through through Audited Reported Total 30-Jun-20 30-Jun-21 31-Dec-21 Costs Expenses Budget REVENUE Grant Revenue 537,514$ 442,874$ 79,454$ 980,388$ 1,129,798$ Total Revenue:537,514 442,874 79,454 980,388 1,129,798 EXPENDITURES Assurance 16 Costs Assurance 16 159,916 98,013 - 257,929 257,929 257,929 Administrative Costs Administrative Costs 120,021 80,931 32,048 233,000 233,000 257,929 Total A-16/Administration Costs 279,937 178,944 32,048 490,929 490,929 515,858 Program Support Costs Intake 122,461 74,025 33,674 230,160 230,160 246,688 Outreach 99,757 54,423 - 154,180 154,180 154,180 Training & Technical Assistance 26,619 21,823 7,197 55,639 55,639 61,672 Total Program Support Costs 248,837 150,271 40,871 439,979 439,979 462,540 Program Services Costs ECIP Emergency Heating and Cooling Services 8,740 34,205 6,535 49,480 49,480 151,400 Total Expenses:537,514$ 363,420$ 79,454$ 980,388$ 980,388$ 1,129,798$ COUNTY OF CONTRA COSTA CSD Contract No. 20B-2005 (EHA16) (Assistance Listing No. 93.568) For the Period October 1, 2019 through December 31, 2021 EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) 39 33 1-Oct-19 1-Jul-20 1-Jul-21 Total Total through through through Audited Reported Total 30-Jun-20 30-Jun-21 31-Dec-21 Costs Expenses Budget REVENUE Grant Revenue 773,767$ 506,458$ 129$ 1,280,225$ 1,280,226$ Total Revenue:773,767 506,458 129 1,280,225 1,280,226 EXPENDITURES Weatherization Program Costs Intake 23,720 31,563 - 55,283 55,283 102,418 Outreach 14,458 7,821 - 22,279 22,279 64,011 Training and Technical Assistance 40,122 15,078 - 55,200 55,200 64,011 Total Program Costs:78,300 54,462 - 132,762 132,762 230,440 Weatherization Direct Program Costs Weatherization Activity Expenditures 695,467 451,867 129 1,147,463 1,147,463 1,049,786 Total Expenses:773,767$ 506,329$ 129$ 1,280,225$ 1,280,225$ 1,280,226$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 20B-2005 (WX) (Assistance Listing No. 93.568) For the Period October 1, 2019 through December 31, 2021 40 34 1-Jul-20 1-Jul-21 Total Total through through Audited Reported Total 30-Jun-21 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue 104,788$ 20,212$ 125,000$ 125,000$ Total Revenue:104,788 20,212 125,000 125,000 EXPENDITURES Administration Administrative Costs 7,060 - 7,060 7,060 7,092 Total Administation Costs 7,060 - 7,060 7,060 7,092 Training & Technical Assistance Training & Technical Assistance 3,082 11,544 14,626 14,626 14,626 - - - - Total Training & Technical Assistance 3,082 11,544 14,626 14,626 14,626 Program Costs Intake 3,740 - 3,740 3,740 3,746 Outreach 335 - 335 335 2,498 Direct Program Activities - 3,881 3,881 3,881 52,022 General Overhead Costs 5,749 5,749 5,749 12,488 Other Program Costs 83,801 60 83,861 83,861 4,995 Client Education 1,022 1,022 1,022 2,495 Health and Safety Activities - 4,727 4,727 4,727 25,038 Total Program Costs 94,647 8,668 103,315 103,315 103,282 Total Expenses:104,788$ 20,212$ 125,000$ 125,000$ 125,000$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 20C-6004 (Assistance Listing No. 81.042) For the Period June 1, 2021 through June 30, 2022 41 35 1-Apr-22 Total Total through Audited Reported Total 30-Jun-22 Costs Expenses Budget REVENUE Grant Revenue -$ -$ 376,446$ Total Revenue:- - 376,446 EXPENDITURES Aministrative Costs Administrative Costs - - - 376,446 Total Expenses:-$ -$ -$ 376,446$ COUNTY OF CONTRA COSTA EHSD-Community Services Bureau Supplemental Schedule of Revenue and Expenditures (SSRE) CSD Contract No. 21W-9002 (LIHWAP) (Assistance Listing No. 93.499) For the Period April 1, 2022 through June 30, 2022 42 36 Page left intentionally blank 43 Contra Costa County Robert R. Campbell Auditor-Controller 625 Court Street Martinez, California 94553-1282 Phone (925) 608-9300 Fax (925) 608-9395 Harjit S. Nahal Assistant Auditor-Controller   37 Corrective Action Plan For the Year Ended June 30, 2022 Reference Number: 2022-001 Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Head Start Cluster Assistance Listing Number: 93.600 Federal Award Numbers: 09CH010862-04-02 and 09HE000903-01-00 Category of Finding: Reporting Type of Finding: Material Weakness in Internal Control over Compliance and Instance of Noncompliance The Employment and Human Services Department will comply with Appendix A (I)(a) of 2 CFR Part 170 to report each obligating action greater than or equal to $30,000 in Federal funds for a subaward to a non- Federal entity no later than the end of the month following the month in which the obligation was made. When applicable, the Employment and Human Services Department will require that its subrecipient provide their executive total compensation. The Employment and Human Services Department will report the information per 2 CFR 170 Appendix A, and the grant award instructions. The Employment and Human Services Department’s fiscal management will work with fiscal staff to develop a FFATA tracking tool for designated fiscal staff to use to meet the reporting requirement of Head Start. EHSD designated fiscal staff will be trained on the tracking tool and reporting requirement for completeness, accuracy and timeliness in accordance with 2 CFR 170 Appendix A, and the grant award instructions. Contact person responsible for corrective action plan: Marla Stuart, Director Contra Costa County Employment and Human Services Department Emilia Gabriele, Chief Deputy Director Contra Costa County Employment and Human Services Department Erik Brown, Chief Financial Officer Contra Costa County Employment and Human Services Department 44 Contra Costa County Robert R. Campbell Auditor-Controller 625 Court Street Martinez, California 94553-1282 Phone (925) 608-9300 Fax (925) 608-9395 Harjit S. Nahal Assistant Auditor-Controller   38 Summary Schedule of Prior Year Findings For the Year Ended June 30, 2022 Financial Statement Findings: Finding 2021-001 – Accuracy of the Schedule of Expenditures of Federal Awards Significant Deficiency U.S. Code of Federal Regulations, Title 2, Part 200, section 510(b) Schedule of Expenditures of Federal Awards requires recipients of federal awards to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the entity’s financial statements to accurately reflect federal awards expended and amounts provided to subrecipients for individual federal programs by assistance listing (AL) numbers. During the audit, various misstatements were identified in the County’s SEFA for the year ended June 30, 2021. This is due to the coronavirus pandemic and other priorities, the County was challenged with staffing resources. In addition to turnover of staff, there was a need to allocate substantial County resources to address public health and safety needs while managing the significant inflow of new federal funds from the Coronavirus Aid, Relief, and Economic Security (CARES) Act. The County subsequently corrected the expenditure amounts reported in its fiscal year 2021 SEFA prior to its issuance. Recommendation: The County should reevaluate its process and controls for the preparation of the SEFA to ensure the completeness and accuracy of the SEFA. Considerations may include:  Providing training or reference materials to personnel responsible for communicating federal expenditures and related information to the Office of the Auditor-Controller, to enhance understanding of SEFA reporting requirements;  Enhancing reviews by the grant-administering departments prior to submission of program expenditures and related information to the Office of the Auditor-Controller; and  Strengthening the review and monitoring functions, such as more detailed analytical reviews and/or reconciliations to supporting documents on a sampled basis. Status: Corrected. 45 COUNTY OF CONTRA COSTA, CALIFORNIA Summary Schedule of Prior Year Audit Findings For the Year Ended June 30, 2022   39 Federal Audit Findings: Finding 2018-001-Wage Rate Requirements: (Significant Deficiency in Internal Control Over Compliance) Highway Planning and Construction (HPC) Program Assistance Listing Number 20.205 Current Status: Public Works identified procedure and documentation improvements to ensure compliance with the Wage Rate Requirement and that all certified payroll is received prior to the issuance of payment to the contractor. The “checklist” utilized in the review and approval process of invoices will be revised to include certified payroll for both the primary contractor and all subcontractors. Invoices are not approved for payment until the checklist is completed. We have identified two opportunities to include additional notation to the contractor regarding the requirement for certified payroll. A specific notice will be made to the front of the Special Provisions to point out Section 7-1.03K(3) Certified Payroll Records of the Caltrans Standard Specifications to the contractor’s attention, specifying the requirement for weekly certified payroll, including all subcontractors, as part of the invoicing process and prior to any approval for payments. An additional item will be added on the Preconstruction Checklist to the contractor regarding the requirement of certified payroll. As of June 30, 2021, modifications to the forms identified, training for staff, and implementation was still in progress. Implementation, including finalizing updated forms, was completed in September 2019. However, additional staff training, including updating staff procedures manual, and procedure modifications were identified to ensure implementation of corrective action. In November 2021, corrective action included updating contract language to incorporate a note to the Special Notices section of the Special Provisions, updating the staff procedures manual, and annual training of project managers and resident engineers. Also, additional documentation is required for subcontractors and a 10% deduction for an omission of a certified payroll report to ensure implementation of corrective action. As of June 30, 2022: corrected. Contact person responsible for corrective action plan: Diana Oyler, Chief of Fiscal Services Contra Costa County Public Works Department Joe Yee, Deputy Director Contra Costa County Public Works Department 46 CONTRA COSTA COUNTY Staff Report 1025 ESCOBAR STREET MARTINEZ, CA 94553 File #:23-763 Agenda Date:11/6/2023 Agenda #:5. FINANCE COMMITTEE Meeting Date: 11/6/23 Subject: Capital Projects Report Submitted For: Finance Committee Department: Public Works Referral No: 1/6/2009 SD.2 Referral Name: Capital Projects Report Presenter: Jeff Acuff Contact: Brian Balbas (925) 313-2284 Referral History: On January 6, 2009, the Board of Supervisors approved recommendations for Board Member appointments to local, regional, and statewide boards, committees, and commissions for the 2009 calendar year. One of the adopted recommendations was to combine the Capital Facilities Committee with the Finance Committee. Referral Update: Per Committee request the report elements have been updated. The presentation summarizes upcoming, active, and recently completed major construction projects. The PDF report attached provides additional status and cost details for active and completed construction and facilities maintenance projects, including the Surplus Property Report. Recommendation(s)/Next Step(s): ACCEPT Capital Projects update. Fiscal Impact (if any): N/A CONTRA COSTA COUNTY Printed on 11/1/2023Page 1 of 1 powered by Legistar™47 Jeff Acuff Division Manager Public Works Department 48 6/01/22 to 9/30/23 114 Active Projects valued at over $509 million 92 New Projects 36 Deferred Maintenance Projects 52 Completed Projects Main Customer Agencies: Health Services (HSD), Sheriff, CCC Fire Protection District, Library 49 50 4 51 •First government project in the world to achieve Total Resource & Efficiency (TRUE) Pre-Certification. 5 52 6 53 2024 Contra Costa County 54 55 56 57 New Fire Stations •FS 90, Brentwood •FS 86, Bay Point Replacement Fire Stations •FS 9, Concord •FS 94, Brentwood Improvements Fire Training East Fire Station 87 Fire Communications Center Fire Station 2 Generator Fire Station 81 Generator Fire Station 81 Bathrooms Fire Station 85 Driveway Reconfiguration Fire Station 14 Repairs to Concrete Apron 58 76 74 90 68 75 110 12 14 21 36 28 92 16 19 18 33 20 51 0 20 40 60 80 100 120 2018 2019 2020 2021 2022 2023 Active Projects New Projects Completed Projects 59 $257M $359M $347M $287M $275M $509M $- $100,000,000 $200,000,000 $300,000,000 $400,000,000 $500,000,000 $600,000,000 2018 2020 2021 2022 2023 60 SHARP INCREASE IN NUMBER OF PROJECTS SUPPLY CHAINSTAFFINGINCREASED COSTS INTERNAL EXTERNAL 61 62 FINANCE COMMITTEE CAPITAL PROJECTS REPORT 63 CAPITAL PROJECTS SUMMARY 64 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS Agency Client Projects NEW PROJECTS since last report (92 projects) APPROX. PROJECT VALUE Health Services Department 47 1. Install Washer/Disinfector at CCRMC $421,000 Public Works 22 2. Install Washer/Disinfector at 13601 San Pablo Ave $350,000 Contra Costa Fire Protection District 15 3. Reconfigure Suites 234, 235 & Telecom Room at 30 Douglas $13,413 Library 13 4. Library Preliminary Assessments $21,630 Sheriff 7 5. Security Camera Improvements at CCRMC $250,000 County Administration 4 6. Repipe Fuel Lines at 2471 Waterbird Way $625,000 Animal Services 1 7. Feasibility Study for Behavioral Health at 847B Brookside Dr. $117,008 Child Support Services 1 8. BHCIP Assessment - 847B Brookside $71,394 Department of Information Technology 1 9. BHCIP Assessment - Kirker Pass $196,861 Employment & Human Services 1 10. BHCIP Assessment - Alhambra Way $10,898 Probation 1 11. Structural for Antenna Roof Support at 555 Escobar $5,000 Public Defender 1 12. Replace Roof at 2475 Waterbird Way $225,000 TOTAL PROJECTS:114 $509,459,987 13. Replace Roof at 2467 Waterbird Way $700,000 14. Roof Replacement at 255 Glacier Drive $1,000,000 15. Replace Underground Storage Tank for Generator $3,000,000 16. FLIP Parking Lot Repairs at WCDF $1,500,000 17. Child Support Services TIs $26,281 18. BHCIP Assessment - Uilkemia House Remodel $25,284 19. Feasibility Study to Add Exam Rooms $21,211 20. BHCIP Assessment - 2523 El Portal $211,739 21. Feasibility/Analysis Elevator Modernization at CCRMC $88,000 22. Feasibility/Analysis for CCRMC Pharmacy Red Outlets $38,268 23. Study Chiller Replacement at CCRMC $3,398 24. Analysis to Upgrade Nurse Call System at CCRMC $18,000 25. Evaluate HVAC for DI Stress Lab & Echo Reading Room $35,000 26. Address Building Movement at Fire Station 87 $500,000 27. Repairs to Concrete Apron at Fire Station 14 $750,000 28. Dog Park at 847C Brookside Drive $552,000 29. Dog Park at 2101 Loveridge Road $350,000 65 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS Funding Source Projects NEW PROJECTS (continued) Am. Recovery Plan Funds / County General Fund 1 30. Estimate to Replace HVAC at 4549 Delta Fair $9,726 Capital Reserve Funds 3 31. BHCIP - General Work $150,000 CCC Department Funding 9 32. Climate Action Plan & General Plan Review $10,934 CCCFPD 9 33. BHCIP Assessment - Vacant Lot adjacent to 2523 El Portal $17,582 CDHCD Grant 3 34. Access Control from Lobby to Secure Parking TBD Clean Energy Program Funding 1 35. Pinole Library Roof Replacement $949,506 Enterprise Fund Medi-Cal Revenue 1 36. Antioch Library HVAC Replacement $209,050 Federal and State Funds 2 37. Pinole Library HVAC Replacement $442,038 FLIP Funds 9 38. Replace Emergency Generator at 50 Douglas $500,000 General Fund 3 39. Replace Emergency Generator at 30 Douglas $750,000 Hazard Mitigation Grant 2 40. Address Building Movement at Fire Training East TBD Hospital Enterprise Fund 30 41. Fire Comm Center Remodel (Fire Station 2) $5,500,000 HUD Hums Grant 1 42. Old Juvenile Hall Demolition Estimate and CEQA $31,721 Library Fund 4 43. Fire Comm Center Remodel $5,500,000 Measure X 18 44. Children's Waiting Area Shielding $4,130 Measure X and FPD Supplemental Funding 2 45. Upgrade PreAction Fire Alarm Systems at MDF $1,000,000 Measure X and Supplemental Funding 8 46. Kensington Library Deferred Maintenance Estimate $1,392 Med. Waiver Quality Improvement Payment Plan 1 47. Ygnacio Valley Library Deferred Maintenance Estimate $194 Mental Health Services Act + Potential BHCIP 1 48. Libraries PM Support $15,000 Power Resilience Allocation Funds + Dept Funds 1 49. Fire Station 85 Driveway Reconfiguration $150,000 Tech. Resource Funding + Bldg Maint. Fund 1 50. Fire Station 81 Bathroom Improvement TBD Unknown 4 51. Montalvin Park ADA Parking Project $46,606 TOTAL PROJECTS:114 $509,459,987 52. Data Center Fire Suppression System Upgrade $185,000 53. Pinole Library Electrical Study $10,901 54. Estimate to Add Outlets at CCRMC $22,000 55. HUGS System Update at CCRMC TBD 56. Enhanced Isolation Room Conversion Study TBD 57. Fire Station 9 at Existing Site (209 Center Ave., Martinez) $18,000,000 Public Works 58. Fire Station 94, Brentwood $16,900,000 66 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS Approximate Project Value Projects NEW PROJECTS (continued) Up to - $100,000 18 59. Mod F Jump Barrier $1,900,000 Between $100,001 - $250,000 13 60. Study NPC Deficiencies at CCRMC TBD Between $250,001 - $500,000 16 61. Kensington Library HVAC Upgrade Study $40,000 Between $500,001 - $1,000,000 22 62. Antioch Library Electrical Study $35,000 Projects over $1,000,001 31 63. Probation Training Center HVAC Upgrade $32,000 To Be Determined (TBD) 14 64. Study to Recoat Building at 2311 Loveridge Rd., Pittsburg $7,478 Power Purchase Agreements (PPA) 0 65. Skylights/Windows Study at Public Works IT Division $21,156 TOTAL PROJECTS:114 66. Estimate for Animal Services Remodel Work $170,000 67. 5D Medication Room TBD 68. Chiller Replacement at Linus Pauling Drive, Hercules $675,000 69. EOC HVAC Warranty TBD 70. Red Outlet Installation for Pharmacy at CCRMC TBD 71. Bay Point Library $10,000,000 72. Accessibility Upgrades at Mammography Room TBD 73. Elevator Study for CCRMC Satellite Buildings $70,000 74. PES Family Room Conversion to Intake Room TBD 75. Chiller Replacement at CCRMC TBD 76. Antioch Library Re-roof $800,000 77. Kensington Library HVAC Upgrade TBD 78. Child Support Services Space Plan TBD 79. Library Design Standards $50,000 80. Central County Storage Facility $25,000,000 81. East County Service Center $90,000,000 82. Library Admin Space Planning $20,000 83. Residential Treatment Program - El Portal TBD 84. Fire Station 10 Re-roof $275,000 85. Library Admin Space Planning $20,000 86. Recoat Building at 2311 Loveridge Pittsburg TBD 87. Pinole Library Electrical Upgrade $150,000 67 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS Deferred Maintenance Projects Projects NEW PROJECTS (continued) Active Projects 88. Clayton Library Interior $50,000 Health Services Department 9 89. CCRMC Vacuum Pump Study TBD Public Works 9 90. Ygnacio Valley Library HVAC Study $50,000 Contra Costa Fire Protection District 4 91. Ygnacio Valley Library Re-roof Estimate $50,000 Library 8 92. Ygnacio Valley Library Electrical Study $50,000 Sheriff 3 TOTAL VALUE OF NEW PROJECTS:$190,997,799 County Administration 0 Animal Services 0 Child Support Services 0 Department of Information Technology 1 Employment & Human Services 1 Probation 1 Public Defender 0 TOTAL PROJECTS:36 68 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS COMPLETED PROJECTS since last report (52 projects) APPROX. PROJECT VALUE 1. Accessibility and Fire, Life, and Safety Upgrades at MDF $705,668 2. ADA, Fire/Life Safety, and Rooftop Equipment at WCDF $4,143,245 3. Module M Remodel $20,095,523 4. SunPower PPA Project at 1000 Ward Street $436,661 5. SunPower PPA Project at 2530 Arnold Drive incl 6. SunPower PPA Project at 4545 Delta Fair Blvd incl 7. SunPower PPA Project at 4549 Delta Fair Blvd incl 8. Perimeter Intrusion Detection System $1,500,000 9. Replace Elevator at 10 Douglas $481,406 10. Covid Testing Equipment $530,105 11. Countywide Facilities Master Plan $632,149 12. Ornamental Car Cage $336,583 13. Replace Chiller at 1305 Macdonald Avenue $560,251 14. Elevator Modernization at 40 Douglas $609,185 15. Estimate to Modernize Elevators, 1305 Macdonald Ave. $352,170 16. Module C Remodel $4,168,896 17. New CT Unit $1,254,925 18. Demolition of Fire Station 54 $359,210 19. BHCIP Assessment - 847B Brookside $71,394 20. BHCIP Assessment - Kirker Pass $196,861 21. Martinez Inpatient Pharmacy (MIP) Modular Clean Room $800,000 22. BHCIP Assessment - 2523 El Portal Drive $211,739 23. BHCIP Assessment - Vacant Lot adjacent to 2523 El Portal $17,582 24. Fire Comm Center Remodel $365,419 25. Access Control Upgrade at CCRMC $73,675 26. Restroom Assessment, 3024 Willow Pass Road, Concord $34,898 27. Interior/Exterior Security Camera Evaluation $89,794 28. TI for Emergency Response Unit $57,461 29. Blue Light Call Boxes for CCRMC Parking Areas $34,667 69 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS COMPLETED PROJECTS (continued) 30. Prelim Design Development at Juvenile Hall $53,490 31. ADA Parking Feasibility $11,980 32. RFP for Fire Station Construction $54,000 33. Staff Restroom Upgrades at 50 Douglas Drive, Martinez $8,796 34. Assess and Estimate Plumbing Improvements $3,316 35. Libraries Prelim Assessments $21,630 36. Child Support Services TI's $26,281 37. Feasibility/Analysis for CCRMC Pharmacy Red Outlets $38,268 38. Study Chiller Replacement at CCRMC $3,398 39. Estimate to Replace HVAC at 4549 Delta Fair $9,726 40. Old Juvenile Hall Demolition Estimate and CEQA $31,721 41. Pinole Library Electrical Study $10,901 42. Enhanced Isolation Room Conversion Study $5,306 43. Kensington Library HVAC Study $24,841 44. Study to Recoat Building at 2311 Loveridge Rd., Pittsburg $7,478 45. Skylights/Windows Study for Public Works IT $21,156 46. Fire Station 10 - Sewer Line $374,833 47. Feasibility Study for Shelter at 847B Brookside Drive TBD 48. Negotiate Micro-housing Master Lease, 2555 El Portal Drive $149,667 49. Feasibility Study to Add Exam Rooms $21,211 50. Fire Station 86 $15,729,000 51. Climate Action Plan & General Plan Review $10,934 52. Perimeter Intrusion Detection System $1,500,000 TOTAL VALUE OF COMPLETED PROJECTS:$56,237,400 70 CAPITAL PROJECTS REPORT - FINANCE COMMITTEE PROJECTS SUMMARY 06/01/22 - 09/30/23 ACTIVE PROJECT DATA PROJECT SUBSETS CANCELLED PROJECTS since last report (13 projects) APPROX. PROJECT VALUE 1. Central Kitchen Renovation $365,374 2. Reconfigure Suites 234, 235 & Telecom Room at 30 Douglas $13,413 3. BHCIP Assessment - Alhambra Way $10,898 4. Adult Shelter Upgrades at 847C Brookside Drive $117,008 5. Estimate for the Pallet Village Project $96,368 6. Children's Waiting Area Shielding $4,130 7. Estimate Exterior Paint at 1305 Macdonald Ave., Richmond $3,008 8. Estimate to Replace Carpet 4545 Delta Fair Blvd., Antioch $4,792 9. Kensington Library Deferred Maintenance Estimate $1,392 10. Ygnacio Valley Library Deferred Maintenance Estimate $194 11. Montalvin Park ADA Parking Project $46,606 12. Expansion of Mental Health Center at CCRMC $500 13. BHCIP Assessment - Uilkemia House $25,284 TOTAL VALUE OF CANCELLED PROJECTS:$688,967 TRANSFERRED TO FACILITIES since last report (2 projects) APPROX. PROJECT VALUE 1. Structural for Antenna Roof Support at 555 Escobar - 2. Antioch Library HVAC Replacement - TOTAL VALUE OF TRANSFERRED PROJECTS:- 71 ACTIVE PROJECTS REPORT 72 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments PROJECTS IN FEASIBILITY STUDY, DESIGN AND OTHER PHASES PRIOR TO CONSTRUCTION Animal Services 1 Estimate for Animal Services Remodel Work 4800 Imhoff Place, Martinez 5 Study 80% 11/17/23 TBD American Recovery Plan Funds or County General Fund Draft schematic design completed & Final Schematic and cost estimate underway. Contra Costa Fire Protection District 2 Repairs to Concrete Apron at FS-14 521 Jones Street, Martinez 5 Design 50% 04/15/24 $750,000 Fire District Capital Construction Fund Design development drawings being completed. 3 Fire Station 85 Driveway Reconfiguration 2331 Loveridge Road, Pittsburg 5 Design 50% TBD $150,000 Fire District Capital Construction Fund Project in Construction Drawing phase. 4 Fire Station 81 Bathroom Improvement 315 W 10th Street, Antioch 5 Design 50% 12/31/24 $120,000 Measure X Project in Construction Drawing phase. 5 Fire Station 90 Empire & Grant, Brentwood 3 Design 98% 03/30/26 $20,000,000 Measure X + Development Impact Fees + Federal Earmark + Fire District Bridging documents are underway. CM estimates ultimate project cost of $26.8 million. 6 Fire Station 94 739 First Street, Brentwood 3 Design 98% 03/30/26 $16,900,000 Measure X + Fire District Capital Construction Fund Bridging documents nearly complete. 7 Fire Comm Center Remodel (Fire Station 2) 2010 Geary Road, Walnut Creek 4 Permit 50% 10/15/25 $5,500,000 Fire District EMS Transport Fund Preparing for bid while in permit review. 8 Address Building Movement at Fire Training East 2331 Loveridge Road, Pittsburg 5 Pre-Design 10% TBD TBD Fire District Capital Construction Fund Trying to resolve how to best test soils. 9 Address Building Movement at FS-87 800 W. Leland Drive, Pittsburg 5 Pre-Design 20% TBD $500,000 Fire District Capital Construction Fund Soils report completed to guide solution. 10 Fire Station 10 Reroof 2955 Treat Blvd, Concord 4 Project Set-Up 1% TBD $275,000 FPD General Fund Working with user and JOC contractor on project plan. 11 Fire Station 9 - Existing Site 209 Center Ave, Pacheco 4 Project Set-Up 0% TBD $18,000,000 Bond Funds and Fire District Capital Construction Fund Consultant proposals have been solicited. Child Support Services 12 Child Support Services Space Plan 50 Douglas Drive, Martinez 5 Project Set-Up 1% TBD $16,000 66% Federally Funded, 34% State Funded Architect procurement in process. County Administration 13 Central County Storage 2467 Waterbird Way, Martinez 5 Project Set-Up 1% 03/01/27 $20,000,000 Undesignated Capital + General Fund Capital Reserves Currently looking at planning for ultimate condition of Public Works' Waterbird campus. 14 East County Service Hub Antioch or Brentwood tbd Project Set-Up 1% 09/01/27 $60,000,000 Undesignated Capital + General Fund Capital Reserves Two potential sites are under consideration. CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 73 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 Department of Information Technology 15 Fire Suppression System Upgrade 30 Douglas Drive, Martinez 5 Design 25% 06/15/24 $185,000 Technology Resource Funding + Building Maintenance Fund Consultant is working on construction drawings. Employment & Human Services 16 Chiller replacement at Linus Pauling 151 Linus Pauling Drive, Hercules 5 Project Set-Up 2% TBD $675,000 Org 0504 Consultant proposals under review by EHSD. Health Services 17 Replace CCRMC Cooling Towers 2500 Alhambra Ave, Martinez 5 Bid 45% 12/15/24 $4,600,000 Hospital Enterprise Fund Bids are being evaluated. Mechanical equip. lead times are estimated at 36-40 weeks. 18 MWC- Building Addition & Generator 25 Allen Street, Martinez 5 Bid 40% 08/15/24 $2,665,028 Medical Waiver Quality Improvement Payment Plan Board approval to solicit bids received October 3. Public bid process will be next step. 19 Generator for Public Health Modular 2500 Alhambra Ave, Martinez 5 Design 50% 05/15/24 TBD Hospital Enterprise Fund Generator delivery is due in February. 20 Replace Cart Washer 2500 Alhambra Ave, Martinez 5 Design 35% 06/01/24 $764,268 Hospital Enterprise Fund Hospital equipment replacement project. 21 Added Red Outlets for CCRMC Pharmacy 2500 Alhambra Ave, Martinez 5 Design 10% 06/30/24 $250,000 Hospital Enterprise Fund Design in progress and scheduled for review by December 2023 22 Dog Park at Brookside 847 C Brookside Drive, Richmond 1 Design 25% 04/30/24 $350,000 CDHCD Grant In design. Project currently being valued engineered. 23 CCRMC Measure X Projects: Master Plan 2500 Alhambra Ave, Martinez 5 Master Planning 85% 11/15/23 $1,000,000 Measure X Part of $80mm allocated for BOS approved improvements at CCRMC. 24 CCRMC Measure X Projects: Medical Office Building 2500 Alhambra Ave, Martinez 5 Master Planning 0% TBD $29,000,000 Measure X Project on hold pending CCRMC master plan. 25 CCRMC Measure X Projects: Parking Structure 2500 Alhambra Ave, Martinez 5 Master Planning 0% TBD $15,000,000 Measure X Project on hold pending CCRMC master plan. 26 CCRMC Measure X Projects: Interventional Radiology Expansion 2500 Alhambra Ave, Martinez 5 Master Planning 0% TBD $5,000,000 Measure X Project on hold pending CCRMC master plan. 27 CCRMC Measure X Projects: Psychology Services Expansion 2500 Alhambra Ave, Martinez 5 Master Planning 0% TBD $5,000,000 Measure X Project on hold pending CCRMC master plan. 28 CCRMC Vacuum Pump Study 2500 Alhambra Ave, Martinez 5 New Project 0% 02/17/24 TBD Hospital Enterprise Fund Project kick-off on 10/31/23 29 Install Washer/Disinfector at WCHC 13601 San Pablo Ave, San Pablo 1 Permit 35% 05/04/24 $421,000 Hospital Enterprise Fund In Permit review at the Department of Conservation and Development. 74 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 30 Add 3 Exam Rooms 215 Pacifica Avenue, Bay Point 5 Pre-Design 5% 06/30/24 $600,000 Hospital Enterprise Fund Finalizing design proposal. 31 Recoat Building 2311 Loveridge Road, Pittsburg 5 Project Set-Up 5% 06/30/24 $800,000 Hospital Enterprise Fund Cost estimate from Leland Saylor is $800K. Met with Dynasel for job scope walk on 10/4. 32 Study NPC Deficiencies at CCRMC 2500 Alhambra Ave, Martinez 5 Project Set-Up 5% 12/31/23 TBD Hospital Enterprise Fund Project concerns State-mandated improvements to acute care facilities. 33 TIs at Suites 300 and 300A 597 Center Ave, Martinez 5 Project Set-Up 0% 03/30/24 $290,000 Enterprise Fund Medi-Cal Revenue Beginning effort to procure an architectural firm. 34 Chiller Replacement at CCRMC 2500 Alhambra Ave, Martinez 5 Project Set-Up 2% TBD $1,035,000 Hospital Enterprise Fund Consultant procurement is in progress. 35 HUGS System Update 2500 Alhambra Ave, Martinez 5 Study 5%08/15/25 $600,000 Orgs 6536, 6971 and Hospital Enterprise Fund Project included in WW1025 Elevator Study at CCRMC 36 Elevator modernization Study for CCRMC Hospital 2500 Alhambra Ave, Martinez 5 Study 50%11/30/23 $88,000 Hospital Enterprise Fund Draft report and cost estimate to be submitted on 10/6/23 37 Elevator modernization Study for CCRMC Satellite Buildings 2500 Alhambra Ave, Martinez 5 Study 50%11/30/23 $70,000 Hospital Enterprise Fund Draft report and cost estimate to be submitted on 10/6/23 38 PES Family Room Conversion to Intake Room 2500 Alhambra Ave, Martinez 5 Study 5% 11/30/23 TBD Hospital Enterprise Fund Consultant services proposal due 10/6/23 39 Estimate to Add Outlets at CCRMC 2500 Alhambra Ave, Martinez 5 Study 5% 12/31/23 $18,500 Hospital Enterprise Fund Consultant to walk site on October 11, 2023 to confirm locations. 40 Hope House Structural Repairs (Evaluation) 300 Ilene Street, Martinez 5 Study 99% TBD $400,000 Risk Management Except for soils monitoring, project is complete. Health Services has not yet authorized design and/or 41 5D Medication Room - feasibility study 2500 Alhambra Ave, Martinez 5 Study 25% 12/01/23 TBD Hospital Enterprise Fund Design team is going to evaluate and present several different options. 42 Evaluate HVAC for DI Stress Lab and ECHO Reading Room - feasibility study 2500 Alhambra Ave, Martinez 5 Study 25% 12/01/23 $38,000 Hospital Enterprise Fund Design team is going to evaluate and present several different options. 43 Accessibility Upgrades to Mammography Room 13601 San Pablo Ave, San Pablo 1 Study 25% 10/31/23 $7,000 Hospital Enterprise Fund Currently finalizing cost estimates. 44 Upgrade Nurse Call System at CCRMC 2500 Alhambra Ave, Martinez 5 Study 98% 11/15/23 $18,000 Hospital Enterprise Fund Presentation of findings to CCRMC staff is the last remaining action item. 45 Crisis Hub Center 1034 Oak Grove Road, Concord 4 Design 35% 12/20/24 $5,000,000 Measure X + Federal Grant dollars pending award Construction drawings underway, construction cost estimate due 46 Residential Treatment Program - El Portal 2523 El Portal Drive, San Pablo 1 Design 5% 12/01/24 TBD Mental Health Services Act + potential BHCIP Consultant services proposal in progress, site walk on 10/11/23 75 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 Library 47 Pinole Library Roof Replacement 2935 Pinole Valley Road, Pinole 1 Design 10% 07/26/26 $949,506 CA State Library Grant + Measure X + Library Fund Project being designed in concert with HVAC and Electrical Upgrade projects. 48 Pinole Library HVAC Replacement 2935 Pinole Valley Road, Pinole 1 Design 10% 09/15/26 $606,283 CA State Library Grant + Measure X + Library Fund Project being designed in concert with Roof and Electrical Upgrade projects. 49 Pinole Library Electrical Upgrade 2935 Pinole Valley Road, Pinole 1 Design 10% 07/26/26 $150,000 Library Fund + Measure X + State Grant Funding Project being designed in concert with Roof (WH405)and HVAC (WH407) 50 Clayton Library Interior 6125 Clayton Road, Clayton 4 New Project 0% TBD $50,000 Library Fund Scope of work is for design and a cost estimate. 51 Ygnacio Valley Library HVAC Study 2661 Oak Grove Road, Walnut Creek 4 New Project 0% TBD $50,000 Library Fund + Measure X Newly received work request. 52 Ygnacio Valley Library Reroof Estimate 2661 Oak Grove Road, Walnut Creek 4 New Project 0% TBD $50,000 Library Fund + Measure X Newly received work request. 53 Ygnacio Valley Library Electrical Study 2661 Oak Grove Road, Walnut Creek 4 New Project 0% TBD $50,000 Library Fund + Measure X Newly received work request. 54 Bay Point Library 205 Pacifica Avenue, Bay Point 5 Pre-Design 3% 09/15/26 $10,000,000 not noted on work request Current efforts involve support of Library with grant funding, lease negotiations and public outreach. 55 Library Design Standards n/a n/a Project Set-Up 2% TBD $50,000 Library Fund Project is to develop design standards to use at all County libraries. 56 Library Admin Space Planning 777 Arnold Drive, Martinez 5 Project Set-Up 0% TBD $20,000 Library Fund Scope of work is for design and a cost estimate. 57 Kensington Library HVAC Upgrade 61 Arlington Ave, Kensington 1 Project Set-Up 1% TBD $1,732,850 not noted on work request Design proposal received and being reviewed for approval with client 58 Libraries PM Support various n/a Pre-Design 80% TBD $15,000 Library Fund Services provided involve support to the Library when evaluating potential projects. 76 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 Probation 59 Probation Training Center HVAC Upgrade 100 Glacier Drive, Martinez 5 Study 20% 12/01/23 $32,000 Org 3000 Feasibility study is in progress. Construction is pending outcome of feasibility study. Public Works 60 Flip Roof Replacement - 255 Glacier 255 Glacier Drive, Martinez 5 Bid 50% 12/08/23 $998,000 FLIP Funds JOC contractor is in the process of pricing construction. 61 Repipe PW Fuel Lines 2471 Waterbird Way, Martinez 5 Design 25% 08/01/24 $625,000 FLIP Funds Construction documents are in progress. 62 Replace Underground storage tank (FLIP) 1000 Ward Street, Martinez 5 Design 25% 12/01/24 $3,000,000 FLIP Funds Schematic design is complete. 63 Installation of EV Chargers at 2475 Waterbird 2475 Waterbird Way, Martinez 5 Design 10% 05/15/24 $209,170 Measure X 50% design is complete. 6 ports. 64 Installation of EV Chargers - 2047 Arnold Industrial 2047 Arnold Industrial Way, Concord 5 Design 10% 06/15/24 $260,530 Measure X 50% design is complete. 4 ports 65 Installation of EV Chargers - 10 Douglas 10 Douglas Drive, Martinez 5 Design 10% 03/15/24 $207,730 Measure X 50% design is complete. 10 ports 66 Installation of EV Chargers - 2467 Waterbird 2467 Waterbird Way, Martinez 5 Design 10% 05/15/24 $209,170 Measure X 50% design is complete. 6 ports 67 Installation of EV Chargers - 4800 Imhoff 4800 Imhoff Place, Martinez 5 Design 10% 05/15/24 $260,530 Measure X 30% design is complete. 8 ports 68 Installation of EV Chargers - 597 Center 597 Center Ave, Martinez 5 Design 10% 05/15/24 $169,570 Measure X 50% design is complete. 6 ports 69 Replace emergency generator 30 Douglas Drive, Martinez 5 Design 30% 03/01/25 $500,000 Measure X Deferred Maintenance Funding Supply chain issues for generator delivery will impact project completion schedule. 70 Installation of EV Chargers at 4545 Delta Fair 4545 Delta Fair Blvd, Antioch 5 Permit 25% 05/15/24 $414,930 Measure X In permitting, 14 ports. 71 Installation of EV Chargers at 4549 Delta Fair 4549 Delta Fair Blvd, Antioch 5 Permit 25% 05/15/24 $339,950 Measure X In permitting, 12 ports. 72 Parking Lot Repairs and ADA Upgrades 10 Douglas Drive, Martinez 5 Pre-Design 3% 02/15/25 $8,800,000 FLIP Funds CPM reviewing design proposal. 73 Renew Emergency Generator 50 Douglas Drive, Martinez 5 Study 50% 08/01/25 $500,000 Measure X Deferred Maintenance Funding Electrical load studies completed. Supply chain issues for generator delivery. 77 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 Sheriff 74 Parking lot repairs (FLIP) 5555 Giant Highway, Richmond 1 Design 20% 11/15/25 $1,500,000 FLIP Funds Full repairs to begin after completion of WRTH construction. 75 Mod F Jump Barrier 1000 Ward Street, Martinez 5 Design 15%08/31/24 $1,900,000 FY22/23 Operating Budget Various solutions being evaluated for structural implications. 76 Access Control from Lobby to Secure Parking 1850 Muir Road, Martinez 5 Permit 25% 02/17/24 $160,000 Sheriff Coroner Just got permit & expect to start work end of October 77 Custody Alternative Facility TI Study 920 Mellus Street, Martinez 5 Study 40%11/01/24 $31,500 Org 2577 Draft schematic design submitted. Final in progress. Subtotal $ 249,927,515 78 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 PROJECTS IN CONSTRUCTION PHASES Contra Costa Fire Protection District 78 Fire Station 2 Generator 2012 Geary Road, Walnut Creek 4 Construction 50% 05/15/24 $615,000 Hazard Mitigation Grant Program Construction start pending arrival of generator equipment. Estimated November 2023. 79 Fire Station 81 Generator 315 W 10th Street, Antioch 5 Construction 50% 05/15/24 $533,000 Hazard Mitigation Grant Program Construction start pending arrival of generator equipment. Estimated November 2023. County Administration 80 (Administration Building Demolition and Redevelopment) ADR 651 Pine Street, Martinez 5 Construction 85% 06/11/24 $77,874,271 General Fund Construction underway. Final completion is estimated June 2024. 81 Carquinez Site Telcom Tower Repair 1001 Arabian Heights, Martinez 5 Post-Construction 95% 12/15/23 $1,560,000 Capital Reserve Funds Construction is complete. Working on project closeout. Health Services 82 Omnicell Dispensing Units 2500 Alhambra Ave, Martinez 5 Construction 85% 01/15/24 $450,000 Hospital Enterprise Fund Completion of final spaces is pending access coordination with CCRMC staff. 83 Surgical Lights 2500 Alhambra Ave, Martinez 5 Construction 90% 02/28/24 $969,839 Hospital Enterprise Fund Final room in Trauma to begin mid- Oct 2023. OB-Gyn rooms to begin Jan 2024 due to staffing. 84 25 Allen Crisis Stabilization Unit 25 Allen Street, Martinez 5 Construction 95% 11/01/23 $2,322,571 CHFFA Grant Project nearing construction completion. Final inspections forthcoming this month. 85 Pittsburg Health Center Cooling Tower Replacement 2311 Loveridge Road, Pittsburg 5 Construction 85% 11/15/23 $1,902,000 Hospital Enterprise Fund Project nearing construction completion. 86 Sewer Line Segregation Above Pharmacy 2500 Alhambra Ave, Martinez 5 Construction 55% 05/01/24 $500,000 Hospital Enterprise Fund Construction is in phase 1 of 3. 87 Lab Automation 2500 Alhambra Ave, Martinez 5 Construction 60% 01/05/24 $1,512,360 Hospital Enterprise Fund Started construction on phase 3 of 4 on October 3. 88 New Public Health Trailer 2500 Alhambra Ave, Martinez 5 Post-Construction 95% 11/15/23 $600,000 5822 Covid Mitigation Funding & Public Health ELC State / Federal funding Construction is complete. Working on project closeout. 89 Martinez Inpatient Pharmacy (MIP) Modular Clean Room 2500 Alhambra Ave, Martinez 5 Post-Construction 98% 10/31/23 $818,000 Hospital Enterprise Fund Construction completed on September 6. Working on project closeout. 90 Pittsburg Health Center Elevators 2311 Loveridge Road, Pittsburg 5 Post-Construction 98% 11/15/23 $2,668,523 Hospital Enterprise Fund Construction is complete. Working on project closeout. 91 San Pablo Microhousing 2555 El Portal Drive, San Pablo 1 Construction 85% 12/29/23 $1,263,704 HUD Hums Grant Construction by lessor under build-to- suit arrangement is 75% complete. 79 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 Library 92 Antioch Library Re-Roof 501 W. 18th Street, Antioch 1 Pre-Construction 25% 06/30/24 $800,000 Measure X + State Library Grant Funds Construction is scheduled to start in April 2024, after rainy season. Public Defender 93 800 Ferry TIs 800 Ferry Street, Martinez 5 Construction 80% 11/30/23 $1,718,269 not noted on work request Construction is in phase 3 of 3. Public Works 94 Installation of EV Chargers - 30/40 Muir 30 Muir Road, Martinez 5 Construction 60% 03/15/24 $915,816 Measure X Electrical equipment supply chain issues will push construction completion past end of 2023. 95 10 Douglas Generator and EV Charger Infrastructure 10 Douglas Drive, Martinez 5 Construction 70% 06/01/24 $440,000 FLIP Funds Working on design changes for permit submittal. 96 MDF Pre-action Upgrades 1000 Ward Street, Martinez 5 Construction 80% 02/29/24 $1,000,000 General Funds - flip reserves Currently working on improvement at the second to the last module. 97 Flip Roof Replacement - 2467 Waterbird 2467 Waterbird Way, Martinez 5 Post-Construction 99% 10/15/23 $700,000 FLIP Funds Construction is complete. Working on project closeout. 98 Flip Roof Replacement - 2475 Waterbird 2475 Waterbird Way, Martinez 5 Post-Construction 99% 10/15/23 $225,000 FLIP Funds Construction is complete. Working on project closeout. 99 WCDF SGIP Battery 5555 Giant Highway, Richmond 1 Construction 15% 12/01/24 TBD Clean Energy Program Funding 30% design is complete. Major equipment has been ordered. 100 1980 Muir Rd Generator 1960/1980 Muir Road, Martinez 5 Post-Construction 99% 10/31/23 $700,000 Power Resilience Allocation Funds + Org 3623 Construction is complete. Working on project closeout. Sheriff 101 West County Re-entry, Treatment & Housing Facility (WRTH) 5555 Giant Highway, Richmond 1 Construction 45%07/15/25 $126,500,000 Org 2580 Waiting for State Fire Marshall & DCD permits. Limited soil excavation & disposal underway. 102 Security Cameras / Upgrade of Central Control 1000 Ward Street, Martinez 5 Construction 90% 03/08/24 $3,966,633 Org 2578/4948 Finalizing last components of the new security system 103 Intercom System / Video System Upgrade 5555 Giant Highway, Richmond 1 Construction 90% 03/08/24 $1,699,986 Org 2580/4955 Finalizing last components of the new security system Subtotal $ 232,254,972 80 No. Project Name Address Supv. Dist. Phase % Proj. Compl. Est. Proj. Compl. Date Estimated Project Budget Funding Source Comments CAPITAL PROJECTS REPORT - FINANCE COMMITTEE CURRENT ACTIVE PROJECTS 06/01/22-09/30/23 PROJECTS ON HOLD Contra Costa Fire Protection District 104 Fire Station 9 - Airport Site NEC of Marsh and Center, Pacheco 4 On Hold 25% TBD $800,000 FPD funding and financing Project is on hold and is expected to be cancelled. 105 Fire Station 5 - Battalion Office/Headquarters 205 Boyd Road, Pleasant Hill 4 On Hold 10% TBD $75,000 not noted on work request Project placed on hold by CCCFPD. 106 Fire Station 17 620 St. Mary's Road, Lafayette 2 On Hold 10% TBD $75,000 Fire District Capital Construction Fund Project placed on hold by CCCFPD. Health Services 107 20 Allen New Public Health Lab 20 Allen Street, Martinez 5 On Hold 5% TBD $25,000,000 Measure X Project put on hold pending CCRMC master plan to determine location for the new lab building. 108 CCRMC Lobby Redesign 2500 Alhambra Ave, Martinez 5 On Hold 40% TBD $150,000 Hospital Enterprise Fund Project on hold pending CCRMC master plan. 109 Reseal/Restripe Parking Lots 2500 Alhambra Ave, Martinez 5 On Hold 5% TBD $577,500 Hospital Enterprise Fund Project on hold pending CCRMC master plan. 110 CCRMC Security Camera Improvements 2500 Alhambra Ave, Martinez 5 On Hold 2% TBD $250,000 Hospital Enterprise Fund Project on hold pending CCRMC master plan. 111 Dog Park at Delta Landing 2101 Loveridge Road, Pittsburg 5 On Hold 5% TBD $350,000 CDHCD Grant On hold pending construction budget value engineering results for Brookside Dog Park project. 112 Handicap Parking Feasibility 595 Center Ave, Martinez 5 On Hold 5% TBD TBD General Fund On hold. 113 Demolish Bldgs at Richmond Maintenance Yard 845 Brookside Drive, Richmond 1 On Hold 10% TBD TBD Hospital Enterprise Fund On hold. Public Works 114 Organization of Archive Documents n/a 5 On Hold 15% TBD TBD General Fund Project on hold in favor of other CPM priorities. Subtotal $ 27,277,500 81 POTENTIAL SURPLUS PROPERTY REPORT 82 Address City Lot Size Comments Current Status POTENTIAL SURPLUS PROPERTY - VACANT LAND None POTENTIAL SURPLUS PROPERTY - IMPROVED SITES 100 38th Street Richmond 2.86 Acres Improvement with 83,884 square feet. 2-Story building with full basement. An Exclusive Negotiating Rights Agreement gives EDEN Housing until December 2025 to exercise an option to purchase the property. 210 O'Hare Oakley .62 Acres Sheriff Sub-Station Preparing to convey to the City of Oakley. Conveyance likely to be completed by the end of the year. POTENTIAL SURPLUS PROPERTY - FINANCE COMMITTEE 06/01/22-09/30/23 83