Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Calculate Par Average Daily Usage

Calculate Par Average Daily Usage

  • Set up par locations
  • Set up par items
  • 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 the 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.
  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.