油耗核算案例.docx

1、油耗核算案例12.附件（1）配送与直送的成本比较计算过程：直送成本：武汉的坐标为（x,y）(18.28,14.63)，所以武汉到各城市地图距离为：城市XjYjx-aX2y-aY2和D岳阳14.6810.45-3.612.96-4.1817.472430.43245.5165569长沙14.056.11-4.2317.8929-8.5272.590490.48339.512271湘潭13.845.13-4.4419.7136-9.590.25109.963610.486353株洲14.925.05-3.3611.2896-9.5891.7764103.06610.152143衡阳13.261.6

2、4-5.0225.2004-12.99168.7401193.940513.926252永州10.080-8.267.24-14.63214.0369281.276916.771312邵阳9.682.91-8.673.96-11.72137.3584211.318414.536795益阳12.337.57-5.9535.4025-7.0649.843685.24619.2328815常德10.279.18-8.0164.1601-5.4529.702593.86269.6882713怀化4.824.18-13.46181.1716-10.45109.2025290.374117.040367娄

3、底11.244.6-7.0449.5616-10.03100.6009150.162512.254081冷水江9.084.52-9.284.64-10.11102.2121186.852113.669386张家界6.49.39-11.88141.1344-5.2427.4576168.59212.984298运输总成本计算表序号城市XjYjqjCjDT费用1岳阳14.6810.4520001.55.516556916549.672长沙14.056.1135001.49.51227146610.133湘潭13.845.1325001.410.48635336702.244株洲14.925.053

4、0001.410.152143426395衡阳13.261.6440001.313.92625272416.516永州10.08010001.216.77131220125.577邵阳9.682.9150001.314.53679594489.178益阳12.337.5710001.49.232881512926.039常德10.279.1840001.49.688271354254.3210怀化4.824.1835001.217.04036771569.5411娄底11.244.615001.312.25408123895.4612冷水江9.084.5220001.413.669386382

5、74.2813张家界6.49.3915001.412.98429827267.0314合计34500557718.9直送成本=T(直)*1000/3=185906300元配送成本=T(配)*1000/3+(200+1)*34500=59158566.67+6934500=66093066.67元直送成本185906300元 配送成本66093066.67元（2）选址计算过程表1.各城市的钢材年销售量及汽车运输费率表序号地点产品销售总量（吨）运输费率（元/吨公里）1岳阳冷板+线材20001.52长沙冷板+线材35001.43湘潭冷板25001.44株洲冷板+线材30001.45衡阳冷板+线材40

6、001.36永州线材10001.27邵阳冷板+线材50001.38益阳冷板+线材10001.49常德冷板+线材40001.410怀化线材35001.211娄底冷板15001.312冷水江线材20001.413张家界线材15001.4若采用工厂直送方法，：从工厂到各目的市场地点运输费率均为1.4/吨。配送中心建设费为每吨200元，营运费用预计平均1元/吨。长途公路运输实际公路运输路线与两点直线距离的修正系数为1.41。先计算采用从武汉送到各消费地的运输费用直送费用计算表2序号地点销售总量（吨）运输费率元每吨公里图上距离（厘米）修正后实际距离（厘米）总运输费用1岳阳20001.55.57.7552

7、32652长沙35001.4912.69621813湘潭25001.4101.41493504株洲30001.49.713.67757443.45衡阳40001.31318.33953166永州10001.316.322.98327579.67邵阳50001.313.819.4581264778益阳10001.48.712.26717173.89常德40001.4912.697106410怀化35001.21622.569475211娄底15001.311.616.35631894.212冷水江20001.412.717.90750139.613张家界15001.41216.9235532直送

8、费用计算得总费用为742167.6元初始坐标值计算表3序号城市XjYjqjCjCjqjCjqjXjCjqjYj1岳阳10.713.720001.5300032100411002长沙10.49.835001.4490050960480203湘潭10.18.825001.4350035350308004株洲11.18.830001.4420046620369605衡阳9.45.640001.3520048880291206永州6.93.210001.21200828038407邵阳6.26.250001.3650040300422508益阳8.411.210001.4140011760156809

