Helping a Small Development Organization Manage Volunteers More Efficiently

Development organizations plan and execute programs that are directed primarily toward promoting human welfare. Because these organizations rely heavily on volunteers to carry out their social missions, efficiently managing their volunteer workforce is important. In this study, we discuss the development of a spreadsheet-based, multicriteria volunteer-scheduling model for a small development organization in a developing South American country. We demonstrate how the model helps to reduce the number of unfilled shifts, decrease total scheduling costs, and better satisfy the volunteers' scheduling preferences, thus supporting the long-term retention and effectiveness of the organization's volunteer workforce.

[1]  Andreas T. Ernst,et al.  Staff scheduling and rostering: A review of applications, methods and models , 2004, Eur. J. Oper. Res..

[2]  Larry J. LeBlanc,et al.  Implementing Large-Scale Optimization Models in Excel Using VBA , 2007, Interfaces.

[3]  C. Rees,et al.  Microfinance and the commercial banking system , 2009 .

[4]  Alexandra Medina-Borja,et al.  Integrating Excel, Access, and Visual Basic to Deploy Performance Measurement and Evaluation at the American Red Cross , 2008, Interfaces.

[5]  Didem Gürses,et al.  Microfinance and Poverty Reduction in Turkey , 2009 .

[6]  J. M. Thompson,et al.  Solving the multi-objective nurse scheduling problem with a weighted cost function , 2007, Ann. Oper. Res..

[7]  Scott E. Sampson Optimization of volunteer labor assignments , 2006 .

[8]  Hesham K. Alfares,et al.  Survey, Categorization, and Comparison of Recent Tour Scheduling Literature , 2004, Ann. Oper. Res..

[9]  Erhan Erkut,et al.  Improving Volunteer Scheduling for the Edmonton Folk Festival , 2004, Interfaces.

[10]  S. S. Al Sharif,et al.  A 0-1 goal programming model for nurse scheduling , 2005, Comput. Oper. Res..

[11]  Veda C. Storey,et al.  The use of spreadsheets in organizations: Determinants and consequences , 1996, Inf. Manag..

[12]  Stephen E. Bechtold,et al.  A Comparative Evaluation of Labor Tour Scheduling Methods , 1991 .

[13]  Marlei Pozzebon,et al.  The Role of ICT in Helping Parallel Paths Converge: Microcredit and Correspondent Banking in Brazil , 2009 .

[14]  Stefan E. Karisch,et al.  Airline Crew Rostering: Problem Types, Modeling, and Optimization , 2004, Ann. Oper. Res..

[15]  Gary M. Thompson,et al.  A Comparison of Heuristics for Assigning Individual Employees to Labor Tour Schedules , 2004, Ann. Oper. Res..

[16]  Ingrid Farasyn,et al.  Spreadsheet Models for Inventory Target Setting at Procter & Gamble , 2008, Interfaces.