档案工作簿模板.xls

2012.6.21库存明细产品光瓶盒装普装精制精酿库存1864393426单价180120150300720活动1.31.31.31.31.5合计2492.307692 59353.84615 10730.76923 9692.3076922880陈酿合计6808144029101.58.2576090909.230772012年6月21日之前销售清单门店/产品联系人电话光瓶盒装普装件数金额/件合计件数金额/件合计件数河大配送xxx011501501新华新天地xxx011501501新华华北xxx011501501新华晋安路xxx011501501知鱼乐超市xxx011501501冰冰副食xxx011501501宏图超市xxx011501501薄利副食xxx011501501爱家华建店xxx011501501祥云名烟名酒xxx001石桥口乐购便利店xxx011501501心连心超市xxx011501501三全超市xxx011501501依人超市xxx011501501仁和副食xxx011501501锦祥名烟名酒xxx011501501媛妞副食xxx011501501微利副食xxx01150150小心连心超市xxx011501501合计0181502700182012年6月23日之前销售清单门店/产品联系人电话光瓶盒装普装件数金额/件合计件数金额/件合计件数南阳市百家xxx11921920河道街副食xxx119219211501501化肥厂生后区百家xxx1192192115015000000000000000000000000000000000合计576300精制精酿陈酿合计金额/件合计件数金额/件合计件数金额/件合计件数金额/件合计件数金额/件258258139639600380425825800024082582580002408258258000240825825813963960038042582580002408258258139639600380425825800024082582580002408258258139639600265425825813963960038042582581396396003804258258139639600380425825813963960038042582580002408258258139639600380425825800024080000115025825813963960038042584644103963960004611304精制精酿陈酿合计金额/件合计件数金额/件合计件数金额/件合计件数金额/件合计件数金额/件000011922702700002612000013420000000000000000000000000000002012年6月21日之前销售清单普装2012年6月23日之前销售清单普装000000000000000000000000000000000000000000000000000000000000000000270000411462012.6.21价格表商品名称度数规格及质量经销价（元/件）支持%市场老供价建议入店价（元）促销/业务费百家宴陈酿52%16/优144050%378百家宴精酿52%16/一72050%202百家宴精制52%16/一30030%66百家宴盒装52%16/一15030%43.6百家宴简装52%16/一12030%25.5百家宴光瓶52%112/一18030%礼品或瓶盖奖（元）建议零售价（元/瓶）备注580258986535282012.6.21之前开封市销售价格表到岸价开票价出货价终端价简盒15.420 28十赠一25.536普装19.225 48十赠一43.665精制38.550 73十赠一66105精酿80120202268陈酿160240378568光瓶11.54156月赠品赠品/瓶123456789 10 11 12 131415 161718 19 20 21 22 23 24光瓶盒装普装66精制6精酿陈酿合计00000000000000000000 12 0602012年赠品赠品123456789 10 11 12合计单件折扣价格规格件数单瓶价格实际费用花销光瓶0138 120 11.50盒装092.3 60 15.40普装1211562 19.2 231精制623161 38.5 231精酿48060800陈酿096060 1600合计0000018000000046225 26 27 28 29 30 31合计/瓶合计/件单件折扣价格 规格单瓶价格实际费用花销00 138.46153851211.5000 92.30769231615.40122 115.3846154619.223161 230.7692308638.5231004806800009606160000000001834622012.6月实际出库表产品期初库存/日期实际库存出货合计123456789#光瓶18108000000000000000000盒装64363310000000000000000000普装93849000000000000000000精制42375000000000000000000精酿660000000000000000000陈酿660000000000000000000合计808776320000000000000000002012.6月入库表产品剩余库存/日期实际库存入库合计123456789#光瓶10100盒装6336330普装84840精制37370精酿660陈酿660合计7767760#000000000000000002012.6月出库表产品期初库存/日期剩余库存出货合计123456789#光瓶18108盒装64363310普装93849精制42375精酿660陈酿660合计80877632000000000000000000杨涛光瓶5盒装8普装7精制4精酿陈酿#3100008000000000000#0000000000108000000000010400000000000000000000000000000000000020#00000000#310000000000000#318#18140020#000000006月份日销售额产品出厂价格费用点单件折扣价格123456789 10 11 12 13 14光瓶1801.3138.46153850000000 0000000盒装1201.392.307692310000000 0000000普装1501.3115.38461540000000 0000000精制3001.3230.76923080000000 0000000精酿7201.54800000000 0000000陈酿 14401.59600000000 0000000合计00000000000000115 16 17 18 19 20 21 222324 25 26 27 28 29 30 31 合计00000000#0000000011080000000092300000000 923.1000000#0923000000001038000000#09230000001154000000000000000000000000000000000000000000#0#000000004223库存成本产品老库存/日期出厂价格费用点单件折扣价格原库存金额合计实际销售 实际库存销售成本库存成本光瓶181801.3138.5 24928101107.69 1384.615盒装6431201.392.31#10633923.077 58430.77普装931501.3115.4#9841038.46 9692.308精制423001.3230.8 96925371153.85 8538.462精酿67201.548028800602880陈酿614401.596057600605760合计808#327764223.08 86686.15产品期初库存/日期剩余库存 出货合计12345光瓶18180盒装6436430普装93930精制422913精酿660陈酿660合计80879513000006789101112111111011000