|
2024 BUDGET SHEET
<br />Fund: Liquor
<br />Detail of Revenues/Expenses
<br />2020
<br />Actual
<br />2021
<br />Actual
<br />2022 2023
<br />Actual BUDGET
<br />6/30/2023 2024
<br />Actual BUDGET
<br />REVENUES:
<br />Sales
<br />Cost of Sales
<br />GROSS PROFIT
<br />Other Revenue
<br />Interest
<br />Delivery Fee
<br />Misc. Revenue
<br />Transfer In
<br />TOTAL LIQUOR REVENUE
<br />EXPENDITURES:
<br />PERSONAL SERVICES
<br />Regular Pay
<br />Overtime Pay
<br />Part-time Pay
<br />PERA
<br />FICA
<br />Other Retirement Contributions
<br />Medicare
<br />Insurance
<br />Workers Comp
<br />Unemployment Compensation
<br />TOTAL PERSONAL SERVICES
<br />SUPPLIES
<br />Fuel & Lubes
<br />Uniform Allowance
<br />Operating Supplies
<br />TOTAL SUPPLIES
<br />SERVICES & CHARGES
<br />Audit Fees
<br />Telephone
<br />Conferences/Schools
<br />Advertising/Marketing
<br />Insurance
<br />Utilities
<br />Maintenance/Software
<br />Depreciation
<br />Dues/Subscriptions
<br />Taxes & Licenses
<br />Credit Card Fees
<br />Miscellaneous
<br />TOTAL SERVICES & CHARGES
<br />CAPITAL OUTLAY
<br />DEBT SERVICE
<br />TRANSFERS OUT
<br />General Fund
<br />Park Improvement Fund
<br />SCBA Funding
<br />TOTAL LIQUOR EXPENDITURES
<br />CHANGE IN NET POSITION
<br />CASH BALANCE - BEGINNING
<br />CASH BALANCE - ENDING
<br />CASH FLOW RESERVE
<br />7,923,581
<br />8,613,070
<br />8,528,136 6,816,250
<br />3,813,186 8,161,000
<br />(5,679,210)
<br />(6,234,978)
<br />(6,191,509) (4,937,100)
<br />(2,597,582) (6,028,000)
<br />2,244,371
<br />215,253
<br />2,378,092
<br />(67,485)
<br />2,336,627 1,879,150
<br />(489,851) 100,000
<br />1,215,604 2,133,000
<br />19,618 125,000
<br />-
<br />3,424
<br />1,970
<br />5,000
<br />865
<br />5,000
<br />4,126
<br />4,146
<br />1,263
<br />4,000
<br />3,316 4,000
<br />14,205
<br />-
<br />- -
<br />-
<br />2,477,955
<br />522,980
<br />2,318,177
<br />1 548,842
<br />1,850,009 1,988,150
<br />533,642 615,600
<br />23,799 2,267,000
<br />279,358 627,800
<br />1,953
<br />-
<br />8
<br />-
<br />-
<br />202,175
<br />237,506
<br />264,863
<br />191,100
<br />119,825
<br />191,100
<br />54,269
<br />58,962
<br />56,928
<br />60,500
<br />28,509
<br />61,400
<br />43,756
<br />47,552
<br />48,675
<br />50,050
<br />24,095
<br />50,800
<br />10,977
<br />22,464
<br />44,571
<br />-
<br />-
<br />10,329
<br />11,112
<br />11,384
<br />11,700
<br />51635
<br />11,850
<br />93,613
<br />101,247
<br />94,855
<br />98,250
<br />50,770
<br />108,100
<br />16,050
<br />18,083
<br />30,090
<br />19,750
<br />14,786
<br />19,450
<br />924
<br />-
<br />1,126
<br />-
<br />287
<br />957,026
<br />56
<br />1,000,840
<br />703
<br />1,086,142 1,046,950
<br />957 1,000
<br />523,265
<br />412
<br />1,070,500
<br />1,500
<br />2,817
<br />3,273
<br />3,772 3,600
<br />1,169
<br />3,600
<br />24,513
<br />17,143
<br />18,701 22,000
<br />7,708
<br />23,000
<br />27,386
<br />8,824
<br />21,119
<br />10,304
<br />23,430 26,600
<br />8,722 10,300
<br />9,289
<br />9,500
<br />28,100
<br />11,300
<br />3,471
<br />3,122
<br />3,083
<br />3,900
<br />1,661
<br />3,900
<br />586
<br />-
<br />530
<br />2,000
<br />759
<br />2,000
<br />14,490
<br />5,511
<br />5,396
<br />19,000
<br />3,335
<br />19,000
<br />14,913
<br />18,265
<br />18,656
<br />19,850
<br />2,636
<br />2175-6
<br />67,722
<br />62,930
<br />72,675
<br />64,500
<br />30,455
<br />64,500
<br />84,459
<br />44,786
<br />104,793
<br />54,600
<br />60,348
<br />54,600
<br />95,999
<br />94,939
<br />93,815
<br />99,000
<br />100,000
<br />6,164
<br />6,176
<br />6,200
<br />6,000
<br />6,000
<br />440
<br />573
<br />459
<br />500
<br />900 500
<br />158,972
<br />180,150
<br />167,247
<br />169,000
<br />56,394 173,000
<br />-
<br />456,040
<br />-
<br />-
<br />426,756
<br />-
<br />- -
<br />481,576 448,650
<br />- 80,000
<br />13 -
<br />166,001 455,950
<br />182,250 91,000
<br />-
<br />344
<br />-
<br />500,000
<br />500,000
<br />750,000 1,000,000
<br />750,000
<br />255,147
<br />250,000
<br />250,000 250,000
<br />250,000
<br />2,195,599
<br />282,356
<br />n
<br />251,394
<br />-
<br />2,591,492 2,852,200
<br />(741,483) (864,050)
<br />n n
<br />4,727,923 4,560,789
<br />4,560,789 3,795,739
<br />2,852,200 2,645,550
<br />880,805 2,645,550
<br />(857,006) (378,550)
<br />n
<br />3,795,739
<br />3,517,189
<br />2,450,109
<br />(131,932)
<br />n
<br />4,907,484
<br />4,727,923
<br />Comments:
<br />
|