销售管理分析表

,序号客户编号月采购金额结算周期等级地址联系人联系电话备注,1.0客户1K0001500W,2.0客户2K00021000W,3.0客户3K00031000W,4.0客户4K0004800W,5.0客户5K0005600W,6.0客户6K0006200W,7.0客户7K0007100W60天,8.0客户8K0008500W,9.0客户9K0009400W,10.0客户10K0010600W,11.0,12.0,13.0,14.0,15.0,16.0,序号品名编码型号规格单位销售价价格波动范围生产周期备注,1.0产品1C00001,2.0产品1C00002,3.0产品2C00003,4.0产品2C00004,5.0产品3C00005,6.0产品3C00006,7.0产品4C00007,8.0产品4C00008,9.0产品5C00009,10.0产品5C00010,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,产品报价单,日期： 年 月 日,序号品名型号规格单位单价供货周期备注,1.0产品1,2.0产品1,3.0产品2,4.0产品2,5.0产品3,6.0产品3,7.0产品4,8.0产品4,9.0产品5,10.0产品5,供应商：,地址：,联系人：,联系电话：,备注：此报价单15日内有效，商业机密请勿外传。,序号月份日期客户采购订单号品名编码型号规格单位单价数量金额到货日期运输方式收货地址收货人联系方式备注,43466.0客户1TT000000101001C0000143481.0,2.043467.0TT000000101002C0000243482.0,3.043468.0客户3TT000000101003C0000343483.0,4.043469.0客户4TT000000101004C0000443484.0,5.043470.0客户5TT000000101005C0000543485.0,6.043471.0客户6TT000000101006C0000643486.0,7.043472.0客户7TT000000101007C0000743487.0,8.043473.0客户8TT00000010100843488.0,9.043474.0TT000000101009C0000943489.0,10.043475.0客户10TT000000101010C0001043490.0,11.043476.0TT000000101011C0000143491.0,12.043477.0客户3TT000000101012C0000243492.0,13.043478.0客户4TT000000101013C0000343493.0,14.043479.0客户5TT000000101014C0000443494.0,15.043480.0客户6TT000000101015C0000543495.0,16.043481.0客户7TT000000101016C0000643496.0,17.043482.0客户8TT000000101017C0000743497.0,18.043483.0TT00000010101843498.0,19.043484.0客户1TT000000101019C0000943499.0,20.043485.0TT000000101020C0001043500.0,21.02.043497.0TT00000010102150.055000.043501.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,序号月份日期客户订单品名编码型号规格单位出库数量差异数运输人车牌号联系方式状态收货人备注,43479.0客户1TT000000101001C00001,43480.0TT000000101002C00002,3.043481.0客户3TT000000101003C00003,4.043482.0客户4TT000000101004C00004,5.043483.0客户5TT000000101005C00005,6.043484.0客户6TT000000101006C00006,7.043485.0客户7TT000000101007C00007,8.043486.0客户8TT000000101008,9.043487.0TT000000101009C00009,10.043488.0客户10TT000000101010C00010,11.043489.0TT000000101011C00001,12.043490.0客户3TT000000101012C00002,13.043491.0客户4TT000000101013C00003,14.043492.0客户5TT000000101014C00004,15.043493.0客户6TT000000101015C00005,16.043494.0客户7TT000000101016C00006,17.043495.0客户8TT000000101017C00007,18.043496.0TT000000101018,19.043497.0客户1TT000000101019C00009,20.043498.0TT000000101020C00010,21.043510.0TT00000010102150.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,年份月份查询明细,2019.01.0日期采购数量采购金额,1.043466.0100.0100000.0,客户2.043467.0,客户13.043468.0,4.043469.0,5.043470.0,6.043471.0,7.043472.0,采购数量合计8.043473.0,200.09.043474.0,10.043475.0,采购金额合计11.043476.0,200000.012.043477.0,13.043478.0,备注：输入客户、年份、月份数据自动汇总生成。14.043479.0,15.043480.0,16.043481.0,17.043482.0,18.043483.0,19.043484.0100.0100000.0,20.043485.0,21.043486.0,22.043487.0,23.043488.0,24.043489.0,25.043490.0,26.043491.0,27.043492.0,28.043493.0,29.043494.0,30.043495.0,31.043496.0,序号月份日期客户订单号金额已付金额待付金额收款账号名称开户行收款账号付款账号名称开户行付款账号付款流水号备注,43466.0客户1TT000000101001,2.043467.0TT000000101002,3.043468.0客户3TT000000101003,4.043469.0客户4TT000000101004,5.043470.0客户5TT000000101005,6.043471.0客户6TT000000101006,7.043472.0客户7TT000000101007,8.043473.0客户8TT000000101008,9.043474.0TT000000101009,10.043475.0客户10TT000000101010,11.043476.0TT000000101011,12.043477.0客户3TT000000101012,13.043478.0客户4TT000000101013,14.043479.0客户5TT000000101014,15.043480.0客户6TT000000101015,16.043481.0客户7TT000000101016,17.043482.0客户8TT000000101017,18.043483.0TT000000101018,19.043484.0客户1TT00000010101980000.020000.0,20.043485.0TT00000010102060000.050000.0,21.02.043497.0TT00000010102155000.0,22.0,23.0,月份：1.0,序号客户总采购金额已付金额待付金额备注,1.0客户1200000.0180000.020000.0,2.0客户2320000.0270000.050000.0,3.0客户3,4.0客户4,5.0客户5,6.0客户6,7.0客户7,8.0客户8,9.0客户9,10.0客户10110000.0110000.0,11.0,12.0,13.0,14.0,15.0,16.0,序号客户采购金额占比每月采购明细,1.02.03.04.05.06.07.08.09.010.011.012.0,1.0客户1200000.00.092807424594200000.0,2.0客户2320000.00.14849187935320000.0,3.0客户3,4.0客户4,5.0客户5,6.0客户6,7.0客户7,8.0客户8,9.0客户9265000.00.12296983758755000.0,10.0客户10110000.00.0510440835267110000.0,11.0,12.0,13.0,14.0,15.0,序号品名编号型号规格采购金额占比每月采购明细,1.02.03.04.05.06.07.08.09.010.011.012.0,1.0产品1C00001,2.0C00002,3.0产品2C00003,4.0C00004,5.0产品3C00005,6.0C00006,7.0产品4C00007,8.0C00008275000.00.12761020881755000.0,9.0产品5C00009,10.0C00010,11.0,12.0,13.0,14.0,15.0,月份：1.0,序号客户本月销售额下月销售目标增长比例责任人同类型产品对比销售计划备注,1.0产品1我司产品与竞争对手同类型产品相比，常规性能相似，老化性能我司更优，外观缺陷相似，价格我司较贵。保持性能的同时改善外观不良缺陷，降低成本从而在价格上取得优势。2.0产品2,3.0产品3,4.0产品4王五,吴文,5.0产品5王五,吴文,6.00.0,7.0,8.0,9.0,10.0,11.0