Vizlib Home Try Vizlib

Line Chart - Scenario Analysis Forecasting

In the Scenario Analysis option of Line Charts, the percent entered is a compounded value (in that if you enter 10, for example, each month of the forward forecast increases by 10% over the previous months total).  What we need is the ability to say that I want to END with a 10% increase based on the average for the training period.  

An example scenario:  I know that we will be increasing production by 10% over the course of the next 6 months.  So if we started with 1000, at the end of 6 months, we are at 1,100.  In this way, I can get an idea of how much to increase my staffing each month.  

Relatedly, it would be great if I can choose how I want that increase to show - evenly (by the same amount each month) or in a curved fashion where the ramp up increases exponentially or in a bell curve fashion where I anticipate having a spike exceeding the target 10% which then levels off so that at the end of the forecast period, it is a 10% increase from the starting point.


Login to post a comment