Analytical Insights of Physical Inventory Count
The objective of this blog post is to explain the analytical insights provided by the physical inventory count report and the underlying data source.
Warehouse Managers want to analyze the results of physical inventory counting activities. They want to know how accurate their inventory is in terms of number of counted items with or without deviations, which quantities were lost or gained, and which values are related to it. They want all different count methods being considered.
With the report physical inventory count you get 3 different views:
The View ‘Count Analysis on Number of Items’ focuses on the item level, meaning each line item in a physical inventory count document represents one count item, e.g. for one product which is located in 2 logistics areas, the number of count items is 2. This is displayed as the ‘Number of counted items’ key figure. If the item was counted as expected it is displayed as ‘1’ in the ‘Number of counted items without deviations, other wise it gets a 0. The 3rd key figure shows the % of inventory accuracy based on the items.
The view ‘Count Analysis on Quantities’ is meant for a product level analysis. It shows the book quantities, actual quantities and the quantity difference. Based on this the deviation percentage is calculated.
The view ‘Count Analysis on Values’ shows the planned value, confirmed value and the value difference. Also, here we provide the deviation value in %.
Here you find a link to a video with a demo