FTF HOMEVISITS EAST YR2 FY20 (01).PDF

Maricopa County — Formal (2019-07-31)

View PDF Item 103 Meeting page

Extracted text (via pymupdf_layout) 27755 characters
C-86-18-090-G-01

Line-Item Budget and Budget Narrative
SFY20 Line-Item Budget
Budget period: July 1, 2019 - June 30, 2020
Budget Category Line Item Description Requested Funds Total Cost
PERSONNEL SERVICES Personnel Services Sub Total $99,712
Salaries 0.25 FTE Supervisor $22,535
0.25 FTE Admin Assist $7,172
0.25 FTE Outreach Worker $10,330
1 FTE Nurse Home Visitor $59,675
EMPLOYEE RELATED EXPENSES Employee Related Expenses Sub Total $40,451
Fringe Benefits or Other ERE Variable 19.76% $19,703
Fixed $11,856/FTE $20,748
PROFESSIONAL AND OUTSIDE SERVICES Professional & Outside Services Sub $22,493
Total
Contracted Services NSO Expansion plus Annual Fees $9,156
NHV Orientation Training $5,419
Nurse Supervisor Training $2,918
Infant Mental Health Consultant $5,000
TRAVEL Travel Sub Total $6,668
In-State Travel Mileage $3,738
Out-of-State Travel NSO Orientation and Training $2,930
AID TO ORGANIZATIONS OR INDIVIDUALS Aid to Organizations or Individuals Sub Total $146,971
Subgrants or Subcontracts to Southwest Human Development 1.0 $146,971
organizations/agencies/entities FTE NHV
OTHER OPERATING EXPENSES Other Operating Expenses Sub Total $11,903
• Telephones/Communications Services $1,146
• Internet Access
• General Office Supplies $600
• Food $400
• Rent/Occupancy $2,616
• Utilities
• Furniture
• Postage
• Software (including IT supplies)
• Dues/Subscriptions
• Advertising
• Printing/Copying $2,500
• Equipment Maintenance
• Professional Development (Staff $1,440
Training, Conferences, Workshops,
Training Fees for Staff)
• Insurance
$2,500
• Program Materials
$701
• Program Supplies
• Scholarships
• Program Incentives
NON-CAPITAL EQUIPMENT Non-Capital Sub Total $8,238
Equipment $4,999 or less in value Vision and Hearing Screening Equip $6,238
Laptop Computer $2,000
Subtotal Direct Program Costs: $336,436
ADMINISTRATIVE/INDIRECT COSTS Total Ad:MI/Indirect $18,946
Indlrect/Admin Costs $18,946
Total $355,382 $355,382
Authorized Signature Date II //2//
Max Porter, Acting Director
Page I 2

