|
Row Name
|
Display Condition
|
Description
|
|---|---|---|
|
Requirements
|
None
|
|
|
Backorder Original
|
Only display if backorder exists
|
Original backorder quantity
|
|
Allocated
|
Only display if allocated exist
|
Allocated Quantity from stock amount table
|
|
Replenishment Sent
|
Only display if outbound replenishments exist
|
Outbound recommended and approved replenishment orders
|
|
Balancing Orders Sent
|
Only display if outbound balance orders exist
|
Outbound recommended and approved balancing orders
|
|
Excess Recall Orders Sent
|
Only display if outbound excess recall orders exist
|
Outbound recommended and approved excess recall orders
|
|
Repair Orders Sent
|
Only display if rework repair orders exist
|
Outbound recommended and approved rework repair orders (where rework flag in order plan table is set to yes)
|
|
Sales Orders
|
Sum of open sales order quantities for sales orders which have due dates in future up to the maximum of local procurement, repair, repl/balancing lead times + buffer days specified in global setting OP_ADD_DAYS_TO_LT_TO_CALC_TOROP_BALANCE
Note that if GS is set ‘-1’ the total time horizon is used
|
|
|
Downstream Sales Orders
|
Sales orders of Trigger pairs outside the inventory position lead time at downstream locations that are projected back to parent locations until they are within a Trigger parent’s inventory position or the Time Phased parent. The projected sales orders are counted as normal sales orders.
|
|
|
Trigger Point Replenishment Deficit
|
Only display in integrated mode
|
The sum of the replenishment deficit (Amount Requested - Recommended Quantity) from the trigger point child locations.
|
|
Stock Maximum
|
Total of ROP and Effective Order Quantity
|
|
|
Trigger Point Chain Deficit
|
Only display if the part is in a part chain
|
The Chain deficit at the Top Most Part due to down-chain part requirement that could not be met with available supply for Trigger pairs. This only displays if the selected part is in a part chain.
|
|
Supply
|
None
|
OH Good + Approved Orders + On Order + In Repair + In return * NFF
|
|
On Hand Good
|
None
|
If in chain: On Hand Orig - Outgoing + Incoming
otherwise On Hand Good Orig
|
|
On Hand Good Orig
|
Only display if SKU is part of a chain
|
Sum of On Hand New Orig and On Hand Fixed Orig quantities from stock amount table
|
|
Outgoing Chain and Substitute
|
Only display if SKU is part of a chain or has substitutes
|
Outgoing Chain + Outgoing Substitutes
|
|
Outgoing Chain
|
Only display if SKU is part of a chain
|
Transfer to down-chain Part + Roll up to superseding Part + Rolled up good as defective
|
|
Transfer to down-chain Part
|
Transfer to down-chain Part
|
|
|
Roll up to superseding Part
|
Roll up to superseding Part
|
|
|
Rolled up good as defective
|
Rolled up good as defective
|
|
|
Outgoing Substitutes
|
Only display if SKU has substitutes
|
Outgoing Substitutes
|
|
Incoming Chain and Substitutes
|
Only display if SKU is part of a chain or has substitutes
|
Incoming Chain + Incoming Substitutes + Reduce To Produce
|
|
Incoming Chain
|
Incoming Roll-up + Transfer
|
|
|
Incoming roll-up from lower indenture part
|
Incoming roll-up from lower indenture part
|
|
|
Transfer from higher indenture part
|
Transfer from higher indenture part
|
|
|
Incoming Substitute
|
Only display if SKU has substitutes
|
Incoming Substitute
|
|
Reduce to Produce (disassembly)
|
Only display if incoming Disassembly Good order exists
|
Sum of inbound disassembly orders (order type = 7)
|
|
Planned Orders
|
Procurement + Repair + Replenishment + Balancing + Excess Recall
|
|
|
Procurement
|
Planned procurement orders
|
|
|
Repair
|
Planned repair orders
|
|
|
Replenishment
|
Planned replenishment orders
|
|
|
Balancing
|
Planned balancing orders
|
|
|
Excess Recall
|
Planned excess recall orders
|
|
|
On Order
|
On Order Quantity from stock amount table
|
|
|
In Repair
|
In Repair Quantity from stock amount table
|
|
|
Good Available in Future
|
Good Available in Future Quantity from stock amount table
|
|
|
Inventory Position
|
Supply - Requirements
|
|
|
Supply (Defective)
|
Only display if SKU is repairable
|
On Hand Bad Orig + Incoming - Outgoing
|
|
On Hand Bad Orig
|
On Hand Bad Orig Quantity from stock amount table
|
|
|
Incoming
|
Defective Sales Return + Reduce to Produce, Defective
|
|
|
Defective Sales Returns
|
In Return Orig * (1-NFF Rate)
|
|
|
Reduce to Produce (Defective)
|
Sum of inbound disassembly orders (order type = 8)
|
|
|
Incoming Defective
|
Incoming defective
|
|
|
Outgoing
|
Repair defective parts on outgoing repair orders + Roll-up Defective
|
|
|
Repair defective parts on outgoing repair orders
|
Number of units expected to be send on outgoing repair orders
|
|
|
Roll-up Defective
|
Roll-up defective
|
|
|
Bad Available in Future
|
Bad arriving in Future from stock amounts table
|
|
|
Targets
|
Targets
|
|
|
Stock Maximum
|
Stock Maximum
|
|
|
ROP
|
Re-order point
|
|
|
EOQ
|
The Economic Order Quantity (EOQ) is the optimum quantity of goods to be purchased at one time in order to minimize the cost of ordering and holding items in inventory. The two main variables in the Economic Order Quantity (EOQ) calculation are:
• Order Cost
• Carrying Cost (also known as Holding Cost)
At any order point (be it one piece or one thousand pieces), by adding the Carrying Cost per part with the Order Cost per part, you get the total cost of that part.
|
|
|
Supply (Recommended)
|
Procurement + Repair + Replenishment + Balancing + Excess Recall
|
|
|
Procurement
|
Recommended procurement orders
|
|
|
Repair
|
Recommended repair orders
|
|
|
Replenishment
|
Recommended replenishment orders
|
|
|
Balancing
|
Recommended balancing orders
|
|
|
Excess Recall
|
Recommended excess recall orders
|
|
|
Excess Limit
|
The limit above which inventory is considered in excess. The calculation of Excess Limit is in relation to the Order Policy Type that is used:
• When using Time Phased it is calculated as (Safety Stock + EOQ – 1)
This can be increased if order sizing or Excess Burnout Days are used.
|