Forecasting varying amounts over time

When creating any forecast entry, you have two options for entering your numbers:

  • Constant amount, which applies the same number to every month or year of your forecast
  • Varying amounts over time, which allows you to enter different numbers for each month of your forecast manually or to have certain months with no numbers at all

The example below shows you how to access these input types for a sample revenue entry, but the process is identical for direct costs, expenses, personnel, assets, or any other kind of forecast item:

varying amounts.gif

When do I use varying amounts over time?

The Varying amounts over time input is helpful in a number of different scenarios:

  • If the unit price of your product or service varies seasonally, Varying amounts over time allows you to set different unit prices for different months.
  • If you're adding personnel to your forecast and want to show seasonal fluctuations in the number of staff you'll be employing, Varying amounts over time allows you to enter a different number of employees each month. You can also use this method to show seasonal fluctuations in salary amounts.

In other words, the Varying amounts input can be used throughout the forecast, adding flexibility to your projections.

Applying a percentage of growth to varying amounts entries

When you've created an entry using varying amounts over time, you can apply a flat growth percentage to each month of the current year. Enter the percentage in the Change field, and click Apply:

varying amounts increase.gif

As shown above, the point-and-click chart and the numbers entered below will change as the percentage is applied to all months of the current year.

Note: The change field will not apply a growth rate to the forecast item. Changes will only apply to the currently selected year.

LivePlan Premium adds the ability to forecast a year-over-year percentage change instead of a number of units, hours, or revenue. The example below shows you how to access Varying amounts over time for a sample Unit Sales revenue entry, but the process is identical for most sections of your forecast:

annual change percent toggle.gif

Using the fill-right feature in forecast grids

Varying amounts over time entries provide a fill-right shortcut to save time when forecasting the same figures for multiple months. Each field in the grid has the fill-right option, except for the very last one.  

To use this feature, click on a field containing the value you want to copy. Next, hover over the three blue dots below that field and click the Apply button. The value from this field will be copied into all fields in the row. 

forecast fill right.gif

Click Save & Exit to save your changes:
save and exit detail.png

Was this article helpful?
26 out of 35 found this helpful