No insight with excel
As a demand & supply planner, De Jong works within a small team that is responsible for forecasting, purchasing and stock management of a total of 1,600 finished and semi-finished product lines. For a long time, they only had excel to manage the inventory. However, as the assortment grew, it became more and more difficult to keep the inventory in check.
“With excel, it was difficult for us to spot trends because we could only look back on 12 months of demand. We also had little control over seasonal patterns and demand outliers. The forecast was not adjustable so one-off peaks could not be ruled out. As a result, it took me a lot of time each week to prepare the right orders. You cannot factor in service levels in Excel. As a result, we often had too much safety stock for one product and not enough for another”, highlights De Jong.