{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","Bag","Bin","Size","10000 bu bin","20000 bu bin","40000 bu bin","60000 bu bin","80000 bu bin","Bin Costs","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,1,18,11],[19,1,19,11],[20,1,20,11],[5,1,5,12],[6,1,6,12],[8,1,8,12],[0,1,0,12],[1,1,1,12],[3,1,3,12],[4,1,4,12],[7,1,7,12]]}
[null,"Grain Bag and Bin Storage"]
[null,"Version 1.0 2021"]
[]
[null,"Aaron Smith, Associate Professor - Crop Marketing Specialist"]
[null,"Office: (865) 974-7476     Email: aaron.smith@utk.edu"]
[null,"Charles Martinez, Assistant Professor"]
[null,"Office: (865) 974-7476     Email: cmart113@utk.edu"]
[null,"Christopher R Narayanan, Extension Area Specialist III"]
[null,"Hence Duncan, UT Extension Intern 2021"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The University of Tennessee is an EEO/AA/Title VI/Title IX/Section 504/ADA/ADEA institution in the provision of its education and employment programs and services. All qualified applicants will receive equal consideration for employment and admission without regard to race, color, national origin, religion, sex, pregnancy, marital status, sexual orientation, gender identity, age, physical or mental disability, genetic information, veteran status, and parental status."]
[]
[null,"This project is supported by Tennessee Corn Promotion Board Grant, Award Number R124110176 and USDA/NIFA under Award Number 2018-70027-28585."]

{"sheet":"Bag","index":1,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,6],[35,0,35,1],[36,0,36,1],[48,1,48,7],[44,1,44,7],[45,1,45,7],[46,1,46,7],[47,1,47,7],[43,1,43,7],[8,4,8,5],[49,1,49,7],[50,1,50,7],[51,1,51,7],[52,1,52,7],[58,1,58,7],[59,1,59,7],[60,1,60,7],[53,1,53,7],[54,1,54,7],[55,1,55,7],[56,1,56,7],[57,1,57,7]]}
["Grain Bag Storage Estimate"]
["Table 1. Assumptions",null,null,null,"Table 2. Machinery Assumptions"]
[null,"Value","Unit",null,"Machinery ","Purchase Price ($)","Useful Life (years)","Salvage Value ($)",null,null,null,"Capital Recovery ($/Year)","Repairs and Maintanance ($/Year)","Taxes, Insurance, and Housing ($/Year)","Fuel & Lubrication"]
["Acres",400,"acres",null,"Loader",44801,10,5000,null,null,"Loader",{"$f":"(F4-H4)*($B$15/(1-(1+$B$15)^-G4))+(H4*$B$15)","v":5107.1028752837583},{"$f":"(F4+H4)/2*B17","v":996.02},{"$f":"(F4+H4)/2*$B$16","v":498.01},"-"]
["Estimated Yield",200,"bu/acre",null,"Unloader",50861,10,5000,null,null,"Unloader",{"$f":"(F5-H5)*($B$15/(1-(1+$B$15)^-G5))+(H5*$B$15)","v":5854.245997924384},{"$f":"(F5+H5)/2*B17","v":1117.22},{"$f":"(F5+H5)/2*$B$16","v":558.61},"-"]
["Estimated Production",{"$f":"B4*B5","v":80000},"bu",null,"Tractor",125000,15,10000,null,null,"Tractor",{"$f":"((F6-H6)*($B$15/(1-(1+$B$15)^-G6))+(H6*$B$15))*G9","v":537.16132713309548},{"$f":"((F6+H6)/2*B17)*G9","v":135},{"$f":"((F6+H6)/2*$B$16)*G9","v":67.5},{"$f":"(0.06*F8*0.73*((B24+B25)*B11)*B13)*1.15","v":180.60667199999997}]
["Estimated Price",5,"$/bu",null,null,null,null,null,null,null,"Total Machinery Costs",{"$f":"SUM(L4:L6)","v":11498.510200341238},{"$f":"SUM(M4:M6)","v":2248.2399999999998},{"$f":"SUM(N4:N6)","v":1124.1199999999999},{"$f":"SUM(O4:O6)","v":180.60667199999997}]
["Bag Size",16000,"bu ",null,"Tractor PTO HP",120]
["Bag Weight",450,"lbs",null,"Share of Tractor Annual Use",null,0.05,null,null,null,null,"ASABE Agricultural Machinery Management","Iowa State https://www.extension.iastate.edu/agdm/crops/html/a3-29.html","Iowa State https://www.extension.iastate.edu/agdm/crops/html/a3-29.html","ASABE Agricultural Machinery Management"]
["Bag Price",1100,"$/bag"]
["# of Bags",{"$f":"ROUNDUP(B6/B8,0)","v":5},"# (rounded up)"]
["Labor Rate",15.61,"$/hr"]
["Diesel Price",2.4900000000000002,"$/gallon"]
["Interest Rate (Operating)",0.05,"%"]
["Interest Rate (Fixed)",0.04,"%"]
["Taxes, Insurance, & Housing",0.02,"% of purchase price"]
["Repair and Maintenance",0.04,"% of purchase price"]
["Estimated Shrinkage/Storage Loss",0.02,"%"]
[]
["Table 3. Estimated Costs"]
["Operating Costs","Quantity","Unit","Number of people","Cost per unit","Unit","Total Cost","$/bu"]
["Site Preparation",{"$f":"B11","v":5},"bags","-",5,"$/bag",{"$f":"B22*E22","v":25}]
["Bag",{"$f":"B11","v":5},"bags","-",{"$f":"B10","v":1100},"$/bag",{"$f":"B23*E23","v":5500}]
["Labor Loading per Bag",1.2,"hrs/bag",2,{"$f":"B12","v":15.61},"$/hr",{"$f":"B24*D24*E24*B11","v":187.32}]
["Labor Unloading per Bag",1.2,"hrs/bag",2,{"$f":"B12","v":15.61},"$/hr",{"$f":"B25*D25*E25*B11","v":187.32}]
["Machinery Repair & Maintenance",{"$f":"M7","v":2248.2399999999998},"$","-","-","$",{"$f":"B26","v":2248.2399999999998}]
["Machinery Fuel & Lubrication",{"$f":"O7","v":180.60667199999997},"$","-","-","$",{"$f":"B27","v":180.60667199999997}]
["Bag Sealing",{"$f":"B11","v":5},"bags","-",15,"$/bag",{"$f":"E28*B28","v":75}]
["Insecticides",{"$f":"(B6/1000)*10","v":800},"lb","-",2,"$/lb",{"$f":"B29*E29","v":1600}]
["Sensors",2,"# per bag","-",15,"$/Sensor",{"$f":"+B30*B11*E30","v":150}]
["Labor - Bag Repair and Monitoring",2,"hrs/bag","-",{"$f":"B12","v":15.61},"$/hr",{"$f":"E31*B31*B11","v":156.1}]
["Bag Disposal/Ton",{"$f":"B11","v":5},"bags","-",25,"$/ton",{"$f":"B11*B9/2000*E32","v":28.125}]
["Operating Interest",null,null,null,null,null,{"$f":"SUM(G22:G32)*0.5*B14","v":258.44279180000001}]
["Total Operating Costs",null,null,null,null,null,{"$f":"SUM(G22:G33)","v":10596.1544638},{"$f":"G34/B6","v":0.13245193079750001}]
["Ownership Costs"]
["Capital Recovery (Depreciation + Interest)",null,null,null,null,null,{"$f":"L7","v":11498.510200341238}]
["Taxes, Insurance, and Housing",null,null,null,null,null,{"$f":"N7","v":1124.1199999999999}]
["Total Ownership Costs",null,null,null,null,null,{"$f":"SUM(G36:G37)","v":12622.630200341238},{"$f":"G38/B6","v":0.15778287750426548}]
["Shrink/Storage Loss",null,null,null,null,null,{"$f":"B6*B18*B7","v":8000},{"$f":"G39/B6","v":0.1}]
["Operating + Ownership + Shrink/Storage Loss Costs",null,null,null,null,null,{"$f":"G38+G34+G39","v":31218.78466414124},{"$f":"G40/B6","v":0.39023480830176549}]
[]
["Footnotes:"]
["Cell  ","Explanation"]
["Cell B7","Current estimated harvest price for corn. "]
["Cell B8&9&10","Bag dimensions 10' x 325'."]
["Cell B12","Average hourly wage for support activities for crop production."]
["Cell B13","Average gallon price of farm diesel delivered."]
["Cell B14","Average fixed operation loan according to Federal Reserve Bank of Kansas City – National Survey of Terms of Lending to Farmers."]
["Cell B15","Average fixed intermediate loan according to Federal Reserve Bank of Kansas City – National Survey of Terms of Lending to Farmers."]
["Cell B16","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]
["Cell B17","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]
["Cell B18","Estimated loss and spoilage for placing grain in a bag."]
["Cell F4","MSRP for loftness 10 ft xl bagger."]
["Cell F5","MSRP for loftness 10 ft bag unloader."]
["Cell F6","Estimated tractor price"]
["Cell G9","Estimated percent of yearly tractor usage to bag and unload grain."]
["Cell E22","Cost to knock down stalks with grain cart."]
["Cell B26","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]
["Cell B27","Estimated cost according to ASABE (Agricultural Machinery Management)."]
["Cell G37","Estimated cost according to ASABE (Agricultural Machinery Management)."]
["Cell G38","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]

{"sheet":"Bin","index":2,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,6],[9,8,9,9]]}
["Grain Bin Storage Estimate"]
["Table 4. Assumptions",null,null,null,"Table 5. Construction Costs",null,null,null,"Table 6. Construction Costs",null,null,null,null,null,"Capital Recovery ($/Year)","Repairs and Maintenance ($/Year)","Taxes, Insurance, and Housing ($/Year)","Fuel & Lubrication"]
[null,null,null,null,null,"Price",null,null,"Machinery ","Purchase Price ($)","Useful Life (years)","Salvage Value ($)",null,"Tractor Auger",{"$f":"(J4-L4)*($B$13/(1-(1+$B$13)^-K4))+(L4*$B$13)","v":553.93774657837741},{"$f":"(J4+L4)/2*B15","v":97.65},{"$f":"(J4+L4)/2*$B$14","v":48.825000000000003},"-"]
["Select Bin Size",80000,"Bushels",null,"Bin (Tank)",99123.21,null,null,"Truck Auger",4650,10,{"$f":"J4*0.05","v":232.5},null,"Fill Auger",{"$f":"(J5-L5)*($B$13/(1-(1+$B$13)^-K5))+(L5*$B$13)","v":2373.5934624890688},{"$f":"(J5+L5)/2*B15","v":418.42500000000001},{"$f":"(J5+L5)/2*$B$14","v":209.21250000000001},"-"]
[null,null,null,null,"Floor",38618.14,null,null,"Fill Auger",19925,10,{"$f":"J5*0.05","v":996.25},null,"Tractor",{"$f":"((J6-L6)*($B$13/(1-(1+$B$13)^-K6))+(L6*$B$13))*K10","v":537.16132713309548},{"$f":"(J6+L6)/2*B15*K10","v":135},{"$f":"((J6+L6)/2*$B$14)*K10","v":67.5},{"$f":"(0.06*J9*0.73*((B21+B22)*B11)*1.15)","v":2408.08896}]
[null,"Value","Unit",null,"Fan",15129.1,null,null,"Tractor",125000,15,10000,null,"Bin",{"$f":"((J7-L7)*($B$13/(1-(1+$B$13)^-K7))+(L7*$B$13))","v":12855.763811503373},{"$f":"(J7+L7)/2*B16","v":1004.16885},{"$f":"((J6+L6)/2*$B$14)*K10","v":67.5},"-"]
["Estimated price",5,"$/bu",null,"Sweep Auger",13246.02,null,null,"Bin",{"$f":"G17","v":200833.77},25,0,null,"Total Machinery Costs",{"$f":"SUM(O3:O6)","v":16320.456347703916},{"$f":"SUM(P3:P6)","v":1655.2438500000001},{"$f":"SUM(Q3:Q6)","v":393.03750000000002},{"$f":"SUM(R3:R6)","v":2408.08896}]
["Bin Size",{"$f":"B4","v":80000},"bu ",null,"Additional Options",7293.18]
["Bin Price",{"$f":"G17","v":200833.77},"$/bin",null,"Labor",32000,null,null,"Tractor PTO HP",120,null,null,null,null,"ASABE Agricultural Machinery Management","Iowa State https://www.extension.iastate.edu/agdm/crops/html/a3-29.html","Iowa State https://www.extension.iastate.edu/agdm/crops/html/a3-29.html","ASABE Agricultural Machinery Management"]
["Labor Rate",15.61,"$/hr",null,"Freight",3600,null,null,"Share of Tractor Annual Use",null,0.05]
["Diesel Price",2.4900000000000002,"$/gallon",null,"Discount",-21676.21]
["Interest Rate (Operating)",0.05,"%",null,null,"Bin Total",{"$f":"SUM(F4:F11)","v":187333.44}]
["Interest Rate (Fixed)",0.04,"%",null,null,"Concrete",10934]
["Taxes, Insurance, & Housing",0.02,"% of purchase price",null,null,"Gravel",566.33000000000004,null,null,null,null,null,null,null,null,"Level",67719,"bu"]
["Machinery - Repair and Maintenance",0.04,"% of purchase price",null,null,"Site Prep",500,null,null,null,null,null,null,"Bin Size",null,"Peaked",80327,"bu"]
["Bin - Repair and Maintenance",0.01,"% of purchase price",null,null,"Electrical",1500,null,null,null,null,null,null,10000]
["Estimated Shrinkage/Spoilage",0.01,"%",null,null,"Total:",{"$f":"SUM(G12:G16)","v":200833.77},null,null,null,null,null,null,20000]
["Table 7. Estimated Costs",null,null,null,null,null,null,null,null,null,null,null,null,40000]
["Operating Costs","Quantity","Unit","Cost per unit","Unit","Total Cost","$/bu",null,null,null,null,null,null,60000]
["Site Maintenance",1,"bin",500,"$/bin",{"$f":"B20*D20","v":500},null,null,null,null,null,null,null,80000]
["Labor Loading",80,"hrs/bin",{"$f":"B10","v":15.61},"$/hr",{"$f":"B21*D21","v":1248.8}]
["Labor Unloading",80,"hrs/bin",{"$f":"B10","v":15.61},"$/hr",{"$f":"B22*D22","v":1248.8}]
["Repair & Maintenance",{"$f":"P7","v":1655.2438500000001},"$","-","$",{"$f":"B23","v":1655.2438500000001}]
["Machinery Fuel & Lubrication",{"$f":"R7","v":2408.08896},"$","-","$",{"$f":"B24","v":2408.08896}]
["Insecticides",800,"lb",2,"$/lb",{"$f":"B25*D25","v":1600}]
["Sensors",8,"# per bin",15,"$/sensor",{"$f":"B26*D26","v":120}]
["Labor - Bin Repair and Monitoring",1,"hrs/bin",{"$f":"B10","v":15.61},"$/hr",{"$f":"B27*D27","v":15.61}]
["Operating Interest",null,null,null,null,{"$f":"SUM(F20:F27)*0.5*B12","v":219.91357025000002}]
["Total Operating Costs",null,null,null,null,{"$f":"SUM(F20:F28)","v":9016.4563802500015},{"$f":"F29/B8","v":0.11270570475312502}]
["Ownership Costs"]
["Capital Recovery (Depreciation + Interest)",null,null,null,null,{"$f":"O7","v":16320.456347703916}]
["Taxes, Insurance, and Housing",null,null,null,null,{"$f":"Q7","v":393.03750000000002}]
["Total Ownership Costs",null,null,null,null,{"$f":"SUM(F31:F32)","v":16713.493847703914},{"$f":"F33/B8","v":0.20891867309629891}]
["Shrink/Storage Loss",null,null,null,null,{"$f":"B8*B7*B17","v":4000},{"$f":"F34/B8","v":0.05}]
["Operating + Ownership + Shrink/Storage Loss Costs",null,null,null,null,{"$f":"F33+F29+F34","v":29729.950227953916},{"$f":"F35/B8","v":0.37162437784942393}]
[]
["Footnotes:"]
["Cell  ","Explanation"]
["Cell B9","Estimated price for bin"]
["Cell B10","Average hourly wage for support activities for crop production."]
["Cell B11","Average gallon price of farm diesel delivered."]
["Cell B12","Average fixed operation loan according to Federal Reserve Bank of St. Louis- Eighth Federal Reserve District Survey."]
["Cell B13","Average fixed intermediate loan according to Federal Reserve Bank of St. Louis- Eighth Federal Reserve District Survey."]
["Cell B14","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]
["Cell B15","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]
["Cell B17","Estimated loss and spoilage for placing grain in a bin."]
["Cell F4","Estimated price for just the bin tank."]
["Cell F5","Estimated price for grain bin floor."]
["Cell F6","Estimated price for the fan(s) for bin."]
["Cell F7","Estimated price for sweep auger. "]
["Cell F8","Estimated price for stairs/ladders, doors and other accessories. "]
["Cell F9","Estimated price for grain bin labor."]
["Cell F10","Estimated freight."]
["Cell F11","Estimated discount off book quote price for cells F4-F10."]
["Cell J4","Estimated truck auger purchase price."]
["Cell J5","Estimated fill auger purchase price."]
["Cell J6","Estimated bin cost from G17."]
["Cell K10","Estimated percent of yearly tractor usage to bag and unload grain."]
["Cell G13","Estimated cost for concrete for bin."]
["Cell G14","Estimated cost for gravel to place a 3 foot radius around bin 3 inches deep."]
["Cell G15","Estimated cost of supplies and labor."]
["Cell B23","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]
["Cell B24","Estimated cost according to ASABE (Agricultural Machinery Management)."]
["Cell G31","Estimated cost according to ASABE (Agricultural Machinery Management)."]
["Cell G32","Estimated cost according to Iowa State.  https://www.extension.iastate.edu/agdm/crops/html/a3-29.html"]

{"sheet":"Size","index":3,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Capacity",10000,20000,40000,60000,80000]
[null,"Bin",18246.830000000002,32993.769999999997,56218.81,85802.57,99123.21,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,2,FALSE)","v":99123.21}]
[null,"Floor",6153.84,10617.22,19681.72,31608.74,38618.14,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,3,FALSE)","v":38618.14}]
[null,"Fan",4053.91,4629.97,9729.16,9109.01,15129.1,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,4,FALSE)","v":15129.1}]
[null,"Sweep Auger",5410.93,6069.28,7087.41,12660.91,13246.02,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,5,FALSE)","v":13246.02}]
[null,"Additional Options",7166.22,5390.89,6334.42,6989.6,7293.18,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,6,FALSE)","v":7293.18}]
[null,"Labor",12900,11000,18200,26000,32000,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,7,FALSE)","v":32000}]
[null,"Freight",1900,1800,1800,3600,3600,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,8,FALSE)","v":3600}]
[null,"Discount",-5128.8900000000003,-7462.64,-12381.44,-18271.349999999999,-21676.21,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,9,FALSE)","v":-21676.21}]
[null,"Bin Total",{"$f":"SUM($C$3:$C$10)","v":50702.840000000004},{"$f":"SUM(D3:D10)","v":65038.490000000005},{"$f":"SUM(E3:E10)","v":106670.08},{"$f":"SUM(F3:F10)","v":157499.48000000001},{"$f":"SUM(G3:G10)","v":187333.44},null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,10,FALSE)","v":187333.44}]
[null,"Concrete",{"$f":"16*142","v":2272},{"$f":"30*142","v":4260},6958,8520,{"$f":"77*142","v":10934},null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,11,FALSE)","v":10934}]
[null,"Gravel",246.53,276.33,410,485.33,566.33000000000004,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,12,FALSE)","v":566.33000000000004}]
[null,"Site Prep",500,500,500,500,500,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,13,FALSE)","v":500}]
[null,"Electrical",1500,1500,1500,1500,1500,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,14,FALSE)","v":1500}]
[null,"Total Fixed Cost",{"$f":"SUM($C$11:$C$15)","v":55221.37},{"$f":"SUM(D11:D15)","v":71574.820000000007},{"$f":"SUM(E11:E15)","v":116038.08},{"$f":"SUM(F11:F15)","v":168504.81},{"$f":"SUM(G11:G15)","v":200833.77},null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,15,FALSE)","v":200833.77}]
["Machinery PP","Truck Auger",4650,4650,4650,4650,4650,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,16,FALSE)","v":4650}]
[null,"Fill Auger",14300,14300,15750,17600,19925,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,17,FALSE)","v":19925}]
[null,"Tractor",125000,125000,125000,125000,125000,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,18,FALSE)","v":125000}]
[null,"Bin",55221,{"$f":"D16","v":71574.820000000007},{"$f":"E16","v":116038.08},{"$f":"F16","v":168504.81},{"$f":"G16","v":200833.77},null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,19,FALSE)","v":200833.77}]
["Other","Labor Loading",10,20,40,60,80,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,20,FALSE)","v":80}]
[null,"Labor Unloading",10,20,40,60,80,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,21,FALSE)","v":80}]
[null,"Labor Bin Repair/monitor",1,1,1,1,1,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,22,FALSE)","v":1}]
[null,"Insecticides",{"$f":"10*(C2/1000)","v":100},{"$f":"10*(D2/1000)","v":200},400,600,800,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,23,FALSE)","v":800}]
[null,"Sensors",1,2,4,6,8,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,24,FALSE)","v":8}]
[null,"Level",10173,21232,43340,54853,67719,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,25,FALSE)","v":67719}]
[null,"Peaked",11322,23956,49796,64044,80327,null,{"$f":"HLOOKUP(+Bin!$B$4,$B$2:$G$27,26,FALSE)","v":80327}]

{"sheet":"10000 bu bin","index":4,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":true,"merged":[[6,0,6,1],[26,0,26,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[21,1,21,2],[23,1,23,2],[24,1,24,2],[0,0,0,1],[20,1,20,2],[22,1,22,2],[19,1,19,2],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[11,0,11,1],[14,0,14,1]]}
["Variable Cost",null,"Hours","Cost/Hour","Total Cost"]
["Tractor",null,10,28.5,{"$f":"C2*D2","v":285},null,null,null,null,"Storage"]
["Transportation",null,null,null,null,null,null,null,null,"Level",10173,"bu"]
["Labor/Year",null,null,null,null,null,null,null,null,"Peaked",11322,"bu"]
["Shrinkage/Spoilage"]
[]
["Bin Costs",null,10000,20000]
["Bin",null,18246.830000000002]
["Floor",null,6153.84]
["Fan",null,4053.91]
["Sweep Auger",null,5410.93]
["Additional Options",null,7166.22]
["Labor",null,12900]
["Freight",null,1900]
["Discount",null,-5128.8900000000003,null,null,null,null,null,null,null,"40 per cubic yard for gravel"]
[null,"Bin Total",null,{"$f":"SUM($C$8:$C$15)","v":50702.840000000004}]
[null,"Concrete",null,{"$f":"16*142","v":2272}]
[null,"Gravel",null,246.53]
[null,"Site Prep",null,500]
[null,"Eletrical"]
[null,"Depreciation/year",null,1388.114]
[null,"Interest/year",null,{"$f":"0.0488*$D$21","v":67.739963200000005}]
[null,"Insurance/year"]
[null,"Taxes/year"]
[null,"Total Fixed Cost",null,{"$f":"SUM($D$16:$D$24)","v":55177.223963200006}]
[]
["Depreciation ",null,"Intial Cost","Salvage Value","Useful Life","Depreciation/Year"]
[null,"Bin",{"$f":"$D$16-SUM($C$13:$C$14)","v":35902.840000000004},0,25,{"$f":"(C28-D28)/E28","v":1436.1136000000001}]
[null,"Truck Auger",4650,0,10,{"$f":"(C29-D29)/E29","v":465}]
[null,"Fill Auger",14300,0,10,1430,null,null,null,null,null,null,null,"kk"]

{"sheet":"20000 bu bin","index":5,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,0,1],[26,0,26,1],[11,0,11,1],[14,0,14,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[6,0,6,1],[7,0,7,1],[21,1,21,2],[19,1,19,2],[20,1,20,2],[23,1,23,2],[22,1,22,2],[8,0,8,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[24,1,24,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2]]}
["Variable Cost",null,"Hours","Cost/Hour","Total Cost"]
["Tractor",null,20,28.5,{"$f":"C2*D2","v":570},null,null,null,null,"Storage"]
["Transportation",null,null,null,{"$f":"C3*D3","v":0},null,null,null,null,"Level",21232,"bu"]
["Labor/Year",null,20,16.38,327.59999999999997,null,null,null,null,"Peaked",23956,"bu"]
["Shrinkage/Spoilage"]
[]
["Bin Costs"]
["Bin",null,32993.769999999997]
["Floor",null,10617.22]
["Fan",null,4629.97]
["Sweep Auger",null,6069.28]
["Additional Options",null,5390.89]
["Labor",null,11000]
["Freight",null,1800]
["Discount",null,-7462.64]
[null,"Bin Total",null,{"$f":"SUM(C8:C15)","v":65038.490000000005}]
[null,"Concrete",null,{"$f":"30*142","v":4260}]
[null,"Gravel",null,276.33]
[null,"Site Prep",null,500]
[null,"Eletrical"]
[null,"Depreciation/year",null,2005.54]
[null,"Interest/year",null,{"$f":"0.0488*D21","v":97.870352000000011}]
[null,"Insurance"]
[null,"Taxes"]
[null,"Total Fixed Cost",null,{"$f":"SUM(D16:D24)","v":72178.230351999999}]
[]
["Depreciation ",null,"Intial Cost","Salvage Value","Useful Life","Depreciation/Year"]
[null,"Bin",{"$f":"D16-SUM(C13:C14)","v":52238.490000000005},0,25,{"$f":"(C28-D28)/E28","v":2089.5396000000001}]
[null,"Truck Auger",4650,0,10,{"$f":"(C29-D29)/E29","v":465}]
[null,"Fill Auger",14300,0,10,1430]

{"sheet":"40000 bu bin","index":6,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[26,0,26,1],[0,0,0,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[13,0,13,1],[21,1,21,2],[7,0,7,1],[8,0,8,1],[9,0,9,1],[12,0,12,1],[11,0,11,1],[14,0,14,1],[6,0,6,1],[10,0,10,1],[15,1,15,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2]]}
["Variable Costs",null,null,"Hours","Cost/Hour","Total Cost"]
["Tractor",null,40,28.5,{"$f":"C2*D2","v":1140},null,null,null,null,"Storage"]
["Transportation",null,null,null,{"$f":"C3*D3","v":0},null,null,null,null,"Level",43340,"bu"]
["Labor/Year",null,40,16.38,655.19999999999993,null,null,null,null,"Peaked",49796,"bu"]
["Shrinkage/Spoilage"]
[]
["Bin Cost"]
["Bin",null,56218.81]
["Floor",null,19681.72]
["Fan",null,9729.16]
["Sweep Auger",null,7087.41]
["Additional Options",null,6334.42]
["Labor",null,18200]
["Freight",null,1800]
["Discount",null,-12381.44]
[null,"Bin Total",null,{"$f":"SUM(C8:C15)","v":106670.08}]
[null,"Concrete",null,6958]
[null,"Gravel",null,410]
[null,"Site Prep",null,500]
[null,"Eletrical"]
[null,"Depreciation/year",null,3318.8]
[null,"Interest/year",null,{"$f":"0.0488*D21","v":161.95744000000002}]
[null,"Insurance"]
[null,"Taxes"]
[null,"Total Fixed Cost",null,{"$f":"SUM(D16:D24)","v":118018.83744}]
[]
["Depreciation ",null,"Intial Cost","Salvage Value","Useful Life","Depreciation/Year"]
[null,"Bin",{"$f":"D16-SUM(C13:C14)","v":86670.080000000002},0,25,{"$f":"(C28-D28)/E28","v":3466.8032000000003}]
[null,"Truck Auger",4650,0,10,{"$f":"(C29-D29)/E29","v":465}]
[null,"Fill Auger",15750,0,10,1575]

{"sheet":"60000 bu bin","index":7,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,0,1],[6,0,6,1],[26,0,26,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[12,0,12,1],[21,1,21,2],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[14,0,14,1],[13,0,13,1],[24,1,24,2],[20,1,20,2],[22,1,22,2],[23,1,23,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
["Variable Cost",null,"Hours","Cost/Hour","Total Cost"]
["Tractor/year",null,{"$f":"1710/28.5","v":60},28.5,{"$f":"C2*D2","v":1710},null,null,null,null,"Storage"]
["Transportation",null,null,null,{"$f":"C3*D3","v":0},null,null,null,null,"Level",54853,"bu"]
["Labor/Year",null,60,16.38,982.8,null,null,null,null,"Peaked",64044,"bu"]
["Shrinkage/ Spoilage"]
[]
["Bin Cost"]
["Bin",null,85802.57]
["Floor",null,31608.74]
["Fan",null,9109.01]
["Sweep Auger",null,12660.91]
["Additional Options",null,6989.6]
["Labor",null,26000]
["Freight",null,3600]
["Discount",null,-18271.349999999999]
[null,"Bin Total",null,{"$f":"SUM(C8:C15)","v":157499.48000000001}]
[null,"Concrete",null,8520]
[null,"Gravel",null,485.33]
[null,"Site Prep",null,500]
[null,"Eletrical"]
[null,"Depreciation/Year",null,4907.9799999999996]
[null,"Interest/Year",null,{"$f":"0.0488*D21","v":239.509424}]
[null,"Insurance"]
[null,"Taxes"]
[null,"Total Fixed Cost",null,{"$f":"SUM(D16:D24)","v":172152.299424}]
[]
["Depreciation ",null,"Intial Cost","Salvage Value","Useful Life","Depreciation/Year"]
[null,"Bin",{"$f":"D16-SUM(C13:C14)","v":127899.48000000001},0,25,{"$f":"(C28-D28)/E28","v":5115.9792000000007}]
[null,"Truck Auger",4650,0,10,{"$f":"(C29-D29)/E29","v":465}]
[null,"Fill Auger",17600,0,10,1760]

{"sheet":"80000 bu bin","index":8,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":true,"merged":[[26,0,26,1],[20,1,20,2],[21,1,21,2],[22,1,22,2],[11,0,11,1],[14,0,14,1],[19,1,19,2],[12,0,12,1],[15,1,15,2],[16,1,16,2],[18,1,18,2],[13,0,13,1],[23,1,23,2],[24,1,24,2],[17,1,17,2],[0,0,0,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[3,0,3,1],[4,0,4,1],[1,0,1,1],[2,0,2,1]]}
["Variable Cost",null,"Hours","Cost/Hour","Total Cost"]
["Tractor/year",null,80,28.5,{"$f":"C2*D2","v":2280},null,null,null,null,"Storage"]
["Transportation",null,null,null,{"$f":"C3*D3","v":0},null,null,null,null,"Level",67719,"bu"]
["Labor/Year",null,80,16.38,1310.3999999999999,null,null,null,null,"Peaked",80327,"bu"]
["Shrinkage/Spoilage"]
[]
["Bin Cost"]
["Bin",null,99123.21]
["Floor",null,38618.14]
["Fan",null,15129.1]
["Sweep Auger",null,13246.02]
["Additional Options",null,7293.18]
["Labor",null,32000]
["Freight",null,3600]
["Discount",null,-21676.21]
[null,"Bin Total",null,{"$f":"SUM(C8:C15)","v":187333.44}]
[null,"Concrete",null,{"$f":"77*142","v":10934}]
[null,"Gravel",null,566.33000000000004]
[null,"Site Prep",null,500]
[null,"Eletrical"]
[null,"Depreciation/Year"]
[null,"Interest/Year"]
[null,"Insurance"]
[null,"Taxes"]
[null,"Total Fixed Cost",null,{"$f":"SUM(D16:D24)","v":199333.77}]
[]
["Depreciation ",null,"Intial Cost","Salvage Value","Useful Life","Depreciation/Year"]
[null,"Bin",{"$f":"D16-SUM(C13:C14)","v":151733.44},0,25,{"$f":"(C28-D28)/E28","v":6069.3375999999998}]
[null,"Auger"]

{"sheet":"Bin Costs","index":9,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[[19,1,19,2],[20,1,20,2],[21,1,21,2],[36,1,36,2],[37,1,37,2],[35,1,35,2],[33,1,33,2],[26,1,26,2],[0,1,0,9],[4,1,4,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[7,1,7,2],[3,0,3,2],[5,1,5,2],[6,1,6,2],[8,1,8,2],[38,1,38,2],[39,1,39,2],[12,1,12,2],[27,1,27,2],[30,0,30,2],[31,1,31,2],[32,1,32,2],[34,1,34,2],[17,0,17,2],[18,1,18,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[13,1,13,2],[14,1,14,2]]}
[null,"Grain Bin Cost"]
[]
[null,null,null,null,null,null,null,"Number of Bushels Stored",null,null,60000]
["Fixed Costs"]
[null,"Grain Bin Cost"]
[null,"Concrete"]
[null,"Gravel"]
[null,"Site Prep"]
[null,"Eletrical"]
[null,"Depreciation"]
[null,"Interest",null,4.8800000000000003E-2,null,"https://www.dtnpf.com/agriculture/web/ag/news/business-inputs/article/2021/05/04/farm-credit-rates"]
[null,"Insurance"]
[null,"Load Out Bin"]
[null,"Taxes"]
[null,"Total Fixed Cost"]
[]
[]
["Machinery Costs"]
[null,"Tractor",null,124000,null,"https://configure.deere.com/cbyo/#/en_us/configure/117649354",null,null,null,null,null,null,"Johndeere 6130m"]
[null,"Grain Dryer"]
[null,"Leg"]
[null,"Pit"]
[null,"Auger",null,14000,null,null,null,"rough estimate from tractor house on new 19 1080hp brandt"]
[null,"Transportation"]
[null,"Fan",null,9000,null,null,null,null,null,"using 2 20 hp gsi fans"]
[null,"Sweep Auger",null,null,null,null,null,null,null,null,null,null," "]
[null,"Load Out Auger"]
[null,"Total Machinery Costs"]
[]
[]
["Variable Costs"]
[null,"Shrinkage",null,0.02]
[null,"Spoilage",null,0.02]
[null,"Handling Loss",null,5.0000000000000001E-3,null,"kentucky number"]
[null,"Insecticides"]
[null,"Eletricty",null,2400,null,null,null,null,"for 2 20 hp fan rough estimate found on thread needs to be confirmed"]
[null,"Propane/Natural Gas"]
[null,"Repairs"]
[null,"Labor/hour",null,16.38,null,null,null,"https://www.bls.gov/oes/current/oes452091.htm"]
[null,"Total Variable Costs"]

{"sheet":"Sheet1","index":10,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[10000,null,null,20000,null,null,40000,null,null,60000,null,null,80000]
["Intial Cost",{"$f":"50702.84","v":50702.84},null,"Intial Cost",65038.49,null,"Intial Cost",{"$f":"106670.08","v":106670.08},null,"Intial Cost",{"$f":"157499.48","v":157499.48000000001},null,"Intial Cost"]
["concerete ",1600,null,"concrete",3000,null,"concrete",4900,null,"concrete",6000,null,"cocrete"]