Meridian Technology Infrastructure — Cost Transparency & Scenarios

Power BI dashboard wireframes (annotated) · 3 screens · figures from the Q1 2025 model ($40.2M base)
Screen 1 of 3
Executive overview
Period: Q1 2025Program: AllProduct: AllView: Fully-loaded
$40.2M
Fully-loaded cost 1
50%
Compute share of total
$3.2M
Overhead loading (8%) 2
+0.6%
Actual vs budget

Fully-loaded cost by product

Compute$20.1M
Database$4.8M
End-User$3.8M
Cloud Plat.$3.4M
Storage$3.2M
Security$2.9M
Network$1.9M

Cost by pool

Labour$12.4M
Public Cloud$9.3M
HW Deprec.$6.3M
Data Centre$3.4M
Overhead$3.2M
Vendor$2.6M
Network$1.8M
Software$1.3M

Monthly fully-loaded trend 3

Jan $18.2M
Feb $11.2M
Mar $10.7M
1Fully-Loaded Cost is the headline measure (direct + allocated + overhead). A toggle switches to pre-overhead for a like-for-like budget view.
2Overhead loading is a distinct KPI and a distinct bar colour, so the ~8% shared-overhead assumption is never hidden inside product costs.
3The declining trend is data coverage (facts populate Jan to Mar), flagged so no one misreads it as a cost reduction.
Screen 2 of 3
Cost transparency drill
Drill: Program → Funding request → Product → ApplicationPeriod: Q1 2025
$5.05
Unit cost, $ / vCPU-hour (Compute) 2
Tier 1
Filter: application criticality

Fully-loaded cost by program and product 1

ProgramFunding requestProductDirect + allocOverheadFully-loaded
Core Hosting ModernizationCompute Capacity RefreshCompute$18.5M$1.6M$20.1M
Core Hosting ModernizationDatabase Platform UpgradeDatabase$4.4M$0.4M$4.8M
Core Hosting ModernizationStorage Tiering ProgramStorage$3.0M$0.2M$3.2M
Cloud AccelerationPublic Cloud Landing ZoneCloud Platform$3.1M$0.3M$3.4M
Workplace & Security ServicesEnd-User Device RefreshEnd-User$3.5M$0.3M$3.8M
Workplace & Security ServicesZero-Trust Security RolloutSecurity$2.7M$0.2M$2.9M
Network & Connectivity UpliftWAN ModernizationNetwork$1.8M$0.1M$1.9M
1A decomposition matrix drills Program → Funding request → Product → Application. Overhead sits in its own column so fully-loaded is always direct+alloc plus a visible loading.
2Unit cost ($/vCPU-hr, $/GB) turns absolute spend into an efficiency lens the CFO can compare across products.
Screen 3 of 3
Scenario what-if
Live parametersBefore / after

Cloud migration % 1

Set to 15% · cloud cost factor 1.10

Vendor rate increase

Set to +8% on managed-service pool
$40.17M
Baseline fully-loaded
+$50k
Cloud migration delta +0.1%
+$204k
Vendor +8% delta +0.5%
$40.43M
Both scenarios applied

Before / after by product — vendor +8% 2

Database$4.82M
$4.95M
Cloud Plat.$3.40M
$3.49M
baselineafter scenario · vendor increase lands only on the two managed-service consumers

Before / after by product — cloud migration 15% @ 1.10 3

Compute$20.08M
$20.10M
Storage$3.23M
$3.26M
baselineafter scenario · cloud migration lands only on the two products Data Centre serves
1The Cloud migration % slider is a Power BI what-if parameter driving Scenario Cloud Delta. Moving it recalculates the delta live for live what-if questions.
23Scenario toggle: the segmented control above each breakdown swaps the panel between the two scenarios — a bookmark-driven toggle (or a field-parameter slicer) bound to the same visual, so only one breakdown is on screen at a time in the real report; both are drawn here to show what each state looks like.
Sensitivity call-out: the cloud migration sign flips with the cost factor (+$50k at 1.10, −$50k at 0.90). The vendor increase is linear and certain. This framing is the headline for the live Q&A.