201308福州完成率分析.xls

《201308福州完成率分析.xls》由会员分享，可在线阅读，更多相关《201308福州完成率分析.xls（2462页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、送货(全部)重货1列列标标签签1-3T1-3T3-5T3-5T0.5T0.5T以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下599249081620601620365633188200-400Km1424711434271214010355121871311573400-600Km386223038546142081276093392722061600-900Km992538670111242

2、577431432611506976794900-1200Km11992012144013359255671353598444769901500-1800Km3844834625272145620732773841570991800-2100Km66499617974128677407271289058701792100-2500Km2012821903131120013459359892485012500-2900Km8185866751294016210431440252682900-3300Km280029772802674321200-1500Km3089831436279450870

3、9336186273513300公里Km1113010332364606130总总计计4561214561214266054266054524522139632139632348502348501141145776195776194325664325665T5T以以上上0.5-1T0.5-1T求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数80480053703325719811522672

4、170662331557019058710660813343713306055430317707203287167371310946121201986438634325349120156677752497165366929308255737315243277910626055443313137174835277641441324472698405893239253215658192117486850097432411503403056233884216476249213821944228112602103305113136981168414662636182936677568547176011

5、7263236250902122640101624887222059255503423515219653770377016267816267818366818366852523146453146452612842612846026021725026172502615389731538973求求和和项项:票票数数汇汇总总0.5T以下完成率0.5T以下 收入0.5T以下 票数0.5-1T 完成率0.5-1T收入0.5-1T票数1-3T 完成率1-3T 收入117200Km以下205.9%656380164.4%325715122.1%5992322200-400Km161.7%1871323313

6、1.1%1066043124.6%14247411400-600Km153.8%33927303127.7%1673746127.1%386221181600-900Km149.8%115069863127.2%66777165114.5%992531046900-1200Km127.9%98444737115.0%6260513198.7%1199205091500-1800Km129.3%73841414125.3%4058953111.0%384485971800-2100Km126.9%89058486120.9%4115056107.6%664992932100-2500Km123.

7、5%59892249110.0%213822891.9%201281362500-2900Km124.4%31440113117.2%136981494.4%8185452900-3300Km108.0%80263698.8%6775794.1%28003061200-1500Km132.3%36186236118.2%250904098.3%30898273300公里Km105.4%646020107.7%59254107.7%1113049904990总计133.5%5776193770120.4%314645602106.9%4561211-3T 票数3-5T 完成率3-5T 收入3-5

8、T 票数5T以上完成率5T以上收入5T以上票数平均完成率总收入总票数16127.2%2060389.4%48003132.8%2267211727117.2%121401281.7%155707117.8%7133032246111.3%14208987.1%177077122.9%12120141111298.7%425772688.1%4325315119.0%366929118113388.3%592553596.2%3152410105.4%371748104627103.5%21456787.4%413248112.3%2156585094170.4%286771287.2%8500

9、2108.0%2338845971383.2%112003109.0%112602293579.8%129404107.2%662631362102.0%176014527108.5%94503114.5%1016243063107.1%235152745291.1%21396311488.6%16267852112.1%17250264990送货(全部)重货0列列标标签签10-2010-20方方1-31-3方方1 1方方以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票

10、数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下278618993648445274265004244200-400Km17293189701721746159621052662317777400-600Km29983347571845013350581454517034324600-900Km14384715854293219931186192735184398147080900-1200Km18281219900611632205530442611462353492218941500-1800Km601175901320103638889812071067739

11、54661800-2100Km92758104578301282991145432581132181006022100-2500Km7400132273745796924912465077634252500-2900Km2730029706631225305214740045383052900-3300Km1134515468318921185302516825180523300Km以上11880116782165101591817888188631200-1500Km35130382151462192552431456647361620总总计计622651622651685059685059

12、32532510505931050593939150939150299629969153329153328116528116522020方方以以上上3-103-10方方求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数13214001343110156829025273262030245410045106865815869282819515729315622363539902873167848

13、648569119200417186823898485797033263292573296804399622909185273115174759211189385957056190217971510680155553699645565457367986599205488414752381249936465404244781739641753521395547795375224787750768417987085414502346762389982591193014184224205274651313470514018111427040163581147751749398890685901515

14、95062372432214269678316500237594845408127571264835260112103421034243037643037647329047329094941566515156651515999651599965191919194585467458546745091164509116求求和和项项:票票数数汇汇总总1方以下 完成率1方以下收入1方以下票数1-3方完成率1-3方收入1-3方票数3-10方 完成率203200Km以下153.2%6500132143.2%648442122.5%776200-400Km149.8%26623454136.2%217461

