
Last version published: 27/06/2020 09:05
Publication number: ELQ-16605-5
View all versions & Certificate

Analyzing Sales and Product Performance
Tools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors
Further information
Analyse historic sales data, understand seasonality patterns, calculate price, volume and mix effect on revenue (profit) variations, develop proper forecasts
When a wide-scope analysis of sales is required
n/a
Reviews
4.7 / 5 (13 votes)- 85%
- 8%
- -
- 8%
- -
Write a review
People using this Best Practice also downloaded
More Best Practices from Andrei Okhlopkov
Unlocking Full Potential of Excel Data Tables (Part 2)
This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication1,045Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Profit Distribution and Carried Interest Waterfall
A template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall5882add_shopping_cart$30.00by Andrei Okhlopkov
Price-Volume-Mix Analysis
Tools and methods to calculate and depict price-volume-mix effects and other variances552Discussadd_shopping_cart$39.00by Andrei Okhlopkov
Inventory Analysis and Management
Inventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders257Discussadd_shopping_cart$20.00by Andrei Okhlopkov
Due Diligence Tools and Methods
A suite of best practices to perform financial and commercial due diligence375Discussadd_shopping_cart$100.00by Andrei Okhlopkov
Horizontal Waterfall Chart
A smart and efficient chart with detailed step-by-step instructions85Discussadd_shopping_cart$7.00by Andrei Okhlopkov
Cap Table with Investor Returns and Charts
Cap table with 5 investment rounds for up to 10 investors142Discussadd_shopping_cart$25.00by Andrei Okhlopkov
Controlling Outlook from Excel (full version)
Explains how to programmatically link Excel to Outlook178Discussadd_shopping_cart$15.00by Andrei Okhlopkov
Interim Budgeting (Reforecasting)
Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts263Discussadd_shopping_cart$20.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)314Discussadd_shopping_cart$20.00by Andrei Okhlopkov
VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface202Discussadd_shopping_cart$25.00by Andrei Okhlopkov
A Chart Showing Three Dimensions of Data
A professionally-designed chart which can show data in three measurements43Discussadd_shopping_cart$5.00by Andrei Okhlopkov
Any questions on Analyzing Sales And Product Performance?
The user community and author are here to help. Go ahead!