IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v38y2008i4p324-337.html
   My bibliography  Save this article

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

Author

Listed:
  • 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)

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.

Suggested Citation

  • Kalyan S. Pasupathy & Alexandra Medina-Borja, 2008. "Integrating Excel, Access, and Visual Basic to Deploy Performance Measurement and Evaluation at the American Red Cross," Interfaces, INFORMS, vol. 38(4), pages 324-337, August.
  • Handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:324-337
    DOI: 10.1287/inte.1080.0366
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.1080.0366
    Download Restriction: no

    References listed on IDEAS

    as
    1. Kris Siddharthan & Melissa Ahern & Robert Rosenman, 2000. "Data Envelopment Analysis to determine efficiencies of health maintenance organizations," Health Care Management Science, Springer, vol. 3(1), pages 23-29, January.
    2. Paradi, Joseph C. & Schaffnit, Claire, 2004. "Commercial branch performance evaluation and results communication in a Canadian bank--a DEA application," European Journal of Operational Research, Elsevier, vol. 156(3), pages 719-735, August.
    3. A. Charnes & W. W. Cooper & E. Rhodes, 1981. "Evaluating Program and Managerial Efficiency: An Application of Data Envelopment Analysis to Program Follow Through," Management Science, INFORMS, vol. 27(6), pages 668-697, June.
    4. A Medina-Borja & K S Pasupathy & K Triantis, 2007. "Large-scale data envelopment analysis (DEA) implementation: a strategic performance management approach," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 58(8), pages 1084-1098, August.
    5. R. D. Banker & A. Charnes & W. W. Cooper, 1984. "Some Models for Estimating Technical and Scale Inefficiencies in Data Envelopment Analysis," Management Science, INFORMS, vol. 30(9), pages 1078-1092, September.
    6. Boussofiane, A. & Dyson, R. G. & Thanassoulis, E., 1991. "Applied data envelopment analysis," European Journal of Operational Research, Elsevier, vol. 52(1), pages 1-15, May.
    7. Chalos, Peter & Cherian, Joseph, 1995. "An application of data envelopment analysis to public sector performance measurement and accountability," Journal of Accounting and Public Policy, Elsevier, vol. 14(2), pages 143-160.
    8. Charnes, A. & Cooper, W. W. & Rhodes, E., 1978. "Measuring the efficiency of decision making units," European Journal of Operational Research, Elsevier, vol. 2(6), pages 429-444, November.
    9. Yasar Ozcan, 1998. "Physician benchmarking: measuring variation in practice behavior in treatment of otitis media," Health Care Management Science, Springer, vol. 1(1), pages 5-17, September.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Alexandra Medina-Borja & Konstantinos Triantis, 2014. "Modeling social services performance: a four-stage DEA approach to evaluate fundraising efficiency, capacity building, service quality, and effectiveness in the nonprofit sector," Annals of Operations Research, Springer, vol. 221(1), pages 285-307, October.
    2. Mauro Falasca & Christopher Zobel & Cliff Ragsdale, 2011. "Helping a Small Development Organization Manage Volunteers More Efficiently," Interfaces, INFORMS, vol. 41(3), pages 254-262, June.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:324-337. See general information about how to correct material in RePEc.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Matthew Walls). General contact details of provider: http://edirc.repec.org/data/inforea.html .

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service hosted by the Research Division of the Federal Reserve Bank of St. Louis . RePEc uses bibliographic data supplied by the respective publishers.