{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Introduction","Summary","Risk Analysis","Charts","Seed, Fertilizer & Chemical","Op. Cost Input","Fixed Cost Input","Assumptions","Chart data (HIDE)","Data (HIDE)"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":113,"comments":2,"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":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,0,5,8],[4,0,4,8],[48,1,48,8],[6,0,6,8],[16,1,22,8],[24,1,26,8],[45,1,47,8],[40,1,43,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
["Guidelines For Estimating"]
[{"$f":"\"Special Crop Production Costs - \"&I11","v":"Special Crop Production Costs - 2022"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Date:  January,",2022]
[]
[]
[]
[]
[]
[null,"The following budgets are estimates of the cost of producing selected special field crops in Manitoba.  General Manitoba Agriculture and Resource Development recommendations are assumed in using fertilizers and chemical inputs. These figures provide an economic evaluation of the crops and estimated yields 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 for various crops. On each farm, costs and yields differ due to soil type, climate and agronomic practices. "]
[]
[]
[]
[]
[null,"This tool is available as an Excel worksheet at: "]
[null,"or at your nearest"]
[null,"                                                                                          is also available to help"]
[null,"determine machinery costs."]
[]
[]
[]
[]
[]
[]
[null,"The ",null,null,null,null,"is also available for producers to"]
[null,"estimate the cash cost of producing field crops on their farm on an annual basis.  CropPlan calculates marginal returns, breakeven yields, breakeven crop prices on total production and remaining unsold inventory, land and machinery cost analysis and cash based finanical ratios.  "]
[]
[]
[]
[]
[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 your nearest ARD and MASC Service Centre."]

{"sheet":"Summary","index":1,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,69,8],[68,9,69,10],[0,0,0,8],[0,9,0,10],[32,2,32,8],[52,2,52,8]]}
[{"$f":"IF('Data (HIDE)'!B13=\"Manitoba\",\"Special Crop Production Costs \"&Introduction!I11&\" Guidelines (Dollars Per Acre)\",\"Special Crop Production Costs \"&Introduction!I11&\" Guidelines \"&'Data (HIDE)'!B13&\" (Dollars Per Acre)\")","v":"Special Crop Production Costs 2022 Guidelines (Dollars Per Acre)"}]
[null,null,{"$f":"'Data (HIDE)'!$B$16","v":"Black Bean"},{"$f":"'Data (HIDE)'!$B$17","v":"Hempseed"},{"$f":"'Data (HIDE)'!$B$18","v":"Kidney Bean"},{"$f":"'Data (HIDE)'!$B$19","v":"Fababean"},{"$f":"'Data (HIDE)'!$B$20","v":"Buckwheat"},{"$f":"'Data (HIDE)'!$B$21","v":"Canaryseed"},{"$f":"'Data (HIDE)'!$B$22","v":"Lentil"},null,"Your Farm"]
["A.  Operating Costs"]
[null,"Seed & Treatment",{"$f":"'Data (HIDE)'!$L$16","v":96.25},{"$f":"'Data (HIDE)'!$L$17","v":58.75},{"$f":"'Data (HIDE)'!$L$18","v":229.9},{"$f":"'Data (HIDE)'!$L$19","v":39.6},{"$f":"'Data (HIDE)'!$L$20","v":25},{"$f":"'Data (HIDE)'!$L$21","v":33},{"$f":"'Data (HIDE)'!$L$22","v":70}]
[null,"Fertilizer",{"$f":"'Data (HIDE)'!$M$16","v":103.13153114130613},{"$f":"'Data (HIDE)'!$M$17","v":103.13153114130613},{"$f":"'Data (HIDE)'!$M$18","v":103.13153114130613},{"$f":"'Data (HIDE)'!$M$19","v":49.815711670469909},{"$f":"'Data (HIDE)'!$M$20","v":55.553702620488359},{"$f":"'Data (HIDE)'!$M$21","v":89.243105486184035},{"$f":"'Data (HIDE)'!$M$22","v":25.62387036894884}]
[null,"Pesticide",{"$f":"'Data (HIDE)'!$N$16+'Data (HIDE)'!$O$16+'Data (HIDE)'!$P$16","v":117.52},{"$f":"'Data (HIDE)'!$N$17++'Data (HIDE)'!$O$17+'Data (HIDE)'!$P$17","v":47.54},{"$f":"'Data (HIDE)'!$N$18+'Data (HIDE)'!$O$18+'Data (HIDE)'!$P$18","v":117.52},{"$f":"'Data (HIDE)'!$N$19+'Data (HIDE)'!$O$19+'Data (HIDE)'!$P$19","v":15.5},{"$f":"'Data (HIDE)'!$N$20+'Data (HIDE)'!$O$20+'Data (HIDE)'!$P$20","v":6.13},{"$f":"'Data (HIDE)'!$N$21+'Data (HIDE)'!$O$21+'Data (HIDE)'!$P$21","v":28.17},{"$f":"'Data (HIDE)'!$N$22+'Data (HIDE)'!$O$22+'Data (HIDE)'!$P$22","v":29.380000000000003}]
[null,"if delete it will affect crop rotation and fuel calcs"]
[null,"if delete it will affect crop rotation and fuel calcs"]
[null,"Fuel",{"$f":"'Data (HIDE)'!$Q$16","v":23.880764421052632},{"$f":"'Data (HIDE)'!$Q$17","v":24.453561483253587},{"$f":"'Data (HIDE)'!$Q$18","v":23.319453052631577},{"$f":"'Data (HIDE)'!$Q$19","v":22.128387157894736},{"$f":"'Data (HIDE)'!$Q$20","v":21.003934105263156},{"$f":"'Data (HIDE)'!$Q$21","v":23.375130484210526},{"$f":"'Data (HIDE)'!$Q$22","v":19.929917631578945}]
[null,"Machinery Operating & Lease",{"$f":"'Data (HIDE)'!$R$16+'Data (HIDE)'!$S$16+'Data (HIDE)'!$T$16","v":22.88},{"$f":"'Data (HIDE)'!$R$17+'Data (HIDE)'!$S$17+'Data (HIDE)'!$T$17","v":22.88},{"$f":"'Data (HIDE)'!$R$18+'Data (HIDE)'!$S$18+'Data (HIDE)'!$T$18","v":22.88},{"$f":"'Data (HIDE)'!$R$19+'Data (HIDE)'!$S$19+'Data (HIDE)'!$T$19","v":22.88},{"$f":"'Data (HIDE)'!$R$20+'Data (HIDE)'!$S$20+'Data (HIDE)'!$T$20","v":22.88},{"$f":"'Data (HIDE)'!$R$21+'Data (HIDE)'!$S$21+'Data (HIDE)'!$T$21","v":22.88},{"$f":"'Data (HIDE)'!$R$22+'Data (HIDE)'!$S$22+'Data (HIDE)'!$T$22","v":22.88}]
[null,"if delete it will affect crop rotation and fuel calcs"]
[null,"if delete it will affect crop rotation and fuel calcs"]
[null,"Labour - Hired",{"$f":"'Data (HIDE)'!$U$16","v":5},{"$f":"'Data (HIDE)'!$U$17","v":5},{"$f":"'Data (HIDE)'!$U$18","v":5},{"$f":"'Data (HIDE)'!$U$19","v":5},{"$f":"'Data (HIDE)'!$U$20","v":5},{"$f":"'Data (HIDE)'!$U$21","v":5},{"$f":"'Data (HIDE)'!$U$22","v":5}]
[null,"Crop Insurance",{"$f":"'Data (HIDE)'!$V$16","v":33.5},{"$f":"'Data (HIDE)'!$V$17","v":36.75},{"$f":"'Data (HIDE)'!$V$18","v":48.25},{"$f":"'Data (HIDE)'!$V$19","v":36.75},{"$f":"'Data (HIDE)'!$V$20","v":19},{"$f":"'Data (HIDE)'!$V$21","v":24},{"$f":"'Data (HIDE)'!$V$22","v":17.25}]
[null,"Hail Insurance",{"$f":"'Data (HIDE)'!$W$16","v":16.537499999999998},{"$f":"'Data (HIDE)'!$W$17","v":18.899999999999999},{"$f":"'Data (HIDE)'!$W$18","v":16.537499999999998},{"$f":"'Data (HIDE)'!$W$19","v":16.537499999999998},{"$f":"'Data (HIDE)'!$W$20","v":23.625},{"$f":"'Data (HIDE)'!$W$21","v":9.4499999999999993},{"$f":"'Data (HIDE)'!$W$22","v":12.285}]
[null,"Drying & Other Costs",{"$f":"'Data (HIDE)'!$X$16+'Data (HIDE)'!$AA$16","v":17.75},{"$f":"'Data (HIDE)'!$X$17+'Data (HIDE)'!$AA$17","v":17.75},{"$f":"'Data (HIDE)'!$X$18+'Data (HIDE)'!$AA$18","v":17.75},{"$f":"'Data (HIDE)'!$X$19+'Data (HIDE)'!$AA$19","v":17.75},{"$f":"'Data (HIDE)'!$X$20+'Data (HIDE)'!$AA$20","v":17.75},{"$f":"'Data (HIDE)'!$X$21+'Data (HIDE)'!$AA$21","v":17.75},{"$f":"'Data (HIDE)'!$X$22+'Data (HIDE)'!$AA$22","v":17.75}]
[null,"Land Taxes",{"$f":"'Data (HIDE)'!$Y$16","v":17.5},{"$f":"'Data (HIDE)'!$Y$17","v":17.5},{"$f":"'Data (HIDE)'!$Y$18","v":17.5},{"$f":"'Data (HIDE)'!$Y$19","v":17.5},{"$f":"'Data (HIDE)'!$Y$20","v":17.5},{"$f":"'Data (HIDE)'!$Y$21","v":17.5},{"$f":"'Data (HIDE)'!$Y$22","v":17.5}]
[null,"if delete it will affect crop rotation and fuel calcs"]
[null,"Storage Costs",{"$f":"'Data (HIDE)'!$Z$16","v":4.6238085182474471},{"$f":"'Data (HIDE)'!$Z$17","v":2.7817029855766728},{"$f":"'Data (HIDE)'!$Z$18","v":3.8078423091449567},{"$f":"'Data (HIDE)'!$Z$19","v":6.2557409364524288},{"$f":"'Data (HIDE)'!$Z$20","v":2.4478986273074721},{"$f":"'Data (HIDE)'!$Z$21","v":5.0589904964354435},{"$f":"'Data (HIDE)'!$Z$22","v":3.0598732841343401}]
[null,"Interest on Operating",{"$f":"'Data (HIDE)'!$AB$16","v":11.46},{"$f":"'Data (HIDE)'!$AB$17","v":8.89},{"$f":"'Data (HIDE)'!$AB$18","v":15.14},{"$f":"'Data (HIDE)'!$AB$19","v":6.24},{"$f":"'Data (HIDE)'!$AB$20","v":5.4},{"$f":"'Data (HIDE)'!$AB$21","v":6.89},{"$f":"'Data (HIDE)'!$AB$22","v":6.02}]
[null,"Total Operating",{"$f":"SUM(C4:C20)","v":470.03360408060621},364.32679561013634,620.73632650308264,255.95733976481708,221.290535353059,282.31722646682999,246.67866128466213,null,{"$f":"IF(SUM(K4:K20)=0,\"\",SUM(K4:K20))","v":""}]
[null,null,"",null,"","","","",""]
["B.   Fixed Costs",null,"","","","","","",""]
[null,"Land Costs",{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433}]
[null,"Machinery Costs",{"$f":"'Data (HIDE)'!$AE$16","v":76.170594248435023},{"$f":"'Data (HIDE)'!$AE$17","v":68.009459150388409},{"$f":"'Data (HIDE)'!$AE$18","v":76.170594248435023},{"$f":"'Data (HIDE)'!$AE$19","v":68.009459150388409},{"$f":"'Data (HIDE)'!$AE$20","v":68.009459150388409},{"$f":"'Data (HIDE)'!$AE$21","v":68.009459150388409},{"$f":"'Data (HIDE)'!$AE$22","v":68.009459150388409}]
[null,"Total Fixed ",{"$f":"SUM(C24:C25)","v":154.35838824466947},146.19725314662284,154.35838824466947,146.19725314662284,146.19725314662284,146.19725314662284,146.19725314662284,null,{"$f":"IF(SUM(K24:K25)=0,\"\",SUM(K24:K25))","v":""}]
[null,"if delete it will affect crop rotation and fuel calcs",null,null,null,null,null,null,null,null,{"$f":"IF(OR(K21=\"\",K26=\"\"),\"\",K21+K26)","v":""}]
[]
["C.   Owners - Labour & Living",null,{"$f":"'Data (HIDE)'!$AH$16","v":25},{"$f":"'Data (HIDE)'!$AH$17","v":25},{"$f":"'Data (HIDE)'!$AH$18","v":25},{"$f":"'Data (HIDE)'!$AH$19","v":25},{"$f":"'Data (HIDE)'!$AH$20","v":25},{"$f":"'Data (HIDE)'!$AH$21","v":25},{"$f":"'Data (HIDE)'!$AH$22","v":25}]
[]
["Total Costs",null,{"$f":"+C26+C29+C21","v":649.39199232527562},{"$f":"+D26+D29+D21","v":535.52404875675916},800.09471474775205,427.15459291143992,392.48778849968187,453.51447961345286,417.87591443128497,null,{"$f":"IF(OR(K21=\"\",K26=\"\",K29=\"\"),\"\",SUM(K21+K26+K29))","v":""}]
[]
[null,null,"Profitability Analysis"]
["Estimated Farmgate"]
[null,"Target Price $ per unit",{"$f":"'Data (HIDE)'!$E$16","v":0.45},{"$f":"'Data (HIDE)'!$E$17","v":0.9},{"$f":"'Data (HIDE)'!$E$18","v":0.49},{"$f":"'Data (HIDE)'!$E$19","v":0.2},{"$f":"'Data (HIDE)'!$E$20","v":17.5},{"$f":"'Data (HIDE)'!$E$21","v":0.35},{"$f":"'Data (HIDE)'!$E$22","v":0.42},null,null,null,null,null,null,null,{"$f":"'Data (HIDE)'!$E$16","v":0.45},{"$f":"'Data (HIDE)'!$E$17","v":0.9},{"$f":"'Data (HIDE)'!$E$18","v":0.49},{"$f":"'Data (HIDE)'!$E$19","v":0.2},{"$f":"'Data (HIDE)'!$E$20","v":17.5},{"$f":"'Data (HIDE)'!$E$21","v":0.35},{"$f":"'Data (HIDE)'!$E$22","v":0.42}]
[null,"Premium $ per unit",0,0,0,0,0,0,0]
[null,"Target Yield per acre",{"$f":"'Data (HIDE)'!$C$16","v":1700},{"$f":"'Data (HIDE)'!$C$17","v":750},{"$f":"'Data (HIDE)'!$C$18","v":1400},{"$f":"'Data (HIDE)'!$C$19","v":2300},{"$f":"'Data (HIDE)'!$C$20","v":15},{"$f":"'Data (HIDE)'!$C$21","v":1550},{"$f":"'Data (HIDE)'!$C$22","v":1125},null,null,null,null,null,null,null,{"$f":"'Data (HIDE)'!$C$16","v":1700},{"$f":"'Data (HIDE)'!$C$17","v":750},{"$f":"'Data (HIDE)'!$C$18","v":1400},{"$f":"'Data (HIDE)'!$C$19","v":2300},{"$f":"'Data (HIDE)'!$C$20","v":15},{"$f":"'Data (HIDE)'!$C$21","v":1550},{"$f":"'Data (HIDE)'!$C$22","v":1125}]
[null,"Unit type",{"$f":"'Data (HIDE)'!$D$16","v":"lb"},{"$f":"'Data (HIDE)'!$D$17","v":"lb"},{"$f":"'Data (HIDE)'!$D$18","v":"lb"},{"$f":"'Data (HIDE)'!$D$19","v":"lb"},{"$f":"'Data (HIDE)'!$D$20","v":"bu"},{"$f":"'Data (HIDE)'!$D$21","v":"lb"},{"$f":"'Data (HIDE)'!$D$22","v":"lb"}]
[null,"Gross Revenue / acre",{"$f":"ROUND(((C35+C36)*C37),2)","v":765},675,686,460,262.5,542.5,472.5,null,{"$f":"IF(OR(K35=\"\",K37=\"\"),\"\",ROUND(K35*K37,2))","v":""}]
[null,"Revenue Ranking",{"$f":"RANK(C39,C39:I39)","v":1},{"$f":"RANK(D39,C39:I39)","v":3},{"$f":"RANK(E39,C39:I39)","v":2},{"$f":"RANK(F39,C39:I39)","v":6},{"$f":"RANK(G39,C39:I39)","v":7},{"$f":"RANK(H39,C39:I39)","v":4},{"$f":"RANK(I39,C39:I39)","v":5}]
[]
[null,"Operating Expense Ratio",{"$f":"SUM(C21/C39)","v":0.61442301187007353},0.53974340090390571,0.90486344971294841,0.55642899948873281,0.84301156324974857,0.52040041745037791,0.52207124081409972,null,{"$f":"IF(OR(K21=\"\",K39=\"\"),\"\",K21/K39)","v":""}]
[]
["Marginal Returns "]
[null,"Over Operating Costs",{"$f":"SUM(C39-C21)","v":294.96639591939379},310.67320438986366,65.263673496917363,204.04266023518292,41.209464646941001,260.18277353317001,225.82133871533787,null,{"$f":"IF(OR(K21=\"\",K39=\"\"),\"\",K39-K21)","v":""}]
[null,"Over Operating & Fixed ",{"$f":"SUM(C39-C27)","v":765},675,686,460,262.5,542.5,472.5]
[null,"Over Total Costs (Net Profit)",{"$f":"SUM(C39-C31)","v":115.60800767472438},139.47595124324084,-114.09471474775205,32.84540708856008,-129.98778849968187,88.985520386547137,54.624085568715032,null,{"$f":"IF(OR(K31=\"\",K39=\"\"),\"\",K39-K31)","v":""}]
[null,"Profitability Ranking",{"$f":"RANK(C47,C47:I47)","v":2},{"$f":"RANK(D47,C47:I47)","v":1},{"$f":"RANK(E47,C47:I47)","v":6},{"$f":"RANK(F47,C47:I47)","v":5},{"$f":"RANK(G47,C47:I47)","v":7},{"$f":"RANK(H47,C47:I47)","v":3},{"$f":"RANK(I47,C47:I47)","v":4}]
[]
["Return on Investment (ROI)",null,{"$f":"SUM((C39-C31)/C31)","v":0.17802499729133892},0.26044759626956049,-0.14260151035208748,7.6893489227610329E-2,-0.33118938297818462,0.1962131847750325,0.13071843502408262]
["Return on Asset (ROA)",null,{"$f":"'Data (HIDE)'!$AS$16","v":6.1102625232170152E-2},{"$f":"'Data (HIDE)'!$AS$17","v":6.5826566765117084E-2},{"$f":"'Data (HIDE)'!$AS$18","v":3.096887246696304E-3},{"$f":"'Data (HIDE)'!$AS$19","v":3.8899661675551242E-2},{"$f":"'Data (HIDE)'!$AS$20","v":-2.2198321598633835E-3},{"$f":"'Data (HIDE)'!$AS$21","v":5.3076457962921722E-2},{"$f":"'Data (HIDE)'!$AS$22","v":4.4399327958418652E-2}]
[]
[null,null," Breakeven Analysis"]
["Breakeven Price Per Unit"]
[null,"Over Operating Costs",{"$f":"SUM(Summary!C21/Summary!C37)","v":0.27649035534153305},{"$f":"SUM(Summary!D21/Summary!D37)","v":0.48576906081351512},{"$f":"SUM(Summary!E21/Summary!E37)","v":0.44338309035934476},{"$f":"SUM(Summary!F21/Summary!F37)","v":0.11128579989774656},{"$f":"SUM(Summary!G21/Summary!G37)","v":14.7527023568706},{"$f":"SUM(Summary!H21/Summary!H37)","v":0.18214014610763227},{"$f":"SUM(Summary!I21/Summary!I37)","v":0.2192699211419219}]
[null,"Over Land Costs",{"$f":"SUM(Summary!C24/Summary!C37)","v":4.5992819997784963E-2},{"$f":"SUM(Summary!D24/Summary!D37)","v":0.10425039199497925},{"$f":"SUM(Summary!E24/Summary!E37)","v":5.5848424283024597E-2},{"$f":"SUM(Summary!F24/Summary!F37)","v":3.3994693041841058E-2},{"$f":"SUM(Summary!G24/Summary!G37)","v":5.212519599748962},{"$f":"SUM(Summary!H24/Summary!H37)","v":5.0443738062086733E-2},{"$f":"SUM(Summary!I24/Summary!I37)","v":6.9500261329986157E-2}]
[null,"Over Machinery Costs",{"$f":"SUM(Summary!C25/Summary!C37)","v":4.4806231910844131E-2},{"$f":"SUM(Summary!D25/Summary!D37)","v":9.0679278867184548E-2},{"$f":"SUM(Summary!E25/Summary!E37)","v":5.4407567320310733E-2},{"$f":"SUM(Summary!F25/Summary!F37)","v":2.9569330065386264E-2},{"$f":"SUM(Summary!G25/Summary!G37)","v":4.5339639433592271},{"$f":"SUM(Summary!H25/Summary!H37)","v":4.3877070419605424E-2},{"$f":"SUM(Summary!I25/Summary!I37)","v":6.045285257812303E-2}]
[null,"Over Owners Labour & Lliving",{"$f":"SUM(Summary!C29/Summary!C37)","v":1.4705882352941176E-2},{"$f":"SUM(Summary!D29/Summary!D37)","v":3.3333333333333333E-2},{"$f":"SUM(Summary!E29/Summary!E37)","v":1.7857142857142856E-2},{"$f":"SUM(Summary!F29/Summary!F37)","v":1.0869565217391304E-2},{"$f":"SUM(Summary!G29/Summary!G37)","v":1.6666666666666667},{"$f":"SUM(Summary!H29/Summary!H37)","v":1.6129032258064516E-2},{"$f":"SUM(Summary!I29/Summary!I37)","v":2.2222222222222223E-2}]
[null,"Over Total Costs",{"$f":"SUM(C55:C58)","v":0.38199528960310336},{"$f":"SUM(D55:D58)","v":0.71403206500901217},0.57149622481982298,0.18571938822236517,26.165852566645459,0.29258998684738891,0.3714452572722533]
["Breakeven Yield (Bu or lb.)"]
[null,"Over Operating Costs",{"$f":"ROUND(Summary!C21/Summary!C35,1)","v":1044.5},{"$f":"ROUND(Summary!D21/Summary!D35,1)","v":404.8},{"$f":"ROUND(Summary!E21/Summary!E35,1)","v":1266.8},{"$f":"ROUND(Summary!F21/Summary!F35,1)","v":1279.8},{"$f":"ROUND(Summary!G21/Summary!G35,1)","v":12.6},{"$f":"ROUND(Summary!H21/Summary!H35,1)","v":806.6},{"$f":"ROUND(Summary!I21/Summary!I35,1)","v":587.29999999999995}]
[null,"Over Land Costs",{"$f":"ROUND(Summary!C24/Summary!C35,1)","v":173.8},{"$f":"ROUND(Summary!D24/Summary!D35,1)","v":86.9},{"$f":"ROUND(Summary!E24/Summary!E35,1)","v":159.6},{"$f":"ROUND(Summary!F24/Summary!F35,1)","v":390.9},{"$f":"ROUND(Summary!G24/Summary!G35,1)","v":4.5},{"$f":"ROUND(Summary!H24/Summary!H35,1)","v":223.4},{"$f":"ROUND(Summary!I24/Summary!I35,1)","v":186.2}]
[null,"Over Machinery Costs",{"$f":"ROUND(Summary!C25/Summary!C35,1)","v":169.3},{"$f":"ROUND(Summary!D25/Summary!D35,1)","v":75.599999999999994},{"$f":"ROUND(Summary!E25/Summary!E35,1)","v":155.5},{"$f":"ROUND(Summary!F25/Summary!F35,1)","v":340},{"$f":"ROUND(Summary!G25/Summary!G35,1)","v":3.9},{"$f":"ROUND(Summary!H25/Summary!H35,1)","v":194.3},{"$f":"ROUND(Summary!I25/Summary!I35,1)","v":161.9}]
[null,"Over Owners Labour & Lliving",{"$f":"ROUND(Summary!C29/Summary!C35,1)","v":55.6},{"$f":"ROUND(Summary!D29/Summary!D35,1)","v":27.8},{"$f":"ROUND(Summary!E29/Summary!E35,1)","v":51},{"$f":"ROUND(Summary!F29/Summary!F35,1)","v":125},{"$f":"ROUND(Summary!G29/Summary!G35,1)","v":1.4},{"$f":"ROUND(Summary!H29/Summary!H35,1)","v":71.400000000000006},{"$f":"ROUND(Summary!I29/Summary!I35,1)","v":59.5}]
[null,"Over Total Costs",{"$f":"SUM(C61:C64)","v":1443.1999999999998},{"$f":"SUM(D61:D64)","v":595.1},1632.8999999999999,2135.6999999999998,22.4,1295.7,994.9]
["Breakeven Yield Risk Ratio",null,{"$f":"SUM(Summary!C37/C65)","v":1.1779379157427941},{"$f":"SUM(Summary!D37/D65)","v":1.2602923878339773},{"$f":"SUM(Summary!E37/E65)","v":0.85737032273868585},{"$f":"SUM(Summary!F37/F65)","v":1.0769302804701035},{"$f":"SUM(Summary!G37/G65)","v":0.66964285714285721},{"$f":"SUM(Summary!H37/H65)","v":1.1962645674152967},{"$f":"SUM(Summary!I37/I65)","v":1.1307669112473615}]
[null,"(Target Yield per Acre / BE Yield)"]
[]
[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 utilization of this information is the responsibility of the user."]

{"sheet":"Risk Analysis","index":2,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[20,0,20,8],[20,9,20,10],[63,1,64,8],[0,0,0,8],[51,0,51,8]]}
[{"$f":"IF('Data (HIDE)'!B13=\"Manitoba\",\"AgriInsurance Analysis\",\"AgriInsurance Analysis - \"&'Data (HIDE)'!B13)","v":"AgriInsurance Analysis"}]
[]
[null,{"$f":"\"*Based on \"&'Data (HIDE)'!B45&\"*\"","v":"*Based on 2021 MASC data*"},{"$f":"'Data (HIDE)'!$B$16","v":"Black Bean"},{"$f":"'Data (HIDE)'!$B$17","v":"Hempseed"},{"$f":"'Data (HIDE)'!$B$18","v":"Kidney Bean"},{"$f":"'Data (HIDE)'!$B$19","v":"Fababean"},{"$f":"'Data (HIDE)'!$B$20","v":"Buckwheat"},{"$f":"'Data (HIDE)'!$B$21","v":"Canaryseed"},{"$f":"'Data (HIDE)'!$B$22","v":"Lentil"},null,"Your Farm"]
[]
["AgriInsurance "]
[null,{"$f":"'Data (HIDE)'!B14","v":"80% Insured Value"},{"$f":"'Data (HIDE)'!$AJ$16","v":520},{"$f":"'Data (HIDE)'!$AJ$17","v":460},{"$f":"'Data (HIDE)'!$AJ$18","v":610},{"$f":"'Data (HIDE)'!$AJ$19","v":200},{"$f":"'Data (HIDE)'!$AJ$20","v":180},{"$f":"'Data (HIDE)'!$AJ$21","v":420},{"$f":"'Data (HIDE)'!$AJ$22","v":250}]
[null,"Premium Cost (% of Insured)",{"$f":"'Data (HIDE)'!$AK$16","v":6.4423076923076916E-2},{"$f":"'Data (HIDE)'!$AK$17","v":7.9891304347826084E-2},{"$f":"'Data (HIDE)'!$AK$18","v":7.9098360655737707E-2},{"$f":"'Data (HIDE)'!$AK$19","v":0.18375},{"$f":"'Data (HIDE)'!$AK$20","v":0.10555555555555556},{"$f":"'Data (HIDE)'!$AK$21","v":5.7142857142857141E-2},{"$f":"'Data (HIDE)'!$AK$22","v":6.9000000000000006E-2}]
[]
["Costs Not Covered By AgriInsurance"]
[null,"Operating Costs",{"$f":"IF(Summary!C21-C6<0,0,SUM(Summary!C21-C6))","v":0},{"$f":"IF(Summary!D21-D6<0,0,SUM(Summary!D21-D6))","v":0},{"$f":"IF(Summary!E21-E6<0,0,SUM(Summary!E21-E6))","v":10.736326503082637},{"$f":"IF(Summary!F21-F6<0,0,SUM(Summary!F21-F6))","v":55.957339764817078},{"$f":"IF(Summary!G21-G6<0,0,SUM(Summary!G21-G6))","v":41.290535353058999},{"$f":"IF(Summary!H21-H6<0,0,SUM(Summary!H21-H6))","v":0},{"$f":"IF(Summary!I21-I6<0,0,SUM(Summary!I21-I6))","v":0}]
[null,"Operating & Fixed Costs",{"$f":"IF(Summary!C27-C6<0,0,SUM(Summary!C27-C6))","v":0},{"$f":"IF(Summary!D27-D6<0,0,SUM(Summary!D27-D6))","v":0},{"$f":"IF(Summary!E27-E6<0,0,SUM(Summary!E27-E6))","v":0},{"$f":"IF(Summary!F27-F6<0,0,SUM(Summary!F27-F6))","v":0},{"$f":"IF(Summary!G27-G6<0,0,SUM(Summary!G27-G6))","v":0},{"$f":"IF(Summary!H27-H6<0,0,SUM(Summary!H27-H6))","v":0},{"$f":"IF(Summary!I27-I6<0,0,SUM(Summary!I27-I6))","v":0}]
[null,"Total Costs",{"$f":"IF(Summary!C31-C6<0,0,SUM(Summary!C31-C6))","v":129.39199232527562},{"$f":"IF(Summary!D31-D6<0,0,SUM(Summary!D31-D6))","v":75.524048756759157},{"$f":"IF(Summary!E31-E6<0,0,SUM(Summary!E31-E6))","v":190.09471474775205},{"$f":"IF(Summary!F31-F6<0,0,SUM(Summary!F31-F6))","v":227.15459291143992},{"$f":"IF(Summary!G31-G6<0,0,SUM(Summary!G31-G6))","v":212.48778849968187},{"$f":"IF(Summary!H31-H6<0,0,SUM(Summary!H31-H6))","v":33.514479613452863},{"$f":"IF(Summary!I31-I6<0,0,SUM(Summary!I31-I6))","v":167.87591443128497}]
[]
["AgriInsurance Risk Ratio",null,"(AgriInsurance Coverage / Cost)"]
[null,"Operating Costs",{"$f":"SUM(C6/Summary!C21)","v":1.1063038801600769},{"$f":"SUM(D6/Summary!D21)","v":1.2626027114740221},{"$f":"SUM(E6/Summary!E21)","v":0.98270388561989641},{"$f":"SUM(F6/Summary!F21)","v":0.78138021040446537},{"$f":"SUM(G6/Summary!G21)","v":0.81341029661669972},{"$f":"SUM(H6/Summary!H21)","v":1.4876881770774502},{"$f":"SUM(I6/Summary!I21)","v":1.0134642319608875}]
[null,"Total Costs",{"$f":"SUM(C6/Summary!C31)","v":0.80074901776666174},{"$f":"SUM(D6/Summary!D31)","v":0.85897169523555239},{"$f":"SUM(E6/Summary!E31)","v":0.76240973569275017},{"$f":"SUM(F6/Summary!F31)","v":0.46821456053374361},{"$f":"SUM(G6/Summary!G31)","v":0.45861299452924481},{"$f":"SUM(H6/Summary!H31)","v":0.9261005301484122},{"$f":"SUM(I6/Summary!I31)","v":0.59826372223496438}]
[]
[null,"Risk Ranking",{"$f":"RANK(C15,$C15:$I15,1)","v":5},6,3,1,2,7,4]
[null,"(Lower number indicates increasing risk)"]
[]
[{"$f":"IF('Data (HIDE)'!B13=\"Manitoba\",\"Risk & Sensitivity Analysis (Stress Test)\",\"Sensitivity Analysis (Stress Test) - \"&'Data (HIDE)'!B13)","v":"Risk & Sensitivity Analysis (Stress Test)"}]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"Summary!C21","v":470.03360408060621},{"$f":"Summary!D21","v":364.32679561013634},{"$f":"Summary!E21","v":620.73632650308264},{"$f":"Summary!F21","v":255.95733976481708},{"$f":"Summary!G21","v":221.290535353059},{"$f":"Summary!H21","v":282.31722646682999},{"$f":"Summary!I21","v":246.67866128466213}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"Summary!C26","v":154.35838824466947},{"$f":"Summary!D26","v":146.19725314662284},{"$f":"Summary!E26","v":154.35838824466947},{"$f":"Summary!F26","v":146.19725314662284},{"$f":"Summary!G26","v":146.19725314662284},{"$f":"Summary!H26","v":146.19725314662284},{"$f":"Summary!I26","v":146.19725314662284}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"Summary!C31","v":649.39199232527562},{"$f":"Summary!D31","v":535.52404875675916},{"$f":"Summary!E31","v":800.09471474775205},{"$f":"Summary!F31","v":427.15459291143992},{"$f":"Summary!G31","v":392.48778849968187},{"$f":"Summary!H31","v":453.51447961345286},{"$f":"Summary!I31","v":417.87591443128497}]
[]
["Estimated Farmgate"]
[null,"Price $ per unit",{"$f":"Summary!C35","v":0.45},{"$f":"Summary!D35","v":0.9},{"$f":"Summary!E35","v":0.49},{"$f":"Summary!F35","v":0.2},{"$f":"Summary!G35","v":17.5},{"$f":"Summary!H35","v":0.35},{"$f":"Summary!I35","v":0.42}]
[null,"Yield per acre (bu or lb.)",{"$f":"Summary!C37","v":1700},{"$f":"Summary!D37","v":750},{"$f":"Summary!E37","v":1400},{"$f":"Summary!F37","v":2300},{"$f":"Summary!G37","v":15},{"$f":"Summary!H37","v":1550},{"$f":"Summary!I37","v":1125}]
[null,"Unit type",{"$f":"Summary!C38","v":"lb"},{"$f":"Summary!D38","v":"lb"},{"$f":"Summary!E38","v":"lb"},{"$f":"Summary!F38","v":"lb"},{"$f":"Summary!G38","v":"bu"},{"$f":"Summary!H38","v":"lb"},{"$f":"Summary!I38","v":"lb"}]
[]
[null,null,null,"Percent Market Price Change",-0.2]
[null,null,null,"Percent Crop Yield Change",-0.1]
[]
[]
[null,null,{"$f":"'Data (HIDE)'!$B$16","v":"Black Bean"},{"$f":"'Data (HIDE)'!$B$17","v":"Hempseed"},{"$f":"'Data (HIDE)'!$B$18","v":"Kidney Bean"},{"$f":"'Data (HIDE)'!$B$19","v":"Fababean"},{"$f":"'Data (HIDE)'!$B$20","v":"Buckwheat"},{"$f":"'Data (HIDE)'!$B$21","v":"Canaryseed"},{"$f":"'Data (HIDE)'!$B$22","v":"Lentil"},null,"Your Farm"]
[]
[null,"Market Price ($ per unit)",{"$f":"SUM(C29*(1+$E$33))","v":0.36000000000000004},0.72000000000000008,0.39200000000000002,0.16000000000000003,14,0.27999999999999997,0.33600000000000002]
[null,"Yield (per acre)",{"$f":"ROUND(C30*(1+$E$34),0)","v":1530},675,1260,2070,14,1395,1013]
[]
[{"$f":"\"Stress Test Scenario = Market Price \"&IF(E33<0,\"Down\",\"Up\")&\" \"&ABS(E33*100)&\"%, and Crop Yield \"&IF(E34<0,\"Down\",\"Up\")&\" \"&ABS(E34*100)&\"%\"","v":"Stress Test Scenario = Market Price Down 20%, and Crop Yield Down 10%"}]
[null,"Gross Revenue / acre",{"$f":"C39*C40","v":550.80000000000007},486.00000000000006,493.92,331.20000000000005,196,390.59999999999997,340.36799999999999]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C43-C24)","v":80.766395919393858},121.67320438986371,-126.81632650308262,75.242660235182967,-25.290535353058999,108.28277353316997,93.689338715337868]
[null,"   Over Operating & Fixed ",{"$f":"SUM(C43-(C24+C25))","v":-73.591992325275555},-24.5240487567591,-281.17471474775203,-70.954592911439875,-171.48778849968187,-37.914479613452897,-52.507914431284973]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C43-C26)","v":-98.591992325275555},-49.5240487567591,-306.17471474775203,-95.954592911439875,-196.48778849968187,-62.914479613452897,-77.507914431284973]
[null,"Profitability Ranking",{"$f":"RANK(C47,C47:I47)","v":5},{"$f":"RANK(D47,C47:I47)","v":1},{"$f":"RANK(E47,C47:I47)","v":7},{"$f":"RANK(F47,C47:I47)","v":4},{"$f":"RANK(G47,C47:I47)","v":6},{"$f":"RANK(H47,C47:I47)","v":2},{"$f":"RANK(I47,C47:I47)","v":3}]
[]
[null,"Operating Expense Ratio",{"$f":"SUM(C24/C43)","v":0.85336529426399088},0.74964361236653565,1.256754791267984,0.77281805484546207,1.1290333436380562,0.72277835756996933,0.72474104876093559]
[]
[" Acreage Analysis"]
[]
[null,null,{"$f":"'Data (HIDE)'!$B$16","v":"Black Bean"},{"$f":"'Data (HIDE)'!$B$17","v":"Hempseed"},{"$f":"'Data (HIDE)'!$B$18","v":"Kidney Bean"},{"$f":"'Data (HIDE)'!$B$19","v":"Fababean"},{"$f":"'Data (HIDE)'!$B$20","v":"Buckwheat"},{"$f":"'Data (HIDE)'!$B$21","v":"Canaryseed"},{"$f":"'Data (HIDE)'!$B$22","v":"Lentil"},null,"Your Farm"]
[]
["MASC Seeded Acreage "]
[null,"5 Year Average Acres",{"$f":"'Data (HIDE)'!$H$16","v":25222.6},{"$f":"'Data (HIDE)'!$H$17","v":12974},{"$f":"'Data (HIDE)'!$H$18","v":10570.2},{"$f":"'Data (HIDE)'!$H$19","v":6828.4},{"$f":"'Data (HIDE)'!$H$20","v":5471.2},{"$f":"'Data (HIDE)'!$H$21","v":4227.8},{"$f":"'Data (HIDE)'!$H$22","v":1899.8}]
[null,"Acre Ranking",{"$f":"RANK(C57,C57:I57)","v":1},{"$f":"RANK(D57,C57:I57)","v":2},{"$f":"RANK(E57,C57:I57)","v":3},{"$f":"RANK(F57,C57:I57)","v":4},{"$f":"RANK(G57,C57:I57)","v":5},{"$f":"RANK(H57,C57:I57)","v":6},{"$f":"RANK(I57,C57:I57)","v":7}]
[]
[null,{"$f":"'Data (HIDE)'!J15","v":"2021 Acres"},{"$f":"'Data (HIDE)'!$J$16","v":27846},{"$f":"'Data (HIDE)'!$J$17","v":6131},{"$f":"'Data (HIDE)'!$J$18","v":9454},{"$f":"'Data (HIDE)'!$J$19","v":5206},{"$f":"'Data (HIDE)'!$J$20","v":4416},{"$f":"'Data (HIDE)'!$J$21","v":6979},{"$f":"'Data (HIDE)'!$J$22","v":1070}]
[null,"Acre Ranking",{"$f":"RANK(C60,C60:I60)","v":1},{"$f":"RANK(D60,C60:I60)","v":4},{"$f":"RANK(E60,C60:I60)","v":2},{"$f":"RANK(F60,C60:I60)","v":5},{"$f":"RANK(G60,C60:I60)","v":6},{"$f":"RANK(H60,C60:I60)","v":3},{"$f":"RANK(I60,C60:I60)","v":7}]
[]
[]
[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 utilization of this information is the responsibility of the user."]

{"sheet":"Charts","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Seed, Fertilizer & Chemical","index":4,"n_rows":56,"n_cols":46,"rows_kept":56,"cut":false,"hidden":false,"merged":[[36,1,38,14],[40,0,40,14],[0,0,0,14],[11,0,11,14],[22,2,22,12],[23,2,23,3],[23,5,23,6],[23,8,23,9],[23,11,23,12],[33,1,34,14]]}
["Seed & Treatment"]
[null,null,null,"Seeding Rate",null,null,"Price",null,null,"Cost"]
["Crop",null,null,"per Acre",null,null,"per Unit",null,null,"per Acre"]
[null,"Hempseed",null,25,"lb",null,2.35,"/lb",null,{"$f":"ROUND(D4*G4,2)","v":58.75}]
[null,"Black Bean",null,1.25,"unit",null,77,"/unit",null,96.25]
[null,"Kidney Bean",null,1.1000000000000001,"unit",null,209,"/unit",null,229.9]
[null,"Buckwheat",null,1,"bu",null,25,"/bu",null,25]
[null,"Canaryseed",null,44,"lb",null,0.75,"/lb",null,33]
[null,"Fababean",null,180,"lb",null,0.22,"/lb",null,39.6]
[null,"Lentil",null,2,"bu",null,35,"/bu",null,70]
[]
["Fertilizer"]
[null,null,null,"Bulk Price",null,null,"Actual Nutrient",null,null,"Nitrogen",null,null,"Sulphur"]
["Fertilizer Type",null,null,"$/tonne",null,null,"$/lb",null,null,"Usage",null,null,"Usage"]
[null,"Nitrogen: (urea) 46-0-0",null,1090,null,null,{"$f":"SUM(D15/(2204.5855*0.46))","v":1.0748348010958542},null,null,0.75,null,null," -"]
[null,"Nitrogen: (NH3) 82-0-0",null,1330,null,null,{"$f":"SUM(D16/(2204.5855*0.82))","v":0.73571708582506556},null,null,0.25,null,null," -"]
[null,"Nitrogen: (liquid) 28-0-0",null,640,null,null,{"$f":"SUM(D17/(2204.5855*0.28))","v":1.0368000178329602},null,null,0,null,null," -"]
[null,"Phosphorus:   11-52-0",null,1175,null,null,{"$f":"SUM((D18-(G15*(0.11*2204.5855)))/(2204.5855*0.52))","v":0.79759265585906169},null,null," -",null,null," -"]
[null,"Potash:   0-0-60",null,835,null,null,{"$f":"SUM(D19/(2204.5855*0.6))","v":0.63126001085767214},null,null," -",null,null," -"]
[null,"Sulphur:   20.5-0-0-24",null,640,null,null,{"$f":"SUM((D20-(G15*(0.205*2204.5855)))/(2204.5855*0.24))","v":0.29151196153574505},null,null," -",null,null,1]
[null,"MES S15:  13-33-0-15",null,1100,null,null,{"$f":"SUM((D21-(G15*(0.13*2204.5855))-(G18*(0.33*2204.5855)))/(2204.5855*0.15))","v":0.64017272004107129},0,null," -",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"***HIDE***"]
[null,null,"Amount of Actual Pounds of Elements Applied Per Acre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"82-0-0",null,null,null,"28-0-0",null,null,null,null,null,"46-0-0",null,null,null,"11-52-0",null,null,"0-0-60",null,null,"20.5-0-0-24",null,null,"13-33-0-15"]
[null,null,"Nitrogen",null,null,"Phosphorus",null,null,"Potash",null,null,"Sulphur",null,null,"Total",null,null,null,"preseed","preseed","preseed","preseed","suppl","suppl","suppl","suppl","blend ","blend","blend","blend","blend","blend","blend","blend","blend","blend","blend ","blend","blend","blend ","blend","blend","blend ","blend","blend","N phos"]
["Crop",null,"lbs","$/acre",null,"lbs","$/acre",null,"lbs","$/acre",null,"lbs","$/acre",null,"$/acre",null,null,null,"N actual","N lbs","N MT","N cost","N actual","N lbs","N MT","N cost","N phos","N  sul1","N  sul2","N urea","N lbs","N MT","N cost","phos lbs","phos MT","phos cost","potash","pot MT","pot cost","sul 1 lbs","sul 1 MT","sul 1 cost","sul 2 lbs","sul 2 MT","sul 2 cost","lbs"]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B4","v":"Hempseed"},80,{"$f":"IF(SUM($J$15:$J$17)<>100%,\"ERROR\",SUM(V26+Z26+AG26))","v":72.382886698567518},null,30,{"$f":"AJ26","v":30.748644442738613},null,0,{"$f":"AM26","v":0},null,0,{"$f":"IF(SUM($M$20:$M$21)<>100%,\"ERROR\",AP26+AS26)","v":0},null,{"$f":"D26+G26+J26+M26","v":103.13153114130613},null,null,null,{"$f":"SUM(C26*$J$16)","v":20},{"$f":"MAXA(0,(S26)/(0.82))","v":24.390243902439025},{"$f":"(T26)/2204.6","v":1.1063342058622437E-2},{"$f":"SUM(U26*$D$16)","v":14.714244937967841},{"$f":"SUM(C26*$J$17)","v":0},{"$f":"MAXA(0,(W26)/(0.28))","v":0},{"$f":"(X26)/2204.6","v":0},{"$f":"SUM(Y26*$D$17)","v":0},{"$f":"SUM(AH26*0.11)","v":6.3461538461538467},{"$f":"SUM(AN26*0.205)","v":0},{"$f":"SUM(AQ26*0.13)","v":0},{"$f":"SUM(C26-(AA26+AB26+AC26+W26+S26))","v":53.653846153846153},{"$f":"MAXA(0,(AD26)/(0.46))","v":116.63879598662207},{"$f":"(AE26)/2204.6","v":5.2907010789540992E-2},{"$f":"SUM(AF26*$D$15)","v":57.668641760599684},{"$f":"MAXA(0,(F26-(AQ26*0.33))/0.52)","v":57.692307692307693},{"$f":"(AH26)/2204.6","v":2.6169059100203073E-2},{"$f":"SUM(AI26*$D$18)","v":30.748644442738613},{"$f":"SUM(I26/0.6)","v":0},{"$f":"(AK26)/2204.6","v":0},{"$f":"SUM(AL26*$D$19)","v":0},{"$f":"MAXA(0,SUM(L26*$M$20)/0.24)","v":0},{"$f":"(AN26)/2204.6","v":0},{"$f":"SUM(AO26*$D$20)","v":0},{"$f":"MAXA(0,SUM(L26*$M$21)/0.15)","v":0},{"$f":"(AQ26)/2204.6","v":0},{"$f":"SUM(AR26*$D$21)","v":0}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B5","v":"Black Bean"},80,{"$f":"IF(SUM($J$15:$J$17)<>100%,\"ERROR\",SUM(V27+Z27+AG27))","v":72.382886698567518},null,30,{"$f":"AJ27","v":30.748644442738613},null,0,{"$f":"AM27","v":0},null,0,{"$f":"IF(SUM($M$20:$M$21)<>100%,\"ERROR\",AP27+AS27)","v":0},null,103.13153114130613,null,null,null,{"$f":"SUM(C27*$J$16)","v":20},{"$f":"MAXA(0,(S27)/(0.82))","v":24.390243902439025},{"$f":"(T27)/2204.6","v":1.1063342058622437E-2},{"$f":"SUM(U27*$D$16)","v":14.714244937967841},{"$f":"SUM(C27*$J$17)","v":0},{"$f":"MAXA(0,(W27)/(0.28))","v":0},{"$f":"(X27)/2204.6","v":0},{"$f":"SUM(Y27*$D$17)","v":0},{"$f":"SUM(AH27*0.11)","v":6.3461538461538467},{"$f":"SUM(AN27*0.205)","v":0},{"$f":"SUM(AQ27*0.13)","v":0},{"$f":"SUM(C27-(AA27+AB27+AC27+W27+S27))","v":53.653846153846153},{"$f":"MAXA(0,(AD27)/(0.46))","v":116.63879598662207},{"$f":"(AE27)/2204.6","v":5.2907010789540992E-2},{"$f":"SUM(AF27*$D$15)","v":57.668641760599684},{"$f":"MAXA(0,(F27-(AQ27*0.33))/0.52)","v":57.692307692307693},{"$f":"(AH27)/2204.6","v":2.6169059100203073E-2},{"$f":"SUM(AI27*$D$18)","v":30.748644442738613},{"$f":"SUM(I27/0.6)","v":0},{"$f":"(AK27)/2204.6","v":0},{"$f":"SUM(AL27*$D$19)","v":0},{"$f":"MAXA(0,SUM(L27*$M$20)/0.24)","v":0},{"$f":"(AN27)/2204.6","v":0},{"$f":"SUM(AO27*$D$20)","v":0},{"$f":"MAXA(0,SUM(L27*$M$21)/0.15)","v":0},{"$f":"(AQ27)/2204.6","v":0},{"$f":"SUM(AR27*$D$21)","v":0}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B6","v":"Kidney Bean"},80,72.382886698567518,null,30,30.748644442738613,null,0,0,null,0,0,null,103.13153114130613,null,null,null,20,24.390243902439025,1.1063342058622437E-2,14.714244937967841,0,0,0,0,6.3461538461538467,0,0,53.653846153846153,116.63879598662207,5.2907010789540992E-2,57.668641760599684,57.692307692307693,2.6169059100203073E-2,30.748644442738613,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B7","v":"Buckwheat"},40,35.054606325329289,null,20,20.49909629515907,null,0,0,null,0,0,null,55.553702620488359,null,null,null,10,12.195121951219512,5.5316710293112185E-3,7.3571224689839205,0,0,0,0,4.2307692307692308,0,0,25.76923076923077,56.020066889632105,2.5410535648023272E-2,27.697483856345368,38.46153846153846,1.744603940013538E-2,20.49909629515907,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B8","v":"Canaryseed"},70,63.619235117235192,null,25,25.62387036894884,null,0,0,null,0,0,null,89.243105486184035,null,null,null,17.5,21.341463414634148,9.6804243012946333E-3,12.874964320721862,0,0,0,0,5.2884615384615383,0,0,47.21153846153846,102.63377926421404,4.6554376877535171E-2,50.744270796513334,48.076923076923073,2.1807549250169225E-2,25.62387036894884,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B9","v":"Fababean"},0,0,null,25,25.62387036894884,null,0,0,null,20,24.191841301521066,null,49.815711670469909,null,null,null,0,0,0,0,0,0,0,0,5.2884615384615383,17.083333333333336,0,-22.371794871794876,0,0,0,48.076923076923073,2.1807549250169225E-2,25.62387036894884,0,0,0,83.333333333333343,3.7799752033626663E-2,24.191841301521066,0,0,0]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B10","v":"Lentil"},0,0,null,25,25.62387036894884,null,0,0,null,0,0,null,25.62387036894884,null,null,null,0,0,0,0,0,0,0,0,5.2884615384615383,0,0,-5.2884615384615383,0,0,0,48.076923076923073,2.1807549250169225E-2,25.62387036894884,0,0,0,0,0,0,0,0,0]
[]
["*","The fertilizer recommendation will vary depending on the soil type, climate and crop rotation. MB Ag. recommends that soil test sampling and analysis be conducted each year to produce a better baseline for fertility. It costs $1.00 to $2.00/acre for custom sampling and analysis. "]
[]
["*","For more information on fertilizer rates and recommendations - "]
["*","Note: phosphorus amounts are allotted to each crop in the above examples.  Sometimes this amount may not be practical or safe to apply with the seed of some crops like soybean or canola.  Options for meeting these needs and phosphorus balance through the rotation are provided at: "]
[]
[]
[]
["Chemicals"]
[null,null,null,"Weed",null,"Disease","Insect ",null,null,"Total"]
[null,null,null,"Control",null,"Control","Control",null,null,"Cost"]
["Crop",null,null,"$/acre",null,"$/acre","$/acre",null,null,"$/acre"]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B4","v":"Hempseed"},null,47.54,null,0,0,null,null,{"$f":"D45+F45+G45","v":47.54}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B5","v":"Black Bean"},null,77.02,null,40.5,0,null,null,117.52]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B6","v":"Kidney Bean"},null,77.02,null,40.5,0,null,null,117.52]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B7","v":"Buckwheat"},null,6.13,null,0,0,null,null,6.13]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B8","v":"Canaryseed"},null,14.42,null,13.75,0,null,null,28.17]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B9","v":"Fababean"},null,15.5,null,0,0,null,null,15.5]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B10","v":"Lentil"},null,15.5,null,13.88,0,null,null,29.380000000000003]
[]
[null,"Note: "]
[null,"Pre-emergent burn off and/or pre-harvest desiccation not included in weed control costs."]
[null,"Chemical costs do not include year end rebates or bundling discounts. "]
[null,"Disease Control costs do not include custom application costs. "]

