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 Levels.
    • Users without the Device and Location Management Role will be able to see all Par Levels that are tied to their assigned locations. They will not be able to add, edit, or delete: only view, their location's Par Levels.
  • 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.
  • 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 record changes will be captured in the audit log report.

Viewing Par Levels in Stratosphere

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, as well as those who have an assigned location that is tied to a Par Level.

This page will contain a table of all the Par Levels that a user is authorized to view.

  • Users with the device and location management role will see all Par Levels
  • Users without this role will only see the Par Levels for locations to which they are assigned.

Details

To view a Par Levels details, click the name of the Par Level. In the details page you will 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 reorder quantities.
  • Product* - The total number of items read by the last device to use this Par Level. Includes a link to the detailed inventory report where you can see the item-specific information of the inventory "in" the Par 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 "Ready for Reorder". If the Min value = Max Value (for 1:1 reordering, the product will only show as "Ready to Reorder" 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 or 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, your are warned to reorder 1 item to get back up to 13. This practice is often called one-to-one reordering, and keeps inventory lean, but may reuslt 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 "Ready to Reorder" but recommend resupplying 10 units, to get back to the Max of 23,r ather 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.

Viewing the Par Levels Report

The Par Levels Report defaults to displaying rows with a status of "Out of Stock", "Ready to Reorder", 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 int he 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 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.
  • Reorder - 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 "Ready to Reorder".
    • Ready to Reorder - 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.

Adding Par Levels

Adding Par Levels requires the "Device and Location Management" role to be granted in your user record. Contact your system administrator to add this capability.

To add a Par Level:

  1. Select "Add Par Level" in the top left of the Par Levels page.
  2. Enter a Par Level Name. The name must be unique from other Par Level names, to avoid confusion.
  3. 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.
  4. 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.
    1. For each product, set a Min and Max quantity. The Max value must be greater than, or equal to (if 1:1 reordering is desired), the Min value . Stratosphere will continuously evaluate current inventory levels at all assigned locations against this min and max, and calculate suggested reorder quantities.
  5. Click Save to finish adding the Par Level. The Par Level will now appear in the Par Levels table.

Editing Par Levels

Editing Par Levels 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.

Option 1

  1. On the Par Levels page, open the quick action menu for the Par Level you wish to edit and select "Edit".

  2. In the Edit Par Level window that opens, make any desired changes.
  3. 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.

Option 2

  1. On the Par Levels page, click the Par Level name link

  2. In the Par Level details page, make any desired changes.
  3. Click "Save Changes" to save the edited record. To cancel your edits, simply leave the device details page without saving.

Deleting Par Levels

Deleting Par Levels 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 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.

Option 1

  1. On the Par Levels page, open the quick action menu for the Par Level you wish to delete and select "delete"

  2. In the "Delete Par Level" confirmation window that appears, click "Delete" to confirm the deletion of the Par Level. This cannot be undone. Clicking "Cancel" or the X in the top right of the window will not delete the Par Level.

Option 2

  1. On the Par Levels page, click the Par Level name link for the device you wish to delete.

  2. On the Par Level Details page that opens, scroll to the bottom of the page and click "Delete".
  3. In the "Delete Par Level" confirmation window that appears, click "Delete" to confirm the deletion of the Par Level. This cannot be undone. Clicking "Cancel" or the X in the top right of the window will not delete the Par Level.

Enabling Par Levels

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:

  1. Go to the organization page
  2. Select the "Add/Remove Features" tab

  3. Toggle the "Par Levels" feature on
  4. Press "Save Changes"

Disabling Par Levels

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:

  1. Go to the organization page
  2. Select the "Add/Remove Features" tab

  3. Toggle the "Par Levels" feature off

  4. Press "Save Changes"
  5. Confirm your intention to disable by pressing "Save Changes" in the resulting popup.