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

{"sheet":"Assumptions","index":1,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,0,20,0],[22,0,26,0],[14,0,16,0],[10,0,12,0],[4,0,8,0]]}
[]
["Swine (26 to 121 kg) Finishing Cost of Production"]
[]
[]
[{"$f":"\"The following 26 to 121 kg budget is based on the assumption that all feed is purchased or home-mixed. The budget includes a land investment cost for \"&'Finish Input'!G161&\" acres, with \"&'Finish Input'!G162&\" acres rented out at $\"&'Finish Input'!G163&\" per acre, of the estimated \"&ROUND(((('Finish-Worksheet'!D133*'Finish Input'!F140)/(40.768*2))*2.4709661),0)&\" to \"&ROUND(((('Finish-Worksheet'!D133*'Finish Input'!F140)/(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 following 26 to 121 kg budget is based on the assumption that all feed is purchased or home-mixed. The budget includes a land investment cost for 40 acres, with 0 acres rented out at $60 per acre, of the estimated 232 to 358 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."}]
[]
[]
[]
[]
[]
[{"$f":"\"The budget includes an assumption that 1.5% of the market pigs are sold as lightweight pigs. It is assumed that when light weight pigs are sold, they will have a salvage value. Therefore, total marketings are reduced by \"&'Finish Input'!H35&\"% to compensate for the lightweight pigs.\"","v":"The budget includes an assumption that 1.5% of the market pigs are sold as lightweight pigs. It is assumed that when light weight pigs are sold, they will have a salvage value. Therefore, total marketings are reduced by 2.44% to compensate for the lightweight pigs."}]
[]
[]
[]
["The budget includes an assumption that this particular operation is \"all-in, all-out\" by room. Space allocations for finishing pigs are in accordance with Recommended Code of Practice for the Care and Handling of Farm Animals: Pigs."]
[]
[]
[]
["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 the feed intakes of their animals. Please consult with a nutritionist for diet information suggestions."]
[]
[]
[]
["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 finishing 26 to 121 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":"Finish Summary","index":2,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,4,2,5],[2,7,2,8],[67,0,69,10],[43,0,43,10]]}
[{"$f":"\"Swine (26 to 121 kg) Finishing Summary - \"&Introduction!G12","v":"Swine (26 to 121 kg) Finishing Summary - April, 2023"}]
[]
[null,null,null,null,"Purchased Feed",null,null,"Home-Mixed Feed"]
[null,null,null,null,"$/Pig","Total",null,"$/Pig","Total",null,"Your "]
["A. Operating Costs",null,null,null,"Sold","Cost",null,"Sold","Cost",null,"Cost"]
["1.","Feed Costs:"]
[null,"1.01 Grower 1",null,null,{"$f":"'Finish-Worksheet'!D17","v":33.549999999999997},{"$f":"ROUND(E7*'Finish Input'!$G$36,0)","v":381681},null,{"$f":"'Finish-Worksheet'!D47","v":24.1},{"$f":"ROUND(H7*'Finish Input'!$G$36,0)","v":274173}]
[null,"1.02 Grower 2",null,null,{"$f":"'Finish-Worksheet'!D27","v":87.1},{"$f":"ROUND(E8*'Finish Input'!$G$36,0)","v":990891},null,{"$f":"'Finish-Worksheet'!D57","v":68.87},{"$f":"ROUND(H8*'Finish Input'!$G$36,0)","v":783498}]
["","1.03 Finisher ",null,null,{"$f":"'Finish-Worksheet'!D37","v":42.91},{"$f":"ROUND(E9*'Finish Input'!$G$36,0)","v":488164},null,{"$f":"'Finish-Worksheet'!D67","v":29.61},{"$f":"ROUND(H9*'Finish Input'!$G$36,0)","v":336857}]
["Total Feed Cost",null,null,null,{"$f":"SUM(E7:E9)","v":163.56},{"$f":"SUM(F7:F9)","v":1860736},null,{"$f":"SUM(H7:H9)","v":122.58},{"$f":"SUM(I7:I9)","v":1394528}]
[]
["2.","Other Operating Costs:"]
[null,"2.01 Weanling Cost",null,null,{"$f":"'Finish-Worksheet'!D78","v":89.39},{"$f":"ROUND(E13*'Finish Input'!$G$36,0)","v":1016943},null,{"$f":"E13","v":89.39},{"$f":"F13","v":1016943}]
[null,"2.02 Veterinary Medicine & Supplies",null,null,{"$f":"'Finish-Worksheet'!D84","v":1.4679419583836519},{"$f":"ROUND(E14*'Finish Input'!$G$36,0)","v":16700},null,{"$f":"E14","v":1.4679419583836519},{"$f":"F14","v":16700}]
[null,"2.03 Maintenance & Repairs",null,null,{"$f":"'Finish-Worksheet'!D90","v":2.4263586259908565},{"$f":"ROUND(E15*'Finish Input'!$G$36,0)","v":27603},null,2.4263586259908565,27603]
[null,"2.04 Hydro & Propane",null,null,{"$f":"'Finish-Worksheet'!D96","v":3.6169386648844619},{"$f":"ROUND(E16*'Finish Input'!$G$36,0)","v":41148},null,3.6169386648844619,41148]
[null,"2.05 Insurance",null,null,{"$f":"'Finish-Worksheet'!D118","v":2.5484004619999987},{"$f":"ROUND(E17*'Finish Input'!$G$36,0)","v":28992},null,2.5484004619999987,28992]
[null,"2.06 Manure Costs",null,null,{"$f":"'Finish-Worksheet'!D164","v":2.231130670752397},{"$f":"ROUND(E18*'Finish Input'!$G$36,0)","v":25382},null,2.231130670752397,25382]
[null,"2.07 Office Supplies",null,null,{"$f":"'Finish-Worksheet'!D170","v":0.1051246446434741},{"$f":"ROUND(E19*'Finish Input'!$G$36,0)","v":1196},null,0.1051246446434741,1196]
[null,"2.08 Marketing & Transport",null,null,{"$f":"'Finish-Worksheet'!D179","v":9.6100000000000012},{"$f":"ROUND(E20*'Finish Input'!$G$36,0)","v":109328},null,9.6100000000000012,109328]
[null,"2.09 Property Tax",null,null,{"$f":"'Finish-Worksheet'!D191","v":0.8790071607087736},{"$f":"ROUND(E21*'Finish Input'!$G$36,0)","v":10000},null,0.8790071607087736,10000]
["Subtotal Operating Costs",null,null,null,{"$f":"SUM(E13:E21)+E10","v":275.83490218736358},{"$f":"SUM(F13:F21)+F10","v":3138028},null,{"$f":"SUM(H13:H21)+H10","v":234.85490218736359},{"$f":"SUM(I13:I21)+I10","v":2671820}]
[null,"2.10 Interest on Operating Costs",null,null,{"$f":"'Finish-Worksheet'!D208","v":5.23072103064231},{"$f":"ROUND(E23*'Finish Input'!$G$36,0)","v":59507},null,{"$f":"'Finish-Worksheet'!D225","v":4.6438088388614878},{"$f":"ROUND(H23*'Finish Input'!$G$36,0)","v":52830}]
["Total Operating Costs",null,null,null,{"$f":"SUM(E22:E23)","v":281.0656232180059},{"$f":"SUM(F22:F23)","v":3197535},null,{"$f":"SUM(H22:H23)","v":239.49871102622507},{"$f":"SUM(I22:I23)","v":2724650}]
[]
["B. Fixed Costs"]
["3.","Depreciation:"]
[null,"3.01 Buildings & Manure Storage",null,null,{"$f":"'Finish-Worksheet'!D238","v":6.4261049093639881},{"$f":"ROUND(E28*'Finish Input'!$G$36,0)","v":73106},null,{"$f":"'Finish-Worksheet'!D253","v":6.5685040693988102},{"$f":"ROUND(H28*'Finish Input'!$G$36,0)","v":74726}]
[null,"3.02 Equipment",null,null,{"$f":"'Finish-Worksheet'!D245","v":3.9130434782608696},{"$f":"ROUND(E29*'Finish Input'!$G$36,0)","v":44517},null,{"$f":"'Finish-Worksheet'!D260","v":4.4275791098533572},{"$f":"ROUND(H29*'Finish Input'!$G$36,0)","v":50370}]
["Total Depreciation Cost",null,null,null,{"$f":"SUM(E28:E29)","v":10.339148387624858},{"$f":"SUM(F28:F29)","v":117623},null,{"$f":"SUM(H28:H29)","v":10.996083179252167},{"$f":"SUM(I28:I29)","v":125096}]
[]
["4.","Investment:",null,null,null,""]
[null,"4.01 Land",null,null,{"$f":"'Finish-Worksheet'!D278","v":0.3529213750245726},{"$f":"ROUND(E33*'Finish Input'!$G$36,0)","v":4015},null,{"$f":"E33","v":0.3529213750245726},{"$f":"F33","v":4015}]
[null,"4.02 Buildings & Manure Storage",null,null,{"$f":"'Finish-Worksheet'!D287","v":2.6676263139442988},{"$f":"ROUND(E34*'Finish Input'!$G$36,0)","v":30348},null,{"$f":"'Finish-Worksheet'!D304","v":2.7274537388200395},{"$f":"F34","v":30348}]
[null,"4.03 Equipment",null,null,{"$f":"'Finish-Worksheet'!D295","v":0.67405565360001418},{"$f":"ROUND(E35*'Finish Input'!$G$36,0)","v":7668},null,{"$f":"'Finish-Worksheet'!D312","v":0.75382555343433544},{"$f":"ROUND(H35*'Finish Input'!$G$36,0)","v":8576}]
["Total Investment Cost",null,null,null,{"$f":"SUM(E33:E35)","v":3.6946033425688856},{"$f":"SUM(F33:F35)","v":42031},null,{"$f":"SUM(H33:H35)","v":3.8342006672789477},{"$f":"SUM(I33:I35)","v":42939}]
["Total Fixed Costs",null,null,null,{"$f":"E30+E36","v":14.033751730193744},{"$f":"F30+F36","v":159654},null,{"$f":"H30+H36","v":14.830283846531115},{"$f":"I30+I36","v":168035}]
[]
["C.  Labour"]
[null,"Wages, benefits and hired manager",null,null,{"$f":"'Finish-Worksheet'!D318","v":5.9238050574485674},{"$f":"ROUND(E40*'Finish Input'!$G$36,0)","v":67392},null,{"$f":"E40","v":5.9238050574485674},{"$f":"F40","v":67392}]
[]
["Total Cost of Production",null,null,null,{"$f":"E24+E37+E40","v":301.02318000564821},{"$f":"F24+F37+SUM(F40:F40)","v":3424581},null,{"$f":"H24+H37+H40","v":260.25279993020473},{"$f":"I24+I37+SUM(I40:I40)","v":2960077}]
[]
["Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null," Per Pig","Total",null," Per Pig","Total"]
[null,"Market Price ($ per 100kg)",null,null,{"$f":"'Finish Input'!E12","v":202},null,null,{"$f":"E47","v":202}]
[null,"Market weight (shrunk-kg/hog live)",null,null,{"$f":"('Finish Input'!I20)*(1-('Finish Input'!H35/100))","v":118.0476},null,null,118.0476]
[null,"Dressing %",null,null,{"$f":"'Finish Input'!I13","v":80},null,null,80]
[null,"Premium per head sold",null,null,{"$f":"'Finish Input'!E13","v":2},null,null,2]
[null,"Land rental per head sold",null,null,{"$f":"SUM(('Finish Input'!G162*'Finish Input'!G163)/'Finish Input'!G36)","v":0},null,null,0]
[null,"Gross Revenue  / hog",null,null,{"$f":"SUM(((E48*E49)*('Finish Input'!I12/100)*E47)/10000+E50)+E51","v":211.84141376000005},{"$f":"ROUND(E52*'Finish Input'!$G$36,0)","v":2410008},null,211.84141376000005,{"$f":"ROUND(H52*'Finish Input'!$G$36,0)","v":2410008}]
[]
["Marginal Returns "]
[null,"Over Operating Costs",null,null,{"$f":"SUM(E52-E24)","v":-69.224209458005845},{"$f":"ROUND(E55*'Finish Input'!$G$36,0)","v":-787527},null,{"$f":"SUM(E52-H24)","v":-27.657297266225015},{"$f":"ROUND(H55*'Finish Input'!$G$36,0)","v":-314642}]
[null,"Over Operating & Labour Costs",null,null,{"$f":"SUM(E52-E24-E40)","v":-75.148014515454406},{"$f":"ROUND(E56*'Finish Input'!$G$36,0)","v":-854919},null,{"$f":"SUM(E52-H24-H40)","v":-33.581102323673583},{"$f":"ROUND(H56*'Finish Input'!$G$36,0)","v":-382034}]
[null,"Over Total Costs (Net Profit)",null,null,{"$f":"SUM(E52-E42)","v":-89.181766245648163},{"$f":"ROUND(E57*'Finish Input'!$G$36,0)","v":-1014574},null,{"$f":"SUM(E52-H42)","v":-48.411386170204679},{"$f":"ROUND(H57*'Finish Input'!$G$36,0)","v":-550751}]
[]
["Operating Expense Ratio",null,null,null,{"$f":"SUM(E24/E52)","v":1.3267737324319009},null,null,{"$f":"SUM(H24/E52)","v":1.1305566120209083}]
[]
["Breakeven Selling Price",null,null,null,"$/100 kg ","$/cwt ",null,"$/100 kg ","$/cwt "]
[null,"Operating Costs",null,null,{"$f":"(E24/(('Finish Input'!$I$20)*('Finish Input'!$I$13/100)*('Finish Input'!$I$12/100)))*100","v":263.96095343539241},{"$f":"E62/2.2046","v":119.73190303701007},null,{"$f":"(H24/(('Finish Input'!$I$20)*('Finish Input'!$I$13/100)*('Finish Input'!$I$12/100)))*100","v":224.92365798856596},{"$f":"H62/2.2046","v":102.02470198156851}]
[null,"Operating & Labour Costs",null,null,{"$f":"((E24+E40)/(('Finish Input'!$I$20)*('Finish Input'!$I$13/100)*('Finish Input'!$I$12/100)))*100","v":269.52425645703835},{"$f":"E63/2.2046","v":122.25540073348378},null,{"$f":"((H24+H40)/(('Finish Input'!$I$20)*('Finish Input'!$I$13/100)*('Finish Input'!$I$12/100)))*100","v":230.48696101021187},{"$f":"H63/2.2046","v":104.54819967804221}]
[null,"Total Costs",null,null,{"$f":"(E42/(('Finish Input'!$I$20)*('Finish Input'!$I$13/100)*('Finish Input'!$I$12/100)))*100","v":282.70396319087922},{"$f":"E64/2.2046","v":128.23367649046503},null,{"$f":"(H42/(('Finish Input'!$I$20)*('Finish Input'!$I$13/100)*('Finish Input'!$I$12/100)))*100","v":244.41472570454988},{"$f":"H64/2.2046","v":110.86579229998634}]
[]
["Return On Assets (ROA)",null,null,null,{"$f":"SUM((E57+E23+E36)*'Finish Input'!$I$24)/(('Finish Input'!$H$85-'Finish Input'!H72-'Finish Input'!H64)+(((E52-E51)/2)*'Finish Input'!I28))","v":-0.31390566514895996},null,null,{"$f":"SUM((H57+H23+H36)*'Finish Input'!$I$24)/('Finish Input'!$H$85+(((E52-E51)/2)*'Finish Input'!I28))","v":-0.15087705465803322}]
[]
["Note: This budget is only a guide and is not intended to be an in-depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user. No liability for decisions based on this publication is assumed. "]

{"sheet":"Risk Analysis","index":3,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,0,61,6],[0,0,0,6],[37,0,37,6],[39,2,39,6],[46,0,46,6],[48,2,48,6]]}
["Risk & Sensitivity Analysis (Stress Test)"]
["A.  Operating Costs"]
[null,"Feed cost",{"$f":"'Finish Summary'!E10","v":163.56},{"$f":"'Finish Summary'!H10","v":122.58}]
[null,"Weanling cost",{"$f":"'Finish Summary'!E13","v":89.39},{"$f":"'Finish Summary'!H13","v":89.39}]
[null,"Other Operating Costs",{"$f":"SUM('Finish Summary'!E24-'Finish Summary'!E13-'Finish Summary'!E10)","v":28.115623218005908},{"$f":"SUM('Finish Summary'!H24-'Finish Summary'!H13-'Finish Summary'!H10)","v":27.528711026225082}]
[null,"Subtotal",{"$f":"SUM(C3:C5)","v":281.0656232180059},{"$f":"SUM(D3:D5)","v":239.49871102622507}]
["B.  Fixed Costs",null,{"$f":"'Finish Summary'!E37","v":14.033751730193744},{"$f":"'Finish Summary'!H37","v":14.830283846531115}]
["C.  Labour",null,{"$f":"'Finish Summary'!E40","v":5.9238050574485674},{"$f":"'Finish Summary'!H40","v":5.9238050574485674}]
["Total Costs",null,{"$f":"SUM(C6:C8)","v":301.02318000564821},{"$f":"SUM(D6:D8)","v":260.25279993020473}]
[]
["Estimated Farmgate"]
[null,"Price ($ per 100kg)",{"$f":"'Finish Input'!E12","v":202},{"$f":"'Finish Input'!E12","v":202}]
[]
[]
[null,"Percent Market Price Change",-0.1]
[null,"Percent Feed Cost Change",0.1]
[null,"Percent Weanling Cost Change",0.05]
[]
[]
[null,null,"Purchased Feed","Home-Mixed Feed"]
[null,null,"Per Pig","Per Pig"]
[null,"Market Price ($ per 100kg)",{"$f":"SUM(C12*(1+C15))","v":181.8},{"$f":"SUM(D12*(1+C15))","v":181.8}]
[null,"Feed Cost",{"$f":"SUM(C3+(C3*C16))","v":179.916},{"$f":"SUM(D3+(D3*C16))","v":134.83799999999999}]
[null,"Weanling Cost",{"$f":"SUM(('Finish Input'!$G$105*(1+C17))/100*'Finish Input'!$G$107*'Finish Input'!$G$106*'Finish Input'!$G$32/'Finish Input'!$G$36)","v":93.861124744512168},{"$f":"SUM(('Finish Input'!$G$105*(1+C17))/100*'Finish Input'!$G$107*'Finish Input'!$G$106*'Finish Input'!$G$32/'Finish Input'!$G$36)","v":93.861124744512168}]
[]
[{"$f":"\"Stress Test Scenario = Market Price \"&IF(C15<0,\"Down\",\"Up\")&\" \"&ABS(C15*100)&\"%, Feed Price \"&IF(C16<0,\"Down\",\"Up\")&\" \"&ABS(C16*100)&\"% and Weanling Cost \"&IF(C17<0,\"Down\",\"Up\")&\" \"&ABS(C17*100)&\"%\"","v":"Stress Test Scenario = Market Price Down 10%, Feed Price Up 10% and Weanling Cost Up 5%"}]
[null,"Operating Costs",{"$f":"SUM(C5+C23+C24)","v":301.89274796251806},{"$f":"SUM(D5+D23+D24)","v":256.22783577073722}]
[null,"Total Costs",{"$f":"C7+C8+C27","v":321.85030475016038},{"$f":"D7+D8+D27","v":276.98192467471688}]
[null,"Gross Revenue / hog",{"$f":"SUM((('Finish Summary'!$E$48*'Finish Input'!$I$13)*('Finish Input'!$I$12/100)*C22)/10000+'Finish Input'!$E$13)+'Finish Summary'!$E$51","v":190.85727238400003},{"$f":"SUM((('Finish Summary'!$E$48*'Finish Input'!$I$13)*('Finish Input'!$I$12/100)*D22)/10000+'Finish Input'!$E$13)+'Finish Summary'!$E$51","v":190.85727238400003}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C29-C27)","v":-111.03547557851803},{"$f":"SUM(D29-D27)","v":-65.370563386737189}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C29-C27-C8)","v":-116.95928063596659},{"$f":"SUM(D29-D27-D8)","v":-71.29436844418575}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C29-C28)","v":-130.99303236616035},{"$f":"SUM(D29-D28)","v":-86.124652290716853}]
[null,"Operating Expense Ratio",{"$f":"SUM(C27/C29)","v":1.5817723065596234},{"$f":"SUM(D27/D29)","v":1.3425102044590329}]
[null,"Return on Asset (ROA)",{"$f":"SUM(((C33+'Finish Summary'!$E$23+'Finish Summary'!$E$36)*'Finish Input'!$I$24)/('Finish Input'!$H$85+(((C29-'Finish Summary'!$E$51/2))*'Finish Input'!$I39)))","v":-0.53349007473559584},{"$f":"SUM(((D33+'Finish Summary'!$E$23+'Finish Summary'!$E$36)*'Finish Input'!$I$24)/('Finish Input'!$H$85+(((D29-'Finish Summary'!$E$51/2))*'Finish Input'!$I39)))","v":-0.33739533491221763}]
[]
[]
["Estimated Breakeven Canadian Dollar Analysis*"]
[]
[null,"*Purchased Feed","Est. US Futures Price (USD per cwt)"]
[null,null,{"$f":"SUM($E$41-4)","v":68.838610178717218},{"$f":"SUM($E$41-2)","v":70.838610178717218},{"$f":"'Finish Input'!F14","v":72.838610178717218},{"$f":"SUM($E$41+2)","v":74.838610178717218},{"$f":"SUM($E$41+4)","v":76.838610178717218}]
["Breakeven CDN Dollar ($1 Cdn = $ USD)"]
[null,"Operating Costs",{"$f":"SUM(C41/(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.51259446588384017},{"$f":"SUM(D41/(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.52748711012965088},{"$f":"SUM(E41/(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.5423797543754616},{"$f":"SUM(F41/(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.55727239862127231},{"$f":"SUM(G41/(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.57216504286708303}]
[null,"Operating & Labour Costs",{"$f":"SUM(C41/((('Finish Summary'!$E$24+'Finish Summary'!C40)/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.51259446588384017},{"$f":"SUM(D41/((('Finish Summary'!$E$24+'Finish Summary'!D40)/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.52748711012965088},{"$f":"SUM(E41/((('Finish Summary'!$E$24+'Finish Summary'!E40)/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.53174046825748378},{"$f":"SUM(F41/((('Finish Summary'!$E$24+'Finish Summary'!F40)/2.2046)+('Finish Input'!$H$13/2.2046)))","v":2.4374932047608443E-3},{"$f":"SUM(G41/((('Finish Summary'!$E$24+'Finish Summary'!G40)/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.57216504286708303}]
[null,"Operating, Fixed & Labour Costs",{"$f":"SUM(C41/(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.48022300135479806},{"$f":"SUM(D41/(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.49417514246014732},{"$f":"SUM(E41/(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.50812728356549663},{"$f":"SUM(F41/(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.52207942467084589},{"$f":"SUM(G41/(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046)))","v":0.53603156577619515}]
[]
["Estimated Breakeven US Futures Price Analysis*"]
[]
[null,"*Purchased Feed","Canadian Dollar ($1 Cdn = $ USD)"]
[null,null,{"$f":"SUM($E$50-0.02)","v":0.72},{"$f":"SUM($E$50-0.01)","v":0.73},{"$f":"'Finish Input'!E11","v":0.74},{"$f":"SUM($E$50+0.01)","v":0.75},{"$f":"SUM($E$50+0.02)","v":0.76}]
[null,null,{"$f":"SUM(1/C50)","v":1.3888888888888888},{"$f":"SUM(1/D50)","v":1.3698630136986301},{"$f":"SUM(1/E50)","v":1.3513513513513513},{"$f":"SUM(1/F50)","v":1.3333333333333333},{"$f":"SUM(1/G50)","v":1.3157894736842106}]
["Breakeven Futures Price ($ USD)"]
[null,"Operating Costs",{"$f":"SUM(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046))/C$51","v":96.69202971830002},{"$f":"SUM(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046))/D$51","v":98.034974575498637},{"$f":"SUM(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046))/E$51","v":99.377919432697254},{"$f":"SUM(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046))/F$51","v":100.72086428989586},{"$f":"SUM(('Finish Summary'!$E$24/2.2046)+('Finish Input'!$H$13/2.2046))/G$51","v":102.06380914709446}]
[null,"Operating & Labour Costs",{"$f":"SUM((('Finish Summary'!$E$24+'Finish Summary'!$E$40)/2.2046)+('Finish Input'!$H$13/2.2046))/C$51","v":98.626684368287783},{"$f":"SUM((('Finish Summary'!$E$24+'Finish Summary'!$E$40)/2.2046)+('Finish Input'!$H$13/2.2046))/D$51","v":99.996499428958444},{"$f":"SUM((('Finish Summary'!$E$24+'Finish Summary'!$E$40)/2.2046)+('Finish Input'!$H$13/2.2046))/E$51","v":101.3663144896291},{"$f":"SUM((('Finish Summary'!$E$24+'Finish Summary'!$E$40)/2.2046)+('Finish Input'!$H$13/2.2046))/F$51","v":102.73612955029978},{"$f":"SUM((('Finish Summary'!$E$24+'Finish Summary'!$E$40)/2.2046)+('Finish Input'!$H$13/2.2046))/G$51","v":104.10594461097043}]
[null,"Operating, Fixed & Labour Costs",{"$f":"SUM(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046))/C$51","v":103.20996534703198},{"$f":"SUM(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046))/D$51","v":104.64343708796298},{"$f":"SUM(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046))/E$51","v":106.07690882889398},{"$f":"SUM(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046))/F$51","v":107.51038056982497},{"$f":"SUM(('Finish Summary'!$E$42/2.2046)+('Finish Input'!$H$13/2.2046))/G$51","v":108.94385231075597}]
[]
[{"$f":"\"Breakeven Canadian Dollar = Est. US Futures / (Cost + Basis)  (eg. ($\"&TEXT(E41,\"0.00\")&\" /(($\"&TEXT('Finish Summary'!E42,\"0.00\")&\" + $\"&TEXT('Finish Input'!H13,\"0.00\")&\")/2.2046)) = $\"&TEXT(E45,\"0.0000\")&\" US)\"","v":"Breakeven Canadian Dollar = Est. US Futures / (Cost + Basis)  (eg. ($72.84 /(($301.02 + $15.00)/2.2046)) = $0.5081 US)"}]
[{"$f":"\"Breakeven Est. US Futures = (Cost + Basis) / Cdn Dollar  (eg. ((($\"&TEXT('Finish Summary'!E42,\"0.00\")&\" + $\"&TEXT('Finish Input'!H13,\"0.00\")&\")/2.2046)/(1/\"&TEXT(E50,\"0.0000\")&\")) = $\"&TEXT(E55,\"0.00\")&\")\"","v":"Breakeven Est. US Futures = (Cost + Basis) / Cdn Dollar  (eg. ((($301.02 + $15.00)/2.2046)/(1/0.7400)) = $106.08)"}]
[]
["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":"Finish Input","index":4,"n_rows":169,"n_cols":11,"rows_kept":169,"cut":false,"hidden":false,"merged":[[1,0,1,11],[88,0,88,10],[86,0,87,10],[54,4,54,7],[41,7,41,8]]}
[]
["Swine (26-121 kg) Finishing Production Cost Assumptions"]
[]
[""]
["1.","This input table outlines the cost of production for a finishing enterprise"]
["2.","Buildings and equipment are valued at new cost."]
["3.","Purchased or home-mixed feed is used."]
["4.","Manure haulage is contracted out."]
[]
[null,null,"Weanling Cost based on ",null,null,87]
[null,null,"$1 Canadian Dollar",null,0.74,null,"USD     or $1 USD =",{"$f":"SUM(1/E11)","v":1.3513513513513513},"Canadian Dollar"]
[null,null,"Market Price/100kg",null,202,"  or:",{"$f":"E12/100/2.2046","v":0.91626598929511016}," /lb",110,"Market Index"]
[null,null,"Premium/head",null,2,null,"Basis ($ per 100kg)",15,80,"% Dress"]
[null,null,"Estimated US Futures Price",null,null,{"$f":"SUM((E12+H13)/2.2046)/H11","v":72.838610178717218},"USD"]
[]
["Indicators of Productivity"]
[null,null,null,null,null,null,"Grower 1","Grower 2","Finisher",null,"Total"]
["Number of Pigs Purchased",null,null,null,null,null,12000,{"$f":"G24","v":11886},{"$f":"H24","v":11773},null,{"$f":"G18","v":12000}]
["Average Beginning Weight (kg)",null,null,null,null,null,26,{"$f":"G20","v":50},{"$f":"H20","v":100},null,{"$f":"G19","v":26}]
["Average Ending Weight (kg)",null,null,null,null,null,50,100,121,null,{"$f":"I20","v":121}]
["Percent Mortality",null,null,null,null,null,0.95,0.95,0.95,null,{"$f":"((G18-I24)/G18)*100","v":2.8250000000000002}]
["Days on Feed",null,null,null,null,null,23,65,28,null,{"$f":"SUM(G22:I22)","v":116}]
["Feed Conversion Ratio ",null,null,null,null,null,1.95,3,3.5,null,{"$f":"(G23*(G20-G19)+H23*(H20-H19)+I23*(I20-I19))/(I20-G19)","v":2.8452631578947369}]
["Number of Pigs (Ending)",null,null,null,null,null,{"$f":"ROUND(G18-(G18*G21/100),0)","v":11886},{"$f":"ROUND(H18-(H18*H21/100),0)","v":11773},{"$f":"ROUND(I18-(I18*I21/100),0)","v":11661},null,{"$f":"I24","v":11661}]
["Weight Gain/Pig (kg)",null,null,null,null,null,{"$f":"G20-G19","v":24},{"$f":"H20-H19","v":50},{"$f":"I20-I19","v":21},null,{"$f":"SUM(G25:I25)","v":95}]
["Feed Disappearance/Pig (kg)",null,null,null,null,null,{"$f":"G23*G25","v":46.8},{"$f":"H23*H25","v":150},{"$f":"I23*I25","v":73.5},null,{"$f":"SUM(G26:I26)","v":270.3}]
["Average Daily Gain (kg)",null,null,null,null,null,{"$f":"(G20-G19)/G22","v":1.0434782608695652},{"$f":"(H20-H19)/H22","v":0.76923076923076927},{"$f":"(I20-I19)/I22","v":0.75},null,{"$f":"K25/K22","v":0.81896551724137934}]
["Average Number Pigs in Barn",null,null,null,null,null,{"$f":"((G18+G24)/2)/$G$39","v":4024.6273972602744},{"$f":"((H18+H24)/2)/$G$39","v":3986.3794520547949},{"$f":"((I18+I24)/2)/$G$39","v":3948.4684931506854},null,{"$f":"SUM(G28:I28)/3","v":3986.4917808219179}]
[]
["Productivity Profile",null,null,null,null,null,"Total"]
[]
["Pigs Purchased",null,null,null,null,null,{"$f":"G18","v":12000}]
["Pigs Died",null,null,null,null,null,{"$f":"ROUND(G32*K21/100,0)","v":339},{"$f":"K21","v":2.8250000000000002}," % mortality"]
["Pigs available for marketing",null,null,null,null,null,{"$f":"I24","v":11661}]
["Less Light Weight Pig Adjustment  ",null,null,null,null,null,{"$f":"G34*H35/100","v":284.52839999999998},2.44,"%"]
["Pigs Sold at full market value",null,null,null,null,null,{"$f":"G34-G35","v":11376.471600000001}]
["Washing and restocking days",null,null,null,null,null,7]
["Total Days to Market",null,null,null,null,null,{"$f":"G22+H22+I22+G37","v":123}]
["Turnover (365 / days to market)",null,null,null,null,null,{"$f":"365/G38","v":2.9674796747967478}]
[]
["Feed Requirements and Costs"]
[null,null,null,null,null,null,null,"Ration Cost per tonne"]
[null,null,null,null,null,"FCR *","kg/pig","Purchased","   Home-Mixed"]
["    Grower 1",null,null,null,null,{"$f":"G23","v":1.95},{"$f":"F44*(G20-G19)","v":46.8},679.58,{"$f":"'Feed-Summary'!H27","v":488.20025000000004}]
["    Grower 2",null,null,null,null,{"$f":"H23","v":3},{"$f":"F45*(H20-H19)","v":150},550.5,{"$f":"'Feed-Summary'!H52","v":435.25662499999999}]
["    Finisher Ration",null,null,null,null,{"$f":"I23","v":3.5},{"$f":"F46*(I20-I19)","v":73.5},553.45000000000005,{"$f":"'Feed-Summary'!H77","v":381.96875}]
[null,"* FCR = Feed Conversion Ratio (Feed:Gain)"]
[]
[]
["Labour"]
[]
["Total Hours per year",null,null,null,null,null,48," hours/week",{"$f":"G52*52","v":2496},null," hours/year"]
["Wage (includes hired manager) ",null,null,null,null,null,27," /hour (weighted) "]
[]
[null,null,null,null,"Capital Investment1"]
[]
[null,null,4040,"Pig Places"]
[]
[null,null,null,null,null,null,"/sq.ft","Total","/Pig Place",null,"Your Cost"]
["Buildings",null,null,null,null,null,null,""]
[null,"Barn ",null,null,{"$f":"C57*9.2","v":37168},"ft.2",50,{"$f":"E61*G61","v":1858400},{"$f":"H61/$C$57","v":460}]
[null,"Office & Loading",null,null,300,"ft.2",50,{"$f":"E62*G62","v":15000},{"$f":"H62/$C$57","v":3.7128712871287131}]
[null,"Standby Generator",null,null,null,null,null,24000,{"$f":"H63/$C$57","v":5.9405940594059405}]
[null,"Feed Mill (building only)",null,null,null,null,null,45000,{"$f":"H64/$C$57","v":11.138613861386139}]
[null,"Total Building Cost",null,null,null,null,null,{"$f":"SUM(H61:H64)","v":1942400},{"$f":"H65/C57","v":480.79207920792078}]
[null,null,null,null,null,null,null,""]
["Equipment",null,null,null,null,null,null,""]
[null,"Finishing Barn",null,null,null,null,null,470000,{"$f":"H68/C57","v":116.33663366336634}]
[null,"Other",null,null,null,null,null,{"$f":"+G69","v":0},{"$f":"H69/C57","v":0}]
[null,"Fire Alarm System",null,null,null,null,null,1000,{"$f":"H70/C57","v":0.24752475247524752}]
[null,"Storage Bins",null,null,null,null,null,36000,{"$f":"H71/C57","v":8.9108910891089117}]
[null,"Feed Mill (equipment only)",null,null,null,null,null,60000,{"$f":"H72/C57","v":14.851485148514852}]
[null,"Total Equipment Cost",null,null,null,null,null,{"$f":"SUM(H68:H72)","v":567000},{"$f":"H73/C57","v":140.34653465346534}]
["Total Buildings and Equipment Cost",null,null,null,null,null,null,{"$f":"H65+H73","v":2509400},{"$f":"H74/C57","v":621.13861386138615}]
[]
["Land Value"]
[" ","Land Investment",null,{"$f":"G161-G162","v":40},"acres @",null,{"$f":"G164","v":2750},{"$f":"D77*G77","v":110000},{"$f":"+H77/$C$57","v":27.227722772277229}]
[null,"Land Investment",null,{"$f":"G161-D77","v":0},"acres @",null,{"$f":"G164","v":2750},{"$f":"D78*G78","v":0},{"$f":"+H78/$C$57","v":0}]
[]
["Other Costs"]
["Site preparation",null,null,null,null,null,null,36000,{"$f":"+H81/C57","v":8.9108910891089117}]
["Manure Storage",null,null,null,null,null,null,120000,{"$f":"H82/C57","v":29.702970297029704}]
["Total Other Costs",null,null,null,null,null,null,{"$f":"SUM(H81+H82)","v":156000},{"$f":"SUM(I81+I82)","v":38.613861386138616}]
[]
["Total Capital Investment",null,null,null,null,null,null,{"$f":"H74+G77+H83+H78","v":2668150},{"$f":"H85/C57","v":660.43316831683171}]
[]
["¹ 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."]
[]
["NOTE: 1 sq.ft. = 0.0929 sq.m;  1 sq.m.= 10.764 sq.ft.;  1 ft.= 0.3048 m"]
[]
[]
["Fixed Costs"]
[]
["Depreciation (straight line):"]
[null,"Useful Life:"]
[null,null,"Buildings",null,null,null,25," years"]
[null,null,"Equipment",null,null,null,10," years"]
[null,"Salvage Value (% of original cost):"]
[null,null,"Buildings",null,null,null,10," %"]
[null,null,"Equipment",null,null,null,10," %"]
[null,null,null,null,null,null,""]
["Investment Interest Rate",null,null,null,null,null,2.75," %"]
[]
["Other Operating Costs"]
[null,"Average market price",null,null,null,null,{"$f":"F10","v":87}," /cwt",{"$f":"G105*2.2046","v":191.80020000000002},"/ckg"]
[null,"Weanling Formula",null,null,null,null,1.7]
[null,"Purchase Weight",null,null,null,null,57.3," lbs"]
[null,"Hauling in",null,null,null,null,0," /pig purchased"]
[]
[null,"Annual Veterinary Costs:"]
[null,null,"Professional Services",null,null,null,700]
[null,null,"Medication",null,null,null,16000]
[]
[null,"Maintenance & Repair",null,null,null,null,1.1000000000000001," % of total capital investment"]
[]
[null,"Hydro & Propane",null,null,null,"Hydro rate",9.3240000000000003E-2,"per kwhr"]
[null,null,null,null,null,"Hydro usage",200000,"kwhr"]
[null,null,null,null,null,"Propane rate",0.75,"per litre"]
[null,null,null,null,null,"Propane usage",30000,"litres"]
[]
[null,"Insurance"]
[null,null,"Buildings and equipment",null,null,null,0.78," /$100 Capital Invested"]
[null,null,"Feeder hogs",null,null,null,0.88," /$100 Capital Invested"]
[null,null,"Business Interruption",null,null,null,0.78," /$100 Capital Invested"]
[null,null,"Business Interruption Insured value",null,null,null,75,"per feeder"]
[null,null,"Estimated Market Value of Hogs",null,null,null,202," /hog"]
[]
[null,"Manure Costs:"]
[null,null,"Storage volume",null,null,null,7.1," litres/pig/day ³"]
[null,null,null,"Cost / litre",null,null,2.8999999999999998E-3," /litre"]
[null,null,null,"Cost / gallon",null,null,{"$f":"G130*4.56409","v":1.3235861E-2}," /gallon"]
[]
[null,null,"Odour control (barley straw)",null,null,null,0," total costs"]
[null,null,"Manure Management Fee",null,null,null,3000," total costs"]
[]
[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,3.5,0.77,60]
[null,null,"Phosphate (P2O5)",null,null,0.74,0.89,0]
[null,null,"Potassium",null,null,1.41,0.6,0]
[null,null,null,null,"* kg/1000 L x 10 = lbs/1000 imp. Gallons"]
[null,"Marketing & Transport."]
[null,null,null,null,"Trucking in",null,4,"/pig"]
[null,null,null,null,"Trucking out",null,4.5,"/pig"]
[null,null,null,null,"Council Levy",null,0.8,"/pig"]
[null,null,null,null,"Grading Charge",null,0.06,"/pig"]
[null,null,null,null,"Truck Washing",null,0,"/pig"]
[null,null,null,null,"Insurance",null,0.25,"/pig"]
[null,null,null,null,"Special Levy",null,0,"/pig"]
[]
[null,"Office Supplies",null,null,null,null,0.3," /pig place"]
[]
[null,"Operating Loan Interest %",null,null,null,null,8.5," %"]
[]
[null,"Property Tax:"]
[null,null,"Grower-Finisher Barn & Land ",null,null,null,10000," /year"]
[null,null,"Land",null,null,null,10," /acre"]
[]
[null,"Land Value for Grower-Finisher Operation:"]
[null,null,"Number of Acres",null,null,null,40,"acres"]
[null,null,"Number of Acres rented out",null,null,null,0,"acres"]
[null,null,"Rental rate (income)",null,null,null,60,"/acre"]
[null,null,"Land Value per Acre",null,null,null,2750,"/acre"]
[]
[]
["³ 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 Input","index":5,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
[]
["Feed Ingredient Costs"]
[]
[null,null,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 - 47 % ",null,null,665]
[null,"  Canola Meal - 34 % ",null,null,425]
[null,"  Peas",null,null,390]
[null,"  Grower Micro Premix",null,null,6000]
[null,"  Canola Oil ",null,null,2400]
[null,"  Whey Powder ",null,null,1364.6]
[null,"  Herring Meal",null,null,3364.4]
[null,"  Plasma",null,null,5720]
[null,"  Limestone ",null,null,203.95]
[null,"  Dical (16% Ca-21% P) ",null,null,1524.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 - Steam Rolled",null,null,375]
[null,"  Processing Costs:"]
[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,"Grower 1 ","Grower 2","Finisher"]
[null,"",null,"Ration","Ration","Ration"]
[null,null,null,"(kg)","(kg)","(kg)"]
[null,{"$f":"B5","v":"  Wheat"},null,475,200,0]
[null,"  Barley",null,215,597,834]
[null,"  Corn ",null,0,0,0]
[null,"  Soybean Meal - 47 % ",null,175,75,0]
[null,"  Canola Meal - 34 % ",null,0,100,80]
[null,"  Peas",null,100,0,70]
[null,{"$f":"B11","v":"  Grower Micro Premix"},null,3,3,3]
[null,"  Canola Oil ",null,10,8,0]
[null,"  Whey Powder ",null,0,0,0]
[null,"  Herring Meal",null,0,0,0]
[null,"  Plasma",null,0,0,0]
[null,"  Limestone ",null,12,10,8]
[null,"  Dical (16% Ca-21% P) ",null,5,2,1]
[null,"  Salt - 96% ",null,3.5,3.5,3.5]
[null,"  Phytase",null,0.5,0.5,0.5]
[null,"  L-Lysine HCL ",null,1,1,0]
[null,"  L-Threonine ",null,0,0,0]
[null,"  DL-Methionine ",null,0,0,0]
[null,"  Oats - Steam Rolled",null,0,0,0]
[null,"  Total ",null,{"$f":"SUM(D32:D50)","v":1000},{"$f":"SUM(E32:E50)","v":1000},{"$f":"SUM(F32:F50)","v":1000}]
[]
[]
[null,"Total Feed Ingredients per Feeder Pig per Year -- Grower-Finisher Barn"]
[null,null,null,{"$f":"D29","v":"Grower 1 "},{"$f":"E29","v":"Grower 2"},{"$f":"F29","v":"Finisher"}]
[null,null,null,"Ration","Ration","Ration","Total"]
[null,null,null,"(kg/year)","(kg/year)","(kg/year)","(kg/year)"]
[null,{"$f":"B5","v":"  Wheat"},null,{"$f":"('Finish-Worksheet'!$D$12*D32/1000)","v":22.23},{"$f":"('Finish-Worksheet'!$D$22*E32/1000)","v":30},{"$f":"('Finish-Worksheet'!$D$32*F32/1000)","v":0},{"$f":"SUM(D58:F58)","v":52.230000000000004}]
[null,"  Barley",null,{"$f":"('Finish-Worksheet'!$D$12*D33/1000)","v":10.061999999999999},{"$f":"('Finish-Worksheet'!$D$22*E33/1000)","v":89.55},{"$f":"('Finish-Worksheet'!$D$32*F33/1000)","v":61.298999999999999},{"$f":"SUM(D59:F59)","v":160.911}]
[null,"  Corn ",null,{"$f":"('Finish-Worksheet'!$D$12*D34/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E34/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F34/1000)","v":0},0]
[null,"  Soybean Meal - 47 % ",null,{"$f":"('Finish-Worksheet'!$D$12*D35/1000)","v":8.19},{"$f":"('Finish-Worksheet'!$D$22*E35/1000)","v":11.25},{"$f":"('Finish-Worksheet'!$D$32*F35/1000)","v":0},19.439999999999998]
[null,"  Canola Meal - 34 % ",null,{"$f":"('Finish-Worksheet'!$D$12*D36/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E36/1000)","v":15},{"$f":"('Finish-Worksheet'!$D$32*F36/1000)","v":5.88},20.88]
[null,"  Peas",null,{"$f":"('Finish-Worksheet'!$D$12*D37/1000)","v":4.68},{"$f":"('Finish-Worksheet'!$D$22*E37/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F37/1000)","v":5.1449999999999996},9.8249999999999993]
[null,{"$f":"B11","v":"  Grower Micro Premix"},null,{"$f":"('Finish-Worksheet'!$D$12*D38/1000)","v":0.14039999999999997},{"$f":"('Finish-Worksheet'!$D$22*E38/1000)","v":0.45},{"$f":"('Finish-Worksheet'!$D$32*F38/1000)","v":0.2205},0.81090000000000007]
[null,"  Canola Oil ",null,{"$f":"('Finish-Worksheet'!$D$12*D39/1000)","v":0.46800000000000003},{"$f":"('Finish-Worksheet'!$D$22*E39/1000)","v":1.2},{"$f":"('Finish-Worksheet'!$D$32*F39/1000)","v":0},1.6679999999999999]
[null,"  Whey Powder ",null,{"$f":"('Finish-Worksheet'!$D$12*D40/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E40/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F40/1000)","v":0},0]
[null,"  Herring Meal",null,{"$f":"('Finish-Worksheet'!$D$12*D41/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E41/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F41/1000)","v":0},0]
[null,"  Plasma",null,{"$f":"('Finish-Worksheet'!$D$12*D42/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E42/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F42/1000)","v":0},0]
[null,"  Limestone ",null,{"$f":"('Finish-Worksheet'!$D$12*D43/1000)","v":0.56159999999999988},{"$f":"('Finish-Worksheet'!$D$22*E43/1000)","v":1.5},{"$f":"('Finish-Worksheet'!$D$32*F43/1000)","v":0.58799999999999997},2.6496]
[null,"  Dical (16% Ca-21% P) ",null,{"$f":"('Finish-Worksheet'!$D$12*D44/1000)","v":0.23400000000000001},{"$f":"('Finish-Worksheet'!$D$22*E44/1000)","v":0.3},{"$f":"('Finish-Worksheet'!$D$32*F44/1000)","v":7.3499999999999996E-2},0.60750000000000004]
[null,"  Salt - 96% ",null,{"$f":"('Finish-Worksheet'!$D$12*D45/1000)","v":0.16379999999999997},{"$f":"('Finish-Worksheet'!$D$22*E45/1000)","v":0.52500000000000002},{"$f":"('Finish-Worksheet'!$D$32*F45/1000)","v":0.25724999999999998},0.94604999999999995]
[null,"  Phytase",null,{"$f":"('Finish-Worksheet'!$D$12*D46/1000)","v":2.3399999999999997E-2},{"$f":"('Finish-Worksheet'!$D$22*E46/1000)","v":7.4999999999999997E-2},{"$f":"('Finish-Worksheet'!$D$32*F46/1000)","v":3.6749999999999998E-2},0.13514999999999999]
[null,"  L-Lysine HCL ",null,{"$f":"('Finish-Worksheet'!$D$12*D47/1000)","v":4.6799999999999994E-2},{"$f":"('Finish-Worksheet'!$D$22*E47/1000)","v":0.15},{"$f":"('Finish-Worksheet'!$D$32*F47/1000)","v":0},0.19679999999999997]
[null,"  L-Threonine ",null,{"$f":"('Finish-Worksheet'!$D$12*D48/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E48/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F48/1000)","v":0},0]
[null,"  DL-Methionine ",null,{"$f":"('Finish-Worksheet'!$D$12*D49/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E49/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F49/1000)","v":0},0]
[null,"  Oats - Steam Rolled",null,{"$f":"('Finish-Worksheet'!$D$12*D50/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$22*E50/1000)","v":0},{"$f":"('Finish-Worksheet'!$D$32*F50/1000)","v":0},0]
[null,"  Total Ration Used (kgs)",null,{"$f":"SUM(D58:D76)","v":46.800000000000004},{"$f":"SUM(E58:E76)","v":150},{"$f":"SUM(F58:F76)","v":73.499999999999986},{"$f":"SUM(G58:G76)","v":270.30000000000007}]
[]
[null,null,null," "]

{"sheet":"Feed-Summary","index":6,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Home-Mixed Feed Requirement and Cost Summary"]
[null,null,null,null,null,"Ingredient",null,"Ration"]
[null,null,null,"Amount",null,"    Price",null,"Cost"]
["Grower 1",null,null,"       (kg)",null,"($ /tonne)",null,"($ /tonne)",null,"Your Cost"]
[{"$f":"'Feed Input'!B32","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!D32=0,\"\",'Feed Input'!D32)","v":475},null,{"$f":"IF('Feed Input'!D32=0,\" \",'Feed Input'!E5)","v":370},null,{"$f":"IF('Feed Input'!D32=0,\" \",ROUND((D5/1000)*F5,2))","v":175.75}]
[{"$f":"'Feed Input'!B33","v":"  Barley"},null,null,{"$f":"IF('Feed Input'!D33=0,\"\",'Feed Input'!D33)","v":215},null,{"$f":"IF('Feed Input'!D33=0,\" \",'Feed Input'!E6)","v":320},null,{"$f":"IF('Feed Input'!D33=0,\" \",ROUND((D6/1000)*F6,2))","v":68.8}]
[{"$f":"'Feed Input'!B34","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!D34=0,\"\",'Feed Input'!D34)","v":""},null,{"$f":"IF('Feed Input'!D34=0,\" \",'Feed Input'!E7)","v":" "},null,{"$f":"IF('Feed Input'!D34=0,\" \",ROUND((D7/1000)*F7,2))","v":" "}]
[{"$f":"'Feed Input'!B35","v":"  Soybean Meal - 47 % "},null,null,{"$f":"IF('Feed Input'!D35=0,\"\",'Feed Input'!D35)","v":175},null,{"$f":"IF('Feed Input'!D35=0,\" \",'Feed Input'!E8)","v":665},null,{"$f":"IF('Feed Input'!D35=0,\" \",ROUND((D8/1000)*F8,2))","v":116.38}]
[{"$f":"'Feed Input'!B36","v":"  Canola Meal - 34 % "},null,null,{"$f":"IF('Feed Input'!D36=0,\"\",'Feed Input'!D36)","v":""},null,{"$f":"IF('Feed Input'!D36=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!D36=0,\" \",ROUND((D9/1000)*F9,2))","v":" "}]
[{"$f":"'Feed Input'!B37","v":"  Peas"},null,null,{"$f":"IF('Feed Input'!D37=0,\"\",'Feed Input'!D37)","v":100},null,{"$f":"IF('Feed Input'!D37=0,\" \",'Feed Input'!E10)","v":390},null,{"$f":"IF('Feed Input'!D37=0,\" \",ROUND((D10/1000)*F10,2))","v":39}]
[{"$f":"'Feed Input'!B38","v":"  Grower Micro Premix"},null,null,{"$f":"IF('Feed Input'!D38=0,\"\",'Feed Input'!D38)","v":3},null,{"$f":"IF('Feed Input'!D38=0,\" \",'Feed Input'!E11)","v":6000},null,{"$f":"IF('Feed Input'!D38=0,\" \",ROUND((D11/1000)*F11,2))","v":18}]
[{"$f":"'Feed Input'!B39","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!D39=0,\"\",'Feed Input'!D39)","v":10},null,{"$f":"IF('Feed Input'!D39=0,\" \",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!D39=0,\" \",ROUND((D12/1000)*F12,2))","v":24}]
[{"$f":"'Feed Input'!B40","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!D40=0,\"\",'Feed Input'!D40)","v":""},null,{"$f":"IF('Feed Input'!D40=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!D40=0,\" \",ROUND((D13/1000)*F13,2))","v":" "}]
[{"$f":"'Feed Input'!B41","v":"  Herring Meal"},null,null,{"$f":"IF('Feed Input'!D41=0,\"\",'Feed Input'!D41)","v":""},null,{"$f":"IF('Feed Input'!D41=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!D41=0,\" \",ROUND((D14/1000)*F14,2))","v":" "}]
[{"$f":"'Feed Input'!B42","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!D42=0,\"\",'Feed Input'!D42)","v":""},null,{"$f":"IF('Feed Input'!D42=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!D42=0,\" \",ROUND((D15/1000)*F15,2))","v":" "}]
[{"$f":"'Feed Input'!B43","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!D43=0,\"\",'Feed Input'!D43)","v":12},null,{"$f":"IF('Feed Input'!D43=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!D43=0,\" \",ROUND((D16/1000)*F16,2))","v":2.4500000000000002}]
[{"$f":"'Feed Input'!B44","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!D44=0,\"\",'Feed Input'!D44)","v":5},null,{"$f":"IF('Feed Input'!D44=0,\" \",'Feed Input'!E17)","v":1524.23},null,{"$f":"IF('Feed Input'!D44=0,\" \",ROUND((D17/1000)*F17,2))","v":7.62}]
[{"$f":"'Feed Input'!B45","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!D45=0,\"\",'Feed Input'!D45)","v":3.5},null,{"$f":"IF('Feed Input'!D45=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!D45=0,\" \",ROUND((D18/1000)*F18,2))","v":0.92}]
[{"$f":"'Feed Input'!B46","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!D46=0,\"\",'Feed Input'!D46)","v":0.5},null,{"$f":"IF('Feed Input'!D46=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!D46=0,\" \",ROUND((D19/1000)*F19,2))","v":7.25}]
[{"$f":"'Feed Input'!B47","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!D47=0,\"\",'Feed Input'!D47)","v":1},null,{"$f":"IF('Feed Input'!D47=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!D47=0,\" \",ROUND((D20/1000)*F20,2))","v":2.25}]
[{"$f":"'Feed Input'!B48","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!D48=0,\"\",'Feed Input'!D48)","v":""},null,{"$f":"IF('Feed Input'!D48=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!D48=0,\" \",ROUND((D21/1000)*F21,2))","v":" "}]
[{"$f":"'Feed Input'!B49","v":"  DL-Methionine "},null,null,{"$f":"IF('Feed Input'!D49=0,\"\",'Feed Input'!D49)","v":""},null,{"$f":"IF('Feed Input'!D49=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!D49=0,\" \",ROUND((D22/1000)*F22,2))","v":" "}]
[{"$f":"'Feed Input'!B50","v":"  Oats - Steam Rolled"},null,null,{"$f":"IF('Feed Input'!D50=0,\"\",'Feed Input'!D50)","v":""},null,{"$f":"IF('Feed Input'!D50=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!D50=0,\" \",ROUND((D23/1000)*F23,2))","v":" "}]
["Total ",null,null,{"$f":"SUM(D5:D23)","v":1000},"kg",null,null,{"$f":"SUM(H5:H23)","v":462.42}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H24+(F25*H24/100)","v":468.20025000000004}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H25=0,0,H25+F26)","v":478.20025000000004}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H26+F27","v":488.20025000000004}]
[]
["Grower 2"]
[{"$f":"'Feed Input'!B5","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!E32=0,\"\",'Feed Input'!E32)","v":200},null,{"$f":"IF('Feed Input'!E32=0,\"\",'Feed Input'!E5)","v":370},null,{"$f":"IF('Feed Input'!E32=0,\"\",ROUND((D30/1000)*F30,2))","v":74}]
[{"$f":"'Feed Input'!B6","v":"  Barley"},null,null,{"$f":"IF('Feed Input'!E33=0,\"\",'Feed Input'!E33)","v":597},null,{"$f":"IF('Feed Input'!E33=0,\"\",'Feed Input'!E6)","v":320},null,{"$f":"IF('Feed Input'!E33=0,\"\",ROUND((D31/1000)*F31,2))","v":191.04}]
[{"$f":"'Feed Input'!B7","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!E34=0,\"\",'Feed Input'!E34)","v":""},null,{"$f":"IF('Feed Input'!E34=0,\"\",'Feed Input'!E7)","v":""},null,{"$f":"IF('Feed Input'!E34=0,\"\",ROUND((D32/1000)*F32,2))","v":""}]
[{"$f":"'Feed Input'!B8","v":"  Soybean Meal - 47 % "},null,null,{"$f":"IF('Feed Input'!E35=0,\"\",'Feed Input'!E35)","v":75},null,{"$f":"IF('Feed Input'!E35=0,\"\",'Feed Input'!E8)","v":665},null,{"$f":"IF('Feed Input'!E35=0,\"\",ROUND((D33/1000)*F33,2))","v":49.88}]
[{"$f":"'Feed Input'!B9","v":"  Canola Meal - 34 % "},null,null,{"$f":"IF('Feed Input'!E36=0,\"\",'Feed Input'!E36)","v":100},null,{"$f":"IF('Feed Input'!E36=0,\"\",'Feed Input'!E9)","v":425},null,{"$f":"IF('Feed Input'!E36=0,\"\",ROUND((D34/1000)*F34,2))","v":42.5}]
[{"$f":"'Feed Input'!B10","v":"  Peas"},null,null,{"$f":"IF('Feed Input'!E37=0,\"\",'Feed Input'!E37)","v":""},null,{"$f":"IF('Feed Input'!E37=0,\"\",'Feed Input'!E10)","v":""},null,{"$f":"IF('Feed Input'!E37=0,\"\",ROUND((D35/1000)*F35,2))","v":""}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix"},null,null,{"$f":"IF('Feed Input'!E38=0,\"\",'Feed Input'!E38)","v":3},null,{"$f":"IF('Feed Input'!E38=0,\"\",'Feed Input'!E11)","v":6000},null,{"$f":"IF('Feed Input'!E38=0,\"\",ROUND((D36/1000)*F36,2))","v":18}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!E39=0,\"\",'Feed Input'!E39)","v":8},null,{"$f":"IF('Feed Input'!E39=0,\"\",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!E39=0,\"\",ROUND((D37/1000)*F37,2))","v":19.2}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!E40=0,\"\",'Feed Input'!E40)","v":""},null,{"$f":"IF('Feed Input'!E40=0,\"\",'Feed Input'!E13)","v":""},null,{"$f":"IF('Feed Input'!E40=0,\"\",ROUND((D38/1000)*F38,2))","v":""}]
[{"$f":"'Feed Input'!B14","v":"  Herring Meal"},null,null,{"$f":"IF('Feed Input'!E41=0,\"\",'Feed Input'!E41)","v":""},null,{"$f":"IF('Feed Input'!E41=0,\"\",'Feed Input'!E14)","v":""},null,{"$f":"IF('Feed Input'!E41=0,\"\",ROUND((D39/1000)*F39,2))","v":""}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!E42=0,\"\",'Feed Input'!E42)","v":""},null,{"$f":"IF('Feed Input'!E42=0,\"\",'Feed Input'!E15)","v":""},null,{"$f":"IF('Feed Input'!E42=0,\"\",ROUND((D40/1000)*F40,2))","v":""}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!E43=0,\"\",'Feed Input'!E43)","v":10},null,{"$f":"IF('Feed Input'!E43=0,\"\",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!E43=0,\"\",ROUND((D41/1000)*F41,2))","v":2.04}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!E44=0,\"\",'Feed Input'!E44)","v":2},null,{"$f":"IF('Feed Input'!E44=0,\"\",'Feed Input'!E17)","v":1524.23},null,{"$f":"IF('Feed Input'!E44=0,\"\",ROUND((D42/1000)*F42,2))","v":3.05}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!E45=0,\"\",'Feed Input'!E45)","v":3.5},null,{"$f":"IF('Feed Input'!E45=0,\"\",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!E45=0,\"\",ROUND((D43/1000)*F43,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!E46=0,\"\",'Feed Input'!E46)","v":0.5},null,{"$f":"IF('Feed Input'!E46=0,\"\",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!E46=0,\"\",ROUND((D44/1000)*F44,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!E47=0,\"\",'Feed Input'!E47)","v":1},null,{"$f":"IF('Feed Input'!E47=0,\"\",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!E47=0,\"\",ROUND((D45/1000)*F45,2))","v":2.25}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!E48=0,\"\",'Feed Input'!E48)","v":""},null,{"$f":"IF('Feed Input'!E48=0,\"\",'Feed Input'!E21)","v":""},null,{"$f":"IF('Feed Input'!E48=0,\"\",ROUND((D46/1000)*F46,2))","v":""}]
[{"$f":"'Feed Input'!B22","v":"  DL-Methionine "},null,null,{"$f":"IF('Feed Input'!E49=0,\"\",'Feed Input'!E49)","v":""},null,{"$f":"IF('Feed Input'!E49=0,\"\",'Feed Input'!E22)","v":""},null,{"$f":"IF('Feed Input'!E49=0,\"\",ROUND((D47/1000)*F47,2))","v":""}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Steam Rolled"},null,null,{"$f":"IF('Feed Input'!E50=0,\"\",'Feed Input'!E50)","v":""},null,{"$f":"IF('Feed Input'!E50=0,\"\",'Feed Input'!E23)","v":""},null,{"$f":"IF('Feed Input'!E50=0,\"\",ROUND((D48/1000)*F48,2))","v":""}]
["Total ",null,null,{"$f":"SUM(D30:D48)","v":1000},"kg",null,null,{"$f":"SUM(H30:H48)","v":410.13}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H49+(F50*H49/100)","v":415.25662499999999}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H50=0,0,H50+F51)","v":425.25662499999999}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H51+F52","v":435.25662499999999}]
[]
["Finisher Ration:"]
[{"$f":"'Feed Input'!B32","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!F32=0,\"\",'Feed Input'!F32)","v":""},null,{"$f":"IF('Feed Input'!F32=0,\"\",'Feed Input'!E5)","v":""},null,{"$f":"IF('Feed Input'!F32=0,\"\",ROUND((D55/1000)*F55,2))","v":""}]
[{"$f":"'Feed Input'!B33","v":"  Barley"},null,null,{"$f":"IF('Feed Input'!F33=0,\"\",'Feed Input'!F33)","v":834},null,{"$f":"IF('Feed Input'!F33=0,\"\",'Feed Input'!E6)","v":320},null,{"$f":"IF('Feed Input'!F33=0,\"\",ROUND((D56/1000)*F56,2))","v":266.88}]
[{"$f":"'Feed Input'!B34","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!F34=0,\"\",'Feed Input'!F34)","v":""},null,{"$f":"IF('Feed Input'!F34=0,\"\",'Feed Input'!E7)","v":""},null,{"$f":"IF('Feed Input'!F34=0,\"\",ROUND((D57/1000)*F57,2))","v":""}]
[{"$f":"'Feed Input'!B35","v":"  Soybean Meal - 47 % "},null,null,{"$f":"IF('Feed Input'!F35=0,\"\",'Feed Input'!F35)","v":""},null,{"$f":"IF('Feed Input'!F35=0,\"\",'Feed Input'!E8)","v":""},null,{"$f":"IF('Feed Input'!F35=0,\"\",ROUND((D58/1000)*F58,2))","v":""}]
[{"$f":"'Feed Input'!B36","v":"  Canola Meal - 34 % "},null,null,{"$f":"IF('Feed Input'!F36=0,\"\",'Feed Input'!F36)","v":80},null,{"$f":"IF('Feed Input'!F36=0,\"\",'Feed Input'!E9)","v":425},null,{"$f":"IF('Feed Input'!F36=0,\"\",ROUND((D59/1000)*F59,2))","v":34}]
[{"$f":"'Feed Input'!B37","v":"  Peas"},null,null,{"$f":"IF('Feed Input'!F37=0,\"\",'Feed Input'!F37)","v":70},null,{"$f":"IF('Feed Input'!F37=0,\"\",'Feed Input'!E10)","v":390},null,{"$f":"IF('Feed Input'!F37=0,\"\",ROUND((D60/1000)*F60,2))","v":27.3}]
[{"$f":"'Feed Input'!B38","v":"  Grower Micro Premix"},null,null,{"$f":"IF('Feed Input'!F38=0,\"\",'Feed Input'!F38)","v":3},null,{"$f":"IF('Feed Input'!F38=0,\"\",'Feed Input'!E11)","v":6000},null,{"$f":"IF('Feed Input'!F38=0,\"\",ROUND((D61/1000)*F61,2))","v":18}]
[{"$f":"'Feed Input'!B39","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!F39=0,\"\",'Feed Input'!F39)","v":""},null,{"$f":"IF('Feed Input'!F39=0,\"\",'Feed Input'!E12)","v":""},null,{"$f":"IF('Feed Input'!F39=0,\"\",ROUND((D62/1000)*F62,2))","v":""}]
[{"$f":"'Feed Input'!B40","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!F40=0,\"\",'Feed Input'!F40)","v":""},null,{"$f":"IF('Feed Input'!F40=0,\"\",'Feed Input'!E13)","v":""},null,{"$f":"IF('Feed Input'!F40=0,\"\",ROUND((D63/1000)*F63,2))","v":""}]
[{"$f":"'Feed Input'!B41","v":"  Herring Meal"},null,null,{"$f":"IF('Feed Input'!F41=0,\"\",'Feed Input'!F41)","v":""},null,{"$f":"IF('Feed Input'!F41=0,\"\",'Feed Input'!E14)","v":""},null,{"$f":"IF('Feed Input'!F41=0,\"\",ROUND((D64/1000)*F64,2))","v":""}]
[{"$f":"'Feed Input'!B42","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!F42=0,\"\",'Feed Input'!F42)","v":""},null,{"$f":"IF('Feed Input'!F42=0,\"\",'Feed Input'!E15)","v":""},null,{"$f":"IF('Feed Input'!F42=0,\"\",ROUND((D65/1000)*F65,2))","v":""}]
[{"$f":"'Feed Input'!B43","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!F43=0,\"\",'Feed Input'!F43)","v":8},null,{"$f":"IF('Feed Input'!F43=0,\"\",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!F43=0,\"\",ROUND((D66/1000)*F66,2))","v":1.63}]
[{"$f":"'Feed Input'!B44","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!F44=0,\"\",'Feed Input'!F44)","v":1},null,{"$f":"IF('Feed Input'!F44=0,\"\",'Feed Input'!E17)","v":1524.23},null,{"$f":"IF('Feed Input'!F44=0,\"\",ROUND((D67/1000)*F67,2))","v":1.52}]
[{"$f":"'Feed Input'!B45","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!F45=0,\"\",'Feed Input'!F45)","v":3.5},null,{"$f":"IF('Feed Input'!F45=0,\"\",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!F45=0,\"\",ROUND((D68/1000)*F68,2))","v":0.92}]
[{"$f":"'Feed Input'!B46","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!F46=0,\"\",'Feed Input'!F46)","v":0.5},null,{"$f":"IF('Feed Input'!F46=0,\"\",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!F46=0,\"\",ROUND((D69/1000)*F69,2))","v":7.25}]
[{"$f":"'Feed Input'!B47","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!F47=0,\"\",'Feed Input'!F47)","v":""},null,{"$f":"IF('Feed Input'!F47=0,\"\",'Feed Input'!E20)","v":""},null,{"$f":"IF('Feed Input'!F47=0,\"\",ROUND((D70/1000)*F70,2))","v":""}]
[{"$f":"'Feed Input'!B48","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!F48=0,\"\",'Feed Input'!F48)","v":""},null,{"$f":"IF('Feed Input'!F48=0,\"\",'Feed Input'!E21)","v":""},null,{"$f":"IF('Feed Input'!F48=0,\"\",ROUND((D71/1000)*F71,2))","v":""}]
[{"$f":"'Feed Input'!B49","v":"  DL-Methionine "},null,null,{"$f":"IF('Feed Input'!F49=0,\"\",'Feed Input'!F49)","v":""},null,{"$f":"IF('Feed Input'!F49=0,\"\",'Feed Input'!E22)","v":""},null,{"$f":"IF('Feed Input'!F49=0,\"\",ROUND((D72/1000)*F72,2))","v":""}]
[{"$f":"'Feed Input'!B50","v":"  Oats - Steam Rolled"},null,null,{"$f":"IF('Feed Input'!F50=0,\"\",'Feed Input'!F50)","v":""},null,{"$f":"IF('Feed Input'!F50=0,\"\",'Feed Input'!E23)","v":""},null,{"$f":"IF('Feed Input'!F50=0,\"\",ROUND((D73/1000)*F73,2))","v":""}]
["Total ",null,null,{"$f":"SUM(D55:D73)","v":1000},"kg",null,null,{"$f":"SUM(H55:H73)","v":357.5}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H74+(F75*H74/100)","v":361.96875}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H75=0,0,H75+F76)","v":371.96875}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H76+F77","v":381.96875}]

{"sheet":"Finish-Worksheet","index":7,"n_rows":328,"n_cols":9,"rows_kept":328,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
[null,null,null,null,""]
["Swine Finishing Production Cost Worksheet"]
[]
[]
["A.  Operating Costs",null,null,null,null,null,null,null,"Your Cost"]
[]
["1. Feed Requirements and Costs"]
[]
[null,1.01,"  Grower 1 - Purchased Feed"]
[null,null,null,{"$f":"'Finish Input'!G25","v":24},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Finish Input'!G23","v":1.95},null," feed conversion ratio"]
[null,null,"=",{"$f":"D10*D11","v":46.8},null," kg ration/pig"]
[null,null,"x",{"$f":"'Finish Input'!H44","v":679.58},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"x",{"$f":"'Finish Input'!$G$18","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D12*D13/1000)*D15)/D16,2)","v":33.549999999999997},null," /pig sold"]
[null,null,""]
[null,1.02,"  Grower 2 - Purchased Feed"]
[null,null,null,{"$f":"'Finish Input'!H25","v":50},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Finish Input'!H23","v":3},null," feed conversion ratio"]
[null,null,"=",{"$f":"D20*D21","v":150},null," kg ration/pig"]
[null,null,"x",{"$f":"'Finish Input'!H45","v":550.5},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"x",{"$f":"'Finish Input'!$G$18","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D22*D23/1000)*D25)/D26,2)","v":87.1},null," /pig sold"]
[null,null,""]
[null,1.03,"  Finisher Ration - Purchased Feed"]
[null,null,null,{"$f":"'Finish Input'!I25","v":21},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Finish Input'!I23","v":3.5},null," feed conversion ratio"]
[null,null,"=",{"$f":"D30*D31","v":73.5},null," kg ration/pig"]
[null,null,"x",{"$f":"'Finish Input'!H46","v":553.45000000000005},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"x",{"$f":"'Finish Input'!$G$18","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D32*D33/1000)*D35)/D36,2)","v":42.91},null," /pig sold"]
[]
[null,1.04,"  Grower 1 - Home Mixed Feed"]
[null,null,null,{"$f":"'Finish Input'!G25","v":24},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Finish Input'!G23","v":1.95},null," feed conversion ratio"]
[null,null,"=",{"$f":"D40*D41","v":46.8},null," kg ration/pig"]
[null,null,"x",{"$f":"'Finish Input'!I44","v":488.20025000000004},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"x",{"$f":"'Finish Input'!$G$18","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D42*D43/1000)*D45)/D46,2)","v":24.1},null," /pig sold"]
[null,null,""]
[null,1.05,"  Grower 2 - Home Mixed Feed"]
[null,null,null,{"$f":"'Finish Input'!H25","v":50},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Finish Input'!H23","v":3},null," feed conversion ratio"]
[null,null,"=",{"$f":"D50*D51","v":150},null," kg ration/pig"]
[null,null,"x",{"$f":"'Finish Input'!I45","v":435.25662499999999},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"x",{"$f":"'Finish Input'!$G$18","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D52*D53/1000)*D55)/D56,2)","v":68.87},null," /pig sold"]
[null,null,""]
[null,1.06,"  Finisher Ration - Home Mixed Feed"]
[null,null,null,{"$f":"'Finish Input'!I25","v":21},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Finish Input'!I23","v":3.5},null," feed conversion ratio"]
[null,null,"=",{"$f":"D60*D61","v":73.5},null," kg ration/pig"]
[null,null,"x",{"$f":"'Finish Input'!I46","v":381.96875},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"x",{"$f":"'Finish Input'!$G$18","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D62*D63/1000)*D65)/D66,2)","v":29.61},null," /pig sold"]
[]
["2. Other Operating Costs"]
[]
[null,2.0099999999999998,"  Weanling Cost"]
[null,null,null,{"$f":"'Finish Input'!G105","v":87},null," market price"]
[null,null,"÷",100,null,"lbs/cwt"]
[null,null,"x",{"$f":"'Finish Input'!G107","v":57.3},null," lbs"]
[null,null,"x",{"$f":"'Finish Input'!G106","v":1.7},null," formula factor"]
[null,null,"x",{"$f":"'Finish Input'!G32","v":12000},null," weanlings purchased"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"ROUND(((D72/D73*D75*D74))*D76/D77,2)","v":89.39},null," /pig sold"]
[]
[null,2.02,"  Veterinary Cost"]
[null,null,null,{"$f":"'Finish Input'!G111","v":700},null,"professional services"]
[null,null,"+",{"$f":"'Finish Input'!G112","v":16000},null,"medication"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(D81+D82)/D83","v":1.4679419583836519},null," /pig sold"]
[]
[null,2.0299999999999998,"  Maintenance & Repairs"]
[null,null,"",{"$f":"'Finish Input'!G114","v":1.1000000000000001},null," % of total capital investment"]
[null,null,"x",{"$f":"'Finish Input'!H74","v":2509400},null," total buildings and equipment cost"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"D87/100*D88/D89","v":2.4263586259908565},null," /pig sold"]
[]
[null,2.04,"Utilities"]
[null,null,null,{"$f":"'Finish Input'!G116*'Finish Input'!G117","v":18648},null," hydro"]
[null,null,"+",{"$f":"'Finish Input'!G118*'Finish Input'!G119","v":22500},null," propane"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(D93+D94)/D95","v":3.6169386648844619},null," /pig sold"]
[]
[null,2.0499999999999998,"  Insurance"]
[null,null,null,{"$f":"'Finish Input'!H74","v":2509400},null," buildings & equipment "]
[null,null,"x",{"$f":"'Finish Input'!G122","v":0.78},null," /$100 "]
[null,null,"÷",100,null," /$100 capital "]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"D100*D99/D101/D102","v":1.7205088438844254},null," /pig sold"]
[]
[null,null,null,{"$f":"'Finish Input'!K28","v":3986.4917808219179},null,"average number pigs in barn"]
[null,null,"x",{"$f":"'Finish Input'!G126","v":202},null,"average value"]
[null,null,"x",{"$f":"'Finish Input'!G123","v":0.88},null," /$100 "]
[null,null,"÷",100,null," /$100 capital "]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(((D105*D106)*D107)/D108)/D109","v":0.62289856106079866},null," /pig sold"]
[]
[null,null,null,{"$f":"'Finish Input'!G125","v":75},null,"insured value"]
[null,null,"x",{"$f":"'Finish Input'!K28","v":3986.4917808219179},null,"average number in barn"]
[null,null,"x",{"$f":"'Finish Input'!G124","v":0.78},null,"rate /$100"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"((D112*D113)*D114/100)/D115","v":0.20499305705477452},null," /pig sold"]
[]
[null,null,"=",{"$f":"D103+D110+D116","v":2.5484004619999987},null," /pig sold"]
[]
[null,2.06,"  Manure Costs "]
[null,"  Haulage",null,{"$f":"'Finish Input'!G129","v":7.1},null," litres/pig/day"]
[null,null,"x",365,null," days/year"]
[null,null,"x",{"$f":"'Finish Input'!K28","v":3986.4917808219179},null," average inventory of pigs"]
[null,null,"x",{"$f":"'Finish Input'!G130","v":2.8999999999999998E-3},null," /litre"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(D121*D122*D123*D124)/D125","v":2.6334949937377772},null," /pig sold"]
[]
[null,"  Estimated Nutrient Value"]
[null,null,null,{"$f":"'Finish Input'!G129","v":7.1},null," litres/pig/day"]
[null,null,"x",365,null," days/year"]
[null,null,"x",{"$f":"'Finish Input'!K28","v":3986.4917808219179},null," average inventory of pigs"]
[null,null,"÷",1000]
[null,null,"=",{"$f":"SUM((D129*D130*D131)/1000)","v":10330.993450000002},null,"# of 1000 litres of manure"]
[null,null,"Nitrogen"]
[null,null,null,{"$f":"'Finish Input'!F139","v":3.5},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D133","v":10330.993450000002},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Finish Input'!H139","v":60},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Finish Input'!G139","v":0.77},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D135*D136*(D137/100)/D138)*D139)/D140","v":0.66606647119801232},null,"estimated nutrient value / pig sold"]
[null,null,"Phosphate"]
[null,null,null,{"$f":"'Finish Input'!F140","v":0.74},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D133","v":10330.993450000002},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Finish Input'!H140","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Finish Input'!G140","v":0.89},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D143*D144*(D145/100)/D146)*D147)/D148","v":0},null,"estimated nutrient value / pig sold"]
[null,null,"Potassium"]
[null,null,null,{"$f":"'Finish Input'!F141","v":1.41},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D133","v":10330.993450000002},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Finish Input'!H141","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Finish Input'!G141","v":0.6},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D151*D152*(D153/100)/D154)*D155)/D156","v":0},null,"estimated nutrient value / pig sold"]
[]
[null,"  Odour control & Mgmt Fees"]
[null,null,null,{"$f":"'Finish Input'!G133+'Finish Input'!G134","v":3000},null,"total cost"]
[null,null,null,{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,null,{"$f":"D160/D161","v":0.2637021482126321},null," /pig sold"]
[]
[null,"Total",null,{"$f":"D126+D162-(D141+D149+D157)","v":2.231130670752397},null," /pig sold"]
[]
[null,2.0699999999999998,"  Office Supplies"]
[null,null,"",{"$f":"'Finish Input'!G152","v":0.3},null," /pig place"]
[null,null,"x",{"$f":"'Finish Input'!K28","v":3986.4917808219179},null," pig places"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"D167*D168/D169","v":0.1051246446434741},null," /pig sold"]
[]
[null,2.08,"  Marketing & Transportation"]
[null,null,null,{"$f":"'Finish Input'!G144","v":4},null," trucking in"]
[null,null,"+",{"$f":"'Finish Input'!G145","v":4.5},null," trucking out"]
[null,null,"+",{"$f":"'Finish Input'!G146","v":0.8},null," council levy"]
[null,null,"+",{"$f":"'Finish Input'!G147","v":0.06},null," grading charge"]
[null,null,"+",{"$f":"'Finish Input'!G149","v":0.25},null," insurance"]
[null,null,"+",{"$f":"'Finish Input'!G150","v":0},null," Special levy"]
[null,null,"=",{"$f":"SUM(D173:D178)","v":9.6100000000000012},null," /pig sold"]
[]
[null,2.09,"  Property Taxes"]
[null,null,null,{"$f":"'Finish Input'!G157","v":10000},null," taxes on barn and land"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"D182/D183","v":0.8790071607087736},null," /pig sold"]
[]
[null,null,null,{"$f":"'Finish Input'!G158","v":10},null," taxes on  land"]
[null,null,"x",{"$f":"'Finish Input'!G162","v":0},null,"acres"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(D186*D187)/D188","v":0},null," /pig sold"]
[]
[null,"Total",null,{"$f":"D184+D189","v":0.8790071607087736},null," /pig sold"]
[]
[null,"2.10","  Interest on Operating Cost - Purchased Feed"]
[null,null,null,{"$f":"'Finish Summary'!E13","v":89.39},null," weaner cost"]
[null,null,"x",{"$f":"'Finish Input'!G38","v":123},null," total days to market"]
[null,null,"x",{"$f":"'Finish Input'!$G$154","v":8.5},null," % operating rate"]
[null,null,"÷",365,null," days/year"]
[null,null,"=",{"$f":"D194*D195*D196/100/D197","v":2.5604724657534246},null," /pig sold"]
[]
[null,null,null,{"$f":"'Finish Summary'!E22","v":275.83490218736358},null," subtotal operating cost"]
[null,null,"-",{"$f":"D194","v":89.39},null," weaner cost"]
[null,null,"÷",2,null," average"]
[null,null,"x",{"$f":"D195","v":123},null," total days to market"]
[null,null,"÷",365,null," days/year"]
[null,null,"x",{"$f":"D196","v":8.5},null," % operating rate"]
[null,null,"=",{"$f":"((((D200-D201)/D202)*D203)*D205/100)/D204","v":2.6702485648888854},null," /pig sold"]
[]
[null,null,"=",{"$f":"D198+D206","v":5.23072103064231},null," /pig sold"]
[]
[null,null,"  Interest on Operating Cost - Home Mixed Feed"]
[null,null,null,{"$f":"'Finish Summary'!E13","v":89.39},null," weaner cost"]
[null,null,"x",{"$f":"'Finish Input'!G38","v":123},null," total days to market"]
[null,null,"x",{"$f":"'Finish Input'!$G$154","v":8.5},null," % operating rate"]
[null,null,"÷",365,null," days/year"]
[null,null,"=",{"$f":"D211*D212*D213/100/D214","v":2.5604724657534246},null," /pig sold"]
[]
[null,null,null,{"$f":"'Finish Summary'!H22","v":234.85490218736359},null," subtotal operating cost"]
[null,null,"-",{"$f":"D211","v":89.39},null," weaner cost"]
[null,null,"÷",2,null," average"]
[null,null,"x",{"$f":"D212","v":123},null," total days to market"]
[null,null,"÷",365,null," days/year"]
[null,null,"x",{"$f":"D213","v":8.5},null," % operating rate"]
[null,null,"=",{"$f":"((((D217-D218)/D219)*D220)*D222/100)/D221","v":2.0833363731080632},null," /pig sold"]
[]
[null,null,"=",{"$f":"D215+D223","v":4.6438088388614878},null," /pig sold"]
[]
["B.  Fixed Costs"]
["3. Depreciation"]
[null,null,null,"Original cost - Salvage Value"]
[null,null,null,"                    Useful Life"]
[null,null,null,null,null,null,""]
[null,3.01,"  Buildings - not including feedmill"]
[null,null,"",{"$f":"'Finish Input'!H65+'Finish Input'!H82-'Finish Input'!H64","v":2017400},null," total building cost (including earthen"]
[null,null,null,null,null,"  manure storage)"]
[null,null,"-",{"$f":"'Finish Input'!G99/100*('Finish Input'!H65-'Finish Input'!H64)","v":189740},null," salvage value (building only)"]
[null,null,"÷",{"$f":"'Finish Input'!G96","v":25},null," years useful life"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(D233-D235)/D236/D237","v":6.4261049093639881},null," /pig sold"]
[]
[null,3.02,"  Equipment - not including feedmill"]
[null,null,null,{"$f":"'Finish Input'!H73-'Finish Input'!H72","v":507000},null," total equipment cost"]
[null,null,"-",{"$f":"'Finish Input'!G100/100*('Finish Input'!H73-'Finish Input'!H72)","v":50700},null," salvage value"]
[null,null,"÷",{"$f":"'Finish Input'!G97","v":10},null," years useful life"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(('Finish Input'!H73-'Finish Input'!H72)-D242)/'Finish Input'!G97/'Finish Input'!G34","v":3.9130434782608696},null," /pig sold"]
[]
[null,3.03,"  Buildings - including feedmill"]
[null,null,"",{"$f":"'Finish Input'!H65+'Finish Input'!H82","v":2062400},null," total building cost (including earthen"]
[null,null,null,null,null,"  manure storage)"]
[null,null,"-",{"$f":"'Finish Input'!G99/100*'Finish Input'!H65","v":194240},null," salvage value (building only)"]
[null,null,"÷",{"$f":"'Finish Input'!G96","v":25},null," years useful life"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(D248-D250)/D251/D252","v":6.5685040693988102},null," /pig sold"]
[]
[null,3.04,"  Equipment - including feedmill"]
[null,null,null,{"$f":"'Finish Input'!H73","v":567000},null," total equipment cost"]
[null,null,"-",{"$f":"'Finish Input'!G100/100*'Finish Input'!H73","v":56700},null," salvage value"]
[null,null,"÷",{"$f":"'Finish Input'!G97","v":10},null," years useful life"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"('Finish Input'!H73-D242)/'Finish Input'!G97/'Finish Input'!G34","v":4.4275791098533572},null," /pig sold"]
[]
["4.  Investment Cost "]
[]
[null,null,"(Original Cost + Salvage Value)  X  Investment Rate"]
[null,null,null,"           2"]
[null,null,""]
[null,4.01,"Land for Barn Site"]
[null,null,null,{"$f":"'Finish Input'!H77","v":110000},null," land investment"]
[null,null,"+",{"$f":"'Finish Input'!H81","v":36000},null,"site preparation"]
[null,null,"x",{"$f":"'Finish Input'!G102","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Finish Input'!G36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"((D268+D269)*D270/100)/D271","v":0.3529213750245726},null," /pig sold"]
[null,null,"Land for manure application"]
[null,null,null,{"$f":"'Finish Input'!H78","v":0},null," land investment"]
[null,null,"x",{"$f":"'Finish Input'!G102","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Finish Input'!G36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"((D274)*D275/100)/D276","v":0},null," /pig sold"]
[null,"Total",null,{"$f":"D272+D277","v":0.3529213750245726},null," /pig sold"]
[]
[null,4.0199999999999996," Buildings - not including feedmill"]
[null,null,null,{"$f":"'Finish Input'!H65+'Finish Input'!H82-'Finish Input'!H64","v":2017400},null," total building cost (including earthen"]
[null,null,null,null,null,"   manure storage)"]
[null,null,"+",{"$f":"'Finish Input'!G99/100*('Finish Input'!H65-'Finish Input'!H64)","v":189740},null," salvage value (building only)"]
[null,null,"÷",2,null," average"]
[null,null,"x",{"$f":"'Finish Input'!G102","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(((D281+D283)/D284)*D285/100)/D286","v":2.6676263139442988},null," /pig sold"]
[]
[null,4.03," Equipment - not including feedmill"]
[null,null,null,{"$f":"'Finish Input'!H73-'Finish Input'!H72","v":507000},null," total equipment cost"]
[null,null,"+",{"$f":"'Finish Input'!G100/100*('Finish Input'!H73-'Finish Input'!H72)","v":50700},null," salvage value"]
[null,null,"÷",2,null," average"]
[null,null,"x",{"$f":"D285","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(((D290+D291)/D292)*D293/100)/D294","v":0.67405565360001418},null," /pig sold"]
[]
[null,4.04," Buildings - including feedmill"]
[null,null,null,{"$f":"'Finish Input'!H65+'Finish Input'!H82","v":2062400},null," total building cost (including earthen"]
[null,null,null,null,null,"   manure storage)"]
[null,null,"+",{"$f":"'Finish Input'!G99/100*'Finish Input'!H65","v":194240},null," salvage value (building only)"]
[null,null,"÷",2,null," average"]
[null,null,"x",{"$f":"'Finish Input'!G102","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(((D298+D300)/D301)*D302/100)/D303","v":2.7274537388200395},null," /pig sold"]
[]
[null,4.05," Equipment - including feedmill"]
[null,null,null,{"$f":"'Finish Input'!H73","v":567000},null," total equipment cost"]
[null,null,"+",{"$f":"'Finish Input'!G100/100*'Finish Input'!H73","v":56700},null," salvage value"]
[null,null,"÷",2,null," average"]
[null,null,"x",{"$f":"D285","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"(((D307+D308)/D309)*D310/100)/D311","v":0.75382555343433544},null," /pig sold"]
[]
["5.  Labour Cost"]
[null,null,null,{"$f":"'Finish Input'!I52","v":2496},null," total hours/year"]
[null,null,"x",{"$f":"'Finish Input'!G53","v":27},null," /hour"]
[null,null,"÷",{"$f":"'Finish Input'!$G$36","v":11376.471600000001},null," pigs sold"]
[null,null,"=",{"$f":"D315*D316/D317","v":5.9238050574485674},null," /pig sold"]
[]
[]
["Return on Assets (ROA) ",null,null,null,"Net Income + Operating Interest + Investment Interest"]
["",null,null,null,"   - Value of Unpaid Family and Operator Labour"]
["",null,null,null,null,"Total Assets"]
[""]
["Total Assets",null,null,"Definition: Total Assets includes the buildings, "]
["",null,null,"equipment, land, manure storage and breeding stock valued at "]
["",null,null,"replacement cost, plus the value of market livestock "]
["",null,null,"on inventory.  "]

{"sheet":"Finish-O","index":8,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"============================================================================="]
[null,"","","GROWING AND FINISHING PIG PRODUCTION SUMMARY"]
[null,"","","",null,"","","","","",""]
[null,"============================================================================="]
[null,"A. OPERATING COSTS",null,null,null,null,"","","TOTAL","$/HOG SOLD","$/PLACE"]
[null,"","1.","Feed Costs:",null,null,null,"","-----------------------------------------------------------------------"]
[null,"","","1.01","Grower Ration #1",null,null,null,{"$f":"J9*'Finish Input'!G34","v":637273.65},{"$f":"ROUND('Finish Input'!G44*SUM('Finish Input'!H44:I44)/1000,2)","v":54.65},{"$f":"J9*'Finish Input'!G34/'Finish Input'!K28","v":159.85826261219825}]
[null,null,null,"1.02","Grower Ration #2",null,null,null,{"$f":"J10*'Finish Input'!G34","v":1724195.4600000002},{"$f":"ROUND('Finish Input'!G45*SUM('Finish Input'!H45:I45)/1000,2)","v":147.86000000000001},{"$f":"J10*'Finish Input'!G34/'Finish Input'!K28","v":432.50947319011226}]
[null,"","","1.02","Finisher Ration",null,null,null,{"$f":"J11*'Finish Input'!G34","v":801693.75},{"$f":"ROUND('Finish Input'!G46*SUM('Finish Input'!H46:I46)/1000,2)","v":68.75},{"$f":"J11*'Finish Input'!G34/'Finish Input'!K28","v":201.10257190464097}]
[null,"","","","",null,null,null,"=================================================="]
[null,"","","Total Feed Cost",null,null,null,null,{"$f":"SUM(I9:I12)","v":3163162.8600000003},{"$f":"SUM(J9:J12)","v":271.26},{"$f":"SUM(K9:K12)","v":793.47030770695153}]
[null,"","","","",null,null,null,"","",""]
[null,"","2.","Other Operating Costs:",null,null,null,null,"","",""]
[null,"","","2.01","Weanling Cost **",null,null,null,{"$f":"J16*'Finish Input'!G34","v":687600},{"$f":"'Finish Input'!G107*'Finish Input'!G32/'Finish Input'!G34","v":58.965783380499097},{"$f":"J16*'Finish Input'!G34/'Finish Input'!K28","v":172.48248279549534}]
[null,"","","2.02","Veterinary Cost",null,null,null,{"$f":"J17*'Finish Input'!G34","v":191999997.53999999},{"$f":"ROUND('Finish Input'!G112*'Finish Input'!G18/'Finish Input'!G34,2)","v":16465.14},{"$f":"J17*'Finish Input'!G34/'Finish Input'!K28","v":48162.647283926985}]
[null,"","","2.03","Maintenance & Repairs",null,null,null,{"$f":"J18*'Finish Input'!G34","v":27636.57},{"$f":"ROUND('Finish Input'!G114*'Finish Input'!H74/'Finish Input'!G34/100,2)","v":2.37},{"$f":"J18*'Finish Input'!G34/'Finish Input'!K28","v":6.9325541151127146}]
[null,"","","B7","Hydro (Heat)",null,null,null,{"$f":"J19*'Finish Input'!G34","v":{"$error":"#REF!"}},{"$f":"ROUND('Finish Input'!#REF!*'Finish Input'!#REF!*'Finish Input'!K28/'Finish Input'!G34,2)","v":{"$error":"#REF!"}},{"$f":"J19*'Finish Input'!G34/'Finish Input'!K28","v":{"$error":"#REF!"}}]
[null,"","","2.05","Insurance",null,null,null,{"$f":"J20*'Finish Input'!G34","v":20062.853628536286},{"$f":"'Finish-Worksheet'!D103","v":1.7205088438844254},{"$f":"J20*'Finish Input'!G34/'Finish Input'!K28","v":5.0327091416703764}]
[null,"","","2.06","Manure Haulage",null,null,null,{"$f":"J21*'Finish Input'!G34","v":30668.43},{"$f":"ROUND('Finish-Worksheet'!D126,2)","v":2.63},{"$f":"J21*'Finish Input'!G34/'Finish Input'!K28","v":7.6930874779520835}]
[null,"","","2.07","Office Supplies",null,null,null,{"$f":"J22*'Finish Input'!G34","v":1166.1000000000001},{"$f":"ROUND('Finish Input'!G152*'Finish Input'!K28/'Finish Input'!G34,2)","v":0.1},{"$f":"J22*'Finish Input'!G34/'Finish Input'!K28","v":0.29251283186129601}]
[null,"","","2.08","Marketing & Transportation",null,null,null,{"$f":"J23*'Finish Input'!G34","v":52474.5},{"$f":"ROUND('Finish Input'!G145,2)","v":4.5},{"$f":"J23*'Finish Input'!G34/'Finish Input'!K28","v":13.163077433758318}]
[null,"","","2.09","Property Taxes",null,null,null,{"$f":"'Finish Input'!#REF!","v":{"$error":"#REF!"}},{"$f":"I24/'Finish Input'!G34","v":{"$error":"#REF!"}},{"$f":"J24*'Finish Input'!G34/'Finish Input'!K28","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,null,"================================================"]
[null,"","","Subtotal Operating Costs",null,null,null,null,{"$f":"J26*'Finish Input'!G34","v":{"$error":"#REF!"}},{"$f":"J13+SUM(J16:J25)","v":{"$error":"#REF!"}},{"$f":"J26*'Finish Input'!G34/'Finish Input'!K28","v":{"$error":"#REF!"}}]
[null,"","","2.10","Interest on Operating Cost",null,null,null,{"$f":"J27*'Finish Input'!G34","v":{"$error":"#REF!"}},{"$f":"ROUND((J16*'Finish Input'!G154/100*'Finish Input'!K22/365)+((J26-J16)*'Finish Input'!G154/100*'Finish Input'!K22/365),2)","v":{"$error":"#REF!"}},{"$f":"J27*'Finish Input'!G34/'Finish Input'!K28","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","================================================"]
[null,"","TOTAL OPERATING COSTS",null,null,null,null,"",{"$f":"J29*'Finish Input'!G34","v":{"$error":"#REF!"}},{"$f":"J26+J27","v":{"$error":"#REF!"}},{"$f":"J29*'Finish Input'!G34/'Finish Input'!K28","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","","",""]
[null,"B. FIXED COSTS",null,null,null,null,null,"","","",""]
[null,"","3.","Depreciation:",null,null,null,"","","",""]
[null,"","","3.01","Buildings and Manure Storage",null,null,"",{"$f":"J33*'Finish Input'!G34","v":74934.809348093462},{"$f":"'Finish-Worksheet'!D238","v":6.4261049093639881},{"$f":"J33*'Finish Input'!G34/'Finish Input'!K28","v":18.797181448758366}]
[null,"","","3.02","Equipment",null,null,"",{"$f":"J34*'Finish Input'!G34","v":51075.18},{"$f":"ROUND(('Finish Input'!H73-('Finish Input'!G100/100*'Finish Input'!H73))/'Finish Input'!G97/'Finish Input'!G34,2)","v":4.38},{"$f":"J34*'Finish Input'!G34/'Finish Input'!K28","v":12.812062035524763}]
[null,"","","","",null,null,"","============================================="]
[null,"","","Total Depreciation Cost",null,null,null,null,{"$f":"J36*'Finish Input'!G34","v":126009.98934809347},{"$f":"SUM(J32:J35)","v":10.806104909363988},{"$f":"J36*'Finish Input'!G34/'Finish Input'!K28","v":31.609243484283134}]
[null,"","","","",null,null,"","","",""]
[null,"","4.","Investment:",null,null,null,"","","",""]
[null,"","","4.01","Buildings and Manure Storage",null,null,"",{"$f":"J39*'Finish Input'!G34","v":31107.190446904468},{"$f":"'Finish-Worksheet'!D287","v":2.6676263139442988},{"$f":"J39*'Finish Input'!G34/'Finish Input'!K28","v":7.8031492743955742}]
[null,"","","4.02","Equipment",null,null,"",{"$f":"J40*'Finish Input'!G34","v":8629.14},{"$f":"ROUND(('Finish Input'!H73+('Finish Input'!G100/100*'Finish Input'!H73))/2*'Finish Input'!G102/100/'Finish Input'!G34,2)","v":0.74},{"$f":"J40*'Finish Input'!G34/'Finish Input'!K28","v":2.1645949557735902}]
[null,"","","","",null,null,"","==========================================="]
[null,"","","Total Investment Cost",null,null,null,"",{"$f":"J42*'Finish Input'!G34","v":39736.330446904467},{"$f":"SUM(J38:J41)","v":3.4076263139442986},{"$f":"J42*'Finish Input'!G34/'Finish Input'!K28","v":9.9677442301691634}]
[null,"","","","",null,null,"","============================================"]
[null,"","TOTAL FIXED COSTS",null,null,null,null,null,{"$f":"J44*'Finish Input'!G34","v":165746.31979499792},{"$f":"J36+J42","v":14.213731223308287},{"$f":"J44*'Finish Input'!G34/'Finish Input'!K28","v":41.576987714452294}]
[null,"","","","",null,null,"","","",""]
[null,"C. LABOUR",null,null,null,null,null,"","","",""]
[null,"","",{"$f":"'Finish Input'!G52","v":48},"hours/wk. @",null,{"$f":"'Finish Input'!G53","v":27}," /hour",{"$f":"J47*'Finish Input'!G34","v":67400.58},{"$f":"ROUND('Finish Input'!I52*'Finish Input'!G53/'Finish Input'!G34,2)","v":5.78},{"$f":"J47*'Finish Input'!G34/'Finish Input'!K28","v":16.907241681582907}]
[null,"","","","","","","","==============================================="]
[null,"","TOTAL COST OF PRODUCTION",null,null,null,null,null,{"$f":"J49*'Finish Input'!G34","v":{"$error":"#REF!"}},{"$f":"J29+J44+J47","v":{"$error":"#REF!"}},{"$f":"J49*'Finish Input'!G34/'Finish Input'!K28","v":{"$error":"#REF!"}}]
[null,"","",null,null,null,null,"","","",""]
[null,"","BREAK-EVEN PRICE (carcass)",null,null,null,null,"$/100 kg","$/CWT","",""]
[null,"","",null,null,null,null,"----------------------","-----------------------","",""]
[null,"","Operating Cost",null,null,null,null,{"$f":"J29/('Finish Input'!I20*'Finish Input'!I13*'Finish Input'!I12)*1000000","v":{"$error":"#REF!"}},{"$f":"H53/2.2046","v":{"$error":"#REF!"}},"",""]
[null,"","Operating & Labour Cost",null,null,null,null,{"$f":"H53+J47/('Finish Input'!I20*'Finish Input'!I13*'Finish Input'!I12)*1000000","v":{"$error":"#REF!"}},{"$f":"H54/2.2046","v":{"$error":"#REF!"}},"",""]
[null,"","Operating, Labour & Fixed Cost",null,null,null,null,{"$f":"H54+J44/('Finish Input'!I20*'Finish Input'!I13*'Finish Input'!I12)*1000000","v":{"$error":"#REF!"}},{"$f":"H55/2.2046","v":{"$error":"#REF!"}},"",""]
[null,"","",null,null,null,null,"","","",""]
[null,"","Break-even Price = Cost per Hog Sold / (Slaughter Wt. X  Dressing % X Index)"]
[]
[null,null,"** Footnote on Weanling Cost:  This is not the price paid for the weanling.  Because"]
[null,"","    this figure is expressed on a \"per hog sold\" basis, it includes death loss."]

{"sheet":"Weaner-O","index":9,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"============================================================================="]
[null,"","WEANER PIG PRODUCTION COST SUMMARY",null,null,null,null,null,"",""]
[null,"","","","","","","","",""]
[null,"============================================================================="]
[null,"A.","OPERATING COSTS",null,null,null,null,"     TOTAL","$/HOG SOLD","$/SOW/YR"]
[null,"","1.","Feed Costs:",null,"","","------------------------------------------------------------------------"]
[null,"","","A1","Sow Lactation Ration",null,null,{"$f":"ROUND(#REF!*#REF!*#REF!*#REF!/1000*#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(J9/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!*#REF!*#REF!/1000,2)","v":{"$error":"#REF!"}}]
[null,"","","1.02","Sow Gestation Ration",null,null,{"$f":"ROUND((365-#REF!*#REF!)*#REF!*#REF!/1000*#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(J10/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND((365-#REF!*#REF!)*#REF!*#REF!/1000,2)","v":{"$error":"#REF!"}}]
[null,"","","1.03","Boar Ration",null,null,{"$f":"ROUND(365*#REF!*#REF!/1000*#REF!/#REF!*#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(J11/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(365*#REF!*#REF!/1000*#REF!/#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","1.04","Creep Feed",null,null,{"$f":"ROUND(#REF!*#REF!/1000*#REF!*#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(J12/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!/1000*#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","1.05","Starter Ration #1",null,null,{"$f":"ROUND(#REF!*#REF!/1000*#REF!*#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(J13/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!/1000*#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,"1.05","Starter Ration #2",null,null,{"$f":"ROUND(#REF!*#REF!/1000*#REF!*#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(J14/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!/1000*#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","","","","","===================================="]
[null,"","","Total Feed Cost",null,null,null,{"$f":"J16*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J16/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"SUM(J8:J15)","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","",""]
[null,"","2.","Other Operating Costs:",null,null,null,"","",""]
[null,"","","A7","Vet. Medicine & Supplies:",null,null,"","",""]
[null,"","","","    Professional Services",null,null,{"$f":"J20*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J20/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","","    Medication",null,null,{"$f":"J21*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J21/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","A8","Maintenance & Repairs",null,null,{"$f":"J22*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J22/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,"","","A9","Hydro (Heat)",null,null,{"$f":"J23*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J23/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","2.04","Insurance",null,null,{"$f":"(+#REF!+#REF!)*#REF!/100","v":{"$error":"#REF!"}},{"$f":"ROUND(J24/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"H24/#REF!","v":{"$error":"#REF!"}}]
[null,"","","2.05","Manure Haulage",null,null,{"$f":"J25*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J25/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!/1000*#REF!*365,2)","v":{"$error":"#REF!"}}]
[null,"","","2.06","Office Supplies",null,null,{"$f":"J26*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J26/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND((500+(2*#REF!))/#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","2.07","Marketing & Transportation",null,null,{"$f":"J27*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J27/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","2.08","Sow Replacement",null,null,{"$f":"J28*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J28/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!/100*(#REF!-(#REF!*#REF!/100)),2)","v":{"$error":"#REF!"}}]
[null,"","","2.09","Boar Replacement",null,null,{"$f":"J29*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J29/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!/100*#REF!*(#REF!-(#REF!*#REF!/100))/#REF!,2)","v":{"$error":"#REF!"}}]
[null,null,null,"2.09","Property Taxes",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J30/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"H30/#REF!","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"===================================="]
[null,"","","","Subtotal Operating Costs",null,null,{"$f":"SUM(H15:H31)","v":{"$error":"#REF!"}},{"$f":"ROUND(J32/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"H32/#REF!","v":{"$error":"#REF!"}}]
[null,"","","2.10","Interest on Operating Cost",null,null,{"$f":"J33*#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I33*'Finish Input'!H34","v":{"$error":"#REF!"}}]
[null,"","","","","","","===================================="]
[null,"","TOTAL OPERATING COSTS",null,null,null,"",{"$f":"J35*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J35/'Finish Input'!$H$34,2)","v":{"$error":"#REF!"}},{"$f":"SUM(J32:J33)","v":{"$error":"#REF!"}}]
[null,"","",null,null,null,"","","",""]
[null,"B.","FIXED COSTS",null,null,null,"","","",""]
[null,"","3.","Depreciation:",null,null,null,"","",""]
[null,"","","3.01","Buildings and Manure Storage",null,null,{"$f":"J39*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J39/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"","","3.02","Equipment",null,null,{"$f":"J40*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J40/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!-(#REF!/100*#REF!))/#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"===================================="]
[null,"","","Total Depreciation Cost",null,null,null,{"$f":"J42*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J42/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"SUM(J38:J41)","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","",""]
[null,"","4.","Investment:",null,null,null,"","",""]
[null,"","","4.01","Buildings and Manure Storage",null,null,{"$f":"J45*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J45/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"","","4.02","Equipment",null,null,{"$f":"J46*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J46/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!+(#REF!/100*#REF!))/2*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,"","","4.03","Breeding Herd",null,null,{"$f":"J47*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J47/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"===================================="]
[null,"","","Total Investment Cost",null,null,null,{"$f":"J49*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J49/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"SUM(J44:J48)","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"===================================="]
[null,"","TOTAL FIXED COSTS",null,null,null,null,{"$f":"J51*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J51/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"J42+J49","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","",""]
[null,"C.","LABOUR",null,null,"","","","",""]
[null,"","",{"$f":"#REF!","v":{"$error":"#REF!"}},"hours/wk.",null,null,{"$f":"J54*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J54/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!*52/#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","","","","","===================================="]
[null,"","TOTAL COST OF PRODUCTION",null,null,null,"",{"$f":"J56*#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J56/#REF!,2)","v":{"$error":"#REF!"}},{"$f":"J35+J51+J54","v":{"$error":"#REF!"}}]
[]
[null,"============================================================================="]
[null,"","","","","Revenue per pig sold:",null,null,null,{"$f":"'Finish Input'!G107","v":57.3}]
[null,"","","","","",null,null,null,""]
[null,"","","","","Net of Operating Cost",null,null,null,{"$f":"IF(J59=0,0,J59-I35)","v":{"$error":"#REF!"}}]
[null,"","","","","Net of Operating & Labour Cost",null,null,null,{"$f":"IF(J59=0,0,J61-I54)","v":{"$error":"#REF!"}}]
[null,"","","","","Net of Operating, Labour & Fixed Cost",null,null,null,{"$f":"IF(J59=0,0,J62-I51)","v":{"$error":"#REF!"}}]

{"sheet":"Ingredient-Summary","index":10,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[12,1,12,7],[1,0,1,8]]}
[]
["Summary of Purchased Feeds Used"]
[null,null,{"$f":"'Finish Input'!G34","v":11661},"Pigs available for marketing (includes lightweights)"]
[]
[null,null,null,null,"Total per","Total","Total","Total per"]
[null,null,null,null,"Pig Mkt","per Year","per Month","Pig Mkt"]
[null,null,null,null,"(kgs)","(tonnes)","(tonnes)","(lbs)"]
[null,{"$f":"'Finish Input'!A44","v":"    Grower 1"},null,null,{"$f":"'Finish Input'!G44","v":46.8},{"$f":"(E8*$C$3)/1000","v":545.73479999999995},{"$f":"F8/12","v":45.477899999999998},{"$f":"E8*2.2046","v":103.17528}]
[null,{"$f":"'Finish Input'!A45","v":"    Grower 2"},null,null,{"$f":"'Finish Input'!G45","v":150},{"$f":"(E9*$C$3)/1000","v":1749.15},{"$f":"F9/12","v":145.76250000000002},{"$f":"E9*2.2046","v":330.69}]
[null,{"$f":"'Finish Input'!A46","v":"    Finisher Ration"},null,null,{"$f":"'Finish Input'!G46","v":73.5},{"$f":"(E10*$C$3)/1000","v":857.08349999999996},{"$f":"F10/12","v":71.423625000000001},{"$f":"E10*2.2046","v":162.03810000000001}]
[null,"    Total",null,null,{"$f":"SUM(E8:E10)","v":270.3},{"$f":"SUM(F8:F10)","v":3151.9682999999995},{"$f":"SUM(G8:G10)","v":262.66402500000004},{"$f":"SUM(H8:H10)","v":595.90337999999997}]
[]
[null,"  Summary of Home-Mixed Feed Ingredients Used"]
[null,null,null,null,"Total","Total","Total","Total"]
[null," ",null,null,"per Pig","per Year","per Month","per Pig"]
[null,null,null,null,"(kgs)","(tonnes)","(tonnes)","(lbs)"]
[null,{"$f":"'Feed Input'!B5","v":"  Wheat"},null,null,{"$f":"'Feed Input'!G58","v":52.230000000000004},{"$f":"(E17*$C$3)/1000","v":609.05403000000001},{"$f":"F17/12","v":50.754502500000001},{"$f":"E17*2.2046","v":115.14625800000002}]
[null,{"$f":"'Feed Input'!B6","v":"  Barley"},null,null,{"$f":"'Feed Input'!G59","v":160.911},1876.3831710000002,{"$f":"F18/12","v":156.36526425000002},{"$f":"E18*2.2046","v":354.74439060000003}]
[null,{"$f":"'Feed Input'!B7","v":"  Corn "},null,null,{"$f":"'Feed Input'!G60","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B8","v":"  Soybean Meal - 47 % "},null,null,{"$f":"'Feed Input'!G61","v":19.439999999999998},226.68983999999998,18.890819999999998,42.857423999999995]
[null,{"$f":"'Feed Input'!B9","v":"  Canola Meal - 34 % "},null,null,{"$f":"'Feed Input'!G62","v":20.88},243.48167999999998,20.290139999999997,46.032048000000003]
[null,{"$f":"'Feed Input'!B10","v":"  Peas"},null,null,{"$f":"'Feed Input'!G63","v":9.8249999999999993},114.56932499999999,9.5474437499999993,21.660194999999998]
[null,{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix"},null,null,{"$f":"'Feed Input'!G64","v":0.81090000000000007},9.4559049000000019,0.78799207500000013,1.7877101400000002]
[null,{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"'Feed Input'!G65","v":1.6679999999999999},19.450547999999998,1.6208789999999997,3.6772727999999999]
[null,{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"'Feed Input'!G66","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B14","v":"  Herring Meal"},null,null,{"$f":"'Feed Input'!G67","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"'Feed Input'!G68","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"'Feed Input'!G69","v":2.6496},30.896985600000001,2.5747488000000001,5.8413081600000005]
[null,{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"'Feed Input'!G70","v":0.60750000000000004},7.084057500000001,0.59033812500000005,1.3392945000000001]
[null,{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"'Feed Input'!G71","v":0.94604999999999995},11.03188905,0.91932408750000005,2.0856618299999998]
[null,{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"'Feed Input'!G72","v":0.13514999999999999},1.57598415,0.13133201250000001,0.29795168999999999]
[null,{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"'Feed Input'!G73","v":0.19679999999999997},2.2948847999999997,0.19124039999999998,0.43386527999999996]
[null,{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"'Feed Input'!G74","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B22","v":"  DL-Methionine "},null,null,{"$f":"'Feed Input'!G75","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B23","v":"  Oats - Steam Rolled"},null,null,{"$f":"'Feed Input'!G76","v":0},0,0,0]
[null,"  Total",null,null,{"$f":"SUM(E17:E35)","v":270.30000000000007},{"$f":"SUM(F17:F35)","v":3151.9682999999995},{"$f":"SUM(G17:G35)","v":262.66402500000009},{"$f":"SUM(H17:H35)","v":595.9033800000002}]