--- OCR page 1 of 74 --- . Stave OTTAWA COUNTY N 2022-2023 OV 14 29% ESTIMATE OF NEEDS E AND FINANCIAL STATEMENT or Hae Auditor gl FISCAL YEAR 2021-2022 "Spector cE BOARD OF COUNTY COMMISSIONERS OF THE COUNTY OF OTTAWA STATE OF OKLAHOMA r 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 r 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. - THE 2022-2023 | ESTIMATE OF NEEDS : AND E FINANCIAL STATEMENT OF THE FISCAL YEAR 2021-2022 PREPARED BY TURNER & ASSOCIATES, PLC SUBMITTER TO THE OTTAWA COUNTY EXCISE BOARD THIS | *"pay OF ew ember 2022 BOARD OF COUNTY COMMISSIONERS [ Zab Chairman County cies Osh) 7, ys : VY), Commissioner // / ‘ommissioner e Ec Treasurer: Assessor F220 2) Ky Cousbag ( r Court Clerk Not available ner Ro ban shee ‘ RECE! ED S-A- and. Form 2631 R01 Entity: Ottawa County, 58 November QQ por: nr r State Auditor and Inspector r Of We --- OCR page 2 of 74 --- C ™ Index Page | Exhibit Av. = County General 1 - Exhibit D County Highway Unrestricted 13 Exhibit E Health 21 Total Exhibit I's 29) 1-1103 County Bridge and Road Improvement 30 - 1-1204 k Assessor Revolving Fee 31 1-1208 County Clerk Lien Fee 32 1-1209 County Clerk Records Management and Preservation 33 1-1212 Emergency Management 34 5 1-1218 Local Emergency Planning Committee 35 11220 Resale Property 36 17-1221 Reward Fund 37 11223 Sheriff Commissary 38 q 17-1225 Sheriff Forfeiture 39 1-1226 Sheriff Service Fee 40 1-1230 Treasurer Mortgage Certification 41 ~ 1-1235 County Donations 42 1-1401 Convenience Center 43 1-1456 Bureau of Indian Affairs Assigned by County 44 1-1507 Special Revenue Assigned by County 45 ~ 1-1566 American Rescue Plan Act 2021 46 Total Exhibit L.ST's 47 LST-1305 Courthouse Improvement Sales Tax 48 LST-1313 Road and Bridges Sales Tax 49 - LST-1321 Rural Fire Sales Tax 50 Total Exhibit M's 51 M-7201 Court Clerk Revolving a2) M-7202 Child Abuse (Multidisciplinary) Prevention 53 Ei M-7205 Law Library 54 M-7206 Drug Court 55 M-7210 Court Clerk Preservation 56 M-7401 Individual Redemption 37 7 M-7402 Excess Resale 58 M-7408 Tax Refunds 59 M-7506 Emergency Transportation Revolving 60 - M-7605 Educational Trust 61 M-7702 Independent School Remit 62 M-7703 Municipal-City-Town Remit 63 M-7704 Emergency Medical Service District (EMS-522) Remit 64 - M-7706 Career Tech Remit 65 Exhibit W 67 Exhibit X 69 Exhibit Y yak be | Exhibit Z 75 Salary Calculations Tl - = - S.A. and I. Form 2631 R01 Entity: Ottawa County, 58 November 09, 2022 ™ = | --- OCR page 3 of 74 --- ol OTTAWA COUNTY 2022-2023 ESTIMATE OF NEEDS fl AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2021-2022 _ 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 ~ beginning July 1, 2021 and ending June 30, 2022, together with an itemized statement of the estimated needs Ithereof for the fiscal year beginning July 1, 2022 and ending June 30, 2023. The same have been prepared in conformity to Statute, in relation to which be it further noted that: if 1. We, the members of the Board of County Commissioners of said County and State, do hereby certify that ithe statements herein submitted show the true and correct conditions of the fiscal affairs of said County for the ifiscal year ending June 30, 2022, that said statements comprise a "full and accurate statement of the E lassessments, 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, 2022 pursuant to the provisions of 68 O.S. 1991 Section 3002. r 2. And we further certify that the estimates of the several amounts necessary for current expenses for the fiscal " lyear beginning July 1, 2022 and ending June 30, 2023 as shown under "Schedule 8" were prepared and filed _ \with the Board of County Commissioners as of the first Monday in July 2022, that the same have been | correctly entered, and that all estimates made are entered as certified by Department Heads for the respective L lpurposes herein set out. We further certify that the sums requested for salaries of county officers and the deputies are calculated and based upon authority of salary statutes currently effective and applicable in this 3. We further certify that the estimated income from sources other than ad valorem tax, shown on "Schedule |4", 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, 2022. \Dated at the office of the County Clerk, at Miami, Oklahoma, - Ithis day of , 2022. Cat AMAL Za AM ayrmaly 7 County Clerl gE V Wh, Evicvan Drove Rew — ‘omm Aiongy7 Ssiorler > reasurer ‘Assessor ew Court Clerk Sheri . IFiled this day of. , 2022 Secretary and Clerk of Excise Board, Ottawa County, Oklahoma. S.A. and I. Form 2631ROI Entity: Ottawa County, 38 November 09, 2022 r --- OCR page 4 of 74 --- Independent Accountant's Compilation Report ™ Honorable Board of County Commissioners = Ottawa County, Oklahoma Management is responsible for the accompanying 2021-2022 prescribed financial statements as of and m for the fiscal year ended June 30, 2022, and the 2022-2023 Estimate of Needs (SA&I form 2631R97) and the Publication Sheet (SA&I 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 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. o 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 m of the County's assets and liabilities, This report is intended solely for the information and use of. management of Ottawa County, Oklahoma, c 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. . m =a > - luaNeeq Associates, PLE TURNER & ASSOCIATES, PLC --- OCR page 5 of 74 --- ~ - AFFIDAVIT OF PUBLICATION r STATE OF OKLAHOMA, COUNTY OF OTTAWA. Personally appeared before me, the undersigned Notary Public, . Abe nw Mike boll 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, 2022, and the estimated needs and the ~ estimated income from sources other than ad valorem taxes, for the fiscal year beginning July 1, 2022 and ending June 30, 2023 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 = with proof of publication is herewith attached marked Exhibit "Z" and made a part of hereof. i=) a ‘County Clerk : ih Subscribed and sworn to before me this\4 day oQolember 2022. = 4 Q2G0dI? 7 r Notary Public My Commission Expires ote, OFFICIAL SEAL = S220 NATASHA L BRUNNER iat ke: = NOTARY PUBLIC OKLAHOMA Ber OTTAWA COUNTY “tans COMM. NO, 22002227 EXP, 02-15-26} = = ” ro] oa P) S.A. and I, Form 2631R01 Entity: Ottawa County, 56 November 09, 2022, a) ) --- OCR page 6 of 74 --- ee PUBLICATION SHEET - OTTAWA COUNTY, OKLAHOMA “INANCIAL STATEMENT OF THE VARIUS FUNDS FOR THE FISCAL YEAR ENDING JUNE 30, 2022, AND ESTIMATE OF NEED! FOR THE FISCAL YEAR ENDING JUNE 30, 2023, OF THE GOVERNING BOARD OF OTTAWA COUNTY, OKLAHOMA Exhibit “2” fae [STATEMENT OF FINANCIAL CONDITION General Health Sinking IAS OF JUNE 30, 2022 Fund Fund Fund [ASSETS Cash Balance June 30, 2022 $ 2,714,465.59 || $ 456,290.58 [__Tnvestments TOTAL ASSETS 3 2,714,405.59 || S 756,200.58 LIABILITIES AND RESERVES: es SE Warrants Outstanding y 137,827.77 || S. 3,678.50 Reserves fr Interest on Warrants Reserves from Schedule 8 5 1,028,889.05 |['S 90,564.34 TOTAL LIABILITIES AND RESERVES || S 7,166,716.82 |[S 94,240.84 CASH FUND BALANCE (Deficit) JUNE 30, 2022][ $ 1,547,748.77 ][$ 362,047.74 a | | | ESTIMATE OF NEEDS FOR FISCAL YEAR ENDING JUNE 30, 2023 Grand Total Current Expense Needs: $ 6,256,728.55 |] S 639,474.97, Reserves for Interest on Warrants & Revaluation Total Required 5 ©,256,728.55 || S GIT ATAIT FINANCED: PT Cash Fund Balance $ 1,547,748.77 || $ 362,047.74 Revenues Approved by Excise Board 5 2,864, 268.89 Total Deductions S 4.412,017.00| S 362,047.14 [Baas to Raine Team Ad Watonem TSS TS SES 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 Affairs of said County as reflected by the record of the County Clerk and Treasurer. We further certify that the forgoing estimate for current <qsea> expenses for the fiscal year beginning July 1, 2022, and ending June 30, 2023, as shown are reasonably necessary for the prope, conduct of the affairs of the said County, that the Estimate Incometo be derived from sources other thatn ad valorem taxation * § id %) does not exceed the lawfully authorixed ration of the revenue derived from the same sources during the preceeding fiscal ye FO raat OLN 1 a / 897 2 nN i MM eS Chairman of Board County Cl Seal Subscribed and sworn as before me this ‘oméfissioner jf day of yy _ 2022. ‘Commissioner 1 \ ‘Notary Public - oonttinn, OFFICIAL SEAL °° NATASHA L BRUNNER Ea Ke NOTARY PUBLIC OKLAHOMA, Boeaaee OTTAWA COUNTY S.A. and I. Form 2631RO! Entity: Ottawa County, $8 “mans” COMM, NO. 22002227 EXP. 02-15-26 November 09, 2022 --- OCR page 7 of 74 --- COUNTY GENERAL COVERING THE PERIOD ‘7/2021 TO 6/30/2022 Page | ESTIMATE OF NEEDS FOR 2022-2023 Fr EXHIBIT A r | tevestments oo I A APE | i [Reserve for interest on Warranss TF Pr r |» Cc" PREVENT —=S*Y r FP r |_TOTAL REVENUE dS STA] REQUIREMENTS: r |_ interest Paid on Warrants Sd [_Reserve for interest on Warrants iS [ r [ADDITIONS EEE OEE [sn r a [DEDUCTIONS OE Eee eee] C [sd | es | r r S.A. and [. Form 2631R0! Entity: Ottawa County, 58 November 09, 2022 --- OCR page 8 of 74 --- Page 2 COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 _ ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT A —— [Schedule a: Revenue J. 2000-7021 Account [2001 3022 Accoumt J] ‘Actually ‘Amount Actually | om | o [AdValorem Taxes - [s__aanssis = [8 _saz367a[s 33.36.78] [S_3naes21 ff sais Ts 31,658.15] : [S__ae[s ‘say [s____an20[s__ 99740018 45620) ° CS . | 9107 Coun Cenk Fees SiS 10,012.19 | [ss 200008 200.00 [sists TS 05,193.83) a [ss ss 00s 3,135.00] . [ss 11 506.07 [5 11,906.07] . [$595,001.25 804,097.49 [5 309,096.24 " [seis tsss[s_ 1808s 23] [ss [Saat sos 1 50] r [S508 [8 so 567.13 [s 2998.6] [Total for state Revenues susan [9301 Bureau of Land Management Saran Sea 8 " [sss anc Ts 21200] [SSI7CARES Act a es es [Tota for Federal Revenues Sasson se bas ay . [ 06 Resoveree sas re a] [2409 Restle Disbuion ss ose se] = [Bit Sale of County Oomed seis sg to Ps [$a Sg tS [s__ 205393575 TeL0O |S FI waa TS Bova] | ESTAL REVENUES FORTHE COUNTY GENERALFUND - [oust Uncesticied Revenue Sse o57 6S 1S OSNOST [SSS TS STO [s 1.328.203) [s_1.591.570.53 |S 262.7502 a = [aa Vator Tax Se | [gan Toa otal ———————}- sts fs — pp oe S.A. and L Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 9 of 74 --- COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 3 ESTIMATE OF NEEDS FOR 2022-2023 r EXHIBIT A. Basis & Limit r _ _ Estimate Governing Board Excise Board a r" rs es [_“AdValoremTaxToal SSCS r [s . LS 8976.60 $8,976.60 r | 9104 Motor Vehicle Auto Stamps SS™~—~sSY Motor Vehicle Auto Stamps [90.00%] [s__3,469.81 | 3,469.81 [s_ 3,469.81 | 3,469.81 [so r [ss [ss r [S—222,683.92 [s222.683.92 S366, 622 35 TS 366,622.25 | r [ss r r a . [st rs | r [s—____-_ | —___] [__Total for Federal Revenues SS r [ooonfs is S| a es Fr | saeco TS 27 167.00 | r [90.00% $e | “TotsT Miscellaneous County General dd cr [creel To oa Rg] rs r cr S.A. and L Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 10 of 74 --- frees ‘This page intentionally left blank : : ° a . | i ! * | ; " { ; ; : | 7 | 7 ; S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 7 ; --- OCR page 11 of 74 --- COUNTY GENERAL COVERING THE PERIOD. 7/1/2021 TO 6/30/2022 Page S r ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT A (CURRENT AND ALL PRIOR YEARS TRE] r [cash Balance Reponed to Excise Board fone 30,2000 ST | Gash Fund Balance Transfered Ow SS |_Cash Fund Balance Transfened in dS eT] = x [Aa Valorem Tax Apporioned dS ss neon ts [Miscellaneous Revenue Schedule) dS naa 20s = [Cash Fund Balance Forward From Preceding Vest SSSSSCSSCSC*diS gorge SY [Por Expenditures Recovered dS OTAL RECEDTS dS snore nm ; limerest Paid Thereon CSS CS SY m [Reserve for intereston Warants OS SC Cd [Reserves FromScheduleS CdS oO Sid r PERC iS ts ™ (CURRENT AND ALLPRIORYEARS 2020-22 —«dzCSSCSPREDOD Tom [Warrants Outstanding June 30 of YearinCaption SSS 9616805 TTS 96,168.05] r [ROTAL dS 5.068.655.6505 238,246.57 S___5,306,882.17 | [Warrants Converted to Bonds orJudgements dS SSS SS ial [Warrants Cancelled ss L [Warrants Estopped byStatute SSS 08S ASS =i 45 | r r [Additions: ST [Deduetions: iS r [Net Balance 2021 Tax in Process ofColletion ST CSC~dYSSCS [ ‘Net Appropriations. ‘Warrants Approved by [ [i200 Fringe Benefits ss r r S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 12 of 74 --- Page 6 COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 1 EXHIBIT A a 7 JUNE, 30 2022 DEPARTMENTS OF GOVERNMENT Reserves Warrants Balance = |APPROPRIATED ACCOUNTS Saran Since Lapsed Issued Appropriations Appropriations : [ss [sO 319.02 [ss 319.02 [s__ 39.02 [sd S_ 319.02 | 7 | tio Fulltime salaries Ss a ee | ™ a EE CS | GES GE | SE EE Ce | | [Total for Sheriff IS SC SCC™C“‘CSC:CS i [ss Ce m [Ss Sa | [iio Futltimesalares IS SC dSCCS*S*”d = [so gs a Ee | a Ee | ™ | 10 Fulltime salanies OS SC SCS” [1310 Travel sss ™ [4130 LeaserRencals SS , . |_ 1110 Fulltime sataneg IS SSCS” : | 1310 Travel ss 7 [ss ss 564.00 | [S___ 5130.00 [SS 4,780.50 4 [Pepe: 1400, Coure Clerk [s—_ sr a Cs | [1310 Tvl id a a | [s__ 6,459.00 | 7 a Ce | EE [sss 7 [1130 Pan Time selaies st 3 js | 1310 Travel a a | a [s__ s Sid 7 S.A. and I, Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 13 of 74 --- r COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 7 | ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT A. r Lapsed Ne Supplemental ae ‘nount Warrants R Balance Baa Approved by Pp Adjustments rn Issued eserves Known to be Governing B County i __ Unencumbered Board cise Board [s_ ss 0.00000 S aoo0000 Ts Sid r [Ss 5,500.00 [$3,788.70 [Sos [sd S 5500.00 SB78RTO[S 730s __——-—id [S_____ 48528642 [$485,286.42 [5 48400900TS —- —S —a7.a2 | r [s_ 24.4522 [s" 2aaszga[s aaeszaz[s ts IS SS [ss sss [S_ 9.75104 [ST 59,751.04 [S37 31285 [$600 [ses S| r [s__verzsian s_sorasia2 |S 931,is9a8 |S _te07 |) T0955 | [ss anata [sara s TS r js__ fs 6.45900 [S$ 6asg00 [ss a Ee Ce CE [SS 180,573.14 TS 8OSTIGTS Sd [" [s_ = s226,460.67 [$224,807.84 [SS 652.83] [ss 2,900.00 [x= Ss 2,000.00 | [Ss te 5 [ssa [sa |S 506.55 (SS 263,867.22 TS 228,239.91 S 883991 TS 26,787.40] r [s_ ss 12800000 TS sa2isaz[s TS 73,786.58] [ss 15,000.00 [ST 9ssiga [Ss s.sa7s7 [$100.45 r [ss 13,000.00 [$6,729.32 [S232 ['§ 57.56] [Sato 0 [5 3.885.083 5] Ss A 5 r [ss 320,265.90 $319,082.32] $s 122158] [sss 6,459.00 Ts 6,459.00 § S| [ss 36,453.15 [$s 32,08292 [$s 3381.00 [$1,029.23 [sf 36,453.15 [$36,433.15 | [sos 564.00 gaa 9 ss 69.09 ia [sd S 363,740.05 [$358,079.15] _33u1.00 TS 2,319.90] : [ss 500,437.21 TF 469,249.02 ] [ss 968.88 | E [sj r a oe ee Sh i are a] a ENE r [ss 123,480.43 [$22,267.31 [ss 222.2 Ts” 121,104.73 Ts 123,340.66 [ss [ssa 75080 TS 7soso [ss | r [ss 2,280.00 [ST 884.19 |S 75.00 ['s320.81| [s_S 133,520.23 TS 131,902.50 TS 75.00 TS 1842. 93S 13018553 [SF 132,391.46 c S.A. and L. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 14 of 74 --- Page 8 COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 _ - ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT A J JUNE, 30 2022 DEPARTMENTS OF GOVERNMENT —— Warrants Balence |APPROPRIATED ACCOUNTS : Since Lapsed Original 30-2021 Issued Appropriations ~ [13i0Trevel sss 5.00000] ~ So ee . | 140 Ful time salaries SSS se . a | ee CS TET o PT es ea eee re | aN ERS CTT] Fowl tor Excise Equalaton Js Fh ar] , | 1110 Full die salaries SSS oS a] a Se | ee CS RET] . Ha PS a CTC RLU C7 iad Daa etad ei Mm Care - [oa for Eleeton Board SS rr [2005 Mainzoance & Operation TS Sono [ss sors a ota for tnformation Technology [S___s00 [$s sn fs se 7 SE Sel Caan |e NS NT TT] De es eee eee eS I pst capil Outages Se eS | Hosa for Emergency Management saa] saa saa fs ao] - [tio RuiLsnesehtes| Ss Es ay Fa ae ee | 7 RS a ee CT From for County Audi Budget fs] — at s Se 7 (Toe for County Cemetery $$ > |Dept: 4700, Free Fair Budget - [oval for Free Fale budget. 7 ~~ S.A. and I, Form 2631RO1 Entity; Ottawa County, 58 November 09, 2022 --- OCR page 15 of 74 --- COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 9 =a ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT A = Supplemental ne? Ameunt Warrants pay ee Approved by Adjustments ea Issued Lear) Known to be Governing County = Unencumbered Board Par [s_7.07525[ $s saisg1 TS _s32591]8 si |S G.84s.09 fs 3.1saai[s 303491 [s 1200s = [s_ "28,073.90 [$35,573.90 [$16,172.48 [8 _19ao1.2[s | [[email protected] [$= sss Ss [S_765.56)| $se6aa [ST saeae ts = [S___ 00 [saga Te TS 243974 [Ss 73,7492 [8 20 | . [s_____ 62,678.68 [5 99,000.00[s 9900008 «dS Sid m= [ss i zasaos aizessots- ss | ; [s_(2ao,sea.se[s seo [sss 239,012.14 [$___(605,340.92)[ $012,882.61 [$123,925.91 |S 88895670 [SSS al [SS 3.875 40 S26 06 TS S393] [SS 3,875.08 2.7606 TS dS 1899384] Zl [ss is2gio.e2 Ts s20s86oTs S251 93] [ss 2,000.00 Ts oasse fs Ts 9 46] ps [ss sooo fs e982 [soos 72| [s_ s 17,500.00 Ts 10,149.58 |S 1.52000 [s _ 5,830.42 - [ss 000.00 Ts ss 1,000.00] [ss 100.00 ['s 355.80 | ss 744.20 [1,025.00 [$1,025.00 | al [ss 174,510.62 [S164 15089 [S 1,620.00 TS 8,739.73 [SS 25,000.00 TS 18,898.75 TS 4415.00 TS 1,686.25] [s___ = TS 25,000.00 Ts 18,898.75 [54,415.00 S1,686.25 | id . [s____ 69,000.00 ts2g10.79Ts is2i931[S ST 8 a ES (SC | = [ss 5:00:00 [$86.90 [ss 231310] [ss 14,000.00 [9,778.27 |S 363.87 [33,857.26] L [ss 4,000.00 [5S 4,000.00} [S__ 15425115 |S 159,783.35 | P [ss 50,000-00 [SS TS150,000.00 SS [ss [Ss 150,000.00 [SS dS 15000000 /s dS CC ~*d r" [ses a0 a Ts 2805497 STS 3538590] L [s___=S aang TS 2808491 [SS 35,385.90] 55,202.13 |S $5,202.13 | [se S 900.00 SSS 005007 r eS ED Ee EXT) [ss 9,500.00 STOO TS 6S 866] r [SS 9500-00 TS 9S 136A TS «36 r S.A. and I, Form 2631ROI Entity: Ottawa County, 58 November 09, 2022 --- OCR page 16 of 74 --- Page 10 COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 7 EXHIBIT A 7 JUNE, 30 2022 DEPARTMENTS OF GOVERNMENT Reserves Warrants Balance — |APPROPRIATED ACCOUNTS 6-30-2021 Since Lapsed Issued ‘Appropriations Appropriations 7 [S348 [S75 STS |S BTAT] [SSS SC“‘$SNNC-C'CS 7 [YS 5458222 SSIS S __ BTU] = = DEPARTMENTS OF GOVERNMENT pact a pp Total Warrants Since Original ‘Supplemental ROPRIATED ACCOUNTS Sales || Reserve Teeued | L&psed Balance pe n aosmrens ' Tax ES |_1110Fulltimesalaries a ee | js fs ss s000000[s = [s_ [ss a [s_22342.75[$223a75]s is Is [S__ss93i |S" 39638 [$162.93] [Total forSherif-ST [S_166,491.89 | $116,537.37 |S 49,95452 [5 1,675,90473 |S ___—-_| - [s_1,675,904.73[ S| = S.A. and L Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 17 of 74 --- COUNTY GENERAL COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 11 ESTIMATE OF NEEDS FOR 2022-2023 r EXHIBIT A " Supplemental Ma Amount Warrants een eer Approved by Adjustments re a Issued od) Known to be Governing County bie Unencumbered Board Eo P [S______ O00 s $228,122.88 [S3,600,513.39[S _978,403.45 [8 _648,80604] a ES EE CE | r r L Excess/Shortfall Total Net Collections over | Sales tax Interest || Estimated ST from] Appropriations as r ‘Appropriations | Warrants Issued Lapsed Balance) timate Schedule] Schedule 4 Schedule 4 TRproved by 4 Excise Board |S 1,019,085.30['$ 1,005,293.64[s 2.79513 [S toseass[$ SIS YS 1526.08. r [s__s0.000.00['s_aiageg6[s = [s a,s000a [ss [S_ 266,821.43 ['s _190,838.28[$ 32,690.47 |S a3z9268[$ tS IS CdS | $_ 340,000.00 [$230,090.33 [$15,000.00] $ “9490967[$_ S| : [ss ss r [so SS 95088 | [S_1,675,904.73 | $_1,467,722.21 [S _ 50,485.60 [$_ 157,696.92 [$= TS SS _—1902,815.14] r $1,675,904.73 | $_1,467,722.21 | $50,485.60 |S 157,696.92 [SS SS 1,902,815.14 Needs by County r PURPOSE: Govenring Board || _ Excise Board [js | r r S.A. and I. Form 2631R01 Entity: Ottawa County, $8 November 09, 2022 --- OCR page 18 of 74 --- COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 13 ESTIMATE OF NEEDS FOR 2022-2023 P EXHBIT D ‘ a r [evesmens [TOTAL ASSETS r [S| m | ; CETONE 30,2000 STOTT] . ' CS 7 REVENUE ——— P| al [TOTAL REVENUE OSCSCSCSC*di REQUIREMENTS. - " [ tateestPeidon Warants iS [Reserve for intrest on Warns] r = cr S.A. and L Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 19 of 74 --- Page 14 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2021 TO 6/30/2022 = ESTIMATE OF NEEDS FOR 2022-2023 . EXHIBIT D —— [Setefulew: Revenge 9200 00) come [OT cco 7 Actually Amount Actually Over : sas 50] [S_____-_[s__ iano s __ a5 3800) [s—__-_[s___2923|s___ 2923] o [s______-_[s___7a582.63 [s__703.832.63| | [s___-_[s 66,806.86 ]s 466,806.86 [s-[s_iosa[s 110.54] [s____- |s 38251596 |s _300515,96| " [s______-_|s 166,993.06 [s 166,993.06] } [s—__-_[$ __50.988.21 [$250,984.21] [S____-_ Is __taarniasi [saa 71031 - Ss aes ee . [STs ae 573 TS 1063957 = | %406Recoveris IS SS Sid rr re [s—azssoes|s “Ts __iagen.77 fs 179 902.77] a a 7 [s___-[s 107480] s__10,774.0| . [sss [$300.00] $s [Ss sas [8 1s LST] . [ss ani ene [s 2601 00270] a | Se EE a Ce = SMEATON KTS ERIN [s___- [5 2681,062.76 |S —2,681,062.76] . i. 4 J S.A. and I, Form 2631R01 Entity: Otawa_ County, 58 November 09, 2022 7 --- OCR page 20 of 74 --- COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page IS ESTIMATE OF NEEDS FOR 2022-2023 r EXHIBIT D Schedule 4: Revenue ac OD fone SSS—S—id ee | ee |e _ Estimate Governing Board Excise Board r ss —_ es r [Ss +d [econ ss = [9212 OTC = Gasoline wx es [Ss - [sd [s2ieoTc Special dfs [ss " [ 9233 OTC.MotorVehisleCRF id nds? . [9241 OTC. Motor Veehile CRB 0009 § a a m= ss [Total for Federal Revenues Sd = [_2406Recoveriss YS es es [9409 Resale Distbuion oes n [9411 Sale of County Owned Asses Sires [fs [9415 Miscellaneous 00094 8] ——_ S.-J r [-Toal UnresviciedRevewe OS es es es a a ° gernaerateeg L a S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 21 of 74 --- COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 17 PF ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT D ‘ (CURRENT AND ALL PRIOR VEARS Pr [Cash Balance Reported wo Excise Board June 30,201 SSS] | Gash Fund Balance Tensfened Out dS asco [_Cash Fund Balance Transfemed i TS J r pase otReeewe a [Local Revenues Fr [9200 |state Revenues dS aso 3 | 9300)Federal Revenues dS tags. 73 sd : | 2400)biscetianeous Revenues dS as. fs | 9500[Special Assessments TS ds id P JAN Other Revenues Geheduled) dS OS [Cash Fund Balance Forward Fiom Preceding Year CdS COB T'S id Prior Expenditures Revovered Ss SY ma [POTAL RECETS dS 20a r lserest Paid Thereon 0s r [Reserve forinterestonWarants 0S r ec | | S| [ , Warrants Outstanding June 30 of YearinCaption SWS 156,028.09 [$156,028.09] t r [Warrants Converted to Bonds or Judgements Ss tg [Wamants Canceled IS St S15 1.96 | [Warrants Estopped by Statute SS pegs fs 188.95] r ‘Net Ay riations: ‘Warrants Approved by a a ea [ilooTowalSaiaies YS seora9.19 [Ss asoeasals YS 150,54665] [1200 Fringe Benefits SS ss r [4100 Total Machinary & Equipment, Capital Outlay || S____638,452.56|[8____454,aa6.82|[§_ = TS _—_—184,005.74] ie S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022. --- OCR page 22 of 74 --- Page 18 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 7 EXHBIT D 1 JUNE, 30 2022 DEPARTMENTS OF GOVERNMENT a Warrants Balance = PPROPRIATED ACCOUNTS 6-30-2021 Since Lapsed Issued Appropriations Appropriations 7 a CC [ss iY [ 200s Mainenance & Operation [8 osa[s_1909[s____-s_375.183.00] 7 [js - [es —-—*ds Sid [ss [s____wosa[s oats 71 a Cs [istotave id 1 ES Ce GRE Se ee 1 EC [[e3toTeevel sac Ps [$110 Capital Ouday ss ast 0] 7 [74130 LeaseMRentals Og "7 [_ 2005 Maintenance & Operation ISS so rrr : SS a [_ 2005 Mainenance & Operation Spa OOO TST [Se ST] 1 [$2546.00 [Sasa [$__ Ss fot tor CHRB 2081-3 sa sas 00 3290600 [8] or) 7 [_ Total Provision for Interest on Warrants YS 83 > : 7 S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 23 of 74 --- COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 19 ESTIMATE OF NEEDS FOR 2022-2023 r EXHIBIT D Lapsed r Supplemental bg a Warrants A Balance pet Approved by Adjustments eae Issued eserves Known to be Governing County proP Unencumbered Board Eo r [s_529,00000[$ s37.73017 Ts 485258348 - [saa] ia [s_ 31,587.69 [se aasai [Ss 164366968 =| S___ 12,058.45] [s_ 61,000.00 | s"68.97657 |S S75688e [Sd S_11.407.73 |s__ 507,000.00] sissaoa7[S a7ia736[S —-~—‘[S anit] |g 10.33200 [$s t1.90430 [$s 9,082.60[s _—-—‘|S 1,961.70] = [s_1.163.59[s 20,00000Ts ss LS _ 20,000.00 [S_ 83,608.15 [ST 85,233.39 [ST 69.33406 [SS 15,899.33| : r [s__s2sio00.00 Ts 532.6955 [TS aeiseesa[S «(8 _s0662.71] [s__22,s0000 [$23,456.10 [Ss 1409036 |S zaz0[s_ 9,241.54 » [stats [$200,000.00 [s 90.70550[s T'S 109,294.50] L [s__ 55,360.00 [$87 817.19 [72.471 46 | $815,345.73 | [S_____ 938,807.77 [$__1,250,595.30 |S 843,462.06 [S 110091 TS 406,032.33 | r [SO 87,515.36] S 156,102.92 [$83,757.53 [S_5.6B0.00 TS 66,665.39] [S87 51536 [S 156,102.92 [383,757.53 [8 5,680.00 S 66,665.39 | = [S_ 98,941.62 [sO 150,921.59 SS 150,921.59] r [s_—_"sasaren Ts tao 019 18 Ts Ts ino] [S$ 2,484.65] $66,747 2 TS 36,897.73 [STS 29,8898] . [S______(12,484.65)[ $66,747.62 [S36897.73 1S = «LS 29,849.89 | ' [s_ SSS SS SC‘CS*=S*”S ‘ Needs by County PURPOSE: Govenring Board || Excise Board r Ha Dee r S.A. and I, Form 2631R01 Entity: Ottawa County, $8 November 09, 2022 --- OCR page 24 of 74 --- HEALTH COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 21 r ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT E a | 7 | levestinens oh = [TOTAL ASSETS fs se] L [ss al . LA | = [REVENUE Ee eee) - ———————— a | “TOTALREVENUE Td : REQUIREMENTS: ee 7 ee ee [ interest Paid on Warrants [isd a - al [DEDUCTIONS EEE r | r r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘November 09, 2022 --- OCR page 25 of 74 --- Page 22 HEALTH COVERING THE PERIOD 7/1/2021 TO 6/30/2022 = ESTIMATE OF NEEDS FOR 2022-2023 EXHIBITE — — Actually Amount Actually Over = [AdValorem Taxes | "9002 rior Year CdS asec sss ao as | sa 998.06| c [sa rer [4.76705] Z ee es es [9nsHeath Fees id [s______-_|s 7930.66 |s 7930.46 HE Deo He [s___-_|s-___"7pamse Ts 7530.65 ° [____ ss | [s___ 2658s 2s | [S__1981S TS dS S~=«SSS |S —«95.95| . [Ss sass | [S13 tiosas Ts 1139545 - [Tot Unresvicwed Revenue SISOS ST sae [SST] | s2isore-Selestex Ss SY [ Restricted - Sates Tax teres. Sts ° [Total Miseotianeous Health| 3___ a0 [s [ss hte [ss] [TAaValoremTex ‘YS 280,050.68] : : : E = |! S.A. and L. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 26 of 74 --- HEALTH COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 23 7 ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT E Basis & Limit ™ Estimate Governing Board Excise Board | 9001 CunentTax id = a rs ee | m [ss [| 9115 Heath Fees non s ; GSS Do a a ™ [ss a m LS Sd [_ 9407 Reimbursements of Expenditures OSS Ls Sd " EE : [ss a ™ Ls Sd Sr r ; r S.A. and L Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022 --- OCR page 27 of 74 --- HEALTH COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 25 ESTIMATE OF NEEDS FOR 2022-2023 r EXHIBIT E CURRENT AND ALL PRIOR YEARS RET r [Cash Balance Reported to Excise Board June30,2021 SSS OS] l |_ Gash Fund Balance Transfered Out SS [_Cash Fund Balance Transfered by dS P ‘ [Ad Valorem Tax Apporioned dS 8600868 3 | [Miscellaneous Revenue Schedule) Sid 9 520.058 F [bash Fund Balance Forward From Preceding Year SSCS ioe r PPror Expenditures Recovered SS FOTALRECERTS Tid ets Sd f L linerest Paid Thereon CSS CdS CS =S«d r Reserve forinterestonWarants ST CY JReserves From Schedule 8 CS GSS CCS r a CS S| [Warrants Outstanding june 30 of YearinCaption SSS 1927S ITS 19.278.85] r POTAL dS 208,267.66 [40,652.88 S 248,960.50] [Warrants Converted to Bonds orJudgements SSS [Warrants Cancelled CS TC CdS CCS r 7 c r [Additions: Es [Deduetions: Pr [Net Balance 2021 Tax in Process of Collection SC c | ‘Net Ay rations ‘Warrants Approved by [ [1200 Fringe Benefits Ss ss r [4100 Total Machinary & Equipment, Capital Outlay [$387,160.78 ]]$ 68,564.24 |S ‘LS 339,474.97 | r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 28 of 74 --- Page 26 HEALTH COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 ‘ EXHIBIT E _ _ 7 JUNE, 30 2022 DEPARTMENTS OF GOVERNMENT Reserves ‘Warrants: Balance ~ |APPROPRIATED ACCOUNTS. 6-30-2021 Since Lapsed Issued Appropriations Appropriations ; [110 Fulltime saares YS namo] S yaaa |S e126] [310Tavet 7 a [S____wesae]S___Tiaiso |S 798.7] [savant ot pean ————— ofEgeates ———_—]s- —asaass ae as — arora} 7 Ss or 4 TS 295655 Sa |S asa TS ara] S.A. and L. Form 2631RO01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 29 of 74 --- HEALTH COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 27 m ESTIMATE OF NEEDS FOR 2022-2023 EXHIBIT E ‘Schedule 8: Report Of Prior Year's Expenditures = FISCAL YEAR ENDING JUNE 30, 2022 FISCAL YEAR 2022-2023 Lapsed Needs as ‘Net Amour ‘Supplemental a pie Warrants — Balance Estimated by lapis by Adjustments Appropriations Issued Known to be Governing pee = pode Unencumbered Board *eise Boa [Dept: 7001, Road Improvement District Is «dS 100,000.00 | $ 35,012.67 |S 64,648.98 | $ 338.35|[s__125,000.00[$ 155,000.00 3 45,000.00)[ $ 20,000.00 [$10,518.61 [S$ 2,426.83 | 7,054.56|[$ 20,000.00] $ 20,000.00 = $ 3,696.22 | $ 118,696.22 $s 23,488.53$ _1,035.55|]$ 125,000.00 |S 125,000.00 $ 30,000.00 | $ 387,160.78 | $ 68,56424[S «LS _318,596.54|1S 400,000.00|§ 339,474.97 S____18,096.22[$ 625,857.00] $208,267.66 |S 90,564.34 |S 327,025.00 || 670,000.00 |S 639,474.97 sa) $ 18,696.22 [S 625,857.00 [S$ 208,267.66[S 90,564.34] $ 327,025.00] S 670,000.00 |S 639,474.97 ; ‘SUBJECT TO WARRANT ISSUE [ss SS SSC CdS CCS id "= TOTAL UNRESTRICTED EXPENSES FOR THE HEALTH FUND $ 18,696.22 [$ 625,857.00 |S 208,267.66 [S ___90,564.34[$ 327,025.00] S 670,000.00 8 639,474.97 ESTIMATE OF NEEDS FOR THE 2022-2023 FISCAL YEAR Estimate of ‘Approved by m Needs by County IPURPOSE: Govenring Board || __Excise Board Total of Unrestricted Expenses for the Health, Schedule & $665,518.17 [$634,993.14 Total of Restricted Sales Tax Expenses for the Health, Schedule 8A | || oo] Pro rata share of County Assessor's Budget as determined by County Excise Board s 4481.83 |S CREE) GRAND TOTAL - Health Fund S___670,000.00 || $__ 639,474.97 “al rm = u r S.A. and L. Form 2631RO1 Entity: Ottawa County, $8 November 09, 2022 --- OCR page 30 of 74 --- tal | TOTAL OF SPECIAL REVENUE FUNDS COVERING THE PERIOD JULY 1, 2021 TO JUNE 30, 2022 Page 29 m ESTIMATE OF NEEDS FOR 2022-2023 ! EXHIBIT "I" TOTALS r a {ss OTAL ASSETS TT rr] p [Reserve for Interest on Warrants ia Fr [s r [s__2,sa7aa ls | U | rere r [Ad Valorem Tax Apportioned To YearIn Caption IS SS [Sources of Revenue dd [9100 [Local Revenues Cd i [9200|State Revenues CSC~*d F [9500|Special Assessments CCC~*d r [9600]Other Revenues COS CdS [ss es ee a r [ss [ss [OTAL RECEIPTS CCS m L [so r [ss a ee Pr js | js [ERIC Ss c ‘Net Appropriations Warrants ‘Approved by Pete Oe | ee ee js [sl [ss r ' js ss JAN Other Expenses r S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 t P --- OCR page 31 of 74 --- o Page 30 COUNTY BRIDGE AND ROAD IMPROVEMENT COVERING THE PERIOD 7/1/2021 TO 6/30/2022 = ESTIMATE OF NEEDS FOR 2022-2023 11103, COUNTY BRIDGE AND ROAD IMPROVEMENT . so : [Warrants Outstanding SY [Reserve for Interest on Warrants = SS AN CAST BALAN . [Cash Belonce Reported to Excise Board Tune 30, 2021 TS YS STI T : [ss [ss ° es a [po0dfinterest, Mortgage Tax Os or P200| Local Revenues Os ss . [2200|State Revenues [ss a ee P00 Special Assessmens Oh h F [sot] Other Revenues Se fe Oter Non-Tax Revenues [st ° Pass Fak and Seles Tax ntrest [s— es POTAL RECEIPTS re [ss . [s___ 17,283.62 [era ieee res © CaS TS ors fs ee Rete for Interest on Wanang 3 = [ss AQTAL LIABILITES AND RESERVE. es | a a a [ss - ‘Net Appropriations Warrants ‘Approved b a | - [sss CS |S Ee CE EC ES Ce [CS Cee Cee [S17 285.52 S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022 7 5 --- OCR page 32 of 74 --- = ASSESSOR REVOLVING FEE COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 31 + ESTIMATE OF NEEDS FOR 2022-2023 1-1204 - - ASSESSOR REVOLVING FEE. BES —— " pevestments os 7 |S rT [Reserve for Interest on Warrants [Reserves From Schedule 3 esses es a [TOTAL LIABILTIIES AND RESERVES [TOTAL LIABILITIES, RESERVES AND CASHFUND BALANCE S15 23008] " [CURRENT AND ALL PRIOR YEARS dP PRED‘ a [ss a Sd a a es | [9100[Local Revenues TOCSY " |9200]State Revenues CdS |9300[Federal Revenues CdS CC CdS CCC@Y es nm [9500|Special Assessments TS CdS [9600|Other Revenues CdS CCS | Se [so = a as ee rs |S_ 1,606.00 fs = [s18.s32.16 [ss [s_ 5,302.08 [ss [ss [ss ua fs a | ee es - [ss P [ss [DER IC TT SS [S____13,230.08[S | r 7 ‘Net Appropriations ‘Warrants: ‘Approved by r a | | [sos Ss a (| | [$5,302.08 [ST [£100 Total Machinary & Equipment, Capital Outlay[$_ = SSS Si” JAM Other Expenses SSS oS [S___ 5,302.08 | r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 t --- OCR page 33 of 74 --- e Page 32 COUNTY CLERK LIEN FEE COVERING THE PERIOD 7/1/2021 TO 6/30/2022 - ESTIMATE OF NEEDS FOR 2022-2023 a 1.1208 ee ASSETS: . 7 [Warrants Outstanding 0 [Reserve for Intereston Warrants [Reserves From Schedule 3 . (TOTAL LIABILITIES AND RESERVES S| [CURRENT AND ACL PROK YEARS L | Cash Fund Balance Transferred Qut SC OSC CS [_Cash Fund Balance TransfemedIn dS CdS id . [Ad Valorem Tax Apportioned To YearInCaption SC SC Cid ‘SLI EESEESENENENERO ESSE Gt | SOE [2000fimerest, Mortgage Tax dS SY [9100|Local Revenues dS STS 8 5035 | . [9200]State Revenues CdS CdS Sd |9300|Federal Revenues SS [2400|Miscellaneous Revenues dS SY [9500|Special Assessments SS ° |2600]Other Revenues TS [2700|School Revenues SS [All Other Non-Tax Revenues TSS . [Sales Tax and Sales Tax tnterest TSS [Cash Fund Balance Forward From Preceding Year CSS YS] [Prior Expenditures Recovered YS FOTAL RECEIPTS SYS SS © ferest Paid Thereon SS = [Reserve for Warrants Outstanding “0 [Reserve for Interest on Warrants Sg Reserves From Schedule 8S eg . HOTAL LIABILITES AND RESERVE SY a ek [CASH BALANCE FORWARD TO NEXT YEAR S'S 39.00] = Net Appropriations Warrants Approved by “ [3200 Fringe Benefits sg BS [1300 Travel Related Ts tessa sss roe] 000 Total Maintenance & Operations $1027.60 8 -_ [$s 10 aae-00] 7 Ht00 Total Machinary & Equipment, Capital Outlay] $= SS [a Other Expenses TS OS oo [TOTAL EXPENDITURES 2021-22 FISCAL YEAR|S __32,90863 8 S808} 77] ‘S.A. and I. Form 2631RO1 Entity: Ottawa County, 8 _ ~ November 09, 2022 7 --- OCR page 34 of 74 --- COUNTY CLERK RECORDS MANAGEMENT AND PRESERVATION COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 33, - ESTIMATE OF NEEDS FOR 2022-2023 r 11209 _ COUNTY CLERK RECORDS MANAGEMENT AND PRESERVATION r Pavestents eS re [—_ | is cal ae ; 0 BILITIES, RESERVES AND CASH FUND BALANC $ 161,994.41 P [Cash Balance Reported to Excise Board June 30, 2031 SYS *T08 STBTTY m |_ Cash Fund Balance Transferred Out TS Sd L |_Cash Fund Balance Transferred In S dS [s_ - es es [ss = [9100 [Local Revenues |9200|State Revenues SS . [s_ ss [s—_ ]9500|Special Assessments "0 Ss (Bf ier Reverses gs [ss a es r [Cash Fund Balance Forward From Preceding Year SOS id PPrior Expenditures Recovered 0S FPOTAL RECEIPTS 0676659 [TOTAL RECEIPTS AND BALANCE dS 73,095.76 [5 [s [interest Paid Thereon ss [s——_——] r [sd L [Reserve for Warrants Outstanding 0 es [ss r [ss 1 ET [$159,589.42 [$d r ‘Net Appropriations Warrants ‘Approved by cr [S$ 24,175.03 SSS 2175.05 | [sss ea | r ES a a | Ce [S__11,101.35] r ‘S.A. and I. Form 2631ROI Entity: Ottawa County, 58 November 09, 2022 --- OCR page 35 of 74 --- = Page 34 EMERGENCY MANAGEMENT COVERING THE PERIOD 7/1/2021 TO 6/30/2022 - ESTIMATE OF NEEDS FOR 2022-2023 11212, EMERGENCY. MANAGEMENT ag Sa] e [so - —TTT_E_EEE——— [s_ [ss [s____-_| - sd a EL ° a [SS sd 7 a ee [2100[Local Revenues OSS ® [2200]State Revenues dS [2300] Federal Revenues Sd [2400] Miscellaneous Revenues TSF |2500|Special Assessments dS [st . a [2700|School Revenues Ss | a - fates Tax and Sales Tax Interest oh [fash Fund Balance Forward From Preveding Year a | | = [s_ [so a [ss . [s__-| Cs [Reserve for Interest on Warrants [s_ | = [ss [ss [RERICTT SS [st sS_ =i 7 poctedule &: Emergency ‘Management Fund Summary of expenses _ July 1,2022 Issued County Excise = [1100 Total Salaries OS a j [sss 300 Travel Related Ss hs 2000 Total Maintenance & Operations S__a1 501.75 80.6 SJ 7 A100 Total Machinary& Equipment, Cepfal Guay ST =f § 3 |All Other Expenses 7 a [$___ SOLS SYS] S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 36 of 74 --- LOCAL EMERGENCY PLANNING COMMITTEE COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 35 al ESTIMATE OF NEEDS FOR 2022-2023 1-1218 5 LOCAL EMERGENCY PLANNING COMMITTEE r [Cash Balances pevesiments ee A ia [Warrants Outstanding ssos— | Reserve for Interest on Warrants [s-| ) TOTAL LIABILITIES AND RESERVES P [CURRENT AND ALL PRIOR YEARS dE] [Cash Balance Repored t Exeie Board Tune 30,207) 7S = [ss ; | [ss pm [Ad Valorem Tax Apportoned To Year Ta Caption} | [Sourees ofReverse > [So00fimerest, Mongage Tex si00|Lecal Revenues — = vd [9200|State Revenues OCOSCSdYSS dC ~*d >400)etscellaneous Revenaes ee | r [9600]OtherRevenues SSCS = YS a —_s— rs r a a es es [ss r es | a as [" [sd a rs es | r [Sos JDERICTT SdSY [S____ 5,820.00 [$d r ‘Net Appropriations Warrants Approved by j SS r [ss Sa (| [Ss] r ss L JAN Other Expenses 0S SS oS [TOTAL EXPENDITURES 2071-20 FISCAL YEARS S00 [$s "5. -_—s mo] id $.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 37 of 74 --- Page 36 RESALE PROPERTY COVERING THE PERIOD 7/1/2021 TO 6/30/2022 = ESTIMATE OF NEEDS FOR 2022-2023 RESALS PROFERT 1-1220 . aS 6 [TOTAL ASSETS [Reserve for interest on Warrants dd Reserves From Schedule 3 - - [Cash Balance Reported to Excise Board June 30,002) SST . [ “Cash Fund Balance Transferred Out dS sorne ts [Cash Fund Balance Transfenred In J - [Ad Valorem Tax Apportoned To Year ta Caplio Boureeg of Revenue op [9100]Local Revenues S239. SSB | = [9200|State Revenues ST [9200)Federal Revenues S's [2500[Sperial Assessmenss se Sa | : [2800]Omher Revenues [2700[Schoo! Revenues Ts [a Otier Non-Tax Revenues - Beles Tax and Sales Tax Interest 7 [Cash Fund Balance Forward From Preceding Year os J [Por Expenditures Recovered Ss OTAL RECEIPTS 0 ors ts . lnterest Paid Thereon Oe FOzAL DISBURSEMENTS ore rr > [CASH BALANCE TUNE 30,2098 5095 Reserve for Warrans Oustanding a eS Reserve for Interest on Warrants = Reseres From Schedule 82 ROTAL LIABILITES AND RESERVE 5 ore , A a ‘Net Appropriations farrants “Approved by " CO aS nS Ke (| ee ee [300 Tavel Relted S00 sess 3 ase] Brod Total Maintenance & Operations "S61 4,g81.47 | $183,847.20 3s —"as.o3477| 7 100 Total Machinary & Equipment, Capial Gully $33,298.67 8. _[s 3} "ss oon | ab Other Expenses SS ss TOTAL EXPENDITURES 2071-27 FISCAL YEAR| S S505]. 798 307050018 3 sana) S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘November 09, 2022 7 --- OCR page 38 of 74 --- = REWARD FUND COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 37 a ESTIMATE OF NEEDS FOR 2022-2023 11221 _ _ REWARD FUND. 7 pose << | Pnvestments SS . [Warrants Outstanding Reserve forntereston Warrants [Reserves From Schedule 3S na [TOTAL LIABILITIES ANDRESERVES SS (TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE YS 1.0070 7 [Schedule 5: Reward Fund Fund Balance Sheet of Current and All Pror Yeas (CURRENT AND ALLPRIORYEARS SSCS 202-0‘ PRESZ00T + 3 [ss [SS [Ss 1377.96 [$s 7 es Ce a | Hii De [100[Local Revenues " [9200|State Revenues a ee [ss 5 [9500|Special Assessments T'S SY ]9600[Other Revenues ST [so S| rs " io a es [ss [Ss 24 fs | ” [TOTALRECEIPTS AND BALANCE S720 |Warrants of VearinCaption SST [ss 7 [ss [sd a [ss 2 [ss [ss {i | [sd = Net Aj riations ‘Warrants Approved by . [1100 Total Salaries SS [1200 Fringe Benefits Ss ss a ES | | | = [2000Total Maintenance & Operations [STAT 20S ST A SE JAN Other Expenses | SS SS Ss 7 S.A. and L Form 2631R01! Entity: Ottawa County, 58 November 09, 2022 --- OCR page 39 of 74 --- . Page 38 SHERIFF COMMISSARY COVERING THE PERIOD 7/1/2021 TO 6/30/2022 e ESTIMATE OF NEEDS FOR 2022-2023 SHERIFF COMMISSARY 1.1223 — EERE URE EE RRERR ERE . [ses fOTAL ASSETS . . [is is ee . Ce ee es [2100[Locet Revenues ' a [9300|Federal Revenues [s—__ is [2500|Speviat Assesimenss 0 hh ‘ [2600] Other Revenues Th [2700|Schoot Revenues Ts I [sS—__— fs ; [ss [S—__ fs [ss [s——-] . [s__3,783.74 [ss . [s—-_] [s-_] [Ss . [s__-] [s—___-_} cE SC [sa esos . ‘Net Appropriations Warrants ‘Approved by ; pe Gal Sates eee 1200 Binge Benefig sg F300 Travel Related Sg 5 ; SC a | L S.A. and L. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 40 of 74 --- SHERIFF FORFEITURE COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 39 tial ESTIMATE OF NEEDS FOR 2022-2023 | 11225 SHERIFF FORFEITURE r $8 Pvestmens ee L ——— [S_ 2,733.60] r 2 a [J] = s—_ r r CORRENT AND ALL PRIORVEARS REO r | Cash Fund Balance Transferred Out L es P [Ad Valorem Tax Apporiioned To Vear inCaption dS SY r [Sources of Revenue [P100}tocal Revenues [s200|state Revenues YS r [2300]Federal Revenues a er [9500|Spestal Assessments SS r [9600] Other Revenues ss es es a r [Cash Fund Balance Forward From Preceding Vea SSSSSC—*dS S'S : Prior Expenditures Recovered SCSCSCSC~diS Sd [s___orsafs— [s____ 350.00] r [Warrants of Yearin Caption SCCidS CdS 18 | [ss [Ss —_] r [CASH BALANCE JUNE30,2022,——~—C—*‘“‘“S*S*S*S*S*S*™*™C™~C~C~CSY BALANCE JUNE 30, 2022 [S_2,733.60[$ «SJ i" [Resetve for Warrants Outstanding SS [ss - [Reserves From Schedule 8 dS] r TOTAL LIABILITES ANDRESERVE SSCS is DERCTT Ss let Appropriations. ‘Warrants: Approved a a C ER SE CE SA fs r a SE a Ss es r S.A. and I. Form 2631R01 Entity: Ottawa. County, 58 November 09, 2022 --- OCR page 41 of 74 --- Page 40 SHERIFF SERVICE FEE COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 7 161226 ee _ _ __SHERIFF SERVICE FEE oh 7 [s [TOTAL ASSETS 7 [ss 7 4 [SS 153,37632 | | Cash Fund Balance TransfemedQut_ CdS CC CS a | [Ss : es [ss [9100}Lecal Revenues SSCS [9200|State Revenues C—O 7 [9300]Federal Revenues COCOCSCSS Sd |9500|Special Assessments [2600|Other Revenues CSS [ss 7 [2700[School Revenues SS a [ss 7 [so Prior Expenditures Recovered SS [s_- ) interest Paid Thereon Sg 7 [ss a [ss 7 [ss EEC SS 7 ‘Net Appropriations Warrants ‘Approved by feats er] eer | me | eee | a [ss ss 7 [100 Total Machinary & Equipment, Capial Outayf$— = SS [SF FT [S$ 50,76253 | : S.A. and I. Form 2631RO01 Entity: Otawa County, 58. November 09, 2022 7 --- OCR page 42 of 74 --- = TREASURER MORTGAGE CERTIFICATION COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 41 = ESTIMATE OF NEEDS FOR 2022-2023 11230 _ TREASURER MORTGAGE CERTIFICATION - . a aa Hnvestmen se . CS SS $d [$3,737.13] [ss —a) A " |CORRENT AND ALL PRIOR YEARS PRETO J m Ss a | = [Ad Valorem Tax Apportioned To VearInCapton dS SY Sources ofRevemue [9100[Local Revenues SC 7 |9200|State Revenues Ss [9300] Federal Revenues SS [9400] Miscellaneous Revenues m= [ss [9600]Other Revenues (ce KS Lo es = a a [ss = [ss n [S373 [Sd [sS_ 200.00][s [Reserve for Interest on Warrants SS al [Reserves From Schedule § SS [s_ | (EE (KS | [$3,537.13 [S| r ‘Net Appropriations ‘Warrants Approved b r a ES | | L a a [ss px _-—*PB00TTotaT Maintenance & Operations $__ 551s [S_aza7 81s] s—128777| Ss ss 7 L SE [sd r S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022, --- OCR page 43 of 74 --- - Page 42 COUNTY DONATIONS COVERING THE PERIOD 7/1/2021 TO 6/30/2022 e ESTIMATE OF NEEDS FOR 2022-2023 COUNTY DONATIONS 11235 _ . es aed : . [CORRENTAND ALL ROR YEARS ET . es [s—__ . a es es [P100|Locat Revenues . [9200|state Revenues YS [s—____-_ fs—— Cs a CE : [2600| Other Revenues [ss Ce - EE [sarees a [s__sza7a8 [s__—] . [s 32,102.42] eS s {CASH BALANCE JUNE 30,2022 ais aa [sass [ss - eserves From Schedule 8 ort [s_ | aE - Net Appropriations Warrants ‘Approved by - CC [200 Fringe Benefits ss 5 300 Travel Related SS 700 Total Maintenance & Operations [$f 3 7 ES ee FS Ee [$ —sarenir [S16 99039] [S 154,164.17] [Ss 3,029.60 | S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 44 of 74 --- CONVENIENCE CENTER COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 43 ESTIMATE OF NEEDS FOR 2022-2023 r 1-1401 _ - CONVENIENCE CENTER r Povestmen se r [Warrants Outstanding [Reserve for Intereston Warrants P r [CURRENT AND ALL PRIORYEARS Td REO] r [ss [is |Ad Valorem Tax Apportioned To VearInCaption———SSSSCSCSC~SdYS SY r [Sources of Revenue Td [9100 [Local Revenues CSC~dUCSCCCOC CdS TC ~=*d r [y200|State Revenues SS es es es r [9s00]Otber Revenues |9700|School Revenues TS Sd JAI Other Non-Tax Revenues TS dS [Sales Tax and Sales Tax Interest CCS SY c [Cash Fund Balance Forward From Preceding Yeas SSCS Sid Cd [Ss js = F c es r [S___8sa627 5d l a [sos [Reserves From Schedule§ CS SC CS@Y r [TOTALLIABILITES ANDRESERVE TS 2000001 SC Cid [DEFOE SS i | r ‘Net Appropriations Warrants Approved by r [Wo0ToalSwares YS SS [ss [ss [1300 Travel Related TS Ss F r a ES | JAW Other Expenses SE SS BS ia S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 45 of 74 --- Page 44 BUREAU OF INDIAN AFFAIRS ASSIGNED BY COUNTY COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 7 11456 BUREAU OF INDIAN AFFAIRS ASSIGNED BY COUNTY ASSETS: eee eee —__] ro = [s_ | [ss [S| (lOTAL LIABILITIES ANDRESERVES SS SCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSC“‘CNSCNCNNY LIABILITIES AND RESERVES i [sd 7 [CASH FUND BALANCE JUNE 30,2022 TS 7 CURRENT AND ALL PRIOR YEARS PRET = a | [Cash Fund Balance Transferred Ip 7S [sd a " es [P00dfinterest, Mongage Tax SE |2100[Local Revenues OTs [ss - |2200|State Revenues OS [ss [9300[Federal Revenues [2epof Miscellaneous Revenues Tg ig [2500|Special Assessments OT [so s [9600] Other Revenues [ss [2700|Schoo! Revenues os [sO | fe Other Non Tax Revenues Ss . [ss Se | a | HOTAL RECEIPTS AND BALANCE rs] [ss 7 [ss iS St Page SUREMENTS [S$ LSaS 59S 7 a [ss rs | | [ss ! a [js EE) | 7 ‘Net Appropriations Warrants ‘Approved by [Se [ss 7 #300 Fringe Benefis ss J a [ss [$1545.59 [8s [$1545.39] 4 a [Al Other Expenses tS ee EE S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 46 of 74 --- r | SPECIAL REVENUE ASSIGNED BY COUNTY COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 45 i ESTIMATE OF NEEDS FOR 2022-2023 1-1507 . _ SPECIAL REVENUE ASSIGNED BY COUNTY. wad 7” [ss | [Reserve for Inereston Warrants a " [Cash Balance Reported to Excise Board Tune 32021 SSS oa | Opening Balance fromPriorYear CSC CdS TC ~*d | Cash Fund Balance Transferred Out SC CdS ~CSY |_ Cash Fund Balance TransferredIn IS Sd [Adjusted Cash Balance TS Sd ™ [Ad Valorem Tax Apportioned To YearIn Caption CdS Sid [Sources ofReverue Sd [9000ftmterest, Mortgage Tax CdS TT SY [9100]Local Revenues ST ™ [9200|StateRevenues SS . |9300|Federal Revenues dS 2,000,000.00 [8 | TF) [9500|Special Assessments SOS r [9600|Other Revenues SY : |[9700[School Revenues SS a a [so Ss ; a ee | js r is =| [js GS [St Pr | L Ss [Reserve forlntereston Warrants js r [sn [so Se [S_ es2798 sd c ‘Net Appropriations Warrants ‘Approved by : [ae | See | [1100Total Salaries SS [ [1200 Fringe Benefits SSS a ES | r J4100 Total Machinary & Equipment, Capital Outleyf$ SS SS Sid EE i ‘S.A. and I. Form 2631RO! Entity: Ottawa County, 58 November 09, 2022 --- OCR page 47 of 74 --- ™ Page 46 AMERICAN RESCUE PLAN ACT 2021 COVERING THE PERIOD 7/1/2021 TO 6/30/2022 a ESTIMATE OF NEEDS FOR 2022-2023 11566 AMERICAN RESCUE PLAN ACT 2021 a [Cash Balances Sd ———_| (TOTAL ASSETS TOT] [s |S era - [CASH FUND BALANCE JUNE 30, 2022 [Cesh Balance Reported to Excise Board June 30, 3021 dS YS 3,003,02750 . | Cash Fund Balance Transferred Out SCS [se a [s c Ss Rourees of Revenue op |2100fLocal Revenues VY [ss = [2200|State Revenues OS [ss [9300[Federal Revenues J [ss a . [9600 fother Revenues OS I [2700| Schoo! Revenues re - a ce CS es [OTAL RECEIPTS TS oe] [ss = [st [so a [s__ | - | es Reserve for interest on Warrants [st a [s_ 22,890.00 [§ : [s_ Pe CE FORGE EETO EE [ss sd 9 escue ‘Net Appropriations Warrants ‘Approved b: EE ped ings Benes ss J [sss 1 [sss so [Ss Ss S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 48 of 74 --- TOTAL OF SALES TAX REVENUE FUNDS COVERING THE PERIOD JULY 1, 2021 TO JUNE 30, 2022 Page 47 P ESTIMATE OF NEEDS FOR 2022-2023 r EXHIBIT "IST" TOTALS r [vestments ee js (ROTAL ASSETS TT ere] r [js [3 373,164.54] P [CASH FUND BALANCE JUNE 30, 2022S 8209, 000.10] al (CURRENT AND ALL PRIOR YEARS dS «dS + [s_ = S3,960,469.91 | r | Cash Fund Balance Transferred Out IS SCS L [ss F [ss ee : [9000]Interest, Mortgage Tax [9100}Local Revenues Cd [ss 4 |9200[State Revenues js |9300[Federal Revenues C~*d [9500|Special Assessments COSC CdS CCS r |9600[Other Revenues id Ei |700|School Revenues CdS CC CdS CC C*d a ee r [ss [Prior Expenditures Recovered TS CSC C*d [se r [interest Paid Thereon CdS SCS r [ss a r [ss [DEPICT SS Pr ‘Net Appropriations ‘Warrants ‘Approved by a ES c [1200 Fringe Benefits SS CE r [ss ss JAW Other Expenses SS Ss ip S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘November 09, 2022 --- OCR page 49 of 74 --- Page 48 COURTHOUSE IMPROVEMENT SALES TAX COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 7 LST-1305 COURTHOUSE IMPROVEMENT SALES TAX 9 sire 7 | [investments js 7 [CASH FUND BALANCE JONE 30, 3002 7 CURRENT AND ALL PRIOR YEARS REO] | Opening Balance fromPrior Year SCS Balance from Prior Year [S_ 978,250.67 | 978,250.67 [$978,250.67 | 978,250.67 7 [ss [_ Gash Fund Balance Transfemed fa SY [ba Valorem Tax Apportioned To Veat In Caption SSF 7 owes of Revenue op } |2000finteres, Mortgage Tax Sa [ss [2100[Local Revenues es | |2200|State Revenues [ss [st [9800 [Miseellancous Revenues Tp [ss Pesce Special Assessments Oh " [2600{Other Revenues es ; es eo et Now Tax Revenues 7 a es [ss [$12,233.54 1 [$441,210.12 [$12,233.54 | Hierest Paid Thereon [ss oa pO URSEMEN TS rr re [$__1,337,956.19 | eset for Warns Oustnding 0 es [s_ 7 ROTAL IABILITES AND RESERVE i js pec a TD) [S_1.208,233.01 [S| 7 ‘Net Appropriations Warrants ‘Approved by 4 [00 Tour Salaries SS Cs ! [1200 Fringe Benefits a [300 Travel Related Ts 3 es es [$127,386.55 5 121631687 | | ES EC Al Other Expenses ts a eS S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 ~ ‘November 09, 2022 7 --- OCR page 50 of 74 --- ROAD AND BRIDGES SALES TAX COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 49 Ff ern ESTIMATE OF NEEDS FOR 2022-2023 . ROAD AND BRIDGES SALES TAX. ‘ r NOTAL ASSES LIABILITIES AND RESEI SS r [ss | r r es Ss r [ss JSources of Revenue TT |2100|Local Revenues YS OS r [9200|State Revenues YS SY [ss |2500|Spectal Assessments COS ST CS” |2600]Other Revenues SY r |2700|School Revenues SS JAM Other Non-Tax Revenues YS r [Cash Fund Balance Forward From Preceding Year dS CB, [Prior Expenditures Recovered SCC Od SY [js - r [interest Paid hereon C*dYdSC CC OCS r [ss es [ss r [ss [ERIC dS r ‘Net Appropriations ‘Warrants Approved b a ES | c Sa | [1300 Travel Related SSS ts r es [ss Wall Other Expenses SSS r S.A. and I, Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 51 of 74 --- Page 50 RURAL FIRE SALES TAX COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ESTIMATE OF NEEDS FOR 2022-2023 RURAUFIRE SALES TAK 7 LST-1321 Se 7 [TOTAL ASSETS dS [s_ 7 7 . [ss a c a a |2100|Local Revenues VOY 7 [9200]State Revenues dS] [s [so [s_ 654.33 [2500[Special Assessments Ts ts ™ [9600] Other Revenues Os oh [2700 [School Revenues os rs : [s_ 3,012.00 [ss [Prior Expenditures Recovered [ss FOTAL RECEIPTS FS our a = 7 fisterest Paid Thereon [S___ 3,012.00] 7 [s_ a [Reserves From Schedule From Schedule § [S 68,844.48 | 68,844.48 [sd 7 OTAL LIABILITES ANDRESERVE ———] ——s0 20 03] [ss 2 [ss : Net Appropriations ‘Approved by a ee 7 PO Teal Series Se See H200 Fringe Benefie ss sh [Ss ss [$443,312.05 | 7 | pore eepenses SS os [$218,272.25 | S.A. and L. Form 2631ROL Entity: Ottawa County, 58 ~ ‘November 09, 2022 al --- OCR page 52 of 74 --- TOTAL OF EXPENDABLE TRUST FUNDS COVERING THE PERIOD JULY 1, 2021 TO JUNE 30, 2022 Page 51 rr ESTIMATE OF NEEDS FOR 2022-2023 Pr EXHIBIT "M" TOTALS r 35 aT [vestments ee [TOTAL ASSETS r S| roe] r Oe ——————— r [CURRENT AND ALL PRIOR YEARS dS PRESDOT J ——or) r [fs | r [is | [Sources ofRevenue [2100]Local Revenues r [9200|State Revenues = [9500]Special Assessments [° —[ssoofotierRevenygs ig EE [fs - fs es —T| r [is _| [fs ts [s——__] r fnterest Paid hereon SS | r [CASH BALANCE JUNE30,2022,———OO—“SsSOSC;C;~C;C;*~*™~™~C~™Y BALANCE JUNE 30, 2022 [$529,661.97 7S «132.00 Ed as Es r [Ss perc. r : let Appropriations ‘arrants ‘Approved by t a (a | [ss [S__o.aeais 3 _—__—-_ |S sea,61635 | r es [iJ Ss Pr S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022 7 --- OCR page 53 of 74 --- Page 52 COURT CLERK REVOLVING COVERING THE PERIOD 7/1/2021 TO 6/30/2022 7 wer0t ESTIMATE OF NEEDS FOR 2022-2023 COURT CLERK REVOLVING SSS [ss 1 ee eg—— @£@—@ <<< | [Warrants Outstanding COCCI Cd [Reserve for Interest on Warrants dS [Reserves From Schedule 0S : [TOTAL LIABILITIES AND RESERVES SCS SSSSCS~*Sd 7 | Cr 1 (CURRENT AND ALL PRIOR YEARS dC TE PREDO—| 7 | Cash Fund Balance Transferred Out iS SY |_Cash Fund Balance Transfered In ISS [Adjusted Cash Balance TS aS STS] | . a a [2100fLoeal Revenues Ts sri] [2200{State Revenues op . 19200 [Federel Revenues TS [pi0o [Miscellaneous Revenues TS [2500 |Special Assessments [ss 7 [2600] Other Revenues [ss [ss Es | = ates Tax and Soles Tax Interest TT : [S| a BOTAL RECEIPTS > 7 a 7 TO) Reserve for Warrans Ouistanding Reserve for Interest on Warrants [ss es es ) a | PRS OS RNGE FORWARD TO RES FES | 7 let Appropriations Warrants ‘Approved by 1 [1200 Fringe Benefits a es ee [$320,072 S390, 177.12 $s | [s_22,801.7 Sao ss ES oo [$___ 2 ES dS S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘November 09, 2022 7 --- OCR page 54 of 74 --- = CHILD ABUSE (MULTIDISCIPLINARY) PREVENTION COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 53 co) ESTIMATE OF NEEDS FOR 2022-2023 M-7202 = _ _ CHILD ABUSE (MULTIDISCIPLINARY) PREVENTION Ted ed SSS | " [Cash Balances sees rea] [nvestments ee [TOTAL ASSETS BILITIES AND RESERV = | SJ [Reserve for Interest on Warrants J s——_— 7” [sd 7 5 [iS fs rs ee [so m Cs es [s000]imerest, MongageTax wm ——_[910O|Loeal Revenues [s200]State Revenues Sf J [9300]Federal Revenues Cs m _|9500|Spesial Assessments | [2s00|other Revenues J es se = es LE Le es ee EE) P [is -] es ee [ss es i 1S eae Bes [ss He GE] es ee r [ss [ERC oh [si [ ‘Net Appropriations ‘Warrants Approved by [ [1200 Fringe Benefits 8 sss SSE) ES r SS JAll Other Expenses FS OS ee es Ss | Fr S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 55 of 74 --- = Page 54 LAW LIBRARY COVERING THE PERIOD 7/1/2021 TO 6/30/2022 =< ESTIMATE OF NEEDS FOR 2022-2023 M-7205 LAW LIBRARY a [vestments eS [TOTAL ASSETS io] [Warrants Outstanding Reserve for Intereston Warrants] [Reserves From Schedule 3 Oe = TOTAL LIABILITIES AND RESERVES (TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE 83D] [Cosh Fund Balance Transferred Ow Sts [Cash Fund Balance Transferred fy [Adjusted Cash Balance ee e [Ad Valorem Tax Apportioned To Year In Capon SS Sources of Revenue [2i0ofLocal Revenues 0S rns = [p200|State Revenues Ts [9300 [Federal Revenues [2#00{tiscelaneous Revenues TS - [ps00{Special Assessments [2600[ Other Revenues [2700| School Revenues oh FF [A Other Non Tex Revenues - ake Tax and Sales Tax interest TT [Cash Fund Balance Forward From Preceding Year Prior Expenditures Resovered 00 POTAL RECEIPTS OS ag . POTAL RECEIPTS AND BALANGE Tf ait | farents of Year in Caption 0 sg Heres Paid Thereon EE FOTAL DISBURSEMENTS rr 7 [CASH BALANCE JONE 30,2022 —— pfs J Reserve for Warranis Outstanding Reserve for Interest on Wamranig Th Reserves From Schedule 8h 2 POTAL MABILITES AND RESERVE Se | -—_—— [CASH BALANCE FORWARD TONEXT YEAR a s J 7 ‘Net Appropriations ‘Approved by Pelton | 7 yee reel Sans ee SS [200 Fringe Benefis sg [300 Travel Related Ss oh G70 Total Maintenance & Operations {3a a8 1 SOT S__-—|s ase] 7 E100 Toul Mactinary & Equipment, Capra Owl $= SS pb Other Expenses Ss (TOTAL EXPENDITURES 2001-22 FISCAL YEAR[S 71301 S ——THOILBS] Ss ese} ‘S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022 7 --- OCR page 56 of 74 --- DRUG COURT COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 55 = ESTIMATE OF NEEDS FOR 2022-2023 M-7206. _ _ DRUG COURT, ; " eq TOTAL ASSETS eer [Warrants Outstanding J [Reserve for Imereston Warrants [Reserves From Schedule 30 5 TOTAL LIABILITIES ANDRESERVES i [CURRENT AND ALL PRIOR YEARS OREO = [ “Cash Fund Balance Transferred Oud Ct ("Cash Fund Balance Transfered In fs = [Ad Valorem Tax Apportioned To VearIn Caption Cid OS CS [Sources ofRevenue [9000[interest, Morgage Tax IS [9100[Local Revenues CSS 2a ISTE - [9200|State Revenues SZ sd [9400|Miscellaneous Revenues dS SS 23,625.00] [9500|Special Assessments dS r [9600]Oter Revenues dS [9700|School Revenues JAM Other Non-Tax Revenues SS [Sales Tax and Sales Tax Interest dS r [Cash Fund Balance Forward From Preseding Year SSCS S| Prior Expenditures Recovered dS FOTALRECEIPTS dS aS r sterest Paid Thereon r L [Reserve for Warrants Outstanding SY [Reserve for Interest on Warrants YS Reserves From Schedule 8 dS r [TOTAL LIABILITES AND RESERVE Cw iY DEFICT SS ‘Net Aj riations ‘Warrants ‘Approved b [ [1200Fringe Benefits 3 [1300-Travel Related Sg ts [2000"Total Maintenance & Operations |S SB 09608 |S ae S____-_|3____ 8a | [ [atooToat Machinery & Equimen, Copa ORS —— S$ JAM Other Expenses SS > [TOTAL EXPENDITURES 2021-22 FISCAL YEAR[S __58,096.08|[S __40,614.63]/8 |S 8481.45] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘November 09, 2022 --- OCR page 57 of 74 --- Page 56 COURT CLERK PRESERVATION COVERING THE PERIOD 7/1/2021 TO 6/30/2022 7 ESTIMATE OF NEEDS FOR 2022-2023 M-7210, COURT CLERK PRESERVATION <a, 7 [TOTAL ASSETS OCOCOCOSOCOCCCSCNSCSCSCSSST I — s—— [TOTAL LIABILITIES AND RESERVES 7 a ie ————————}__7 SS Tm) Opening Balance from Prior Year $ 23,072.35 || $ 23,072.35 7 Sr ET es Se a Ee a es a ee Pl0ofLecal Revewes a] Sata Sa Reems i fs ——— ss S500] Speial Assessment 7 J $000 Reve sh Seles Tax and Sales Tax Ts 7 cs ss [sao ———— RSLAL RECEDPISANDBREANGE i tee es en ss 7 ss sera; ———_ es es ee Se ee ———__}>—f#——|__] [s—_——-4 + en Coes Ce {CASH BALANCE FORWARD T0 NERT YEAR -———_ su f}§ ——— 7 Net Appropriations ‘Warrants ‘Approved by 7 CC [ss [s—— 3} —-<$ 00 Foal Meinennie & Opes “J s-__seaa fs 3 $a] 3] $100 Toul Mashnay & Egupnens, Coa] Oulaf sss —_}>- "3 ! Sara S.A. and |. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 7 --- OCR page 58 of 74 --- INDIVIDUAL REDEMPTION COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page $7 PP ESTIMATE OF NEEDS FOR 2022-2023 t a : a INDIVIDUAL REDEMPTION Seer eee an Shee Tune, ir r Ek 355 as eS c so [SJ Reserves From Schedule $s s——_——— Ss 7) r es Se ee [So 337s] P es r ouees ofRevenue Tf [st00|toeal Revenues [s200|state Revenues r [psb0|Federel Revenues a es [° ——_|s00fotber Revenses hh L [9700|Schoot Revenues es ; es r es : es [fs [s—_ c [fs fs J [ss ee r [so - [sos [ss [s——] r [ss DeFICTT: oS oo [sd r ‘Net Appropriations Warrants ‘Approved b: [sore | See sss oh es P a EE JAM Other Expenses SS OS oe [sd i S.A. and L Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 L --- OCR page 59 of 74 --- Page 58 EXCESS RESALE COVERING THE PERIOD 7/1/2021 TO 6/30/2022 7 — ESTIMATE OF NEEDS FOR 2022-2023 EXCESS RESALE 7 [S| ; 7 s— [s—__- a = 1 7 ss _ [ss] : [ss [s—__s [SS [s—____ fs 4 ee ee [2100}toeal Revenues —| * [9200|state Revenwes Sg [ss SC ee Ce 7 [9s00]Otier Revenues [Ss [SJ CE Ce : [ss Por Expenditures Revovered 0 [s__-] 7 [ss [ss [ss : [s__ J 7 eset for Warrants Ouitanding Reserve For Interest on Warrenty TO [ss 7 [ss a a | ee [sj — 7 Net Appropriations Warrants ‘Approved by . HS LR Leo pe 1200 Finge BeneBig sg fs Hg ee (Ee Pa reel Maintenanee & Operations 3 10073.00 8 srr 5 ipa neal Machinery & Equipment, Capel Ouly| Ss } Ss sS—_——] S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ~ November 09, 2022 7 --- OCR page 60 of 74 --- 5 TAX REFUNDS COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 59 nm Merabal ESTIMATE OF NEEDS FOR 2022-2023 a Ce [WansnisOusiandig Reserve for Interest on Warrants J * sj * a - |_Opening Balance fiom Prior Year SS [s—___] J [4 > [Ad Valorem Tax Apponioned To Year In Capon YS dS [Sowees ofRevenwe es [S100|tocal Revenues Sis = [s200|state Revenues | [9300]Federal Revenues [940o|Miscellaneous Revenues n [s—__] es a IAIl Other Non-Tax Revenues iS n Sates Tax and Sales Tax Interest CdS ZY [s—___] Prior Expenditures Recovered SS HOTALRECEIPTS n [s+ [s 16660583 -_| finerest Paid Thereon i = _(ROTAL DISBURSEMENTS 0S ICASH-BALANCE JUNE 30,09 158.00 J a [sd n [fs] [ss a A [CASH BALANCE FORWARD TONEXT YEAR ss s—] r ‘Net Appropriations Warrants ‘Approved by . ee Eee ES Se [s_____-_|s__15800 [— (RrooToat actin & Euipmene Copal On| S$ J SS [SS 198.00] P S.A. and L Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 61 of 74 --- Ee Page 60 EMERGENCY TRANSPORTATION REVOLVING COVERING be ae 71112021 TO 6/30/2022 = 17506 ESTIMATE OF NEEDS FOR 2022-21 EMERGENCY TRANSPORTATION REVOLVING . 88 Baiances - [s_| [investments . [ss [ss a, ® HR ASH FUND BALANCE JUNE 30, 20 = (TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE . [Schedule 5: Emergency Transportation Revolving Fund Balance SI heet of Current and All Prior ¥ Years SC~S@YS a es ® [ss a Ss [2100fLocat Revenues 0 [ss . [ss ss es ‘ | [9600 other Revenues es a [ss = a es a se " [ss [ss peat DISBURSEMENTS DISBURSEMENTS [ss te 90] 7 [sd [ss js is "i [ss 7 [ss (| [Ss Net Appropriations | Warrants “Approved by 7 a a a Ce [st ee | js : a 7 | [so ‘ sh Li-EES LEe S.A. and I. Form 2631ROI Entity: Ottawa County, 5 November 09, 2022 7 5 { --- OCR page 62 of 74 --- EDUCATIONAL TRUST COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 61 al ESTIMATE OF NEEDS FOR 2022-2023 M-7605 : - EDUCATIONAL TRUST A a —_ Reserve forInterest on Waranis [s————— =: S———J ; r . [CURRENT AND ALL PRIOR YEARS 00 PRET ~ ee [ “Cash Fund Balance Transferred In [s—11,1s000 [3] = Aa Valorem Tax Apporioned To VearIn Caption dS ee [Do00[inerest, MongageTax YS [9100|Local Revenues iS ™ —— fpa0o)state Revenues ts [9300|Federal Revenues a 5 [9500|Special Assessments YS [9600] Other Revenues ss Cs es p Seles Tax andSefes Tax Interest ISS |Cash Fund Balance Forward From Preceding Veet SS dS [Prior ExpendituresRecoversd SS [fs [TOTAL RECEIPTS ANDBALANCE $28,910.00] r [Warrants of Yearin Caption Sid 3,000.08 | es [SJ r (CASHBALANCEJUNE30,2022,0————“CsSSCSCSCSCSCSC“‘S(SC”S”S”S*SCS*é‘;SC*”Y BALANCE JUNE 30, 2022 [$_21,910.00]/$ Cd a [ss es Porat ciasicrres anp RESERVE eric Ss s————} r Net Appropriations Warrants ‘Approved by [ [200 Fringe Benefits SS is a ES [s—_—— [Rta raat wachinay& Equipment, Copal Ou] $$ a ES [S____3,000.00|[S TS 21,910.00] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 63 of 74 --- . Page 62 INDEPENDENT SCHOOL REMIT COVERING THE ED To 6/30/2022 ° ESTIMATE OF NEEDS FOR 2022-202, ee M7702 . ' es —— [TOTAL LIABILITIES ANDRESERVES——S—~CSC~C~SCSCSCSCSCSC.C“‘(!T dS RRENT AND ALL PRIOR YEARS 2021-22 PRE-2021 [SS 105,088] | es ee Es es js ' re [2t00fLocal Revenues SiS 3855.30 S525 13] L [2200|State Revenues SS nS aa] |2300)Federal Revenues St [ss ' [2500}Special Assessments TS tS [ss |9700|School Revenues TS [s_ [all Other Non-Tax Revenues BS oh ' a es es | [$__11,437,306.86 | $ ' [ss a [$_11,436,742.44 [$3 . CASHBALANCE TUNE 30,2022 is cts | Reserve for Warrants Outstanding [so a - [ss POTAL LIABILITES AND RESERVE [ss EEC [ss [sso] . ‘Net Appropriations | Warrants “Approved 6 : pa teal Saas a Ce a . | [Ss ot [sera ts ———— [s 11.36.7428 [Ss ro 61030) - S.A. and L Form 2631 ROI Entity: Ottawa County, $B November 09, 2022 --- OCR page 64 of 74 --- 7A MUNICIPAL-CITY-TOWN REMIT COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 63 a) ESTIMATE OF NEEDS FOR 2022-2023 M-7703 _ - MUNICIPAL-CITY-TOWN REMIT = SS yeash Balances fivestments eee [s [s 381.07] [so [s—___ | m TOTAL LIABILITIES AND RESERVES Sr] - [Schedule 5: Municipal-City-Town Remit Fund Balance Sheet of Current and All Prior Years [SST ATT 9] = [$51,195.21 | [ss [_Cash Fund Balance TransferedIn dS dS id a) [Ss es ee |9100[Local Revenues CSC—~*Y [so i" [9200[State Revenues [9300|Federal Revenues CdS CdS CS is | 5 [9500|Special Assessments SSCS [9600{Other Revenues C*dS CC CdS sSYd [9700|School Revenues SCSSCSCSCSC is -_| [SS n [ST Se [Psior Expenditures Recovered [sos [$400,037.90 [$= " [ss mn [Ss 37,890.62 |[S_ (0.00) [s 381.07 [sd [ss ‘a [ss [s_ 381.07 [ss . JDERIC TT S000) sd = Ss fj [Schedule 9: Municipal-City-Town Remit Fund Summary of Expenses ‘Net Appropriations ‘Warrants: ‘Approved by [ceive | P LE DS LEE Lo Se SE [2000 Total Maintenance & Operations SSS dS CC (SY r [2100 Total Machinary & Equipment, Capital OutlayS— SS [s— sd r S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘November 09, 2022 --- OCR page 65 of 74 --- ™ Page 64 EMERGENCY MEDICAL SERVICE DISTRICT (EMS-522) REMIT COVERING THE PERIOD 7/1/2021 TO 6/30/2022 ° ESTIMATE OF NEEDS FOR 2022-2023 M-7704, EMERGENCY MEDICAL SERVICE DISTRICT (EMS-522) REMIT . [s_ 4,615.08 | x ee 5465.08 — [ss [ss Reserves From Schedule 30S " sd . ICURRENT AND ALL PRIOR YEARS dT —sdESPREO [ss Se [Adjusted Cash Balance 00S ST ‘ [sS— | a cy | [9100[Local Revenues SSCS [ss 5,067.26} . |9200|State Revenues [sane 's 21.98] |9300]Federal Revenues [ss [9400[Miseellancous Revenues - [2500|Special Assessments [9600[Other Revenues es 19700] School Revenves SC | [At Other Non-Tax Revenues P a ce a a [so . [$574,355.67 [$id [s_-| a FOTAL DISBURSEMENTS se . sd es Reserve for Interest on Wamrants TO = [ss es [DERI [ss {CASH BALANCE FORWARD TO NEXT YEAR 5 st ——— = Medical Service District Ems-522) Remit Fund Summary of Epes ‘Net Appropriations ‘Warrants Approved by o a 300 Travel Related sp = [SSS SS 100 Towel Machinery & Equipment, Capial Oway) $=" s——— JAM Other Expenses [S| [$374,355.67 | Ss 455.08] = S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 66 of 74 --- CAREER TECH REMIT COVERING THE PERIOD 7/1/2021 TO 6/30/2022 Page 65 J ESTIMATE OF NEEDS FOR 2022-2023 M7706 CAREER TECH REMIT eS Fe a | Sas PAL ASSES re] 7 FE q ASH FUND BALANCE JUNE 30, 2022 |[S____ 16,926.93 | es . [2t00fLocal Revenues VOSS [9200[State Revenues CdS e's 800 | J [9500 |Special Asiessmenty OOS ; [$16,926.95 [$= es ! a | Ss | SE Sa ; i Net Appropriations Warrants ‘Approved by | a ES EE }200 Fringe Benefits Sg >| 00 Total Maintenance & Operations $s J es (HOTAL EXPENDITURES 2091-22 FISCAL YEAR| S _2,106,431.45] r S.A. and I. Form 2631RO1 Entity: Ottawa County, 38 ‘November 09, 2022 , --- OCR page 67 of 74 --- Page 67 r Statement of Receipts, Disbursements, and Changes in Cash Balances Exhibit W r [ Beginning Cash Receipts 5 Ending Cash County Funds Balance July |_|] _Apportiones | T'2nsfers In | Transfers Out |] Disbursements ff ineine Cash | rp JExhibit A’ S$ 2,829,774.24 |$_5,049,207.33 | S 2,492.97][$ 0.00 S_5,166,944.31 |S _2,714,530.23 | [Exhibic IS 0.00 | S 0.00 |/s 00s 0.00 |S 0.00 [$0.00] t Exhibit D $___1,584,734.53 |[$_2,681,062.76 $ 4,731.00 [$_2,773,931.17 [S$ 1,487,135.12 | [Exhibit E $s 395,305.84 |[$ 305,526.74 | $ O00S 0.00 /TS 244,262.00 1s 456,570.58 [Total ExhibitG’s [$0.00 |S 0.00 {{$ 9.00 |[s 9.00|[$ 0.00 | s0.00 | P [Total ExhibitH's |[$ 900s 000s .00/s 00's o.oo fs 0.00 [Total Exhibit I's __] $___4,659,462.03 | $_3,195,984.28|[S_4,731.00]/$ 2,527.44 || $_2,155,577.79 || S_5,702,072.08 otal Exhibit ST's ]$__3,960,469.91 1S 2,862,404.81 [SOOO TS —0.00 | $_3,180,110.08||S _3,642,764.64 P [Total Exhibity's I's 9.00 ['s 0.00 's 000 [soos 0.00 [$0.00 | l [Total ExhibitK’s [$0.00 1 0.00|/s 0.00 [$0.00 |S 9.00 |/s 9.00 (Total ExhibitL's || S ooofs 0.00lls ooolfs _—0.00|fs 0.00 |[S 0.00 = [Hotal Exhibit M's _[[$___ 885,700.19 |[ $ 14,651,607.78 |S 18,507.19 [$1,648.65 |[S 15,024,504.54|[S__529.661.97 L P r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 Fr \ --- OCR page 68 of 74 --- Page 69 r Calculation of the Maximum Budget available using the Estimated Valuations, Miscellaneous Revenues, and Carryover Pr Exhibit X a r General Fund Mill Le P1024 000 FTotal Estimated Assessed Valuation S$ 198,162,30300| Sd SSS] Gross Ad Valorem Tax Le’ $s 202918198 s—“‘«é‘iYSC“‘CS3$S!...OW#C#@dS Reserve for Delinquency Reserve Percentage| $s i84a71.09[ C~dESC“‘($SN’NN._J Net Ad Valorem Tax Ley $s 1,844,71089[ Sd 1,844,710.89 a CO | Cash fund balance. June 30 3 1,077,347. |S 470,401.66 | $ 1,547,748.77 r Miscellaneous Revenue $ 2,864,268.89 | § 0.00 |S 2,864,268.89 a Total Available for Appropriations 3 3,786,326.89 | $ 470,401.66 [ § 6,256,728.55 r S.A. and I Form 2631ROI Entity: Ottawa County, 58 SEE 7 --- OCR page 69 of 74 --- Exhibit “Y" Page 71 r CERTIFICATE OF EXCISE BOARD r ESTIMATE OF NEEDS FOR 2022-2023 STATE OF OKLAHOMA, COUNTY OF OTTAWA. P |We, the members of the Excise Board of said County and State, do hereby certify that we have examined the foregoing . lestimates of proposed current expenses for the ensuing fiscal year as filed with the Board of County Commissioners, and those| \directly under, or in contractual relationship with, the Board of County Commissioners; we have ascertained from the r Financial Statements submitted therewith the amount of Surplus Balances of Cash on Hand; we have considered the incollected ad valorem taxes of the previous year or years; and we have ascertained that the probable Income estimated to be |collected from all sources other than ad valorem taxation may reasonably be expected as a revenue for the ensuing fiscal year, r land that the same does not exceed 90% of the actual collection from such sources for the previous fiscal year. r lin so doing, we have diligently performed the duties imposed upon the Excise Board by 68 O.S. 1991 Section 3007, (1) lascertaining that the financial statements, as to statistics therein contained reflect the true fiscal condition at the close of the jfiscal year, or caused the same to be corrected so to show; (2) struck from the estimate of needs so submitted any items not r lauthorized 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 ‘cise Board to make provision for mandatory governmental functions where the estimate submitted wholly failed or was r 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. [ |Accordingly, we have and do hereby appropriate the Surplus Balances of Cash on Hand, and the Revenues and Levies hereinafter set forth for each Fund to the several and specific purposes named in such estimates, by each, to the intent and r purpose 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 jwill permit; and we have provided also that the Levies are in excess of the amount appropriated to needs after deducting the jsurplus cash balance on hand, and Estimated Revenues other than tax, by the percentage and amount or reserve for delinquent r |tax as hereinafter set forth, which we have determined in the manner provided by law. [ |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, r 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 have made and certified a tax levy therefor to the extent of the excess of said total requirements over any other legal \deduction, including a reserve of caused the same to be corrected pursuant to 68 O. S. 1991 Section 3009, have approved the r requirements therefor to fulfill the conditions of Section 26 and 28 of Article 10, Oklahoma Constitution, and have made and \certified a tax levy therefor to the extent of the excess of said total requirements over any other legal deduction, including a r reserve for delinquent taxes. r S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 70 of 74 --- CERTIFICATE OF EXCISE BOARD - ESTIMATE OF NEEDS FOR 2022-2023 [County Excise Board's Appropriation General Health Sinking Fund 7 | | [so " [So thal be | PS on [Rate of Levy Required and Certified Ga Millsy | _ 10247] ES a 7 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 ~ 2022-2023 is as follows: a a [__ Public Service] Z ™ 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 ascertained as aforesaid, the aggregate amount to be raised by ad valorem taxation, we thereupon made the . levies therefor as provided by law as follows: ree Free Fair Budget Account (Levy Per Applicable Statute) 0.00 Mills; 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) 3.07 Mills; Total County Levies 14.85 Mills; County Wide Levy For Schools (4.00 Mills) 4.10 Mills; Total County Wide Levy 18.95 Mills; 5 —_ and we do hereby order the above levies to be certified forthwith by the Secretary ofthis Board to the County Assessor of said County, in order that the County Assessor may immediately extend said levies upon the Tax Rolls forthe year 2023 without regard to any protest that - may be filed against any levies, as required by 68 O. S, 1991, Section 2869. Dated at » Oklahoma, this day of , 2022. Jeg. Board vpn 7 s Board —— Lot Kadlas Egle On wile th Excise wd Member Excise Board Secretary S.A. and I. Form 2631R01 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 71 of 74 --- Page 73 r Ottawa County, 58 Statistical Data 2022-2023 r Total Gross Valuation Real Propert $ 145,608,494.00 r FTotal Homestead Exemption 5 B,352,442.00 t Total Real Property $ 137,256,052.00 Total Personal Propet $ 29,886,430.00 r Total Public Service Propet $ 31,019,821.00 EE, c S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 --- OCR page 72 of 74 --- al PUBLICATION SHEET - OTTAWA COUNTY, OKLAHOMA *INANCIAL STATEMENT OF THE VARIUS FUNDS FOR THE FISCAL YEAR ENDING JUNE 30, 2022, AND ESTIMATE OF NEED‘ FOR THE FISCAL YEAR ENDING JUNE 30, 2023, OF THE GOVERNING BOARD OF . OTTAWA COUNTY, OKLAHOMA Exhibit “2” Page 75 |AS OF JUNE 30, 2022 Fund Fund Fund J [ASSETS. [_Tnvestments_ id [___TOTAL ASSETS f a A = SIE ee God a] ESTIMATE OF NEEDS a E eae | aa | ] [ [Balance to Raise from Ad Valorem Tax [S$ 1.844, 710.893 TTT Eg CERTIFICATE - GOVERNING BOARD STATE OF OKLAHOMA, COUNTY OF OTTAWA, ss: a 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 Affairs 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, 2022, and ending June 30, 2023, 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 not exceed the lawfully authorixed ration of the revenue derived from the same sources during the preceeding fiscal year a] a Chairman of Board County Clerk Seal Pa] Lie = Subscribed and sworn as before me this IMISSiO1 day of + 2022. Ainge tas Renan issioner Notary Public dl S.A. and I, Form 2631RO1 Entity: Ottawa County, 58 November 09, 2022 " --- OCR page 73 of 74 --- S.A. No, 2633 (2009) 22 cates saan Nov 14 20 arent! evo 2t02 ; ease Taxable Year 2023 State Auditor & Inspe' 2022-2023 z a ‘SCHOOL General ‘Common Goneral ‘Building ‘Sinking General Building = UNIT OF TAXATION bist Fund Fund Fund Fund Fund Fund Fund [yanaote—=—S«d~San«diCt0za~ 0]. a6a0] 6.2] — 7.69] aE a) a || [- 10.247 1.02) 76.42| Jauspaw | Sta i|S—t0.zal 000] 1.84] tol] [- 10.24) 4.09 [foal ooo[ 45a] atolf | .07]| 8.66600] 20.40) a PE |) A | | | 792.44] faon SSC Sas «iY S200] tga ato 3.07] [-—s024 4097] lraivana —S~CiaSC*dC ea 00] tsa] =o], 36.08 7 5a5| 7 tara - t0.26| toa) 90.12) eS NS NS |S S| | | [ween SSSC*dC id tz oo] a] tol 7|| 35.48 |7S.07|7 18.097 40.24 1.02) a SS | Sa (RS! (See (a a ee) EE (| ee eS ES (| | | a | (| || eS CR (|G | eT NT | (A A A) RN ON SE), (| “* Vo-Tech # 11 - Northeast Technology Center - Burns Flat, Mayes Co. State of Oklahoma ) ee County of ) Tebupll hel Clerk for Ottawa County, Oklahoma, do hereby certify that the above levies are true and correct for the taxable yee ar 2022 Witness my hand and seal this: EEX {-— i *~ jg CTEM ak Aahye Mich Dane enue REO} VN 4 \ ey --- OCR page 74 of 74 --- Page 77 c Calculation of Annual County Officer Salary r Personal property and livestock are exempt from property tax. OS 19 §§ 180.71 - 180.83 r [CountyName: SS SSCSC~C~SsSSSCSC~*~S awd 30,935 [Taxable Value: $ 198,162,303.00 Double Homestead Value Ss r $ 198,162,303.00 [County Mill Rate: 10.24 [Service-abilty: TS 2,029,181.98 PT r $ 24,500.00 $s 44,500.00 SSeS eee r Base Salary as set by Board of County ; ET |Commissioners: po ad [Allowed increase of basic salary based on | Aion so | valuation: . po r [Required increase based on population: | ® cE) [Salary forF¥: TS 54,987.50 r Total salary at minimum base: $ 34,987.50 Total salary at maximum base: $ $4,987.50 | r IService-ablilty = Total amount of revenue collected by multiplying Imillate rate (County part) by the taxable valuation. r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 15, 2022