各部门成本费用核定表.xls

20082008年年餐餐饮饮部部毛毛利利对对比比分分析析表表月份 项目中餐烧味西餐点心出品部小计水吧楼面茶位2楼VIP房和6楼KTV和棋牌室餐饮部合计营业收入2月825,974.6089,464.7082,900.00998,339.30138,769.4033,951.0027,024.001,198,083.703月836,515.5098,668.6092,459.401,027,643.50171,783.5042,473.0023,552.001,265,452.004月855,944.78106,473.2088,649.001,051,066.98181,933.0035,079.4040,507.201,308,586.585月1,164,261.09128,214.80109,250.501,401,726.39220,188.9039,249.0046,120.001,707,284.296月1,233,788.09137,448.40126,139.501,497,375.99288,611.6041,320.0073,881.001,901,188.597月1,319,979.35145,537.10129,955.601,595,472.05292,088.9245,991.1568,778.402,002,330.528月1,395,387.90154,513.20133,745.001,683,646.10252,169.4042,021.0056,756.002,034,592.509月1,350,440.00146,705.40102,440.001,599,585.40249,130.4037,675.0044,076.001,930,466.80营业成本2月314,708.6943,968.6922,890.1544,340.04425,907.57173,511.772,156.00601,575.343月281,464.3047,284.4933,782.3655,345.22417,876.37178,007.774,421.90600,306.044月305,598.6943,014.9835,308.9353,895.58437,818.18196,522.724,541.46638,882.365月373,625.2961,891.1040,799.2759,661.64535,977.30238,683.603,708.16778,369.066月377,572.5072,362.8940,383.3765,332.63555,651.39272,995.745,501.44834,148.577月369,819.1774,731.4934,567.9661,599.33540,717.95220,004.813,703.68764,426.448月458,057.9679,652.4947,324.7673,480.65658,515.86242,206.906,543.13907,265.899月427,548.4781,529.5542,755.6068,306.60620,140.22216,197.394,815.65841,153.26毛利2月467,297.2266,574.5538,559.96572,431.73-34,742.3731,795.0027,024.00596,508.363月507,766.7164,886.2437,114.18609,767.13-6,224.2738,051.1023,552.00665,145.964月507,331.1171,164.2734,753.42613,248.80-14,589.7230,537.9440,507.20669,704.225月728,744.7087,415.5349,588.86865,749.09-18,494.7035,540.8446,120.00928,915.236月783,852.7097,065.0360,806.87941,724.6015,615.8635,818.5673,881.001,067,040.027月875,428.69110,969.1468,356.271,054,754.1072,084.1142,287.4768,778.401,237,904.088月857,677.45107,188.4460,264.351,025,130.249,962.5035,477.8756,756.001,127,326.619月841,361.98103,949.8034,133.40979,445.1832,933.0132,859.3544,076.001,089,313.54毛利率2月56.58%74.41%46.51%57.34%-25.04%93.65%100.00%49.79%3月60.70%65.76%40.14%59.34%-3.62%89.59%100.00%52.56%4月59.27%66.84%39.20%58.35%-8.02%87.05%100.00%51.18%5月62.59%68.18%45.39%61.76%-8.40%90.55%100.00%54.41%6月63.53%70.62%48.21%62.89%5.41%86.69%100.00%56.12%7月66.32%76.25%52.60%66.11%24.68%91.95%100.00%61.82%8月61.47%69.37%45.06%60.89%3.95%84.43%100.00%55.41%9月62.30%70.86%33.32%61.23%13.22%87.22%100.00%56.43%制表：Vivi7 7月月份份营营业业收收入入对对比比表表部部门门代代码码总总部部分分部部7 7月月份份6 6与与7 7对对比比%8 8月月份份7 7与与8 8对对比比%09休闲部康乐收入30,027.703.99%25,802.40-14.07%10前厅部净桑收入128,450.40-3.84%142,964.2011.30%11餐饮部楼面茶位收入45,991.1511.30%42,021.00-8.63%11餐饮部VIP房KTV棋牌收入68,778.40-6.91%56,756.00-17.48%18餐饮部水吧收入292,088.921.20%252,169.40-13.67%餐饮部小计406,858.470.75%519,713.0027.74%12.01出品部中厨、烧味收入1,319,979.356.99%1,395,387.905.71%12.02出品部西厨收入145,537.105.88%154,513.206.17%12.03出品部点心收入129,955.603.03%133,745.002.92%12出品部小计1,595,472.056.55%1,683,646.105.53%14.01.01保健部按摩收入4,363,561.639.94%4,181,218.10-4.18%14.01.03保健部中医收入329,038.608.58%346,369.405.27%14.01.04保健部脑健康收入3,960.00按摩项目小计4,692,600.239.84%4,531,547.50-3.43%14.02.01保健部足浴收入1,672,550.1018.39%1,667,136.00-0.32%14.02.04保健部推背收入840.002.44%710.00-15.48%14.02.02保健部美发收入30,018.0021.61%26,776.00-10.80%14.02.03保健部美甲收入31,384.0017.48%29,889.00-4.76%大堂项目小计1,734,792.1018.42%1,724,511.00-0.59%保健部收入6,427,392.3312.03%6,256,058.50-2.67%14.01.02保健部SPA项目收入275,746.9023.23%314,822.4014.17%15.02楼层部客房收入418,965.403.09%432,050.503.12%合计9,282,913.2510.10%9,375,057.100.99%部门成本项目7月份成本定额7月份实际成本7月实际成本占收入比例8月份实际成本8月实际成本占收入比例保健部按摩耗材12720.8613405.040.31%14694.870.35%楼层部按摩房成本7891.368213.650.19%10568.860.25%制表：Vivi9 9月月份份8 8与与9 9对对比比%27,879.008.05%144,543.401.10%37,675.00-10.34%44,076.00-22.34%249,130.40-1.21%503,303.80-3.16%1,350,440.00-3.22%146,705.40-5.05%102,440.00-23.41%1,599,585.40-4.99%3,864,649.20-7.57%375,076.008.29%5,636.0042.32%4,245,361.20-6.32%1,507,124.00-9.60%670.00-5.63%24,516.00-8.44%21,628.40-27.64%1,553,938.40-9.89%5,799,299.60-7.30%370,176.0017.58%430,243.30-0.42%8,875,030.50-5.33%9月份实际成本9月实际成本占收入比例14,937.160.39%7,607.580.20%9 9月月份份实实际际成成本本明明细细表表部门代码总部分部7月领料7月盘点8月领料8月盘点09休闲部休闲部（赠烟）3310219.763216.5203.9休闲部（用品）8692.05865.528663.092665.0610前厅部前厅部86473.816099.9887701.465682.3611餐饮部楼面（调味品）5605.451414.285103.471092.11楼面（用品）15775.83059.6721443.82789.9912出品部出品部（用品）8660.3508535.150出品部（毛利）12.01出品部中厨（用品）5369.736864.5中厨（毛利）12.02出品部西厨（用品）1328.5910.65西厨（毛利）12.03出品部点心（用品）1851.12589点心（毛利）12.04出品部烧味（用品）111171烧味（毛利）17员工食堂员工食堂（食品）139804.413267.94138112.963159.85员工食堂（用品）1741.56125.361278.18100.5913管家部管家部48669.561004.3549538.0553682.5113.01管家部洗衣房（洗涤品）3311525942.173087729947.24洗衣房（物料用品）56571.81558.2513.02管家部组（清洁品）1443228329.3816101.823735.27组（清洁用具）1117.5161100114保健部保健部31720.0415478.319240.3223310.8514.01.01保健部按摩18093.14688.0614760.74753.8914.01.02保健部SPA9020.974533.041461.223571.7514.01.03保健部中医38540.515.75保健项目合计8341.3914.02.01保健部足浴杂项1829.97251.411845.91628.0514.02.04保健部推背60.923774.9614.02.02保健部美发9254104.210953947.5614.02.03保健部美甲14661840.67977.5大堂项目合计6628.0715楼层部楼层部12177.34395.8116804.773358.7115.01楼层部按摩房8806.7593.059341.12865.3115.02楼层部客房3370.63802.767463.652493.416美容部美容部236.2696.518水吧用品2346.823392合计466440.48176809.43457844.54183026.07制表：vivi8月成本9月领料9月盘点9月成本9-8成本3232.3631676192751.9-480.466863.556641.741653.967652.84789.2988119.0880692.099747.7676626.69-11492.395425.645926.792073.2454945.655-479.9921713.4816672.112099.1217362.98-4350.508535.1510753.83010753.832218.68000.006864.56249.16249.1-615.40000.00910.65372.7372.7-537.95000.005893601.133601.133012.13000.00171530.9530.9359.90000.00138221.05122440.414321.53121278.73-16942.321302.951706.841521655.43352.4856859.8969015.188788.3433909.27-22950.6226871.9355637.66584719737.84-7134.098130.05651.35967.6-5316.3-13446.3520695.9111457.316901.7418290.83-2405.0811621268.9721196.934.9036891.2935016.7214416.1821550.81-15340.4814694.8713145.752962.4814937.16242.292422.512703.261237.082704.19281.6824.753651.7527.0017142.1315885.014199.5617693.1550.97469.262089.51496.782220.771751.5122.9648.826.163.201251.6458832531282.5630.92863.17569.21218.48328.22-534.952607.033246.76017.063857.711250.6817841.8711866.313059.8412165.18-5676.699068.867260.51518.247607.58-1461.288773.014605.82541.64557.6-4215.41696.51014.481014.48317.9833923122.83122.8-269.20511830.04497934.88239212.4414720.49-97109.545各各部部门门成成本本费费用用考考核核指指标标核核定定表表部门代码总部核算分部7月：42532人7月：42532人7月份完成情况8月：41610人8月完成情况9月：38713人9月完成情况按领货金额人均消费按扣除盘点存货后成本人均消费按领货金额 按实际消耗实际消耗成本或毛利人均消费8月对比7月增减%实际消耗成本或毛利人均消费9月-8月增减额9月对比8月增减%人均消费增减额09休闲部休闲部（赠烟）3310.000.0783090.240.1-8.48%-14.55%3232.360.0784.60%2751.900.071-480.46-14.86%-0.01休闲部（用品）8692.057826.5345.76%31.25%6863.55-12.30%7652.84789.2911.50%10前厅部前厅部86473.81 2.03380373.831.923.03%14.35%88119.082.1189.64%76626.691.98-11492.39-13.04%-0.1411餐饮部楼面（调味品）5605.454191.1728.84%-3.67%5425.6429.45%4945.655-479.99-8.85%楼面（用品）15775.812716.131.20%-18.43%21713.4870.76%17362.98-4350.50-20.04%12出品部出品部（用品）8660.358660.3568.45%68.45%8535.15-1.45%10753.832218.6825.99%出品部（综合毛利）66.11%-100.00%14.07%60.89%-5.22%61.23%0.34%12出品部中厨（用品）5369.735369.7345.37%45.37%6864.527.84%6249.1-615.40-8.96%中厨（毛利）66.32%-100.00%12.95%61.47%-4.85%62.30%0.83%12出品部西厨（用品）1328.51328.5147.73%147.73%910.65-31.45%372.7-537.95-59.07%西厨（毛利）76.25%-100.00%17.09%69.37%-6.88%70.86%1.49%12出品部点心（用品）1851.121851.12162.27%162.27%589-68.18%3601.133012.13511.40%点心（毛利）52.60%-100.00%25.08%45.06%-7.54%33.32%-11.74%12出品部烧味（用品）111111-45.91%-45.91%17154.05%530.9359.90210.47%烧味（毛利）与中餐合并与中餐合并与中餐合并与中餐合并与中餐合并与中餐合并与中餐合并与中餐合并17员工食堂员工食堂（食品）139804.46.896136536.476.72.60%0.20%138221.056.7561.23%121278.736.06-16942.32-12.26%-0.69员工食堂（用品）1741.561616.2054.30%43.19%1302.95-19.38%1655.43352.4827.05%13管家部管家部48664.5-12334.8511.90%-128.36%56859.89-560.97%33909.27-22950.62-40.36%13管家部洗衣房（洗涤品）33115 0.7797172.830.219.68%-74.08%26871.930.646274.63%19737.840.510-7134.09-26.55%-0.14洗衣房（物料用品）0-6566.8-100.00%-615.12%8130.05-223.81%-5316.3-13446.35-165.39%13管家部组（清洁品）14432 0.339-13897.38-018.98%-214.57%20695.910.497-248.92%18290.830.472-2405.08-11.62%-0.02组（清洁用具）1117.5956.5-53.70%-60.37%116221.48%1196.934.903.00%14保健部保健部31720.0416241.7495.71%0.21%21219.1630.65%21550.81331.651.56%14.01.01保健部按摩18093.113405.0442.23%5.38%14694.879.62%14937.16242.291.65%14.01.02保健部SPA9020.974487.9334.36%-33.16%2422.51-46.02%2704.19281.6811.63%14.01.03保健部中医38538524.75-93.57%51.7527.00109.09%按摩项目小计27499.0718277.97116.17%43.69%17142.13-6.21%17693.1550.973.21%14.02.01保健部足浴杂项1829.971578.56-20.09%-31.07%1939.2622.85%2220.77281.5114.52%14.02.04保健部推背-60.92-100.00%-161.69%22.96137.69%26.163.2013.94%14.02.02保健部美发925-3179.210.52%-479.86%1251.64139.37%1282.5630.922.47%14.02.03保健部美甲1466-374.67461.49%-243.50%863.17330.38%328.22-534.95-61.98%大堂项目小计4220.97-2036.2321.06%-158.40%4077.03300.22%3857.71-219.32-5.38%15楼层部楼层部12177.37781.49-2.98%-38.01%18114.13132.78%12165.18-5948.95-32.84%15.01楼层部按摩房8806.78213.6510.34%2.91%9341.1213.73%7607.58-1733.54-18.56%楼层部客房3370.6-432.16-26.25%-109.46%8773.012130.04%4557.6-4215.41-48.05%16美容部美容部236.2236.2-59.93%-59.93%696.5194.88%1014.48317.9845.65%18水吧水果136409.43 3.207136409.43 3.2116.84%16.84%132886.63.194-2.58%117944.73.05-14941.90-11.24%-0.15用品2346.822346.8230.27%30.27%339244.54%3122.8-269.20-7.94%Page 6