SFY20 Budget Narrative
The budget narrative should provide a clear and concise description of how amounts were determined, including
calculations, for each proposed line item in the Line-Item Budget. If a budget category does not apply, either leave
blank or delete the category.
Personnel Services: $99,712
The salary rate for each position was determined according to MCDPH market range levels. Nurse salaries are
determined by YRs of nursing experience. Cost elements to implement Nurse Family Partnership (NFP) with
fidelity to the model were obtained directly from the Nurse Family Partnership National Service Office (NS0).
Costs were adjusted for local salary ranges, the required state mileage rate, and current training and material
costs. The budget reflects an estimated 2.5% increase in salary per YR.
Nurse Supervisor: Rae Edwards
The nurse supervisor will ensure effective program management and provide clinical supervision of the MCDPH
nurse home visitors and data entry staff. With an hourly rate of $43.17 x 2088 annual hours, 25% of which will be
charged to this grant for the 12-month grant cycle, or $22,535.
Nurse Home Visitors (NHV) Carrie McBride
The NHV will provide home-based preventive intervention with 25 young families/YR. The NHV will assess status,
teach, make referrals, and nurture the development of young parents across several domains of functioning, by
developing a therapeutic relationship. With an hourly rate of $28.58 x 2088 annual hours 100% which will be
charged to this grant for the 12-month grant cycle, or $59,675.
Data Entry/Adrnin Assistant: Channon Wroten
The data entry staff will provide efficient, accurate, and thorough entry of program and home visit data into the
national web-based Penelope and will support the nursing staff by organizing and storing NFP materials and client
files. With an hourly rate of $13.74 x 2088 annual hours, 25% of which will be charged to this grant for the 12-
month grant cycle, or $7,172.
Outreach/Health Educator Specialist: Xochitl Wilson
The Outreach/Educator Specialist will provide referral sources and assistance to families needing resources for
education, legal, child support, housing, food and career issues. Services will include coordination of client
socializations and graduations, participation in the bi-weekly NFP team meeting and the bi-weekly case
conference, and outreach and collaboration with other agencies serving pregnant women and young mothers in
the East Maricopa Region. With an hourly rate of $19.79 x 2088 annual hours, 25% of which will be charged to
this grant for the 12-month grant cycle, or $10,330.
Employee Related Expenses: $40,451
Variable of 19.76% of total salaries for Medicare, social security, unemployment, worker's compensation, long
term disability, life insurance, and Arizona State Retirement System.
Annual cost $19,703
Fixed Benefits are calculated @ $11,856.00 per 1 FTE, x 1.75 FTE's for medical and dental coverage.
Annual cost $20,748
Professional and Outside Services: $22,493
National Service Office Fees: $9,156
Annual program support: Nurse-Family Partnership National Service Office contributes to covering costs
associated with the following resources and services: Data system (ETO) operation and use; Reporting- NFP
routinely provides reports to agencies through (ETO) and the NFP Reporting Portal via the NFP Community;
Ongoing Nurse-Family Partnership nurse home visitor, supervisor, and administrator education; resource library;
conference calls; web forums; Nurse-Family Partnership Community resources; and maintenance of Visit-to-Visit
Guidelines and supporting materials; Community outreach materials. Also provided are the NEP marketing and
communications resources and guidance and a copy of the NFP Public Awareness Video, as well as updates and
Page I 3

regular monthly communications from the NFP National Service Office; Policy and Government Affairs, including
advocacy and educational work at federal and state levels. $8,328 of which 50% will be charged to this budget.
$4,164/12-month grant cycle
Annual Nurse Consultation Fee: Nurse Family Partnership contributes to covering costs associated with a Nurse-
Family Partnership Nurse Consultant providing the following support to supervisors: Monitoring reports based on
the supervisor and her/his team's activity and performance and providing support with quality improvement
initiatives; Structured, routine support for the supervisor in operations and clinical issues; Periodic visits to the
supervisor and NFP team. Clinical and supervisory coaching and consultation with the supervisor. $9,984.00 of
which 50% will be charged to this budget. $4,992/12-month grant cycle
Nurse Initial Education Tuition
Implementation of the NFP model requires an NHV complete Units One, Two & Three training from the National
Service Office. The cost of training in the first YR includes: NHV Initial Education Tuition+ Education Materials =
$5,419 Budgeted each YR in case of staff turnover.
Supervisor Initial Education Tuition
The NFP model requires that supervisors complete Units One through Four of the Supervisor Initial Training in
addition to Units One, Two, and Three of the Nurse Initial Education Training. Supervisor Initial Education Tuition
Units One through Four + Education Materials = $5,835.00 of which 50% will be charged to this budget.
$2,918/12-month grant cycle
Infant Mental Health Consultation
Contract services for 16 hours per month from endorsed ITMH consultant. The consultant will support the
supervisor in reflective practice, attend case conference staffing's weekly, and consult on complex
infant/mother dyads with nurse home visitors. $5,000/12-month grant cycle
Travel: $6,668
In State Mileage
This line item covers the nurse home visitors', outreach health educator, and nurse supervisor's travel related to
client visits and community outreach. The cost is calculated as:
$0.445 per mile x 400miles/month x 1 NHV = $2,136/ 12-month grant cycle
$0.445 per mile x 100 miles/month x 1 Nurse Supervisor = $5341 12-month grant cycle
$0,445 per mile x 200 miles/month x 1 Outreach Health Educator = $1,068/ 12-month grant cycle
$3,738/12-month grant cycle
Out of State Travel
All travel is following First Things First Travel Policies. Travel to Denver for Unit 2 of the Nurse Initial Education
Tuition, including air travel ($400), meals ($50/day x 5 days = $250), lodging ($180/night x 4 nights = $720), and
ground travel ($95). Total = $1,465.00. Budgeted each YR in case of staff turnover. Travel to Denver for Unit 4 of
the Supervisor Initial Education Tuition, including air travel ($400), meals ($50/day x 5 days = $250), lodging
($180/night x 4 nights = $720), and ground travel ($95). Total = $1,465.00.
$2,930/12-month grant cycle
Aid to Organizations or Individuals: $146,971
MCDPH will partner with Southwest Human Development to implement NFP; SWHD will provide 1 FTE NHV to
implement the full scope of NFP services with 25 clients in this region. The annual cost for SWHD will provide
salary ($88,555), ERE ($23,910), travel and training $3,813,Professional Development $974, NSO annual dues
($7,492), telephone ($524), internet ($874), postage ($150), graphics ($450), rent ($3,067), supplies ($125), food
for socializations ($100), programmatic materials ($2,326), laptop ($1,250) and indirect within the allowable
rate, 10% ($13,361).
Other Operating Expenses: $11,903
Telephone/Communication Services:
Includes phones, adaptors, and chargers. Cell phones are an essential element of home visiting program to ensure
the safety of the nurse home visitor and outreach worker. $95.46 x 12 months: $1,146/YR
Page I 4

