Example 5 - No valid receiving day

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

The Pre-requisites for this scenario:

The Calculate Schedules input values for the Macro or worksheet:

  • Order Start Offset: 14 (macro or worksheet)
  • Requirements horizon: 28 (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)
  • End_date: 2017-06-25 (Current Planning Period's Start Date + Cycle Future Horizon in days)

Item code: 10141

Location code: B1

Measure mapping inputs:

  • Default Source Method: 1 (Transfer)
  • Opening stock: 0
  • Reorder Point (ROP): 60
  • Receiving calendar ID: 4
  • Freeze Period: 7
  • Lead Time (Transfer): 7
  • Minimum Lot Quantity (Transfer): 10
  • Increment (Purchase): 5

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 = 4). The default pattern for the interpolation calendar (First Monday of every month):
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
0 1 0 0 0 0 0
Table 1. Override patterns:
Date After Date Before Description Sunday Monday Tuesday Wednesday Thursday Friday Saturday
2016-07-11 2016-07-31 0 0 0 0 0 0 0 0
2016-08-08 2016-08-31 0 0 0 0 0 0 0 0
2016-09-12 2016-09-30 0 0 0 0 0 0 0 0
2016-10-10 2016-10-31 0 0 0 0 0 0 0 0
2016-11-14 2016-11-30 0 0 0 0 0 0 0
2016-12-12 2016-12-31 0 0 0 0 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 = 14
    • Lead Time (Purchase) = 7
    • Freeze Period = 7
    • 2016-06-27 + 14 = 2016-07-11
  • 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-07-04 Monday BEFORE BEFORE
    2016-01-08 Monday AFTER AFTER
  • If receiving_date is not matching, the planned order is not possible.
  • If mapped, set output measure ‘Schedule Last Calculated’ = current date & time.