Forecasting methods can get complicated quickly. We have put together four popular forecasting methods with additional information on the Dynamic Budgets website. If you have a budgeting tool, you may incorporate one or more of these methods or use our FREE Excel-based tool that pulls data from Dynamics GP.
- Duplicate the original budget and make line item updates
- Create a blended row of YTD Actuals & update the remaining month values
- Create a blended row of YTD Actuals & Budget (or Prior Year or Annualized Values) and add adjustment rows
- Use a Standard 4-line calculation: (Forecast * % change) + $ Adjustment = Projection