Tactical planning tool & Power BI dashboards

Tactical planning over an 18-month horizon at Michelin's largest North America plant means committing capacity long before demand is certain. The planning question is not what will happen — it is which combinations of demand, capacity and constraint would leave the plant exposed, and how early that can be seen.

• Integrated demand forecasts, capacity requirements and operational constraints into a single Excel model, so the three inputs that actually interact were evaluated together rather than in separate files.
• Built scenario analysis into the tool so alternatives could be run against the plan rather than argued about — the point of a tactical model is to be wrong cheaply, on paper.
• Evaluated production capacity, demand forecasts and resource limitations to identify where supply risk concentrated across the horizon.
• Built Power BI dashboards with Supply Chain, Manufacturing and Operations that mapped end-to-end processes and surfaced production bottlenecks — a model nobody reads changes nothing, so the output had to reach the people making allocation calls.

• A tactical planning tool supporting 18-month production decisions at the company's largest North American manufacturing plant.
• Improved planning visibility — supply risks surface as an output of the model rather than as a discovery later in the horizon.
• Power BI dashboards mapping end-to-end processes and identifying production bottlenecks, driving improvements in plant performance.

• Excel modeling
• Power BI
• Scenario analysis
• Demand forecasting
• Capacity planning