{"sheet":"Op. Cost Input","index":5,"n_rows":34,"n_cols":29,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,13],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[21,0,21,13],[10,8,10,13],[9,4,9,13],[24,10,25,10],[24,11,25,11],[24,12,25,12],[24,13,25,13],[23,12,23,13],[23,4,23,11]]}
["Operating Costs"]
[]
[null,"Interest Rate on Operating",null,0.05,null,null,"Grain Hauling",null,null,null,null,null,null,null,null,null,null,"# Hired","# of","Acres","Hours "]
[null,"Land Taxes  ($/acre)",null,17.5,null,null,"  Distance to storage",null,6,"miles roundtrip",null,null,null,null,null,null,null,"Staff","Months","Farmed","Per Acre"]
[null,"Labour rate ($/hour)",null,25,null,null,"  Distance to market",null,45,"miles roundtrip",null,null,null,null,null,null,null,1,12,{"$f":"'Fixed Cost Input'!D5+'Fixed Cost Input'!D6","v":2500},{"$f":"SUM(R5*S5*4*40)/T5","v":0.76800000000000002}]
[null,"Machinery Operating  ($/acre)",null,20,null,null,"  Grain truck fuel use",null,5,"Miles per Imp. Gallon",null,null,null,null,null,null,null,1,4,{"$f":"T5","v":2500},{"$f":"SUM(R6*S6*4*40)/T6","v":0.25600000000000001}]
[null,"Other Costs ($/acre)",null,17.75,null,null,"  Grain truck size",null,475,"bushels",null,null,null,null,null,null,null,0,0,{"$f":"T5","v":2500},{"$f":"SUM(R7*S7*4*40)/T7","v":0}]
[null,"Fuel Cost  ($/litre)",null,1.1499999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"T5","v":2500},{"$f":"SUM(R8*S8*4*40)/T8","v":0}]
[null,"Owners - Labour & Living (hrs/acre)",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(U5:U8)","v":1.024}]
[null,null,null,null,"Operating Cost ($/Acre)"]
[null,null,"Labour",null,"Crop*","Hail","Drying","Storage","Rental and Custom Costs"]
["Crop",null,"(hrs/acre)","Fuel","Insurance","Insurance","Costs","$/acre**","Seeding","Application","Swathing","Harvest","General","Total"]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B4","v":"Hempseed"},0.2,{"$f":"SUM($D$8*D28)","v":24.453561483253587},{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,2,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":36.75},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,3,FALSE)","v":18.899999999999999},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,2,FALSE)/44*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":2.7817029855766728},"-","-","-","-","-",{"$f":"SUM(I13:M13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,2,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,2,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,2,FALSE)))+'Data (HIDE)'!$D$77","v":36.662999999999997},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,3,FALSE)","v":18.899999999999999}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B5","v":"Black Bean"},0.2,23.880764421052632,{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,3,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":33.5},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,4,FALSE)","v":16.537499999999998},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,3,FALSE)/60*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":4.6238085182474471},"-","-","-","-","-",{"$f":"SUM(I14:M14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,3,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,3,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,3,FALSE)))+'Data (HIDE)'!$D$77","v":33.471000000000004},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,4,FALSE)","v":16.537499999999998}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B6","v":"Kidney Bean"},0.2,23.319453052631577,{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,4,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":48.25},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,5,FALSE)","v":16.537499999999998},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,4,FALSE)/60*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":3.8078423091449567},"-","-","-","-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,4,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,4,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,4,FALSE)))+'Data (HIDE)'!$D$77","v":48.131999999999991},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,5,FALSE)","v":16.537499999999998}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B7","v":"Buckwheat"},0.2,21.003934105263156,{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,5,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":19},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,6,FALSE)","v":23.625},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,5,FALSE)*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":2.4478986273074721},"-","-","-","-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,5,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,5,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,5,FALSE)))+'Data (HIDE)'!$D$77","v":19.116},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,6,FALSE)","v":23.625}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B8","v":"Canaryseed"},0.2,23.375130484210526,{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,6,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":24},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,7,FALSE)","v":9.4499999999999993},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,6,FALSE)/50*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":5.0589904964354435},"-","-","-","-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,6,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,6,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,6,FALSE)))+'Data (HIDE)'!$D$77","v":23.996999999999996},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,7,FALSE)","v":9.4499999999999993}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B9","v":"Fababean"},0.2,22.128387157894736,{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,7,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":36.75},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,8,FALSE)","v":16.537499999999998},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,7,FALSE)/60*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":6.2557409364524288},"-","-","-","-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,7,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,7,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,7,FALSE)))+'Data (HIDE)'!$D$77","v":36.662999999999997},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,8,FALSE)","v":16.537499999999998}]
[null,{"$f":"'Seed, Fertilizer & Chemical'!B10","v":"Lentil"},0.2,19.929917631578945,{"$f":"MROUND(HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,8,FALSE)+'Data (HIDE)'!$D$77,0.25)","v":17.25},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,9,FALSE)","v":12.285},"-",{"$f":"-PMT('Fixed Cost Input'!$C$11,20,(HLOOKUP('Data (HIDE)'!$B$13,'Data (HIDE)'!$C$46:$G$53,8,FALSE)/60*(('Fixed Cost Input'!$C$17*'Fixed Cost Input'!$D$17)+('Fixed Cost Input'!$C$18*'Fixed Cost Input'!$D$18)+('Fixed Cost Input'!$C$19*'Fixed Cost Input'!$D$19))*'Fixed Cost Input'!$D$20),0)","v":3.0598732841343401},"-","-","-","-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data (HIDE)'!$B$14=\"80% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!$C$68:$G$75,8,FALSE),IF('Data (HIDE)'!$B$14=\"70% Insured Value\",HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,8,FALSE),HLOOKUP('Data (HIDE)'!$V$14,'Data (HIDE)'!#REF!,8,FALSE)))+'Data (HIDE)'!$D$77","v":17.171999999999997},{"$f":"HLOOKUP('Data (HIDE)'!$W$14,'Data (HIDE)'!$D$82:$H$90,9,FALSE)","v":12.285}]
[{"$f":"IF('Data (HIDE)'!B13=\"Manitoba\",\"* \"&'Data (HIDE)'!B14&\" - Based on MASC Risk Areas 2, 5, 6, & 12\",\"* \"&'Data (HIDE)'!B14&\" - Based on MASC \"&'Data (HIDE)'!B13)","v":"* 80% Insured Value - Based on MASC Risk Areas 2, 5, 6, & 12"},null,null,null,null,null,null,"** Storage costs are listed under Fixed Costs on the Summary Page."]
[]
["Field Fuel Usage"]
[]
[null,null,null,null,"Number of Field Operations & Litres Fuel Per Acre Per Operation",null,null,null,null,null,null,null,"Trucks L/acre"]
[null,null,null,null,"cultivator or tandem disk","high speed disk","harrow or land roller","air drill","row planter","SP sprayer","swather","combine & grain cart","3/4 ton pickup","grain hauling"]
[null,null,null,"Total"]
["Crop",null,null,"L/acre",2.2999999999999998,3.5,1.1000000000000001,2.6,1.7,0.5,1.8,6,2]
[null,{"$f":"B13","v":"Hempseed"},null,{"$f":"SUM(E28*$E$27)+(F28*$F$27)+(G28*$G$27)+(H28*$H$27)+(I28*$I$27)+(J28*$J$27)+(K28*$K$27)+(L28*$L$27)+M28+N28","v":21.263966507177035},1,1,2,1,null,2,null,1,{"$f":"$M$27","v":2},{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B28,Summary!$C$2:$S$37,36,FALSE)/44)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B28,Summary!$C$2:$S$37,36,FALSE)/44)))","v":1.6639665071770338}]
[null,"Black Bean",null,{"$f":"SUM(E29*$E$27)+(F29*$F$27)+(G29*$G$27)+(H29*$H$27)+(I29*$I$27)+(J29*$J$27)+(K29*$K$27)+(L29*$L$27)+M29+N29","v":20.765882105263159},1,null,2,null,1,4,1,1,2,{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B29,Summary!$C$2:$S$37,36,FALSE)/60)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B29,Summary!$C$2:$S$37,36,FALSE)/60)))","v":2.7658821052631577}]
[null,"Kidney Bean",null,20.277785263157895,1,null,2,null,1,4,1,1,2,{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B30,Summary!$C$2:$S$37,36,FALSE)/60)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B30,Summary!$C$2:$S$37,36,FALSE)/60)))","v":2.2777852631578948}]
[null,"Buckwheat",null,18.26429052631579,1,null,1,1,null,2,1,1,2,{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/HLOOKUP(B31,Summary!$C$2:$I$37,36,FALSE)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/HLOOKUP(B31,Summary!$C$2:$I$37,36,FALSE)))","v":1.4642905263157895}]
[null,"Canaryseed",null,20.326200421052633,1,null,1,1,null,3,1,1,2,{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B32,Summary!$C$2:$S$37,36,FALSE)/50)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B32,Summary!$C$2:$S$37,36,FALSE)/50)))","v":3.0262004210526321}]
[null,"Fababean",null,19.242075789473684,1,null,1,1,null,3,null,1,2,{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B33,Summary!$C$2:$S$37,36,FALSE)/60)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B33,Summary!$C$2:$S$37,36,FALSE)/60)))","v":3.7420757894736845}]
[null,"Lentil",null,17.330363157894737,1,null,1,1,null,3,null,1,2,{"$f":"SUM((($I$4/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B34,Summary!$C$2:$S$37,36,FALSE)/60)))+((($I$5/$I$6)*4.546)/('Op. Cost Input'!$I$7/(HLOOKUP(B34,Summary!$C$2:$S$37,36,FALSE)/60)))","v":1.830363157894737}]

