{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Introduction","2022","2021","2020","2019","2018","2017","2016","2015","2014","2013","2012","2011","2010","2009"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":14,"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":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,1,43,13],[44,1,44,13],[8,8,8,13],[42,1,42,13],[8,1,8,6],[4,1,4,13],[5,1,5,12],[11,4,11,9],[6,8,6,13],[12,4,12,9],[7,8,7,13],[6,1,6,6],[7,1,7,6]]}
[]
[]
[]
[]
[null,"Dairy Margin Coverage"]
[null,"Version 4.0"]
[null,"Andrew P. Griffith",null,null,null,null,null,null,"Becky Bowling"]
[null,"Associate Professor",null,null,null,null,null,null,"Extension Specialist I"]
[null,"Email: agriff14@utk.edu",null,null,null,null,null,null,"Email: bowling10@utk.edu"]
[]
[]
[null,null,null,null,"Jason Fewell"]
[null,null,null,null,"Former Assistant Professor"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Programs in agriculture and natural resources, 4-H youth development, family and consumer sciences, and resource development."]
[null,"University of Tennessee Institute of Agriculture, U.S. Department of Agriculture and country governments cooperating."]
[null,"UT Extension provide equal opportunities in programs and employment."]

{"sheet":"2022","index":1,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Coverage Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2022,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2019,null,"lbs",null,"All milk price ($/cwt)",24.2,24.7,25.9,27.1]
[null,2020,null,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2021,null,"lbs",null,"Monthly national avg price received for corn ($/bu)",5.57,6.1,6.56,7.08,null,null,null,null,null,null,null,null,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",421.21,480.96,493.98,476.7,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":0},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",262,266,269,271]
[null,null,{"$f":"C10/100","v":0},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":24.2},24.7,25.9,27.1,0,0,0,0,0,0,0,0]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",8,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":5.9754960000000006},6.5440799999999992,7.0375679999999994,7.5954239999999995,0,0,0,0,0,0,0,0]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":3.0958934999999999},3.5350559999999995,3.6307529999999999,3.5037449999999999,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":3.5893999999999999},3.6442000000000001,3.6853000000000002,3.7126999999999999,0,0,0,0,0,0,0,0]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":12.6607895},13.723335999999998,14.353620999999999,14.811869,0,0,0,0,0,0,0,0]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":11.539210499999999},10.976664000000001,11.546379,12.288131000000002,0,0,0,0,0,0,0,0]
[null,"Annual Premium cost to participate in DMC",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":0}]
[null,"Total annual cost to participate in DMC",{"$f":"C3+C21","v":100}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":8},{"$f":"$C$14","v":8},8,8,8,8,8,8,8,8,8,8]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":-2.0392104999999994},-1.4766640000000013,-2.0463789999999999,-2.7881310000000017,0,0,0,0,0,0,0,0]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-3.5392104999999994},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":-2.9766640000000013},-3.5463789999999999,-4.2881310000000017,0,0,0,0,0,0,0,0]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":0},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":0}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Dairy Margin Payment",{"$f":"SUM(G41:G52)","v":0}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":100}]
[null,null,null,null,null,"Annual return to participating in DMC",{"$f":"G54-G56","v":-100}]

{"sheet":"2021","index":2,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Coverage Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2021,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2018,null,"lbs",null,"All milk price ($/cwt)",17.5,17.100000000000001,17.399999999999999,18.399999999999999,19.2,18.399999999999999,17.899999999999999,17.7,18.399999999999999,19.7,20.8,21.8]
[null,2019,null,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2020,null,"lbs",null,"Monthly national avg price received for corn ($/bu)",4.24,4.75,4.8899999999999997,5.31,5.91,6,6.12,6.32,5.47,5.0199999999999996,5.27,5.47,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",439.24,427.28,410.02,413.36,421.03,378.18,365.23,358.21,343.55,325.43,358.73,399.53,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":0},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",206,211,210,211,226,230,232,238,244,247,246,253]
[null,null,{"$f":"C10/100","v":0},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":17.5},17.100000000000001,17.399999999999999,18.399999999999999,19.2,18.399999999999999,17.899999999999999,17.7,18.399999999999999,19.7,20.8,21.8]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",8,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":4.5486719999999998},5.0957999999999997,5.2459919999999993,5.6965679999999992,6.3402479999999999,6.4367999999999999,6.5655359999999998,6.7800960000000003,5.8682159999999994,5.3854559999999996,5.6536559999999998,5.8682159999999994]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":3.2284139999999999},3.1405079999999996,3.0136469999999997,3.0381960000000001,3.0945704999999997,2.779623,2.6844405,2.6328434999999999,2.5250925,2.3919104999999998,2.6366654999999999,2.9365454999999998]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.8222},2.8907000000000003,2.8770000000000002,2.8907000000000003,3.0962000000000001,3.1510000000000002,3.1783999999999999,3.2606000000000002,3.3428,3.3839000000000001,3.3702000000000001,3.4661]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":10.599285999999999},11.127008,11.136639000000001,11.625463999999999,12.531018499999998,12.367422999999999,12.428376499999999,12.6735395,11.7361085,11.1612665,11.6605215,12.270861499999999]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":6.9007140000000007},5.9729920000000014,6.263360999999998,6.7745359999999994,6.668981500000001,6.0325769999999999,5.4716234999999998,5.0264604999999989,6.6638914999999983,8.5387334999999993,9.1394785000000009,9.529138500000002]
[null,"Annual Premium cost to participate in DMC",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":0}]
[null,"Total annual cost to participate in DMC",{"$f":"C3+C21","v":100}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":8},{"$f":"$C$14","v":8},8,8,8,8,8,8,8,8,8,8]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":2.5992859999999993},3.5270079999999986,3.236639000000002,2.7254640000000006,2.831018499999999,3.4674230000000001,4.0283765000000002,4.4735395000000011,2.8361085000000017,0.96126650000000069,0.36052149999999905,-2.9138500000001955E-2]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":1.0992859999999993},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":2.0270079999999986},1.736639000000002,1.2254640000000006,1.331018499999999,1.9674230000000001,2.5283765000000002,2.9735395000000011,1.3361085000000017,-0.53873349999999931,-1.1394785000000009,-1.529138500000002]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":0},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":0}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Dairy Margin Payment",{"$f":"SUM(G41:G52)","v":0}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":100}]
[null,null,null,null,null,"Annual return to participating in DMC",{"$f":"G54-G56","v":-100}]

