OperationsA manufacturer that installs what it makes

Scheduling the installs

Every job has to clear the same steps before a crew can install it, and most of what the schedule needed lived in people’s heads. We built one platform for it: 50 to 100 jobs at a time, the shop’s schedule balanced against the crews and installers, and AI agents that read the email and flag problems. It replaced a Trello board, a spreadsheet, and an Access database.

Built
A five-week look-ahead, a crew grid, a map, job cards, an installer app, and a job archive
Replaced
A Trello board, a spreadsheet, and an Access database
Connected to
The ERP (jobs, tasks, purchase orders), Microsoft 365 (sign-in and email), and the quoting tool
Scale
50 to 100 jobs at once, with the shop’s schedule, the crews, and the installers
AI
Advisory agents that read the scheduling email and flag problems; a person makes every decision
The five-week look-ahead: a column for each week with its install jobs, each card showing the job, its stage, the install dates, whether the customer confirmed them, the man-days, and a note, under a banner flagging one job at risk.
1 AT RISK— install within 3 weeks and missing a gate that’s now actionable

Need to Return

Started — waiting on follow-up

0 jobs

No active returns

This Week

Oct 12 – Oct 16

2 jobs  60 days

#JB-1187 Harbor Fresh Market

On Site

Install Oct 12 – 19

36 man-days · ⌖ 137 Commerce…

#JB-1194 Ridgeview Schools, central…

On Site

Install Oct 14 – 19

24 man-days · ⌖ 174 Industrial S…

🗒 Note: Kitchen closed until 2 PM on school days

Week 2

Oct 19 – Oct 23

4 jobs  42 days

Continues

#JB-1187 Harbor Fresh Market

On Site

Install Oct 12 – 19

36 man-days · ⌖ 137 Commerce…

Continues

#JB-1194 Ridgeview Schools, central…

On Site

Install Oct 14 – 19

24 man-days · ⌖ 174 Industrial S…

🗒 Note: Kitchen closed until 2 PM on school days

#JB-1208 Pinecrest Senior Living

Scheduled

Install Oct 20 – 26✓ Confirmed

30 man-days · ⌖ 248 Station St,…

🗒 Note: Freight elevator booked 7 to 11 AM

#JB-1264 Copper Kettle

Week 3

Oct 26 – Oct 30

3 jobs  84 days

Continues

#JB-1208 Pinecrest Senior Living

Scheduled

Install Oct 20 – 26✓ Confirmed

30 man-days · ⌖ 248 Station St,…

🗒 Note: Freight elevator booked 7 to 11 AM

#JB-1215 Northfield Grocery, store 12

Drawings sent — awaiting ap…

Install Oct 26 – 29Tentative

Mark confirmed

20 man-days · ⌖ 285 Park St, T…

#JB-1222 Summit Dairy distribution

Scheduled

Install Oct 27 – Nov 5✓ Confirmed

64 man-days · ⌖ 322 Main St, S…

🗒 Note: Two crews, overnights included

Week 4

Nov 2 – Nov 6

3 jobs  30 days

Continues

#JB-1222 Summit Dairy distribution

Scheduled

Install Oct 27 – Nov 5✓ Confirmed

64 man-days · ⌖ 322 Main St, S…

🗒 Note: Two crews, overnights included

#JB-1229 Lakeside Grill

Scheduled

Install Nov 2 – 3Tentative

Mark confirmed

6 man-days · ⌖ 359 Commerce …

#JB-1236 Riverside Hospital cafeteria

Drawings sent — awaiting ap…

Install Nov 3 – 6✓ Confirmed

24 man-days · ⌖ 396 Industrial …

🗒 Note: Badge access for every installer

Week 5

Nov 9 – Nov 13

2 jobs  56 days

#JB-1243 Maple Street Bakery

Scheduled

Install Nov 9 – 10Tentative

Mark confirmed

8 man-days · ⌖ 433 Harbor St, …

#JB-1250 Westgate Foods warehouse

Scheduled

Install Nov 10 – 17✓ Confirmed

