最新、月采购部业务数据分析课件

11月采购数据分析汇报人：黄锐汇报时间：2010年12月11月采购数据分析汇报人：黄锐1、小结2、采购贡献完成情况3、缺货管理4、库存周转率完成情况5、不良库存处理进度6、调拨完成情况7、对外应付完成情况8、大库存控制率情况9、价格差错通报10、利润延伸收取情况11、采购员主要业绩排名情况12、采购组长主要业绩排名情况13、下阶段工作安排大纲1、小结大纲1、小结项目指标实际完成完成率采购量(包含中药、计生、器械、原料药)/28849.31/销售量24542.7025330.87103.21%毛利率5.10%4.74%92.94%采购贡献率//98.08%缺货控制率15.00%16.04%93.52%库存周转率30.0032.3192.85%老批号4.00%9.13%43.81%近效期0.04%0.110%36.36%废品库0.01%0.010%100.00%调拨完成2969.001454.3248.98%对外应付1500017845.10118.97%1、小结项目指标实际完成完成率采购量(包含中药、计生、器2、采购贡献完成情况采购员实际销售金额目标销售金额销售金额完成率实际毛利率目标毛利率毛利率完成率实际毛利额目标毛利额毛利额完成率采购贡献率排名汤建锋5516.294497.58122.65%4.28%5.00%85.60%236.24224.88105.05%104.13%1柯巍639.31606.05105.49%5.03%5.10%98.63%32.1330.91103.95%102.06%2韩志芹1777.741992.0789.24%3.81%3.40%112.06%67.8167.73100.12%100.65%3万碧林1588.661417.02112.11%4.83%5.50%87.82%76.7877.9498.51%99.97%4何刚1700.121614.68105.29%5.34%5.80%92.07%90.7193.6596.86%98.68%5刘国辉420.85479.8087.71%5.70%5.20%109.62%23.9824.9596.11%98.67%6孙美华406.88377.58107.76%5.35%6.10%87.70%21.7723.0394.53%97.73%7刘小敏525.88521.87100.77%7.69%8.30%92.65%40.4743.3193.44%96.71%8姚晏407.80433.0694.17%6.97%7.10%98.17%28.4430.7592.49%96.17%9陈志豪1326.871232.63107.65%4.91%6.10%80.49%65.1575.1986.65%94.07%10郑建伦621.40710.3387.48%6.73%6.90%97.54%41.8149.0185.31%92.51%11邱军498.56551.8890.34%5.66%6.20%91.29%28.2234.2282.47%90.82%12林克滨1177.461321.2489.12%4.44%4.80%92.50%52.2663.4282.40%90.81%13孙修能2635.872939.6889.67%2.98%3.50%85.14%78.60102.8976.39%87.41%14郑恋1280.561593.7380.35%7.61%8.10%93.95%97.48129.0975.51%87.15%15杨元魁2835.472546.69111.34%2.52%4.50%56.00%71.45114.6062.35%83.67%16部门整体25330.8724542.70103.21%4.74%5.10%86.67%1120.381251.6889.51%98.08%2、采购贡献完成情况采购员实际销售金额目标销售金额销3、缺货管理采购员品规数缺货天数实际缺货率缺货目标控制率排名柯巍364160714.72%22.64%153.80%1陈志豪2736057.39%10.35%140.05%2孙美华327261426.65%32.85%123.26%3孙修能380170014.91%10.89%73.04%14韩志芹279121814.55%9.95%68.38%15郑恋434282821.72%13.83%63.67%16部门整体64503104016.04%15.00%93.52%3、缺货管理采购员品规数缺货天数实际缺货率缺货目标控制率排名4、库存周转率完成情况采购员实际周转天数目标周转天数周转率完成率排名邱军25.8932.9127.08%1柯巍22.1727.38123.50%2杨元魁24.5829.93121.77%3郑恋46.0235.0976.25%14韩志芹33.8124.7873.29%15陈志豪61.1444.472.62%16部门整体32.313092.85%4、库存周转率完成情况采购员实际周转天数目标周转天数周转率完5、不良库存处理进度采购员老批号库存控制率近效期库存控制率废品库库存控制率不良库存综合控制率排名孙美华200.00%200.00%200.00%200.00%1郑建伦200.00%190.48%200.00%197.62%2孙修能185.19%200.00%200.00%192.60%3韩志芹30.70%200.00%90.91%88.08%14郑恋101.01%26.32%66.67%73.75%15汤建锋32.08%10.13%200.00%68.57%16部门整体43.81%36.36%100.00%56.00%5、不良库存处理进度采购员老批号库存控制率近效期库存控制率废6、调拨完成情况采购员实际调拨目标调拨调拨完成率排名孙美华39.6126.42149.92%1刘小敏148.99123.21120.92%2孙修能353.95299.87118.03%3汤建锋28.54457.526.24%14杨元魁1.7035.334.81%15柯巍1.0632.363.28%16部门整体1454.322969.0048.98%6、调拨完成情况采购员实际调拨目标调拨调拨完成率排名孙美华37、对外应付完成情况采购员实际应付目标应付应付完成率排名杨元魁526.16107.00491.74%1林克滨1251.18957.00130.74%2韩志芹4349.233414.00127.39%3郑建伦916.84987.0092.89%14姚晏748.15812.0092.14%15柯巍360.85689.0052.37%16部门整体17845.1015000.00118.97%7、对外应付完成情况采购员实际应付目标应付应付完成率排名杨元8、大库存控制率情况采购员截止到11.30总库存额大库存金额大库存控制率排名何刚12987591.10793441.366.11%1杨元魁24124674.361620346.116.72%2林克滨10563592.24800950.677.58%3郑建伦7340279.442598043.4235.39%14郑恋19461243.139041151.4146.46%15陈志豪23689419.4714396886.1760.77%16部门整体248658679.7058939979.3923.70%8、大库存控制率情况采购员截止到11.30总库存额大库存金额9、价格差错通报采购员核算成本价差错数成本价销售指导售价价格差错数销售类别汇总韩志芹

