{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Assumptions","Sunflower Production Budget","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,"Sunflower 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":92,"n_cols":2,"rows_kept":92,"cut":false,"hidden":false,"merged":[[61,1,62,13],[91,1,93,13],[51,1,52,13],[84,1,86,13],[88,1,89,13],[73,1,74,13],[76,1,76,13],[64,1,65,13],[67,1,68,13],[70,1,71,13],[77,1,79,13],[81,1,82,13],[57,1,58,13],[59,1,59,13],[40,1,44,13],[46,1,49,13],[32,1,35,13],[45,1,45,13],[54,1,55,13],[39,1,39,13],[37,1,38,13],[24,1,27,13],[29,1,30,13],[1,1,1,13],[4,1,8,13],[9,1,13,13],[14,1,15,13],[16,1,17,13],[18,1,22,13],[23,1,23,13]]}
[]
[null,"Assumptions"]
[]
[]
[null,"This spreadsheet contains the 2025 University of Tennessee cut flower budget for Single-Stem Varieties of Sunflowers. 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 flower 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 single stem sunflower varieties planted on 6 inch spacing for a seeding rate of 4,000 seeds in a 1,000 sq. ft. plot. (333 ft. length, 3 ft. wide bed, with 6 rows of seeds per bed)."]
[]
[null,"Variable Costs"]
[]
[null,"1 The 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 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, kusers 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,"3An assumption that half (2,000 seeds) are direct-seeded and half of production grown as transplants (plugs) by the producer for succession planting. Seed cost estimated as average cost of single-stem sunflower varieties from common seed supplier prices. "]
[]
[]
[null,"4Half of seeds grown as transplants by producer assumed (2,000 seeds). 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 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":"Sunflower 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]]}
["Sunflower Budget"]
["Flower Variety","Sunflower, Single Stem Varieties"]
["Production Space",1000,"sq. ft."]
["Seeding Rate",4000,"seeds"]
[" Marketed Rate1",0.7]
[]
["Gross Income","Unit","Quantity","$/Unit","Total Estimate"]
["Sunflower Stems2","Stem ",{"$f":"B$4*B$5","v":2800},{"$f":"'Input Calculations'!$H$25","v":1.7000000000000002},{"$f":"C8*D8","v":4760.0000000000009}]
[]
["Variable Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Seed3","seed",{"$f":"B4/2","v":2000},{"$f":"'Input Calculations'!D$34","v":3.6800000000000006E-2},{"$f":"C11*D11","v":73.600000000000009}]
["Transplants (growing plugs)4","plugs",{"$f":"B4/2","v":2000},{"$f":"'Input Calculations'!C$57","v":9.9733000000000002E-2},199.46600000000001]
["Soil Test5","test",0.2,15,3]
["Fertilizer - 20-10-206","lb. ",{"$f":"'Input Calculations'!G$94","v":10},{"$f":"'Input Calculations'!K$94","v":1.5031999999999999},15.031999999999998]
["Fungicide - cost of 3 sprays throughout growing season6",null,null,null,{"$f":"'Input Calculations'!L$85","v":8.3867499999999993}]
["Insecticide - cost of 4 sprays throughout growing season6",null,null,null,{"$f":"'Input Calculations'!L$90","v":9.4849999999999994}]
["Irrigation Supplies7"]
["   Dripline purchased annually","linear ft.",{"$f":"'Input Calculations'!E$102","v":666.66666666666663},{"$f":"'Input Calculations'!K$102","v":4.9599999999999998E-2},{"$f":"C18*D18","v":33.066666666666663}]
["   Attachments purchased annually",null,1,{"$f":"'Input Calculations'!H$126","v":67.06},67.06]
["   Operation of Irrigation ","water use in 1,000 gal.",{"$f":"'Input Calculations'!K$131","v":9.8649300000000011},{"$f":"'Input Calculations'!L$131","v":6.8363333333333332},{"$f":"C20*D20","v":67.43994979}]
["Staples for Ground Cover8","staples",{"$f":"'Input Calculations'!H$66","v":1000},{"$f":"'Input Calculations'!D$68","v":7.7949999999999992E-2},{"$f":"D21*C21","v":77.949999999999989}]
["Black Woven Ground Cover8","ft.",1000,{"$f":"'Input Calculations'!G$64","v":3.0013703703703706E-2},{"$f":"C22*D22","v":30.013703703703705}]
["Flower Netting9","sq. ft. ",1000,{"$f":"'Input Calculations'!J$74","v":7.4999999999999997E-2},75]
["Stakes9","stakes",{"$f":"'Input Calculations'!L$72","v":84},{"$f":"'Input Calculations'!C$72","v":0.9966666666666667},83.72]
["Labor10","hours",{"$f":"'Input Calculations'!F$150","v":68},15.87,1079.1599999999999]
["Machinery Repair and Maintenance (5%)11","1,000 sq. ft.",1,{"$f":"'Input Calculations'!B$166","v":60},{"$f":"D26*C26","v":60}]
["Fuel12","gal.",{"$f":"'Input Calculations'!I$190","v":6},{"$f":"'Input Calculations'!E$190","v":3.75},{"$f":"C27*D27","v":22.5}]
["Propane12","lb. ",{"$f":"'Input Calculations'!B$193","v":0.4},null,0]
["Harvest Containers13","each",10,{"$f":"'Input Calculations'!D$155","v":2.0499999999999998},20.5]
["Marketing Costs (20% of Estimated Gross Income)14",null,null,{"$f":"E8*0.2","v":952.00000000000023},{"$f":"D30","v":952.00000000000023}]
["Operating Interest (7% of Variable Costs)15",null,7.0000000000000007E-2,{"$f":"(SUM(E11:E30)/2)","v":1438.6900350801852},{"$f":"D31*C31","v":100.70830245561298}]
["Total Variable Costs",null,null,null,{"$f":"SUM(E11:E31)","v":2978.0883726159836}]
[]
["Fixed Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Small Tools and Equipment16","Useful Life of 3 Years",1,{"$f":"'Input Calculations'!B$187","v":102.14066666666668},{"$f":"C35*D35","v":102.14066666666668}]
["Tiller17","Model 732 Tiller",1,{"$f":"('Input Calculations'!B$163)*0.2","v":18.560000000000002},{"$f":"C36*D36","v":18.560000000000002}]
["Lawn Mower17","Mower 35\"",1,{"$f":"('Input Calculations'!B$165)*0.2","v":10.240000000000002},{"$f":"D37*C37","v":10.240000000000002}]
["Irrigation System Main Component Attachments",null,1,{"$f":"'Input Calculations'!E$128","v":18.076666666666664},{"$f":"D38*C38","v":18.076666666666664}]
["Storage and Post-Harvest Handling Building18","(15'X20'X16')",1,{"$f":"'Input Calculations'!N$204","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":297.8088372615984},{"$f":"D40","v":297.8088372615984}]
["General Overhead Cost (15% of Total Production Cost)20",null,null,{"$f":"(SUM($E$32,$E$35:$E$40))*0.15","v":538.78232361537846},{"$f":"D41","v":538.78232361537846}]
["Total Fixed Costs",null,null,null,{"$f":"SUM(E35:E41)","v":1152.5761084352512}]
["Total Specified Costs",null,null,null,{"$f":"E42+E32","v":4130.6644810512353}]
[]
["Returns Over Specified  Cost",null,null,null,{"$f":"E8-E43","v":629.33551894876564}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sunflower Budget"]
["Flower Variety","Sunflower, Single Stem Varieties"]
["Production Space",1000,"sq. ft."]
["Seeding Rate/ Spacing",4000]
["Crop Survival and Marketable Rate",0.7]
[]
["Gross Income","Unit","Quantity","$/Unit","Total Estimate"]
["Sunflower Stems","Stem ",{"$f":"B$4*B$5","v":2800},{"$f":"'Input Calculations'!$H$25","v":1.7000000000000002},{"$f":"C132*D132","v":4760.0000000000009}]
[]
["Variable Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Seed","lb. ",2000,{"$f":"'Input Calculations'!D$34","v":3.6800000000000006E-2},{"$f":"C135*D135","v":73.600000000000009}]
["Transplants (growing plugs)","plugs",2000,{"$f":"'Input Calculations'!C$57","v":9.9733000000000002E-2},199.46600000000001]
["Soil Test","test",0.2,15,3]
["Fertilizer - 20-10-20","lb. ",{"$f":"'Input Calculations'!G$94","v":10},{"$f":"'Input Calculations'!K$94","v":1.5031999999999999},15.031999999999998]
["Fungicide - cost of 3 sprays throughout growing season",null,null,null,{"$f":"'Input Calculations'!L$85","v":8.3867499999999993}]
["Insecticide - cost of 4 sprays throughout growing season",null,null,null,{"$f":"'Input Calculations'!L$90","v":9.4849999999999994}]
["Irrigation Supplies"]
["   Dripline purchased annually","linear ft.",{"$f":"'Input Calculations'!E$102","v":666.66666666666663},{"$f":"'Input Calculations'!K$102","v":4.9599999999999998E-2},{"$f":"C142*D142","v":33.066666666666663}]
["   Attachments purchased annually",null,1,{"$f":"'Input Calculations'!H$126","v":67.06},67.06]
["   Operation of Irrigation ","water use in 1,000 gal.",{"$f":"'Input Calculations'!K$131","v":9.8649300000000011},{"$f":"'Input Calculations'!L$131","v":6.8363333333333332},{"$f":"C144*D144","v":67.43994979}]
["Staples for Ground Cover","staples",{"$f":"'Input Calculations'!H$66","v":1000},{"$f":"'Input Calculations'!D$68","v":7.7949999999999992E-2},{"$f":"D145*C145","v":77.949999999999989}]
["Black Woven Ground Cover","ft.",1000,{"$f":"'Input Calculations'!G$64","v":3.0013703703703706E-2},{"$f":"C146*D146","v":30.013703703703705}]
["Flower Netting","sq. ft. ",1000,{"$f":"'Input Calculations'!J$74","v":7.4999999999999997E-2},75]
["Stakes ","stakes",{"$f":"'Input Calculations'!L$72","v":84},{"$f":"'Input Calculations'!C$72","v":0.9966666666666667},83.72]
["Labor","hours",{"$f":"'Input Calculations'!F$150","v":68},15.87,1079.1599999999999]
["Machinery Repair and Maintenance (5%) ","1,000 sq. ft.",1,{"$f":"'Input Calculations'!B$166","v":60},{"$f":"D150*C150","v":60}]
["Fuel","gal.",{"$f":"'Input Calculations'!I$190","v":6},{"$f":"'Input Calculations'!E$190","v":3.75},{"$f":"C151*D151","v":22.5}]
["Propane ","lb. ",{"$f":"'Input Calculations'!B$193","v":0.4},null,0]
["Harvest Containers","each",10,{"$f":"'Input Calculations'!D$155","v":2.0499999999999998},20.5]
["Marketing Costs (20% of Estimated Gross Income)",null,null,{"$f":"E132*0.2","v":952.00000000000023},{"$f":"D154","v":952.00000000000023}]
["Operating Interest (7% of Variable Costs)",null,7.0000000000000007E-2,{"$f":"(SUM(E135:E154)/2)","v":1438.6900350801852},{"$f":"D155*C155","v":100.70830245561298}]
["Total Variable Costs",null,null,null,{"$f":"SUM(E135:E155)","v":2978.0883726159836}]
[]
["Fixed Costs","Unit","Quantity","$/Unit","Total Estimate"]
["Small Tools and Equipment","Useful Life of 3 Years",1,{"$f":"'Input Calculations'!B$187","v":102.14066666666668},{"$f":"C159*D159","v":102.14066666666668}]
["Tiller ","Model 732 Tiller",1,{"$f":"('Input Calculations'!B$163)*0.2","v":18.560000000000002},{"$f":"C160*D160","v":18.560000000000002}]
["Lawn Mower ","Mower 35\"",1,{"$f":"('Input Calculations'!B$165)*0.2","v":10.240000000000002},{"$f":"D161*C161","v":10.240000000000002}]
["Irrigation System Main Component Attachments",null,1,{"$f":"'Input Calculations'!E$128","v":18.076666666666664},{"$f":"D162*C162","v":18.076666666666664}]
["Storage and Post-Harvest Handling Building","(15'X20'X16')",1,{"$f":"'Input Calculations'!N$204","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":297.8088372615984},{"$f":"D164","v":297.8088372615984}]
["General Overhead Cost (15% of Total Production Cost)",null,null,{"$f":"(SUM($E$32,$E$35:$E$40))*0.15","v":538.78232361537846},{"$f":"D165","v":538.78232361537846}]
["Total Fixed Costs",null,null,null,{"$f":"SUM(E159:E165)","v":1152.5761084352512}]
["Total Specified Costs",null,null,null,{"$f":"E166+E156","v":4130.6644810512353}]
[]
["Returns Over Specified  Cost",null,null,null,{"$f":"E132-E167","v":629.33551894876564}]

{"sheet":"Input Calculations","index":3,"n_rows":204,"n_cols":15,"rows_kept":204,"cut":false,"hidden":true,"merged":[[143,4,144,5],[197,0,197,15]]}
["1000 sq ft bed","3 ft wide by 333.3 ft long bed. 6 inch spacing. Means 6 rows of seed for the bed"]
[null,4000,"seeds",null,"Trial data from UT study in 2024. Total trial area of 2,000 sq ft split into two growing areas, one low fertilizer application and one medium fertilizer"]
[]
["spacing",null,null,"seeding","survival","avg survival rate","sq ft",null,null,"Total inches "]
["Procut Orange 5/31","a","1141a",67,63,{"$f":"E5/D5","v":0.94029850746268662},16.5,63,{"$f":"H5/G5","v":3.8181818181818183},{"$f":"G5*144","v":2376},{"$f":"J5/D5","v":35.462686567164177},{"$f":"SQRT(K5)","v":5.9550555469419573}]
["Sunrich Lime 5/31","a","1142a",48,42,{"$f":"E6/D6","v":0.875},12,44,3.6666666666666665,1728,36,6]
["Sunrich Orange 5/31","a","1143a",48,47,0.97916666666666663,12,46,3.8333333333333335,1728,36,6]
["Procut Gold Lite 5/31","a","1144a",54,52,0.96296296296296291,13.5,62,4.5925925925925926,1944,36,6]
["Procut White 5/31","a","1145a",54,53,0.98148148148148151,13.5,84,6.2222222222222223,1944,36,6]
["Procut Orange 6/17 planted 6/27","b","1141b",35,33,0.94285714285714284,9,25,2.7777777777777777,1296,37.028571428571432,6.0851106340453196]
["Sunrich Lime 6/17 planted 6/27","b","1142b",29,27,0.93103448275862066,7.5,19,2.5333333333333332,1080,37.241379310344826,6.1025715325872936]
["Sunrich Orange 6/17 planted 6/27","b","1143b",33,31,0.93939393939393945,9,47,5.2222222222222223,1296,39.272727272727273,6.2667956144051224]
["Procut Gold Lite 6/17 planted 6/27","b","1144b",34,34,1,9,20,2.2222222222222223,1296,38.117647058823529,6.1739490651303184]
["Procut White 6/17 planted 6/27","b","1145b",33,33,1,9,15,1.6666666666666667,1296,39.272727272727273,6.2667956144051224]
["Procut Orange DS 7/2","c","1141c",36,22,0.61111111111111116,9,8,0.88888888888888884,1296,36,6]
["Sunrich Lime DS 7/2","c","1142c",36,6,0.16666666666666666,9,1,null,1296,36,6]
["Sunrich Orange DS 7/2","c","1143c",36,4,0.1111111111111111,9,5,null,1296,36,6]
["Procut Gold Lite DS 7/2","c","1144c",36,31,0.86111111111111116,9,34,{"$f":"H18/G18","v":3.7777777777777777},1296,36,6]
["Procut White DS 7/2","c","1145c",36,32,0.88888888888888884,9,24,2.6666666666666665,1296,36,6]
[null,null,null,null,null,{"$f":"AVERAGE(F5:F19)","v":0.8127389381648259},"80% used in budget"]
[]
["Selling Prices 2024 - Sunflowers"]
[]
["date","location","price","stem count","price per stem",null,null,"avg price selling stems"]
[null,null,null,null,{"$f":"C25/D25","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E26:E29)","v":1.7000000000000002}]
[null,"Coffee Co Producer",10,5,{"$f":"C26/D26","v":2}]
[null,"Nash cut flower collective",12,5,2.4]
["2024-07-15","Rutherford farmers market",1,1,1,null,null,null,"*assumption: prices averaged from farmers market and direct to consumer retail stores in high-income, urban markets. Prices are highly variable."]
["2024-07-29","Knox Farmers market",7,5,1.4]
[]
[]
[]
["Seed prices from Johnnys","price",5000,"Average Seed Price"]
["Procut Orange 5/31",150,{"$f":"B34/C33","v":0.03},{"$f":"AVERAGE(C34:C38)","v":3.6800000000000006E-2}]
["Sunrich Lime 5/31",210,{"$f":"B35/C33","v":4.2000000000000003E-2}]
["Sunrich Orange 5/31",210,{"$f":"B36/C33","v":4.2000000000000003E-2}]
["Procut Gold Lite 5/31",150,{"$f":"B37/C33","v":0.03}]
["Procut White 5/31",200,{"$f":"B38/C33","v":0.04}]
["Procut Orange 6/17 planted 6/27",150]
["Sunrich Lime 6/17 planted 6/27",210]
["Sunrich Orange 6/17 planted 6/27",210]
["Procut Gold Lite 6/17 planted 6/27",150]
["Procut White 6/17 planted 6/27",200]
["Procut Orange DS 7/2",150]
["Sunrich Lime DS 7/2",210]
["Sunrich Orange DS 7/2",210,null,null,null,null,"Trays per bag","Trays needed","# Bags Needed","Price per bag","Price for 2,000 plugs promix"]
["Procut Gold Lite DS 7/2",150,null,null,"Promix 2.8 cu ft bags",null,40,{"$f":"J52","v":56},{"$f":"H47/G47","v":1.4},21.79,{"$f":"I47*J47","v":30.505999999999997}]
["Procut White DS 7/2",200]
[]
[null,null,null,null,null,null,null,null,"planting 2,000 as plugs"]
["Growing Transplants cost addition to seed cost","For all 2,000",null,null,"Trays",null,"Cells per tray","price per tray","Total number of trays","Round up to whole","Total tray price"]
["Avg seed cost",{"$f":"0.04*2000","v":80},null,null,"606 black trays",null,36,0.8,{"$f":"2000/G52","v":55.555555555555557},56,{"$f":"J52*H52","v":44.800000000000004}]
["Growing Medium",{"$f":"K47","v":30.505999999999997}]
["Trays",{"$f":"K52","v":44.800000000000004},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"]
["Seed starting light energy use - ",{"$f":"L55","v":44.16},null,16,18,16,0.16,null,{"$f":"1.38","v":1.38},{"$f":"I55*D55","v":22.08},2,{"$f":"J55*K55","v":44.16}]
[]
["Total cost",{"$f":"SUM(B52:B55)","v":199.46600000000001},{"$f":"B57/2000","v":9.9733000000000002E-2}]
[]
[]
[]
[]
["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":"B63*C63","v":1800},162.07400000000001,null,{"$f":"E63/D63","v":9.0041111111111113E-2},1000,{"$f":"G63*H63","v":90.041111111111107}]
[null,null,null,null,null,null,{"$f":"G63/3","v":3.0013703703703706E-2}]
["Staples","Total Bought","Cost","Cost per Staple ","Staples per Sq. Ft.",null,"Total Sq. Ft. ","Total # Staples"]
["Pro trade 6 inch sod staple flat top",300,18,{"$f":"C66/B66","v":0.06},1,null,1000,{"$f":"G66*E66","v":1000}]
[null,100,9.59,9.5899999999999999E-2]
[null,null,"avg",{"$f":"(D67+D66)/2","v":7.7949999999999992E-2}]
[]
["Flower Netting and stakes"]
[null,"Price each",3,"years","stakes every 8 ft",null,"on each side","width of bed",1000,"sections of stakes","Total number of stakes","Round up number of stakes","Price of stakes total"]
["Step in fence post TSC, 2 inch, 4 ft tall",2.99,{"$f":"B72/C71","v":0.9966666666666667},null,8,null,2,3,{"$f":"I71/H72","v":333.33333333333331},{"$f":"I72/E72","v":41.666666666666664},{"$f":"J72*2","v":83.333333333333329},84,{"$f":"L72*B72","v":251.16000000000003}]
[null,"Width in ft","length in ft","Total sq ft",null,null,"Total plant support needed","price per roll","Price for netting"]
["Tenax plant support 6\"X6\"",4,328,{"$f":"B74*C74","v":1312},{"$f":"1000/D74","v":0.76219512195121952},null,1,75,{"$f":"G74*H74","v":75},{"$f":"I74/1000","v":7.4999999999999997E-2}]
[]
[]
[]
[]
[]
["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","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":"(E81*G81)*B81","v":10.8},210,320,{"$f":"I81/J81","v":0.65625},{"$f":"H81*K81","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":"C82*D82","v":1.5},null,1,{"$f":"(E82*G82)*B82","v":3},17.16,16,1.0725,{"$f":"H82*K82","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,4.5999999999999996,17.98,16,1.12375,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,{"$f":"L83+L82","v":8.3867499999999993},"total fungicide application 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","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","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":"(E90*G90)*B90","v":16},18.97,32,{"$f":"I90/J90","v":0.59281249999999996},{"$f":"H90*K90","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,"knoxville seed and supply"]
["Fertilizer","pounds of actual N per 1,000 sq ft","N per bag","pounds in bag","lbs of N in bag",null,"Applying lbs of product",null,"price from receipt","pounds in bag","price per pound"]
["medium appl of fertilizer - 20-10-20",2,0.2,25,{"$f":"D94*C94","v":5},null,{"$f":"B94*E94","v":10},null,37.58,25,{"$f":"I94/J94","v":1.5031999999999999},{"$f":"G94*K94","v":15.031999999999998}]
["*note: 2 pounds of nitrogen per 1,000 sq ft is medium fertilization split over 8 applications total"]
[]
["Irrigation System"]
[null,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",null,1000]
[]
["Variable only one year use:","Bed widthin ft","bed length in ft","number of lines in bed","Linear ft of driptape needed",null,null,null,"Price","length in ft","price per ft","Total cost for driptape annual use"]
["Driptape - toro aqua-trax 5/8\", 6 mil, 8 in, 0.5 gpm, 2500'",6,{"$f":"C99/B102","v":166.66666666666666},4,{"$f":"C102*D102","v":666.66666666666663},null,null,null,124,2500,{"$f":"I102/J102","v":4.9599999999999998E-2},{"$f":"E102*K102","v":33.066666666666663}]
[]
[]
[null,null,"Useful life for fixed cost",3,"years"]
["Irrigation Attachments"]
["From Irrigation King receipt Celeste","Totalquantity from Celeste","quantity for 1,000 ","price each unit","Fixed cost",null,"Annual Purchase - Variable cost fittings"]
["5/8\" tape swivel X 5/8\" tape swivel repair coupler",10,5,3.5,{"$f":"C108*D108","v":17.5},null,5,{"$f":"G108*D108","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]
["3/4\" permaloc x 3/4 MPT 800 series",2,1,2.76,2.76,null,null,0]
[null,null,null,null,0,null,null,0,null,null,null,"City","Water prices per 1,000 gallons"]
["From Dripworks receipt Celeste",null,null,null,0,null,null,0,null,null,null,"Lebanon",10.968]
["Mainline 3/4\" poly tubing - 100 ft",1,1,31.95,31.95,null,null,0,null,null,null,"Murfreesboro",3.66]
["3/4 easy loc coupler",2,null,4.9800000000000004,0,null,2,9.9600000000000009,null,null,null,"Bristol",6.28]
["3/4\" easy loc elbow",2,1,7.78,7.78,null,null,0,null,null,null,"Springfield",6.58]
["3/4\" easy loc x male hose end",1,1,1.59,1.59,null,null,0,null,null,null,"Fayetteville",7.83]
["3/4\" easy loc tee ",1,1,5.95,5.95,null,null,0,null,null,null,"Clinton",5.7]
["3/4\" easy loc valve",1,1,4.95,4.95,null,null,0,null,null,null,"State average",{"$f":"AVERAGE(M118:M123)","v":6.8363333333333332}]
["shipping - do we include? (none on irrigation king)",null,1,14.95,14.95,null,null,0]
[null,null,"Total fixed cost",null,{"$f":"SUM(E108:E125)","v":271.14999999999998},null,null,{"$f":"SUM(H108:H125)","v":67.06},"Sum of annual fittings cost"]
[null,null,null,null,{"$f":"E126/D105","v":90.383333333333326},"Total 1/4 acre",null,"*3 year life "]
["Irrigation kit to spread over 3 years for fixed cost. ","Driptape and annual attachments for variable cost  should be around $100.",null,null,{"$f":"E127*0.2","v":18.076666666666664},"Total this crop"]
[]
["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":"C131*60","v":348},{"$f":"E102","v":666.66666666666663},0.5,6.67,{"$f":"G131*D131","v":2321.16},{"$f":"E150/2","v":4.25},{"$f":"H131*I131","v":9864.93},{"$f":"J131/1000","v":9.8649300000000011},{"$f":"M124","v":6.8363333333333332},{"$f":"L131*K131","v":67.43994979}]
[null,null,"Penn state: https://extension.psu.edu/determining-how-long-to-run-drip-irrigation-systems-for-vegetables"]
[]
["Labor (using UT Trial data but not using this method in budget)",1587,1000]
[null,"hours for 1587 ","hours for 1,000 sq ft"]
["Burning Holes in fabric",8,{"$f":"(B136*$C$134)/$B$134","v":5.0409577819785758}]
["irrigation set up",6,3.7807183364839321]
["laying fabric",8,5.0409577819785758]
["stakes/netting",6,3.7807183364839321]
["  Pre-plant (grow transplants, lay irrigation, plastic) Total",{"$f":"SUM(B136:B139)","v":28},17.643352236925015]
["Harvest hours - no data"]
["Planting",60,{"$f":"(B142*$C$134)/$B$134","v":37.807183364839318}]
["Weeding",6,3.7807183364839321]
["Spraying",4.5,2.8355387523629489,null,"Hours for 1,000 sq feet without harvest hours based on Celeste data"]
["Irrigation (measuring, mixing fert and setting timers)",4,2.5204788909892879]
["Planting and Plant Maintenance (planting, spraying, weeding, irrigation) Total",{"$f":"SUM(B142:B145)","v":74.5},46.943919344675486,null,{"$f":"C140+C146","v":64.587271581600504}]
[]
["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":"B150/C150","v":8},8.5,{"$f":"D150*E150","v":68},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"]
[]
["Harvest containers","Number of containers","10 L, 10 count johnnys","price each bucket","total cost"]
[null,100,20.5,{"$f":"C155/10","v":2.0499999999999998},{"$f":"B155*D155","v":204.99999999999997},null,"https://www.johnnyseeds.com/tools-supplies/cut-flower-supplies/flower-buckets/flower-buckets-10-l-10-count-7824.html"]
[]
["Land - cash rent","1,000 sq. ft. ",1,25,{"$f":"C157*D157","v":25},"Cash rental rates are based on the 2022 USDA-NASS reported cash rental rates for irrigated cropland in Tennessee ($187/acre)."]
[]
["Large Equipment ",null,null,null,null,null,"Source"]
["High Tunnel Average Cost for a Standard 32' by 30' (960 sq. ft.) ",{"$f":"(960*3.81)+1500","v":5157.6000000000004},"$3.81/foot","10 Year Dep. Life ","Salvage Value 10%",{"$f":"B160*0.1","v":515.7600000000001},"https://justplainbusiness.com/scenic-acres-greenhouse-mfg/",null,null,null,"Economy Version Hightunnel Package 30*48 $5,497, $3.81/ft, Add Installation Fee of $1,500 "]
["Not using high tunnel in this budget",{"$f":"(B160-F160)/10","v":464.18400000000003},"Per Year ",null,null,null,"https://journals.flvc.org/edis/article/download/132085/138352/250524#:~:text=We%20assume%20the%20salvage%20value,value%2C%20following%20Biship%20et%20al."]
["Tiller ",4000,"5 Year Depreciation ",{"$f":"B162*0.42","v":1680},null,null,"https://www.bcsamerica.com/product/model-732"]
[null,{"$f":"((B162-D162)/5)*0.2","v":92.800000000000011},"Per Year "]
["Lawn Mower ",2000,"5 Year Depreciation ",{"$f":"B164*0.36","v":720},null,null,"https://www.foards.com/collections/bad-boy-mowers/products/bby25fj180"]
[null,{"$f":"((B164-D164)/5)*0.2","v":51.2},"Per Year "]
["Machinery Repair and Maintenance 5% (No High Tunnel) ",{"$f":"((B162+B164)*0.05)*0.2","v":60}]
["***Everything took 20% Except the High Tunnel - not utilized in this budget"]
[]
[]
[]
["Small Tools and 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,"flat bottom wagon for transporting buckets and trays",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(B172:B185)","v":1532.1100000000001},"Lasts for 3 Years "]
[null,{"$f":"(B186/3)*0.2","v":102.14066666666668}]
[]
["Fuel ",null,null,"Gallons or pounds","Price per Gallon"]
["Lawn Mower for 1,000 sq. ft. ",".1 Gallons ","Mow 24 Times ",{"$f":"0.1*24","v":2.4000000000000004},3.75,{"$f":"D190*E190","v":9.0000000000000018},null,{"$f":"ROUNDUP(D190,0)","v":3},{"$f":"H190+D191","v":6},"Total fuel use ingal"]
["Tiller for 1,000 sq. ft. ",".75 Gallons","4 Passes ",{"$f":"0.75*4","v":3},3.75,11.25]
["Propane for Mulch Burner (1lb. Propane Cylinder) 20% in lbs",2,13,null,{"$f":"C192/B192","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":"B192*0.2","v":0.4},null,null,null,{"$f":"SUM(F190:F192)","v":22.85}]
[]
["Paper Sleeves (5 stems per sleeve) *Not Included in Budget","each",640,0.4,{"$f":"C195*D195","v":256},"https://www.johnnyseeds.com/tools-supplies/cut-flower-supplies/flower-post-harvest/kraft-paper-cut-flower-sleeves-l-100-count-7816.0.html?srsltid=AfmBOop0XMP8CWODgzTjYSjOYn0QwamVTEtCZErbQNThFCfQS3yMWMN4ULA"]
[]
[]
["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":"B201*C201","v":10000},0.25,{"$f":"D201*E201","v":2500},{"$f":"(D201+F201+I201)/2","v":6500},15,{"$f":"(D201-F201)/H201","v":500},7.0000000000000007E-2,{"$f":"(CUMIPMT(J201,5,B201,1,5,1)/20)*-1","v":69.838071124705863},{"$f":"G201*0.005","v":32.5},{"$f":"G201*0.005","v":32.5},{"$f":"D201*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":"I201+K201+L201+M201+N201","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":"N203*0.2","v":166.96761422494117}]