Even though it is used as an effective setup to find the relative efficiency of various decision making units in the service sector with multiple inputs and multiple output, it can be equally applied in a manufacturing setup, trying to compare the efficiencies of different manufacturing departments or plants of a manufacturing company.
|Good explanation of cells in the spreadsheet to be embedded with formula|
You will find some of the links here of some interest. Depending on the number of DMUs, you have to formulate as much LPPs. Hence manual solution may be difficult considering that one has multiple inputs and multiple outputs,
A spreadsheet solver (LP solver in Excel) or the solver in Google spreadsheet can be used.
|Entering cell details in LP solver as parameters|
I make it a point to see that students desiring to understand DEA should know previously how to solve an Linear programming problem using any spreadsheet, Excel or Google sheet, helpful links are given below ...
Some links are given here .