Recently we are engaged in a development project in a city where construction will need to stop during the snow months (generally from 1st Dec to 30th Apr). This presents a problem when I’m trying to spread the construction cost using the standard normal distribution function because there are dormant periods for construction. Would you have any advice how to deal with this specific situation?
My suggestion would be to detail out the construction draws. A slower method for sure, but then you’ll know the model is properly handling the winter downtime. To do this, change the ‘Forecast Method’ (column D of the Budget tab) to ‘Manual Input’ and then manually enter the draw schedule in the columns to the right. Make sure to unhide the Manual Input columns (columns K:BR).
