ATTCHMNT F PH IND COST PLN FY1718 .PDF

ATTACHMENT F - PUBLIC HEALTH GRANTS INDIRECT COST PLAN FY17-18
(FOR ORIGINAL COPY)
FTF-RC035-19-0609-00 Page 172 of 232

Based on Actual Expenditures for the
Year Ended June 30, 2016
Maricopa County, Arizona

Maricopa County
Department of Finance
Shelby L. Seharbach
CPA, CGFM
As sis ta nt County
Manager and CERTIFICATE OF INDIRECT COSTS
Chief Financial Officer
301 West Jefferson Street
Suite 960 This is to certify that I have reviewed the indirect cost rate proposal submitted
Phoenix, KZ 85003-2143
Phone: 602.506-35M herewith and to the best of my knowledge and belief:
Fax: 602.5064451
www.maricopa.gov/finance 1. All costs included in this proposal dated July 1, 2015 to June 30, 2016 (FY16)
to establish billing or final indirect costs rates for July 1, 2017 to June 30,
2018 (FY18) are allowable in accordance with the requirements of the Federal
award(s) to which they apply and the provision of 2 CFR Part 200, Uniform
Administrative Requirements, Cost Principles and Audit Requirements for
Federal Awards. Unallowable costs have been adjusted for in allocating costs
as indicated in the indirect cost proposal,
2. All costs included in this proposal are properly allocable to Federal awards on
the basis of a beneficial or causal relationship between the expenses incurred
and the agreements to which they are allocated in accordance with applicable
requirements. Further, the same costs that have been treated as indirect
costs have not been claimed as direct costs. Similar types of costs have been
accounted for consistently and the Federal Government will be notified of any
accounting changes that would affect the predetermined rate
I declare that the foregoing is true and correct.
GOVERNMENT UNIT: Maricopa County
SIGNATURE:
NAME OF OFFICIAL: Shelby L. Scharbach
TITLE: Assistant County Manager - Chief Financial Officer
DATE OF EXECUTION: July 1, 2017

Epi
Consultants Epi Disease Response for the Clinic Disease Health Records
Certificates Disease Emergency and Homeless Health HIV/STD Tuberculosis Laboratory Pharmacy
Death Health Educators Non-Communicable Health Healthcare Public Hansen's Refugee Medical
& Immunizations Care Communicable Services Preparedness
Birth Child Nurse Data Public
a and Policy Performance Public Policy
Vital Community Health Preparedness Performance Improvement Health of Improvement Office of Health
of Registration & Promotion Office of Epidemiology Response Public Office
Office of Wellness of & Disease Control
Office Office
j==j and Family Health
Health Infants, Ida? of Health of Oral
it Office Office
County Public Resources aL.,=== nts Finance & Services Community Action
of Procurement & Professional Administration Health
Human •k...&,1r. Budget Technical 11
Maricopa Department Children Start Program Program Insurance
& Healthy Control Care Partnership Program
Infants, Intensive Sealant First Dental
Community Transformation Phoenix Hazard Family Teeth White
Women, South Lead Newborn !Nurse Dental First Ryan
1 I $
Healthcare Innovation Community Communications Marketing Health Initiatives
of of Empowerment Worksite Innovation School Community innovation
Office Office of and of of Wellness of
Office Office Health Office Office Health
I 1 and
Misuse of with Comm. Media Adrnin Program
Integration Abuse & integration Collaborative County Partnership (HIPMC) Support & Youth Youth Social Media Gps Worksites Program Activity Ambassador Programs Design
11/2/26 Drug Health Health Maricopa Improvement County and Children Challenges STEP for Information Stakeholder Populations/Hispanic & to Program Arizona Health Physical 1TE Initiative Internship Nutrition to School Community
Updated: Systems Disease Strategy for & Content directly Arizona & Youth IG N Hearts
Last Health Prescription Behavioral Chronic Preventive Safe Kids Health Maricopa Cloud Alliance Unique Collective Public Marketing Special Digital FindHelpPhx* *report Healthy Smokefree Adolescent Nutrition Parent & STAND & Million Dietetic Community Safe Routes Healthy

MARICOPA COUNTY
DEPARTMENT OF PUBLIC HEALTH
DESCRIPTION OF INDIRECT COSTS
FOR FY2017/2018 PLAN
CENTRAL SERVICE COST ALLOCATION PLAN COSTS
This category consists of countywide costs allocated to Public Health from the OMB
2 CFR Part 200 Cost Allocation Plan. These costs were allocated entirely to
administration and then allocated to various grant funded programs based on
salary and/or operating expenditures per grant agreements.
DEPARTMENTAL INDIRECT
The Departmental cost pool consists of costs that benefit all Public Health
divisions. These costs were allocated to the divisions based on salary and
operating expenditures. The following description of the organization is based
on the structure as of February 2017.
PUBLIC HEALTH DIRECTOR
The Department of Public Health is organized into six primary divisions consisting
of the Administration division, Community Transformation, Community Health
Action, Clinical Services, Disease Control and Program Operations and one quasi
division namely Performance Improvement. The Director and staff provide
oversight to these areas and ensure the fulfillment of their mission and
mandates. The administrative costs were allocated to the divisions based on
salary expenditures with the exception of the salary of the Public Health Director
which was retained in the General Fund as a mandated public health position.
ADMINISTRATION DIVISION
This division consists of four administrative units: Professional & Technical
Services, Human Resources, Budget & Finance and Procurement & Grants
Management. Professional & Technical Services provides facilities management
and strategic planning services.
PUBLIC HEALTH CLINICAL SERVICES
This division provides tuberculosis control, confidential counseling and testing
services for a variety of infectious diseases, health screening for new refugees to
the County, health services for the homeless, pharmacy support to the

