Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-09-08
Calculate Par Recommended Reorder Points

Calculate Par Recommended Reorder Points

Security: These domains in the Inventory functional area:
  • Manage: Par Inventory
  • Reports: Par Inventory
You can configure Workday to calculate a recommended reorder point for your par items to reduce manual data review. We enable you to make frequent adjustments to minimum and maximum stocking quantities based on your usage activity, which improves your demand forecasting and anomaly detection.
When you don't enable decimal stocking quantities for the par item and unit of measure combination, Workday rounds recommended par levels and reorder points to whole numbers. When the item isn't a purchase item, Workday rounds the item level to a whole number.
  1. Access the
    Calculate Par Recommended Reorder Point
     task.
  2. Complete the task:
    Option Description
    Auto Generate Worksheet
    Select to generate a workbook, enabling you to update the reorder point and par level of your items, and save that information outside of Workday.
    Par Company
    Select the company to record par transaction accounting entries.
    Location Hierarchy
    Enables you to calculate suggested par levels and order points for multiple par locations. You must have access to the specific location hierarchy to select it.
    Reorder Calculation Type
    Current ADU
     uses the average daily usage for the par item, on the par inventory site, in the base unit of measure. This method is best for:
    • New items with no history.
    • Items with inconsistent usage.
    Previous Horizon
     uses the number of transactions during the time period that you configure on the
    Previous Horizon Days
     and
    Days to Include
     prompts. Best for items with consistent usage.
    Seasonality and Trend
     uses historic year-over-year data to calculate trend and seasonality. Best for seasonal items with consistent usage.
    Reorder Manual Adjust %
    Enter a percentage multiplier to add to your recommended reorder point. Example: Make a 20% adjustment for a seasonal rush of inventory usage.
    Use Lead Time
    Select to use the configured
    Preferred Supplier Lead Time
     value from the Inventory Site options on the purchase item, in your reorder point calculation.
    Use Target Days on Hand
    Select to use the minimum amount of par inventory you want to have on hand, measured in number of days of stock for the item in your calculation.
    Update Par Level
    Select to update the stock level for the par items.
    Update Reorder Point
    Select to update the reorder point on the par items to the value recommended by the task.
    Exclude Critical Items
    Select to exclude items from planning or automatic updates. Use this option for items that needs to maintain a minimum quantity regardless of historic demand.
    Reorder Tolerance %
    When you configure Workday to update your reorder point, you can enter a tolerance percentage. Workday automatically updates your reorder point only when it falls within the percentage you configure. When you leave the field blank, Workday updates all reorder points with the recommended values the task generates. Example: You enter in 25% and the current reorder point is 100, so the recommended reorder point must be between 75-125 to update.
    Replenishment Source
    Enables you to restrict your reorder point calculations to items from the replenishment source you select.
Workday provides the recommended reorder point of the par item in the replenishment UOM.
Workday calculates these fields for your par items:
  • Adjusted Average Daily Usage
    , which equals the
    Average Daily Usage
     plus ((
    Average Daily Usage
     multiplied by the
    Reorder Manual Adjust %
    ) divided by 100).
  • Recommended Par Level Calculation
    , which equals the:
    • (
      Target DOH
       plus
      Lead Time
      ) multiplied by
      Adjusted Average Daily Usage
       when you select the
      Use Lead Time
       option and the par line has a target DOH.
    • Target DOH
       multiplied by
      Adjusted Average Daily Usage
       when you don’t select the
      Use Lead Time
       option and the par line has a target DOH.
    • Adjusted Daily Usage
       multiplied by
      Lead Time
       when you don’t select the
      Use Target Days on Hand
       option or the par line doesn't have a target DOH.
  • Recommended Reorder Point
    , which equals the:
    • Adjusted Average Daily Usage
       multiplied by (
      Minimum Days on Hand
       plus
      Lead Time
      ) when you select the
      Use Lead Time
       option.
    • Adjusted Average Daily Usage
       multiplied by
      Minimum Days on Hand
       when you don’t select the
      Use Lead Time
       option.
You can use the
Recommended Par Levels
 report to view replenishment details by par inventory site and par item.