Inventory management system design for a chimney service firm
- Location
- Pennsylvania, USA
- Year
- 2020
- Engagement
- Profitability Improvement: Reporting & Automation
Chimney specialist had expanded in previous two years. Client had no inventory management system or processes and COVID-19 supply chain issues were exacerbating over-purchase and stockout issues.
Our team analyzed all purchases in previous five years to create list of SKUs and usage for all parts and other consumables. We established min/max values based on order quantities, ease of sourcing, lead time and usage multiples. Linked spreadsheet database to QuickBooks and quoting / scheduling software via API.
Measurable impact
–80%
Reduced inventory management workload from 1.0 to 0.2 FTE
Trades, Home and Personal Services
Measurable impact
–18%
Reduced inventory by 18% while reducing stockouts
Trades, Home and Personal Services
Measurable impact
88%
Improved min/max compliance from 24% (untracked) to 88% (tracked and managed)
Trades, Home and Personal Services