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

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

Author

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

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.

Suggested Citation

  • Larry J. LeBlanc & Dale Randels & T. K. Swann, 2000. "Heery International's Spreadsheet Optimization Model for Assigning Managers to Construction Projects," Interfaces, INFORMS, vol. 30(6), pages 95-106, December.
    • Handle: RePEc:inm:orinte:v:30:y:2000:i:6:p:95-106
    DOI: 10.1287/inte.30.6.95.11622
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.30.6.95.11622
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.30.6.95.11622?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Rania M. Awad & John W. Chinneck, 1998. "Proctor Assignment at Carleton University," Interfaces, INFORMS, vol. 28(2), pages 58-71, April.
    2. Ahmad I. Z. Jarrah & James T. Diamond, 1997. "The Problem of Generating Crew Bidlines," Interfaces, INFORMS, vol. 27(4), pages 49-64, August.
    3. Daniel Fylstra & Leon Lasdon & John Watson & Allan Waren, 1998. "Design and Use of the Microsoft Excel Solver," Interfaces, INFORMS, vol. 28(5), pages 29-55, October.
    4. Conway, D. G. & Ragsdale, C. T., 1997. "Modeling optimization problems in the unstructured world of spreadsheets," Omega, Elsevier, vol. 25(3), pages 313-322, June.
    5. John R. Grandzol & Thomas Traaen, 1995. "Using Mathematical Programming to Help Supervisors Balance Workloads," Interfaces, INFORMS, vol. 25(4), pages 92-103, August.
    6. Gary M. Thompson, 1997. "Assigning Telephone Operators to Shifts at New Brunswick Telephone Company," Interfaces, INFORMS, vol. 27(4), pages 1-11, August.
    7. Jeph Abara, 1989. "Applying Integer Linear Programming to the Fleet Assignment Problem," Interfaces, INFORMS, vol. 19(4), pages 20-28, August.
    8. Stephen G. Powell, 1997. "The Teachers' Forum: From Intelligent Consumer to Active Modeler, Two MBA Success Stories," Interfaces, INFORMS, vol. 27(3), pages 88-98, June.
    9. Thomas A. Grandine, 1998. "Assigning Season Tickets Fairly," Interfaces, INFORMS, vol. 28(4), pages 15-20, August.
    10. Warren B. Powell & Yosef Sheffi & Kenneth S. Nickerson & Kevin Butterbaugh & Susan Atherton, 1988. "Maximizing Profits for North American Van Lines' Truckload Division: A New Framework for Pricing and Operations," Interfaces, INFORMS, vol. 18(1), pages 21-41, February.
    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. S Eom & E Kim, 2006. "A survey of decision support system applications (1995–2001)," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 57(11), pages 1264-1278, November.
    2. Lone Seboni & Joseph Ssegawa, 2022. "Does a Project Manager Assignment Process Affect Project Management Performance Indicators? An Empirical Study," Sustainability, MDPI, vol. 14(13), pages 1-17, June.
    3. Amir Hossein JAHANIKIA & Vahidreza YOUSEFI & Ehsan MEHRABANFAR & Negar KAVOOSI KHOSROWSHAHII, 2015. "Decision-Making for Crisis Management of Power Distribution Networks," Informatica Economica, Academy of Economic Studies - Bucharest, Romania, vol. 19(4), pages 5-12.
    4. Larry J. LeBlanc & Michael R. Galbreth, 2007. "Implementing Large-Scale Optimization Models in Excel Using VBA," Interfaces, INFORMS, vol. 37(4), pages 370-382, August.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Cunha, Claudio Barbieri & Mutarelli, Fernando, 2007. "A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine," European Journal of Operational Research, Elsevier, vol. 176(2), pages 925-940, January.
    2. Thomas A. Grossman, 2002. "Student Consulting Projects Benefit Faculty and Industry," Interfaces, INFORMS, vol. 32(2), pages 42-48, April.
    3. Larry J. LeBlanc & Michael R. Galbreth, 2007. "Implementing Large-Scale Optimization Models in Excel Using VBA," Interfaces, INFORMS, vol. 37(4), pages 370-382, August.
    4. João P. Pita & Cynthia Barnhart & António P. Antunes, 2013. "Integrated Flight Scheduling and Fleet Assignment Under Airport Congestion," Transportation Science, INFORMS, vol. 47(4), pages 477-492, November.
    5. Belanger, Nicolas & Desaulniers, Guy & Soumis, Francois & Desrosiers, Jacques, 2006. "Periodic airline fleet assignment with time windows, spacing constraints, and time dependent revenues," European Journal of Operational Research, Elsevier, vol. 175(3), pages 1754-1766, December.
    6. Glomb, Lukas & Liers, Frauke & Rösel, Florian, 2023. "Optimizing integrated aircraft assignment and turnaround handling," European Journal of Operational Research, Elsevier, vol. 310(3), pages 1051-1071.
    7. L. Gharis & J. Roise & J. McCarter, 2015. "A compromise programming model for developing the cost of including carbon pools and flux into forest management," Annals of Operations Research, Springer, vol. 232(1), pages 115-133, September.
    8. Retkowski, Waldemar & Ziefle, Gesa & Thöming, Jorg, 2015. "Evaluation of different heat extraction strategies for shallow vertical ground-source heat pump systems," Applied Energy, Elsevier, vol. 149(C), pages 259-271.
    9. Christophe Oggier & Emmanuel Fragnière & Jeremy Stuby, 2005. "Nestlé Improves Its Financial Reporting with Management Science," Interfaces, INFORMS, vol. 35(4), pages 271-280, August.
    10. Suzanne de Treville & Ann van Ackere, 2006. "Equipping Students to Reduce Lead Times: The Role of Queuing-Theory-Based Modeling," Interfaces, INFORMS, vol. 36(2), pages 165-173, April.
    11. Peter J. Regan, 2006. "Professional Decision Modeling: Practitioner as Professor," Interfaces, INFORMS, vol. 36(2), pages 142-149, April.
    12. Sriram, Chellappan & Haghani, Ali, 2003. "An optimization model for aircraft maintenance scheduling and re-assignment," Transportation Research Part A: Policy and Practice, Elsevier, vol. 37(1), pages 29-48, January.
    13. Mohammed Saddoune & Guy Desaulniers & Issmail Elhallaoui & François Soumis, 2012. "Integrated Airline Crew Pairing and Crew Assignment by Dynamic Constraint Aggregation," Transportation Science, INFORMS, vol. 46(1), pages 39-55, February.
    14. Allan W. Gray & Joshua D. Detre & Brian C. Briggeman, 2005. "Valuing Limited Information in Decision Making Under Uncertainty," Working Papers 05-02, Purdue University, College of Agriculture, Department of Agricultural Economics.
    15. Oliver Faust & Jochen Gönsch & Robert Klein, 2017. "Demand-Oriented Integrated Scheduling for Point-to-Point Airlines," Transportation Science, INFORMS, vol. 51(1), pages 196-213, February.
    16. Calvin Sonntag & Thomas A. Grossman, 1999. "End-User Modeling Improves R&D Management at AgrEvo Canada, Inc," Interfaces, INFORMS, vol. 29(5), pages 132-142, October.
    17. Briggeman, Brian C. & Detre, Joshua D. & Gray, Allan W., 2004. "Compound Options: A Real Options Application To An Agricultural Business," 2004 Annual meeting, August 1-4, Denver, CO 19996, American Agricultural Economics Association (New Name 2008: Agricultural and Applied Economics Association).
    18. Mehran Hojati, 2010. "Near-optimal solution to an employee assignment problem with seniority," Annals of Operations Research, Springer, vol. 181(1), pages 539-557, December.
    19. Listes, O.L. & Dekker, R., 2002. "A scenario aggregation based approach for determining a robust airline fleet composition," Econometric Institute Research Papers EI 2002-17, Erasmus University Rotterdam, Erasmus School of Economics (ESE), Econometric Institute.
    20. Hamza Khan & József K. Tar & Imre Rudas & Levente Kovács & György Eigner, 2018. "Receding Horizon Control of Type 1 Diabetes Mellitus by Using Nonlinear Programming," Complexity, Hindawi, vol. 2018, pages 1-11, April.

    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:30:y:2000:i:6:p:95-106. See general information about how to correct material in RePEc.

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

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

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

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.