Quick answer
A relocation cost simulation is a structured model of the full employer cost of moving an employee from one location to another. It calculates net-to-gross and gross-up amounts, housing and cost-of-living allowances, and family size adjustments, all linked to a policy tier, and you can clone, adjust, and compare it in seconds. Unlike a spreadsheet, it comes with built-in tax logic, policy linkage, and a full audit trail.
Every global mobility team has built "the spreadsheet" at some point. You know the one. A tangle of tabs for base salary, tax gross-ups, housing allowances, and cost-of-living adjustments, with a formula in column AF that nobody wants to touch in case it breaks the whole model.
It works, until it doesn't. And in global mobility, that failure tends to show up at the worst possible time: mid-approval, mid-negotiation, or mid-assignment.
So what replaces it? A relocation cost simulation. Here is what that means, and why the spreadsheet approach runs out of road so quickly.
What goes into a relocation cost simulation?
A cost simulation models the total employer cost of a workforce move under a specific set of assumptions. That includes:
- Base salary and bonus, converted and adjusted across currencies
- Net-to-gross calculations and gross-ups, powered by a tax engine instead of a static formula
- Housing, cost-of-living, and other allowances, layered onto the base package
- Family size and dependents, which affect several downstream calculations
- Policy tier, such as Gold, Silver, or Bronze, and what that tier actually includes
- Worker classification, since employee and contractor moves carry different cost structures
Set the origin, destination, and compensation inputs, then run the calculation. You get a full cost breakdown: not an estimate scribbled on the back of an offer letter, but a defensible, structured number you can bring to a budget meeting.
Why can't a spreadsheet handle relocation cost modeling?
Spreadsheets hold numbers well. They hold logic that changes by country, by policy, and by year far less well.
No version control
Once three people have edited the same relocation model, nobody is entirely sure which tab reflects the latest tax rules or the most recent policy update. There is no record of who changed what, or when.
No real comparison
Want to see a full package next to a localized package? Or an employee move next to a contractor move? In a spreadsheet, that usually means duplicating the whole workbook and hoping the copies stay in sync.
No connection to policy
Spreadsheets don't know a move falls under a Gold-tier policy, and they don't update when that policy changes. The link between a move and the rules that govern it lives in someone's memory, not in the model.
No audit trail
If a compliance question comes up eighteen months later about why a number was what it was, a spreadsheet has no history to point to. A simulation platform tracks that history down to the individual field.
The gap isn't really about math. Spreadsheets can technically calculate a gross-up. The gap is about trust.
Spreadsheet vs. simulation platform, side by side
| Capability | Spreadsheet | Simulation platform |
|---|---|---|
| Version history | None, tabs get overwritten silently | Field-level audit trail on every change |
| Tax logic | Manual formulas, easy to break | Built-in tax engine, kept current |
| Scenario comparison | Duplicate workbooks | Clone and compare side by side |
| Policy linkage | Copied from a PDF, often stale | Live link to Gold, Silver, Bronze tiers |
| Group moves | One sheet per employee | Batch simulations across a project |
| Stakeholder output | Manual copy into a deck | One-click formal cost estimate |
What a simulation platform gives you instead
This is where a purpose-built platform like Topia Horizon Cost Simulations changes the equation. A cost simulation in Horizon isn't a static number. It's a living scenario you can build on.
- Run it in seconds. Enter origin, destination, and compensation, and get a total employer cost breakdown instantly.
- Clone and compare. Swap the tax approach, package type, or worker classification, and view results side by side.
- Scale to groups. Model a 10-person office expansion without opening 10 spreadsheets. Group simulations batch the analysis under one project.
- Link to policy. Every simulation ties back to a Gold, Silver, or Bronze tier, so the numbers reflect what your organization has committed to.
- Keep the audit trail. Every field-level change gets tracked automatically, before and after snapshots included.
- Export when you're ready to decide. Generate a formal cost estimate straight from the simulation for stakeholder review.
The real difference
Global mobility decisions, like relocating someone from the US to Germany, standing up an office in Singapore, or weighing an employee against a contractor, deserve better than a formula only one person fully understands. A cost simulation gives every stakeholder the same defensible number, backed by the same audit trail, every time.
Ready to see it on your own numbers? Run a real relocation scenario in Horizon and see the total employer cost breakdown in seconds.
Frequently Asked Questions
- What is a relocation cost simulation?
- A relocation cost simulation is a structured model of the total employer cost of moving an employee from one location to another. It includes base salary and bonus, net-to-gross and gross-up calculations, housing and cost-of-living allowances, family size, and the policy tier the move falls under.
- Why can't a spreadsheet handle relocation cost modeling?
- Spreadsheets have no version control, no audit trail, and no live connection to current tax rules or policy documents. Every relocation model is a static snapshot that someone has to update manually, so costs drift and compliance details fall out of date.
- What is a gross-up in relocation cost modeling?
- A gross-up is an additional payment that covers the tax an employee owes on relocation benefits, so the benefit keeps its full value. Calculating it accurately requires a tax engine that reflects current rules in both the origin and destination country.
- Can you compare employee versus contractor relocation costs?
- Yes. A cost simulation platform lets you clone an existing scenario, swap the worker classification, and compare both total employer cost breakdowns side by side.
- How does Horizon by Topia calculate relocation costs?
- Horizon by Topia runs relocation cost simulations through a proprietary tax engine. Set the origin and destination, enter compensation details, and Horizon calculates the total employer cost instantly, gross-ups, allowances, and policy-linked benefits included, with a full field-level audit trail.
