INTRODUCTION
The Social Accounts’ Reports and the Balance Sheets both contain a wealth of information about the specified study region. Provided below are definitions and descriptions of many of the terms and categories found within the tables. From the Regions screen, click the View Region Details button or click the name of the region. Note that all the data in Region Details is nominal; it is not adjusted for inflation.
SOCIAL ACCOUNTS’ REPORTS
Reports are the first set of dashboards under Social Accounts.
COMMODITY SUMMARY
- Industry Commodity Production = the total Output of this Commodity that is produced by Industries. Some Commodities are produced by more than one Industry – this value includes the sum of the production of this Commodity by all Industries.
- Institutional Commodity Production = the total Output of this Commodity that is produced by Institutions (i.e., produced and/or sold by Government or taken out of Inventory).
- Total Commodity Supply = Industry Commodity Production + Institutional Commodity Production.
- Local Use of Local Supply = Total Commodity Supply – Foreign and Domestic Exports of the commodity from the region. Exports can be found in the Commodity Trade table.
- Intermediate Commodity Demand = total demand for this Commodity by Industries.
- Institutional Commodity Demand = total demand for this Commodity by Institutions (Inventory, Government, Households, Capital).
- Total Gross Commodity Demand = Intermediate Commodity Demand + Institutional Commodity Demand. The term “gross” refers to the fact that these figures include imports (both foreign and domestic) of the Commodity into the region.
- Domestic Supply/Demand Ratio = the percentage of total local demand for the Commodity that could possibly be met by local production. It is calculated by dividing Total Commodity Supply less Foreign Exports by Total Gross Commodity Demand, constrained to a maximum of 100%.
- Average RPC = the proportion of local demand for the Commodity that is currently met by local production. It is “average” in the sense that there is just one RPC per Commodity, so all Industries and Institutions are assumed to purchase that Commodity locally at the same rate.
- Average RSC = the proportion of local supply of the Commodity that goes to meet local demand.
COMMODITY TRADE
Commodity Exports
- Foreign Exports = Output value of local production of this Commodity that is exported to international regions.
- Domestic Exports = Output value of local production of this Commodity that is exported to other regions of the U.S.
- Industry Exports = value of exports (both foreign and domestic) from the region for use by other Industries as an input.
- Institutional Exports = value of exports (both foreign and domestic) out of the region demanded by Institutions (Inventory, Government, Households, Capital).
- Total Exports = Foreign Exports + Domestic Exports.
- Foreign Export Proportion = the percentage of Total Exports that go to foreign countries. It is calculated by dividing Foreign Exports by Total Exports.
Commodity Imports
- Intermediate Imports = value of imports (both foreign and domestic) into the region for use by Industries as an input.
- Institutional Imports = value of imports (both foreign and domestic) into the region for final use by Institutions (Inventory, Government, Households, Capital).
- Domestic Imports = Output value of this Commodity that is Imported from other regions of the U.S.
- Foreign Imports = Output value of this Commodity that is imported from international regions.
- Total Imports = Intermediate Imports + Institutional Imports.
- Foreign Import Proportion = the percentage of Total Imports that come from foreign countries. It is calculated by dividing Foreign Imports by Total Imports.
INSTITUTION LOCAL COMMODITY DEMAND
This table lists each Institution’s demand for local production of each Commodity. The sum across all Institutions for a particular Commodity is the total local Institutional demand for local production of that Commodity. Foreign Exports and Domestic Exports are the same as reported in the Commodity Trade screen.
HOUSEHOLD LOCAL COMMODITY DEMAND
This table lists each Household type’s demand for local production of each Commodity. The sum across all Household types for a particular Commodity is equivalent to the “Households” value on the Institution Local Commodity Demand screen.
GOVERNMENT LOCAL COMMODITY DEMAND
This table lists each Government type’s demand for local production of each Commodity. The sum across all six Government types for a particular Commodity is equivalent to the “Government” value on the Institution Local Commodity Demand screen.
SOCIAL ACCOUNTS’ BALANCE SHEETS
The Balance Sheets provides detailed information about the Industries and Commodities in the Region.
INDUSTRY BALANCE SHEET
On all of the Balance Sheets, the default Industry or Commodity is always Oilseeds. In order to see the Industry or Commodity of interest, click the Filter button to make a selection, then click Refresh.
Commodity Production
- Commodity Production = the Output value of each of the Commodities produced by this Industry or Institution.
- Market Share = the proportion of Commodity Production that is produced by this Industry. If there is more than one producer of a Commodity, this Industry’s Market Share for that Commodity will be less than 100%.
- Byproduct Coefficient = the proportion of this Industry’s total Industry Output that is dedicated to each Commodity. If the Industry makes more than one Commodity, each Byproduct Coefficient will be less than 100%.
Commodity Demand
- RPC = the proportion of local demand for the Commodity that is currently met by local production. This is the same value as that found in the Commodity Summary table.
- Gross Absorption = the proportion of Total Industry Output for this Industry that goes toward purchases of each Commodity. Gross Absorption is calculated as Gross Inputs/Total Industry Output. Total Gross Absorptions will be less than one, with the remainder of Total Industry Output going toward Value Added.
- Gross Inputs = the value that this Industry spends on each Commodity.
- Regional Absorption = the proportion of Total Industry Output for this Industry that goes toward local purchases of each Commodity. Regional Absorption can be calculated as Gross Absorption * RPC.
- Regional Inputs = the value that this Industry spends locally on each Commodity. Regional Inputs can be calculated as Gross Inputs * RPC.
Value Added
- Value Added Coefficient = the proportion of Total Industry Output that goes toward each category of Value-Added. Each Value Added Coefficient can be calculated by dividing Value Added by Total Industry Output. The Total Value-Added Coefficient + Total Gross Absorption = 1.00.
- Value Added = the dollar value paid to each category of Value Added.
COMMODITY BALANCE SHEET
Industry-Institutional Production
- Industry Production = the total Output of this Commodity that is produced by the Industry listed in each row.
- Regional Market Share = the proportion of Industry Production that is produced by the Industry/Institution listed in each row. If there is more than one producer of this Commodity, each Market Share will be less than 100%.
- (Byproduct) Coefficient = the proportion of each Industry’s total Industry Output that is dedicated to this Commodity. If the Industry/Institution makes more than one Commodity, the Byproduct Coefficient will be less than 100%.
Industry Demand
- RPC = the proportion of local demand for the Commodity that is currently met by local production. This is the same value as that found in the Commodity Summary dashboard.
- Gross Absorption = the proportion of Total Industry Output for each Industry that goes toward purchases of this Commodity. Gross Absorption is calculated as Gross Inputs/Total Industry Output.
- Gross Inputs = the value that each Industry spends on this Commodity.
- Regional Absorption = the proportion of Total Industry Output for each Industry that goes toward local purchases of this Commodity. Regional Absorption can be calculated as Gross Absorption * RPC.
- Regional Inputs = the value that each Industry spends locally on this Commodity. Regional Inputs can be calculated as Gross Inputs * RPC.
Institutional Demand
- RPC = the proportion of local demand for the Commodity that is currently met by local production. This is the same value as that found in the Commodity Summary dashboard. Note that if Institutions purchase this Commodity from local retailers, the retail margin portion of the purchase will have a high RPC; however, the producer portion of the purchase price will have a low RPC if there is little local production of that Commodity.
- Gross Demand = the amount that each Institution spends on this Commodity.
- Regional Demand = the amount that each Institution spends locally on this Commodity. Note that this value has already been margined (that is, if the Institution buys this Commodity from a retailer, this value only shows the portion of that purchase amount that goes to local producers of the Commodity). Regional Demand can be calculated as Gross Demand * RPC.
IXC SOCIAL ACCOUNTING MATRIX
Details on these tables can be found in the article: Summary Description of Elements of the IxC and the IxI Social Accounting Matrix.
SORTING
The title bar displayed across the top of each Social Account table contains buttons that can change the viewing attributes of the table. Column titles act as sorting buttons. Initially most views are sorted by Industry or Commodity code in ascending value (first row is 1 last row is 546). To change the way all fields in the table are arranged, click on the title of the desired column. All data in the table will be sorted in descending order (highest values listed at the top of the table) relative to the column title. To change how the data is sorted, click on another field. When the view has been sorted by a column other than Industry Code, the selected column title will appear with an arrow to its right indicating that the table has been sorted by this column header.
DOWNLOADING
The download function allows data to be exported as a CSV or PDF by clicking on the Dashboard Actions icon in the upper right corner of the table.
This will prompt a popup. Click download.
Written August 30, 2023