{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Blank","Alfalfa","SWS Wheat","SWW Wheat","Potato"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":47,"comments":0,"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":"Blank","index":0,"n_rows":114,"n_cols":15,"rows_kept":114,"cut":false,"hidden":false,"merged":[[73,1,73,3],[73,4,73,8],[0,0,0,7],[71,1,71,3],[71,4,71,8],[72,1,72,3],[72,4,72,8],[74,1,74,3],[74,4,74,8],[75,1,75,3],[75,4,75,8],[76,1,76,3],[76,4,76,8],[92,1,92,11],[77,1,77,3],[77,4,77,8],[88,1,88,11],[89,1,89,11],[90,1,90,11],[91,1,91,11]]}
["Crop Description",null,null,null,null,null,null,null,null,"Number of acres:",null,1]
[]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Total ",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost",null,"Value",null,"Cost/Acre",null,null,"Instructions:"]
[]
[null,"Gross Returns",null,null,null,null,null,null,null,null,null,null,null,null,"Enter information in white cells.  "]
[null,null,null,null,null,null,null,null,null,{"$f":"L7*$L$1","v":0},null,{"$f":"D7*H7","v":0},null,null,"Values in blue cells are calculated."]
[null,null,null,null,null,null,null,null,null,{"$f":"L8*$L$1","v":0},null,{"$f":"D8*H8","v":0},null,null,"Enter number of acres in cell L1."]
[null,null,null,null,null,null,null,null,null,{"$f":"L9*$L$1","v":0},null,{"$f":"D9*H9","v":0}]
[null,"Total Gross Returns",null,null,null,null,null,null,null,{"$f":"SUM(J7:J9)","v":0},null,{"$f":"SUM(L7:L9)","v":0}]
[]
[null,"Operating Inputs",null,null,null,null,null,null,null,null,null,null,null,null,"Questions:"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":0},null,{"$f":"SUM(L15:L16)","v":0},null,null,"Ben Eborn"]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D15*H15","v":0},null,null,"Extension Ag Economist"]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D16*H16","v":0},null,null,"University of Idaho"]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,0,null,{"$f":"SUM(L19:L25)","v":0},null,null,"beborn@uidaho.edu"]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D19*H19","v":0},null,null,"(208) 847-0344"]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Pesticide:",null,null,null,null,null,null,null,0,null,{"$f":"SUM(L28:L33)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D28*H28","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Custom:",null,null,null,null,null,null,null,0,null,{"$f":"SUM(L36:L40)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D36*H36","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D37*H37","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D38*H38","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D39*H39","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D40*H40","v":0}]
[]
[null,"Irrigation",null,null,null,null,null,null,null,{"$f":"L42*$L$1","v":0},null,{"$f":"SUM(L43:L45)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D43*H43","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D44*H44","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D45*H45","v":0}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,0,null,{"$f":"SUM(L48:L52)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D48*H48","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D49*H49","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D50*H50","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"L51*$L$1","v":0},null,{"$f":"D51*H51","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D52*H52","v":0}]
[]
[null,"Labor:",null,null,null,null,null,null,null,0,null,{"$f":"SUM(L55:L57)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D55*H55","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D56*H56","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D57*H57","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,0,null,{"$f":"SUM(L60:L62)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D60*H60","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D61*H61","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D62*H62","v":0}]
[]
[null,"Interest on Operating Capital at",null,"###%",null,null,null,null,null,0]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,0,null,{"$f":"L14+L18+L27+L35+L47+L54+L59+L64+L42","v":0}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$f":"L66/D7","v":{"$error":"#DIV/0!"}}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,0,null,{"$f":"L10-L66","v":0}]
[]
[null,"Ownership Costs:"]
[null,"General Overhead",null,null,null,null,null,null,null,{"$f":"L72*$L$1","v":0}]
[null,"Land Rent",null,null,null,null,null,null,null,{"$f":"L73*$L$1","v":0}]
[null,"Management Fee",null,null,null,null,null,null,null,0]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,0]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,0]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"L80*$L$1","v":0},null,{"$f":"SUM(L71:L78)","v":0}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$f":"L80/D7","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,0,null,{"$f":"L66+L80","v":0}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$f":"L83/D7","v":{"$error":"#DIV/0!"}}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,0,null,{"$f":"L10-L83","v":0}]
[]
[null,"Notes:"]
[]
[]
[]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F98*(1-D96)","v":0},null,{"$f":"D7","v":0},null,{"$f":"F98*(1+H96)","v":0}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$66/D98","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$66/F98","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$66/H98","v":{"$error":"#DIV/0!"}}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$80/D98","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$80/F98","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$80/H98","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$83/D98","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$83/F98","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$83/H98","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F108*(1-D96)","v":0},null,{"$f":"H7","v":0},null,{"$f":"F108*(1+H96)","v":0}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$66/D108","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$66/F108","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$66/H108","v":{"$error":"#DIV/0!"}}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$80/D108","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$80/F108","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$80/H108","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$83/D108","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$83/F108","v":{"$error":"#DIV/0!"}},null,{"$f":"$L$83/H108","v":{"$error":"#DIV/0!"}}]

