月度西厨成本分析(0001).xls
《月度西厨成本分析(0001).xls》由会员分享,可在线阅读,更多相关《月度西厨成本分析(0001).xls(49页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、和和谐谐西西厨厨成成本本分分析析表表趵趵北北西西厨厨成成本本分分析析表表2001.10月份2011.10月份项目收入上月存本月存本月发生成本额成本率收入上月存本月存本月发生成本额成本率牛排412165050681039779890924.00%牛排18684236453589.84634246397.224.83%酱汁4121650324.517572.117247.64.18%酱汁18684215759715872563.88%配餐:41216505296.550398.745102.210.94%配餐:18684291125949.32148924651.713.19%水果41216501
2、235.313907.812672.55.82%水果186842382.68957379.56867.13.68%蔬菜41216500251525151.15%蔬菜186842132.27120562117.21.13%油料4121650659718865293.00%油料18684248921758136444982.41%发包41216502614750.24489.22.06%发包18684234892.718042059.31.10%意面4121650312259022781.05%意面186842260156130014040.75%通心粉412165060172016600.76%
3、通心粉18684250251251500.08%黄油4121650320208017600.81%黄油186842480640128011200.60%鸡蛋4121650280.572907009.53.22%鸡蛋186842151.88633703435.81.84%调料4121650128.3633.5505.20.23%调料186842801134.5253919.50.49%淡奶油、牛奶、玉米粒、玉米羹、等4121652040.47724.25683.82.61%淡奶油、牛奶、玉米粒、玉米羹、等1868421614.42091.12557.52080.81.11%41216518684
4、2412165186842合计412165010689 171947.8 161258.839.12%186842129149598.17498978304.941.91%马马鞍鞍山山西西厨厨成成本本分分析析表表小小吃吃城城西西厨厨成成本本分分析析表表2001.10月份2011.09月份项目收入上月存本月存本月发生成本额成本率项目收入上月存本月存本月发生成本额成本率牛排11899931112632290112949024.78%牛排1166642999.528241784318018.513.08%酱汁118999214.8560.186222.95877.524.94%酱汁116664237
5、338.24072.83971.62.88%配餐:11899910693.29340.8215140.5 16492.8813.86%配餐:1166642750.46124.912333.28958.76.50%水果118999780626.14345.24499.13.78%水果116664569.5487.936743755.62.73%蔬菜11899917220.511631314.51.10%蔬菜1166641942.224442420.81.76%油料11899978336242.16162206.91.85%油料116664899.92889.35188.63199.22.32%发
6、包118999116266.81774.816241.36%发包1166641007.52632.50-1625-1.18%意面1189992522085205640.47%意面116664254.5731026.61208.10.88%通心粉11899970656506550.55%通心粉00.00%黄油118999320320128012801.08%黄油鸡蛋118999107.5193.5228622001.85%鸡蛋调料118999126.4120301307.40.26%调料淡奶油、牛奶、玉米粒、玉米羹、等118999916.31278.822204.51841.981.55%淡奶油
7、、牛奶、玉米粒、玉米羹、等11899900.00%1189990.00%合计118999140191253350374.451860.443.58%合计1378035986.99287.13424930948.822.46%#DIV/0!淄淄博博西西厨厨分分析析表表高高新新店店西西厨厨成成本本分分析析表表2011.10月份2011.10月份收入上月存本月存本月发生成本额成本率项目收入上月存本月存本月发生成本额成本率项目8495628241950.32042321296.725.07%牛排4661352484317101931112423.86%牛排84956338.223.83437.2375
8、1.64.42%酱汁46613559.6663.123412237.54.80%酱汁849566124.96596.612778.112306.414.49%配餐:466132351.92669.756401.16083.2513.05%配餐:84956413.97543871.43531.34.16%水果4661320724.45%水果8495671.83919311963.82.31%蔬菜46613116.340.25%蔬菜849562632.534938687.50.01%油料466133920.84%油料8495673581113.61128.61.33%发包46613788.81.6
9、9%发包84956781567807020.83%意面466136851.47%意面84956252050550.06%通心粉466131000.21%通心粉8495632016096011201.32%黄油466133200.69%黄油84956117.61891237.51166.11.37%鸡蛋46613695.681.49%鸡蛋8495636.763.5178151.20.18%调料46613560.61.20%调料淡奶油、牛奶、玉米粒、玉米羹、等849562356.41664.11788.62480.92.92%淡奶油、牛奶、玉米粒、玉米羹、等352.83#DIV/0!其他#DIV/
10、0!849569287.18570.736638.337354.743.97%合计466138159.5765018935.1 19444.7541.72%合计小小吃吃城城西西厨厨成成本本分分析析表表2011.10月份成本率收入上月存本月存 本月发生成本额成本率差额1085806602736278722579623.76%2579610858098536596255245.09%55241085807612697016488.817130.815.78%17130.8108580527732490146964.32%469610858005355350.49%53510858023792890
11、308425732.37%257310858081316127010350.95%10351085805857211706560.60%656108580075750.07%7510858089648064010560.97%10561085801141942678.92598.92.39%2598.910858035571786164834193.15%3419108580486.9486.90.45%486.91085800.00%1085800.00%10858083701024250322.848450.844.62%高高新新店店西西厨厨成成本本分分析析表表1010月月份份西西 厨厨
12、成成 本本 分分 析析和和谐谐趵趵北北马马鞍鞍山山小小吃吃城城淄淄博博高高新新项目西厨成本额成本率平均差额西厨成本额成本率平均差额西厨成本额成本率平均差额西厨成本额成本率平均差额西厨成本额成本率平均差额西厨成本额成本率平均差额西厨收入4121651868421189998495646613108580牛排9890924.00%-132546397.224.83%9592949024.78%55121296.725.07%6361112423.86%-2122579623.76%-609酱汁172484.18%-77472563.88%-9135877.54.94%6743751.64.42%3
13、72237.54.80%19955245.09%776配餐:4510210.94%-727824651.713.19%90716492.913.86%137012306.414.49%15106083.2513.05%15917130.815.78%3332水果126733.07%-20996867.13.68%1714499.13.78%2343531.34.16%48720724.45%40246964.32%805蔬菜25150.61%-11682117.21.13%4481314.51.10%2511963.82.31%1205116.340.25%-3005350.49%-435油料
14、65291.58%-81844982.41%11682206.91.85%86879.51.04%-6353920.84%-43925732.37%638发包4489.21.09%-2962059.31.10%-11016241.36%2421128.61.33%142788.81.69%24810350.95%-226意面22780.55%-42714040.75%1785640.47%-2177020.83%1446851.47%3796560.60%-57通心粉16600.40%5011500.08%-3766550.55%320550.06%-1841000.21%-31750.07%
15、-230黄油17600.43%-110311200.60%-17812801.08%45311201.32%5303200.69%-410560.97%302鸡蛋7009.51.70%-3493435.81.84%10022001.85%761166.11.37%-351695.681.49%-1372598.92.39%660调料505.20.12%-2017919.50.49%-224307.40.26%-421151.20.18%-369560.61.20%27534193.15%2755淡奶油、牛奶、玉米粒、玉米羹、等5683.81.38%5022080.81.11%-27018421
16、.55%3451608.91.89%540352.830.76%-234486.90.45%-879合计16125939.12%-937778304.941.91%95351860.443.58%259537354.743.97%218319444.841.72%14748450.844.62%3499水果沙拉成本人数人均人数人均人数人均人数人均人数人均人数人均95391.5948981.8334531.6822812.4112961.6931281.67酱汁分析单位购牛排份数购酱汁斤数购酱汁金额标准应用量斤数用量差额均价标准差额单位购牛排份数购酱汁斤数购酱汁金额标准应用量斤数用量差额均价标准
17、差额和谐84302677.51535675-95克/份1601.710765.73526170小吃城1891592.0343775-95克/份359.292335.805411351趵北42741229.5715875-95克/份812.064175.821882430淄博967394.0234175-95克/份183.732105.941621249马鞍山 26431078.0623375-95克/份502.175765.7823329高新25811008.5596375-95克/份490.395185.912743063分析:(1)水果沙拉人均成本如果按趵北为标准,马鞍山、淄博、高新低于0
18、.15元/人基本在合理数之内,和谐低于0.24元/人小吃城高于0.58元/人*2281=1323元 (2)酱汁:按每份标准用量75-95克计算,按最高标准用量95/份,各店都高于标准用量,总金额17593元 (3)西冷牛排:牛肉价格上涨2元/斤,每份上涨0.74元*20786=15397元,出品率下降0.1每份上涨0.324元*20786=6735元,两项合计上涨22132元1111 月月 份份 西西 厨厨 成成 本本 分分 析析和和谐谐趵趵北北马马鞍鞍山山小小吃吃城城淄淄博博高高新新项目标准西厨成本额营业额成本率标准差额西厨成本额营业额成本率标准差额西厨成本额营业额成本率标准差额西厨成本额营
19、业额成本率标准差额西厨成本额营业额成本率标准差额西厨成本额营业额成本率标准差额西厨收入5340份2495352952份1275962013份888941469份751151532份776212383份109803牛排5916423.71%3154624.72%2205024.80%1539420.49%牛排盘盈53份1828223.55%2623923.90%配餐:6.954389817.59%678519838.815.55%-67816537.218.60%25479872.413.14%-337974512.55%-90218908.917.22%2347酱汁份2 9989.94.00%
20、-6903192.32.50%-271239624.46%-641844.82.46%-10932477.63.19%-58641303.76%-636油料(沙拉0.13份0.4856042.25%304129302.30%151317872.01%82128293.77%2124885.41.14%15038783.53%2734鸡蛋 份0.6546561.87%11852182.51.71%26416281.83%320877.51.17%-77349.20.45%-64717891.63%240发包 份0.58 2827.61.13%-2701316.31.03%-3961169.21.
21、32%2857.81.14%67540.97%-13512631.15%-119水果沙拉 份1.9106054.25%45943943.44%-121552995.96%147439805.30%11892625.453.38%-28547304.31%202红茶红酒大雪碧份0.1115.80.05%-41858.70.05%-2373060.34%105209.20.28%62375.80.48%223412.50.38%174意面通心粉份0.3523620.95%4938340.65%-1999131.03%2083360.45%-1785500.71%1413781.25%544牛奶淡奶
22、黄油面粉份0.42743.51.10%60818481.45%66714731.66%6681353.31.80%76610961.41%483971.50.88%18其他+黄油蒜蓉0.17+沙拉酱0.30.494994237730831637-986-2415.2-3135631.55-119356.9-811西厨合计10306251384.838587.225266.42802745147.9金额/份小吃成本额销售份数标准差额(份小吃成本额销售份数标准差额(份小吃成本额销售份数标准差额(份小吃成本额销售份数标准差额(份小吃成本额销售份数标准差额(份小吃成本额销售份数标准差额(份薯条份1.5
23、2 1347.596982770463-44412.5254-17316.5160-48789.25482-3739927816鸡柳份3.16 194.45675222.2555-15123.8832-700088.523-5133475鸡米花份3.61802.9198-24607.635-133290.7867-14206.6570286.4460-1940193-18烤翅份6 2060.3327-161072164-15519.25892535.583-6251.2537-5888140-8骨肉相连份1.8 505.252898322.51801120.466-114069-9432622
24、6177163蝴蝶虾4.45 740.92156-104451077178.336-412224-375.1318154955-68小吃合计5651.33439.351645.111320.61533.5723961.38%#DIV/0!0.00%#DIV/0!0.00%#DIV/0!0.00%#DIV/0!0.00%#DIV/0!0.00%#DIV/0!合计0.00%#DIV/0!54577.142.77%#DIV/0!0.00%#DIV/0!27111.236.09%#DIV/0!30504.639.30%#DIV/0!49277.944.88%#DIV/0!水果沙拉成本人数人均人数人均人
25、数人均人数人均人数人均人数人均#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!酱汁分析单位购牛排份数购酱汁斤数购酱汁金额标准应用量斤数用量差额均价标准差额单位购牛排份数购酱汁斤数购酱汁金额标准应用量斤数用量差额均价标准差额和谐75-95克/份00#DIV/0!#DIV/0!小吃城75-95克/份00#DIV/0!#DIV/0!趵北75-95克/份00#DIV/0!#DIV/0!淄博75-95克/份00#DIV/0!#DIV/0!马鞍山75-95克/份00#DIV/0!#DIV/0!高新75-95克/份00#DIV/0!#DIV/0!分析:(1)-2-3累累计
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 月度 成本 分析 0001
限制150内