15、0587.9%890400-600Km131.6%45170635128.4%45013145104.6%3682600-900Km125.4%1843982389118.1%21993173599.9%5212900-1200Km106.1%2353493115105.8%322055114696.2%13181500-1800Km111.8%106773996116.5%103638207107.2%13711800-2100Km112.5%113218936112.0%12829925899.2%6562100-2500Km102.6%65077478107.7%7457912493.5

16、%3272500-2900Km104.5%40045259102.3%312254788.1%1522900-3300Km93.2%16825114102.1%189212584.5%723300Km以上100.2%888151103.7%165101795.4%10171200-1500Km107.9%66473783112.6%62192145104.0%1567615676总计112.8%91533210342111.9%1050593299697.9%3-10方收入3-10方票数10-20方完成率10-20方收入10-20方票数20方以上完成率20方以上 收入20方以上 票数平均完成率

17、 总收入总票数1015625146.7%27863104.3%14001134.6%273262038158619591.2%172931794.0%100455100.7%157293776678489186.3%2998318138.9%39901111.7%19200489032925743990.7%1438479387.5%8485726104.8%962290368259570579791.9%18281211682.8%1747593897.1%151068052129865988101.9%601172099.6%455657108.8%41475213181739641398

18、8.7%9275830109.6%465408103.2%5547791371798705055.9%74003100.9%7750198.2%234676656242051391.9%27300684.1%11930296.1%13470532714775973.3%113453165.3%270401103.5%8890615259502101.7%118802101.2%4322172845407191.9%351301469.4%165004101.8%26483510171566515191990.9%62265132590.9%43037694101.7%458546715676送

19、货(全部)重货1列列标标签签1-3T1-3T3-5T3-5T0.5T0.5T以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下20842152585483096684162230814365200-400Km3794238984801864220682232312317167400-600Km4311544458603196141376281450413768600-900Km3097713676

20、7943127055134000619210886191916900-1200Km24963931351431719057924736612388548824171500-1800Km1712621746421121224791203493977407681021800-2100Km8990399606691139741001313262161561442100-2500Km88328927894767785663751830207293882500-2900Km21842238481339004005129535281312900-3300Km219222452797200689511600

21、4164203300Km以上420849362820887381200-1500Km6261765908482950729585123050826524总总计计1121390112139012661481266148124212428648888648889834549834544854855113745113744530814530815T5T以以上上0.5-1T0.5-1T求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基

22、准准运运费费求求和和项项:票票数数3141043384459535107927856551665898875831415786215898258175791431769255149250133122207633219169451790417261463151173360326761134457147195332210492310475328619285632376307587852901111047918492394966542171474061185043037852206155068640675336304610196074297682629730870033882331486764663

23、269623415641336138185693212609232131821307273933314224681073389932517318242161711810741710467258837799563245900612761348061496012731000365291104211023995383760442166659786427511242572125939212866207550318431843688301368830143362494336249757757439938439938425622425622942942662589166258917464553746455

24、3求求和和项项:票票数数汇汇总总0.5T以下完成率0.5T以下 收入0.5T以下 票数0.5-1T 完成率0.5-1T收入0.5-1T票数1-3T 完成率474200Km以下155.3%22308314137.4%1079255136.6%544200-400Km134.7%23123314122.8%175796997.3%301400-600Km105.3%14504122103.7%179044697.0%1907600-900Km118.4%108861676100.2%10492328684.3%1428900-1200Km107.4%8854858795.6%9239421779.

25、6%6701500-1800Km113.7%77407378107.1%6753310198.1%4981800-2100Km110.7%62161297104.4%486766990.3%2532100-2500Km102.8%30207138100.1%213182795.2%1422500-2900Km105.0%29535107112.8%182421891.6%782900-3300Km97.5%160045896.3%5900689.4%393300Km以上93.9%820827101.8%10421985.2%2761200-1500Km115.0%30508166114.1%2

26、42573995.0%66106610总计112.9%5113743184103.4%43993894288.6%1-3T 收入1-3T 票数3-5T 完成率3-5T 收入3-5T 票数5T以上完成率5T以上收入5T以上票数平均完成率总收入总票数2084254124.3%830916234.0%10433835187.7%166589474379428090.1%186422399.3%15786258102.0%255149544431156077.2%319612894.7%2076334593.8%31511730130977143179.6%27055119277.1%11344573

27、2281.2%1928563190724963931777.0%19057912376.8%85290118479.7%14740611428171262112101.8%1224793994.8%5220614098.4%9607426708990369113.8%1139743291.1%3087003197.2%6234154988832847102.1%677851887.3%1856932393.1%393331253218421397.4%39001104.2%338993102.6%107417142219229104.4%7200187.6%83779490.1%1348067

