Category: Variance Analysis

November 30, 2022
Price Volume Mix Variance Analysis in Power BI
Find out how to perform a Price Volume Mix Analysis in Power BI to see how price, volume and product mix changes affect your revenue.
October 19, 2022
Cost Variance Table in Excel (PY-AC-FC-PL)
Next-level visualization of different costs with three comparison measures in one table: the previous year (PY), forecast (FC), and plan (PL). Add dynamic comments for more insights.
October 19, 2022
Cost Variance Table in Excel (PY-AC-PL)
Display different costs with absolute and relative variance. Compare the actual (AC) value with the previous year (PY) and plan (PL) in the same table and add dynamic comments for more insights.
October 19, 2022
Cost Variance Table in Excel (PY-AC and AC-PL)
Show different costs compared to the previous year or plan. Use custom calculations or not, display dynamic comments, and visualize variances for more insights.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (PY-AC-FC-PL)
The most advanced template for monthly sales variance report featuring 3 comparisons in the same waterfall or column chart: previous year, forecast, and plan compared to the actual value.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (AC-FC-PL)
On one page you can compare the actual (AC) sales performance over months to the plan (PL) and forecast (FC) with Zebra BI Charts. Automatically calculated variances are also visualized together with dynamic comments for more insights.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (AC-PY-PL)
On one page you can compare the actual (AC) sales performance over months to the plan (PL) and previous year (PY) with Zebra BI Charts. Automatically calculated variances are also visualized together with dynamic comments for more insights.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (PY-AC and AC-PL)
This Excel template is a two-page report for sales monthly variances. You can compare the actual with the previous year on one page and with the plan on the other page. Trends over time are visualized with Zebra BI Charts for Office.
October 19, 2022
Sales Variance Table in Excel (PY-AC-FC-PL)
The most powerful template for checking the Market/Country's actual performance in a hierarchical table. You can add up to 3 comparisons at the same time (plan, previous year, and forecast) with automatically calculated variances and integrated dynamic comments.

Pagination