Office Supplies:
Essential supplies such as materials for organizing and storing files, as well as client file folders, paper, pens
$600/YR
Food:
MCDPH will host 4 socialization events per year, 0$100.00 per event: $400.00/YR
Rent
Nurse Home Visitors and Outreach Worker will have access to cubicles at MCDPH as a primary workspace:
$124.56/month x 1.75 FTE's x 12 months= $2,616/YR
Printing/Copying:
Cost of printing handouts and program facilitators for clients.
25 families x $100112-month grant cycle: $2,500/YR
Professional Development:
Additional specialized professional development that individuals or the team may identify as a need, including
attending conferences and receiving the Dyadic Assessment of Naturalistic Caregiver-child Experiences (DANCE)
Education Program. All NFP nurse home visitors and supervisors are required to attend the DANCE Fundamentals
program after the first YR of work, which trains nurses to observe and provide parenting pathways that guide
interventions. After initial education, DANCE users must demonstrate proficiency to continue using the DANCE in
clinical practice. The annual recertification fee of $60/user covers an on-line proficiency evaluation, access to the
DANCE website, and unlimited use of the DANCE materials (after proficiency is demonstrated) until the user's
licensing end date. Costs include: Annual conference costs (Infant Mental Health, Prevent Child Abuse Az, FTF) for
NHV, Outreach Worker and Supervisor = $960.00 x 1.5 FTE = $1,440.00/12-month grant cycle.
Program Educational Materials
Support materials for families and for nurse home visitors to assist in the work they are doing with families beyond
NFP and PIPE handouts. The NFP program uses materials to assist in removing barriers, improve health education,
and reward healthy behavior including: completion of home visits, prenatal care, post-partum care and well child
care, up-to-date immunizations, etc. Our program strategy is to pair an appropriate item with a home visit theme.
It is also important for nurses to demonstrate how to nurture a relationship by acknowledging births, birthdays,
successes, NFP graduation, etc. with cards, photos, books, and developmental toys. Program Educational
Materials will also include education materials used and distributed at socialization events. Home Visitation
Education Materials: $100.00 x 25 families: $2,500/12-month grant cycle.
Program and Medical Supplies:
Items needed for home visiting nursing activities such as growth charts, disposable measuring tapes, scale
cloths, hand sanitizer, gloves, surfaces wipes, thermometer covers, nursing bags, baby dolls, etc. $701/12-
month grant cycle
Non-Capital Equipment: $8,238
Vision and Hearing Screening
A one-time purchase of equipment necessary to implement the Vision and Hearing Screening requirement.
Cost was determined by quotes obtained February 2018. It is anticipated that cost will be shared with another
FTE region.
OAE + Accessories = $5,240 of which 50%, will be charged to this budget $2,620
Spot Vision + Accessories = $7,236 of which 50% will be charged to this budget $3,618
Laptop Computer
Replace existing 2013 unit that Outreach staff is using. Quote = $2,000 for unit, mouse, and bag
Administrative/Indirect Costs: $18,946
Page I 5

