--- OCR page 1 of 77 --- 7 OTTAWA COUNTY F ILED 2023-2024 r ESTIMATE OF NEEDS NOV 07 2093 AND FINANCIAL STATEMENT OF THE 1, % FISCAL YEAR 2022-2023 'e Audit _ Or & Inspector BOARD OF COUNTY COMMISSIONERS OF THE COUNTY OF OTTAWA a STATE OF OKLAHOMA Two copies of this Financial Statement and Estimate of Needs should be filed with the County Clerk not later than August 17 for all Counties. After approval by the Excise Board and the levies are made, both statements . should be signed by the appropriate Board Members. One complete signed copy must be sent to the State Auditor and Inspector, 2300 N. Lincoln Blvd., State Capital, Room 123, Oklahoma City, OK 73105. If publication may not be had by date required for filing, affidavit and proof of publication are required to be . attached within five days after date of filing. i” THE 2023-2024 ESTIMATE OF NEEDS = AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2022-2023 PREPARED BY TURNER & ASSOCIATES, PLC SUBMITTED TO THE OTTAWA COUNTY cE EXCISE BOARD THIS Q23*DAY OF 2023 . BOARD OF COUNTY COMMISSIONERS Chairman a t= _ County es comin Say, Ake fan commissioner__Meg 7 FX LZ r om Treasurer SK Oda y Sot bunk Assessor Becky Spt Court Clerk _\ UL Qn Q 4 ___. Shefjff _ <7 ED _ S.A_and |. Form 2631 ROT Entity: Ottawa County. 58 October tae 1023 State Auditor and Inspector r OF ama. --- OCR page 2 of 77 --- ™ | Index Page” = * 1 Exhibit A County General 1 Exhibit D County Highway Unrestricted 12 a ExhibitE Health 20 Total Exhibit I's 28 1-1103 , County Bridge and Road Improvement 29 1-1204 ° Assessor Revolving Fee 30 q 1-1206 Sheriff Bond Fee 3 1 ! 1-1208 ‘County Clerk Lien Fee 32 1-1209 County Clerk Records Management and Preservation 33 a 1-1212 Emergency Management 34 i 1-1218 Local Emergency Planning Committee 35 1-1220 Resale Property 36 : 1-1221 Reward Fund 37 1-1223 Sheriff Commissary 38 1-1225 Sheriff Forfeiture 39 1-1226 Sheriff Service Fee 40 1-1230 Treasurer Mortgage Certification 41 ie 1-1235 County Donations 42 1-1251 Opioid Abate 43 1-1401 Convenience Center 44 1-1456 Bureau of Indian Affairs Stateline Road 45 = 1-1507 Tribal ARPA Funds 46 | 1-1566 American Rescue Plan Act 2021 47 1-1570 Local Assistance & Tribal Consistency 48 Total Exhibit 1.ST's 49 " LST-1305 Courthouse Improvement Sales Tax 50 ! LST-1313 Road and Bridges Sales Tax 51 LST-1321 Rural Fire Sales Tax 52 re Total Exhibit M's 53 7 M-7202 Child Abuse (Multidisciplinary) Prevention 54 M-7205 Law Library 55 M-7206 Drug Court 56 M-7210 Court Clerk Preservation 57 " M-7401 Individual Redemption 58 M-7402 Excess Resale 59 M-7408 Tax Refunds 60 M-7506 Emergency Transportation Revolving 61 M-7605 Educational Trust 62 M-7702 Independent School Remit 63 M-7703 Municipal-City-Town Remit 64 4 M-7704 Emergency Medical Service District (EMS-522) Remit 65 M-7706 Career Tech Remit 66 Exhibit W 67 Exhibit X 69 “| Exhibit Y 1 } Exhibit Z 715 S.A. and I. Form 2631RO1 Entity: Ottawa County,58=~~~SSCSCSCSCS October 19, 2023 ™ --- OCR page 3 of 77 --- OTTAWA COUNTY 2023-2024 - ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2022-2023 n OTTAWA COUNTY, STATE OF OKLAHOMA . \To the County Excise Board of said County and State, Greeting:- [Pursuant to the requirements of 68 O.S. 1991 Section 3002, we submit herewith for your consideration, the within statement of the fiscal condition of the County of Ottawa, State of Oklahoma, for the fiscal year BE beginning July 1, 2022 and ending June 30, 2023, together with an itemized statement of the estimated needs Ithereof for the fiscal year beginning July 1, 2023 and ending June 30, 2024. The same have been prepared ‘in conformity to Statute, in relation to which be it further noted that: 1, We, the members of the Board of County Commissioners of said County and State, do hereby certify that |the statements herein submitted show the true and correct conditions of the fiscal affairs of said County for the i ifiscal year ending June 30, 2023, that said statements comprise a "full and accurate statement of the assessments, receipts and expenditures of the preceding year, made out in detail under separate heads" as required by 19 O.S. 1991 Section 345; that said preparation was had at an official session of said Board, begun| = lon the first Monday in July, 2023 pursuant to the provisions of 68 O.S. 1991 Section 3002. 2. And we further certify that the estimates of the several amounts necessary for current expenses for the fiscal lyear beginning July 1, 2023 and ending June 30, 2024 as shown under "Schedule 8" were prepared and filed cE with the Board of County Commissioners as of the first Monday in July 2023, that the same have been correctly entered, and that all estimates made are entered as certified by Department Heads for the respective purposes herein set out. We further certify that the sums requested for salaries of county officers and the EF deputies are calculated and based upon authority of salary statutes currently effective and applicable in this 157 We further certify that the estimated income from sources other than ad valorem tax, shown on "Schedule - I4", may reasonably be expected to be collected as a revenue during the ensuing fiscal year, and is not in excess lof the 90% of the amounts collected for the same sources during the fiscal year ending June 30, 2023. - \Dated at the office of the County Clerk, at Miami, Oklahoma, iE thisAS tay of oer 2023 XQ) i BTY)e —_ CEA, = | ipa wk by uy rairm: ounty Clerl Oe MM he 2A a] ‘ommpissioner E ‘ommissforte 7 wt AC CTA — SI ‘ourt’CTer! r oo th 3 Filed thisQS3_~ day of Ochotyec 2023 Secretary and Clerk of Excise Board, Ottawa County, Oklahoma. an S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 4 of 77 --- "I Independent Accountant's Compilation Report 7 4 | Honorable Board of County Commissioners ! Ottawa County, Oklahoma 7 Management is responsible for the accompanying 2022-2023 prescribed financial statements as of and for the fiscal year ended June 30, 2023, and the 2023-2024 Estimate of Needs (SA&I form 2631R97) and : the Publication Sheet (SA&1 form 2631R97) for Ottawa County, included in accompanying prescribed form. We have performed a compilation engagement in accordance with Statements on Standards for Accounting and Review Services promulgated by the Accounting and Review Services Committee of the 5 AICPA. We did not audit or review the prescribed financial statements, estimate of needs and | publication sheet nor were we required to perform any procedures to verify the accuracy or completeness of the information provided by management. Accordingly, we do not express an opinion, a conclusion, = nor provide any form of assurance on these prescribed financial statements. The prescribed financial statements, estimate of needs and publication sheets forms are presented in = accordance with the requirements prescribed by the Office of the Oklahoma State Auditor and Inspector per 68 OS § 3003.B as defined by 68 OS § 3004-3011 and are not intended to be a complete presentation of the County's assets and liabilities. . This report is intended solely for the information and use of management of Ottawa County, Oklahoma, the Excise Board of Ottawa County Oklahoma and for filing with the State Auditor and Inspector and is = not intended to be and should not be used by anyone other than these specific parties. o —Tnees Associates, PLE TURNER & ASSOCIATES, PLO. ==~~SOSC~SCSCSSSSSSSSSSSSSSSSSS mR | S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023, a --- OCR page 5 of 77 --- = eee AFFIDAVIT OF PUBLICATION STATE OF OKLAHOMA, COUNTY OF OTTAWA Personally appeared before me, the undersigned Notary Public, E CAE m 15 Q County Clerk of the County and State aforesaid, who being first duly sworn according to law, deposes and says: That he/she complied with the law by having the financial statement for the fiscal year ending June 30, 2023, and the estimated needs and the gE estimated income from sources other than ad valorem taxes, for the fiscal year beginning July 1, 2023 and ending June 30, 2024 published in one issue of the Miami News Record a legally-qualified newspaper published - of general circulation, in said county (strike inapplicable phrase) a copy of which together BE with proof of publication is herewith attached marked Exhibit "Z" and made a part of hereof. a] aN jounty Clerk Subscribed and sworn to before me thigeay of _Yobeben 2023. E = ian Af LUA —A-O\= aan viary Public My Commission Expires OFFICIAL SEAL ’ . Win, ee. HAL BRUNNER / SNM! Ton, c “Je Nome PUBLIC OKLAHOMA SO OTA ses [EAS OTTAWACOUNTY SO? ROTA ee |e yay, no, 22002227 EXP. 02-45-26 oo = ~fortawa county3™ =| = : #23011885 : = E pi EXP. 09-01-2027 FE sa. PAS r GRU SS “uf, OF OK “ag, » S.A. and I. Form 2631RO1 Entity: Onawa County, 58 ‘October 19, 2023 = --- OCR page 6 of 77 --- sd ceo oun GL THEE EFIT | seman eames OM tet RaTRR NCR eo tact iin ndiiesene lo) p BRISCAL YEARENDING JUNE 30, 2004, OPTHEGOVERNINGDOR en ee _ BIRTESENTORFINRCMC CONDON —] os a Sep Long ie ~ASOpmUNES 2s ie a ee Ca ea axe: | I EE : eas tee ee | ies (Paastosee er rh ‘tees SS es a Ce Ce vel eon Warns Ss BREA] SCRE 433s » | Baverton etter] $$ a Bat (eg OTAL LIABILITIES ARD RESERVES [35,708 ar J Nee ie CASH FURD BALANCE (Decl JUNESO,I09S Tsay ST || Ct. Se ed aN ORY _ EINATEOPNENDS a we Dickies [Reserves for nereston Waris Reventon [$8 [cakes e's een 19) oof eects CERTIFICATE SGOVERNING BOARD © cht rll oh ae ees : STATEGFOMLAHONA COUNTYOROTTAWA xe i ang Nb as ! dy elected used Governing Otcers af Orawe Counvy, Otlabem Wo herebyceifjahat a meeting OES Gaeta iene ern ne) ail? islet ‘GHOIS: 1991 Secs 3003the foregoing stement sas prepared ard is tue end correct condition ofthe Financial Affairs of eid - ‘toon a efleced by the roan ofthe‘ Couny Clerk end Treasurer Wetter cenify thatthe forgoing estinats for caret ORS 0 -expeses ore fiscal yea beginning Jy J, 2023, sn ending Sune 30,2024 as shown arereaorably neces forthe prof AN i ‘ondoet ofthe Airs oF the sid Coury, thatthe Estimate Tacometo be derived from sources her hamn ad valorem wales — By does nok exceed the lnwfully uthorned radon ofthe revenue derived from he seme sources dicing the preceding fica a UNH) Chana of Boud Bi Mant aiid | BON ae bested ed nara bere ma ~ | ester my : Braver CQ ckelner 20. SN MITE, | SOC SOMONE Ff OTTAWA cowry S.A en. Form 2531RO1 Eatiy:Orawa Coen, $8 F betrattiees } 2 onotecis.ams BoA OP teavay fF RetvasecSs . “i OF ORNS Page 76 Estimate of Needs by Appropriated Account for 2023-2024 a _ eee ene Et vaeamzam —_—_| I: nrestricted Expenses for the General Fund: _. | Governing Board | Exclse Board [Mio,Follimesslanes CdS S000 52,000.00 | a a [into fulltime sades SS SE CC | A ET (2008: Maintenance & Opsaion Sr] {(- 2020, Profesionsl Services Ce FE 7 | [Departments ( Oo, Treasurer — = 4 | PT Fate ia |. emeomn | sco] [isto-tael Seo S58 ‘Deparment: 0500, Commasioners (Ti, Fulltime sles dS anon Sasa [steel S20 ca fg .000 | Sp om O80 eee rf a | [a eae es $5 tonsa 000 | \ ler et [ito Fulltime saares 8 SSRIS SRST [ste Trevet sat) [anus Mamenenoe Opens 36ABIS | S___—36853.15) ee A es ee i trio, ful time salaries args SSB Ea EP] ERENCE ee CT | EL [Deparment 1600, Aueseor t 1110, Full time salaries pee [2005 Metmenanee B Opertiog 2S A es ae titostulhimessanes SSSR [none Maimenance @ Opemios 9c ss 09 {—fon0-Praesional Seniees 8 = s000.00 fs 90,000.00 [Caso DesseMRenials anno fs. SO --- OCR page 7 of 77 --- ‘S.A, and], Form 26310 Enty: Otawa County, $B ® g ye 719.2033 | | Page77 © : = " ____. Estimate of Needs by Appropriated Account for 2023-2024 Sf ATEN i v .. oor Gey, gal Year 2023-202 REDE ie a [s304000.0 | eS Tf Int bara Cee [Ss 2093 | SET SS THO, Fulltime salaries: [3 ssoraz y's 153,012.80) | | 1g0jPareTimesalareg om Stas 00 | S450] EL Ne emma Se) oe oe (Department: 2700, Bmergeney Management | TE fi | | [-—_ Total or 700, Emergeney Management YS TORBAY STO SEAD [ 2020, Professiona) Seniees SSF { (L201, Premiums d:Awaris 0d [s__9500,00] { 1130, PartTime salaries ters aissr2i as | | 2070, Professional Services sss} S.A. and |, Form 2631R01 Entity: Ottawa County, 58 ‘October 19, 2023 --- OCR page 8 of 77 --- \ = COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page | ESTIMATE OF NEEDS FOR 2023- | EXHIBIT A ane [Schedule 1, Current Balance Sheet-June30,2023 =r r we Cash Balance June 30, 2023 S____ 192624096 [_tevestments |_TOTAL ASSETS SH [LIABILITIES AND RESERVES: $ 62,533.74 [js r Reserves From Schedule 8 g 122,641.15 TOTAL LIABILITIES AND RESERVES 3 185,174.87 CASH FUND BALANCE JUNE 30, 2023 S____1,741,066.09 r TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE S___1,926,240.96 ichedule 2, Revenue and Requirements for 2022-2023 ____ — iY Ld rP REVENUE: l ‘Adjusted Cash Balance June 30, 2022 S___1,548,718.49) Cash Fund Balance Transferred From Prior Vears $ 677,676.39 AILAd Valorem Tax Apportioned S__1,998,818.78 r Miscellaneous Revenue Apportioned S___3,319,539.47 TOTAL REVENUE 3__7,544,753.15 REQUIREMENTS: Claims Paid by Warrants Issued $___5.681,045.91 Reserves From Schedule 8 $ 122,641.13 js Reserve for Interest on Warrants is] r TOTAL REQUIREMENTS S___5,803,687.04 ‘ADD: CASH FUND BALANCE AS PER BALANCE SHEET JUNE 30, 2023 S___1,741,066.09 __TOTAL REQUIREMENTS AND CASH FUND BALANCE S_7,54,753.13 r schedule 3, Cash Fund Balance Analysis - June 30, 2023 Restricted Sales Tax |[ Amount _| [ADDITIONS: fiscellaneous Revenue Collected in Excess with Transfer Adjustments $ 211,098.86 s 456,240.30 r farrants Estopped, Cancelled or Converted [js [s_ [Fiscal Year 2022-2023 Lapsed Appropriations s 429,339.30 |S 23,738.21 ||$ 453,077.51 ‘iscal Year 2021-2022 Lapsed Appropriations $ 653,475.75 |[S 24,200.64 |[$ 677,676.39 [Ad Valorem Tax Collections in Excess of Estimate $ 15410789 fT LS 154,107.89 Pr ‘OTAL ADDITIONS S___1,448,021.80 |S 295,080.29 |[$___1, 741,102.09 \ DEDUCTIONS Td [Supplemental Appropriations $ (14,714.00)]| $ 14,750.00 ]|$ 36.00 F (Current Tax in Process of Collection a ee | r ‘OTAL DEDUCTIONS $ C4714. 00S 14,750.00 [$36.00 [Cash Fund Balance as per Balance Sheet June 30, 2023 [S___1,462,735.80[$ 78,330.29 1, 741,066.09 L r S.A. and I, Form 2631RO1 Entity: Otawa County, 58 October 19, 2023 --- OCR page 9 of 77 --- ™ | Page 2 COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 7 A ao ——— ee] AdVatoremTares [sss s99sz04 fs 39,952.04] [9003 Back Year Sa oon iss son s7 |S 23.502 57] 7 ' 7 [S____ 8976.0 [s 55:013.09 [S46 03609] | | 9106CountyClerkFeesSSC«dSS«1 42,624.94 [S___128,362.45[$ __127.595.67[$____—(766.78)| 7 4 [S___368.60225 [$302,641.91 |S 6,980.30) [sa 6628 [sa ie628 TS 9 " [s___8.08| 4 [ss ros 700 [Ss ro T5700 - : [ss 3570 Ts 5468.70] [ss 1272.00 § 1.27200] 7 a Ce Ss [ss [S600 [sR SISTA | [014 Seles Tex tere ss ss 7 [2418 Miscellneous Sale Tax Reesips ss ss [Restricted Seles Tex Tmerest Ss ss 7 ‘ S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 7 7 } --- OCR page 10 of 77 --- r - COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 3 r ESTIMATE OF NEEDS FOR 2023-2024 1 EXHIBIT A Bass & Limi [2005000 Recount) Estimate Governing Board Excise Board [_ 9001 Cunent Tax dT r es [9003 Back Year [AdVatoren Texto r Laos estes as aires 8] r | r ( [sso Ts 355,193.56] r r [s___1608[s 16004] r — Ss 2 a r [ss [= ated ["9s09'Ressle Dison coef ST es r ["_Total for Miscellaneous Revenues SSC for Miscellaneous Revenues [| a ke | Ge r [9418 Miscellaneous Sele TaxReseips Sid ms [S____- | ___} r CI eer |} fs rr Pr if c S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 11 of 77 --- r ! r COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 5 | ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT A F | [Cash Balance Reported to Excise Board June30,2022 IS dS 270453003 | | Cash Fund Balance TransferedQut IS gs oT Jad Valorem Tax Apportioned Song's | [Miscellaneous Revenue (Schedule 4) YS 89.5397] r [Cash Fund Balance Forward From Preceding Vear S67 676395 id [Prior Expenditures Recovered SC [FOTAL RECEIPTS dS S99 RASS r linterest Paid Thereon r [Reserve for Warrants Outstanding S337 fs [Reserve for interest on Warrants Ss [Reserves From Schedule taste r FOTALLIABILITES ANDRESERVE SSA TS . DEFICITS ss r iment and AN Pro Years [Warrants Outstanding June 30 of Year in Caption SS 157 80z.si [S137,892.41] r [Warrants Converted to Bonds or Judgements S'S C'S r [Warrants Cancelled CdS . [Warrants Estopped by Statute S's ss . Eee ee r lAdditionss tg [Deductions [Gross BalanceTax 2.029.181. 98 | r [Reserve for Protest Pending r [Net Balance 2022 Tax in Process ofColletion T'S [Excess Collections dS 90,653.28 J r ‘ ropriations ‘Warrants Approved by r fi200Fringe Benefits S'S ss cr ‘S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 12 of 77 --- “4 Page 6 COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 7 EXHIBITA i Warrants Balance JUNE 30208 *] RPPROPRIATED ACCOUNTS. ipoeieel Since Lapsed Original 6-30-2022 Issued ‘Appropriations Appropriations 7 [ss | ! [s__tiso Ts 1587.40 [$s 123.90 5 | [ss [ss ss 7 eS CS || [s__ 526.00 [$263.00 [Ss 263.00 | $ | [Total for Sheriff S25 107 TS TROT ATS 6905.69 | S [ss [ss gs a ee ™ (Fotal for Treasurer IS SCS C~=*@d | , a a | = ELL | FN [s___8.839.91 [$8899.91 [Sd [ Wo Futltime salaries YS SS SY 4 [1310 Travel [s_ 6213.12 [$ 62s ts | [Ss “ 7 [ss T [1310 Travel sss 4 [Ss . Se Ea (SO [eee eee [s_ 298.98 ['s29898 |S "| [S_____ 298.98 [5298.98 [Sd \ [ss 7 |_1310 Travel sss | [sO 75.00 [sO 75.00 [S$ [S____ 75.00 [SOS SS —_—=i3 2,391.40 | [sss 7 [1310 Travel sac ss 12000 [s__isa01.a2 [sana [s- [s__ 4228.00 ['§ 4z2800[s ‘| a CC CS | [s___ a weals ears a00| S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 ‘7 7 --- OCR page 13 of 77 --- P COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 7 i EXHIBIT A ESTIMATE OF NEEDS FOR 2023-2024 r ; Supplemental Net feos Warrants Asna ees by Approved by ‘Adjustments ‘Appropriations Issued Known to be Governing County r Unencumbered Board Excise Board [ss a0,00000 TS 40,0000 SY r .$—_— ese ened [sos 2,620.50] 500.00 [$__42,879.50[S = TS 2.62050] . [s___65.000.00['sas.si8a2[s 1380083 [S «dS 7assooys dS Cid r [ss sss ss sar] |s_— 150,250.00 [s"630,82533 |S s58.e0997[s ranveaa [Ss ameeels ~~ s 496,285.24 ae es a a [ss 383,024.22 | [S996 84 | r [STs as.ass27] [s_4.232.a5[ 176559704 TS 176585 [SST] |s_ 39828 [s10.85724 |S tosszza[s Os r [SU 5,432.85 |S ann as [S705 12 [ss 0773 | [S__ 1598.24 TS 194,887.13 [Ss 194,466.09 TSS 421.04] r [ss 226,460.67 [$225,608.77 [$855.90] [ss 2,000.00 [$524 io [ss 475.90] [SS 10,406 55] 7 216.09 [ST 3.190.46 | : [SS RT IDS B9S38a96 |S ___-_ |S _ 8872.36] Pr ' [ss 28,000.00T ss 100,20430 Ts 4,000.00 Ts 23,705.70 | [sO 15,000.00 [$s 15.22699 Ts 67.79 [$605.22 | is [ss 13,0000 TS 9,7as99[s 2.704sg[s 548.43 | r [ss 2,646.00 [s2,20426 TS 220.3 |S 22131] —_—— sss TS ras ara sa |S —Bose.80- Ts 25,080.66] r [ss G9 Ssa7zioaa |S 33432680 TS TS 2.883.64 [s___sz.os[s aanos|s7eios[s [Ss [s—- ~'(s —s6aszas[s27.66255[$ 467009 [$4,120.51] is (Sass [s songs fs r [s_- {s _selaosaz [Ss 369.4318 [S__ 4,670.09 [$7,004.15] [s____—‘14330.78[S__sisea7onyS a66asaaaTs TS 49,193.54] r Is sa0s[seaigs[samsigs[s = [S { [Ss -_'|s 3000s S000 S| (Se [sss [Sa |S 300.00 9,193.84 : [s__sa0stssons7s[saova7s[s_ Ts [s_ S_—* 300000 $1005.50 [S500 TS 219.50 [S_____ 824529 [Ss 1anese7s[8 140sz1.60[S 7500S 240.15] Fr Is 7aaz.oa]s _1as04zo TS rar gonz9[s S000 [s______Gasonfs_aaraarts savas fs 4 (s____ais7ao[sti,ig7ao[s 3.99206 [8 S20s3a[s r [s_____492s00[s _95,928.00[s sszago[s TS [s______Giesan[s 31s [S ais st [Sd CBOSS 248,130.99 TS 5.20534 TS (0.00) [ S.A. and I, Form 2631RO! Entity: Ottawa County, $8 October 19, 2023 --- OCR page 14 of 77 --- al Page 8 COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 a EXHIBIT A ———————— ‘Schedule 8: Report OF Prior Year's Expenditures cede Spe FISCAL YEAR ENDING JUNE 30, 2022 FY ENDING 2 — Balance JUNE, 30 2023 DEPARTMENTS OF GOVERNMENT 7 arrants al ; .PPROPRIATED ACCOUNTS. Faery Since Lapsed Original Issued Appropriations Appropriations Dept: 2000, General Government 7 [ii0Fultinesslres 8 sd $ 102,359.13 1130 Part Time salaries [ss ss 38,734.80 2005 Maintenance & Operation $ 8,027.82 | $ 5,300.65 [$ 2ma7A7N$ 300,000.00 7 2999 Contingencies [js ts ss 777,231.86 4110 Capital Outlay $ 888,956.70 [$ 245,831.63 [$ 643,125.07 //$ i ‘otal for General Government 5 $96,984.52 [528113228 |S 645,852.24 |[S____1,218,325.79 = Dept: 2100, Excise Equalization 1110 Eull time salaries [SS TS 1,937.70 ‘otal for Excise Equalization [js SSS 1,937.70 [Dept: 2200, Election Board L 1110 Fulltime salaries [sss TS 159,334.17 1130 Part Time salaries [ss ss 1,400.00 1310 Travel $ 100.00] $ 56.16 $s 600.00 - 2005 Maintenance & Operation 3 1,520.00 [$ 1,470.00 | $ $0.00 || $ 17,000.00 i‘ 4110 Capital Outla a ES Ce 2,100.00 4130 Lease/Rentals [SS 1.02500 ‘otal for Election Board $ 1,620.00] $___ 1526.16] $_93.BE TS 181,459.17 - [Dept: 2500, Information Technolog) 2005 Maintenance & Operation $ 4,415.00 [$ 4365.00[S_——50.00]] S 25,000.00 ‘otal for Information Technology [s____4,41s.oo[s 4305.0 50.005 25,000.00 [Dept: 2700, Emergency Management ts 1110 Fulltime salaries [ss TS 138,783.35 [1310 Travel ss ss 3,000.00 2005 Maintenance & Operation 3 363.87 | $ 357828 «GOSS. 14,000.00 4110 Capital Outlay [sss 4,000.00 ™ ‘otal for Emergency Management s 363.87 [$ 357.82[S 6.05 |S 159,783.35 [Dept: 4500, County Audit Budget 2020 Professional Services a Se CE 35,202.13 = ‘otal for County Audit Budget [SS TS SES 5520713] [Dept: 4600, County Cemetery 2005 Maintenance & Operation a Ke SS Ey 400.00 ‘otal for County Cemetery [SS SS 400.00 a [Dept: 4700, Free Fair Budget — | 2015 Premiums & Awards $ 136.64 [$ 136.64[$ SS 9,500.00 otal for Free Fair Budget [S___ 136.64 [SSCS 9,500.00 ‘COUNTY GENERAL FUND ACCOUNT = * Sub-Total of Expenditures $s 978,403.45 |S 324,927.70 S$ ____-653,475.75 |S 4,353,913.41 ‘SUBJECT TO WARRANT ISSUE ~ Total Provision for Interest on Warrants [ss eS dS TOTAL UNRESTRICTED EXPENSES FOR THE COUNTY GENERAL FUND . LL ™—~—OC#@CS ‘978,403.45 | $ 324,927.70 [$ 653,475.75 || S 4,353,913.41 ° sate BA Report OF SY ‘Schedule 8A: Repont Of Prior Year's Sales Tax | FISCAL YEAR ENDING JUNE 30, 2022 FY ENDING JUNE, 30 2023 i [DEPARTMENTS OF GOVERNMENT % of 5 APPROPRIATED ACCOUNTS ot A Warrants Since! | Originat ‘Supplemental Sales ‘eserve Issued | L@psed Balancey ciation Adjustments 7 Tax S.A. and I. Form 2631RO1 Entity: Ottawa County, 58. October 19, 2023 i. 7 --- OCR page 15 of 77 --- Pr COUNTY ean eae THE PERIOD 7/1/2022 TO 6/30/2023 Page 9 i |ATE Of 3 | mera F NEEDS FOR 2023-2024 Schedule 8: Report Of Prior Year's Expenditures = r FISCAL YEAR ENDING JUNE 30, 2023 FISCAL YEAR 2023-2004 | Lapsed Needs Supplemental et Amount Warrants neveves Baer er Approved by Adjustments Appropriations Issued Known to be Governing B County r Unencumbered Board ecedeT i] [Dept: 2000, General Government is CS*dCSS 102,359.13 $ 100,150.85 $s 2,208.28 [|S 37,375.22 | $ $7,575.22, is S'S 38,734.80 | $ 37,366.65[$ —-_—*'(|S 1,368.15 |S 30,000.00 | $ 30,000.00 $ 98,500.00 | $ 398,500.00 [$ 364,342.87 [S$ 10,353.14|S 23,803.99 /$ 400,000.00 | § 400,000.00 $ (569,805.33)| $ 207,426.53 | $ 8,900.23 S$ 198,526.30|][$ 670,445.71 [$ 448,712.61 y 442,808.07 | $ 442,808.07 [S$ 442.80807[S ss - ~_[S ____0,00|[$ _$00,000.00|$ 300,000.00 s (28,497.26)| S 1,189,828.53 |S __953,568.67 S 225,906.72 |S __1,658,020.93 |S _1,436,287.83 [Dept: 2100, Excise Equalization [$s 36.00 TS 1,973.70 | $ 1,937.79[$ __- +s 3591S 2,422.35 |S 2,422.35 = [s____—=36.00 TS 1,973.70 |S 1,937.79 {$= S35 2,422.35 |S 2,422.35 r Dept: 2200, Election Board $ 2,000.00 | $ 161,334.17] S 146,963.00 $ 14371.17][S 135,079.42 [$ 133,012.80 [s_.02s.00 |S 2,425.00 |S 1,727.82 $ 621.828 2,445.00] $ 2,445.00 a coooo[s 39a [s LS 201.29|/s 650.00 | $ 650.00 r [SCS 17,000.00 | $. 9,449.11 [$ 120,00 [$ 7,43089[$ 18,000.00] $. 18,000.00 § (2,000.00)[ $ woools - |s- *|S 100.00 || s 2,100.00 | $ 2,100.00 $ C,025.00[ ss ss 1,100.00 | $ 1,100.00 | 181,459.17 [S__158,538.64 |S 195.36 [S$ 22,725.17 |[S___179,374.42 [$177,307.80 [Dept: 2500, Information Technology a 25,000.00 [$ 7079.75[$ -_([S 17,920.25 ][$ 50,000.00] $ $0,000.00 | rs cs 25,000.00 |S 7079.75|8_- +S 17,920.25 |[$__ 50,000.00 | $ 50,000.00 r [Dept: 2700, Emergency Management $ 4,000.00 [ $ 142,783.35[$ _la2aaii6[s Ss -—«d'S 342.19|[$ 140,036.49 [$ 140,036.49 es 3,000.00[$ 1.80188 |S. 200.00 | $ 998.1215 3,000.00 | $ 3,000.00 ra [ss - *‘((S 14,000.00 | $ 9,851.83 $ 3,024.17 || $ 15,000.00 | $ 15,000.00 a 4,000.00 |S o9098[S CdS 3,009.02 }[$ 4,000.00 ['$ 4,000.00 7 3 4,000.00 |S 163,783.38 [S__ 155,085.85 [$ 7,324.00 [5 7373.50 ||S 162,036.49 |S 162,036.49 [Dept: 4500, County Audit Budget rs ry 3520213[8 - ‘(Ss - ~‘ids 35,202.13] S 77,215.32 | $ 77,215.32 a PD I ES PED EE [Dept: 4600, County Cemetei [ss 200.00 [ss TS 400.00] $ 1,000.00] $ 1,000.00 r [sd aooots SS 400.005 1,000.00 [Dept: 4700, Free Fair Budget [SSS ‘9,500.00 [S 8.195.00 |S 1,294.55 $ 10.45 ]/$ 9,500.00 [$ 9,500.00 P [sd 9,500.00 |S 8,195.00 | $ 1294s |S Was|[S__9.500.00 TS 9,500.00 COUNTY GENERAL FUND ACCOUNT. $ (14,714.00)[S ___4,339,199.41 [|S _3.805,451.35|S _104,408.76|S 429,339.30] S _ 3,965,810.09 [$_4,727,065.58 ‘SUBJECT TO WARRANT ISSUE (SS TS SS SS t TOTAL UNRESTRICTED EXPENSES FOR THE COUNTY GENERAL FUND. 3 (14,714.00)[ § __4339,199.41 [S$ 3,805451.35|S 104,408.76 [S _429,339.30][S _ 3,965,810.09 |S _4,727,065.58 F = r Schedule 8A; Report Of Prior Year's Sales Tax FISCAL YEAR ENDING JUNE 30, 2023 FISCAL YEAR 2023-2024 Excess/Shortfall Total Net Warrants " Lapsed Balance| Collections over } Sales tax Interest Estimated ST from Appropriations as Appropriations Issued ‘eserves | Lapsed Balance} estimate Schedule| Schedule 4 Schedule 4 ‘Approved by . 4 Excise Board c S.A, and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 16 of 77 --- 1 Page 10 COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 7 EXHIBIT A i Schedule 8A: Report Of Prior Year's Sales Tax FISCAL YEAR ENDING JUNE 30, 2022 FY ENDING JUNE, 30 2023 7 %ot IDEPARTMENTS OF GOVERNMENT . Total Warrants Since Original Supplemental } APPROPRIATED ACCOUNTS, Soles Reserve issued | CAPSC4 Balance} opriation | Adjustments Tax 5 [Dept: 8004, Sheriff-ST { 1110 Full time salaries $2,795.13 |$__2795.13|S8 _- [|S 1.526,481.63[$ 14,750.00 , 1130 Part Time salaries Looms - [s- [s = ls 2000000, -_| 2005 Maintenance & Operation S$ __32,690.47|$ _13,64657|$ 19,043.90|/$ —- ~—‘([$ 10,000.00 2020 Professional Services $_15,000.00[$ 9.843.26[$ 5,156.74|[$ 346,902.67 | $ (10,000.00) 4130 Lease/Rentals [ooo s [sss 943084[s | ‘otal for Sheriff-ST 0.00%] S 50,485.60 | $ 26,284.96 |§ 24,200.64||$ _1,902,815.14|$ 14,750.00 COUNTY GENERAL FUND SALES TAX ACCOUNT __ 4 ‘Sub-Total of Expenditures 0.00% [S$ 50,485.60 $ 26,284.96 | $ 24,200.64 ][ $_1,902,815.14 | $ 14,750.00 | ! \ a] 7q H : S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 7 ! --- OCR page 17 of 77 --- 2 5 COUNTY GENERAL COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page I) ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT A ’ Excess/Shortfall Total Net ‘Warrants Collections aver | Sales tax Interest |] Estimated ST from} Appropriations ‘Appropriations Issued Reserves | Lapsed Balance] e imate Schedule] Schedule 4 Schedule 4 repproved by 7 7 4 Excise Board [S_1,541.231.63 [sisaizie[s [ss TS 1 [s__20,00000[$s igs903a[s [Ss oee [Ss [s__i0,00000[s ss = [s 10,000.00 [$s IS aoszazas[s | [s_ 336,902.67 [$306,771.33 [$18,000.00 [$ i2a3134[$ SS eaoa zz s S__sasose[s— 7ao26|s—nasr|s—isorai[s——]s___]s__ sees] i [S_1,917,565.14 | $1,875,594.56 [$18,232.37 [323,738.21 [SS | S$ 1,917,565.14 | $1,875,594.56 [$18,232.37 [S$ _23.738.21[$ = SYS 2,818,184.93 |S 1,788,129.72 | | ‘Needs by County PURPOSE: Govenring Board ||_Excise Board , . a ‘ " n mn rm S.A. and I. Form 2631R01 Entity: Otawa County, 58 October 19, 2023 --- OCR page 18 of 77 --- r COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 13 ESTIMATE OF NEEDS F % r EXHIBIT D EDS FOR 2023-2024 Schedule 1, Current Balance Sheet- June 30,2023. EEE r a Cash Balance June 30, 2023 ee THEE [__TOTAL ASSETS SS [LIABILITIES AND RESERVES: Warrants Outstanding $ 24,339.44 Reserve for Interest on Warrants r Reserves From Schedule 8 $ TERT E TOTAL LIABILITIES AND RESERVES 3 43,215.32 "ASH FUND BALAI JUNE 30, 2023 Sn 7,858,912.91 r [__ TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE S___1,902,128.23 schedule 2, Revenue and Requirements for 2022-20 - a REVENUE: ‘Adjusted Cash Balance June 30, 2022 S$ 1,430,793.75 ‘Cash Fund Balance Transferred From Prior Vears $ 3,487.44 Miscellaneous Revenue Apportioned S_2,476,738.24 P TOTAL REVENUE 5391101943, Claims Paid by Warrants Issued S$ 2,033,230.64 Reserves From Schedule 8 $ 18,875.88 is Reserve for Interest on Warrants ae TOTAL REQUIREMENTS S___2,052,106.52 Pr "ADD: CASH FUND BALANCE AS PER BALANCE SHEET JUNE 30, 2023, S$ 1,858,912.91 if TOTAL REQUIREMENTS AND CASH FUND BALANCE $ 3,911,019.43 L r S.A. and |, Form 2631R01 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 19 of 77 --- | Page 14 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 a | a er 1 | [9110 Donations JS Js = [82,0000 Ts 2,000.00 y (SS 2.000.00 SF, 000.00 4 [9204 Grans-Swe ———SSSSCSC~diS (dS TS ($0,000.00 $50,000.00] | [s__2o1asgo2yis = 'S281,383.78 |S 281,383.78] a ES | [ss 780,184.91 [$780,184.91] 4 [s 466,806.86 [5 —<([S 432,280.22 [$432,280.22 ! [s___tiosafs ST taa.ze fs 140.78 [s______-_|$ 25529990 [$255,299.90 = [ss 134,641.67 [5 154,641.67 [79241 OTC: Motor Vechile IRB IS 250098421 [SS 425,256.08 [$425,256.04] : [Total for State Revenues dS aTTOST YS dS 7987.30 |S __2,979,187.90 | a EE | ES CS | [ss 13,231.83 [313,231.83 | = [ss [66,824.69 |S 66,824.69 | | [sss |_9411 Sale of County Owned Assets TS to77agolfs «dS «393,75 [8 8,393.75 | o* [9412 Sale of County Owned Propery dS OS SC STC CdS CTC CSY LAS415 Miscellaneous Ss [SS aga S_88.45027 | [sos 276 738247 Ss 2,476,738.24 | : [ 9014 SalesTexterst ss Sd | 9216OTC-SakesTax dS SS «dS CY [ 9418 Miseeiancous Sale TaxReseips Ss 3 7 [_ Restricted Sales Tax Tmerest ss : [STS areas |S 2.476 738.24 | 4 I S.A. and I. Form 2631RO1 Entity: Otawa County, 58 October 19, 2023 7] “7 | --- OCR page 20 of 77 --- . = COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 15 ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT D. Basis & Limit Estimate Governing Board Excise Board a Fa | " a | | | [ss a eS ee Ss CT a " [0s fs |_9212 OTC -Gasolinetax oor se es = es es LC a Fe [| o.0nfs se a ka = |_ Totalfor Site Revenues iS Sd a es a SC | ” [ss [sts , _|[Caoo Resale Disvibutin dss a Ce [ss a a [Total for Miscellaneous Revenues Sd S.-i ~s -| [oot Sees Tax niet 000s r [ss [9418 Miscellaneous Sale TaxReseps Oona ce a | | r [Grand Total ofAM Revenues Sd c S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 21 of 77 --- = > COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 17 ESTIMATE OF NEEDS FOR 2023, EXHIBIT D 2023-2024 , ana B County Highway Unrestricted Fund Balance Sheet of Current and All Prior Vears ‘AND ALL PRIOR VEARS 2022-23 [__PRE-2022 | [Cash Balance Reported to Excise Board June 30, 2022 [Ss - ‘|s 1,487,135.12 Opening Balance from Prior Year Taare $ 1,430,793.75 |[$____1.430,793.75 | : Ses Fue ace Tanfored Out ae Cash Fund Balance Transferred In [ss Adjusted Cash Balance S$ 1,430,793.75][$ 36,341.37 ee A Piloa[beea Revenues $ 2,000.00 f[s | 9200|State Revenues 79,187.30 fs g30o[fedeal Revenues is 4» [9400 [Miscellaneous Revenues $ ssaso27[s_ i 9500|Special Assessments js_ fs All Other Revenues (Schedule 4) $ Ties [Cash Fund Balance Forward From Preceding Year 5 3.487.445 5 [Prior Expenditures Recovered [ss ‘OTAL RECEIPTS: $s 2,480,225.68 $= (OTAL RECEIPTS AND BALANCE $____3,911,019.43 ]/$ 56,341.37 Warrants of Year in Caption S$ 2,008,891.20|[$ 52,853.93 7 interest Paid Thereon [ss OTAL DISBURSEMENTS $_2,008,891.20||$ 52,853.93 (CASH BALANCE AND INVESTMENTS JUNE 30, 2023, S___1,902,128.23|[$ 3,487.44 , [Reserve for Warrants Outstanding 5 ssa Sid [sts [Reserves From Schedule 8 $ 13,875.88[s ‘OTAL LIABILITES AND RESERVE. $ B2i532(8 —-_—idt 7 pec: gs ICASH BALANCE FORWARD TO NEXT YEAR s 1,858,912.91 [Schedule 6: County Highway Unrestricted Fund Warrant Account of Current and All Prior Years J URRENT AND ALL PRIOR YEARS. [2022-23 || PRE-2022, ‘arrants Outstanding June 30 of Year in Caption [ss - sd 40,113.35 [$ 40,113.35 farrants Registered During Year $ 2,033,23064|[$ 14,475.72. 2,047,706.36 WOTAL dS 2,033,230.64 IS $4,589.07 || S___2.087,819.71 " [Warrants Paid During Year 5 2,008.891.20][$ $2,853.93 |S __2,061,745.13 [Warrants Converted to Bonds or Judgements Is is i——~+ = Warrants Estopped by Statute [s_-_ifs 1,735.14 18 1,735.14 OTAL WARRANTS RETIRED. $____2,008,891.20 [$ 34,589.07 |[$___2,063,480.27, TOTAL WARRANTS OUTSTANDING JUNE 30, 2023 s ss94ays LS 24,339.44 | n a ‘al a [Schedule 9: County Highway Unrestricted Fund Summary of Expenses. ‘Net Appropriations Warrants “Approved by ‘otal for Expenses July 1, 2023, Issued belied County Excise Board - 1 100 Total Salaries $ 1,060,768.52 |[$ 396597405 dS (746,050.75)) . i ds ds 1300 Travel Related 5 65,019.12 |S 44,347.68 || 450.00 || $ (30,304.60) [2000 Total Maintenance & Operations S$ 1,990,702.66 | $ 795,239.60 |S 18,425.88 || $ 344,593.69 r 4100 Total Machinary & Equipment, Capital Outla} s 7297,085.96|5_——-_~—‘(S (113,040.22)} . SA. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘October 19, 2023 P i --- OCR page 22 of 77 --- - Page 18 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2022 TO 6/30/2023 - ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT D ——————= Teereduie 8 Reon Of ior Years gentry % Report Of Prior Year's Expenditures . JUNE, 30 2023 DEPARTMENTS OF GOVERNMENT ae Warrants Balance Original PPROPRIATED ACCOUNTS 6-30-2022 Since apse 7 gir al Issued ‘Appropriations ‘Appropriations tina] s nas 300] a ae [cere es ee (acs ese [ere ar [S__228426[$ __—228i26[S 3.00 « a ce Cer a a Cs es es es a ce 7 a as ee es ee a [Stoo fs toni [s _(0.80)] ' Sa Sos ee rr [00s Mametarce& Ope [$e] a cs ss ' FF TV HIGHWAY UNRESTRICTED FIND ACCOUNT ' .—— Fo ; S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 23 of 77 --- a 5 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2022 TO 6/30/2023 “Page rg ESTIMATE OF NEED: x — ao S FOR 2023-2024 . Schedule 8: Report Of Prior Year's Expenditures 1 FISCAL YEAR ENDING JUNE 30, 2023 FISCAL YEAR 2023-2024 N Lapsed Needs as Super let Aout Warrants Balance Estimated by Approved by djustments § Issued ree a County Appropriati wn to be Governing “ 1 sh Unencumbered Board eee Dept: 4100, Highway District 1 — $s 292,428.99 | $ 344,900.82] $ 290,172.52[$ —-~—*d'S $4,728.30 || 54,728.30 [$ 54,728.30 , $ 21,308.04 [ $ 23,815.88 | S 16,25835[$ - ~‘(|$ 7,557.53 ||$ 7,787.53 | $ 7,157.53 $ 110,980.88 | $ 48247321 [8 143,622.90 $ 843.89 |S 338,006.42 [$338,006.42 [S$ 338,006.42 s 30,580.36 [$ 42.638.81[$ - ~|S -~*‘IS 42,638.81 |S 42,638.81 | $ 42,638.81 $s 114,034.43 [$ 125,442.16 | $ 66,608.20[$ (dS 58,833.96 |S 58,833.96 | $ 58,833.96 , 3 369,332.70 | § 1,019,270-88 [$16,661,971 S 845.89 [S 501,765.02 |[$ 501,965.02 |$ 501,965.02 Dept: 4200, Highway District 2 $s 268,150.62 | $ 315,562.73|$ 260,82216[$ - —<d(S $4,740.57] $ 54,740.57 |S 54,740.57 $ 13,668.00 | $ 15,961.70 | $ 9,875.93|$ 450.00] $ 5,635.77 |[$ 5,635.77 | $ 5,635.77 : Ss 135,537.81 | $ 421,299.38 [$ 181,861.68|$ 14,175.27 $ _225,262.43||$ 225,262.43 |$ 225,262.43 s 81,911.56 | $ 101,911,56[$ _25,17400|$ _—-_~‘|$ 16,737.56 || $ 76,737.56 | $ 76,737.56 $ 117,000.00 | $ 132,899.33 | $ 92,133.72 [5 - ~'‘|S 40,765.61 || $ 40,765.61 | $ 40,765.61 $s 616,267.99 | $ 987,634.70 | $ 569,867.49 |S 14,625.27] $ __ 403,141.94 |[$ 403,141.94 |S 403,141.94 . [Dept: 4300, Highway District 3 $ 349,642.26 | $ 400,304.97[$ 345.602.7285 - ~‘(1S 34,702.25 |S 54,702.25 [$ 54,702.25 $s 16,000.00 | $ 25,241.54 [$ 18,21340|$ ‘dS 7,028.14 $ 7,028.14 ; $ 192,273.27 [$ 414,237.16 [$311,413.64] $ 340672[S _99,416.80|$ 99,416.80 |S 99,416.80 $s $80.37 | $ 109,874.87 | $ 58,827.04/S - +S. 51,047.83 ||'$ 51,047.83 | $ 51,047.83 $ $8,132.27 [$ 103,478.00 | $ 54,303.00/$ = 1S 49,175.00 | $ ‘49,175.00 | $ 49,175.00 s 646,628.17 |S___1,053,136.54 |S 788,359.80 | S 3406.72 |S 261,370.02 ||$ 261,370.02 [$261,370.02 : [Dept: 6510, CIRB 2021-1 $ 141,752.01 | $ 208,417.40[S _12837247[8 Ss - _—*(S 80,044.93 [$ 80,044.93 [S 80,044.93 $s 141,752.01 | $ 208,417.40 | S$ 128,372.47|S = (|S 80,044.93 || $ 80,044.93 | $ 80,044.93 Dept: 6520, CIRB 2021-2 . $ 130,325.69 | $ 292,673.61 | $ 29,968.91]$ = - _[S _262,704.70][$ 262,704.70 | $262,704.70 $ 130,325.69 | S 292,673.61 | $ 29,968.91 [|S = dS 262,704.70 $ 262,704.70 Dept: 6530, CIRB 2021-3 s 141,752.01 [$ 17,601.90]$ - ‘(Ss - |S 171,601.90 |] $ 171,601.90 [$ 171,601.90 ’ $ 141,752.01 | $ T00190/$ 1S SOS 171,601.90 || S 171,601.90 | $ 171,601.90 COUNTY HIGHWAY UNRESTRICTED FUND ACCOUNT $ 2,246,05857 |S ___3,732,735.03 |S _ 2.033,230.64|S 16,875.88 |S 1,680,62851]/S _ 1,680,828.51 |S 1,680,828.51| + fSURECTTo Wannanr 908? (RE SS Go ee TOTAL UNRESTRICTED EXPENSES FOR THE COUNTY HIGHWAY UNRESTRICTED FUND. a $ 2,246,058.57 |S __3,732,735.03 |S __2,033230.64]$ 18,875.88 [S _ 1,680,628.51][S__1,680,828.51 $_1,680,828.51 1 = Estimate of Approved by ESTIMATE OF NEEDS FOR THE 2023-2024 FISCAL YE: cae He ing ise Board PURPOSE: Govenring Board : bee Bow ™ 7 Total of Unrestricted Expenses for the County Highway Unrestricted, Schedule 8 S$ 1,680,828.51 680,828. Total of Restricted Sales Tax Expenses for the County Highway Unrestricted, Schedule 8A. is -f|s - J GRAND TOTAL - County Highway Unrestricted Fund S__1,680,828.51 |S _1,680,828.51 7 a " S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 - --- OCR page 24 of 77 --- = oT HEALTH COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 21 ESTIMATE OF NEEDS FOR 2023-2024 EXHIBITE [Schedule T, Current Balance Sheet - June 30, 2023 a SERIE CC Cash Balance June 30, 2023 3 504,289.44 1 | Tavestments YS |_TOTAL ASSETS dS. 304,289.44 TABILITIES AND RESERVES: __ Warrants Outstanding 5 easeaT . Reserve for Interest on Warians Reserves From Schedule 8 5 7163050 TOTAL LIABILITIES AND RESERVES S 8,368.77 "ASH FUND BALANCE JUNE 30, 2023 [Ss 435,920.67 | a TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE _____ 3 304,289.44 [Schedule 2, Revenue and Requirements for 2022-2023 ‘Adjusted Cash Balance June 30, 2022 $ 362,047.74 Cash Fund Balance Transferred From Prior Vears $ 29,848.41 a All Ad Valorem Tax Apportioned $ 300,603.71 Miscellaneous Revenue Apportioned $ 15,191.78 [TOTALREVENUE SSCS ST REQUIREMENTS, ° Claims Paid by Warrants Issued $ 210,140.47 Reserves From Schedule 8 $ 41,630.50 [ss ; Reserve for Interest on Warrants | TOTAL REQUIREMENTS 3 751,710.97 ADD: CASH FUND BALANCE AS PER BALANCE SHEET JUNE 30. 2023 $ 455,920.67 TOTAL REQUIREMENTS AND CASH FUND BALANCE, $ 707,691.64 [Schedule 3, Cash Fund Balance Analysis - June 30, 2023 ADDITIONS. fiscellaneous Revenue Collected in Excess with Transfer Adjustments = ° |Warrants Estopped, Cancelled or Converted $ — Fiscal Year 2022-2023 Lapsed Appropriations = eT [Fiscal Year 2021-2022 Lapsed Appropriations : BuR 5 od Valorem Tax Collections in Excess of Estimate 2 aaa OTAL ADDITIONS, ______4 783. PeDUCTONS _—__ ISupplemental Appropriations 7 [Current Tax in Process of Collection ‘OTAL DEDUCTIONS ee [Cash Fund Balance as per Balance Sheet June 30, 2023, a re ma L S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 25 of 77 --- Page 22 HEALTH COVERING THE PERIOD 7/1/2022 TO 6/30/2023 . ESTIMATE OF NEEDS FOR 2023-2024 7 IB ———— 77 [stars [s___ soreness 13.6335] {sabe Prior Year dS seas goog s00847| ; Ls 34 56 [S53 53455 [otto Donations ss : [9s Reathfees [s_____- |s__9sen.ss['s_ 9.508355] fs —— as TSS | ' <a [s_____-_|s___2.8|s_____2.8 | [Total for Sate Revenues Ss SS S| | [S_______[s S05 ae Ts 5.009. | ee ee a Cee [S- ]s___ BisLe]s 15,151 78] [sss | a CS SE iss ds [Sane |S TESTS S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 19, 2023 . --- OCR page 26 of 77 --- m= : HEALTH COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 23 ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT E Basis & Limit Estimate _||_Governing Board Excise Board ST [ss -) [ss [9003 Back Year L_-Ad Valorem Tax Total CdS CCC C~CS~*d 5 [ss [ous Heath Fees [sg a = |_Total for Local Revenues CS CCS TC~CC~CS@dS as as " a a [_ 9407 Reimbursements of Expenditures 0 00% SS = |_Total for Miscellaneous Revenues SS a js gs J [ss [ss [90.00% $d Ls Sd gs a a Ce | [Surplus Cash from Senedule 3 dS sma [S900] 5 ° = - a r S.A. and. Form 2631RO1 Entity: Ottawa County, 58 October 19,2023 --- OCR page 27 of 77 --- . a HEALTH COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 25 EXHIBIT E ESTIMATE OF NEEDS FOR 2023-2024 1 |GRRENTANG ALL PRIOR YEARS os Fetus Reed Ecc BadIg30 0 rrr, [Opening Sas fon PorYaw fs aes + |[ash Fund Balance Trrsfered In Ra Vatren Tx appre fs of | ssn even ee i s i Fund Baer eva Fon Peedg Yar at fs PrarBueninwe Reged! J fs ee Co cs Ce Se Reseve fr Warans Ousanding SoS Pesneorierestn Ware — isenesfon Sette ro fs TOTAL UABILTES AND RESERVE fs tf DERCTE g Varans Outage Not Yex SG ’ otal OCidCS 210,16. |S HTH 274.814.90] ER Name cede fp ss ee eS es eT = RPRC ARRAS OU STAND TORE ea) i‘ Fete of tC a ees : a ers . ea a poe Cea ST ” - a ee Te cagnen, CapalOuay —[s__seaTso7]'$_ sacs Saaz} | ‘S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘October 19, 2023 --- OCR page 28 of 77 --- Page 26 HEALTH COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 . EXHIBIT E JUNE, 302023 . DEPARTMENTS OF GOVERNMENT — Warrants Balance = |APPROPRIATED ACCOUNTS ean Since Lapsed Issued ‘Appropriations Appropriations [ 1ioFuittimesalares ——SSSSSCSCSCSdzS CGS Maa TTS 20,15426] [notre CdS essa [Sasso S.174.73 | a KS | : a Ce CC | ‘ | ' ' ' ' ' S.A. and I, Form 2631RO1 Entity: Ottawa County, $8 October 19, 2023 . --- OCR page 29 of 77 --- a HEALTH COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 27 ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT E Schedule 8: Report Of Prior Year's Expenditures " FISCAL YEAR ENDING JUNE 30, 2023 FISCAL YEAR 2023-2024 Lapsed Needs as Supplemental Net ii Warrants 5 Balance Estimated by Approved by Adjustments Appropriations Issued eserves Known to be Governing 5 al 4 a Unencumbered Board Reise Boars Dept: 7001, Road Improvement District Is S- *d‘S 155,000.00 [$ 84,601.53 |S 30,000.00 | $ 40,398.47 ||$ 200,000.00 $ 200,000.00 1 is CSC'S 20,000.00 | $ 8,903.43 [$ 1,100.00] $ 9,996.57 | $ 15,000.00 | $ 15,000.00 $ 14,862.91 | $ 139,862.91 |S 104,842.05 | $ 10,530.50 | $ 24,490.36 || $ 123,000.00 | $ 123,000.00 fs —C-«SCdCS'S 339,474.97 [$11,793.46 [S «LS 327,681.51 |S _299,475.00[$ 414,202.61 Ss 14,862.91 | $ 654,337.88 | S 210,140.47 | $ 41,630.50 | $ 402,566.91 |! $ 637,475.00 | S 752,202.61 a [HEALTH FUND ACCOUNT $ 14,862.91 | S G43I7HB]S __UOMOATTS 41,630.50 S __402,566.91]|S 63747500 |S 752,202.61 ‘SUBJECT TO WARRANT ISSUE a ES ES FS FS 7 TOTAL UNRESTRICTED EXPENSES FOR THE HEALTH FUND. Ss 14,862.91 | $ 654,337.88 | S 210,140.47 | $ 41,630.50 | $ 402,566.91 || S 637,475.00 | $ 752,202.61 2 ESTIMATE OF NEEDS FOR THE 2023-2024 FISCAL YEAR, Estimate of Approved by Needs by County |PURPOSE: Govenring Board Excise Board “Total of Unrestricted Expenses for the Health, Schedule 8 S___632,860.35|[$ 747,587.96 7 Total of Restricted Sales Tax Expenses for the Health, Schedule 8A is - ‘fs Pro rata share of County Assessor's Budget as determined by County Excise Board $ 4614.65 |[$ 4614.65 GRAND TOTAL - Health Fund $_ 637,475.00 ][$_752,202.61 n a a = al . al ' P 3 r S.A. and I. Form 2631RO01 Entity: Ottawa County, 58 October 19, 202: --- OCR page 30 of 77 --- = TOTAL OF SPECIAL REVENUE FUNDS COVERING THE PERIOD JULY 1, 2022 TO JUNE 30, 2023 Page 28 ESTIMATE OF NEEDS FOR 2023-2024 . EXHIBIT “I" TOTALS se . Pe aE ee CNN TAL ASSETS c [saa Emanuel ; $ are TAL LIABILITIES, RESERVES AND CASH FUND BALANCE Ss | [Ss 31959358 | sd [Ad Valorem Tax Apportioned To YearInCaption SS ' [Sources ofRevenue js [9100|Local Revenues [ss [9200|State Revenues S077. ' [js [is |9500|Special Assessments [ss ' [2600[Other Revenues SS [9700|School Revenues CdS dd JAM! Other Non-Tax Revenues Sd [Sales Tax and Sales TaxInterest_ SC SC CS ' [ss [Prior Expenditures Recovered CSC CdS CCS” [FOTAL RECEIPTS CdS 7T IS ' [erest Paid Thereon YS : [so [Reserve for Interest on Warrants TS Ss . [ss a | . [Schedule 9: Special Revenue Funds Summary ofExpenses——— ‘Net Appropriations ‘Warrants ‘Approved by ; [sss . [ss [is = S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 31 of 77 --- 2 5 COUNTY BRIDGE AND ROAD IMPROVEMENT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 29 11103 ESTIMATE OF NEEDS FOR 2023-2024 7 5 +a COUNTY BRIDGE AND ROAD IMPROVEMENT , ee - —__ [Cash Balances 0] DOTA Sos arr] : CIABTCTTTES AND RESERV [SS 2155 [Warrants Outstanding SY [Reserve for Interest on Warrants » __|Resewes From Schedule 3 S| [CASH FUND BALANCE JUNE 30, 2025 TSS. 98 | [CURRENT AND ALL PRIOR VEARS 0 SPE 2003 ° as a : [ss [Sources of Revenue ee » 9V0oftocal Revenues [o200|State Revenues CS stra [9300 [Federal Revenves—— SS a . [ss fse00lotherRevenues [9700|Schoot Revenues ° [All Other Non-Tax Revenues [ss a Prior Expenditures Recovered Ss " [sf Iineres Paid Thereon SS 7 TOTAL DISBURSEMENTS] [S 544,787.89 | [$262,998.00 | ICASH BALANCE JUNE 30, 7005S SORTS [Reserve for Warrants Oulsandmg S| [ss " Reserve fornereston Warans Resenes From Schedule OTALLIABILITES ANDRESERVE—— SS perc Si " [S___ S01 Ta 96S ‘ati roved b} ° a EC [1200 Fringe Benefis]s__- [sss " [s00Traver Related Ss [S__LOsSTS OTS seater. go [SS 81. 593.92| Fro0Toial Machinery & Equipment, Copia Oumay[S——— SS r [SSS RTS Sa Te SYS F81593.92 S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 ‘October 19, 2023 --- OCR page 32 of 77 --- . Page 30 ASSESSOR REVOLVING FEE COVERING THE PERIOD 72002 TO 6/30/2023 . ESTIMATE OF NEEDS FOR 2023-. [ASSESSOR REVOLVING FEE 11206 nn oe - ee Oe Warrants Outstanding Outstanding : | | [Reserve for Interest on Warranis_—SSSCSCSCSCSCSCSCSSSSSCCCCCCCSCSCSCSCSSSTC for Interest on Warrants is -_| [Reserves FromSchedule3 From Schedule 3 eS . ‘ [CURRENT AND ALL PRIOR YEARS 2020-25 PRES202 _ [SS 15,230.08 | ' |_Cash Fund Balance Transferred ut SS [Cash Fund Balance Transfene@in SS [ss a | ' Sources ofRevense SS OSOSOOCCCSYY Cd |9000]interest, Mortgage Tax Ss [9100}Local Revenues 0732.00] ; [ss [ss a LS Le ' [2600[Other Revenues 0 [Ss JAM Other Non-Tax Revenues CSS [Sales Tax and'Sales Tax Interest SYS CSCS ' [Cash Fund Balance Forward From Preceding Year SSCS Sd [Prior Expenditures Recovered TS Sid [TOTAL RECEIPTS dS 0S [ROTAL RECEIPTS AND BALANCE Se Sd ‘ [se listerest Paid Thereon SS [FOTAL DISBURSEMENTS 0 . [| [sos [ss [Reserves From Schedule § => [ss S . [POTAL LIABILITES AND RESERVE SS [PERT SSS [is . ‘Net Appropriations Warrants ‘Approved by : [P1O0"Total Salaries a CS Ce [so sss [s___ 6400's . [S$ JAI Other Expenses OS Ss OS [SS c ‘S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023, --- OCR page 33 of 77 --- , 5 SHERIFF BOND FEE COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 31 11206 ESTIMATE OF NEEDS FOR 2023-2024 Schedule 1 Coney Ba US RE BOND FEE a ASS 2S (Cash Balances sos X— [vestments [TOTAL ASSETS [Warrans Outstanding Reserve for Interest on Warranig Reserves From Sehegule 3s TOTAL LIABILITIES AND RESERVES dS [CASH FOND BALANCE JUNE 30,2023 S| Oe eo ; (Cash Balance Reported to Excise Board June 30,0022 YS dS " [opening Balance fiom Prior Year | cash Fund Balance Transfered Os} [Cash Fund Batance Transferred in ——_______________ sn s——| 7 [Adjusted Cash Balance 89.0 [Ad Vatorem Tax Apporioned To Vear Tn Caption SSS SS Sources ofRevene J [9000Tinterest, Mongage Tax s- |s | > pT00|Local Revenues iS SY [9200]State Revenues [9300] Federal Revenues 4s ,__[Pabolhscetaneous Revenues "——[Bs00)Special Assessments [9600] Other Revenues [9700] School Revenues > |AMOther Non-Tax Revenwes_——— SS ales Tax and Safes Taxtwerest SS [Cash Fand Balance Forward From Preceding Ver SYS Prior Expenditures Recovered _________]s__-_|s ° frorac Receipts TOTAL RECEIPTS AND BALANCE _____]s__#s0 [s-— [Waranis of Year in Caption] 8___ 9.00 ][s — Wimeres Paid Thereon ts TOTAL DISBURSEMENTS ——________________]8__s00 3 ICASH BALANCE JUNE 30,0003 SSOSCSCOCOCCOCCCC*dCS)— Ss Sd [Reserve for Warrants Outstanding SS nm RReserve for Interest on Warrants S'S Reserves From Schedule 8 ___s_- ]s = | TOTAL LIABILITES ANDRESERVE SSCS CS S| perc SS ” [CASH BALANCE FORWARD TONEXT YEARS Sd ‘Net Appropriations Warrants ‘Approved by = Promotors areas) see Reems | ca fooTowlSaares CS CS SS [7200 Fringe Benefits sss fs = |fs00 Travel Related SSS [2000 Tota Matnenance & Operations [Seo s——ean 00s SE —— — — [AllOther Expenses. SSCS CCC CS OSS S.A. and I. Form 2631RO01 Entity: Ottawa County, $8 ‘October 19, 2023 --- OCR page 34 of 77 --- Page 32 COUNTY CLERK LIEN FEE COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 - COUNTY CLERK LIEN FEE $208 investments OTAL ASSETS 88S [ss Reserve for Interest on Warrants | sd : . ; [Cash Fund Balance Transferred Out ig Ce [ss a ° [Sourees of Revenue | [9000] interest, Mortgage Tax ss [2100|Local Revenues 0S areas ' [ss [ss |9500|Special Assessments Eee eS ' ce es [ss a [Sales Tax and Sales Tax Interest Ss ‘ [Cash Fund Balance Forward From Preceding Year SS [Prior Expenditures Recovered 0s [ss . [s_ 36,211.28 ss [ss [ss [ss . [S| [ss a a . [ss [ERIC Ss [ss . [Schedule 9: County Clerk Lien Fee Fund Summary of expenses let Appropriations Warrants ‘Approved by : [ss ss [s—-_| [S___3.986.95 [8s . £100 Total Machinary & Equipment Capital Outlay[ $= SS [ator Enpemes On a Ee ES EE EAPC) . S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 35 of 77 --- A ; COUNTY CLERK RECORDS MANAGEMENT AND PRESERVATION COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 33 ESTIMATE OF NEEDS FOR 2023-2024 11209 COUNTY CLERK RECORDS MANAGEMENT AND PRESERVATION 2 SS | [Ievestments TS [TOTAL ASSETS TS TS] sy [Reserve for Intereston Warrants Sd 1 [ss [sd 7 [CURRENT AND ALC PRIOR YEARS SSS. SCSdC'[ 2020-03 «YT -~PRE-2022——‘|| . js a a Ce SoucesofRevenue [ss " [9100[Local Revenues [js [9200[State Revenues Sg [9300|FederalRevemes ST [9400] Miscellaneous Revenues SS ° ee [9600|Other Revenues [700|School Revenues ST » [A Other Non-Tax Revenues Cs [s— [Prior Expenditures Recovered S'S z js es ° [Reserve for Warrants Outstandmg SS " [ss Reserves From Schedule8_—— S'S FfOTALLIABILITES ANDRESERVE Ss perc: SS " [CASH BALANCE FORWARD TONEXTYEAR ST SDSS 234.05] N Warrants ‘Approved 6: SS | SO = “300 Traver Related SS [ss 1S100 Total Machinary & Equipment, Capfal Outlay] $—_—- —<SS YS iS ss a [S____ 72,934.65 [Sd ‘SA. and I, Form 2631RO1 Entity: Ottawa County, $8 ‘October 19, 2023 al --- OCR page 36 of 77 --- : Page 34 EMERGENCY MANAGEMENT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 . ar EMERGENCY MANAGEMENT FfOTALASSETS—— nd [Warrants Outstanding [Reserve for Interest on Warrants [st (TOTAL LIABILITIES AND RESERVES Sd ' [TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE TS 30.808.17] ' [CURRENT AND ALL PRIOR YEARS 2000-73 PRE DON | Cash Fund Balance Transferred QS CY a | [ss [se ' es ee [ss |9100}Local Revenues Ss [9200[State Revenues [ss es [9500]Special Assessments 0S [9600]Other Revenues Ss [ss a [s_S ' cs |e [ss [ss [$30,898.11 [S$ [s_ 0.00 [$= es | [s_ 30.00 [Ss ' [S308 S | [sg es [ss . a PERC SS [st . [Schedule 9: Emergency Management Fund Summary of Expenses ‘Net Appropriations Warrants ‘Approved by LE LC LC LC es [ss [ss ss [is -_| . [ss SS JAlLOther Expenses SS SS hs EC) ka . S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023, --- OCR page 37 of 77 --- m 1 LOCAL EMERGENCY PLANNING COMMITTEE COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 35 ESTIMATE OF NEEDS FOR 2023-2024 Elie LOCAL EMERGENCY PLANNING COMMITTEE a SS | [investments [TOTAL ASSETS » [LIABILITTES AND RESERVES: CCSYY ae [ss , — [CASH FUND BALANCE TUNE 30, 2025 5 800,00 [TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCES 8,82000] 7 * a [so Sd : a Ss fs Sources ofRevense [ss ST > [9100[Local Revenues SS [9200|State Revenues SS [9300|Federal Revenues C'S doo] seellaneous Reverses * [9500|Special Assessments SS [9e00|Other Revenues SSCSCSC—SSSSSOCCSCCSSTTTTCdS 00| Schoo! Revenues ] rs cs Cash Fund Blanes Forward Pom Peay Yer Prior Expenditures Recovered SS ° OTALRECEPTS TS TOTAL RECEIPTS ANDBALANCE CdS S200 [Warrants of Vear in Caption SS 5 [interest Paid Thereon SST TOTAL DISBURSEMENTS [sed [Reserve for Warrants Outstanding SS a [Reserve forinterest on Warrants SSCS dS is iS TOTAL LIABILITES ANDRESERVE S'S 2p xin ACS AOC " cr ‘Net Appropriations: Warrants | Resenes | aoe " ny Exe Ln ES fs dS " sss oss rr \iiooToal Machinany& Equipmen, Copia Only] SSS Sis - is is 7 a S.A. and I. Form 2631RO1 Entity: Otawa County, 58 ‘October 19, 2023 = --- OCR page 38 of 77 --- : Page 36 RESALE PROPERTY COVERING THE PERIOD oe TO 6/30/2023 . ESTIMATE OF NEEDS FOR 2023. RESALE PROPERTY 11220 ee ; ee 7 Po a [SS 957,397.76 [sd [Cash Fund Balance Transferred ins. ]$____—_| Cc re es is _|s | [9100|Local Revenues js ]9200[State Revenues IS Sd [ss is_ | [9500]Special Assessments SOS |9600[Other Revenues CS CC*dCS SCs Es a a , [fs] [SS js [interest Paid Thereon TT CC™C—SS ICASHBALANCE JUNE 30,2025 CSSC*dS_—=88, 69'S 0.00 | S| [Reserve for Intereston Warrants CdS CC CdS CS~* [Reserves From Schedule YS ‘ js [DER CT SS r Net Appropriations Warrants ‘Approved by |_tenes | cme | [SSS [SS 25,102.65 | [S______-_[s_ 403,373.35} ‘ Cs JAW Other Expenses SS OS SF S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 39 of 77 --- a a REWARD FUND COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 37 ESTIMATE OF NEEDS FOR 2023-2024 161221 __ REWARD FUND n SSS | [investments St [TOTAL ASSETS SST |Warrants Outstanding” [Reserve for Interest on Warrants ST 4 [Reserves From Schedule EO [TOTAL LIABILITIES AND RESERVES dS a ° [Cash Fund Balance Transferred Que SS [Cash Fund Balance Transfemed nS Sd a [Adjusted Cash Balance aa 20 ST [ad Valorem Tax Apportaned To VearInCapion dS OS [Sources ofRevenve J [9100|LocalRevenues STS [9200|StateRevenues SST [9300|Federal Revenues ST [9400[MiscellaneousRevenues ST ° [9500|Special Assessments SS [9600|Other Revenues SS [9700|School Revenues SS a [All OtherNon-Tax Revenues ST [Sales Tax and Sales TaxInterest SS [Cash Fund Balance Forward From Preceding Ver SS [Prior Expenditures Recovered dS 7 fforaLRecerts S28 TOTAL RECEIPTS AND BALANCES asa |Warrants of Yearin Caption SS a linterest Paid Theron dS TOTAL DISBURSEMENTS ST [CASH BALANCE JUNE 30,005 SS ATS [Reserve for Warrants Outstanding S'S = [Reserve forlntereston Warants SS [Reserves From Schedule SS TOTAL LIABILITES ANDRESERVE CS i 2 SST (SEN i ICASH-BALANCE FORWARD TONEXTVEAR SATS ATS) Wet Appropriations Warrants ‘Approved b ° [0 ToaSaares CS SS [i200 Fringe Benefits _———~<iis ‘iis sds a [1300 Travel Related IS dS SS [2000 Total Maintenance & Operations ‘8 ____Warsa7fS SS 475.47] 12100 Total Machinary & Equipment, Capnal OwlayS SS SS lallOther Expenses SS IS SS * TOTAL EXPENDITURES 2000-05 FISCAL YEARS tarsa7IS_ SS 1ST ‘SA. and. Form 2631RO1 Entity: Ottawa County. 58 ‘October 19, 2023, = --- OCR page 40 of 77 --- a Page 38 SHERIFF COMMISSARY COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 e 1-1223 SHERIFF COMMISSARY ASSETS. - [so [s___tost2 38] . - [CURRENT'AND ALL PRIOR YEARS PRETO es [ss rs [Ss c [Sources of Revenue |9000]Interest, Mortgage Tax CSC CdS C~=* [9100[Local Revenues CSC™C~C~iYCSS CC*SAIYTS CS - |9200fState Revenues C—O TC ~*Y [9300 [Federal Revenues CCSC~iCSC NSN COS. SC~CC*d Ce Ee [9500[Special Assessments TTS dS ” [9600[Other Revenues STC CdS CS [so [so cs b. [S___ 196738 S| es [s__i21,9iss6 fs =| - listerest Paid Thereon CdS OS CS«CSd = [ss a [ss “ [ss ea SS | on fet Appropriations W. ‘Approved by a ee [So 7 a k | [1300 Travel Related SS fs [£100 Total Machinary & Equipment, Capital Outlay $= SSS SY 7 JA Other Expenses SS SS eo S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 _ ‘October 19, 2023 . --- OCR page 41 of 77 --- m= - SHERIFF FORFEITURE COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 39 bizs ESTIMATE OF NEEDS FOR 2023-2024 [Schedule T: Current Balance Sheet - June 30, 2023 eS E m SS Fevestments [Warrants Outstanding Sd [Reserve for Intereston Warrants dS = _Reseres From Schedule 3s [TOTAL LIABILITIES AND RESERVES SCC dS] oa} ee , __ fesr Balance Reported to Excise Board Tune 30,2022 STS OO —————— a m [so rs es ad [9100|LocalRevenves SS [pz00|StateRevenues CS [9300|Federal Revenues [9400|Miscellaneous Revenues SS * [9500|Special Assessments SS [S600]Other Revenues dS a = a [Sales Tax and Sales Taximerest SS a [Prior Expenditures Recovered S'S a ee [ss [Warrants of Vear in Caption SS 7996'S 5 rs ee [so ICASH BALANCE JUNE 30,2005 SOSOSCSSCSCOCSCSCSCSSSCSdC S05 S [Reserve for Warrants Oustandmg SS a [SS [Reserves FromSchedule8 SS [TOTAL LIABILITES ANDRESERVE IS a | " [CASH BALANCE FORWARD TONEXTYEAR S205. = Net Appropriations Warrants ‘Approved by - oc -|s - js js fs - is dss m a | | [ss [4100 Total Machinary & Equipment, CapnalOutlayfS [SS SS a | ES | m HOTAL EXPENDITURES 2007-25 FISCAL YEAR[S 2300'S omssoS TS 2,053.64] S.A. and I. Form 2631RO1 Entity: Otawa County, 58 ‘October 19, 2023 ‘ie --- OCR page 42 of 77 --- Page 40 SHERIFF SERVICE FEE COVERING THE PERIOD mena ‘TO 6/30/2023 . ESTIMATE OF NEEDS FOR 2023: SHERIFF SERVICE FEE 1:1226 oe . Ps nessa [rvesmens << FOTAL ASSETS . ps as] 208 : [is | es a a [S000]imerest, Mongage Tax [2100}Local Revenues STS [9200]State Revenues [9300]Federal Revenues [s—_ 591050 [$7] [9500]Spesial Assessments CdS «SOS [9600]Other Revenues YS ts [2700|School Revenues YS SJ a Ce : [fs [ss [s____] . es . [sd is fs | [s—_-_] . [is _] a ES . jet Appropriations Warrants ‘Approved by . [200 Fringe Benefits dS [ss [1300 Travel Related SS . [5100 Total Machinary & Equipment, Capial Owayf SSS Sd [All Other Expenses Ss : S.A. and I, Form 2631RO1 Entity; Ottawa County, 58 October 19, 2023 --- OCR page 43 of 77 --- ; : ‘TREASURER MORTGAGE CERTIFICATION COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 4] ESTIMATE OF NEEDS FOR 2023-2024 1.1230 EEE TREASURER MORTGAGE CERTIFICATION 22 [vestments TS (TOTAL ASSETS CCOCSCCSSSCS J [s___—] 3s , [fs - [TOTAL CIABILITTES, RESERVES AND CASH FUND BALANCE JS 32000] ’ — [So 3,737.13] ; ae [Cash Fund Balance Trastened Ins }s_— [Ad Valorem Tax Apporioned To Veer Capon YS SS rr | s———J + [pi00fLocarRevenues Sg [9200|Suate Revenues es ss * —[ps00|Speciar Assessments SS [ss S—___ is , __|AlWOter Non-Tax Revenues es es Prior Expendiures Recovered SS > Horacrecets Sans es [ss [s Ss 9 [Reserve forlnterest on Warrants S'S [ss [s__- [Js perc YS 1 _| CASH BALANCE FORWARD TONEXT YEARS 0890S "Net Appropriations farrants “Approved b (W00ToalSeares SSS a a SC A [Sa ss 8] s—— \i00 Total Machinary & Equipment, CaptarOutays SSS — a Sana ses 38990] S.A. and I. Form 2631RO1 Entity: Ottawa County. 58 ‘October 19, 2023 5 | --- OCR page 44 of 77 --- Page 42 COUNTY DONATIONS COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 . 141235 i COUNTY DONATIONS, ——————— ae OTALASSETS ed [sd [ss FReserves FromSchedule3 Sn sd c ' [SS 577 50 a [SS [Ad Valorem Tax Apportioned To VearIncapon SS OS ' es | cs ploollael Revewes Revenues [sores [State Revenues ss [9300|Federal Revenues IS s—__ [9500|Special Assessments 7S ' ae De [9700|School Revenues CS dS JA Other Non-Tax Revenues ST SC [Sales Tax and Sales Taxinterest CdS Sid ‘ sS—__— [Prior Expenditures Recovered Ss [ss ‘ (rr c Reserve for Warrants Outstanding" ree Reserve for Interest on Warrants CC—C~d Sd [Reserves From Schedule 8S Sd : [POTAL LIABILITES AND RESERVE Ss a . ee I __||_July 1, 2023 Issued County Excise . [so Ss a a SE [se a . Se CE | [s [S895.49 Se . S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 ~ ‘October 19, 2023 --- OCR page 45 of 77 --- = - = OPIOID ABATE COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 43 ESTIMATE OF NEEDS FOR 2023-2024 11251 - OPIOID ABATE 7 SSA [investments a 5 HOTAL ASSETS 5 Sr ay [S__ 14,103.76 | 14,103.76 |Warrants Outstanding Sd [Reserve for Intereston Warrants CdS Cd 5 [Reserves From Schedule 3 VS [TOTAL LIABILITIES AND RESERVES dS A [CURRENT AND ALL PRIOR YEARS 2022-25 PRE2022 [Cash Balance Reported to Excise Board June 30,2027 7S " [Opening Balance from Prior Year ST [_Cash Fund Balance Transfered Out SS [Cash Fund Balance Transfenedin SS 9 [Adjusted CashBalance JAd Valorem Tax Apportioned To Vear In Caption SS [Sources ofRevenue [9000]Interest, MortgageTax SS _ [9100|Local Revenues ST [9200|State Revenues SS [9300|Federal Revenues Ss a [400[Miscelianeous Revenues TORTO ST [9500|Special Assessments SS [9600[Other Revenues [9700|School Revenues ST " [All Other Non-TaxRevenues—— SST [Sates Tax and Sales TaxInerest SS [Cash Fund Balance Forward From Preceding Year SS [Prior Expenditures Recovered S's ° FfoTALReceIPTS CdS Ta top 76s . [TOTAL RECEIPTS AND BALANCE. CdS Th 10S TELS [Warrants of Year in Caption Ss a linterest Paid Thereon SS [TOTAL DISBURSEMENTS TS [CASH BALANCE JUNE 30,2008 STO TOS [Reserve for Warrants Ouistanding SST " [Reserve for Intereston Warrants S'S [Reserves From Schedule8_ SSCS ST TOTAL LIABILITESAND RESERVES perc dS " ICASH BALANCE FORWARD TONEXTVEAR STOO YS) Net Appropriations Warrants Approved by a De ee (MoOTowiSaares SS SS [i200 Fringe Benefits SCS CdS " [1300Travel Related SOS Ss [2000 Total Maintenance & Operations [3 1hvos7eys SSS 18,105.76 | [2100 Total Machinary & Equipment, CapralOwlayfS IS SS lAllOtherExpenses SS OSS a FOTAL EXPENDITURES 1029-25 FISCAL VEAR[S __1ats7oS SSO 78] S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘October 19, 2023 m= --- OCR page 46 of 77 --- - Page 44 CONVENIENCE CENTER COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 = rani CONVENIENCE CENTER. RSET . ——_—_—_———— fs - | [fs 7 — « * - is [sd [Cash Fund Balance Transferred In $8 JAG Valorem Tax Apportoned To Year mCaption CdS dS CY ’ Sourees ofRevenue [poo0[imerest, Mongage Tax J [9100)Local Revenues $s [p200]state Revenues $s . [9300]Federal Revenues [9400|Miscellaneous Revenues YS] [9500]Spectal Assessments SS ts : [pe00[Other Revenues Sts [9700]Schoot Revenves Ss [All Other Non-Tax Revenues [Sales Tax and Sales Tax terest pS - [Cash Fund Balance Forward From Preceding Vea 2,000,008 J [Prior Expenditures Recovered SS [s——] . [Warrants of VearinCaption YS TT lerest Paid Thereon ts [TOTAL DISBURSEMENTS ° [Reserve for Warrants Outstanding Reserve for Interest on Warrants 3 [Reserves From Schedule 8S a [TOTAL LIABILITES ANDRESERVE S$ [perICrT SS - Net Appropriations “Approved by ee bare a - LC [sf fs sss [2000-Total Maintenance & Operations [$_ 54627 $s sae] - a [AU Other Expenses SS os oh s___ ers s S.A. and 1. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 7 --- OCR page 47 of 77 --- BUREAU OF INDIAN AFFAIRS STATELINE ROAD COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 45 P ESTIMATE OF NEEDS FOR 2023-2024 : 11456 _ BUREAU OF INDIAN AFFAIRS STATELINE ROAD r : [investments OS [TOTAL ASSETS SS | [ss [ss | r sd ; [Cask Balance Reporied to Excise Board Tune 50, 2022 7 S559] r [ Cash Fund Balance Transferred Que ss |_Cash Fund Balance Transferred [nS Sd js r [Ad Valorem Tax Apportoned To Year In Caption Ts eS ee re [2100|L.ocal Revenues ss [9200|State Revenues ss [ss a P a [p600]Other Revenues [9700|Schoot Revenues ss F a r a [Cash Fund Balance Forward From Preceding Vear S's [ss r es es [TOTAL RECEIPTS AND BALANCES Sasso fs lWarrants of VearinCaption - rs r [ss CASH BALANCE JUNE 30,2025 SES SS a es [ Reserves FromSchedule8 ST [TOTAL LIABILITES ANDRESERVE ERC P [ss t F ‘Net Appropriations Warrants ‘Approved by a [sss ES r Ss SS [4100 Total Machinary & Equipment, Capital Outlay $= fs Ss sss r [TOTAL EXPENDITURES 2027-25 FISCAL VEAR[S —1.545.59 [SSS 1585.59] S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘October 19, 2023 --- OCR page 48 of 77 --- - Page 46 TRIBAL ARPA FUNDS COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 - 141507 TRIBAL ARPA FUNDS ASSETS - linvesiments WOTAL ASSETS ST] LIABILITIES AND RESERVES: C [st TOTAL LIABILITIES AND RESERVES Td . . e es |[_Cash Fund Balance Transferedin dS dS JAd Valorem Tax Apportioned To Year inCaption 7S OSC f [Sources of Revenue TT [9000]interest, Mortgage Tax ST CSCS yee tee Revenues | aro . [State Revenues SS [9300]Federal Revenues CS SY [2400] Miscellaneous Revenues SS |9500|Special Assessments SS . |9600|Other Revenues SC SY [9700]School Revenues SS [All Other Non-Tax Revenues SS [Sales Tax and Sales Tax Interest SOS ° [ss [Prior Expenditures Recovered CdS SCC*@Y js « [s_ linterest Paid Thereon_ SS [POTAL DISBURSEMENTS dS TTS G [S$ 21,800.00[/$ [ss |$__1,197,986.00 [$= . [S__1,219,786.00 [$= a | | «= Net Appropriations farrants ~ ‘Approved by | _ises | tenes | cote | a eS EC (ES —— a FE (KS [SoS ss = [so Ss eS CS ES (EE | [S_ 410,329.30] = $.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 49 of 77 --- a 9 AMERICAN RESCUE PLAN ACT 2021 COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 47 ESTIMATE OF NEEDS FOR 2023-2024 11566 AMERICAN RESCUE PLAN ACT 2021 5 SSS [investments BS [OTAL ASSETS * USNS SNL js ® — i. iE | 2 a [Sources of Revenue [[9000]interest, Mortgage Tax 022.09 Ts ° [s100]Local Revenues [9200|State Revenues js 5 [9400[Miscellaneous Revenues SS |9500|Special Assessments SS [ptblope Rete js Se [9700|School Revenues SS 2 [AM Other Non-Tax Revenues SS [Sales TaxandSalesTaxtmerest Sg js [ss 7 [s a es es [S_ 102,959.02[$ 7 [Reserve for interest on Warrants ST js [s_ | [DEFICITS ES fs ° jet Appropriations y Approved by ° [ser | tee caace | [ss Ss * GS DE Le Lo [Ss ss a EE | | ” [S_3,120,258.31 ] [S___1,522,383.34 | ‘SA. and I. Form 2631ROI Entity: Ottawa County, 58 ‘October 19, 2023 my --- OCR page 50 of 77 --- Page 48 LOCAL ASSISTANCE & TRIBAL CONSISTENCY COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 © 1-1570 LOCAL ASSISTANCE & TRIBAL CONSISTENCY pSSETS : ——_—_—_—_—_—————— [LIABILITIES ANDRESERVES. « ss [ss Reserves From Schedule 333] ss . . CURRENT AND ALL PRIOR YEARS 2007-75 PRE-2027 [Cash Balance Reported to Excise Board June 30,2022 | Opening Balance from Prior Years . [ss [sd [i Bources of Revenue es Se [9100 [Local Revenues [sts . [ss ee [ss ° | [ss so Sales Tax and Safes Tax Inerest—— SS . [Cash Fund Balance Forward From Precedng Ver [Prior Expenditures Recovered [ROTAL RECEIPTS 0 ss c [POTAL RECEIPTS AND BALANCE CS 50.000.00 [S| [Warrants of Vearin Caption SS [ss a . [sd [ss [ss [ss . as [ERC Ss [sd © ‘Net Appropriations Narrants Approved 6 - [ss eee] js es EC CC EE es . [SS SC Se | [$e S- © S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘October 19, 2023 --- OCR page 51 of 77 --- 5 " TOTAL OF SALES TAX REVENE Fun source, THE PERIOD JULY 1, 2022 TO JUNE 30, 2023 Page 49 EXHIETerSerorare IATE OF NEEDS FOR 2023-2024 n (ASSETS: [TOTAL ASSETS Sr] > [Warrants Outstanding SYS 1 90 x _ Reserves From Schedule $0 186686 | (TOTAL LIABILITIES, RESERVES AND CASHFUND BALANCE «dz S 4,013, 359,.80 | . SERVES AND CASH FUND By , __ [Cash Balance Reported to Excise BoardJune 30,2000 SYS 3,602, 768.08 | | Cash Fund Balance TransferedOu CdS | Cash Fund Balance Transferedin SS > [Ad Valorem Tax Apportioned To VearInCaption dS S| Sources ofRevenue [S000]interest, Mortgage Tax scr SY * fpT00|Local Revenues SST [9200|State Revenues SZ S| . | 400]Miscellaneous Revenues IS ICTS [9500]Special Assessments SST [s600]Other Revenues IS CS [9700|Schoo! Revenues IS > [AlTOther Non-Tax Revenues SS [Sales Tax and Sales Tax Interest St, [Cash Fund Balance Forward From Preceding Year S91. 869.03 [8 [Prior Expenditures Recovered S's " frotacReceTs—SOSOSOSOSSCSCSCOCCOCOCCCCSC*dS es gTBST PS interest Paid Thereon dS [Reserve for Warrants Outsandmg dS 175.902 = [Reserve for Interest on Warrants ST [Reserves From Schedule iS 1,6 [TOTALLIABILITESANDRESERVE. CSCS LIABILITES AND RESERVE [S 279,565.51 || 279,565.51 — A ES (CS " 7 ‘Net Appropriations Warrants Approved by a (Wo0ToaSaares SS ST [i200 Fringe Benefits IS SS m —|S00Traver Related SS SS Wail Machinary & Equipment, Capital Owlay SS SS 7 lAllother Expenses dS Ss ‘S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ~ ‘October 19, 2023 --- OCR page 52 of 77 --- Page 50 COURTHOUSE IMPROVEMENT SALES TAX Coven ‘id 71112022 TO 6/30/2023 . Tie COURTHOUSE IMPROVEMENT SALES TAX. LST-1305 ee ee ee ese Se 2 Sea ———— [LIABILITIES AND RESERVES. . Waren Ousnding . . [CURRENTAND ALL PRIORVEARS 2000-23 PRE2022_ [Cash Balance Reported to Excise Board Tune 30,2022 TS = ST 337, 556.19 ’ | Cash Fund Balance Transferred Out SS [| |Ad Valorem Tax Apportioned To Year In Caption SS ‘ [Sources of Revenue [sos |9100[Local Revenues ST ; [9200[State Revenues ss [9300|Federal Revenues SSS [9400 [Miscellaneous Revenues TS a : i [s_S [ss S| c [so [Sos [ss : [interest Paid Thereon Ss . [Reserve for Warrants Quistanding 0S SC Cd [Reserve for interest on Warrants SC CS Cd [ss | . [sn a Ek | . ‘Net Appropriations Warrants ‘Approved by a | CE | [1200 Fringe Benefits S| [ss [1300 Travel Related TS Ss . Ss | Ek | a [3 1,992,534.52 | [S_1320513.17 | 7 §.A. and I. Form 2631ROI Entity: Ottawa County, 58 October 19, 2023 --- OCR page 53 of 77 --- = = ROAD AND BRIDGES SALES TAX COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 51 ist. ESTIMATE OF NEEDS FOR 2023-2024 = ROAD AND BRIDGES SALES TAX (| fiovestments [ss » [s_17796.10] 4 __—— | Cash Fund Balance Transferred Out SS [_ Cash Fund Balance TransferedIn SS | n a [Sources ofRevenue [s_ * [9100]LocalRevenes SS [9200[StateRevenues TS [ss 5 [9400[MiscellaneousRevenues S85 TTBS [9500|Special Assessments [9600]Other Revenues [Ss [SS n a [Sales Tax and Sales Tax Interest STOTT SSAA [ss es " OTALRECEIPTS SaaS n [ss [ sd [Reserve for Interest on Warrants SS [js [sd perc CCS fs ” [S$ 1,900,499.57 | = "Net Appropriations Warrants “Approved by cs ss is - iis ss " [300 Travel Related IS OS'S i OS Ss = | [SS S.A. and I. Form 2631RO1 Entity: Onawa County, 58 October 19, 2023, 7 --- OCR page 54 of 77 --- Page 52 RURAL FIRE SALES TAX COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 = RURAL FIRE SALES TAX. LST-1321 eee [Reserve for Imereston Warrants C , , [ss [ss |Ad Valorem Tax Apportioned To Year In Caption SS ' [Sources ofRevenue | r= Fa [9100|Local Revenues Sg ee : [9300] Federal Revenues ce | [Ss ' |600]Other Revenues |9700|School Revenues ss JAMl Other Non-Tax Revenues 0S [Sales Tax and Sales Tax Imereti S SS TOSTS ‘ [Ss [ss [ss , linterest Paid Thereon Ss . [so JReserve for Interest on Warrants Sg JReserves From Schedule $745.00 [3 . [TOTAL LIABILITES AND RESERVE S09. 95S [DEFT SS c ‘Net Appropriations Warrants “Approved by : [so Se a Cs [Ss . [SSS a EC EC | . S.A. and I. Form 2631R01 Entity: Ottawa County, $8 October 19, 2023 --- OCR page 55 of 77 --- 5 TOTAL OF EXPENDABLE TRUST FUNDS COVERING THE PERIOD JULY 1, 2022 TO JUNE 30, 2023 Page 53 ESTIMATE OF NEEDS FOR 2023-2024 EXHIBIT "M" TOTALS n |ASSEISS fovestments Z [TOTAL ASSETS CSS OT FTES S| ; s—— aa] [CASH FOND BALANCE JUNE 30,2003 8 T8008 , __[[shBatance Reported to Excise Boar@Tune 30,0000 SS 509,405.97] —n s——— a [is es ——— » [ot00ftocai Revenues YS 7.52076 8 [9200|State Revenues Yc 26s [9300)Federal Revenues «_[a00] Miscellaneous Revenues dS 00S [9500] Special Assessmenis [Ss | [pe00] Other Revenues | ro » |All Other Non-Tax Reems Sales Tax and Soles Tax Interest [ets [Prior Expenditures Resovered " a | is | 7 ——-o| S—n| Reserves From Schedule @ SS (ec ES 7 - ‘Net Appropriations ‘Warrants ‘Approved by Ln [200 Fringe Benefits Js ‘Js ss m 300 Travet Related SS D005 Total Maintenance & Operations] s__ sss s __woaeasga]'s S705 7 | [sri0 Machina & Eaupmen, CapilOwsy sss mir Expenses Ss sre fs reese SSO [TOTAL EXPENDITURES 2027-25 FISCAL YEAH S—assTefs____-_| ‘S.A. and 1. Form 2631ROI Entity: Ottawa County, 58 October 19, 2023 a --- OCR page 56 of 77 --- - Page 54 CHILD ABUSE (MULTIDISCIPLINARY) PREVENTION COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 - M-7202 ____CHILD ABUSE (MULTIDISCIPLINARY) PREVENTION - [TOTALASSETS.—OOOO Td [CTABILITIES AND RESERVES . [Warrants Outstanding ———_———SS isd [| HOTAL LIABILITIES AND RESERVES - - : [Cash Fund Balance Transfemed Outs Ff cS | Cs c ee a) [2100]tocal Revenues dS OS [9200]State Revenues [ss c [9300]Federal Revenves dS SY Cs [9500|Special Assessments SS . |s600[Other Revenues Si [9700] Schoo! Revenves SS CE a ° rs [ss [Ss -_ [serecr-ea . [fs sd ee [ss - [s____-_] es es a - es [ERC SS [sd = fet Appropriations Warrants ‘Approved b: - Ce HEE Se en |e a EC Ce Si a EE a a . S.A, and I. Form 2631RO1 Entity: ‘Ontawa County, 38 October 19, 2023 : --- OCR page 57 of 77 --- m 7 LAW LIBRARY COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 55 ESTIMATE OF NEEDS FOR 2023-2024 M-7205 _ LAW LIBRARY, m SSS |Warrants Outstanding ST [Reserve for Intereston Warrants ST " s_ bs " , ea [ss [Cash Fund Balance TransferedIn SS m [sd Cs [Sources ofRevenue |9000]Interest, MorgageTax Ss = [9100[LocalRevenues S80 SOS [9200|State Revenues [s_- [5300|Federal Revenues S's na [9400] Miscellaneous Revenues a [S600]Other Revenues ST [9700|School Revenues YS r [All Other Non-Tax Revenues SSCS dS SC | [Cash Fund Balance Forward From Preceding Ver S'S a " HOTALRECEIPTS dS 802 SST [ss [ss a linterest Paid Thereon SSS a [S____ 20,1389 [Sd [Reserve for Warrants Outstanding SS " HEE be Reserves From Schedule8 Ss [ss peor ST = _ | CASH BALANCE FORWARD TONEXT YEARS Net Appropriations] Warrants ‘Approved by ae | sa) iS - iis Ss Se a ES Ss ss S.A. and. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 58 of 77 --- Page 56 DRUG COURT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 - M-7206 DRUG COURT SSIS - [investments —_____________________________]_— ROTAL ASSETS re) [Warrants Outstanding Js] Reserve for merest on Warenis——— Reserves From Schedule3 Sd [TOTAL LIABILITIES AND RESERVES . L . [ Cash Fund Balance TransfenedOw SS dT [Cash Fund Balance Transferred In ss) [Adjusted Cash Balance SS [Ad Valorem Tax Apportioned To Vear in Caption SSCS «SS id : [Sources ofRevenue [2000]ineres, Morgage Tax i [9100}Local Revenues S82 SY [p200]State Revenues . |9300)Federal Revenues dS (dS [9400 Mfiseellaneous Revenés——— SS [9500]Special Assessments SS . [9600]Other Revenues " [2700}Schoot Revenves SS [AIT Other Non-Tax Revenues S'S Seles Tax and Sales Tex imerest IS dS ° [Cash Fund Balance Forward FromPrecedng Veer ISS [Prior Expendiures Recovered Sd OTAL RECEIPTS S512 0S) [TOTAL RECEIPTS AND BALANCES 10.795.47 3 J ° [Warrants of Year inCaption YS 302.008 limerest Paid Thereon SS [TOTAL DISBURSEMENTS JS . ICASHBALANCE JUNE 30,200) YS 0a SJ) Reserve for Warrants Outstanding SS [Reserve for Imerest on Warrnts YS Reserves From Schedule 8S - ITOTAL LIABILITES ANDRESERVE SYS YS [DEPICT SS [CASH BALANCE FORWARD TO NEXTYEAR STIS . ‘Net Appropriations Warrants ‘Approved by - [TOO Total Safaris SS [i200 Fringe Benefits SSS is [1300-Travel Related SSS 2000"Total Maintenance & Operations [S__ 1070290830200 [8s] = [2100-Total Machinary & Equipmen, Capital Outayf$— (SSS JAW Other Expenses SS iS tS [TOTAL EXPENDITURES 2002-05 FISCAL YEAR[S__1O72.50|'$____ 0000S ]S_Toamnso] $.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 59 of 77 --- = = COURT CLERK PRESERVATION COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 57 ESTIMATE OF NEEDS FOR 2023-2024 M-7210 wo __COURT CLERK PRESERVATION Sh Pnvestment sO [TOTAL ASSETS TS aT] S| [ss a [| sd 7 JABILITTES, RESERVES AN [Sete 5 Cour Cer Preservation Fund Balance Sheet of Curent and AT Prior Vege CURRENT AND ALL PRIOR YEARS TPE ‘| ” [_ Cash Fund Balance Transferred Out —SSSCSSCSCSCSCSCSCSCC‘dS CO Si sd a [Adjusted Cash Balance SOOTY [Ad Valorem Tax Apportoned To VearInCapion CdS S| jSources ofRevenue [9000[Interest, Mortgage Tax " [9100|Local Revenues [se [ss [9300[Federal Revenues = [9400[Miscellancous Revenues SS [9500[Special Assessments SS js Ss [9700|School Revenues ST m Al OtherNon-Tax Revenues SS [Sales Tax and Sales Tax imerest CS S| re a sd TOTALRECEIPTS,—OOOCSCSCSC‘C~*~;C~C~*iCS TGA TST [TOTALRECEIPTSAND BALANCES SST IS [Warrants of YearinCaption S'S n ee [ss [CASH'BALANCE JUNE 30,2003 SSS SST YS a is a | [ReservesFromSchedule8 SS [TOTALLIABILITESANDRESERVE SS a | I | " sd [Schedule 9: Court Clerk Preservation Fund Summary of Expenses ‘Net Appropriations ‘Warrants Approved by " [OO0Totat Salaries SSS a (Ca ES (KS " [Is00TravelRelated CS SS SS a }4100 Total Machinary & Equipment, Capital Outlay SS SS = lAlOtherExpenses SS Ss S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘October 19, 2023 = --- OCR page 60 of 77 --- Page 58 INDIVIDUAL REDEMPTION COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 = M7401 INDIVIDUAL REDEMPTION ASSETS . [Cash Balances 3 4 OTALASSETS—— S13 57 [Warrants Outsanding ST [so [sn - sd - [Cash Balance Reported to Excise Board Tune 30,3025 SS TS5ST] js is es ae [fs | ™ [Sources of Revenue [9000[Interest, Mortgage Tax [9100|tocal Revenues [ss . [Is - ‘is S| [SST |9500]Special Assessments - |9600[Other Revenues 0S 19700|School Revenues [so cs - LE Dee es es Es es [ss . a [ss [is _-_|s_——} [sd 7 a [se [ss [ss ‘ (2 Nn SN ESC NERO (Sss7 [sd ‘Net Appropriations Warrants ‘Approved b} [Ss ss SE 2000 Total Maintenance & Operations S$ SSSTS SSS ST 1 [So SSS i JAll Other Expenses SSS SY | S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 7 1 | --- OCR page 61 of 77 --- 5 = EXCESS RESALE COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 59 ESTIMATE OF NEEDS FOR 2023-2024 M-7402 EXCESS RESALE mn (ASSETS [vestments }s— [Warrants Outstanding CdS Reserve for Inereston Warrants |x] = [Reserves From Schedule33—————— [FOTAL LIABILITIES AND RESERVES SSCS | 5 —— [CURRENT'AND ALL PRIOR VEARS SPR TOO , _ [estBalance Reported to Excise Board Tone 3000S YS TOOSTSOT] [Cash Fund Balance Transfened OWS ST [Cash Fund Balance TransferedIn, CdS Sd m |Rdjusted Cash Balance dS FOS [Ad Valorem Tax Apporiioned To VeartuCapion SSCS S| Bourcesof Revenue > [piod]Local Revenues S250 ST [p200] Stare Revenues SS [9500[Federal Revenues —___{s__- Js] ,—_[t00|Miscetaneous Revenmes SS [9500|Special Assessments} s_ 5s (5600) Ofer Fens | SE | 5 ENON-F [9700|Sckool Revenues ss = __|alCOther Non-Tax Revenues SS ales Tax and Sales Tax nero ss [Cask Fand Balance Forward From Preceding Vea SS —_[rorExrendiresRecoweed Si ” — FovaC RECEIPTS YS 27. 555.58 ST HOTALRECEIPTS AND BALANCE SSS YS 15,926,998 HWavants of Year in Caption] 8___ saz [3 » _|imersrPaid Theron dS TOTAL DISBURSEMENTS (Spry ICASH BALANCE JUNE 30,2005 STATIS (Reserve for Warrants Outsandmg SS mW RegeveforInterest on Warans Recenes Hom Schedule 8S FrOTAL LIABILITES AND RESERVE perern YS m CASH BALANCE FORWARD TONEXT YEARS Sera ST ‘Net Appropriations Warrants ‘Approved by " ota hiz00 Fringe Benet Ss = Soo Travel Related SS 000 Tata Maintenance & Operations | 3 1woseh.OT|[S__7saus 7a |S 2551 | L100 Total Machinary & Equipment, Cantal OwayfS—— SS SS iter Expenses SS SS r HOTAL EXPENDITURES 2007-05 FISCAL VEAR|S 10090001 [S549 7a |S 25519.29] J S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 62 of 77 --- Page 60 TAX REFUNDS COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 e M-7408 __ a TAX REFUNDS ASSETS. = [investments [fOTAL ASSETS S933] S| [Reserve for Interest on Warrants SSS [s_ S| . 7 a re ee . [Ss 4.132.513 [S| ee es . a | [sos [9100[Local Revenues ST [9200|State Revenues . js [SS is - ‘is ist F [9600[Other Revenues 0 [9700]School Revenues SS JAIL Other Non-Tax Revenues YS dS] [Sales Tax and Seles Tax imerest SS | ° Ce es a | [$151,897.33 [$s . [$__151,738.00|/$ | rs ist - S| a [ss as - [s 2 (ES (KC [sd = Net Appropriations Warrants a ‘Approved b: - SS Ce Ce | Ss [SS Ss 935 - [2100 Total Machinary & Equipment, CapralOutley[$ “SS «SSS dS SC Ci JAN Other Expenses | SSS [S151 73800 [SS 1593S S.A. and 1, Form 2631RO1 Entity: Ottawa County, 58 October 19, 2023 7 = --- OCR page 63 of 77 --- m 7 EMERGENCY TRANSPORTATION REVOLVING COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 61 ESTIMATE OF NEEDS FOR 2023-2024 M-7506 a EMERGENCY TRANSPORTATION REVOLVING A (SSS 2 [investments [TOTAL ASSETS 4 x aS TESERY : 3 215,760.02 [s_ [ST 5 [Reserves From Schedule 3s s_ 7 | “Cash Fund Balance Transferred Out Ss [_ Cash Fund Balance Transferred In SS a [Adjusted Cash Balance 0 80,956.27 5 | JAd Valorem Tax Apportioned To Year In Caption SS [ss " —|fp100ftocal Revenues Sg |9200|sState Revenues 275,760.02 [8 [9300[Federal Revenues 1 js [9500|Special Assessments Ss [S600]OmerRevenves gs [9700|School Revenues SST 1 [ATI Other Non-Tax Revenues Ss [ss [s_S [Prior Expenditures Recovered ST [st [ss [s_180,956.27[$ a linerest Paid Thereon Sg [ss aaa [Reserve for Warrants Quistandmg Sg " [ss [ss TOTAL LIABILITES ANDRESERVE SS [DEFICITS [S__ 275,760.02 [S ‘Net Appropriations: Warrants ‘Approved by [1100 Total Salaries Ss Se | J a ESE [s__wossea7[s—— St [2100 Total Machinary & Equipment, Capital Outlay $= Ss . Ss Es S.A. and I. Form 2631R01 Entity: Ottawa County. 58 October 19, 2023 n --- OCR page 64 of 77 --- Page 62 EDUCATIONAL TRUST COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 . EDUCATIONAL TRUST M-7605 _ c IOTAL ASSETS SSCS 345.00] [s [Reserve for Interest on Warrants Se his [TOTAL LIABILITIES AND RESERVES Sd : c [SS 2970.00] ' [sss [SS [sn [Ad Valorem Tax Apportioned To YearInCaption SS ' [Sources of Revenue [ss [ss [9200|StateRevenues SS . DE Dae [ss [9500|Special Assessments ST ‘ [se [ss ss [Sales Tax and Sales Tax Interest SS e [SS [ss [s_ 12,565.00 [$s [ss ‘ js = GEES [so c sd a [sos [ss . [ss [ss [sd . ‘Net Appropriations Warrants ‘Approved by . [T1OOTotal Salaries Se [1200 Fringe Benefits dS YS SC CdS Cd [SS SS [SS SS . [SS s_ S____ 3.00000 [Sd - S.A. and I. Form 2631R01 Entity: Ottawa County, 58. ~ October 19, 2023 --- OCR page 65 of 77 --- = I INDEPENDENT SCHOOL REMIT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 63 ESTIMATE OF NEEDS FOR 2023-2024 M-7702 INDEPENDENT SCHOOL REMIT 2 SS ee eos eae Oo] fsvestments [FOTAL ASSETS ST] = x5 FAS RESERG — ___|s 99,535.27 [Warrants Outstanding [Reserve for Interest on Warrants 0s nm _ Reserves From Schedule $C sd a (Cash Balance Reporied to Excise Board June 30,2022 0587050 " [sis Ce a [s—— | a [p000[Interest, Mortgage Tax TS 19s 66.2a fs 7 [9100[Local Revenues [ss |9200|State Revenues [ss [9300|Federal Revenues TS S| 4, [400 [Miscellaneous Revenues SS [9500]Special Assessments OS ST [9600|Other Revenues [ss [9700|School Revenues dS ST m [All Other Non-Tax Revenues SS is - is ss [Prior Expenditures Recovered Sg " [ss [ss [Warrants of VearinCaption SS 198.2089 I'S m limerest Paid Thereon Ss [Ss [CASH BALANCE JUNE 30,2025 S935. 7S [Reserve for Warrants Outstanding SS " ee [Reserves From Schedule SS [ss DEFICITS " [S___ 99535278 Net Appropriations Warrants: ‘Approved by ° [To0Toral Satanes_—— SS [i200 Fringe Benents S'S fs m3 00"Travel Related sss [sss " [a100 Total Machinary & Equipment, Capnal Owlay|S—- [SS ST [S_12295,518.67 |S Ta.t9eaz0.89 ST S.A. and I. Form 2631ROI Entity: Ottawa County, 58 ‘October 19, 2023 r --- OCR page 66 of 77 --- ° Page 64 MUNICIPAL-CITY-TOWN REMIT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 e MUNICIPAL-CITY-TOWN REMIT. M-7703 _ Ne TOTALASSETS— Reserve for inerestonWaranis—— ST Reserves FromSchedule3 . . . [ss ee a ' es |9100[Local Revenues . [ss [9300|Federal Revenues [9400|Miscellaneous Revenues SS [9500|Special Assessments [st ‘ [ss fs rs JAlTOther Non-Tax Revenues Ss [Sales Tax and Sales TaxImerest YS dS . ee) js ts [ss ; [ss [ss js [ss . [ss a . ‘Net Appropriations farrants ‘Approved bj : a a a Ce a EE Ss . a EE [ss [S380 805.99 | sd - S.A. and I. Form 2631R01 Entity: Ottawa County, $8 October 19, 2023 --- OCR page 67 of 77 --- m 2 EMERGENCY MEDICAL SERVICE DISTRICT (EMS-522) REMIT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 Page 65 ESTIMATE OF NEEDS FOR 2023-2024 M.7704 EMERGENCY MEDICAL SERVICE DISTRICT (EMS-522) REMIT [investments OB [TOTAL ASSETS Od ° [ss [ss a [ss [s__ > Se 5 [SS 5675.08] |_ Cash Fund Balance Transferred Qut SS |_Cash Fund Balance Transferedin ST SC ] [so - S| | | [ss ° |9100[Local Revenues [ss [9300[Federal Revenues 2 |9400[Miscellaneous Revenues Ss [9500|Special Assessments S'S [9600|Other Revenues es cs = [ss [Sales Tax and Sales Tax Interest Ss [Cash Fund Balance Forward From Preceding Year SS Sd [Prior Expenditures Recovered SS , [ss T [TOTALRECEIPTSAND BALANCES 603,892.01 [8 [Warrants of Year in Caption TS 599,784.21 ST 9 [imerestPaidThereon Sg SJ [CASH BALANCE JUNE 30,2003 SOTO YS [Reserve for Warrants Quistanding ST " [Reserve for Interest on Warrants ST [s_ S [ss DEFICITS SS [Sd 4 ‘Net Appropriations Warrants Approved by " a | | a | | ” [SS ss [ss a CE n [se - S.A. and |. Form 2631RO01 Entity: Ottawa County, 58 ‘October 19, 2023 a --- OCR page 68 of 77 --- - Page 66 CAREER TECH REMIT COVERING THE PERIOD 7/1/2022 TO 6/30/2023 ESTIMATE OF NEEDS FOR 2023-2024 CAREER TECH REMIT M-7706 —EE . Ss — —-1) 7 CORREO BRAN CE TONE S020 : : fs - isd [Cesi-Fund Balance Transfered In |s_____-_|s_ ae [Ad Valorem Tax Apporioned To VeorInCapion iS TORI : a [P100|Locat Revenues Si ; [p20o|state Revenues Sd is. | is___- [s-_1 [P400] Miscellaneous Revenues SS ss [9e00] other Revenues Cs ss] Sales Tax and Safes Tax interest SS ' Cs [ss [s__-] . isd fs dt [imerestPaidThereon Sd [sa ienzeTys | : s—_— [fs [s_____- |s___-_] Reserves From Schedule SZ FOTAL LIABILITES ANDRESERVE SSCS CdS Ce [s——ameays————]} ‘Net Appropriations ‘Approved b: C a Ha Se Ge SC 2000 Total Maintenance & Operations +S SS dS Sd SC s—__| S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 19, 2023 --- OCR page 69 of 77 --- m = Page 67 Statement of Receipts, Disbursements, and Changes in Cash Balances Exhibit W a ee, ey 3 2.714,530.25 |S 531835825 [5 969.72 is 0.00 €,107,617.24 |S 1,926 28096 | nding [soos oo fs 00 [soo sooo fs 0.00] " [s_ 0.00 fs 0.00 J [Exit fs 456,570.58] s 315,195.49 [$0.00 S000 fs 268,076.65 /§ 504,289.44 fowl ExhibitGs [soo sooo sooo fs 00 fs 0.00 fs 0.00 [Toul Exhibits [sooo fs oo sooo fs 0.00 fs 0.00 fs .00 | m Total Exhibits |S $.702,072.08 [$ 4.273,958.64 [$ 30,449.00 |S 31,959.35 [$ 4843,785.77[$ 5,130,734.60 otal Exhibit STs |S 3,642,764.64S 2,954000.48[[S __O.00|'S _—OO0'S __2.481,454.28]|$ _4.115.359.84 [TowlExhibitys “fs 000 fs 0.00 fs 0.00 sooo soos 0.00 | otal Exhibitk’s [$0.00 fs 000 ifs 00 fs 000 fs 0.00 000 | owl Exhibits fs oo {s ooo fs ooo fs ons ooo fs 000 | " otal Exhibit MSS 320,403.97 |[S___15,676,630.11 S 156,965.43 4152.51 [$___15,750,95047 [$607,976.53 a = a na m = mA mi al = --- OCR page 70 of 77 --- m 8 Page 69 Calculation of the Maximum Budget available using 5 the Estimated Valuations, Miscellaneous Revenues, and Carryover Exhibit X 5 General Fund General Fund Mill Lev; 40.24 [0.09 PT FFotal Estimated Assessed Valuation S__211,625,955.00| ——~S«YCS I n Gross Ad Valorem Tax Le $ 2,167,09074[ CdS C™~CS@Y Reserve for Delinquency Reserve Percentage] 10%| § 197,008.25 | Ss [Net Ad Valorem Tax Levy $ 1,970,08249[SC*d'S 1,970,082.49 aa 7 ‘Cash fund balance. June 30 $ 1,462,735.80 | § 278,330.29 | $ 1,741,066.09 Miscellaneous Revenue $ 2,804,046.72[S 0.00 | S$ 2,804,046.72 a ee a Total Available for Appropriations 5 6,236,865.01 | S 278,330.29 | $ 6,515,195.30 ] a n nm a) a m m™ " aa] = S.A. and I, Form 2631ROI Entity: Ottawa County, 58 October 19, 2023 m= --- OCR page 71 of 77 --- a] Exhibit “y" = xhibit “Y’ Page 71 CERTIFICATE OF EXCISE BOARD = ESTIMATE OF NEEDS FOR 2023-2024 = a ISTATE OF OKLAHOMA, COUNTY OF OTTAWA. We, the members of the Excise Board of said County and State, do hereby certify that we have examined the foregoing 4 estimates of proposed current expenses for the ensuing fiscal year as filed with the Board of County Commissioners, and thosel directly under, or in contractual relationship with, the Board of County Commissioners; we have ascertained from the |Financial Statements submitted therewith the amount of Surplus Balances of Cash on Hand; we have considered the luncollected ad valorem taxes of the previous year or years; and we have ascertained that the probable Income estimated to be a collected from all sources other than ad valorem taxation may reasonably be expected as a revenue for the ensuing fiscal year, jand that the same does not exceed 90% of the actual collection from such sources for the previous fiscal year. a lin so doing, we have diligently performed the duties imposed upon the Excise Board by 68 0.S. 1991 Section 3007, (1) a jascertaining that the financial statements, as to statistics therein contained reflect the true fiscal condition at the close of the \fiscal year, or caused the same to be corrected so to show; (2) struck from the estimate of needs so submitted any items not jauthorized by law and reduced to the sum authorized by law any items restricted by statute as to the amount lawfully . lexpendable therefore; (3) supplemented such estimate, after proper publication, by an estimate of needs prepared by this " |Excise Board to make provision for mandatory governmental functions where the estimate submitted wholly failed or was \deemed inadequate to fulfill the mandate of the Constitutions or of the Legislature; (4) computed the total means available to leach fund in the manner provided; and (5) then and only thereafter. 7 5 |Accordingly, we have and do hereby appropriate the Surplus Balances of Cash on Hand, and the Revenues and Levies lhereinafter set forth for each Fund to the several and specific purposes named in such estimates, by each, to the intent and lpurpose that CONSTITUTIONAL GOVERNMENTAL FUNCTIONS shall be first assured and provided for, and lsubsequently to provide for Legislative Governmental Functions insofar as to the available Surpluses, Revenues and Levies 7 hvill permit; and we have provided also that the Levies are in excess of the amount appropriated to needs after deducting the surplus cash balance on hand, and Estimated Revenues other than tax, by the percentage and amount or reserve for delinquent ax as hereinafter set forth, which we have determined in the manner provided by law. 7 7 [We further certify that we have examined the within statements of account and estimated needs or requirements of the |Governing Board of Ottawa County, in relation to the Sinking Fund or Funds thereof, land after finding the same correct or having caused the same to be corrected pursuant to 68 O. S. 1991 Section 3009, have lapproved the requirements therefor to fulfill the conditions of Section 26 and 28 of Article 10, Oklahoma Constitution, and J Ihave made and certified a tax levy therefor to the extent of the excess of said total requirements over any other legal ldeduction, including a reserve of caused the same to be corrected pursuant to 68 O. S. 1991 Section 3009, have approved the requirements therefor to fulfill the conditions of Section 26 and 28 of Article 10, Oklahoma Constitution, and have made and a Icertified a tax levy therefor to the extent of the excess of said total requirements over any other legal deduction, including a lreserve for delinquent taxes. ” pe S.A. and I. Form 2631ROI Entity: Ottawa County. 58 _ October 19, 2023 7 --- OCR page 72 of 77 --- CERTIFICATE OF EXCISE BOARD ESTIMATE OF NEEDS FOR 2023-2024 ™ lof Income and Revenue Fund Depart ment (Exe, Homesteads) [S___6.515,195.30 | [sn [ss - fs, Value of Surplus Tax in Process ———SOSCSC—~d SS SS . re - [Added for Delinquency «iS ———*97,008 25 [S$ 29.es.ig [ST a [Rate of Levy Required and Conmec (mM) OEE ' We further certify that the net assessed valuation of the Property, subject to ad valorem taxes, after the amount of all Homestead Exemptions have been deducted in the said County as finally equalized and certified by the State Board of Equalization for the current year 2023-2024 is as follows: ' ' and that the assessed valuations herein certified have been used in computing the rates of mill levies and the proceeds thereof appropriated as aforesaid; and that having ascervained as aforesaid, the aggregate amount to be raised by ad valorem taxation, we thereupon made the levies therefor as provided by law as follows: ' Free Fair Budget Account (Levy Per Applicable Statute) 0.00 Milis; Free Fair Improvement Budget Account (Net Proceeds of 1.00 Mill) 0.00 Mills; Free Fair Additional Improvement Budget Account (Net Proceeds of 1.00 Mill) 0.00 Mills; Library Budget Account (Net Proceeds of 1/2 of 1.00 Mill) 0.00 Mills; | Cooperative County/City-County Library Budget Account (1.00 to 4,00 Mills) 0.00 Mills; County Cemetery (Prior To Aug, 15, 1933) Budget Account (Net Proceeds of 1/5 of 1.00 Mill) 0.00 Mills; Public Buildings Budget Account (Not To Exceed 5.00 Mills) 0.00 Mills; . Emergency Medical Service ( Not To Exceed 3,00 Mills) 0.00 Mills; Total County Levies 11.78 Mills; County Wide Levy For Schools (4.00 Mills) 10.00 Mills; Total County Wide Levy 11.78 Mills; ' and we do hereby order the above levies to be certified forthwith by the Secretary of this Board to the County Assessor of said County, in order that the County Assessor may immediately extend said levies upon the Tax Rolls for the year 2024 without regard to any protest that . may be filed against any levies, as required by 68 O. S. 1991, Section 2869. Dated at CV ener \ + Oklahoma this AD day of fad 2023 E > . 7 Excise Board wpe xSise Board Chairman ay, TR, Abd Exeisd Board Member KE VS Excise Board Secretary Ss i\ wd 7 S.A. and I, Form 2631R01 Entity: Ottawa County, 58 i Hs October 19, 2023 be TAWA COUNTY 2; Sie | 07. iF] ae” --- OCR page 73 of 77 --- nm A Page 73 Ouawa County, 58 Statistical Data a] 2023-2024 J [Total Gross Valuation Real Property $ 152,547,487.00 [Total Homestead Exemption $ 8,501,950,00 Total Real Prope $ 144,045,537.00 n PT [Total Personal Property 5 35,653.521.00 Total Public Service Property $ 31,930,897.00 Total Valuation of Property 629,955.00 a " n n a n = m nm m m ma = S.A. and I. Form 2631RO! Entity: Ottawa County, 58 October 19, 2023 = --- OCR page 74 of 77 --- _ — PUBLICATION SHEET - OTTAWA COUNTY, OKLAHOMA SINANCIAL STATEMENT OF THE VARIUS FUNDS FOR THE FISCAL YEAR ENDING JUNE 30,2023, AND ESTIMATE OF NEEDS FOR THE FISCAL YEAR ENDING JUNE 30, 2024, OF THE GOVERNING BOARD OF dl OTTAWA COUNTY, OKLAHOMA Exhibit "Z” Page 75 STATEMENT OF FINANCIAL CONDITION General Health Sinking Lae eee] Cash Balance June 30, 2023 5 1,926,240.96 || 504,289.44 | tavestments SS . [___TOTALASSETS 1,926,240.96 [S$ SORTS sd LIABILITIES AND RESERVES a | (| $ 62,533.74 |S 6,738.27 |__Reserves for Interest on Warrants [SS J Reserves trom Schedule 8 5 123,641,15 |[S 47,630,50 TOTAL LIABILITIES AND RESERVES 3 8,368.77 CASH FUND BALANCE (Deficit) JUNE 30, 2023] S T,741,066.09 || S 455,920.67 > ee nn Ds inna ESTIMATE OF NEEDS Grand Total Current Expense Needs $ 6,515,195.30 | $ 752,202.61 7 Reserves for Interest on Warrants & Revaluation [|S Total Required 3 6515,195.50 || 5 752,202.61 FINANCED: a (a || . $ 1,741,066.09 Revenues Approved by Excise Board 5 2,804,046.72 Total Deductions 4,545,112.81 || S 455,920.07 CERTIFICATE - GOVERNING BOARD , STATE OF OKLAHOMA, COUNTY OF OTTAWA, ss: We, the undersigned duly elected, qualified Governing Officers of Ottawa County, Oklahoma, do hereby certify that at a meeting of the Governing Body of the said County, begun at the time provided by law for Counties and pursuant to the provisions of . 68 O.S. 1991 Sec. 3002, the foregoing statement was prepared and is true and correct condition of the Financial A fairs of said County as reflected by the record of the County Clerk and Treasurer. We further certify that the forgoing estimate for current expenses for the fiscal year beginning July 1, 2023, and ending June 30, 2024, as shown are reasonably necessary for the proper conduct of the affairs of the said County, that the Estimate Incometo be derived from sources other thatn ad valorem taxation ~ does goreRpeed the lawfully euthosjagd ration ofthe revenue derived from the same sources during the preceed oses TIER) aa I\ «NG fg He CR F OTTAWA COLNTY £ 7 Hef <<) es bell as Airman os Cn Calunty Clerk Ra Seal pr’ o aa Te g OR Subscribed and sworn as before me this Commissioner - OS cayor eke ln 20 => si ia oS a Rei Commissioner She goTh apt ree ee F&fortawa county” | = i 423011885 } = Ek exp, 09-01-2027 FS 5 5 2 Ox is October 19, 2023 S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ZA byes yetober 19, 2023 en Bo OS L “nS OF OMS --- OCR page 75 of 77 --- - Page 76 C Estimate of Needs by Appropriated Account for 2023-2024 Fiscal Year 2023-2024 e = ‘Needs as Estimated by ‘Approved by County [Departments 0100, District Atorney - (Department: 0400, Sherif . [_1110, Fulltime selares CdS SC (1130, Pan Time salaries SS 9578.9 [""2005; Maintenance & Operation SS —49;6 285.24 | [-2020, Professional Services SS 33 02820 | - [8130 Lease/Rentals SS 9.96188 [Total for 0400, Shen? dS iS ——« OS T (Department: 0600, Treasurer . [Total for 0600, Treasurer id 2 39S 794,398, 30 . [Department: 0800, Commissioners [1310,Travel 2.000.008 2,000.00 : [Bepartment: 0900, OSU Extension J | Total for 0900, OSU Extension id Scag 158, 69600 | [Department: 1000, County Clerk . [1310,Travel dS 105354. 40 3 10333040] . [Total for 1000, County Clerk «dS ID'S a0 302.20] [Department: 1400, Court Clerk [1310 Travel 033440 1093380 - [Department: 1600, Assessor [1310 travel YS 220 12820 = [Departments 1700, Visual Inspestion JP | 1110, Full time salaries dS Ss [1310, Travel 500.00 7359000 . | S.A. and I. Form 2631R01 Entity: Ottawa County, $8 . October 19, 2023 7 7 --- OCR page 76 of 77 --- sca FILED CCunent fecal yoor 2023-2024 Dain Cated ctor a.2022 NOV 01 2023 Taxable Year 2024 . Valuation OTTAWA COUNTY TAX LEVIES State Auditor & Inspector (2023-2024 uuiror taxarion | _ost fund fund rund _| Fond Jwvandowe | tori t0.24f= 0.00] tsa at | sor" seas] siz 7.06024” 1.02||70.94] [—roz[o.00f asa] ata Sor] s6.a9j-.z7[- 3.65 t0.24 1.02” 75.82) don't add votech amounts fauna | taf 40.24] 0.00] asa] ato! | 3.07]) 36.78} 13.47] t0.24 1.027 84.57| fcommerce | taf 40.24] 0.00] asa] atoll 3.07] a.s6[-.0a|-" 10.96 to.zaf 1.02 29.04] fim | tas [40.24] 0.00] asa] atoll 3.07 s5.7o|= sto 2.92 to.zaf 1.09 Jaton | asf 10.24] 0.00] tsa] to, 3.07] 6.08] sts[= 08 | to.24] 0.00 asa] ata! 3.07] 36.04" Stef 45.27 10.24] 1.02] 96.67] SR (OO fiona [10.20] 0.00] asa] atoll s.o7|| 35.48] S07 47.98|-t0.26| 4.02 98.69] eS a ee ee ees | ee ee ee ee a (| a A RN NS S| | ES ( a SS | A A | | | LO (| a |S CRC | || SS | | + Common Fund - 4 Mil Levy County Wide Levy for Schools ** Vo-Tech # 14 - Northeast Technology Center - Burns Flat, Mayes Co, State of Oklahoma ) )ss. County of) Wee Wid Clerk for Ottawa County, Oklahoma, do hereby certify that the above levies are true and correct for the taxable year 2019. Gee Witness my hand and seal this: S RD fe ® LS i Lange PL Wn LON BS fa County Clerk Nd & aaa EY --- OCR page 77 of 77 --- : = Page 77 Estimate of Needs by Appropriated Account for 2023-2024 ‘Governmental Budget Accounts . Governing Board, Excise Board ,, _ | Department: 2000, General Government [ 1110, Fulltimesalaries YSIS | a [Department: 2100, Excise Equalization " [Total for 2100, Excise Equalization dS aS (Department: 2200, Election Board . [71310 Travel dS 50.00 8 650.00] : , _|Pepartment: 2500, information Technology [Total for 2500, taformation Technology dS 50.0000 S 30.00.00] [Department: 2700, Emergency Management , [[1310, Travel ES 5.00000" S 3.00.00] [Departments 4500, County Audit Budget , [Department: 4600, County Cemetery » Department: 4700, Free Fair Budget , (“Total Tor Unrestricted Expenses for the General Fund: [3 3 908,81009 |S 4,727,068.58] 1 [Department:800 Shentest [""3005, Maintenance & Operation SCC~dS Sd * — |[2020, Professional Services YS i388 02822 I S [ #130, Lease/Remals S898 ; [Total for Restricted Expenses tor the General Fund: [S218 18493 |S 1, 788,105.77] footGewairow oernowens ————*diS moms] ; S.A. and I, Form 2631R01 Entity: Ottawa County. 58 October 19, 2023 ,