{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input","Net-per cow per day","Net-per herd per day","Net-per herd per year"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Input","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["(updated:  9/24/12)",null,null,"(enter data in green shaded cells)"]
[null,null,"Dairy Feed Change Evaluator"]
[]
[null,null,null,"Current","New",null,"Results Summary"]
[null,null,"Variable","Ration","Ration",null,null,"New Ration"]
[null,null,"Cow Data",null,null,null,"Measure","vs. Current"]
[null,null,"Number of Cows",750,750,null,"Per cow/day",{"$f":"'Net-per cow per day'!$F$32","v":8.5308250000000641E-2}]
[null,null,"Pounds of Milk (per cow/day)",80,75,null,"Herd per day",{"$f":"'Net-per herd per day'!F32","v":63.981187499997759}]
[null,null,"Butterfat (%)",3.4000000000000002E-2,3.6499999999999998E-2,null,"Herd per week",{"$f":"H8*7","v":447.86831249998431}]
[null,null,"Milk Protein (%)",2.8000000000000001E-2,0.03,null,"Herd per month",{"$f":"H8*30.5","v":1951.4262187499316}]
[null,null,"Other Solids (%)",5.7000000000000002E-2,5.7000000000000002E-2,null,"Herd per year",{"$f":"H8*365","v":23353.133437499182}]
[null,null,"Milk Price Data"]
[null,null,"Butterfat Price ($/lb)",2.2511000000000001,{"$f":"IF(D13>0,D13,\"\")","v":2.2511000000000001}]
[null,null,"Milk Protein Price ($/lb)",3.8292000000000002,{"$f":"IF(D14>0,D14,\"\")","v":3.8292000000000002}]
[null,null,"Other Solids Price ($/lb)",0.36080000000000001,0.36080000000000001]
[null,null,"Approximate Class III Price1 ($/cwt)",{"$f":"(D14*3.1)+(D15*5.9)+(D13*3.5)","v":21.87809},{"$f":"(E14*3.1)+(E15*5.9)+(E13*3.5)","v":21.87809}]
[null,null,"PPD2 ($/cwt)",1.48,1.48]
[null,null,"Volume Premium ($/cwt)",0.4,0.4]
[null,null,"Quality Premium ($/cwt)",0.1,0.1]
[null,null,"Other Premium ($/cwt)",0,{"$f":"IF(D20>0,D20,0)","v":0}]
[null,null,"Variable Cost Data"]
[null,null,"Milk Hauling ($/cwt)",0.45,0.45]
[null,null,"Promotion ($/cwt)",0.15,0.15]
[null,null,"Co-op Dues ($/cwt)",0.01,0.01]
[null,null,"Other Deductions ($/cwt)",0.1,0.1]
[null,null,"Utilities3 (KWh/lb milk)",7.9000000000000008E-3,7.9000000000000008E-3]
[null,null,"Electric cost ($/KWh)",0.1,0.1]
[null,null,"Ration Variables"]
[null,null,"DM4 Intake (lbs./cow/day)",51,50]
[null,null,"Ration Cost ($/lb. DM)",7.0000000000000007E-2,6.8000000000000005E-2]
[null,null,"1Approximate Class III price based on the given butterfat, milk protein, and other solids prices."]
[null,null,"2PPD equals producer price differential used in federal order minimum pricing."]
[null,null,"3Electricity used to cool milk."]
[null,null,"4DM equals dry matter."]
[null,null,"http://www.ams.usda.gov/AMSv1.0/ams.fetchTemplateData.do?startIndex=1&template=TemplateV&page=MilkPriceAnnouncementsSummariesandProductPrices  "]
[]
[null,null,"Dairy Feed Change Evaluator was programmed by Craig Thomas, Michigan State University Extension Dairy Educator"]
[null,null,"Questions?  Contact Craig Thomas at:","thomasc@anr.msu.edu","810-404-3402 (cell)",null,"810-648-2515 (office)"]

{"sheet":"Net-per cow per day","index":1,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Daily Comparison (per cow)"]
[]
[null,null,null,{"$f":"Input!$D$4","v":"Current"},{"$f":"Input!$E$4","v":"New"},{"$f":"Input!H5","v":"New Ration"}]
[null,null,"Item (per cow/day)","Ration","Ration",{"$f":"Input!H6","v":"vs. Current"}]
[null,null,"Component"]
[null,null,"Butterfat (lbs.)",{"$f":"Input!D8*Input!D9","v":2.72},{"$f":"Input!E8*Input!E9","v":2.7374999999999998},{"$f":"E7-D7","v":1.7499999999999627E-2}]
[null,null,"Milk Protein (lbs.)",{"$f":"Input!D8*Input!D10","v":2.2400000000000002},{"$f":"Input!E8*Input!E10","v":2.25},{"$f":"E8-D8","v":9.9999999999997868E-3}]
[null,null,"Other Solids (lbs.)",{"$f":"Input!D8*Input!D11","v":4.5600000000000005},{"$f":"Input!E8*Input!E11","v":4.2750000000000004},-0.28500000000000014]
[null,null,"Component Revenue"]
[null,null,"Butterfat ($)",{"$f":"Input!D8*Input!D9*Input!D13","v":6.1229920000000009},{"$f":"Input!E8*Input!E9*Input!E13","v":6.16238625},3.9394249999999076E-2]
[null,null,"Milk protein ($)",{"$f":"Input!D8*Input!D10*Input!D14","v":8.5774080000000019},{"$f":"Input!E8*Input!E10*Input!E14","v":8.6157000000000004},3.8291999999998438E-2]
[null,null,"Other solids ($)",{"$f":"Input!D8*Input!D11*Input!D15","v":1.6452480000000003},{"$f":"Input!E8*Input!E11*Input!E15","v":1.5424200000000001},-0.10282800000000014]
[null,null,"Total Component Revenue",{"$f":"SUM(D11:D13)","v":16.345648000000001},{"$f":"SUM(E11:E13)","v":16.320506250000001},-2.5141749999999519E-2]
[null,null,"Premium Revenue"]
[null,null,"PPD1 ($)",{"$f":"Input!D8*Input!D17*0.01","v":1.1840000000000002},{"$f":"Input!E8*Input!E17*0.01","v":1.1100000000000001},-7.4000000000000066E-2]
[null,null,"Volume Premium ($)",{"$f":"Input!D8*Input!D18*0.01","v":0.32},{"$f":"Input!E8*Input!E18*0.01","v":0.3},-2.0000000000000018E-2]
[null,null,"Quality Premium ($)",{"$f":"Input!D8*Input!D19*0.01","v":0.08},{"$f":"Input!E8*Input!E19*0.01","v":7.4999999999999997E-2},-5.0000000000000044E-3]
[null,null,"Other Premium ($)",{"$f":"Input!D8*Input!D20*0.01","v":0},{"$f":"Input!E8*Input!E20*0.01","v":0},0]
[null,null,"Total Premium Revenue",{"$f":"SUM(D16:D19)","v":1.5840000000000003},{"$f":"SUM(E16:E19)","v":1.4850000000000001},-9.9000000000000199E-2]
[null,null,"Total Revenue",{"$f":"D14+D20","v":17.929648},{"$f":"E14+E20","v":17.805506250000001},{"$f":"E21-D21","v":-0.12414174999999972}]
[null,null,"Variable Costs"]
[null,null,"Milk Hauling ($)",{"$f":"Input!D8*Input!D22*0.01","v":0.36},{"$f":"Input!E8*Input!E22*0.01","v":0.33750000000000002},-2.2499999999999964E-2]
[null,null,"Promotion ($)",{"$f":"Input!D8*Input!D23*0.01","v":0.12},{"$f":"Input!E8*Input!E23*0.01","v":0.1125},-7.4999999999999928E-3]
[null,null,"Co-op Dues ($)",{"$f":"Input!D8*Input!D24*0.01","v":8.0000000000000002E-3},{"$f":"Input!E8*Input!E24*0.01","v":7.4999999999999997E-3},-5.0000000000000044E-4]
[null,null,"Other Deductions ($)",{"$f":"Input!D8*Input!D25*0.01","v":0.08},{"$f":"Input!E8*Input!E25*0.01","v":7.4999999999999997E-2},-5.0000000000000044E-3]
[null,null,"Utilities2 ($)",{"$f":"Input!D8*Input!D26*Input!D27","v":6.320000000000002E-2},{"$f":"Input!E8*Input!E26*Input!E27","v":5.9250000000000004E-2},-3.950000000000016E-3]
[null,null,"Total Variable Cost",{"$f":"SUM(D23:D27)","v":0.63119999999999998},{"$f":"SUM(E23:E27)","v":0.59175},-3.9449999999999985E-2]
[null,null,"Feed Cost"]
[null,null,"Ration Cost",{"$f":"Input!D29*Input!D30","v":3.5700000000000003},{"$f":"Input!E29*Input!E30","v":3.4000000000000004},-0.16999999999999993]
[null,null,"Total Cost",{"$f":"D28+D30","v":4.2012},{"$f":"E28+E30","v":3.9917500000000006},-0.20944999999999947]
[null,null,"Net Return",{"$f":"D21-D31","v":13.728448},{"$f":"E21-E31","v":13.813756250000001},8.5308250000000641E-2]
[]
[null,null,"1PPD equals producer price differential used in federal order minimum pricing."]
[null,null,"2Utilities used to cool milk."]

{"sheet":"Net-per herd per day","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Daily Comparison (herd)"]
[]
[null,null,null,{"$f":"Input!$D$4","v":"Current"},{"$f":"Input!$E$4","v":"New"},{"$f":"Input!H5","v":"New Ration"}]
[null,null,"Item (per cow/day)","Ration","Ration",{"$f":"Input!H6","v":"vs. Current"}]
[null,null,"Component"]
[null,null,"Butterfat (lbs.)",{"$f":"'Net-per cow per day'!D7*Input!$D$7","v":2040.0000000000002},{"$f":"'Net-per cow per day'!E7*Input!$E$7","v":2053.125},{"$f":"E7-D7","v":13.124999999999773}]
[null,null,"Milk Protein (lbs.)",{"$f":"'Net-per cow per day'!D8*Input!$D$7","v":1680.0000000000002},{"$f":"'Net-per cow per day'!E8*Input!$E$7","v":1687.5},{"$f":"E8-D8","v":7.4999999999997726}]
[null,null,"Other Solids (lbs.)",{"$f":"'Net-per cow per day'!D9*Input!$D$7","v":3420.0000000000005},{"$f":"'Net-per cow per day'!E9*Input!$E$7","v":3206.2500000000005},-213.75]
[null,null,"Component Revenue"]
[null,null,"Butterfat ($)",{"$f":"'Net-per cow per day'!D11*Input!$D$7","v":4592.2440000000006},{"$f":"'Net-per cow per day'!E11*Input!$E$7","v":4621.7896874999997},29.545687499999076]
[null,null,"Milk protein ($)",{"$f":"'Net-per cow per day'!D12*Input!$D$7","v":6433.0560000000014},{"$f":"'Net-per cow per day'!E12*Input!$E$7","v":6461.7750000000005},28.718999999999141]
[null,null,"Other solids ($)",{"$f":"'Net-per cow per day'!D13*Input!$D$7","v":1233.9360000000001},{"$f":"'Net-per cow per day'!E13*Input!$E$7","v":1156.8150000000001},-77.121000000000095]
[null,null,"Total Component Revenue",{"$f":"SUM(D11:D13)","v":12259.236000000003},{"$f":"SUM(E11:E13)","v":12240.379687500001},-18.856312500001877]
[null,null,"Premium Revenue"]
[null,null,"PPD1 ($)",{"$f":"'Net-per cow per day'!D16*Input!$D$7","v":888.00000000000011},{"$f":"'Net-per cow per day'!E16*Input!$E$7","v":832.50000000000011},-55.5]
[null,null,"Volume Premium ($)",{"$f":"'Net-per cow per day'!D17*Input!$D$7","v":240},{"$f":"'Net-per cow per day'!E17*Input!$E$7","v":225},-15]
[null,null,"Quality Premium ($)",{"$f":"'Net-per cow per day'!D18*Input!$D$7","v":60},{"$f":"'Net-per cow per day'!E18*Input!$E$7","v":56.25},-3.75]
[null,null,"Other Premium ($)",{"$f":"'Net-per cow per day'!D19*Input!$D$7","v":0},{"$f":"'Net-per cow per day'!E19*Input!$E$7","v":0},0]
[null,null,"Total Premium Revenue",{"$f":"SUM(D16:D19)","v":1188},{"$f":"SUM(E16:E19)","v":1113.75},-74.25]
[null,null,"Total Revenue",{"$f":"D14+D20","v":13447.236000000003},{"$f":"E14+E20","v":13354.129687500001},{"$f":"E21-D21","v":-93.106312500001877}]
[null,null,"Variable Costs"]
[null,null,"Milk Hauling ($)",{"$f":"'Net-per cow per day'!D23*Input!$D$7","v":270},{"$f":"'Net-per cow per day'!E23*Input!$E$7","v":253.12500000000003},-16.874999999999972]
[null,null,"Promotion ($)",{"$f":"'Net-per cow per day'!D24*Input!$D$7","v":90},{"$f":"'Net-per cow per day'!E24*Input!$E$7","v":84.375},-5.625]
[null,null,"Co-op Dues ($)",{"$f":"'Net-per cow per day'!D25*Input!$D$7","v":6},{"$f":"'Net-per cow per day'!E25*Input!$E$7","v":5.625},-0.375]
[null,null,"Other Deductions ($)",{"$f":"'Net-per cow per day'!D26*Input!$D$7","v":60},{"$f":"'Net-per cow per day'!E26*Input!$E$7","v":56.25},-3.75]
[null,null,"Utilities2 ($)",{"$f":"'Net-per cow per day'!D27*Input!$D$7","v":47.400000000000013},{"$f":"'Net-per cow per day'!E27*Input!$E$7","v":44.4375},-2.9625000000000128]
[null,null,"Total Variable Cost",{"$f":"SUM(D23:D27)","v":473.40000000000003},{"$f":"SUM(E23:E27)","v":443.8125},-29.587500000000034]
[null,null,"Feed Cost"]
[null,null,"Ration Cost",{"$f":"'Net-per cow per day'!D30*Input!$D$7","v":2677.5},{"$f":"'Net-per cow per day'!E30*Input!$E$7","v":2550.0000000000005},-127.49999999999955]
[null,null,"Total Cost",{"$f":"D28+D30","v":3150.9},{"$f":"E28+E30","v":2993.8125000000005},-157.08749999999964]
[null,null,"Net Return",{"$f":"D21-D31","v":10296.336000000003},{"$f":"E21-E31","v":10360.317187500001},63.981187499997759]
[]
[null,null,"1PPD equals producer price differential used in federal order minimum pricing."]
[null,null,"2Utilities used to cool milk."]

{"sheet":"Net-per herd per year","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Annual Comparison (herd)"]
[]
[null,null,null,{"$f":"Input!$D$4","v":"Current"},{"$f":"Input!$E$4","v":"New"},{"$f":"Input!H5","v":"New Ration"}]
[null,null,"Item (per cow/day)","Ration","Ration",{"$f":"Input!H6","v":"vs. Current"}]
[null,null,"Component"]
[null,null,"Butterfat (lbs.)",{"$f":"'Net-per herd per day'!D7*365","v":744600.00000000012},{"$f":"'Net-per herd per day'!E7*365","v":749390.625},{"$f":"E7-D7","v":4790.6249999998836}]
[null,null,"Milk Protein (lbs.)",{"$f":"'Net-per herd per day'!D8*365","v":613200.00000000012},{"$f":"'Net-per herd per day'!E8*365","v":615937.5},{"$f":"E8-D8","v":2737.4999999998836}]
[null,null,"Other Solids (lbs.)",{"$f":"'Net-per herd per day'!D9*365","v":1248300.0000000002},{"$f":"'Net-per herd per day'!E9*365","v":1170281.2500000002},-78018.75]
[null,null,"Component Revenue"]
[null,null,"Butterfat ($)",{"$f":"'Net-per herd per day'!D11*365","v":1676169.0600000003},{"$f":"'Net-per herd per day'!E11*365","v":1686953.2359374999},10784.175937499618]
[null,null,"Milk protein ($)",{"$f":"'Net-per herd per day'!D12*365","v":2348065.4400000004},{"$f":"'Net-per herd per day'!E12*365","v":2358547.875},10482.43499999959]
[null,null,"Other solids ($)",{"$f":"'Net-per herd per day'!D13*365","v":450386.64000000007},{"$f":"'Net-per herd per day'!E13*365","v":422237.47500000003},-28149.165000000037]
[null,null,"Total Component Revenue",{"$f":"SUM(D11:D13)","v":4474621.1400000006},{"$f":"SUM(E11:E13)","v":4467738.5859375},-6882.554062500596]
[null,null,"Premium Revenue"]
[null,null,"PPD1 ($)",{"$f":"'Net-per herd per day'!D16*365","v":324120.00000000006},{"$f":"'Net-per herd per day'!E16*365","v":303862.50000000006},-20257.5]
[null,null,"Volume Premium ($)",{"$f":"'Net-per herd per day'!D17*365","v":87600},{"$f":"'Net-per herd per day'!E17*365","v":82125},-5475]
[null,null,"Quality Premium ($)",{"$f":"'Net-per herd per day'!D18*365","v":21900},{"$f":"'Net-per herd per day'!E18*365","v":20531.25},-1368.75]
[null,null,"Other Premium ($)",{"$f":"'Net-per herd per day'!D19*365","v":0},{"$f":"'Net-per herd per day'!E19*365","v":0},0]
[null,null,"Total Premium Revenue",{"$f":"SUM(D16:D19)","v":433620.00000000006},{"$f":"SUM(E16:E19)","v":406518.75000000006},-27101.25]
[null,null,"Total Revenue",{"$f":"D14+D20","v":4908241.1400000006},{"$f":"E14+E20","v":4874257.3359375},{"$f":"E21-D21","v":-33983.804062500596}]
[null,null,"Variable Costs"]
[null,null,"Milk Hauling ($)",{"$f":"'Net-per herd per day'!D23*365","v":98550},{"$f":"'Net-per herd per day'!E23*365","v":92390.625000000015},-6159.3749999999854]
[null,null,"Promotion ($)",{"$f":"'Net-per herd per day'!D24*365","v":32850},{"$f":"'Net-per herd per day'!E24*365","v":30796.875},-2053.125]
[null,null,"Co-op Dues ($)",{"$f":"'Net-per herd per day'!D25*365","v":2190},{"$f":"'Net-per herd per day'!E25*365","v":2053.125},-136.875]
[null,null,"Other Deductions ($)",{"$f":"'Net-per herd per day'!D26*365","v":21900},{"$f":"'Net-per herd per day'!E26*365","v":20531.25},-1368.75]
[null,null,"Utilities2 ($)",{"$f":"'Net-per herd per day'!D27*365","v":17301.000000000004},{"$f":"'Net-per herd per day'!E27*365","v":16219.6875},-1081.3125000000036]
[null,null,"Total Variable Cost",{"$f":"SUM(D23:D27)","v":172791},{"$f":"SUM(E23:E27)","v":161991.5625},-10799.4375]
[null,null,"Feed Cost"]
[null,null,"Ration Cost",{"$f":"'Net-per herd per day'!D30*365","v":977287.5},{"$f":"'Net-per herd per day'!E30*365","v":930750.00000000012},-46537.499999999884]
[null,null,"Total Cost",{"$f":"D28+D30","v":1150078.5},{"$f":"E28+E30","v":1092741.5625},-57336.9375]
[null,null,"Net Return",{"$f":"D21-D31","v":3758162.6400000006},{"$f":"E21-E31","v":3781515.7734375},23353.133437499404]
[]
[null,null,"1PPD equals producer price differential used in federal order minimum pricing."]
[null,null,"2Utilities used to cool milk."]