|
Orange County ABC Beard
<br /> Actual to Budget Comparison
<br /> For the/1scal year ending 0613012023 Attachment"Ce
<br /> SEPT YTO 2023 Balance %
<br /> Sales 2022 Budget Remaining Remaining
<br /> Liquor Sales 2,066,513 6,076,545 24,520,230 18,443,685 75.22%
<br /> Wine/Mixer 3,085 8,611 38,000 29,389 7T34%
<br /> - LBO 469,891 1,202,929 8,602,485 2,399,657 66,61%
<br /> Gross Sales 2,539,3B2 7,287,984 28,160,715 20,872,731 74.12%
<br /> Taxes based on gross sales 573,784 1,676,729 6,617,770 4,941041 74.e0%
<br /> Netsoles 1,966,598 5,611,255 21.642,94E 15,931,691 73.95%
<br /> Cost of Sales(lrmArmry nvenlory edpatmama) 1,302,949 3,739,292 14,713,975 10,974 693 74.69%
<br /> Grass Profit 662,649 1,811,963 6828,.971 4,957,008 72.69%
<br /> Operating Expenses benchmark
<br /> Payroll and RaleredExpenses 03,33%
<br /> Salaries and Wages 182.841 539,272 2,167,14S 1,627,873 75.12%
<br /> Payroll Taxes 18,654 43,841 162,345 119,504 73.00%
<br /> Retirement 20,310 61,941 210,910 148,969 70.83%
<br /> Group Health Insurance 33,769 98,736 422,675 323,939 78.64%
<br /> Retiree's Group Insurance 11,512 34,537 131,850 97,313 73.81%
<br /> Human Resources 1,486 11,687 5,500 (6,187) -112.40%
<br /> 401k 7.964 18,517 69,395 50,879 73.32%
<br /> Processingfees 796 2,098 8,500 6,402 76.32%
<br /> Total payroll related expenses 283,322 810,629 3 178 321 2,367,692 74.50%
<br /> Other Operating Expenses
<br /> Board MemberstMeeling(TraveliTralning 465 2,696 6,600 3,904 69.15%
<br /> Rent 4,300 13,187 319,9C0 306,113 95.87%
<br /> tease Amortization 19,748 59,244 (59,244)
<br /> Repairs&Maintenance-Bldgs 2,179 9,694 40,000 30,206 76.77%
<br /> Repairs&Maintenance-Equip. 729 4,809 20,000 15,191 76.98%
<br /> UtTlltles,Telephone,Internet 6,963 20,933 95,950 75,017 78.18%
<br /> Business Insurance 6,409 19,227 75,000 55,773 7436%
<br /> Store Supplies,Bags and Expenses 16,599 51,833 135,000 63,167 81,61%
<br /> Employee Travel 490 1,500 1,010 67.33%
<br /> Office Supplles&Expenses 2,736 9,431 17,500 8,069 46,11%
<br /> Maintenance Services 2,034 6,168 26,400 20,232 76.64A
<br /> Service Agreements(Data/HVAC) 7.679 23,037 78,000 54,963 70,47%
<br /> Postage 360 940 3,10D 2,260 72,90%
<br /> Prcfesslonal Fees(office)(audit and legal) 1.975 5,925 35,ODD 29,075 83.07%
<br /> Dues&Subscriptions 445 985 4,900 3,915 79.9C%
<br /> Credit Card Processing 39,259 117,252 430,003 112,748 72,73%
<br /> Training and Education 1,084 1,508 10,000 8,492 84.92%
<br /> Burglar Alarm and Security 576 1,725 7,2130 5,475 76,04%
<br /> Vehicle Expense 1,455 10,628 SB,a00 7,372 40.06%
<br /> Uniforms 43 4,200 4,157 98,98%
<br /> Debt Service(interest expense) 6.786 14,952 83,375 68,423 92.07%
<br /> Interest(Leases) 3,789 11,433 - (11,433)
<br /> Cash over/short 452 (64) Soo 564 112.80%
<br /> Contingencies/Mist. 229 115 SOD 3B5 77.00%
<br /> Total operating expenses 1261239 386,091 1412,025 1,025,934 72.85%
<br /> Total Operating/Payroll Expenses 408,561 1,190,719 4.590,346 3,393,627 73,93%
<br /> Operating Income 254,088 675,244 2.230.626 1,553,381 69.94%
<br /> Other income
<br /> Interest Income 155 484 2,000 1,516 76.80%
<br /> Miscellaneous 0 1,600 1,500 100.00%
<br /> Total Other Income 155 484 3,600 3,016 86.17%
<br /> Net Income Before Profit Olalributlons! 264,243 676,728 2,242.125 1,566,397 60.86%
<br /> Statutory Dlsirlbutlons
<br /> Lew Enforcement 14,000 42,00D 188.000 126,000 75,00%
<br /> Alcohol Rehab&Ed 21,000 63,000 252,00D 189,OOo 76.00%
<br /> Total Statutory Distributions 36,000 105,OOD 420,000 315,000 75.00%
<br /> Net Income Before Profit Distribution 219,243 570.728 1,822,125 1.251.397 68.68%
<br /> Profit Distribution
<br /> Orange County-Gen Fund 58.334 175,000 700,000 525,000 75,00%
<br /> Working Capital Retalnedae 160.909 395.728 1,122,125 72e,397 64.73%
<br /> Dap.d,aeenim,nb&V.1edit.W 32,351 97y22
<br /> 12E,658 298.3%
<br /> CapitalOutiay Month VTD Budget Budget remaining
<br /> Store N4(Mebane) �
<br /> Store construction 0 146.152 1,285,100 1,118,948 88.46% i
<br /> Change Orders/Engineering/Project Administration 0 14.497 190,000 175,503 92.37%
<br /> Furniture,fixtures and equipment(FFE) 0 1,665 110,260
<br /> Resurface floors/afnce 5,949 10,000 4,051 40,61%
<br /> Refrigerator units(riive stores) 2,580 16,000 12,420 82.83%
<br /> i
<br /> Southern Village 3,3.18 D (3,316) -100,OD% �
<br /> i
<br /> Capital Receipts
<br /> ! Debt service proceeds{FH) 0 (146,152) (1,219,335) (1,073,I83) 89.01% f
<br /> Appropriated fund balance(RSB) D 0 (37f,015) 1371,015) 103.00%
<br /> Debt 5ervke(odncioal)
<br /> Trulst(Chapel Hid North) 22,017 69,116 67,098 75.29% I
<br /> First Horizon(Mebane Store) 0 0 152,440 152,440 100.00%
<br /> 0 50,024 241,555 191,531 79,29%
<br /> 5 IJ
<br /> I
<br />
|