|
Orange County ABC Board BUDGET WORKSHEET
<br /> Multi-Year Comparison Revenues and EK enses
<br /> - pandem(cperfod current
<br /> 2018 2019 2020 2021 2022 2023 2024 2025 chongefmm
<br /> Saies (Actual) {Actual) (Actual♦ Actual) (Actual) (Actual) projected propared current
<br /> Liquor Safes 15,978,795 17,111,567 20,957,512 24,871,360 25,433,856 26,045,623 26,299,205 26,325,190 2.00%
<br /> Wine/Mixer 21,500 26,978 43,999 44,816 41,249 38,237 32,550 34,000 4.45%
<br /> LBD 4,194,074 4,226,045 3,027,061 2,241,857 4,575,131 5,125,307 5,077,895 4,976,330 -2.W%
<br /> Gross Sales 20,184,369 21,364,590 24,028,572 27,159,053 30,050,286 31,209,268 31,409,641 31,835,520 1.36%
<br /> Taxes based on gross sales 4,763,241 5,025,S71 1 5,550,427 6,209,454 6,985063 1 7,261,799 7,303,235 7,401,760 1 1.35%
<br /> Not Sales 15,421,128 16,338,719 18,478,145 20,948,599 23,065,223 23,947,368 24,106,405 24,433,760
<br /> Cost of Sales(includng inwnl.ryadjus1rr niSl 10,468,398 10,929,643 12,503,279 14,231,538 15,484,992 16,103,177 16,369,325 16,458,965 0.55%
<br /> Gross Profit$ 4,952,730 5,41g076 5,974,866 6,717,061 7,580,231 7,844,191 7,737,091 7,974,795 3.D7%
<br /> %h,creas. has. 9% fe% 1296 13% 3% -1.3T5S 3,07%
<br /> Salaries and Wages 1,701,177 1,771,334 1,850,787 1,960,430 2,076,384 2,397,503 7 27608,330 2,921,330 12.00%
<br /> Payroll Taxes 126,673 132,359 129,853 149,065 158,640 179,372 194,382 223,480 14.97%
<br /> Retirement(13.64%in 2025) 140,737 167,163 141,354 164,232 201,166 254,575 295,505 343,255 16.16%
<br /> OPEB adjst 133,341
<br /> Group Health Insurance 308,602 326,162 327,390 336,180 393,337 458,465 516,99E 568,695 1000%
<br /> Retiree's Group Insurance(actuarial) 83,127 $3,127 113,149 113,149 279,146 162,150 162,150 172,000 6.07%
<br /> OPEB ndjst (157,044
<br /> Human Resources 5,392 9,611 8,791 4,141 5,214 23,249 13,025 25,000 91.94%
<br /> 401k 45,465 51,240 47,525 43,765 48,000 66,194 67,980 70,110 3.13%
<br /> Processing tees 2110 4,6961 7,981 7,697 8,009 9,963 9,690 9,975 2-94%
<br /> Total payraff and related 2,413,283 2.545,682 2,626,830 2,778,659 3,159,976 3,526,865 3,858,060 4,333,845 12.04%
<br /> %increase Base 5% 3% 6% 14% 12% 3.61% f204%
<br /> Operational Expenses
<br /> Board Member/Meeting Expenses/Travel 5,775 6,262 7,673 4,950 5,100 6,823 7,479 8,000 6.98%
<br /> Rent 284,926 218,729 199,107 199,952 52,800 51,677 64,330 65,000 1.04%
<br /> Cease Amortization 216,392 235,521 235,522 245,000 4.02%
<br /> Repairs&Maintenance-Bldgs 26,093 21,464 34,220 38.870 45,923 39,123 51,240 42,825 -16.42%
<br /> Repairs&Maintenance-Equip. 6,198 18,879 11,412 32,630 23,248 21,953 29,673 24,500 -17.43%
<br /> Unifies,Telephone,Internet 103,590 96,357 92,066 92,389 93,221 94,731 116,980 128,680 10.00%
<br /> Business Insurance 86,846 74,239 70,461 69,001 71,809 80,675 94,345 103,780 10.00%
<br /> Store Supplies,Bags&Expenses 109,629 108,340 151,406 150,378 147,223 195,914 183,120 195,000 6.49%
<br /> Emptayee Travel 348 784 2,381 0 29 1,910 1,975 2,000 1.27%
<br /> Ol6ce Supplies&Expenses 17,688 13,178 20,418 20,290 16,124 33,058 29,780 28,500 -4.30%
<br /> Exterior Maint.Services 24,090 23,094 22,647 35,065 25,707 24,497 32,190 32,000 -0.59%
<br /> Service Agreements(Data/HVAC/Grants) 38,476 63,107 67363 79,829 76,137 91,779 113,945 115,000 0,93%
<br /> Postage 2,295 3,219 3,078 3,122 3,675 3,225 3,747 4,200 12.09%
<br /> Professional Fees(audit and legal) 31,378 19,783 24,831 23,287 38,052 28,500 28,500 30,000 Safi%
<br /> Dues&Subscriptions 3,193 3,515 4,461 3,614 4,853 7,921 3,210 4,000 24.6196
<br /> Credit Card Processinglbank fees 263,919 297,934 365,621 437,440 460,004 524,545 552,142 579,750 5.00%
<br /> Training and Education(Human Resources) 5,165 6,437 4,468 1,720 614 10,180 12,006 15,000 24.94%
<br /> Burglar Alarm and Security 5,004 5.644 6,952 7,194 6,900 7,220 7,22D 7,500 3.89%
<br /> Vehicle Expense 7,705 9,134 10,970 12,928 20,191 25,148 35,990 20,000 25.08%
<br /> Uniforms 5,382 4,593 4,819 4,755 2,699 2,946 734 2,800 281.47%
<br /> Ceht Service(Interest Exp) 46,734 47,770 136,821 134,640 87,727 60,793 63,457 59,175 -6.75%
<br /> interest(leases) 42,552 45,574 40,461 41,270 2.00%
<br /> Loss on disposal of assets 1,827
<br /> Cash Short(Over) 1,303 1,348 1,390 (587) (601) -293 -974 Sao -151.33%
<br /> ConlingeneiesiMisc, 113 272 63 1 (38) (256) 229 1 165 500 203.03%
<br /> Total operating expenses 1,075,750 1,044,082 1,243,028 1,350,327 1,440,113 1,595,266 1,687,235 1,754,980 4.02%
<br /> %Increase has. -3% 19% 9% 7% 11% 577% 4.02%
<br /> Operating Income 1,463,697 1,820,312 2,105,008 2,539,075 2,980,142 2,722,060 2,181,787 1,885,971)
<br /> Other Income
<br /> Inveslmentflnterast lnoome 740 250 2,173 1,329 1,989 6,259 3,571 2,500 -29.95%
<br /> Mscellaneous 490 1,397 9,443 413 4,067 524 524 500 -438%
<br /> Total Other Income 2,230 1,647 11,616 1,742 6,056 6,783 4,095 3,000 -26,74%
<br /> Net Income Before Profit Distributions 1,464,927 1,821,959 2,116,624 2,589,817 2,986,199 2.726,843 2,165,882 1,80,970 .
<br /> Statutory Distflbutlons
<br /> Law Enforcement 149,300 160,000 147,00o 154,500 166,000 1 168,000 176,631) 190,000 7.57%
<br /> Alcohol Rehab&Ed 212,500 244,000 165,233 164,200 237,1300 252,000 261,000 285,000 9.20%
<br /> Total Statutory Distributions 361,800 404,000 312,233 318,700 403,000 420,000 437,6311 475,000 8.54%
<br /> %increase base 72% -2396 2% 26% 4% 4.20% 8,54%
<br /> Net Income Before Profit Distribution 1,103,127 1,417,959 1,804,391 2,271,117 2,583,198 2,398,843 1.748.252 1,413,970
<br /> PmBt Distribution
<br /> Orange County-Gen Fund 500,000 535,000 500,000 400,000 530,000 700,000 805,0DO 840,000 4.35%
<br /> %increase base 7% -7% -20% 33% 32% 15o0% 4.35%
<br /> Working Capital Retained{before capital orpansesl 603,127 B82,959 1,304,391 1,871,117 1 2,053,198 1,608,843 943,252 573.970
<br /> %6+crease base 46% 43% 43% 10% -22% -41A7% -39.151A
<br /> Capital Expenditures Security Camera Upgrades 25,000
<br /> Delivery truck 130,400
<br /> Debt service(prinerpal) 156,
<br /> 3IZ255
<br /> Appropiated fund balance(prev.retained) (312,255)
<br /> 573,970
<br /> *Depreciatian(non-budget i(em) 318,8116 360,883 400,401 438,188 441,311 423,518 448,040 400,665
<br /> 173,285
<br /> Page 4
<br />
|