9、常德6.512.640001.45600364007056010怀化1.77.535001.2420071404410011娄底7.68.215001.31950148202238612冷水江5.88.120001.42800162403136013张家界312.815001.42100630037044总和97.8116.8345004650535515041538由 Cj为配送中心到目的市场（需求地）的运输费率qj为配送中心到目的市场（需求地）的运量得X0=7.6，Y0=13.51利用两点距离公式列表计算配送中心到各需求地的距离与运输总成本，如下表4城市XjX0YjY0D岳阳10.77.6

10、13.78.95.7长沙10.47.69.88.92.9湘潭10.17.68.88.92.5株洲11.17.68.88.93.5衡阳9.47.65.68.93.8永州6.97.63.28.95.7邵阳6.27.66.58.92.8益阳8.47.611.28.92.4常德6.57.612.68.93.9怀化1.77.67.58.96.1娄底7.67.68.28.90.7冷水江5.87.68.18.92张家界37.612.88.96初始运输总成本计算表5城市XjYjDqjCjW0岳阳10.713.75.720001.524111长沙10.49.82.935001.420036.1湘潭10.18.8

11、2.525001.412377.5株洲11.18.83.530001.420727衡阳9.45.63.840001.327861.6永州6.93.25.710001.29644.4邵阳6.26.52.850001.325662益阳8.411.22.410001.44737.6常德6.512.63.940001.430794.4怀化1.77.56.135001.236124.2娄底7.68.20.715001.31924.65冷水江5.88.1221.47896张家界312.861.51.417766注：W= qj* Cj* D得总的W=239622.5742167.6在初始坐标值的基础上，利用

12、数值分析法进行重复修正迭代，=njjjjjjjjnjjjiqCyqCyqCXqCx1111/得X1=7.8,Y1=8.7第二次迭代，先计算两点距离公式表6城市XjX1YjY1D1岳阳1077.813.78.75.8长沙10.47.89.88.72.8湘潭10.17.88.88.72.3株洲11.17.88.88.73.3衡阳9.47.85.68.73.5永州6.97.83.28.75.6邵阳6.27.86.58.72.7益阳8.47.811.28.72.6常德6.57.812.68.74.1怀化1.77.87.58.76.2娄底7.67.88.28.70.5冷水江5.87.88.18.72.1

13、张家界37.812.88.76.3运输总成本计算表7城市XjYjD1qjCjW1岳阳10.713.75.820001.524534长沙10.49.82.835001.419345.2湘潭10.18.82.325001.411350.5株洲11.18.83.330001.419542.6衡阳9.45.63.540001.325662永州6.93.25.610001.29475.2邵阳6.26.52.750001.324745.5益阳8.411.22.610001.45132.4常德6.512.64.140001.432373.6怀化1.77.56.235001.236716.4娄底7.68.20

14、.515001.31374.8冷水江5.88.12.120001.48290.8张家界312.86.315001.418654.3注：W= qj* Cj* DW1=237197.3 W1,没有进一步下降的空间，所以不需返回继续算，连续迭代后可以最终得出最优的坐标值为X=7.8,Y=8.7因为计算出来的的都比直送所需费用低，所以在湖南娄底建立配送中心是划得来的。（3）选点地图（4）课程设计的收获与体会经过一个多星期的“配送中心规划与配送业务方案设计”的课程设计，觉得自己学到了很多东西。通过这个课程设计，把平时老师在课堂上讲的配送中心选址，重心法，数值分析法等运用到了实践中了，进行了更彻底的消化吸收，虽然计算过程有点繁琐，特别是对于我这种电脑操作不是很熟练的人，做完这个课程设计加强了我对电脑的操作能力，Excel有了一定的掌握。这不仅巩固了我们所学的理论知识，更增强了我们解决实际问题的能力，对我们将来从事相关工作大有裨益。这次课程设计还让我们认识到，只有将所学的理论知识与实践相结合，并不断的加以优化，才能真正的掌握分析、解决实际问题的能力。