Loading...
09 - September 2022 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS SEPTEMBER 2022 Village of Oak Brook  Monthly Financial Report – Fund Narrative  For the Period Ending September 30, 2022    The monthly financial report serves as a document to inform and update readers of the Village’s  financial  current  position,  including  historical  and  trend  information.    A  detailed  financial  statement and trend information is displayed for all Village major funds.  A fund is considered  major if it is the primary operating of the Village (General Fund) or meets the following criteria:     Total assets/deferred outflows of resources, liabilities/deferred inflows of resources,  revenues, or expenditures/expenses of that individual governmental or enterprise fund  are at least 10% of the total for all funds of the same category or type, and     The same element of the individual fund that met the 10% test is at least 5% of the  corresponding total for all funds combined.    This report is prepared on a cash basis of accounting, meaning transactions are recognized only  when cash is increased or decreased.  Transactions for each month are compared to amounts  from the Village’s annual budget, which was also prepared using the cash basis of accounting.   For the Village’s enterprise funds (Water and Sports Core), a reconciliation is included to display  results on a full accrual basis, which is how information is presented in the Village’s Annual  Comprehensive Financial Report (annual audit).    The proceeding pages contain detailed information on the Village’s major funds.  Highlights for  each of the Village’s funds are:    General Fund   Total revenues through September 2022 are $4,687,552, or 24.3%, higher than last  September, and $5,530,609, or 30.0%, over budget to date.  The main drivers for this  are:                                                                   o Sales  tax  revenue,  the  General  Fund’s largest revenue source, is  up $3,467,556 from last year and  $3,684,036  over  budget.  September 2022 collections came  in at the highest level in the past  five years.   o Other Intergovernmental Tax is up  $636,283  from  last  year  and  $883,959 over budget. Receipts from Income Tax and Replacement Tax came in  higher than anticipated in September.  $0.25 $0.50 $0.75 $1.00 $1.25 $1.50 2018 2019 2020 2021 2022 Sales Tax ‐ September  Collections Last 5 Years o The Telecommunication/Utility Tax is down $ 74,012 from last year and $48,356  over budget.                                                                                                                          Total expenditures through September 2022 are $819,420, or 5.2%, higher than last year  and $2,160,495 or 11.51%, under budget to date.      Hotel Tax Fund   Total revenues through September 2022 are $261,685, or 51.7%, higher than last year  and $167,769, or 27.9%, over budget to date.  The main drivers for this are:  o Hotel tax revenue is up $380,581 from last year and $175,765 over budget.   Hotel stay continues to recover from the effects of COVID‐19 on the travel  industry.     Total expenditures through September 2022 are $306,328 higher than last year and  $169,452 over budget.   o Operation and Contract expenditures are up $256,283, or 328.7%, from last year  and $116,757 over budget.    Infrastructure Fund   Total revenues through September 2022 are up $1,772,477, or 40.3%, from last year and  $972,747 or 15.7%, over budget.  The main drivers for this are:                                                                                            o Non‐home rule sales tax revenue is up $1,196,880 from last year, and $1,206,123  over  budget.    September  2022  collections came in at the highest level  in the past five years.      Total expenditures through September 2022  are down $513,645 or 7.1%, from last year and  $2,603,470 or 27.8%, under budget to date.   The main drivers for this are:  o Operation and contract expenditures  are down $305,595 from last year and  $423,557 under budget.    o Capital Outlay is down $158,768 from last year and $2,141,529 under budget.    Promenade TIF Fund   Total revenues through September 2022 are down $59,900 or 12.7%, from last year and  $41,457 under budget.  Revenues are under budget due to the timing of information to  record the TIF sale tax transfer.     $0 $250 $500 $750 2018 2019 2020 2021 2022 Non‐Home Rule Sales Tax ‐ September Collections Last 5  Years  Total expenditures through September 2022 are up $1,572 from last year and $119,094  over budget.  The increase relates to timing in payment of notes payable compared to last  year.          Water Fund   Total revenues through September 2022 are up $705,248, or 7.8% higher than last year  and $1,713,992, or 21.33%, over budget.     Total expenditures through September 2022 are down $4,554,872, or 52.1%, from last  year and $33,337,342 or 44.31%, under budget.  The main drivers for this are:  o Personnel expenditures are down $256,889 from last year and $159,642 under  budget.    o Capital outlay expenditures are down $4,555,969 from last year.       Sports Core Fund   Total revenues through September 2022 are up $748,958 or 21.7% higher than last year  and $891,446, over budget to date.  The main drivers for this are:  o Membership revenue is up $453,263 from last year and $207,751 over budget.    o Rentals are up by $186,722 from last year and $109,871 over budget.     Total expenditures through September 2022 are up $87,858, or 3.1%, from last year, and  $31,336, or 0.82% over budget to date.  The main drivers for this are:    o Personnel expenditure are down $41,705 from last year and $158,565 under  budget.  o Operation and contract expenditures are higher $397,978 from last year and  $126,895 over budget.  o Capital outlay expenditures are down $304,438 from last year, and $9,832 under  budget.  YTD YTD Net Fund Budgeted YTD YTD Increase Increase Governmental Funds Revenues Expenditures (Decrease)(Decrease) General Fund (Major Fund)24,388,087$ 16,699,476$ 7,688,611$ (2,493)$ Main operating fund of the Village. Hotel Fund (Major Fund)768,144$ 442,141$ 326,003$ 175,755$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 416,802$ -$ 416,802$ 157,960$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)6,415,202$ 6,842,077$ (426,876)$ (3,685,571)$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)412,744$ 486,710$ (73,966)$ 3,671$ Accounts for the revenues and expenditures restricted to the Tax Increment Financing (TIF) district located at 22nd St. and Meyers Rd. Enterprise Funds Water Fund (Major Fund)9,750,617$ 4,510,198$ 5,240,418$ 189,086$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)4,206,465$ 2,937,774$ 1,268,690$ 521,081$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 126,382$ -$ 126,382$ 66,499$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 2,171,700$ 2,076,462$ 95,238$ 30,809$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 468,159$ 495,778$ (27,619)$ (19,713)$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 643,718$ 554,573$ 89,145$ 37,262$ Accounts for the replacement of the Village's vehicle fleet and the related departmental contributions. Further information on the Village's major funds (as indicated above) can be found on the proceeding pages. Executive Summary on Village Funds Through September 30, 2022 9/30/22 9/30/22 9/30/21 9/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 10,116,480$   13,584,036     9,900,000$       137.2% 13,200,000$     3,467,556$       Other Intergovernmental Tax* 1,458,476       2,097,759       1,213,800         172.8% 1,618,400         639,283             Telecommunications/Utility Tax 4,318,618       4,244,606       4,196,250         101.2% 5,595,000         (74,012)             Grants 39,301             22,507             11,250               200.1% 15,000               (16,794)             Licenses and Permits 1,617,125       1,849,667       1,505,633         122.8% 2,007,510         232,542             Charges for Services 1,051,698       1,459,425       866,175             168.5% 1,154,900         407,727             Fines and Penalties 113,267           166,700           106,500             156.5% 142,000             53,433               Administrative Towing Fees 22,550             38,350             18,750               204.5% 25,000               15,800               Investment Interest 138,110           171,303           108,000             158.6% 144,000             33,193               Franchise Fees 106,146           166,134           148,500             111.9% 198,000             59,988               Installment Contract Proceeds ‐                         N/A ‐                         Miscellaneous Income 294,846           163,682           358,703             45.6% 478,270             (131,164)           Total Operating Revenues 19,276,617$   23,964,169$   18,433,560$     130.0% 24,578,080$     4,687,552$       OPERATING EXPENDITURES Personnel 12,902,807$   13,055,925$   14,601,187$     89.4% 19,468,249$     153,118$          Materials and Supplies 293,048           332,682           429,409             77.5% 572,545             39,634$             Operation and Contract 2,394,868       2,949,432       2,688,540         109.7% 3,584,720         554,564$          Other Expenditures 6,457               4,290               89,160               4.8% 118,880             (2,168)$             Capital Outlay 200,463           274,733           969,263             28.3% 1,292,350         74,270$             Total Operating Expenditures 15,797,643$   16,617,063$   18,777,558$     88.5% 25,036,744$     819,420$          SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 3,478,974$     7,347,106$     (343,998)$         ‐2135.8% (458,664)$         3,868,132$       INTERFUND TRANSACTIONS Transfers In ‐$                 ‐$                 ‐$                   N/A ‐$                   ‐$                   Transfers Out ‐                   N/A ‐                     Reimbursements From Other Funds 445,257           423,918           423,915             100.0% 565,220             (21,339)             Reimbursements To Other Funds (79,416)            (82,413)            (82,410)             100.0% (109,880)           (2,997)                Sports Core Loan ‐                   N/A ‐                     ‐                     Total Interfund Transactions 365,841$        341,505$        341,505$          100.0% 455,340$          (24,336)$           NET FUND INCREASE (DECREASE) 3,844,815$     7,688,611$    (2,493)$            (3,324)$             3,843,796$      *Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax. Village of Oak Brook General Fund Financial Update For the Period Ending September 30, 2022 Total Total Revenues Expenditures 9/30/22 Actual 23,964,169$         16,617,063$         9/30/21 Actual 19,276,617$         15,797,643$         % Change From Last Year 24.3% 5.2% Major Revenues Other Telecom/Utility Licenses & Charges for Sales Tax Intergov. Tax Tax Permits Services 9/30/22 Actual 13,584,036$         2,097,759$            4,244,606$            1,849,667$            1,459,425$            9/30/21 Actual  $        10,116,480   $          1,458,476   $          4,318,618   $          1,617,125   $          1,051,698  % Change From Last Year 34.3% 43.8% ‐1.7% 14.4% 38.8% Five Year Trend Major Expenditures Materials & Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 9/30/22 Actual 13,055,925$         332,682$               2,949,432$            4,290$                   274,733$               9/30/21 Actual 12,902,807$         293,048$               2,394,868$            6,457$                   200,463$               % Change From Last Year 1.2% 13.5% 23.2% ‐33.6% 37.0% Five Year Trend Expenditures by Department 9/30/21 9/30/22 9/30/22 9/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 1,806,636$            555,048$               784,905$               70.7% 3,002,480$            (1,251,588)$          Financial Services 557,828                 207,071                 194,640                 106.4% 827,030                 (350,757)                Public Works 655,875                 157,826                 183,560                 86.0% 928,765                 (498,049)                Engineering & Capital Projects 22,418                   11,172                   139,000                 8.0% 384,000                 (11,246)                  Library 637,585                 233,222                 239,800                 97.3% 996,145                 (404,363)                Police 6,213,517              2,185,963              2,336,800              93.5% 9,869,105              (4,027,554)            Fire 5,191,220              1,611,145              1,872,020              86.1% 7,922,040              (3,580,075)            Development Services 712,564                 222,207                 250,015                 88.9% 1,094,285              (490,357)                Total Expenditures 15,797,643$         16,617,063$         18,777,558$         88.5% 25,036,744$         (10,613,988)$        Five Year Trend For the Period Ending September 30, 2022 General Fund ‐ Five Year Trend Village of Oak Brook Revenues Expenditures 9/30/22 9/30/22 9/30/21 9/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 475,309$           755,890$         580,125$           130.3% 773,500$           280,581$           Investment Interest 25,878               12,253             15,750               77.8% 21,000               (13,625)              Loan Interest 4,000                 ‐                   4,500                 0.0% 6,000                 (4,000)                Miscellaneous 1,272                (1,272)                Total Operating Revenues 506,459$           768,144$        600,375$           127.9% 800,500$           261,685$           EXPENDITURES Operation and Contract 77,963$             334,246$         217,489$           153.7% 289,985$           256,283$           Capital Outlay 2,650                 52,695             ‐                      N/A ‐                      50,045               Total Expenditures 80,613$             386,941$        217,489$           177.9% 289,985$           306,328$           SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 425,846$           381,203$        382,886$           99.6% 510,515$           (44,643)$           INTERFUND TRANSACTIONS Transfer Out (2,383,612)$      ‐$                 (145,031)$         0.0% (193,375)$         2,383,612$       Reimbursements to Other Funds (63,063)              (55,200)            (62,100)              88.9% (82,800)              7,863                 Total Interfund Transactions (2,446,675)$      (55,200)$         (207,131)$         26.6% (276,175)$         2,391,475$       NET FUND INCREASE (DECREASE) (2,020,829)$      326,003$        175,755$           234,340$           2,346,832$       Note ‐ Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending September 30, 2022 Total Total Revenues Expenditures 9/30/22 Actual  $              768,144 386,941$                9/30/21 Actual  $              506,459 80,613$                  % Change From Last Year 51.7% 380.0% Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 9/30/22 Actual  $              755,890  $                 12,253 ‐$                        ‐$                        9/30/21 Actual  $              475,309  $                 25,878 4,000$                    1,272$                    % Change From Last Year 59.0% ‐52.6% 0.0% 0.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 9/30/22 Actual 334,246$                52,695$                  9/30/21 Actual 77,963$                  2,650$                    % Change From Last Year 328.7% N/A Five Year Trend Village of Oak Brook Hotel Tax Fund ‐ Major Sources Five Year Trend For the Period Ending September 30, 2022 Five Year Trend 2018 2019 2020 2021 2022 Revenues Expenditures 9/30/22 9/30/22 9/30/21 9/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non‐Home Rule Sales Tax 4,370,493$   5,567,373$    4,361,250$       127.7% 5,815,000$       1,196,880$       Charges for Services ‐                  ‐                     N/A ‐$                   Investment Interest 25,421            55,297            20,625               268.1% 27,500               29,876               Grants ‐                       550,000          817,298            67.3% 1,089,730         550,000            Miscellaneous 4,279              ‐                       750                    0.0% 1,000                 (4,279)                Total Operating Revenues 4,400,193$   6,172,670$    5,199,923$       118.7% 6,933,230$       1,772,477$       OPERATING EXPENDITURES Personnel 1,005,235$   959,830$        969,626$          99.0% 1,292,835$       (45,405)$           Materials and Supplies 145,239         141,361          169,950            83.2% 226,600            (3,878)                Operation and Contract 1,179,673      874,078          1,297,635         67.4% 1,730,180         (305,595)           Other Expenditures ‐                     N/A ‐                     Capital Outlay 4,936,979      4,778,211      6,919,740         69.1% 9,226,320         (158,768)           Total Operating Expenditures 7,267,126$   6,753,481$    9,356,951$       72.2% 12,475,935$    (513,645)$         SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (2,866,933)$  (580,812)$      (4,157,029)$     14.0% (5,542,705)$     2,286,121$       INTERFUND TRANSACTIONS Transfers In 2,383,612$   ‐$                 317,531$          0.0% 423,375$          (2,383,612)$     Reimbursements From Other Funds 248,886         242,532          242,524            100.0% 323,365            (6,354)                Reimbursements To Other Funds (132,228)        (88,596)           (88,598)             100.0% (118,130)           43,632               Total Interfund Transactions 2,500,270$   153,936$       471,458$          32.7% 628,610$          (2,346,334)$     NET FUND INCREASE (DECREASE) (366,663)$     (426,876)$     (3,685,571)$    (4,914,095)$     (60,213)$          Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending September 30, 2022 Total Total Revenues Expenditures 9/30/22 Actual  $          6,172,670 6,753,481$           9/30/21 Actual  $          4,400,193 7,267,126$           % Change From Last Year 40.3% ‐7.1% Major Revenues Sales Tax Charges for  Services Investment  Interest Miscellaneous 9/30/22 Actual  $          5,567,373   $                         ‐    $                55,297  $                         ‐    9/30/21 Actual  $          4,370,493   $                         ‐    $                25,421  $                         ‐    % Change From Last Year 27.4% 0.0% 117.5% 0.0% Five Year Trend Major Expenditures Materials & Operation & Personnel Supplies Contractual Capital Outlay 9/30/22 Actual 959,830$               141,361$               874,078$               4,778,211$           9/30/21 Actual 1,005,235$           145,239$               1,179,673$           4,936,979$           % Change From Last Year ‐4.5% ‐2.7% ‐25.9% ‐3.2% Five Year Trend Expenditures by Department 9/30/21 9/30/22 9/30/22 9/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 85,246$                 28,892$                 52,010$                 55.5% 209,510$               (56,355)$                Public Works 651,848                 589,033                 584,365                 100.8% 2,380,195              (926,197)                Engineering & Capital Projects 768,463                 98,940                   706,825                 14.0% 9,886,230              (3,396,070)            Total Expenditures 1,505,557$           716,864$               1,343,200$           53.4% 12,475,935$          (4,378,622)$          Five Year Trend Village of Oak Brook Infrastructure Fund ‐ Major Sources Five Year Trend For the Period Ending September 30, 2022 Revenues Expenditures Village of Oak BrookMonthly Operating StatementSports Core Fund Consolidated PresentationFor the Period Ending September 30, 20229/30/22 9/30/229/30/22 YTD % of YTD 2022 9/30/21 DifferenceB&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD PriorOperations Operations Operations Club Total Budget Budget Budget Total YearOPERATING REVENUESMemberships 402,838$             ‐$                     ‐$                     406,225$             809,063$             601,313$             134.5% 801,750$             355,800$             453,263$            Greens Fees ‐                       ‐                       ‐                       1,089,321            1,089,321            858,750               126.8% 1,145,000            1,146,479            (57,158)               Pro Shop Sales ‐                       ‐                       ‐                       190,219               190,219               157,500               120.8% 210,000               202,254               (12,035)               Golf Lessons ‐                       ‐                       ‐                       41,695                 41,695                 37,500                 111.2% 50,000                 46,755                 (5,060)                 Driving Range Fees ‐                       ‐                       ‐                       330,936               330,936               225,000               147.1% 300,000               327,073               3,863                  Rentals ‐                       208,643               254,460               392,099               855,202               745,331               114.7% 993,775               668,480               186,722              Programs/User Fees 78,680                 ‐                       ‐                       ‐                       78,680                 11,625                 676.8% 15,500                 ‐                       78,680                Food Sales 44,287                 ‐                       ‐                       238,627               282,914               214,500               131.9% 286,000               250,155               32,759                Beverage Sales 17,712                 ‐                       ‐                       427,162               444,874               367,500               121.1% 490,000               440,564               4,310                  Taste of Oak Brook ‐                       66,812                 ‐                       ‐                       66,812                 90,000                 74.2% 120,000               ‐                       66,812                Grants ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       N/A ‐                       ‐                       ‐                      Other Revenue 2,359                   ‐                       ‐                       14,392                 16,751                 6,000                   279.2% 8,000                   19,947                 (3,196)                 Total Operating Revenues 545,875$            275,455$            254,460$             3,130,674$         4,206,465$         3,315,019$         126.9% 4,420,025$         3,457,507$         748,958$            OPERATING EXPENDITURESPersonnel 64,155$               ‐$                     96,118$               934,697$             1,094,970$          1,253,535$          87.4% 1,671,380$          1,136,675$          (41,705)$             Materials & Supplies 58,718                 ‐                       6,367                   546,927               612,013               539,175               113.5% 718,900               575,990               36,023                Operational & Contractual 282,230               203,055               61,123                 287,560               833,969               707,074               117.9% 942,765               435,991               397,978              Other ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       N/A ‐                       ‐                       ‐                      Capital 232,016               ‐                       ‐                       108,214               340,230               350,063               97.2% 466,750               644,668               (304,438)             Total Operating Expenditures 637,120$            203,055$            163,609$             1,877,398$         2,881,182$         2,849,846$         101.1% 3,799,795$         2,793,324$         87,858$              B&T Administration Overhead Allocation* 12,352$               ‐$                     (12,352)$              ‐$                     (0)$                         ‐$                     N/A ‐$                     9,997$                 9,997$                Operating Revenues Over (Under) Expenditures (78,893)$             72,399$               78,500$               1,253,276$         1,325,282$         465,173$             284.9% 620,230$             674,180$             671,096$            INTERFUND TRANSACTIONSInterfund Loan** ‐$                     ‐$                     ‐$                     ‐$                     ‐$                     ‐$                     N/A ‐$                     ‐$                     ‐$                    Transfer From General Fund ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       N/A ‐                       ‐                       ‐                      Transfer From Golf Surcharge Fund ‐                       ‐                       ‐                       ‐                       ‐                       112,500               0.0% 150,000               ‐                       ‐                      Reimbursement From Infrastructure Fund ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       N/A ‐                       24,003                 (24,003)               Reimbursement From Water Fund ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       N/A ‐                       6,003                   (6,003)                 Reimbursement To General Fund (14,148)                ‐                       ‐                       (42,444)                (56,592)                (56,591)                100.0% (75,455)                (47,169)                (9,423)                 Total Interfund Transactions (14,148)$             ‐$                     ‐$                     (42,444)$              (56,592)$              55,909$               ‐101.2% 74,545$               (17,163)$              (39,429)$             Total Revenues Over (Under) Expenditures ‐ Budgetary Basis(93,041)$             72,399$               78,500$               1,210,832$          1,268,690$          521,081$             694,775$             657,017$             631,667$            ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay 232,016$             ‐$                     ‐$                     108,214$             340,230$             644,668$            Depreciation Expense (126,170)             (1,264)                  (25,000)                (184,725)              (337,159)              (357,159)             IMRF Pension Expense (1,538)                  ‐                       (1,250)                  (18,375)                (21,163)                (22,163)               OPEB Expense ‐                       ‐                       (1,250)                  (21,000)                (22,250)                (23,250)               Total GAAP Adjustments 104,308$            (1,264)$               (27,500)$              (115,886)$           (40,341)$              242,097$            Fund Increase/(Decrease) ‐ GAAP Basis 11,268$               71,136$               51,000$               1,094,946$         1,228,349$         899,114$            *Overhead allocation is comprised of salaries, business forms, liability insurance, building &  grounds maintenance and bank service fees in Program 811 ‐ Sports Core General Operations distributed to various Sports Core Programs on a % basis.**Estimates based on historical year‐end audit adjustments.  Actual amounts are not measured and recorded until the end of the year. Total Direct Total Direct Revenues Expenditures 9/30/22 Actual  $          4,206,465 2,881,182$            9/30/21 Actual  $          3,457,507 2,793,324$            % Change From Last Year 21.7% 3.1% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 9/30/22 Actual  $             809,063   $          1,089,321   $             330,936   $             855,202 78,680$                 9/30/21 Actual  $             355,800   $          1,146,479   $             327,073   $             668,480 ‐$                       % Change From Last Year 127.4% ‐5.0% N/A 27.9% 0.0% Five Year Trend Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 9/30/22 Actual 1,094,970$            612,013$               833,969$               ‐$                       340,230$               9/30/21 Actual 1,136,675$            575,990$               435,991$               ‐$                       644,668$               % Change From Last Year ‐3.7% 6.3% 91.3% 0.0% ‐47.2% Five Year Trend Revenues by Department 9/30/21 9/30/22 9/30/22 9/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 8,518$                   545,875$               391,088$               139.6% 521,450$               475,359$               Open Field Operations 102,500                 275,455                 281,250                 97.9% 375,000                 106,143                 B&T Clubhouse Operations 124,417                 254,460                 263,456                 96.6% 351,275                 130,043                 Golf Club 3,222,072              3,130,674              2,379,225              131.6% 3,172,300              (91,398)                  Total Revenues 3,457,507$           4,206,465$           3,315,019$           126.9% 4,420,025$           620,147$               Expenditures by Department 9/30/21 9/30/22 9/30/22 % of YTD 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 401,172$               637,120$               425,385$               149.8% 567,180$               235,948$               Open Field Operations 240,728$               203,055$               187,995$               108.0% 250,660$               (37,673)$                B&T Clubhouse Operations 143,801                 163,609                 223,650                 73.2% 298,200                 19,808                   Golf Club 2,007,623              1,877,398              2,012,816              93.3% 2,683,755              (130,225)                Total Expenditures 2,793,324$           2,881,182$           2,849,846$           101.1% 3,799,795$           87,858$                 Five Year Trend Village of Oak Brook Sports Core Fund ‐ Major Sources Five Year Trend For the Period Ending September 30, 2022 Revenues Expenditures Village of Oak BrookMonthly Operating StatementBath & Tennis Club Recreation OperationsFor the Period Ending September 30, 20229/30/22 9/30/22822 9/30/22 YTD % of YTD 2022 9/30/21 Difference811 812 813 Poolside YTD Amended Amended Adopted YTD PriorB&T Admin Swimming Tennis Café Total Budget Budget Budget Total YearOPERATING REVENUESMemberships ‐$                   377,263$           25,575               ‐                     402,838$           336,713$           119.6% 448,950$           ‐$                   402,838$          Programs/User Fees ‐                     40,416               38,264               ‐                     78,680               11,625.00          676.8% 15,500               ‐                     78,680              Food Sales ‐                     ‐                     ‐                     44,287               44,287               27,000.00          164.0% 36,000               ‐                     ‐                    Beverage Sales ‐                     ‐                     ‐                     17,712               17,712               15,000.00          118.1% 20,000               ‐                     ‐                    Grants ‐                     ‐                     ‐                     ‐                     ‐                          ‐                     N/A ‐                     ‐                     ‐                    Other Revenue 2,359                 ‐                     ‐                     ‐                     2,359                 750                    314.5% 1,000                 8,518                 (6,159)               Total Operating Revenues 2,359$               417,679$           63,839$             61,998$             545,875$           391,088$           139.6% 521,450$           8,518$               475,359$          OPERATING EXPENDITURESPersonnel 16,517$             12,211$             ‐$                       35,427$             64,155$             95,513$             67.2% 127,350$           16,251$             47,904$            Materials & Supplies 432                    20,031               6,574                 31,681               58,718               55,913               105.0% 74,550               27,425               31,293              Operational & Contractual 23,266               200,135             52,793               6,036                 282,230             230,648             122.4% 307,530             88,195               194,035            Other ‐                     ‐                     ‐                          ‐                     N/A ‐                     ‐                    Capital ‐                     231,266             750                    ‐                     232,016             43,313               535.7% 57,750               269,301             (37,285)             Total Operating Expenditures 40,215$             463,643$           60,118$             73,144$             637,120$           425,385$           149.8% 567,180$           401,172$           235,948$          B&T Administration Overhead Allocation* 24,703$             (8,893)$              (2,470)$              (988)$                 12,352$             ‐$                   N/A 68,810$             30,312$             (17,960)$           Operating Revenues Over (Under) Expenditures (13,153)$           (54,857)$           1,251$               (12,133)$           (78,893)$           (34,298)$           230.0% 23,080$             (362,342)$         221,451$          Transfer From General Fund ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     N/A ‐                     ‐                    Reimbursement From Infrastructure Fund ‐                     ‐                     ‐                     ‐                     ‐                     ‐$                   N/A ‐                     24,003               (24,003)             Reimbursement From Water Fund ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     N/A ‐                     6,003                 (6,003)               Reimbursement To General Fund (14,148)              ‐                     ‐                     ‐                     (14,148)              (14,149)              100.0% (18,865)              (11,790)              (2,358)               Total Interfund Transactions (14,148)$           ‐$                   ‐$                   ‐$                   (14,148)$           (14,149)$           100.0% (18,865)$           18,216$             (32,364)$          Total Revenues Over (Under) Expenditures ‐ Budgetary Basis (27,301)$           (54,857)$           1,251$               (12,133)$           (93,041)$           (48,446)$           4,215$               (344,126)$         189,087$          ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay ‐$                   231,266$           750$                  ‐$                   232,016$           269,301$          Depreciation Expense (48,269)              (75,000)              (2,025)                (876)                   (126,170)            (126,170)           IMRF Pension Expense (1,500)                ‐                     ‐                     (38)                     (1,538)                (1,538)               Total GAAP Adjustments (49,769)$           156,266$           (1,275)$              (914)$                 104,308$           141,593$          Fund Increase/(Decrease) ‐ GAAP Basis (77,071)$           101,410$           (24)$                   (13,047)$           11,268$             (202,533)$        *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 ‐ Sports Core General Operations distributed to various Sports Core Programs ona percentage basis.**Estimates based on historical year‐end audit adjustments.  Actual amounts are not measured and recorded until the end of the year. Village of Oak BrookMonthly Operating StatementOpen Fields OperationsFor the Period Ending September 30, 2022 9/30/22 9/30/229/30/22 YTD % of YTD 2022 9/30/21 Difference815 816 YTD Amended Amended Adopted YTD PriorPolo Open Fields Total Budget Budget Budget Total YearOPERATING REVENUESField Rentals ‐$                    128,643$           128,643$           127,500$           100.9% 170,000$           22,500$             106,143$          Range Rentals ‐                      80,000               80,000               63,750               125.5% 85,000               80,000               ‐                     Taste of Oak Brook ‐                      66,812               66,812               90,000               74.2% 120,000             ‐                      ‐                     Other Revenue ‐                      ‐                      ‐                      N/A ‐                      ‐                      ‐                     Total Operating Revenues ‐$                   275,455$           275,455$           281,250$           97.9% 375,000$           102,500$           106,143$          OPERATING EXPENDITURESPersonnel ‐$                    ‐$                    ‐$                    ‐$                    N/A ‐$                    ‐$                   Materials & Supplies ‐                      ‐                      ‐                      1,125                  0.0% 1,500$               ‐                      ‐                     Operational & Contractual 199                     202,856             203,055             186,870             108.7% 249,160             8,053                  195,002            Capital ‐                      ‐                      ‐                      N/A 232,675             (232,675)           Total Operating Expenditures 199$                   202,856$           203,055$           187,995$           108.0% 250,660$           240,728$           (37,673)$           Operating Revenues Over (Under) Expenditures (199)$                 72,599$             72,399$             93,255$             77.6% 124,340$           (138,228)$          143,815$          INTERFUND TRANSACTIONSTransfer From Hotel Tax Fund ‐$                    ‐$                    ‐$                    ‐$                    N/A ‐$                    ‐$                    ‐$                   Total Interfund Transactions ‐$                   ‐$                   ‐$                   ‐$                   N/A ‐$                   ‐$                   ‐$                  Total Revenues Over (Under) Expenditures ‐ Budgetary Basis (199)$                72,599$            72,399$            93,255$             124,340$          (138,228)$         143,815$         ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay ‐$                    ‐$                    ‐$                    232,675$          Depreciation Expense ‐                      (1,264)                (1,264)                (1,264)               Total GAAP Adjustments ‐$                   (1,264)$              (1,264)$              231,411$          Fund Increase/(Decrease) ‐ GAAP Basis (199)$                71,335$            71,136$            93,183$           *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 ‐ Sports Core General Operations distributed tovarious Sports Core Programs on a percentage basis.**Estimates based on historical year‐end audit adjustments.  Actual amounts are not measured and recorded until the end of the year. Village of Oak BrookMonthly Operating StatementBath & Tennis Clubhouse OperationsFor the Period Ending September 30, 20229/30/22 9/30/22821 YTD % of YTD 2022 9/30/21 DifferenceB&T  Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total YearOPERATING REVENUESRentals 254,460$           263,456$           96.6% 351,275$           124,417$           130,043$          Total Operating Revenues 254,460$           263,456$           96.6% 351,275$           124,417$           130,043$          OPERATING EXPENDITURESPersonnel 96,118$              105,188$           91.4% 140,250$           89,286$              6,832$               Materials & Supplies 6,367                  11,513                55.3% 15,350                5,636                  731                    Operational & Contractual 61,123                69,450                88.0% 92,600                44,497                16,626               Capital ‐                      37,500                0.0% 50,000                4,382                  (4,382)                Total Operating Expenditures 163,609$           223,650$           73.2% 298,200$           143,801$           19,808$             B&T Administration Overhead Allocation* (12,352)$            ‐$                    N/A (68,810)$            (20,315)$            7,963$               Operating Revenues Over (Under) Expenditures 78,500$              39,806$              197.2% (15,735)$            (39,699)$            118,199$          INTERFUND TRANSACTIONSTransfer From General Fund ‐$                    ‐$                    0.0% ‐$                    ‐$                    ‐$                   Total Interfund Transactions ‐$                    ‐$                   0.0%‐$                    ‐$                    ‐$                   Total Revenues Over (Under) Expenditures ‐ Budgetary Basis 78,500$             39,806$             (15,735)$           (39,699)$           118,199$         ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay ‐$                    4,382$               Depreciation Expense (25,000)              (45,000)             IMRF Pension Expense (1,250)                 (2,250)                OPEB Expense (1,250)                 (2,250)                Total GAAP Adjustments (27,500)$            (45,118)$           Fund Increase/(Decrease) ‐ GAAP Basis 51,000$             (84,817)$          *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 ‐ Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.**Estimates based on historical year‐end audit adjustments.  Actual amounts are not measured and recorded until the end of the year. Village of Oak BrookMonthly Operating StatementGolf Club ProgramsFor the Period Ending September 30, 20229/30/22 9/30/22823 831 832 833 834 9/30/22 YTD % of YTD 2022 9/30/21 DifferenceGolf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD PriorCafé Operation & Practice Operations Maintenance Total Budget Budget Budget Total YearOPERATING REVENUESMemberships ‐$                   406,225$           ‐$                   ‐$                   ‐$                   406,225$           264,600$           153.5% 352,800$           355,800$           50,425$            Greens Fees ‐                     1,089,321          ‐                     ‐                     ‐                     1,089,321          858,750             126.8% 1,145,000          1,146,479          (57,158)             Pro Shop Sales ‐                     190,219             ‐                     ‐                     ‐                     190,219             157,500             120.8% 210,000             202,254             (12,035)             Golf Lessons ‐                     ‐                     41,695               ‐                     ‐                     41,695               37,500               111.2% 50,000               46,755               (5,060)               Driving Range Fees ‐                     ‐                     330,936             ‐                     ‐                     330,936             225,000             147.1% 300,000             327,073             3,863                Rentals ‐                     2,750                 ‐                     389,349             ‐                     392,099             290,625             134.9% 387,500             441,563             (49,464)             Food Sales 238,627             ‐                     ‐                     ‐                     ‐                     238,627             187,500             127.3% 250,000             250,155             (11,528)             Beverage Sales 427,162             ‐                     ‐                     ‐                     ‐                     427,162             352,500             121.2% 470,000             440,564             (13,402)             Other Revenue 14,340               52                       ‐                     ‐                     ‐                     14,392               5,250                 274.1% 7,000                 11,429               2,963                Total Operating Revenues 680,129$           1,688,566$        372,631$           389,349$           ‐$                   3,130,674$        2,379,225$        131.6% 3,172,300$        3,222,072$        (91,398)$           OPERATING EXPENDITURESPersonnel 188,696$           401,380$           47,632$             36,062$             260,927$           934,697$           1,052,835$        88.8% 1,403,780$        1,031,138$        (96,441)$           Materials & Supplies 244,467             128,045             15,986               1,449                 156,979             546,927             470,625             116.2% 627,500             542,929             3,998                Operational & Contractual 4,131                 182,343             4,981                 54,380               41,725               287,560             220,106             130.6% 293,475             295,246             (7,686)               Other ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     N/A ‐                     ‐                     ‐                    Capital ‐                     108,214             ‐                     ‐                     ‐                     108,214             269,250             40.2% 359,000             138,310             (30,096)             Total Operating Expenditures 437,294$           819,982$           68,600$             91,891$             459,632$           1,877,398$        2,012,816$        93.3% 2,683,755$        2,007,623$        (130,225)$         Operating Revenues Over (Under) Expenditures 242,835$           868,585$           304,031$           297,457$           (459,632)$          1,253,276$        366,409$           342.0% 488,545$           1,214,449$        38,827$            INTERFUND TRANSACTIONSTransfer from Golf Surcharge ‐$                   ‐$                   ‐$                   ‐$                   ‐$                   ‐$                   112,500$           0.0% 150,000$           ‐$                   ‐$                  Reimbursement to General Fund ‐                     (42,444)              ‐                     ‐                     ‐                     (42,444)              (42,443)              100.0% (56,590)              (35,379)              (7,065)               Total Interfund Transactions ‐$                   (42,444)$            ‐$                   ‐$                   ‐$                   (42,444)$            70,058$             ‐60.6% 93,410$             (35,379)$            (7,065)$             Total Revenues Over (Under) Expenditures ‐ Budgetary Basis 242,835$           826,141$           304,031$           297,457$           (459,632)$          1,210,832$        436,466$           581,955$           1,179,070$        31,762$            ADUSTMENTS TO GAAP BASIS*Remove Capital Outlay ‐$                   108,214$           ‐$                   ‐$                   ‐$                   108,214$           138,310$          Depreciation Expense (750)                   (78,750)              (1,725)                (9,750)                (93,750)              (184,725)            (184,725)           IMRF Pension Expense (1,875)                (7,500)                (750)                   ‐                     (8,250)                (18,375)              (18,375)             OPEB Expense (2,250)                (11,250)              ‐                     ‐                     (7,500)                (21,000)              (21,000)             Total GAAP Adjustments (4,875)$              10,714$             (2,475)$              (9,750)$              (109,500)$          (115,886)$          (85,790)$           Fund Increase/(Decrease) ‐ GAAP Basis 237,960$           836,855$           301,556$           287,707$           (569,132)$          1,094,946$        1,093,280$       *Estimates based on historical year‐end audit adjustments.  Actual amounts are not measured and recorded until the end of the year.