Spreadsheet: 145917d1331815483-need-help-with-weighted-average-test-1
Sheet: Weekly Comparison Yields

[NAME] - [NAME] |  |  |  | PRODUCTION VARIANCES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production Pounds
Weekly Processing Recap |  |  |  | WE031112 |  |  | Current Week |  | WE030412 |  |  | WE022612 |  |  | WE021912 |  |  |  | WE031112 | WE030412 | WE022612 | WE021912
 |  |  | FY13 Yield Baseline | Yield $ | Sub $ | Price $ | Yield Per /Cwt. | Vs. Baseline | Yield $ | Sub $ | Price $ | Yield $ | Sub $ | Price $ | Yield $ | Sub $ | Price $ |  | Prod (lbs) | Prod (lbs) | Prod (lbs) | Prod (lbs)
499001 | Ham [NAME] |  |  | 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
431101 | Seam Boning |  |  | 115400 | -3053 | 928 |  |  | 92213 | -5019 | 11840 | 88291 | -4003 | -4236 | 102969 | -4660 | 4359 |  | 2435768 | 2624330 | 2208519 | 2150822
431201 | Deffatting |  |  | -47765 | -3830 | -55 |  |  | -45799 | -1995 | -2101 | -48686 | -4006 | -4444 | -51910 | -268 | -2908 |  | 872257 | 976501 | 936771 | 885173
510011 | Ham Grind & Blend |  |  | -23 | 15 | -2877 |  |  | -137 | -3 | 7943 | 215 | -827 | -5864 | 144 | 0 | -1917 |  | 126567 | 148185 | 118676 | 117018
521001 | Ham Cure |  |  | 597 | -44626 | -1532 |  |  | 5223 | 2417 | -37211 | 5689 | 25432 | -64116 | 8642 | -54714 | 6836 |  | 1968767 | 2579111 | 2128184 | 2108505
523101 | Ham Massage |  |  | 22994 | -2698 | 1308 |  |  | 8513 | -5995 | 6382 | 11317 | -650 | -4628 | 5905 | 759 | 3928 |  | 1970566 | 2439308 | 2180355 | 1906117
531201 | BNLS Ham Stuff |  |  | -6827 | 0 | 1380 |  |  | -10183 | 1960 | 4421 | -13623 | 0 | -2069 | -12113 | 0 | 4515 |  | 1055790 | 1197397 | 1064289 | 956394
531202 | BI Ham Stuff |  |  | -3363 | 0 | -515 |  |  | -5193 | 947 | 8171 | -3547 | 1032 | -1713 | -3632 | 0 | 4857 |  | 733410 | 1151516 | 842340 | 960497
542001 | Smokehouse - Hams |  |  | 2181 | 0 | -3112 |  |  | 4402 | -93 | 5698 | 6305 | -102 | -1219 | -2606 | 0 | 355 |  | 1617630 | 2122697 | 1725854 | 1709221
550001 | Cooler - Hams |  |  | 4383 | 0 | -1529 |  |  | 4542 | 0 | 15913 | 1788 | 0 | -6256 | -1645 | 0 | 11779 |  | 1768278 | 1945997 | 1738522 | 1739501
561101 | Smoked Meats Pack - Boneless |  |  | 35803 | -3444 | -2049 |  |  | 33519 | -22927 | -4380 | 31504 | -623 | 3152 | 28108 | -1897 | -1981 |  | 907202.5 | 1029650.2 | 891049.55 | 987975.1000000001
563601 | Smoked Meats Pack - Bone In |  |  | -4054 | -704 | -206 |  |  | -3429 | -934 | -597 | -3899 | 2870 | 7388 | 3439 | -1832 | -7128 |  | 821823.7 | 886628.5 | 814315.8 | 731679.4
 | Total Smoked Meats
532201 | 4th Flr Massage |  |  | -226 | 41 | -1 |  |  | -1526 | -370 | 9 | -1539 | 123 | 1195 | -839 | 748 | 2 |  | 39924 | 55447 | 46060 | 53687
532211 | 6th Flr Stuff |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
533201 | 8th Flr Stuff |  |  | -2428 | -654 | 1822 |  |  | -3160 | 0 | -2397 | -3145 | -740 | 1188 | -3652 | -397 | 2731 |  | 310852.7 | 343485.3 | 305504.2 | 267648.2
543001 | 4th/6th Flr Deli Smkhs |  |  | -274 | -144 | 1856 |  |  | -226 | 0 | -2869 | 574 | 0 | -172 | -579 | 0 | -2176 |  | 236543 | 212624 | 195014 | 159018
561201 | 4th Floor Deli Pack |  |  | 2434 | 925 | -565 |  |  | 3718 | 943 | -124 | 879 | -164 | 340 | 809 | 364 | -584 |  | 200167.38 | 149365.58 | 145319.86 | 127166.53
562201 | 8th [NAME] |  |  | 1012 | 0 | -263 |  |  | 3936 | 0 | 737 | 956 | 1 | -395 | 934 | 0 | 1590 |  | 188928.9 | 190300.2 | 134998.7 | 144377.7
 | Total Canning
 | Total Smk Meats and Canning
Total Smk Meat and Cann Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2095198 | 2219152 | 1956092 | 1977630
611501 | Belly Frozen |  |  | 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
612101 | Belly Tumble |  |  | 9116 | 7528 | -30070 |  |  | 15092 | 2062 | -7278 | 20939 | -176 | -20987 | -6867 | 663 | 1000 |  | 1841278 | 1571811 | 1466332 | 1547494
612201 | Belly Conversion |  |  | -18346 | 2878 | 2511 |  |  | -28511 | 4885 | -773 | -46732 | 4001 | -1121 | -5649 | 1416 | 61 |  | 1988686 | 1791273 | 1879306 | 1635818
613001 | Belly Pump |  |  | -15099 | -15021 | -20 |  |  | 12472 | 760 | -18150 | 3878 | 9103 | -66093 | 1174 | 7270 | -33465 |  | 1896309 | 1776937 | 1982419 | 1713205
615001 | Smokehouse - Bacon |  |  | 1991 | 0 | 60 |  |  | 12775 | 0 | 687 | 15013 | 0 | -7915 | 9649 | 0 | -2497 |  | 1732207 | 1634446 | 1821571 | 1575720
620001 | Cooler - Bacon |  |  | 4797 | -47 | 729 |  |  | -1826 | -116 | 2004 | 14418 | -28 | -56018 | -1256 | -256 | 9183 |  | 1772512 | 1588123 | 1770374 | 1581310
620101 | Belly Smk/Pressed |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
631101 | Bacon Slice - Retail |  |  | 15144 | -3011 | 2743 |  |  | 16295 | -5452 | -1791 | 20472 | -6886 | 1771 | 13189 | -9675 | 2315 |  | 694441 | 740077 | 761748 | 793559
631201 | Bacon Slice - Food Service |  |  | -1584 | -6335 | -13 |  |  | -5681 | -3682 | -3311 | -6094 | 1250 | -830 | -4391 | -5887 | 266 |  | 1070340 | 850116 | 1001864 | 787470
 | Total Bacon
Total Bacon Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1706646 | 1540736 | 1711356 | 1517395
710001 | Sausage - Grind |  |  | -5442 | -1935 | -125 |  |  | -2847 | 46 | 2741 | -612 | 313 | 6425 | -74 | -6923 | 9676 |  | 900859 | 899645 | 993533 | 846337
711011 | Sausage - Blend |  |  | -84 | -2018 | -153 |  |  | -100 | -916 | -474 | -224 | -3000 | 136 | -88 | 2 | 105 |  | 160613 | 179768 | 180984 | 187923
812001 | [NAME] |  |  | -976 | 1976 | 330 |  |  | -5741 | 1375 | 2857 | -1677 | -1115 | 156 | -1135 | -407 | 74 |  | 217211 | 346163 | 321155 | 265757
813001 | Hotdog Blend |  |  | 1325 | 4464 | 555 |  |  | 1184 | 14220 | 435 | 5922 | 6159 | 1134 | -1187 | 19404 | 724 |  | 780748 | 803609 | 801514 | 725933
821001 | Sausage Stuff |  |  | 75 | -904 | 49 |  |  | -719 | -2911 | 429 | 589 | -1362 | 43 | -325 | -1296 | 902 |  | 265855.5 | 349341 | 298340.5 | 351187
823001 | [NAME] |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
830001 | Processed Smoke/Cook |  |  | 866 | 0 | 107 |  |  | 5638 | 5000 | 1595 | 410 | 3944 | 130 | 1529 | 11542 | -40 |  | 254921 | 303274 | 270813 | 253372
840001 | Processed Cooler |  |  | -833 | 0 | -2 |  |  | -327 | 0 | 0 | -781 | 0 | 10 | -345 | 0 | 18 |  | 15708 | 8457 | 19118 | 9726
851001 | Processed Sausage Pack |  |  | 829 | 434 | 75 |  |  | 2302 | 773 | 1947 | 533 | 568 | 301 | -1864 | 2104 | 363 |  | 276558.3 | 307952.1 | 277801.7 | 281493.9
852201 | Hotdog Pack |  |  | 3772 | -2665 | 77 |  |  | 7113 | 0 | -525 | 2419 | 0 | 80 | 2769 | 0 | -97 |  | 688930 | 710548 | 712600 | 639418
723001 | Fresh Sausage - Skin-On Links |  |  | 498 | 0 | -95 |  |  | -39 | 0 | 43 | -18 | 0 | -96 | -22 | 0 | -46 |  | 77662 | 72570 | 85328 | 69630
724001 | Fresh Saus - Sknls Links, Chubs, Patties |  |  | 260 | -41 | -100 |  |  | 664 | 57 | 45 | 273 | 563 | 149 | 183 | 377 | -19 |  | 120242 | 132667 | 88220 | 139315
853002 | 4X6 Slicing |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | Total Sausage
Total Sausage Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1163392 | 1223737 | 1163950 | 1129857
 | Total Processed Meats Yields
Total Finished Goods