|
Orange Catinty ABC Board BUDGET WORK5HEET
<br /> Multi-Year Comparison Revenues and Expenses
<br /> - pandemic perrod -_i current
<br /> 2018 2018 Z020 2021 Z� 2023 202A 2025 change from
<br /> Sales Actual Actual Actual Actual ActDal Actual
<br /> Uquor Sales prxlene4 ropaaed current
<br /> 15,978,795 17,111,567 2.0,957,512 24,871,380 25,433,856 26,D45,623 25,293,940 26,B19,820 2.00%
<br /> Wine/Miner
<br /> L80 21,500 26,978 43,999 44,816 41,249 38,237 31,465 34,D00 8.06%
<br /> 4,184,074 4,226,045 3,027,061 2,241,957 4,575,181 5,125,307 5,O80800 4,979,195 -.00%
<br /> Gross Sales 20,194,369 21,364,590 24,028,572 27.159,059 30,050,286 31,209,168 31,406,205 31,833,005 1.36%
<br /> Taxes based on gross sales 4,763,241 1 51025,871 5,550,427 6,209.454 15,985,063 7,261,799 q2.627,615
<br /> 7,401,175 1.3fi%
<br /> Not Sales 15,421,128 16,338,719 1$478,145 20,948,599 23,065,223 23,947,36824,431,830
<br /> CoslofSales(Including invaniuryadJusunenlej 10,465,398 10,928,643 12,503,279 24,231,53a 1s,484,992 16,I03,177 16,457,fi65 0.55%
<br /> Gross Profit$ 4,952,730 5,410,076 5,974,966 6,717,061 7,580,231 7,844,191 7,974,165 3.08%
<br /> %ncreasa base 996 1o% 72% 12% 3%Salades and Wages 1,701,177 ,771,334 1,850,787 1,960,430 2,07fi,3Bq 2,397,503 2,942,930 12.00%
<br /> Payroll Taxes 126,673 132,359 129,853 149,065 158,640 179,872 195,995 225,135 14,87%
<br /> Retirement(13.64%fn 2025) 140,737 167,163 141,354 164,732 201,166 254,575 301,195 345,795 14.91%
<br /> OPEB adjst 133,341
<br /> Group Health Insurance 300,602 326,162 327,390 336,180 383,337 - 458,465 526,135 578,)50 __ _
<br /> -- Retiree's Group fnsuronc Wtuadal)----- 83,127 83,127 113,149 113,149 27-R, 10.00%
<br /> 146 ].62,15p 162150 172,Q00 0.0%
<br /> OPEB adjst (157,047J ,
<br /> Human Resources 5,392 9,611 8,791 4,141 5,214 23,249 12,965 25,000 92.83%
<br /> 40lk 45,465 51,240 47,525 43,765 48,080 66,194 63,005 70,630 3.86%
<br /> Processing fees 2110 4,686 7,981 7,697 8,009 9,063 9,640 9,975 3,48%
<br /> Total payrall and mlated 2.413.283 2,545,6E12 2,626,830 2,770,659 3,159,976 3,526,865 3,903,701 4,370,215 11.95%
<br /> %hrree¢e base 5% 3% 6% 14% 12% MOM f 2s%
<br /> Operational Expenses
<br /> Board Member/Meeting Expenses/Travel 5,775 6,262 7,673 4,950 5,100 6,823 7,406 8,000 8.02%Rent 284,926 218,729 199,107 198,952 52,800 51,677 62,100 65,000 6.24%
<br /> Lease Amortization 216,382 235,521 236,402 245,000 3.64%
<br /> Repairs&Maintenance-RRidgedlis 26,093 21,464 34,220 38,870 45,923 39,123 51),860 42,825 -15.8096 Repairs&Maintenance-Equlp. 6,198 19,879 11,412 32,630 23,248 21,953 26,193 24,500 -6.4696 Utilities,Telephone,Internet 108,590 95,357 92,066 92,388 93,221 94,731 112,744 124,020 10.00%
<br /> Business Insurance 86,846 74,239 70,461 6%001 71,809 90,675 94,270 103,695 10.00%
<br /> Store Supplies,Bags&Expenses 109,629 108,340 151,406 150,379 147,223 195,814 1791 195,000 8.57%
<br /> Employee Travel 348 784 2,381 0 29 1,910 1,971 2,00D 1A7%
<br /> Office Supplies&Expenses 17,688 13,179 20,418 20,290 16,124 33,058 29,495 28,500 -3.37%
<br /> Exledor Malnt Services 24,090 23,094 22,647 35,065 25,707 24,487 31,837 32,000 0.51%
<br /> Service Agreements{DataJHVAC/Grants) 38,476 63,107 67,763 79,829 76,137 91,779 112,043 115,000 2.69%Postage 2,295 3,219 3,078 3,121 3,675 3,225 3,384 4,200 24.11%
<br /> Professional Fees(audit and legal) 31,378 19,783 24,831 23,287 38,052 28,698 28,698 30,000 4.54%
<br /> Dues&SubscdIaVons 3,193 3,515 4,461 3,614 4,853 7,921 6,703 4,000 -40.33%
<br /> Credit Card Proceasingtbank fees 263,819 297,934 -465,621 437,440 460,O134 524,645 551,135 578,695 5.00%
<br /> Training and Education(Human Resources( 5,165 6,437 4,468 1,720 614 10,180 11,812 15,000 26,99%
<br /> Burglar Alarm and Security 5,004 5,644 6,952 7,194 1 7,279 7,275 7,500 Vehicle Expense 7,705 9,134 10,970 12,828 2D,191 25,148 15,813 20,000 26.48%Uniforms5,382 4,593 4,819 4,755 2,699 2,846 430 2,800 551.16%
<br /> Debt Service(Interest Exp) 46,734 47,770 136,821 134,640 87,727 60,793 63,721 59,175 -7.13%
<br /> Interest(leases) 42,552 45,574 4OA37 41,450
<br /> Lass an disposal of assets 1,827
<br /> Cash Short(aver( 1,303 1,348 I,390 (587) (601) -293 -1,198 Soo -141,74%
<br /> ConlingencieslMlsc. 113 272 63 (38 25fi) 229 SZ8 Soo 3 3 73%
<br /> Total operating expenses 1,075,75Q 1,044,082 1,243 028 1,350,327 1,440,113 1,595,514 1,672,526 1,749,360
<br /> 4.59%
<br /> %haraesa base _3% 12% 9% 7% 11% 4.63% 4.59%
<br /> Operating Income 1,463,697 1,820,312 2,105.008 2,56$075 2,960,142 2,721,807 2,159,916 1,854,590
<br /> Other Income
<br /> Investmentllnterest income 740 250 2,173 1,329 1,989 6,259 5,050 2,500 -50.50%
<br /> Miscaftneous 499 1,397 9,443 413 4967 525 525 SOD 4.76%
<br /> Total Other Income 1,230 1,647 11,616 1,742 6,056 6,784 5,575 3,Opo 46,19%
<br /> Net Income Before Profit Distributions 1,464,927 1,321,959 2,116,624 2,589,817 2,996,198 2,728,547 2,765,491 1,857,590
<br /> Statutory Distributions
<br /> Law Enforcement 149,309 160,D00 147,000 154,SOO 166,ON 168,000 176,630 184,OOp 4.17%
<br /> Alcohel Rehab&Ed 212,500 244,000 165,233 g11,42U11 =" 16,,Wo1,W0 261,000 291,000 11.49%
<br /> Total Statutory Distributions 361,800 404,000 312,2330,o00 437,630 475,gpo 8.54%
<br /> 12% -23% 4% 4.20% &54%
<br /> Net Income Before Profit Distribution 1,103,127 1,417,959 1,804,391 ,308,591 1,727,881 1,382,5Bo
<br /> Profit Distribution
<br /> Orange County-Gen Fund SOO535,000 SDO,00❑ 0,000 805,000 840000 4.35%
<br /> base 7% 32% 1500% 4.m%
<br /> Working Capital Retained @atom,ltetexpenaec] 603,127 B$2,959 1,304,391 8,591 922,861 542,590
<br /> %ncreese peas 46% 48% 43% 7a% -22% .4z63% -41z1%
<br /> -- -- - - - - - Capllaf enditures- -- - SecgrltyCarderrGpgrades 25,00�
<br /> Delivery truck 130,400
<br /> Debt service(principal) 156855
<br /> 312,255
<br /> Appropiated fund balance(prey,retained) (312,255)
<br /> 542,590
<br />
|