Integrated Supply Chain - Personal Health

Supply Planning Simulator

Fixed-order sandbox: JIT → LBA pull-ahead → due-week overtime → minimum-fill → late catch-up.

Scenario view

Weekly load plan

Planner controls

Scenario inputs

Inputs & results

Planning table

Tip: paste Excel into a cell to fill downward; bulk fill sets one column for all weeks.

Week Demand Minimum utilization Capacity Overtime capacity JIT Pull ahead Overtime Late load Total load Late due demand Utilization

Learning

How this simulator builds a load plan

Every KPI and chart segment traces back to the same deterministic sequence below. The goal is not “guessing” capacity—it is applying transparent rules so you can see cause and effect when demand, LBA, or minimums change.

1 · JIT on the due week

For each week’s demand, the engine first loads as much as possible on regular capacity in that same week (the due week). That volume shows up as JIT. This mirrors “make what is due now” before borrowing earlier capacity.

2 · Pull-ahead within local build-ahead (LBA)

What does not fit JIT is produced in earlier weeks using their regular capacity, stepping backward week by week. You cannot pull farther than your local build ahead setting allows. This is the core pull ahead bucket (purple in the chart).

3 · Overtime on the due week

After JIT and pull-ahead, remaining uncovered demand for that due week uses overtime capacity declared on that same week—not earlier weeks—before anything is marked late.

4 · Late due (until placed)

Demand that still cannot be placed becomes late due demand for that due week. It has not disappeared; the next phase tries to absorb it forward in time.

5 · Minimum utilization fill

Separately, if a week’s total load would sit below its minimum utilization (capped by regular capacity), the model pulls future JIT into that earlier week—within the same LBA window—to lift the week toward its minimum. That movement also counts toward pull-ahead and the LBA intensity KPI (weeks early × units).

6 · Late catch-up in later weeks

Late due units are pushed forward, consuming regular capacity first, then overtime, in chronological order in later weeks until the horizon ends. Whatever cannot be placed remains unresolved beyond the horizon—a signal that the scenario cannot close inside the simulated window.