Spreadsheet: 145917d1331815483-need-help-with-weighted-average-test-1
Sheet: Baseline V2

Weekly Processing Recap |  |  | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 |  |  |  | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43
 |  |  | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Yield $ | Total Baseline Yield | Per /Cwt. |  | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs) | Total Baseline Lbs
499001 | Ham [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
499101 | Ham Defrost |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
431101 | Seam Boning |  | 127110 | 147425 | 84143 | 83124 | 54276 | 73042 | 62562 | 53600 | 96685 | 103274 | 102952 | 102969 | 88291 |  |  |  | 2493081 | 2146901 | 1986345 | 1996796 | 1567460 | 1654773 | 2009582 | 1971351 | 2586213 | 2610779 | 2594949 | 2150822 | 2208519
431201 | Deffatting |  | -55605 | -90962 | -16321 | -21065 | -17421 | -25313 | -20591 | -9801 | -44010 | -47950 | -37913 | -51910 | -48686 |  |  |  | 1267889.07 | 1146158 | 437494 | 308970 | 357456 | 591928 | 513797 | 265132 | 774660 | 755269 | 833017 | 885173 | 936771
510011 | Ham Grind & Blend |  | -1867 | -740 | -1158 | -442 | -2337 | -250 | -342 | -910 | -117 | 300 | 244 | 144 | 215 |  |  |  | 140062 | 144325 | 112304 | 112368 | 85389 | 90998 | 107434 | 132914 | 122574 | 132718 | 111456 | 117018 | 118676
521001 | Ham Cure |  | 17306 | 6461 | 3385 | -4675 | -1780 | 4993 | 4686 | -1057 | -1238 | 858 | 3191 | 8642 | 5689 |  |  |  | 3214516 | 2330411 | 1706486 | 1398165 | 1146422 | 1247466 | 1802941 | 1386327 | 2000501 | 2187318 | 2151584 | 2108505 | 2128184
523101 | Ham Massage |  | 7636 | -414 | 3285 | 2130 | 4842 | 1052 | 167 | -204 | 8267 | 7805 | 5603 | 5905 | 11317 |  |  |  | 2955807 | 1928321 | 1658969 | 1339380 | 1194864 | 1330789 | 1858770 | 1448446 | 1882034 | 1900748 | 2136795 | 1906117 | 2180355
531201 | BNLS Ham Stuff |  |  | -18267 | -10135 | -5740 | -9315 | -4288 | -2050 | -5855 | -14437 | -15469 | -16997 | -12113 | -13623 |  |  |  | 1771156 | 1121571 | 940484 | 921137 | 741608 | 766738 | 880718 | 945988 | 1098976 | 1140500 | 1047417 | 956394 | 1064289
531202 | BI Ham Stuff |  | 1311 | 6905 | 1955 | 1228 | 1709 | -259 | 4667 | 1856 | 8499 | 3623 | 4754 | -3632 | -3547 |  |  |  | 1450426 | 1316953 | 613331 | 233405 | 312653 | 357086 | 783426 | 331667 | 708044 | 767650 | 758812 | 960497 | 842340
542001 | Smokehouse - Hams |  | 13853 | -6024 | 4675 | 9441 | 186 | 2372 | 3787 | 8099 | 903 | -4035 | 9247 | -2606 | 6305 |  |  |  | 2869477 | 2163565 | 1385597 | 1030185 | 946221 | 1020588 | 1498192 | 1156009 | 1614544 | 1722442 | 1661523 | 1709221 | 1725854
550001 | Cooler - Hams |  | 7835 | -62 | 5174 | 1665 | 1276 | -1172 | 3408 | 109 | 1167 | 3844 | -5211 | -1645 | 1788 |  |  |  | 2760795 | 2306549 | 1648328 | 1082864 | 797549 | 1072842 | 1233393 | 1257396 | 1418334 | 1667039 | 1399249 | 1739501 | 1738522
561101 | Smoked Meats Pack - Boneless |  | 46949 | 36501 | 22409 | 17100 | 15966 | 14105 | 26086 | 26091 | 28579 | 36029 | 33222 | 28108 | 31504 |  |  |  | 1207661.6 | 1017612 | 819101.3 | 782533.1000000001 | 535650.1 | 665732.7 | 746337.3999999999 | 785265.1 | 916226.1 | 960510.9 | 730188.8999999999 | 987975.1000000001 | 891049.55
563601 | Smoked Meats Pack - Bone In |  | -6516 | -13100 | 5490 | -4019 | -3287 | 3632 | 1752 | 4536 | 4345 | 12586 | 6898 | 3439 | -3899 |  |  |  | 1515916.8 | 1244497.15 | 728335.8 | 230783.2 | 230966.7 | 355423.7 | 431017.8 | 439175.1 | 460714.8 | 670992.45 | 636910.5 | 731679.4 | 814315.8
 | Total Smoked Meats |  |  |  |  |  |  |  |  | 76464
532201 | 4th Flr Massage |  | 1147 | 1539 | -64 | -3393 | -1759 | -143 | -1041 | -663 | -240 | -2471 | -1134 | -839 | -1539 |  |  |  | 45848 | 47383 | 32007 | 42183 | 35996 | 28850 | 36860 | 62872 | 31725 | 67072 | 22567 | 53687 | 46060
532211 | 6th Flr Stuff |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
533201 | 8th Flr Stuff |  | -2131 | -1317 | -3609 | -3709 | -3106 | -2927 | -4075 | -2741 | -1754 | -2657 | -3068 | -3652 | -3145 |  |  |  | 354617.8 | 336991.3 | 291601.7 | 294173.7 | 224749.5 | 206166.6 | 307216.7 | 340196.1 | 228019.5 | 342585.2 | 317383.9 | 267648.2 | 305504.2
543001 | 4th/6th Flr Deli Smkhs |  | 2110 | -1029 | 526 | -345 | 1776 | -2905 | -264 | -678 | 331 | -566 | -2839 | -579 | 574 |  |  |  | 152991 | 163785 | 143559 | 146392 | 102863 | 133981 | 186836 | 146378 | 143140 | 163289 | 167392 | 159018 | 195014
561201 | 4th Floor Deli Pack |  | 2929 | -87 | 1571 | -199 | -952 | -3670 | -514 | 1442 | 1457 | 3289 | -757 | 809 | 879 |  |  |  | 130092.57 | 133131.11 | 134466.7 | 149332.15 | 99804.63 | 111322.48 | 177151.02 | 146185.86 | 130078.89 | 135643.51 | 153101.39 | 127166.53 | 145319.86
562201 | 8th [NAME] |  | 1615 | 1000 | 3149 | -577 | 586 | 1466 | 1236 | 863 | -144 | 1935 | 1730 | 934 | 956 |  |  |  | 161062.6 | 199763.7 | 156413.9 | 152297.9 | 125742.1 | 99208.3 | 162211 | 181250.9 | 76604.80000000002 | 206910.7 | 201914.2 | 144377.7 | 134998.7
 | Total Canning |  |  |  |  |  |  |  |  | -1777
 | Total Smk Meats and Canning
Total Smk Meat and Cann Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3004587 | 2582675 | 1828551 | 1303105 | 981273 | 1221687 | 1500527 | 1543685 | 1572698 | 1572698 | 1709452 | 1977630 | 1956092
611501 | Belly Frozen |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
612001 | Belly Defrost |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
612101 | Belly Tumble |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -6867 | 20939 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1547494 | 1466332
612201 | Belly Conversion |  | -43799 | -45618 | -32753 | -35054 | -13743 | -28876 | -25461 | 9216 | -11689 | 1672 | -16646 | -5649 | -46732 |  |  |  | 2164969 | 2233552 | 2289646 | 1829174 | 1656439 | 2150853 | 2193283 | 1883601 | 1666572 | 1441483 | 1621903 | 1635818 | 1879306
613001 | Belly Pump |  | -15792 | -6035 | -12396 | -10443 | -12774 | -9350 | -9654 | -8895 | -9827 | -86 | -809 | 1174 | 3878 |  |  |  | 1777385 | 1806791 | 1953047 | 1635869 | 1607526 | 1657975 | 1914821 | 1916766 | 1770962 | 1715927 | 1983294 | 1713205 | 1982419
615001 | Smokehouse - Bacon |  | 2401 | 5037 | 696 | 4543 | -640 | -2278 | 6413 | 15471 | 10381 | 11106 | 15482 | 9649 | 15013 |  |  |  | 1637013 | 1666119 | 1797332 | 1508523 | 1478399 | 1521718 | 1764193 | 1767272 | 1629339 | 1579848 | 1825260 | 1575720 | 1821571
620001 | Cooler - Bacon |  | -16448 | -3010 | 897 | -5009 | -4510 | -1580 | 3941 | -2116 | 5065 | 8761 | 7961 | -1256 | 14418 |  |  |  | 1595505 | 1659460 | 1801760 | 1453645 | 1447421 | 1547988 | 1689870 | 1728700 | 1613972 | 1573956 | 1794590 | 1581310 | 1770374
620101 | Belly Smk/Pressed |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
631101 | Bacon Slice - Retail |  | 12475 | 12388 | 20683 | 12847 | 8378 | 16123 | 21268 | 15864 | 14926 | 16172 | 3372 | 13189 | 20472 |  |  |  | 825305 | 859521 | 907511 | 752596 | 715718 | 770140 | 927919 | 936946 | 843376 | 765261 | 872733 | 793559 | 761748
631201 | Bacon Slice - Food Service |  | -10917 | -10239 | -17992 | -13731 | -11802 | -12499 | -36881 | -18606 | -8102 | -15498 | -7367 | -4391 | -6094 |  |  |  | 807574 | 824984 | 900166 | 709270 | 748141 | 783085 | 766628 | 793701 | 774341 | 801631 | 918432 | 787470 | 1001864
 | Total Bacon |  |  |  |  |  |  |  |  | 10934
Total Bacon Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1542566 | 1595965 | 1731186 | 1404493 | 1395308 | 1499975 | 1624329 | 1662512 | 1556605 | 1556605 | 1737706 | 1517395 | 1711356
710001 | Sausage - Grind |  | -915 | 312 | -661 | 442 | 188 | 2423 | -1300 | 465 | -2012 | -2023 | 724 | -74 | -612 |  |  |  | 762796 | 862513 | 941621 | 926779 | 805931 | 857631 | 1129186 | 961889 | 985192 | 865753 | 738377 | 846337 | 993533
711011 | Sausage - Blend |  | -64 | -74 | -52 | -116 | -92 | -54 | -216 | -23 | -117 | -83 | -77 | -88 | -224 |  |  |  | 159070 | 153495 | 188324 | 201214.5 | 171310 | 175763 | 281079 | 211653 | 219827 | 184821 | 129372 | 187923 | 180984
812001 | [NAME] |  | -561 | -250 | -1878 | -793 | -137 | -307 | -1305 | -677 | -869 | -624 | -845 | -1135 | -1677 |  |  |  | 315564 | 353772 | 311798 | 290896 | 245795 | 227157 | 252966 | 255530 | 278634 | 250879 | 254317 | 265757 | 321155
813001 | Hotdog Blend |  | 686 | 1318 | 2263 | 3864 | 1573 | 5295 | 7295 | 1853 | 2321 | 2079 | -1798 | -1187 | 5922 |  |  |  | 600010 | 749203 | 726399 | 810934 | 630080 | 674733 | 884811 | 809390 | 786181 | 706846 | 642524 | 725933 | 801514
821001 | Sausage Stuff |  | 467 | 506 | -1268 | -134 | 1893 | -33 | -590 | 626 | 781 | -148 | 132 | -325 | 589 |  |  |  | 372712 | 381778 | 371105 | 280928 | 245298 | 237739 | 302424 | 269709 | 315543 | 265943 | 254243 | 351187 | 298340.5
823001 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 976 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
830001 | Processed Smoke/Cook |  | 2199 | 2054 | 929 | 884 | 87 | 733 | 841 | 55 | 318 | 675 | 678 | 1529 | 410 |  |  |  | 42988 | 42667 | 38417 | 38993 | 28199 | 33621 | 42830 | 17993 | 32213 | 36565 | 47182 | 253372 | 270813
840001 | Processed Cooler |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -345 | -781 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9726 | 19118
851001 | Processed Sausage Pack |  | -7718 | -7880 | -12363 | -1207 | -2296 | -4746 | -2749 | 1539 | -1034 | 230 | 193 | -1864 | 533 |  |  |  | 291742.3 | 319201.3 | 328365.1 | 279502.9 | 201336.7 | 217525.7 | 278426.2 | 228323.1 | 279768.2 | 247310.5 | 261433.8 | 281493.9 | 277801.7
852201 | Hotdog Pack |  | 927 | 6312 | 12514 | 8166 | 7544 | -958 | 13491 | 1488 | -6425 | 252 | -1344 | 2769 | 2419 |  |  |  | 529274 | 663028 | 645660 | 723590 | 563084 | 597842 | 792826 | 713077 | 690057.5 | 624268 | 561290 | 639418 | 712600
723001 | Fresh Sausage - Skin-On Links |  | 224 | 352 | -87 | -273 | 47 | -1525 | -33 | -397 | -587 | -175 | 241 | -22 | -18 |  |  |  | 37796 | 88974 | 92280 | 77278 | 62080 | 62020 | 57960 | 82280 | 83992 | 68262 | 34920 | 69630 | 85328
724001 | Fresh Saus - Sknls Links, Chubs, Patties |  | 636 | 31 | 1026 | 1026 | 1658 | 1943 | 1069 | 552 | 811 | 48 | 129 | 183 | 273 |  |  |  | 151715 | 99692 | 126330 | 152725 | 151582 | 135443 | 228170 | 150460 | 165084 | 144739 | 120523 | 139315 | 88220
853002 | 4X6 Slicing |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Sausage |  |  |  |  |  |  |  |  | 5481
Total Sausage Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1010527 | 1170895 | 1195635 | 1233096 | 978083 | 1012831 | 1357382 | 1173364 | 1218902 | 1218902 | 978167 | 1129857 | 1163950
 | Total Processed Meats Yields |  |  |  |  |  |  |  |  | 91102
Total Finished Goods