I'm building a sales forecast and my assumptions table has the following
Customer/Project Name
sales volume
unit price
project start date (Month)
Project Ramp Period (Our projects are ramped over a period of time, typically 3 months)
Project Duration
With this data I want to fill a sales projection worksheet that will show revenue by month - the trick I have is figuring our how to calculate the ramp and move it to the correct period. I can do this manually - but then it wont be dynamic if i change the project start date.
Example if we have a project with sales volume of 3000, unit price of $5, a start date of March, and a ramp period of 3 months - Id like it fill the projections sheet with $5,000 in Sales Revenue for March, $10,000 in April, $15,000 in May and every other month following for the duration
Thanks for any help
Bookmarks