{"sheet":"Alfalfa","index":1,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[61,9,62,9],[61,11,62,11],[65,1,65,3],[65,4,65,8],[0,0,0,7],[63,1,63,3],[63,4,63,8],[64,1,64,3],[64,4,64,8],[61,0,62,8],[66,1,66,3],[66,4,66,8],[67,1,67,3],[67,4,67,8],[68,1,68,3],[68,4,68,8],[83,1,83,11],[84,1,84,11],[85,1,85,11],[69,1,69,3],[69,4,69,8],[70,1,70,3],[70,4,70,8],[81,1,81,11],[82,1,82,11]]}
["Alfalfa Hay - Treasure Valley - 2017",null,null,null,null,null,null,null,null,"Number of acres:",null,150]
[]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Total ",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost",null,"Value",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Alfalfa Hay",null,7.5,null,"ton",null,130,null,{"$f":"L7*$L$1","v":146250},null,{"$f":"D7*H7","v":975}]
[null,null,null,null,null,null,null,null,null,{"$f":"L8*$L$1","v":0},null,{"$f":"D8*H8","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Gross Returns",null,null,null,null,null,null,null,{"$f":"SUM(J7:J9)","v":146250},null,{"$f":"SUM(L7:L9)","v":975}]
[]
[null,"Operating Inputs"]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":10215},null,{"$f":"SUM(L15:L21)","v":68.099999999999994}]
[null,"Dry Nitrogen",null,15,null,"lb",null,0.4,null,900,null,{"$f":"D15*H15","v":6}]
[null,"Dry P2O5",null,75,null,"lb",null,0.38,null,4275,null,28.5]
[null,"K2O",null,80,null,"lb",null,0.31,null,3720,null,24.8]
[null,"Sulfur",null,40,null,"lb",null,0.22,null,1320,null,8.8000000000000007]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,2782.5,null,{"$f":"SUM(L24:L29)","v":18.55}]
[null,"Metribuzin 75DF",null,1,null,"lb",null,11.5,null,1725,null,{"$f":"D24*H24","v":11.5}]
[null,"Warrior II w/Zeon Tech",null,3,null,"fl oz",null,2.35,null,1057.5,null,7.0500000000000007]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,42525,null,{"$f":"SUM(L32:L36)","v":283.5}]
[null,"Custom Fertilize",null,1,null,"acre",null,7.75,null,1162.5,null,{"$f":"D32*H32","v":7.75}]
[null,"Custom Swath & Rake",null,4,null,"acre",null,23,null,13800,null,{"$f":"D33*H33","v":92}]
[null,"Custom Bale: 1-ton",null,7.5,null,"ton",null,18,null,20250,null,{"$f":"D34*H34","v":135}]
[null,"Custom Haul & Stack: 1-ton",null,7.5,null,"ton",null,6.5,null,7312.5,null,{"$f":"D35*H35","v":48.75}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D36*H36","v":0}]
[]
[null,"Irrigation:",null,null,null,null,null,null,null,8475,null,{"$f":"SUM(L39:L41)","v":56.5}]
[null,"Water Assessment",null,1,null,"acre",null,53.5,null,8025,null,{"$f":"D39*H39","v":53.5}]
[null,"Repairs - Conc. Ditch",null,1,null,"acre",null,3,null,450,null,{"$f":"D40*H40","v":3}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D41*H41","v":0}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,1880.55,null,{"$f":"SUM(L44:L48)","v":12.536999999999999}]
[null,"Fuel - Gas",null,1.28,null,"gal",null,2.5499999999999998,null,489.59999999999997,null,{"$f":"D44*H44","v":3.2639999999999998}]
[null,"Fuel - Diesel",null,1.65,null,"gal",null,2.35,null,581.625,null,{"$f":"D45*H45","v":3.8774999999999999}]
[null,"Fuel - Road Diesel",null,0.63,null,"gal",null,2.85,null,269.32499999999999,null,{"$f":"D46*H46","v":1.7955000000000001}]
[null,"Lube",null,1,null,"$",null,1.34,null,201,null,{"$f":"D47*H47","v":1.34}]
[null,"Machinery Repair",null,1,null,"$",null,2.2599999999999998,null,338.99999999999994,null,{"$f":"D48*H48","v":2.2599999999999998}]
[]
[null,"Labor:",null,null,null,null,null,null,null,13836.000000000002,null,{"$f":"SUM(L51:L53)","v":92.240000000000009}]
[null,"Equipment Operator Labor",null,1.2,null,"hrs",null,19.7,null,3545.9999999999995,null,{"$f":"D51*H51","v":23.639999999999997}]
[null,"Irrigation Labor",null,4.9000000000000004,null,"hrs",null,14,null,10290.000000000002,null,{"$f":"D52*H52","v":68.600000000000009}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D53*H53","v":0}]
[]
[null,"Interest on Operating Capital at 5.75%",null,6.25E-2,null,null,null,null,null,1672.5,null,11.15]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,81386.550000000032,null,{"$f":"SUM(L14:L55)-(L14+L23+L31+L38+L43+L50)","v":542.57700000000023}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,10851.540000000003,null,{"$f":"L57/D7","v":72.343600000000023}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,64863.449999999968,null,{"$f":"L10-L57","v":432.42299999999977}]
[]
["Alfalfa Hay - Treasure Valley - 2017",null,null,null,null,null,null,null,null,"Number of acres:",null,150]
[]
[null,"General Overhead",null,null,null,null,null,null,null,{"$f":"L64*$L$1","v":2100},null,14]
[null,"Land Rent",null,null,null,null,null,null,null,{"$f":"L65*$L$1","v":33750},null,225]
[null,"Management Fee",null,null,null,null,null,null,null,6750,null,45]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,206.99999999999997,null,1.38]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,3244.5,null,21.63]
[null,"Alfalfa Establishment - Est. Amort. Cost",null,null,null,null,null,null,null,9654,null,64.36]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"L73*$L$1","v":55705.5},null,{"$f":"SUM(L63:L71)","v":371.37}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,7427.4,null,{"$f":"L73/D7","v":49.515999999999998}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,137092.05000000005,null,{"$f":"L57+L73","v":913.94700000000023}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,18278.940000000006,null,{"$f":"L76/D7","v":121.85960000000003}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,9157.9499999999662,null,{"$f":"L10-L76","v":61.05299999999977}]
[]
[null,"Notes:"]
[]
[]
[]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F91*(1-D89)","v":6.75},null,{"$f":"D7","v":7.5},null,{"$f":"F91*(1+H89)","v":8.25}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$57/D91","v":80.381777777777813},null,{"$f":"$L$57/F91","v":72.343600000000023},null,{"$f":"$L$57/H91","v":65.766909090909124}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$73/D91","v":55.017777777777781},null,{"$f":"$L$73/F91","v":49.515999999999998},null,{"$f":"$L$73/H91","v":45.014545454545456}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$76/D91","v":135.39955555555559},null,{"$f":"$L$76/F91","v":121.85960000000003},null,{"$f":"$L$76/H91","v":110.78145454545458}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F101*(1-D89)","v":117},null,{"$f":"H7","v":130},null,{"$f":"F101*(1+H89)","v":143}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$57/D101","v":4.6374102564102584},null,{"$f":"$L$57/F101","v":4.1736692307692325},null,{"$f":"$L$57/H101","v":3.7942447552447569}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$73/D101","v":3.1741025641025642},null,{"$f":"$L$73/F101","v":2.8566923076923079},null,{"$f":"$L$73/H101","v":2.5969930069930069}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$76/D101","v":7.8115128205128226},null,{"$f":"$L$76/F101","v":7.0303615384615403},null,{"$f":"$L$76/H101","v":6.3912377622377639}]

{"sheet":"SWS Wheat","index":2,"n_rows":115,"n_cols":12,"rows_kept":115,"cut":false,"hidden":false,"merged":[[69,0,69,7],[71,1,71,3],[71,4,71,8],[72,1,72,3],[72,4,72,8],[0,0,0,7],[73,1,73,3],[73,4,73,8],[74,1,74,3],[74,4,74,8],[75,1,75,3],[75,4,75,8],[76,1,76,3],[76,4,76,8],[77,1,77,3],[77,4,77,8],[78,1,78,3],[78,4,78,8],[89,1,89,11],[90,1,90,11],[91,1,91,11],[92,1,92,11],[93,1,93,11]]}
["Soft White Spring Wheat - Treasure Valley - 2017",null,null,null,null,null,null,null,null,"Number of acres:",null,300]
[]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Total ",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost",null,"Value",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Soft White Wheat",null,110,null,"bu",null,4,null,{"$f":"L7*$L$1","v":132000},null,{"$f":"D7*H7","v":440}]
[null,null,null,null,null,null,null,null,null,{"$f":"L8*$L$1","v":0},null,{"$f":"D8*H8","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Gross Returns",null,null,null,null,null,null,null,{"$f":"SUM(J7:J9)","v":132000},null,{"$f":"SUM(L7:L9)","v":440}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":8100},null,{"$f":"SUM(L15:L16)","v":27}]
[null,"Wheat Seed: SWS",null,150,null,"lb",null,0.18,null,8100,null,{"$f":"D15*H15","v":27}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D16*H16","v":0}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,28518,null,{"$f":"SUM(L19:L25)","v":95.06}]
[null,"Dry Nitrogen",null,125,null,"lb",null,0.4,null,15000,null,{"$f":"D19*H19","v":50}]
[null,"Dry P2O5",null,50,null,"lb",null,0.38,null,5700,null,19]
[null,"K2O",null,50,null,"lb",null,0.31,null,4650,null,15.5]
[null,"Sulfur",null,48,null,"lb",null,0.22,null,3168,null,10.56]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,3296.9999999999995,null,{"$f":"SUM(L28:L32)","v":10.989999999999998}]
[null,"Bronate Advanced",null,0.8,null,"pint",null,5.6,null,1343.9999999999998,null,{"$f":"D28*H28","v":4.4799999999999995}]
[null,"Affinity Broad Spectrum",null,0.6,null,"oz",null,9.6,null,1728,null,5.76]
[null,"N-I Surfactant + UAN",null,1,null,"acre",null,0.75,null,225,null,0.75]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,21390,null,{"$f":"SUM(L35:L39)","v":71.3}]
[null,"Custom Fertilize",null,2,null,"acre",null,7.75,null,4650,null,{"$f":"D35*H35","v":15.5}]
[null,"Custom Combine",null,1,null,"acre",null,36,null,10800,null,{"$f":"D36*H36","v":36}]
[null,"Custome Haul",null,110,null,"bu",null,0.18,null,5940,null,{"$f":"D37*H37","v":19.8}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D38*H38","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D39*H39","v":0}]
[]
[null,"Irrigation:",null,null,null,null,null,null,null,16950,null,{"$f":"SUM(L42:L44)","v":56.5}]
[null,"Water Assessment",null,1,null,"acre",null,53.5,null,16050,null,{"$f":"D42*H42","v":53.5}]
[null,"Repairs - Conc. Ditch",null,1,null,"acre",null,3,null,900,null,{"$f":"D43*H43","v":3}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D44*H44","v":0}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,10423.800000000001,null,{"$f":"SUM(L47:L51)","v":34.746000000000002}]
[null,"Fuel - Gas",null,1.28,null,"gal",null,2.5499999999999998,null,979.19999999999993,null,{"$f":"D47*H47","v":3.2639999999999998}]
[null,"Fuel - Diesel",null,7.02,null,"gal",null,2.35,null,4949.1000000000004,null,{"$f":"D48*H48","v":16.497}]
[null,"Fuel - Road Diesel",null,0.1,null,"gal",null,2.85,null,85.500000000000014,null,{"$f":"D49*H49","v":0.28500000000000003}]
[null,"Lube",null,1,null,"$",null,3.1,null,{"$f":"L50*$L$1","v":930},null,{"$f":"D50*H50","v":3.1}]
[null,"Machinery Repair",null,1,null,"$",null,11.6,null,3480,null,{"$f":"D51*H51","v":11.6}]
[]
[null,"Labor:",null,null,null,null,null,null,null,21713.100000000002,null,{"$f":"SUM(L54:L56)","v":72.37700000000001}]
[null,"Equipment Operator Labor",null,1.76,null,"hrs",null,19.7,null,10401.599999999999,null,{"$f":"D54*H54","v":34.671999999999997}]
[null,"General Farm Labor",null,0.3,null,"hrs",null,11.35,null,1021.4999999999999,null,{"$f":"D55*H55","v":3.4049999999999998}]
[null,"Irrigation Labor",null,2.4500000000000002,null,"hrs",null,14,null,10290.000000000002,null,{"$f":"D56*H56","v":34.300000000000004}]
[]
[null,"Other:",null,null,null,null,null,null,null,4500,null,{"$f":"SUM(L59:L61)","v":15}]
[null,"Crop Insurance",null,1,null,"acre",null,15,null,4500,null,{"$f":"D59*H59","v":15}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D60*H60","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D61*H61","v":0}]
[]
[null,"Interest on Operating Capital at 5.75%",null,6.25E-2,null,null,null,null,null,2865,null,9.5500000000000007]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,117756.89999999995,null,{"$f":"SUM(L14:L63)-(L14+L18+L27+L34+L41+L46+L53+L58)","v":392.52299999999985}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,1070.5172727272723,null,{"$f":"L65/D7","v":3.5683909090909078}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,14243.100000000044,null,{"$f":"L10-L65","v":47.477000000000146}]
[]
["Soft White Spring Wheat - Treasure Valley - 2017",null,null,null,null,null,null,null,null,"Number of acres:",null,300]
[null,"Ownership Costs:"]
[null,"General Overhead",null,null,null,null,null,null,null,{"$f":"L72*$L$1","v":2700},null,9]
[null,"Land Rent",null,null,null,null,null,null,null,{"$f":"L73*$L$1","v":67500},null,225]
[null,"Management Fee",null,null,null,null,null,null,null,10200,null,34]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,426,null,1.42]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,13493.999999999998,null,44.98]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"L81*$L$1","v":94320.000000000015},null,{"$f":"SUM(L71:L79)","v":314.40000000000003}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,857.4545454545455,null,{"$f":"L81/D7","v":2.8581818181818184}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,212076.89999999997,null,{"$f":"L65+L81","v":706.92299999999989}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,1927.971818181818,null,{"$f":"L84/D7","v":6.4265727272727267}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,-80076.899999999965,null,{"$f":"L10-L84","v":-266.92299999999989}]
[]
[null,"Notes:"]
[]
[]
[]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F99*(1-D97)","v":99},null,{"$f":"D7","v":110},null,{"$f":"F99*(1+H97)","v":121.00000000000001}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$65/D99","v":3.9648787878787863},null,{"$f":"$L$65/F99","v":3.5683909090909078},null,{"$f":"$L$65/H99","v":3.2439917355371883}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$81/D99","v":3.1757575757575762},null,{"$f":"$L$81/F99","v":2.8581818181818184},null,{"$f":"$L$81/H99","v":2.5983471074380167}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$84/D99","v":7.1406363636363626},null,{"$f":"$L$84/F99","v":6.4265727272727267},null,{"$f":"$L$84/H99","v":5.842338842975205}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F109*(1-D97)","v":3.6},null,{"$f":"H7","v":4},null,{"$f":"F109*(1+H97)","v":4.4000000000000004}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$65/D109","v":109.03416666666662},null,{"$f":"$L$65/F109","v":98.130749999999964},null,{"$f":"$L$65/H109","v":89.209772727272693}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$81/D109","v":87.333333333333343},null,{"$f":"$L$81/F109","v":78.600000000000009},null,{"$f":"$L$81/H109","v":71.454545454545453}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$84/D109","v":196.36749999999995},null,{"$f":"$L$84/F109","v":176.73074999999997},null,{"$f":"$L$84/H109","v":160.66431818181815}]