{"sheet":"2020","index":3,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Coverage Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2020,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2017,null,"lbs",null,"All milk price ($/cwt)",19.600000000000001,18.899999999999999,18,14.4,13.6,18.100000000000001,20.5,18.8,17.899999999999999,20.2,21.3,18.5]
[null,2018,null,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2019,null,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.79,3.78,3.68,3.29,3.2,3.16,3.21,3.12,3.41,3.61,3.79,3.97,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",300.11,295.27999999999997,312.38,295.39,288.56,288.66000000000003,291.25,290.18,319.99,367.11,387.83,396.68,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":0},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",210,210,205,209,211,201,192,192,192,194,200,203]
[null,null,{"$f":"C10/100","v":0},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":19.600000000000001},18.899999999999999,18,14.4,13.6,18.100000000000001,20.5,18.8,17.899999999999999,20.2,21.3,18.5]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",7,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":4.065912},4.0551839999999997,3.9479040000000003,3.529512,3.43296,3.3900480000000002,3.4436879999999999,3.3471359999999999,3.6582479999999999,3.8728079999999996,4.065912,4.2590159999999999]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.2058084999999998},2.1703079999999999,2.2959929999999997,2.1711164999999997,2.1209159999999998,2.121651,2.1406874999999999,2.1328230000000001,2.3519264999999998,2.6982585000000001,2.8505504999999998,2.9155980000000001]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.8770000000000002},2.8770000000000002,2.8085,2.8633000000000002,2.8907000000000003,2.7537000000000003,2.6303999999999998,2.6303999999999998,2.6303999999999998,2.6577999999999999,2.74,2.7810999999999999]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":9.1487204999999996},9.1024919999999998,9.0523970000000009,8.5639284999999994,8.4445759999999996,8.2653990000000004,8.2147755,8.110358999999999,8.6405744999999996,9.2288664999999988,9.6564624999999999,9.9557140000000004]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.107},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":10.451279500000002},9.7975079999999988,8.9476029999999991,5.836071500000001,5.155424,9.834601000000001,12.2852245,10.689641000000002,9.259425499999999,10.971133500000001,11.643537500000001,8.5442859999999996]
[null,"Annual Premium cost to participate in DMC",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":0}]
[null,"Total annual cost to participate in DMC",{"$f":"C3+C21","v":100}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":7},{"$f":"$C$14","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":-0.95127950000000183},-0.29750799999999877,0.55239700000000092,3.663928499999999,4.344576,-0.33460100000000104,-2.7852245,-1.1896410000000017,0.24057450000000102,-1.4711335000000005,-2.1435375000000008,0.9557140000000004]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-3.4512795000000018},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":-2.7975079999999988},-1.9476029999999991,1.163928499999999,1.844576,-2.834601000000001,-5.2852245,-3.6896410000000017,-2.259425499999999,-3.9711335000000005,-4.6435375000000008,-1.5442859999999996]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":0},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":0}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Dairy Margin Payment",{"$f":"SUM(G41:G52)","v":0}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":100}]
[null,null,null,null,null,"Annual return to participating in DMC",{"$f":"G54-G56","v":-100}]

{"sheet":"2019","index":4,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Coverage Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2019,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2016,null,"lbs",null,"All milk price ($/cwt)",16.600000000000001,16.8,17.5,17.7,18,18.100000000000001,18.7,18.899999999999999,19.3,19.899999999999999,21,20.7]
[null,2017,null,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2018,null,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.56,3.6,3.61,3.52,3.63,3.98,4.16,3.93,3.8,3.84,3.68,3.71,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",314.92,306.83,306.38,304.26,297.52,324.75,310.77,296.42,295.57,309.48,303.13,299.58999999999997,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":0},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",201,202.5,198.5,209,213,205,196,193.5,192.5,192,191,187.5]
[null,null,{"$f":"C10/100","v":0},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":16.600000000000001},16.8,17.5,17.7,18,18.100000000000001,18.7,18.899999999999999,19.3,19.899999999999999,21,20.7]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",7,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":3.8191679999999999},3.8620800000000002,3.8728079999999996,3.7762560000000001,3.8942639999999997,4.2697440000000002,4.4628480000000001,4.2161040000000005,4.0766399999999994,4.1195519999999997,3.9479040000000003,3.9800879999999998]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.3146620000000002},2.2552004999999999,2.2518929999999999,2.2363109999999997,2.1867719999999999,2.3869124999999998,2.2841594999999999,2.178687,2.1724394999999999,2.2746780000000002,2.2280055000000001,2.2019864999999998]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.7537000000000003},2.7742499999999999,2.7194500000000001,2.8633000000000002,2.9180999999999999,2.8085,2.6852,2.6509499999999999,2.6372499999999999,2.6303999999999998,2.6167000000000002,2.5687500000000001]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":8.8875299999999999},8.8915305,8.8441510000000001,8.8758669999999995,8.999136,9.4651565000000009,9.4322075000000005,9.0457409999999996,8.8863294999999987,9.0246300000000002,8.7926095000000011,8.7508245000000002]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.107},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":7.7124700000000015},7.9084695000000007,8.6558489999999999,8.8241329999999998,9.000864,8.6348435000000006,9.2677924999999988,9.854258999999999,10.413670500000002,10.875369999999998,12.207390499999999,11.949175499999999]
[null,"Annual Premium cost to participate in DMC",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":0}]
[null,"Total annual cost to participate in DMC",{"$f":"C3+C21","v":100}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":7},{"$f":"$C$14","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":1.7875299999999985},1.5915304999999993,0.8441510000000001,0.67586700000000022,0.49913600000000002,0.86515649999999944,0.23220750000000123,-0.35425899999999899,-0.91367050000000205,-1.3753699999999984,-2.7073904999999989,-2.4491754999999991]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-0.71247000000000149},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":-0.90846950000000071},-1.6558489999999999,-1.8241329999999998,-2.000864,-1.6348435000000006,-2.2677924999999988,-2.854258999999999,-3.4136705000000021,-3.8753699999999984,-5.2073904999999989,-4.9491754999999991]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":0},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":0}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Dairy Margin Payment",{"$f":"SUM(G41:G52)","v":0}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":100}]
[null,null,null,null,null,"Annual return to participating in DMC",{"$f":"G54-G56","v":-100}]

