Skip to main content
Administrator Guide
Last Updated: 2025-09-19
Calculate Par Average Daily Usage

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: Inventory
    domain 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.
  1. Access the
    Calculate Par Average Daily Usage
    task.
  2. As you complete the task, consider:
    Option Description
    Previous Horizon Days
    Enter 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 the
    Previous Horizon Days
    value based on the percentage you configure.
    Include Returns
    Select 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.