KUKU

KU ScholarWorks

  • myKU
  • Email
  • Enroll & Pay
  • KU Directory
    • Login
    View Item 
    •   KU ScholarWorks
    • Engineering Management
    • Engineering Management Field Projects
    • View Item
    •   KU ScholarWorks
    • Engineering Management
    • Engineering Management Field Projects
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    Staffing Optimization Tools for a 24 x 7 Telecommunications Control Center Environment

    Thumbnail
    View/Open
    Woster, Jonathan EMGT Field Project.pdf (19.49Mb)
    Issue Date
    2011-07-29
    Author
    Woster, Jonathan
    Type
    Project
    Metadata
    Show full item record
    Abstract
    This research explored optimization techniques to assist in personnel scheduling in a telecommunications environment. A survey of personnel was conducted to help determine basic employee priorities and two models were implemented in Microsoft Excel Solver to assist in providing data to support employee scheduling. The first model is linear and, given the number of people required during each hour of the week, determines the optimal number of personnel that should be working each of the available shift types, with an objective of minimizing cost. This tool includes the option to include or exclude particular shifts depending on employee and management preference. This model is found to be a useful tool in learning about the cost implications of various shifts and is suitable for assisting in shift scheduling. The second model designed is nonlinear and minimizes variance in the hourly utilization rate of personnel. Given a fixed number of people, the model seeks to determine the optimal number of personnel that should be working each of the available shift types, with an objective of balancing capacity to demand across each hour of the week. Microsoft Excel Solver is found to be insufficient in handling the number of constraints in this nonlinear model. Implementation of this methodology within a more powerful software package is suggested for future research.
    URI
    http://hdl.handle.net/1808/7948
    Collections
    • Engineering Management Field Projects [238]

    Items in KU ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.


    We want to hear from you! Please share your stories about how Open Access to this item benefits YOU.


    Contact KU ScholarWorks
    785-864-8983
    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    785-864-8983

    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    Image Credits
     

     

    Browse

    All of KU ScholarWorksCommunities & CollectionsThis Collection

    My Account

    Login

    Statistics

    View Usage Statistics

    Contact KU ScholarWorks
    785-864-8983
    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    785-864-8983

    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    Image Credits
     

     

    The University of Kansas
      Contact KU ScholarWorks
    Lawrence, KS | Maps
     
    • Academics
    • Admission
    • Alumni
    • Athletics
    • Campuses
    • Giving
    • Jobs

    The University of Kansas prohibits discrimination on the basis of race, color, ethnicity, religion, sex, national origin, age, ancestry, disability, status as a veteran, sexual orientation, marital status, parental status, gender identity, gender expression and genetic information in the University’s programs and activities. The following person has been designated to handle inquiries regarding the non-discrimination policies: Director of the Office of Institutional Opportunity and Access, IOA@ku.edu, 1246 W. Campus Road, Room 153A, Lawrence, KS, 66045, (785)864-6414, 711 TTY.

     Contact KU
    Lawrence, KS | Maps