{"sheet":"Fixed Cost Input","index":6,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,9],[21,0,21,9],[45,0,45,9],[53,0,53,9]]}
["Fixed Costs"]
[]
[null,"Land",null,null,null,null,null,null,"Conventional","Special"]
[null,"  Average Land value ($/acre)",null,3400,null,null,"Machinery",null,"Crop","Crop"]
[null,"  Conventional Crop acres",null,2000,null,null,"  Total Investment ($/acre)",null,{"$f":"ROUND((C44)/(D5+D6),2)","v":500},{"$f":"ROUND((C52)/(D6+D5),2)","v":60}]
[null,"  Special Crop acres",null,500,null,null,"  Residual Value (End of Useful Life)",null,0.25]
[null,"  Owned Land Equity",null,0.85,null,null,"  Useful Life (years)",null,15]
[null,"  Land Financed",null,{"$f":"SUM(1-D7)","v":0.15000000000000002},null,null,"  Owned Equipment Equity",null,0.55000000000000004]
[null,"  Land Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2,null,null,"  Equipment Financed",null,{"$f":"SUM(1-I8)","v":0.44999999999999996}]
[null,"Land cost ($/acre)",null,null,null,null,"  Machinery Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2]
[null,"  Finance Rate & Term",4.6249999999999999E-2,25,"Years"]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C11,D11,D4*D8,0)","v":34.837793996234424},null,null,"Machinery Cost ($/acre)"]
[null,"  Owned Land Opportunity Cost",null,{"$f":"SUM(D4*D7)*(D9)","v":43.35},null,null,"  Finance Rate & Term",0.05,7,"Years"]
[null,"  Total Cost",null,{"$f":"SUM(D12:D13)","v":78.187793996234433},null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H13,I13,I5*I9,0)","v":38.884459150388409},{"$f":"-PMT(H13,I13,J5*I9,0)","v":4.6661350980466088}]
[null,null,null,null,null,null,"  Machinery Depreciation Cost",null,{"$f":"(I5-(I5*I6))/I7","v":25},{"$f":"(J5-(J5*I6))/I7","v":3}]
[null,"Grain Storage ","Usage %","Cost",null,null,"  Owned Machinery Opportunity Cost ",null,{"$f":"SUM(I5*I8)*(I10)","v":4.125},{"$f":"SUM(J5*I8)*(I10)","v":0.495}]
[null,"  Non-aeration bins",0.15,2.5,"/bu",null,null,null,{"$f":"SUM(I14:I16)","v":68.009459150388409},{"$f":"SUM(J14:J16)","v":8.1611350980466089}]
[null,"  Aeration bins",0.7,3.5,"/bu"]
[null,"  Hopper bins",0.15,4.5,"/bu",null,"Total Land & Machinery Debt ($/acre)",null,{"$f":"(D4*D8)+((I5+J5)*I9)","v":762}]
[null,"  Storage Financed",null,0.6,null,null,"Machinery Lease cost ($/acre)",null,{"$f":"D62","v":2.88}]
[]
["Conventional Crop Equipment Inventory and Current Values"]
[null,null,"Market","Grain","Grain",null,null,"Market","Grain","Grain"]
["Power & Misc Equipment",null,"Value","Usage %","Allocation",null,"Harvest Equipment","Value","Usage %","Allocation"]
[null,"4WD Tractor 475HP",250000,1,{"$f":"SUM(C25*D25)","v":250000},null,"Combine",260000,1,{"$f":"SUM(H25*I25)","v":260000}]
[null,"MFWD Tractor 150HP",100000,1,{"$f":"SUM(C26*D26)","v":100000},null,"Swather 35 ft",30000,1,{"$f":"SUM(H26*I26)","v":30000}]
[null,"2WD Tractor 60HP",30000,1,30000,null,"Harvest Header",50000,1,50000]
[null,"ATV Quad",5000,1,5000,null,"Tandem grain truck",60000,1,60000]
[null,null,0,0,0,null,"Grain cart",35000,1,35000]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E25:E31)","v":385000},null,"Total",null,null,{"$f":"SUM(J25:J31)","v":435000}]
[]
[null,null,"Market","Grain","Grain",null,null,"Market","Grain","Grain"]
["Seeding & Tillage",null,"Value","Usage %","Allocation",null,"Spraying & Misc.","Value","Usage %","Allocation"]
[null,"Cultivator",15000,1,{"$f":"SUM(C36*D36)","v":15000},null,"SP sprayer",175000,1,{"$f":"SUM(H36*I36)","v":175000}]
[null,"Harrow 80ft",27000,1,27000,null,"Miscellaneous",9000,1,9000]
[null,"Air tank",60000,1,60000,null,"PTO Auger 13x70",15000,1,15000]
[null,"Air drill ",125000,1,125000,null,"Auger 8x35",4000,1,4000]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,"Total",{"$f":"SUM(C36:C41)","v":227000},null,{"$f":"SUM(E36:E41)","v":227000},null,"Total",null,null,{"$f":"SUM(J36:J41)","v":203000}]
[]
[null,"Owned Equipment TOTAL",{"$f":"SUM(E32+J32+E42+J42)","v":1250000}]
[]
["Special Crop Equipment Inventory and Current Values"]
[null,null,"Market","Grain","Grain",null,null,"Market","Grain","Grain"]
["Seeding, Tillage, Spraying",null,"Value","Usage %","Allocation",null,"Harvest Equipment","Value","Usage %","Allocation"]
[null,"Planter",100000,1,{"$f":"SUM(C49*D49)","v":100000},null,"Harvest Header",50000,1,{"$f":"SUM(H49*I49)","v":50000}]
[null,null,0,0,{"$f":"SUM(C50*D50)","v":0},null,null,0,0,{"$f":"SUM(H50*I50)","v":0}]
[null,"Total",null,null,{"$f":"SUM(E49:E50)","v":100000},null,"Total",null,null,{"$f":"SUM(J49:J50)","v":50000}]
[null,"Special Equipment TOTAL",{"$f":"SUM(E51+J51)","v":150000}]
[]
["Leased Equipment Inventory"]
[null,null,"Annual","Grain","Grain",null,null,"Annual","Grain","Grain"]
["Seeding, Tillage, Spraying",null,"Lease","Usage %","Allocation",null,"Trucks & Trailers","Lease","Usage %","Allocation"]
[null,"enter equipment here",0,0,{"$f":"SUM(C57*D57)","v":0},null,"3/4 ton pickup",9600,0.75,{"$f":"SUM(H57*I57)","v":7200}]
[null,null,0,0,{"$f":"SUM(C58*D58)","v":0},null,null,0,0,{"$f":"SUM(H58*I58)","v":0}]
[null,null,0,0,{"$f":"SUM(C59*D59)","v":0},null,null,0,0,{"$f":"SUM(H59*I59)","v":0}]
[null,"Total",{"$f":"SUM(C57:C59)","v":0},null,{"$f":"SUM(E57:E59)","v":0},null,"Total",null,null,{"$f":"SUM(J57:J59)","v":7200}]
[]
[null,"Leased Equipment TOTAL",{"$f":"SUM(E60+J60)","v":7200},{"$f":"SUM(C62/(D5+D6))","v":2.88},"per acre"]
[null,"* Leased equipment costs are listed under Operating Costs on the Summary Page."]

