Safety Allowance Reset (ICR765)

Using Reports

Use this program to obtain a report of the current and recommended safety allowance per item. The optional update enables you to reset the current with the recommended quantities as displayed on the report.

The system contains a default safety allowance percentage (%), which is set in the IC Static Control F/M. Initially, it defaults to 50%. That safety allowance percent calculates the safety stock.

The safety stock is inventory that ideally is never sold but rather is stored as a precaution against running out of stock due to a variance in anticipated lead time or usage when replenishing the item. Each item’s safety stock amount is calculated from the safety allowance %. Many items may dip into the safety stock due to variances in lead times, etc. However, if safety stock is never used, it has a turn ratio of zero. The cost of stocking a 50% safety allowance may not be necessary on all items. Some items may never dip into the safety stock. Therefore, it may be cost effective to lower the safety allowance % on these items. Other items may dip into the safety stock more often, resulting in stockouts (no stock on hand). For these items, It may be cost effective to raise the safety allowance on these items.

The Safety Allowance Reset program enables you to recalculate the safety allowance % based on 12-month usage rates. If the item in the warehouse does not have usage rates for the last 12 periods, the program skips this item.

Report information includes:

  • warehouse

  • current order point

  • item class or vendor

  • reset order point

  • item number

  • current safety stock

  • item description

  • reset safety stock

  • movement class

  • maximum safety allowance dip

  • season code

  • restocking warehouse

  • current safety allowance

  • total number of items listed

  • reset safety allowance

 

Basic calculations are included in the report legend.

To access this program, choose Inventory Control-->Reports & Prints -->Safety Allowance Reset.

Use he following fields to print a Safety Allowance Reset Report:

1. Order

Enter whether to print in Vendor or Movement Class order. Press Enter (CR) to default to Vendor.

2. Beginning [Order Choice]

Enter the first vendor (or movement class) you want to see on your report. Press Enter (CR) or image\ex_allft_shg.gif to default to the FIRST vendor record on file or Movement Class 1. Press F2 or image\find_shg.gif to search.

3. Ending [Order Choice]

Enter the last vendor (or movement class) you want to see on your report. Press Enter (CR) to default to LAST vendor record on file or Movement Class 14. Press F2 or image\find_shg.gif to search.

4. Movement Class/Vendor

Enter the movement class or class to print. If movement class is the report order, enter the vendor to print. If vendor is the report order, enter the movement class to print. Press F1 or image\all_shg.gif to default to ALL.

5. Subsort By Movement Class/Vendor

If movement class is the report order, indicate whether to subsort by vendor? If vendor is the report order, indicate whether to subsort by movement class? Press Enter (CR) to default to selected.

6. Item Class

Enter the item class to print. The entry must be a valid class. Press F1 or image\all_shg.gif to default to ALL. Press F2 or image\find_shg.gif to search.

7. Item Description

Enter whether to print item description 1, 2, or Both from Item F/M. Press Enter (CR) to default to 1.

8. Warehouse

Enter up to twenty 2-character warehouse codes side by side to print. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F3 or image\all_shg.gif to default to ALL. Press F2 or image\find_shg.gif to search.

9. Dip Into Safety Stock Cutoff

Enter the maximum dip percentage into safety stock to print (0-99), i.e., if the dip % went above this % any time in the past 12 months, the item is not to print on the report; therefore, not eligible for a safety stock reset. Press Enter (CR) to default to 99.

10. Target Maximum Dip

Enter maximum dip % into safety stock allowable (0-99), i.e., if the system allows a dip of this % in a worst case scenario.

11. Safety Allowance - Minimum

Enter minimum safety allowance %, i.e., the lowest % of the item could be reset to (0-99). Press Enter (CR) to default to 50%.

12. Safety Allowance - Maximum

Enter maximum safety allowance %, i.e., the highest % the item could be reset to (0-99).

13. Include

Enter whether to print Usage and/or safety allowance Dip information. Press Enter (CR) to default to NONE.

14. Check the report. Do you wish to reset?

Upon completion of printing, the user has the option to replace current safety allowance % with reset safety allowance. Enter YES or N to indicate whether to update and reset.

See Also

Selecting existing templates

Creating system templates

Editing the order, range and properties stored in templates

Setting printer properties in templates

Using print options in reports

Setting a default printer using templates topics

Using print options

Using report templates

Viewing reports on screen (using the viewer)

Register formats and procedures

Reports and Prints Menu Options

Using Reports