How To: Use the PAR Worksheet

How To: Use the PAR Worksheet




The PAR Worksheet provides a fast, repeatable way to mass update PAR levels using actual sales data from a selected date range or event.

  1.  The following employee permission:
    1. Worksheets > PARWorksheets

  2. Know your objectives:
    1. The date range or event you want to analyze
    2. Which stores or stands you want to update
    3. Whether you need restocking sizes only (recommended for concessions)






  1.  Navigate to Worksheets > PAR and select Create New PAR Worksheet.

  2. Enter Worksheet Number. (Date of event)
    ex. 03.15.26

  3. Enter Description (Name of event)
    ex. Game 5 - High Attendance

  4. Select Stands.

  5. Select Size.
    For Concession clients it is recommended to select Include Only Restocking Size.

  6. Select Levels.
    Include all levels unless creating PAR worksheets for specific item sets.

  7. Set Date Span or Event.
    This is the date range or event that sales will be pulled for analytics.

  8. Click Fetch Data.

  9. Set Sorting Options to your preferences then click Apply Sorting.

  10. Review information and make necessary adjustments to the New PAR Level column.

    Column
    What to consider?
    Qty Sold
    High Sales? Consider increasing PAR.
    Sellthrough Rate
    High % = likely understocked
    Low % = possibly overstocked
    Ending On Hand
    Large leftover quantities? Lower PAR.


  11. Click Commit Changes to update PAR levels.

  12. Select Yes Refresh.

  13. Click Close to exit the worksheet.


Figure 1. The PAR Worksheet


Sellthrough % 
The percentage of the total inventory you sold during a certain period of time. In simple terms, it tells you how much of what you had available actually got sold. 
Formula: Sell-through % = (Units Sold ÷ Units Available) × 100

PAR
It’s the right amount you aim to keep in stock so you don’t run out or have too much. 

Reorder Point
Indicates how low inventory levels can go before you should reorder/restock.

Max Capacity
The maximum quantity a stand/store can hold. 



Editing Behavior
  1. When you change the PAR, the system automatically updates the Reorder Point.
  2. Editing the Reorder Point alone does not change PAR.


Create Separate "Template" PAR Worksheets for Special Events

For example:

  • Start of season
  • Mid-season adjustments
  • Holiday periods
  • Hot weather periods

Save these worksheets as templates for reuse.

Align PAR & Reorder Point

Since PAR updates reorder points automatically:

  • Keep reorder point = PAR for simple restocking behavior.


Include Restocking Size Only (Concessions)

Why? This is the size that you transfer items in to stands.



    • Related Articles

    • How do I create a new Transfer Worksheet?

      Transfer worksheets allow users with warehouse locations that transfer product to additional locations to easily create those transfers based on requests, or ad hoc. *As a note: Worksheets visibility is based on permissions, and if you cannot see ...

    • How do I create & use replenishment worksheets?

      The Replenishment Worksheet is a tool that utilizes a designated warehouse store to generate requests or transfers for multiple locations on a single screen. This tool uses algorithms to decide which store’s requests get priority fulfillment based on ...

    • How To: Create a Purchase Order Worksheet

      Purchase order worksheets let you create purchase orders for multiple stores and one vendor at the same time. This feature is useful for corporate buyers who place orders across locations. Permission to: access Purchase Order Worksheets (Optional) ...

    • Quick Reference: Worksheets

      Worksheets streamline purchasing and other critical inventory management tasks by reducing manual entry, improving planning accuracy, and supporting scalability as your company grows. Tip: Take time to review the worksheets available in Yellow Dog ...

    • How do I use the enhancements in Replenishment Worksheets?

      This video will demonstrate how to use the new replenishment features Replenishment Worksheet Enhancements We have introduced three Replenishment Worksheet enhancements. Exclude Items with No PARs Set Filter When creating a new Replenishment WS, this ...

    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...

    • Feature Overview: Par & Re-Order Points

      Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...

    • Tips & Tricks: How do I download and install drivers for my Zebra Printer?

      **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...

    • How To: Swap the On-Hand/Parent Size (Edit Base Unit)

      When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...

    • FAQs: What are Bins?

      Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...