MIZWALA ADVISORS

PRINTABLE WORKSHEET · 4 NOVEMBER 2026

Your largest customer may not be your most profitable

Complete this sheet with your own verified information. Calculations are manual. Use your browser’s Print command to save a PDF or print; entries are not submitted or automatically saved.

Decision, customer group and period
Net sales reconciliation and credits
Direct costs already included
Activity driver, volume and source
Estimated rate, sample and uncertainty
Shared costs and double-counting checks
Which costs/capacity would really change?
Proposed service/price change and contract checks
Trial, owner, actual results and review date

Reference example — fictional

Fictional quarterly customer comparison · OMR
MeasureCustomer A / Customer B
Net sales60,000 / 40,000
Direct product/service cost42,000 / 28,000
Gross contribution18,000 / 12,000
Delivery activity4,500 / 1,350
Support activity4,200 / 700
Returns handling1,800 / 250
Contribution after listed activities7,500 / 9,700

A: 18,000 − 4,500 − 4,200 − 1,800 = 7,500. B: 12,000 − 1,350 − 700 − 250 = 9,700. Fictional estimates; before remaining shared costs, financing and tax.

Return to the full guide and sources