|
Orange County ABC Board
<br /> Actual to Budget Comparison
<br /> Far theflscof year ending 0513012023 Attachment C'
<br /> MARCH WO 2023 Balance %
<br /> Sales 2023 Budget leassuing Person,
<br /> Liquor Sales 2,101,516 19,753,747 24,971,330 5,217,583 20,89%
<br /> Wine/Mixer 1.978 28,891 39,50D 10,609 20.86%
<br /> LBO 461.898 3,W2,478 4,407,485 595,009 13.50%
<br /> Gressel 2,585,392 23,595,114 29,418,315 5,823,201 19.79%
<br /> Taxes based on gross sales 004,793 5,495,131 6,894445 1,408,314 20.43%
<br /> NMSWes 11980,599 18,108983 22,623.870 4,414,887 19.60%
<br /> 0081 of Sales Amuse lnvontay standards) 1.283,496 12,099,496 15,367,930 3,272,444 21.33%
<br /> Gross Profit 697,104 601949T 7,155940 1136443 16.88%
<br /> Payroll and Related Expenses benchmark
<br /> Salaries and Wages 202,613 1,805,980 2,237,145 431,165 19.27% 25.00%
<br /> Payroll Taxes 19,766 142,181 174,345 32,158 IBA5%
<br /> Retlasuart 28,329 195,595 231,910 36,315 15.66%
<br /> Group Health Insurance 39,478 327,906 422,675 94,769 22.42%
<br /> Retiree's Group Insurance 11,613 IW,612 131,850 28,238 21.42%
<br /> Human Resources $95 1],]24 22,00D 4,276 19.44%
<br /> 401k 7,202 51,356 69,395 18,039 25.99% j
<br /> Processing fees 511 5,768 815DD 1,732 20.38%
<br /> Total Payroll related expenses 310,307 ' 2,551,128 3,297,820 M6,692 19.61%
<br /> 0pemtln9 Expenses
<br /> Board MembBrefMee9ngfTmVBUFmiaing TOT 5,475 Sm 1,125 17.05%
<br /> Rent 4,300 39,785 54,3M 14,515 26.73%
<br /> Leans Anawti atlon 20,507 181,527 243,OOD 61,473 25.30%
<br /> Repairs&Maintenance-BIdBs 1,241 22,036 40,ODD 17,964 44.01%
<br /> Repalrs&Maintenance-Equlp. 1,974 17,205 20,OW 2,794 13.97%
<br /> Utilities,Telephone,Internet 5,724 73,728 95,950 22,222 23.16%
<br /> Business Insurance 6,574 59,115 75,OW 15,885 21.18%
<br /> Store Supplles,Expand Expenses 16,694. 143,178 175,OOD 31,822 18.18%
<br /> Employee Travel 814 1,659 1,500 (169) -11.27%
<br /> Ofgee Supplies&Expenses 4,992 25,602 38,00D 2,398 8.66%
<br /> Maintenance Services 2,527 18,545 26,4W 7,855 29.76%
<br /> Servles Agreements(OatO/HVAC) 7,511 69,013 84,250 15,237 18.09%
<br /> Postage 418 2,503 3,100 597 19.26%
<br /> Professional Fees(office)(audit and legal) 1,975 20,091 35,00D 14,909 42.60%
<br /> Dues&Subscriptions 303 5,410 4,90D 1,490 30,41%
<br /> Credit Card Pmcessing 41,516 389,838 475,50D 85,662 18.02%
<br /> Training and Education 31036 7,765 10,000 2,235 22.36%
<br /> Burglar Alarm and Security 575 5,175 7,20D 2,025 28,13%
<br /> Vehlde Expense 2,211 21,748 28,500 6,752 23.69%
<br /> Uniforms 2,429 4,20D 1,]7] 42.31%
<br /> Debt Service Interest expense) 4,]]4 35,546 53,375 17,229 33.40%
<br /> Interest(Leases) 3,548 33,850 of 11,820 26,18%
<br /> Cash over/short 176 427 750 323 43.07%
<br /> Cantingencles/Mid. b IN SOO 310 02.e0%
<br /> Told dermal exassal 137,100 1,179,325 1,518,175. 338,850 22.32%
<br /> Total OpomtingMayroll Expanses 447,40 3.830,4521 4,815,995 985,543 20.40%
<br /> Income from Operellons 249,697 2;1ae,046 2,335945 150,900 6.45%
<br /> Other Income
<br /> Interest Income 841 4,158 21000 (2,158) 407.90%
<br /> Miscellaneous 0 1,600 1,500 100.00%
<br /> Total Other Income 841 4,150 3,600 (658) ,18.00%
<br /> Net Income Before Profit Distributions: 250,538 2,193,203 2;343;445 150,242 6.41%
<br /> Statutory Dislrlbutlons
<br /> Law Enforcement 14,000 126,000 168,000 42,000 26.Oc% I
<br /> Alcohol Rehab&Ed 1 21,000 189,000 262,000 63,000 25.00%
<br /> Total SlatuloryDlsldbutlone 35,000 316,000 420,000 106,000 25.W% li
<br /> Net Income Before Profit Distribution 215,638 1,878;203 1,923,445 45,242 2.35
<br /> Profit Dlstdbut100
<br /> Donnas County-Gen Fund Be 334 525,000' 700,000 I75,000 25.00% '.
<br /> Working Capltalftetained': L ib],204 1,353,203 1,223,445 120,]68 -00.01%
<br /> aePree.fka Moe-0 ,d,dae„0 34.72e aM 92B 42B 0B0
<br /> 122.478 110a02M 90p446
<br /> Cabital Outlay Month YID. Budget aadammmemme
<br /> Stare#4(AT"no')
<br /> Store ccmAruttIbn 188.584 1,162,185 1,266,100 112,915 8.93%
<br /> Change Orders/coneering/Prolect Administration 0 23,404 236;000 211,596 80.04%
<br /> Furniture,fixtures and equipmentHff) 2,217 84,933 165,250 80,317 48.60%
<br /> Resurface floors/atone 0 0 0 0,00% I.
<br /> Copier/afOce 0 6,949 6.950 1
<br /> RefrlgeratOs units IT.stores) 0 2,660 7,600 4,920 66.60%
<br /> Southern Village renovations 0 122,168 122,200 42 -100.00%
<br /> Capital Receipts
<br /> Debt seMce promeds INTO (188,684) (1,162,185) (1,219,336) (67,1501 6.51%
<br /> Appropriated fund bale me g1SB) 0 0 (677,910) (677,310) 100,00%
<br /> Debt Service farindpel)
<br /> Trulst(Chapel Hill North) 0 6]],010 677,810 0.00%
<br /> First Had20n(Mebane Store) 13,228 26.486 64.440 27,954 51.35%
<br /> 15.445 943,32B 636,105 (3W,215 i8.30%
<br /> 5
<br />
|