{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Title Page","Instructions","Summary","Graphical","Input Prices","SWWW Budget","SWWW Mach Costs","HRWW Budget","HRWW Mach Costs","SWSW Budget","SWSW Mach Costs","HRSW Budget","HRSW Mach Costs","BGE Budget","BGE Mach Costs","BG Budget","BG Mach Costs","Spring Canola Budget","SC Mach Costs","CF Budget","CF Mach Costs","Machinery Costs","Machinery Complement"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":1,"defined_names":178,"comments":12,"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":"1904"}

{"sheet":"Title Page","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,7,17,7],[12,8,17,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Photo: Dennis Pittmann"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"2009 Direct Seed Crop Rotation Budgets"]
[null,null,null,null,null,"Lewis County, Idaho"]
[]
[null,null,null,null,null,"Kathleen Painter, PhD1 and Ken Hart2"]
[null,null,null,null,null,"1Farm and Ranch Management Specialist"]
[null,null,null,null,null,"Department of Agricultural Economics & Rural Sociology"]
[null,null,null,null,null,"Ag Science, Room 32"]
[null,null,null,null,null,"Moscow ID 83843-2334"]
[null,null,null,null,null,"(208) 885-6041"]
[null,null,null,null,null,"kpainter@uidaho.edu"]
[]
[null,null,null,null,null,"2University of Idaho Extension specialist, Lewis County"]
[null,null,null,null,null,"khart@uidaho.edu"]

