Data Processing

Stacked Time Charts: The stacked time charts were also used to indicate the range and variability in time for supply chain steps in the target countries. Findings from these graphs were used to identify key areas of variability in the supply chain, which helped inform the development of recommendations for supply chain improvement.

Bar Charts: Bar charts were used to demonstrate trends in data over time–for example, changes in UNICEF’s demand for RUTF and Nutriset’s capacity to produce RUTF over time. This was used to determine if and when demand for RUTF might exceed capacity. Bar charts were also used to show UNICEF’s total order volumes placed for RUTF for specific months determine if certain months consistently experience spikes in order volume.

Pie Charts: Pie charts were used to determine what proportion of the total cost of RUTF is comprised of the shipping cost. This was a useful visual tool for assessing the differences between sea freight and air freight’s effect on the cost of RUTF. Pie charts were also used to determine what proportion of UNICEF’s demand for RUTF is sourced from Nutriset.

Scatter Plots: Scatter plots were used to determine if RUTF order weight had any effect on transportation time. Scatter plots were also used to quickly understand and determine relationships between data, but ultimately the plots were replaced with more specific data processing charts.

Line Graphs: Line graphs were used to plot production lead time against the date the order was placed. This was then overlaid with the above-mentioned bar chart showing order volume, to determine if increases in order volume resulted in an increase in production lead time. Line graphs were plotted for production lead time for each individual country as well as for all UNICEF orders worldwide. Line graphs were also used to look at Nutriset’s total capacity for producing RUTF as well as the demand Nutriset experiences for RUTF from all of its customers.