Spreadsheet: 850310d1700672062-help-with-forecasting-budget-vs-actuals-example-felix
Sheet: Example

 | Example
 |  |  |  | APRIL | APRIL | APRIL | APRIL | MAY | MAY | MAY | MAY | [NAME] | [NAME] | [NAME] | [NAME] | JULY | JULY | JULY | JULY | AUGUST | AUGUST | AUGUST | AUGUST | SEPTEMBER | SEPTEMBER | SEPTEMBER | SEPTEMBER | OCTOBER | OCTOBER | OCTOBER | OCTOBER | NOVEMBER | NOVEMBER | NOVEMBER | NOVEMBER | DECEMBER | DECEMBER | DECEMBER | DECEMBER | JANUARY | JANUARY | JANUARY | JANUARY | FEBRUARY | FEBRUARY | FEBRUARY | FEBRUARY | [NAME] | [NAME] | [NAME] | [NAME] |  | TOTAL | TOTAL | TOTAL | TOTAL |  | Q1 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q4
 | INCOME | TYPE | TREND | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL |  | BUDGET | VAR | % | ACTUAL |  | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL
 | Product 1 | TOTAL
 | Product 1 | Setup |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 1 | Monthly |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 2 | TOTAL
 | Product 2 | Setup |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 2 | Monthly |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 3 | TOTAL
 | Product 3 | Setup |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 3 | Monthly |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 4 | TOTAL
 | Product 4 | Setup |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 4 | Monthly |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 5 | TOTAL
 | Product 5 | Setup |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | Product 5 | Miscellaneous |  | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10 | 5 |  |  | 10
 | TOTAL INCOME
 |  |  | MoM
 |  |  |  | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME]
 |  |  |  | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | BUDGET | BUDGET | BUDGET | BUDGET
 |  |  | TOTAL INCOME