Loading...
FY 2014 Restaurant OperationsVillage of North Palm Beach Food and Beverage Operations (Preliminary) Fiscal Year 2014 Year -to -Date Expenses: October 2013 November 2013 December 2013 January 2014 February 2014 March 2014 April 2014 TOTAL of total % of total % of total Cost of Goods Sold - Liquor % of total 9% % of total 9% % of total 9% % of total 9% 6,137.31 Sales Oct -13 sales Nov -12 sales Dec -13 sales Jan -14 sales Feb -14 sales Mar -14 sales Apr -14 sales Year -to -Date % of total sales Food & Beverage $ 27,303.51 66% $ 36,551.78 69% $ 45,015.01 70% $ 36,434.18 68% $ 46,885.31 68% $ 43,647.21 66% $ 45,651.93 68% $ 281,488.93 68% Liquor 13,997.94 34% 16,381.00 31% 19,117.58 30% 17,425.52 32% 22,302.42 32% 22,851.43 34% 21,023.83 32% 133,099.72 32% Miscellaneous Revenue (46.87) 0% 0.27 0% (149.75) 0% (38.64) 0% (9.56) 0% 1.97 0% 0.33 0% (242.25) 0% Total Sales 41,254.58 100% 52,933.05 100% 63,982.84 100% 53,821.06 100% 69,178.17 100% 66,500.61 100% 66,676.09 100% 414,346.40 100% Expenses: Cost of Goods Sold - Liquor 3,774.50 9% 4,501.63 9% 5,707.77 9% 4,958.38 9% 6,137.31 9% 8,602.47 13% 6,152.41 9% 39,834.47 10% Cost of Goods Sold - Food & Beverage 8,661.03 21% 12,860.20 24% 18,612.27 29% 12,416.56 23% 15,507.10 22% 16,381.63 25% 16,739.16 25% 101,177.95 24% Personnel 29,547.08 72% 30,345.27 57% 33,606.14 53% 46,895.81 87% 31,782.65 46% 30,920.09 46% 32,554.95 49% 235,651.99 57% Other operating 13,028.62 32% 8,595.76 16% 11,523.88 18% 16,322.64 30% 9,616.32 14% 13,402.94 20% 14,369.85 22% 86,860.01 21% Capital - 0% 0% 0% 0% - 0% - 0% 0% - 0% Total Expenses 55,011.23 56,302.86 69,450.06 80,593.39 63,043.38 69,307.13 69,816.37 463,524.42 Net $ (13,756.65) _L j3 $ (5,467.22) _L26 $ 6,134.79 $ (2,806.52) _L j3 $ (49,178.02) Liquor COGS as % of Liquor Sales: 27% 27% 30% 28% 28% 38% 29% 30% Food COGS as % of Food Sales: 32% 35% 41% 34% 33% 38% 37% 36% Inventory on hand at end of current period: Liquor Inventory 8,388.26 Food & Beverage Inventory 10,007.07 Total Inventory on hand $ 18,395.33