层次分析法Excel演算实验_精品文档表格文件下载.xls

1、28*1/31*1A,D对于A：20*1/410*1/3A,E对于A：25*13*1/2A,F对于A：17*511*3A,G对于A：29*1/21*1质量A与其他5个因素比较A,B对于A：30*3A,C对于A：15*18*1/2A,D对于A：23*67*5A,E对于A：30*9A,F对于A：24*63*5服务水平A与其他4个因素比较20122010200820062004200220000%5%10%15%20%25%30%35%40%45%人员成本食材成本物流成本A,B对于A：10*110*1/3A,C对于A：24*43*3A,D对于A：17*95*5A,E对于A：19*34*1可追溯性A与

2、其他3个因素比较A,B对于A：28*61*1A,C对于A：30*9A,D对于A：10*610*4总资产A收益率与其他2个因素比较A,B对于A：15*515*3A,C对于A：10*1/310*1创新性A与剩下1个因素比较A,B对于A：5*1/36*1/7外观售后服务按行相乘开5次方权重Wi934053.322699030.5024842472 1/20.10.6309573440.095418253121.1486983550.173715051 1/30.006172840.361490590.0546674033 121.1486983550.173715056.6125436751按行相乘

3、开3次方权重WiAwiAwi/Wi0.070.405480.10945230.333.0036951.51.1447140.30899560.933.003695102.1544350.58155211.753.0036953.70462913.003695按行相乘开3次方权重WiAwiAwi/Wi15 2.4662120740.6483290141.94738243.0036945980.666666667 0.8735804650.2296507940.68980083.0036945980.1 0.4641588830.1220201920.36651143.0036945983.803

4、95142213.003694598按行相乘开3次方权重WiAwiAwi/Wi0.066666667 0.4054801330.109452290.328763.0036945981.5 1.1447142430.3089956440.928133.003694598102.154434690.5815520671.746803.0036945983.70462906613.003694598按行相乘开3次方权重WiAwiAwi/Wi15 2.4662120740.6483290141.947383.0036945980.1 0.4641588830.1220201920.366513.003

5、6945980.666666667 0.8735804650.2296507940.689803.0036945983.80395142213.003694598按行相乘开3次方权重WiAwiAwi/Wi9 2.0800838230.60001.80003.00000.333333333 0.6933612740.20000.60003.00000.333333333 0.6933612740.20000.60003.00003.46680637213.0000选择的目标质量外观售后服务0.0546674030.17371505Ai*bi0.6483290140.60000.054998051

6、0.061862420.019013510.1220201920.20000.1552654430.0219128770.0536771940.2296507940.20000.2922207520.0116429530.1010243460.0018472990C.I.=AiCIR.I.=AiRI0.51490.51490.0015263950.51490.0031849980可追溯性总资产收益率创新关联按行相乘 1/41 4 1/20.0277777781 6 9 6 5832 1/24 7 2 281 6 9 5 2160 1/61 4 1/20.013888889 1/9 1/41 1

7、/50.000022046 1/52 5 1 0.333333333按行相乘开3次方权重WiAwiAwi/Wi0.066666667 0.4054801330.1047294340.3182223.038511091110.2582849940.7848023.03851109115 2.4662120740.6369855721.9354883.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.066666667 0.4054801330.1047294340.31822153.038511091110.2582849940.784

8、80183.03851109115 2.4662120740.6369855721.93548773.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.5 0.7937005260.250.7500003.00000000.5 0.7937005260.250.7500003.00000004 1.5874010520.51.5000003.00000003.17480210413.0000000层次总排序一致性检验冷链物流模式选择按行相乘开3次方权重WiAwiAwi/Wi15 2.4662120740.6369855721.9354

9、8773.0385110910.066666667 0.4054801330.1047294340.31822153.038511091110.2582849940.78480183.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.066666667 0.4054801330.1047294340.3182223.038511091110.2582849940.7848023.03851109115 2.4662120740.6369855721.9354883.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.111111111 0.4807498570.1428571430.428571