|
Orange County ABC Board BUEIGET WORKSHEET
<br /> Multi-Year Comparison Revenues and Ex erl
<br /> (base) (current)
<br /> 2022 2023 2024 2025 2026 96choage from
<br /> Sales (Actual) (Actual) (Actual) projected BUDGET previous year
<br /> Liquor Sales 25,433,856 26,045,623 26,233,194 25,630,305 25,950,000 1.25%
<br /> Wine/{Mixer 41,249 38,237 30,698 3,575 500 -96.01%
<br /> LBD 4,575,181 5,125,307 5,047,452 4,693,140 4,650,000 -0.92%
<br /> Gross Sales 30,050,286 31,209,168 31,311,344 30,327,020 30,600,500 0.90%
<br /> Taxes based on gross sales 6,985,063 7,261,799 7,278,602 7,045,390 7,108,495 6.90%
<br /> Net Sales 23,G65,223 23,947,368 24,032,742 23,281,630 23,492,005
<br /> Cost 4f(Moods(including Inventory adjustments) 15,474,063 16,103,177 16,324,990 15,827,760 15,942,865 0.73%
<br /> Gross Profit$ 7,591,160 7,944,191 7,707,752 7,453,870 7,549,140
<br /> %increase 13% 3% -1.74% -3.29% 1.28%
<br /> Salaries and Wages 2,076,384 2,397,503 2,612,849 2,649,683 2,755,670 4.00%
<br /> Payroll Taxes 158,640 179,372 195,905 199,069 205,675 3.32%
<br /> Retirement 18oard's portion) 201,166 254,575 301,622 323,275 340,090 5.20%
<br /> Group Health insurance 383,337 454,591 525,566 514,308 529,025 2,96%
<br /> Retiree's Group Insurance(actuarial) 279,146 139,149 162,148 176,632 185,000 4.74%
<br /> Human Resources 5,214 23,249 11,899 7,716 10,000 29.60%
<br /> 401k 48,080 66,194 67,913 65,537 67,000 2.23%
<br /> Processing fees 8,009 9,063 9,637 9,740 9,850 1.13%
<br /> Total payroll and related 3,159,976 3,522,696 3,887,539 3,945,960 4,102,310
<br /> Operational Expenses
<br /> Board Member/Meeting Expenses/Travei 5,100 6,823 7,426 9,745 10,200 4.67%
<br /> Rent 52,800 51,677 56,611 57,290 58,435 2.00%
<br /> leas,Amortization 216,382 235,521 235,523 235,525 235,525 0.00%
<br /> Repairs&Maintenance-Bldgs 45,923 39,123 49,014 50,660 44,000 -13.15%
<br /> Repairs&Maintenance-Equip. 23,248 21,953 25,803 18,930 23,000 21.50%
<br /> Utilities,Telephone,Internet 93,221 94,731 116,034 126,598 125,000 -1.26%
<br /> Business Insurance 71,809 80,675 94,194 107,344 113,785 6.00%
<br /> Store Supplies,Bags&Expenses 147,223 195,814 184,599 170,791 165,000 -3.39%
<br /> Employee Travel 29 11910 1,793 411 500 21.65%
<br /> Office Supplies&Expenses 16,124 32,961 23,841 22,285 20,000 -10.25%
<br /> Exterior Maint.Services 25,707 24,487 31,925 26,285 28,000 6.52%
<br /> Contract Service Agreements 76,137 91,779 114,456 120,985 122,000 0.84%
<br /> Postage 3,675 3,225 3,619 3,892 3,900 0.21%
<br /> Professional Fees(audit and legal) 38,052 32,116 28,499 16,818 19,800 17.73%
<br /> Dues&Subscriptions 4,653 7,779 3,087 5,662 5,500 -2.86%
<br /> Credit Card Processing/bank fees 460,004 524,545 548,646 534,720 535,000 0.05%
<br /> Training and Education(Human Resources) 614 10,420 12,090 10,172 10,00D -1.69%
<br /> Burglar Alarm and Security 6,900 6,900 7,315 7,330 7,500 1.63%
<br /> Vehicle Expense 20,191 25,148 14,603 13,777 15,OOD 8.88%
<br /> Uniforms 2,699 2,846 311 5,409 3,000 -44.54%
<br /> Debt Service(interest Exp) 87,727 60,793 63,377 58,969 54,315 -7.89%
<br /> Interest(leases) 42,552 45,574 40,352 34,836 30,n0D -13.88%
<br /> Cash Short(Over) (601) -293 -176 1,594 500 -58.63%
<br /> Contingencies/Misc. 1256) 229 99 67 Soo 646.27%
<br /> Total operating expenses 1,440,113 1,596,736 1,6631041 1,640,145 1,630,460 -0.59%
<br /> increa 7% 11% 4.15% -1.36% -0.59%
<br /> Operating Income 2,991,071 2,724,759 2,157,173 1,367,765 1,916,370
<br /> Other income
<br /> InvestmenUlrHerestincome 1,989 4,432 5,118 17,450 30,000 7192%
<br /> Miscellaneous 4,067 35 525 5,300 1,500 1 -71,70%
<br /> Total Other Income 6,056 4,467 5,643 22,750 31,500 38.46%
<br /> Net Income Before Profit Distributions 2,997,127 2,729,225 Z16ZB16 1,890,515 1,847,870
<br /> Statutory Distributions
<br /> Law Enforcement 165,000 168,1300 176,630 184,OOD 200,000 8.70%
<br /> Alcohol Rehab&Ed 237,OOD 252,000 261,000 291,000 261,000 -10.31%
<br /> Total Statutory Distributions 403,00D 420,000 437,630 475,000 461,000
<br /> Net Income Before Profit Distribution 2,594,127 2,309,226 1,725,186 1,415,515 1,386,870
<br /> Profit Distribution
<br /> Orange County-Gen Fund aj
<br /> 700,000 805,000 840,000 8B1,600 4.95%
<br /> %incease 32% 15.00% 4.35% 4.95%
<br /> Working Capital Retained(before capital expenses) 1,609,226 920,186 575.515 505,270
<br /> depreciation(non-budgetmyitem) 441,311 423,518 477,307 505,469 492,805
<br /> 1,622,815 1,185,708 442,879 70,046 12,455
<br /> Capital Outlay 1,715,027 1,770,965 367,966 210,937 300,000 42.22%
<br /> Debt Service 547,189 733,056 152,615 157,057 162A00 3.15%
<br /> 2,262,216 2,504,021 520,581 367,994 462,000
<br /> Page 3
<br />
|