| 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.