Article ID: | iaor20072660 |
Country: | United States |
Volume: | 36 |
Issue: | 5 |
Start Page Number: | 400 |
End Page Number: | 406 |
Publication Date: | Sep 2006 |
Journal: | Interfaces |
Authors: | Raghavan S., Gamvros Ioannis, Nidel Richard |
Keywords: | decision, finance & banking, spreadsheets, community OR |
Catholic Relief Services, a not-for-profit agency that funds development programs and humanitarian relief efforts throughout the world, faces a challenging budget-allocation problem annually. We developed a mathematical model and a spreadsheet tool that allocates available funds based on the impact these investments will have in different countries. The model ensures a fair allocation to countries in need that is consistent with the agency's priorities and is simple enough for managers to understand. The agency is using the tool to plan its spending and considers it a success that has greatly improved the planning process.