The URL can be used to link to this page

Home My WebLink AboutLake Elsinore PandL Bar_July 4-6_updated (Elvis Frias's conflicted copy 2024-07-09)Day 7/4/2024 7/5/2024 7/6/2024 Sponsorship Total Split Profit 11159.0967 -7835.6292 568.1775 5000 8891.645 4445.8225 7/4/2024 Revenue Concessions Beer Seltzer Margarita/Paloma Michelada Water Corona Premier Special Soda Mixed Drinks Modelo Agua Fresca Wine Total Concession Revenue Parking VIP General ADA Total Parking Revenue Total Revenue COGS Concessions Beer Seltzer Margarita/Paloma Michelada Water Corona Premier Special Soda Mixed Drinks Modelo Agua Fresca Wine Total COGS Concessions Parking VIP General ADA Total COGS Parking Total COGS Gross Profit Operating Expenses Bartenders Cashiers Labor - Bars On-Site Manager Freezer Truck Supplies/Ice Bar/Tent Rental Per Diem - Food Total Operating Costs Net Profit Units 201 57 82 50 142 38 78 35 23 6 114 484 72 201 57 82 50 142 38 78 35 23 6 114 484 72 10 6 2 1 1 1 14 1 Price 15 15 10 15 5 15 5 10 10 10 30 20 15 2.39583333333333 2.675 2.56 2.34166666666667 0.1 2.68333333333333 0.5 2.5 1.20416666666667 2.75 4 4 4 250 250 433 500 367 425 40 125 Total 3015 855 820 750 710 570 390 350 230 60 7750 3420 9680 1080 14180 21930 481.5625 152.475 209.92 117.083333333333 14.2 101.966666666667 39 87.5 27.6958333333333 16.5 1247.90333333333 456 1936 288 2680 3927.90333333333 18002.0966666667 2500 1500 866 500 367 425 560 125 6843 11159.0966666667 7/5/2024 Revenue Concessions Beer Seltzer Margarita/Paloma Michelada Water Corona Premier Special Soda Mixed Drinks Modelo Agua Fresca Wine Total Concession Revenue Parking VIP General ADA Total Parking Revenue Total Revenue COGS Concessions Beer Seltzer Margarita/Paloma Michelada Water Corona Premier Special Soda Mixed Drinks Modelo Agua Fresca Wine Total COGS Concessions Parking VIP General ADA Total COGS Parking Total COGS Gross Profit Operating Expenses Bartenders Cashiers Labor Set-up On-Site Manager Freezer Truck Bar Rental/Tent Rental Supplies/Ice Per Diem - Food Morros/Voces de Rancho Total Operating Costs Net Profit Units 281 25 100 23 76 17 15 3 12 0 18 198 19 281 25 100 23 76 17 15 3 12 0 18 198 19 6 4 2 1 1 14 1 1 1 Price 15 15 10 15 5 15 5 10 10 10 30 20 15 2.39583333333333 2.675 2.56 2.34166666666667 0.1 2.68333333333333 0.5 2.5 1.20416666666667 2.75 4 4 4 250 250 433 500 367 40 425 125 12000 Total 4215 375 1000 345 380 255 75 30 120 0 6795 540 3960 285 4785 11580 673.229166666667 66.875 256 53.8583333333333 7.6 45.6166666666667 7.5 7.5 14.45 0 1132.62916666667 72 792 76 940 2072.62916666667 9507.37083333333 1500 1000 866 500 367 560 425 125 12000 17343 -7835.62916666667 7/6/2024 Revenue Concessions Beer Seltzer Margarita/Paloma Michelada Water Corona Premier Special Soda Mixed Drinks Modelo Agua Fresca Wine Total Concession Revenue Parking VIP General ADA Total Parking Revenue Total Revenue COGS Concessions Beer Seltzer Margarita/Paloma Michelada Water Corona Premier Special Soda Mixed Drinks Modelo Agua Fresca Wine Total COGS Concessions Parking VIP General ADA Total COGS Parking Total COGS Gross Profit Operating Expenses Bartenders Cashiers Labor Set-up On-Site Manager Bar/Tent Rental Freezer Truck Supplies/Ice Per Diem - Food Total Operating Costs Net Profit Units 59 8 16 9 29 15 10 5 8 5 54 163 28 59 8 16 9 29 15 10 5 8 5 54 163 28 6 4 2 1 14 1 1 1 Price 15 15 10 15 5 15 5 10 10 10 30 20 15 2.39583333333333 2.675 2.56 2.34166666666667 0.1 2.68333333333333 0.5 2.5 1.20416666666667 2.75 4 4 4 250 250 433 500 40 367 425 125 Total 885 120 160 135 145 225 50 50 80 50 1900 1620 3260 420 5300 7200 141.354166666667 21.4 40.96 21.075 2.9 40.25 5 12.5 9.63333333333333 13.75 308.8225 216 652 112 980 1288.8225 5911.1775 1500 1000 866 500 560 367 425 125 5343 568.1775 Corona Extra Pacifico Modelo Chelada Truly Modelo Agua Frescas Corona Premier 150 19.92 Units 150 50 50 40 20 100 150 179.28 329.28 2.53292307692308 Price 28.75 28.75 32.2 32.1 28.9 32.2 Total 4312.5 1437.5 1610 1284 578 3220 Price Per Unit 2.39583333333333 2.39583333333333 2.68333333333333 2.675 1.20416666666667 1.34166666666667 Item Beer Ready to Drink Soda Water Energy Drinks Tequila For Margaritas and Palomas Barrels for Margaritas and Palomas Mixers Supplies Insurance Ice Bartenders Cashiers Freezer Truck Rental Bar Fronts and Cooler Rentals Set-up Labor and Transport Questions: 1. Is the license full bar or just beer/wine? Units 300 50 30 30 20 24 12 3 3 1 3 3 3 3 23 5 Price 28 32 15.99 10.99 36.99 288 150 1000 500 1500 1500 3000 1750 350 75 1200 Cost 8400 1600 479.7 329.7 739.8 6912 1800 3000 1500 1500 4500 9000 5250 1050 1725 6000 53786.2 Notes In cases (24 each) In cases (24 each) In cases (24 each) In cases (64 each) In cases (24 each) In cases (12 each) Barrels for the Mixed Drinks In days In days Insurance to cover the bar areas In days For the three says For the three says In days Per Unit Per day Type of Cost Variable Variable Variable Variable Variable Variable Variable Variable Variable Fixed Fixed Fixed Fixed Fixed Fixed Fixed Parking Total Units 7200 1200 720 1920 480 700 1800 500 500 Need to order barrels Jockey box rental Ipads Sales Price 8 8 5 5 6 5 12 Revenue Costs Net Profit Split 15 20 Amount 57600 9600 3600 9600 2880 3500 21600 108380 53786.2 54593.8 27296.9 7500 10000 17500 72093.8 36046.9 12015.6333