Spreadsheet: f6e04841-56d8-4a96-9a1f-8462b4f968ac
Sheet: RedGold

65
 |  |  |  |  |  | SCHOOL YEAR 2013 / 2014 |  | REVISED: 11/19/12
 |  |  |  |  |  | Commodity Processing Calculator
 |  |  |  |  |  | USDA Material Number:  100332 Tomato Paste Totes
 |  |  |  |  |  | RED GOLD BRANDS |  |  |  |  |  |  | MAY USE EITHER METHOD 1 OR METHOD 2
 |  |  |  |  |  |  |  |  |  |  |  |  | METHOD 1 |  | METHOD 2
 | [NAME] | UNIT NET WEIGHT | CASE                     NET               WEIGHT | SERVINGS    PER CASE | SERVING    NET WEIGHT | PRODUCT DESCRIPTION |  | UPC CODE | RED GOLD           ITEM NUMBER | AMOUNT DONATED FOOD PER CASE | ESTIMATED FINISHED CASES PER TRUCK OF PASTE | PASS THRU VALUE PER CASE | ESTIMATED  ANNUAL CASES NEEDED | ESTIMATED TOTAL PASTE POUNDS NEEDED | ESTIMATED             SERVINGS            NEEDED                  PER YEAR | ESTIMATED TOTAL PASTE POUNDS NEEDED
 |  |  |  | COLUMN A |  |  |  |  |  | COLUMN B |  | 0.3612 | COLUMN C | COLUMN D     (B x C = D) | COLUMN E | COLUMN F       (E/A x B = F)
 | 6 / #10 Cans | 115 oz. | 43.13 lbs. | 1151 | .6 oz. | Red Gold 33% Fancy Ketchup 6 / # 10 Cans |  | 72940-11002 | REDY599 | 9.81
 |  | 114 oz. | 42.75 lbs. | 1140 | .6 oz. | Red Gold 100% Natural [NAME] made w/Sugar Low Sodium  6 / #10 Cans |  | 72940-11583 | REDYL99 | 10.39
 | 6 / #10 Pouches (6 / 7 lb. 2 oz.) | 114 oz. | 42.75 lbs. | 1141 | .6 oz. | Red Gold 33% Fancy Ketchup 6 / 114 oz. Pouches (6 / 7 lb. 2 oz.) |  | 72940-11561 | REDY572 | 9.72
 | 6/ #10 Jugs (6 /114 oz.) | 114 oz. | 42.75 lbs. | 1141 | .6 oz. | Red Gold 33% Fancy Ketchup 6/ 114 oz. Jugs with Pump |  | 72940-11574 | REDY59P | 9.72
 | 9 / 64 oz. Plastic | 64 oz. | 36.00 lbs. | 961 | .6 oz. | Red Gold 33% Fancy Ketchup 9 / 64 oz. Plastic Squeeze Bottle |  | 72940-11564 | REDYA64 | 8.23
 | 1 / 3 gal. Bag In Box | 28.5 lbs. | 28.50 lbs. | 760 | .6 oz. | Red Gold 33% Fancy Ketchup 1 / 3 gal. Bag-In-Box for Wall Rack** |  | 72940-11560 | REDYA3GTH | 6.48
 |  | 28.5 lbs. | 28.50 lbs. | 760 | .6 oz. | Red Gold 100% Natural [NAME] made w/Sugar Low Sodium 1/3 gal. Bag-In-Box (Wall Rack**) |  | 72940-11577 | [NAME] | 6.93
 |  | 14.5 lbs. | 43.50 lbs. | 1161 | .6 oz. | Red Gold 33% Fancy Ketchup 3 / 1.5 gal. Pouch Pack |  | 72940-11562 | REDY53H | 9.89
 | 2 / 1.5 gal.  Pouches | 14.5 lbs. | 29.00 lbs. | 774 | .6 oz. | Red Gold 33% Fancy Ketchup 2 / 1.5 gal. Dispenser Pouch Pack** |  | 72940-11563 | [NAME] | 6.6
 | 2 / 1.5 gal.  Pouches | 14.5 lbs. | 28.50 lbs. | 760 | .6 oz. | Red Gold 100% Natural [NAME] made w/Sugar Low Sodium  2 / 1.5 gal. Dispenser Pouch Pack** |  | 72940-11550 | REDYL7D | 6.93
 | 1,000 / 9 gm Portion Control | 9 grams | 19.84 lbs. | 1000 | .3 oz. | Red Gold Fancy Ketchup 1,000 / 9 gm Portion Control Foil Packets |  | 72940-11581 | REDY59G | 4.21
 |  | 9 grams | 19.84 lbs. | 1000 | .3 oz. | Red Gold 100% Natural [NAME] made w/Sugar Low Sodium 1,000 / 9 gm Foil Packets |  | 72940-11584 | REDYL9G | 4.81
 |  | 1 oz. | 15.63 lbs. | 250 | 1.0 oz. | Red Gold 33% Fancy Ketchup 250 / 1 oz. Plastic [NAME] |  | 72940-11579 | REDY51Z | 3.56
 |  | 2 oz. | 10.00 lbs. | 162 | 1.02 oz. | Red Gold (Nutritionally Enhanced) Salsa 80  / 2 oz. Plastic [NAME] |  | 72940-11137 | REDSC2Z | 1.53
 |  | 14.2 grams | 12.77 lbs. | 204 | 1.02 oz. | Red Gold Picante Sauce 408 / 14.2 Gram Packets |  | 72940-11138 | REDSD4Z | 1.61
 |  | 1 oz. | 15.63 lbs. | 250 | 1.0 oz. | Red Gold Marinara Sauce 250 / 1 oz. Plastic [NAME] |  | 72940-11135 | REDNA1Z | 3.98
 |  | 2 oz. | 12.00 lbs. | 96 | 2.0 oz. | Red Gold Marinara Sauce 96 / 2 oz. Plastic [NAME] |  | 72940-82205 | REDNA2Z96 | 3.35
 |  | 1 oz. | 15.63. lbs. | 250 | 1.0 oz. | Red Gold Bar-B-Que Sauce 250 / 1 oz. Plastic [NAME] |  | 72940-11580 | REDOA1Z | 2.05
 | 6 / #10 Cans | 103 oz. | 38.63 lbs. | 604 | 1.02 oz. | Red Gold Nutritionally Enhanced Salsa  6 / #10 Cans |  | 72940-11005 | REDSC99 | 5.9
 | 6 / #10 Cans | 106 oz. | 39.75 lbs. | 144 | 4.4 oz. | Redpack Nutritionally Enhanced Spaghetti Sauce 6 # 10 Cans |  | 72940-82107 | RPKMA9E | 10.32
 | 6 / #10 Cans | 106 oz. | 39.75 lbs. | 144 | 4.4 oz. | Redpack Multi Purpose Spaghetti Sauce 6 / # 10 Cans |  | 72940-82100 | RPKMA9C | 10.67
 | 6 / #10 Cans | 105 oz. | 39.38 lbs. | 140 | 4.5 oz. | Redpack Nutritionally Enhanced Marinara Sauce 6 / # 10 Cans |  | 72940-82206 | RPKNA9E | 7.33
 | 6 / #10 Cans | 105 oz. | 39.38 lbs. | 145 | 4.4 oz. | Redpack Multi Purpose [NAME] 6 / # 10 Cans |  | 72940-82200 | RPKNA99 | 7.52
 |  | 106 oz. | 39.75 lbs. | 291 | 2.2 oz. | Redpack Nutritionally Enhanced Fully Prepared Pizza Sauce 6 / # 10 Cans |  | 72940-81909 | RPKIL9E | 12.26
 | 6 / #10 Cans | 106 oz. | 39.75 lbs. | 291 | 2.2 oz. | Redpack Fully Prepared Pizza Sauce 6 / # 10 Cans |  | 72940-81907 | RPKIL99 | 12.26
 | 6 / #10 Cans | 105 oz. | 39.38 lbs. | 293 | 2.2 oz. | Redpack Extra Heavy Pizza Sauce w/ Basil 6 / # 10 Cans |  | 72940-81903 | RPKIX99 | 15.354
 | 6 / #10 Cans | 108 oz. | 40.50 lbs. | 282 | 2.3 oz. | Redpack Sloppy [NAME] 6 / # 10 Cans |  | 72940-74150 | RPK1A99 | 10.52
 | 6 / #10 Cans | 105 oz. | 39.38 lbs. | 293 | 2.2 oz. | Redpack Concentrated & Crushed All Purpose Tomatoes 6  # 10 Cans |  | 72940-81400 | RPKDX99 | 17.41
 |  | 111 oz. | 41.63 lbs. | 555 | 1.2 oz. | Redpack Tomato Paste 6 / # 10 Cans |  | 72940-82300 | RPKUA99 | 30.97
 | 6 / #10 Cans | 106 oz. | 39.75 lbs. | 289 | 2.2 oz. | Redpack Tomato Sauce 6 / # 10 Cans |  | 72940-81800 | RPKHA99 | 9.72
 | 6 / #10 Cans | 106 oz. | 39.75 lbs. | 288 | 2.2 oz. | Redpack Tomato Puree (1.06 Specific Gravity) 6 / # 10 Cans |  | 72940-81701 | RPKH69X | 16.26
 | 12 / 46 oz. Cans | 46 oz. | 36.86 lbs. | 69 | 8.6 oz. | Sacramento Tomato Juice 12 / 46 oz. Cans |  | 72940-76002 | SACVA46 | 6.45
 |  |  |  |  |  |  |  |  |  |  | TOTAL ALL BRANDS
 |  | *100332 = Totes of Tomato Paste / 1 Tote = 2,850 lbs of Paste / 1 truckload of 100332 = 14 Totes or 39,900 lbs. of Paste |  |  |  |  |  |  |  | TOTAL ENTITLEMENT DOLLARS COMMITTED
 |  | ** For use with a dispenser, consult your local Red Gold representative.
 |  | NOTE 1: The Donated Foods (DF) entity code is 100332 / Totes of Tomato Paste. The Pass Thru Value (PTV) or NOI (Net Off Invoice) discount amount has been determined based on the quantity of tomato paste in the products being offered under this program. 100332 values quoted for the SY 2013 / 2014 were provided by FNS via the 11/16/12 NMPA notification @ $.3612 per pound or $14,411.88 per truckload of paste. The corresponding Pass Through Value Discount per case for each product is indicated above.
 |  |  |  |  |  |  | Redpack, Sacramento and Red Gold are the registered trademarks of Red Gold, LLC., [NAME], IN