{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Assumptions","Weaner-Summary","Risk Analysis","Weanling Input","Feed-Cost","Feed-Summary","Weaner-Worksheet","Ingredient-Summary"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":25,"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":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,53,8],[5,1,5,7],[4,1,4,7],[63,1,63,7],[54,1,55,7],[6,1,6,7],[14,1,23,8],[25,1,34,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
[null,"     Guidelines For Estimating"]
[null,"Weaner Pig (Nursery) Costs 6 to 26 kg"]
[null,{"$f":"\" Based on marketing \"&FIXED('Weanling Input'!F15,0)&\" pigs\"","v":" Based on marketing 35,512 pigs"}]
[]
[]
[null,null,null,null,null,"Date:","April, 2023"]
[]
[]
[]
[]
[null,"This guide is designed to provide you with planning information and a format for calculating costs of production of a swine weaner 6 to 26 kg enterprise  in Manitoba.  This type of  operation is intended to represent the second stage, or nursery, of a three stage pork system.  General Manitoba Agriculture recommendations are assumed in using feed and veterinary inputs. These figures provide an economic evaluation of the livestock and estimated prices required to cover all costs.  Costs include labour, investment and depreciation, but do not include management costs, nor do they necessarily represent the average cost of production in Manitoba."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"These budgets may be adjusted by putting in your own figures.  As a producer you are encouraged to calculate your own costs of production. The assumptions on which the costs are based are outlined in the supporting pages. These assumptions were arrived at using the breeding stock, management practices, and facilities seen in modern, well managed swine operations of comparable size in Manitoba. Productivity and performance assumptions are based on information collected by department specialists, feed companies and other organizations. Where individual herd productivity and performance levels differ from those listed, adjustments will be required. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This tool is available as an Excel worksheet at: "]
[]
[]
[]
[]
[]
[]
[]
[null,"                                                                                          is also available to help"]
[null,"determine machinery costs."]
[]
[]
[]
[]
[]
[]
[null,"Note: This budget is only a guide and is not intended as an in-depth study of the cost of production of this industry. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact a Farm Management Specialist."]

{"sheet":"Assumptions","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,8],[4,1,5,8],[7,1,9,8],[22,1,26,8],[30,1,30,8],[13,1,13,8],[11,1,12,8],[17,1,20,8],[28,1,28,8]]}
[]
["Weaner Pig (Nursery) Costs 6 to 26 kg Cost of Production"]
[]
[]
[null,"The following farrow wean cost of production budget is based on the assumption that all feed is purchased or home mixed."]
[]
[]
[null,{"$f":"\"The budget includes a land investment cost for \"&'Weanling Input'!G141&\" acres, with \"&'Weanling Input'!G142&\" acres rented out at $\"&'Weanling Input'!G143&\" per acre, of the estimated \"&ROUND(((('Weaner-Worksheet'!D108*'Weanling Input'!F121)/(40.768*2))*2.4709661),0)&\" to \"&ROUND(((('Weaner-Worksheet'!D108*'Weanling Input'!F121)/(26.362*2))*2.4709661),0)&\" acres of total landbase that would be required for this size of livestock operation.  This land base falls within the 2XP2O5 application rate, soil phosphorus levels permitting.\"","v":"The budget includes a land investment cost for 40 acres, with 0 acres rented out at $80 per acre, of the estimated 81 to 126 acres of total landbase that would be required for this size of livestock operation.  This land base falls within the 2XP2O5 application rate, soil phosphorus levels permitting."}]
[]
[]
[]
[null,"If developing a cost of production budget to include home mixed rations the following items should be added to the budget:"]
[]
[null,"     - additional equipment costs associated with a mix mill; "]
[null,"     - additional bins for different ingredients;"]
[null,"     - additional labour for feed preparation. "]
[]
[null,"The rations illustrated in this budget are examples only. Individual farm conditions should be taken into account when formulating the diets. Producers need to know what the feed intakes of their animals are. Please consult with a nutritionist for diet formulations suggestions."]
[]
[]
[]
[]
[null,"The Manitoba pork production industry profile is changing and this budget was specifically designed to address the need of producers who may want to analyze the cost of starting up or switching to a swine nursery 6 to 26 kg operation. Several companies are offering contracts with varying levels of guarantees. Producers need to accurately calculate their costs before they can properly make a decision."]

{"sheet":"Weaner-Summary","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,0,65,10],[2,4,2,5],[2,7,2,8],[0,0,0,10],[43,0,43,10]]}
[{"$f":"\"Weaner Pig (Nursery) 6 to 26 kg Summary - \"&Introduction!G10","v":"Weaner Pig (Nursery) 6 to 26 kg Summary - April, 2023"}]
[]
[null,null,null,null,"Purchased Feed",null,null,"Home-Mixed Feed"]
[null,null,null,null,"$/Pig","Total",null,"$/Pig","Total"]
["A. Operating Costs",null,null,null,"Sold","Cost",null,"Sold","Cost",null,"Your Cost"]
["1.","Feed Costs:"]
[null,1.01,"Pre Starter 1",null,{"$f":"'Weaner-Worksheet'!D12","v":1.6},{"$f":"ROUND(E7*'Weanling Input'!$F$15,0)","v":56819},null,{"$f":"'Weaner-Worksheet'!D17","v":0.95},{"$f":"ROUND(H7*'Weanling Input'!$F$15,0)","v":33736}]
[null,1.02,"Pre Starter 2",null,{"$f":"'Weaner-Worksheet'!D23","v":6.45},{"$f":"ROUND(E8*'Weanling Input'!$F$15,0)","v":229052},null,{"$f":"'Weaner-Worksheet'!D28","v":3.49},{"$f":"ROUND(H8*'Weanling Input'!$F$15,0)","v":123937}]
[null,1.03,"Starter 1",null,{"$f":"'Weaner-Worksheet'!D34","v":14.27},{"$f":"ROUND(E9*'Weanling Input'!$F$15,0)","v":506756},null,{"$f":"'Weaner-Worksheet'!D39","v":8.4499999999999993},{"$f":"ROUND(H9*'Weanling Input'!$F$15,0)","v":300076}]
[null,1.04,"Starter 2",null,{"$f":"'Weaner-Worksheet'!D45","v":19.41},{"$f":"ROUND(E10*'Weanling Input'!$F$15,0)","v":689288},null,{"$f":"'Weaner-Worksheet'!D50","v":13.82},{"$f":"ROUND(H10*'Weanling Input'!$F$15,0)","v":490776}]
["Total Feed Cost",null,null,null,{"$f":"SUM(E7:E10)","v":41.730000000000004},{"$f":"SUM(F7:F10)","v":1481915},null,{"$f":"SUM(H7:H10)","v":26.71},{"$f":"SUM(I7:I10)","v":948525}]
[null,"","",null,""]
["2.","Other Operating Costs:",null,null,""]
[null,"2.01","Weanling cost",null,{"$f":"'Weaner-Worksheet'!D56","v":47.85},{"$f":"ROUND(E14*'Weanling Input'!$F$15,0)","v":1699249},null,{"$f":"E14","v":47.85},{"$f":"ROUND(H14*'Weanling Input'!$F$15,0)","v":1699249}]
["",2.02,"Veterinary Medicine & Supplies",null,{"$f":"'Weaner-Worksheet'!D62","v":2.81595},{"$f":"ROUND(E15*'Weanling Input'!$F$15,0)","v":100000},null,{"$f":"E15","v":2.81595},{"$f":"ROUND(H15*'Weanling Input'!$F$15,0)","v":100000}]
["",2.0299999999999998,"Maintenance & Repairs",null,{"$f":"'Weaner-Worksheet'!D68","v":0.18},{"$f":"ROUND(E16*'Weanling Input'!$F$15,0)","v":6392},null,0.18,{"$f":"ROUND(H16*'Weanling Input'!$F$15,0)","v":6392}]
["",2.04,"Hydro & Propane",null,{"$f":"'Weaner-Worksheet'!D74","v":1.5810999999999999},{"$f":"ROUND(E17*'Weanling Input'!$F$15,0)","v":56148},null,1.5810999999999999,{"$f":"ROUND(H17*'Weanling Input'!$F$15,0)","v":56148}]
["",2.0499999999999998,"Insurance",null,{"$f":"'Weaner-Worksheet'!D94","v":0.33999999999999997},{"$f":"ROUND(E18*'Weanling Input'!$F$15,0)","v":12074},null,0.33999999999999997,{"$f":"ROUND(H18*'Weanling Input'!$F$15,0)","v":12074}]
["",2.06,"Manure Costs",null,{"$f":"'Weaner-Worksheet'!D139","v":0.38404995383940643},{"$f":"ROUND(E19*'Weanling Input'!$F$15,0)","v":13638},null,0.38404995383940643,{"$f":"ROUND(H19*'Weanling Input'!$F$15,0)","v":13638}]
["",2.0699999999999998,"Office Supplies",null,{"$f":"'Weaner-Worksheet'!D145","v":4.3929999999999997E-2},{"$f":"ROUND(E20*'Weanling Input'!$F$15,0)","v":1560},null,4.3929999999999997E-2,{"$f":"ROUND(H20*'Weanling Input'!$F$15,0)","v":1560}]
["",2.08,"Levy, Marketing & Transportation",null,{"$f":"'Weaner-Worksheet'!D151","v":3.7399999999999998},{"$f":"ROUND(E21*'Weanling Input'!$F$15,0)","v":132815},null,3.7399999999999998,{"$f":"ROUND(H21*'Weanling Input'!$F$15,0)","v":132815}]
[null,2.09,"Property Taxes",null,{"$f":"'Weaner-Worksheet'!D156","v":0.28159000000000001},{"$f":"ROUND(E22*'Weanling Input'!$F$15,0)","v":10000},null,0.28159000000000001,{"$f":"ROUND(H22*'Weanling Input'!$F$15,0)","v":10000}]
["Subtotal Operating Costs",null,null,null,{"$f":"SUM(E11:E22)","v":98.946619953839431},{"$f":"SUM(F11:F22)","v":3513791},null,{"$f":"SUM(H11:H22)","v":83.92661995383942},{"$f":"SUM(I11:I22)","v":2980401}]
["","2.10","Interest on Operating Cost",null,{"$f":"'Weaner-Worksheet'!D172","v":0.89},{"$f":"ROUND(E24*'Weanling Input'!$F$15,0)","v":31606},null,{"$f":"'Weaner-Worksheet'!D180","v":0.8},{"$f":"ROUND(H24*'Weanling Input'!$F$15,0)","v":28410}]
["Total Operating Costs",null,null,null,{"$f":"E23+E24","v":99.836619953839431},{"$f":"F23+F24","v":3545397},null,{"$f":"H23+H24","v":84.726619953839418},{"$f":"I23+I24","v":3008811}]
[null,"","",null,""]
["B. Fixed Costs",null,null,null,""]
["3.","Depreciation:",null,null,""]
["","3.01","Buildings and Manure Storage",null,{"$f":"'Weaner-Worksheet'!D192","v":0.72},{"$f":"ROUND(E29*'Weanling Input'!$F$15,0)","v":25569},null,{"$f":"'Weaner-Worksheet'!D198","v":0.76},{"$f":"ROUND(H29*'Weanling Input'!$F$15,0)","v":26989}]
["","3.02","Equipment",null,{"$f":"'Weaner-Worksheet'!D205","v":1.19},{"$f":"ROUND(E30*'Weanling Input'!$F$15,0)","v":42259},null,{"$f":"'Weaner-Worksheet'!D211","v":1.36},{"$f":"ROUND(H30*'Weanling Input'!$F$15,0)","v":48296}]
["","Total Depreciation Cost",null,null,{"$f":"E29+E30","v":1.91},{"$f":"ROUND(E31*'Weanling Input'!$F$15,0)","v":67828},null,{"$f":"H29+H30","v":2.12},{"$f":"ROUND(H31*'Weanling Input'!$F$15,0)","v":75285}]
["4.","Investment:",null,null,""]
[null,"4.01","Land Cost",null,{"$f":"'Weaner-Worksheet'!D221","v":0.11306037395809868},{"$f":"ROUND(E33*'Weanling Input'!$F$15,0)","v":4015},null,{"$f":"E33","v":0.11306037395809868},{"$f":"ROUND(H33*'Weanling Input'!$F$15,0)","v":4015}]
["",4.0199999999999996,"Buildings and Manure Storage",null,{"$f":"'Weaner-Worksheet'!D235","v":0.28999999999999998},{"$f":"ROUND(E34*'Weanling Input'!$F$15,0)","v":10298},null,{"$f":"'Weaner-Worksheet'!D242","v":0.31},{"$f":"ROUND(H34*'Weanling Input'!$F$15,0)","v":11009}]
["",4.03,"Equipment",null,{"$f":"'Weaner-Worksheet'!D250","v":0.2},{"$f":"ROUND(E35*'Weanling Input'!$F$15,0)","v":7102},null,{"$f":"'Weaner-Worksheet'!D257","v":0.22},{"$f":"ROUND(H35*'Weanling Input'!$F$15,0)","v":7813}]
["","Total Investment Cost",null,null,{"$f":"SUM(E33:E35)","v":0.60306037395809864},{"$f":"ROUND(E36*'Weanling Input'!$F$15,0)","v":21416},null,{"$f":"SUM(H33:H35)","v":0.64306037395809867},{"$f":"ROUND(H36*'Weanling Input'!$F$15,0)","v":22836}]
["Total Fixed Costs",null,null,null,{"$f":"E31+E36","v":2.5130603739580986},{"$f":"F31+F36","v":89244},null,{"$f":"H31+H36","v":2.7630603739580986},{"$f":"I31+I36","v":98121}]
[null,"","",null,""]
["C.  Labour",null,null,null,""]
[null,"Wages, benefits and hired manager",null,null,{"$f":"'Weaner-Worksheet'!D264","v":1.9},{"$f":"ROUND(E40*'Weanling Input'!$F$15,0)","v":67473},null,{"$f":"E40","v":1.9},{"$f":"ROUND(H40*'Weanling Input'!$F$15,0)","v":67473}]
[null,"",""]
["Total Cost of Production",null,null,null,{"$f":"E25+E37+E40","v":104.24968032779753},{"$f":"F25+F37+F40","v":3702114},null,{"$f":"H25+H37+H40","v":89.389680327797521},{"$f":"I25+I37+I40","v":3174405}]
[]
["Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null," Per Pig","Total",null," Per Pig","Total"]
[null,"Market Price per weanling",null,null,{"$f":"'Weanling Input'!F16","v":87},{"$f":"ROUND(E47*'Weanling Input'!$F$15,0)","v":3089544},null,{"$f":"E47","v":87},{"$f":"ROUND(H47*'Weanling Input'!$F$15,0)","v":3089544}]
[null,"Land rental per head sold",null,null,{"$f":"SUM('Weanling Input'!G142*'Weanling Input'!G143)/'Weanling Input'!F15","v":0},{"$f":"ROUND(E48*'Weanling Input'!$F$15,0)","v":0},null,{"$f":"E48","v":0},{"$f":"ROUND(H48*'Weanling Input'!$F$15,0)","v":0}]
[null,"Gross Revenue  / hog",null,null,{"$f":"SUM(E47:E48)","v":87},{"$f":"SUM(F47:F48)","v":3089544},null,{"$f":"SUM(H47:H48)","v":87},{"$f":"SUM(I47:I48)","v":3089544}]
[]
["Marginal Returns "]
[null,"Over Operating Costs",null,null,{"$f":"SUM(E49-E25)","v":-12.836619953839431},{"$f":"ROUND(E52*'Weanling Input'!$F$15,0)","v":-455854},null,{"$f":"SUM(H49-H25)","v":2.2733800461605824},{"$f":"ROUND(H52*'Weanling Input'!$F$15,0)","v":80732}]
[null,"Over Operating & Labour Costs",null,null,{"$f":"SUM(E49-E25-E40)","v":-14.736619953839432},{"$f":"ROUND(E53*'Weanling Input'!$F$15,0)","v":-523327},null,{"$f":"SUM(H49-H25-H40)","v":0.37338004616058251},{"$f":"ROUND(H53*'Weanling Input'!$F$15,0)","v":13259}]
[null,"Over Total Costs (Net Profit)",null,null,{"$f":"SUM(E49-E42)","v":-17.249680327797535},{"$f":"ROUND(E54*'Weanling Input'!$F$15,0)","v":-612571},null,{"$f":"SUM(H49-H42)","v":-2.3896803277975209},{"$f":"ROUND(H54*'Weanling Input'!$F$15,0)","v":-84862}]
[]
["Operating Expense Ratio",null,null,null,{"$f":"SUM(E25/E49)","v":1.1475473557912579},null,null,{"$f":"SUM(H25/H49)","v":0.97386919487171741}]
[]
["Breakeven Selling Price",null,null,null,"$/Pig",null,null,"$/Pig"]
[null,"Operating Costs",null,null,{"$f":"E25","v":99.836619953839431},null,null,{"$f":"H25","v":84.726619953839418}]
[null,"Operating & Labour Costs",null,null,{"$f":"E25+E40","v":101.73661995383944},null,null,{"$f":"H25+H40","v":86.626619953839423}]
[null,"Total Costs",null,null,{"$f":"E42","v":104.24968032779753},null,null,{"$f":"H42","v":89.389680327797521}]
[]
["Return On Assets (ROA)",null,null,null,{"$f":"SUM(((E54+E36+E24)*'Weanling Input'!$F$15)/(('Weanling Input'!$H$76-'Weanling Input'!$H$62-'Weanling Input'!$H$53)+(('Weanling Input'!F16/2)*'Weanling Input'!F10)))","v":-0.37268488597358873},null,null,{"$f":"SUM(((H54+H36+H24)*'Weanling Input'!$F$15)/(('Weanling Input'!$H$76)+(('Weanling Input'!F16/2)*'Weanling Input'!F10)))","v":-2.0926523780344597E-2}]
[]
["Note: This budget is only a guide and is not intended as an in depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user."]

{"sheet":"Risk Analysis","index":3,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,0,55,6],[0,0,0,7]]}
["Risk & Sensitivity Analysis"]
[]
[null,null,"Purchased Feed","Home-Mixed Feed"]
[null,null,"Per Pig","Per Pig"]
["A.  Operating Costs"]
[null,"Feed cost",{"$f":"'Weaner-Summary'!E11","v":41.730000000000004},{"$f":"'Weaner-Summary'!H11","v":26.71}]
[null,"Weanling cost",{"$f":"'Weanling Input'!F18","v":47.85},{"$f":"C7","v":47.85}]
[null,"Other Operating Costs",{"$f":"SUM('Weaner-Summary'!E25-'Risk Analysis'!C6-'Risk Analysis'!C7)","v":10.256619953839426},{"$f":"SUM('Weaner-Summary'!H25-'Risk Analysis'!D6-'Risk Analysis'!D7)","v":10.166619953839415}]
[null,"Subtotal",{"$f":"SUM(C6:C8)","v":99.836619953839431},{"$f":"SUM(D6:D8)","v":84.726619953839418}]
["B.  Fixed Costs",null,{"$f":"'Weaner-Summary'!E37","v":2.5130603739580986},{"$f":"'Weaner-Summary'!H37","v":2.7630603739580986}]
["C.  Labour",null,{"$f":"'Weaner-Summary'!E40","v":1.9},{"$f":"'Weaner-Summary'!H40","v":1.9}]
["Total Costs",null,{"$f":"SUM(C9:C11)","v":104.24968032779753},{"$f":"SUM(D9:D11)","v":89.389680327797521}]
[]
["Estimated Farmgate"]
[null,"Price ($ per weanling)",{"$f":"'Weanling Input'!F16","v":87},{"$f":"C15","v":87}]
[]
[]
[null,null,"Up","Down"]
[null,"Percent Market Price Variation",0.1,0.1]
[null,"Percent Feed Cost Variation",0.1,0.05]
[null,"Percent Weanling Cost Variation",0.05,0.05]
[]
[]
[null,"Higher Market Price",{"$f":"SUM(C15*(1+C19))","v":95.7},{"$f":"SUM(D15*(1+C19))","v":95.7}]
[null,"Lower Market Price",{"$f":"SUM(C15*(1-D19))","v":78.3},{"$f":"SUM(D15*(1-D19))","v":78.3}]
[null,"Higher Feed Cost",{"$f":"SUM(C6+(C6*C20))","v":45.903000000000006},{"$f":"SUM(D6+(D6*C20))","v":29.381}]
[null,"Lower Feed Cost",{"$f":"SUM(C6-(C6*D20))","v":39.643500000000003},{"$f":"SUM(D6-(D6*D20))","v":25.374500000000001}]
[null,"Higher Weanling Purchase Cost",{"$f":"SUM(C7*(1+C21))","v":50.242500000000007},{"$f":"SUM(D7*(1+C21))","v":50.242500000000007}]
[null,"Lower Weanling Purchase Cost",{"$f":"SUM(C7*(1-D21))","v":45.457499999999996},{"$f":"SUM(D7*(1-D21))","v":45.457499999999996}]
[]
[{"$f":"\"Higher Margin Scenario - Market Price Up \"&C19*100&\"%, Feed Price Down \"&D20*100&\"% and Weanling Purchase Cost Down \"&D21*100&\"%\"","v":"Higher Margin Scenario - Market Price Up 10%, Feed Price Down 5% and Weanling Purchase Cost Down 5%"}]
[null,"Operating Costs",{"$f":"SUM(C29+C27+C8)","v":95.357619953839418},{"$f":"SUM(D29+D27+D8)","v":80.998619953839409}]
[null,"Total Costs",{"$f":"C32+C11+C10","v":99.770680327797521},{"$f":"D32+D11+D10","v":85.661680327797512}]
[null,"Gross Revenue / hog",{"$f":"C24","v":95.7},{"$f":"D24","v":95.7}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C34-C32)","v":0.34238004616058504},{"$f":"SUM(D34-D32)","v":14.701380046160594}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C34-C32-C11)","v":-1.5576199538394149},{"$f":"SUM(D34-D32-D11)","v":12.801380046160594}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C34-C33)","v":-4.0706803277975183},{"$f":"SUM(D34-D33)","v":10.038319672202491}]
[null,"Operating Expense Ratio",{"$f":"SUM(C32/C34)","v":0.99642236106415272},{"$f":"SUM(D32/D34)","v":0.84638056378097604}]
[null,"Return on Asset (ROA)",{"$f":"SUM(((C38+'Weaner-Summary'!$H$36+'Weaner-Summary'!$H$24)*'Weanling Input'!$F$15)/(('Weanling Input'!$H$76-'Weanling Input'!$H$53-'Weanling Input'!$H$62)+((C34/2)*'Weanling Input'!$F$10)))","v":-6.1227569061262636E-2},{"$f":"SUM(((D38+'Weaner-Summary'!$H$36+'Weaner-Summary'!$H$24)*'Weanling Input'!$F$15)/(('Weanling Input'!$H$76)+((D34/2)*'Weanling Input'!$F$10)))","v":0.25028960245991755}]
[]
[{"$f":"\"Lower Margin Scenario - Market Price Down \"&D19*100&\"%, Feed Price Up \"&C20*100&\"% and Weanling Purchase Cost Up \"&C21*100&\"%\"","v":"Lower Margin Scenario - Market Price Down 10%, Feed Price Up 10% and Weanling Purchase Cost Up 5%"}]
[null,"Operating Costs",{"$f":"SUM(C8+C26+C28)","v":106.40211995383945},{"$f":"SUM(D8+D26+D28)","v":89.790119953839422}]
[null,"Total Costs",{"$f":"C10+C11+C43","v":110.81518032779755},{"$f":"D10+D11+D43","v":94.453180327797526}]
[null,"Gross Revenue / hog",{"$f":"C25","v":78.3},{"$f":"D25","v":78.3}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C45-C43)","v":-28.102119953839448},{"$f":"SUM(D45-D43)","v":-11.490119953839425}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C45-C43-C11)","v":-30.002119953839447},{"$f":"SUM(D45-D43-D11)","v":-13.390119953839426}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C45-C44)","v":-32.515180327797552},{"$f":"SUM(D45-D44)","v":-16.153180327797529}]
[null,"Operating Expense Ratio",{"$f":"SUM(C43/C45)","v":1.358903192258486},{"$f":"SUM(D43/D45)","v":1.146744826996672}]
[null,"Return on Asset (ROA)",{"$f":"SUM(((C49+'Weaner-Summary'!$H$36+'Weaner-Summary'!$H$24)*'Weanling Input'!$F$15)/(('Weanling Input'!$H$76-'Weanling Input'!$H$53-'Weanling Input'!$H$62)+((C45/2)*'Weanling Input'!$F$10)))","v":-0.74617801417435092},{"$f":"SUM(((D49+'Weaner-Summary'!$H$36+'Weaner-Summary'!$H$24)*'Weanling Input'!$F$15)/(('Weanling Input'!$H$76)+((D45/2)*'Weanling Input'!$F$10)))","v":-0.32983481279012605}]
[]
[]
["Note: This budget is only a guide and is not intended as an in depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user."]

