|
orange County ABC Board
<br /> Actual to Budget Comparison
<br /> For the fiscal year ending 06/30/2023 Attachment"C"
<br /> FEBRUARY YTD 2023 Balance %
<br /> Sales 2023 Budget Remaining Remaining
<br /> Liquor Sales 1.901.713 17,652,231 24,971,330 7,319,099 29.31%
<br /> Wine/Mixer 2,401 26,913 39,500 12,597 31 6745
<br /> LB❑ 434,298 3,330,578 4,407,485 1,076,907 24.43%
<br /> Gross Soles 2,338,412 21,009,722 29,419,315 8,408,593 28.58%
<br /> Taxes based on gross sales 541 4,881,338 6,894,445 2,013,107 29.20%
<br /> Netsoles 11,792,106 16,128,384 22,523,87C 6,395,486 28.39%
<br /> COSt Of Sales(nrdutling L,aenbryatlWgmrntsl 1,193,914 101 15.367,930 1 4,562,836 29.69%
<br /> Gross Profir 598,192 5,323290 7,155,940 1,832,550 25.61%
<br /> Payroll and Related Expenses Learh-i
<br /> Salaries and Wages 185,722 1,603,367 2,237,145 633,778 28 33% 3333%
<br /> Payroll Taxes 13,123 122,421 174,345 51,924 29 78%
<br /> Retirement 18,801 167,266 231,910 64,644 27 87%
<br /> Group Health Insurance 36,491 289,428 422.675 134,247 31.76%
<br /> Retiree's Group Insurance 11,5t3 92.01 131,850 39,751 30.15%
<br /> Human Resources 494 16,829 22,000 5,111 23.50%
<br /> 401k 4,872 44,154 69,395 25,241 36.37%
<br /> Processing fees 1.473 1 6,257 8,500 2,243 1 2E 39%
<br /> Total payroll related expenses 272.399 2,3401 3,297,920 956,999 29.02%
<br /> Operating Expenses
<br /> Board Mem6erslMeeting7TravelRraining 500 4,768 6,W0 1,632 21.76%
<br /> Rent 4,255 35,485 54,3130 18,815 34.65%
<br /> Lease Amortization 20.507 161,020 243,1JOD 81,980 3374%
<br /> Repairs&Maintenance-Bids 924 20,795 40,000 19,205 48.01%
<br /> Repairs&Maintenance-Equip. 4.227 15,232 20,000 4,768 23.84%
<br /> Utilities,Telephone,Internet 6,8213 65,DD4 95,950 30,946 32.25%
<br /> Business Insurance 7,044 52,541 75,1JOD 22,459 29.95%
<br /> Store Supplies,Bags and Expenses 11,130 124,744 175,G00 50,256 28.72%
<br /> Employee Travel 360 855 2,500 645 43.00%
<br /> ONIre Supplies&Expenses 141) 20,610 28,008 7,390 26.39%
<br /> Maintenance Services 1.954 16,018 26,400 10,382 39.33%
<br /> S-ir.Agreements l Data/HVAC) 7.511 61,502 94,250 22,748 27.00%
<br /> Postage 138 2,087 3,100 1,013 32.68%
<br /> Professional Fees(office}(audit and legal) 2.225 18,116 35,000 16,884 48.24%
<br /> Dues&Subscriptions 303 3,107 4,900 1,791 3659%
<br /> Credit Card Processing 38.099 348,322 475,500 127,178 26.75%
<br /> Training and Education 1,299 4,729 10,000 5,271 52.71%
<br /> Burglar Alarm and Security 575 4,600 7,200 2,600 36.11%
<br /> Vehicle Expense 669 19,537 28,500 8,963 31.45%
<br /> Uniforms 1,816 2,423 4,200 1,777 42.31%
<br /> Debt Service(Interest expense) 4,744 30,772 53,375 22,603 42.35%
<br /> Interest(Leases) 3.585 29,782 45,150 15,368 34.D4%
<br /> Cash over/short (243) 251 750 499 E6.53%
<br /> Contingencies/Mist 76 185 Soo 315 1 63.00%
<br /> Total operating expenses 120,664 1,042,485 1,519,175 475,690 31.33%
<br /> Total OperatingiPayroll Expenses 393,063 3,383.305 4,815,995 1.432,690 29.75%
<br /> Income from Operations 205,129 1,939.985 2,339,945 399,960 17.D9%
<br /> Other Income
<br /> Interest Income 767 3,317 2.000 (1,317) -85.35%
<br /> Miscellaneous 0 1,500 1,500 100.00%
<br /> Total Other Income 767 3,317 3.500 183 5.23%
<br /> Net Income Before Pmllit Distributions: 205,896 1,943.302 2,343,445 4D01143 17.089A
<br /> Statutory Distributions
<br /> Law Enforcement 14,006 112,000 168,000 56,000 33.33%
<br /> Alcohol Rehab&Ed 21.000 11 252,000 84,000 33.33%
<br /> Total Statutory Distributions 35.000 281 420,000 140.000 33.3354
<br /> Net Income Before Profit Distribution 170.896 1.663,302 1,923,445 20,i43 13.52%
<br /> Profit Distribution
<br /> Orange County-Gen Fund 58.333 466.666 700,D00 233,334 33.33%
<br /> Working Capital Retained': 112.563 1,196,636 1.223.445 26,809 2.1945
<br /> Depmda(im lno dgefudrraml 344691 2aay2Ts 425000
<br /> 77572 92a36a 798,445
<br /> Capital Outlay Month YTD Budget audaetremalxing
<br /> Smre N4 fMebone)
<br /> Store cnnstructfun 0 1 f 265,100 301,499 23.83%
<br /> Change Orders/Engineering/Project Administration 679 23.404 235.000 211,596 90.04%
<br /> Furniture,fixtures and equipment IFFEI 12,8E5 82.716 le5,25C 82,534 4994%
<br /> Resurface Boors/office a 0 0 00%
<br /> Copier/office 5,949 5,960
<br /> Refrigerator units(five stores) 2,58D 7,500 4,920 6560%
<br /> Southern Village renovations 0 122,158 122,200 42 -100 G0%
<br /> Capital Receipts
<br /> Debt service proceeds(FH) 0 (963601) (1,219,335) (255,734) 20,97%
<br /> Appropriated fund balance(R58) 0 (677,810) (677,810) 100,00%
<br /> Debt Service IarinclnaU
<br /> Truist(Chapel Hill Mori D 677,810 677,810
<br /> First Horizon(Mebane Smre) 0 0 54,440 14,440 1001
<br /> 13,544 914,617 636,105 (278,51Z) -4178%
<br /> 5
<br />
|