28、84208284.9%31000189.1%5383739626174899.7%2950712102.6%6597811102.6%2128662761121390124287.9%86488848585.1%368830175788.8%66258916610送货(全部)重货0列列标标签签10-2010-20方方1-31-3方方1 1方方以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下229

29、23252484425575159501653731720609200-400Km31852318753228810188671162537316715400-600Km860091258997139780370981402578321970600-900Km3895704637252513039382995261011204693181081900-1200Km4339725222652632709002724048962037131956961500-1800Km3099943245881031878761872344051232831293391800-2100Km38269741975

30、41312031172068194271432611470512100-2500Km1242911340253412052212873121175490831072500-2900Km3361136454844447479767431627368552900-3300Km1023112388322808259743220184250323300Km以上178602295541083612641156897102051200-1500Km1631401726286491474891242075520153811总总计计200615120061512291804229180410081008135

31、0084135008413423431342343369936999528229528229214699214692020方方以以上上3-103-10方方求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数482123267250467187543744223218426345635450629987797912273449183433709522301520205427919595628897

32、167894241042481464369535781861732118570113244642716363027078488872720205297664421177626008700841685960026919818112267186255242998916457371743904163351750360775297261864127458391040105937411111081324405394708543612228988235558547426286823733026261962281396168845132864588190613236997839171008191264121

33、532656177731106488125171373288227094330358343341398834107229429184362182552302011122074891806952897056048189818955405445540544612720161272011081108128255942825594307628330762833212321212675195126751951375910013759100求求和和项项:票票数数汇汇总总1方以下 完成率1方以下收入1方以下票数1-3方完成率1-3方 收入1-3方票数3-10方 完成率1062200Km以下181.1%373

34、17482160.4%25575165128.7%576200-400Km151.8%25373299152.7%28810116113.4%703400-600Km117.4%25783279107.2%3978014085.8%4152600-900Km113.0%2046931732101.5%303938101189.9%4255900-1200Km104.1%203713211799.4%27090089686.1%19571500-1800Km95.3%123283989100.3%18787640597.5%20911800-2100Km97.4%143261104098.2%2

35、0311742793.6%9132100-2500Km90.8%7549047493.6%12052221193.1%3112500-2900Km85.8%3162719092.6%444477487.6%1872900-3300Km80.6%2018412187.8%228083286.2%723300Km以上67.6%68973785.7%108361588.4%9101200-1500Km102.6%55201429102.6%9147420796.9%1718917189总计103.4%9528228189100.6%1350084369991.9%3-10方收入3-10方票数10-2

36、0方完成率10-20方收入10-20方票数20方以上完成率20方以上收入20方以上 票数平均完成率总收入总票数5437418490.8%229234449.2%12326718774.3%2634561062491839599.9%318523296.2%8779734110.4%2230155768942414668.3%860097167.8%1959566775.6%43695370363630288784.0%38957025189.5%118570127191.4%2720205415259600281183.1%43397226387.6%76260016888.8%2267186

37、425535175029795.5%30999410394.4%164573716395.4%2618641195744053936191.2%38269713195.3%105937413294.6%2228988209126196216892.7%12429134110.8%2628682697.7%845132913613233992.2%33611889.4%171008311532653182.6%10231385.1%106488187303581377.8%178604121.4%32882392.2%988347220111218094.5%16314064101.0%1843

38、623098.5%6952899102825594321287.5%2006151100890.4%5540544108192.1%1267519517189零担重货0.5T以下完成率0.5T以下票数0.5-1T完成率0.5-1T票数1-3T 完成率1-3T 票数3-5T 完成率3-5T 票数1200Km以下205.9%80164.4%15122.1%16127.2%32200-400Km161.7%233131.1%43124.6%27117.2%123400-600Km153.8%303127.7%46127.1%46111.3%94600-900Km149.8%863127.2%1651

39、14.5%11298.7%265900-1200Km127.9%737115.0%13198.7%13388.3%3561200-1500Km132.3%236118.2%4098.3%27108.5%371500-1800Km129.3%414125.3%53111.0%27103.5%781800-2100Km126.9%486120.9%56107.6%4170.4%1292100-2500Km123.5%249110.0%2891.9%1383.2%3102500-2900Km124.4%113117.2%1494.4%579.8%4112900-3300Km108.0%3698.8%

40、794.1%2123300Km以上105.4%20107.7%4107.7%313总总计计133.5%37703770120.4%602602106.9%45245291.1%114114132.8%117.8%122.9%119.0%105.4%114.5%112.3%108.0%109.0%107.2%102.0%107.1%200Km以下 200-400Km400-600Km600-900Km 900-1200Km1200-1500Km1500-1800Km1800-2100Km2100-2500Km2500-2900Km2900-3300Km3300Km以上0%50%100%150%2

