{"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,"Biodiesel Production Costs - Farm Fuel"]
[null,{"$f":"\"Based on \"&Input!D14&\",000 Litres Used Vegetable Oil\"","v":"Based on 15,000 Litres Used Vegetable Oil"}]
[]
[]
[]
[]
[]
[]
[]
[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 supplying used vegetable oils as the oil feedstock.  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,"End of worksheet"]

{"sheet":"Input","index":1,"n_rows":69,"n_cols":7,"rows_kept":69,"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 feedstock is valued at fair market price."]
[null,"4.  Feedstock cost (used vegetable oil) does not include transportation "]
[null,"     costs to facility."]
[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,1.05," litres"]
[null," Methanol",null,6950," / tonne"]
[null," Methanol recovery",null,25,"%"]
[null," Catalyst - potassium hydroxide",null,12350," / tonne"]
[null,"Percent increase in Catalyst Required for FFAs",null,100,"%"]
[]
[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,"Used Vegetable Oil Supply"]
[null,"Used vegetable oil cost",null,500," / tonne"]
[null,"Average load size per oil pick-up",null,2200,"Litres"]
[null,"Average distance per oil pick-up",null,200,"kilometres"]
[null,"Trucking cost - 1 tonne with trailer",null,0.5," / km"]
[null," Labour rate",null,20," / hour"]
[null," Used oil bulk density",null,0.91500000000000004," kg / L"]
[]
[null,"Other Operating Costs"]
[null," Hydro",null,0.15," / kWhr"]
[null," Maintenance",null,2.5,"%"]
[null," Waste/washwater disposal",null,0.15," / 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,"    Waste oil processing",2500,null,0.1,20,"years"]
[null,"   Total ",{"$f":"SUM(C52:C53)","v":5500},null,{"$f":"AVERAGE(E52:E53)","v":0.1},{"$f":"AVERAGE(F52:F53)","v":20},"years"]
[null,null,null,null,null,null,""]
[null,"  Machinery & Equipment"]
[null,"    Biodiesel plant",3000,null,0.1,10,"years"]
[null,"    Waste oil filtering",2500,null,0.1,10,"years"]
[null,"    Total ",{"$f":"SUM(C57:C58)","v":5500},null,{"$f":"AVERAGE(E57:E58)","v":0.1},{"$f":"AVERAGE(F57:F58)","v":10},"years"]
[]
[null,"    Total Bldg., Mach. & Equip ",{"$f":"C54+C59","v":11000}]
[]
[null,"    Total Land Value",10000]
[]
[null,"    Total Capital Investment",{"$f":"C61+C63","v":21000}]
[]
[]
[]
[null,"end of worksheet"]

{"sheet":"Summary","index":2,"n_rows":63,"n_cols":5,"rows_kept":63,"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 of Used Vegetable Oil\"","v":"Based on 15,000 Litres of Used Vegetable Oil"}]
[]
[]
[null,"A.  Operating Costs","Cost/Litre","Total Cost","Your Actual Cost"]
[null,"1.  Input Costs"]
[null,"    1.01   Feedstock - used vegetable oil",{"$f":"SUM(D8/(Input!D14*1000))","v":0.52704166666666663},{"$f":"Details!G40","v":7905.625}]
[null,"    1.02   Methanol",{"$f":"SUM(D9/(Input!D14*1000))","v":1.1017400625},{"$f":"Details!G50","v":16526.100937499999}]
[null,"    1.03   Catalyst",{"$f":"SUM(D10/(Input!D14*1000))","v":0.38467181025000002},{"$f":"Details!G62","v":5770.0771537500004}]
[null,"Subtotal Input Cost",{"$f":"C8+C9+C10","v":2.0134535394166666},{"$f":"SUM(D8:D10)","v":30201.80309125}]
[]
[null,"2.  Other Operating Costs",""]
[null,"    2.01   Hydro",{"$f":"SUM(D14/(Input!D14*1000))","v":9.9000000000000008E-3},{"$f":"Details!G69","v":148.5}]
[null,"    2.02   Maintenance",{"$f":"SUM(D15/(Input!D14*1000))","v":1.8333333333333333E-2},{"$f":"Details!G76","v":275}]
[null,"    2.03   Waste/washwater disposal",{"$f":"SUM(D16/(Input!D14*1000))","v":0.15},{"$f":"Details!G79","v":2250}]
[null,"    2.04   Ontario Fuel Tax submission",{"$f":"SUM(D17/(Input!D14*1000))","v":0},{"$f":"Details!G80","v":0}]
[null,"    2.05   Misc. administration",{"$f":"SUM(D18/(Input!D14*1000))","v":0},{"$f":"Details!G81","v":0}]
[null,"    2.06   Insurance",{"$f":"SUM(D19/(Input!D14*1000))","v":3.6666666666666666E-3},{"$f":"Details!G88","v":55}]
[null,"    2.07   Property taxes",{"$f":"SUM(D20/(Input!D14*1000))","v":5.1666666666666666E-3},{"$f":"Details!G95","v":77.5}]
[null,"Subtotal Operating Costs",{"$f":"SUM(C14:C20)","v":0.18706666666666666},{"$f":"SUM(D14:D20)","v":2806}]
[null,"    2.08   Operating interest",{"$f":"SUM(D22/(Input!D14*1000))","v":3.7333333333333333E-3},{"$f":"ROUND(Details!G103,0)","v":56}]
[null,"Total Operating Costs",{"$f":"C21+C22+C11","v":2.2042535394166665},{"$f":"SUM(D21:D22)+D11","v":33063.803091249996}]
[]
[null,"3.  Depreciation"]
[null,"    3.01   Buildings",{"$f":"SUM(D26/(Input!D14*1000))","v":1.6500000000000001E-2},{"$f":"Details!G132","v":247.5}]
[null,"    3.02   Machinery and equipment",{"$f":"SUM(D27/(Input!D14*1000))","v":3.3000000000000002E-2},{"$f":"Details!G138","v":495}]
[]
[null,"4.  Investment","",""]
[null,"    4.01   Buildings",{"$f":"SUM(D30/(Input!D14*1000))","v":5.0416666666666665E-3},{"$f":"Details!G147","v":75.625}]
[null,"    4.02   Machinery and equipment",{"$f":"SUM(D31/(Input!D14*1000))","v":5.0416666666666665E-3},{"$f":"Details!G154","v":75.625}]
[null,"    4.03   Land",{"$f":"SUM(D32/(Input!D14*1000))","v":1.6666666666666666E-2},{"$f":"Details!G159","v":250}]
[null,"Total Fixed Costs",{"$f":"SUM(C26:C32)","v":7.6249999999999998E-2},{"$f":"SUM(D26:D32)","v":1143.75}]
[null,"Total Operating and Fixed Costs",{"$f":"C23+C33","v":2.2805035394166664},{"$f":"D23+D33","v":34207.553091249996}]
[]
[null,"C.  Labour",{"$f":"SUM(D36/(Input!D14*1000))","v":0.21274074074074076},{"$f":"Details!G176","v":3191.1111111111113}]
[null,"Total Cost of Production",{"$f":"C34+C36","v":2.4932442801574073},{"$f":"D36+D34","v":37398.664202361106}]
[]
[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!G183","v":18000}]
[null,"    5.02   Estimated increased fuel efficiency value",{"$f":"SUM(D42/(Input!D14*1000))","v":1.8274111675126825E-2},{"$f":"Details!G198","v":274.11167512690236}]
[null,"    5.03   Glycerol sales",{"$f":"SUM(D43/(Input!D14*1000))","v":1.6845912000000001E-2},{"$f":"Details!G203","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":-1.2581242564822805},{"$f":"D44-D37","v":-18871.863847234203}]
[]
[null,"Breakeven price"," $/Litre"]
[null,"        A. Operating Costs",{"$f":"SUM((D23-(D44-D41))/(Input!D14*1000))","v":2.1691335157415397}]
[null,"        B. Operating and labour costs",{"$f":"SUM(((D23+D36)-(D44-D41))/(Input!D14*1000))","v":2.3818742564822801}]
[null,"        C. Operating and fixed costs",{"$f":"SUM((D34-(D44-D41))/(Input!D14*1000))","v":2.2453835157415392}]
[null,"        D. Operating, fixed and labour costs",{"$f":"SUM(((D34+D36)-(D44-D41))/(Input!D14*1000))","v":2.4581242564822801}]
[]
[]
[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,"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":216,"n_cols":9,"rows_kept":216,"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."]
[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 - used vegetable oil"]
[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":1.05},"oil required per litre biodiesel"]
[null,null,null,null,null,"=",{"$f":"SUM(G17*G18)","v":15750},"Litres vegetable oil required"]
[null,null,null,null,null,"x",{"$f":"Input!D37","v":0.91500000000000004},"used vegetable oil bulk density kg/L"]
[null,null,null,null,null,"÷",1000,"kg per tonne"]
[null,null,null,null,null,"=",{"$f":"SUM(G19*G20)/G21","v":14.411250000000001},"Tonnes of used vegetable oil"]
[]
[null,null,null,null,null,null,{"$f":"G22","v":14.411250000000001},"Tonnes of vegetable oil"]
[null,null,null,null,null,"x",{"$f":"Input!D32","v":500},"Used vegetable oil per tonne"]
[null,null,null,null,null,"=",{"$f":"SUM(G24*G25)","v":7205.625},"Used vegetable oil cost"]
[]
[null,null,null,null,null,null,{"$f":"Input!D33","v":2200},"Litres average load size per pickup"]
[]
[null,null,null,null,null,null,{"$f":"G19","v":15750},"Litres vegetable oil required "]
[null,null,null,null,null,"÷",{"$f":"G28","v":2200},"Litres load size per pickup "]
[null,null,null,null,null,"=",{"$f":"ROUND(G30/G31,0)","v":7},"Total number of loads"]
[null,null,null,null,null,"x",{"$f":"Input!D34","v":200},"Average km per pickup"]
[null,null,null,null,null,"=",{"$f":"SUM(G32*G33)","v":1400},"Number of km"]
[null,null,null,null,null,"x",{"$f":"Input!D35","v":0.5},"Trucking cost per km"]
[null,null,null,null,null,"=",{"$f":"SUM(G34*G35)","v":700},"Trucking cost "]
[]
[null,null,null,null,null,null,{"$f":"G26","v":7205.625},{"$f":"H26","v":"Used vegetable oil cost"}]
[null,null,null,null,null,"-",{"$f":"G36","v":700},{"$f":"H36","v":"Trucking cost "}]
[null,null,null,null,"Total ","=",{"$f":"SUM(G38+G39)","v":7905.625},"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":1.05},"oil required per litre biodiesel"]
[null,null,null,null,null,"x",{"$f":"Input!D37","v":0.91500000000000004},"used 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":"(G43*G44*G45*G46*(1-G47)*G49)/G48","v":16526.100937499999},"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":1.05},"oil required per litre biodiesel"]
[null,null,null,null,null,"x",{"$f":"Input!D37","v":0.91500000000000004},"Used 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,"+",{"$f":"G57*(Input!D24/100)","v":16.21},"Additional catalyst to adjust for FFAs (kg/T)"]
[null,null,null,null,null,"=",{"$f":"G57+G58","v":32.42},"Total 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(G53*G54*G55/G56*G59/G60*G61)","v":5770.0771537500004},"Catalyst "]
[]
[null,null,"2.  Other Operating Costs"]
[null,null,null,"2.01  Hydro"]
[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!D40","v":0.15},"Hydro rate - kWhr"]
[null,null,null,null,"Total ","=",{"$f":"SUM((G66*G67*G68))","v":148.5},"Hydro - biodiesel"]
[]
[null,null,null,"2.02  Maintenance"]
[null,null,null,null,null,null,{"$f":"Input!C54","v":5500},"capital cost - buildings"]
[null,null,null,null,null,"+",{"$f":"Input!C59","v":5500},"capital cost - equipment"]
[null,null,null,null,null,"=",{"$f":"SUM(G72:G73)","v":11000},"Total bldg. & equipment"]
[null,null,null,null,null,"x",{"$f":"Input!D41/100","v":2.5000000000000001E-2},"Maintenance rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G74*G75)","v":275},"Total Maintenance"]
[]
[null,null,null,"2.03 - 2.05   Misc. Administration"]
[null,null,null,null,null,null,{"$f":"Input!D14*1000*Input!D42","v":2250},"Waste/washwater disposal"]
[null,null,null,null,null,null,{"$f":"Input!D14*1000 * Input!D43","v":0},"Ontario Fuel Tax Submission"]
[null,null,null,null,null,null,{"$f":"Input!D44","v":0},"Misc. Administration "]
[]
[null,null,null,"2.06  Insurance"]
[null,null,null,null,null,null,{"$f":"Input!C54","v":5500},"capital cost - buildings"]
[null,null,null,null,null,"+",{"$f":"Input!C59","v":5500},"capital cost - equipment"]
[null,null,null,null,null,"=",{"$f":"SUM(G84:G85)","v":11000},"Total bldg. & equipment"]
[null,null,null,null,null,"x",{"$f":"Input!D45/100","v":5.0000000000000001E-3},"Insurance rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G86*G87)","v":55},"Total Insurance"]
[]
[null,null,null,"2.07 Property Taxes"]
[null,null,null,null,null,null,{"$f":"Input!C54","v":5500},"capital cost - buildings"]
[null,null,null,null,null,"+",{"$f":"Input!C63","v":10000},"capital cost - land"]
[null,null,null,null,null,"=",{"$f":"SUM(G91:G92)","v":15500},"Total bldg. & land"]
[null,null,null,null,null,"x",{"$f":"Input!D46/100","v":5.0000000000000001E-3},"Property tax rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G93*G94)","v":77.5},"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":2806},"subtotal operating costs"]
[null,null,null,null,null,"÷",2,"average"]
[null,null,null,null,null,"x",{"$f":"Input!D48","v":4},"% operating interest rate"]
[null,null,null,null,null,"=",{"$f":"ROUND((G100/G101)*(G102),2)/100","v":56.12},"Operating Interest"]
[]
[null,null,null,null,null,null,"Capital Costs"]
[]
[null,null,"  Buildings"]
[null,null,"        Biodiesel Plant",null,null,null,null,{"$f":"Input!C52","v":3000}]
[null,null,"        Waste oil facility",null,null,null,null,{"$f":"Input!C53","v":2500}]
[null,null,"         Total Building Cost",null,null,null,null,{"$f":"SUM(H108:H109)","v":5500}]
[]
[null,null,"  Machinery & Equipment"]
[null,null,"        Biodiesel Plant",null,null,null,null,{"$f":"Input!C57","v":3000}]
[null,null,"        Waste oil filtering",null,null,null,null,{"$f":"Input!C58","v":2500}]
[null,null,"         Total Machinery & Equipment Cost",null,null,null,null,{"$f":"SUM(H113:H114)","v":5500}]
[]
[null,null,"Total Bldg., Mach. & Equip.",null,null,null,null,{"$f":"H110+H115","v":11000}]
[]
[null,null,"Total Land Value",null,null,null,null,{"$f":"Input!C63","v":10000}]
[]
[null,null,"Total Capital Investment",null,null,null,null,{"$f":"H117+H119","v":21000}]
[]
[]
[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!C54","v":5500},"original cost"]
[null,null,null,null,null,"-",{"$f":"(Input!E54)*Input!C54","v":550},"salvage value"]
[null,null,null,null,null,"÷",{"$f":"Input!F54","v":20},"years useful life"]
[null,null,null,null,null,"=",{"$f":"((G129-G130)/G131)","v":247.5}]
[]
[null,null,null,"3.02  Machinery & Equipment"]
[null,null,null,null,null,null,{"$f":"Input!C59","v":5500},"original cost"]
[null,null,null,null,null,"-",{"$f":"(Input!E59)*Input!C59","v":550},"salvage value"]
[null,null,null,null,null,"÷",{"$f":"Input!F59","v":10},"years useful life"]
[null,null,null,null,null,"=",{"$f":"((G135-G136)/G137)","v":495}]
[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":"G129","v":5500},"original cost"]
[null,null,null,null,null,"+",{"$f":"G130","v":550},"salvage value"]
[null,null,null,null,null,"÷",2,"average"]
[null,null,null,null,null,"x",{"$f":"Input!D47","v":2.5},"% investment rate"]
[null,null,null,null,null,"=",{"$f":"(((G143+G144)/G145)*(G146/100))","v":75.625}]
[]
[null,null,null,"4.02  Machinery & Equipment"]
[null,null,null,null,null,null,{"$f":"G135","v":5500},"original cost"]
[null,null,null,null,null,"+",{"$f":"G136","v":550},"salvage value"]
[null,null,null,null,null,"÷",2,"average"]
[null,null,null,null,null,"x",{"$f":"Input!D47","v":2.5},"% investment rate"]
[null,null,null,null,null,"=",{"$f":"(((G150+G151)/G152)*(G153/100))","v":75.625}]
[]
[null,null,null,"4.03  Land"]
[null,null,null,null,null,null,{"$f":"Input!C63","v":10000},"land"]
[null,null,null,null,null,"x",{"$f":"Input!D47","v":2.5},"% investment rate"]
[null,null,null,null,null,"=",{"$f":"SUM(G157*(G158/100))","v":250}]
[]
[null,"C. Labour"]
[null,null,null,"    Used vegetable oil"]
[null,null,null,null,null,"x",{"$f":"G32","v":7},"Total number of loads"]
[null,null,null,null,null,"x",{"$f":"SUM(G33/90)+2","v":4.2222222222222223}," Hours per load"]
[null,null,null,null,null,"x",{"$f":"Input!D36","v":20}," Labour Rate per hour"]
[null,null,null,null,"   Total","=",{"$f":"SUM(G163*G164*G165)","v":591.11111111111109},"Used Vegetable Oil Labour Cost"]
[null,null,null,null,null,null,{"$f":"SUM(G163*G164)/(40*48)","v":1.539351851851852E-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(G169*G170*G171*G172)","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":"G173+G166","v":3191.1111111111113},"Labour"]
[null,null,null,"Total",null,"=",{"$f":"SUM(G174+G167)","v":8.3101851851851843E-2},"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!D27","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":"G182*G181","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!D29/100)))*(1*(1-(Input!D28/100)))","v":0},{"$f":"\"Diesel fuel used - portion of B\"&Input!D28&\" blend\"","v":"Diesel fuel used - portion of B100 blend"}]
[null,null,null,null,null,"x",{"$f":"Input!D27","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"=",{"$f":"SUM(G186*G187)","v":0},{"$f":"\"Diesel fuel value - portion of B\"&Input!D28&\" blend\"","v":"Diesel fuel value - portion of B100 blend"}]
[]
[null,null,null,null,null,null,{"$f":"Input!D27","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"-",{"$f":"G188","v":0},{"$f":"H188","v":"Diesel fuel value - portion of B100 blend"}]
[null,null,null,null,null,"=",{"$f":"SUM(G190-G191)","v":1.2},{"$f":"\"Biodiesel fuel value - portion of B\"&Input!D28&\" blend\"","v":"Biodiesel fuel value - portion of B100 blend"}]
[null,null,null,null,null,"÷",{"$f":"SUM(1*(1-(Input!D29/100)))*(1*((Input!D28/100)))","v":0.98499999999999999},{"$f":"\"Biodiesel fuel used - portion of B\"&Input!D28&\" blend\"","v":"Biodiesel fuel used - portion of B100 blend"}]
[null,null,null,null,null,null,{"$f":"SUM(G192/G193)","v":1.2182741116751268},"Total Relative biodiesel value"]
[null,null,null,null,null,"-",{"$f":"Input!D27","v":1.2},"Diesel (coloured) farm fuel - #1 ULSD"]
[null,null,null,null,null,"=",{"$f":"SUM(G194-G195)","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":"G197*G196","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!D26","v":180},"glycerol per tonne"]
[null,null,null,null,"Total ","=",{"$f":"G202*G201","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"]