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

[NAME] - [NAME] |  |  | LABOR VARIANCES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production Pounds
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
 |  |  | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | 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 |  | 8040.794400000006 | 261.7507000000012 | 3140.813500000006 | 2801.492599999991 | 1565.241899999999 | 2014.096599999998 | -380.8345999999905 | 80.29879999999787 | 2189.701500000011 | 2750.8186 | 5082.212399999989 | 2370.373799999998 | 67.24049999999647 |  |  |  | 2493081 | 2146901 | 1986345 | 1996796 | 1567460 | 1654773 | 2009582 | 1971351 | 2586213 | 2610779 | 2594949 | 2150822 | 2208519
431201 | Deffatting |  | 1110.7351 | 957.9334999999987 | 353.7434999999999 | 717.4269 | 67.8251999999998 | 341.0749999999994 | 662.8548999999998 | 245.1842000000005 | 616.8585000000003 | 1145.2324 | 916.8096000000007 | 875.8806000000004 | 382.0040000000004 |  |  |  | 1267889.07 | 1146158 | 437494 | 308970 | 357456 | 591928 | 513797 | 265132 | 774660 | 755269 | 833017 | 885173 | 936771
510011 | Ham Grind & Blend |  | 113.7213 | 107.6922 | 71.7255 | 67.9833 | 66.7359 | 73.5966 | 76.0914 | 140.7483 | 88.5654 | 155.925 | 52.1829 | 129.1059 | 96.0498 |  |  |  | 140062 | 144325 | 112304 | 112368 | 85389 | 90998 | 107434 | 132914 | 122574 | 132718 | 111456 | 117018 | 118676
521001 | Ham Cure |  | -4748.2281 | -4828.477499999999 | -3884.4036 | -2709.1449 | -3505.609799999999 | -4856.9598 | -5207.894999999999 | -7709.139899999999 | -5378.996699999999 | -6390.222299999999 | -7178.786999999999 | -5172.967800000001 | -5392.3023 |  |  |  | 3214516 | 2330411 | 1706486 | 1398165 | 1146422 | 1247466 | 1802941 | 1386327 | 2000501 | 2187318 | 2151584 | 2108505 | 2128184
523101 | Ham Massage |  | -8266.935599999999 | -5760.2853 | -5357.583 | -4694.382 | -4472.7606 | -4749.6834 | -5418.9135 | -5969.432699999999 | -7302.903299999999 | -6359.0373 | -6079.4118 | -5553.632699999999 | -6000.201899999999 |  |  |  | 2955807 | 1928321 | 1658969 | 1339380 | 1194864 | 1330789 | 1858770 | 1448446 | 1882034 | 1900748 | 2136795 | 1906117 | 2180355
531201 | BNLS Ham Stuff |  | 18359.4411 | 17785.2213 | 15574.6206 | 17103.1014 | 11757.5766 | 13820.1525 | 13620.3606 | 17370.8766 | 12620.5695 | 13186.4733 | 5976.293399999999 | 6145.108200000001 | 8776.2906 |  |  |  | 1771156 | 1121571 | 940484 | 921137 | 741608 | 766738 | 880718 | 945988 | 1098976 | 1140500 | 1047417 | 956394 | 1064289
531202 | BI Ham Stuff |  | 10686.4758 | 12012.8778 | 3349.268999999999 | -3763.1979 | -184.6151999999996 | -172.5570000000001 | 5044.485599999998 | -376.7147999999999 | 2393.5527 | 5240.951099999999 | 4820.577299999999 | 8552.7981 | 8012.881799999998 |  |  |  | 1450426 | 1316953 | 613331 | 233405 | 312653 | 357086 | 783426 | 331667 | 708044 | 767650 | 758812 | 960497 | 842340
542001 | Smokehouse - Hams |  | -1534.301999999999 | -5171.9283 | -5244.693299999999 | -2886.0678 | -4429.1016 | -5274.215099999999 | -4840.119899999999 | -3820.786199999999 | -3409.1442 | -1069.0218 | -1404.1566 | 700.8308999999998 | -555.3008999999993 |  |  |  | 2869477 | 2163565 | 1385597 | 1030185 | 946221 | 1020588 | 1498192 | 1156009 | 1614544 | 1722442 | 1661523 | 1709221 | 1725854
550001 | Cooler - Hams |  | 0 | 0 | 0 | 52.3908 | 0 | 48.0249 | 0 | 0 | 0 | 0 | 0 | 0 | 29.9376 |  |  |  | 2760795 | 2306549 | 1648328 | 1082864 | 797549 | 1072842 | 1233393 | 1257396 | 1418334 | 1667039 | 1399249 | 1739501 | 1738522
561101 | Smoked Meats Pack - Boneless |  | -13832.00279999999 | -7217.456399999997 | -10720.77929999999 | -17495.4087 | 2321.203500000002 | 2065.902299999998 | -2703.947400000001 | 1489.187700000001 | 797.0885999999992 | -7251.9678 | -5646.771899999995 | -11173.3776 | -8395.417800000001 |  |  |  | 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 |  | 8121.405599999998 | 16488.3411 | 2890.6416 | 21345.093 | 3165.2775 | 6278.3721 | 10067.9733 | 8465.0643 | 7520.990399999999 | 5600.2023 | 6110.804700000001 | 10929 | 15468.5916 |  |  |  | 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
532201 | 4th Flr Massage |  | 142.6194 | 158.4198 | 98.12879999999998 | 92.30759999999998 | 94.5945 | 95.63399999999999 | 107.9001 | 198.7524 | 124.3242 | 204.9894 | 70.27019999999999 | 181.7046 | 123.2847 |  |  |  | 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 |  | 824.1156 | 812.0573999999999 | 261.7461 | 582.5358 | 466.1118 | 626.1948 | 793.7621999999999 | 994.5935999999999 | 842.2029 | 1126.1943 | 1230.5601 | 972.1404 | 401.247 |  |  |  | 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 |  | 1089.6039 | 1431.1836 | 1039.5 | 570.4776000000006 | -197.5049999999999 | 1757.5866 | 1735.3413 | -1045.9449 | -3407.481 | -1411.640999999999 | -4249.2681 | -756.5481 | 832.6394999999998 |  |  |  | 152991 | 163785 | 143559 | 146392 | 102863 | 133981 | 186836 | 146378 | 143140 | 163289 | 167392 | 159018 | 195014
561201 | 4th Floor Deli Pack |  | -1213.0965 | -2598.957899999999 | -3676.7115 | -102.2868000000007 | 254.8854000000001 | -4932.8433 | -4026.607199999999 | -355.0932000000001 | -1127.649599999999 | 325.3635000000003 | -3165.693299999999 | -6268.8087 | -1665.902700000001 |  |  |  | 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] |  | 54.26189999999951 | 3457.5849 | 536.5899000000004 | -3772.9692 | -3162.3669 | -4187.5218 | -1890.2268 | 2307.2742 | -6599.785499999999 | 862.7849999999994 | 5239.703699999998 | -3235.339800000001 | -1824.7383 |  |  |  | 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
 | 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 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1547494 | 1466332
612201 | Belly Conversion |  | -1502.909100000001 | 87.11009999999993 | -1485.861300000001 | -4334.299199999999 | 11.64240000000018 | 3632.844599999998 | 2224.9458 | -68.60699999999862 | 1791.6822 | -1156.131900000001 | -767.3589000000005 | -2799.581399999999 | -1382.3271 |  |  |  | 2164969 | 2233552 | 2289646 | 1829174 | 1656439 | 2150853 | 2193283 | 1883601 | 1666572 | 1441483 | 1621903 | 1635818 | 1879306
613001 | Belly Pump |  | -2417.2533 | -1930.7673 | -3497.709600000002 | -2587.9392 | -1446.360300000001 | -2124.114300000001 | -3756.753 | -654.261299999999 | -2280.039299999999 | -2146.567500000001 | -2097.2952 | -1739.7072 | -1234.925999999999 |  |  |  | 1777385 | 1806791 | 1953047 | 1635869 | 1607526 | 1657975 | 1914821 | 1916766 | 1770962 | 1715927 | 1983294 | 1713205 | 1982419
615001 | Smokehouse - Bacon |  | 718.2945000000001 | 1292.0985 | 980.4563999999997 | 941.1633000000002 | 762.5772000000001 | 1235.9655 | 1315.7991 | 1348.4394 | 1177.7535 | -1686.2769 | -1364.4477 | -964.4481000000001 | -423.2843999999999 |  |  |  | 1637013 | 1666119 | 1797332 | 1508523 | 1478399 | 1521718 | 1764193 | 1767272 | 1629339 | 1579848 | 1825260 | 1575720 | 1821571
620001 | Cooler - Bacon |  | 238.8771 | 248.2326 | 269.6463 | 217.4634 | 216.8397 | 231.8085 | 253.0143 | 258.8355 | 241.9956 | 235.5507 | 268.8147 | 236.7981 | 265.4883 |  |  |  | 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 |  | -9028.265399999997 | -9769.844699999994 | -13472.95950000001 | -9252.381599999995 | -6260.076900000003 | -8251.135200000002 | -6960.699900000006 | -5856.542999999998 | -15696.03419999999 | -3013.094699999994 | -7684.815599999999 | -3511.015200000002 | -1402.909199999995 |  |  |  | 825305 | 859521 | 907511 | 752596 | 715718 | 770140 | 927919 | 936946 | 843376 | 765261 | 872733 | 793559 | 761748
631201 | Bacon Slice - Food Service |  | -2836.171799999999 | 375.0516000000006 | -5773.383000000001 | -4228.062300000003 | -3543.239699999999 | -4487.521499999998 | -7823.484899999999 | -5052.801600000004 | 491.4755999999978 | -5849.682300000007 | -2871.099000000005 | -3460.911299999998 | -3324.944699999993 |  |  |  | 807574 | 824984 | 900166 | 709270 | 748141 | 783085 | 766628 | 793701 | 774341 | 801631 | 918432 | 787470 | 1001864
 | Total Bacon
