Sales Analysis: Explain a Product-Mix Change with a Sales Bridge

Start with products, units and realized prices

Fictional shop sells desk organizers and trays. In MonthA it sells 100 organizers at $30 and 200 trays at $10. In MonthB it sells 80 organizers at $32 and 240 trays at $10. Prices are realized prices per unit after any reductions; the supplied periods have no other sales items, returns or tax amounts to add.

Salesforce describes sales analysis as examining sales data for patterns, including product performance. This exercise concentrates on the product breakdown and a reproducible bridge rather than a general list of analytics tools.

Calculate the product totals

Reconcile the change using a stated bridge convention

Use MonthA prices to measure the quantity changes first. Organizers:(80−100)×$30=−$600. Trays:(240−200)×$10=+$400. Total quantity effect is−$200. Then apply the price changes to MonthB quantities: 80×($32−$30)=+$160 for organizers; trays have no price change.

The bridge reconciles:−$200+$160=−$40. This ordering allocates the price/quantity interaction to the price effect. A different valid ordering can allocate that interaction differently, so state the convention rather than presenting the two effects as uniquely determined causes.

Describe the product mix without making a causal claim

Organizers were one-third of MonthA’s units and one-quarter of MonthB’s units. More of the supplied volume moved into the lower-priced product. That helps explain why total units increased while revenue fell slightly, despite the higher organizer price.

Do not conclude that the price rise caused the organizer decline. The fixture gives no information about demand, availability, marketing activity or buyer decisions. It also supplies no product costs, so a revenue analysis cannot establish which month was more profitable.

Write the completed analysis note

“Sales revenue declined $40 to $4,960 while units rose to 320. Organizer revenue fell $440 and tray revenue rose $400. Using prior prices for the quantity step, the−$200 quantity effect was partly offset by a+$160 price effect. Product costs and reasons for the quantity changes are not supplied.”

Practice check: if someone reports the change as−$440, they have used only one product. Recover the+$400 tray contribution before accepting the total.