Department and to clients, and lab support to the Department and to the
Correctional Health and Juvenile Probation departments.
COMMUNITY HEALTH ACTION
This division is responsible for the Office of Family Health, the Women, Infants
and Children (WIC) grant program and the Office of Oral Health.
COMMUNITY TRANSFORMATION
This division is responsible for the Office of Worksite Health Innovation, Office of
School Health & Wellness Initiatives and Office of Community Health Innovation.
DISEASE CONTROL
This division is responsible for the Office of Preparedness & Response,
Community Health Nursing (including childhood immunizations), Epidemiology
and Disease Surveillance, and Vital Registration — the registration of births and
deaths in Maricopa County.
PROGRAM OPERATIONS
This division is responsible for the Office of Healthcare Innovation, Office of
Community Empowerment and Office of Communications and Marketing. The
cost of Office of Office of Communications and Marketing was allocated to the
divisions based on salary expenditures.
PERFORMANCE IMPROVEMENT AND PUBLIC HEALTH POLICY
This team directly reports to the department director and consists of the Office of
Performance Improvement and Office of Public Health Policy.
GRANT PROGRAMS
This category was established to accumulate indirect costs to compute the
indirect rate for the Department of Public Health. The indirect rate cost base
was determined using total grant expenditures, less capital expenditures for
grants, administrative costs in the grant fund not subject to indirect, Central
Service Costs, and pass-through subrecipients. The 2015/2016 expenditures
used as grant base for calculating the indirect rate for 2017/2018 is
$32,267,595,89 (541,788,596.88 total grant fund expenditures less
$9,521,000.99 in distorting costs = $32,267,595.89 net base).

Public Health
Departmental Indirect Cost Allocation for Grants for FY2017-18
2CFR Part 200 County Wide 2,238,717.04
Indirect Cost
Allocated Rate Base Indirect Rate
County Wide Rate 2,238,717 32,267,596 6.9%
Departmental Rate 3,115,457 32,267,596 9.7%
5,354,174 16.6%
Rate base was calculated as defined below:
Total FY16 Expenditures for Public Health Grants 41,788,596,88
Less: Capital total for grant 900's -9,995.00
Less: Administration not subject to indirect (net of CSCA) -3,186,815.21
Less: CSCA -1,844,699,60
Less: internal Audit Costs -3,756.58
Less: Pass Thru- Subrecipients -4,475,734.60
RATE BASE 32,267,595.89
;Allocation of County Wide Cost
Basis:
Labor % of Labor indirect Cost
General Fund (100-860) 5,983,724.24
iGrant.PUnd,i(532461)- 25.4051.1.71;76 1,00% 2238,717;04
Special Revenue Fund (265-863) 3,828,672,49
TOTAL OPERATIONS* 35,463,568.49 100% 2,238,717,04
*Net of Admin Labor
Allocation of Public Health Acirnin Cost
Administration Services Labor:
Administration (100-860-8601 ODIR/SPPT) Less Indirect (0795) 231,178.00
Administration (100-860-8602) Less Indirect (0795) 332,429.52
Administration (100-860-8630) Less Indirect (0795) 806,287,42
Administration (100-860-8632) Less Indirect (0795) 440,606,84
Administration (100-860-8640) Less Indirect (0795) 307,731.,22
Administration (1.00-860-8642) Less Indirect (0795) 584,479.84
Administration (265-863-8630) Less Indirect (0795)
Single Audit Costs (532-861-8630) 3,756,58
Administration Services Labor 2,706,469.42
Administration Services Non-Labor (Less Capital/Central Services) 1,600,749,83
TOTAL ADMINISTRATIVE SERVICES 4,307,219,25
Basis:
Labor % of Labor Indirect Cost
Admin (100-860-8601/02/30/32/40/42)** Allocated Out
General Fund (1007860) 5,983,724,24 16.87% 726,751.20
-Grant Fund (532 8E) 25,651,171.76... 72 -33% 3,115,46 95- ;
Special Revenue Fund (265-863) 3,828,672.49 10,80% 465,010,50
TOTAL OPERATIONS* 35,463,568.49 100,00% 4,307,219,25
TOTAL ADMINISTRATIVE SERVICES 2,706,469,42
TOTAL 38,170,037,91 100.00% 4,307,219.25
Recon Agrees To Pivot Table 38,170,037.91
**Net of indirect (0795)
FY18 Public Health indirect cost Allocation Plan/Grant Fund 3/28/2017.2:42 PM