|
Orange County ABC Board
<br /> Actual to Budget Comparison
<br /> for the frscof year ending 0613012022 Attachment"C"
<br /> JUNE YfO 2022 Balance %
<br /> Sales 2022 Budget Remalning Remaining
<br /> Licl—Sales 1.922.420 25,433,858 25,479,565 45,707 OAS%
<br /> Wine/Mixer 2.507 41,249 41,310 61 0.15%
<br /> LBO 405.732 4,575,19 4,55S,550 19,6301 -0.43%
<br /> Gross Sales, 2.330.659 30,050,287 30,076,425 26,132 0.09%
<br /> Taxes based on gross sales 543,538 6,985 060 6,991,600 6$40 0.09%
<br /> Net Sales 1.787..121 231065,227 23,054,625 19,59ti 0.08%
<br /> Cost of sales fIdurl uwmtny eelustme l 1,189,840 1 15,494,993 15,472,21D 1 (12,783) -0.05%
<br /> Gross Profit 590,281 7,580,234 7,612,6151 32,381 OAS%
<br /> Operating Expenses arnchmarx
<br /> Pey,Wl end Ralatad Expenses
<br /> Salaries and Wages 182,220 2,076,384 2,104,120 27,736 1.32%
<br /> Payroll Taxes 11,605 158,641 155,705 (2,9361 -1.89%
<br /> Retirement 14,689 201,165 202,200 1,035 O.S1%
<br /> Group Health Insurance 32,992 393,337 384,245 909 0.24%
<br /> Retiree Health ins 10,951 131,035 12S,000 (6,035) -4A3%
<br /> YE Portion of Slate pension exp(per LASS 69) (58,504) (511,504)
<br /> OPES tiabddy Adjus7menl (283,521) (283,521)
<br /> Health Reimb./Flex 233 5,212 5,600 389 8.03%
<br /> Cash over/short (75) (600) 750 1,350 180.00%
<br /> 401k 5,148 48,081 48,435 354 0.13%
<br /> Processing fees 801 8008 7,945 63 •0.80%
<br /> 70181 payroll related expenses 103,654) 2,669 238 3,034,000 364,762 12.02%
<br /> Orhn Operating Expenses
<br /> Board MembeislMeeting(havelfftaining 426 5,100, S,100 (1)
<br /> Rent 1138.932) 52,802 208,575 155,773 74.68%
<br /> Repairs&Maintenance-Bldgs 1,D40 45,920 45,920 60 0.13%
<br /> Repairs&Maintenance-Equip. 0.555 23,246 14,290 (9,957) 42.68%
<br /> Utilities,Telephone,Internet 8,206 93,228 91,925 (2,3031 -1.42%
<br /> Business insurance e,409 71,808 71,810 2 0.00%
<br /> Store Supplies,Bagsand Expenses 14,730 147,22.5 145,000 (2,225) -1.53%
<br /> Employee Travel 29 30 1 3.13%
<br /> Office Supplies&Expenses 801 16,125 14,400 (1,725) -11,98%
<br /> Maintenance Services 3,702 25,7D6 24,440 (1,266) .5.18%
<br /> Service Agreements(Data/HVAC) 8.733 76,138 76,140 2 OM51i
<br /> Postage 655 3,676 3,745 69 1.84%
<br /> Professional Fees(office)(audit and legal) 4.688 38,050 37,785 (266) -0.70%
<br /> Dues&Subscriptions 302 4,852 4,855 3 0.07%
<br /> Credit Card Processing 36.874 460,003 460,450 447 0.10%
<br /> Training and Education 614 61S 1 0.16%
<br /> Burglar Alarm and Security 575 6,900 7,325 425 5.80%
<br /> Vehicle Expense 534 20,190 20,920 730 3A9%
<br /> Uniforms 2,699 3,000 301 10.03%
<br /> Debtservice(interest expense) 3,618 87,728 97,220 (508) -0.55%
<br /> Interest(teases) 25,444 ZS,444
<br /> Lease Amcrllzatinn 154.521 154,591
<br /> Contingencies/Mist 1 256 SOD 756 1 151,20%
<br /> Total operafing expenses 138,838 1361818 1,324,105 37713 .2,85%
<br /> Total OperatinglPeyroll Expenses 35.234 4.031.058 4,358,105 327.044 1 7.50%
<br /> Operating Income 555.047 3,649,178 3,254,610 (294,669) -9.05%
<br /> Other Income
<br /> Interest income 184 1,990 1,300 (690) -53.08%
<br /> Miscellaneous 4,087 580 3,507 -428.25%
<br /> Total Other Income 164 6,057 1.380 (4,197) -225.65%
<br /> Net Income Before ProTil Distributions: 555,211 3,655.235 3.256,370 (298,866) -9.18%
<br /> Statutory Distributions
<br /> Lew Enforcement 13,833 teS,99B 168,000 1 0,00%
<br /> Alcohol Rehab 8 Ed 10.750 237.000 237,000 0,00%
<br /> Total Statutory Distributions 33.583 02,699 403.000 1 0.00%
<br /> Net Income Before Profit Distribution 521,628 3,152,236 2.853.370 298,86
<br /> Profit Distribution
<br /> Orange County-Gen Fund 44166 530,002 530.000 2 0.00%
<br /> Working Capital Recalned": 477,482 2822,234 2,323,370 298.865 -12-BO%
<br /> OspsdaWnrnm-eetlgeletlrtem) M-OU g9L319 436.975
<br /> 440.016 2,IM,924
<br /> Capital Outlay Month YTD Budget 8.44etnelre1n1ng
<br /> Store d4(M,,15—)
<br /> Replacement store(Mebane) 5,415 1.163.480 1,672,540 509,360 30.45%
<br /> Store#815ourhern 011a0e)
<br /> Security deposit 0 8,030 8.030 0,00%
<br /> Leasehold Improvements 0 10,574 10,575 1 0.01%
<br /> Furniture,fixtures and equipment(FFE) 0 14,882 14.665 3 0.02%
<br /> Comfort Engineers(new HVAC) 0 11.337 11,340 3 0.03%
<br /> ClearTech(Intercom/music system) 0 3,752 3.755 3 0.08%
<br /> Debt Service lorincioall
<br /> RS8(Oakdale)(principal) 0 1,980.498 105,183 (),RSS,3151 -1763.89%
<br /> BB&T(prindpal) 7300 W.358 93,882 (2,6741 -3.20
<br /> 7,300 2,046,854 188.865 (1,857,989) _983.77%
<br /> 12.7161 7267,298 L861,705 1 (405,593) Q1.79%
<br /> 5
<br />
|