Loading...
FY 2013 Restaurant_Monthly 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 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 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% $ 218,770.19 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% 107,117.49 33% Miscellaneous Revenue (38.76) 0% 1.79 0% 0.78 0% 399.69 1% (4.69) 0% 2.58 0% 361.39 0 Total Sales 32,197.03 100% 57,800.96 100% 61,684.08 100% 59,014.95 100% 46,753.28 100% 68,798.77 100% 326,249.07 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% 33,414.77 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,196.30 29% 88,761.57 27 Personnel 23,598.20 73% 25,476.87 44% 41,407.10 67% 28,195.93 48% 27,054.55 58% 27,243.01 40% 172,975.66 53% Other operating 33,003.83 103% 12,576.39 22% 11,782.88 19% 11,032.23 19% 16,817.91 36% 10,736.13 16% 95,949.37 29% Capital - 0% 0% 0% 2,250.00 4% - 0% - 0% 2,250.00 1 Total Expenses 68,863.02 57,270.23 78,367.73 63,529.82 60,237.79 65,082.78 393,351.37 Net _L(2 $ 530.73 $(16,683.65) _L_E,514.871 $(13,484.51) $ 3,715.99 $ (67,102.30) Liquor COGS as%of Liquor Sales: 30% 27% 31% 35% 31% 32% 31 Food COGS as%of Food Sales: 42% 36% 45% 39% 38% 43% 41 Inventory on hand at end of current period: Liquor Inventory 9,325.19 Food&Beverage Inventory 8,083.96 Total Inventory on hand $ 17,409.15