{"sheet":"Assumptions","index":7,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[42,0,43,11],[4,0,5,11],[13,0,13,11],[0,0,0,11],[8,0,9,11],[18,0,19,11],[24,0,26,11]]}
["Other Assumptions"]
[]
["Fuel Costs:  Includes fuel used for field work, trucking in inputs and trucking out production."]
[]
["Machinery  Operating Costs:  Includes costs for maintenance, repairs, licenses and insurance, based on 3.2% of machinery investment cost."]
[]
[]
["Crop Insurance: (2021 rates) "]
[{"$f":"IF('Data (HIDE)'!B13=\"Manitoba\",'Data (HIDE)'!B14&\" coverage, $50/acre excess moisture Insurance, and additional hail insurance at $\"&'Data (HIDE)'!W13&\"/acre coverage for all crops.  Coverage and costs based on MASC Risk Areas #2, 5, 6, and 12.\",'Data (HIDE)'!B14&\" coverage, $50/acre excess moisture Insurance, and additional hail insurance at $\"&'Data (HIDE)'!W13&\"/acre coverage for all crops.  Coverage and costs based on MASC \"&'Data (HIDE)'!B13)","v":"80% Insured Value coverage, $50/acre excess moisture Insurance, and additional hail insurance at $300/acre coverage for all crops.  Coverage and costs based on MASC Risk Areas #2, 5, 6, and 12."}]
[]
[]
["Other Costs:  Includes overhead expenses - hydro, telephone, accounting, buildings, supplies and insurance, etc."]
[]
["Land Taxes:  The average cost based on land tax assessment and mill rates of a sample of municipalities growing crops less provincial tax rebate."]
[]
["Interest On Operating:",null,null,{"$f":"\"Interest charges on operating costs are calculated at \"&'Op. Cost Input'!D3*100&\"% for six months.\"","v":"Interest charges on operating costs are calculated at 5% for six months."}]
[]
["Land Cost:"]
[{"$f":"\"Based on approximate average land values.  Budget assumed \"&'Fixed Cost Input'!D8*100&\"% financed at \"&'Fixed Cost Input'!C11*100&\"% for \"&'Fixed Cost Input'!D11&\" years, plus \"&'Fixed Cost Input'!D9*100&\"% land equity opportunity cost. Budget can be used to estimate cashflow by removing investment cost.\"","v":"Based on approximate average land values.  Budget assumed 15% financed at 4.625% for 25 years, plus 1.5% land equity opportunity cost. Budget can be used to estimate cashflow by removing investment cost."}]
[]
[{"$f":"\"P&I Cost (based on \"&TEXT('Fixed Cost Input'!D4*('Fixed Cost Input'!D5+'Fixed Cost Input'!D6)*'Fixed Cost Input'!D8,\"$#,###\")&\" Mortgage) = $\"&TEXT('Fixed Cost Input'!D12*('Fixed Cost Input'!D5+'Fixed Cost Input'!D6),\"#,###\")&\" payments per year) / \"&'Fixed Cost Input'!D5+'Fixed Cost Input'!D6&\" acres = $\"&TEXT('Fixed Cost Input'!D12,\"0.00\")&\"/acre)\"","v":"P&I Cost (based on $1,275,000 Mortgage) = $87,094 payments per year) / 2500 acres = $34.84/acre)"}]
[{"$f":"\"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. (($\"&TEXT('Fixed Cost Input'!D4,\"#,###\")&\" x \"&'Fixed Cost Input'!D7*100&\"%) x \"&'Fixed Cost Input'!D9*100&\"%) = $\"&TEXT('Fixed Cost Input'!D13,\"0.00\")&\"/acre)\"","v":"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. (($3,400 x 85%) x 1.5%) = $43.35/acre)"}]
[]
["Machinery Cost: "]
[{"$f":"\"Based on approximate average machinery values.  Budget assumed \"&'Fixed Cost Input'!I9*100&\"% financed at \"&'Fixed Cost Input'!H13*100&\"% for \"&'Fixed Cost Input'!I13&\" years, depreciation costs over \"&'Fixed Cost Input'!I7&\" years with a \"&'Fixed Cost Input'!I6*100&\"% residual value, plus \"&'Fixed Cost Input'!I10*100&\"% machinery equity opportunity cost. Budget can be used to estimate cashflow by removing depreciation and investment cost. \"","v":"Based on approximate average machinery values.  Budget assumed 45% financed at 5% for 7 years, depreciation costs over 15 years with a 25% residual value, plus 1.5% machinery equity opportunity cost. Budget can be used to estimate cashflow by removing depreciation and investment cost. "}]
[]
[]
[{"$f":"\"P&I Cost (based on \"&TEXT('Fixed Cost Input'!C44*'Fixed Cost Input'!I9,\"$#,###\")&\" + \"&TEXT('Fixed Cost Input'!C52*'Fixed Cost Input'!I9,\"$#,###\")&\" Loans) = $\"&TEXT('Fixed Cost Input'!I14*('Fixed Cost Input'!D5+'Fixed Cost Input'!D6),\"#,###\")&\" + $\"&TEXT('Fixed Cost Input'!J14*('Fixed Cost Input'!D5+'Fixed Cost Input'!D6),\"#,###\")&\" payments per year) / \"&'Fixed Cost Input'!D5+'Fixed Cost Input'!D6&\" acres = $\"&TEXT('Fixed Cost Input'!I14,\"0.00\")&\" and $\"&TEXT('Fixed Cost Input'!J14,\"0.00\")&\"/acre)\"","v":"P&I Cost (based on $562,500 + $67,500 Loans) = $97,211 + $11,665 payments per year) / 2500 acres = $38.88 and $4.67/acre)"}]
[{"$f":"\"Depreciation (Useage Cost) = (Total Investment - Residual Value) / Years Useful Life  (eg. ($\"&TEXT('Fixed Cost Input'!I5,\"0.00\")&\" - ($\"&TEXT('Fixed Cost Input'!I5,\"0.00\")&\" x \"&'Fixed Cost Input'!I6*100&\"%)) / \"&'Fixed Cost Input'!I7&\" = $\"&TEXT('Fixed Cost Input'!I15,\"0.00\")&\"/acre)\"","v":"Depreciation (Useage Cost) = (Total Investment - Residual Value) / Years Useful Life  (eg. ($500.00 - ($500.00 x 25%)) / 15 = $25.00/acre)"}]
[{"$f":"\"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. ($\"&'Fixed Cost Input'!I5&\" x \"&'Fixed Cost Input'!I8*100&\"%) x \"&'Fixed Cost Input'!I10*100&\"%) = $\"&TEXT('Fixed Cost Input'!I16,\"0.00\")&\"/acre)\"","v":"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. ($500 x 55%) x 1.5%) = $4.13/acre)"}]
[]
["Depreciation Cost = Original Cost - Salvage Value"]
[{"$f":"\"                                                    Useful Life\"","v":"                                                    Useful Life"}]
["Investment Cost = Original Cost + Salvage Value x Investment Rate"]
[{"$f":"\"                                                        2\"","v":"                                                        2"}]
["Estimated Farmgate Values:"]
[" Target crop prices are based on deferred delivery contract prices for fall 2022."]
[" Target yields are estimated based on 5 year MASC average yields."]
[]
["Storage Cost:"]
["Storage costs for each crop are based on estimated yields entered on the Summary page. "]
[{"$f":"\"Budget assumed \"&'Fixed Cost Input'!D20*100&\"% financed at \"&'Fixed Cost Input'!C11*100&\"% for 20 years.\"","v":"Budget assumed 60% financed at 4.625% for 20 years."}]
[{"$f":"\"Farm storage requirements were assumed to cost $\"&TEXT('Fixed Cost Input'!D17,\"0.00\")&\"/bushel for \"&'Fixed Cost Input'!C17*100&\"% of the storage, $\"&TEXT('Fixed Cost Input'!D18,\"0.00\")&\"/bushel for \"&'Fixed Cost Input'!C18*100&\"% aerated storage and $\"&TEXT('Fixed Cost Input'!D19,\"0.00\")&\"/bushel for \"&'Fixed Cost Input'!C19*100&\"% hopper storage.\"","v":"Farm storage requirements were assumed to cost $2.50/bushel for 15% of the storage, $3.50/bushel for 70% aerated storage and $4.50/bushel for 15% hopper storage."}]
[]
[]
["Profitability, Breakeven & Risk Analysis Formulas:"]
[{"$f":"\"Gross Revenue = Price per unit x Yield per acre  (eg. kidney bean:  $\"&TEXT('Data (HIDE)'!E18,\"0.00\")&\"/lb x \"&'Data (HIDE)'!C18&\"lb/ac = $\"&TEXT('Data (HIDE)'!AL18, \"0.00\")&\"/ac)\"","v":"Gross Revenue = Price per unit x Yield per acre  (eg. kidney bean:  $0.49/lb x 1400lb/ac = $686.00/ac)"}]
[{"$f":"\"Net Profit = Gross Revenue - Total Cost     (eg. kidney bean: $\"&TEXT('Data (HIDE)'!AL18,\"0.00\")&\" gross revenue - $\"&TEXT('Data (HIDE)'!AI18,\"0.00\")&\" total cost = $\"&TEXT('Data (HIDE)'!AM18,\"0.00\")&\" per acre)\"","v":"Net Profit = Gross Revenue - Total Cost     (eg. kidney bean: $686.00 gross revenue - $800.09 total cost = $-114.09 per acre)"}]
[{"$f":"\"Operating Expense Ratio = (Operating Cost / Gross Revenue) x 100    (eg. kidney bean: $\"&TEXT('Data (HIDE)'!AC18,\"0.00\")&\" operating expense / $\"&ROUND('Data (HIDE)'!AL18,2)&\" revenue = \"&TEXT('Data (HIDE)'!AN18*100,\"0.0\")&\"%)\"","v":"Operating Expense Ratio = (Operating Cost / Gross Revenue) x 100    (eg. kidney bean: $620.74 operating expense / $686 revenue = 90.5%)"}]
[{"$f":"\"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost (eg. kidney bean: ($\"&TEXT('Data (HIDE)'!AL18,\"0.00\")&\" - $\"&TEXT('Data (HIDE)'!AI18,\"0.00\")&\") / $\"&TEXT('Data (HIDE)'!AI18,\"0.00\")&\" = \"&TEXT('Data (HIDE)'!AT18*100,\"0.0\")&\"%)\"","v":"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost (eg. kidney bean: ($686.00 - $800.09) / $800.09 = -14.3%)"}]
["Estimated Return on Asset (ROA) = (Margin Over Operating - Labour - Machinery Depreciation) / (Land Investment Cost + Machinery Investment Cost) "]
[{"$f":"\"   (eg. kidney bean: ($\"&TEXT('Data (HIDE)'!AL18-'Data (HIDE)'!AC18,\"0.00\")&\" margin - $\"&TEXT('Data (HIDE)'!AH18,\"0.00\")&\" labour - $\"&TEXT(('Fixed Cost Input'!$I$15+'Fixed Cost Input'!$J$15),\"0.00\")&\" dep.) / ($\"&'Fixed Cost Input'!D4&\" land cost + $\"&TEXT('Fixed Cost Input'!I5,\"0.00\")&\" conv. machinery + $\"&TEXT('Fixed Cost Input'!J5,\"0.00\")&\" special crop. mach.) = \"&TEXT('Data (HIDE)'!AS18*100,\".00\")&\"%) \"","v":"   (eg. kidney bean: ($65.26 margin - $25.00 labour - $28.00 dep.) / ($3400 land cost + $500.00 conv. machinery + $60.00 special crop. mach.) = .31%) "}]
[{"$f":"\"Breakeven Price = Cost / Target Yield  (eg. kidney bean cost $\"&TEXT('Data (HIDE)'!AI18,\"0.00\")&\"  / \"&'Data (HIDE)'!C18&\" lb = $\"&TEXT('Data (HIDE)'!AO18,\"0.00\")&\" per lb)\"","v":"Breakeven Price = Cost / Target Yield  (eg. kidney bean cost $800.09  / 1400 lb = $0.57 per lb)"}]
[{"$f":"\"Breakeven Yield = Cost / Target Price per Unit  (eg. kidney bean cost $\"&TEXT('Data (HIDE)'!AI18,\"0.00\")&\"  / $\"&TEXT('Data (HIDE)'!E18,\"0.00\")&\" lb = \"&TEXT('Data (HIDE)'!AP18,\"0.0\")&\"  lb)\"","v":"Breakeven Yield = Cost / Target Price per Unit  (eg. kidney bean cost $800.09  / $0.49 lb = 1632.8  lb)"}]
[{"$f":"\"Breakeven Yield Risk Ratio = (Yield per Acre / Breakeven Yield) x 100  (eg. kidney bean yield \"&'Data (HIDE)'!C18&\"  lb/ac / \"&TEXT('Data (HIDE)'!AP18,\"0.0\")&\" lb BE = \"&ROUND('Data (HIDE)'!AQ18*100,0)&\" %)\"","v":"Breakeven Yield Risk Ratio = (Yield per Acre / Breakeven Yield) x 100  (eg. kidney bean yield 1400  lb/ac / 1632.8 lb BE = 86 %)"}]
[{"$f":"\"AgriInsurance Risk Ratio = (AgriInsurance Coverage / Operating Cost) x 100  (eg. kidney bean coverage $\"&TEXT('Data (HIDE)'!AJ18,\"0.00\")&\"/ac / $\"&TEXT('Data (HIDE)'!AC18,\"0.00\")&\" operating expense  = \"&ROUND('Data (HIDE)'!AR18*100,0)&\" %)\"","v":"AgriInsurance Risk Ratio = (AgriInsurance Coverage / Operating Cost) x 100  (eg. kidney bean coverage $610.00/ac / $620.74 operating expense  = 98 %)"}]
[]
["Created and maintained by ",null,null,null,null,null,null,null,null,null,null,{"$f":"\"January, \"&Introduction!I11","v":"January, 2022"}]
["For more information, contact your nearest"]
["Darren Bond",null,null,null,"Roy Arnott",null,null,null,"Sharon Ardron"]
["Farm Management Specialist         ",null,null,null,"Farm Management Specialist         ",null,null,null,"Farm Management Specialist         "]

{"sheet":"Chart data (HIDE)","index":8,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"'Data (HIDE)'!B13&\" Breakeven Yield Risk Ratio - \"&Introduction!I11","v":"Manitoba Breakeven Yield Risk Ratio - 2022"}]
[{"$f":"'Data (HIDE)'!B13&\" Risk & Reward Analysis - \"&Introduction!I11","v":"Manitoba Risk & Reward Analysis - 2022"},null,null,null,"80% Coverage of Total Costs"]
[{"$f":"'Data (HIDE)'!B13&\" - \"&'Data (HIDE)'!B14&\" AgriInsurance Risk Analysis - \"&Introduction!I11","v":"Manitoba - 80% Insured Value AgriInsurance Risk Analysis - 2022"}]
[null,"Operating Costs",{"$f":"'Data (HIDE)'!B14","v":"80% Insured Value"},"80% Coverage of Operating Costs","80% Coverage of Total Costs (Risk)","Return on Asset (Reward)","Return on Investment (Reward)",null,null,null,null,"Target Yield as % of B/E Yield"]
[{"$f":"'Data (HIDE)'!B16","v":"Black Bean"},{"$f":"'Data (HIDE)'!AC16","v":470.03360408060621},{"$f":"'Data (HIDE)'!AJ16","v":520},{"$f":"'Data (HIDE)'!AV16","v":1.1063038801600769},{"$f":"'Data (HIDE)'!AW16","v":0.80074901776666174},{"$f":"'Data (HIDE)'!AS16","v":6.1102625232170152E-2},{"$f":"'Data (HIDE)'!AT16","v":0.17802499729133892},null,null,null,null,{"$f":"'Data (HIDE)'!AX16","v":1.1780195412653316}]
[{"$f":"'Data (HIDE)'!B17","v":"Hempseed"},{"$f":"'Data (HIDE)'!AC17","v":364.32679561013634},{"$f":"'Data (HIDE)'!AJ17","v":460},{"$f":"'Data (HIDE)'!AV17","v":1.2626027114740221},{"$f":"'Data (HIDE)'!AW17","v":0.85897169523555239},{"$f":"'Data (HIDE)'!AS17","v":6.5826566765117084E-2},{"$f":"'Data (HIDE)'!AT17","v":0.26044759626956049},null,null,null,null,{"$f":"'Data (HIDE)'!AX17","v":1.2605042016806722}]
[{"$f":"'Data (HIDE)'!B18","v":"Kidney Bean"},{"$f":"'Data (HIDE)'!AC18","v":620.73632650308264},{"$f":"'Data (HIDE)'!AJ18","v":610},{"$f":"'Data (HIDE)'!AV18","v":0.98270388561989641},{"$f":"'Data (HIDE)'!AW18","v":0.76240973569275017},{"$f":"'Data (HIDE)'!AS18","v":3.096887246696304E-3},{"$f":"'Data (HIDE)'!AT18","v":-0.14260151035208748},null,null,null,null,{"$f":"'Data (HIDE)'!AX18","v":0.85742283194512492}]
[{"$f":"'Data (HIDE)'!B19","v":"Fababean"},{"$f":"'Data (HIDE)'!AC19","v":255.95733976481708},{"$f":"'Data (HIDE)'!AJ19","v":200},{"$f":"'Data (HIDE)'!AV19","v":0.78138021040446537},{"$f":"'Data (HIDE)'!AW19","v":0.46821456053374361},{"$f":"'Data (HIDE)'!AS19","v":3.8899661675551242E-2},{"$f":"'Data (HIDE)'!AT19","v":7.6893489227610329E-2},null,null,null,null,{"$f":"'Data (HIDE)'!AX19","v":1.0768798576645753}]
[{"$f":"'Data (HIDE)'!B20","v":"Buckwheat"},{"$f":"'Data (HIDE)'!AC20","v":221.290535353059},{"$f":"'Data (HIDE)'!AJ20","v":180},{"$f":"'Data (HIDE)'!AV20","v":0.81341029661669972},{"$f":"'Data (HIDE)'!AW20","v":0.45861299452924481},{"$f":"'Data (HIDE)'!AS20","v":-2.2198321598633835E-3},{"$f":"'Data (HIDE)'!AT20","v":-0.33118938297818462},null,null,null,null,{"$f":"'Data (HIDE)'!AX20","v":0.66964285714285721}]
[{"$f":"'Data (HIDE)'!B21","v":"Canaryseed"},{"$f":"'Data (HIDE)'!AC21","v":282.31722646682999},{"$f":"'Data (HIDE)'!AJ21","v":420},{"$f":"'Data (HIDE)'!AV21","v":1.4876881770774502},{"$f":"'Data (HIDE)'!AW21","v":0.9261005301484122},{"$f":"'Data (HIDE)'!AS21","v":5.3076457962921722E-2},{"$f":"'Data (HIDE)'!AT21","v":0.1962131847750325},null,null,null,null,{"$f":"'Data (HIDE)'!AX21","v":1.1961722488038278}]
[{"$f":"'Data (HIDE)'!B22","v":"Lentil"},{"$f":"'Data (HIDE)'!AC22","v":246.67866128466213},{"$f":"'Data (HIDE)'!AJ22","v":250},{"$f":"'Data (HIDE)'!AV22","v":1.0134642319608875},{"$f":"'Data (HIDE)'!AW22","v":0.59826372223496438},{"$f":"'Data (HIDE)'!AS22","v":4.4399327958418652E-2},{"$f":"'Data (HIDE)'!AT22","v":0.13071843502408262},null,null,null,null,{"$f":"'Data (HIDE)'!AX22","v":1.1307669112473615}]

