Spreadsheet: 850337d1700689509-help-with-forecasting-budget-vs-actuals-example
Sheet: Example

 | Example
 | Column1 | Column2 | Column3 | Column310 | Column311 | Column312 | Column313 | Column314 | Column315 | Column316 | Column317 | Column318 | Column319 | Column320 | Column321 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51 |  | TOTAL | TOTAL | TOTAL | TOTAL |  | Q1 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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] |  | BUDGET | VAR | % | ACTUAL |  | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL | BUDGET | VAR | % | ACTUAL
 | 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
 | 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
 |  |  |  | APRIL:ACTUAL | MAY:ACTUAL | JUNE:ACTUAL | JULY:ACTUAL | AUGUST:ACTUAL | SEPTEMBER:ACTUAL | OCTOBER:ACTUAL | NOVEMBER:BUDGET | DECEMBER:BUDGET | JANUARY:BUDGET | FEBRUARY:BUDGET | [NAME]:BUDGET
 |  |  |  | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 50 | 50 | 50 | 50 | 50