白條豬分割表

店別：,,,,,,,,,,,,,,,,

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

金額：均為含稅,,,,,,,,,,,,,,,,

當(dāng)日白條成本（kg）:,24.8,,,當(dāng)日進(jìn)貨量(kg):,362,,昨日庫存量(kg):,96.5,,,今日庫存量(kg):,21,,,當(dāng)日白條分割總重量（kg）:,437.50

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

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

白條精分割標(biāo)準(zhǔn)表格,,,,門店填寫內(nèi)容,,,,,,,,,,,,備注

貨號(hào),品名,單位,應(yīng)銷占比,銷售量,實(shí)銷佔(zhàn)比,占比差異,當(dāng)日系統(tǒng)設(shè)定售價(jià)(元/kg）,當(dāng)日實(shí)際銷售之平均售價(jià)(元/kg）,當(dāng)日實(shí)際銷售業(yè)績(jī),當(dāng)日實(shí)際銷售毛利額,當(dāng)日實(shí)際銷售毛利率,當(dāng)日系統(tǒng)售價(jià)應(yīng)售業(yè)績(jī),當(dāng)日系統(tǒng)售價(jià)應(yīng)售毛利額,當(dāng)日系統(tǒng)售價(jià)應(yīng)售毛利率,"占比差異分析說明

（超過±2%）",

,,,,,,,應(yīng)銷數(shù)據(jù),實(shí)際數(shù)據(jù),,,,應(yīng)銷數(shù)據(jù),,,,

填表日期,,,,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%,,錄入人員只在黃色區(qū)域輸入相應(yīng)數(shù)值，其他部分均為公式，請(qǐng)勿調(diào)整

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

21011788,2號(hào)精瘦肉,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,四號(hào)精瘦肉,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,,,,,,,,,,,,,,

轉(zhuǎn)貨,,kg,,,,0.0%,,,,,,,,,,

合計(jì),,kg,,427.539,,,,,9754.64,-242.19,-2.5%,3871.00,765.13,19.8%,,

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

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

備注：,,,,,,,,,,,,,,,,

1,實(shí)銷占比=當(dāng)日分割部位肉銷量/（當(dāng)日白條進(jìn)貨量+昨日庫存量-當(dāng)日庫存量）,,,,,,,,,,,,,,,

2,當(dāng)日白條分割銷售總量=當(dāng)日進(jìn)貨量+昨日庫存量-今日庫存量,,,,,,,,,,,,,,,

3,“占比差異分析說明”欄位：只需針對(duì)占比大于差異在±2%的數(shù)據(jù)做說明。目的：協(xié)助水畜課長(zhǎng)找出差異原因，使白條分割取得毛利最大化,,,,,,,,,,,,,,,

4,當(dāng)天的白條努力當(dāng)天分割銷售完，如有有剩下的可采用冰鹽水浸泡過的毛巾給予覆蓋，以減少白條的水份損失。沒有毛巾的可用保鮮