--- OCR page 1 of 75 --- = 7 r OCT 28 2029 State Aug fr a Or & Inspector COUNTY 2020-2021 - ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2019-2020 , BOARD OF COUNTY COMMISSIONERS OF a] THE COUNTY OF OTTAWA 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 a Bivd,, State Capitol, Room 100, 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 2020-2021 ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2019-2020 = PREPARED BY Turner and Associates, PLC . SUBMITJED TO THE OTTAWA COUNTY EXCISE BOARD THIS @ _ DAY OF 2020 zo BOARD OF COUNTY COMMISSIONERS L = » \ cf rman County’ Clerk) : Conynissioner : “Commissioner Bo buy. DQ: nome By chef wete f Pra OD AS dl Z\ Court Clerk ea shenitt Y S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 2 of 75 --- 5 OTTAWA COUNTY | 2020-2021 ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2019-2020 INDEX 7 [Letters and Certifications: Page 7 - Affidavit of Publication. msn ae) Certificate of Excise Board a nmnanmnnniininadgtibit "Y" - Page I 7 IExhibits: Filed 7 Exhibit "A" General Fund Yes Exhibit "3" Building Fund mtn, NO 1 Exhibit "C" Co-op Fund. snsnntnmmnnintninussiiannmnmnnnnnenannennenmnnn NO 7 Exhibit "D" Highway Fund a umntnettitiniiiiinnninntmnmnnnnnmnannnn YES Exhibit "F" Emergency Medical Service Fund cummin YES a | Exhibit "G" Sinking Fund meennnenininniantsnnnnninnannnninnnnnnnunnsnnnnninnnannnn YS : Exhibit "H" Industrial Development Bond Fund oo msmunmmnennennannnnaenn NO 7 Exhibit "I" Special Revenue Funds. mennstmnnatinnanninainninnnninininnmamnmeennnnmnnnnan YS ™ Exhibit "J" Capital Project Funds mmnninsnsnnunninitininnnanansnninnnnanannnnnmninnnannnan NO | Exhibit "K" Enterprise Funds ammnnuneiiitinnninnuinnannnnnnnnannnnn NO = | Exhibit "L" Internal Service Funds. i mtnntiinnnininnnnannannnnnmnnn, NO = Exhibit "Y" Certificate of Excise Board a mannsananunsnininnnnnninnanannnnnnnnnnnnnannn XE | Estimate of Needs : S.A.él. Form 2631R97 Entity: Ottawa County, 38 See Accountant's Report ‘Wednesday, August 19, 2020 7 | --- OCR page 3 of 75 --- = Page 3 AFFIDAVIT OF PUBLICATION STATE OF OKLAHOMA, COUNTY OF OTTAWA Personally appeared before me, the undersigned Notary Public, __( pany. LUWV0» 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, 2020, and the estimated needs and the estimated income from sources other than ad valorem taxes, for the fiscal year beginning July 1, 2020 and ending June 30, 2021 published in one issue of the Miami News Record a legally-qualified newspaper published - a 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. s V Gounty Clerk x _ Subscribed and sworn to before me this Si day of OGlebey 2020. gE ol t >) My Commission Expires a OFFICIAL SEAL _ 4; NATASHA L. MAYS E\JACHE NOTARY PUBLIC OKLAHOMA are OTTAWA COUNTY COMM. NO, 18002679 Ex 03-09.2024 » S.A.&I. Form 2631R97 Entity: Ottawa County,58 See Accountant's Report Wednesday, August 19, 2020 = --- OCR page 4 of 75 --- vs 3 Be ‘pan ages REST AEN a neem rane eRe (eyecare nme ply — omaha ———— | | a = _.. oe Se — ———— = ieee — et eee — a ——— a ———— — == eo — — | SS —————— _———————————— _——— ——— ————— mur rmnorne ST aes SALE me maT “isansareangae area [a | OS TT | eT . ——<————— os) oe Peed a a | aC CT) ——— eer ea ( ———————— _—__—— ee Bo a = _——— ———____— Ee a pc ee _————F enemy — roeertieeeeereennonemerereeseoas” Ses eee Fes et eae Procuiert aiymnctetnaceter oe tare Liege. saan gy ey Ortashs A firous Os ce oe tenenatnecns ttre eospegens (Published in The Miami News-Record - September 15, 2020) LPXLP --- OCR page 5 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" PAGEL a ee ASSETS: pe vestments r [___TOTALASSETS OOOO [Ser oan r [fs J F i ee ee ee REVENUE: r | TOTALREVENUES ST C™C™C™—CCCOdC™C“*C*™*C‘“Ci*isCS [ Claims Paid by Warrants Issued is i is Ld = baa r Cd C [s————— r r | r C—O S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report ‘Wednesday, August 19, 2020 --- OCR page 6 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 5 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" 2a =n tee . [1000 CHARGESFORSERVICES TT SCSdYCSCOC—CSYCC~—“CSCSCSCSCSC‘*d " | a a eb [1073 oe Cou Cl Sg [9109 Dist Atomey Fes [S13 Cony Heat ees [S19 Cony Engines Fes et Panini) 5 ——— 5 [eiaasteitres J 3 [S12 Coan eS a [925 Eesion Bord Reesbasenens ar] [BS RNTERGOVERO MENTAL REVENUES. [OGAL SOURCES | [S15 Publi Heath Contos] ——__],§ ———_ [9126 Shoo Deputy Reinburemet [9123 Coun bry i 8 ta [91222M& M Lin Fees [91923 Assent Fes [91324 Gout Fund Fees - [9101 OS U Benson Reinbusement 1} 822 fs [95 Highway Budest Account Miseeanang_————__} | [221 Ogee. [p12 ee oo [218 kee PB oo [___Tolal -Local Sowees TS oss P'S oo] ™ | 3000 INTER GOVERNMENTAL REVENUES - STATE SOURCES; JP [209 Boat Moor Liense- OTC Cade 6115, ———_}, ———_] a ee Ce i 21 Ac Lens a Ragin OTC Ga BE pusone-org > [318 Omer ORE [Sub Tol 09s rt | 7 [9142 Farm Implement Tax Stamps Tg [91205 Year Exemption Reimbursement 3 sas t's es [24 Tensor faves 8 fr a CT ae i [9202 Diss Amey Reina Sap} [203 Ste Elson Reimbursement ae oe re [2206 Homestead Exemption Reimbursement [9221 Sate Payments in Liew of Tex evens ‘Continued on page 2b ‘See Accountant's Report Wednesday, August 19, 2020 7 S.A.&I1. Form 2631R97 Entity: Ottawa County, 58 / --- OCR page 7 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page 2a OO ] r BASIS AND [over] uirror ensuinc [__(UNDER) | ESTIMATE. pee EOE oC ECt—“CSCC*®YS Po sare | rs ass fs an] [soa —__so.0ed ss 7020 fs 17020] [s___ 40,000.00) sooo] sts sd iT es ee ee [st 90.000 $s [s———20.007f $s fs 90,002 $s Ps 00909 § [S200 | 009 5 [ssa 0000 $s r [ss (1,840.41) | | [S$ ———«S82,110.23] 82,110.23 [S$ _—«82,110.23| 82,110.23 a | a | | fs 5009 § oh a a [sean | __s«.se' ss rat's rarer] 0: A EE es ss [sf 9000024 § ts ts [S334 00 § ss [sa | 50 0026 ss rss | a 1? ee EC [3000940 § [fs 900090 § ss fs 500094 § ce [sf 5000948 Ss so er Sr | ES | | SO | | | t nl is i [s______(@ao.16]]| 10000v[s- ls arasoool['s a7 8a009| [ss —soofs ss a a es CC CT CS] [s—___184337.48 | ______s0.00%4 §—____f's_ira7,s08.30|['3__1.147,508330| [s____—132, 594237 | 009s [sig a6 35 3218, 14635] a ee [sf 90.0096 § ss Sa | SESE) a | |S SATE] |S TURTLE P [so onofs dS C“‘CNC“C*i#'SNSC NC NNN WC [stesiao7| soos. |'s_19paes9|[s 19 948.59 [s 900094 8 a) a [fs 80.0098 $s ts [sp 00 0026's t's arn s a [sf 80.0026 $s ts Ps 00 [90 009 § i r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report ‘Wednesday, August 19, 2020 --- OCR page 8 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 7 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" ae 7 SOURCE Continued from page 2a [9305 Emergency Management Reimbursement TS CdS id " [9407.1 CivilDefense Reimbursement SCC CdS CCC—~*d |94072Food Stamp Reimbursement dS dS TC —* [9407.3 Tick Eradication Reimbursement YS dS Cid | 9415.1 Welfare Agencies Miscellaneous CdS dS TC —~*d 7 | 9415.2 Documentary Stamps dS i CY [3226 Other fs os ee rr ar [se [4000 INTERGOVERNMENTAL REVENUES - FEDERAL SOURCES: [| PY |9202 Distict Attomey Reimbursement=Federal iS 7 [9219 Other-TobaccoTex ~*~ | S970 70] [9221 Federal Payments in Lieu of Tax Revenues id Sd [9314 Bureau of Land Management iS ar] 7 [9303 Federal Grants i? [9811 Flood Cool [9415 CTPA. Salary Reimbursement SS [4118 Other 7 [219 Other oo [Total Federal Sourees Ts aI S930 | [3000 MISCELLANEOUS REVENUE: YP 7 | 9007 interest on Investments dS |S sr] [9122 Permits 500 0] : 7 | 2405.2 Child Advocacy Salary Reimbursement dS [9406 Recoveries rr] [2407.1 Insurance Reimbursements iS] 3 79 20] "y | 9407.2 Public Finance Authority Reimbursement dS 4 [9407.3 Refinds and Reimbursements dS YP | [2408 Rental or Lease of County Properly dS | 2409 Resale Property Fund Distibution dS a] 7 [9410 Transfer Bom Sinking TTS oS [9411 Sale of County Property tg arr [2415.1 Return Cheek Charges Ts [94152 Bony Sales | | 9415.3 Indian Deputy Salary Reimbursement $3 [9415.4 Other-ProtestTex tf [9416.1 Vending Machine Commissions 8 1 [94162 Other Concessions dt [9507 Mowing & Trash Reimbursement 8 [$130 Other oh [3151 tne 7 [ 9000 NON-REVENUE RECEIPIS; a 1 | | S.A.81. Form 2631R97 Entity: Ottawa County, 38 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 9 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Cc Page 2b r BASIS AND [OVER __||_ LIMITOFENSUING [___(UNDER) | ESTIMATE a 7 r ps 90.0096 [$s ts ps 90.0096 $s ts [S90 009 ss [sO S 0. 0086 $s is [$0 0096 3s i [s_ 0 90.007¢f ss [s_ 90 000 $s r [sf 0 002 ss [s_ 355,688 [SC ~*~ snr a79-76 [8 ____ 1,676,479. 76| | | | | r ES | 1 | |S | | [s_ 6240.07 | 90.00%f'§ 2 77903 S28 77903 | [sO 90.009¢f § sg [so 228.00] 90.00% ss 205208 ————205 20 | r [s_ 90.0096 $s Ss a | 0 | [s_90.0086f sss r [SP 90.0096 8 [So 0009 [S687 SSS CRIS «28-984 23 | r 5 340,182.05 SS 1886.67 58S 1,886,677 58] |S |S a | | [sO 35,879.95] 90.00% SS 48 006.965 48,006.56] ps 200,00 [0.0096 sg [se 90.0094 ss [sO 8,658.74 ][ 0.00 sss [So 79,274.86 [0.008% Ss r pS 90.0096 [s__ 2,800.00 f[ 0.000%] [So 90.0094 Ss [ssa 0.009 ss r pS 90-009 [s_ 8,867.78 ]| 00nd Ss [So 90.0074 SS a eS | NS 1) | | [so 90.0096 sg fs 90.0098] gS ES | | | S| r fs 90.002 gg fs 90.0028 fs 90,0026 3s r [So 90.0094 [S134 940.4 PS CdS 259,167 9G IS «259,167.96 | NS | OS | | | r pS 90.0094 ST | | | | [So 473,282.03 [IS Sd 95S —_—2227,955.77| r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 10 of 75 --- m GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 = ESTIMATE OF NEEDS FOR 2020-2021 . EXHIBIT “A” 3 E | 7 ) - | [s—_*- | 5 i | e [s—- | 7 [___DEFICIT: (Red Figure) = [S__71,76775]| ™ [TOTAL . [| [is [s—— ™ 7 Sd es [fs | 7 S-A-&I. Form 263 Entity: Ottawa County, 58 ‘See Accountant's Report ‘Wednesday, August 19, 2020 --- OCR page 11 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 if ESTIMATE OF NEEDS FOR 2020-2021 Page 3 ‘Schedule 5, (Continued) r i 2018-2019 017-2018 2016-2017 2015-2016 2014-2015 013-2014 TOTAL $ 1,079,189.26][§ Ss Ss ~SdzS 1,079, 189.06 s 951,086.57] $US Ss ss 958,263.56 [sa 9i3.t0 ls ss ss Ts 952559967 $ 130,015.79 [$s ss ss 1073,925.37 $ 4651527{s Ss sss 1, 734,463.94 [sss ss ss 25528 990.63 r a ES | | FS | 71,199.27 aS | | | SS | s 4651527] ss ss 9554 555.74 $ 176 531.06 $ Ss sss 5,408,479.11 r $ 10533179 [sss sss 092,623.48 [sss ss s 105,331.79][ $s sss 4,092, 603.48 r [S__71,199.27| 71,199.27 | [st Cd [ss - ~—'| [$s [$= TS 1,315,855.63 | a | (EE |) 60,750.80 SS | | (ES ES eS | | SES | SS | | |) 56,712.64 r [sss ss 7,463.48 [ss sss ss $ 7199278 SS OS OS -«*dS1,198,392.19 t ‘Schedule 6, (Continued) 019-2020 2018-2019 2017-2018 2016-2017 015-2016 2014-2015 2013-2014 sd a | r $ 4,048,042.49 [$33,564.04 |[ $s sss $s 4,048,042.49 [$105,331.79 [$= SS SS s. 3,987,291.69/[$_105,331.79]]$_ = SS ss ES KS |S (S| S| SE |S (|S SS | a ES | (Sf | $ 3,987,291.69 | $_105,331.79[$___ its dS dS Sd P [S60 750.80 [SSS chedule 9, General Fund Investments Tnvestments LIQUIDATIONS Barred Investments INVESTED IN on Hand Since By Collections by on Hand June 30, 2019 Purchased of Cost Premium, Court Order June 30, 2020 r [sss ST [so ss sss EE | | (| || Ee Ec | | | r ES | | | | a | (Se | S| Se | SE | | | r | | | || LEGS LES | |e eo ee [ss SS SS TOTAL INVESTMENTS [$= [SS SS r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report ‘Wednesday, August 19, 2020 --- OCR page 12 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 7 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" 4a - | — ae CE 7 [ __APPROPRIATED ACCOUNTS | ¢30-2019 | __SINCE__| LAPSED [APPROPRIATIONS issue aPrormariong 7 Oo [0100 DISTRICT ATTOURNEY-STATE: [SS CY CSY [1ui0Personal Series dS SY zoo] [1130 Pan TimeHelp Ss iY 7 [isto Ss [4110 CapialOuiay dS O's «d's dC | se10tmergovenmental «dS Y's Is forgo, Sis ts [0200 DISTRICTATTORNEY-COUNTY: [ECC S*Y 4 [110 Personal Services SS [1130PatTimeHelp iS ist [1s10Tevet ts sd or? [200s Mainsnane and Oper sg [4110 Capital Outay St 3 rs [esto imergovenmental iS ss 3] [20052 LewLibrary St 3 7 [02h Other gs hh [02 Total SS 8 oh [0400 COUNTY SHERIFF; {iO Paonal Sendees saa saan ss se] "| [1130 Pan Time Help dS ss Ts sooo] [2310 Teavel gs ts ts 7 [4110 Capital Owdey S'S «ds “Ys 2a] [2020 Inmate Treament S's 3 Ys a [2070 FY 18-19 Expense dS ss TP sta [4130 LeaseRentl O's os I or] [0600 COUNTY TREASURER; EY 7 [110 Personal Servis dS nS os Fs sea] [zo Par Time Helps ss tg rs [1310 Travel Ts gs err] [200s Maintenanceand Operation SSS 23.82 $ ams Ps] 7 [4110 Capital Quay ts [6810 Integovernmental SS [se0ther ss hh C- [06 Total dS I'S 308. |S] s aoa] 7 [9800 COUNTY COMMISSIONERS: EE [i110 Personal Services ISS ro] PaO ss fs oor] [2005 Maimenance and Operation i$ 's - 1s 1s ——90e 35] [4110 Capital Outlay ts fs Or? a Ces Ces ee ren | [ose Others gh [08 Total Ss Ss ore] = S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report . Wednesday, August 19, 2020 7 --- OCR page 13 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page 4a r |_TNET AMOUNT |_WARRANTS [RESERVES | LAPSED | NEEDS AS | APPROVED BY] | SUPPLEMENTAL [or | issuep_ || BALANCE | ESTIMATED BY| COUNTY __| |___ADJUSTMENTS “_[ApPRoPRIATIONS| |__| KNOWNTOBE| GOVERNING [EXCISE BOARD] r [ADDED [CANCELLED] [| J UNENCUMBERED! BOARD |__| eet GE Es ee eee | [ss [s='s 4000000] s 40,0000 | [s Is 40,000.00 |S 40,000.00] ( bp = — [ss ss ss is ts |s__ = [s fs 5,000.00] s 3,648.78 1,098.40 || s_ 252.82 s 5,000.00] s 5,000.00] [se fs ss sss r [s_=fs ss ss Ss [sss sss Ss ts [ss ss 500000 |S easels 109840 |[s 952.82 | s __45,000.00|[s 45,000.00] cr A | A | | | [sts ss ss eS |S | |S | | Se | | |S | | r [sss sss is a ESS | | FS (| Se SN | |S | | SS |S |S |S | | | | | | | r [s_45s2a.ag|[s_-S1,034,466.98 || s_1022.23055|[s W'S 12,236.43 | sis25a11.94 || $_1,03446698| [s__isse67/s_ = W's si686.67|[s sioseo7l[s - ~sTs Ws 50,000.00]s 51,686.67] fs_ sss sss 902.60]fs [s_s7.799.77|[s = —(['s298.865.74][s a78era7i ls igesi73|[s1,39930|[s 492,480.00|| s 298,865.74] r [s__-Wf's 71,093.13 [$173,906.87 '$167,106.87|[s 6,800.00] $=‘ s 135,400.00 $173,906.87] [sss 128.08ssalf'siasosssats sis 137,057.04 s_~ 162,748.28 | : [ss Ws 34.662.74][s 346cn74[s Ts ss r a | | | EC [s__-_[s__-_—i[s" 92,069.66][s 91,638.57 [$431.09 |[s 00s 96,239.86 | $92,069.66] |S | SRN | | | (TO | r [ss = Ss 164,103.34] $162,055.69 |[s = S2,.047.65 || $162,600.23 |[s_ -153,777.01| SS |S | | S| |S | js ss 6028.40] 6028.40 [ss Hs 6 459.00 s 6,459.00] r SS ES | (| [se fs ss Js ts ss a |S | | | SO |S | | C [s_ = Ss = S 170,731.74 |S _ 168,084.09 [$2,047.65 [$169,059.23 |[ S_ 160,236.01 | eS |S | | | | |S | | [s__66a721][s = T'S 206,654.24] 320665424 TS SWS 15624051 |S 15624051] r [sss ss sss . se ss 2,000.00 | s 232.57 ss 1,767.43 |['s 2,000.00 || s 2,000.00 |s sss toaosss|'s4s0890l[s = Ws s.497.65[s 10,406.55 |[$ 10,406.55] [sss ss sss r [sss ss es Ce SE | SE (SS | SS | | [s__6647.21 [$= NS 219,060.79 [S$ 21179571 |S «dS 7,265.08 | $168,647.06 || S__ 168,647.06] r S.A.&1 Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 14 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 1 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" 4b |} —___f_SCAL YEARENDING TUNE 30,2018 FT) [issue Tarrropriarions[ Pd CdCCd 0900 COUNTY COMMISSIONERS O.S.U.EXTENSION: [| TC [1110Personal Services dS CSC «CdS «CdS 79,812.00 Popa Time Hep fs sss" [1310 Travel sss 5,000.00] [2005 Maintenance and Operation s(S359.55|/$ 2359553 ~*‘iT's 13,000.00] [4110 Cepia Outlay C'S Cs OSC CdS Ci | 6810 ntergovemmental IS dS CdS SC Sd CC Cd [2040 Other-Lease dS CS “dis SiS 2,50 00] [09Total CdS 89ST _2359SSI[S__- I$ 110,438.00] if [1110 Personal Services CS 7086S 7086'S fs 298 114.64] |1130PanTimeHelp ts SSS CdS CS [1310 Travel ss ts Ys a0] [2005 Mainesanee and Opemion | s_is050|'s-__iaigw|s sora] s——sesesis] | [4110Capital Outlay Ss SOs Sd | 6810 Intergovermmental SSS dS Cid poe se}; ——} fs 7 | 2040 Other-Lease d's ts SS ~*~ sn] [1400 COURT CLERK: [110Pesonal Series fs 0 aac fs] *) [1130 PatTimeHelp S'S ts CC SY [310 Travel ss ss as] a a CECT by [4u10 Capital Outlay dS SC (SYS i” [6810 Interzovernmental SS dS [14g Other = ss ts oh SS st Ss arp] [1800 COUNTY ASSESSORS ee [1110 Personal Services SS rrr] [1130 Pan Time Help SS [slo tee! 0 3 rd) [2005 Maintenance and Operation T'S 7500s 75.00]|s - Isa. 19000] [410Cepitel Outlay SS ss a | EE Ce SC [sg Othe ss Ss oh [sh Other = ss th [16 Tota) dS 50'S 2500 SJ] rr] [1700 ISO RSPEI [1110 Personal Series dS org ats fs | [1130 Pare Time Help fg tg gp a [1310 Travels 560s T's aso sap] 4 [2005 Maintenanesand Operation SSS —2.a26.66||s _apecel's _- _]|s—2n.760.00] [4110 Capital Outlay St St | $810 inergovernmental S's ts [2040 Other Lease Sg fs 1 err] 7 [17h Other gs i [7 Teal ses as sos sew S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 1 --- OCR page 15 of 75 --- r GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 L Page 4b r [__FISCAL YEAR ENDING JUNE 30,2020] FISCAL YEAR 2020-2021 —] | __""Tner aMounT [WARRANTS [RESERVES [LAPSED | NEEDS AS _| APPROVED BY| | _SupPLeMENTAL [or | issuep_[" | BALANCE [ESTIMATED BY| COUNTY __| | __ADIUSTMENTS "_[arpropriaTions|_ | ——S—*(LKNOWNTOBE| GOVERNING | EXCISEBOARD | r L_ADDED [CANCELLED TT idUNeNcoBeRED[ BOARD | _——_—i| A [s__- [ss eaiz00[ss.ss600][s = “ITs 747600] s 72,000.00] s__72,00000| r [ss fs ss sss [s___ = |[s2204a ls ia.779s8 ls a2isae|[s 9534||s 6,468.78] s 15,000.00] s 15,000.00] [ss iss 13,000.00] s 8,269.32 s 43g7.12|[s_343.56|| s 13,000.00] s 13,000.00] [sss ss ss r [ss sts sss ts [s__ 2042s. fs 2,8664a|[s" 2gesas[s is oselts 2,646.00] s 2,646.00] r a A ROC : [sss aa tiaca ls 274761 [ss 23,367.73 [$s 29620112] $296 201.12 SS |S EE | | | [s__13200[s_ = [sé 160a0|['s 66040 [sss Gas9.00|[s 6,459.00] cr |s_ = Ws 3,245.99 s 33,339.16 | $26,656.53 || $6542 ls aes fs 36,453.15] $ 36,453.15] a | | | | EP | Sa | | | | | a | ES | Ee (| q [js [ss _s6acol[s 4200/8 T's aaool[ ss s6ao0|'s 564.00] [S__132.00 | $3,245.99 | $338,178.20 | $307,983.84 |S _635412 |S 23,840.24| $339,677.27 $ _ 339,677.27] a A RS NY OO | r [ss ss 465,755.53] Ss 458,063.00[s Ws 7.60249 [s a7asari6l[s 474,941.16] pss sg ss ss [s_ = ['s1.246.00[['s7.604.00][s668.86|[s = i's 905.14] s 6459.00] s_~ 6,459.00] 7 [sts = Is 30000|[s is 7032s 129.68 ]['s 300.00 s_—_ 300.00] r a | ES |S a | ES |S | SR ES | | (S| | r [s_=| S 1246.00 | $473,659.53 [$464,761.90 S$ 17032 $8,727.31 | $481,700.16 | $481,700.16 | Gl I ee eee eee [s_2s7467][$_ Ss o92a3.ce [Ss ezaness sos TS 6a,asz.86 [ s 68,482.86] js ts Ws ss ss ses.as is 968.85] r [js ts Ts 7,320.20][$ 7.32020//s ss 7 75080][s 7,750.80] [sts Ts 312000] 2.41724 |['s 229.08 ls 473.68 $3,020.00 || $3,020.00] [ss ts ss ss ss ‘ | (ES | | [ [ss sg ss [js ss ss sss [$2,574.67] $____- TS 79,683.88 [$78,981.09 $229.08 |] $473.71] $80,222.51 | $80,222.51] r SS RN A RS NC [s_- [ss 7931469 ls 166,56526][s = W'S 1.74943 s 184.269.28][ $184,269.28 [sts se sg ss r |s"_-_|[s_207990[s_5920.10|[s ss6a75|[s_ 3553s I's 8,500.00 s "8,500.00| [s_2,09334][s_ ss 30.85334l's5980.75|[s_4.g72.sel[s Is 25,000.00 $25,000.00] |S ES ES | r a re es ee ee ee ee ee [s_- Its igaal[ssa6s6l[s seesol[s ss 750.005 750.00] a | | | Ee | r S.A.&I. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report ‘Wednesday, August 19, 2020 --- OCR page 16 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 7 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT “A” ae [FISCAL YEAR ENDING JUNE 30,2019 | + 7 a ES OS ( [1800 JUVENILE SHELTERBUREAU: EY [1110 PersonalServiess ds SS «dS | 1130 PareTime Help ss ss 7 [4310 Travels ss ts [2005 Maintenance and Operation iS SS SSS [sss sss [ss ss ss = [ss ss sss os r SE | EE (SE |S | | Se | ES | |S | | es ee ee EE | | | [ a | | | [s_ = fs fs 8745386 [$73,729.36 |[§ Is 72asol's enaaseals — 97,445.62| [ss sss ss |s_50,723.00]s = W's 350,723.00] $331,209.63 s 6.04827 || s 13,465.10 $300,000.00 s 300,000.00] |s___ = f's 101,186.63 |[ s_ 369,987.45 |[ s_ 109,203.73 [$4,750.00] $256,033.72 | $500,000.00 || $839,354.18 r SE | | Ek EE | (| - a | | | | | (| r | ES | | (| [s_ ts ss ss ss eS | r [sss 937.703 61490[[s Ts 322.808 1.93770] s1,957-70| a | ES | | | SS | ES | | (| r aa | |S | (| [ss ss sss | SE | Se |S (SS | fs_ ss sss r [sss 1937.70 seo] SS 82S 193770 S 1957.70 | a A SS | [s_2sizi9l[s = [s14a36927 1s 14436027[s ss 14596681 ls 145,966.81] r [s___ [ss 2,000.00|['s 575.76[8* = Is aa2a ls 2,000.00] $2,000.00] |s_ ts ts .20000|'sess.00fs = sat.ool[s _200.00/[s 200.00] js = Is 2,500.00 's 17,000.00 $7,123.06] s 65.00] $s agui.sa|[s17,500.00|[$ 17,500.00] ; js__ [ss 1o00.00[[s [ss 1.000.00]s so0.co|['s 500.00] Pr SE | ( ‘ [ss izisifs toszsifis ooaze [ss esal[si,100.00|[s 1,100.00] [S_2,517.19 | $2,517.19 [$166,652.08 [$153,731.37 $65.00 $12,855.71 | $167,266.81 | $ 167,266.81 | r S.A.&l, Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 18 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 _ ESTIMATE OF NEEDS FOR 2020-2021 } EXHIBIT "A" a Schedule 8(d), Report Of Prior Year's Expenditures rm pT FISCAL YEAR ENDING JUNE 30, 2019 C7 DEPARTMENTS OF GOVERNMENT. RESERVES BALANCE ORIGINAL. 3 'APPROPRIATED ACCOUNTS 6-30-2019 SINCE LAPSED _ | APPROPRIATIONS | issuep—Taerorriarions| SE ee en ee 2300 INSURANCE - BENEFITS: a | [i2iorica gs 1221 Retirement [ss ss ' 1222 Hospital eS | [4222.2 Accident ss SY [223 bite sss 5 1233 Unemployment SE 1234 Workmans Compensation a | 2065 Property a ES | a 2066 Self Insured SS CC | [235 Others ss ts 23 Total SE | | 2400 COUNTY PURCHASING AGENT: a | ee |e 1110 Personal Services a 1130 Part Time Help SS SF [1310 Travels ss es 2005 Maintenance and Operation [ss ss 4110 Capital Outlay eC 6810 Intergovernmental a Ce eS [24g Other ts tg [ss [24 Total =i [ss 2500 DATA PROCESSING: pS —e--, 1110 Personal Services [sss S 1130 Part Time Help [ss ss [4310Travel gs a es 2005 Maintenance and Operation [ss ss 4110 Capital Outlay [ss sis =] 5 6810 Intergovernmental eS | |e 25 Total [ss S's 26 COUNTY SUPT. OF HEALTH LS " 26a Personal Services [sss FI 26b Part Time Help [ss ss [26eTrevel tS [sss 26d Maintenance and Operation [sss ts 7 26e Capital Outlay [ss ss 26f Intergovernmental [ss ss [26g Omer [ss is [26 Tol CY HSE SS Ls 5600 WELFARE AGENCIES: eS | | 1110 Personal Services eS CS | 1130 Part Time Help a 7 [1310 Travel ts [sss 2005 Maintenance and Operation [ss ss 4110 Capital Outla es ES 4 $810 Intergovernmental [ss t's ts Ot [27g Other [sss [27 Total [s__ s fs dts S.A.&1 Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 19 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page 4d ie FISCAL YEAR ENDING JUNE 30, 2020 FISCAL YEAR 2020-2021 L [___T NET AMOUNT | WARRANTS | RESERVES NEEDS AS | SUPPLEMENTAL [or __[_issuep_ [| BALANCE | ESTIMATED BY| COUNTY _| ADIUSTMENTS __[appropriaTions| | —«| KNOWNTO BE r [ADDED [CANCELLED] Td YUNENCUMBERED| BOARD | eS A SN | [sss sss i r [se fs sss ss is [ss ss ss ss HESS GE SS | Fa RS , [sss sss ss r [sss sss ss [ss fs sss sss EE EE | | [ss ss sss ES EE | | Ek | | ES ES | ES (| 7 A A ON (SO | r a | | | | a | EE | | | | | SN ES | | | (| r |S EE | | (| | | ES | ES | (| a | ES |S | ES | (E a | ER | | | (| ——————— a A SO EE SE |S ES | | | a | ES | r SE | ES |S | | | a |S (ER | Ee (ES |S a es es r a se es ee ees ee eee ee es ee es ee ee ee eee SE SE r eS eR LR OR SS [sss sss [sss ss ss i} 8 s&s fe r i——} 8} fs $$ 2 8 fs fs ss SE |S | (| F js ss ss r a SN Se SE Ee | eS A RN SO SC [ss ss ss r a |S CS | SS (S| | |S eS (| | Ee | ES | ES | | r Ee SS SS ES | | | a |S Se | | | [sos ss SSS ' r S.A.&L. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 20 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 = ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" 4e Schedule 8(e), Report Of Prior Year's Expenditures : | FISCAL YEAR ENDING JUNE 30, 2019 [| 7 DEPARTMENTS OF GOVERNMENT RESERVES WARRANTS, BALANCE ORIGINAL APPROPRIATED ACCOUNTS 6-30-2019 SINCE LAPSED [APPROPRIATIONS [iss APPROPRIATION 1 aS Ce (OS | 2800 CHARITY: eS | 1110 Personal Services [ss ss 1130 Part Time Help KS 7 [1310 Travel SS ss 2005 Maintenance and Operation a ee | 4110 Capital Outla a | | a 6810 Intergoveramental [so sss | [ss ss 28 Total a FE | 3300 FIRE FIGHTING SERVICES: | 7 1110 Personal Services ES |G Pe 1130 Part Time Help [ss ss th [a | | KE [a 2005 Maintenance and Operation SC | 7 4110 Capital Outla [ss ss 6810 Intergovernmental [so sss 2040 Equipment Lease Rentals a Ke (| | 7 CX i Fon an [so ES | 25 Total | | 30 RECORDING ACCOUNT: | | | 7 1110 Personal Services re | Ce 1130 Part Time Help [ss ss [i310 Travel CSCiS [sss 4 2005 Maintenance and Operation [ss ss 4110 Capital Qutlas [ss ss 6810 Intergovernmental es Cs Ce SS | | " 30 Total | Ce [SL COUNTY ENGINEER) 0 1110 Personal Services a Ce 1130 Part Time Help [sss [1310 Travel Ci [sss 2005 Maintenance and Operation a | | 4110 Capital Outi ee ES rs Ce 6810 intergovernmental [ss St [Sig Other a | | 31h Other = [sss fs [31 Feta fs I 4900 LIBRARY: 1110 Personal Services [ss 1130 Part Time Help [ss Ss 4 [2310Travel SSCS [ss ss 2005 Maintenance and Operation [ss sf 4110 Capital Outs [sss fs 6810 Intergovernmental [so sss [32gOther- OSS [ss ss 32 Total ES EE CS | | S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 21 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page de = FISCAL YEAR ENDING JUNE 30, 2020 [NET AMOUNT |__-SUPPLEMENTAL [_or |" issuep [| _BALANCE | ESTIMATED BY COUNTY __| ADJUSTMENTS APPROPRIATION{ [KNOWN TOBE| GOVERNING [EXCISE BOARD| r L_ADDED [CANCELLED] | _UNENCUMBEREY BOARD |__| a | | | | [sss oh [sss sss ts r [sss sss SS Se ES ES | a ES |S ER (| r [sss ss ss is a | ES | | | [S_ sss ss Ps tn Be EE _] [ [ss CE | CS (| js sss ss ss r SS a ss es ee ee a | ES | FS | SE |S Ea (SF | ES | ES ES (| SS | Ee KS | SR | | ES (EE | [s_ ss SS SS LS | | | | | [ SN | | | S| SO | SO | | $s ——}s fp ts ts ts r a | | [sss ss OD ——————EE————E SS ee ee eee eee [s_ = Cs SC es [sd ‘ a ES | | Sk | a a |S ES | | | | m SS | CE (SS ES | | [Is - Is - ‘Is —S- ~*|s is [ it —_—} $$} 3s sh Is - ls - ls -|s - ls - is - |[s - iis - ‘| ae ee Pr [s_ fs ss ss l [sss ss rr re ee ee ee ee ee ee es ee ee ee ee eee Pr [ss = SS SS SS | | | | | || en a ee r rr a a ee ee a ae pss ss ss a ES | SE SS | | S| | | SE ES EE | (ES (| r ES | ES | SS | | [ss sss ss [ss SS SS r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report ‘Wednesday, August 19, 2020 --- OCR page 22 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 . 7 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" ae |} aS OF GE eg GE YEAR ENDING TONE, | issuep[arpropriations[ a a [2600PUBLICDEFENDER: Cd [in0Personal Servis SC CdS CC «CdS SC CdS SC «S*d a (eS CE | SS | ES [1310 Travel sss [2005 Maintenance and Operation S'S SiS SS CC SCY ee a | $810 intergovernmental sss [33gQther- SC CdS CC «dS CC dS Cd | 33h Other = Ss aa) [2700 EMERGENCY MANAGEMENT: TE | 1110Personal Services St Sasa fs IIs srao7aal [1130PanTimeHelp SC SSS CZ fisiotiqel sg is a |2005 Maintenance and Operation «S$ 400.00 242.11 | 157.89 |T's 14,000.00] a a a ee | ae by [34g Other Ss [34 Fowl dS 0S 1845.36 Is _ 90.08 |S 7770734 [2900 SOLD Wa eS SS [1110 Personal Services dS dS «Sd . [4130 Part Time Help 8 ts [4310 Travel 3 ts so [2005 Maintenance and Operation S'S dts “| [4110 Cepia Outlay St ts [$810 inergovernmental S's 3 [36g0cher= Ss Sh [36h Other Ss 4 [36 Total 8 of [W0Pewonal Serves 0S SF ™ [2310 Travel ss Sh [2005 Maintenance and Operation St 7 Ss es es ee ee [$810 ntepoverment 5 3 [3820ther ss os [388 Others ts 5 oh 7 [38 Total SS hs 7 [3000 REWARD FUND: [1110 Personal Seviees SS hh [1310 Travel ss sh [2005 Maintenance and Operation 8 3 [2110 Capi Owday Og {$810 mesgemmesia ss | [40x Other ss Ys [40 otal fs 3.A&L Form 2631R97 Entity: Ottawa County, 38 ‘See Accountant's Report ‘Wednesday, August 19, 2020 4 --- OCR page 23 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page 4f r | ______T Ne AMOUNT | WARRANTS | RESERVES | LAPSED | NEEDS AS | APPROVED BY| |_SUPPLEMENTAL [or | issuep_ |_| _ BALANCE | ESTIMATED BY| county _] [-apiustments —_ [AreROmRuaTions| | __— RowNTOBEL_GovERNING | Eco r [ADDED [CANCELLED] || J unencumperep| BOARD |_| t a |S | | | [sss oh r [ss sss ss SS | [ss sss oS os [sss sss is ts [ss sss os os r [ss sss SS i SS ES EE | | a Ee EE ( ( S| | | | [s_6i32.14|[$ "= s63,33938 ls asz9a8i[s - ‘I's _- | 8 12050019] s 12050019 | = [ss ss sss 300.00] 300.00] r [ss i279 |[s 237281 |[s aea7el[s -~“('s 889.05] s 3,000.00] s 3,000.00] [s_ = ts = 's 14,000.00] $11,464.46 [$383.23 |[s_ 2,152.31] 14,000.00] $14,000.00] [ss aso.00[s3,55000][s s77aats T's _2,972.52]| $4,000.00 $4,000.00] = js ts ss ss ss cr a | ES | |S | | (| | | | | |S | | [sss [ SE | | |S SP |S |S [ss ss sss F a | | S| | | | r a | | | S| SS | | | | |S S| | | | | ES | | | Sk | Pr a |S | S| | | | ( SE | |S | S| | | | | | | | | | | | = | |S |S | | | | r ES | | ee | [sos ss [sss ss r [ss ss ss [sss |S Se Se | S| | | | [ss sg ST r [sits SS SS a | | | | | | | | SS | | | r | | |S S| | S| [ss ss [ss sss Ss T ES A EE (on Fe en ee P [sos gs Ss b |S | Se (SS S| [s___-_ [ss SS SS dS Cd r $.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report ‘Wednesday, August 19, 2020 P { --- OCR page 24 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 | EXHIBIT "A" 4g Schedule 8(g), Report Of Prior Year's Expenditures : TT FISCAL YEAR ENDING JUNE 30, 2019 +4 7 ‘DEPARTMENTS OF GOVERNMENT RESERVES BALANCE ORIGINAL 'APPROPRIATED ACCOUNTS 6-30-2019 SINCE LAPSED [APPROPRIATIONS Pisum faPpropriaTiong || = a SS RN a cS |S | | [60a Personal Services a Ee | | 7 \60b Part Time Help | [Sc Travel sss [60d Maintenance and Operation a | | | | (60e Capital Outlay SE | | | 60f Intergovernmental a es lo0g Other SS Ss SN [|| S| RT [ee [60 Total [ss SSC =dt 7 | NS | | 61a Personal Services eS | l61b Part Time Help a | | 61d Maintenance and Operation [ss ss 6le Capital Outla [sos ss 61 Intergovernmental [ss ss " [ss ss (6th Other ds Sd [61 Total [ss dS dS A | | a 7 (62a Personal Services [ss ss 62b Part Time Help [ss ss [e2e Travel Ss \62d Maintenance and Operation a l62e Capital Qutla [ss ss 62f Intergovernmental ES [e2h Other Ts ds [s =| (62 Total a || 3S” a | | l63a Personal Services [ss ss (63b Part Time Help [ss ss [68eTravel fs ts [sg [63d Maintenance and Operation a | | 7 (63e Capital Outlay [ss ss 63f Intergovernmental eS 2 Se Pe es [63 Total a Es | | " a S| | | a (640 Part Time Help [sos ss 7 es ee es [64d Maintenance and Operation [ss ss 64e Capital Outta [ss ss (64f Intergovernmental [ss ss 7 [ss ss [ss iS dS 'S.A.&1. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 25 of 75 --- p GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 I ESTIMATE OF NEEDS FOR 2020-2021 ‘ Page 4g = FISCAL YEAR ENDING JUNE 30, 2020 |-_—____Tweramounr | WARRANTS [RESERVES | LAPSED | NEEDS aS | APPROVED By] [|_SUPPLEMENTAL | OF __—‘| _ISSUED [BALANCE [ESTIMATED BY| COUNTY _| | _ADIUSTMENTS ___APPROPRIATION| |__| KNOWN TOBE| GOVERNING [EXCISE BOARD| r CANCELLED] NENCUMBERE, BOARD | [ss [ss ss js sss ss i ts r [sss sss fs rs [sss ss ss is [sss sss ds i r [sss sss is [ss sss ss is [sss sss i r (SS ss oS ts A A (NN | | js ss ss I Se | EE | | ES CS | r rr es es ee ee ee [s_ = a | | (| a es | es ee ee ee [s_ = a |S | r a | ES | | | EN ES (| | ES |S |S ES | | LS | | A | | | [ ee a a es ee ee ee r a |S | | | | [ss ss ss ES | ES | |S | $s fs fs r b-——f§ fs fs ss ts [ss Ss m | |S | NE | | | | es Pr a a a re ee ee ee . i——3—-s\— 8 ef ts s$———s fs fs fs sts r SN ee a {$s fs fs fs ss i$} 3 fs fe ss is a ee ee ee ee ee ee eee r [s__ its SS SS SS | | | | | [ss gg Is - lis - fis - ‘Is - ‘Is - ‘Is - ‘fis - ‘Is | r Is is is SS is - is ss SS ss fs - Is - lls - Ils - ils - ls - ls - fs - | Is. Is -|s - ls - |[s - fs - |/s - |s -_| c js = ts ‘ a | | | ( [s__ SS F S.A.&l. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 / L --- OCR page 26 of 75 --- GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "A" 4h Schedule 8(h), Report Of Prior Year's Expenditures PT FISCAL YEAR ENDING JUNE 30, 2019 TT 7 DEPARTMENTS OF GOVERNMENT RESERVES WARRANTS. BALANCE ‘ORIGINAL, ‘APPROPRIATED ACCOUNTS. 6-30-2019 LAPSED [issue [arprorniations| a NS SE | A ee | Sees (| (65a Personal Services [ss ss \65b Part Time Help [sss 7 JoSeTravel sss |65d Maintenance and Operation. a ee 65¢ Capital Outlay [ss 65f Intergovernmental a [65g Others ss [65h Other ss ts a | [66a Personal Services a | [S6b Part Time Help [so sss [Soe Travel ss 5 66d Maintenance and Operation pss ss [66e Capital Outlay [ss ss [S6fIntergovemmental —SCS~S™ a | | | 4 [66g Other - [ss ss [66h Other ss ts 166 Total ES | ES eS | es ee ee " 67a Personal Services [ss ss 67b Part Time Help SS | ote Travel ss ts 9 i674 Maintenance and Operation dS d's SY dt lorflmergovemmental S'S dis - [67h Others ss B7 Total EE | | a (68a Personal Services a a a | [68b Part Time Help a Ce [o8e Travel [ss ss 8 68d Maintenance and Operation a 7 (68e Capital Outlay [ss ss 68f Intergovernmental [sss [8g Omer ss Ys 68 Total Sts ‘ fee ee ae [69a Personal Services a | Ce [62h Part Time Help [ss ss 7 eseravet sts os [69d Maintenance and Operation | 69e Capital Outta [ss ss i2Ftatergovermmental OS ts 7 [oe Otier ss fs oh (69 Total TS fs S.A.&I, Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 27 of 75 --- m GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page 4h r | Ter AMOUNT [WARRANTS [RESERVES | LAPSED | —NREDS AS | APPROVEDBY]| | —“SUpPLEMENTAL [or issue [| _ BALANCE [ESTIMATED BY| COUNTY _] | -apsusmenrs [arpaoriaions| |__| KNOWNTOBE| GOVERNING | EXCISE BOARD | [apps “TeaNcencepl [| -——finevcuaerebl pan a A [sss oS Po fs sss Ss (0 sss Ss hh [ss sss Sts fs Se SE | SS (CF [sss ss Sts [sss Ss ts f | ss SS [ss ss ss a SN a EN [sss Ss ss [sss ss r [ss ss ss fs [sis sg ss [sss ss ss [sss 8 Ss CS ee ee ee ee |e Ss si I [sts ss ss Sa |S | (eC Pe | [sss Ss Ss eS ee es ee es es es a Sa ES [s__-_s___-_is-___-[s_- _is____- Is _-_is | r es es ee ee es ee [s—-] a [s_- is. is _- [s- |s- fIs_- Js fis ee ee | Ce ee ee Cee [sss ts ts ss [s__- fs fs [ss is ss Po pe Ss SS eS | | | | RE | | | Ss ss ee eS |e ee Ce Ce es es es [s_- fs - Is. [s- fs [Is - Is d r [ss - fs fs is ss [ss Is - fs. is fs. fs rs [sys ts is ss ss [se S S S SS S r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 28 of 75 --- "7 } GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 7 ESTIMATE OF NEEDS FOR 2020-2021 ; EXHIBIT "A" a , Po ISCALYEARENDINGIUNE30,2019 sd. CS 4 piss |APPROPRIATIONS . a | [4000 HIGHWAY BUDGET ACCOUNT: [1110 Personal Serviews SS OS CCS Cd CS; [1130 Part Time Help Ss ss 4 [1310 Travel ss ss OS! [2005 Maintenance and Operation TS S'S iS CS CY [$810 Intergovernmental tS SSC SS Cd CCS [80g Other =< ss ts [80h Other ss Ss On | 80) Other ss ss 7 [80 Tol TS 8 ss SO} [4500 COUNTY AUDIT BUDGET ACCOUNT: EE [$810 Intergovernmental S'S sd | [82¢ Other sss [82 Total dS Ss Ss rr] [4600 COUNTY CEMETARY ACCOUNT: TES " [10 Personal Series SS dS dS [1130 Par Time Help SSS [4310 Travel ss dS | 2005 Maintenance and Operation S'S ~ [4110 Cepiel Outgy ts [ $810 tergovernmental J] CS TS neal Cee (ee Cr Re [fT e TT C T 7 [ MOOTICK ERADICATION ACCOUNT: PE [1120 Personal Services Sf Da (aie aa {ea ~ a Cy | | ee | [2005 Maintenance and Operation 3 St Di a ED To eel a ee) [6810 mergovernmental sg 1 Caer (Taal ae ees) eT) i ees (Te ee sl sia es eS ge es S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 31 of 75 --- c GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 r ESTIMATE OF NEEDS FOR 2020-2021 Page 4j ia FISCAL YEAR ENDING JUNE 30, 2020 FISCAL YEAR 2020-2021 | __T NET AMOUNT [WARRANTS | RESERVES |__SUPPLEMENTAL [oF [issue |_| BALANCE | ESTIMATED BY| COUNTY _| - | _absustments [appropriations] | ——~=S*d KNOWNTOBE| GOVERNING | EXCISE BOARD | r [ADDED [CANCELLED] Td) _~*dUNENCUMBERED[__ BOARD | ————id - a | | | [ss ss r [sss sss is [sss ss ss i [ss sss sss [sss ss ss Pr [ss sss sss 6 [sss ss ss ES EE |S EE | | | | | (| | r | ES EE [ss ss gs r [sis ss sss Ts SS |S ES | |S | | | Ea |S S| | | | a | EE | | | r [sss ss SS |S (| ES (| SC RE | ES SS ES ES | | | : | | | | | | r —# —# |} ee ee a ee a |S SS | | | i$ &# ss fs fs fs r i—k 2 a a ee ee ee eee ee : [ss gs is r re re ee ee es ee ee Cee A | | | S| S| | | | | A | | Is - |s -|s - ils - Ils - lls - fs - is - ‘| HS GS | (on | | r Is -\s -|s -|s- Is. - |s.- Is - Is -_| es [ss ss ss r |S | SS | | | r [ss sss ss [ss ss ss r a | | | | Sk | aS | | | | | | | i$} #__- ss fs fs ee ee ee eee eee eee Pr =——& ss fs -— 2 2 3 ——_ js ss sss Ee | | Se r |S SS ES | SS S| ES | | |S | [SSS r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 l i --- OCR page 32 of 75 --- > GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 = ESTIMATE OF NEEDS FOR 2020-2021 : EXHIBIT "A" a3 ‘Schedule 8), Report Of Prior Year's Expenditures - PT FISCAL YEAR ENDING JUNE 30, 2019 TT DEPARTMENTS OF GOVERNMENT. RESERVES BALANCE ORIGINAL APPROPRIATED ACCOUNTS 6-30-2019 SINCE | __LAPSED [issue [appropriations[ = a | 3300 BUILDING MAINTENANCE ACCOUNT: | | | 1110 Personal Services | (kk | [1130PanTimeHelp TS SO OS CC «CdS Cid total SS OS CC CS Cid [2005 Maintenance and Operation eS 4110 Capital Outlay a | (| [6810 Intergovernmental ( ode Other sss es 2h Others ss st = 2) Other sss is a | | | pe ee ee TI|§-ouNN-—_ | J 193a Personal Services a | | 93b Part Time Help a | 3etravel Ss ts [93d Maintenance and Operation | Z [93e Capital Outla a 93f Intergovernmental ES | a | 3h Other sss is OC—'?F [93 Total [so SS cr | | SS || fp [94a Personal Services a | | l94b Part Time Help ES | CS ac Travel sts js J94d Maintenance and Operation [ss ss S4e Capital Outlay [ss ss C=, [94f Intergovernmental ps sss a I94h Other - eS | | | [94 Total a ES | 98 OTHER USE: a {98a Other Deductions [sss 98 Total a | | . a | fT 7 TOTAL GENERAL FUND ACCOUNT $ 56,334.94 |] $ 33,564.04 | $ 22,770.90 || $__4,615,758.84 SUBJECT TO WARRANT ISSUE: 99 Provision for Interest on Warrants GRAND TOTAL GENERAL FUND 3 22,770.50 4,615,758.84 ESTIMATE OF NEEDS FOR THE FISCAL YEAR . PURPOSE: Pro rata share of Cot Assessor's Budget as determined by County Excise Board 7 is amount is included in the appropriated account "17 Revaluation of Real Property") GRAND TOTAL - General Fund S.A.&1 Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 33 of 75 --- r Pp GENERAL FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 | ESTIMATE OF NEEDS FOR 2020-2021 Page 4k r | —__ Tver amount | WaRRANTS | RESERVES [LAPSED | NEEDS AS [APPROVED BY] [| “supecewentat [or __[ssuep [| BALANCE [ESTIMATED BY| COUNTY _| = | _abwustments —|arenopnarions| [| KNOWNTO BE] GOVERNING | EXCISE BOARD | [aioe Teanceurep] DP Farencaesn| BOARD a 5 |G Fe | Pee Po sss ss ts SE SE a CC CF EE a a CC C ( eS ss ss is ss (| sn Ge A es Cer) ee ee SS Se SC SC ES S ( r G=_=| | ES | | | KS | ES | | | | (| e |S sss i Ces ss ss eS | EE EC ES SA ES SS ee ee eee es Ce Ce Ce ec Ce [sss ss i ss a ESS SEN CN CR CN CS ———— a | | | | ES CE ES | EC [f= ss BB [sss ss is ig ts » (Ss ss ts ss ae Se SS ER SR EN EN ES SC [sss gis ig gs [ss = ts SSS r a |S | | | | | | | ss I [s____- ts ts SS SS Sd SS a _ eh r ——_— eet Coury a [TS 5,325,739.08 TS 5,024,382.80] C.F ase TS 95.5550 a Le __*d S55 351,596.02 |S 5,050,239.74 | r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accouantant's Report ‘Wednesday, August 19, 2020 --- OCR page 34 of 75 --- | | HIGHWAY FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 = ESTIMATE OF NEEDS FOR 2020-2021 | EXHIBIT “D* i Ed 7 [s_ = |____TOTALASSETS 7 Js sane Warrants Outstanding $ 34,252.94 [s_ | 7 1 7 [ss "4 [s_ | 7 [Js 7 [ss [TOTAL DISBURSEMENTS SSSOSCOSOSOCOSOSCSCSCSCSCSCSCSCSST SY DISBURSEMENTS [$s __2.4103 410, 375.22 || 7 [ss 7 7 7 [TOTAL [s___2,498,877.32] [se 7 [ss S.A.&1. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 35 of 75 --- r r HIGHWAY FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 I ESTIMATE OF NEEDS FOR 2020-2021 ip C1 | | REVENUE: * Cash Balance June 30, 2019 $ 1,731,151.83 ‘Cash Fund Balance Transferred From Prior Years $ 13,90289[ SCS Pr s_223357866][ | l [__TOTALREVENUE OCC CSCSCSCSCidCCS 3,978,633.38 REQUIREMENTS: Claims Paid by Warrants Issued & Transfer Fees Apportioned $ 2,444,628.16 r Reserves From Schedule 8 ae es js r TOTAL REQUIREMENTS LCs ADD: CASH FUND BALANCE AS PER BALANCE SHEET 6-30-2020 TOTAL REQUIREMENTS AND CASH FUND BALANCE $ 3,978,633.38 r 2018-2019 2017-2018 2016-2017 2015-2016 2014-2015 2013-2014 TOTAL - a (| r $ 17311s183l[s_ ss sss ar3si.ss s gacssots = ss ss Hs ,740.620.02| [ss sss i a SS Se CS [sss ss ss 02.89 a | FS FS ( ( fs sss ss r $ esos2s ss ss [ss gg ss 64,562.65, a Ee FS FF P| r a ee $ 13,902.89 |[s___ WS Ss ss ,582,161.05 [sos ss ss P a Se Fe (| r [fs is sis sds is sds ar : SS |S Sa FS | Se FS [so ss gg r [sts ss Sd Schedule 6, (Continued) Pr 2019-2020 2018-2019 2017-2018 2016-2017 2015-2016 2014-2015 2013-2014 : | js Ss ts fs ss s_sasioo[s [ss ts es r s___s4249.16][s__ = its ts dS $ 2,410375.22][$_541g743f[s SS ss ss sss r [s [ss ts sss a | En (SS | [sis ss [s_____saaszae fs Ss Ss Pr ‘S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 36 of 75 --- HIGHWAY FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 = ESTIMATE OF NEEDS FOR 2020-2021 a | EXHIBIT "D" | 1000 CHARGESFORSERVICES COSY fiscawn eeeertes fmigobe ts a a a SS 7 [____Total Charges ForSevices SS SCCSCSC~C~C“‘“‘i‘S SSC“‘“‘;™CS~*idSCSCC*“‘“CNC#*#“*#‘; [__INTERGOVERNMENTALREVENUES: CdCSSSCS—~S boo INTERGOVERNMENTAL REVENUES - LOCAL SOURCES; |/____] pus cout Geese TT pint Highway Budget Acsmunt Maeelaneus Y's 3 122 Loca Paripaion Projet) SY 123 Oter-InLiewof Taxes 7 | a [____ Total Local Suess CSS—S*diS dS [8000 INTERGOVERNMENTAL REVENUES - STATESOURCES:_ SSS SSSSSSCSCSdiY " pl20umysalstex< oe 121 OTC. (0912) Gruss Produsion Tx For Roads -Umetiaed —__|s —_. ]s —] P210 OTC. 1212) Die Fue T8 See 5007 4B orRouis-Unewined se 123 OTC. 2012) Diesel Ful T68 See 500,740 For Roads -Unnsticed [ss 9 124 Orc. (1612) Diesel Ful -Resviced Road Maintenance -Primay —|s____.|s 125 OTC. (1112) Diesel Fuel 168 Se 500.7 4C For Rouds “Rested [$s] B125 OTC: (1012) Diesel Fuel T68 Seo $007 4A For Roads - Umesnied ss] p22 OTC: (0312) Gas Exe TH S500 64D ForRenis-Uneswized dss ee] BI28 OTC. (1412) Gas Enso T6 Se 500 6 48 For Roa -Unrstited 1s |s plz OTC. 212) Ges Exe TSE Seo STO.64E ForRoats-Uneseieed ss, 130 Ore: (1712) Gas Excise Resviced Road Mantenane-Primay ss . PII OTC. (0212) Gas Excise T68 Se 500.6 40 ForRoads-Resiaed | s-[s B32 OTC: (O12) Gus Enso T68 Seo 500 4A For Roads-Unrstiend |p | 218 OT: (0612) Special Fuel Use Tax 126 For Roais-Unrestied $a n | 5 PIA OTC. (071) Spc Fe. 06¢HBIOS]ForRonds-Unewieed sts] 135 OTC. (052) Special Fs Tx i¢ HBS49 For Roads -Unrestited 1s J B136 OTC. (COR) Spcil Fuel V2¢ HB1480 For Rods -Unrstiged [sf P37 OTC- 1912 Special Fue ResiciedRoed Meintenance- Primary [| s_- ——J 7 P22 OTC. (1812) Motor Veh Colestons /CRIR 3 3 299 OTC: (082) Motor Ves Colesuons CRF 3] ir ry P217 OTC. (1812) Motor Veiole Colon COR gs ass PEA OTC: (312) Mtr Veil Calesions COCT 5 et] P26 OTC. ForieureGamineTax $Y a] pusore.( owe. tg a a (es es [__ SubTotal = O1G Tf os irre] 219 Sue Grats I PXOCED Smal Projets I rec] 7 p22 Emergency ManagenentReinbureweat gp 22a Tek Tot Miselaneows Reeve ts ee a CC] postaLieofTaws fg i peg ower fp [__Total State Sourees I IS ree] ‘Continued on page 2b See Accountant's Report Wednesday, August 19, 2020 | S.A.&L. Form 2631R97 Entity: Ottawa County, 58 u --- OCR page 37 of 75 --- Pp HIGHWAY FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 | ESTIMATE OF NEEDS FOR 2020-2021 Page 2a | : BASIS AND r LIMIT OF ENSUING | aggre —| “Seas 1 eee ESTIMATE. [___INCOME | GOVERNING BOARD_|___EXCISEBOARD __| | OT r [ss oh [sn 00s fs | [spss ts r [so SCS eS | | (| a | r [— [sss sf [S00 3s rs [S000 3s rs r [Ss 200013 fs rs a a | | SO | r 00 oh [sf gs fs [s_____ssage077| __o0oulls Is Js r [S009 fs fs c [sf se ss [sed § 3 [st S003 ts r [s____rmgiasel| o00u[s [ss -_] fs a009-§ 3 [sf p00 ss [p00 § 3 r a [sf 9000s ss a) 7 r a a a r a [sage oood[s [sss [sweisis[ ood sss r [s__~«sa,sn1.05]|_____oowas___- Is. [s___ ] [s_s855| _ooofs__- [ss | [s~exs19 | o00nfs ss | [sf 00 § fs r ES [s_teassagg| tS SC CdS Cd a | | Sf S| [s—___“joaaaeas | 00s r Ps 0009 § 5 [sf 009s fs hs a r Ee 7 7 a CS [ss fs fs ls 2054g0ng6f SS CCCCSdSC C=*«d r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 | r --- OCR page 38 of 75 --- HIGHWAY FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 / ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "D" 2b SOURCE 1 [Continued from page 2a }4000 INTERGOVERNMENTAL REVENUES -FEDERALSOURCES: uz FederalGrants Se 7 WNSITP.A Salary Reimbursement CS TCC CdS TC *C*d ls114 Federal Emergency Management Agency (FEMA) CdS OC CdS Cid : [2115 Federal Participation (Projeet) SC CdS CCS 7 Wi6Ower Cid TC CdS CC *” wu7omer= Cd CdS C=S*Y |_____ Total Federal Sources OS SC Cd - [___ Grand Total Intergovernmental Revenues dS = 1s songasan| ™ pabPatTimeHelp SC dls sds Cd OY fisiotrevet ss is sre] - fu0Capial Quay dS dts Ss «ds 20.702 | patimewovemmenal O's ts dis Sd fis0Lewe Rental Os ts sd ce] 7 pabOtber ss 300 DISTRICT3 HIGHWAY BUDGET ACCOUNT: fio Personal Services dS asta ls sas 1s sosem| = pabPanTimeelp Os Ss ts ftom seats ees ITs ara] ftu0Capinl day ss ss Ws a " Patioegovermmental Os is SY tsoLesse Renal sss Ts | Pah Other ss ts PEOTHER USE; ta Oe Detveigns gs i J pSTow Sts ts 7 a - a [GRAND TOTAL HIGHWAY FUND [Stan [8 eaei.oo||s as SSS] 1 ‘7 S.A.&l, Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 43 of 75 --- foal HIGHWAY FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 i Page 3b | Governmental Budget Accounts] FISCAL YEAR ENDING JUNE 30, 2020, r | Twer amount | WwarRANTS | RESERVES | LAPSED | NEEDS AS _| APPROVED BY] : SUPPLEMENTAL [or [issued [| CBALANCE | ESTIMATED BY ADJUSTMENTS ___[appropaiaions| | —=«| KNOWNTOBE| GOVERNING | EXCISE BOARD | Pr [_appeD Icanceuiep] [dL —=éduencumperen! Boar> | i t a ls. | —_ [s 52437232 | 524,372.32 [s 478,556.06 | 478,556.06 [si I's 45,816.26 | 45,816.26 [s 45,816.26 | 45,816.26 ['s 45,816.26 | 45,816.26 js | [ss sss ss r a ee [js | [ss | r [ss S$ 12,900.00]| $19,837.72 $19,837.72 Hf} fsa js ss gs sss r Is - TS __-_(|L $_1,400,390.02|[$ 673,109.64 $731,269.39 || $__731,269.39 | | | | (| [ss = s 520,645.39 [js | $41,786.03 r js ss sss ss [s = ls Ws tasresalfs isese9lfs _83s||s 1,122.70 [sts $_ 307,299.00|| $307,299.00 c |s_ iss so7ezesfs fs S 89,782.68 || $ 89,782.68 [ss ss ss ss [sss 76,071.61 [sis 2.99737 r [ss ss ss ss { [s_ = iis | $746,286.47 || $___4,521.15 || $_447,863.84 [ a | | | |S |S | ON | a [s | cr | ES | SS | (ef ef | [ss | [sss sn.ge8.99 | s 342,360.70] s 18ai719[s_1si,10710|[ $162,728.38 r [s_ = ts | [ss ss ss ss [s = is [s | $__2i7997|[$__28,179.97 [ss es ss is ss r [s_- Ils - ‘|| $_1,353,529.87|[$_1,025,232.05|[$ 19,967.19 [s__ 319,951.91 | eS | | | | | || a | |S | SP | | FO | | Pr a SE | | Ee | | | E—}; — | $_1,494,209.08 |] $_1,494,209.08 [ [ss = S_3,952,591.35][S_2.444,628.16|[S 39,796.14 ][$_1,468,167.05 J[S_1,494,209.08 ][$_1,494,209.08 eet by County | P| Governing Board [Excise Board _| le PT 5 1,494,209.08 T 5 1,494,209.08 a | a Fr PS, 494,209.08 TS _1,494.209.08] S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 44 of 75 --- HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 r EXHIBIT "E" PAGE 1 Ln r ASSETS: |_—_tnvestments TT OSSSCSC=*d [ss r L_____ TOTAL ASSETS COCCOCOCOCOCCC™S*d JABILITIES AND RESERVES: [s = r + Pr r | | | ca | r \Cash Balance June 30, 2019 | {| i fe r [| era es = (Claims Paid by Warrants Issued $ 189,296.53 r [| [so rs | c Ld fo [ r a r r [s r r fo [s ‘ r { PCa —sSY r {Cash Fund Balance as per Balance Sheet 6-30-2020 +i 233,058.00] $.A.&I. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 Pr --- OCR page 45 of 75 --- HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 = EXHIBIT "E" 2a 1 eee ee " [1000 CHARGESFORSERVICES 1000 CHARGES FOR SERVICES es oS 7 [112 Laboratory Serviees dS CdS CCS RE S E Re ae a [ 1115 Child Guidance Services CdS CC CdS CS [16 Barly TestBarly Care SC OSC *d | 1117 Food Service Test and Certification CdS CC CdS Cid 7 [1118 PooVSpaCenticatoon SCC CdS [1119 Sewage andPereTest CdS CdS iY [1120 Public Bathing Licenses iS SC CdS {1121 Oh ce cc ||; CeCe |S | : [1122 Miscellaneous Health Fees YS iS [1123 Otero ts [1124 Others ts " [1125 Other ts [____Total Charges For Services SCS*dCS CC —*idtS 1999S] | __INTERGOVERNMENTALREVENUE EY 7 | 2000 INTERGOVERNMENTAL REVENUE -LOCAL SOURCES; SSCS SCY [2111 MobiteHomeTex Sg [2112 Housing Authority Payments in Lieu ofTaxRevenue dS] [2113 Revaluation of Real Property Reimbursements iS [2114 Manufacturing Exempt Reimbursement i [2115 Public Heath Contibutions dS [2146 Perinatal Health Program 0 7 [2117 Community Gare-HMQ Tg [2118 Other Protest Tax Tt ae a CT by [____Total-Local Souress | 3000 INTERGOVERNMENTAL REVENUES - STATE SOURCES; [| [3211 Sate Land Payments [3212 Ste Payments in Liew of TexRevenwe YP sa] 7 [3213 Homestead Exemption Reimbursement YS [2214 Additional Homestead Exemption Reimbursement [3215 Ste Grats EB 7 [3216 Ollahome Dept of Environmental Quali t's [3217 STD Progam Suwte) OO [3218 Water ResoureesBoard Tg 7 [3219 Oldahoms Conservation Commission 13220 Wolfie Agen Sub-Total OPE tg [222ldeare i oo [3223 Child Abuse Prevention gg [3224 Adolescent Heath Sate? [2205 TB Sap 7 [3226 Otter Sate Reinbusenent-S Vear Exemption 3 ae] [3227 Other ET [3228 Ores oh Lota = State Sourges Ts rr Continued on page 2b See Accountant's Report Wednesday, August 19,2020 S.A.&L. Form 2631R97 Entity: Ottawa County, 58 7 --- OCR page 46 of 75 --- [ HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 | Page 2a EES” BASIS AND r LIMIT OF ENSUING t ESTIMATE a | | | | 7 r fs soos ss fs 0.0024f $s fs :0.00%[ ss ds r js 90.0026 sss [so 90000 8s fs 90009 sss r ps 90.0096 ss ps 900096 ss ps 90.0024 ss r [so 0S C—“=‘“‘“S*SC*~CSC*diCSC;i‘“CSNN’NNNNNWCCWC*CY ps 90.0096 ss [so 90.002 sss ps 90.002¢ff ss r [ss 90.00 sg ED a | | S| | (ES r | | Rl EE DE Re | r [so 90. 002 ss [se 90.002 3 ss [sors ss Po fs 90.0096 ss \ SS | | | | fs 80009 $s es 90.0094 r [s__19,999.4s PS | | | || | | | r [s_a3a23 ff o.oo sg [sO 90.0096 gg Se | r fs 90.00% sg gs ES | [S80 009 $s r SS | | [so P 9 0.002 ss Ee 0 (CS S| [sO 90.009ff Ss r [ss 900096 ggg js 90.002 [S000 ff [sO 90.0024f SS [s33agor fons ss PS 000g Pr fs 90.00 sg [s_ 3,584.24 S.A.&I. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 r --- OCR page 47 of 75 --- HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 ~ EXHIBIT “E" 2b 7 SOURCE [aroun acruanty 1} Continued from page 2a [4000 IVTERGOVERNMENTAL REVENUES - FEDERAL SOURCES. ES CS Ce i [4112 Federal Payments in Lieu ofTex Revenues [4113 Bureau ofLand Managemen $d sale et ete [4115 Women infants and Children 8 [4116 Maternity Care (Medicaid) d's [U7 EPSDT Medio) $5 7 [+18 Family Paming edie) 3 7 [4119 Bary intervention Federal) 3 3 [4120 Oxishoma Dept. of Environmental Qualiy Feder) ss P21 91D Progam Geter) ss [$122 RyanWhiteProgam i$ 3 [4123 immunization Aston Plan eS Ce Ce by [4125 Summer Food Series [sz60mere I es es Tb [s1280ber tS RG cS a | | [S000 MISCELLANEOUSREVENUE! PY [5111 inereston Invesments [5112 inswance Resoveries 13 ieee Reba fg sd [s1¢Copies gp [$115 Retun Check Charges tt [$116 Usliy Reimbursements 7 [5117 Other Refunds and Reimbursemenss 8 [5118 Resale Property Fund Distibuton [S119 SaleofPropeny ts [5120 Sale of auipment Os 7] [$121 Vending Machine Commissions [5122 Other Concessions {32s Pub Reeods Fee gg [5124 Reoord Seach Fee [5125 Carseat Sales ae Cees ees i [5127 Sabge Sales fs [5128 Projest Women $F [5129 Community Cwe=HIMO 7 [s1300mer@ 0g [5131 Otero [3132 0m I [__Total Miscellaneous Revenue iS] 773] 7 [S000 NON-REVENUE RECEIPTS: [6111 Contributions from Other Funds YS a | ‘7 : [_Grand Total HealthFund dS IS S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 48 of 75 --- [ HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 r Page 2b BREAD —|____——narar cco —————] r LIMIT OF ENSUING [____ (UNDER) | ESTIMATE | r [so 90.000f $s SY [sO s000df's ds CdS CS” fs 50.0093 ss SY pS eee OMS CdS CC CdS CCCS@Y r fs 90.0026 $s [S900 $s js 50.00% $s Ss r RS (EL? on | | [so 90.002f ss fs 90.0026 3s a es es | a | SS [so 90. 009% ss i [So 50.00% r a | SF fs 90.0098 gg ee || | | c [So 90.00% gg is SS |S | SC 5 S23,563.69 SS | | | || [ [so 90.00% sg ig 0008 fs r [sora oof s ss 0009 § ps [so 90.007 sg atte §- r a | | | | a | | | | [so 90.0074 Ss es r a || | | [so 90.0079 gs ss 009 J r a | | S| | 0 08 ss ss 0 § r Ss | | | [so 90.000 ss Is Cos pe ee 0.007 ss l a | | | Is 0000p is a | lf [SSS CS Sd | | | | OO || | | | | SO | | c [so 25357g2 OS OS CdS id S.A.&I. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 r --- OCR page 49 of 75 --- HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 - EXHIBIT "E" 3 7 [ss 7 [s—__— 7 7 [ss 7 [s = 7 [s 1 [ss 7 " [TOTAL " [ss [s___] es i ] ) [fs ss 7 [ss 7 [ss 'S.A.&. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 50 of 75 --- r HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 r Page3 Schedule 5, (Continued 2018-2019 2017-2018 2016-2017 2015-2016 2014-2015 2013-2014 TOTAL r [s__ 22983397] YS OS CdS CC CdS SS dS 209,833.97] a a ES | r [s_seos7zaziis Ws dS CC C«CdTS SSSC*~S:~C*iiS SSS 22983397] | $ gossazis = sss Ss CdS 260,847.10 SR CC | r [ss sss ss 10,036.24 a | | | CS s_6g9sa2fs 0 gs sss Ts 296,241.16 = S$ 66os28a[s ss ss 526,075.13 r s__s6016.60l[s [sss ss 931,760.98 a |S | (FS | $___s601660]s = [ss sss 231,760.98 r [s___1oo36.24 [$= SC CdS TC CdS SC CdS «CdS 294,314.15 Ss | Ee | [ss ss sss is SS ES EE a | ES (FS a ES |S | | | | r a |S | ee Schedule 6, (Continued) 2019-2020 2018-2019 2017-2018 2016-2017 2015-2016 2014-2015 2013-2014 r [s_ [ss ss $__189,296.53|[$_4asa7el[s Ws ss gs $189,296.53 [ss r [$s 175,74438][$_56.016.60]/s_ SSC CdS CC“ SCSdi SCC Cd CS «Csd ES | Se SE |S ES ES eS SF fs sss r $___56016.60]/$ Ss (S__ 3.55215 ][s 50000] SS [ Schedule 9, Health Fund Investments Tavestments LIQUIDATIONS. Barred Tavestments ia INVESTED IN on Hand Since By Collections ‘Amortized by on Hand June 30, 2019 Purchased of Cost Premium Court Order June 30, 2020 | | | EF po fg gg Ss lL (Fs S| S| (| a | |S | SF S| S| S| | (| r | | | SO | SS a |S |S | SR | Se | SS = eS | | | SE r a EE | | CE | LS |S FS | | Fe [OTAL INVESTMENT! $= [SSS r S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 t --- OCR page 51 of 75 --- HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "E" a 7 ee FISCAL YEAR ENDING JUNE 30, 2019 | Cd DEPARTMENTS OF GOVERNMENT ORIGINAL 1 APPROPRIATED ACCOUNTS 6-30-2019 APPROPRIATIONS [issue arPropriaTiong a | 7 92 COUNTY HEALTH BUDGET ACCOUNT: eS | $___9,001.00|[$___9,001.00][s_ = s 123,000.00 2b Part Time Help a pcTrvel CdS 1,100.00 $ 406.60 $ 7,344.60 |{ $ 4,760.38 | $ 2,584.22 [sss 0688.16 es ee ee 92g Other - Revaluation es ee ee) 4,076.48 ES ee . 2 Tow Cd $ 990.82. A | | NS | es es CF : [ss ss paeTavel is dss ds CC [p34 Maintenance and Operation ——SSSSSSSSC«d'S SC ~«*d'S.=~«SSC~*~‘ S;*id‘S;~SCSCSCSCSC~CC*d SS SSCSCS~*d " sss Ss 93f Intergovernmental a 3 Tol SC CdS CdS SC dS TY EE ee ee eee eee a . [ss ss [ss ss 7 [ss sss [ss ss a (ES | [98 OTHER USES: eS | | 98a Other Deductions [ss ss 7 | a | | | TOTAL GENERAL FUND ACCOUNT $14,454.78] $ 2,990.82 |[$____ 412,764.64 7 GRAND TOTAL GENERAL FUND. 7 ESTIMATE OF NEEDS FOR THE FISCAL YEAR ~ 7 Pro rata share of County Assessor's Budget as determined by County Excise Board 7 S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 52 of 75 --- c HEALTH FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 r Page fe [Tver amount [warrants [RESERVES | LAPSED [NEEDS aS | APPROVED BY] | | “‘supecewentat [or [7 issuep |__| __BaLance _[ESrimareD By| county __| [__ADIUSTMENTS ___[pPROPRIATION’ | | KNOWNTOBE] GOVERNING [EXCISE BOARD] [ a [s___-_|[s___- [5 125,000.00||3 —s033790||s s2.6ez.10]['s -_] 3 1300001 s se p000| a CC P [ss fs no's agra s m0] s some | s — seas mo [s to7i3se|[s-|[s_169713.88||s a608657]|s _4515.36]] $79,111.95 Ts 200,000.00] s 110,000.00] [ss Ts niose.16|'s 3993.94) - ls 106,694.22 Ts 175,000.00] s —258.495.76| a SE SE SN CC [s/s Is aoreas fs apeaas[s _- [[s 1331s _s000.00]|s 3508.64] _ {joss sss is sd (Fem § ef ees ee ee ee ee [so7isael's _-_[s_a7a7e.s2|[s 1899655 |[s 3726716 || 8 20591485 || s smi 000.00] 5 _aaa384.0] A r is ss Ss [s__- |s- [s_- [s_- Js _- fs ss] [s__- |s_- ss _- [s_- Js >. Js _]s___] [s- |s- [s - [s_- fs - fs ss | Sen a is. [ss - Js - [s_- fs _- ]s__- s__-_] is. [s- Is - Is _-[s - Is - Js _- Js | Po fs Ss sss ss fs ES | SE a a a SS bo [sos ss ts fs ss As | eo) Geol es Gees os Hos [s- Is. |s__. |s_- |s- Is _- ]s- Is __- | [ =| — 3 I [s__- |s___-]s_- [s_-|s - |s_-|s- Is | r EE EE SE (CC (iss oh o_o a a | r ———— [ss _-_[s____-_|s__-['s____- ls_ Is JIs- | Loa}: ——— bs ens teers ere fs ress soa ee a ee aS ET EN ER i; —_, —_}, —_ ——_ —_ is] fs rp { a TF ering Boar [ics Boar YS 589,000.00 TS 484,495.76 | a a Co TTTETHFHEReoNvNva--.....0V.0._ 5 ro] P S.A.&l. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Monday, August 03, 2020 --- OCR page 53 of 75 --- Pr EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "F" PAGE 1 r | ASSETS: - Is‘ | ___TOTAL ASSETS Td | t Warrants Outstanding is P isd l [____ TOTAL LIABILITIES ANDRESERVES S| L a ST r REVENUE: , r [ fd eee | a Claims Paid by Warrants Issued $ 525,360.16 > [s_ r [s_ [ss pd [ See ba r LL. r [ss [ss fr [s___ 23,650.02 [s_ 13,914.13 | r Csr [ss r LT [Cash r S.A.&I. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 : --- OCR page 54 of 75 --- EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 / ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "F" 2 [Seemie4 Misiones souRCE a [i000 CHARGES FOR SERVICES Pd [i SeviceFees SB [i112 sevieeFes iS [1113 TainingFes iS [isteomer Sd [Tol hangs For Sendees 8S [ —INTERGOVERNMENTAL REVENUES PE [2600 INTERGOVERNMENTAL REVENUES -LOCAL SOURCES; [J [2itt Local Comibutons dS [2112 Local Governmental Reinburenenis———SSSSSCSCidS [213 Lowa Payments inLienofTaxRevenwe Sd [2neOber-ProetTaxes dS [Total -Local Sous] [0 INTERGOVERNMENTAL REVENUES. STATE SOURCES; PJ [3111 CountySalesTwx-OTE [puzome-ore [SubfewlOs [e211 SaieGrams [3212 Sute Payments in Liew ofTaxRevenue SiS id [3213 Homestead Exemption Reimbursement ds [3214 adaional Homestead Exemption Reimbursement $s [321s Oter-Syearenempt gg a] EE [Toul SaieSewees 8s rr [000 INTERGOVERNMENTAL REVENUES FEDERAL SOURGES, [J [Federal Gang YS [ate Reimbusenent-Feded dS tg in [4113 Federal Payments in Liew of Tax Revemses YS a Sa [Toul eiealSowes [Grand Total nergoverimental Revenues YS] [S000 MISCELLANEOUSREVENUE, [stitinerestontnvesmens {S12 Reta or Lene ofPopeny sg [3113 SaeofPropeny tg [S114 Subscription Sales Membenbip) ES Ce Cee [5116 Inoue Reimbursements tg 2 ily Rebs fs is 9 [5119 Vending Machine Commissions 3 151200Oter Cononssons i eS CS CS be [312 Oe Ss |__ Toul MiseelaneousRevense 3 — ——— [6111 Consibutons fom Quer Funds a [Grand Toul Emergensy Medial Seviee Fund. > saa 7 S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 55 of 75 --- r EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 r Page 2 2019-2020 ACCOUNT BASIS AND 2020-2021 ACCOUNT - LIMIT OF ENSUING CHARGEABLE ESTIMATED BY | (UNDER) ESTIMATE, INCOME. GOVERNING BOARD EXCISE BOARD A a [s = sooo] $s SCC CdS CSC~SS*SY r SY) PS [sO s000fs «dS SS CCSC~C~—SC*diS SSCS SY [scons CS CCCOCC«*didiS SCSC™~SSY ———S—————— (|| r [so c0003f ss [so 90.00% $e Ss js 90.00% $= Ss r ps 90.008f' $s fs is dS es —“‘“CONC*rCSSCC‘“‘’’NNCC#CWN"™*SCS | (| | r GE EE De) Pe] js c0oonf's ts C*d a | | |S | SS CC r a (07 |S | ls CCCs Cds SCC‘ SS#&@CTS:=CS™CC=éC [s fondfs Cs CC r [s_g6asz0[ ons ss [se s00f gg r $ 664520 CS CS CC dS a | | | | fs oes ss 5) a Gc PS] FE r a | | | | Is os ss a |S | | r 664520, SS Sd . a | | | CS | | |S Po fs 0.000 ss l a | [so of r [js soos ts is [so 0.00rf pg [ss 0. 00rd gg gs r [so 0.000 sg [so 50.00% eg Is of ss a goooms Ts ( [s——— 7 a cr a | S| ; ——— Lo a r es | S.A.&I. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 56 of 75 --- EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 7 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "F" 3 "| [sd [s r ls js "| js al Al [si hi [st [s_ [ss 1 [si [si b 7 [sd [TOTAL 7 [ss [si js 7 1 : 7 [Additions [s_ is | al : js 7 is 4 [S_____23,650.02| S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 7 --- OCR page 57 of 75 --- r EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to SUNE 30, 2020 \ ESTIMATE OF NEEDS FOR 2020-2021 Page 3 [” [Schedule 5 (Continued t 2018-2019 2017-2018 2016-2017 2015-2016 2014-2015 2013-2014 TOTAL r $ zegi66[s ss ss SS 2981.66 S$ 29s66]s_ sss ss 2,981.66 r seiwists [ss ss Ts 519,968.98 [ss ss ss [ss ss ss 16,895.79 r js ss ss Ts 543,509.97 s__ieassrolfs sss ss st5.491.63 r is is ts Cds SC CdS «CdS «Ss 525,360.16 a |S | | (eS r [sts ds [so ss ss ss r js ts sss ss r s___16895.79|[$_ Ss 131.47] Schedule 6, (Continued) r 2019-2020 2018-2019 2017-2018 2016-2017 2015-2016 2014-2015 2013-2014 [sts sss ss $s sas360i6is sts ss ss s__525,360.16][$_ ts Ss ss r s_s2s360.16]f$ ss ss ' gs 525,36016|[s ts is ss sd r [ss ss ts ds ds Schedule 9, Emergency Medical Service Fund Investments r Investments LIQUIDATIONS Barred Investments INVESTED IN on Hand Since By Collections by ‘on Hand June 30, 2019_||__ Purchased ofCost___||_Premium _ Court Order June 30, 2020 r a ee 7 [sds dS ss [ [foraLnwes™ents[s = fs SS SS ‘S.A.&1. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19, 2020 --- OCR page 58 of 75 --- ™ EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 { ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "F" 4 Schedule 8(a), Report Of Prior Year's Expenditures PT FISCAL YEAR ENDING JUNE 30, 2019 [| DEPARTMENTS OF GOVERNMENT BALANCE ORIGINAL || ‘APPROPRIATED ACCOUNTS 6-30-2019 APPROPRIATIONS PT issueplarpropriationg | a SS | 92 EMERGENCY MEDICAL SERVICEBUDGETACCOUNT]] a Ce [ss gs J92d Maintenance and Operation js ss sas, 386.49 ne ee ee ee ee [ss gs ea |S |S FP SET) re a | | | | js ts ss pabParTimeHelp [ss ss E 3d Maintenance and Operation [ss ss [ss ss a Ce [ss ss |S | |S | a | | | [ss ss Sd loab Part Time Hel; Part Time Hel; > ™—~—CC*SC Is. | [ssi Iss i i——+ [ss ss Is is is ds CCS a es ee Ee Cs es PS EMERGENCY MEDICAL SERVICE AUDITBUDGET ACH Td 95a Salaries and Expense of Audit and Report [sis ss [s_ sss pSTow SC «dS «dS SSC Sd Sd Fn 98 OTHER USE: a | ee Es ee a TOTAL GENERAL FUND ACCOUNT [sis ds «CdS 385,09 SUBJECT TO WARRANT ISSUE: = GRAND TOTAL GENERAL FUND. [sss 285,386.09] ESTIMATE OF NEEDS FOR THE FISCAL YEAR. - Pro rata share of County Assessor's Budget as determined by County Excise Board GRAND TOTAL - General Fund = S.A.&l. Form 2631R97 Entity: Ottawa County, 58 ‘See Accountant's Report Wednesday, August 19,2020 | --- OCR page 59 of 75 --- = EMERGENCY MEDICAL SERVICE FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 a Page 4 FISCAL YEAR ENDING JUNE 30, 2020 FISCAL YEAR 2019-2020 | weramount | warrants [RESERVES | LAPSED | NEEDS AS | APPROVED By| " |L surpyementaL [or | issuep_| | BALANCE ESTIMATED BY ADJUSTMENTS APPROPRIATION) S| —SSSSS*«dU KNOWN TOBE| GOVERNING [EXCISE BOARD| ADDED [CANCELLED] || SSNENCUMBEREH] BOARD |__| ; [sss sss is i [ss iss sss Ts s ffs. sss ss sd [$ 44,209.35 | 44,209.35 [s- | Se I$ 525,360.16 | 525,360.16 Is i [s 4,235.68 | 4,235.68 [s 482,404.84 | 482,404.84 [$482,404.84 | 482,404.84 nfs sss sss is $4420935[$ = |[s__529,s9ssa|[s 52536016|/s = —*ds 4,235.68, ° == [sts ss ss js fs ss is ss fs eo ffs ss ss sss [ss ss ss ss a fs sss ss ss [ss sss ss [s__- is ts WS ss is a fe [sts sss sss [sts ss ss ss » fs = fs ss ss ss a a | Se (| js - [ss ss gs mS ss ss sss [ss sss gs [s__- is ts sss ss | | n [sts ss ss ss [ss ss sss » |S Js [sss ES (| [ss ss sg ss Ps ss sss eS es | [s_44,209.35|[$_-_|[S__ 529,595.84 $4,235.68 -—}—_} —___-—_|- — " [s__- Is - [ss _ [Sa4zop3s[s_ = Ws s29ses.ea][s 25 36016|/s -—~(S 4235.08 |[s 482,400.84 ][s 482,404.84 TT Estimate of [Approved by_] ; PF ees by County] p= Governing Board | Excise Board _| TS, TS 474,652.81 | Po—OCSCSC(C(C#C(C#C#C#C#N#SS~C*~*é*C;«TS2.OB‘S_7,752.03| wae r S.A.&. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 60 of 75 --- f SINKING FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 - ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "G" Pagel Ld etait Extension [CashonHandJune 30,2019 Sa linvestments Since Liquidated 0S | | | [COLLECTED AND APPORTIONED: Cd [2018 and Prior Ad Valorem Tax 0S 019 AdValoremTax CS [Protest Tax Refunds 0S . [Miscellaneous Receipts 0S [OTALRECEIPTS 0 TTTTCUdTC™CCSYCS SSC=*dS 28 | [TOTAL RECEIPTS AND BALANCES S07 DISBURSEMENTS Eee |S || interest Paid on Past-Due Coupons SC SC*d [Bonds Paid SS", linerestPaidonPast-DueBonds dS TTS [Commission Paid to Fiscal Agency-TransfertoGeneral S'S id [fransfer Que S92 linterest Paid on Such Judgments CdS SP linvestments Purchased CCC*ddSCCCOdYCSCSCSY Pudgments Paid Under 62 0.8. 1981, §435 Cid PPOTAL DISBURSEMENTS dS 10928 | . CASH BALANCE ONHAND JUNE 30,2020 SCSC—~*dYSCS iS ra . I [Cash Balance on Hand June 30,2020 0S Hegel Investments Properly Maturing CdS SY Pudgments Paid to Recover ByTaxLevy dS CSS [TOTAL LIQUID ASSETS (in Extension Column) —SSSSS—*dEC dS rr | = JDEDUCT MATURED INDEBTEDNESS: SS Ja:Past-Due Coupons OOS SY Pp.tnterest Accrued Thereon SiS CY = fe. PastDue Bonds TS fe-Interest Thereon After Last Coupon dS fe-Fiscal Agency Commissionon Above CdS CY [é Judgments and Interest Levied forButUnpaid CdS CY D [TOTAL Items a. Through f. (To Extension Column) did BALANCE OF ASSETS SUBJECT TO ACCRUALS ES 1] DEDUCT ACCRUAL RESERVES IF ASSETS SUFFICIENT: YY - lg Eamed UnmatuedInwerest SSCS fp. Acerual on Final Coupons SY ji Accrued on Unmatured Bonds dS (TOTAL Items g. Through i (To Extension Column) dE - [EXCESS OF ASSETS OVER ACCRUAL RESERVES dE dS S.A.&1. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report Wednesday, August 19, 2020 --- OCR page 61 of 75 --- Pr SINKING FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2019, to JUNE 30, 2020 ESTIMATE OF NEEDS FOR 2020-2021 EXHIBIT "G" Page 2 r [SINKING FUND] r a [ss - [sos r es Ce ee | rs ee r [se t [Schedule 7, 2019 Ad Valorem Tax Account - Sinking Funds j Net Value _$ = 0.000 Mills Amount [s f [ss Deductionss [so [so r [sos [ss [so [ | Net Balance 2019 Tax inProcessofCollectionor ——SOC~—“‘—*S*S*S*s~sC—C—C—C‘; CSTSSTSTSTSTSTSTCé«dC STC” [s_ | r [sven | Investments Barred Investments June 30, 2019 Purchased of Cost Premium Court Order June 30, 2019 a | SE [ a | En ES | a | S| [ss ss r a | | | | a a | | a | ES | r Se ES | | ES | | Fe ee TOTAL INVESTMENTS [$= SS ST r S.A.&I. Form 2631R97 Entity: Ottawa County, 58 See Accountant's Report ‘Wednesday, August 19, 2020| [OCR page 62 failed: Command '['pdftoppm', '-f', '62', '-l', '62', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p62']' died with .] [OCR page 63 failed: Command '['pdftoppm', '-f', '63', '-l', '63', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p63']' died with .] [OCR page 64 failed: Command '['pdftoppm', '-f', '64', '-l', '64', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p64']' died with .] [OCR page 65 failed: Command '['pdftoppm', '-f', '65', '-l', '65', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p65']' died with .] [OCR page 66 failed: Command '['pdftoppm', '-f', '66', '-l', '66', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p66']' died with .] [OCR page 67 failed: Command '['pdftoppm', '-f', '67', '-l', '67', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p67']' died with .] [OCR page 68 failed: Command '['pdftoppm', '-f', '68', '-l', '68', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p68']' died with .] [OCR page 69 failed: Command '['pdftoppm', '-f', '69', '-l', '69', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p69']' died with .] [OCR page 70 failed: Command '['pdftoppm', '-f', '70', '-l', '70', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p70']' died with .] [OCR page 71 failed: Command '['pdftoppm', '-f', '71', '-l', '71', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p71']' died with .] [OCR page 72 failed: Command '['pdftoppm', '-f', '72', '-l', '72', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p72']' died with .] [OCR page 73 failed: Command '['pdftoppm', '-f', '73', '-l', '73', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p73']' died with .] [OCR page 74 failed: Command '['pdftoppm', '-f', '74', '-l', '74', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p74']' died with .] [OCR page 75 failed: Command '['pdftoppm', '-f', '75', '-l', '75', '-r', '130', '-png', '/var/www/exposemiamiok/html/documents/ottawa-county-finance/ottawa-county-fy21.pdf', '/tmp/finance-ocr-9ydn6tlt/p75']' died with .]