Hello everyone, here is my problem:
I am looking for a formula that will automatically determine when to apply a ramp-up period for new programs. This formula also has to have the ability to know how much dollar amount to spread over the remaining full production months so annual figures will still match up. So say I have a new program launching un July, my formula I have in place will already determine from an annual #, to divide that number by 6 to get an average volume per month figure. However, I want my formula to take the first three months and apply a run-up. So say for those 6 months im averaging 1,000 units for the remainder of the year. I want the first month to have 1,000*.25, second month 1,000*.5 and third month 1,000*.85. However, as stated above, I cant lose volume anywhere because my annual # would then be off, so for the remaining three months of full production, I need those months to be 1,000*1.46667 to account for the lost 75%,50% and 15% from the first three months. I have attached a spread sheet with a small sample of what I am trying to accomplish.
Thank you all for any help/suggestions!
Bookmarks