Tactical Planning Tool & Power BI Dashboards

Tactical planning at Michelin’s US5 Lexington site relies on balancing tire production across the plant and projecting inventory over an 18-month horizon. However, the legacy planning file was over 12 years old, relied on outdated primary run locations, and ignored critical mold and tooling constraints which led to inaccurate data and unaligned production plans.

• Rebuilt the US5 Tactical File into a standardized planning tool using advanced Excel formulas, Power Query, and dynamic visualizations.
• Standardized primary run locations across CAIs and created internal bridge logic to automatically account for material, tooling, and mold constraints when shifting demand between shops.
• Constructed a polyvalency model to map shop bridging capabilities, evaluating machine-level constraints rather than relying on total theoretical capacity.
• Collaborated weekly with stakeholders (Central Tactical Planners, Master Planners, and SC Coordinators) to validate machine capacity, monthly commit volumes, and stock norms.
• Tested and iterated on the tool during the live June and July Tactical Planning cycles to refine inventory position models and risk forecasting.
• Built Power BI dashboards alongside Supply Chain and Operations teams to map end-to-end processes and surface production bottlenecks visually.

• Delivered a modernized tactical tool that bridges tactical and operational planning across tire-building shops, ensuring full compliance with MMW Foundations Bronze Level standards.
• Replaced reliance on theoretical capacity with machine-level constraint planning, enabling proactive mitigation of production risks months in advance.
• Provided planners with a repeatable framework to optimize capacity levers, stock levels, and cross-shop demand allocation.
• Created Power BI dashboards to highlight production bottlenecks and align cross-functional decision-making across plant operations.

• Excel Modeling
• Power BI
• Scenario Analysis
• Demand Forecasting
• Capacity Planning