酒店成本核算表格.xls

酒店成本核算表格.xls

《酒店成本核算表格.xls》由会员分享，可在线阅读，更多相关《酒店成本核算表格.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出出库库-酒酒水水库库0.00出出库库-食食品品库库0.00-205216.66141,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.4582,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!

=