{"sheet":"2018","index":5,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2018,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2015,null,"lbs",null,"All milk price ($/cwt)",16.100000000000001,15.3,15.6,15.8,16.2,16.3,15.4,15.9,16.7,17.399999999999999,17,16.399999999999999]
[null,2016,null,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2017,null,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.29,3.38,3.51,3.58,3.67,3.58,3.47,3.36,3.39,3.41,3.41,3.54,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",322.58999999999997,362.85,379.85,385.84,393.55,355.71,341.08,332.5,318.32,319.14999999999998,310.62,311.7,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":0},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",152,155,166,183,189,181,179,177,180,178,175,180]
[null,null,{"$f":"C10/100","v":0},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":16.100000000000001},15.3,15.6,15.8,16.2,16.3,15.4,15.9,16.7,17.399999999999999,17,16.399999999999999]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",7,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":3.529512},3.626064,3.7655279999999998,3.840624,3.937176,3.840624,3.7226159999999999,3.6046079999999998,3.6367920000000002,3.6582479999999999,3.6582479999999999,3.7977119999999998]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.3710364999999998},2.6669475,2.7918975000000001,2.8359239999999999,2.8925925000000001,2.6144684999999996,2.5069379999999999,2.4438749999999998,2.3396520000000001,2.3457524999999997,2.2830569999999999,2.2909949999999997]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.0824000000000003},2.1234999999999999,2.2742,2.5070999999999999,2.5893000000000002,2.4797000000000002,2.4523000000000001,2.4249000000000001,2.4660000000000002,2.4386000000000001,2.3975,2.4660000000000002]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":7.9829484999999991},8.4165115000000004,8.8316254999999995,9.1836479999999998,9.4190684999999998,8.9347925000000004,8.6818540000000013,8.4733829999999983,8.4424440000000018,8.4426005000000011,8.3388050000000007,8.5547070000000005]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.107},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":8.1170515000000023},6.8834885000000003,6.7683745000000002,6.6163520000000009,6.7809314999999994,7.3652075000000004,6.7181459999999991,7.426617000000002,8.2575559999999975,8.9573994999999975,8.6611949999999993,7.8452929999999981]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":0}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":100}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":7},{"$f":"$C$14","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":1.3829484999999977},2.6165114999999997,2.7316254999999998,2.8836479999999991,2.7190685000000006,2.1347924999999996,2.7818540000000009,2.073382999999998,1.2424440000000025,0.54260050000000248,0.83880500000000069,1.6547070000000019]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-1.1170515000000023},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":0.11651149999999966},0.23162549999999982,0.3836479999999991,0.21906850000000055,-0.36520750000000035,0.28185400000000094,-0.42661700000000202,-1.2575559999999975,-1.9573994999999975,-1.6611949999999993,-0.84529299999999807]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":0},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":0}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":0}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":100}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":-100}]

{"sheet":"2017","index":6,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2017,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2014,10000000,"lbs",null,"All milk price ($/cwt)",18.899999999999999,18.5,17.3,16.5,16.7,17.3,17.3,18,17.8,17.899999999999999,18.100000000000001,17.2]
[null,2015,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2016,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.4,3.44,3.49,3.43,3.45,3.43,3.49,3.27,3.27,3.26,3.15,3.23,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",332.34,334.42,320.33999999999997,305.67,307.63,300.72000000000003,326.04000000000002,301.05,307.7,315.23,313.52,319.22000000000003,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",128,129,135,148,155,154,152,147,149,152,148,148]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":18.899999999999999},18.5,17.3,16.5,16.7,17.3,17.3,18,17.8,17.899999999999999,18.100000000000001,17.2]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",7,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":3.6475199999999997},3.6904319999999999,3.7440720000000001,3.6797040000000001,3.7011600000000002,3.6797040000000001,3.7440720000000001,3.5080559999999998,3.5080559999999998,3.4973279999999995,3.3793199999999999,3.465144]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.4426989999999997},2.4579870000000001,2.3544989999999997,2.2466745000000001,2.2610804999999998,2.2102919999999999,2.3963939999999999,2.2127175000000001,2.2615949999999998,2.3169404999999998,2.3043719999999999,2.3462670000000001]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":1.7536},1.7673000000000001,1.8495000000000001,2.0276000000000001,2.1234999999999999,2.1097999999999999,2.0824000000000003,2.0139,2.0413000000000001,2.0824000000000003,2.0276000000000001,2.0276000000000001]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":7.8438189999999999},7.9157190000000011,7.9480709999999997,7.9539784999999998,8.0857405,7.9997959999999999,8.2228659999999998,7.7346734999999995,7.8109509999999993,7.8966684999999988,7.7112920000000003,7.8390109999999993]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.107},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":11.056180999999999},10.584280999999999,9.3519290000000019,8.5460215000000002,8.6142594999999993,9.3002040000000008,9.0771340000000009,10.2653265,9.9890490000000014,10.0033315,10.388708000000001,9.360989]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":70224}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":70324}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":7},{"$f":"$C$14","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":-1.5561809999999987},-1.0842809999999989,0.14807099999999807,0.95397849999999984,0.88574050000000071,0.1997959999999992,0.42286599999999908,-0.76532650000000046,-0.4890490000000014,-0.50333149999999982,-0.88870800000000116,0.139011]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-4.0561809999999987},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":-3.5842809999999989},-2.3519290000000019,-1.5460215000000002,-1.6142594999999993,-2.3002040000000008,-2.0771340000000009,-3.2653265000000005,-2.9890490000000014,-3.0033314999999998,-3.3887080000000012,-2.360989]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":0},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":0},586.11437499999238,3776.1648958333321,3506.0561458333359,790.85916666666344,1673.8445833333296,0,0,0,0,550.25187500000004]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":586.11437499999238}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":3776.1648958333321}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":3506.0561458333359}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":790.85916666666344}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":1673.8445833333296}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":550.25187500000004}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":10883.291041666653}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":70324}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":-59440.708958333344}]

{"sheet":"2016","index":7,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2016,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2013,10000000,"lbs",null,"All milk price ($/cwt)",16.100000000000001,15.7,15.3,15,14.5,14.8,16.100000000000001,17.100000000000001,17.3,16.600000000000001,17.600000000000001,18.8]
[null,2014,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2015,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.66,3.57,3.57,3.58,3.68,3.82,3.6,3.21,3.22,3.29,3.23,3.33,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",279.56,273.61,276.22000000000003,303.81,376.35,408.57,371.49,340.8,337.95,323.27,322.41000000000003,321.02,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",147,142,144,153,147,142,140,138,137,135,130,129]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":16.100000000000001},15.7,15.3,15,14.5,14.8,16.100000000000001,17.100000000000001,17.3,16.600000000000001,17.600000000000001,18.8]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",7,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":3.9264480000000002},3.8298959999999997,3.8298959999999997,3.840624,3.9479040000000003,4.098096,3.8620800000000002,3.4436879999999999,3.4544160000000002,3.529512,3.465144,3.5724239999999998]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.0547659999999999},2.0110334999999999,2.0302169999999999,2.2330035000000001,2.7661725000000001,3.0029895,2.7304515,2.50488,2.4839324999999999,2.3760344999999998,2.3697135,2.3594969999999997]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.0139},1.9454,1.9728000000000001,2.0960999999999999,2.0139,1.9454,1.9180000000000001,1.8906000000000001,1.8769,1.8495000000000001,1.7810000000000001,1.7673000000000001]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":7.9951139999999992},7.7863294999999999,7.8329130000000005,8.1697275000000005,8.7279765000000005,9.0464854999999993,8.510531499999999,7.8391679999999999,7.8152485,7.7550464999999997,7.6158575000000006,7.6992209999999996]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.107},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":8.1048860000000023},7.9136704999999994,7.4670870000000003,6.8302724999999995,5.7720234999999995,5.7535145000000014,7.5894685000000024,9.2608320000000006,9.4847515000000016,8.8449535000000026,9.9841425000000008,11.100779000000001]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":70224}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":70324}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":7},{"$f":"$C$14","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":1.3951139999999977},1.5863295000000006,2.0329129999999997,2.6697275000000005,3.7279765000000005,3.7464854999999986,1.9105314999999976,0.23916799999999938,1.5248499999998444E-2,0.65504649999999742,-0.48414250000000081,-1.6007790000000011]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-1.1048860000000023},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":-0.91367049999999939},-0.46708700000000025,0.16972750000000048,1.2279765000000005,1.2464854999999986,-0.58946850000000239,-2.2608320000000006,-2.4847515000000016,-1.8449535000000026,-2.9841425000000008,-4.1007790000000011]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":5522.326249999991},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":6279.220937500002},8046.9472916666664,11373.876979166671,20589.462020833336,20750.644562499987,7562.5205208333236,946.7066666666642,60.358645833327166,2592.892395833323,0,0]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":5522.326249999991}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":6279.220937500002}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":8046.9472916666664}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":11373.876979166671}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":20589.462020833336}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":20750.644562499987}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":7562.5205208333236}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":946.7066666666642}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":60.358645833327166}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":2592.892395833323}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":83724.956270833296}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":70324}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":13400.956270833296}]

