Calculate Par Average Daily Usage
- Set up par locations
- Set up par items
- Update the bin and unit of measure of a par line.
- Security:Set Up: Inventorydomain in the Inventory functional area.
You can use Workday to calculate the average daily usage (ADU) for your par items, increasing the accuracy of your item traffic reporting. To calculate par ADU, Workday adds daily shipments and receipts, and divides the result by the number of previous horizon days. Workday only applies this formula to receipts and returns to inventory and suppliers in
Approved
or Adjustment In Progress
status, and only includes shipments in a Closed
status.Workday only takes into account data from these transactions when calculating par ADU:
- Par counts.
- Stock requests created as a result of a par count.
- Requisitions created as a result of a par count.
When you update the bin and unit of measure of a par line and calculate the par ADU, the par line counts as new usage.
- Access theCalculate Par Average Daily Usagetask.
- As you complete the task, consider:
Option Description Previous Horizon DaysEnter the number of days going backwards from yesterday that you want to track your par item usage.Variance Exclusion %Enables you to exclude outliers from the calculation. When you enter an exclusion percentage, Workday calculates the quantity variance based on the true average daily usage. Workday doesn't include anything above or below the value in the calculation. When exclusions exist, Workday lowers thePrevious Horizon Daysvalue based on the percentage you configure.Include ReturnsSelect to include returns in the par ADU calculation formula. To calculate par ADU, Workday adds the daily shipments and receipts, subtracts the daily returns, and divides the result by the number of previous horizon days.
Workday updates the
Average Daily Usage
field on the par locations you select.Update your par inventory analytics.