apply solver foundation for missions planning

The target of this project is to define and optimise the missions planning using Microsoft solver foundation. ## Deliverables The target of this project is to define and optimise the missions planning. ? Here are the source data and constraints: -? ? ? ? ? ? ? ? There are X missions to realise. -? ? ? ? ? ? ? ? There are Y persons to realise missions -? ? ? ? ? ? ? ? Each mission can be realised with one of two options o? ? ? ? ? ? In any day between two dates o? ? ? ? ? ? In one day in an hours range -? ? ? ? ? ? ? ? Each mission requires a number of skills and a minimum level of each skill. -? ? ? ? ? ? ? ? Each mission has a duration (generally, between 30 mins and 7 hours). -? ? ? ? ? ? ? ? Each mission has an address with gps coordinates -? ? ? ? ? ? ? ? Each mission requires one or more persons that we will call "a team" -? ? ? ? ? ? ? ? Each person has a skills with a level of each skill -? ? ? ? ? ? ? ? The team skills is a maximum level of each skill of team persons -? ? ? ? ? ? ? ? To realise a mission, a team skills should be equal or greater to mission required skills. However, the gap between team skills and required skill should be minimum in order to not create over skilled teams for simple missions -? ? ? ? ? ? ? ? Each person is working from 9 am to 6 pm. He should take a break of one hour between 12 and 14 hours -? ? ? ? ? ? ? ? A person starts his day from his home. -? ? ? ? ? ? ? ? The distance between missions is calculated as strait line between two gps coordinates. It should be minimised. -? ? ? ? ? ? ? ? The time to go from one mission to another is calculated as 6 minutes per kilometre -? ? ? ? ? ? ? ? A person can have a list of absence periods. During absence, the person can realise no mission. -? ? ? ? ? ? ? ? There should be at least one hour per day per person reserved to urgent non planned missions. ? The target is to propose a planning that will : -? ? ? ? ? ? ? ? realise all missions in a minimum period of time -? ? ? ? ? ? ? ? minimise the distance -? ? ? ? ? ? ? ? minimise the gap between team skills and mission required skills Here is an article speaking how French Techdays sessions were planned with Ms solver foundation : <[login to view URL]>