Loading...
FY 2013 Restaurant_Monthly_UPDATED 09-10-13 Village M North Palm Beach Footl"d Beverage Operatiops(Praliminary) Fiscal Year 2013 Year-to-Date October2012 November 2012 December 2012 January 2013 Febrpary 2013 March 2013 Apri12013 May 2013 June 2013 July 2013 August 2013 TOTAL %of[Mal %of total %oft-I %of total %oft-I %of total %oft-I %of total Sales Oct-12 sales Nov-12 sales Dec-12 sales Jan-13 sales Feb-13 sales Mar-13 sales Apr-13 sales May43 sales Jun-13 %oftmal sales Ju1-13 %of total sales Aug-13 %oftmal sales Year-to-Date %of tatMSales Footl&Beverage $26,68133 64% $39,88010 69% $43,34317 70% $38,71394 66% $29,03632 62/0 $47,11533 68% $41,]5385 66% $29,79997 67% $ 28,74665 66% $ 31,89218 63% $ 29,79271 65% $380,57555 66% Liquor 11,554.46 36% 17,91007 31% 18,34013 36% 19,90132 34% 1],]2165 38% 21,68086 32% 211]633 34% 14,98460 34% 14,]4435 34% 18,96430 37% 1612519 35% 193,11226 34% Miscellaneous Revenue (3876) 0% 179 01% 078 0% 39969 1% (469) 0% 058 01% (1689) 0% (6716) 01% 153 0% 055 01% (157) 0% 27585 01% Total Sales 32197.03 100% 57,800.96 100% 61684.08 100% 59,014.95 100% 46753.28 100% 68,796.77 100% 62913.29 100% 44,62].41 100% 43492.53 100% 50,]6].03 117% 45916.33 100% 573,963.66 100% Ezpenses: Cost of GOOds Sold-Liquor 3,51028 11% 4,87980 8°/a 5,63145 9% 7,03882 12% 5,44]08 12/0 6,90734 10% 5,80743 9% 5,03054 11% 6,37484 15% 3,94950 8°/a 4,97094 11% 59,55702 10% Cost of GOOds Sold-Footl&Beverage 8,75071 2% 14,33717 25% 19,54636 32/0 15,01284 25% 10,91825 23% 20,19858 29% 14,41696 23% 11,85083 27% 12,14491 28% 12,54623 25% 11,6159] 25% 151,34769 26% Personnel 23,59826 73% 25,47687 44% 41,40710 67% 28,19593 48% 2],05455 58% 30,03401 44% 2],23898 43% 23,98448 54% 38,84265 89% 25,30139 50% 24,735]5 54% 315,869.91 55% ONer operating 33,00383 103% 12,57639 22% 11,78288 19% 11,03223 19% 17,267_91 37% 11,16709 16% 9,44814 15% 8,66055 19% 10,40736 24% 9,83734 19% 13,55855 36% 148,74221 26% Capital - 0% 01% 0% 2,25000 4% - 0% - 01% 2,92]4] 5% - 01% 13,74640 32/0 - 01% - 0% 18,92387 3°/a Total Ezpenses 68863.02 5],2]0.23 78367.73 63,529.82 6068].]9 68,30].02 59838.92 49,544.40 81516.10 51,634.46 54881.21 694,440.70 Net _L J2 $ 530.73 $(16,683.65) _L_L4 $113,934.51) $ 489.]5 $ 3,0]4.3] _L_L4 $ 138,023.5]) _L_1867 43) _L_18 966488) _L U20 Liquor COGS a s%of Liquor Sales: 30% 2% 31% 35% 31% 32/o 27% 34% 43% 21% 31% 31% Footl COGS as%of Footl Sales: 42% 36% 45% 39% 38% 43°/o 35% 401% 42% 39°/0 39% 401% Inventory on hantl at entl of current periotl: Liquor Inventory 9,57028 Footl&Beverage Inventory 7,28352 Total Inventory on hantl $16,853.80