X2
18930148
18930148
0
0.00%

Y1
0.53
0.53
0
0.00%

Y2
2.56
2.56
0
0.00%

Y3
1953223.86
1953223.86
0
0.00%

Y4
165
165
0
0.00%
15
15
1

X1
7602327108
7602327108
0
0.00%

X2
764172160
764172160
0
0.00%

Y1
16.1
16.1
0
0.00%

Y2
0.27
0.27
0
0.00%

Y3
10480
10480
0
0.00%

Y4
72
72
0
0.00%
16
16
0.129362795

X1
3435800497
444464753.9
-2991335743
-87.06%

X2
951577533
19862335.82
-931715197.2
-97.91%

Y1
0.42
0.556099085
0.136099085
32.40%

Y2
0.81
2.686063505
1.876063505
231.61%

Y3
2049407.55
2049407.55
0
0.00%

Y4
104
173.1251869
69.12518686
66.47%
17
17
1

X1
2323681771
2323681771
0
0.00%

X2
11098627
11098627
0
0.00%

Y1
1.22
1.22
0
0.00%

Y2
0.09
0.09
0
0.00%

Y3
96558.71
96558.71
0
0.00%

Y4
137
137
0
0.00%
18
18
0.223558209

X1
1355002014
302921823.8
-1052080190
-77.64%

X2
220545014
17847055.41
-202697958.6
-91.91%

Y1
0.41
0.41
0
0.00%

Y2
0.05
1.568447961
1.518447961
999.90%

Y3
291690
1231755.689
940065.6887
322.28%

Y4
117
117
0
0.00%
19
19
1

X1
279274010
279274010
0
0.00%

X2
37591474
37591474
0
0.00%

Y1
0.53
0.53
0
0.00%

Y2
0.16
0.16
0
0.00%

Y3
326369.5
326369.5
0
0.00%

Y4
103
103
0
0.00%
20
20
0.88858662

X1
15924487520
258818049.1
-15665669471
-98.37%

X2
13016307
11566116.24
-1450190.762
-11.14%

Y1
0.03
0.323824283
0.293824283
979.41%

Y2
0.19
1.564132387
1.374132387
723.23%

Y3
1193398.71
1193398.71
0
0.00%

Y4
50
100.8132202
50.81322023
101.63%
21
21
0.691980911

X1
3946726418
441452894.9
-3505273523
-88.81%

X2
28509083
19727741.22
-8781341.779
-30.80%

Y1
0.09
0.55233075
0.46233075
513.70%

Y2
1.08
2.667861737
1.587861737
147.02%

Y3
2035520
2035520
0
0.00%

Y4
92
171.952026
79.95202602
86.90%

جدول4-2- جدول وزني DEA براي مدلCCR ورودي محور سال 90

جدول4-3- رتبه بندي تشخيص واحدهاي کارا و ناکارا مدلCCR ورودي محور سال 90
Model Name = DEA-Solver Pro5.0/ CCR(CCR-I)

Workbook Name = C:UsersTakinpardazeDesktopCCR-I90.xls
Rank
DMU
Score

1
19
1

1
17
1

1
15
1

1
3
1

1
14
1

6
4
0.896081

7
20
0.888587

8
11
0.837376

9
10
0.779885

10
21
0.691981

11
9
0.461425

12
8
0.452352

13
5
0.451779

14
13
0.356725

15
2
0.284484

16
18
0.223558

17
7
0.220871

18
1
0.220591

19
6
0.135769

20
16
0.129363

21
12
4.17E-02

نمودار4-1- رتبه بندي تشخيص واحدهاي کارا و ناکارا مدلCCR ورودي محور سال 90

جدول4-4- رتبه بندي واحدهاي کارا و ناکارا مدلCCR ورودي محور سال 90
Model Name = DEA-Solver Pro5.0/ Super-Radial(Super-CCR-I)
Workbook Name = C:UsersTakinpardazeDesktopI90-CCR.xls
Rank
DMU
Score

1
14
4.858754

2
17
3.926167

3
15
1.281437

4
3
1.241574

5
19
1.139174

6
4
0.896081

7
20
0.888587

8
11
0.837376

9
10
0.779885

10
21
0.691981

11
9
0.461425

12
8
0.452352

13
5
0.451779

14
13
0.356725

15
2
0.284484

16
18
0.223558

17
7
0.220871

18
1
0.220591

19
6
0.135769

20
16
0.129363

21
12
4.17E-02

نمودار4-2- رتبه بندي واحدهاي کارا و ناکارا مدلCCR ورودي محور سال 90