48 man-days · ⌖ 470 Station St,…

The look-ahead. One job is flagged at risk: booked within three weeks with its drawings still out.

The problem

Before a crew can install a job, five things have to happen: the deposit is in, the drawings are approved, the materials are ordered, the customer is ready, and a crew is assigned. The old schedule tracked none of them. The install date was a formula, the signed date plus five weeks, and the spreadsheet’s five-week outlook had nearly every job sitting under “unscheduled”.

The field super could plan a week or two out. Nobody owned weeks three to eight, so engineering couldn’t order materials ahead, and sales couldn’t give a customer an honest date without walking over to ask. The schedule itself lived in three places: a spreadsheet for the crews, a Trello board the installers read on their phones, and an old Access database for every past job.

What we built

  • Steps, not guesses. Each job’s deposit, drawings, and materials dates come from the ERP and the email, and its stage is worked out from them in one place, so every screen agrees.
  • The five-week look-ahead. Every job in each week it’s worked, and an at-risk strip for any job booked within three weeks with a step still open.
  • The crew grid. Every installer and truck for the next three weeks, with shop days and time off. Booking a crew on a job whose drawings aren’t approved shows a large amber warning. It never blocks: the schedule is a plan.
  • The map. The week’s jobs, each installer’s home, and their travel range drawn around it. A job outside every ring stands out as an overnight, and the nearest installers are a click away.
  • The job card. Everything the crew read on the Trello card, under the same headings, plus the drawings and photos they’re allowed to see. Sales documents never reach the field.
  • An app for installers. Today’s job, the week ahead, directions, documents, and photos, on the phone.
  • Every past job, searchable. Completed jobs back to the old Access database, searchable by number, customer, name, or address, by everyone.
  • Won jobs arrive on their own. A quote won in the quoting tool becomes a job on the board within about 15 minutes, with its contact, scope, and files.
The crew schedule: nine installers and two trucks across three weeks, each day filled with a job, shop work, or time off, and a banner warning that a crew is booked on a job whose drawings are not approved.

Crew is booked on a job whose drawings aren’t approved

The install shouldn’t start until they’re approved. Sales is chasing the customer.

JB-1215 Northfield Grocery, store 12 · first crew day Mon, Oct 26 · Tyler, Ray, Truck 1 · Drawings sent Sep 11, waiting on the customer · Salesperson Priya Shah

Installer

This Week

Oct 12 – Oct 18

Week 2

Oct 19 – Oct 25

Week 3

Oct 26 – Nov 1

M
10/12
T
10/13
W
10/14
T
10/15
F
10/16
S
10/17
S
10/18
M
10/19
T
10/20
W
10/21
T
10/22
F
10/23
S
10/24
S
10/25
M
10/26
T
10/27
W
10/28
T
10/29
F
10/30
S
10/31
S
11/1
Dan
Harbor Fresh Market5d
Harbor…
OFF
SHOP2d
OFF
OFF
Summit Dairy distribution4d
Eli
SHOP2d
OFF
SHOP2d
SHOP
Pinecrest Senior Living4d
Pinecr…
SHOP2d
OFF
SHOP
Jorge
SHOP
OFF
SHOP2d
OFF
Copper Kettle Brewing3d
OFF
SHOP
SHOP
Summit Dairy distribution4d
Luis
Harbor Fresh Market5d
Harbor…
SHOP2d
OFF
SHOP
SHOP
Summit Dairy distribution4d
Marco
Harbor Fresh Market5d
Harbor…
Pinecrest Senior Living4d
Pinecr…
OFF
SHOP2d
OFF
Nate
OFF
SHOP2d
OFF
SHOP
Copper Kettle Brewing3d
SHOP2d
SHOP
Summit Dairy distribution4d
Ray
SHOP
OFF
Ridgeview Schools, central ki…3d
Ridgev…
SHOP2d
OFF
SHOP
Northfield Grocery, store 124d
SHOP
Sean
OFF
SHOP2d
OFF
SHOP
SHOP
Pinecrest Senior Living4d
Pinecr…
OFF
SHOP2d
OFF
Tyler
SHOP2d
Ridgeview Schools, central ki…3d
Ridgev…
OFF
SHOP2d
OFF
Northfield Grocery, store 124d
SHOP
Truck 1
Harbor…
Coppe…
Nor…
Truck 2
Ridgev…
Pinecr…
Summi…
The crew grid, with the drawings warning above it.

Then the AI agents

Once the schedule lived in one place, we added AI agents. They read the scheduling email and file each message on its job, and they check the schedule against concrete rules and guidelines: a crew booked twice, a pairing rule broken, a job too far for its crew, a step still open close to the install. When something looks wrong, they flag it and lay out what they found.

They’re advisory. The company chose to have a person make every scheduling decision, so the agents inform the decision and never make it.

The map view: this week’s install jobs as blue pins, other weeks’ in grey, installers’ homes in green, and each installer’s travel range drawn as a ring around home. The clip steps through the next five weeks.

Map View

18 projects · 9 installers

Projects Installers Travel range
This Week 2Oct 12 – Oct 18This Week 2Oct 12 – Oct 18Week 2 4Oct 19 – Oct 25Week 2 4Oct 19 – Oct 25Week 3 3Oct 26 – Nov 1Week 3 3Oct 26 – Nov 1Week 4 3Nov 2 – Nov 8Week 4 3Nov 2 – Nov 8Week 5 2Nov 9 – Nov 15Week 5 2Nov 9 – Nov 15
NEW YORKPENNSYLVANIAOHIOMARYLANDNEW JERSEYKitchenerHamiltonOswegoRochesterSyracuseUticaBuffaloSarniaLondonLansingDetroitAnn ArborToledoClevelandAkronYoungstownErieIthacaElmiraBinghamtonAlbanyScrantonPittsburghMansfieldCantonColumbusDaytonWheelingMorgantownHarrisburgLancasterAllentownPhiladelphiaTrentonNewarkNew YorkHarbor Fresh MarketRidgeview Schools, ce…Harbor Fresh MarketRidgeview Schools, ce…Pinecrest Senior LivingCopper Kettle BrewingNorthfield Grocery, st…Summit Dairy distribu…Pinecrest Senior LivingRiverside Hospital caf…Summit Dairy distribu…Lakeside GrillMaple Street BakeryWestgate Foods ware…MapSatellite⛶✥Map data · sample

Select a Project

Click a pin on the map to see nearest installers, travel distances, and overnight eligibility.

Travel notes

⚠“Harbor Fresh Market” is 85 mi from nearest installer — consider overnight.

Travel notes

⚠“Harbor Fresh Market” is 85 mi from nearest installer — consider overnight.

Travel notes

⚠“Maple Street Bakery” is 86 mi from nearest installer — consider overnight.

⚠“Westgate Foods warehouse” is 127 mi from nearest installer — consider overnight.

Legend

  • Project (selected week)
  • Project (other weeks)
  • Installer home
  • Installer travel range (6)
The map, week by week: each installer’s travel range around home, so a job outside every ring stands out as an overnight.

What changed

What used to live in people’s heads is in one platform: every job’s steps, every crew’s weeks, and every installer’s range. It runs 50 to 100 jobs at a time, balancing what the shop has to build, and when, against the people who install it. The spreadsheet, the Trello board, and the old database are retired.

Questions

Does the AI change the schedule on its own?
No. The agents are advisory: they file the email, check the schedule against your rules, and flag what looks wrong. A person makes every scheduling decision.
Will our installers have to learn something new?
Very little. The job card shows what their old board showed, under the same headings, and the installer app puts today’s job on their phone.
How does it work with our ERP?
It reads jobs, tasks, and purchase orders from the ERP every 15 minutes during the business day and writes install dates back to the job. The ERP stays the record for contracts and billing.

Every screen shows sample data. The company isn’t named here, and we’re glad to put you in touch: ask us for a reference.

What should your first tool be?

Tell us about the workflow that eats your team’s week. We’ll listen, then sketch the first tool with you.