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.
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.
Produced by MO	Displays the quantity replenished by manufacturing orders.
Produced by PO	Displays the quantity replenished by purchase orders.
Produced by DO	Displays the quantity replenished by distribution orders.
Total consumed	Quantity consumed into 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.
Consumed by MO	Displays the quantity consumed by manufacturing orders.
Consumed by DO	Displays the quantity consumed by distribution orders.
Consumed by SO	Displays the quantity consumed by sales orders.
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.
Work in progress MO	Sum of the manufacturing order quantities in progress in that time bucket.
On order PO	Sum of the purchase order quantities on order in that time bucket.
In transit DO	Sum of the 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.