For the RUTF supply chain, the dynamic modeling tool was developed in Excel. One of the requirements of the project was that no special software be used to create any of the tools that were an integral part of the project. UNICEF wanted the dynamic modeling tool to be available for multiple people to use after the project was complete, and this necessitated building the tool in a general purpose software application (like Excel) that was already widely used. The dynamic modeling tool developed for this project was built to accommodate a wide variety of inputs and assess performance across multiple measures, therefore a “what-if” tool was most appropriate.
The inputs that were included in the RUTF dynamic modeling tool were a list of supply chain nodes (demand locations, warehouse locations, and production locations), transportation parameters (time and cost for two transportation modes between each supply chain node), transportation choices, warehouse costs and capacity, production costs and capacity, production choices, demand levels, and funding levels.
The RUTF dynamic modeling tool measured supply chain performance (for each country/demand location and overall) based on total supply chain cost, landed cost (cost per MT of RUTF), average delay (time from when order was placed until RUTF arrived at demand location), and RUTF shortfall. A set of worksheets was used to map out the weekly flow of RUTF through the supply chain and measure the supply chain’s performance.
There are online videos to help you understand the structure of the model located in the videos section.