سال90 CCR-Output
واحد4 : ناکارا، براي رسيدن به کارايي، X2 بايد به اندازه 19.39%کاهش يابد.Y1 بايد به اندازه11.60% و Y2 بايد به اندازه 38.56% و Y3بايد به اندازه 587.32% و Y4 بايد به اندازه 11.60%افزايش يابند.
واحد8: ناکارا، براي رسيدن به کارايي،X2 بايد به اندازه 45.91% کاهش يابد.Y1 بايد به اندازه121.07%و Y2 و Y3بايد به اندازه 999.90%و Y4 بايد به اندازه 356.42%افزايش يابند.
واحد12: ناکارا، براي رسيدن به کارايي،Y1 وY2 و Y3و Y4بايد به اندازه 999.90%افزايش يابد.
واحد 16: ناکارا، براي رسيدن به کارايي، X2 بايد به اندازه 83.86%کاهش يابد.Y1 بايد به اندازه 923.51% وY2 بايد به اندازه 999.90% و Y3بايد به اندازه 673.02%و Y4بايد به اندازه 999.90%افزايش يابد.
واحد20: ناکارا، براي رسيدن به کارايي، X1 بايد به اندازه 98.17%کاهش يابد.Y1 بايد به اندازه 999.90% وY2 بايد به اندازه 826.45% و Y3بايد به اندازه 12.54% و Y4بايد به اندازه 126.91% افزايش يابد.

جدول4-5- تجزيه تحليلDEA براي مدلCCR خروجي محور
سال 90
Model Name = DEA-Solver Pro5.0/ CCR(CCR-O) Returns to Scale = Constant (0 = Sum of Lambda Infinity)
Workbook Name = C:UsersTakinpardazeDesktopCCR-O90.xls

No.
DMU
1/Score

I/O
Data
Projection
Difference
%

1
1
4.53327509

X1
5241059212
5241059212
0
0.00%

X2
3147295974
1396833332
-1750462642
-55.62%

Y1
2.64
11.96784624
9.327846237
353.33%

Y2
4.6
20.85306541
16.25306541
353.33%

Y3
291650.25
11020243.05
10728592.8
999.90%

Y4
96
1183.660334
1087.660334
999.90%

2
2
3.515135817

X1
2780605273
2780605273
0
0.00%

X2
1125467744
615451096.6
-510016647.4
-45.32%

Y1
1.64
5.76482274
4.12482274
251.51%

Y2
3.48
12.23267264
8.752672644
251.51%

Y3
308254.54
7267223.744
6958969.204
999.90%

Y4
100
720.6735715
620.6735715
620.67%

3
3
1

X1
575722754
575722754
0
0.00%

X2
246990447
246990447
0
0.00%

Y1
1.75
1.75
0
0.00%

Y2
1.42
1.42
0
0.00%

Y3
152759.16
152759.16
0
0.00%

Y4
61
61
0
0.00%

4
4
1.115970787

X1
842346687
842346687
0
0.00%

X2
411043178
331345887.1
-79697290.91
-19.39%

Y1
2.19
2.443976023
0.253976023
11.60%

Y2
1.36
1.884480237
0.524480237
38.56%

Y3
45922.94
315638.5633
269715.6233
587.32%

Y4
104
116.0609618
12.06096183
11.60%

5
5
2.213470112

X1
2367385702
2367385702
0
0.00%

X2
1636796911
824886984.1
-811909926.9
-49.60%

Y1
2.85
6.308389821
3.458389821
121.35%

Y2
3.44
7.614337187
4.174337187
121.35%

Y3
735190.68
2784938.407
2049747.727
278.80%

Y4
105
391.568053
286.568053
272.92%

6
6
7.365460001

X1
3130256435
3130256435
0
0.00%

X2
1102182208
864688087.2
-237494120.8
-21.55%

Y1
1.04
7.660078401
6.620078401
636.55%

Y2
0.36
4.644850682
4.284850682
999.90%

Y3
19690.48
2297855.217
2278164.737
999.90%

Y4
103
758.6423801
655.6423801
636.55%

7
7
4.527536033

X1
2391451347
2391451347
0
0.00%

X2
600866721
600866721
0
0.00%

Y1
1.29
5.840521483
4.550521483
352.75%

Y2
0.07
2.965545713
2.895545713
999.90%

Y3
9265.53
1144079.66
1134814.13
999.90%

Y4
86
389.3680989
303.3680989
352.75%

8
8
2.21066912

X1
3360013837
3360013837
0
0.00%

X2
2665042031
1441477367
-1223564664
-45.91%

Y1
4.62
10.21329133
5.593291335
121.07%

Y2
0.62
8.287356397
7.667356397
999.90%

Y3
56764.56
891527.8887
834763.3287
999.90%

Y4
78
356.0061551
278.0061551
356.42%

9
9
2.167200655

