Paper Info
Title
Integrating Excel, Access, and Visual Basic to Deploy Performance Measurement and Evaluation at the American Red Cross
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.
Year
DOI
Venue
2008
10.1287/inte.1080.0366
Interfaces
Keywords
Field
DocType
united states,arc manager,visual basic,american red cross,largest nonprofit social service,integrating excel,deploy performance measurement,microsoft excel,social service,data envelopment analysis,premium solver,microsoft access,visual basic for applications,decision support,linear programming,implementation
Social work,Visual Basic,Computer science,Visual Basic for Applications,Decision support system,Performance measurement,Data envelopment analysis,Solver,Operations management,Social Welfare
Journal
Volume
Issue
ISSN
38
4
0092-2102
Citations 
PageRank 
References 
4
0.47
3
Authors
2
Name
Order
Citations
PageRank
Kalyan S. Pasupathy1219.19
Alexandra Medina-Borja291.85