{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Instructions","Grain Hauling Cost Calculator"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,3,2,9],[3,3,3,9],[30,1,30,11],[31,1,31,11],[32,1,32,11],[5,1,5,12],[6,1,6,12],[7,1,7,12],[27,1,27,12]]}
[]
[]
[null,null,null,"Grain Hauling Cost Calculator"]
[null,null,null,"Version 1.0"]
[]
[null,"Aaron Smith"]
[null,"Assistant Professor - Crop Marketing Specialist"]
[null,"Office: (865) 974-7476     Email: aaron.smith@utk.edu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For technical support, contact Aaron Smith at the contact information above."]
[]
[]
[null,"Programs in agriculture and natural resources, 4-H youth development, family and consumer sciences, and resource development."]
[null,"University of Tennessee Institute of Agriculture, U.S. Department of Agriculture and country governments cooperating."]
[null,"UT Extension provide equal opportunities in programs and employment."]

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Grain Hauling Cost Calculator","index":2,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[16,5,16,7],[17,5,17,7],[18,5,18,7],[11,5,11,8],[26,1,31,8],[34,1,35,8],[0,1,0,6],[36,1,37,8],[2,2,2,3],[23,7,23,8],[5,5,6,8],[7,5,7,8],[8,5,8,7],[9,5,9,7],[10,5,10,8],[12,5,12,7],[13,5,13,7],[14,5,14,7],[15,5,15,8]]}
[null,"Grain Hauling Cost Calculator"]
[]
[null,"Commodity","Corn"]
[]
[]
[null,"Haul Details","Unit","Value",null,"Estimated Costs"]
[null,"Distance (One Way)","miles ",50]
[null,"Total Number of Bushels","bu",4500,null,"Variable Cost ($/Load)"]
[null,"Bushels per Load","bu",900,null,"Labor Cost",null,null,{"$f":"((D7*2/D14)+D11+D12)*D17","v":40.111111111111114}]
[null,"Number of Loads","#",{"$f":"ROUNDUP(D8/D9,0)","v":5},null,"Fuel Cost",null,null,{"$f":"D7*2/D13*D16","v":76}]
[null,"Loading Time (per load)","hrs",0.5]
[null,"Unloading Time (per Load)","hrs",1.5,null,"Fixed Cost (Share of Total Annual Cost)"]
[null,"Average Fuel Use","miles/gal",5,null,"Repair and Maintenance",null,null,{"$f":"IF(D23=0,(F22*C22/(D22/E22)*D19),(F22*C22/(D22/E22)*D19+F23*C23/(D23/E23))*H58)","v":43.309542181069958}]
[null,"Average Speed","miles/hr",45,null,"Capital Recovery",null,null,{"$f":"IF(D23=0,(((C22-G22)*(D18/(1-(1+D18)^-(D22/E22)))+G22*D18)*D19),(((C22-G22)*(D18/(1-(1+D18)^-(D22/E22)))+G22*D18)*D19+(C23-G23)*(D18/(1-(1+D18)^-(D23/E23)))+G23*D18)*H58)","v":383.78211232337691}]
[null,"Inputs",null,null,null,"Taxes, Insurance, and Housing",null,null,{"$f":"(C22*D19+C23*H58)*0.02","v":146.01851851851853}]
[null,"Diesel Fuel","$/gal",3.8]
[null,"Wage Rate","$/hr",9.5,null,"Total Cost",null,null,{"$f":"SUM(I9:I10)*D10+SUM(I13:I15)","v":1153.6657285785209}]
[null,"Interest Rate","%",0.05,null,"Cost per Bushel",null,null,{"$f":"I17/D8","v":0.25637016190633799}]
[null,"Share of Annual Truck Use","%",{"$f":"((D7/D14*2+D11+D12)*D10)/E22","v":8.7962962962962965E-2},null,"Custom Rate Eq. ($/mile round trip)",null,null,{"$f":"I18*D9/(D7*2)","v":2.307331457157042}]
[null,"Truck/Trailer Information"]
[null,null,"Purchase Price ($)","Useful Life (hrs)","Annual Use (hrs)","Repair Factor","Salvage Value ($)","Number of Single Axles","Number of Tandem Axles"]
[null,"Truck (Tractor)",35000,2400,240,0.25,1000,1,1]
[null,"Trailer",40000,3600,200,0.15,5000,0,1]
[null,null,null,null,null,null,null,{"$f":"IF((IF(C3=F44,G44,G45)*D9)>H50,G56,G55)","v":" "}]
[]
[]
[null,"Disclaimer:  The information provided within represents estimates that are a result of a set of calculations that are described in more detail in the instructions.  Changes in parameter values and corresponding costs are estimates and the user should use their own reasonable judgment to reflect whether the estimates are appropriate before acting on the results. The user is advised to test the calculator thoroughly before relying on its results.  The University of Tennessee will not be liable for any claim or damage brought against the user by any third party, nor will the University of Tennessee be liable for any consequential, indirect or special damages suffered by the user as a result of using the calculator."]
[]
[]
[]
[]
[]
[]
[]
[null,"Questions and comments should be directed to Dr. Aaron Smith, Assistant Professor, University of Tennessee. Phone: (865) 974-7476  Email: aaron.smith@utk.edu"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1 bu ="]
[null,null,null,null,null,"Corn",56,"lbs"]
[null,null,null,null,null,"Soybeans",60,"lbs"]
[null,null,null,null,null,"Wheat",60,"lbs"]
[null,null,null,null,null,null,"1st Single","Single","Tandem"]
[null,null,null,null,null,"Max Weight ",12000,20000,34000,"lbs/axcel"]
[]
[null,null,null,null,null,"Maximum Load Weight","lbs",{"$f":"G48*1+H48*(H22+H23-1)+I48*(I22+I23)-20000","v":60000}]
[null,null,null,null,null,"Maximum Bushels/Load","Bu",{"$f":"(H50)/IF(C3=F45,G45,IF(C3=F44,G44,G46))","v":1071.4285714285713}]
[]
[]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Overloaded"]
[]
[null,null,null,null,null,null,"Trailer annual use",{"$f":"((D7/D14*2+D11+D12)*D10)/E23","v":0.10555555555555556}]