Appendix A.

Appendix A . Table 1. Raw single-ingredient beef products affected by nutrition labeling 

requirements.

Types of Product

Beef consumed at home All beef Processed Ground Stew Steak

Beef 

dish

Other 

cuts

Pounds/capita 43.13 6.46 13.81 6.6 9.68 3.88 2.69

Percent of product subject 

labeling requirements 0.0 0.0 100 100 0.0 100

Total amount1 (billion lbs.) 5.47 1.903 2.792 .776

1. Based on a U.S. population in 2002 of 288.4 million

Source: Christopher Davis and Biing-Hwan Lin. “Factors Affecting U.S. Beef Consumption”. LDP-M-135-02. 

Economic Research Service, USDA. October, 2005. Washington, DC. 

The total amount of beef consumed per capital is 67.5 pound annually. Of that amount, 

43.13 pounds is consumed at home. It is assumed that consumers purchase beef consumed at 

home from grocery stores or other retail establishments. Cooked or multi-ingredient beef dish 

products (that are not ground or chopped) are not subject to the rule. The amount of product 

subject to the rule is accounted for elsewhere. The total amount of raw, single-ingredient beef 

product subject to the rule is estimated at 5.47 billion pounds.

Discussion of Appendix A Table 1. 

Appendix A. Table 2. Raw, single ingredient pork products affected by nutrition labeling 

requirements.

Types of Product

Fresh Pork

Total 

Fresh

Chops Steak Ribs Fresh 

Ham

Fresh 

Nonspecified

Offal

Pounds/capita 19.2 5.5 1.9 1.9 2.5 6.7 0.8

Percent consumed at home 81.8

Percent of product subject 

labeling requirements 100 100 .25 0.0 0.0 0.0

Amount1 (billion lbs.) 1.858 1.298 .448 .112

1. Based on a U.S. population in 2002 of 288.4 million

Source: Christopher Davis and Biing-Hwan Lin. “Factors Affecting U.S. Pork Consumption”. LDP-M-130-1 

Economic Research Service, USDA. May, 2005 Washington, DC.

Total annual per capita pork consumption is 51.5 pounds. Of this amount 19.2 pounds is 

purchased as raw, single-ingredient product. The remainder is cooked or mult-ingredient product 

and is not subject to the rule. Nearly 82 percent of fresh product is consumed at home. The 

remainder is consumed at a food service establishments. All major cuts of single- ingredient, 

raw pork and beef products are subject to the rule, unless an exemption applies. FSIS assumes 

that twenty-five percent of fresh (raw) ribs are subject to the rule as the remainder is assumed to 

be sold with ingredients, such as sauces, added. Fresh non-specified products are assumed to 

largely (67%) consist of ground or chopped product.

Discussion of Appendix A. Table 2.

Appendix A. Table 3. Raw, single-ingredient chicken products affected by nutrition labeling 

requirements.
Total

Grocery and 

retail outlets2

Food service, fast 

food outlets3

Deboned for further 

processing, including 

ground4

Ground5

Share of broilers for major markets

Percent of total1 25 29 46

Pounds/capita 20.25 23.49 37.26 1.86

Percent of product 

subject to labeling 

requirements 

80 0.0 50

Amount6 (billion 

pounds)

10.103 4.730 5.373

1 Source: National Chicken Council. http://www.nationalchickencouncil.com/statistics

2 Primarily fresh, unprepared parts/portions prepackaged for supermarkets’ meat department. Size ranges from 

4.21 to 5.25 pounds, liveweight. 

3 Primarily cup-up parts for fried chicken and similar. May also include Cornish hens. Size is 4.2 pounds and 

smaller, liveweight. 

4 May also include young, heavy roasters for retail grocery, Size is 5.26 pounds and larger, liveweight.

5 Ground chicken is assumed to be 5% of the category: “Deboned for further processing, including ground,” 

6 Total consumption is based on a total U.S. population of 288.4 million. 

Discussion of Appendix A. Table3.

Total annual per capita chicken consumption is 82 pounds. Of this amount 20.25 pounds is 

purchased from grocery stories and other retail outlets. Half of the broilers deboned for further 

processing are assumed to be single-ingredient raw product. The remainder is cooked or multiingredient product and is not subject to the rule. Based on this information, total annual 

consumption of single-ingredient chicken products is 10.1 billion pounds.

 

Appendix A. Table 4. Raw, single-ingredient turkey products affected by nutrition labeling 

requirements.

Grocery and 

retail outlets

Commodity 

outlets

Food service 

outlets

Exports

Share of Product Distribution

Percent of total1 46.8 27.7 15.1 10.5

Percent of Domestic Consumption 52.3 30.9 16.7

Pounds/capita 9.26 3.24 2.96

Percent of product subject to 

labeling requirements 80 0.0 0.0

Amount2 (billion pounds) 2.136

1 Source: National Turkey Federation at http://www.eatturkey.com/consumer

2 Total consumption is based on a total U.S. population of 288.4 million.

Discussion of Appendix A. Table 4.

Total annual per capita turkey consumption is 17.7 pounds. Of this amount, 9.26 pounds is 

purchased from grocery stories and other retail outlets. Eighty percent of turkey products sold at 

these establishments are assumed to be single-ingredient products. The total amount of major 

cuts of single-ingredient turkey products subject to labeling requirements is estimated at 2.136 

billion pounds.
Appendix A. Table 5. Derivation of Lives Saved for Composite Scenario

Year 1 2 3 4 5 6 7 8 9 10 AverageYears 1-10

Scenario 1 0.0 0.0 28.6 28.6 28.6 28.6 28.6 57.2 57.2 57.2 31.5

Scenario 2 0.0 0.0 0.0 0.0 0.0 28.6 28.6 28.6 28.6 28.6 14.3

Scenario 3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 28.6 28.6 5.7

Composite 0.0 0.0 9.5 9.5 9.5 19.1 19.1 28.6 38.2 38.2 17.2

Year 11 12 13 14 15 16 17 18 19 20 AverageYears 1-20

Scenario 1 57.2 57.2 114.5 114.5 114.5 114.5 114.5 114.5 114.5 114.5 67.3

Scenario 2 57.2 57.2 57.2 57.2 57.2 114.5 114.5 114.5 114.5 114.5 50.1

Scenario 3 28.6 28.6 28.6 57.2 57.2 57.2 57.2 57.2 114.5 114.5 32.9

Composite 47.7 47.7 66.8 76.3 76.3 95.4 95.4 95.4 114.5 114.5 50.1

Appendix A. Table 6. Derivation of the Value of Lives Saved for the Composite Scenario

Year Value 

of 

Life

1 2 3 4 5 6 7 8 9 10 Present Value

3 

percent

7 

percent

$Million

Scenario 1 5.0 0.0 0.0 47.7 47.7 47.7 95.4 95.4 143.1 190.8 190.8

Scenario 2 5.5 0.0 0.0 52.5 52.5 52.5 105.0 105.0 157.4 209.9 209.9

Scenario 3 6.5 0.0 0.0 62.0 62.0 62.0 124.0 124.0 186.1 248.1 248.1

Composite 5.6 0.0 0.0 54.1 54.1 54.1 108.1 108.1 162.2 216.3 216.30

Year 11 12 13 14 15 16 17 18 19 20

Scenario 1 5.0 238.5 238.5 333.9 381.7 381.7 477.1 477.1 477.1 572.5 572.5

Scenario 2 5.5 262.4 262.4 367.3 419.8 419.8 524.7 524.7 524.7 629.7 629.7

Scenario 3 6.5 310.1 310.1 434.1 496.1 496.1 620.1 620.1 620.1 744.2 744.2

Composite 270.3 270.3 378.5 432.5 432.5 540.7 540.7 540.7 648.8 648.80 3,694.4 2,176.7
 Appendix B. Table 1

Cost Estimates of Signage for Major Cuts of Meat and Poultry Products - Retail Stores (see note #1 below)

Labor Costs (assume recur every 2 years)

Small Stores Large Stores Total Stores

 Number of affected stores 51,431 23,479 74,910 Source: see # Stores Table

 Hourly wage estimates $21.11 $21.11 $21.11 Source: U.S. Dept. of Labor, 2002

 Number of hours per store 0.5 0.5 0.5 Source: see note #3 below

 Total labor costs $542,854 $247,821 $790,675

Signage Costs (assume recur every 2 years)

Small Stores Large Stores Total Stores

 Number of affected stores 51,431 23,479 74,910 Source: see # Stores Table

 Signs (3 total per store) $28.00 $28.00 $28.00 Source: see note #4 below

 Sign frames (3 total per store) (3 @ $12.39) $37.17 $37.17 $37.17 Source: see note #5 below

 Sign cost per store $65.17 $65.17 $65.17

 Total signage costs $3,351,758 $1,530,126 $4,881,885

Total Costs (assume recur every 2 years) $3,894,612 $1,777,947 $5,672,560

Notes:

(1) We assume these costs recur every two years because signs and frames wear out and need replacement.

(2) Retail Diagnostics Inc. (RDI) Survey October 1999

(3) Assumes minimum time 0.3 hours; most-likely time 0.5 hours; maximum time 0.7 hours, in a triangular distribution

(4) FMI website (FMI.org); one sign each for (1) beef & veal, (2) pork & lamb, and (3) poultry; prices for non-members - 2006 costs include shipping costs

(5) Hubert.com for 8.5x11 inch metal frames with stem - 2006 costs include shipping costs
 Appendix B. Table 2

Cost Estimates for Labeling Ground Product: Processing Establishments

Cost of Redesigning Labels (one-time) Fed. Large & Small State Small

Number of small and large establishments that grind meat 1,008 41 Source: PBIS, April 2006 (see # Plants Table)

Number of companies that own grinding establishments 363 41 Source: see note #3 below

Average number of products per company 6.6 6.6 Source: Based on IRI scanner data (see note #1 below)

 Total number of prepackaged ground products 2,398 271

Fed-Inspected Large & Small Firms State-Insp. Small Firms

Low Mid High Low Mid High

Per label costs of redesigning labels $929 $1,557 $2,383 $929 $1,557 $2,383 Source: FDA Label Costs Table

Per label costs of nutrition analysis $599 $690 $787 $599 $690 $787 Source: FDA Label Costs Table

$1,528 $2,247 $3,170 $1,528 $2,247 $3,170 

 Total One-Time Costs $3,664,522 $5,387,394 $7,602,515 $413,519 $607,935 $857,898 

Cost of Larger Labels (ongoing) Fed. Large & Small 0.0500% State Small Source: see note #9 below

Number of packages of ground M&P packaged by processors 484,105,275 242,053 Source: See Package Volume Table

Cost per label for larger label $0.005 $0.005 Source: See note #2 below

 Total Ongoing Costs $2,420,526 $1,210

Notes:

(1) IRI scanner data

 IRI scanner data includes data on frozen ground meat and poultry products=3.3 products/company

 Assumed companies would produce an equal number of fresh ground meat and poultry products=6.6 products/company

(2) Average cost of blank label. Minimum cost of $0.002; most-likely cost of $0.005; maximum cost of $0.008 of a triangular distribution.

 Blank labels that will be printed on-site. Purchased in quantities. Includes labor cost to apply printed label to package.

(3) Based on estimate of 3 establishments per federally-inspected company, Muth et al., 2003, JAFIO; 

 plus small state-inspected establishments/companies PBIS 2006

(4) National Cattlemen's Beef Association (NCBA) National Meat Case Study in 2004

(5) Ongoing costs for larger labels could be reduced if establishments print nutrition facts directly on product overwrap.

(6) Med values are taken as the most likely value of a triangular distribution

(7) Low values are taken as the minimum value of a triangular distribution

(8) High values are taken as the maximum value of a triangular distribution

(9) The proportion of packages associated with small firms is unknown but expected to be small
 Appendix B. Table 3

Cost Estimates for Labeling Ground Product: Retail Stores

Option 1: Assume nutrition facts will be printed using a scale printer.

 Cost of Upgrading or Replacing Scale & Printer Systems (recur after 5 years)

 Number of affected retail stores of large firms 23,479 Source: See # Stores Table

 Number of scale printers for M&P products 1.5 Source: NCBA study by D. Amstein

 Total number of scale printers in retail stores of large firms 35,219

 Cost of upgrading or replacing scale & printer systems (per system) $1,600 Source: NCBA study by D. Amstein

 Total upgrade or replacement costs $56,349,600 $2,400 per store

 Cost of Redesigning Larger Blank Store Labels for Use in Scale & Printer Systems (one-time)

 Number of affected grocery stores & meat market firms 255 Source: See # Stores Table

 Number of affected warehouse store firms 11 Source: See # Stores Table

 Total # affected retail firms 266

Low Mid High

 Label redesign costs $929 $1,557 $2,383 Source: See FDA Label Costs Table

 Total label redesign costs $247,231 $414,074 $634,003

 Cost of Nutrition Analysis (one-time)

 Number of affected grocery stores & meat market companies 255 Source: See # Stores Table

 Number of products packaged in the store/company 4.6 Source: See Store Counts Table

 Total affected grocery stores & meat market products 1,166 rounded value

 Number of affected warehouse store companies 11 Source: See # Stores Table

 Number of products packaged in store/company 1.3 Source: See Store Counts Table

 Total affected warehouse store products 15

 Total number of store packaged unique labels 1,180 rounded value

Low Mid High

 Per label costs of nutrition analysis $599 $690 $787 Source: See FDA Label Costs Table

 Total of above per label change (one-time) $1,528 $2,247 $3,170 

 Total nutrition analysis costs $706,716 $814,406 $928,827 

 Total One-Time 1st Year Costs $57,303,547 $57,578,080 $57,912,429 

 Number of scale printers 35,219 Source: See above calculation at cell B8

 Annual maintenance cost per scale printer $144 Source: See note #5 below.

 Number of packages of ground M&P packaged by retailers 1,452,315,826 Source: See Package Volume Table

 Cost of larger label $0.005 Source: See note #2 on Ground-Plants Table

 Total Ongoing Costs $12,333,043

Coments: Cost to upgrade scale and printer systems per store is $2,400 (1,600 x 1.5)

 
Option 2: Assume nutrition facts will be preprinted on a sticker applied at retail.

 Cost of Designing Separate Nutrition Facts Stickers (one-time)

 Total number of store packaged unique labels 1,180 rounded value Source: See above under Cost of Nutrition Analysis

Low Mid High

Per label costs of redesigning labels $929 $1,557 $2,383 Source: See FDA Label Costs Table

Per label costs of nutrition analysis $599 $690 $787 Source: See FDA Label Costs Table

 Total One-Time Cost of Above per Label $1,528 $2,247 $3,170 

 Total One-Time Costs $1,803,808 $2,651,867 $3,742,229

Number of packages of ground meat & poultry packaged by retailers 1,452,315,826 Source: See Package Volume Table

Low Mid High

Cost of Purchasing and Applying Labels 0.0160 0.0293 0.0422 Source: See FDA Sticker Costs Table

 Total Ongoing Costs $23,187,420 $42,510,270 $61,281,038

Notes:

(1) Low values are taken as the minimum value of a triangular distribution of costs

(2) Med values are taken as the most likely value of a triangular distribution of costs

(3) High values are taken as the maximum value of a triangular distribution of costs

(4) National Cattlemen's Beef Association National Meat Case Study in 2004

(5) RTI's Label Model; Hobertcorp.com, 2003; 6% of $2400 (cost of maintenance agreement per store)
 Appendix B. Table 4

Numbers of Active Federally-Inspected and State-inspected Establishments that Grind Meat and Poultry:

Establishment Size Number of Active Federally-Inspected Establishments Source: See note #1 below

Very Small 1,433

Small 858

Large 109

 Total 2,400

Establishment Size Number of Active State Establishments Source: See note #2 below

Very Small 632

Small 41

Large 0

 Total 673

Notes:

(1) Source: FSIS PBIS, April 2006. These federally-inspected establishments have 03B HACCP codes for grinding meat or poultry.

(2) Source: FSIS PBIS, April 2006. These state-inspected establishments have 03B HACCP codes for grinding meat or poultry.

 About 41 state-inspected establishments/companies are small and could potentially be affected.
 Appendix B. Table 5

Number of Retail Firms and Establishments (Stores), 2002

NAICS Code Description Firm Size Category # Firms # Establishments (Stores) Sales ($1000s)

NAICS 445110 Supermarkets and other grocery (except convenience) stores 500-999 110 1,245 11,135,953

1000+ 143 19,189 299,476,731

 Sub-total Large 253 20,434 310,612,684 0.78589586 proportion of sales for large firms

 Total All Sizes 42,318 66,150 395,233,897

NAICS 445210 Meat Markets 500-999 1 46 1,327,181 0.3 proportion of sales for 500-999 sized firms (estimated)

1000+ 1 96 1,769,575 0.4 proportion of sales for 1000+ firms (estimated)

 Sub-total Large 2 142 3,096,757 0.7 proportion of sales for large firms (estimated)

 Total All Sizes 5,354 5,848 4,423,938 756,487 per establishment, on average

NAICS 452910 Warehouse Clubs & Superstores 500-999 2 5 164,627 32,925,301 per establishment (estimated), on average

1000+ 9 2,898 190,835,042 65,850,601 per establishment, on average

 Sub-total Large 11 2,903 190,999,669 0.99867857 proportion of sales for large firms

 Total All Sizes 16 2,912 191,252,396

Total affected for ground product labeling Total Large 266 23,479 504,709,109 0.85412146 proportion of sales for large firms

Total affected for POP labeling Total All Sizes 47,688 74,910 590,910,231

Total large & non-compliant wavered Large & Small 12,122 0.854 proportion of sales for large firms

Source: U.S. Department of Commerce, U.S. Bureau of the Census - 2002 Economic Census. November 2005. "Establishment and Firm Size: Retail Trade." EC02-44SS-SZ. 

Note: Estimates are made when the Census could not disclose because too few firms are in the size category.

 For meat markets, sales for the 500-999 and 1000+ categories (yet are estimated) also not disclosed, thus we included them with the sub-total for large.

 For warehouse stores, sales for the 500-900 category were not disclosed (yet are estimated) but are included in the total.
 Appendix B. Table 6

Per Unit Cost Estimates for Designing/Redesigning Labels (assume one color change, flexography printing method):

2001 Costs 2005 Costs

Low Mid High inflator Low Mid High

Administrative Costs $120 $280 $440 1.140416 $137 $319 $502 

Graphic Design $300 $450 $600 $342 $513 $684 

Prepress Activities $245 $352 $550 $279 $401 $627 

Engraving $150 $283 $500 $171 $323 $570 

 Total/SKU $815 $1,365 $2,090 $929 $1,557 $2,383 

NLEA Panel Analysis $525 $605 $690 $599 $690 $787 

Totals of above $1,340 $1,970 $2,780 $1,528 $2,247 $3,170 

Source: Muth, M.K., E.C. Gledhill, and S.A. Karns. January 2003. "FDA Labeling Cost Model." Prepared by RTI International for FDA/CFSAN.

Notes:

(1) Estimates are per unique package or label (or SKU) and are in 2001 dollars.

(2) Assumed one-color change because the FDA labeling cost model assumes one color for nutrition facts and ingredient lists.

(3) Assumed flexography printing method because this was the most common method we found in examining ground meat labels and packages.

(4) Assumed no discarded inventory costs because manufacturers could deplete existing labels/packaging within the compliance period.

(5) Assumed no market testing costs for redesigned labels.

(6) Administrative costs include paperwork burden costs.

(7) Inflator is the PPI for 2005 divided by the PPI for 2001 (PPI for total manufacturing industries, U.S. Department of Labor, extracted 2/06)

(8) NLEA panel analysis costs include the costs of preparing and shipping a refrigerated sample to the testing lab.

(9) Mid values are taken as the most likely value of a triangular distribution of costs

(10) Low values are taken as the minimum value of a triangular distribution of costs

(11) High values are taken as the maximum value of a triangular distribution of costs
 Appendix B. Table 7

Costs of Pressure Sensitive Labels:

2001 Prices 2006 Prices

Low Mid High inflator Low Mid High

Sticker Costs $0.010 0.015 $0.020 1.140416 $0.011 $0.017 $0.023

Application Costs $0.004 0.011 $0.017 $0.005 $0.012 $0.019

 Total/Label $0.014 $0.026 $0.037 $0.016 $0.029 $0.042

Source: Muth, M.K., E.C. Gledhill, and S.A. Karns. January 2003. "FDA Labeling Cost Model." Prepared by RTI International.

Notes:

(1) Cost are per label.

(2) Assumed labels would be applied manually ($15/hour loaded wage).

(3) Inflator is the PPI for 2006 divided by the PPI for 2001 (PPI for total manufacturing industries, U.S. Department of Labor, extracted 3/06)

(4) Mid values are taken as the most likely value of a triangular distribution of costs.

(5) Low values are taken as the minimum value of a triangular distribution of costs.

(6) High values are taken as the maximum value of a triangular distribution of costs.
 Appendix B. Table 8

Ground Meat and Poultry Package Volume Estimates

Pounds of ground beef purchased/U.S. household 49.3 Source: NCBA's Meat Purchase Diary 2003

Number of U.S. households (millions), 2003 112.0 Source: US Census Bureau 2003 Estimate

 Total pounds ground beef (millions) 5,521.6

Other ground meat products, as a fraction of ground beef 0.123 Source: Based on AMI estimate of .123 pounds of other ground M&P for every pound of ground beef 

Total pounds of other ground meat products (millions) 679.2

 Total pounds ground meat and poultry (millions) 6,200.8

Average weight per package of meat and poultry (pounds) 2.7 rounded Source: NCBA's Meat Purchase Diary 2003

 Total packages of ground meat and poultry (millions) 2,267.1

% sales from large company stores 85.4% Source: % sales from large company stores (see # Stores Tab)

Number of packages produced by non-exempt entities (millions) 1,936.4 Source: Total packages * % sales from large company stores (see # Stores Tab)

Proportion of packages sold as case ready 0.25 Source: NCBA's February 2001 survey of 7 major retail chains (cited in AMI's comments)

Proportion of packages packaged at retail 0.75 Source: NCBA's February 2001 survey of 7 major retail chains (cited in AMI's comments)

Total Packages of Ground M&P Packaged by Processors (millions) 484.1 rounded 484,105,275 packages

Total Packages of Ground M&P Packaged by Retailers (millions) 1,452.3 rounded 1,452,315,826 packages

 check-sum total for pages: 1,936.4 rounded 1,936,421,101 packages

Note:

(1) In their comments the Animal Protection Unit estimates that 18.5% of ground beef is already ground when it arrives at the store.

 This percentage appears consistent with the NCBA data (25%) if you include poultry, which is almost always ground before it arrives at the store.
 Appendix B. Table 9

Store Count Data: Ground Products

Store Brands Safe Handling Nutrition Facts

# 

Products

# 

Pkg'd 

at 

store

# Not 

Pkg'd 

at 

store

Total 

Store 

Brands

# 

National 

Brands

# on 

Label

# on 

Packaging

# 

Without

# on 

Label

# on 

Packaging

# 

Without

Grocery Stores

 Harris Teeter 17 2 9 11 6 14 3 0 14 2 1

 Lowe's 8 2 2 4 4 5 3 0 3 3 2

Food Lion 10 4 3 7 3 9 1 0 5 1 4

Kroger 12 6 0 6 5 7 5 0 1 5 6

Whole Foods 8 8 0 8 0 8 0 0 2 0 6

Piggly Wiggly 8 5 0 5 3 5 3 0 2 3 3

Weaver 

Street

5 5 0 5 0 5 0 0 0 0 5

 Averages 9.7 4.6 2.0 6.6 3.0 7.6 2.1 0.0 3.9 2.0 3.9

 Median 8.0 5.0 0.0 6.0 3.0 na na na 2.0 2.0 4.0

 Std.Dev. 3.86 2.15 3.32 2.37 2.31 na na na 4.74 1.82 1.95

Club Stores

 CostCo 7 0 2 2 5 2 5 0 0 5 2

 Sam's Club 7 3 0 3 4 3 4 0 0 4 3

 BJ's 6 1 4 5 1 5 1 0 -- -- --

 Averages 6.7 1.3 2.0 3.3 3.3 3.3 3.3 0.0 0.0 4.5 2.5

 Median 7.0 1.0 2.0 3.0 4.0 na na na 0.0 4.5 2.5

 Std.Dev. 0.58 1.53 2.0 1.53 2.08 na na na 0 0.71 0.71

Source: Collected by RTI during April 2003

Note:

(1) "na" means not applicable for the analysis
 Appendix B. Table 10. Summary Report of Simulation Results for Prefered Alternative 3 and Other Alternatives 2, 4, and 5

Name Worksheet Cell Minimum Mean Maximum x1 p1 x2 p2 x2-x1 p2-p1

Output 1 1/all / Present Value of Processing Plant Costs (7%) Alt#3_FirstYrPVCosts K6 4.524489 7.7065 23.32659 5.911853 5% 10.69158 95% 4.779727 90%

Output 2 1/all / Present Value of Processing Plant Costs (3%) Alt#3_FirstYrPVCosts L6 4.698694 8.003221 24.22473 6.139475 5% 11.10323 95% 4.963759 90%

Output 3 1/all / Present Value of Option 1 Retail + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts M6 70.79372 79.59664 138.2949 73.76441 5% 90.81413 95% 17.04971 90%

Output 4 1/all / Present Value of Option 1 Retail + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts N6 73.51948 82.66132 143.6197 76.60455 5% 94.31071 95% 17.70617 90%

Output 5 1/all / Present Value of Option 2 + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts O6 26.62024 62.33791 301.1663 37.74284 5% 112.2358 95% 74.493 90%

Output 6 1/all / Present Value of Option 2 + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts P6 27.64519 64.73809 312.762 39.19603 5% 116.5572 95% 77.36119 90%

Output 7 1/only small / Present Value of Processing Plant Costs (7%) Alt#3_FirstYrPVCosts K7 0.3478134 0.5319847 0.7402734 0.4523729 5% 0.6180986 95% 0.1657256 90%

Output 8 1/only small / Present Value of Processing Plant Costs (3%) Alt#3_FirstYrPVCosts L7 0.3757022 0.574641 0.7996309 0.4886457 5% 0.6676598 95% 0.1790141 90%

Output 9 1/only small / Present Value of Option 1 Retail + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts M7 3.622322 3.931981 4.274684 3.780463 5% 4.08602 95% 0.3055565 90%

Output 10 1/only small / Present Value of Option 1 Retail + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts N7 3.912772 4.247261 4.617443 4.083593 5% 4.41365 95% 0.3300567 90%

Output 11 1/only small / Present Value of Option 2 + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts O7 3.622322 3.931981 4.274684 3.780463 5% 4.08602 95% 0.3055565 90%

Output 12 1/only small / Present Value of Option 2 + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts P7 3.912772 4.247261 4.617443 4.083593 5% 4.41365 95% 0.3300567 90%

Output 13 TOTALS / 6. Present Value of Option 1 Retail Costs (cols. a+d) (7%) Alt#3_PVCosts G28 238.854 312.7741 862.6877 260.3061 5% 411.0768 95% 150.7707 90%

Output 14 TOTALS / 7. Present Value of Option 1 Retail Costs (cols. a+d) (3%) Alt#3_PVCosts H28 320.7396 424.5332 1196.648 350.8678 5% 562.5464 95% 211.6786 90%

Output 15 TOTALS / 8. Present Value of Option 2 Retail Costs (cols. a+e) (7%) Alt#3_PVCosts I28 183.4665 564.3593 3150.617 299.0769 5% 1100.977 95% 801.8998 90%

Output 16 TOTALS / 9. Present Value of Option 2 Retail Costs (cols. a+e) (3%) Alt#3_PVCosts J28 255.8609 790.7017 4422.095 418.2226 5% 1544.257 95% 1126.034 90%

Output 17 TOTALS / 10. Present Value of Processing Plant Costs (cols. b+c) (7%) Alt#3_PVCosts K28 9.876256 35.28122 211.0778 17.769 5% 68.09151 95% 50.32251 90%

Output 18 TOTALS / 11. Present Value of Processing Plant Costs (cols. b+c) (3%) Alt#3_PVCosts L28 12.21997 47.69666 294.6017 23.10007 5% 93.85428 95% 70.75421 90%

Output 19 TOTALS / 12. Present Value of Option 1 Retail + Processing Plant Costs (cols. 1+3) (7%) Alt#3_PVCosts M28 253.0443 348.0554 1007.507 282.8855 5% 474.7921 95% 191.9066 90%

Output 20 TOTALS / 13. Present Value of Option 1 Retail + Processing Plant Costs (cols. 1+3) (3%) Alt#3_PVCosts N28 338.9907 472.2298 1397.966 380.7655 5% 650.2348 95% 269.4693 90%

Output 21 TOTALS / 14. Present Value of Option 2 Retail + Processing Plant Costs (cols. 2+3) (7%) Alt#3_PVCosts O28 197.8344 599.6406 3311.421 321.0251 5% 1164.679 95% 843.6543 90%

Output 22 TOTALS / 15. Present Value of Option 2 Retail + Processing Plant Costs (cols. 2+3) (3%) Alt#3_PVCosts P28 274.3269 838.3984 4646.199 447.1591 5% 1631.649 95% 1184.49 90%

Output 23 TOTALS / f. Present Value of POP Placards Costs (Retail) (column a) (7%) Alt#3_PVCosts G56 29.34454 31.06861 32.796 29.88411 5% 32.25296 95% 2.368847 90%

Output 24 TOTALS / g. Present Value of POP Placards Costs (Retail) (column a) (3%) Alt#3_PVCosts H56 40.4405 42.81648 45.19704 41.18409 5% 44.44867 95% 3.264576 90%

Output 25 TOTALS / h. Present Value of Modifying Product Labels Costs (Plants) (column b) (7%) Alt#3_PVCosts I56 3.461233 5.037241 6.986729 4.281801 5% 5.857973 95% 1.576172 90%

Output 26 TOTALS / i. Present Value of Modifying Product Labels Costs (Plants) (column b) (3%) Alt#3_PVCosts J56 3.5945 5.231188 7.255736 4.446661 5% 6.08352 95% 1.636858 90%

Output 27 TOTALS / j. Present Value of Larger Labels on Ground or Chopped Meat and Poultry Products Costs (Plants) (column c) (7%) Alt#3_PVCosts K56 4.967961 30.24398 206.231 12.74931 5% 63.10998 95% 50.36067 90%

Output 28 TOTALS / k. Present Value of Larger Labels on Ground or Chopped Meat and Poultry Products Costs (Plants) (column c) (3%) Alt#3_PVCosts L56 6.975498 42.46548 289.5682 17.90126 5% 88.61251 95% 70.71125 90%

Output 29 TOTALS / l. Present Value of Option 1 Labels Printed Costs (Retail) (column d) (7%) Alt#3_PVCosts M56 207.5623 281.7055 831.2629 229.2318 5% 379.9774 95% 150.7457 90%

Output 30 TOTALS / m. Present Value of Option 1 Labels Printed Costs (Retail) (column d) (3%) Alt#3_PVCosts N56 277.6156 381.7167 1153.341 308.0403 5% 519.7181 95% 211.6778 90%

Output 31 TOTALS / n. Present Value of Option 2 Labels Preprinted Costs (Retail) (column e) (7%) Alt#3_PVCosts O56 152.2856 533.2907 3120.23 268.0049 5% 1069.73 95% 801.7252 90%

Output 32 TOTALS / o. Present Value of Option 2 Labels Preprinted Costs (Retail) (column e) (3%) Alt#3_PVCosts P56 212.8896 747.8853 4380.218 375.3708 5% 1501.001 95% 1125.63 90%

Output 33 TOTALS / 1. POP Materials - Undiscounted Costs Alt#2_PVCosts B28 155.7106 165.6335 174.8761 160.6553 5% 170.6187 95% 9.96344 90%

Output 34 TOTALS / 2. Present Value of POP Materials Costs (column 1) Discounted at 3% Alt#2_PVCosts C28 115.8097 123.1899 130.0641 119.4873 5% 126.8977 95% 7.410316 90%

Output 35 TOTALS / 3. Present Value of POP Materials Costs (column 1) Discounted at 7% Alt#2_PVCosts D28 82.47989 87.73607 92.63188 85.09909 5% 90.37672 95% 5.277634 90%

Output 36 17. Present Value Option 1 Labels on Cuts and Ground and Chopped Products Costs (Retail+ Processing Plants) (column 16) (7%) Alt#4_PVCosts AE13 539.8585 813.039 1541.749 673.6125 5% 974.4242 95% 300.8116 90%

Output 37 18. Present Value Option 1 Labels on Cuts and Ground and Chopped Products Costs (Retail+ Processing Plants) (column 16) (3%) Alt#4_PVCosts AF13 719.7699 1103.973 2123.141 907.9171 5% 1330.837 95% 422.9202 90%

Output 38 TOTALS / 4. Present Value of Retail Cuts Costs (column 1) (7%) Alt#5_PVCosts(all) G28 392.3612 589.2578 783.6083 474.1151 5% 704.5154 95% 230.4003 90%

Output 39 TOTALS / 5. Present Value of Processing Plant Cuts Costs (column 2) (7%) Alt#5_PVCosts(all) M28 77.93051 151.3201 226.1671 102.357 5% 200.2057 95% 97.84871 90%

Output 40 Option5TOTALS / Present Value Retail + Processing Plant Costs (7%) Alt#5_PVCosts(all) N28 498.9416 740.5779 977.5933 616.4286 5% 864.6799 95% 248.2513 90%

Output 41 TOTALS / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T28 525.8773 803.3177 1078.437 638.263 5% 968.1425 95% 329.8795 90%

Output 42 TOTALS / 8. Present Value of Processing Plant Cuts Costs (column 2) (3%) Alt#5_PVCosts(all) U28 99.09669 200.636 303.6093 131.9657 5% 269.2901 95% 137.3244 90%

Output 43 Option5TOTALS / Present Value Retail + Processing Plant costs (3%) Alt#5_PVCosts(all) V28 665.6229 1003.954 1339.583 826.8002 5% 1181.181 95% 354.3809 90%

Output 44 TOTALS / 14. Present Value of Option 1 Labels on Ground and Chopped Products Costs (Retail+ Processing Plants) (column 13) (7%) Alt#5_PVCosts(all) AB28 121.2044 215.9573 875.1605 150.8434 5% 342.5892 95% 191.7457 90%

Output 45 TOTALS / 15. Present Value of Option 1 Labels on Ground and Chopped Products Costs (Retail+ Processing Plants) (column 13) (3%) Alt#5_PVCosts(all) AC28 161.9806 294.864 1220.258 203.4353 5% 472.6021 95% 269.1668 90%

Output 46 TOTALS / 17. Present Value Option 1 Labels on Cuts and Ground and Chopped Products Costs (Retail+ Processing Plants) (column 16) (7%) Alt#5_PVCosts(all) AE28 665.9578 956.5352 1651.604 808.3594 5% 1127.418 95% 319.0583 90%

Output 47 TOTALS / 18. Present Value Option 1 Labels on Cuts and Ground and Chopped Products Costs (Retail+ Processing Plants) (column 16) (3%) Alt#5_PVCosts(all) AF28 886.6022 1298.818 2274.423 1088.075 5% 1540.351 95% 452.2767 90%
Input 1 Number of hours per store / Small Businesses Major Cuts B8 0.3008029 0.5 0.6990761 0.3632365 5% 0.636751 95% 0.2735145 90%

Input 2 Number of hours per store / Large Businesses Major Cuts C8 0.3011787 0.5 0.6990944 0.363239 5% 0.6367496 95% 0.2735105 90%

Input 3 Number of hours per store / Total Major Cuts D8 0.3009402 0.5 0.6994433 0.3632387 5% 0.6367446 95% 0.2735059 90%

Input 4 Average number of products per company / Large & Small Firms Ground-Plants B7 5.602516 6.6 7.595329 5.916198 5% 7.283714 95% 1.367516 90%

Input 5 Average number of products per company / Small Firms Only Ground-Plants C7 5.602384 6.6 7.596412 5.916222 5% 7.283737 95% 1.367515 90%

Input 6 Cost per label for larger label / Large & Small Ground-Plants B19 2.01E-03 0.005 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 7 Cost per label for larger label / Small Firm Only Ground-Plants D19 2.01E-03 0.005 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 8 Cost of larger label / Low Ground-Stores B43 2.01E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 9 Administrative Costs / Mid FDA Label Costs C5 120.667 280 439.7722 170.5935 5% 389.4023 95% 218.8088 90%

Input 10 Graphic Design / Mid FDA Label Costs C6 300.7239 450 599.1665 347.4256 5% 552.5579 95% 205.1322 90%

Input 11 Prepress Activities / Mid FDA Label Costs C7 245.206 351.6667 549.0533 260.1247 5% 483.4896 95% 223.3648 90%

Input 12 Engraving / Mid FDA Label Costs C8 150.0575 283.3334 499.8881 179.5797 5% 427.5426 95% 247.963 90%

Input 13 NLEA Panel Analysis / Mid FDA Label Costs C11 525.4388 605 689.8027 549.8729 5% 662.7495 95% 112.8766 90%

Input 14 Sticker Costs / Mid FDA Sticker Costs C4 1.00E-02 0.015 0.0199824 1.16E-02 5% 1.84E-02 95% 6.84E-03 90%

Input 15 Application Costs / Mid FDA Sticker Costs C5 4.02E-03 1.07E-02 1.70E-02 0.006133 5% 1.50E-02 95% 8.89E-03 90%

Input 16 Average weight per package of meat and poultry (pounds) Package Volume B10 0.5000975 2.735976 7.127759 1.171606 5% 4.351544 95% 3.179938 90%

Input 17 labor needed / 1. POP Materials - Undiscounted Costs Alt#2_PVCosts B36 0.300998 0.5 0.6992958 0.3632411 5% 0.6367509 95% 0.2735097 90%

Input 18 manual cost / 1. POP Materials - Undiscounted Costs Alt#2_PVCosts B39 97.5038 100 102.4844 98.29042 5% 101.7094 95% 3.418999 90%

Input 19 Mid Alt#2_PVCosts F57 0.5481475 0.614 0.6798027 0.5688669 5% 0.659126 95% 9.03E-02 90%

Input 20 Most-likely Alt#4_PVCosts C13 0.7504928 0.85 0.9494274 0.7816175 5% 0.9183722 95% 0.1367547 90%

Input 21 recurring labels @$0.005 / 7. Present Value of Retail Costs (column 1) (3%) Alt#5_PVCosts T40 2.01E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 22 label @$0.005 / 7. Present Value of Retail Costs (column 1) (3%) Alt#5_PVCosts T45 2.02E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 23 recurring labels @$0.005 / 7. Present Value of Retail Costs (column 1) (3%) Alt#5_PVCosts T50 2.02E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 24 one-time redesign labels / mid-point Alt#5_PVCosts E54 1333.955 2014.667 2758.056 1541.316 5% 2519.301 95% 977.9844 90%

Input 25 recurring labels @$0.005 / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T40 2.01E-03 5.00E-03 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 26 label @$0.005 / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T45 2.00E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 27 recurring labels @$0.005 / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T50 2.01E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 28 packages @ / OMB mid-year discount factor 7% Alt#5_PVCosts(all) R59 2.02E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%
Appendix B. 

Table 11. Simulation Results for Alternative 3

TOTALS / 12. Present Value of Option 1 Retail 

+ Processing Plant Costs (7%) / M28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stati

stic Value %tile Value

Minim

um 253.0443268 5%

282.885528

6

Maxi

mum 1007.507141 10%

290.556945

8

Mean 348.0553744 15%

296.529327

4

Std 

Dev 68.38035638 20%

301.688812

3

Varia

nce 4675.873139 25%

306.439056

4

Skew

ness 2.726449229 30%

311.130096

4

Kurto

sis 14.45048762 35%

315.749420

2

Medi

an 330.3052979 40%

320.311889

6

Mode 315.6748047 45%

325.131042

5

Left X 282.8855286 50%

330.305297

9

Left P 5% 55%

335.944610

6

Right 

X 474.7921448 60%

342.122436

5

Right 

P 95% 65% 348.750824

Diff X 191.9066162 70%

356.882904

1

Diff P 90% 75%

366.553192

1

#Erro

rs 0 80%

378.794464

1

Filter 

Min 85%

395.336425

8

Filter 

Max 90%

422.024444

6

#Filte

red 0 95%

474.792144

8

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of meat 

and poultry (pounds) / $B$10 -0.768 -0.864

#2 Cost of larger label / Low / $B$43 0.327 0.440

#3

Cost per label for larger label / Large & 

Small / $B$19 0.107 0.149

#4

Number of hours per store / Total / 

$D$8 0.012 0.017

#5 Prepress Activities / Mid / $C$7 0.008 0.000

#6

Average number of products per 

company / Large & Small Firms / $B$7 0.005 0.007

#7 Mid / $F$57 -0.004 -0.002

#8 Sticker Costs / Mid / $C$4 0.004 0.009

#9

Number of hours per store / Small 

Businesses / $B$8 0.000 -0.006

#10

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.010

#11

Average number of products per 

company / Small Firms Only / $C$7 0.000 -0.004

#12

Cost per label for larger label / Small 

Firm Only / $D$19 0.000 -0.003

#13 Administrative Costs / Mid / $C$5 0.000 0.009

#14 Graphic Design / Mid / $C$6 0.000 0.004

#15 Engraving / Mid / $C$8 0.000 0.004

#16 NLEA Panel Analysis / Mid / $C$11 0.000 0.006

 Regression Sensitivity for Cell M28

Std b Coefficients

 

 Sticker Costs / Mid/C4 .004

-.004 Mid/F57

 Average number of products.../B7 .005

 Prepress Activities / Mid/C7 .008

 Number of hours per store .../D8 .012

 Cost per label for larger .../B19 .107

 Cost of larger label / Low.../B43 .327

-.768 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 12. Simulation Results for Alternative 3

TOTALS / 13. Present Value of Option 1 Retail 

+ Processing Plant Costs (3%) / N28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stati

stic Value %tile Value

Minim

um 338.9906921 5%

380.765502

9

Maxi

mum 1397.966431 10%

391.529174

8

Mean 472.2298217 15%

399.881378

2

Std 

Dev 96.01141101 20%

407.133636

5

Varia

nce 9218.191044 25%

413.787170

4

Skew

ness 2.726573257 30%

420.388458

3

Kurto

sis 14.45127701 35%

426.858459

5

Media

n 447.2653809 40%

433.286407

5

Mode 386.9847412 45% 440.00177

Left X 380.7655029 50%

447.265380

9

Left P 5% 55%

455.232299

8

Right 

X 650.2348022 60%

463.901367

2

Right 

P 95% 65%

473.203887

9

Diff X 269.4692993 70%

484.685394

3

Diff P 90% 75%

498.167663

6

#Erro

rs 0 80%

515.384094

2

Filter 

Min 85%

538.659484

9

Filter 

Max 90%

576.070861

8

#Filte

red 0 95%

650.234802

2

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of meat 

and poultry (pounds) / $B$10 -0.768 -0.864

#2 Cost of larger label / Low / $B$43 0.327 0.440

#3

Cost per label for larger label / Large & 

Small / $B$19 0.107 0.149

#4

Number of hours per store / Total / 

$D$8 0.012 0.017

#5 Prepress Activities / Mid / $C$7 0.007 -0.001

#6 Sticker Costs / Mid / $C$4 0.004 0.009

#7 Mid / $F$57 -0.004 -0.002

#8

Number of hours per store / Small 

Businesses / $B$8 0.000 -0.006

#9

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.010

#10

Average number of products per 

company / Large & Small Firms / $B$7 0.000 0.005

#11

Average number of products per 

company / Small Firms Only / $C$7 0.000 -0.004

#12

Cost per label for larger label / Small 

Firm Only / $D$19 0.000 -0.003

#13 Administrative Costs / Mid / $C$5 0.000 0.008

#14 Graphic Design / Mid / $C$6 0.000 0.002

#15 Engraving / Mid / $C$8 0.000 0.002

#16 NLEA Panel Analysis / Mid / $C$11 0.000 0.006

 Regression Sensitivity for Cell N28

Std b Coefficients

 

-.004 Mid/F57

 Sticker Costs / Mid/C4 .004

 Prepress Activities / Mid/C7 .007

 Number of hours per store .../D8 .012

 Cost per label for larger .../B19 .107

 Cost of larger label / Low.../B43 .327

-.768 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 13. Simulation Results for Alternative 3

TOTALS / 14. Present Value of Option 2 Retail 

+ Processing Plant Costs (7%) / O28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stati

stic Value %tile Value

Minim

um 197.8344116 5%

321.025146

5

Maxi

mum 3311.421143 10%

352.549987

8

Mean 599.6405555 15%

376.395507

8

Std 

Dev 300.7998421 20%

397.184600

8

Varia

nce 90480.545 25%

416.747955

3

Skew

ness 2.690983679 30%

435.538726

8

Kurto

sis 13.61728735 35%

454.032318

1

Media

n 517.4179688 40%

473.582366

9

Mode 433.8913819 45%

495.079345

7

Left X 321.0251465 50%

517.417968

8

Left P 5% 55% 541.208313

Right 

X 1164.679443 60%

568.116455

1

Right 

P 95% 65%

598.876647

9

Diff X 843.6542969 70%

634.497314

5

Diff P 90% 75%

677.469299

3

#Erro

rs 0 80%

734.534118

7

Filter 

Min 85%

808.335754

4

Filter 

Max 90%

928.862243

7

#Filte

red 0 95%

1164.67944

3

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of meat 

and poultry (pounds) / $B$10 -0.808 -0.938

#2 Application Costs / Mid / $C$5 0.181 0.240

#3 Sticker Costs / Mid / $C$4 0.143 0.201

#4

Cost per label for larger label / Large & 

Small / $B$19 0.023 0.040

#5 Mid / $F$57 -0.006 -0.001

#6

Number of hours per store / Total / 

$D$8 0.005 0.000

#7 Prepress Activities / Mid / $C$7 0.005 -0.002

#8

Number of hours per store / Small 

Businesses / $B$8 0.000 -0.006

#9

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.014

#10

Average number of products per 

company / Large & Small Firms / $B$7 0.000 0.001

#11

Average number of products per 

company / Small Firms Only / $C$7 0.000 -0.004

#12

Cost per label for larger label / Small 

Firm Only / $D$19 0.000 -0.002

#13 Cost of larger label / Low / $B$43 0.000 0.002

#14 Administrative Costs / Mid / $C$5 0.000 0.004

#15 Graphic Design / Mid / $C$6 0.000 0.003

#16 Engraving / Mid / $C$8 0.000 -0.002

 Regression Sensitivity for Cell O28

Std b Coefficients

 

 Prepress Activities / Mid/C7 .005

 Number of hours per store .../D8 .005

-.006 Mid/F57

 Cost per label for larger .../B19 .023

 Sticker Costs / Mid/C4 .143

 Application Costs / Mid/C5 .181

-.808 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 14. Simulation Results for Alternative 3

TOTALS / 15. Present Value of Option 2 Retail 

+ Processing Plant Costs (3%) / P28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stati

stic Value %tile Value

Minim

um 274.3268738 5%

447.159118

7

Maxi

mum 4646.19873 10%

491.491668

7

Mean 838.3983764 15%

524.986755

4

Std 

Dev 422.3519421 20%

554.116882

3

Varia

nce 178381.163 25%

581.576049

8

Skew

ness 2.690986948 30%

607.970336

9

Kurto

sis 13.61731634 35%

634.027099

6

Media

n 722.9379272 40%

661.456298

8

Mode 605.6732987 45%

691.544616

7

Left X 447.1591187 50%

722.937927

2

Left P 5% 55%

756.334594

7

Right 

X 1631.648682 60%

794.176269

5

Right 

P 95% 65%

837.286987

3

Diff X 1184.489563 70%

887.353698

7

Diff P 90% 75%

947.747924

8

#Erro

rs 0 80%

1027.69006

3

Filter 

Min 85%

1131.46386

7

Filter 

Max 90%

1300.82836

9

#Filte

red 0 95%

1631.64868

2

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of meat 

and poultry (pounds) / $B$10 -0.808 -0.938

#2 Application Costs / Mid / $C$5 0.181 0.240

#3 Sticker Costs / Mid / $C$4 0.143 0.201

#4

Cost per label for larger label / Large & 

Small / $B$19 0.023 0.040

#5 Mid / $F$57 -0.006 -0.001

#6

Number of hours per store / Total / 

$D$8 0.005 0.000

#7 Prepress Activities / Mid / $C$7 0.004 -0.002

#8

Number of hours per store / Small 

Businesses / $B$8 0.000 -0.006

#9

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.014

#10

Average number of products per 

company / Large & Small Firms / $B$7 0.000 0.001

#11

Average number of products per 

company / Small Firms Only / $C$7 0.000 -0.004

#12

Cost per label for larger label / Small 

Firm Only / $D$19 0.000 -0.002

#13 Cost of larger label / Low / $B$43 0.000 0.002

#14 Administrative Costs / Mid / $C$5 0.000 0.003

#15 Graphic Design / Mid / $C$6 0.000 0.003

#16 Engraving / Mid / $C$8 0.000 -0.002

 Regression Sensitivity for Cell P28

Std b Coefficients

 

 Prepress Activities / Mid/C7 .004

 Number of hours per store .../D8 .005

-.006 Mid/F57

 Cost per label for larger .../B19 .023

 Sticker Costs / Mid/C4 .143

 Application Costs / Mid/C5 .181

-.808 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 15. Simulation Results for Alternative 2

TOTALS / 3. Present Value of POP 

Materials Costs Discounted at 7% / D28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stat

istic Value %tile Value

Mini

mum 82.47988892 5%

85.0990905

8

Maxi

mum 92.63188171 10%

85.6480789

2

Mean 87.73606578 15%

86.0285797

1

Std 

Dev 1.59135023 20%

86.3459167

5

Varia

nce 2.532395554 25% 86.6121521

Skew

ness 0.000665353 30%

86.8632812

5

Kurto

sis 2.637797173 35%

87.0935668

9

Medi

an 87.74233246 40%

87.3171234

1

Mode 85.40917206 45%

87.5320663

5

Left X 85.09909058 50%

87.7423324

6

Left P 5% 55% 87.947258

Right 

X 90.37672424 60%

88.1590576

2

Right 

P 95% 65%

88.3729934

7

Diff X 5.277633667 70%

88.6035308

8

Diff P 90% 75%

88.8457183

8

#Erro

rs 0 80%

89.1222839

4

Filter 

Min 85%

89.4396820

1

Filter 

Max 90%

89.8327560

4

#Filte

red 0 95%

90.3767242

4

Sensitivity

Ran

k Name Regr Corr

#1

labor needed / 1. POP Materials -

Undiscounted Costs / $B$36 0.860 0.858

#2

manual cost / 1. POP Materials -

Undiscounted Costs / $B$39 0.509 0.489

#3 Number of hours per store / Total / $D$8 0.000 0.004

#4 Graphic Design / Mid / $C$6 0.000 0.000

#5

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$40 0.000 0.000

#6

packages @ / OMB mid-year discount factor 7% / 

$R$59 0.000 0.005

#7

Cost per label for larger label / Large & Small / 

$B$19 0.000 -0.003

#8

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$50 0.000 -0.006

#9

Number of hours per store / Large Businesses / 

$C$8 0.000 -0.002

#10

label @$0.005 / 7. Present Value of Retail 

Cuts Costs (column 1) (3%) / $T$45 0.000 0.002

#11

recurring labels @$0.005 / 7. Present Value 

of Retail Costs (column 1) (3%) / $T$40 0.000 0.002

#12 Administrative Costs / Mid / $C$5 0.000 0.000

#13

Number of hours per store / Small Businesses / 

$B$8 0.000 0.003

#14 one-time redesign labels / mid-point / $E$54 0.000 -0.005

#15

Average number of products per company / Large & 

Small Firms / $B$7 0.000 0.003

#16 Sticker Costs / Mid / $C$4 0.000 -0.010

 Regression Sensitivity for Cell D28

Std b Coefficients

 

 manual cost / 1. .../B39 .509

 labor needed / 1. .../B36 .86

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 16. Simulation Results for Alternative 2

TOTALS / 2. Present Value of POP 

Materials Costs Discounted at 3% / C28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stat

istic Value %tile Value

Mini

mum 115.8097305 5%

119.487342

8

Maxi

mum 130.0641174 10%

120.258178

7

Mean 123.1899168 15%

120.792434

7

Std 

Dev 2.234409539 20%

121.238006

6

Varia

nce 4.992585986 25%

121.611839

3

Skew

ness 0.000665241 30% 121.964447

Kurto

sis 2.637797201 35%

122.287788

4

Medi

an 123.1987228 40%

122.601684

6

Mode 121.1455002 45%

122.903480

5

Left X 119.4873428 50%

123.198722

8

Left P 5% 55%

123.486457

8

Right 

X 126.8976593 60%

123.783836

4

Right 

P 95% 65%

124.084228

5

Diff X 7.410316467 70%

124.407913

2

Diff P 90% 75%

124.747978

2

#Erro

rs 0 80%

125.136299

1

Filter 

Min 85%

125.581962

6

Filter 

Max 90%

126.133880

6

#Filte

red 0 95%

126.897659

3

Sensitivity

Ran

k Name Regr Corr

#1

labor needed / 1. POP Materials -

Undiscounted Costs / $B$36 0.860 0.858

#2

manual cost / 1. POP Materials -

Undiscounted Costs / $B$39 0.509 0.489

#3

Cost per label for larger label / Small Firm Only / 

$D$19 0.000 -0.004

#4 Administrative Costs / Mid / $C$5 0.000 0.000

#5

Number of hours per store / Large Businesses / 

$C$8 0.000 -0.002

#6 Number of hours per store / Total / $D$8 0.000 0.004

#7

Average weight per package of meat and poultry 

(pounds) / $B$10 0.000 -0.004

#8

label @$0.005 / 7. Present Value of Retail 

Cuts Costs (column 1) (3%) / $T$45 0.000 0.002

#9

Cost per label for larger label / Large & Small / 

$B$19 0.000 -0.003

#10 one-time redesign labels / mid-point / $E$54 0.000 -0.005

#11 NLEA Panel Analysis / Mid / $C$11 0.000 0.006

#12 Cost of larger label / Low / $B$43 0.000 -0.004

#13

label @$0.005 / 7. Present Value of Retail 

Costs (column 1) (3%) / $T$45 0.000 -0.001

#14

recurring labels @$0.005 / 7. Present Value 

of Retail Costs (column 1) (3%) / $T$50 0.000 -0.004

#15

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$40 0.000 0.000

#16

Average number of products per company / Small 

Firms Only / $C$7 0.000 0.003

 Regression Sensitivity for Cell C28

Std b Coefficients

 

 manual cost / 1. .../B39 .509

 labor needed / 1. .../B36 .86

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 17. Simulation Results for Alternative 4

17. Present Value Option 1 Labels on 

Major Cuts and Ground and Chopped

Products Costs (Retail+ Processing 

Plants) (7%) / AE13

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stat

istic Value %tile Value

Mini

mum 539.8584595 5%

673.612548

8

Maxi

mum 1541.748535 10%

700.205444

3

Mean 813.0389791 15%

719.353027

3

Std 

Dev 94.6180836 20%

735.030090

3

Varia

nce 8952.581745 25%

748.733459

5

Skew

ness 0.742339781 30%

761.089294

4

Kurto

sis 4.765490214 35%

772.525878

9

Medi

an 805.7607422 40%

783.680236

8

Mode 820.7205811 45%

794.771240

2

Left 

X 673.6125488 50%

805.760742

2

Left 

P 5% 55% 817.303833

Right 

X 974.4241943 60%

828.625549

3

Right 

P 95% 65%

840.463012

7

Diff X 300.8116455 70%

853.246643

1

Diff P 90% 75% 867.921875

#Erro

rs 0 80% 884.368103

Filter 

Min 85%

904.312683

1

Filter 

Max 90%

930.934875

5

#Filte

red 0 95%

974.424194

3

Sensitivity

Ran

k Name Regr Corr

#1

label @$0.005 / 7. Present Value of Retail 

Cuts Costs (column 1) (3%) / $T$45 0.607 0.644

#2

Average weight per package of meat and poultry 

(pounds) / $B$10 -0.471 -0.419

#3 Most-likely / $C$13 0.411 0.421

#4

packages @ / OMB mid-year discount factor 7% / 

$R$59 0.263 0.269

#5 Cost of larger label / Low / $B$43 0.201 0.188

#6

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$50 0.110 0.110

#7

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$40 0.068 0.068

#8

Cost per label for larger label / Large & Small / 

$B$19 0.066 0.063

#9 Prepress Activities / Mid / $C$7 0.015 0.012

#10 Engraving / Mid / $C$8 0.014 0.012

#11 NLEA Panel Analysis / Mid / $C$11 0.011 0.008

#12 Graphic Design / Mid / $C$6 0.010 0.009

#13 Administrative Costs / Mid / $C$5 0.009 0.018

#14

Average number of products per company / Large 

& Small Firms / $B$7 0.003 0.004

#15

Number of hours per store / Small Businesses / 

$B$8 0.000 0.001

#16

Number of hours per store / Large Businesses / 

$C$8 0.000 -0.003

 Regression Sensitivity for Cell AE13

Std b Coefficients

 

 Average number of products.../B7 .003

 Administrative Costs / Mid/C5 .009

 Graphic Design / Mid/C6 .01

 NLEA Panel Analysis / Mid/C11 .011

 Engraving / Mid/C8 .014

 Prepress Activities / Mid/C7 .015

 Cost per label for larger .../B19 .066

 recurring labels @$0.005 /.../T40 .068

 recurring labels @$0.005 /.../T50 .11

 Cost of larger label / Low.../B43 .201

 packages @ / OMB mid-year .../R59 .263

 Most-likely/C13 .411

-.471 Average weight per package.../B10

 label @$0.005 / 7. .../T45 .607

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 18. Simulation Results for Alternative 4

18. Present Value Option 1 Labels on 

Major Cuts and Ground and Chopped

Products Costs (Retail+ Processing 

Plants) (3%) / AF13

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stat

istic Value %tile Value

Mini

mum 719.7698975 5%

907.917053

2

Maxi

mum 2123.141357 10%

944.959167

5

Mean 1103.972769 15%

971.733337

4

Std 

Dev 133.0740525 20%

994.010803

2

Varia

nce 17708.70344 25%

1013.35339

4

Skew

ness 0.737513295 30%

1030.88183

6

Kurto

sis 4.74371891 35%

1046.97753

9

Medi

an 1093.8479 40%

1062.67541

5

Mode 1028.776855 45%

1078.20800

8

Left 

X 907.9170532 50% 1093.8479

Left 

P 5% 55%

1109.88757

3

Right 

X 1330.83728 60%

1126.02246

1

Right 

P 95% 65%

1142.91723

6

Diff X 422.9202271 70%

1160.56591

8

Diff P 90% 75%

1181.50915

5

#Erro

rs 0 80%

1204.12463

4

Filter 

Min 85%

1232.87902

8

Filter 

Max 90%

1269.32580

6

#Filte

red 0 95% 1330.83728

Sensitivity

Ran

k Name Regr Corr

#1

label @$0.005 / 7. Present Value of Retail 

Cuts Costs (column 1) (3%) / $T$45 0.619 0.657

#2

Average weight per package of meat and poultry 

(pounds) / $B$10 -0.471 -0.419

#3 Most-likely / $C$13 0.397 0.405

#4

packages @ / OMB mid-year discount factor 7% / 

$R$59 0.263 0.269

#5 Cost of larger label / Low / $B$43 0.200 0.187

#6

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$50 0.116 0.115

#7

Cost per label for larger label / Large & Small / 

$B$19 0.066 0.063

#8

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$40 0.050 0.049

#9 Prepress Activities / Mid / $C$7 0.012 0.008

#10 Engraving / Mid / $C$8 0.010 0.008

#11 NLEA Panel Analysis / Mid / $C$11 0.008 0.006

#12 Graphic Design / Mid / $C$6 0.007 0.007

#13 Administrative Costs / Mid / $C$5 0.006 0.015

#14

Number of hours per store / Small Businesses / 

$B$8 0.000 0.001

#15

Number of hours per store / Large Businesses / 

$C$8 0.000 -0.003

#16 Number of hours per store / Total / $D$8 0.000 -0.002

 Regression Sensitivity for Cell AF13

Std b Coefficients

 

 Administrative Costs / Mid/C5 .006

 Graphic Design / Mid/C6 .007

 NLEA Panel Analysis / Mid/C11 .008

 Engraving / Mid/C8 .01

 Prepress Activities / Mid/C7 .012

 recurring labels @$0.005 /.../T40 .05

 Cost per label for larger .../B19 .066

 recurring labels @$0.005 /.../T50 .116

 Cost of larger label / Low.../B43 .2

 packages @ / OMB mid-year .../R59 .263

 Most-likely/C13 .397

-.471 Average weight per package.../B10

 label @$0.005 / 7. .../T45 .619

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 19. Simulation Results for Alternative 5

TOTALS / 17. Present Value Option 1 

Labels on All Cuts and Ground and

Chopped Products Costs (Retail+ 

Processing Plants) (7%) / AE28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stat

istic Value %tile Value

Mini

mum 665.9577637 5% 808.359375

Maxi

mum 1651.604004 10%

836.726379

4

Mean 956.5351607 15%

857.143310

5

Std 

Dev 101.4497445 20%

873.244506

8

Varia

nce 10292.05065 25%

887.933410

6

Skew

ness 0.841931164 30%

901.193237

3

Kurto

sis 5.229223147 35%

913.495056

2

Medi

an 948.7000732 40%

925.544433

6

Mode 940.3519897 45%

937.320739

7

Left X 808.359375 50%

948.700073

2

Left P 5% 55%

960.729919

4

Right 

X 1127.417725 60%

972.939025

9

Right 

P 95% 65%

985.879821

8

Diff X 319.0583496 70%

999.837829

6

Diff P 90% 75%

1014.59405

5

#Erro

rs 0 80%

1031.48254

4

Filter 

Min 85% 1051.00708

Filter 

Max 90%

1077.71643

1

#Filte

red 0 95%

1127.41772

5

Sensitivity

Ran

k Name Regr Corr

#1

label @$0.005 / 7. Present Value of Retail 

Cuts Costs (column 1) (3%) / $T$45 0.666 0.724

#2

Average weight per package of meat and poultry 

(pounds) / $B$10 -0.518 -0.467

#3

packages @ / OMB mid-year discount factor 7% / 

$R$59 0.289 0.302

#4 Cost of larger label / Low / $B$43 0.220 0.209

#5

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$50 0.121 0.123

#6

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$40 0.075 0.075

#7

Cost per label for larger label / Large & Small / 

$B$19 0.072 0.068

#8 Prepress Activities / Mid / $C$7 0.017 0.012

#9 Engraving / Mid / $C$8 0.015 0.015

#10 NLEA Panel Analysis / Mid / $C$11 0.012 0.011

#11 Graphic Design / Mid / $C$6 0.011 0.015

#12 Administrative Costs / Mid / $C$5 0.010 0.020

#13

Average number of products per company / Large & 

Small Firms / $B$7 0.004 0.004

#14 Sticker Costs / Mid / $C$4 0.003 0.004

#15 Mid / $F$57 -0.003 -0.003

#16

Number of hours per store / Small Businesses / 

$B$8 0.000 0.001

 Regression Sensitivity for Cell AE28

Std b Coefficients

 

-.003 Mid/F57

 Sticker Costs / Mid/C4 .003

 Average number of products.../B7 .004

 Administrative Costs / Mid/C5 .01

 Graphic Design / Mid/C6 .011

 NLEA Panel Analysis / Mid/C11 .012

 Engraving / Mid/C8 .015

 Prepress Activities / Mid/C7 .017

 Cost per label for larger .../B19 .072

 recurring labels @$0.005 /.../T40 .075

 recurring labels @$0.005 /.../T50 .121

 Cost of larger label / Low.../B43 .22

 packages @ / OMB mid-year .../R59 .289

-.518 Average weight per package.../B10

 label @$0.005 / 7. .../T45 .666

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix B. 

Table 20. Simulation Results for Alternative 5

TOTALS / 18. Present Value Option 1 

Labels on All Cuts and Ground and

Chopped Products Costs (Retail+ 

Processing Plants) (3%) / AF28

Summary Information

Workbook Name

NutLabAt14Feb06 

IV_23Mar06_Vd.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/24/2006 20:41

Simulation Stop Time 4/24/2006 20:44

Simulation Duration 00:02:12

Random Seed 1247717209

Summary Statistics

Stat

istic Value %tile Value

Mini

mum 886.6021729 5%

1088.07470

7

Maxi

mum 2274.42334 10%

1128.49084

5

Mean 1298.817773 15%

1157.64196

8

Std 

Dev 143.6598372 20%

1180.66662

6

Varia

nce 20638.14881 25%

1201.27819

8

Skew

ness 0.821122018 30%

1220.26879

9

Kurto

sis 5.145346615 35%

1237.57568

4

Medi

an 1287.922852 40%

1254.84460

4

Mode 1336.641846 45% 1271.78186

Left X 1088.074707 50%

1287.92285

2

Left P 5% 55%

1305.02392

6

Right 

X 1540.35144 60%

1322.34802

2

Right 

P 95% 65%

1340.78881

8

Diff X 452.2767334 70%

1360.72216

8

Diff P 90% 75%

1381.67089

8

#Erro

rs 0 80%

1405.46264

6

Filter 

Min 85%

1432.99731

4

Filter 

Max 90%

1470.96276

9

#Filte

red 0 95% 1540.35144

Sensitivity

Ran

k Name Regr Corr

#1

label @$0.005 / 7. Present Value of Retail 

Cuts Costs (column 1) (3%) / $T$45 0.674 0.731

#2

Average weight per package of meat and poultry 

(pounds) / $B$10 -0.513 -0.462

#3

packages @ / OMB mid-year discount factor 7% / 

$R$59 0.286 0.298

#4 Cost of larger label / Low / $B$43 0.218 0.207

#5

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$50 0.126 0.128

#6

Cost per label for larger label / Large & Small / 

$B$19 0.072 0.067

#7

recurring labels @$0.005 / 7. Present Value 

of Retail Cuts Costs (column 1) (3%) / $T$40 0.054 0.053

#8 Prepress Activities / Mid / $C$7 0.013 0.008

#9 Engraving / Mid / $C$8 0.011 0.010

#10 NLEA Panel Analysis / Mid / $C$11 0.009 0.008

#11 Graphic Design / Mid / $C$6 0.008 0.011

#12 Administrative Costs / Mid / $C$5 0.007 0.016

#13 Sticker Costs / Mid / $C$4 0.003 0.003

#14 Mid / $F$57 -0.003 -0.003

#15

Number of hours per store / Small Businesses / 

$B$8 0.000 0.001

#16

Number of hours per store / Large Businesses / 

$C$8 0.000 -0.006

 Regression Sensitivity for Cell AF28

Std b Coefficients

 

-.003 Mid/F57

 Sticker Costs / Mid/C4 .003

 Administrative Costs / Mid/C5 .007

 Graphic Design / Mid/C6 .008

 NLEA Panel Analysis / Mid/C11 .009

 Engraving / Mid/C8 .011

 Prepress Activities / Mid/C7 .013

 recurring labels @$0.005 /.../T40 .054

 Cost per label for larger .../B19 .072

 recurring labels @$0.005 /.../T50 .126

 Cost of larger label / Low.../B43 .218

 packages @ / OMB mid-year .../R59 .286

-.513 Average weight per package.../B10

 label @$0.005 / 7. .../T45 .674

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix C. Table 1. Compliance Adjusted Baseline: Simulation Results for Alternative 3 Costs (after estimated current expended costs are adjusted off total costs)

Name Worksheet Cell Minimum Mean Maximum x1 p1 x2 p2 x2-x1 p2-p1

Output 1 1/all / Present Value of Processing Plant Costs (7%) Alt#3_FirstYrPVCosts K6 1.471688 2.465302 7.565954 1.893266 5% 3.411976 95% 1.51871 90%

Output 2 1/all / Present Value of Processing Plant Costs (3%) Alt#3_FirstYrPVCosts L6 1.528352 2.560222 7.857264 1.966162 5% 3.543346 95% 1.577184 90%

Output 3 1/all / Present Value of Option 1 Retail + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts M6 23.18766 26.16835 43.96635 24.30616 5% 29.73896 95% 5.432796 90%

Output 4 1/all / Present Value of Option 1 Retail + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts N6 24.08045 27.1759 45.65918 25.24201 5% 30.88399 95% 5.641973 90%

Output 5 1/all / Present Value of Option 2 + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts O6 8.696994 20.64985 98.33887 12.80933 5% 36.61141 95% 23.80207 90%

Output 6 1/all / Present Value of Option 2 + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts P6 9.031851 21.44492 102.1252 13.30253 5% 38.02105 95% 24.71852 90%

Output 7 1/only small / Present Value of Processing Plant Costs (7%) Alt#3_FirstYrPVCosts K7 0.119247 0.1702358 0.2374366 0.1445874 5% 0.197849 95% 5.33E-02 90%

Output 8 1/only small / Present Value of Processing Plant Costs (3%) Alt#3_FirstYrPVCosts L7 0.1288086 0.1838859 0.2564751 0.1561808 5% 0.2137132 95% 5.75E-02 90%

Output 9 1/only small / Present Value of Option 1 Retail + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts M7 3.34948 3.570232 3.799559 3.438833 5% 3.702084 95% 0.2632515 90%

Output 10 1/only small / Present Value of Option 1 Retail + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts N7 3.618053 3.856505 4.10422 3.71457 5% 3.99893 95% 0.2843599 90%

Output 11 1/only small / Present Value of Option 2 + Processing Plant Costs (7%) Alt#3_FirstYrPVCosts O7 3.34948 3.570232 3.799559 3.438833 5% 3.702084 95% 0.2632515 90%

Output 12 1/only small / Present Value of Option 2 + Processing Plant Costs (3%) Alt#3_FirstYrPVCosts P7 3.618053 3.856505 4.10422 3.71457 5% 3.99893 95% 0.2843599 90%

Output 13 TOTALS / 6. Present Value of Option 1 Retail Costs (cols. a+d) (7%) Alt#3_PVCosts G28 79.03374 104.1672 270.7651 87.47724 5% 135.5844 95% 48.10712 90%

Output 14 TOTALS / 7. Present Value of Option 1 Retail Costs (cols. a+d) (3%) Alt#3_PVCosts H28 106.2122 141.4721 375.4081 118.0466 5% 185.5728 95% 67.52618 90%

Output 15 TOTALS / 8. Present Value of Option 2 Retail Costs (cols. a+e) (7%) Alt#3_PVCosts I28 58.69766 184.7231 1026.806 100.1822 5% 356.0912 95% 255.909 90%

Output 16 TOTALS / 9. Present Value of Option 2 Retail Costs (cols. a+e) (3%) Alt#3_PVCosts J28 81.81952 258.7143 1441.053 140.0118 5% 499.301 95% 359.2892 90%

Output 17 TOTALS / 10. Present Value of Processing Plant Costs (cols. b+c) (7%) Alt#3_PVCosts K28 3.380496 11.28148 68.49493 5.722594 5% 21.69823 95% 15.97563 90%

Output 18 TOTALS / 11. Present Value of Processing Plant Costs (cols. b+c) (3%) Alt#3_PVCosts L28 4.203216 15.251 95.5637 7.452395 5% 29.89207 95% 22.43967 90%

Output 19 TOTALS / 12. Present Value of Option 1 Retail + Processing Plant Costs (cols. 1+3) (7%) Alt#3_PVCosts M28 84.15536 115.4487 316.3576 94.72345 5% 155.9656 95% 61.24217 90%

Output 20 TOTALS / 13. Present Value of Option 1 Retail + Processing Plant Costs (cols. 1+3) (3%) Alt#3_PVCosts N28 112.8678 156.7231 438.7929 127.6168 5% 213.6017 95% 85.9849 90%

Output 21 TOTALS / 14. Present Value of Option 2 Retail + Processing Plant Costs (cols. 2+3) (7%) Alt#3_PVCosts O28 63.81927 196.0046 1075.384 107.2419 5% 376.518 95% 269.2761 90%

Output 22 TOTALS / 15. Present Value of Option 2 Retail + Processing Plant Costs (cols. 2+3) (3%) Alt#3_PVCosts P28 88.47511 273.9653 1508.669 149.3604 5% 527.4691 95% 378.1087 90%

Output 23 TOTALS / f. Present Value of POP Placards Costs (Retail) (column a) (7%) Alt#3_PVCosts G56 13.2645 14.04301 14.82184 13.50764 5% 14.57837 95% 1.070736 90%

Output 24 TOTALS / g. Present Value of POP Placards Costs (Retail) (column a) (3%) Alt#3_PVCosts H56 18.28016 19.35305 20.42638 18.61523 5% 20.09085 95% 1.475611 90%

Output 25 TOTALS / h. Present Value of Modifying Product Labels Costs (Plants) (column b) (7%) Alt#3_PVCosts I56 1.117336 1.611887 2.249285 1.369858 5% 1.873365 95% 0.5035071 90%

Output 26 TOTALS / i. Present Value of Modifying Product Labels Costs (Plants) (column b) (3%) Alt#3_PVCosts J56 1.160357 1.673949 2.335888 1.422601 5% 1.945495 95% 0.5228937 90%

Output 27 TOTALS / j. Present Value of Larger Labels on Ground or Chopped Meat and Poultry Products Costs (Plants) (column c) (7%) Alt#3_PVCosts K56 1.809184 9.669598 66.82695 4.111356 5% 20.10353 95% 15.99217 90%

Output 28 TOTALS / k. Present Value of Larger Labels on Ground or Chopped Meat and Poultry Products Costs (Plants) (column c) (3%) Alt#3_PVCosts L56 2.540269 13.57705 93.8315 5.772742 5% 28.2273 95% 22.45456 90%

Output 29 TOTALS / l. Present Value of Option 1 Labels Printed Costs (Retail) (column d) (7%) Alt#3_PVCosts M56 65.57464 90.12418 257.1666 73.46009 5% 121.5078 95% 48.04772 90%

Output 30 TOTALS / m. Present Value of Option 1 Labels Printed Costs (Retail) (column d) (3%) Alt#3_PVCosts N56 87.66388 122.119 356.6676 98.72092 5% 166.1899 95% 67.46894 90%

Output 31 TOTALS / n. Present Value of Option 2 Labels Preprinted Costs (Retail) (column e) (7%) Alt#3_PVCosts O56 45.14693 170.6801 1012.61 86.13628 5% 341.968 95% 255.8317 90%

Output 32 TOTALS / o. Present Value of Option 2 Labels Preprinted Costs (Retail) (column e) (3%) Alt#3_PVCosts P56 63.0968 239.3612 1421.49 120.666 5% 479.8532 95% 359.1873 90%

Input 1 Number of hours per store / Small Businesses Major Cuts B8 0.3008628 0.5 0.6990162 0.3632444 5% 0.6367434 95% 0.273499 90%

Input 2 Number of hours per store / Large Businesses Major Cuts C8 0.30084 0.5 0.6989619 0.3632451 5% 0.6367505 95% 0.2735054 90%

Input 3 Number of hours per store / Total Major Cuts D8 0.3011362 0.5000001 0.6989459 0.3632432 5% 0.6367533 95% 0.2735101 90%

Input 4 Average number of products per company / Large & Small Firms Ground-Plants B7 5.605926 6.6 7.594223 5.916216 5% 7.283718 95% 1.367502 90%

Input 5 Average number of products per company / Small Firms Only Ground-Plants C7 5.605144 6.6 7.593747 5.916185 5% 7.28376 95% 1.367574 90%

Input 6 Cost per label for larger label / Large & Small Ground-Plants B19 2.01E-03 0.005 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 7 Cost per label for larger label / Small Firm Only Ground-Plants D19 2.01E-03 5.00E-03 8.00E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 8 Cost of larger label / Low Ground-Stores B43 2.02E-03 0.005 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 9 Administrative Costs / Mid FDA Label Costs C5 120.9024 280 439.094 170.5865 5% 389.4013 95% 218.8148 90%

Input 10 Graphic Design / Mid FDA Label Costs C6 300.864 450 599.6684 347.4249 5% 552.561 95% 205.136 90%

Input 11 Prepress Activities / Mid FDA Label Costs C7 245.1927 351.6667 549.0701 260.1243 5% 483.4915 95% 223.3671 90%

Input 12 Engraving / Mid FDA Label Costs C8 150.5764 283.3333 499.201 179.5802 5% 427.5392 95% 247.959 90%

Input 13 NLEA Panel Analysis / Mid FDA Label Costs C11 525.3312 605 689.8738 549.8698 5% 662.7505 95% 112.8807 90%

Input 14 Sticker Costs / Mid FDA Sticker Costs C4 1.00E-02 0.015 2.00E-02 1.16E-02 5% 1.84E-02 95% 6.84E-03 90%

Input 15 Application Costs / Mid FDA Sticker Costs C5 4.04E-03 1.07E-02 1.70E-02 6.13E-03 5% 1.50E-02 95% 8.89E-03 90%
Input 16 Average weight per package of meat and poultry (pounds) Package Volume B10 0.5001397 2.735974 6.978588 1.171519 5% 4.351441 95% 3.179922 90%

Input 17 labor needed / 1. POP Materials - Undiscounted Costs Alt#2_PVCosts B36 0.300937 0.5 0.6992218 0.3632347 5% 0.6367471 95% 0.2735123 90%

Input 18 manual cost / 1. POP Materials - Undiscounted Costs Alt#2_PVCosts B39 97.51342 100 102.4865 98.29041 5% 101.7094 95% 3.418945 90%

Input 19 Mid Alt#2_PVCosts F57 0.5482107 0.614 0.67961 0.5688697 5% 0.6591256 95% 9.03E-02 90%

Input 20 Most-likely Alt#4_PVCosts C13 0.7505617 0.85 0.9495229 0.781617 5% 0.9183729 95% 0.1367558 90%

Input 21 recurring labels @$0.005 / 7. Present Value of Retail Costs (column 1) (3%) Alt#5_PVCosts T40 2.02E-03 0.005 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 22 label @$0.005 / 7. Present Value of Retail Costs (column 1) (3%) Alt#5_PVCosts T45 2.01E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 23 recurring labels @$0.005 / 7. Present Value of Retail Costs (column 1) (3%) Alt#5_PVCosts T50 2.00E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 24 one-time redesign labels / mid-point Alt#5_PVCosts E54 1332.596 2014.667 2756.674 1541.315 5% 2519.295 95% 977.9807 90%

Input 25 recurring labels @$0.005 / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T40 2.01E-03 0.005 8.00E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 26 label @$0.005 / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T45 2.01E-03 0.005 7.98E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 27 recurring labels @$0.005 / 7. Present Value of Retail Cuts Costs (column 1) (3%) Alt#5_PVCosts(all) T50 2.02E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%

Input 28 packages @ / OMB mid-year discount factor 7% Alt#5_PVCosts(all) R59 2.01E-03 0.005 7.99E-03 2.95E-03 5% 7.05E-03 95% 4.10E-03 90%
Appendix C. 

Table 2. Compliance Adjusted Baseline:

Simulation Results for Alternative 3

 TOTALS / 12. Present Value of Option 1 

Retail + Processing Plant Costs (7%) / M28

Summary Information

Workbook Name

NutLabAt14Feb06 

IVb_23Mar06_Ve.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/28/2006 8:58

Simulation Stop Time 4/28/2006 9:00

Simulation Duration 00:01:59

Random Seed 1568173645

Summary Statistics

Statisti

c Value %tile Value

Minimum $84.16 5% $94.72

Maximum $316.36 10% $97.14

Mean $115.45 15% $98.97

Std Dev $21.76 20% $100.65

Variance 473.4231132 25% $102.14

Skewness 2.703591838 30% $103.63

Kurtosis 14.23690179 35% $105.12

Median $109.78 40% $106.58

Mode $93.50 45% $108.13

Left X $94.72 50% $109.78

Left P 5% 55% $111.59

Right X $155.97 60% $113.56

Right P 95% 65% $115.78

Diff X $61.24 70% $118.28

Diff P 90% 75% $121.41

#Errors 0 80% $125.34

Filter Min 85% $130.60

Filter Max 90% $139.06

#Filtered 0 95% $155.97

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of meat 

and poultry (pounds) / $B$10 -0.771 -0.864

#2 Cost of larger label / Low / $B$43 0.328 0.437

#3

Cost per label for larger label / Large & 

Small / $B$19 0.108 0.144

#4

Number of hours per store / Total / 

$D$8 0.019 0.020

#5

Average number of products per 

company / Large & Small Firms / $B$7 0.007 0.011

#6

labor needed / 1. POP 

Materials - Undiscounted Costs / $B$36 0.005 0.006

#7

Number of hours per store / Small 

Businesses / $B$8 0.000 0.009

#8

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.003

#9

Average number of products per 

company / Small Firms Only / $C$7 0.000 0.003

#10

Cost per label for larger label / Small 

Firm Only / $D$19 0.000 -0.004

#11 Administrative Costs / Mid / $C$5 0.000 0.002

#12 Graphic Design / Mid / $C$6 0.000 -0.002

#13 Prepress Activities / Mid / $C$7 0.000 0.011

#14 Engraving / Mid / $C$8 0.000 0.010

#15 NLEA Panel Analysis / Mid / $C$11 0.000 0.005

#16 Sticker Costs / Mid / $C$4 0.000 -0.009

 Regression Sensitivity for Cell M28

Std b Coefficients

 

 labor needed / 1. .../B36 .005

 Average number of products.../B7 .007

 Number of hours per store .../D8 .019

 Cost per label for larger .../B19 .108

 Cost of larger label / Low.../B43 .328

-.771 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix C. 

Table 3. Compliance Adjusted Baseline:

Simulation Results for 

Alternative 3

 TOTALS 

/ 13. 

Present 

Value of 

Option 1 

Retail + 

Processi

ng Plant 

Costs 

(3%) / 

N28

Summary Information

Workbook Name

NutLabAt14Feb06 

IVb_23Mar06_Ve.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/28/2006 8:58

Simulation Stop Time 4/28/2006 9:00

Simulation Duration 00:01:59

Random Seed 1568173645

Summary Statistics

Statisti

c Value %tile Value

Minimum $112.87 5% $127.62

Maximum $438.79 10% $130.99

Mean $156.72 15% $133.59

Std Dev $30.55 20% $135.93

Variance 933.3019486 25% $138.03

Skewness 2.70378473 30% $140.14

Kurtosis 14.23846121 35% $142.20

Median $148.77 40% $144.28

Mode $138.88 45% $146.46

Left X $127.62 50% $148.77

Left P 5% 55% $151.33

Right X $213.60 60% $154.06

Right P 95% 65% $157.18

Diff X $85.98 70% $160.69

Diff P 90% 75% $165.09

#Errors 0 80% $170.62

Filter Min 85% $177.99

Filter Max 90% $189.88

#Filtered 0 95% $213.60

Sensitivity

Rank Name Regr Corr

#1

Average weight per package of meat and 

poultry (pounds) / $B$10 -0.771 -0.864

#2 Cost of larger label / Low / $B$43 0.328 0.437

#3

Cost per label for larger label / Large & 

Small / $B$19 0.108 0.144

#4 Number of hours per store / Total / $D$8 0.019 0.019

#5

Average number of products per company / 

Large & Small Firms / $B$7 0.006 0.009

#6

labor needed / 1. POP Materials -

Undiscounted Costs / $B$36 0.005 0.006

#7

Number of hours per store / Small 

Businesses / $B$8 0.000 0.009

#8

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.003

#9

Average number of products per company / 

Small Firms Only / $C$7 0.000 0.003

#10

Cost per label for larger label / Small Firm 

Only / $D$19 0.000 -0.004

#11 Administrative Costs / Mid / $C$5 0.000 0.000

#12 Graphic Design / Mid / $C$6 0.000 -0.003

#13 Prepress Activities / Mid / $C$7 0.000 0.010

#14 Engraving / Mid / $C$8 0.000 0.009

#15 NLEA Panel Analysis / Mid / $C$11 0.000 0.005

#16 Sticker Costs / Mid / $C$4 0.000 -0.009

 Regression Sensitivity for Cell N28

Std b Coefficients

 

 labor needed / 1. .../B36 .005

 Average number of products.../B7 .006

 Number of hours per store .../D8 .019

 Cost per label for larger .../B19 .108

 Cost of larger label / Low.../B43 .328

-.771 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix C. 

Table 4. Compliance Adjusted Baseline:

Simulation Results for Alternative 3

TOTALS / 14. Present Value of Option 2 

Retail + Processing Plant Costs (7%) / O28

Summary Information

Workbook Name

NutLabAt14Feb06 

IVb_23Mar06_Ve.xls

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/28/2006 8:58

Simulation Stop Time 4/28/2006 9:00

Simulation Duration 00:01:59

Random Seed 1568173645

Summary Statistics

Statisti

c Value %tile Value

Minimum $63.82 5% $107.24

Maximum $1,075.38 10% $116.79

Mean $196.00 15% $124.31

Std Dev $96.50 20% $130.87

Variance 9312.027818 25% $137.20

Skewness 2.719310924 30% $143.46

Kurtosis 13.90441753 35% $149.57

Median $169.58 40% $155.93

Mode $142.86 45% $162.56

Left X $107.24 50% $169.58

Left P 5% 55% $177.37

Right X $376.52 60% $185.98

Right P 95% 65% $195.60

Diff X $269.28 70% $206.91

Diff P 90% 75% $220.57

#Errors 0 80% $238.58

Filter Min 85% $262.54

Filter Max 90% $301.52

#Filtered 0 95% $376.52

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of meat 

and poultry (pounds) / $B$10 -0.807 -0.937

#2 Application Costs / Mid / $C$5 0.183 0.255

#3 Sticker Costs / Mid / $C$4 0.145 0.183

#4

Cost per label for larger label / Large & 

Small / $B$19 0.025 0.032

#5

Number of hours per store / Total / 

$D$8 0.009 0.002

#6

labor needed / 1. POP 

Materials - Undiscounted Costs / $B$36 0.005 0.010

#7

Number of hours per store / Small 

Businesses / $B$8 0.000 0.009

#8

Number of hours per store / Large 

Businesses / $C$8 0.000 -0.002

#9

Average number of products per 

company / Large & Small Firms / $B$7 0.000 0.006

#10

Average number of products per 

company / Small Firms Only / $C$7 0.000 0.004

#11

Cost per label for larger label / Small 

Firm Only / $D$19 0.000 0.002

#12 Cost of larger label / Low / $B$43 0.000 -0.002

#13 Administrative Costs / Mid / $C$5 0.000 0.003

#14 Graphic Design / Mid / $C$6 0.000 -0.002

#15 Prepress Activities / Mid / $C$7 0.000 0.006

#16 Engraving / Mid / $C$8 0.000 0.008

 Regression Sensitivity for Cell O28

Std b Coefficients

 

 labor needed / 1. .../B36 .005

 Number of hours per store .../D8 .009

 Cost per label for larger .../B19 .025

 Sticker Costs / Mid/C4 .145

 Application Costs / Mid/C5 .183

-.807 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix C. 

Table 5. Compliance Adjusted Baseline:

Simulation Results for Alternative 3

TOTALS / 15. Present Value of Option 

2 Retail + Processing Plant Costs (3%) 

/ P28

Summary Information

Workbook Name

NutLabAt14Feb06 

IVb_23Mar06_Ve.xl

s

Number of Simulations 1

Number of Iterations 50000

Number of Inputs 28

Number of Outputs 47

Sampling Type Latin Hypercube

Simulation Start Time 4/28/2006 8:58

Simulation Stop Time 4/28/2006 9:00

Simulation Duration 00:01:59

Random Seed 1568173645

Summary Statistics

Statistic Value

%til

e Value

Minimum $88.48 5% $149.36

Maximum $1,508.67 10% $162.73

Mean $273.97 15% $173.31

Std Dev $135.49 20% $182.51

Variance 18358.366 25% $191.39

Skewness 2.7193235 30% $200.17

Kurtosis 13.904476 35% $208.78

Median $236.87 40% $217.72

Mode $199.34 45% $226.99

Left X $149.36 50% $236.87

Left P 5% 55% $247.81

Right X $527.47 60% $259.90

Right P 95% 65% $273.35

Diff X $378.11 70% $289.24

Diff P 90% 75% $308.49

#Errors 0 80% $333.71

Filter Min 85% $367.40

Filter Max 90% $422.10

#Filtered 0 95% $527.47

Sensitivity

Ran

k Name Regr Corr

#1

Average weight per package of 

meat and poultry (pounds) / 

$B$10 -0.807 -0.937

#2 Application Costs / Mid / $C$5 0.183 0.255

#3 Sticker Costs / Mid / $C$4 0.145 0.183

#4

Cost per label for larger label / 

Large & Small / $B$19 0.025 0.032

#5

Number of hours per store / 

Total / $D$8 0.009 0.002

#6

labor needed / 1. POP 

Materials - Undiscounted Costs / 

$B$36 0.005 0.010

#7

Number of hours per store / 

Small Businesses / $B$8 0.000 0.009

#8

Number of hours per store / 

Large Businesses / $C$8 0.000 -0.002

#9

Average number of products per 

company / Large & Small Firms / 

$B$7 0.000 0.005

#10

Average number of products per 

company / Small Firms Only / 

$C$7 0.000 0.004

#11

Cost per label for larger label / 

Small Firm Only / $D$19 0.000 0.002

#12

Cost of larger label / Low / 

$B$43 0.000 -0.002

#13

Administrative Costs / Mid / 

$C$5 0.000 0.002

#14 Graphic Design / Mid / $C$6 0.000 -0.002

#15 Prepress Activities / Mid / $C$7 0.000 0.005

#16 Engraving / Mid / $C$8 0.000 0.008

 Regression Sensitivity for Cell P28

Std b Coefficients

 

 labor needed / 1. .../B36 .005

 Number of hours per store .../D8 .009

 Cost per label for larger .../B19 .025

 Sticker Costs / Mid/C4 .145

 Application Costs / Mid/C5 .183

-.807 Average weight per package.../B10

-1 -0.75 -0.5 -0.25 0 0.25 0.5 0.75 1
Appendix D. Table 1. Summary of Estimated Additional Costs by Alternative for the Nutrition Labeling Rule

Alternatives: Option Baseline Annualized Costs (20-year) Annualized Costs (20-year) Present Value (20-year) Present Value (20-year)

Discounted 3 Percent, $Millions Discounted 7 Percent, $Millions Discounted 3 Percent, $Millions Discounted 7 Percent, $Millions

Mean Median 5th Pct. 95th Pct. Mean Median 5th Pct. 95th Pct. Mean Median 5th Pct. 95th Pct. Mean Median 5th Pct. 95th Pct.

1. status quo na2

2. POP manuals for all products:

Total7 na Baseline I3 8.28 8.28 8.03 8.53 8.28 8.28 8.03 8.53 123.19 123.20 119.49 126.90 87.74 87.74 85.10 90.38

 Ground & chopped na na na na na na na na na na na na na na na na

 Major cuts na na na na na na na na na na na na na na na na

 Non-major cuts na na na na na na na na na na na na na na na na

3. On-package labels for ground and chopped products; POP placards for major cuts:

Total Option 15 Baseline I 31.74 30.06 25.59 43.71 32.85 31.18 26.70 44.82 472.23 447.26 380.76 650.23 348.06 330.30 282.88 474.79

 Ground & chopped 28.86 27.19 22.37 41.13 29.92 28.25 23.43 42.19 429.41 404.47 332.79 611.95 316.98 299.23 248.20 446.92

 Major cuts 2.88 2.88 2.77 2.99 2.93 2.93 2.82 3.04 42.82 42.82 41.18 44.48 31.07 31.07 29.88 32.25

Total Option 26 Baseline I 56.35 48.59 30.06 109.67 56.60 48.84 30.30 109.94 838.40 722.94 447.16 1631.65 599.64 517.42 321.02 1164.68

 Ground & chopped 53.48 45.72 26.90 107.12 53.67 45.91 27.09 107.31 795.58 680.25 400.14 1593.66 568.57 486.42 286.97 1136.82

 Major cuts 2.88 2.88 2.77 2.99 2.93 2.93 2.82 3.04 42.82 42.82 41.18 44.48 31.07 31.07 29.88 32.25

Total Option 1 Baseline II4 10.53 10.00 8.58 14.36 10.90 10.36 8.94 14.72 156.72 148.77 127.62 213.60 115.45 109.78 94.72 155.97

 Ground & chopped 9.23 8.70 7.18 13.13 9.57 9.04 7.52 13.47 137.37 129.41 106.89 195.37 101.41 95.74 79.69 142.70

 Major cuts 1.30 1.30 1.25 1.35 1.33 1.33 1.28 1.38 19.35 19.35 18.61 20.09 14.04 14.04 13.51 14.58

Total Option 2 Baseline II 18.42 15.92 10.04 35.45 18.50 16.01 10.12 35.54 273.97 236.87 149.36 527.47 196.00 169.58 107.24 376.52

 Ground & chopped 17.11 14.61 8.66 34.22 17.18 14.68 8.72 34.28 254.61 217.42 128.85 509.10 181.96 155.48 92.39 363.21

 Major cuts 1.30 1.30 1.25 1.35 1.33 1.33 1.28 1.38 19.35 19.35 18.61 20.09 14.04 14.04 13.51 14.58

4. On-package labels for ground and chopped products and major cuts

Total Option 1 Baseline I 74.20 73.52 61.03 89.45 76.75 76.06 63.58 91.98 1103.97 1093.85 907.92 1330.84 813.04 805.76 673.61 974.42

 Ground & chopped 28.86 na na na 29.92 na na na 429.41 na na na 316.98 na na na

 Major cuts 45.34 na na na 46.82 na na na 674.49 na na na 496.00 na na na

5. On-package labels for ground and chopped products, major cuts, and minor cuts

Total Option 1 Baseline I 87.30 86.57 73.14 103.54 90.29 89.55 76.30 106.42 1298.82 1287.92 1088.07 1540.35 956.54 948.70 808.36 1127.42

 Ground & chopped 28.86 na na na 29.92 na na na 429.41 na na na 316.98 na na na

 Major cuts 45.34 na na na 46.82 na na na 674.49 na na na 496.00 na na na

 Non-major cuts 13.10 na na na 13.54 na na na 194.84 na na na 143.49 na na na

Notes:

(1) The costs are from a probabilistic (stochastic) simulation model that used @Risk Software Version 4.5 (Palisade Corporation, Ithaca, NY)

(2) "na" means "not applicable" or that this information does not apply to this alternative, or information not available.

(3) Baseline I is the baseline without consideration of compliance levels for major cuts and ground single-ingredient products

(4) Baseline II is the baseline with consideration of compliance levels for major cuts (54.8% of retail stores) and ground single-ingredient products (68% of packages of ground meat and poultry)

(5) Option 1: prints labels for the ground and chopped single-ingredient products in each of the stores

(6) Option 2: purchases printed labels for the ground and chopped single-ingredient products in each of the stores
 Appendix D. Table 2. Stochastic Model Framework of Output for Total and Discounted Costs for Nutrition Labeling Rule: Alternative 3

Total and Discounted Costs for Nutrition Labeling Rule: Alternative 3 

costs discounted over 20-year period using 7% and 3% discount factor

($$ in millions)

Row/Column 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Year

1. 

(cols. a+d) 

Option 1 

Retail 

Annual 

Costs

2. 

(cols. a+e) 

Option 2 

Retail 

Annual 

Costs

3. 

(cols. b+c) 

Annual 

Processing 

Plant Costs

4. (cols. 

1+3) 

Annual 

Option 1 

Retail + 

Processing 

Plant Costs

5. (cols. 

2+3) 

Annual 

Option 2 

Retail + 

Processing 

Plant Costs

6. 

Present 

Value of 

Option 1 

Retail 

Costs 

(cols. a+d) 

(7%)

7. 

Present 

Value of 

Option 1 

Retail 

Costs 

(cols. a+d) 

(3%)

8. 

Present 

Value of 

Option 2 

Retail 

Costs 

(cols. a+e) 

(7%)

9. 

Present 

Value of 

Option 2 

Retail 

Costs 

(cols. a+e) 

(3%)

10. 

Present 

Value of 

Processing 

Plant Costs 

(cols. b+c) 

(7%)

11. 

Present 

Value of 

Processing 

Plant Costs 

(cols. b+c) 

(3%)

12. 

Present 

Value of 

Option 1 

Retail + 

Processing 

Plant Costs 

(cols. 1+3) 

(7%)

13. 

Present 

Value of 

Option 1 

Retail + 

Processing 

Plant Costs 

(cols. 1+3) 

(3%)

14. 

Present 

Value of 

Option 2 

Retail + 

Processing 

Plant Costs 

(cols. 2+3) 

(7%)

15. 

Present 

Value of 

Option 2 

Retail + 

Processing 

Plant Costs 

(cols. 2+3) 

(3%)

1 $75.58 $50.83 $7.81 $83.39 $58.64 $70.67 $73.39 $47.53 $49.36 $7.30 $7.58 $77.97 $80.97 $54.83 $56.94

2 12.33 42.51 2.42 14.75 44.93 10.77 11.63 37.11 40.09 2.11 2.28 12.88 13.91 39.22 42.37

3 18.01 48.18 2.42 20.43 50.60 14.69 16.48 39.32 44.09 1.98 2.21 16.67 18.69 41.29 46.30

4 12.33 42.51 2.42 14.75 44.93 9.41 10.95 32.44 37.75 1.85 2.15 11.26 13.10 34.28 39.90

5 18.01 48.18 2.42 20.43 50.60 12.84 15.54 34.35 41.58 1.73 2.09 14.56 17.63 36.08 43.67

6 68.68 42.51 2.42 71.10 44.93 45.74 57.49 28.31 35.58 1.61 2.03 47.35 59.51 29.92 37.61

7 18.01 48.18 2.42 20.43 50.60 11.22 14.64 30.02 39.17 1.51 1.97 12.73 16.61 31.53 41.14

8 12.33 42.51 2.42 14.75 44.93 7.18 9.73 24.74 33.54 1.41 1.91 8.59 11.64 26.15 35.45

9 18.01 48.18 2.42 20.43 50.60 9.80 13.79 26.21 36.91 1.32 1.85 11.11 15.65 27.53 38.76

10 12.33 42.51 2.42 14.75 44.93 6.27 9.18 21.60 31.63 1.23 1.80 7.49 10.98 22.82 33.43

11 74.36 48.18 2.42 76.78 50.60 35.32 53.68 22.89 34.79 1.15 1.75 36.47 55.43 24.04 36.54

12 12.33 42.51 2.42 14.75 44.93 5.48 8.65 18.87 29.80 1.07 1.70 6.55 10.34 19.95 31.50

13 18.01 48.18 2.42 20.43 50.60 7.47 12.26 20.00 32.81 1.00 1.65 8.48 13.91 21.00 34.46

14 12.33 42.51 2.42 14.75 44.93 4.79 8.15 16.49 28.10 0.94 1.60 5.72 9.75 17.43 29.70

15 18.01 48.18 2.42 20.43 50.60 6.52 11.56 17.44 30.93 0.88 1.55 7.39 13.11 18.32 32.49

16 68.68 42.51 2.42 71.10 44.93 23.28 42.79 14.41 26.48 0.82 1.51 24.10 44.30 15.23 27.99

17 18.01 48.18 2.42 20.43 50.60 5.71 10.89 15.27 29.15 0.77 1.46 6.48 12.36 16.04 30.62

18 12.33 42.51 2.42 14.75 44.93 3.65 7.24 12.58 24.95 0.72 1.42 4.37 8.66 13.30 26.37

19 18.01 48.18 2.42 20.43 50.60 4.99 10.26 13.35 27.46 0.67 1.38 5.66 11.64 14.02 28.84

20 12.33 42.51 2.42 14.75 44.93 3.18 6.83 10.97 23.55 0.62 1.34 3.81 8.17 11.59 24.89

TOTALS $530.01 $909.58 $53.80 $583.81 $963.38 $298.96 $405.13 $483.90 $677.73 $30.68 $41.24 $329.64 $446.37 $514.58 $718.97

Years 6-10 129.36 223.90 12.10 141.46 236.00 80.20 104.82 130.88 176.83 7.08 9.56 87.27 114.38 137.95 186.39

Years 11-20 264.39 453.47 24.21 288.60 477.67 100.38 172.32 162.28 288.04 8.64 15.36 109.03 187.68 170.92 303.40
 Appendix D. Table 2 (continued). Stochastic Model Framework of Output for Total and Discounted Costs for Nutrition Labeling Rule: Alternative 3

Row/Column a. b. c. d. e. f. g. h. i. j. k. l. m. n. o.

Year

a. 

Purchasing 

and 

Installing 

POP 

Placards 

Costs 

(Retail)

b. 

Modifying 

Product 

Labels 

Costs 

(Processing 

Plants)

c. Larger 

Labels on 

Ground or 

Chopped 

Meat and 

Poultry 

Products 

Costs 

(Processing 

Plants)

d. 

Option 1 

Labels 

Printed 

Costs 

(Retail) 

e. 

Option 2 

Labels 

Preprinted 

Costs 

(Retail)

f. Present 

Value of 

POP 

Placards 

Costs 

(Retail) 

(column a) 

(7%)

g. 

Present 

Value of 

POP 

Placards 

Costs 

(Retail) 

(column a) 

(3%)

h. 

Present 

Value of 

Modifying 

Product 

Labels 

Costs 

(Plants) 

(column b) 

(7%)

i. Present 

Value of 

Modifying 

Product 

Labels 

Costs 

(Plants) 

(column b) 

(3%)

j. Present 

Value of 

Larger 

Labels on 

Ground or 

Chopped 

Meat and 

Poultry 

Products 

Costs 

(Plants) 

(column c) 

(7%)

k. Present 

Value of 

Larger 

Labels on 

Ground or 

Chopped 

Meat and 

Poultry 

Products 

Costs 

(Plants) 

(column c) 

(3%)

l. Present 

Value of 

Option 1 

Labels 

Printed 

Costs 

(Retail) 

(column d) 

(7%)

m. 

Present 

Value of 

Option 1 

Labels 

Printed 

Costs 

(Retail) 

(column d) 

(3%)

n. 

Present 

Value of 

Option 2 

Labels 

Preprinted 

Costs 

(Retail) 

(column e) 

(7%)

o. Present 

Value of 

Option 2 

Labels 

Preprinted 

Costs 

(Retail) 

(column e) 

(3%)

1 $5.67 $5.39 $2.42 $69.91 $45.16 $5.30 $5.51 $5.04 $5.23 $2.26 $2.35 $65.37 $67.88 $42.23 $43.85

2 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 2.11 2.28 10.77 11.63 37.11 40.09

3 5.67 0.00 2.42 12.33 42.51 4.63 5.19 0.00 0.00 1.98 2.21 10.06 11.28 34.69 38.90

4 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 1.85 2.15 9.41 10.95 32.44 37.75

5 5.67 0.00 2.42 12.33 42.51 4.04 4.90 0.00 0.00 1.73 2.09 8.79 10.64 30.31 36.69

6 0.00 0.00 2.42 68.68 42.51 0.00 0.00 0.00 0.00 1.61 2.03 45.74 57.49 28.31 35.58

7 5.67 0.00 2.42 12.33 42.51 3.53 4.61 0.00 0.00 1.51 1.97 7.68 10.03 26.48 34.56

8 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 1.41 1.91 7.18 9.73 24.74 33.54

9 5.67 0.00 2.42 12.33 42.51 3.09 4.35 0.00 0.00 1.32 1.85 6.71 9.45 23.13 32.56

10 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 1.23 1.80 6.27 9.18 21.60 31.63

11 5.67 0.00 2.42 68.68 42.51 2.69 4.10 0.00 0.00 1.15 1.75 32.62 49.59 20.19 30.69

12 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 1.07 1.70 5.48 8.65 18.87 29.80

13 5.67 0.00 2.42 12.33 42.51 2.35 3.86 0.00 0.00 1.00 1.65 5.12 8.40 17.64 28.95

14 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 0.94 1.60 4.79 8.15 16.49 28.10

15 5.67 0.00 2.42 12.33 42.51 2.05 3.64 0.00 0.00 0.88 1.55 4.46 7.92 15.39 27.29

16 0.00 0.00 2.42 68.68 42.51 0.00 0.00 0.00 0.00 0.82 1.51 23.28 42.79 14.41 26.48

17 5.67 0.00 2.42 12.33 42.51 1.80 3.43 0.00 0.00 0.77 1.46 3.91 7.46 13.48 25.72

18 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 0.72 1.42 3.65 7.24 12.58 24.95

19 5.67 0.00 2.42 12.33 42.51 1.57 3.23 0.00 0.00 0.67 1.38 3.42 7.03 11.78 24.23

20 0.00 0.00 2.42 12.33 42.51 0.00 0.00 0.00 0.00 0.62 1.34 3.18 6.83 10.97 23.55

TOTALS $56.73 $5.39 $48.41 $473.29 $852.86 $31.07 $42.82 $5.04 $5.23 $25.64 $36.01 $267.89 $362.32 $452.83 $634.92

Years 6-10 11.35 0.00 12.10 118.01 212.55 6.62 8.96 0.00 0.00 7.08 9.56 73.58 95.87 124.26 167.87

Years 11-20 28.36 0.00 24.21 236.03 425.10 10.47 18.27 0.00 0.00 8.64 15.36 89.91 154.06 151.80 269.77