XLS《损耗表说明》

"生鲜处各课日损耗表" "店别:" "课别:月份:" "原因","营业额A","物品报废B",,

"顾客退货C",,

"折价D",,

"不知明损耗E",,

"其他G",,

"合计F", "日期",,

"金额B1","占比B2","金额C1","占比C2","金额D1","占比D2","金额E1","占比E2","金额G1","占比G2","金额F1","占比F2" "1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12" "13" "14" "TOTAL" "制表人:课长:处长: "备注: "1-31号","实际营业额","实际报废B2=B1/A",,

"顾客因商品问题到客服退货的C2=C1/A%",,

"折价商品处理品按流程按进行所损失的金额D2=D1/A%",,

"每月底大盘计算无形损耗包括偷盗、自然损失、水分蒸发等E1=E4(管理表)-B1-C1-D1-G1E2=E1/A%(1-31号的累加营业额)每周二填写前周的累计",,

"不在前项所列之内,而又存在之损耗如:试做、试吃及生产日报表损耗栏(F)内的数字.

G1=统计的金额G2=G1/A%",,

"F1=B1+C1+D1+E1+G1F2=F1/A%", "生鲜处各课日损耗表" "店别:" "课别:月份:" "原因","营业额","物品报废",,

"顾客退货",,

"折价",,

"不知明损耗",,

"其他",,

"合计", "日期",,

"金额","占比","金额","占比","金额","占比","金额","占比","金额","占比","金额","占比" "1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12" "13" "14" "15" "16" "17" "18" "19" "20" "21" "22" "23" "24" "25" "26" "27" "28" "29" "30" "31" "TOTAL" "制表人:课长:处长: