S
StompS
Here's the dilemma:
I have a company that expands to a new city every X months. It takes 5
months for that city to reach full production (Y units). Each new city ramps
up to Y units with a given formula. At full production, that city's units
stays constant (Y). Every X months I need to add a new city that "ramps up"
over 5 months. How can I make a formula that, everytime I increase the
number of cities, it will ramp the city up to full procution over the 5
month period?
IE:
For Months 1-12, starting with 1 city and adding the 2nd at month 9:
Production = 0, 2, 4, 6, 8, 10 (city 1 has reached full production), 10,
10, 10 (city 2 is added but has no production the first month), 12, 14, 16,
18, 20 (city 2 has reached full production). There will be a chart with 50
cities that all ramp up the same way.
Any thoughts? Thanks in advance!
I have a company that expands to a new city every X months. It takes 5
months for that city to reach full production (Y units). Each new city ramps
up to Y units with a given formula. At full production, that city's units
stays constant (Y). Every X months I need to add a new city that "ramps up"
over 5 months. How can I make a formula that, everytime I increase the
number of cities, it will ramp the city up to full procution over the 5
month period?
IE:
For Months 1-12, starting with 1 city and adding the 2nd at month 9:
Production = 0, 2, 4, 6, 8, 10 (city 1 has reached full production), 10,
10, 10 (city 2 is added but has no production the first month), 12, 14, 16,
18, 20 (city 2 has reached full production). There will be a chart with 50
cities that all ramp up the same way.
Any thoughts? Thanks in advance!