Optimization

Staff Scheduling Optimization

Designed and implemented a decision-optimization system to improve staff scheduling and operational planning across retail store operations. The system uses mixed-integer programming to allocate staff across shifts, roles, and locations while respecting labor rules, demand patterns, and budget constraints. A complementary discrete-event simulation model was also built to optimize labor allocation, increasing average net earnings by 5.5%.

Domain

Retail Operations

Methods

  • Mixed-Integer Programming
  • Discrete-Event Simulation
  • Demand Forecasting

Tools

  • Python
  • Gurobi
  • SQL

Impact / Outcome

Delivered approximately $1M in annual savings through optimized staff scheduling and 5.5% increase in average net earnings via labor allocation simulation.