Loading...
FY 2013 Restaurant_May 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 TOTAL %of total %of total %of total %of total %of total %of total %of total %of total 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 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% $ 290,234.01 67% 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% 143,278.42 33% Miscellaneous Revenue (38.76) 0% 1.79 0% 0.78 0% 399.69 1% (4.69) 0% 0.58 0% 0.06 0% (67.16) 0% 292.29 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,930.24 100% 44,627.41 100% 433,804.72 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% 44,261.74 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,776.15 26% 114,956.90 26% Personnel 23,598.20 73% 25,476.87 44% 41,407.10 67% 28,195.93 48% 27,054.55 58% 30,034.01 44% 27,238.98 43% 23,979.48 54% 226,985.12 52% 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,356.42 19% 114,634.89 26% Capital - 0% 0% 0% 2,250.00 4% - 0% - 0% 2,927.47 5% - 0% 5,177.47 1% Total Expenses 68,863.02 57,270.23 78,367.73 63,529.82 60,687.79 68,307.02 59,838.92 49,151.59 506,016.12 Net $(36,665.99) $ 530.73 $(16,683.65) $ (4,514.87) $(13,934.51) $ 489.75 $ 3,091.32 $ (4,524.18) $ (72,211.40) Liquor COGS as%of Liquor Sales: 30% 27% 31% 35% 31% 32% 27% 34% 31% Food COGS as%of Food Sales: 42% 36% 45% 39% 38% 43% 35% 40% 40% Inventory on hand at end of current period: Liquor Inventory 9,335.68 Food&Beverage Inventory 8,568.98 Total Inventory on hand $ 17,904.66