Constructing enterprise input-output tables - a case study of New Zealand dairy products
© Lenzen, Lundie; licensee Springer. 2012
Received: 31 August 2012
Accepted: 3 September 2012
Published: 5 September 2012
Skip to main content
© Lenzen, Lundie; licensee Springer. 2012
Received: 31 August 2012
Accepted: 3 September 2012
Published: 5 September 2012
We describe an efficient method for estimating enterprise input-output tables for cases when only information on marginal totals is available. In order to estimate the production structure of enterprises, we utilize engineering knowledge to construct a qualitative prior containing 1 wherever an output may require an input, and 0 otherwise. This qualitative prior is then scaled by the total enterprise turnover, and subsequently reconciled using the RAS method in order to meet accounting rules. We demonstrate the usefulness of this method in an application to dairy product manufacturing in New Zealand, where we estimate the input-output tables for 22 production sites. Our analysis is carried out in units of mass, and hence the accounting rules are mass balance requirements.
JEL Classification:Q560, C650, L660.
Perhaps one of the unconventional uses of input-output analysis is its application to processes and networks within firms. Nevertheless, so-called enterprise models have been constructed for more than 40 years (Farag ). A true enterprise model is different from single-region input-output models where the inputs and outputs of a firm augment the table by one sector (Tiebout ; Billings and Katz ; Joshi ). Rather, the firm is appraised as a system in its own right, and represented as a table distinguishing functional units of the firm as row and column sectors (Grubbstrom and Tang ; Lave ). Perhaps the most comprehensive and at the same time pioneering work is that of Polenske (), who demonstrated the usefulness of an enterprise input-output model that is embedded in the nested system of regional and national input-output tables. Since then, a number of interesting enterprise input-output models and their applications have been published worldwide (Correa and Craft ; Marangoni and Fezzi ; Li et al.; Lenzen et al.[2010a]), notably by Albino and colleagues (Albino et al.; Albino and Kühtz ). Polenske’s basic idea was taken up again in recent input-output-based hybrid life-cycle approaches, where a so-called foreground system containing interdependent production processes is embedded in a national input-output table (Heijungs and Suh ; Suh ).
Our work is about employing an enterprise model of the dairy industry in an assessment of life-cycle input coefficients of dairy products. Our approach is motivated by the fact that, given a growing population and demand for food and at the same time limited land resources for cultivation, the food sector - including the dairy industry - faces increasing pressure to move toward more resource-efficient production as measured in the context of life-cycle systems (Flysjö ). Therefore, standards and guidelines have been developed (for example, ISO 14044 ; IDF ), and efforts have been made to quantify the resource and environmental impacts of the dairy industry (Berlin ; Lundie et al.; de Vries and de Boer ; Nilsson et al.). More recently, the industry and retailers have started to systematically quantify and publish the environmental impacts of their products. These industry activities have so far concentrated on carbon accounting, that is, carbon footprinting and carbon labeling (Carbon Disclosure Project ). These carbon-related reporting and labeling activities are predominantly based on the methodology of life-cycle assessment (ISO 14044 ).
In particular, we investigate whether enterprise input-output approaches can be employed to deal with the multi-functionality issue in environmental Life-Cycle Assessment, which has been identified as a significant methodological problem (ISO 14044 , Ciroth et al.). When assessing the environmental performance of products, the general situation is that most processes that constitute part of a production system are multi-functional: (1) they may produce more than one product (co-production), or (2) they may treat two or more waste inputs (combined waste treatment), or (3) they may treat one waste input and produce one valuable output. Combinations of these main types, involving three or more of the above basic functions on both the input and output side may also occur (Heijungs and Suh ). Multi-functionality is especially present in dairy manufacturing systems. For example, the input of raw milk on a whole-of-plant basis needs to be allocated to the final products: skim milk powder, butter and buttermilk powder.
ISO 14044 (, Section 4.3.4) states that in all such cases the materials and energy flows as well as associated environmental releases shall be allocated to the different products according to clearly stated procedures. Several approaches for dealing with the multi-functionality problem have been developed, for example, through system boundary expansion and by allocation (or partitioning) using physicochemical, economic, mass and energy approaches (see, for example, Cederberg and Stadig ; IDF ; Feitz et al.; Weidema [2003, 2004]).
Enterprise input-output tables, the basic ingredient of the studies listed above, are usually constructed based on data gathered during firm surveys. Such surveys usually gather data on inputs and outputs for various sub-processes or sub-branches of the firm, which are then collated into a complete input-output table. It is the aim and also the novelty of this work to demonstrate a semi-survey method for constructing enterprise input-output tables solely from marginal totals. In this respect, our method resembles early matrix balancing methods described by Deming and Stephan (), Stephan (), Friedlander (), and Bacharach (), and in fact, our work makes use of the widely known RAS matrix balancing technique (Bacharach ).
In this paper we have applied this balancing approach to resolve the problem of allocation of inputs to products of multi-product processing sites in the dairy industry. Dairy products manufacturing requires a number of primary inputs such as raw milk, ingredients, chemicals, energy carriers and water. Dairy manufacturing plants usually produce more than one product as the fat content in raw milk usually exceeds the required fat content of milk powders, cheeses or fresh milk products (for example, market milk, yogurt or dairy desserts). Therefore, excess milk fat is normally further processed into butter or anhydrous milk fat (AMF). The primary input raw milk is also transformed into intermediate products such as lactose and whey, which may in turn be transformed into other intermediate products. Finally, a number of outputs emerge, such as milk, butter, cheese, and cream, but small fractions of substance also end up in solid waste and waste water. Dairy manufacturing plants consequently produce a wide variety of products, but resource use or emissions data are typically only available on a whole-of-factory basis. Data collection for each unit process within the plant is resource-intensive, and there is typically insufficient metering to collect the required information. In addition, many of the unit processes are shared for producing different products (for example, pasteurization/separation or spray drying). Such aggregation of data poses problems when undertaking the Life Cycle Assessment (LCA) for a selected product within a multi-product setting. To compare the life cycle of one dairy product to another, therefore, requires determination of the material consumption and process energy (electricity and fuel) demand in addition to emissions from a plant for each product.
In short, dairy products manufacturing represents an input-output system of interdependent sectors. Whereas in an economic system the sectors are industries that are interconnected by money transactions measured in currency units, in our dairy products manufacturing system the sectors are substances that are interconnected through mass flows measured in mass units.
The aim of our study is to compile a representative enterprise input-output table for the New Zealand dairy products industry. To this end, we construct input-output tables for all 22 dairy manufacturing enterprises owned by Fonterra in New Zealand from (a) a qualitative prior matrix, and (b) data on total inputs and outputs of products. The qualitative prior is a binary matrix with entries initially set to one where an input may be required to produce an output, and zero where this is not the case. As the raw data, these tables are expressed in mass units, and therefore, a mass balance has to be imposed on the whole enterprise system. This requirement forms the basis for applying the RAS matrix balancing approach. The resulting 22 enterprise input-output tables are aggregated into one table representative for the entire industry. In order to ascertain the quality of this enterprise table, we examine the level of variance in input-output coefficients across all single manufacturing sites. As a further test of quality, we aggregate our micro-level coefficients so that we can compare them (a) with macro-level data from input-output tables, and (b) with a bottom-up process-type life-cycle assessment of a dairy processing system (Feitz et al.).
We first explain our methodology and then our data sources in the following two sections. Thereafter, we present our results and conclude.
Hypothetical enterprise input-output table (thin frame), including a qualitative prior for intermediate mass flows (bold frame) and primary and final mass flows (thin frame), as well as marginal row and column sums (total inputs and outputs), for a dairy manufacturing site
In a sense, the above definitions are reminiscent of definitions for the components of monetary input-output tables such as value added, intermediate demand and final demand, and in fact, the concept of mass flow in physical input-output tables is not fundamentally different from the concept of circulating money in an economy. As with monetary input-output tables, all intermediate outputs are also intermediate inputs, if not in practice then in principle, and hence our intermediate mass flow matrix is square and symmetrical.
As mentioned in the introduction, we construct the 22 enterprise input-output tables based only on two sets of data: (a) a qualitative prior matrix, and (b) data on total inputs and outputs of products. Table 1 lists hypothetical total inputs and outputs in the bottom row and right-hand column. Totals of intermediate inputs and outputs are equal, because we assume matter cannot be lost anywhere in the system. Totals for primary inputs must not equal those for final outputs, because primary inputs are being transformed by the system into outputs, and final outputs are being produced by the system from transformed inputs. However, the total across all primary inputs is equal to the total across all final outputs, once again because matter cannot be lost. The qualitative prior in Table 1 (thin frame) is a binary matrix with entries set to 1 where an input may be required to produce an output, and 0 where this is not the case. The identity of 0s and 1s is determined solely on the basis of engineering knowledge. Such a qualitative prior is useful for fixing the input structure in cases where information on intermediate flows is completely absent (see Table 3.30 in Müller () for an example of applying the qualitative prior method to the construction of SAMs).
Hypothetical enterprise input-output table with a scaled qualitative prior
Hypothetical, fully balanced enterprise input-output table for a dairy manufacturing site
The shaded element is the one where primary input 1 could have been used in principle, but appears not to have been used in practice, for producing intermediate output 1. This serves to show the utility of RAS to derive solely from data on totals, and a mass-balance condition, how inputs are best allocated across co-products in a complex production system.
We undertake a number of diagnostic analyzes on the 22 enterprise tables constructed as described in the previous section. Let be the balanced enterprise input-output tables for the sites. In order to control the different sizes of manufacturing sites, we calculate input-output coefficients according to , where denotes the diagonalization of a vector containing gross substance output of manufacturing site is a summation operator, and the prime ′ denotes transposition. In input-output economics parlance, A is called a direct requirements matrix. It is commonly referred to as the production recipe, because it is independent of production scale.
In order to fulfill our main aim, a representative enterprise input-output table for the New Zealand dairy products industry, we derive a combined table A by taking a weighted average over all 22 enterprises, where , and is total mass turnover of enterprise s. As a result, enterprises influence the weighted average according to their size. In addition we calculate relative and absolute standard errors for each element of .
Finally, we use in order to calculate the classical Leontief inverse , where I is an identity matrix with the same dimensions as . The elements of L then represent the total (direct and indirect) mass requirement of substance i to produce substance j.
In order to enable the comparison with Feitz et al. (), we require an additional normalization step; we write the elements of a normalized Leontief inverse as . This unusual way of normalization was chosen by representatives of the Australian Dairy Processing Industry because the preference was to release relative figures rather than absolute figures. Therefore, results were reported in relation to the reference product milk powder.
To achieve our stated aims, we first collected data in mass and energy units on all intermediate and primary inputs, and on intermediate and final outputs for the manufacturing sites. Before starting with the onsite data collection we developed a questionnaire, asking for information on throughputs of various inputs and outputs. The questionnaire lists, for example, intermediate outputs such as AMF, cheese whey, casein fines (43 in total). These intermediate outputs are identical with the intermediate inputs. Primary inputs asked for (52 in total) are, for example, ingredients (such as salt), chemical usage (caustic, nitric acid, triplex sodium hypochlorite), energy (electricity usage, thermal energy consumption from black coal, lignite, gas, oil, LPG and biogas, cogenerated steam and waste heat), packaging (for example, kraft liner, cardboard, polypropylene, steel drums, nitrogen and carbon dioxide usage), refrigerant use (R22 and ammonia), and town water usage. Final outputs asked for (29 in total) are milk powders (skim and whole milk powder, butter milk powder, nutritionals, specialty powders, different types of MPC), cheese (dry salt and brine salt cheese, mozz type cheese and cream cheese), fat products (butter, fat blend), casein-based products (casein and caseinate) and whey products (whey powder, whey protein concentrate, whey fractions, lactose, lactalbumin, alamin and ethanol). Final outputs also include milk solids to waste, wastewater discharged to sewer and solid waste.
The data collection was predominantly done by site visits. Relevant data were extracted from onsite meters, data management systems (for example, SAP, Excel) and financial accounts (for example, expenditure data allow backtracking to mass and energy flows). Obtaining high-quality data is challenging as the majority of the mass and energy flows are captured only on a whole-of-plant basis, for example, thermal and electrical energy consumption and town water demand are usually not measured for separate processing steps. However, there are also mass inputs that can be allocated directly (in the qualitative prior) to specific products, for example, salt to cheese, or low density polypropylene for packing cheese. An additional challenge is caused by the intermediate product transfers between sites. There is a large variation of these product transfers among individual sites, while the overall amount of product transfers for all sites is only compared to the total quantity of final products.
Second, we set up a qualitative prior on the basis of extensive interviews with experts from the dairy industry. The qualitative prior reflects the structure of mass flow of all inputs and outputs. In addition to the scaling described above, we also weight the qualitative prior (with weights ranging between 0.001 and 1) in order to suppress some connections and emphasize others (compare with a weighting procedure applied by Müller and Djanibekov () for estimating an agricultural model).
Dairy processing is ultimately a milk solids concentration process. Therefore, we start with identifying those intermediate and final outputs that require direct raw milk and whole milk as a primary input. This is straightforward for final outputs such as butter, different types of whey products, powders, cheeses and milk concentrates, but more complex for intermediate outputs, mainly due to the choice of intermediate product names and the variety of how processing sites manufacture their dairy products. For raw milk and whole milk inputs, we have identified 23 intermediate outputs in total, such as cream, homogenized milk, skim milk and whey cream. In these cases 1 is set where an input is required to produce an output, and 0 where this is not the case. A small fraction of milk solids enters the waste stream, that is, wastewater discharged to sewer or municipal household waste.
Some of the primary inputs are ingredients that can be allocated directly to final products: for example, lactose goes into milk powders, salt is used for butter, cheese and MPC, and acetic is used for MPC. In these cases we weight the qualitative prior elements with 0.01 because these ingredients can be expected to contribute less to final products than to intermediate products. Direct allocation is also possible for the majority of cleaning agents (caustic, nitric acid, triplex sodium hypochlorite), for example, triplex being used for cleaning caseinate processing equipment. Packaging material consists of the actual material (kraft liner, cardboard, polypropylene, steel drums) in which the product is contained in and - in the case of powders - nitrogen and carbon dioxide gas that is filled in the packaging material together with the product. Paper, paper cases and LDPE are assumed to be required for all products, while HDPE and some LDPE can be directly attributed to butter and cheese.
Energy inputs (electrical and thermal) are not subject to mass flow constraints as all other inputs. Therefore, we used additional process information for allocating electrical and thermal energy consumption to the final products.
Intermediate inputs are products that are required for producing intermediate and final dairy products. In total there are 43 intermediate inputs, and in our system these are transformed into intermediate outputs in 196 combinations. For example, AMF is potentially used in AMF, beta serum, butter rework, colostrums cream and milk, cream (high-fat and organic), whey AMF serum and whey cream. In addition, intermediate inputs are also used for producing final products that are sold to the market; for example, skim milk concentrate is used for MPC70, cheese dry salt and brine salt, mozz type cheese and cream cheese.
Whilst the above description is nowhere near exhaustive in explaining the entire qualitative prior, it serves as an illustration of the principles followed in constructing such a prior.
We observe some deviations from equality (represented by the diagonal in Figure 4); however, these deviations are almost all smaller than half an order or magnitude, and hence comparable to variations within our sample of dairy manufacturing firms (compare with Figure 2). Considering that the study by Feitz et al. and our study deal with entirely different sets of firms, the agreement between the two is reasonable enough to demonstrate that our results are in the right ballpark. This is especially because this comparison is in terms of aggregates of products (cheese, milk, etc.), which are likely to differ between this study and the one by Feitz et al.
We have described an efficient method for estimating enterprise input-output tables for cases when only information on marginal totals is available. In order to fix the production structure of enterprises, we utilize engineering knowledge to construct a qualitative prior containing 1 wherever an output may require an input, and 0 otherwise. Mass flow balance is accomplished by balancing a scaled prior using the RAS matrix balancing method.
We have demonstrated the usefulness of this method in an application to dairy product manufacturing in New Zealand, where we estimate input-output tables in mass units for 22 dairy manufacturing enterprises.
We encountered only one problem where improvements could be made in future applications. The water mass balances of most sites have been problematic: while the water content of primary input raw milk was always well known, there were discrepancies in metering information for incoming town water and discharged wastewater resulting in inconsistencies of mass balances for many sites. Since town water is such a significant input in mass terms, these discrepancies distorted the adjustment of smaller mass flows of other substances. In the future we recommend paying particular attention to obtaining quality data for important mass flows. In addition, we recommend treating the input of water on a net basis, that is, to exclude all once-through water uses such as for washing equipment and to include only water that is associated with substance transformations.
Having qualified our results, we nevertheless conclude that in contrast to bottom-up methods such as process analysis much labor, time and money can be saved by employing marginal totals, a qualitative prior, and any matrix balancing method. However, interdisciplinary expert judgment is needed to set up the quality prior and the matrix balancing method and to account for the uniqueness of dairy processing sites.
2. Beta serum
3. Butter rework
5. Casein fines
6. Cheese whey
7. Cheese whey concentrate
8. Cheese whey retentate
9. Colostrum Cream
10. Colostrum milk
11. Colostrum permeate
13. Cream fima
14. Cream hi fat
15. Dilute milk permeate
16. Evap milk perm 30%
17. Evap milk perm 45%
18. High fat whey retentate
19. Homog milk
20. Imported Lactose
21. Ion exchange whey
22. Lactalb slurry
23. Lactic whey
24. Lactose slurry
25. Milk perm 18%
26. Mineral acid whey
27. Nano filtered whey
28. Organic Cream
30. Reconstituted lactose
31. Retentate concentrate
32. Retentate concentrate_Gen
33. RO Milk
34. Secondary skim milk
35. Skim milk
36. Skim milk concentrate
37. Skim milk retentate
39. Whey AMF serum
40. Whey cream
41. Whey permeate
42. Whey protein retentate
1. Total MS from raw and whole milk
2. Milk concentrate
4. Lactose only milk powder
5. Ingredients milk powder
6. Salt butter
7. Salt cheese
8. Salt MPC
9. Acetic acid MPC
10. Calcicum hydroxide caseinate
11. Sodiuim hydroxide caseinate
12. Sulphuric acid caseinate
13. Caustic milk treatment
14. Nitric acid milk treatment
15. Triplex milk treatment
16. Sodium hypochlorite milk treatment
17. Caustic demin
18. Nitric acid demin
19. Sodium hypochlorite demin
20. Caustic butter
21. Nitric acid butter
22. Sodium hypochlorite butter
23. Caustic milk powder
24. Nitric acid milk powder
25. Sodium hypochlorite milk powder
26. Caustic MPC42-85
27. Triplex MPC42-85
28. Sodium hypochlorite MPC42-85
29. Caustic dry salt cheese
30. Nitric acid dry salt cheese
31. Triplex dry salt cheese
32. Sodium hypochlorite dry salt cheese
33. Caustic caseinate
34. Triplex caseinate
35. Sodium hypochlorite caseinate
36. Caustic lactose
37. Nitric acid lactose
38. Triplex lactose
39. Sodium hypochlorite lactose
40. Nitrogen usage
41. Carbon usage
42. Town water usage
43. Paper cases
2. Fat Blend
3. Skim milk powder
4. Whole milk powder
5. Butter milk powder
7. Specialty Powders
11. MPC 85
12. Cheese (dry salt)
13. Cheese (brine salt)
14. Mozz type cheese
15. Cream Cheese
18. Whey powder
20. Whey fractions
25. Milk concentrate
27. Milk solids to waste
28. Wastewater discharged to sewer
29. HSW waste (trucked)
The authors are grateful for expert advice and data on mass inputs and outputs for 22 New Zealand dairy manufacturing sites collected by Jim Barnett (Fonterra).
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.