At work we get awards over a year duration or so around 2M dollars. Sales start slow, ramp up, then descend. Some type of normal distribution. Sales are not just the average amount divided by the award. Is there some way I can setup a dollar value and period of performance to generate an estimated time phasing of sales for each month?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Estimating sales over duration of time
- Thread starter cegarbage
- Start date
Excel Facts
How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Similar threads
- Replies
- 0
- Views
- 503
- Replies
- 0
- Views
- 755
- Replies
- 0
- Views
- 225
- Replies
- 2
- Views
- 539
