Contact us

DAT-021 · Reporting

Sales mix analysis

We decompose a change in revenue into volume, price and mix across up to 30 products.

Illustrative preview of Sales mix analysis workbook
Illustrative preview Product or group, Revenue driver, Explained movement.
What you receive
Sales mix analysis workbook
Delivery estimate
3–7 working days
Delivery arrangement
Remote delivery

Why work with SPARKLE?

Make the numbers checkable

Use the decomposition to see which drivers contributed and which require a closer commercial review.

Sales mix analysis workbook

We decompose a change in revenue into volume, price and mix across up to 30 products.

A result you can review

In the Sales mix analysis workbook, follow “Product or group”, “Revenue driver” and “Explained movement” to check the handover against your original question.

When this service helps

Revenue can rise while volume falls if selling prices or the mix of products changes. The service is intended for SME managers and reporting teams. Use the decomposition to see which drivers contributed and which require a closer commercial review. It is useful when your team can identify the decision the work needs to support and name someone to review what comes back.

What to prepare

Historical data, comparison periods and the business question. Before work starts, explain how the result will be used, which inputs are already approved and whether access or material must come from someone else. Flag gaps in the current information early so they can be handled within the scope or recorded for follow-up.

How we deliver it

Reconcile quantities and revenue, Separate volume, price and mix effects and Review the drivers. The work takes place remotely through an agreed channel. We identify questions that affect the outcome, confirm where your team needs to make a decision and explain any assumptions that remain at handover.

Timing and boundaries

Indicative delivery after agreed inputs are complete: 3–7 working days. Licences, hosting and extra data sources require separate agreement. Timing may also depend on access, client review or decisions outside the agreed scope. Confirm who owns those dependencies before using the estimate for a launch or other commitment.

After handover

Begin by checking the sales mix analysis workbook against the original question and the information your team supplied. Decide whether you can act on the result directly or need to collect evidence, obtain approval or commission a separate implementation. That distinction helps you turn the assignment into a practical next step.

Questions about this service

Can we request additional work?

Describe the extra work when you enquire. Any change to the published scope, file limits or timing needs separate written agreement.

How should we share files?

Wait for instructions about the agreed channel. Share only the material needed for the assignment and confirm that your organisation has the right to share it.

Related services

DAT-020 Explain performance

Customer churn analysis

We compare retention across four cohorts and identify the largest observable churn differences.

Let’s discuss what you need.

Tell us about your business and the outcome you want to achieve.

Contact us