90 likes | 105 Views
Optimal Group Assignment and Scheduling Model. Mark Turner. Overview. Schedule students to test a new system being developed for the military Flyers for signups sent to: Undergraduate students Graduate students > sessions = better results. Needs / Constraints.
E N D
Optimal Group Assignment and Scheduling Model Mark Turner
Overview • Schedule students to test a new system being developed for the military • Flyers for signups sent to: • Undergraduate students • Graduate students • > sessions = better results
Needs / Constraints • Requires 6 students for 2 hours • Two weeks of sessions • Students may not be reused • One session at a time
General Model Hybrid Networking Problem
Mathematical Formulation Subject to: Maximize Flow Where: p = source node q = sink node xj = student nodes (j = 1 … Students) yi = session nodes (I = 1 … 60) i = sessions j = students
Software Used • Microsoft Excel • Front-End • Data Manipulation • Formatting • Interpretation • AMPL • Model • Design • Dynamic Ability
Results • Under this structure • 120 students used (possible 190) • 20 sessions (possible 60) • Maximum Efficiency given: • Amount of students available at specific scheduling times