A computer-aided inventory management system – part 2:
inventory level control
C.Y.D. Liu and Keith Ridgway Reviews inventory policies and lot-sizing techniques in a cutting tool manufacturer
In part 1 of this article the design and development of a computer-aided inventory management system (CAIMS) was described. The CAIMS system was developed for a cutting tool manufacturer, PRESTO Tools Ltd, Sheffield, with the objectives of reducing inventory investment and improving productivity, customer-service level and plant efficiency. The CAIMS system consists of four modules incorporating analytical techniques for ABC analysis, forecasting, economic batch quantity calculation and the statistical calculation of the re-order level respectively. In this second part of the article, various inventory policies and lot-sizing techniques are reviewed and the analytical techniques used in the economic batch quantity (EBQ) and re-order level (ROL) modules are described.
review. In this case, the replenishment order quantity is variable and brings the stock to a predetermined level (S ). In the (s,S ) policy is similar to the re-order cycle policy but a variable replenishment order is only placed when the stock falls below a predetermined level (s). In the combined re-order level and re-order cycle policy, replenishment orders are placed periodically and when the stock-on-hand falls below the re-order level. Replenishment orders placed when the re-order level is reached are of fixed size, but those placed at the review are variable. All of these systems are closely related in that a predetermined amount of stock, or period is set to trigger a fixed, or variable replenishment order. The key task is to determine accurately the parameters required to implement a successful inventory policy, i.e. the replenishment order quantity and the re-order level. The calculation of both the re-order level and replenishment order quantity is usually dealt with in isolation. Lewis suggested that for the optimum operation of a re-order level policy, these two quantities should be calculated jointly as one directly influences the other. Lewis recommended a method originally proposed by Tate. Tate’s formula has the advantage of being relatively insensitive to large variations in stockout costs. Lewis illustrated Tate’s formula with an example, and demonstrated that the re-order level evaluated using the joint calculation method was less than that calculated to achieve the same service level using the independent calculation method. The joint calculation method is complicated, and it is difficult to assess whether this additional computational effort is really providing an overall cost saving to the business. Several authors including Prichard, Brown, and Ploss and Wight, have described the use of statistical techniques to calculate the re-order level. This method has been adopted in the ROL module and will be discussed later. The authors wish to thank the staff of PRESTO Tools Ltd, Sheffield for their help during the course of the project.
Lewis identifies two basic type of inventory policy. The first, in which decisions concerning replenishment are based on the level of inventory held, is known as re-order level policy. The second based on a cycle time, is known as reorder cycle policy. Within these two categories there are several variants including the re-order level policy with periodic reviews, the (s,S) policy and the combined re-order level, and re-order cycle policy. In the re-order level policy, an order for replenishment is placed when the stock-on-hand equals or falls below a fixed value, known as the re-order level. When a replenishment order is placed, the quantity required is fixed. The amount of stock held must be reviewed continuously. In the re-order cycle policy, the stock-on-hand is reviewed periodically and a...