Write a client case study from your project notes

Kitchens manufacturer cut admin from 22 to 8 hours a week and boosted installations 18% Client: Brindle & Rowe Kitchens, 46 staff across one workshop and three showrooms. Problem: Custom orders arrived as emailed PDFs, phone notes, handwritten showroom sheets and the occasional photo of a marked up floor plan. A production coordinator re keyed everything into two spreadsheets, then again into the workshop schedule. Solution: A custom intake tool that extracts common fields, flags conflicting measurements and creates draft job cards for review. Result: Admin time down from about 22 to 8 hours a week; clarification requests down from 11% to 3%; 18% more installations completed without adding a coordinator. The problem Custom orders reached Brindle & Rowe as emailed PDFs, phone notes, handwritten showroom sheets, and the occasional photo of a marked up floor plan. The production coordinator copied dimensions, appliance choices, delivery dates and deposit status into two spreadsheets, then re entered most of it into the workshop schedule. A missing unit number or a "left hand hinge" note could trigger a re cut. Roughly 11% of jobs needed clarification, and Monday mornings were spent reconciling duplicated order numbers. What we did We built an intake tool that extracts the common fields, flags conflicting measurements, groups attachments by customer and creates a draft job card for review. It keeps unusual notes—"client wants bins near kettle, not sink"—instead of forcing them into a dropdown. We added a simple approval queue and a weekly exception report. The build took 9 weeks with 1 developer and a part time designer. The first import exposed 38 old orders with inconsistent dates. The results After 10 weeks: Admin time fell from about 22 hours to 8 hours a week Clarification requests dropped from 11% to 3% Schedule changes caused by missing details fell by 41% They completed 18% more installations without adding a coordinator "It finally separates a genuinely odd kitchen from a badly copied note." — Production lead, Brindle & Rowe Kitchens