{"sheet":"Instructions","index":1,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS AND ASSUMPTIONS"]
[null,"General Instructions:"]
[null,"A color coding system is used to indicate the source of the data for each budget and to show which data can be adjusted. Orange cells can be changed without affecting the underlying equations in this cost calculator. Data in yellow cells are from the Summary sheet (click on yellow Summary tab or select it from the TabSelect drop-down menu). In the Summary sheet both crop price and yield are in orange cells. Adjusting any of those numbers will automatically update all calculations throughout the spreadsheet. You can quickly compare price and yield changes by crop and rotation on net returns and land costs. You can also see rotational impacts. For example, if you know that a crop will have a higher yield in a particular sequence, adjust the crop yield in the upper table and see the rotational impact in the second table. You can save the file with this data, then create another scenario and save it as a different file. The graphical tab will illustrate the results of these changes automatically."]
[null,"Input Prices:"]
[null,"By entering input prices on the Input Prices sheet (click on the green Input Prices tab), all of the cost calculations will be automatically updated. Input cost changes can also be made on individual crop price sheets, over-riding the input cost formulae on that particular crop budget. Fertilizer prices are based on current (Apr 09) quotes, but they are subject to uncertainty. Chemical input prices are based on February, 2009, quotes from chemical and seed dealers. These prices are subject to change, however, and will affect profitability of different crops."]
[null,"Crop Prices:"]
[null,"Crop prices can be adjusted on the Summary tab and the effects of this change will be reflected throughout all the budgets. (Yields can be adjusted similarly.) Grain prices are based on futures prices for July and August 2009, as of April 2009, FOB Lind, Washington. (Source: Union Elevator, http://www.unionelevator.com). Canola cash prices are from northerncanola.com for Apr 2009."]
[null,"Machinery Costs:"]
[null,"The machinery complement and associated hourly machinery cost data are in the last two sheets. The hourly machinery cost data are used to create the individualized machinery cost data for each budget, located in a separate tab for each crop. In the crop budget sheets, entries in blue cells are calculated by the machinery cost program and come from the associated Machinery Cost sheet for that crop. Machinery fixed costs include capital recovery costs, property taxes, insurance, and housing. For the overall farm operation, these costs do not vary by crop, given the ownership of a specific machinery complement, and are incurred whether or not crops are grown. Your per acre fixed costs will change if the farm size differs significantly from the size used in these budgets."]
[null,"Land Costs:"]
[null,"Land costs, included either as real or as opportunity costs, are based on a typical share rental arrangement. We calculate net land rental cost as a cost share as follows:"]
[null,"1/3 Crop Value – (1/3 Fertilizer Cost + 1/3 Chemical Cost + 1/3 Crop Insurance + Land Taxes)"]
[null,"A typical lease agreement in the areas surveyed is a one-third land owner and two-third tenant crop share, with the land owner paying land taxes, one-third of the fertilizer cost, one-third of the chemical cost, and one-third of the crop insurance. The tenant covers all other production expenses. This crop-share percentage can be adjusted in the crop worksheets. If the percentage is adjusted on the Summary tab, it is changed for all crops. If you want different crop-share percentages for different crops, adjust the percentage on the budget sheet for that crop. This valuable tool reveals how factors such as crop and input price increases as well as cropping choices affect revenue for landlords and operators differently."]
[null,"While the owner-operator will not actually experience a land rental cost, this cost represents the minimum return owner-operators must realize to justify growing the crop themselves.  To determine the profitability of crop production relative to other activities, the owner-operator may want to consider these forgone rental returns along with the usual production expenses."]
[null,"General Assumptions:"]
[null,"Since farming is inherently variable and constantly changing, we hope that this spreadsheet format will be helpful in adjusting these budgets to reflect your particular operation. Enterprise costs and returns vary from one location to the next and over time for any particular farming operation. Variability stems from differences in the following:"]
[null,"• Capital, labor, and natural resources"]
[null,"• Type and size of machinery complement"]
[null,"• Cultural practices"]
[null,"• Size of farm enterprise"]
[null,"• Crop yields"]
[null,"• Input prices"]
[null,"• Commodity prices"]
[null,"• Management skill"]
[]
[]
[null,"Please examine closely the assumptions we have used and make adjustments to reflect your particular operation. Adjustments in the variable costs can easily be made without affecting the overall accuracy of the budget information. Machinery costs are more difficult to adjust, due to the underlying complexity of machinery cost calculations. A separate machinery cost calculator program is used to develop the costs used in these budgets, which are based on specific machinery widths, tractor horsepower, type of operation, etc. The machinery cost program and data sets specific to this budget are available upon request."]
[null,"Acknowledgments:"]
[null,"I wish to thank everyone who helped gather all of the information needed to create these worksheets. First and foremost, I thank the farmers who were willing to take the time to share their enterprise information in order to create this worksheet. Without their assistance we would not be able to provide this critical information to others. However, I take responsibility for any errors in these budgets."]
[]
[null,"Budget spreadsheets are available at the following link:"]
[null,"http://www.webpages.uidaho.edu/~kpainter/"]

{"sheet":"Summary","index":2,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[7,1,7,11],[44,1,44,4],[45,1,45,4]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Summary of Returns by Crop and Rotation ($/acre/yr)"]
[]
[null,"In the spreadsheet version, you may adjust yield, price, and crop-share % information in orange cells."]
[null,"All land cost (crop-share) and other data will adjust automatically throughout.",null,null,null,null,null,null,null,null,"Crop & Cost"]
[null,null,null,null,null,null,"Total","Returns","Total","Returns ","Share**"]
[null,null,null,"Yield ","Price*","Revenue","Cost of","over TC","Variable","over VC","Operator:",0.67,"Operator"]
[null,"By Crop:","Unit","per acre","per unit","per acre","Operation","($/acre)","Costs","($/acre)","Owner:",0.33,"Owner"]
[null,"Soft White Winter Wheat (SWWW)","bu",74,4.88,{"$f":"D15*E15","v":361.12},{"$f":"'SWWW Budget'!$J$73","v":325.67319999999989},{"$f":"D15*E15-G15","v":35.44680000000011},{"$f":"'SWWW Budget'!$J$55","v":217.45337499999988},{"$f":"F15-I15","v":143.66662500000012},{"$f":"'SWWW Budget'!$J$62","v":68.700824999999995}]
[null,"Hard Red Winter Wheat (HRWW)","bu",74,5.73,424.02000000000004,{"$f":"'HRWW Budget'!$J$73","v":372.34149999999988},51.678500000000156,{"$f":"'HRWW Budget'!$J$53","v":11.10585},412.91415000000006,{"$f":"'HRWW Budget'!$J$61","v":5.229000000000001}]
[null,"Soft White Spring Wheat (SWSW)","bu",58,4.88,283.04000000000002,{"$f":"'SWSW Budget'!$J$79","v":286.6629324999999},-3.6229324999998767,{"$f":"'SWSW Budget'!$J$61","v":197.39196249999992},85.6480375000001,{"$f":"'SWSW Budget'!$J$68","v":47.681970000000014}]
[null,"Hard Red Spring Wheat (HRSW)","bu",58,6.79,393.82,{"$f":"'HRSW Budget'!$J$79","v":344.37006249999996},49.449937500000033,{"$f":"'HRSW Budget'!$J$61","v":223.01781249999999},170.8021875,{"$f":"'HRSW Budget'!$J$68","v":79.763249999999985}]
[null,"Bluegrass Establishment (BGE)","lb",null,null,0,{"$f":"'BGE Budget'!$J$56","v":83.776906249999996},-83.776906249999996,{"$f":"'BGE Budget'!J45","v":57.057906250000002},-57.057906250000002]
[null,"Bluegrass Production (BG)","lb",675,0.65,{"$f":"D20*E20","v":438.75},{"$f":"'BG Budget'!$J$73","v":632.83418383254025},{"$f":"D20*E20-G20","v":-194.08418383254025},{"$f":"'BG Budget'!$J$53","v":296.56124999999997},{"$f":"F20-I20","v":142.18875000000003},{"$f":"'BG Budget'!$J$60","v":287.42070000000001}]
[null,"Spring Canola (SC)","lb",1300,0.16500000000000001,214.5,{"$f":"'Spring Canola Budget'!J70","v":278.81832749999995},-64.318327499999953,{"$f":"'Spring Canola Budget'!J52","v":205.22103749999997},9.2789625000000342,{"$f":"'Spring Canola Budget'!$H$59","v":32.008289999999995}]
[null,"Chem Fallow (CF)","lb",null,null,0,{"$f":"'CF Budget'!J52","v":79.333800000000011},-79.333800000000011,{"$f":"'CF Budget'!J41","v":54.844800000000006},-54.844800000000006]
[null,"*August 2009 farmgate prices for grains, posted by the Union Elevator, Lind, WA, www.unionelevator.com, accessed Apr 2009."]
[null,"Canola price from northerncanola.com for Aug 09."]
[null,"**In a crop- and cost-share arrangement, the landowner and the farm manager split the crop and the specified costs, typically fertilizer, chemicals"]
[null,"and crop insurance."]
[null,null,null,null,null,null,null,null,"Aver.",null,"Aver."]
[null,null,null,null,null,null,"Aver.","Aver.","Total","Aver.","Cost"]
[null,null,null,null,null,"Aver.","Total","Returns","Variable","Returns ","Share"]
[null,null,null,null,null,"Revenue","Cost (TC)","over TC","Costs (VC)","over VC","Cost "]
[null,"By Rotation:",null,null,null,"($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","($/acre)"]
[null,"SWWW, SWSW, SC",null,null,null,{"$f":"AVERAGE(F$15,F$17,F$21)","v":286.22000000000003},{"$f":"AVERAGE(G$15,G$17,G$21)","v":297.05148666666656},-10.831486666666573,206.68879166666659,79.531208333333424,49.463695000000001]
[null,"SWWW, HRSW, SC",null,null,null,{"$f":"AVERAGE(F$15,F$18,F$21)","v":323.1466666666667},{"$f":"AVERAGE(G$15,G$18,G$21)","v":316.2871966666666},6.859470000000063,215.2307416666666,107.91592500000006,60.157454999999992]
[null,"HRWW, SWSW, SC",null,null,null,{"$f":"AVERAGE(F$17,F$16,F$21)","v":307.18666666666667},{"$f":"AVERAGE(G$17,G$16,G$21)","v":312.60758666666658},-5.4209199999998914,137.90628333333328,169.28038333333339,28.306420000000003]
[null,"HRWW, HRSW, SC",null,null,null,{"$f":"AVERAGE(F$16,F$18,F$21)","v":344.1133333333334},{"$f":"AVERAGE(G$16,G$18,G$21)","v":331.84329666666662},12.270036666666746,146.44823333333332,197.66510000000002,39.000179999999993]
[null,"SWWW, SWSW, BGE, BG x 6",null,null,null,{"$f":"AVERAGE(F$15,F$17,F$20,F$20,F$20,F$20,F$20,F$20,)","v":364.07333333333332},{"$f":"AVERAGE(G$15,G$17,G$20,G$20,G$20,G$20,G$20,G$20,)","v":489.92680394391573},-125.85347061058236,243.80142638888881,120.27190694444448,204.54522166666669]
[null,"SWWW, HRSW, BGE, BG x 6",null,null,null,{"$f":"AVERAGE(F$15,F$18,F$20,F$20,F$20,F$20,F$20,F$20)","v":423.43},{"$f":"AVERAGE(G$15,G$18,G$20,G$20,G$20,G$20,G$20,G$20)","v":558.38104568690528},-134.95104568690516,277.47983593749996,145.95016406250002,234.12353437500002]
[null,"HRWW, SWSW, BGE, BG x 6",null,null,null,{"$f":"AVERAGE(F$17,F$16,F$20, F$20,F$20,F$20,F$20,F$20)","v":417.44499999999999},{"$f":"AVERAGE(G$17,G$16,G$20, G$20,G$20,G$20,G$20,G$20)","v":557.00119193690523},-139.55619193690515,248.48316406249998,168.96183593750004,222.17939625000002]
[null,"HRWW, HRSW, BGE, BG x 6",null,null,null,{"$f":"AVERAGE(F$16,F$18,F$20,F$20,F$20,F$20,F$20,F$20)","v":431.29250000000002},{"$f":"AVERAGE(G$16,G$18,G$20,G$20,G$20,G$20,G$20,G$20)","v":564.2145831869052},-132.92208318690516,251.68639531249997,179.60610468750002,226.18955625000001]
[null,"SWWW, SWSW, CF",null,null,null,{"$f":"AVERAGE(F$15,F$17,F$22)","v":214.72000000000003},{"$f":"AVERAGE(G$15,G$17,G$22)","v":230.55664416666662},-15.836644166666593,156.56337916666661,58.156620833333399,58.191397500000008]
[null,"SWWW, HRSW, CF",null,null,null,{"$f":"AVERAGE(F$15,F$18,F$22)","v":251.64666666666668},{"$f":"AVERAGE(G$15,G$18,G$22)","v":249.79235416666663},1.854312500000044,165.10532916666662,86.54133750000004,74.23203749999999]
[null,"HRWW, SWSW, CF",null,null,null,{"$f":"AVERAGE(F$17,F$16,F$22)","v":235.6866666666667},{"$f":"AVERAGE(G$17,G$16,G$22)","v":246.1127441666666},-10.426077499999911,87.78087083333331,147.90579583333337,26.455485000000007]
[null,"HRWW, HRSW, CF",null,null,null,{"$f":"AVERAGE(F$16,F$18,F$22)","v":272.61333333333334},{"$f":"AVERAGE(G$16,G$18,G$22)","v":265.34845416666661},7.2648791666667263,96.322820833333324,176.29051250000001,42.496124999999992]
[]
[null,"Budget spreadsheets are available at the following link:"]
[null,"http://www.uidaho.edu/~kpainter"]

{"sheet":"Graphical","index":3,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Graphical Summary of Returns by Crop and Rotation ($/acre)"]
[]
[null,null,null,"Returns"]
[null,null,null,"over TC"]
[null,null,"By Crop:","($/acre)"]
[null,null,"SWWW",{"$f":"Summary!H15","v":35.44680000000011},null,null,null,null,null,null,null,null,"Crop Prices:"]
[null,null,"HRWW",{"$f":"Summary!H16","v":51.678500000000156},null,null,null,null,null,null,null,null,"SWWW",{"$f":"Summary!E15","v":4.88}]
[null,null,"SWSW",{"$f":"Summary!H17","v":-3.6229324999998767},null,null,null,null,null,null,null,null,"HRWW",{"$f":"Summary!E16","v":5.73}]
[null,null,"HRSW",{"$f":"Summary!H18","v":49.449937500000033},null,null,null,null,null,null,null,null,"SWSW",{"$f":"Summary!E17","v":4.88}]
[null,null,"BGE",{"$f":"Summary!H19","v":-83.776906249999996},null,null,null,null,"LEGEND:",null,null,null,"HRSW",{"$f":"Summary!E18","v":6.79}]
[null,null,"BG",{"$f":"Summary!H20","v":-194.08418383254025},null,null,null,null,"Soft White Winter Wheat (SWWW)",null,null,null,"BG",{"$f":"Summary!E20","v":0.65}]
[null,null,"SC",{"$f":"Summary!H21","v":-64.318327499999953},null,null,null,null,"Hard Red Winter Wheat (HRWW)",null,null,null,"SC",{"$f":"Summary!E21","v":0.16500000000000001}]
[null,null,"CF",{"$f":"Summary!H22","v":-79.333800000000011},null,null,null,null,"Soft White Spring Wheat (SWSW)"]
[null,null,null,null,null,null,null,null,"Hard Red Spring Wheat (HRSW)"]
[null,null,null,null,null,null,null,null,"Bluegrass Establishment (BGE)"]
[null,null,null,null,null,null,null,null,"Bluegrass Production (BG)"]
[null,null,null,null,null,null,null,null,"Spring Canola (SC)"]
[null,null,null,null,null,null,null,null,"Chem Fallow (CF)"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Returns"]
[null,null,null,"over TC"]
[null,null,"By Rotation:","($/acre)"]
[null,null,"SWWW, SWSW, SC",{"$f":"Summary!H32","v":-10.831486666666573}]
[null,null,"SWWW, HRSW, SC",{"$f":"Summary!H33","v":6.859470000000063}]
[null,null,"HRWW, SWSW, SC",{"$f":"Summary!H34","v":-5.4209199999998914}]
[null,null,"HRWW, HRSW, SC",{"$f":"Summary!H35","v":12.270036666666746}]
[null,null,"SWWW, SWSW, BGE, BG x 6",{"$f":"Summary!H36","v":-125.85347061058236}]
[null,null,"SWWW, HRSW, BGE, BG x 6",{"$f":"Summary!H37","v":-134.95104568690516}]
[null,null,"HRWW, SWSW, BGE, BG x 6",{"$f":"Summary!H38","v":-139.55619193690515}]
[null,null,"HRWW, HRSW, BGE, BG x 6",{"$f":"Summary!H39","v":-132.92208318690516}]
[null,null,"SWWW, SWSW, CF",{"$f":"Summary!H40","v":-15.836644166666593}]
[null,null,"SWWW, HRSW, CF",-0.92379583333332482]
[null,null,"HRWW, SWSW, CF",-13.204185833333298]
[null,null,"HRWW, HRSW, CF",4.4867708333333569]

{"sheet":"Input Prices","index":4,"n_rows":92,"n_cols":4,"rows_kept":92,"cut":false,"hidden":false,"merged":[[7,1,7,6]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Input Price Assumptions"]
[null,null,null,"Projected"]
[null,null,null,2009]
[null,null,"Unit","Price/unit"]
[null,"Fuel:"]
[null,"Diesel","gal",2]
[null,"Gas","gal",2.5]
[]
[null,"Seed:"]
[null,"Soft White Winter Wheat Seed","lb",0.15]
[null,"Hard Red Winter Wheat Seed","lb",0.2]
[null,"Soft White Spring Wheat Seed","lb",0.18]
[null,"Hard Red Spring Wheat Seed","lb",0.22]
[null,"Bluegrass Seed","lb",0.3775]
[null,"Canola Seed","lb",6]
[null,"Garbanzo Seed","lb",0.45]
[]
[null,"Fertilizer:"]
[null,"Nitrogen","lb",0.55000000000000004]
[null,"Phosphorous","lb",1.17]
[null,"Sulfur","lb",0.23]
[null,"Potassium","lb",0.46]
[]
[null,"Adjuvants:"]
[null,"Ammonium Sulfate (liquid)","oz",0.02]
[null,"Ammonium Sulfate (20-0-0-24)","lb",0.12]
[null,"Crop Oil Concentrate","pt",1]
[null,"In-Place","oz",0.24]
[null,"M90","oz",0.01]
[null,"Surfactant","oz",0.08]
[null,"Syltac Sticker","pt",6.25]
[]
[null,"Custom Rental:"]
[null,"26' Rental Shredder","acre",10]
[null,"36' Ripper Shooter","acre",2.5]
[null,"90' Rental Sprayer","acre",1.75]
[null,"Custom Swathing","acre",15]
[null,"Custom Aerial","acre",6.5]
[null,"Fertilizer Applicator","acre",1]
[]
[null,"Pesticides:"]
[null,"Achieve SC","oz",2]
[null,"Ally","oz",24.81]
[null,"Assure II","oz",1.2]
[null,"Axial","oz",1.81]
[null,"Banvel 4SC","oz",0.77]
[null,"Beacon","oz",32]
[null,"Bronate","pt",5.68]
[null,"Brox M","oz",0.3]
[null,"Capture","acre",10.17]
[null,"Dimethoate","pt",7]
[null,"Discover","oz",4.41]
[null,"FarGO","qt",12.52]
[null,"Finesse","oz",17.399999999999999]
[null,"Glyphosphate","oz",0.39]
[null,"Imidan 70","lb",9.85]
[null,"Maverick","oz",17.45]
[null,"Poast","pt",9.3800000000000008]
[null,"Osprey","oz",3.55]
[null,"Prowl","oz",0.25]
[null,"Pursuit","oz",4.1500000000000004]
[null,"Quadris","oz",2.23]
[null,"Quilt","oz",1.22]
[null,"R-11","oz",0.9375]
[null,"Starane","oz",0.93]
[null,"Starane + Salvo","oz",0.43]
[null,"Starane + Sword","oz",0.43]
[]
[null,"Labor:"]
[null,"Hourly machine labor*","acre",20]
[]
[null,"Cash Rent:"]
[null,"Cash Rent","acre",0]
[]
[null,"Land Tax:"]
[null,"Land Tax","acre",3.9]
[]
[null,"Miscellaneous:"]
[null,"Burning permit","acre",2]
[null,"Bluegrass bags, tags, etc.","cwt",13]
[]
[null,"Interest:"]
[null,"Operating Loan","percent",7.4999999999999997E-2]
[null,"Machinery Loan/investment","percent",7.4999999999999997E-2]
[null,"*Includes all applicable state and federal taxes."]

{"sheet":"SWWW Budget","index":5,"n_rows":103,"n_cols":10,"rows_kept":103,"cut":false,"hidden":false,"merged":[[78,1,78,9],[13,12,13,17],[12,12,12,16],[7,1,7,10],[59,1,59,3],[60,1,60,3]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data is from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data is from Input Costs page (green tab)."]
[null,"Blue Cells: Data is from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Soft White Winter Wheat, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Wheat",null,{"$f":"yswww","v":74},null,"bu",null,{"$f":"pswww","v":4.88},null,{"$f":"D13*H13","v":361.12}]
[]
[null,"Variable Costs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J18)","v":12}]
[null,"Soft White Winter Wheat Seed",null,80,null,"lb",null,{"$f":"SWWWSd","v":0.15},null,{"$f":"D18*H18","v":12}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J21:J24)","v":77.5}]
[null,"Nitrogen (dry)",null,80,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D21*H21","v":44}]
[null,"Phosphorous (dry)",null,20,null,"lb",null,{"$f":"P","v":1.17},null,{"$f":"D22*H22","v":23.4}]
[null,"Sulfur (dry)",null,20,null,"lb",null,{"$f":"S","v":0.23},null,{"$f":"D23*H23","v":4.6000000000000005}]
[null,"Nitrogen (topdress)1",null,10,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D24*H24","v":5.5}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J27:J34)","v":38.6175}]
[null,"Roundup",null,20,null,"oz",null,{"$f":"Glyphosphate","v":0.39},null,{"$f":"D27*H27","v":7.8000000000000007}]
[null,"Ammonium Sulfate",null,50,null,"oz",null,{"$f":"AmmSulfLiq","v":0.02},null,1]
[null,"M90",null,1.5,null,"oz",null,{"$f":"M","v":0.01},null,1.4999999999999999E-2]
[null,"Osprey",null,4.75,null,"oz",null,{"$f":"Osprey","v":3.55},null,16.862500000000001]
[null,"Starane+Salvo",null,22,null,"oz",null,{"$f":"StaraneSalvo","v":0.43},null,9.4599999999999991]
[null,"Brox M",null,1.6,null,"oz",null,{"$f":"BroxM","v":0.3},null,0.48]
[null,"R-11",null,3.2,null,"oz",null,{"$f":"RPest","v":0.9375},null,{"$f":"D33*H33","v":3}]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J37:J41)","v":45.111999999999995}]
[null,"Fuel",null,{"$f":"'SWWW Mach Costs'!M17","v":5.8462499999999995},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D37*H37","v":11.692499999999999}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'SWWW Mach Costs'!I17","v":2.2294999999999994},null,{"$f":"D38*H38","v":2.2294999999999994}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'SWWW Mach Costs'!G17","v":10.930000000000001},null,{"$f":"D39*H39","v":10.930000000000001}]
[null,"Machinery Labor",null,{"$f":"'SWWW Mach Costs'!L17","v":1.0129999999999999},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D40*H40","v":20.259999999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"D41*H41","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":2.145}]
[null,"Rental Sprayer",null,0,null,"acre",null,{"$f":"Sprayer","v":1.75},null,{"$f":"D44*H44","v":0}]
[null,"Aerial Spray",null,0.33,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D45*H45","v":2.145}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J48:J50)","v":25}]
[null,"Crop insurance",null,1,null,"acre",null,25,null,{"$f":"D48*H48","v":25}]
[null,"Storage Facility & Equip. Repairs.",null,null,null,null,null,null,null,{"$f":"D49*H49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D50*H50","v":0}]
[]
[null,"Overhead2",null,null,null,null,null,null,null,{"$f":"($J$17+$J$20+$J$26+$J$43+$J$47)*0.05","v":7.7631250000000014}]
[null,"Operating Interest3",null,null,null,null,null,null,null,{"$f":"+(J17+J20+J26+J43+J47)*operloan*0.8","v":9.3157500000000013}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J53)-(J17+J20+J26+J36+J43+J47)","v":217.45337499999988}]
[null,"Variable Costs per Unit",null,null,null,null,null,null,null,{"$f":"J55/D13","v":2.93855912162162}]
[]
[null,"Net Returns Above Variable Costs",null,null,null,null,null,null,null,{"$f":"J13-J55","v":143.66662500000012}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'SWWW Mach Costs'!D17:D17","v":30.389999999999997}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'SWWW Mach Costs'!E17","v":5.229000000000001}]
[null,"Land Cost*",null,1,null,"acre",null,{"$f":"+(D13*H13)*D64-(J20+J26+H48)*D64-J68","v":68.700824999999995},null,{"$f":"H62","v":68.700824999999995}]
[null,"*Based on Share Rent Percentage:"]
[null,"  Landlord",null,{"$f":"+ownershare","v":0.33}]
[null,"  Tenant",null,{"$f":"opershare","v":0.67}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J59:J68)","v":108.219825}]
[null,"Fixed Costs per Unit",null,null,null,null,null,null,null,{"$f":"J70/D13","v":1.4624300675675677}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J55+J70","v":325.67319999999989}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J73/D13","v":4.4009891891891879}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J73","v":35.44680000000011}]
[]
[null,"Notes:"]
[null,"1Topdressing is assumed to occur one year in three. Typical application is 30 lb of nitrogen, applied either aerially or with a rogator."]
[null,"2Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"3Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[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":"F87*(1-D85)","v":66.600000000000009},null,{"$f":"D13","v":74},null,{"$f":"F87*(1+H85)","v":81.400000000000006}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$55/D87","v":3.2650656906906885},null,{"$f":"$J$55/F87","v":2.93855912162162},null,{"$f":"$J$55/H87","v":2.6714173832923818}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$70/D87","v":1.6249222972972972},null,{"$f":"$J$70/F87","v":1.4624300675675677},null,{"$f":"$J$70/H87","v":1.3294818796068795}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$73/D87","v":4.8899879879879862},null,{"$f":"$J$73/F87","v":4.4009891891891879},null,{"$f":"$J$73/H87","v":4.000899262899261}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F97*(1-D85)","v":4.3920000000000003},null,{"$f":"H13","v":4.88},null,{"$f":"F97*(1+H85)","v":5.3680000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$55/D97","v":49.511242030965363},null,{"$f":"$J$55/F97","v":44.560117827868829},null,{"$f":"$J$55/H97","v":40.509198025335294}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$70/D97","v":24.640215163934425},null,{"$f":"$J$70/F97","v":22.176193647540984},null,{"$f":"$J$70/H97","v":20.160176043219074}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$73/D97","v":74.151457194899791},null,{"$f":"$J$73/F97","v":66.736311475409821},null,{"$f":"$J$73/H97","v":60.669374068554376}]

{"sheet":"SWWW Mach Costs","index":6,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9]]}
[]
[null,"Soft White Winter Wheat  Machinery Costs ($/acre)"]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"425HP-WT + 60' Heavy Harrow1","Aug/Sept",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"200HP-WT + 100' Pull Sprayer2","Sept",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' NT Drill3","Sept",{"$f":"'Machinery Costs'!C19","v":5.45},{"$f":"'Machinery Costs'!D19","v":0.57999999999999996},{"$f":"'Machinery Costs'!E19","v":6.03},{"$f":"'Machinery Costs'!F19","v":3.12},{"$f":"'Machinery Costs'!G19","v":2.8134999999999999},{"$f":"'Machinery Costs'!H19","v":0.4965},{"$f":"'Machinery Costs'!I19","v":6.43},{"$f":"'Machinery Costs'!J19","v":1.69},{"$f":"'Machinery Costs'!K19","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L19","v":1.4067499999999999},{"$f":"'Machinery Costs'!M19","v":14.149999999999999}]
[null,"200HP-WT + 100' Pull Sprayer4","April",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' Combine","August",{"$f":"'Machinery Costs'!C20","v":10.16},{"$f":"'Machinery Costs'!D20","v":0.87},{"$f":"'Machinery Costs'!E20","v":11.03},{"$f":"'Machinery Costs'!F20","v":1.43},{"$f":"'Machinery Costs'!G20","v":2.81},{"$f":"'Machinery Costs'!H20","v":0.5},{"$f":"'Machinery Costs'!I20","v":4.74},{"$f":"'Machinery Costs'!J20","v":1.69},{"$f":"'Machinery Costs'!K20","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L20","v":1.405},{"$f":"'Machinery Costs'!M20","v":17.46}]
[null,"200HP-WT + Bankout Wagon","August",{"$f":"'Machinery Costs'!C21","v":1.91},{"$f":"'Machinery Costs'!D21","v":0.2},{"$f":"'Machinery Costs'!E21","v":2.11},{"$f":"'Machinery Costs'!F21","v":0.82},{"$f":"'Machinery Costs'!G21","v":1.3260000000000001},{"$f":"'Machinery Costs'!H21","v":0.23399999999999999},{"$f":"'Machinery Costs'!I21","v":2.38},{"$f":"'Machinery Costs'!J21","v":1.69},{"$f":"'Machinery Costs'!K21","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L21","v":0.66300000000000003},{"$f":"'Machinery Costs'!M21","v":6.18}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D16)","v":30.389999999999997},{"$f":"SUM(E6:E16)","v":5.229000000000001},35.619,10.930000000000001,11.692499999999999,2.2294999999999994,24.851999999999997,20.260000000000002,1.0129999999999999,5.8462499999999995,80.73099999999998]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"1Harrow once unless following winter wheat, in which case you'll need an additional harrow operation."]
[null,"2Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"3Typically 80 lb seed, 80 lb N, 20 lb P, 20 lb S."]
[null,"4Typically a tankmix with a wildoat spray such as Osprey (4.75 oz) and broadleaf sprays such as Starane+Salvo (22 oz) and Brox M (16 oz) plus a surfactant such as R-11 (3.2 oz)."]

{"sheet":"HRWW Budget","index":7,"n_rows":103,"n_cols":10,"rows_kept":103,"cut":false,"hidden":false,"merged":[[7,1,7,10],[78,1,78,9],[12,12,12,16],[13,12,13,17],[60,1,60,3],[59,1,59,3]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data is from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data is from Input Costs page (green tab)."]
[null,"Blue Cells: Data is from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Hard Red Winter Wheat, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Wheat",null,{"$f":"yhrww","v":74},null,"bu",null,{"$f":"phrww","v":5.73},null,{"$f":"D13*H13","v":424.02000000000004}]
[]
[null,"Variable Costs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J18)","v":20}]
[null,"Hard Red Winter Wheat Seed",null,100,null,"lb",null,{"$f":"HRWWSd","v":0.2},null,{"$f":"D18*H18","v":20}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J21:J24)","v":94}]
[null,"Nitrogen (dry)",null,110,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D21*H21","v":60.500000000000007}]
[null,"Phosphorous (dry)",null,20,null,"lb",null,{"$f":"P","v":1.17},null,{"$f":"D22*H22","v":23.4}]
[null,"Sulfur (dry)",null,20,null,"lb",null,{"$f":"S","v":0.23},null,{"$f":"D23*H23","v":4.6000000000000005}]
[null,"Nitrogen (topdress)1",null,10,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D24*H24","v":5.5}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J27:J34)","v":43.952500000000001}]
[null,"Roundup",null,20,null,"oz",null,{"$f":"Glyphosphate","v":0.39},null,{"$f":"D27*H27","v":7.8000000000000007}]
[null,"Ammonium Sulfate",null,100,null,"oz",null,{"$f":"AmmSulfLiq","v":0.02},null,2]
[null,"M90",null,3,null,"oz",null,{"$f":"M","v":0.01},null,0.03]
[null,"Osprey",null,4.75,null,"oz",null,{"$f":"Osprey","v":3.55},null,16.862500000000001]
[null,"Starane+Salvo",null,22,null,"oz",null,{"$f":"StaraneSalvo","v":0.43},null,9.4599999999999991]
[null,"Brox M",null,16,null,"oz",null,{"$f":"BroxM","v":0.3},null,4.8]
[null,"R-11",null,3.2,null,"oz",null,{"$f":"RPest","v":0.9375},null,{"$f":"D33*H33","v":3}]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J37:J41)","v":45.111999999999995}]
[null,"Fuel",null,{"$f":"'HRWW Mach Costs'!M17","v":5.8462499999999995},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D37*H37","v":11.692499999999999}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"+'HRWW Mach Costs'!I17","v":2.2294999999999994},null,{"$f":"D38*H38","v":2.2294999999999994}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'HRWW Mach Costs'!G17","v":10.930000000000001},null,{"$f":"D39*H39","v":10.930000000000001}]
[null,"Machinery Labor",null,{"$f":"'HRWW Mach Costs'!L17","v":1.0129999999999999},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D40*H40","v":20.259999999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"D41*H41","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J44:J45)","v":2.145}]
[null,"Rental Sprayer",null,0,null,"acre",null,{"$f":"Sprayer","v":1.75},null,{"$f":"D44*H44","v":0}]
[null,"Aerial Spray",null,0.33,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D45*H45","v":2.145}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J48:J50)","v":25}]
[null,"Crop insurance",null,1,null,"acre",null,25,null,{"$f":"D48*H48","v":25}]
[null,"Storage Facility & Equip. Repairs.",null,null,null,null,null,null,null,{"$f":"D49*H49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D50*H50","v":0}]
[]
[null,"Overhead2",null,null,null,null,null,null,null,{"$f":"($J$17+$J$20+$J$26+$J$43+$J$47)*0.05","v":9.2548750000000002}]
[null,"Operating Interest3",null,null,null,null,null,null,null,{"$f":"+(J17+J20+J26+J43+J47)*operloan*0.8","v":11.10585}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J53)-(J17+J20+J26+J36+J43+J47)","v":250.57022499999988}]
[null,"Variable Costs per Unit",null,null,null,null,null,null,null,{"$f":"J55/D13","v":3.3860841216216202}]
[]
[null,"Net Returns Above Variable Costs",null,null,null,null,null,null,null,{"$f":"J13-J55","v":173.44977500000016}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'HRWW Mach Costs'!D17","v":30.389999999999997}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'HRWW Mach Costs'!E17","v":5.229000000000001}]
[null,"Land Cost*",null,1,null,"acre",null,{"$f":"+(D13*H13)*D64-(J20+J26+H48)*D64-J68","v":82.252274999999997},null,{"$f":"H62","v":82.252274999999997}]
[null,"*Based on Share Rent Percentage:"]
[null,"  Landlord",null,{"$f":"+ownershare","v":0.33}]
[null,"  Tenant",null,{"$f":"opershare","v":0.67}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J59:J68)","v":121.771275}]
[null,"Fixed Costs per Unit",null,null,null,null,null,null,null,{"$f":"J70/D13","v":1.6455577702702704}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J55+J70","v":372.34149999999988}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J73/D13","v":5.0316418918918906}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J73","v":51.678500000000156}]
[]
[null,"Notes:"]
[null,"1Topdressing is assumed to occur one year in three. Typical application is 30 lb of nitrogen, applied either aerially or with a rogator."]
[null,"2Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"3Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[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":"F87*(1-D85)","v":66.600000000000009},null,{"$f":"D13","v":74},null,{"$f":"F87*(1+H85)","v":81.400000000000006}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$55/D87","v":3.7623156906906883},null,{"$f":"$J$55/F87","v":3.3860841216216202},null,{"$f":"$J$55/H87","v":3.0782582923832909}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$70/D87","v":1.8283975225225224},null,{"$f":"$J$70/F87","v":1.6455577702702704},null,{"$f":"$J$70/H87","v":1.4959616093366093}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$73/D87","v":5.5907132132132107},null,{"$f":"$J$73/F87","v":5.0316418918918906},null,{"$f":"$J$73/H87","v":4.5742199017198999}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F97*(1-D85)","v":5.1570000000000009},null,{"$f":"H13","v":5.73},null,{"$f":"F97*(1+H85)","v":6.3030000000000008}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$55/D97","v":48.588370176459151},null,{"$f":"$J$55/F97","v":43.72953315881324},null,{"$f":"$J$55/H97","v":39.754121053466577}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$70/D97","v":23.612812681791734},null,{"$f":"$J$70/F97","v":21.251531413612565},null,{"$f":"$J$70/H97","v":19.319574012375057}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$73/D97","v":72.201182858250888},null,{"$f":"$J$73/F97","v":64.981064572425808},null,{"$f":"$J$73/H97","v":59.073695065841633}]

