Article ID: | iaor1996735 |
Country: | United States |
Volume: | 35 |
Start Page Number: | 58 |
End Page Number: | 62 |
Publication Date: | Sep 1994 |
Journal: | Production and Inventory Management Journal |
Authors: | Keaton Mark H. |
Keywords: | spreadsheets |
One must consult a table of the standard normal loss integral to determine the reorder point to meet a desired fraction of demand from stock when demand during lead time is stochastic but follows the normal distribution. The table gives the appropriate safety factor. In this article, a simple functional approximation which gives accurate values of the safety factor directly is described, eliminating the need for table lookups and interpolation. The approximation is naturally suited for spreadsheet applications.