HomeMy WebLinkAboutAdopting 2015 Cost Allocation ResolutionKITTITAS COUNTY
BOARD OF COUNTY COMMISSIONERS
RESOLUTION NO. 2017-
A Resolution adopting the Kittitas County Public Health Department Simplified
Indirect Cost Allocation Plan
For
Year Ended December 31, 2015
WHEREAS, Kittitas County receives Federal Grant Dollars, and
WHEREAS, according to the United States Office of Management & Budget, 2 CFR Part 200,
Uniform Administration Requirements, Cost Principles and Audit Requirements for Federal Awards
(Uniform Guidance), Kittitas County Health Department needs to adopt a Simplified Indirect Cost
Allocation Plan, and;
WHEREAS, the County Auditor has reviewed the Simplified Indirect Cost Allocation Plan
and determined the Public Health Department's Indirect Cost Rate to be 31.01%, based on the
distribution base of direct salaries & wages of each division/program, and;
WHEREAS, the County Auditor has approved the Indirect Cost Rate of 29.50%; a slight
increase from the actual calculation to allow for a margin of error, and
WHEREAS, the attached documentation shows the calculation of the Indirect Cost Plan for the
Kittitas County Public Health Department as per the requirements for 2 CFR Part 200, Uniform
Administration Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform
Guidance).
NOW, THEREFORE BE IT RESOLVED that the Board of County Commissioners adopts
the Indirect Cost Rate for Kittitas County Public Health Department at 29.50%, based on the
distribution base of direct salaries & wages, for federal grant reimbursement as certified by the County
Auditor, effective January 1, 2017.
ADOPTED this 21St day of March, 2017
ATTEST
BOARD OF COUNTY COMMISSIONERS
KITTITAS COUNTY, WASHINGTON
Chairman
Vice -Chairman
Commissioner
Clerk of the Board/Deputy Clerk of the Board
KITTITAS COUNTY
CERTIFICATE OF COST ALLOCATION PLAN
This is to certify that I have reviewed the cost allocation plan submitted herewith and to
the best of my knowledge and belief:
(1) All costs included in this proposal for the period ended December 31, 2015 are to
establish cost allocations or billings starting January 1, 2017 are allowable in
accordance with the requirements of the Part; 2 CFR Part 200, "Uniform Administration
Requirements, Cost Principles and Audit Requirements for Federal Awards" and the
Federal award(s) to which they apply. Unallowable costs have been adjusted for in
allocating costs as indicated in the cost allocation plan.
(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
Federal awards 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.
declare that the foregoing is true and correct.
Governmental Unit: Kittitas County Central Services
Signature:
P ,,, tT t
Name of Official: Jerald V. Pettit
Title: Kittitas County Auditor
Date of Execution: January 1, 2017
The 2017 rate approved is 11.25%
Kittitas County Public Health Department
Simplified Indirect Cost Allocation Plan
For the Year Ended December 31, 2015
NARRATIVE
In order for the Kittitas County Public Health Department (KCPHD) to comply with federal
regulations in the Uniform Grant Guidance, a simplified Indirect Cost Allocation Plan is adopted
to be able to bill indirect costs to grants.
KCPHD's financial data from 2015 is used to formulate the 2017 Indirect Cost Allocation Plan.
The distribution base on which the indirect rate will be allocated is the direct salaries charged to
department's programs.
The department's costs are divided into two categories: administration costs and direct program
costs. Within the category of administration costs, only expenses incurred for common or joint
purposes and in support of all programs are considered indirect costs. The costs coded to
individual programs are considered direct costs.
DEFINITIONS
• All Other Direct Costs — the amount remaining from total costs less unallowable costs,
indirect costs, and direct salaries.
• Direct Costs — costs that can be identified specifically with a particular final cost
objective such as a particular award, project, service or other direct activity of an
organization.
• Direct Cost Base — the 2015 fiscal year salaries for each program within the public health
department.
• Exclusions — costs that are passed through or sub -granted to others are considered to be
excludable costs. Some salaries that were charged to administration are not included in
the indirect costs. Also, the portion of the department's supplies and services and charges
expenses that were determined to not be directly associated with administration duties
were excluded.
• Indirect Cost Allocation Plan — the documentation identifying, accumulating, and
developing rates based on the allowable costs of the public health administrative division.
These costs may be allocated to the individual programs and billed to the program grants.
• Indirect Cost Rate — a device for determining in a reasonable manner the proportion of
indirect costs each program should bear. It is the ratio of the indirect costs to a direct cost
base.
• Indirect Costs — those costs incurred for a common objective that benefits more than one
grant program or project. Such costs are not readily assignable to the cost objective
specifically benefitted.
• Uniform Grant Guidance — United States Office of Management & Budget document
establishing principles and standards for determining costs for Federal awards carried out
through grants, cost reimbursement contracts, and other agreements with governmental
units.
• TotaI Costs — the 2015 fiscal year financial data.
Unallowable Costs — certain costs specifically unallowable under the general and special
award conditions or agency instructions. These costs are defined by the Uniform Grant
Guidance.
INDIRECT FUNCTIONS
At KCPHD, the indirect functions are those administrative tasks completed and the costs
incurred to support all divisions of the department. Administration division costs for the fiscal
year 2015 totaled $368,179.03. Some of the costs included in this total are: the salaries for
administrative staff time; the purchase of office supplies, operating supplies, minor office
equipment; fees for professional services, telephone service, postage, travel, advertising, and
other such expenses that are necessary to support the multiple programs within the department.
Excludable costs that are a part of the Administrative division's totals include salaries and
benefits that were charged to the division but are not included in the indirect rate calculation
because they are not positions that were determined to be consistently engaged in full-time work
benefiting all programs. This exclusion includes 3 percent of the Public Health Administrator
and 2 percent of the Fiscal Analyst's time. This percentage was found on the actual costs charged
to the Developmental Disabilities program by the Administrator and Fiscal Analyst during 2015
compared to their total, respective, annual salary. Costs were also excluded from the calculation
based on the assumption that only 17.54 percent of the total costs charged to the division for
supplies, and services and charges would be used by the positions supported by the indirect rate.
This percentage was found by dividing the total number of budgeted FTE for 2015 by the
number of FTE supported by the indirect rate.
Excludable costs included in the Administrative division's totals included:
Salaries $12,760.22
Benefits $5,348.73
Supplies $3,503.46
Services and Charges $33.522.36
Total Excludable Costs $55,134.77
Unallowable costs included in the Administrative division's total include capital lease
expenditures and central services billings from the county.
Unallowable costs included in the Administrative division's totals included:
Capital Leases $3,127.08
Central Services Billing $96,076.79
Total Unallowable Costs $99,203.87
A summary of the department's indirect costs are as follows:
Total Administrative Division Costs $368,179.03
Less: Total Excludable Costs ($55,134.77)
Less: Total Unallowable Costs ($99,203.87)
Total Indirect Costs $213,840.39
DIVISIONS WITH DIRECT EXPENSES
In 2015, KCPHD had 27 active programs with total expenditures of $1,381,541.08. Of that
amount, $16,322.27 was related to excludable costs, which were passed through to Community
Health of Central Washington for their professional services in the Children and Youth with
Special Health Care Needs program and to the Kittitas County Community Network for their
professional service in the Tobacco Prevention grant. $10,526.54 was related to an unallowable
cost because it was used the mobile air monitors a capital expenditure for the Mobile Air
Monitoring grant.
Direct costs included $689,537.79 related to salaries. The final $665,154.48 was considered to be
allowable direct costs. These allowable costs include, but are no limited to:
• Operating supplies that were necessary to meet the deliverables of the contracts;
■ Professional services as prescribed by OMB Uniform Grant Guidance, page 110,
§200.459. These services were provided by individuals that possess skills not available
within the department and the services were necessary to carry out the scope of the
contract;
• Food that was purchased for a meeting or conference where the primary purpose is the
dissemination of technical information (OMB Uniform Grant Guidance, §200.432);
• Advertising communicating specific activities or accomplishments as part of the outreach
effort for grant deliverables (OMB Uniform Grant Guidance, §200.421);
• Equipment purchases that did not meet the county's threshold of a $5,000 minimum to be
considered capital equipment.
RATE RECOMMENDATION
In order to account for a margin of error in the calculation of the department's indirect cost rate,
it is recommended by the department's Fiscal Analyst to adopt a rate of 29.50%. This
recommendation would increase the 2017 rate 0.50% over the previous fiscal year's rate.
o Iqv^Dom ()qo
m
O
p of T In .-+ O O
O O
U
Vf m � w
a Mrn
*
y
0 m 00
m m
eNi �h
N N
C
H In
Y
O M w V1 to M m n m I, ko m N W N a m O w I, O m V N O O
v a M o m m n a M m M
w
a
O m
o a
O
W O w m 111 N W M In 00 Vl N 1� O r m O m m O N l0 M W of m m
a
O a
U
N V 00 m w w a w 00 w V1 w V O w w H N 00 a a a a m 0 1� m
to r vl m N m � m c oo In Oo In m c ao m .� m In In In In w .� w m
N
.•+
N m
N
N 1p V1 1p V O a a r-1 r-1 V lT r -I N r -I N O N e -I V1 V O lU
NIll
QN
N H H VT N H V} V} H M V} H a V1 1A Gl l0 a M V} T N N Vl
N N VT VT VT N V? Lf lA Vf V} V} VT N
10
to
N
W
i�A
w
O
L
u
u
p
cu
N In I� to d' m V M a N H I, l0 m In m m M m w w m m O a
01
O M
M N m a 0 m H N m H T m m m lD N m O t l(1 N 00 M O V N
C
d
a N O 10 m m Ol ul I-� H V I,: m O 4 T ri m m m W In V
V1 m N T m m 01 o m a of In w w m m M m 10 N to n to m V m
P
M
O P
N m
m
y
A
a O1 N n m O m Vl M O H r" Ol M O H In M W 01 W l0 H H H l0 H
m a N m 0 m n a a O n m O N a m m N Ol m N n
of
Ol
Ln
O1
a N N H V H H LT V H a T N m L V W a M VT M N N V
00
00
O
N
N N N N N VT V} L} 1A
O
o n
a
a
0000
Ian
A6
to
m o
V
o M
INn I--1 O
N n
N
H m 10
m
O
d Q
C
a,
N M
m
N H
C w
— u
n
N
n
C c4.
C
Vml
N n a M
O
tC
4L
Ln
.2 N
N L
^ V
O N
N l00 V O N
m I� m In In
1aIl INn
H a
' 6 ~
X
N N
N rNi ��A �mA M
INlI P
O N
W
H N N
N N
'
L O
H
O m
m H
y�
N W m N O N M O M m I H W H H m N 0 m N a In M m O a
Il l0 00 to l0 l0 M N d' O O N N Ol Vl Ol O N In l0 N I- H In N H l0
W m O m w
O 00 N Ol N O 1�
O H
.j
N
N N m N O O m M l0 W H O m to H V H a N H O O 1� H W In In
N m N W a I� to
m O
A
V_ m
O
u
W T O a O N V In H H N w H w t In w O n lD n m V N I,
O H llH W O H al l0 l7 Il 00 In W I� O v a W In m H to , N m V
a H lD vl m N I�
of a I� M a H O
n N
H r
W Ot n o1 N m N 01 00 Vl H N M N r -I a a a N m a 1- m m
ri m w a N m w
w O1
d
W VT m a H N to V? N I.- H V W N L? 1� M W I� N n V V H
0o W i/1 +/} a V} m
w a
1
n N N VT V V V} V V V? V N A N VT VT N N
N N n
ri
�
H
N
I
V
a�
c c
w �
x o
t w v
p
N
C
l7 «
w C
W
w •C ° O
w
Er
d= w
E
m O¢ ° '
CO c C w -O ° - +L+ I°i di
In m m °
N Ul
o c
c c
_
w c o o u H� Q 'Z o u a m °- ¢ N v u a
o
w a m Fa c - •c o - w v 'c In u w w E o
2 E 01 0 o °$ u w° o°°- w a c v
a •� •� w w— i
o. a.
s
w
w Z y = a E u c E v u E o^ m w o rc
n u E E n 'a c
In
a m 'c as E 9 j E a ° O o w v E a^ o o o '> ;?
> c
v¢ ¢ 'n ii u u
0 w - c E° o o L o o 0 0> o c
u- H 2 u H U a 'm O u In O N w w>
v
O
H
E
\ \ \ \ o
2 / 2 r\ 3 e}§ z
.�% ,\\/\\ \°§\° \
( £ ^ CO 0 { I } .) / ) / j
/ ± \ � L ƒ = s = _
_ 0 ■
_
co
$
2
) m
\ \
+ \
0
%
®2
2
0}
/ q m
& c\
e
■ _
e
_
_ 0-_
j
\
u 5
\ £
\
LL
\
} )
£
J
r
J
.
J
\ \ \ \ o
2 / 2 r\ 3 e}§ z
.�% ,\\/\\ \°§\° \
( £ ^ CO 0 { I } .) / ) / j
/ ± \ � L ƒ = s = _
_ 0 ■
_
co
$
2
) m
0
\
b o
®
_
¢§
m
/ q m
e )
_
■ _
_ ° _
\ M
}
j
\
}
/ o
}
2
/
} )
£
J
r
J
.
\ \ \ \ o
2 / 2 r\ 3 e}§ z
.�% ,\\/\\ \°§\° \
( £ ^ CO 0 { I } .) / ) / j
/ ± \ � L ƒ = s = _
_ 0 ■
_
$
2
) m
/ > m
\
b o
®
2�=
2 z
>
_
6 2
\) a
CL E e
= o
® 5
2 °
_
i <
7- G
_ c
/ o
� °
/
ƒ 2
�
\ \ \ \ o
2 / 2 r\ 3 e}§ z
.�% ,\\/\\ \°§\° \
( £ ^ CO 0 { I } .) / ) / j
/ ± \ � L ƒ = s = _
_ 0 ■
_
$
2
_
§ }
� °
�
j 3
� §