{"sheet":"HRWW Mach Costs","index":8,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,3,4,3],[3,4,4,4],[3,5,4,5],[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,9,4,9],[3,6,4,6],[3,7,4,7],[3,8,4,8]]}
[]
[null,"Hard Red Winter Wheat  Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"425HP-WT + 60' Heavy Harrow1","Aug/Sept",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"200HP-WT + 100' Pull Sprayer2","Sept",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' NT Drill3","Sept",{"$f":"'Machinery Costs'!C19","v":5.45},{"$f":"'Machinery Costs'!D19","v":0.57999999999999996},{"$f":"'Machinery Costs'!E19","v":6.03},{"$f":"'Machinery Costs'!F19","v":3.12},{"$f":"'Machinery Costs'!G19","v":2.8134999999999999},{"$f":"'Machinery Costs'!H19","v":0.4965},{"$f":"'Machinery Costs'!I19","v":6.43},{"$f":"'Machinery Costs'!J19","v":1.69},{"$f":"'Machinery Costs'!K19","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L19","v":1.4067499999999999},{"$f":"'Machinery Costs'!M19","v":14.149999999999999}]
[null,"200HP-WT + 100' Pull Sprayer4","April",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' Combine","August",{"$f":"'Machinery Costs'!C20","v":10.16},{"$f":"'Machinery Costs'!D20","v":0.87},{"$f":"'Machinery Costs'!E20","v":11.03},{"$f":"'Machinery Costs'!F20","v":1.43},{"$f":"'Machinery Costs'!G20","v":2.81},{"$f":"'Machinery Costs'!H20","v":0.5},{"$f":"'Machinery Costs'!I20","v":4.74},{"$f":"'Machinery Costs'!J20","v":1.69},{"$f":"'Machinery Costs'!K20","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L20","v":1.405},{"$f":"'Machinery Costs'!M20","v":17.46}]
[null,"200HP-WT + Bankout Wagon","August",{"$f":"'Machinery Costs'!C21","v":1.91},{"$f":"'Machinery Costs'!D21","v":0.2},{"$f":"'Machinery Costs'!E21","v":2.11},{"$f":"'Machinery Costs'!F21","v":0.82},{"$f":"'Machinery Costs'!G21","v":1.3260000000000001},{"$f":"'Machinery Costs'!H21","v":0.23399999999999999},{"$f":"'Machinery Costs'!I21","v":2.38},{"$f":"'Machinery Costs'!J21","v":1.69},{"$f":"'Machinery Costs'!K21","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L21","v":0.66300000000000003},{"$f":"'Machinery Costs'!M21","v":6.18}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D16)","v":30.389999999999997},{"$f":"SUM(E6:E16)","v":5.229000000000001},35.619,10.930000000000001,11.692499999999999,2.2294999999999994,24.851999999999997,20.260000000000002,1.0129999999999999,5.8462499999999995,80.73099999999998]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"1Harrow once unless following winter wheat, in which case you'll need an additional harrow operation."]
[null,"2Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"3Typically 80 lb seed, 80 lb N, 20 lb P, 20 lb S."]
[null,"4Typically a tankmix with a wildoat spray such as Osprey (4.75 oz) and broadleaf sprays such as Starane+Salvo (22 oz) and Brox M (16 oz) plus a surfactant such as R-11 (3.2 oz)."]

{"sheet":"SWSW Budget","index":9,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":false,"merged":[[7,1,7,9],[86,1,86,9],[87,1,87,9]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Soft White Spring Wheat, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Soft White Spring Wheat",null,{"$f":"Summary!D17","v":58},null,"bu",null,{"$f":"Summary!E17","v":4.88},null,{"$f":"D13*H13","v":283.04000000000002}]
[null,"Variable Costs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J17:J17)","v":12}]
[null,"Soft White Wheat Seed",null,80,null,"lb",null,{"$f":"Wheat","v":0.15},null,{"$f":"D17*H17","v":12}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J20:J24)","v":72}]
[null,"Nitrogen (dry)",null,80,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D20*H20","v":44}]
[null,"Phosphorous (dry)",null,20,null,"lb",null,{"$f":"P","v":1.17},null,{"$f":"D21*H21","v":23.4}]
[null,"Potassium (dry)",null,0,null,"lb",null,{"$f":"K","v":0.46},null,{"$f":"D22*H22","v":0}]
[null,"Sulfur (dry)",null,20,null,"lb",null,{"$f":"S","v":0.23},null,{"$f":"D23*H23","v":4.6000000000000005}]
[null,null,null,null,null,null,null,null,null,{"$f":"D24*H24","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J27:J34)","v":34.731000000000002}]
[null,"Roundup",null,36,null,"oz",null,{"$f":"Glyphosphate","v":0.39},null,{"$f":"D27*H27","v":14.040000000000001}]
[null,"M90",null,3,null,"oz",null,{"$f":"M","v":0.01},null,0.03]
[null,"Ammonium Sulfate",null,50,null,"oz",null,{"$f":"AmmSulfLiq","v":0.02},null,1]
[null,"Axial",null,4.0999999999999996,null,"oz",null,{"$f":"Axial","v":1.81},null,7.4209999999999994]
[null,"Brox M",null,12,null,"oz",null,{"$f":"BroxM","v":0.3},null,3.5999999999999996]
[null,"Starane",null,8,null,"oz",null,{"$f":"Starane","v":0.93},null,7.44]
[null,"InPlace",null,5,null,"oz",null,{"$f":"InPlace","v":0.24},null,1.2]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Fungicides:",null,null,null,null,null,null,null,{"$f":"SUM(J37:J39)","v":0}]
[null,"Quilt",null,0,null,"oz",null,{"$f":"Quilt","v":1.22},null,{"$f":"D37*H37","v":0}]
[null,"Syltac Sticker",null,0,null,"pt",null,{"$f":"Syltac","v":6.25},null,{"$f":"D38*H38","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D39*H39","v":0}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J42:J46)","v":46.521999999999998}]
[null,"Fuel",null,{"$f":"'SWSW Mach Costs'!M18","v":6.0162499999999994},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D42*H42","v":12.032499999999999}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'SWSW Mach Costs'!I18","v":2.2894999999999994},null,{"$f":"D43*H43","v":2.2894999999999994}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'SWSW Mach Costs'!G18","v":11.51},null,{"$f":"D44*H44","v":11.51}]
[null,"Machinery Labor",null,{"$f":"'SWSW Mach Costs'!L18","v":1.0345},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D45*H45","v":20.689999999999998}]
[null,"Other Labor",null,null,null,null,null,null,null,{"$f":"D46*H46","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J49:J51)","v":0}]
[null,"Rental Sprayer",null,0,null,"acre",null,{"$f":"Sprayer","v":1.75},null,{"$f":"D49*H49","v":0}]
[null,"Custom Aerial",null,0,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D50*H50","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D51*H51","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J54:J56)","v":20}]
[null,"Crop insurance",null,1,null,"acre",null,20,null,{"$f":"D54*H54","v":20}]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,{"$f":"D55*H55","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D56*H56","v":0}]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(J16+J19+J26+J36+J48+J53)*0.05","v":6.9365500000000004}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"(J16+J19+J26+J36+J48+J53)*operloan*0.5","v":5.2024124999999994}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J16:J59)-(J16+J19+J26+J36+J41+J48+J53)","v":197.39196249999992}]
[null,"Variable Costs per Unit",null,null,null,null,null,null,null,{"$f":"J61/D13","v":3.4033096982758608}]
[]
[null,"Net Returns Above Variable Costs",null,null,null,null,null,null,null,{"$f":"J13-J61","v":85.6480375000001}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'SWSW Mach Costs'!D18","v":32.249999999999993}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'SWSW Mach Costs'!E18","v":5.4390000000000009}]
[null,"Land Cost*",null,1,null,"acre",null,{"$f":"+(D13*H13)*D70-(J19+J26+J36+H54)*D70-J74","v":47.681970000000014},null,{"$f":"D68*H68","v":47.681970000000014}]
[null,"*Based on Share Rent Percentage:"]
[null,"  Landlord",null,{"$f":"+ownershare","v":0.33}]
[null,"  Tenant",null,{"$f":"opershare","v":0.67}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J65:J74)","v":89.270970000000005}]
[null,"Fixed Costs per Unit",null,null,null,null,null,null,null,{"$f":"J76/D13","v":1.5391546551724138}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J61+J76","v":286.6629324999999}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J79/D13","v":4.9424643534482744}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J79","v":-3.6229324999998767}]
[]
[null,"Notes:"]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[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":"F93*(1-D91)","v":52.2},null,{"$f":"D13","v":58},null,{"$f":"F93*(1+H91)","v":63.800000000000004}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$61/D93","v":3.7814552203065115},null,{"$f":"$J$61/F93","v":3.4033096982758608},null,{"$f":"$J$61/H93","v":3.0939179075235095}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$76/D93","v":1.7101718390804599},null,{"$f":"$J$76/F93","v":1.5391546551724138},null,{"$f":"$J$76/H93","v":1.3992315047021944}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$79/D93","v":5.4916270593869712},null,{"$f":"$J$79/F93","v":4.9424643534482744},null,{"$f":"$J$79/H93","v":4.4931494122257032}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F103*(1-D91)","v":4.3920000000000003},null,{"$f":"H13","v":4.88},null,{"$f":"F103*(1+H91)","v":5.3680000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$61/D103","v":44.94352515938067},null,{"$f":"$J$61/F103","v":40.449172643442608},null,{"$f":"$J$61/H103","v":36.771975130402367}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$76/D103","v":20.325812841530055},null,{"$f":"$J$76/F103","v":18.293231557377052},null,{"$f":"$J$76/H103","v":16.630210506706408}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$79/D103","v":65.269338000910722},null,{"$f":"$J$79/F103","v":58.742404200819649},null,{"$f":"$J$79/H103","v":53.402185637108772}]

