We win large projects which run across several months. We're looking for help on how to forecast these projects by month across their lifetime.
As an example:
We win a contract with a chain of fast food restaurants for the supply of all their tables and chairs. The contract is estimated at £1m for 2021 but it is spread across 1300 restaurants throughout Europe. Each venue constitutes an individual quote to be won and delivered. The contract runs from 1 Jan to 31 Dec 2021.
Questions and challenges:
- From a forecasting point of view, is there a way to input... (More)