{"sheet":"SWW Wheat","index":3,"n_rows":116,"n_cols":12,"rows_kept":116,"cut":false,"hidden":false,"merged":[[74,1,74,3],[74,4,74,8],[0,0,0,7],[72,1,72,3],[72,4,72,8],[73,1,73,3],[73,4,73,8],[70,0,70,7],[75,1,75,3],[75,4,75,8],[76,1,76,3],[76,4,76,8],[77,1,77,3],[77,4,77,8],[92,1,92,11],[93,1,93,11],[94,1,94,11],[78,1,78,3],[78,4,78,8],[79,1,79,3],[79,4,79,8],[90,1,90,11],[91,1,91,11]]}
["Soft White Winter Wheat - Treasure Valley - 2017",null,null,null,null,null,null,null,null,"Number of acres:",null,300]
[]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Total ",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost",null,"Value",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Soft White Wheat",null,130,null,"bu",null,4,null,{"$f":"L7*$L$1","v":156000},null,{"$f":"D7*H7","v":520}]
[null,null,null,null,null,null,null,null,null,{"$f":"L8*$L$1","v":0},null,{"$f":"D8*H8","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,"Total Gross Returns",null,null,null,null,null,null,null,{"$f":"SUM(J7:J9)","v":156000},null,{"$f":"SUM(L7:L9)","v":520}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":5400},null,{"$f":"SUM(L15:L16)","v":18}]
[null,"Wheat Seed: SWS",null,100,null,"lb",null,0.18,null,5400,null,{"$f":"D15*H15","v":18}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D16*H16","v":0}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,31518,null,{"$f":"SUM(L19:L25)","v":105.06}]
[null,"Dry Nitrogen",null,150,null,"lb",null,0.4,null,18000,null,{"$f":"D19*H19","v":60}]
[null,"Dry P2O5",null,50,null,"lb",null,0.38,null,5700,null,19]
[null,"K2O",null,50,null,"lb",null,0.31,null,4650,null,15.5]
[null,"Sulfur",null,48,null,"lb",null,0.22,null,3168,null,10.56]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,3296.9999999999995,null,{"$f":"SUM(L28:L33)","v":10.989999999999998}]
[null,"Bronate Advanced",null,0.8,null,"pint",null,5.6,null,1343.9999999999998,null,{"$f":"D28*H28","v":4.4799999999999995}]
[null,"Affinity Broad Spectrum",null,0.6,null,"oz",null,9.6,null,1728,null,5.76]
[null,"N-I Surfactant + UAN",null,1,null,"acre",null,0.75,null,225,null,0.75]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,22470,null,{"$f":"SUM(L36:L40)","v":74.900000000000006}]
[null,"Custom Fertilize",null,2,null,"acre",null,7.75,null,4650,null,{"$f":"D36*H36","v":15.5}]
[null,"Custom Combine",null,1,null,"acre",null,36,null,10800,null,{"$f":"D37*H37","v":36}]
[null,"Custome Haul",null,130,null,"bu",null,0.18,null,7020,null,{"$f":"D38*H38","v":23.4}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D39*H39","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D40*H40","v":0}]
[]
[null,"Irrigation:",null,null,null,null,null,null,null,16950,null,{"$f":"SUM(L43:L45)","v":56.5}]
[null,"Water Assessment",null,1,null,"acre",null,53.5,null,16050,null,{"$f":"D43*H43","v":53.5}]
[null,"Repairs - Conc. Ditch",null,1,null,"acre",null,3,null,900,null,{"$f":"D44*H44","v":3}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D45*H45","v":0}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,10113.9,null,{"$f":"SUM(L48:L52)","v":33.713000000000001}]
[null,"Fuel - Gas",null,1.28,null,"gal",null,2.5499999999999998,null,979.19999999999993,null,{"$f":"D48*H48","v":3.2639999999999998}]
[null,"Fuel - Diesel",null,6.64,null,"gal",null,2.35,null,4681.2,null,{"$f":"D49*H49","v":15.603999999999999}]
[null,"Fuel - Road Diesel",null,0.1,null,"gal",null,2.85,null,85.500000000000014,null,{"$f":"D50*H50","v":0.28500000000000003}]
[null,"Lube",null,1,null,"$",null,2.96,null,888,null,{"$f":"D51*H51","v":2.96}]
[null,"Machinery Repair",null,1,null,"$",null,11.6,null,3480,null,{"$f":"D52*H52","v":11.6}]
[]
[null,"Labor:",null,null,null,null,null,null,null,21713.100000000002,null,{"$f":"SUM(L55:L57)","v":72.37700000000001}]
[null,"Equipment Operator Labor",null,1.76,null,"hrs",null,19.7,null,10401.599999999999,null,{"$f":"D55*H55","v":34.671999999999997}]
[null,"Non-Machine Labor",null,0.3,null,"hrs",null,11.35,null,1021.4999999999999,null,{"$f":"D56*H56","v":3.4049999999999998}]
[null,"Irrigation Labor",null,2.4500000000000002,null,"hrs",null,14,null,10290.000000000002,null,{"$f":"D57*H57","v":34.300000000000004}]
[]
[null,"Other:",null,null,null,null,null,null,null,4500,null,{"$f":"SUM(L60:L62)","v":15}]
[null,"Crop Insurance",null,1,null,"acre",null,15,null,4500,null,{"$f":"D60*H60","v":15}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D61*H61","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"D62*H62","v":0}]
[]
[null,"Interest on Operating Capital at 5.75%",null,6.25E-2,null,null,null,null,null,2835,null,9.4499999999999993]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,118796.99999999997,null,{"$f":"SUM(L14:L64)-(L14+L18+L27+L35+L42+L47+L54+L59)","v":395.9899999999999}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,913.82307692307666,null,{"$f":"L66/D7","v":3.0460769230769222}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,37203.000000000029,null,{"$f":"L10-L66","v":124.0100000000001}]
[]
["Soft White Winter Wheat - Treasure Valley - 2017",null,null,null,null,null,null,null,null,"Number of acres:",null,300]
[null,"Ownership Costs:"]
[null,"General Overhead",null,null,null,null,null,null,null,{"$f":"L73*$L$1","v":3000},null,10]
[null,"Land Rent",null,null,null,null,null,null,null,{"$f":"L74*$L$1","v":67500},null,225]
[null,"Management Fee",null,null,null,null,null,null,null,10800,null,36]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,426,null,1.42]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,13493.999999999998,null,44.98]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"L82*$L$1","v":95220.000000000015},null,{"$f":"SUM(L72:L80)","v":317.40000000000003}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,732.46153846153845,null,{"$f":"L82/D7","v":2.4415384615384617}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,214016.99999999997,null,{"$f":"L66+L82","v":713.38999999999987}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,1646.2846153846151,null,{"$f":"L85/D7","v":5.4876153846153839}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,-58016.999999999964,null,{"$f":"L10-L85","v":-193.38999999999987}]
[]
[null,"Notes:"]
[]
[]
[]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F100*(1-D98)","v":117},null,{"$f":"D7","v":130},null,{"$f":"F100*(1+H98)","v":143}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$66/D100","v":3.3845299145299137},null,{"$f":"$L$66/F100","v":3.0460769230769222},null,{"$f":"$L$66/H100","v":2.7691608391608384}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$82/D100","v":2.712820512820513},null,{"$f":"$L$82/F100","v":2.4415384615384617},null,{"$f":"$L$82/H100","v":2.2195804195804198}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$85/D100","v":6.0973504273504266},null,{"$f":"$L$85/F100","v":5.4876153846153839},null,{"$f":"$L$85/H100","v":4.9887412587412578}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F110*(1-D98)","v":3.6},null,{"$f":"H7","v":4},null,{"$f":"F110*(1+H98)","v":4.4000000000000004}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$66/D110","v":109.99722222222219},null,{"$f":"$L$66/F110","v":98.997499999999974},null,{"$f":"$L$66/H110","v":89.997727272727246}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$82/D110","v":88.166666666666671},null,{"$f":"$L$82/F110","v":79.350000000000009},null,{"$f":"$L$82/H110","v":72.13636363636364}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$85/D110","v":198.16388888888883},null,{"$f":"$L$85/F110","v":178.34749999999997},null,{"$f":"$L$85/H110","v":162.13409090909087}]