{"sheet":"SWSW Mach Costs","index":10,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,24,13],[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9]]}
[]
[null,"Soft White Spring Wheat  Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"425HP-WT + 60' Heavy Harrow","Sept",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"200HP-WT + 100' Pull Sprayer1","October",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"200HP-WT + 100' Pull Sprayer2","April",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' NT Drill3","April",{"$f":"'Machinery Costs'!C19","v":5.45},{"$f":"'Machinery Costs'!D19","v":0.57999999999999996},{"$f":"'Machinery Costs'!E19","v":6.03},{"$f":"'Machinery Costs'!F19","v":3.12},{"$f":"'Machinery Costs'!G19","v":2.8134999999999999},{"$f":"'Machinery Costs'!H19","v":0.4965},{"$f":"'Machinery Costs'!I19","v":6.43},{"$f":"'Machinery Costs'!J19","v":1.69},{"$f":"'Machinery Costs'!K19","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L19","v":1.4067499999999999},{"$f":"'Machinery Costs'!M19","v":14.149999999999999}]
[null,"200HP-WT + 100' Pull Sprayer4","May",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' Combine","August",{"$f":"'Machinery Costs'!C20","v":10.16},{"$f":"'Machinery Costs'!D20","v":0.87},{"$f":"'Machinery Costs'!E20","v":11.03},{"$f":"'Machinery Costs'!F20","v":1.43},{"$f":"'Machinery Costs'!G20","v":2.81},{"$f":"'Machinery Costs'!H20","v":0.5},{"$f":"'Machinery Costs'!I20","v":4.74},{"$f":"'Machinery Costs'!J20","v":1.69},{"$f":"'Machinery Costs'!K20","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L20","v":1.405},{"$f":"'Machinery Costs'!M20","v":17.46}]
[null,"200HP-WT + Bankout Wagon","August",{"$f":"'Machinery Costs'!C21","v":1.91},{"$f":"'Machinery Costs'!D21","v":0.2},{"$f":"'Machinery Costs'!E21","v":2.11},{"$f":"'Machinery Costs'!F21","v":0.82},{"$f":"'Machinery Costs'!G21","v":1.3260000000000001},{"$f":"'Machinery Costs'!H21","v":0.23399999999999999},{"$f":"'Machinery Costs'!I21","v":2.38},{"$f":"'Machinery Costs'!J21","v":1.69},{"$f":"'Machinery Costs'!K21","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L21","v":0.66300000000000003},{"$f":"'Machinery Costs'!M21","v":6.18}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D17)","v":32.249999999999993},{"$f":"SUM(E6:E17)","v":5.4390000000000009},37.689,11.51,12.032499999999999,2.2894999999999994,25.831999999999997,20.69,1.0345,6.0162499999999994,84.210999999999999]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"1Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"2Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"3Typically 80 lb seed, 80 lb N, 20 lb P, 20 lb S."]
[null,"4Typically a tankmix with broadleaf sprays such as Starane+Salvo (22 oz) and Brox M (12 oz) plus a surfactant such as R-11 (3.2 oz). In addition, a wildoat spray such as Axial (8.2 oz/ac) is used on about half the acreage (thus 4.1 oz per acre is budgeted)."]

{"sheet":"HRSW Budget","index":11,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":false,"merged":[[7,1,7,9],[86,1,86,9],[87,1,87,9]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Hard Red Spring Wheat, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Hard Red Spring Wheat",null,{"$f":"yhrsw","v":58},null,"bu",null,{"$f":"phrsw","v":6.79},null,{"$f":"D13*H13","v":393.82}]
[null,"Variable Costs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J17:J17)","v":22}]
[null,"Hard Red Spring Wheat Seed",null,100,null,"lb",null,{"$f":"HRSWSd","v":0.22},null,{"$f":"D17*H17","v":22}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J20:J24)","v":88.5}]
[null,"Nitrogen (dry)",null,110,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D20*H20","v":60.500000000000007}]
[null,"Phosphorous (dry)",null,20,null,"lb",null,{"$f":"P","v":1.17},null,{"$f":"D21*H21","v":23.4}]
[null,"Potassium (dry)",null,0,null,"lb",null,{"$f":"K","v":0.46},null,{"$f":"D22*H22","v":0}]
[null,"Sulfur (dry)",null,20,null,"lb",null,{"$f":"S","v":0.23},null,{"$f":"D23*H23","v":4.6000000000000005}]
[null,null,null,null,null,null,null,null,null,{"$f":"D24*H24","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J27:J34)","v":31.795000000000002}]
[null,"Roundup",null,36,null,"oz",null,{"$f":"Glyphosphate","v":0.39},null,{"$f":"D27*H27","v":14.040000000000001}]
[null,"M90",null,3,null,"oz",null,{"$f":"M","v":0.01},null,0.03]
[null,"Ammonium Sulfate",null,103.2,null,"oz",null,{"$f":"AmmSulfLiq","v":0.02},null,2.0640000000000001]
[null,"Axial",null,4.0999999999999996,null,"oz",null,{"$f":"Axial","v":1.81},null,7.4209999999999994]
[null,"Brox M",null,12,null,"oz",null,{"$f":"BroxM","v":0.3},null,3.5999999999999996]
[null,"Starane",null,8,null,"oz",null,{"$f":"StaraneSalvo","v":0.43},null,3.44]
[null,"InPlace",null,5,null,"oz",null,{"$f":"InPlace","v":0.24},null,1.2]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Fungicides:",null,null,null,null,null,null,null,{"$f":"SUM(J37:J39)","v":0}]
[null,"Quilt",null,null,null,"oz",null,{"$f":"Quilt","v":1.22},null,{"$f":"D37*H37","v":0}]
[null,"Syltac Sticker",null,null,null,"pt",null,{"$f":"Syltac","v":6.25},null,{"$f":"D38*H38","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D39*H39","v":0}]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J42:J46)","v":46.521999999999998}]
[null,"Fuel",null,{"$f":"'HRSW Mach Costs'!M18","v":6.0162499999999994},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D42*H42","v":12.032499999999999}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'HRSW Mach Costs'!I18","v":2.2894999999999994},null,{"$f":"D43*H43","v":2.2894999999999994}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'HRSW Mach Costs'!G18","v":11.51},null,{"$f":"D44*H44","v":11.51}]
[null,"Machinery Labor",null,{"$f":"'HRSW Mach Costs'!L18","v":1.0345},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D45*H45","v":20.689999999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"D46*H46","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J49:J51)","v":0}]
[null,"Rental Sprayer Applicator",null,0,null,"acre",null,{"$f":"Sprayer","v":1.75},null,{"$f":"D49*H49","v":0}]
[null,"Custom Aerial",null,0,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D50*H50","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D51*H51","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J54:J56)","v":20}]
[null,"Crop insurance",null,1,null,"acre",null,20,null,{"$f":"D54*H54","v":20}]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,{"$f":"D55*H55","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D56*H56","v":0}]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(J16+J19+J26+J36+J48+J53)*0.05","v":8.1147500000000008}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+(J16+J19+J26+J36+J48+J53)*operloan*0.5","v":6.0860625000000006}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J16:J59)-(J16+J19+J26+J36+J41+J48+J53)","v":223.01781249999999}]
[null,"Variable Costs per Unit",null,null,null,null,null,null,null,{"$f":"J61/D13","v":3.8451346982758619}]
[]
[null,"Net Returns Above Variable Costs",null,null,null,null,null,null,null,{"$f":"J13-J61","v":170.8021875}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'HRSW Mach Costs'!D18","v":32.249999999999993}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'HRSW Mach Costs'!E18","v":5.4390000000000009}]
[null,"Land Cost*",null,1,null,"acre",null,{"$f":"+(D13*H13)*D70-(J19+J26+J36+H54)*D70-J74","v":79.763249999999985},null,{"$f":"H68","v":79.763249999999985}]
[null,"*Based on Share Rent Percentage:"]
[null,"  Landlord",null,{"$f":"+ownershare","v":0.33}]
[null,"  Tenant",null,{"$f":"opershare","v":0.67}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J65:J74)","v":121.35224999999998}]
[null,"Fixed Costs per Unit",null,null,null,null,null,null,null,{"$f":"J76/D13","v":2.0922801724137927}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J61+J76","v":344.37006249999996}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J79/D13","v":5.9374148706896541}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J79","v":49.449937500000033}]
[]
[null,"Notes:"]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[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":"F93*(1-D91)","v":52.2},null,{"$f":"D13","v":58},null,{"$f":"F93*(1+H91)","v":63.800000000000004}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$61/D93","v":4.2723718869731799},null,{"$f":"$J$61/F93","v":3.8451346982758619},null,{"$f":"$J$61/H93","v":3.4955769984326017}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$76/D93","v":2.3247557471264364},null,{"$f":"$J$76/F93","v":2.0922801724137927},null,{"$f":"$J$76/H93","v":1.9020728840125387}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$79/D93","v":6.5971276340996159},null,{"$f":"$J$79/F93","v":5.9374148706896541},null,{"$f":"$J$79/H93","v":5.3976498824451404}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F103*(1-D91)","v":6.1109999999999998},null,{"$f":"H13","v":6.79},null,{"$f":"F103*(1+H91)","v":7.4690000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$61/D103","v":36.494487399770904},null,{"$f":"$J$61/F103","v":32.845038659793815},null,{"$f":"$J$61/H103","v":29.859126054358011}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$76/D103","v":19.858001963672066},null,{"$f":"$J$76/F103","v":17.872201767304858},null,{"$f":"$J$76/H103","v":16.247456152095324}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$79/D103","v":56.35248936344297},null,{"$f":"$J$79/F103","v":50.717240427098666},null,{"$f":"$J$79/H103","v":46.106582206453332}]

{"sheet":"HRSW Mach Costs","index":12,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,24,13],[3,8,4,8],[3,9,4,9],[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[]
[null,"Hard Red Spring Wheat  Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"425HP-WT + 60' Heavy Harrow","Sept",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"200HP-WT + 100' Pull Sprayer1","October",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"200HP-WT + 100' Pull Sprayer2","April",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' NT Drill3","April",{"$f":"'Machinery Costs'!C19","v":5.45},{"$f":"'Machinery Costs'!D19","v":0.57999999999999996},{"$f":"'Machinery Costs'!E19","v":6.03},{"$f":"'Machinery Costs'!F19","v":3.12},{"$f":"'Machinery Costs'!G19","v":2.8134999999999999},{"$f":"'Machinery Costs'!H19","v":0.4965},{"$f":"'Machinery Costs'!I19","v":6.43},{"$f":"'Machinery Costs'!J19","v":1.69},{"$f":"'Machinery Costs'!K19","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L19","v":1.4067499999999999},{"$f":"'Machinery Costs'!M19","v":14.149999999999999}]
[null,"200HP-WT + 100' Pull Sprayer4","May",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' Combine","August",{"$f":"'Machinery Costs'!C20","v":10.16},{"$f":"'Machinery Costs'!D20","v":0.87},{"$f":"'Machinery Costs'!E20","v":11.03},{"$f":"'Machinery Costs'!F20","v":1.43},{"$f":"'Machinery Costs'!G20","v":2.81},{"$f":"'Machinery Costs'!H20","v":0.5},{"$f":"'Machinery Costs'!I20","v":4.74},{"$f":"'Machinery Costs'!J20","v":1.69},{"$f":"'Machinery Costs'!K20","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L20","v":1.405},{"$f":"'Machinery Costs'!M20","v":17.46}]
[null,"200HP-WT + Bankout Wagon","August",{"$f":"'Machinery Costs'!C21","v":1.91},{"$f":"'Machinery Costs'!D21","v":0.2},{"$f":"'Machinery Costs'!E21","v":2.11},{"$f":"'Machinery Costs'!F21","v":0.82},{"$f":"'Machinery Costs'!G21","v":1.3260000000000001},{"$f":"'Machinery Costs'!H21","v":0.23399999999999999},{"$f":"'Machinery Costs'!I21","v":2.38},{"$f":"'Machinery Costs'!J21","v":1.69},{"$f":"'Machinery Costs'!K21","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L21","v":0.66300000000000003},{"$f":"'Machinery Costs'!M21","v":6.18}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D17)","v":32.249999999999993},{"$f":"SUM(E6:E17)","v":5.4390000000000009},37.689,11.51,12.032499999999999,2.2894999999999994,25.831999999999997,20.69,1.0345,6.0162499999999994,84.210999999999999]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"1Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"2Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"3Typically 100 lb seed, 110 lb N, 20 lb P, 20 lb S."]
[null,"4Typically a tankmix with broadleaf sprays such as Starane+Salvo (22 oz) and Brox M (1.6 oz) plus a surfactant such as R-11 (3.2 oz). In addition, a wildoat spray such as Axial (8.2 oz/ac) is used on about half the acreage (thus 4.1 oz per acre is budgeted)."]

{"sheet":"BGE Budget","index":13,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,1,7,9]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Bluegrass Establishment, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[]
[null,"Variable Costs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J16:J16)","v":16.987500000000001}]
[null,"Bluegrass Seed",null,45,null,"lb",null,{"$f":"BGSd","v":0.3775},null,{"$f":"D16*H16","v":16.987500000000001}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J19:J20)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D19*H19","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D20*H20","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J23:J25)","v":0}]
[null,null,null,null,null,"oz",null,null,null,{"$f":"D23*H23","v":0}]
[null,null,null,null,null,"oz",null,null,null,0]
[null,null,null,null,null,"oz",null,null,null,0]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J28:J32)","v":38.584000000000003}]
[null,"Fuel",null,{"$f":"'BGE Mach Costs'!M15","v":4.58575},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D28*H28","v":9.1715}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'BGE Mach Costs'!I15","v":1.7804999999999997},null,{"$f":"D29*H29","v":1.7804999999999997}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'BGE Mach Costs'!G15","v":8.6720000000000006},null,{"$f":"D30*H30","v":8.6720000000000006}]
[null,"Machinery Labor",null,{"$f":"'BGE Mach Costs'!L15","v":0.94799999999999995},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D31*H31","v":18.96}]
[null,null,null,null,null,null,null,null,null,{"$f":"D32*H32","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J35:J37)","v":0}]
[null,"Rental Sprayer",null,null,null,"acre",null,{"$f":"Sprayer","v":1.75},null,{"$f":"D35*H35","v":0}]
[null,"Custom Aerial Spray",null,null,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D36*H36","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D37*H37","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J40:J40)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D40*H40","v":0}]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(J15+J18+J22+J34+J39)*0.05","v":0.8493750000000001}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+(J15+J18+J22+J34+J39)*operloan*0.5","v":0.63703125000000005}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J15:J43)-(J15+J18+J22+J27+J34+J39)","v":57.057906250000002}]
[]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'BGE Mach Costs'!D15","v":18.64}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'BGE Mach Costs'!E15","v":4.1790000000000003}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J47:J52)","v":26.719000000000001}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J45+J54","v":83.776906249999996}]
[]
[null,"Notes:"]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]

{"sheet":"BGE Mach Costs","index":14,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,9,4,9],[3,7,4,7],[3,8,4,8]]}
[]
[null,"Bluegrass Seed Establishment Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"425HP-WT + 60' Heavy Harrow","Sept",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"36' NT Drill1","Sept",{"$f":"'Machinery Costs'!C19","v":5.45},{"$f":"'Machinery Costs'!D19","v":0.57999999999999996},{"$f":"'Machinery Costs'!E19","v":6.03},{"$f":"'Machinery Costs'!F19","v":3.12},{"$f":"'Machinery Costs'!G19","v":2.8134999999999999},{"$f":"'Machinery Costs'!H19","v":0.4965},{"$f":"'Machinery Costs'!I19","v":6.43},{"$f":"'Machinery Costs'!J19","v":1.69},{"$f":"'Machinery Costs'!K19","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L19","v":1.4067499999999999},{"$f":"'Machinery Costs'!M19","v":14.149999999999999}]
[null,"200HP-WT + 20' Rotary Mower","June",{"$f":"'Machinery Costs'!C16","v":2.02},{"$f":"'Machinery Costs'!D16","v":0.22},{"$f":"'Machinery Costs'!E16","v":2.2400000000000002},{"$f":"'Machinery Costs'!F16","v":0.57599999999999996},{"$f":"'Machinery Costs'!G16","v":1.1475},{"$f":"'Machinery Costs'!H16","v":0.20250000000000001},{"$f":"'Machinery Costs'!I16","v":1.9260000000000002},{"$f":"'Machinery Costs'!J16","v":1.47},{"$f":"'Machinery Costs'!K16","v":7.3499999999999996E-2},{"$f":"'Machinery Costs'!L16","v":0.57374999999999998},{"$f":"'Machinery Costs'!M16","v":5.6360000000000001}]
[null,"200HP-WT + 20' Rotary Mower","July",{"$f":"'Machinery Costs'!C16","v":2.02},{"$f":"'Machinery Costs'!D16","v":0.22},{"$f":"'Machinery Costs'!E16","v":2.2400000000000002},{"$f":"'Machinery Costs'!F16","v":0.57599999999999996},{"$f":"'Machinery Costs'!G16","v":1.1475},{"$f":"'Machinery Costs'!H16","v":0.20250000000000001},{"$f":"'Machinery Costs'!I16","v":1.9260000000000002},{"$f":"'Machinery Costs'!J16","v":1.47},{"$f":"'Machinery Costs'!K16","v":7.3499999999999996E-2},{"$f":"'Machinery Costs'!L16","v":0.57374999999999998},{"$f":"'Machinery Costs'!M16","v":5.6360000000000001}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D14)","v":18.64},{"$f":"SUM(E6:E14)","v":4.1790000000000003},22.818999999999999,8.6720000000000006,9.1715,1.7804999999999997,19.623999999999999,18.96,0.94799999999999995,4.58575,{"$f":"SUM(N6:N14)","v":61.402999999999999}]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"15.5 lb bluegrass seed."]

{"sheet":"BG Budget","index":15,"n_rows":103,"n_cols":10,"rows_kept":103,"cut":false,"hidden":false,"merged":[[7,1,7,9],[80,1,80,9],[81,1,81,9]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Bluegrass Production, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Bluegrass seed",null,{"$f":"Summary!D20","v":675},null,"lb",null,1.5,null,{"$f":"D13*H13","v":1012.5}]
[]
[null,"Variable Costs"]
[]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J19:J22)","v":104.55000000000001}]
[null,"Nitrogen",null,135,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D19*H19","v":74.25}]
[null,"Phosphorus",null,20,null,"lb",null,{"$f":"P","v":1.17},null,{"$f":"D20*H20","v":23.4}]
[null,"Sulfur",null,30,null,"lb",null,{"$f":"S","v":0.23},null,{"$f":"D21*H21","v":6.9}]
[null,null,null,null,null,null,null,null,null,{"$f":"D22*H22","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J25:J31)","v":25.16}]
[null,"Banvel 4E",null,8,null,"oz",null,{"$f":"banvel","v":0.77},null,{"$f":"D25*H25","v":6.16}]
[null,"Beacon",null,0.5,null,"oz",null,{"$f":"beacon","v":32},null,16]
[null,"Crop oil concentrate",null,3,null,"pt",null,{"$f":"COC","v":1},null,3]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J34:J38)","v":35.24}]
[null,"Fuel",null,{"$f":"'BG Mach Costs'!M16","v":4.1659999999999995},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D34*H34","v":8.331999999999999}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'BG Mach Costs'!I16","v":1.6329999999999998},null,{"$f":"D35*H35","v":1.6329999999999998}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'BG Mach Costs'!G16","v":6.8250000000000002},null,{"$f":"D36*H36","v":6.8250000000000002}]
[null,"Machinery Labor",null,{"$f":"'BG Mach Costs'!L16","v":0.9225000000000001},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D37*H37","v":18.450000000000003}]
[null,null,null,null,null,null,null,null,null,{"$f":"D38*H38","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J41:J43)","v":18}]
[null,"Rental Fertilizer Spreader",null,1,null,"acre",null,{"$f":"FertApplicator","v":1},null,{"$f":"D41*H41","v":1}]
[null,"Custom Swathing",null,1,null,"acre",null,{"$f":"swathing","v":15},null,{"$f":"D42*H42","v":15}]
[null,"Hauling ($75 per 25,000 lb load)",null,1,null,"acre",null,2,null,{"$f":"D43*H43","v":2}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J46:J48)","v":89.75}]
[null,"Crop insurance",null,1,null,"acre",null,null,null,{"$f":"D46*H46","v":0}]
[null,"Burning permit",null,1,null,"acre",null,{"$f":"burn","v":2},null,{"$f":"D47*H47","v":2}]
[null,"Bags, tags, etc.",null,{"$f":"D13/100","v":6.75},null,"cwt",null,{"$f":"BGmisc","v":13},null,{"$f":"D48*H48","v":87.75}]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(J18+J24+J33+J40+J45)*0.05","v":13.635000000000003}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+(J18+J24+J33+J40+J45)*operloan*0.5","v":10.226250000000002}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J51)-(J18+J24+J33+J40+J45)","v":296.56124999999997}]
[null,"Variable Costs per Unit",null,null,null,null,null,null,null,{"$f":"J53/D13","v":0.43934999999999996}]
[]
[null,"Net Returns Above Variable Costs",null,null,null,null,null,null,null,{"$f":"J13-J53","v":715.93875000000003}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'BG Mach Costs'!D16","v":22.459999999999997}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'BG Mach Costs'!E16","v":4.370000000000001}]
[null,"Land Cost*",null,1,null,"acre",null,{"$f":"+(D13*H13)*D62-(J18+J24+H46)*D62-J68","v":287.42070000000001},null,{"$f":"H60","v":287.42070000000001}]
[null,"*Based on Share Rent Percentage:"]
[null,"  Landlord",null,{"$f":"+ownershare","v":0.33}]
[null,"  Tenant",null,{"$f":"opershare","v":0.67}]
[]
[null,"Bluegrass establishment cost*",null,null,null,null,null,null,null,{"$f":"-PMT(0.08,D66,'BGE Budget'!J56)","v":18.122233832540285}]
[null,"*Based on years of production:",null,6]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J57:J68)","v":336.27293383254028}]
[null,"Fixed Costs per Unit",null,null,null,null,null,null,null,{"$f":"J70/D13","v":0.49818212419635594}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J53+J70","v":632.83418383254025}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J73/D13","v":0.9375321241963559}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J73","v":379.66581616745975}]
[]
[null,"Notes:"]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[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":"F87*(1-D85)","v":607.5},null,{"$f":"D13","v":675},null,{"$f":"F87*(1+H85)","v":742.50000000000011}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$53/D87","v":0.48816666666666664},null,{"$f":"$J$53/F87","v":0.43934999999999996},null,{"$f":"$J$53/H87","v":0.39940909090909082}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$70/D87","v":0.55353569355150667},null,{"$f":"$J$70/F87","v":0.49818212419635594},null,{"$f":"$J$70/H87","v":0.45289284017850534}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$73/D87","v":1.0417023602181732},null,{"$f":"$J$73/F87","v":0.9375321241963559},null,{"$f":"$J$73/H87","v":0.85230193108759611}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F97*(1-D85)","v":1.35},null,{"$f":"H13","v":1.5},null,{"$f":"F97*(1+H85)","v":1.6500000000000001}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$53/D97","v":219.67499999999995},null,{"$f":"$J$53/F97","v":197.70749999999998},null,{"$f":"$J$53/H97","v":179.73409090909087}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$70/D97","v":249.09106209817796},null,{"$f":"$J$70/F97","v":224.18195588836019},null,{"$f":"$J$70/H97","v":203.80177808032741}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$73/D97","v":468.76606209817794},null,{"$f":"$J$73/F97","v":421.88945588836015},null,{"$f":"$J$73/H97","v":383.5358689894183}]

{"sheet":"BG Mach Costs","index":16,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,9,4,9],[21,1,22,13],[3,7,4,7],[3,8,4,8],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
[]
[null,"Bluegrass Production  Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"200HP-WT + Fert. Spreader1","October",{"$f":"'Machinery Costs'!C17","v":0.59},{"$f":"'Machinery Costs'!D17","v":0.06},{"$f":"'Machinery Costs'!E17","v":0.64999999999999991},{"$f":"'Machinery Costs'!F17","v":0.155},{"$f":"'Machinery Costs'!G17","v":0.64300000000000002},{"$f":"'Machinery Costs'!H17","v":0.11},{"$f":"'Machinery Costs'!I17","v":0.90800000000000003},{"$f":"'Machinery Costs'!J17","v":0.82},{"$f":"'Machinery Costs'!K17","v":4.0999999999999995E-2},{"$f":"'Machinery Costs'!L17","v":0.32150000000000001},{"$f":"'Machinery Costs'!M17","v":2.3780000000000001}]
[null,"200HP-WT + 100' Pull Sprayer2","April",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"Custom Swathing","July"]
[null,"36' Combine","August",{"$f":"'Machinery Costs'!C20","v":10.16},{"$f":"'Machinery Costs'!D20","v":0.87},{"$f":"'Machinery Costs'!E20","v":11.03},{"$f":"'Machinery Costs'!F20","v":1.43},{"$f":"'Machinery Costs'!G20","v":2.81},{"$f":"'Machinery Costs'!H20","v":0.5},{"$f":"'Machinery Costs'!I20","v":4.74},{"$f":"'Machinery Costs'!J20","v":1.69},{"$f":"'Machinery Costs'!K20","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L20","v":1.405},{"$f":"'Machinery Costs'!M20","v":17.46}]
[null,"200HP-WT + Bankout Wagon","August",{"$f":"'Machinery Costs'!C21","v":1.91},{"$f":"'Machinery Costs'!D21","v":0.2},{"$f":"'Machinery Costs'!E21","v":2.11},{"$f":"'Machinery Costs'!F21","v":0.82},{"$f":"'Machinery Costs'!G21","v":1.3260000000000001},{"$f":"'Machinery Costs'!H21","v":0.23399999999999999},{"$f":"'Machinery Costs'!I21","v":2.38},{"$f":"'Machinery Costs'!J21","v":1.69},{"$f":"'Machinery Costs'!K21","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L21","v":0.66300000000000003},{"$f":"'Machinery Costs'!M21","v":6.18}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D15)","v":22.459999999999997},4.370000000000001,26.83,6.8250000000000002,8.331999999999999,1.6329999999999998,16.789999999999996,18.45,0.9225000000000001,4.1659999999999995,62.070000000000007]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"1Typically 135 lb N, 20 lb K, and 30 lb S, plus a rented fertilizer spreader ($1/acre)."]
[null,"2Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"3Typically 100 lb seed, 110 lb N, 20 lb P, 20 lb S."]
[null,"4Typically a tankmix with broadleaf sprays such as Starane+Salvo (22 oz) and Brox M (1.6 oz) plus a surfactant such as R-11 (3.2 oz). In addition, a wildoat spray such as Axial (8.2 oz/ac) is used on about half the acreage (thus 4.1 oz per acre is budgeted)."]

{"sheet":"Spring Canola Budget","index":17,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[7,1,7,9],[77,1,77,9],[78,1,78,9]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Direct Seeded Spring Canola, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Canola",null,{"$f":"ysc","v":1300},null,"lb",null,{"$f":"psc","v":0.16500000000000001},null,{"$f":"D13*H13","v":214.5}]
[]
[null,"Variable Costs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J18)","v":30}]
[null,"Canola Seed",null,5,null,"lb",null,{"$f":"SCSd","v":6},null,{"$f":"D18*H18","v":30}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J21:J24)","v":55.632000000000005}]
[null,"Nitrogen (dry)",null,80,null,"lb",null,{"$f":"N","v":0.55000000000000004},null,{"$f":"D21*H21","v":44}]
[null,"Phosphorous (dry)",null,6.6,null,"lb",null,{"$f":"P","v":1.17},null,{"$f":"D22*H22","v":7.7219999999999995}]
[null,"Sulfur (dry)",null,17,null,"lb",null,{"$f":"S","v":0.23},null,{"$f":"D23*H23","v":3.91}]
[null,null,null,null,null,null,null,null,null,{"$f":"D24*H24","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J27:J31)","v":35.055}]
[null,"Roundup",null,56,null,"oz",null,{"$f":"Glyphosphate","v":0.39},null,{"$f":"D27*H27","v":21.84}]
[null,"Ammonium Sulfate",null,150,null,"oz",null,{"$f":"AmmSulfLiq","v":0.02},null,3]
[null,"M90",null,4.5,null,"oz",null,{"$f":"M","v":0.01},null,4.4999999999999998E-2]
[null,"Capture",null,1,null,"acre",null,{"$f":"Capture","v":10.17},null,10.17]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J34:J38)","v":46.521999999999998}]
[null,"Fuel",null,{"$f":"'SC Mach Costs'!M18","v":6.0162499999999994},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D34*H34","v":12.032499999999999}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'SC Mach Costs'!I18","v":2.2894999999999994},null,{"$f":"D35*H35","v":2.2894999999999994}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'SC Mach Costs'!G18","v":11.51},null,{"$f":"D36*H36","v":11.51}]
[null,"Machinery Labor",null,{"$f":"'SC Mach Costs'!L18","v":1.0345},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D37*H37","v":20.689999999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"D38*H38","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J41:J42)","v":6.5}]
[null,"Custom Aerial Spray",null,1,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D41*H41","v":6.5}]
[null,null,null,null,null,null,null,null,null,{"$f":"D42*H42","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":15}]
[null,"Crop insurance",null,1,null,"acre",null,15,null,{"$f":"D45*H45","v":15}]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,{"$f":"D46*H46","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D47*H47","v":0}]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(J17+J20+J26+J33+J40+J44)*0.05","v":9.4354500000000012}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+(J17+J20+J26+J33+J40+J44)*operloan*0.5","v":7.0765874999999996}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J50)-(J17+J20+J26+J33+J40+J44)","v":205.22103749999997}]
[null,"Variable Costs per Unit",null,null,null,null,null,null,null,{"$f":"J52/D13","v":0.15786233653846152}]
[]
[null,"Net Returns Above Variable Costs",null,null,null,null,null,null,null,{"$f":"J13-J52","v":9.2789625000000342}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'SC Mach Costs'!D18","v":32.249999999999993}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'SC Mach Costs'!$E$18","v":5.4390000000000009}]
[null,"Land Cost*",null,1,null,"acre",null,{"$f":"+(D13*H13)*D61-(J20+J26+H45)*D61-J65","v":32.008289999999995},null,{"$f":"H59","v":32.008289999999995}]
[null,"*Based on Share Rent Percentage:"]
[null,"  Landlord",null,{"$f":"+ownershare","v":0.33}]
[null,"  Tenant",null,{"$f":"opershare","v":0.67}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J56:J65)","v":73.597289999999987}]
[null,"Fixed Costs per Unit",null,null,null,null,null,null,null,{"$f":"J67/D13","v":5.6613299999999991E-2}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J52+J67","v":278.81832749999995}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J70/D13","v":0.21447563653846149}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J70","v":-64.318327499999953}]
[]
[null,"Notes:"]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[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":"F84*(1-D82)","v":1170},null,{"$f":"D13","v":1300},null,{"$f":"F84*(1+H82)","v":1430.0000000000002}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$52/D84","v":0.17540259615384612},null,{"$f":"$J$52/F84","v":0.15786233653846152},null,{"$f":"$J$52/H84","v":0.143511215034965}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$67/D84","v":6.2903666666666649E-2},null,{"$f":"$J$67/F84","v":5.6613299999999991E-2},null,{"$f":"$J$67/H84","v":5.1466636363636346E-2}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$70/D84","v":0.23830626282051279},null,{"$f":"$J$70/F84","v":0.21447563653846149},null,{"$f":"$J$70/H84","v":0.19497785139860133}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F94*(1-D82)","v":0.14850000000000002},null,{"$f":"H13","v":0.16500000000000001},null,{"$f":"F94*(1+H82)","v":0.18150000000000002}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$52/D94","v":1381.959848484848},null,{"$f":"$J$52/F94","v":1243.7638636363633},null,{"$f":"$J$52/H94","v":1130.694421487603}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$67/D94","v":495.60464646464629},null,{"$f":"$J$67/F94","v":446.0441818181817},null,{"$f":"$J$67/H94","v":405.49471074380153}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$70/D94","v":1877.5644949494945},null,{"$f":"$J$70/F94","v":1689.808045454545},null,{"$f":"$J$70/H94","v":1536.1891322314045}]

{"sheet":"SC Mach Costs","index":18,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,9,4,9],[23,1,24,13],[3,7,4,7],[3,8,4,8],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
[]
[null,"Spring Canola  Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"425HP-WT + 60' Heavy Harrow","Sept",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"200HP-WT + 100' Pull Sprayer1","October",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"200HP-WT + 100' Pull Sprayer2","April",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' NT Drill3","April",{"$f":"'Machinery Costs'!C19","v":5.45},{"$f":"'Machinery Costs'!D19","v":0.57999999999999996},{"$f":"'Machinery Costs'!E19","v":6.03},{"$f":"'Machinery Costs'!F19","v":3.12},{"$f":"'Machinery Costs'!G19","v":2.8134999999999999},{"$f":"'Machinery Costs'!H19","v":0.4965},{"$f":"'Machinery Costs'!I19","v":6.43},{"$f":"'Machinery Costs'!J19","v":1.69},{"$f":"'Machinery Costs'!K19","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L19","v":1.4067499999999999},{"$f":"'Machinery Costs'!M19","v":14.149999999999999}]
[null,"200HP-WT + 100' Pull Sprayer4","May",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"36' Combine","August",{"$f":"'Machinery Costs'!C20","v":10.16},{"$f":"'Machinery Costs'!D20","v":0.87},{"$f":"'Machinery Costs'!E20","v":11.03},{"$f":"'Machinery Costs'!F20","v":1.43},{"$f":"'Machinery Costs'!G20","v":2.81},{"$f":"'Machinery Costs'!H20","v":0.5},{"$f":"'Machinery Costs'!I20","v":4.74},{"$f":"'Machinery Costs'!J20","v":1.69},{"$f":"'Machinery Costs'!K20","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L20","v":1.405},{"$f":"'Machinery Costs'!M20","v":17.46}]
[null,"200HP-WT + Bankout Wagon","August",{"$f":"'Machinery Costs'!C21","v":1.91},{"$f":"'Machinery Costs'!D21","v":0.2},{"$f":"'Machinery Costs'!E21","v":2.11},{"$f":"'Machinery Costs'!F21","v":0.82},{"$f":"'Machinery Costs'!G21","v":1.3260000000000001},{"$f":"'Machinery Costs'!H21","v":0.23399999999999999},{"$f":"'Machinery Costs'!I21","v":2.38},{"$f":"'Machinery Costs'!J21","v":1.69},{"$f":"'Machinery Costs'!K21","v":8.4499999999999992E-2},{"$f":"'Machinery Costs'!L21","v":0.66300000000000003},{"$f":"'Machinery Costs'!M21","v":6.18}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D17)","v":32.249999999999993},{"$f":"SUM(E6:E17)","v":5.4390000000000009},37.689,11.51,12.032499999999999,2.2894999999999994,25.831999999999997,20.69,1.0345,6.0162499999999994,84.210999999999999]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"Comments:"]
[null,"1Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"2Typically 16-24 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]
[null,"3Typically 5 lb seed, 80 lb N, 6.6 lb P, 17 lb S."]
[null,"4Typically 16 oz Roundup, 1.5 oz M90, 50 oz ammonium sulfate."]

{"sheet":"CF Budget","index":19,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[7,1,7,9],[56,1,56,9],[57,1,57,9]]}
[]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow Cells: Data are from Summary page (yellow tab)."]
[null,"Orange Cells: Revise this data here to reflect your situation."]
[null,"Green Cells: Data are from Input Costs page (green tab)."]
[null,"Blue Cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Production Costs for Chem Fallow, Northern Idaho"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[]
[null,"Variable Costs"]
[]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J17:J20)","v":21.12}]
[null,"Roundup",null,54,null,"oz",null,{"$f":"Glyphosphate","v":0.39},null,{"$f":"D17*H17","v":21.060000000000002}]
[null,"Ammonium Sulfate",null,null,null,"oz",null,{"$f":"AmmSulfLiq","v":0.02},null,0]
[null,"M90",null,6,null,"oz",null,{"$f":"M","v":0.01},null,0.06]
[null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,"Machinery:",null,null,null,null,null,null,null,{"$f":"SUM(J24:J28)","v":29.312000000000001}]
[null,"Fuel",null,{"$f":"'CF Mach Costs'!M16","v":2.7115},null,"gal",null,{"$f":"Diesel","v":2},null,{"$f":"D24*H24","v":5.423}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"'CF Mach Costs'!I16","v":1.119},null,{"$f":"D25*H25","v":1.119}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"'CF Mach Costs'!G16","v":6.7200000000000006},null,{"$f":"D26*H26","v":6.7200000000000006}]
[null,"Machinery Labor",null,{"$f":"'CF Mach Costs'!L16","v":0.80249999999999999},null,"acre",null,{"$f":"Labor","v":20},null,{"$f":"D27*H27","v":16.05}]
[null,null,null,null,null,null,null,null,null,{"$f":"D28*H28","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J31:J33)","v":0}]
[null,"Rental Sprayer",null,0,null,"acre",null,{"$f":"Sprayer","v":1.75},null,{"$f":"D31*H31","v":0}]
[null,"Custom Aerial Spray",null,0,null,"acre",null,{"$f":"Aerial","v":6.5},null,{"$f":"D32*H32","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D33*H33","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J36:J36)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D36*H36","v":0}]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(J16+J23+J30+J35)*0.05","v":2.5216000000000003}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"(J16+J23+J30+J35)*operloan*0.5","v":1.8912}]
[]
[null,"Total Variable Costs",null,null,null,null,null,null,null,{"$f":"SUM(J15:J39)-(J16+J23+J30+J35)","v":54.844800000000006}]
[null,"Fixed Costs:"]
[null,"Capital recovery costs",null,null,null,null,null,null,null,{"$f":"'CF Mach Costs'!D16","v":16.590000000000003}]
[null,"Machinery insurance, taxes, housing, licenses",null,null,null,null,null,null,null,{"$f":"'CF Mach Costs'!E16","v":3.9990000000000001}]
[]
[null,"Cash rent",null,null,null,null,null,null,null,{"$f":"cashrent","v":0}]
[null,"Land taxes",null,null,null,null,null,null,null,{"$f":"landtax","v":3.9}]
[]
[]
[null,"Total Fixed Costs",null,null,null,null,null,null,null,{"$f":"SUM(J42:J47)","v":24.489000000000001}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J41+J50","v":79.333800000000011}]
[]
[null,"Notes:"]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]

{"sheet":"CF Mach Costs","index":20,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,8,4,8],[3,9,4,9],[1,1,1,13],[2,3,2,5],[2,6,2,9],[2,10,2,11],[2,13,3,13],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[]
[null,"Chem Fallow Machinery Costs ($/acre) "]
[null,null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Timing of Operation","Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"200HP-WT + 100' Pull Sprayer1","Fall",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"200HP-WT + 100' Pull Sprayer2","Spring",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"200HP-WT + 100' Pull Sprayer3","June",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"200HP-WT + 100' Pull Sprayer4","July",{"$f":"'Machinery Costs'!C15","v":1.86},{"$f":"'Machinery Costs'!D15","v":0.21},{"$f":"'Machinery Costs'!E15","v":2.0700000000000003},{"$f":"'Machinery Costs'!F15","v":0.57999999999999996},{"$f":"'Machinery Costs'!G15","v":0.34},{"$f":"'Machinery Costs'!H15","v":0.06},{"$f":"'Machinery Costs'!I15","v":0.98},{"$f":"'Machinery Costs'!J15","v":0.43},{"$f":"'Machinery Costs'!K15","v":2.1499999999999998E-2},{"$f":"'Machinery Costs'!L15","v":0.17},{"$f":"'Machinery Costs'!M15","v":3.4800000000000004}]
[null,"425HP-WT + 60' Heavy Harrow","September",{"$f":"'Machinery Costs'!C18","v":1.21},{"$f":"'Machinery Costs'!D18","v":0.129},{"$f":"'Machinery Costs'!E18","v":1.339},{"$f":"'Machinery Costs'!F18","v":0.56000000000000005},{"$f":"'Machinery Costs'!G18","v":0.85},{"$f":"'Machinery Costs'!H18","v":0.15},{"$f":"'Machinery Costs'!I18","v":1.56},{"$f":"'Machinery Costs'!J18","v":0.51},{"$f":"'Machinery Costs'!K18","v":2.5500000000000002E-2},{"$f":"'Machinery Costs'!L18","v":0.42499999999999999},{"$f":"'Machinery Costs'!M18","v":3.4090000000000003}]
[null,"Pickup 3/4 ton 4WD, new","Annual",{"$f":"'Machinery Costs'!C8","v":2.16},{"$f":"'Machinery Costs'!D8","v":0.38},{"$f":"'Machinery Costs'!E8","v":2.54},{"$f":"'Machinery Costs'!F8","v":0.78},{"$f":"'Machinery Costs'!G8","v":0},{"$f":"'Machinery Costs'!H8","v":0.16200000000000001},{"$f":"'Machinery Costs'!I8","v":0.94200000000000006},{"$f":"'Machinery Costs'!J8","v":2.64},{"$f":"'Machinery Costs'!K8","v":0.13200000000000001},{"$f":"'Machinery Costs'!L8","v":0},{"$f":"'Machinery Costs'!M8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used","Annual",{"$f":"'Machinery Costs'!C9","v":1.56},{"$f":"'Machinery Costs'!D9","v":0.44},{"$f":"'Machinery Costs'!E9","v":2},{"$f":"'Machinery Costs'!F9","v":0.78},{"$f":"'Machinery Costs'!G9","v":1.224},{"$f":"'Machinery Costs'!H9","v":0.216},{"$f":"'Machinery Costs'!I9","v":2.2199999999999998},{"$f":"'Machinery Costs'!J9","v":4.38},{"$f":"'Machinery Costs'!K9","v":0.219},{"$f":"'Machinery Costs'!L9","v":0.61199999999999999},{"$f":"'Machinery Costs'!M9","v":8.6}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C10","v":1.65},{"$f":"'Machinery Costs'!D10","v":0.99},{"$f":"'Machinery Costs'!E10","v":2.6399999999999997},{"$f":"'Machinery Costs'!F10","v":0.99},{"$f":"'Machinery Costs'!G10","v":0.96899999999999986},{"$f":"'Machinery Costs'!H10","v":0.17099999999999999},{"$f":"'Machinery Costs'!I10","v":2.13},{"$f":"'Machinery Costs'!J10","v":3.3},{"$f":"'Machinery Costs'!K10","v":0.16499999999999998},{"$f":"'Machinery Costs'!L10","v":0.48449999999999993},{"$f":"'Machinery Costs'!M10","v":8.07}]
[null,"Tandem Axle Truck","Annual",{"$f":"'Machinery Costs'!C11","v":1.65},{"$f":"'Machinery Costs'!D11","v":0.99},{"$f":"'Machinery Costs'!E11","v":2.6399999999999997},{"$f":"'Machinery Costs'!F11","v":0.99},{"$f":"'Machinery Costs'!G11","v":0.96899999999999986},{"$f":"'Machinery Costs'!H11","v":0.17099999999999999},{"$f":"'Machinery Costs'!I11","v":2.13},{"$f":"'Machinery Costs'!J11","v":3.3},{"$f":"'Machinery Costs'!K11","v":0.16499999999999998},{"$f":"'Machinery Costs'!L11","v":0.48449999999999993},{"$f":"'Machinery Costs'!M11","v":8.07}]
[null,"Trap Wagon","Annual",{"$f":"'Machinery Costs'!C12","v":0.92},{"$f":"'Machinery Costs'!D12","v":0.23},{"$f":"'Machinery Costs'!E12","v":1.1500000000000001},{"$f":"'Machinery Costs'!F12","v":0.3},{"$f":"'Machinery Costs'!G12","v":5.0999999999999997E-2},{"$f":"'Machinery Costs'!H12","v":8.9999999999999993E-3},{"$f":"'Machinery Costs'!I12","v":0.36},{"$f":"'Machinery Costs'!J12","v":0.2},{"$f":"'Machinery Costs'!K12","v":0.01},{"$f":"'Machinery Costs'!L12","v":2.5499999999999998E-2},{"$f":"'Machinery Costs'!M12","v":1.7100000000000002}]
[null,"Total:",null,{"$f":"SUM(D6:D15)","v":16.590000000000003},{"$f":"SUM(E6:E15)","v":3.9990000000000001},20.589000000000002,6.7200000000000006,5.423,1.119,13.261999999999997,16.05,0.80249999999999999,2.7115,49.901000000000003]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]
[null,"118 oz Roundup, 1.5 oz M90"]
[null,"218 oz Roundup, 1.5 oz M90"]
[null,"310 oz Roundup, 1.5 oz M90"]
[null,"48 oz Roundup, 1.5 oz M90"]

{"sheet":"Machinery Costs","index":21,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,1,6,12],[13,1,13,12],[3,2,3,4],[1,1,1,12],[3,9,3,10],[2,1,2,12],[3,12,4,12],[3,5,3,8],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,3,5,3],[4,2,5,2]]}
[]
[null,"Machinery Costs ($/acre)"]
[null,"Note: Per hour machinery costs can be changed in this master table and they will update throughout. Per acre costs are calculated in a separate machinery cost program using the values listed in the Machinery Complement tab."]
[null,null,"Fixed Costs ($/acre):",null,null,"Variable Costs ($/acre):",null,null,null,"Labor",null,"Fuel Use","Total Cost"]
[null,null,"Capital Recovery Costs","  Taxes, Housing, Insurance, License","  Total Fixed Costs","  Repairs ","  Fuel","  Lubricants","Total"]
[null,null,null,null,null,null,null,null,null,"($/acre)","(hr/acre) ","(gal/acre)","($/acre)"]
[null,"Machinery costs for these implements are spread across every acre of the farm, regardless of crops produced:"]
[null,"Pickup 3/4 ton 4WD, new",2.16,0.38,{"$f":"D8+C8","v":2.54},0.78,null,0.16200000000000001,{"$f":"+H8+G8+F8","v":0.94200000000000006},2.64,{"$f":"J8/20","v":0.13200000000000001},{"$f":"+G8/2","v":0},{"$f":"+J8+I8+E8","v":6.1219999999999999}]
[null,"Pickup 3/4 ton 4WD, used",1.56,0.44,{"$f":"D9+C9","v":2},0.78,1.224,0.216,2.2199999999999998,4.38,{"$f":"J9/20","v":0.219},{"$f":"+G9/2","v":0.61199999999999999},8.6]
[null,"Tandem Axle Truck",1.65,0.99,{"$f":"D10+C10","v":2.6399999999999997},0.99,0.96899999999999986,0.17099999999999999,2.13,3.3,0.16499999999999998,0.48449999999999993,8.07]
[null,"Tandem Axle Truck",1.65,0.99,{"$f":"D11+C11","v":2.6399999999999997},0.99,0.96899999999999986,0.17099999999999999,2.13,3.3,0.16499999999999998,0.48449999999999993,{"$f":"+J11+I11+E11","v":8.07}]
[null,"Trap Wagon",0.92,0.23,{"$f":"D12+C12","v":1.1500000000000001},0.3,5.0999999999999997E-2,8.9999999999999993E-3,0.36,0.2,0.01,2.5499999999999998E-2,1.7100000000000002]
[null,"Subtotal:",{"$f":"SUM(C8:C12)","v":7.9399999999999995},{"$f":"SUM(D8:D12)","v":3.03},10.97,3.84,3.2129999999999996,0.72899999999999998,7.782,13.82,0.69100000000000006,1.6064999999999998,32.572000000000003]
[null,"Machinery costs for these implements are specific to the operations for each crop:"]
[null,"200HP-WT + 100' Pull Sprayer",1.86,0.21,{"$f":"D15+C15","v":2.0700000000000003},0.57999999999999996,0.34,0.06,{"$f":"+H15+G15+F15","v":0.98},0.43,{"$f":"J15/20","v":2.1499999999999998E-2},{"$f":"+G15/2","v":0.17},3.4800000000000004]
[null,"200HP-WT + 20' Rotary Mower",2.02,0.22,2.2400000000000002,0.57599999999999996,{"$f":"1.35*0.85","v":1.1475},{"$f":"1.35*0.15","v":0.20250000000000001},{"$f":"+H16+G16+F16","v":1.9260000000000002},1.47,{"$f":"J16/20","v":7.3499999999999996E-2},{"$f":"+G16/2","v":0.57374999999999998},{"$f":"+J16+I16+E16","v":5.6360000000000001}]
[null,"200HP-WT + 45' Fert Spreader (rental)",0.59,0.06,0.64999999999999991,0.155,0.64300000000000002,0.11,{"$f":"+H17+G17+F17","v":0.90800000000000003},0.82,{"$f":"J17/20","v":4.0999999999999995E-2},{"$f":"+G17/2","v":0.32150000000000001},{"$f":"+J17+I17+E17","v":2.3780000000000001}]
[null,"425HP-WT + 60' Heavy Harrow",1.21,0.129,1.339,0.56000000000000005,0.85,0.15,1.56,0.51,2.5500000000000002E-2,0.42499999999999999,3.4090000000000003]
[null,"425HP-WT + 36' NT Drill",5.45,0.57999999999999996,6.03,3.12,2.8134999999999999,0.4965,6.43,1.69,{"$f":"J19/20","v":8.4499999999999992E-2},1.4067499999999999,14.149999999999999]
[null,"36' Combine",10.16,0.87,11.03,1.43,2.81,0.5,{"$f":"+H20+G20+F20","v":4.74},1.69,{"$f":"J20/20","v":8.4499999999999992E-2},{"$f":"+G20/2","v":1.405},{"$f":"+J20+I20+E20","v":17.46}]
[null,"200HP-WT + Bankout Wagon",1.91,0.2,2.11,0.82,1.3260000000000001,0.23399999999999999,{"$f":"+H21+G21+F21","v":2.38},1.69,{"$f":"J21/20","v":8.4499999999999992E-2},{"$f":"+G21/2","v":0.66300000000000003},{"$f":"+J21+I21+E21","v":6.18}]
[null,"Total:",{"$f":"SUM(C8:C20)-C13","v":29.230000000000004},5.0989999999999984,34.329000000000001,10.260999999999999,11.817,2.2479999999999998,24.325999999999997,20.43,1.0215000000000001,5.9085000000000001,79.085000000000008]
[null,"Note: Farm size is assumed to be 2000 acres for the purposes of machinery cost calculations."]

{"sheet":"Machinery Complement","index":22,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,1,8,11],[11,1,11,11],[2,1,2,11]]}
[null,"Summary"]
[]
[null,"Machinery Complement for Direct Seed/No Tillage, Northern Idaho"]
[null,null,null,null,null,null,null,"Annual",null,"Taxes,"]
[null,null,null,null,null,"Annual ",null,"Repairs","Gallons","Housing,"]
[null,"Type of","Current","Age When","Years of","Hours","Salvage","(Materials","of","Insur.,","Labor","Acres"]
[null,"Machine","Value","Purchased","Life","of Use","Value","& Labor)","Fuel/Hr.","Licenses","Multiplier","per Hour"]
[null,null,"$",null,null,null,"$","$",null,"%"]
[null,"Tractors:"]
[null,"200HP FWA Tractor",50000,10,15,300,19000,1242,9,1,1.1000000000000001]
[null,"425HP 4WD Tractor",80000,10,15,350,30000,2830,16,1,1.1000000000000001]
[null,"Equipment:"]
[null,"Bankout Wagon w/ 200HP-WT",15000,5,15,155,6186,1000,null,1,1.1000000000000001,13]
[null,"30' Rotary Mower  w/ 200HP-WT",22000,4,15,40,2500,600,null,1,1.1000000000000001,15]
[null,"100' Pull Sprayer w/ 200HP-WT",35000,2,15,100,18500,1000,null,1,1.2,51]
[null,"60' Heavy Harrow w/ 425HP-WT",15000,5,15,50,5800,750,null,1,1.1000000000000001,43]
[null,"36' NT Drill  w/ 425HP-WT",80000,4,10,175,53000,5000,17,1,1.2,12.8]
[null,"Fertilizer Tanks & Pump",25000,0,20,null,0,1000]
[null,"36' Combine",225000,5,10,200,77570.218855908708,3708,15,2.6,1.25,13]
[null,"Trucks:",null,null,null,"Miles/year:",null,null,"MPG:"]
[null,"Tandem Axle Truck",35000,15,15,6000,8000,2000,6,6.8,1.1000000000000001]
[null,"Tandem Axle Truck",35000,15,15,6000,8000,2000,6,6.8,1.1000000000000001]
[null,"Trap Wagon",15000,10,10,500,3000,600,12,3.8,1.2]
[null,"3/4T 4WD Pickup, new",34000,0,5,12000,22000,1500,16,6.8,1.1000000000000001]
[null,"3/4T 4WD Pickup, used",22000,5,7,12000,7500,1500,12,6.8,1.1000000000000001]