Assistance with developing team assignments model

  1. eabueno34
    eabueno34
    Hello -
    I am need in of assistance with developing a team assignment simulator based on daily production goals, historical employee output, and workload priority. Excel Solver and Simulator functions don't seem have this capability. Does any have experience building a model like this?

    Below is a high level overview of the issue I am trying solve:

    Problem statement: Management manually assigns work functions at the start of each shift using their best judgement. Employee performance data is sometimes used but primarily to meet Function A daily goals. This often leads to over-production in Function A and low production for Functions B&C.

    Example: Daily Production Goals
    Function A = 100 Per Hour
    Function B = 80 Per Hour
    Function C = 70 Per Hours

    Goal: Develop an automated team assignment model/simulator which optimizes production across three functions.
    FUNTION A
    Emp 1
    Emp 2
    Emp 3

    FUNTION B
    Emp 1
    Emp 2
    Emp 3
Results 1 to 1 of 1

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1