油耗核算案例

1、12.附件（1）配送與直送的成本比較計(jì)算過(guò)程：直送成本：武漢的坐標(biāo)為（x,y）(18.28,14.63)，所以武漢到各城市地圖距離為：城市XjYjx-aX2y-aY2和D岳陽(yáng)14.6810.45-3.612.96-4.1817.472430.43245.5165569長(zhǎng)沙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衡陽(yáng)13.261.64-5.02

2、25.2004-12.99168.7401193.940513.926252永州10.080-8.267.24-14.63214.0369281.276916.771312邵陽(yáng)9.682.91-8.673.96-11.72137.3584211.318414.536795益陽(yáng)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ì)算表序號(hào)城市XjYjqjCjDT費(fèi)用1岳陽(yáng)14.6810.4520001.55.516556916549.672長(zhǎng)沙14.056.1135001.49.51227146610.133湘潭13.845.1325001.410.48635336702.244株洲14.925.0530001.4

4、10.152143426395衡陽(yáng)13.261.6440001.313.92625272416.516永州10.08010001.216.77131220125.577邵陽(yáng)9.682.9150001.314.53679594489.178益陽(yáng)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ì)算過(guò)程表1.各城市的鋼材年銷(xiāo)售量及汽車(chē)運(yùn)輸費(fèi)率表序號(hào)地點(diǎn)產(chǎn)品銷(xiāo)售總量（噸）運(yùn)輸費(fèi)率（元/噸公里）1岳陽(yáng)冷板+線(xiàn)材20001.52長(zhǎng)沙冷板+線(xiàn)材35001.43湘潭冷板25001.44株洲冷板+線(xiàn)材30001.45衡陽(yáng)冷板+線(xiàn)材400

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

7、2652長(zhǎng)沙35001.4912.69621813湘潭25001.4101.41493504株洲30001.49.713.67757443.45衡陽(yáng)40001.31318.33953166永州10001.316.322.98327579.67邵陽(yáng)50001.313.819.4581264778益陽(yáng)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序號(hào)城市XjYjqjCjCjqjCjqjXjCjqjYj1岳陽(yáng)10.713.720001.5300032100411002長(zhǎng)沙10.49.835001.4490050960480203湘潭10.18.825001.4350035350308004株洲11.18.830001.4420046620369605衡陽(yáng)9.45.640001.3520048880291206永州6.93.210001.21200828038407邵陽(yáng)6.26.250001.3650040300422508益陽(yáng)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為配送中心到目的市場(chǎng)（需求地）的運(yùn)輸費(fèi)率qj為配送中心到目的市場(chǎng)（需求地）的運(yùn)量得X0=7.6，Y0=13.51利用兩點(diǎn)距離公式列表計(jì)算配送中心到各需求地的距離與運(yùn)輸總成本，如下表4城市XjX0YjY0D岳陽(yáng)10.77.613

10、.78.95.7長(zhǎng)沙10.47.69.88.92.9湘潭10.17.68.88.92.5株洲11.17.68.88.93.5衡陽(yáng)9.47.65.68.93.8永州6.97.63.28.95.7邵陽(yáng)6.27.66.58.92.8益陽(yáng)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岳陽(yáng)10.713.75.720001.524111長(zhǎng)沙10.49.82.935001.420036.1湘潭10.18.82.

11、525001.412377.5株洲11.18.83.530001.420727衡陽(yáng)9.45.63.840001.327861.6永州6.93.25.710001.29644.4邵陽(yáng)6.26.52.850001.325662益陽(yáng)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岳陽(yáng)1077.813.78.75.8長(zhǎng)沙10.47.89.88.72.8湘潭10.17.88.88.72.3株洲11.17.88.88.73.3衡陽(yáng)9.47.85.68.73.5永州6.97.83.28.75.6邵陽(yáng)6.27.86.58.72.7益陽(yáng)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岳陽(yáng)10.713.75.820001.524534長(zhǎng)沙10.49.82.835001.419345.2湘潭10.18.82.325001.411350.5株洲11.18.83.330001.419542.6衡陽(yáng)9.45.63.540001.325662永州6.93.25.610001.29475.2邵陽(yáng)6.26.52.750001.324745.5益陽(yáng)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岳陽(yáng)10.713.75.820001.5245340長(zhǎng)沙10.49.82.835001.419345.2湘潭10.18.82.225001.410857株洲11.18.83.230001.418950.4衡陽(yáng)9.45.63.440001.324928.8永州6.93.25.510001.29306邵陽(yáng)6.26.52.750001.324745.5益陽(yáng)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,沒(méi)有進(jìn)一步下降的空間，所以不需返回繼續(xù)算，連續(xù)迭代后可以最終得出最優(yōu)的坐標(biāo)值為X=7.8,Y=8.7因?yàn)橛?jì)算出來(lái)的的都比直送所需費(fèi)用低，所以在湖南婁底建立配送中心是劃得來(lái)的。（3）選點(diǎn)地圖（4）課程設(shè)計(jì)的收獲與體會(huì)經(jīng)過(guò)一個(gè)多星期的“配送中心規(guī)劃與配送業(yè)務(wù)方案設(shè)計(jì)”的課