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

 |  | Date | Product | Type | [NAME] | Actual sales | Var | %
 |  | 2023-04-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 1 | Setup | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 1 | Monthly | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 2 | Setup | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 2 | Monthly | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 3 | Setup | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 3 | Monthly | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 4 | Setup | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 4 | Monthly | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-04-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-05-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-06-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-07-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-08-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-09-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-10-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-11-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2023-12-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2024-01-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2024-02-01 00:00:00 | Product 5 | Monthly | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 5 | Setup | 5 | 10
 |  | 2024-03-01 00:00:00 | Product 5 | Monthly | 5 | 10