For Maricopa County,
by and through its Department of Public Health
___________________________________ _______________
Bill Gates, Chairman, Board of Supervisors Date
APPROVED AS TO FORM:
______________________________________
Attorney for County Date
ATTEST:
______________________________________
Office of the Clerk of the Board Date

funded the I 7
FTEs through program 1.0 .25 .25 Page
program. Meets the Staffing Qualifications Yes/No** Yes Yes Yes
SOP
proposed
through the practice, NFP and clients, high risk families, in to data client support analyzing ensure the FTF observation activities and partners health
clinical to the to 25 with and and assists Provide sources accurate maintain and supervision annually. client
funded in fidelity Recruitment of up relationships women social families, outcomes, referral and support primary data improvement, model NHV reflective professional educational community events
partially Responsibilities standards with SOP. caseload emotional, of and and timely documentation, to oversight, NFP staff, the NFP include of with staff with coordinate socialization
FIRST fully or visits FTF of a therapeutic parenting needs goals support relationships of quality to quarterly, development plan marketing, building referrals,
Table are and highest home and the and physical, maintain and program supervision reporting, fidelity Responsibilities home and
and Key Roles Maintain Provide Model, management develop pregnant assess environmental establishing education, families, collection community referrals. Provide program SOP. the weekly, development Outreach, relationship facilitate education
THINGS Personnel and and in to
implementation/services of Child Home Nurse
FIRST Program the Standards Maternal Nurse Registered experience Maternal-Child Management
program with in NFP experience
W. for that align experience as an Nursing, supervisory Health, Nutrition
responsible years' experience in nursing in
qualifications NAU, 5 years' Science Arizona program in Public related Degree
directly Background/Expertise* include (SOP) 2013 3 of in of or
Must Practice BSN Nursing. Visitor Bachelor licensed years Experience Health, Bachelor's
individuals 2
those
- Title McBride/Nurse Edwards/Nurse Educator
Personnel Visitor Wilson/Outreach
Key Name/ Position Carrie Home Rae Supervisor Xochitl Health

I 8
.25 1.75 Page
the submitted. if any
of or Qualification
oversight Total: to be Practice
Yes Staff
Program need of
program not from
direct do Standards
compilations, have they FTF Exemption
with or indicated, the for 7/-7
report assist implement in
and needed outlined Request
monthly as directly otherwise FTF y//2
monitoring tasks the
entry, not unless Qualifications Date
data quality administrative who do but through
Daily data but time
program any Personnel/Staff approved
entry at been
data proposed requested the have
inventory sales, the be meet they
in through may
service, personnel standards,
Experience funded personnel
customer key
degree. partially key all Qualification
management for that
Associates management, individuals assure Staff
and descriptions I the
those - job document, meet hire. Director
Wroten/ Personnel and/or this do not to Acting
Assistant prior "-7//74.7-7
Channon Additional program. *Resumes signing personnel process Porter,
Office N/A By Max
**

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

