THE FEUTEX TOOLKIT

Periodic Review Order-up-to Plan

Calculate a replenishment quantity covering review plus lead time, net of inventory position.

Supply Chain workspace● Runs in your browser

01 Your input

Daily demanditems/dayReviewdaysLeaddaysSafetyitemsOn handitemsOn orderitemsBackordersitems

02 Your result

View or copy raw result data

Result data

Formula

Target stock = v.daily_demand*(v.review+v.lead)+v.safety ; Order quantity = Math.max(0,v.daily_demand*(v.review+v.lead)+v.safety-v.on_hand-v.on_order+v.backorders)

Sources and model references

https://learning.sap.com/courses/discovering-retail-functions-and-business-processes-in-sap-s-4hana-retail/performing-requirements-planning_bbf9e421-fee4-4c82-bb13-5cf8ad7d7121

Worked example

Inputs

Daily demand: 40 items/day
Review: 7 days
Lead: 5 days
Safety: 100 items
On hand: 300 items
On order: 150 items
Backorders: 20 items

Expected results

Target stock: 580 items
Order quantity: 150 items

Load the example in the workspace to reproduce these results. Display rounding does not change the underlying calculation.

How to use this tool

Enter your own assumptions using a consistent currency and period.
Review the scenario outputs and compare alternative inputs.
Check the stated model limits before using the result in an operating plan.

Try this example

{
  "daily_demand": 40,
  "review": 7,
  "lead": 5,
  "safety": 100,
  "on_hand": 300,
  "on_order": 150,
  "backorders": 20
}

Accuracy and scope

Deterministic planning scenario; inputs are assumptions, not forecasts. Excludes taxes, financing, legal requirements and costs not explicitly entered. Source explains the underlying planning framework; this specific scenario arithmetic is original.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.