<p>You should try to avoid mixing data sets unless you have a good way to bridge them. There are very precise methodologies used to construct each data set and mixing them can lead to nonobvious problems. You might consider looking at the <a href="https://www.bea.gov/industry/input-output-accounts-data" rel="nofollow noreferrer">BEA's IO tables at a more disaggregated level</a>. For example, the Use table shows Personal Consumption Expenditures at a granularity that you might be interested in. For example, in the screenshot below it shows that in 2012, households consumed \$32 billion worth of goods from the &quot;Vegetable and melon farming&quot; product category.</p>
<p><a href="https://i.sstatic.net/ttNDd.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ttNDd.png" alt="enter image description here" /></a></p>
<p>At this level of disaggregation, you can see how much households purchased from different kinds of product categories: restaurant goods, from frozen foods, from snack food manufacturing, etc. You can also see how much each of these industries purchased from each other product type category, etc. Continuing with the example, you'll see that the Vegetable and melon farming industry purchased
\$106 billion worth of goods from &quot;Farm machinery and equipment manufacturing&quot; product category.</p>
<p><a href="https://i.sstatic.net/IeMqW.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/IeMqW.png" alt="enter image description here" /></a></p>
<p>Note that I haven't stated that the Vegetable and melon farming industry necessarily produces goods in the Vegetable and melon farming product category. To get that information, you would have to explore the <a href="https://www.bea.gov/industry/input-output-accounts-data" rel="nofollow noreferrer">BEA supply tables.</a> For those interested, more information is in the answer to this other question: <a href="https://economics.stackexchange.com/a/47689/59">https://economics.stackexchange.com/a/47689/59</a></p>
<p>Hope this helps.</p>
<p>The link to the spreadsheet from the BEA is given here: <a href="https://apps.bea.gov/industry/xls/io-annual/Use_SUT_Framework_2007_2012_DET.xlsx" rel="nofollow noreferrer">https://apps.bea.gov/industry/xls/io-annual/Use_SUT_Framework_2007_2012_DET.xlsx</a></p>

CC BY-SA 4.0
2021-09-27T01:25:16.717Z
2021-09-27T16:30:48.620Z
2021-09-27T16:30:48.620Z
jmbejara
<p>From the <a href="https://www.bls.gov/opub/reports/consumer-expenditures/2019/home.htm" rel="nofollow noreferrer">2019 Consumer Expenditure Survey</a>, the average household annual food expenditure was $8,169 for that year. There are subcategories such as &quot;Food at Home&quot; and &quot;Food away from Home,&quot; but for simplicity, I'll keep the scope to annual household food expenditures.</p>
<p>I want to partition this $8,169 into the <a href="https://apps.bea.gov/iTable/iTable.cfm?5205=sum&amp;5206=10&amp;isuri=1&amp;reqid=52&amp;step=102#5205=sum&amp;5206=10&amp;isuri=1&amp;reqid=52&amp;step=102" rel="nofollow noreferrer">BEA industries</a> (aggregation level is &quot;summary&quot;) for the ultimate goal of assessing pollution impact. That is, if buying bread is related to a farm purchasing harvesting equipment, maybe some of those dollars should be allocated towards both farms and industrial machinery.</p>
<p>Here are a few immediately relevant BEA industry summaries:</p>
<ul>
<li>111CA: Farms</li>
<li>113FF: Forestry, Fishing &amp; Related activity (the fish is sold to markets?)</li>
<li>311FT: Food and Beverage &amp; tobacco</li>
<li>445: Food and Beverage Stores</li>
<li>722: Food services and Drinking places</li>
</ul>
<p>In my studies of the Leontief Input/Output model, one thought is just to pile all $8,169 into 311FT and let the &quot;recipe&quot; tell me how much that 111CA contributed, but that feels contradictory since it predicts 0 final demand at the household level for 111CA, when clearly that industry has a large GDP number.</p>
<p>So what is the best way to &quot;attribute&quot; the household expenditures on food into those industries?</p>

<macroeconomics><gdp><input-output><food>
How could you partition Household Food Expenditures into Producing Industries?
Ben Ogorek
# How could you partition Household Food Expenditures into Producing Industries?

(Asked by: username_0 on 2021-09-25)

From the [2019 Consumer Expenditure Survey](https://www.bls.gov/opub/reports/consumer-expenditures/2019/home.htm), the average household annual food expenditure was $8,169 for that year. There are subcategories such as "Food at Home" and "Food away from Home," but for simplicity, I'll keep the scope to annual household food expenditures.

I want to partition this $8,169 into the [BEA industries](https://apps.bea.gov/iTable/iTable.cfm?5205=sum&5206=10&isuri=1&reqid=52&step=102#5205=sum&5206=10&isuri=1&reqid=52&step=102) (aggregation level is "summary") for the ultimate goal of assessing pollution impact. That is, if buying bread is related to a farm purchasing harvesting equipment, maybe some of those dollars should be allocated towards both farms and industrial machinery.

Here are a few immediately relevant BEA industry summaries:

* 111CA: Farms
* 113FF: Forestry, Fishing & Related activity (the fish is sold to markets?)
* 311FT: Food and Beverage & tobacco
* 445: Food and Beverage Stores
* 722: Food services and Drinking places

In my studies of the Leontief Input/Output model, one thought is just to pile all $8,169 into 311FT and let the "recipe" tell me how much that 111CA contributed, but that feels contradictory since it predicts 0 final demand at the household level for 111CA, when clearly that industry has a large GDP number.

So what is the best way to "attribute" the household expenditures on food into those industries?

**Tags:** macroeconomics, gdp, input-output, food

---

## 1 answers

### Answer by username_1 on 2021-09-27. Score: 4 | Accepted answer

You should try to avoid mixing data sets unless you have a good way to bridge them. There are very precise methodologies used to construct each data set and mixing them can lead to nonobvious problems. You might consider looking at the [BEA's IO tables at a more disaggregated level](https://www.bea.gov/industry/input-output-accounts-data). For example, the Use table shows Personal Consumption Expenditures at a granularity that you might be interested in. For example, in the screenshot below it shows that in 2012, households consumed \$32 billion worth of goods from the "Vegetable and melon farming" product category.

[![enter image description here](https://i.sstatic.net/ttNDd.png)](https://i.sstatic.net/ttNDd.png)

At this level of disaggregation, you can see how much households purchased from different kinds of product categories: restaurant goods, from frozen foods, from snack food manufacturing, etc. You can also see how much each of these industries purchased from each other product type category, etc. Continuing with the example, you'll see that the Vegetable and melon farming industry purchased
\$106 billion worth of goods from "Farm machinery and equipment manufacturing" product category.

[![enter image description here](https://i.sstatic.net/IeMqW.png)](https://i.sstatic.net/IeMqW.png)

Note that I haven't stated that the Vegetable and melon farming industry necessarily produces goods in the Vegetable and melon farming product category. To get that information, you would have to explore the [BEA supply tables.](https://www.bea.gov/industry/input-output-accounts-data) For those interested, more information is in the answer to this other question: <https://economics.stackexchange.com/a/47689/59>

Hope this helps.

The link to the spreadsheet from the BEA is given here: <https://apps.bea.gov/industry/xls/io-annual/Use_SUT_Framework_2007_2012_DET.xlsx>


---

