Cost Modeling & Scenarios

Model cost changes and analyze impact on margins

Saved Scenarios
12
3 pending review
Active Model
Q1 2025 Forecast
Last run: 2 hours ago
Best Case Margin
21.4%
+2.7% vs baseline
Worst Case Margin
16.2%
-2.5% vs baseline

Scenario Builder

Base Scenario:

Cost Variables

+2.5%
-10% 0% +10%
+5.0%
-10% 0% +10%
+3.0%
-10% 0% +10%
0.0%
-10% 0% +10%

Revenue Variables

+4.0%
-15% 0% +15%
+1.5%
-10% 0% +10%

Rebate Variables

+0.5%
-5% 0% +5%
0.0%
-5% 0% +5%

Impact Preview

Net Margin Comparison

Baseline
18.7%
Projected
17.4%
-1.3% margin impact

Financial Impact

Revenue Change +$8.2M
Cost Change +$10.1M
Rebate Change +$1.2M
Net Impact -$3.1M

Risk Assessment

Cost increases outpace revenue
GPO rate increase adds $620K
Volume growth partially offsets

Saved Scenarios

Actions

Create New Scenario