酒店成本核算表格.xls

1、2007年年7月月每每月月餐餐饮饮饮饮食食成成本本分分析析报报告告员员工工餐餐合合计计食食品品库库食食品品酒酒水水香香烟烟食食品品销销售售收收入入：995,783.00730,598.00259,417.005,768.00 减减：折折扣扣125,448.00125,448.00 净净销销售售收收入入870,335.00605,150.00259,417.005,768.00销销售售成成本本 期期初初库库存存744,206.80331,661.70114,259.10289,529.208,756.80 直直接接采采购购151,248.03143,999.547,248.49 退退货货0.00

2、 出出库库-酒酒水水库库0.00 出出库库-食食品品库库0.00-205216.66 141,548.1160,318.553,350.00 部部门门退退库库0.00.调调入入0.00 调调出出0.00 厨厨房房内内部部调调拨拨0.00 可可用用成成本本合合计计895,454.83126,445.04399,806.75357,096.2412,106.800.00 库库差差调调整整0.00 期期末末库库存存671,853.44253,285.50133,536.30274,937.6410,094.00 实实际际成成本本消消耗耗223,601.39-126,840.46266,270.458

3、2,158.602,012.800.00成成本本扣扣减减 款款待待43,906.8043,906.80 餐餐饮饮试试菜菜0.00外外卖卖0.00 员员工工餐餐费费用用18,048.0018,048.00员员工工赔赔偿偿0.00 报报损损0.00 扣扣减减合合计计61,954.800.0061,954.800.000.000.00 净净销销售售成成本本161,646.59-126,840.46204,315.6582,158.602,012.800.00 食食品品成成本本率率综综合合餐餐饮饮 本本月月 (毛毛）16.23%28.97%27.97%0.00%0.00%本本月月（净净）18.57%33.15%33.76%31.67%34.90%上上月月 预预计计39.00%33.00%32.00%42.00%50.00%年年累累计计#DIV/0!39.21%#DIV/0!#DIV/0!#DIV/0!=