Skip to main content

Available to Promise

Available to Promise simulates the production of a finished product and returns the date it could be delivered, together with the two things that date depends on: the capacity of the resources its operations need, and the material its components would consume.

alt text

The result is a row of five dates, read left to right. A Calculated Start later than Start means something is in the way, and Delivery is the answer — the date you can promise. Above them the simulation repeats what it was asked: the final product, its version, the warehouse and the stock on hand.

Nothing is written — no work order, no reservation, no change to the item — so the simulation can be run as often as needed.

Production timeline​

StepDescription
StartEarliest date production could begin given current resource and material availability.
Calculated StartDate production should begin to meet the requested quantity within the working calendar.
Production DaysNumber of working days needed for production. Weekends are excluded.
CompleteDate the last unit comes out of production.
DeliveryEarliest date the goods can be delivered after production completes.

Available to Promise

Parameters​

FieldDescription
ItemThe finished product to promise — one item, picked from a list that shows code, name, stock and material group. Required.
Item VersionThe item version to simulate, for an item under version control. Empty uses the current version.
VariantThe planning variant to simulate, for a configurable item.
QuantityHow many to promise. Required, 1 by default.
WarehouseThe warehouse to deliver from. Empty follows the item's warehouse rule.

The parameters are kept in the address of the page, so a simulation can be bookmarked or sent to a colleague.

Resource Capacity​

One row per resource the item's operations need.

ColumnDescription
CodeThe resource.
NameThe resource's description.
Total TimeThe total time the simulation needs on that resource.
Period columnsOne per day, week or month, each holding two figures: the time planned on that resource in that period, and underneath it the share of the resource's capacity that represents.

The color of each period column comes from the calculation, not from a threshold you set:

Cell ColorMeaning
GreenComfortable load — capacity available.
YellowWarning — load close to capacity.
RedOverloaded — capacity exceeded; the resource is the bottleneck for this period.

Materials​

One row per component the production would consume.

ColumnDescription
CodeThe component.
NameThe component's description.
InventoryThe stock currently on hand.
RequirementsThe total quantity the simulation would consume.
BalanceWhat is left once the requirement is taken off the stock. Red when negative — the component is short.
Lead TimeDays the component takes to arrive when it has to be procured.

The period columns hold the quantity needed in that period on top and the running balance underneath. The running balance carries forward, so the first period where it turns red is when the shortage bites, and the component's lead time says how far ahead of that someone has to order.

How wide a period is follows how far ahead the simulation had to look: daily up to two weeks (weekends skipped, the first column prefixed <=), weekly up to about fifteen weeks (year and calendar week), monthly beyond that. Fifteen periods are shown at most. Both grids export to Excel in full.

Examples​

The delivery date is later than the customer will accept. A red period in Resource Capacity means capacity limits the date — another shift, or moving other work, pulls it in. A red Balance in Materials means a component limits it, and the fix is a purchase order. If both are clean, the date is production time plus lead times, and only a smaller quantity moves it.

Promising a partial quantity. Run the simulation for the full quantity, then for less. The figures scale with it, so two runs show how much can be promised for the original date.

Limitations​

  • One item at a time. For several products, run the simulation once per product.
  • The material check reflects the last MRP run, not live stock. A goods receipt posted since then is not in the answer.
  • The lead time comes from the item's default MRP settings, not from a supplier quotation.
  • Variants, configurations and formulas in the bill of materials or the routing are not evaluated. Short variants and item versions are.
  • Capacity other sales orders will need is only counted when a work order already exists for them.
  • The result is not saved, and nothing links it to a sales order. A date you promise has to be recorded on the order yourself.