Inventory report
The report shows per buffer and per time bucket the inventory profile: the starting inventory, the material consumed, the material produced and the ending inventory.
If the report is opened for a single buffer an inventory graph is displayed.
The rows in the report are defined such that following equations apply:
End inventory = Start inventory + Total produced – Total consumed
Start inventory = End inventory of the previous time bucket
Total produced = Produced by MO + Produced by PO + Produced by DO
Total consumed = Consumed by MO + Consumed by DO + Consumed by SO
Field |
Description |
|---|---|
Item |
Item stored in the buffer. |
Location |
Location of the buffer. |
Start inventory |
Inventory in the buffer at the start of the time bucket. |
Start inventory days of cover |
Shows how many days of demand is covered with the starting inventory.
In other words, it shows when will you run out of stock without new
replenishments.
|
Safety stock |
The safety stock at the start of the time bucket. |
Inventory status |
Represents the delay for unprotected buffers (community version or
buffers without inventory policy) otherwise represents the buffer
inventory status
|
Total produced |
Quantity replenished into the buffer during the time bucket.
A drill down menu is available to see the detail of the supplying operations,
and to see the demands the produced material is used for.
Total produced = total produced confirmed + total produced proposed
|
Total produced confirmed |
Quantity produced into the buffer during the time bucket by confirmed and
approved operations.
Total produced confirmed = total produced by MO confirmed
+ total produced by PO confirmed
+ total produced by DO confirmed
|
Total produced proposed |
Quantity produced into the buffer during the time bucket by proposed operations.
Total produced confirmed = total produced by MO proposed
+ total produced by PO proposed
+ total produced by DO proposed
|
Produced by MO |
Displays the quantity replenished by manufacturing orders.
Produced by MO = Produced by MO proposed + Produced by MO confirmed
|
Produced by MO confirmed |
Displays the quantity replenished by confirmed and approved manufacturing orders.
|
Produced by MO proposed |
Displays the quantity replenished by proposed manufacturing orders.
|
Produced by PO |
Displays the quantity replenished by purchase orders.
Produced by PO = Produced by PO proposed + Produced by PO confirmed
|
Produced by PO confirmed |
Displays the quantity replenished by confirmed and approved purchase orders.
|
Produced by PO proposed |
Displays the quantity replenished by proposed purchase orders.
|
Proposed ordering |
Displays the quantity of the proposed POs that need to be
purchased in this time bucket.
|
Produced by DO |
Displays the quantity replenished by distribution orders.
Produced by DO = Produced by DO proposed + Produced by DO confirmed
|
Produced by DO confirmed |
Displays the quantity replenished by confirmed and approved distributrion orders.
|
Produced by DO proposed |
Displays the quantity replenished by proposed distributrion orders.
|
Total consumed |
Quantity consumed from the buffer during the time bucket.
A drill down menu is available to see the detail of the consuming operations,
and to see the demands the consumed material is used for.
Total consumed = total consumed confirmed + total consumed proposed
|
Total consumed confirmed |
Quantity consumed from the buffer during the time bucket by confirmed and
approved operations.
Total consumed confirmed = total consumed by MO confirmed
+ total consumed by PO confirmed
+ total consumed by DO confirmed
|
Total consumed proposed |
Quantity consumed from the buffer during the time bucket by proposed operations.
Total consumed proposed = total consumed by MO proposed
+ total consumed by PO proposed
+ total consumed by DO proposed
+ consumed by SO
|
Consumed by MO |
Displays the quantity consumed by manufacturing orders.
Consumed by MO = consumed by MO proposed + consumed by MO confirmed
|
Consumed by MO proposed |
Displays the quantity consumed by proposed manufacturing orders.
|
Consumed by MO confirmed |
Displays the quantity consumed by confirmed & approved manufacturing orders.
|
Consumed by DO |
Displays the quantity consumed by distribution orders.
Consumed by DO = consumed by DO proposed + consumed by DO confirmed
|
Consumed by DO proposed |
Displays the quantity consumed by proposed distribution orders.
|
Consumed by DO confirmed |
Displays the quantity consumed by confirmed & approved distribution orders.
|
Consumed by SO |
Displays the quantity consumed by sales orders.
|
Consumed by Fcst |
Displays the quantity consumed by forecast.
|
Net forecast |
The net forecast for that time bucket.
|
Open sales orders |
The open sales orders with a due date in that time bucket.
|
Total demand |
The total demand due in that time bucket.
Total demand = Open sales orders + Net forecast.
|
Total in progress |
Sum of the manufacturing/purchase/distribution order quantities in progress.
The shipping/starting date of the order must be before the end date
of the time bucket and the receiving/enddate of the order must be after
the end date of the time bucket to be considered in progress.
Total in progress = Total in progress confirmed + Total in progress proposed
|
Total in progress confirmed |
Work in progress confirmed = Work in progress MO confirmed
+ In transit DO confirmed + On order PO confirmed
|
Total in progress proposed |
Work in progress proposed = Work in progress MO proposed
+ In transit DO proposed + On order PO proposed
|
Work in progress MO |
Sum of the manufacturing order quantities in progress in that time bucket.
Work in progress MO = Work in progress MO confirmed
+ Work in progress MO proposed
|
Work in progress MO proposed |
Sum of the proposed manufacturing order quantities in progress in that time
bucket.
|
Work in progress MO confirmed |
Sum of the confirmed and approved manufacturing order quantities in progress
in that time bucket.
|
On order PO |
Sum of the purchase order quantities on order in that time bucket.
On order PO = On order PO confirmed + On order PO proposed
|
On order PO confirmed |
Sum of the confirmed and approved purchase order quantities on order in that
time bucket.
|
On order PO proposed |
Sum of the proposed purchase order quantities on order in that
time bucket.
|
In transit DO |
Sum of the distribution order quantities in transit in that time bucket.
In transit DO = In transit DO confirmed + In transit DO proposed
|
In transit DO confirmed |
Sum of the confirmed and approved distribution order quantities in transit
in that time bucket.
|
In transit DO proposed |
Sum of the proposed distribution order quantities in transit in that time
bucket.
|
End inventory |
Inventory in the buffer at the end of the time bucket.
A drill down menu is available to see the detail of the consuming and
producing operations, and to see the demands the consumed material is used
for.
|
Total backlog |
The total quantity of demand due in the past that is still to be planned.
Total backlog = Order backlog + Forecast backlog
|
Order backlog |
The total quantity of sales orders due in the past that is still to be planned.
|
Forecast backlog |
The total quantity of forecast due in the past that is still to be planned.
|
