IBEW · Sponsorship Planning

Budget Planner

Set the tier thresholds and per-ad costs. The tier counts and total spend recalculate as you go.

Live snapshot from Jon's sheet
Total ad budget
$0
City ads  $0  /  0 Locals
State ads  $0  /  0 States

Open calls by state

Fewer callsMore calls
Top border marks a state that meets a tier — T1 T2 T3
⇪
Drop this period's Master Open Calls (.xlsx) here, or — the map, tiers, and budget all recompute automatically.
Showing the latest snapshot from Jon's sheet.

How the Locals split

Where the money goes

Jon's model: each tier has a set budget (the “pot”), split equally among the Locals or states in that tier. Change a pot on the left and the per-ad amount moves.

BucketCountTier budgetEach gets

Tier 1 & 2 Locals at these settings

The highest-priority Locals your thresholds would put on Indeed right now.

LocalCityStCallsTier

Prototype — the same math as Jon's workbook (Inside-JW calls, tiered at or above each threshold), running live in the browser on a snapshot of the current numbers. Nothing leaves this page. A production version would load fresh call counts each period and embed directly into WordPress.