Input-output analysis with extensions
Shows the convergence of the Neumann series to the inverse matrix.
Breakdown of final use and value-added accounting.
Y = C + I + V + E (breakdown of final demand per sector)
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.
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.
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
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.
Price model (dual Leontief model)
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).
Satellite accounts: environment and employment
fj = indicator per unit of output of sector j
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.
Analyse how changes in the parameters affect the results.
Variation of individual coefficients aij by ±Δ% → effect on output X
Elasticity: ε = (ΔX/X) / (Δa/a)
Variation of the final use components → effect on total output
Variation of the import coefficients → effect on domestic production
Variation of value added v → effect on price vector p
Variation of the emission coefficients f → effect on environmental burden
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".
Download all calculated data as a CSV file.
Exports all extended input-output tables from the extensions