Rebate Modeling
Build scenarios and analyze potential outcomes
Base Parameters
Volume Assumptions
Current: $2,400,000
$
Current: 5%
Current: 1.0
Rebate Structure
| Tier | Threshold | Current Rate | New Rate | |
|---|---|---|---|---|
| (current) (target) |
Additional Factors
Scenario Comparison
| Metric | Baseline | Scenario | Variance | % Change |
|---|---|---|---|---|
| Projected Volume | ||||
| Rebate Earned | ||||
| Effective Rate | ||||
| Performance Bonus | $0 | -- | ||
| Commitment Bonus | $0 | -- | ||
| Total Rebate Value |
Comparison Visualization
Volume
Baseline
Rebate Earned
Baseline
Total Value (incl. bonuses)
Baseline
Sensitivity Analysis
Impact of +/- 10% change on key variables
Volume
Rate
Growth
Rate changes have the highest impact on total rebate value
Interactive Analysis
Adjust parameters and see real-time impact
-20%
0%
+50%
-1%
0%
+2%
+5 customers
0%
Projected Impact
Annual Rebate
Change from Current
ROI of Changes
On incremental volume
Break-even Volume
For tier upgrade
Tier Progression
$0
$500K
$1M
$2M
$3M+
With projected changes, volume reaches , qualifying for tier
| Model Name | Description | Base Contract | Created By | Last Modified | Status | |
|---|---|---|---|---|---|---|
|
|