油耗核算案例

1、12.附件（1）配送與直送的成本比較計(jì)算過程：直送成本：武漢的坐標(biāo)為（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.64-5.02

2、25.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婁底11.24

3、4.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運(yùn)輸總成本計(jì)算表序號城市XjYjqjCjDT費(fèi)用1岳陽14.6810.4520001.55.516556916549.672長沙14.056.1135001.49.51227146610.133湘潭13.845.1325001.410.48635336702.244株洲14.925.0530001.4

4、10.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.66938638274.281

5、3張家界6.49.3915001.412.98429827267.0314合計(jì)34500557718.9直送成本=T(直)*1000/3=185906300元配送成本=T(配)*1000/3+(200+1)*34500=59158566.67+6934500=66093066.67元直送成本185906300元 < 配送成本66093066.67元（2）選址計(jì)算過程表1.各城市的鋼材年銷售量及汽車運(yùn)輸費(fèi)率表序號地點(diǎn)產(chǎn)品銷售總量（噸）運(yùn)輸費(fèi)率（元/噸公里）1岳陽冷板+線材20001.52長沙冷板+線材35001.43湘潭冷板25001.44株洲冷板+線材30001.45衡陽冷板+線材400

6、01.36永州線材10001.27邵陽冷板+線材50001.38益陽冷板+線材10001.49常德冷板+線材40001.410懷化線材35001.211婁底冷板15001.312冷水江線材20001.413張家界線材15001.4若采用工廠直送方法，：從工廠到各目的市場地點(diǎn)運(yùn)輸費(fèi)率均為1.4/噸。配送中心建設(shè)費(fèi)為每噸200元，營運(yùn)費(fèi)用預(yù)計(jì)平均1元/噸。長途公路運(yùn)輸實(shí)際公路運(yùn)輸路線與兩點(diǎn)直線距離的修正系數(shù)為1.41。先計(jì)算采用從武漢送到各消費(fèi)地的運(yùn)輸費(fèi)用直送費(fèi)用計(jì)算表2序號地點(diǎn)銷售總量（噸）運(yùn)輸費(fèi)率元每噸公里圖上距離（厘米）修正后實(shí)際距離（厘米）總運(yùn)輸費(fèi)用1岳陽20001.55.57.75523

7、2652長沙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直送費(fèi)

8、用計(jì)算得總費(fèi)用為742167.6元初始坐標(biāo)值計(jì)算表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為配送中心到目的市場（需求地）的運(yùn)輸費(fèi)率qj為配送中心到目的市場（需求地）的運(yùn)量得X0=7.6，Y0=13.51利用兩點(diǎn)距離公式列表計(jì)算配送中心到各需求地的距離與運(yùn)輸總成本，如下表4城市XjX0YjY0D岳陽10.77.613

10、.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初始運(yùn)輸總成本計(jì)算表5城市XjYjDqjCjW0岳陽10.713.75.720001.524111長沙10.49.82.935001.420036.1湘潭10.18.82.

11、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在初始坐標(biāo)值的基礎(chǔ)上，利用數(shù)值

12、分析法進(jìn)行重復(fù)修正迭代，ïïîïïíì=åååå=njjjjjjjjnjjjiqCyqCyqCXqCx1111/得X1=7.8,Y1=8.7第二次迭代，先計(jì)算兩點(diǎn)距離公式表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.5

13、7.812.68.74.1懷化1.77.87.58.76.2婁底7.67.88.28.70.5冷水江5.87.88.18.72.1張家界37.812.88.76.3運(yùn)輸總成本計(jì)算表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.45

14、132.4常德6.512.64.140001.432373.6懷化1.77.56.235001.236716.4婁底7.68.20.515001.31374.8冷水江5.88.12.120001.48290.8張家界312.86.315001.418654.3注：W= qj* Cj* DW1=237197.3 <W0在初始坐標(biāo)值的基礎(chǔ)上，利用數(shù)值分析法進(jìn)行重復(fù)修正迭代，ïïîïïíì=åååå=njjjjjjjjnjjjiqCyqCyqCXqCx1212/得X2=7.9, Y2=

15、8.6，城市XjYjD2qjCj2岳陽10.713.75.820001.5245340長沙10.49.82.835001.419345.2湘潭10.18.82.225001.410857株洲11.18.83.230001.418950.4衡陽9.45.63.440001.324928.8永州6.93.25.510001.29306邵陽6.26.52.750001.324745.5益陽8.411.22.610001.45132.4常德6.512.64.240001.433163.2懷化1.77.56.335001.237308.6婁底7.68.20.515001.31374.75冷水江5.88.12.220001.48685.6張家界312.86.515001.419246.5總的W2=237578因?yàn)閃2>W1,沒有進(jìn)一步下降的空間，所以不需返回繼續(xù)算，連續(xù)迭代后可以最終得出最優(yōu)的坐標(biāo)值為X=7.8,Y=8.7因?yàn)橛?jì)算出來的的都比直送所需費(fèi)用低，所以在湖南婁底建立配送中心是劃得來的。（3）選點(diǎn)地圖（4）課程設(shè)計(jì)的收獲與體會經(jīng)過一個多星期的“配送中心規(guī)劃與配送業(yè)務(wù)方案設(shè)計(jì)”的課