{"sheet":"2015","index":8,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2015,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2012,10000000,"lbs",null,"All milk price ($/cwt)",17.600000000000001,16.8,16.600000000000001,16.5,16.7,16.899999999999999,16.600000000000001,16.7,17.5,17.7,18.2,17.2]
[null,2013,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2014,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.81,3.79,3.81,3.75,3.62,3.58,3.8,3.68,3.68,3.67,3.6,3.65,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",380.02,370.38,357.83,336.61,320.23,335.03,375.71,357.85,333.62,327.97,308.60000000000002,289.77999999999997,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",174,172,172,184,192,178,169,159,157,156,150,150]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":17.600000000000001},16.8,16.600000000000001,16.5,16.7,16.899999999999999,16.600000000000001,16.7,17.5,17.7,18.2,17.2]
[]
[null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",9.5,"/cwt",null,"Average feed cost calculation:"]
[null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",7,"/cwt",null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":4.0873679999999997},4.065912,4.0873679999999997,4.0229999999999997,3.8835359999999999,3.840624,4.0766399999999994,3.9479040000000003,3.9479040000000003,3.937176,3.8620800000000002,3.9157199999999999]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.7931469999999998},2.7222930000000001,2.6300504999999998,2.4740834999999999,2.3536904999999999,2.4624704999999998,2.7614684999999999,2.6301975,2.4521069999999998,2.4105795000000003,2.2682100000000003,2.1298829999999995]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.3837999999999999},2.3564000000000003,2.3564000000000003,2.5207999999999999,2.6303999999999998,2.4386000000000001,2.3153000000000001,2.1783000000000001,2.1509,2.1372,2.0550000000000002,2.0550000000000002]
[null,"Locked coverage discount",null,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.15},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":9.2643149999999999},9.1446050000000003,9.0738184999999998,9.0178834999999999,8.8676265000000001,8.7416945000000013,9.1534084999999994,8.7564015000000008,8.5509109999999993,8.4849554999999999,8.1852900000000002,8.1006029999999996]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$14,C40:D48,2)*((100-C17)/100)","v":1.107},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":8.3356850000000016},7.6553950000000004,7.5261815000000016,7.4821165000000001,7.8323734999999992,8.1583054999999973,7.446591500000002,7.9435984999999985,8.9490890000000007,9.2150444999999994,10.014709999999999,9.0993969999999997]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":70224}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":70324}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt) up to 5,000,000 lbs.",{"$f":"$C$13","v":9.5},9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5,9.5]
[null,null,6,0.05,null,"Margin coverage level ($/cwt) over 5,000,000 lbs.",{"$f":"$C$14","v":7},{"$f":"$C$14","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,6.5,7.0000000000000007E-2,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,7,0.08]
[null,null,7.5,0.09,null,"Actual margin - Threshold margin up to 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":1.1643149999999984},1.8446049999999996,1.9738184999999984,2.0178834999999999,1.6676265000000008,1.3416945000000027,2.053408499999998,1.5564015000000015,0.55091099999999926,0.28495550000000058,-0.51470999999999911,0.40060300000000026]
[null,null,8,0.1,null,"Actual margin - Threshold margin over 5,000,000 lbs.",{"$f":"IF(G20=0,0,IFERROR(G30-G20,\"\"))","v":-1.3356850000000016},{"$f":"IF(H20=0,0,IFERROR(H30-H20,\"\"))","v":-0.65539500000000039},-0.52618150000000163,-0.48211650000000006,-0.83237349999999921,-1.1583054999999973,-0.44659150000000203,-0.94359849999999845,-1.9490890000000007,-2.2150444999999994,-3.0147099999999991,-2.0993969999999997]
[null,null,8.5,0.105]
[null,null,9,0.11,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(AND(G33>0,$C$11<=50000),G33*(G31/100)*$C$11/12,IF(AND(G33>0,$C$11>50000),G33*(G31/100)*50000/12+IF(AND(G34>0,$C$11>50000),G34*(G31/100)*($C$11-50000)/12,0),0)),0)","v":4608.7468749999935},{"$f":"IFERROR(IF(AND(H33>0,$C$11<=50000),H33*(H31/100)*$C$11/12,IF(AND(H33>0,$C$11>50000),H33*(H31/100)*50000/12+IF(AND(H34>0,$C$11>50000),H34*(H31/100)*($C$11-50000)/12,0),0)),0)","v":7301.5614583333308},7813.031562499993,7987.4555208333331,6601.0215625000028,5310.874062500011,8128.0753124999928,6160.7559375000055,2180.6893749999967,1127.948854166669,0,1585.7202083333343]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$36,0)","v":4608.7468749999935}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$36,0)","v":7301.5614583333308}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$36,0)","v":7813.031562499993}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$36,0)","v":7987.4555208333331}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$36,0)","v":6601.0215625000028}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$36,0)","v":5310.874062500011}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$36,0)","v":8128.0753124999928}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$36,0)","v":6160.7559375000055}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$36,0)","v":2180.6893749999967}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$36,0)","v":1127.948854166669}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$36,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$36,0)","v":1585.7202083333343}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":58805.88072916666}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":70324}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":-11518.11927083334}]

