油耗核算案例

1、12.附件(1)配送與直送的成本比較計(jì)算過程:直送成本：武漢的坐標(biāo)為(x,y) (18.28,14.63),所以武漢到各城市地圖距離為：城市XjYjx-aX2y-aY2和D岳14.10.-3.612.96-4.117.4730.435.5165陽684582424569長(zhǎng)14.6.1-4.217.89-8.572.5990.489.5122沙0513292043371湘13.5.1-4.419.71-9.5109.910.486潭84343690.25636353株14.5.0-3.311.28-9.591.77103.010.152洲92569686466143衡13.1.6-5.025.2

2、0-12.168.7193.913.926陽26420499401405252永10.0-8.267.24-14.214.0281.216.771州0863369769312邵9.62.9-8.673.96-11.137.3211.314.536陽8172584184795、人12.7.5-5.935.40-7.049.8485.249.2328陽33752563661815常10.9.1-8.064.16-5.429.7093.869.6882德27810152526713懷4.84.1-13.181.1-10.109.2290.317.040化284671645025741367婁11.4

3、.6-7.049.56-10.100.6150.112.254底2441603009625081冷9.04.5-9.284.64-10.102.2186.813.669水8211121521386江張6.49.3-11.141.1-5.227.45168.512.984家98834447692298界運(yùn)輸總成本計(jì)算表序號(hào)城市XjYjqCjDT費(fèi)用1岳陽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、105衡陽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.2

5、813張家界6.49.3915001.412.98429827267.0314 合34500557718.9計(jì)直送成本=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)率表序號(hào)地點(diǎn)產(chǎn)品銷售總量（噸）運(yùn)輸費(fèi)率（元/ 噸公里）1岳陽冷板+線 材20001.52長(zhǎng)沙冷板+線 材35001.43湘潭冷板25001.44株洲冷板+線 材30001.45衡

6、陽冷板+線 材40001.36永州線材10001.27邵陽冷板+線50001.3材8益陽冷板+線 材10001.49常德冷板+線 材40001.410懷化線材35001.211婁底冷板15001.312冷水江線材20001.413張家界線材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)輸路線與兩點(diǎn)直線距離的修 正系數(shù)為1.41。先計(jì)算采用從武漢送到各消費(fèi)地的運(yùn)輸費(fèi)用直送費(fèi)用計(jì)算表2運(yùn)輸修正總運(yùn)輸序號(hào)地點(diǎn)銷售總費(fèi)率圖上后費(fèi)用量元每距離實(shí)際（噸）噸公（厘距離里米）（厘米）1岳陽20

7、001.55.57.755232652長(zhǎng)沙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.4

8、1216.9235532直送費(fèi)用計(jì)算得總費(fèi)用為742167.6元初始坐標(biāo)值計(jì)算表3序號(hào)城市XjYjqCjCjqjCjqjXjCjqjYj1岳 陽10.713.720001.5300032100411002長(zhǎng)沙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.210

9、001.4140011760156809常 德6.512.640001.45600364007056010懷 化1.77.535001.2420071404410011婁底7.68.215001.31950148202238612冷 水5.88.120001.428001624031360江13張家界312.815001.42100630037044總和97.8116.8345004650535515041538由nXoCiqjX j / Cj qjj iny。5qjyj/ 射j iCj為配送中心到目的市場(chǎng)（需求地）的運(yùn)輸費(fèi)率 qj為配送中心到目的市場(chǎng)（需求地）的運(yùn)量得 X0=7.6, Y0=

10、13.51利用兩點(diǎn)距離公式列表計(jì)算配送中心到各需求地的距 離與運(yùn)輸總成本，如下表4城市XjX0YjY0D岳陽10.77.613.78.95.7長(zhǎng)沙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城市XjYjDqCjW0

11、岳陽10.713.75.720001.524111長(zhǎng)沙10.49.82.935001.420036.1湘潭10.18.82.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.8

12、61.51.417766注：W= qj* Cj* D得總的 W=239622.5v742167.6在初始坐標(biāo)值的基礎(chǔ)上，利用數(shù)值分析法進(jìn)行重復(fù)修正迭代，nC.q.X. / C.q.ii j jj .j iny1Cjqjyj/ Cjqjj 1得 X1=7.8，丫1=8.7第二次迭代，先計(jì)算兩點(diǎn)距離公式表6城市XjX1YjY1D1岳陽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衡陽9.47.85.68.73.5永州6.97.83.28.75.6邵陽6.27.86.58.72.7益陽8.47.811.28

13、.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張家界37.812.88.76.3運(yùn)輸總成本計(jì)算表7城市XjYjD1qjCjW1岳陽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衡陽9.45.63.540001.325662永州6.93.25.610001.29475.2邵陽6.26.52.750001.324745.5益陽8.411.22

14、.610001.45132.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ù)修 正迭代，nx2C.q.X. / C.q.2i j jJ jj 1ny2Cjqjyj/ CjqjJ i得 X2=7.9, 丫2=8.6，城市XjYjD2qjCjW 2岳陽10.713.75.820001.524

15、5340長(zhǎng)沙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,丫=8.7因?yàn)橛?jì)算出來的的W都比直送所需費(fèi)用低，所以