Wilkins, A Zurn Company: Materials Requirement Planning Custom Case Solution & Analysis
Evidence Brief: Wilkins, A Zurn Company
1. Financial Metrics
- Annual Sales Growth: Consistent 20 percent year-over-year increase in the backflow preventer market.
- Inventory Value: Total inventory reached 4.5 million dollars by the end of the fiscal year.
- Inventory Turns: Current turns sit at 2.4, significantly below the industry benchmark of 4.0 for similar manufacturing profiles.
- Product Range: Over 400 end-item stock keeping units (SKUs) with 2,500 active component parts.
- Order Backlog: Late shipments currently represent 15 percent of total monthly order volume.
2. Operational Facts
- System Infrastructure: Implementation of IBM MAPICS (Manufacturing Accounting and Production Information Control System).
- Lead Times: Cumulative lead times for complex assemblies range from 8 to 12 weeks; fabrication lead times average 4 weeks.
- Production Model: Transitioning from a manual card-based system to a computer-driven Materials Requirement Planning (MRP) logic.
- Manufacturing Process: High-mix, low-volume production involving brass casting, machining, and final assembly.
- Data Accuracy: Bill of Materials (BOM) accuracy is estimated at 85 percent; inventory record accuracy is approximately 70 percent.
3. Stakeholder Positions
- Rick: Production Manager. Believes the MRP system logic is too rigid and does not account for shop floor realities or machine breakdowns.
- Planners: Express frustration with the system generating hundreds of exception messages daily, leading to message fatigue.
- Marketing Team: Demands high finished goods safety stock to maintain 98 percent service levels regardless of production constraints.
- Zurn Corporate: Expects immediate reduction in working capital through lower inventory levels following the software investment.
4. Information Gaps
- Capacity Constraints: The case lacks specific data on machine hours available versus machine hours required (Rough Cut Capacity Planning).
- Setup Costs: Specific dollar costs for machine changeovers are not detailed.
- Vendor Reliability: No formal metrics provided on supplier on-time delivery percentages.
- Software Training: The total hours of employee training provided during the MAPICS rollout are unstated.
Strategic Analysis
1. Core Strategic Question
- The primary dilemma is the failure to synchronize the rigid, time-phased logic of the MRP system with the inherent variability of the manufacturing floor and inaccurate underlying data.
- Secondary issue: The conflict between the marketing goal of 98 percent service levels and the corporate mandate to reduce inventory value below 4 million dollars.
2. Structural Analysis
Inventory Management Lens: The bullwhip effect is being amplified by the MRP system. Because inventory records are only 70 percent accurate, the system triggers unnecessary replenishment orders, inflating work-in-process (WIP) and clogging the fabrication department.
Operations Strategy: Wilkins is attempting to run a sophisticated MRP system on a foundation of poor data discipline. The system assumes infinite capacity, which results in unrealistic production start dates that the shop floor ignores, reverting to informal prioritization.
3. Strategic Options
| Option | Rationale | Trade-offs |
|---|---|---|
| Freeze and Clean | Stop the MRP expansion to fix BOM and inventory accuracy to 95 percent plus. | Short-term production slowdown for long-term system reliability. |
| Hybrid Push-Pull | Use MRP for long-lead raw materials and Kanban/Visual cues for assembly. | Reduces system complexity but requires higher shop floor discipline. |
| Capacity-Constrained Scheduling | Integrate finite capacity planning into the current MAPICS module. | High implementation cost and technical difficulty. |
