Loading...
HomeMy WebLinkAbout2021 Resolution Sheriff Cost Per Deputy (2)KITTITAS COUNTY BOARD OF COUNTY COMMISSIONERS RESOLUTION NO. 2021- A Resolution adopting the Kittitas County Sheriff Cost per Deputy for theBudget Year 2021 WHEREAS, Kittitas County receives Federal Grant Dollars and bills other organizations, 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 Sheriff needs to adopt a rate for the Cost of a Deputy, and; WHEREAS, the County Auditor has reviewed and approved the Cost Plan and determined the Kittitas County Sheriff Rate's to comply, and WHEREAS, the attached documentation shows the calculation rate for the Cost per Deputy 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 rates as follows Regular hours non-federal $75.00 Overtime hours non-federal $112.00 Regular hours federal $61.00 Overtime hours federal $92.00 for the Cost per Deputy for Kittitas County Sheriff as certified by the County Auditor, effective January 1, 2021. ADOPTED this 1St day of June, 2021 ATTEST BOARD OF COUNTY COMMISSIONERS KITTITAS COUNTY, WASHINGTON Chairman Vice -Chairman Commissioner Clerk of the Board/Deputy Clerk of the Board CERTIFICATE OF COST PER DEPUTY This is to certify that I have reviewed the cost per deputy plan submitted herewith and to the best of my knowledge and belief: (1) All costs included in this proposal, dated January 1, 2021, to establish a billing rate for the cost per deputy for 2021 are allowable in accordance with the requirements of the Federal award(s) to which they apply and the provisions of this Part. Unallowable costs have been adjusted for in allocating costs as indicated in the cost 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 Adopted Budget and the 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 and the Federal Government will be notified of any accounting changes that would affect the pre -determined rate. I declare that the foregoing is true and correct. Governmental Unit: Kittitas County Sheriff Signature: Name of Official: Jerald V. Pettit Title: _Kittitas County Auditor_ Date of Execution: _January 1, 2021 The 2021 Cost per Deputy Rate is approved based upon the 2021 adopted budget and completed review 5-27-2021. The rates approved are: Regular hours non-federal $75.00 Overtime hours non-federal $112.00 Regular hours federal $61.00 Overtime hours federal $92.00 t0 )n m N Ev n 00 O o I m M N o o vNi N m o u o m N o O � N M a U V N 0 O N clj f0 v w c N OI 0 3 U w EA w a O uj e» w w v3 w v O) N c o W o,N N >. N O �f O °°. it m K 0 U �m Q JO m _� E' a— N m X U m N r Ol 0 O E :_. m N o N O m .�. U Ul O � m m U T O V9 w 2 G Oo � w C` O22 L O nl U pOp O~ M N m O H3 O O. U p T. V N d) ap, d V C O p) m' ,.o> O-- E-- 69 U w L M U U OI C m m C m a� H y O r o 2 E m•� �o )� Q H o N "o ° CN O ~ Q m ~EaN�F. E °1 p � N� m U w Q v mo Q .. w `• J c M J U C E n O o u) T o Q m � .5 U O N N tV N V! ? CD O K LL r ON 0r LL O LU Ja Q W Z LL F» i r q J a N D Ev q O o M "T U M N a U V N 0 O O clj f0 v w c N OI 0 3 U a u 10 w w V J m N v O) N c O W E C ani N U °'a` a`) o _ °°. it m K 0 U �m Q JO m _� E' 3 O w w m d 0 m 0 O N C r m N r Ol O O .N C_ L C o r O 'o m fA V9 w 2 G m 0 C' a j �a C m J w C O p) m' ,.o> O-- E-- O J V pm Q ~ O r N v 2 Q Q o c o N CN O O T A � w n m a) U � w w O w C p —_ p N C 10 w w � p 3 w L In m U J m � C m E0a O 21 N OU C J � — Q C N " D p � w J � n � � w U m of o Q T 'E U m H m L L U O ut C w w w w E S $ � `m w C L L U o' T w C w w a O U N (a p J J U U j U N C d.0 U W O p C C C w O w � U a`m m 0 0+ o S E C w « N u .4 J J c m .N.. `p U O m N J J n v m w d L m N p U U X � t E p 0 E W 'U W O w O O V z= z p z m 3 N o r O o M "T U M N N M U V N 0 O O clj f0 v w c w o 0 C ti v 10 w w V v O) O g U c ani N U °'a` a`) o _ °°. it m K 0 U C Q JO m _� E' 3 O w w m d 0 m 0 O N C C o E C Ol O O .N C_ L F w 0 0 N M M O O U .'-T'm O 'o m fA V9 w 2 G m 0 C' a j �a !a m J w C O p) m' ,.o> O-- E-- O J V pm U ~ O r N v 2 Q Q o c o o 5 m N E °1 p � m Q Q Y o u) T c _ J U O N N E 5 E 0 N ui co C � L p V � y o w0 (D N ry J q J N - C O1 C C N O w � w o ,7.) L O O w R N a w V O � o L) m m J m w m C N C N J a m m f0 OI 0 cn N m 10- o w m w U L U H 3 5/27/2021 8:01 AM New Deputy $ (Filling Vacancy) Page 1 KITTITAS COUNTY SHERIFF'S OFFICE Updated: PATROL DEPUTY COSTS 1/1/2021 -SM $12,336.76 ISSUED COST PER SUB - QTY ITEM TOTAL TOTAL PRE-EMPLOYMENT $1,596.50 MEDICAL SCREENING POLYGRAPH PSYCH SCREENING 1 $796.50; $796.50 1 $200.001 $200.00 1 $600001 $600.00 $20.79 UNIFORMS $1,999.40 CUFF CASES UNIFORM PANTS - STRYKE PANTS UNIFORM PANTS - FECHHEIMER CARGO PANTS 2 $64.93 $129.86 1 2 $80.09 $160.18 UNIFORM S/S SHIRT - FECHHEIMER 2 $69.26 $138.52 UNIFORM L/S SHIRT - FECHHEIMER 2 $74.71 $149.42 UNIFORM L/S SHIRT - BLAUER ARMORSKIN 2 $59.59 $119.18 UNIFORM S/S SHIRT - BLAUER ARMORSKIN BOOTS 2 $58.64 $117.28 1 $250.00 $250.00 GREEN TIE 1 $8.01 $8.01 STOCKING HAT 1 $18.12 $18.12 BALL CAP 1 $17.26 $17.26 JUMPSUIT 1 $516.05 $516.05 NAME TAG 1 $10.82 $10.82 BADGE 1 $97.20 $97.20 STREETGUARD GLOVES 1 $40.60 $40.60 WINTER JACKET W/ LINER 1 $226.90 $226.90 ACADEMY PACK (ENTRY LEVEL DEPUTY) $3,809.37 ACADEMY TUITION 1 $3,347.001 $3,347,00 !ACADEMY CLOTHING I 1 $462,371 $462.37 BP VEST $1.648.21 1 ABA XTREME LEVEL II BP VEST 1 1 $37.46 $0.00 $20.79 W/THREAT PLATES, EXTERNAL CUFF CASES 2 $24.90 $0.00 CARRIER, POUCHES, 1 $13.00 $0.00 OC SPRAY .PLACARDS, ETC 1 $1648.21 $1,648.21 1 DUTY GEAR DUTY BELT LINER BELT 1 1 $37.46 $0.00 $20.79 $0.00 CUFF CASES 2 $24.90 $0.00 BELT KEEPERS SET OF 4) 1 $13.00 $0.00 OC SPRAY 1 $16.90 $0.00 OC CASE 1 $14.73 _$0.00 CHAIN HANDCUFFS 1 $30.27 $0.00 HINGED HANDCUFFS 1 $41.70 $0.00 GUN HOLSTER 1 $154.82 $0.00 SERPA TASER HOLSTER 1 $62.51 $0.00 KEY HOLDER 1 $15.39 $0.00 GLOVE POUCH 1 $12.35 $0.00 FLASHLIGHT HOLDER 1 $23.29 $0.00 4 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 5/27/2021 8:01 AM New Deputy $ (Filling Vacancy) Page 2 I EQUIPMENT 5698.98 I RADIO HOLDER 1 $44.86 $0.00 $250.00 $250.00 RIFLE 1 RADIO EARPIECE 1 $43.11 $43.11 $611.90 $0.00 LESS LETHAL AMMO 15 MAG HOLDER 1 $26.81 $0.00 1 $99.00 ASP/BATON 1 $75.80 $0.00 $0.00 QUIKCLOT ASP SIDEBREAK HOLDER 1 $37.37 $0.00 1 FIREARMS $0.00 CPR MASK $782.49 I EQUIPMENT 5698.98 I HANDGUN W/3 MAGS 1 $596.42 $0.00 5 plus 10 for training HANDGUN AMMO 1 $250.00 $250.00 RIFLE 1 $923.07 $0.00 SUPPRESSOR 1 $332.38 $0.00 LESS LETHAL SHOTGUN 1 $611.90 $0.00 LESS LETHAL AMMO 15 $6,77 $6.77 TASER 60 - ANNUAL PMT 1 $525.72 $525.72 I EQUIPMENT 5698.98 I TECHNOLOGY $385.58 OFFICE 365 LICENSE 11 $385.581 $385.58 VEHICLE $1,373.12 PURCHASE & LICENSING - FORD PI SUV PORTABLE RADIO W/CHARGER & EXTERNAL MIC, PROGRAM_ HEADLAMP CELL PHONE 1 $1,002.30 $0.00 j 1 $32.22 $0.00 1 $50.00 $50.00 CELL PHONE - MONTHLY SERVICE 12 $45.00 $540.00 GUN VAULT SAFE 1 $99.00 $0.00 FIRST AID KIT 1 $69.05 $0.00 QUIKCLOT 1 $42.01 $0.00 10OFT MEASURING TAPE 1 $25.78 $0.00 CPR MASK 1 $8.67 $8.6_7 DIGITAL VOICE RECORDER PBT 1 �1 $250.31 _ $8,00 $0.0� $479.33 DIGITAL CAMERA W/SD CARD & CASE _ _ _ _ f 1 _ BINOCULARS 1 $314.64 $0.00 $181.78 $0.00 FINGERPRINT KIT 1 $112.95 $0,00 CRIME SCENE TAPE 1 $9.74 $9.74 BIOHAZARD CONTAINERS 2 $5.00 $0.00 BIOHAZARD PICKUP KIT 1 $17.32 $0.00 RUBBER GLOVES 1 $7.57 $7.57 DISINFECTANT 1 $3.00 $3.00 C -A -T TOURNIQUET 1 $27.20 $0.00 LIFEJACKET 1 $80.00 $80.00 TECHNOLOGY $385.58 OFFICE 365 LICENSE 11 $385.581 $385.58 VEHICLE $1,373.12 PURCHASE & LICENSING - FORD PI SUV 1 $38,647.85 $0.00 DELL TOUGHBOOK 1 $2,436.00 $0.00 DATA1911 VERUS SOLO VIDEO _SYSTEM MAINTENANCE & SERVICE CONTRACTS PATROL BUILD 1 $5,670.00 $0.00 1 $4,510.00 $0.00 1 $16,700.00 $0.00 GRAPHICS 1 $430.00 $0.00 RADAR, PRINTER, SCANNER, IMPACT CHARGER 1 $3,510.00 $0.00 DIAMOND HARD TRUCK COVER 1 $1,650.00 $0.00 5 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 5/27/2021 8:01 AM New Deputy $ (Filling Vacancy) Page 3 KENWOOD RADIO 1 $2,600.00 $0.00 COMPUTER WIRELESS - MONTHLY SERVICE 12 $40.01 $480.12 MAGLITE W/CHARGER 1 $100.27 $0.00 INOVA LIGHT W/CHARGER 1 $243.08 $0.00 RADAR CALIBRATION & CERTIFICATE - ANNUAL 1 $86.00 $86.00 PORTABLE RADIO CHARGER 1 $87.19 $0.00 GOODYEAR ALL SEASON TIRES JUMPER CABLES SHOVEL 1 SET $807.00 $807.00 1 $34.65 $0.00 1 $17.31 $0.00 SAFETY CONES 3 $13.94 $0.00 ROAD FLARES 1 CASE 1 $48.55 $0.00 WOOL BLANKET 1 $11.91 $0.00 ORANGE TRAFFIC PAINT 1 J $7.241 $0.00 ANNUAL ANNUAL G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 5/27/2021 8:01 AM Exisiting Deputy Annual Costs KITTITAS COUNTY SHERIFF'S OFFICE Updated: PATROL DEPUTY COSTS 1/1/2021 -SM $3,$00.37 ISSUED COST PER SUB - QTY ITEM TOTAL TOTAL UNIFORMS $580.30 113P VE51 $329.64 ABA XTREME LEVEL II BP VEST W/THREAT PLATES, EXTERNAL CARRIER, POUCHES. PLACARDS, ETC. 0.20 $1,648.21, $329.64 FIREARMS $283.85 HANDGUN AMMO j 1 $250.001 $250.00 LESS LETHAL AMMO j 5 $6.771 $33.85 EQUIPMENT $547.78 UNIFORM PANTS 2 $64.93 $129.86 UNIFORM S/S SHIRT 2 $69.26 $138.52 UNIFORM L/S SHIRT 2 $74.71 $149.42 BOOTS 0.5 $325.00 $162.50 GREEN TIE 1 $8.01 $0.00 STOCKING HAT 1 $18.12 $0.00 BALL CAP 1 $17.26 $0.00 JUMPSUIT 1 $516.05 $0.00 NAME TAG 1 $10.82 $0.00 BADGE 1 $97.20 $0.00 WINTER JACKET W/ LINER 1 $226.90 $0.00 113P VE51 $329.64 ABA XTREME LEVEL II BP VEST W/THREAT PLATES, EXTERNAL CARRIER, POUCHES. PLACARDS, ETC. 0.20 $1,648.21, $329.64 FIREARMS $283.85 HANDGUN AMMO j 1 $250.001 $250.00 LESS LETHAL AMMO j 5 $6.771 $33.85 EQUIPMENT $547.78 TECHNOLOGY $385.58 OFFICE 365 LICENSE 1 $385.58] $385.58 VEHICLE $1.373.12 CELL PHONE MONTHLY SERVICE 12 $45.00 $360.00 FINGERPRINT KIT 1 $112.95 $112.95 CRIME SCENE TAPE 1 $9.74 $9.74 BIOHAZARD CONTAINERS 2 $5.00 $10.00 BIOHAZARD PICKUP KIT 1 $17.32 $17.32 RUBBER GLOVES 1 $7.57 $7.57 DISINFECTANT 1 $3.00 $3.00 C -A -T TOURNIQUET 1 $27.20 $27.20 TECHNOLOGY $385.58 OFFICE 365 LICENSE 1 $385.58] $385.58 VEHICLE $1.373.12 Page 1 $325.00 N REPLACE 7 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY xlsx COMPUTER WIRELESS MONTHLY SERVICE 12 $40.01 $480.12 RADAR CALIBRATION 1 $86.00 $86.00 ANNUAL GOODYEAR ALL SEASON TIRES 1 SET $807.00 $807.00 ANNUAL Page 1 $325.00 N REPLACE 7 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY xlsx a N a W U) W IL U) W 9 w O U) Z 0 F- J U J a U m N 0 N r u7 � v � m M n n n'M O L n O -i fA m m r*: O P9 W N n W O N 3 6n w o LL N d to N N W B 10 0 69 60 !R (A L0 601, fR 619, W 00 60 n O n n M V T n N 60 N W O1 W N 01 c=vti>6Nr>u 6nr>6nmm6`o F L N ER v d► N? FA f9 6* fR r m f` m m w 0 0 0 0 0 0 0 0 0 J O O o O O O O O O V> fA 6o w 6o to to 60 60 •+ V fO N W W 1- M O d a+ W O W o N (P (n u7 W y O N M W W O T V W F3 L) V V V V u7 u) L,)0 C U) Eo fo Eo E!> ff> OO O O O O O O O V f- N f.- Or N f` f- N r - D M m M m M m m M M Cy W W tri w w W W W W C U9 60 6o fo to 6o V> 6o V> 3 a 0 0 m r N ro 0 0 0 E 0 ED, 0 0 0 0 0 0 0 = c 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 fn 6f> » 69 to to to wr v> W V W W CO m O W N W 01 O (P Q. Of W N N N W W m O N m M fA Eo 60 6o fo to fo to 60 C CD u7 V) Lf) Lo Lo u7 u7 u7 u7 m M M to m m m M m 60 fA EA fo EA ER ER FA 69 N M W V W m W W N a W W W Ln W N W M N W u7_ r m U V W W f- 01 O N M LL N N N N N Cl) Cl) M M fA Vt fA 60 60 61> 60 60 60 T N N W r N V m N 00 V N V W u7 V V I- m S eO+ W O O W f` W O M m m M M M V V V C% fo fie to to 60 61) 60 60 O E e Mm m m m M M M m m m m m Cl) co co Cl) m 7 M M m m Mm Mm m d OO O O O O O O O O O O O O O O O O m OW W W V W V O W V W W W V W O N N W O N O f- W M W W u7 W M V W r W W 69 G9 6� W W W to 7 Eo fA fA fA Eo Eo fA EA fA C C a O O O O O O O O O O O O O O O O O O m O 0 N Lo h (n N W W O V W u) u7 69 W W W fS r r d fo Eo fA fA fo (o fR fo fo N 10 m A i+ U A N N N N N N N N N C W Q a a (~7 (9 U) U) h N U) U U t7 r v M M N n n N n 60 N_ M M N 60 OR 011� OR n W o C w n m N N Of O M h LL ra u>fnte6om6onnn G c Cl) cnm M r` r L' m Z m 7 10 .�O t0 N L N N -Fu m N 0 m N d 0 H L N X 4 W M 4 o W o N m - W M O m O O O o 0 ` 60 69 69 60 6A fA 60 W 69 C E M � 6L/ n ., J m U J N U) 60 — 0 C a !O n 6r> � n N 0 >' �,a X6`7 to of ri acmNv f n J a O C 60 6o m eo n n n oo ao ~ 0 c 0 O N L fA fA 64). to 60 Wk 6q 6q 6H w d' O O g O h OCD O U) J AW P. fo fo Eo FA V> b9 69 fie fo W Lo V O Lo W W W m N 60 L Q O 0 U). M. M. N 1 W M C tO tD fA 60 6o to 60 60 6f> 69 fo 60 V 60 69 ff> fo Cal 60 60 60 W. ` W to N W V O N W N 7 4 0 0 0 0 N N N M o E 0 0 0 0 0 0 0 0 0 S c o 0 0 0 o O O O o fo 64 w 6o fo Ga 61) fo yo O7 Nr, W n V N f - O. •.i W V N O V m m N 0 O) fn W W O N V 0 aN+ N N N N M M M M M y Eo b> Ef> 69 fo fo 60 60 60 C d m M fn M M M in M u7 M fn M fn M fn M 69 V-> 60 60 69 to to 60 60 V V W u7 m W Ntoco co a W r V ( 0 W 'o w O M U W r` to m u7 W to o to to fo 69 Go 60 60 7 m f -W V u7 m W V N 6A V M N N m O O M W W n m _ W) f- u7 N m 0 47 u07 Lo W W 600 W m EA co 10 W W to to 60 60 U) 7 2 i iiiii OO O O O O O O O [` 00 0 0 0 0 0 0 0 l0 O V W W f� V N fO to r rn N O y6N0 667 0 60 W Lr, W aa, W P- 0 600 y 60 60 69 co to 69 to 6o Eo N N m d >NN N N N N N N N N N U N N N N N N N N N 9 o W N M 0 W �- N N a a M M a J J F F CL III vi III III III W a U a (7 (7 p U)v~1 U)i U)i U tq N r W 0 co N_ d C � C d m � E m n N O N E n N O N C Or m Cl) G c Cl) cnm M r` r L' m Z m .�O t0 N L N N -Fu m N 0 m N d X N_ X 4 W M 4 o W o N m - W M O m O O O o 0 ` f� N C cO LP C E C d m+' E 7 E ., J m U J N N W fn - ca N O - aei = Q a >' E m D IV c o D f n J a O w OO H 0 c 0 X O d' O O g O h OCD O U) AW P. W 0 W U O 0 o Z o Z c }X j EL LU ¢ O H O U 0 co N_ W E E n N O N E n N O N m Cl) y6 GG Cl) cnm m r` r L' m Z m .�O t0 N L N N -Fu N � N N 0 N X X X :n u7 m X N_ X 4 W M I- f- u) O u7 O o W o N m - W O m O O O o 0 f� O cO W C C E C d E 7 E ., J U J N E O N W fn - O - CL a Q cu of E m c o 0 f n J a U U 0 c W 0 W U O 0 o Z o Z c }X j EL LU ¢ O H O U 5/27/2021 8:01 AM Direct Costs (non-sal_ben) DIRECT COSTS ALLOCABLE TO DEPUTIES $ 12,336.76 Cost of On -boarding a New Deputy: Total gal fuel/invoice PRE-EMPLOYMENT COSTS $ 1,596.50 UNIFORMS $ 1,999.40 ACADEMY PACK ENTRY LEVEL DEPUTY $ 3,809.37 BP VEST $ 1,648.21 DUTY GEAR $ 43.11 FIREARMS $ 782.49 EQUIPMENT $ 698.98 TECHNOLOGY $ 385.58 VEHICLE $ 1,373.12 $ 12,336.76 $ 3,500.27 Example of average cost/gal: DOT Annual fuel cost range (2019): Total cost/invoice Total gal fuel/invoice Cost of Maintaining a Deputy/Year: JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC (This is the invoice total, not just Patrol) $ UNIFORMS $ 580.30 BP VEST $ 329.64 FIREARMS/AMMO $ 283.85 EQUIPMENT $ 547.78 TECHNOLOGY $ 385.58 VEHICLE GENERAL ANNUAL COSTS $ 1,373.12 $ 3,500.27 Example of average cost/gal: DOT Annual fuel cost range (2019): Total cost/invoice Total gal fuel/invoice Avg Cost/Gal JAN FEB MAR APR MAY JUNE JULY AUG SEPT OCT NOV DEC (This is the invoice total, not just Patrol) $ 9,448.31 4,159.82 $ 2.27 $ 7,650.53 3,496.38 $ 2.19 $ 8,486.64 3,721.36 $ 2.28 $ 9,350.57 3,468.93 $ 2.70 $ 11,381.10 3,862.19 $ 2.95 $ 11,358.80 3,933.24 $ 2.89 $ 10,367.30 3,859.95 $ 2.69 $ 10,469.78 3,938.89 $ 2.66 $ 10,074.78 3,853.57 $ 2.61 $ 10,187.56 3,653.12 $ 2.79 $ 10,313.44 3,608.51 $ 2.86 $ 9,399.73 3,665.14 $ 2.56 $ 118,488.54 45,221.10 1 $ 2.62 2021 budgeted fuel cost for GF and L&J vehicles: $84,250 Average cost/mile (using $2.37/gal, & assume 15 mpg avg) $ 0.16 Assume avg total miles driven/hour 50.00 Avg fuel cost/mile/hour $ 7.90 9 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY xlsx 5/27/2021 8:01 AM Direct Costs (non-sal_ben) 2021 KITTCOM/SPILLMAN COST $ 412,858.84 (Per contract) 2021 Insurance Budget (property & liability) $ 106,169.00 (non -jail, non-boatinq portion only) 2021 Vehicle maintenance budget for GF and L&J vehicles: $ 119,091.00 2020 Depreciation Values (from Kay's Depr Schedule): $ 153,063.31 2020 Allocated vehicle warranties for NEW LE and L&J $ 31,881.94 vehicles warranties not capitalized): 2020/2021 Estimated cost for allocated depreciation, warranties and repairs $ 304,036.25 From OMB Super Circular 200 E. Direct Costs 1 General Direct costs are those that can be identified specifically with a particular final cost objective 2. Application. Typical direct costs chargeable to Federal awards are: a Compensation of employees for the time devoted and identified specifically to the performance of those awards. b. Cost of materials acquired, consumed, or expended specifically for the purpose of those awards c. Equipment and other approved capital expenditures. d. Travel expenses incurred specifically to carry out the award 3. Minor items. Any direct cost of a minor amount may be treated as an indirect cost for reasons of practicality where such accounting treatment for that item of cost is consistently applied to all cost objectives 4. Factors affecting allowability of costs. To be allowable under Federal awards, costs must meet the following general criteria a Be necessary and reasonable for proper and efficient performance and administration of Federal awards. 5 Reasonable costs. A cost is reasonable if, in its nature and amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the cost 10 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 11 N a � in O U F U C - w K � E O = � _ Z j O C w J E V � O m N _w r w J ci U � p LL 11 Q t0 E E O U m c H 12 x U) X F-- W 0 Q LL 0 U) 0 U N O .c 0) L U) O C-6 a) U X LLI U) a) U N ' O M ' r-1 N Ol 1 O Ln 00 O N J N W lmD LDD LLnn LO f- Ln � z �D O LSD 0Z ri tri r I ":FLO O I-- W `� M N U d Q W N O � m0r,��mN O Ln rn M J �y Q LD LD tD O O n t/i 00 N N N LA LD -i LA M O H LU Ln N U d Q W M N r-1 Ln r1 M N M 1.0 LD I'D ri LD <D Ct M r-1 I- N r� N M ll1 n J LU Ln Ln N -Izt zl- O � m -1 00 � W -4Z • - M N r -I ri r -I <D LD N Lu O d Q W N LnM W -!-1 0 + to to Ln V-1 u F0 - Ln M m ri O ri O ri O ri O ri O c -I O O O O O O O O O N e4 O m m m M m m M D1 �t 01 m D1 (n0) v Ol J J J W Q > Z O v H W + Z Z z z z z ZZ Z Z Z Z Z Z Z Z Z O a a a a Z F- J J J J J J J oc w Z Q W > 111 > 111 > W > LL > LL > fru > z z z z z z cc L7 aaaaaa 0000002 H ���� CC = = �� <<<<<<oQc °� >cc a W o:: 0< == w H J Q 0 Ln N N N L i L% � W Q } Ooc oc ~ W Ln M Ln r -I O O D Z W r-1 r 1 O r I O r -I O r 1 O r 1 O lD LD O LD O LD O LD O LD O LCLO 0 M -Zt m m m m 0 0 0 0 0 0 O m ;* Ln Ct Ln It Ln ;I- m -* Ln m 'ct 1�1- m Ln Tt Ln It Ln Zt Ln U Ln Ln �D r- Ln M Ln Ln �D rl Ln a) J N O O N O N O N r-1 N Ol N N O O N O N O N ri N Ol N Vt O O OO O O O O O O O O m 0 0 0 0 0 m 0 0 0 0 0 m m m m m m M M m m W Q Z LU Z) LU D Z O LU L Ces U V) co ? u W a = U W < 0- ai) L/)< Lna < tan LNn a 12 x U) X F-- W 0 Q LL 0 U) 0 U N O .c 0) L U) O C-6 a) U X LLI U) a) U O a G Gl 0 E u u Q C a.+ V i2 v E N M V Ln lD r Z 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N L O1 O O O O O O N N N m m M r, m m;t V qT ci N N 0 0 0 0 0 R w lD lD ID LD lD lD m lD n O O O -! m m ri ri ri ri Ln m m Vl m m m R m lD N r -I eti ri -4 ri M W ID m m m N N ri r -I M ri ri -4 O m W M Ln Ln Ln W O W M m m m m m N m'zt N N N M W N M W M M M N H c-1 O m m m H V m W W Lw W W W O lD Ln N N N m M r' l0 M lD IO LO m m oc Ln Ln Lr c -I m LD H rti r-1 H .--1 r- 1 N' N 1- r` n n W W IDn n n n n W W W w N N N ct N Olzl* O N N N r n r, n n n O .-1 r n n r r -i m W O O d' d' It-tt N Ln m n l0 m N m m m Lw m W Lw Lw Lw Lw 1p m V7 ul LQ n Cr m m m Vl Vl m N rri O r\ O N r\ m -1 ri r-1 m m m m m m w -t O m Ln Ln W n w 7 m w W W N L L . . • . . ri L O m Ln Ln m n O O O n r\ r` r r, r\ Li l m O n r` n m N 0 r- N w w LD O O N W r -i V la m Ln m m LD M M M M M m m m N M M M v m a m v m m Ln a M ri N M 1� � l0 m m m m m co m m 00 00 O m M0 O o m m M m m �' a N O n m m N N N N N N N N N fV N N m N N N N N N fN ri r-1 r -I r-1 H ri M m N N O 7 O N N N n n n r, r n N m m ri ci -1 m m m Ln N Ln Ln Ln lD w w r-1 .-I eti r -I m m M V Ln m N lD W N m m m V V ��lz� 1' r N Ln n n n V OR M V N V CY d' IO LD LD m Vl Vl Vl LD LD m N O n O N n m r-1 N r1 m Ln Ln Ln Ln m N m n n n n m N w m n m m m ID N N O VV 7 LD lD Lw O Vl Vl Ln M n cl O O O ID W LD LO l0 LD 00 00 V V W Lw Ln m r -I m m m cor00 m N m M M MM N N oo r -I ;t W m Ln LO LD LO N N N N N N M M r� V7 Ln Ln M V1 m N N N N rlV lzz� Vlzl Vl Ln Ln Ln Ln ri r -I N M n N N N N N ry O O O O O O m M N m m m m m N m m m m m m M op oo m m � V V m m C m m N N O'zt O N N N n r\ n N r� rl N M m r-1 c -I r -I M m m Ln Ln Ln Ln Ln W ID W ri .--I N ri L,)0 n m r\ lD W N m m m� V V � 1t V N N Vl n n n� m M V N d� 7 LD LD ID m Ln N Lf) .-i O n O N N M-1 c -I Ln Ln Ln Ln Vl LQ N M n n n n M N lD m n m m m W N N O V -q 7 O Lfl Ln Ln M N -4 O O O ID W LD LD LD W W W It Ct cr dl W W Ln m ci m m m W W W N M M M N W ri �r LD m Ln LD LD l: N rIN N N N M M n% Vl Ln Lr M Ln m N N N N N` Vlzl V Ln Ln Ln ri N M r Zj" LD m m m m O O O O O O N N It -1 .--I r -I LD w m LY) N M m m 00 00 00 00 r-1 H ri O n m m N N N N N N M M M M M M M M N M M M M M N M M M M M M M M M T C1 V M M N N Z ¢ p LL m Z O N 5 O 2 Q W = m 2 u O O _ w w z z Z N w _ O C} 0 O w W lY Z W C V1 Y Z C O ¢ C m m LL J ik Y m J Y m W Z U w > > > U U ❑ W V) O U LL m V v Y m o ° Q z Ln (n Vii m o w w Q m~ m w m w m R > g w > ❑ ❑ ❑ > > > > > > `° z z o 0 0 , o o cWc o w - > > _ ❑ u u o = u O W W W❑❑❑❑❑❑❑ a G Z Z > Ln m m m Ln Ln Ln Ln Ln Ln w w m m m m OO 0 m_ = 0 U Ln l.7 Ln LY m a ❑❑ m> 0 in m cc of LY m m w w w 0cc _ w oC tr w K K O O LU W .� F_ w LL H 0 0 0 0 0 0 0 0 0 F m cc�� O O O O O m m 0 v - m p p a a a=_= m m m m m m W W W O O W m W d m m~ W W m O O O O O W W Q J LU Q W Ln VI Ln W w W W W w= 0 ¢ N W Ur W W w W U u W -1.1 eq N N Z a X V) X w U, LL W V U U U U U V) V7 m Z Z Z LL LL Z U Q u u u V LY w V LL LL LL LL LL z W W W W LL' tY 0C lY Q' K LL' lY �. W W ❑ "" W ❑ ❑❑ W W W W W W O O Q ❑ ❑ ❑ ❑ ❑ ❑ W = W W W � F- W O O ❑ O O❑ O ❑ ❑❑ lY Y Y Y F F Ln Ln U LL' c F u �-- F W Z Z F- K LY K C m Ir O W z U v u Z Z Z z z Z LL LL w 0 0 0 0 0 0 Z W Z z Z Z - 2 0 0 0 0 0 0 0 0 0 0 LL U W O l LL LL LL LL LL LL - W W - LL LL LL LJ. LL LL oL LL LL LL W Q O O Ln w w w w r n n n n W❑ p ❑ J J 0 0 0 0 0 0 to n O M O N Ln Ln ci N c -I ri r -I c-1 N N N N N N O O r-1 r-7 O= O N N N O O O O O O O O O O o 0 0 0 0 O O O O O O O 0 0 0 0 0 0 0 0 0 0 N U LL- LL LL LL LL LL LL LL LL LL LL LL N N N N N N LL ❑ LL W LL Q d LL LL N N N N N N N N N N O w w m O o ri N m lzt Ln w r� w O r -I N m V ri N m m ID r-1 N mct M't Ln w n w m m m m -;t 0 0 0 0 p 0 0 0 0 r l .-I .--1 r-1 ri t o ci V T 7 m m m Ln 0 0 0 0 0 0 r-1 w NLw a r� m O 0 0 o r, r, rn r- r, F, r` I. I. a v t v a m Ln Ln m m Ln r -I r-1 ri r-1 m m ww m m m rl Lw o o n o m m m m m m m m m m m m m v a v v a Ln m m m m m m m m w FZ F, F, FZ n F, w m m m o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O N N n m Q lD r-1 ri ri ri e -i r-1 ri ri ri H ri ri ri ri ri ri r -I H 1-1 ri r -I ri ri ri r -I ,-I ri ri ri li ri ri -4 ri ri 1-1 ri ri H W o_ r W N "' > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Q u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u Q W Q F- LA '^ UCYC7CJC7CYClC7U0c0Cf0CY00CIO 00ClC7C7C1UCY0cc C7ct00 Oct 0000 Q W W W W W W W W w W W w W W W W W W W W W W W W W W W W W W W W W W w W W W W W 13 �o 2 NEt ry o > N 88 66 O W ❑ ❑ �mnbOio wdf Z? N vwiNN� N d NnN N m s o22-22.22 ry O 2 W mO w0 F IIl x �, _a o W w CCO =HNo~ul 0 O F a ^ K W U U h M 2 g = r W O O a O Q W K Q== g F K H m W o -W. W Q 0 H 0 W W F U >> V ry a o d p ^. N d a a R Q R R O a O ww pN�z�-dwa G F a O W a z >> �woazwwm0 r w d a z W rc w a w rc� �i)aaawoo U, U a g a y w o O> a Waa Ow..M,W 7 w o w w a i O U z as m>Ow>��o m> o ❑ w ry o W— o00 0 0 m a S8 pa,m°'n 888 ry w om�ww��,ww �ry wo g w ^» ee F W, W q w _ w rvO m e V W ❑ Iz W W urvi urvi � ewn eD p j z� N� m OW C� wwww ywe�w wen n w ww w w mc LL U U W' N m ❑ O ❑ ❑ ❑ O W i F J J J J J J NV ammmmmm z U - KKK O¢' Z O - - - - - U m N e e[. .. i. w eC �n e0 .h eD b ❑ K F E P E E O W a¢¢¢ Q Q 6 V J W W W a W 6 W F k� Vaa Y p ry o m a N F ANN W WWW UooW N woo W WaN0 U, N W UUaUa W W LL f7 q0 N gaK Q N w -W aviz z Z W Q ZZZ N 2 Z LE U K a ��w;�� zzzzuoLL w, C, o w uvu No 181 w zc°>i w OOOOgg9 Y> UUU U K } U K W W W W °ONS U bma0 NO s5� Q 0 H wwwww W 1 N Jw ❑ °� www wp www z U j =O K K K x¢ �' ❑ W, x x x m N b b b OF w❑ O W No N U F W❑ aa F 000 F❑ W W W w li N LL LL LL Fie W K UZ— a K Z K w wDDO �r w z3zU ZUZ U m Z � w K m K w W 000 H Z W O o w WWW W ~mmm , 6 Z¢ W U V LL SSiZ O N OOOOOOo W�zo6 M � _ � o g LL LL LL LL LL LL oo� FF F Z x Z ,� x= x f H Z z Z S O gg O O z Nrvgo waa�1 ¢w� www a¢ a w Q d w rvrvrvry >O >OYa >>> O❑ > d [9 KD Y Q Z w > wN w owo W m u�i t.Qtv�i y C) y�L) uLLd LLLLd C) L) YZUam�LL 0 0 0 0 0 0 OZzzzzz z LLa QLL QLL QLL ¢LL aLL Z =a¢aWZ tW W W W wW w W Z Z Z Z Z Z LL J ZWWWWW6 N Wa F ON o o g o w w rvrvry ry ry % r? 14