Loading...
FY 2013 Restaurant_ YTD JULY 2013 Village of North Palm Beach Food and Beverage Operations(Preliminary) Fiscal Year 2013 Year-to-Date October 2012 November 2012 December 2012 January 2013 February 2013 March 2013 April 2013 May 2013 June 2013 July 2013 TOTAL %of total %of total %of total %of total %of total %oftotsl %of total %oftotsl Sales Oct-12 sales Nov-12 sales Dec-12 sales Jan-13 sales Feb-13 sales Mar-13 sales Apr-13 sales May-13 sales Jun-13 %of total sales Jul-13 %of total sales Year-to-Date %of total sales Food&Beverage $20,681.33 64% $39,880.10 69% $43,343.17 70% $38,713.94 66% $29,036.32 62% $47,115.33 68% $41,753.85 66% $29,709.97 67% $ 28,746.r5 66% $ 31,802.18 63% $ 350,782.84 66% Liquor 11,554.46 36% 17,919.07 31% 18,340.13 30% 19,901.32 34% 17,721.65 38% 21,680.86 32% 21,176.33 34% 14,984.60 34% 14,744.35 34% 18,964.30 37% 176,987.07 34% Miscellaneous Revenue (38.76) 0% 1.79 0% 0.78 0% 399.69 1% (4.69) 0% 0.58 0% (16.89) 0% (67.16) 0% 1.53 0% 0.55 0% 277.42 0% Total Sales 32,197.03 100% 57,800.96 100% 61,684.08 100% 59,014.95 100% 46,753.28 100% 68,796.77 100% 62,913.29 100% 44,627.41 100% 43,492.53 100% 50,767.03 117% 528,047.33 100% Expenses. Cost of Goods Sold-Liquor 3,510.28 11% 4,879.80 8% 5,631.45 9% 7,038.82 12% 5,447.08 12% 6,907.34 10% 5,807.43 9% 5,039.54 11% 6,374.84 15% 3,949.50 8% 54,586.08 10% Cost of Goods Sold-Food&Beverage 8,750.71 27% 14,337.17 25% 19,546.30 32% 15,012.84 25% 10,918.25 23% 20,198.58 29% 14,416.90 23% 11,859.83 27% 12,144.91 28% 12,546.23 25% 139,731.72 26% Personnel 23,598.20 73% 25,476.87 44% 41,407.10 67% 28,195.93 48% 27,054.55 5B% 30,034.01 44% 27,238.98 43% 23,984.48 54% 38,842.65 89% 25,291.39 50% 291,124.16 55% Other operating 33,003.83 103% 12,576.39 22% 11,782.88 19% 11,032.23 19% 17,267.91 37% 11,167.09 16% 9,448.14 15% 8,660.55 19% 10,407.30 24% 9,837.34 19% 135,183.66 26% Capital - 0% 0% 0% 2,250.00 4% - 0% - 0% 2,927.47 5% - 0% 13,746.40 32% - 0% 18,923.87 4% Total Expenses 68,863.02 57,270.23 78,367.73 63,529.82 60,687.79 68,307.02 59,838.92 49,544.40 81,516.10 51,624.46 639,549.49 Net _L(3 $ 530.73 $(16,683.65) $ (4,514.87) $(13,934.51) $ 489.75 $ 3,074.37 $ 14,916.991 _L_[W_023 $ (857.43) $(111,502.16) Liquor COGS as%of Liquor Sales: 30% 27% 31% 35% 31% 32% 27% 34% 43% 21% 31% Food COGS as%of Food Sales: 42% 36% 45% 39% 38% 43% 35% 40% 42% 39% 40% Inventory on hand at end of current period: Liquor Inventory 9,334.99 Food&Beverage Inventory 7,674.36 Total Inventory on hand $ 17,009.35