X1
2495413459
2495413459
0
0.00%

X2
1736056885
1070555717
-665501168
-38.33%

Y1
3.5
7.585202292
4.085202292
116.72%

Y2
0.51
6.15484986
5.64484986
999.90%

Y3
18825.49
662119.5032
643294.0132
999.90%

Y4
100
264.3984799
164.3984799
164.40%

10
10
1.282239697

X1
2037610834
2037610834
0
0.00%

X2
1231800817
127364096.1
-1104436721
-89.66%

Y1
2.12
2.718348158
0.598348158
28.22%

Y2
9.34
11.97611877
2.636118771
28.22%

Y3
2770329.57
8984802.581
6214473.011
224.32%

Y4
124
766.8896953
642.8896953
518.46%

11
11
1.194206519

X1
2333821738
2333821738
0
0.00%

X2
163825108
104294324.1
-59530783.89
-36.34%

Y1
1.08
2.919997867
1.839997867
170.37%

Y2
6.06
14.10414064
8.044140639
132.74%

Y3
9011129.85
10761150.01
1750020.158
19.42%

Y4
122
909.0559396
787.0559396
645.13%

12
12
2.40E+01

X1
10383542669
10383542669
0
0.00%

X2
1031847750
1031847750
0
0.00%

Y1
0.75
17.97404618
17.22404618
999.90%

Y2
0.22
31.9449938
31.7249938
999.90%

Y3
1023952.82
24539433.69
23515480.87
999.90%

Y4
109
2612.228044
2503.228044
999.90%

13
13
2.803283017

X1
4881148878
4881148878
0
0.00%

X2
3046189460
339472975.9
-2706716484
-88.86%

Y1
2.38
6.671813581
4.291813581
180.33%

Y2
10.12
28.36922414
18.24922414
180.33%

Y3
246.37
21134704.68
21134458.31
999.90%

Y4
76
1811.745705
1735.745705
999.90%

14
14
1

X1
423604940
423604940
0
0.00%

X2
18930148
18930148
0
0.00%

Y1
0.53
0.53
0
0.00%

Y2
2.56
2.56
0
0.00%

Y3
1953223.86
1953223.86
0
0.00%

Y4
165
165
0
0.00%

15
15
1

X1
7602327108
7602327108
0
0.00%

X2
764172160
764172160
0
0.00%

Y1
16.1
16.1
0
0.00%

Y2
0.27
0.27
0
0.00%

Y3
10480
10480
0
0.00%

Y4
72
72
0
0.00%

16
16
7.730197877

X1
3435800497
3435800497
0
0.00%

X2
951577533
153539786.2
-798037746.8
-83.86%

Y1
0.42
4.298755967
3.878755967
923.51%

Y2
0.81
20.76380241
19.95380241
999.90%

Y3
2049407.55
15842325.89
13792918.34
673.02%

Y4
104
1338.291952
1234.291952
999.90%

17
17
1

X1
2323681771
2323681771
0
0.00%

X2
11098627
11098627
0
0.00%

Y1
1.22
1.22
0
0.00%

Y2
0.09
0.09
0
0.00%

Y3
96558.71
96558.71
0
0.00%

Y4
137
137
0
0.00%

18
18
4.473107936

X1
1355002014
1355002014
0
0.00%

X2
220545014
79831805.19
-140713208.8
-63.80%

Y1
0.41
1.833974254
1.423974254
347.31%

Y2
0.05
7.015837022
6.965837022
999.90%

Y3
291690
5509776.147
5218086.147
999.90%

Y4
117
523.3536285
406.3536285
347.31%

19
19
1

X1
279274010
279274010
0
0.00%

X2
37591474
37591474
0
0.00%

Y1
0.53
0.53
0
0.00%

Y2
0.16
0.16
0
0.00%

Y3
326369.5
326369.5
0
0.00%

Y4
103
103
0
0.00%

20
20
1.12538269

X1
15924487520
291269352.2
-15633218168
-98.17%

X2
13016307
13016307
0
0.00%

Y1
0.03
0.364426243
0.334426243
999.90%

Y2
0.19
1.760247512
1.570247512
826.45%

Y3
1193398.71
1343030.25
149631.54
12.54%

Y4
50
113.4534529
63.45345293
126.91%

21
21
1.44512657

X1
3946726418
637955307.8
-3308771110
-83.84%

X2
28509083
28509083
0
0.00%

Y1
0.09
0.798187842
0.708187842
786.88%

Y2
1.08
3.855397881
2.775397881
256.98%

Y3
2035520
2941584.035
906064.0353
44.51%

Y4
92
248.4924415
156.4924415
170.10%

جدول4-6-


دیدگاهتان را بنویسید