{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Assumptions","Zinnia Production Budget","Zinnia Input Calculations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"Introduction","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,1,26,13],[27,1,27,13],[28,1,28,13],[4,1,4,13],[6,1,6,6],[6,8,6,13],[7,1,7,6],[7,8,7,13],[8,1,8,13],[9,1,9,13],[5,1,5,13]]}
[]
[]
[]
[]
[null,"Zinnia Budget"]
[null,"Version 1.0"]
[null,"Rachel Painter",null,null,null,null,null,null,"Eryn Bell"]
[null,"Email: rpainter@utk.edu",null,null,null,null,null,null,"Email: ebell@utk.edu"]
[null,"Becky Bowling"]
[null,"Email: bowling10@utk.edu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Programs in agriculture and natural resources, 4-H youth development, family and consumer sciences, and resource development."]
[null,"University of Tennessee Institute of Agriculture, U.S. Department of Agriculture and country governments cooperating."]
[null,"UT Extension provide equal opportunities in programs and employment."]

{"sheet":"Assumptions","index":1,"n_rows":91,"n_cols":2,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,1,92,13],[52,1,53,13],[83,1,85,13],[87,1,88,13],[73,1,74,13],[75,1,75,13],[69,1,71,13],[76,1,78,13],[80,1,81,13],[38,1,39,13],[58,1,58,13],[63,1,64,13],[66,1,67,13],[55,1,56,13],[41,1,45,13],[47,1,50,13],[59,1,59,13],[46,1,46,13],[60,1,61,13],[32,1,36,13],[27,1,30,13],[1,1,1,13],[4,1,8,13],[9,1,13,13],[14,1,15,13],[16,1,17,13],[25,1,25,13],[18,1,23,13]]}
[]
[null,"Assumptions"]
[]
[]
[null,"This spreadsheet contains the 2025 University of Tennessee cut flower budget for Zinnias. Quantities and prices can be modified on the budget for any light blue cell. This spreadsheet should not be considered representative of all circumstances and is provided as a template or guide that can be used to estimate cost of production. Inputs used and prices for inputs vary tremendously from farm-to-farm; as such, producers are encouraged to use their own inputs, input prices, and cost structures for budgeting and planning purposes. "]
[]
[]
[]
[]
[null,"This budget assumes that this crop is part of a 1/4-acre cut flower operation (approximately 10,890 sq. ft.) managed by one full-time employee (40 hours per week), meaning the farm is assumed to have 5 production spaces of summer annual flowers grown on 1,000 square foot plots each. Expenses such as labor, utilities, equipment, and materials are shared across the entire operation, with each section bearing equal distribution of these costs (20%). This assumption allows for management and budgeting for a flower farm producing multiple flower types on a 1/4-acre plot."]
[]
[]
[]
[]
[null,"This budget assumes various zinnia varieties planted on 9 inch spacing for a seeding rate of approximately 1,780 seeds in a 1,000 sq. ft. plot. (333 ft. length, 3 ft wide bed, with 4 rows of seeds per bed). "]
[]
[null,"Variable Costs"]
[]
[null,"1The marketed rate represents the percentage of flower stems successfully sold after accounting for production losses and unsold inventory. Losses can occur from crop failure, transplant issues, harvest or post-harvest damage, and stems that remain unsold due to market limitations. Marketed rates typically vary depending on the producer’s production skills and experience, as well as anticipated market demand. Producers are encouraged to adjust the marketed rate to reflect experience and skills regarding management practices, crop conditions, and sales opportunities."]
[]
[]
[]
[]
[]
[]
[null,"2An average of 8 stems per plant assumed based on data from a 2024 UT cut flower study."]
[]
[null,"3An average price per stem for direct to consumer sales was estimated using the Tennessee Farmers Market Price Reports for various farmers markets as well as prices from experienced producers from across the state. As significant regional and seasonal price variability may exist, users are encouraged to adjust this price to reflect market conditions based on specific location, customer demand, and production to improve the accuracy of the budget calculations.  Source: https://arec.tennessee.edu/extension/tennessee-market-highlights/"]
[]
[]
[]
[]
[null,"4An assumption that all seeds are grown as transplants (plugs) by the producer for succession planting. Seed cost estimated as average cost of various varieties from common seed supplier prices. This estimate includes the average seed price calculated above and the cost of common growing medium, 606 black growing trays with 36 cells per tray, and energy use of a typical seed starting wire rack station using 16 T8, 18W, 4 ft. bulbs running for 16 hours per day for 2 months to grow transplants. The fixed cost of the wire rack station and bulbs are included in the general overhead fixed costs.  "]
[]
[]
[]
[]
[]
[null,"5For accurate fertilizer and lime recommendations, take a soil sample. An assumption of 20% of soil sample costs are distributed to this crop.  Source: https://soillab.tennessee.edu/soil-testing/field-soil-samples/"]
[]
[]
[null,"6Total fertilizer and pest control applications split over multiple applications. Fertilizer and pest control applications are representative of typical operations in Tennessee after proper testing and following current University of Tennessee Extension recommendations. Recommendations are current at time of publication and will be updated regularly; however, recommendations for agricultural inputs including pesticide registrations may be updated and inclusion in the budget should not be interpreted as a recommendation for use. Consult a county Extension agent for current application and control recommendations."]
[]
[]
[]
[]
[null,"County Extension office contact information available here."]
[null,"7Irrigation variable costs include water cost, driptape and attachments which would often be purchased annually. Irrigation is assumed to be set up as 3 ft wide beds with 2 drip lines of 5/8\", 6 mil drip tape with a flow rate of 0.5 gpm. Water cost is estimated for applying 1 inch of water per week with 12 in. emitter spacing and average of water cost calculated from both urban and rural cities costs per 1,000 gal across Tennessee. "]
[]
[]
[]
[]
[null,"8Staple and ground cover cost estimated for a 6 inch sod staple with a flat top to secure a 3.2 oz woven black ground cover. If no ground cover is used, ground cover and staple cost can be removed."]
[]
[]
[null,"9Flower netting costs include the purchase of 6-inch by 6-inch netting and step-in fence posts, which are used to support the netting for plant stabilization throughout the growing season."]
[]
[]
[null,"10Labor is estimated as one full time employee managing the 1/4 acre operation. Therefore, 20% of the employee's time would be devoted to this crop, resulting in 8 hours per week for the number of weeks spent producing the crop. This assumption was accurate based on labor hours from a UT cut flower study in 2024. Labor rate is the USDA Adverse Wage Rate for farm workers for 2025. "]
[null,"Source: https://flag.dol.gov/wage-data/adverse-effect-wage-rates#range"]
[null,"11Machinery repair and maintenance cost are estimated as 5% of purchase price of large equipment, with 20% of the cost allocated to this crop."]
[]
[]
[null,"12Fuel and propane estimated to prepare ground, burn holes into woven ground cover, and maintain grass rows between production spaces throughout growing season. Current average prices are estimated, but should be adjusted to reflect current relevant prices."]
[]
[]
[null,"13Typical harvest containers are assumed as a variable expense as some harvest containers may be damaged or provided for a customer for bulk purchases. Purchasing new harvest containers annually can assist with sanitation and be part of an integrated pest management strategy. "]
[]
[]
[null,"14Marketing cost are estimated at 20% of maximum gross sales. Marketing costs include packaging such as paper or plastic wrap, bands to secure stems, transportation to selling locations, promotional materials, and other costs not specified related to post-harvest and selling expenses."]
[]
[]
[]
[null,"15An operating interest for 6 months of operating capital is estimated at a current interest rate of 7% of all variable expenses. This should be adjusted to reflect current interest rates and considered an opportunity cost of capital being utilized for this enterprise."]
[]
[null,"Fixed Costs"]
[null,"16Small tools and equipment include shovels, rakes, a propane torch to burn holes in ground cover, a wheel barrow, hand pruners, gloves, loppers, hammers, mallets, and the main irrigation hookup equipment costs are estimated with a useful life of 3 years and 20% of calculated annual expenses allocated to this crop."]
[]
[]
[]
[null,"17Estimated cost of common tiller and lawn mower used for cut flower production and operation maintenance are calculated for the 1/4 acre operation with a useful life of 5 years and 20% of cost allocated to this crop."]
[]
[]
[null,"18Expenses for a storage and post-harvest handling building with dimensions of 15'X20'X16' are estimated with a useful life of 15 years, along with interest, insurance, property taxes, repairs on the building. This building would be used for the entire operation with 20% of the annual cost allocated to this crop."]
[]
[]
[]
[null,"19Returns to land, ownership, and capital are estimated at 10% of the total variable costs, reflecting the opportunity cost of utilizing the land and invested capital in the flower operation."]
[]
[]
[null,"20General overhead costs are estimated at 10% of total production costs of the budget. These costs include expenses not previously accounted for including the transplant starting wire rack and lights, general utilities, insurance, office supplies, administrative or professional support or fees. "]

