Suggested Ordering
Requirements:
Before you start using suggested ordering, there are a few things that need to be available and accurate in CLEARVIEW to ensure that this feature generates accurate figures:
-
Invoices entered into CLEARVIEW: The quantity of each supplier product received needs to entered as invoices after each delivery received.
-
Counts performed on regular basis: You need to perform physical counts for your inventory on a regular basis. CLEARVIEW recommends a minimum of a weekly full inventory count, and mini inventory (hot item) counts can be performed more regularly.
-
Accurate inventory reporting: The inventory reporting for your store needs to be accurate as suggested ordering calculates usage based on this data.
One way to know how accurate your inventory reporting is, is to check your variance report. The lesser the variance between the actual and theoretical count for each item, the more accurate is your reporting.
-
A financial/product mix forecast: A forecast for the period up to the next delivery date of the supplier will lend to the accuracy of the calculated build to's.
-
The sales yield worksheet set up: The sales yield worksheet is required to calculate the case yield for select or all supplier products (more information is available in the next section).
CLEARVIEW suggests that you should include at least the four last physical counts in the Sales Yield Worksheet. Four counts will provide sufficient data to iron out irregularities that may have occurred in a week.
CLEARVIEW recommends using suggested ordering only if the variance for the last four count periods (the recommended count period is one week) has been acceptable to you.