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.
Inventory report for a single buffer Inventory report as a graph Inventory report as a table