投料成本终极版

序号菜品出库金额（斤）序号菜品出库金额（斤）羊肉片0土豆0羊腿222.2黄蘑0五花肉1红椒123.475猪颈肉0.8青椒82.045前肘1.2葱80.644排骨482.8香葱31.118里脊0豆腐0月牙骨0干豆腐0牛腩0日本豆腐0牛通脊240.3木耳63.06牛肚23.8白玉菇0猪手85蟹味菇0猪皮0茄子204金茸0紫薯0脊骨0地瓜0牛腱子0地瓜球0牛元宝0玉米粒0腱子筋0四季豆325.5猪颈肉0.8黄豆芽59.50绿豆芽73.2鸡脯肉0黄瓜555.2虾仁121.8酸菜1.2鱿鱼0四川酸菜64百叶23.8粉丝0.2鸡翅中0香菇3.345肺子0日本小土豆0肚头0香芋卷0猪肚0水晶粉0干炸江虾0蒜苗0鸳鸯贝0芥兰216黄玉参0蛰皮0小黄花鱼0冬瓜0三文鱼0魔芋粉5海肠0蛰头0鸡爪0木瓜0鸡胗0鲜奶0大肠0胡萝卜9胖头鱼头0烤麸0胖头鱼尾204青笋2.4鸡心74梅菜笋丝1.476午餐肉26.894手剥笋0腊肉40.6花生米0鸭头1.338松花蛋0猪腰子223.8水晶梨0墨鱼嘴86.5黄豆0鸡腿73.1臭菜0干虾干4.84紫生菜0大虾101.5西生菜5550绿萝卜0金针蘑0白菜0材料使用核对表填制日期：年月日报表人：材料使用核对表填制日期：年月日报表人：韭菜0哈密瓜0序号菜品出库金额（斤）序号菜品出库金额（斤）芽菜21.7小柿子5.5脆肠6.4葡萄0圆葱143.2橙子0薯条11.15西瓜0菠萝罐头62.7菠菜0杏鲍菇95.2泰椒21.51紫苏叶2.12香菜0苹果11法香0紫甘蓝2.2毛葱8.88蒜台70.4茶树菇304.5西芹0.86香芹0西兰花5豆花0.004鸭血95.2鸡蛋80.16肥肠23.8蛋黄24.79荷兰豆146娃娃菜0.002腊肠21.5鲤鱼465苦瓜91.2腊鸭121.8油麦菜291.36鳝鱼84.7菜心561大头菜162.4响螺片58.4油菜377.9银芽17.52芋头231角瓜1.7茼蒿338萝卜咸菜4.4梅肉70.4泡姜13.8杭椒112.8合计填制日期：年月日报表人：填制日期：年月日报表人：材料使用核对表材料使用核对表菜系综合毛利生啫/上杂60.96%川菜56.63%凉菜56.02%鲁菜61.11%粤菜48.40%综合毛利56.62%菜品编码菜名菜品成本售价毛利率毛利菜品编码菜名菜品成本售价毛利率毛利41860.96%254.80川菜18.21201水煮鱼21.855862.33%3953.31%20.7921627.399.903269.06%22.10酸菜鱼20.61217飘香一锅满32.245857.87%4857.07%44.41%3214.3311.003467.64%23.002950.59%干锅茶树菇211毛血旺3853972.21%10.8428.16蒜蓉粉丝娃娃菜14.675844.60%2977.16%22.38牛眼贝蒸水蛋63.39%16.4841.93%15.932622.07巴蜀爆全腰2873.18%20.492473832.137.8628梅菜扣肉84047.518405840360.77%17.0113.4825.76虾酱蒸豆花84149.526.6271.95%20.1465.22%36.1518.52250山椒炒鸡心10.9928秘制鱼头24.788407513肘花蒸酸菜13.223825.874858.58%28.12251巴蜀爆脆肠13.592851.48%14.4119.8819.75干锅鸭头15.533859.14%22.47203干煸四季豆8.2513.52生啫/上杂生啫酸菜五花肉81048103生啫金针木耳8102生啫排骨2870.54%39456.63%2848.28%14.48223.11生啫大肠8106生啫鸡胗8105生啫茶树菇五花肉8101菜品编码菜名菜品成本售价毛利率毛利菜品编码菜名菜品成本售价毛利率毛利463清炒荷兰豆464蒜蓉荷兰豆菜品编码菜名菜品成本售价毛利率毛利475.7617.353214.65479XO小瓜炒猪颈肉粤菜小计98348.40%22.41466白灼三鲜45.78%2662.97%16.373637.76%13.599.63416芥兰清炒424芥兰白灼9.6336.66%9.632256.24%12.3716.372662.97%6.538.8015.20421西生菜蚝油423芥兰蒜蓉24428西生菜白灼2258.03%17.472427.22%12.132244.88%9.8712.779.23430菜心清炒10.6211.38422菜心白灼429菜心蒜蓉2248.29%2469.87%6.482473.00%17.5219.5016.777.23418蒜蓉油麦菜425清炒油麦菜731苦瓜煎蛋2666.70%433苦瓜蒜蓉8.502869.66%17.348.668.662869.08%19.34432苦瓜清炒2945.89%465腊味荷兰豆4.23%1.6113.3115.6914.122849.59%13.8834.57%9.68475星级红豆煨猪手3830.10%473财神印度干炒鸡36.3938478葡京小炒皇18.374811.4426.5618.322814.65%5.57472芙蓉奶香虾球32.433829.6361.73%37.14%14.118.712868.91%19.2923.893844.92%21.5616.803855.80%21.2026.44483654.47%19.6138.39682845.88%12.8543.54%29.613860.80%23.102860.23%16.87476泰国紫苏墨鱼嘴403青瓜小炒411杏鲍菇牛柳杭椒牛柳445豉汁焗小排444菠萝咕咾肉14.9011.1315.1544116.39458蛋黄焗香芋408XO酱香茄盒413炭烧羊腿439梅菜肉松茼蒿芽菜品编码菜名菜品成本售价毛利率毛利菜品编码菜名菜品成本售价毛利率毛利392301627.114.89323027300441.55%36.09%17.32凉菜3833013036鲁菜84.00%14.96黄蘑土豆片5.622476.56%18.38肥羊金针蘑21.04364826.88大妈扒全茄4.702883.20%23.30乾坤一品素5.123259.56%熏酱拼盘19.033849.93%18.9730.6859.57%21.4426.38奶香三宝1.632894.20%新派三丝14.563622.64388农家小炒皇8.382971.12%20.62美级蒜香翅15.3638香熏脊骨9.741845.90%8.263022肺片炒酸菜6.35183052吉祥三宝17.403854.21%20.6064.70%11.6564.94%18.1846.99%17.85309千禧富裕224辣爆毛肚20.15389.8228689泡椒凤爪9.291951.10%9.71蒜烧肚条20.1038346小排烧香菇12.035879.25%45.9747.11%17.9055.68%15.5951.99%12.483053黄桃鸡柳3008干炸江虾11.522412.4128601老式凉菜16.9615-13.03%-1.96香熏猪手372香芋吐丝9.6036351牛腩小土豆16.033857.81%21.9773.33%26.4046.58%19.5742.05%28.59343辣炒鸳鸯贝327葱烧海参39.416822.43423655.50%19.98352香汁里脊10.532862.38%303笨豆芽炒粉5.8718小计78761.11%480.9067.36%12.1317.473037干葱炒脆骨16.02617梅菜笋丝4.291673.19%11.713.171273.62%8.836049皮冻松花蛋11.792857.90%16.2183.87%7.55647油泼青笋1.4596005风味烤麸86.37%6.9158.26%12.82603蘸酱菜1.098686尖椒泡菜9.182259.79%4.7857.79%6.94618酱豆5.07123.228648酒香醉梨12.163868.00%25.8461.22%17.14673一绝金茸10.86286011捞汁松花蛋74.24%28.2145.71%12.80680手剥笋9.79386053神农猪手15.202862.94%10.0747.20%15.106035鲜奶木瓜16.90325.9316604捞汁四宝3.463890.88%34.5489.11%8.02720阿香牛肉0.9896003柠檬瓜条6038爽汁蛰丝60.948830.75%27.0684.72%614三文鱼16.45188.58%1.556044糟汁黄花小计66656.02%373.11236.09%17.3248熏酱拼盘30.68序号菜品出库金额（克）出库金额（斤）期末合计羊肉片00羊腿111100222.2五花肉5001猪颈肉4000.8前肘6001.2排骨241400482.8里脊00月牙骨00牛腩00牛通脊120150240.3牛肚1190023.8猪手4250085猪皮00金茸00脊骨00牛腱子00牛元宝00腱子筋00猪颈肉4000.80000鸡脯肉00虾仁60900121.8鱿鱼00百叶1190023.8鸡翅中00肺子00肚头00猪肚00干炸江虾00鸳鸯贝00黄玉参00小黄花鱼00三文鱼00海肠00鸡爪00鸡胗00大肠00胖头鱼头00胖头鱼尾102000204材料使用核对表填制日期：年月日报表人：鸡心3700074午餐肉1344726.894腊肉2030040.6鸭头6691.338猪腰子111900223.8墨鱼嘴4325086.5鸡腿3655073.1干虾干24204.84大虾50750101.50000金针蘑00韭菜00土豆00黄蘑00红椒61737.5123.475青椒41022.582.045葱4032280.644香葱1555931.118豆腐00干豆腐00日本豆腐00木耳3153063.06白玉菇00蟹味菇00茄子102000204紫薯00地瓜00地瓜球00玉米粒00四季豆162750325.5黄豆芽2975059.5绿豆芽3660073.2黄瓜277600555.2酸菜6001.2四川酸菜3200064粉丝1000.2香菇1672.53.345日本小土豆00香芋卷00水晶粉00蒜苗00芥兰108000216蛰皮00冬瓜00魔芋粉25005蛰头00木瓜00鲜奶00胡萝卜45009烤麸00青笋12002.4梅菜笋丝7381.476手剥笋00花生米00松花蛋00水晶梨00黄豆00臭菜00紫生菜00西生菜277500555绿萝卜00白菜00哈密瓜00小柿子27505.5葡萄00橙子00西瓜00菠菜00泰椒1075521.51香菜00法香00毛葱44408.88茶树菇152250304.5香芹00豆花20.004鸡蛋4008080.16蛋黄1239524.79娃娃菜10.002鲤鱼232500465腊鸭60900121.8鳝鱼4235084.7大头菜81200162.4油菜188950377.9芋头115500231茼蒿169000338梅肉3520070.4杭椒56400112.8芽菜1085021.7脆肠32006.4圆葱71600143.2薯条557511.15菠萝罐头3135062.7杏鲍菇4760095.2紫苏叶10602.12苹果550011紫甘蓝11002.2蒜台3520070.4西芹4300.86西兰花25005鸭血4760095.2肥肠1190023.8荷兰豆73000146腊肠1075021.5苦瓜4560091.2油麦菜145680291.36菜心280500561响螺片2920058.4银芽876017.52角瓜8501.7萝卜咸菜22004.4泡姜690013.8合计序号菜品单位期初库存库存金额进库数量单价出库数量单价郫县豆瓣酱900红腰豆5