|
Orange County ABC Board
<br /> Actual to Budget Comparison
<br /> For the flsml year ending 0613012023 Attachment"C"
<br /> MAY YTD 2023 Balance %
<br /> Sales 2023 Budget Remaining Remelting
<br /> Liquor Sales 2,114,763 29,939,195 24,971,330 1,031,345 4A3%
<br /> Wine/Mixer 1,964 36,281 39,500 3,219 8.15%
<br /> LBO 470,207 14,742,4j7 4407.485 334,942 -7.00%
<br /> Gross Soles 2,608,9M 29,718,ff93 29,418,315 699,622 2.38%
<br /> Taxes based on gross sales 809,521 6,69,05q 6,894,445 210,391 3.05Y.
<br /> Net Soles 1,999.413 ;22A3i 639 22.623.870 489,231 2A7%
<br /> Cost Of Salas lNs'rm urvxnmryequzerent9 1385088 Sd186;3i5 15,367930 581,615 3.78%
<br /> Gross Profit fi13525 $2g9,324 7,155940 92,384 -1,29%
<br /> Payroll and Related Expenses benchmark
<br /> Salaries and Wages 196 255 ,`' ;203,8a8 2,237,145 33,297 1A9% 8.33% j
<br /> Payroll Taxes ':13A41 169;d8f 174,345 41884 2.80%
<br /> Retirement '19.138 234,M 231,910 (2,7731 -1.20%
<br /> Group Health Insurance -42,672 ,411j$fi8 422,675 11,107 2,63%
<br /> Retiree's Group Insurance --i11 512 136,636 13LS50 5,214 3.95%
<br /> Human Resources 2,009 r,21,933 22,000 67 0.30%
<br /> 4011, 4857 61,271 69,395 8,123 11.71%
<br /> Processing fees 1 679 ,,3751 8,509 125 1.47% j
<br /> Toinjowymiladichadexpenses 200663 1,297,776 31297,820 60,044 1.02%
<br /> Op...M9Expenses
<br /> Board MembamiMeeBngiTrovesTmieirg 1 497 _6,397 6,600 203 3.06%
<br /> Rent +4124 49209 54,300 6,091 11.22%
<br /> Lease Amortization 20507 222,541 243,000 20,459 0.42% j
<br /> Repalrs&Malatenance-Bldgs 1A96 34,fi47 40,000 5,353 13.38%
<br /> Repalu B,Maintenance Equip. 4257 ;$,463 20,000 (1,463) -7.32%
<br /> Utilities Telephone,Internet 130aa 91,351 95,950 4,599 4.79% j
<br /> Business Insurance '7 044 ]3,203 75,ow 1,797 2.40%
<br /> Stare Supplies Bags and Expenses 18500 181;956 175,000 (6,956) 3.97%
<br /> Employee Travel 4 3;909 1,500 (409) -27.27%
<br /> Office Supplies&Expenses -2,955 28;935 28,000 (935) -3.34%
<br /> Maintenance Services 7 T909 2;,091 26,400 4,309 16.32% j
<br /> Service Agreements(Dala/HVAQ T,]511 94�635 84,250 215 0.26%
<br /> Postage 342 3ji95 3,100 (95) J.06%
<br /> Professlonal Fee,(office)(audit and legal) '1,975 30,1411 35,000 4,859 13.88%
<br /> Dues&Subscriptions 303 4,g16 4,900 924 18.04%
<br /> Crecit card Processing 45.191 481;i21 475,500 (5,621) -1.18%
<br /> Training and Education '1,707 ,9ree4 10,000 116 1.16%
<br /> Burglar Alarm and Sew fit, 575 6,35i 7,200 8)5 12.15%
<br /> Vehicle Expense 936 23,4$] 28,500 5,013 17,69%
<br /> Uniforms 304 1;727 4,200 1,473 35.07%
<br /> Debt Sari.(interest expense( 4968 46,30& 53.375 7,067 13.24%
<br /> Interest(Leases) 3475 40j53 45,150 4,797 10.62%
<br /> Cash over/Short (400) -. 3 750 747 99.60%
<br /> Cant ngendes/Miu 15 $o9 500. 291 68.20%
<br /> Total opening expenses , 147291 1,464,566 1,51$175 53,669 3.54%
<br /> Total Operalin9iPayroll Expenses 437784 . 4i9Z 281 4.815.995 111,714 2.36%
<br /> Inoom.from Oscar... 175761 2,546,093 2,339,445 (206,098) -8.81%
<br /> Oiherinoome
<br /> Interest Income _ 732 .5,6@2 21DIX (3,682) -184.10%
<br /> Miscellaneous 35 11800 1,465 97,61%
<br /> Total Other Income 732 r 315DO (2,217) 63.34%
<br /> Net In...Before PmUt Distribution.: 178493 255£,760 2,343.445 (208,315) -8..on
<br /> Statutory 0lslribullons >
<br /> Law Enfmcement 14 000 159,b00 lea," 14,001)
<br /> Alcohol Rehab&Ed .21000 231.000 262,000 21,000 8.33%
<br /> Total Statutory Distributions 35001 385,000 - 420,000 35,000 6.33% j
<br /> Net Income Before Profit Olmdbutlon 141493 2166.760 1,923,445 243.315 -12.66%
<br /> Profit Distribution
<br /> Orange CounlyGen Fund 50333 641',66fi 700000 98,334 T33%
<br /> Working Comm Reta1nediChen9e In Net Position '63.189 1 595;094: 1.223,445 (301,649 -24.66%
<br /> neyradp.ccrvMxb.vvdra4 Pines arfon 42a0og
<br /> 45.07 1,14e,011 7ea.Me i
<br /> Capital Outlay Month I YTI) , .Budget audoernmasal,
<br /> Stare#4(Meb acre) -
<br /> Storewnslruction 196,738 1,376.713 1,265:100 (111,613) -8.82%
<br /> Change Orders/EneJnaerimi'm1ct Administration 8,948 30 503 215,000 20g497 87,02%
<br /> Furnitum,fixtures and equipment(FFE) I .64, 165,250 38,207 23.12%
<br /> Resurface BocnA,fBce 0 '-'0' 0 - 0.00%
<br /> Copier/of@e 0 5:949. 6,950 1
<br /> Refrigerator units(five stores) 5 2.937 S.sti, 7.500 1,983 26.44%
<br /> Southern Village renovations 0 129:012 122.200 (6,812) -100.00% II,
<br /> Capital Receipts
<br /> _- Debt service proceeds(FH) (3%356) (1.219,335) - 0,00%
<br /> Appropriated fund balance(RSB) 0 1`.0 (077.810) (677,810) 100.00%
<br /> Debt Smakti mhelli l
<br /> Trulrt(Chapel HIII North) q -6",810 677,810 - 0.00%
<br /> First Uprisen(Meters Store) 13,016 39,50; 54.440 14,938 27.44%
<br /> 180.27 1;172,714 fi36;305 (536,fi09) -84.36%
<br /> 5
<br />
|