The technique described here is called “exponential smoothing”. It is a simple method of updating an average as new data becomes available. It is the basis of most techniques used for forecasting customer demands. It was discussed briefly in the article entitled “Demand Rate Estimation”. In this article, it will be illustrated in relation to […]
Author Archive | Don Johnston
Some incorrect formulae were found in the simulation spreadsheet described in the article entitled “An Educational Inventory Management Simulator“. They have been fixed.
This article contains information concerning the mathematics involved in the spreadsheets which are described in Part 1. That article was revised on 5 March 2017 and the spreadsheets were revised on 19 February 2017. It is assumed that the readers of this article have some knowledge of statistical mathematics. Any row which is concerned with […]
Replenishment decisions rely on forecasts of lead times amongst other things. If the mean lead time for an item is not expected to change much then the average of recent lead times for the item can be used. Unless that item is purchased frequently, there won’t be many lead times to use for averaging purposes. […]
It is easy to reduce investment in inventory if you don’t mind a deterioration in customer service. Likewise, it is easy to provide good customer service if you don’t mind having a large investment in inventory. Good inventory management is concerned with having a low investment in inventory in relation to the customer service provided […]
I have developed an inventory simulation spreadsheet for educational purposes. It provides two facilities which are not provided by the online simulator which is accessed by means of the “Simulator” tab. The additional facilities are graphs and use of your own demand history. The online facility is more versatile than the spreadsheet. Also, it carries […]
This article contains detailed information concerning the online Monte Carlo inventory management simulator which can be accessed by clicking on the “Simulator” tab in the menu at the top of the page. In parts of this article, it will be assumed that the reader has some knowledge of statistics. If you don’t have a statistical […]
The Monte Carlo simulator is not working at present. It was working until I put it on this site. I am investigating the problem.
There is now an online Monte Carlo inventory management simulator available for use. Clicking on the “Simulator” tab in the menu at the top of the page will open the simulator in a new browser tab. Click here for instructions for using it. Each simulation is carried out for each day until there have been […]