|
2022 BUDGET SHEET
<br />Fund: Liquor
<br />Acct.20182019202020212022
<br />Explanation/Detail of Supplies or Services
<br />No.BUDGETBUDGETComments:
<br />ActualActualActual
<br />REVENUES:
<br />Sales7,198,180 7,612,712 7,923,581 7,670,500 7,901,000
<br />Cost of Sales (5,399,898)(5,119,654) (5,679,210) (5,403,500) (5,636,000)
<br />GROSS PROFIT 2,078,526 2,212,814 2,244,371 2,267,000 2,265,000
<br />Other Revenue
<br />3621Interest 55,235 221,617 215,253 50,000 80,000
<br />3620Delivery Fee- - - - 5,000
<br />3629Misc. Revenue 4,973 5,078 4,126 4,800 4,000
<br />3921Transfer In- - 14,205- -
<br />TOTAL LIQUOR REVENUE 2,138,734 2,439,509 2,477,955 2,321,800 2,354,000
<br />EXPENDITURES:
<br />PERSONAL SERVICES
<br />4101Regular Pay 373,255 459,657 522,980 553,100 588,100
<br />4102Overtime Pay 41 622 1,953- -
<br />4103Part-time Pay 194,761 189,565 202,175 189,000 205,000
<br />4104PERA 41,824 46,081 54,269 55,650 59,500
<br />4105FICA 34,790 39,859 43,756 46,000 49,200
<br />4106Other Retirement Contributions (26,102) 55,778 10,977- -
<br />4107Medicare 8,136 9,321 10,329 10,750 11,500
<br />4108Insurance 73,136 81,485 93,613 98,350 111,000
<br />Benefit change
<br />4109Workers Comp 16,402 17,073 16,050 18,700 19,650
<br />4110Unemployment Compensation- 307 924- -
<br />TOTAL PERSONAL SERVICES 716,243 899,748 957,026 971,550 1,043,950
<br />SUPPLIES
<br />4212Fuel 72- 56 1,000 1,000
<br />4217Uniform Allowance 3,204 3,831 2,817 3,600 3,600
<br />Operating Supplies
<br />4219 12,574 37,699 24,513 15,000 22,000
<br />TOTAL SUPPLIES 15,850 41,530 27,386 19,600 26,600
<br />SERVICES & CHARGES
<br />4301Audit Fees 7,726 7,812 8,824 8,100 10,000
<br />Telephone
<br />4321 2,661 2,120 3,471 3,100 3,900
<br />4331Conferences/Schools 426 875 586 2,000 2,000
<br />Advertising/Marketing
<br />4349 15,822 11,098 14,490 19,000 19,000
<br />4361Insurance 15,204 14,661 14,913 16,000 19,850
<br />Utilities
<br />4389 62,101 58,997 67,722 63,300 68,000
<br />4404Maintenance 39,319 55,296 84,459 34,000 67,600 New POS software
<br />Depreciation
<br />4420 119,186 123,286 95,999 124,000 99,000
<br />4433Dues/Subscriptions 6,060 5,700 6,164 5,500 6,000
<br />TaxesLicenses
<br />4437 456 440 440 500 500
<br />4438 112,992 150,955 158,972 155,000 170,200
<br />Online service fees
<br />TOTAL SERVICES & CHARGES 381,953 431,240 456,040 430,500 466,050
<br />4530 CAPITAL OUTLAY- - - 20,000-
<br />4720 TRANSFERS OUT
<br /> General Fund 492,000 500,000 500,000 500,000 500,000
<br /> Park Improvement Fund 197,174 214,855 255,147 250,000 250,000
<br />TOTAL LIQUOR EXPENDITURES 1,803,220 2,087,373 2,195,599 2,191,650 2,286,600
<br />N NET POSITION 335,514 352,136 282,356 130,150 67,400
<br />CHANGE I
<br />^^^^^
<br />CASH BALANCE - BEGINNING 4,897,299 5,151,449
<br />CASH BALANCE - ENDING 5,151,449 5,317,849
<br />
|