|
Orange County ABC Beard j
<br /> Actual to Budget Comparison
<br /> For theflscal year ending 0613012024 Attachment'C'
<br /> JULY YTD 2024 Balance %
<br /> Sales 2023 Budget Remaining Bernardo, I
<br /> Liquor Sales 11961.761 1,961,761 26,613,255 24,651,494 92.63%
<br /> W1ne/Mixer 2,620 21620 40,050 37,430 93.46%
<br /> LEAD 333,656 333,656 4,615,680 4282024 92.77%
<br /> Grass Sales 2.298,037 2,298,037 31,268,985 28,970,948 9265%
<br /> Taxes based on Broad..Is 532,126 - 592,126 7,501,430 6,969,304 02.91%
<br /> Net Sales 1,765,911 1,765,911 23,767,566 22,001,644 92.57%
<br /> Cost of Sales(inebe,p imenior,mlmumnm) 1,186,065 1,185,068 16,398,045 15,151977 92,74% III
<br /> Gross Profit 679,843 579,g43 7,429,510 6849,667 92.2MA
<br /> Payroll and Related Expenses fienobmmk
<br /> Salaries and Wages 161.689 161,589 2,576,200 2,414,611 93.73% 91.67%
<br /> Payroll Taxes 13,566 13,566 197,080 183,514 93.12%
<br /> Retlrement 20,687 - 20,687 273,910 253,223 92.45%
<br /> Group Health Insurance 48.472 46,472 485,000 08,528 90.42% '
<br /> Realm 's Group Insurance 11.512 11,512 170,000 158,488 93.23%
<br /> Human Resources 473 473 25,000 24,527 98.11%
<br /> 4011, 4.846 4,846 68,500 63,654 92.93%
<br /> Processing fees 703 703 91600 8,897 92.68%
<br /> Total payroll related expenses 20.848 259,848 3,805,290 3,545,442 93.17%
<br /> Operating Expanse.
<br /> Beard Membereadeeling/Tr.ve1/Tralning 504 SIX 0,500 7,996 94.07%
<br /> Rent 9,926 9,926 66,005 56,079 84.06%
<br /> Lease Amertlmtlon 19,627 19,627 246,085 226,458 92.02%
<br /> Repairs&Maintenance-Bldgs 4,876 '4,876 42,000 37,124 88.39%
<br /> Repairs&Maintenance-Equi, 1,677 1,677 25,000 23,323 93.29%
<br /> Otilities,Telephone,Internet 8,403 8,03 95,000 86,597 91.15%
<br /> Business Insurance 7,081 7,081 88,275 81,194 91.98%
<br /> Store Supplies,Begs and Expenses 15,317 15,317 180,000 164,683 91.49%
<br /> Employee Travel - - 0 31500 3,500 100.00%
<br /> Offlce Supplies&Expenses 1,787 1,797 25,000 23,203 92.81%
<br /> Maintenance Servlces 2,212 2,212 28,000 25,788 92.10%
<br /> Service Agreements(Data/HVAC) %140 9,140 95,OD0 85,860 90.38%
<br /> Postage 360 350 3,400 3,OS0 09.71%
<br /> Professlonal Fees(office)(audit and legal) 2,000 2,000 35,000 33,000 94.20%
<br /> Does&SubscH Lions 166 166 4,900 4,734 96.61% j
<br /> Credit Card Processing 41.217 < 41,217 565,115 523,898 92.71%
<br /> Training and Education 49 < 49 Tom 9,951 99.51%
<br /> Burglar Ala rm and Security 576 - 575 7,200 6,625 92.01%
<br /> Vehl[le Expense 526 526 301000 29,474 98.25%
<br /> Uniforms 311 311 4,000 3,689 92.23%
<br /> Debt Service(interest expense) 5,612 '. 5,512 62,675 57,163 91.21%
<br /> Interest(Losses) 3.564 3,564 41,260 37,696 91.36%
<br /> Cash aver/short (251) (251) 500 751 150.20%
<br /> Cm ingrad,a/Mbc. 5 -5. 500 495 99.00%
<br /> rate/operating expenses 134.584 134,S$41 1,666,915 1,532,331 91.93% -
<br /> Total OperdtinglPayrcll Etta.usas 394,432 394,432 5,472.205 5,077,779 92.79%
<br /> Income hom Operations 186,411 185,411 1.957,305 1,771,894 90.63%
<br /> Other Income
<br /> Interest Income 450 450 2,500 2,050 82.00%
<br /> Mlaoellaneous 290 290 1,000 710 71.00%
<br /> Total Other Income 74D 740 31600 2,760 78.85%
<br /> I
<br /> Not Income Before Profit Distributions: 106.151 186.151 1.,960,806 1,774,654 9D.51%
<br /> Statutory Distributional,
<br /> Lew Enforcement 14.719 14,719 211,630 196,911 93.04%
<br /> Alcohol Rehab&Ed 21,753 21,750 261,000 239,250 91.67%
<br /> Total Stlu/ory Distributions 3$,469 36,469 472,630 436,1fi1 92.28%
<br /> Net Income Before Ramat Distribution 149,682 149.652 1.488176 1,336,483 69.B4%
<br /> Profit Distribution
<br /> Orange County-Gen Ford 66,667 66,657 805,000 J38,333 91.J2%
<br /> Working OBpItel Retail Pon.In Not Portion: 63,015 83,015 603,176 800,180 07.85%
<br /> nopreG00wr0—odg,elnanem) 35.3)2 36= 4Y5_00a
<br /> 4I,&3 47,a13 tc,loa
<br /> i
<br /> Capital Carl Month YTD Budget $.deer ry alnm¢
<br /> Warehouse
<br /> Oellvery truck 0 0 130.400 130,400 100.00% '..
<br /> Racking,firepanel,scanners,compnter 0 0 23.600 23,500 100.001
<br /> Office
<br /> Replacement windows 0 0 36,000 35,000 100.00%
<br /> Grant software,morns,DVR 0 0 16,000 16,000 100.00%
<br /> Sm.
<br /> Security camera upgrades o 0 10,000 ID,000 100.00%
<br /> Store#004 drill arc'hn.,Vienglneedag 2,900 2,900 0 (2,900)
<br /> refrigerated molar 3,280 3,280 0 (3,280) -10RDO%
<br /> Capitol Receipts
<br /> Appropriated fund balance(R58) (2,900) (2,900) (373.400) (370,500) 99,22%
<br /> Debt Service(principal)
<br /> Flat Hanson(Mebane Store) 12,490 12,490 156,500 146,010 82.12%
<br /> 15,7701 15,770
<br /> i
<br /> I
<br /> 5
<br />
|