396 \u00d6dev2 - Variables I1 0 I2 0.19305019 Obj Function(Depot 1 0.78413962 Constraints Depot 1 Depot 2 Depot 3 Depot 4 Depot 5 Depot 6 Depot 7 Depot 8

396 u00d6dev2 - Variables I1 0 I2 0.19305019 Obj...

This preview shows page 1 - 8 out of 38 pages.

Variables: I1 I2 I3 O1 O2 0 0.19305019 0 0.03648316 0.18797462 0.78413962 0.92471042 0.83113328 Constraints I1 I2 I3 O1 O2 Values Depot 1 5.19 5.23 5.03 5.83 3.04 -0.22551289 Depot 2 4.29 4.79 4.53 4.17 4.11 0 Depot 3 5.36 5.33 5.43 5.83 3.45 -0.16774831 Depot 4 5.04 5.18 5.12 5.83 3.29 -0.16886672 Depot 5 5.32 5.35 5.35 4.17 3.59 -0.20585491 Depot 6 5.05 5.18 5.00 8.33 3.04 -0.12465249 Depot 7 4.76 5.48 5.19 5.00 3.63 -0.19315143 Depot 8 5.11 5.34 5.15 3.33 2.83 -0.37743096 Depot 9 5.15 5.22 5.18 8.97 3.62 0 Depot 10 5.39 5.30 5.35 7.50 3.14 -0.15930207 Depot 11 5.56 5.39 5.15 5.83 3.10 -0.24512244 Depot 12 5.37 5.32 5.44 5.83 3.17 -0.2184507 Depot13 5.44 5.18 5.24 10.00 2.81 -0.10695978 Inputs 5.19 5.23 5.03 1.00965251 4.29 4.79 4.53 0.92471042 1 Obj. Function (Depot 1)
Image of page 1
RHS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 = 1.00 = 1.00
Image of page 2
Variables: I1 I2 I3 O1 O2 0.183823529 0 0 0.1 0 Outputs Constraints I1 I2 I3 O1 O2 Depots 1 5.19 5.23 5.03 5.83 3.04 2 4.29 4.79 4.53 4.17 4.11 3 5.36 5.33 5.43 5.83 3.45 4 5.04 5.18 5.12 5.83 3.29 5 5.32 5.35 5.35 4.17 3.59 6 5.05 5.18 5.00 8.33 3.04 7 4.76 5.48 5.19 5.00 3.63 8 5.11 5.34 5.15 3.33 2.83 9 5.15 5.22 5.18 8.97 3.62 10 5.39 5.30 5.35 7.50 3.14 11 5.56 5.39 5.15 5.83 3.10 12 5.37 5.32 5.44 5.83 3.17 13 5.44 5.18 5.24 10.00 2.81 Inputs 1 5.19 5.23 5.03 2 4.29 4.79 4.53 3 5.36 5.33 5.43 4 5.04 5.18 5.12 5 5.32 5.35 5.35 6 5.05 5.18 5.00 7 4.76 5.48 5.19 8 5.11 5.34 5.15 9 5.15 5.22 5.18 10 5.39 5.30 5.35 11 5.56 5.39 5.15 12 5.37 5.32 5.44 13 5.44 5.18 5.24 Non- negativity I1 1 Non- negativity I2 1 Non- negativity I3 1 Non- negativity O1 1 Non- negativity O2 1
Image of page 3
5.83 4.17 5.83 5.83 4.17 3.04 4.11 3.45 3.29 3.59 E(Depot1)= E(Depot2)= E(Depot3)= E(Depot4)= E(Depot5)= 0.7887665121 1 0.8369725591 0.8311332778 0.800686276 Values (Depot 1) Values (Depot 2) Values (Depot 3) Values (Depot 4) Values (Depot 5) -0.2112334879 -0.2438740601 -0.2191663692 -0.2255128856 -0.2183470556 0 0 0 0 0 -0.2194956373 -0.1814063174 -0.1630274409 -0.1677483128 -0.1624179925 -0.1856744775 -0.1826157873 -0.1641143754 -0.1688667222 -0.1635008638 -0.2534013102 -0.2226155372 -0.2000616179 -0.205854908 -0.199313724 -0.0936078695 -0.134801647 -0.1211444445 -0.1246524883 -0.1206915681 -0.1775683143 -0.2088777466 -0.1877156484 -0.1931514297 -0.1870139077 -0.3832511401 -0.408161251 -0.3668090792 -0.3774309638 -0.3654378303 0 0 0 0 0 -0.1828812987 -0.1722723832 -0.154818896 -0.1593020687 -0.1542401338 -0.2246619496 -0.2650802166 -0.2382240595 -0.2451224396 -0.2373335023 -0.2701495619 -0.2362368772 -0.2123029347 -0.2184507031 -0.2115092788 -0.1067072918 -0.1156684059 -0.1039496556 -0.1069597808 -0.1035610588 1 1 1 1 1
Image of page 4
Objective Functions 8.33 5.00 3.33 8.97 7.50 3.04 3.63 2.83 3.62 3.14 E(Depot6)= E(Depot7)= E(Depot8)= E(Depot9)= E(Depot10)= 0.9340072219 0.8676382295 0.6338778292 1 0.8443047706 Values (Depot 6) Values (Depot 7) Values (Depot 8) Values (Depot 9) Values (Depot 10) -0.2726876836 -0.2743710622 -0.2187559453 -0.2832946735 -0.2204069335 -0.2125733698 0 0 -0.2101824934 0 -0.3169081979 -0.2428047861 -0.1627221461 -0.261477656 -0.1639502378 -0.268870924 -0.2018337244 -0.1638070452 -0.2487319187 -0.1650433247 -0.4219522298 -0.3017179988 -0.1996869706 -0.3694293452 -0.2011940421 -0.0659927781 -0.1089797427 -0.1209175823 -0.0958374704 -0.1218301678 -0.3198308396 -0.1323617705 -0.187364121 -0.3312803712 -0.1887781898 -0.5157086672 -0.4280046698 -0.3661221708 -0.5032328664 -0.368885357 0 0 0 0 0 -0.1938967829 -0.2091436332 -0.154528973 -0.1678880066 -0.1556952294 -0.2914516613 -0.3422562187 -0.2377779471 -0.3079498039 -0.2395724976 -0.3433429686 -0.2908533272 -0.2119053636 -0.2875442632 -0.2135046494 0 -0.1378209274 -0.1037549933 0 -0.1045380499 1 1 1 1 1
Image of page 5
5.83 5.83 10.00 3.10 3.17 2.81 E(Depot11)= E(Depot12)= E(Depot13)= 0.7805728919 0.7872979997 1 Values (Depot 11) Values (Depot 12) Values (Depot 13) RHS -0.2063115425 -0.219578336 -0.3710441176 0.00 0 0 -0.3716029412 0.00 -0.2143811758 -0.1633338835 -0.4022941176 0.00 -0.1813480819 -0.1644228611 -0.3434705882 0.00 -0.2474968136 -0.2004376735 -0.5609411765 0.00 -0.0914267153 -0.1213721596 -0.0953088235 0.00 -0.1734308002 -0.1880684974 -0.375 0.00 -0.3743210165 -0.36749857 -0.6063382353 0.00 0 0 -0.0496911765 0.00 -0.1786199869 -0.155109909 -0.2408088235 0.00 -0.2194271081 -0.2386718491 -0.4390588235 0.00 -0.2638548148 -0.2127020003 -0.4041323529 0.00 -0.1042209083 -0.1041450497 0 0.00 = 1.00 = 1.00 = 1.00 = 1.00 = 1.00 = 1.00 = 1.00 = 1.00 = 1.00 = 1.00 1 = 1.00 1 = 1.00 1 = 1.00 0.00 0.00 0.00 0.00 0.00
Image of page 6
Depot No: 1 Reduce Facility Cost By #DIV/0! dollars Efficiency 0.7887665121 Reduce Employee Cost By #DIV/0! dollars I1= 0 Reduce Floor Space By 1.062504 I2= 0 I3= 0.1988071571 Referance Set O1= 0.0446645614 Outputs and Inputs Depot 2 Depot 13 O2= 0.1738066181 Facility 4.29 5.44 Employee 4.79 5.18 Reference Set Relative Weights Floor space 4.53 5.24 Depot 2 0.283134218 Profit 4.17 10.00 Depot 13 0 Customer 4.11 2.81 Depot No: 3 Reduce Facility Cost By #DIV/0! dollars Efficiency 0.8369725591 Reduce Employee Cost By 0.868936 dollars I1= 0 Reduce Floor Space By #DIV/0! I2= 0.1876172608 I3= 0 Referance Set O1= 0.0354564246 Outputs and Inputs Depot 2 Depot 13 O2= 0.1826845227 Facility 4.29 5.44 Employee 4.79 5.18 Reference Set Relative Weights Floor space 4.53 5.24 Depot 2 0.4520584439 Profit 4.17 10.00 Depot 13 0 Customer 4.11 2.81 Depot No: 4 Reduce Facility Cost By #DIV/0! dollars Efficiency 0.8311332778 Reduce Employee Cost By 0.87473 dollars I1= 0 Reduce Floor Space By #DIV/0! I2= 0.1930501931 I3= 0 Referance Set O1= 0.0364831551 Outputs and Inputs Depot 2 Depot 13 O2= 0.1879746151 Facility 4.29 5.44 Employee 4.79 5.18 Reference Set Relative Weights Floor space 4.53 5.24 Depot 2 0.3861367948 Profit 4.17 10.00 Depot 13 0 Customer 4.11 2.81 Depot No: 5 Reduce Facility Cost By #DIV/0! dollars Efficiency 0.800686276 Reduce Employee Cost By 1.066328 dollars I1= 0 Reduce Floor Space By #DIV/0!
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 38 pages?

  • Fall '14
  • Using Excel Solver, Data Envelopment Analysis,, The Following Inputs Are Ident, A Major Super Market Retailer, The Average Quality Score Obta, On The Other Hand, The Output, The Table Below Summarizes The, Solve The DEA Model For Each S, Identify Efficient And Ineffic, Assume Linear Model, Simplex LP, Identify The Appropriate Refer, Discuss In Which Ways Each Sto

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture