Spreadsheet: 876391d1723066600-value-error-help-my-mrp-copy
Sheet: Raw Materials

 |  | CTRL + ALT + F5 |  |  | Week 1 |  |  |  |  |  | Week 2 |  |  |  |  |  | Week 3 |  |  |  |  |  | Week 4
 |  | Description | UoM | Line # | Current Inv | Usage | Purchase Qty | UoM | Ending Inv |  | Current Inv | Usage | Purchase Qty | UoM | Ending Inv |  | Current Inv | Usage | Purchase Qty | UoM | Ending Inv |  | Current Inv | Usage | Purchase Qty | UoM | Ending Inv |  | Weekly Avg
 | CP | Cocoa Premix | LB | 090120 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | PC | Premium Cocoa | LB | 090282 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | S | Salt | LB | 110035 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | AA | Ascorbic Acid | LB | 110048 |  |  |  | Box |  |  |  |  |  | Box |  |  |  |  |  | Box |  |  |  |  |  | Box
 | SC | Sodium Citrate | LB | 110085 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | A | Aspartame | LB | 110240 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | PS | Potassium Sorbate | LB | 110248 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | TP | Tricalcium Phosphate | LB | 110228 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | SB | Sodium Benzoate | LB | 110298 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | CL | Calcium Lactate | LB | 110563 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | M | [NAME] | LB | 110567 |  |  |  | Box |  |  |  |  |  | Box |  |  |  |  |  | Box |  |  |  |  |  | Box
 | OA | Orange Aroma | LB | 171579 |  |  |  | Bottle |  |  |  |  |  | Bottle |  |  |  |  |  | Bottle |  |  |  |  |  | Bottle
 | OAO | Orange Addback Oil | LB | 171705 |  |  |  | Bottle |  |  |  |  |  | Bottle |  |  |  |  |  | Bottle |  |  |  |  |  | Bottle
 | OB | Orange Drink Base | GAL | 171777 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 | FPB | Fruit Punch Drink Base | GAL | 171778 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 | XG | [NAME] | LB | 440284 |  |  |  | Box |  |  |  |  |  | Box |  |  |  |  |  | Box |  |  |  |  |  | Box
 | BS | Buttermilk Stabilizer FL-190 | LB | 440409 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | TC | Tea Concentrate | GAL | 580215 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 | CTC | Caff Tea Concentrate | GAL | 580012 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 | ADJ | Adjisweet | LB | 110314 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | NC | Neutral Cloud | LB | 171770 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 | TTB | Tampico Tropical Base | GAL | 172181 |  |  |  | Gal |  |  |  |  |  | Gal |  |  |  |  |  | Gal |  |  |  |  |  | Gal
 | TDB445 | Tampico Dry Blend 445 | BAG | 445445 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | TMPB | Tampico Mango Punch Base | GAL | 172183 |  |  |  | Gal |  |  |  |  |  | Gal |  |  |  |  |  | Gal |  |  |  |  |  | Gal
 | TCPB | Tampico Citrus Punch Base | GAL | 172180 |  |  |  | Gal |  |  |  |  |  | Gal |  |  |  |  |  | Gal |  |  |  |  |  | Gal
 | TDB444 | Tampico Dry Blend 444 | BAG | 445444 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | LJC | 12% Lemon Juice Concentrate | GAL | 170257 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 |  | Brewed Tea Extract Part 1 | GAL | 580021 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 |  | Decaf Brewed Tea Extract Part 2 | GAL | 580020 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 |  | Caffeinated Brewed Tea Extract Part 2 | GAL | 580019 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 |  | [NAME] | LB | 171470
 |  | Peach Flavor | LB | 171314
 |  | Blackberry Flavor | LB | 171312
 |  | Blue Raspberry Flavor | GAL | 170304 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 |  | Potassium Acesulfame | LB | 110482 |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag |  |  |  |  |  | Bag
 | DENB | Dry Eggnog Base | LB | 173027 |  |  |  | BAG |  |  |  |  |  | BAG |  |  |  |  |  | BAG |  |  |  |  |  | BAG
 | PENB | Pumpkin Eggnog Base | LB | 173028 |  |  |  | BAG |  |  |  |  |  | BAG |  |  |  |  |  | BAG |  |  |  |  |  | BAG
 | CENB | Custard Eggnog Base | LB | 173029 |  |  |  | BAG |  |  |  |  |  | BAG |  |  |  |  |  | BAG |  |  |  |  |  | BAG
 | ENF | Eggnog Flavor | GAL | 173030 |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail |  |  |  |  |  | 5 gal pail
 |  | SUMIFS(tblLOCDTL[LDLOCQ], tblLOCDTL[LDRESC], $E3, tblLOCDTL[LDWHSE], "52")