白条猪分割表

店别：,,,,,,,,,,,,,,,,

销售日期：,2013年1月16日,,,,,,,,,,,,,,,

金额：均为含税,,,,,,,,,,,,,,,,

当日白条成本（kg）:,24.8,,,当日进货量(kg):,362,,昨日库存量(kg):,96.5,,,今日库存量(kg):,21,,,当日白条分割总重量（kg）:,437.50

填表日期,D,,3,,D,,,D-1,,,,,,,,D

,,,,,,,,,,,,,,,,,

白条精分割标准表格,,,,门店填写内容,,,,,,,,,,,,备注

货号,品名,单位,应销占比,銷售量,实销佔比,占比差异,当日系统设定售价(元/kg）,当日实际销售之平均售价(元/kg）,当日实际销售业绩,当日实际销售毛利额,当日实际销售毛利率,当日系统售价应售业绩,当日系统售价应售毛利额,当日系统售价应售毛利率,"占比差异分析说明

（超过±2%）",

,,,,,,,应销数据,实际数据,,,,应销数据,,,,

填表日期,,,,D+1,,,D,,D+1,,,,,,D+1,

21011542,带皮前腿肉,kg,18.2%,16.320,3.7%,-14.5%,,21.52,440.64,26.11,5.9%,261.74,58.89,22.5%,,录入人员只在黄色区域输入相应数值，其他部分均为公式，请勿调整

21010590,夹心肉,kg,2.6%,,0.0%,-2.6%,26.00,24.99,,,#DIV/0!,18.77,5.34,28.5%,,

21011788,2号精瘦肉,kg,1.3%,4.328,1.0%,-0.3%,31.00,25.00,125.51,15.58,12.4%,49.85,19.94,40.0%,,

21010729,颈骨,kg,1.9%,11.082,2.5%,0.7%,13.00,18.00,199.47,-82.01,-41.1%,71.86,-30.96,-43.1%,,

21010484,前排,kg,3.0%,18.770,4.3%,1.3%,25.00,25.00,488.03,11.27,2.3%,271.50,69.50,25.6%,,

21010507,前棒骨,kg,2.1%,12.604,2.9%,0.8%,11.00,#DIV/0!,151.21,-126.08,-83.4%,0.00,0.00,#DIV/0!,,

21012396,扇子骨,kg,0.5%,9.918,2.3%,1.8%,2.00,#DIV/0!,19.84,-232.08,-1169.8%,0.00,0.00,#DIV/0!,,

21011528,带皮中方肉,kg,5.3%,67.430,15.4%,10.1%,23.00,19.81,1615.57,-97.15,-6.0%,803.21,153.66,19.1%,,

21011535,带皮五花肉,kg,15.5%,45.075,10.3%,-5.2%,22.00,21.00,1171.97,27.07,2.3%,349.80,54.06,15.5%,,

21010767,精五花肉,kg,4.5%,31.362,7.2%,2.7%,27.00,24.40,846.80,50.21,5.9%,337.66,105.05,31.1%,,

21010521,中排,kg,6.0%,13.760,3.1%,-2.9%,27.00,27.00,385.28,35.78,9.3%,91.58,28.49,31.1%,,

21012372,四号精瘦肉,kg,3.4%,,0.0%,-3.4%,33.00,28.00,,,,14.12,6.16,43.6%,,

21010644,元宝肉,kg,1.7%,,0.0%,-1.7%,30.00,28.00,,,,0.00,0.00,#DIV/0!,,

21010842,二刀肉,kg,5.5%,,0.0%,-5.5%,29.00,24.01,,,#DIV/0!,44.95,16.12,35.9%,,

21011566,带皮后腿肉,kg,10.8%,19.806,4.5%,-6.3%,25.00,20.21,514.96,11.89,2.3%,983.55,251.79,25.6%,,

21010477,猪腰柳,kg,1.2%,8.288,1.9%,0.7%,35.00,27.00,248.64,38.12,15.3%,79.31,37.16,46.9%,,

21010606,龙骨,kg,3.0%,17.698,4.0%,1.0%,15.00,14.00,247.78,-201.75,-81.4%,177.36,-42.57,-24.0%,,

21012532,去骨肘子,kg,8.0%,28.304,6.5%,-1.5%,29.00,22.40,735.87,16.95,2.3%,188.50,67.60,35.9%,,

21010699,后棒骨,kg,2.7%,11.880,2.7%,0.0%,13.00,11.00,147.44,-154.31,-104.7%,104.52,-45.02,-43.1%,,

21010750,耗儿肉,kg,1.3%,0.702,0.2%,-1.1%,33.00,28.00,20.36,2.53,12.4%,22.70,9.91,43.6%,,

21011559,鲜肋排,kg,,2.054,0.5%,0.5%,40.00,40.00,73.95,16.03,,,,,,

21012433,鲜肉馅(6:4),kg,,41.225,9.4%,9.4%,29.00,,741.23,263.02,35.5%,,,,,

21010491,猪皮,kg,,8.008,1.8%,1.8%,4.00,4.01,48.04,-169.78,-353.4%,,,,,

21010460,前腿肉整只,kg,,34.262,,,,,890.81,178.16,,,,,,

21010637,后腿肉整只,kg,,24.663,,,,,641.24,128.25,,,,,,

21010545,精肉馅,kg,,,,,,,,,,,,,,

21011665,碎肥肉（3：7）,kg,,,,,,,,,,,,,,

21011764,碎精肉（2：8）,kg,,,,,,,,,,,,,,

21010545,精肉馅,kg,,,,,,,,,,,,,,

21010828,精瘦肉片,kg,,,,,,,,,,,,,,

转货,,kg,,,,0.0%,,,,,,,,,,

合计,,kg,,427.539,,,,,9754.64,-242.19,-2.5%,3871.00,765.13,19.8%,,

步留率,,,,97.7%,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

备注：,,,,,,,,,,,,,,,,

1,实销占比=当日分割部位肉销量/（当日白条进货量+昨日库存量-当日库存量）,,,,,,,,,,,,,,,

2,当日白条分割销售总量=当日进货量+昨日库存量-今日库存量,,,,,,,,,,,,,,,

3,“占比差异分析说明”栏位：只需针对占比大于差异在±2%的数据做说明。目的：协助水畜课长找出差异原因，使白条分割取得毛利最大化,,,,,,,,,,,,,,,

4,当天的白条努力当天分割销售完，如有有剩下的可采用冰盐水浸泡过的毛巾给予覆盖，以减少白条的水份损失。没有毛巾的可用保鲜