1

1何刚

1

1孙美华

1

1部门整体0003039、价格差错通报采购员核算成本价差错数成本价销售指导售价价格10、利润延伸收取情况责任人广告费流向费会务费礼金礼品租赁费合计万碧林1200.000.0073680.000.00150.000.0075030.00刘小敏30000.00500.0075900.001000.000.001000.00108400.00邱军0.00500.0071350.000.00240.000.0072090.00何刚33250.000.0082000.001200.001018.000.00117468.00黄锐4000.000.0070000.000.000.000.0074000.00郑建伦5000.000.0062400.000.000.000.0067400.00汤建锋0.00700.00170000.000.004600.000.00175300.00孙美华0.000.0049808.000.00103.000.0049911.00刘国辉2000.00500.0040032.120.00290.000.0042822.12陈志豪0.000.0013000.000.000.000.0013000.00杨元魁1900.000.0093992.800.00360.000.0096252.80郑恋12000.000.0072600.000.000.000.0084600.00柯巍3940.002000.0081028.640.00-35.000.0086933.64林克滨1000.000.00114737.000.000.000.00115737.00韩志芹2403.800.0042688.000.000.000.0045091.80姚晏1600.000.0064962.000.00308.000.0066870.00孙修能18000.000.00134601.600.000.000.00152601.60汪泉（总监）0.000.000.003000.001766.000.004766.00汇总116293.804200.001312780.165200.008800.001000.001448273.9610、利润延伸收取情况责任人广告费流向费会务费12、采购员业绩排名采购员缺货控制率周转率完成率采购贡献率目标完成率上月排名本月月排名柯巍153.80%123.50%102.06%124.01%31孙美华123.26%117.05%97.73%111.19%112邱军111.21%127.08%90.82%107.82%43郑建伦123.23%95.17%92.51%102.52%94陈志豪140.05%72.62%94.07%98.98%105汤建锋91.38%90.62%104.13%98.88%66何刚95.71%98.25%98.68%97.66%147杨元魁88.18%121.77%83.67%96.45%78万碧林76.34%110.98%99.97%96.18%29姚晏96.65%91.14%96.17%94.81%1210刘国辉80.00%101.41%98.67%93.89%1511刘小敏85.92%90.77%96.71%91.69%512林克滨79.96%97.35%90.81%89.52%1313韩志芹68.38%73.29%100.65%82.76%1614孙修能73.04%81.34%87.41%81.28%115郑恋63.67%76.25%87.15%80.27%816部门整体93.52%92.85%94.94%93.89%12、采购员业绩排名采购员缺货控制率周转率完成率采12、采购组长业绩排名剂型缺货控制率周转率完成率采购贡献率目标完成率上月排名本月排名中成药103.93%108.59%97.65%102.82%51片剂101.84%104.34%98.83%101.39%42针剂89.71%109.78%97.38%98.80%13水剂92.91%93.15%89.70%91.70%24集采82.65%83.86%97.07%91.54%35部门整体93.52%92.85%94.94%93.89%12、采购组长业绩排名剂型缺货控制率周转率完成率采购贡献13、下阶段重点工作继续跟进本年度协议的完成情况，重点厂家重点沟通。2011年一级协议和二级客户的争取。重点关注缺货控制，及时进行缺货分析，多渠道采购。加强大库存和老批号的处理，不良库存的控制，争取达到200%要求中小客户在本月结算前以票折或者抵货款方式兑现返利，提前开展返利清收工作2010年终答谢会赞助剩余费用的催收，已收180万继续跟进综合利润提升项目。13、下阶段重点工作继续跟进本年度协议的完成情况，重点厂家重工作所需支持及建议序号支持项目支持内容支持部门支持时间1老批号促销盖中盖，奥美拉唑等近效期产品促销中山本部及各三级公司营销部根据老批号库存情况，不定期进行，以月为阶段。工作所需支持及建议序号支持项目支持内容支持部门支持时间1老批ThankYou!ThankYou!11月采购数据分析汇报人：黄锐汇报时间：2010年12月11月采购数据分析汇报人：黄锐1、小结2、采购贡献完成情况3、缺货管理4、库存周转率完成情况5、不良库存处理进度6、调拨完成情况7、对外应付完成情况8、大库存控制率情况9、价格差错通报10、利润延伸收取情况11、采购员主要业绩排名情况12、采购组长主要业绩排名情况13、下阶段工作安排大纲1、小结大纲1、小结项目指标实际完成完成率采购量(包含中药、计生、器械、原料药)/28849.31/销售量24542.7025330.87103.21%毛利率5.10%4.74%92.94%采购贡献率//98.08%缺货控制率15.00%16.04%93.52%库存周转率30.0032.3192.85%老批号4.00%9.13%43.81%近效期0.04%0.110%36.36%废品库0.01%0.010%100.00%调拨完成2969.001454.3248.98%对外应付1500017845.10118.97%1、小结项目指标实际完成完成率采购量(包含中药、计生、器2、采购贡献完成情况采购员实际销售金额目标销售金额销售金额完成率实际毛利率目标毛利率毛利率完成率实际毛利额目标毛利额毛利额完成率采购贡献率排名汤建锋5516.294497.58122.65%4.28%5.00%85.60%236.24224.88105.05%104.13%1柯巍639.31606.05105.49%5.03%5.10%98.63%32.1330.91103.95%102.06%2韩志芹1777.741992.0789.24%3.81%3.40%112.06%67.8167.73100.12%100.65%3万碧林1588.661417.02112.11%4.83%5.50%87.82%76.7877.9498.51%99.97%4何刚1700.121614.68105.29%5.34%5.80%92.07%90.7193.6596.86%98.68%5刘国辉420.85479.8087.71%5.70%5.20%109.62%23.9824.9596.11%98.67%6孙美华406.88377.58107.76%5.35%6.10%87.70%21.7723.0394.53%97.73%7刘小敏525.88521.87100.77%7.69%8.30%92.65%40.4743.3193.44%96.71%8姚晏407.80433.0694.17%6.97%7.10%98.17%28.4430.7592.49%96.17%9陈志豪1326.871232.63107.65%4.91%6.10%80.49%65.1575.1986.65%94.07%10郑建伦621.40710.3387.48%6.73%6.90%97.54%41.8149.0185.31%92.51%11邱军498.56551.8890.34%5.66%6.20%91.29%28.2234.2282.47%90.82%12林克滨1177.461321.2489.12%4.44%4.80%92.50%52.2663.4282.40%90.81%13孙修能2635.872939.6889.67%2.98%3.50%85.14%78.60102.8976.39%87.41%14郑恋1280.561593.7380.35%7.61%8.10%93.95%97.48129.0975.51%87.15%15杨元魁2835.472546.69111.34%2.52%4.50%56.00%71.45114.6062.35%83.67%16部门整体25330.8724542.70103.21%4.74%5.10%86.67%1120.381251.6889.51%98.08%2、采购贡献完成情况采购员实际销售金额目标销售金额销3、缺货管理采购员品规数缺货天数实际缺货率缺货目标控制率排名柯巍364160714.72%22.64%153.80%1陈志豪2736057.39%10.35%140.05%2孙美华327261426.65%32.85%123.26%3孙修能380170014.91%10.89%73.04%14韩志芹279121814.55%9.95%68.38%15郑恋434282821.72%13.83%63.67%16部门整体64503104016.04%15.00%93.52%3、缺货管理采购员品规数缺货天数实际缺货率缺货目标控制率排名4、库存周转率完成情况采购员实际周转天数目标周转天数周转率完成率排名邱军25.8932.9127.08%1柯巍22.1727.38123.50%2杨元魁24.5829.93121.77%3郑恋46.0235.0976.25%14韩志芹33.8124.7873.29%15陈志豪61.1444.472.62%16部门整体32.313092.85%4、库存周转率完成情况采购员实际周转天数目标周转天数周转率完5、不良库存处理进度采购员老批号库存控制率近效期库存控制率废品库库存控制率不良库存综合控制率排名孙美华200.00%200.00%200.00%200.00%1郑建伦200.00%190.48%200.00%197.62%2孙修能185.19%200.00%200.00%192.60%3韩志芹30.70%200.00%90.91%88.08%14郑恋101.01%26.32%66.67%73.75%15汤建锋32.08%10.13%200.00%68.57%16部门整体43.81%36.36%100.00%56.00%5、不良库存处理进度采购员老批号库存控制率近效期库存控制率废6、调拨完成情况采购员实际调拨目标调拨调拨完成率排名孙美华39.6126.42149.92%1刘小敏148.99123.21120.92%2孙修能353.95299.87118.03%3汤建锋28.54457.526.24%14杨元魁1.7035.334.81%15柯巍1.0632.363.28%16部门整体1454.322969.0048.98%6、调拨完成情况采购员实际调拨目标调拨调拨完成率排名孙美华37、对外应付完成情况采购员实际应付目标应付应付完成率排名杨元魁526.16107.00491.74%1林克滨1251.18957.00130.74%2韩志芹4349.233414.00127.39%3郑建伦916.84987.0092.89%14姚晏748.15812.0092.14%15柯巍360.85689.0052.37%16部门整体17845.1015000.00118.97%7、对外应付完成情况采购员实际应付目标应付应付完成率排名杨元8、大库存控制率情况采购员截止到11.30总库存额大库存金额大库存控制率排名何刚12987591.10793441.366.11%1杨元魁24124674.361620346.116.72%2林克滨10563592.24800950.677.58%3郑建伦7340279.442598043.4235.39%14郑恋19461243.139041151.4146.46%15陈志豪23689419.4714396886.1760.77%16部门整体248658679.7058939979.3923.70%8、大库存控制率情况采购员截止到11.30总库存额大库存金额9、价格差错通报采购员核算成本价差错数成本价销售指导售价价格差错数销售类别汇总韩志芹

