
Suggested Ordering: Sales Yield Worksheet
To change the parameters for individual items:
-
Click on the name of the sub-category that contains the inventory item(s) for which you want to change the controls, or click on the View Worksheet button to view all the inventory items.
-
In the window that pops-up:
-
Change the Adjust To% to adjust the theoretical case yield for each of the items, if required.
The default Adjust To % adjusts the theoretical case yield to equate it to the actual case yield (so essentially, the actual case yield is used by default). Changing the Adjust To % to zero will result in the theoretical case yield being used for the inventory item.
-
Enter the minimum decimal value at which the calculated figure will be rounded up (as the PO can contain only whole numbers) in Round Up At for each of the inventory items, as required.
To apply the same value to all the inventory items in the list, enter the figure in the Round Up At box that's located in the header of the table.
-
Enter the percentage of extra inventory you'd like to order (over that calculated as sufficient to meet the requirement until the next delivery) for each of the inventory items in Buffer %.
To apply the same value to all the inventory items in the list, enter the figure in the Buffer % box that's located in the header of the table.
-
Enter the percentage difference, between the case yield calculated for the present period and the case yield of the previous period, at which you want to be warned for each inventory item in Warning %*.
To apply the same value to all the inventory items in the list, enter the figure in the Warning %* box that's located in the header of the table.
-
Place a checkmark in the Ignore Warning %* column for an inventory item if you don't want to be warned of the difference in case yield since the last period for the item.
To ignore the warning for all the inventory items in the list, place a checkmark in the Ignore Warning %* box that's located in the header of the table.
-
Click on the Update Worksheet button.
-
Click on the OK button in the confirmation pop-up box.
-
Do not click on the Update button to save the custom settings. The Update button will override all custom settings with the item defaults.