{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","Truck costs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":4,"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":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,11],[28,1,29,11],[30,1,31,11],[35,1,36,4],[35,6,36,10],[39,15,39,16],[40,1,40,3],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[27,1,27,4]]}
[]
[]
[null,"KSU-Truck Cost"]
[]
[null,"An Excel spreadsheet to estimate the cost of owning and operating a truck."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 6.30.16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly. This spreadsheet uses macros to print the three different pages, however printing can also be done manually by highlighting the desired range and using the menu print commands."]
[]
[null,"In the \"User input\" tab all blue numbers are inputs and all black numbers are calculated from these inputs.  Several input cells (i.e., blue number) have a red diamond in the upper right hand corner of the cell.  By moving your mouse cursor over this diamond, a brief description of the input will be displayed on the screen."]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"With Questions contact:",null,null,null,null,"Originally Developed by:"]
[]
[null,"Rich Llewelyn",null,null,null,null,"Kevin C. Dhuyvetter, Ph.D."]
[null,"Extension Assistant",null,null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,"Kansas State University"]
[null,"rvl@ksu.edu"]
[null,"785-532-1504"]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Truck costs","index":1,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ESTIMATED TRUCK COSTS (blue values are inputs and black values are calculated)",null,null,null,null,null,null,null,"Input comment"]
[]
[null,"Truck and trailer investment"]
[null,"Average value of truck, $",null,17500,null,null,null,null,null,"Average value of semi"]
[null,"annual depreciation, %",null,3.5000000000000003E-2,null,null,null,null,null,"____________________________________"]
[null,"Average value of trailer, $",null,15000,null,null,null,null,null,"Average value of semi grain trailer"]
[null,"annual depreciation, %",null,3.5000000000000003E-2,null,null,null,null,null,"____________________________________"]
[null,"Interest rate",null,0.05,null,null,null,null,null,"____________________________________"]
[]
[null,"Truck hauling information"]
[null,"Miles driven annually",null,12000,null,null,null,null,null,"____________________________________"]
[null,"Units (bushels, tons, etc) per load","bushel",950,null,null,null,null,null,"____________________________________"]
[null,"Percent of miles hauling (as opposed to empty)",null,0.5,null,null,null,null,null,"____________________________________"]
[null,"Loaded miles driven annually",null,{"$f":"D12*D14","v":6000},null,null,null,null,null,"calculated value"]
[null,"Length of average trip, one-way miles",null,20,null,null,null,null,null,"____________________________________"]
[null,"Number of trips/loads per year",null,{"$f":"D15/D16","v":300},null,null,null,null,null,"calculated value"]
[null,"Average driving speed, mph",null,40,null,null,null,null,null,"____________________________________"]
[null,"Diesel price, $/gallon",null,2.25,null,null,null,null,null,"____________________________________"]
[null,"Average miles per gallon",null,4,null,null,null,null,null,"____________________________________"]
[null,"Wage rate, $/hr",null,15,null,null,null,null,null,"____________________________________"]
[null,"Labor hrs/hr of driving time",null,2,null,null,null,null,null,"____________________________________"]
[]
[null,null,null,null,null,null,null,"Include in"]
[null,null,null,"Annual","Per load","Per mile",{"$f":"\"Per \"&C13","v":"Per bushel"},"total? (Y=1)",null,"Input comment"]
[null,"Annual fixed costs (ownership)"]
[null,"truck depreciation",null,{"$f":"D5*D6","v":612.50000000000011},{"$f":"D27/D$17","v":2.041666666666667},{"$f":"D27/D$12","v":5.1041666666666673E-2},{"$f":"D27/(D$13*D$17)","v":2.1491228070175442E-3},1,null,"calculated value"]
[null,"truck interest",null,{"$f":"D5*D9","v":875},2.9166666666666665,7.2916666666666671E-2,3.0701754385964912E-3,1,null,"calculated value"]
[null,"truck insurance",null,300,1,2.5000000000000001E-2,1.0526315789473684E-3,1,null,"____________________________________"]
[null,"truck tag",null,375,1.25,3.125E-2,1.3157894736842105E-3,1,null,"____________________________________"]
[null,"trailer depreciation",null,{"$f":"D7*D8","v":525},1.75,4.3749999999999997E-2,1.8421052631578947E-3,1,null,"calculated value"]
[null,"trailer interest",null,{"$f":"D7*D9","v":750},2.5,6.25E-2,2.631578947368421E-3,1,null,"calculated value"]
[null,"trailer insurance",null,100,0.33333333333333331,8.3333333333333332E-3,3.5087719298245611E-4,1,null,"____________________________________"]
[null,"trailer tag",null,50,0.16666666666666666,4.1666666666666666E-3,1.7543859649122806E-4,1,null,"____________________________________"]
[null,"property taxes",null,350,1.1666666666666667,2.9166666666666667E-2,1.2280701754385965E-3,1,null,"____________________________________"]
[null,null,null,{"$f":"SUM(D27:D35)","v":3937.5},{"$f":"SUM(E27:E35)","v":13.125},{"$f":"SUM(F27:F35)","v":0.328125},{"$f":"SUM(G27:G35)","v":1.381578947368421E-2},"xxx"]
[null,"Mileage costs (operating)"]
[null,"truck tires",null,{"$f":"F38*D$12","v":863.99999999999989},{"$f":"D38/D$17","v":2.8799999999999994},{"$f":"400*18/100000","v":7.1999999999999995E-2},{"$f":"D38/(D$13*D$17)","v":3.0315789473684207E-3},1,null,"$400/tire replace every 100,000 miles (18 tires)"]
[null,"service costs (lubrication, oil, etc.)",null,{"$f":"F39*D$12","v":420.00000000000006},{"$f":"D39/D$17","v":1.4000000000000001},{"$f":"350/10000","v":3.5000000000000003E-2},{"$f":"D39/(D$13*D$17)","v":1.4736842105263161E-3},1,null,"$350 every 10,000 miles"]
[null,"repairs and maintenance",null,{"$f":"F40*D$12","v":1200},{"$f":"D40/D$17","v":4},{"$f":"1000/10000","v":0.1},{"$f":"D40/(D$13*D$17)","v":4.2105263157894736E-3},1,null,"$1000 every 10,000 miles"]
[null,"fuel",null,{"$f":"D12/D20*D19","v":6750},{"$f":"D41/D$17","v":22.5},{"$f":"D41/D12","v":0.5625},{"$f":"D41/(D13*D17)","v":2.368421052631579E-2},1,null,"calculated value"]
[null,"labor",null,{"$f":"D12/D18*D22*D21","v":9000},{"$f":"D42/D17","v":30},{"$f":"D42/D12","v":0.75},{"$f":"D42/(D13*D17)","v":3.1578947368421054E-2},1,null,"calculated value"]
[null,null,null,{"$f":"SUM(D38:D42)","v":18234},{"$f":"SUM(E35:E42)","v":75.071666666666658},{"$f":"SUM(F38:F42)","v":1.5195000000000001},{"$f":"SUM(G38:G42)","v":6.3978947368421052E-2},"xxx",null,"calculated value"]
[]
[null,"Total cost",null,{"$f":"SUMPRODUCT(D27:D43,$H27:$H43)","v":22171.5},{"$f":"SUMPRODUCT(E27:E43,$H27:$H43)","v":73.905000000000001},{"$f":"SUMPRODUCT(F27:F43,$H27:$H43)","v":1.8476249999999999},{"$f":"SUMPRODUCT(G27:G43,$H27:$H43)","v":7.7794736842105264E-2},"xxx",null,"calculated value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year",null,null,null,2016]
[null,"Section 179 allowance",null,null,null,500000]
[null,"Bonus depreciation (cell L22 in User input)",null,null,null,0]
[]
[null,"Market ding when trade",null,null,null,0]
[null,"NEP adjustment to approximate list price",null,null,null,1]