HomeMy WebLinkAbout2023d ABC Board Minutes ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: August 22, 2023 Agenda Item# 6a
Regular Session X
Closed Session
- I
Presenter/Information Contact: Ron McCoy
Subject: July 2023 Financial Reports
I
Attachment(s):
1. Attachment"A"Comparative Statement of Net Position for July 2023.
2. Attachment `B" Comparative Statement of Revenues, Expenses and Changes in Net
Position for July 2023 and 2022.
3. Attachment"C"Actual to Budget Comparison, FY 2023.
Brief Summary/Explanations:
1. Comparative Statement of Net Position (Attachment"A"):
Total cash held by the Board in July ($3,999,057) increased $209,543 (5.53%) over the
previous year. Inventory ($4,399,446) increased $310,414 (7.59%) in response to continually
elevated sales levels and the addition of the Southern Village and the new Mebane stores.
Payable liabilities ($1,802,107) increased $526,705 (41.30%), an indicator of elevated
inventory volumes. Long-term liabilities increased by $245,500 (6.34%) due primarily to the
First Horizon loan on store 004(Mebane). Income for the month/year was $47,643, down
-$60,102 (-55.78%).
2. Comparative Revenue, Expenses and Changes in Net Position 2023 to 2022 j
(Attachment"B"):
Retail store sales for the month ($1,961,761) were up modestly (0.51%). LBD/commercial
sales declined slightly(4.15%) due primarily to the onset of the summer vacation season. All
store liquor sales were down from the previous year except for Store 004(Mebane),up$85,121
(43.80%) and Store 008 (Southern Village), up $65,058 (100%) (see agenda item 5b). Total
sales for the month/year($2,298,037) increased 0.26%.
Payroll(+0.97%) and operating expenses (+0.18%)were virtually unchanged from the
previous year.
Cost of goods/sales increased substantially, up $50,459 (+4.44%). This increase
significantly affected net income for the month ($47,643 after depreciation), a decrease of
-$60,102 (-55.78%).
i
r
Page 1 of 5 pages
I
I
ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: August 22, 2023 Agenda Item# 6a
Regular Session X
Closed Session_
3. Actual to Budget Comparison for Year-to-Date 2023 (Attachment"C"):
With one month elapsed in the new fiscal year, approximately 91.67% of allocated
funds should remain in the annual budget. With sales revenues,payroll, and operational
expenses comparable to the previous year, the budget for the month is as anticipated.
A belated/unforeseen final invoice for engineering and project management for Store
004 ($2,900) arrived from the architect and has been recorded against capital expenditures.
Increased demand in stores for refrigerated products prompted the purchase of a new cooler
$3,280) for Store 003 (Chapel Hill North).
Work on the replacement of the fire panel in the warehouse has been completed and
will be paid for in August. New racking for storage and the new warehouse delivery truck for
have been ordered. The new boardroom monitor has also been installed.
Action Requested:
1. Consent Agenda Item.
2. Review and discuss as needed.
Financial Impact: See Above
Staff Recommendations/Comments: None
i
i
Page 2 of 5 pages
i,
Orange County Alcoholic Beverage Control Board
Comparative Statement of Net Position
As of July,2023 and 2022
Attachment"A"
Assets
2023 2022 Variance
Current Masts -
Cash If Cash Equivalents
Cash-Truhu 435,467 2,424,116 (1,988,658)
Cash-Roxboro Savings 420,268 963,606; (543,338)
Cash-First Horizon 3,126,332 386;093'. 2,739.239
Cash-Change Banks 18,000 16,7001 2,300
Total Cash&Cash Equivalents 3;999,057 3.780.614! 209,543 5.53%
Accounts Receivable 1,327 3,054j (2,327)
Prepaid Expenses 193,410' 134,6211 58,769
Dletributlons(Prepaid) 206,271
Security Deposits 20,736 20,736 -
Inventory 4.399,446' 4,089,032', 310,414 7.59% j
Invmgmy(bags) 45,495. 69,634'. (24,139)
Lease Asset 2,053,336'. 2,053,336,
B920:021' 61371,013! 549,008
Total Current Assets 10,919;076 10,180,52]! 758,657
Property&Equipment
Land,Buildings&Improvements 13,353,023 10,149,391 3,203,632
Vehicles&Equipment 2,226,234 1.882,011'. 344,223
Total Property&Equipment 16,679,267 12:031,40T 3,547,856 L,
Less:Accumulated Depreclatlon (4,403,276). {0,976,609); (426.687)
Accumulated Lease Amortization (479 058). (236,130), (242,928)
Net Property&Equipment 10:696y923 7,818,M 2,678,240
Other Assets(Pension)
Deferred Curlew Asset(OPEB) -242,307 -242,38P
Pension Deferralk/W Penslon Most 343,977 343977' - -
Deferred Outfbws of Resources 201J66 : 201,166
302,766: 302,756-Construction in Progress(Southern Village) 0 25,436: (25,436)
Construction in Progress(Mebane) 0. 1.760228, (1,760,228) _
Total Other Assets 0 11775,064; (1,776.664)
Total Assets 21.018,757 20:057:630 1.861,12]
Liabilities and Equity
Current Liabilities
Accounts Payable
Trade 1.662.858. 1,161,614 601,244
Other 109,249 113,788, 26,461
1,802,107 777TMAT 528706 41.30%
Excise Taxes 527,169'. 526.131, 1,038
Other Taxes 142,540' 141,960'. 580
Payroll Llabllities 80,762 53,134', 27,618
Payroll Accmals 54.268 79,873:. (26,605)
Accrued Interest(lease) 24.171 18,760, 6,411
828.900' 819.858 9,042 1.10%
Other Current Liabilities
Net Llabllity(OPEB) 546,066 540,056 -
Deferred Pension Liability 363,462' 363A62:Deferred MUM of Resources(Penslon) 549,636 549;636 -
Lease Liability(current portion) 218.947 188,363 30.594
`1,678,101 < 1,647.507 30.594
Long Term Liabilities
Note Payabl8(Pirst Horizon) 2,642,189 1,449,266!. 1,192,933
Note Payable(Tmist) 0 572,299. (572,299)
Long Term Debt Adjustmenthaudllor Z0,400 0' (50,408)
Long Term Debt Adfustrnent(leaee) 41,334 139,524, (98,190)
Lease Liability(longterm portion) 1,486,277. 1,712,813'. (226.538)
4.119,392 3.8738921, 245,600 8.34%
Distributions
Payable to Law Enforcement 0 (376)'; 375
Payable to Education 0 18,600' (18,500)
Payable to County 0 68333 (58,333)
Total Cu nantILT Liabilities 0 76.4581 (76458)
Equity
Balance Beginning oflhe year 13,442.614 12,256,76B' 1,185,846
Add Income(Loses)Year-to-Date 47,643 107,7451 (60,102) -56.78%
Balance End of the Period 13,490,257 12,364,6131 1,125,744
-- Total Liabilities&Equity 2L918.75R 20.05]630: 8861,127
3
i
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Revenues,Expenses and Changes in Net Position
For the month of July,2023 and 2022 Attachment"B"
July July $ %
sales 2023 2022 Variance Variance
Retail-Liquor Sales 1,961,761 1,951,835 9,926 0.51
Wine/Mixers Sales 2,620 2,624 (4) -0.15%
Commercial/LBD1MIxed Beverage-Liquor Sales 333,656 337,523 3,867 -1A6%
Total Sales 2,298,037 2,201,982 6,055 0.26%
Less Taxes Based on Gross Sales 532,126 631,200 926 0,17
Net Sales 1,766.911 1,760,782 5129 0.29%
Less;Cost of Sales(Inc.breakage/adJsts.) 11186,068 1,135,609 50459 4.44%
Gross Profit 579843 625173 45.330 -7.25%
Payroll&Related Expenses li
Salaries&Wages 161,589 177,562 (15,973) -9.00%
Payroll Taxes 13,566 12,746 820 6,43%
Emp Retirement 20,687 - 18,101 2,586 14.29%
Health Insurance 46,472 31,169 15,303 49.10%
Retiree Health Ins 11,512 11,512 0.00%
Human Resources 473 266 207 77.82%
NC401k 4,846 5,370 (524) -9.76%
Processing fees 703 633 70 11.11
Total Payroll&Related 259,848 257359 2,489 0,97%
Operating Expenses
Board Members/Meeting/Travet/Training 504 1,301- (797) -61.26%
Rent 9,926 4,521 5,405 119.55%
Lease Amortization 19,627 19,748 (121) 100.00%
Repairs&Malnl. (Bldgs) 4,876 2,757 2,119 76.88%
Repairs&Munt.(Equip.) 1,677 3,379 (1,702) 100.00%
Utilities,Telephone and Internet 5,403 8,532 (129) -1.51%
Insurance-Buslness 7,081 6,409 672 10.49%
Store Expenses,Supplies and Bags 15,317 14,969 348 2.32%
Travel/Mileage Reimbursement - 0.00%
OfflcmWarehouse Supplies&Expenses 1,797 3,280 (1,483) -4521%
Ext.Maintenance Services 2,212 2,100 112 5.33%
Contract(Service Agreements 9,140 7,679 1,461 19.03%
Postage 350 -140 210 0.00% '..
Professional Services(legallaudit) 2,000 '1,975 25 1.27%
Dues/Subscrlptlons/Licenses 166 237 (71) -29.96%
Credit Card Processing/Bank fees 41,217 39,503 1,714 4.34%
Training/EducatloNMeeting 49 118 (69) 100.00%
Burglar Alarm&Security 575 575 0.00%
Vehicle Expense 526 '. 9,173 (8,647) -94,27%
Uniforms 311 -. 43 26B 0.00%
Interest(Debt Service) 5,512 4,281 1,231 28,75%
Interest(Leases) 3,564 —3,832 (26B) 100.00%
Cash over/short (251 (144) (107) 74.31%
ConlingencleslMlac. 5 (19) 24 -126.32%
Total Operating Expenses 134,584 134,389 195 0.15%
Total PayrolVOperating Expenses 394,432 391,747 2,685 0,69%
Income from Operations 185,411 233,426 (48,015) -20.57% ',
Other Income
Investment income 450 166 284 171.08%
Miscellaneous 290 290 0.00%
Total Other Income 740 166. 574 345.78%
Net Income Before Distributions 186,151 233,592 (47,441) -20.31
Statutory Distributions:
Law Enforcement(6%) 14,719 14.000 719 5.14%
Alcohol Rehabilitation&Educallon(7%) 21,750 21,000. 760 3.57%
Total Statutory Distributions 36,469 36,000 1,469 4.20%
Net Income Before Profit Distribution 149,682 1 1 8,592 48,910 -24.63%
Profit Distribution:
Orange County-General Fund 66.667 58,333 8,334 14.29%
Net Income(Loss)before depreciation 83.015 140269 (57,244) -40.81%
depmclatlon 35,372 32,514
47.643 107,745 (60,102) -55.78%
I
Year to Date Sates Comparison current (current)
Sales FV 2024 FV 2023 Change % li
Retail Liquor 1,961,781 1,951,835 9,926 0.61%
_. Wine Sales 2,620 2,624 (4) -0.16
LBD Sates 333,656 337,523 3,867 .1.16
Total Sales 2,298,037 2,291,982 6,065 0.26%
Net Income(YTD) 47,843 107,745 60,102 -55.78%
4 I
Orange County ABC Beard j
Actual to Budget Comparison
For theflscal year ending 0613012024 Attachment'C'
JULY YTD 2024 Balance %
Sales 2023 Budget Remaining Bernardo, I
Liquor Sales 11961.761 1,961,761 26,613,255 24,651,494 92.63%
W1ne/Mixer 2,620 21620 40,050 37,430 93.46%
LEAD 333,656 333,656 4,615,680 4282024 92.77%
Grass Sales 2.298,037 2,298,037 31,268,985 28,970,948 9265%
Taxes based on Broad..Is 532,126 - 592,126 7,501,430 6,969,304 02.91%
Net Sales 1,765,911 1,765,911 23,767,566 22,001,644 92.57%
Cost of Sales(inebe,p imenior,mlmumnm) 1,186,065 1,185,068 16,398,045 15,151977 92,74% III
Gross Profit 679,843 579,g43 7,429,510 6849,667 92.2MA
Payroll and Related Expenses fienobmmk
Salaries and Wages 161.689 161,589 2,576,200 2,414,611 93.73% 91.67%
Payroll Taxes 13,566 13,566 197,080 183,514 93.12%
Retlrement 20,687 - 20,687 273,910 253,223 92.45%
Group Health Insurance 48.472 46,472 485,000 08,528 90.42% '
Realm 's Group Insurance 11.512 11,512 170,000 158,488 93.23%
Human Resources 473 473 25,000 24,527 98.11%
4011, 4.846 4,846 68,500 63,654 92.93%
Processing fees 703 703 91600 8,897 92.68%
Total payroll related expenses 20.848 259,848 3,805,290 3,545,442 93.17%
Operating Expanse.
Beard Membereadeeling/Tr.ve1/Tralning 504 SIX 0,500 7,996 94.07%
Rent 9,926 9,926 66,005 56,079 84.06%
Lease Amertlmtlon 19,627 19,627 246,085 226,458 92.02%
Repairs&Maintenance-Bldgs 4,876 '4,876 42,000 37,124 88.39%
Repairs&Maintenance-Equi, 1,677 1,677 25,000 23,323 93.29%
Otilities,Telephone,Internet 8,403 8,03 95,000 86,597 91.15%
Business Insurance 7,081 7,081 88,275 81,194 91.98%
Store Supplies,Begs and Expenses 15,317 15,317 180,000 164,683 91.49%
Employee Travel - - 0 31500 3,500 100.00%
Offlce Supplies&Expenses 1,787 1,797 25,000 23,203 92.81%
Maintenance Servlces 2,212 2,212 28,000 25,788 92.10%
Service Agreements(Data/HVAC) %140 9,140 95,OD0 85,860 90.38%
Postage 360 350 3,400 3,OS0 09.71%
Professlonal Fees(office)(audit and legal) 2,000 2,000 35,000 33,000 94.20%
Does&SubscH Lions 166 166 4,900 4,734 96.61% j
Credit Card Processing 41.217 < 41,217 565,115 523,898 92.71%
Training and Education 49 < 49 Tom 9,951 99.51%
Burglar Ala rm and Security 576 - 575 7,200 6,625 92.01%
Vehl[le Expense 526 526 301000 29,474 98.25%
Uniforms 311 311 4,000 3,689 92.23%
Debt Service(interest expense) 5,612 '. 5,512 62,675 57,163 91.21%
Interest(Losses) 3.564 3,564 41,260 37,696 91.36%
Cash aver/short (251) (251) 500 751 150.20%
Cm ingrad,a/Mbc. 5 -5. 500 495 99.00%
rate/operating expenses 134.584 134,S$41 1,666,915 1,532,331 91.93% -
Total OperdtinglPayrcll Etta.usas 394,432 394,432 5,472.205 5,077,779 92.79%
Income hom Operations 186,411 185,411 1.957,305 1,771,894 90.63%
Other Income
Interest Income 450 450 2,500 2,050 82.00%
Mlaoellaneous 290 290 1,000 710 71.00%
Total Other Income 74D 740 31600 2,760 78.85%
I
Not Income Before Profit Distributions: 106.151 186.151 1.,960,806 1,774,654 9D.51%
Statutory Distributional,
Lew Enforcement 14.719 14,719 211,630 196,911 93.04%
Alcohol Rehab&Ed 21,753 21,750 261,000 239,250 91.67%
Total Stlu/ory Distributions 3$,469 36,469 472,630 436,1fi1 92.28%
Net Income Before Ramat Distribution 149,682 149.652 1.488176 1,336,483 69.B4%
Profit Distribution
Orange County-Gen Ford 66,667 66,657 805,000 J38,333 91.J2%
Working OBpItel Retail Pon.In Not Portion: 63,015 83,015 603,176 800,180 07.85%
nopreG00wr0—odg,elnanem) 35.3)2 36= 4Y5_00a
4I,&3 47,a13 tc,loa
i
Capital Carl Month YTD Budget $.deer ry alnm¢
Warehouse
Oellvery truck 0 0 130.400 130,400 100.00% '..
Racking,firepanel,scanners,compnter 0 0 23.600 23,500 100.001
Office
Replacement windows 0 0 36,000 35,000 100.00%
Grant software,morns,DVR 0 0 16,000 16,000 100.00%
Sm.
Security camera upgrades o 0 10,000 ID,000 100.00%
Store#004 drill arc'hn.,Vienglneedag 2,900 2,900 0 (2,900)
refrigerated molar 3,280 3,280 0 (3,280) -10RDO%
Capitol Receipts
Appropriated fund balance(R58) (2,900) (2,900) (373.400) (370,500) 99,22%
Debt Service(principal)
Flat Hanson(Mebane Store) 12,490 12,490 156,500 146,010 82.12%
15,7701 15,770
i
I
5
ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: August 22,2023 Agenda Item # 6b
Regular Session X
Closed Session
Presenter/Information Contact: Ron McCoy
Subject: July 2023 Year-to-Date Retail and Mixed Beverage/LBD Store Sales
Attachment(s):
1. Attachment "A" Comparative Statement of Monthly and Year-to-Date Retail and Mixed
Beverage Sales by Store for July 2023 and 2022 (Page 3)
2. Attachment `B" Comparative Statement of Monthly and Year-to-Date Retail and Mixed
Beverage Sales Rankings for July 2023 (Page 4)
3. Attachment"C"Comparative Statement of Fortified Wine Sales by Store for July 2023 and
2022 (Page 5)
Brief Summary/Explanations:
II
Comparative Statement of Monthly and Year-to Date Retail/LBD Sales b Store (page 3)
With the onset of the summer vacation season, sales for most stores declined significantly.
Oakdale (10) saw the largest decrease (-$38,561, -10.97%), followed by Ram's Plaza(2) (-$30,960,
-8.53%), Carrboro (7) (-$23,053, -6.75%) and Chapel Hill North (3) (-$22,335, -8.54%). Only two
stores experienced increased sales: Mebane (4) (up $85,121, 43.80%) and Southern Village(8)
(+$65,058).
The number of bottles sold(147,491) decreased-2,699 (-1.80%).
Comparative Monthly and Retail/LBD Sales by Store Rankings (page 4)
Ram's Plaza (2) led all retail sales ($331,846), followed by Carrboro (7) ($318,426), Oakdale
($312,931) and Mebane (4) ($279,451).
Ram's Plaza(2) led all LBD sales ($189,892)with Carrboro (7) in second place ($71,415).
Comparative Monthly and Year-to Date Fortified Wine Sales (page 55)
Overall fortified wine sales for July($2,619)remained essentially unchanged from the previous
year,down-$5 (-0.19%).
Page 1 of 4 pages
i
i
ORANGE COUNTY ABC BOARD—AGENDA FORM
I
Meeting Date: August 22, 2023 Agenda Item# 6b
Regular Session X
Closed Session_
I
Action Requested:
1. Consent Agenda Item.
2. Review and discuss as needed.
Financial Impact: See Above
Staff Recommendations/Comments: None
i
I
I
i
Page 2 of 4 pages
I
i
i
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Monthly and Year-to-Date Retail and Mixed Beverage Sales by Store
For the month of JULY 2023 and 2022 Attachment A"
MonthlV Liquor Sales/YTD %of
Retail Sales rbvstorenumber) 07/01/2023-07131/2023 07/01/2022-07/31/2022 difference %increase retail sales
Hillsborough (1) 155,045 157,201'. (2,156) -1.37% 7.90%
Rams Plaza(2) 331,846'. 362,806'. (30,960) -8.53% 16.92%
Chapel Hill North(3) 239,119'' 261,454. (22,335) -8.54% 12.19%
Mebane(4) 279,451', 194,330 85,121 43.80% 14.24%
Meadowmont(5) 147,681�, 167,141 (19,460) -11.64% 7.53%
Eno/Durham(6) 112,204', 115,933. (3,729) -3.22% 5.72%
Carrboro(7) 318,426 341,479 (23,053) -6.75% 16.23%
Southern Village(8) 65,058; 0' 65,058 100,00% 3.32%
Oakdale(10) 312,931. 351,492. (38,561) -10.97% 15.95%
1,961,761'.. 1,951,836 9,925 0.51% 100.00%
LBD %of LBD sales
Rams Plaza(2) 189,892'. 207,131'. (17,239) -8.32% 56.91%
Chapel HIII North(3) 2,5881, 0 2,588 100.0016 0.78%
Mebane(4) 651.. 932', (281) -30.15% 0.20%
Meadowmont(5) 9,315'. 11,088.I (1,773) -15.99% 2.79%
Carrboro(7) 71,415... 63,597, 7,818 12.29% 21.40%
Southern Village(8) 3,395 0. 3,395 100.00% 1.02%
Oakdale(10) 56,400; 54,775', 1,625 2.97% 16.90%
333,656' 337,523' (3,867) -1.15% 100.00%
TOTAL 2,295,417 2,289,359, 6,058 0.26%
Total Bottles Sold 07/0112023-07/31/2023 07/01/2022-07/31/2022
Retail 74,153''.. 75,811 ' (1,658) -2.19%
"minis"(50 ml) 60,767 61,333 (566) -0.92%
LBD 12,571 . 13,046 (475) -3.64%
147,491 150,190 (2,699) -1.80%
Page 3
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Monthly and Year-to-Date Retail and Mixed Beverage Sales Rankings
For the month of JULY 2023 and 2022 Attachment "B"
Sales Rankings (Liquor)
Retail Sales 0 7/01/2 0 2 3-0 7/31/2023 RANK %of Total
Rams Plaza (2) 331,846 1 16.92%
Carrboro (7) 318,426 2 16.23%
Oakdale (10) 312,931 3 15.95%
Mebane (4) 279,451 4 14.24%
Chapel Hill North (3) 239,119 5 12.19%
Hillsborough (1) 155,045' 6 7.90%
Meadowmont(5) 147,681 7 7.53%
Eno/Durham (6) 112,204', 8 5.72%
Southern Village(8) 65,058 9 3.32%
1,961,7611I 100.00%
LBD 07/01/2023-07/31/2023 %of Total
Rams Plaza (2) 189,892 1 56.91%
Carrboro (7) 71,415', 2 21.40%
Oakdale (10) 56,400 3 16.90%
Meadowmont(5) 9,315 4 2.791.
Southern Village (8) 3,395' S 1.02%
Chapel Hill North (3) 2,588 6 0.78%
Mebane (4) 651' 7 0.20%
333,6561 100.00%
Page 4
I
I
i
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Year-to-Date Fortified Wine Sales by Store
For the month of JULY 2023 and 2022 Attachment "C"
I
i
I
Wine Sales by Stores %of
Wine Sales(by store number) 07/01/2023-07/31/2023 07/01/2022-07/31/2022 difference %increase retail sales
Oakdale(10) 485i 533 (48) -9.01% 18.52%
Rams Plaza (2) 469 494 (25) -5.06% 17.91%
Carrboro(7) 387 377 10 2.65% 14.78%
Chapel Hill North(3) 343 323 20 6.19% 13.10%
Hillsborough(1) 268 156 112 71.79% 10.23%
Southern Village (8) 223 0 223 100.00% 8.51%
Meadowmont(5) 206 286', (80) 100.00% 7.87%
Mebane(4) 151' 260' (109) -41.92% 5.77%
Eno/Durham (6) 87 195' (108) -55.38% 3.32%
2,619 2,624' (5) -0.19%
Page 5
i
ORANGE COUNTY ABC BOARD—AGENDA FORM
i
Meeting Date: August 22, 2023 Agenda Item# 6c
Regular Session X
Closed Session
Presenter/Information Contact: Ron McCoy
Subject: Statewide Sales Report for July 2023
i
Attachment(s):
1. Attachment"NC Statewide Sales Report of Spirituous Liquor(Retail and LBD Sales)"
July 2023
Brief Summary/Explanations:
Retail store sales in July for the state totaled $126,769,924, up 3.19%. Statewide LBD sales
were $30,797,169, up 3.70%.
With the summer vacation season underway -a pattern that dissipated during the pandemic-
alcohol sales have shifted to destination counties. "Coastal" counties experienced the greatest
increases: Dare County ABC placed 9"' in July with sales of $3,634,928 (up from 24' place in
November 2022),Carteret County finished 10"'(up from 19th position in November)and New Hanover
topped out in 3' position with $6,671,019 (up from 61h place in November). (NOTE: "Mountain"
counties experienced increases as well but not to the measurable extremes of the coastal ones.)
Orange County ABC slipped to 17'h place from its usual 12/13`h position, following the typical
summertime pattern. Total liquor sales of$2,295,417 remained comparable to the previous year's,
however, a variance of just 0.26%.
i
it
Action Requested:
1. Consent Agenda Item.
2. Review and discuss as needed.
Financial Impact: See Above
Staff Recommendations/Comments: None
Page 1 of 2 pages
m -tmLnaem aea moci � a o � aeF, m i, a F,oLnam
r, v m v In Ln r i aL 9 o W M Ln m � N N Lq � n m �r o n N � a m
� n m N ri to N m V o trl n WIt cO n W N M1 m at N al m n to o N
y o ,--f N Il'F N m m En Am O N ry LD O N .-I N rl a ri N V I, m o W N
'
V
N LD r V N m m al N to m m m to m m r� r-I N ID m �r oo N ry LD Lo
y m M1 LD o l0 ri r-I H m LD N Lo M1 m +--I m LD m N N -T -t ri N n V n
CZ Ct W V m O LD : M n n N Ln M Ln m m M W M LD M O W s n ra N
d M1 Q r, M r- o 00 O rn N N n d� N' .--I' Ln rR re Lr N N' ai L S m C' Qt °
t/] N lD a lD a oo fV m a N N N N
❑ M
d1
r
a: aemaeaa' a mmr, mm a° m r o aaa� aea a mmmm
o Nr m m v M o N N M1 N m ,� a m o1 n o a o m o m o In M N Ol
m � lD m n v 61 4 V 1-1 e'! N m m M O Ln rr 4 N 0 N M M LD N NIQ 00 of " Ln cn m of r- ❑I Lri al o o to r-i r, T al o o o N LD ni ri uo Ln o r, M O
L'{] o
00 m CO n n m o0 al m m m M1 m m � Ln al m W r, M1 m r-, m r-, ti of
_m
m n m LD LD v-I N CD N m o �--� oo a1 al .--1 m Ln o N o Woo tr N Oo m n al
N N N m O N o oo N N m N " tm N N W Lo m Ln r-I Lo m \D m al
m LD cF n Lr m N al pl -: al -4: al M a LQ M ri -1 N a a Ln M1 to
m v n Lp n N 0 li 1 cn N N In " h N O o G1 M " N t1l 06 't
V o M P of n N n m Ln m a Lo a M N m M W N m c-I N N o n
y ih N o0 a m t'r1 Lr rrl Lrl a .-i m r- SD at tD r• M L5 m m m l5 m m N13
ri
N ri M [rl frl n'1 N N r-I N r-I rl rl ri r-I �1 ri rl rl Cr fYl
U
aeaeaeaea � a aeaeo � a—.R ZR aea as � � a a o a ae � ae
n N a oo N o n oo N N o N M1 o 00 0l Lo o m m M1 N o v v o a1 m Q m
ri Lq Lo p m m Lo N m m O to m m N N a N O n LD m 0 tD It N 10 n N
aE rn o N m .-i N N m rh m " O r-i O m M O H M1 4 N N N N O N a5 O ty m
C �
m
m N m m m O m m .N m m r, Lo m m m m m M1 LD Ln oo m c, N oo M
W 'r o m to m o N w � m � tD w m a LA m m am H m a] m m n o
m m m N N N lD tl m O a1 M M v Ln N v rn M Ln rn Lo N v; o 0o rl a: v
4+ LD m o N m N tl' Ln N N m r-I ri M1 m rl Lo m N r-I ri m N N m M1 o M1
d t/f n 0 Ln m m .--I Li'1 Ln N �' n n ri N M M N m c-I O
N N r-I ri r-I n O
N 41
m rV Ln N m M1 r-t O rh O O O tD ul 00 Lo m o H N H O r M1 O w r' Lo
y M m t" m r, m Ln Lo LD M Ln LD m d' W Ln n .-� r-- m tY c-L [t LD Ql s-I W O tD
y m C: m a1 D Lr D V oa M1 ai r, M1 m N M n N m m M + Lo ry W r N Ln to
a N m r, M1 N m N al m r, m m M r- LG a1 Lr r,l Lp Ln M tD al M1 M1 o � to ai
H -1 N ri '* M o M ri M1 M M m m r, H Lo g N N N O m N � M r, e-I N M V
1 rl LD m N o n m N M n n LA a V M N N M1 LD r- L' M N N ci .--I n In
F N r-,-, to LD L6 -}F 4 4 m N N' N N N' N N N H H H H H H H H H 1-1 H p
0 Ln
H
M
N V CO Lo H n N n V o M1 m n N m v M v N M M1 n r-L M m L4 N
r 4 N r-I V al H N LD o N m rl N m oo Cx al N m N Cr ci N o O N C Lo M1 lD Lo
N V M1 N m to fV a1 O M Ln Lfl m Lo n n Letn m Lrl m .-�L Lrl m N M n rh O V
N N m oo m M N Lnt-I m rn e-i oo r, V V N m r, o al Ln Ln r, o o m Lo c Vj f m
N LD oo m a W m m m � � 0r�i m ri O M N N O Ln rti m O Ln rti M1 M1 LD a1 rV
o � c N Lo m r, CZ m to m dt m m N N m H m N m lr7
y o0 N ri r-I Oti
d N ry b
} lL R
LL j
0
a m V m H W O tD M M o rn v-I M M o N Ln r-I N m �t M LD C N N v-I Ln lel LD
y O LD tD al LD m C9 O N al N O o al M m N N H m " �t O Ln Le) m L r*1 m
a o M N M ri N < LfO rl o rl fl1 r-I rV M1 m al L1 m 0 r-I LO r o M M r, Fr c-I
-6 M � m p Ln r, H m LD oo a) N Kr al N n t 4 d' N Q Q LD r-I o0 M1 oo r-I al N c-I
Ln Ln N .-i at M a m a LD oo N n m o Ln Lp N N n Lo r, -:r v m Ln V n N Lf1 w
c ri m ri r N c rn 1- r-E ri rl c a7 tD M Lr r-i Ln rV li O +-I m O ^ oG
.a m m V m V m V N N N N N N N N N rti ei H r-1 r-f ri ti N H H H N
d1 O
rr. O
00 N al rA W M1 m m m o0 ri m N V +--I m n t m LD LD m tD M1 N m m Ln M
H N ri m �r N r m N f\ Ln m m ^ 4 N rl .i O N m Ln .-1 M Ln al m m Ql m
N N O O Ll m N N m al tD c Lf1 N' N Rl .� It U al o N al al .� m' LPL lf V' V o N 4'
N 91 ml o Lei LA 01 n '7 N W 00 .-3 rl LD' H LM V 1- � r, N' ao' n oo Ln Lri N' N n m C
M Ln CO M n a M r-I .-1 LD M tD m m M m M V Ln m M1 M1 R m N M1 LD m N tD "i LD N L, \ ti
Qr J al n tD V t-i m r� m LD m LD Ln ti L V M M N r r, M1 Ln N a M M N N .-I Ln
w l0 „Mi r, Q rj `? o
Q LA
d °
J N N cr o Ln W to N LD o sD tD H o M1 m ry LO m o o H o n s-I o tD N n yl al
V p m m N m M1 M1 N N V' m V' m r-] LD m m m LD rl m Lo o N N r-I ri ri IT R Lo O
ry y M r, r-I m V N m V rl N .a m -t O N lD LD .-1 LD m .t N " M1 Ir a, o R
a N w w w o o l6 a+ Lp v i o rn r- i re a Ln r, m r-i Ln o rri o o v v N v ae
m o N m m m V o e-i Lo ♦` N a H N ri m N m N ri m n ri tD N m r'I Lrl m m N O
in O N . N W m n LD m n m tr m m N N M ri m N m ri ri N r-I ri H rh Ln Ol L>7
41 } !� 00 N r-I rl N 4` ❑ a C O
LL m co oo
O M r-I m LD N .-i ri M1 N N Ln N N n M .N L6 m LD Ln m m ID N m IM N
N N m o m n o m L1l W w o o N O o a w r al m N to Ln ri i n r" N trOj N
6 � ud m N m N V m m m rl M al N Oct N O V n m N al ld c1' � Cr Lr 11' V It O m C O
J U La V r m m m m n o0 m w w H t m Lo .-i m N W d" ri m m m m a o0 ao' Ol o a ti
C yl m o m a lD H lD m M It '-I N m N LD N 'r V M O m LA o n
_ al N N r-� ry m o n n r-� m ri N - .--� t-i m ll tt Lr N V rl r-I N rl o o M1 — m V al 4
a am-' M m V N tT m N N N N N N N N N .-1 t-1 •-i �-i t-1 ry .-1 ri .-1 .-i ry ri q0 N Y n W ti w
❑ y of
1 c oc a
R w
(A S a
U u u
0 o °u Q ¢ m Q ¢ m u um m m ¢ m m o 0 o 0 o a
0 y u° U m u u o m y u m ' V m u a Q ¢ ¢ Q ¢ n 'E = = = = -_ E
E u m e .�. �. c v d o E E E E E +
a d m u `a Q Q Q U u a V °o Q m m c ¢ u u c c c c � '^ rn r M1
N r+'I ir5 m "° m ¢ o ¢ ¢ m D � Mn N m d' Ln LD
r'M -tl 3 ¢ a ._ p a o m ° U c N m D o I � Lo q � n th t?in t/}of v1
C D ° ° c U a 4 u Q o u m U u@ = o) p ¢ a o 0 o Y o *" n n n n n n
o m � u � a o .o � _ n cu ° � vu u u vro a
ja to 2 c m w u ° p d m c d m U c c a w 5 c m
a -° `y u a .7 U tc o a, c = p w C o m m m m m m
N y m yy N a N !G ? j L "3 o w O LO_D o ro o r0 f0 N m N 3 m lLF m Lb Ln Lb
o z tq F n U ¢ o 0 0 0 U a 2L 0 oc ¢ z (D U a �i U w �
GI o r
Y y o
C .4 fV M It NW N W M C '~ N m V M LD r' W M O N N en a Ln LD n W c
r+ !Y rY ry ri rl r-I r-E ri ri N N N N N N N N N � O
i� - 0 0
C ar
z 11 N
ORANGE COUNTY ABC BOARD
Meeting Date: August 22, 2023 Agenda Item#-7-
Regular Session
Presenter/Information Contact: Taylor Jackson
Subject: Paid Parental Leave Policy
Attached: Proposed Paid Parental Leave Policy
Brief Summary/Explanations: We currently do not have a parental leave policy in place, the
purpose of paid parental leave is to allow paid leave for parental care of a newborn or a child
placed for adoption, foster care, or guardianship. By law we offer unpaid Family Medical Leave
(FMLA) which provides leave to eligible employees. Therefore, paid parental leave addresses the
lack of income experienced for such qualifying events. Many state agencies are now offering
parental leave, such as UNC System, Town of Hillsborough, Chapel Hill and Orange County
Government.
Board Action: This policy will need board approval
I
Orange County ABC Board Policy and Procedure Manual
i
Paid Parental Leave Policy
Orange County ABC will offer paid parental leave to qualifying full time employees. The
purpose of paid parental leave is to enable the employee to care for and bond with a
newborn or a newly adopted or newly placed child. This policy will run concurrently with
Family and Medical Leave Act (FMLA) leave, as applicable.
Eligibility
Eligible employees must meet the following criteria: -':N
➢ Full time employee
➢ Have been employed for at least 12 months
➢ Have worked at least 1,260 hours during the j2'`co�trecutive months immediately
preceding the date the leave would begin-
Paid Parental Leave Provisions -'�
➢ Six weeks of paid parental leave for the NO parer
➢ Two weeks of paid parental[gave for the parent, adoption, foster care,
or other legal placement df a child. <'
Requests for Paid Parental LeavetE ` \�
➢ The employe wtll provide their Wpervior,aricj.the human resource department
with notice i fFt e reques or leave at leasf 30 days>prior to the proposed date of
the leave f or t e leave s not or abI , as soon as possible). The employee
must complete tl�e gecaery,forms a1n provide all documentation as required by
the human resource clopartmerit to subst ntiate the request.
Amo6601me Frame and DUl'aUpn of Paid.F�arental Leave
➢ Eli 'file. employees will receive a maximum of 6 or 2 weeks of paid parental leave
per birth;!adoption or p� cemeWof a child/children. The fact that a multiple birth,
adoption`o.r p(acemeni;`6 curs (e.g., the birth of twins or adoption of siblings) does
not increas`d;Jhe week;i" al amount of paid parental leave granted for that event.
In addition, in cawill an employee receive more than 6 or 2 weeks of paid
parental leave in: rolling 12-month period, regardless of whether more than one
birth, adoption or foster care placement event occurs within that 12-month time
frame.
➢ Each week of paid parental leave is compensated at 100 percent of the employee's
regular, straight-time weekly pay. Paid parental leave will be paid on a bi-weekly
basis on regularly scheduled pay dates.
➢ Approved paid parental leave may be taken at any time during the 12-month period
Immediately following the birth, adoption or placement of a child with the employee.
Paid parental leave may not be used or extended beyond this 12-month time
frame.
i
i
i
i
I
Orange County ABC Board Policy and Procedure Manual
➢ In the event of a female employee who herself has given birth, the 6 weeks of
paid parental leave will commence at the conclusion of any short-term disability
leave/benefit provided to the employee for the employee's own medical recovery
following childbirth.
➢ Employees must take paid parental leave in one continuous period of leave and
must use all paid parental leave during the 12-month time frame indicated above.
➢ Upon termination of the individual's employment at the company, he or she will not
be paid for any unused paid parental leave for which he or she was eligible.
Coordination with Other Policies
➢ Paid parental leave taken under this policy willt"fQ concurrently with leave under
the FMLA; thus, any leave taken under thie ppii0yJhat falls under the definition of
circumstances qualifying for leave due to #he=blrth pr placement of a child due to
adoption or foster care, the leave will t.0,': iunted towsffi44e 12 weeks of available
FMLA leave per a 12-month period:."A• 6ther requiremar�ts,.,and provisions under
the FMLA will apply. In no case vulll':the total amount o#'Ie6ye whether paid or
unpaid granted to the employee undartfre FMLA a need 12 Wo s during the 12-
month FMLA period. Please refer to t'h Fanlil,.y nd Medical a eve Policy for
further guidance on the FM a, .. ,'
➢ After the paid parenta! leaw"4,6, any short te�m disability leave for employees
giving birth) is exhausted, �,,1 balarYce of FMLA leave (if applicable) will be
compensated through employa6j ac6ru0d sick, vacation and personal time. Upon
exhaustion of accrue l;. ick, vacat on and personal #ireig) any remaining leave will
be unpaid leave I'leaq'a re er to tb*F.Amily and Medical Leave Policy for further
guidance on'th FMLA.
➢ The company All alntalh all benefits for\employees during the paid parental leave
period just as if 1116y were taking any d her company paid leave such as paid
vadaticn Ieava or paid %c leave j
➢ If bompany',holiday dobi rs while thd-employee is on paid parental leave, such
day,will be chargirr =too haiida�r pay; however, such holiday pay will not extend the
..,kid parental leaV�e entitIftent.
➢ So that; r!employee's:t turn t6..Work can be properly scheduled, an employee on
medical,J'baye is requ(re,i to provide Human Resources with at least two weeks'
advance notibeofthe date the employee intends to return to work.When a medical
leave ends, tftid"empfoyo''e will be reinstated to the same position, if it is available,
or to an equivalent position for which the employee is qualified,
➢ If an employee fails to report to work promptly at the end of the medical leave, the
board will assume the employee has resigned and reimbursement will be
requested for health insurance for the period of medical leave. The employee must
return to work for a minimum of 30 calendar days to fulfill the health insurance
obligation to the company.
➢ Employees are prohibited from performing unauthorized work for a personal gain
while on medical leave.
ORANGE COUNTY ABC BOARD —AGENDA FORM c�
Meeting Date: August 22, 2023 Agenda Item # a
Regular Session X
Closed Session
Presenter/Information Contact: Office Staff
Subject: Management Updates as of March 16, 2023.
1. Law Enforcement
Law enforcement reports will be available at the meeting.
2. Truck Accident Update
On July 13, 2023 one of the delivery trucks hit a car in the Hardees parking lot in
Hillsborough. It appears the back end of the truck swung wider than the driver
anticipated damaging the passenger side of the car. No one was injured and it
was turned over to Insurance. Financial impact is the $1000 deductible.
3. Recurring topics for fiscal year 2024
Highlights include 4 meetings on the 4th Tuesday due to calendarization and no
Meeting in December during the busy holiday season.
4. Canned Cocktail Coolers
Beverage Coolers are in six stores. Only the Meadowmont, Eno and older
Hillsborough store do not have the space for a cooler.
6. Meeting in Cherokee
Several board members attended the Annual ABC meeting. Many topics were
discussed including the potential legislative updates currently on hold.
6. Broad Branch Distillery tour
We are doing 2 tours of the Broad Branch distillery in Winston Salem to coincide
with a single barrel pick.
I
I
�I
I
i
i
I
i
Page 1 of 1 pages
Orange County ABC Meeting Schedule & Recurring Topics for fy2024
The following list of meeting dates is based on the current recurring schedule of the third or
fourth Tuesday in each month @ 10:OOam and dates are subject to change as needed.
Recurring Reports: Financial statements from the preceding month are included in the Board
email each month along with sales and non-financial data such as unit sales, etc.
July 18, 2023 if Needed (No meeting scheduled)
New Board members are introduced and sworn-in or in August if no July meeting
Elect Vice-Chair or in August if no July meeting
August 22, 2023 Ott, Tuesday
Review/update/modify list of recurring Board meeting activities.
r Discuss future meeting dates/times; modify as necessary.
Review un-audited financial statements for the past fiscal year if available.
Verify Ethics Training completed or scheduled for newly appointed board members
September 19, 2023
Review final copies of audited financial statements.
Put independent auditor contract out for bid as needed.
Put HVAC contract out for Bid every 3 years 2024, 2027 if needed
Have initial Health Coverage conversation if needed
October 17, 2023
r Review financial results of the 1 st quarter.
y Review latest financial projections through year-end.
Y Review bids for independent auditors as needed.
Review bids for HVAC contracts as needed
November 28, 2023 ,-tt'Tuesday
Review commercial insurance package if needed (renews 111).
Review leases coming up for renewal and plan for options
Review group health insurance renewal (renews 111).
Pre-Holiday Season store security as needed
Board Attorney review (2023,2025)
December 2023 if Needed (No Meeting Scheduled)
No Recurring Board Topics are scheduled
January 23, 2024 4t'Tuesday
Review actual-to-budget results of the first half of the year and discuss latest financial
projections through year-end.
r Review/update/modify list of recurring Board meeting activities.
6 Month Law Enforcement Report for All agencies
r Discuss progress of ALERT funding and Law Enforcement Contracts
February 22, 2024
'/z of Grantees come in for presentations
Living Wage and salary chart Review 2024,2026
New Board Member Recommendations if needed
y Present to Board of County Commissioners
Paae 1 of 2 oaaes
Orange County ABC Meeting Schedule & Recurring Topics for fy2024
March 19, 2024
Review Board members term expirations and determine if action is required to request second
term appointments of members or to request new members.
'/2 of Grantees come in for presentations
Applications for the Alcohol Education Grant Program have a March 31 deadline. Applications are
reviewed during the month of April. Allocations are determined at the May meeting to include in draft
budget.
April 23, 2024 41d Tuesday
r Review results of the 3rd quarter and compare to budgeted amounts.
Review year-to-date financial information, revise projections (if necessary) and latest
financial projections through year-end.
Review and discuss Board Goals
GM Review distributed to board members for feedback
Grant books given to board at this meeting to bring back to May meeting
Law Enforcement funding requests are due by April 16, 2023
May 21, 2024
Review list of projected major property and equipment purchases (over $50,000).
Review Preliminary Sales forecast/expense budget for the upcoming fiscal year.
Review latest financial projections though year-end.
FY2024 Draft budget is presented to the board for review
Capital Improvement Plan Review if needed
Draft Budget posted online and in media and sent to ABC commission and County
Commissioners and announces public hearing.
Review distribution laws and policies relating to "Net Profits before Distributions" and
working capital limits
Review Law Enforcement funding requests
Closed session to Discuss GM Review
Review Alcohol Education Grant requests
Make recommendation to BOCC for Board Chair role and new members
" Public Hearing must be held prior to June 18 Meeting***
June 18, 2024
y Determine distribution amount for the General Fund for next FY.
r Sales Forecast/Budget for upcoming fiscal year.
Determine capital Improvement projects for next FY.
Determine Education grant funds for the upcoming fiscal year.
Determine General Fund distributions for the upcoming fiscal year.
Review Alcohol law enforcement requests and distributions
GM Review & Contract Auto-Renewal before July 1.
Budget for next fiscal year is adopted and copies sent to ABC commission and County
Commissioners before July 1.
Determine attendees for the Summer Conference in August
BOCC appoints Board Chair
Paae 2 of 2 nanPs
State of!North Carolina
Alcoholic Beverage Control Commission S STA7 t
mod` ��vs� rr"s IW�
ABC Law Enforcement Monthly Report
GS 18B-501(f1)
Board: �o
Orange County
Reporting Month/Year: {
x
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission 1 CB 4 CH
Total Number of Offenses Contained in Reports 1 CB 4 CH
Sell to Underage Campaign Checks 1 CB
Permittee Inspections
Compliance Checks 4 CB 1 CH
Seller/Server Training
Alcohol Education
ABC Law Violations At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage 1 CB 4 CH
Attempt to Purchase/ Purchase by Underage
Underage Possession
Unauthorized Possession
Sell/Give to Intoxicated
All Other Alcohol Related Charges
TotJ==11 +
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony Drug Related Charges
Misdemeanor Drug Related Charges
Total:
Other Offenses At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired 4 OC
All Other Criminal Charges
Total:
TOTAL CRIMINAL CHARGES:
Agencies Assisted
Assistance Provided to Other Agencies
Remarks
Carrboro: 4 plain clothes operations looking for fake ID's. 6/6 compliance check 1
violation. Also handed out flyers for bars classes. . Chapel Hill: June compliance on
June 23 and 4 failed. Hillsborough: NA Orange County: Stationary Patrols at store
closings, Attended a meeting about college parties and agri-touriam. Follow up on
Alcohol purchase surveys.
Reporting Officer/Title:
4 Agencies Reporting
Report Date:
July 12023
State of North Carolina
Alcoholic Beverage Control Commission �t STATF Q,
. 00
ABC Law Enforcement Monthly Report
G5 18B-501(f1) .
Board: r p
Orange County
Reporting Month/Year:
Jul-23 r�s QuArn vtC �`�s
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission 5 CH
Total Number of Offenses Contained in Reports 5 CH
Sell to Underage Campaign Checks 1 CB
Permittee Inspections 1 CH
Compliance Checks 2 CB 1 CH
Seller/Server Training 1 CH
Alcohol Education
ABC Law Violations
At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage 5 CH
Attempt to Purchase/ Purchase by Underage
Underage Possession
Unauthorized Possession
Sell /Give to Intoxicated
All Other Alcohol Related Charges
Total:
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony Drug Related Charges
Misdemeanor Drug Related Charges
Total:
Other Offenses At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired
All Other Criminal Charges
Total:
TOTAL CRIMINAL CHARGES:
Agencies Assisted
Assistance Provided to Other Agencies
Remarks
Carrboro: 2 plain clothes operations looking for fake ID's. 7/7 compliance check no
violations. . Chapel Hill: Compliance check on 7/22 and 5 business failed out of 43
checked. Kahlovera Street tacos failed for the third time this year and was added to
a district watch list. Hillsborough: NA Orange County: Stationary Patrols at store
closings parties and agri-touriam. Follow up on Alcohol purchase surveys.
Reporting Officer/Title:
4 Agencies Reporting
Report Date:
August 12023
State of North Carolina
Alcoholic Beverage Control Commission STA
�v ��Y 20 fJTj�
ABC Law Enforcement Monthly Report
G5 18 B-501(f1) r
Boa rd: -'" _ P0
Orange County
Reporting Month/Year: y
Jul-23 QfAM vtitQ`.
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission 5 CH
Total Number of Offenses Contained in Reports 5 CH
Sell to Underage Campaign Checks 1 CB
Permittee Inspections 1 CH
Compliance Checks Z C8 1 CH
Seller/Server Training 1 CH
Alcohol Education
ABC Law Violations At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage 5 CH
Attempt to Purchase/ Purchase by Underage
Underage Possession
Unauthorized Possession
Sell/Give to Intoxicated
Ail Other Alcohol Related Charges
Total:
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony Drug Related Charges
Misdemeanor Drug Related Charges
Total:
Other Offenses At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired
All Other Criminal Charges
Total:
TOTAL CRIMINAL CHARGES:
Agencies Assisted
Assistance Provided to Other Agencies
Remarks
Carrboro: 2 plain clothes operations looking for fake ID's. 7/7 compliance check no
violations. . Chapel Hill: Compliance check on 7/22 and 5 business failed out of 43
checked. Kahlovera Street tacos failed for the third time this year and was added to
a district watch list. Hillsborough: NA Orange County: Stationary Patrols at store
closings parties and agri-touriam. Follow up on Alcohol purchase surveys.
Reporting Officer/Title:
4 Agencies Reporting
Report Date:
August 12023
State of North Carolina
Alcoholic Beverage Control Commission V01" STIMF'
ABC Law Enforcement Monthly Report �' 'A"Y
GS 186-501(f1) d �-
L.3
Board: c
orange County �✓„� D
Reporting Month/Year:
Jun-23 Q11AM `*
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission 1 CB 4 CH
Total Number of Offenses Contained in Reports 1 CB 4 CH
Seil to Underage Campaign Checks 1 CB
Permittee Inspections
Compliance Checks 4 CB 1 CH
Seller/Server Training
Alcohol Education
ABC Law Violations At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage 1 CB 4 CH
Attempt to Purchase/ Purchase by Underage
Underage Possession
Unauthorized Possession
Sell /Give to Intoxicated
All Other Alcohol Related Charges
Total:
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony Drug Related Charges
Misdemeanor Drug Related Charges
Tota I:
Other Offenses At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired 4 OC
All Other Criminal Charges
Total: i
TOTAL CRIMINAL CHARGES:
Agencies Assisted
Assistance Provided to Other Agencies
Remarks
Carrboro:4 plain clothes operations looking for fake ID's. 6/6 compliance check 1
violation. Also handed out flyers for bars classes. . Chapel Hill: June compliance on
June 23 and 4 failed. Hillsborough: NA Orange County: Stationary Patrols at store
closings, Attended a meeting about college parties and agri-touriam. Follow up on
Alcohol purchase surveys.
Reporting Officer/Title:
4 Agencies Reporting
Report Date:
July �, 2023
i
ORANGE COUNTY ABC BOARD
TRAVEL REIMBURSEMENT REQUEST AND EXPENSE REPORT
REQUEST I REPORT SECTION
Name of Requestor: Jennifer Title: manager Date of Request:
i
Important-attach all applicable receipts and/or invoices to this report
Sun Mon Tues Wed Thurs Fri Sat Totals
Dates Traveled
Lodging incltaxes) $ ..._
Fares,Air, Bus, etc
To/From Destination
Mileage-personal
vehicle (per below)
Meals: Breakfast
Incl. Lunch
Tips Dinner
Flat Rate
Taxi, Bus, Rental
Registration Fees
Conference Exp 1
Telephone
Baggage Handling
Other Expenses
Totals
Comments:
Ex lanation of personal vehicle expenses:
Mileage
Date From (location) To (location) Claimed $Amount
carrboro first horrizon
EXPENSE SUMMARY
Total cost of trip per above
Less: expenses prepaid by Board
Less: cash advanced
Add (Deduct) other adjustments- Explain
Balance Due- Board or Requestor(Circle One)
I hereby certify that the foregoing travel expenses were incurred in the conduct of Board business.
Signature of requestor: Date:
APPROVAL 1 REVIEW/PAYMENT SECTION
Approved by Board Chair: Date:
Reviewed & approved for payment by GM: Date:
"A completed Travel Reimbursement and Expense Report form should be submitted within 14 work days
after returning from travel (OCABC Board Policy& Procedure Manual).
OCABC Board Form 002, October 21, 2003 (Prior forms are superseded)
Article III, Appendix B -OCABC Board Form 002 -Travel Reimbursement Request
I
III -7
I
I
i
ORANGE COUNTY ABC BOARD
TRAVEL REIMBURSEMENT REQUEST AND EXPENSE REPORT* j
REQUEST/REPORT SECTION
Name of Requestor: Jennifer Title: manager Date of Request:
Im ortant-attach all applicable receipts and/or invoices to this report
Sun Mon Tues Wed Thurs Fri Sat Totals
Dates Traveled ==
- — I
Lodging (ind taxes) $
Fares,Air, Bus, etc
To/From Destination
Mileage-personal
vehicle (per below)
Meals: Breakfast
Incl. Lunch
Tips Dinner
Flat Rate
Taxi, Bus, Rental
I
Registration Fees
Conference Ex
Telephone
Baggage Handling
Other Expenses
Totals
Comments:
Explanation of personal vehicle expenses:
Mileage ;
Date From (location) To location Claimed $Amount
carrboro first horrizon
i
EXPENSE SUMMARY
Total cost of trip per above
Less: expenses prepaid by Board
Less: cash advanced
Add (Deduct) other adjustments - Explain j
Balance Due- Board or Requestor(Circle One)
I hereby certify that the foregoing travel expenses were incurred in the conduct of Board business.
Signature of requestor: Date:
APPROVAL/REVIEW/PAYMENT SECTION
i
Approved by Board Chair: Date:
Reviewed & approved for payment by GM: Date:
A completed Travel Reimbursement and Expense Report form should be submitted within 14 work days j
after returning from travel (OCABC Board Policy & Procedure Manual).
OCABC Board Form 002, October 21, 2003 (Prior forms are superseded)
Article III,Appendix B -OCABC Board Form 002 -Travel Reimbursement Request
11I-7
i
ORANGE COUNTY ABC BOARD
Open Meeting Board Minutes
Tuesday September 19, 2023, 10:00am
Location: 601 Valley Forge Road Hillsborough,NC 27278
I
Scheduled attendees:
I
I
Patrick Burns, Board Chair Elizabeth Carter, Member
Mike Zito, Member Tony DuBois, General Manager
Judson Williamson, Vice Chair Ron McCoy, Finance Officer
Angela Willoughby, Asst. GM Julie Mebane, Board Secretary
Amy Fowler, BOCC Liaison Taylor Jackson- Human Resources
i
Scheduled Absence: Chris Willett, Beemer, Hadler & Willett, P.A
Melvin Green, Member
Call to order at 10:00 am, a quorum was present and Mr. Burns, Board Chairman, called the
Board Meeting to Order.
i
Mr. Burns read the Mission Statement: The Mission of the Orange County ABC Board
and our employees is to serve our locality responsibly by controlling the sale of
spirituous liquor, returning profits to Law enforcement, Alcohol Education, and the
County Fund while providing excellent service in customer friendly, modern, and
efficient stores.
Mr. Burns read the Conflict-of-Interest Statement. The question was asked: does
anyone have a conflict of interest with respect to any matters on the agenda?All present
said nay.
Approval of the Open Meeting Agenda: Ms. Carter made a motion to approve the agenda, Mr.
Williamson seconded the motion and the vote carried.
Minutes of the open session August 22, 2023, were presented. Mr. Williamson made a motion to
approve the open session minutes as presented, Mr. Zito seconded the motion and the vote
carried
i _ III
i
Consent Agenda: August, 2023
a. Financial Reports:
i. Comparative Statement of Net Assets
ii Comparative Revenue and Expenses August
iii Actual-to-Budget Comparison for August 2023
b. August 2023 and Year-to-Date Retail sales
c. Statewide sales report
Discussion was held. Mr. Zito made a motion to approve the August Consent Agenda, Ms. Carter
seconded the motion and the vote carried.
Law Enforcement: This report is required by the NCABC.
Bars Classes: Employees attended a BARS class at the office on July 18t" and the remaining
employees will attend a class in Chapel Hill on August 14"'. A few stragglers will
attend the next class in Chapel Hill to complete our yearly training.
Single Barrel Endeaps: We are featuring our single batTel staff selections on endcaps in 6
locations that have the space to do so. We have stickers designed by Emily, our Southern Village
Store Manager to make sure all bottles and endcap signage stands out.
Banking-Staff members have been meeting with banks to consider if we want to make a
change or consolidate our banking relationships. We will keep the board updated if any changes
are recommended.
Online Grant Administration- Meetings have been held with companies to receive quotes to
move the grant process online.
Website Redesign-Meetings have been held about updating the boards website. We will keep the
board updated on what is decided.
Broad Branch Distillery Tour-There were 2 tours of the Broad Branch Distillery in Winston-
Salem on August 24°' and 315'. 20 employees attended the tours. This is to coincide with a single
barrel selection arriving soon.
Bourbon Steward Class- There is a second Bourbon Steward Class in partnership with Mystic
Distillery in Durham scheduled for September 20' and we will have 18 attending. Durham
ABC will send 15 employees as well,
i
State Bill Updates-Three things for the board to potentially consider are Sunday Sales, Holiday
openings and Customer Tracking for the lottery items. The NC legislature is still discussing.
i
A motion was made by Mr. Zito at 10:34am to go into a closed session for a personnel matter and
Ms. Carter seconded the motion and the vote carried
Mr. Williamson nude a inotion at 10:44ain to go lack into open session and M°. Zito .seconded
the motion and the vote carried.
Board Comments: Mr. Zito asked for an update on when the Grant Distribution posters would be
completed. Mr. McCoy explained the we needed the final audit report before the posters would be
completed. Mr.McCoy also shared the layout of the posters with the Board. Mr.Williamson shared
his experience with the Bull City Bourbon Club tasting. Mr. Burns thanked the staff for everything
they contributed to make OCABC a successful organization.
At 10:54am Mr. Zito made a motion to adjourn, Ms. Carter seconded the motion and the vote
carried.
I
Chars �atureDat oard Secretary's Signature and Date
State of North Carolina
Alcoholic Beverage Control Commission STATE
zn + ls
ABC Law Enforcement Monthly Report
GS 18B-501(f1)
Board: PC
Orange County
Reporting Month/Year:
Nov-23 E
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission
Total Number of Offenses Contained in Reports
Sell to Underage Campaign Checks
Permittee Inspections
Compliance Checks 1 CH 4CB
Seller/Server Training
Alcohol Education
ABC Law Violations At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage
Attempt to Purchase/ Purchase by Underage 1 CB
Underage Possession 1 CB
Unauthorized Possession
Sell/Give to Intoxicated
All Other Alcohol Related Charges 10 CH JI:
CH
Tot +
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony Drug Related Charges
Misdemeanor Drug Related Charges
Total: +
Other Offenses At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired
All Other Criminal Charges
Total: +
TOTAL CRIMINAL CHARGES: +
Agencies Assisted
Assistance Provided to Other Agencies
Remarks
Carrboro: 4 plain clothes operations looking for fake ID's. 1 fake ID referral to
OCPAD. Chapel Hill PD: 10 on premise fake ID charges all referred to OCPAD.
Hillsborough: NA Orange County: Conducted several stationary patrols at store
locations at closing. Assisted ALE with op in Hillsborough and Chapel Hill.
Compliance Chech Nov 22 3 violations. All 3 ABC stores checked passed.
Reporting Officer/Title:
4 Agencies Reporting
Report Date:
f}et I2023
No
i
ORANGE COUNTY ABC BOARD
i
Proposed Agenda For Open Session
Tuesday, September 19"',2023, 10:00am
Scheduled attendees:
Patrick Burns,Board Chair Elizabeth Carter,Vice Chair
Mike Zito, Member Tony DuBois, General Manager
Judson Williamson,Member Ron McCoy,Finance Officer
Angela Willbughby, Asst, GM Julie Mebane, Board Secretary
Amy Fowler, BOCC Liaison Taylor Jackson-Human Resources
Melvin Green,Member
Scheduled Absence: Cluis Willett,Beemer, Hadler& Willett, P.A
i
1. Call open session meeting to order.
• The Mission of the Orange County ABC Board and our employees is to serve our
locality responsibly by controlling the sale of spirituous liquor,returning profits to Law
enforeement,Alcohol Education,and the County hand while providing excellent service
in customer friendly,modern,and efficient stores.
• Does any member of the Board have a conflict of interest or any condition or fact that
might create the appearance of a conflict of interest with respect to any matters on
today's agenda?
2. Discuss proposed agenda., revise as needed and adopt the agenda.
I
3. Minutes of Open meeting August 22, 2023
r
i
4. Consent Agendas August 2023 1
Financial Reports:
i. Comparative Statement oFNot Assets
ii Comparative Revenue and Expenses for August
i
I
i
i
I!
5. Management Updates
i
6. Closed Session for personnel issue
7. Board Comments
8. Motion to adjourn.
I
�i
I
I
I
i
f
i
�I
I
ORANGE COUNTY ABC BOARD
Open Meeting Board Minutes
Tuesday, October 17u', 2023, 10:00am
Location: 601 Valley Forge Road Hillsborough, NC 27278
Scheduled attendees:
Patrick Burns, Board Chair Elizabeth Carter, Member
Mike Zito, Member Tony DuBois, General Manager
Judson Williamson, Vice Chair Ron McCoy, Finance Officer
Angela Willoughby, Asst. GM Julie Mebane, Board Secretary
Amy Fowler, BOCC Liaison Melvin Green, Member
Mason Barringer - Auditor
Scheduled Absence: Chris Willett, Beemer, Hadler & Willett, P.A
Call to order at 10:00 am, a quorum was present and Mr. Burns, Board Chairman called the board
meeting to order.
Mr. Burns read the Mission Statement: The Mission of the Orange County ABC Board and our
employees is to serve our locality responsibly by controlling the sale of spirituous liquor, returning
profits to Law enforcement, Alcohol Education, and the County Fund while providing excellent
service in customer friendly, modern, and efficient stores.
Mr. Burns read the Conflict-of-Interest Statement. The question was asked: Does any member of
the Board have a conflict of interest or any condition or fact that might create the appearance of
a conflict of interest with respect to any matters on today's agenda?All present said nay
Approval of the Open Meeting Agenda: Mr. Zito made a motion to approve the agenda, Mr. Green
seconded the motion and the vote carried.
Minutes of the open session September 19, 2023: Mr. Green made a motion to approve the minutes,
NIr. Zito seconded the motion and the vote carried.
2023 Audit Review: Mason Barringer, Auditor with DMJPS CPA's and Advisors, reviewed the
2022/2023 audit report with board members.
Highlights of the audit review:
• Working capital (current assets less current liabilities) decreased by 14.18% over the prior year.
Current assets ($7,777,839) decreased -$214,083 while current liabilities($3,400,630) increased
$508,963, due primarily to the allocated net pension liability (state retirement) ($1,413,742,
41,050,280)
. Approximately 11.5% of profits were expended for law enforcement (5% required) and 17.3%
for alcohol education/rehabilitation(7% required)
• Assets exceeded liabilities by $13,462,308, up from $12,256,768 in 2023
• Sales revenues of$31,208,975, up 3.86% from 2022, were the highest in the Board's history
• Total bottles sold in 2023 (2,020,888) was up 49,366 (2.50%)
• The Board invested $1,851,306 in capital assets for the completion of the Mebane store and
furniture, fixtures and equipment related to the Mebane and Southern Village stores
• Notes payable ($2,654,679) increased $486,280 (22.43%), due primarily to inventory growth
related to the new stores.
• Net position increased$1,205,540,down-$748,373 (38.30%)from the previous year's unusually
high ($1,953,913) growth, due primarily to the Board's decisions to pay off the BB&T/Truist
debt and finance only the money necessary to pay the builder for the construction of Store 004.
All other expenses for Store 004 -furniture, fixtures, equipment, architect, engineering, permits
etc.-were paid by the Board using retained earnings from previous fiscal years.
I
Discussion was held, Mr. Williamson made a motion to approve the audited financial statements as
prepared, Mr. Zito seconded the motion and the vote carried.
Consent Agenda: September 2023
a. Financial Reports:
i. Comparative Statement of Net Assets
ii. Comparative Revenue and Expenses for September
iii. Actual to Budget Comparison
b. September 2023 and Year to Date Retail and LBD Sales
c. Statewide Sales Report for September 2023
Discussion was held, Mr. Williamson made a motion to approve the consent agenda, Mr. Zito seconded
the motion and the vote carried.
i
Management Updates:
• Law Enforcement Reports were presented
• Staff continues to evaluate grant management companies for streamlining the grant process
• 90Degree was hired for redesign of the OC ABC website
• Staff is evaluating current banking relationship and meeting with additional banks
• Air ducts were cleaned as well as air quality tests performed at the #IHillsborough and#6 Eno
retail locations
• A bourbon steward class was held on 9/24/23, 18 employees attended class
• Single Barrel and Sale Item pictures were presented
• Additional exterior lights are being installed at#2 Rams Plaza, #4 Mebane and#7 Carrboro retail
stores
i,
Board Comments:
All board members expressed appreciation to the staff on the audit presentation. Mr. Burns thanked the j
county commissioners for hosting the volunteer presentation.
Ils. Carter made a motion to adjourn, Mr. Williamson seconded the motion and the vote carried.
i
2 3
Chair's Signature and Date
i
State of North Carolina
t
Alcoholic Beverage Control Commission
ABC Law Enforcement Monthly Report
GS 18B-501(f1)
Board:
Orange County
Reporting Month/Year:
November 1202$
ri .��Bula�9fl1►�tnnty�n���raihiCtg
Violations Reports Submitted to ABC Commission
Total Number of Offenses Contained in Reports
Sell to Underage Campaign Checks
Permittee Inspections 1,CH
Compliance Checks 4 CB
I Seller/Serve rTraining 1CH
I
Alcohol Education
I
At Permitted Away From Permitted
f A Lgyv Viafatrafisa< >
Establishment Establishment
Sell/Give to Underage
Attempt to Purchase/Purchase by Underage CB
I
Underage Possession 4 CB
Unauthorized Possession
j Sell/Give to intoxicated .
All Other Alcohol Related Charges 3 H 14,C
Total:
At Permitted Away From Permitted
GFtt1s� ustancU�oioiis Establishment Establishment
Felony Drug Related Charges
Misdemeanor Drug Related Charges
Total:
r x y-'r xYa t a
O>hY O{f�nses
At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired
All Other Criminal Charges 1 CB
Total:
TOTAL CRIMINAL CHARGES:
Assistance Provided to Other Agencies
I
Carrbdro: 5 plain clothes operations looking for fake ID's.3 Fake ID's were located 4
underage possession charges and 1 larceny of alcoholic beverages.. Chapel Hill PD:
Conducted 2 ALERT operations 3 violationas for fraduant,ID'sent o OCPAD. One
Violation during an inspection of Lime& Lemonl Hillsborough: NA Orange County:
Conducted several stationary patrols at store locations at closing.
Reporting Officer/Title:
4 Ageicies Raporting
Report Date:
N 4pv 12023
I
State of North Carolina
Alcoholic Beverage Control Commission Q
ABC Law Enforcement Monthly Report
GS 18B-501(f1)
Board:
Orange County �7 -
Reporting Month/Year:
Sep-23 QUAM �
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission
Total Number of Offenses Contained in Reports
Sell to Underage Campaign Checks
Permittee Inspections
Compliance Checks 5 CB
Seller/Server Training 1 CH
Alcohol Education
ABC Law Violations At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage
Attempt to Purchase/ Purchase by Underage 9 CB
Underage Possession 6 CB 2 CH
Unauthorized Possession
Sell/Give to Intoxicated
All Other Alcohol Related Charges 42 CH 4 CH
Total:
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony drug Related Charges
Misdemeanor drug Related Charges
Total•
Other Offenses At Permitted Away From Permitted
Establishment Establishment
Driving While Impaired
All Other Criminal Charges
Total•
TOTAL CRIMINAL CHARGES:
Agencies Assisted
Assistance Provided to Other Agencies
Remarks
Carrboro: 5 plain clothes operations looking for fake ID's. 9/15 plain clothes Op
with Chapel Hill at Carolina Inn 1 fake ID referral and also went to Still Life and had
10 fake ID Charges. Chapel Hill PD: Conducted 3 ALERT operations 42 on premise
fake ID charges all referred to OCPAD. Hillsborough: NA Orange County:
Conducted several stationary patrols at store locations at closing.
Reporting Officer/Title:
4 Agencies Reporting
Report Date:
October 12023
i
Materiality
Financial Accounting Standards Codification, Qualitative Characteristics of Accounting Information, defines
materiality as the "magnitude of an omission or misstatement of accounting information that, in the light of
surrounding circumstances,makes it probable that the judgment of a reasonable person relying on the information
would have been changed or influenced by the omission or misstatement." In planning and performing the audit,
we used professional judgment to determine a level of performance materiality of$60,000. Factors considered in
this evaluation included the components of the financial statements believed to be the most critical to users and
the extent of adjustment detected in prior audits.
Compliance with All Ethics Requirements Regarding Independence
The engagement team and others in our firm have complied with all relevant ethical requirements regarding
independence.
I
Qualitative Aspects of the ABC Board's Significant Accounting Practices
Significant Accounting Policies
Management has the responsibility to select and use appropriate accounting policies. A summary of the
significant accounting policies adopted by the ABC Board is included in Note I to the financial statements.
During the year ended June 30, 2023, the ABC Board implemented Governmental Accounting Standards Board
96 related to lease reporting requirements, using the modified retrospective approach. See Note 17 to the financial
statements for additional information. No matters have come to our attention that would require us, under
professional standards, to inform you about (1) the methods used to account for significant unusual transactions
and(2) the effect of significant accounting policies in controversial or emerging areas for which there is a lack of
authoritative guidance or consensus.
Significant Accounting Estimates
Accounting estimates are an integral part of the financial statements prepared by management and are based on
management's current judgments. Those judgments are normally based on knowledge and experience about past
and current events and assumptions about future events. Certain accounting estimates are particularly sensitive
because of their significance to the financial statements and because of the possibility that future events affecting
them may differ markedly from management's current judgments.
The most sensitive accounting estimates affecting the financial statements are the depreciation lives and methods
relating to capital assets.
We evaluated the key factors and assumptions used to develop the depreciation lives and methods relating to
capital assets and determined that it is reasonable in relation to the basic financial statements taken as a whole.
Financial Statement Disclosures
Certain financial statement disclosures involve significant judgment and are particularly sensitive because of their
significance to financial statement users. The most sensitive disclosures affecting the ABC Board's financial
statements relate to the distributions of income.
Significant Difficulties Encountered During the Audit
We encountered no significant difficulties in dealing with management relating to the performance of the audit.
2
Corrected Misstatements
For purposes of this communication, professional standards require us to accumulate all known and likely
misstatements identified during the audit, other than those that we believe are trivial, and communicate them to
the appropriate level of management. Further, professional standards require us to communicate the effect of
uncorrected misstatements related to prior periods on the relevant classes of transactions, account balances or
disclosures, and the financial statements as a whole. Management has corrected all such misstatements. In
addition, none of the misstatements detected as a result of audit procedures and corrected by management were
material, either individually or in the aggregate,to the financial statements taken as a whole.
Disagreements with Management
For purposes of this letter,professional standards define a disagreement with management as a matter, whether or
not resolved to our satisfaction, concerning a financial accounting, reporting, or auditing matter, which could be
significant to the ABC Board's financial statements or the auditor's report. No such disagreements arose during
the course of the audit.
Representations Requested from Management
We have requested certain written representations from management, which are included in that letter dated
September 28, 2023.
i
Management's Consultations with Other Accountants
In some cases, management may decide to consult with other accountants about auditing and accounting matters.
Management informed us that, and to our knowledge, there were no consultations with other accountants
regarding auditing and accounting matters.
Other Significant Matters Findings or Issues
In the normal course of our professional association with the ABC Board, we generally discuss a variety of
matters, including the application of accounting principles and auditing standards, business conditions affecting
the ABC Board, and business plans and strategies that may affect the risks of material misstatement. None of the
matters discussed resulted in a condition to our retention as the ABC Board's auditor.
This report is intended solely for the information and use of the Board of Directors of the ABC Board and is not
intended to be, and should not be,used by anyone other than these specified parties.
We appreciate the time and consideration extended to us by the ABC Board's personnel during our audit. If we
can be of further assistance,or if you have any questions,please do not hesitate to contact us.
Very truly yours,
D'?12�5 �l'1'G✓
Certified Public Accountants
Greensboro,North Carolina
I
3
Orange County Alcoholic Beverage Control Board
Statement of Revenue,Expenses, and Changes in Net Assets
Year Ended June 30, 2023
2023
Operating Revenue
Liquor Sales -Regular $ 26,045,431
Mixed Beverage Sales 5,125,307
Wine Sales 38,237
Total Gross Sales 31,208,975
Deduct Taxes on Gross Sales
i
State Excise Tax 6,760,808
Mixed Beverage Tax(Revenue) 393,894
Mixed Beverage Tax(Human Resources) 39,389
Rehabilitation Tax 67,516
Total Taxes 7,261,607 j
Net Sales 23,947,368
Deduct Cost of Sales
Cost of Liquor Sold 16,083,743
Cost of Wine Sold 19,434
16,103,177
Gross Profit on Sales 7,844,191
Deduct Operating Expenses
i
Store Expenses 3,574,196
Warehouse and Delivery Expenses 411,251
Administrative Expenses 878,632
Depreciation and Amortization Expenses 659,039
Total Operating Expenses 5,523,118
Income From Operations 2,321,073
Non-Operating Revenues and Expenses
Other Income—Miscellaneous 4,467
Total Non-Operating Revenues(Expenses) 4,467
i
Change in Net Assets Before Distributions 2,325,540
Deduct:
Law Enforcement 168,000
Alcohol Education 252,000
Change in Net Assets Before Profit Distributions 1,905,540
I
1
I
Profit Distributions 2023
City or Municipality $ 700,000
Change in Net Assets 1,205,540
Net Assets, Beginning of Year 12,256,768
Net Assets,End of Year $ 13,462,308
45% Mixed Beverage Tax Retained $ 354,505
Surcharge Collected $ 162,521
Bottles Sold:
Regular 980,930
Mixed Beverage 201,755
Miniatures 838,203
Number of Retail Stores 9
I
I
2
ORANGE COUNTY ABC BOARD—AGENDA FORM
i
Meeting Date: October 17,2023 Agenda Item # rJa
Regular Session X
Closed Session_
Presenter/Information Contact: Ron McCoy
Subject: September 2023 Financial Reports
Attachment(s):
1. Attachment"A" Comparative Statement of Net Position for September 2023.
2. Attachment `B" Comparative Statement of Revenues, Expenses and Changes in Net
Position for September 2023 and 2022.
3. Attachment"C"Actual to Budget Comparison, FY 2023.
Brief Summary/Explanations:
1. Comparative Statement of Net Position (Attachment"A"):
Cash assets held by the Board ($3,660,029) decreased by -$173,189 (452%).
Inventory($4,984,009) increased significantly, up $709,474(16.60%), due in part to increases
at the new Mebane and Southern Village stores.
Construction in progress in 2022 ($2,332,835) decreased in full, replaced by
$3,270,727 in increased property assets.
Liabilities for accounts payable ($1,488,182) increased 13.19%, due to elevated
inventory purchases (+$226,643). Total tax and payroll liabilities ($924,941) increased
$76,815 (9.06%).
Year-to-date income ($224,875) decreased by -$48,075, down -17.61% from the
previous year.
2. Comparative Revenue, Expenses and Changes in Net Position 2023 to 2022
(Attachment"B"):
Total sales for the month ($2,600,688) increased 2.41% (+$61,306). Sales-related
taxes increased 2.19%, although cost of sales improved a modest 0.04% ($563), resultin in a
net increase in gross profit of$47,734, (7.43%). g
Payroll-expenses ($386,694) increased substantially ($103,373, 36.49%) due to three
payroll periods in September of the current year.
Total operational expenses ($146,685) increased$21,445 (+17.12%), primarily due to
escalations in utilities ($6,068), credit card fees ($5,731), training/conference expenses
($3,020) and equipment repairs ($2,429).
Net income after depreciation was $17,985, down -$90,112 (-83.36%).
i
Page 1 of 5 pages
I
ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: October 17, 2023 Agenda Item # 5a
Regular Session X
Closed Session
3. Actual to Budget Comparison for Year-to-Date 2023 (Attachment "C"):
With one-quarter of the fiscal year passed, a balance of approximately 75% of
allocated funds should remain in the annual budget. In the case of sales (76.33%),year-to-date
revenues trended 1.33% higher than anticipated. However, expenditures for total payroll-
related expenses (75.26%) and total operating expenses (75%) were as expected.
Although potential increases in equipment repair, store maintenance and capital outlay
related to store expenses are expected in the future, first quarter performance of revenues and
expenses finished squarely within the parameters of the annual budget.
Action Requested:
1. Consent Agenda Item.
2. Review and discuss as needed.
Financial Impact: See Above
Staff Recommendations/Comments: None
Page 2 of 5 pages
Orange County Alcoholic Beverage Control Board
Comparative Statement of Net Position
As of September,2023 and 2022
Attachment"A"
Assets
Currant Assets 2023 2022 Vanished
Cash&Cash Equivalents
Cash-Tmist 620,060 943,414: (317,364)
Cash-Roxboro Savings 391.837 926,033- (534,196)
Cash-Fimt Horizon 2,624,132 1,948.071 676.061
Cash-Change Banks 16000 15.700'. 2,300
Total Cash&Cash Equivalents 3,660029 3.833218 (173189) 4.52%
Accounts Receivable 1,355 5,982: (4,627)
Prepaid Expenses 167,568. - 136,165'. 31,403
Distributions(prepaid) 0 0'
Security Deposits 20,736 20,736'
Inventory 4,984,009 4,274,635I 709.474 16.60%
Inventory(bags) 31,227 69,560: (28,333)
Lease Asset 2,112,828 2053.336; 59,492
7.317,723 6,550,314'. 767,409
Total Current Assets 10,877:752 10.383 532' 594,220
property&Equipment
Land,Buildings&Improvements 13,131,027 10,149,392. 2,981,635
Vehicles&Equipment _ 2,179,632 1,890640:' 289.092
Total Property&Equipment 15,316,659 12,039,932' 3270,727
Less:Accumulated Depreciation (4,178,391) (4;041,496)I (136,895)
Accumulated Lease Amortization (509690) (275626' (234,064)
Net Property&Equipment 10.622578 7,722,810 2,899,768
Other Assets(Pension)
Deferred Ouglow Asset(OPEB) -185,678 -242,387 56,709
Pension Deferrals/Net Pension Asset 677,608 343,977 333,631
Deferred Outflows of Resources 264559 201,166'.. 63.393
746,489. 302,756 443,733
Construction in Progress(Southern Village) 0 33.310. (33,M)
Construction In Progress(Mebane) 0 2,299525` (2,288526)
Total Other Assess 0 2,332,835 (2,332 8351
Total Assets _22,346,818 20,741,933 8 1, 04,888
Liabilities and Equity
Current Liabilities
Accounts Payable j
Trade 11369.908 1,143,205 226,643
Other 118,274 171,348 (63,074)
1,468,182: 1,314,613.. 173,669 13.19%
Elected Taxes 601,599 688,574 13,026
Other Taxes 164.836 150,604' 4,231
Payroll Liabilities
19,649 31,432'. 63,935
Payroll Accmals 1
Accrued Interest(lease) 43.491 22, 14,203
,070 0 (16679)
924.941 848,126 76.815 9.06%
Other Current Liabilities
Net Liabllity(OPEB) 446,71B 646,056< (tD0,336)
Deferred Pension Liability 1,413,742 363,482'. 7(100,338
Deferred Inflows of Resourban(pension) 18,721 649,6363,462 ,050,280
Lease Liability(current portion) 916)
231,241 202197 29,044 j
2,110;422 �1;6�6',3g1 449,071
Long Term Liabilities
Note Payable(First Horizon) 2,462,955 1,968;OT8' 474.877
Note Payable(Truisl) 0 988,078 (474,877
Long Term Debt Adlustment(lease) 164,000 567,602 51,602
Lease Liability(long tams portion) 478
1.519,134 1.675622. 11563388
4,M 091 4,360,]26. (2P4 6361 -5.15%
Distributions
Payable to Law Enforcement 0 125 (125)
Payable to Education 0 27,274 (27,274)
Payable to County 0 0
Total CurrenOLT Liabilities 0 E7,399. (2]399)
Equity
Balance Beginning of the year 13,462,308 12,256,788. 1,206,640
Add Income(Less)Veer-to-Date 224,875 272,950 (48,075) -17.61%
Balance End of Period _ 13,687,183 12�528,718. 1.157,465
Total Liabilities&Equity 22346819 20 741933 1,604,886
i
3
i
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Revenues,Expenses and Changes In Net Position
For the month of September,2023 and 2022 Attachment"B"
Sales September September $
Retail-Liquor Sales 2023 2022 Variance Variance
WlnefMlxera Sales
2,126,709 2,066,513 60,196
3,328 2.91
Commercial/LBD/Mixed Beverage-Liquor Sales 9,801 258 8.411
Total Sales g q 470,853 469,801 852 0,1g Y.
2,600,688 2,539,382 61,306 2.41%
Less Taxes Based on Gross Sales 607,254 694,245 13,009 2.19%
Net Sales 1993,434 1,945,137t
248%
Less:Cost of Sales(Inc.breakage/ad/s1e) 1,303,512 1,302,949
0.04%
Gross Profit 689,922 642,188
7.43
Payroll&Related Expenses
Salaries&Wages 277,946 182,841 i Payroll Taxes 52.02%
21,020 18,65312.69%Emp Retirement 31,828 26,31020.97%Health Insurance 33,230 33,759
Retiree Health Ins 13,513 1.57°1
Human Resources 11,51217.38%NC 401k 847 1,486 -43.00%Processing fees 7,468 7,964 -6.23%
Total Payroll&Related 842. 796 46 5.78%
386,694 283,321 103,373 36.49%
Operating Expenses
Board Members/Meeting/Travel/hainin9 1,011 465 546 117.42%
Rent 4,300 4,300
Lease Amortization 19 627 - 0.00%
Repairs&Molar. (Ridge) 19,746 (121) 100.00%
Repairs&Maim,(Equip.) 3,788 2,179 1,609 73 84%
Utilities,Telephone and Internet 3,158 729 2,429 100.00%
Insurance- 13,031 6,963 6,068 87.15%
Business
Store Expenses,Supplies Bags
Travel/Mileage Reimbursement
18,535 16,599 1,936 7,044 6,409 635 9.91%
nt 11.66%
Office/Warehouse Supplies&Expenses 2735 - 735 0.00%
,
Ext.Maintenance Services 2,736 (101) 0.00%
ostracV 2,122 2,034 88 0.00%
Postage Service Agreements 9,108 7,679 1,429 Ptage 455 0,00%
Professional Services(legallaudit) 975 125 0.00
Dues/Licenses/Fees 2,216 1,445 25 0,00%
Credit Card Processing/Bank fees 216 445 (229) 0.00%
Training/Educatlon/Meetln 44,990 39,259 5,731 0.00%
Burglar Alarm&Security g 4,184 1,084 3,020 100.00%
Vehicle Expense 575 575 - 0.00%
Uniforms 363 1,456 (1,092) 100.00%
Interest(Debt Service) 5,109 5,78b 6 1.69
Interest(Leases) ( 99) -11.00%
3,490 3,789 '
Cash over/short (182) -40.27%
Contingencles/Mist. 279 230 (182) -g027%
Total Operating Expenses 19 230 211 -91.74%
146685 125,240 2i,445 17.12%
Total Payroll/Operating Expenses 633,379 408,561 124.818 °
30.55/o
Income from Operations 156,543 233,627 (77,084) -32.99%
Other Income
Investment income 4t3 155 258 166.45%Miscellaneous 25 25 0.00%Total Other Income 436 155 283 182,58%
Net Income Before Distributions 156,981 233,782 (76.801) -32.85%
Statutory Distributions: -
Law Enforcement(5%) 14,720 14,000 720 0
Alcohol Rehabilitation&Education(7%) 21,750 21,000 5.14/o
Total Statutory Distributions 750 3.57%
36,470 36,000 1,470 4.20%
Net Income Before Profit Distribution 120,511 198,782 (78,271)
Profit Distribution: -39.38
Orange County-General Fund 66,666 56,334 8,332 14.28%
Net Income(Loss)before depreciation 63.846 140,448 j
depmclatlon 35,860 32351
17.911 108,097 (90,712) -83.36%
Year to Date Sales Comparison current current
Sales FY 2024 FY 2023M104,710
Retail Liquor 6,181,254 6,076,544A1.72%Wine Sales 9,009 8,611
LBDSales 6181,25 1,076,544TotalSales 7 401 474 7,287,983 i Net Income(YTD) 224,875 272,950
48,075 -17.61
I
I
1
Orange Ccun[y ABC Boats
Actual to Budget CUM Parlson
For the fiscal year ending 0613012024 Alfachment'Ge
SEPTEMBER YTD 2024 Balance %
Sa/ea 2023 gutl6e[ Remelnlnp gamelnlnp
Liquor Sales 2,126,709 6,191,254 26,613,255 20,432,OD1 ]B.W%
Wine/Mixer 3,326 %009 40,050 31,041 77.61%
LBD 470,653 1,211211 4,615,600 3,404,469 73.76%
I Gross Sales 2,600,688 7,401,474 31,268,985 23,867,511 76.33%
Taxes based on gross sales 607,264 1720,591 7,501,430 5,780,839 77.06%
Net Soles 1,993,434 5,680,883 23,767,555 18,086,672 76.10%
Costof Beles pr4um,n lmronlwy eymaea,$) 1.303.512 3,737,743 16,338,045 12,600302 77.12%
Gross Feder 689,922 1,943 140 7429,510 5,486,370 73,85%
Payroll and Related Expenses henchmeek
Salaries and Wages 277-946 590,835 2,575,200 1,985,365 77.07% 75.009
Payroll Taxes 21,020 48,249 197,080 148,831 76.52%
Retirement 31,828 73,2DD 273,910 200,710 73 28%
Group Health Insurance 33,230 113,369 485,000 371,631 76,62%
Retiree's Group Insurance 13,513 40,537 170,000 129,463 76.16%
Human Resources 647 1,320 25,000 23,680 94.72%
401k 7,460 17,189 68,500 51,311 74.91%
Rmcessing fees 842 2,274 91600 7,326 76.31%
Total payroll Agreed expenses 386694 $86,973 3805,290 2,918317 76.89%
Operating Expenses
li Board MmelarerMcm eg?revelRralnin8 11011 3,192 8,500 5,308 82.46%
Rent 4,300 18,526 6GW5 47,479 71,93%
Lease Amortization 19,6v 58,881 246,085 187,204 76.07%
Repairs&Maintenance-Bldgs 3788 11,221 42,000 30,779 73.28%
Repairs&Maintenance Equip. 3,168 5,768 25,000 19,232 76.93%
Utllitles,Telephone,Internet 13.031 27,596 95,000 67,404 7D.95%
Business Insurance 7.044 21,169 88,275 67,106 76.02%
Store Suppla%Saga and Expenses 18,635 54,134 180,000 125,866 69,93%
Employee Travel 735 2,081 3,500 2,419 69.11%
Offlce Supplies&Expenses 2,635 8,562 25,000 16,438 66.76%
Maintenance Services 2,122 6,456 28,000 21,544 76.94%
Service Agreements(Data/HVAC) 9,108 27,35E 95,000 67,644 71.20%
Postage 4W 1,072 3,400 2,328 68.47%
Professlonal Fees(oNlce)(audit and legal) 2,000 6,000 35,OD0 29,000 82.0%
Cuts&Subscriptions 210 - 597 4,90 4,303 87.82%
Credit Card Processing 44,990 129,274 565,115 435,841 77,12%
Training and Education 4,104 4,153 10,000 5,947 66.47%
Burglar Alarm and Security 575 1,725 7,200 5,475 76.04%
Vehicle Expense 363 2,010 30,000 27,990 93.30%
UnRorms - 311 4,000 3,689 92.23%
Debt Servlce(Interest expense) glum 16,284 62,675 46,391 74.02%
Internet(Lease,) 3,490 10,619 41,260 30,642 7427%
Cash over/short 270 627 Sm (1271 -25.40%
Contingencies/Mice. 19 37 500 463 92.6091
Total-parching expanses 146,585 416,650 1,666,915 1,250,265 75.00%
Total OperatioglPsyroll Expanses 533,379 11303,823 5,472,205 4,168,582 76.18%
Income from Operations 156,ma 639,517 1,957,305 1,317,788 67.33%
Otherincome
Interest lunches 413. 1;304 2,500 11196 47.84%
Mlscellaneous 25 315 11000 685 68.50%
Total Other lnoomo 438 11619 3,500 1,801 53.74% '.
Net Income Before Profit Disirlbullons: 1561981 641,136 1,960;805 1,319,669 67.30%
Statutory Distributions
Lew Enforcement 14,719 44,158 211,630 167,472 79.13%
Alcohol Rehab&Ed ED
65,25P 261,000 195,750 750D%
Total Statutory Distributions 109,408 472,630 363.222 76.85%
Net Income Before Profit DlslHbutlon 531,728 1,488,175 956,447 64,27%
Pro01 Dlstrlbutlon
Orange C-unly�Gsn Fund 200,000 805,000 605,000 7fi.i6%
Working Capital RetinoduChenge In Net Pealtlae: 331.728 BB3,1]6 351,44] 51.44%
aePmcleOan tnmAe"Ve.d clue 39UW ID6853 426_OW
11 des 214,871 Zell.
Capitol Outlet/ Month VTD Budget eadaetrememms
Warehouse
Oelivery truck 0 430,400 130,400 100.00% .
Racking,Incorrect,scanners,computer 14,311 23.036 23,500. 464 1.97%
office
Replacement windows 0 36,000 35,000 100.00%
Grant software,monitor,DVR 3;368 16,000 12,632 78.95%
Stares
Security camera upgrades 0 10,000 10,000 100.00%
Stare"Elslgn 2.881 0 (2,881) -100.00%
Store#004 adm1fino1 a ahloat/englneering 2,WO 0 (2,900) -100.00%
1%19amfed molar 3;280 0 (3,280) 400.00%
Capital Receipts
Approprlated fund balance(RSB) (17,874) (373,400) (355,526) 95.21%
Debt Smrclu.i I I l)
First Hatred(Mebane Store) 12,89 37,723 168,500 120,777 76.20%
Z72054 55,314
s
I
I
ORANGE COUNTY ABC BOARD —AGENDA FORM
Meeting Date: October 17, 2023 Agenda Item # 5b
Regular Session X
Closed Session
Presenter/Information Contact: Ron McCoy
Subject: September 2023 Year-to-Date Retail and Mixed Beverage/LBD Store Sales
Attachment(s):
1. Attachment "A" Comparative Statement of Monthly and Year-to-Date Retail and Mixed
Beverage Sales by Store for September 2023 and 2022 (Page 3)
2. Attachment `B" Comparative Statement of Monthly and Year-to-Date Retail and Mixed
Beverage Sales Rankings for September 2023 (Page 4)
Brief Summary/Explanations:
Comparative Statement of Monthly and Year-to Date Retail/LBD Sales bye (page 3)
Total retail store sales increased $60,187, up 2.91%, due to sales increase at Mebane (4)
($70,843, +35.80%) and Southern Village (8) ($71,910, 100%). All other sales experienced sales
decreases. Carrboro (7)had the largest decrease, down-$21,679 (-5.52%). Chapel Hill North (3)had
the largest percentage decrease, down -6.60% (-$18,344).
Total LBD sales were virtually unchanged from the prior year(+0.18%). Rams Plaza(2) had
a substantial sales decrease (-$25,776), due primarily to the reallocation of LBD customers to other
store locations.
Total bottles sold (170,232) increased by 1,989 (1.18%).
Year-to-date retail sales decreased at all stores except Mebane (4) (up $232,972, 40.16%) and
Southern Village(8) (up $211,019, 100%).
Comparative Monthly and Retail/LBD Sales by Store Rankings (page 4)
Rams Plaza(2) finished first in both retail ($376,663) and LBD ($290,796) sales. Carrboro (7)
placed first in wine sales ($752), second in retails sales ($371,268) and third in LBD sales ($75,971).
Oakdale (10) finished third in retail sales ($323,249) but pushed into second place in LBD sales
($76,600).
Action Requested:
1. Consent Agenda Item.
2. Review and discuss as needed.
Financial Impact: See Above
Staff Recommendations/Comments: None
Page 1 of 3 pages
i
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Monthly and Year-to-Date Retail and Mixed Beverage Sales by Store
For the month of SEPTEMBER 2023 and 2022 Attachment A"
Monthly Liquor Sales/YTD
Retail Sales/bV store numb j 09/01/2023-09/30/2023 09101/2022-09/30/2022 Of
di erence %increase retailsa/es
Hillsborough(1) 157,254 161,637 (4,383) -2.71% 7.39%
Rams Plaza(2) 376,663 393,050 (16,387) -4.17% 17.71%
Chapel Hill North(3) 259,746 278,090. (18,344) -6.60% 12.21%
Mebane(4) 268,711 197,868 70,843 35.80% 12.64%
Meadowmont(5) 173,471 182,545 (9,074) -4.97% 8.16%
Eno/Durham(6) 124,437. 124,473 (36) -0.03% 5.85%
Carrboro(7) 371,268. 392,947 (21,679) -5.52% 17.46%
Southern Village(8) 71,910 0 71,910 100.00% 3.38%
Oakdale(10) 323,249 335,912 (12,663) -3.77% 15.20%
LBD 2,126,709 2,066,522 60,187 2.91% 100.00%
%of LBD sales
Rams Plaza(2)
290,796'. 316,572 (25,776) -8.149.1 61.79%
Chapel Hill North(3) 8,896 0 8,896 100.00% 1.89%
Mebane(4) 1,014 1,405 (391) -27.83% 0.22%
Meadowmont(5) 14,298. 12,375 1,923 15.54% 3.04%
Carrboro(7) 75,971 81,952 (5,981) -730% 16.14%
Southern Village(8) 3,078: 0 3,078 100,00% 0.65%
Oakdale(10) 76,600 57,497 19,103 33.22% 1628%
470,653. 469,801. 852 0.18% 100.00%
TOTAL 2,597,362 2,536,323 61,039 2.41%
Total Bottles Sold 09&112023-09/30/2023 09/01/2022-09/30/2022
Retail 80,039 80,287 (248) -0.31%
"minis"(50 ml) 71,841 68,916 2,925 4.24% '
18,352 19,040
LBD (688J -3.61% '
170,232 168,243 1,989 1.18%
Year-to-Date Liquor Sales
of
Retail Sales m ,r mb ) 07/01/2023-09/30/2023 07/Ol/2022-09/3012022 %
di erence %increase retail sales
Hillsborough(1) 465,486
474,943. (9,457) -1.99'Yo 7.53%
Rams Plaza(2) 1,086,034 1,161,440 (75,406) -6.49% 17.57%
Chapel Hill North(3) 754,907 818,308 (63,401) -7.75% 12.21%
Mebane(4) 813,064 580,092 232,972 40.16% 13.15%
Meadowmont(5) 495,262 542,023 (46,761) -8.63% 8.01%
Eno/Durham(6) 356,356. 363,297 (6,941) -1.91% 5 77%
Carrboro(7) 1,051,774 1,115,295 (63,521) -5.70% 17.p2%
Southern Village(8) 211,019
0 211,019 100.00% 3.41%
Oakdale(10) 947,352 1,021,146 (73,794) -7.23% 15,33%
6,181,254 6,076,544 104,710 1.72% 100.00%
LBD 07/01/2023-09130/2023 07/0112022-09/3012022
Rams Plaza(2) %of LBD sales
720,351. 774,004 53 653 - " o
Chapel Hill North(3) 14,192 ( , ) 6.93/0 59.47/0
0 14,192 100.00% 1.17%
Mebane(4) 2,947 3,198 (251) -7.85% 0.24%
Meadowmont(5) 37,535 37,029 506 1.37% 3.10%
Carrboro(7) 224,661 213,882 10,779 5.04% 18.55%
Southern Village(8) 9,631 0 9,631 100.00%
Oakdale(10) 201,894 0.80%
174,715 27,179 15.56% 16.67%
1,211,211 1,202,828 8,383 0.70%
- 100.00%
TOTAL 7,392,465 7,279,372 113,093 1.55%
i
Page 2
Orange County Board of Alcoholic Beverage Control
Comparative Statement of Monthly and Year-to-Date Retail and Mixed Beverage Sales Rankings
For the month of SEPTEMBER 2023 and 2022 Attachment "B"
Sales Rankings
Retail Liquor Sales 09/01/2023-09/30/2023 RANK %of Total
Rams Plaza (2) 376,663 1 v.71%
Carrboro (7) 371,268 2 1Z46%
Oakdale (10) 323,249 3 15.20%
Mebane (4) 268,711 4 12.64%
Chapel Hill North (3) 259,746 5 12.21%
Meadowmont(5) 173,471 6 8.16%
Hillsborough (1) 157,254 7 z39%
Eno/Durham (6) 124,437 8 5.85%
Southern Village (8) 71,910 9 3.38%
2,126,709 100.00%
LBD 09101/2023-09/3012023
Rams Plaza (2) 290,796 1 61.79%
Oakdale (10) 76,600' 2 16.28%
Carrboro (7) 75,971 3 16.14%
Meadowmont(5) 14,298 4 3.04%
Southern Village (8) 3,078 5 0.65%
Chapel Hill North (3) 8,896 6 1.89%
Mebane (4) 1_,014 7 0.22%
470,653 100.00%
Wine Sales 09/01/2023-09/30/2023
Carrboro (7) 752' 1 22.62%
Chapel Hill North (3) 622 2 18.71%
Meadowmont (5) 512 3 15.40%
Rams Plaza (2) 480 4 14.44%
Oakdale (10) 414 5 12.45%
Mebane (4) 160 6 4.81%
Hillsborough (1) 160 6 4.81%
Southern Village (8) 145 8 4.36%
Eno/Durham (6) 80 9 2.419.
3,325 100.00%
Page 3
ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: October 17, 2023 Agenda Item# 5C
Regular Session X
Closed Session
Presenter/Information Contact: Ron McCoy
Subject: Statewide Sales Report for September 2023
Attachment(s):
1. Attachment"NC Statewide Sales Report of Spirituous Liquor(Retail and LBD Sales)"
September 2023
Brief Summary/Explanations:
Total retail liquor sales for the 171 ABC Boards in North Carolina were $122,092,122, up
$2,727,270 (2.28%). Total LBD sales for the month ($31,512,389) dropped slightly, down-$38,376
(-0.12%).
27 boards (15.79% of total boards) produced 71.47% of all sales in the state. Mecklenburg
County ABC led all sales with$22,571,050, followed by Wake County ABC with $17,940,698.
Orange County ABC moved into I lt"place with total sales of$2,597,362.
Action Requested:
1. Consent Agenda Item.
2. Review and discuss as needed.
Financial Impact: See Above
Staff Recommendations/Comments: None
Page 1 of 2 pages
4owawN � mwmmmmwOmanoti D t+ 0 p Ln o m Ln Ni
v n m d r o r a n t-1 m N Ln N oa m ca t-1 d r o ll o LD m
to o � ni rV o a0 O N m Q n a Di m M t0 Iri VI rYj n'j [t d m o w
v
•� N co co N N Q r O m n N N m to LD Ln ri r r-1 °o o r M m m m M
N a N tD m m r Ln r-I N m LA O m Ln o °0 m m O oo m m m m m In ri
m 1p N M1 m cP o N N m m 'i r N (n ri cc m Q m - r of vl In m n
O LO fV M r � N Co N L l D �-1 Q .--I N tD N n N M N lO a m M
HI d m d L'1 Ob N ri 4l1 ri e-I N r1 t--I r1 N N rrY tYi N N p M1
❑ N ~ r'1
U
a: a� a o ZRe, 9 .R9 999Ao 3E 3e3e998 Z9 � ao
d N oo Lo m Hm to a .-, m +-i r1 r- w r m o o m m m v o n m
m m o to m LD N h o Lo m N m o rn 'i w to o o m m m ri o ri v, �o ❑I ry
Ol O to Lri of La Ll In m o .-1 r� o o m Ln to o a o ti Lo r- o ti m mi
DO m r oa r. m m 0o n m m m m m m m m m m Lo r r rn co o
w '
w
yr LD o c-I rr H M o ri Ln r d .-i Ln d tD Ln M a a tti o t6 d Co d m tO
m co o z m .-i 00 m m a m n O ry rn m Nr N N H Ln A m to
m ei m m d N to to m � 00 m m O o 00 m tD I n v "�Ln oo LD o v
m 0o
m v N m wni m ri ri rrs ri 0d a v ,-i of w m �-i m Ln
V o o m LD Ln m Ln vi c0 N d It d oa ,� rn N m m H rr m r .� 'ti m
. m m m d a m m t-1 tO m n Ili. CO lO m o t-I m m co r m N
NM m M M M N t-i rN Lti e-I r-f t-- q N
u`
�ea' ae9Xe o ;R9ZR e99 � oe ;2a2 ;2a aea° aeae � ao � �
H n z d Q d LO Do N v7 " L1'1 Q O Q m H d LO d Ln m m N Lo m o CD
N O Q rq Ih LD Ln rA r" DO d L0 LO LO m m r It +1 N ri N r Q O rn r
a) `ae o o ti rl o o r--i 0 4 o N rri rV rn Ln 'i o o m m M rn rj r4 4 ri m
c
m
.c
m Nm tD m o cr Ln m r, LD e0 d m N r rn � o m m m r- m m to o m
o a n H O .--3 a .--I m Q n m m h m Q N !� Ln m m m Lrl o m M
10 LA Q m o m ri a t6 LD ri O m ri cl In ot m LD O m r O M ri N kc n rp m
rfl N' Q In m N Q SD O m ' Ln N m N N V N i LD o al m LO li] M V c cc
F +h N ri m M M m M1 N N N L➢ m <D 00 N m .-i a Vl Q m Ln N m
N
OD m .-1 r In to m m eti O d d 0 LD m m tti LO Ln rn m m M r 0 m m Ln h
yL Cl) m Q LD r-I m m d N m t-I n d m Ln d M ti CO N V N m h h c-I 00
w d N a d m .--I m m Q ff m a ri d Lr1 m Q m lO m Ln m lti t-1 N m d lryD LD
m rn Ip Lti M o0 .--I m m r m LD m N N m m e-I rl r rl M o Lo m �a d m V Ln
N Q N m m a m N ri r m m H m tO n w m 0a LO O to It Q N M M t•i ri
m m cr M1 m m r. m c0 n m tO �' M rV M 0 m r lD Ln Lnq M N m
N .ri t0 Ln Ln � - V N N' N' N N' N N' N " H ti c-I r1 ti r-I r-i r[ ry ti Id cr
G o
N �
M
N m r N d Ln N O m r Q 1-4 tD M N a N M tD Ln M m (n N N M Lo Co Ln
N Ln d m r -:rN o m LO N n m r c-I r m r-- Do r, co m r o 00 l0 N Lo
N " M ei O Ln m m m m LD W 'i o0 d m r O d N m r/1 rr1 Lr N n m N frl r-
N w n V N oO o a rM1 cr Ln tD C1 t••T r n c l LD N N o O' m m rl' 1D m V r: O 0
N d N d e-I d 00 N m m W m d Q m r-I r-I is r m In L-i Ly ti n es L4 Ln ry
m m r m Q m a m h LD Q 'r L7 LO m N N d In N .--I M .--I N ry .--I ty hl m
y to o6 a c-I rl' ti ti e-j m
N
)-
m 4
LL
°
d m N m m a O M Q Q LD M m r d m to CO O O N d d N Ln r h N
N m dq o m n >� m d No ei m to r-- oo Ln V1 m ei Q Cx cr lO w LO M N LD N
y N m r M r, r! m m O n m m " o ri M1 m t-1 d m .-i m lc m 0a rr N N m
jy Da m m m w ei N m N In LO rf Q Ln m m d m r O o o d N LD m N 'R Q
Vy r•1 m 1D m m m m w N o L"1 d d c-I '-1 m tO m m m rl r-I m O Lb lO y
_ m m o DD N O m LD m N O m ri N a m Ln LO Ln r-I N 1Y1 N N M O m a m
•im+ .M-I rl Lr m � V m N N N N rl N' N' N e-I' r-i ti c-I ti ff ri ti r-i ti .-T m
w � o
0
0 0, n Ln m m oa .r Q LD N a m m o m r m er m e m o o to to m N ci
H to m Q Q N m h m o LD tO a m LO m W r m LD 00 O N .--I m r a h 0 ri N
9J O tD r Ln rV N m m w It r m Ln .-i r r N n N M N CC m r O N m Ln w
10 rl o LD 00 m m L6 Lr LP LD r- m 7 N m r-, m Q m c0 a rl N to e-1 00
m e r, d 00 .--I d N to m Ln N m e-I t-I d m N Q m N d t-I an d Lo m Ln .d-I d m o
61 r.fl m to m r, m o tII o•1 m r Ln Ln Lr d rr7 M 0 00 *�-i' r Lfl Q Q m ftl L•i ei tO �
(Q Q 4
Q N LO m Ln Ln' � N N .--1 Q N N N N N 11 .-I' Li ti .-i ti e-I � fn a
Q F O
m N �
J N n m d LO M m M1 m m n M V 0 LD Q Q m <0 e-1 m N M Ln rV CO r-L
'a N Ln .-i LO LO W m Ln a M N Ln M m Ln LO 4 W m r r d d m O O M co
m
m m tD n O= M r LO r-1 N LO a LD ClO r-I o to m O tD m m m o0 M m cr ry " �
I6 ?L o ff l0 Ln m N m ti o O Q o m LO N O 00 Ln N a d N o Lfl M h m Lr] N al ti
m 00 e-I h a o M m d m N A d m m r-I a N Q m LD N N 00 N N m M 00
VI LD r M O 0 a h kC Q Q d Lo M N N d' N N ,-1 d m .--I s-I N '-1 e-1 O
Q oo .-1 N
m ca OD
u �
O b M m M m N a ri N M m m tO M N t0 LO M r M N N d r .--1 Q w n N Q
V m m m r, LO N It LO m o <D d .--I Lo o .i Q m L-1 Lo m n m r Lo m N `
U N LO m 00 tO Ln m m LD N A tD fV Q c .--1 m N O m " Ln m o V o N I
J m o m m N N OO o � tD LD m m r-1 e-I tG r: l0 m LD m m m " m W O L/I 4] N'
N m N o r-1 Q m LD m LO m N M1 00 e-1 Do N .i m M Oo m LD Lp m tD w n m O aE
Ln m N N m n m Lp LD m m 0 .--I N r-I m In tD lC rV N M N c-I N 4 m b Q In M V Fr q
c r m-! cmi N m Q m m N N N N' .-I N N N' ri rl 1-1 ri r!' — r Or O
0 0 oy rN-I v
a V
D c
m m u m Co m u u U U V co o c c c c
q y Q Q 4 u C Q a u m m m m m
�v .WL u co u° u m o u m m U u .�. -E a a m �. a. Q. S m E = = = E
a ¢ d0 u Q c u u 00 a ¢ m m c G U u v rn N E E E E M1
d w y m ° m 3 a a m u a ¢ o a c c u m c c c VF N d n w .i
OJ p > p U co 4 p C p w m 7 p 7 p Lri
�+ C Q p E c Q p c u v o Q
N { ❑ m c O c p U 16 w a '� 6.1 p m o U U u 'e U } Q m U U U U O v a
m w , o wu v m E — w pn ° o c � ° -oa -o -o -2
i6 c 2 m w u c c w c m
,,, u LY we w a r a7i u c w 3a c c o w E ° ° e ° a } o
° v o m° o 0 0 0 0
H m w m d w 7 p L O N L4 CD x0 C m m p O p rL m — p cQ m m m m
Q+ ¢ �S L7 z i- ❑ u d u 0 o u x o u a DC z C7 u si a w m N m i N
O F
Ui O ] Y c
cc �` C O 14 N m Q LA LO r co m o .•i N m d 1A Lo r b
cc Ly N M d N LD A 00 m !y .-e ..I ei t••I '•I ei N N N N N N N N o 'o
U G m °
Z
N
ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: October 17, 2023 Agenda Item # _
Regular Session X
Closed Session
Presenter/Information Contact: Office Staff
Subject: Management Updates as of October 11, 2023.
1. Law Enforcement
Law enforcement reports will be available at the meeting.
2. Grant Management Companies
We continue to evaluate Grant Management Companies for potentially making
the grant system more consistent and streamlined.
3. Website Design
We hired 90Degree to do the website redesign and hope to have it ready to
launch at the beginning of the year.
4. Bank Evaluations
Staff have been meeting with banks to consider if we want to make a change or
consolidate our banking relationships. We will keep the board updated if any
changes are recommended.
6. Duct Cleaning
The ducts were cleaned at our two older stores in Hillsborough and Eno close to
Durham. Two air tests were also performed to check indoor air quality.
6. Bourbon Steward Class
The second Bourbon Steward Class was September 24 in partnership with
Mystic Distillery and we had 18 who attended. Durham ABC sent 15 employees
as well.
7. Single Barrel + Sale Items
Several stores set up Single Barrel Staff Selection Endcaps as seen in a picture
from the Oakdale store. We also marked down some delisted items as seen
pictured on an endcap at Chapel Hill North.
8. Store Lighting Upgrades
3 stores are in the process of having some outdoor lighting improvements done
before the time changes. Mebane is adding two lights behind the store. Carrboro
is upgrading two parking lot fixtures to high performing LED fixtures and Ram's
Plaza management is adding another light behind the store.
Page 1 of 1 pages
i
1 r • �
i
1
ASC
• . . f ' t
IQ r
PV
_,,:_.,-:a� � �, ;w ;;;,• I � lay �,4.{�,.� ���'
,;ram �� �u:, goo
.1•.3',r lel� � 4� i' k L p -14
,
wr
41
•� �"� i'_ O 1.D r � -` i�. { .__�T:
_eat � p�h� flLl '
lit
r '
Tr
mat
••: 1� j • • '• E t 1 y
's}
t . 1 ,j yl ,� 1 j � ��•
CFFF-N F--FFEh EFFEh FFF
1
Kom
Id
KNOB � . . . . . " :r • ,� � s,�
hiw CREEK :�
ti _ RYE ram: �� I
` 4\SAL
i
._
:Jrrrmot APPE[
nil
t
i
•
d Mi PS
cpas + advisors
ORANGE COUNTY ALCOHOLIC
BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
HILLSBOROUGH, NORTH CAROLINA
FINANCIAL STATEMENTS, MD&A, AND
SUPPLEMENTARY INFORMATION
Years Ended June 30, 2023 and 2022
DMJPS PLLC 1 888,873.2545 1 dmjps.com I be greater Member of CPAmerica,Inc.
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
HILLSBOROUGH,NORTH CAROLINA
June 30,2023 and 2022
BOARD MEMBERS
Patrick Burns
Chair
i
Judson Williamson
Mike Zito
Elizabeth Carter
Melvin Green
I
Tony DuBois
General Manager
i
i
i
i
i I
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
HILLSBOROUGH,NORTH CAROLINA
June 30,2023 and 2022
TABLE OF CONTENTS
Pages
INDEPENDENT AUDITOR'S REPORT 1-3
MANAGEMENT'S DISCUSSION AND ANALYSIS 4-8
FINANCIAL STATEMENTS
Exhibit A Statements of Net Position 10
i
Exhibit B Statements of Revenue,Expenses,and Changes in Net Position 11-12
Exhibit C Statements of Cash Flows 13-14
Notes to Financial Statements 15-34
REQUIRED SUPPLEMENTARY INFORMATION
Schedule 1 Local Government Employees'Retirement System's
Schedules of Proportionate Share of Net Pension Liability(Asset) 36
Schedule 2 Schedules of Contributions 37
Schedule 3 Other Post-Employment Benefits—Schedules of Changes in the Total
OPEB Liability and Related Ratios 38
SUPPLEMENTARY INFORMATION
Schedule 4 Schedule of Revenue and Expenses by Stores 40-41
i
Schedule 5 Schedule of Store Selling Expenses 42-43
i
Schedule 6 Schedules of Warehouse and Delivery Expenses 44
Schedule 7 Schedules of Administrative Expenses 45
Schedule 8 Schedules of Nonoperating Income(Expense) 46
i
Schedule 9 Schedules of Law Enforcement Expenses 47
Schedule 10 Schedule of Distributions of Profits 48 49
Schedule 11 Schedule of Revenue and Expenditures—Budget and Actual 50-51
•
t•
MjPS
cpas + advisors
INDEPENDENT AUDITOR'S REPORT
Board of Directors
Orange County Alcoholic Beverage Control Board
Hillsborough,North Carolina
Opinion
We have audited the accompanying financial statements of Orange County Alcoholic Beverage Control Board ("the
ABC Board"),a component unit of the Orange County Government,which comprise the statements of net position, as
of June 30, 2023 and 2022, and the related statements of revenue, expenses, and changes in net position and cash
flows for the years then ended,and the related notes to the financial statements.
In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position
of the ABC Board, as of June 30, 2023 and 2022, and the respective changes in financial position, and where
applicable, cash flows for the years then ended, in accordance with accounting principles generally accepted in the
United States of America.
Basis for Opinion
We conducted our audits in accordance with auditing standards generally accepted in the United States of America.
Our responsibilities under those standards are further described in the Auditor's Responsibilities for the Audit of the
Financial Statements section of our report, We are required to be independent of the ABC Board, and to meet our
other ethical responsibilities, in accordance with the relevant ethical requirements relating to our audits. We believe
that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinion.
Responsibilities ofManagem entfor the Financial Statements
Management is responsible for the preparation and fair presentation of these financial statements, in accordance with
accounting principles generally accepted in the United States of America; this includes the design, implementation,
and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are
free from material misstatement,whether due to fraud or error.
In preparing the financial statements, management is required to evaluate whether there are conditions or events,
considered in the aggregate, that raise substantial doubt about the ABC Board's ability to continue as a going concern
for twelve(12) months beyond the financial statement date, including any currently known information that may raise
substantial doubt shortly thereafter,
4-
DMJPS PLLC 1 888.873.2545 1 dmjps.com I be greater
Member of CPAmerica,inc.
Auditor's Responsibilities far the Audit of the Financial Statements
Our objectives are to obtain reasonable assurance about whether the financial statements, as a whole, are free from
material misstatement, whether due to fraud or error, and to issue an auditor's report that includes our opinions.
Reasonable assurance is a high level of assurance,but is not absolute assurance, and therefore, is not a guarantee that
an audit conducted in accordance with generally accepted auditing standards will always detect a material
misstatement when it exists. The risk of not detecting a material misstatement resulting from fraud is higher than for
one resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the
override of internal control. Misstatements are considered material if there is a substantial likelihood that,
individually,or in the aggregate,they would influence the judgment made by a reasonable user based on the financial
statements.
In performing an audit in accordance with generally accepted auditing standards,we:
• Exercise professional judgment and maintain professional skepticism throughout the audits.
• Identify and assess the risks of material misstatement of the financial statements, whether due to fraud or
error,and design and perform audit procedures responsive to those risks. Such procedures include examining,
on a test basis,evidence regarding the amounts and disclosures in the financial statements.
• Obtain an understanding of internal control relevant to the audit in order to design audit procedures that are
appropriate in the circumstances,but not for the purpose of expressing an opinion on the effectiveness of the
ABC Board's internal control.Accordingly,no such opinion is expressed.
• Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting
estimates made by management,as well as evaluate the overall presentation of the financial statements.
• Conclude whether, in our judgment, there are conditions or events, considered in the aggregate, that raise
substantial doubt about the ABC Board's ability to continue as a going concern for a reasonable period of
time.
We are required to communicate with those charged with governance regarding, among other matters, the planned
scope and timing of the audits.
i
Other Matters-Required Supplementary Information
Accounting principles generally accepted in the United States of America require that the Management's Discussion
and Analysis on pages 4 through 8, Local Government Employees' Retirement System's Schedules of Proportionate
Share of Net Pension Liability (Asset) on page 36, Schedules of Contributions on page 37, and Other Post-
Employment Benefits on page 38, be presented to supplement the basic financial statements. Such information,
although not a part of the basic financial statements, is required by the Govermnental Accounting Standards Board
("GASB'), who considers it to be an essential part of financial reporting for placing the basic financial statements in
an appropriate operational,economic,or historical context. We have applied certain limited procedures to the required
supplementary information,in accordance with auditing standards generally accepted in the United States of America,
which consisted principally of inquiries of management regarding methods of preparing the information and
i
comparing the information for consistency with management's responses to our inquiries, the basic financial
statements,and other knowledge we obtained during our audits of the basic financial statements. We do not express an
opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient
evidence to express an opinion or provide any assurance.
I
I
2
I
Other Information
Our audits were conducted for the purpose of forming opinions on the financial statements, as a whole.The Schedules
of Revenue and Expenses by Store, Store Selling Expenses, Warehouse and Delivery Expenses, Administrative
Expenses, Nonoperating Income (Expense), Law Enforcement Expenses, Distributions of Profits, and Revenue and
Expenditures—Budget and Actual are presented for purposes of additional analysis and are not a required part of the
basic financial statements. These schedules are the responsibility of management and were derived from, and relate
directly to, the underlying accounting and other records used to prepare the financial statements. The information has
been subjected to the auditing procedures applied in our audits of the financial statements and certain additional
procedures, including comparing and reconciling such information directly to the underlying accounting and other
records used to prepare the financial statements themselves, and other additional procedures in accordance with
auditing standards generally accepted in the United States of America. In our opinion, the information is fairly stated,
in all material respects,in relation to the financial statements taken as a whole.
MF5 ;Dzze
Certified Public Accountants
Greensboro,North Carolina
i
September 28,2023
i
I
-3-
i
•
. :--dmjps
�.�. .• cpas + advisors
MANAGEMENT'S DISCUSSION AND ANALYSIS
This section of the Orange County Alcoholic Beverage Control Board's ("the ABC Board") financial report represents
our discussion and analysis of the financial performance of the ABC Board,as of,and for,the years ended June 30,2023
and 2022.This information should be read in conjunction with the audited financial statements included in this report.
Financial Highlights
• Working capital decrease of approximately 14.18%over the prior year.
• Approximately 11.5%of profits was expended for law enforcement in the current year.
• Approximately 17.3%of profits was expended for alcohol education and rehabilitation in the current year.
Overview of the Financial Statements
The audited financial statements of the ABC Board consist of three(3)components. They are as follows:
• Management's Discussion and Analysis
• Basic Financial Statements
• Additional Information Required by the ABC Commission
The Basic Financial Statements are prepared using the full accrual basis of accounting. They consist of three (3)
statements.The first statement is the Statement of Net Position.Assets and liabilities are classified between current and
noncurrent. This statement provides a summary of the ABC Board's investment in assets and obligations to creditors.
Liquidity and financial flexibility can be evaluated using the information contained in this statement.
The next statement is the Statement of Revenue, Expenses, and Changes in Net Position. This statement is used in
evaluating whether the ABC Board has recovered all its cost through sales. Its information is used in determining credit
worthiness.
The final required statement is the Statement of Cash Flows. This statement reports cash inflows and outflows in the
following categories:operating,investing,and financing activities.Based on this data,the user can determine the sources
of cash,uses of cash,and change in cash.
The notes to the financial statements provide more detailed information and should be read in conjunction with the
statements.
The ABC Commission requires some schedules,in addition to the information required by generally accepted accounting
principles generally accepted in the United States of America. They include Schedule of Revenues and Expenses by
Store, Schedule of Store Selling Expenses,Schedule of Warehouse and Delivery Expenses, Schedule of Administrative
Expenses, Schedule of Nonoperating Income (Expense), Schedule of Law Enforcement Expenses, Schedule of
Distributions of Profits, and a Schedule of Revenue and Expenditures—Budget and Actual.
-4-
DMJPS PLLC 1 888.873.2545 1 dnnJps.corn I be greater
Member of CPAmerica,Inc.
Financial Analysis of the ABC Board
Net position is an indicator of the fiscal health of the ABC Board. Assets exceeded liabilities by $13,462,308 in 2023;
$12,256,768 in 2022; and $10,302,855 in 2021. The largest component of net position was the investment in capital
assets. It was 83% of the total net position for 2023, 80%for 2022, and 85%for 2021. The following is a summary of
the net position:
Condensed Statement of Net Position
$Change %Change
This Period This Period
6/30/2023 6/30/2022 6/30/2021 Over Last Over LastPeriod Period
Assets
Current assets $ 7,777,839 $ 7,991,922 $ 7,804,067 $ (214,083) (2.68%)
Noncurrent assets 13,813,318 12,254,876 10,273,949 1,558,442 4.88%
Total Assets $21,591,157 $20,246,798 $ 18,078,016 $ 1,344,359 6.64%
Liabilities
Current liabilities $ 3,400,630 $ 2,891,667 $ 3,201,519 $ 508,963 17.60%
Noncurrent liabilities 4,728,219 5,098,363 4,573,642 (370,144) (7.26%)
Total Liabilities 8,128,849 7,990,030 7,775,161 138,819 1.74%
Net Position
Net investment in
capital assets 8,548,978 7,688,904 5,868,000 860,074 11.19%
Restricted 919,582 885,538 803,992 34,044 3.84%
Unrestricted 3,993,748 3,682,326 3,630,863 311,422 8.46%
Total Net Position 13,462,308 12,256,768 10,302,855 1,205,540 9.84%
Total Liabilities
and Net Position $21,591,157 $20,246,798 $ 18,078,016 $ 1,344,359 6.64%
Net position increased by 9.84%from 2022,compared to a 12.00%increase between 2022 and 2021.
I
i
i
I
i
i
_5_
i
The following is a summary of the changes in net position:
Condensed Statement of Revenue,Expenses,and Changes in Net Position
$Change %Change
This Period This Period
Over Last Over Last
6/30/2023 6/30/2022 6/30/2021 Period Period
Sales $ 31,208,975 $ 30,050,080 $ 27,158,053 $ 1,158,895 3.86%
Less taxes 7,261,607 6,984,856 6,209,454 276,751 3.96%
Net sales 23,947,368 23,065,224 20,948,599 882,144 3.82%
Cost of sales 16,103,177 15,484,994 14,221,193 618,183 3.99%
Gross profit 7,844,191 7,591,160 6,727,406 263,961 3.48%
Operating expenses 5,523,118 4,699,373 4,547,785 823,745 17.53%
Operating income 2,321,073 2,880,857 2,179,621 (559,784) (19.43%)
Nonopnopererating income
e
(expense) 4,467 6,056 1,742 (1,589) (26.24%)
Change in net position
before required
distributions 2,325,540 2,886,913 2,181,363 (561,373) (19.45%)
Law enforcement and
education expenses 420,000 403,000 318,700 17,000 4.22%
Change in net position
before profit
distributions 1,905,540 2,483,913 1,862,663 (578,373) (23.28%)
Profit distributions 700,000 530,000 400,000 170,000 32.08%
Change in net position 1,205,540 1,953,913 1,462,663 (748,373) (38.30%)
Net position,beginning 12,256,768 10,302,855 8,840,192 1,953,913 18.96%
Net position,ending $ 13,462,308 $ 12,256,768 $ 10,302,855 $ 1,205,540 9.84%
The following is a breakdown of sales by source:
i
$Change %Change
This Period This Period
Over Last Over Last
6/30/2023 6/30/2022 6/30/2021 Year Year
Retail liquor sales $ 26,045,431 $ 25,433,649 $ 24,871,380 $ 611,782 2.41%
Retail wine sales 38,237 41,249 44,816 (3,012) (7.30%)
Mixed beverage sales 5,125,307 4,575,182 2,241,857 550,125 12,02%
Total Sales $ 31,208,975 $ 30,050,080 $ 27,158,503 $ 1,158,895 3.86%
The system sold bottles of liquor and wine as follows:
Bottles Sold Sales Price
June 30,2023 2,020,888 $ 31,208,975
June 30,2022 1,971,522 $ 30,050,080
June 30,2021 1,707,005 $ 27,158,503
i
-6-
Cost, etc.,of the average bottle are shown below:
6/30/2023 6/30/2022 6/30/2021
Sales Price $ 15.4 $ 15.2 $ 15.0
Sales taxes and assessments $ 3.7 $ 3.6 $ 3.5
Cost of merchandise 8.1 8.0 8.0
Store selling expenses 1.8 1.6 1.7
Warehouse and delivery expenses 2 2 2
Administrative expenses [net of nonoperating income
(expense)] 4 4 4
Law enforcement and education 2 2 2
Net income for distribution 1.0 1.2 1.0
$ 15.4 $ 15.2 $ 15.0
Capital Assets
Investment in capital assets,as of June 30,2023,totals$11,203,657,net of accumulated depreciation.
Major capital asset transactions during the year include the following:
Completion of new Mebane store $ 1,510,363
Furniture,fixtures and equipment 340,943
Capital Assets(Net of Accumulated Depreciation)
$Change %Change
This Period This Period
6/30/2023 6/30/2022 6/30/2021 Over Last Over LastPeriod Period
Land $ 1,951,041 $ 1,951,041 $ 1,951,041 $ --- 0.00%
Construction in progress 1,769,975 72,988 (1,769,975) (100%)
Buildings and
improvements 8,716,530 5,776,469 6,019,084 2,940,061 50.90%
Store fixtures and
equipment 377,146 154,589 252,629 222,557 143.97%
Warehouse fixtures
and equipment 16,516 32,528 37,103 16,012
Office furniture, ( ) (49.22%)
fixtures,and
equipment 19,522 31,239 64,860 11,717
( ) (37.51%) i
Leasehold improvements 108,237 117,723 141,520 (9,486) (8.06%)
Motor vehicles 14,665 23,739 44,363 (9,074) (38.22%)
$ 11,203,657 $ 9,857,303 $ 8,583,588 $ 1,346,354 13.66%
Additional information on the ABC Board's capital assets can be found in Note 1.G of the Basic Financial Statements.
-7- i
Debt Administration
Notes payable increased by 22.43%from the prior year.
Summary of Changes in Notes Payable
$Change %Change
This Period This Period
Over Last Over Last
6/30/2023 6/30/2022 6/30/2021 Period Period
Notes payable $ 2,654,679 $ 2,168,399 $ 2,715,588 $ 486,280 22.43%
Requests for Information
This report is intended to provide a summary of the financial condition of the ABC Board. Questions or requests for
additional information should be addressed to:
Tony DuBois,General Manager
Orange County Alcoholic Beverage Control Board
601 Valley Forge Road
Hillsborough,NC 27278
8
i
ORANGE COUNTY ALCOHOLIC
BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
FINANCIAL STATEMENTS
Years Ended June 30,2023 and 2022
i
i
i
I
i
-9-
Exhibit A
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
STATEMENTS OF NET POSITION
June 30,2023 and 2022
ASSETS
2023 2022
Current Assets
Cash[Note 1] $ 3,714,166 $ 3,815,113
Accounts receivable[Note 1] 788 19,299
Inventories[Note 11 3,912,767 4,056,782
Prepaid expenses 150,118 100,728
Total Current Assets 7,777,839 7,991,922
Non-Current Assets
Property,plant,and equipment[Note 1](net of accumulated depreciation) 11,203,657 9,857,303
Lease assets[Note 3](net of accumulated amortization) 1,662,018 1,836,954 '..
12,865,675 11,694,257
Other Assets
Security deposits 15,476 15,476
Total Assets $ 20,658,990 $ 19.701,655
Deferred Outflows of Resources
Contributions of pension plan in current fiscal year $ 254,559 $ 201,166
Pension deferrals 677,608 343,977
$ 932,167 $ 545.143
LIABILITIES&NET POSITION
Current Liabilities
Accounts payable-trade $ 633,241 $ 1,279,490
Accounts payable-other 103,526 130,506
Notes payable[Note 14] 154,002 139,524
Lease liability[Note 31 224,276 181,445
Accrued payroll 146,486 118,876
Accrued taxes 725,357 678,364
Net pension Liability[Note 1] 1,413,742 363,462
Total Current Liabilities 3,400,630 2,891,667
Noncurrent Liabilities
Retiree health insurance 445,718 546,056
Notes payable[Note 14] 2,500,677 2,028,875
Lease liability[Note 3] 1,576,425 1,731,409
Total Noncurrent Liabilities 4,522,820 4,306,340
Total Liabilities 7923,450 7,198,007
Deferred Inflows of Resources
OPEB deferrals 185,678 242,387
Pension deferrals 19,721 549,636
$ 205,399 $ 792,023
Net Position
Net investment in capital assets 8,548,978 7,688,904
Restricted for worldng capital 919,582 885,538
Unrestricted 3,993,748 3,682,326
Total Net Position 13,462,308 12,256,768
Total Liabilities and Net Position $ 21,591,157 $ 2Q 246,798
See auditor's report and notes to financial statements.
-10- I
I
I
ORANGE COUNTY ALCHOLIC BEVERAGE CONTROL BOARD Exhibit B-I
(a component unit of Orange County Government)
STATEMENTS OF REVENUE,EXPENSES,AND CHANGES IN NET POSITION
Years Ended June 30,2023 and 2022
2023 2022
Liquor sales $ 26,045,431 $ 25,433,649
Mixed beverage sales 5,125,307 4,575,182
Wine sales 38,237 41,249
Total Gross Sales 31,208,975 30,050,080
Less: Taxes Based on Gross Sales
State's share of mixed beverage surcharge 393,894 370,920
State excise 6,760,808 6,509,663
Mixed beverage 39,389 37,092
Rehabilitation 67,516 67,181
Total Taxes 7,261,607 6,984,856
Net Sales 23,947,368 23,065,224
Cost of Sales
Liquor 16,083,743 15,463,933
Cost of wine sales 19,434 21,061
16,103,177 15,484,994
Gross Profit 7,844,191 7,580,230
i
Operating Expenses
Store selling 3,574,196 2,947,584
Warehouse and delivery 411,251 323,113
Administrative 878,632 770,982
Depreciation and amortization 659,039 657,694
Total Operating Expenses 5,523,118 4,699,373
Operating Income[carriedforward] 2,321,073 2,880,857
I
I
I
See auditor's report and notes to financial statements.
-11-
I
I
Exhibit B-2
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
STATEMENTS OF REVENUE,EXPENSES,AND CHANGES IN NET POSITION
Years Ended June 30,2023 and 2022
2023 2022
Operating Income[hroughtforward] $ 2,321,073 $ 2,880,857
Nonoperating Income 4,467 6,056
Change in Net Position Before Required Distributions 2,325,540 2,886,913
Law Enforcement and Education Expenses
Law enforcement expenses 168,000 166,000
Education expenses 252,000 237,000
420,000 403,000
Change in Net Position Before Profit Distributions 1,905,540 2,483,913
Profit Distribution-Orange County 700,000 530,000
Change in Net Position 1,205,540 1,953,913
Net Position,beginning 12,256,768 10,302,855
Net Position,ending $ 13,462,308 $ 12,256,768
See auditor's report and notes to financial statements.
-12-
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD Exhibit C-1
(a component unit of Orange County Government)
STATEMENTS OF CASH FLOWS
Years Ended June 30,2023 and 2022
2023 2022
Cash Flows from Operating Activities
Cash received from customers $ 31,208,975 $ 30,050,080
Payments for inventory costs (16,605,411) (16,315,900)
Payments for operating expenses (4,918,034) (4,179,599)
Taxes paid
(7,214,614) (6,968,131)
Net Cash Provided by Operating Activities 2,470,916 2,586,450
Cash Flows from Capital and Related Financing Activities
Acquisition and construction of capital assets (1,770,965) (1,715,027)
Increase in lease assets (59,492) (830,735)
Increase(decrease)in lease liabilities (112,153) 690,253
Increase(decrease) in notes payable 486,280 (547,189)
Net Cash Used in Capital and Related Financing Activities (1,456,330) (2,402,698)
Cash Flows from Noneapital Financing Activities
Law enforcement expenses (168,000) (166,000)
Alcohol education expenses (252,000) (237,000)
Profit distributions to primary government (700,000) (530,000)
Net Cash Used in Noneapital Financing Activities (1,120,000) (933,000)
Cash Flows from Investing Activities
Interest and miscellaneous income 4,467 6,056
Net Decrease in Cash (100,947) (743,192)
Cash,beginning 3,815,113 4,558,305
Cash, ending
$ 3,714,166 $ 3,815,113
I
See auditor's report and notes to financial statements.
i
13
I
Exhibit C-2
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
STATEMENTS OF CASH FLOWS
Years Ended June 30,2023 and 2022
2023 2022
Reconciliation of Operating Income to Net Cash Provided by
Operating Activities
Operating income $ 2,321,073 $ 2,880,857
Adjustments to reconcile operating income to net cash
provided by operating activities:
Depreciation and amortization 659,039 657,694
Changes in assets and liabilities:
(Increase)decrease in accounts receivable 18,511 (15,200)
(Increase)decrease in inventories 144,015 (934,172)
(Increase)decrease in prepaid expenses (49,390) 18,325
(Increase)decrease in deferred outflows of resources (387,024) (92,860)
Increase(decrease)in accounts payable (673,229) 144,560
Increase(decrease)in accrued liabilities 74,603 28,298
Increase(decrease)in deferred inflows of resources (529,915) 510,649
Increase(decrease)in deferred inflows of resources OPEB (56,709) (50,787)
Increase(decrease)in net pension liability 1,050,280 (476,293)
Increase(decrease)in retiree health insurance (100,338) (84,621)
Total Adjustments 149,843 (294,407)
Net Cash Provided by Operating Activities $ 2,470,916 $ 2,586,450
See auditor's report and notes to financial statements.
-14-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
A. Principles Used in Determining the Scope of the Entity for Financial Reporting
The Orange County Alcoholic Beverage Control Board ("the ABC Board"), a component unit of the
Orange County Government, is a corporate body with powers outlined by North Carolina General
Statutes ("NC G.S.") Chapter 1813-701. The local ABC Board may borrow money in accordance with
NC G.S. 1813-702(b), and the City or County's governing body who appoints the ABC Board shall in
no way be held responsible for the debts of the ABC Board.
The ABC Board is required by NC G.S. to distribute its entire net income after deducting amounts
required for law enforcement, education, and retaining proper working capital to the General Fund of
the City and County, which represents a financial benefit to the City and County. Therefore, the ABC
Board is reported as a discretely presented component unit in the City's and County's financial
statements.
B. Organizational History
The ABC Board was established under Chapter 18 of the NC G.S. and implemented by a county-wide
election held on February 3, 1959.
A composite Board, consisting of the Orange County Board of Commissioners, the Orange County
Board of Elections,and the Orange County Board of Health,three(3)appointed individuals to serve on
the ABC Board with terms of three(3)years,two(2)years,and one year.
The ABC Board, as provided by North Carolina Alcoholic Beverage Control laws, operates eight (8)
retail liquor stores, and through contacts with the Orange County Sheriff's Department, Town of
Chapel Hill Police Department, Town of Carrboro Police Department, Town of Hillsborough Police
Department, and UNC Police Department, investigates violations of such laws. NC G.S. 18B-
805(c)(2)(3) requires that the ABC Board expend at least 5% of profits for Law Enforcement and at
its for Alcoholic Education and Rehabilitation purposes. The ABC Board is also
least 7% of same pro
required to retain a sufficient amount of cash in its working capital that generally consists of two (2)
weeks of average net sales.
Mixed beverages for social establishments and restaurants in Orange County was authorized by a
comity-wide vote on September 12, 1978.
On April 17, 1979, the North Carolina General Assembly, in Session Laws Chapter 385,provided an
act to expand the ABC Board from three(3) to five(5) members and provided that the members shall
be appointed by the Board of Orange County Commissioners.
i
I�
i
i
-15-
i
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES[cont'd]
C. Basis of Presentation
All activities of the ABC Board are accounted for within a single proprietary (enterprise) fund.
Proprietary funds are used to account for operations that are (a) financed and operated in a manner
similar to private business enterprises where the intent of the governing body is that the cost of
providing goods or services to the general public on a continuing basis be financed or recovered
primarily through user charges or (b) where the governing body has decided that periodic
determination of revenue earned, expenses incurred, and/or the change in net position is appropriate
for capital maintenance,public policy,management control,accountability,or other purposes.
D. Basis of Accounting
The financial statements have been prepared on the accrual basis of accounting. All sales are made by
cash, check, debit card, or credit card, and recorded at the time of sale. Other revenue is recorded
when earned.Expenses are recognized when incurred.
E. Use of Estimates
The preparation of financial statements in conformity with U.S. generally accepted accounting
principles, requires management to make certain estimates and assumptions that affect the reported
amounts of assets and liabilities and disclosure of contingent assets and liabilities at the statement of
net position date, and reported amounts of revenue and expenses during the reporting period.
Estimates are used to determine depreciation expense,the allowance for doubtful accounts, and certain
claims and judgment liabilities,among other accounts.Actual results may differ from those estimates.
F. Pensions
For purposes of measuring the net pension asset, net pension liability, deferred outflows of resources
and deferred inflows of resources related to pensions and pension expense, information about the
fiduciary net position of the Local Governmental Employees' Retirement System ("LGERS"), and
additions to/deductions from LGERS' fiduciary net position have been determined on the same basis as
they are reported by LGERS. For this purpose,plan member contributions are recognized in the period
in which the contributions are due. The ABC Board's employer contributions are recognized when due
and the ABC Board has a legal requirement to provide the contributions. Benefits and refunds are
recognized when due,and payable in accordance with the terms of LGERS.Investments are reported at
fair value.
G. Assets,Liabilities,and Net Position
Deposits
All deposits of the ABC Board are made in board-designated official depositories and are collateralized
as required by G.S. 159-31. Official depositories may be established with any bank or savings and loan
association whose principal office is located in North Carolina. In addition, the ABC Board may
establish time deposit accounts,money market accounts, and certificates of deposit.
16
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES[cont'dj
G. Assets,Liabilities,and Net Position[cont'd]
At June 30, 2023, the Board's deposits had a carrying amount of$3,714,166 and a bank balance of
$3,851,221. At June 30, 2022, the Board's deposits had a carrying amount of$3,815,113 and a bank
balance of $3,925,897. All of the bank balance was covered by the Federal Deposit Insurance
Corporation("FDIC").
All of the ABC Board's deposits are either insured or collateralized by using one of two (2) methods.
Under the Dedicated Method, all deposits over the FDIC coverage are collateralized with securities
held by the ABC Board's agent in the ABC Board's name. Under the Pooling Method, a collateral
pool, all uninsured deposits are collateralized with securities held by the State Treasurer's agent in the
name of the State Treasurer. Since the State Treasurer is acting in a fiduciary capacity for the ABC
Board, these deposits are considered to be held by the ABC Board's agent in the ABC Board's name.
The amount of the pledged collateral is based on an approved averaging method for non-interest-
bearing deposits and the actual current balance for interest bearing deposits. Depositories using the
Pooling Method report to the State Treasurer the adequacy of their pooled collateral covering
uninsured deposits. The State Treasurer does not confirm this information with the ABC Board or the
escrow agent. Because of the inability to measure the exact amount of collateral pledged for the ABC
Board under the Pooling Method, the potential exists for under collateralization, and this risk may
increase in periods of high cash flows. However, the State Treasurer of North Carolina enforces strict
standards of financial stability for each Pooling Method depository that collateralizes public deposits
under the Pooling Method.
The ABC Board has deposits in Pooling Method banks only.
Cash
For purposes of the statement of cash flows, the ABC Board considers all highly liquid investments,
with a maturity of three(3)months or less when purchased,to be cash.
Accounts Receivable
The amounts shown on the statement of net position for receivables is net of$0 allowance for doubtful
accounts. The direct write-off method for bad debts is used for financial reporting, which is not
materially different from the allowance method.
Inventories
Inventories are valued at the lower of cost(FIFO)or market and are summarized below,as of June 30:
2023 2022
Liquor in stores $ 2,905,144 $ 2,616,347
Liquor in warehouse 952,887 1,398,154
Wine 3,413 9,059
Bags 51,323 33,222
$ 3,912,767 $ 4,056,782 j
-17-
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES[cont'd]
Capital Assets
Capital assets are stated at cost and are being depreciated over their useful lives, on a straight-line
basis,as follows:
Buildings 25-50 years
Building improvements 10-15 years
Autos and trucks 5-7 years
Furniture,fixtures,and equipment 5-7 years
Leasehold improvements are depreciated over the term of the lease agreement.
Upon disposition of an asset, the cost of the asset and the related accumulated depreciation are
removed from the books.Any gain or loss on disposition is reflected in the earnings for the period.
Capital asset activity for the year ended June 30,2023,was as follows:
Beginning Ending
Balances Increases Decreases Balances
Capital Assets Not Being Depreciated
Land $ 1,951,041 $ $ --- $ 1,951,041
Construction in progress 1,769,975 1,769,975 ---
Total Capital Assets Not Being
Depreciated 3,721,016 $ $ 1,769,975 1,951,041
Capital Assets Being Depreciated
Buildings and improvements 7,965,939 $ 3,185,257 $ 221,996 10,929,200
Store fixtures and equipment 1,244,061 334,994 75,887 1,503,168
Warehouse fixtures and equipment 135,946 --- --- 135,946
Office furniture,fixtures,and equipment 296,381 5,949 --- 302,330
Leasehold improvements 232,407 15,474 --- 247,881
Motor vehicles 205,630 --- --- 205,630
Total Capital Assets Being
Depreciated 10,080,364 $ 3,541,675 $ 297,883 13,324,155
Less Accumulated Depreciation for:
Buildings and improvements 2,189,474 $ 45,125 $ 221,922 2,212,677
Store fixtures and equipment 1,098,758 110,681 74,133 1,135,306
Warehouse fixtures and equipment 120,811 16,011 --- 136,822
Office furniture,fixtures,and equipment 238,461 17,667 --- 256,128
Leasehold improvements 114,685 24,959 --- 139,644
Motor vehicles 181,888 9,074 190,962
Total Accumulated Depreciation 3,944,077 $ 423,517 $ 296,055 4,071,539
Total Capital Assets Being
Depreciated(Net) 6,136,287 9,252,616
Capital Assets,Net $ 9,857,303 $ 11,203,657
-18-
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES[cont'dj
G. Assets,Liabilities,and Net Position[cont'd]
Capital Assets[cont'd]
Capital asset activity for the year ended June 30,2022,was as follows:
Beginning Ending
Balances Increases Decreases Balances
Capital Assets Not Being Depreciated
Land $ 1,951,041 $ $ $ 1,951,041
Construction in progress 72,988 1,696,987 --- 1,769,975
Total Capital Assets Not Being
Depreciated 2,024,029 $ 1,696,987 $ --- 3,721,016
Capital Assets Being Depreciated
Buildings and improvements 7,965,939 $ --- $ --- 7,965,939
Store fixtures and equipment 1,241,111 2,950 --- 1,244,061
Warehouse fixtures and equipment 135,946 --- --- 135,946
Office furniture,fixtures,and equipment 281,292 15,089 --- 296,381
Leasehold improvements 232,407 --- --- 232,407
Motor vehicles 205,630 --- --- 205,630
Total Capital Assets Being
Depreciated 10,062,325 $ 18,039 $ --- 10,080,364
Less Accumulated Depreciation for:
Buildings and improvements 1,946,856 $ 242,618 $ 2,189,474
Store fixtures and equipment 988,482 110,276 --- 1,098,758
Warehouse fixtures and equipment 98,843 21,968 --- 120,811
Office furniture,fixtures and equipment 216,430 22,031 --- 238,461
Leasehold improvements 90,886 23,799 --- 114,685
Motor vehicles 161,269 20,619 --- 181,888
Total Accumulated Depreciation 3,502,766 $ 441,311 $ 1944,077
Total Capital Assets Being
Depreciated(Net) 6,559,559 6,136,287
Capital Assets,Net $ 8,583,588 $ 9,857,303
_19-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES[cont'd]
G. Assets,Liabilities,and Net Position[cont'd]
Net Position
Net position consists of the following:
1. Invested in capital assets, net of related debt — This component of net position consists of
capital assets, including any restricted capital assets, net of accumulated depreciation, and
reduced by the outstanding balances of any borrowings that are attributable to the acquisition,
construction, or improvement of those assets. If there are significant unspent related debt
proceeds at year end, the portion of the debt attributable to the unspent proceeds is not included
in the calculation of invested in capital assets,net of related debt. Rather,that portion of the debt
is included in the same net position component as the unspent proceeds. For the years ended
June 30, 2023 and 2022, the ABC Board had $8,548,978 and $7,688,904 invested in capital
assets,respectively.
2. Restricted for law enforcement—This applies only when the ABC Board employs its own ABC
officer.
3. Restricted for capital improvements —NC G.S.18B-805(d) requires approval of the appointing
authority to establish this account.
4. Restricted for working capital—North Carolina Alcoholic Beverage Control Commission Rule
.0902("Rule .0902")defines working capital as the total of cash,investments, and inventory less
all unsecured liabilities.An ABC board shall set its working capital requirements at not less than
two (2) weeks of average gross sales of the last fiscal year or greater than three (3) months of
average gross sales of the last fiscal year. Average gross sales means gross receipts from the sale
of alcoholic beverages less distributions required by NC G.S.1813-805(b), (2), (3), and (4). For
the years ended June 30,2023 and 2022, the ABC Board had$919,582 and $885,538 restricted
for working capital,respectively.
5. Unrestricted net position—This component of net position consists of net positions that do not
meet the definition of restricted or net investment in capital assets, net of related debt. For the
years ended June 30, 2023 and 2022, the ABC Board had $3,993,748 and $3,682,326 in
unrestricted net position,respectively.
H. Income Taxes
The ABC Board is a nonprofit governmental organization; accordingly, no income taxes have been
provided for in the accompanying financial statements.
I. Subsequent Events
Management has evaluated subsequent events through September 28, 2023, the date the financial
statements were available to be issued.
-20-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
2. STEWARDSHIP,COMPLIANCE,AND ACCOUNTABILITY
Compliance with NC General Statutes
The ABC Board noted no instances of noncompliance with NC General Statutes for the year ended June 30,
2023.
The ABC Board noted expenditures exceeding revenues by $663,148 in the Schedule of Revenues and
Expenditures—Budget and Actual as a result of the use of outside financing in the construction of a new store,
as well as the use of previously retained funds to pay off debt acquired in previous years.
3. DETAIL NOTES ON ALL FUNDS
Pension Plan Obligations
LGERS
Plan Description. The ABC Board is a participating employer in the statewide LGERS, a cost-sharing
multiple-employer defined benefit pension plan administered by the State of North Carolina. LGERS
membership is comprised of general employees and local law enforcement officers ("LEOs") of participating
local governmental entities. Article 3 of NC G.S. Chapter 128 assigns the authority to establish and amend
benefit provisions to the North Carolina General Assembly. Management of the plan is vested in the LGERS
Board of Trustees, which consists of thirteen (13) members — nine (9) appointed by the Governor, one
appointed by the State Senate, one appointed by the State House of Representatives, and the State Treasurer
and State Superintendent, who serve as ex-officio members. The LGERS is included in the Comprehensive
Annual Financial Report ("CAFR") for the State of North Carolina. The State's CAFR includes financial
statements and required supplementary information for LGERS, and that report may be obtained by writing to
the Off-ice of the State Controller 1410 Mail Service Center, Raleigh, NC 27699-1410, by calling (919) 981-
5454,or at www.osc.ne.eov.
Benefits Provided. LGERS provides retirement and survivor benefits. Retirement benefits are determined as
1.85% of the member's average final compensation times the member's years of creditable service. A
member's average final compensation is calculated as the average of a member's four (4)highest consecutive
years of compensation. Plan members are eligible to retire with full retirement benefits at age sixty-five (65)
with five (5) years of creditable service, at age sixty(60)with twenty-five (25)years of creditable service, or
at any age with thirty (30) years of creditable service. Plan members are eligible to retire with partial
retirement benefits at age fifty(50)with twenty (20)years of creditable service or at age sixty(60)with five
(5) years of creditable service. Survivor benefits are available to eligible beneficiaries of members who die
while in active service or within one hundred and eighty(180) days of their last day of service and who have
either completed twenty(20)years of creditable service regardless of age, or have completed five (5) years of
service and have reached age sixty (60). Eligible beneficiaries may elect to receive a monthly Survivor's
Alternate Benefit for life or a return of the member's contributions. The plan does not provide for automatic
post-retirement benefit increases.Increases are contingent upon actuarial gains of the plan.
ii
-21-
il
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
3. DETAIL NOTES ON ALL FUNDS[cont'dj
Pension Plan Obligations[cont'd]
LGERS[cont'df
LGERS plan members who are LEOs are eligible to retire with full retirement benefits at age fifty-five (55)
with five (5)years of creditable service as an officer, or at any age with thirty(30)years of creditable service.
LEO plan members are eligible to retire with partial retirement benefits at age fifty(50)with fifteen(15)years
of creditable service as an officer. Survivor benefits are available to eligible beneficiaries of LEO members
who die while in active service or within one hundred and eighty(180) days of their last day of service and
who also have either completed twenty (20)years of creditable service regardless of age, or have completed
fifteen (15)years of service as an LEO and have reached age fifty-five (55), or have completed fifteen (15)
years of creditable service as an LEO if killed in the line of duty. Eligible beneficiaries may elect to receive a
monthly Survivor's Alternate Benefit for life,or a return of the member's contributions.
Contributions. Contribution provisions are established by NC G.S. 128-30 and may be amended only by the
North Carolina General Assembly. The ABC Board employees are required to contribute 6% of their
compensation. Employer contributions are actuarially determined and set annually by the LGERS Board of
Trustees. The ABC Board's contractually required contribution rate for the years ended June 30, 2023 and
2022,was 8.01% of compensation for law enforcement officers and 8.00% for general employees, actuarially
determined as an amount that,when combined with employee contributions,is expected to finance the costs of
benefits earned by employees during the year. Contributions to the pension plan from the ABC Board for the
years ended June 30,2023 and 2022,were$254,559 and$201,166,respectively.
Refunds of Contributions. ABC Board employees, who have terminated service as a contributing member of
LGERS,may file an application for a refund of their contributions. By state law, refunds to members with at
least five (5) years of service include 4% interest. State law requires a sixty (60)-day waiting period after
service termination before the refund may be paid. The acceptance of a refund payment cancels the
individual's right to employer contributions,or any other benefit provided by LGERS.
Pension Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of
Resources Related to Pensions
At June 30, 2023, the ABC Board reported a liability of$1,413,742 for its proportionate share of the net
pension liability. The net pension liability was measured as of June 30, 2022. The total pension liability used
to calculate the net pension liability was determined by an actuarial valuation as of December 31, 2019. The
total pension liability was then rolled forward to the measurement date of June 30, 2022, utilizing updated
procedures incorporating the actuarial assumptions. The ABC Board's proportion of the net pension liability
was based on a projection of the ABC Board's long-term share of Future payroll covered by the pension plan,
relative to the projected future payroll covered by the pension plan of all participating LGERS employers,
actuarially determined. At June 30, 2023,the ABC Board's proportion was 0.02506%, which was an increase
of 0.00136%from its proportion measured as of June 30,2022.
j
-22-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
3. DETAIL NOTES ON ALL FUNDS[cont'd]
Pension Plan Obligations[cont'd]
Pension Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of
Resources Related to Pensions[cont'd]
For the year ended June 30, 2023,the ABC Board recognized pension expense of$387,900. At June 30, 2023,
the ABC Board reported deferred outflows of resources and deferred inflows of resources related to pensions
from the following sources:
Deferred Deferred
Outflows of Inflows of
Resources Resources
Differences between expected and actual experience $ 60,917 $ 5,973
Changes of assumptions 141,060
Net difference between projected and actual earnings on pension
plan investments 467,256 ---
Changes in proportion and differences between ABC Board
contributions and proportionate share of contributions 8,375 13,748
ABC Board's contributions subsequent to the measurement date 254,559
Total $ 932,167 $ 19,721
A net amount of$932,167,reported as deferred outflows of resources related to pensions resulting from ABC
Board contributions,subsequent to the measurement date,will be recognized as a decrease of the net pension
liability in the year ended June 30, 2023. Other amounts repotted as deferred inflows of resources related to
pensions will be recognized in pension expense as follows:
Year Ending June 30:
2024 $ 200,121
179,766
2026
2027 55,390
222,610
Total $ 657,887
Actuarial Assumptions. The total pension liability in the December 31, 2020 actuarial valuation was
determined using the following actuarial assumptions,applied to all periods included in the measurement:
Inflation 3.0%
Salary increases 3.50%to 8.10%,including inflation and productivity factor
Investment rate of return 7.00%,net of pension plan investment expense,including inflation
I
23
i
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
3. DETAIL NOTES ON ALL FUNDS[cont'd]
Pension Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of
Resources Related to Pensions[cont'd]
The plan currently uses mortality tables that vary by age, gender, employee group (i.e., general, law
enforcement officer), and health status (i.e., disabled and healthy). The current mortality rates are based on
published tables and based on studies that cover significant portions of the U.S. population. The healthy
mortality rates also contain a provision to reflect future mortality improvements.
Valuations were based on the results of an actuarial experience study for the period of January 1,2014 through
December 31,2020.
Future ad hoc COLA amounts are not considered to be substantively automatic and are,therefore,not included
in the measurement.
The projected long-term investment returns and inflation assumptions are developed through review of current
and historical capital markets data, sell-side investment research, consultant whitepapers, and historical
performance of investment strategies. Fixed income return projections reflect current yields across the U.S.
Treasury yield curve and market expectations of forward yields projected and interpolated for multiple tenors
and over multiple year horizons. Global public equity return projections are established through analysis of the
equity risk premium and the fixed income return projections. Other asset categories and strategies return
projections reflect the foregoing and historical data analysis. These projections are combined to produce the
long-term expected rate of return by weighting the expected future real rates of return by the target asset
allocation percentage and by adding expected inflation. The target allocation and best estimates of arithmetic
real rates of return for each major asset class,as of June 30,2023,are summarized in the following table:
Long-Term Expected
Asset Class Target Allocation Real Rate of Return
Fixed Income 29.0% 1.4%
Global Equity 42.0% 5.3%
Real Estate 8.0% 4.3%
Alternatives 8.0% 8.9%
Credit 7.0% 6.0%
Inflation Protection 6.0% 4.0%
Total 100.0%
The information above is based on thirty (30)-year expectations developed with the consulting actuary for the
2018 asset liability and investment policy study for the North Carolina Retirement Systems,including LGERS.
The long-term nominal rates of return underlying the real rates of return are arithmetic annualized figures. The
real rates of return are calculated from nominal rates by multiplicatively subtracting a long-term inflation
assumption of 3.00%.All rates of return and inflation are annualized.
�I
i
-24-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
3. DETAIL NOTES ON ALL FUNDS[cont'df
Pension Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of
Resources Related to Pensions[cont'd]
Discount Rate. The discount rate used to measure the total pension liability was 6.50%.The projection of cash
flows used to determine the discount rate assumed that contributions from plan members will be made at the
current contribution rate and that contributions from employers will be made at statutorily required rates,
actuarially determined. Based on these assumptions,the pension plan's fiduciary net position was projected to
be available to make all projected future benefit payments of the current plan members. Therefore, the long-
term expected rate of return on pension plan investments was applied to all periods of projected benefit
payments to determine the total pension liability.
Sensitivity of the ABC Board's Proportionate Share of the Net Pension Liability to Changes in the Discount
Rate. The following presents the ABC Board's proportionate share of the net pension asset calculated using
the discount rate of 6.50%,as well as what the ABC Board's proportionate share of the net pension asset or net
pension liability would be if it were calculated using a discount rate that is one percentage point lower
(5.50%),or one percentage point higher(7.50%),than the current rate:
1%Decrease Discount Rate I%Increase
(5.50%) (6.50%) (7.50%)
ABC Board's proportionate share of the
net pension liability (asset) $ 2,551,622 $ 1,413,742 $ 476,063
Pension Plan Fiduciary Net Position. Detailed information about the pension plan's fiduciary net position is
available in the separately issued CAFR for the State of North Carolina.
Death Benefits
The ABC Board has also elected to provide death benefits to employees through the LGERS Death Benefit
Plan("the Death Benefit Plan") and is a multiple-employer, state-administered, cost-sharing plan funded on a
one year term cost basis. The beneficiaries of those die employees who i p y e in active service after one year of
contributing membership in LGERS, or who die within one hundred and eighty(180) days after retirement or
termination of service and have at least one year of contributing membership service in LGERS at the time of
death, are eligible for death benefits. Lump sum death benefit payments to beneficiaries are equal to the
employee's twelve (12) highest months of salary in a row during the twenty-four (24) months prior to the
employee's death,but the benefit may not exceed$50,000,or be less than$25,000.All death benefit payments
are made from the Death Benefit Plan. The ABC Board has no liability beyond the payment of monthly
contributions. The contributions to the Death Benefit Plan cannot be separated between the post-employment
benefit amount and the other benefit amount.The ABC Board considers these contributions to be immaterial.
The ABC Board also provides additional group-term life insurance coverage in the amount of$20,000 to its
full-time employees.
I
25
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
i
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
3. DETAIL NOTES ON ALL FUNDS[cont'd]
Significant Lease Transactions
The ABC Board entered into a lease agreement with Rams Plaza Associates, LLC to lease facilities at Rams
Plaza. The lease became effective June 23, 2016, and expires on June 30, 2026, with the option for two (2)
additional five (5)-year periods. The lease calls for lease payments of$7,746 per month for the first five (5)
years, and lease payments of$8,520 per month for the remaining five (5)years. The ABC Board had a lease
agreement with Inland Mid-Atlantic, LLC to lease facilities at Meadowmont Village. The lease expired on
April 30, 2021. The lease was renewed for another five (5)years expiring April 30, 2026. The lease calls for
lease payments of$5,192 per month for the first year, with subsequent annual increases thereafter. The ABC
Board entered into a lease agreement with SV Center, LLC to lease facilities at Southern Village. The lease
became effective October 13, 2021, and expires on October 13, 2031. The lease calls for lease payments of
$8,030 per month for the first five (5) years, and lease payments of$9,090 per month for the remaining five
(5)years.
Lease assets and liabilities for the year ended June 30,2022 consisted of the following:
Beginning Modifications& End of
of Year Additions Remeasurements Subtractions Year
Building $ 2,053,336 $ $ 59,492 $ $ 2,112,828
Accumulated
amortization (216,382) (234,428) --- --- (450,810)
Total Lease Assets,
net $ 1,836,954 $ (234,428) $ 59,492 $ --- $ 1,662,018
Lease Liabilities $ 1,912,854 $ $ $ (112,153) $ 1,800,701
Lease expense for the year-ended June 30,2023 consisted of the following:
Amortization expense—building $ 235,521
Interest on lease liabilities 45,527
Variable lease expense
51,603
Total $ 332,651
i,
-26-
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
3. DETAIL NOTES ON ALL FUNDS[cont'd]
Significant Lease Transactions[cont'd]
Lease payments under present arrangements are as follows:
Total
Year Ending June 30: Principal Interest Payments
2024 $ 224,276 $ 40,764 $ 265,040
2025 231,734 35,300 267,034
2026 227,381 29,666 257,047
2027 173,692 24,913 198,605
2028 189,574 20,599 210,173
Thereafter 754,044 35,124 789,168
Total $ 1,800,701 $ 186,366 $ 1,987,067
Vacation and Sick Leave Compensation
ABC Board employees hired prior to July 1, 1997, may accumulate up to twenty-four (24) days of earned
vacation;employees hired on or after July 1, 1997, may accumulate up to twenty(20)days of earned vacation
and such leave is fully vested when earned. Accrued vacation, as of June 30, 2023 and 2022, amounted to
$73,388 and$53,790,respectively.
Employees can accumulate an unlimited amount of sick leave. Sick leave does not vest, but unused sick leave
accumulated at the time of retirement may be used in the determination of length of service for retirement
benefit purposes. Since the ABC Board has no obligation for accumulated sick leave until it is actually taken,
no accrual for sick leave has been made.
4. DISTRIBUTIONS OF INCOME
NC G.S. 18B-805(e)requires that the minimum distribution set aside in(c)(i),plus any profit remaining after
deducting amounts required for law enforcement, education, and retaining proper working capital, be paid
quarterly to the City and County units. There is a verbal agreement with Orange County to distribute$500,000
for the years June 30,2023 and 2022. The agreement allows for an additional distribution, at the discretion of
the ABC Board, based on profits estimated through year end. Consideration is given to a pending capital
outlay for construction in progress, capital improvements, longevity pay, payroll wage increases, and other
financial obligations of the ABC Board. Any possible additional distribution is paid in June. Actual profit
withheld by the ABC Board for the years ended June 30, 2023 and 2022, was $1,205,540 and $1,953,913,
respectively. This is to increase net assets for anticipated capital improvements, construction-in-progress, and
reserve for longevity pay and contingencies as allowed by the state as follows:
-27-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
4. DISTRIBUTIONS OF INCOME[cont'd]
2023 2022
Net income before profit distribution $ 1,905,540 $ 2,483,913
Less:amount retained for capital improvements,construction-in-
progress,and reserve for longevity pay and contingencies 1,205,540 1,953,913
Amount Distributed to Orange County $ 700,000 $ 530,000
The ABC Board made distributions to Orange County for the years ended June 30, 2023 and 2022, in the
amounts of$700,000 and$530,000,respectively.
5. LAW ENFORCEMENT AND ALCOHOL EDUCATION EXPENSES
The ABC Board is required by law to expend not less than 5% of its profits for law enforcement and not less
than 7% of its profits for education on the excessive use of alcoholic beverages and for rehabilitation of
alcoholics. Profits are defined by law for these calculations as change in net position before law enforcement
and educational expenses, less the 3-1/2% markup provided in NC G.S. I8B-804(b)(5) and the bottle charge
provided for in NC G.S. 18B-804(b)(6b).
2023 2022
Income before required distributions $ 2,325,540 $ 2,886,913
Less: 3-1/2%tax and bottle charge 865,571 835,384
Profit subject to expense percentages $ 1,459,969 $ 2,051,529
Law enforcement expenses $ 168,000 $ 166,000
Percentage of profit 11.5% 8.1%
Minimum authorized 72,998 102,576
Alcohol education and rehabilitation expenses $ 252,000 $ 237,000
Percentage of profit 17.3% 11.6%
Minimum authorized 102,198 143,607
6. DISBURSEMENT OF TAXES INCLUDED IN SELLING PRICE
i
A state excise tax, at the rate of 30% on the retail (net sales) price, is charged monthly on liquor sales
(excluding wine sales). Transactions for this account for the years ended June 30, 2023 and 2022, are
summarized as follows:
2023 2022
Taxes payable,July 1,2022 and 2021 $ 504,026 $ 490,891
Taxes collected during the years ended June 30,2023 and 2022 6,760,808 6,509,663
Taxes remitted to NC Department of Revenue 6,723,700 6,496,528
Taxes Payable $ 541,134 $ 504,026
I
28
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
6. DISBURSEMENT OF TAXES INCLUDED IN SELLING PRICE[eont'd]
The excise tax is computed in accordance with NC G.S. 18B-805(i).
The accrued North Carolina excise tax at June 30, 2023, was remitted to the North Carolina Department of
Revenue on July 3,2023.
A bottle charge of one cent($.01)on each bottle containing fifty(50)milliliters or less and five cents($.05)on
each bottle containing more than fifty (50) milliliters is collected and distributed monthly to the Orange
County commissioners for alcohol education or rehabilitation. Payments to Orange County were based on the
following bottle sales for the years ended June 30,2023 and 2022:
2023 2022
Bottles Amount Bottles Amount
Regular 980,930 @ 50= $ 49,046 987,734 @ 5¢= $ 49,387
Mixed beverage 201,755 @ 5¢= 10,088 198,934 @ 50= 9,947
Miniature 838,203 @ 10= 8,382 784,584 @ 1¢= 7,847
Total Payment for Yr. $ 67,516 $ 67,181
A "mixed beverage tax" at the rate of$20 per four (4) liters is charged on the sale of liquor to be resold as
mixed beverages. 50%of the mixed beverage tax is submitted monthly to the NC Department of Revenue. 5%
of the mixed beverage tax is submitted monthly to the NC Department of Human Resources.
Revenue from mixed beverage tax and the state's share of mixed beverage surcharge is included in mixed
beverage sales for the years ended June 30,2023 and 2022,as follows:
2023 2022
State's share of mixed beverage surcharge $ 393,894 $ 370,920
5%of mixed beverage tax 39,389 37,092
45%of profit retained 354,505 333,829
Total Revenue from Mixed Beverage Tax $ 787,788 $ 741,840
7. SURCHARGE COLLECTED
The total amount of surcharge collected for the years ended June 30, 2023 and 2022, was $162,521 and
$164,881,respectively.The bailment surcharge rate is$2.75 per case.
8. LIQUOR SALES TAX
The total amount of sales tax collected by the ABC Board and remitted to the NC Department of Revenue for
the years ended June 30,2023 and 2022, was $1,824,060 and $1,781,274,respectively. The current sales tax
rate is 7%.
_29_
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
9• WORKING CAPITAL REQUIREMENTS
The ABC Board is required by Rule .0902 to set its working capital requirements at not less than two (2)
weeks of average gross sales of the latest fiscal year. Gross sales are gross receipts from the sale of alcoholic
beverages,less distributions,as defined in NC G.S. 1813-805(b)(2), (3),and(4).
The ABC Board's position on this requirement is as follows:
2023 2022
Minimum amount $ 919,582
Actual working capital $ 885,538
Maximum amount 4,139,142 4,205,505
5,977,283 5,755,994
The ABC Board has met the minimum amount of working capital required by ABC law.
10. LAW ENFORCEMENT EXPENSE
All law enforcement activities are performed by the Orange County Sheriff Department, the Town of Chapel
Hill Police Department, the Town of Carrbom Police Department, the Town of Hillsborough Police
Department, and the UNC Police Department. Expense for the years ended June 30, 2023 and 2022, was
$168,000 and$166,000,respectively.
It. BREAKAGE
Breakage expense for the years ended June 30,2023 and 2022,was$12,685 and$10,930,respectively.
12. DEPRECIATION EXPENSE
Depreciation expense for the years ended June 30,2023 and 2022, was $423,518 and$441,312, respective The expense is summarized as follows: ly.
2023 2022
Store selling expenses $ 321,718
Warehouse and delivery expenses $ 317,630
Administrative expenses 61,496 79,770
40,304 43,912
$ 423,518 $ 441,312
I
13. INTEREST EXPENSE
Interest expense for the years ended June 30,2023 and 2022,was$60,793 and$87,726,respectively.
i
i
-30
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
14. NOTESPAYABLE
Notes payable consists of the following at June 30,2023 and 2022:
2023 2022
BB&T—Governmental Finance—note payable, interest at
3.15%;payable in monthly installments of$9,075 including
interest; secured by deed of trust on real property and
construction thereon, located at 251 Perkins Drive, Chapel
Hill, NC. Paid off during year ended June 30, 2023 with
previously retained funds. $ $ 668,735
First Horizon Bank—note payable, interest at 2.4%; interest
only payments until March 2023, then payable in monthly
installments of$18,002 including interest; secured by deed
of trust on land located on Highway 70 West in Mebane,
NC. 2,654,679 1,499,664
2,654,679 2,168,399
Less:current portion 154,002 139,524
$ 2,500,677 $ 2,028,875
Current maturities of noncurrent liability are as follows:
Year Ending June 30: Amount
2024 $ 154,002
2025 157,739
2026 161,566
2027 165,487
2028 169,503
2029 and thereafter 1,846,382
$ 2,654,679
15. OTHER POST-EMPLOYMENT BENEFITS
Plan Description
The ABC Board administers a single-employer defined benefit healthcare plan("the Retiree Healthcare Plan")'
The Retiree Healthcare Plan provides healthcare coverage for qualified retired employees as provided by the
ABC Board Policies and Procedures Manual.
i
i,
-31
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
15. OTHER POST-EMPLOYMENT BENEFITS[cont'd]
Funding Policy
The payment requirement for this coverage is based on the insurance premium rates charged by the insurance
provider for the ABC Board and is paid in full for the benefit of all qualified retired employees.
Annual OPEB Cost and Net OPEB Obligations
The ABC Board's beginning OPEB liability of $901,484 was measured, as of June 30, 2022, and was
determined by an actuarial valuation as of that date.
Actuarial assumptions and other inputs.The total OPEB liability in the June 30,2023 actuarial valuation was
determined using the following actuarial assumptions and other inputs, applied to all periods included in the
measurement unless otherwise specified:
Inflation 2.50%
Salary increases Discount rate 3.250/ 8.41%,including inflation
3 25%
Healthcare cost trend rates Medical-7.00%
The discount rate is based on the yield of the S&P Municipal Bond 20-Year High Grade Rate Index, as of the
measurement date.
i
Changes in the Total OPEB Liability
Total OPEB
Liability
Balance at July 1,2022 $ 901,484
Changes for the year:
Service cost
Interest 15,436
Changes of benefit terms 27,667
Differences between expected and actual experience (11,235)
Changes in assumptions or other inputs 23,376
Benefit payments (101,203)
376
Net changes (45,959)
Balance at June 30,2023 $ 855,525
Mortality rates were based on the RP-2014 Total Data Set for Healthy Annuitants Mortality Table.
I
As of June 30,2023 and 2022,the ABC Board's OPEB plan fiduciary net position and the net OPEB liability
were$409,807 and$355,428,respectively.
i
_32_ ,
i
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
Jun
e 30 202
3 and 2022
15. OTHER POST-EMPLOYMENT BENEFITS[cont'd]
Changes in the Total OPEB Liability
The actuarial assumptions used in the June 30, 2023 valuation were based on the results of an actuarial
experience study for the period January 2015 through December 2019.
Sensitivity of the total OPEB liability to changes in the discount rate. The following presents the total OPEB
liability of the ABC Board at June 30,2023,as well as what the ABC Board's total OPEB liability would have
been if it were calculated using the discount rate that is one percentage point lower(2.25%), or one percentage
point higher(4.25%),than the current discount rate:
1%Decrease Discount Rate 3.25%) 1%Increase
Net OPEB liability $514,756 $445,718 $384,585
Sensitivity of the total OPEB liability to changes in the healthcare cost trend rates. The following presents
the total OPEB liability of the ABC Board at June 30, 2023, as well as what the ABC Board's total OPEB
liability would have been if it were calculated using healthcare cost trend rates that are one percentage point
lower than,or one percentage point higher than,the current healthcare cost trend rates:
1%Decrease Current 1%Increase
Net OPEB liabili $376,005 $445,718 $525,040
Expense and Deferred Outflows of Resources and Deferred Inflows of Resources Related to OPEB
For the year ended June 30, 2023, the ABC Board recognized OPEB expense of$157,047.At June 30, 2023,
the ABC Board reported deferred outflows of resources and deferred inflows of resources related to OPEB
from the following sources:
i
Deferred Deferred
Outflows of Inflows of
Resources Resources
Difference between expected and actual experience p $ 70,631 $ 303,416
Changes of assumptions 25,550
Benefit payments and administrative costs made
subsequent to the measurement date 21,557 ---
Total $ 117,738 $ 303,416
i
-33-
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
NOTES TO FINANCIAL STATEMENTS
June 30,2023 and 2022
15. OTHER POST-EMPLOYMENT BENEFITS[cont'd]
Amounts reported as deferred inflows of resources related to pensions will be recognized in OPEB expense as
follows:
Year Ending June 30:
2024 $ (34,392)
2025
2026 (70,443)
(87,628)
2027 4,954
2028 1,831
Total $' (185,678)
16. RISI{MANAGEMENT
The ABC Board,is exposed to various risks of loss related to torts; theft of, damage to, and destruction of
assets; errors and omissions; injuries to employees; and natural disasters. The ABC Board has property,
general liability, auto liability,workmen's compensation, and employee health coverage. In addition,the ABC
Board has liquor legal liability.
In accordance with NC G.S. 1813-700(i), the ABC Board's insurance policies provide public official blanket
bond coverage of$50,000 for each ABC Board member and blanket protection of$50,000 for employees
designated as the general manager and finance officer.
There have been no significant reductions in insurance coverage from coverage in the prior year and settled
claims have not exceeded coverage in any of the past three(3)fiscal years.
17. ACCOUNTING PROVISION RECENTLY ADOPTED
In June 2017, the Governmental Accounting Standards Board ("GASB") issued a new lease accounting
standard, GASB 87, to more accurately portray lease obligations and increase the usefulness of governmental
financial statements. Under this standard, the ABC Board is required to evaluate leases and recognize a lease
asset and liability for each lease meeting certain criteria.The ABC Board adopted this standard on July 1,2021
using the modified retrospective approach.
In May 2020,the GASB issued a new accounting standard,GASB 96,to more accurately portray subscription-
based information technology arrangements("SBITAs")and increase the usefulness of governmental financial
statements. Under this standard, the ABC Board is required to evaluate information technology software
currently being used and recognize a subscription liability and an intangible asset representing the ABC
Board's right to use the subscription asset. The standard provides an exception for short-term SBITAs with a
maximum possible term of twelve(12)months or less. The ABC Board adopted this standard during the year-
ended June 30,2023,and did not have any SBITAs requiring transition.
I
i
-34-
i
REQUIRED SUPPLEMENTARY INFORMATION
i
I
j
if
i
-35-
e
� 00 h ip c M
N
� o ry
Yf f9
b
O � _
FA fA
e
Vt O W e e
O
69 V
� O pO h O 01
V3 69
v
Iri Y F� lO-I M F 64 69
W 'o
W a
c W
O
U o � F
u a
e
W ry VV� N M a 6 4R
O W o lA Vi
N
69 69
I
o o o '
a
ri
' N
U 10
N N N
o
a
rn � o
N N
' on
N N
69 69 69
b W n
N M
� Fig H3
l I
W oMp 7 �
A M
p� F9 49 V3
N O O 00 e
a „ z
o d o M N FA
a FW z
U '7' N N O r
W W v�i v�i M r
o �"
� V3 Y3
au
a i-r N N
b
R rOT�
N ~ C M
Q NO N N r
Q ✓� 6A 69 69 ,
In U1 VM1 i0 O
Ci
N N N
A FR 6N9 i
F
O 'F
p O y T
F A
i
i
Schedule 3
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
OTHER POST-EMPLOYMENT BENEFITS
REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULES OF CHANGES IN THE TOTAL
OPEB LIABILITY AND RELATED RATIOS
2023 2022
Total OPEB Liability
Service cost $ 15,436 $ 14,949
Interest 27,667 29,325
Changes of benefit terms -
Differences between expected and
actual experience (11,235) 2,682
Changes of assumptions 23,376 -
Benefit payments (101,203) (94,771
Net Change in Total OPEB Liability (45,959) (47,815)
Total OPEB Liability,beginning 901,484 949,299
Total OPEB Liability,ending 855,525 901,484
Plan Fiduciary Net Position
Contributions-employer 162,149 138,149
Net investment income 158 153
Benefit payments 101,203( ) (94,771)
Administrative expense (6,725)
Net Change in Plan Fiduciary
Net Position 54,379 36,806
Plan Fiduciary Net Position,beginning 355,428 318,622
Plan Fiduciary Net Position,ending 409,807 355,428
Net OPEB Liability,ending $ 445,718 $ 546,056
Covered Payroll $ 1,829,075 $ 1,405,218
Total OPEB Liability as a Percentage
of Covered Payroll 24.37% 38.86%
Notes to Schedule:
Fiscal Year Rate
Changes of assumptions and other inputs reflect the effects of changes
in the discount rate of the period 2023 3.25%
2022 3.25%
See auditor's report.
i
-38-
SUPPLEMENTARY INFORMATION 71
-39-
ORANGE COUNTY ABC BOARD —AGENDA FORM
Meeting Date: October 17, 2023 Agenda Item # 4
Regular Session X
Closed Session_
Presenter/Information Contact: Ron McCoy
Subject: Audited Financial Statements for Fiscal Year 2023
Attachment(s):
1. Attachment: Audit for Fiscal Year Ending 2023 (sent separately)
2. Attachment: Auditor's Letter, dated September 28, 2023
3. Attachment: Statement of Revenues, Expenses and Changes in Net Assets (2023)
PRESENTATION: Mason Barringer, auditor(DMJPS)
Brief Summary/Explanations:
The audit for the fiscal year ending 06/30/2023 was conducted by the auditing firm of
Davenport, Marvin, Joyce, Price and Sprinkle (DMJPS) with Mason Barringer as lead auditor. The
completion of the audit was delayed by late reporting of OPEB calculations performed by Cavanaugh
MacDonald, the Board's long-time actuarial firm. However, DMJPS was able to submit the audit to
the NC ABC Commission in time to comply with the mandatory 09/30 reporting deadline.
Highlights:
• Working capital (current assets less current liabilities) decreased by 14.18% over the
prior year. Current assets ($7,777,839) decreased -$214,083 while current liabilities
($3,400,630) increased $508,963, due primarily to the allocated net pension liability
(state retirement) ($1,413,742, +$1,050,280) (pages 4 & 10).
• Approximately 11.5%of profits were expended for law enforcement(5%required)and
17.3% for alcohol education/rehabilitation 7%required)( (pages 4 &28)
• Assets exceeded liabilities by $13,462,308, up from$12,256,768 in 2023 (page 5).
• Sales revenues of$31,208,975, up 3.86% from 2022, were the highest in the Board's
history(page 6).
• Total bottles sold in 2023 (2,020,888) was up 49,366 (2.50%) (page 6).
• The Board invested$1,851,306 in capital assets for the completion of the Mebane store
and furniture,fixtures and equipment related to the Mebane and Southern Village stores
(page 7).
• Notes payable ($2,654,679) increased $486,280 (22.43%), due primarily to inventory
growth related to the new stores (page 8).
• Net position increased$1,205,540, down-$748,373 (38.30%) from the previous
year's unusually high ($1,953,913) growth, due primarily to the Board's decisions to
pay off the BB&T/Truist debt and finance only the money necessary to pay the
builder for the construction of Store 004. All other expenses for Store 004 -furniture,
fixtures, equipment, architect, engineering,permits etc.-were paid by the Board using
retained earnings from previous fiscal years. (page 12).
Page 1 of 7 pages
ORANGE COUNTY ABC BOARD—AGENDA FORM
Meeting Date: October 17, 2023 Agenda Item# 4
Regular Session X
Closed Session
Notes:
• The format of the "Schedule of Revenue and Expenditures-Budget and Actual" (the year-
end budget reconciliation) (page 51) does not allow for the inclusion of"outside" funding
resources including capital funds received from debt service and fiends retained in prior
fiscal years. As a result, the report shows a deficit of expenditures over revenues of
-$663.148.
The auditor addresses this issue in Note 2 ("Stewardship, Compliance and
Accountability") (page21). The auditor mentions the outside financing received for the
construction of the new Mebane store as well as the Board's decision to use retained
funds from previous years to satisfy the outstanding debt on the Chapel Hill North store
(page 21).
The auditor further elaborates on this matter in Note 14 ("Notes Payable"), detailing the
payoff of the BB&T/Truist loan using previously retained funds.
• In previous years, the Board has voted to deposit unrestricted working capital
retained/retained earnings/change in net position revenues from the previous year
($1,205,540 for fiscal year 2023) in a separate bank account, segregated from operational
funds. Separating these funds allowed the Board to determine the availability of funds
necessary to satisfy debt service and ongoing capital investments.
Currently,a balance of$391,837 remains in this account(Roxboro Savings).As the Board
is investigating new banking options, should the Board elect to segregate the 2023 retained
earnings as usual,the relocation of these funds may be delayed until final banking decisions
are made.
Action Requested:
1. Review and discuss as needed.
2. Motion to approve the audited financial statements as prepared.
3. Discuss potential segregation of retained earnings from FY 2023. Vote as needed.
Financial Impact: See Above
Staff Recommendations/Comments: See Above.
Page 2 of 7 pages
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULE OF REVENUES AND EXPENSES BY STORES
Year Ended June 30,2023
(With Comparative Totals for Year Ended June 30,2022)
2023
Store#1 Store#3
Highway Store#2 Chapel Hill Store#4
70 West Rams Plaza North Mebane
Liquor sales $ 2,035,017 $ 4,718,135 $ 3,421,890 $ 2,688,321
Mixed beverage sales - 3,130,273 9,429 13,665
Wine sales 2,619 7,330 4,772 2,116
Total Gross Sales 2,037,636 7,855,738 L,436,091 2,704,102
Less: Taxes Based on Gross Sales:
State's share of mixed
beverage surcharge - 257,885 908 1,374
State excise 452,266 1,631,576 763,455 600,128
Mixed beverage - 25,789 91 137
Rehabilitation 5,340 16,589 7,109 6,745
Total Tax 457,606 1,931,839 771,563 608,384
Net Sales 1,580,030 5,923,899 1,664,528 1,095,718
Cost of Sales:
Liquor 1,074,601 3,908,143 1,818,456 1,413,712
wine 1,326 . 3 723 2,433 1,065
i
Total Cost of Sales 1,075,927 3,911,866 1,820,889 1,414,777
Gross Profit 504,103 2,012,033 843,639 680,941
Store Selling Expenses 295,161 800,427 491,709 379,232
i
Selling Profit $ 208,942 $ 1,211,606 $ 351,930 $ 301,709
I
i
l
See auditor's report.
I
-40-
Schedule 4
i
2023
Store#10
Store 46 Store#8 Granville
Store#5 Groucho Rd./ Store#7 Southern Centre/
Meadowmont Durham Carrboro Village Oakdale 2023 2022
$ 2,130,457 $ 1,535,854 $ 4,486,691 $ 639,016 $4,390,050 $26,045,431 $25,433,649
170,805 - 965,629 8,933 826,573 5,125,307 4,575,182
4,077 2,194 6,659 2,323 6,147 38,237 41,249
2,305,339 1,538,048 5,458,979 650,272 5,222,770 31,208,975 30,050,080
10,128 - 71,805 596 51,198 393,894 370,920
507,826 341,543 1,181,158 144,117 1,138,739 6,760,808 6,509,663
1,013 - 7,179 60 5,120 39,389 37,092
4,454 3,725 11,941 1,175 10,438 67,516 67,181
523,421 345,268 1,272,083 145,948 1,205,495 7,261,607 6,984,856
1,781,918 1,192,780 4,186,896 504,324 4,017,275 23,947,368 23,065,224
1,205,155 809,994 2,811,301 323,914 2,718,467 16,083,743 15,463,933
2,091 1,113 3,367 1,183 3,133 19,434 21,061
1,207,246 811,107 2,814,668 325,097 2,721,600 16,103,177 15,484,994
574,672 381,673 1,372,228 179,227 1,295,675 7,844,191 7,580,230
303,149 237,924 584,671 212,335 591,306 3,895,914 3,265,214
$ 271,523 $ 143,749 $ 787,557 $ (33,108) $ 704,369 $ 3,948,277 $ 4,315,016
-41-
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULE OF STORE SELLING EXPENSES
Year Ended June 30,2023
(With Comparative Totals for Year Ended Tune 30,2022)
2023
Store#1 Store#3
Highway Store#2 Chapel Hill Store#4
70 West Rams Plaza North Mebane
Salaries and wages $ 143,493 $ 355,488 $ 194,664
$ 181,452
Cash shortage(gain) 123 (1,218) 51
(222)
j Store supplies 15,691 29,691
23,193 25,173
Exterior maintenance services 2,028 1,041
4,657 2,028
Depreciation 11,853 43,793
62,779 21,263
Repairs and maintenance 16,013 18,709
13,389 11,113
Burglar alarm and security expense 480 480
960 480
Telephone 493 493
493 493
Internet service 1,838 2,315
1,353 1,162
Employees'retirement and
payroll taxes 37,528
86,790 50,122 41,467
Rent - 37,632 -
Utilities 7 678 -
8,625 8,133 7,970
Group insurance 21,993 64,566 54,289
32,078
General insurance 4,420 11,234
10,060 4,939
Licenses and taxes _
- 142
Service charges 31,326 121,375
Travel 67,239 39,847
Training 4 5
204 263 323 263
Interest
- 19,217 - 9,579
Miscellaneous (67)
--------------
$ 295,161 $ 800,427 $ 491,709 $ 379,232
I
Note: Depreciation and amortization expense is separately stated on the Statements of Revenue,Expenses,and
Changes in Net Position.
i
See auditor's report.
-42-
Schedule 5
2023
Store#10
Store#6 Store#8 Granville
Store#5 Groucho Rd./ Store#7 Southern Centre/
Meadowmont Durham Carrboro Village Oakdale 2023 2022
$ 129,858 $ 113,526 $ 251,429 $ 94,811 $ 221,381 $ 1,686,102 $ 1,422,442
52 168 (613) (30) 1,394 (295) (595)
15,791 14,266 27,733 13,872 31,816 197,226 146,372
174 2,028 2,608 174 4,422 19,160 19,039
7,046 9,495 54,915 18,237 92,337 321,718 317,630
11,666 7,523 14,955 2,591 14,491 110,450 116,605
960 480 960 - 960 5,760 5,760
493 493 493 346 493 4,290 4,897
1,396 1,548 1,688 670 2,343 14,313 15,476
38,622 31,994 59,789 28,101 61,351 435,764 239,548
14,036 - - 10 51,678 52,799
3,141 5,081 8,674 266 8,459 58,027 56,307
21,993 21,943 62,731 16,641 57,996 354,230 310,555
4,641 4,334 10,829 845 10,877 62,179 55,307
- - - - - 142 -
47,801 24,723 88,142 14,101 82,723 517,277 459,987
- - 21 236 266 -
323 319 317 263 263 2,538 -
5,156 - - 21,201 - 55,153 43,085
3 - - (64)
$ 303,149 $ 237,924 $ 584,671 $ 212,335 $ 591,306 $ 3,895,914 $ 3,265,214
-43-
Schedule 6
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULES OF WAREHOUSE AND DELIVERY EXPENSES
Years Ended June 30,2023 and 2022
2023 2022
Salaries and wages $ 240,625 $ 209,010
Vehicle 24,335 19,799
Supplies 5,014 2,705
Burglar alarm and security expense 570 570
Depreciation 61,496 79,770
Group insurance 40,575 31,147
General insurance 10,493 9,320
Employee's retirement and payroll taxes 65,128 35,871
Repairs and maintenance 20,058 9,644
Utilities 4,453 5,047
$ 472,747 $ 402,883
Note: Depreciation expense is separately stated on the Statements of Revenue,Expenses,and Changes
in Net Position.
See auditor's report.
-44-
Schedule 7
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULES OF ADMINISTRATIVE EXPENSES
Years Ended June 30,2023 and 2022
2023 2022
Salaries and wages $ 470,775 $ 444,933
Professional services(audit and legal) 32,116 38,052
Payroll processing fees 9,063 8,009
Burglar alarm and security expense 570 570
Travel 1,643 29
Supplies 29,624 17,687
Depreciation 40,304 43,912
Repairs and maintenance 22,348 19,057
Telephone 464 2,420
Utilities 7,207 4,474
Board expenses 6,823 5,100
Vehicle 813 392
Group insurance 86,908 48,057
Generalinsurance 8,001 7,181
Employees'retirement and payroll taxes 132,590 72,757
Dues and subscriptions 7,846 4,853
Retiree health insurance (18,898) (4,375)
Exterior maintenance services 5,327 6,666
Training 7,883 614
Internet service 5,976 4,599
Uniforms and clothing 2,846 2,699
Bank adjustments 7,268 15
Miscellaneous 225 -
Interest expense 51,214 87,193
$ 918,936 $ 814,894
Note: Depreciation expense is separately stated on the Statements of Revenue,Expenses,and Changes
in Net Position.
See auditor's report.
-45-
Schedule 8
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULES OF NONOPERATING INCOME(EXPENSE)
Years Ended June 30,2023 and 2022
2023 2022
Miscellaneous $ 35 $ 4,067
Loss on disposal of capital assets (1,827) -
Interest earned 6,259 1,989
i
$ 4,467 $ 6,056
See auditor's report.
-46-
i
i
Schedule 9
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
i
SCHEDULES OF LAW ENFORCEMENT EXPENSES
Years Ended June 30,2023 and 2022
2023 2022
Contract Orange County Sheriff/Chapel Hill Police Department/
Carrboro Police Department/Hillsborough Police Department/
UNC Police Department $ 168,000 $ 166,000
See auditor's report.
-47-
Schedule10(a)
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
- (a component unit of Orange County Government)
SCHEDULE OF DISTRIBUTIONS OF PROFITS
Year Ended June 30,2023
Date of Restrictions
Distribution Recipient Amount Distribution on Use
Law Enforcement Town of Hillsborough Police $ 2,625 7/14/2022 Enforcement
Town of Hillsborough Police 2,625 11/17/2022 Enforcement
Town of Hillsborough Police 2,625 1/4/2023 Enforcement
Town of Hillsborough Police 2,625 4/3/2023 Enforcement
Town of Carrboro Police 2,500 7/14/2022 Enforcement
Town of Carrboro Police 2,500 11/17/2022 Enforcement
Town of Carrboro Police 2,500 1/4/2023 Enforcement
Town of Carrboro Police 2,500 4/3/2023 Enforcement
Town of Chapel Hill Police 9,250 7/14/2022 Enforcement
Town of Chapel Hill Police 9,500 11/17/2022 Enforcement
Town of Chapel Hill Police 9,375 1/4/2023 Enforcement
Town of Chapel Hill Police 9,375 4/3/2023 Enforcement
Orange County Sheriff 27,500 9/28/2022 Enforcement
Orange County Sheriff 27,500 11/21/2022 Enforcement
Orange County Sheriff 27,500 3/l/2023 Enforcement
Orange County Sheriff 27,500 6/l/2023 Enforcement
Total Law Enforcement 168,000
Alcohol Education Carpe Diem 13,800 1/26/2023 Education
Carpe Diem 4,200 5/17/2023 Education
Chapel Hill Downtown Partner 2,500 7/5/2022 Education
Chapel Hill Downtown Partner 2,500 8/2/2022 Education
Chapel Hill Downtown Partner 2,500 9/21/2022 Education
Chapel Hill Downtown Partner 2,500 10/4/2022 Education
Chapel Hill Downtown Partner 5,000 11/1/2022 Education
Chapel Hill Downtown Partner 2,500 1/4/2023 Education
Chapel Hill Downtown Partner 2,500 2/3/2023 Education
Chapel Hill Downtown Partner 2,500 3/2/2023 Education
Chapel Hill Downtown Partner 2,500 4/6/2023 Education
Chapel Hill Downtown Partner 2,500 4/26/2023 Education
Chapel Hill Downtown Partner 2,500 5/17/2023 Education
Boomerang Youth 15,000 3/28/2023 Education
Boomerang Youth 5,000 5/17/2023 Education
Chapel Hill/Carrboro Schools 9,500 9/29/2022 Education
Chapel Hill/Carrboro Schools 9,500 11/30/2022 Education
Chapel Hill/Carrboro Schools 9,500 3/l/2023 Education
Chapel Hill/Carrboro Schools 9,500 6/l/2023 Education
El Centro Hispano 1,179 9/22/2022 Education
El Centro Hispano 399 10/24/2022 Education
El Centro Hispano 4,025 1/9/2023 Education
See auditor's report.
-48-
Schedule10(b)
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULE OF DISTRIBUTIONS OF PROFITS
Year Ended June 30,2023
Date of Restrictions
Distribution Recipient Amount Distribution on Use
Alcohol Education(cont'd) El Centro Hispano $ 1,260 2/24/2023 Education
El Centro Hispano 3,549 3/23/2023 Education
El Centro Hispano 2,640 4/7/2023 Education
El Centro Hispano 8,063 5/22/2023 Education
El Centro Hispano 3,885 5/22/2023 Education
El Futuro 7,500 10/24/2022 Education
El Futuro 2,500 11/21/2022 Education
El Futuro 2,500 12/14/2022 Education
El Futuro 5,000 2/22/2023 Education
El Futuro 2,500 4/25/2023 Education
El Future 2,500 5/8/2023 Education
EI Future 2,500 5/25/2023 Education
El Future 5,000 6/15/2023 Education
Orange Partnership/FreedomHouse 1,425 11/30/2022 Education
Orange Partnership/Freedom House 1,522 12/8/2022 Education
Orange Partnership/Freedom House 11,567 5/25/2023 Education
Orange Partnership/Freedom House 6,986 6/15/2023 Education
Orange County Drug Court 8,000 9/29/2022 Education
Orange County Drug Court 8,000 11/30/2022 Education
Orange County Drug Court 8,000 3/1/2023 Education
Orange County Drug Court 8,000 6/1/2023 Education
ReEntry House Plus,Inc. 683 8/9/2022 Education
ReEntry House Plus,Inc. 683 9/7/2022 Education
ReEntry House Plus,Inc. 683 9/28/2022 Education
ReEntry House Plus,Inc. 683 10/26/2022 Education
ReEntry House Plus,Inc. 683 11/30/2022 Education
ReEntry House Plus,Inc. 682 1/9/2023 Education
ReEntry House Plus,Inc. 682 2/3/2023 Education
ReEntry House Plus,Inc. 682 3/10/2023 Education
ReEntry House Plus,Inc. 1,357 4/20/2023 Education
ReEntry House Plus,Inc. 682 6/9/2023 Education
Orange County Schools 7,500 9/29/2022 Education
Orange County Schools 7,500 I1/30/2022 Education
Orange County Schools 7,500 3/l/2023 Education
Orange County Schools 7,500 6/l/2023 Education
Total Alcohol Education 252,000
Orange County Government Units Orange County General Fund 175,000 9/28/2022 None
Orange County General Fund 175,000 11/30/2022 None
Orange County General Fund 175,000 3/1/2023 None
Orange County General Fund 175,000 6/1/2023 None
Total Orange County
Government Units 700,000
Total Distributions $1,120,000
See auditor's report.
� -49-
I
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD Schedule ll(a)
(a component unit of Orange County Government)
SCHEDULE OF REVENUE AND EXPENDITURES-BUDGET AND ACTUAL
Year Ended June 30,2023
2023 2023 Variance
Original Revised 2023 Positive
Budget Budget Actual (Negative)
Revenue
Operating Revenue:
Liquorsales-regular $24,520,230 $ 25,996,885 $ 26,045,431 $ 48,546
Mixed beverage sales 3,602,485 5,135,985 5,125,307 (10,678)
Wine sales 38,000 38,285 38,237 (48)
Total Operating Revenue 28,160,715 31,171,155 31,208,975 37,820
Nonoperating Revenue(Expense):
Other 3,500 3,500 4,467 967
Total Revenue 28,164,215 31,174,655 31,213,442 38,787
Expenses
Taxes Based on Revenue:
Retail sales tax 6,617,770 7,272,650 6,828,324 444,326
Mixed beverage tax 433,283 (433,283)
Total Expenses 6,617,770 7,272,650 7,261,607 11,043
Cost of Goods Sold 14,713,945 16,061,595 16,103,177 (41,582)
Gross Profit 6,832,500 7,840,410 7,848,658 8,248
Operating Expenses
Salaries and benefits 3,178,320 3,546,340 3,526,568 19,772
Board member/meeting expense 6,600 6,900 6,823 77
Cash short 500 750 (295) 1,045
Rent 319,300 54,300 51,678 2,622
Repairs,maintenance,and service contracts 138,000 159,705 152,856 6,849
Utilities,telephone,and internet 95,950 100,250 94,730 5,520
Business insurance 75,000 75,000 80,673 (5,673)
Store supplies and bags 135,000 195,455 197,226 (1,771)
Travel(office) 1,500 1,500 1,909 (409)
Office supplies 20,600 33,535 34,780 (1,245)
Janitorial services/exterior maintenance 26,400 26,400 24,487 1,913
Professional fees(audit and legal) 35,000 32,115 32,116 (1)
Dues and subscriptions 4,900 4,900 7,846 (2,946)
Credit card processing 430,000 527,255 524,545 2,710
Training and education 10,000 10,000 10,421 (421)
Security monitoring 7,200 7,200 6,900 300
Vehicle expense 18,000 25,710 25,148 562
Uniforms 4,200 4,200 2,846 1,354
Interest expense 83,375 98,525 106,367 (7,842)
Contingencies 500 500 161 339
Total Operating Expenses 4,590,345 4,910,540 4,887,785 22,755
Capital Outlay 1,590,350 1,824,210 1,770,965 53,245
Debt Service 241,555 749,100 733,056 16,044
Total Expenditures 6,422,250 7,483,850 7,391,806 92,044
See auditor's report.
-50-
Schedule11(b)
ORANGE COUNTY ALCOHOLIC BEVERAGE CONTROL BOARD
(a component unit of Orange County Government)
SCHEDULE OF REVENUE AND EXPENDITURES—BUDGET AND ACTUAL
Year Ended June 30,2023
2023 2023 Variance
Original Revised 2023 Positive
Budget Budget Actual (Negative)
Distributions
Law enforcement $ 168,000 $ 168,000 $ 168,000 $ -
Alcohol education and rehabilitation 252,000 252,000 252,000 -
Orange County 700,000 700,000 700,000
Total 1,120,000 1,120,000 1,120,000 -
Total Expenditures and Distributions 7,542,250 8,603,850 8,511,806 92,044
Revenue Over(Under)Expenditures (709,750) (763,440) (663,148) 100,292
Other Financing Sources(Uses):
Working Capital Retained
(Unrestricted Funds) 709,750 763,440 (763,440)
Revenue Over(Under)Expenditures
and Other Financing Sources(Uses) $ $ (663,148) $ (663,148)
Reconciliation from budgetary basis
(modified accruals)to full accrual:
Reconciling items:
Capital outlay-financed 1,219,336
Capital outlay-cash 551,629
Depreciation and amortization (659,039)
Principal payment on notes payable 733,056
Decrease in deferred outflows of
resources-pensions 397,024
Decrease in deferred inflows of
resources-OPEB 56,709
Increase in deferred inflows of
resources-pensions 529,915
Increase in net pension liability (1,050,280)
Increase in net OPEB liability 100,338
Change in Net Position $ 1,205,540
See auditor's report.
-51-
State of North Carolina
Alcoholic Beverage Control Commission 1( -20 1 �
fiY rTf�
ABC Law Enforcement Monthly Report
GS 188-501(f1)
Iy rT
Board:
Orange County
Reporting Month/Year: VL
Dec-23 CAM vtC -
Regulatory Activity and Training
Violations Reports Submitted to ABC Commission 0
Total Number of Offenses Contained in Reports 0
Sell to Underage Campaign Checks 0
Permittee Inspections 0
Compliance Checks 1
Seller/Server Training 0
Alcohol Education 1
ABC Law Violations At Permitted Away From Permitted
Establishment Establishment
Sell/Give to Underage 6 0
Attempt to Purchase/ Purchase by Underage 0 0
Underage Possession 0 0
Unauthorized Possession 0 0
Sell /Give to Intoxicated 0 0
All Other Alcohol Related Charges 0 0
Total:
Controlled Substance Violations At Permitted Away From Permitted
Establishment Establishment
Felony Drug Related Charges 0 0
Misdemeanor Drug Related Charges 0 0
Total:
At Permitted Away From Permitted
Other Offenses Establishment Establishment
Driving While Impaired 0 0
All Other Criminal Charges 0 0
Total:
TOTAL CRIMINAL CHARGES:
Agencies Assisted
Assistance Provided to Other Agencies 0
Remarks
CHPD conducted one compliance operation this month. 35 total businesses were
checked and 6 failed. All violations will be submitted in the ABC portal.
Reporting Officer/Title:
Mondrez Pamplin, Patrol Sergeant, CHPD
Report Date:
15-Jan-24
ORANGE COUNTY ABC BOARD
Open Meeting Board Minutes
Tuesday,November 28, 2023, 10:00am
Location: 601 Valley Forge Road Hillsborough,NC 27278
Scheduled attendees:
Patrick Burns, Board Chair Judson Williamson, Vice Chair
Elizabeth Carter, Member Melvin Green, Member
Mike Zito, Member Tony DuBois, General Manager
Ron McCoy, Finance Officer Angela Willoughby, Asst. GM
Amy Fowler, BOCC Liaison Taylor Jackson, Human Resources
Call to order at 10:04 am, a quorum was present and Mr. Burns, Board Chairman called the board
meeting to order.
Mr. Burns read the Mission Statement: The Mission of the Orange County ABC Board and our
employees is to serve our locality responsibly by controlling the sale of spirituous liquor,returning
profits to Law enforcement, Alcohol Education, and the County Fund while providing excellent
service in customer friendly, modern, and efficient stores.
Mr. Burns read the Conflict-of-Interest Statement. The question was asked: Does any member of
the Board have a conflict of interest or any condition or fact that might create the appearance of
a conflict of interest with respect to any matters on today's agenda?All present said nay
Approval of the Open Meeting Agenda: Mr. Zito made a motion to approve the agenda, Mr. Green
seconded the motion and the vote carried.
Minutes of the open session October 17,2023:Mr. Williamson made a motion to approve the minutes,
Mr. Green seconded the motion and the vote carried.
Consent Agenda: October 2023
a. Financial Reports:
i. Comparative Statement of Net Assets
ii. Comparative Revenue and Expenses for October
iii. Actual to Budget Comparison
b. October 2023 and Year to Date Retail and LBD Sales j
c. Statewide Sales Report for October 2023
Discussion was held, Ms. Carter made a motion to approve the consent agenda, Mr. Williamson
seconded the motion and the vote carried.
Board Attorney Contract Renewal: Discussion was held, Mr. Zito made a motion to approve the
contract renewal, Mr. Williamson seconded the motion and the vote carried.
I
Management Updates:
• Law Enforcement Reports were presented
• A grant management company(Fondant)was hired to manage the grant process. Taylor Jackson
is managing the implementation with a January timeframe to coordinate with the new grant
submissions.
• 90Degree was hired for redesign of the OC ABC website with an expected completion date of
January 31, 2024.
• Staff discussed a proposal for upgrading the POS system as well as back office software from
the current supplier, Dalcom. The proposal is $205,000 for retail POS system and $27,000 for
back office software. There was consensus from the board to move forward with signing the
contract with Dalcom and to include the proposal as a budget amendment in January 2024.
• Financial posters have been placed in each store and office location.
• Weldon Mills distillery tours are scheduled for January 18 & 25,2024.
• The allocated bourbon lotteries are expected to take place in December when all products have
been received. There will be a customer,restaurant/bar and employee lottery.
Health Insurance: The 2024 health renewals were within the budgeted amount therefore the board will
remain with the current company, First Carolina Care.
I
Board Comments:
Ms. Fowler stated the change of county commissioner liaison will start January 2024. All board
members expressed appreciation to Amy Fowler and her commitment to ABC. Mr. Burns discussed
current law enforcement challenges and acknowledged the staff on the work for the financial posters.
Ms. Carter made a motion to adjourn, Mr. Zito seconded the motion and the vote carried—11:08.
i
I
Chair's Signature and Date
i
I
i
i
I
I
3/5/26, 11:27 AM Orange County ABC Mail-November 2023 Board Meeting Minutes
Orange County
ABC Primary Admin<admin@orangeabc.com>
November 2023 Board Meeting Minutes
2 messages
asstgm@orangeabc.com <asstgm@orangeabc.com>~ Thu, Jan 11, 2024 at 9:26 AM
To: Primary Admin <admin@orangeabc.com>, ocabc@orangeabc.com
Julie & Tony — Please proofread notes for me before submitting to
board packet.
Thanks
Hey Angela,
i
Can you please send me the minutes from the November Board
meeting?
Thanks,
Julie
Julie Mebane
Accounting 8 Administration
Orange County ABC Board
I
I
I
https://Mail.google.com/mail/u/0/?ik=e24ab99d7a&view=pt&search=all&permthid=thread-f.,1787804392498075494&simpl=msg-f:17878043924980754... 1/2
3/5/26, 11:27AM Orange County ABC Mail-November 2023 Board Meeting Minutes
. November 2023 Board Meeting Minutes.pdf
160K
_,_.._.._. .___,_..___._.............___.W__...__ ._..__.... ._.—...__..............._........_..r._.__W.. ___..___._ �.._..� _.__.._�_---.. _____.�
jrimary Admin <admin@orangeabc.com> Fri, Jan 12, 2024 at 8:16 AM
ro: asstgm@orangeabc.com
Thanks!
Julie
[Quoted text hidden]
II
i
1�I
I
i
i
ill
I
ll
I
https://m al l.goog le.com/mall/u/0/?ik=e24ab99d7a&view=pt&search=nl I&permthid=thread-f.1787804392498075494&s lmpl=msg-f.17878043924980754... 2/2