You
give the simulator three inputs and the simulator will tell you
whether FILLRATE100 can help you improve or not.
Provide an initial and a final position of stocks for a set of
SKUs in a location, and the simulator will calculate the final stock
that FILLRATE100 would have produced, comparing both availability and
investment.
Input
consumption (or sales)
Prepare a XLS spreadsheet and import the data, with this
structure:
DATE | SKU | LOCATION | CONSUMPTION
WARNING
Do not use sales of a period with promotions or seasonality, because FILLRATE100 will help automate decisions by dealing with uncertainty, however, known events provide elements to modify inventories in aggregate, which cannot be simulated.
Input
stocks: at the date of first consumption and at the date of last
consumption
Prepare a XLS spreadsheet and import the data, with this
structure:
SKU | LOCATION | ACTUAL INITIAL STOCK | ACTUAL ENDING STOCK
Actual ending stock is the stock you had just after the period for which you're providing consumption (sales), ad the comparison will be between this and what the simulator calculates as if your decisions would have been made with FILLRATE100.
Stocks are compared by quantity of units whereas investment is what we want to reduce. This version does not ask for the unit cost and uses quantities as a proxy. Next version will include cost to calculate variation of investment.
Set
parameters for the location:
Order Lead Time: this is the time between one order and the
next. It might be that you are not familiar with this concept because
replenishment orders are triggered by a Re-Order Point (ROP) in your
operation. To run the simulation, set this parameter to 1 day for
stores and minor warehouses; and 7 for Distribution Centers.
Supply Lead Time: this is the time between placing and
order and receiving the goods.
Calculate
the Global Results and see the comparison between your actual end
result (final stock) and the simulated end result.
Sample files to test the simulator:
Consumption history:
Initial stock: