{"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":[[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],[74,1,74,3],[74,4,74,8],[75,1,75,3],[75,4,75,8],[76,1,76,3],[76,4,76,8],[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]]}
["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":[[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],[66,1,66,3],[66,4,66,8],[67,1,67,3],[67,4,67,8],[68,1,68,3],[68,4,68,8],[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]]}
["Alfalfa Hay - Treasure Valley - 2019",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,160,null,{"$f":"L7*$L$1","v":180000},null,{"$f":"D7*H7","v":1200}]
[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":180000},null,{"$f":"SUM(L7:L9)","v":1200}]
[]
[null,"Operating Inputs"]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":10597.499999999998},null,{"$f":"SUM(L15:L21)","v":70.649999999999991}]
[null,"Dry Nitrogen",null,15,null,"lb",null,0.42,null,945,null,{"$f":"D15*H15","v":6.3}]
[null,"Dry P2O5",null,75,null,"lb",null,0.41,null,4612.4999999999991,null,30.749999999999996]
[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,3187.5,null,{"$f":"SUM(L24:L29)","v":21.25}]
[null,"Metribuzin 75DF",null,1,null,"lb",null,16,null,2400,null,{"$f":"D24*H24","v":16}]
[null,"Warrior II w/Zeon Tech",null,3,null,"fl oz",null,1.75,null,787.5,null,5.25]
[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,45000,null,{"$f":"SUM(L32:L36)","v":300}]
[null,"Custom Fertilize",null,1,null,"acre",null,7.5,null,1125,null,{"$f":"D32*H32","v":7.5}]
[null,"Custom Swath & Rake",null,4,null,"acre",null,30,null,18000,null,{"$f":"D33*H33","v":120}]
[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,5,null,5625,null,{"$f":"D35*H35","v":37.5}]
[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,9150,null,{"$f":"SUM(L39:L41)","v":61}]
[null,"Water Assessment",null,1,null,"acre",null,57,null,8550,null,{"$f":"D39*H39","v":57}]
[null,"Repairs - Conc. Ditch",null,1,null,"acre",null,4,null,600,null,{"$f":"D40*H40","v":4}]
[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,2283.75,null,{"$f":"SUM(L44:L48)","v":15.225}]
[null,"Fuel - Gas",null,1.28,null,"gal",null,3.25,null,624,null,{"$f":"D44*H44","v":4.16}]
[null,"Fuel - Diesel",null,1.65,null,"gal",null,3,null,742.49999999999989,null,{"$f":"D45*H45","v":4.9499999999999993}]
[null,"Fuel - Road Diesel",null,0.63,null,"gal",null,3.5,null,330.75,null,{"$f":"D46*H46","v":2.2050000000000001}]
[null,"Lube",null,1,null,"$",null,1.51,null,226.5,null,{"$f":"D47*H47","v":1.51}]
[null,"Machinery Repair",null,1,null,"$",null,2.4,null,360,null,{"$f":"D48*H48","v":2.4}]
[]
[null,"Labor:",null,null,null,null,null,null,null,16949.25,null,{"$f":"SUM(L51:L53)","v":112.995}]
[null,"Equipment Operator Labor",null,1.2,null,"hrs",null,22.5,null,4050,null,{"$f":"D51*H51","v":27}]
[null,"Irrigation Labor",null,4.9000000000000004,null,"hrs",null,17.55,null,12899.25,null,{"$f":"D52*H52","v":85.995000000000005}]
[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,7.0000000000000007E-2,null,null,null,null,null,2052,null,13.68]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,89219.999999999971,null,{"$f":"SUM(L14:L55)-(L14+L23+L31+L38+L43+L50)","v":594.79999999999984}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,11895.999999999996,null,{"$f":"L57/D7","v":79.306666666666644}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,90780.000000000029,null,{"$f":"L10-L57","v":605.20000000000016}]
[]
["Alfalfa Hay - Treasure Valley - 2019",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":2250},null,15]
[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,7050,null,47]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,220.5,null,1.47]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,3501,null,23.34]
[null,"Alfalfa Establishment - Est. Amort. Cost",null,null,null,null,null,null,null,11008.5,null,73.39]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"L73*$L$1","v":57780},null,{"$f":"SUM(L63:L71)","v":385.2}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,7704,null,{"$f":"L73/D7","v":51.36}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,146999.99999999997,null,{"$f":"L57+L73","v":979.99999999999977}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,19599.999999999993,null,{"$f":"L76/D7","v":130.66666666666663}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,33000.000000000036,null,{"$f":"L10-L76","v":220.00000000000023}]
[]
[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":88.118518518518499},null,{"$f":"$L$57/F91","v":79.306666666666644},null,{"$f":"$L$57/H91","v":72.09696969696968}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$73/D91","v":57.066666666666663},null,{"$f":"$L$73/F91","v":51.36},null,{"$f":"$L$73/H91","v":46.690909090909088}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$76/D91","v":145.18518518518516},null,{"$f":"$L$76/F91","v":130.66666666666663},null,{"$f":"$L$76/H91","v":118.78787878787875}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F101*(1-D89)","v":144},null,{"$f":"H7","v":160},null,{"$f":"F101*(1+H89)","v":176}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$57/D101","v":4.1305555555555546},null,{"$f":"$L$57/F101","v":3.7174999999999989},null,{"$f":"$L$57/H101","v":3.3795454545454535}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$73/D101","v":2.6749999999999998},null,{"$f":"$L$73/F101","v":2.4074999999999998},null,{"$f":"$L$73/H101","v":2.1886363636363635}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$76/D101","v":6.8055555555555536},null,{"$f":"$L$76/F101","v":6.1249999999999982},null,{"$f":"$L$76/H101","v":5.5681818181818166}]

{"sheet":"SWS Wheat","index":2,"n_rows":115,"n_cols":12,"rows_kept":115,"cut":false,"hidden":false,"merged":[[92,1,92,11],[93,1,93,11],[78,1,78,3],[78,4,78,8],[89,1,89,11],[90,1,90,11],[91,1,91,11],[75,1,75,3],[75,4,75,8],[76,1,76,3],[76,4,76,8],[77,1,77,3],[77,4,77,8],[0,0,0,7],[73,1,73,3],[73,4,73,8],[74,1,74,3],[74,4,74,8],[69,0,69,7],[71,1,71,3],[71,4,71,8],[72,1,72,3],[72,4,72,8]]}
["Soft White Spring Wheat - Treasure Valley - 2019",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.55,null,{"$f":"L7*$L$1","v":150150},null,{"$f":"D7*H7","v":500.5}]
[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":150150},null,{"$f":"SUM(L7:L9)","v":500.5}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":9900},null,{"$f":"SUM(L15:L16)","v":33}]
[null,"Wheat Seed: SWS",null,150,null,"lb",null,0.22,null,9900,null,{"$f":"D15*H15","v":33}]
[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,29718,null,{"$f":"SUM(L19:L25)","v":99.06}]
[null,"Dry Nitrogen",null,125,null,"lb",null,0.42,null,15750,null,{"$f":"D19*H19","v":52.5}]
[null,"Dry P2O5",null,50,null,"lb",null,0.41,null,6150,null,20.5]
[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,2805.0000000000005,null,{"$f":"SUM(L28:L32)","v":9.3500000000000014}]
[null,"Bronate Advanced",null,0.8,null,"pint",null,5.5,null,1320,null,{"$f":"D28*H28","v":4.4000000000000004}]
[null,"Affinity Broad Spectrum",null,0.6,null,"oz",null,7,null,1260,null,4.2]
[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,38100,null,{"$f":"SUM(L35:L39)","v":127}]
[null,"Custom Fertilize",null,2,null,"acre",null,7.5,null,4500,null,{"$f":"D35*H35","v":15}]
[null,"Custom Spraying",null,1,null,"acre",null,7.5,null,2250,null,{"$f":"D36*H36","v":7.5}]
[null,"Custom Combine",null,1,null,"acre",null,66,null,19800,null,66]
[null,"Custome Haul",null,110,null,"bu",null,0.35,null,11550,null,38.5]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Irrigation:",null,null,null,null,null,null,null,18300,null,{"$f":"SUM(L42:L44)","v":61}]
[null,"Water Assessment",null,1,null,"acre",null,57,null,17100,null,{"$f":"D42*H42","v":57}]
[null,"Repairs - Conc. Ditch",null,1,null,"acre",null,4,null,1200,null,{"$f":"D43*H43","v":4}]
[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,12414,null,{"$f":"SUM(L47:L51)","v":41.38}]
[null,"Fuel - Gas",null,1.28,null,"gal",null,3.25,null,1248,null,{"$f":"D47*H47","v":4.16}]
[null,"Fuel - Diesel",null,7.02,null,"gal",null,3,null,6318,null,{"$f":"D48*H48","v":21.06}]
[null,"Fuel - Road Diesel",null,0.1,null,"gal",null,3.5,null,105.00000000000001,null,{"$f":"D49*H49","v":0.35000000000000003}]
[null,"Lube",null,1,null,"$",null,3.48,null,{"$f":"L50*$L$1","v":1044},null,{"$f":"D50*H50","v":3.48}]
[null,"Machinery Repair",null,1,null,"$",null,12.33,null,3699,null,{"$f":"D51*H51","v":12.33}]
[]
[null,"Labor:",null,null,null,null,null,null,null,26358.750000000004,null,{"$f":"SUM(L54:L56)","v":87.862500000000011}]
[null,"Equipment Operator Labor",null,1.76,null,"hrs",null,22.5,null,11880,null,{"$f":"D54*H54","v":39.6}]
[null,"General Farm Labor",null,0.3,null,"hrs",null,17.55,null,1579.5,null,{"$f":"D55*H55","v":5.2649999999999997}]
[null,"Irrigation Labor",null,2.4500000000000002,null,"hrs",null,17.55,null,12899.25,null,{"$f":"D56*H56","v":42.997500000000002}]
[]
[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,7.0000000000000007E-2,null,null,null,null,null,3957,null,13.19]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,146052.74999999997,null,{"$f":"SUM(L14:L63)-(L14+L18+L27+L34+L41+L46+L53+L58)","v":486.84249999999992}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,1327.7522727272726,null,{"$f":"L65/D7","v":4.4258409090909083}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,4097.2500000000255,null,{"$f":"L10-L65","v":13.657500000000084}]
[]
["Soft White Spring Wheat - Treasure Valley - 2019",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":3600},null,12]
[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,11700,null,39]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,441,null,1.47]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,14559,null,48.53]
[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":97800},null,{"$f":"SUM(L71:L79)","v":326}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,889.09090909090912,null,{"$f":"L81/D7","v":2.9636363636363638}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,243852.75,null,{"$f":"L65+L81","v":812.84249999999997}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,2216.8431818181816,null,{"$f":"L84/D7","v":7.3894772727272722}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,-93702.749999999985,null,{"$f":"L10-L84","v":-312.34249999999997}]
[]
[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":4.9176010101010093},null,{"$f":"$L$65/F99","v":4.4258409090909083},null,{"$f":"$L$65/H99","v":4.0234917355371893}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$81/D99","v":3.2929292929292928},null,{"$f":"$L$81/F99","v":2.9636363636363638},null,{"$f":"$L$81/H99","v":2.6942148760330573}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$84/D99","v":8.2105303030303034},null,{"$f":"$L$84/F99","v":7.3894772727272722},null,{"$f":"$L$84/H99","v":6.7177066115702466}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F109*(1-D97)","v":4.0949999999999998},null,{"$f":"H7","v":4.55},null,{"$f":"F109*(1+H97)","v":5.0049999999999999}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$65/D109","v":118.88705738705737},null,{"$f":"$L$65/F109","v":106.99835164835163},null,{"$f":"$L$65/H109","v":97.271228771228763}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$81/D109","v":79.609279609279611},null,{"$f":"$L$81/F109","v":71.64835164835165},null,{"$f":"$L$81/H109","v":65.134865134865137}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$84/D109","v":198.49633699633699},null,{"$f":"$L$84/F109","v":178.64670329670329},null,{"$f":"$L$84/H109","v":162.4060939060939}]

{"sheet":"SWW Wheat","index":3,"n_rows":116,"n_cols":12,"rows_kept":116,"cut":false,"hidden":false,"merged":[[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],[75,1,75,3],[75,4,75,8],[76,1,76,3],[76,4,76,8],[77,1,77,3],[77,4,77,8],[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]]}
["Soft White Winter Wheat - Treasure Valley - 2019",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.55,null,{"$f":"L7*$L$1","v":177450},null,{"$f":"D7*H7","v":591.5}]
[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":177450},null,{"$f":"SUM(L7:L9)","v":591.5}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"L14*$L$1","v":6600},null,{"$f":"SUM(L15:L16)","v":22}]
[null,"Wheat Seed: SWS",null,100,null,"lb",null,0.22,null,6600,null,{"$f":"D15*H15","v":22}]
[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,32868,null,{"$f":"SUM(L19:L25)","v":109.56}]
[null,"Dry Nitrogen",null,150,null,"lb",null,0.42,null,18900,null,{"$f":"D19*H19","v":63}]
[null,"Dry P2O5",null,50,null,"lb",null,0.41,null,6150,null,20.5]
[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,2805.0000000000005,null,{"$f":"SUM(L28:L33)","v":9.3500000000000014}]
[null,"Bronate Advanced",null,0.8,null,"pint",null,5.5,null,1320,null,{"$f":"D28*H28","v":4.4000000000000004}]
[null,"Affinity Broad Spectrum",null,0.6,null,"oz",null,7,null,1260,null,4.2]
[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,40200,null,{"$f":"SUM(L36:L40)","v":134}]
[null,"Custom Fertilize",null,2,null,"acre",null,7.5,null,4500,null,{"$f":"D36*H36","v":15}]
[null,"Custom Spraying",null,1,null,"acre",null,7.5,null,2250,null,{"$f":"D37*H37","v":7.5}]
[null,"Custom Combine",null,1,null,"acre",null,66,null,19800,null,66]
[null,"Custome Haul",null,130,null,"bu",null,0.35,null,13650,null,45.5]
[null,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"Irrigation:",null,null,null,null,null,null,null,18300,null,{"$f":"SUM(L43:L45)","v":61}]
[null,"Water Assessment",null,1,null,"acre",null,57,null,17100,null,{"$f":"D43*H43","v":57}]
[null,"Repairs - Conc. Ditch",null,1,null,"acre",null,4,null,1200,null,{"$f":"D44*H44","v":4}]
[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,12024,null,{"$f":"SUM(L48:L52)","v":40.08}]
[null,"Fuel - Gas",null,1.28,null,"gal",null,3.25,null,1248,null,{"$f":"D48*H48","v":4.16}]
[null,"Fuel - Diesel",null,6.64,null,"gal",null,3,null,5975.9999999999991,null,{"$f":"D49*H49","v":19.919999999999998}]
[null,"Fuel - Road Diesel",null,0.1,null,"gal",null,3.5,null,105.00000000000001,null,{"$f":"D50*H50","v":0.35000000000000003}]
[null,"Lube",null,1,null,"$",null,3.32,null,996,null,{"$f":"D51*H51","v":3.32}]
[null,"Machinery Repair",null,1,null,"$",null,12.33,null,3699,null,{"$f":"D52*H52","v":12.33}]
[]
[null,"Labor:",null,null,null,null,null,null,null,26358.750000000004,null,{"$f":"SUM(L55:L57)","v":87.862500000000011}]
[null,"Equipment Operator Labor",null,1.76,null,"hrs",null,22.5,null,11880,null,{"$f":"D55*H55","v":39.6}]
[null,"Non-Machine Labor",null,0.3,null,"hrs",null,17.55,null,1579.5,null,{"$f":"D56*H56","v":5.2649999999999997}]
[null,"Irrigation Labor",null,2.4500000000000002,null,"hrs",null,17.55,null,12899.25,null,{"$f":"D57*H57","v":42.997500000000002}]
[]
[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,7.0000000000000007E-2,null,null,null,null,null,3894,null,12.98]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,147549.75,null,{"$f":"SUM(L14:L64)-(L14+L18+L27+L35+L42+L47+L54+L59)","v":491.83249999999998}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,1134.998076923077,null,{"$f":"L66/D7","v":3.7833269230769231}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,29900.250000000007,null,{"$f":"L10-L66","v":99.667500000000018}]
[]
["Soft White Winter Wheat - Treasure Valley - 2019",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":3600},null,12]
[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,11700,null,39]
[null,"Property Taxes",null,null,null,null,null,null,null,0]
[null,"Property Insurance",null,null,null,null,null,null,null,441,null,1.47]
[null,"Investment Repairs",null,null,null,null,null,null,null,0]
[null,"Capital Recovery - Equipment",null,null,null,null,null,null,null,14559,null,48.53]
[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":97800},null,{"$f":"SUM(L72:L80)","v":326}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,752.30769230769226,null,{"$f":"L82/D7","v":2.5076923076923077}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,245349.75,null,{"$f":"L66+L82","v":817.83249999999998}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,1887.3057692307693,null,{"$f":"L85/D7","v":6.2910192307692308}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,-67899.75,null,{"$f":"L10-L85","v":-226.33249999999998}]
[]
[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":4.2036965811965814},null,{"$f":"$L$66/F100","v":3.7833269230769231},null,{"$f":"$L$66/H100","v":3.4393881118881118}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$82/D100","v":2.7863247863247862},null,{"$f":"$L$82/F100","v":2.5076923076923077},null,{"$f":"$L$82/H100","v":2.2797202797202796}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$85/D100","v":6.9900213675213676},null,{"$f":"$L$85/F100","v":6.2910192307692308},null,{"$f":"$L$85/H100","v":5.7191083916083914}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F110*(1-D98)","v":4.0949999999999998},null,{"$f":"H7","v":4.55},null,{"$f":"F110*(1+H98)","v":5.0049999999999999}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$L$66/D110","v":120.1056166056166},null,{"$f":"$L$66/F110","v":108.09505494505494},null,{"$f":"$L$66/H110","v":98.268231768231772}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$L$82/D110","v":79.609279609279611},null,{"$f":"$L$82/F110","v":71.64835164835165},null,{"$f":"$L$82/H110","v":65.134865134865137}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$L$85/D110","v":199.71489621489621},null,{"$f":"$L$85/F110","v":179.7434065934066},null,{"$f":"$L$85/H110","v":163.40309690309689}]

