{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Assumptions","Farrow-Wean Summary","Risk Analysis","Farrow-Wean Input","Fixed Cost","Ingredient-Summary"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":44,"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":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,1,48,8],[4,1,4,8],[5,1,5,8],[6,1,6,8],[50,1,51,8],[11,1,20,8],[21,1,32,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
[null,"Guidelines For Estimating"]
[null,"Swine Farrow-Wean to 6 kg Costs"]
[null,{"$f":"\"Based On \"&'Farrow-Wean Input'!G11&\" Sows \"&FIXED('Farrow-Wean Input'!F27,0)&\" Pigs Sold\"","v":"Based On 600 Sows 16,944 Pigs Sold"}]
[]
[null,null,null,null,null,null,"Date:","June, 2025"]
[]
[]
[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."]
[]
[]
[null,{"$f":"\"The budget includes a land investment cost for \"&'Fixed Cost'!D31&\" acres, with \"&'Fixed Cost'!C44&\" acres rented out at $\"&'Fixed Cost'!C45&\" per acre, of the estimated \"&ROUND(((('Farrow-Wean Input'!C94*'Farrow-Wean Input'!H96)/(40.768*2))*2.4709661),0)&\" to \"&ROUND(((('Farrow-Wean Input'!C94*'Farrow-Wean Input'!H96)/(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 $100 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":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,61,8],[2,4,2,6],[0,0,0,8],[39,0,39,8]]}
[{"$f":"'Farrow-Wean Input'!G11&\" Sow Farrow-Wean to 6kg Cost of Production Summary - \"&Introduction!H9","v":"600 Sow Farrow-Wean to 6kg Cost of Production Summary - June, 2025"}]
[]
[null,null,null,null,"Purchased Feed"]
[null,null,null,null,"$/Pig",null,"Total"]
["A. Operating Costs",null,null,null,"Sold","$/Sow","Cost",null,"Your Cost"]
["1.","Feed Costs:"]
[null,"Sow Lactation Ration",null,null,{"$f":"'Farrow-Wean Input'!G40","v":5.5103657932011334},{"$f":"ROUND(E7*'Farrow-Wean Input'!$G$27,2)","v":155.61000000000001},{"$f":"ROUND(E7*'Farrow-Wean Input'!$F$27,0)","v":93368}]
[null,"Sow Gestation Ration",null,null,{"$f":"'Farrow-Wean Input'!F40","v":14.021959631728045},{"$f":"ROUND(E8*'Farrow-Wean Input'!$G$27,2)","v":395.98},{"$f":"ROUND(E8*'Farrow-Wean Input'!$F$27,0)","v":237588}]
[null,"Boar Ration",null,null,{"$f":"'Farrow-Wean Input'!H40","v":8.1233179886685547E-2},{"$f":"ROUND(E9*'Farrow-Wean Input'!$G$27,2)","v":2.29},{"$f":"ROUND(E9*'Farrow-Wean Input'!$F$27,0)","v":1376}]
[null,"Creep Feed",null,null,{"$f":"'Farrow-Wean Input'!I40","v":0.87971246458923524},{"$f":"ROUND(E10*'Farrow-Wean Input'!$G$27,2)","v":24.84},{"$f":"ROUND(E10*'Farrow-Wean Input'!$F$27,0)","v":14906}]
["Total Feed Cost",null,null,null,{"$f":"SUM(E7:E10)","v":20.493271069405097},{"$f":"SUM(F7:F10)","v":578.72},{"$f":"SUM(G7:G10)","v":347238}]
[]
["2.","Other Operating Costs:",null,null,null,""]
[null,"Veterinary Medicine & Supplies:",null,null,{"$f":"'Farrow-Wean Input'!C54","v":4.9575070821529748},{"$f":"ROUND(E14*'Farrow-Wean Input'!$G$27,2)","v":140},{"$f":"ROUND(E14*'Farrow-Wean Input'!$F$27,0)","v":84000}]
[null,"Maintenance & Repairs",null,null,{"$f":"'Farrow-Wean Input'!C60","v":1.9837095249006116},{"$f":"ROUND(E15*'Farrow-Wean Input'!$G$27,2)","v":56.02},{"$f":"ROUND(E15*'Farrow-Wean Input'!$F$27,0)","v":33612}]
[null,"Hydro & Propane",null,null,{"$f":"'Farrow-Wean Input'!C73+'Farrow-Wean Input'!C67","v":3.7288597733711049},{"$f":"ROUND(E16*'Farrow-Wean Input'!$G$27,2)","v":105.3},{"$f":"ROUND(E16*'Farrow-Wean Input'!$F$27,0)","v":63182}]
[null,"Insurance",null,null,{"$f":"'Farrow-Wean Input'!I80","v":2.0155323523817463},{"$f":"ROUND(E17*'Farrow-Wean Input'!$G$27,2)","v":56.92},{"$f":"ROUND(E17*'Farrow-Wean Input'!$F$27,0)","v":34151}]
[null,"Manure Costs",null,null,{"$f":"'Farrow-Wean Input'!C109","v":0.90704247120977788},{"$f":"ROUND(E18*'Farrow-Wean Input'!$G$27,2)","v":25.61},{"$f":"ROUND(E18*'Farrow-Wean Input'!$F$27,0)","v":15369}]
[null,"Office Supplies",null,null,{"$f":"'Farrow-Wean Input'!C114","v":7.0821529745042494E-2},{"$f":"ROUND(E19*'Farrow-Wean Input'!$G$27,2)","v":2},{"$f":"ROUND(E19*'Farrow-Wean Input'!$F$27,0)","v":1200}]
[null,"Marketing & Transport.",null,null,{"$f":"'Farrow-Wean Input'!C119","v":3.69},{"$f":"ROUND(E20*'Farrow-Wean Input'!$G$27,2)","v":104.21},{"$f":"ROUND(E20*'Farrow-Wean Input'!$F$27,0)","v":62523}]
[null,"Herd Replacement",null,null,{"$f":"'Farrow-Wean Input'!C154","v":2.6469810154036835},{"$f":"ROUND(E21*'Farrow-Wean Input'!$G$27,2)","v":74.75},{"$f":"ROUND(E21*'Farrow-Wean Input'!$F$27,0)","v":44850}]
[null,"Artificial Insemination",null,null,{"$f":"'Farrow-Wean Input'!C127","v":2.039518413597734},{"$f":"ROUND(E22*'Farrow-Wean Input'!$G$27,2)","v":57.6},{"$f":"ROUND(E22*'Farrow-Wean Input'!$F$27,0)","v":34558}]
[null,"Property Tax",null,null,{"$f":"'Farrow-Wean Input'!C166","v":0.47804532577903686},{"$f":"ROUND(E23*'Farrow-Wean Input'!$G$27,2)","v":13.5},{"$f":"ROUND(E23*'Farrow-Wean Input'!$F$27,0)","v":8100}]
["Subtotal Operating Costs",null,null,null,{"$f":"SUM(E14:E23)+E11","v":43.011288557946813},{"$f":"SUM(F14:F23)+F11","v":1214.6300000000001},{"$f":"SUM(G14:G23)+G11","v":728783}]
[null,"Interest on Operating Costs",null,null,{"$f":"'Farrow-Wean Input'!C174","v":0.63251894938157083},{"$f":"ROUND(E25*'Farrow-Wean Input'!$G$27,2)","v":17.86},{"$f":"ROUND(E25*'Farrow-Wean Input'!$F$27,0)","v":10717}]
["Total Operating Costs",null,null,null,{"$f":"SUM(E24:E25)","v":43.643807507328383},{"$f":"SUM(F24:F25)","v":1232.49},{"$f":"SUM(G24:G25)","v":739500}]
[]
["B. Fixed Costs",null,null,null,null,""]
[null,"Buildings & Manure Storage",null,null,{"$f":"'Fixed Cost'!D27","v":8.7875337791543249},{"$f":"ROUND(E29*'Farrow-Wean Input'!$G$27,2)","v":248.16},{"$f":"ROUND(E29*'Farrow-Wean Input'!$F$27,0)","v":148896}]
[null,"Barn Equipment",null,null,{"$f":"'Fixed Cost'!I27","v":7.8812497781731388},{"$f":"ROUND(E30*'Farrow-Wean Input'!$G$27,2)","v":222.57},{"$f":"ROUND(E30*'Farrow-Wean Input'!$F$27,0)","v":133540}]
[null,"Breeding Stock",null,null,{"$f":"'Fixed Cost'!I39+'Fixed Cost'!I51","v":2.0821680793829538},{"$f":"ROUND(E31*'Farrow-Wean Input'!$G$27,2)","v":58.8},{"$f":"ROUND(E31*'Farrow-Wean Input'!$F$27,0)","v":35280}]
[null,"Land",null,null,{"$f":"'Fixed Cost'!D41","v":0.79975978963628203},{"$f":"ROUND(E32*'Farrow-Wean Input'!$G$27,2)","v":22.59},{"$f":"ROUND(E32*'Farrow-Wean Input'!$F$27,0)","v":13551}]
["Total Fixed Costs",null,null,null,{"$f":"SUM(E29:E32)","v":19.550711426346702},{"$f":"SUM(F29:F32)","v":552.12},331267]
[]
["C. Labour",null,null,null,null,""]
[null,"Wages, benefits and hired manager",null,null,{"$f":"'Farrow-Wean Input'!C48","v":9.9433427762039663},{"$f":"ROUND(E36*'Farrow-Wean Input'!$G$27,2)","v":280.8},{"$f":"ROUND(E36*'Farrow-Wean Input'!$F$27,0)","v":168480}]
[]
["Total Cost of Production",null,null,null,{"$f":"E26+E33+E36","v":73.137861709879047},{"$f":"F26+F33+F36","v":2065.4100000000003},{"$f":"G26+G33+G36","v":1239247}]
[]
["Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null,"$/Pig","$/Sow","Total"]
[null,"Market Price per weanling",null,null,{"$f":"'Farrow-Wean Input'!F8","v":63},{"$f":"ROUND(E43*'Farrow-Wean Input'!$G$27,2)","v":1779.12},{"$f":"ROUND(E43*'Farrow-Wean Input'!$F$27,0)","v":1067472}]
[null,"Land rental per head sold",null,null,{"$f":"SUM(('Fixed Cost'!C44*'Fixed Cost'!C45)/'Farrow-Wean Input'!F27)","v":0},{"$f":"ROUND(E44*'Farrow-Wean Input'!$G$27,2)","v":0},{"$f":"ROUND(E44*'Farrow-Wean Input'!$F$27,0)","v":0}]
[null,"Gross Revenue  / hog",null,null,{"$f":"SUM(E43:E44)","v":63},{"$f":"SUM(F43:F44)","v":1779.12},{"$f":"SUM(G43:G44)","v":1067472}]
[]
["Marginal Returns "]
[null,"Over Operating Costs",null,null,{"$f":"SUM(E45-E26)","v":19.356192492671617},{"$f":"SUM(F45-F26)","v":546.62999999999988},{"$f":"SUM(G45-G26)","v":327972}]
[null,"Over Operating & Labour Costs",null,null,{"$f":"SUM(E45-E26-E36)","v":9.412849716467651},{"$f":"SUM(F45-F26-F36)","v":265.82999999999987},{"$f":"SUM(G45-G26-G36)","v":159492}]
[null,"Over Total Costs (Net Profit)",null,null,{"$f":"SUM(E45-E38)","v":-10.137861709879047},{"$f":"SUM(F45-F38)","v":-286.29000000000042},{"$f":"SUM(G45-G38)","v":-171775}]
[]
["Operating Expense Ratio",null,null,null,{"$f":"SUM(E26/E45)","v":0.69275884932267273}]
[]
["Breakeven Selling Price",null,null,null,"$/Pig"]
[null,"Operating Costs",null,null,{"$f":"(E26)","v":43.643807507328383}]
[null,"Operating & Labour Costs",null,null,{"$f":"(E26+E36)","v":53.587150283532353}]
[null,"Total Costs",null,null,{"$f":"E38","v":73.137861709879047}]
[]
["Return On Assets (ROA)",null,null,null,{"$f":"SUM((E50+E25+'Fixed Cost'!G68)*'Farrow-Wean Input'!$F$27)/(('Fixed Cost'!D50)+(('Farrow-Wean Input'!$F$8/2)*('Farrow-Wean Input'!F27/365*'Farrow-Wean Input'!G14)))","v":-3.0864707986384746E-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":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,7],[52,0,54,7]]}
["Risk & Sensitivity Analysis"]
[]
[null,null,"Purchased Feed"]
[null,null,"Per Pig"]
["A.  Operating Costs"]
[null,"Feed cost",{"$f":"'Farrow-Wean Summary'!E11","v":20.493271069405097}]
[null,"Other Operating Costs",{"$f":"SUM('Farrow-Wean Summary'!E26-'Farrow-Wean Summary'!E11)","v":23.150536437923286}]
[null,"Subtotal",{"$f":"SUM(C6:C7)","v":43.643807507328383}]
["B.  Fixed Costs",null,{"$f":"'Farrow-Wean Summary'!E33","v":19.550711426346702}]
["C.  Labour",null,{"$f":"'Farrow-Wean Summary'!E36","v":9.9433427762039663}]
["Total Costs",null,{"$f":"SUM(C8:C10)","v":73.137861709879047}]
[]
["Estimated Farmgate"]
[null,"Price ($ per weanling)",{"$f":"'Farrow-Wean Summary'!E43","v":63}]
[null,"Weanlings sold per sow",{"$f":"'Farrow-Wean Input'!G27","v":28.24}]
[]
[]
[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":69.300000000000011}]
[null,"Lower Price ($ per weanling)",{"$f":"SUM(C14*(1-E19))","v":56.7}]
[null,"Higher Feed Cost",{"$f":"SUM(C6+(C6*(C20)))","v":22.542598176345606}]
[null,"Lower Feed Cost",{"$f":"SUM(C6-(C6*E20))","v":19.468607515934842}]
[null,"Higher Weanlings Sold Per Sow",{"$f":"SUM(C15+C21)","v":28.74}]
[null,"Lower Weanlings Sold Per Sow",{"$f":"SUM(C15-E21)","v":25.74}]
[]
[]
[{"$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$27)/C28))","v":42.280441665828647}]
[null,"Total Costs",{"$f":"C33+C10+C9","v":71.774495868379319}]
[null,"Gross Revenue / hog",{"$f":"SUM(C24+'Farrow-Wean Summary'!$E$44)","v":69.300000000000011}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C35-C33)","v":27.019558334171364}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C35-C33-C10)","v":17.076215557967398}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C35-C34)","v":-2.4744958683793072}]
[null,"Operating Expense Ratio",{"$f":"SUM(C33/C35)","v":0.61010738334529058}]
[]
[{"$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$27)/C29))","v":47.882586651598494}]
[null,"Total Costs",{"$f":"C9+C10+C43","v":77.376640854149159}]
[null,"Gross Revenue / hog",{"$f":"SUM(C25+'Farrow-Wean Summary'!$E$44)","v":56.7}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C45-C43)","v":8.8174133484015087}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C45-C43-C10)","v":-1.1259294278024576}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C45-C44)","v":-20.676640854149156}]
[null,"Operating Expense Ratio",{"$f":"SUM(C43/C45)","v":0.84449006440208985}]
[]
[]
["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":179,"n_cols":9,"rows_kept":179,"cut":false,"hidden":false,"merged":[[0,0,0,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,63]
[]
["Indicators of Productivity"]
["Sows",null,null,null,null,null,600,300,"/sow"]
["Boars",null,null,null,null,null,3,3000," /boar"]
["Litters/Sow/Year",null,null,null,null,null,2.38]
["Average Weaning Age (days)",null,null,null,null,null,21]
["Average Born Alive per Litter",null,null,null,null,null,13.9]
["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":"G11","v":600}]
["Boars",null,null,null,null,{"$f":"G12","v":3}]
["Litters",null,null,null,null,{"$f":"ROUND(G22*F20,0)","v":1428},{"$f":"G13","v":2.38},"",""]
["Pigs Born Alive",null,null,null,null,{"$f":"ROUND(G15*F22,0)","v":19849},{"$f":"ROUND(F23/F20,2)","v":33.08},{"$f":"G15","v":13.9},""]
["Pigs Died, Pre-Weaning",null,null,null,null,{"$f":"ROUND(G16*F23/100,0)","v":2481},{"$f":"ROUND(F24/F20,2)","v":4.1399999999999997},{"$f":"ROUND(F24/F22,2)","v":1.74},{"$f":"G16","v":12.5}]
["Pigs Weaned",null,null,null,null,{"$f":"F23-F24","v":17368},{"$f":"ROUND(F25/F20,2)","v":28.95},{"$f":"ROUND(F25/F22,2)","v":12.16},""]
["Pigs Culled ",null,null,null,null,{"$f":"ROUND(G17*F25/100,0)","v":424},{"$f":"ROUND(F26/F20,2)","v":0.71},{"$f":"ROUND(F26/F22,2)","v":0.3},{"$f":"G17","v":2.44}]
["Weaner Pigs Sold",null,null,null,null,{"$f":"ROUND(F25-F26,0)","v":16944},{"$f":"ROUND(F27/F20,2)","v":28.24},{"$f":"ROUND(F27/F22,2)","v":11.87},""]
[]
["Feed Requirements and Costs",null,null,null,null,null,"Nursing"]
[null,null,null,null,null,"Dry Sow","Sow","Boar Ration","Creep Feed"]
[null,null,"Days average weaning age",null,null,null,{"$f":"G14","v":21},null," (kg/pig)"]
[null,"x","Litters/Sow/Year",null,null,null,{"$f":"G13","v":2.38}]
[null,"=","Days lactation/gestation",null,null,{"$f":"365-G33","v":315.02},{"$f":"SUM(G14*G13)","v":49.98},365]
[null,"x","kg ration/day",null,null,3,6.5,3,0.5]
[null,"x","ration cost per tonne",null,null,419,479,419,1502]
[null,"x","boars",null,null,null,null,{"$f":"G12","v":3}]
[null,"÷","kg/tonne",null,null,1000,1000,1000]
[null,"x","pigs born alive/sow/year",null,null,null,null,null,{"$f":"G23","v":33.08}]
[null,"÷","pigs sold/sow/year",null,null,{"$f":"G27","v":28.24},{"$f":"G27","v":28.24},{"$f":"F27","v":16944},{"$f":"G27","v":28.24}]
[null,"=","/pig sold",null,null,{"$f":"(F33*F34*F35/F37)/F39","v":14.021959631728045},{"$f":"(G31*G32*G34*G35/1000)/G39","v":5.5103657932011334},{"$f":"(H33*H34*H35*H36/H37)/H39","v":8.1233179886685547E-2},{"$f":"((I34*I35/1000)*I38)/I39","v":0.87971246458923524}]
[]
["Labour"]
[null,null,120,"hours/week"]
[null,"x",52,"weeks/year"]
[null,"=",{"$f":"C43*52","v":6240},{"$f":"\"total hours/year    (\"&C45/G11&\" hrs/sow)\"","v":"total hours/year    (10.4 hrs/sow)"}]
[null,"x",27," wage/hour (includes hired manager) "]
[null,"÷",{"$f":"F27","v":16944}," pigs sold"]
[null,"=",{"$f":"(C45*C46)/C47","v":9.9433427762039663}," /pig sold"]
[]
["Veterinary Medicine & Supplies"]
[null,null,140,"Professional Services/sow"]
[null,"+",0,"Medication/sow"]
[null,"÷",{"$f":"G27","v":28.24},"pigs sold/sow/year"]
[null,"=",{"$f":"SUM(C51:C52)/C53","v":4.9575070821529748},"/pig sold"]
[]
["Maintenance & Repair"]
[null,null,1.5," % of Total Capital Investment"]
[null,"x",{"$f":"'Fixed Cost'!D14+'Fixed Cost'!I14","v":2240798.2793277311}," total buildings and equipment cost"]
[null,"÷",{"$f":"F27","v":16944}," pigs sold"]
[null,"=",{"$f":"SUM((C57/100)*C58)/C59","v":1.9837095249006116}," /pig sold"]
[]
["Hydro & Propane"]
[null,null,450,"Hydro usage - kwhr/sow"]
[null,"x",{"$f":"G11","v":600},"sows"]
[null,"x",9.2340000000000005E-2,"Hydro rate per kwhr"]
[null,"÷",{"$f":"F27","v":16944}," pigs sold"]
[null,"=",{"$f":"SUM((C63*C64*C65)/C66)","v":1.4714235127478754}," /pig sold"]
[]
[null,null,85,"Propane usage - litres/sow"]
[null,"x",{"$f":"G11","v":600},"sows"]
[null,"x",0.75,"Propane rate per litre"]
[null,"÷",{"$f":"F27","v":16944}," pigs sold"]
[null,"=",{"$f":"SUM((C69*C70*C71)/C72)","v":2.2574362606232294}," /pig sold"]
[]
["Insurance"]
[null,null,0.78," /$100 Capital Invested - Buildings and Equip.",null,null,null,null,{"$f":"SUM('Fixed Cost'!D14+'Fixed Cost'!I14)*C76/100/$F$27","v":1.0315289529483183}]
[null,null,0.88," /$100 Capital Invested - Breeding Stock",null,null,null,null,{"$f":"SUM((G11*H11)+(G12*H12)+(F8*F27))*C77/100/$F$27","v":0.65255864022662891}]
[null,null,0.78," /$100 Capital Invested - Business Interuption"]
[null,null,1200,"per sow - Business Interuption Value",null,null,null,null,{"$f":"SUM(C79*G11*C78/100/F27)","v":0.33144475920679889}]
[null,null,null,null,null,null,null," /pig sold",{"$f":"SUM(I76:I79)","v":2.0155323523817463}]
[]
["Manure Costs"]
[null," Haulage",null,22.7," litres/sow/day ³",null,"³ 1000 litres = 35.314 cubic feet"]
[null,"x",365," days/year"]
[null,"x",{"$f":"G11","v":600}," average inventory of sows"]
[null,"x",3.0000000000000001E-3," /litre   =",null,{"$f":"C86*4.54609","v":1.3638270000000001E-2}," /gallon"]
[null,"÷",{"$f":"F27","v":16944}," pigs sold"]
[null,"=",{"$f":"(D83*C84*C85*C86)/C87","v":0.88018767705382439}," /pig sold"]
[null," Estimated Nutrient Value"]
[null,null,{"$f":"D83","v":22.7}," litres/pig/day"]
[null,"x",365," days/year"]
[null,"x",{"$f":"C85","v":600}," average inventory of pigs"]
[null,"÷",1000]
[null,"=",{"$f":"SUM((C90*C91*C92)/1000)","v":4971.3},"# of 1000 litres of manure"]
[null,null,null,null,null,null," Nitrogen","Phosphate","Potassium"]
[null,null,"kg per 1000 litres",null,null,null,2.09,0.56000000000000005,0.89]
[null,"x","# of 1000 litres of manure",null,null,null,{"$f":"C94","v":4971.3},{"$f":"C94","v":4971.3},{"$f":"C94","v":4971.3}]
[null,"x","% nutrient value recovery",null,null,null,60,0,0]
[null,"÷","lbs per kg",null,null,null,2.2045854999999999,2.2045854999999999,2.2045854999999999]
[null,"x","fertilizer value per lb.",null,null,null,0.9,0.9,0.5]
[null,"÷"," pigs sold",null,null,null,{"$f":"F27","v":16944},{"$f":"F27","v":16944},{"$f":"F27","v":16944}]
[null,"=","estimated nutrient value / pig sold",null,null,null,{"$f":"SUM((G96*G97*(G98/100)/G99)*G100)/G101","v":0.15019903020665279},{"$f":"SUM((H96*H97*(H98/100)/H99)*H100)/H101","v":0},{"$f":"SUM((I96*I97*(I98/100)/I99)*I100)/I101","v":0}]
[null,"Odour control & Mgmt Fees",null,null,null,null,"* kg/1000 L x 10 = lbs/1000 imp. Gallons"]
[null,null,0,"Odour control (barley straw)"]
[null,"+",3000,"Manure Management Fee"]
[null,"÷",{"$f":"F27","v":16944}," pigs sold"]
[null,"=",{"$f":"(C104+C105)/C106","v":0.17705382436260622}," /pig sold"]
[]
[null,"=",{"$f":"C88+C107-(G102+H102+I102)","v":0.90704247120977788}," /pig sold"]
[]
["Office Supplies"]
[null,"x",2,null,"$/sow"]
[null,"÷",{"$f":"'Farrow-Wean Input'!$G$27","v":28.24},null,"pigs/sow"]
[null,"=",{"$f":"C112/C113","v":7.0821529745042494E-2},null,"/pig sold"]
[]
["Marketing & Transportation"]
[null,null,3.5,"marketing & transportation/weaner pig sold"]
[null,"+",0.19,"Board Levy/weaner pig sold"]
[null,"=",{"$f":"SUM(C117:C118)","v":3.69}," /pig sold"]
[]
["AI Cost"]
[null,null,2.2000000000000002,null,"Number of services/sow"]
[null,"x",11,null,"Cost/dose (semen)"]
[null,"x",{"$f":"G11","v":600},null,"sows"]
[null,"x",{"$f":"G13","v":2.38},null,"Litters/Sow/Year"]
[null,"÷",{"$f":"F27","v":16944},null," pigs sold"]
[null,"=",{"$f":"(((C122*C123)*C124)*C125)/C126","v":2.039518413597734},null," /pig sold"]
[]
["Breeding Herd Replacement"]
[" Sow ",null,180,null,"kg/sow (cull weight)"]
[null,"x",77.3,null,"/100 kg live"]
[null,"=",{"$f":"C130*C131/100","v":139.13999999999999},null,"/sow value of cull"]
[]
[null,null,{"$f":"'Farrow-Wean Input'!H11","v":300},null,"/sow value of replacement"]
[null,"-",{"$f":"C132","v":139.13999999999999},null,"/sow value of cull"]
[null,"=",{"$f":"C134-C132","v":160.86000000000001},null,"net replacement cost"]
[null,"x",42,null,"percent sow culling rate"]
[null,"÷",{"$f":"G27","v":28.24},null,"pigs sold/sow/year"]
[null,"=",{"$f":"(C136*C137/100)/C138","v":2.392393767705383},null,"/pig sold"]
[]
[" Boar ",null,225,null,"kg/boar (cull weight)"]
[null,"x",{"$f":"C131*0.714","v":55.192199999999993},null,"/100 kg live"]
[null,"=",{"$f":"C141*C142/100","v":124.18244999999999},null,"/boar value of cull"]
[]
[null,null,{"$f":"H12","v":3000},null,"/boar value of replacement"]
[null,"-",{"$f":"C143","v":124.18244999999999},null,"/boar value of cull"]
[null,"=",{"$f":"C145-C146","v":2875.8175500000002},null,"net replacement cost"]
[null,"x",50,null,"% culling rate"]
[null,"x",{"$f":"G12","v":3},null,"number of boars"]
[null,"÷",{"$f":"G11","v":600},null,"number of sows"]
[null,"÷",{"$f":"G27","v":28.24},null,"pigs sold/sow/year"]
[null,"=",{"$f":"(C147*C148/100*C149/C150)/C151","v":0.25458724769830032},null,"/pig sold"]
[]
[null,"=",{"$f":"C139+C152","v":2.6469810154036835},null,"Total/pig sold"]
[]
["Property Taxes"]
[null,null,7500,null," taxes on barn and land"]
[null,"÷",{"$f":"F27","v":16944},null," pigs sold"]
[null,"=",{"$f":"C157/C158","v":0.4426345609065156},null," /pig sold"]
[]
[null,null,15,null," taxes on  land"]
[null,"x",{"$f":"'Fixed Cost'!D31","v":40},null,"acres"]
[null,"÷",{"$f":"F27","v":16944},null," pigs sold"]
[null,"=",{"$f":"(C161*C162)/C163","v":3.5410764872521247E-2},null," /pig sold"]
[]
[null,"=",{"$f":"C159+C164","v":0.47804532577903686},null,"Total/pig sold"]
[]
["Interest on Operating Cost"]
[null,null,{"$f":"'Farrow-Wean Summary'!E24","v":43.011288557946813},null,"subtotal operating"]
[null,"÷",2,null,"average"]
[null,"x",{"$f":"365/G13","v":153.36134453781514},null,"days farrow to farrow"]
[null,"÷",365,null,"days per year"]
[null,"x",7,null,"% operating interest rate"]
[null,"=",{"$f":"((C169/C170)*C171/C172)*C173/100","v":0.63251894938157083},null,"/pig sold"]
[]
[]
["³ 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":"Fixed Cost","index":5,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,9],[53,0,54,9]]}
["Fixed Costs"]
[]
[null,"Pig Places1"]
[null,"Gestation",{"$f":"'Farrow-Wean Input'!G11","v":600},27,"ft.2 per Pig Place",null,{"$f":"D4*C4","v":16200},"ft.2 Total"]
[null,"Farrowing",{"$f":"'Farrow-Wean Input'!F25/'Farrow-Wean Input'!G13","v":7297.4789915966394},1.07,"ft.2 per Pig Place",null,7808.3025210084043,"ft.2 Total"]
[]
[]
["Buildings",null,"$/pig place","Total",null,"Barn Equipment",null,"$/pig place","Total"]
[null,"  Gestation",1750,{"$f":"C9*$C$4","v":1050000},{"$f":"\"($\"&ROUND((C9*$C$4)/$G$4,0)&\"/sq.ft.) \"","v":"($65/sq.ft.) "},null,"Gestation",720,{"$f":"H9*$C$4","v":432000},{"$f":"\"($\"&ROUND((H9*$C$4)/$G$4,0)&\"/sq.ft.) \"","v":"($27/sq.ft.) "}]
[null,"  Farrowing",50,{"$f":"C10*$C$5","v":364873.94957983197},{"$f":"\"($\"&ROUND((C10*$C$5)/$G$5,0)&\"/sq.ft.) \"","v":"($47/sq.ft.) "},null,"Farrowing",30,{"$f":"H10*$C$5","v":218924.36974789918},{"$f":"\"($\"&ROUND((H10*$C$5)/$G$5,0)&\"/sq.ft.) \"","v":"($28/sq.ft.) "}]
[null,"  Office and Loading (300 sq.ft.)",25,{"$f":"C11*$C$4","v":15000},{"$f":"\"($\"&ROUND((C11*$C$4)/300,0)&\"/sq.ft.) \"","v":"($50/sq.ft.) "},null,"Other",0,{"$f":"H11*C4","v":0},null,null,"*HIDE*"]
[null,"  Manure Storage",200,{"$f":"C12*$C$4","v":120000},null,null,"Fire Alarm System",5,{"$f":"H12*$C$4","v":3000},null,null,{"$f":"(#REF!-#REF!)/(#REF!+#REF!)","v":{"$error":"#REF!"}}]
[null,"  Standby Generator",41.666600000000003,{"$f":"C13*$C$4","v":24999.960000000003},null,null,"Storage Bins",20,{"$f":"H13*C4","v":12000}]
[null,"Total Barn Cost",null,{"$f":"SUM(D9:D13)","v":1574873.9095798319},null,null,"Total Equipment Cost",null,{"$f":"SUM(I9:I13)","v":665924.36974789924}]
[]
[null,"  Residual Value (End of Useful Life)",null,0.5,null,null,"  Residual Value (End of Useful Life)",null,0.1]
[null,"  Useful Life (years)",null,25,null,null,"  Useful Life (years)",null,10]
[null,"  Owned Barn Equity",null,0.25,null,null,"  Owned Barn Equipment Equity",null,0.25]
[null,"  Barn Financed",null,{"$f":"SUM(1-D18)","v":0.75},null,null,"  Barn Equipment Financed",null,{"$f":"SUM(1-I18)","v":0.75}]
[null,"  Barn Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2,null,null,"  Equipment Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2]
[null,"Buildings Cost",null,null,null,null,"Barn Equipment Cost"]
[null,"  Finance Rate & Term",7.0000000000000007E-2,20,"Years",null,"  Finance Rate & Term",7.0000000000000007E-2,10,"Years"]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C22,D22,D14*D19,0)","v":111492.71700146988},null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H22,I22,I14*I19,0)","v":71109.486577500124}]
[null,"  Buildings Depreciation Cost",null,{"$f":"(D14-(D14*D16))/D17","v":31497.478191596638},null,null,"  Equipment Depreciation Cost",null,{"$f":"(I14-(I14*I16))/I17","v":59933.193277310929}]
[null,"  Owned Building Opportunity Cost ",null,{"$f":"SUM(D14*D18)*(D20)","v":5905.7771609243691},null,null,"  Owned Equipment Opportunity Cost ",null,{"$f":"SUM(I14*I18)*(I20)","v":2497.2163865546222}]
[null,"  Total Cost",null,{"$f":"SUM(D23:D25)","v":148895.97235399089},null,null,"  Total Cost",null,{"$f":"SUM(I23:I25)","v":133539.89624136567}]
[null,{"$f":"\"  Total Cost $/pig sold (based on \"&TEXT('Farrow-Wean Input'!F27,\"#,###\")&\")\"","v":"  Total Cost $/pig sold (based on 16,944)"},null,{"$f":"D26/'Farrow-Wean Input'!F27","v":8.7875337791543249},null,null,{"$f":"\"  Total Cost $/pig sold (based on \"&TEXT('Farrow-Wean Input'!F27,\"#,###\")&\")\"","v":"  Total Cost $/pig sold (based on 16,944)"},null,{"$f":"I26/'Farrow-Wean Input'!F27","v":7.8812497781731388}]
[null,null,null,null,null,null,null,null,null,null,null,"w/o harvest"]
["Land",null,null,null,null,"Breeding Stock - Sows",null,null,null,null,null,{"$f":"-PMT($C$22,$D$22,L12*$D$19,0)","v":{"$error":"#REF!"}}]
[null,"  Average Land value ($/acre)",null,4000,null,null,"  Sow value ($/head)",null,{"$f":"'Farrow-Wean Input'!H11","v":300}]
[null,"  Acres",null,40,null,null,"  Owned Sow Equity",null,0.25]
[null,"  Site preparation cost",null,36000,null,null,{"$f":"\"  Sows Financed (\"&TEXT(I30*I32,\"$#,###\")&\" per head)\"","v":"  Sows Financed ($225 per head)"},null,{"$f":"SUM(1-I31)","v":0.75},null,null,{"$f":"(L12-(L12*$D$16))/$D$17","v":{"$error":"#REF!"}}]
[null,"  Owned Land Equity",null,0.25,null,null,"  Cow Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2]
[null,"  Land Financed",null,{"$f":"SUM(1-D33)","v":0.75},null,null,"Sow cost"]
[null,"  Land Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2,null,null,"  Finance Rate & Term",7.0000000000000007E-2,5,"Years"]
[null,"Land cost ",null,null,null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H35,I35,I30*'Farrow-Wean Input'!G11*I32,0)","v":32925.243749585497}]
[null,"  Finance Rate & Term",0.06,20,"Years",null,"  Owned Sows Opportunity Cost",null,{"$f":"SUM(I30*'Farrow-Wean Input'!G11*I31)*(I33)","v":675}]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C37,D37,((D30*D31)+D32)*D34,0)","v":12816.129875597162},{"$f":"-IPMT(C37,D37,((D30*D31)+D32)*D34,0)","v":0},null,"  Total Cost",null,{"$f":"SUM(I36:I37)","v":33600.243749585497}]
[null,"  Owned Land Opportunity Cost",null,{"$f":"SUM(((D30*D31)+D32)*D33)*(D35)","v":735},null,null,{"$f":"\"  Total Cost $/pig sold (based on \"&TEXT('Farrow-Wean Input'!F27,\"#,###\")&\")\"","v":"  Total Cost $/pig sold (based on 16,944)"},null,{"$f":"I38/'Farrow-Wean Input'!F27","v":1.9830172184599562}]
[null,"  Total Cost",null,{"$f":"SUM(D38:D39)","v":13551.129875597162}]
[null,{"$f":"\"  Total Cost $/pig sold (based on \"&TEXT('Farrow-Wean Input'!F27,\"#,###\")&\")\"","v":"  Total Cost $/pig sold (based on 16,944)"},null,{"$f":"D40/'Farrow-Wean Input'!F27","v":0.79975978963628203},null,"Breeding Stock - Boars"]
[null,null,null,null,null,null,"  Boar value ($/head)",null,{"$f":"'Farrow-Wean Input'!H12","v":3000}]
[null,"Land Rental",null,null,null,null,"  Owned Boar Equity",null,0.25]
[null,"Number of Acres rented out",0,"acres",null,null,{"$f":"\"  Boars Financed (\"&TEXT(I42*I44,\"$#,###\")&\" per head)\"","v":"  Boars Financed ($2,250 per head)"},null,{"$f":"SUM(1-I43)","v":0.75}]
[null,"Land rental rate (income)",100,"/acre",null,null,"  Boar Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2]
[null,null,null,null,null,null,"Boar cost"]
[null,null,null,null,null,null,"  Finance Rate & Term",7.0000000000000007E-2,5,"Years"]
[null,null,null,null,null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H47,I47,I42*'Farrow-Wean Input'!G12*I44,0)","v":1646.2621874792751}]
[null,null,null,null,null,null,"  Owned Boars Opportunity Cost",null,{"$f":"SUM(I42*'Farrow-Wean Input'!G12*I43)*(I45)","v":33.75}]
[null,"Total Capital Investment",null,{"$f":"D14+I14+(D30*D31)+D32+(I30*'Farrow-Wean Input'!G11)+(I42*'Farrow-Wean Input'!G12)","v":2625798.2793277311},null,null,"  Total Cost",null,{"$f":"SUM(I48:I49)","v":1680.0121874792751}]
[null,"Total Capital Investment / Sow Place",null,{"$f":"D50/C4","v":4376.3304655462189},null,null,{"$f":"\"  Total Cost $/pig sold (based on \"&TEXT('Farrow-Wean Input'!F27,\"#,###\")&\")\"","v":"  Total Cost $/pig sold (based on 16,944)"},null,{"$f":"I50/'Farrow-Wean Input'!F27","v":9.9150860922997824E-2}]
[]
[]
["¹ FOOTNOTE: The number of square feet in the building and the cost per square foot for buildings and equipment are approximations only.  A certified building plan which is designed according to the average inventory of grower-finisher pigs should be used in order to get the exact dimensions and area for new buildings."]
[]
["1 sq.ft. = 0.0929 sq.m;  1 sq.m.= 10.764 sq.ft.;  1 ft.= 0.3048 m"]
["1 cubic metre = 1000 litres; 1 cubic metre = 35.314 cubic feet;  1 cubic metre = 219.97 imperial gallons"]
[]
[]
[]
[null,null,"pmt","years","loan amt",null,"interest"]
[null,"Buildings",{"$f":"D23","v":111492.71700146988},{"$f":"D22","v":20},{"$f":"D14*D19","v":1181155.4321848738},null,{"$f":"SUM(((C62*D62)-E62)/D62)","v":52434.945392226182}]
[null,"equipment",{"$f":"I23","v":71109.486577500124},{"$f":"I17","v":10},{"$f":"I14*I19","v":499443.27731092443},null,{"$f":"SUM(((C63*D63)-E63)/D63)","v":21165.158846407681}]
[null,"land",{"$f":"D38","v":12816.129875597162},{"$f":"D37","v":20},{"$f":"((D31*D30)+D32)*D34","v":147000},null,{"$f":"SUM(((C64*D64)-E64)/D64)","v":5466.1298755971629}]
[null,"sows",{"$f":"I36","v":32925.243749585497},{"$f":"I35","v":5},{"$f":"I30*'Farrow-Wean Input'!H11*I32","v":67500},null,{"$f":"SUM(((C65*D65)-E65)/D65)","v":19425.243749585497}]
[null,"boars",{"$f":"I48","v":1646.2621874792751},{"$f":"I47","v":5},{"$f":"I42*'Farrow-Wean Input'!G12*'Fixed Cost'!I44","v":6750},null,296.26218747927521]
[null,null,null,null,null,null,{"$f":"SUM(G62:G64)","v":79066.234114231032},"total"]
[null,null,null,null,null,null,{"$f":"G67/'Farrow-Wean Input'!F27","v":4.6663263759579223},"per pig"]

{"sheet":"Ingredient-Summary","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,6]]}
[]
[null,null,"  Summary of Purchased Feeds Used"]
[]
[null,"Number of Sows",null,{"$f":"'Farrow-Wean Input'!$G$11","v":600}]
[null,"Total Pigs Fed",null,{"$f":"'Farrow-Wean Input'!$F$25","v":17368}]
[]
[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'!F35<=0,0,('Farrow-Wean Input'!F34*'Farrow-Wean Input'!F33)*'Farrow-Wean Input'!F20/1000)","v":567.03599999999994},{"$f":"D10/12","v":47.252999999999993},{"$f":"(D10/$D$5)*1000","v":32.648318747121138},{"$f":"F10*2.2046","v":71.976483509903261}]
[null,"Lactating Sow",null,{"$f":"IF('Farrow-Wean Input'!G35<=0,0,('Farrow-Wean Input'!G34*'Farrow-Wean Input'!G33)*'Farrow-Wean Input'!F20/1000)","v":194.922},{"$f":"D11/12","v":16.243500000000001},{"$f":"(D11/$D$5)*1000","v":11.223053892215569},{"$f":"F11*2.2046","v":24.742344610778446}]
[null,"Boar",null,{"$f":"IF('Farrow-Wean Input'!H35<=0,0,('Farrow-Wean Input'!H34*'Farrow-Wean Input'!H33)*'Farrow-Wean Input'!F21/1000)","v":3.2850000000000001},{"$f":"D12/12","v":0.27374999999999999},{"$f":"(D12/$D$5)*1000","v":0.1891409488714878},{"$f":"F12*2.2046","v":0.41698013588208205}]
[null,"Creep",null,{"$f":"IF('Farrow-Wean Input'!I35<=0,0,('Farrow-Wean Input'!I34*'Farrow-Wean Input'!F25)/1000)","v":8.6839999999999993},{"$f":"D13/12","v":0.72366666666666657},{"$f":"(D13/$D$5)*1000","v":0.5},{"$f":"F13*2.2046","v":1.1023000000000001}]
[null,"Total",null,{"$f":"SUM(D10:D13)","v":773.92699999999991},{"$f":"SUM(E10:E13)","v":64.493916666666664},{"$f":"SUM(F10:F13)","v":44.560513588208195},{"$f":"SUM(G10:G13)","v":98.238108256563791}]