Maricopa County
Depaitinent of Finance
Shelby L. Scharbach
CPA, CGFIVI
Assistant County
Manager and CERTIFICATE OF INDIRECT COSTS
Chief Financial Officer
301 West Jef Imon Street
Suiie Plincnix, 960 AZ 85003-2143 This is to certify that I have reviewed the indirect cost rate proposal submitted
Phone: 602.506-3561 herewith and to the best of my knowledge and belief:
Fax: 602.506-4451
www.maticopa.gov/Einmice 1. All costs included in this proposal dated July 1, 2016 to June 30, 2017 (FY17)
to establish billing or final indirect costs rates for July 1, 2018 to June 30,
2019 (FY19) 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, 2018

,• I • • i I I Safe I lt ;
Au:counting Safe Million Healthy Dietetic Community Access provement Seheol STAND Parent Nutrition Adolescent Smoke-free Healthy FIndHeitiPhe Digital Special Murketing& Public Collective Challenges Alliance Cloud Mancopa Health Coordinated Kids Preventive "Chronic !Behavioral Prescription Heart
Support to Routes Hearts Community internship Healthy to Plan Hearth IGNITE & Ambassador Physical & Health Arizona Arizona •reoemnr.dtj Content Information STEP for Strategy County Improvement Maricepa Health Disease Health Drug Systems
Support' School initiative Health foods Index/School Worites Social it Populations/Hispanic Stakeholder Youth for & Children and (HIPMCI Community integration Abuse intetraon
Design Worker Activity Program ,aPre2racnSmAdmy Youth Support County Collaborative &
Health Program Media Media Comm. with Partnership Health Misuse
Internship/ Irn- of
Unique Assessment
—
land
Health Office Wellness of Office Health Officer:if Office Office
Support Integtition of SChool and of
Innovations Community Initiatives Innovation Worksitt Marketing Communications Empowerment of-Community Innevatien ceofKoafthzare
Health
; I 1
f
ill Operations Program
Tram-formation Community
Ryan FirstTeeth Dental Nurse 'Newborn Lead t 'Scutt, Women,
White Sealant Family Hazard Phoenix Infants,
Dental First Intensive Control Healthy &
Program Partnership Care
Insuranse Program Start Children
Program vri l; ; it n"..aricopa
Health Adminictra Budget& Technical Human Departnent
Community „ GrusrtcMgrnt. Acquisition Office Professional
— • Action tioni & of Anance Services & Resources of
Office County
of Office Children Women, Public
Oral Health of Infants,
Health Family ormq
; and Grants/Contracts Procurement Health
-----
Improvement Performance
----
j
1 oiciaa.a :1
Office Office and °MCC of Office Office Viireliness Office Office
Hearth of tinprovernent of Response of Prornotian & of Registration of
POlicy Public Performance OFPreparedness Epidemiology Health Community Vital
Epidemiology
i
— I — ;
Public Healthcare Public fined Earth
Medical Refugee Hansen's Wbalth Preparedness Health Corrimunicable Data Care Death &
Lost Pharmacy Laboratory bercu los Clinic the for and Services Health immunizations
Records Is Health Disease Emergency Disease Certificates
Updated: Homeless Response Consultants
11/6/17 I

