|
2023 BUDGET SHEET
<br />Fund: Liquor
<br />20192020202120226/30/222023
<br />Detail of Revenues/Expenses
<br />Comments:
<br />BUDGETActualBUDGET
<br />ActualActualActual
<br />REVENUES:
<br />Sales7,612,7127,923,5818,613,0707,901,0003,935,1356,816,250
<br />Cost of Sales(5,399,898)(5,679,210)(6,234,978)(5,636,000)(2,688,974)(4,937,100)
<br />GROSS PROFIT2,212,8142,244,3712,378,0922,265,0001,246,1611,879,150
<br />Other Revenue
<br />Interest87,440215,253(67,485)80,00036,961100,000
<br />Delivery Fee--3,4245,0001,0755,000
<br />Misc. Revenue5,0784,1264,1464,0001,2004,000
<br />Transfer In-14,205----
<br />TOTAL LIQUOR REVENUE2,305,3322,477,9552,318,1772,354,0001,285,3971,988,150
<br />EXPENDITURES:
<br />PERSONAL SERVICES
<br />Regular Pay459,657522,980548,842588,100234,082604,850
<br />Overtime Pay6221,953----
<br />Part-time Pay189,565202,175237,506205,000111,136191,100
<br />PERA46,08154,26958,96259,50025,37659,700
<br />FICA39,85943,75647,55249,20021,07749,350
<br />Other Retirement Contributions55,77810,977(22,464)---
<br />Medicare9,32110,32911,11211,5004,92911,600
<br />Insurance81,48593,613101,247111,00047,580103,150
<br />Workers Comp17,07316,05018,08320,50025,41419,750
<br />Unemployment Compensation307924--967-
<br />TOTAL PERSONAL SERVICES899,748957,0261,000,8401,044,800470,5611,039,500
<br />SUPPLIES
<br />FuelLubes-567031,0004321,000
<br />Uniform Allowance3,8312,8173,2733,6001,8633,600
<br />OperatingSupplies37,69924,51317,14322,0008,47222,000
<br />TOTAL SUPPLIES41,53027,38621,11926,60010,76726,600
<br />SERVICES & CHARGES
<br />Audit Fees7,8128,82410,30410,0006,75010,300
<br />Telephone2,1203,4713,1223,9001,4353,900
<br />Conferences/Schools875586-2,0002952,000
<br />Advertising/Marketing11,09814,4905,51119,0002,70119,000
<br />Insurance14,66114,91318,26519,8503,94219,850
<br />Utilities58,99767,72262,93068,00024,60764,500
<br />Maintenance/Software55,29684,45944,78667,60049,01254,600
<br />Depreciation123,28695,99994,93999,000-99,000
<br />Dues/Subscriptions5,7006,1646,1766,000-6,000
<br />Taxes & Licenses440440573500119500
<br />Credit Card Fees150,955158,972180,150170,20068,809169,000 2% in-store, 3.5% online
<br />IT Equipment Charge7,000
<br />TOTAL SERVICES & CHARGES431,240456,040426,756466,050157,670455,650
<br />CAPITAL OUTLAY---100,000-80,000 NB monument sign
<br />TRANSFERS OUT
<br />General Fund500,000500,000500,000750,000-750,000
<br /> Park Improvement Fund214,855255,147250,000250,000250,000250,000
<br /> SCBA Funding251,394
<br />TOTAL LIQUOR EXPENDITURES2,087,3732,195,5992,450,1092,637,450888,9982,601,750
<br />CHANGE IN NET POSITION217,959282,356(131,932)(283,450)396,399(613,600)
<br />^^^^^
<br />CASH BALANCE - BEGINNING4,897,2994,727,9234,543,473
<br />CASH BALANCE - ENDING4,727,9234,543,4734,028,873
<br />CASH FLOW RESERVE2,637,4502,601,7502,620,000
<br />
|