Total Bacon Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1542566 | 1595965 | 1731186 | 1404493 | 1395308 | 1499975 | 1624329 | 1662512 | 1556605 | 1556605 | 1737706 | 1517395 | 1711356
710001 | Sausage - Grind |  | -8846 | -10147.6 | -9851.599999999999 | -8387.599999999999 | -6405.4 | -7149.599999999999 | -9593.2 | -7845.599999999999 | -8959.400000000001 | -9017.8 | -8337.8 | -7922 | -7881.599999999999 |  |  |  | 762796 | 862513 | 941621 | 926779 | 805931 | 857631 | 1129186 | 961889 | 985192 | 865753 | 738377 | 846337 | 993533
711011 | Sausage - Blend |  | -831.5999999999999 | -856.5479999999998 | -1029.105 | -519.75 | -1182.951 | -1047.816 | -690.228 | -1041.579 | -1087.317 | -696.4649999999999 | -748.44 | -519.75 | -634.095 |  |  |  | 159070 | 153495 | 188324 | 201214.5 | 171310 | 175763 | 281079 | 211653 | 219827 | 184821 | 129372 | 187923 | 180984
812001 | [NAME] |  | -79.41779999999991 | 1428.0651 | 1054.2609 | 269.2305000000001 | 1191.6828 | -247.8168000000001 | 451.7667000000001 | 134.5113 | 949.0634999999999 | 1134.7182 | 403.326 | -1180.2483 | 662.7851999999997 |  |  |  | 315564 | 353772 | 311798 | 290896 | 245795 | 227157 | 252966 | 255530 | 278634 | 250879 | 254317 | 265757 | 321155
813001 | Hotdog Blend |  | 1178.1693 | 1968.1893 | 1771.5159 | 2296.6713 | 1657.7946 | 2133.6777 | 2644.2801 | 2010.393 | 1923.075 | 1707.0669 | 186.0705 | 304.5734999999999 | 1255.5081 |  |  |  | 600010 | 749203 | 726399 | 810934 | 630080 | 674733 | 884811 | 809390 | 786181 | 706846 | 642524 | 725933 | 801514
821001 | Sausage Stuff |  | 4920.577199999999 | 3827.439 | 3247.190099999999 | 2270.4759 | 2190.0186 | 1537.4205 | 1908.1062 | 4903.1136 | 8695.8333 | 6960.907800000001 | 4103.322299999999 | 6421.8231 | 8044.898400000001 |  |  |  | 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 |  | -2954.0511 | -2810.3922 | -2687.5233 | -2160.4968 | -2335.7565 | -2018.5011 | -2374.8417 | -2206.0269 | -2284.821 | -2336.1723 | -2095.2162 | -1625.3622 | -1515.3831 |  |  |  | 42988 | 42667 | 38417 | 38993 | 28199 | 33621 | 42830 | 17993 | 32213 | 36565 | 47182 | 253372 | 270813
840001 | Processed Cooler |  | -230.769 | -185.031 | -147.609 | -124.74 | -103.95 | -191.268 | -170.478 | -216.216 | -224.532 | -193.347 | -203.742 | -216.216 | -220.374 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9726 | 19118
851001 | Processed Sausage Pack |  | 1524.114899999999 | 4619.330100000001 | 5648.019300000001 | 4785.6501 | 4418.706599999999 | 3517.667999999999 | 4901.4504 | 2440.5381 | 3583.156500000001 | 3148.437599999999 | 3279.414600000001 | 3399.9966 | 1088.772299999999 |  |  |  | 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 |  | -1872.139500000001 | 2148.854400000001 | 2219.332500000001 | 1247.400000000001 | 2891.0574 | 2431.390499999999 | 5920.160400000002 | 665.2800000000022 | 965.0717999999979 | -552.1823999999999 | -1285.653599999999 | -1226.609999999999 | 5098.331700000002 |  |  |  | 529274 | 663028 | 645660 | 723590 | 563084 | 597842 | 792826 | 713077 | 690057.5 | 624268 | 561290 | 639418 | 712600
723001 | Fresh Sausage - Skin-On Links |  | 645.1136999999999 | 3567.3561 | 4091.6799 | 3016.8369 | 1880.6634 | 649.4795999999999 | 2579.4153 | 4270.266 | 4650.723 | 1348.6473 | 1830.1437 | 3697.501499999999 | 3351.5559 |  |  |  | 37796 | 88974 | 92280 | 77278 | 62080 | 62020 | 57960 | 82280 | 83992 | 68262 | 34920 | 69630 | 85328
724001 | Fresh Saus - Sknls Links, Chubs, Patties |  | 370.2698999999999 | 370.2698999999996 | 190.2284999999999 | 1031.3919 | 741.7871999999995 | -1784.613600000001 | -1791.4743 | -2878.5834 | -2360.0808 | 927.0261 | -634.9265999999997 | -2141.7858 | -1116.2151 |  |  |  | 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
Total Sausage Finished Goods |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1010527 | 1170895 | 1195635 | 1233096 | 978083 | 1012831 | 1357382 | 1173364 | 1218902 | 1218902 | 978167 | 1129857 | 1163950
 | Total Processed Meats Yields
Total Finished Goods