{"sheet":"Potato","index":4,"n_rows":134,"n_cols":11,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,0,0,7],[85,0,85,7],[90,1,90,3],[90,4,90,8],[91,1,91,3],[91,4,91,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],[95,1,95,3],[95,4,95,8],[96,1,96,3],[96,4,96,8],[97,1,97,3],[97,4,97,8],[108,1,108,10],[109,1,109,10],[110,1,110,10],[111,1,111,10],[112,1,112,10]]}
["2019 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,505,null,"cwt",null,8,null,null,{"$f":"D7*H7","v":4040}]
[null,"Total Gross Returns",null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K7)","v":4040}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,null,{"$f":"SUM(K13:K14)","v":379.2}]
[null,"G-3 Russet Burbank Seed",null,24,null,"cwt",null,13.85,null,null,{"$f":"D13*H13","v":332.4}]
[null,"Seed Cutting",null,24,null,"cwt",null,1.95,null,null,{"$f":"D14*H14","v":46.8}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K23)","v":410.75}]
[null,"Dry Nitrogen - Preplant",null,175,null,"lb",null,0.42,null,null,{"$f":"D17*H17","v":73.5}]
[null,"Dry P2O5",null,220,null,"lb",null,0.41,null,null,90.199999999999989]
[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.48,null,null,31.2]
[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":582.67250000000001}]
[null,"Metam CLR (42%)",null,42,null,"gal",null,5.4,null,null,{"$f":"D26*H26","v":226.8}]
[null,"Seed Treatment",null,24,null,"cwt",null,0.7,null,null,{"$f":"D27*H27","v":16.799999999999997}]
[null,"Admire Pro",null,8,null,"fl oz",null,1.3,null,null,10.4]
[null,"Moncut 70DF",null,0.8,null,"lb",null,30,null,null,24]
[null,"Eptam 7E",null,4,null,"pt",null,6.85,null,null,27.4]
[null,"Metribuzin 75DF",null,0.75,null,"lb",null,14.35,null,null,10.762499999999999]
[null,"Prowl H2O",null,2,null,"pt",null,4.6500000000000004,null,null,9.3000000000000007]
[null,"Quadris Flowable",null,8,null,"fl oz",null,1.2,null,null,9.6]
[null,"Luna Tranquility (2x)",null,16,null,"fl oz",null,2.5,null,null,40]
[null,"Revus Top (2x)",null,12,null,"fl oz",null,2.2000000000000002,null,null,26.400000000000002]
[null,"Bravo Weather Stik (2x)",null,3,null,"pt",null,4.75,null,null,{"$f":"D36*H36","v":14.25}]
[null,"Manzate Pro-Stick",null,2,null,"lb",null,4,null,null,{"$f":"D37*H37","v":8}]
[null,"Gavel 75DF",null,2,null,"lb",null,9.1999999999999993,null,null,{"$f":"D38*H38","v":18.399999999999999}]
[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.35,null,null,{"$f":"D40*H40","v":16.200000000000003}]
[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.35,null,null,{"$f":"D42*H42","v":16.45}]
[null,"Beleaf 50SG",null,2.8,null,"oz ",null,10.95,null,null,{"$f":"D43*H43","v":30.659999999999997}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,null,{"$f":"SUM(K46:K50)","v":134}]
[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,7.5,null,null,{"$f":"D47*H47","v":7.5}]
[null,"Custom Fertilize: 0 - 400 lbs",null,1,null,"acre",null,6.5,null,null,{"$f":"D48*H48","v":6.5}]
[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":133.88}]
[null,"Water Assessment",null,1,null,"acre",null,57,null,null,{"$f":"D53*H53","v":57}]
[null,"Irrigation Repairs - Center Pivot",null,31,null,"acre-inch",null,0.55000000000000004,null,null,{"$f":"D54*H54","v":17.05}]
[null,"Irrigation Power - Center Pivot",null,31,null,"acre-inch",null,1.93,null,null,{"$f":"D55*H55","v":59.83}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,null,{"$f":"SUM(K58:K62)","v":180.29000000000002}]
[null,"Fuel - Gas",null,5.32,null,"gal",null,3.25,null,null,{"$f":"D58*H58","v":17.29}]
[null,"Fuel - Farm Diesel",null,22.37,null,"gal",null,3,null,null,{"$f":"D59*H59","v":67.11}]
[null,"Fuel - Road Diesel",null,2.3199999999999998,null,"gal",null,3.5,null,null,{"$f":"D60*H60","v":8.1199999999999992}]
[null,"Lube",null,1,null,"$",null,12.67,null,null,{"$f":"D61*H61","v":12.67}]
[null,"Machinery Repairs",null,1,null,"$",null,75.099999999999994,null,null,{"$f":"D62*H62","v":75.099999999999994}]
[]
[null,"Labor:",null,null,null,null,null,null,null,null,{"$f":"SUM(K65:K69)","v":286.90200000000004}]
[null,"Equipment Operator Labor",null,4.78,null,"hrs",null,22.5,null,null,{"$f":"D65*H65","v":107.55000000000001}]
[null,"Truck Driver Labor",null,3.6,null,"hrs",null,17.55,null,null,{"$f":"D66*H66","v":63.180000000000007}]
[null,"Irrigation Labor - Center Pivot",null,1.28,null,"hrs",null,22.5,null,null,28.8]
[null,"Irrigation Labor - Chem-Fert",null,1.2,null,"hrs",null,22.5,null,null,{"$f":"D68*H68","v":27}]
[null,"General Farm Labor",null,3.44,null,"hrs",null,17.55,null,null,{"$f":"D69*H69","v":60.372}]
[]
[null,"Sorting:",null,null,null,null,null,null,null,null,{"$f":"SUM(K72:K74)","v":86.355000000000004}]
[null,"Sorting Labor",null,505,null,"cwt",null,0.13400000000000001,null,null,{"$f":"D72*H72","v":67.67}]
[null,"Sorting Equipment Repairs & Power",null,505,null,"cwt",null,3.6999999999999998E-2,null,null,{"$f":"D73*H73","v":18.684999999999999}]
[]
[null,"Other:",null,null,null,null,null,null,null,null,{"$f":"SUM(K76:K77)","v":131.89999999999998}]
[null,"Crop Insurance",null,1,null,"acre",null,50,null,null,{"$f":"D76*H76","v":50}]
[null,"Fees & Assessments",null,455,null,"cwt",null,0.18,null,null,{"$f":"D77*H77","v":81.899999999999991}]
[]
[null,"Interest on Operating Capital at 7.00%",null,null,null,null,null,null,null,null,92.61]
[]
[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":2418.5594999999998}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,null,{"$f":"K81/D7","v":4.7892267326732672}]
[]
[null,"Net Returns Above Operating Costs",null,null,null,null,null,null,null,null,{"$f":"K8-K81","v":1621.4405000000002}]
[]
["2019 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.45]
[null,"Tractors & Equipment Depreciation & Interest",null,null,null,null,null,null,null,null,225]
[null,"Potato Handling Equipment Deprec. & Interest",null,null,null,null,null,null,null,null,85]
[null,"Land*",null,null,null,null,null,null,null,null,700]
[null,"Overhead",null,null,null,null,null,null,null,null,72]
[null,"Management Fee",null,null,null,null,null,null,null,null,223]
[]
[]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(K90:K98)","v":1311.45}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,null,{"$f":"K100/D7","v":2.5969306930693072}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,null,{"$f":"K81+K100","v":3730.0095000000001}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,null,{"$f":"K103/D7","v":7.3861574257425744}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,null,{"$f":"K8-K103","v":309.99049999999988}]
[]
[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":479.75},null,{"$f":"D7","v":505},null,{"$f":"F118*(1+H116)","v":530.25}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$K$81/D118","v":5.0412912975508073},null,{"$f":"$K$81/F118","v":4.7892267326732672},null,{"$f":"$K$81/H118","v":4.561168316831683}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$K$100/D118","v":2.7336112558624284},null,{"$f":"$K$100/F118","v":2.5969306930693072},null,{"$f":"$K$100/H118","v":2.4732673267326732}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$K$103/D118","v":7.7749025534132361},null,{"$f":"$K$103/F118","v":7.3861574257425744},null,{"$f":"$K$103/H118","v":7.0344356435643567}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F128*(1-D116)","v":7.6},null,{"$f":"H7","v":8},null,{"$f":"F128*(1+H116)","v":8.4}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$K$81/D128","v":318.23151315789471},null,{"$f":"$K$81/F128","v":302.31993749999998},null,{"$f":"$K$81/H128","v":287.92374999999998}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$K$100/D128","v":172.55921052631581},null,{"$f":"$K$100/F128","v":163.93125000000001},null,{"$f":"$K$100/H128","v":156.125}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$K$103/D128","v":490.79072368421055},null,{"$f":"$K$103/F128","v":466.25118750000001},null,{"$f":"$K$103/H128","v":444.04874999999998}]