{"sheet":"2014","index":9,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2014,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2011,10000000,"lbs",null,"All milk price ($/cwt)",23.5,24.9,25.4,25.3,24.2,23.2,23.3,24.1,25.7,25.3,23,20.3]
[null,2012,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2013,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",4.42,4.3499999999999996,4.54,4.71,4.71,4.49,4.05,3.63,3.48,3.28,3.58,3.77,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",479.54,509.25,495.71,514.01,519.38,501.72,450.79,490.3,525.72,381.5,441.39,431.73,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",185,188,191,206,224,222,216,209,197,194,184,182]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":23.5},24.9,25.4,25.3,24.2,23.2,23.3,24.1,25.7,25.3,23,20.3]
[]
[null,"Margin coverage level ($/cwt)",8,"/cwt",null,"Average feed cost calculation:"]
[null,null,null,null,null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":4.7417759999999998},4.6666799999999995,4.8705119999999997,5.0528880000000003,5.0528880000000003,4.816872,4.3448399999999996,3.8942639999999997,3.7333439999999998,3.5187839999999997,3.840624,4.0444560000000003]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":3.5246189999999999},3.7429874999999999,3.6434684999999996,3.7779734999999999,3.8174429999999999,3.6876419999999999,3.3133064999999999,3.6037050000000002,3.864042,2.8040249999999998,3.2442164999999998,3.1732155]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.5345},2.5756000000000001,2.6167000000000002,2.8222,3.0688,3.0413999999999999,2.9592000000000001,2.8633000000000002,2.6989000000000001,2.6577999999999999,2.5207999999999999,2.4934000000000003]
[null,"Locked coverage discount",0,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.1},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":10.800894999999999},10.985267499999999,11.130680499999999,11.653061500000002,11.939131,11.545914,10.6173465,10.361269,10.296286,8.9806089999999994,9.6056404999999998,9.7110714999999992]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":12.699105000000001},13.9147325,14.2693195,13.646938499999999,12.260869,11.654086,12.682653500000001,13.738731000000001,15.403713999999999,16.319391000000003,13.3943595,10.588928500000002]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":108091}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":108191}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt)",{"$f":"$C$13","v":8},8,8,8,8,8,8,8,8,8,8,8]
[null,null,6,0.05,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,6.5,7.0000000000000007E-2]
[null,null,7,0.08,null,"Actual margin - Threshold margin",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":-4.6991050000000012},{"$f":"IF(H20=0,0,IFERROR(H29-H20,\"\"))","v":-5.9147324999999995},-6.2693194999999999,-5.6469384999999992,-4.2608689999999996,-3.6540859999999995,-4.6826535000000007,-5.7387310000000014,-7.403713999999999,-8.3193910000000031,-5.3943595000000002,-2.5889285000000015]
[null,null,7.5,0.09]
[null,null,8,0.1,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(G32>0,G32*(G30/100)*$C$11/6,0),0)","v":0},{"$f":"IFERROR(IF(H32>0,H32*(H30/100)*$C$11/6,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,8.5,0.105]
[null,null,9,0.11]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$34,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$34,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$34,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$34,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$34,0)","v":0}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$34,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$34,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$34,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$34,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$34,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$34,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$34,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":0}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":108191}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":-108191}]

{"sheet":"2013","index":10,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2013,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2010,10000000,"lbs",null,"All milk price ($/cwt)",19.899999999999999,19.5,19.100000000000001,19.5,19.7,19.5,19,19.5,20.100000000000001,20.7,21.6,22]
[null,2011,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2012,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",6.96,7.04,7.13,6.97,6.97,6.97,6.79,6.21,5.4,4.6100000000000003,4.3499999999999996,4.41,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",431.39,440.66500000000002,437.32499999999999,422.07,465.72,496.77499999999998,544.59,464.90499999999997,500.39,443.63,451.13,498.31,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",217,218,219,213,221,220,209,200,194,193,188,187]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":19.899999999999999},19.5,19.100000000000001,19.5,19.7,19.5,19,19.5,20.100000000000001,20.7,21.6,22]
[]
[null,"Margin coverage level ($/cwt)",8,"/cwt",null,"Average feed cost calculation:"]
[null,null,null,null,null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":7.4666879999999995},7.5525120000000001,7.6490640000000001,7.4774159999999998,7.4774159999999998,7.4774159999999998,7.2843119999999999,6.6620879999999998,5.79312,4.945608,4.6666799999999995,4.7310480000000004]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":3.1707164999999997},3.23888775,3.21433875,3.1022144999999997,3.4230420000000001,3.6512962499999997,4.0027365000000001,3.4170517499999997,3.6778664999999999,3.2606804999999999,3.3158054999999997,3.6625785]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.9729000000000001},2.9866000000000001,3.0003000000000002,2.9180999999999999,3.0277000000000003,3.0140000000000002,2.8633000000000002,2.74,2.6577999999999999,2.6440999999999999,2.5756000000000001,2.5619000000000001]
[null,"Locked coverage discount",0,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.1},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":13.610304499999998},13.777999749999999,13.863702750000002,13.497730499999999,13.928158,14.142712249999999,14.150348500000002,12.81913975,12.1287865,10.850388499999999,10.558085499999999,10.9555265]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":6.2896955000000005},5.7220002500000007,5.2362972499999998,6.0022695000000006,5.7718419999999995,5.3572877500000011,4.8496514999999984,6.6808602500000003,7.9712135000000011,9.8496115,11.041914500000003,11.0444735]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":108091}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":108191}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt)",{"$f":"$C$13","v":8},8,8,8,8,8,8,8,8,8,8,8]
[null,null,6,0.05,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,6.5,7.0000000000000007E-2]
[null,null,7,0.08,null,"Actual margin - Threshold margin",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":1.7103044999999995},{"$f":"IF(H20=0,0,IFERROR(H29-H20,\"\"))","v":2.2779997499999993},2.7637027500000002,1.9977304999999994,2.2281580000000005,2.6427122499999989,3.1503485000000016,1.3191397499999997,2.8786499999998938E-2,-1.8496115,-3.0419145000000025,-3.0444735000000005]
[null,null,7.5,0.09]
[null,null,8,0.1,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(G32>0,G32*(G30/100)*$C$11/6,0),0)","v":29787.803374999989},{"$f":"IFERROR(IF(H32>0,H32*(H30/100)*$C$11/6,0),0)","v":39675.16231249999},48134.489562499999,34793.806208333321,38807.085166666679,46027.23835416665,54868.569708333351,22975.017312499989,501.3648749999814,0,0,0]
[null,null,8.5,0.105]
[null,null,9,0.11]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$34,0)","v":29787.803374999989}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$34,0)","v":39675.16231249999}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$34,0)","v":48134.489562499999}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$34,0)","v":34793.806208333321}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$34,0)","v":38807.085166666679}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$34,0)","v":46027.23835416665}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$34,0)","v":54868.569708333351}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$34,0)","v":22975.017312499989}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$34,0)","v":501.3648749999814}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$34,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$34,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$34,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":315570.53687499993}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":108191}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":207379.53687499993}]

