{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Calculations","Credits","Crop List","Variable Costs","Fixed Costs","Outputs","Comparison Charts"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Calculations","index":0,"n_rows":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Greenhouse size ","Length (ft)","Width (ft)","Area","Usable space","Growing area"]
[null,{"$f":"'Variable Costs'!D12","v":96},{"$f":"'Variable Costs'!E12","v":30},{"$f":"'Variable Costs'!F12","v":2880},{"$f":"'Variable Costs'!G12","v":0.8},{"$f":"'Variable Costs'!H12","v":2304}]
[]
["Variable costs - Annual expenses "]
["Production expenses","Object","Description","Price","Unit","Total cost","Total"]
[null,"Seeds","Spinach",70,"per 100M seeds",{"$f":"((144*F4)/100000)*D8","v":232.2432}]
[null,null,"Lettuce",150,"per pound",{"$f":"(0.000375*D9)*F4","v":129.6}]
[null,null,"Mizuna",33,"per pound",{"$f":"(0.00075*F4)*D10","v":57.024000000000001}]
[null,"Media","Living acres compost",6.1,"1 cb ft",{"$f":"(D11*2*(((F4*0.25)/27)/0.074))","v":3517.1171171171172}]
[null,"Media shipping",null,0.5,"per mile",70]
[null,"Bags","3000 20 x 12\" produce bags",55,null,55]
[null,null,null,null,null,null,{"$f":"SUM(F8:F13)","v":4060.9843171171174}]
["Labor",null,null,12.03,"per hour"]
[null,null,"tray filling",{"$f":"0.00875*F4","v":20.160000000000004},"hours",{"$f":"$D$15*D16","v":242.52480000000003}]
[null,null,"planting ",{"$f":"0.00641*F4","v":14.76864},"hours",{"$f":"$D$15*D17","v":177.66673919999999}]
[null,null,"harvesting",{"$f":"0.003*F4","v":6.9119999999999999},"hours",83.151359999999997]
[null,null,"watering",{"$f":"0.0146*F4","v":33.638399999999997},"hours",404.66995199999997]
[null,null,"packing",{"$f":"(0.29/(60))*F4","v":11.135999999999999},"hours",133.96607999999998]
[null,null,"marketing",5,"hours",60.15]
[]
["Total",null,null,null,null,null,{"$f":"SUM(F8:F21)","v":5163.1132483171168}]
[]
[]
[]
["Gross Income","Crop","Greenhouse temperature (F)","Season",null,"Pounds per sq ft","Pounds per greenhouse","Price or Charge",null,"Total"]
[null,"Lettuce",40,"Fall Early",{"$f":"B28&\"|\"&C28&\"|\"&D28","v":"Lettuce|40|Fall Early"},0.32,{"$f":"F28*$F$4","v":737.28},{"$f":"'Variable Costs'!$C$18","v":10},"per pound",{"$f":"G28*H28","v":7372.7999999999993}]
[null,"Lettuce",40,"Fall Late",{"$f":"B29&\"|\"&C29&\"|\"&D29","v":"Lettuce|40|Fall Late"},0.41,{"$f":"F29*$F$4","v":944.64},{"$f":"'Variable Costs'!$C$18","v":10},"per pound",{"$f":"G29*H29","v":9446.4}]
[null,"Lettuce",40,"Spring Early","Lettuce|40|Spring Early",0.4,921.6,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",9216]
[null,"Lettuce",40,"Spring Late","Lettuce|40|Spring Late",0.34,783.36,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",7833.6]
[null,"Lettuce",50,"Fall Early","Lettuce|50|Fall Early",0.31,714.24,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",7142.4]
[null,"Lettuce",50,"Fall Late","Lettuce|50|Fall Late",0.43,990.72,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",{"$f":"G33*H33","v":9907.2000000000007}]
[null,"Lettuce",50,"Spring Early","Lettuce|50|Spring Early",0.31,714.24,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",{"$f":"G34*H34","v":7142.4}]
[null,"Lettuce",50,"Spring Late","Lettuce|50|Spring Late",0.56000000000000005,1290.2400000000002,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",12902.400000000001]
[null,"Mizuna",40,"Fall Early","Mizuna|40|Fall Early",0.35,806.4,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",8064]
[null,"Mizuna",40,"Fall Late","Mizuna|40|Fall Late",0.49,1128.96,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",11289.6]
[null,"Mizuna",40,"Spring Early","Mizuna|40|Spring Early",0.14000000000000001,322.56000000000006,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",3225.6000000000004]
[null,"Mizuna",40,"Spring Late","Mizuna|40|Spring Late",0.18,414.71999999999997,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",4147.2]
[null,"Mizuna",50,"Fall Early","Mizuna|50|Fall Early",0.14000000000000001,322.56000000000006,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",3225.6000000000004]
[null,"Mizuna",50,"Fall Late","Mizuna|50|Fall Late",0.19,437.76,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",4377.6000000000004]
[null,"Mizuna",50,"Spring Early","Mizuna|50|Spring Early",0.09,207.35999999999999,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",2073.6]
[null,"Mizuna",50,"Spring Late","Mizuna|50|Spring Late",0.14000000000000001,322.56000000000006,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",3225.6000000000004]
[null,"Spinach",40,"Fall Early","Spinach|40|Fall Early",0.28999999999999998,668.16,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",6681.5999999999995]
[null,"Spinach",40,"Fall Late","Spinach|40|Fall Late",0.28999999999999998,668.16,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",6681.5999999999995]
[null,"Spinach",40,"Spring Early","Spinach|40|Spring Early",0.28999999999999998,668.16,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",6681.5999999999995]
[null,"Spinach",40,"Spring Late","Spinach|40|Spring Late",0.28999999999999998,668.16,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",6681.5999999999995]
[null,"Spinach",50,"Fall Early","Spinach|50|Fall Early",0.23,529.92000000000007,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",5299.2000000000007]
[null,"Spinach",50,"Fall Late","Spinach|50|Fall Late",0.23,529.92000000000007,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",5299.2000000000007]
[null,"Spinach",50,"Spring Early","Spinach|50|Spring Early",0.23,529.92000000000007,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",5299.2000000000007]
[null,"Spinach",50,"Spring Late","Spinach|50|Spring Late",0.23,529.92000000000007,{"$f":"'Variable Costs'!$C$18","v":10},"per pound",5299.2000000000007]
[]
[]
["Fuel and Fixed costs"]
["Temperature set point (F)","Season","Planting",null,"Start week","End week","Weeks of greenhouse use","Fuel Use (gal)","Fuel cost ($3.23/gal)","Ajusted total fixed costs"]
["Lettuce|40","Fall","Early",{"$f":"A56&\" \"&B56&\" \"&C56","v":"Lettuce|40 Fall Early"},39,44,{"$f":"F56-E56","v":5},41.795665634674926,{"$f":"H56*3.23","v":135},{"$f":"('Fixed Costs'!$K$53*(G56/(20+G56)))","v":944.54016920000004}]
["Lettuce|40","Fall","Late","Lettuce|40 Fall Late",44,51,7,274.92260061919507,888.00000000000011,{"$f":"('Fixed Costs'!$K$53*(G57/(20+G57)))","v":1224.403923037037}]
["Lettuce|40","Winter","Early","Lettuce|40 Winter Early",4,11,7,719.50464396284826,2324,{"$f":"('Fixed Costs'!$K$53*(G58/(20)))","v":1652.9452960999997}]
["Lettuce|40","Winter","Late","Lettuce|40 Winter Late",12,16,4,145.51083591331269,470,{"$f":"('Fixed Costs'!$K$53*(G59/(20)))","v":944.54016920000004}]
["Lettuce|50","Fall","Early","Lettuce|50 Fall Early",39,44,5,139.3188854489164,450,{"$f":"('Fixed Costs'!$K$53*(G60/(20+G60)))","v":944.54016920000004}]
["Lettuce|50","Fall","Late","Lettuce|50 Fall Late",44,49,5,475.23219814241486,1535,{"$f":"('Fixed Costs'!$K$53*(G61/(20+G61)))","v":944.54016920000004}]
["Lettuce|50","Winter","Early","Lettuce|50 Winter Early",4,10,6,900.30959752321985,2908,{"$f":"('Fixed Costs'!$K$53*(G62/(20)))","v":1416.8102537999998}]
["Lettuce|50","Winter","Late","Lettuce|50 Winter Late",11,16,5,593.80804953560369,1918,{"$f":"('Fixed Costs'!$K$53*(G63/(20)))","v":1180.6752114999999}]
["Mizuna|40","Fall","Early","Mizuna|40 Fall Early",40,43,3,34.055727554179569,110.00000000000001,{"$f":"('Fixed Costs'!$K$53*(G64/(20+G64)))","v":616.00445817391301}]
["Mizuna|40","Fall","Late","Mizuna|40 Fall Late",44,49,5,196.90402476780187,636,{"$f":"('Fixed Costs'!$K$53*(G65/(20+G65)))","v":944.54016920000004}]
["Mizuna|40","Winter","Early","Mizuna|40 Winter Early",4,10,6,610.52631578947364,1971.9999999999998,{"$f":"('Fixed Costs'!$K$53*(G66/(20)))","v":1416.8102537999998}]
["Mizuna|40","Winter","Late","Mizuna|40 Winter Late",11,14,3,149.22600619195046,482,{"$f":"('Fixed Costs'!$K$53*(G67/(20)))","v":708.40512689999991}]
["Mizuna|50","Fall","Early","Mizuna|50 Fall Early",40,43,3,80.495356037151709,260,{"$f":"('Fixed Costs'!$K$53*(G68/(20+G68)))","v":616.00445817391301}]
["Mizuna|50","Fall","Late","Mizuna|50 Fall Late",44,50,6,401.85758513931887,1298,{"$f":"('Fixed Costs'!$K$53*(G69/(20+G69)))","v":1089.8540413846154}]
["Mizuna|50","Winter","Early","Mizuna|50 Winter Early",4,9,5,798.76160990712071,2580,{"$f":"('Fixed Costs'!$K$53*(G70/(20)))","v":1180.6752114999999}]
["Mizuna|50","Winter","Late","Mizuna|50 Winter Late",10,13,3,353.25077399380802,1141,{"$f":"('Fixed Costs'!$K$53*(G71/(20)))","v":708.40512689999991}]
["Spinach|40","Fall","Early","Spinach|40 Fall Early",39,43,4,37.151702786377697,119.99999999999996,{"$f":"('Fixed Costs'!$K$53*(G72/(20+G72)))","v":787.11680766666655}]
["Spinach|40","Fall","Late","Spinach|40 Fall Late",44,51,7,277.08978328173373,895,{"$f":"('Fixed Costs'!$K$53*(G73/(20+G73)))","v":1224.403923037037}]
["Spinach|40","Winter","Early","Spinach|40 Winter Early",4,10,6,610.52631578947364,1971.9999999999998,{"$f":"('Fixed Costs'!$K$53*(G74/(20)))","v":1416.8102537999998}]
["Spinach|40","Winter","Late","Spinach|40 Winter Late",11,15,4,194.11764705882354,627,{"$f":"('Fixed Costs'!$K$53*(G75/20))","v":944.54016920000004}]
["Spinach|50","Fall","Early","Spinach|50 Fall Early",39,43,4,119.19504643962848,385,{"$f":"('Fixed Costs'!$K$53*(G76/(20+G76)))","v":787.11680766666655}]
["Spinach|50","Fall","Late","Spinach|50 Fall Late",44,50,6,494.73684210526318,1598,{"$f":"('Fixed Costs'!$K$53*(G77/(20+G77)))","v":1089.8540413846154}]
["Spinach|50","Winter","Early","Spinach|50 Winter Early",4,9,5,830.34055727554176,2682,{"$f":"('Fixed Costs'!$K$53*(G78/(20)))","v":1180.6752114999999}]
["Spinach|50","Winter","Late","Spinach|50 Winter Late",10,13,3,353.25077399380802,1141,{"$f":"('Fixed Costs'!$K$53*(G79/20))","v":708.40512689999991}]

{"sheet":"Credits","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,1,42,12],[44,1,44,12],[9,1,11,12],[35,1,37,12],[38,1,38,12],[40,1,40,12]]}
[]
[null,"Enterprise Budget for bench-top production of salad greens "]
[]
[]
[]
[]
[]
[]
[]
[null,"This enterprise budget was prepared at the University of New Hampshire with data collected from 2011- 2013 through funding provided by the following organizations and the Specialty Crop Block Grant \"Feasibility of Using Existing Greenhouse Structures to Increase Production of Winter Vegetables and Herbs\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This enterprise budget was developed by the following contributors:"]
[]
[]
[null,"Claire Collie, graduate student, Claire.Collie@wildcats.unh.edu"]
[]
[null,"Michael R. Sciabarrasi, Extension Specialist, Agriculture Business Management, Mike.Sciabarrasi@unh.edu"]
[]
[null,"Becky Sideman, Extension Specialist, Sustainable Horticulture Production, Becky.Sideman@unh.edu"]
[]
[null,"Brian Krug, Extension Specialist, Greenhouse and Floriculture, brian.krug@unh.edu"]

{"sheet":"Crop List","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,4,18,4],[23,1,25,12],[6,5,6,6],[14,1,14,12],[7,1,12,12]]}
[]
[null,"Enterprise Budget for bench-top production of salad greens "]
[]
[]
[]
[]
[]
[null,"This enterprise budget aims to address the costs associated with producing salad greens grown on greenhouse bench-tops during the late fall and winter when New Hampshire markets often lack fresh produce.  Greenhouses used for seasonal bedding plant production go largely unused between October and February.  These greenhouses are usually equipped with growing benches that cannot be modified for traditional in-ground production.  Bench-top production of salad greens has two economic aims: First, provide a source of revenue during the off-season using a crop that generates sales greater than heating, labor and variable costs, and second, spread the fixed costs of the greenhouse infrastructure over another crop making the overall business more profitable. "]
[]
[]
[]
[]
[]
[]
[null,"How to use this budget: Use the top buttons to navigate between pages.  Any white area outlined in black can be edited to reflect your personal growing area. "]
[]
[]
[null,null,null,null,"Select a crop",null,"Crop list",null,null,"Select a ",null,"Temperature"]
[null,null,null,null,null,null,"Spinach",null,null,"growing temperature",null,40]
[null,null,null,null,null,null,"Lettuce",null,null,null,null,50]
[null,null,null,null,"Mizuna",null,"Mizuna",null,null,50]
[]
[]
[null,"We evaluated over 25 different salad greens in a bench-top system over a three year period.  We picked three species to budget enterprise budgets for.  These three greens represent the growth rate and habits of most cool temperature tolerant salad greens."]

{"sheet":"Variable Costs","index":3,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,5,6,6],[47,1,47,8],[15,1,15,8],[10,1,10,2]]}
[]
[null,"Enterprise Budget for bench-top production of salad greens "]
[]
[]
[]
[]
[null,null,"Crop",{"$f":"'Crop List'!E21","v":"Mizuna"},null,"Greenhouse temperature",null,{"$f":"'Crop List'!J21","v":50}]
[]
[]
[]
[null,"Greenhouse size ",null,"Length (ft)","Width (ft)","Area","Usable space","Growing area"]
[null,null,null,{"$f":"'Fixed Costs'!C13","v":96},{"$f":"'Fixed Costs'!D13","v":30},{"$f":"D12*E12","v":2880},{"$f":"'Fixed Costs'!F13","v":0.8},{"$f":"F12*G12","v":2304}]
[]
[]
[]
[null,"Gross Income Estimated gross income is based on the yield of these salad greens grown in Durham, NH during the fall and winter of 2012 and 2013. Estimated yield values are from salad greens harvested between 4 -5 inches for lettuce and mizuna, and 3 - 5 inches for spinach."]
[null,null,"Price per pound",null,"Planting","Yield (pounds per square foot)","Yield (pounds per greenhouse)","Total"]
[null,null,10,null,"Late September",{"$f":"VLOOKUP(K18,Calculations!$E$28:$F$51, 2)","v":0.14000000000000001},{"$f":"F18*$H$12","v":322.56000000000006},{"$f":"G18*$C$18","v":3225.6000000000004},null,"Fall Early",{"$f":"$D$7&\"|\"&$H$7&\"|\"&J18","v":"Mizuna|50|Fall Early"}]
[null,null,null,null,"Late October",{"$f":"VLOOKUP(K19,Calculations!$E$28:$F$51, 2)","v":0.19},{"$f":"F19*$H$12","v":437.76},{"$f":"G19*$C$18","v":4377.6000000000004},null,"Fall Late",{"$f":"$D$7&\"|\"&$H$7&\"|\"&J19","v":"Mizuna|50|Fall Late"}]
[null,null,null,null,"Late January",{"$f":"VLOOKUP(K20,Calculations!$E$28:$F$51, 2)","v":0.09},{"$f":"F20*$H$12","v":207.35999999999999},{"$f":"G20*$C$18","v":2073.6},null,"Spring Early",{"$f":"$D$7&\"|\"&$H$7&\"|\"&J20","v":"Mizuna|50|Spring Early"}]
[null,null,null,null,"Late March",{"$f":"VLOOKUP(K21,Calculations!$E$28:$F$51, 2)","v":0.14000000000000001},{"$f":"F21*$H$12","v":322.56000000000006},{"$f":"G21*$C$18","v":3225.6000000000004},null,"Spring Late",{"$f":"$D$7&\"|\"&$H$7&\"|\"&J21","v":"Mizuna|50|Spring Late"}]
[]
[]
[]
[null,"Production expenses"]
[null,null,"Object","Description","Price","Unit","Total cost","Total"]
[null,null,"Seeds",{"$f":"'Crop List'!E21","v":"Mizuna"},{"$f":"VLOOKUP(D27, Calculations!C8:F10, 2,FALSE)","v":33},{"$f":"VLOOKUP('Crop List'!E21,Calculations!C8:F10,3,FALSE)","v":"per pound"},{"$f":"VLOOKUP(D27,Calculations!C8:F10,4,FALSE)","v":57.024000000000001}]
[null,null,"Media","Living acres compost",6.1,"1 cb ft",{"$f":"(E28*2*(((H12*0.25)/27)/0.074))","v":3517.1171171171172}]
[null,null,"Media shipping",null,0.5,"per mile",70]
[null,null,"Bags","3000 20 x 12\" produce bags",55,null,55]
[null,null,null,null,null,null,null,{"$f":"SUM(G27:G30)","v":3699.1411171171171}]
[]
[]
[]
[null," Labor ",null,"Rate per hour",12.03]
[]
[null,null,null,"Activity","Time spent",null,"Subtotal","Total"]
[null,null,null,"tray filling",{"$f":"0.00875*H12","v":20.160000000000004},"hours",{"$f":"$E$35*E38","v":242.52480000000003}]
[null,null,null,"planting ",{"$f":"0.00641*H12","v":14.76864},"hours",177.66673919999999]
[null,null,null,"harvesting",{"$f":"0.003*H12","v":6.9119999999999999},"hours",83.151359999999997]
[null,null,null,"watering",{"$f":"0.0146*H12","v":33.638399999999997},"hours",404.66995199999997]
[null,null,null,"packing",{"$f":"(0.29/(60))*H12","v":11.135999999999999},"hours",133.96607999999998]
[null,null,null,"marketing",5,"hours",60.15]
[null,null,null,null,null,null,null,{"$f":"SUM(G38:G43)","v":1102.1289312000001}]
[]
[]
[]
[null,"Fuel use In this budget No. 2 heating oil is used as the source of fuel Fuel use for each crop of salad greens is based on Virtual Grower fuel use predictions for the length of time each crop is in the greenhouse.  Portsmouth, NH was used as the location in Virtual Grower.  Our empirical fuel use measurements were roughly half of those predicted by Virtual Grower.  Growers should calculate their own heating costs for the most accurate representation of fuel costs.  Virtual Grower can be downloaded from: http://www.ars.usda.gov/services/software/download.htm?softwareid=309"]
[null,null,null,null,"Fuel cost per gallon",3.23]
[]
[null,null,"Planting","Start week","End week","Weeks in greenhouse ","Fuel Use (gal)","Fuel cost "]
[null,null,"Late September",{"$f":"VLOOKUP(L52,Calculations!D56:H79,2)","v":40},{"$f":"VLOOKUP(L52,Calculations!D56:J79,3)","v":43},{"$f":"E52-D52","v":3},{"$f":"VLOOKUP(L52,Calculations!D56:J79,5)","v":80.495356037151709},{"$f":"G52*$F$49","v":260},null,"Fall","Early",{"$f":"$D$7&\"|\"&$H$7&\" \"&J52&\" \"&K52","v":"Mizuna|50 Fall Early"}]
[null,null,"Late October",{"$f":"VLOOKUP(L53,Calculations!D55:I79,2)","v":44},{"$f":"VLOOKUP(L53,Calculations!D56:J79,3)","v":50},{"$f":"E53-D53","v":6},{"$f":"VLOOKUP(L53,Calculations!D56:J79,5)","v":401.85758513931887},{"$f":"G53*$F$49","v":1298},null,"Fall","Late",{"$f":"$D$7&\"|\"&$H$7&\" \"&J53&\" \"&K53","v":"Mizuna|50 Fall Late"}]
[null,null,"Late January",{"$f":"VLOOKUP(L54,Calculations!D55:I79,2)","v":4},{"$f":"VLOOKUP(L54,Calculations!D56:J79,3)","v":9},5,{"$f":"VLOOKUP(L54,Calculations!D56:J79,5)","v":798.76160990712071},2580,null,"Winter","Early",{"$f":"$D$7&\"|\"&$H$7&\" \"&J54&\" \"&K54","v":"Mizuna|50 Winter Early"}]
[null,null,"Late March",{"$f":"VLOOKUP(L55,Calculations!D56:J79,2)","v":10},{"$f":"VLOOKUP(L55,Calculations!D56:J79,3)","v":13},3,{"$f":"VLOOKUP(L55,Calculations!D56:J79,5)","v":353.25077399380802},1141,null,"Winter","Late",{"$f":"$D$7&\"|\"&$H$7&\" \"&J55&\" \"&K55","v":"Mizuna|50 Winter Late"}]

{"sheet":"Fixed Costs","index":4,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[56,1,57,10],[6,5,6,6],[52,1,52,2],[22,7,22,9],[16,1,20,10]]}
[]
[null,"Enterprise Budget for bench-top production of salad greens "]
[]
[]
[]
[]
[null,null,"Crop",{"$f":"'Crop List'!E21","v":"Mizuna"},null,"Greenhouse temperature",null,{"$f":"'Crop List'!J21","v":50}]
[]
[]
[]
[]
[null,"Greenhouse size ","Length (ft)","Width (ft)","Area","Usable space","Growing area"]
[null,null,96,30,{"$f":"C13*D13","v":2880},0.8,{"$f":"E13*F13","v":2304}]
[]
[]
[]
[null,"Greenhouse investment costs Fixed costs, or ownership costs are not tied directly to an enterprise budget.  They are the costs that would exist even if the crop were not grown, so it is hard to assign expenses correctly. The prices used in this budget were collected in fall 2013.  Depreciation is a way of matching investment costs with the period of time used.  This budget uses straight-line deprecation and assumes no salvage value for investments at the end of their useful life. Interest on each investment cost is calculated by dividing investment costs by two and multiplying by 7%.  This convention assumes a grower would, on average, have half of the purchase cost tied up in the investment over its useful life."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Annual Charges"]
[null,null,null,"Amount or description","Price ",null,"Cost","Life - years","Depreciation","Interest (7%)","Annualized"]
[null,"Structure costs"]
[null,null,"Frame","Morton's 'H' Series Greenhouses",2560,null,{"$f":"E26","v":2560},10,{"$f":"G26*0.1","v":256},{"$f":"(G26/2)*0.07","v":89.600000000000009},{"$f":"SUM(I26:J26)","v":345.6}]
[null,null,"End walls","44 Hi-Core¨ XL Glazing Construction Panels",38.9,"per sheet",{"$f":"E27*44","v":1711.6},10,{"$f":"G27*0.1","v":171.16},{"$f":"(G27/2)*0.07","v":59.906000000000006},{"$f":"SUM(I27:J27)","v":231.066}]
[null,null,"Heaters","2 Heatmaster Oil Models 224000 BTU",{"$f":"4870","v":4870},"per unit",{"$f":"E28*2","v":9740},10,974,{"$f":"(G28/2)*0.07","v":340.90000000000003},1314.9]
[null,null,"Vents","2 Shaefer Powered Shutters - 48\" WS480",{"$f":"365","v":365},"per unit",{"$f":"2*E29","v":730},10,73,25.55,98.55]
[null,null,"Fans","2 Schaefer Motorized Shutter-WS360",{"$f":"300","v":300},"per unit",{"$f":"2*E30","v":600},10,60,21.000000000000004,81]
[null,null,"HAF fans","6 GreenTek 12\" HAF Fan",{"$f":"150.22","v":150.22},"per unit",{"$f":"6*E31","v":901.31999999999994},10,90.132000000000005,31.546200000000002,121.6782]
[null,null,"Inflation","Outside Air Inflation System",147.68,"per unit",{"$f":"E32","v":147.68},10,14.768000000000001,5.1688000000000009,19.936800000000002]
[null,"Plastic","Cover","6 Mil greenhouse poly  ",{"$f":"429.5","v":429.5},null,{"$f":"E33","v":429.5},5,{"$f":"G33*0.05","v":21.475000000000001},15.032500000000001,36.5075]
[null,null,null,"6 mil Tufflite Infrared Greenhouse Films ",606.89,null,{"$f":"E34","v":606.89},5,{"$f":"G34*0.05","v":30.3445},21.241150000000001,51.585650000000001]
[null,null,"Floor","Polypropylene Ground Cover ",{"$f":"1.5*2*90","v":270},null,{"$f":"E35","v":270},5,13.5,9.4500000000000011,22.950000000000003]
[null,null,"Trays","Dillen 13”x 17” nursery flat, 25/cn, ",50.96,"per 25 units",{"$f":"(E36/25)*(G13/1.625)","v":2890.1376},5,144.50688,101.15481600000001,245.66169600000001]
[null,null,"Benches","EZ grow pro  benches (4' x 8')",195,"per bench",{"$f":"(G13/32)*E37","v":14040},10,{"$f":"G37*0.1","v":1404},491.40000000000003,{"$f":"SUM(I37:J37)","v":1895.4}]
[null,"Misc. ","Scale","EZ Weight PX",150,null,{"$f":"E38","v":150},10,{"$f":"G38*0.1","v":15},5.2500000000000009,20.25]
[null,null,"clippers/knife","2 Needle nose shears",27,null,{"$f":"E39*2","v":54},5,{"$f":"G39*0.05","v":2.7},1.8900000000000001,4.59]
[null,null,"Harvest bins","4, 7 gallon tubtrug",13,null,{"$f":"E40*4","v":52},5,{"$f":"G40*0.05","v":2.6},1.8200000000000003,4.42]
[null,null,"Seeder","Vibro hand seeder",73,null,{"$f":"E41","v":73},10,{"$f":"G41*0.1","v":7.3000000000000007},2.5550000000000002,9.8550000000000004]
[null,null,"Washing","Dynamic salad spinner",250,null,{"$f":"E42","v":250},5,{"$f":"G42*0.05","v":12.5},8.75,21.25]
[null,null,"Greenhouse repairs",null,null,null,null,null,null,null,125]
[null,"Total",null,null,null,null,{"$f":"SUM(G26:G42)","v":35206.1276},null,{"$f":"SUM(I26:I42)","v":3292.9863799999998},{"$f":"SUM(J26:J42)","v":1232.2144660000001},{"$f":"SUM(K26:K43)","v":4650.2008459999997}]
[]
[]
[]
[null,"Land Investment",null,"Acres","Price ",null,"Cost",null,"Interest (4%)","Taxes and insurance","Annual cost"]
[null,null,null,0.1,5000,"per acre",{"$f":"D49*E49","v":500},null,{"$f":"G49*0.04","v":20},{"$f":"(G49*0.1)+(G49*0.005)","v":52.5},{"$f":"SUM(H49:J49)","v":72.5}]
[]
[]
[]
[null,"Total Annual investments",null,null,null,null,null,null,null,null,{"$f":"K49+K44","v":4722.7008459999997}]
[]
[]
[]
[null,"Adjusted fixed costs by seasonal planting The total investment cost above is adjusted to reflect just the number of weeks a crop of salad greens is in the greenhouse.  "]
[]
[null,null,null,"Planting","Start week","End week","Weeks in greenhouse","Seasonal fixed costs"]
[null,null,null,"Late September",{"$f":"VLOOKUP(N60,Calculations!D56:J79,2)","v":40},{"$f":"VLOOKUP(N60,Calculations!D56:J79,3)","v":43},{"$f":"F60-E60","v":3},{"$f":"('Fixed Costs'!K53*(G60/(20+G60)))","v":616.00445817391301},null,null,null,"Fall","Early",{"$f":"$D$7&\"|\"&$H$7&\" \"&L60&\" \"&M60","v":"Mizuna|50 Fall Early"}]
[null,null,null,"Late October",{"$f":"VLOOKUP(N61,Calculations!D56:J79,2)","v":44},{"$f":"VLOOKUP(N61,Calculations!D56:J79,3)","v":50},{"$f":"F61-E61","v":6},{"$f":"('Fixed Costs'!K53*(G61/(20+G61)))","v":1089.8540413846154},null,null,null,"Fall","Late",{"$f":"$D$7&\"|\"&$H$7&\" \"&L61&\" \"&M61","v":"Mizuna|50 Fall Late"}]
[null,null,null,"Late January",{"$f":"VLOOKUP(N62,Calculations!D56:J79,2)","v":4},{"$f":"VLOOKUP(N62,Calculations!D56:J79,3)","v":9},5,{"$f":"('Fixed Costs'!K53*(G62/(20)))","v":1180.6752114999999},null,null,null,"Winter","Early",{"$f":"$D$7&\"|\"&$H$7&\" \"&L62&\" \"&M62","v":"Mizuna|50 Winter Early"}]
[null,null,null,"Late March",{"$f":"VLOOKUP(N63,Calculations!D57:J88,2)","v":10},{"$f":"VLOOKUP(N63,Calculations!D56:J79,3)","v":13},3,{"$f":"('Fixed Costs'!K53*(G63/(20)))","v":708.40512689999991},null,null,null,"Winter","Late",{"$f":"$D$7&\"|\"&$H$7&\" \"&L63&\" \"&M63","v":"Mizuna|50 Winter Late"}]

{"sheet":"Outputs","index":5,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,1,15,1],[6,5,6,6]]}
[]
[null,"Enterprise Budget for bench-top production of salad greens "]
[]
[]
[]
[]
[null,null,"Crop",{"$f":"'Crop List'!E21","v":"Mizuna"},null,"Greenhouse temperature",null,{"$f":"'Crop List'!J21","v":50}]
[]
[]
[]
[]
[null,"Output","Planting","Gross income","Annual Expenses","Fuel cost","Operating interest","Seasonal fixed costs","Net returns","Net income above variable costs"]
[null,null,"Late September",{"$f":"'Variable Costs'!H18","v":3225.6000000000004},{"$f":"'Variable Costs'!$H$31+'Variable Costs'!$H$44","v":4801.2700483171175},{"$f":"'Variable Costs'!H52","v":260},{"$f":"(F13+'Variable Costs'!$H$31)*0.5*('Fixed Costs'!G60/52)*0.07","v":7.9944195634095649},{"$f":"'Fixed Costs'!H60","v":616.00445817391301},{"$f":"D13-(E13+H13+F13+G13)","v":-2459.6689260544399},{"$f":"D13-(E13+F13+G13)","v":-1843.6644678805269}]
[null,null,"Late October",{"$f":"'Variable Costs'!H19","v":4377.6000000000004},{"$f":"'Variable Costs'!$H$31+'Variable Costs'!$H$44","v":4801.2700483171175},{"$f":"'Variable Costs'!H53","v":1298},{"$f":"(F14+'Variable Costs'!$H$31)*0.5*('Fixed Costs'!G61/52)*0.07","v":20.180762203742209},{"$f":"'Fixed Costs'!H61","v":1089.8540413846154},{"$f":"D14-(E14+H14+F14+G14)","v":-2831.7048519054742},{"$f":"D14-(E14+F14+G14)","v":-1741.8508105208593}]
[null,null,"Late January",{"$f":"'Variable Costs'!H20","v":2073.6},{"$f":"'Variable Costs'!$H$31+'Variable Costs'!$H$44","v":4801.2700483171175},{"$f":"'Variable Costs'!H54","v":2580},{"$f":"(F15+'Variable Costs'!$H$31)*0.5*('Fixed Costs'!G62/52)*0.07","v":21.131724913374914},{"$f":"'Fixed Costs'!H62","v":1180.6752114999999},{"$f":"D15-(E15+H15+F15+G15)","v":-6509.4769847304924},{"$f":"D15-(E15+F15+G15)","v":-5328.8017732304925}]
[null,null,"Late March",{"$f":"'Variable Costs'!H21","v":3225.6000000000004},{"$f":"'Variable Costs'!$H$31+'Variable Costs'!$H$44","v":4801.2700483171175},{"$f":"'Variable Costs'!H55","v":1141},{"$f":"(F16+'Variable Costs'!$H$31)*0.5*('Fixed Costs'!G63/52)*0.07","v":9.7733618711018728},{"$f":"'Fixed Costs'!H63","v":708.40512689999991},{"$f":"D16-(E16+H16+F16+G16)","v":-3434.848537088219},{"$f":"D16-(E16+F16+G16)","v":-2726.4434101882189}]

{"sheet":"Comparison Charts","index":6,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[7,1,8,15]]}
[]
[null,"Enterprise Budget for bench-top production of salad greens "]
[]
[]
[]
[]
[]
[null,"The selling price of salad greens can change throughout the year, and can drastically change the potential income. The price of baby salad greens ranges from $8 to $15 per pound according to data collected by NOFA-NH and MOFGA in 2014.  Here we show the net income above variable costs of all three salad greens at a range of prices per pound."]
[]
[]
[]
[null,"Crop: Spinach","Temperature: 50  ",null,null,null,null,null,null,"Crop: Spinach","Temperature: 40  "]
[]
[null,"Price per pound",10,11,12,13,14,15,null,"Price per pound",10,11,12,13,14,15]
[null,"Planting",null,null,null,null,null,null,null,"Planting"]
[null,"Late September",-73.75675686320119,456.16324313679888,986.08324313679896,1516.003243136799,2045.9232431367991,2575.8432431367992,null,"Late September",1574.3567046752596,2242.5167046752595,2910.6767046752602,3578.8367046752601,4246.9967046752599,4915.1567046752598]
[null,"Late October",-1297.3891649823972,-767.46916498239716,-237.54916498239709,292.37083501760299,822.29083501760306,1352.2108350176031,null,"Late October",787.63972711184942,1455.7997271118493,2123.95972711185,2792.1197271118499,3460.2797271118498,4128.4397271118496]
[null,"Late January",-2381.3539224612605,-1851.4339224612604,-1321.5139224612603,-791.59392246126026,-261.67392246126019,268.24607753873988,null,"Late January",-290.49954959778279,377.66045040221707,1045.8204504022178,1713.9804504022177,2382.1404504022175,3050.3004504022174]
[null,"Late March",-828.4164181882179,-298.49641818821783,231.42358181178224,761.34358181178231,1291.2635818117824,1821.1835818117825,null,"Late March",1065.9917046752598,1734.1517046752597,2402.3117046752604,3070.4717046752603,3738.6317046752602,4406.79170467526]
[]
[]
[]
[null,"Crop: Lettuce","Temperature: 50  ",null,null,null,null,null,null,"Crop: Lettuce","Temperature: 40  "]
[]
[null,"Price per pound",10,11,12,13,14,15,null,"Price per pound",10,11,12,13,14,15]
[null,"Planting",null,null,null,null,null,null,null,"Planting"]
[null,"Late September",1804.3462498464305,2518.5862498464312,3232.8262498464319,3947.0662498464317,4661.3062498464315,5375.5462498464312,null,"Late September",2350.8063460002759,3088.0863460002765,3825.3663460002772,4562.646346000276,5299.9263460002767,6037.2063460002755]
[null,"Late October",3480.4948075387392,4471.2148075387386,5461.9348075387379,6452.6548075387391,7443.3748075387384,8434.0948075387387,null,"Late October",3662.599515265696,4607.2395152656954,5551.8795152656967,6496.5195152656961,7441.1595152656955,8385.7995152656968]
[null,"Late January",-666.42182898239844,47.818171017602253,762.05817101760294,1476.2981710176027,2190.5381710176025,2904.7781710176023,null,"Late January",1989.433746034927,2911.0337460349274,3832.6337460349278,4754.2337460349281,5675.8337460349267,6597.433746034927]
[null,"Late March",6091.4058652310478,7381.6458652310494,8671.8858652310482,9962.1258652310498,11252.365865231051,12542.605865231049,null,"Late March",2478.3339440598756,3261.6939440598762,4045.053944059875,4828.4139440598756,5611.7739440598762,6395.1339440598749]
[]
[]
[]
[null,"Crop: Mizuna","Temperature: 50  ",null,null,null,null,null,null,"Crop: Mizuna","Temperature: 40  "]
[]
[null,"Price per pound",10,11,12,13,14,15,null,"Price per pound",10,11,12,13,14,15]
[null,"Planting",null,null,null,null,null,null,null,"Planting"]
[null,"Late September",-1843.6644678805269,-1521.1044678805265,-1198.5444678805266,-875.98446788052661,-553.42446788052621,-230.86446788052672,null,"Late September",3145.0384167348575,3951.4384167348571,4757.8384167348568,5564.2384167348564,6370.6384167348579,7177.0384167348575]
[null,"Late October",-1741.8508105208593,-1304.09081052086,-866.33081052085981,-428.5708105208596,9.1891894791397135,446.94918947913993,null,"Late October",5837.7405344618155,6966.7005344618165,8095.6605344618156,9224.6205344618138,10353.580534461817,11482.540534461816]
[null,"Late January",-5328.8017732304925,-5121.4417732304928,-4914.0817732304931,-4706.7217732304925,-4499.3617732304929,-4292.0017732304932,null,"Late January",-3570.5727335977826,-3248.0127335977822,-2925.4527335977823,-2602.8927335977824,-2280.332733597782,-1957.7727335977825]
[null,"Late March",-2726.4434101882189,-2403.8834101882185,-2081.3234101882185,-1758.7634101882186,-1436.2034101882182,-1113.6434101882187,null,"Late March",-1144.5127371112967,-729.79273711129645,-315.0727371112971,99.647262888703153,514.36726288870341,929.08726288870275]