Summary
The Order Schedule Detail grid is one of the most important displays in all of StockIQ, as it's where your various inventory parameters come together to generate blanket order suggestions, including:
- Your current on hand
- Open demands
- Forecast
- Dependent Forecast
- Open regular PO's
- Open blanket PO's
- Your safety stock for matching item-sites
- Holidays, smoothing and supplier capacities
- Order Cycles
Column Description
The key aspect of the grid is that it's showing you a day-by-day (or week-by-week or month-by-month) projection of your inventory levels, and based on those projections, the orders that must be placed to keep you at or above your safety stock level for matching item-site-suppliers, in accordance with your order policies.
Period Date: If you are looking at daily resolution, this is the date of the inventory projection. If you are looking at weekly or monthly, it is the beginning of the week or month period.
Demand
Actuals: Any open firm demands, such as customer orders, pending transfer pulls, or pending work order allocations. This should be the same as in the normal Order Schedule screen
Independent Forecast: this is the independent forecast from Forecast Manager. This should be the same as in the normal Order Schedule screen
Supply
On Order: Pending arrivals of open regular PO's. This should be the same as in the normal Order Schedule screen
On Blanket: Pending arrivals of open blanket PO's
Planned Orders
Release: Shows the quantity and date of when StockIQ suggests you release this blanket order. This quantity is calculated by finding the longest possible shipping time based on matching item-site-suppliers then working backwards to see what is needed today.
Ship: Shows the corresponding ship date for an order released on the release date, given the lead times provided to StockIQ.
Receipt: Shows the Planned Receipt Date for an order released and shipped on the associated dates, given the lead times provided to StockIQ. Note that this quantity is planned to arrive on this date, and then contributes to projected On Hand for that date.
Projected Inventory
On Hand: shows the projected on hand level calculated given all your supply and demand, including any suggestions made by StockIQ. If qty exists in the On Blanket column, we add that qty to Project On Hand to give visibility that there's an existing blanket(s) out there that is already being produced. The goal is to show this so we are not suggesting duplicate blanket order quantities. This is NOT done on the normal Order Schedule since Place Orders functions to get product in now by releasing from existing blankets or placing a new normal PO.
IMPORTANT: If you are looking at a weekly or monthly rollup, this is the level projected to be on hand at the END of the period displayed, e.g. the end of the week or end of the month.
Days: Your days of supply based on projected on hand, given average usage of that item at that point.
Balance: Your projected on hand quantity converted to an inventory value.
Flags & Colors
A few different colored "flags" can be shown in the Order Schedule depending on the data present:
Release & Receipt Column - Blue Flag
Blue flags in the release and receipt columns indicate the days over which your "Days Coverage" or Order Cycle are covering you for the current order cycle. In this way, you can visually see what your Days Coverage or Order Cycle has done on your order schedule without having to count days on the grid.
Period Date Column - Orange Flag
These flags indicate the presence of Site or Supplier holidays. See the Site Holiday and Supplier Holiday topics for more details on the implications of setting these holidays.
Release, Ship & Receipt Column - Cyan Flag
These Cyan (light blue) colored flags indicate the presence of a Vendor Schedule. If the flag is in the Release column, you have an order schedule. If it is in the Ship column, you have a Ship schedule, and if the flag is in the Receipt column, you have a Delivery schedule. The flags appear on the days that are NOT available for order/ship/receipt due to your schedule limitations.
This image shows an Vendor Schedule where deliveries are allowed on Tuesdays and Thursdays: