 Technical Notes
 Open access
 Published:
Efficient updating of regional supply and use tables with the nationallevel statistics
Journal of Economic Structures volume 11, Article number: 16 (2022)
Abstract
Supply and use tables (SUTs) lay out a detailed picture of the entire economy, providing an overview of the production process and use of commodities. The governmental agencies produce these mainly at the national level to derive components related to the calculation of the gross domestic product (GDP). The national SUTs, however, do not capture the heterogeneity of regions within a country. The regional SUTs, on the other hand, are difficult and costly to compile. In the absence of regularly compiled regional SUTs, analysts typically resort to hybrid models based on mechanically updated tables with less extensive data requirements. However, the approaches currently available in the literature do not necessarily guarantee a consistent structure of the SUTs when there is a mismatch in spatial scale at which sectoral output data are available. Building on the multiregional generalized RAS, this paper proposes a modification to the structure of the benchmark matrix that guarantees the supply–use accounting balance as well as the identity of GDP by income and GDP by expenditure at the regional level in the projected matrix. As a result, the procedure allows for efficient production of regional SUTs appropriate for calculating multiplier effects from the nationallevel statistics.
1 Introduction
Supply and use tables (SUTs) lay out a detailed picture of the entire economy, providing an overview of the production process and use of commodities. SUTs are also a building block of models intended for detailed economic impact assessment, extensively applied in many fields, including assessment of the impact of the natural resource use. The governmental agencies produce these mainly at the national level to derive components related to the calculation of the gross domestic product (GDP).
The national SUTs, however, do not capture the heterogeneity of regions within a single country. This deficiency is problematic as the differences between regions and subnational interdependencies can be substantial. It follows from industries’ diversification in terms of the production structure that may be related to the location, availability of resources, or ability to attract talent. A policy that is targeting a specific sector when the reliance on that sector varies between regions will produce unevenly distributed economic effects.
While it is clear that regional SUTs have a great potential for policymakers who may be interested in the localized effects of their decisions, these are rarely available. Detailed regional tables are often a product of a specific project with a limited sectoral focus, available for a narrow time frame, and rarely set for routine updating. This is because such products are dataintensive, requiring information on the whole range of industries that comprise the region’s economy. Compiling data from all sectors and ensuring its consistency across takes resources and time (Jensen and Macdonald 1982). Values are often available only for an aggregate (Oosterhaven et al. 1986). As a result, timely policy advice based on regional SUTs is rare. Instead, economic impact inputs to policymaking decisions tend to be based on tables updated with limited data using a hybrid approach in which superior information (e.g., focused survey, expert opinion) is incorporated into otherwise mechanically updated tables (Lahr 1993).
The multiregional generalized RAS (MRGRAS) technique described in Temursho et al. (2020) offers an advanced approach to updating a partitioned matrix that needs to conform to new row sums, column sums and, additionally, nonoverlapping aggregation constraints. While using row and column constraints is at the core of more traditional updating methods (e.g., RAS method), adding aggregation constraints provides an opportunity to maximize the utilization of available data by making use of the nationallevel statistics.
Temursho et al. (2020) application of the MRGRAS technique to SUTs, however, does not necessarily guarantee a consistent structure of the updated tables. This technical note proposes a simple modification to the structure of the benchmark matrix that guarantees the supply–use accounting balance as well as the identity of GDP by income and GDP by expenditure at the regional level in the output matrix. As a result, the procedure allows efficient production of tables appropriate for calculating multiplier effects and estimating regional economic impacts.
This note’s contribution also lies in the empirical application, presenting an example of using the MRGRAS method. It demonstrates the farreaching economic impacts of fisheries management policies that alter catch limits for commercial harvesters using the Pacific halibut commercial fishery in Alaska as a case study. The stepbystep instructions on how to apply the approach should be of interest to any researcher working on regional economic analysis, regardless of the focus sector.
2 Materials and methods
The most commonly adopted technique for updating the SUTs is the socalled RAS method method (Stone and Brown 1962; Bacharach 1970; Lahr and de Mesnard 2004). It is a biproportional technique used to estimate a new matrix from an existing one by scaling row and column entries to exogenously given totals. The major shortcoming of this method is that it requires a full set of row and column constraints, something not always available to the analyst (Lenzen et al. 2006). RAS also does not benefit from data available at a higher aggregation level than the original model, while additional information may be available on sums for some submatrices of the projected matrix. Moreover, RAS can only handle nonnegative matrices. In the context of SUTs, certain areas of the partitioned matrix may include negative numbers, for example, columns containing values describing changes in inventories or rows with net taxes, which may be negative if subsidies outweigh tax paid.
The generalized RAS (GRAS) method (GünlükŞenesen and Bates 1988; Junius and Oosterhaven 2003) solves the problem with negative numbers by using reciprocals of the exponential transformations of the related Lagrange multipliers. Approach proposed by Cole (1992); Gilchrist and St. Louis (2004) applies constraints on subgroups of matrix entries. The SUTRAS extension proposed by Temurshoev and Timmer (2011) applies RAS technique to joint projections of SUTs that does not require the availability of the use and supply totals by products, but still guarantees consistency of the output by construction.
Temursho et al. (2020) MRGRAS approach combines number of advantages of the extensions to the original RAS method. It allows updating of a partitioned matrix such as SUTs with nonexhaustive row and column totals and nonoverlapping aggregation constraints. The updated tables incorporate partial information on its components while continuing to conform to available aggregated data. As a result, this technique can make the multiregional model consistent with aggregated national data and include uptodate estimates from a limited number of sectors derived from, for example, a focused survey or statistics published by an agency responsible for a specific sector. Thus, the technique maximizes the potential for the use of data that may be supplied at various sectoral and regional aggregation levels. Moreover, it allows for adjusting SUTs’ positive and negative entries simultaneously. This accommodates the challenge of higher economic heterogeneity of regions within more aggregated economic system that result in more likely occurrence of negative elements within a multiregional SUTs.
The MRGRAS approach is based on triproportional scaling. The algorithm is set to minimize the weighted logarithm of the relative distance between the entries of the new and the old SUTs, subject to row, column and aggregation constraints. To find the solution that accounts for negative entries, the original benchmark matrix serving as an initial input to the scaling procedure is decomposed to a matrix containing positive elements and a matrix containing the negative entries’ absolute values. What follows is the adjustment procedure consisting of a sequence of computations deriving adjustment multipliers that is set to stop when the multipliers converge to a solution conforming to a preset sufficiently low tolerance level.
Adopting the extended MRGRAS technique, as described in Temursho et al. (2020), however, does not necessarily guarantee the consistent structure of the updated tables. Updated SUTs must continue to satisfy the two SUT framework identities, that is, in the estimated matrix total supply by product should be equal to total use by product, and total intermediate input and value added by industry should be equal to sectoral total output. Temursho et al. (2020) application deals with the challenge of the lack of data on total output by product, but not output by both product and industry. To address this shortcoming, this note proposes a simple modification to the structure of the benchmark matrix that imposes the identity of GDP by income and GDP by expenditure at the regional level in the output matrix. As a result, the updated matrix efficiently accommodates nationallevel output data, as well as regional data on GDP components that are often produced by statistical agencies even when there is no attempt to derive the full set of regional SUTs.
2.1 MRGRAS for updating multiregional SUTs
Temursho et al. (2020) describe adopting the MRGRAS technique to multiregional SUTs that is well suited to situations when the supply (at least partially) is known at the regional level. However, it is more likely that more detailed regional statistics are available for components related to the calculation of the GDP, that is final demand and value added, as well as trade. Thus, the paper proposes a modification of the MRGRAS setting for R regions that makes the use of these statistics while at the same time guarantees consistent structure of the projected SUTs. It is written as follows:
Matrix in Eq. 1 represents purchases only type of regionalized national SUT (Oosterhaven 1984), with its core equivalent to the matrix in Temursho et al. (2020). Here, \(S_r\) (r = {1, ..., R}) is the supply matrix of dimension commodity (C) by industry (I), where the subscript indicates the region within the analyzed country. The supply matrices are introduced here with negative signs so that the columns containing these will sum to zero. \(U_{r,s}\) (r, s = {1, ..., R}) is the domestic use matrix of dimension \(C \times I\), where subscripts indicate the commodity origin and where the commodity is used; \({\text{FD}}_{r,s}\) is the domestic final demand of dimension \(C \times\) number of final demand categories (D), with subscripts following these for \(U_{r,s}\); \(U_r^M\) and \({\text{FD}}_r^M\) are use and final demand matrices of the same dimensions, but related to imported products; \({\text{VA}}_r\) is a square matrix with value added values on the diagonal; and \(S_r^d\) is a square matrix with the supply by commodity on diagonal.
Note that the proposed structure implies that rows of the first row section and columns of the first and third column sections sum to zero. Rows of the second row section sum to negative exports by region and commodity, and rows of the third row section sum to imports by region and commodity. \(S_r^d\) matrices are introduced with an intention to preserve the SUT framework consistency in the assembled partitioned matrix.
Equations 2 and 3 summarize the described row (vector u) and column (vector v) sums. E indicates vector of export and M indicates vector of imports. Subscripts indicate each vectors’ length:
3 Application
3.1 Pacific halibut case study
Pacific halibut is distributed on the west coast of the USA and Canada, from California to Alaska. The fish are primarily targeted by the commercial longline fishery and by sport fishers, as well as taken for personal use. The fishery limits are set by the International Pacific Halibut Commission (IPHC) based on annual stock assessment. However, under the Convention establishing the IPHC, the Commission’s mandate is optimum management of the Pacific halibut resource, which necessarily includes also an economic dimension.
3.2 Preparing 3region benchmark SUTs
The model uses as a base the fisheriesfocused multiregional social accounting matrix (MRSAM) model developed by Seung et al. (2020) and describing the US economy in 2014, aggregated to the set of industries and commodities listed in Table 1, and three regions: Alaska (AK), USA West Coast (WC), and the rest of the USA (US).
Equation 4 presents the structure of the benchmark matrix constructed from MRSAM that is used as an updating function input (\(X^0\)). It follows the structure of the matrix proposed in Eq. 1, but specifies regions considered in the model (\(r,s=\{ {\text{ak}}, {\text{wc}}, {\text{us}} \}\)) and separates three value added (VA) categories (employee compensation, proprietor income, other VA components). The final demand (FD) matrices consist of two types of FD, personal consumption expenditures (PCE) and other FD (\({{\text{FD}}^O}\)).
As the MRGRAS technique requires the consistency of constraints, the original model’s trade vectors need to be adjusted. See details in Supplementary data file 1: Table S1 of data file. In the model, fisheries production, including Pacific halibut harvest, is assumed to be supplying the seafood processing industry. This implies a broader scope of the processing sector that also includes product preparation and packaging. Under this assumption, harvested fish are sold to other industries or final users only as a seafood commodity.
3.3 Updating 3region SUTs
This section demonstrates the adoption of the MRGRAS technique for updating the multiregional SUTs described in the previous section using the most recent (2019 and 2020) nationallevel SUTs published by the US Bureau of Economic Analysis (BEA 2021b), complementary regional data on personal consumption and value added by state (BEA 2021c), data on trade in goods by US Census (2020) and fisheriesspecific statistics.
First, the BEA tables are aggregated to the same industries and commodities as those listed in Table 1. BEA tables do not specify fisheries as a distinct industry. Fisheries statistics are used to reallocate fisheries production (supply), as well as input to the seafood processing sector, to align BEA tables with the MRSAM model and incorporate more detailed information on the focus sector. Fisheries production, including landings of Alaskan Pacific halibut, is sourced from commercial fisheries landings database (NOAA 2020).
There is also a mismatch in the allocation of beverages and tobacco production. BEA uses aggregate Food and beverage and tobacco products, while MRSAM includes beverages and tobacco join with other manufacturing products. To accommodate this, the constraints on use and value added by region combine all manufacturing industries (industries 6–8). National supply table is aligned with MRSAM supply tables using supplementary table Gross Output by Industry  Detail Level (BEA 2021a).
MRGRAS technique is applied to the MRSAM model (i.e., the matrix in Eq. 4) using the following aggregation constraints built using data for 2019 and 2020:

1
Supply matrices (\(S_r\)), summed elementwise and with merged columns for industries 1–3 and 6–8 must equal BEAderived supply matrix with the same industries merged (S). Production of fisheries commodities derived from fisheries statistics is assigned to the column describing industries 1–3 in aggregate, and production of manufactured commodities is assigned according to supplementary supply data to the column describing industries 6–8 in aggregate.

2
Domestic and foreign use matrices (all \(U_{r,s}\) and \(U_r^M\) matrices), summed elementwise and with merged columns for industries 1–3 and 6–8 and merged rows for manufactured commodities must equal BEAderived domestic and foreign use matrix with the same industries and commodities merged (\(U^d\) and \(U_r^M\)). As fisheries production is assumed to be supplying the seafood processing industry, the fisheries sector’s output can be assigned directly as input to production by domestic manufacturers.

3
Final demand matrices (all \({\text{FD}}_{r,s}\) and \({\text{FD}}_r^M\) matrices), summed elementwise and with merged manufactured commodities (c6–8) must equal the BEAderived final demand matrices with the same commodities merged (\({\text{FD}}^d\) and \({\text{FD}}^M\)). Note that FD for fisheries commodities is zero by design.

4
Value added matrices (all \({\text{VA}}_r^L\), \({\text{VA}}_r^P\) and \({\text{VA}}_r^O\)) are included in the same form as in the benchmark matrix with the exception of industries that have to be aggregated to align with BEAsupplied data. Value added components (derived from BEA tables SAGDP2, SAGDP4, and SAINC5) are aggregated for industries 1–3 and for industries 6–8. VA matrices with aggregates are marked with stars (*).

5
Diagonals of the \(S_r^d\) matrices summed elementwise must equal BEAderived vector of supply by commodity (diagonal of \(S^d\)). \(S^{*d}\) is \(S^d\) matrix adjusted for aggregation of commodities in \(U^d\) and \({\text{FD}}^d\).
Equation 5 represents the structure of the final aggregation constraints matrix. The full aggregation matrices are available in the Additional file 1: S2 tab.
MRGRAS technique is applied to the original model using the following row and column constraints built based on data for 2019 and 2020:

1
Per model structure, rows of the first row section of \(X^0\) sum to zero.

2
The sum of rows of the second and third row section must equal negative export vectors, and import vectors, respectively, derived from statelevel statistics on trade. By fisheries product definition adopted here, the export and import of commodities c1–2 is zero.

3
The sum of rows of the fourth to sixth row sections must equal vectors with value added components by region. No row constraints are applied for rows containing VA related to aggregated industries. These are derived from aggregation constraints defined in \(W^1\) matrix.

4
Per model structure, columns of the first and third column sections of \(X^0\) sum to zero.

5
In the second column section of \(X^0\), the first column of final demand by each region sums to the final demand by households. These are reported by state in BEA’s table SAEXP1.
Constraints on row (vector u) and column (vector v) sums are summarized by Eqs. 6 and 7:
The output matrix is also adapted to accommodate specific fisheriesrelated data. Fisheries production statistics are used to constraint the supply of commodities 1 and 2. This is done by setting diagonals of subsection \(S_r^d\) of matrix \(X^0\) for commodities 1–2 to zero and fixing the sum of rows related to fisheries output to negative reported fish production. Adopting this constraint requires also adjusting \(W^1\) for consistency.
The updated matrices for 2019 and 2020 are derived using benchmark matrix \(X^0\) and described constraints using the iterative algorithm proposed by Temursho et al. (2020).
3.4 Results
The structure of the updating output (\(X^{2019}\) and \(X^{2020}\)) is the same as the structure of the \(X^0\) matrix. Imposing consistent structure of the regional SUTs results in minimal mismatch between regional supply and use in the projected matrix. Mean absolute difference amounted to USD 0.03 million for 2019 and USD 0.08 million for 2020. In comparison, mean absolute difference between regional supply and use estimated without imposing consistent structure of the regional SUTs was USD 10,738 million, or on average 1.03% total supply for 2019. For 2020, it was USD 14,926 million and 1.47%.
Table 2 compares results for Pacific halibut fishing in Alaska derived from social accounting matrices built from the updated SUTs. Since Pacific halibut is managed using fisheries limits, the economic impact is estimated using a supplydriven approach (Leung and Pooley 2002), using method developed by Tanjuakio et al. (1996). The results suggest considerable decrease in the Pacific halibut’s economic contribution to the United States’ economy from 2019 to 2020.
4 Discussion and conclusions
This paper presents a modification of the MRGRAS method that is making the best use of typically available regional statistics, while guaranteeing consistent structure of the output matrix. The proposed framework focuses on updating regional SUTs when detailed regional statistics are available for components related to the calculation of the GDP, that is final demand and value added, as well as trade. This is a common situation for the analyst to come across. At the same time, the output of the proposed approach guarantees the identity of GDP by income and GDP by expenditure at the regional level. This is a notable advantage as supply–use accounting balance is necessary for deriving any meaningful economic impact assessment estimates.
The paper also offers an elaborate example of updating SUTs for calculating economic impacts at the regional level. While the IPHC’s focus is establishing harvest limits that permit the optimum yield from the fishery and maintain the stock at the sustainable level, understanding the human dimension is part of its optimum management of the natural resource.
Few important points regarding the MRGRAS technique and its potential for informing decisionmaking need to be noted. First, when adopting exhaustive constraints, that is applying a full set of row, column and aggregation constraints, all constraints have to be mutually consistent and consistent with the benchmark input matrix. In case of discrepancies between sources, it is an analyst’s decision what component to adjust instead of the algorithm finding the most efficient solution. Second, the algorithm is only applicable to the cases with nonoverlapping aggregation constraints, that is the disaggregated item can be a part of only one aggregated set. While this type of setup represents a prevalent situation the analyst may come across, overlapping and possibly conflicting constraints require adopting an alternative methodology, for example the KRAS (Lenzen et al. 2009) or generalpurpose constrained optimization solver. Third, MRGRAS signpreserving property should be carefully considered when applying the method. Shifts between positive and negative values may occur from year to year. If such transition or fluctuations are expected, redefining variables may be the best option. For example, one may consider separating taxes and subsidies instead of adopting net tax to guarantee that the signs match.
Abbreviations
 BEA:

