REAL PROBLEMS · REAL NUMBERS · FREE TOOLS
Case studies
Real problems and real numbers. Each one shows what was broken, what changed, how we knew it worked, and what I learned. Every case study links to a free tool you can use on your own work.
By Brian Mongold, retired Chief Master Sergeant and Lean Six Sigma Green Belt.
Equal Opportunity case tracking: making an invisible process measurable
Only 18% of cases had the data needed to track them. We fixed the data, opened a path to file any day, and found the bottlenecks nobody could see.
Development applications: moving 400+ submissions out of encrypted email
Three people spent evenings downloading encrypted emails one at a time, and nobody could see where a package stood. Moving submissions into myPers cut the team’s time on the process in half, at zero cost.
Security authorizations: expired packages cut by more than half
I inherited a security-authorization tracking database for 49 tenant units, built by someone who had left. Learning it before replacing it cut expired packages by more than half and package completion time by 40%.
Deployment support: automated outreach for 228 families
A two-person Family Readiness office was retyping deployment information into a tracker and sending member and spouse outreach by hand. Microsoft Forms, Power Automate, and SharePoint automated both for 228 families.
Pharmacy staging: nine seconds a trip, about 220 trips a day
My first process improvement, before I knew the words for it. Moving a staging shelf saved about nine seconds per prescription. That walk happened about 220 times a day, so nine seconds added up.