1

1何刚

1

1孙美华

1

1部门整体0003039、价格差错通报采购员核算成本价差错数成本价销售指导售价价格10、利润延伸收取情况责任人广告费流向费会务费礼金礼品租赁费合计万碧林1200.000.0073680.000.00150.000.0075030.00刘小敏30000.00500.0075900.001000.000.001000.00108400.00邱军0.00500.0071350.000.00240.000.0072090.00何刚33250.000.0082000.001200.001018.000.00117468.00黄锐4000.000.0070000.000.000.000.0074000.00郑建伦5000.000.0062400.000.000.000.0067400.00汤建锋0.00700.00170000.000.004600.000.00175300.00孙美华0.000.0049808.000.00103.000.0049911.00刘国辉2000.00500.0040032.120.00290.000.0042822.12陈志豪0.000.0013000.000.000.000.0013000.00杨元魁1900.000.0093992.800.00360.000.0096252.80郑恋12000.000.0072600.000.000.000.0084600.00柯巍3940.002000.0081028.640.00-35.000.0086933.64林克滨1000.000.00114737.000.000.000.00115737.00韩志芹2403.800.0042688.000.000.000.0045091.80姚晏1600.000.0064962.000.00308.000.0066870.00孙修能18000.000.00134601.600.000.000.00152601.60汪泉（总监）0.000.000.003000.001766.000.004766.00汇总116293.804200.001312780.165200.008800.001000.001448273.9610、利润延伸收取情况责任人广告费流向费会务费12、采购员业绩排名采购员缺货控制率周转率完成率采购贡献率目标完成率上月排名本月月排名柯巍153.80%123.50%102.06%