Skip to content

Route and Crew Assignment Optimiser for On-Site Workers

Building materials group, UK and Ireland

In short

How can planners assign crews to jobs by distance, people and stock?

Planners at a multi-site materials business often assign people and vehicles to jobs by phone and spreadsheet. A crew sent without the material, or on a long route when a closer team was free, costs fuel, hours and customer patience. We built an app that suggests assignments by distance, availability and stock.

At a glance

  • Assignments ranked by distance, people and material
  • Planner confirms or overrides each suggestion
  • Jobs flagged when material is not available

The client

The client is a building materials group with quarries, plants and customer sites in the UK and Ireland. Its on-site workers, drivers and crews move between those locations every day.

What it was costing them

  • Wasted travel: workers assigned without checking distance drive further than needed.
  • Idle time: a crew arrives and the material is not ready.
  • Planner dependence: the best assignments live in one planner's head.
  • Slow replanning: a sick day or late job forces a manual reshuffle.

What we built

We built a planning app that scores each possible assignment on distance, people and material, and lets the planner confirm it.

  • Shorter routes: Azure Maps distances rank which worker or crew is closest to each job.
  • Right people: skills, working hours and absences in Dataverse decide who can take a job.
  • Material first: stock is checked before assignment, and jobs without material are flagged.
  • Planner stays in charge: the app suggests, the planner confirms or overrides, and overrides are logged with a reason.
  • Workers know where to go: confirmed jobs appear in a mobile app with route and job details.
  • Fast replanning: an absence or late job re-ranks the affected assignments.

Results

  • Result: daily planning time falls, as the app prepares a first draft of assignments.
  • Result: fewer wasted trips, as material is checked before a job is assigned.
  • Result: shared, visible rules reduce reliance on one experienced planner.

The risk most teams miss

Planners drop tools they do not trust. If suggestions ignore real constraints, such as a job that needs two people, planners go back to the spreadsheet by month three. We kept the rules small and visible, showed why each suggestion ranks first, and tuned the rules from logged overrides. The pilot started in one region.

What we would add today

Improvements we would add on top of what is live.

  • Move to Dynamics 365 Field Service with Resource Scheduling Optimization when jobs and constraints outgrow simple rules.
  • Analyse historic routes and travel time in Fabric to tune the ranking rules.
  • Add a Copilot Studio agent so workers can ask for their next job or report a delay in plain language.

Technology

Dataverse, Power Apps (model-driven for planners, canvas for workers), Azure Maps, Power Automate, Power BI.

Tell us how jobs are assigned to your crews today, and we will tell you which rules can be automated first.

Products and capabilities

  • Power Apps
  • Dataverse
  • Azure Maps
  • Power Automate
  • crew assignment
  • field workforce planning

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.