MARICOPA COUNTY
DEPARTMENT OF PUBLIC HEALTH
DESCRIPTION OF INDIRECT COSTS
FOR FY 2018/2019 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 May 2018.
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, Finance & Budget 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, 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, Office of Community Health Innovation and
Integration Support,
DISEASE CONTROL
This division is responsible for the Office of Preparedness & Response, Community
Wellness & Health Promotion (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 the distorting costs of capital
expenditures for grants, administrative costs in the grant fund not subject to
indirect, Central Service Costs, pass-through subrecipients and expenditures of the
discontinued program for Healthcare for the Homeless. The 2016/2017
expenditures used as grant base for calculating the indirect rate for 2018/2019 is
$31,464,782.14 ($45,177,895.56 total grant fund expenditures less
$13,713,113.42 in distorting costs $31,464,782.14 net base).

Public Health
Explanation of Amounts deducted from Base for Grant Indirect Calculation — FY 2019
• Object 8110 Healthcare, 8111 Dental, and 8120 General/Other Services under program codes with suffix 'sub'
reflect funds passed through to subrecipients and contractors, and therefore not subject to indirect.
• The Ryan White Dental program, object 8125 Insurance Services, reflects pass-through funds to Delta Dental
insurance. This grant only allows 10% of the direct services to be administrative/ indirect costs and therefore not
subject to indirect.
• Capital expenditures are exempt from indirect costs.
• The Cost Pool (POOL) amount represents indirect collected from the grants for the department share and the
spending of the indirect revenues. This includes the administration costs, which are not subject to indirect. An
indirect rate is not applied to the cost pool as this would be doubling up of indirect being applied to the already
collected indirect revenue and thus, should be excluded.
• Central Service Costs (CSCA) are deducted because this is the amount of indirect collected from the grants for
the county share.
Explanation of Grant Indirect Deductions — FY 2019

Public Health
Departmental Indirect Cost Allocation for Grants for FY 2018-2019
2CFR Part 200 County Wide $2,482,447.71
Indirect Cost
Allocated Rate Base Indirect Rate
County Wide Rate 2,482,498 31,464,782 7.9%
Departmental Rate 3,457,233 31,464,782 11.0%
5,939,681 18.9%
Rate base was calculated as defined below:
Total FY17 Expenditures for Public Health Grants 45,177,895.56
Less: Capital total for grant 900's -96,848.80
Less: Administration not subject to indirect (net of CSC.A) -3,390,747.60
Less: CSCA -1,779,992.20
Less: Internal Audit Costs -2,025.61
Less: Pass Thru Subreciplents -5,128,772.17
Less: VICH Discontinued Program -3,314,727.04
RATE BASE 31,464,782.14
Allocation of County Wide Cost
Basis:
Labor % of Labor Indirect Cost
General Fund (F100-0860) 6,313,003.47
Grant Fund (F532-13860) 26,521,616.15 100% 2,482,447.71
Special Revenue Fund (F265-0860) 4,005,601.26
TOTAL OPERATIONS* 36,840,220.88 100% 2,482,447.71
*Net of Admin Services Labor Costs
'Allocation of Public Health Admin Cost
Administration Services Labor:
Administration (100-0860-8601 ODIRAPPT) Less indirect (7950) 235,379.76
Administration (100-0860-8602 SPPT) Less Indirect (7950) 287,962.44
Administration (100-1)860-8630) Less Indirect (7950) 870,477.94
Administration (100-1)860-8632) Less Indirect (7950) 463,290.66
Administration (100-1)860-8640) Less Indirect (7950) 327,373.05
Administration (100-0860-8642) Less Indirect (7950) 555,923.23
Administration (265-0860-8630) Less Indirect (7950)
Administration (532-D860-8630) Less Indirect (7950)
Admin Services Labor Costs 2,740,407.08
Admin Services Non-Labor Costs (Less Capital/Central Services)** 2,061,910,44
TOTAL ADMINISTRATION 4,802,317.52
**Excluding Supplies & Services Allocation-Out (8050, 8720)
Basis:
Labor % of Labor Indirect Cost
Admin (100-D860-8601/02/30/32/40/42)** Allocated Out
General Fund (F100-D860) 6 313 003 47 17.14% 822,933.37
Grant Fund (F532-0860) 26,521,616.15 71.99% 3,457,232.85
Special Revenue Fund (F265-0860) 4,005,601.26 10.87% 522,151.30
TOTAL OPERATIONS* 36,840,220.88 100.00% 4,802,317.52
TOTAL ADMINISTRATION 2,740,407.08
TOTAL 39,580,627.96 100.00% 4,802,317.52
Recon Agrees To Pivot Table 39,580,627.96
**Net of Indirect (7950)
FY19 Public Health indirect Cost Allocation Nan 5-16-2018/Grant Fund V3 5/17/2018 2:06 PM