Background - I am creating a 3 year revenue forecast for a product that is to be launched. The forecast starts with the raw number of customers in each market, and then applies cuts based on assumptions as you move down the model, finally ending with revenue and volume as the output.
Problem - Each market has different launch dates, that may change. As such when we roll out this forecast, to each country team, it would be good if they could select the month and year when they launch, and then the forecast adapt accordingly.
Ideal Solution - I have a drop down list for month and year. if for example, the user selected launch date for March 2021, the following would happen:
1. The customer numbers in 2020 are multiplied by 0 as the product has not launched in this year. Equally the raw customer numbers in 2022 and 2023 are unchanged
2. The customer numbers in 2021 are multiplied by 9/12, as the product launched in March and thus there are 9 months left of the year where they can sell to customers
3. Only the year 2021 is affected
Is this possible?
Problem - Each market has different launch dates, that may change. As such when we roll out this forecast, to each country team, it would be good if they could select the month and year when they launch, and then the forecast adapt accordingly.
Ideal Solution - I have a drop down list for month and year. if for example, the user selected launch date for March 2021, the following would happen:
1. The customer numbers in 2020 are multiplied by 0 as the product has not launched in this year. Equally the raw customer numbers in 2022 and 2023 are unchanged
2. The customer numbers in 2021 are multiplied by 9/12, as the product launched in March and thus there are 9 months left of the year where they can sell to customers
3. Only the year 2021 is affected
Is this possible?
