Document Type

Closed Project

Publication Date

Winter 2007


Tim Anderson

Course Title

Operations Research

Course Number

ETM 540


This paper will address the implementation of Data Envelopment Analysis (DEA) model in Microsoft Excel spreadsheet using Visual Basis Analysis (VBA). The spreadsheet will be structured for easy execution of the model and interpretation of output that will be utilized by regional managers of a large retail chain. Both of the Input and Output Envelopment models are implemented in the spreadsheet for execution and interpretation. The primary focus of the interpretation will be the evaluation of less than efficient sites (location or decision making unit DMU) and the efficient sites they are compared to. The purpose of this evaluation is to understand the optimization output relative to the DEA model structure.


This project is only available to students, faculty, and staff of Portland State University.

Persistent Identifier