餐厅订货核算表.xls

奇奇火火锅锅预预估估订订货货量量核核算算表表 制制定定单单位位： 制制表表人人： 录录入入周周期期电电脑脑数数据据预预估估星星期期一一至至四四营营业业额额预预估估节节假假日日营营业业额额盘盘点点每每日日现现有有库库存存量量自自动动生生成成实实际际订订货货量量 日日 期期 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 20142014 年年 月月 日日 星星 期期星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六星星期期日日 项项目目 名名称称 周周销销售售 数数量量 日日销销售售 数数量量 周周总总营营 业业额额 平平均均日日 营营业业额额 份份数数销销 量量占占比比 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估营营 业业额额 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 美美国国肥肥牛牛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.012.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.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.750007.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.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 鲜鲜猪猪黄黄喉喉4064730567580.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.8800011.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.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 无无骨骨鸭鸭掌掌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 无无骨骨凤凤爪爪4364730567580.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 鹌鹌鹑鹑蛋蛋3254730567580.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%60003.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.050004.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.850006.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.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.150009.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.9500016.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.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 老老南南瓜瓜2134730567580.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 卤卤水水豆豆干干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 莴莴笋笋尖尖2544730567580.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.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 淮淮山山药药5384730567580.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 火火锅锅笋笋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.059%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.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.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.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.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 肥肥牛牛鸳鸳鸯鸯锅锅2334730567580.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 筒筒骨骨全全清清汤汤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.61000038.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.42.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.250000.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%60002.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.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%60003.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(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 绿绿豆豆汁汁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 奇奇火火锅锅实实际际订订货货量量统统计计表表 制制定定单单位位： 制制表表人人: : 电电脑脑数数据据自自动动生生成成盘盘点点每每日日现现有有库库存存量量核核算算实实际际订订货货量量 日日 期期20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日20142014年年 月月 日日 星星 期期星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六星星期期日日 项项目目 名名称称 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 预预估估订订 货货量量 现现有有库库 存存量量 实实际际订订 货货量量 美美国国肥肥牛牛 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 鲜鲜牛牛蹄蹄筋筋 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.48.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.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.