Loading...
HomeMy WebLinkAboutResolution Adopting 2024 Indirect Cost AllocationStaff Report by: Brian Carlson Budget and Finance Director Topic: Annual (2024) Indirect Cost Allocation Plan Meeting BOCC Regular Meeting Tuesday April 2nd, 2024 Summary: • The attached Resolution and plan documents reflect the County’s internal allocation of administrative costs. • This is presented annually to BOCC. Public Health and Sheriff each produce similar annual cost-rate plans. • The Auditor’s recommended rate is 13% Background: • Indirect Cost Allocation refers to the cost of certain county departments to provide services to other County Departments. This enables a quantifiable, reasonable and consistent way to offset the County’s costs to administer grants. • Indirect Cost Allocation is also applicable to certain County contracts, and for internal accounting and budgeting, e.g. Departments and/or Funds pay one another for the provision of services. • A cost allocation plan is required for most Fed grant recipients. A plan’s threshold requirements are established by the Federal Office of Management and Budget. • The rate calculation is formula-driven, and uses the most-recent audited financial data. Therefore, there is commonly a two-year lag for implementation of a given rate. E.g. 2022 data is used to establish a rate for operations in 2024. • The rate calculation is forwarded to the County Auditor, who then commonly applies a margin of error to arrive at a final “certified” rate. The Certified rate is forwarded to BOCC for review/approval. Analysis: • The current plan and recent history are shown below: • The recommended “adopted” rate is proposed by the Auditor following his review of the calculated figures. • Additional plan information and calculations are contained in the attached 2023 Indirect Cost Allocation Plan Conclusion / Next Steps: • Approve resolution adopting central services cost allocation plan Effective Year 2021 2022 2023 2024 Actual Rate 13.36%16.89%13.25%13.00% Adopted Rate 12.75%15.00%13.30%13.00% Variance 0.61%1.89%0.05%0% KITTITAS COUNTY BOARD OF COUNTY COMMISSIONERS RESOLUTION NO. 2024-___ A Resolution Adopting a Central Services Simplified Indirect Cost Allocation Plan for Budget Year 2024 WHEREAS, Kittitas County is a recipient of Federal grant awards, and WHEREAS, pursuant to CFR Title 2, Subtitle A, chapter II, Part 200, Uniform Administrative Requirements, Cost Principles, and audit Requirements for Federal Awards, local government grant recipients are required to adopt a central services simplified indirect cost allocation plan in order to claim such costs for reimbursement, and WHEREAS, the County Auditor has determined the Indirect Cost Rate to be 13%, based on the fair and equitable distribution base of direct salaries & wages of each department/fund, and; WHEREAS, the County Auditor has certified the Indirect Cost Rate of 13.0%, equal to the actual calculation; and WHEREAS, the attached documentation shows the calculation s of the Indirect Cost Plan for Kittitas County 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 at 13% based on the fair and equitable distribution base of direct salaries & wages, for federal grant reimbursement as certified by the County Auditor, effective January 1, 2024. ADOPTED this 2nd day of April, 2024. BOARD OF COUNTY COMMISSIONERS KITTITAS COUNTY, WASHINGTON Chairman Vice-Chairman ATTEST Commissioner _________________________ 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, 2022 are to establish cost allocations or billings starting January 1, 2024 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. I declare that the foregoing is true and correct. Governmental Unit: Kittitas County Central Services The 2024 rate approved is 13% Signature: ____________________________ Name of Official: Bryan Elliott Title: Kittitas County Auditor Effective Date: January 1, 2024 Kittitas County Central Services Simplified Indirect Cost Allocation Plan Effective January 1, 2023 SUMMARY The following Central Services Indirect Cost Allocation Plan (“Plan”) memorializes a cost rate for the provision of internal services billed indirectly, i.e. services provided by certain County Departments to other County departments. The Plan is compiled pursuant to Federal regulations, is revised and formally adopted annually, and establishes a reasonable and consistent basis to account for internal- service costs. The rate is established and certified by the County Auditor, and formally adopted via Resolution by the County Commissioners. The primary application of the indirect cost rate is for grants-accounting and reporting, though it can also be used to establish costs for contracted county services, or for internal budgeting and accounting. The cost rate reflects the countywide internal service costs as a percentage of direct service (i.e. services provided to County citizens) personnel costs. The rate is calculated based on 2022 audited figures, and is not adjusted to reflect allowable and excluded costs and an error-margin. The 2024 indirect cost rate is calculated according to the federal Office of Management and Budget simplified method as follows: This plan distinguishes Indirect Service departments (those that primarily provide services to other County departments) from Direct Service departments (those that primarily provide services to County citizens). The accounting, information technology, communications, and human resources departments are the identified indirect service departments, and are the primary providers of central services. Their operations are 90% dedicated to internal customers, and their central services costs comprise 80% of countywide central services costs. There are four other departments (Auditor/Administration, Courthouse, non-Departmental, Treasurer) that provide indirect services, though not as their primary function. DEFINITIONS Additional Costs – Additional expenses not accounted for at the department level, including depreciation. All Other Direct Costs – the amount remaining from total costs less additional expenses, unallowable costs, indirect costs, and direct salaries & wages. Capitalized Assets – Purchases of Asset that has a value $5,000 or above and has a life longer than one year. These assets are depreciated. The Capitalized Asset is removed as an unallowable cost. Central Service and Other Internal Costs:3,046,450 Direct-Cost Personnel:23,414,200 Indirect Rate 13.0% Auditor-Recommended Rate 13% Central Services – services that are provided to the organization, the customers of the Central Service s are the internal departments, which include Auditor Accounting, Information Technology, Communications, and Human Resource. Central Service Cost allocation plan – means the documentation identifying, accumulating, and allocating or developing rates based on the allowable costs of services provided by a governmental unit on a centralized basis to its departments and agencies. The costs of these services may be allocated or billed to users. Department – all County Departments and/or County Funds. Depreciation – Allocating the costs of a Capitalized Asset to periods benefiting the assets use. Direct Salaries & Wages – the 2021 fiscal year end salaries & wages for each department Excluded Costs - Certain items of cost are classified by Uniform Guidance as extraordinary or distorting expenditures and are excluded from the computation of the indirect cost rate i.e. capitalized equipment. Indirect Costs – costs incurred for a common or joint purpose benefiting more than one cost objective Indirect Cost Rate – a devise for determining in a reasonable manner the proportion of indirect costs each program should bear. It is the ratio of the indirect coast to a direct cost base. Sub Department – additional breakdown of a department expenses for accounting purposes Total Costs – the 2021 fiscal year end actual expenses Unallowable Costs – Certain items of cost are classified by Uniform Guidance as unallowable, which means that federal funds cannot be used for those items of cost. For indirect cost rate calculation, however, these unallowed costs are included in the base along with the direct costs. Some examples for unallowed costs are: Governance, promotional advertising, entertainment, and fines & penalties. Uniform Guidance – United States Office of Management & Budget, 2CFR Part 200, Uniform Administration Requirements, Cost Principles and Audit Requirements for Federal Awards establishing principles and standards for determining costs for Federal awards carried out through grants, cost reimbursement contracts, and other agreements with governmental units. FINANCIAL INFORMATION Accounting Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. Audited Data Kittitas County is audited annually by the State Auditor’s office. The audits consist of Financial and Single Audit and the Accountability Audit. The Financial and Single Audit was issued on October 19, 2023, Report #1033460. The report states: Depreciation Capital assets, which includes property, plant, equipment, and infrastructure assets, (e.g., roads, bridges, sidewalks, and similar items), are reported in the applicable governmental or business-type columns in the government-wide financial statements. Capital assets are defined by the county as assets with an initial, individual cost of more than $5,000 and an estimated useful life more than one year. Such assets are recorded at historical cost or estimated historical cost if purchased or constructed. Don ated capital assets are recorded at estimated fair market value at the date of donation. Kittitas County has elected to use the modified approach to account for the infrastructure account; Gravel Roads, which eliminates the need to report depreciation expense. Computer Software is reported as Intangible Assets with a capitalization limit of $5,000 and is not depreciated. Capital Leases are defined as long term debt to the county. The asset is tracked but there is not value placed in the Capital Assets. Capital Leases are determined by one of the following four criteria; 1) The lease transfers ownership of the property to the lessee by, or at, the end of the lease term; 2) The lease contains an option to purchase the leased property at a bargain price; 3) The lease is equal to or greater than 75% of the estimated economic life of the leased property; 4) The present value of rental and other minimum lease payments, excluding that portion representing executory costs to be paid by the lessor, equals or exceeds 90% of the fair value of the lease property. The cost of normal maintenance and repairs that do not add to the value of the asset or materially extend assets lives are not capitalized. Major outlays for capital assets and improvements are capitalized as projects are constructed. Interest incurred during the construction phase of the capital assets of business-type activities is included as part of the capitalized value of the assets constructed. Property, plant, and equipment of the primary government are depreciated using the straight-line method over the following estimated useful lives: Assets Years Buildings & Improvements 5-60 Improvements other than Buildings 5-50 Machinery & Equipment 3-20 Roads, Guardrails & Traffic Signals 20 Bridges 51 Time and Attendance Kittitas County uses an electronic time and attendance system to track employee’s time. Employees who allocate their time are required to post their time by project or by project time distribution. This allows the time costs to be charged to the specific project. Travel Reimbursements Kittitas County’s travel policy for 2022 followed the Federal Guidelines for employee reimbursement of travel costs. Kittitas County uses the High-Low cost of travel reimbursement. INDIRECT FUNCTIONS Auditor – Accounting The Accounting Division is responsible for the Budgeting, Auditing and Accounting for the county. The total Auditor’s Accounting Division 2022 actual expenses were $1.02MM. The accounting division audits the vouchers and payrolls and processes the warrants for the junior taxing districts. Information Technology (Services) Information Technology is responsible for maintaining the county computer equipment and software for all departments. Total 2022 actual expenses for Information Technology were $1,45MM. Capital outlay and software/subscription costs are excluded. Human Resource The Human Resource Department administers various programs involving recruitment, compensation, benefits, collective bargaining, and personnel policy. The 2022 actual expenses are $348K. There were no additional, excluded, or unallowable costs. DEPARTMENTS THAT PROVIDE DIRECT SERVICES Auditor- Administration The Auditor is responsible for five sub-departments (Accounting, Recording, Vehicle Licensing, Elections and Voter Registration) with a total of thirteen employees:. During 2021 the accounting staff had six full time employees and one intern. Treasurer The County Treasurer is responsible for the collection of the taxes, receipting of all money from all departments/funds, investments, and the redemption of all county warrants. As of year-end 2022, 50% of treasury funds were held on behalf of Special Purpose districts. This percentage is applied to Treasury Department personnel costs to arrive at excluded costs of $230K. GENERAL COSTS OF GOVERNMENT Under Paragraph 200.444 of Uniform Administration Requirements, Cost Principles and Audit Requirements for Federal Awards the general costs of government are unallowable. The following unallowable costs include: • Salaries and expenses of the Board of County Commissioners, • Cost of the judicial branch of government • Cost of prosecutorial activities unless treated as a direct cost to a specific program if authorized by statues or regulation • Cost of other general types of government services normally provided to the public such as fire and police ATTACHMENTS (3) • Indirect Cost Allocation (Simplified Method) work papers • Resolution Adopting Central Services Simplified Indirect Cost Allocation Plan for Budget Year 2024 • Cost Allocation Certificate 2024 Cost Allocation Workpapers 2021 2022 2021 2022 510 SALARIES AND WAGES 22,313,254 23,414,200 Grand Total 2,953,749 3,046,450 0010 ASSESSOR 922,941 964,302 0011 AUDITOR 1,138,485 1,016,104 0011 AUDITOR 457,361 464,384 001 ADMINISTRATION 185,152 200,861 0012 BOARD OF EQUALIZATION 21,529 18,614 002 ACCOUNTING 952,894 804,504 0013 FIRE MARSHAL 179,684 121,299 007 SECRETARY STATE GRANTS 97 2,589 0015 CLERK 385,922 394,115 008 COVID-19 342 0016 COMMISSIONERS 476,703 493,696 009 OPERATIONS EQUIPMENT 8,149 0017 INFORMATION TECHNOLOGY 706,631 748,990 0017 INFORMATION TECHNOLOGY 1,443,628 1,452,495 0018 WSU EXTENSION 108,935 71,872 001 INFORMATION SERVICES 1,113,755 1,097,617 0019 DISABILITY BOARD 16,296 16,780 003 KITTCOM PROJECT 71,885 68,035 0021 JUDGE - SUPERIOR COURT 340,764 367,780 004 VOIP PHONE SYSTEM 27,644 23,160 0022 JUVENILE 403,691 420,611 009 ENTERPRISE SOFTWARE 230,344 263,683 0023 LAW LIBRARY 3,790 4,075 0038 HUMAN RESOURCES 371,636 347,851 0024 LOWER DISTRICT COURT 678,327 718,570 001 ADMINISTRATION 301,652 273,259 0025 FACILITIES MAINTENANCE 328,708 370,817 002 EMPLOYEE BENEFIT PROGRAM 7,440 0026 NON-DEPARTMENTAL 124,661 129,609 003 MISCELLANEOUS 30,477 33,711 0027 CORONER 203,856 254,667 005 CIVIL SERVICE 32,066 40,881 0028 PUBLIC INFORMATION OFFICE 39,328 23,582 0031 TREASURER (50%)230,000 0029 PROSECUTOR 1,731,755 1,845,439 0030 SHERIFF 6,505,132 6,937,243 0031 TREASURER (50%)230,000 Central Service and Other Internal Costs:3,046,450 0032 UPPER DISTRICT COURT 408,535 413,483 Direct-Cost Personnel:23,414,200 0033 PEST AND DISEASE CONTROL BOARD 28 190 Indirect Rate 13.0% 0034 CONFERENCE OF GOVERNMENTS - - Auditor-Recommended Rate 13% 0037 EMERGENCY MANAGEMENT SERVICES 41,307 57,316 0038 HUMAN RESOURCES 241,635 214,169 0039 ADMISSIONS TAX - 0043 DECLARATION OF EMERGENCY 284,573 11,410 0045 HISTORICAL DOCUMENT PROGRAM 13,608 7,845 0048 NORTH MOBILE HOME PARK 11,583 9,621 0081 COUNTY ROAD 3,124,868 3,152,254 0083 FLOOD CONTROL 116,445 141,266 0101 AIRPORT 145,500 158,709 0109 EVENT CENTER 459,464 507,316 0118 VETERANS ASSISTANCE 67 154 0123 NOXIOUS WEED 216,772 251,200 0127 MISDEMEANANT PROBATION 457,600 468,092 0141 LODGING TAX OPERATIONS 9,594 7,010 0400 SOLID WASTE GENERAL ADMIN 252,483 249,285 0401 RECYCLING - 2,367 0402 COORDINATED PREVENTION GRANT 66,759 95,793 0405 LIQUID WASTE LAGOONS 25,863 16,119 0406 SCALE HOUSE OPERATIONS 127,538 141,201 0407 LANDFILL MANAGEMENT 1,767 1,655 0408 DIVERTED WASTES 91,350 98,258 0409 MODERATE RISK WASTE 1,177 0413 DOE - LITTER GRANT 6,823 17,719 0415 COMPOSTING FACILITY 66,168 55,296 0418 ECOLOGY GRANTS 12,613 0419 CDS ADMINISTRATION 95,210 101,383 0420 BUILDING 603,020 598,848 0421 PLANNING 302,972 259,495 0422 CODE ENFORCEMENT 93,397 116,061 0611 ADMINISTRATION 220,434 283,450 0612 PERSONAL HEALTH ADMINISTRATION 743,679 798,807 0615 ENVIRONMENTAL HEALTH PROGRAMS 432,183 537,861 0620 OTHER 13,536 30,707 0625 OTHER SERVICES 1,300 802