Budget BJA FY 25 Comp Opioid Substance abuse grant - CG.xlsx
Extracted text (via pymupdf)
4606 characters
Personnel Name Rank Exempt Status New Sworn Detective #1 - Year 1 Other Exempt New Sworn Detective #1 - Year 2 Other Exempt New Sworn Detective #1 - Year 3 Other Exempt New Sworn Detective #2 - Year 1 Other Exempt New Sworn Detective #2 - Year 2 Other Exempt New Sworn Detective #2 - Year 3 Other Exempt New Sworn Sergeant- Year 1 Other Exempt New Sworn Sergeant- Year 2 Other Exempt New Sworn Sergeant- Year 3 Other Exempt Total Salary Item Quantity Cost per item Fully Outfitted Vehicle 3 90,000.00 Total Grant Year 1 Costs 735,288.17 $ 735,288.17 $ Year 2 Costs 488,552.57 $ 488,552.57 $ Year 3 Costs 511,866.46 $ 76,159.26 $ TOTAL $1,735,707.20 1,300,000.00 $ Police Department Name Annual Salary FICA % FICA $ Medicare % Medicare $ 90,000.00 $ 6.20% 5,580.00 $ 1.45% $1,305.00 94,500.00 $ 6.20% 5,859.00 $ 1.45% $1,370.25 99,225.00 $ 6.20% 6,151.95 $ 1.45% $1,438.76 90,000.00 $ 6.20% 5,580.00 $ 1.45% $1,305.00 94,500.00 $ 6.20% 5,859.00 $ 1.45% $1,370.25 99,225.00 $ 6.20% 6,151.95 $ 1.45% $1,438.76 112,000.00 $ 6.20% 6,944.00 $ 1.45% $1,624.00 117,600.00 $ 6.20% 7,291.20 $ 1.45% $1,705.20 123,480.00 $ 6.20% 7,655.76 $ 1.45% $1,790.46 920,530.00 $ Match TOTAL - Check - $ 735,288.17 $ - $ 488,552.57 $ 435,707.20 $ 511,866.46 $ 435,707.20 $ 1,735,707.20 $ Buckeye Police Department Workers Comp % Workers Comp $ Retirement % Employer contribution Retirement $ Employer contribution 3.15% $2,835.00 26.75% $24,075.00 3.15% $2,976.75 26.75% $25,278.75 3.15% $3,125.59 26.75% $26,542.69 3.15% $2,835.00 26.75% $24,075.00 3.15% $2,976.75 26.75% $25,278.75 3.15% $3,125.59 26.75% $26,542.69 3.15% $3,528.00 26.75% $29,960.00 3.15% $3,704.40 26.75% $31,458.00 3.15% $3,889.62 26.75% $33,030.90 Life, AD&D, ST Disability $ Health Insurance Dental Insurance 186.96 $ 19,506.05 $ 1,381.88 $ 196.31 $ 20,481.35 $ 1,450.97 $ 206.12 $ 21,505.42 $ 1,523.52 $ 186.96 $ 19,506.05 $ 1,381.88 $ 196.31 $ 20,481.35 $ 1,450.97 $ 206.12 $ 21,505.42 $ 1,523.52 $ 186.96 $ 19,506.05 $ 1,381.88 $ 196.31 $ 20,481.35 $ 1,450.97 $ 196.31 $ 20,481.35 $ 1,450.97 $ Grant amount 1,300,000.00 $ Buckeye non- required contribution 435,707.20 $ Total Personnel Cost for 2 detectives & 1 Sergeant for 3 ye Vision Insurance Total Benefits Total employer cost 139.17 $ $55,009.06 145,009.06 $ 146.13 $ $57,759.51 152,259.51 $ 153.43 $ $60,647.48 159,872.48 $ 139.17 $ $55,009.06 145,009.06 $ 146.13 $ $57,759.51 152,259.51 $ 153.43 $ $60,647.48 159,872.48 $ 139.17 $ $63,270.06 175,270.06 $ 146.13 $ $66,433.56 184,033.56 $ 146.13 $ $68,641.50 192,121.50 $ Total Benefits Cost to Employer $545,177.20 1,465,707.20 $ Vehicle cost 270,000.00 $ 1,735,707.20 $ 75% 25% ears (36 months) and 3 vehicles Health Premiums Monthly Health Monthly Dental Monthly Vision Emp 898.14 53.49 5.91 EMP+Sp 1613.98 108.50 11.24 Emp+Children 1524.23 123.10 11.84 Emp+Fam 2,465.67 175.55 17.4 6,502.02 460.63 46.39 Average 1,625.50 115.16 11.60 Average/year 19,506.05 1,381.88 139.17