{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Assumptions","Farrow-Wean Summary","Risk Analysis","Farrow-Wean Input","Feed-Cost","Feed-Summary","Weaner-Worksheet","Ingredient-Summary"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":33,"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":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,1,52,8],[4,1,4,8],[5,1,5,8],[6,1,6,8],[54,1,55,8],[11,1,20,8],[22,1,33,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
[null,"Guidelines For Estimating"]
[null,"Swine Farrow-Wean to 6 kg Costs"]
[null,{"$f":"\"Based On \"&'Farrow-Wean Input'!G13&\" Sows \"&FIXED('Farrow-Wean Input'!F30,0)&\" Pigs Sold\"","v":"Based On 600 Sows 16,422 Pigs Sold"}]
[]
[null,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 farrow to 6kg enterprise  in Manitoba.  This operation is intended to represent the first stage of a three stage 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":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,14,8],[16,1,22,8],[4,1,5,8],[7,1,10,8],[1,1,1,8]]}
[]
[null,"Farrow-Wean to 6 kg Pig Cost of Production"]
[]
[]
[null,"The following farrow wean to 6 kg 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 \"&'Farrow-Wean Input'!G153&\" acres, with \"&'Farrow-Wean Input'!G154&\" acres rented out at $\"&'Farrow-Wean Input'!G155&\" per acre, of the estimated \"&ROUND(((('Weaner-Worksheet'!D136*'Farrow-Wean Input'!F123)/(40.768*2))*2.4709661),0)&\" to \"&ROUND(((('Weaner-Worksheet'!D136*'Farrow-Wean Input'!F123)/(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 84 to 130 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,"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 formulation 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 farrow wean 6 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":"Farrow-Wean Summary","index":2,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,12],[67,0,68,12],[2,4,2,6],[2,8,2,10],[46,0,46,12]]}
[{"$f":"'Farrow-Wean Input'!G13&\" Sow Farrow-Wean to 6kg Cost of Production Summary - \"&Introduction!H9","v":"600 Sow Farrow-Wean to 6kg Cost of Production Summary - April, 2023"}]
[]
[null,null,null,null,"Purchased Feed",null,null,null,"Home-Mixed Feed"]
[null,null,null,null,"$/Pig",null,"Total",null,"$/Pig",null,"Total"]
["A. Operating Costs",null,null,null,"Sold","$/Sow","Cost",null,"Sold","$/Sow","Cost",null,"Your Cost"]
["1.","Feed Costs:"]
[null,"1.01","Sow Lactation Ration",null,{"$f":"'Weaner-Worksheet'!D16","v":7.52},{"$f":"ROUND(E7*'Farrow-Wean Input'!$G$30,2)","v":205.82},{"$f":"ROUND(E7*'Farrow-Wean Input'!$F$30,0)","v":123493},null,{"$f":"'Weaner-Worksheet'!D54","v":5.83},{"$f":"ROUND(I7*'Farrow-Wean Input'!$G$30,2)","v":159.57},{"$f":"ROUND(I7*'Farrow-Wean Input'!$F$30,0)","v":95740}]
[null,"1.02","Sow Gestation Ration",null,{"$f":"'Weaner-Worksheet'!D26","v":18.989999999999998},{"$f":"ROUND(E8*'Farrow-Wean Input'!$G$30,2)","v":519.76},{"$f":"ROUND(E8*'Farrow-Wean Input'!$F$30,0)","v":311854},null,{"$f":"'Weaner-Worksheet'!D64","v":14.58},{"$f":"ROUND(I8*'Farrow-Wean Input'!$G$30,2)","v":399.05},{"$f":"ROUND(I8*'Farrow-Wean Input'!$F$30,0)","v":239433}]
[null,"1.03","Boar Ration",null,{"$f":"'Weaner-Worksheet'!D36","v":0.11},{"$f":"ROUND(E9*'Farrow-Wean Input'!$G$30,2)","v":3.01},{"$f":"ROUND(E9*'Farrow-Wean Input'!$F$30,0)","v":1806},null,{"$f":"'Weaner-Worksheet'!D74","v":0.08},{"$f":"ROUND(I9*'Farrow-Wean Input'!$G$30,2)","v":2.19},{"$f":"ROUND(I9*'Farrow-Wean Input'!$F$30,0)","v":1314}]
[null,"1.04","Creep Feed",null,{"$f":"'Weaner-Worksheet'!D44","v":1.17},{"$f":"ROUND(E10*'Farrow-Wean Input'!$G$30,2)","v":32.020000000000003},{"$f":"ROUND(E10*'Farrow-Wean Input'!$F$30,0)","v":19214},null,{"$f":"'Weaner-Worksheet'!D82","v":0.64},{"$f":"ROUND(I10*'Farrow-Wean Input'!$G$30,2)","v":17.52},{"$f":"ROUND(I10*'Farrow-Wean Input'!$F$30,0)","v":10510}]
["Total Feed Cost",null,null,null,{"$f":"SUM(E7:E10)","v":27.79},{"$f":"SUM(F7:F10)","v":760.6099999999999},{"$f":"SUM(G7:G10)","v":456367},null,{"$f":"SUM(I7:I10)","v":21.13},{"$f":"SUM(J7:J10)","v":578.33000000000004},{"$f":"SUM(K7:K10)","v":346997}]
[]
["2.","Other Operating Costs:",null,null,null,""]
[null,"2.01","Veterinary Medicine & Supplies:",null,{"$f":"'Weaner-Worksheet'!D90","v":1.21},{"$f":"ROUND(E14*'Farrow-Wean Input'!$G$30,2)","v":33.119999999999997},{"$f":"ROUND(E14*'Farrow-Wean Input'!$F$30,0)","v":19871},null,{"$f":"E14","v":1.21},{"$f":"ROUND(I14*'Farrow-Wean Input'!$G$30,2)","v":33.119999999999997},{"$f":"ROUND(I14*'Farrow-Wean Input'!$F$30,0)","v":19871}]
[null,"2.02","Maintenance & Repairs",null,{"$f":"'Weaner-Worksheet'!D96","v":1.87},{"$f":"ROUND(E15*'Farrow-Wean Input'!$G$30,2)","v":51.18},{"$f":"ROUND(E15*'Farrow-Wean Input'!$F$30,0)","v":30709},null,1.87,{"$f":"ROUND(I15*'Farrow-Wean Input'!$G$30,2)","v":51.18},{"$f":"ROUND(I15*'Farrow-Wean Input'!$F$30,0)","v":30709}]
[null,"2.03","Hydro & Propane",null,{"$f":"'Weaner-Worksheet'!D102","v":3.78485},{"$f":"ROUND(E16*'Farrow-Wean Input'!$G$30,2)","v":103.59},{"$f":"ROUND(E16*'Farrow-Wean Input'!$F$30,0)","v":62155},null,3.78485,{"$f":"ROUND(I16*'Farrow-Wean Input'!$G$30,2)","v":103.59},{"$f":"ROUND(I16*'Farrow-Wean Input'!$F$30,0)","v":62155}]
[null,"2.04","Insurance",null,{"$f":"'Weaner-Worksheet'!D123","v":1.9729388381439532},{"$f":"ROUND(E17*'Farrow-Wean Input'!$G$30,2)","v":54},{"$f":"ROUND(E17*'Farrow-Wean Input'!$F$30,0)","v":32400},null,1.9729388381439532,{"$f":"ROUND(I17*'Farrow-Wean Input'!$G$30,2)","v":54},{"$f":"ROUND(I17*'Farrow-Wean Input'!$F$30,0)","v":32400}]
[null,"2.05","Manure Costs",null,{"$f":"'Weaner-Worksheet'!D166","v":0.93009345706825708},{"$f":"ROUND(E18*'Farrow-Wean Input'!$G$30,2)","v":25.46},{"$f":"ROUND(E18*'Farrow-Wean Input'!$F$30,0)","v":15274},null,0.93009345706825708,{"$f":"ROUND(I18*'Farrow-Wean Input'!$G$30,2)","v":25.46},{"$f":"ROUND(I18*'Farrow-Wean Input'!$F$30,0)","v":15274}]
[null,"2.06","Office Supplies",null,{"$f":"'Weaner-Worksheet'!D171","v":7.3072707343807081E-2},{"$f":"ROUND(E19*'Farrow-Wean Input'!$G$30,2)","v":2},{"$f":"ROUND(E19*'Farrow-Wean Input'!$F$30,0)","v":1200},null,7.3072707343807081E-2,{"$f":"ROUND(I19*'Farrow-Wean Input'!$G$30,2)","v":2},{"$f":"ROUND(I19*'Farrow-Wean Input'!$F$30,0)","v":1200}]
[null,"2.07","Marketing & Transport.",null,{"$f":"'Weaner-Worksheet'!D176","v":3.69},{"$f":"ROUND(E20*'Farrow-Wean Input'!$G$30,2)","v":101},{"$f":"ROUND(E20*'Farrow-Wean Input'!$F$30,0)","v":60597},null,3.69,{"$f":"ROUND(I20*'Farrow-Wean Input'!$G$30,2)","v":101},{"$f":"ROUND(I20*'Farrow-Wean Input'!$F$30,0)","v":60597}]
[null,"2.08","Herd Replacement",null,{"$f":"'Weaner-Worksheet'!D204","v":3.5484},{"$f":"ROUND(E21*'Farrow-Wean Input'!$G$30,2)","v":97.12},{"$f":"ROUND(E21*'Farrow-Wean Input'!$F$30,0)","v":58272},null,3.5484,{"$f":"ROUND(I21*'Farrow-Wean Input'!$G$30,2)","v":97.12},{"$f":"ROUND(I21*'Farrow-Wean Input'!$F$30,0)","v":58272}]
[null,"2.09","Artificial Insemination",null,{"$f":"'Weaner-Worksheet'!D212","v":2.0999269272926568},{"$f":"ROUND(E22*'Farrow-Wean Input'!$G$30,2)","v":57.48},{"$f":"ROUND(E22*'Farrow-Wean Input'!$F$30,0)","v":34485},null,2.0999269272926568,{"$f":"ROUND(I22*'Farrow-Wean Input'!$G$30,2)","v":57.48},{"$f":"ROUND(I22*'Farrow-Wean Input'!$F$30,0)","v":34485}]
[null,"2.10","Property Tax",null,{"$f":"'Weaner-Worksheet'!D224","v":0.45669999999999999},{"$f":"ROUND(E23*'Farrow-Wean Input'!$G$30,2)","v":12.5},{"$f":"ROUND(E23*'Farrow-Wean Input'!$F$30,0)","v":7500},null,0.45669999999999999,{"$f":"ROUND(I23*'Farrow-Wean Input'!$G$30,2)","v":12.5},{"$f":"ROUND(I23*'Farrow-Wean Input'!$F$30,0)","v":7500}]
["Subtotal Operating Costs",null,null,null,{"$f":"SUM(E14:E23)+E11","v":47.425981929848675},{"$f":"SUM(F14:F23)+F11","v":1298.06},{"$f":"SUM(G14:G23)+G11","v":778830},null,{"$f":"SUM(I14:I23)+I11","v":40.765981929848678},{"$f":"SUM(J14:J23)+J11","v":1115.78},{"$f":"SUM(K14:K23)+K11","v":669460}]
[null,"2.11","Interest on Operating Costs",null,{"$f":"'Weaner-Worksheet'!D240","v":0.84689999999999999},{"$f":"ROUND(E25*'Farrow-Wean Input'!$G$30,2)","v":23.18},{"$f":"ROUND(E25*'Farrow-Wean Input'!$F$30,0)","v":13908},null,{"$f":"'Weaner-Worksheet'!D251","v":0.72799999999999998},{"$f":"ROUND(I25*'Farrow-Wean Input'!$G$30,2)","v":19.93},{"$f":"ROUND(I25*'Farrow-Wean Input'!$F$30,0)","v":11955}]
["Total Operating Costs",null,null,null,{"$f":"SUM(E24:E25)","v":48.272881929848673},{"$f":"SUM(F24:F25)","v":1321.24},{"$f":"SUM(G24:G25)","v":792738},null,{"$f":"SUM(I24:I25)","v":41.49398192984868},{"$f":"SUM(J24:J25)","v":1135.71},{"$f":"SUM(K24:K25)","v":681415}]
[]
["B. Fixed Costs",null,null,null,null,""]
["3.","Depreciation:",null,null,null,""]
[null,"3.01","Buildings & Manure Storage",null,{"$f":"'Weaner-Worksheet'!D264","v":3.46},{"$f":"ROUND(E30*'Farrow-Wean Input'!$G$30,2)","v":94.7},{"$f":"ROUND(E30*'Farrow-Wean Input'!$F$30,0)","v":56820},null,{"$f":"'Weaner-Worksheet'!D272","v":3.55},{"$f":"ROUND(I30*'Farrow-Wean Input'!$G$30,2)","v":97.16},{"$f":"ROUND(I30*'Farrow-Wean Input'!$F$30,0)","v":58298}]
[null,"3.02","Equipment",null,{"$f":"'Weaner-Worksheet'!D279","v":3.53},{"$f":"ROUND(E31*'Farrow-Wean Input'!$G$30,2)","v":96.62},{"$f":"ROUND(E31*'Farrow-Wean Input'!$F$30,0)","v":57970},null,{"$f":"'Weaner-Worksheet'!D286","v":3.86},{"$f":"ROUND(I31*'Farrow-Wean Input'!$G$30,2)","v":105.65},{"$f":"ROUND(I31*'Farrow-Wean Input'!$F$30,0)","v":63389}]
["Total Depreciation Cost",null,null,null,{"$f":"SUM(E30:E31)","v":6.99},{"$f":"SUM(F30:F31)","v":191.32},{"$f":"SUM(G30:G31)","v":114790},null,{"$f":"SUM(I30:I31)","v":7.41},{"$f":"SUM(J30:J31)","v":202.81},{"$f":"SUM(K30:K31)","v":121687}]
[]
["4.","Investment:",null,null,null,"",""]
[null,"4.01","Land Cost",null,{"$f":"'Weaner-Worksheet'!D305","v":0.24448909998782123},{"$f":"ROUND(E35*'Farrow-Wean Input'!$G$30,2)","v":6.69},{"$f":"ROUND(E35*'Farrow-Wean Input'!$F$30,0)","v":4015},null,{"$f":"E35","v":0.24448909998782123},{"$f":"ROUND(I35*'Farrow-Wean Input'!$G$30,2)","v":6.69},{"$f":"ROUND(I35*'Farrow-Wean Input'!$F$30,0)","v":4015}]
[null,"4.02","Buildings & Manure Storage",null,{"$f":"'Weaner-Worksheet'!D314","v":1.4227000000000001},{"$f":"ROUND(E36*'Farrow-Wean Input'!$G$30,2)","v":38.94},{"$f":"ROUND(E36*'Farrow-Wean Input'!$F$30,0)","v":23364},null,{"$f":"'Weaner-Worksheet'!D322","v":1.4641999999999999},{"$f":"ROUND(I36*'Farrow-Wean Input'!$G$30,2)","v":40.08},{"$f":"ROUND(I36*'Farrow-Wean Input'!$F$30,0)","v":24045}]
[null,"4.03","Equipment",null,{"$f":"'Weaner-Worksheet'!D330","v":0.59340000000000004},{"$f":"ROUND(E37*'Farrow-Wean Input'!$G$30,2)","v":16.239999999999998},{"$f":"ROUND(E37*'Farrow-Wean Input'!$F$30,0)","v":9745},null,{"$f":"'Weaner-Worksheet'!D337","v":0.64859999999999995},{"$f":"ROUND(I37*'Farrow-Wean Input'!$G$30,2)","v":17.75},{"$f":"ROUND(I37*'Farrow-Wean Input'!$F$30,0)","v":10651}]
[null,"4.04","Breeding Herd",null,{"$f":"'Weaner-Worksheet'!D343","v":0.36920000000000003},{"$f":"ROUND(E38*'Farrow-Wean Input'!$G$30,2)","v":10.11},{"$f":"ROUND(E38*'Farrow-Wean Input'!$F$30,0)","v":6063},null,{"$f":"E38","v":0.36920000000000003},{"$f":"ROUND(I38*'Farrow-Wean Input'!$G$30,2)","v":10.11},{"$f":"ROUND(I38*'Farrow-Wean Input'!$F$30,0)","v":6063}]
["Total Investment Cost",null,null,null,{"$f":"SUM(E35:E38)","v":2.6297890999878217},{"$f":"SUM(F35:F38)","v":71.97999999999999},{"$f":"SUM(G35:G38)","v":43187},null,{"$f":"SUM(I35:I38)","v":2.7264890999878215},{"$f":"SUM(J35:J38)","v":74.63},{"$f":"SUM(K35:K38)","v":44774}]
["Total Fixed Costs",null,null,null,{"$f":"E32+E39","v":9.6197890999878215},{"$f":"F32+F39","v":263.29999999999995},{"$f":"G32+G39","v":157977},null,{"$f":"I32+I39","v":10.136489099987822},{"$f":"J32+J39","v":277.44},{"$f":"K32+K39","v":166461}]
[]
["C. Labour",null,null,null,null,""]
[null,"Wages, benefits and hired manager",null,null,{"$f":"'Weaner-Worksheet'!D351","v":10.26},{"$f":"ROUND(E43*'Farrow-Wean Input'!$G$30,2)","v":280.82},{"$f":"ROUND(E43*'Farrow-Wean Input'!$F$30,0)","v":168490},null,{"$f":"E43","v":10.26},{"$f":"ROUND(I43*'Farrow-Wean Input'!$G$30,2)","v":280.82},{"$f":"ROUND(I43*'Farrow-Wean Input'!$F$30,0)","v":168490}]
[]
["Total Cost of Production",null,null,null,{"$f":"E26+E40+E43","v":68.152671029836497},{"$f":"F26+F40+F43","v":1865.36},{"$f":"G26+G40+G43","v":1119205},null,{"$f":"I26+I40+I43","v":61.890471029836498},{"$f":"J26+J40+J43","v":1693.97},{"$f":"K26+K40+K43","v":1016366}]
[]
["Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null,"$/Pig","$/Sow","Total",null,"$/Pig","$/Sow","Total"]
[null,"Market Price per weanling",null,null,{"$f":"'Farrow-Wean Input'!F9","v":56},{"$f":"ROUND(E50*'Farrow-Wean Input'!$G$30,2)","v":1532.72},{"$f":"ROUND(E50*'Farrow-Wean Input'!$F$30,0)","v":919632},null,{"$f":"E50","v":56},{"$f":"ROUND(I50*'Farrow-Wean Input'!$G$30,2)","v":1532.72},{"$f":"ROUND(I50*'Farrow-Wean Input'!$F$30,0)","v":919632}]
[null,"Land rental per head sold",null,null,{"$f":"SUM(('Farrow-Wean Input'!G154*'Farrow-Wean Input'!G155)/'Farrow-Wean Input'!F30)","v":0},{"$f":"ROUND(E51*'Farrow-Wean Input'!$G$30,2)","v":0},{"$f":"ROUND(E51*'Farrow-Wean Input'!$F$30,0)","v":0},null,{"$f":"E51","v":0},{"$f":"ROUND(I51*'Farrow-Wean Input'!$G$30,2)","v":0},{"$f":"ROUND(I51*'Farrow-Wean Input'!$F$30,0)","v":0}]
[null,"Gross Revenue  / hog",null,null,{"$f":"SUM(E50:E51)","v":56},{"$f":"SUM(F50:F51)","v":1532.72},{"$f":"SUM(G50:G51)","v":919632},null,{"$f":"SUM(I50:I51)","v":56},{"$f":"SUM(J50:J51)","v":1532.72},{"$f":"SUM(K50:K51)","v":919632}]
[]
["Marginal Returns "]
[null,"Over Operating Costs",null,null,{"$f":"SUM(E52-E26)","v":7.7271180701513273},{"$f":"SUM(F52-F26)","v":211.48000000000002},{"$f":"SUM(G52-G26)","v":126894},null,{"$f":"SUM(I52-I26)","v":14.50601807015132},{"$f":"SUM(J52-J26)","v":397.01},{"$f":"SUM(K52-K26)","v":238217}]
[null,"Over Operating & Labour Costs",null,null,{"$f":"SUM(E52-E26-E43)","v":-2.5328819298486724},{"$f":"SUM(F52-F26-F43)","v":-69.339999999999975},{"$f":"SUM(G52-G26-G43)","v":-41596},null,{"$f":"SUM(I52-I26-I43)","v":4.2460180701513206},{"$f":"SUM(J52-J26-J43)","v":116.19},{"$f":"SUM(K52-K26-K43)","v":69727}]
[null,"Over Total Costs (Net Profit)",null,null,{"$f":"SUM(E52-E45)","v":-12.152671029836497},{"$f":"SUM(F52-F45)","v":-332.63999999999987},{"$f":"SUM(G52-G45)","v":-199573},null,{"$f":"SUM(I52-I45)","v":-5.8904710298364975},{"$f":"SUM(J52-J45)","v":-161.25},{"$f":"SUM(K52-K45)","v":-96734}]
[]
["Operating Expense Ratio",null,null,null,{"$f":"SUM(E26/E52)","v":0.86201574874729769},null,null,null,{"$f":"SUM(I26/I52)","v":0.74096396303301215}]
[]
["Breakeven Selling Price",null,null,null,"$/Pig",null,null,null,"$/Pig"]
[null,"Operating Costs",null,null,{"$f":"(E26)","v":48.272881929848673},null,null,null,{"$f":"(I26)","v":41.49398192984868}]
[null,"Operating & Labour Costs",null,null,{"$f":"(E26+E43)","v":58.532881929848671},null,null,null,{"$f":"(I26+I43)","v":51.753981929848678}]
[null,"Total Costs",null,null,{"$f":"E45","v":68.152671029836497},null,null,null,{"$f":"I45","v":61.890471029836498}]
[]
["Return On Assets (ROA)",null,null,null,{"$f":"SUM((E57+E25+E39)*'Farrow-Wean Input'!$F$30)/(('Farrow-Wean Input'!$H$78-'Farrow-Wean Input'!H60-'Farrow-Wean Input'!H52)+(('Farrow-Wean Input'!$F$9/2)*('Farrow-Wean Input'!F30/365*'Farrow-Wean Input'!G16)))","v":-5.5652395065780437E-2},null,null,null,{"$f":"SUM((I57+I25+I39)*'Farrow-Wean Input'!$F$30)/('Farrow-Wean Input'!$H$78++(('Farrow-Wean Input'!$F$9/2)*('Farrow-Wean Input'!F30/365*'Farrow-Wean Input'!G16)))","v":-1.5010074814204162E-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":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,7],[54,0,56,7]]}
["Risk & Sensitivity Analysis"]
[]
[null,null,"Purchased Feed",null,"Home-Mixed Feed"]
[null,null,"Per Pig",null,"Per Pig"]
["A.  Operating Costs"]
[null,"Feed cost",{"$f":"'Farrow-Wean Summary'!E11","v":27.79},null,{"$f":"'Farrow-Wean Summary'!I11","v":21.13}]
[null,"Other Operating Costs",{"$f":"SUM('Farrow-Wean Summary'!E26-'Farrow-Wean Summary'!E11)","v":20.482881929848674},null,{"$f":"SUM('Farrow-Wean Summary'!I26-'Farrow-Wean Summary'!I11)","v":20.363981929848681}]
[null,"Subtotal",{"$f":"SUM(C6:C7)","v":48.272881929848673},null,{"$f":"SUM(E6:E7)","v":41.49398192984868}]
["B.  Fixed Costs",null,{"$f":"'Farrow-Wean Summary'!E40","v":9.6197890999878215},null,{"$f":"'Farrow-Wean Summary'!I40","v":10.136489099987822}]
["C.  Labour",null,{"$f":"'Farrow-Wean Summary'!E43","v":10.26},null,{"$f":"'Farrow-Wean Summary'!I43","v":10.26}]
["Total Costs",null,{"$f":"SUM(C8:C10)","v":68.152671029836497},null,{"$f":"SUM(E8:E10)","v":61.890471029836498}]
[]
["Estimated Farmgate"]
[null,"Price ($ per weanling)",{"$f":"'Farrow-Wean Summary'!E50","v":56},null,{"$f":"'Farrow-Wean Summary'!I50","v":56}]
[null,"Weanlings sold per sow",{"$f":"'Farrow-Wean Input'!G30","v":27.37},null,{"$f":"'Farrow-Wean Input'!G30","v":27.37}]
[]
[]
[null,null,"Up",null,"Down"]
[null,"Percent Market Price Variation",0.1,null,0.1]
[null,"Percent Feed Cost Variation",0.1,null,0.05]
[null,"Weanlings Sold Per Sow ",0.5,null,2.5]
[]
[]
[null,"Higher Price ($ per weanling)",{"$f":"SUM(C14*(1+C19))","v":61.600000000000009},null,{"$f":"SUM(E14*(1+C19))","v":61.600000000000009}]
[null,"Lower Price ($ per weanling)",{"$f":"SUM(C14*(1-E19))","v":50.4},null,{"$f":"SUM(E14*(1-E19))","v":50.4}]
[null,"Higher Feed Cost",{"$f":"SUM(C6+(C6*(C20)))","v":30.568999999999999},null,{"$f":"SUM(E6+(E6*C20))","v":23.242999999999999}]
[null,"Lower Feed Cost",{"$f":"SUM(C6-(C6*E20))","v":26.400500000000001},null,{"$f":"SUM(E6-(E6*E20))","v":20.073499999999999}]
[null,"Higher Weanlings Sold Per Sow",{"$f":"SUM(C15+C21)","v":27.87},null,{"$f":"SUM(E15+C21)","v":27.87}]
[null,"Lower Weanlings Sold Per Sow",{"$f":"SUM(C15-E21)","v":24.87},null,{"$f":"SUM(E15-E21)","v":24.87}]
[]
[]
[{"$f":"\"Higher Margin Scenario - Price Up \"&C19*100&\"%, Feed Price Down \"&E20*100&\"% and Weanlings Sold Per Sow Up \"&C21","v":"Higher Margin Scenario - Price Up 10%, Feed Price Down 5% and Weanlings Sold Per Sow Up 0.5"}]
[null,"Operating Costs",{"$f":"SUM(C7+((C27*'Farrow-Wean Input'!$G$30)/C28))","v":46.409745403117427},null,{"$f":"SUM(E7+((E27*'Farrow-Wean Input'!$G$30)/E28))","v":40.07735455274068}]
[null,"Total Costs",{"$f":"C33+C10+C9","v":66.289534503105244},null,{"$f":"E33+E10+E9","v":60.473843652728497}]
[null,"Gross Revenue / hog",{"$f":"SUM(C24+'Farrow-Wean Summary'!$E$51)","v":61.600000000000009},null,{"$f":"SUM(E24+'Farrow-Wean Summary'!$E$51)","v":61.600000000000009}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C35-C33)","v":15.190254596882582},null,{"$f":"SUM(E35-E33)","v":21.522645447259329}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C35-C33-C10)","v":4.9302545968825822},null,{"$f":"SUM(E35-E33-E10)","v":11.262645447259329}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C35-C34)","v":-4.6895345031052358},null,{"$f":"SUM(E35-E34)","v":1.126156347271511}]
[null,"Operating Expense Ratio",{"$f":"SUM(C33/C35)","v":0.75340495784281525},null,{"$f":"SUM(E33/E35)","v":0.65060640507695899}]
[null,"Return on Asset (ROA)",{"$f":"SUM((C39+'Farrow-Wean Summary'!$E$39+'Farrow-Wean Summary'!$E$25)*'Farrow-Wean Input'!$F$30)/(('Farrow-Wean Input'!$H$78-'Farrow-Wean Input'!H52-'Farrow-Wean Input'!H60)++(('Farrow-Wean Input'!$F$9/2)*('Farrow-Wean Input'!F30/365*'Farrow-Wean Input'!G16)))","v":-7.7798400312232242E-3},null,{"$f":"SUM((E39+'Farrow-Wean Summary'!$E$39+'Farrow-Wean Summary'!$E$25)*'Farrow-Wean Input'!$F$30)/('Farrow-Wean Input'!$H$78++(('Farrow-Wean Input'!$F$9/2)*('Farrow-Wean Input'!F30/365*'Farrow-Wean Input'!G16)))","v":2.8361891225471215E-2}]
[]
[{"$f":"\"Lower Margin Scenario - Price Down \"&E19*100&\"%, Feed Price Up \"&C20*100&\"% and Weanlings Sold Per Sow Down \"&E21","v":"Lower Margin Scenario - Price Down 10%, Feed Price Up 10% and Weanlings Sold Per Sow Down 2.5"}]
[null,"Operating Costs",{"$f":"SUM(C7+((C26*'Farrow-Wean Input'!$G$30)/C29))","v":54.124760900496042},null,{"$f":"SUM(E7+((E26*'Farrow-Wean Input'!$G$30)/E29))","v":45.943431467444171}]
[null,"Total Costs",{"$f":"C9+C10+C44","v":74.00455000048386},null,{"$f":"E9+E10+E44","v":66.339920567431989}]
[null,"Gross Revenue / hog",{"$f":"SUM(C25+'Farrow-Wean Summary'!$E$51)","v":50.4},null,{"$f":"SUM(E25+'Farrow-Wean Summary'!$E$51)","v":50.4}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C46-C44)","v":-3.7247609004960438},null,{"$f":"SUM(E46-E44)","v":4.4565685325558277}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C46-C44-C10)","v":-13.984760900496044},null,{"$f":"SUM(E46-E44-E10)","v":-5.803431467444172}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C46-C45)","v":-23.604550000483862},null,{"$f":"SUM(E46-E45)","v":-15.93992056743199}]
[null,"Operating Expense Ratio",{"$f":"SUM(C44/C46)","v":1.0739039861209532},null,{"$f":"SUM(E44/E46)","v":0.91157602117944792}]
[null,"Return on Asset (ROA)",{"$f":"SUM((C50+'Farrow-Wean Summary'!$E$39+'Farrow-Wean Summary'!$E$25)*'Farrow-Wean Input'!$F$30)/(('Farrow-Wean Input'!$H$78-'Farrow-Wean Input'!H52-'Farrow-Wean Input'!H60)++(('Farrow-Wean Input'!$F$9/2)*('Farrow-Wean Input'!F30/365*'Farrow-Wean Input'!G16)))","v":-0.1291108805574723},null,{"$f":"SUM((E50+'Farrow-Wean Summary'!$E$39+'Farrow-Wean Summary'!$E$25)*'Farrow-Wean Input'!$F$30)/('Farrow-Wean Input'!$H$78++(('Farrow-Wean Input'!$F$9/2)*('Farrow-Wean Input'!F30/365*'Farrow-Wean Input'!G16)))","v":-7.6796151260736814E-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":"Farrow-Wean Input","index":4,"n_rows":163,"n_cols":11,"rows_kept":163,"cut":false,"hidden":false,"merged":[[80,0,80,10],[1,0,1,10],[78,0,78,10],[79,0,79,10]]}
[]
["Farrow to 6kg Pig Production Costs"]
[]
["1."," This input table outlines the production assumptions used."]
["2."," Buildings and equipment are valued at new cost."]
["3."," Manure haulage is contracted out."]
["4."," Gilts are purchased for herd replacement."]
[]
[null,null,"Weanling market price / head",null,null,56]
[]
["Indicators of Productivity"]
[]
["Sows",null,null,null,null,null,600]
["Boars",null,null,null,null,null,3]
["Litters/Sow/Year",null,null,null,null,null,2.375]
["Average Weaning Age (days)",null,null,null,null,null,21]
["Average Born Alive per Litter",null,null,null,null,null,13.5]
["Percent Pre-Weaning Mortality",null,null,null,null,null,12.5]
["Percent Post-Weaning Culls",null,null,null,null,null,2.44]
[]
["Herd Profile",null,null,null,null,"Total","/Sow","/Litter","%Mortality"]
[]
["Sows",null,null,null,null,{"$f":"G13","v":600}]
["Boars",null,null,null,null,{"$f":"G14","v":3}]
["Litters",null,null,null,null,{"$f":"ROUND(G25*F23,0)","v":1425},{"$f":"G15","v":2.375},"",""]
["Pigs Born Alive",null,null,null,null,{"$f":"ROUND(G17*F25,0)","v":19238},{"$f":"ROUND(F26/F23,2)","v":32.06},{"$f":"G17","v":13.5},""]
["Pigs Died, Pre-Weaning",null,null,null,null,{"$f":"ROUND(G18*F26/100,0)","v":2405},{"$f":"ROUND(F27/F23,2)","v":4.01},{"$f":"ROUND(F27/F25,2)","v":1.69},{"$f":"G18","v":12.5}]
["Pigs Weaned",null,null,null,null,{"$f":"F26-F27","v":16833},{"$f":"ROUND(F28/F23,2)","v":28.06},{"$f":"ROUND(F28/F25,2)","v":11.81},""]
["Pigs Culled ",null,null,null,null,{"$f":"ROUND(G19*F28/100,0)","v":411},{"$f":"ROUND(F29/F23,2)","v":0.69},{"$f":"ROUND(F29/F25,2)","v":0.28999999999999998},{"$f":"G19","v":2.44}]
["Weaner Pigs Sold",null,null,null,null,{"$f":"ROUND(F28-F29,0)","v":16422},{"$f":"ROUND(F30/F23,2)","v":27.37},{"$f":"ROUND(F30/F25,2)","v":11.52},""]
[]
["Feed Requirements and Costs",null,null,null,null,null,null,"Purchased","Home-Mixed"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G34:H34)","v":549.75}]
["Sow Gestation Ration",null,null,null,null,3," kg/day",549.75,{"$f":"'Feed-Summary'!H29","v":422.21562500000005}]
["Sow Lactation Ration",null,null,null,null,6.5," kg/day",635,{"$f":"'Feed-Summary'!H54","v":491.92625000000004}]
["Boar Ration",null,null,null,null,3," kg/day",549.75,{"$f":"'Feed-Summary'!H29","v":422.21562500000005}]
["Creep Feed",null,null,null,null,0.5," kg/pig",2000,{"$f":"'Feed-Summary'!H79","v":1093.4091250000001}]
[]
["Labour"]
[]
["Total Hours per 7-day week",null,null,null,null,null,120," hours/week "]
["Wage (includes benefits & hired manager) ",null,null,null,null,null,27," /hour "]
[]
[null,null,null,null,null,"Sow Barn Capital Investment"]
[]
[null,null,null,null,null,null,null,null,null,null,"Your"]
["Buildings",null,null,null,null,"Sq.Ft. ¹","$/Sq.Ft.","Total","/Sow",null,"Cost"]
[null,"Gestation",null,null,null,{"$f":"G13*27","v":16200},64,{"$f":"F48*G48","v":1036800},{"$f":"H48/F23","v":1728}]
[null,"Farrowing",null,null,null,{"$f":"(F28/G15)*1.07","v":7583.7094736842109},43,{"$f":"F49*G49","v":326099.50736842107},{"$f":"H49/F23","v":543.49917894736848}]
[null,"Office & Loading",null,null,null,300,50,{"$f":"F50*G50","v":15000},{"$f":"H50/F23","v":25}]
[null,"Standby Generator",null,null,null,{"$f":"H51","v":25000},null,25000,{"$f":"H51/F23","v":41.666666666666664}]
[null,"Feed Mill (building only)",null,null,null,null,null,45000,{"$f":"H52/F23","v":75}]
["Total Building Cost",null,null,null,null,null,null,{"$f":"SUM(H48:H52)","v":1447899.5073684212},{"$f":"SUM(I48:I51)","v":2338.1658456140349}]
[null,null,null,null,null,null,null,"",""]
["Equipment ¹",null,null,null,null,null,null,"",""]
[null,"Gestation",null,null,null,null,26.5,{"$f":"G56*F48","v":429300},{"$f":"H56/F23","v":715.5}]
[null,"Farrowing",null,null,null,null,26.5,{"$f":"G57*F49","v":200968.30105263158},{"$f":"H57/F23","v":334.94716842105265}]
[null,"Fire Alarm System",null,null,null,null,null,3000,{"$f":"H58/F23","v":5}]
[null,"Feed Bins (4 bins)",null,null,null,null,null,11000,{"$f":"H59/F23","v":18.333333333333332}]
[null,"Feed Mill (equipment only)",null,null,null,null,null,60000,{"$f":"H60/F23","v":100}]
["Total Equipment Cost",null,null,null,null,null,null,{"$f":"SUM(H56:H60)","v":704268.30105263158},{"$f":"SUM(I56:I59)","v":1073.7805017543858}]
["Total Buildings and Equipment Cost",null,null,null,null,null,null,{"$f":"H53+H61","v":2152167.808421053},{"$f":"I53+I61","v":3411.9463473684209}]
[]
["Breeding Stock",null,null,null,null,null,null,""]
[null,"Value of Replacement Sow",null,null,null,350," /sow",{"$f":"F65*F23","v":210000},{"$f":"H65/F23","v":350}]
[null,"Value of Replacement Boar",null,null,null,3500," /boar",{"$f":"F66*F24","v":10500},{"$f":"H66/F23","v":17.5}]
["Total Breeding Stock Cost",null,null,null,null,null,null,{"$f":"SUM(H65:H66)","v":220500},{"$f":"H67/F23","v":367.5}]
[]
["Land Value"]
[null,"Land Investment",null,{"$f":"G153-G154","v":40},"acres @",{"$f":"G156","v":2750},null,{"$f":"D70*F70","v":110000},{"$f":"H70/F23","v":183.33333333333334}]
[null,"Land Investment",null,{"$f":"G154","v":0},"acres @",{"$f":"G156","v":2750},null,{"$f":"D71*F71","v":0},{"$f":"H71/F24","v":0}]
[]
["Other Costs"]
[null,"Site Preparation",null,null,null,null,null,36000,{"$f":"H74/F23","v":60}]
[null,"Manure Storage",null,null,null,null,null,120000,{"$f":"H75/F23","v":200}]
["Total Other Costs",null,null,null,null,null,null,{"$f":"SUM(H74:H75)","v":156000},{"$f":"SUM(I74:I75)","v":260}]
[]
["Total Capital Investment",null,null,null,null,null,null,{"$f":"H62+H67+H70+H71+H76","v":2638667.808421053},{"$f":"H78/F23","v":4397.7796807017548}]
["¹ FOOTNOTE: The number of sqare feet allocated for buildings and equipment are approximations.   "]
[" Cost per sow for buildings and equipment will vary around the province."]
["FOOTNOTE: 1 sq.ft. = 0.0929 sq.m;  1 sq.m.= 10.764 sq.ft.;  1 ft.= 0.3048 m"]
[]
[]
["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,"%"]
[]
[]
["Veterinary Costs: Professional Services",null,null,null,null,null,9,"/sow"]
[null,null,"                  Medication",null,null,null,24,"/sow"]
[]
["Maintenance & Repair",null,null,null,null,null,1.5,"% of Total Capital Investment"]
[]
["Hydro & Propane ",null,null,null,"Hydro rate",null,9.2340000000000005E-2,"per kwhr"]
[null,null,null,null,"Hydro usage",null,267000,"kwhr"]
[null,null,null,null,"Propane rate",null,0.75,"total propane"]
[null,null,null,null,"Propane usage",null,50000,"litres"]
[]
["Insurance"]
[null,null,"Buildings & equipment",null,null,null,0.78,"/$100 Capital Invested"]
[null,null,"Breeding Stock & weaners",null,null,null,0.88,"/$100 Capital Invested"]
[null,null,"Business Interruption",null,null,null,0.78,"/$100 Capital Invested"]
[null,null,"Business Interruption based on ",null,null,null,1200,"/Sow"]
[null,null,"Weaner Value",null,null,null,56,"/Weaner"]
[]
["Manure Costs:",null,null,"Storage volume",null,null,22.7,"litres/sow/day ³"]
[null,null,null,"Haulage Cost",null,null,2.8999999999999998E-3,"/litre"]
[null,null,null,null,null,null,{"$f":"G113*4.56409","v":1.3235861E-2},"/gallon"]
[]
[null,null,null,"Odour control (barley straw)",null,null,0," total cost"]
[null,null,null,"Manure Management Fee",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.09,0.77,60]
[null,null,"Phosphate (P2O5)",null,null,0.56000000000000005,0.89,0]
[null,null,"Potassium",null,null,0.89,0.6,0]
[null,null,null,null,"* kg/1000 L x 10 = lbs/1000 imp. Gallons"]
[]
["Office Supplies",null,null,"Estimated rate per sow",null,null,2,"$/sow"]
[]
["Marketing & Transportation",null,null,null,null,null,3.5,"/weaner pig sold"]
["Board Levy",null,null,null,null,null,0.19,"/weaner pig sold"]
[]
["Breeding Herd Replacement:",null,null,null,null,null,42,"% of sows replaced per year"]
[null,"Cull Sow Weight",null,null,null,null,180,"kg"]
[null,"Cull Sow Price (live weight)",null,null,null,null,77.28,"/100kg"]
[null,"Cull Sow Price (dress weight)",null,null,null,null,{"$f":"ROUND(+G134/0.8,2)","v":96.6},"/100kg"]
[null,"Value of Replacement Sow",null,null,null,null,350,"/sow"]
[]
["Boar Replacement Rate:",null,null,null,null,null,50,"% of boars replaced per year"]
[null,"Cull Boar Weight",null,null,null,null,225,"kg"]
[null,"Cull Boar Price (live weight)",null,null,null,null,{"$f":"G134*0.714","v":55.17792},"/100kg "]
[null,"Cull Boar Price (dress weight)",null,null,null,null,{"$f":"G140/0.8","v":68.972399999999993},"/100kg "]
[null,"Value of Replacement Boar",null,null,null,null,3500," /boar"]
[]
["Breeding Costs"]
[null,null,"Number of services/sow",null,null,null,2.2000000000000002]
[null,null,"Cost/dose (semen)",null,null,null,11]
[]
["Property Tax:"]
[null,null,"Farrow-weanling barn & land",null,null,null,7500,"/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 (income)",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":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,0,1,7]]}
[]
["Feed Ingredient Costs"]
[]
[null,"Ingredients",null,null,"Price/tonne",null,"Your Cost"]
[null,"  Wheat",null,null,370]
[null,"  Barley",null,null,320]
[null,"  Corn ",null,null,355]
[null,"  Soybean Meal ",null,null,665]
[null,"  Canola Meal ",null,null,425]
[null,"  Peas",null,null,390]
[null,"  Sow Micro",null,null,6000]
[null,"  Canola Oil",null,null,2400]
[null,"  Whey Powder ",null,null,1364.6]
[null,"  Fish Meal",null,null,3364.4]
[null,"  Plasma",null,null,5720]
[null,"  Limestone",null,null,203.95]
[null,"  Dical (16% Ca-21% P) ",null,null,1544.23]
[null,"  Salt - 96%",null,null,261.89999999999998]
[null,"  Phytase",null,null,14500]
[null,"  L-Lysine HCL",null,null,2248.5]
[null,"  L-Threonine ",null,null,2815.6]
[null,"  DL-Methionine",null,null,3850.2]
[null,"  Oats - groats",null,null,375]
[null,"  Processing Cost"]
[null,"  (Hydro,repairs/maintenance & insurance)",null,null,10]
[null,"  Percent Weight loss due to processing",null,null,1.25,"%"]
[null,"  Labour Cost",null,null,10]
[]
[null,"Ration Formulas",null,"Dry","Nursing","Boar","Creep"]
[null,null,null,"Sow","Sow","Ration","Ration"]
[null,null,null,"(kg)","(kg)","(kg)","(kg)"]
[null,{"$f":"B5","v":"  Wheat"},null,259,568.70000000000005,233.64,0]
[null,"  Barley",null,539,200,539,0]
[null,"  Corn ",null,0,0,0,139.75]
[null,"  Soybean Meal ",null,0,196,0,116.59]
[null,"  Canola Meal ",null,80,0,102,0]
[null,"  Peas",null,91,0,91,0]
[null,{"$f":"B11","v":"  Sow Micro"},null,5,5,5,5]
[null,{"$f":"B12","v":"  Canola Oil"},null,0,0,0,20]
[null,"  Whey Powder ",null,0,0,0,100]
[null,"  Fish Meal",null,0,0,0,60]
[null,"  Plasma",null,0,0,0,58]
[null,"  Limestone",null,10,12,12,12.23]
[null,"  Dical (16% Ca-21% P) ",null,11,12,12,9.43]
[null,"  Salt - 96%",null,3.5,5,3.5,3.5]
[null,"  Phytase",null,0.5,0.5,0.5,0]
[null,"  L-Lysine HCL",null,1,0.8,1.36,0.5]
[null,"  L-Threonine ",null,0,0,0,0]
[null,"  DL-Methionine",null,0,0,0,0]
[null,"  Oats - groats",null,0,0,0,475]
[null,"TOTAL (kg)",null,{"$f":"SUM(D32:D50)","v":1000},{"$f":"SUM(E32:E50)","v":1000},{"$f":"SUM(F32:F50)","v":1000},{"$f":"SUM(G32:G50)","v":1000}]
[]
[]
[null,"Total Feed per Sow",null,"Dry","Nursing"]
[null,null,null,"Sow","Sow","Boar","Creep"]
[null,null,null,"Ration","Ration","Ration","Ration","Total"]
[null,null,null,"(tonnes)","(kg/sow)","(kg)","(kg)","(kg)"]
[null,{"$f":"B5","v":"  Wheat"},null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D32/1000)*'Farrow-Wean Input'!$G$13/1000","v":146.91127499999999},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E32/1000)*'Farrow-Wean Input'!$G$13/1000","v":110.61925875000003},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F32/1000))*'Farrow-Wean Input'!$G$14/1000","v":0.76750739999999995},{"$f":"('Farrow-Wean Input'!$F$37*(G32/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},{"$f":"SUM(D58:G58)","v":258.29804115000002}]
[null,"  Barley",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D33/1000)*'Farrow-Wean Input'!$G$13/1000","v":305.73427499999997},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E33/1000)*'Farrow-Wean Input'!$G$13/1000","v":38.902500000000003},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F33/1000))*'Farrow-Wean Input'!$G$14/1000","v":1.7706150000000003},{"$f":"('Farrow-Wean Input'!$F$37*(G33/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},{"$f":"SUM(D59:G59)","v":346.40738999999996}]
[null,"  Corn ",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D34/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E34/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F34/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G34/1000))*'Farrow-Wean Input'!$F$28/1000","v":1.1762058750000002},{"$f":"SUM(D60:G60)","v":1.1762058750000002}]
[null,"  Soybean Meal ",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D35/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E35/1000)*'Farrow-Wean Input'!$G$13/1000","v":38.124450000000003},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F35/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G35/1000))*'Farrow-Wean Input'!$F$28/1000","v":0.98127973499999999},39.105729735000004]
[null,"  Canola Meal ",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D36/1000)*'Farrow-Wean Input'!$G$13/1000","v":45.378},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E36/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F36/1000))*'Farrow-Wean Input'!$G$14/1000","v":0.33506999999999998},{"$f":"('Farrow-Wean Input'!$F$37*(G36/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},45.713070000000002]
[null,"  Peas",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D37/1000)*'Farrow-Wean Input'!$G$13/1000","v":51.617474999999999},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E37/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F37/1000))*'Farrow-Wean Input'!$G$14/1000","v":0.29893500000000001},{"$f":"('Farrow-Wean Input'!$F$37*(G37/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},51.916409999999999]
[null,{"$f":"B11","v":"  Sow Micro"},null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D38/1000)*'Farrow-Wean Input'!$G$13/1000","v":2.836125},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E38/1000)*'Farrow-Wean Input'!$G$13/1000","v":0.9725625},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F38/1000))*'Farrow-Wean Input'!$G$14/1000","v":1.6425000000000002E-2},{"$f":"('Farrow-Wean Input'!$F$37*(G38/1000))*'Farrow-Wean Input'!$F$28/1000","v":4.2082500000000002E-2},3.8671949999999997]
[null,{"$f":"B12","v":"  Canola Oil"},null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D39/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E39/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F39/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G39/1000))*'Farrow-Wean Input'!$F$28/1000","v":0.16833000000000001},0.16833000000000001]
[null,"  Whey Powder ",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D40/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E40/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F40/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G40/1000))*'Farrow-Wean Input'!$F$28/1000","v":0.84165000000000012},0.84165000000000012]
[null,"  Fish Meal",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D41/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E41/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F41/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G41/1000))*'Farrow-Wean Input'!$F$28/1000","v":0.50499000000000005},0.50499000000000005]
[null,"  Plasma",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D42/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E42/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F42/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G42/1000))*'Farrow-Wean Input'!$F$28/1000","v":0.48815700000000006},0.48815700000000006]
[null,"  Limestone",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D43/1000)*'Farrow-Wean Input'!$G$13/1000","v":5.67225},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E43/1000)*'Farrow-Wean Input'!$G$13/1000","v":2.3341500000000002},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F43/1000))*'Farrow-Wean Input'!$G$14/1000","v":3.9420000000000004E-2},{"$f":"('Farrow-Wean Input'!$F$37*(G43/1000))*'Farrow-Wean Input'!$F$28/1000","v":0.10293379500000002},8.1487537949999993]
[null,"  Dical (16% Ca-21% P) ",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D44/1000)*'Farrow-Wean Input'!$G$13/1000","v":6.2394749999999997},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E44/1000)*'Farrow-Wean Input'!$G$13/1000","v":2.3341500000000002},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F44/1000))*'Farrow-Wean Input'!$G$14/1000","v":3.9420000000000004E-2},{"$f":"('Farrow-Wean Input'!$F$37*(G44/1000))*'Farrow-Wean Input'!$F$28/1000","v":7.9367594999999999E-2},8.6924125950000004]
[null,"  Salt - 96%",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D45/1000)*'Farrow-Wean Input'!$G$13/1000","v":1.9852875000000001},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E45/1000)*'Farrow-Wean Input'!$G$13/1000","v":0.9725625},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F45/1000))*'Farrow-Wean Input'!$G$14/1000","v":1.1497500000000001E-2},{"$f":"('Farrow-Wean Input'!$F$37*(G45/1000))*'Farrow-Wean Input'!$F$28/1000","v":2.9457750000000001E-2},2.9988052500000002]
[null,"  Phytase",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D46/1000)*'Farrow-Wean Input'!$G$13/1000","v":0.28361249999999999},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E46/1000)*'Farrow-Wean Input'!$G$13/1000","v":9.7256250000000002E-2},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F46/1000))*'Farrow-Wean Input'!$G$14/1000","v":1.6425000000000001E-3},{"$f":"('Farrow-Wean Input'!$F$37*(G46/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},0.38251124999999997]
[null,"  L-Lysine HCL",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D47/1000)*'Farrow-Wean Input'!$G$13/1000","v":0.56722499999999998},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E47/1000)*'Farrow-Wean Input'!$G$13/1000","v":0.15561000000000003},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F47/1000))*'Farrow-Wean Input'!$G$14/1000","v":4.4676000000000004E-3},{"$f":"('Farrow-Wean Input'!$F$37*(G47/1000))*'Farrow-Wean Input'!$F$28/1000","v":4.2082500000000002E-3},0.73151085000000005]
[null,"  L-Threonine ",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D48/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E48/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F48/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G48/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},0]
[null,"  DL-Methionine",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D49/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E49/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F49/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G49/1000))*'Farrow-Wean Input'!$F$28/1000","v":0},0]
[null,"  Oats - groats",null,{"$f":"((365-'Weaner-Worksheet'!$D$11)*'Farrow-Wean Input'!$F$34*D50/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"('Farrow-Wean Input'!$G$16*'Farrow-Wean Input'!$G$15*'Farrow-Wean Input'!$F$35*E50/1000)*'Farrow-Wean Input'!$G$13/1000","v":0},{"$f":"(365*'Farrow-Wean Input'!$F$36*(F50/1000))*'Farrow-Wean Input'!$G$14/1000","v":0},{"$f":"('Farrow-Wean Input'!$F$37*(G50/1000))*'Farrow-Wean Input'!$F$28/1000","v":3.9978374999999997},3.9978374999999997]
[null,"Total Ration (kg/sow/year)",null,{"$f":"SUM(D58:D76)","v":567.22499999999991},{"$f":"SUM(E58:E76)","v":194.51250000000002},{"$f":"SUM(F58:F76)","v":3.2849999999999997},{"$f":"SUM(G58:G76)","v":8.4164999999999992},{"$f":"SUM(H58:H76)","v":773.43899999999985}]

{"sheet":"Feed-Summary","index":6,"n_rows":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
[]
["Feed Requirement and Cost Summary"]
[]
[null,null,null,null,null,"Ingredient",null,"Ration"]
[null,null,null,"Amount",null,"    Price",null,"Cost"]
["Sow Gestation & Boar Ration:",null,null,"       (kg)",null,"($ /tonne)",null,"($ /tonne)",null,"Your Cost"]
[{"$f":"'Feed-Cost'!B5","v":"  Wheat"},null,null,{"$f":"IF('Feed-Cost'!D32=0,\" \",'Feed-Cost'!D32)","v":259},null,{"$f":"IF('Feed-Cost'!D32=0,\" \",'Feed-Cost'!E5)","v":370},null,{"$f":"IF('Feed-Cost'!D32=0,\" \",ROUND((D7/1000)*F7,2))","v":95.83}]
[{"$f":"'Feed-Cost'!B6","v":"  Barley"},null,null,{"$f":"IF('Feed-Cost'!D33=0,\" \",'Feed-Cost'!D33)","v":539},null,{"$f":"IF('Feed-Cost'!D33=0,\" \",'Feed-Cost'!E6)","v":320},null,{"$f":"IF('Feed-Cost'!D33=0,\" \",ROUND((D8/1000)*F8,2))","v":172.48}]
[{"$f":"'Feed-Cost'!B7","v":"  Corn "},null,null,{"$f":"IF('Feed-Cost'!D34=0,\" \",'Feed-Cost'!D34)","v":" "},null,{"$f":"IF('Feed-Cost'!D34=0,\" \",'Feed-Cost'!E7)","v":" "},null,{"$f":"IF('Feed-Cost'!D34=0,\" \",ROUND((D9/1000)*F9,2))","v":" "}]
[{"$f":"'Feed-Cost'!B8","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed-Cost'!D35=0,\" \",'Feed-Cost'!D35)","v":" "},null,{"$f":"IF('Feed-Cost'!D35=0,\" \",'Feed-Cost'!E8)","v":" "},null,{"$f":"IF('Feed-Cost'!D35=0,\" \",ROUND((D10/1000)*F10,2))","v":" "}]
[{"$f":"'Feed-Cost'!B9","v":"  Canola Meal "},null,null,{"$f":"IF('Feed-Cost'!D36=0,\" \",'Feed-Cost'!D36)","v":80},null,{"$f":"IF('Feed-Cost'!D36=0,\" \",'Feed-Cost'!E9)","v":425},null,{"$f":"IF('Feed-Cost'!D36=0,\" \",ROUND((D11/1000)*F11,2))","v":34}]
[{"$f":"'Feed-Cost'!B10","v":"  Peas"},null,null,{"$f":"IF('Feed-Cost'!D37=0,\" \",'Feed-Cost'!D37)","v":91},null,{"$f":"IF('Feed-Cost'!D37=0,\" \",'Feed-Cost'!E10)","v":390},null,{"$f":"IF('Feed-Cost'!D37=0,\" \",ROUND((D12/1000)*F12,2))","v":35.49}]
[{"$f":"'Feed-Cost'!B11","v":"  Sow Micro"},null,null,{"$f":"IF('Feed-Cost'!D38=0,\" \",'Feed-Cost'!D38)","v":5},null,{"$f":"IF('Feed-Cost'!D38=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!D38=0,\" \",ROUND((D13/1000)*F13,2))","v":30}]
[{"$f":"'Feed-Cost'!B12","v":"  Canola Oil"},null,null,{"$f":"IF('Feed-Cost'!D39=0,\" \",'Feed-Cost'!D39)","v":" "},null,{"$f":"IF('Feed-Cost'!D39=0,\" \",'Feed-Cost'!E12)","v":" "},null,{"$f":"IF('Feed-Cost'!D39=0,\" \",ROUND((D14/1000)*F14,2))","v":" "}]
[{"$f":"'Feed-Cost'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed-Cost'!D40=0,\" \",'Feed-Cost'!D40)","v":" "},null,{"$f":"IF('Feed-Cost'!D40=0,\" \",'Feed-Cost'!E13)","v":" "},null,{"$f":"IF('Feed-Cost'!D40=0,\" \",ROUND((D15/1000)*F15,2))","v":" "}]
[{"$f":"'Feed-Cost'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed-Cost'!D41=0,\" \",'Feed-Cost'!D41)","v":" "},null,{"$f":"IF('Feed-Cost'!D41=0,\" \",'Feed-Cost'!E14)","v":" "},null,{"$f":"IF('Feed-Cost'!D41=0,\" \",ROUND((D16/1000)*F16,2))","v":" "}]
[{"$f":"'Feed-Cost'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed-Cost'!D42=0,\" \",'Feed-Cost'!D42)","v":" "},null,{"$f":"IF('Feed-Cost'!D42=0,\" \",'Feed-Cost'!E15)","v":" "},null,{"$f":"IF('Feed-Cost'!D42=0,\" \",ROUND((D17/1000)*F17,2))","v":" "}]
[{"$f":"'Feed-Cost'!B16","v":"  Limestone"},null,null,{"$f":"IF('Feed-Cost'!D43=0,\" \",'Feed-Cost'!D43)","v":10},null,{"$f":"IF('Feed-Cost'!D43=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!D43=0,\" \",ROUND((D18/1000)*F18,2))","v":2.04}]
[{"$f":"'Feed-Cost'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed-Cost'!D44=0,\" \",'Feed-Cost'!D44)","v":11},null,{"$f":"IF('Feed-Cost'!D44=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!D44=0,\" \",ROUND((D19/1000)*F19,2))","v":16.989999999999998}]
[{"$f":"'Feed-Cost'!B18","v":"  Salt - 96%"},null,null,{"$f":"IF('Feed-Cost'!D45=0,\" \",'Feed-Cost'!D45)","v":3.5},null,{"$f":"IF('Feed-Cost'!D45=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!D45=0,\" \",ROUND((D20/1000)*F20,2))","v":0.92}]
[{"$f":"'Feed-Cost'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed-Cost'!D46=0,\" \",'Feed-Cost'!D46)","v":0.5},null,{"$f":"IF('Feed-Cost'!D46=0,\" \",'Feed-Cost'!E19)","v":14500},null,{"$f":"IF('Feed-Cost'!D46=0,\" \",ROUND((D21/1000)*F21,2))","v":7.25}]
[{"$f":"'Feed-Cost'!B20","v":"  L-Lysine HCL"},null,null,{"$f":"IF('Feed-Cost'!D47=0,\" \",'Feed-Cost'!D47)","v":1},null,{"$f":"IF('Feed-Cost'!D47=0,\" \",'Feed-Cost'!E20)","v":2248.5},null,{"$f":"IF('Feed-Cost'!D47=0,\" \",ROUND((D22/1000)*F22,2))","v":2.25}]
[{"$f":"'Feed-Cost'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed-Cost'!D48=0,\" \",'Feed-Cost'!D48)","v":" "},null,{"$f":"IF('Feed-Cost'!D48=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!D48=0,\" \",ROUND((D23/1000)*F23,2))","v":" "}]
[{"$f":"'Feed-Cost'!B22","v":"  DL-Methionine"},null,null,{"$f":"IF('Feed-Cost'!D49=0,\" \",'Feed-Cost'!D49)","v":" "},null,{"$f":"IF('Feed-Cost'!D49=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!D49=0,\" \",ROUND((D24/1000)*F24,2))","v":" "}]
[{"$f":"'Feed-Cost'!B23","v":"  Oats - groats"},null,null,{"$f":"IF('Feed-Cost'!D50=0,\" \",'Feed-Cost'!D50)","v":" "},null,{"$f":"IF('Feed-Cost'!D50=0,\" \",'Feed-Cost'!E23)","v":" "},null,{"$f":"IF('Feed-Cost'!D50=0,\" \",ROUND((D25/1000)*F25,2))","v":" "}]
["Total Dry Sow",null,null,{"$f":"SUM(D7:D25)","v":1000},"kg ",null,null,{"$f":"SUM(H7:H25)","v":397.25000000000006}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H26+(F27*H26/100)","v":402.21562500000005}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H27=0,0,H27+F28)","v":412.21562500000005}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"IF(H27=0,0,H28+F29)","v":422.21562500000005}]
[]
["Sow Lactation:"]
[{"$f":"'Feed-Cost'!B5","v":"  Wheat"},null,null,{"$f":"IF('Feed-Cost'!E32=0,\" \",'Feed-Cost'!E32)","v":568.70000000000005},null,{"$f":"IF('Feed-Cost'!E32=0,\" \",'Feed-Cost'!E5)","v":370},null,{"$f":"IF('Feed-Cost'!E32=0,\" \",ROUND((D32/1000)*F32,2))","v":210.42}]
[{"$f":"'Feed-Cost'!B6","v":"  Barley"},null,null,{"$f":"IF('Feed-Cost'!E33=0,\" \",'Feed-Cost'!E33)","v":200},null,{"$f":"IF('Feed-Cost'!E33=0,\" \",'Feed-Cost'!E6)","v":320},null,{"$f":"IF('Feed-Cost'!E33=0,\" \",ROUND((D33/1000)*F33,2))","v":64}]
[{"$f":"'Feed-Cost'!B7","v":"  Corn "},null,null,{"$f":"IF('Feed-Cost'!E34=0,\" \",'Feed-Cost'!E34)","v":" "},null,{"$f":"IF('Feed-Cost'!E34=0,\" \",'Feed-Cost'!E7)","v":" "},null,{"$f":"IF('Feed-Cost'!E34=0,\" \",ROUND((D34/1000)*F34,2))","v":" "}]
[{"$f":"'Feed-Cost'!B8","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed-Cost'!E35=0,\" \",'Feed-Cost'!E35)","v":196},null,{"$f":"IF('Feed-Cost'!E35=0,\" \",'Feed-Cost'!E8)","v":665},null,{"$f":"IF('Feed-Cost'!E35=0,\" \",ROUND((D35/1000)*F35,2))","v":130.34}]
[{"$f":"'Feed-Cost'!B9","v":"  Canola Meal "},null,null,{"$f":"IF('Feed-Cost'!E36=0,\" \",'Feed-Cost'!E36)","v":" "},null,{"$f":"IF('Feed-Cost'!E36=0,\" \",'Feed-Cost'!E9)","v":" "},null,{"$f":"IF('Feed-Cost'!E36=0,\" \",ROUND((D36/1000)*F36,2))","v":" "}]
[{"$f":"'Feed-Cost'!B10","v":"  Peas"},null,null,{"$f":"IF('Feed-Cost'!E37=0,\" \",'Feed-Cost'!E37)","v":" "},null,{"$f":"IF('Feed-Cost'!E37=0,\" \",'Feed-Cost'!E10)","v":" "},null,{"$f":"IF('Feed-Cost'!E37=0,\" \",ROUND((D37/1000)*F37,2))","v":" "}]
[{"$f":"'Feed-Cost'!B11","v":"  Sow Micro"},null,null,{"$f":"IF('Feed-Cost'!E38=0,\" \",'Feed-Cost'!E38)","v":5},null,{"$f":"IF('Feed-Cost'!E38=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!E38=0,\" \",ROUND((D38/1000)*F38,2))","v":30}]
[{"$f":"'Feed-Cost'!B12","v":"  Canola Oil"},null,null,{"$f":"IF('Feed-Cost'!E39=0,\" \",'Feed-Cost'!E39)","v":" "},null,{"$f":"IF('Feed-Cost'!E39=0,\" \",'Feed-Cost'!E12)","v":" "},null,{"$f":"IF('Feed-Cost'!E39=0,\" \",ROUND((D39/1000)*F39,2))","v":" "}]
[{"$f":"'Feed-Cost'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed-Cost'!E40=0,\" \",'Feed-Cost'!E40)","v":" "},null,{"$f":"IF('Feed-Cost'!E40=0,\" \",'Feed-Cost'!E13)","v":" "},null,{"$f":"IF('Feed-Cost'!E40=0,\" \",ROUND((D40/1000)*F40,2))","v":" "}]
[{"$f":"'Feed-Cost'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed-Cost'!E41=0,\" \",'Feed-Cost'!E41)","v":" "},null,{"$f":"IF('Feed-Cost'!E41=0,\" \",'Feed-Cost'!E14)","v":" "},null,{"$f":"IF('Feed-Cost'!E41=0,\" \",ROUND((D41/1000)*F41,2))","v":" "}]
[{"$f":"'Feed-Cost'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed-Cost'!E42=0,\" \",'Feed-Cost'!E42)","v":" "},null,{"$f":"IF('Feed-Cost'!E42=0,\" \",'Feed-Cost'!E15)","v":" "},null,{"$f":"IF('Feed-Cost'!E42=0,\" \",ROUND((D42/1000)*F42,2))","v":" "}]
[{"$f":"'Feed-Cost'!B16","v":"  Limestone"},null,null,{"$f":"IF('Feed-Cost'!E43=0,\" \",'Feed-Cost'!E43)","v":12},null,{"$f":"IF('Feed-Cost'!E43=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!E43=0,\" \",ROUND((D43/1000)*F43,2))","v":2.4500000000000002}]
[{"$f":"'Feed-Cost'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed-Cost'!E44=0,\" \",'Feed-Cost'!E44)","v":12},null,{"$f":"IF('Feed-Cost'!E44=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!E44=0,\" \",ROUND((D44/1000)*F44,2))","v":18.53}]
[{"$f":"'Feed-Cost'!B18","v":"  Salt - 96%"},null,null,{"$f":"IF('Feed-Cost'!E45=0,\" \",'Feed-Cost'!E45)","v":5},null,{"$f":"IF('Feed-Cost'!E45=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!E45=0,\" \",ROUND((D45/1000)*F45,2))","v":1.31}]
[{"$f":"'Feed-Cost'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed-Cost'!E46=0,\" \",'Feed-Cost'!E46)","v":0.5},null,{"$f":"IF('Feed-Cost'!E46=0,\" \",'Feed-Cost'!E19)","v":14500},null,{"$f":"IF('Feed-Cost'!E46=0,\" \",ROUND((D46/1000)*F46,2))","v":7.25}]
[{"$f":"'Feed-Cost'!B20","v":"  L-Lysine HCL"},null,null,{"$f":"IF('Feed-Cost'!E47=0,\" \",'Feed-Cost'!E47)","v":0.8},null,{"$f":"IF('Feed-Cost'!E47=0,\" \",'Feed-Cost'!E20)","v":2248.5},null,{"$f":"IF('Feed-Cost'!E47=0,\" \",ROUND((D47/1000)*F47,2))","v":1.8}]
[{"$f":"'Feed-Cost'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed-Cost'!E48=0,\" \",'Feed-Cost'!E48)","v":" "},null,{"$f":"IF('Feed-Cost'!E48=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!E48=0,\" \",ROUND((D48/1000)*F48,2))","v":" "}]
[{"$f":"'Feed-Cost'!B22","v":"  DL-Methionine"},null,null,{"$f":"IF('Feed-Cost'!E49=0,\" \",'Feed-Cost'!E49)","v":" "},null,{"$f":"IF('Feed-Cost'!E49=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!E49=0,\" \",ROUND((D49/1000)*F49,2))","v":" "}]
[{"$f":"'Feed-Cost'!B23","v":"  Oats - groats"},null,null,{"$f":"IF('Feed-Cost'!E50=0,\" \",'Feed-Cost'!E50)","v":" "},null,{"$f":"IF('Feed-Cost'!E50=0,\" \",'Feed-Cost'!E23)","v":" "},null,{"$f":"IF('Feed-Cost'!E50=0,\" \",ROUND((D50/1000)*F50,2))","v":" "}]
["Total Nursing Sow",null,null,{"$f":"SUM(D32:D50)","v":1000},"kg",null,null,{"$f":"SUM(H32:H50)","v":466.1}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H51+(F52*H51/100)","v":471.92625000000004}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H52=0,0,H52+F53)","v":481.92625000000004}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"IF(F52=0,0,H53+F54)","v":491.92625000000004}]
[]
["Creep Ration:"]
[{"$f":"'Feed-Cost'!B5","v":"  Wheat"},null,null,{"$f":"IF('Feed-Cost'!G32=0,\" \",'Feed-Cost'!G32)","v":" "},null,{"$f":"IF('Feed-Cost'!G32=0,\" \",'Feed-Cost'!E5)","v":" "},null,{"$f":"IF('Feed-Cost'!G32=0,\" \",ROUND((D57/1000)*F57,2))","v":" "}]
[{"$f":"'Feed-Cost'!B6","v":"  Barley"},null,null,{"$f":"IF('Feed-Cost'!G33=0,\" \",'Feed-Cost'!G33)","v":" "},null,{"$f":"IF('Feed-Cost'!G33=0,\" \",'Feed-Cost'!E6)","v":" "},null,{"$f":"IF('Feed-Cost'!G33=0,\" \",ROUND((D58/1000)*F58,2))","v":" "}]
[{"$f":"'Feed-Cost'!B7","v":"  Corn "},null,null,{"$f":"IF('Feed-Cost'!G34=0,\" \",'Feed-Cost'!G34)","v":139.75},null,{"$f":"IF('Feed-Cost'!G34=0,\" \",'Feed-Cost'!E7)","v":355},null,{"$f":"IF('Feed-Cost'!G34=0,\" \",ROUND((D59/1000)*F59,2))","v":49.61}]
[{"$f":"'Feed-Cost'!B8","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed-Cost'!G35=0,\" \",'Feed-Cost'!G35)","v":116.59},null,{"$f":"IF('Feed-Cost'!G35=0,\" \",'Feed-Cost'!E8)","v":665},null,{"$f":"IF('Feed-Cost'!G35=0,\" \",ROUND((D60/1000)*F60,2))","v":77.53}]
[{"$f":"'Feed-Cost'!B9","v":"  Canola Meal "},null,null,{"$f":"IF('Feed-Cost'!G36=0,\" \",'Feed-Cost'!G36)","v":" "},null,{"$f":"IF('Feed-Cost'!G36=0,\" \",'Feed-Cost'!E9)","v":" "},null,{"$f":"IF('Feed-Cost'!G36=0,\" \",ROUND((D61/1000)*F61,2))","v":" "}]
[{"$f":"'Feed-Cost'!B10","v":"  Peas"},null,null,{"$f":"IF('Feed-Cost'!G37=0,\" \",'Feed-Cost'!G37)","v":" "},null,{"$f":"IF('Feed-Cost'!G37=0,\" \",'Feed-Cost'!E10)","v":" "},null,{"$f":"IF('Feed-Cost'!G37=0,\" \",ROUND((D62/1000)*F62,2))","v":" "}]
[{"$f":"'Feed-Cost'!B11","v":"  Sow Micro"},null,null,{"$f":"IF('Feed-Cost'!G38=0,\" \",'Feed-Cost'!G38)","v":5},null,{"$f":"IF('Feed-Cost'!G38=0,\" \",'Feed-Cost'!E11)","v":6000},null,{"$f":"IF('Feed-Cost'!G38=0,\" \",ROUND((D63/1000)*F63,2))","v":30}]
[{"$f":"'Feed-Cost'!B12","v":"  Canola Oil"},null,null,{"$f":"IF('Feed-Cost'!G39=0,\" \",'Feed-Cost'!G39)","v":20},null,{"$f":"IF('Feed-Cost'!G39=0,\" \",'Feed-Cost'!E12)","v":2400},null,{"$f":"IF('Feed-Cost'!G39=0,\" \",ROUND((D64/1000)*F64,2))","v":48}]
[{"$f":"'Feed-Cost'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed-Cost'!G40=0,\" \",'Feed-Cost'!G40)","v":100},null,{"$f":"IF('Feed-Cost'!G40=0,\" \",'Feed-Cost'!E13)","v":1364.6},null,{"$f":"IF('Feed-Cost'!G40=0,\" \",ROUND((D65/1000)*F65,2))","v":136.46}]
[{"$f":"'Feed-Cost'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed-Cost'!G41=0,\" \",'Feed-Cost'!G41)","v":60},null,{"$f":"IF('Feed-Cost'!G41=0,\" \",'Feed-Cost'!E14)","v":3364.4},null,{"$f":"IF('Feed-Cost'!G41=0,\" \",ROUND((D66/1000)*F66,2))","v":201.86}]
[{"$f":"'Feed-Cost'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed-Cost'!G42=0,\" \",'Feed-Cost'!G42)","v":58},null,{"$f":"IF('Feed-Cost'!G42=0,\" \",'Feed-Cost'!E15)","v":5720},null,{"$f":"IF('Feed-Cost'!G42=0,\" \",ROUND((D67/1000)*F67,2))","v":331.76}]
[{"$f":"'Feed-Cost'!B16","v":"  Limestone"},null,null,{"$f":"IF('Feed-Cost'!G43=0,\" \",'Feed-Cost'!G43)","v":12.23},null,{"$f":"IF('Feed-Cost'!G43=0,\" \",'Feed-Cost'!E16)","v":203.95},null,{"$f":"IF('Feed-Cost'!G43=0,\" \",ROUND((D68/1000)*F68,2))","v":2.4900000000000002}]
[{"$f":"'Feed-Cost'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed-Cost'!G44=0,\" \",'Feed-Cost'!G44)","v":9.43},null,{"$f":"IF('Feed-Cost'!G44=0,\" \",'Feed-Cost'!E17)","v":1544.23},null,{"$f":"IF('Feed-Cost'!G44=0,\" \",ROUND((D69/1000)*F69,2))","v":14.56}]
[{"$f":"'Feed-Cost'!B18","v":"  Salt - 96%"},null,null,{"$f":"IF('Feed-Cost'!G45=0,\" \",'Feed-Cost'!G45)","v":3.5},null,{"$f":"IF('Feed-Cost'!G45=0,\" \",'Feed-Cost'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed-Cost'!G45=0,\" \",ROUND((D70/1000)*F70,2))","v":0.92}]
[{"$f":"'Feed-Cost'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed-Cost'!G46=0,\" \",'Feed-Cost'!G46)","v":" "},null,{"$f":"IF('Feed-Cost'!G46=0,\" \",'Feed-Cost'!E19)","v":" "},null,{"$f":"IF('Feed-Cost'!G46=0,\" \",ROUND((D71/1000)*F71,2))","v":" "}]
[{"$f":"'Feed-Cost'!B20","v":"  L-Lysine HCL"},null,null,{"$f":"IF('Feed-Cost'!G47=0,\" \",'Feed-Cost'!G47)","v":0.5},null,{"$f":"IF('Feed-Cost'!G47=0,\" \",'Feed-Cost'!E20)","v":2248.5},null,{"$f":"IF('Feed-Cost'!G47=0,\" \",ROUND((D72/1000)*F72,2))","v":1.1200000000000001}]
[{"$f":"'Feed-Cost'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed-Cost'!G48=0,\" \",'Feed-Cost'!G48)","v":" "},null,{"$f":"IF('Feed-Cost'!G48=0,\" \",'Feed-Cost'!E21)","v":" "},null,{"$f":"IF('Feed-Cost'!G48=0,\" \",ROUND((D73/1000)*F73,2))","v":" "}]
[{"$f":"'Feed-Cost'!B22","v":"  DL-Methionine"},null,null,{"$f":"IF('Feed-Cost'!G49=0,\" \",'Feed-Cost'!G49)","v":" "},null,{"$f":"IF('Feed-Cost'!G49=0,\" \",'Feed-Cost'!E22)","v":" "},null,{"$f":"IF('Feed-Cost'!G49=0,\" \",ROUND((D74/1000)*F74,2))","v":" "}]
[{"$f":"'Feed-Cost'!B23","v":"  Oats - groats"},null,null,{"$f":"IF('Feed-Cost'!G50=0,\" \",'Feed-Cost'!G50)","v":475},null,{"$f":"IF('Feed-Cost'!G50=0,\" \",'Feed-Cost'!E23)","v":375},null,{"$f":"IF('Feed-Cost'!G50=0,\" \",ROUND((D75/1000)*F75,2))","v":178.13}]
["Total Creep",null,null,{"$f":"SUM(D57:D75)","v":1000},"kg",null,null,{"$f":"SUM(H57:H75)","v":1072.44}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed-Cost'!$E$26","v":1.25},"%",{"$f":"H76+(F77*H60/100)","v":1073.4091250000001}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed-Cost'!$E$25","v":10},null,{"$f":"IF(H77=0,0,H77+F78)","v":1083.4091250000001}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed-Cost'!E27","v":10},null,{"$f":"IF(F77=0,0,H78+F79)","v":1093.4091250000001}]

