📊 Static Leontief Model

Input-output analysis with extensions

Matrix A (technical coefficients)

Manage databox ↗

No data loaded yet. Click "Load data from databox" and choose a dataset.

No calculation performed. Please switch to the "Input" tab.

Neumann series: (E-A)⁻¹ = E + A + A² + A³ + ...

Shows the convergence of the Neumann series to the inverse matrix.

No calculation performed. Please calculate first.

Extended analyses

Breakdown of final use and value-added accounting.

Theory

Y = C + I + V + E (breakdown of final demand per sector)

  • C = consumption (private households and government)
  • I = gross fixed capital formation
  • V = changes in inventories (can be negative)
  • E = exports

If the dataset contains no E, it is calculated as a residual: E = Y − C − I − V. The small example datasets (ZIP) describe a closed economy with V = E = 0; the 5×5 example and the Destatis data contain all four components.

Input

Please calculate in the "Input" tab first.

Theory

Imports by product group

mgj = imports of group g per unit of output of sector j (share of output)

Imgj = mgj · Xj    and    Imj = Σg Imgj

Example data: three groups (raw materials, intermediate products, services). Destatis: one group (imported intermediate inputs). At most three groups are evaluated.

Input

Please calculate in the "Input" tab first.

Theory

Cost structure per sector j (column of the input-output table)

Xj = Σi aijXj + Mj + Lj + Gj + Tj

or in coefficients: Σi aij + mj + lj + gj + tj = 1

BWSj = Lj + Gj + Tj

  • Intermediate inputs = column sum of A times Xj
  • M = imports (sum of the import groups from step 2)
  • L = wages (compensation of employees)
  • G = profits (gross operating surplus incl. depreciation)
  • T = taxes less subsidies (can be negative)

Destatis: besides other taxes on production, T also contains taxes on products; L + G + T is therefore somewhat larger than gross value added in the national accounts.

Input

Please calculate step 1 first.

Theory

Price model (dual Leontief model)

  • Quantity model: X = (E−A)⁻¹ · Y
  • Price model: pT = pT · A + vT  ⇒  pT = vT · (E−A)⁻¹

p = price index per sector (base 1), v = primary input costs per unit of output. From the databox, v = share of gross value added is used. Since imported intermediate inputs are not included, Σi aij + vj < 1 and therefore p < 1. With v = value-added share plus import share, p = 1. For cost changes, ΔpT = ΔvT · (E−A)⁻¹ (e.g. a wage increase in one sector).

Input

Please calculate in the "Input" tab first.

Theory

Satellite accounts: environment and employment

fj = indicator per unit of output of sector j

  • Direct: fj · Xj
  • Indirect (first supply stage): Σi fi · aij · Xj
  • Total: direct + indirect

Total intensity over all supply stages: fT · (E−A)⁻¹

Example data: CO2 (t), energy (MWh) and employment (persons employed) per unit of output. Destatis: persons employed per EUR million of output. At most three indicators are evaluated.

Input

Please calculate in the "Input" tab first.

🔬 Sensitivity analysis

Analyse how changes in the parameters affect the results.

Theory

Variation of individual coefficients aij by ±Δ% → effect on output X

Elasticity: ε = (ΔX/X) / (Δa/a)

Parameter

±% change of the coefficient

Theory

Variation of the final use components → effect on total output

Parameter

Theory

Variation of the import coefficients → effect on domestic production

Parameter

Theory

Variation of value added v → effect on price vector p

Parameter

Theory

Variation of the emission coefficients f → effect on environmental burden

Parameter

📊 Tornado chart

Shows the top 10 influencing factors from all sensitivity analyses performed.

Tip: first run "Analyse all" in the desired sections, then click "Create tornado chart".

Export results

Download all calculated data as a CSV file.

Exports all extended input-output tables from the extensions