Revenue Variance Analysis | Price,

Revenue Variance Analysis | Price, Volume & Mix (PVM)

Developed an Excel-based revenue variance analysis model for a fictional FMCG business to identify the underlying drivers of budget versus actual sales performance.

The analysis separates revenue movements into price, volume and product mix impacts, providing greater visibility into commercial performance.

Key features:

Price, Volume & Mix variance calculations

Budget versus actual revenue reconciliation

Interactive customer and category analysis

Variance bridge visualisation

Identification of key revenue performance drivers

Business value: Helps commercial and finance teams understand why revenue changes, identify pricing and volume opportunities, and support more informed business decisions.

Independent portfolio demonstration using fictional data. Part of the Northstar Consumer Products financial analysis project.