餐饮成本核算表模板VIP

表表1 仓仓库库盘盘点点表表 品名单位上日结余进货今日领料今日结余使用备注 精制油桶 油浸金枪鱼罐 生粉包 黄酒包 葡萄干包 魔厨高汤包 鸡粉包 厚饼粉包 烤鸡粉包 南乳淹料包 鱿鱼裹粉包 奶粉包 高精粉袋 大米袋 意大利面包 白葡萄酒瓶 红葡萄酒瓶 白兰地瓶 通心粉包 藏红花包 芝士粉瓶 辣椒仔瓶 水瓜榴瓶 蛋黄酱瓶 浓缩果汁瓶 开心果包 面包糠包 松子包 番茄酱罐 番茄沙司瓶 白胡椒粉瓶 黑胡椒粉瓶 盐包 嫩肉粉瓶 鸡精包 黑橄榄瓶 橄榄油瓶 听装蘑菇听 听装菠萝听 听装杂果听 听装玉米听 香叶包 什香草瓶 百里香瓶 紫苏粉瓶 花椒粉瓶 阿里根奴瓶 香尖草瓶 红椒粉瓶 罗勒叶瓶 成成本本核核算算 品名原料 蒜香面包面包片4片黄油15g蒜末2g荷兰芹末0.5g盐0.2g鸡精0.1 0.50.70.10.10.10.1 怪味薯角薯角180g梅林沙司30ml 2.20.4 香炸洋葱圈洋葱圈8个 1.2 牛肉烧多士面包片3片芝士20g牛肉酱10g 0.41.10.4 香熏烟肉香肠卷培根香肠卷5只 圣女果1只荷兰芹1朵泰式甜辣鸡酱30ml 50.050.050.8 千岛黄金虾凤尾虾6只鸡蛋1只面包糠10g生粉2g千岛酱30ml 3.50.50.10.020.7 紫苏炸鱿鱼鱿鱼须120g紫苏2g鞑靼酱30g 2.20.50.8 柠檬蒜香生蚝生蚝3只调制面包糠30g酱汁3g柠檬角一只圣女果1只 4.50.50.10.30.05 米兰黄金生蚝生蚝4只面包糠10g鸡蛋1只生粉2g 5.80.10.50.02 香草扇贝王扇贝3只葱油汁15g土豆泥60g柠檬角一只荷兰芹1朵 2.70.250.30.30.05 芝士薯球土豆泥30g芝士60g面包糠12g 0.153.30.1 法式焗蜗牛烧制蜗牛6只 蒜香黄油12g 蒜香面包3片 2.90.71 特色烤鸡翅鸡翅4只腌料荷兰芹1朵圣女果1只 4.90.150.050.05 佛罗伦萨香辣翅根翅根2只腌料荷兰芹1朵圣女果1只 1.40.150.050.05 培根金针菇卷培根5片金针菇20g照烧酱30g荷兰芹1朵圣女果1只 3.20.11.50.050.05 佛罗伦萨香辣脆皮鸡手枪腿1只腌料黑椒汁 50.21.5 焗北太平洋野生甜虾甜虾10只奶汁30g芝士10g黄油5g 3.40.60.50.3 佛罗伦萨特色童子鸡童子鸡半只腌料裹粉 半只60.50.5 田园色拉球生菜120g红叶生菜10g苦叶生菜5g红椒圈1只5g 青椒圈1只5g 白洋葱圈1只5g红腰豆5g玉米粒5g黄瓜片3片10g圣女果1只15g千岛酱80g胡萝卜丝5g紫橄榄丝g 0.70.20.10.20.10.050.10.050.050.051.80.10.1 双薯宝贝色拉土豆块80g红薯80g黄瓜30g菠萝30g方腿20g香甜酱20g 0.40.50.10.30.70.5 金枪鱼色拉球生菜120g苦叶生菜10g金枪鱼50g土豆泥50g圣女果2只红粉少许千岛酱80g 0.70.21.50.30.10.051.8 阳光柳橙水果色拉苹果80g菠萝半片35g红提1只5g 猕猴桃半只50g黄桃20g香甜酱30g柳橙酱30g 0.70.30.31.50.40.60.6 烟熏三文鱼色拉烟熏三文鱼3片90g 红叶生菜10g 罗马生菜10g 苦叶生菜10g油醋汁30g 8.80.20.20.21.5 烟熏鸡肉芒果色拉球生菜120g烟熏鸡肉30g 芒果沙沙50g红粉少许千岛酱80g 0.71.21.50.051.8 香甜玉米汤玉米粒100g牛奶60g白汁20g鸡汁1g洋葱末2g蒜末1g黄油2g黄姜粉0.2g鲜奶油2cc水150cc 10.50.50.030.010.010.080.010.05 意大利浓菜汤黄油2g蒜末1g洋葱丁10g胡萝卜10g卷心菜18g番茄丁10g香叶1张茄膏10g水150g通心粉5g荷兰芹末少许 0.080.010.10.10.050.050.050.20.20.05 鸡丝奶油蘑菇汤鸡丝5g奶油30g牛奶100g黄油面料15g黄油3g蘑菇片30g 鸡汁汤120g罗勒叶0.1g 白胡椒粉0.2g洋葱末2g 0.10.90.850.60.120.40.60.050.010.01 青豆芦荟汤青豆100g 鸡汁汤250g(1:7) 芦荟10g奶油5g 110.50.15 香辣茄汁培根意面意面220g黄油15g洋葱末3g蒜末2g辣椒酱5g培根30g茄汁120g盐1g鸡汁水10g红椒丝5g香菜丝2g芝士粉0.2g 1.70.70.010.010.050.81.70.010.10.10.050.05 意大利肉酱面意面220g黄油15g洋葱末3g蒜末2g牛肉酱120g盐0.5g鸡汁水10g芝士粉0.2g 1.70.70.010.012.50.010.10.05 意式腊肠面意面220g精制油10g红尖椒10g蘑菇片20g蒜肉5粒10g腊肠20g荷兰芹末0.1g 1.70.70.10.30.10.80.05 佛罗伦萨菌王菇面意面220g蒜油5g蒜肉3粒6g洋葱末3g金针菇5g蟹味菇5g蘑菇10g香菇10g野山椒3根3g盐1g鸡汁水10g 新鲜荷兰芹末2g 1.70.30.070.010.050.10.150.20.10.050.10.1 鸡肉西兰花奶油紫苏面意面220g黄油15g洋葱末3g蒜末2g西兰花30g鸡肉块60g紫苏酱5g奶油60ml盐0.5g鸡汁水10g芝士粉0.2g 1.70.70.010.010.41.20.41.80.050.10.05 意大利经典蘑菇培根意面意面220g黄油15g蒜末2g洋葱末3g蘑菇片30g培根30g奶油60ml盐1g鸡汁水10g鸡蛋黄1只 1.70.70.010.010.40.81.80.050.10.5 奶油三文鱼芦笋意面意面220g黄油15g蒜末2g洋葱末3g水瓜榴3g芦笋10g三文鱼15g柠檬汁5cc奶油120g盐1g鸡汁水10g荷兰芹末0.2g 芝士粉0.2g 1.70.70.010.010.10.51.50.23.60.050.10.10.05 海鲜天使意面意面220g黄油15g蒜末2g洋葱末3g青口贝1个20g大头虾2个20g 文蛤3个30g鱿鱼须20g 胡萝卜条2根5g 刀豆2根10g番茄汁60ml白葡萄酒5g盐1g鸡汁水10g 1.70.70.010.0110.50.50.50.10.10.80.10.050.1 大虾松仁香草面意面220g黄油10g蒜末2g洋葱末3g虾仁3只30g松子5g松子油6g番茄条3根15g香草酱50g盐0.5g鸡汁水10g芝士粉0.2g 1.70.50.010.011.80.50.80.11.80.0250.10.05 黑胡椒牛柳意面意面220g精制油10g洋葱20g青椒丝3根10g红椒丝3根10g牛柳80g黑胡椒粉0.2g 1.70.20.050.050.12.80.1 香辣酱汁蜗牛饭米饭250g黄油10g蒜末2g胡萝卜丝10g洋葱丝15g蘑菇片30g蜗牛8片40g 特色酱油40cc 0.80.50.010.20.040.42.51 奶油蘑菇鸡肉饭米饭250g橄榄油10g蒜末2g洋葱丁30g鸡肉丁80g蘑菇片30g奶油60ml水100ml黄油10g盐1g鸡汁水10g芝士粉0.2g 0.80.50.010.071.60.41.80.50.050.10.05 菠菜香肠松子饭米饭250g黄油15g松子5g松子油6g腊肠30g菠菜酱60cc盐1g鸡汁水10g色拉米4片10g 0.80.70.50.8110.050.10.7 红酒鸡肉饭米饭250g精制油10g蒜末2g洋葱末3g鸡肉丁80g蘑菇片15g香菇片15g胡萝卜丝15g蜜汁叉烧酱10ml 红酒30ml盐1g鸡汁水10g荷兰芹末0.2g 0.80.50.010.011.60.20.30.30.50.40.050.10.05 威尼斯式渔夫烩饭米饭250g黄油15g蒜末2g洋葱末3g青口贝1个20g大头虾2个20g 文蛤3个30g鱿鱼须20g番茄汁60ml白葡萄酒5g盐1g鸡汁水10g杂菜10g芝士粉0.3g 0.80.70.010.0110.50.50.50.80.10.050.10.20.1 海派味增饭米饭250g黄油15g梅肉80g白味增30g糖2g味淋5g白葡萄酒5g鸡汁水10g球生菜1片10g 0.80.72.510.050.10.10.10.1 芝士培根泡菜饭米饭250g黄油15g奥尔良培根80g 韩国泡菜50g泡菜膏5g芝士10g 0.80.72.80.50.20.56 米兰风行烧肉饭米饭250g黄油15g梅肉80g(3mm)刀豆2根玉米粒5g胡萝卜丝5g烧肉汁25g 0.80.72.50.10.050.051 大虾菠萝焗饭菠萝饭200g菠萝半只虾仁4只40g腰果10g奶汁20g芝士20g 11.520.60.51.1 佛罗伦萨肉酱奶汁焗饭蛋炒饭200g奶汁50g肉酱70g芝士20g 11.21.81.1 那波利培根芝士焗通心粉通心粉150g青椒丁5g红椒丁5g培根15g奶汁50g芝士20g 20.10.10.41.21.1 佛罗伦萨鸡腿排无骨鸡腿排1块(腌制)西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁蜂蜜 3.30.40.30.20.210.5 日式照烧牛仔骨牛仔骨180g西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁 150.40.40.20.21 香煎银鳕鱼配黄油柠檬汁鳕鱼一片西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁 15.60.40.40.20.21 哥伦布猪排配芒果沙司炸猪排1块180g 西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁 4.50.40.40.20.21 沙朗牛排配黑椒汁牛排1块180g洋葱丝30g西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁 120.20.40.40.20.21 菲力牛排菲力牛排1块180g西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁 12.80.40.40.20.21 佛罗伦萨苹果鲷鱼排鲷鱼排2块西兰花35g花菜35g胡萝卜条4根20g杂菜20g酱汁 4.30.40.40.20.21 米兰奶油葡国鸡1/4童子鸡白汁100g鸡汤(1:3)10g芝士10g白胡椒粉1g 蘑菇一个半洋葱5g色拉油30g 22.50.10.50.020.20.031.5 缤纷田园风光(9)匹萨酱40g芝士100g杂菜20g青椒10g 蘑菇 10g 番茄 20g菠萝20g 洋葱10g 0.54.70.20.20.10.20.20.1 缤纷田园风光(6)匹萨酱20g芝士50g杂菜10g青椒g 蘑菇 10g 番茄 20g菠萝20g 洋葱10g 热带雨林特色水果(9) 匹萨酱40g水果酱20g芝士100g 杂果15g 菠萝 20g香蕉片15g 黄桃15g香甜酱 20g 0.50.54.70.50.20.20.20.5 热带雨林特色水果(6) 匹萨酱40g水果酱20g芝士100g 杂果15g 菠萝 20g香蕉片15g 黄桃15g香甜酱 20g 夏威夷浪漫之梦(9) 匹萨酱40g芝士100g火腿15g培根片 15g菠萝 20g香蕉15g香甜酱20g 0.54.70.50.50.20.20.5 夏威夷浪漫之梦(6) 匹萨酱40g芝士100g火腿15g培根片 15g菠萝 20g香蕉15g香甜酱20g 意式精选(9)匹萨酱40g 匹萨片4片（8g）意式各式香肠50g 洋葱粒 10g芝士100g 0.50.510.14.7 意式精选(6)匹萨酱40g 匹萨片4片（8g）意式各式香肠50g 洋葱粒 10g芝士100g 海陆满溢(9) 匹萨酱40g芝士100g 虾仁6只 匹萨片4片蟹柳粒 15g杂菜 20g菠萝15g 0.54.73.50.50.50.20.2 海陆满溢(6) 匹萨酱40g芝士100g 虾仁6只 匹萨片4片蟹柳粒 15g杂菜 20g菠萝15g 金牌超级至尊(9) 匹萨酱40g芝士100g匹萨粒10g 培根10g 牛肉10g鸡肉粒10g洋葱10g青椒10g蘑菇10g番茄粒20g 0.54.70.50.40.50.20.10.20.10.1 金牌超级至尊(6) 匹萨酱40g芝士100g匹萨粒10g 培根10g 牛肉10g鸡肉粒10g洋葱10g青椒10g蘑菇10g番茄粒20g 佛罗伦萨特选匹萨(9)匹萨酱40g芝士100g匹萨粒10g 牛肉粒10g鸡肉粒10g腊肠20g菠萝10g洋葱10g青椒10g蘑菇10g番茄粒10g 0.54.70.50.50.20.70.20.10.20.10.1 佛罗伦萨特选匹萨(6)匹萨酱40g芝士100g匹萨粒10g 牛肉粒10g鸡肉粒10g腊肠20g菠萝10g洋葱10g青椒10g蘑菇10g番茄粒10g 黑椒牛柳饭牛柳(腌制)150g青椒20g红椒10g洋葱30g油20g调味料例汤米饭200g 5.80.10.20.20.30.21.50.5 红烧牛腩牛腩(熟)150g青椒20g红椒10g洋葱30g油20g调味料例汤米饭200g 60.10.20.20.30.21.50.5 水果咕咾肉猪肉(半成品)150g 菠萝30g番茄沙司50g白醋5g调味料例汤米饭200g 5.20.50.70.10.21.50.5 海南鸡饭童子鸡半只(熟) 脂油黄2g生姜2g泰式鸡酱20g脂油黄10g调味料例汤米饭200g 60.10.10.70.30.21.50.5 卤肉饭卤肉150g香菇30g卤蛋1只青椒20g红椒10g调味料例汤米饭200g 4.50.40.70.10.20.21.50.5 滑菇鸡饭鸡胸肉100g杂菌100g青椒20g红椒10g新鲜蘑菇330g调味料例汤米饭200g 2.51.50.10.20.40.21.50.5 栗子排骨饭排骨150g糖水栗子100g青椒20g红椒10g调味料例汤米饭200g 4.540.10.20.21.50.5 鱼香肉丝饭肉丝100g茭白30g胡萝卜丝30g香菇丝10g调味料例汤米饭200g 3.50.20.20.20.21.50.5 咖喱牛腩饭牛腩(熟)150g土豆100g胡萝卜30g调味料例汤米饭200g 60.50.20.21.50.5 司坦利咖喱烩鸡饭鸡腿肉120g土豆100g胡萝卜30g调味料例汤米饭201g 3.50.50.20.21.50.5 蒙特利尔式早餐美式咖啡1杯土豆100g鸡蛋1只培根2片60g腊肠30g水果 1.20.50.5211 建议售价成本毛利率 ￥1.60￥6.0026.67%73.33% ￥2.60￥6.0043.33%56.67% ￥1.20￥8.0015.00%85.00% ￥1.90￥12.0015.83%84.17% ￥5.90￥15.0039.33%60.67% ￥4.82￥18.0026.78%73.22% ￥3.50￥18.0019.44%80.56% ￥5.45￥18.0030.28%69.72% ￥6.42￥18.0035.67%64.33% ￥3.60￥12.0030.00%70.00% ￥3.55￥12.0029.58%70.42% ￥7.00￥18.0038.89%61.11% ￥5.15￥15.0034.33%65.67% ￥1.65￥7.0023.57%76.43% 成成本本核核算算 ￥4.90￥15.0032.67%67.33% ￥6.70￥18.0037.22%62.78% ￥4.80￥15.0032.00%68.00% ￥7.00￥20.0035.00%65.00% ￥3.60￥9.0040.00%60.00% ￥2.50￥9.0027.78%72.22% ￥4.65￥12.0038.75%61.25% ￥4.40￥12.0036.67%63.33% ￥10.90￥28.0038.93%61.07% ￥5.25￥15.0035.00%65.00% ￥2.19￥8.0027.38%72.63% ￥0.89￥8.0011.13%88.88% ￥3.64￥12.0030.33%69.67% ￥2.65￥10.0026.50%73.50% ￥5.28￥12.0044.00%56.00% ￥5.08￥12.0042.33%57.67% ￥3.75￥12.0031.25%68.75% ￥2.93￥12.0024.42%75.58% ￥6.42￥15.0042.80%57.20% ￥6.07￥15.0040.47%59.53% ￥8.62￥18.0047.89%52.11% 芝士粉0.2g 0.05￥6.22￥18.0034.56%65.44% ￥7.40￥18.0041.08%58.92% ￥5.00￥22.0022.73%77.27% ￥5.45￥18.0030.28%69.72% ￥5.88￥18.0032.67%67.33% ￥5.65￥18.0031.39%68.61% ￥4.82￥18.0026.78%73.22% ￥5.37￥18.0029.83%70.17% ￥5.45￥16.0034.06%65.94% ￥5.56￥18.0030.89%69.11% ￥5.20￥18.0028.89%71.11% ￥6.70￥18.0037.22%62.78% ￥5.10￥12.0042.50%57.50% ￥4.90￥18.0027.22%72.78% ￥5.90￥24.0024.58%75.42% ￥17.20￥42.0040.95%59.05% ￥17.80￥38.0046.84%53.16% ￥6.70￥26.0025.77%74.23% ￥14.40￥38.0037.89%62.11% ￥15.00￥42.0035.71%64.29% ￥6.50￥32.0020.31%79.69% ￥6.85￥18.0038.06%61.94% 底胚 1.3￥7.50￥19.0039.47%60.53% ￥3.40￥9.0037.78%62.22% 底胚 1.3￥8.60￥22.0039.09%60.91% ￥3.90￥10.0039.00%61.00% 底胚 1.3￥8.40￥24.0035.00%65.00% ￥3.80￥12.0031.67%68.33% 底胚 1.3￥8.10￥26.0031.15%68.85% ￥3.70￥12.0030.83%69.17% 底胚 1.3￥11.40￥28.0040.71%59.29% ￥5.20￥15.0034.67%65.33% 底胚 1.3￥8.60￥32.0026.88%73.13% ￥3.90￥15.0026.00%74.00% 底胚 1.3￥9.10￥32.0028.44%71.56% ￥4.20￥15.0028.00%72.00% ￥8.80￥26.0033.85%66.15% ￥9.00￥24.0037.50%62.50% ￥8.70￥22.0039.55%60.45% ￥9.40￥26.0036.15%63.85% ￥8.10￥20.0040.50%59.50% ￥6.90￥18.0038.33%61.67% ￥11.00￥28.0039.29%60.71% ￥6.30￥18.0035.00%65.00% ￥8.90￥28.0031.79%68.21% ￥6.40￥18.0035.56%64.44% ￥6.20￥18.0034.44%65.56% 498.905 ￥1,477.0033.78%66.22% 冷库盘点表1 盘点人:日期: 品名单位上日结余进货今日领料今日结余使用备注 生蚝 扇贝 北极甜虾 烟熏三文鱼 青口贝 凤尾虾(26-30) 凤尾虾(41-50) 银鳕鱼 蟹柳棒 烟熏鸡肉 西冷牛排 沙朗牛排 羊排 牛仔骨 鸡中翅 鸡翅根 鸡胸肉 无骨鸡腿排 鱿鱼须 鲷鱼排 童子鸡 冷冻青豆 甜玉米粒 安佳马苏 黄油 薯角 洋葱圈 培根香肠卷 色拉米 芝士香肠 方腿肉 火腿片 匹萨粒 蜗牛 烟熏鸡