|
Orange County ABC Board
<br /> Actual to Budget Comparison
<br /> For theflscal year ending lM/30/2023 Attachment"C"
<br /> JAN WD 2023 Bahama %
<br /> Bales 2023 Budget Remaining RumeWng
<br /> Liquor Sales 1,776,905 15,750,518 24,971,330 9,220,812 38.93%
<br /> Wine/Mixer 2,816 24;512 39,500 14,988 37,04%
<br /> LBO 407,317 2,896,280 4,407,485 1,511,205 34.29%
<br /> Gross Sales 2,187,039 18,671,310 39,418,31S 10,747,005 N 53% 1
<br /> Taxes based an gross Bales 511,749 4,335,03E 689444E 2559 13 37.12%
<br /> Net Soles 1,575,290 14,396,278 22,623.870 a 187,592 38.35%
<br /> Cost of BNe3 4naunmg lm'niory anNmnvna) 1,118,682 9,611,1W 15,367,930 5756,750 3746%
<br /> Gross Profit 558,808 4,725,098 7155940 2 0842 33.97% j
<br /> I
<br /> Operating Expenses benchmark
<br /> Peyrdland RNelwla,panan I I I 41.6)%
<br /> Salaries and Wages 232,338 1,417,64E 2,237,145 819,500 36.63%
<br /> Payroll Taxes 16,040. 109,298 I]4,345 65,047 37,31%
<br /> Retirement 21,833 148,48E 231,910 83,445 35.98%
<br /> Group Health Insurance 39,533 25],739 422,6]5 164,936 39,02%
<br /> Ratime's Group Insurance 11,513 80,586 131,850 51,264 38.as%
<br /> Human Resources 1,116" 16,33E 22,000 51665 25.75%
<br /> 401k 5,03E 39,28E 69,395 30,113 43.39%
<br /> Processing fees 529 4,)84 B,500 3,716 43.72%
<br /> Tiodpayrollrelafadaxpen3ee 32Q039 2,0J4,134 3,297820 1,223,686 37,11%
<br /> O@er Opeonksg Expenses
<br /> Board MembamlMestingRrevelf7mining 378 4,268 Brute 2,332 35.33% '.
<br /> Rent 4.300 31,230 54,300 23,070 42.49%
<br /> lease Amortization 20.507 M0,513 243,000 102,487 42.18%
<br /> Repairs&Maintenance Bags 759 19,871 0,000 20,129 50.32%
<br /> Repairs&PAWManance-Equip. 708 11,005 20,00o 8,995 44,98%
<br /> UIIIIHes,Telephone,Internet 12.365 56,178 95,950 39,772 MAR%
<br /> Business Insurance 7,043 45,497 74$000 29,503 39.34%
<br /> Store Supplies,Bags and Expenses 11.412 113,614 175,000 61,386 3508%
<br /> Employee Travel 495 1,500 1,005 67.00%
<br /> OfRce Sul&Expenses 1,917 2OA70 28,CO0 7,530 26,89%
<br /> Maintenance Sarvlces 1,054 14,064 26,400 12,336 46.73%
<br /> Servhe Agreements(DM,/HVAC) 7,698 53,991 84,250 30,259 35,92%
<br /> Postage 350 1,949 3,100 1,01 37.13%
<br /> Professional Fees Replan)(audit and legal) 1,975 - "15,891 35,000 19,109 S4.80%
<br /> Dues&Subsctlptinm 453 2,804 4,900 2,096 42.78%
<br /> Credit Card Processing 36,521 310,223 475,500 165,277 34.76%
<br /> Training and Education 1,SD0 3,430 ID,000 6,57D 65.70%
<br /> Burglar Alarm and Security 575 4,02E 7,200 3,175 44.10%
<br /> Vehlde Expense 2.005 18,868 28150D 9,63E 33,80%
<br /> Uniforms 607 4,200 3,593 65.55%
<br /> Debt Service(interest expense( 6,163 26,028 53,375 27,347 51.24%
<br /> Tmerest(Lesse5) 3,822 26,197 45,150 18,953 41,98%
<br /> Cash war/short (3) 494 75D 256 34.13%
<br /> Cantingendes/Mist. 50 109 son 391 78,20%
<br /> Total opemfing expenses 121,352. . 921,821 1,518,175 596,354 39.28%
<br /> Total OpemtinglPaynall Expenses 449,391 2,995,954 4,815,996 118201041 37.79%
<br /> Operating Income 107.217 4,724;144 2,339,945 610,801 26.10%
<br /> Other Income
<br /> Intmea)In... 857 2,550 2,000 (55D) -27.60%
<br /> Miscellaneous b 1,50D 1,50D 100.00%
<br /> Total Other Income 857 2,550 3'Sm 95D 27.14%
<br /> Net Income Before Pmpt Distributions: 1D8,074 1.731,694 2,343,4E 611,751 26.10%
<br /> Statutory Distributions
<br /> Law Enforcement 14,000 98.000 168,000 70,000 41.67%
<br /> Alcohol Rehab&Ed 21,000 147,000 252,000 105,00D 41.67%
<br /> Total stetulory Distributions 35,000 245.000 420,000 176,000 41.67%
<br /> Net Income Before Profit Distribution 73074 1,4813AR4 1,923.445 436,751 22.71%
<br /> Profit Distribution
<br /> Orange County-Gen Fund 50,333 400,333 700000 291,fi67 41.87%
<br /> Working Capital Retainad-: 14,]41 1,070.381 1,223,44E 145,084 11.86%
<br /> Dapraaexan Rwww4wmaamlarram 2aaee2 0II '..
<br /> (maced dal
<br /> Capital Outlav Month VTO Budget eudeammalmng
<br /> Store 14'Mebane' '.
<br /> store conslmdipn 129.461 963,601 1,266,100 3OL499 23.83%
<br /> Change Ortlers/Englneering/Project Administration 2,622 22.725 235,000 212,27E 90.33%
<br /> Fumhme,famous and equlmeolt(FFE) 89,851 165.250 95,399 67.73%
<br /> ResurfaCefloms/office 0 0 0.00%
<br /> Copler/oHRe 5,949 6,950 j
<br /> Refrigerator units(9ve stores) 2,580 7,500 4,920 GEED%
<br /> Southern Village renovations 122,158 122.200 42 -100.00%
<br /> Capital Receipts
<br /> Deb"arvla proceeds)Fit) (983,601) (1,219,335) (255,734) 20.97%
<br /> Appropriated fund balance(RSB) 0 (677,8i(b (677,810) 100.00%
<br /> Debt Sandoz,(principal) j
<br /> Twist(Chapel Hill North) 0 677,810 077,810 - 0.00%
<br /> First H.dwn(Mebene Stare) 0 0 54,440 54,440 100.00%
<br /> 132,083 901,073 638,10E (264,960) -01.85%
<br /> 5
<br />
|