{"sheet":"2012","index":11,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2012,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2009,10000000,"lbs",null,"All milk price ($/cwt)",19,17.7,17.2,17.100000000000001,16.2,16.600000000000001,16.899999999999999,18.100000000000001,19.600000000000001,21.5,22,22.9]
[null,2010,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2011,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",6.07,6.28,6.35,6.34,6.34,6.37,7.14,7.63,6.89,6.78,7.01,6.87,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",310.64999999999998,330.37,365.96,394.3,415.17,422.6,515.83000000000004,564.69000000000005,529.37,488.46,466.16,460.09,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",193,194,200,210,215,205,203,203,206,212,215,217]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":19},17.7,17.2,17.100000000000001,16.2,16.600000000000001,16.899999999999999,18.100000000000001,19.600000000000001,21.5,22,22.9]
[]
[null,"Margin coverage level ($/cwt)",8,"/cwt",null,"Average feed cost calculation:"]
[null,null,null,null,null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":6.5118960000000001},6.7371840000000001,6.8122799999999994,6.801552,6.801552,6.833736,7.6597919999999995,8.1854639999999996,7.3915919999999993,7.2735840000000005,7.5203279999999992,7.3701359999999996]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.2832774999999996},2.4282195,2.6898059999999999,2.8981050000000002,3.0514994999999998,3.1061100000000001,3.7913505000000001,4.1504715000000001,3.8908695,3.5901809999999998,3.4262760000000001,3.3816614999999999]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.6440999999999999},2.6577999999999999,2.74,2.8770000000000002,2.9455,2.8085,2.7810999999999999,2.7810999999999999,2.8222,2.9043999999999999,2.9455,2.9729000000000001]
[null,"Locked coverage discount",0,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.1},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":11.439273500000001},11.8232035,12.242085999999999,12.576657000000001,12.798551499999999,12.748346,14.2322425,15.1170355,14.104661500000001,13.768165,13.892104,13.724697499999998]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":7.5607264999999995},5.8767964999999993,4.9579140000000006,4.5233430000000006,3.4014485000000008,3.8516540000000017,2.6677574999999987,2.9829645000000014,5.4953385000000008,7.7318350000000002,8.1078960000000002,9.1753025000000008]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":108091}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":108191}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt)",{"$f":"$C$13","v":8},8,8,8,8,8,8,8,8,8,8,8]
[null,null,6,0.05,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,6.5,7.0000000000000007E-2]
[null,null,7,0.08,null,"Actual margin - Threshold margin",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":0.43927350000000054},{"$f":"IF(H20=0,0,IFERROR(H29-H20,\"\"))","v":2.1232035000000007},3.0420859999999994,3.4766569999999994,4.5985514999999992,4.1483459999999983,5.3322425000000013,5.0170354999999986,2.5046614999999992,0.26816499999999976,-0.10789600000000021,-1.1753025000000008]
[null,null,7.5,0.09]
[null,null,8,0.1,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(G32>0,G32*(G30/100)*$C$11/6,0),0)","v":7650.680125000009},{"$f":"IFERROR(IF(H32>0,H32*(H30/100)*$C$11/6,0),0)","v":36979.127625000008},52982.997833333327,60551.776083333323,80091.438624999981,72250.359499999977,92869.890208333367,87380.034958333315,43622.854458333321,4670.5404166666622,0,0]
[null,null,8.5,0.105]
[null,null,9,0.11]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$34,0)","v":7650.680125000009}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$34,0)","v":36979.127625000008}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$34,0)","v":52982.997833333327}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$34,0)","v":60551.776083333323}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$34,0)","v":80091.438624999981}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$34,0)","v":72250.359499999977}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$34,0)","v":92869.890208333367}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$34,0)","v":87380.034958333315}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$34,0)","v":43622.854458333321}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$34,0)","v":4670.5404166666622}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$34,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$34,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":539049.69983333326}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":108191}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":430858.69983333326}]

{"sheet":"2011","index":12,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2011,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2008,10000000,"lbs",null,"All milk price ($/cwt)",16.7,19.100000000000001,20.399999999999999,19.600000000000001,19.600000000000001,21.1,21.9,22,21.1,19.899999999999999,20.399999999999999,19.8]
[null,2009,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2010,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",4.9400000000000004,5.65,5.53,6.36,6.32,6.38,6.33,6.88,6.38,5.73,5.83,5.86,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",368.54,358.59,345.43,335.87,342.3,347.45,346.52,349.6,336.32,301.45,292.21499999999997,281.65499999999997,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",121,129,142,161,191,185,198,196,198,204,193,195]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":16.7},19.100000000000001,20.399999999999999,19.600000000000001,19.600000000000001,21.1,21.9,22,21.1,19.899999999999999,20.399999999999999,19.8]
[]
[null,"Margin coverage level ($/cwt)",8,"/cwt",null,"Average feed cost calculation:"]
[null,null,null,null,null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":5.2996319999999999},6.0613200000000003,5.9325840000000003,6.8230080000000006,6.7800960000000003,6.8444639999999994,6.7908239999999997,7.3808639999999999,6.8444639999999994,6.1471439999999999,6.2544240000000002,6.2866080000000002]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.7087690000000002},2.6356364999999999,2.5389105000000001,2.4686444999999999,2.5159050000000001,2.5537574999999997,2.5469219999999999,2.5695600000000001,2.4719519999999999,2.2156574999999998,2.1477802499999998,2.0701642499999999]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":1.6577},1.7673000000000001,1.9454,2.2057000000000002,2.6167000000000002,2.5345,2.7126000000000001,2.6852,2.7126000000000001,2.7948,2.6440999999999999,2.6715]
[null,"Locked coverage discount",0,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.1},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":9.6661009999999994},10.464256500000001,10.4168945,11.497352500000002,11.912701,11.932721499999998,12.050345999999999,12.635624,12.029016,11.1576015,11.04630425,11.028272250000001]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":7.0338989999999999},8.6357435000000002,9.9831054999999989,8.1026474999999998,7.6872990000000012,9.1672785000000037,9.8496539999999992,9.364376,9.070984000000001,8.7423984999999984,9.3536957499999982,8.7717277500000002]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":108091}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":108191}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt)",{"$f":"$C$13","v":8},8,8,8,8,8,8,8,8,8,8,8]
[null,null,6,0.05,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,6.5,7.0000000000000007E-2]
[null,null,7,0.08,null,"Actual margin - Threshold margin",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":0.9661010000000001},{"$f":"IF(H20=0,0,IFERROR(H29-H20,\"\"))","v":-0.63574350000000024},-1.9831054999999989,-0.10264749999999978,0.31270099999999879,-1.1672785000000037,-1.8496539999999992,-1.364376,-1.070984000000001,-0.74239849999999841,-1.3536957499999982,-0.77172775000000016]
[null,null,7.5,0.09]
[null,null,8,0.1,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(G32>0,G32*(G30/100)*$C$11/6,0),0)","v":16826.259083333334},{"$f":"IFERROR(IF(H32>0,H32*(H30/100)*$C$11/6,0),0)","v":0},0,0,5446.2090833333123,0,0,0,0,0,0,0]
[null,null,8.5,0.105]
[null,null,9,0.11]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$34,0)","v":16826.259083333334}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$34,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$34,0)","v":0}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$34,0)","v":0}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$34,0)","v":5446.2090833333123}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$34,0)","v":0}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$34,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$34,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$34,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$34,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$34,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$34,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":22272.468166666647}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":108191}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":-85918.531833333356}]

