Heery International's Spreadsheet Optimization Model for Assigning Managers to Construction Projects

Larry J. LeBlanc, Dale Randels and T. K. Swann
Additional contact information
Larry J. LeBlanc: Owen Graduate School of Management, Vanderbilt University, 401 21st Avenue South, Nashville, Tennessee 37203
Dale Randels: Heery International, Inc., 214 2nd Avenue North, Suite 1, Nashville, Tennessee 37201
T. K. Swann: Heery International, Inc.

Interfaces, 2000, vol. 30, issue 6, 95-106

Abstract: When assigning managers to construction projects, Heery International tries to minimize the total cost of the assignments while maintaining a balanced workload for different managers. We developed and implemented an Excel spreadsheet optimization model for problems with up to 114 projects. As time passes, new projects arise, old projects terminate, and occasionally new managers join the team, and existing ones resign or transfer out. Because the model is in a spreadsheet environment, Heery can easily add or remove projects and managers from the model. As a result of our model, Heery has managed its projects without replacing a manager who resigned and has reduced travel costs, because the model assigns managers to projects that are closer to their homes than previously.

Keywords: PROGRAMMING—INTEGER; APPLICATIONS; PROJECT MANAGEMENT (search for similar items in EconPapers)
Date: 2000
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (5)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.30.6.95.11622 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:30:y:2000:i:6:p:95-106

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().