Hi there,
I’m currently tackling a hierarchical reconciliation problem and encountering an issue that I believe might be quite common. We’re working with projects composed of individual tasks, which users work on daily, and we’re trying to forecast future workloads at the project, task, and user levels. This setup creates a hierarchy (user-task -> user/task -> project) that we are attempting to forecast.
For projects, tasks, and users that have been active for a significant period, we can forecast over longer horizons compared to newer entities. Our challenge arises when new users/tasks are introduced into an existing project for which we have already forecasted and reconciled data for a given horizon.
Is there a known heuristic or method to determine if the forecast horizon should be adjusted when new users/tasks are added to a project? Would love to hear thoughts from the community on this topic! Thank you.