{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Input","Summary","Details"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"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":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"This Biodiesel Production Cost Calculator has 4 worksheets.\n There are fields that can be completed by the user. It is 8 columns wide and 250 rows long."]
[null,"Guidelines For Estimating"]
[null,"Soybean Biodiesel Production Costs - Farm Fuel"]
[null,{"$f":"\"Based on \"&Input!D14&\",000 Litres per year\"","v":"Based on 15,000 Litres per year"}]
[]
[]
[]
[]
[]
[]
[]
[null,"This guide provides you with planning information and a format for calculating costs of production for on-farm biodiesel production based on the cost of growing soybeans on your farm. Opportunity costs related to potential soybean market prices are not included. Adjustments will be necessary when applying these figures to your own enterprise. "]
[]
[null,"The budget estimates are based on a number of assumptions which are clearly defined in the \nsupporting pages.  Input costs are based on industry information. Proper plant management in the production process and compliance to all applicable environmental and safety requirements is assumed.  Most original equipment manufacturers (OEM) require biodiesel to meet ASTM D6751 fuel quality standard."]
[]
[null,"Disclaimer: This budget is only a guide and is not intended as an in depth study of the cost of \nproduction of the biodiesel industry. Interpretation and use of this information is the responsibility of the user. If you require assistance with developing your individual budget for your operation, call the Agricultural Information Contact Centre at 1-877-424-1300."]
[]
[]
[null,"Adapted for Ontario by Kevin McKague and Richard Brunke"]
[null,"Engineering Specialists, OMAFRA"]
[null,"email: kevin.mckague@ontario.ca"]
[null,"version October 14, 2014"]
[null,"2021-10-14"]
[]
[]
[null,"End of worksheet"]

{"sheet":"Input","index":1,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,"This Biodiesel Production Cost Calculator has 4 worksheets.\n There are fields that can be completed by the user. It is 8 columns wide and 250 rows long."]
[null,"Biodiesel Production Costs - Input"]
[]
[null,"Assumptions"]
[]
[null,"1.  This budget outlines the cost of production for a biodiesel operation."]
[null,"2.  Buildings and equipment are valued at new cost."]
[null,"3.  All soybean feedstock is valued at cost of production."]
[null,"4.  Feedstock cost (vegetable oil) includes the market value of"]
[null,"     soybean meal produced."]
[null,"5.  All biodiesel produced is for farm use only."]
[]
[null,"Biodiesel Plant Production",null,"Input Variables","   Units","Comments"]
[null," Plant size - thousands of litres",null,15]
[null," Days per year",null,65]
[null," Hours operation per day",null,8]
[null," Employees per shift - biodiesel production",null,0.25]
[null," Labour rate",null,20,"/ hour"]
[]
[null,"Vegetable oil required per litre biodiesel",null,0.99087999999999998," litres"]
[null," Methanol",null,6950," / tonne"]
[null," Methanol recovery",null,25,"%"]
[null," Catalyst - potassium hydroxide",null,12350," / tonne"]
[]
[null," Glycerol",null,180," / tonne"]
[null," Diesel (coloured) farm fuel - ULSD",null,1.2," / litre"]
[null," On-farm biodiesel blend usage",null,100,"%"]
[null," On-farm fuel efficiency increase with biodiesel use",null,1.5,"%"]
[]
[null,"Soybean Oil Production"]
[null," Soybean feedstock cost (or cost of production)",null,310," / acre"]
[null," Soybean average yield - bushels",null,45," / acre"]
[null," Soybean meal - 48% protein",null,515," / tonne"]
[null," Days per year",null,155]
[null," Hours operation per day",null,24]
[null," Employees per shift - soybean oil production",null,0.05]
[null," Labour rate",null,20,"/ hour"]
[null," Soybean oil content",null,17.5,"%"]
[null," Residual oil in soybean meal",null,8.5,"%"]
[null," Shrinkage in oilseed processing",null,3,"%"]
[null," Residual oil in soybean meal (solvent extraction)",null,1,"%"]
[]
[null," Extra oil meal premium",null,0,"%"]
[null," Soybean oil bulk density",null,0.92," kg / L"]
[]
[null,"Other Operating Costs"]
[null," Hydro",null,0.15," / kWhr"]
[null," Maintenance",null,2.5,"%"]
[null," Waste/washwater disposal",null,0.1333," / L"]
[null," Ontario Fuel Tax submission  (0.143/L if product used in licensed vehicles)",null,0," / L"]
[null," Misc. administration  (e.g. Registration with Ontario Ministry of Finance)",null,0," / year"]
[null," Insurance",null,0.5,"%"]
[null," Property taxes",null,0.5,"%"]
[null," Investment rate  ",null,2.5,"%"]
[null," Operating interest rate  ",null,4,"%"]
[null,null,"","",null,null,""]
[null,"Capital Costs"]
[null,"   Buildings ","Original Value",null,"Salvage Value","Useful Life"]
[null,"    Biodiesel plant",3000,null,0.1,20,"years"]
[null,"    Soybean oil plant",5000,null,0.1,20,"years"]
[null,"   Total ",{"$f":"SUM(C59:C60)","v":8000},null,{"$f":"AVERAGE(E59:E60)","v":0.1},{"$f":"AVERAGE(F59:F60)","v":20},"years"]
[null,null,null,null,null,null,""]
[null,"  Machinery & Equipment"]
[null,"    Biodiesel plant",3000,null,0.1,15,"years"]
[null,"    Soybean oil plant",36000,null,0.1,15,"years"]
[null,"    Total ",{"$f":"SUM(C64:C65)","v":39000},null,{"$f":"AVERAGE(E64:E65)","v":0.1},{"$f":"AVERAGE(F64:F65)","v":15},"years"]
[]
[null,"    Total Bldg., Mach. & Equip ",{"$f":"C61+C66","v":47000}]
[]
[null,"    Total Land Value",10000]
[]
[null,"    Total Capital Investment",{"$f":"C68+C70","v":57000}]
[]
[]
[]
[null,"end of worksheet"]

{"sheet":"Summary","index":2,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"This Biodiesel Production Cost Calculator has 4 worksheets.\n There are fields that can be completed by the user. It is 8 columns wide and 250 rows long."]
[null,{"$f":"\"      Biodiesel Production Costs - Farm Fuel\"","v":"      Biodiesel Production Costs - Farm Fuel"},null,{"$f":"TODAY()","v":"2023-04-26"}]
[null,{"$f":"\"Based on \"&Input!D14&\",000 Litres and Soybean Production Costs of\"","v":"Based on 15,000 Litres and Soybean Production Costs of"}]
[null,{"$f":"\"       \"&TEXT(Input!D31,\"$#.##\")&\" per acre and Yield of \"&Input!D32&\" bushels per acre\"","v":"       $310. per acre and Yield of 45 bushels per acre"}]
[]
[null,"A.  Operating Costs","Cost/Litre","Total Cost","Your Actual Cost"]
[null,"1.  Input Costs"]
[null,"    1.01   Feedstock  (soy oil minus meal value)",{"$f":"SUM(D8/(Input!D14*1000))","v":-2.0261418763207115},{"$f":"Details!G58","v":-30392.128144810675}]
[null,"    1.02   Methanol",{"$f":"SUM(D9/(Input!D14*1000))","v":1.0453883088000002},{"$f":"Details!G68","v":15680.824632000002}]
[null,"    1.03   Catalyst",{"$f":"SUM(D10/(Input!D14*1000))","v":0.18249831645760001},{"$f":"Details!G78","v":2737.4747468640003}]
[null,"Subtotal Input Cost",{"$f":"C8+C9+C10","v":-0.79825525106311135},{"$f":"SUM(D8:D10)","v":-11973.828765946673}]
[]
[null,"2.  Other Operating Costs",""]
[null,"    2.01   Hydro",{"$f":"SUM(D14/(Input!D14*1000))","v":0.24236044800000009},{"$f":"Details!G101","v":3635.4067200000013}]
[null,"    2.02   Maintenance",{"$f":"SUM(D15/(Input!D14*1000))","v":7.8333333333333338E-2},{"$f":"Details!G108","v":1175}]
[null,"    2.03   Waste/washwater disposal",{"$f":"SUM(D16/(Input!D14*1000))","v":0.1333},{"$f":"Details!G111","v":1999.5}]
[null,"    2.04   Ontario Fuel Tax submission",{"$f":"SUM(D17/(Input!D14*1000))","v":0},{"$f":"Details!G112","v":0}]
[null,"    2.05   Misc. administration",{"$f":"SUM(D18/(Input!D14*1000))","v":0},{"$f":"Details!G113","v":0}]
[null,"    2.06   Insurance",{"$f":"SUM(D19/(Input!D14*1000))","v":1.5666666666666666E-2},{"$f":"Details!G120","v":235}]
[null,"    2.07   Property taxes",{"$f":"SUM(D20/(Input!D14*1000))","v":6.0000000000000001E-3},{"$f":"Details!G127","v":90}]
[null,"Subtotal Operating Costs",{"$f":"SUM(C14:C20)","v":0.47566044800000012},{"$f":"SUM(D14:D20)","v":7134.9067200000009}]
[null,"    2.08   Operating interest",{"$f":"SUM(D22/(Input!D14*1000))","v":9.5333333333333329E-3},{"$f":"ROUND(Details!G135,0)","v":143}]
[null,"Total Operating Costs",{"$f":"C21+C22+C11","v":-0.31306146972977789},{"$f":"SUM(D21:D22)+D11","v":-4695.9220459466724}]
[]
[null,"3.  Depreciation"]
[null,"    3.01   Buildings",{"$f":"SUM(D26/(Input!D14*1000))","v":2.4E-2},{"$f":"Details!G164","v":360}]
[null,"    3.02   Machinery and equipment",{"$f":"SUM(D27/(Input!D14*1000))","v":0.156},{"$f":"Details!G170","v":2340}]
[]
[null,"4.  Investment","",""]
[null,"    4.01   Buildings",{"$f":"SUM(D30/(Input!D14*1000))","v":7.3333333333333332E-3},{"$f":"Details!G179","v":110}]
[null,"    4.02   Machinery and equipment",{"$f":"SUM(D31/(Input!D14*1000))","v":3.5749999999999997E-2},{"$f":"Details!G186","v":536.25}]
[null,"    4.03   Land",{"$f":"SUM(D32/(Input!D14*1000))","v":1.6666666666666666E-2},{"$f":"Details!G191","v":250}]
[null,"Total Fixed Costs",{"$f":"SUM(C26:C32)","v":0.23974999999999999},{"$f":"SUM(D26:D32)","v":3596.25}]
[null,"Total Operating and Fixed Costs",{"$f":"C23+C33","v":-7.3311469729777895E-2},{"$f":"D23+D33","v":-1099.6720459466724}]
[]
[null,"C.  Labour",{"$f":"SUM(D36/(Input!D14*1000))","v":0.42133333333333334},{"$f":"Details!G209","v":6320}]
[null,"Total Cost of Production",{"$f":"C34+C36","v":0.34802186360355547},{"$f":"D36+D34","v":5220.3279540533276}]
[]
[null,"D.  Value"]
[null,"5.  Biodiesel"]
[null,"    5.01   Estimated on-farm biodiesel value",{"$f":"SUM(D41/(Input!D14*1000))","v":1.2},{"$f":"Details!G216","v":18000}]
[null,"    5.02   Estimated increased fuel efficiency value",{"$f":"SUM(D42/(Input!D14*1000))","v":1.8274111675126825E-2},{"$f":"Details!G231","v":274.11167512690236}]
[null,"    5.03   Glycerol sales",{"$f":"SUM(D43/(Input!D14*1000))","v":1.6845912000000001E-2},{"$f":"Details!G236","v":252.68868000000001}]
[null,"Total Value",{"$f":"C41+C42+C43","v":1.2351200236751267},{"$f":"D41+D42+D43","v":18526.800355126903}]
[]
[null,"Total Value - Cost of Production",{"$f":"C44-C37","v":0.88709816007157127},{"$f":"D44-D37","v":13306.472401073575}]
[]
[null,"Breakeven price"," $/Litre"," $ Cost of Prod./Bushel"]
[null,"        A. Operating Costs",{"$f":"SUM((D23-(D44-D41))/(Input!D14*1000))","v":-0.34818149340490501},{"$f":"SUM(((D44-D23)/(Details!G32))+Details!G36)","v":11.049541895230803}]
[null,"        B. Operating and labour costs",{"$f":"SUM(((D23+D36)-(D44-D41))/(Input!D14*1000))","v":7.3151839928428303E-2},{"$f":"SUM(((D44-D23-D36)/(Details!G32))+Details!G36)","v":9.9175340141632766}]
[null,"        C. Operating and fixed costs",{"$f":"SUM((D34-(D44-D41))/(Input!D14*1000))","v":-0.10843149340490503},{"$f":"SUM(((D44-D34)/(Details!G32))+Details!G36)","v":10.405398961324302}]
[null,"        D. Operating, fixed and labour costs",{"$f":"SUM(((D34+D36)-(D44-D41))/(Input!D14*1000))","v":0.31290183992842829},{"$f":"SUM(((D44-D34-D36)/(Details!G32))+Details!G36)","v":9.2733910802567738}]
[]
[]
[null,{"$f":"\"Breakeven Price $/Litre = (Cost - (Total Value - Est. on-farm biodiesel value)) ÷ \"&Input!D14&\",000 litres\"","v":"Breakeven Price $/Litre = (Cost - (Total Value - Est. on-farm biodiesel value)) ÷ 15,000 litres"}]
[null,{"$f":"\"Breakeven Price $COP/Bu. = Total Value - Cost ÷ \"&Details!G32&\" bu. of soybeans + $\"&Details!G36&\" COP per bu.\"","v":"Breakeven Price $COP/Bu. = Total Value - Cost ÷ 5583 bu. of soybeans + $6.89 COP per bu."}]
[null,null,{"$f":"\"(with soybean meal = $\"&Input!D33&\"/tonne)\"","v":"(with soybean meal = $515/tonne)"}]
[]
[]
[]
[]
[null,"Disclaimer: This budget is only a guide and is not intended as an in-depth study of the cost of production of"]
[null,"this industry.  Interpretation and use of this information is the responsibility of the user. No liability for"]
[null,"decisions based on the interpretation and use of the information in this publication is assumed."]

{"sheet":"Details","index":3,"n_rows":249,"n_cols":9,"rows_kept":249,"cut":false,"hidden":false,"merged":[]}
[null,"This Biodiesel Production Cost Calculator has 4 worksheets.\n There are fields that can be completed by the user. It is 8 columns wide and 250 rows long."]
[null,"Biodiesel Production Worksheet"]
[]
[]
[null,"Assumptions"]
[null,"1.  This budget outlines the cost of production for a biodiesel operation."]
[null,"2.  Buildings and equipment are valued at new cost."]
[null,"3.  All soybean feedstock is valued at cost of production."]
[null,"4.  Feedstock cost (vegetable oil) includes the market value of soybean meal produced."]
[null,"5.  All biodiesel produced is for farm use only."]
[]
[]
[]
[null,"A. Operating Costs"]
[null,null,"1.  Input Costs",null,null,null,null,null,"Your Values"]
[null,null,null,"1.01  Feedstock - vegetable oil"]
[null,null,null,null,null,null,{"$f":"Input!D38/100","v":0.17499999999999999},"soybean oil content"]
[null,null,null,null,null,"-",{"$f":"Input!D39/100","v":8.5000000000000006E-2},"residual oil in soybean meal"]
[null,null,null,null,null,"=",{"$f":"(G17-G18)","v":8.9999999999999983E-2},"net oil extraction"]
[null,null,null,null,null,"-",{"$f":"Input!D40/100","v":0.03},"shrinkage in processing"]
[null,null,null,null,null,"=",{"$f":"(1-G19-G20)","v":0.88},"net soybean meal yield"]
[]
[null,null,null,null,null,"x",1000,"kg per tonne"]
[null,null,null,null,null,"=",{"$f":"SUM(G19*G23)","v":89.999999999999986},"kg oil per tonne of soybeans"]
[null,null,null,null,null,"÷",{"$f":"Input!D44","v":0.92},"Soybean oil bulk density kg/L"]
[null,null,null,null,null,"=",{"$f":"SUM(G24/G25)","v":97.826086956521721},"Litres oil per tonne of soybeans"]
[]
[null,null,null,null,null,null,{"$f":"SUM(1000*Input!D14)","v":15000},"Biodiesel Plant Capacity - litres"]
[null,null,null,null,null,"x",{"$f":"Input!D20","v":0.99087999999999998},"oil required per litre biodiesel"]
[null,null,null,null,null,"÷",{"$f":"G26","v":97.826086956521721},"Litres oil per tonne of soybeans"]
[null,null,null,null,null,"=",{"$f":"SUM((G28*G29)/G30)","v":151.93493333333336},"Tonnes Soybeans required"]
[null,null,null,null,null,null,{"$f":"ROUND(G31*36.744,0)","v":5583},"Bushels Soybean required"]
[]
[null,null,null,null,null,null,{"$f":"Input!D31","v":310},"Soybean cost of production per acre"]
[null,null,null,null,null,"÷",{"$f":"Input!D32","v":45},"Yield per acre"]
[null,null,null,null,null,null,{"$f":"ROUND(G34/G35,2)","v":6.89},"Feedstock cost of production per bushel"]
[null,null,null,null,null,null,{"$f":"SUM(G36*36.744)","v":253.16615999999999},"Feedstock cost per tonne"]
[null,null,null,null,null,"x",{"$f":"G31","v":151.93493333333336},{"$f":"H31","v":"Tonnes Soybeans required"}]
[null,null,null,null,null,"=",{"$f":"SUM(G37*G38)","v":38464.783641856004},"Feedstock - Soybeans"]
[]
[null,null,null,null,null,null,{"$f":"G31","v":151.93493333333336},{"$f":"H31","v":"Tonnes Soybeans required"}]
[null,null,null,null,null,"x",{"$f":"G21","v":0.88},"net soybean meal yield"]
[null,null,null,null,null,"=",{"$f":"SUM(G41*G42)","v":133.70274133333336},"Tonnes soybean meal"]
[]
[null,null,null,null,null,null,{"$f":"SUM(((Input!D39)-Input!D41)/100*1000)","v":75},"Kg extra oil content in meal"]
[null,null,null,null,null,null,{"$f":"SUM((Input!D42)*100)/(40.3*(76/100))*(2183*(167.28/100))/100","v":0},"Soybean oil feed value equivalent"]
[null,null,null,null,null,null,null,"  per tonne (167.28 TDN)"]
[null,null,null,null,null,null,{"$f":"SUM(G45*(G46))/1000","v":0},"Residual oil soybean meal premium"]
[null,null,null,null,null,"x",{"$f":"Input!D43/100","v":0},"Oil premium payable"]
[null,null,null,null,null,"=",{"$f":"SUM(G48*G49)","v":0},"Oil premium per tonne"]
[null,null,null,null,null,"+",{"$f":"Input!D33","v":515},"Soybean meal - 48% protein"]
[null,null,null,null,null,"=",{"$f":"SUM((G48*G49)+G51)","v":515},"Soybean meal price per tonne"]
[null,null,null,null,null,"x",{"$f":"G43","v":133.70274133333336},"Tonnes soybean meal"]
[null,null,null,null,null,"=",{"$f":"SUM(G52*G53)","v":68856.911786666678},"Soybean meal income"]
[]
[null,null,null,null,null,null,{"$f":"G39","v":38464.783641856004},{"$f":"H39","v":"Feedstock - Soybeans"}]
[null,null,null,null,null,"-",{"$f":"G54","v":68856.911786666678},{"$f":"H54","v":"Soybean meal income"}]
[null,null,null,null,"Total ","=",{"$f":"SUM(G56-G57)","v":-30392.128144810675},"Net Feedstock Cost"]
[]
[null,null,null,"1.02  Methanol"]
[null,null,null,null,null,null,{"$f":"SUM(1000*Input!D14)","v":15000},"Biodiesel Plant Capacity - litres"]
[null,null,null,null,null,"x",{"$f":"Input!D20","v":0.99087999999999998},"oil required per litre biodiesel"]
[null,null,null,null,null,"x",{"$f":"Input!D44","v":0.92},"Soybean oil bulk density kg/L"]
[null,null,null,null,null,"x",0.22,"Methanol required"]
[null,null,null,null,null,"x",{"$f":"(Input!D22/100)","v":0.25},"Methanol recovery"]
[null,null,null,null,null,"÷",1000,"kg per tonne"]
[null,null,null,null,null,"x",{"$f":"Input!D21","v":6950},"Methanol per tonne"]
[null,null,null,null,"Total","=",{"$f":"(G61*G62*G63*G64*(1-G65)*G67)/G66","v":15680.824632000002},"Methanol"]
[]
[null,null,null,"1.03  Catalyst"]
[null,null,null,null,null,null,{"$f":"SUM(1000*Input!D14)","v":15000},"Biodiesel Plant Capacity - litres"]
[null,null,null,null,null,"x",{"$f":"Input!D20","v":0.99087999999999998},"oil required per litre biodiesel"]
[null,null,null,null,null,"x",{"$f":"Input!D44","v":0.92},"Soybean oil bulk density kg/L"]
[null,null,null,null,null,"÷",1000,"kg per tonne"]
[null,null,null,null,null,"x",16.21,"kg potassium hydroxide /tonne"]
[null,null,null,null,null,"÷",1000,"kg per tonne"]
[null,null,null,null,null,"x",{"$f":"Input!D23","v":12350},"Catalyst per tonne"]
[null,null,null,null,"Total","=",{"$f":"SUM(G71*G72*G73/G74*G75/G76*G77)","v":2737.4747468640003},"Catalyst "]
[]
[null,null,"2.  Other Operating Costs"]
[null,null,null,"2.01  Hydro"]
[null,null,null,null,null,null,{"$f":"G31","v":151.93493333333336},"Total Tonnes of Soybeans"]
[null,null,null,null,null,"÷",{"$f":"Input!D34","v":155},"Days per year - crush"]
[null,null,null,null,null,null,{"$f":"SUM(G82/G83)","v":0.98022537634408624},"Tonnes soybeans per day"]
[null,null,null,null,null,"÷",{"$f":"Input!D35","v":24}," Hours operation per day - crush"]
[null,null,null,null,null,null,{"$f":"SUM(G84/G85)","v":4.0842724014336924E-2},"Tonnes soybeans per hour"]
[]
[null,null,null,null,null,"x",{"$f":"G84","v":0.98022537634408624},"Tonnes soybeans per day"]
[null,null,null,null,null,"x",8.5,"HP per tonne"]
[null,null,null,null,null,"x",0.75,"HP to kilowatts"]
[null,null,null,null,null,"x",{"$f":"Input!D47","v":0.15},"Hydro rate - kWhr"]
[null,null,null,null,null,"x",{"$f":"Input!D34","v":155},"Days per year - crush"]
[null,null,null,null,null,"x",{"$f":"Input!D35","v":24},"Hours operation per day - crush"]
[null,null,null,null,null,"=",{"$f":"SUM(G88*G89*G90*G91*G92*G93)","v":3486.9067200000013},"Subtotal Hydro - crush"]
[]
[null,null,null,null,null,null,{"$f":"Input!D14*1000","v":15000},"Biodiesel Plant Capacity - litres"]
[null,null,null,null,null,"x",6.6000000000000003E-2,"kWhr per litre"]
[null,null,null,null,null,"x",{"$f":"Input!D47","v":0.15},"Hydro rate - kWhr"]
[null,null,null,null,null,"=",{"$f":"SUM((G96*G97*G98))","v":148.5},"Subtotal Hydro - biodiesel"]
[]
[null,null,null,null,"Total ","=",{"$f":"G99+G94","v":3635.4067200000013},"Hydro"]
[]
[null,null,null,"2.02  Maintenance"]
[null,null,null,null,null,null,{"$f":"Input!C61","v":8000},"capital cost - buildings"]
[null,null,null,null,null,"+",{"$f":"Input!C66","v":39000},"capital cost - equipment"]
[null,null,null,null,null,"=",{"$f":"SUM(G104:G105)","v":47000},"Total bldg. & equipment"]
[null,null,null,null,null,"x",{"$f":"Input!D48/100","v":2.5000000000000001E-2},"Maintenance rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G106*G107)","v":1175},"Total Maintenance"]
[]
[null,null,null,"2.03 - 2.05   Administration"]
[null,null,null,null,null,null,{"$f":"Input!D14*1000*Input!D49","v":1999.5},"Waste/washwater disposal","____________"]
[null,null,null,null,null,null,{"$f":"Input!D14*1000 * Input!D50","v":0},"Ontario Fuel Tax Submission","____________"]
[null,null,null,null,null,null,{"$f":"Input!D51","v":0},"Misc. Administration ","____________"]
[]
[null,null,null,"2.06  Insurance"]
[null,null,null,null,null,null,{"$f":"Input!C61","v":8000},"capital cost - buildings"]
[null,null,null,null,null,"+",{"$f":"Input!C66","v":39000},"capital cost - equipment"]
[null,null,null,null,null,"=",{"$f":"SUM(G116:G117)","v":47000},"Total bldg. & equipment"]
[null,null,null,null,null,"x",{"$f":"Input!D52/100","v":5.0000000000000001E-3},"Insurance rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G118*G119)","v":235},"Total Insurance"]
[]
[null,null,null,"2.07 Property Taxes"]
[null,null,null,null,null,null,{"$f":"Input!C61","v":8000},"capital cost - buildings"]
[null,null,null,null,null,"+",{"$f":"Input!C70","v":10000},"capital cost - land"]
[null,null,null,null,null,"=",{"$f":"SUM(G123:G124)","v":18000},"Total bldg. & land"]
[null,null,null,null,null,"x",{"$f":"Input!D53/100","v":5.0000000000000001E-3},"Property tax rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G125*G126)","v":90},"Total Property tax"]
[]
[null,null,null,"2.08  Operating Interest"]
[null,null,null,"         (Operating interest is charged on one half of the subtotal operating costs)"]
[]
[null,null,null,null,null,null,{"$f":"Summary!D21","v":7134.9067200000009},"subtotal operating costs"]
[null,null,null,null,null,"÷",2,"average"]
[null,null,null,null,null,"x",{"$f":"Input!D55","v":4},"% operating interest rate"]
[null,null,null,null,null,"=",{"$f":"ROUND((G132/G133)*(G134),2)/100","v":142.69809999999998},"Operating Interest"]
[]
[null,null,null,null,null,null,"Capital Costs"]
[]
[null,null,"  Buildings"]
[null,null,"        Biodiesel Plant",null,null,null,null,{"$f":"Input!C59","v":3000}]
[null,null,"        Soybean oil Plant",null,null,null,null,{"$f":"Input!C60","v":5000}]
[null,null,"         Total Building Cost",null,null,null,null,{"$f":"SUM(H140:H141)","v":8000}]
[]
[null,null,"  Machinery & Equipment"]
[null,null,"        Biodiesel Plant",null,null,null,null,{"$f":"Input!C64","v":3000}]
[null,null,"        Soybean oil Plant",null,null,null,null,{"$f":"Input!C65","v":36000}]
[null,null,"         Total Machinery & Equipment Cost",null,null,null,null,{"$f":"SUM(H145:H146)","v":39000}]
[]
[null,null,"Total Bldg., Mach. & Equip.",null,null,null,null,{"$f":"H142+H147","v":47000}]
[]
[null,null,"Total Land Value",null,null,null,null,{"$f":"Input!C70","v":10000}]
[]
[null,null,"Total Capital Investment",null,null,null,null,{"$f":"H149+H151","v":57000}]
[]
[]
[null,"B. Fixed Costs"]
[null,null,"3.  Depreciation",null,null,null,"Original Cost - Salvage Value"]
[null,null,null,null,null,null,"                              Useful Life"]
[]
[null,null,null,"3.01  Buildings"]
[null,null,null,null,null,null,{"$f":"Input!C61","v":8000},"original cost"]
[null,null,null,null,null,"-",{"$f":"(Input!E61)*Input!C61","v":800},"salvage value"]
[null,null,null,null,null,"÷",{"$f":"Input!F61","v":20},"years useful life"]
[null,null,null,null,null,"=",{"$f":"((G161-G162)/G163)","v":360}]
[]
[null,null,null,"3.02  Machinery & Equipment"]
[null,null,null,null,null,null,{"$f":"Input!C66","v":39000},"original cost"]
[null,null,null,null,null,"-",{"$f":"(Input!E66)*Input!C66","v":3900},"salvage value"]
[null,null,null,null,null,"÷",{"$f":"Input!F66","v":15},"years useful life"]
[null,null,null,null,null,"=",{"$f":"((G167-G168)/G169)","v":2340}]
[null,null,null,null,null,null,null,""]
[null,null,"4.  Investment",null,null,null,"Original Cost + Salvage Value x Investment Rate"]
[null,null,null,null,null,null,null,2]
[null,null,null,"4.01  Buildings"]
[null,null,null,null,null,null,{"$f":"G161","v":8000},"original cost"]
[null,null,null,null,null,"+",{"$f":"G162","v":800},"salvage value"]
[null,null,null,null,null,"÷",2,"average"]
[null,null,null,null,null,"x",{"$f":"Input!D54","v":2.5},"% investment rate"]
[null,null,null,null,null,"=",{"$f":"(((G175+G176)/G177)*(G178/100))","v":110}]
[]
[null,null,null,"4.02  Machinery & Equipment"]
[null,null,null,null,null,null,{"$f":"G167","v":39000},"original cost"]
[null,null,null,null,null,"+",{"$f":"G168","v":3900},"salvage value"]
[null,null,null,null,null,"÷",2,"average"]
[null,null,null,null,null,"x",{"$f":"Input!D54","v":2.5},"% investment rate"]
[null,null,null,null,null,"=",{"$f":"(((G182+G183)/G184)*(G185/100))","v":536.25}]
[]
[null,null,null,"4.03  Land"]
[null,null,null,null,null,null,{"$f":"Input!C70","v":10000},"land"]
[null,null,null,null,null,"x",{"$f":"Input!D54","v":2.5},"% investment rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G189*(G190/100))","v":250}]
[]
[null,"C. Labour"]
[null,null,null,"    Soybean oil"]
[null,null,null,null,null,null,{"$f":"Input!D36","v":0.05}," Employees per shift "]
[null,null,null,null,null,"x",{"$f":"Input!D34","v":155}," Days per year"]
[null,null,null,null,null,"x",{"$f":"Input!D35","v":24}," Hours operation per day"]
[null,null,null,null,null,"x",{"$f":"Input!D37","v":20}," Labour Rate per hour"]
[null,null,null,null,"   Total","=",{"$f":"SUM(G195*G196*G197*G198)","v":3720},"Soybean oil Labour Cost"]
[null,null,null,null,null,null,{"$f":"SUM((Input!D34*Input!D35)*Input!D36)/(40*48)","v":9.6875000000000003E-2},"Full time job positions"]
[null,null,null,"    Biodiesel"]
[null,null,null,null,null,null,{"$f":"Input!D17","v":0.25}," Employees per shift "]
[null,null,null,null,null,"x",{"$f":"Input!D15","v":65}," Days per year"]
[null,null,null,null,null,"x",{"$f":"Input!D16","v":8}," Hours operation per day"]
[null,null,null,null,null,"x",{"$f":"Input!D18","v":20}," Labour Rate per hour"]
[null,null,null,null,"   Total","=",{"$f":"SUM(G202*G203*G204*G205)","v":2600},"Biodiesel Labour Cost"]
[null,null,null,null,null,null,{"$f":"SUM((Input!D15*Input!D16)*Input!D17)/(40*48)","v":6.7708333333333329E-2},"Full time job positions"]
[]
[null,null,null,"Total",null,"=",{"$f":"G206+G199","v":6320},"Labour"]
[null,null,null,"Total",null,"=",{"$f":"SUM(G207+G200)","v":0.16458333333333333},"Full time job positions"]
[]
[null,null,"5.  Value"]
[null,null,null,"5.01  Estimated On-Farm Biodiesel value"]
[null,null,null,null,null,null,{"$f":"Input!D26","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"x",{"$f":"SUM(1000*Input!D14)","v":15000},"Biodiesel Plant Capacity - litres"]
[null,null,null,null,"Total ","=",{"$f":"G215*G214","v":18000},"Biodiesel value"]
[]
[null,null,null,"5.02  Estimated Increased Fuel Efficiency value"]
[null,null,null,null,null,null,{"$f":"SUM(1*(1-(Input!D28/100)))*(1*(1-(Input!D27/100)))","v":0},{"$f":"\"Diesel fuel used - portion of B\"&Input!D27&\" blend\"","v":"Diesel fuel used - portion of B100 blend"}]
[null,null,null,null,null,"x",{"$f":"Input!D26","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"=",{"$f":"SUM(G219*G220)","v":0},{"$f":"\"Diesel fuel value - portion of B\"&Input!D27&\" blend\"","v":"Diesel fuel value - portion of B100 blend"}]
[]
[null,null,null,null,null,null,{"$f":"Input!D26","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"-",{"$f":"G221","v":0},{"$f":"H221","v":"Diesel fuel value - portion of B100 blend"}]
[null,null,null,null,null,"=",{"$f":"SUM(G223-G224)","v":1.2},{"$f":"\"Biodiesel fuel value - portion of B\"&Input!D27&\" blend\"","v":"Biodiesel fuel value - portion of B100 blend"}]
[null,null,null,null,null,"÷",{"$f":"SUM(1*(1-(Input!D28/100)))*(1*((Input!D27/100)))","v":0.98499999999999999},{"$f":"\"Biodiesel fuel used - portion of B\"&Input!D27&\" blend\"","v":"Biodiesel fuel used - portion of B100 blend"}]
[null,null,null,null,null,null,{"$f":"SUM(G225/G226)","v":1.2182741116751268},"Total Relative biodiesel value"]
[null,null,null,null,null,"-",{"$f":"Input!D26","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"=",{"$f":"SUM(G227-G228)","v":1.8274111675126825E-2},"Balance - Relative biodiesel value"]
[null,null,null,null,null,"x",{"$f":"SUM(1000*Input!D14)","v":15000},"Biodiesel Plant Capacity - litres"]
[null,null,null,null,"Total ","=",{"$f":"G230*G229","v":274.11167512690236},"Increased Fuel Efficiency value"]
[]
[null,null,null,"5.03  Glycerol Sales"]
[null,null,null,null,null,null,{"$f":"SUM((Input!D14*1000)*0.0935884)/1000","v":1.403826},"Tonnes glycerol produced"]
[null,null,null,null,null,"x",{"$f":"Input!D25","v":180},"glycerol per tonne"]
[null,null,null,null,"Total ","=",{"$f":"G235*G234","v":252.68868000000001},"Glycerol"]
[]
[null,"For further information contact:"]
[]
[]
[null,"Prepared by:",null,null,null,null,null,"Adapted for Ontario by:"]
[]
[null,"Roy Arnott, P.Ag.",null,null,null,null,null,"Kevin McKague, P.Eng."]
[null,"Farm Management Specialist ",null,null,null,null,null,"Ontario Ministry of Agriculture, Food and Rural Affairs"]
[null,"Manitoba Agriculture, Food and Rural Initiatives",null,null,null,null,null,"Woodstock, ON  519-835-6078"]
[null,"Killarney GO Centre  204-523-6424",null,null,null,null,null,"email: kevin.mckague@ontario.ca"]
[]
[]
[null,"end of worksheet"]