GANIVRA · FREE WORKSHEET · ILLUSTRATIVE DATA
Which customers cost more than they pay?
Review customer contribution after included costs. Replace the examples, document your evidence, then calculate and save the review.
Works locally without uploading data. Inputs are not automatically saved: use Print / Save PDF before closing. Read the worked guide.
1. Set the reporting boundary
2. Enter customer evidence
All amounts must use one currency and period. Blank numeric fields are unknown, not zero. Mark any row with unpriced calls, missing revenue, or unresolved costs as Incomplete. Revenue adjustments that make revenue negative need a separate review; this worksheet accepts non-negative amounts.
| Customer | Revenue | Models | Tools | Shared | Review | Data status | Action / owner / due |
|---|
3. Review the results
4. Reconcile and assign follow-up
Contribution = revenue − included costs. Margin = contribution ÷ revenue. Portfolio margin uses totals, not an average of customer percentages. These figures are not net profit or full accounting gross margin. A positive result with missing costs is not an approved margin.