201308福州完成率分析.xls

送货(全部)重货1列列标标签签1-3T1-3T3-5T3-5T0.5T0.5T以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下599249081620601620365633188200-400Km1424711434271214010355121871311573400-600Km386223038546142081276093392722061600-900Km992538670111242577431432611506976794900-1200Km11992012144013359255671353598444769901500-1800Km3844834625272145620732773841570991800-2100Km66499617974128677407271289058701792100-2500Km2012821903131120013459359892485012500-2900Km8185866751294016210431440252682900-3300Km280029772802674321200-1500Km30898314362794508709336186273513300公里Km1113010332364606130总总计计4561214561214266054266054524522139632139632348502348501141145776195776194325664325665T5T以以上上0.5-1T0.5-1T求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数804800537033257198115226721706623315570190587106608133437133060554303177072032871673713109461212019864386343253491201566777524971653669293082557373152432779106260554433131371748352776414413244726984058932392532156581921174868500974324115034030562338842164762492138219442281126021033051131369811684146626361829366775685471760117263236250902122640101624887222059255503423515219653770377016267816267818366818366852523146453146452612842612846026021725026172502615389731538973求求和和项项:票票数数汇汇总总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%18713233131.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.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-5T 票数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%85002108.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方方以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下278618993648445274265004244200-400Km17293189701721746159621052662317777400-600Km29983347571845013350581454517034324600-900Km14384715854293219931186192735184398147080900-1200Km18281219900611632205530442611462353492218941500-1800Km60117590132010363888981207106773954661800-2100Km92758104578301282991145432581132181006022100-2500Km7400132273745796924912465077634252500-2900Km2730029706631225305214740045383052900-3300Km1134515468318921185302516825180523300Km以上11880116782165101591817888188631200-1500Km35130382151462192552431456647361620总总计计62265162265168505968505932532510505931050593939150939150299629969153329153328116528116522020方方以以上上3-103-10方方求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数1321400134311015682902527326203024541004510686581586928281951572931562236353990287316784864856911920041718682389848579703326329257329680439962290918527311517475921118938595705619021797151068015555369964556545736798659920548841475238124993646540424478173964175352139554779537522478775076841798708541450234676238998259119301418422420527465131347051401811142704016358114775174939889068590151595062372432214269678316500237594845408127571264835260112103421034243037643037647329047329094941566515156651515999651599965191919194585467458546745091164509116求求和和项项:票票数数汇汇总总1方以下 完成率1方以下收入1方以下票数1-3方完成率1-3方收入1-3方票数3-10方 完成率203200Km以下153.2%6500132143.2%648442122.5%776200-400Km149.8%26623454136.2%2174610587.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%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方以上 票数平均完成率 总收入总票数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%414752131817396413988.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送货(全部)重货1列列标标签签1-3T1-3T3-5T3-5T0.5T0.5T以以下下行行标标签签求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费200Km以下20842152585483096684162230814365200-400Km3794238984801864220682232312317167400-600Km4311544458603196141376281450413768600-900Km30977136767943127055134000619210886191916900-1200Km24963931351431719057924736612388548824171500-1800Km1712621746421121224791203493977407681021800-2100Km8990399606691139741001313262161561442100-2500Km88328927894767785663751830207293882500-2900Km21842238481339004005129535281312900-3300Km2192224527972006895116004164203300Km以上420849362820887381200-1500Km6261765908482950729585123050826524总总计计1121390112139012661481266148124212428648888648889834549834544854855113745113744530814530815T5T以以上上0.5-1T0.5-1T求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数31410433844595351079278565516658988758314157862158982581757914317692551492501331222076332191694517904172614631511733603267611344571471953322104923104753286192856323763075878529011110479184923949665421714740611850430378522061550686406753363046101960742976826297308700338823314867646632696234156413361381856932126092321318213072739333142246810733899325173182421617118107417104672588377995632459006127613480614960127310003652911042110239953837604421666597864275112425721259392128662075503184318436883013688301433624943362497577574399384399384256224256229429426625891662589174645537464553求求和和项项:票票数数汇汇总总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.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%242573995.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%113445732281.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%134806784208284.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以下22923252484425575159501653731720609200-400Km31852318753228810188671162537316715400-600Km860091258997139780370981402578321970600-900Km3895704637252513039382995261011204693181081900-1200Km4339725222652632709002724048962037131956961500-1800Km3099943245881031878761872344051232831293391800-2100Km3826974197541312031172068194271432611470512100-2500Km1242911340253412052212873121175490831072500-2900Km3361136454844447479767431627368552900-3300Km1023112388322808259743220184250323300Km以上178602295541083612641156897102051200-1500Km1631401726286491474891242075520153811总总计计2006151200615122918042291804100810081350084135008413423431342343369936999528229528229214699214692020方方以以上上3-103-10方方求求和和项项:纯纯运运费费汇汇总总求求和和项项:基基准准运运费费汇汇总总求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数 求求和和项项:纯纯运运费费求求和和项项:基基准准运运费费求求和和项项:票票数数482123267250467187543744223218426345635450629987797912273449183433709522301520205427919595628897167894241042481464369535781861732118570113244642716363027078488872720205297664421177626008700841685960026919818112267186255242998916457371743904163351750360775297261864127458391040105937411111081324405394708543612228988235558547426286823733026261962281396168845132864588190613236997839171008191264121532656177731106488125171373288227094330358343341398834107229429184362182552302011122074891806952897056048189818955405445540544612720161272011081108128255942825594307628330762833212321212675195126751951375910013759100求求和和项项:票票数数汇汇总总1方以下 完成率1方以下收入1方以下票数1-3方完成率1-3方 收入1-3方票数3-10方 完成率1062200Km以下181.1%37317482160.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%20311742793.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-20方完成率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%2267186425535175029795.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%1843623098.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%165114.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%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%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月月福福州州零零担担重重货货完完成成率率情情况况图图5T以上完成率5T以上票数平均完成率 总收入总票数0.5T以下完成率0.5T以下收入0.5-1T完成率89.4%3132.8%22672117200Km以下205.9%3188164.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%2108.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%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 收入1-3T 收入3-5T 收入5T以上 收入0.5T以下 完成率0.5-1T 完成率1-3T 完成率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-3300Km3300Km以上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.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%34625103.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%1725026172502649904990132.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 收入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