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