Par Levels
With the Par Levels feature enabled for your organization, Stratosphere will continuously compare the existing stock of products at all locations against your specified minimum and maximum stocking levels and report the status in an easy-to-use dashboard widget and report. Now you can prevent and identify overstocks or stock outs at a glance.
Specifically, when the Par Levels feature is enabled, the following will occur in your Stratosphere organization:
- The Par Levels page will become available in the main menu on the left sidebar:
- Users with the Device and Location Management Role will be able to add, edit, and delete Par Level Groups.
- Users without the Device and Location Management Role will be able to see all Par Level Groups that are tied to their assigned locations. They will be able to view their location's Par Level Groups, but they will not be able to add, edit, or delete Par Level Groupss.
- Users who have either the Device and Location management Role OR are assigned to a location that has Par Levels set will now have access to:
- The Product Par Levels widget on the Dashboard (See Viewing the Par Levels Report section of this page below for a description of each Status)
- The Par Levels report, which can be accessed via the dashboard or from the reports menu, will become available.
- The Location Details page will now have a "Par Level assigned to this location" field, which will link to the Par Level record, if one is assigned.
- Par Level Group record changes will be captured in the Audit Log report.
Par Levels includes an optional sub-feature called 1:1 Par Levels, which replaces the minimum and maximum par level for each product with a single par level. For more information, see the 1:1 Par Levels page.
If the Par Level feature is enabled at the Organization level, Par Levels will appear in the menu for all users with the Device and Location Management role.
This page will contain a table of all the Par Levels for the organization.
To view a Par Level's details, click the name of the Par Level. In the details page you will see all the available information for that Par Level, including:
- Par Level Name* - The unique name of the Par Level.
- Assigned Locations - The Stratosphere locations that will use this par level to evaluate their restock quantities.
- Product* - The Product Name and Product # for which you are setting the Mn and Max stocking level.
- Min - The minimum quantity of this product that should ever be stocked at a single assigned location. If current stock is at or below the min value, the product will be marked "Below Min". If the Min value = Max Value, the product will only show as "Below Min" when current quantity goes below Min.
- Max - The maximum quantity of this product that should ever be stocked at a single assigned location. If current stock is above Max, the product will show as "Overstocked". If current stock = the Max value, the product will show as "Fully Stocked." For more detailed description of each status, see the "Par Levels Dashboard Widget and Report" section below.
* = Required
How do I know what to set as Min and Max?
Setting an appropriate Min and Max value is an art and a science. It is a science because a quick google search will yield dozens of formulas for calculating appropriate min and max levels. It is an art because no min and max value will ever perfectly prevent stockouts or overstocking, since usage can depend on the time of year, the economy, and many other factors that are even more difficult to quantify. It is up to you to decide whether you are more willing to risk a stockout or high levels of inventory, depending on your business model.
If you are looking for a quick and dirty formula here it is:
(weekly inventory use + Safety stock) / Deliveries per week = your Minimum Par Level.
"Safety stock" should be at least 10% of weekly inventory use, but higher percentages will increase your service level and reduce the risk of stockouts. Be warned that aiming to achieve a 0% chance of stockouts is a statistically impossible goal, so it is up to your organization to determine what percentage risk of a stock out is acceptable and carry the appropriate corresponding safety stock.
Examples: You want to use ground shipping to save money, so you plan to only send a single shipment every week. In the average week, an account typically uses 10 of a particularly product. By adding 30% to 10, you determine you should keep 13 units in stock at any given time. Even with that number in hand, there are still decisions you need to make regarding how lean you want to run your supply chain.
- Lean: You could set your Min and Max for that product to 13, so as soon as it falls below, you are warned to restock 1 item to get back up to 13. This practice is often called one-to-one restocking, and keeps inventory lean, but may result in higher processing and shipping costs due to higher frequency of resupply.
- Resilient: Alternatively, you could set your Min to 13 but set your Max to 23. That way when your current inventory is 13 units, Stratosphere will list this product as "Below Min" but recommend resupplying 10 units, to get back to the Max of 23, rather than just 1. This results in a greater volume of inventory at the location, but potentially lower processing and shipping costs, along with a lower risk of stockouts in periods of unusual demand, or supply disruption.
The Par Levels Report defaults to displaying rows with a status of "Out of Stock", "Below Min, and "In Stock", although any combination of status filters can be selected. Like all reports: the columns are searchable, sortable, and exportable.
The Par Levels report will display a row for each unique product at each location that has a par level assigned. If a location has no par level assigned, none of the products at that location will display on this report. If a location has a par level set, all products, even those that do not have min or max set in the par level, will display on this report. So for example, if "product A" enters a locations inventory, and that location's par level does not include the product, the product will display on this report as "Overstocked". In this case, we recommend either adding the product to the location's par level with appropriate min and max values, or finding and physically removing the product from that location's inventory.
The Par Levels Report contains the following columns:
- Location Name - The name of the location where the par level controlled product is stocked.
- Product # - The # or code of the product.
- Product Name - The name of the product.
- Min- The minimum quantity of the product that should be stocked at this location.
- Max - The maximum quantity of the product that should be stocked at this location.
- Current - The current quantity of the product that is in inventory at this location.
- Restock Quantity - The quantity of product that should be restocked in order to make the current inventory reach Max par.
- Status - A quick visual and conversational indicator of the current state of product inventory at the location, relative to par.
- Out of Stock - There are currently 0 of this product at this location. Restock ASAP. Avoid this status by restocking while status is "Below Min".
- Below Min - There are currently 1 or more products at this location, but the current inventory is below Min. Restock soon, but not urgently.
- In Stock - The current stock of product at this location is somewhere between Min and Max. Use your best judgment to determine whether to restock now, or wait until levels are at or below Min.
- Fully Stocked - The current stock of product matches Max exactly. Consider implementing the Slow Moving Inventory report to verify that the reason your products are fully stocked is thanks to timely resupply, not due to a persistent lack of demand.
- Overstocked - The current stock of product is above the Max set for that product at that location. Consider moving this inventory to a different location, or if this high level is justified, increase the Max Par Level for that product at that location.
When the Product Catalog Additional Fields feature is enabled, the Par Levels Report will update to include the Product System and Product Category columns.
Adding Par Level Groups requires the "Device and Location Management" role to be granted in your user record. Contact your system administrator to add this capability.
Par Level Groups can be added to Stratosphere manually via the web interface and through .csv imports.
- Select "Add Par Level Group" in the top left of the Par Levels page.
- Enter a Par Level Group Name. The name must be unique from other Par Level Group names.
- Select Assigned Locations from a list of all Stratosphere locations. Any location listed will have their current inventory evaluated against the min and max values in this par level, and the results will be visible on the dashboard widget and report for all users assigned to those locations.
- Select at least one Product, from a searchable, browsable list of all products. Once a product is selected, another row will appear for selection of additional products. There is no limit to the number of products you can assign min and max values to.
- For each product, set a Min and Max quantity. The Max value must be greater than or equal to the Min value. Both Min and Mix must be greater than 0. Stratosphere will continuously evaluate current inventory levels at all assigned locations against this min and max, and calculate suggested restock quantities.
- Click Save to finish adding the Par Level Group. The Par Level Group will now appear in the Par Levels table.
There is no way to undo a csv import, other than to edit or remove par level groups from Stratosphere individually. When bulk importing, verify the accuracy of the import. Double-check to ensure that the data in the uploaded file is accurate. After importing the file, but before saving the imported records, open the "Ready to Import" section and verify that the columns are mapped appropriately and the data is exactly as you want it.
- Select "Import Par Level Groups" at the top of the Par Levels page.
- Enter a name for your par level group in the Par Level Group Name field. This name must be unique from outher Par Level Group Names. This field is required.
- Select one or more assigned locations for the par level group. This field is optional.
- "Choose File" and select your import file. The file must meet the following requirements:
- .CSV file format
- Less than 1 MB file size
- Contain columns titled "Product Name", "Product #", "Min", and "Max".
- Product Name - The name of the product from your product catalog. This field is required.
- Product # - The code of the product from your product catalog. This field is required.
- Min - The minimum stocking level for this product in the selected location(s). This field is required. Min must be less than or equal to Max.
- Max - The maximum stocking level for this product in the selected location(s). This field is required. Max must be greater than or equal to Min.
- Once a file is chosen, select "Import Par Level Group". If your list of rows is large, it may take a minute to import.
- Before saving the import, validate that the import was completed as expected by reviewing the following lists:
- Ready to Import - These rows were successfully read from the file.
- Errors - These rows were not successfully read from the file. Where possible, the reason for the error will be explained in this list. Potential reasons include:
- Duplicate Rows
- Invalid Product Name, Product #, Min, or Max
- Invalid columns included in the import file
- Missing required fields
- If you are happy with your import preview, click "Import Par Level Group" one last time to create a Par Level Group using the "Ready to Import" rows.
The import must be validated within 20 minutes, otherwise you will need to restart the import process again.
You can review the last 10 Par Level Group Imports, including the list of rows that had Errors, by clicking "Import Par Level Groups" from the top of the Par Levels page at any time.
Here is an example CSV used for a Par Level Group import in Stratosphere:
Often, the majority of your locations are bound to follow a baseline stocking plan. You can simplify the assignment of par levels as you add new locations bys electing a particular par level to assign to all new locations you create in Stratosphere. You can always change the par level group for a particular location at any time.
- Select the dropdown at the top of the Par Levels page.
- Select which of your Par Level Groups you would like all new locations to follow as their default.
- Your selection will be automatically saved.
Editing Par Level Groups requires the "Device and Location Management" Role to be granted in your user record. Contact your system administrator to add this capability.
There are two options for editing an Par Level.
- On the Par Levels page, open the quick action menu for the Par Level Group you wish to edit and select "Edit".
- In the Edit Par Level Group window that opens, make any desired changes.
- Click "Save Changes" to save the edited record. Clicking "Cancel" or the X in the top right of the window will remove any edits you just made but had not yet saved.
- On the Par Levels page, click the Par Level Group name link
- In the Par Level Group details page, make any desired changes.
- Click "Save Changes" to save the edited record. To cancel your edits, simply leave the device details page without saving.
Deleting Par Level Groups requires the "Device and Location Management" Role to be granted in your user record. Contact your system administrator to add this capability.
Deleting a Par Level Group will immediately remove the Par Level from Stratosphere and from the Par Level widget and report. There are two options for deleting a Par Level.
- On the Par Levels page, open the quick action menu for the Par Level Group you wish to delete and select "delete"
- In the "Delete Par Level Group" confirmation window that appears, click "Delete" to confirm the deletion of the Par Level Group. This cannot be undone. Clicking "Cancel" or the X in the top right of the window will not delete the Par Level Group.
- On the Par Levels page, click the Par Level Group name link for the device you wish to delete.
- On the Par Level Group Details page that opens, scroll to the bottom of the page and click "Delete".
- In the "Delete Par Level" confirmation window that appears, click "Delete" to confirm the deletion of the Par Level Group. This cannot be undone. Clicking "Cancel" or the X in the top right of the window will not delete the Par Level Group.
Enabling Par Levels requires the "Organization Management" role to be granted in your user record. Contact your system administrator to add this capability.
To enable Par Levels for your organization:
- Go to the organization page
- Select the "Add/Remove Features" tab
- Toggle the "Par Levels" feature on
- Press "Save Changes"
Disabling Par Levels requires the "Organization Management" role to be granted in your user record. Contact your system administrator to add this capability.
Disabling Par Levels will instantly hide all Par Level screens and data.
To disable the Par Levels feature:
- Go to the organization page
- Select the "Add/Remove Features" tab
- Toggle the "Par Levels" feature off
- Press "Save Changes"
- Confirm your intention to disable by pressing "Save Changes" in the resulting popup.