HomeMy WebLinkAboutC01-194 Consolidated Cost Allocation Plancot -(��- -fig
EXECUTIVE SUMMARY
CONSOLIDATED COST ALLOCATION PLAN
The Consolidated Cost Allocation Plan is required by the State that calculates related
support services of Social Services for reimbursement. The plan allocates allowable
costs of central services provided to functions responsible for accomplishing federally
assisted programs and grants. These costs were not reimbursed as direct program
costs by the State Agency (Colorado Dept of Social Services).
Comparison of the Net Allowable Costs and Indirect Rate Percentage:
2000 1999 1998 1997
Net Allowable Costs: $706,088 $665,087 $515,541 $313,796
Indirect Rate: 4.897% 4.973% 4.193% 2.728%
The State reimburses a percentage of these indirect costs. Reimbursement of indirect
costs are received 22 months after submittal, due to multiple year comparisons
required in the calculation formula. Therefore, Eagle County was reimbursed for
1997's indirect costs in 1999 and may be still be adjusted in 2001.
A full description of the State's reimbursement calculation is mailed by the State
Department of Human Services annually in the Cost Allocation Plan Statement.
Almost all of Eagle County's Net Allowable Costs increased as did all the salaries and
fringe benefits. Therefore, no significant change was made in the Cost Allocation
Plan's indirect rate.
yi (:j
Eagle County, Colorado
Consolidated Cost Allocation Plan
and Indirect Cost Rate
December 31, 2000
Eagle County, Colorado
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Table of Contents
Certification
Plan Narrative
Organization Chart
1
2
3 - 4
County Cost Allocation Plan and
Indirect Cost Rate 5 - 10
i
J
Eagle County, Colorado
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Certification
I hereby certify as the responsible official of Eagle County,
Colorado, that the information contained in this Consolidated Cost
Allocation Plan for the year ended December 31, 2000 is correct and
was prepared in accordance with the policies and procedures
contained in the FMC Circular 74 -4. I further certify that a
consistent approach has been followed in treating a given type of
cost as direct or indirect and that in no case have costs charged
as direct costs of Federally supported programs been included in
the direct costs reflected in the plan, to the best of my knowledge
and belief.
Chairman of Board of Commissioners
LZC0
EAGLE COUNTY, COLORADO
ATTEST:14 �z�/�
erk to the Board
June, 2001
1
j3
Eagle County, Colorado
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Plan Narrative
The Eagle County Consolidated Cost Allocation Plan includes the
allowable costs of services provided to grantee and central service
departments. It is prepared in accordance with the guidelines
described in FMC Circular 74 -4 and "Guide for Local Government
Agencies Establishing Cost Allocation Plans and Indirect Cost Rates
for Grants and Contracts with the Department of Health, Education,
and Welfare ", OASC 8.
The plan allocates otherwise allowable charges which are
specifically incurred and paid for the grantee department
(Department of Social Services) , or other departments which support
federal programs. These costs were not reimbursed as direct
program costs by the State Agency (Colorado Department of Social
Services). These allocations are shown on the schedules included
in the plan.
The plan then allocates allowable costs of central services
provided to functions responsible for accomplishing federally
assisted programs and grants.
Only the costs of those central services which could be identified
as benefitting the grantee department were allocated in the plan.
All amounts are rounded to the nearest dollar and percentages to
the nearest thousandth.
2
r Cz _
SUMMARY CHART
CITIZENS
STATE
I
COMMISSIONS
LEGISLATURE
I
AND
I
I
I
i
I
�
BOARDS
�
(
I
I
I
COUNTY COUNTY
I
I
I
I
I
COUNTY COUNTY
COUNTY
COUNTY
COUNTY
ASSESSOR CLERK
CORONER COMMISSIONERS
SHERIFF
SURVEYOR
TREASURER
(Public
I
Trustee)
I_ ---- --
OFFICE
I
I
I
STAFF
I
I
COUNTY
I
(
TRANSPORTATION
I
I
COUNTY
ATTORNEY
AUTHORITY
ADMINISTRATOR .
K,
OFFICES MANAGED
BY
COUNTY ADMINISTRATOR
COUNTY
ADMINISTRATOR
I
I OFFICE STAFF
ASSISTANT I - HEALTH & HUMAN SERVICES
ADMINISTRATOR I SOCIAL SERVICES `
GENERAL SERVICES -
EXTENSION
WEED 3 PEST
ANIMAL CONTROL -
EVENT MANAGEMENT -
COMMUNITY SERVICES -
FACILITIES MANAGEMENT -
INFORMATION SYSTEMS -
11
PUBLIC HEALTH
- FINANCE
BUDGET
ACCOUNTING
PURCHASING
DEBT SERVICE
u9s
FUND TRANSFERS
- HUMAN RESOURCES
- ENGINEERING
- COMMUNITY DEVELOPMENT
PLANNING & ZONING
BUILDING INSPECTION
ENVIRONMENTAL HEALTH
I HOUSING '
I
-AIRPORT
I
I
-PUBLIC WORKS
'ROAD & BRIDGE `
MOTOR POOL
LANDFILL
NOTE: ASTERISK (7 INDICATES THAT THE BOCC MUST APPROVE DIRECTOR APPOINTMENTS
4
Eagle County, Colorado.>
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Central Services Department
Treasurer
Administrative
Finance
Purchasing
Information Technology
Human Resources
Facility Management
Building Usage
Equipment Usage
Retirement
Property Insurance
Auditing /Special Services
Total
Indirect Rate Computation: Total Net Allowable Costs
Total Salaries and
Fringe Benefits
. Total
Expenditures Additions
417,574
335,021
400,530
76,658
741,318
234,278
1,555,210
Net
Allowable
Deductions Note Costs
396,695
284,768
372,493
68,992
667,186
217,879
1,537,673
7,123
9,718
6,833
421,806
45,705
3,760,589 491,185 3,545,686
5
706,088
14,419,115
1
2
3
4
5
6
7
8
9
10
11
20,879
50,253
28,037
7,666
74,132
16,399
17,537
7,123
9,718
6,833
421,806
45,705
706,088
4.897%
Eagle County, Colorado
C Consolidated Cost Allocation Plan
.F Year Ended December 31, 2000
Total
Department
Expenditures
Departments (Memo Only)
Assessor
Clerk & Recorders - Operations& Elect
Commissioners
Board of Equalization
Public Communications
District Attorney
Grants & Contributions
Sheriff - all Departments
Emergency Medical
Public Trustee/Treasurers Commissions
Coroner
Surveyor
Attorney
GIS
Nursing Services
Senior Services
WIC Program
Community Service Block Grant
Title III - Homemaker
Healthy Babies Grant
Immunization
Prenatal
EPSDT
RSVP
Vital Statistics
Health & Wellness
Ensure Program
Human Services Grants
Transportation
Child & Fam Svcs. Ad
Early Headstart
Senior Tax Workoff
Extension
Weed and Pest Control
County Fair /Fair Benefit
Animal Control
Employee Events
Human Resources - Employee Benefits
Engineering
Planning and Zoning
Building Inspection
Environmental Health
Housing
Road and Bridge Fund
Social Services Fund
Wrap Fund
Retirement Fund
Insurance Reserve Fund
Capital Improvements Fund
Sales Tax Eagle Valley Transportation
Sales Tax Eagle Valley Trails
Sales Tax Roaring Fork Valley - Transp.
Sales Tax Roaring Fork Valley - Trails
Transportaion Vehicle Replacement
Airport Fund
Conservation Trust Fund
Microwave Maintenance Fund
Contingent Fund
General Obligation Bond Fund
Justice Center Revenue Bond Fund
Joint Maint. Center Debt Service Fund
Capital Expenditure Fund
Construction Fund
Housing Fund
Landfill Fund
Motor Pool Fund
Health Insurance Fund
Enhanced E911 Fund
1,091,327
909,135
357,693
2,335
113,741
763,016
39,712
5,347,756
20,327
357,679
55,067
11,544
420,325
871,472
474,186
93,992
78,386
554
554
32,072
4,116
198,854
8,997
81,103
206
7,226
4,243
68,483
59,127
582
296,616
1,480
99,499
73,391
314,562
420,928
30,804
120,413
823,786
760,542
923,605
380,093
742,575
5,287,003
1,090,076
49,798
609,040
519,891
4,110,625
4,393,403
783,814
254,335
79,561
331,041
11,715,858
0
2,086
0
761,860
716,503
1,999,545
241,659
9,314,279
162,046
2,771,001
3,049,466
2,260,340
358,673
Department
Salaries
and Fringe
Benefits
951,711
773,648
194,097
2,129
74,201
0
0
3,799,694
0
74,108
16,569
11,544
373,647
173,096
402,547
82,146
77,576
554
554
29,748
4,107
83,558
8,612
38,111
0
0
0
0
43,519
582
141,381
1,400
49,837
29,056
38,676
328,665
30,804
38,866
558,083
573,917
682,330
346,655
116,025
1,276,122
872,614
0
587,058
0
0
228,290
29,770
0
0
0
601,187
0
0
0
0
0
0
0
0
5,882
306,384
360,055
0
0
Total 67,324,007 14,419,115
Eagle County, Colorado
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Note 1 The Treasurer's Department performs various. services related to the
Banking function for all departments. The amount of time involved for
2000 is estimated to be approximately 5% based on total Treasurers
transactions.
Note 2 The County Administrative Department performs various services related
to the Management function for all departments. The amount of time
involved for 2000 is estimated to be approximately 15% based on
departments directly managed by the County Administrator.
Note 3 The Finance Department performs various services related to the
Budgeting and Accounting functions for all departments. The amount of
time involved for 2000 is estimated to be approximately 7% based on
number of account numbers, budget amounts and warrants produced.
Note 4 The Purchasing Department performs various services related to the
Purchasing function for all departments. The amount of time involved for
2000 is estimated to be approximately 10% based on Purchase Orders
received and special central stores billings.
Note 5 The Information Technology Department performs various services related
to the Information Technology function for all departments. The amount
of time involved for 2000 is estimated to be approximately 10% based on
number computers serviceable by Information Technology.
Note 6 The Human Resources Department performs various services related to the
Personnel function for all departments. The amount of time involved for
2000 is estimated to be approximately 7% based on the number of
employees.
* Percents are estimated time devoted directly to Social Services by the Central Services
Departments.
7
C Eagle County, Colorado
Consolidated Cost Allocation Plan C
Year Ended December 31, 2000
Schedule A: BUILDING USAGE
Allowable Central
Square Percent of Service Department
Central Service Department Feet Time Spent Square Footage
Treasurer
2800
5.00%
140
Administration
2453
15.00%
368
Finance
1793
7.00%
126
Purchasing
50
10.00%
5
Information Technology
2641
10.00%
264
Facility Management
3500
10.00%
350
Human Resources
1075
7.00%
75
1,328
Square Foot Central Service Departments 1,328
Square Foot All County Departments 117,776
= 1.1276%
E:3
Eagle County, Colorado u
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Note 7 Facility Management (see Schedule A)
Facility Management Total Expenditure
% of Central Service Space to Total Space
Note 8 Building Usage (see Schedule A)
New Building Costs
% of Central Service Space to Total Space
Central Service Building Allocations
Years of Amortization
Total Central Service Departments
Building Usage
Note 9 Equipment Usage Charge
1,555,210
1.1276%
17,537
15,793,325
1.1276%
178,086
25 Years
7,123
9
Cost of
Percent of
Allocable
Central Service Department
Equipment
6.667%
Time Spent
Costs
Treasurer
119,704
7,981
5.00%
399
Administration
59,808
3,987
15.00%
598
Finance
46,532
3,102
7.00%
217
Purchasing
69,289
4,619
10.00%
462
Information Technology
770,820
51,391
10.00%
5,139
Facility Management
404,593
26,974
10.00%
2,697
Human Resources
44,074
2,938
7.00%
206
Total
9,718
9
Eagle County, Colorado
Consolidated Cost Allocation Plan
Year Ended December 31, 2000
Note 10 Retirement Charge - A 6% retirement benefit is paid on behalf of the employees
the County.
Note.11.1 Property Insurance Charge
Total Property Insurance Paid in 2000
iff
421,806
Retirement
Percent of
Allowable
Central Service Department
Wages
Retirement
Time Spent
Costs
Treasurer
208,750
12,525
5.00%
626
Administration
128,467
7,708
15.00%
1,156
Finance
239,633
14,378
7.00%
1,006
Purchasing
0
0
10.00%
0
Information Technology
231,150
13,869
10.00%
1,387
Facility Management
322,200
19,332
10.00%
1,933
Human Resources
172,717
10,363
7.00%
725
Total
6,833
Note.11.1 Property Insurance Charge
Total Property Insurance Paid in 2000
iff
421,806