Act on the result
Quote at least the minimum client service fee or explicitly revise scope, reserve or target margin.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
Agencies pricing campaign delivery with handled media and scope risk.
Handling revenue, protected delivery cost, gross margin and minimum service fee.
Keep client media spend as pass-through and enter only agency delivery costs.
Use a different tool when: Do not use this to compare quoted and actual job economics and identify overruns; use Job Costing & Margin Planner for that decision. Use this tool to price agency campaign delivery after media handling, scope reserve and target margin.
Cash & growth
Handling revenue, protected delivery cost, gross margin and minimum service fee.
Amounts use the same currency as your inputs. No currency conversion is performed.
Use one consistent period, contribution and currency basis.
Your numbers stay in this browser
Agency service fee excluding media pass-through. Use one consistent currency and indirect-tax basis.
Delivery hours charged to the campaign.
Internal loaded delivery cost per hour. Use one consistent currency and indirect-tax basis.
Creative, contractor and tool costs paid by the agency. Use one consistent currency and indirect-tax basis.
Client pass-through media basis; excluded from agency revenue and delivery cost. Use one consistent currency and indirect-tax basis.
Fee charged on handled media spend.
Reserve applied to base delivery cost.
Gross margin to protect on agency revenue.
Every result is produced by the registered customer and marketing engine.
Each row names the assumption axis changed from the baseline.
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
media spend handled ร handling fee rate500.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โcampaign hours ร loaded hourly cost + external delivery costs7,000.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โbase delivery cost ร scope buffer rate700.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โbase delivery cost + scope reserve7,700.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โclient service fee + handling revenue12,500.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โagency revenue โ protected delivery cost4,800.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โgross profit รท agency revenue0.38 percentReports percent for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โprotected delivery cost รท (1 โ target margin)11,000.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โmax(0, minimum agency revenue โ handling revenue)10,500.00Reports money for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โgross margin โ target margin rate0.08 percentReports percent for the declared cohort and period using the entered attribution and contribution basis. The engine retains raw precision; formatting never feeds calculation.
Agency Campaign Margin Planner formulas โThis calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| campaignHours | Delivery hours charged to the campaign. | delivery hours/campaign | 0 to 100000 | Required | 100 |
| clientServiceFee | Agency service fee excluding media pass-through. Use one consistent currency and indirect-tax basis. | currency units/campaign, excluding media pass-through | 0 to 10000000 | Required | 12000 |
| externalDeliveryCosts | Creative, contractor and tool costs paid by the agency. Use one consistent currency and indirect-tax basis. | currency units/campaign | 0 to 10000000 | Required | 1000 |
| loadedHourlyCost | Internal loaded delivery cost per hour. Use one consistent currency and indirect-tax basis. | currency units/delivery hour | 0 to 10000000 | Required | 60 |
| mediaHandlingFeeRate | Fee charged on handled media spend. | decimal share of client media spend handled | 0 to 1 | Required | 0.1 |
| mediaSpendHandled | Client pass-through media basis; excluded from agency revenue and delivery cost. Use one consistent currency and indirect-tax basis. | currency units of client media spend/campaign | 0 to 10000000 | Required | 5000 |
| scopeBufferRate | Reserve applied to base delivery cost. | decimal share of base delivery cost | 0 to 1 | Required | 0.1 |
| targetMarginRate | Gross margin to protect on agency revenue. | decimal share of agency revenue | 0 to 1 | Required | 0.3 |
Minimum client service fee protects the entered delivery cost, scope reserve and target margin after media-handling revenue.
Data used here
Quote at least the minimum client service fee or explicitly revise scope, reserve or target margin.
Retest campaign hours as delivery hours per campaign and scope reserve rate as a percentage of base delivery cost.
Educational estimate, not advice. See all assumptions & limitations โ
Guides to interpret the decision and its assumptions.
Connect utilisation, recovery rate, scope delivery and committed pipeline without treating one ratio as an agency forecast.
Read guideQuote at least the minimum client service fee or explicitly revise scope, reserve or target margin.
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.