Constructing enterprise input-output tables - a case study of New Zealand dairy products

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 [1967]). 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 [1967]; Billings and Katz [1982]; Joshi [2001]). 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 [2000]; Lave [2006]). Perhaps the most comprehensive and at the same time pioneering work is that of Polenske ([1997]), 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 [1999]; Marangoni and Fezzi [2002]; Li et al.[2008]; Lenzen et al.[2010a]), notably by Albino and colleagues (Albino et al.[2003]; Albino and Kühtz [2004]). 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 [2002]; Suh [2004]).

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ö [2011]). Therefore, standards and guidelines have been developed (for example, ISO 14044 [2006]; IDF [2010]), and efforts have been made to quantify the resource and environmental impacts of the dairy industry (Berlin [2002]; Lundie et al.[2002]; de Vries and de Boer [2010]; Nilsson et al.[2010]). 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 [2011]). These carbon-related reporting and labeling activities are predominantly based on the methodology of life-cycle assessment (ISO 14044 [2006]).

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 [2006], Ciroth et al.[2008]). 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 [2002]). 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 ([2006], 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 [2003]; IDF [2010]; Feitz et al.[2007]; 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 ([1940]), Stephan ([1942]), Friedlander ([1961]), and Bacharach ([1965]), and in fact, our work makes use of the widely known RAS matrix balancing technique (Bacharach [1970]).

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.[2007]).

We first explain our methodology and then our data sources in the following two sections. Thereafter, we present our results and conclude.

We construct an enterprise input-output table in physical units of mass flow for each of the 22 manufacturing sites (schematic in Table 1). We define primary inputs as those inputs that are not supplied by any of the dairy manufacturing sites. Primary inputs (such as raw milk) are used to produce both intermediate outputs (such as whey) and final outputs (such as cheese). We define intermediate inputs as those inputs that are supplied within the dairy manufacturing system. Like primary inputs, intermediate inputs (such as whey) are also used to produce both intermediate outputs (such as whey) and final outputs (such as cheese). Finally, we define intermediate outputs as those outputs that are used again as inputs to produce other outputs, and final outputs as those outputs that end with the consumer and do not enter the production system again.

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 ([2006]) for an example of applying the qualitative prior method to the construction of SAMs).

The construction of the enterprise tables now proceeds in two steps. First, the qualitative prior is scaled so that the sum of all elements equals total mass turnover of the establishment. In our hypothetical example, the qualitative prior will be multiplied by 200/10=20 in order to scale the binary-element total from 10 to the prescribed input and output total of 200 (Table 2). Note that this scaled prior does not balance, that is, row and column sums for intermediate products are not equal as required. This is a common situation encountered by virtually every researcher faced with the task of constructing input-output tables.

Therefore, the second (RAS) algorithm (Bacharach [1965]) is used to balance the scaled prior in order to achieve row and column sum equality. In essence, the exogenously given marginal row and column sums act as constraints on the solution of the RAS algorithm. Together with the scaled prior, they constitute all necessary ingredients for RAS to determine a balanced enterprise input-output table that satisfies all constraints whilst preserving the structure of the scaled prior as much as possible. The fully balanced version of our hypothetical enterprise table is shown in Table 3.

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 {\mathbf{T}}_s be the balanced enterprise input-output tables for the s=1,\dots ,22 sites. In order to control the different sizes of manufacturing sites, we calculate input-output coefficients according to {\mathbf{A}}_s={\mathbf{T}}_s{\widehat{{\mathbf{x}}_s}}^{-1}, where \widehat{{\mathbf{x}}_s} denotes the diagonalization of a vector {\mathbf{x}}_s={\mathbf{T}}_s{\mathbf{1}}^{\prime } containing gross substance output of manufacturing site s,\mathbf{1}=\{1,\dots ,1\} 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 {\mathbf{A}}^{\ast }={\mathbf{\Sigma }}_s{w}_s{\mathbf{A}}_s over all 22 enterprises, where w_s={\mathbf{x}}_s/{\mathbf{\Sigma }}_r{\mathbf{x}}_r, and {\mathbf{x}}_s 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 {\mathbf{A}}^{\ast }.

Finally, we use {\mathbf{A}}^{\ast } in order to calculate the classical Leontief inverse \mathbf{L}={(\mathbf{I}-{\mathbf{A}}^{\ast })}^{-1}, where I is an identity matrix with the same dimensions as {\mathbf{A}}^{\ast }. The elements L_{ij} 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. ([2007]), we require an additional normalization step; we write the elements of a normalized Leontief inverse as L_{n,ij}=L_{ij}/L_{i,\mathrm{m}\mathrm{i}\mathrm{l}\mathrm{k}\mathrm{p}\mathrm{o}\mathrm{w}\mathrm{d}\mathrm{e}\mathrm{r}}. 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 \sim 2\mathrm{\%} 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 ([2009]) 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.

The enterprise input-output matrix {\mathbf{A}}^{\ast } for the New Zealand dairy manufacturing system is reasonably sparse (Figure 1, left plot). This sparsity is of course pre-determined by the non-zero entries in the qualitative prior, because the zero entries are preserved during RAS balancing. Most of the significant elements in {\mathbf{A}}^{\ast } can be found in two particular rows that hold milk solids (row #44) and town water (row #85), which constitutes by far the main mass flows.

Checkerboard plot of {log}_{10}(A_{ij}^{\ast }) and its absolute and relative standard errors. Element magnitude is represented by cell colors. The axes are scaled by sector numbers: rows and columns 1-43 represent intermediate inputs and outputs, rows 44-88 represent primary inputs, columns 44-73 represent final outputs.

Full size image

Some {\mathbf{A}}^{\ast } elements show relatively large relative standard errors of up to 400% (Figure 1, right plot). A closer analysis shows that these large standard deviations are associated with small elements in {\mathbf{A}}^{\ast }. Moreover, Figure 2 reveals an inverse relationship where large elements are associated with small relative standard errors and vice versa. For example, small standard deviations are associated with large elements in {\mathbf{A}}^{\ast }, for example, mass flows of milk solid inputs and town water inputs. This circumstance is well known from statistical analyzes of input-output tables (Lenzen [2000]; Lenzen et al.[2010b]). It means that the proportion of small and unimportant inputs into production processes can vary significantly between enterprises, but that the proportion of large and important inputs is relatively constant. For example, the input of nitric acid into whole milk powder fluctuates between 0.002% and 0.05% of milk powder mass, but the input of raw milk solids into various intermediate and final dairy products ranges only between 5% and 10% of product mass.

Relative standard errors of input-output coefficients as a function of their magnitude.

Full size image

We then aggregated our dairy enterprise input-output table {\mathbf{A}}^{\ast } into the classification of a part of the published monetary New Zealand (Statistics New Zealand [2011]) and Australian (ABS [2009]) input-output tables, and compared the magnitude of coefficients. The sector breakdown of the two monetary input-output tables contains 8 sectors onto which the sectors in our enterprise table can be mapped. Whilst we would not expect a strong similarity between physical (mass) and monetary ($) coefficients, the magnitudes of the relative proportions of inputs agree reasonably well (Figure 3). Areas above the diagonal indicate inputs that are more important in physical terms than in monetary terms, and vice versa for the area below the diagonal. Of course, water supply deviates most strongly from the diagonal, but also basic chemicals are an order of magnitude less expensive for their mass than other inputs. On the other hand, plastic products affect inputs more financially than physically. Interestingly, Australian and New Zealand monetary input coefficients agree reasonably well, except for the monetary input of paper products into dairy manufacturing, which appears to be much smaller in New Zealand than in Australia.

Comparison between monetary and physical input-output coefficients for dairy products. A and ‘o’ symbols = Australia, N and ‘x’ symbols = New Zealand, Ch = Basic chemicals, Dp = Dairy products, Of = Other food products, Pl = Plastic products, Pp = Paper products, Tm = Treated milk, Um = Untreated milk, Wa = Water supply.

Full size image

Finally, we compare our normalized Leontief multipliers {\mathbf{L}}_n with the life-cycle coefficients obtained by Feitz et al. ([2007]) (Figure 4). In Feitz et al. an industry-specific allocation matrix was developed for the dairy manufacturing industry to enable better allocation of resources to dairy products given whole-of-plant information. The allocation matrix was the product of an extensive process to determine average resource use and wastewater emissions for individual dairy products (for example, kL of water per tonne of yogurt) from 17 multi-product manufacturing plants with a similar processing technology. The process involved using initial literature and company estimates for resource efficiency per product (for example, GJ of electricity/tonne of milk powder), normalizing the resource efficiency figures for all products to milk powder, and producing a matrix of life-cycle resource efficiency coefficients.

Comparison between our dairy enterprise input-output multipliers and life-cycle coefficients obtained by Feitz et al. ([2007]). Each marker group represents inputs into up to 9 dairy products (milk powder, milk, cream, butter, AMF/ghee, cheese, whey powder, UHT, WPC/lactose) according to Feitz et al. (x axis) and this study (y axis). Groups including less than 9 markers indicate that inputs are unimportant for some products.

Full size image

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.

A.1 Intermediate inputs and outputs (Table 4)

A.2 Primary inputs (Table 5)

A.3 Final outputs (Table 6)

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).

Affiliations

1. ISA, School of Physics A28, The University of Sydney, Sydney, NSW, 2006, Australia

   • Manfred Lenzen

2. PE INTERNATIONAL, Hauptstraße 111 - 113, 70771, Leinfelden-Echterdingen, Germany

   • Sven Lundie

3. UNSW Water Research Centre, The University of New South Wales, Sydney, NSW, 2052, Australia

   • Sven Lundie

Corresponding author

Correspondence to Manfred Lenzen.

Competing interests

The authors declare that they have no competing interests.

Authors’ contributions

ML developed the methodology and carried out the calculation and generated the quantitative results, while SL was in charge of data collection, populating the qualitative prior matrix. ML and SL interpreted the results and drew the conclusions. All authors read and approved the final manuscript.

Reprints and Permissions