I have built the world IOTs in wages-value for the year 2000 to 2014, as well as the Excel tables explaining OSs formation of the 2,464 world productive units for the same years.
One will find on the WIOD site, peculiarly under the form Excel or Rdata, the world IOTs in prices for the year 2000 to 2014. Rdata files can be read with the R software.Data on labour compensation, I have used for building the IOTs in wages-value, come from the World Input-Output Database site too.
The world IOTs in prices of the
WIOD describe 43
countries and the rest of the world, i.e. 44 areas,
(list
of areas) and 56 activities (list
of activities), i.e. 2,464 productive units
Taking the example of the year 2014, I present below in 5 steps the method I have followed to build the world IOTs in wages-value and the Excel tables explaining the OSs formation of the 2,464 productive units of the world economy. This method follows what I had exposed at the Bordeaux ADEK conference in July 2010, except that at Bordeaux I had described a process (cf. § 6, p.p. 19 et 20) to build a single world IOT in value from several national IOTs in prices. I have not used this process, since I have started from a single world IOT in prices.
I join the computer process I have used.
This vector of 2,464 elements gives the incomes paid by each of the 2,464 productive units including the rest of the world. The "socio-economic accounts" of the WIOD give the se incomes (wages and labour-incomes of the independent workers ("labour compensation") paid by each of the 56 industries of the 43 countries, but not by the rest of the world. These figures being in local currency have to be converted in U.S. dollars, which is the common currency of the world IOT, using the exchange rates given by the WIOD. This gives the 2,408 (56 x 43) first elements of the vector . For finding the 56 last elements of this vector relating to the rest of the world, I have supposed that, for each industry of the rest of the world, the ratio labour compensation/value added was equal to the average ratio of the 43 countries for the same industry. One can find the value added of the 2,464 productive units (including these of the rest of the world) in the world IOT in prices under the Excel or Rdata form.
One can see the vector giving the labour compensations of the 2,464 productive units thus obtained under a matrix form. Despite this matrix presentation, it is a true vector, the vector , which can be got by writing end to end the different lines of the matrix.
The IOT in prices gives the vector of the production of the 2,464 productive units and the matrix of intermediate consumption IC (2,464 x 2,464). One can get the diagonal matrix Σ and the square matrix (2,464 x 2,464) Σ - IC. But this matrix has no inverse, because some elements of are null, which implies that some column vectors of Σ - IC are also null. As a remedy to this problem, I have replaced all the null elements of by one. The only effect of that change is to replace a null production by a production of 1 million of USD, which is negligible on a world level.
After that, the solve function of R gives the vector of which I give the matrix form similar to that of
We know the vector
| intermediate consumption |
43,828,260 | final uses | 42,196,851 | total | 86,025,111 |
| labour compensation | 42,196,851 | ||||
| total | 86,025,111 |
One can verify that the total of the rows of commodities equals the total of the columns of industries.
I decompose the OSs of the different productive units following the method
developped in my Bordeaux communication. The accounting
OS of these units is given by the vector
The vector
The calculus results are given in a unique Excel file here with the following sheets:
At last the same Excel file presents three more sheets whose object is wages-value OSs calculus (see 5th step below).
Each sheet is a matrix (56 industry rows, 44 area columns) giving the values of each productive unit. If one considers end to end the columns of each of these matrices, one gets vectors of 2,464 elements equivalent to the n elements vectors of the theorical model.
The primitive OS, realized only by the sales of consumption commodities before any
exchange between firms, is given by the vector
Each element of these vectors represents the sales of one of the 2,464 commodities as consumption good to the 44 countries (including the rest of the world and the country making the good). On a IOT the final uses appear on a matrix located on the "right" of the matrix IC of the intermediate consumptions. With the software R, I have extracted from the IOT in prices published on the WIOD site, the matrix efprix of the final uses in prices. After that, one need to extract from this last matrix the sales of consumption goods from each productive unit to the different countries.
The final purchases of each country are divided on five successive columns (purchases by the consumers, purchases by non-profit institutions serving households, purchases by government, purchases of GFCF, variations of stocks). I have considered all the sales of consumption, therefore the sales given by the first three columnns. I have given a double index to each productive unit, an index b for the activity varying from 1 to 56 (cf. list of activities), and the index p for the area varying from 1 to 44 (cf. list of countries).
Thus one can represent the vector
Aefprix <- array(t(efprix),dim=c(5,44,56,44))
# 5 types of final use, 44 countries purchasers, 56 activities producers, 44 countries producers
Ctotprix[b,p]=sum(Aefprix[1:3,,b,p])
The last program line means that only the first three types of final use have been selected, that all the coutries are purchasers (no figure between both commas), but that only the activity b of the country p is producer.
The matrix giving the final uses measured in value is efval = K efprix and from
program lines similar to the above lines, we can build the matrix Ctotval
(44 x 56), which represents the vector
Results are written on the two firsts sheets of the
Excel file for
The calculus of gains and losses made by each of the 2,464 productive units is done easily from the matrices of intermediate consumption in prices IC and in value K IC.
One can verify that the total of the earnings got by the whole of the 2,464 productive units, that are written on the sheet 4 of the Excel file, equals the total of the losses got by the whole of the same productive units written on the sheet 5. Therefore the total of the net earnings of the whole of the productive units written on sheet 6 is null.
On sheet 7, I write the OSs got by each productive unit after the intermediate
consumption exchanges have occured. That can be done by summing sheets 3 and 6. Thus it is a
redistribution of the OSs
We have no matrices
A similar program line gives the measure in value. Therefore one can calculate the gain got by each produtive unit. Results are given on sheet 8.
The commodities produced by a productive unit, then stored by the same or an other productive unit, are given by the 5th position of the matrices efprix and efval. Therefore the earnings made by the productive unit whose indices are b and p when producing commodities that are eventually stored are given by gainsStocksProd[b,p] = sum(Aefprix[5,,b,p]) - sum(Aefval[5,,b,p]). The results are recorded on the 9th sheet of the Excel file.
As I explain in my Bordeaux communication, §4.3, pp 18 and 19, to get the final OSs in value, one has to omit the 5th component relative to the gains done with stock variations and to deduct a component I have called "4th A" giving the losses done when buying GFCF. But there are no data relative to this new component in firms accounts whose goal is the calculus of accounting OS, and not a OS in value. Therefore the IOT, which is built on the same principles, cannot be used to calculate the losses done by each productive unit when buying GFCF.
But we can, through the world IOT's, either in prices or in wages-value, calculate the losses done by the whole of the productive units of a given area (country or rest of the world) when buying GFCF. Therefore I will begin to calculate these losses. Then I will estimate the losses done by each productive unit in sharing the losses of each area between the productive units of the same area.
Results are displayed on sheets 11 (estimation of losses by purchasing GFCF), 12 (estimation of the net earnings done through GFCF exchanges) and 13 (OSs in wages-value) of the Excel file.
The purchases of GFCF by the area from all the productive units are given by the program line: FBCFprix[p]=sum(Aefprix[4,p,,]).
A similar program line gives their measure in value. Therefore one can calculate the losses realized by all the productive units from a same country when purchasing GFCF.
The result, i.e. the vector of 44 elements giving the losses coming from the GFCF purchases by each of the 44 areas, is written on line 63 of the sheet 11 of the Excel file. One can verify that the total of the gains made by the whole of the units (sheet 8) is equal to the total of the losses made by the whole of the areas.
We have no matrix Inv, as defined in my communication at Bordeaux. This matrix would have given the purchases of GFCF by each of the 2,464 productive units from the different productive units.
I have estimated these purchases through a matrix of GFCF distribution between the activities for France and for the year 2009, which I have got unofficially and with courtesy from the French statistical office. This matrix gives the distribution of purchases of GFCF by France between the French productive units.
I have supposed that this distribution applied without any difference to all areas for the year 2014.
These estimations are given on the sheet 11 "pertes achats FBCF" of the Excel file. Their totals by area appear on line 58. To allow a comparison I have copied on line 63 the totals of the losses by area got directly (cf. § d). The figures are slighty different. Thus the total of the world losses got by summation of the losses of the 2,464 world productive units is inferior of 2,700 millions of US dollars to the total got by summation of the losses by area. This difference, inferior to 35 hundred thousandths, is absolutely negligible.
Then I introduce the sheet 12 giving the gain of each productive unit when selling GFCF net of its losses when buying GFCF. The total of these net gains should be null at the world level, but as the losses when buying GFCF have been underestimated of 2,700 millions, the sum of these net gains are overestimated of the same figure.
Finally, on the same file Excel, I add the sheet 13
"OS final en valeur" which gives the vector of the final OSs in wages-value of the
different productive units of the world, which I get by adding to the initial OSs vector