Abstract
This paper develops and tests a simple procedure for establishing stocking rules for a multi-component distribution center that supplies spare parts for an equipment maintenance operation. Our basic formulation seeks to minimize inventory investment subject to constraints on average service level and replenishment frequency. We simplify this formulation by classifying parts according to a new ABC methodology and applying heuristics to the classical (Q,r) model that lead to closed-form expressions for the stocking parameters. Our numerical results show that: (1) the proposed ABC scheme does not introduce large errors provided that it is done in a manner that reflects the key parameters in the model, and (2) any of a number of simple reorder point heuristics can provide the basis for an effective spreadsheet implementable system for controlling inventory in a complex multi-component environment as long as the service level is checked against the exact formula.
Similar content being viewed by others
References
Abramowitz, M. and I.A. Stegun. (1964). Handbook of Mathematical Functions with Formulas, Graphs, and Mathematical Tables. National Bureau of Standards Applied Mathematica Series. Vol. 55, pp. 932–933.
Cohen, M., P. Kamesam, P. Kleindorfer, H. Lee, and A. Tekerian. (1990). “IBM's Multi-Echelon Inventory System for Managing Service Logistics.” Interfaces 20, 65–82.
Cohen, M.,Y.S. Zheng, and V. Agrawal. (1997). “Service Parts Logistics:ABenchmark Analysis.” IIE Transactions 29, 627–639.
Federgruen, A. and Y.S. Zheng. (1992). “An Efficient Algorithm for Computing an Optimal (r; Q) Policy in Continuous Review Stochastic Inventory Systems.” Operations Research 40, 808–813.
Hadley, G. and T.M. Whitin. (1963). Analysis of Inventory Systems. Englewood Cliffs, NJ: Prentice-Hall.
Hopp, W., M. Spearman, and R. Zhang. (1997). “Easily Implementable (Q, r) Inventory Control Policies.” Operations Research 45, 327–340.
Nahmias, S. (1993). Production and Operations Analysis, 2nd Edn. Homewood, IL: Irwin.
Wilson, R.H. (1934). “A Scientific Routine for Stock Control.” Harvard Business Review XIII(1), 116–128.
Zheng, Y.S. (1992). “On Properties of Stochastic Inventory Systems.” Management Science 38, 87–103.
Zipkin, P. (1986). “Inventory Service-Level Measures: Convexity and Approximation.” Management Science 32, 975–981.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Zhang, R.Q., Hopp, W.J. & Supatgiat, C. Spreadsheet Implementable Inventory Control for a Distribution Center. Journal of Heuristics 7, 185–203 (2001). https://doi.org/10.1023/A:1009613921001
Issue Date:
DOI: https://doi.org/10.1023/A:1009613921001