Integrating Excel, Access, and Visual Basic to deploy performance measurement and evaluation at the American Red Cross

Kalyan S Pasupathy, Alexandra Medina-Borja

Research output: Contribution to journalArticle

9 Citations (Scopus)

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.

Original languageEnglish (US)
Pages (from-to)324-337
Number of pages14
JournalInterfaces
Volume38
Issue number4
DOIs
StatePublished - Jul 2008
Externally publishedYes

Fingerprint

Data envelopment analysis
Linear programming
Resource allocation
Managers
Social services
Excel
Performance evaluation
Microsoft
Performance measurement
Premium
Decision maker
Jurisdiction
Service delivery
Resources
Lessons learned
Resource utilization
Service organization

Keywords

  • Data envelopment analysis
  • Decision support
  • Implementation
  • Linear programming
  • Visual Basic for Applications

ASJC Scopus subject areas

  • Management of Technology and Innovation
  • Strategy and Management
  • Management Science and Operations Research

Cite this

Integrating Excel, Access, and Visual Basic to deploy performance measurement and evaluation at the American Red Cross. / Pasupathy, Kalyan S; Medina-Borja, Alexandra.

In: Interfaces, Vol. 38, No. 4, 07.2008, p. 324-337.

Research output: Contribution to journalArticle

@article{3dc9f9afcec84a17a231a6bda5a5ae07,
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.",
keywords = "Data envelopment analysis, Decision support, Implementation, Linear programming, Visual Basic for Applications",
author = "Pasupathy, {Kalyan S} and Alexandra Medina-Borja",
year = "2008",
month = "7",
doi = "10.1287/inte.1080.0366",
language = "English (US)",
volume = "38",
pages = "324--337",
journal = "Interfaces",
issn = "0092-2102",
publisher = "INFORMS Inst.for Operations Res.and the Management Sciences",
number = "4",

}

TY - JOUR

T1 - Integrating Excel, Access, and Visual Basic to deploy performance measurement and evaluation at the American Red Cross

AU - Pasupathy, Kalyan S

AU - Medina-Borja, Alexandra

PY - 2008/7

Y1 - 2008/7

N2 - 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.

AB - 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.

KW - Data envelopment analysis

KW - Decision support

KW - Implementation

KW - Linear programming

KW - Visual Basic for Applications

UR - http://www.scopus.com/inward/record.url?scp=61349194550&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=61349194550&partnerID=8YFLogxK

U2 - 10.1287/inte.1080.0366

DO - 10.1287/inte.1080.0366

M3 - Article

VL - 38

SP - 324

EP - 337

JO - Interfaces

JF - Interfaces

SN - 0092-2102

IS - 4

ER -