{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Summary","Seed, Fertilizer & Chemical","Operating Costs","Fixed Cost Input","Strawberry Production Info","Assumptions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":45,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":false,"merged":[[4,0,4,8],[5,0,5,8],[47,1,49,8],[13,1,21,8],[22,1,24,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
["Guidelines For Estimating"]
["Strawberry U-Pick Production Costs"]
[]
[]
[]
[]
[]
[]
[]
[null,"The following budget estimates the cost of producing Strawberries in Manitoba.  General Manitoba Agriculture 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. "]
[]
[]
[]
[]
["                                                                                          is also available to help"]
[null,"determine machinery costs."]
[]
[]
[null,"This tool is available as an Excel worksheet at:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: This budget is only a guide and is not intended as an in depth study of the cost of production of this industry. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact a Farm Management Specialist."]

{"sheet":"Summary","index":1,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,11,5,12],[58,0,58,6],[31,1,31,6],[44,1,44,6],[0,1,0,6],[1,1,1,6],[2,1,2,6],[60,0,60,8],[3,4,3,5]]}
[null,{"$f":"\"Strawberry - Cost of Production Summary     \"","v":"Strawberry - Cost of Production Summary     "}]
[null,{"$f":"\"Based on  \"&'Fixed Cost Input'!C11&\" acres\"","v":"Based on  20 acres"}]
[null,{"$f":"\"Based on  \"&'Fixed Cost Input'!C6&\" acres\"","v":"Based on  10 acres"}]
[null,null,null,"Establishment1","Picking Years"]
[null,null,null,"Cost $/acre","Cost /acre","Cost/lb","Your Cost"]
[null,"Operating Costs"]
["A","Establishment cost (amortized)1",null,{"$f":"\"-\"","v":"-"},{"$f":"'Fixed Cost Input'!C26","v":3722.0888694205105},{"$f":"\"-\"","v":"-"}]
[null,"Seed & Treatment",null,{"$f":"'Seed, Fertilizer & Chemical'!D4","v":2240},{"$f":"\"-\"","v":"-"},{"$f":"ROUND(E7/$E$35,4)","v":0.68930000000000002}]
[null,"Fertilizer",null,{"$f":"'Seed, Fertilizer & Chemical'!J22","v":179.85586613214025},{"$f":"'Seed, Fertilizer & Chemical'!J23","v":170.1578277445831},{"$f":"ROUND(E9/$E$35,4)","v":3.15E-2}]
[null,"Pesticide",null,{"$f":"'Seed, Fertilizer & Chemical'!E29","v":120},{"$f":"'Seed, Fertilizer & Chemical'!E30","v":266},4.9299999999999997E-2]
[null,"Fuel",null,{"$f":"'Operating Costs'!G18","v":54.66},{"$f":"'Operating Costs'!G26","v":48.52},8.9999999999999993E-3]
[null,"Irrigation",null,{"$f":"'Operating Costs'!D34","v":15.96},{"$f":"'Operating Costs'!E34","v":63.84},1.18E-2]
[null,"Machinery Operating & Lease",null,{"$f":"'Operating Costs'!$D$6+'Fixed Cost Input'!$D$71","v":25},{"$f":"'Operating Costs'!$D$6+'Fixed Cost Input'!$D$71","v":25},4.5999999999999999E-3]
[null,"Labour - hired",null,{"$f":"'Operating Costs'!J40","v":1066},{"$f":"'Operating Costs'!J41","v":1734},0.3211]
[null,"Crop Insurance (Establishment only)",null,{"$f":"'Operating Costs'!$C$70","v":64.800000000000011},{"$f":"\"-\"","v":"-"},{"$f":"\"-\"","v":"-"}]
[null,"Hail Insurance",null,{"$f":"'Operating Costs'!$C$71","v":280},{"$f":"'Operating Costs'!$C$71","v":280},{"$f":"ROUND(E16/$E$35,4)","v":5.1900000000000002E-2}]
[null,"Land Taxes",null,{"$f":"'Operating Costs'!$D$4","v":20},{"$f":"'Operating Costs'!$D$4","v":20},3.7000000000000002E-3]
[null,"Miscellaneous Cost",null,{"$f":"'Operating Costs'!D54","v":578.255},{"$f":"'Operating Costs'!D54","v":578.255},0.1071]
[null,"Rental and Custom Charges",null,{"$f":"'Operating Costs'!H64","v":0},{"$f":"'Operating Costs'!H65","v":0},0]
[null,"Repairs & Maintenance Cost",null,{"$f":"'Operating Costs'!D59","v":378.26249999999999},{"$f":"'Operating Costs'!D59","v":378.26249999999999},7.0000000000000007E-2]
[null,"Interest on Operating",null,{"$f":"SUM(D8:D20)*'Operating Costs'!D3","v":351.59553562924987},{"$f":"SUM(E7:E20)/2*'Operating Costs'!D3","v":255.01434690077832},4.7199999999999999E-2]
[null,"Total Operating Costs",null,{"$f":"SUM(D8:D21)","v":5374.3889017613901},{"$f":"SUM(E7:E21)","v":7541.1385440658723},{"$f":"SUM(F8:F21)","v":1.3965000000000001}]
[]
["B. ","Fixed Costs"]
[null,"Land Costs",null,{"$f":"'Fixed Cost Input'!$C$14","v":327.64594941898008},{"$f":"'Fixed Cost Input'!$C$14","v":327.64594941898008},{"$f":"ROUND(E25/$E$35,4)","v":6.0699999999999997E-2}]
[null,"Machinery Costs",null,{"$f":"'Fixed Cost Input'!$G$16","v":2949.8788049438208},{"$f":"'Fixed Cost Input'!$G$16","v":2949.8788049438208},{"$f":"ROUND(E26/$E$35,4)","v":0.54630000000000001}]
[null,"Storage & Irrigation Costs",null,{"$f":"'Fixed Cost Input'!G33","v":2153.6568478951876},{"$f":"'Fixed Cost Input'!G33","v":2153.6568478951876},{"$f":"ROUND(E27/$E$35,4)","v":0.39879999999999999}]
[null,"Total Fixed Costs",null,{"$f":"SUM(D25:D27)","v":5431.1816022579887},{"$f":"SUM(E25:E27)","v":5431.1816022579887},{"$f":"ROUND(E28/$E$35,4)","v":1.0058}]
[]
["C. ","Total Costs",null,{"$f":"D22+D28","v":10805.570504019379},{"$f":"E22+E28","v":12972.320146323862},{"$f":"ROUND(E30/$E$35,4)","v":2.4022999999999999}]
[]
[null,"Profitability Analysis"]
[null,"Estimated Farmgate"]
[null,"Price per Unit",null,null,{"$f":"'Seed, Fertilizer & Chemical'!$E$46","v":5}]
[null,"Target Yield per acre (lbs)",null,null,{"$f":"ROUNDUP('Seed, Fertilizer & Chemical'!E45,-2)","v":5400}]
[null,"Gross Revenue / acre",null,null,{"$f":"ROUND(((E34)*E35),2)","v":27000}]
[]
[null,"Operating Expense Ratio",null,null,{"$f":"SUM(E22/E36)","v":0.27930142755799525}]
[]
[null,"Marginal Returns"]
[null,"Over Operating Costs",null,null,{"$f":"SUM(E36-E22)","v":19458.861455934129}]
[null,"Over Total Costs (Net Profit)",null,null,{"$f":"SUM(E36-E30)","v":14027.679853676138}]
[]
[]
[null,"Breakeven Analysis"]
[null,"Breakeven Price ($ Per lb.)"]
[null,"Operating Costs",null,null,{"$f":"E22/E35","v":1.3965071377899763}]
[null,"Over Fixed Costs",null,null,{"$f":"(E28/E35)","v":1.0057743707885165}]
[null,"Over Total Costs",null,null,{"$f":"SUM(E47:E48)","v":2.4022815085784925}]
[]
[null,"Breakeven Yield (lbs)"]
[null,"Over Operating Costs",null,null,{"$f":"ROUND(E22/E34,0)","v":1508}]
[null,"Over Fixed Costs",null,null,{"$f":"ROUND(E28/E34, 0)","v":1086}]
[null,"Over Total Costs",null,null,{"$f":"ROUND(E30/E34, 0)","v":2594}]
[]
[null,"Breakeven Yield Risk Ratio",null,null,{"$f":"SUM(E35/E54)","v":2.081727062451812}]
[null,"(Yield per acre/BE Yield)"]
[{"$f":"\"1. The cost of establishing the crop of $\"&TEXT(D30,\"0.00\")&\", includes the pre plant and planting years, was amortized over $\"&TEXT(E7,\"0.00\")&\"\"","v":"1. The cost of establishing the crop of $10805.57, includes the pre plant and planting years, was amortized over $3722.09"}]
["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":"Seed, Fertilizer & Chemical","index":2,"n_rows":50,"n_cols":46,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,0,6,9],[0,0,0,9],[37,1,37,5],[35,0,35,9],[24,0,24,9],[18,1,18,8]]}
["Strawberry Planting "]
[]
[null,"Transplanting Rate (plants/ac)","Plant Cost (per plant)","Cost per Acre"]
["Strawberry Plants",8000,0.28000000000000003,{"$f":"C4*B4","v":2240}]
[]
[]
["Fertilizer"]
[]
[null,null,"Bulk Price",null,"Actual Nutrient",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitrogen",null,"Sulphur"]
["Fertilizer Type",null,"$/tonne",null,"$/lb",null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage",null,"Usage"]
["Nitrogen: (urea) 46-0-0",null,900,null,{"$f":"SUM(C11/(2204.5855*0.46))","v":0.8874782761341915},null,null,null,null,null,null,null,null,null,null,null,null,null,1,null," -"]
["Nitrogen: (NH3) 82-0-0",null,1090,null,{"$f":"SUM(C12/(2204.5855*0.82))","v":0.60295610793182064},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null," -"]
["Nitrogen: (liquid) 28-0-0",null,440,null,{"$f":"SUM(C13/(2204.5855*0.28))","v":0.7128000122601601},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null," -"]
["Phosphorus:   11-52-0",null,1250,null,{"$f":"SUM((C14-(E11*(0.11*2204.5855)))/(2204.5855*0.52))","v":0.90264884495699815},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," -",null," -"]
["Potash:   0-0-60",null,650,null,{"$f":"SUM(C15/(2204.5855*0.6))","v":0.49140000845208009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," -",null," -"]
["Sulphur:   20.5-0-0-24",null,850,null,{"$f":"SUM((C16-(E11*(0.205*2204.5855)))/(2204.5855*0.24))","v":0.8484456667671787},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null," -"]
["MES S15:  13-33-0-15",null,1140,null,{"$f":"SUM((C17-(E11*(0.13*2204.5855))-(E14*(0.33*2204.5855)))/(2204.5855*0.15))","v":0.69238476107289748},null,null,null,null," -",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"***HIDE***"]
[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,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,"Nitrogen",null,"Phosphorus",null,"Potash",null,"Sulphur",null,"Total",null,null,null,null,null,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","lbs","$/acre","lbs","$/acre","lbs","$/acre","lbs","$/acre","$/acre",null,null,null,null,null,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"]
["Strawberry Planting",70,{"$f":"IF(SUM($S$11:$S$13)<>100%,\"ERROR\",SUM(V22+Z22+AG22))","v":31.978874666742723},100,{"$f":"AJ22","v":109.03774625084613},30,{"$f":"AM22","v":14.741903293114397},15,{"$f":"IF(SUM($U$16:$U$17)<>100%,\"ERROR\",AP22+AS22)","v":24.097341921436996},{"$f":"C22+E22+G22+I22","v":179.85586613214025},null,null,null,null,null,null,null,null,{"$f":"SUM(B22*$S$12)","v":0},{"$f":"MAXA(0,(S22)/(0.82))","v":0},{"$f":"(T22)/2204.6","v":0},{"$f":"SUM(U22*$C$12)","v":0},{"$f":"SUM(B22*$S$13)","v":0},{"$f":"MAXA(0,(W22)/(0.28))","v":0},{"$f":"(X22)/2204.6","v":0},{"$f":"SUM(Y22*$C$13)","v":0},{"$f":"SUM(AH22*0.11)","v":21.153846153846153},{"$f":"SUM(AN22*0.205)","v":12.8125},{"$f":"SUM(AQ22*0.13)","v":0},{"$f":"SUM(B22-(AA22+AB22+AC22+W22+S22))","v":36.033653846153847},{"$f":"MAXA(0,(AD22)/(0.46))","v":78.334030100334445},{"$f":"(AE22)/2204.6","v":3.5532082963047468E-2},{"$f":"SUM(AF22*$C$11)","v":31.978874666742723},{"$f":"MAXA(0,(D22-(AQ22*0.33))/0.52)","v":192.30769230769229},{"$f":"(AH22)/2204.6","v":8.7230197000676898E-2},{"$f":"SUM(AI22*$C$14)","v":109.03774625084613},{"$f":"SUM(F22/0.6)","v":50},{"$f":"(AK22)/2204.6","v":2.2679851220175996E-2},{"$f":"SUM(AL22*$C$15)","v":14.741903293114397},{"$f":"MAXA(0,SUM(H22*$U$16)/0.24)","v":62.5},{"$f":"(AN22)/2204.6","v":2.8349814025219997E-2},{"$f":"SUM(AO22*$C$16)","v":24.097341921436996},{"$f":"MAXA(0,SUM(H22*$U$17)/0.15)","v":0},{"$f":"(AQ22)/2204.6","v":0},{"$f":"SUM(AR22*$C$17)","v":0}]
["Strawberry Picking",150,{"$f":"IF(SUM($S$11:$S$13)<>100%,\"ERROR\",SUM(V23+Z23+AG23))","v":125.57592789415381},20,{"$f":"AJ23","v":21.807549250169224},30,{"$f":"AM23","v":14.741903293114397},5,{"$f":"IF(SUM($U$16:$U$17)<>100%,\"ERROR\",AP23+AS23)","v":8.0324473071456666},{"$f":"C23+E23+G23+I23","v":170.1578277445831},null,null,null,null,null,null,null,null,{"$f":"SUM(B23*$S$12)","v":0},{"$f":"MAXA(0,(S23)/(0.82))","v":0},{"$f":"(T23)/2204.6","v":0},{"$f":"SUM(U23*$C$12)","v":0},{"$f":"SUM(B23*$S$13)","v":0},{"$f":"MAXA(0,(W23)/(0.28))","v":0},{"$f":"(X23)/2204.6","v":0},{"$f":"SUM(Y23*$C$13)","v":0},{"$f":"SUM(AH23*0.11)","v":4.2307692307692308},{"$f":"SUM(AN23*0.205)","v":4.2708333333333339},{"$f":"SUM(AQ23*0.13)","v":0},{"$f":"SUM(B23-(AA23+AB23+AC23+W23+S23))","v":141.49839743589743},{"$f":"MAXA(0,(AD23)/(0.46))","v":307.60521181716831},{"$f":"(AE23)/2204.6","v":0.13952880877128201},{"$f":"SUM(AF23*$C$11)","v":125.57592789415381},{"$f":"MAXA(0,(D23-(AQ23*0.33))/0.52)","v":38.46153846153846},{"$f":"(AH23)/2204.6","v":1.744603940013538E-2},{"$f":"SUM(AI23*$C$14)","v":21.807549250169224},{"$f":"SUM(F23/0.6)","v":50},{"$f":"(AK23)/2204.6","v":2.2679851220175996E-2},{"$f":"SUM(AL23*$C$15)","v":14.741903293114397},{"$f":"MAXA(0,SUM(H23*$U$16)/0.24)","v":20.833333333333336},{"$f":"(AN23)/2204.6","v":9.4499380084066657E-3},{"$f":"SUM(AO23*$C$16)","v":8.0324473071456666},{"$f":"MAXA(0,SUM(H23*$U$17)/0.15)","v":0},{"$f":"(AQ23)/2204.6","v":0},{"$f":"SUM(AR23*$C$17)","v":0}]
[]
["Crop Protection"]
[]
[null,"Weed Control","Disease Control","Insect Control","Total Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hail Insurance Premiums"]
[null," $/ac"," $/ac"," $/ac"," $/ac",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area # 2","Area # 5","Area # 6","Area # 12"]
["Planting",120,0,0,{"$f":"B29+C29+D29","v":120},null,null,null,null,null,null,null,null,null,null,null,null,null,300,330,270,220,{"$f":"AVERAGE(S29:V29)","v":280}]
["Picking",180,80,6,{"$f":"B30+C30+D30","v":266}]
["Note: "]
["Pre-emergent burn off is not included in weed control costs. "]
["Chemical costs do not include year end rebates or bundling discounts. "]
["Disease Control costs do not include custom application costs. "]
[]
["Crop Rotations and Yields"]
[]
[null,"Crop Rotation and Yields"]
[null,null,null,"Year","lbs/acre"]
[null,"Planting Year",null,1]
[null,"1st Picking",null,2,6600]
[null,"2nd Picking",null,3,5500]
[null,"3rd Picking",null,4,4000]
[null,null,null,"Total Yield (lbs/acre)",{"$f":"SUM(E40:E43)","v":16100}]
[null,null,null,"Average Yield (lbs/acre)",{"$f":"ROUND(SUM(E44/COUNTA(E40:E43)),0)","v":5367}]
[null,null,null,"Market Price per Pound",5]
[]
[]
["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. "]

{"sheet":"Operating Costs","index":3,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,0,9],[54,0,54,9],[25,2,25,5],[66,0,66,9],[42,0,42,9],[35,0,35,9],[27,0,27,9],[9,0,9,9],[17,2,17,5],[55,0,55,9],[60,0,60,9],[37,2,37,7]]}
["Operating Costs"]
[]
[null,"Interest Rate on Operating",null,7.0000000000000007E-2]
[null,"Land Taxes  ($/acre)",null,20]
[null,"Labour rate ($/hour)",null,20]
[null,"Machinery Operating  ($/acre)",null,25]
[null,"Cost per round bale of straw",null,70]
[null,"Fuel Cost  ($/litre)",null,1.1000000000000001]
[]
["Field Fuel Usage"]
[]
[null,null,"Times","Width","Speed","Tractor","Fuel","Capacity","Time","Maint"]
[null,"Operation","Over","Feet","MPH","HP","Per Acre","Ac/Hr","Hr./Ac.","& Lub"]
[null,"Planting",1,5,1,50,{"$f":"(0.25*(F14*0.75))*I14*$D$8","v":20.625},{"$f":"(D14*E14)/10","v":0.5},{"$f":"IF(ISERROR(1/H14),0,(1/H14)*(C14))","v":2},{"$f":"0.1*G14","v":2.0625}]
[null,"Cultivate",3,5,5,50,{"$f":"(0.25*(F15*0.75))*I15*$D$8","v":12.375000000000004},{"$f":"(D15*E15)/10","v":2.5},{"$f":"IF(ISERROR(1/H15),0,(1/H15)*(C15))","v":1.2000000000000002},{"$f":"0.1*G15","v":1.2375000000000005}]
[null,"Spray",1,25,4,50,{"$f":"(0.25*(F16*0.75))*I16*$D$8","v":1.03125},{"$f":"(D16*E16)/10","v":10},{"$f":"IF(ISERROR(1/H16),0,(1/H16)*(C16))","v":0.1},{"$f":"0.1*G16","v":0.10312500000000001}]
[null,"Straw Spreading",1,5,2,100,{"$f":"(0.25*(F17*0.75))*I17*$D$8","v":20.625},{"$f":"(D17*E17)/10","v":1},{"$f":"IF(ISERROR(1/H17),0,(1/H17)*(C17))","v":1},{"$f":"0.1*G17","v":2.0625}]
[null,null,"Total Establishment Field Operation Fuel Costs ($/acre)",null,null,null,{"$f":"ROUND(SUM(G14:G17),2)","v":54.66}]
[]
[null,"Straw removal",1,5,5,50,{"$f":"(0.25*(F20*0.75))*I20*$D$8","v":4.125},{"$f":"(D20*E20)/10","v":2.5},{"$f":"IF(ISERR(1/H20),0,(1/H20)*C20)","v":0.4},{"$f":"0.1*G20","v":0.41250000000000003}]
[null,"Spray",5,25,4,50,5.15625,10,0.5,0.515625]
[null,"Mowing",1,5,5,50,4.125,2.5,0.4,0.41250000000000003]
[null,"Rototilling",2,5,3,50,13.750000000000002,1.5,1.3333333333333333,1.3750000000000002]
[null,"Fertilizer",2,40,7,50,0.7366071428571429,28,7.1428571428571425E-2,7.3660714285714288E-2]
[null,"Straw Spreading",1,5,2,100,20.625,1,1,2.0625]
[null,null,"Total Picking Field Operation Fuel Costs ($/acre)",null,null,null,{"$f":"ROUND(SUM(G20:G25),2)","v":48.52}]
[]
["Irrigation Cost "]
[]
[null,"Irrigation Fuel Costs",null,"Establishment","Picking"]
[null,"Inches water applied",null,3,12]
[null,"Hours/acre for 1\" of water",null,4,4]
[null,"Hourly pumping costs",null,1.33,1.33]
[null,null,"Total Cost ($/acre)",{"$f":"D31*D32*D33","v":15.96},{"$f":"E31*E32*E33","v":63.84}]
[]
["Labour Cost "]
[]
[null,null,"Hours Required per Acre"]
[null,null,"Weed Control","De-blossoming","Irrigation","Straw Spreading","Field Operation","U-Pick Operation","Total Hours","Total ($/acre)"]
[null,"Establishment",30,8,6,5,4.3,0,{"$f":"SUM(C40:H40)","v":53.3},{"$f":"I40*$D$5","v":1066}]
[null,"Picking",30,0,6,5,3.7,42,{"$f":"SUM(C41:H41)","v":86.7},{"$f":"I41*$D$5","v":1734}]
[]
["Miscellaneous Cost "]
[]
[null,"Plant (total $)",null,750]
[null,"Advertising (total $)",null,500]
[null,"Utilities (total $)",null,{"$f":"150+1000","v":1150}]
[null,"Pails/Baskets ($/each)",0.75,{"$f":"'Seed, Fertilizer & Chemical'!E45/5*C48","v":805.05000000000007}]
[null,"Straw bales per acre",3,{"$f":"C49*$D$7*'Fixed Cost Input'!C6","v":2100}]
[null,"Other Costs ($/acre)",17.75,{"$f":"SUM(C50*'Fixed Cost Input'!C6)","v":177.5}]
[null,"Washrooms (total $)",null,300]
[null,{"$f":"\"Total Miscellaneous Cost ($/\"&'Fixed Cost Input'!C6&\" acres)\"","v":"Total Miscellaneous Cost ($/10 acres)"},null,{"$f":"SUM(D45:D51)","v":5782.55}]
[]
[null,"Total Miscellaneous Cost ($/acre)",null,{"$f":"D52/'Fixed Cost Input'!C6","v":578.255}]
[]
["Repairs & Maintenance Cost "]
[]
[null,"% rate of investment",null,1.4999999999999999E-2]
[null,"Total Repair & Maintenance Costs",null,{"$f":"D58*('Fixed Cost Input'!D42+'Fixed Cost Input'!D62+'Fixed Cost Input'!D71)/'Fixed Cost Input'!C6","v":378.26249999999999}]
[]
["Rental and Custom Charges"]
[]
[null,"Rental & Custom Charges",null,"Seeding","Application","Harvest","General","Total"]
[null,"Establishment",null,"-","-","-","-",{"$f":"SUM(D64:G64)","v":0}]
[null,"Picking ",null,"-","-","-","-",{"$f":"SUM(D65:G65)","v":0}]
[]
["Crop & Hail Insurance"]
[]
[null,null,"Crop Insurance"]
[null,"Establishment",{"$f":"('Seed, Fertilizer & Chemical'!B4/100)*0.81","v":64.800000000000011}]
[null,"Hail Insurance",{"$f":"'Seed, Fertilizer & Chemical'!W29","v":280}]
[]
[null,"Note: This budget is only a guide and not intended as an in depth study of the cost of production of this industry.  Interpretation and utilization of this information is the "]
[null,"responsibility of the user."]

{"sheet":"Fixed Cost Input","index":4,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":false,"merged":[[34,0,34,8],[1,0,1,8],[44,0,44,8],[64,0,64,8]]}
[]
["Fixed Costs"]
[]
["Land",null,null,null,null,"Machinery"]
["Average Land Value ",null,5000,null,null,"Total Investment ($/acre)",{"$f":"ROUND(D62/C6,2)","v":14017.5}]
["Strawberry Acres",null,10,null,null,"Residual Value (End of Useful Life)",0.25]
["Owned Land Equity",null,0.3,null,null,"Useful Life (years)",15]
["Land Financed ",null,{"$f":"SUM(1-C7)","v":0.7},null,null,"Owned Equipment Equity",0.2]
["Land Opportunity Cost ",null,1.4999999999999999E-2,null,null,"Equipment Financed ",{"$f":"SUM(1-G8)","v":0.8}]
["Land cost ($/acre)",null,null,null,null,"Machinery Opportunity Cost ",1.4999999999999999E-2]
["Finance Rate & Term",0.06,20,"Years",null,"Machinery Cost ($/acre)"]
["Principal & Interest Cost",null,{"$f":"-PMT(B11,C11,(C5*C8),0)","v":305.14594941898008},null,null,"Finance Rate & Term ",7.0000000000000007E-2,7,"Years"]
["Owned Land Opportunity Cost",null,{"$f":"SUM(C5*C7)*C9","v":22.5},null,null,"Principal & Interest Cost",{"$f":"-PMT(G12,H12,G5*G9)","v":2080.7938049438208}]
["Total Cost",null,{"$f":"SUM(C12:C13)","v":327.64594941898008},null,null,"Machinery Depreciation Cost",{"$f":"(G5-(G5*G6))/G7","v":700.875}]
[null,null,null,null,null,"Owned Machinery Opportunity Cost",{"$f":"SUM(G5*G9)*(G10)","v":168.21}]
["Strawberry Establishment",null,null,null,null,"Total Cost",{"$f":"SUM(G13:G15)","v":2949.8788049438208}]
["Establishment cost ($/acre)",null,{"$f":"ROUND(Summary!D30,0)","v":10806}]
["Strawberry Acres",null,{"$f":"C6","v":10},null,null,"Storage & Irrigation"]
["Establishment Equity",null,0.1,null,null,"Total Investment Storage ($/ac)",{"$f":"ROUND((D37+D38+D39+D40)/C6,2)","v":8200}]
[{"$f":"\"Establishment Financed (\"&TEXT(C17*C20,\"$#,###\")&\" per acre)\"","v":"Establishment Financed ($9,725 per acre)"},null,{"$f":"SUM(1-C19)","v":0.9},null,null,"Total Investment Irrigation ($/ac)",{"$f":"ROUND(D41/C6,2)","v":3000}]
["Establishment Opportunity Cost (Investment Rate) ",null,1.4999999999999999E-2,null,null,"Residual Value (End of Useful Life)",0.25]
["Establishment cost ($/acre)",null,null,null,null,"Useful Life Storage (years)",20]
["Finance Rate & Term",{"$f":"G12","v":7.0000000000000007E-2},{"$f":"COUNTA('Seed, Fertilizer & Chemical'!E40:E43)","v":3},"Years",null,"Useful Life Irrigation (years)",15]
["Principle & Interest Cost",null,{"$f":"-PMT(B23,C23,C17*C20,0)","v":3705.8798694205107},null,null,"Owned S & I Equity",0.2]
["Owned Land Opportunity Cost",null,{"$f":"SUM(C17*C19)*(C21)","v":16.209000000000003},null,null,"S & I Financed ",{"$f":"SUM(1-G24)","v":0.8}]
["Total Cost",null,{"$f":"SUM(C24:C25)","v":3722.0888694205105},null,null,"S & I Opportunity Cost ",1.4999999999999999E-2]
[null,null,null,null,null,"Storage & Irrigation Cost ($/acre)"]
[null,null,null,null,null,"Finance Rate & Term ",7.0000000000000007E-2,7,"Years"]
[null,null,null,null,null,"Principal & Interest Cost",{"$f":"-PMT(G28,H28,(G19+G20)*G25)","v":1662.5568478951877}]
[null,null,null,null,null,"Storage Depreciation Cost",{"$f":"(G19-(G19*G21))/G22","v":307.5}]
[null,null,null,null,null,"Irrigation Depreciation Cost",{"$f":"(G20-(G20*G21))/G23","v":150}]
[null,null,null,null,null,"Owned S & I Opportunity Cost",{"$f":"SUM((G19+G20)*G24)*(G26)","v":33.6}]
["Total  Debt ($/acre)",null,{"$f":"((C5)*C8)+(G5*G9)+((G19+G20)*G25)+(C17*C20)","v":33399.4},null,null,"Total Cost",{"$f":"SUM(G29:G32)","v":2153.6568478951876}]
[]
["Storage & Irrigation"]
[null,"Market Value","Strawberry Usage %","Strawberry Allocation"]
["Storage Shed",60000,0.9,{"$f":"SUM(B37*C37)","v":54000}]
["Cooler",10000,1,{"$f":"SUM(B38*C38)","v":10000}]
["Booth ",3000,1,3000]
["Miscellaneous ",15000,1,15000]
["Irrigation Equipment",30000,1,30000]
["Storage & Irrigation TOTAL",{"$f":"SUM(B37:B41)","v":118000},null,{"$f":"SUM(D37:D41)","v":112000}]
["Storage & Irrigation Total per acre",{"$f":"B42/C6","v":11800},null,{"$f":"D42/C6","v":11200}]
[]
["Equipment Inventory and Current Values"]
[]
["Power Equipment","Market Value","Strawberry Usage %","Strawberry Allocation",null,"Harvest Equipment","Market Value","Strawberry Usage %","Strawberry Allocation"]
["Tractor - 50 HP",60000,1,{"$f":"SUM(B48*C48)","v":60000},null,null,0,0,{"$f":"SUM(G48*H48)","v":0}]
["Tractor - 100 HP",100000,0.33,{"$f":"SUM(B49*C49)","v":33000},null,null,0,0,{"$f":"SUM(G49*H49)","v":0}]
[null,0,0,{"$f":"SUM(B50*C50)","v":0},null,null,0,0,0]
[null,0,0,0,null,null,0,0,0]
["Total Inventory",{"$f":"SUM(B48:B51)","v":160000},null,{"$f":"SUM(D48:D51)","v":93000},null,"Total Inventory",{"$f":"SUM(G48:G51)","v":0},null,{"$f":"SUM(I48:I51)","v":0}]
[]
["Seeding & Tillage","Market Value","Strawberry Usage %","Strawberry Allocation",null,"Spraying & Misc.","Market Value","Strawberry Usage %","Strawberry  Allocation"]
["Planter",5000,1,{"$f":"SUM(B55*C55)","v":5000},null,"Sprayer  - 25 ft",10000,1,{"$f":"SUM(G55*H55)","v":10000}]
["Rotovator",8000,0.9,{"$f":"SUM(B56*C56)","v":7200},null,"Straw spreader",39500,0.25,{"$f":"SUM(G56*H56)","v":9875}]
["Cultivator ",1500,0.9,1350,null,"Fertilizer Spreader",40000,0.25,10000]
[null,0,0,0,null,"Mower",5000,0.75,3750]
[null,0,0,0,null,null,0,0,0]
["Total Inventory",{"$f":"SUM(B55:B59)","v":14500},null,{"$f":"SUM(D55:D59)","v":13550},null,"Total Inventory",{"$f":"SUM(G55:G59)","v":94500},null,{"$f":"SUM(I55:I59)","v":33625}]
[]
["Owned Equipment TOTAL",{"$f":"SUM(D52+I52+I60+D60+D42)","v":252175},null,{"$f":"SUM(D52+D60+I52+I60)","v":140175}]
["Owned Equipment TOTAL / acre",{"$f":"B62/C6","v":25217.5},null,{"$f":"D62/C6","v":14017.5}]
[]
["Leased Equipment Inventory and Current Values"]
["Seeding, Tillage, Spraying etc","Annual Lease","Strawberry Usage %","Strawberry Allocation"]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
["Lease Equipment TOTAL",{"$f":"SUM(B67:B69)","v":0},null,{"$f":"SUM(D67:D69)","v":0}]
["Leased Equipment TOTAL / acre",{"$f":"B70/C6","v":0},null,{"$f":"D70/C6","v":0}]
[]
["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":"Strawberry Production Info","index":5,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,34,7],[1,0,1,7],[3,0,4,7],[6,0,10,7],[12,0,17,7],[19,0,28,7]]}
[]
["Strawberry Production in Manitoba"]
[]
["The projected strawberry production costs in this publication have been prepared to assist you in developing your own production costs. "]
[]
[]
["The capital and cash input costs associated with growing strawberries in Manitoba are substantial.  Detailed planning is necessary when budgeting for capital expenditures and also for the annual operating costs. The importance of good financial planning is evident by noting the large capital required for 1 acre of strawberries is significant.  "]
[]
[]
[]
[]
[]
["Commercial strawberry production in Manitoba has been an important part of diversification in the province.    The majority of the strawberry farms are on a U-Pick basis; but custom picking of the crop has increased over the past few years. "]
[]
[]
[]
[]
[]
[]
["Strawberries are an intensely managed crop that require precise timing. Yield and quality achieved during the short 3 - 4 week picking season hinge on timely management practices of the previous year, as well as care and maintenance before picking.  Growers entering the industry need these basic requirements: (1) suitable land with adequate drainage and shelterbelts, (2) access to an adequate quantity and quality of water for irrigation, (3) financial resources that permit a significant level of investment on infrastructure and input costs, (4) the ability to apply intensive management skills to the crop in a precisely timed manner, (5) the ability to determine market potential, and (6) the willingness to accept risk."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["It is advised that new growers should proceed on a small but graduated scale.  A complete assessment of the customer base and marketing opportunities needs to be completed prior to planting the first crop of strawberries.  "]

{"sheet":"Assumptions","index":6,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[13,0,13,11],[18,0,19,11],[0,0,0,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."]
[]
["Crop Insurance: "]
["Establishment coverage is available through MASC."]
["Hail insurance coverage insured value based on MASC Risk Areas 2, 5, 6, & 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 \"&'Operating Costs'!D3*100&\"% for six months.\"","v":"Interest charges on operating costs are calculated at 7% for six months."}]
[]
["Land Cost:"]
[{"$f":"\"Based on approximate average land values. Budget assumed \"&'Fixed Cost Input'!C8*100&\"% financed at \"& 'Fixed Cost Input'!B11*100&\"% for \"&'Fixed Cost Input'!C11&\" years, plus \"&'Fixed Cost Input'!C9*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 70% financed at 6% for 20 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'!C5*('Fixed Cost Input'!C6)*'Fixed Cost Input'!C8,\"$#,###\")&\" Mortgage) = $\"&TEXT('Fixed Cost Input'!C12*('Fixed Cost Input'!C6),\"#,###\")&\" payments per year) / \"&'Fixed Cost Input'!C6&\" acres = $\"&TEXT('Fixed Cost Input'!C12,\"0.00\")&\"/acre)\"","v":"P&I Cost (based on $35,000 Mortgage) = $3,051 payments per year) / 10 acres = $305.15/acre)"}]
[{"$f":"\"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. (($\"&TEXT('Fixed Cost Input'!C5,\"#,###\")&\" x \"&'Fixed Cost Input'!C7*100&\"%) x \"&'Fixed Cost Input'!C9*100&\"%) = $\"&TEXT('Fixed Cost Input'!C13,\"0.00\")&\"/acre)\"","v":"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. (($5,000 x 30%) x 1.5%) = $22.50/acre)"}]
[]
["Machinery Cost: "]
[{"$f":"\"Based on approximate average machinery values.  Budget assumed \"&'Fixed Cost Input'!G9*100&\"% financed at \"&'Fixed Cost Input'!G12*100&\"% for \"&'Fixed Cost Input'!H12&\" years, depreciation costs over \"&'Fixed Cost Input'!G7&\" years with a \"&'Fixed Cost Input'!G6*100&\"% residual value, plus \"&'Fixed Cost Input'!G10*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 80% financed at 7% 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'!B62*'Fixed Cost Input'!G9,\"$#,###\")&\" Loans) = $\"&TEXT('Fixed Cost Input'!G13*('Fixed Cost Input'!C6),\"#,###\")&\" payments per year) / \"&'Fixed Cost Input'!C6&\" acres = $\"&TEXT('Fixed Cost Input'!G13,\"0.00\")&\"/acre)\"","v":"P&I Cost (based on $201,740 Loans) = $20,808 payments per year) / 10 acres = $2080.79/acre)"}]
[{"$f":"\"Depreciation (Useage Cost) = (Total Investment - Residual Value) / Years Useful Life  (eg. ($\"&'Fixed Cost Input'!G5&\" - ($\"&'Fixed Cost Input'!G5&\" x \"&'Fixed Cost Input'!G6*100&\"%)) / \"&'Fixed Cost Input'!G7&\" = $\"&TEXT('Fixed Cost Input'!G14,\"0.00\")&\"/acre)\"","v":"Depreciation (Useage Cost) = (Total Investment - Residual Value) / Years Useful Life  (eg. ($14017.5 - ($14017.5 x 25%)) / 15 = $700.88/acre)"}]
[{"$f":"\"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. ($\"&'Fixed Cost Input'!G5&\" x \"&'Fixed Cost Input'!G8*100&\"%) x \"&'Fixed Cost Input'!G10*100&\"%) = $\"&TEXT('Fixed Cost Input'!G15,\"0.00\")&\"/acre)\"","v":"Investment = (Total Investment x Owned Equity %) x Investment Rate %  (eg. ($14017.5 x 20%) x 1.5%) = $168.21/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:"]
[{"$f":"\"Target crop prices are based on $\"&'Seed, Fertilizer & Chemical'!E46&\" value per pound sold.\"","v":"Target crop prices are based on $5 value per pound sold."}]
[{"$f":"\"Target crop yields are based on historical yield from Manitoba crop average of \"&TEXT('Seed, Fertilizer & Chemical'!E45,\"#,###\")&\" lbs/ac.\"","v":"Target crop yields are based on historical yield from Manitoba crop average of 5,367 lbs/ac."}]
[]
["Plant Costs:"]
[" Plant cost based on Prairie Fruit Growers Association member plant discount price."]
[]
["Miscellaneous Costs:"]
["Includes: plant costs, advertising, utilities, pails/baskets, portable washrooms, and rental & custom charges."]
[]
["Profitability, Breakeven & Risk Analysis Formulas:"]
[{"$f":"\"Gross Revenue = Price per unit x Yield per acre  (eg. picking years:  $\"&TEXT(Summary!E34,\"0.00\")&\"/lbs x \"&Summary!E35&\"lbs/ac = $\"&TEXT(Summary!E36, \"0.00\")&\"/ac)\"","v":"Gross Revenue = Price per unit x Yield per acre  (eg. picking years:  $5.00/lbs x 5400lbs/ac = $27000.00/ac)"}]
[{"$f":"\"Net Profit = Gross Revenue - Total Cost  (eg. picking years:   $\"&TEXT(Summary!E36,\"0.00\")&\" gross revenue - $\"&TEXT(Summary!E30,\"0.00\")&\" total cost = $\"&TEXT(Summary!E42,\"0.00\")&\" per acre)\"","v":"Net Profit = Gross Revenue - Total Cost  (eg. picking years:   $27000.00 gross revenue - $12972.32 total cost = $14027.68 per acre)"}]
[{"$f":"\"Operating Expense Ratio = (Operating Cost / Gross Revenue) x 100    (eg. picking years:   $\"&TEXT(Summary!E22,\"0.00\")&\" operating expense / $\"&TEXT(Summary!E36,\"0.00\")&\" total cost = \"&TEXT(Summary!E38*100,\"0.0\")&\"%)\"","v":"Operating Expense Ratio = (Operating Cost / Gross Revenue) x 100    (eg. picking years:   $7541.14 operating expense / $27000.00 total cost = 27.9%)"}]
[{"$f":"\"Breakeven Price = Cost / Target Yield  (eg. picking years:  $\"&TEXT(Summary!E30,\"0.00\")&\"  / \"&Summary!E35&\" lbs = $\"&TEXT(Summary!E49,\"0.00\")&\" per lbs)\"","v":"Breakeven Price = Cost / Target Yield  (eg. picking years:  $12972.32  / 5400 lbs = $2.40 per lbs)"}]
[{"$f":"\"Breakeven Yield = Cost / Price per Unit  (eg. picking years:  $\"&TEXT(Summary!E30,\"0.00\")&\"  / $\"&TEXT(Summary!E34,\"0.00\")&\" lbs = \"&TEXT(Summary!E54,\"0.0\")&\" lbs)\"","v":"Breakeven Yield = Cost / Price per Unit  (eg. picking years:  $12972.32  / $5.00 lbs = 2594.0 lbs)"}]
[{"$f":"\"Breakeven Yield Risk Ratio = (Yield per Acre / Breakeven Yield) x 100  (eg. picking years:  \"&Summary!E35&\"  lbs/ac / \"&TEXT(Summary!E54,\"0.0\")&\" bu BE = \"&ROUND(Summary!E56*100,0)&\"%)\"","v":"Breakeven Yield Risk Ratio = (Yield per Acre / Breakeven Yield) x 100  (eg. picking years:  5400  lbs/ac / 2594.0 bu BE = 208%)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"June, 2025"]