{"sheet":"Potato","index":4,"n_rows":134,"n_cols":11,"rows_kept":134,"cut":false,"hidden":false,"merged":[[108,1,108,10],[109,1,109,10],[110,1,110,10],[111,1,111,10],[112,1,112,10],[95,1,95,3],[95,4,95,8],[96,1,96,3],[96,4,96,8],[97,1,97,3],[97,4,97,8],[92,1,92,3],[92,4,92,8],[93,1,93,3],[93,4,93,8],[94,1,94,3],[94,4,94,8],[0,0,0,7],[85,0,85,7],[90,1,90,3],[90,4,90,8],[91,1,91,3],[91,4,91,8]]}
["Table A-1.  2017 Costs to grow, harvest and sort Southwestern Idaho Russet Burbank potatoes with fumigation."]
[]
[null,null,null,"Quantity",null,null,null,"Price or",null,null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost",null,null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Potatoes",null,500,null,"cwt",null,7.75,null,null,{"$f":"D7*H7","v":3875}]
[null,"Total Gross Returns",null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K7)","v":3875}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,null,{"$f":"SUM(K13:K14)","v":375.6}]
[null,"G-3 Russet Burbank Seed",null,24,null,"cwt",null,13.9,null,null,{"$f":"D13*H13","v":333.6}]
[null,"Seed Cutting",null,24,null,"cwt",null,1.75,null,null,{"$f":"D14*H14","v":42}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K23)","v":405.85}]
[null,"Dry Nitrogen - Preplant",null,175,null,"lb",null,0.4,null,null,{"$f":"D17*H17","v":70}]
[null,"Dry P2O5",null,220,null,"lb",null,0.38,null,null,83.6]
[null,"K2O",null,255,null,"lb",null,0.31,null,null,79.05]
[null,"Sulfur",null,115,null,"lb",null,0.22,null,null,25.3]
[null,"Liquid Nitrogen",null,135,null,"lb",null,0.5,null,null,67.5]
[null,"Liquid P2O5",null,65,null,"lb",null,0.56000000000000005,null,null,36.400000000000006]
[null,"Micronutrients & Foliars ",null,2,null,"acre",null,22,null,null,44]
[]
[null,"Pesticides & Chemicals:",null,null,null,null,null,null,null,null,{"$f":"SUM(K26:K43)","v":575.29500000000007}]
[null,"Vapam HL 42%",null,42,null,"gal",null,5.5,null,null,{"$f":"D26*H26","v":231}]
[null,"Seed Treatment",null,24,null,"cwt",null,0.65,null,null,{"$f":"D27*H27","v":15.600000000000001}]
[null,"Admire Pro",null,8,null,"fl oz",null,1.25,null,null,10]
[null,"Moncut 70DF",null,0.8,null,"lb",null,29.8,null,null,23.840000000000003]
[null,"Eptam 7E",null,4,null,"pt",null,6.3,null,null,25.2]
[null,"Metribuzin 75DF",null,0.75,null,"lb",null,11.9,null,null,8.9250000000000007]
[null,"Prowl 3.3EC",null,2,null,"pt",null,5.15,null,null,10.3]
[null,"Quadris Flowable",null,8,null,"fl oz",null,1.5,null,null,12]
[null,"Endura (2x)",null,7,null,"oz ",null,4.55,null,null,31.849999999999998]
[null,"Revus Top (2x)",null,12,null,"fl oz",null,2.25,null,null,27]
[null,"Bravo Weather Stik (2x)",null,3,null,"pt",null,5.6,null,null,{"$f":"D36*H36","v":16.799999999999997}]
[null,"Manzate Pro-Stick",null,2,null,"lb",null,3.85,null,null,{"$f":"D37*H37","v":7.7}]
[null,"Gavel 75DF",null,2,null,"lb",null,8.5,null,null,{"$f":"D38*H38","v":17}]
[null,"Fulfill WDG",null,5.5,null,"oz ",null,6.5,null,null,{"$f":"D39*H39","v":35.75}]
[null,"Brigadier (2x)",null,12,null,"fl oz",null,1.4,null,null,16.799999999999997]
[null,"Movento",null,5,null,"fl oz",null,8.3000000000000007,null,null,41.5]
[null,"Agri-Mek .75SC (2x)",null,7,null,"fl oz",null,2.25,null,null,{"$f":"D42*H42","v":15.75}]
[null,"Beleaf 50SG",null,2.8,null,"oz ",null,10.1,null,null,{"$f":"D43*H43","v":28.279999999999998}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,null,{"$f":"SUM(K46:K50)","v":135.25}]
[null,"Custom Fumigate - Deep Injection",null,1,null,"acre",null,45,null,null,{"$f":"D46*H46","v":45}]
[null,"Custom Fertilize: 400 - 800 lbs",null,1,null,"acre",null,8,null,null,{"$f":"D47*H47","v":8}]
[null,"Custom Fertilize: 0 - 400 lbs",null,1,null,"acre",null,7.25,null,null,{"$f":"D48*H48","v":7.25}]
[null,"Custom Air Spray - 5 gal",null,5,null,"acre",null,9,null,null,45]
[null,"Consultant & Soil/Pet. Test ",null,1,null,"acre",null,30,null,null,{"$f":"D50*H50","v":30}]
[]
[null,"Irrigation:",null,null,null,null,null,null,null,null,{"$f":"SUM(K53:K55)","v":130.07}]
[null,"Water Assessment",null,1,null,"acre",null,53.5,null,null,{"$f":"D53*H53","v":53.5}]
[null,"Irrigation Repairs - Center Pivot",null,31,null,"acre-inch",null,0.53,null,null,{"$f":"D54*H54","v":16.43}]
[null,"Irrigation Power - Center Pivot",null,31,null,"acre-inch",null,1.94,null,null,{"$f":"D55*H55","v":60.14}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,null,{"$f":"SUM(K58:K62)","v":153.07749999999999}]
[null,"Fuel - Gas",null,5.32,null,"gal",null,2.5499999999999998,null,null,{"$f":"D58*H58","v":13.565999999999999}]
[null,"Fuel - Farm Diesel",null,22.37,null,"gal",null,2.35,null,null,{"$f":"D59*H59","v":52.569500000000005}]
[null,"Fuel - Road Diesel",null,2.3199999999999998,null,"gal",null,2.85,null,null,{"$f":"D60*H60","v":6.6120000000000001}]
[null,"Lube",null,1,null,"$",null,11.01,null,null,{"$f":"D61*H61","v":11.01}]
[null,"Machinery Repairs",null,1,null,"$",null,69.319999999999993,null,null,{"$f":"D62*H62","v":69.319999999999993}]
[]
[null,"Labor:",null,null,null,null,null,null,null,null,{"$f":"SUM(K65:K69)","v":237.32599999999996}]
[null,"Equipment Operator Labor",null,4.78,null,"hrs",null,19.7,null,null,{"$f":"D65*H65","v":94.165999999999997}]
[null,"Truck Driver Labor",null,3.6,null,"hrs",null,15.35,null,null,{"$f":"D66*H66","v":55.26}]
[null,"Irrigation Labor - Center Pivot",null,1.28,null,"hrs",null,19.7,null,null,25.216000000000001]
[null,"Irrigation Labor - Chem-Fert",null,1.2,null,"hrs",null,19.7,null,null,{"$f":"D68*H68","v":23.639999999999997}]
[null,"General Farm Labor",null,3.44,null,"hrs",null,11.35,null,null,{"$f":"D69*H69","v":39.043999999999997}]
[]
[null,"Sorting:",null,null,null,null,null,null,null,null,{"$f":"SUM(K72:K74)","v":75}]
[null,"Sorting Labor",null,500,null,"cwt",null,0.115,null,null,{"$f":"D72*H72","v":57.5}]
[null,"Sorting Equipment Repairs & Power",null,500,null,"cwt",null,3.5000000000000003E-2,null,null,{"$f":"D73*H73","v":17.5}]
[]
[null,"Other:",null,null,null,null,null,null,null,null,{"$f":"SUM(K76:K77)","v":155.5}]
[null,"Crop Insurance",null,1,null,"acre",null,70,null,null,{"$f":"D76*H76","v":70}]
[null,"Fees & Assessments",null,475,null,"cwt",null,0.18,null,null,{"$f":"D77*H77","v":85.5}]
[]
[null,"Interest on Operating Capital at 6.25%",null,null,null,null,null,null,null,null,83.84]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(K12:K79)-(K12+K16+K25+K45+K52+K57+K64+K71+K75)","v":2326.808500000001}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,null,{"$f":"K81/D7","v":4.6536170000000023}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,null,{"$f":"K8-K81","v":1548.191499999999}]
[]
["Table A-1.  2017 Costs to grow, harvest and sort Southwestern Idaho Russet Burbank potatoes with fumigation."]
[]
[null,null,null,"Quantity",null,null,null,"Price or",null,null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost",null,null,"Cost/Acre"]
[null,"Ownership Costs:"]
[null,"Tractors & Equipment Insurance",null,null,null,null,null,null,null,null,6.15]
[null,"Tractors & Equipment Depreciation & Interest",null,null,null,null,null,null,null,null,208]
[null,"Potato Handling Equipment Deprec. & Interest",null,null,null,null,null,null,null,null,79]
[null,"Land*",null,null,null,null,null,null,null,null,700]
[null,"Overhead",null,null,null,null,null,null,null,null,58]
[null,"Management Fee",null,null,null,null,null,null,null,null,177]
[]
[]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(K90:K98)","v":1228.1500000000001}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,null,{"$f":"K100/D7","v":2.4563000000000001}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,null,{"$f":"K81+K100","v":3554.9585000000011}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,null,{"$f":"K103/D7","v":7.109917000000002}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,null,{"$f":"K8-K103","v":320.0414999999989}]
[]
[null,"Notes:"]
[null,"*Includes irrigation system ownership costs."]
[null,"Blue font indicates an increase."]
[null,"Red font indicates a decrease."]
[null,"A green font indicates a change in product or procedure to derive the cost."]
[null,"Procedural changes can result in different costs than were published the previous year."]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.05,null,null,null,0.05]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F118*(1-D116)","v":475},null,{"$f":"D7","v":500},null,{"$f":"F118*(1+H116)","v":525}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$K$81/D118","v":4.8985442105263175},null,{"$f":"$K$81/F118","v":4.6536170000000023},null,{"$f":"$K$81/H118","v":4.4320161904761921}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$K$100/D118","v":2.5855789473684214},null,{"$f":"$K$100/F118","v":2.4563000000000001},null,{"$f":"$K$100/H118","v":2.3393333333333337}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$K$103/D118","v":7.4841231578947394},null,{"$f":"$K$103/F118","v":7.109917000000002},null,{"$f":"$K$103/H118","v":6.7713495238095263}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F128*(1-D116)","v":7.3624999999999998},null,{"$f":"H7","v":7.75},null,{"$f":"F128*(1+H116)","v":8.1375000000000011}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$K$81/D128","v":316.03511035653662},null,{"$f":"$K$81/F128","v":300.23335483870983},null,{"$f":"$K$81/H128","v":285.93652841781881}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$K$100/D128","v":166.81154499151106},null,{"$f":"$K$100/F128","v":158.47096774193548},null,{"$f":"$K$100/H128","v":150.92473118279568}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$K$103/D128","v":482.8466553480477},null,{"$f":"$K$103/F128","v":458.70432258064528},null,{"$f":"$K$103/H128","v":436.86125960061452}]