{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Summary"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Data","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,2,25,6],[1,1,2,7]]}
[]
[null,"Pickup and Trailer Cost Calculator\nOklahoma State University\n\nDeveloped by\nJames McGrann, Professor Emeritus, Texas A&M University and Christy Waggoner, Former Programmer, Texas A&M University\n2015 update by\nDamona Doye and Roger Sahs, Oklahoma State University\n"]
[]
[]
[null,null,"Ranch Name:",null,null,null,"Date:"]
[null,null,"OK Ranch",null,null,null,{"$f":"NOW()","v":"2021-10-19T14:51:27.460"}]
[null,null,""]
[null,null,null,null,null,"Pickup","Trailer"]
[null,null,"Input Data","Units",null,"Values","Values"]
[]
[null,null,"Current Value","$",null,42000,15000]
[null,null,"Total Miles Used (useful life)","Mile",null,150000,50000]
[null,null,"Current Mileage","Mile",null,40000,30000]
[null,null,"Salvage Value (trade or junk)","$",null,7000,1000]
[null,null,"Annual Miles of Use","Mile",null,25000,1000]
[null,null,"Fuel Use (miles per gallon)","Gal.",null,18,6]
[null,null,"Cost of Fuel","$/Gal.",null,3,{"$f":"F17","v":3}]
[null,null,"Interest Rate on Capital","%",null,5,{"$f":"F18","v":5}]
[null,null,"Monthly Loan Payments (if made)","$",null,0,0]
[null,null,"Annual License & Tax","$",null,120,20]
[null,null,"Annual Insurance","$",null,1500,50]
[null,null,"Tire Cost (per set)","$",null,1000,700]
[null,null,"Tire Life in Miles","Mile",null,25000,20000]
[null,null,"Annual Repair & Maintenance Cost","$",null,1500,300]
[]
[null,null,"Calculated Cost for a Trip"]
[]
[null,null,"Input Data","Units",null,"Value"]
[]
[null,null,"Total Miles Traveled for Trip","Miles",null,120]
[null,null,"Total Driver Labor Required","Hr.",null,2]
[null,null,"Driver Labor Cost per Hour","$/Hr.",null,15]
[null,null,"Total Additional Labor Required","Hr.",null,0]
[null,null,"Additional Labor Cost / Hour","$/Hr.",null,0]
[null,null,"Total Number Hauled per Trip","Head",null,10]

{"sheet":"Summary","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,6],[32,1,32,6]]}
[]
[null,"Per Mile and Annual Costs"]
[null," "," "," "," "," "]
[null,null,null,null,"Pickup","Trailer","Combined"]
[null,"Cost Components","Units",null,"Values","Values","Costs"]
[]
[null,"Variable Cost"]
[null,"    Fuel","$/Mi.",null,{"$f":"IF(Data!F16=0,0,Data!F17/Data!F16)*+IF(Data!F15=0,0,1)","v":0.16666666666666666},{"$f":"IF(Data!G16=0,0,Data!G17/Data!G16)*+IF(Data!F15=0,0,1)","v":0.5},{"$f":"(E8+F8)","v":0.66666666666666663}]
[null,"    Tires","$/Mi.",null,{"$f":"IF(Data!F23=0,0,Data!F22/Data!F23)*+IF(Data!F15=0,0,1)","v":0.04},{"$f":"IF(Data!G23=0,0,Data!G22/Data!G23)*+IF(Data!F15=0,0,1)","v":3.5000000000000003E-2},{"$f":"(E9+F9)","v":7.5000000000000011E-2}]
[null,"    Repair & Maintenance","$/Mi.",null,{"$f":"IF(Data!F15=0,0,Data!F24/Data!F15)","v":0.06},{"$f":"IF(Data!G15=0,0,Data!G24/Data!G15)","v":0.3},{"$f":"(E10+F10)","v":0.36}]
[null,null,null,null," -----------"," -----------"," -----------"]
[null,"Total Variable Cost","$/Mi.",null,{"$f":"SUM(E8:E10)","v":0.26666666666666666},{"$f":"SUM(F8:F10)","v":0.83499999999999996},{"$f":"SUM(G8:G10)","v":1.1016666666666666}]
[null,"Annual Variable Cost","$",null,{"$f":"(E12*Data!F15)","v":6666.666666666667},{"$f":"(F12*Data!G15)","v":835},{"$f":"(E13+F13)","v":7501.666666666667}]
[]
[null,"Fixed Costs"]
[null,"   License / Tax","$/Mi.",null,{"$f":"IF(Data!F15=0,0,Data!F20/Data!F15)","v":4.7999999999999996E-3},{"$f":"IF(Data!G15=0,0,Data!G20/Data!G15)","v":0.02},{"$f":"(E16+F16)","v":2.4799999999999999E-2}]
[null,"   Insurance","$/Mi.",null,{"$f":"IF(Data!F15=0,0,Data!F21/Data!F15)","v":0.06},{"$f":"IF(Data!G15=0,0,Data!G21/Data!G15)","v":0.05},{"$f":"(E17+F17)","v":0.11}]
[null,"   Interest (non-cash)","$/Mi.",null,{"$f":"IF(OR(Data!F15=0,(Data!F12=Data!F13)),0,(((Data!F11+Data!F14)/2))*Data!F18*0.01/Data!F15)","v":4.9000000000000002E-2},{"$f":"IF(OR(Data!G15=0,(Data!G12=Data!G13)),0,(((Data!G11+Data!G14)/2))*Data!G18*0.01/Data!G15)","v":0.4},{"$f":"(E18+F18)","v":0.44900000000000001}]
[null,"   Depreciation","$/Mi.",null,{"$f":"IF(OR(Data!F15=0,(Data!F12=Data!F13)),0,((Data!F11-Data!F14)*Data!F15/(Data!F12-Data!F13))/Data!F15)","v":0.31818181818181818},{"$f":"IF(OR(Data!G15=0,(Data!G12=Data!G13)),0,((Data!G11-Data!G14)*Data!G15/(Data!G12-Data!G13))/Data!G15)","v":0.7},{"$f":"(E19+F19)","v":1.0181818181818181}]
[null,null,null,null," -----------"," -----------"," -----------"]
[null,"Total Fixed Cost","$/Mi.",null,{"$f":"SUM(E16:E19)","v":0.43198181818181819},{"$f":"SUM(F16:F19)","v":1.17},{"$f":"SUM(G16:G19)","v":1.6019818181818182}]
[null,"Total Annual Fixed Cost","$",null,{"$f":"(E21*Data!F15)","v":10799.545454545454},{"$f":"(F21*Data!G15)","v":1170},{"$f":"(E22+F22)","v":11969.545454545454}]
[]
[null,"Total Cost per Mile","$/Mi.",null,{"$f":"IF(Data!F15=0,0,((E13+E22)/Data!F15))","v":0.69864848484848485},{"$f":"IF(Data!G15=0,0,((F13+F22)/Data!G15))","v":2.0049999999999999},{"$f":"(G12+G21)","v":2.7036484848484847}]
[null,"Total Annual Cost","$",null,{"$f":"(E13+E22)","v":17466.21212121212},{"$f":"(F13+F22)","v":2005},{"$f":"(E25+F25)","v":19471.21212121212}]
[null,"-","-","-","-","-","-"]
[null,"Total Cash Costs per Mile","$/Mi.",null,{"$f":"IF(Data!F15=0,0,E28/Data!F15)","v":0.33146666666666674},{"$f":"IF(Data!G15=0,0,F28/Data!G15)","v":0.90500000000000003},{"$f":"(E27+F27)","v":1.2364666666666668}]
[null,"Total Cash Costs","$",null,{"$f":"(E13+Data!F19*12+Data!F20+Data!F21)","v":8286.6666666666679},{"$f":"(F13+Data!G19*12+Data!G20+Data!G21)","v":905},{"$f":"(E28+F28)","v":9191.6666666666679}]
[]
[]
[]
[]
[null,"Calculated Cost for a Trip"]
[]
[null,null,null,null,"Per","Per"]
[null,"Cost Components","Units",null,"Trip",{"$f":"+Data!D35","v":"Head"}]
[]
[null,"Total Variable Cost","$",null,{"$f":"(G12*Data!F30+Data!F31*Data!F32+Data!F33*Data!F34)","v":162.19999999999999},{"$f":"IF(Data!F35=0,0,E38/Data!F35)","v":16.22}]
[null,"Total Fixed Cost","$",null,{"$f":"(G21*Data!F30)","v":192.23781818181817},{"$f":"IF(Data!F35=0,0,E39/Data!F35)","v":19.223781818181816}]
[null,"Total Cost","$",null,{"$f":"SUM(E38:E39)","v":354.43781818181816},{"$f":"SUM(F38:F39)","v":35.443781818181819}]
[null,"-","-","-","-","-"]
[null,"Total Cash Cost","$",null,{"$f":"(G27*Data!F30+Data!F31*Data!F32+Data!F33*Data!F34)","v":178.37600000000003},{"$f":"IF(Data!F35=0,0,E42/Data!F35)","v":17.837600000000002}]
[null,"Total Cash Cost","$/Mile",null,{"$f":"E42/Data!F30","v":1.486466666666667}]