Forecasts are being received on a monthly basis and you are asked to spread these...

When forecasts are spread into smaller time intervals using a spreading profile, the quantities are distributed according to the specified proportions in the profile. The graphic indicates that the profile points are 20, 20, 25, and 35 for each of the four weeks, respectively. To spread the monthly forecast of 500 units into weekly intervals, you multiply each proportion by the monthly forecast and divide by the sum of the profile points. So, (20/100) * 500 for the first two weeks, (25/100) * 500 for the third week, and (35/100) * 500 for the fourth week, which results in the weekly forecasts of 100, 100, 125, and 175, respectively.

ReferencesThe calculation uses basic arithmetic based on the principles of proportionally spreading a total quantity across a defined profile, as described in the Kinaxis RapidResponse demand planning documentation.