|
Orange County ABC Board WORKSHEET
<br /> Multi Year Comparison Revenues and Expenses
<br /> pandemic period Bart need pmpasrd
<br /> 201a 2019 2020 2021 2fl22 2023 2024
<br /> Sales {Actual (Actual) (Actual) (Actual) Actual 0/34,70"
<br /> Liquor Sales 15,978,795 17,111,567 20,957,517 24,871,380 25,433,956 25,699,955 26,459,625 3.00%
<br /> Wine/Mixer 21,500 26,978 43,999 44,816 41,249 39,270 40,050 k65%
<br /> LID 4,194,074 4,226,045 3,M7,1161 2,241,857 4,575,181 5,075,020 4,567,520 -10.00%
<br /> Gross Sales 20,194,369 21,364,590 24,028,572 27,158,053 30,050,286 30,802,245 31,067,195 0,86%
<br /> %irrrnrase base 505% 1247% 13.02% ?065S£ 2%% 086%
<br /> Taxes based on gross sales 4,763,241 5,025,871 5,550,427 6,209,454 6,985,063 7,220,805 7,453,020 3,36%
<br /> Costal Sales(Fdutling mvenuay adlus6neniel 10,468,398 10,928,643 12,503,279 14,231,538 15,484,992 15,927,225 16,232,620 1,92%
<br /> %inWreSe basil 4.75% 13.16% 12.22% 9.92% 297% 237%
<br /> Gross Profit$ 4,952,730 5,410,076 5,974,866 6,717,061 7,580,231 7,664,215 7,381,565 -3,69%
<br /> Salaries and Wages 1,701,177 2,771,334 1,850,787 1,960,430 2,076,394 2,410,820 2,576,200 6s6%
<br /> Payroll Taxes 126,673 132,359 129,053 149,065 158,640 183,685 197,080 7.29%
<br /> Retirement 140,737 167,163 141,354 164,232 201,166 255,445 273,910 7.23%
<br /> Group Health Insurance 308,602 326,162 327,390 336,180 383,337 450,875 475,000 5.35%
<br /> Retiree's Group Insurance'lartuarial) 83,127 89,127 113,149 113,149 279,146 138,150 175,000 26.67%
<br /> Human Resources 5,392 9,611 8,791 4,141 5,214 24,325 20,aD0 .17.78%
<br /> 461k 45,455 51,240 47,525 43,765 48,080 66,535 68,205 2.51%
<br /> Processing fees 2110 4,686 7,981 7,697 B4O09 9,550 9,6GO 0.53%
<br /> Totaf payroll and related 2,413.283 2,545,682 2,626,830 2,T78,659 3,159,976 3,539,385 3,794,995
<br /> %i�reese base 5% 3% 6% f4% 12% 722%
<br /> Operational Expenses
<br /> Board Member/Meeting Expenses/Travel 5,775 6,267 7,673 4,950 5,100 6,825 8,500 24.54%
<br /> Rent 284,926 218,729 199,107 198,952 52,800 52,595 66,005 25.50%
<br /> Lease Amortization 216,382 243,050 -46,085 1.25%
<br /> Repairs&Maintenance-Ildgs 26,093 21,464 34,220 38,B70 45,923 46,025 45,000 -2.23%
<br /> Repairs&Maintenance-Equip. 6,198 18,879 11,412 32,630 23,248 24,320 25,000 7-8fi%
<br /> Utilities,Telephone,Internet 103,590 96,357 92,066 92,388 93,221 90,220 95,a0a 5.30%
<br /> Business Insurance 86,846 74,239 70,461 69,061 71,809 80,250 88,275 10.00%
<br /> Store Supplies,Bags&Expenses 109,629 108,340 151,406 150,378 147,223 187,186 175,000 -6.51%
<br /> Employee Traver 348 784 2,381 0 29 3,481 3,500 0.55%
<br /> Office Supplies&Expenses 17,688 13,178 20,418 20,290 16,124 29,130 24,1100 -11.61%
<br /> Exterior Maint.Services 24,090 23,094 22,547 35,065 25,707 24,637 28,000 13.65%
<br /> Service Agreements{Data/HVAC) 3%476 63,107 67,763 79,829 76,137 92,182 95,01111 306%
<br /> Postage 2,295 3,219 3.078 3,121 3,675 3,253 3,4011 4.52%
<br /> Prafessiona$Fees(audit and legal} 31,378 19,793 24,031 23,287 38,052 32,356 35,000 9.14%
<br /> Dues&Subscriptions 3,193 3,515 4,461 3,614 4,853 4,318 4,500 4.21%
<br /> Credit Card Processingl0ank fees 263,819 297,934 365,621 437,4411 460,004 521,945 563,700 9.00%
<br /> Training and Education(Human Resources( S1165 6,437 4,468 1,72u 614 8,341 10,a00 19.89%
<br /> Burglar Alarm and Security 5,004 5,644 6,952 7,194 6,900 6,900 7,200 4.35%
<br /> Vehicle Expense 7,705 9,134 10,970 12,828 20,191 25,503 30,000 17.63%
<br /> Uniforms 5,382 4,593 4,919 4,755 2,699 2,924 3,SOu 19.70%
<br /> Debt Service(Interest Exp) 46,734 47,770 136,821 134,540 87,727 S3,525 62,570 17.09%
<br /> Interest(leases) 42,552 44,050 -5.33%
<br /> Cash Short(Over) 1,303 1,348 1,390 (587) (601) 518 Soo' -3.47%
<br /> Contingencies/Misc. 113 272 63 (381 (256( 206 500 142.72%
<br /> Total operating expenses 1,075,750 1,044,082 1,243,028 1,350,327 1,440,113 1,583,750 1,661,595 4.92%
<br /> %Irncreass base 3% 19% 9% 7% 10% 4.92%
<br /> Operating income 1,46%697 1,820,312 2,105,008 2,588,075 2,980,142 2,541,080 1,924,976
<br /> Other Income
<br /> Investmentllnkerest Income 740 250 7,173 1,329 1,9B9 6,020 2,500
<br /> Miscellaneous 490 1,397 9,443 413 4,067 35 1,000
<br /> Total Other Income 1,230 L647 11,616 1.742 1 6,056 6,055 3,500
<br /> Net Income Before Profit Distributions 1,464,927 1,821,959 2,116,624 2,599,817 2.986,198 2,547,135 1.928,475
<br /> Statutory Distributions
<br /> Law Enforcement 149,300 160,o00 147,000 154,500 166,000 168,90c 175,000 4.17%
<br /> Alcohol Rehab&Ed 212,500 244,0W 165,233 164,200 237,000 252,000 275,OOD 9.13%
<br /> Total Statutory Distributions 361,800 404,000 312,233 318,700 403,000 420,000 450,000
<br /> %ixreeso base 12% .23% 2% i6 4% 7.14%
<br /> Net Income Before Profit Distribution 1,103,127 1,417,959 1,804,391 2,271,117 2,583,190 2,127,135 1,478,47S
<br /> Profit Distribution
<br /> Orange County-Gen Fund 500,000 F 535,000 500,000 400,000 530,000 700,000 805,Gau 15.00%
<br /> %increase base 7% -7% -20% 33% 32% 1500%
<br /> Working Capital Retained Jim-capital aapaasaa} 603,127 1 882,959 1,304,391 1,871,117 2,053,198 1,427,135 673,475
<br /> %increase base 46% 48% 43% 10% 30% -52.01%
<br /> '0epreclo6on 318,806 360,883 400,4111 438,1B8 441,311 417,045 554,985
<br /> Capital Expenditures Debt service(principal) 74,375 154,000 Debt service(principal)
<br /> Store construction I,492,690 35,000 Replace windows
<br /> Change orders/Projeel AdmirsfsrtmUon 23,560 7,500 Grant software
<br /> Furniturefixtures andequipment 127,595 3,500 Boardroom monitor
<br /> 5,000 Replace security DVR
<br /> Refrigerator unit 2,580
<br /> Southern Village I22,159 125,000 New delivery truck
<br /> 8,500 Replace Fre panel
<br /> office copier 5,950 1,500 Addt computer
<br /> 10,000 Additional racking
<br /> Chopel hill North payoff 685865 2,500 Addt scanners
<br /> 2,534,774
<br /> 10_000 Upgrade cameras
<br /> Capital receipts{FH) [12I5,922) 362,500
<br /> 1,319,854
<br /> Rppropriatedfund balance (371,0I5) (362,500) Appropriatedfund balance
<br /> (prevlons year) (previous year)
<br /> Page 947,839 673,475
<br />
|