Traditional Care (SoC) Cost
£117,078
Avg cost per patient · PN-based pathway
CRT (The Insides System) Cost
£71,931
Avg cost per patient · CRT pathway
Net Saving per Patient
£45,147
38.6% reduction vs SoC
Largest Saving Driver
PN Costs
£33,487 saving (77.0%)
Cost Driver Comparison — Traditional Care vs. CRT per Patient
Top Saving Contributors
Audience View
Cost Bridge — From Traditional Care to CRT (per patient)
SoC Total
Cost Saving (Step Down)
Incremental CRT Cost
CRT Total
💡 This chart shows how each cost driver contributes to moving from the Traditional Care total cost to the CRT total. Green bars represent savings (steps down); red bars represent incremental CRT-only costs.
Savings Ranked by Magnitude
Contribution to Total Net Saving
Savings Contribution Detail
Tornado Chart — Impact on Net Savings
One-Way Sensitivity — Selected Input
⚙️ Editing these inputs recalculates all linked cost-driver outputs and updates all charts. Values shown are from the workbook base case. Changes apply to the active scenario only.
📋 You can directly edit Traditional Care and CRT values below. Edited cells are marked. Changes propagate to all charts. Use "Include" checkbox to exclude a row from totals.
Editable Cost-Driver Output Table
| ✓ | Cost Driver | Traditional Care (SoC) | CRT Cost | Saving (£) | Saving (%) | Source | Tag | Notes |
|---|
📐 Comparison View — Mirrors the legacy BIA visual format. Shows clinical metrics (days & %) and cost comparisons side-by-side with diverging bars. Updates live when model inputs change.
🎯 Select a scenario to view its assumptions and results. Edit scenario inputs, then click "Apply Scenario" to update all charts.
Scenario Comparison — Net Saving per Patient
Active Scenario: Base Case
🌏 Switch cost assumptions to a different market. Clinical assumptions remain fixed; only local cost inputs change. Select or edit a market below.
Market Cost Inputs — United Kingdom (Base)
Market Result Preview
Colours
Number Format
Sort Order
Display Options
Model Overview
✎ Click text to editThis Budget Impact Analysis (BIA) compares the cost of treating patients with intestinal failure using Chyme Reinfusion Therapy (CRT) via The Insides System against the PN-based standard of care (SoC). All values represent per-patient average costs in GBP.
- CRT values are derived from REINFUSE trial data, FR/NZ Registry, and published literature (weighted cohort analysis).
- SoC comparator values are based on standard care literature and NHS reference costs.
- Source heterogeneity exists across studies; this model blends multiple data sources.
- This is a budget impact communication tool, not a single head-to-head CEA.
- Cost of AKI saving is implied from model SoC and CRT values (not explicitly stated in workbook).
- Cost for Failure to Establish on CRT is a CRT-specific incremental cost; SoC value is £0.
- PN cost calculation logic involves complex weighting of inpatient TPN and home HPN days. The formula is partially reconstructed.
Calculation Trace
| Cost Driver | Formula (Reconstructed) | Status |
|---|---|---|
| Hospital Bed Cost | (pct_d × days_d + (1-pct_d) × days_nd) × daily_bed_cost CRT: discharged days include 28-day pre-therapy | Verified ✓ |
| PN Costs | SoC: (C7×TPN + (C5−C7)×HPN)×(1−reduction) CRT: pct_weaned×days_wean×TPN + (1−pct_weaned)×(C7×TPN+(C5−C7)×HPN) − reduction×(C7×TPN+(C5−C7)×HPN) Exact Excel formula — verified to <£0.001 of workbook value | Verified ✓ |
| Cost of The Insides System | device_cost + (months − 1) × refill_cost | Verified ✓ |
| CLABSI | incidence_clabsi × cost_clabsi_episode | Verified ✓ |
| PNALD | incidence_pnald × cost_pnald_episode | Verified ✓ |
| PPOI | incidence_ppoi × cost_ppoi_episode | Verified ✓ |
| AKI | incidence_aki × cost_aki_episode | Verified ✓ |
| Failure to Establish | (1 − success_rate) × device_cost | Verified ✓ |
Key Evidence Sources
Source references sync from Model Inputs tab| Input | Base Value | Source Reference (edit in Model Inputs) |
|---|