{"sheet":"2010","index":13,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2009,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2006,10000000,"lbs",null,"All milk price ($/cwt)",16.100000000000001,15.9,14.8,14.6,15.1,15.5,16,16.7,17.7,18.5,17.899999999999999,16.7]
[null,2007,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2008,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",3.66,3.55,3.55,3.41,3.48,3.41,3.49,3.65,4.08,4.32,4.55,4.82,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",314.23,295.79000000000002,277.61,291.20999999999998,287.85000000000002,305.77999999999997,325.56,331.76,317.64999999999998,321.92,341.78,351.93,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",113,111,111,113,121,119,117,116,117,118,117,121]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":16.100000000000001},15.9,14.8,14.6,15.1,15.5,16,16.7,17.7,18.5,17.899999999999999,16.7]
[]
[null,"Margin coverage level ($/cwt)",8,"/cwt",null,"Average feed cost calculation:"]
[null,null,null,null,null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":3.9264480000000002},3.8084399999999996,3.8084399999999996,3.6582479999999999,3.7333439999999998,3.6582479999999999,3.7440720000000001,3.9157199999999999,4.3770239999999996,4.6344960000000004,4.88124,5.1708959999999999]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.3095905000000001},2.1740565000000003,2.0404335000000002,2.1403934999999996,2.1156975,2.2474829999999999,2.3928660000000002,2.4384359999999998,2.3347274999999996,2.3661120000000002,2.5120829999999996,2.5866854999999997]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":1.5481},1.5206999999999999,1.5206999999999999,1.5481,1.6577,1.6303000000000001,1.6029,1.5891999999999999,1.6029,1.6166,1.6029,1.6577]
[null,"Locked coverage discount",0,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.1},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":7.7841385000000001},7.5031964999999996,7.3695734999999996,7.3467414999999994,7.5067415000000004,7.5360309999999995,7.7398380000000007,7.9433559999999996,8.3146515000000001,8.6172080000000015,8.9962230000000005,9.415281499999999]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":8.3158615000000005},8.3968035000000008,7.4304265000000012,7.2532585000000003,7.5932584999999992,7.9639690000000005,8.2601619999999993,8.7566439999999997,9.3853484999999992,9.8827919999999985,8.9037769999999981,7.2847185000000003]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":108091}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":108191}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt)",{"$f":"$C$13","v":8},8,8,8,8,8,8,8,8,8,8,8]
[null,null,6,0.05,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,6.5,7.0000000000000007E-2]
[null,null,7,0.08,null,"Actual margin - Threshold margin",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":-0.31586150000000046},{"$f":"IF(H20=0,0,IFERROR(H29-H20,\"\"))","v":-0.39680350000000075},0.56957349999999884,0.74674149999999972,0.40674150000000076,3.603099999999948E-2,-0.26016199999999934,-0.75664399999999965,-1.3853484999999992,-1.8827919999999985,-0.90377699999999805,0.71528149999999968]
[null,null,7.5,0.09]
[null,null,8,0.1,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(G32>0,G32*(G30/100)*$C$11/6,0),0)","v":0},{"$f":"IFERROR(IF(H32>0,H32*(H30/100)*$C$11/6,0),0)","v":0},9920.0717916666454,13005.747791666661,7084.0811250000124,627.53991666665752,0,0,0,0,0,12457.819458333326]
[null,null,8.5,0.105]
[null,null,9,0.11]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$34,0)","v":0}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$34,0)","v":0}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$34,0)","v":9920.0717916666454}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$34,0)","v":13005.747791666661}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$34,0)","v":7084.0811250000124}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$34,0)","v":627.53991666665752}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$34,0)","v":0}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$34,0)","v":0}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$34,0)","v":0}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$34,0)","v":0}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$34,0)","v":0}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$34,0)","v":12457.819458333326}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":43095.260083333305}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":108191}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":-65095.739916666695}]

{"sheet":"2009","index":14,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,5,37,17],[38,5,38,17],[0,1,0,4],[1,1,1,3],[1,5,1,17],[2,5,2,17],[25,5,25,17],[26,5,26,17]]}
[null,"****Users may type over the default values in the blue boxes****"]
[null,"Dairy Margin Protection Program"]
[null,"Participation fee",100,null,null,"Actual Dairy Production Margin Calculation"]
[null,null,null,null,null,2019,"January","February","March","April","May","June","July","August","September","October","November","December",null,"See comment"]
[null,"Production history for the past three years:",null,null,null,"See comment",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2016,10000000,"lbs",null,"All milk price ($/cwt)",13.3,11.6,11.8,11.9,11.6,11.3,11.3,12,12.9,14.2,15.3,16.5]
[null,2017,10500000,"lbs",null,"Average feed cost calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,2018,11000000,"lbs",null,"Monthly national avg price received for corn ($/bu)",4.3600000000000003,3.87,3.86,3.85,3.97,4.03,3.6,3.33,3.25,3.61,3.65,3.59,null,"http://www.ams.usda.gov/mnreports/gx_gr117.txt"]
[null,null,null,null,null,"Monthly avg price of central Ill. high protein soymeal ($/ton)",306.85000000000002,297.42,292.22000000000003,324.27,380.37,418.47,373.18,405.27,379.68,325.69,328.18,333.93,null,"http://usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do;jsessionid=F154BA78C7C50C021C8CA924EDB72FD5?documentID=1002"]
[null,"Maximum of last three years' production",{"$f":"MAX(C6:C8)","v":11000000},"lbs",null,"Monthly national avg price received for alfalfa ($/ton)",149,143,137,133,138,128,120,111,110,109,110,110]
[null,null,{"$f":"C10/100","v":110000},"cwt",null,"All milk price",{"$f":"IFERROR((G6),\"\")","v":13.3},11.6,11.8,11.9,11.6,11.3,11.3,12,12.9,14.2,15.3,16.5]
[]
[null,"Margin coverage level ($/cwt)",8,"/cwt",null,"Average feed cost calculation:"]
[null,null,null,null,null,"Cost for corn in $/cwt.",{"$f":"IFERROR((G8)*1.0728,\"\")","v":4.6774080000000007},4.1517359999999996,4.1410079999999994,4.13028,4.2590159999999999,4.3233839999999999,3.8620800000000002,3.5724239999999998,3.4866000000000001,3.8728079999999996,3.9157199999999999,3.8513519999999999]
[null,"Production coverage level (%)",95,"%",null,"Cost for soymeal in $/cwt.",{"$f":"IFERROR((G9)*0.00735,\"\")","v":2.2553475000000001},2.1860370000000002,2.1478170000000003,2.3833844999999996,2.7957195000000001,3.0757544999999999,2.7428729999999999,2.9787344999999998,2.790648,2.3938215,2.4121229999999998,2.4543854999999999]
[null,null,null,null,null,"Cost for alfalfa in $/cwt.",{"$f":"IFERROR((G10)*0.0137,\"\")","v":2.0413000000000001},1.9591000000000001,1.8769,1.8221000000000001,1.8906000000000001,1.7536,1.6440000000000001,1.5206999999999999,1.5070000000000001,1.4933000000000001,1.5070000000000001,1.5070000000000001]
[null,"Locked coverage discount",0,"%"]
[null,"Premiums for milk marketings up to 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C26:D37,2)*((100-C17)/100)","v":0.1},"/cwt",null,"Average feed cost in $/cwt.",{"$f":"IFERROR(SUM(G14:G16),\"\")","v":8.9740555000000004},8.2968729999999997,8.1657249999999983,8.3357644999999998,8.9453354999999988,9.1527384999999999,8.2489530000000002,8.0718584999999994,7.7842479999999998,7.7599295000000001,7.8348429999999993,7.812737499999999]
[null,"Premiums for milk marketings over 5,000,000 lbs.",{"$f":"VLOOKUP(C$13,C40:D48,2)*((100-C17)/100)","v":1.8129999999999999},"/cwt"]
[null,null,null,null,null,"Actual Dairy Production Margin",{"$f":"IFERROR(G11-G18,\"\")","v":4.3259445000000003},3.3031269999999999,3.6342750000000024,3.5642355000000006,2.6546645000000009,2.1472615000000008,3.0510470000000005,3.9281415000000006,5.1157520000000005,6.4400704999999991,7.4651570000000014,8.687262500000001]
[null,"Annual Premium cost to participate in MPP",{"$f":"IF(C10<5000001,C11*(C15/100)*C18,50000*(C15/100)*C18+(C11-50000)*(C15/100)*C19)","v":108091}]
[null,"Total annual cost to participate in MPP",{"$f":"C3+C21","v":108191}]
[]
[]
[null,"For milk marketings up to 5,000,000 lbs.","Coverage level","Premium ($/cwt)"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"Dairy Margin Coverage Payment Calculation"]
[null,null,5,5.0000000000000001E-3]
[null,null,5.5,0.03,null,"Margin coverage level ($/cwt)",{"$f":"$C$13","v":8},8,8,8,8,8,8,8,8,8,8,8]
[null,null,6,0.05,null,"Production coverage level (%)",{"$f":"$C$15","v":95},95,95,95,95,95,95,95,95,95,95,95]
[null,null,6.5,7.0000000000000007E-2]
[null,null,7,0.08,null,"Actual margin - Threshold margin",{"$f":"IF(G20=0,0,IFERROR(G29-G20,\"\"))","v":3.6740554999999997},{"$f":"IF(H20=0,0,IFERROR(H29-H20,\"\"))","v":4.6968730000000001},4.3657249999999976,4.4357644999999994,5.3453354999999991,5.8527384999999992,4.9489529999999995,4.0718584999999994,2.8842479999999995,1.5599295000000009,0.53484299999999863,-0.687262500000001]
[null,null,7.5,0.09]
[null,null,8,0.1,null,"Dairy Margin Coverage Payment",{"$f":"IFERROR(IF(G32>0,G32*(G30/100)*$C$11/6,0),0)","v":63989.799958333322},{"$f":"IFERROR(IF(H32>0,H32*(H30/100)*$C$11/6,0),0)","v":81803.871416666661},76036.377083333282,77256.231708333318,93097.926624999978,101935.19554166665,86194.264749999988,70918.202208333314,50233.985999999983,27168.772125000014,9315.1822499999762,0]
[null,null,8.5,0.105]
[null,null,9,0.11]
[null,null,9.5,0.15]
[null,null,null,null,null,"****Note that the DMC payment value below is the annual payment.****"]
[null,"For milk marketings over 5,000,000 lbs.","Coverage level","Premium ($/cwt)",null,"Annual Dairy Margin Coverage Payment"]
[null,null,4,0]
[null,null,4.5,2.5000000000000001E-3,null,"January",{"$f":"IFERROR(G$34,0)","v":63989.799958333322}]
[null,null,5,5.0000000000000001E-3,null,"February",{"$f":"IFERROR(H$34,0)","v":81803.871416666661}]
[null,null,5.5,0.1,null,"March",{"$f":"IFERROR(I$34,0)","v":76036.377083333282}]
[null,null,6,0.31,null,"April",{"$f":"IFERROR(J$34,0)","v":77256.231708333318}]
[null,null,6.5,0.65,null,"May",{"$f":"IFERROR(K$34,0)","v":93097.926624999978}]
[null,null,7,1.107,null,"June",{"$f":"IFERROR(L$34,0)","v":101935.19554166665}]
[{"$f":"TODAY()","v":"2022-06-06"},null,7.5,1.413,null,"July",{"$f":"IFERROR(M$34,0)","v":86194.264749999988}]
[null,null,8,1.8129999999999999,null,"August",{"$f":"IFERROR(N$34,0)","v":70918.202208333314}]
[null,null,null,null,null,"September",{"$f":"IFERROR(O$34,0)","v":50233.985999999983}]
[null,null,null,null,null,"October",{"$f":"IFERROR(P$34,0)","v":27168.772125000014}]
[null,null,null,null,null,"November",{"$f":"IFERROR(Q$34,0)","v":9315.1822499999762}]
[null,null,null,null,null,"December",{"$f":"IFERROR(R$34,0)","v":0}]
[]
[null,null,null,null,null,"Total Annual Margin Protection Payment",{"$f":"SUM(G41:G52)","v":737949.80966666644}]
[]
[null,null,null,null,null,"Cost to participate",{"$f":"C22","v":108191}]
[null,null,null,null,null,"Annual return to participating in MPP",{"$f":"G54-G56","v":629758.80966666644}]