Inventory and production tracking for a microbe manufacturer
- Location
- Wisconsin, USA
- Year
- 2023
- Engagement
- Profitability Improvement: SIOP
Company manufactured microbials, probiotics, and other beneficial organisms. Quality team was looking to track material inflows and production batches. Tracking would tie into quality and performance KPIs, forward looking forecast and material purchasing needs.
Our team gathered lists of vendors, customers, products and formulations. We developed tracking sheets for each batch produced. We linked production to raw material inventory and consumption. We created displays for KPIs and other predictive analytics.
Measurable impact
3 wk
Google Sheet was developed over 3 weeks collaboratively with client
Medical Devices
Measurable impact
+53%
Purchase accuracy increased by 53% within 4 weeks of implementation
Medical Devices
Measurable impact
–33%
Customer shipping errors decreased by 33% in the same timeframe
Medical Devices