物流企业速递快运快递运输管理操作运营流程 宅急送 配送中心收益表.xls

潍潍坊坊专专线线收收益益表表序序发发车车时时间间车车号号代代收收运运费费及及货货款款合合计计整整车车成成本本整整车车资资费费收收入入整整车车毛毛利利毛毛利利率率专专线线收收入入费费用用南南昌昌资资费费收收入入占占专专线线收收入入的的比比例例率率南南昌昌收收入入毛毛利利占占专专线线费费用用的的比比例例率率装装卸卸成成本本费费市市内内送送货货运运费费中中转转托托运运成成本本中中转转配配送送运运费费成成本本小小计计市市内内配配送送资资费费收收入入外外出出卸卸货货收收入入中中转转资资费费收收入入专专线线加加收收10%10%收收入入整整车车装装卸卸收收入入收收入入合合计计11780.0050.00100.00665.0050.00865.00115.70665.0066.50162.501009.70144.7014.33%326330.94%4.43%24560.00100.00150130.0080.00460.00440.64146.0014.60325.00926.24466.2450.34%484019.14%9.63%36010.00130.00240.004.000.00374.00560.135.000.50325.00890.63516.6358.01%604014.75%8.55%49279.0060.0080.0049.000.00189.00187.1059.005.90162.50414.50225.5054.40%271515.27%8.31%511822.0040.0090.00240.000.00370.00135.62240.0024.00162.50562.12192.1234.18%122474.59%1.57%0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!0.000.00#DIV/0!合合计计33451.0033451.00 380.00380.00 660.00660.001088.001088.00130.00130.002258.002258.001439.191439.19 1115.001115.00 111.50111.500.000.001137.501137.503803.193803.191545.191545.1940.63%40.63%29105.0029105.0013.07%13.07%5.31%5.31%上上海海专专线线收收益益表表序序发发车车时时间间车车号号代代收收运运费费及及货货款款合合计计整整车车成成本本整整车车资资费费收收入入整整车车毛毛利利毛毛利利率率装装卸卸成成本本费费市市内内送送货货运运费费中中转转托托运运成成本本中中转转配配送送运运费费成成本本小小计计市市内内配配送送资资费费收收入入外外出出卸卸货货收收入入中中转转资资费费收收入入专专线线加加收收10%10%收收入入整整车车装装卸卸收收入入收收入入合合计计180.00455.001507.0030.002072.00710.601507221.764502889.36817.3628.29%280.00105.00420.000.00605.0019542061.5225901.50296.5032.89%3350.001700.0030.002080.004339.501700213.32346.30266.3011.35%4605.0025.000.00630.00799.32582.43906.73276.7330.52%5575.0055.0012.50642.5077319.405582.8910.80268.3029.46%6700.00490.0037.501227.50895.65490138.5651524.22296.7219.47%7390.00630.000.001020.00484630111.41225.40205.4016.76%8540.00770.000.001310.006607701431573.00263.0016.72%9170.0035.000.00205.00452.13548.71535.81330.8161.74%10110.00655.00100.00865.00151.565580.65887.1522.152.50%11630.001515.000.002145.00718.2169.001515223.322456.52311.5212.68%12220.002795.000.003015.00378.112795317.3113490.42475.4213.62%13560.00133.000.00693.0056613369.9768.9075.909.87%14335.00425.000.00760.0054296.0042596.71063.70303.7028.55%15560.001870.000.002430.00649.0501870251.90502770.96340.9612.30%16375.00718.000.001093.004500718116.801284.80191.8014.93%17570.005.000.00575.0065351565.80723.80148.8020.56%18530.0080.000.00610.00742187.48082.20904.20294.2032.54%19330.00210.000.00540.00532.510521074.250816.75276.7533.88%0.0000.000.00#DIV/0!0.0000.000.00#DIV/0!0.0000.000.00#DIV/0!合合计计0.000.00160.00160.008110.008110.0014038.0014038.00210.00210.0022518.0022518.0010785.0110785.01637.30637.3014038.0014038.002482.302482.30675.00675.0027980.3127980.315462.315462.3119.52%19.52%广广州州专专线线收收益益表表序序发发车车时时间间车车号号代代收收运运费费及及货货款款合合计计整整车车成成本本整整车车资资费费收收入入整整车车毛毛利利毛毛利利率率专线收入费用南昌资费收入占专线收入的比例率南昌收入毛利占专线费用的比例率装装卸卸成成本本费费市市内内送送货货运运费费中中转转托托运运成成本本中中转转配配送送运运费费成成本本小小计计市市内内配配送送资资费费收收入入外外出出卸卸货货收收入入中中转转资资费费收收入入专专线线加加收收10%10%收收入入整整车车装装卸卸收收入入收收入入合合计计1390.001565.00454.000.002019.002056.60521.84454.00251.06650.003411.661392.6640.82%14699.0023.21%9.47%2300.00906.00760.000.001666.001509.80285.70760.00226.980.002496.78830.7833.27%8843.0028.23%9.39%30.00531.00710.000.001241.00913.300.00705.00161.830.001780.13539.1330.29%7274.0024.47%7.41%4520.001295.00475.000.001770.002047.80455.60475.00252.280.002775.081005.0836.22%14307.0019.40%7.03%5220.001230.001215.000.002445.001684.50240.901215.00289.950.003189.45744.4523.34%16186.0019.70%4.60%660.00880.002823.000.003703.00992.00164.402823.00381.500.004196.50493.5011.76%17618.0023.82%2.80%70.001650.00495.000.002145.002169.900.00495.00266.490.002931.39786.3926.83%17601.0016.65%4.47%820.001280.00516.000.001796.001593.012.09516.00210.900.002319.91523.9122.58%12822.0018.09%4.09%960.001082.00205.000.001287.001350.70109.82205.00155.570.001711.27424.2724.79%11999.0014.26%3.54%10119.00861.00660.000.001521.001233.48313.80660.00187.350.002080.83559.8326.90%15485.0013.44%3.62%1191.001938.00798.000.002736.002274.47261.60798.00307.250.003379.72643.7219.05%23751.0014.23%2.71%1260.00954.001840.000.002794.001201.9060.401840.00304.190.003346.09552.0916.50%16791.0019.93%3.29%1345.001170.001063.000.002233.001139.50106.501063.00220.250.002422.75189.757.83%12901.0018.78%1.47%14260.001256.00839.000.002095.001678.63393.00839.00251.760.002769.39674.3924.35%16500.0016.78%4.09%15492.001439.00300.000.001739.001640.701207.36300.00194.070.002134.77395.7718.54%11608.0018.39%3.41%1624.00965.00597.000.001562.00910.6054.00597.00150.760.001658.3696.365.81%12505.0013.26%0.77%17208.001010.001809.000.002819.001321.910.001809.00313.090.003444.00625.0018.15%16770.0020.54%3.73%180.001150.00198.000.001348.001368.100.001984.00335.210.003687.312339.3163.44%13944.0026.44%16.78%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.000.00#DIV/0!#DIV/0!#DIV/0!合合计计0.000.002869.002869.0021162.0021162.0015757.0015757.000.000.0036919.0036919.0027086.9027086.904177.014177.0117538.0017538.004460.494460.49650.00650.0049735.3949735.3912816.3912816.3925.77%261604.00261604.0019.01%4.90%