Originally published: 16/12/2019 07:08
Last version published: 12/04/2020 16:54
Publication number: ELQ-20434-6
View all versions & Certificate
Last version published: 12/04/2020 16:54
Publication number: ELQ-20434-6
View all versions & Certificate
Price Volume Mix Analysis (PVM) excel template with Charts - Sales mix and Gross Profit by Product
Price volume mix analysis (PVM) excel template to better understand your sales and improve pricing strategy.
by Pierre-Alexandre HEURTEBIZEConsultant - M&A, Modelling and Financial analyst - Investment Manager at HoriZen CapitalFollow 29
Further information
Give a strong and automated tool to analyse revenue and gross profit change on a product by product level and efficiently understand the impact of the change in price, change in volume and change in mix on your top line and your gross profit.
A business with multiple products. Retail, marketplace, services companies.
If you are using a microsoft excel version older than 2016
Reviews
4.9 / 5 (17 votes)- 88%
- 12%
- -
- -
- -
Write a review
- Nice toolReally helps us understand where our growth is and improve our pricing strategy! Highly recommend
- Very helpfulI have been using it on a daily basis. Saves time and makes my life a lot easier. Very good value for money, will definitely recommend it.
- Real time saver!This tool became a staple in my daily workflow. A real time saver. Highly recommend it
- GreatAmazing analysis tool!
People using this Best Practice also downloaded
Price-Volume-Mix Analysis
Tools and methods to calculate and depict price-volume-mix effects and other variances486Discussadd_shopping_cart$45.00by Andrei Okhlopkov
Sales Mix, Menu Mix and Menu Engineering Spreadsheet
A series of sales mix worksheets that allows you to analyze menus based on a series of factors.6,4134add_shopping_cart$10.00by Chef David Buchanan
Black-Scholes Excel Pricing Model
A mini Black-Scholes Excel model, just hit and go!4,855Discussadd_shopping_cartfreeby Gia Hy Le Pham
Monadic Price Testing Excel Template
A tool designed to analyze peoples' purchase intention at different price points and for alternative products.1,362Discussadd_shopping_cartfreeby Alberto Scappini
More Best Practices from Pierre-Alexandre HEURTEBIZE
Multiple investing rounds Cap Table
Cap table for capital raise / buy in - by out and investor IRR and investment multiple forecast1,568Discussadd_shopping_cart$15.00by HEURTEBIZE
Multiple rounds Cap Table including Safe, pro-rata rights and Management Option Pool
Multiple rounds cap table including SAFE conversion, Management option pool and investment performance (IRR) 3 scenarios534Discussadd_shopping_cart$40.00Due Diligences Excel Template - P&L starter pack
Starter Pack Template for Financial Due Diligence - P&L790Discussadd_shopping_cart$35.00Inventory Management and Analysis best practice with dynamic charts
Inventory Management and Analysis best practice. Useful to the Management team as well as to external financial analyst.8281add_shopping_cart$39.00Discounted Cash Flow (DCF) and Comparables Valuation Model
Discounted Cash Flow analysis of your business and compare it to a valuation comparables.408Discussadd_shopping_cart$39.00DSO - DPO - DIO computation and graph - Countback method (Includes countforward method!)
DSO (Days Sales Outstanding)/ DPO (Days Payable Outstanding)/ DIO (Days Inventory Outstanding) charts countback method.859Discussadd_shopping_cart$35.00Due Diligence Excel Best Practice - Balance Sheet starter pack
Starter Pack Best Practice for Financial Due Diligence - Balance Sheet635Discussadd_shopping_cart$39.00Simple Startup and SME Forecast Business Plan
A projection Model for startup and SME to forecast a complete P&L, Net Working Capital and Cash flow.273Discussadd_shopping_cart$29.00Advanced multiple rounds Cap Table Model including SAFE an Management pool with 4 different structures
Multiple rounds cap table including SAFE conversion, Management option pool and performance (IRR) with 3 deal structures106Discussadd_shopping_cart$70.00P&L (Profit & Loss) Constant Currency Analysis Excel Model
Best practice to assess the impact of FX on a P&L for a business trading in different currencies9112add_shopping_cart$15.00SaaS P&L, revenue and churn analysis dashboard
Dashboard for SaaS and subscription businesses to track and understand their P&L and revenue generation154Discussadd_shopping_cart$35.00Scorecard - Scoring and Valuation Model
Scorecard / scoring model to help valuation, target assessment and visually see strengths and weaknesses of a business112Discussadd_shopping_cart$19.00
Discussion feed for Price Volume Mix Analysis (PVM) Excel Template With Charts - Sales Mix And Gross Profit By Product
The user community and author are here to help. Go ahead!
- Hi I was looking for simple solution for the company I work for. here they want constant GP but want to play around with the price and volume to decide the next step ( to increase the price or volume) with fixed GP. will this work on what you have explained?
- Hello Darshika,
Happy to help if i can. Could you provide more context and be more specific about what you mean by “fixed GP”? Gross profit being revenue less cost, I struggle to understant how your gross profit can stay fixed if you increase the price? Do you mean GP by product? Total GP?
Is the aim to have a model that would say “our costs are X per product. We want to achieve a total gross profit of Y. How many products do we need to sell if the product is priced at Z?”
- What is the best way to add additional products to this analysis?
- Hi David!
Given how I've built the model mostly using only direct links, this should not prove too complex to add new product.
First, I would insert the new rows below all the tables and chart sources throughout the tool.
Once this is done, you will simply need to drag down the existing formula and to include the new products in the chart. For the latter, clicking on one chart should allow you to see the source data area colored and you can just expand that area by dragging the right bottom corner of the coloured area.
Hope this helps!
