Macro help to calculate run-up period for balance sheet using a logic nesting IF formula

Hello everyone, here is my problem:

I am looking for a macro that will automatically determine when to apply a ramp-up period for new programs. This macro 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. I have attached a spread sheet with a small sample of what I am trying to accomplish.

Thank you all for any help/suggestions!Monthly Sales-6-28-2013 FORM USE.xlsx