HomeMy WebLinkAboutAgreement A-16-432-3 with LPC Consulting Services.pdfAgreement No . 16-432-3
AMENDMENT Ill TO AGREEMENT 1
2
3
THIS AMENDMENT, hereinafter referred to as "Amendment Ill ", is made and entered into this
18th day of August , 2020 , by and between COUNTY OF FRESNO , a Political Subdivision
4 of the State of California , hereinafter referred to as "COUNTY", and LPC CONSUL TING
5 ASSOCIATES , whose address is 1451 River Park Drive , Sacramento , CA 95815 , hereinafter referred
6 to as "CONTRACTOR" (collectively the "parties ").
7 WHEREAS , COUNTY and CONTRACTOR entered into that certain Agreement , identified as
8 COUNTY Agreement No. 16-432 , effective July 1, 2016 , COUNTY Amendment No . 16-432-1 , effective
9 June 20 , 2017 and COUNTY Amendment No . 16-432-2, effective November 6 ,2018 , herein
1 O collectively referred to as COUNTY Agreement 16-432 , whereby , CONTRACTOR agreed to provide
11 prevention evaluation serv ices and Strategic Prevention Plan development as specified in Agreement
12 No . 16-432; and
13 WHEREAS , the parties desire to amend the Agreement regarding changes as stated below
14 and restate the Agreement in its entirety .
15 NOW, THEREFORE , for good and valuable consideration , the rece ipt and adequacy of which
16 is hereby acknowledged , COUNTY and CONTRACTOR agree as follows:
17 1. That effective July 1, 2020 , all references in existing COUNTY Agreement No . 16-432 ,
18 to "Revised Exhibit A " shall be changed to read "Revised Exhib it A-1 ", attached hereto and
19 incorporated herein by this reference .
20 2 . That effective July 1, 2020 , all references in existing COUNTY Agreement No . 16-432 ,
21 to "Revised Exhibit B" shall be changed to read "Revised Exhibit B-1 ". Revised Exhibit B-1 is attached
22 hereto and incorporated herein by this reference .
23 3 . That Section Two (2) "TERM " of existing COUNTY Agreement No. 16-432 , located on
24 Page Two (2), beginning on Line Twenty-Two (2) with the word "The" and ending on Page Two (2),
25 Line Twenty-Seven (27) with the word "performance " shall be deleted and replaced with the following :
26 "The te r m of th is Agreement shall be for a period of five (5) years , commencing on July
27 1, 2016 through and including June 30 , 2021 . This agreement may be extended for one (1) additional
28 consecutive six (6) month period upon written approval of both parties no later than thirty (30) days
- 1 -
- 2 -
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
prior to the first day of the next extension period. The DBH Director or her designee is authorized to
execute such written approval on behalf of COUNTY based on CONTRACTOR’s satisfactory
performance.”
4. That Subsection A of Section Four (4) “COMPENSATION”, of the existing COUNTY
Agreement No. 16-432, Section Four (4) “COMPENSATION”, located on Page Four (4), beginning on
Line Seven (7) with the letter “A” and ending on Page Four (4) Line Twenty-One (21) with
“($40,000.00)” be deleted in its entirety and replaced with the following:
“A. For actual services provided as identified in the terms and conditions of this
Agreement and Revised Exhibit A-1, COUNTY agrees to pay CONTRACTOR and CONTRACTOR
agrees to receive compensation as identified in Revised Exhibits B-1, “Budget,” attached hereto and
incorporated herein to this Agreement, contingent of confirmation of funding.
For the period July 1, 2016 through June 30, 2017, in no event shall actual services
performed be in excess of Ninety Thousand and No/100 Dollars ($90,000.00).
For the period July 1, 2017 through June 30, 2018, in no event shall actual services
performed be in excess of Eighty Thousand and No/100 Dollars ($80,000.00).
For the period July 1, 2018 through June 30, 2019, in no event shall actual services
performed be in excess of One Hundred Twenty Thousand and No/Dollars ($120,000.00).
For the period July 1, 2019 through June 30, 2020, in no event shall actual services
performed be in excess of One Hundred and Five Thousand and No/100 Dollars ($105,000.00).
For the period July 1, 2020 through June 30, 2021, in no event shall actual services
performed be in excess of One Hundred and Five Thousand and No/100 Dollars ($105,000.00).
If this agreement is renewed for an additional six (6) month period pursuant to Section
2, TERM, for the period July 1, 2021 through December 31, 2021, in no event shall actual services
performed be in excess of Forty Thousand and No/100 Dollars ($40,000.00).”
The total maximum compensation to be paid by COUNTY to CONTRACTOR upon
execution through December 31, 2021 shall not exceed Five Hundred Forty Thousand and No/100
Dollars ($540,000.00).”
///
- 3 -
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
5. That Section Eleven (11) “INSURANCE”, of the existing COUNTY Agreement No. 16-
432, located on Page Nine (9), beginning on Line Twenty-Three (23) with the number “11” and ending
on Page Eleven (11) Line Thirteen (13) with the word “better” be deleted and the following inserted in
its place:
“11. INSURANCE
Without limiting the COUNTY's right to obtain indemnification from
CONTRACTOR or any third parties, CONTRACTOR, at its sole expense, shall maintain in full force
and effect, the following insurance policies or a program of self-insurance, including but not limited to,
an insurance pooling arrangement or Joint Powers Agreement (JPA) throughout the term of the
Agreement:
A. Commercial General Liability
Commercial General Liability Insurance with limits of not less than Two
Million Dollars ($2,000,000.00) per occurrence and an annual aggregate of Four Million Dollars
($4,000,000.00). This policy shall be issued on a per occurrence basis. COUNTY may require
specific coverages including completed operations, products liability, contractual liability, Explosion-
Collapse-Underground, fire legal liability or any other liability insurance deemed necessary because of
the nature of this contract.
B. Automobile Liability
Comprehensive Automobile Liability Insurance with limits of not less than
One Million Dollars ($1,000,000.00) per accident for bodily injury and for property damages. Coverage
should include any auto used in connection with this Agreement.
C. Professional Liability
If CONTRACTOR employs licensed professional staff, (e.g., Ph.D., R.N.,
L.C.S.W., M.F.C.C.) in providing services, Professional Liability Insurance with limits of not less than
One Million Dollars ($1,000,000.00) per occurrence, Three Million Dollars ($3,000,000.00) annual
aggregate.
D. Worker’s Compensation
A policy of Worker's Compensation insurance as may be required by the
- 4 -
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
California Labor Code.
Additional Requirements Relating to Insurance
CONTRACTOR shall obtain endorsements to the Commercial General Liability
insurance naming the County of Fresno, its officers, agents, and employees, individually and
collectively, as additional insured, but only insofar as the operations under this Agreement are
concerned. Such coverage for additional insured shall apply as primary insurance and any other
insurance, or self insurance, maintained by COUNTY, its officers, agents and employees shall be
excess only and not contributing with insurance provided under CONTRACTOR's policies herein. This
insurance shall not be cancelled or changed without a minimum of thirty (30) days advance written
notice given to COUNTY.
CONTRACTOR hereby waives its right to recover from COUNTY, its officers, agents,
and employees any amounts paid by the policy of worker’s compensation insurance required by this
Agreement. CONTRACTOR is solely responsible to obtain any endorsement to such policy that may
be necessary to accomplish such waiver of subrogation, but CONTRACTOR’s waiver of subrogation
under this paragraph is effective whether or not CONTRACTOR obtains such an endorsement.
Within Thirty (30) days from the date CONTRACTOR signs and executes this
Agreement, CONTRACTOR shall provide certificates of insurance and endorsement as stated above
for all of the foregoing policies, as required herein, to the County of Fresno, Department of Behavioral
Health, Public Behavioral Health Division, 2085 E. Dakota Ave, Fresno, California, 93726, Attention:
LPC Consulting Associates Contract Staff Analyst, stating that such insurance coverage have been
obtained and are in full force; that the County of Fresno, its officers, agents and employees will not be
responsible for any premiums on the policies; that for such worker’s compensation insurance the
CONTRACTOR has waived its right to recover from the COUNTY, its officer, agents, and employees
any amounts paid under the insurance policy and that waiver does not invalidate the insurance policy;
that such Commercial General Liability insurance names the County of Fresno, its officers, agents and
employees, individually and collectively, as additional insured, but only insofar as the operations under
this Agreement are concerned; that such coverage for additional insured shall apply as primary
insurance and any other insurance, or self insurance, maintained by COUNTY, its officers, agents and
- 5 -
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
employees, shall be excess only and not contributing with insurance provided under CONTRACTOR's
policies herein; and that this insurance shall not be cancelled or changed without a minimum of thirty
(30) days advance, written notice given to COUNTY.
In the event CONTRACTOR fails to keep in effect at all times insurance coverage as
herein provided, the COUNTY may, in addition to other remedies it may have, suspend or terminate
this Agreement upon the occurrence of such event.
All policies shall be issued by admitted insurers licensed to do business in the State of
California, and such insurance shall be purchased from companies possessing a current A.M. Best,
Inc. rating of A FSC VII or better.”
6. COUNTY and CONTRACTOR agree that this Amendment III is sufficient to amend the
Agreement; and that upon execution of this Amendment III, the Agreement, Amendment I, Amendment
II and Amendment III together shall be considered the Agreement.
The Agreement, as hereby amended, is ratified and continued. All provisions, terms,
covenants, conditions and promises contained in the Agreement and not amended herein shall remain
in full force and effect.
///
///
///
///
///
///
///
///
///
///
///
///
///
1 IN WITNESS WHEREOF, the parties hereto have executed this Amendment Ill as of the
2 date first above set forth .
3
4 LPC CONSUL TING ASSOCIATES, INC.
\ '\! I -5 ~ It -u· ~
6 l+---1-y r~·C_', ,_· _'_J.. __ · _·_."'\---::::l~=---
7 (Authorized Signature) (_
Michele Darling, CEO
8 !+----------------Print Name & Title
9
10
1451 River Park Drive #100
11 Sacramento, CA 95815
12 Mailing Address
13
14
15
16
17
18 FOR ACCOUNTING USE ONLY :
19
20 Fund : 0001
21 Subclass : 10000
22 ORG: 56302081
23 Account: 7295/0
24
25
26
27
28
COUNTY OF FRESNO
Ernest Buddy Mendes, C rman of the
Board of Supervisors oft e County of
Fresno
ATTEST:
Bernice E. Seide l
Clerk of the Board of Supervisors
County of Fresno , State of California
By : ~ASADA ::::E:;.sbo::p
Deputy
-6 -
Revised Exhibit A-1
Page 1 of 5
SCOPE OF WORK
Extension for the Evaluation of Fresno County’s Youth Alcohol and Drug
Prevention Program and the Development of the 2021-2026 Strategic
Prevention Plan
This Scope of Work (SOW) is in response to the extension of Fresno County’s Youth Alcohol and Drug
Prevention Program due to the COVID-19 pandemic. The SOW is for the 2020-21 fiscal year so LPC can
continue:
• The evaluation of the Youth Alcohol and Drug Prevention Program in Fresno County, and
• Support for the development of the 2021-2026 Fresno County Strategic Prevention Plan.
This SOW addresses adding an additional year to the Evaluation of the Youth Alcohol and Drug Prevention
Program and assistance with the 2021-2026 Strategic Prevention Plan (SPP), and moving the development
of the Final Evaluation Report out by one year (to July 2021-December 2021) once the prevention
providers complete their work under the current funding cycle (ending June 2021).
The following table displays the shifts in the evaluation SOW timelines.
Table 1 | Revised Evaluation SOW Timelines
Component Existing Timeline Proposed Timeline
Evaluation of Prevention Programming July 2016-June 2020 July 2016-June 2021
Final Analysis and Evaluation Reporting July 2020-Dec 2020 July 2021-Dec 2021
2021-2026 Strategic Prevention Plan July 2018-June 2020 July 2020-Dec 2021
Evaluation of Youth Alcohol and Drug Prevention Program
LPC is evaluating the Youth Alcohol and Drug Prevention Program, which aims to:
• Decrease underage alcohol use by decreasing youth access to alcohol from adults and increasing
the average age of onset for alcohol use.
• Decrease marijuana use among youth and increase the average age of onset for youth using
marijuana by increasing education and awareness about the consequences of marijuana use.
• Decrease prescription drug and over-the-counter drug misuse by increasing public education and
awareness about the consequences of prescription misuse and increasing efforts for safe disposal
of medications.
The current evaluation is for the 2016 to 2020 funding cycle. Due to the COVID-19 pandemic, in April 2020
the prevention providers received approval for contract extensions to continue their work through June
2021. This SOW provides a list of activities to continue the evaluation and data collection activities through
June 2021 to align with the providers’ work.
Revised Exhibit A-1
Page 2 of 5
Evaluation Research Questions
The evaluation plan for Fresno County’s Youth Alcohol and Drug Prevention Program was developed to
address the following research questions.
Table 2 | Evaluation Research Questions
Questions Process Outcome
How are the funded prevention projects being implemented in Fresno County
countywide, and across sites? X
Who are the participants in the prevention programs? What are their demographic
characteristics and risk factors for substance use and abuse? X
What are the barriers to implementation and how have they been addressed? X
What lessons are being learned about prevention program implementation with specific
populations, in specific geographic regions of the county (e.g., urban and rural)? X
What is the impact on the program participants? X
How have knowledge, attitudes and beliefs change during the SPP? X
What is the impact of the program on behavior among individual participants? At the
school site and the County level? X
Evaluation Scope of Work
Table 3 details the proposed evaluation tasks and activities to continue data collection systems for the
extended contract year and enable LPC to develop a comprehensive Final Evaluation Report to measure
Youth Alcohol and Drug Prevention Program outcomes that address the 2015-2020 Fresno County
Strategic Prevention Plan.
Table 3 | Proposed FY2020/21 Evaluation SOW
Tasks and Activities Milestones and
Deliverables
Timeline
Conduct annual interviews with program staff via Zoom. Interview data July 2020
Collect all outstanding quantitative and qualitative data from
providers for FY2019/2020 July 31, 2020
Review revised provider SOWs and update provider evaluation
workplans for FY2020/2021
Evaluation workplans
for each provider August 2020
Analyze data and draft FY2019/2020 Evaluation Report Annual evaluation
report September 30, 2020
Update all data collection tools for FY2020/2021, and develop any
new tools based on providers’ SOW Data collection tools September 2020
Develop web-based Fresno County Student Insight Survey as an
option for survey administration. Web-based survey September 2020
Present FY2019/2020 Annual Evaluation Report findings and Zoom Presentation By December 15, 2020
Revised Exhibit A-1
Page 3 of 5
Tasks and Activities Milestones and
Deliverables
Timeline
recommendations via Zoom to the Fresno County Behavioral
Health Board
Provide technical assistance to providers on methods for
administering and collecting the Student Insight Survey. Completed surveys Ongoing
Participate in providers’ Advisory/Workgroup/Coalition meetings
via Zoom.
Meeting notes and
agendas Quarterly
Participate in Fresno County’s Quarterly Prevention Provider
meetings via Zoom.
Meeting notes and
agendas Quarterly
Request and analyze provider implementation data and develop
Quarterly Data Dashboards at provider and county level.
Quarterly data
dashboards
Quarterly
Conduct annual focus groups with program participants and
interviews with program staff via Zoom.
Interviews and focus
group data May-June 2021
As mentioned previously, the one-year extension of the current funding cycle would push the
comprehensive final evaluation reporting period from July-December 2020 to July-December 2021, once
the prevention work has concluded. The SOW for this six-month period will remain the same (see
Attachment A for revised dates for activities).
Strategic Prevention Plan Scope of Work
Currently, four of the six state mandated Strategic Prevention Plan (SPP) chapters are complete. The
extension of the 2020-21 SPP contract, will enable LPC to continue assisting Fresno County staff with the
development of the final two state mandated SPP chapters (i.e., Implementation and Evaluation). The
SOW or tasks for completing the SPP are outlined in Table 4.
Fresno County staff plans to release and award the Prevention Provider RFP prior to initiating the
development of the final two SPP chapters. In addition, based on previous experience, the timeline for
the state to provide SPP edits is variable. As a result, the timeline for completing the SPP is “to be
determined,” except for completing the work by May 2021.
Table 4 | Strategic Prevention Plan SOW
Tasks and Activities Milestones and
Deliverables
Review the Assessment, Capacity Building, and Planning chapters of the SPP, and then
meet with State and County staff to draft a timeline for completing the final two
chapters of the SPP. This meeting will also provide an opportunity to receive input
from the State Technical Assistance provider about the content they expect to see in
the Implementation and Evaluation Chapters of the SPP.
SPP Calendar
Review contracted prevention provider scopes of work submitted through prevention
provider RFP process to inform the development of the Implementation chapter. If
necessary, schedule meetings with the providers to ask clarifying questions.
Draft tasks and timeline
for implementation
chapter
Develop SPP Implementation chapter with County staff assistance Draft Implementation
chapter
Revised Exhibit A-1
Page 4 of 5
Tasks and Activities Milestones and
Deliverables
Edit Implementation chapter per input received from County staff and State Final Implementation
chapter
Develop Evaluation Chapter Draft Evaluation
Chapter
Edit Evaluation chapter based on input received from County staff and State Final Evaluation
Chapter
Compile SPP Final Chapters and Appendix Final SPP
Revised Exhibit A-1
Page 5 of 5
Attachment A
Timeline for Final Report from Original Contract and Revised Dates Due to Extension
Tasks and Activities
Original
Timeline
Revised
Timeline
For each prevention provider, analyze qualitative data to describe program
implementation, successes, challenges and barriers, and accomplishments.
7/31/20 7/31/21
Analyze qualitative data on feedback from participants, and reflections from
stakeholders.
7/31/20 7/31/21
Draft comprehensive evaluation report that includes an annual summary for year
four.
9/30/20 9/30/21
Present final comprehensive report findings and recommendations to the Fresno
County Behavioral Health Board
By 12/31/20 By 12/15/21
Revised Exhibit B-1
Page 1 of 6
Employee Salaries
Acct #Position FTE Admin Direct Total
1101 Senior Associate II 0.19 20,360$ 20,360$
1102 Senior Associate II 0.29 28,082 28,082
1103 Data Visualist 0.14 4,368 4,368
1104 Research Associate II 0.02 1,244 1,244
1105 Research Associate I 0.05 2,203 2,203
1106 Office Manager 0.04 1,889 1,889
1107 Data Systems Manager 0.01 800 800
Personnel Salaries Subtotal 0.74 1,889$ 57,057$ 58,946$
Employee Benefits
Acct #Admin Direct Total
1201 271$ 13,291$ 13,562$
1202 5 228 233
1203 163 7,981 8,144
439$ 21,500$ 21,939$
Payroll Taxes & Expenses:
Acct #Admin Direct Total
1302 136 6,663 6,799
1303 3 169 172
1304 1 42 43
1305 - 7 7
140$ 6,881$ 7,021$
2,468$ 85,438$ 87,906$
3000: OPERATING EXPENSES
Acct #Amount
3001 597$
3003 1,012
3005 36
3007 117
3009 351
2,113$
4000: FACILITIES & EQUIPMENT
Acct #Amount
4002 7,511
4005 81
7,592$
AOD Prevention Program Evaluation
LPC Consulting Associates, Inc.
Fiscal Year (FY) 2020-21
Description
Payroll Taxes & Expenses Subtotal:
Line Item Description
Line Item Description
TRAIN-CA
EMPLOYEE SALARIES & BENEFITS TOTAL:
PROGRAM EXPENSES
FACILITIES/EQUIPMENT TOTAL:
1000: SALARIES & BENEFITS
OPERATING EXPENSES TOTAL:
Retirement
Worker's Compensation
Health Insurance
FICA/MEDICARE
SUI
FUTA
Employee Benefits Subtotal:
Description
Security
Staff Appreciation
Subscriptions & Memberships
Rent/Lease Building
Staff Development & Training
Office, Household & Program Supplies
Telecommunications
Revised Exhibit B-1
Page 2 of 6
5000: SPECIAL EXPENSES
Acct #Amount
5005 1,591
1,591$
6000: ADMINISTRATIVE EXPENSES
Acct #Amount
6002 488
6003 4,005
6006 860
6008 219
6009 186
6010 3
6011 37
5,798$
Acct #Amount
8201 Realignment 15,750$
15,750$
Acct #Amount
8404 89,250
89,250$
Line Item Description
Professional Liability Insurance
Accounting/Bookkeeping
ADMINISTRATIVE EXPENSES TOTAL
NET PROGRAM COST:
PROGRAM FUNDING SOURCES
105,000$ TOTAL PROGRAM EXPENSES
SB 920
Line Item Description
8400 - OTHER REVENUE
TOTAL PROGRAM FUNDING SOURCES:105,000$
-$
OTHER REVENUE TOTAL
Line Item Description
REALIGNMENT TOTAL
8200 - REALIGNMENT
SPECIAL EXPENSES TOTAL:
IT/Network Expenses
Legal Fees
Bank and credit Card Fees
Payroll Services
Line Item Description
Licenses and Permits
Taxes
Revised Exhibit B-1
Page 3 of 6
ACCT #LINE ITEM AMT DETAILED DESCRIPTION OF ITEMS BUDGETED IN EACH ACCOUNT LINE
1000: SALARIES & BENEFITS 87,906
Employee Salaries 58,946
1101 Senior Associate II 20,360 Co-manage evaluation of prevention initiative, Assist Fresno DBH-SUDS staff in drafting
Strategic Prevention Plan (SPP)
1102 Senior Associate II 28,082 Co-manage evaluation of prevention initiative, Assist Fresno DBH-SUDS staff in drafting
Strategic Prevention Plan (SPP)
1103 Data Visualist 4,368 Create data visualizations, graphics, dashboards
1104 Research Associate II 1,244 Assist with evaluation of prevention initiative
1105 Research Associate I 2,203 Assist with evaluation of prevention initiative
1106 Office Manager 1,889 Provide administrative, fiscal support
1107 Data Systems Manager 800 Assist with evaluation of prevention initiative, data systems
Employee Benefits 21,939
1201 Retirement 13,562 employer retirement contributions
1202 Worker's Compensation 233 Workers' compensation coverage
1203 Health Insurance 8,144 health and dental insurance for employees
Payroll Taxes & Expenses:7,021
1301 OASDI -
1302 FICA/MEDICARE 6,799 Social Security tax and Medicare tax on employee earnings
1303 SUI 172 State Unemployment Tax
1304 FUTA 43 Federal Unemployment Tax
1305 TRAIN-CA 7 Employment Training Tax (ETT)
3000: OPERATING EXPENSES 2,113
3001 Telecommunications 597 telephone and internet service
3003 Office, Household & Program Supplies 1,012 office supplies
3005 Staff Development & Training 36 staff development
3007 Subscriptions & Memberships 117 staff membership to American Evaluation Association
3009 Staff Appreciation 351 workplace appreciation to support employee morale
4000: FACILITIES & EQUIPMENT 7,592
4002 Rent/Lease Building 7,511 building rent
4005 Security 81 building security/HIPAA compliance
5000: SPECIAL EXPENSES 1,591
5005 IT/Network Expenses 1,591 software subscriptions, network support services, tech support services
6000: ADMINISTRATIVE EXPENSES 5,798
6002 Professional Liability Insurance 488 professional liability (errors & omissions) insurance
6003 Accounting/Bookkeeping 4,005 bookkeeping and accounting services
6006 Payroll Services 860 payroll service + 401k plan administration fees
6008 Legal Fees 219 legal services
6009 Bank and credit Card Fees 186 banking fees
6010 Licenses and Permits 3 local business license
6011 Taxes 37 local taxes
TOTAL PROGRAM EXPENSE FROM BUDGET NARRATIVE:105,000
TOTAL PROGRAM EXPENSES FROM BUDGET TEMPLATE:105,000
BUDGET CHECK:-
AOD Prevention Program Evaluation
PROGRAM EXPENSE
LPC Consulting Associates, Inc.
Fiscal Year (FY) 2020-21 Budget Narrative
Revised Exhibit B-1
Page 4 of 6
Employee Salaries
Acct #Position FTE Admin Direct Total
1101 Senior Associate II 0.06 -$ 6,749$ 6,749$
1102 Senior Associate II 0.11 - 10,801 10,801
1103 Data Visualist 0.08 - 2,330 2,330
1104 Office Manager 0.02 922 - 922
1105 Data Systems Manager 0.02 - 1,851 1,851
Personnel Salaries Subtotal 0.29 922$ 21,731$ 22,653$
Employee Benefits
Acct #Admin Direct Total
1201 102$ 5,006$ 5,108$
1202 2 86 88
1203 61 3,006 3,067
165$ 8,098$ 8,263$
Payroll Taxes & Expenses:
Acct #Admin Direct Total
1301 -$ -$ -$
1302 51 2,510 2,561
1303 1 64 65
1304 - 16 16
1305 - 3 3
52$ 2,593$ 2,645$
1,139$ 32,422$ 33,561$
3000: OPERATING EXPENSES
Acct #Amount
3001 225$
3003 381
3005 14
3007 44
3009 133
797$
4000: FACILITIES & EQUIPMENT
Acct #Amount
4002 2,829
4005 30
2,859$
AOD Prevention Program Evaluation
LPC Consulting Associates, Inc.
Fiscal Year (FY) 2021-22
PROGRAM EXPENSES
1000: SALARIES & BENEFITS
Description
Employee Benefits Subtotal:
Description
OASDI
FICA/MEDICARE
SUI
Retirement
Worker's Compensation
Health Insurance
FUTA
TRAIN-CA
Payroll Taxes & Expenses Subtotal:
EMPLOYEE SALARIES & BENEFITS TOTAL:
Line Item Description
Subscriptions & Memberships
Staff Appreciation
Telecommunications
Office, Household & Program Supplies
Staff Development & Training
Security
OPERATING EXPENSES TOTAL:
Line Item Description
Rent/Lease Building
FACILITIES/EQUIPMENT TOTAL:
Fresno County Department of Behavioral Health Contract Budget Template Revised 2/7/2020
Revised Exhibit B-1
Page 5 of 6
5000: SPECIAL EXPENSES
Acct #Amount
5005 599
599$
6000: ADMINISTRATIVE EXPENSES
Acct #Amount
6002 184
6003 1,509
6006 323
6008 83
6009 70
6010 1
6011 14
2,184$
Acct #Amount
8404 40,000
40,000$
SPECIAL EXPENSES TOTAL:
Line Item Description
IT/Network Services
Line Item Description
ADMINISTRATIVE EXPENSES TOTAL
Legal Fees
Bank and Credit Card Fees
Licenses and Permits
Taxes
Professional Liability Insurance
Accounting/Bookkeeping
Payroll Services
PROGRAM FUNDING SOURCES
TOTAL PROGRAM EXPENSES 40,000$
OTHER REVENUE TOTAL
TOTAL PROGRAM FUNDING SOURCES:40,000$
NET PROGRAM COST: -$
8400 - OTHER REVENUE
Line Item Description
SB 920
Fresno County Department of Behavioral Health Contract Budget Template Revised 2/7/2020
Revised Exhibit B-1
Page 6 of 6
ACCT #LINE ITEM AMT DETAILED DESCRIPTION OF ITEMS BUDGETED IN EACH ACCOUNT LINE
1000: SALARIES & BENEFITS 33,561
Employee Salaries 22,653
1101 Senior Associate II 6,749 Conduct analysis of cumulative evaluation data, writing/editing narrative
1102 Senior Associate II 10,801 Conduct analysis of cumulative evaluation data, writing/editing narrative
1103 Data Visualist 2,330 Create data visualizations, graphics, presentations; format final report
1104 Office Manager 922 Provide administrative, fiscal support
1105 Data Systems Manager 1,851 Develop data queries, analyses; data systems management
Employee Benefits 8,263
1201 Retirement 5,108 employer retirement contributions
1202 Worker's Compensation 88 Workers' compensation coverage
1203 Health Insurance 3,067 health and dental insurance for employees
Payroll Taxes & Expenses:2,645
1302 FICA/MEDICARE 2,561 Social Security tax and Medicare tax on employee earnings
1303 SUI 65 State Unemployment Tax
1304 FUTA 16 Federal Unemployment Tax
1305 TRAIN-CA 3 Employment Training Tax (ETT)
3000: OPERATING EXPENSES 797
3001 Telecommunications 225 telephone and internet service
3003 Office, Household & Program Supplies 381 office supplies
3005 Staff Development & Training 14 staff development
3007 Subscriptions & Memberships 44 staff membership to American Evaluation Association
3009 Staff Appreciation 133 workplace appreciation to support employee morale
4000: FACILITIES & EQUIPMENT 2,859
4002 Rent/Lease Building 2,829 building rent
4005 Security 30 building security/HIPAA compliance
5000: SPECIAL EXPENSES 599
5005 IT/Network Services 599 software subscriptions, network support services, tech support services
6000: ADMINISTRATIVE EXPENSES 2,184
6002 Professional Liability Insurance 184 professional liability (errors & omissions) insurance
6003 Accounting/Bookkeeping 1,509 bookkeeping and accounting services
6006 Payroll Services 323 payroll service + 401k plan administration fees
6008 Legal Fees 83 legal services
6009 Bank and Credit Card Fees 70 banking fees
6010 Licenses and Permits 1 local business license
6011 Taxes 14 local taxes
TOTAL PROGRAM EXPENSE FROM BUDGET NARRATIVE:40,000
TOTAL PROGRAM EXPENSES FROM BUDGET TEMPLATE:40,000
BUDGET CHECK:-
AOD Prevention Program Evaluation
LPC Consulting Associates, Inc.
PROGRAM EXPENSE
Fiscal Year (FY) 2021-22 Budget Narrative