• - Session # 1 (6h): Introduction to Operations Research: discover how this discipline can help you solve real optimization problems by modeling them using mathematics and by finding a solution with a solver. We present the definition of an optimization problem, the notions of constraints, decision variables, data ... We will take examples from industry such as the planning of TV ads, the optimization of construction sites motorways, formwork stock management on construction sites, inventory routing problem for gas delivery, ... We introduce the various market solvers (IBM CPLEX ©, LocalSolver ©, Gurobi Optimization © , etc ...). Then we set up a methodology making it possible to take the right reflexes in the modeling of real problems as well as in the management of an Operations Research Problem.
  
  
• - Session # 2 (4h): First examples of problem modeling with four first examples: a home food delivery company that must manage its hiring for the coming year, a cow breeder who must optimize his feed purchases, a factory which sells computer keyboards and an electric scooter company which must decide on the volumes to be allocated to each partner city.
  
  
• - Session # 3 (4h): Following session 2 which allowed us to model the first 4 problems, we use Excel © Solver to solve these first examples. We carry out the first problem together and the 3 other problems are carried out independently with the help of the instructor.
  
  
• - Session # 4 (4h): We continue with two other examples for which we carry out the modeling then the Excel model © Solver: a problem of setting up fast food restaurants which must choose between several cities and a problem of setting up vaccination centers within a region.
  
  
• - Session # 5 and # 6 (6h): We are carrying out a project consisting in modeling a bigger problem of factories that build headphones that they have to deliver to different distributors spread over the territory. You will be asked to deliver the mathematical model, the solver in Excel © Solver as well as a presentation in Consulting mode that explains the results and makes recommendations. The idea is to immerse yourself in the shoes of an optimization consultant who carries out his study and provides his conclusions.

Antoine Jeanjean (PhD)