Want to ask some help about converting monthly forecast to weekly forecast.
Model itself is monthly, want to allocate the sales to # days in the month (weekday is too much calculation).
Ideally would have a peak around 20th but would set it aside for now.
Week end on Fridays won't align with month start / end so will use pro rata to distribute sales / cost etc.
But the bigger challenge is not know how to setup the model so monthly time series could accommodate weekly forecast.
Hey Hengjia,
Do you have an example of the month to week logic you'd like to apply to a module?
I can provide an example of how to create a weekly time series in the model, it does require an understanding of how to manipulate time series in Modano. Takes a bit of fiddling around.
Jun
Thank you in advance Jun.
Have existing model setup in monthly time series, the weekly is calculated on Mth to Wk tab attached.
Would totally like to know how to custom a rolling weekly time series.
Hi Hengjia,
Give this a go. I've only put in a weekly forecast time series to demonstrate getting a new time series period title set in.
I haven't included a rolling historical / forecast weekly series in there as it's an added layer of complexity.
I've just mocked up a conversion from months down to weeks based on your logic, hopefully it makes sense...
Jun
Thank you so much Jun.
Following your method I added daily just to test, working really well.
Also learn about the NETWORKDAYS formula from you, haven't used this before.
I tweaked the week to month index reference a bit so it now could sort of accommodate periods beyond 12 months.
No worries Hengjia. Nice one! I see what you've done with the indexing, oversight on my part, nice fix!
Anyway, glad it's helped you!
Jun