Stock Level Assessment

Stock level assessment reports provide you with your current stock levels as well as the date by which you're expected to run out of stock.

There are two stock level assessment reports that can be generated:

Current Stock Level: Also known as theoretical on hand, it is the estimated current stock level of each item.
Stock Depletion Date: The date by which you're expected to run out of each inventory item.

These reports are based on the last physical count, sales, purchases, transfers and waste recorded since the last physical count.

Current Stock Level Report

TO GENERATE A CURRENT STOCK LEVEL REPORT:

Open the Stock Level Assessment page.
Select the Area*, Store and Supplier, for which you want to generate the report from the drop-down lists.
Select Current Stock Levels from the Mode drop-down list.
Select the Sub-Category if required.
If you want to view the stock levels for today (updated up to the last transmission from your POS), place a checkmark in the box next to Use Live Sales for current stock levels*.

If the Use Live Sales for current stock levels* option isn't available or is not turned on, the stock levels will be calculated as of the last end of day Completion of end of day tasks on the POS which results in EOD markers sent to Clearview..
Click on the Go button.

The following information is displayed on the page:

Sub-Category: The sub-category in which the inventory item falls.
Product Code: The product code of the supplier product An inventory item in a package size available from a particular supplier..
Product Description: The name of the supplier product An inventory item in a package size available from a particular supplier..
Pack size: Also referred to as Per Method #1 in Physical Counts, it is the size or quantity of the inventory item considered as one unit by the supplier (for example, large case, box, etc.).
Inventory Item Description: The name of the inventory item mapped to the supplier product An inventory item in a package size available from a particular supplier..
Current Stock Level: The estimated present stock level of the supplier product An inventory item in a package size available from a particular supplier./inventory item.

Report links:

Clicking on a Product Code in the report opens the Update Product Information page for the inventory item.
Clicking on an Inventory Item Description in the report opens the Inventory Item Information page for the inventory item.
Clicking on a Current Stock Level in the report displays the calculation of the current stock level for the inventory item.

Stock Depletion Date Report

The Stock Depletion Date provides you with two options based on which the calculation will be performed:

Default for Each Item: The forecasted case yield Used interchangably with sales yield, case yield is a comparison of the item usage to sales for the period. will be used for the calculation unless the Use Forecasted PLU Build To's is set to Yes on the Inventory Item Information page.
Forecast Sales/Case Yield: The forecasted case yield Used interchangably with sales yield, case yield is a comparison of the item usage to sales for the period. will be used for all inventory items regardless of what the Use Forecasted PLU Build To`s is set to on the Inventory Item Information page.

The theoretical usage calculations are used to calculate inventory item usage since the last physical count. For inventory items that are not tracked by the POS (for example, items that are not sold - like cleaning supplies) the usage is calculated based on historical usage trends and adjusted for the forecasted sales.

There are two prerequisites to generating a stock depletion date report:

First is the sales yield Used interchangably with case yield, sales yield is a comparison of the item usage to sales for the period. worksheet.

Click here to learn how to set up the sales yield Used interchangably with case yield, sales yield is a comparison of the item usage to sales for the period. worksheet.
Second is the product mix forecast created up to at least the Next Delivery Date.

Click here to learn how to generate a forecast.

TO GENERATE A STOCK DEPLETION DATE REPORT:

Open the Stock Level Assessment page.
Select the Area*, Store and Supplier, for which you want to generate the report from the drop-down lists.
Select Stock Depletion Date from the Mode drop-down list.
Select the Sub-Category and Products to Display from the drop-down lists if required.
Select the Order Date, Delivery Date and Next Delivery Date from the respective drop-down lists if required.

Selecting the dates will provide for a more accurate report.
If you want to include the current days theoretical usage The estimated usage of an inventory item based on menu item sales, recipes mapped to the menu items, sales assumptions and waste recorded. (updated up to the last transmission from your POS), place a checkmark in the box next to Use Live Sales for current stock levels*.

If the Use Live Sales for current stock levels* option isn't available or is not checked the stock levels will be calculated as of the last end of day Completion of end of day tasks on the POS which results in EOD markers sent to Clearview..
Select the Stock Depletion Calculation Method from the drop-down list.
Click on the Go button.

The following information is displayed on the page:

Sub-Category:The sub-category under which the inventory item is classified.
Product Code: The product code of the supplier product An inventory item in a package size available from a particular supplier..
Product Description:The name of the supplier product An inventory item in a package size available from a particular supplier..
Pack size: Also referred to as Per Method #1 in Physical Counts, it is the size or quantity of the inventory item considered as one unit by the supplier (for example, large case, box, etc.).
Inventory Item Description: The name of the inventory item mapped to the supplier product An inventory item in a package size available from a particular supplier..
Current Stock Level: The estimated present stock level of the supplier product An inventory item in a package size available from a particular supplier./inventory item.
Stock Depletion Date: The date on which you're expected to run out of stock of the inventory item.
For inventory items that aren't expected to run out by the last day for which forecasts have been created, the Stock Depletion Date column will either:
- Show the estimated stock level as of the Next Delivery Date, if the delivery dates are selected.
- Show the estimated stock level at the end of the last day of the forecast, if the delivery dates are not selected.

Associated Settings

Sales Yield Worksheet controls case yield Used interchangably with sales yield, case yield is a comparison of the item usage to sales for the period. settings.
Supplier Product controls each package size of inventory items as supplied by the vendor.
Supplier Product Bulk Update provides an easy method to quickly update the availability and pricing of multiple supplier products.
Suppliers controls vendor settings for all stores.
Inventory Items controls the set-up of individual inventory items.
Inventory Item by Location controls the inventory items for the store selected.

**not available indicates that the item has not been counted in past 45 days.

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.