|
Orange County ABC Board j
<br /> Actual to Budget Comparison
<br /> For the fiscal year reargue 000/2023 Attachment"C"
<br /> APRIL YTD 2023 Balance %
<br /> Sales 2023 Budget Answer, Remaining
<br /> LiquorSales 2,061,475L66N34"",,"799
<br /> 2 24,971,330 3,166,108L7.628V%
<br /> Wine/Mixer 3,42517 39,500 7,183
<br /> LBD 45974320 4,407,485 135,265
<br /> Grasssmes 2,514.64359 29,418,315 3,308,55E
<br /> Tams based on gross sales 588,40339 6,894,445 B19,912
<br /> armholes 1,926.24026 22,523,870 2,488,644
<br /> Costo(Sales ryn,o,anekmntwy equsumaal -0,310,9397 15,367,930 1,957 503
<br /> Grass profit 616.30199 7,155,940 521,141
<br /> Payroll and Related Expeneee benchmark
<br /> Salaries and Wages 201,813 2,007,593 2,237,145 229,552 10.26% 16.67%
<br /> Payroll Taxes 13,833 156,020 174,345 18,325 10.51%
<br /> Retirement 19,950 215,545 231,910 15,365 7.06%
<br /> Group Health Insurance 40,990 368,896 422,675 53,779 12,72%
<br /> Retiree's Group Insurance 11,512 - 115,124 131,850 16,726 12.69%
<br /> Human Resources 21200 19,924 22,000 2,076 0.44%
<br /> 401k 51059 56,415 69,395 12,980 18.70%
<br /> Processing fees 928 7,696 8,5DD 804 9.46%
<br /> Than payroll related expenses 29B4O85 2,947,213 3,297,820 350,607 10.63%
<br /> Oper
<br /> Board MnglemWeea
<br /> Board MemberslMeetingRrevelRrelning 5,900 6,600 1 . 1%
<br /> Rent 4,300 300 44,085 54,30D 10,215 215 18.81% I,
<br /> Lease Ammtlmimi 20,607 202,034 243,000 40,966 16.86%
<br /> Repairs&Malntenance-Bldgs 6,215 27,251 0,000 12,749 31.87%
<br /> Repairs&Malntenance-Equip. - 17,20E 20,000 2,794 13.97%
<br /> Utilities,Telephone,Internet 5,381 78,263 95,950 17,687 18.43%
<br /> Business Insurance 7,044 66,159 75,000 8,841 11.79%
<br /> Stour Supplies,Bags and Expenses 20,278 163,456 175,000 11,544 6.60%
<br /> Employee Travel 236 1,905 1,500 (905) �22.00%
<br /> Office Supplies&Expenses 378 25,980 28,000 2,020 7,21%
<br /> Malntenance Service$ 1,637 20,182 26,400 6,218 23.65%
<br /> Service Agreements(Data/HVAC) 7,511 76,574 94,250 7,726 9.17%
<br /> Postage 350 ,2,853 3,100 247 7.97%
<br /> Pmfesslanal Fees(age.)(audit and legal) 8,075 28,166 35,000 6,834 19.63%
<br /> Dues&Subscriptions 303 3,713 4,900 1,187 24.22%
<br /> Credit Card Processing 46,092 435,930 475,500 39,570 8.32%Training and Education 412 8,177 10,000 1,823 18.23%
<br /> Burglar Alarm and Security 575 5,750 7,200 1,450 20.14%
<br /> Vehicle Expense 803 22,551 28,500 5,949 20.87%
<br /> Unitarms 2,423 4,200 1,777 42,31%
<br /> Debt Service(interest expense) 5,776 41,322 53,375 12,053 22.5B%
<br /> Interest(Leases) 3,54E 36,878 45,150 8,272 18.32%
<br /> Cash over/short (24) 403 750 347 45.27% .
<br /> Contingencles/Misc. 4 194 500 306 61,20% '.
<br /> Total oirsafing expenses 139,826 1,317,305 1,518,175 200870 13.23%
<br /> Total OperatinglPayroll Expenses 434,911 4,264,617 4,816,995 551,478 11.45%
<br /> Income from Operations 180,390 2.370,282 2,339,045 (30,337) -1.30%
<br /> Other Income
<br /> Interest Income 793 4.950 2,000 (2,950) -147.60% '..
<br /> Miscellaneous 35 35 1,600 1,465 97.67%
<br /> Total Other Income 828 4,985 31500 (1,485) 42.43%
<br /> Net Income Butore Profit Distributions: 181,218 2,375,267 2,343,445 (31,822) -1.36%
<br /> Slalutary Dimutbulions
<br /> Law Enforcement 14,000 140,000 168.000 28,000 18.87%
<br /> Alcohol Rehab&Ed 21,000 210.000 262,000 42,000 18.67%
<br /> Total SWlulory Distributions 55:000 350,000 420,000 70,000 16.67%
<br /> Net Income Before Profit Distribution 148218 2,025,267 1,923,44E 101,822 -5.29%
<br /> Profit Distribution
<br /> Orange County-Gen Fund 58,333 683.333 700.000 116,667 16.67%
<br /> Working Capital Retained•: SLBBS 1,441,9m 1.223,445 210g89) -17.88%
<br /> Poarawd'n loon bWdrandlM1M aa�m4 34f014 42L0W
<br /> 4%ml I.100,020 708.445
<br /> Capital Outlav Month YTD Budget amtleetn,naelhe
<br /> Score ad"debane)
<br /> Starecamtrudicn 27,792 1.222.748 1,2e5,100 42,352 3,35%
<br /> Change Ord ors/Earderwag/Prmleet Administration 23.560 235,000 211,49 89.97%
<br /> Furniture,fixtures and equipment(FFE) 102,100 127,593 166,251) 37,657 22.79%
<br /> Premature flams/office 0 0 0 - 0.00%
<br /> Capler/office 0 5,949 6,950 1
<br /> Refrigerator malts(five stores) 0 2,580 7,500 4,920 65.60%
<br /> Southern Village renovations 0 129.012 122,200 16,812) -,Do
<br /> .00%
<br /> Capital Receipts
<br /> Debt service prameds(FH) (27,792) (1,219,336) (1,219.336) - OAD%
<br /> Appropriated fund balance(RSB) 0 0 (617,910) (677,810) 100.00%
<br /> Debt Sabra(principal)
<br /> TmI,t(Ohapel Hill North) 0 677,810 077,810 - O.DD%
<br /> First Homon(Mebane Store) 15,556 42,052 54,440 12,388 22.76%
<br /> 117.716 1,011,969 636,105
<br /> 5
<br />
|