Distribution planning software in Excel for an apparel company (2007)

(23-12-2007)
For a Belgian company expanding its market into Eastern Europe, Russia and the Middle East, a multi-year multi-product calculation tool was developed within Excel. It will generate the network structure for each SKU (plant location, DC locations, market zones, ....) from master lists, and then allow to enter sales volume predictions and evolutions for the coming time periods. Reports include capacity requirements, flow volumes across network segments, ....The Excel interface provides instant accessability for the users. Program logic was developed in Visual Basic. The research was carried out by prof. Van Landeghem, Joris April and Kurt Decock.