{"sheet":"Data (HIDE)","index":9,"n_rows":110,"n_cols":67,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
[null,"Annual Update Steps:",null,null,null,null,null,null,null,null,null,"To Do List:"]
[null,"copy & paste 'Green' data blocks below from annual MASC cost and coverage information spreadsheet."]
[null,"enter COP yields into 'yellow' data block below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V14&\" Yield per Acre - \"&Introduction!I11","v":"Manitoba Yield per Acre - 2022"}]
[null,"enter MASC insured values & COP yields into 'yellow' data blocks below"]
[null,"enter MASC SAR acres into data block below and change formula for 5 year average."]
[null,"select yellow rows and sort"]
[]
[]
[]
[]
[null,"*****Re-sort Yellow rows based on column I for 5yr Avg Ac Ranking or column K for 2018 Ranking ******   *****SUMMARY will AUTO update!! ******",null,null,null,null,null,null,null,null,null,null,null,null,"****sort on column F to reset to original listing ****"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hail Ins. coverage / acre "]
[null,"Manitoba",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300]
[null,"80% Insured Value",null,null,"**Change Mkt Prices Here***",null,null,null,null,"**Change yr for Risk pg***",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":"Manitoba"},{"$f":"B13","v":"Manitoba"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V14","v":"Manitoba"},null,null,null,null,null,null,null,null,null,null,null,"AgriInsurance Insured Value"]
[null,null,"Yield","Unit","Price","Default RANK","Manual Rank","5 yr Avg Acres","5 yr Avg Acres RANK","2021 Acres","2020 Acres RANK","Seed & Treatment","Fertilizer","Herbicide","Fungicide","Insecticide","Fuel","Machinery Operating","Machinery Lease","Rental and Custom","Labour","Crop Insurance","Hail Insurance","Other Costs","Land Taxes","Storage Costs","Drying Costs","Interest on Operating","Total Operating","Land Investment Costs","Machinery Costs","Total Fixed ","Total Operating & Fixed","Labour","Total Costs","Insured value","% Premium","Gross Revenue","Margin Over Total Costs (Net Profit)","Operating Expense Ratio","B/E Price Over Total Costs","Breakeven Yield Over Total Costs","B/E Yield Risk Ratio","AgriInsurance Risk Ratio","Estimated ROA (Reward)","Estimated ROI (Reward)",null,"% of Op Cost","% of Total Costs","Target or Average Yield as % of B/E Yield"]
[null,"Black Bean",{"$f":"HLOOKUP($B$13,$C$46:$G$53,3,FALSE)","v":1700},"lb",0.45,2,1,{"$f":"$C$38","v":25222.6},{"$f":"RANK(H16,$H$16:$H$22)","v":1},{"$f":"$D38","v":27846},{"$f":"RANK(J16,$J$16:$J$22)","v":1},{"$f":"'Seed, Fertilizer & Chemical'!J5","v":96.25},{"$f":"'Seed, Fertilizer & Chemical'!O27","v":103.13153114130613},{"$f":"'Seed, Fertilizer & Chemical'!D46","v":77.02},{"$f":"'Seed, Fertilizer & Chemical'!F46","v":40.5},{"$f":"'Seed, Fertilizer & Chemical'!G46","v":0},{"$f":"'Op. Cost Input'!D14","v":23.880764421052632},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N14","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C13","v":5},{"$f":"'Op. Cost Input'!E14","v":33.5},{"$f":"'Op. Cost Input'!F14","v":16.537499999999998},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H14","v":4.6238085182474471},{"$f":"IF('Op. Cost Input'!G14=\"-\",0,'Op. Cost Input'!G14)","v":0},{"$f":"ROUND(SUM(L16:AA16)/2*('Op. Cost Input'!$D$3),2)","v":11.46},{"$f":"SUM(L16:AB16)","v":470.03360408060621},{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17+'Fixed Cost Input'!$J$17","v":76.170594248435023},{"$f":"SUM(AD16:AE16)","v":154.35838824466947},{"$f":"SUM(AF16+AC16)","v":624.39199232527562},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},{"$f":"SUM(AG16+AH16)","v":649.39199232527562},{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,3,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,3,FALSE),HLOOKUP($V$14,#REF!,3,FALSE)))","v":520},{"$f":"SUM(V16/AJ16)","v":6.4423076923076916E-2},{"$f":"SUM(C16*E16)","v":765},{"$f":"SUM(AL16-AI16)","v":115.60800767472438},{"$f":"SUM(AC16/AL16)","v":0.61442301187007353},{"$f":"SUM(AI16/C16)","v":0.38199528960310331},{"$f":"ROUND(AI16/E16,1)","v":1443.1},{"$f":"SUM(C16/AP16)","v":1.1780195412653316},{"$f":"SUM(AJ16/AC16)","v":1.1063038801600769},{"$f":"SUM((AL16-AC16-AH16-('Fixed Cost Input'!$I$15+'Fixed Cost Input'!$J$15))/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":6.1102625232170152E-2},{"$f":"AM16/AI16","v":0.17802499729133892},null,{"$f":"SUM(AJ16/AC16)","v":1.1063038801600769},{"$f":"SUM(AJ16/AI16)","v":0.80074901776666174},{"$f":"C16/AP16","v":1.1780195412653316},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16*E16)","v":765}]
[null,"Hempseed",{"$f":"HLOOKUP($B$13,$C$46:$G$53,2,FALSE)","v":750},"lb",0.9,1,2,{"$f":"$C$37","v":12974},2,{"$f":"$D$37","v":6131},4,{"$f":"'Seed, Fertilizer & Chemical'!J4","v":58.75},{"$f":"'Seed, Fertilizer & Chemical'!O26","v":103.13153114130613},{"$f":"'Seed, Fertilizer & Chemical'!D45","v":47.54},{"$f":"'Seed, Fertilizer & Chemical'!F45","v":0},{"$f":"'Seed, Fertilizer & Chemical'!G45","v":0},{"$f":"'Op. Cost Input'!D13","v":24.453561483253587},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N13","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C14","v":5},{"$f":"'Op. Cost Input'!E13","v":36.75},{"$f":"'Op. Cost Input'!F13","v":18.899999999999999},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H13","v":2.7817029855766728},{"$f":"IF('Op. Cost Input'!G13=\"-\",0,'Op. Cost Input'!G13)","v":0},{"$f":"ROUND(SUM(L17:AA17)/2*('Op. Cost Input'!$D$3),2)","v":8.89},364.32679561013634,{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17","v":68.009459150388409},146.19725314662284,510.52404875675916,{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},535.52404875675916,{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,2,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,2,FALSE),HLOOKUP($V$14,#REF!,2,FALSE)))","v":460},7.9891304347826084E-2,675,139.47595124324084,0.53974340090390571,0.71403206500901217,595,1.2605042016806722,1.2626027114740221,{"$f":"SUM((AL17-AC17-AH17-'Fixed Cost Input'!$I$15)/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":6.5826566765117084E-2},0.26044759626956049,null,1.2626027114740221,0.85897169523555239,1.2605042016806722,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,675]
[null,"Kidney Bean",{"$f":"HLOOKUP($B$13,$C$46:$G$53,4,FALSE)","v":1400},"lb",0.49,3,3,{"$f":"$C$39","v":10570.2},3,{"$f":"$D$39","v":9454},2,{"$f":"'Seed, Fertilizer & Chemical'!J6","v":229.9},{"$f":"'Seed, Fertilizer & Chemical'!O28","v":103.13153114130613},{"$f":"'Seed, Fertilizer & Chemical'!D47","v":77.02},{"$f":"'Seed, Fertilizer & Chemical'!F47","v":40.5},{"$f":"'Seed, Fertilizer & Chemical'!G47","v":0},{"$f":"'Op. Cost Input'!D15","v":23.319453052631577},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N15","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C15","v":5},{"$f":"'Op. Cost Input'!E15","v":48.25},{"$f":"'Op. Cost Input'!F15","v":16.537499999999998},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H15","v":3.8078423091449567},{"$f":"IF('Op. Cost Input'!G15=\"-\",0,'Op. Cost Input'!G15)","v":0},{"$f":"ROUND(SUM(L18:AA18)/2*('Op. Cost Input'!$D$3),2)","v":15.14},620.73632650308264,{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17+'Fixed Cost Input'!$J$17","v":76.170594248435023},154.35838824466947,775.09471474775205,{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},800.09471474775205,{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,4,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,4,FALSE),HLOOKUP($V$14,#REF!,5,FALSE)))","v":610},7.9098360655737707E-2,686,-114.09471474775205,0.90486344971294841,0.57149622481982287,1632.8,0.85742283194512492,0.98270388561989641,{"$f":"SUM((AL18-AC18-AH18-('Fixed Cost Input'!$I$15+'Fixed Cost Input'!$J$15))/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":3.096887246696304E-3},-0.14260151035208748,null,0.98270388561989641,0.76240973569275017,0.85742283194512492,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,686]
[null,"Fababean",{"$f":"HLOOKUP($B$13,$C$46:$G$53,7,FALSE)","v":2300},"lb",0.2,6,4,{"$f":"$C$42","v":6828.4},4,{"$f":"$D$42","v":5206},5,{"$f":"'Seed, Fertilizer & Chemical'!J9","v":39.6},{"$f":"'Seed, Fertilizer & Chemical'!O31","v":49.815711670469909},{"$f":"'Seed, Fertilizer & Chemical'!D50","v":15.5},{"$f":"'Seed, Fertilizer & Chemical'!F50","v":0},{"$f":"'Seed, Fertilizer & Chemical'!G50","v":0},{"$f":"'Op. Cost Input'!D18","v":22.128387157894736},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N18","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C16","v":5},{"$f":"'Op. Cost Input'!E18","v":36.75},{"$f":"'Op. Cost Input'!F18","v":16.537499999999998},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H18","v":6.2557409364524288},{"$f":"IF('Op. Cost Input'!G18=\"-\",0,'Op. Cost Input'!G18)","v":0},{"$f":"ROUND(SUM(L19:AA19)/2*('Op. Cost Input'!$D$3),2)","v":6.24},255.95733976481708,{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17","v":68.009459150388409},146.19725314662284,402.15459291143992,{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},427.15459291143992,{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,7,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,7,FALSE),HLOOKUP($V$14,#REF!,7,FALSE)))","v":200},0.18375,460,32.84540708856008,0.55642899948873281,0.18571938822236519,2135.8000000000002,1.0768798576645753,0.78138021040446537,{"$f":"SUM((AL19-AC19-AH19-'Fixed Cost Input'!$I$15)/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":3.8899661675551242E-2},7.6893489227610329E-2,null,0.78138021040446537,0.46821456053374361,1.0768798576645753,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,460]
[null,"Buckwheat",{"$f":"HLOOKUP($B$13,$C$46:$G$53,5,FALSE)","v":15},"bu",17.5,4,5,{"$f":"$C$40","v":5471.2},5,{"$f":"$D$40","v":4416},6,{"$f":"'Seed, Fertilizer & Chemical'!J7","v":25},{"$f":"'Seed, Fertilizer & Chemical'!O29","v":55.553702620488359},{"$f":"'Seed, Fertilizer & Chemical'!D48","v":6.13},{"$f":"'Seed, Fertilizer & Chemical'!F48","v":0},{"$f":"'Seed, Fertilizer & Chemical'!G48","v":0},{"$f":"'Op. Cost Input'!D16","v":21.003934105263156},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N16","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C17","v":5},{"$f":"'Op. Cost Input'!E16","v":19},{"$f":"'Op. Cost Input'!F16","v":23.625},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H16","v":2.4478986273074721},{"$f":"IF('Op. Cost Input'!G16=\"-\",0,'Op. Cost Input'!G16)","v":0},{"$f":"ROUND(SUM(L20:AA20)/2*('Op. Cost Input'!$D$3),2)","v":5.4},221.290535353059,{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17","v":68.009459150388409},146.19725314662284,367.48778849968187,{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},392.48778849968187,{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,5,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,5,FALSE),HLOOKUP($V$14,#REF!,5,FALSE)))","v":180},0.10555555555555556,262.5,-129.98778849968187,0.84301156324974857,26.165852566645459,22.4,0.66964285714285721,0.81341029661669972,{"$f":"SUM((AL20-AC20-AH20-'Fixed Cost Input'!$I$15)/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":-2.2198321598633835E-3},-0.33118938297818462,null,0.81341029661669972,0.45861299452924481,0.66964285714285721,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,262.5]
[null,"Canaryseed",{"$f":"HLOOKUP($B$13,$C$46:$G$53,6,FALSE)","v":1550},"lb",0.35,5,6,{"$f":"$C$41","v":4227.8},6,{"$f":"$D$41","v":6979},3,{"$f":"'Seed, Fertilizer & Chemical'!J8","v":33},{"$f":"'Seed, Fertilizer & Chemical'!O30","v":89.243105486184035},{"$f":"'Seed, Fertilizer & Chemical'!D49","v":14.42},{"$f":"'Seed, Fertilizer & Chemical'!F49","v":13.75},{"$f":"'Seed, Fertilizer & Chemical'!G49","v":0},{"$f":"'Op. Cost Input'!D17","v":23.375130484210526},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N17","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C18","v":5},{"$f":"'Op. Cost Input'!E17","v":24},{"$f":"'Op. Cost Input'!F17","v":9.4499999999999993},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H17","v":5.0589904964354435},{"$f":"IF('Op. Cost Input'!G17=\"-\",0,'Op. Cost Input'!G17)","v":0},{"$f":"ROUND(SUM(L21:AA21)/2*('Op. Cost Input'!$D$3),2)","v":6.89},282.31722646682999,{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17","v":68.009459150388409},146.19725314662284,428.51447961345286,{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},453.51447961345286,{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,6,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,6,FALSE),HLOOKUP($V$14,#REF!,6,FALSE)))","v":420},5.7142857142857141E-2,542.5,88.985520386547137,0.52040041745037791,0.29258998684738896,1295.8,1.1961722488038278,1.4876881770774502,{"$f":"SUM((AL21-AC21-AH21-'Fixed Cost Input'!$I$15)/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":5.3076457962921722E-2},0.1962131847750325,null,1.4876881770774502,0.9261005301484122,1.1961722488038278,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,542.5]
[null,"Lentil",{"$f":"HLOOKUP($B$13,$C$46:$G$53,8,FALSE)","v":1125},"lb",0.42,7,7,{"$f":"$C$43","v":1899.8},7,{"$f":"$D$43","v":1070},7,{"$f":"'Seed, Fertilizer & Chemical'!J10","v":70},{"$f":"'Seed, Fertilizer & Chemical'!O32","v":25.62387036894884},{"$f":"'Seed, Fertilizer & Chemical'!D51","v":15.5},{"$f":"'Seed, Fertilizer & Chemical'!F51","v":13.88},{"$f":"'Seed, Fertilizer & Chemical'!G51","v":0},{"$f":"'Op. Cost Input'!D19","v":19.929917631578945},{"$f":"'Op. Cost Input'!$D$6","v":20},{"$f":"'Fixed Cost Input'!$I$20","v":2.88},{"$f":"'Op. Cost Input'!N19","v":0},{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$C19","v":5},{"$f":"'Op. Cost Input'!E19","v":17.25},{"$f":"'Op. Cost Input'!F19","v":12.285},{"$f":"'Op. Cost Input'!$D$7","v":17.75},{"$f":"'Op. Cost Input'!$D$4","v":17.5},{"$f":"'Op. Cost Input'!H19","v":3.0598732841343401},{"$f":"IF('Op. Cost Input'!G19=\"-\",0,'Op. Cost Input'!G19)","v":0},{"$f":"ROUND(SUM(L22:AA22)/2*('Op. Cost Input'!$D$3),2)","v":6.02},246.67866128466213,{"$f":"'Fixed Cost Input'!$D$14","v":78.187793996234433},{"$f":"'Fixed Cost Input'!$I$17","v":68.009459150388409},146.19725314662284,392.87591443128497,{"$f":"'Op. Cost Input'!$D$5*'Op. Cost Input'!$D$9","v":25},417.87591443128497,{"$f":"IF($B$14=\"80% Insured Value\",HLOOKUP($V$14,$D$57:$H$64,8,FALSE),IF($B$14=\"70% Insured Value\",HLOOKUP($V$14,#REF!,8,FALSE),HLOOKUP($V$14,#REF!,8,FALSE)))","v":250},6.9000000000000006E-2,472.5,54.624085568715032,0.52207124081409972,0.3714452572722533,994.9,1.1307669112473615,1.0134642319608875,{"$f":"SUM((AL22-AC22-AH22-'Fixed Cost Input'!$I$15)/(('Fixed Cost Input'!$D$4)+'Fixed Cost Input'!$I$5+'Fixed Cost Input'!$J$5))","v":4.4399327958418652E-2},0.13071843502408262,null,1.0134642319608875,0.59826372223496438,1.1307669112473615,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,472.5]
[]
[]
[null,"MASC Seeded Acreage SAR - Market Variety Share Report"]
[null,null,"5yr",2021,2020,2019,2018,2017,2016,2015,2014,2013,2012,null,null,null,null,null,"$/MT","unit","$/unit"]
[null,"Hempseed",{"$f":"AVERAGE(D27:H27)","v":12974},6131,11308,10009,10126,27296,14491,21220,17453,11297,14403,null,null,null,null,"Hempseed",1653,2204.62,{"$f":"SUM(S27/T27)","v":0.74978907929711247}]
[null,"Black Bean",{"$f":"AVERAGE(D28:H28)","v":25222.6},27846,20940,27308,27610,22409,17512,20302,14921,9535,14498,null,null,null,null,"Black Bean",725,2204.62,0.3288548593408388]
[null,"Kidney Bean",10570.2,9454,{"$f":"12402","v":12402},12358,10501,8136,11906,16604,17210,8734,9319,null,null,null,null,"Kidney Bean",925,2204.62,0.41957344122796675]
[null,"Buckwheat",5471.2,{"$f":"4416","v":4416},5681,6766,4848,5645,11083,8921,2599,5094,11535,null,null,null,null,"Buckwheat",645,50,12.9]
[null,"Canaryseed",4227.8,6979,5120,3179,1578,4283,7635,9449,2009,6422,12135,null,null,null,null,"Canaryseed",475,2204.62,0.21545663198192888]
[null,"Fababean",6828.4,5206,6679,8052,5826,8379,9596,9040,3468,2377,3463,null,null,null,null,"Fababean",185,2204.62,8.3914688245593352E-2]
[null,"Lentil",1899.8,1070,2522,1542,1684,2681,9957,1707,0,533,877,null,null,null,null,"Lentil",400,2204.62,0.18143716377425589]
[]
[null,"MASC Seeded Acreage (for COP)"]
[null,null,"5yr",2021,2020,2019,2018,2017,2016,2015,2014,2013,2012]
[null,"Hempseed",{"$f":"AVERAGE(D37:H37)","v":12974},{"$f":"D27","v":6131},11308,10009,10126,27296,14491,21220,17453,11297,14403]
[null,"Black Bean",{"$f":"AVERAGE(D38:H38)","v":25222.6},{"$f":"D28","v":27846},20940,27308,27610,22409,17512,20302,14921,9535,14498]
[null,"Kidney Bean",10570.2,{"$f":"D29","v":9454},12402,12358,10501,8136,11906,16604,17210,8734,9319]
[null,"Buckwheat",5471.2,{"$f":"D30","v":4416},5681,6766,4848,5645,11083,8921,2599,5094,11535]
[null,"Canaryseed",4227.8,{"$f":"D31","v":6979},5120,3179,1578,4283,7635,9449,2009,6422,12135]
[null,"Fababean",6828.4,{"$f":"D32","v":5206},6679,8052,5826,8379,9596,9040,3468,2377,3463]
[null,"Lentil",1899.8,{"$f":"D33","v":1070},2522,1542,1684,2681,9957,1707,0,{"$f":"L33","v":533},{"$f":"M33","v":877}]
[]
[null,"2021 MASC data","COP"]
[null,"Expected Yield 'D'","Manitoba","RA#2","RA#5","RA#6","RA#12","Avg.",null,null,null,null,null,"80% Insured Value"]
[null,"Hempseed",750,688,688,688,688,688,null,null,null,null,null,"70% Insured Value"]
[null,"Black Bean",1700,1673,1673,1338,1673,1589.25,null,null,null,null,null,"50% Insured Value"]
[null,"Kidney Bean",1400,1495,1495,1195,1495,1420]
[null,"Buckwheat",15,13.4,13.4,13.4,13.4,13.4]
[null,"Canaryseed",1550,1565,1565,1565,1565,1565]
[null,"Fababean",2300,2054,2054,2054,2054,2054]
[null,"Lentil",1125,1105,1105,1105,1105,1105]
[]
[null,null,"**Mkt Prices are Changed E16 to E22 above***"]
[null,"80% Insured Value",2021,"Avg 2,5,6,12"]
[null,null,"ins.$/bu","Manitoba","RA#2","RA#5","RA#6","RA#12"]
[null,"Hempseed",0.69,460,379.77600000000001,379.77600000000001,379.77600000000001,379.77600000000001,null,null,379.77600000000001,1.2,{"$f":"ROUND(K58*L58,-1)","v":460}]
[null,"Black Bean",0.35,520,455.05600000000004,455.05600000000004,363.93600000000004,455.05600000000004,null,null,432.27600000000007,1.2,{"$f":"ROUND(K59*L59,-1)","v":520}]
[null,"Kidney Bean",0.45,610,538.20000000000005,538.20000000000005,430.20000000000005,538.20000000000005,null,null,511.20000000000005,1.2,610]
[null,"Buckwheat",14.04,180,150.50880000000001,150.50880000000001,150.50880000000001,150.50880000000001,null,null,150.50880000000001,1.2,180]
[null,"Canaryseed",0.28000000000000003,420,350.56000000000006,350.56000000000006,350.56000000000006,350.56000000000006,null,null,350.56000000000006,1.2,420]
[null,"Fababean",0.1,200,164.32000000000002,164.32000000000002,164.32000000000002,164.32000000000002,null,null,164.32000000000002,1.2,200]
[null,"Lentil",0.4,250,212.16,212.16,212.16,212.16,null,null,212.16,1.2,250]
[]
[]
[null,null,"Avg 2,5,6,12"]
[null,"80% Crop","Manitoba","RA#2","RA#5","RA#6","RA#12","Avg."]
[null,"Hempseed",36.122999999999998,30.06,30.24,30.66,29.45,30.102499999999999,null,null,30.102499999999999,1.2,{"$f":"K69*L69","v":36.122999999999998}]
[null,"Black Bean",32.931000000000004,27.39,27.57,27.99,26.82,27.442500000000003,null,null,27.442500000000003,1.2,{"$f":"K70*L70","v":32.931000000000004}]
[null,"Kidney Bean",47.591999999999992,39.479999999999997,39.92,40.4,38.840000000000003,39.660000000000004,null,null,39.659999999999997,1.2,47.591999999999992]
[null,"Buckwheat",18.576000000000001,15.41,15.58,15.76,15.17,15.48,null,null,15.48,1.2,18.576000000000001]
[null,"Canaryseed",23.456999999999997,19.45,19.72,19.850000000000001,19.170000000000002,19.547499999999999,null,null,19.547499999999999,1.2,23.456999999999997]
[null,"Fababean",36.122999999999998,30.06,30.24,30.66,29.45,30.102499999999999,null,null,30.102499999999999,1.2,36.122999999999998]
[null,"Lentil",16.631999999999998,10.43,15.01,15.3,14.7,13.86,null,null,13.86,1.2,16.631999999999998]
[]
[null,"Base EMI premium / acre ($50)",null,0.54,null,200]
[null,null,null,null,null,250]
[null,"Hail Ins. coverage / acre ",null,null,null,300]
[]
[null,null,"Rate","Avg 2,5,6,12","Cost per Acre"]
[null,"HAIL Ins. Costs","Factor","Manitoba","RA#2","RA#5","RA#6","RA#12"]
[null,{"$f":"W13","v":300},null,null,3.3,3.8,3,2.5]
[null,"Hempseed",2,{"$f":"AVERAGE(E84,F84,G84,H84)","v":18.899999999999999},{"$f":"(($E$83*$C84)/100)*$W$13","v":19.8},{"$f":"(($F$83*$C84)/100)*$W$13","v":22.8},{"$f":"(($G$83*$C84)/100)*$W$13","v":18},{"$f":"(($H$83*$C84)/100)*$W$13","v":15}]
[null,"Black Bean",1.75,16.537499999999998,{"$f":"(($E$83*$C85)/100)*$W$13","v":17.324999999999999},19.949999999999996,15.75,13.125]
[null,"Kidney Bean",1.75,16.537499999999998,17.324999999999999,19.949999999999996,15.75,13.125]
[null,"Buckwheat",2.5,23.625,24.75,28.5,22.5,18.75]
[null,"Canaryseed",1,9.4499999999999993,9.9,11.4,9,7.5]
[null,"Fababean",1.75,16.537499999999998,17.324999999999999,19.949999999999996,15.75,13.125]
[null,"Lentil",1.3,12.285,12.870000000000001,14.819999999999999,11.700000000000003,9.75]
[]
[]
[null,"Data Source – MASC Harvest Production Reports (2010-2015)"]
[null,null,null,"Crop planted"]
[null,"Stubble ",null,"Wheat - Hard Red Spring","Wheat - Northern Hard Red","Wheat - Special Purpose","Wheat - Prairie Spring","Wheat - Winter","Oats","Barley","Canola","Flaxseed","Peas","Soybeans","Beans - White","Sunflower Oil","Sunflower Confection","Corn"]
[null,"Wheat - Hard Red Spring",2,85,85,85,85,84,98,96,102,105,103,101,106,101,101,98]
[null,"Wheat - Northern Hard Red",3,85,85,85,85,84,98,96,102,105,103,101,106,101,101,98]
[null,"Wheat - Special Purpose",4,85,85,85,85,84,98,96,102,105,103,101,106,101,101,98]
[null,"Wheat - Prairie Spring",5,85,85,85,85,84,98,96,102,105,103,101,106,101,101,98]
[null,"Wheat - Winter",6,75,75,75,75,83,97,105,98,94,112,105,83,87,87,74]
[null,"Oats",7,93,93,93,93,86,77,78,95,92,94,100,77,104,104,99]
[null,"Barley",8,90,90,90,90,91,90,85,104,104,93,101,67,100,100,92]
[null,"Canola",9,101,101,101,101,105,101,102,86,87,96,100,99,75,75,99]
[null,"Flaxseed",10,96,96,96,96,104,97,106,103,79,86,98,100,71,71,78]
[null,"Peas",11,101,101,101,101,82,112,102,104,145,100,68,100,100,100,94]
[null,"Soybeans",12,108,108,108,108,93,108,108,104,104,96,94,100,101,101,103]
[null,"Beans - White",13,119,119,119,119,100,115,114,119,100,100,107,78,100,100,111]
[null,"Sunflower Oil",14,102,102,102,102,100,103,103,91,101,100,93,100,100,100,95]
[null,"Sunflower Confection",15,102,102,102,102,100,103,103,91,101,100,93,100,100,100,95]
[null,"Corn",16,98,98,98,98,67,111,96,112,100,100,102,61,119,119,89]