US Bureau of Economic Analysis
 FD:

Final demand
 GDP:

Gross domestic product
 GRAS:

Generalized RAS
 IPHC:

International Pacific Halibut Commission
 MRGRAS:

Multiregional generalized RAS
 PCE:

Personal consumption expenditures
 MRSAM:

Multiregional social accounting matrix
 SUTs:

Supply and use tables
 VA:

Value added
References
Bacharach M (1970) Biproportional matrices and inputoutput change. Cambridge University Press, Cambridge
BEA (2021a) Industry economic account data: GDP by industry. https://www.bea.gov/data/gdp/gdpindustry
BEA (2021b) Inputoutput accounts data. https://www.bea.gov/industry/inputoutputaccountsdata
BEA (2021c) Regional Data: GDP and Personal Income. https://www.bea.gov/data/economicaccounts/regional
Cole S (1992) A note on a Lagrangian derivation of a general multipropotional scaling algorithm. Regional Sci Urban Econ 22(2):291–297. https://doi.org/10.1016/01660462(92)90017U
Gilchrist D, St Louis LV (2004) An algorithm for the consistent inclusion of partial information in the revision of inputoutput tables. Econ Syst Res 16(2):149–156. https://doi.org/10.1080/0953531042000219277
GünlükŞenesen G, Bates JM (1988) Some experiments with methods of adjusting unbalanced data matrices. J R Stat Soc Series A 151(3):473–490. https://doi.org/10.2307/2982995
Jensen RC, Macdonald S (1982) Technique and technology in regional inputoutput. Ann Region Sci 16:27–45. https://doi.org/10.1007/BF01284245
Junius T, Oosterhaven J (2003) The solution of updating or regionalizing a matrix with both positive and negative entries. Econ Syst Res 15(1):87–96. https://doi.org/10.1080/0953531032000056954
Lahr M, de Mesnard L (2004) Biproportional techniques in inputoutput analysis: table updating and structural analysis. Econ Syst Res 16(2):115–134. https://doi.org/10.1080/0953531042000219259
Lahr ML (1993) A review of the literature supporting the hybrid approach to constructing regional inputoutput models. Econ Syst Res 5(3):277–293. https://doi.org/10.1080/09535319300000023
Lenzen M, Gallego B, Wood R (2006) A flexible approach to matrix balancing under partial information. J Appl InputOutput Anal 12:1–24
Lenzen M, Gallego B, Wood R (2009) Matrix balancing under conflicting information. Econ Syst Res 21(1):23–44. https://doi.org/10.1080/09535310802688661
Leung P, Pooley S (2002) Regional economic impacts of reductions in fisheries production: a supplydriven approach. Mar Resour Econ 16(4):251–262. https://doi.org/10.1086/mre.16.4.42629336
NOAA (2020) Annual commercial landing statistics. https://foss.nmfs.noaa.gov/apexfoss/f?p=215
Oosterhaven J (1984) A family of square and rectangular interregional inputoutput tables and models. Region Sci Urban Econ 14:565–582. https://doi.org/10.1016/01660462(84)900334
Oosterhaven J, Piek G, Stelder D (1986) Theory and practice of updating regional versus interregional tables. Papers Region Sci 59(1), 45https://doi.org/10.1111/j.14355597.1986.tb00982.x
Seung CK, Waters E, Taylor ML (2020) Developing a MultiRegional Social Accounting Matrix (MRSAM) for Southwest Alaska Fisheries. NOAA Technical Memorandum NMFSAFSC 399, https://repository.library.noaa.gov/view/noaa/22942
Stone R, Brown A (1962) A computable model of economic growth. New York, Chapman and Hall
Tanjuakio RV, Hastings SE, Tytus PJ (1996) The economic contribution of agriculture in Delaware. Agric Resour Econ Rev 25(1):46–53. https://doi.org/10.1017/S106828050000006x
Temursho U, Oosterhaven J, Cardenete MA (2020) A multiregional generalized RAS updating technique. Spatial Econ Anal https://doi.org/10.1080/17421772.2020.1825782
Temurshoev U, Timmer MP (2011) Joint estimation of supply and use tables joint estimation of supply and use tables. Papers Region Sci 90(4):863–882. https://doi.org/10.1111/j.14355957.2010.00345.x
US Census (2020) USA Trade® Online. https://usatrade.census.gov/
Acknowledgements
The author thanks colleagues at the IPHC and three anonymous reviewers for helpful comments on earlier draft of the manuscript.
Funding
The author declares no external funding.
Author information
Authors and Affiliations
Contributions
The author confirms sole responsibility for the following: study conception and design, data collection, analysis and interpretation of results, and manuscript preparation. The author read and approved the final manuscript.
Corresponding author
Ethics declarations
Ethics approval and consent to participate
Not applicable.
Consent for publication
Not applicable.
Competing interests
The author declares no conflict of interest.
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Supplementary Information
Additional file 1.
See details in Supplementary data file, tab S1.
Rights and permissions
Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/.
About this article
Cite this article
Hutniczak, B. Efficient updating of regional supply and use tables with the nationallevel statistics. Economic Structures 11, 16 (2022). https://doi.org/10.1186/s40008022002748
Received:
Revised:
Accepted:
Published:
DOI: https://doi.org/10.1186/s40008022002748