Northstar Technologies. Four regions, four currencies, one consolidated operating story.
FICTIONAL CASE STUDY · Northstar Technologies is not a real company. All regional inputs and exchange rates were authored for this case. Q2 2026 compared with Q2 2025; no employer information.
Consolidated revenue$239.46m6.0% reported growth
Budget variance-4.94mActual less budget · USD
FX-neutral growth9.8%Prior-period FX held constant
Regional revenue · actual vs budgetUSD m · shared scale, zero baseline
United States actual
112.00
United States budget
110.00
Germany actual
56.70
Germany budget
58.30
Mexico actual
36.96
Mexico budget
39.00
Japan actual
33.80
Japan budget
37.10
Revenue variance bridgeUSD m · shared scale, zero baseline
Operations
3.72
FX translation
-8.66
Net variance
-4.94
Budget 244.40 + operations 3.72 + FX (-8.66) = actual 239.46 USD m.
The regional operating picture
Operating profit by regionUSD m · shared scale, zero baseline
United States
28.00
Germany
13.65
Mexico
8.64
Japan
6.17
Capital expenditure by regionUSD m · shared scale, zero baseline
United States
10.00
Germany
6.30
Mexico
3.03
Japan
2.73
Calculated results · USD m except percentages, percentage points (pp), and people. Positive cost/headcount variances mean above budget.
Region
Local growth
USD growth
Op. margin
Margin Δ pp
OpEx Δ
Headcount Δ
CapEx Δ
United States
12.0%
12.0%
25.0%
-0.45
2.00
8
1.00
Germany
8.0%
3.1%
24.1%
-0.45
-0.95
5
0.80
Mexico
12.0%
2.7%
23.4%
0.29
-1.68
10
0.02
Japan
4.0%
-3.4%
18.3%
-2.49
-1.78
-2
-0.07
Management commentary
United States · USD
12.0% local growth
Revenue grew 12.0% in local currency and 12.0% after USD translation. Reported revenue was 2.00m above budget. FX contributed 0.00m to that variance.
Operating expense was 2.00m above budget. Investigate staffing, pricing, and mix before attributing causes.
Germany · EUR
8.0% local growth
Revenue grew 8.0% in local currency and 3.1% after USD translation. Reported revenue was 1.60m below budget. FX contributed -2.70m to that variance.
Operating expense was 0.95m below budget. Investigate staffing, pricing, and mix before attributing causes.
Mexico · MXN
12.0% local growth
Revenue grew 12.0% in local currency and 2.7% after USD translation. Reported revenue was 2.04m below budget. FX contributed -3.36m to that variance.
Operating expense was 1.68m below budget. Investigate staffing, pricing, and mix before attributing causes.
Japan · JPY
4.0% local growth
Revenue grew 4.0% in local currency and -3.4% after USD translation. Reported revenue was 3.30m below budget. FX contributed -2.60m to that variance.
Operating expense was 1.78m below budget. Investigate staffing, pricing, and mix before attributing causes.
Commentary is generated from the deterministic model. The model does not infer business causes from variances alone.
Build the next-quarter scenario
Apply a common local revenue growth assumption to Q2 actuals, then move foreign-currency translation rates. This simplified revenue forecast excludes seasonality and does not forecast expenses or profit.
Q3 scenario revenue$251.43mEstimated Impact · not guidance
Q2 starting revenue$239.46m
Sequential change5.0%
Regional forecast · Q3 scenarioUSD m · shared scale, zero baseline
United States
117.60
Germany
59.54
Mexico
38.81
Japan
35.49
Inspect the source inputs
Local revenue, expense, and CapEx amounts are retained. Multiply each by its period-average USD-per-local-unit rate to consolidate.
All inputs fictional · Q2 2026 · Local millions; FX = USD per local unit · Same period for all regions.
Region / currency
Prior rev.
Budget rev.
Actual rev.
Budget OpEx
Actual OpEx
Prior FX
Budget FX
Actual FX
Budget HC
Actual HC
Budget CapEx
Actual CapEx
United States / USD
100
110
112
82
84
1
1
1
400
408
9
10
Germany / EUR
50
53
54
40
41
1.1
1.1
1.05
200
205
5
6
Mexico / MXN
600
650
672
500
515
0.06
0.06
0.055
300
310
50
55
Japan / JPY
5000
5300
5200
4200
4250
0.007
0.007
0.0065
180
178
400
420
Model formulas and limitations
Budget variance = actual local revenue × actual FX − budget local revenue × budget FX. Operations = (actual − budget local revenue) × budget FX. FX = actual local revenue × (actual FX − budget FX). Constant-currency growth uses prior-year FX for both years.
Operating profit = revenue − operating expenses. Margin variance = actual margin − budget margin. No intercompany eliminations, tax, debt, depreciation schedules, or confidential data. Quarterly average rates are assumptions, not market quotes.
Source: Luna1 authored fictional case · As of 2026-06-30 · Updated 2026-09-26 · Millions of local currency; headcount in people · Reporting currency USD.