最新、月采購部業(yè)務(wù)數(shù)據(jù)分析課件

11月采購數(shù)據(jù)分析匯報(bào)人：黃銳匯報(bào)時(shí)間：2010年12月11月采購數(shù)據(jù)分析匯報(bào)人：黃銳1、小結(jié)2、采購貢獻(xiàn)完成情況3、缺貨管理4、庫存周轉(zhuǎn)率完成情況5、不良庫存處理進(jìn)度6、調(diào)撥完成情況7、對外應(yīng)付完成情況8、大庫存控制率情況9、價(jià)格差錯(cuò)通報(bào)10、利潤延伸收取情況11、采購員主要業(yè)績排名情況12、采購組長主要業(yè)績排名情況13、下階段工作安排大綱1、小結(jié)大綱1、小結(jié)項(xiàng)目指標(biāo)實(shí)際完成完成率采購量(包含中藥、計(jì)生、器械、原料藥)/28849.31/銷售量24542.7025330.87103.21%毛利率5.10%4.74%92.94%采購貢獻(xiàn)率//98.08%缺貨控制率15.00%16.04%93.52%庫存周轉(zhuǎn)率30.0032.3192.85%老批號4.00%9.13%43.81%近效期0.04%0.110%36.36%廢品庫0.01%0.010%100.00%調(diào)撥完成2969.001454.3248.98%對外應(yīng)付1500017845.10118.97%1、小結(jié)項(xiàng)目指標(biāo)實(shí)際完成完成率采購量(包含中藥、計(jì)生、器2、采購貢獻(xiàn)完成情況采購員實(shí)際銷售金額目標(biāo)銷售金額銷售金額完成率實(shí)際毛利率目標(biāo)毛利率毛利率完成率實(shí)際毛利額目標(biāo)毛利額毛利額完成率采購貢獻(xiàn)率排名湯建鋒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、采購貢獻(xiàn)完成情況采購員實(shí)際銷售金額目標(biāo)銷售金額銷3、缺貨管理采購員品規(guī)數(shù)缺貨天數(shù)實(shí)際缺貨率缺貨目標(biāo)控制率排名柯巍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、缺貨管理采購員品規(guī)數(shù)缺貨天數(shù)實(shí)際缺貨率缺貨目標(biāo)控制率排名4、庫存周轉(zhuǎn)率完成情況采購員實(shí)際周轉(zhuǎn)天數(shù)目標(biāo)周轉(zhuǎn)天數(shù)周轉(zhuǎn)率完成率排名邱軍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、庫存周轉(zhuǎn)率完成情況采購員實(shí)際周轉(zhuǎn)天數(shù)目標(biāo)周轉(zhuǎn)天數(shù)周轉(zhuǎn)率完5、不良庫存處理進(jìn)度采購員老批號庫存控制率近效期庫存控制率廢品庫庫存控制率不良庫存綜合控制率排名孫美華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、不良庫存處理進(jìn)度采購員老批號庫存控制率近效期庫存控制率廢6、調(diào)撥完成情況采購員實(shí)際調(diào)撥目標(biāo)調(diào)撥調(diào)撥完成率排名孫美華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、調(diào)撥完成情況采購員實(shí)際調(diào)撥目標(biāo)調(diào)撥調(diào)撥完成率排名孫美華37、對外應(yīng)付完成情況采購員實(shí)際應(yīng)付目標(biāo)應(yīng)付應(yīng)付完成率排名楊元魁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、對外應(yīng)付完成情況采購員實(shí)際應(yīng)付目標(biāo)應(yīng)付應(yīng)付完成率排名楊元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、價(jià)格差錯(cuò)通報(bào)采購員核算成本價(jià)差錯(cuò)數(shù)成本價(jià)銷售指導(dǎo)售價(jià)價(jià)格差錯(cuò)數(shù)銷售類別匯總韓志芹

1

1何剛

1

1孫美華

1