{"sheet":"Zinnia Production Budget","index":2,"n_rows":169,"n_cols":5,"rows_kept":169,"cut":false,"hidden":false,"merged":[[0,0,0,4],[31,0,31,3],[41,0,41,3],[42,0,42,3],[44,0,44,3],[124,0,124,4],[155,0,155,3],[165,0,165,3],[166,0,166,3],[168,0,168,3]]}
["Zinnia Budget"]
["Flower Variety","Zinnia, Various Varieties"]
["Production Space",1000,"sq. ft."]
["Seeding Rate",1780,"seeds"]
["Marketed Rate1",0.65]
["Average Stems/ Plant2",8]
[]
["Gross Income","Unit","Quantity","$/Unit","Total Estimate"]
["Zinnia Stems3","Stem ",{"$f":"(B4*B5)*B6","v":9256},1,{"$f":"C9*D9","v":9256}]
[]
["Variable Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Transplants (growing plugs)4","plugs",1780,{"$f":"'Zinnia Input Calculations'!C$53","v":0.11258286516853933},{"$f":"C12*D12","v":200.39750000000001}]
["Soil Test5","test",0.2,15,{"$f":"C13*D13","v":3}]
["Fertilizer - 20-10-206","lb. ",{"$f":"'Zinnia Input Calculations'!F$57","v":10},{"$f":"'Zinnia Input Calculations'!I$57","v":1.5031999999999999},15.031999999999998]
["Fungicide - cost of 3 sprays throughout growing season6",null,null,null,{"$f":"'Zinnia Input Calculations'!M$87","v":8.3867499999999993}]
["Insecticide - cost of 4 sprays throughout growing season6",null,null,null,{"$f":"'Zinnia Input Calculations'!M$93","v":9.4849999999999994}]
["Irrigation Supplies7"]
["   Dripline purchased annually","linear ft.",{"$f":"'Zinnia Input Calculations'!E$102","v":666.66666666666663},{"$f":"'Zinnia Input Calculations'!H$102","v":4.9599999999999998E-2},{"$f":"C18*D18","v":33.066666666666663}]
["   Attachments purchased annually",null,1,{"$f":"'Zinnia Input Calculations'!H$125","v":67.06},67.06]
["   Operation of Irrigation ","water use in 1,000 gal.",{"$f":"'Zinnia Input Calculations'!K$129","v":13.926959999999999},{"$f":"'Zinnia Input Calculations'!L$129","v":6.8363333333333332},{"$f":"C20*D20","v":95.209340879999999}]
["Staples for Ground Cover8","staples",{"$f":"'Zinnia Input Calculations'!G$66","v":1000},{"$f":"'Zinnia Input Calculations'!D$68","v":7.7949999999999992E-2},{"$f":"D21*C21","v":77.949999999999989}]
["Black Woven Ground Cover8","ft.",1000,{"$f":"'Zinnia Input Calculations'!G$63","v":3.0013703703703706E-2},{"$f":"C22*D22","v":30.013703703703705}]
["Flower Netting9","sq. ft. ",1000,{"$f":"'Zinnia Input Calculations'!F$79","v":7.4999999999999997E-2},75]
["Stakes9 ","stakes",{"$f":"'Zinnia Input Calculations'!H$72","v":84},{"$f":"'Zinnia Input Calculations'!I$74","v":0.99666666666666681},83.720000000000013]
["Labor10","hours",{"$f":"'Zinnia Input Calculations'!F$137","v":112},{"$f":"'Zinnia Input Calculations'!C$139","v":15.87},1777.4399999999998]
["Machinery Repair and Maintenance (5%)11","1,000 sq. ft.",1,{"$f":"'Zinnia Input Calculations'!B$153","v":60},{"$f":"D26*C26","v":60}]
["Fuel12","gal.",{"$f":"'Zinnia Input Calculations'!H$175","v":6},{"$f":"'Zinnia Input Calculations'!E$176","v":3.75},{"$f":"C27*D27","v":22.5}]
["Propane12","lb. ",{"$f":"'Zinnia Input Calculations'!B$178","v":0.4},{"$f":"'Zinnia Input Calculations'!E$177","v":6.5},2.6]
["Harvest Containers13","each",10,{"$f":"'Zinnia Input Calculations'!D$133","v":2.0499999999999998},20.5]
["Marketing Costs (20% of Estimated Gross Income)14",null,null,{"$f":"E9*0.2","v":1851.2},{"$f":"D30","v":1851.2}]
["Operating Interest (7% of Variable Costs)15",null,7.0000000000000007E-2,{"$f":"(SUM(E12:E30)/2)","v":2216.2804806251852},{"$f":"D31*C31","v":155.13963364376298}]
["Total Variable Costs",null,null,null,{"$f":"SUM(E12:E31)","v":4587.7005948941332}]
[]
["Fixed Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Small Tools and Equipment16","Useful Life of 3 Years",1,{"$f":"'Zinnia Input Calculations'!B$171","v":102.14066666666668},{"$f":"C35*D35","v":102.14066666666668}]
["Tiller17","Model 732 Tiller",1,{"$f":"'Zinnia Input Calculations'!B$148","v":18.560000000000002},{"$f":"C36*D36","v":18.560000000000002}]
["Lawn Mower17 ","Mower 35\"",1,{"$f":"'Zinnia Input Calculations'!B$151","v":10.240000000000002},{"$f":"D37*C37","v":10.240000000000002}]
["Irrigation System Main Component Attachments",null,1,{"$f":"'Zinnia Input Calculations'!E$127","v":18.076666666666664},{"$f":"D38*C38","v":18.076666666666664}]
["Storage and Post-Harvest Handling Building18","(15'X20'X16')",1,{"$f":"'Zinnia Input Calculations'!N$185","v":166.96761422494117},{"$f":"C39*D39","v":166.96761422494117}]
["Returns to Land, Ownership, and Capital (10% of Variable Costs)19",null,null,{"$f":"E$32*0.1","v":458.77005948941337},{"$f":"D40","v":458.77005948941337}]
["General Overhead Cost (15% of Total Production Cost)20",null,null,{"$f":"(SUM($E$32,$E$35:$E$40))*0.15","v":804.36834029127306},{"$f":"D41","v":804.36834029127306}]
["Total Fixed Costs",null,null,null,{"$f":"SUM(E35:E41)","v":1579.1233473389609}]
["Total Specified Costs",null,null,null,{"$f":"E42+E32","v":6166.8239422330944}]
[]
["Returns Over Specified  Cost",null,null,null,{"$f":"E9-E43","v":3089.1760577669056}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zinnia Budget"]
["Flower Variety","Zinnia, Various Varieties"]
["Production Space",1000,"sq. ft."]
["Seeding Rate",1780,"seeds"]
["Crop Survival and Marketable Rate",0.65]
["Average Stems/ Plant",8]
[]
["Gross Income","Unit","Quantity","$/Unit","Total Estimate"]
["Zinnia Stems","Stem ",{"$f":"(B128*B129)*B130","v":9256},1,{"$f":"C133*D133","v":9256}]
[]
["Variable Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Transplants (growing plugs)","plugs",1780,{"$f":"'Zinnia Input Calculations'!C$53","v":0.11258286516853933},{"$f":"C136*D136","v":200.39750000000001}]
["Soil Test","test",0.2,15,{"$f":"C137*D137","v":3}]
["Fertilizer - 20-10-20","lb. ",{"$f":"'Zinnia Input Calculations'!F$57","v":10},{"$f":"'Zinnia Input Calculations'!I$57","v":1.5031999999999999},15.031999999999998]
["Fungicide - cost of 3 sprays throughout growing season",null,null,null,{"$f":"'Zinnia Input Calculations'!M$87","v":8.3867499999999993}]
["Insecticide - cost of 4 sprays throughout growing season",null,null,null,{"$f":"'Zinnia Input Calculations'!M$93","v":9.4849999999999994}]
["Irrigation Supplies"]
["   Dripline purchased annually","linear ft.",{"$f":"'Zinnia Input Calculations'!E$102","v":666.66666666666663},{"$f":"'Zinnia Input Calculations'!H$102","v":4.9599999999999998E-2},{"$f":"C142*D142","v":33.066666666666663}]
["   Attachments purchased annually",null,1,{"$f":"'Zinnia Input Calculations'!H$125","v":67.06},67.06]
["   Operation of Irrigation ","water use in 1,000 gal.",{"$f":"'Zinnia Input Calculations'!K$129","v":13.926959999999999},{"$f":"'Zinnia Input Calculations'!L$129","v":6.8363333333333332},{"$f":"C144*D144","v":95.209340879999999}]
["Staples for Ground Cover","staples",{"$f":"'Zinnia Input Calculations'!G$66","v":1000},{"$f":"'Zinnia Input Calculations'!D$68","v":7.7949999999999992E-2},{"$f":"D145*C145","v":77.949999999999989}]
["Black Woven Ground Cover","ft.",1000,{"$f":"'Zinnia Input Calculations'!G$63","v":3.0013703703703706E-2},{"$f":"C146*D146","v":30.013703703703705}]
["Flower Netting","sq. ft. ",1000,{"$f":"'Zinnia Input Calculations'!F$79","v":7.4999999999999997E-2},75]
["Stakes ","stakes",{"$f":"'Zinnia Input Calculations'!H$72","v":84},{"$f":"'Zinnia Input Calculations'!I$74","v":0.99666666666666681},83.720000000000013]
["Labor","hours",{"$f":"'Zinnia Input Calculations'!F$137","v":112},{"$f":"'Zinnia Input Calculations'!C$139","v":15.87},1777.4399999999998]
["Machinery Repair and Maintenance (5%) ","1,000 sq. ft.",1,{"$f":"'Zinnia Input Calculations'!B$153","v":60},{"$f":"D150*C150","v":60}]
["Fuel","gal.",{"$f":"'Zinnia Input Calculations'!H$175","v":6},{"$f":"'Zinnia Input Calculations'!E$176","v":3.75},{"$f":"C151*D151","v":22.5}]
["Propane ","lb. ",{"$f":"'Zinnia Input Calculations'!B$178","v":0.4},{"$f":"'Zinnia Input Calculations'!E$177","v":6.5},2.6]
["Harvest Containers","each",10,{"$f":"'Zinnia Input Calculations'!D$133","v":2.0499999999999998},20.5]
["Marketing Costs (20% of Estimated Gross Income)",null,null,{"$f":"E133*0.2","v":1851.2},{"$f":"D154","v":1851.2}]
["Operating Interest (7% of Variable Costs)",null,7.0000000000000007E-2,{"$f":"(SUM(E136:E154)/2)","v":2216.2804806251852},{"$f":"D155*C155","v":155.13963364376298}]
["Total Variable Costs",null,null,null,{"$f":"SUM(E136:E155)","v":4587.7005948941332}]
[]
["Fixed Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Small Tools and Equipment","Useful Life of 3 Years",1,{"$f":"'Zinnia Input Calculations'!B$171","v":102.14066666666668},{"$f":"C159*D159","v":102.14066666666668}]
["Tiller ","Model 732 Tiller",1,{"$f":"'Zinnia Input Calculations'!B$148","v":18.560000000000002},{"$f":"C160*D160","v":18.560000000000002}]
["Lawn Mower ","Mower 35\"",1,{"$f":"'Zinnia Input Calculations'!B$151","v":10.240000000000002},{"$f":"D161*C161","v":10.240000000000002}]
["Irrigation System Main Component Attachments",null,1,{"$f":"'Zinnia Input Calculations'!E$127","v":18.076666666666664},{"$f":"D162*C162","v":18.076666666666664}]
["Storage and Post-Harvest Handling Building","(15'X20'X16')",1,{"$f":"'Zinnia Input Calculations'!N$185","v":166.96761422494117},{"$f":"C163*D163","v":166.96761422494117}]
["Returns to Land, Ownership, and Capital (10% of Variable Costs) ",null,null,{"$f":"E$32*0.1","v":458.77005948941337},{"$f":"D164","v":458.77005948941337}]
["General Overhead Cost (15% of Total Production Cost)",null,null,{"$f":"(SUM($E$32,$E$35:$E$40))*0.15","v":804.36834029127306},{"$f":"D165","v":804.36834029127306}]
["Total Fixed Costs",null,null,null,{"$f":"SUM(E159:E165)","v":1579.1233473389609}]
["Total Specified Costs",null,null,null,{"$f":"E166+E156","v":6166.8239422330944}]
[]
["Returns Over Specified  Cost",null,null,null,{"$f":"E133-E167","v":3089.1760577669056}]

{"sheet":"Zinnia Input Calculations","index":3,"n_rows":185,"n_cols":16,"rows_kept":185,"cut":false,"hidden":true,"merged":[]}
[1000,"sq ft bed",{"$f":"'Zinnia Production Budget'!B4","v":1780},"seeding rate","3 ft wide by 333.3 ft long bed. 9 inch spacing means 4 rows of seeds per bed for approx 1,780 seeds"]
[]
["Planting Data "]
["Variety","Type","N Level","Succession","Number Planted","Survived","Square feet/plot","Per Plant Square Footage","Total Stems/Plot","Stems/ft2","Avg Stems/ft2/cultivar/N Level","Av Stems/ft2/Type","Av Stem/ft2/Type/MedN","Av Stem/ft2/Type/LowN"]
["Benary Mix ","Zinnia","Med",1,36,35,15,{"$f":"G5/E5","v":0.41666666666666669},263,{"$f":"I5/G5","v":17.533333333333335}]
["Benary Mix ","Zinnia","Med",2,30,30,13.5,0.45,194,14.37037037037037,{"$f":"AVERAGE(J5:J6)","v":15.951851851851853}]
["Benary Mix ","Zinnia","Low",1,28,27,13.5,0.48214285714285715,159,11.777777777777779]
["Benary Mix ","Zinnia","Low",2,22,21,9,0.40909090909090912,135,15,{"$f":"AVERAGE(J7:J8)","v":13.388888888888889}]
["QuLemPeach ","Zinnia","Med",1,31,31,15,0.4838709677419355,312,20.8]
["QuLemPeach ","Zinnia","Med",2,30,28,13.5,0.45,230,17.037037037037038,{"$f":"AVERAGE(J9:J10)","v":18.918518518518518}]
["QuLemPeach ","Zinnia","Low",1,42,35,18,0.42857142857142855,327,18.166666666666668]
["QuLemPeach ","Zinnia","Low",2,30,29,13.5,0.45,267,19.777777777777779,{"$f":"AVERAGE(J11:J12)","v":18.972222222222221}]
["Benary Lime ","Zinnia","Med",1,28,27,13.5,0.48214285714285715,221,16.37037037037037]
["Benary Lime","Zinnia","Med",2,30,29,13.5,0.45,212,15.703703703703704,{"$f":"AVERAGE(J13:J14)","v":16.037037037037038}]
["Benary Lime","Zinnia","Low",1,29,29,13.5,0.46551724137931033,209,15.481481481481481]
["Benary Lime","Zinnia","Low",2,29,26,13.5,0.46551724137931033,162,12,{"$f":"AVERAGE(J15:J16)","v":13.74074074074074}]
["QuLimeOrange","Zinnia","Med",1,25,23,12,0.48,220,18.333333333333332]
["QuLimeOrange","Zinnia","Med",2,30,30,13.5,0.45,247,18.296296296296298,{"$f":"AVERAGE(J17:J18)","v":18.314814814814817}]
["QuLimeOrange","Zinnia","Low",1,24,24,12,0.5,186,15.5]
["QuLimeOrange","Zinnia","Low",2,25,25,13.5,0.54,222,16.444444444444443,{"$f":"AVERAGE(J19:J20)","v":15.972222222222221}]
["Zinderella Peach","Zinnia","Med",1,30,30,15,0.5,308,20.533333333333335]
["Zinderella Peach ","Zinnia","Med",2,30,30,13.5,0.45,301,22.296296296296298,{"$f":"AVERAGE(J21:J22)","v":21.414814814814818}]
["Zinderella Peach","Zinnia","Low",1,35,35,15,0.42857142857142855,275,18.333333333333332]
["Zinderella Peach","Zinnia","Low",2,30,29,13.5,0.45,281,20.814814814814813,{"$f":"AVERAGE(J23:J24)","v":19.574074074074073},{"$f":"AVERAGE(J5:J24)","v":17.22851851851852},{"$f":"AVERAGE(K6,K10,K14,K18,K22)","v":18.127407407407411},{"$f":"AVERAGE(K8,K12,K16,K20,K24)","v":16.329629629629629}]
[null,null,null,null,{"$f":"SUM(E5:E24)","v":594},{"$f":"SUM(F5:F24)","v":573},null,{"$f":"SUM(H5:H24)/20","v":0.46160457988433512},{"$f":"SUM(I5:I24)","v":4731}]
[null,null,null,null,"Avg. Survival Rate ",{"$f":"F25/E25","v":0.96464646464646464},null,"Stems/Plant",{"$f":"I25/F25","v":8.2565445026178015}]
[]
["Stem Price Data "]
["Source","Price",null,"Producers","stems in bundle","price","price per stem"]
["https://www.menkveldfarm.com/flowers-by-the-bunch",1.2,null,null,10,9,{"$f":"F30/E30","v":0.9}]
["https://www.menkveldfarm.com/flowers-by-the-bunch",0.75]
["https://www.menkveldfarm.com/flowers-by-the-bunch",1,null,"price"]
["Memphis producer",{"$f":"G30","v":0.9},null,10]
["Average Price Per Stem ",{"$f":"AVERAGE(B30:B33)","v":0.96250000000000002}]
[]
["Seed Prices "]
["Seed Prices from Johnny's ","Number of Seeds","Price ","Average Seed Price"]
["Benary Mix ",500,20.7,{"$f":"SUM(C38:C42)/SUM(B38:B42)","v":5.1520000000000003E-2}]
["QuLemPeach ",500,29.5]
["Benary Lime ",500,20.7]
["QuLimeOrange",500,29.5]
["Zinderella Peach",500,28.4]
[]
[null,"Trays per bag","Trays needed","# Bags Needed","Price per bag","Price for Plugs for seed"]
["Promix 2.8 cu ft bags",40,50,{"$f":"C45/B45","v":1.25},21.79,{"$f":"D45*E45","v":27.237499999999997}]
["planting all as plugs"]
[]
["Growing Transplants cost addition to seed cost","For all plugs",null,"Cells per tray","Price Per Tray ","# of Trays","Total tray price"]
["Avg seed cost",{"$f":"C1*0.05","v":89},null,36,0.8,{"$f":"C45","v":50},{"$f":"E49*F49","v":40}]
["Growing Medium",{"$f":"F45","v":27.237499999999997},null,"bulbs","Wattage","hours run a day","Electricity cost per kwh",null,"Cost per month for 1 bulb","Cost per month for all bulbs","Months run"]
["Trays",{"$f":"G49","v":40},null,16,18,16,0.16,null,{"$f":"1.38","v":1.38},{"$f":"I51*D51","v":22.08},2,{"$f":"J51*K51","v":44.16}]
["Seed starting light energy use",{"$f":"L51","v":44.16}]
["Total cost of Transplants per Transplant",{"$f":"SUM(B49:B52)","v":200.39750000000001},{"$f":"B53/C1","v":0.11258286516853933}]
[]
["Fertilizer "]
["Fertilizer","Lbs. of actual N per 1,000 sq ft","N per bag","Lbs. in Bag","lbs of N in bag","Applying lbs of product","Receipt Price","Lbs. in Bag","Price/Lb."]
["Medium appl of fertilizer - 20-10-20",2,0.2,25,{"$f":"D57*C57","v":5},{"$f":"B57*E57","v":10},37.58,25,{"$f":"G57/H57","v":1.5031999999999999}]
["*Note: 2 pounds of nitrogen per 1,000 sq ft is medium fertilization split over 8 applications total"]
[]
["Ground Cover"]
["Ground Cover","width","length","Total sq ft","price each",null,"Price per sq ft","Total sq ft used"]
["DeWitt 3.2 oz Sunbelt, Woven Ground Cover Black 6 ft by 300",6,300,{"$f":"B62*C62","v":1800},162.07400000000001,null,{"$f":"E62/D62","v":9.0041111111111113E-2},1000]
[null,null,null,null,null,null,{"$f":"G62/3","v":3.0013703703703706E-2},"Lats 3 Years"]
["Staples"]
["Staples","Total Bought","Cost","Cost per Staple ","Staples per Sq. Ft.","Total Sq. Ft. ","Total # Staples"]
["Pro trade 6 inch sod staple flat top",300,18,{"$f":"C66/B66","v":0.06},1,1000,{"$f":"F66*E66","v":1000}]
[null,100,9.59,{"$f":"C67/B67","v":9.5899999999999999E-2}]
[null,null,"avg",{"$f":"(D67+D66)/2","v":7.7949999999999992E-2}]
[]
["Flower Stakes"]
[null,"Price per Stake ","Stakes every 8 Ft. ","Stakes on Sides in Ft. ","Width of Bed in Ft. ","1000 Sq. Ft.","# of Sections of Stakes ","Stakes Needed","Total Price of Stakes "]
["Step in fence post TSC, 2 inch, 4 ft tall",2.99,8,2,3,{"$f":"1000/E72","v":333.33333333333331},{"$f":"F72/C72","v":41.666666666666664},84,{"$f":"H72*B72","v":251.16000000000003}]
[null,null,null,null,null,null,null,null,{"$f":"I72/3","v":83.720000000000013},"Lasts for Three Years"]
[null,null,null,null,null,null,null,null,{"$f":"I73/H72","v":0.99666666666666681},"Per Stake "]
[]
["Flower Netting"]
[null,"Roll Width in ft","Roll Length in ft","Roll Total sq ft","% of Roll Needed ","Netting Roll Price"]
["Tenax plant support 6\"X6\"",4,328,{"$f":"B78*C78","v":1312},{"$f":"1000/D78","v":0.76219512195121952},75]
[null,null,null,null,null,{"$f":"F78/1000","v":7.4999999999999997E-2},"Per Square Foot "]
[]
["Fungicide"]
["Fungicide","number of sprays","max application rate tbspoon per 1 gallon of water","tablespoon in an oz","application rate per 1 gal water in oz",null,"Gallons per 1,000 sq ft","Total amount in oz to apply per growing",null,"Price for product","oz in bottle","price per oz","Total cost for application per season",null,null,"Links"]
["Chlorothalonil Daconil -site one commercial",3,null,null,3.6,null,1,{"$f":"(E83*G83)*B83","v":10.8},null,210,320,{"$f":"J83/K83","v":0.65625},{"$f":"H83*L83","v":7.0875000000000004},"using smaller bottles instead of commercial price here",null,"https://www.siteone.com/71418fung-daconil-weatherstik-fungicide-25-gal-agency/p/769562?store=454&cid=lia|siteone_2023_pest_XXXXX|{adgroup}|google&ds_k=&xmid=xm_%ebuy!_%25epid!_%ecid!&gad_source=1&gclid=Cj0KCQiA88a5BhDPARIsAFj595jFwv5HpkzBFqanxnnpc2uCP3M6wCFNlwqbts9ryoiWxF07CwchDZcaAokhEALw_wcB"]
["chlorothalonil - daconil",2,3,0.5,{"$f":"C84*D84","v":1.5},null,1,{"$f":"(E84*G84)*B84","v":3},null,17.16,16,{"$f":"J84/K84","v":1.0725},{"$f":"H84*L84","v":3.2175000000000002},null,null,"https://www.homedepot.com/p/Daconil-16-oz-Concentrate-Fungicide-100536524/202268570"]
["Copper - capt jack's",1,null,null,2,null,2.2999999999999998,{"$f":"(E85*G85)*B85","v":4.5999999999999996},null,17.98,16,{"$f":"J85/K85","v":1.12375},{"$f":"H85*L85","v":5.1692499999999999},null,null,"https://www.homedepot.com/p/Bonide-Captain-Jack-s-Copper-Fungicide-16-oz-Concentrate-for-Organic-Gardening-Controls-Common-Diseases-811/203911375"]
[]
[null,"copper - 1.1 to 2.3 gallons of diluted spray per 1,000 sq ft is application rate with 0.5 to 2.0 fluid oz of product range mixed in. took max for both",null,null,null,null,null,null,null,null,null,null,{"$f":"M84+M85","v":8.3867499999999993},"total fung app per season"]
[null,"1 gal per 1,000 sq ft. in rule of thumb for spraying for leaf coverage from Celeste. For daconil commercial product, 3.6 oz per 1,000 sq foot is application rate for single application recommendation from label."]
[null,"spray for leaf runoff, spot spraying"]
[]
["Insecticide"]
[null,"nu of sprays",null,null,"application rate per 1 gal water in oz",null,"gallons per 1,000 sq ft","total amount in oz to apply per growing",null,"Price for product","oz in bottle","price per oz","Total cost for application per season"]
["Sevin liquid - zetacypermethrin",4,null,null,4,null,1,{"$f":"(E93*G93)*B93","v":16},null,18.97,32,{"$f":"J93/K93","v":0.59281249999999996},{"$f":"H93*L93","v":9.4849999999999994},null,null,"https://www.homedepot.com/p/Sevin-32-oz-16-000-sq-ft-Outdoor-Lawn-and-Garden-Insect-Killer-Concentrate-3-Month-Control-100530123/303593798"]
["separate sprays or tank mixed?"]
[null,null,null,null,null,null,null,null,null,"knoxville seed and supply"]
[]
["Irrigation System"]
[null,"total sq ft"]
["3 ft wide beds, 2 lines, 200 linear feet of tape of that, so if it is 3 ft wide, 666.67 linear feet of tape",1000]
[]
["Variable only one year use:","Bed widthin ft","bed length in ft","number of lines in bed","Linear ft of driptape needed","Price of driptape","Length in ft","Price per ft of driptape"]
["Driptape - toro aqua-trax 5/8\", 6 mil, 8 in, 0.5 gpm, 2500'",6,{"$f":"B99/B102","v":166.66666666666666},4,{"$f":"C102*D102","v":666.66666666666663},124,2500,{"$f":"F102/G102","v":4.9599999999999998E-2}]
[]
["Irrigation Attachments"]
[null,null,"Useful Life for Fixed Costs",3,"Years"]
["From Irrigation King receipt Celeste","Totalquantity from Celeste","quantity for 1,000 ","price each unit","Fixed cost",null,"Annual Purchase - Variable Costs"]
["5/8\" tape swivel X 5/8\" tape swivel repair coupler",10,5,3.5,{"$f":"C107*D107","v":17.5},null,5,{"$f":"G107*D107","v":17.5}]
["8 mm punch red handle",1,1,6.95,6.95,null,null,0]
["5/8\" tape end plug",20,8,5.2,41.6,null,2,10.4]
["starter mini-valve 10mm barb x 5/8\" tape swivel",20,8,14.6,116.8,null,2,29.2]
["3/4\" permaloc elbow 800 series",1,1,3.69,3.69,null,null,0]
["3/4\" permaloc x 3/4\" MHT w cap plug 800 series",2,1,4.3,4.3,null,null,0]
["3/4\" permaloc coupler 800 series",2,1,4.32,4.32,null,null,0]
["3/4\" permaloc x 3/4\" FHT 800 series",2,1,6.06,6.06,null,null,0,null,null,"City","Water prices per 1,000 gallons"]
["3/4\" permaloc x 3/4 MPT 800 series",2,1,2.76,2.76,null,null,0,null,null,"Lebanon",10.968]
[null,null,null,null,0,null,null,0,null,null,"Murfreesboro",3.66]
["From Dripworks receipt Celeste",null,null,null,0,null,null,0,null,null,"Bristol",6.28]
["Mainline 3/4\" poly tubing - 100 ft",1,1,31.95,31.95,null,null,0,null,null,"Springfield",6.58]
["3/4 easy loc coupler",2,null,4.9800000000000004,0,null,2,9.9600000000000009,null,null,"Fayetteville",7.83]
["3/4\" easy loc elbow",2,1,7.78,7.78,null,null,0,null,null,"Clinton",5.7]
["3/4\" easy loc x male hose end",1,1,1.59,1.59,null,null,0,null,null,"State average",{"$f":"AVERAGE(L115:L120)","v":6.8363333333333332}]
["3/4\" easy loc tee ",1,1,5.95,5.95,null,null,0]
["3/4\" easy loc valve",1,1,4.95,4.95,null,null,0,null,null,"Days to Maturity",null,"avg days to maturity"]
["shipping - do we include? (none on irrigation king)",null,1,14.95,14.95,null,null,0,null,null,75,90,{"$f":"AVERAGE(K124:L124)","v":82.5}]
[null,null,"Total fixed cost",null,{"$f":"SUM(E107:E124)","v":271.14999999999998},null,"Total",{"$f":"SUM(H107:H124)","v":67.06},null,null,null,null,{"$f":"M124/7","v":11.785714285714286}]
[null,null,null,"3 Year Spread",{"$f":"E125/D105","v":90.383333333333326},null,null,null,null,null,null,null,{"$f":"ROUNDUP(M125,0)","v":12},"12 weeks to maturity"]
[null,null,null,null,{"$f":"E126*0.2","v":18.076666666666664}]
["Irrigation Usage Cost","Inches of water to deliver","Hours to run to deliver water","minutes run","Feet of driptape","Gallons per minute emitted","Total gallons emitted per minute for 1,000 sq feet","Gallons per week","Weeks to water (weeks to maturity from planting divided by 2)","Total Gallons","Thousand gallons","Price per 1,000 gallon of water"]
["0.5 GPM drip line at 12” emitter spacing",1,{"$f":"5.8","v":5.8},{"$f":"C129*60","v":348},666.67,0.5,6.67,{"$f":"G129*D129","v":2321.16},{"$f":"M126/2","v":6},{"$f":"H129*I129","v":13926.96},{"$f":"J129/1000","v":13.926959999999999},{"$f":"L121","v":6.8363333333333332},{"$f":"L129*K129","v":95.209340879999999}]
[null,null,"Penn state: https://extension.psu.edu/determining-how-long-to-run-drip-irrigation-systems-for-vegetables"]
["Harvest Containers"]
[null,"Number of containers","10 L, 10 count johnnys","price each bucket","total cost"]
["Harvest containers",100,20.5,{"$f":"C133/10","v":2.0499999999999998},{"$f":"B133*D133","v":204.99999999999997},"https://www.johnnyseeds.com/tools-supplies/cut-flower-supplies/flower-buckets/flower-buckets-10-l-10-count-7824.html"]
[]
["Labor Based on 1/4 acre operation, one full time employee"]
[null,"Hours per week for 1/4 acre","Number of crops in 1/4 acre at one time","Hours per wk devoted to this crop","Avg Number of weeks to produce this crop","Total hours devoted to crop"]
[null,40,5,{"$f":"B137/C137","v":8},{"$f":"M126+2","v":14},{"$f":"D137*E137","v":112},null,"Weeks to produce this crop determined from weeks to maturity of the crop from planting"]
[]
[null,"Labor rate",15.87,"https://flag.dol.gov/wage-data/adverse-effect-wage-rates#range"]
[]
[]
["Land Rent "]
["Land - cash rent","1,000 sq. ft. ",1,25,"Cash rental rates are based on the 2022 USDA-NASS reported cash rental rates for irrigated cropland in Tennessee ($187/acre)."]
[]
["Large Equipment "]
["Tiller ",4000,"5 Year Depreciation ",{"$f":"B146*0.42","v":1680},"https://www.bcsamerica.com/product/model-732"]
[null,{"$f":"((B146-D146)/5)*0.2","v":92.800000000000011},"Per Year ","Salvage Value"]
["*Sharing cost with other sections of 1/4 acre",{"$f":"B147*0.2","v":18.560000000000002}]
["Lawn Mower ",2000,"5 Year Depreciation ",{"$f":"B149*0.36","v":720},"https://www.foards.com/collections/bad-boy-mowers/products/bby25fj180"]
[null,{"$f":"((B149-D149)/5)*0.2","v":51.2},"Per Year ","Salvage Value"]
["*Sharing cost with other sections of 1/4 acre",{"$f":"B150*0.2","v":10.240000000000002}]
[]
["Machinery Repair and Maintenance 5% ",{"$f":"((B146+B149)*0.05)*0.2","v":60}]
[]
["Small Equipment "]
["- EcoCart Hookup Kit ",692.11,null,null,null,null,"QC Supply "]
["- Mulch Hole Burner",350,null,null,null,null,"https://www.johnnyseeds.com/tools-supplies/mulches-and-weed-barrier/mulch-tools-accessories/mulch-hole-burners/mulch-hole-burner-starter-kit-7664.0.html?utm_source=google&utm_medium=cpc&utm_campaign=BL%20|%20PMAX%20|%20Tools%20&%20Supplies&utm_keyword=&gad_source=1&gclid=CjwKCAiA6t-6BhA3EiwAltRFGM_mVcoh-t7zeG2pT1Q5rWVXhXudQjk49l5oKaiZk0BBQfONmWn3pxoC2K4QAvD_BwE"]
["- Craftsman Large Shovels (2) $25",50,null,null,null,null,"https://www.lowes.com/pd/CRAFTSMAN-45-in-Wood-Handle-Digging-Shovel/5015343867"]
["- Craftsman Large Heavy Rake (1) $25",25,null,null,null,null,"Lowes"]
["- Craftsman Leaf Rake (1) $25",25,null,null,null,null,"Lowes"]
["- Craftsman Garden Hoe (1) $25",25,null,null,null,null,"Lowes"]
["- Craftsman Stirrup Hoe (1) $28",28,null,null,null,null,"Lowes"]
["- Craftsman Wheel Barrow (1) $120",120,null,null,null,null,"Lowes"]
["- Fiskars Hand Pruners (2) $30 ",60,null,null,null,null,"Lowes"]
["- Fiskars Lopper (1) ",35,null,null,null,null,"Lowes"]
["- Garden Hand Tool Set (1) ",50,null,null,null,null,"Lowes"]
["- Garden Gloves (2) ",40,null,null,null,null,"https://www.lowes.com/pd/Miracle-Gro-SYNTH-LEATHER-HI-DEX-GLOVES-M/1002630254"]
["- Rubber Mallet (staples) ",20]
["- Hammer (2) $6",12]
["Total ",{"$f":"SUM(B156:B169)","v":1532.1100000000001},"Lasts for 3 Years "]
["*Sharing cost with other sections of 1/4 acre",{"$f":"(B170/3)*0.2","v":102.14066666666668}]
[]
["Fuel "]
[null,null,null,"Gallons","Price per Gallon",null,null,"total fuel use in gal"]
["Lawn Mower for 1,000 sq. ft. ",".1 Gallons ","Mow 24 Times ",{"$f":"0.1*24","v":2.4000000000000004},3.75,{"$f":"D175*E175","v":9.0000000000000018},{"$f":"ROUNDUP(D175,0)","v":3},{"$f":"G175+D176","v":6}]
["Tiller for 1,000 sq. ft. ",".75 Gallons","4 Passes ",{"$f":"0.75*4","v":3},3.75,{"$f":"D176*E176","v":11.25}]
["Propane for Mulch Burner (1lb. Propane Cylinder) 20% (in lbs)",2,13,null,{"$f":"C177/B177","v":6.5},{"$f":"(13)*0.2","v":2.6},"https://www.lowes.com/pd/BernzOmatic-1-lb-2-Pack-Pre-Filled-Propane-Tank/50235565"]
[null,{"$f":"B177*0.2","v":0.4},null,null,"Total",{"$f":"SUM(F175:F177)","v":22.85}]
["Building  Expenses"]
[null,"Purchase",null,null,"Salvage","Salvage","Average","Useful",null,"Interest",null,null,"Property"]
["Item","Price","Units","Cost","Percent","Value","Value","Life","Depreciation","Rate","Interest","Insurance","Tax","Repairs"]
["Storage and Post Harvest Handling Building (15'X20'X16')",10000,1,{"$f":"B182*C182","v":10000},0.25,{"$f":"D182*E182","v":2500},{"$f":"(D182+F182+I182)/2","v":6500},15,{"$f":"(D182-F182)/H182","v":500},7.0000000000000007E-2,{"$f":"(CUMIPMT(J182,5,B182,1,5,1)/20)*-1","v":69.838071124705863},{"$f":"G182*0.005","v":32.5},{"$f":"G182*0.005","v":32.5},{"$f":"D182*0.02","v":200}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Annual Cost for 1/4 acre operation",{"$f":"I182+K182+L182+M182+N182","v":834.83807112470583}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Annual Cost for this crop (20% of total)",{"$f":"N184*0.2","v":166.96761422494117}]