{"sheet":"Weanling Input","index":4,"n_rows":151,"n_cols":9,"rows_kept":151,"cut":false,"hidden":false,"merged":[[46,1,46,8],[19,6,19,7],[1,0,1,8]]}
[]
["Weaner Pig (Nursery) Production Costs 6 to 26 kg "]
[]
[" 1. This input table outlines the cost of production for the weaner barn only."]
[" 2. Buildings and equipment are valued at new cost."]
[" 3. Manure haulage is contracted out."]
[]
["Herd Profile"]
[]
["Weaner Pig Places",null,null,null,null,5200]
["Number of turns",null,null,null,null,7]
["Weaner Pigs Purchased",null,null,null,null,{"$f":"F10*F11","v":36400}]
["Percent Post-Weaning Mortality",null,null,null,null,2.44]
["Pigs Died, Post-Weaning",null,null,null,null,{"$f":"ROUND(F13*F12/100,0)","v":888}]
["Weaner Pigs Sold",null,null,null,null,{"$f":"ROUND(F12-F14,0)","v":35512},null,null,""]
["Average Market Price",null,null,null,null,87,"/cwt",{"$f":"F16*2.2046","v":191.80020000000002},"/ckg"]
["Weanling Formula Factor (% of Mkt Price)",null,null,null,null,55,"%"]
["Calculated Weanling Puchase Price",null,null,null,null,{"$f":"F16*F17/100","v":47.85},"/pig"]
[]
["Feed Requirements",null,null,null,null,null,"Ration Cost per tonne"]
[null,null,null,null,null,null,"Purchased","Home-Mixed"]
["Pre Starter 1(sew)",null,null,null,0.8," kg/pig",2000,{"$f":"'Feed-Summary'!H29","v":1186.470875}]
["Pre Starter 2 ",null,null,null,4," kg/pig",1611.5,{"$f":"'Feed-Summary'!H54","v":873.30462499999999}]
["Starter 1",null,null,null,11.9," kg/pig",1199,{"$f":"'Feed-Summary'!H79","v":710.4743749999999}]
["Starter 2 ",null,null,null,24," kg/pig",808.65,{"$f":"'Feed-Summary'!H105","v":575.97387500000002}]
["Total Feed",null,null,null,{"$f":"SUM(E22:E25)","v":40.700000000000003}," kg/pig"]
[]
["Weaner Pig Efficiency",null,null,null,"Ration 1","Ration 2","Ration 3","Ration 4"]
["Days Post-Weaning (nursery)",null,null,null,2,8,17,15,{"$f":"SUM(E29:H29)","v":42}]
["Target Starting Weight (kg)",null,null,null,6,6.5,9,16,{"$f":"E30","v":6}]
["Target Ending Weight (kg)",null,null,null,6.5,9,16,26,{"$f":"H31","v":26}]
["Feed Conversion Ratio ",null,null,null,{"$f":"E22/(E31-E30)","v":1.6},{"$f":"E23/(F31-F30)","v":1.6},{"$f":"E24/(G31-G30)","v":1.7},{"$f":"E25/(H31-H30)","v":2.4},{"$f":"((E32*($E$31-$E$30)+F32*($F$31-$F$30)+G32*($G$31-$G$30)+H32*($H$31-$H$30)))/($I$31-$I$30)","v":2.0350000000000001}]
["Average Daily Gain (kg)",null,null,null,{"$f":"(E31-E30)/E29","v":0.25},{"$f":"(F31-F30)/F29","v":0.3125},{"$f":"(G31-G30)/G29","v":0.41176470588235292},{"$f":"(H31-H30)/H29","v":0.66666666666666663},{"$f":"((E33*($E$31-$E$30)+F33*($F$31-$F$30)+G33*($G$31-$G$30)+H33*($H$31-$H$30)))/($I$31-$I$30)","v":0.52276348039215681}]
[]
["Days Weaner on feed (nursery)",null,null,null,null,{"$f":"I29","v":42}," days"]
["Total Cycle Days (per turn)",null,null,null,null,{"$f":"ROUND(365/F11,0)","v":52}," days"]
["Target Starting Weight",null,null,null,null,{"$f":"I30","v":6}," kg"]
["Target Ending Weight",null,null,null,null,{"$f":"I31","v":26}," kg"]
["Feed Conversion Ratio (feed:gain)",null,null,null,null,{"$f":"I32","v":2.0350000000000001}," kg"]
["Average Daily Gain",null,null,null,null,{"$f":"I33","v":0.52276348039215681}," kg"]
[]
["Labour"]
["Total Hours per 7-day week",null,null,null,null,48," hours/week"]
["Wage (includes benefits & hired manager) ",null,null,null,null,27," /hour "]
[]
[]
[null,"Capital Investment"]
[]
[null,null,null,null,null,"$/Sq. Ft.","$/Pig Place","Total","Your Cost"]
["Buildings"]
[null,"Barn",null,{"$f":"F10*3","v":15600},"sq ft",42,{"$f":"H51/F10","v":126},{"$f":"F51*D51","v":655200}]
[null,"Office & loading",null,null,null,25000,null,9000]
[null,"Feed Mill (building only)",null,null,null,null,null,45000]
[null,"Total Building Cost",null,null,null,null,null,{"$f":"SUM(H51:H52)","v":664200}]
[null,null,null,null,null,null,null,""]
["Equipment",null,null,null,null,null,null,""]
[null,"Nursery barn",null,null,null,null,null,340000]
[null,"Generator",null,null,null,null,null,15000]
[null,"Electrical & other",null,null,null,null,null,100000]
[null,"Fire Alarm System",null,null,null,null,null,1000]
[null,"Feed Bins",null,null,null,null,null,12000]
[null,"Feed Mill (equipment only)",null,null,null,null,null,60000]
[null,"Total Equipment Cost",null,null,null,null,null,{"$f":"SUM(H57:H62)","v":528000}]
[]
["Total Buildings and Equipment Cost",null,null,null,null,null,{"$f":"H65/F10","v":229.26923076923077},{"$f":"H54+H63","v":1192200}]
[]
["Land Value"]
[null,"Land Investment",null,{"$f":"G141-G142","v":40},"acres @",{"$f":"G144","v":2750},null,{"$f":"D68*F68","v":110000}]
[null,"Land Investment",null,{"$f":"G142","v":0},"acres @",{"$f":"G144","v":2750},null,{"$f":"D69*F69","v":0}]
[]
["Other Costs"]
[null,"Site preparation",null,null,null,null,null,36000]
[null,"Manure Storage",null,null,null,null,null,42000]
[null,"Total Other Costs",null,null,null,null,null,{"$f":"H72+H73","v":78000}]
[]
["Total Capital Investment",null,null,null,null,null,{"$f":"H76/F10","v":265.42307692307691},{"$f":"H65+H68+H74+H69","v":1380200}]
[]
[]
["Fixed Costs"]
["Depreciation (straight line):"]
[null,"Useful Life:"]
[null,null,"Buildings",null,null,null,25," years"]
[null,null,"Equipment",null,null,null,10," years"]
[null,"Salvage Value (% of original cost):"]
[null,null,"Buildings",null,null,null,10," %"]
[null,null,"Equipment",null,null,null,10," %"]
[null,null,null,null,null,null,""]
["Investment Interest Rate",null,null,null,null,null,2.75," %"]
[]
[]
["Other Operating Costs, Taxes and Land"]
[]
["Veterinary Costs: ",null,null,"Professional Services",null,null,2000," total"]
[null,null,null,"Medication",null,null,98000," total"]
[]
["Maintenance & Repair",null,null,null,null,null,0.55000000000000004,"% of Total Capital Investment"]
[]
["Hydro & Propane ",null,null,null,null,"Hydro rate",9.3240000000000003E-2,"per kwhr"]
[null,null,null,null,null,"Hydro usage",200000,"kwhr"]
[null,null,null,null,null,"Propane rate",0.75,"per litre"]
[null,null,null,null,null,"Propane usage",50000,"litres"]
["Insurance"]
[null,null,null,"Buildings and Equipment",null,null,0.65,"/$100 Capital Invested"]
[null,null,null,"Market Pigs",null,null,0.65,"/$100 Capital Invested"]
[null,null,null,"Business Interruption",null,null,0.65,"/$100 Capital Invested"]
[null,null,null,"Business Interruption Value",null,null,45,"per market pig"]
[null,null,null,"Market Hog Value",null,null,87,"market value"]
[]
["Manure Costs:"]
[null,null,"Storage volume",null,null,null,2.4,"litres/pig/day"]
[null,null,null,null,null,null,2.8999999999999998E-3,"/litre"]
[null,null,null,null,null,null,{"$f":"G111*4.56409","v":1.3235861E-2},"/gallon"]
[]
[null,null,"Odour control (barley straw)",null,null,null,0," total cost"]
[null,null,"Manure Management Fee",null,null,null,3000," total cost"]
[]
[null,null,"Manure nutrient content",null,null,"nutrient","fertilizer","% nutrient"]
[null,null,null,null,null,"kg/1000 ","value","value cost"]
[null,null,null,null,null,"litres","$/lb","recovery / sale"]
[null,null,"Total Nitrogen ",null,null,2.62,0.77,60]
[null,null,"Phosphate (P2O5)",null,null,0.59,0.89,0]
[null,null,"Potassium",null,null,1.37,0.6,0]
[null,null,null,null,"* kg/1000 L x 10 = lbs/1000 imp. Gallons"]
["Office supplies",null,null,null,null,null,0.3,"/pig place"]
[]
["Marketing & Transportation"]
[]
[null,null,null,"Trucking in",null,null,3.5,"/pig"]
[null,null,null,"Trucking out",null,null,0,"/pig"]
[null,null,null,"Council Levy",null,null,0.19,"/pig"]
[null,null,null,"Grading Charge",null,null,0,"/pig"]
[null,null,null,"Truck Washing",null,null,0,"/pig"]
[null,null,null,"Insurance",null,null,0.05,"/pig"]
[null,null,null,"Special Levy",null,null,0,"/pig"]
[]
["Property Tax:"]
[null,null,"Tax on Weanling Barn & Land",null,null,null,10000," /year"]
[null,null,"Land",null,null,null,10," /acre"]
[]
["Land Value"]
[null,null,"Number of acres",null,null,null,40]
[null,null,"Number of acres rented out",null,null,null,0]
[null,null,"Rental rate",null,null,null,80]
[null,null,"Land value per acre",null,null,null,2750]
[]
["Operating Loan Interest Rate",null,null,null,null,null,8.5,"%"]
[]
[]
["** FOOTNOTE:  1 cubic metre = 1000 litres"]
[null,null,null," 1 cubic metre = 35.314 cubic feet"]
[null,null,null," 1 cubic metre = 219.97 imperial gallons"]

{"sheet":"Feed-Cost","index":5,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":false,"merged":[[1,0,1,6],[55,2,55,7],[29,3,29,6]]}
[]
["Feed Ingredient Costs"]
[]
["  Ingredients",null,null,null,"Price/tonne",null,"Your Cost"]
["  Wheat",null,null,null,370]
["  Barley",null,null,null,320]
["  Corn ",null,null,null,355]
["  Soybean Meal - 47 %",null,null,null,665]
["  Canola Meal - 34% ",null,null,null,425]
["  Peas ",null,null,null,390]
["  Grower Micro Premix ",null,null,null,6000]
["  Canola Oil ",null,null,null,2400]
["  Whey Powder ",null,null,null,1364.6]
["  Fish Meal",null,null,null,3364.4]
["  Plasma",null,null,null,6270]
["  Limestone",null,null,null,203.95]
["  Dical (16% Ca-21% P) ",null,null,null,1544.23]
["  Salt - 96%",null,null,null,261.89999999999998]
["  Phytase",null,null,null,14500]
["  L-Lysine HCL",null,null,null,2248.5]
["  L-Threonine ",null,null,null,2815.6]
["  D,L-Methionine ",null,null,null,3850.2]
["  Oats - Steam rolled",null,null,null,375]
["  Processing Cost "]
["  (Hydro & Repairs/Maintenance & Insurance)",null,null,null,10]
["  Percent Weight loss due to processing",null,null,null,1.25,"%"]
["  Labour",null,null,null,10]
[]
[]
[null,null,null,"Suggested Home Mixed Rations"]
[null,null,null,"Pre starter 1","Pre starter 2","Starter 1","Starter 2"]
[null,null,null,"(kg)","(kg)","(kg)","(kg)"]
[{"$f":"A5","v":"  Wheat"},null,null,106,134.5,405,404]
["  Barley",null,null,0,0,0,65]
["  Corn ",null,null,0,0,249,250]
["  Soybean Meal - 47 %",null,null,120,130,200,227]
["  Canola Meal - 34% ",null,null,0,0,0,0]
["  Peas ",null,null,0,0,0,0]
[{"$f":"A11","v":"  Grower Micro Premix "},null,null,5,5,5,5]
["  Canola Oil ",null,null,27,19,11,0]
["  Whey Powder ",null,null,121,125,70,0]
["  Fish Meal",null,null,61,75,40,25]
["  Plasma",null,null,59,0,0,0]
["  Limestone",null,null,12.5,12.5,7,11]
["  Dical (16% Ca-21% P) ",null,null,10,10,8,8]
["  Salt - 96%",null,null,3.5,3.5,3.5,3.5]
["  Phytase",null,null,0,0.5,0.5,0.5]
["  L-Lysine HCL",null,null,0.5,0,1,1]
["  L-Threonine ",null,null,0,0,0,0]
["  D,L-Methionine ",null,null,0,0,0,0]
["  Oats - Steam rolled",null,null,474.5,485,0,0]
["Total must equal 1000 kg",null,null,{"$f":"SUM(D33:D51)","v":1000},{"$f":"SUM(E33:E51)","v":1000},{"$f":"SUM(F33:F51)","v":1000},{"$f":"SUM(G33:G51)","v":1000}]
[]
[]
[]
[null,null,"Total Feed Ingredients per Weanling -- Nursery Barn"]
[null,null,"Pre starter 1","Pre starter 2","Starter 1","Starter 2","Total"]
[null,null,"(tonnes)","(tonnes)","(tonnes)","(tonnes)","(tonnes)"]
[{"$f":"A5","v":"  Wheat"},null,{"$f":"(('Weanling Input'!$E$22*D33/1000)*'Weanling Input'!$F$12/1000)","v":3.0867200000000006},{"$f":"('Weanling Input'!$E$23*E33/1000)*'Weanling Input'!$F$12/1000","v":19.583200000000001},{"$f":"(('Weanling Input'!$E$24*F33/1000)*'Weanling Input'!$F$12/1000)","v":175.4298},{"$f":"(('Weanling Input'!$E$25*G33/1000)*'Weanling Input'!$F$12/1000)","v":352.93439999999998},{"$f":"SUM(C59:F59)","v":551.03412000000003}]
["  Barley",null,{"$f":"(('Weanling Input'!$E$22*D34/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E34/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F34/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G34/1000)*'Weanling Input'!$F$12/1000)","v":56.783999999999999},56.783999999999999]
["  Corn ",null,{"$f":"(('Weanling Input'!$E$22*D35/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E35/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F35/1000)*'Weanling Input'!$F$12/1000)","v":107.85683999999999},{"$f":"(('Weanling Input'!$E$25*G35/1000)*'Weanling Input'!$F$12/1000)","v":218.4},326.25684000000001]
["  Soybean Meal - 47 %",null,{"$f":"(('Weanling Input'!$E$22*D36/1000)*'Weanling Input'!$F$12/1000)","v":3.4944000000000002},{"$f":"('Weanling Input'!$E$23*E36/1000)*'Weanling Input'!$F$12/1000","v":18.928000000000001},{"$f":"(('Weanling Input'!$E$24*F36/1000)*'Weanling Input'!$F$12/1000)","v":86.632000000000005},{"$f":"(('Weanling Input'!$E$25*G36/1000)*'Weanling Input'!$F$12/1000)","v":198.30720000000002},307.36160000000001]
["  Canola Meal - 34% ",null,{"$f":"(('Weanling Input'!$E$22*D37/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E37/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F37/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G37/1000)*'Weanling Input'!$F$12/1000)","v":0},0]
["  Peas ",null,{"$f":"(('Weanling Input'!$E$22*D38/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E38/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F38/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G38/1000)*'Weanling Input'!$F$12/1000)","v":0},0]
[{"$f":"A11","v":"  Grower Micro Premix "},null,{"$f":"(('Weanling Input'!$E$22*D39/1000)*'Weanling Input'!$F$12/1000)","v":0.14560000000000001},{"$f":"('Weanling Input'!$E$23*E39/1000)*'Weanling Input'!$F$12/1000","v":0.72799999999999998},{"$f":"(('Weanling Input'!$E$24*F39/1000)*'Weanling Input'!$F$12/1000)","v":2.1657999999999999},{"$f":"(('Weanling Input'!$E$25*G39/1000)*'Weanling Input'!$F$12/1000)","v":4.3680000000000003},7.4074]
["  Canola Oil ",null,{"$f":"(('Weanling Input'!$E$22*D40/1000)*'Weanling Input'!$F$12/1000)","v":0.78624000000000005},{"$f":"('Weanling Input'!$E$23*E40/1000)*'Weanling Input'!$F$12/1000","v":2.7664},{"$f":"(('Weanling Input'!$E$24*F40/1000)*'Weanling Input'!$F$12/1000)","v":4.7647599999999999},{"$f":"(('Weanling Input'!$E$25*G40/1000)*'Weanling Input'!$F$12/1000)","v":0},8.3173999999999992]
["  Whey Powder ",null,{"$f":"(('Weanling Input'!$E$22*D41/1000)*'Weanling Input'!$F$12/1000)","v":3.5235200000000004},{"$f":"('Weanling Input'!$E$23*E41/1000)*'Weanling Input'!$F$12/1000","v":18.2},{"$f":"(('Weanling Input'!$E$24*F41/1000)*'Weanling Input'!$F$12/1000)","v":30.321199999999997},{"$f":"(('Weanling Input'!$E$25*G41/1000)*'Weanling Input'!$F$12/1000)","v":0},52.044719999999998]
["  Fish Meal",null,{"$f":"(('Weanling Input'!$E$22*D42/1000)*'Weanling Input'!$F$12/1000)","v":1.7763200000000001},{"$f":"('Weanling Input'!$E$23*E42/1000)*'Weanling Input'!$F$12/1000","v":10.92},{"$f":"(('Weanling Input'!$E$24*F42/1000)*'Weanling Input'!$F$12/1000)","v":17.3264},{"$f":"(('Weanling Input'!$E$25*G42/1000)*'Weanling Input'!$F$12/1000)","v":21.84},51.862719999999996]
["  Plasma",null,{"$f":"(('Weanling Input'!$E$22*D43/1000)*'Weanling Input'!$F$12/1000)","v":1.7180800000000001},{"$f":"('Weanling Input'!$E$23*E43/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F43/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G43/1000)*'Weanling Input'!$F$12/1000)","v":0},1.7180800000000001]
["  Limestone",null,{"$f":"(('Weanling Input'!$E$22*D44/1000)*'Weanling Input'!$F$12/1000)","v":0.36399999999999999},{"$f":"('Weanling Input'!$E$23*E44/1000)*'Weanling Input'!$F$12/1000","v":1.82},{"$f":"(('Weanling Input'!$E$24*F44/1000)*'Weanling Input'!$F$12/1000)","v":3.0321199999999999},{"$f":"(('Weanling Input'!$E$25*G44/1000)*'Weanling Input'!$F$12/1000)","v":9.6096000000000004},14.82572]
["  Dical (16% Ca-21% P) ",null,{"$f":"(('Weanling Input'!$E$22*D45/1000)*'Weanling Input'!$F$12/1000)","v":0.29120000000000001},{"$f":"('Weanling Input'!$E$23*E45/1000)*'Weanling Input'!$F$12/1000","v":1.456},{"$f":"(('Weanling Input'!$E$24*F45/1000)*'Weanling Input'!$F$12/1000)","v":3.4652800000000004},{"$f":"(('Weanling Input'!$E$25*G45/1000)*'Weanling Input'!$F$12/1000)","v":6.9888000000000003},12.201280000000001]
["  Salt - 96%",null,{"$f":"(('Weanling Input'!$E$22*D46/1000)*'Weanling Input'!$F$12/1000)","v":0.10192000000000001},{"$f":"('Weanling Input'!$E$23*E46/1000)*'Weanling Input'!$F$12/1000","v":0.50960000000000005},{"$f":"(('Weanling Input'!$E$24*F46/1000)*'Weanling Input'!$F$12/1000)","v":1.51606},{"$f":"(('Weanling Input'!$E$25*G46/1000)*'Weanling Input'!$F$12/1000)","v":3.0576000000000003},5.1851800000000008]
["  Phytase",null,{"$f":"(('Weanling Input'!$E$22*D47/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E47/1000)*'Weanling Input'!$F$12/1000","v":7.2800000000000004E-2},{"$f":"(('Weanling Input'!$E$24*F47/1000)*'Weanling Input'!$F$12/1000)","v":0.21658000000000002},{"$f":"(('Weanling Input'!$E$25*G47/1000)*'Weanling Input'!$F$12/1000)","v":0.43680000000000002},0.72618000000000005]
["  L-Lysine HCL",null,{"$f":"(('Weanling Input'!$E$22*D48/1000)*'Weanling Input'!$F$12/1000)","v":1.456E-2},{"$f":"('Weanling Input'!$E$23*E48/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F48/1000)*'Weanling Input'!$F$12/1000)","v":0.43316000000000004},{"$f":"(('Weanling Input'!$E$25*G48/1000)*'Weanling Input'!$F$12/1000)","v":0.87360000000000004},1.3213200000000001]
["  L-Threonine ",null,{"$f":"(('Weanling Input'!$E$22*D49/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E49/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F49/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G49/1000)*'Weanling Input'!$F$12/1000)","v":0},0]
["  D,L-Methionine ",null,{"$f":"(('Weanling Input'!$E$22*D50/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"('Weanling Input'!$E$23*E50/1000)*'Weanling Input'!$F$12/1000","v":0},{"$f":"(('Weanling Input'!$E$24*F50/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G50/1000)*'Weanling Input'!$F$12/1000)","v":0},0]
["  Oats - Steam rolled",null,{"$f":"(('Weanling Input'!$E$22*D51/1000)*'Weanling Input'!$F$12/1000)","v":13.817440000000003},{"$f":"('Weanling Input'!$E$23*E51/1000)*'Weanling Input'!$F$12/1000","v":70.616},{"$f":"(('Weanling Input'!$E$24*F51/1000)*'Weanling Input'!$F$12/1000)","v":0},{"$f":"(('Weanling Input'!$E$25*G51/1000)*'Weanling Input'!$F$12/1000)","v":0},84.433440000000004]
["Total Ration used (tonnes)",null,{"$f":"SUM(C59:C77)","v":29.120000000000005},{"$f":"SUM(D59:D77)","v":145.60000000000002},{"$f":"SUM(E59:E77)","v":433.15999999999997},{"$f":"SUM(F59:F77)","v":873.6},{"$f":"SUM(G59:G77)","v":1481.4800000000005}]
[]
[]
[]
["Summary of Feed Ingredients Used for a Farrow-Weanling Operation"]
["Weanlings Sold ",null,{"$f":"'Weanling Input'!F15","v":35512}]
[null,null,null,"Total","Total"]
[null,null,null,"per Year","per Month"]
[null,null,null,"(tonnes)","(tonnes)"]
[{"$f":"A5","v":"  Wheat"},null,null,{"$f":"G59","v":551.03412000000003},{"$f":"D87/12","v":45.919510000000002}]
["  Barley",null,null,56.783999999999999,4.7320000000000002]
["  Corn ",null,null,326.25684000000001,27.18807]
["  Soybean Meal - 47 %",null,null,307.36160000000001,25.613466666666667]
["  Canola Meal - 34% ",null,null,0,0]
["  Peas ",null,null,0,0]
[{"$f":"A11","v":"  Grower Micro Premix "},null,null,{"$f":"G65","v":7.4074},0.6172833333333333]
["  Canola Oil ",null,null,8.3173999999999992,0.6931166666666666]
["  Whey Powder ",null,null,52.044719999999998,4.3370600000000001]
["  Fish Meal",null,null,51.862719999999996,4.3218933333333327]
["  Plasma",null,null,1.7180800000000001,0.14317333333333335]
["  Limestone",null,null,14.82572,1.2354766666666668]
["  Dical (16% Ca-21% P) ",null,null,12.201280000000001,1.0167733333333333]
["  Salt - 96%",null,null,5.1851800000000008,0.43209833333333342]
["  Phytase",null,null,0.72618000000000005,6.0515000000000006E-2]
["  L-Lysine HCL",null,null,1.3213200000000001,0.11011]
["  L-Threonine ",null,null,0,0]
["  D,L-Methionine ",null,null,0,0]
["  Oats - Steam rolled",null,null,84.433440000000004,7.0361200000000004]
["Total Ration used  (tonnes)",null,null,{"$f":"SUM(D87:D105)","v":1481.4800000000005},{"$f":"SUM(E87:E105)","v":123.45666666666666}]
[]
[null,null," "]

{"sheet":"Feed-Summary","index":6,"n_rows":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,0,2,9]]}
[]
[]
["Feed Requirement and Cost Summary"]
[]
[null,null,null,"Amount",null,"Price",null,"Ration Cost",null,"Your"]
[null,"Pre starter 1",null," (kg)",null,"  $ /tonne",null,"  $ /tonne",null,"Cost"]
[null,{"$f":"'Feed-Cost'!A5","v":"  Wheat"},null,{"$f":"IF('Feed-Cost'!D33=0,\" \",'Feed-Cost'!D33)","v":106},null,{"$f":"IF('Feed-Cost'!D33=0,\" \",'Feed-Cost'!E5)","v":370},null,{"$f":"IF('Feed-Cost'!D33=0,\" \",ROUND((D7/1000)*F7,2))","v":39.22}]
[null,{"$f":"'Feed-Cost'!A6","v":"  Barley"},null,{"$f":"IF('Feed-Cost'!D34=0,\" \",'Feed-Cost'!D34)","v":" "},null,{"$f":"IF('Feed-Cost'!D34=0,\" \",'Feed-Cost'!E6)","v":" "},null,{"$f":"IF('Feed-Cost'!D34=0,\" \",ROUND((D8/1000)*F8,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A7","v":"  Corn "},null,{"$f":"IF('Feed-Cost'!D35=0,\" \",'Feed-Cost'!D35)","v":" "},null,{"$f":"IF('Feed-Cost'!D35=0,\" \",'Feed-Cost'!E7)","v":" "},null,{"$f":"IF('Feed-Cost'!D35=0,\" \",ROUND((D9/1000)*F9,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A8","v":"  Soybean Meal - 47 %"},null,{"$f":"IF('Feed-Cost'!D36=0,\" \",'Feed-Cost'!D36)","v":120},null,{"$f":"IF('Feed-Cost'!D36=0,\" \",'Feed-Cost'!E8)","v":665},null,{"$f":"IF('Feed-Cost'!D36=0,\" \",ROUND((D10/1000)*F10,2))","v":79.8}]
[null,{"$f":"'Feed-Cost'!A9","v":"  Canola Meal - 34% "},null,{"$f":"IF('Feed-Cost'!D37=0,\" \",'Feed-Cost'!D37)","v":" "},null,{"$f":"IF('Feed-Cost'!D37=0,\" \",'Feed-Cost'!E9)","v":" "},null,{"$f":"IF('Feed-Cost'!D37=0,\" \",ROUND((D11/1000)*F11,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A10","v":"  Peas "},null,{"$f":"IF('Feed-Cost'!D38=0,\" \",'Feed-Cost'!D38)","v":" "},null,{"$f":"IF('Feed-Cost'!D38=0,\" \",'Feed-Cost'!E10)","v":" "},null,{"$f":"IF('Feed-Cost'!D38=0,\" \",ROUND((D12/1000)*F12,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A11","v":"  Grower Micro Premix "},null,{"$f":"IF('Feed-Cost'!D39=0,\" \",'Feed-Cost'!D39)","v":5},null,{"$f":"IF('Feed-Cost'!D39=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!D39=0,\" \",ROUND((D13/1000)*F13,2))","v":30}]
[null,{"$f":"'Feed-Cost'!A12","v":"  Canola Oil "},null,{"$f":"IF('Feed-Cost'!D40=0,\" \",'Feed-Cost'!D40)","v":27},null,{"$f":"IF('Feed-Cost'!D40=0,\" \",'Feed-Cost'!E12)","v":2400},null,{"$f":"IF('Feed-Cost'!D40=0,\" \",ROUND((D14/1000)*F14,2))","v":64.8}]
[null,{"$f":"'Feed-Cost'!A13","v":"  Whey Powder "},null,{"$f":"IF('Feed-Cost'!D41=0,\" \",'Feed-Cost'!D41)","v":121},null,{"$f":"IF('Feed-Cost'!D41=0,\" \",'Feed-Cost'!E13)","v":1364.6},null,{"$f":"IF('Feed-Cost'!D41=0,\" \",ROUND((D15/1000)*F15,2))","v":165.12}]
[null,{"$f":"'Feed-Cost'!A14","v":"  Fish Meal"},null,{"$f":"IF('Feed-Cost'!D42=0,\" \",'Feed-Cost'!D42)","v":61},null,{"$f":"IF('Feed-Cost'!D42=0,\" \",'Feed-Cost'!E14)","v":3364.4},null,{"$f":"IF('Feed-Cost'!D42=0,\" \",ROUND((D16/1000)*F16,2))","v":205.23}]
[null,{"$f":"'Feed-Cost'!A15","v":"  Plasma"},null,{"$f":"IF('Feed-Cost'!D43=0,\" \",'Feed-Cost'!D43)","v":59},null,{"$f":"IF('Feed-Cost'!D43=0,\" \",'Feed-Cost'!E15)","v":6270},null,{"$f":"IF('Feed-Cost'!D43=0,\" \",ROUND((D17/1000)*F17,2))","v":369.93}]
[null,{"$f":"'Feed-Cost'!A16","v":"  Limestone"},null,{"$f":"IF('Feed-Cost'!D44=0,\" \",'Feed-Cost'!D44)","v":12.5},null,{"$f":"IF('Feed-Cost'!D44=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!D44=0,\" \",ROUND((D18/1000)*F18,2))","v":2.5499999999999998}]
[null,{"$f":"'Feed-Cost'!A17","v":"  Dical (16% Ca-21% P) "},null,{"$f":"IF('Feed-Cost'!D45=0,\" \",'Feed-Cost'!D45)","v":10},null,{"$f":"IF('Feed-Cost'!D45=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!D45=0,\" \",ROUND((D19/1000)*F19,2))","v":15.44}]
[null,{"$f":"'Feed-Cost'!A18","v":"  Salt - 96%"},null,{"$f":"IF('Feed-Cost'!D46=0,\" \",'Feed-Cost'!D46)","v":3.5},null,{"$f":"IF('Feed-Cost'!D46=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!D46=0,\" \",ROUND((D20/1000)*F20,2))","v":0.92}]
[null,{"$f":"'Feed-Cost'!A19","v":"  Phytase"},null,{"$f":"IF('Feed-Cost'!D47=0,\" \",'Feed-Cost'!D47)","v":" "},null,{"$f":"IF('Feed-Cost'!D47=0,\" \",'Feed-Cost'!E19)","v":" "},null,{"$f":"IF('Feed-Cost'!D47=0,\" \",ROUND((D21/1000)*F21,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A20","v":"  L-Lysine HCL"},null,{"$f":"IF('Feed-Cost'!D48=0,\" \",'Feed-Cost'!D48)","v":0.5},null,{"$f":"IF('Feed-Cost'!D48=0,\" \",'Feed-Cost'!E20)","v":2248.5},null,{"$f":"IF('Feed-Cost'!D48=0,\" \",ROUND((D22/1000)*F22,2))","v":1.1200000000000001}]
[null,{"$f":"'Feed-Cost'!A21","v":"  L-Threonine "},null,{"$f":"IF('Feed-Cost'!D49=0,\" \",'Feed-Cost'!D49)","v":" "},null,{"$f":"IF('Feed-Cost'!D49=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!D49=0,\" \",ROUND((D23/1000)*F23,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A22","v":"  D,L-Methionine "},null,{"$f":"IF('Feed-Cost'!D50=0,\" \",'Feed-Cost'!D50)","v":" "},null,{"$f":"IF('Feed-Cost'!D50=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!D50=0,\" \",ROUND((D24/1000)*F24,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A23","v":"  Oats - Steam rolled"},null,{"$f":"IF('Feed-Cost'!D51=0,\" \",'Feed-Cost'!D51)","v":474.5},null,{"$f":"IF('Feed-Cost'!D51=0,\" \",'Feed-Cost'!E23)","v":375},null,{"$f":"IF('Feed-Cost'!D51=0,\" \",ROUND((D25/1000)*F25,2))","v":177.94}]
[null,"  Total Pre Starter 1",null,{"$f":"SUM(D7:D25)","v":1000},"kg",null,null,{"$f":"SUM(H7:H25)","v":1152.07}]
[null,"  Adjusted for weight loss (percentage)",null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H26+(F27*H26/100)","v":1166.470875}]
[null,"  Plus processing cost per tonne",null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H27=0,0,H27+F28)","v":1176.470875}]
[null,"  Plus Labour Cost",null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"H28+F29","v":1186.470875}]
[]
[null,"Pre starter 2"]
[null,{"$f":"'Feed-Cost'!A5","v":"  Wheat"},null,{"$f":"IF('Feed-Cost'!E33=0,\" \",'Feed-Cost'!E33)","v":134.5},null,{"$f":"IF('Feed-Cost'!E33=0,\" \",'Feed-Cost'!E5)","v":370},null,{"$f":"IF('Feed-Cost'!E33=0,\" \",ROUND((D32/1000)*F32,2))","v":49.77}]
[null,{"$f":"'Feed-Cost'!A6","v":"  Barley"},null,{"$f":"IF('Feed-Cost'!E34=0,\" \",'Feed-Cost'!E34)","v":" "},null,{"$f":"IF('Feed-Cost'!E34=0,\" \",'Feed-Cost'!E6)","v":" "},null,{"$f":"IF('Feed-Cost'!E34=0,\" \",ROUND((D33/1000)*F33,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A7","v":"  Corn "},null,{"$f":"IF('Feed-Cost'!E35=0,\" \",'Feed-Cost'!E35)","v":" "},null,{"$f":"IF('Feed-Cost'!E35=0,\" \",'Feed-Cost'!E7)","v":" "},null,{"$f":"IF('Feed-Cost'!E35=0,\" \",ROUND((D34/1000)*F34,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A8","v":"  Soybean Meal - 47 %"},null,{"$f":"IF('Feed-Cost'!E36=0,\" \",'Feed-Cost'!E36)","v":130},null,{"$f":"IF('Feed-Cost'!E36=0,\" \",'Feed-Cost'!E8)","v":665},null,{"$f":"IF('Feed-Cost'!E36=0,\" \",ROUND((D35/1000)*F35,2))","v":86.45}]
[null,{"$f":"'Feed-Cost'!A9","v":"  Canola Meal - 34% "},null,{"$f":"IF('Feed-Cost'!E37=0,\" \",'Feed-Cost'!E37)","v":" "},null,{"$f":"IF('Feed-Cost'!E37=0,\" \",'Feed-Cost'!E9)","v":" "},null,{"$f":"IF('Feed-Cost'!E37=0,\" \",ROUND((D36/1000)*F36,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A10","v":"  Peas "},null,{"$f":"IF('Feed-Cost'!E38=0,\" \",'Feed-Cost'!E38)","v":" "},null,{"$f":"IF('Feed-Cost'!E38=0,\" \",'Feed-Cost'!E10)","v":" "},null,{"$f":"IF('Feed-Cost'!E38=0,\" \",ROUND((D37/1000)*F37,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A11","v":"  Grower Micro Premix "},null,{"$f":"IF('Feed-Cost'!E39=0,\" \",'Feed-Cost'!E39)","v":5},null,{"$f":"IF('Feed-Cost'!E39=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!E39=0,\" \",ROUND((D38/1000)*F38,2))","v":30}]
[null,{"$f":"'Feed-Cost'!A12","v":"  Canola Oil "},null,{"$f":"IF('Feed-Cost'!E40=0,\" \",'Feed-Cost'!E40)","v":19},null,{"$f":"IF('Feed-Cost'!E40=0,\" \",'Feed-Cost'!E12)","v":2400},null,{"$f":"IF('Feed-Cost'!E40=0,\" \",ROUND((D39/1000)*F39,2))","v":45.6}]
[null,{"$f":"'Feed-Cost'!A13","v":"  Whey Powder "},null,{"$f":"IF('Feed-Cost'!E41=0,\" \",'Feed-Cost'!E41)","v":125},null,{"$f":"IF('Feed-Cost'!E41=0,\" \",'Feed-Cost'!E13)","v":1364.6},null,{"$f":"IF('Feed-Cost'!E41=0,\" \",ROUND((D40/1000)*F40,2))","v":170.58}]
[null,{"$f":"'Feed-Cost'!A14","v":"  Fish Meal"},null,{"$f":"IF('Feed-Cost'!E42=0,\" \",'Feed-Cost'!E42)","v":75},null,{"$f":"IF('Feed-Cost'!E42=0,\" \",'Feed-Cost'!E14)","v":3364.4},null,{"$f":"IF('Feed-Cost'!E42=0,\" \",ROUND((D41/1000)*F41,2))","v":252.33}]
[null,{"$f":"'Feed-Cost'!A15","v":"  Plasma"},null,{"$f":"IF('Feed-Cost'!E43=0,\" \",'Feed-Cost'!E43)","v":" "},null,{"$f":"IF('Feed-Cost'!E43=0,\" \",'Feed-Cost'!E15)","v":" "},null,{"$f":"IF('Feed-Cost'!E43=0,\" \",ROUND((D42/1000)*F42,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A16","v":"  Limestone"},null,{"$f":"IF('Feed-Cost'!E44=0,\" \",'Feed-Cost'!E44)","v":12.5},null,{"$f":"IF('Feed-Cost'!E44=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!E44=0,\" \",ROUND((D43/1000)*F43,2))","v":2.5499999999999998}]
[null,{"$f":"'Feed-Cost'!A17","v":"  Dical (16% Ca-21% P) "},null,{"$f":"IF('Feed-Cost'!E45=0,\" \",'Feed-Cost'!E45)","v":10},null,{"$f":"IF('Feed-Cost'!E45=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!E45=0,\" \",ROUND((D44/1000)*F44,2))","v":15.44}]
[null,{"$f":"'Feed-Cost'!A18","v":"  Salt - 96%"},null,{"$f":"IF('Feed-Cost'!E46=0,\" \",'Feed-Cost'!E46)","v":3.5},null,{"$f":"IF('Feed-Cost'!E46=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!E46=0,\" \",ROUND((D45/1000)*F45,2))","v":0.92}]
[null,{"$f":"'Feed-Cost'!A19","v":"  Phytase"},null,{"$f":"IF('Feed-Cost'!E47=0,\" \",'Feed-Cost'!E47)","v":0.5},null,{"$f":"IF('Feed-Cost'!E47=0,\" \",'Feed-Cost'!E19)","v":14500},null,{"$f":"IF('Feed-Cost'!E47=0,\" \",ROUND((D46/1000)*F46,2))","v":7.25}]
[null,{"$f":"'Feed-Cost'!A20","v":"  L-Lysine HCL"},null,{"$f":"IF('Feed-Cost'!E48=0,\" \",'Feed-Cost'!E48)","v":" "},null,{"$f":"IF('Feed-Cost'!E48=0,\" \",'Feed-Cost'!E20)","v":" "},null,{"$f":"IF('Feed-Cost'!E48=0,\" \",ROUND((D47/1000)*F47,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A21","v":"  L-Threonine "},null,{"$f":"IF('Feed-Cost'!E49=0,\" \",'Feed-Cost'!E49)","v":" "},null,{"$f":"IF('Feed-Cost'!E49=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!E49=0,\" \",ROUND((D48/1000)*F48,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A22","v":"  D,L-Methionine "},null,{"$f":"IF('Feed-Cost'!E50=0,\" \",'Feed-Cost'!E50)","v":" "},null,{"$f":"IF('Feed-Cost'!E50=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!E50=0,\" \",ROUND((D49/1000)*F49,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A23","v":"  Oats - Steam rolled"},null,{"$f":"IF('Feed-Cost'!E51=0,\" \",'Feed-Cost'!E51)","v":485},null,{"$f":"IF('Feed-Cost'!E51=0,\" \",'Feed-Cost'!E23)","v":375},null,{"$f":"IF('Feed-Cost'!E51=0,\" \",ROUND((D50/1000)*F50,2))","v":181.88}]
[null,"  Total Pre Starter 2",null,{"$f":"SUM(D32:D50)","v":1000},"kg",null,null,{"$f":"SUM(H32:H50)","v":842.77}]
[null,"  Adjusted for weight loss (percentage)",null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H51+(F52*H51/100)","v":853.30462499999999}]
[null,"  Plus processing cost per tonne",null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H52=0,0,H52+F53)","v":863.30462499999999}]
[null,"  Plus Labour Cost",null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"H53+F54","v":873.30462499999999}]
[]
[null,"Starter 1"]
[null,{"$f":"'Feed-Cost'!A5","v":"  Wheat"},null,{"$f":"IF('Feed-Cost'!F33=0,\" \",'Feed-Cost'!F33)","v":405},null,{"$f":"IF('Feed-Cost'!F33=0,\" \",'Feed-Cost'!E5)","v":370},null,{"$f":"IF('Feed-Cost'!F33=0,\" \",ROUND((D57/1000)*F57,2))","v":149.85}]
[null,{"$f":"'Feed-Cost'!A6","v":"  Barley"},null,{"$f":"IF('Feed-Cost'!F34=0,\" \",'Feed-Cost'!F34)","v":" "},null,{"$f":"IF('Feed-Cost'!F34=0,\" \",'Feed-Cost'!E6)","v":" "},null,{"$f":"IF('Feed-Cost'!F34=0,\" \",ROUND((D58/1000)*F58,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A7","v":"  Corn "},null,{"$f":"IF('Feed-Cost'!F35=0,\" \",'Feed-Cost'!F35)","v":249},null,{"$f":"IF('Feed-Cost'!F35=0,\" \",'Feed-Cost'!E7)","v":355},null,{"$f":"IF('Feed-Cost'!F35=0,\" \",ROUND((D59/1000)*F59,2))","v":88.4}]
[null,{"$f":"'Feed-Cost'!A8","v":"  Soybean Meal - 47 %"},null,{"$f":"IF('Feed-Cost'!F36=0,\" \",'Feed-Cost'!F36)","v":200},null,{"$f":"IF('Feed-Cost'!F36=0,\" \",'Feed-Cost'!E8)","v":665},null,{"$f":"IF('Feed-Cost'!F36=0,\" \",ROUND((D60/1000)*F60,2))","v":133}]
[null,{"$f":"'Feed-Cost'!A9","v":"  Canola Meal - 34% "},null,{"$f":"IF('Feed-Cost'!F37=0,\" \",'Feed-Cost'!F37)","v":" "},null,{"$f":"IF('Feed-Cost'!F37=0,\" \",'Feed-Cost'!E9)","v":" "},null,{"$f":"IF('Feed-Cost'!F37=0,\" \",ROUND((D61/1000)*F61,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A10","v":"  Peas "},null,{"$f":"IF('Feed-Cost'!F38=0,\" \",'Feed-Cost'!F38)","v":" "},null,{"$f":"IF('Feed-Cost'!F38=0,\" \",'Feed-Cost'!E10)","v":" "},null,{"$f":"IF('Feed-Cost'!F38=0,\" \",ROUND((D62/1000)*F62,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A11","v":"  Grower Micro Premix "},null,{"$f":"IF('Feed-Cost'!F39=0,\" \",'Feed-Cost'!F39)","v":5},null,{"$f":"IF('Feed-Cost'!F39=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!F39=0,\" \",ROUND((D63/1000)*F63,2))","v":30}]
[null,{"$f":"'Feed-Cost'!A12","v":"  Canola Oil "},null,{"$f":"IF('Feed-Cost'!F40=0,\" \",'Feed-Cost'!F40)","v":11},null,{"$f":"IF('Feed-Cost'!F40=0,\" \",'Feed-Cost'!E12)","v":2400},null,{"$f":"IF('Feed-Cost'!F40=0,\" \",ROUND((D64/1000)*F64,2))","v":26.4}]
[null,{"$f":"'Feed-Cost'!A13","v":"  Whey Powder "},null,{"$f":"IF('Feed-Cost'!F41=0,\" \",'Feed-Cost'!F41)","v":70},null,{"$f":"IF('Feed-Cost'!F41=0,\" \",'Feed-Cost'!E13)","v":1364.6},null,{"$f":"IF('Feed-Cost'!F41=0,\" \",ROUND((D65/1000)*F65,2))","v":95.52}]
[null,{"$f":"'Feed-Cost'!A14","v":"  Fish Meal"},null,{"$f":"IF('Feed-Cost'!F42=0,\" \",'Feed-Cost'!F42)","v":40},null,{"$f":"IF('Feed-Cost'!F42=0,\" \",'Feed-Cost'!E14)","v":3364.4},null,{"$f":"IF('Feed-Cost'!F42=0,\" \",ROUND((D66/1000)*F66,2))","v":134.58000000000001}]
[null,{"$f":"'Feed-Cost'!A15","v":"  Plasma"},null,{"$f":"IF('Feed-Cost'!F43=0,\" \",'Feed-Cost'!F43)","v":" "},null,{"$f":"IF('Feed-Cost'!F43=0,\" \",'Feed-Cost'!E15)","v":" "},null,{"$f":"IF('Feed-Cost'!F43=0,\" \",ROUND((D67/1000)*F67,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A16","v":"  Limestone"},null,{"$f":"IF('Feed-Cost'!F44=0,\" \",'Feed-Cost'!F44)","v":7},null,{"$f":"IF('Feed-Cost'!F44=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!F44=0,\" \",ROUND((D68/1000)*F68,2))","v":1.43}]
[null,{"$f":"'Feed-Cost'!A17","v":"  Dical (16% Ca-21% P) "},null,{"$f":"IF('Feed-Cost'!F45=0,\" \",'Feed-Cost'!F45)","v":8},null,{"$f":"IF('Feed-Cost'!F45=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!F45=0,\" \",ROUND((D69/1000)*F69,2))","v":12.35}]
[null,{"$f":"'Feed-Cost'!A18","v":"  Salt - 96%"},null,{"$f":"IF('Feed-Cost'!F46=0,\" \",'Feed-Cost'!F46)","v":3.5},null,{"$f":"IF('Feed-Cost'!F46=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!F46=0,\" \",ROUND((D70/1000)*F70,2))","v":0.92}]
[null,{"$f":"'Feed-Cost'!A19","v":"  Phytase"},null,{"$f":"IF('Feed-Cost'!F47=0,\" \",'Feed-Cost'!F47)","v":0.5},null,{"$f":"IF('Feed-Cost'!F47=0,\" \",'Feed-Cost'!E19)","v":14500},null,{"$f":"IF('Feed-Cost'!F47=0,\" \",ROUND((D71/1000)*F71,2))","v":7.25}]
[null,{"$f":"'Feed-Cost'!A20","v":"  L-Lysine HCL"},null,{"$f":"IF('Feed-Cost'!F48=0,\" \",'Feed-Cost'!F48)","v":1},null,{"$f":"IF('Feed-Cost'!F48=0,\" \",'Feed-Cost'!E20)","v":2248.5},null,{"$f":"IF('Feed-Cost'!F48=0,\" \",ROUND((D72/1000)*F72,2))","v":2.25}]
[null,{"$f":"'Feed-Cost'!A21","v":"  L-Threonine "},null,{"$f":"IF('Feed-Cost'!F49=0,\" \",'Feed-Cost'!F49)","v":" "},null,{"$f":"IF('Feed-Cost'!F49=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!F49=0,\" \",ROUND((D73/1000)*F73,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A22","v":"  D,L-Methionine "},null,{"$f":"IF('Feed-Cost'!F50=0,\" \",'Feed-Cost'!F50)","v":" "},null,{"$f":"IF('Feed-Cost'!F50=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!F50=0,\" \",ROUND((D74/1000)*F74,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A23","v":"  Oats - Steam rolled"},null,{"$f":"IF('Feed-Cost'!F51=0,\" \",'Feed-Cost'!F51)","v":" "},null,{"$f":"IF('Feed-Cost'!F51=0,\" \",'Feed-Cost'!E23)","v":" "},null,{"$f":"IF('Feed-Cost'!F51=0,\" \",ROUND((D75/1000)*F75,2))","v":" "}]
[null,"  Total Starter 1",null,{"$f":"SUM(D57:D75)","v":1000},"kg",null,null,{"$f":"SUM(H57:H75)","v":681.94999999999993}]
[null,"  Adjusted for weight loss (percentage)",null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H76+(F77*H76/100)","v":690.4743749999999}]
[null,"  Plus processing cost per tonne",null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H77=0,0,H77+F78)","v":700.4743749999999}]
[null,"  Plus Labour Cost",null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"H78+F79","v":710.4743749999999}]
[]
[]
[null,"Starter 2"]
[null,{"$f":"'Feed-Cost'!A5","v":"  Wheat"},null,{"$f":"IF('Feed-Cost'!G33=0,\" \",'Feed-Cost'!G33)","v":404},null,{"$f":"IF('Feed-Cost'!G33=0,\" \",'Feed-Cost'!E5)","v":370},null,{"$f":"IF('Feed-Cost'!G33=0,\" \",ROUND((D83/1000)*F83,2))","v":149.47999999999999}]
[null,{"$f":"'Feed-Cost'!A6","v":"  Barley"},null,{"$f":"IF('Feed-Cost'!G34=0,\" \",'Feed-Cost'!G34)","v":65},null,{"$f":"IF('Feed-Cost'!G34=0,\" \",'Feed-Cost'!E6)","v":320},null,{"$f":"IF('Feed-Cost'!G34=0,\" \",ROUND((D84/1000)*F84,2))","v":20.8}]
[null,{"$f":"'Feed-Cost'!A7","v":"  Corn "},null,{"$f":"IF('Feed-Cost'!G35=0,\" \",'Feed-Cost'!G35)","v":250},null,{"$f":"IF('Feed-Cost'!G35=0,\" \",'Feed-Cost'!E7)","v":355},null,{"$f":"IF('Feed-Cost'!G35=0,\" \",ROUND((D85/1000)*F85,2))","v":88.75}]
[null,{"$f":"'Feed-Cost'!A8","v":"  Soybean Meal - 47 %"},null,{"$f":"IF('Feed-Cost'!G36=0,\" \",'Feed-Cost'!G36)","v":227},null,{"$f":"IF('Feed-Cost'!G36=0,\" \",'Feed-Cost'!E8)","v":665},null,{"$f":"IF('Feed-Cost'!G36=0,\" \",ROUND((D86/1000)*F86,2))","v":150.96}]
[null,{"$f":"'Feed-Cost'!A9","v":"  Canola Meal - 34% "},null,{"$f":"IF('Feed-Cost'!G37=0,\" \",'Feed-Cost'!G37)","v":" "},null,{"$f":"IF('Feed-Cost'!G37=0,\" \",'Feed-Cost'!E9)","v":" "},null,{"$f":"IF('Feed-Cost'!G37=0,\" \",ROUND((D87/1000)*F87,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A10","v":"  Peas "},null,{"$f":"IF('Feed-Cost'!G38=0,\" \",'Feed-Cost'!G38)","v":" "},null,{"$f":"IF('Feed-Cost'!G38=0,\" \",'Feed-Cost'!E10)","v":" "},null,{"$f":"IF('Feed-Cost'!G38=0,\" \",ROUND((D88/1000)*F88,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A11","v":"  Grower Micro Premix "},null,{"$f":"IF('Feed-Cost'!G39=0,\" \",'Feed-Cost'!G39)","v":5},null,{"$f":"IF('Feed-Cost'!G39=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!G39=0,\" \",ROUND((D89/1000)*F89,2))","v":30}]
[null,{"$f":"'Feed-Cost'!A12","v":"  Canola Oil "},null,{"$f":"IF('Feed-Cost'!G40=0,\" \",'Feed-Cost'!G40)","v":" "},null,{"$f":"IF('Feed-Cost'!G40=0,\" \",'Feed-Cost'!E12)","v":" "},null,{"$f":"IF('Feed-Cost'!G40=0,\" \",ROUND((D90/1000)*F90,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A13","v":"  Whey Powder "},null,{"$f":"IF('Feed-Cost'!G41=0,\" \",'Feed-Cost'!G41)","v":" "},null,{"$f":"IF('Feed-Cost'!G41=0,\" \",'Feed-Cost'!E13)","v":" "},null,{"$f":"IF('Feed-Cost'!G41=0,\" \",ROUND((D91/1000)*F91,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A14","v":"  Fish Meal"},null,{"$f":"IF('Feed-Cost'!G42=0,\" \",'Feed-Cost'!G42)","v":25},null,{"$f":"IF('Feed-Cost'!G42=0,\" \",'Feed-Cost'!E14)","v":3364.4},null,{"$f":"IF('Feed-Cost'!G42=0,\" \",ROUND((D92/1000)*F92,2))","v":84.11}]
[null,{"$f":"'Feed-Cost'!A15","v":"  Plasma"},null,{"$f":"IF('Feed-Cost'!G43=0,\" \",'Feed-Cost'!G43)","v":" "},null,{"$f":"IF('Feed-Cost'!G43=0,\" \",'Feed-Cost'!E15)","v":" "},null,{"$f":"IF('Feed-Cost'!G43=0,\" \",ROUND((D93/1000)*F93,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A16","v":"  Limestone"},null,{"$f":"IF('Feed-Cost'!G44=0,\" \",'Feed-Cost'!G44)","v":11},null,{"$f":"IF('Feed-Cost'!G44=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!G44=0,\" \",ROUND((D94/1000)*F94,2))","v":2.2400000000000002}]
[null,{"$f":"'Feed-Cost'!A17","v":"  Dical (16% Ca-21% P) "},null,{"$f":"IF('Feed-Cost'!G45=0,\" \",'Feed-Cost'!G45)","v":8},null,{"$f":"IF('Feed-Cost'!G45=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!G45=0,\" \",ROUND((D95/1000)*F95,2))","v":12.35}]
[null,{"$f":"'Feed-Cost'!A18","v":"  Salt - 96%"},null,{"$f":"IF('Feed-Cost'!G46=0,\" \",'Feed-Cost'!G46)","v":3.5},null,{"$f":"IF('Feed-Cost'!G46=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!G46=0,\" \",ROUND((D96/1000)*F96,2))","v":0.92}]
[null,{"$f":"'Feed-Cost'!A19","v":"  Phytase"},null,{"$f":"IF('Feed-Cost'!G47=0,\" \",'Feed-Cost'!G47)","v":0.5},null,{"$f":"IF('Feed-Cost'!G47=0,\" \",'Feed-Cost'!E19)","v":14500},null,{"$f":"IF('Feed-Cost'!G47=0,\" \",ROUND((D97/1000)*F97,2))","v":7.25}]
[null,{"$f":"'Feed-Cost'!A20","v":"  L-Lysine HCL"},null,{"$f":"IF('Feed-Cost'!G48=0,\" \",'Feed-Cost'!G48)","v":1},null,{"$f":"IF('Feed-Cost'!G48=0,\" \",'Feed-Cost'!E20)","v":2248.5},null,{"$f":"IF('Feed-Cost'!G48=0,\" \",ROUND((D98/1000)*F98,2))","v":2.25}]
[null,{"$f":"'Feed-Cost'!A21","v":"  L-Threonine "},null,{"$f":"IF('Feed-Cost'!G49=0,\" \",'Feed-Cost'!G49)","v":" "},null,{"$f":"IF('Feed-Cost'!G49=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!G49=0,\" \",ROUND((D99/1000)*F99,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A22","v":"  D,L-Methionine "},null,{"$f":"IF('Feed-Cost'!G50=0,\" \",'Feed-Cost'!G50)","v":" "},null,{"$f":"IF('Feed-Cost'!G50=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!G50=0,\" \",ROUND((D100/1000)*F100,2))","v":" "}]
[null,{"$f":"'Feed-Cost'!A23","v":"  Oats - Steam rolled"},null,{"$f":"IF('Feed-Cost'!G51=0,\" \",'Feed-Cost'!G51)","v":" "},null,{"$f":"IF('Feed-Cost'!G51=0,\" \",'Feed-Cost'!E23)","v":" "},null,{"$f":"IF('Feed-Cost'!G51=0,\" \",ROUND((D101/1000)*F101,2))","v":" "}]
[null,"  Total Starter 2",null,{"$f":"SUM(D83:D101)","v":1000},"kg",null,null,{"$f":"SUM(H83:H101)","v":549.11}]
[null,"  Adjusted for weight loss (percentage)",null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H102+(F103*H102/100)","v":555.97387500000002}]
[null,"  Plus processing cost per tonne",null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H103=0,0,H103+F104)","v":565.97387500000002}]
[null,"  Plus Labour Cost",null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"H104+F105","v":575.97387500000002}]

{"sheet":"Weaner-Worksheet","index":7,"n_rows":274,"n_cols":9,"rows_kept":274,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Weaner Pig (Nursery) 6-26kg Production Costs Worksheet"]
[]
["A. Operating Costs"]
[]
["1. Feed Requirements and Costs",null,null,null,null,null,null,null,"Your Cost"]
[]
[null,"1.01  Pre starter 1 - Purchased Feed"]
[null,null,"",{"$f":"'Weanling Input'!E22","v":0.8},null," kg ration/pig"]
[null,null,"x",{"$f":"'Weanling Input'!G22","v":2000},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND(((D9*D10/1000)),2)","v":1.6},null," /pig sold"]
[null,"1.011  Pre starter 1 - Home-Mixed Feed"]
[null,null,"",{"$f":"'Weanling Input'!E22","v":0.8},null," kg ration/pig"]
[null,null,"x",{"$f":"'Feed-Summary'!H29","v":1186.470875},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND(((D14*D15/1000)),2)","v":0.95},null," /pig sold"]
[null,null,""]
[null,"1.02  Pre starter 2 - Purchased Feed"]
[null,null,null,{"$f":"'Weanling Input'!E23","v":4},null," kg ration/pig"]
[null,null,"x",{"$f":"'Weanling Input'!G23","v":1611.5},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND((D20*D21/1000),2)","v":6.45},null," /pig sold"]
[null,"1.021  Pre starter 2 - Home-Mixed Feed"]
[null,null,null,{"$f":"'Weanling Input'!E23","v":4},null," kg ration/pig"]
[null,null,"x",{"$f":"'Feed-Summary'!H54","v":873.30462499999999},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND((D25*D26/1000),2)","v":3.49},null," /pig sold"]
[]
[null,"1.03  Starter 1 - Purchased Feed"]
[null,null,null,{"$f":"'Weanling Input'!E24","v":11.9},null," kg ration/pig"]
[null,null,"x",{"$f":"'Weanling Input'!G24","v":1199},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND((D31*D32/1000),2)","v":14.27},null," /pig sold"]
[null,"1.031  Starter 1 - Home-Mixed Feed"]
[null,null,null,{"$f":"'Weanling Input'!E24","v":11.9},null," kg ration/pig"]
[null,null,"x",{"$f":"'Feed-Summary'!H79","v":710.4743749999999},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND((D36*D37/1000),2)","v":8.4499999999999993},null," /pig sold"]
[]
[null,"1.04  Starter 2 - Purchased Feed"]
[null,null,null,{"$f":"'Weanling Input'!E25","v":24},null," kg ration/pig"]
[null,null,"x",{"$f":"'Weanling Input'!G25","v":808.65},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND((D42*D43/1000),2)","v":19.41},null," /pig sold"]
[null,"1.041  Starter 2 - Home-Mixed Feed"]
[null,null,null,{"$f":"'Weanling Input'!E25","v":24},null," kg ration/pig"]
[null,null,"x",{"$f":"'Feed-Summary'!H105","v":575.97387500000002},null," /tonne "]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"ROUND((D47*D48/1000),2)","v":13.82},null," /pig sold"]
[]
["2. Other Operating Costs"]
[null,"2.01 Weanling Purchase"]
[null,null,null,{"$f":"'Weanling Input'!F16","v":87},null,"$/cwt average market price"]
[null,null,"x",{"$f":"'Weanling Input'!F17","v":55},null,"% of mkt price weanling formula factor"]
[null,null,null,{"$f":"D54*D55/100","v":47.85},null," purchase cost"]
[]
[null,"2.02 Veterinary Medicine & Supplies"]
[null,null,null,{"$f":"'Weanling Input'!G93","v":2000},null," professional services"]
[null,null,"+",{"$f":"'Weanling Input'!G94","v":98000},null," medication"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND((D59+D60)/D61,5)","v":2.81595},null," /pig sold"]
[]
[null,"2.03  Maintenance & Repairs"]
[null,null,null,{"$f":"'Weanling Input'!H65","v":1192200},null," building & equipment cost"]
[null,null,"x",{"$f":"'Weanling Input'!G96","v":0.55000000000000004},null," % year repair & maintenance"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND((D65*D66/100/D67),2)","v":0.18},null," /pig sold"]
[]
[null,"2.04  Hydro & Propane "]
[null,null,null,{"$f":"SUM('Weanling Input'!G98*'Weanling Input'!G99)","v":18648},null," hydro"]
[null,null,"+",{"$f":"SUM('Weanling Input'!G100*'Weanling Input'!G101)","v":37500},null," propane"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND((D71+D72)/D73,5)","v":1.5810999999999999},null," /pig sold"]
[]
[null,"2.05  Insurance"]
[null,null,null,{"$f":"'Weanling Input'!H65","v":1192200},null," investment "]
[null,null,"x",{"$f":"'Weanling Input'!G103","v":0.65},null," rate/$100"]
[null,null,"÷",100,null," /$100 capital"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D77*D78)/100)/D80,2)","v":0.22},null," /pig sold"]
[]
[null,null,null,{"$f":"'Weanling Input'!F10*'Weanling Input'!G107","v":452400},null,"market hogs value"]
[null,null,"x",{"$f":"'Weanling Input'!G104","v":0.65},null," /$100 capital invested"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D83*D84)/100)/D85,2)","v":0.08},null," /pig sold"]
[]
[null,null,null,{"$f":"'Weanling Input'!G106","v":45},null,"business interruption coverage/feeder"]
[null,null,"x",{"$f":"'Weanling Input'!F10","v":5200},null,"feeders"]
[null,null,"x",{"$f":"'Weanling Input'!G105","v":0.65},null," /$100 capital invested"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D88*D89)*D90/100)/D91,2)","v":0.04},null," /pig sold"]
[]
[null,"Total","=",{"$f":"D81+D86+D92","v":0.33999999999999997},null," /pig sold"]
[]
[null,"2.06  Manure Costs"]
[null,"     Haulage",null,{"$f":"'Weanling Input'!G110","v":2.4},null," litres/pig/day"]
[null,null,"x",365,null," days"]
[null,null,"x",{"$f":"'Weanling Input'!G111","v":2.8999999999999998E-3},null," /litre"]
[null,null,"x",{"$f":"'Weanling Input'!F10","v":5200},null,"pig places"]
[null,null,"÷",{"$f":"'Weanling Input'!F15","v":35512},null,"pigs sold"]
[null,null,"=",{"$f":"ROUND(D97*D99*D98*D100/D101,2)","v":0.37},null," /pig sold"]
[null,"  Estimated Nutrient Value"]
[null,null,null,{"$f":"'Weanling Input'!G110","v":2.4},null," litres/pig/day"]
[null,null,"x",365,null," days/year"]
[null,null,"x",{"$f":"'Weanling Input'!F10","v":5200},null," average inventory of pigs"]
[null,null,"÷",1000]
[null,null,"=",{"$f":"SUM((D104*D105*D106)/1000)","v":4555.2},null,"# of 1000 litres of manure"]
[null,null,"Nitrogen"]
[null,null,null,{"$f":"'Weanling Input'!F120","v":2.62},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D108","v":4555.2},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Weanling Input'!H120","v":60},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Weanling Input'!G120","v":0.77},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Weanling Input'!F15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D110*D111*(D112/100)/D113)*D114)/D115","v":7.0428532306121824E-2},null,"estimated nutrient value / pig sold"]
[null,null,"Phosphate"]
[null,null,null,{"$f":"'Weanling Input'!F121","v":0.59},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D108","v":4555.2},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Weanling Input'!H121","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Weanling Input'!G121","v":0.89},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Weanling Input'!F15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D118*D119*(D120/100)/D121)*D122)/D123","v":0},null,"estimated nutrient value / pig sold"]
[null,null,"Potassium"]
[null,null,null,{"$f":"'Weanling Input'!F122","v":1.37},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D108","v":4555.2},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Weanling Input'!H122","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Weanling Input'!G122","v":0.6},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Weanling Input'!F15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D126*D127*(D128/100)/D129)*D130)/D131","v":0},null,"estimated nutrient value / pig sold"]
[]
[null,"   Odour control & Mgmt Fees"]
[null,null,null,{"$f":"'Weanling Input'!G114+'Weanling Input'!G115","v":3000},null,"total cost"]
[null,null,"÷",{"$f":"'Weanling Input'!F15","v":35512},null,"pigs sold"]
[null,null,"=",{"$f":"D135/D136","v":8.4478486145528275E-2},null," /pig sold"]
[]
[null,"   Total ","=",{"$f":"D102+D137-(D116+D124+D132)","v":0.38404995383940643},null," /pig sold"]
[]
[null,"2.07  Office Supplies"]
[null,null,null,{"$f":"'Weanling Input'!G124","v":0.3},null," /pig place"]
[null,null,null,{"$f":"'Weanling Input'!F10","v":5200},null,"pig places"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(D142*D143/D144,5)","v":4.3929999999999997E-2},null," /pig sold"]
[]
[null,"2.08  Levy, Marketing & Transportation"]
[null,null,null,{"$f":"'Weanling Input'!G128","v":3.5},null,"trucking in"]
[null,null,"+",{"$f":"'Weanling Input'!G130","v":0.19},null,"council levy"]
[null,null,"+",{"$f":"'Weanling Input'!G133","v":0.05},null,"insurance"]
[null,null,"=",{"$f":"D148+D149+D150","v":3.7399999999999998},null," /pig sold"]
[]
[null,"2.09 Property Taxes"]
[null,null,null,{"$f":"'Weanling Input'!G137","v":10000},null,"total taxes"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(D154/D155,5)","v":0.28159000000000001},null," /pig sold"]
[]
[null,null,null,{"$f":"'Weanling Input'!G138","v":10},null," taxes on  land"]
[null,null,"x",{"$f":"'Weanling Input'!G142","v":0},null,"acres"]
[null,null,"÷",{"$f":"'Weanling Input'!F15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"(D158*D159)/D160","v":0},null," /pig sold"]
[]
[null,"Total",null,{"$f":"D156+D161","v":0.28159000000000001},null," /pig sold"]
[]
[null,"2.10  Interest on Operating Cost - Purchased Feed:"]
[null,null,null,{"$f":"'Weaner-Summary'!E14","v":47.85},null,"weaner cost"]
[null,null,"+",{"$f":"'Weaner-Summary'!$E$11+SUM('Weaner-Summary'!$E$15:$E$22)","v":51.096619953839408},null,"subtotal operating"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Weanling Input'!F36","v":52},null,"days per turn"]
[null,null,"÷",365,null,"days per year"]
[null,null,"x",{"$f":"'Weanling Input'!G146","v":8.5},null,"% operating interest"]
[null,null,"=",{"$f":"ROUND((((D166+(D167/D168))*D169)/D170)*D171/100,2)","v":0.89},null," /pig sold"]
[null,"        Interest on Operating Cost - Home Mixed Feed:"]
[null,null,null,{"$f":"D166","v":47.85},null,"weaner cost"]
[null,null,"+",{"$f":"'Weaner-Summary'!$H$11+SUM('Weaner-Summary'!$H$15:$H$22)","v":36.076619953839405},null,"subtotal operating"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"D169","v":52},null,"days per turn"]
[null,null,"÷",365,null,"days per year"]
[null,null,"x",{"$f":"D171","v":8.5},null,"% operating interest"]
[null,null,"=",{"$f":"ROUND((((D174+(D175/D176))*D177)/D178)*D179/100,2)","v":0.8},null," /pig sold"]
[]
["B. Fixed Costs"]
[]
["3. Depreciation:",null,null,"  Original cost - Salvage Value"]
[null,null,null,"                    Useful Life"]
[]
[null,"3.01  Buildings - not including feedmill",null,null,null,null,""]
[null,null,null,{"$f":"'Weanling Input'!$H$54+'Weanling Input'!$H$74-'Weanling Input'!H53","v":697200},null,"building cost (including manure storage)"]
[null,null,"-",{"$f":"'Weanling Input'!$G$85/100*($D$188-'Weanling Input'!$H$74)","v":61920},null,"salvage value (building only)"]
[null,null,"÷",{"$f":"'Weanling Input'!G82","v":25},null," years useful life"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D188-D189)/D190)/D191,2)","v":0.72},null," /pig sold"]
[null,"3.011  Buildings - including feedmill",null,null,null,null,""]
[null,null,null,{"$f":"'Weanling Input'!$H$54+'Weanling Input'!$H$74","v":742200},null,"building cost (including manure storage)"]
[null,null,"-",{"$f":"'Weanling Input'!$G$85/100*($D$194-'Weanling Input'!$H$74)","v":66420},null,"salvage value (building only)"]
[null,null,"÷",{"$f":"'Weanling Input'!G82","v":25},null," years useful life"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D194-D195)/D196)/D197,2)","v":0.76},null," /pig sold"]
[]
[null,"3.02  Equipment - not including feedmill"]
[null,null,null,{"$f":"'Weanling Input'!$H$63-'Weanling Input'!H62","v":468000},null," equipment cost"]
[null,null,"-",{"$f":"'Weanling Input'!$G$86/100*$D$201","v":46800},null," salvage value"]
[null,null,"÷",{"$f":"'Weanling Input'!G83","v":10},null," years useful life"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D201-D202)/D203)/D204,2)","v":1.19},null," /pig sold"]
[null,"3.021  Equipment - including feedmill"]
[null,null,null,{"$f":"'Weanling Input'!$H$63","v":528000},null," equipment cost"]
[null,null,"-",{"$f":"'Weanling Input'!$G$86/100*$D$201","v":46800},null," salvage value"]
[null,null,"÷",{"$f":"'Weanling Input'!G83","v":10},null," years useful life"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D207-D208)/D209)/D210,2)","v":1.36},null," /pig sold"]
[]
[]
["4.  Investment:",null,null,"Original Cost + Salvage Value x Investment Rate"]
[null,null,null,2,null,null,null,""]
[null,"4.01         Land for barn site"]
[null,null,null,{"$f":"'Weanling Input'!H68","v":110000},null,"land value"]
[null,null,"+",{"$f":"'Weanling Input'!H72","v":36000},null,"site preparation"]
[null,null,"x",{"$f":"'Weanling Input'!$G$88","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"((D217+D218)*D219/100)/D220","v":0.11306037395809868},null," /pig sold"]
[null,null,"Land for manure application"]
[null,null,null,{"$f":"'Weanling Input'!H69","v":0},null," land investment"]
[null,null,"x",{"$f":"D219","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"D220","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"((D222+D223)*D224/100)/D225","v":0},null," /pig sold"]
[null,"Total",null,{"$f":"D221+D226","v":0.11306037395809868},null," /pig sold"]
[]
[null,"4.02  Buildings - not including feedmill"]
[null,null,null,{"$f":"'Weanling Input'!$H$54+'Weanling Input'!$H$74-'Weanling Input'!H53","v":697200},null,"building cost (including manure storage)"]
[null,null,"+",{"$f":"D189","v":61920},null,"salvage value (building only)"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Weanling Input'!$G$88","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D230+D231)/2*D233/100)/D234,2)","v":0.28999999999999998},null," /pig sold"]
[null,"4.021  Buildings - including feedmill"]
[null,null,null,{"$f":"'Weanling Input'!$H$54+'Weanling Input'!$H$74","v":742200},null,"building cost (including manure storage)"]
[null,null,"+",{"$f":"D195","v":66420},null,"salvage value (building only)"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Weanling Input'!$G$88","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D237+D238)/2*D240/100)/D241,2)","v":0.31},null," /pig sold"]
[]
[null,"4.03  Equipment - not including feedmill"]
[null,null,null,{"$f":"D201","v":468000},null,"equipment cost"]
[null,null,"+",{"$f":"'Weanling Input'!$G$86/100*$D$201","v":46800},null,"salvage value"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Weanling Input'!$G$88","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null,"pigs sold"]
[null,null,"=",{"$f":"ROUND(((D245+D246)/2*D248/100)/D249,2)","v":0.2},null," /pig sold"]
[null,"4.031  Equipment - including feedmill"]
[null,null,null,{"$f":"'Weanling Input'!$H$63","v":528000},null,"equipment cost"]
[null,null,"+",{"$f":"'Weanling Input'!$G$86/100*D252","v":52800},null,"salvage value"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Weanling Input'!$G$88","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null,"pigs sold"]
[null,null,"=",{"$f":"ROUND(((D252+D253)/2*D255/100)/D256,2)","v":0.22},null," /pig sold"]
[]
["C. Labour"]
[null,null,null,{"$f":"'Weanling Input'!F43","v":48},null," hours/week"]
[null,null,"x",52,null," weeks/year"]
[null,null,"x",{"$f":"'Weanling Input'!F44","v":27},null," /hour"]
[null,null,"÷",{"$f":"'Weanling Input'!$F$15","v":35512},null," pigs sold"]
[null,null,"=",{"$f":"ROUND((D260*D261*D262)/D263,2)","v":1.9},null," /pig sold"]
[]
[]
["Return on Assets (ROA) ",null,null,null,"Net Income + Operating Interest + Investment Interest"]
["",null,null,null,"   - Value of Unpaid Family and Operator Labour"]
["",null,null,null,null,"Total Assets"]
[""]
["Total Assets",null,null,"Definition: Total Assets includes the buildings, "]
["",null,null,"equipment, land, manure storage and breeding stock valued at "]
["",null,null,"replacement cost, plus the value of market livestock "]
["",null,null,"on inventory.  "]

{"sheet":"Ingredient-Summary","index":8,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,8],[29,0,29,8]]}
[]
["  Summary of Home Mixed Feed Ingredients Used"]
[]
[null,null,null,"Total pigs sold",null,{"$f":"'Weanling Input'!F15","v":35512}]
[null," "]
[null,null,null,null,"Total","Total","Total","Total"]
[null," ",null,null,"per Year","per Month","per Pig","per Pig"]
[null,null,null,null,"(tonnes)","(tonnes)","(kgs)","(lbs)"]
[null,{"$f":"'Feed-Cost'!A5","v":"  Wheat"},null,null,{"$f":"'Feed-Cost'!D87","v":551.03412000000003},{"$f":"E9/12","v":45.919510000000002},{"$f":"E9/$F$4*1000","v":15.516842757377788},{"$f":"G9*2.2046","v":34.208431542915072}]
[null,{"$f":"'Feed-Cost'!A6","v":"  Barley"},null,null,{"$f":"'Feed-Cost'!D88","v":56.783999999999999},4.7320000000000002,1.599008785762559,{"$f":"G10*2.2046","v":3.5251747690921378}]
[null,{"$f":"'Feed-Cost'!A7","v":"  Corn "},null,null,{"$f":"'Feed-Cost'!D89","v":326.25684000000001},27.18807,9.1872279792746117,20.254162803108809]
[null,{"$f":"'Feed-Cost'!A8","v":"  Soybean Meal - 47 %"},null,null,{"$f":"'Feed-Cost'!D90","v":307.36160000000001},25.613466666666667,8.6551475557558017,19.081138301419241]
[null,{"$f":"'Feed-Cost'!A9","v":"  Canola Meal - 34% "},null,null,{"$f":"'Feed-Cost'!D91","v":0},0,0,0]
[null,{"$f":"'Feed-Cost'!A10","v":"  Peas "},null,null,{"$f":"'Feed-Cost'!D92","v":0},0,0,0]
[null,{"$f":"'Feed-Cost'!A11","v":"  Grower Micro Premix "},null,null,{"$f":"'Feed-Cost'!D93","v":7.4074},0.6172833333333333,0.20858864609146205,0.45985452917323727]
[null,{"$f":"'Feed-Cost'!A12","v":"  Canola Oil "},null,null,{"$f":"'Feed-Cost'!D94","v":8.3173999999999992},0.6931166666666666,0.23421378688893893,0.51634771457535478]
[null,{"$f":"'Feed-Cost'!A13","v":"  Whey Powder "},null,null,{"$f":"'Feed-Cost'!D95","v":52.044719999999998},4.3370600000000001,1.4655530524892992,3.2309582595179092]
[null,{"$f":"'Feed-Cost'!A14","v":"  Fish Meal"},null,null,{"$f":"'Feed-Cost'!D96","v":51.862719999999996},4.3218933333333327,1.460428024329804,3.219659622437486]
[null,{"$f":"'Feed-Cost'!A15","v":"  Plasma"},null,null,{"$f":"'Feed-Cost'!D97","v":1.7180800000000001},0.14317333333333335,4.8380265825636405E-2,0.10665913403919802]
[null,{"$f":"'Feed-Cost'!A16","v":"  Limestone"},null,null,{"$f":"'Feed-Cost'!D98","v":14.82572},1.2354766666666668,0.41748479387249382,0.92038697657129998]
[null,{"$f":"'Feed-Cost'!A17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"'Feed-Cost'!D99","v":12.201280000000001},1.0167733333333333,0.34358188781257037,0.75746062987159268]
[null,{"$f":"'Feed-Cost'!A18","v":"  Salt - 96%"},null,null,{"$f":"'Feed-Cost'!D100","v":5.1851800000000008},0.43209833333333342,0.14601205226402345,0.32189817042126612]
[null,{"$f":"'Feed-Cost'!A19","v":"  Phytase"},null,null,{"$f":"'Feed-Cost'!D101","v":0.72618000000000005},6.0515000000000006E-2,2.0448862356386575E-2,4.5081561950889845E-2]
[null,{"$f":"'Feed-Cost'!A20","v":"  L-Lysine HCL"},null,null,{"$f":"'Feed-Cost'!D102","v":1.3213200000000001},0.11011,3.7207704437936473E-2,8.2028105203874754E-2]
[null,{"$f":"'Feed-Cost'!A21","v":"  L-Threonine "},null,null,{"$f":"'Feed-Cost'!D103","v":0},0,0,0]
[null,{"$f":"'Feed-Cost'!A22","v":"  D,L-Methionine "},null,null,{"$f":"'Feed-Cost'!D104","v":0},0,0,0]
[null,{"$f":"'Feed-Cost'!A23","v":"  Oats - Steam rolled"},null,null,{"$f":"'Feed-Cost'!D105","v":84.433440000000004},7.0361200000000004,2.3776030637530976,5.2416637143500795]
[null,"Total",null,null,{"$f":"SUM(E9:E27)","v":1481.4800000000005},{"$f":"SUM(F9:F27)","v":123.45666666666666},{"$f":"SUM(G9:G27)","v":41.717729218292419},{"$f":"SUM(H9:H27)","v":91.970905834647454}]
[]
["  Summary of Purchased Feed Ingredients Used"]
[]
[null,null,null,null,"Total per","Total","Total","Total per"]
[null,null,null,null,"Pig Mkt","per Year","per Month","Pig Mkt"]
[null,null,null,null,"(kgs)","(tonnes)","(tonnes)","(lbs)"]
[null,"Pre starter 1",null,null,{"$f":"F35/$F$4*1000","v":0.82000450551926118},{"$f":"IF('Weanling Input'!G22<=0,0,'Weanling Input'!E22*'Weanling Input'!F12/1000)","v":29.12},{"$f":"F35/12","v":2.4266666666666667},{"$f":"E35*2.2046","v":1.8077819328677633}]
[null,"Pre starter 2",null,null,{"$f":"F36/$F$4*1000","v":4.1000225275963054},{"$f":"IF('Weanling Input'!G23<=0,0,'Weanling Input'!E23*'Weanling Input'!F12/1000)","v":145.6},{"$f":"F36/12","v":12.133333333333333},{"$f":"E36*2.2046","v":9.0389096643388154}]
[null,"Starter 1",null,null,{"$f":"F37/$F$4*1000","v":12.19756701959901},{"$f":"IF('Weanling Input'!G24<=0,0,'Weanling Input'!E24*'Weanling Input'!F12/1000)","v":433.16},{"$f":"F37/12","v":36.096666666666671},{"$f":"E37*2.2046","v":26.890756251407979}]
[null,"Starter 2",null,null,{"$f":"F38/$F$4*1000","v":24.600135165577836},{"$f":"IF('Weanling Input'!G25<=0,0,'Weanling Input'!E25*'Weanling Input'!F12/1000)","v":873.6},{"$f":"F38/12","v":72.8},{"$f":"E38*2.2046","v":54.233457986032903}]
[null,"Total",null,null,{"$f":"SUM(E35:E38)","v":41.717729218292412},{"$f":"SUM(F35:F38)","v":1481.48},{"$f":"SUM(G35:G38)","v":123.45666666666666},{"$f":"SUM(H35:H38)","v":91.970905834647454}]
[]
[null,"Total",null,null,{"$f":"E28+E39","v":1523.1977292182928},{"$f":"F28+F39","v":1604.9366666666667},{"$f":"G28+G39","v":165.1743958849591},{"$f":"H28+H39","v":183.94181166929491}]