1部門整體0003039、價(jià)格差錯(cuò)通報(bào)采購員核算成本價(jià)差錯(cuò)數(shù)成本價(jià)銷售指導(dǎo)售價(jià)價(jià)格10、利潤延伸收取情況責(zé)任人廣告費(fèi)流向費(fèi)會(huì)務(wù)費(fèi)禮金禮品租賃費(fèi)合計(jì)萬碧林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汪泉（總監(jiān)）0.000.000.003000.001766.000.004766.00匯總116293.804200.001312780.165200.008800.001000.001448273.9610、利潤延伸收取情況責(zé)任人廣告費(fèi)流向費(fèi)會(huì)務(wù)費(fèi)12、采購員業(yè)績排名采購員缺貨控制率周轉(zhuǎn)率完成率采購貢獻(xiàn)率目標(biāo)完成率上月排名本月月排名柯巍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、采購員業(yè)績排名采購員缺貨控制率周轉(zhuǎn)率完成率采12、采購組長業(yè)績排名劑型缺貨控制率周轉(zhuǎn)率完成率采購貢獻(xiàn)率目標(biāo)完成率上月排名本月排名中成藥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、采購組長業(yè)績排名劑型缺貨控制率周轉(zhuǎn)率完成率采購貢獻(xiàn)13、下階段重點(diǎn)工作繼續(xù)跟進(jìn)本年度協(xié)議的完成情況，重點(diǎn)廠家重點(diǎn)溝通。2011年一級協(xié)議和二級客戶的爭取。重點(diǎn)關(guān)注缺貨控制，及時(shí)進(jìn)行缺貨分析，多渠道采購。加強(qiáng)大庫存和老批號的處理，不良庫存的控制，爭取達(dá)到200%要求中小客戶在本月結(jié)算前以票折或者抵貨款方式兌現(xiàn)返利，提前開展返利清收工作2010年終答謝會(huì)贊助剩余費(fèi)用的催收，已收180萬繼續(xù)跟進(jìn)綜合利潤提升項(xiàng)目。13、下階段重點(diǎn)工作繼續(xù)跟進(jìn)本年度協(xié)議的完成情況，重點(diǎn)廠家重工作所需支持及建議序號支持項(xiàng)目支持內(nèi)容支持部門支持時(shí)間1老批號促銷蓋中蓋，奧美拉唑等近效期產(chǎn)品促銷中山本部及各三級公司營銷部根據(jù)老批號庫存情況，不定期進(jìn)行，以月為階段。工作所需支持及建議序號支持項(xiàng)目支持內(nèi)容支持部門支持時(shí)間1老批ThankYou!ThankYou!11月采購數(shù)據(jù)分析匯報(bào)人：黃銳匯報(bào)時(shí)間：2010年12月11月采購數(shù)據(jù)分析匯報(bào)人：黃銳1、小結(jié)2、采購貢獻(xiàn)完成情況3、缺貨管理4、庫存周轉(zhuǎn)率完成情況5、不良庫存處理進(jìn)度6、調(diào)撥完成情況7、對外應(yīng)付完成情況8、大庫存控制率情況9、價(jià)格差錯(cuò)通報(bào)10、利潤延伸收取情況11、采購員主要業(yè)績排名情況12、采購組長主要業(yè)績排名情況13、下階段工作安排大綱1、小結(jié)大綱1、小結(jié)項(xiàng)目指標(biāo)實(shí)際完成完成率采購量(包含中藥、計(jì)生、器械、原料藥)/28849.31/銷售量24542.7025330.87103.21%毛利率5.10%4.74%92.94%采購貢獻(xiàn)率//98.08%缺貨控制率15.00%16.04%93.52%庫存周轉(zhuǎn)率30.0032.3192.85%老批號4.00%9.13%43.81%近效期0.04%0.110%36.36%廢品庫0.01%0.010%100.00%調(diào)撥完成2969.001454.3248.98%對外應(yīng)付1500017845.10118.97%1、小結(jié)項(xiàng)目指標(biāo)實(shí)際完成完成率采購量(包含中藥、計(jì)生、器2、采購貢獻(xiàn)完成情況采購員實(shí)際銷售金額目標(biāo)銷售金額銷售金額完成率實(shí)際毛利率目標(biāo)毛利率毛利率完成率實(shí)際毛利額目標(biāo)毛利額毛利額完成率采購貢獻(xiàn)率排名湯建鋒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、采購貢獻(xiàn)完成情況采購員實(shí)際銷售金額目標(biāo)銷售金額銷3、缺貨管理采購員品規(guī)數(shù)缺貨天數(shù)實(shí)際缺貨率缺貨目標(biāo)控制率排名柯巍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、缺貨管理采購員品規(guī)數(shù)缺貨天數(shù)實(shí)際缺貨率缺貨目標(biāo)控制率排名4、庫存周轉(zhuǎn)率完成情況采購員實(shí)際周轉(zhuǎn)天數(shù)目標(biāo)周轉(zhuǎn)天數(shù)周轉(zhuǎn)率完成率排名邱軍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、庫存周轉(zhuǎn)率完成情況采購員實(shí)際周轉(zhuǎn)天數(shù)目標(biāo)周轉(zhuǎn)天數(shù)周轉(zhuǎn)率完5、不良庫存處理進(jìn)度采購員老批號庫存控制率近效期庫存控制率廢品庫庫存控制率不良庫存綜合控制率排名孫美華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、不良庫存處理進(jìn)度采購員老批號庫存控制率近效期庫存控制率廢6、調(diào)撥完成情況采購員實(shí)際調(diào)撥目標(biāo)調(diào)撥調(diào)撥完成率排名孫美華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、調(diào)撥完成情況采購員實(shí)際調(diào)撥目標(biāo)調(diào)撥調(diào)撥完成率排名孫美華37、對外應(yīng)付完成情況采購員實(shí)際應(yīng)付目標(biāo)應(yīng)付應(yīng)付完成率排名楊元魁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、對外應(yīng)付完成情況采購員實(shí)際應(yīng)付目標(biāo)應(yīng)付應(yīng)付完成率排名楊元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、價(jià)格差錯(cuò)通報(bào)采購員核算成本價(jià)差錯(cuò)數(shù)成本價(jià)銷售指導(dǎo)售價(jià)價(jià)格差錯(cuò)數(shù)銷售類別匯總韓志芹

1

1何剛

1

1孫美華

1

1部門整體0003039、價(jià)格差錯(cuò)通報(bào)采購員核算成本價(jià)差錯(cuò)數(shù)成本價(jià)銷售指導(dǎo)售價(jià)價(jià)格10、利潤延伸收取情況責(zé)任人廣告費(fèi)流向費(fèi)會(huì)務(wù)費(fèi)禮金禮品租賃費(fèi)合計(jì)萬碧林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汪泉（總監(jiān)）0.000.000.003000.001766.000.004766.00匯總116293.804200.001312780.165200.008800.001000.001448273.9610、利潤延伸收取情況責(zé)任人廣告費(fèi)流向費(fèi)會(huì)務(wù)費(fèi)12、采購員業(yè)績排名采購員缺貨控制率周轉(zhuǎn)率完成率采購貢獻(xiàn)率目標(biāo)完成率上月排名本月月排名柯巍153.80%123.50%102.06%