Example 3 - Opening stock above ROP

This topic describes the process of defining an item, location based on ROP schedule logic when the available stock is zero.

The Pre-requisites for this scenario:

The Calculate Schedules input values for the Macro or worksheet:

  • Order Start Offset: “” (macro) or 0 (macro or worksheet)
  • Requirements horizon: “” (macro) or 365 (worksheet)

Global inputs (cycle period and engine call values):

  • Current Planning Period: FY16 M07 (2016-06-27 – 2016-07-24)
  • Start_date: 2016-06-27 (Current Planning Period's Start Date)
  • Cycle Future Horizon: 52 weeks
  • End_date: 2017-06-27 (Current Planning Period's Start Date + Cycle Future Horizon in days)

Item code: 10140

Location code: F1

Measure mapping inputs:

  • Default Source Method: 1 (Transfer)
  • Opening stock: 200
  • Reorder Point (ROP): 100
  • Receiving calendar ID: 1
  • Freeze Period: 7
  • Lead Time (Transfer): 7
  • Minimum Lot Quantity (Transfer): 100
  • Increment (Transfer): 20

ROP schedule logic

  • If the Opening Stock is not less than ROP, planned order is not required.
  • If mapped, set output measure ‘Schedule Last Calculated’ = current date & time.