Example 4 - Available stock above ROP

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

The Pre-requisites for this scenario:

The Calculate Schedules input values for the Macro or worksheet:

  • Order Start Offset: 13 (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: 10496

Location code: F1

Measure mapping inputs:

  • Default Source Method: 2 (Purchase)
  • Opening stock: 52
  • Reorder Point (ROP): 60
  • Receiving calendar ID: 3
  • Freeze Period: 10
  • Lead Time (Purchase): 7
  • Minimum Lot Quantity (Purchase): 12
  • Increment (Purchase): 3

ROP schedule logic

If the Opening Stock < ROP, get the corresponding interpolation calendar from current Engine Settings based on the Measure mapping for Receiving Calendar ID (ID = 3). The default pattern for the interpolation calendar (Tuesday available):
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
0 0 1 0 0 0 0

For No override pattern for the order receiving dates:

  • The first possible order date in the future horizon is calculated as Start_date + MAX of:
    • Order Start Offset = 13
    • Lead Time (Purchase) = 7
    • 2016-06-27 + 13 = 2016-07-10
  • Receiving_date = 1st non-zero day in the receiving calendar >= first_order_date AND <=End_date:
    Non-zero days from Start_date Day of week Before or After first_order_date? Before or After End_date?
    2016-06-28 Tuesday BEFORE BEFORE
    2016-07-05 Tuesday BEFORE BEFORE
    2016-07-12 Tuesday AFTER BEFORE
  • If the receiving_date is identified, check for any existing orders available prior to receiving_date:
    • Get Orders (Start_date: 2016-06-27, receiving_date: 2016-07-12). See, Get Orders logic flow.
    • Sum of the orders (planned, fixed, firm and scheduled) prior to receiving_date is displayed.
    • Get Orders: 12
  • Available stock (Opening stock + Get Orders): 64

If Opening Stock is not less than ROP, planned order is not required.

If mapped, set output measure ‘Schedule Last Calculated’ = current date and time.