{"sheet":"Weaner-Worksheet","index":7,"n_rows":358,"n_cols":10,"rows_kept":358,"cut":false,"hidden":false,"merged":[[1,0,1,9],[357,3,359,9],[353,3,354,7],[355,3,355,5],[254,3,254,5],[255,3,255,5],[289,1,289,3],[289,5,289,6],[228,1,228,5],[353,1,354,2]]}
[]
["Production Cost Worksheet"]
[]
["A. Operating Costs",null,null,null,null,null,null,null,null,"Your Cost"]
[]
["1. Feed Requirements and Costs"]
[]
[null,"1.01  Sow Lactation Ration - Purchased Feeds"]
[null,null,"",{"$f":"'Farrow-Wean Input'!G16","v":21},null,"days average weaning age"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G15","v":2.375},null,"litters/sow/year"]
[null,null,"=",{"$f":"D9*D10","v":49.875},null,"days lactation"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!F35","v":6.5},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H35","v":635},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D9*D10*D12*D13/1000)/D15,2)","v":7.52},null,"/pig sold"]
[null,null,""]
[null,"1.02  Sow Gestation Ration - Purchased Feeds"]
[null,null,"",365,null,"days/year"]
[null,null,"-",{"$f":"D11","v":49.875},null,"days lactation"]
[null,null,"=",{"$f":"D19-D20","v":315.125},null,"days gestation"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!F34","v":3},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H34","v":549.75},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D21*D22*D23/D24)/D25,2)","v":18.989999999999998},null,"/pig sold"]
[null,null,""]
[null,"1.03  Boar Ration - Purchased Feeds"]
[null,null,"",365,null,"days"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!F36","v":3},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H36","v":549.75},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G14","v":3},null,"boars"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G13","v":600},null,"sows"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D29*D30*D31/1000*D33/D34)/D35,2)","v":0.11},null,"/pig sold"]
[null,null,""]
[null,"1.04  Creep Feed - Purchased Feeds"]
[null,null,"",{"$f":"'Farrow-Wean Input'!F37","v":0.5},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H37","v":2000},null,"/tonne of creep feed"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G17*'Farrow-Wean Input'!G15","v":32.0625},null,"pigs born alive/sow/year"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND(((D39*D40/1000)*D42)/D43,2)","v":1.17},null,"/pig sold"]
[]
[null,"1.05  Sow Lactation Ration - Home Mixed Feeds"]
[null,null,"",{"$f":"'Farrow-Wean Input'!G16","v":21},null,"days average weaning age"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G15","v":2.375},null,"litters/sow/year"]
[null,null,"=",{"$f":"D47*D48","v":49.875},null,"days lactation"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!F35","v":6.5},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!I35","v":491.92625000000004},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D47*D48*D50*D51/1000)/D53,2)","v":5.83},null,"/pig sold"]
[null,null,""]
[null,"1.06  Sow Gestation Ration - Home Mixed Feeds"]
[null,null,"",365,null,"days/year"]
[null,null,"-",{"$f":"D11","v":49.875},null,"days lactation"]
[null,null,"=",{"$f":"D57-D58","v":315.125},null,"days gestation"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!F34","v":3},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!I34","v":422.21562500000005},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D59*D60*D61/D62)/D63,2)","v":14.58},null,"/pig sold"]
[null,null,""]
[null,"1.07  Boar Ration - Home Mixed Feeds"]
[null,null,"",365,null,"days"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!F36","v":3},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!I36","v":422.21562500000005},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G14","v":3},null,"boars"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G13","v":600},null,"sows"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D67*D68*D69/1000*D71/D72)/D73,2)","v":0.08},null,"/pig sold"]
[null,null,""]
[null,"1.08  Creep Feed - Home Mixed Feeds"]
[null,null,"",{"$f":"'Farrow-Wean Input'!F37","v":0.5},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!I37","v":1093.4091250000001},null,"/tonne of creep feed"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G17*'Farrow-Wean Input'!G15","v":32.0625},null,"pigs born alive/sow/year"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND(((D77*D78/1000)*D80)/D81,2)","v":0.64},null,"/pig sold"]
[null,null,""]
["2. Other Operating Costs"]
[]
[null,"2.01  Veterinary Medicine & Supplies"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G95","v":9},null,"/sow professional services"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!G96","v":24},null,"/sow medication"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D87+D88)/D89,2)","v":1.21},null,"/pig sold"]
[]
[null,"2.02  Maintenance & Repairs"]
[null,null,null,{"$f":"'Farrow-Wean Input'!I62","v":3411.9463473684209},null,"/sow building & equipment cost"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G98","v":1.5},null,"% repair & maintenance"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D93*D94/100/D95),2)","v":1.87},null,"/pig sold"]
[]
[null,"2.03  Hydro & Propane "]
[null,null,null,{"$f":"'Farrow-Wean Input'!G100*'Farrow-Wean Input'!G101","v":24654.780000000002},null,"hydro"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!G102*'Farrow-Wean Input'!G103","v":37500},null,"propane"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND((D99+D100)/D101,5)","v":3.78485},null,"/pig sold"]
[]
[null,"2.04  Insurance"]
[null,null,null,{"$f":"(+'Farrow-Wean Input'!$H$62)","v":2152167.808421053},null,"buildings & equipment"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G106","v":0.78},null,"/$100 capital"]
[null,null,"÷",100]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND((D105*D106/100)/D108,2)","v":1.02},null,"/pig sold"]
[]
[null,null,null,{"$f":"'Farrow-Wean Input'!H67","v":220500},null,"breeding stock"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!G110*'Farrow-Wean Input'!F30","v":919632},null,"weaners"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G107","v":0.88},null,"/$100 capital"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"(((D111+D112)*D113)/100)/D114","v":0.61095856777493607},null,"/pig sold"]
[]
[null,null,null,{"$f":"'Farrow-Wean Input'!G109","v":1200},null,"business interruption coverage/sow"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G13","v":600},null,"sows"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G108","v":0.78},null," /$100 capital invested"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null," pigs sold"]
[null,null,"=",{"$f":"((D117*D118)*D119/100)/D120","v":0.34198027036901718},null," /pig sold"]
[]
[null,null,"=",{"$f":"D109+D115+D121","v":1.9729388381439532},null,"/pig sold"]
[]
[null,"2.05  Manure Costs "]
[null,"   Haulage",null,{"$f":"'Farrow-Wean Input'!G112","v":22.7},null,"litres/sow/day"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G113","v":2.8999999999999998E-3},null,"/litre"]
[null,null,"x",365,null,"days"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D126*D127*D128)/D129,2)","v":0.88},null,"/pig sold"]
[null,"  Estimated Nutrient Value"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G112","v":22.7},null," litres/sow/day"]
[null,null,"x",365,null," days/year"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G13","v":600},null," average inventory of sows"]
[null,null,"÷",1000]
[null,null,"=",{"$f":"SUM((D132*D133*D134)/1000)","v":4971.3},null,"# of 1000 litres of manure"]
[null,null,"Nitrogen"]
[null,null,null,{"$f":"'Farrow-Wean Input'!F122","v":2.09},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D136","v":4971.3},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H122","v":60},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G122","v":0.77},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D138*D139*(D140/100)/D141)*D142)/D143","v":0.13258831129126067},null,"estimated nutrient value / pig sold"]
[null,null,"Phosphate"]
[null,null,null,{"$f":"'Farrow-Wean Input'!F123","v":0.56000000000000005},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D136","v":4971.3},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H123","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G123","v":0.89},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D146*D147*(D148/100)/D149)*D150)/D151","v":0},null,"estimated nutrient value / pig sold"]
[null,null,"Potassium"]
[null,null,null,{"$f":"'Farrow-Wean Input'!F124","v":0.89},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D136","v":4971.3},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!H124","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G124","v":0.6},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D154*D155*(D156/100)/D157)*D158)/D159","v":0},null,"estimated nutrient value / pig sold"]
[null,"   Odour control & Mgmt Fees"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G116+'Farrow-Wean Input'!G117","v":3000},null,"total costs"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"D162/D163","v":0.18268176835951772},null,"/pig sold"]
[]
[null,"   Total","=",{"$f":"D130+D164-(D144+D152+D160)","v":0.93009345706825708},null,"/pig sold"]
[]
[null,"2.06  Office Supplies"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G127","v":2},null,"$/sow"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"D169/D170","v":7.3072707343807081E-2},null,"/pig sold"]
[]
[null,"2.07  Marketing & Transportation & Board Levy"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G129","v":3.5},null,"marketing & transportation"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!G130","v":0.19},null,"board levy"]
[null,null,"=",{"$f":"D174+D175","v":3.69},null,"/pig sold"]
[]
[null,"2.08  Herd Replacement"]
[null,"Sow",null,{"$f":"'Farrow-Wean Input'!G133","v":180},null,"kg/sow (cull weight)"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G134","v":77.28},null,"/100 kg live"]
[null,null,"=",{"$f":"D179*D180/100","v":139.10399999999998},null,"/sow value of cull"]
[]
[null,null,null,{"$f":"'Farrow-Wean Input'!G136","v":350},null,"/sow value of replacement"]
[null,null,"-",{"$f":"D181","v":139.10399999999998},null,"/sow value of cull"]
[null,null,"=",{"$f":"D183-D181","v":210.89600000000002},null,"net replacement cost"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G132","v":42},null,"% sow culling rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D185*D186/100)/D187,2)","v":3.24},null,"/pig sold"]
[]
[]
[null,"Boar",null,{"$f":"'Farrow-Wean Input'!G139","v":225},null,"kg/boar (cull weight)"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G140","v":55.17792},null,"/100 kg live"]
[null,null,"=",{"$f":"D191*D192/100","v":124.15031999999999},null,"/boar value of cull"]
[]
[null,null,null,{"$f":"'Farrow-Wean Input'!G142","v":3500},null,"/boar value of replacement"]
[null,null,"-",{"$f":"D193","v":124.15031999999999},null,"/boar value of cull"]
[null,null,"=",{"$f":"D195-D196","v":3375.8496799999998},null,"net replacement cost"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G138","v":50},null,"% boar culling rate"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G14","v":3},null,"number of boars"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G13","v":600},null,"number of sows"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!$G$30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D197*D198*D199/D200)/D201,2)/100","v":0.30840000000000001},null,"/pig sold"]
[]
[null,"Total",null,{"$f":"D188+D202","v":3.5484},null,"/pig sold"]
[]
[null,"2.09  Artificial Insemination"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G145","v":2.2000000000000002},null,"Number of services"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G146","v":11},null,"Cost/dose (Semen)"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G13","v":600},null,"Sows"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G15","v":2.375},null,"Litters/sow"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"Pigs sold"]
[null,null,"=",{"$f":"(((D207*D208)*D209)*D210)/D211","v":2.0999269272926568},null,"/pig sold"]
[]
[null,"2.10  Property Taxes:"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G149","v":7500},null,"total taxes"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(D215/D216,5)","v":0.45669999999999999},null,"/pig sold"]
[]
[null,null,null,{"$f":"'Farrow-Wean Input'!G150","v":10},null," taxes on  land"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G154","v":0},null,"acres"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null," pigs sold"]
[null,null,"=",{"$f":"(D219*D220)/D221","v":0},null," /pig sold"]
[]
[null,"Total",null,{"$f":"D217+D222","v":0.45669999999999999},null," /pig sold"]
[]
[null,"2.11  Interest on Operating Cost:"]
[]
[null,"Subtotal Operating Cost x Farrow-to-Farrow Period ",null,null,null,null,"x","% Interest "]
[null,365,null,null,null,null,null,null,2]
[null,null,"Purchased Feeds"]
[null,null,null,365,null,"days per year"]
[null,null,"÷",{"$f":"ROUND('Farrow-Wean Input'!G25,2)","v":2.38},null,"litters/sow"]
[null,null,"=",{"$f":"D231/D232","v":153.36134453781514},null,"days farrow-to-farrow"]
[]
[null,null,null,{"$f":"'Farrow-Wean Summary'!E24","v":47.425981929848675},null,"subtotal operating"]
[null,null,"x",{"$f":"D233","v":153.36134453781514},null,"days farrow to farrow"]
[null,null,"÷",365,null,"days per year"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G158","v":8.5},null,"% operating interest rate"]
[null,null,"÷",2,null,"average"]
[null,null,"=",{"$f":"ROUND(((D235/D239)*D236/D237)*D238,2)/100","v":0.84689999999999999},null,"/pig sold"]
[null,null,"Purchased Feeds"]
[null,null,null,{"$f":"D231","v":365},null,"days per year"]
[null,null,"÷",{"$f":"D232","v":2.38},null,"litters/sow"]
[null,null,"=",{"$f":"D242/D243","v":153.36134453781514},null,"days farrow-to-farrow"]
[]
[null,null,null,{"$f":"'Farrow-Wean Summary'!I24","v":40.765981929848678},null,"subtotal operating"]
[null,null,"x",{"$f":"D244","v":153.36134453781514},null,"days farrow to farrow"]
[null,null,"÷",365,null,"days per year"]
[null,null,"x",{"$f":"D238","v":8.5},null,"% operating interest rate"]
[null,null,"÷",2,null,"average"]
[null,null,"=",{"$f":"ROUND(((D246/D250)*D247/D248)*D249,2)/100","v":0.72799999999999998},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":"'Farrow-Wean Input'!$H$53+'Farrow-Wean Input'!$H$74+'Farrow-Wean Input'!$H$75-'Farrow-Wean Input'!H52","v":1558899.5073684212},null,"building cost (including earthen"]
[null,null,null,null,null,"manure storage)"]
[null,null,"-",{"$f":"('Farrow-Wean Input'!$H$53-'Farrow-Wean Input'!H52)*'Farrow-Wean Input'!$G$89/100","v":140289.95073684212},null,"salvage value (building only)"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G86","v":25},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D259-D261)/D262)/D263,2)","v":3.46},null,"/pig sold"]
[]
[null,"3.011  Buildings - including feedmill",null,null,null,null,""]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$53+'Farrow-Wean Input'!$H$74+'Farrow-Wean Input'!$H$75","v":1603899.5073684212},null,"building cost (including earthen"]
[null,null,null,null,null,"manure storage)"]
[null,null,"-",{"$f":"'Farrow-Wean Input'!$H$53*'Farrow-Wean Input'!$G$89/100","v":144789.95073684212},null,"salvage value (building only)"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G86","v":25},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D267-D269)/D270)/D271,2)","v":3.55},null,"/pig sold"]
[]
[null,"3.02  Equipment - not including feedmill"]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$61-'Farrow-Wean Input'!H60","v":644268.30105263158},null,"equipment cost"]
[null,null,"-",{"$f":"('Farrow-Wean Input'!$H$61-'Farrow-Wean Input'!H60)*'Farrow-Wean Input'!$G$90/100","v":64426.830105263165},null,"salvage value"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G87","v":10},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D275-D276)/D277)/D278,2)","v":3.53},null,"/pig sold"]
[]
[null,"3.021  Equipment - inlcuding feedmill"]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$61","v":704268.30105263158},null,"equipment cost"]
[null,null,"-",{"$f":"'Farrow-Wean Input'!$H$61*'Farrow-Wean Input'!$G$90/100","v":70426.830105263158},null,"salvage value"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G87","v":10},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D282-D283)/D284)/D285,2)","v":3.86},null,"/pig sold"]
[]
["4.  Investment:"]
[]
[null,{"$f":"\"(Original Cost + Salvage Value)\"","v":"(Original Cost + Salvage Value)"},null,null,"x","Investment Rate"]
[null,null,null,{"$f":"\"         2\"","v":"         2"}]
[]
[]
[null,"4.01  Land for Barn site"]
[null,null,null,{"$f":"'Farrow-Wean Input'!H70","v":110000},null,"land investment"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!H74","v":36000},null,"site preparation"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"((D295+D296)*D297/100)/D298","v":0.24448909998782123},null,"/pig sold"]
[null,"          Land for manure application"]
[null,null,null,{"$f":"'Farrow-Wean Input'!H71","v":0},null," land investment"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null," pigs sold"]
[null,null,"=",{"$f":"((D301)*D302/100)/D303","v":0},null," /pig sold"]
[null,"Total",null,{"$f":"D299+D304","v":0.24448909998782123},null," /pig sold"]
[]
[null,"4.02  Buildings - not including feedmill"]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$53+'Farrow-Wean Input'!$H$74+'Farrow-Wean Input'!$H$75-'Farrow-Wean Input'!H52","v":1558899.5073684212},null,"building cost (including earthen "]
[null,null,null,null,null,"manure storage)"]
[null,null,"+",{"$f":"('Farrow-Wean Input'!$H$53-'Farrow-Wean Input'!H52)*'Farrow-Wean Input'!$G$89/100","v":140289.95073684212},null,"salvage value (building only)"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D308+D310)/2*D312)/D313,2)/100","v":1.4227000000000001},null,"/pig sold"]
[null,"4.021  Buildings - including feedmill"]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$53+'Farrow-Wean Input'!$H$74+'Farrow-Wean Input'!$H$75","v":1603899.5073684212},null,"building cost (including earthen "]
[null,null,null,null,null,"manure storage)"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!$H$53*'Farrow-Wean Input'!$G$89/100","v":144789.95073684212},null,"salvage value (building only)"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D316+D318)/2*D320)/D321,2)/100","v":1.4641999999999999},null,"/pig sold"]
[]
[null,"4.03  Equipment - not including feedmill"]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$61-'Farrow-Wean Input'!H60","v":644268.30105263158},null,"equipment cost"]
[null,null,"+",{"$f":"('Farrow-Wean Input'!$H$61-'Farrow-Wean Input'!H60)*'Farrow-Wean Input'!$G$90/100","v":64426.830105263165},null,"salvage value"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D325+D326)/2*D328)/D329,2)/100","v":0.59340000000000004},null,"/pig sold"]
[null,"4.031  Equipment - including feedmill"]
[null,null,null,{"$f":"'Farrow-Wean Input'!$H$61","v":704268.30105263158},null,"equipment cost"]
[null,null,"+",{"$f":"'Farrow-Wean Input'!$H$61*'Farrow-Wean Input'!$G$90/100","v":70426.830105263158},null,"salvage value"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND(((D332+D333)/2*D335)/D336,2)/100","v":0.64859999999999995},null,"/pig sold"]
[]
[null,"4.04  Breeding Stock"]
[null,null,null,{"$f":"'Farrow-Wean Input'!H67","v":220500},null,"value of breeding stock"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G92","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!F30","v":16422},null,"pigs marketed"]
[null,null,"=",{"$f":"ROUND((D340*D341)/D342,2)/100","v":0.36920000000000003},null,"/pig sold"]
[]
["C.  Labour"]
[null,null,null,{"$f":"'Farrow-Wean Input'!G41","v":120},null,"hours/week"]
[null,null,"x",52,null,"weeks/year"]
[null,null,"x",{"$f":"'Farrow-Wean Input'!G42","v":27},null,"/hour"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G13","v":600},null,"sows"]
[null,null,"÷",{"$f":"'Farrow-Wean Input'!G30","v":27.37},null,"pigs/sow"]
[null,null,"=",{"$f":"ROUND((D346*52*D348/'Farrow-Wean Input'!G13)/D350,2)","v":10.26},null,"/pig sold"]
[]
[]
[null,"Return On Assets (ROA) =",null,"Net Income + Operating Interest + Investment Interest - Value of Unpaid Family Labour"]
[]
[null,null,null,"Total Assets"]
[]
[null,"Total Assets =",null,"Total Assets includes the buildings, equipment, land, manure storage and breeding stock valued at replacement cost plus the value of market livestock on inventory."]

{"sheet":"Ingredient-Summary","index":8,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,2,1,6],[16,0,16,7]]}
[]
[null,null,"  Summary of Purchased Feeds Used"]
[]
[null,"Number of Sows",null,{"$f":"'Farrow-Wean Input'!$G$13","v":600}]
[null,"Total Pigs Fed",null,{"$f":"'Farrow-Wean Input'!$F$28","v":16833}]
[]
[null,null,null,"Total","Total","Total","Total"]
[null,null,null,"per Year","per Month","per Pig","per Pig"]
[null,null,null,"(tonnes)","(tonnes)","(kgs)","(lbs)"]
[null,"Dry Sow",null,{"$f":"IF('Farrow-Wean Input'!H34<=0,0,('Farrow-Wean Input'!F34*'Weaner-Worksheet'!D21)*'Farrow-Wean Input'!F23/1000)","v":567.22500000000002},{"$f":"D10/12","v":47.268750000000004},{"$f":"(D10/$D$5)*1000","v":33.697201924790598},{"$f":"F10*2.2046","v":74.288851363393348}]
[null,"Lactating Sow",null,{"$f":"IF('Farrow-Wean Input'!H35<=0,0,('Farrow-Wean Input'!F35*'Weaner-Worksheet'!D11)*'Farrow-Wean Input'!F23/1000)","v":194.51249999999999},{"$f":"D11/12","v":16.209374999999998},{"$f":"(D11/$D$5)*1000","v":11.555426840135448},{"$f":"F11*2.2046","v":25.475094011762611}]
[null,"Boar",null,{"$f":"IF('Farrow-Wean Input'!H36<=0,0,('Farrow-Wean Input'!F36*'Weaner-Worksheet'!D29)*'Farrow-Wean Input'!F24/1000)","v":3.2850000000000001},{"$f":"D12/12","v":0.27374999999999999},{"$f":"(D12/$D$5)*1000","v":0.19515237925503476},{"$f":"F12*2.2046","v":0.43023293530564966}]
[null,"Creep",null,{"$f":"IF('Farrow-Wean Input'!H37<=0,0,('Farrow-Wean Input'!F37*'Farrow-Wean Input'!F28)/1000)","v":8.4164999999999992},{"$f":"D13/12","v":0.70137499999999997},{"$f":"(D13/$D$5)*1000","v":0.49999999999999989},{"$f":"F13*2.2046","v":1.1022999999999998}]
[null,"Total",null,{"$f":"SUM(D10:D13)","v":773.43899999999996},{"$f":"SUM(E10:E13)","v":64.453250000000011},{"$f":"SUM(F10:F13)","v":45.947781144181079},{"$f":"SUM(G10:G13)","v":101.29647831046161}]
[]
[]
["  Summary of Home Feed Ingredients Used"]
[null,null,null,"Total","Total","Total","Total"]
[null," ",null,"per Year","per Month","per Pig","per Pig"]
[null,null,null,"(tonnes)","(tonnes)","(kgs)","(lbs)"]
[null,{"$f":"'Feed-Cost'!B5","v":"  Wheat"},null,{"$f":"'Feed-Cost'!H58","v":258.29804115000002},{"$f":"D21/12","v":21.524836762500001},{"$f":"D21/$D$5*1000","v":15.34474194439494},{"$f":"F21*2.2046","v":33.82901809061309}]
[null,{"$f":"'Feed-Cost'!B6","v":"  Barley"},null,{"$f":"'Feed-Cost'!H59","v":346.40738999999996},28.867282499999998,{"$f":"D22/$D$5*1000","v":20.579064337907678},45.368605239351268]
[null,{"$f":"'Feed-Cost'!B7","v":"  Corn "},null,{"$f":"'Feed-Cost'!H60","v":1.1762058750000002},9.8017156250000015E-2,6.9875000000000007E-2,0.15404642500000001]
[null,{"$f":"'Feed-Cost'!B8","v":"  Soybean Meal "},null,{"$f":"'Feed-Cost'!H61","v":39.105729735000004},3.2588108112500005,2.323158660666548,5.1216355833054719]
[null,{"$f":"'Feed-Cost'!B9","v":"  Canola Meal "},null,{"$f":"'Feed-Cost'!H62","v":45.713070000000002},3.8094225000000002,2.7156816966672608,5.9869918684726438]
[null,{"$f":"'Feed-Cost'!B10","v":"  Peas"},null,{"$f":"'Feed-Cost'!H63","v":51.916409999999999},4.3263674999999999,3.0842042416681519,6.7994366711816081]
[null,{"$f":"'Feed-Cost'!B11","v":"  Sow Micro"},null,{"$f":"'Feed-Cost'!H64","v":3.8671949999999997},0.32226624999999998,0.22973890572090533,0.5064823915523079]
[null,{"$f":"'Feed-Cost'!B12","v":"  Canola Oil"},null,{"$f":"'Feed-Cost'!H65","v":0.16833000000000001},1.40275E-2,0.01,2.2046000000000003E-2]
[null,{"$f":"'Feed-Cost'!B13","v":"  Whey Powder "},null,{"$f":"'Feed-Cost'!H66","v":0.84165000000000012},7.0137500000000005E-2,5.000000000000001E-2,0.11023000000000002]
[null,{"$f":"'Feed-Cost'!B14","v":"  Fish Meal"},null,{"$f":"'Feed-Cost'!H67","v":0.50499000000000005},4.2082500000000002E-2,3.0000000000000006E-2,6.6138000000000016E-2]
[null,{"$f":"'Feed-Cost'!B15","v":"  Plasma"},null,{"$f":"'Feed-Cost'!H68","v":0.48815700000000006},4.0679750000000008E-2,2.9000000000000005E-2,6.3933400000000015E-2]
[null,{"$f":"'Feed-Cost'!B16","v":"  Limestone"},null,{"$f":"'Feed-Cost'!H69","v":8.1487537949999993},0.67906281624999998,0.48409396988059161,1.0672335659987524]
[null,{"$f":"'Feed-Cost'!B17","v":"  Dical (16% Ca-21% P) "},null,{"$f":"'Feed-Cost'!H70","v":8.6924125950000004},0.72436771625000007,0.51639117180538241,1.1384359773621462]
[null,{"$f":"'Feed-Cost'!B18","v":"  Salt - 96%"},null,{"$f":"'Feed-Cost'!H71","v":2.9988052500000002},0.24990043750000002,0.17815037426483693,0.39275031510425951]
[null,{"$f":"'Feed-Cost'!B19","v":"  Phytase"},null,{"$f":"'Feed-Cost'!H72","v":0.38251124999999997},3.18759375E-2,2.2723890572090535E-2,5.0097089155230798E-2]
[null,{"$f":"'Feed-Cost'!B20","v":"  L-Lysine HCL"},null,{"$f":"'Feed-Cost'!H73","v":0.73151085000000005},6.0959237500000006E-2,4.3456950632685794E-2,9.5805193364819102E-2]
[null,{"$f":"'Feed-Cost'!B21","v":"  L-Threonine "},null,{"$f":"'Feed-Cost'!H74","v":0},0,0,0]
[null,{"$f":"'Feed-Cost'!B22","v":"  DL-Methionine"},null,{"$f":"'Feed-Cost'!H75","v":0},0,0,0]
[null,{"$f":"'Feed-Cost'!B23","v":"  Oats - groats"},null,{"$f":"'Feed-Cost'!H76","v":3.9978374999999997},0.33315312499999999,0.23749999999999996,0.52359249999999991]
[null,"Total  ",null,{"$f":"SUM(D21:D39)","v":773.43899999999985},{"$f":"SUM(E21:E39)","v":64.453250000000011},{"$f":"SUM(F21:F39)","v":45.947781144181079},{"$f":"SUM(G21:G39)","v":101.29647831046162}]