Data Center Build Decision Tree in Excel | Vose Software

ModelChoice decision tree · Technology

Data Center Build

Build a Tier IV or a Tier III data centre, lease colocation space, or move to the cloud?

  • Complexity: ★★★★★
  • Free Excel workbook
  • Needs ModelChoice: free trial

From the model’s decision tree

Lowest expected cost: Colocation Partnership

The expected value of each first option when every later decision is also made well (the tree rolled back).

First decisionExpected value
Build Tier IV Data Center−$28,020,000
Build Tier III Data Center−$16,917,750
Colocation Partnership−$14,100,000✔ best
Cloud-Only Infrastructure−$54,442,500
MeasureValue
Expected value of the best strategy−$14,100,000
Best outcome on the best strategy−$12,600,000
Worst outcome on the best strategy−$15,600,000
The best strategy: chance of each outcome or less

The decision

A managed services provider needs to expand its infrastructure capacity to serve growing demand for hosting, cloud, and colocation services. The company must choose between building its own facility, partnering with a colocation provider, or going cloud-only. The options are:

  • Build Tier IV data center — highest reliability (99.995% uptime)
  • Build Tier III data center — good reliability at lower cost
  • Colocation partnership — lease space from an existing provider
  • Cloud-only — use public cloud infrastructure exclusively

How the inputs are linked

The tree sheet has a parameter table above the decision tree. Cost per rack, power costs, and customer pricing are defined once and referenced by multiple branches. Changing a single parameter instantly updates all linked values.

The inputs that drive several branches at once:

  • Cost per Rack — scales build cost for both Tier IV and Tier III
  • Price per Rack/Month — revenue driver in all build and colo scenarios
  • Power Cost per kW — operating expense across all build options
  • Number of Racks — scales all capital and operating costs
  • PUE — cooling efficiency affects power costs in all build paths

The decision tree

The tree has 1 decision, 4 chance events and 11 outcomes. The best path is open: at every decision the best choice is marked, and the expected value beside each branch counts every cash flow from the start. Open any other branch to see what follows it.

DecisionChance event+$ cash flow on the branch

Decision: Data Center Strategy
  • Build Tier IV Data Center −$22,500,000expected −$28,020,000
    Chance: Tier IV Demand Scenario
    • 40% High Demand (90% Fill) +$5,280,000payoff −$17,220,000
    • 40% Medium Demand (65% Fill) −$8,220,000payoff −$30,720,000
    • 20% Low Demand (40% Fill) −$21,720,000payoff −$44,220,000
  • Build Tier III Data Center −$17,250,000expected −$16,917,750
    Chance: Tier III Demand Scenario
    • 35% High Demand (90% Fill) +$10,086,000payoff −$7,164,000
    • 45% Medium Demand (65% Fill) −$1,389,000payoff −$18,639,000
    • 20% Low Demand (40% Fill) −$12,864,000payoff −$30,114,000
  • Colocation Partnershipexpected −$14,100,000 ✔ best
    Chance: Colocation Outcome
    • 50% Scales Well −$12,600,000payoff −$12,600,000
    • 50% Margin Squeeze −$15,600,000payoff −$15,600,000
  • Cloud-Only Infrastructureexpected −$54,442,500
    Chance: Cloud Cost Scenario
    • 40% Costs Stable −$35,700,000payoff −$35,700,000
    • 35% Costs Rise −$57,750,000payoff −$57,750,000
    • 25% Vendor Lock-in −$79,800,000payoff −$79,800,000

Change the numbers. Open the workbook with ModelChoice, change a probability or a cost in the tree, and the best decision updates at once.

Key assumptions

AssumptionValueNotes
Cost per Rack (Build)$15,000Infrastructure cost per rack position
Power Cost per kW/Month$120Electricity cost per kW per month
Number of Racks500Total rack positions to deploy
Cooling Efficiency (PUE)1.40Power Usage Effectiveness (1.0 = perfect)
Customer Price per Rack/Month$1,800Monthly revenue per leased rack
Land and Building Cost$15,000,000Site acquisition and construction
Network Connectivity Cost/Month$50,000Fiber, transit, and peering costs
SLA Penalty Rate10.0%Revenue penalty per SLA violation
Power per Rack (kW)8Average power draw per rack
Colocation Price per Rack/Month$2,200Third-party colo provider rate
Cloud Cost per Rack Equivalent/Mo$3,500Cloud infrastructure equivalent cost
Analysis Period (Months)605-year analysis horizon

The figures are illustrative: the companies and numbers are invented for teaching.

Try it in ModelChoice

  • Increase Power Cost per kW. Watch build options become less attractive
  • Raise Customer Price per Rack. See all build scenarios improve
  • Change Number of Racks. Observe economies of scale
  • Run Sensitivity Analysis. Tornado chart shows which parameters matter most

Find similar models

Further reading