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

 |  |  |  | Yield Version 2 |  |  |  |  |  |  |  | Production Pounds
Weekly Processing Recap |  |  |  | WE031112 |  |  |  |  |  |  |  | WE031112
Fiscal Week | 45 |  | FY13 Yield Baseline | Current Yield $ | Current Yield Per /Cwt. | Curent vs. Baseline | Yield Savings |  | Sub $ | Price $ |  | Prod (lbs)
 |  |  |  |  |  |  |  |  |  |  |  |  | Total By workcenter |  | Total
499001 | Ham [NAME] |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
499101 | Ham Defrost |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
431101 | Seam Boning |  |  | 115400 |  |  |  |  | -3053 | 928 |  | 2435768
431201 | Deffatting |  |  | -47765 |  |  |  |  | -3830 | -55 |  | 872257
510011 | Ham Grind & Blend |  |  | -23 |  |  |  |  | 15 | -2877 |  | 126567
521001 | Ham Cure |  |  | 597 |  |  |  |  | -44626 | -1532 |  | 1968767
523101 | Ham Massage |  |  | 22994 |  |  |  |  | -2698 | 1308 |  | 1970566
531201 | BNLS Ham Stuff |  |  | -6827 |  |  |  |  | 0 | 1380 |  | 1055790
531202 | BI Ham Stuff |  |  | -3363 |  |  |  |  | 0 | -515 |  | 733410
542001 | Smokehouse - Hams |  |  | 2181 |  |  |  |  | 0 | -3112 |  | 1617630
550001 | Cooler - Hams |  |  | 4383 |  |  |  |  | 0 | -1529 |  | 1768278
561101 | Smoked Meats Pack - Boneless |  |  | 35803 |  |  |  |  | -3444 | -2049 |  | 907202.5
563601 | Smoked Meats Pack - Bone In |  |  | -4054 |  |  |  |  | -704 | -206 |  | 821823.7
 | Total Smoked Meats |  | 4.87
532201 | 4th Flr Massage |  |  | -226 |  |  |  |  | 41 | -1 |  | 39924
532211 | 6th Flr Stuff |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
533201 | 8th Flr Stuff |  |  | -2428 |  |  |  |  | -654 | 1822 |  | 310852.7
543001 | 4th/6th Flr Deli Smkhs |  |  | -274 |  |  |  |  | -144 | 1856 |  | 236543
561201 | 4th Floor Deli Pack |  |  | 2434 |  |  |  |  | 925 | -565 |  | 200167.38
562201 | 8th [NAME] |  |  | 1012 |  |  |  |  | 0 | -263 |  | 188928.9
 | Total Canning
 | Total Smk Meats and Canning
Total Smk Meat and Cann Finished Goods |  |  |  |  |  |  |  |  |  |  |  | 2095198
611501 | Belly Frozen |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
612001 | Belly Defrost |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
612101 | Belly Tumble |  |  | 9116 |  |  |  |  | 7528 | -30070 |  | 1841278
612201 | Belly Conversion |  |  | -18346 |  |  |  |  | 2878 | 2511 |  | 1988686
613001 | Belly Pump |  |  | -15099 |  |  |  |  | -15021 | -20 |  | 1896309
615001 | Smokehouse - Bacon |  |  | 1991 |  |  |  |  | 0 | 60 |  | 1732207
620001 | Cooler - Bacon |  |  | 4797 |  |  |  |  | -47 | 729 |  | 1772512
620101 | Belly Smk/Pressed |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
631101 | Bacon Slice - Retail |  |  | 15144 |  |  |  |  | -3011 | 2743 |  | 694441
631201 | Bacon Slice - Food Service |  |  | -1584 |  |  |  |  | -6335 | -13 |  | 1070340
 | Total Bacon
Total Bacon Finished Goods |  |  |  |  |  |  |  |  |  |  |  | 1706646
710001 | Sausage - Grind |  |  | -5442 |  |  |  |  | -1935 | -125 |  | 900859
711011 | Sausage - Blend |  |  | -84 |  |  |  |  | -2018 | -153 |  | 160613
812001 | [NAME] |  |  | -976 |  |  |  |  | 1976 | 330 |  | 217211
813001 | Hotdog Blend |  |  | 1325 |  |  |  |  | 4464 | 555 |  | 780748
821001 | Sausage Stuff |  |  | 75 |  |  |  |  | -904 | 49 |  | 265855.5
823001 | [NAME] |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
830001 | Processed Smoke/Cook |  |  | 866 |  |  |  |  | 0 | 107 |  | 254921
840001 | Processed Cooler |  |  | -833 |  |  |  |  | 0 | -2 |  | 15708
851001 | Processed Sausage Pack |  |  | 829 |  |  |  |  | 434 | 75 |  | 276558.3
852201 | Hotdog Pack |  |  | 3772 |  |  |  |  | -2665 | 77 |  | 688930
723001 | Fresh Sausage - Skin-On Links |  |  | 498 |  |  |  |  | 0 | -95 |  | 77662
724001 | Fresh Saus - Sknls Links, Chubs, Patties |  |  | 260 |  |  |  |  | -41 | -100 |  | 120242
853002 | 4X6 Slicing |  |  | 0 |  |  |  |  | 0 | 0 |  | 0
 | Total Sausage
Total Sausage Finished Goods |  |  |  |  |  |  |  |  |  |  |  | 1163392
 | Total Processed Meats Yields
Total Finished Goods