This Article Full Text (PDF) References Alert me when this article is cited Alert me if a correction is posted Services Email this article to a friend Similar articles in this journal Alert me to new issues of the journal Download to citation manager Citing Articles Citing Articles via Google Scholar Google Scholar Articles by Pasupathy, K. S. Articles by Medina-Borja, A. Search for Related Content

Integrating Excel, Access, and Visual Basic to Deploy Performance Measurement and Evaluation at the American Red Cross

Department of Health Management and Informatics, University of Missouri, Columbia, Missouri 65211
Department of Industrial Engineering, University of Puerto Rico, Mayaguez, Puerto Rico 00681
pasupathyk{at}missouri.edu
amedina{at}uprm.edu

The American Red Cross (ARC) is one of the world's largest nonprofit social service organizations. ARC has a network of approximately 1,000 chapters in the United States and its territories; each is responsible for a specific geographic jurisdiction in which ARC provides an array of social services. ARC is under pressure to demonstrate to the public how it is responsible and accountable for the resources it uses to deliver these services and the outcomes it achieves. Its decision makers are challenged to make accurate decisions to improve resource utilization and service-delivery processes. We designed and developed a system that uses data envelopment analysis to make resource-allocation recommendations that help ARC managers evaluate the performance of chapters at various levels. We used Microsoft Excel for the model formulation and reporting. This paper describes its use, in conjunction with Premium Solver, Visual Basic for Applications, and Microsoft Access, to formulate 4,000 linear-programming models. The system performs the analysis and uses Excel to display the results visually. We also discuss the benefits to ARC, lessons learned, and potential future improvements.

Key Words: decision support; data envelopment analysis; implementation; linear programming; Visual Basic for Applications