weekly

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.

A number of people have raised the following through support, so I thought it was worth documenting in the forum.

When using the Weekly Historical-Forecast content and importing directly from accounting packages, there is a disconnect between the historical income statement data and historical balance sheet data, due to the way accounting packages provide the balance sheet data.

Using a simple example of $100 income for four weeks, when running the import assumptions tool at the end of the month, the following pattern of data is brought in: