《餐厅订货核算表.xls》由会员分享，可在线阅读，更多相关《餐厅订货核算表.xls（7页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、奇奇火火锅锅预预估估订订货货量量核核算算表表制制定定单单位位：制制表表人人：录录入入周周期期电电脑脑数数据据预预估估星星期期一一至至四四营营业业额额预预估估节节假假日日营营业业额额盘盘点点每每日日现现有有库库存存量量自自动动生生成成实实际际订订货货量量日日 期期 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日星星 期期星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六星星
2、期期日日 项项目目 名名称称周周销销售售数数量量日日销销售售数数量量周周总总营营业业额额平平均均日日营营业业额额份份数数销销量量占占比比预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实
3、际际订订货货量量预预估估营营业业额额预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量美美国国肥肥牛牛71104730567580.150%600016.216.2500013.513.5500013.513.5600016.216.2900024.324.31000027.027.0800021.621.6鲜鲜虾虾滑滑304730567580.006%60000.70.750000.60.650000.60.660000.70.790001.01.0100001.11.180000.90.9澳澳洲洲毛毛肚肚6394730567580.133%600014.414.4500012.0
4、12.0500012.012.0600014.414.4900021.621.61000024.024.0800019.219.2奇奇包包子子1524730567580.032%60003.43.450002.92.950002.92.960003.43.490005.15.1100005.75.780004.64.6土土家家苕苕粉粉5484730567580.114%600012.312.3500010.310.3500010.310.3600012.312.3900018.518.51000020.520.5800016.416.4嫩嫩肉肉王王1224730567580.025%60002
5、.72.750002.32.350002.32.360002.72.790004.14.1100004.64.680003.73.7黑黑豆豆腐腐4064730567580.085%60009.19.150007.67.650007.67.660009.19.1900013.713.71000015.215.2800012.212.2鲜鲜牛牛蹄蹄筋筋2034730567580.042%60004.64.650003.83.850003.83.860004.64.690006.86.8100007.67.680006.16.1爽爽口口腰腰片片3854730567580.080%60008.78.7
6、50007.27.250007.27.260008.78.7900013.013.01000014.514.5800011.611.6嫩嫩牛牛肉肉6394730567580.133%600014.414.4500012.012.0500012.012.0600014.414.4900021.621.61000024.024.0800019.219.2肺肺片片614730567580.013%60001.41.450001.11.150001.11.160001.41.490002.12.1100002.32.380001.81.8鲜鲜毛毛肚肚116174730567580.245%600026
7、.526.5500022.122.1500022.122.1600026.526.5900039.739.71000044.144.1800035.335.3精精品品鲜鲜鸭鸭肠肠100144730567580.211%600022.822.8500019.019.0500019.019.0600022.822.8900034.234.21000038.138.1800030.430.4野野生生鳝鳝鱼鱼2434730567580.051%60005.55.550004.64.650004.64.660005.55.590008.28.2100009.19.180007.37.3鲜鲜猪猪黄黄喉喉4
8、064730567580.085%60009.19.150007.67.650007.67.660009.19.1900013.713.71000015.215.2800012.212.2梅梅林林午午餐餐肉肉5884730567580.123%600013.213.2500011.011.0500011.011.0600013.213.2900019.919.91000022.122.1800017.717.7绿绿色色毛毛肚肚3964730567580.082%60008.98.950007.47.450007.47.460008.98.9900013.413.41000014.814.880
9、0011.911.9极极品品羔羔羊羊2034730567580.042%60004.64.650003.83.850003.83.860004.64.690006.86.8100007.67.680006.16.1精精月月君君花花2644730567580.055%60005.95.950004.94.950004.94.960005.95.990008.98.9100009.99.980007.97.9鲜鲜鱿鱿鱼鱼须须1324730567580.027%60003.03.050002.52.550002.52.560003.03.090004.54.5100004.94.980004.04.
10、0泥泥鳅鳅614730567580.013%60001.41.450001.11.150001.11.160001.41.490002.12.1100002.32.380001.81.8金金牌牌鲳鲳鱼鱼1224730567580.025%60002.72.750002.32.350002.32.360002.72.790004.14.1100004.64.680003.73.7脑脑花花4464730567580.093%600010.010.050008.48.450008.48.4600010.010.0900015.115.11000016.716.7800013.413.4无无骨骨鸭鸭掌
11、掌814730567580.017%60001.81.850001.51.550001.51.560001.81.890002.72.7100003.03.080002.42.4虾虾饺饺2744730567580.057%60006.26.250005.15.150005.15.160006.26.290009.29.21000010.310.380008.28.2耗耗儿儿鱼鱼2744730567580.057%60006.26.250005.15.150005.15.160006.26.290009.29.21000010.310.380008.28.2无无骨骨凤凤爪爪43647305675
12、80.091%60009.89.850008.28.250008.28.260009.89.8900014.714.71000016.416.4800013.113.1美美好好火火腿腿肠肠2034730567580.042%60004.64.650003.83.850003.83.860004.64.690006.86.8100007.67.680006.16.1美美好好脆脆皮皮肠肠1124730567580.023%60002.52.550002.12.150002.12.160002.52.590003.83.8100004.24.280003.33.3鹌鹌鹑鹑蛋蛋325473056758
13、0.068%60007.37.350006.16.150006.16.160007.37.3900011.011.01000012.212.280009.79.7鮰鮰鱼鱼片片1424730567580.030%60003.23.250002.72.750002.72.760003.23.290004.84.8100005.35.380004.34.3麻麻辣辣鸭鸭肠肠2334730567580.049%60005.35.350004.44.450004.44.460005.35.390007.97.9100008.88.880007.07.0卤卤肥肥肠肠1724730567580.036%600
14、03.93.950003.23.250003.23.260003.93.990005.85.8100006.56.580005.25.2水水饺饺2034730567580.042%60004.64.650003.83.850003.83.860004.64.690006.86.8100007.67.680006.16.1香香菜菜丸丸子子4164730567580.087%60009.49.450007.87.850007.87.860009.49.4900014.014.01000015.615.6800012.512.5三三线线肉肉2234730567580.047%60005.05.050
15、004.24.250004.24.260005.05.090007.57.5100008.48.480006.76.7上上脑脑肥肥牛牛1014730567580.021%60002.32.350001.91.950001.91.960002.32.390003.43.4100003.83.880003.03.0精精品品牛牛黄黄喉喉2644730567580.055%60005.95.950004.94.950004.94.960005.95.990008.98.9100009.99.980007.97.9老老肉肉片片3654730567580.076%60008.28.250006.86.85
16、0006.86.860008.28.2900012.312.31000013.713.7800011.011.0爽爽口口鱿鱿鱼鱼2544730567580.053%60005.75.750004.84.850004.84.860005.75.790008.68.6100009.59.580007.67.6五五香香毛毛肚肚1324730567580.027%60003.03.050002.52.550002.52.560003.03.090004.54.5100004.94.980004.04.0五五香香菌菌肝肝614730567580.013%60001.41.450001.11.150001
17、.11.160001.41.490002.12.1100002.32.380001.81.8爽爽口口腰腰花花204730567580.004%60000.50.550000.40.450000.40.460000.50.590000.70.7100000.80.880000.60.6金金针针菇菇97144730567580.205%600022.122.1500018.518.5500018.518.5600022.122.1900033.233.21000036.936.9800029.529.5香香菇菇4874730567580.101%600011.011.050009.19.15000
18、9.19.1600011.011.0900016.416.41000018.318.3800014.614.6平平菇菇3554730567580.074%60008.08.050006.76.750006.76.760008.08.0900012.012.01000013.313.3800010.710.7冻冻豆豆腐腐4564730567580.095%600010.310.350008.68.650008.68.6600010.310.3900015.415.41000017.117.1800013.713.7中中段段莲莲藕藕87124730567580.184%600019.919.950
19、0016.616.6500016.616.6600019.919.9900029.829.81000033.133.1800026.526.5宁宁波波年年糕糕1624730567580.034%60003.73.750003.03.050003.03.060003.73.790005.55.5100006.16.180004.94.9苗苗家家粉粉丝丝1014730567580.021%60002.32.350001.91.950001.91.960002.32.390003.43.4100003.83.880003.03.0莴莴笋笋头头5384730567580.112%600012.112.
20、1500010.110.1500010.110.1600012.112.1900018.218.21000020.220.2800016.116.1黄黄瓜瓜3354730567580.070%60007.57.550006.36.350006.36.360007.57.5900011.311.31000012.612.6800010.010.0豆豆皮皮129184730567580.273%600029.529.5500024.524.5500024.524.5600029.529.5900044.244.21000049.149.1800039.339.3老老南南瓜瓜213473056758
21、0.044%60004.84.850004.04.050004.04.060004.84.890007.27.2100008.08.080006.46.4鲜鲜鸭鸭血血5684730567580.118%600012.812.8500010.710.7500010.710.7600012.812.8900019.219.21000021.321.3800017.017.0冬冬瓜瓜6194730567580.129%600013.913.9500011.611.6500011.611.6600013.913.9900020.920.91000023.223.2800018.618.6卤卤水水豆豆干
22、干414730567580.008%60000.90.950000.80.850000.80.860000.90.990001.41.4100001.51.580001.21.2土土豆豆114164730567580.241%600026.026.0500021.721.7500021.721.7600026.026.0900039.039.01000043.443.4800034.734.7茼茼蒿蒿1424730567580.030%60003.23.250002.72.750002.72.760003.23.290004.84.8100005.35.380004.34.3莴莴笋笋尖尖254
23、4730567580.053%60005.75.750004.84.850004.84.860005.75.790008.68.6100009.59.580007.67.6海海带带花花3354730567580.070%60007.57.550006.36.350006.36.360007.57.5900011.311.31000012.612.6800010.010.0小小葱葱1324730567580.027%60003.03.050002.52.550002.52.560003.03.090004.54.5100004.94.980004.04.0海海白白菜菜1324730567580.
24、027%60003.03.050002.52.550002.52.560003.03.090004.54.5100004.94.980004.04.0井井水水豆豆芽芽5484730567580.114%600012.312.3500010.310.3500010.310.3600012.312.3900018.518.51000020.520.5800016.416.4泰泰国国木木耳耳2744730567580.057%60006.26.250005.15.150005.15.160006.26.290009.29.21000010.310.380008.28.2淮淮山山药药538473056
25、7580.112%600012.112.1500010.110.1500010.110.1600012.112.1900018.218.21000020.220.2800016.116.1鲜鲜方方竹竹笋笋4464730567580.093%600010.010.050008.48.450008.48.4600010.010.0900015.115.11000016.716.7800013.413.4苕苕皮皮3654730567580.076%60008.28.250006.86.850006.86.860008.28.2900012.312.31000013.713.7800011.011.0
26、火火锅锅笋笋1524730567580.032%60003.43.450002.92.950002.92.960003.43.490005.15.1100005.75.780004.64.6香香菜菜1624730567580.034%60003.73.750003.03.050003.03.060003.73.790005.55.5100006.16.180004.94.9花花菜菜104730567580.002%60000.20.250000.20.250000.20.260000.20.290000.30.3100000.40.480000.30.3生生菜菜2844730567580.05
27、9%60006.46.450005.35.350005.35.360006.46.490009.69.61000010.710.780008.58.5莲莲白白414730567580.008%60000.90.950000.80.850000.80.860000.90.990001.41.4100001.51.580001.21.2青青菜菜头头914730567580.019%60002.12.150001.71.750001.71.760002.12.190003.13.1100003.43.480002.72.7芋芋儿儿粉粉814730567580.017%60001.81.850001.
28、51.550001.51.560001.81.890002.72.7100003.03.080002.42.4芋芋儿儿814730567580.017%60001.81.850001.51.550001.51.560001.81.890002.72.7100003.03.080002.42.4萝萝卜卜514730567580.011%60001.11.150001.01.050001.01.060001.11.190001.71.7100001.91.980001.51.5娃娃娃娃菜菜414730567580.008%60000.90.950000.80.850000.80.860000.90
29、.990001.41.4100001.51.580001.21.2自自助助味味碟碟7441064730567581.573%6000169.9169.95000141.5141.55000141.5141.56000169.9169.99000254.8254.810000283.1283.18000226.5226.5蛋蛋煎煎糍糍粑粑2434730567580.051%60005.55.550004.64.650004.64.660005.55.590008.28.2100009.19.180007.37.3南南瓜瓜饼饼2844730567580.059%60006.46.450005.35
30、.350005.35.360006.46.490009.69.61000010.710.780008.58.5蛋蛋炒炒饭饭1624730567580.034%60003.73.750003.03.050003.03.060003.73.790005.55.5100006.16.180004.94.9手手工工小小汤汤圆圆6094730567580.127%600013.713.7500011.411.4500011.411.4600013.713.7900020.520.51000022.822.8800018.318.3自自制制酥酥肉肉5784730567580.120%600013.013.
31、0500010.810.8500010.810.8600013.013.0900019.519.51000021.721.7800017.417.4玉玉兔兔奶奶黄黄包包914730567580.019%60002.12.150001.71.750001.71.760002.12.190003.13.1100003.43.480002.72.7传传统统红红汤汤锅锅93134730567580.197%600021.221.2500017.717.7500017.717.7600021.221.2900031.831.81000035.435.4800028.328.3肥肥牛牛鸳鸳鸯鸯锅锅2334
32、730567580.049%60005.35.350004.44.450004.44.460005.35.390007.97.9100008.88.880007.07.0筒筒骨骨鸳鸳鸯鸯锅锅99144730567580.209%600022.622.6500018.818.8500018.818.8600022.622.6900033.933.91000037.737.7800030.130.1肥肥牛牛全全清清汤汤004730567580.000%60000.00.050000.00.050000.00.060000.00.090000.00.0100000.00.080000.00.0筒筒骨
33、骨全全清清汤汤004730567580.000%60000.00.050000.00.050000.00.060000.00.090000.00.0100000.00.080000.00.0山山城城国国宾宾225324730567580.476%600051.451.4500042.842.8500042.842.8600051.451.4900077.177.11000085.685.6800068.568.5重重庆庆纯纯生生101144730567580.214%600023.123.1500019.219.2500019.219.2600023.123.1900034.634.61000
34、038.438.4800030.730.7山山城城195819584674730567580.097%600010.510.550008.88.850008.88.8600010.510.5900015.815.81000017.517.5800014.014.0鲜鲜橙橙多多（大大）104730567580.002%60000.20.250000.20.250000.20.260000.20.290000.30.3100000.40.480000.30.3矿矿泉泉水水714730567580.015%60001.61.650001.31.350001.31.360001.61.690002.4
35、2.4100002.72.780002.12.1中中国国劲劲酒酒（125ml125ml）714730567580.015%60001.61.650001.31.350001.31.360001.61.690002.42.4100002.72.780002.12.1加加多多宝宝97144730567580.205%600022.122.1500018.518.5500018.518.5600022.122.1900033.233.21000036.936.9800029.529.5王王老老吉吉(340ML)(340ML)104730567580.002%60000.20.250000.20.25
36、0000.20.260000.20.290000.30.3100000.40.480000.30.3小小花花瓷瓷诗诗仙仙(125ML)(125ML)104730567580.002%60000.20.250000.20.250000.20.260000.20.290000.30.3100000.40.480000.30.3歪歪嘴嘴郎郎酒酒（100ml)100ml)1424730567580.030%60003.23.250002.72.750002.72.760003.23.290004.84.8100005.35.380004.34.3芦芦荟荟奶奶1014730567580.021%6000
37、2.32.350001.91.950001.91.960002.32.390003.43.4100003.83.880003.03.0金金樽樽黑黑啤啤414730567580.008%60000.90.950000.80.850000.80.860000.90.990001.41.4100001.51.580001.21.2大大雪雪碧碧814730567580.017%60001.81.850001.51.550001.51.560001.81.890002.72.7100003.03.080002.42.4小小雪雪碧碧(500ML)(500ML)104730567580.002%60000.
38、20.250000.20.250000.20.260000.20.290000.30.3100000.40.480000.30.3大大可可乐乐814730567580.017%60001.81.850001.51.550001.51.560001.81.890002.72.7100003.03.080002.42.4大大唯唯怡怡(960ML)(960ML)2034730567580.042%60004.64.650003.83.850003.83.860004.64.690006.86.8100007.67.680006.16.1小小唯唯怡怡(听听)1424730567580.030%6000
39、3.23.250002.72.750002.72.760003.23.290004.84.8100005.35.380004.34.3参参茸茸劲劲酒酒（100ml100ml）204730567580.004%60000.50.550000.40.450000.40.460000.50.590000.70.7100000.80.880000.60.6江江津津老老白白干干（小小江江白白125ml125ml）204730567580.004%60000.50.550000.40.450000.40.460000.50.590000.70.7100000.80.880000.60.6郎郎酒酒108ml
40、(108)108ml(108)304730567580.006%60000.70.750000.60.650000.60.660000.70.790001.01.0100001.11.180000.90.9可可口口可可乐乐(听听)1224730567580.025%60002.72.750002.32.350002.32.360002.72.790004.14.1100004.64.680003.73.7花花生生浆浆2334730567580.049%60005.35.350004.44.450004.44.460005.35.390007.97.9100008.88.880007.07.0绿
41、绿豆豆汁汁1224730567580.025%60002.72.750002.32.350002.32.360002.72.790004.14.1100004.64.680003.73.7米米饭饭135194730567580.285%600030.830.8500025.725.7500025.725.7600030.830.8900046.246.21000051.451.4800041.141.1奇奇火火锅锅实实际际订订货货量量统统计计表表制制定定单单位位：制制表表人人:电电脑脑数数据据自自动动生生成成盘盘点点每每日日现现有有库库存存量量核核算算实实际际订订货货量量日日 期期201420
42、14年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日星星 期期星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六星星期期日日 项项目目 名名称称预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估订订货货量量现现有有库库存
43、存量量实实际际订订货货量量预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量预预估估订订货货量量现现有有库库存存量量实实际际订订货货量量美美国国肥肥牛牛16.213.513.516.224.327.021.6鲜鲜虾虾滑滑0.70.60.60.71.01.10.9澳澳洲洲毛毛肚肚14.412.012.014.421.624.019.2奇奇包包子子3.42.92.93.45.15.74.6土土家家苕苕粉粉12.310.310.312.318.520.516.4嫩嫩肉肉王王2.72.32.32.74.14.63.7黑黑豆豆腐腐9.17.67.69.113.715.212.2鲜鲜牛牛蹄蹄筋筋
44、4.63.83.84.66.87.66.1爽爽口口腰腰片片8.77.27.28.713.014.511.6嫩嫩牛牛肉肉14.412.012.014.421.624.019.2肺肺片片1.41.11.11.42.12.31.8鲜鲜毛毛肚肚26.522.122.126.539.744.135.3精精品品鲜鲜鸭鸭肠肠22.819.019.022.834.238.130.4野野生生鳝鳝鱼鱼5.54.64.65.58.29.17.3鲜鲜猪猪黄黄喉喉9.17.67.69.113.715.212.2梅梅林林午午餐餐肉肉13.211.011.013.219.922.117.7绿绿色色毛毛肚肚8.97.47.4
45、8.913.414.811.9极极品品羔羔羊羊4.63.83.84.66.87.66.1精精月月君君花花5.94.94.95.98.99.97.9鲜鲜鱿鱿鱼鱼须须3.02.52.53.04.54.94.0泥泥鳅鳅1.41.11.11.42.12.31.8金金牌牌鲳鲳鱼鱼2.72.32.32.74.14.63.7脑脑花花10.08.48.410.015.116.713.4无无骨骨鸭鸭掌掌1.81.51.51.82.73.02.4虾虾饺饺6.25.15.16.29.210.38.2耗耗儿儿鱼鱼6.25.15.16.29.210.38.2无无骨骨凤凤爪爪9.88.28.29.814.716.413.
46、1美美好好火火腿腿肠肠4.63.83.84.66.87.66.1美美好好脆脆皮皮肠肠2.52.12.12.53.84.23.3鹌鹌鹑鹑蛋蛋7.36.16.17.311.012.29.7鮰鮰鱼鱼片片3.22.72.73.24.85.34.3麻麻辣辣鸭鸭肠肠5.34.44.45.37.98.87.0卤卤肥肥肠肠3.93.23.23.95.86.55.2水水饺饺4.63.83.84.66.87.66.1香香菜菜丸丸子子9.47.87.89.414.015.612.5三三线线肉肉5.04.24.25.07.58.46.7上上脑脑肥肥牛牛2.31.91.92.33.43.83.0精精品品牛牛黄黄喉喉5.
47、94.94.95.98.99.97.9老老肉肉片片8.26.86.88.212.313.711.0爽爽口口鱿鱿鱼鱼5.74.84.85.78.69.57.6五五香香毛毛肚肚3.02.52.53.04.54.94.0五五香香菌菌肝肝1.41.11.11.42.12.31.8爽爽口口腰腰花花0.50.40.40.50.70.80.6金金针针菇菇22.118.518.522.133.236.929.5香香菇菇11.09.19.111.016.418.314.6平平菇菇8.06.76.78.012.013.310.7冻冻豆豆腐腐10.38.68.610.315.417.113.7中中段段莲莲藕藕19.
48、916.616.619.929.833.126.5宁宁波波年年糕糕3.73.03.03.75.56.14.9苗苗家家粉粉丝丝2.31.91.92.33.43.83.0莴莴笋笋头头12.110.110.112.118.220.216.1黄黄瓜瓜7.56.36.37.511.312.610.0豆豆皮皮29.524.524.529.544.249.139.3老老南南瓜瓜4.84.04.04.87.28.06.4鲜鲜鸭鸭血血12.810.710.712.819.221.317.0冬冬瓜瓜13.911.611.613.920.923.218.6卤卤水水豆豆干干0.90.80.80.91.41.51.2土
49、土豆豆26.021.721.726.039.043.434.7茼茼蒿蒿3.22.72.73.24.85.34.3莴莴笋笋尖尖5.74.84.85.78.69.57.6海海带带花花7.56.36.37.511.312.610.0小小葱葱3.02.52.53.04.54.94.0海海白白菜菜3.02.52.53.04.54.94.0井井水水豆豆芽芽12.310.310.312.318.520.516.4泰泰国国木木耳耳6.25.15.16.29.210.38.2淮淮山山药药12.110.110.112.118.220.216.1鲜鲜方方竹竹笋笋10.08.48.410.015.116.713.4苕
50、苕皮皮8.26.86.88.212.313.711.0火火锅锅笋笋3.42.92.93.45.15.74.6香香菜菜3.73.03.03.75.56.14.9花花菜菜0.20.20.20.20.30.40.3生生菜菜6.45.35.36.49.610.78.5莲莲白白0.90.80.80.91.41.51.2青青菜菜头头2.11.71.72.13.13.42.7芋芋儿儿粉粉1.81.51.51.82.73.02.4芋芋儿儿1.81.51.51.82.73.02.4萝萝卜卜1.11.01.01.11.71.91.5娃娃娃娃菜菜0.90.80.80.91.41.51.2自自助助味味碟碟169.91