41、00%250%0 200 400 600 800 1000 1200 1400 0.5T以下 票数0.5-1T 票数1-3T 票数3-5T 票数5T以上 票数0.5T以下 完成率0.5-1T 完成率1-3T 完成率3-5T 完成率5T以上 完成率平均完成率完完成成率率票票数数2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图完完成成率率票票数数2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图5T以上完成率5T以上票数平均完成率 总收入总票数0.5T以下完成率0.5T以下收入0.5-1T完成率89.4%3132.8%22672117200Km以下205.9%31

42、88164.4%81.7%7117.8%71330322200-400Km161.7%11573131.1%87.1%7122.9%121201411400-600Km153.8%22061127.7%88.1%15119.0%3669291181600-900Km149.8%76794127.2%96.2%10105.4%3717481046900-1200Km127.9%76990115.0%114.5%2156583061200-1500Km132.3%27351118.2%87.4%8112.3%2338845091500-1800Km129.3%57099125.3%87.2%210

43、8.0%1126025971800-2100Km126.9%70179120.9%109.0%662632932100-2500Km123.5%48501110.0%107.2%176011362500-2900Km124.4%25268117.2%102.0%23515452900-3300Km108.0%743298.8%107.1%101624273300Km以上105.4%6130107.7%88.6%5252112.1%172502617250264990总总计计133.5%432566432566120.4%132.8%117.8%122.9%119.0%105.4%114.5%1

44、12.3%108.0%109.0%107.2%102.0%107.1%200Km以下 200-400Km400-600Km600-900Km 900-1200Km1200-1500Km1500-1800Km1800-2100Km2100-2500Km2500-2900Km2900-3300Km3300Km以上0%50%100%150%200%250%0 50000 100000 150000 200000 250000 300000 350000 400000 0.5T以下 收入0.5-1T 收入1-3T 收入3-5T 收入5T以上 收入0.5T以下 完成率0.5-1T 完成率1-3T 完成率

45、3-5T 完成率5T以上 完成率平均完成率完完成成率率收收入入元元2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图完完成成率率收收入入元元2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图132.8%117.8%122.9%119.0%105.4%114.5%112.3%108.0%109.0%107.2%102.0%107.1%200Km以下 200-400Km400-600Km600-900Km 900-1200Km1200-1500Km1500-1800Km1800-2100Km2100-2500Km2500-2900Km2900-3300Km3300K

46、m以上0%50%100%150%200%250%0 200 400 600 800 1000 1200 1400 0.5T以下 票数0.5-1T 票数1-3T 票数3-5T 票数5T以上 票数0.5T以下 完成率0.5-1T 完成率1-3T 完成率3-5T 完成率5T以上 完成率平均完成率完完成成率率票票数数2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图完完成成率率票票数数2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图0.5-1T收入1-3T 完成率1-3T 收入3-5T 完成率3-5T 收入5T以上完成率5T以上收入平均完成率总收入总票数1981122

47、.1%4908127.2%162089.4%5370132.8%226721178133124.6%11434117.2%1035581.7%19058117.8%7133032213109127.1%30385111.3%1276087.1%20328122.9%12120141152497114.5%8670198.7%4314388.1%49120119.0%36692911815443398.7%12144088.3%6713596.2%32779105.4%37174810462122698.3%31436108.5%8709114.5%21565830632392111.0%346

48、25103.5%2073287.4%47269112.3%23388450934030107.6%6179770.4%4072787.2%9743108.0%1126025971944291.9%2190383.2%13459109.0%662632931168494.4%866779.8%16210107.2%17601136685494.1%2977102.0%23515455503107.7%10332107.1%10162427261284261284106.9%42660542660591.1%23485023485088.6%183668183668112.1%1725026172

49、502649904990132.8%117.8%122.9%119.0%105.4%114.5%112.3%108.0%109.0%107.2%102.0%107.1%200Km以下 200-400Km400-600Km600-900Km 900-1200Km1200-1500Km1500-1800Km1800-2100Km2100-2500Km2500-2900Km2900-3300Km3300Km以上0%50%100%150%200%250%0 50000 100000 150000 200000 250000 300000 350000 400000 0.5T以下 收入0.5-1T 收入

50、1-3T 收入3-5T 收入5T以上 收入0.5T以下 完成率0.5-1T 完成率1-3T 完成率3-5T 完成率5T以上 完成率平均完成率完完成成率率收收入入元元2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图完完成成率率收收入入元元2013年年8月月福福州州零零担担重重货货完完成成率率情情况况图图零担泡货1方以下完成率1方以下票数1-3方 完成率1-3方 票数3-10方完成率3-10方票数10-20方完成率10-20方票数1200Km以下153.2%132143.2%42122.5%25146.7%32200-400Km149.8%454136.2%10587.9%195