{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Prices","Feed","Farrow-Finish","Farrow-Wean","Wean-Finish","Nursery","Finishing","Feed (2)_IDOtherIngValues"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":13,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,1,50,10],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[28,1,29,11],[30,1,30,4],[31,1,32,11],[37,1,38,11],[43,1,43,3],[47,1,49,11]]}
[]
[]
[null,"KSU-Swine Farm Management Guide Budgets"]
[]
[null,"Excel spreadsheets for swine enterprise budgeting to evaluate potential income, costs and profitability"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 12.7.2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"The Kansas State University cost-return budgets were developed to serve as a barometer of profitability for various livestock industry enterprises.  These budgets are NOT intended to represent any one operation.  Each individual operation should adjust key inputs to reflect their own situation."]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly.  Blue values are inputs that should be changed from the defaults to match your operation.  Black values are automatically calculated."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Developed by:"]
[]
[null,"Glynn T. Tonsor, Ph.D.",null,null,null,null,null,"Robin Reid"]
[null,"Agricultural Economist",null,null,null,null,null,"Extension Associate"]
[null,"Department of Agricultural Economics",null,null,null,null,null,"Department of Agricultural Economics"]
[null,"Kansas State University",null,null,null,null,null,"Kansas State University"]
[null,"gtonsor@k-state.edu",null,null,null,null,null,"robinreid@ksu.edu"]
[null,"785-532-1518",null,null,null,null,null,"785-532-0964"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"The developers would like to thank the K-State Swine Team for their contributions: Dr. Joel DeRouchey, Dr. Mike Tokach, and Dr. Steve Dritz  www.asi.k-state.edu/species/swine/\n"]
[]
[]
[null,"Copyright 2020 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Prices","index":1,"n_rows":208,"n_cols":9,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
["Current Prices",null,null,null,null,null,null,0]
["One Year Out Prices",null,null,null,null,null,null,0]
["Five Years Out Prices",null,null,null,null,null,null,0]
[null,"Current Prices",0,"One Year Out Prices",0,0,"Five Years Out Prices",0]
[null,"(as of Dec. 7th, 2020)",0,"(as of Dec. 7th, 2020)",0,0,"(Oct. 2020 USDA)",0]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Market Hogs ($/cwt)",44.75,0,46.082000000000001,0,0,58.48,0]
["Weaned Pig ($/hd)",43.23,0,53.152019889999991,0,0,57.988702099999998,0]
["Feeder Pig ($/hd)",54.43,0,66.539911536000005,0,0,84.194752539999996,0]
["Cull Sows ($/cwt)",46.3,0,47.678136312849155,0,0,60.505564245810049,0]
["Replacement Gilts ($/hd)",198.0625,0,203.95790223463686,0,0,258.83117318435757,0]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,0]
["Swine Feed processing ($/ton) charge",17,0,17,0,0,17,0]
["Corn ($/bu)",4.25,0,4.18,0,0,3.55,0]
["Soybean Meal ($/ton)",380,0,334.59999999999997,0,0,341,0]
["DDGS ($/ton)",210,0,206.5411764705882,0,0,175.41176470588235,0]
["Other Feed Ingredients ($/lb, Farrow-Finish)",0.10818308031650385,0,0.10926491111966889,0,0,0.11034674192283393,0]
["Other Feed Ingredients ($/lb, Farrow-Wean)",0.20277752822665265,0,0.20480530350891918,0,0,0.2068330787911857,0]
["Other Feed Ingredients ($/lb, Wean-Finish)",0.29337424167505716,0,0.29630798409180775,0,0,0.29924172650855829,0]
["Other Feed Ingredients ($/lb, Nursery)",0.38740272553688754,0,0.39127675279225643,0,0,0.39515078004762527,0]
["Other Feed Ingredients ($/lb, Finish)",0.24720881108861548,0,0.24968089919950162,0,0,0.25215298731038777,0]
[]
[null,0,0,0,0,0,0,0,0]
["Corn, Yellow Dent",7.5892857142857137E-2,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",7.6651785714285714E-2,0,0,7.7410714285714277E-2,"http://www.usda.gov/oce/commodity/projections/","$/lb"]
["Corn, Nutridense",4.8000000000000001E-2,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",4.8480000000000002E-2,0,0,4.8960000000000004E-2,0,"$/lb"]
["Corn Bran",0,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",0,0,0,0,0,"$/lb"]
["Corn DDG",0,0,0,0,0,0,0,"$/lb"]
["Corn DDGS, >10% Oil",0.125,0,0.12625,0,0,0.1275,0,"$/lb"]
["Corn DDGS, >6 and <9% Oil",7.8E-2,0,7.8780000000000003E-2,0,0,7.9560000000000006E-2,0,"$/lb"]
["Corn DDGS, <4% Oil",0,0,0,0,0,0,0,"$/lb"]
["Corn HP DDG",0.06,0,6.0600000000000001E-2,0,0,6.1199999999999997E-2,0,"$/lb"]
["Soybean Meal, Dehull, Sol Extr2",0,0,0,0,0,0,0,"$/lb"]
["Soybean Meal, Dehulled, Expelled2",0,0,0,0,0,0,0,"$/lb"]
["Soybean Meal, Solvent Extracted2",0,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",0,0,0,0,0,"$/lb"]
["Corn Gluten Meal",0,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",0,0,0,0,0,"$/lb"]
["Corn Grits, Hominy Feed",4.4999999999999998E-2,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",4.5449999999999997E-2,0,0,4.5899999999999996E-2,0,"$/lb"]
["Cotton Seeds, Fullfat",0,0,0,0,0,0,0,"$/lb"]
["Cotton Seed Meal",0,0,0,0,0,0,0,"$/lb"]
["Feather Meal",0,0,0,0,0,0,0,"$/lb"]
["Fish Meal Combined",0.7,0,0.70699999999999996,0,0,0.71399999999999997,0,"$/lb"]
["Flaxseed",0,0,0,0,0,0,0,"$/lb"]
["Flaxseed Meal",0,0,0,0,0,0,0,"$/lb"]
["Lupins",0,0,0,0,0,0,0,"$/lb"]
["Meat Meal",0,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",0,0,0,0,0,"$/lb"]
["Meat and Bone Meal, P >4%",0.15,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",0.1515,0,0,0.153,0,"$/lb"]
["Milk, Casein",0,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",0,0,0,0,0,"$/lb"]
["Milk, Lactose",0.3,0,0.30299999999999999,0,0,0.30599999999999999,0,"$/lb"]
["Milk, Skim Milk Powder",1.2,0,1.212,0,0,1.224,0,"$/lb"]
["Milk, Whey Powder",0.55000000000000004,0,0.5555000000000001,0,0,0.56100000000000005,0,"$/lb"]
["Milk, Whey Permeate, 85% lactose",0.45,0,0.45450000000000002,0,0,0.45900000000000002,0,"$/lb"]
["Milk, Whey Protein Concentrate",0,0,0,0,0,0,0,"$/lb"]
["Millet",0,0,0,0,0,0,0,"$/lb"]
["Molasses, Sugarbeet",0,0,0,0,0,0,0,"$/lb"]
["Molasses, Sugarcane",0,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",0,0,0,0,0,"$/lb"]
["Oats",0,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",0,0,0,0,0,"$/lb"]
["Oats, Naked",0,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",0,0,0,0,0,"$/lb"]
["Oat Groats",0.17499999999999999,0,0.17674999999999999,0,0,0.17849999999999999,0,"$/lb"]
["Peanut Meal, Expelled",0,0,0,0,0,0,0,"$/lb"]
["Peanut Meal, Extracted",0,0,0,0,0,0,0,"$/lb"]
["Peas, Field Peas",0.08,0,8.0799999999999997E-2,0,0,8.1600000000000006E-2,0,"$/lb"]
["Pea Protein Concentrate",0,0,0,0,0,0,0,"$/lb"]
["Potato Protein Concentrate",0,0,0,0,0,0,0,"$/lb"]
["Poultry Byproduct",0.12,0,0.1212,0,0,0.12239999999999999,0,"$/lb"]
["Rice",0,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",0,0,0,0,0,"$/lb"]
["Rice Bran",0,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",0,0,0,0,0,"$/lb"]
["Rice Bran, Defatted",0,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",0,0,0,0,0,"$/lb"]
["Rice, Broken",0,0,0,0,0,0,0,"$/lb"]
["Rye",0,0,0,0,0,0,0,"$/lb"]
["Sesame Meal",0,0,0,0,0,0,0,"$/lb"]
["Sorghum",0.1,0,0.10100000000000001,0,0,0.10200000000000001,0,"$/lb"]
["Soybeans, Full Fat",0.2,0,0.20200000000000001,0,0,0.20400000000000001,0,"$/lb"]
["Soybeans, High Protein, Full Fat",0,0,0,0,0,0,0,"$/lb"]
["Soybeans, Low Oligosaccharide, Full Fat",0,0,0,0,0,0,0,"$/lb"]
["Soybean Meal, High Protein, Expelled",0,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",0,0,0,0,0,"$/lb"]
["Soybean Meal, Low Oligosacch, Expell",0,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",0,0,0,0,0,"$/lb"]
["Soybean Meal, Expelled",0,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",0,0,0,0,0,"$/lb"]
["Soybean Meal, Dehulled, Expelled",0.17499999999999999,0,0.17674999999999999,0,0,0.17849999999999999,0,"$/lb"]
["Soybean Meal, Solvent Extracted",0.155,0,0.15654999999999999,0,0,0.15809999999999999,0,"$/lb"]
["Soybean Meal, Dehull, Sol Extr",0.19,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",0.19190000000000002,0,0,0.1938,"http://www.usda.gov/oce/commodity/projections/","$/lb"]
["Soybean Meal, High Prot, Dehull, Solv Extr",0.32,0,0.32319999999999999,0,0,0.32640000000000002,0,"$/lb"]
["Soybean Meal, Enzyme Treated",0.02,0,2.0199999999999999E-2,0,0,2.0400000000000001E-2,0,"$/lb"]
["Soybean Meal, Fermented",3.5000000000000003E-2,0,3.5350000000000006E-2,0,0,3.5700000000000003E-2,0,"$/lb"]
["Soybean Hulls",4.8000000000000001E-2,0,4.8480000000000002E-2,0,0,4.8960000000000004E-2,0,"$/lb"]
["Soy Protein Concentrate",0.55000000000000004,0,0.5555000000000001,0,0,0.56100000000000005,0,"$/lb"]
["Soy Protein Isolate",0.17499999999999999,0,0.17674999999999999,0,0,0.17849999999999999,0,"$/lb"]
["Sugar Beet Pulp",0.2,0,0.20200000000000001,0,0,0.20400000000000001,0,"$/lb"]
["Sunflower, Full Fat",0,0,0,0,0,0,0,"$/lb"]
["Sunflower Meal, Solvent Extracted",0,0,0,0,0,0,0,"$/lb"]
["Sunflower Meal, Dehulled, Solvent Extr",0,0,0,0,0,0,0,"$/lb"]
["Triticale",0,0,0,0,0,0,0,"$/lb"]
["Wheat, Hard Red",0.06,0,6.0600000000000001E-2,0,0,6.1199999999999997E-2,0,"$/lb"]
["Wheat, Soft Red",0.45,0,0.45450000000000002,0,0,0.45900000000000002,0,"$/lb"]
["Wheat Bran",0.05,0,5.0500000000000003E-2,0,0,5.1000000000000004E-2,0,"$/lb"]
["Wheat Middlings",0.12,0,0.1212,0,0,0.12239999999999999,0,"$/lb"]
["Wheat Shorts",0,0,0,0,0,0,0,"$/lb"]
["Wheat DDGS",0,0,0,0,0,0,0,"$/lb"]
["Yeast, Brewers' Yeast",0,0,0,0,0,0,0,"$/lb"]
["Yeast, Single Cell Protein",0,0,0,0,0,0,0,"$/lb"]
["Beef Tallow",0.4,0,0.40400000000000003,0,0,0.40800000000000003,0,"$/lb"]
["Choice White Grease",0.42,0,0.42419999999999997,0,0,0.4284,0,"$/lb"]
["Poultry Fat",2.7,0,2.7270000000000003,0,0,2.7540000000000004,0,"$/lb"]
["Lard",1.25,0,1.2625,0,0,1.2749999999999999,0,"$/lb"]
["Restaurant Grease",0.38,0,0.38380000000000003,0,0,0.3876,0,"$/lb"]
["Canola oil",1.2,0,1.212,0,0,1.224,0,"$/lb"]
["Coconut oil",7,0,7.07,0,0,7.1400000000000006,0,"$/lb"]
["Corn oil",7,0,7.07,0,0,7.1400000000000006,0,"$/lb"]
["Palm Kernel oil",0,0,0,0,0,0,0,"$/lb"]
["Soybean oil",0.38,0,0.38380000000000003,0,0,0.3876,0,"$/lb"]
["Soybean Lecithin",0.7,0,0.70699999999999996,0,0,0.71399999999999997,0,"$/lb"]
["Sunflower oil",0.6,0,0.60599999999999998,0,0,0.61199999999999999,0,"$/lb"]
["Fat, A/V blend",2.2000000000000002,0,2.2220000000000004,0,0,2.2440000000000002,0,"$/lb"]
["Calcium carbonate",0,0,0,0,0,0,0,"$/lb"]
["Calcium phosphate (tricalcium)",0,0,0,0,0,0,0,"$/lb"]
["Calcium phosphate (dicalcium)",0.3,0,0.30299999999999999,0,0,0.30599999999999999,0,"$/lb"]
["Calcium phosphate (monocalcium)",0.32800000000000001,"KSU ration (Apr 2015)",0.33128000000000002,"Assumes 1% increase",0,0.33456000000000002,"Assumes 2% increase","$/lb"]
["Calcium sulfate, dihydrate",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Limestone, ground",1.7600000000000001E-2,"KSU ration (Apr 2015)",1.7776E-2,"Assumes 1% increase",0,1.7952000000000003E-2,"Assumes 2% increase","$/lb"]
["Magnesium phosphate",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Sodium carbonate",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Sodium bicarbonate",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Sodium chloride",5.8000000000000003E-2,"KSU ration (Apr 2015)",5.858E-2,"Assumes 1% increase",0,5.9160000000000004E-2,"Assumes 2% increase","$/lb"]
["Sodium phosphate, monobasic",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Sodium sulfate, decahydrate",1.6E-2,"KSU ration (Apr 2015)",1.6160000000000001E-2,"Assumes 1% increase",0,1.6320000000000001E-2,"Assumes 2% increase","$/lb"]
["L-Lys-HCL",0.75,"KSU ration (Apr 2015)",0.75750000000000006,"Assumes 1% increase",0,0.76500000000000001,"Assumes 2% increase","$/lb"]
["DL-Met",2.2999999999999998,"KSU ration (Apr 2015)",2.323,"Assumes 1% increase",0,2.3459999999999996,"Assumes 2% increase","$/lb"]
["L-Thr",1.2,"KSU ration (Apr 2015)",1.212,"Assumes 1% increase",0,1.224,"Assumes 2% increase","$/lb"]
["L-Trp",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["L-Val",7,"KSU ration (Apr 2015)",7.07,"Assumes 1% increase",0,7.1400000000000006,"Assumes 2% increase","$/lb"]
["L-Ileu",7,"KSU ration (Apr 2015)",7.07,"Assumes 1% increase",0,7.1400000000000006,"Assumes 2% increase","$/lb"]
["Methionine hydroxy analog",1.2,"KSU ration (Apr 2015)",1.212,"Assumes 1% increase",0,1.224,"Assumes 2% increase","$/lb"]
["Glutamine",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Glutamic acid",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Biolys",0.7,"KSU ration (Apr 2015)",0.70699999999999996,"Assumes 1% increase",0,0.71399999999999997,"Assumes 2% increase","$/lb"]
["Liquid lysine 60%",0.6,"KSU ration (Apr 2015)",0.60599999999999998,"Assumes 1% increase",0,0.61199999999999999,"Assumes 2% increase","$/lb"]
["MHA dry",2.2000000000000002,"KSU ration (Apr 2015)",2.2220000000000004,"Assumes 1% increase",0,2.2440000000000002,"Assumes 2% increase","$/lb"]
["Ractopamine 9 g/lb",37,"KSU ration (Apr 2015)",37.369999999999997,"Assumes 1% increase",0,37.74,"Assumes 2% increase","$/lb"]
["Phase 2 supplement (PEP2)",0.45,"KSU ration (Apr 2015)",0.45450000000000002,"Assumes 1% increase",0,0.45900000000000002,"Assumes 2% increase","$/lb"]
["2007 Starter base mix",0.36,"KSU ration (Apr 2015)",0.36359999999999998,"Assumes 1% increase",0,0.36719999999999997,"Assumes 2% increase","$/lb"]
["2007 Grow-finish base mix",0.22,"KSU ration (Apr 2015)",0.22220000000000001,"Assumes 1% increase",0,0.22440000000000002,"Assumes 2% increase","$/lb"]
["Developer base mix",0.2,"KSU ration (Apr 2015)",0.20200000000000001,"Assumes 1% increase",0,0.20400000000000001,"Assumes 2% increase","$/lb"]
["2007 Sow base mix",0.22,"KSU ration (Apr 2015)",0.22220000000000001,"Assumes 1% increase",0,0.22440000000000002,"Assumes 2% increase","$/lb"]
["Vitamin premix with phytase",0.67700000000000005,"KSU ration (Apr 2015)",0.6837700000000001,"Assumes 1% increase",0,0.69054000000000004,"Assumes 2% increase","$/lb"]
["Trace mineral premix",0.41,"KSU ration (Apr 2015)",0.41409999999999997,"Assumes 1% increase",0,0.41819999999999996,"Assumes 2% increase","$/lb"]
["Sow add pack",1.7,"KSU ration (Apr 2015)",1.7169999999999999,"Assumes 1% increase",0,1.734,"Assumes 2% increase","$/lb"]
["Vitamin premix without phytase",0.9,"KSU ration (Apr 2015)",0.90900000000000003,"Assumes 1% increase",0,0.91800000000000004,"Assumes 2% increase","$/lb"]
["GF DDGS Base Mix",0.25,"KSU ration (Apr 2015)",0.2525,"Assumes 1% increase",0,0.255,"Assumes 2% increase","$/lb"]
["GF synthetics Base Mix",0.3,"KSU ration (Apr 2015)",0.30299999999999999,"Assumes 1% increase",0,0.30599999999999999,"Assumes 2% increase","$/lb"]
["Choline chloride 60%",0.6,"KSU ration (Apr 2015)",0.60599999999999998,"Assumes 1% increase",0,0.61199999999999999,"Assumes 2% increase","$/lb"]
["Natuphos 600",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Natuphos 1200",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Optiphos 2000",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Phyzyme 1200",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Phyzyme 5000",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Ronozyme CT (10,000)",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Ronozyme M (50,000)",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Ronozyme PMX PLT (4625 FYT/g)",0.83320000000000005,"KSU ration (Apr 2015)",0.84153200000000006,"Assumes 1% increase",0,0.84986400000000006,"Assumes 2% increase","$/lb"]
["Zinc oxide",1.1000000000000001,"KSU ration (Apr 2015)",1.1110000000000002,"Assumes 1% increase",0,1.1220000000000001,"Assumes 2% increase","$/lb"]
["Copper sulfate",1.1000000000000001,"KSU ration (Apr 2015)",1.1110000000000002,"Assumes 1% increase",0,1.1220000000000001,"Assumes 2% increase","$/lb"]
["Potassium chloride",0.17499999999999999,"KSU ration (Apr 2015)",0.17674999999999999,"Assumes 1% increase",0,0.17849999999999999,"Assumes 2% increase","$/lb"]
["Calcium chloride",0.2,"KSU ration (Apr 2015)",0.20200000000000001,"Assumes 1% increase",0,0.20400000000000001,"Assumes 2% increase","$/lb"]
["Acidifier",1,"KSU ration (Apr 2015)",1.01,"Assumes 1% increase",0,1.02,"Assumes 2% increase","$/lb"]
["Vitamin E, 20,000 IU",0.4,"KSU ration (Apr 2015)",0.40400000000000003,"Assumes 1% increase",0,0.40800000000000003,"Assumes 2% increase","$/lb"]
["Phase 2 supplement D",0.4,"KSU ration (Apr 2015)",0.40400000000000003,"Assumes 1% increase",0,0.40800000000000003,"Assumes 2% increase","$/lb"]
["DPS 50",0.5,"KSU ration (Apr 2015)",0.505,"Assumes 1% increase",0,0.51,"Assumes 2% increase","$/lb"]
["PEP2+",0.6,"KSU ration (Apr 2015)",0.60599999999999998,"Assumes 1% increase",0,0.61199999999999999,"Assumes 2% increase","$/lb"]
["PEP NS",0.5,"KSU ration (Apr 2015)",0.505,"Assumes 1% increase",0,0.51,"Assumes 2% increase","$/lb"]
["Natural vitamin E 20,000 IU/lb",9.4375,"KSU ration (Apr 2015)",9.5318749999999994,"Assumes 1% increase",0,9.6262500000000006,"Assumes 2% increase","$/lb"]
["Other ingredient",0,0,0,0,0,0,0,"$/lb"]
["Corn DDGS, 10.5% Oil",0.125,0,0.12625,0,0,0.1275,0,"$/lb"]
["Corn DDGS, 7.5% Oil",0.105,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",0.10604999999999999,0,0,0.1071,"Adjust off of Corn Price","$/lb"]
["Corn DDGS, 4.5% Oil",0.125,0,0.12625,0,0,0.1275,0,"$/lb"]
["Denegard",4.7286000000000001,"KSU ration (Apr 2015)",4.7758859999999999,"Assumes 1% increase",0,4.8231720000000005,"Assumes 2% increase","$/lb"]
["CTC 50",1.44,"KSU ration (Apr 2015)",1.4543999999999999,"Assumes 1% increase",0,1.4687999999999999,"Assumes 2% increase","$/lb"]
["Bentonite",0.15,"KSU ration (Apr 2015)",0.1515,"Assumes 1% increase",0,0.153,"Assumes 2% increase","$/lb"]
["Phase 2 supplement (Feb, 2014)",0.73619999999999997,"KSU ration (Apr 2015)",0.74356199999999995,"Assumes 1% increase",0,0.75092399999999992,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Other ingredient",0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
[0,0,"KSU ration (Apr 2015)",0,"Assumes 1% increase",0,0,"Assumes 2% increase","$/lb"]
["Complete nursery pellet",0.35,"KSU ration (Apr 2015)",0.35349999999999998,"Assumes 1% increase",0,0.35699999999999998,"Assumes 2% increase","$/ton"]
[0,0,0,0,0,0,0,0,0]
[0,0,0,1.01,0,0,1.02,0,0]

{"sheet":"Feed","index":2,"n_rows":192,"n_cols":18,"rows_kept":192,"cut":false,"hidden":false,"merged":[[2,6,2,10]]}
["SWINE RATIONS TO SET FEED COSTS"]
[]
["Ingredient",null,null,"Usage per pig, lb",null,null,"Total Useage (lbs per pig) by Production Phase/Type"]
[null,"Price ($/lb)",null,"Sows","Nursery","GF","Farrow-Finish","Farrow-Wean","Wean-Finish","Nursery","Finish",null,null,null,null,"Currently Used?"]
["Corn",null,null,96.90757083367356,31.024626131360272,506.02570353037078,{"$f":"SUM(D5:F5)","v":633.9579004954046},{"$f":"D5","v":96.90757083367356},{"$f":"E5+F5","v":537.0503296617311},{"$f":"E5","v":31.024626131360272},{"$f":"F5","v":506.02570353037078},null,null,null,null,0]
["Soybean Meal, Dehull, Sol Extr",null,null,22.377429166326444,16.291373868639731,120.29520580975098,{"$f":"SUM(D6:F6)","v":158.96400884471717},{"$f":"D6","v":22.377429166326444},{"$f":"E6+F6","v":136.58657967839071},{"$f":"E6","v":16.291373868639731},{"$f":"F6","v":120.29520580975098},null,null,null,null,0]
["Corn",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Milo",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Alfalfa Meal",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Bakery Meal",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Barley",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Barley, Hulless",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Beans, Faba",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Blood Meal",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Blood Plasma",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Brewers Grain",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Canola, Full Fat",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Canola Meal, Expelled",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Canola Meal, Solvent Extracted",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Casava Meal",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Citrus Pulp",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Copra Meal",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0]
["Corn, Yellow Dent",{"$f":"IF(R23=\"\",$B$191,IF(R23=0,$B$191,R23))","v":7.5892857142857137E-2},null,97.563856046378703,29.327382607751133,483.50111636811255,{"$f":"SUM(D23:F23)","v":610.39235502224233},{"$f":"D23","v":97.563856046378703},{"$f":"E23+F23","v":512.82849897586368},{"$f":"E23","v":29.327382607751133},{"$f":"F23","v":483.50111636811255},null,null,null,null,{"$f":"IF(SUM(D23:F222)=0,0,1)","v":1},null,7.5892857142857137E-2]
["Corn, Nutridense",{"$f":"IF(R24=\"\",$B$191,IF(R24=0,$B$191,R24))","v":4.8000000000000001E-2},null,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(SUM(D24:F223)=0,0,1)","v":1},null,4.8000000000000001E-2]
["Corn Bran",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Corn DDG",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Corn DDGS, >10% Oil",0.125,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.125]
["Corn DDGS, >6 and <9% Oil",7.8E-2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,7.8E-2]
["Corn DDGS, <4% Oil",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Corn HP DDG",0.06,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.06]
["Soybean Meal, Dehull, Sol Extr",0.19,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.19]
["Soybean Meal, Dehulled, Expelled",0.17499999999999999,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.17499999999999999]
["Soybean Meal, Solvent Extracted",0.155,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.155]
["Corn Gluten Meal",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Corn Grits, Hominy Feed",4.4999999999999998E-2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,4.4999999999999998E-2]
["Cotton Seeds, Fullfat",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Cotton Seed Meal",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Feather Meal",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Fish Meal Combined",0.7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.7]
["Flaxseed",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Flaxseed Meal",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Lupins",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Meat Meal",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Meat and Bone Meal, P >4%",0.15,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.15]
["Milk, Casein",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Milk, Lactose",0.3,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.3]
["Milk, Skim Milk Powder",1.2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.2]
["Milk, Whey Powder",0.55000000000000004,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.55000000000000004]
["Milk, Whey Permeate, 85% lactose",0.45,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.45]
["Milk, Whey Protein Concentrate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Millet",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Molasses, Sugarbeet",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Molasses, Sugarcane",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Oats",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Oats, Naked",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Oat Groats",0.17499999999999999,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.17499999999999999]
["Peanut Meal, Expelled",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Peanut Meal, Extracted",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Peas, Field Peas",0.08,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.08]
["Pea Protein Concentrate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Potato Protein Concentrate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Poultry Byproduct",0.12,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.12]
["Rice",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Rice Bran",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Rice Bran, Defatted",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Rice, Broken",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Rye",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sesame Meal",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sorghum",0.1,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.1]
["Soybeans, Full Fat",0.2,null,0,0,0,{"$f":"SUM(D70:F70)","v":0},{"$f":"D70","v":0},{"$f":"E70+F70","v":0},{"$f":"E70","v":0},{"$f":"F70","v":0},null,null,null,null,1,null,0.2]
["Soybeans, High Protein, Full Fat",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Soybeans, Low Oligosaccharide, Full Fat",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Soybean Meal, High Protein, Expelled",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Soybean Meal, Low Oligosacch, Expell",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Soybean Meal, Expelled",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Soybean Meal, Dehulled, Expelled",0.17499999999999999,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.17499999999999999]
["Soybean Meal, Solvent Extracted",0.155,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.155]
["Soybean Meal, Dehull, Sol Extr",0.19,null,22.7023939536213,16.966353392248866,100.02572879356299,139.69447613943316,22.7023939536213,116.99208218581185,16.966353392248866,100.02572879356299,null,null,null,null,1,null,0.19]
["Soybean Meal, High Prot, Dehull, Solv Extr",0.32,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.32]
["Soybean Meal, Enzyme Treated",0.02,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.02]
["Soybean Meal, Fermented",3.5000000000000003E-2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,3.5000000000000003E-2]
["Soybean Hulls",4.8000000000000001E-2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,4.8000000000000001E-2]
["Soy Protein Concentrate",0.55000000000000004,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.55000000000000004]
["Soy Protein Isolate",0.17499999999999999,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.17499999999999999]
["Sugar Beet Pulp",0.2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.2]
["Sunflower, Full Fat",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sunflower Meal, Solvent Extracted",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sunflower Meal, Dehulled, Solvent Extr",{"$f":"IF(R88=\"\",$B$191,IF(R88=0,$B$191,R88))","v":2},null,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(SUM(D88:F287)=0,0,1)","v":1},null,0]
["Triticale",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Wheat, Hard Red",0.06,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.06]
["Wheat, Soft Red",0.45,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.45]
["Wheat Bran",0.05,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.05]
["Wheat Middlings",0.12,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.12]
["Wheat Shorts",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Wheat DDGS",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Yeast, Brewers' Yeast",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Yeast, Single Cell Protein",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Beef Tallow",0.4,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.4]
["Choice White Grease",0.42,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.42]
["Poultry Fat",2.7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,2.7]
["Lard",1.25,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.25]
["Restaurant Grease",0.38,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.38]
["Canola oil",1.2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.2]
["Coconut oil",7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,7]
["Corn oil",7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,7]
["Palm Kernel oil",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Soybean oil",0.38,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.38]
["Soybean Lecithin",0.7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.7]
["Sunflower oil",0.6,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.6]
["Fat, A/V blend",2.2000000000000002,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,2.2000000000000002]
["Calcium carbonate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Calcium phosphate (tricalcium)",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Calcium phosphate (dicalcium)",0.3,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.3]
["Calcium phosphate (monocalcium)",0.32800000000000001,null,1.625,0.34816000000000003,2.5203731056101093,4.4935331056101093,1.625,2.8685331056101093,0.34816000000000003,2.5203731056101093,null,null,null,null,1,null,0.32800000000000001]
["Calcium sulfate, dihydrate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Limestone, ground",1.7600000000000001E-2,null,1.6025,0.50048000000000004,5.3853120000000008,7.4882920000000013,1.6025,5.8857920000000004,0.50048000000000004,5.3853120000000008,null,null,null,null,1,null,1.7600000000000001E-2]
["Magnesium phosphate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sodium carbonate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sodium bicarbonate",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sodium chloride",5.8000000000000003E-2,null,0.57999999999999996,0.21760000000000002,2.9918400000000003,3.7894400000000004,0.57999999999999996,3.2094400000000003,0.21760000000000002,2.9918400000000003,null,null,null,null,1,null,5.8000000000000003E-2]
["Sodium phosphate, monobasic",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Sodium sulfate, decahydrate",1.6E-2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.6E-2]
["L-Lys-HCL",0.75,null,8.8749999999999996E-2,0.18008000000000002,1.7951040000000003,2.0639340000000002,8.8749999999999996E-2,1.9751840000000003,0.18008000000000002,1.7951040000000003,null,null,null,null,1,null,0.75]
["DL-Met",2.2999999999999998,null,1.2500000000000001E-2,3.6992000000000004E-2,0.13691163353407723,0.18640363353407724,1.2500000000000001E-2,0.17390363353407723,3.6992000000000004E-2,0.13691163353407723,null,null,null,null,1,null,2.2999999999999998]
["L-Thr",1.2,null,1.2500000000000001E-2,4.7872000000000005E-2,0.47726918585757255,0.53764118585757259,1.2500000000000001E-2,0.52514118585757252,4.7872000000000005E-2,0.47726918585757255,null,null,null,null,1,null,1.2]
["L-Trp",2,null,0,0,6.8292703566466009E-2,6.8292703566466009E-2,0,6.8292703566466009E-2,0,6.8292703566466009E-2,null,null,null,null,1,null,0]
["L-Val",7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,7]
["L-Ileu",7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,7]
["Methionine hydroxy analog",1.2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.2]
["Glutamine",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Glutamic acid",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Biolys",0.7,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.7]
["Liquid lysine 60%",0.6,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.6]
["MHA dry",2.2000000000000002,null,0,0,0,{"$f":"SUM(D134:F134)","v":0},{"$f":"D134","v":0},{"$f":"E134+F134","v":0},{"$f":"E134","v":0},{"$f":"F134","v":0},null,null,null,null,1,null,2.2000000000000002]
["Ractopamine 9 g/lb",37,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,37]
["Phase 2 supplement (PEP2)",0.45,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.45]
["2007 Starter base mix",0.36,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.36]
["2007 Grow-finish base mix",0.22,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.22]
["Developer base mix",0.2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.2]
["2007 Sow base mix",0.22,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.22]
["Vitamin premix with phytase",0.67700000000000005,null,0.3125,0.10880000000000001,0.7040980706373845,1.1253980706373845,0.3125,0.81289807063738451,0.10880000000000001,0.7040980706373845,null,null,null,null,1,null,0.67700000000000005]
["Trace mineral premix",0.41,null,0.1875,6.5280000000000005E-2,0.7040980706373845,0.9568780706373845,0.1875,0.7693780706373845,6.5280000000000005E-2,0.7040980706373845,null,null,null,null,1,null,0.41]
["Sow add pack",1.7,null,0.3125,0,0,0.3125,0.3125,0,0,0,null,null,null,null,1,null,1.7]
["Vitamin premix without phytase",0.9,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.9]
["GF DDGS Base Mix",0.25,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.25]
["GF synthetics Base Mix",0.3,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.3]
["Choline chloride 60%",0.6,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.6]
["Natuphos 600",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Natuphos 1200",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Optiphos 2000",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Phyzyme 1200",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Phyzyme 5000",{"$f":"IF(R152=\"\",$B$191,IF(R152=0,$B$191,R152))","v":2},null,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(SUM(D152:F351)=0,0,1)","v":1},null,0]
["Ronozyme CT (10,000)",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Ronozyme M (50,000)",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Ronozyme PMX PLT (4625 FYT/g)",0.83320000000000005,null,0,0,5.7856068481511556E-2,5.7856068481511556E-2,0,5.7856068481511556E-2,0,5.7856068481511556E-2,null,null,null,null,1,null,0.83320000000000005]
["Zinc oxide",1.1000000000000001,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.1000000000000001]
["Copper sulfate",1.1000000000000001,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1.1000000000000001]
["Potassium chloride",0.17499999999999999,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.17499999999999999]
["Calcium chloride",0.2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.2]
["Acidifier",1,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,1]
["Vitamin E, 20,000 IU",0.4,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.4]
["Phase 2 supplement D",0.4,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.4]
["DPS 50",0.5,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.5]
["PEP2+",0.6,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.6]
["PEP NS",0.5,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.5]
["Natural vitamin E 20,000 IU/lb",9.4375,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,9.4375]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Corn DDGS, 10.5% Oil",0.125,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.125]
["Corn DDGS, 7.5% Oil",0.105,null,0,5.5519999999999996,0,5.5519999999999996,0,5.5519999999999996,5.5519999999999996,{"$f":"F169","v":0},null,null,null,null,1,null,0.105]
["Corn DDGS, 4.5% Oil",0.125,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.125]
["Denegard",4.7286000000000001,null,0,2.1000000000000001E-2,0,2.1000000000000001E-2,0,2.1000000000000001E-2,2.1000000000000001E-2,0,null,null,null,null,1,null,4.7286000000000001]
["CTC 50",1.44,null,0,4.8000000000000001E-2,0,4.8000000000000001E-2,0,4.8000000000000001E-2,4.8000000000000001E-2,0,null,null,null,null,1,null,1.44]
["Bentonite",0.15,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0.15]
["Phase 2 supplement (Feb, 2014)",0.73619999999999997,null,0,2.1,0,2.1,0,2.1,2.1,0,null,null,null,null,1,null,0.73619999999999997]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,0,0,0,0,0,null,null,null,null,1,null,0]
["Other ingredient",2,null,0,0,0,{"$f":"SUM(D186:F186)","v":0},0,0,0,0,null,null,null,null,1,null,0]
[null,2,null,null,null,null,{"$f":"SUM(D187:F187)","v":0},{"$f":"D187","v":0},{"$f":"E187+F187","v":0},{"$f":"E187","v":0},{"$f":"F187","v":0},null,null,null,null,1,null,0]
["Complete nursery pellet",{"$f":"IF(R188=\"\",$B$191,IF(R188=0,$B$191,R188))","v":0.35},null,0,3,0,{"$f":"SUM(D188:F188)","v":3},{"$f":"D188","v":0},{"$f":"E188+F188","v":3},{"$f":"E188","v":3},{"$f":"F188","v":0},null,null,null,null,1,null,0.35]
[null,null,null,{"$f":"SUM(D23:D188)","v":125.00000000000001},{"$f":"SUM(E23:E188)","v":58.519999999999996},{"$f":"SUM(F23:F188)","v":598.36800000000028},{"$f":"SUM(G23:G188)","v":781.88800000000003},{"$f":"SUM(H23:H188)","v":125.00000000000001},656.88800000000026,58.519999999999996,598.36800000000028]
[null,null,"Total:",{"$f":"SUM(D23:D188)","v":125.00000000000001},{"$f":"SUM(E23:E188)","v":58.519999999999996},598.36800000000028]
[null,2,"Total \"Minor\" Ingredients:",{"$f":"D190-(D23+D78+D169)","v":4.7337500000000148},{"$f":"E190-(E23+E78+E169)","v":6.6742640000000009},14.841154838324769]
[null,null,"% Diet Minor Ingredients:",{"$f":"D191/D190","v":3.7870000000000112E-2},{"$f":"E191/E190","v":0.11405099111414903},2.4802721466262837E-2]

{"sheet":"Farrow-Finish","index":3,"n_rows":278,"n_cols":13,"rows_kept":278,"cut":false,"hidden":false,"merged":[[277,9,277,10],[18,11,20,11],[46,0,46,5],[0,0,0,1],[0,2,0,5],[0,6,0,9],[46,6,46,9],[5,3,5,8],[7,3,7,8],[8,3,8,8],[44,9,44,10],[276,0,276,9],[43,0,43,9],[90,0,90,1],[90,2,90,5],[90,6,90,9],[261,2,261,3],[261,4,261,5],[93,0,93,2],[87,0,87,9],[88,9,88,10]]}
[" KSU Farrow-to-Finish Swine Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,null,"INTERNAL NOTES","Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information",null,null,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Weaned Pigs/Mated Sow/Year",23.9,null,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Litters/Mated Sow/Year",2.2999999999999998,null,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Wean-Finish Mortality (%)",7.99,null,"Nursery Feed to Gain",null,null,null,null,null,1.54,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Market Hogs Sold/Mated Sow/Year",{"$f":"B4*((100-B6)/100)","v":21.990389999999998},null,"Grow/Finish Feed to Gain",null,null,null,null,null,2.54,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Sow Replacement Rate",0.5,null,"Weaned Pig Weight",null,null,null,null,null,14,null,"Per April KSU team meeting"]
["Sow Mortality (%)",0.08,null,"Nursery Exit Weight",null,null,null,null,null,52,null,"Per April KSU team meeting"]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Sow","Total per Year per Pig Sold"]
["Market Hogs",{"$f":"IF($C$1=Prices!$A$1, Prices!B14, IF($C$1=Prices!$A$2, Prices!D14, IF($C$1=Prices!$A$3, Prices!G14, \"\")))","v":44.75},"per cwt"," x",277,"lbs"," x",{"$f":"B7","v":21.990389999999998}," =",{"$f":"(B12/100)*E12*H12","v":2725.8737684249995},{"$f":"J12/B7","v":123.9575},"272 lbs is from NPB/Stadler 2014 report table 2"]
["Cull Sows",{"$f":"IF($C$1=Prices!$A$1, Prices!B17, IF($C$1=Prices!$A$2, Prices!D17, IF($C$1=Prices!$A$3, Prices!G17, \"\")))","v":46.3},"per cwt"," x",400,"lbs"," x",{"$f":"B8-B9","v":0.42}," =",{"$f":"B13*(E13/100)*H13","v":77.783999999999992},{"$f":"J13/B7","v":3.5371814688143322},"Per April KSU team meeting"]
["Manure Credit",null,null,null,null,null,null,null,null,{"$f":"K14*$B$7","v":131.94234},6,"Per April KSU team meeting; also note ERS COP places $4.25/cwt gain here so our $5/hd is conservative"]
["Other revenue",null,null,null,null,null,null,null,null,{"$f":"K15*$B$7","v":0},0]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J15)","v":2935.6001084249997},{"$f":"SUM(K12:K15)","v":133.49468146881435}]
[]
["Variable Costs"]
["Sow Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$H$23:$H$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$H$23:$H$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$H$23:$H$188,Prices!$G$41:$G$206), \"\")))/Feed!H189","v":0.10594158912337714},"per lb"," x",{"$f":"Feed!H189","v":125.00000000000001},"lbs",null,null," =",{"$f":"K19*B5","v":30.45820687297093},{"$f":"(B19*E19)","v":13.242698640422145},"Worked from April 2015 KSU XL Ration, collapsing down to #s by phase here w/ details in Feed tab and notes below; Also scaling feed lbs given changes to # pigs and finished weight; Can cross-check w/ ERS COP data also"]
["Nursery Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$J$23:$J$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$J$23:$J$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$J$23:$J$188,Prices!$G$41:$G$206), \"\")))/Feed!J189","v":0.15909744926779315},"per lb"," x",{"$f":"IF(J6=1.54,(((J9-52)*0.011+J6)*(J9-J8)),(J6*(J9-J8)))","v":58.52},"lbs",null,null," =",{"$f":"K20*B4","v":222.518147274515},{"$f":"(B20*E20)","v":9.3103827311512557}]
["Grow-Finish Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$K$23:$K$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$K$23:$K$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$K$23:$K$188,Prices!$G$41:$G$206), \"\")))/Feed!K189","v":0.10000813591761802},"per lb"," x",{"$f":"IF(J7=2.54,(((E12-277)*0.005+J7)*(E12-J9)),(J7*(E12-J9)))","v":571.5},"lbs",null,null," =",{"$f":"K21*B7","v":1256.853036708816},{"$f":"(B21*E21)","v":57.154649676918702}]
["Feed Processing",{"$f":"IF($C$1=Prices!$A$1, Prices!B30, IF($C$1=Prices!$A$2, Prices!D30, IF($C$1=Prices!$A$3,Prices!G30, \"\")))","v":17},"per ton"," x",{"$f":"SUM(E19:E21)/2000","v":0.37751000000000001},"ton",null,null," =",{"$f":"K22*$B$7","v":141.1270661913},{"$f":"B22*E22","v":6.4176700000000002}]
["Labor",15,"per hour","x",6,"hours",null,null," =",{"$f":"B23*E23*B5","v":206.99999999999997},{"$f":"J23/B7","v":9.4132027672087659},"Note: Using Schulz's 3/31/15 Iowa St. values (http://www.extension.iastate.edu/agdm/livestock/pdf/b1-21.pdf)"]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"K24*B7","v":187.00407752099997},{"$f":"3.07*E12/100","v":8.5038999999999998},"Note: Using ERS $1.94/cwt produced value"]
["Replacement Females",{"$f":"(IF(C1=Prices!A1, Prices!B18, IF(C1=Prices!A2, Prices!D18, IF(C1=Prices!A3,Prices!G18, \"\"))))","v":198.0625},"per head"," x",{"$f":"B8","v":0.5},"hd",null,null," =",{"$f":"B25*E25","v":99.03125},{"$f":"J25/B7","v":4.5033876161359583}]
["Semen Cost & Genetic Fee",null,null,null,null,null,null,null,null,{"$f":"13*B5","v":29.9},{"$f":"J26/B7","v":1.3596848441523774},"Note: Schulz's 3/31/15 Iowa St. values are $13/litter"]
["Marketing, Bedding, and Misc",null,null,null,null,null,null,null,null,{"$f":"K27*B7","v":62.131647905999998},{"$f":"(0.04+0.22+0.76)*E12/100","v":2.8254000000000001},"Note: Using ERS $0.92/cwt produced value (Bed&Litter, Mkt,Custom Srv). Compares w/ Schulz's 3/31/15 $30/litter)"]
["Utilities, Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"K28*B7","v":116.95369017599999},{"$f":"1.92*E12/100","v":5.3184000000000005},"Note: Using ERS $2.22/cwt produced values (compares w/ Schulz's 3/31/15 $50/litter)"]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"K29*B7","v":87.106133828999987},{"$f":"1.43*E12/100","v":3.9610999999999996},"Note: Using ERS $0.88/cwt produced value (low compared to Schulz's 3/31/15 $130/litter)"]
["Other variable costs",null,null,null,null,null,null,null,null,0,{"$f":"J30/B7","v":0}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J30)","v":2440.0832564796019},{"$f":"SUM(K19:K30)","v":122.01047627598921}]
[]
["Fixed Costs"]
["Machinery, Facilities, General Overhead",null,null,null,null,null,null,null,null,{"$f":"K34*B7","v":907.00023266699986},{"$f":"(13.54+0.07+1.28)*E12/100","v":41.2453},"Note: Using ERS $9.38/cwt produced value for capital recovery  of mach. & equipment + $0.93 for general farm overhead"]
["Taxes and Insurance",null,null,null,null,null,null,null,null,{"$f":"K35*B7","v":38.375429588999992},{"$f":"0.63*E12/100","v":1.7450999999999999},"Note: Using ERS $0.49/cwt produced value"]
["Legal, Accounting, etc.",null,null,null,null,null,null,null,null,{"$f":"K36*B7","v":32.985585},1.5,"no source"]
["Other fixed costs",null,null,null,null,null,null,null,null,0,{"$f":"J37/B7","v":0}]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J34:J37)","v":978.36124725599984},{"$f":"SUM(K34:K37)","v":44.490400000000001},"Schulz's 3/31/15 value is $195.42/litter"]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J31+J38","v":3418.4445037356018},{"$f":"K31+K38","v":166.50087627598921},"ERS COP is $58.66/cwt produced"]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J16-J31","v":495.51685194539778},{"$f":"K16-K31","v":11.484205192825144},{"$f":"58.66*(E12/100)","v":162.48819999999998}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J16-J40","v":-482.84439531060207},{"$f":"K16-K40","v":-33.006194807174865}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-FarFin",null,null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 12.7.2020"}]
[]
[{"$f":"A1","v":" KSU Farrow-to-Finish Swine Budget"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A45","v":"Publication: AM-FMG-FarFin"},null,null,null,null,null,null,null,null,{"$f":"J45","v":"Version- 12.7.2020"}]
[]
[{"$f":"A47","v":" KSU Farrow-to-Finish Swine Budget"}]
["Budget Assumptions"]
[]
["Feed Ration"]
["Ingredient","Qty","Unit"]
[{"$f":"Feed!A23","v":"Corn, Yellow Dent"},{"$f":"Feed!G23","v":610.39235502224233},"lbs"]
[{"$f":"Feed!A24","v":"Corn, Nutridense"},{"$f":"Feed!G24","v":0},"lbs"]
[{"$f":"Feed!A25","v":"Corn Bran"},{"$f":"Feed!G25","v":0},"lbs"]
[{"$f":"Feed!A26","v":"Corn DDG"},{"$f":"Feed!G26","v":0},"lbs"]
[{"$f":"Feed!A27","v":"Corn DDGS, >10% Oil"},{"$f":"Feed!G27","v":0},"lbs"]
[{"$f":"Feed!A28","v":"Corn DDGS, >6 and <9% Oil"},{"$f":"Feed!G28","v":0},"lbs"]
[{"$f":"Feed!A29","v":"Corn DDGS, <4% Oil"},{"$f":"Feed!G29","v":0},"lbs"]
[{"$f":"Feed!A30","v":"Corn HP DDG"},{"$f":"Feed!G30","v":0},"lbs"]
[{"$f":"Feed!A31","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!G31","v":0},"lbs"]
[{"$f":"Feed!A32","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!G32","v":0},"lbs"]
[{"$f":"Feed!A33","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!G33","v":0},"lbs"]
[{"$f":"Feed!A34","v":"Corn Gluten Meal"},{"$f":"Feed!G34","v":0},"lbs"]
[{"$f":"Feed!A35","v":"Corn Grits, Hominy Feed"},{"$f":"Feed!G35","v":0},"lbs"]
[{"$f":"Feed!A36","v":"Cotton Seeds, Fullfat"},{"$f":"Feed!G36","v":0},"lbs"]
[{"$f":"Feed!A37","v":"Cotton Seed Meal"},{"$f":"Feed!G37","v":0},"lbs"]
[{"$f":"Feed!A38","v":"Feather Meal"},{"$f":"Feed!G38","v":0},"lbs"]
[{"$f":"Feed!A39","v":"Fish Meal Combined"},{"$f":"Feed!G39","v":0},"lbs"]
[{"$f":"Feed!A40","v":"Flaxseed"},{"$f":"Feed!G40","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!G41","v":0},"lbs"]
[{"$f":"Feed!A42","v":"Lupins"},{"$f":"Feed!G42","v":0},"lbs"]
[{"$f":"Feed!A43","v":"Meat Meal"},{"$f":"Feed!G43","v":0},"lbs"]
[{"$f":"Feed!A44","v":"Meat and Bone Meal, P >4%"},{"$f":"Feed!G44","v":0},"lbs"]
[{"$f":"Feed!A45","v":"Milk, Casein"},{"$f":"Feed!G45","v":0},"lbs"]
[{"$f":"Feed!A46","v":"Milk, Lactose"},{"$f":"Feed!G46","v":0},"lbs"]
[{"$f":"Feed!A47","v":"Milk, Skim Milk Powder"},{"$f":"Feed!G47","v":0},"lbs"]
[{"$f":"Feed!A48","v":"Milk, Whey Powder"},{"$f":"Feed!G48","v":0},"lbs"]
[{"$f":"Feed!A49","v":"Milk, Whey Permeate, 85% lactose"},{"$f":"Feed!G49","v":0},"lbs"]
[{"$f":"Feed!A50","v":"Milk, Whey Protein Concentrate"},{"$f":"Feed!G50","v":0},"lbs"]
[{"$f":"Feed!A51","v":"Millet"},{"$f":"Feed!G51","v":0},"lbs"]
[{"$f":"Feed!A52","v":"Molasses, Sugarbeet"},{"$f":"Feed!G52","v":0},"lbs"]
[{"$f":"Feed!A53","v":"Molasses, Sugarcane"},{"$f":"Feed!G53","v":0},"lbs"]
[{"$f":"Feed!A54","v":"Oats"},{"$f":"Feed!G54","v":0},"lbs"]
[{"$f":"Feed!A55","v":"Oats, Naked"},{"$f":"Feed!G55","v":0},"lbs"]
[{"$f":"Feed!A56","v":"Oat Groats"},{"$f":"Feed!G56","v":0},"lbs"]
[{"$f":"Feed!A57","v":"Peanut Meal, Expelled"},{"$f":"Feed!G57","v":0},"lbs"]
[{"$f":"Feed!A58","v":"Peanut Meal, Extracted"},{"$f":"Feed!G58","v":0},"lbs"]
[{"$f":"Feed!A59","v":"Peas, Field Peas"},{"$f":"Feed!G59","v":0},"lbs"]
[{"$f":"Feed!A60","v":"Pea Protein Concentrate"},{"$f":"Feed!G60","v":0},"lbs"]
[{"$f":"Feed!A61","v":"Potato Protein Concentrate"},{"$f":"Feed!G61","v":0},"lbs"]
[{"$f":"Feed!A62","v":"Poultry Byproduct"},{"$f":"Feed!G62","v":0},"lbs"]
[{"$f":"Feed!A63","v":"Rice"},{"$f":"Feed!G63","v":0},"lbs"]
[{"$f":"Feed!A64","v":"Rice Bran"},{"$f":"Feed!G64","v":0},"lbs"]
[{"$f":"Feed!A65","v":"Rice Bran, Defatted"},{"$f":"Feed!G65","v":0},"lbs"]
[{"$f":"Feed!A66","v":"Rice, Broken"},{"$f":"Feed!G66","v":0},"lbs"]
[{"$f":"Feed!A67","v":"Rye"},{"$f":"Feed!G67","v":0},"lbs"]
[{"$f":"Feed!A68","v":"Sesame Meal"},{"$f":"Feed!G68","v":0},"lbs"]
[{"$f":"Feed!A69","v":"Sorghum"},{"$f":"Feed!G69","v":0},"lbs"]
[{"$f":"Feed!A70","v":"Soybeans, Full Fat"},{"$f":"Feed!G70","v":0},"lbs"]
[{"$f":"Feed!A71","v":"Soybeans, High Protein, Full Fat"},{"$f":"Feed!G71","v":0},"lbs"]
[{"$f":"Feed!A72","v":"Soybeans, Low Oligosaccharide, Full Fat"},{"$f":"Feed!G72","v":0},"lbs"]
[{"$f":"Feed!A73","v":"Soybean Meal, High Protein, Expelled"},{"$f":"Feed!G73","v":0},"lbs"]
[{"$f":"Feed!A74","v":"Soybean Meal, Low Oligosacch, Expell"},{"$f":"Feed!G74","v":0},"lbs"]
[{"$f":"Feed!A75","v":"Soybean Meal, Expelled"},{"$f":"Feed!G75","v":0},"lbs"]
[{"$f":"Feed!A76","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!G76","v":0},"lbs"]
[{"$f":"Feed!A77","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!G77","v":0},"lbs"]
[{"$f":"Feed!A78","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!G78","v":139.69447613943316},"lbs"]
[{"$f":"Feed!A79","v":"Soybean Meal, High Prot, Dehull, Solv Extr"},{"$f":"Feed!G79","v":0},"lbs"]
[{"$f":"Feed!A80","v":"Soybean Meal, Enzyme Treated"},{"$f":"Feed!G80","v":0},"lbs"]
[{"$f":"Feed!A81","v":"Soybean Meal, Fermented"},{"$f":"Feed!G81","v":0},"lbs"]
[{"$f":"Feed!A82","v":"Soybean Hulls"},{"$f":"Feed!G82","v":0},"lbs"]
[{"$f":"Feed!A83","v":"Soy Protein Concentrate"},{"$f":"Feed!G83","v":0},"lbs"]
[{"$f":"Feed!A84","v":"Soy Protein Isolate"},{"$f":"Feed!G84","v":0},"lbs"]
[{"$f":"Feed!A85","v":"Sugar Beet Pulp"},{"$f":"Feed!G85","v":0},"lbs"]
[{"$f":"Feed!A86","v":"Sunflower, Full Fat"},{"$f":"Feed!G86","v":0},"lbs"]
[{"$f":"Feed!A87","v":"Sunflower Meal, Solvent Extracted"},{"$f":"Feed!G87","v":0},"lbs"]
[{"$f":"Feed!A88","v":"Sunflower Meal, Dehulled, Solvent Extr"},{"$f":"Feed!G88","v":0},"lbs"]
[{"$f":"Feed!A89","v":"Triticale"},{"$f":"Feed!G89","v":0},"lbs"]
[{"$f":"Feed!A90","v":"Wheat, Hard Red"},{"$f":"Feed!G90","v":0},"lbs"]
[{"$f":"Feed!A91","v":"Wheat, Soft Red"},{"$f":"Feed!G91","v":0},"lbs"]
[{"$f":"Feed!A92","v":"Wheat Bran"},{"$f":"Feed!G92","v":0},"lbs"]
[{"$f":"Feed!A93","v":"Wheat Middlings"},{"$f":"Feed!G93","v":0},"lbs"]
[{"$f":"Feed!A94","v":"Wheat Shorts"},{"$f":"Feed!G94","v":0},"lbs"]
[{"$f":"Feed!A95","v":"Wheat DDGS"},{"$f":"Feed!G95","v":0},"lbs"]
[{"$f":"Feed!A96","v":"Yeast, Brewers' Yeast"},{"$f":"Feed!G96","v":0},"lbs"]
[{"$f":"Feed!A97","v":"Yeast, Single Cell Protein"},{"$f":"Feed!G97","v":0},"lbs"]
[{"$f":"Feed!A98","v":"Beef Tallow"},{"$f":"Feed!G98","v":0},"lbs"]
[{"$f":"Feed!A99","v":"Choice White Grease"},{"$f":"Feed!G99","v":0},"lbs"]
[{"$f":"Feed!A100","v":"Poultry Fat"},{"$f":"Feed!G100","v":0},"lbs"]
[{"$f":"Feed!A101","v":"Lard"},{"$f":"Feed!G101","v":0},"lbs"]
[{"$f":"Feed!A102","v":"Restaurant Grease"},{"$f":"Feed!G102","v":0},"lbs"]
[{"$f":"Feed!A103","v":"Canola oil"},{"$f":"Feed!G103","v":0},"lbs"]
[{"$f":"Feed!A104","v":"Coconut oil"},{"$f":"Feed!G104","v":0},"lbs"]
[{"$f":"Feed!A105","v":"Corn oil"},{"$f":"Feed!G105","v":0},"lbs"]
[{"$f":"Feed!A106","v":"Palm Kernel oil"},{"$f":"Feed!G106","v":0},"lbs"]
[{"$f":"Feed!A107","v":"Soybean oil"},{"$f":"Feed!G107","v":0},"lbs"]
[{"$f":"Feed!A108","v":"Soybean Lecithin"},{"$f":"Feed!G108","v":0},"lbs"]
[{"$f":"Feed!A109","v":"Sunflower oil"},{"$f":"Feed!G109","v":0},"lbs"]
[{"$f":"Feed!A110","v":"Fat, A/V blend"},{"$f":"Feed!G110","v":0},"lbs"]
[{"$f":"Feed!A111","v":"Calcium carbonate"},{"$f":"Feed!G111","v":0},"lbs"]
[{"$f":"Feed!A112","v":"Calcium phosphate (tricalcium)"},{"$f":"Feed!G112","v":0},"lbs"]
[{"$f":"Feed!A113","v":"Calcium phosphate (dicalcium)"},{"$f":"Feed!G113","v":0},"lbs"]
[{"$f":"Feed!A114","v":"Calcium phosphate (monocalcium)"},{"$f":"Feed!G114","v":4.4935331056101093},"lbs"]
[{"$f":"Feed!A115","v":"Calcium sulfate, dihydrate"},{"$f":"Feed!G115","v":0},"lbs"]
[{"$f":"Feed!A116","v":"Limestone, ground"},{"$f":"Feed!G116","v":7.4882920000000013},"lbs"]
[{"$f":"Feed!A117","v":"Magnesium phosphate"},{"$f":"Feed!G117","v":0},"lbs"]
[{"$f":"Feed!A118","v":"Sodium carbonate"},{"$f":"Feed!G118","v":0},"lbs"]
[{"$f":"Feed!A119","v":"Sodium bicarbonate"},{"$f":"Feed!G119","v":0},"lbs"]
[{"$f":"Feed!A120","v":"Sodium chloride"},{"$f":"Feed!G120","v":3.7894400000000004},"lbs"]
[{"$f":"Feed!A121","v":"Sodium phosphate, monobasic"},{"$f":"Feed!G121","v":0},"lbs"]
[{"$f":"Feed!A122","v":"Sodium sulfate, decahydrate"},{"$f":"Feed!G122","v":0},"lbs"]
[{"$f":"Feed!A123","v":"L-Lys-HCL"},{"$f":"Feed!G123","v":2.0639340000000002},"lbs"]
[{"$f":"Feed!A124","v":"DL-Met"},{"$f":"Feed!G124","v":0.18640363353407724},"lbs"]
[{"$f":"Feed!A125","v":"L-Thr"},{"$f":"Feed!G125","v":0.53764118585757259},"lbs"]
[{"$f":"Feed!A126","v":"L-Trp"},{"$f":"Feed!G126","v":6.8292703566466009E-2},"lbs"]
[{"$f":"Feed!A127","v":"L-Val"},{"$f":"Feed!G127","v":0},"lbs"]
[{"$f":"Feed!A128","v":"L-Ileu"},{"$f":"Feed!G128","v":0},"lbs"]
[{"$f":"Feed!A129","v":"Methionine hydroxy analog"},{"$f":"Feed!G129","v":0},"lbs"]
[{"$f":"Feed!A130","v":"Glutamine"},{"$f":"Feed!G130","v":0},"lbs"]
[{"$f":"Feed!A131","v":"Glutamic acid"},{"$f":"Feed!G131","v":0},"lbs"]
[{"$f":"Feed!A132","v":"Biolys"},{"$f":"Feed!G132","v":0},"lbs"]
[{"$f":"Feed!A133","v":"Liquid lysine 60%"},{"$f":"Feed!G133","v":0},"lbs"]
[{"$f":"Feed!A134","v":"MHA dry"},{"$f":"Feed!G134","v":0},"lbs"]
[{"$f":"Feed!A135","v":"Ractopamine 9 g/lb"},{"$f":"Feed!G135","v":0},"lbs"]
[{"$f":"Feed!A136","v":"Phase 2 supplement (PEP2)"},{"$f":"Feed!G136","v":0},"lbs"]
[{"$f":"Feed!A137","v":"2007 Starter base mix"},{"$f":"Feed!G137","v":0},"lbs"]
[{"$f":"Feed!A138","v":"2007 Grow-finish base mix"},{"$f":"Feed!G138","v":0},"lbs"]
[{"$f":"Feed!A139","v":"Developer base mix"},{"$f":"Feed!G139","v":0},"lbs"]
[{"$f":"Feed!A140","v":"2007 Sow base mix"},{"$f":"Feed!G140","v":0},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!G141","v":1.1253980706373845},"lbs"]
[{"$f":"Feed!A142","v":"Trace mineral premix"},{"$f":"Feed!G142","v":0.9568780706373845},"lbs"]
[{"$f":"Feed!A143","v":"Sow add pack"},{"$f":"Feed!G143","v":0.3125},"lbs"]
[{"$f":"Feed!A144","v":"Vitamin premix without phytase"},{"$f":"Feed!G144","v":0},"lbs"]
[{"$f":"Feed!A145","v":"GF DDGS Base Mix"},{"$f":"Feed!G145","v":0},"lbs"]
[{"$f":"Feed!A146","v":"GF synthetics Base Mix"},{"$f":"Feed!G146","v":0},"lbs"]
[{"$f":"Feed!A147","v":"Choline chloride 60%"},{"$f":"Feed!G147","v":0},"lbs"]
[{"$f":"Feed!A148","v":"Natuphos 600"},{"$f":"Feed!G148","v":0},"lbs"]
[{"$f":"Feed!A149","v":"Natuphos 1200"},{"$f":"Feed!G149","v":0},"lbs"]
[{"$f":"Feed!A150","v":"Optiphos 2000"},{"$f":"Feed!G150","v":0},"lbs"]
[{"$f":"Feed!A151","v":"Phyzyme 1200"},{"$f":"Feed!G151","v":0},"lbs"]
[{"$f":"Feed!A152","v":"Phyzyme 5000"},{"$f":"Feed!G152","v":0},"lbs"]
[{"$f":"Feed!A153","v":"Ronozyme CT (10,000)"},{"$f":"Feed!G153","v":0},"lbs"]
[{"$f":"Feed!A154","v":"Ronozyme M (50,000)"},{"$f":"Feed!G154","v":0},"lbs"]
[{"$f":"Feed!A155","v":"Ronozyme PMX PLT (4625 FYT/g)"},{"$f":"Feed!G155","v":5.7856068481511556E-2},"lbs"]
[{"$f":"Feed!A156","v":"Zinc oxide"},{"$f":"Feed!G156","v":0},"lbs"]
[{"$f":"Feed!A157","v":"Copper sulfate"},{"$f":"Feed!G157","v":0},"lbs"]
[{"$f":"Feed!A158","v":"Potassium chloride"},{"$f":"Feed!G158","v":0},"lbs"]
[{"$f":"Feed!A159","v":"Calcium chloride"},{"$f":"Feed!G159","v":0},"lbs"]
[{"$f":"Feed!A160","v":"Acidifier"},{"$f":"Feed!G160","v":0},"lbs"]
[{"$f":"Feed!A161","v":"Vitamin E, 20,000 IU"},{"$f":"Feed!G161","v":0},"lbs"]
[{"$f":"Feed!A162","v":"Phase 2 supplement D"},{"$f":"Feed!G162","v":0},"lbs"]
[{"$f":"Feed!A163","v":"DPS 50"},{"$f":"Feed!G163","v":0},"lbs"]
[{"$f":"Feed!A164","v":"PEP2+"},{"$f":"Feed!G164","v":0},"lbs"]
[{"$f":"Feed!A165","v":"PEP NS"},{"$f":"Feed!G165","v":0},"lbs"]
[{"$f":"Feed!A166","v":"Natural vitamin E 20,000 IU/lb"},{"$f":"Feed!G166","v":0},"lbs"]
[{"$f":"Feed!A167","v":"Other ingredient"},{"$f":"Feed!G167","v":0},"lbs"]
[{"$f":"Feed!A168","v":"Corn DDGS, 10.5% Oil"},{"$f":"Feed!G168","v":0},"lbs"]
[{"$f":"Feed!A169","v":"Corn DDGS, 7.5% Oil"},{"$f":"Feed!G169","v":5.5519999999999996},"lbs"]
[{"$f":"Feed!A170","v":"Corn DDGS, 4.5% Oil"},{"$f":"Feed!G170","v":0},"lbs"]
[{"$f":"Feed!A171","v":"Denegard"},{"$f":"Feed!G171","v":2.1000000000000001E-2},"lbs"]
[{"$f":"Feed!A172","v":"CTC 50"},{"$f":"Feed!G172","v":4.8000000000000001E-2},"lbs"]
[{"$f":"Feed!A173","v":"Bentonite"},{"$f":"Feed!G173","v":0},"lbs"]
[{"$f":"Feed!A174","v":"Phase 2 supplement (Feb, 2014)"},{"$f":"Feed!G174","v":2.1},"lbs"]
[{"$f":"Feed!A175","v":"Other ingredient"},{"$f":"Feed!G175","v":0}]
[{"$f":"Feed!A176","v":"Other ingredient"},{"$f":"Feed!G176","v":0}]
[{"$f":"Feed!A177","v":"Other ingredient"},{"$f":"Feed!G177","v":0}]
[{"$f":"Feed!A178","v":"Other ingredient"},{"$f":"Feed!G178","v":0}]
[{"$f":"Feed!A179","v":"Other ingredient"},{"$f":"Feed!G179","v":0}]
[{"$f":"Feed!A180","v":"Other ingredient"},{"$f":"Feed!G180","v":0}]
[{"$f":"Feed!A181","v":"Other ingredient"},{"$f":"Feed!G181","v":0}]
[{"$f":"Feed!A182","v":"Other ingredient"},{"$f":"Feed!G182","v":0}]
[{"$f":"Feed!A183","v":"Other ingredient"},{"$f":"Feed!G183","v":0}]
[{"$f":"Feed!A184","v":"Other ingredient"},{"$f":"Feed!G184","v":0}]
[{"$f":"Feed!A185","v":"Other ingredient"},{"$f":"Feed!G185","v":0}]
[{"$f":"Feed!A186","v":"Other ingredient"},{"$f":"Feed!G186","v":0}]
[]
["Farrow-Finish Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
[{"$f":"Prices!A14","v":"Market Hogs ($/cwt)"},{"$f":"Prices!B14","v":44.75},{"$f":"Prices!D14","v":46.082000000000001},null,{"$f":"Prices!G14","v":58.48}]
[{"$f":"Prices!A17","v":"Cull Sows ($/cwt)"},{"$f":"Prices!B17","v":46.3},{"$f":"Prices!D17","v":47.678136312849155},null,{"$f":"Prices!G17","v":60.505564245810049}]
[{"$f":"Prices!A18","v":"Replacement Gilts ($/hd)"},{"$f":"Prices!B18","v":198.0625},{"$f":"Prices!D18","v":203.95790223463686},null,{"$f":"Prices!G18","v":258.83117318435757}]
[{"$f":"Prices!A30","v":"Swine Feed processing ($/ton) charge"},{"$f":"Prices!B30","v":17},{"$f":"Prices!D30","v":17},null,{"$f":"Prices!G30","v":17}]
["Sow Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$H$23:$H$174,Prices!$B$40:$B$191)/Feed!H189","v":3.4957828502490414E-2},{"$f":"SUMPRODUCT(Feed!$H$23:$H$174,Prices!$D$40:$D$191)/Feed!H189","v":3.5307406787515316E-2},null,{"$f":"SUMPRODUCT(Feed!$H$23:$H$174,Prices!$G$40:$G$191)/Feed!H189","v":3.5656985072540212E-2}]
["Nursery Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$J$23:$J$174,Prices!$B$40:$B$191)/Feed!J189","v":7.1457484890611336E-2},{"$f":"SUMPRODUCT(Feed!$J$23:$J$174,Prices!$D$40:$D$191)/Feed!J189","v":7.217205973951743E-2},null,{"$f":"SUMPRODUCT(Feed!$J$23:$J$174,Prices!$G$40:$G$191)/Feed!J189","v":7.2886634588423538E-2}]
["Grow-Finish Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$K$23:$K$174,Prices!$B$40:$B$191)/Feed!K189","v":3.0420663579853464E-2},{"$f":"SUMPRODUCT(Feed!$K$23:$K$174,Prices!$D$40:$D$191)/Feed!K189","v":3.0724870215651998E-2},null,{"$f":"SUMPRODUCT(Feed!$K$23:$K$174,Prices!$G$40:$G$191)/Feed!K189","v":3.1029076851450527E-2}]
[{"$f":"Prices!A31","v":"Corn ($/bu)"},{"$f":"Prices!B31","v":4.25},{"$f":"Prices!D31","v":4.18},null,{"$f":"Prices!G31","v":3.55}]
[{"$f":"Prices!A32","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B32","v":380},{"$f":"Prices!D32","v":334.59999999999997},null,{"$f":"Prices!G32","v":341}]
[{"$f":"Prices!A33","v":"DDGS ($/ton)"},{"$f":"Prices!B33","v":210},{"$f":"Prices!D33","v":206.5411764705882},null,{"$f":"Prices!G33","v":175.41176470588235}]
["Other Feed Ingredients",{"$f":"Prices!B34","v":0.10818308031650385},{"$f":"Prices!D34","v":0.10926491111966889},null,{"$f":"Prices!G34","v":0.11034674192283393}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A89","v":"Publication: AM-FMG-FarFin"},null,null,null,null,null,null,null,null,{"$f":"J89","v":"Version- 12.7.2020"}]

{"sheet":"Farrow-Wean","index":4,"n_rows":273,"n_cols":13,"rows_kept":273,"cut":false,"hidden":false,"merged":[[90,0,90,2],[258,2,258,3],[258,4,258,5],[85,9,85,10],[272,9,272,10],[271,0,271,9],[84,0,84,9],[87,0,87,1],[87,2,87,5],[87,6,87,9],[0,0,0,1],[0,2,0,5],[0,6,0,9],[40,0,40,9],[43,0,43,5],[43,6,43,9],[41,9,41,10]]}
[" KSU Farrow-to-Wean Swine Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,null,"INTERNAL NOTES","Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information"]
["Weaned Pigs/Mated Sow/Year",{"$f":"'Farrow-Finish'!B4","v":23.9},null,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Litters/Mated Sow/Year",{"$f":"'Farrow-Finish'!B5","v":2.2999999999999998},null,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Weaning Weight (lbs)",{"$f":"'Farrow-Finish'!J8","v":14},null,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Sow Replacement Rate",0.5,null,null,null,null,null,null,null,null,null,"Per April KSU team meeting"]
["Sow Mortality (%)",0.08,null,null,null,null,null,null,null,null,null,"Per April KSU team meeting"]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Sow","Total per Year per Pig Sold"]
["Weaned Pig",{"$f":"IF($C$1=Prices!$A$1, Prices!B15, IF($C$1=Prices!$A$2, Prices!D15, IF($C$1=Prices!$A$3, Prices!G15, \"\")))","v":43.23},"per hd"," x",1,"hd",null,null," =",{"$f":"K11*B4","v":1033.1969999999999},{"$f":"(B11)*E11","v":43.23}]
["Cull Sows",{"$f":"IF($C$1=Prices!$A$1, Prices!B17, IF($C$1=Prices!$A$2, Prices!D17, IF($C$1=Prices!$A$3, Prices!G17, \"\")))","v":46.3},"per cwt"," x",{"$f":"'Farrow-Finish'!E13","v":400},"lbs"," x",{"$f":"B7-B8","v":0.42}," =",{"$f":"B12*(E12/100)*H12","v":77.783999999999992},{"$f":"J12/B4","v":3.2545606694560667},"Per April KSU team meeting"]
["Manure Credit",null,null,null,null,null,null,null,null,{"$f":"K13*B4","v":11.95},0.5,"Per April KSU team meeting; also note ERS COP places $6.95/cwt gain ($0.90/hd for 13 lb pigs) so our $0.50/hd is reasonable"]
["Other revenue",null,null,null,null,null,null,null,null,{"$f":"K14*B4","v":0},0]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J11:J14)","v":1122.9309999999998},{"$f":"SUM(K11:K14)","v":46.984560669456066}]
[]
["Variable Costs"]
["Sow Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$H$23:$H$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$H$23:$H$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$H$23:$H$188,Prices!$G$41:$G$206), \"\")))/Feed!H189","v":0.10594158912337714},"per lb"," x",{"$f":"Feed!H189","v":125.00000000000001},"lbs",null,null," =",{"$f":"K18*B4","v":316.50049750608923},{"$f":"(B18*E18)","v":13.242698640422145},"Worked from April 2015 KSU XL Ration, collapsing down to #s by phase here w/ details in Feed tab and notes below"]
["Feed Processing",{"$f":"IF($C$1=Prices!$A$1, Prices!B30, IF($C$1=Prices!$A$2, Prices!D30, IF($C$1=Prices!$A$3,Prices!G30, \"\")))","v":17},"per ton"," x",{"$f":"SUM(E18:E18)/2000","v":6.2500000000000014E-2},"ton",null,null," =",{"$f":"K19*B4","v":25.393750000000004},{"$f":"B19*E19","v":1.0625000000000002}]
["Labor",15,"per hour","x",{"$f":"3*B5","v":6.8999999999999995},"hours",null,null," =",{"$f":"B20*E20","v":103.49999999999999},{"$f":"J20/B4","v":4.3305439330543933},"Note: Using Schulz's 3/31/15 Iowa St. values (http://www.extension.iastate.edu/agdm/livestock/pdf/b1-21.pdf) of 3 hrs/litter & 2.30 litters/year in NPB/Stadler. Compares to $4.32/pig from ERS COP."]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"K21*B4","v":60.033773087071232},{"$f":"(4.76/0.2653)*($B$6/100)","v":2.5118733509234827},"Note: Using ERS $10.14/cwt produced value"]
["Replacement Females",{"$f":"(IF(C1=Prices!A1, Prices!B18, IF(C1=Prices!A2, Prices!D18, IF(C1=Prices!A3,Prices!G18, \"\"))))","v":198.0625},"per head"," x",{"$f":"B7","v":0.5},"hd",null,null," =",{"$f":"B22*E22","v":99.03125},{"$f":"J22/B4","v":4.143566945606695}]
["Semen Cost & Genetic Fee",null,null,null,null,null,null,null,null,{"$f":"13*B5","v":29.9},{"$f":"J23/B4","v":1.2510460251046025},"Note: Schulz's 3/31/15 Iowa St. values are $13/litter"]
["Marketing, Bedding, and Misc",null,null,null,null,null,null,null,null,{"$f":"K24*B4","v":3.4229282990493206},{"$f":"(0.17/1.4+0.01/0.4324+0.31/0.3529)*($B$6/100)","v":0.14321875728239836},"Note: Using ERS $0.76/cwt produced value (Bed&Litter, Mkt,Custom Srv)"]
["Utilities, Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"K25*B4","v":18.594791997459513},{"$f":"(1.75/0.3149)*(B6/100)","v":0.77802476976818047},"Note: Using ERS $10.67/cwt produced values (compares w/ Schulz's 3/31/15 $7.5/litter)"]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"K26*B4","v":11.274661713982489},{"$f":"(1.27/0.3769)*(B6/100)","v":0.47174316794905818},"Note: Using ERS $3.28/cwt produced value (low compared to Schulz's 3/31/15 $130/litter)"]
["Other variable costs",null,null,null,null,null,null,null,null,0,{"$f":"J27/B4","v":0}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J18:J27)","v":667.65165260365177},{"$f":"SUM(K18:K27)","v":27.935215590110953}]
[]
["Fixed Costs"]
["Machinery, Facilities, General Overhead",null,null,null,null,null,null,null,null,{"$f":"K31*B4","v":178.3704372763018},{"$f":"(13.1/0.2627+1.83/0.5317)*($B$6/100)","v":7.4631982123975655},"Note: Using ERS $37.08/cwt produced value for capital recovery  of mach. & equipment + $4.42/cwt prod value for General Overhead"]
["Taxes and Insurance",null,null,null,null,null,null,null,null,{"$f":"K32*B4","v":6.0787242632216403},{"$f":"(0.9/0.4954)*($B$6/100)","v":0.25433992733144939},"Note: Using ERS $2.18/cwt produced value"]
["Legal, Accounting, etc.",null,null,null,null,null,null,null,null,{"$f":"K33*B4","v":11.95},0.5,"no source"]
["Other fixed costs",null,null,null,null,null,null,null,null,0,{"$f":"J34/B4","v":0}]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J31:J34)","v":196.39916153952342},{"$f":"SUM(K31:K34)","v":8.2175381397290153}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J28+J35","v":864.05081414317522},{"$f":"K28+K35","v":36.152753729839972},"Compares to ERS COP of $32.73/pig ($251.76/cwt produced)"]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J15-J28","v":455.27934739634804},{"$f":"K15-K28","v":19.049345079345112}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J15-J37","v":258.8801858568246},{"$f":"K15-K37","v":10.831806939616094}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-FarWean",null,null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 12.7.2020"}]
[]
[{"$f":"A1","v":" KSU Farrow-to-Wean Swine Budget"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A42","v":"Publication: AM-FMG-FarWean"},null,null,null,null,null,null,null,null,{"$f":"J42","v":"Version- 12.7.2020"}]
[]
[{"$f":"A44","v":" KSU Farrow-to-Wean Swine Budget"}]
["Budget Assumptions"]
[]
["Feed Ration"]
["Ingredient","Qty","Unit"]
[{"$f":"Feed!A23","v":"Corn, Yellow Dent"},{"$f":"Feed!H23","v":97.563856046378703},"lbs"]
[{"$f":"Feed!A24","v":"Corn, Nutridense"},{"$f":"Feed!H24","v":0},"lbs"]
[{"$f":"Feed!A25","v":"Corn Bran"},{"$f":"Feed!H25","v":0},"lbs"]
[{"$f":"Feed!A26","v":"Corn DDG"},{"$f":"Feed!H26","v":0},"lbs"]
[{"$f":"Feed!A27","v":"Corn DDGS, >10% Oil"},{"$f":"Feed!H27","v":0},"lbs"]
[{"$f":"Feed!A28","v":"Corn DDGS, >6 and <9% Oil"},{"$f":"Feed!H28","v":0},"lbs"]
[{"$f":"Feed!A29","v":"Corn DDGS, <4% Oil"},{"$f":"Feed!H29","v":0},"lbs"]
[{"$f":"Feed!A30","v":"Corn HP DDG"},{"$f":"Feed!H30","v":0},"lbs"]
[{"$f":"Feed!A31","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!H31","v":0},"lbs"]
[{"$f":"Feed!A32","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!H32","v":0},"lbs"]
[{"$f":"Feed!A33","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!H33","v":0},"lbs"]
[{"$f":"Feed!A34","v":"Corn Gluten Meal"},{"$f":"Feed!H34","v":0},"lbs"]
[{"$f":"Feed!A35","v":"Corn Grits, Hominy Feed"},{"$f":"Feed!H35","v":0},"lbs"]
[{"$f":"Feed!A36","v":"Cotton Seeds, Fullfat"},{"$f":"Feed!H36","v":0},"lbs"]
[{"$f":"Feed!A37","v":"Cotton Seed Meal"},{"$f":"Feed!H37","v":0},"lbs"]
[{"$f":"Feed!A38","v":"Feather Meal"},{"$f":"Feed!H38","v":0},"lbs"]
[{"$f":"Feed!A39","v":"Fish Meal Combined"},{"$f":"Feed!H39","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!H41","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!H41","v":0},"lbs"]
[{"$f":"Feed!A42","v":"Lupins"},{"$f":"Feed!H42","v":0},"lbs"]
[{"$f":"Feed!A43","v":"Meat Meal"},{"$f":"Feed!H43","v":0},"lbs"]
[{"$f":"Feed!A44","v":"Meat and Bone Meal, P >4%"},{"$f":"Feed!H44","v":0},"lbs"]
[{"$f":"Feed!A45","v":"Milk, Casein"},{"$f":"Feed!H45","v":0},"lbs"]
[{"$f":"Feed!A46","v":"Milk, Lactose"},{"$f":"Feed!H46","v":0},"lbs"]
[{"$f":"Feed!A47","v":"Milk, Skim Milk Powder"},{"$f":"Feed!H47","v":0},"lbs"]
[{"$f":"Feed!A48","v":"Milk, Whey Powder"},{"$f":"Feed!H48","v":0},"lbs"]
[{"$f":"Feed!A49","v":"Milk, Whey Permeate, 85% lactose"},{"$f":"Feed!H49","v":0},"lbs"]
[{"$f":"Feed!A50","v":"Milk, Whey Protein Concentrate"},{"$f":"Feed!H50","v":0},"lbs"]
[{"$f":"Feed!A51","v":"Millet"},{"$f":"Feed!H51","v":0},"lbs"]
[{"$f":"Feed!A52","v":"Molasses, Sugarbeet"},{"$f":"Feed!H52","v":0},"lbs"]
[{"$f":"Feed!A53","v":"Molasses, Sugarcane"},{"$f":"Feed!H53","v":0},"lbs"]
[{"$f":"Feed!A54","v":"Oats"},{"$f":"Feed!H54","v":0},"lbs"]
[{"$f":"Feed!A55","v":"Oats, Naked"},{"$f":"Feed!H55","v":0},"lbs"]
[{"$f":"Feed!A56","v":"Oat Groats"},{"$f":"Feed!H56","v":0},"lbs"]
[{"$f":"Feed!A57","v":"Peanut Meal, Expelled"},{"$f":"Feed!H57","v":0},"lbs"]
[{"$f":"Feed!A58","v":"Peanut Meal, Extracted"},{"$f":"Feed!H58","v":0},"lbs"]
[{"$f":"Feed!A59","v":"Peas, Field Peas"},{"$f":"Feed!H59","v":0},"lbs"]
[{"$f":"Feed!A60","v":"Pea Protein Concentrate"},{"$f":"Feed!H60","v":0},"lbs"]
[{"$f":"Feed!A61","v":"Potato Protein Concentrate"},{"$f":"Feed!H61","v":0},"lbs"]
[{"$f":"Feed!A62","v":"Poultry Byproduct"},{"$f":"Feed!H62","v":0},"lbs"]
[{"$f":"Feed!A63","v":"Rice"},{"$f":"Feed!H63","v":0},"lbs"]
[{"$f":"Feed!A64","v":"Rice Bran"},{"$f":"Feed!H64","v":0},"lbs"]
[{"$f":"Feed!A65","v":"Rice Bran, Defatted"},{"$f":"Feed!H65","v":0},"lbs"]
[{"$f":"Feed!A66","v":"Rice, Broken"},{"$f":"Feed!H66","v":0},"lbs"]
[{"$f":"Feed!A67","v":"Rye"},{"$f":"Feed!H67","v":0},"lbs"]
[{"$f":"Feed!A68","v":"Sesame Meal"},{"$f":"Feed!H68","v":0},"lbs"]
[{"$f":"Feed!A69","v":"Sorghum"},{"$f":"Feed!H69","v":0},"lbs"]
[{"$f":"Feed!A70","v":"Soybeans, Full Fat"},{"$f":"Feed!H70","v":0},"lbs"]
[{"$f":"Feed!A71","v":"Soybeans, High Protein, Full Fat"},{"$f":"Feed!H71","v":0},"lbs"]
[{"$f":"Feed!A72","v":"Soybeans, Low Oligosaccharide, Full Fat"},{"$f":"Feed!H72","v":0},"lbs"]
[{"$f":"Feed!A73","v":"Soybean Meal, High Protein, Expelled"},{"$f":"Feed!H73","v":0},"lbs"]
[{"$f":"Feed!A74","v":"Soybean Meal, Low Oligosacch, Expell"},{"$f":"Feed!H74","v":0},"lbs"]
[{"$f":"Feed!A75","v":"Soybean Meal, Expelled"},{"$f":"Feed!H75","v":0},"lbs"]
[{"$f":"Feed!A76","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!H76","v":0},"lbs"]
[{"$f":"Feed!A77","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!H77","v":0},"lbs"]
[{"$f":"Feed!A78","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!H78","v":22.7023939536213},"lbs"]
[{"$f":"Feed!A79","v":"Soybean Meal, High Prot, Dehull, Solv Extr"},{"$f":"Feed!H79","v":0},"lbs"]
[{"$f":"Feed!A80","v":"Soybean Meal, Enzyme Treated"},{"$f":"Feed!H80","v":0},"lbs"]
[{"$f":"Feed!A81","v":"Soybean Meal, Fermented"},{"$f":"Feed!H81","v":0},"lbs"]
[{"$f":"Feed!A82","v":"Soybean Hulls"},{"$f":"Feed!H82","v":0},"lbs"]
[{"$f":"Feed!A83","v":"Soy Protein Concentrate"},{"$f":"Feed!H83","v":0},"lbs"]
[{"$f":"Feed!A84","v":"Soy Protein Isolate"},{"$f":"Feed!H84","v":0},"lbs"]
[{"$f":"Feed!A85","v":"Sugar Beet Pulp"},{"$f":"Feed!H85","v":0},"lbs"]
[{"$f":"Feed!A86","v":"Sunflower, Full Fat"},{"$f":"Feed!H86","v":0},"lbs"]
[{"$f":"Feed!A87","v":"Sunflower Meal, Solvent Extracted"},{"$f":"Feed!H87","v":0},"lbs"]
[{"$f":"Feed!A88","v":"Sunflower Meal, Dehulled, Solvent Extr"},{"$f":"Feed!H88","v":0},"lbs"]
[{"$f":"Feed!A89","v":"Triticale"},{"$f":"Feed!H89","v":0},"lbs"]
[{"$f":"Feed!A90","v":"Wheat, Hard Red"},{"$f":"Feed!H90","v":0},"lbs"]
[{"$f":"Feed!A91","v":"Wheat, Soft Red"},{"$f":"Feed!H91","v":0},"lbs"]
[{"$f":"Feed!A92","v":"Wheat Bran"},{"$f":"Feed!H92","v":0},"lbs"]
[{"$f":"Feed!A93","v":"Wheat Middlings"},{"$f":"Feed!H93","v":0},"lbs"]
[{"$f":"Feed!A94","v":"Wheat Shorts"},{"$f":"Feed!H94","v":0},"lbs"]
[{"$f":"Feed!A95","v":"Wheat DDGS"},{"$f":"Feed!H95","v":0},"lbs"]
[{"$f":"Feed!A96","v":"Yeast, Brewers' Yeast"},{"$f":"Feed!H96","v":0},"lbs"]
[{"$f":"Feed!A97","v":"Yeast, Single Cell Protein"},{"$f":"Feed!H97","v":0},"lbs"]
[{"$f":"Feed!A98","v":"Beef Tallow"},{"$f":"Feed!H98","v":0},"lbs"]
[{"$f":"Feed!A99","v":"Choice White Grease"},{"$f":"Feed!H99","v":0},"lbs"]
[{"$f":"Feed!A100","v":"Poultry Fat"},{"$f":"Feed!H100","v":0},"lbs"]
[{"$f":"Feed!A101","v":"Lard"},{"$f":"Feed!H101","v":0},"lbs"]
[{"$f":"Feed!A102","v":"Restaurant Grease"},{"$f":"Feed!H102","v":0},"lbs"]
[{"$f":"Feed!A103","v":"Canola oil"},{"$f":"Feed!H103","v":0},"lbs"]
[{"$f":"Feed!A104","v":"Coconut oil"},{"$f":"Feed!H104","v":0},"lbs"]
[{"$f":"Feed!A105","v":"Corn oil"},{"$f":"Feed!H105","v":0},"lbs"]
[{"$f":"Feed!A106","v":"Palm Kernel oil"},{"$f":"Feed!H106","v":0},"lbs"]
[{"$f":"Feed!A107","v":"Soybean oil"},{"$f":"Feed!H107","v":0},"lbs"]
[{"$f":"Feed!A108","v":"Soybean Lecithin"},{"$f":"Feed!H108","v":0},"lbs"]
[{"$f":"Feed!A109","v":"Sunflower oil"},{"$f":"Feed!H109","v":0},"lbs"]
[{"$f":"Feed!A110","v":"Fat, A/V blend"},{"$f":"Feed!H110","v":0},"lbs"]
[{"$f":"Feed!A111","v":"Calcium carbonate"},{"$f":"Feed!H111","v":0},"lbs"]
[{"$f":"Feed!A112","v":"Calcium phosphate (tricalcium)"},{"$f":"Feed!H112","v":0},"lbs"]
[{"$f":"Feed!A113","v":"Calcium phosphate (dicalcium)"},{"$f":"Feed!H113","v":0},"lbs"]
[{"$f":"Feed!A114","v":"Calcium phosphate (monocalcium)"},{"$f":"Feed!H114","v":1.625},"lbs"]
[{"$f":"Feed!A115","v":"Calcium sulfate, dihydrate"},{"$f":"Feed!H115","v":0},"lbs"]
[{"$f":"Feed!A116","v":"Limestone, ground"},{"$f":"Feed!H116","v":1.6025},"lbs"]
[{"$f":"Feed!A117","v":"Magnesium phosphate"},{"$f":"Feed!H117","v":0},"lbs"]
[{"$f":"Feed!A118","v":"Sodium carbonate"},{"$f":"Feed!H118","v":0},"lbs"]
[{"$f":"Feed!A119","v":"Sodium bicarbonate"},{"$f":"Feed!H119","v":0},"lbs"]
[{"$f":"Feed!A120","v":"Sodium chloride"},{"$f":"Feed!H120","v":0.57999999999999996},"lbs"]
[{"$f":"Feed!A121","v":"Sodium phosphate, monobasic"},{"$f":"Feed!H121","v":0},"lbs"]
[{"$f":"Feed!A122","v":"Sodium sulfate, decahydrate"},{"$f":"Feed!H122","v":0},"lbs"]
[{"$f":"Feed!A123","v":"L-Lys-HCL"},{"$f":"Feed!H123","v":8.8749999999999996E-2},"lbs"]
[{"$f":"Feed!A124","v":"DL-Met"},{"$f":"Feed!H124","v":1.2500000000000001E-2},"lbs"]
[{"$f":"Feed!A125","v":"L-Thr"},{"$f":"Feed!H125","v":1.2500000000000001E-2},"lbs"]
[{"$f":"Feed!A126","v":"L-Trp"},{"$f":"Feed!H126","v":0},"lbs"]
[{"$f":"Feed!A127","v":"L-Val"},{"$f":"Feed!H127","v":0},"lbs"]
[{"$f":"Feed!A128","v":"L-Ileu"},{"$f":"Feed!H128","v":0},"lbs"]
[{"$f":"Feed!A129","v":"Methionine hydroxy analog"},{"$f":"Feed!H129","v":0},"lbs"]
[{"$f":"Feed!A130","v":"Glutamine"},{"$f":"Feed!H130","v":0},"lbs"]
[{"$f":"Feed!A131","v":"Glutamic acid"},{"$f":"Feed!H131","v":0},"lbs"]
[{"$f":"Feed!A132","v":"Biolys"},{"$f":"Feed!H132","v":0},"lbs"]
[{"$f":"Feed!A133","v":"Liquid lysine 60%"},{"$f":"Feed!H133","v":0},"lbs"]
[{"$f":"Feed!A134","v":"MHA dry"},{"$f":"Feed!H134","v":0},"lbs"]
[{"$f":"Feed!A135","v":"Ractopamine 9 g/lb"},{"$f":"Feed!H135","v":0},"lbs"]
[{"$f":"Feed!A136","v":"Phase 2 supplement (PEP2)"},{"$f":"Feed!H136","v":0},"lbs"]
[{"$f":"Feed!A137","v":"2007 Starter base mix"},{"$f":"Feed!H137","v":0},"lbs"]
[{"$f":"Feed!A138","v":"2007 Grow-finish base mix"},{"$f":"Feed!H138","v":0},"lbs"]
[{"$f":"Feed!A139","v":"Developer base mix"},{"$f":"Feed!H139","v":0},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!H141","v":0.3125},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!H141","v":0.3125},"lbs"]
[{"$f":"Feed!A142","v":"Trace mineral premix"},{"$f":"Feed!H142","v":0.1875},"lbs"]
[{"$f":"Feed!A143","v":"Sow add pack"},{"$f":"Feed!H143","v":0.3125},"lbs"]
[{"$f":"Feed!A144","v":"Vitamin premix without phytase"},{"$f":"Feed!H144","v":0},"lbs"]
[{"$f":"Feed!A145","v":"GF DDGS Base Mix"},{"$f":"Feed!H145","v":0},"lbs"]
[{"$f":"Feed!A146","v":"GF synthetics Base Mix"},{"$f":"Feed!H146","v":0},"lbs"]
[{"$f":"Feed!A147","v":"Choline chloride 60%"},{"$f":"Feed!H147","v":0},"lbs"]
[{"$f":"Feed!A148","v":"Natuphos 600"},{"$f":"Feed!H148","v":0},"lbs"]
[{"$f":"Feed!A149","v":"Natuphos 1200"},{"$f":"Feed!H149","v":0},"lbs"]
[{"$f":"Feed!A150","v":"Optiphos 2000"},{"$f":"Feed!H150","v":0},"lbs"]
[{"$f":"Feed!A151","v":"Phyzyme 1200"},{"$f":"Feed!H151","v":0},"lbs"]
[{"$f":"Feed!A152","v":"Phyzyme 5000"},{"$f":"Feed!H152","v":0},"lbs"]
[{"$f":"Feed!A153","v":"Ronozyme CT (10,000)"},{"$f":"Feed!H153","v":0},"lbs"]
[{"$f":"Feed!A154","v":"Ronozyme M (50,000)"},{"$f":"Feed!H154","v":0},"lbs"]
[{"$f":"Feed!A155","v":"Ronozyme PMX PLT (4625 FYT/g)"},{"$f":"Feed!H155","v":0},"lbs"]
[{"$f":"Feed!A156","v":"Zinc oxide"},{"$f":"Feed!H156","v":0},"lbs"]
[{"$f":"Feed!A157","v":"Copper sulfate"},{"$f":"Feed!H157","v":0},"lbs"]
[{"$f":"Feed!A158","v":"Potassium chloride"},{"$f":"Feed!H158","v":0},"lbs"]
[{"$f":"Feed!A159","v":"Calcium chloride"},{"$f":"Feed!H159","v":0},"lbs"]
[{"$f":"Feed!A160","v":"Acidifier"},{"$f":"Feed!H160","v":0},"lbs"]
[{"$f":"Feed!A161","v":"Vitamin E, 20,000 IU"},{"$f":"Feed!H161","v":0},"lbs"]
[{"$f":"Feed!A162","v":"Phase 2 supplement D"},{"$f":"Feed!H162","v":0},"lbs"]
[{"$f":"Feed!A163","v":"DPS 50"},{"$f":"Feed!H163","v":0},"lbs"]
[{"$f":"Feed!A164","v":"PEP2+"},{"$f":"Feed!H164","v":0},"lbs"]
[{"$f":"Feed!A165","v":"PEP NS"},{"$f":"Feed!H165","v":0},"lbs"]
[{"$f":"Feed!A166","v":"Natural vitamin E 20,000 IU/lb"},{"$f":"Feed!H166","v":0},"lbs"]
[{"$f":"Feed!A167","v":"Other ingredient"},{"$f":"Feed!H167","v":0},"lbs"]
[{"$f":"Feed!A168","v":"Corn DDGS, 10.5% Oil"},{"$f":"Feed!H168","v":0},"lbs"]
[{"$f":"Feed!A169","v":"Corn DDGS, 7.5% Oil"},{"$f":"Feed!H169","v":0},"lbs"]
[{"$f":"Feed!A170","v":"Corn DDGS, 4.5% Oil"},{"$f":"Feed!H170","v":0},"lbs"]
[{"$f":"Feed!A171","v":"Denegard"},{"$f":"Feed!H171","v":0},"lbs"]
[{"$f":"Feed!A172","v":"CTC 50"},{"$f":"Feed!H172","v":0},"lbs"]
[{"$f":"Feed!A173","v":"Bentonite"},{"$f":"Feed!H173","v":0},"lbs"]
[{"$f":"Feed!A188","v":"Complete nursery pellet"},{"$f":"Feed!H188","v":0},"lbs"]
[{"$f":"Feed!A175","v":"Other ingredient"},{"$f":"Feed!H175","v":0}]
[{"$f":"Feed!A176","v":"Other ingredient"},{"$f":"Feed!H176","v":0}]
[{"$f":"Feed!A177","v":"Other ingredient"},{"$f":"Feed!H177","v":0}]
[{"$f":"Feed!A178","v":"Other ingredient"},{"$f":"Feed!H178","v":0}]
[{"$f":"Feed!A179","v":"Other ingredient"},{"$f":"Feed!H179","v":0}]
[{"$f":"Feed!A180","v":"Other ingredient"},{"$f":"Feed!H180","v":0}]
[{"$f":"Feed!A181","v":"Other ingredient"},{"$f":"Feed!H181","v":0}]
[{"$f":"Feed!A182","v":"Other ingredient"},{"$f":"Feed!H182","v":0}]
[{"$f":"Feed!A183","v":"Other ingredient"},{"$f":"Feed!H183","v":0}]
[{"$f":"Feed!A184","v":"Other ingredient"},{"$f":"Feed!H184","v":0}]
[{"$f":"Feed!A185","v":"Other ingredient"},{"$f":"Feed!H185","v":0}]
[{"$f":"Feed!A186","v":"Other ingredient"},{"$f":"Feed!H186","v":0}]
[]
["Farrow-Wean Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
[{"$f":"Prices!A15","v":"Weaned Pig ($/hd)"},{"$f":"Prices!B15","v":43.23},{"$f":"Prices!D15","v":53.152019889999991},null,{"$f":"Prices!G15","v":57.988702099999998}]
[{"$f":"Prices!A17","v":"Cull Sows ($/cwt)"},{"$f":"Prices!B17","v":46.3},{"$f":"Prices!D17","v":47.678136312849155},null,{"$f":"Prices!G17","v":60.505564245810049}]
[{"$f":"Prices!A18","v":"Replacement Gilts ($/hd)"},{"$f":"Prices!B18","v":198.0625},{"$f":"Prices!D18","v":203.95790223463686},null,{"$f":"Prices!G18","v":258.83117318435757}]
[{"$f":"Prices!A30","v":"Swine Feed processing ($/ton) charge"},{"$f":"Prices!B30","v":17},{"$f":"Prices!D30","v":17},null,{"$f":"Prices!G30","v":17}]
["Sow Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$H$23:$H$188,Prices!$B$41:$B$206)/Feed!H189","v":0.10594158912337714},{"$f":"SUMPRODUCT(Feed!$H$23:$H$188,Prices!$D$41:$D$206)/Feed!H189","v":0.10700100501461093},null,{"$f":"SUMPRODUCT(Feed!$H$23:$H$188,Prices!$G$41:$G$206)/Feed!H189","v":0.10806042090584468}]
[{"$f":"Prices!A31","v":"Corn ($/bu)"},{"$f":"Prices!B31","v":4.25},{"$f":"Prices!D31","v":4.18},null,{"$f":"Prices!G31","v":3.55}]
[{"$f":"Prices!A32","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B32","v":380},{"$f":"Prices!D32","v":334.59999999999997},null,{"$f":"Prices!G32","v":341}]
[{"$f":"Prices!A33","v":"DDGS ($/ton)"},{"$f":"Prices!B33","v":210},{"$f":"Prices!D33","v":206.5411764705882},null,{"$f":"Prices!G33","v":175.41176470588235}]
["Other Feed Ingredients",{"$f":"Prices!B35","v":0.20277752822665265},{"$f":"Prices!D35","v":0.20480530350891918},null,{"$f":"Prices!G35","v":0.2068330787911857}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A86","v":"Publication: AM-FMG-FarWean"},null,null,null,null,null,null,null,null,{"$f":"J86","v":"Version- 12.7.2020"}]

{"sheet":"Wean-Finish","index":5,"n_rows":270,"n_cols":12,"rows_kept":270,"cut":false,"hidden":false,"merged":[[269,8,269,9],[3,3,3,4],[5,3,5,6],[268,0,268,8],[0,6,0,9],[87,0,87,2],[255,2,255,3],[255,4,255,5],[0,0,0,1],[0,2,0,5],[38,8,38,9],[82,8,82,9],[15,10,16,10],[81,0,81,8],[84,0,84,1],[84,2,84,5],[84,6,84,8],[37,0,37,8],[40,0,40,5],[40,6,40,8]]}
[" KSU Wean-to-Finish Swine Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,"INTERNAL NOTES","Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information",null,null,null,null,null,null,null,null,null," - note ERS COP are not posted for wean-fin (working from BOTH wean-feeder & feeder-fin info to get $/pig values)"]
["Wean-Finish Mortality (%)",7.99,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Wean-Finish Feed to Gain",2.54,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Placement Weight (lbs)",{"$f":"'Farrow-Finish'!J8","v":14},null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Pig Sold"]
["Market Hogs",{"$f":"IF($C$1=Prices!$A$1, Prices!B14, IF($C$1=Prices!$A$2, Prices!D14, IF($C$1=Prices!$A$3, Prices!G14, \"\")))","v":44.75},"per cwt"," x",{"$f":"'Farrow-Finish'!E12","v":277},"lbs"," x",{"$f":"1-B4/100","v":0.92010000000000003}," =",{"$f":"B9*(E9/100)*H9","v":114.05329575},"274 lbs is from NPB/Stadler 2014 report table 3"]
["Less cost of Weaned Pigs",{"$f":"IF($C$1=Prices!$A$1, Prices!B15, IF($C$1=Prices!$A$2, Prices!D15, IF($C$1=Prices!$A$3, Prices!G15, \"\")))","v":43.23},"per hd"," x",1,"hd",null,null," =",{"$f":"-1*(B10)*E10","v":-43.23}]
["Manure Credit",null,null,null,null,null,null,null,null,5.5,"Per April KSU team meeting; also note ERS COP implies $15.63/pig gain here so our $4.50/hd is conservative"]
["Other revenue",null,null,null,null,null,null,null,null,0]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J12)","v":76.32329575}]
[]
["Variable Costs"]
["Nursery Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$J$23:$J$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$J$23:$J$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$J$23:$J$188,Prices!$G$41:$G$206), \"\")))/Feed!J189","v":0.15909744926779315},"per lb"," x",{"$f":"1.51*(52-B6)","v":57.38},"lbs",null,null," =",{"$f":"(B16*E16)","v":9.1290116389859719},"Worked from April 2015 KSU XL Ration, collapsing down to #s by phase here w/ details in Feed tab and notes below; Also scaling feed lbs given changes to Feed Conversion; Deriving adjusted F/G per Mike on May 6, 2015 to get updated lbs consumed.    Schulz' 3/31/15 values are $80.51/pig. "]
["Grow-Finish Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$K$23:$K$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$K$23:$K$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$K$23:$K$188,Prices!$G$41:$G$206), \"\")))/Feed!K189","v":0.10000813591761802},"per lb"," x",{"$f":"IF(B5=2.54,((((E9-277)*0.005+B5)*(E9-B6))-E16),((B5*(E9-B6))-E16))","v":610.64},"lbs",null,null," =",{"$f":"(B17*E17)","v":61.068968116734268}]
["Feed Processing",{"$f":"IF($C$1=Prices!$A$1, Prices!B30, IF($C$1=Prices!$A$2, Prices!D30, IF($C$1=Prices!$A$3,Prices!G30, \"\")))","v":17},"per ton"," x",{"$f":"SUM(E16:E17)/2000","v":0.33400999999999997},"ton",null,null," =",{"$f":"B18*E18","v":5.6781699999999997}]
["Labor",15,"per hour","x",0.7,"hours",null,null," =",{"$f":"B19*E19","v":10.5},"Note: Using Schulz's 3/31/15 Iowa St. values (http://www.extension.iastate.edu/agdm/livestock/pdf/b1-21.pdf) of 0.7 hrs/pig"]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"1.87*($E$9-Nursery!$E$10)/100+4.76*(Nursery!$E$10-$B$6)/100","v":6.0162999999999993},"Note: Using ERS Wean-Feeder & Feeder-Fin values"]
["Marketing, Bedding, and Misc",null,null,null,null,null,null,null,null,{"$f":"(0.25)*($E$9-Nursery!$E$10)/100+(0.17+0.01+0.31)*(Nursery!$E$10-$B$6)/100","v":0.74870000000000003},"Note: Using ERS Wean-Feeder & Feeder-Fin values"]
["Utilities, Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"1.41*($E$9-Nursery!$E$10)/100+1.75*(Nursery!$E$10-$B$6)/100","v":3.8374999999999999},"Note: Using ERS Wean-Feeder & Feeder-Fin values"]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"0.85*($E$9-Nursery!$E$10)/100+1.27*(Nursery!$E$10-$B$6)/100","v":2.3951000000000002},"Note: Using ERS Wean-Feeder & Feeder-Fin values"]
["Other variable costs",null,null,null,null,null,null,null,null,0]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J24)","v":99.37374975572024}]
[]
["Fixed Costs"]
["Machinery, Facilities, General Overhead",null,null,null,null,null,null,null,null,{"$f":"(8.78)*($E$9-Nursery!$E$10)/100+(13.1+1.83)*(Nursery!$E$10-$B$6)/100","v":25.4284},"Note: Using ERS Wean-Feeder & Feeder-Fin values"]
["Taxes and Insurance",null,null,null,null,null,null,null,null,{"$f":"0.8*($E$9-Nursery!$E$10)/100+0.9*(Nursery!$E$10-$B$6)/100","v":2.1419999999999999},"Note: Using ERS Wean-Feeder & Feeder-Fin values"]
["Legal, Accounting, etc.",null,null,null,null,null,null,null,null,1,"no source"]
["Other fixed costs",null,null,null,null,null,null,null,null,0]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J28:J31)","v":28.570399999999999},"Schulz's 3/31/15 value is $195.42/litter"]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J25+J32","v":127.94414975572025},"Cross-check total costs across Far-Fin vs. Far-Wean+Wean-Fin"]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J13-J25","v":-23.050454005720241},{"$f":"J34+'Farrow-Wean'!K37-'Farrow-Finish'!K40","v":-2.4039727904289805}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J13-J34","v":-51.620854005720247}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-WeanFin",null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 12.7.2020"}]
[]
[{"$f":"A1","v":" KSU Wean-to-Finish Swine Budget"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A39","v":"Publication: AM-FMG-WeanFin"},null,null,null,null,null,null,null,{"$f":"I39","v":"Version- 12.7.2020"}]
[]
[{"$f":"A41","v":" KSU Wean-to-Finish Swine Budget"}]
["Budget Assumptions"]
[]
["Feed Ration"]
["Ingredient","Qty","Unit"]
[{"$f":"Feed!A23","v":"Corn, Yellow Dent"},{"$f":"Feed!I23","v":512.82849897586368},"lbs"]
[{"$f":"Feed!A24","v":"Corn, Nutridense"},{"$f":"Feed!I24","v":0},"lbs"]
[{"$f":"Feed!A25","v":"Corn Bran"},{"$f":"Feed!I25","v":0},"lbs"]
[{"$f":"Feed!A26","v":"Corn DDG"},{"$f":"Feed!I26","v":0},"lbs"]
[{"$f":"Feed!A27","v":"Corn DDGS, >10% Oil"},{"$f":"Feed!I27","v":0},"lbs"]
[{"$f":"Feed!A28","v":"Corn DDGS, >6 and <9% Oil"},{"$f":"Feed!I28","v":0},"lbs"]
[{"$f":"Feed!A29","v":"Corn DDGS, <4% Oil"},{"$f":"Feed!I29","v":0},"lbs"]
[{"$f":"Feed!A30","v":"Corn HP DDG"},{"$f":"Feed!I30","v":0},"lbs"]
[{"$f":"Feed!A31","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!I31","v":0},"lbs"]
[{"$f":"Feed!A32","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!I32","v":0},"lbs"]
[{"$f":"Feed!A33","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!I33","v":0},"lbs"]
[{"$f":"Feed!A34","v":"Corn Gluten Meal"},{"$f":"Feed!I34","v":0},"lbs"]
[{"$f":"Feed!A35","v":"Corn Grits, Hominy Feed"},{"$f":"Feed!I35","v":0},"lbs"]
[{"$f":"Feed!A36","v":"Cotton Seeds, Fullfat"},{"$f":"Feed!I36","v":0},"lbs"]
[{"$f":"Feed!A37","v":"Cotton Seed Meal"},{"$f":"Feed!I37","v":0},"lbs"]
[{"$f":"Feed!A38","v":"Feather Meal"},{"$f":"Feed!I38","v":0},"lbs"]
[{"$f":"Feed!A39","v":"Fish Meal Combined"},{"$f":"Feed!I39","v":0},"lbs"]
[{"$f":"Feed!A40","v":"Flaxseed"},{"$f":"Feed!I40","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!I41","v":0},"lbs"]
[{"$f":"Feed!A42","v":"Lupins"},{"$f":"Feed!I42","v":0},"lbs"]
[{"$f":"Feed!A43","v":"Meat Meal"},{"$f":"Feed!I43","v":0},"lbs"]
[{"$f":"Feed!A44","v":"Meat and Bone Meal, P >4%"},{"$f":"Feed!I44","v":0},"lbs"]
[{"$f":"Feed!A45","v":"Milk, Casein"},{"$f":"Feed!I45","v":0},"lbs"]
[{"$f":"Feed!A46","v":"Milk, Lactose"},{"$f":"Feed!I46","v":0},"lbs"]
[{"$f":"Feed!A47","v":"Milk, Skim Milk Powder"},{"$f":"Feed!I47","v":0},"lbs"]
[{"$f":"Feed!A48","v":"Milk, Whey Powder"},{"$f":"Feed!I48","v":0},"lbs"]
[{"$f":"Feed!A49","v":"Milk, Whey Permeate, 85% lactose"},{"$f":"Feed!I49","v":0},"lbs"]
[{"$f":"Feed!A50","v":"Milk, Whey Protein Concentrate"},{"$f":"Feed!I50","v":0},"lbs"]
[{"$f":"Feed!A51","v":"Millet"},{"$f":"Feed!I51","v":0},"lbs"]
[{"$f":"Feed!A52","v":"Molasses, Sugarbeet"},{"$f":"Feed!I52","v":0},"lbs"]
[{"$f":"Feed!A53","v":"Molasses, Sugarcane"},{"$f":"Feed!I53","v":0},"lbs"]
[{"$f":"Feed!A54","v":"Oats"},{"$f":"Feed!I54","v":0},"lbs"]
[{"$f":"Feed!A55","v":"Oats, Naked"},{"$f":"Feed!I55","v":0},"lbs"]
[{"$f":"Feed!A56","v":"Oat Groats"},{"$f":"Feed!I56","v":0},"lbs"]
[{"$f":"Feed!A57","v":"Peanut Meal, Expelled"},{"$f":"Feed!I57","v":0},"lbs"]
[{"$f":"Feed!A58","v":"Peanut Meal, Extracted"},{"$f":"Feed!I58","v":0},"lbs"]
[{"$f":"Feed!A59","v":"Peas, Field Peas"},{"$f":"Feed!I59","v":0},"lbs"]
[{"$f":"Feed!A60","v":"Pea Protein Concentrate"},{"$f":"Feed!I60","v":0},"lbs"]
[{"$f":"Feed!A61","v":"Potato Protein Concentrate"},{"$f":"Feed!I61","v":0},"lbs"]
[{"$f":"Feed!A62","v":"Poultry Byproduct"},{"$f":"Feed!I62","v":0},"lbs"]
[{"$f":"Feed!A63","v":"Rice"},{"$f":"Feed!I63","v":0},"lbs"]
[{"$f":"Feed!A64","v":"Rice Bran"},{"$f":"Feed!I64","v":0},"lbs"]
[{"$f":"Feed!A65","v":"Rice Bran, Defatted"},{"$f":"Feed!I65","v":0},"lbs"]
[{"$f":"Feed!A66","v":"Rice, Broken"},{"$f":"Feed!I66","v":0},"lbs"]
[{"$f":"Feed!A67","v":"Rye"},{"$f":"Feed!I67","v":0},"lbs"]
[{"$f":"Feed!A68","v":"Sesame Meal"},{"$f":"Feed!I68","v":0},"lbs"]
[{"$f":"Feed!A69","v":"Sorghum"},{"$f":"Feed!I69","v":0},"lbs"]
[{"$f":"Feed!A70","v":"Soybeans, Full Fat"},{"$f":"Feed!I70","v":0},"lbs"]
[{"$f":"Feed!A71","v":"Soybeans, High Protein, Full Fat"},{"$f":"Feed!I71","v":0},"lbs"]
[{"$f":"Feed!A72","v":"Soybeans, Low Oligosaccharide, Full Fat"},{"$f":"Feed!I72","v":0},"lbs"]
[{"$f":"Feed!A73","v":"Soybean Meal, High Protein, Expelled"},{"$f":"Feed!I73","v":0},"lbs"]
[{"$f":"Feed!A74","v":"Soybean Meal, Low Oligosacch, Expell"},{"$f":"Feed!I74","v":0},"lbs"]
[{"$f":"Feed!A75","v":"Soybean Meal, Expelled"},{"$f":"Feed!I75","v":0},"lbs"]
[{"$f":"Feed!A76","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!I76","v":0},"lbs"]
[{"$f":"Feed!A77","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!I77","v":0},"lbs"]
[{"$f":"Feed!A78","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!I78","v":116.99208218581185},"lbs"]
[{"$f":"Feed!A79","v":"Soybean Meal, High Prot, Dehull, Solv Extr"},{"$f":"Feed!I79","v":0},"lbs"]
[{"$f":"Feed!A80","v":"Soybean Meal, Enzyme Treated"},{"$f":"Feed!I80","v":0},"lbs"]
[{"$f":"Feed!A81","v":"Soybean Meal, Fermented"},{"$f":"Feed!I81","v":0},"lbs"]
[{"$f":"Feed!A82","v":"Soybean Hulls"},{"$f":"Feed!I82","v":0},"lbs"]
[{"$f":"Feed!A83","v":"Soy Protein Concentrate"},{"$f":"Feed!I83","v":0},"lbs"]
[{"$f":"Feed!A84","v":"Soy Protein Isolate"},{"$f":"Feed!I84","v":0},"lbs"]
[{"$f":"Feed!A85","v":"Sugar Beet Pulp"},{"$f":"Feed!I85","v":0},"lbs"]
[{"$f":"Feed!A86","v":"Sunflower, Full Fat"},{"$f":"Feed!I86","v":0},"lbs"]
[{"$f":"Feed!A87","v":"Sunflower Meal, Solvent Extracted"},{"$f":"Feed!I87","v":0},"lbs"]
[{"$f":"Feed!A88","v":"Sunflower Meal, Dehulled, Solvent Extr"},{"$f":"Feed!I88","v":0},"lbs"]
[{"$f":"Feed!A89","v":"Triticale"},{"$f":"Feed!I89","v":0},"lbs"]
[{"$f":"Feed!A90","v":"Wheat, Hard Red"},{"$f":"Feed!I90","v":0},"lbs"]
[{"$f":"Feed!A91","v":"Wheat, Soft Red"},{"$f":"Feed!I91","v":0},"lbs"]
[{"$f":"Feed!A92","v":"Wheat Bran"},{"$f":"Feed!I92","v":0},"lbs"]
[{"$f":"Feed!A93","v":"Wheat Middlings"},{"$f":"Feed!I93","v":0},"lbs"]
[{"$f":"Feed!A94","v":"Wheat Shorts"},{"$f":"Feed!I94","v":0},"lbs"]
[{"$f":"Feed!A95","v":"Wheat DDGS"},{"$f":"Feed!I95","v":0},"lbs"]
[{"$f":"Feed!A96","v":"Yeast, Brewers' Yeast"},{"$f":"Feed!I96","v":0},"lbs"]
[{"$f":"Feed!A97","v":"Yeast, Single Cell Protein"},{"$f":"Feed!I97","v":0},"lbs"]
[{"$f":"Feed!A98","v":"Beef Tallow"},{"$f":"Feed!I98","v":0},"lbs"]
[{"$f":"Feed!A99","v":"Choice White Grease"},{"$f":"Feed!I99","v":0},"lbs"]
[{"$f":"Feed!A100","v":"Poultry Fat"},{"$f":"Feed!I100","v":0},"lbs"]
[{"$f":"Feed!A101","v":"Lard"},{"$f":"Feed!I101","v":0},"lbs"]
[{"$f":"Feed!A102","v":"Restaurant Grease"},{"$f":"Feed!I102","v":0},"lbs"]
[{"$f":"Feed!A103","v":"Canola oil"},{"$f":"Feed!I103","v":0},"lbs"]
[{"$f":"Feed!A104","v":"Coconut oil"},{"$f":"Feed!I104","v":0},"lbs"]
[{"$f":"Feed!A105","v":"Corn oil"},{"$f":"Feed!I105","v":0},"lbs"]
[{"$f":"Feed!A106","v":"Palm Kernel oil"},{"$f":"Feed!I106","v":0},"lbs"]
[{"$f":"Feed!A107","v":"Soybean oil"},{"$f":"Feed!I107","v":0},"lbs"]
[{"$f":"Feed!A108","v":"Soybean Lecithin"},{"$f":"Feed!I108","v":0},"lbs"]
[{"$f":"Feed!A109","v":"Sunflower oil"},{"$f":"Feed!I109","v":0},"lbs"]
[{"$f":"Feed!A110","v":"Fat, A/V blend"},{"$f":"Feed!I110","v":0},"lbs"]
[{"$f":"Feed!A111","v":"Calcium carbonate"},{"$f":"Feed!I111","v":0},"lbs"]
[{"$f":"Feed!A112","v":"Calcium phosphate (tricalcium)"},{"$f":"Feed!I112","v":0},"lbs"]
[{"$f":"Feed!A113","v":"Calcium phosphate (dicalcium)"},{"$f":"Feed!I113","v":0},"lbs"]
[{"$f":"Feed!A114","v":"Calcium phosphate (monocalcium)"},{"$f":"Feed!I114","v":2.8685331056101093},"lbs"]
[{"$f":"Feed!A115","v":"Calcium sulfate, dihydrate"},{"$f":"Feed!I115","v":0},"lbs"]
[{"$f":"Feed!A116","v":"Limestone, ground"},{"$f":"Feed!I116","v":5.8857920000000004},"lbs"]
[{"$f":"Feed!A117","v":"Magnesium phosphate"},{"$f":"Feed!I117","v":0},"lbs"]
[{"$f":"Feed!A118","v":"Sodium carbonate"},{"$f":"Feed!I118","v":0},"lbs"]
[{"$f":"Feed!A119","v":"Sodium bicarbonate"},{"$f":"Feed!I119","v":0},"lbs"]
[{"$f":"Feed!A120","v":"Sodium chloride"},{"$f":"Feed!I120","v":3.2094400000000003},"lbs"]
[{"$f":"Feed!A121","v":"Sodium phosphate, monobasic"},{"$f":"Feed!I121","v":0},"lbs"]
[{"$f":"Feed!A122","v":"Sodium sulfate, decahydrate"},{"$f":"Feed!I122","v":0},"lbs"]
[{"$f":"Feed!A123","v":"L-Lys-HCL"},{"$f":"Feed!I123","v":1.9751840000000003},"lbs"]
[{"$f":"Feed!A124","v":"DL-Met"},{"$f":"Feed!I124","v":0.17390363353407723},"lbs"]
[{"$f":"Feed!A125","v":"L-Thr"},{"$f":"Feed!I125","v":0.52514118585757252},"lbs"]
[{"$f":"Feed!A126","v":"L-Trp"},{"$f":"Feed!I126","v":6.8292703566466009E-2},"lbs"]
[{"$f":"Feed!A127","v":"L-Val"},{"$f":"Feed!I127","v":0},"lbs"]
[{"$f":"Feed!A128","v":"L-Ileu"},{"$f":"Feed!I128","v":0},"lbs"]
[{"$f":"Feed!A129","v":"Methionine hydroxy analog"},{"$f":"Feed!I129","v":0},"lbs"]
[{"$f":"Feed!A130","v":"Glutamine"},{"$f":"Feed!I130","v":0},"lbs"]
[{"$f":"Feed!A131","v":"Glutamic acid"},{"$f":"Feed!I131","v":0},"lbs"]
[{"$f":"Feed!A132","v":"Biolys"},{"$f":"Feed!I132","v":0},"lbs"]
[{"$f":"Feed!A133","v":"Liquid lysine 60%"},{"$f":"Feed!I133","v":0},"lbs"]
[{"$f":"Feed!A134","v":"MHA dry"},{"$f":"Feed!I134","v":0},"lbs"]
[{"$f":"Feed!A135","v":"Ractopamine 9 g/lb"},{"$f":"Feed!I135","v":0},"lbs"]
[{"$f":"Feed!A136","v":"Phase 2 supplement (PEP2)"},{"$f":"Feed!I136","v":0},"lbs"]
[{"$f":"Feed!A137","v":"2007 Starter base mix"},{"$f":"Feed!I137","v":0},"lbs"]
[{"$f":"Feed!A138","v":"2007 Grow-finish base mix"},{"$f":"Feed!I138","v":0},"lbs"]
[{"$f":"Feed!A139","v":"Developer base mix"},{"$f":"Feed!I139","v":0},"lbs"]
[{"$f":"Feed!A140","v":"2007 Sow base mix"},{"$f":"Feed!I140","v":0},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!I141","v":0.81289807063738451},"lbs"]
[{"$f":"Feed!A142","v":"Trace mineral premix"},{"$f":"Feed!I142","v":0.7693780706373845},"lbs"]
[{"$f":"Feed!A143","v":"Sow add pack"},{"$f":"Feed!I143","v":0},"lbs"]
[{"$f":"Feed!A144","v":"Vitamin premix without phytase"},{"$f":"Feed!I144","v":0},"lbs"]
[{"$f":"Feed!A145","v":"GF DDGS Base Mix"},{"$f":"Feed!I145","v":0},"lbs"]
[{"$f":"Feed!A146","v":"GF synthetics Base Mix"},{"$f":"Feed!I146","v":0},"lbs"]
[{"$f":"Feed!A147","v":"Choline chloride 60%"},{"$f":"Feed!I147","v":0},"lbs"]
[{"$f":"Feed!A148","v":"Natuphos 600"},{"$f":"Feed!I148","v":0},"lbs"]
[{"$f":"Feed!A149","v":"Natuphos 1200"},{"$f":"Feed!I149","v":0},"lbs"]
[{"$f":"Feed!A150","v":"Optiphos 2000"},{"$f":"Feed!I150","v":0},"lbs"]
[{"$f":"Feed!A151","v":"Phyzyme 1200"},{"$f":"Feed!I151","v":0},"lbs"]
[{"$f":"Feed!A152","v":"Phyzyme 5000"},{"$f":"Feed!I152","v":0},"lbs"]
[{"$f":"Feed!A153","v":"Ronozyme CT (10,000)"},{"$f":"Feed!I153","v":0},"lbs"]
[{"$f":"Feed!A154","v":"Ronozyme M (50,000)"},{"$f":"Feed!I154","v":0},"lbs"]
[{"$f":"Feed!A155","v":"Ronozyme PMX PLT (4625 FYT/g)"},{"$f":"Feed!I155","v":5.7856068481511556E-2},"lbs"]
[{"$f":"Feed!A156","v":"Zinc oxide"},{"$f":"Feed!I156","v":0},"lbs"]
[{"$f":"Feed!A157","v":"Copper sulfate"},{"$f":"Feed!I157","v":0},"lbs"]
[{"$f":"Feed!A158","v":"Potassium chloride"},{"$f":"Feed!I158","v":0},"lbs"]
[{"$f":"Feed!A159","v":"Calcium chloride"},{"$f":"Feed!I159","v":0},"lbs"]
[{"$f":"Feed!A160","v":"Acidifier"},{"$f":"Feed!I160","v":0},"lbs"]
[{"$f":"Feed!A161","v":"Vitamin E, 20,000 IU"},{"$f":"Feed!I161","v":0},"lbs"]
[{"$f":"Feed!A162","v":"Phase 2 supplement D"},{"$f":"Feed!I162","v":0},"lbs"]
[{"$f":"Feed!A163","v":"DPS 50"},{"$f":"Feed!I163","v":0},"lbs"]
[{"$f":"Feed!A164","v":"PEP2+"},{"$f":"Feed!I164","v":0},"lbs"]
[{"$f":"Feed!A165","v":"PEP NS"},{"$f":"Feed!I165","v":0},"lbs"]
[{"$f":"Feed!A166","v":"Natural vitamin E 20,000 IU/lb"},{"$f":"Feed!I166","v":0},"lbs"]
[{"$f":"Feed!A167","v":"Other ingredient"},{"$f":"Feed!I167","v":0},"lbs"]
[{"$f":"Feed!A168","v":"Corn DDGS, 10.5% Oil"},{"$f":"Feed!I168","v":0},"lbs"]
[{"$f":"Feed!A169","v":"Corn DDGS, 7.5% Oil"},{"$f":"Feed!I169","v":5.5519999999999996},"lbs"]
[{"$f":"Feed!A170","v":"Corn DDGS, 4.5% Oil"},{"$f":"Feed!I170","v":0},"lbs"]
[{"$f":"Feed!A171","v":"Denegard"},{"$f":"Feed!I171","v":2.1000000000000001E-2},"lbs"]
[{"$f":"Feed!A172","v":"CTC 50"},{"$f":"Feed!I172","v":4.8000000000000001E-2},"lbs"]
[{"$f":"Feed!A173","v":"Bentonite"},{"$f":"Feed!I173","v":0},"lbs"]
[{"$f":"Feed!A174","v":"Phase 2 supplement (Feb, 2014)"},{"$f":"Feed!I174","v":2.1},"lbs"]
[{"$f":"Feed!A175","v":"Other ingredient"},{"$f":"Feed!I175","v":0}]
[{"$f":"Feed!A176","v":"Other ingredient"},{"$f":"Feed!I176","v":0}]
[{"$f":"Feed!A177","v":"Other ingredient"},{"$f":"Feed!I177","v":0}]
[{"$f":"Feed!A178","v":"Other ingredient"},{"$f":"Feed!I178","v":0}]
[{"$f":"Feed!A179","v":"Other ingredient"},{"$f":"Feed!I179","v":0}]
[{"$f":"Feed!A180","v":"Other ingredient"},{"$f":"Feed!I180","v":0}]
[{"$f":"Feed!A181","v":"Other ingredient"},{"$f":"Feed!I181","v":0}]
[{"$f":"Feed!A182","v":"Other ingredient"},{"$f":"Feed!I182","v":0}]
[{"$f":"Feed!A183","v":"Other ingredient"},{"$f":"Feed!I183","v":0}]
[{"$f":"Feed!A184","v":"Other ingredient"},{"$f":"Feed!I184","v":0}]
[{"$f":"Feed!A185","v":"Other ingredient"},{"$f":"Feed!I185","v":0}]
[{"$f":"Feed!A186","v":"Other ingredient"},{"$f":"Feed!I186","v":0}]
[]
["Wean-Finish Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
[{"$f":"Prices!A14","v":"Market Hogs ($/cwt)"},{"$f":"Prices!B14","v":44.75},{"$f":"Prices!D14","v":46.082000000000001},null,{"$f":"Prices!G14","v":58.48}]
[{"$f":"Prices!A15","v":"Weaned Pig ($/hd)"},{"$f":"Prices!B15","v":43.23},{"$f":"Prices!D15","v":53.152019889999991},null,{"$f":"Prices!G15","v":57.988702099999998}]
[{"$f":"Prices!A30","v":"Swine Feed processing ($/ton) charge"},{"$f":"Prices!B30","v":17},{"$f":"Prices!D30","v":17},null,{"$f":"Prices!G30","v":17}]
["Nursery Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$J$23:$J$174,Prices!$B$40:$B$191)/Feed!J189","v":7.1457484890611336E-2},{"$f":"SUMPRODUCT(Feed!$J$23:$J$174,Prices!$D$40:$D$191)/Feed!J189","v":7.217205973951743E-2},null,{"$f":"SUMPRODUCT(Feed!$J$23:$J$174,Prices!$G$40:$G$191)/Feed!J189","v":7.2886634588423538E-2}]
["Grow-Finish Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$K$23:$K$174,Prices!$B$40:$B$191)/Feed!K189","v":3.0420663579853464E-2},{"$f":"SUMPRODUCT(Feed!$K$23:$K$174,Prices!$D$40:$D$191)/Feed!K189","v":3.0724870215651998E-2},null,{"$f":"SUMPRODUCT(Feed!$K$23:$K$174,Prices!$G$40:$G$191)/Feed!K189","v":3.1029076851450527E-2}]
[{"$f":"Prices!A31","v":"Corn ($/bu)"},{"$f":"Prices!B31","v":4.25},{"$f":"Prices!D31","v":4.18},null,{"$f":"Prices!G31","v":3.55}]
[{"$f":"Prices!A32","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B32","v":380},{"$f":"Prices!D32","v":334.59999999999997},null,{"$f":"Prices!G32","v":341}]
[{"$f":"Prices!A33","v":"DDGS ($/ton)"},{"$f":"Prices!B33","v":210},{"$f":"Prices!D33","v":206.5411764705882},null,{"$f":"Prices!G33","v":175.41176470588235}]
["Other Feed Ingredients",{"$f":"Prices!B36","v":0.29337424167505716},{"$f":"Prices!D36","v":0.29630798409180775},null,{"$f":"Prices!G36","v":0.29924172650855829}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A83","v":"Publication: AM-FMG-WeanFin"},null,null,null,null,null,null,null,{"$f":"I83","v":"Version- 12.7.2020"}]

{"sheet":"Nursery","index":6,"n_rows":269,"n_cols":12,"rows_kept":269,"cut":false,"hidden":false,"merged":[[87,0,87,2],[255,2,255,3],[255,4,255,5],[82,8,82,9],[268,8,268,9],[267,0,267,8],[81,0,81,8],[84,0,84,1],[84,2,84,5],[84,6,84,8],[0,0,0,1],[0,2,0,5],[0,6,0,9],[37,0,37,8],[40,0,40,5],[40,6,40,8],[38,8,38,9]]}
[" KSU Nursery Swine Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,"INTERNAL NOTES","Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information"]
["Nursery Mortality (%)",4.7699999999999996,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Feed to Gain Conversion",{"$f":"'Farrow-Finish'!J6","v":1.54},null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Entry Weight (lbs)",{"$f":"'Farrow-Finish'!J8","v":14},null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Exit Weight (lbs)",{"$f":"'Farrow-Finish'!J9","v":52},null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Pig Sold"]
["Feeder Pigs",{"$f":"IF($C$1=Prices!$A$1, Prices!B16, IF($C$1=Prices!$A$2, Prices!D16, IF($C$1=Prices!$A$3, Prices!G16, \"\")))","v":54.43},"per hd"," x",{"$f":"B7","v":52},"lbs"," x",{"$f":"1-B4/100","v":0.95230000000000004}," =",{"$f":"B10*H10","v":51.833689},"50.9 lbs is from NPB/Stadler 2014 report table 4"]
["Less cost of Weaned Pigs",{"$f":"IF($C$1=Prices!$A$1, Prices!B15, IF($C$1=Prices!$A$2, Prices!D15, IF($C$1=Prices!$A$3, Prices!G15, \"\")))","v":43.23},"per hd"," x",1,"hd",null,null," =",{"$f":"-1*(B11)*E11","v":-43.23}]
["Manure Credit",null,null,null,null,null,null,null,null,{"$f":"'Wean-Finish'!J11-Finishing!J12","v":0.5},"Per April KSU team meeting; also note ERS COP places $4.44/cwt gain ($1.70/pig) so we are conservative"]
["Other revenue",null,null,null,null,null,null,null,null,0]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J13)","v":9.1036890000000028}]
[]
["Variable Costs"]
["Nursery Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$J$23:$J$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$J$23:$J$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$J$23:$J$188,Prices!$G$41:$G$206), \"\")))/Feed!J189","v":0.15909744926779315},"per lb"," x",{"$f":"IF(B5=1.54,(((B7-55)*0.011+B5)*(B7-B6)),(B5*(B7-B6)))","v":57.266000000000005},"lbs",null,null," =",{"$f":"(B17*E17)","v":9.1108745297694433},"Worked from April 2015 KSU XL Ration, collapsing down to #s by phase here w/ details in Feed tab and notes below; Also scaling feed lbs given changes to Feed Conversion; Can cross-check w/ ERS COP data also.  Schulz' 3/31/15 values are $80.51/pig"]
["Feed Processing",{"$f":"IF($C$1=Prices!$A$1, Prices!B30, IF($C$1=Prices!$A$2, Prices!D30, IF($C$1=Prices!$A$3,Prices!G30, \"\")))","v":17},"per ton"," x",{"$f":"SUM(E17:E17)/2000","v":2.8633000000000002E-2},"ton",null,null," =",{"$f":"B18*E18","v":0.48676100000000005}]
["Labor",15,"per hour","x",0.2,"hours",null,null," =",{"$f":"B19*E19","v":3},"Note: Using Schulz's 3/31/15 Iowa St. values (http://www.extension.iastate.edu/agdm/livestock/pdf/b1-21.pdf) of 0.7 hrs/pig for wean-fin & Stadler has 19% (45) of days in Nursery of 165 wean-finish."]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"4.64*(($B$7-$B$6)/100)","v":1.7631999999999999},"Note: Using ERS $2.69/cwt produced value"]
["Marketing, Bedding, and Misc",null,null,null,null,null,null,null,null,{"$f":"(0.16+0.01+0.3)*(($B$7-$B$6)/100)","v":0.17859999999999998},"Note: Using ERS $0.35/cwt produced value (Bed&Litter, Mkt,Custom Srv). "]
["Utilities, Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"1.98*(($B$7-$B$6)/100)","v":0.75239999999999996},"Note: Using ERS $3.36/cwt produced values "]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"1.3*(($B$7-$B$6)/100)","v":0.49400000000000005},"Note: Using ERS $1.24/cwt produced value"]
["Other variable costs",null,null,null,null,null,null,null,null,0]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J17:J24)","v":15.785835529769441}]
[]
["Fixed Costs"]
["Machinery, Facilities, General Overhead",null,null,null,null,null,null,null,null,{"$f":"(13.4+1.85)*(($B$7-$B$6)/100)","v":5.7949999999999999},"Note: Using ERS $9.74/cwt produced value for capital recovery  of mach. & equipment + $2.35/cwt prod for general farm overhead"]
["Taxes and Insurance",null,null,null,null,null,null,null,null,{"$f":"0.88*(($B$7-$B$6)/100)","v":0.33440000000000003},"Note: Using ERS $1.08/cwt produced value"]
["Legal, Accounting, etc.",null,null,null,null,null,null,null,null,0.5,"no source"]
["Other fixed costs",null,null,null,null,null,null,null,null,0]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J28:J31)","v":6.6294000000000004}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J25+J32","v":22.41523552976944}]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J14-J25","v":-6.6821465297694385}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J14-J34","v":-13.311546529769437}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Nursery",null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 12.7.2020"}]
[]
[{"$f":"A1","v":" KSU Nursery Swine Budget"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A39","v":"Publication: AM-FMG-Nursery"},null,null,null,null,null,null,null,{"$f":"I39","v":"Version- 12.7.2020"}]
[]
[{"$f":"A41","v":" KSU Nursery Swine Budget"}]
["Budget Assumptions"]
[]
["Feed Ration"]
["Ingredient","Qty","Unit"]
[{"$f":"Feed!A23","v":"Corn, Yellow Dent"},{"$f":"Feed!E23","v":29.327382607751133},"lbs"]
[{"$f":"Feed!A24","v":"Corn, Nutridense"},{"$f":"Feed!E24","v":0},"lbs"]
[{"$f":"Feed!A25","v":"Corn Bran"},{"$f":"Feed!E25","v":0},"lbs"]
[{"$f":"Feed!A26","v":"Corn DDG"},{"$f":"Feed!E26","v":0},"lbs"]
[{"$f":"Feed!A27","v":"Corn DDGS, >10% Oil"},{"$f":"Feed!E27","v":0},"lbs"]
[{"$f":"Feed!A28","v":"Corn DDGS, >6 and <9% Oil"},{"$f":"Feed!E28","v":0},"lbs"]
[{"$f":"Feed!A29","v":"Corn DDGS, <4% Oil"},{"$f":"Feed!E29","v":0},"lbs"]
[{"$f":"Feed!A30","v":"Corn HP DDG"},{"$f":"Feed!E30","v":0},"lbs"]
[{"$f":"Feed!A31","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!E31","v":0},"lbs"]
[{"$f":"Feed!A32","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!E32","v":0},"lbs"]
[{"$f":"Feed!A33","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!E33","v":0},"lbs"]
[{"$f":"Feed!A34","v":"Corn Gluten Meal"},{"$f":"Feed!E34","v":0},"lbs"]
[{"$f":"Feed!A35","v":"Corn Grits, Hominy Feed"},{"$f":"Feed!E35","v":0},"lbs"]
[{"$f":"Feed!A36","v":"Cotton Seeds, Fullfat"},{"$f":"Feed!E36","v":0},"lbs"]
[{"$f":"Feed!A37","v":"Cotton Seed Meal"},{"$f":"Feed!E37","v":0},"lbs"]
[{"$f":"Feed!A38","v":"Feather Meal"},{"$f":"Feed!E38","v":0},"lbs"]
[{"$f":"Feed!A39","v":"Fish Meal Combined"},{"$f":"Feed!E39","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!E41","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!E41","v":0},"lbs"]
[{"$f":"Feed!A42","v":"Lupins"},{"$f":"Feed!E42","v":0},"lbs"]
[{"$f":"Feed!A43","v":"Meat Meal"},{"$f":"Feed!E43","v":0},"lbs"]
[{"$f":"Feed!A44","v":"Meat and Bone Meal, P >4%"},{"$f":"Feed!E44","v":0},"lbs"]
[{"$f":"Feed!A45","v":"Milk, Casein"},{"$f":"Feed!E45","v":0},"lbs"]
[{"$f":"Feed!A46","v":"Milk, Lactose"},{"$f":"Feed!E46","v":0},"lbs"]
[{"$f":"Feed!A47","v":"Milk, Skim Milk Powder"},{"$f":"Feed!E47","v":0},"lbs"]
[{"$f":"Feed!A48","v":"Milk, Whey Powder"},{"$f":"Feed!E48","v":0},"lbs"]
[{"$f":"Feed!A49","v":"Milk, Whey Permeate, 85% lactose"},{"$f":"Feed!E49","v":0},"lbs"]
[{"$f":"Feed!A50","v":"Milk, Whey Protein Concentrate"},{"$f":"Feed!E50","v":0},"lbs"]
[{"$f":"Feed!A51","v":"Millet"},{"$f":"Feed!E51","v":0},"lbs"]
[{"$f":"Feed!A52","v":"Molasses, Sugarbeet"},{"$f":"Feed!E52","v":0},"lbs"]
[{"$f":"Feed!A53","v":"Molasses, Sugarcane"},{"$f":"Feed!E53","v":0},"lbs"]
[{"$f":"Feed!A54","v":"Oats"},{"$f":"Feed!E54","v":0},"lbs"]
[{"$f":"Feed!A55","v":"Oats, Naked"},{"$f":"Feed!E55","v":0},"lbs"]
[{"$f":"Feed!A56","v":"Oat Groats"},{"$f":"Feed!E56","v":0},"lbs"]
[{"$f":"Feed!A57","v":"Peanut Meal, Expelled"},{"$f":"Feed!E57","v":0},"lbs"]
[{"$f":"Feed!A58","v":"Peanut Meal, Extracted"},{"$f":"Feed!E58","v":0},"lbs"]
[{"$f":"Feed!A59","v":"Peas, Field Peas"},{"$f":"Feed!E59","v":0},"lbs"]
[{"$f":"Feed!A60","v":"Pea Protein Concentrate"},{"$f":"Feed!E60","v":0},"lbs"]
[{"$f":"Feed!A61","v":"Potato Protein Concentrate"},{"$f":"Feed!E61","v":0},"lbs"]
[{"$f":"Feed!A62","v":"Poultry Byproduct"},{"$f":"Feed!E62","v":0},"lbs"]
[{"$f":"Feed!A63","v":"Rice"},{"$f":"Feed!E63","v":0},"lbs"]
[{"$f":"Feed!A64","v":"Rice Bran"},{"$f":"Feed!E64","v":0},"lbs"]
[{"$f":"Feed!A65","v":"Rice Bran, Defatted"},{"$f":"Feed!E65","v":0},"lbs"]
[{"$f":"Feed!A66","v":"Rice, Broken"},{"$f":"Feed!E66","v":0},"lbs"]
[{"$f":"Feed!A67","v":"Rye"},{"$f":"Feed!E67","v":0},"lbs"]
[{"$f":"Feed!A68","v":"Sesame Meal"},{"$f":"Feed!E68","v":0},"lbs"]
[{"$f":"Feed!A69","v":"Sorghum"},{"$f":"Feed!E69","v":0},"lbs"]
[{"$f":"Feed!A70","v":"Soybeans, Full Fat"},{"$f":"Feed!E70","v":0},"lbs"]
[{"$f":"Feed!A71","v":"Soybeans, High Protein, Full Fat"},{"$f":"Feed!E71","v":0},"lbs"]
[{"$f":"Feed!A72","v":"Soybeans, Low Oligosaccharide, Full Fat"},{"$f":"Feed!E72","v":0},"lbs"]
[{"$f":"Feed!A73","v":"Soybean Meal, High Protein, Expelled"},{"$f":"Feed!E73","v":0},"lbs"]
[{"$f":"Feed!A74","v":"Soybean Meal, Low Oligosacch, Expell"},{"$f":"Feed!E74","v":0},"lbs"]
[{"$f":"Feed!A75","v":"Soybean Meal, Expelled"},{"$f":"Feed!E75","v":0},"lbs"]
[{"$f":"Feed!A76","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!E76","v":0},"lbs"]
[{"$f":"Feed!A77","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!E77","v":0},"lbs"]
[{"$f":"Feed!A78","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!E78","v":16.966353392248866},"lbs"]
[{"$f":"Feed!A79","v":"Soybean Meal, High Prot, Dehull, Solv Extr"},{"$f":"Feed!E79","v":0},"lbs"]
[{"$f":"Feed!A80","v":"Soybean Meal, Enzyme Treated"},{"$f":"Feed!E80","v":0},"lbs"]
[{"$f":"Feed!A81","v":"Soybean Meal, Fermented"},{"$f":"Feed!E81","v":0},"lbs"]
[{"$f":"Feed!A82","v":"Soybean Hulls"},{"$f":"Feed!E82","v":0},"lbs"]
[{"$f":"Feed!A83","v":"Soy Protein Concentrate"},{"$f":"Feed!E83","v":0},"lbs"]
[{"$f":"Feed!A84","v":"Soy Protein Isolate"},{"$f":"Feed!E84","v":0},"lbs"]
[{"$f":"Feed!A85","v":"Sugar Beet Pulp"},{"$f":"Feed!E85","v":0},"lbs"]
[{"$f":"Feed!A86","v":"Sunflower, Full Fat"},{"$f":"Feed!E86","v":0},"lbs"]
[{"$f":"Feed!A87","v":"Sunflower Meal, Solvent Extracted"},{"$f":"Feed!E87","v":0},"lbs"]
[{"$f":"Feed!A88","v":"Sunflower Meal, Dehulled, Solvent Extr"},{"$f":"Feed!E88","v":0},"lbs"]
[{"$f":"Feed!A89","v":"Triticale"},{"$f":"Feed!E89","v":0},"lbs"]
[{"$f":"Feed!A90","v":"Wheat, Hard Red"},{"$f":"Feed!E90","v":0},"lbs"]
[{"$f":"Feed!A91","v":"Wheat, Soft Red"},{"$f":"Feed!E91","v":0},"lbs"]
[{"$f":"Feed!A92","v":"Wheat Bran"},{"$f":"Feed!E92","v":0},"lbs"]
[{"$f":"Feed!A93","v":"Wheat Middlings"},{"$f":"Feed!E93","v":0},"lbs"]
[{"$f":"Feed!A94","v":"Wheat Shorts"},{"$f":"Feed!E94","v":0},"lbs"]
[{"$f":"Feed!A95","v":"Wheat DDGS"},{"$f":"Feed!E95","v":0},"lbs"]
[{"$f":"Feed!A96","v":"Yeast, Brewers' Yeast"},{"$f":"Feed!E96","v":0},"lbs"]
[{"$f":"Feed!A97","v":"Yeast, Single Cell Protein"},{"$f":"Feed!E97","v":0},"lbs"]
[{"$f":"Feed!A98","v":"Beef Tallow"},{"$f":"Feed!E98","v":0},"lbs"]
[{"$f":"Feed!A99","v":"Choice White Grease"},{"$f":"Feed!E99","v":0},"lbs"]
[{"$f":"Feed!A100","v":"Poultry Fat"},{"$f":"Feed!E100","v":0},"lbs"]
[{"$f":"Feed!A101","v":"Lard"},{"$f":"Feed!E101","v":0},"lbs"]
[{"$f":"Feed!A102","v":"Restaurant Grease"},{"$f":"Feed!E102","v":0},"lbs"]
[{"$f":"Feed!A103","v":"Canola oil"},{"$f":"Feed!E103","v":0},"lbs"]
[{"$f":"Feed!A104","v":"Coconut oil"},{"$f":"Feed!E104","v":0},"lbs"]
[{"$f":"Feed!A105","v":"Corn oil"},{"$f":"Feed!E105","v":0},"lbs"]
[{"$f":"Feed!A106","v":"Palm Kernel oil"},{"$f":"Feed!E106","v":0},"lbs"]
[{"$f":"Feed!A107","v":"Soybean oil"},{"$f":"Feed!E107","v":0},"lbs"]
[{"$f":"Feed!A108","v":"Soybean Lecithin"},{"$f":"Feed!E108","v":0},"lbs"]
[{"$f":"Feed!A109","v":"Sunflower oil"},{"$f":"Feed!E109","v":0},"lbs"]
[{"$f":"Feed!A110","v":"Fat, A/V blend"},{"$f":"Feed!E110","v":0},"lbs"]
[{"$f":"Feed!A111","v":"Calcium carbonate"},{"$f":"Feed!E111","v":0},"lbs"]
[{"$f":"Feed!A112","v":"Calcium phosphate (tricalcium)"},{"$f":"Feed!E112","v":0},"lbs"]
[{"$f":"Feed!A113","v":"Calcium phosphate (dicalcium)"},{"$f":"Feed!E113","v":0},"lbs"]
[{"$f":"Feed!A114","v":"Calcium phosphate (monocalcium)"},{"$f":"Feed!E114","v":0.34816000000000003},"lbs"]
[{"$f":"Feed!A115","v":"Calcium sulfate, dihydrate"},{"$f":"Feed!E115","v":0},"lbs"]
[{"$f":"Feed!A116","v":"Limestone, ground"},{"$f":"Feed!E116","v":0.50048000000000004},"lbs"]
[{"$f":"Feed!A117","v":"Magnesium phosphate"},{"$f":"Feed!E117","v":0},"lbs"]
[{"$f":"Feed!A118","v":"Sodium carbonate"},{"$f":"Feed!E118","v":0},"lbs"]
[{"$f":"Feed!A119","v":"Sodium bicarbonate"},{"$f":"Feed!E119","v":0},"lbs"]
[{"$f":"Feed!A120","v":"Sodium chloride"},{"$f":"Feed!E120","v":0.21760000000000002},"lbs"]
[{"$f":"Feed!A121","v":"Sodium phosphate, monobasic"},{"$f":"Feed!E121","v":0},"lbs"]
[{"$f":"Feed!A122","v":"Sodium sulfate, decahydrate"},{"$f":"Feed!E122","v":0},"lbs"]
[{"$f":"Feed!A123","v":"L-Lys-HCL"},{"$f":"Feed!E123","v":0.18008000000000002},"lbs"]
[{"$f":"Feed!A124","v":"DL-Met"},{"$f":"Feed!E124","v":3.6992000000000004E-2},"lbs"]
[{"$f":"Feed!A125","v":"L-Thr"},{"$f":"Feed!E125","v":4.7872000000000005E-2},"lbs"]
[{"$f":"Feed!A126","v":"L-Trp"},{"$f":"Feed!E126","v":0},"lbs"]
[{"$f":"Feed!A127","v":"L-Val"},{"$f":"Feed!E127","v":0},"lbs"]
[{"$f":"Feed!A128","v":"L-Ileu"},{"$f":"Feed!E128","v":0},"lbs"]
[{"$f":"Feed!A129","v":"Methionine hydroxy analog"},{"$f":"Feed!E129","v":0},"lbs"]
[{"$f":"Feed!A130","v":"Glutamine"},{"$f":"Feed!E130","v":0},"lbs"]
[{"$f":"Feed!A131","v":"Glutamic acid"},{"$f":"Feed!E131","v":0},"lbs"]
[{"$f":"Feed!A132","v":"Biolys"},{"$f":"Feed!E132","v":0},"lbs"]
[{"$f":"Feed!A133","v":"Liquid lysine 60%"},{"$f":"Feed!E133","v":0},"lbs"]
[{"$f":"Feed!A134","v":"MHA dry"},{"$f":"Feed!E134","v":0},"lbs"]
[{"$f":"Feed!A135","v":"Ractopamine 9 g/lb"},{"$f":"Feed!E135","v":0},"lbs"]
[{"$f":"Feed!A136","v":"Phase 2 supplement (PEP2)"},{"$f":"Feed!E136","v":0},"lbs"]
[{"$f":"Feed!A137","v":"2007 Starter base mix"},{"$f":"Feed!E137","v":0},"lbs"]
[{"$f":"Feed!A138","v":"2007 Grow-finish base mix"},{"$f":"Feed!E138","v":0},"lbs"]
[{"$f":"Feed!A139","v":"Developer base mix"},{"$f":"Feed!E139","v":0},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!E141","v":0.10880000000000001},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!E141","v":0.10880000000000001},"lbs"]
[{"$f":"Feed!A142","v":"Trace mineral premix"},{"$f":"Feed!E142","v":6.5280000000000005E-2},"lbs"]
[{"$f":"Feed!A143","v":"Sow add pack"},{"$f":"Feed!E143","v":0},"lbs"]
[{"$f":"Feed!A144","v":"Vitamin premix without phytase"},{"$f":"Feed!E144","v":0},"lbs"]
[{"$f":"Feed!A145","v":"GF DDGS Base Mix"},{"$f":"Feed!E145","v":0},"lbs"]
[{"$f":"Feed!A146","v":"GF synthetics Base Mix"},{"$f":"Feed!E146","v":0},"lbs"]
[{"$f":"Feed!A147","v":"Choline chloride 60%"},{"$f":"Feed!E147","v":0},"lbs"]
[{"$f":"Feed!A148","v":"Natuphos 600"},{"$f":"Feed!E148","v":0},"lbs"]
[{"$f":"Feed!A149","v":"Natuphos 1200"},{"$f":"Feed!E149","v":0},"lbs"]
[{"$f":"Feed!A150","v":"Optiphos 2000"},{"$f":"Feed!E150","v":0},"lbs"]
[{"$f":"Feed!A151","v":"Phyzyme 1200"},{"$f":"Feed!E151","v":0},"lbs"]
[{"$f":"Feed!A152","v":"Phyzyme 5000"},{"$f":"Feed!E152","v":0},"lbs"]
[{"$f":"Feed!A153","v":"Ronozyme CT (10,000)"},{"$f":"Feed!E153","v":0},"lbs"]
[{"$f":"Feed!A154","v":"Ronozyme M (50,000)"},{"$f":"Feed!E154","v":0},"lbs"]
[{"$f":"Feed!A155","v":"Ronozyme PMX PLT (4625 FYT/g)"},{"$f":"Feed!E155","v":0},"lbs"]
[{"$f":"Feed!A156","v":"Zinc oxide"},{"$f":"Feed!E156","v":0},"lbs"]
[{"$f":"Feed!A157","v":"Copper sulfate"},{"$f":"Feed!E157","v":0},"lbs"]
[{"$f":"Feed!A158","v":"Potassium chloride"},{"$f":"Feed!E158","v":0},"lbs"]
[{"$f":"Feed!A159","v":"Calcium chloride"},{"$f":"Feed!E159","v":0},"lbs"]
[{"$f":"Feed!A160","v":"Acidifier"},{"$f":"Feed!E160","v":0},"lbs"]
[{"$f":"Feed!A161","v":"Vitamin E, 20,000 IU"},{"$f":"Feed!E161","v":0},"lbs"]
[{"$f":"Feed!A162","v":"Phase 2 supplement D"},{"$f":"Feed!E162","v":0},"lbs"]
[{"$f":"Feed!A163","v":"DPS 50"},{"$f":"Feed!E163","v":0},"lbs"]
[{"$f":"Feed!A164","v":"PEP2+"},{"$f":"Feed!E164","v":0},"lbs"]
[{"$f":"Feed!A165","v":"PEP NS"},{"$f":"Feed!E165","v":0},"lbs"]
[{"$f":"Feed!A166","v":"Natural vitamin E 20,000 IU/lb"},{"$f":"Feed!E166","v":0},"lbs"]
[{"$f":"Feed!A167","v":"Other ingredient"},{"$f":"Feed!E167","v":0},"lbs"]
[{"$f":"Feed!A168","v":"Corn DDGS, 10.5% Oil"},{"$f":"Feed!E168","v":0},"lbs"]
[{"$f":"Feed!A169","v":"Corn DDGS, 7.5% Oil"},{"$f":"Feed!E169","v":5.5519999999999996},"lbs"]
[{"$f":"Feed!A170","v":"Corn DDGS, 4.5% Oil"},{"$f":"Feed!E170","v":0},"lbs"]
[{"$f":"Feed!A171","v":"Denegard"},{"$f":"Feed!E171","v":2.1000000000000001E-2},"lbs"]
[{"$f":"Feed!A172","v":"CTC 50"},{"$f":"Feed!E172","v":4.8000000000000001E-2},"lbs"]
[{"$f":"Feed!A173","v":"Bentonite"},{"$f":"Feed!E173","v":0},"lbs"]
[{"$f":"Feed!A188","v":"Complete nursery pellet"},{"$f":"Feed!E188","v":3},"lbs"]
[{"$f":"Feed!A175","v":"Other ingredient"},{"$f":"Feed!E175","v":0}]
[{"$f":"Feed!A176","v":"Other ingredient"},{"$f":"Feed!E176","v":0}]
[{"$f":"Feed!A177","v":"Other ingredient"},{"$f":"Feed!E177","v":0}]
[{"$f":"Feed!A178","v":"Other ingredient"},{"$f":"Feed!E178","v":0}]
[{"$f":"Feed!A179","v":"Other ingredient"},{"$f":"Feed!E179","v":0}]
[{"$f":"Feed!A180","v":"Other ingredient"},{"$f":"Feed!E180","v":0}]
[{"$f":"Feed!A181","v":"Other ingredient"},{"$f":"Feed!E181","v":0}]
[{"$f":"Feed!A182","v":"Other ingredient"},{"$f":"Feed!E182","v":0}]
[{"$f":"Feed!A183","v":"Other ingredient"},{"$f":"Feed!E183","v":0}]
[{"$f":"Feed!A184","v":"Other ingredient"},{"$f":"Feed!E184","v":0}]
[{"$f":"Feed!A185","v":"Other ingredient"},{"$f":"Feed!E185","v":0}]
[{"$f":"Feed!A186","v":"Other ingredient"},{"$f":"Feed!E186","v":0}]
[]
["Nursery Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
[{"$f":"Prices!A16","v":"Feeder Pig ($/hd)"},{"$f":"Prices!B16","v":54.43},{"$f":"Prices!D16","v":66.539911536000005},null,{"$f":"Prices!G16","v":84.194752539999996}]
[{"$f":"Prices!A15","v":"Weaned Pig ($/hd)"},{"$f":"Prices!B15","v":43.23},{"$f":"Prices!D15","v":53.152019889999991},null,{"$f":"Prices!G15","v":57.988702099999998}]
[{"$f":"Prices!A30","v":"Swine Feed processing ($/ton) charge"},{"$f":"Prices!B30","v":17},{"$f":"Prices!D30","v":17},null,{"$f":"Prices!G30","v":17}]
["Nursery Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$J$23:$J$188,Prices!$B$41:$B$206)/Feed!J189","v":0.15909744926779315},{"$f":"SUMPRODUCT(Feed!$J$23:$J$188,Prices!$D$41:$D$206)/Feed!J189","v":0.16068842376047107},null,{"$f":"SUMPRODUCT(Feed!$J$23:$J$188,Prices!$G$41:$G$206)/Feed!J189","v":0.16227939825314902}]
[{"$f":"Prices!A31","v":"Corn ($/bu)"},{"$f":"Prices!B31","v":4.25},{"$f":"Prices!D31","v":4.18},null,{"$f":"Prices!G31","v":3.55}]
[{"$f":"Prices!A32","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B32","v":380},{"$f":"Prices!D32","v":334.59999999999997},null,{"$f":"Prices!G32","v":341}]
[{"$f":"Prices!A33","v":"DDGS ($/ton)"},{"$f":"Prices!B33","v":210},{"$f":"Prices!D33","v":206.5411764705882},null,{"$f":"Prices!G33","v":175.41176470588235}]
["Other Feed Ingredients",{"$f":"Prices!B37","v":0.38740272553688754},{"$f":"Prices!D37","v":0.39127675279225643},null,{"$f":"Prices!G37","v":0.39515078004762527}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A83","v":"Publication: AM-FMG-Nursery"},null,null,null,null,null,null,null,{"$f":"I83","v":"Version- 12.7.2020"}]

{"sheet":"Finishing","index":7,"n_rows":269,"n_cols":12,"rows_kept":269,"cut":false,"hidden":false,"merged":[[87,0,87,2],[255,2,255,3],[255,4,255,5],[82,8,82,9],[268,8,268,9],[267,0,267,8],[81,0,81,8],[84,0,84,1],[84,2,84,5],[84,6,84,8],[0,0,0,1],[0,2,0,5],[0,6,0,9],[37,0,37,8],[40,0,40,5],[40,6,40,8],[38,8,38,9]]}
[" KSU Finishing Swine Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,"INTERNAL NOTES","Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information"]
["Finisher Mortality (%)",5.19,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Feed to Gain Conversion",2.71,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Entry Weight (lbs)",{"$f":"Nursery!B7","v":52},null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
["Exit Weight (lbs)",272.8,null,null,null,null,null,null,null,null,"production data from NPB/Stadler \"2014 U.S. Pork Industry Productivity Analysis\""]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Pig Sold"]
["Market Hogs",{"$f":"IF($C$1=Prices!$A$1, Prices!B14, IF($C$1=Prices!$A$2, Prices!D14, IF($C$1=Prices!$A$3, Prices!G14, \"\")))","v":44.75},"per cwt"," x",{"$f":"B7","v":272.8},"lbs"," x",{"$f":"1-B4/100","v":0.94809999999999994}," =",{"$f":"B10*(E10/100)*H10","v":115.7421518}]
["Less cost of Feeder Pigs",{"$f":"IF($C$1=Prices!$A$1, Prices!B16, IF($C$1=Prices!$A$2, Prices!D16, IF($C$1=Prices!$A$3, Prices!G16, \"\")))","v":54.43},"per hd",null,null,null,null,null," =",{"$f":"-1*B11","v":-54.43}]
["Manure Credit",null,null,null,null,null,null,null,null,5,"Per April KSU team meeting; also note ERS COP places $6.30/cwt gain ($15.70/pig) so we are conservative"]
["Other revenue",null,null,null,null,null,null,null,null,0]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J13)","v":66.312151800000009}]
[]
["Variable Costs"]
["Grow-Finish Feed",{"$f":"IF($C$1=Prices!$A$1, SUMPRODUCT(Feed!$K$23:$K$188,Prices!$B$41:$B$206), IF($C$1=Prices!$A$2, SUMPRODUCT(Feed!$K$23:$K$188,Prices!$D$41:$D$206), IF($C$1=Prices!$A$3,SUMPRODUCT(Feed!$K$23:$K$188,Prices!$G$41:$G$206), \"\")))/Feed!K189","v":0.10000813591761802},"per lb","x",{"$f":"IF(B5=2.71,(((E10-272.8)*0.005+B5)*(E10-B6)),(B5*(E10-B6)))","v":598.36800000000005},"lbs",null,null," =",{"$f":"(B17*E17)","v":59.841668272753267},"Worked from April 2015 KSU XL Ration, collapsing down to #s by phase here w/ details in Feed tab and notes below; Also scaling feed lbs given changes to Feed Conversion and Mkt Wt; Deriving adjusted F/G per Mike on May 6, 2015 to get updated lbs consumed. Schulz' 3/31/15 values are $67/pig"]
["Feed Processing",{"$f":"IF($C$1=Prices!$A$1, Prices!B30, IF($C$1=Prices!$A$2, Prices!D30, IF($C$1=Prices!$A$3,Prices!G30, \"\")))","v":17},"per ton","x",{"$f":"SUM(E17:E17)/2000","v":0.29918400000000001},"ton",null,null," =",{"$f":"B18*E18","v":5.0861280000000004}]
["Labor",15,"per hour","x",0.2,"hours",null,null," =",{"$f":"B19*E19","v":3},"Note: Using Schulz's 3/31/15 Iowa St. values (http://www.extension.iastate.edu/agdm/livestock/pdf/b1-21.pdf) of 0.2 hrs/pig"]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"1.87*(($B$7-$B$6)/100)","v":4.1289600000000002},"Note: Using ERS $1.19/cwt produced value"]
["Marketing, Bedding, and Misc",null,null,null,null,null,null,null,null,{"$f":"(0.01+0.05+0.19)*(($B$7-$B$6)/100)","v":0.55200000000000005},"Note: Using ERS $0.44/cwt produced value (Bed&Litter, Mkt,Custom Srv). "]
["Utilities, Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"1.41*(($B$7-$B$6)/100)","v":3.11328},"Note: Using ERS $1.27/cwt produced values "]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"0.85*(($B$7-$B$6)/100)","v":1.8768},"Note: Using ERS $0.58/cwt produced value"]
["Other variable costs",null,null,null,null,null,null,null,null,0]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J17:J24)","v":77.598836272753289},{"$f":"J25-J11","v":132.0288362727533}]
[]
["Fixed Costs"]
["Machinery, Facilities, General Overhead",null,null,null,null,null,null,null,null,{"$f":"(7.52+1.26)*(($B$7-$B$6)/100)","v":19.386240000000001},"Note: Using ERS $5.97/cwt produced value for capital recovery  of mach. & equipment + $0.79/cwt prod for general farm overhead"]
["Taxes and Insurance",null,null,null,null,null,null,null,null,{"$f":"0.8*(($B$7-$B$6)/100)","v":1.7664000000000002},"Note: Using ERS $0.41/cwt produced value"]
["Legal, Accounting, etc.",null,null,null,null,null,null,null,null,1,"no source"]
["Other fixed costs",null,null,null,null,null,null,null,null,0]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J28:J31)","v":22.152640000000002},"Compares to ERS COP data of $9.77/cwt produced (includes labor);"]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J25+J32","v":99.751476272753294},{"$f":"J34-J11","v":154.18147627275329}]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J14-J25","v":-11.286684472753279}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J14-J34","v":-33.439324472753285}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-FinishingSwine",null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 12.7.2020"}]
[]
[{"$f":"A1","v":" KSU Finishing Swine Budget"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A39","v":"Publication: AM-FMG-FinishingSwine"},null,null,null,null,null,null,null,{"$f":"I39","v":"Version- 12.7.2020"}]
[]
[{"$f":"A41","v":" KSU Finishing Swine Budget"}]
["Budget Assumptions"]
[]
["Feed Ration"]
["Ingredient","Qty","Unit"]
[{"$f":"Feed!A23","v":"Corn, Yellow Dent"},{"$f":"Feed!K23","v":483.50111636811255},"lbs"]
[{"$f":"Feed!A24","v":"Corn, Nutridense"},{"$f":"Feed!K24","v":0},"lbs"]
[{"$f":"Feed!A25","v":"Corn Bran"},{"$f":"Feed!K25","v":0},"lbs"]
[{"$f":"Feed!A26","v":"Corn DDG"},{"$f":"Feed!K26","v":0},"lbs"]
[{"$f":"Feed!A27","v":"Corn DDGS, >10% Oil"},{"$f":"Feed!K27","v":0},"lbs"]
[{"$f":"Feed!A28","v":"Corn DDGS, >6 and <9% Oil"},{"$f":"Feed!K28","v":0},"lbs"]
[{"$f":"Feed!A29","v":"Corn DDGS, <4% Oil"},{"$f":"Feed!K29","v":0},"lbs"]
[{"$f":"Feed!A30","v":"Corn HP DDG"},{"$f":"Feed!K30","v":0},"lbs"]
[{"$f":"Feed!A31","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!K31","v":0},"lbs"]
[{"$f":"Feed!A32","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!K32","v":0},"lbs"]
[{"$f":"Feed!A33","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!K33","v":0},"lbs"]
[{"$f":"Feed!A34","v":"Corn Gluten Meal"},{"$f":"Feed!K34","v":0},"lbs"]
[{"$f":"Feed!A35","v":"Corn Grits, Hominy Feed"},{"$f":"Feed!K35","v":0},"lbs"]
[{"$f":"Feed!A36","v":"Cotton Seeds, Fullfat"},{"$f":"Feed!K36","v":0},"lbs"]
[{"$f":"Feed!A37","v":"Cotton Seed Meal"},{"$f":"Feed!K37","v":0},"lbs"]
[{"$f":"Feed!A38","v":"Feather Meal"},{"$f":"Feed!K38","v":0},"lbs"]
[{"$f":"Feed!A39","v":"Fish Meal Combined"},{"$f":"Feed!K39","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!K41","v":0},"lbs"]
[{"$f":"Feed!A41","v":"Flaxseed Meal"},{"$f":"Feed!K41","v":0},"lbs"]
[{"$f":"Feed!A42","v":"Lupins"},{"$f":"Feed!K42","v":0},"lbs"]
[{"$f":"Feed!A43","v":"Meat Meal"},{"$f":"Feed!K43","v":0},"lbs"]
[{"$f":"Feed!A44","v":"Meat and Bone Meal, P >4%"},{"$f":"Feed!K44","v":0},"lbs"]
[{"$f":"Feed!A45","v":"Milk, Casein"},{"$f":"Feed!K45","v":0},"lbs"]
[{"$f":"Feed!A46","v":"Milk, Lactose"},{"$f":"Feed!K46","v":0},"lbs"]
[{"$f":"Feed!A47","v":"Milk, Skim Milk Powder"},{"$f":"Feed!K47","v":0},"lbs"]
[{"$f":"Feed!A48","v":"Milk, Whey Powder"},{"$f":"Feed!K48","v":0},"lbs"]
[{"$f":"Feed!A49","v":"Milk, Whey Permeate, 85% lactose"},{"$f":"Feed!K49","v":0},"lbs"]
[{"$f":"Feed!A50","v":"Milk, Whey Protein Concentrate"},{"$f":"Feed!K50","v":0},"lbs"]
[{"$f":"Feed!A51","v":"Millet"},{"$f":"Feed!K51","v":0},"lbs"]
[{"$f":"Feed!A52","v":"Molasses, Sugarbeet"},{"$f":"Feed!K52","v":0},"lbs"]
[{"$f":"Feed!A53","v":"Molasses, Sugarcane"},{"$f":"Feed!K53","v":0},"lbs"]
[{"$f":"Feed!A54","v":"Oats"},{"$f":"Feed!K54","v":0},"lbs"]
[{"$f":"Feed!A55","v":"Oats, Naked"},{"$f":"Feed!K55","v":0},"lbs"]
[{"$f":"Feed!A56","v":"Oat Groats"},{"$f":"Feed!K56","v":0},"lbs"]
[{"$f":"Feed!A57","v":"Peanut Meal, Expelled"},{"$f":"Feed!K57","v":0},"lbs"]
[{"$f":"Feed!A58","v":"Peanut Meal, Extracted"},{"$f":"Feed!K58","v":0},"lbs"]
[{"$f":"Feed!A59","v":"Peas, Field Peas"},{"$f":"Feed!K59","v":0},"lbs"]
[{"$f":"Feed!A60","v":"Pea Protein Concentrate"},{"$f":"Feed!K60","v":0},"lbs"]
[{"$f":"Feed!A61","v":"Potato Protein Concentrate"},{"$f":"Feed!K61","v":0},"lbs"]
[{"$f":"Feed!A62","v":"Poultry Byproduct"},{"$f":"Feed!K62","v":0},"lbs"]
[{"$f":"Feed!A63","v":"Rice"},{"$f":"Feed!K63","v":0},"lbs"]
[{"$f":"Feed!A64","v":"Rice Bran"},{"$f":"Feed!K64","v":0},"lbs"]
[{"$f":"Feed!A65","v":"Rice Bran, Defatted"},{"$f":"Feed!K65","v":0},"lbs"]
[{"$f":"Feed!A66","v":"Rice, Broken"},{"$f":"Feed!K66","v":0},"lbs"]
[{"$f":"Feed!A67","v":"Rye"},{"$f":"Feed!K67","v":0},"lbs"]
[{"$f":"Feed!A68","v":"Sesame Meal"},{"$f":"Feed!K68","v":0},"lbs"]
[{"$f":"Feed!A69","v":"Sorghum"},{"$f":"Feed!K69","v":0},"lbs"]
[{"$f":"Feed!A70","v":"Soybeans, Full Fat"},{"$f":"Feed!K70","v":0},"lbs"]
[{"$f":"Feed!A71","v":"Soybeans, High Protein, Full Fat"},{"$f":"Feed!K71","v":0},"lbs"]
[{"$f":"Feed!A72","v":"Soybeans, Low Oligosaccharide, Full Fat"},{"$f":"Feed!K72","v":0},"lbs"]
[{"$f":"Feed!A73","v":"Soybean Meal, High Protein, Expelled"},{"$f":"Feed!K73","v":0},"lbs"]
[{"$f":"Feed!A74","v":"Soybean Meal, Low Oligosacch, Expell"},{"$f":"Feed!K74","v":0},"lbs"]
[{"$f":"Feed!A75","v":"Soybean Meal, Expelled"},{"$f":"Feed!K75","v":0},"lbs"]
[{"$f":"Feed!A76","v":"Soybean Meal, Dehulled, Expelled"},{"$f":"Feed!K76","v":0},"lbs"]
[{"$f":"Feed!A77","v":"Soybean Meal, Solvent Extracted"},{"$f":"Feed!K77","v":0},"lbs"]
[{"$f":"Feed!A78","v":"Soybean Meal, Dehull, Sol Extr"},{"$f":"Feed!K78","v":100.02572879356299},"lbs"]
[{"$f":"Feed!A79","v":"Soybean Meal, High Prot, Dehull, Solv Extr"},{"$f":"Feed!K79","v":0},"lbs"]
[{"$f":"Feed!A80","v":"Soybean Meal, Enzyme Treated"},{"$f":"Feed!K80","v":0},"lbs"]
[{"$f":"Feed!A81","v":"Soybean Meal, Fermented"},{"$f":"Feed!K81","v":0},"lbs"]
[{"$f":"Feed!A82","v":"Soybean Hulls"},{"$f":"Feed!K82","v":0},"lbs"]
[{"$f":"Feed!A83","v":"Soy Protein Concentrate"},{"$f":"Feed!K83","v":0},"lbs"]
[{"$f":"Feed!A84","v":"Soy Protein Isolate"},{"$f":"Feed!K84","v":0},"lbs"]
[{"$f":"Feed!A85","v":"Sugar Beet Pulp"},{"$f":"Feed!K85","v":0},"lbs"]
[{"$f":"Feed!A86","v":"Sunflower, Full Fat"},{"$f":"Feed!K86","v":0},"lbs"]
[{"$f":"Feed!A87","v":"Sunflower Meal, Solvent Extracted"},{"$f":"Feed!K87","v":0},"lbs"]
[{"$f":"Feed!A88","v":"Sunflower Meal, Dehulled, Solvent Extr"},{"$f":"Feed!K88","v":0},"lbs"]
[{"$f":"Feed!A89","v":"Triticale"},{"$f":"Feed!K89","v":0},"lbs"]
[{"$f":"Feed!A90","v":"Wheat, Hard Red"},{"$f":"Feed!K90","v":0},"lbs"]
[{"$f":"Feed!A91","v":"Wheat, Soft Red"},{"$f":"Feed!K91","v":0},"lbs"]
[{"$f":"Feed!A92","v":"Wheat Bran"},{"$f":"Feed!K92","v":0},"lbs"]
[{"$f":"Feed!A93","v":"Wheat Middlings"},{"$f":"Feed!K93","v":0},"lbs"]
[{"$f":"Feed!A94","v":"Wheat Shorts"},{"$f":"Feed!K94","v":0},"lbs"]
[{"$f":"Feed!A95","v":"Wheat DDGS"},{"$f":"Feed!K95","v":0},"lbs"]
[{"$f":"Feed!A96","v":"Yeast, Brewers' Yeast"},{"$f":"Feed!K96","v":0},"lbs"]
[{"$f":"Feed!A97","v":"Yeast, Single Cell Protein"},{"$f":"Feed!K97","v":0},"lbs"]
[{"$f":"Feed!A98","v":"Beef Tallow"},{"$f":"Feed!K98","v":0},"lbs"]
[{"$f":"Feed!A99","v":"Choice White Grease"},{"$f":"Feed!K99","v":0},"lbs"]
[{"$f":"Feed!A100","v":"Poultry Fat"},{"$f":"Feed!K100","v":0},"lbs"]
[{"$f":"Feed!A101","v":"Lard"},{"$f":"Feed!K101","v":0},"lbs"]
[{"$f":"Feed!A102","v":"Restaurant Grease"},{"$f":"Feed!K102","v":0},"lbs"]
[{"$f":"Feed!A103","v":"Canola oil"},{"$f":"Feed!K103","v":0},"lbs"]
[{"$f":"Feed!A104","v":"Coconut oil"},{"$f":"Feed!K104","v":0},"lbs"]
[{"$f":"Feed!A105","v":"Corn oil"},{"$f":"Feed!K105","v":0},"lbs"]
[{"$f":"Feed!A106","v":"Palm Kernel oil"},{"$f":"Feed!K106","v":0},"lbs"]
[{"$f":"Feed!A107","v":"Soybean oil"},{"$f":"Feed!K107","v":0},"lbs"]
[{"$f":"Feed!A108","v":"Soybean Lecithin"},{"$f":"Feed!K108","v":0},"lbs"]
[{"$f":"Feed!A109","v":"Sunflower oil"},{"$f":"Feed!K109","v":0},"lbs"]
[{"$f":"Feed!A110","v":"Fat, A/V blend"},{"$f":"Feed!K110","v":0},"lbs"]
[{"$f":"Feed!A111","v":"Calcium carbonate"},{"$f":"Feed!K111","v":0},"lbs"]
[{"$f":"Feed!A112","v":"Calcium phosphate (tricalcium)"},{"$f":"Feed!K112","v":0},"lbs"]
[{"$f":"Feed!A113","v":"Calcium phosphate (dicalcium)"},{"$f":"Feed!K113","v":0},"lbs"]
[{"$f":"Feed!A114","v":"Calcium phosphate (monocalcium)"},{"$f":"Feed!K114","v":2.5203731056101093},"lbs"]
[{"$f":"Feed!A115","v":"Calcium sulfate, dihydrate"},{"$f":"Feed!K115","v":0},"lbs"]
[{"$f":"Feed!A116","v":"Limestone, ground"},{"$f":"Feed!K116","v":5.3853120000000008},"lbs"]
[{"$f":"Feed!A117","v":"Magnesium phosphate"},{"$f":"Feed!K117","v":0},"lbs"]
[{"$f":"Feed!A118","v":"Sodium carbonate"},{"$f":"Feed!K118","v":0},"lbs"]
[{"$f":"Feed!A119","v":"Sodium bicarbonate"},{"$f":"Feed!K119","v":0},"lbs"]
[{"$f":"Feed!A120","v":"Sodium chloride"},{"$f":"Feed!K120","v":2.9918400000000003},"lbs"]
[{"$f":"Feed!A121","v":"Sodium phosphate, monobasic"},{"$f":"Feed!K121","v":0},"lbs"]
[{"$f":"Feed!A122","v":"Sodium sulfate, decahydrate"},{"$f":"Feed!K122","v":0},"lbs"]
[{"$f":"Feed!A123","v":"L-Lys-HCL"},{"$f":"Feed!K123","v":1.7951040000000003},"lbs"]
[{"$f":"Feed!A124","v":"DL-Met"},{"$f":"Feed!K124","v":0.13691163353407723},"lbs"]
[{"$f":"Feed!A125","v":"L-Thr"},{"$f":"Feed!K125","v":0.47726918585757255},"lbs"]
[{"$f":"Feed!A126","v":"L-Trp"},{"$f":"Feed!K126","v":6.8292703566466009E-2},"lbs"]
[{"$f":"Feed!A127","v":"L-Val"},{"$f":"Feed!K127","v":0},"lbs"]
[{"$f":"Feed!A128","v":"L-Ileu"},{"$f":"Feed!K128","v":0},"lbs"]
[{"$f":"Feed!A129","v":"Methionine hydroxy analog"},{"$f":"Feed!K129","v":0},"lbs"]
[{"$f":"Feed!A130","v":"Glutamine"},{"$f":"Feed!K130","v":0},"lbs"]
[{"$f":"Feed!A131","v":"Glutamic acid"},{"$f":"Feed!K131","v":0},"lbs"]
[{"$f":"Feed!A132","v":"Biolys"},{"$f":"Feed!K132","v":0},"lbs"]
[{"$f":"Feed!A133","v":"Liquid lysine 60%"},{"$f":"Feed!K133","v":0},"lbs"]
[{"$f":"Feed!A134","v":"MHA dry"},{"$f":"Feed!K134","v":0},"lbs"]
[{"$f":"Feed!A135","v":"Ractopamine 9 g/lb"},{"$f":"Feed!K135","v":0},"lbs"]
[{"$f":"Feed!A136","v":"Phase 2 supplement (PEP2)"},{"$f":"Feed!K136","v":0},"lbs"]
[{"$f":"Feed!A137","v":"2007 Starter base mix"},{"$f":"Feed!K137","v":0},"lbs"]
[{"$f":"Feed!A138","v":"2007 Grow-finish base mix"},{"$f":"Feed!K138","v":0},"lbs"]
[{"$f":"Feed!A139","v":"Developer base mix"},{"$f":"Feed!K139","v":0},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!K141","v":0.7040980706373845},"lbs"]
[{"$f":"Feed!A141","v":"Vitamin premix with phytase"},{"$f":"Feed!K141","v":0.7040980706373845},"lbs"]
[{"$f":"Feed!A142","v":"Trace mineral premix"},{"$f":"Feed!K142","v":0.7040980706373845},"lbs"]
[{"$f":"Feed!A143","v":"Sow add pack"},{"$f":"Feed!K143","v":0},"lbs"]
[{"$f":"Feed!A144","v":"Vitamin premix without phytase"},{"$f":"Feed!K144","v":0},"lbs"]
[{"$f":"Feed!A145","v":"GF DDGS Base Mix"},{"$f":"Feed!K145","v":0},"lbs"]
[{"$f":"Feed!A146","v":"GF synthetics Base Mix"},{"$f":"Feed!K146","v":0},"lbs"]
[{"$f":"Feed!A147","v":"Choline chloride 60%"},{"$f":"Feed!K147","v":0},"lbs"]
[{"$f":"Feed!A148","v":"Natuphos 600"},{"$f":"Feed!K148","v":0},"lbs"]
[{"$f":"Feed!A149","v":"Natuphos 1200"},{"$f":"Feed!K149","v":0},"lbs"]
[{"$f":"Feed!A150","v":"Optiphos 2000"},{"$f":"Feed!K150","v":0},"lbs"]
[{"$f":"Feed!A151","v":"Phyzyme 1200"},{"$f":"Feed!K151","v":0},"lbs"]
[{"$f":"Feed!A152","v":"Phyzyme 5000"},{"$f":"Feed!K152","v":0},"lbs"]
[{"$f":"Feed!A153","v":"Ronozyme CT (10,000)"},{"$f":"Feed!K153","v":0},"lbs"]
[{"$f":"Feed!A154","v":"Ronozyme M (50,000)"},{"$f":"Feed!K154","v":0},"lbs"]
[{"$f":"Feed!A155","v":"Ronozyme PMX PLT (4625 FYT/g)"},{"$f":"Feed!K155","v":5.7856068481511556E-2},"lbs"]
[{"$f":"Feed!A156","v":"Zinc oxide"},{"$f":"Feed!K156","v":0},"lbs"]
[{"$f":"Feed!A157","v":"Copper sulfate"},{"$f":"Feed!K157","v":0},"lbs"]
[{"$f":"Feed!A158","v":"Potassium chloride"},{"$f":"Feed!K158","v":0},"lbs"]
[{"$f":"Feed!A159","v":"Calcium chloride"},{"$f":"Feed!K159","v":0},"lbs"]
[{"$f":"Feed!A160","v":"Acidifier"},{"$f":"Feed!K160","v":0},"lbs"]
[{"$f":"Feed!A161","v":"Vitamin E, 20,000 IU"},{"$f":"Feed!K161","v":0},"lbs"]
[{"$f":"Feed!A162","v":"Phase 2 supplement D"},{"$f":"Feed!K162","v":0},"lbs"]
[{"$f":"Feed!A163","v":"DPS 50"},{"$f":"Feed!K163","v":0},"lbs"]
[{"$f":"Feed!A164","v":"PEP2+"},{"$f":"Feed!K164","v":0},"lbs"]
[{"$f":"Feed!A165","v":"PEP NS"},{"$f":"Feed!K165","v":0},"lbs"]
[{"$f":"Feed!A166","v":"Natural vitamin E 20,000 IU/lb"},{"$f":"Feed!K166","v":0},"lbs"]
[{"$f":"Feed!A167","v":"Other ingredient"},{"$f":"Feed!K167","v":0},"lbs"]
[{"$f":"Feed!A168","v":"Corn DDGS, 10.5% Oil"},{"$f":"Feed!K168","v":0},"lbs"]
[{"$f":"Feed!A169","v":"Corn DDGS, 7.5% Oil"},{"$f":"Feed!K169","v":0},"lbs"]
[{"$f":"Feed!A170","v":"Corn DDGS, 4.5% Oil"},{"$f":"Feed!K170","v":0},"lbs"]
[{"$f":"Feed!A171","v":"Denegard"},{"$f":"Feed!K171","v":0},"lbs"]
[{"$f":"Feed!A172","v":"CTC 50"},{"$f":"Feed!K172","v":0},"lbs"]
[{"$f":"Feed!A173","v":"Bentonite"},{"$f":"Feed!K173","v":0},"lbs"]
[{"$f":"Feed!A188","v":"Complete nursery pellet"},{"$f":"Feed!K188","v":0},"lbs"]
[{"$f":"Feed!A175","v":"Other ingredient"},{"$f":"Feed!K175","v":0}]
[{"$f":"Feed!A176","v":"Other ingredient"},{"$f":"Feed!K176","v":0}]
[{"$f":"Feed!A177","v":"Other ingredient"},{"$f":"Feed!K177","v":0}]
[{"$f":"Feed!A178","v":"Other ingredient"},{"$f":"Feed!K178","v":0}]
[{"$f":"Feed!A179","v":"Other ingredient"},{"$f":"Feed!K179","v":0}]
[{"$f":"Feed!A180","v":"Other ingredient"},{"$f":"Feed!K180","v":0}]
[{"$f":"Feed!A181","v":"Other ingredient"},{"$f":"Feed!K181","v":0}]
[{"$f":"Feed!A182","v":"Other ingredient"},{"$f":"Feed!K182","v":0}]
[{"$f":"Feed!A183","v":"Other ingredient"},{"$f":"Feed!K183","v":0}]
[{"$f":"Feed!A184","v":"Other ingredient"},{"$f":"Feed!K184","v":0}]
[{"$f":"Feed!A185","v":"Other ingredient"},{"$f":"Feed!K185","v":0}]
[{"$f":"Feed!A186","v":"Other ingredient"},{"$f":"Feed!K186","v":0}]
[]
["Finishing Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
[{"$f":"Prices!A14","v":"Market Hogs ($/cwt)"},{"$f":"Prices!B14","v":44.75},{"$f":"Prices!D14","v":46.082000000000001},null,{"$f":"Prices!G14","v":58.48}]
[{"$f":"Prices!A16","v":"Feeder Pig ($/hd)"},{"$f":"Prices!B16","v":54.43},{"$f":"Prices!D16","v":66.539911536000005},null,{"$f":"Prices!G16","v":84.194752539999996}]
[{"$f":"Prices!A30","v":"Swine Feed processing ($/ton) charge"},{"$f":"Prices!B30","v":17},{"$f":"Prices!D30","v":17},null,{"$f":"Prices!G30","v":17}]
["Grow-Finish Feed ($/lb)",{"$f":"SUMPRODUCT(Feed!$K$23:$K$188,Prices!$B$41:$B$206)/Feed!K189","v":0.10000813591761802},{"$f":"SUMPRODUCT(Feed!$K$23:$K$188,Prices!$D$41:$D$206)/Feed!K189","v":0.10100821727679421},null,{"$f":"SUMPRODUCT(Feed!$K$23:$K$188,Prices!$G$41:$G$206)/Feed!K189","v":0.10200829863597038}]
[{"$f":"Prices!A31","v":"Corn ($/bu)"},{"$f":"Prices!B31","v":4.25},{"$f":"Prices!D31","v":4.18},null,{"$f":"Prices!G31","v":3.55}]
[{"$f":"Prices!A32","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B32","v":380},{"$f":"Prices!D32","v":334.59999999999997},null,{"$f":"Prices!G32","v":341}]
[{"$f":"Prices!A33","v":"DDGS ($/ton)"},{"$f":"Prices!B33","v":210},{"$f":"Prices!D33","v":206.5411764705882},null,{"$f":"Prices!G33","v":175.41176470588235}]
["Other Feed Ingredients",{"$f":"Prices!B38","v":0.24720881108861548},{"$f":"Prices!D38","v":0.24968089919950162},null,{"$f":"Prices!G38","v":0.25215298731038777}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A83","v":"Publication: AM-FMG-FinishingSwine"},null,null,null,null,null,null,null,{"$f":"I83","v":"Version- 12.7.2020"}]

{"sheet":"Feed (2)_IDOtherIngValues","index":8,"n_rows":197,"n_cols":16,"rows_kept":197,"cut":false,"hidden":true,"merged":[[2,7,2,11]]}
["SWINE RATIONS TO SET FEED COSTS"]
[]
["Ingredient",null,null,null,"Usage per pig, lb",null,null,"Total Useage (lbs per pig) by Production Phase/Type"]
[null,"Price","Unit",null,"Sows","Nursery","GF","Farrow-Finish","Farrow-Wean","Wean-Finish","Nursery","Finish",null,null,null,"Currently Used?"]
["Corn",null,null,null,null,null,null,{"$f":"SUM(E5:G5)","v":0},{"$f":"E5","v":0},{"$f":"F5+G5","v":0},{"$f":"F5","v":0},{"$f":"G5","v":0},null,null,null,0]
["Soybean Meal, Dehull, Sol Extr",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Corn",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Milo",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Alfalfa Meal",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Bakery Meal",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Barley",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Barley, Hulless",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Beans, Faba",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Blood Meal",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Blood Plasma",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Brewers Grain",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Canola, Full Fat",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Canola Meal, Expelled",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Canola Meal, Solvent Extracted",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Casava Meal",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Citrus Pulp",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Copra Meal",null,null,null,null,null,null,0,0,0,0,0,null,null,null,0]
["Corn, Yellow Dent",3.73,"$/bu",null,97.929323099534585,28.491718888142149,464.39196337704988,590.81300536472656,97.929323099534585,492.88368226519202,28.491718888142149,464.39196337704988,null,null,null,{"$f":"IF(SUM(E23:G222)=0,0,1)","v":1}]
["L-Lys-HCL",0.90900000000000003,"$/lb",null,0.1075,0.16800000000000001,1.5883526335490903,1.8638526335490904,0.1075,1.7563526335490902,0.16800000000000001,1.5883526335490903,null,null,null,1]
["Vitamin premix with phytase",0.67700000000000005,"$/lb",null,0.3125,0.10125000000000001,0.62647632986137569,1.0402263298613756,0.3125,0.72772632986137564,0.10125000000000001,0.62647632986137569,null,null,null,1]
["Trace mineral premix",0.41,"$/lb",null,0.1875,6.0749999999999998E-2,0.62647632986137569,0.87472632986137566,0.1875,0.68722632986137566,6.0749999999999998E-2,0.62647632986137569,null,null,null,1]
["L-Thr",3.5102000000000002,"$/lb",null,1.8749999999999999E-2,4.4550000000000006E-2,0.37444002241050678,0.4377400224105068,1.8749999999999999E-2,0.41899002241050676,4.4550000000000006E-2,0.37444002241050678,null,null,null,1]
["DL-Met",4.359,"$/lb",null,1.8749999999999999E-2,3.4424999999999997E-2,0.10347588139699389,0.1566508813969939,1.8749999999999999E-2,0.13790088139699389,3.4424999999999997E-2,0.10347588139699389,null,null,null,1]
["Ronozyme PMX PLT (4625 FYT/g)",0.83320000000000005,"$/lb",null,0,0,7.1154959605232604E-2,7.1154959605232604E-2,0,7.1154959605232604E-2,0,7.1154959605232604E-2,null,null,null,1]
["Ractopamine 9 g/lb",37,"$/lb",null,0,0,2.1785655119556373E-2,2.1785655119556373E-2,0,2.1785655119556373E-2,0,2.1785655119556373E-2,null,null,null,1]
["Sow add pack",1.7,"$/lb",null,0.3125,0,0,0.3125,0.3125,0,0,0,null,null,null,1]
["L-Trp",null,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["L-Val",7,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["L-Ileu",7,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Methionine hydroxy analog",1.2,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Glutamine",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Glutamic acid",0,"$/lb",null,0,0,0,{"$f":"SUM(E37:G37)","v":0},{"$f":"E37","v":0},{"$f":"F37+G37","v":0},{"$f":"F37","v":0},{"$f":"G37","v":0},null,null,null,1]
["Biolys",0.7,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Liquid lysine 60%",0.6,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["MHA dry",2.2000000000000002,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Phase 2 supplement (PEP2)",0.45,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["2007 Starter base mix",0.36,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["2007 Grow-finish base mix",0.22,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Developer base mix",0.2,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["2007 Sow base mix",0.22,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Natural vitamin E 20,000 IU/lb",9.4375,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Denegard",4.7286000000000001,"$/lb",null,0,9.1874999999999998E-2,0,9.1874999999999998E-2,0,9.1874999999999998E-2,9.1874999999999998E-2,0,null,null,null,1]
["CTC 50",1.44,"$/lb",null,0,0.21,0,0.21,0,0.21,0.21,0,null,null,null,1]
["Vitamin premix without phytase",0.9,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["GF DDGS Base Mix",0.25,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["GF synthetics Base Mix",0.3,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Choline chloride 60%",0.6,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Natuphos 600",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Natuphos 1200",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Optiphos 2000",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(E55:G254)=0,0,1)","v":1}]
["Phyzyme 1200",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Phyzyme 5000",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Ronozyme CT (10,000)",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Ronozyme M (50,000)",0,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Bentonite",0.15,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Zinc oxide",1.1000000000000001,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Copper sulfate",1.1000000000000001,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Potassium chloride",0.17499999999999999,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Calcium chloride",0.2,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Acidifier",1,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Vitamin E, 20,000 IU",0.4,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Phase 2 supplement D",0.4,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["DPS 50",0.5,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["PEP2+",0.6,"$/lb",null,0,0,0,{"$f":"SUM(E69:G69)","v":0},{"$f":"E69","v":0},{"$f":"F69+G69","v":0},{"$f":"F69","v":0},{"$f":"G69","v":0},null,null,null,1]
["PEP NS",0.5,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Phase 2 supplement (Feb, 2014)",0.73619999999999997,"$/lb",null,0,2.1,0,2.1,0,2.1,2.1,0,null,null,null,1]
["Other ingredient",null,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDGS, 10.5% Oil",0.125,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDGS, 4.5% Oil",0.125,"$/lb",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Dehull, Sol Extr",363.15,"$/ton",null,22.305676900465429,14.955181111857849,110.1436689808755,147.40452699319877,22.305676900465429,125.09885009273336,14.955181111857849,110.1436689808755,null,null,null,1]
["Limestone, ground",35.200000000000003,"$/ton",null,1.6025,0.46575,5.2955280000000009,7.3637780000000008,1.6025,5.7612780000000008,0.46575,5.2955280000000009,null,null,null,1]
["Sodium chloride",{"$f":"0.058*2000","v":116},"$/ton",null,0.57999999999999996,0.20250000000000001,2.9419600000000008,3.7244600000000005,0.57999999999999996,3.1444600000000009,0.20250000000000001,2.9419600000000008,null,null,null,1]
["Calcium phosphate (monocalcium)",656,"$/ton",null,1.625,0.32400000000000001,2.2067178302706041,4.1557178302706044,1.625,2.5307178302706039,0.32400000000000001,2.2067178302706041,null,null,null,1]
["Soybean Meal, Dehull, Sol Extr",null,"$/ton",null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDGS, 7.5% Oil",192,"$/ton",null,0,5.25,0,5.25,0,5.25,5.25,0,null,null,null,1]
["Complete nursery pellet",700,"$/ton",null,0,3,0,3,0,3,3,0,null,null,null,1]
["Corn, Nutridense",4.8000000000000001E-2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn Bran",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDG",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDGS, >10% Oil",0.125,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDGS, >6 and <9% Oil",7.8E-2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn DDGS, <4% Oil",null,null,null,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(E87:G286)=0,0,1)","v":1}]
["Corn HP DDG",0.06,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Dehulled, Expelled",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Solvent Extracted",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn Gluten Meal",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn Grits, Hominy Feed",4.4999999999999998E-2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Cotton Seeds, Fullfat",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Cotton Seed Meal",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Feather Meal",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Fish Meal Combined",0.7,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Flaxseed",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Flaxseed Meal",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Lupins",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Meat Meal",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Meat and Bone Meal, P >4%",0.15,null,null,0,0,0,{"$f":"SUM(E101:G101)","v":0},{"$f":"E101","v":0},{"$f":"F101+G101","v":0},{"$f":"F101","v":0},{"$f":"G101","v":0},null,null,null,1]
["Milk, Casein",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Milk, Lactose",0.3,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Milk, Skim Milk Powder",1.2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Milk, Whey Powder",0.55000000000000004,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Milk, Whey Permeate, 85% lactose",0.45,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Milk, Whey Protein Concentrate",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Millet",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Molasses, Sugarbeet",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Molasses, Sugarcane",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Oats",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Oats, Naked",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Oat Groats",0.17499999999999999,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Peanut Meal, Expelled",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Peanut Meal, Extracted",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Peas, Field Peas",0.08,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Pea Protein Concentrate",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Potato Protein Concentrate",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Poultry Byproduct",0.12,null,null,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(E119:G318)=0,0,1)","v":1}]
["Rice",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Rice Bran",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Rice Bran, Defatted",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Rice, Broken",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Rye",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sesame Meal",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sorghum",0.1,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybeans, Full Fat",0.2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybeans, High Protein, Full Fat",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybeans, Low Oligosaccharide, Full Fat",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, High Protein, Expelled",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Low Oligosacch, Expell",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Expelled",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Dehulled, Expelled",0.17499999999999999,null,null,0,0,0,{"$f":"SUM(E133:G133)","v":0},{"$f":"E133","v":0},{"$f":"F133+G133","v":0},{"$f":"F133","v":0},{"$f":"G133","v":0},null,null,null,1]
["Soybean Meal, Solvent Extracted",0.155,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, High Prot, Dehull, Solv Extr",0.32,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Enzyme Treated",0.02,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Meal, Fermented",3.5000000000000003E-2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Hulls",4.8000000000000001E-2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soy Protein Concentrate",0.55000000000000004,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soy Protein Isolate",0.17499999999999999,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sugar Beet Pulp",0.2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sunflower, Full Fat",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sunflower Meal, Solvent Extracted",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sunflower Meal, Dehulled, Solvent Extr",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Triticale",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Wheat, Hard Red",0.06,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Wheat, Soft Red",0.45,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Wheat Bran",0.05,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Wheat Middlings",0.12,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Wheat Shorts",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Wheat DDGS",0,null,null,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(E151:G350)=0,0,1)","v":1}]
["Yeast, Brewers' Yeast",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Yeast, Single Cell Protein",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Beef Tallow",0.4,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Choice White Grease",0.42,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Poultry Fat",2.7,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Lard",1.25,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Restaurant Grease",0.38,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Canola oil",1.2,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Coconut oil",7,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Corn oil",7,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Palm Kernel oil",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean oil",0.38,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Soybean Lecithin",0.7,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sunflower oil",0.6,null,null,0,0,0,{"$f":"SUM(E165:G165)","v":0},{"$f":"E165","v":0},{"$f":"F165+G165","v":0},{"$f":"F165","v":0},{"$f":"G165","v":0},null,null,null,1]
["Fat, A/V blend",2.2000000000000002,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Calcium carbonate",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Calcium phosphate (tricalcium)",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Calcium phosphate (dicalcium)",0.3,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Calcium sulfate, dihydrate",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Magnesium phosphate",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sodium carbonate",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sodium bicarbonate",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sodium phosphate, monobasic",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Sodium sulfate, decahydrate",32,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(E183:G382)=0,0,1)","v":1}]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",null,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
["Other ingredient",0,null,null,0,0,0,0,0,0,0,0,null,null,null,1]
[null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,1]
[null,null,null,null,{"$f":"SUM(E23:E188)","v":125.00000000000001},{"$f":"SUM(F23:F188)","v":55.5},588.39200000000005,{"$f":"SUM(H23:H188)","v":768.89200000000017},{"$f":"SUM(I23:I188)","v":125.00000000000001},643.89200000000017,55.5,588.39200000000005]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H193+H194","v":25.424467642074735},{"$f":"I193+I194","v":4.7650000000000006},20.659467642074738,6.8031000000000006,13.856367642074737]
[null,null,"$/lb",null,null,null,null,{"$f":"SUM(H24:H71)","v":7.1805118118041307},{"$f":"SUM(I24:I71)","v":0.95750000000000002},6.2230118118041311,2.8108499999999998,3.4121618118041313]
[null,null,"$/ton",null,null,null,null,{"$f":"SUM(H76:H78)+H81","v":18.243955830270604},{"$f":"SUM(I76:I78)+I81","v":3.8075000000000001},14.436455830270605,3.9922500000000003,10.444205830270606]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($B$24:$B$71,H24:H71)/H193","v":1.2054816128381405},{"$f":"SUMPRODUCT($B$24:$B$71,I24:I71)/I193","v":1.1122219321148825},1.2198309579772799,1.0087567319494104,1.3937084060449432]
[null,null,null,null,null,null,null,{"$f":"(SUMPRODUCT($B$76:$B$78,H76:H78)+$B$81*H81)/2000/H194","v":0.15121153804546564},{"$f":"(SUMPRODUCT($B$76:$B$78,I76:I78)+$B$81*I81)/2000/I194","v":0.15622954694681551},0.14988807824920264,0.29462438474544428,9.4563285823635365E-2]
[null,null,"$/lb:",null,null,null,null,{"$f":"SUMPRODUCT(H195:H196,H193:H194)/H192","v":0.44896403502804039},{"$f":"SUMPRODUCT(I195:I196,I193:I194)/I192","v":0.3483308499475341},{"$f":"SUMPRODUCT(J195:J196,J193:J194)/J192","v":0.472174561805218},0.58968382943070063,0.41448070442260443]