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

Kalyan S. Pasupathy () and Alexandra Medina-Borja ()
Additional contact information
Kalyan S. Pasupathy: Department of Health Management and Informatics, University of Missouri, Columbia, Missouri 65211
Alexandra Medina-Borja: Department of Industrial Engineering, University of Puerto Rico, Mayaguez, Puerto Rico 00681

Interfaces, 2008, vol. 38, issue 4, 324-337

Abstract: 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.

Keywords: decision support; data envelopment analysis; implementation; linear programming; Visual Basic for Applications (search for similar items in EconPapers)
Date: 2008
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (5)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.1080.0366 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:38:y:2008:i:4:p:324-337

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().