|
Orange County ABC Board BUDGET WORKSHEET
<br /> Multi-Year Comparison Revenues and Expenses
<br /> (base) (current)
<br /> 2022 2023 2024 2025 2026 %rhangejrom change
<br /> Sales (Actual) (Actual) (Actual) pro)erted BUDGET A.-rousyear since2023
<br /> Liquor Salns 25,433,856 26,045,623 26,233,194 25,565,170 25,451,000 -0A5% 0.07%
<br /> Wine/Mixer 41,249 38,237 30,698 3,650 1,500 -58.90%
<br /> LBD 4,575,181 5,125,307 5,047,452 4,696,224 4,598,000 -2.09% 0.50%
<br /> Gross Sales 30,050,286 31,209,168 31,311,344 30,265,045 30,050,500 -031%
<br /> Taxes based on gross sales 6,985,063 7,261,799 7,279,602 7,069,650 1 7,031,820 -0.54% 0.67%
<br /> Net Sales 23,065,223 23,947,368 24,032,742 23,195,395 23,018,680
<br /> Cost Of Goods(including Inventory adjustments) 15,474,063 16,103,177 16,324,99D 15,834,490 15,716,415 -0.75% 1.57%
<br /> Gross Profit$ 7,591,160 7,844,191 7,707,752 7,360,905 7,302,265
<br /> %increase 13% 3% -174% 450% -0.90%
<br /> Salaries and Wages 2,076,384 2,397,503 2,612,849 2,668,225 2,774,950 4,00% 33.64%
<br /> Payroll Taxes 158,640 179,372 195,905 201,425 210,900 4.70% 32.94%
<br /> Retirement(Board's portion) 201,166 254,575 301,622 325,225 342,140 5.20% 70.08%
<br /> Group Health Insurance 383,337 454,591 525,566 523,235 549,400 5.00% 43.32%
<br /> Retiree's Group insurance(actuarial( 279,146 138,149 162,148 176,630 185,000 4,74% -33.73%
<br /> Human Resources 5,214 23,249 11,899 8,270 10,000 20.92% 91.7996
<br /> 401k 46,080 66,194 67,913 66,395 68,000 2.42% 41.43%
<br /> Processingfees 8,009 9,063 9,637 9,805 9,950 1.48% 24.24%
<br /> Total payroll and related 3,159,976 3,522,696 3,887,539 3,979,210 4,150,340 4.3D°5 31.34%
<br /> Operational Expenses
<br /> Board Member/Meeting Expenses/Travel 5,100 6,823 7,426 10,005 10,200 1.95% 100.00%
<br /> Rent 52,B00 51,677 56,611 56,810 57,945 2.00% 9.7496
<br /> Lease Amortization 216,382 235,521 235,523 235,525 235,525 0.00% 8.85%
<br /> Repairs&Maintenance-Bldgs 45,923 39,123 49,014 51,721 45,000 -12.99% -Z01%
<br /> Repairs&Maintenance-Equip. 23,248 21,953 25,903 17,465 24,000 37.42% 3.23%
<br /> Utilities,Telephone,Internet 93,221 94,731 116,034 124,688 125,000 0.25% 34.09%
<br /> Business Insurance 71,809 80,675 94,194 106,020 112,380 6.00% 56.50%
<br /> Store Supplies,Bags&Expenses 147,223 195,814 184,599 166,107 165,000 -1.85% 12.07%
<br /> Employee Travel 29 1,910 1,793 411 500 21.65%
<br /> Office Supplies&Expenses 16,124 32,961 23,841 22,183 20,000 -9.84% 24.04%
<br /> Exterior Maint.Services 25,707 24,487 31,925 26,140 28,000 7.12% 8.9296
<br /> Service Agreements(Data/HVAC/Grants( 76,137 91,779 114,456 120,933 122,000 0.88% 60.24%
<br /> Postage 3,675 3,225 3,619 3,879 3,900 0.54% 6.32%
<br /> Professional Fees(audit and legal) 38,052 32,116 28,499 18,275 19,600 8.34% -47,97%
<br /> Dues&Subscriptions 4,853 7,779 3,087 5,231 5,500 5.14% 13.3396
<br /> Credit Card Processinglbank fees 460,004 524,545 548,646 532,481 538,000 1.04% 16.96%
<br /> Training and Education(Human Resources) 614 10,420 12,090 11,289 10,000 -11.42%
<br /> Burglar Alarm and Security 6,900 6,900 7,315 7,395 7,500 1,42% 8.70%
<br /> Vehicle Expense 20,191 25,148 14,603 12,618 15,000 18.88% -25.71%
<br /> Uniforms 2,699 2,846 311 5,410 3,000 -44.SS% 1115%
<br /> Debt Service(Interest Exp) 97,727 60,793 63,377 59,549 55,315 -7.11% -36.95%
<br /> Interest(leases) 42,552 45,574 40,352 35,018 34,000 -2.91% -20.10%
<br /> Cash Short(Over) (601) -293 -176 1,745 800 -54.15% -233.11%
<br /> Contingencies/Misc. (256) 229 99 102 500 390.20% -295.31%
<br /> Total operating expenses 1,440,113 1,596,736 1,663,041 1,633,000 1,638,865 0.36% 13.80%
<br /> %rncrease 7% 11% 4,15% -1.01% 036%
<br /> Operating Income 2,991,071 2,724,759 2,157,173 1,748,695 1,513,060
<br /> Other Income
<br /> InvestmentlInterest Income 1,989 4,432 5,118 15,755 16,500 4.73% 729.56%
<br /> Miscellaneous 4,067 35 525 5,240 1,500 1 -71.37% -63,1296
<br /> Total Other Income 6,056 4,467 5,643 20,995 18,000 -14.27%
<br /> Net Income Before ProfitDistributions 2,997,127 2,729,226 2,162,816 1,769,690 1,531,060
<br /> Statutory Distributions
<br /> Law Enforcement 166,000 168,000 176,630 164,0OD 200,000 R.70% 20.48%
<br /> Alcohol Rehab&Ed 237,000 252,000 1 261,000 291,000 250,000 -14,09% 5.49%
<br /> Total Statutory Distributions 403,000 420,000 437,630 475,000 450,000
<br /> Net Income Before Profit Distribution 2,594,127 2.309.226 1,725,186 1.294,690 1,081,060
<br /> Profit Distribution
<br /> Orange County-Gen Fund 530,000 700,000 805,000 840,000 881,400 4.93% 66.30%
<br /> %increase 33% 32% M00% 4.35% 493%
<br /> Working Capital Retained(bet.._PBaiexpeases) 2,064,127 1,609,226 920,186 454.690 199,660
<br /> depreciation(norrbudgeraryrte J 441,311 423,518 477,307 507,425 492,805
<br /> 1,622,816 1,185,708 442,879 -52,735 -293,I45
<br /> Capital Outlay 1,715,027 1,770,965 367,966 205,937 500,000 142.79%
<br /> Debt Service 547,199 733,056 152,615 157,615 16�00 2.78%
<br /> 2,262,216 2,504,021 520,581 363,552 662,000
<br />
|