Client Context
Smurfit Westrock’s Paper & Packaging Solutions sample system currently experiences long cycle times, process inconsistency, and increasing costs. Containerboard sample processing time can take up to 31 days, and paperboard sample costs are increasing 32% YoY. There is no centralized data connecting sample orders to product sales, and inconsistent sample packaging has created variability in the customer experience.
Project Objective
The objective of the project was to streamline data tracking and sales conversion, reduce cycle time from 11 days to 4 days, and improve inventory and sample packaging consistency through automation, centralized data, and standardized processes. For Paperboard, the objective was to improve cost efficiency and inventory management through standardization, inventory planning, and third-party relationship improvements, resulting in measurable cost savings.
Design Strategy
The project followed a three-step approach consisting of process mapping and needs assessment, system design and automated workflow development, and testing, optimization, and process documentation. These phases were supported using Power Apps for the automated intake form and dashboard, SharePoint as the centralized data sources, and Excel for sample-to-sales tracking, inventory planning, and cost analysis.
Deliverables
Containerboard:
• Material Flow Analysis with Centralization and Inventory Standardization Recommendations
• Automated Intake Form and Dashboard for Sample to Sales Tracking and Cycle Time Reduction (11 days to 4 days)
Paperboard:
• Cost and Inventory Standardization Recommendations
• Dynamic Excel Tool for Inventory Planning
• Detailed RFP Recommendation to Ensure a Positive Third-Party Relationship Strategy
Value and Impact
Containerboard: Customer Experience
• Streamlined Data Tracking and Sales Conversion
• 11-day Turnaround Improved to 4 Days
• 63% Decrease in Cycle Time
Paperboard: Cost Savings
• $36,000+ of Additional Savings Opportunity Identified
• Recommendations for Inventory and Third-Party Relationship
• $82,000+ Annual Savings
Project Information
Student Team
John Rezabek, Ansley Gavron, Jesus Villarreal, Katie (Mary) Fish, Elena Gavtadze, Aileen Harrisson