Loading...
HomeMy WebLinkAbout2023 Indirect Costs Allocation Plan WorksheetTotal Costs Exclusions (2) Unallowable (3)Salaries Other Direct Costs Indirect Costs Direct Services/Programs 611.81 Assessment $90,360.86 $13,047.34 $77,313.52 611.82 Public Information Officer $0.00 $0.00 $0.00 612.11 Health Promotions Administration $131,413.30 $67,072.18 $64,341.12 612.22 Maternal Child Health Block Grant $39,231.49 13,258.00 $14,567.60 $11,405.89 612.24 Oral Health $12,027.62 $6,363.04 $5,664.58 612.29 Clinic Services (Adult, Oversees, Children)$734.79 $302.16 $432.63 612.30 In Person Assister (Health Benefit Exchange)$1,168.99 $644.90 $524.09 612.31 LSPAN $76,709.72 $39,786.01 $36,923.71 612.32 Immunizations $16,533.13 $6,082.68 $10,450.45 612.34 Tuberculosis $0.00 $0.00 $0.00 612.35 HIV/AIDS $1,444.65 $792.61 $652.04 612.39 Communicable Disease $821,611.40 $440,923.57 $380,687.83 612.40 Syringe Exchange $127,299.08 $69,057.13 $58,241.95 612.44 Tobacco Prevention $4,411.69 $2,365.31 $2,046.38 612.80 PIO Emergency $0.00 $0.00 $0.00 612.88 Bioterrorism $58,045.36 $32,970.00 $25,075.36 612.91 Marijuana Prevention $12,993.99 $7,596.36 $5,397.63 612.92 Overdose Prevention $9,181.15 $5,039.33 $4,141.82 612.93 Safe Kids $2,205.97 $912.22 $1,293.75 612.94 Snap Ed $27,604.44 $15,483.00 $12,121.44 612.95 Medicaid Administrative Match $122.88 $0.00 $122.88 612.00 Community Health Administration $87,576.71 $38,731.04 $48,845.67 615.02 Water $95,504.26 $51,861.52 $43,642.74 615.03 Solid Waste $33,749.11 $18,699.36 $15,049.75 615.04 On-Site Sewage $156,889.37 $84,459.60 $72,429.77 615.05 Zoonotics / Vector $389.32 $222.71 $166.61 615.06 Food Safety $100,972.53 $55,823.31 $45,149.22 615.08 Living Environment $85,120.12 $45,729.92 $39,390.20 615.09 Environmental Health Emergency $598.80 $273.26 $325.54 615.11 EH Education $14,011.61 $8,194.80 $5,816.81 615.40 EPH FPHS $43,403.14 $24,433.10 $18,970.04 615.56 Food Education/Food Worker Cards $767.96 $424.23 $343.73 615.00 Environmental Health Administration $291,074.63 $142,323.26 $148,751.37 620.71 Vital Records $25,355.87 $13,535.64 $11,820.23 625.50 BOH/BOCC Behaviorial Health Recovery $2,339.98 $1,300.42 $1,039.56 Subtotal $2,370,853.92 $13,258.00 $0.00 $1,209,017.61 $1,148,578.31 $0.00 Indirect Costs of Division Administration Salaries $224,346.86 $48,326.02 $176,020.84 Administration Benefits $71,798.17 $8,420.51 $63,377.66 Supplies $4,737.73 $600.80 $459.61 Services & Charges $139,500.23 $1,764.64 $15,302.42 Capital Outlay $2,274.36 $2,274.36 $0.00 Central Services of the Entity (1)$162,421.55 $162,421.55 $0.00 Subtotal $605,078.90 $59,111.97 $164,695.91 $0.00 $0.00 $255,160.54 TOTAL $2,975,932.82 $72,369.97 $164,695.91 $1,209,017.61 $1,148,578.31 $255,160.54 1. This represents the amount of internal services allocated to the department via the entity-wide central service cost allocation plan. 2. This column represents amounts that are passed through to other entities and amounts that are more directly related to program areas and are not included in the indirect rate 3. This column represents costs not allowed by Uniform Grant Guidance (capital expenditures, legal expenditures and civic organization membership) Public Health Department Indirect Cost Rate:Public Health Department Admin FTE Rate: Indirect Costs $255,160.54 2021 Budgeted FTE 27.00 11.11% Direct Salaries $1,209,017.61 Admin FTE 3.00 Kittitas County Public Health Department Indirect Cost Allocation Plan Based on 2021 Financial Data Direct Costs 21.10%