EOQ, Order Point, Safety Stock Report

 

Function

Use this task to create a list of all inventory items showing the old EOQ, order point and safety stock amounts. The report displays the new EOQ, order point and safety stock quantities are calculated and updated to the Inventory Master File.

 

=> To access this task...

Select EOQ, Order Point, Safety Stock Report from the Period End Processing menu.

 

Inventory Item EOQ, Order Point, Safety Stock menu

EOQ, Order Point, Safety Stock Report

 

About the Fields

 

In the Beginning/Ending Warehouse field...

  • Enter the code of the first/last warehouse to include on the report.

  • Press [Tab] to select the first/last warehouse number record.

  • Click Click to select from a list of warehouse numbers.

In the Beginning/Ending Product Type field...

  • Enter the type of the first/last product to include on the report.

  • Press [Tab] to select the first/last product type record.

  • Click Click to select from a list of product types.

In the Beginning/Ending Item ID field...

  • Enter the number of the first/last item to include on the report.

  • Press [Tab] to select the first/last item number record.

  • Click Click to select from a list of item numbers.

In the Item Type field...

  • Enter the item type to include on the report.

  • Press [Tab] to select all item types.

  • Click Click to select from a list of item types.

When done making selections...

  • Click Run Process button to create the EOQ, Order Point, Safety Stock Report.

  • Click Clear Form button to clear the form and re-enter options.

EOQ, Order Point, Safety Stock Report output

Sample EOQ, Order Point, Safety Stock Report

 

See Output Options.

 

When closing or saving the preview report, the system displays the prompt:


Update Quantities selection


The EOQ is the optimum quantity to be ordered each time you place an order. It is determined based on the fixed costs of setting up or placing and receiving an order, annual sales in units, carrying costs, and per unit purchase price.

 

Order Point Quantities calculates the level of inventory at which a new order should be placed based upon average sales and lead time. Order point is defined as the demand during lead time plus safety stock.

 

Safety Stock Quantities calculates the amount of additional inventory that should be carried to hedge against variations in demand during lead time. Safety stock is determined as 50% of usage during lead time.

 

When done making selections...

  • Click Run Process button to update the quantities.

  • Click Clear Form button to clear the form and re-enter options.



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.