{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Data","50does","100does","180does"],"not_rendered":{"charts":0,"images":1,"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":"Instructions","index":0,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[[28,1,30,10],[0,1,0,10],[2,1,2,10],[6,1,21,10],[23,1,26,10],[3,1,3,10],[4,1,4,10],[43,1,48,10],[50,1,54,10],[32,1,32,10],[34,1,35,10],[37,1,41,10]]}
[null,"Budget Considerations for Various Herd Sizes of Meat Goat Enterprises in Tennessee"]
[]
[null,"John C. Campbell, Extension Area Specialist, University of Tennessee Extension"]
[null,"An Peischel, Assistant Professor, Tennessee State University Cooperative Extension"]
[null,"Rob Holland, Director, Center for Profitable Agriculture, University of Tennessee Extension"]
[]
[null,"This set of three meat goat production budgets is presented here in Excel 2007 format.  The budgets present scenarios for three different herd sizes: 50 does, 100 does, and 180 does.  Differences in inputs result from assumed differences in management intensity and management practices employed.  The budget for each herd size is developed using the same format of nine different tables.  That is, the same information is presented for each herd-size budget through nine different tables.  The nine tables for the 50-doe budget are designated as A-1, A-2…A-9.  Similarly, the tables of the 100-doe budget are designated as B-1, B-2…B-9 and the same table-numbering system is used for the 180-doe budget.  The various parameters and general description of the budgeted scenario is presented in first table of each herd-size budget.  The first table of each herd-size budget is labeled as Table 1.  A letter (A, B, or C) is used prior to the table number to designate the herd-size system.  Table 1 for the 50-doe system is labeled Table A-1 while Table 2 for the 50-doe system is labeled Table A-2.  Table 2 provides the overall estimated costs and returns for the particular system.  Table 3 shows the annual costs for cool-season pasture while Table 4 shows the establishment expenses for cool-season pasture.  Table 5 shows the annual expenses for warm- season pastures while Table 6 shows the establishment costs for warm-season pasture.  Table 7 contains veterinary and medicine expenses while Table 8 contains a description of marketing expenses.  Table 9 shows the fixed expenses for buildings, equipment, machinery and livestock.  Certain items contained in the nine tables are further explained with a list of footnotes that are presented at the end of each budget."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Each budget is contained on a specific worksheet in the workbook file.  The data worksheet contains input prices for the major inputs in each of the budgets.  Changes in prices can be made in the cells in red which will change that input price in each of the budgets.  In each budget, values in red can be changed to fit individual producer's specific situations."]
[]
[]
[]
[]
[null,"Movement among the tables within a worksheet can be accomplished by clicking the appropriate button at each table.  The entire spreadsheet or individual tables can be printed by clicking the appropriate print button.  Macros must be enabled for the buttons to function."]
[]
[]
[]
[null,"When saving as an Excel 2007 file with a new file name, select \"save as Excel Macro-Enabled Workbook.\""]
[]
[null,"When saving as an Excel 1997-2003 files with a new name, select \"save as Excel 97-2003 Workbook\" and click continue in the \"Compatibility Checker\" window."]
[]
[]
[null,"The meat goat production budgets presented here are intended only as a guide.  Producers should use their own information when available and personalized adjustments should be made as needed.  The budget format presented here includes interest expenses for resources used in the goat enterprise.  The underlying assumption of this budget is that existing land resources are used in the enterprise."]
[]
[]
[]
[]
[]
[null,"Prices for productions inputs, especially fuel, livestock feed, and fertilizer, have been extremely volatile in recent years.  Therefore it is extremely important for individuals using this budget for planning purposes to update input prices according to current conditions.  Budgets are only guidelines and a starting point for analysis.  Adjustments can and should be made for unique resource combinations. "]
[]
[]
[]
[]
[]
[]
[null,"Budgets for a single enterprise such as meat goat production are a beginning point for whole-farm planning.  Once producers have studied and revised enterprise budgets to fit their individual situation, they should develop a whole-farm plan. Whole-farm planning incorporates all crop and livestock enterprises into one plan.  The plan also includes items such as taxes, insurance, farm mortgage payments, family living expenses, off-farm income and income taxes."]

{"sheet":"Data","index":1,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"Input Cost Data"]
[]
["Item",null,"Unit","Price"]
["Feed"]
[null,"Hay","ton",80]
[null,"Corn","bushel",4]
[null,"Concentrate Kid Feed","cwt.",14.8]
[null,"Mineral Mix","pound",0.36]
[]
["Seed"]
[null,"Chicory","pound",6]
[null,"Orchardgrass","pound",4]
[null,"Fescue","pound",1.5]
[null,"Red Clover","pound",3.25]
[null,"White Clover","pound",3.65]
[null,"Sericea Lespedeza","pound",6.25]
[null,"Big Bluestem","pound",11]
[]
["Fertilizer"]
[null,"N","pound",0.43]
[null,"P205","pound",0.52]
[null,"K20","pound",0.44]
[null,"Custom Application","acre",5]
[null,"Lime","ton",34.5]
[]
["Machinery-Variable Costs"]
[null,"Pasture Fuel","acre",1.82]
[null,"Pasture Oil & Filter","acre",0.27]
[null,"Pasture Repairs","acre",1.8]
[null,"Pasture Establishment Fuel","acre",20.239999999999998]
[null,"Pasture Establishment Oil & Filter","acre",3.04]
[null,"Pasture Establishment Repairs","acre",13.2]
[null,"Utility Vehicle Fuel","hour",1.5,"0.6 gallons per hour"]
[]
["Machinery-Fixed Costs"]
[null,"Depreciation","acre",0.46]
[null,"Interest","acre",0.71]
[null,"Housing & Insurance","acre",0.09]
[null,"Establishment Depreciation","acre",6.08]
[null,"Establishment Interest","acre",9.0299999999999994]
[null,"Establishment Housing & Insurance","acre",0.96]
[]
["Veterinary"]
[null,"Deworming","dose",0.5]
[null,"Clostridium/Tetanus","dose",0.28000000000000003]
[null,"Lepto","dose",0.37]
[]
["Marketing"]
[null,"Auction Market Fee","head",5.5]
[null,"Auction Market Hauling","head",1]
[null,"Direct Sales Cost","head",4]
[null,"Direct Sales Hauling","head",2]
[]
[]
["General"]
[null,"Guard Dog Feed and Health","year",250]
[null,"Public Water Rate","1,000 gal",6.6]
[null,"Labor","hr",10]
[null,"Operating Interest","percent",0.05]
[null,"Fixed Interest","percent",0.05]

{"sheet":"50does","index":2,"n_rows":323,"n_cols":53,"rows_kept":323,"cut":false,"hidden":false,"merged":[[23,1,23,2],[23,6,23,7],[322,52,376,61],[18,6,18,8],[19,1,19,2],[20,6,20,8],[21,1,21,3],[21,6,21,8],[22,6,22,7],[18,1,18,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[12,1,12,3],[9,1,9,2],[9,6,9,8],[10,1,10,2],[11,1,11,3],[11,6,11,8]]}
[]
[]
[]
[null,null,null,null,null,"MEAT GOAT PRODUCTION (50 DOES AND 1 BUCK)"]
[]
[null,null,null,null,null,"FORAGE BASE OF 15 ACRES, AVERAGE MANAGEMENT"]
[null,null,null,null,null,"ESTIMATED COSTS AND RETURNS TO LAND, MANAGEMENT AND RISK"]
[]
[null,"TABLE A1","INPUT PARAMETERS1"]
[null,"Herd Size (Does)",null,null,50,null,"Percent Weaned Kid Crop",null,null,1.5]
[null,"Bucks",null,null,1]
[null,"Kids Sold Auction Market (head)",null,null,{"$f":"J12*((E10*J10)-((E10*J10)*J16))","v":63.75},null,"Pct. Kids Auction Market",null,null,1]
[null,"Selling Weight Auction Market",null,null,62]
[null,"Kids Sold Direct (head)",null,null,{"$f":"J14*((E10*J10)-((E10*J10)*J16))","v":0},null,"Pct. Kids Direct Market",null,null,0]
[null,"Selling Weight Direct Market",null,null,62]
[null,"Number of Cull Stock Sold",null,null,{"$f":"(E10*J16)-E18","v":6.5},null,"Held for Replacements",null,null,0.15]
[null,"Selling Weight Cull Does",null,null,70]
[null,"Number of (Does) Died",null,null,{"$f":"E10*J18","v":1},null,"Doe Mortality Rate",null,null,0.02]
[null,"Lbs. Corn Doe/Day",null,null,0.5,null,"Days on Corn (Does)",null,null,90]
[null,"Lbs. Hay Doe/Day",null,null,3.5,null,"Days on Hay (Does)",null,null,120]
[null,"Lbs. Concentrate Kid/Day Pre-weaning",null,null,0.25,null,"Days Pre-Weaning (Kids)",null,null,21]
[null,"Lbs. Concenrate Kid/Day Post-weaning",null,null,0.75,null,"Days Post-weaning (Kids)",null,null,60]
[null,"Lbs. Hay Kid/Day",null,null,1,null,"Days on Hay (Kids)",null,null,0]
[null,"Oz Mineral/Day",null,null,0.33,null,"Acres in Forage",null,null,15]
[]
[null,"TABLE A2","ESTIMATED COSTS AND RETURNS"]
[null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","PER DOE","YOUR FARM"]
[null,"REVENUE"]
[null,"Kids Auction2",{"$f":"E12","v":63.75},"Head","cwt",{"$f":"(E12*E13)/100","v":39.524999999999999},118,{"$f":"F29*G29","v":4663.95},{"$f":"H29/$E$10","v":93.278999999999996}]
[null,"Kids Direct2",{"$f":"E14","v":0},"Head","cwt",{"$f":"(E14*E15)/100","v":0},200,{"$f":"F30*G30","v":0},{"$f":"H30/$E$10","v":0}]
[null,"Cull Doe ",{"$f":"E16","v":6.5},"Head","cwt",{"$f":"(E16*E17)/100","v":4.55},70,{"$f":"F31*G31","v":318.5},6.37]
[null,null,null,null,null,null,null,"----------------","----------------","  --------------"]
[null,null,null,null,"TOTAL REVENUE",null,null,{"$f":"SUM(H29:H31)","v":4982.45},{"$f":"SUM(I29:I31)","v":99.649000000000001}]
[]
[null,"VARIABLE EXPENSES"]
[null,"Hay3",null,null,"ton",{"$f":"((J20*E20*(E10+E11+(E10*J16)))/2000)+((J23*E23*(E10*J10))/2000)","v":12.285},{"$f":"Data!$D$5","v":80},{"$f":"F36*G36","v":982.8},{"$f":"H36/$E$10","v":19.655999999999999}]
[null,"Corn ",null,"Breeding","bushels",{"$f":"((E10+E11+(E10*J16))*E19*J19)/56","v":47.008928571428569},{"$f":"Data!$D$6","v":4},{"$f":"F37*G37","v":188.03571428571428},3.7607142857142857]
[null,"Purchased Concentrate",null,"Kids","cwt",{"$f":"((J22*E22*(E10*J10))/100)+((J21*E21*(E10*J10))/100)","v":37.6875},{"$f":"Data!$D$7","v":14.8},{"$f":"F38*G38","v":557.77499999999998},11.1555]
[null,"Cool-Season Pasture4",null,"Table A3","acre",{"$f":"J24*0.7","v":10.5},{"$f":"S118","v":60.00783333333333},{"$f":"F39*G39","v":630.08224999999993},12.601644999999998]
[null,"Warm-Season Pasture4",null,"Table A5","acre",{"$f":"J24*0.3","v":4.5},{"$f":"AC196","v":45.961062500000004},206.82478125000003,4.1364956250000002]
[null,"Mineral Mix",null,null,"lb",{"$f":"(((E10+E11)*E24)/16)*365","v":383.93437500000005},{"$f":"Data!$D$8","v":0.36},138.216375,2.7643274999999998]
[null,"Vet & Med","Table A7",null,null,null,null,{"$f":"AL257","v":323.27499999999998},6.4654999999999996]
[null,"Guardian Dogs5","Feed & Health",null,"each",1,{"$f":"Data!$D$56","v":250},{"$f":"F43*G43","v":250},5]
[null,"Water6",null,null,"1,000 gal",34.119999999999997,{"$f":"Data!$D$57","v":6.6},225.19199999999998,4.5038399999999994]
[null,"Marketing","Table A8",null,null,null,null,{"$f":"AJ271","v":456.625},9.1325000000000003]
[null,"Machinery7","Fuel",null,"hour",45,{"$f":"Data!$D$33","v":1.5},67.5,1.35]
[null,"Machinery ","Repairs",null,null,null,null,{"$f":"AW299","v":280},5.6]
[null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(H36:H47)","v":4306.3261205357139},{"$f":"Data!$D$59","v":0.05},{"$f":"F48*(G48/2)","v":107.65815301339285},2.1531630602678571]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(H36:H48)","v":4413.9842735491065},{"$f":"H50/$E$10","v":88.27968547098213}]
[null,null,null,"RETURN ABOVE VARIABLE EXPENSES",null,null,null,{"$f":"H33-H50","v":568.46572645089327},11.369314529017865]
[]
[null,"DEPRECIATION AND REPAIRS (FIXED COST)8"]
[null,"Depreciation ","Buildings, equipment",null,"Table A9",null,null,{"$f":"AT285+AT286+AT287+AT288","v":101},{"$f":"H54/$E$10","v":2.02}]
[null,"Repairs","Buildings, equipment",null,"Table A9",null,null,{"$f":"AW285+AW286+AW287+AW288","v":56.929999999999993},1.1385999999999998]
[null,"Depreciation","Livestock",null,"Table A9",null,null,{"$f":"AT306","v":125},2.5]
[null,"Depreciation","Fences",null,"Table A9",null,null,{"$f":"AT289+AT290+AT291","v":244.75813333333335},4.8951626666666668]
[null,"Repairs","Fences",null,"Table A9",null,null,{"$f":"AW289+AW290+AW291","v":207.08100000000002},4.1416200000000005]
[null,"Depreciation","Machinery",null,"Table A9",null,null,{"$f":"AT299","v":466.66666666666669},9.3333333333333339]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(H54:H59)","v":1201.4358},{"$f":"H61/$E$10","v":24.028715999999999}]
[null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"H50+H61","v":5615.4200735491067},112.30840147098213]
[null,"RETURN TO LAND, LABOR, CAPITAL,  MANAGEMENT, RISK",null,null,null,null,null,{"$f":"H51-H61","v":-632.9700735491067},-12.659401470982134]
[]
[null,"INTEREST (FIXED COST)9"]
[null,"Livestock","Table A9",null,null,null,null,{"$f":"AV306","v":243.125},{"$f":"H66/$E$10","v":4.8624999999999998}]
[null,"Bldgs. & Equip","Table A9",null,null,null,null,{"$f":"AV285+AV286+AV287+AV288","v":19.825000000000003},0.39650000000000007]
[null,"Fences","Table A9",null,null,null,null,{"$f":"AV289+AV290+AV291","v":103.54050000000001},2.0708100000000003]
[null,"Machinery","Table A9",null,null,null,null,{"$f":"AV299","v":175},3.5]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,"TOTAL INTEREST EXPENSE",null,null,null,{"$f":"SUM(H66:H69)","v":541.4905},{"$f":"SUM(I66:I69)","v":10.82981}]
[null,null,"TOTAL VARIABLE, FIXED, INTEREST EXPENSE",null,null,null,null,{"$f":"H62+H71","v":6156.9105735491066},{"$f":"H72/$E$10","v":123.13821147098213}]
[null,"NET RETURN TO LAND, LABOR, MANAGEMENT, RISK",null,null,null,null,null,{"$f":"H63-H71","v":-1174.4605735491068},-23.489211470982138]
[]
[null,"LABOR EXPENSES"]
[null,"LABOR10",null,null,"hour",150,{"$f":"Data!$D$58","v":10},{"$f":"F76*G76","v":1500},{"$f":"H76/$E$10","v":30}]
[]
[null,null,null,"TOTAL ALL EXPENSES",null,null,null,{"$f":"H72+H76","v":7656.9105735491066},{"$f":"H78/$E$10","v":153.13821147098213}]
[null,null,"RETURN TO LAND, MANAGEMENT, RISK",null,null,null,null,{"$f":"H73-H76","v":-2674.4605735491068},-53.489211470982134]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TABLE A3","COOL-SEASON PASTURE, ANNUAL EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seed",null,null,"lb",0,0,{"$f":"Q91*R91","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",20,{"$f":"Data!$D$20","v":0.43},{"$f":"Q92*R92","v":8.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",10,{"$f":"Data!$D$21","v":0.52},{"$f":"Q93*R93","v":5.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",10,{"$f":"Data!$D$22","v":0.44},{"$f":"Q94*R94","v":4.4000000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",0.2,{"$f":"Data!$D$24","v":34.5},6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$27","v":1.82},1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$28","v":0.27},0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$29","v":1.8},1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(S91:S99)","v":33.99},{"$f":"Data!$D$59","v":0.05},{"$f":"Q100*(R100/2)","v":0.84975000000000012}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(S91:S100)","v":34.839750000000002}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$36","v":0.46},{"$f":"Q106*R106","v":0.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$37","v":0.71},0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$38","v":0.09},0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,"Establishment","Pro-rated",null,"acre",1,{"$f":"S156","v":20.508083333333332},20.508083333333332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(S106:S109)","v":21.768083333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"S102+S111","v":56.607833333333332}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",0.34,{"$f":"Data!$D$58","v":10},{"$f":"Q116*R116","v":3.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ALL ANNUAL EXPENSES",null,null,null,{"$f":"S102+S111+S116","v":60.00783333333333}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TABLE A4","COOL-SEASON PASTURE, ESTABLISHMENT EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seed","Fescue",null,"lb",15,{"$f":"Data!$D$13","v":1.5},{"$f":"Q125*R125","v":22.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,{"$f":"Data!$D$11","v":6},{"$f":"Q126*R126","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Clover",null,"lb",5,{"$f":"Data!$D$14","v":3.25},{"$f":"Q127*R127","v":16.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"White Clover",null,"lb",3,{"$f":"Data!$D$15","v":3.65},10.95]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",30,{"$f":"Data!$D$20","v":0.43},{"$f":"Q129*R129","v":12.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",30,{"$f":"Data!$D$21","v":0.52},{"$f":"Q130*R130","v":15.600000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",30,{"$f":"Data!$D$22","v":0.44},{"$f":"Q131*R131","v":13.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",2,{"$f":"Data!$D$24","v":34.5},69]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$30","v":20.239999999999998},20.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$31","v":3.04},3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$32","v":13.2},13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(S125:S136)","v":201.88},{"$f":"Data!$D$59","v":0.05},{"$f":"Q137*(R137/2)","v":5.0470000000000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(S125:S137)","v":206.92699999999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$39","v":6.08},{"$f":"Q143*R143","v":6.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$40","v":9.0299999999999994},9.0299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$41","v":0.96},0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(S143:S145)","v":16.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"S139+S147","v":222.99699999999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",2.31,{"$f":"Data!$D$58","v":10},{"$f":"Q152*R152","v":23.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ESTABLISHMENT EXPENSES",null,null,null,{"$f":"S139+S147+S152","v":246.09699999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PRO-RATED SHARE ESTABLISHMENT ",null,null,"years",12,null,{"$f":"S154/Q156","v":20.508083333333332}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE A5","WARM-SEASON PASTURE, ANNUAL EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seed",null,null,"lb",0,0,{"$f":"AA169*AB169","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",0,{"$f":"Data!$D$20","v":0.43},{"$f":"AA170*AB170","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",10,{"$f":"Data!$D$21","v":0.52},{"$f":"AA171*AB171","v":5.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",10,{"$f":"Data!$D$22","v":0.44},{"$f":"AA172*AB172","v":4.4000000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",0,{"$f":"Data!$D$24","v":34.5},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$27","v":1.82},1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$28","v":0.27},0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$29","v":1.8},1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(AC169:AC177)","v":18.490000000000002},{"$f":"Data!$D$59","v":0.05},{"$f":"AA178*(AB178/2)","v":0.46225000000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(AC169:AC178)","v":18.952250000000003}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$36","v":0.46},{"$f":"AA184*AB184","v":0.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$37","v":0.71},0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$38","v":0.09},0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Establishment","Pro-rated",null,"acre",1,{"$f":"AC234","v":22.348812499999998},22.348812499999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(AC184:AC187)","v":23.608812499999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"AC180+AC189","v":42.561062500000006}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",0.34,{"$f":"Data!$D$58","v":10},{"$f":"AA194*AB194","v":3.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ALL ANNUAL EXPENSES",null,null,null,{"$f":"AC180+AC189+AC194","v":45.961062500000004}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE A6","WARM-SEASON PASTURE ESTABLISHMENT EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seed","Sericea Lespedeza",null,"lb",15,{"$f":"Data!$D$16","v":6.25},{"$f":"AA203*AB203","v":93.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,{"$f":"Data!$D$17","v":11},{"$f":"AA204*AB204","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,0,{"$f":"AA205*AB205","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",0,{"$f":"Data!$D$20","v":0.43},{"$f":"AA207*AB207","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",20,{"$f":"Data!$D$21","v":0.52},{"$f":"AA208*AB208","v":10.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",20,{"$f":"Data!$D$22","v":0.44},{"$f":"AA209*AB209","v":8.8000000000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",2,{"$f":"Data!$D$24","v":34.5},69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$30","v":20.239999999999998},20.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$31","v":3.04},3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$32","v":13.2},13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(AC203:AC214)","v":223.42999999999998},{"$f":"Data!$D$59","v":0.05},{"$f":"AA215*(AB215/2)","v":5.58575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(AC203:AC215)","v":229.01574999999997}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$39","v":6.08},{"$f":"AA221*AB221","v":6.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$40","v":9.0299999999999994},9.0299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$41","v":0.96},0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(AC221:AC223)","v":16.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"AC217+AC225","v":245.08574999999996}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",2.31,{"$f":"Data!$D$58","v":10},{"$f":"AA230*AB230","v":23.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ESTABLISHMENT EXPENSES",null,null,null,{"$f":"AC217+AC225+AC230","v":268.18574999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO-RATED SHARE ESTABLISHMENT",null,null,"years",12,null,{"$f":"AC232/AA234","v":22.348812499999998}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE A7","VETERINARY AND MEDICINE EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/",null,"YOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","DESCRIP.","DOSES","HEAD","DOSE","TOTAL","FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deworming","Does/Bucks",3,{"$f":"E10+E11","v":51},{"$f":"Data!$D$44","v":0.5},{"$f":"AI247*AJ247*AK247","v":76.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Does/Bucks",1,{"$f":"E10+E11","v":51},{"$f":"Data!$D$45","v":0.28000000000000003},{"$f":"AI248*AJ248*AK248","v":14.280000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Does/Bucks",1,{"$f":"E10+E11","v":51},{"$f":"Data!$D$46","v":0.37},18.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deworming","Replacements",3,{"$f":"E10*J16","v":7.5},{"$f":"Data!$D$44","v":0.5},11.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Replacements",1,{"$f":"E10*J16","v":7.5},{"$f":"Data!$D$45","v":0.28000000000000003},2.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Replacements",1,{"$f":"E10*J16","v":7.5},{"$f":"Data!$D$46","v":0.37},2.7749999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Kids",2,{"$f":"E10*J10","v":75},{"$f":"Data!$D$45","v":0.28000000000000003},42.000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Kids",2,{"$f":"E10*J10","v":75},{"$f":"Data!$D$46","v":0.37},55.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Medicine","Per Doe",null,{"$f":"E10","v":50},2,{"$f":"AJ255*AK255","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-------------","-------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VETERINARY & MEDICINE EXPENSES",null,null,null,null,{"$f":"SUM(AL247:AL255)","v":323.27499999999998}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE A8","MARKETING EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/",null,"YOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","HEAD","HEAD","TOTAL","FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auction Market Fee",{"$f":"E12+E16","v":70.25},{"$f":"Data!$D$49","v":5.5},{"$f":"AH265*AI265","v":386.375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auction Market Hauling",{"$f":"E12+E16","v":70.25},{"$f":"Data!$D$50","v":1},{"$f":"AH266*AI266","v":70.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Sales Misc.Cost ",{"$f":"E14","v":0},{"$f":"Data!$D$51","v":4},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Sales Hauling",{"$f":"E14","v":0},{"$f":"Data!$D$52","v":2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Marketing",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-------------","-------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MARKETING EXPENSES",null,null,{"$f":"SUM(AJ265:AJ269)","v":456.625}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table A9   BUILDING, EQUIPMENT, MACHINERY, AND LIVESTOCK FIXED EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUANTITY","COST","LIFE","DEPREC.","INTEREST","INTEREST","REPAIRS","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM",null,"UNIT ($)","(YEARS)","($/YEAR)","RATE","($/YEAR)","($/YEAR)","($/YEAR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buildings and Equipment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasture Shelters ",2,216,15,{"$f":"(AQ285*AR285)/AS285","v":28.8},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ285*AR285)*0.5)*AU285","v":10.8},{"$f":"(AQ285*AR285)*0.09","v":38.879999999999995},{"$f":"AT285+AV285+AW285","v":78.47999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeders ",3,42,5,{"$f":"(AQ286*AR286)/AS286","v":25.2},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ286*AR286)*0.5)*AU286","v":3.1500000000000004},{"$f":"(AQ286*AR286)*0.05","v":6.3000000000000007},34.650000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral Feeders",1,135,5,{"$f":"(AQ287*AR287)/AS287","v":27},{"$f":"Data!$D$60","v":0.05},3.375,6.75,37.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterers",2,50,5,{"$f":"(AQ288*AR288)/AS288","v":20},{"$f":"Data!$D$60","v":0.05},2.5,5,27.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Tensile Permanent Fence (feet)11",3233,1.1399999999999999,25,{"$f":"(AQ289*AR289)/AS289","v":147.4248},{"$f":"Data!$D$60","v":0.05},92.140500000000003,184.28100000000001,423.84630000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energizer",1,200,6,{"$f":"(AQ290*AR290)/AS290","v":33.333333333333336},{"$f":"Data!$D$60","v":0.05},5,10,48.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Cross Fence (feet)",1600,0.16,4,64,{"$f":"Data!$D$60","v":0.05},6.4,12.8,83.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BUILDLINGS AND EQUIPMENT",null,null,null,{"$f":"SUM(AT285:AT291)","v":345.75813333333332},null,{"$f":"SUM(AV285:AV291)","v":123.36550000000001},264.01100000000002,{"$f":"SUM(AX285:AX291)","v":733.13463333333345}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Terrain Vehicle",1,6000,15,{"$f":"(AQ296*AR296)/AS296","v":400},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ296*AR296)*0.5)*AU296","v":150},{"$f":"(AQ296*AR296)*0.04","v":240},{"$f":"AT296+AV296+AW296","v":790}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility Trailer",1,1000,15,66.666666666666671,{"$f":"Data!$D$60","v":0.05},25,{"$f":"(AQ297*AR297)*0.04","v":40},{"$f":"AT297+AV297+AW297","v":131.66666666666669}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MACHINERY",null,null,null,{"$f":"AT296+AT297","v":466.66666666666669},null,{"$f":"AV296+AV297","v":175},280,921.66666666666674]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buck",{"$f":"E11","v":1},150,2,{"$f":"(AQ302*AR302)/AS302","v":75},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ302*AR302))*AU302","v":7.5},"n. a.",{"$f":"AT302+AV302","v":82.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Does & Replacements13",{"$f":"E10+(E10*J16)","v":57.5},75,null,"n. a.",{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ303*AR303))*AU303","v":215.625},"n. a.",{"$f":"AV303","v":215.625}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Guardian Dogs ",{"$f":"F43","v":1},400,8,50,{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ304*AR304))*AU304","v":20},"n. a.",{"$f":"AV304+AT304","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL LIVESTOCK",null,null,null,{"$f":"SUM(AT302:AT304)","v":125},null,{"$f":"SUM(AV302:AV304)","v":243.125},null,{"$f":"SUM(AX302:AX304)","v":368.125}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes - 50 Doe Budget"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.  The input table (Table A1) contains the parameters for which revenue and expenses are estimated.\n\n2.  The market price for kids sold at auction is based on auction prices from the Tennessee Livestock Producers graded sale for the years 2005 through 2009 assuming 10% were Selection 1, 80% Selection 2, and 10% Selection 3.\n\n3.  Feed hay with minimum 54% TDN and 10% crude protein.  This budget assumes purchased hay.\n\n4.  Detailed pasture expenses are contained in Tables A3, A5, A5, and A6.  Expenses are based on 70% of the pasture acres being as perennial cool-season vegetation and 30% perennial warm-season vegetation.  For this budget, the cool-season vegetation consists of tall fescue, red clover and white clover.  The warm-season vegetation is sericea lespedeza.  These plant species were used for this example budget.  Other species and combinations can be used, but may require adjustments in pasture production cost.  Annual (or yearly) pasture costs (Tables A3 and A5) include cash variable expenses (annual seed, fertilizer, lime, and fuel and repairs for machinery to mow pastures).  Fixed expenses include depreciation and interest on the equipment and a pro-rated share of the establishment costs.  Establishment costs are outlined in Tables A4 and A6.\n\n5.  One livestock guardian dog is budgeted for every 50 does.  Feed and health expenses for the livestock guardian dogs are included as variable expenses in Table 2.  The purchase price of the dog is depreciated as a fixed cost as shown in Table A9.\n\n6.  Purchased utility water usage is based on breeding animals consuming 1.5 gallons per day year-round with kids consuming one-half gallon per day after weaning.\n\n7.  Variable machinery expenses include fuel and repairs for an all terrain vehicle and repairs for a utility trailer.  Fuel costs are calculated based on a use rate of 0.6 gallons of fuel per hour with fuel cost $2.50 per gallon.  Machinery fixed expenses are outlined in Table A9.  Machinery expenses for pasture production are included in the pasture budgets.\n\n8.  Fixed expenses for depreciation and repairs are outlined in Table A9.  Depreciation divides the initial purchase cost over the expected life of the item.  Repair costs represent an average repair cost per year over the life of the item.\n\n9.  Interest expenses reflect the fact that capital invested in goat production is costly, regardless of its source.  Borrowed capital entails a cash interest charge for repayment to lenders.  Capital provided by the owner results in a non-cash opportunity cost, due to the fact that the capital could have been invested elsewhere and earned interest when the capital was invested in goat production.  The foregone interest is a cost to the owner, but it is not a cash expense.  Interest expenses are included for buildings and equipment, fences, and machinery.  Interest expenses are also included for the value of the breeding livestock used in the enterprise.  These costs are outlined in Table A9.\n\n10.  Labor expenses are also included in the budget to reflect the cost of hired and/or owner labor.  Again, labor provided by the owner results in a non-cash opportunity cost, due to the earnings foregone by the owner for employment in other agricultural enterprises or off-farm jobs.  Hired labor should be included in the budget as a cash expense. \n \n11.  Permanent high-tensile fencing costs were based on the number of feet required for a perimeter fence around the entire pasture assuming the pasture is in the shape of a square.  Temporary fencing costs assumed two runs across width of pasture.  Fencing costs will vary with the shape of the pasture and also with the type of fencing material used. \n\n12.  Commercial breeding stock - Buck purchase price is $150 per head.  Buck is used for two years.  Doe value is $75 per head.\n\n13.  Depreciation expense for the does is not included since in the long run the doe herd will consist of raised replacements.\n"]

{"sheet":"100does","index":3,"n_rows":323,"n_cols":53,"rows_kept":323,"cut":false,"hidden":false,"merged":[[23,1,23,2],[23,6,23,7],[322,52,376,61],[18,6,18,8],[19,1,19,2],[20,6,20,8],[21,1,21,3],[21,6,21,8],[22,6,22,7],[18,1,18,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[12,1,12,3],[9,1,9,2],[9,6,9,8],[10,1,10,2],[11,1,11,3],[11,6,11,8]]}
[]
[]
[]
[null,null,null,null,null,"MEAT GOAT PRODUCTION (100 DOES AND 2 BUCKS)"]
[null,null,null,null,null,"20% OF KIDS DIRECT MARKETED"]
[null,null,null,null,null,"FORAGE BASE OF 50 ACRES, ABOVE-AVERAGE MANAGEMENT"]
[null,null,null,null,null,"ESTIMATED COSTS AND RETURNS TO LAND, MANAGEMENT AND RISK"]
[]
[null,"TABLE B1","INPUT PARAMETERS1"]
[null,"Herd Size (Does)",null,null,100,null,"Percent Weaned Kid Crop",null,null,1.75]
[null,"Bucks",null,null,2]
[null,"Kids Sold Auction Market (head)",null,null,{"$f":"J12*((E10*J10)-((E10*J10)*J16))","v":119},null,"Pct. Kids Auction Market",null,null,0.8]
[null,"Selling Weight Auction Market",null,null,65]
[null,"Kids Sold Direct (head)",null,null,{"$f":"J14*((E10*J10)-((E10*J10)*J16))","v":29.75},null,"Pct. Kids Direct Market",null,null,0.2]
[null,"Selling Weight Direct Market",null,null,65]
[null,"Number of Cull Stock Sold",null,null,{"$f":"(E10*J16)-E18","v":13},null,"Held for Replacements",null,null,0.15]
[null,"Selling Weight Cull Does",null,null,80]
[null,"Number of (Does) Died",null,null,{"$f":"E10*J18","v":2},null,"Doe Mortality Rate",null,null,0.02]
[null,"Lbs. Corn Doe/Day",null,null,0.5,null,"Days on Corn (Does)",null,null,90]
[null,"Lbs. Hay Doe/Day",null,null,3,null,"Days on Hay (Does)",null,null,120]
[null,"Lbs. Concentrate Kid/Day Pre-weaning",null,null,0.25,null,"Days Pre-Weaning (Kids)",null,null,21]
[null,"Lbs. Concentrate Kid/Day Post-weaning",null,null,0.75,null,"Days Post-weaning (Kids)",null,null,60]
[null,"Lbs. Hay Kid/Day",null,null,1,null,"Days on Hay (Kids)",null,null,60]
[null,"Oz Mineral/Day",null,null,0.33,null,"Acres in Forage",null,null,50]
[]
[null,"TABLE B2","ESTIMATED COSTS AND RETURNS"]
[null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","PER DOE","YOUR FARM"]
[null,"REVENUE"]
[null,"Kids Auction2",{"$f":"E12","v":119},"Head","cwt",{"$f":"(E12*E13)/100","v":77.349999999999994},120,{"$f":"F29*G29","v":9282},{"$f":"H29/$E$10","v":92.82}]
[null,"Kids Direct2",{"$f":"E14","v":29.75},"Head","cwt",{"$f":"(E14*E15)/100","v":19.337499999999999},200,{"$f":"F30*G30","v":3867.4999999999995},{"$f":"H30/$E$10","v":38.674999999999997}]
[null,"Cull Doe ",{"$f":"E16","v":13},"Head","cwt",{"$f":"(E16*E17)/100","v":10.4},70,{"$f":"F31*G31","v":728},7.28]
[null,null,null,null,null,null,null,"----------------","----------------","  --------------"]
[null,null,null,null,"TOTAL REVENUE",null,null,{"$f":"SUM(H29:H31)","v":13877.5},{"$f":"SUM(I29:I31)","v":138.77500000000001}]
[]
[null,"VARIABLE EXPENSES"]
[null,"Hay3",null,null,"ton",{"$f":"((J20*E20*(E10+E11+(E10*J16)))/2000)+((J23*E23*(E10*J10))/2000)","v":26.31},{"$f":"Data!$D$5","v":80},{"$f":"F36*G36","v":2104.7999999999997},{"$f":"H36/$E$10","v":21.047999999999998}]
[null,"Corn ",null,"Breeding","bushels",{"$f":"((E10+E11+(E10*J16))*E19*J19)/56","v":94.017857142857139},{"$f":"Data!$D$6","v":4},{"$f":"F37*G37","v":376.07142857142856},3.7607142857142857]
[null,"Purchased Concentrate",null,"Kids","cwt.",{"$f":"((J22*E22*(E10*J10))/100)+((J21*E21*(E10*J10))/100)","v":87.9375},{"$f":"Data!$D$7","v":14.8},{"$f":"F38*G38","v":1301.4750000000001},13.014750000000001]
[null,"Cool-Season Pasture4",null,"Table B3","acre",{"$f":"J24*0.7","v":35},{"$f":"S118","v":91.835700000000017},{"$f":"F39*G39","v":3214.2495000000008},32.142495000000011]
[null,"Warm-Season Pasture4",null,"Table B5","acre",{"$f":"J24*0.3","v":15},{"$f":"AC196","v":64.780825000000007},971.71237500000007,9.7171237500000007]
[null,"Mineral Mix",null,null,"lb",{"$f":"(((E10+E11)*E24)/16)*365","v":767.86875000000009},{"$f":"Data!$D$8","v":0.36},276.43275,2.7643274999999998]
[null,"Vet & Med","Table B7",null,null,null,null,{"$f":"AL257","v":679.05},6.7904999999999998]
[null,"Guardian Dogs5","Feed & Health",null,"each",2,{"$f":"Data!$D$56","v":250},{"$f":"F43*G43","v":500},5]
[null,"Water6",null,null,"1,000 gal",70.5,{"$f":"Data!$D$57","v":6.6},465.29999999999995,4.6529999999999996]
[null,"Marketing","Table B8",null,null,null,null,{"$f":"AJ271","v":1036.5},10.365]
[null,"Machinery7","Fuel",null,"hour",75,{"$f":"Data!$D$33","v":1.5},112.5,1.125]
[null,"Machinery ","Repairs",null,null,null,null,{"$f":"AW299","v":280},2.8]
[null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(H36:H47)","v":11318.091053571428},{"$f":"Data!$D$59","v":0.05},{"$f":"F48*(G48/2)","v":282.95227633928573},2.8295227633928572]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(H36:H48)","v":11601.043329910714},{"$f":"H50/$E$10","v":116.01043329910713}]
[null,null,null,"RETURN ABOVE VARIABLE EXPENSES",null,null,null,{"$f":"H33-H50","v":2276.4566700892865},22.764566700892864]
[]
[null,"DEPRECIATION AND REPAIRS (FIXED COST)8"]
[null,"Depreciation ","Buildings, equipment",null,"Table B9",null,null,{"$f":"AT285+AT286+AT287+AT288","v":169.2},{"$f":"H54/$E$10","v":1.6919999999999999}]
[null,"Repairs","Buildings, equipment",null,"Table B9",null,null,{"$f":"AW285+AW286+AW287+AW288","v":89.82},0.89819999999999989]
[null,"Depreciation","Livestock",null,"Table B9",null,null,{"$f":"AT306","v":275},2.75]
[null,"Depreciation","Fences",null,"Table B9",null,null,{"$f":"AT289+AT290+AT291","v":420.51013333333327},4.2051013333333325]
[null,"Repairs","Fences",null,"Table B9",null,null,{"$f":"AW289+AW290+AW291","v":370.07100000000003},3.7007100000000004]
[null,"Depreciation","Machinery",null,"Table B9",null,null,{"$f":"AT299","v":466.66666666666669},4.666666666666667]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(H54:H59)","v":1791.2677999999999},{"$f":"H61/$E$10","v":17.912678}]
[null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"H50+H61","v":13392.311129910713},133.92311129910712]
[null,"RETURN TO LAND, LABOR, CAPITAL,  MANAGEMENT, RISK",null,null,null,null,null,{"$f":"H51-H61","v":485.18887008928664},4.8518887008928662]
[]
[null,"INTEREST (FIXED COST)9"]
[null,"Livestock","Table B9",null,null,null,null,{"$f":"AV306","v":632.5},{"$f":"H66/$E$10","v":6.3250000000000002}]
[null,"Bldgs. & Equip","Table B9",null,null,null,null,{"$f":"AV285+AV286+AV287+AV288","v":31.95},0.31950000000000001]
[null,"Fences","Table B9",null,null,null,null,{"$f":"AV289+AV290+AV291","v":185.03550000000001},1.8503550000000002]
[null,"Machinery","Table B9",null,null,null,null,{"$f":"AV299","v":175},1.75]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,"TOTAL INTEREST EXPENSE",null,null,null,{"$f":"SUM(H66:H69)","v":1024.4855},{"$f":"SUM(I66:I69)","v":10.244854999999999}]
[null,null,"TOTAL VARIABLE, FIXED, INTEREST EXPENSE",null,null,null,null,{"$f":"H62+H71","v":14416.796629910714},{"$f":"H72/$E$10","v":144.16796629910715}]
[null,"NET RETURN TO LAND, LABOR, MANAGEMENT, RISK",null,null,null,null,null,{"$f":"H63-H71","v":-539.29662991071336},-5.3929662991071332]
[]
[null,"LABOR EXPENSES"]
[null,"LABOR10",null,null,"hour",280,{"$f":"Data!$D$58","v":10},{"$f":"F76*G76","v":2800},{"$f":"H76/$E$10","v":28}]
[]
[null,null,null,"TOTAL ALL EXPENSES",null,null,null,{"$f":"H72+H76","v":17216.796629910714},{"$f":"H78/$E$10","v":172.16796629910715}]
[null,null,"RETURN TO LAND, MANAGEMENT, RISK",null,null,null,null,{"$f":"H73-H76","v":-3339.2966299107134},-33.392966299107137]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TABLE B3","COOL-SEASON PASTURE, ANNUAL EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seed",null,null,"lb",0,0,{"$f":"Q91*R91","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",30,{"$f":"Data!$D$20","v":0.43},{"$f":"Q92*R92","v":12.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",30,{"$f":"Data!$D$21","v":0.52},{"$f":"Q93*R93","v":15.600000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",30,{"$f":"Data!$D$22","v":0.44},{"$f":"Q94*R94","v":13.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",0.2,{"$f":"Data!$D$24","v":34.5},6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$27","v":1.82},1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$28","v":0.27},0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$29","v":1.8},1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(S91:S99)","v":57.49},{"$f":"Data!$D$59","v":0.05},{"$f":"Q100*(R100/2)","v":1.4372500000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(S91:S100)","v":58.927250000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$36","v":0.46},{"$f":"Q106*R106","v":0.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$37","v":0.71},0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$38","v":0.09},0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,"Establishment","Pro-rated",null,"acre",1,{"$f":"S156","v":28.248450000000009},28.248450000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(S106:S109)","v":29.508450000000011}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"S102+S111","v":88.435700000000011}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",0.34,{"$f":"Data!$D$58","v":10},{"$f":"Q116*R116","v":3.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ALL ANNUAL EXPENSES",null,null,null,{"$f":"S102+S111+S116","v":91.835700000000017}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TABLE B4","COOL-SEASON PASTURE, ESTABLISHMENT EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seed","Orchardgrass",null,"lb",10,{"$f":"Data!$D$12","v":4},{"$f":"Q125*R125","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Chicory",null,"lb",3,{"$f":"Data!$D$11","v":6},{"$f":"Q126*R126","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Clover",null,"lb",5,{"$f":"Data!$D$14","v":3.25},{"$f":"Q127*R127","v":16.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"White Clover",null,"lb",3,{"$f":"Data!$D$15","v":3.65},10.95]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",30,{"$f":"Data!$D$20","v":0.43},{"$f":"Q129*R129","v":12.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",30,{"$f":"Data!$D$21","v":0.52},{"$f":"Q130*R130","v":15.600000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",30,{"$f":"Data!$D$22","v":0.44},{"$f":"Q131*R131","v":13.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",2,{"$f":"Data!$D$24","v":34.5},69]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$30","v":20.239999999999998},20.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$31","v":3.04},3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$32","v":13.2},13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(S125:S136)","v":237.38000000000002},{"$f":"Data!$D$59","v":0.05},{"$f":"Q137*(R137/2)","v":5.9345000000000008}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(S125:S137)","v":243.31450000000004}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$39","v":6.08},{"$f":"Q143*R143","v":6.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$40","v":9.0299999999999994},9.0299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$41","v":0.96},0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(S143:S145)","v":16.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"S139+S147","v":259.38450000000006}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",2.31,{"$f":"Data!$D$58","v":10},{"$f":"Q152*R152","v":23.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ESTABLISHMENT EXPENSES",null,null,null,{"$f":"S139+S147+S152","v":282.48450000000008}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PRO-RATED SHARE ESTABLISHMENT ",null,null,"years",10,null,{"$f":"S154/Q156","v":28.248450000000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE B5","WARM-SEASON PASTURE, ANNUAL EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seed",null,null,"lb",0,0,{"$f":"AA169*AB169","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",0,{"$f":"Data!$D$20","v":0.43},{"$f":"AA170*AB170","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",20,{"$f":"Data!$D$21","v":0.52},{"$f":"AA171*AB171","v":10.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",20,{"$f":"Data!$D$22","v":0.44},{"$f":"AA172*AB172","v":8.8000000000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",0,{"$f":"Data!$D$24","v":34.5},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$27","v":1.82},1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$28","v":0.27},0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$29","v":1.8},1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(AC169:AC177)","v":28.090000000000003},{"$f":"Data!$D$59","v":0.05},{"$f":"AA178*(AB178/2)","v":0.70225000000000015}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(AC169:AC178)","v":28.792250000000003}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$36","v":0.46},{"$f":"AA184*AB184","v":0.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$37","v":0.71},0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$38","v":0.09},0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Establishment","Pro-rated",null,"acre",1,{"$f":"AC234","v":31.328575000000001},31.328575000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(AC184:AC187)","v":32.588574999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"AC180+AC189","v":61.380825000000002}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",0.34,{"$f":"Data!$D$58","v":10},{"$f":"AA194*AB194","v":3.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ALL ANNUAL EXPENSES",null,null,null,{"$f":"AC180+AC189+AC194","v":64.780825000000007}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE B6","WARM-SEASON PASTURE ESTABLISHMENT EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seed","Sericea Lespedeza",null,"lb",15,{"$f":"Data!$D$16","v":6.25},{"$f":"AA203*AB203","v":93.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Bluestem",null,"lb",4,{"$f":"Data!$D$17","v":11},{"$f":"AA204*AB204","v":44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,0,{"$f":"AA205*AB205","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",0,{"$f":"Data!$D$20","v":0.43},{"$f":"AA207*AB207","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",20,{"$f":"Data!$D$21","v":0.52},{"$f":"AA208*AB208","v":10.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",20,{"$f":"Data!$D$22","v":0.44},{"$f":"AA209*AB209","v":8.8000000000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",2,{"$f":"Data!$D$24","v":34.5},69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$30","v":20.239999999999998},20.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$31","v":3.04},3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$32","v":13.2},13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(AC203:AC214)","v":267.43},{"$f":"Data!$D$59","v":0.05},{"$f":"AA215*(AB215/2)","v":6.6857500000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(AC203:AC215)","v":274.11574999999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$39","v":6.08},{"$f":"AA221*AB221","v":6.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$40","v":9.0299999999999994},9.0299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$41","v":0.96},0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(AC221:AC223)","v":16.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"AC217+AC225","v":290.18574999999998}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",2.31,{"$f":"Data!$D$58","v":10},{"$f":"AA230*AB230","v":23.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ESTABLISHMENT EXPENSES",null,null,null,{"$f":"AC217+AC225+AC230","v":313.28575000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO-RATED SHARE ESTABLISHMENT",null,null,"years",10,null,{"$f":"AC232/AA234","v":31.328575000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE B7","VETERINARY AND MEDICINE EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/",null,"YOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","DESCRIP.","DOSES","HEAD","DOSE","TOTAL","FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deworming","Does/Bucks",3,{"$f":"E10+E11","v":102},{"$f":"Data!$D$44","v":0.5},{"$f":"AI247*AJ247*AK247","v":153}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Does/Bucks",1,{"$f":"E10+E11","v":102},{"$f":"Data!$D$45","v":0.28000000000000003},{"$f":"AI248*AJ248*AK248","v":28.560000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Does/Bucks",1,{"$f":"E10+E11","v":102},{"$f":"Data!$D$46","v":0.37},37.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deworming","Replacements",3,{"$f":"E10*J16","v":15},{"$f":"Data!$D$44","v":0.5},22.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Replacements",1,{"$f":"E10*J16","v":15},{"$f":"Data!$D$45","v":0.28000000000000003},4.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Replacements",1,{"$f":"E10*J16","v":15},{"$f":"Data!$D$46","v":0.37},5.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Kids",2,{"$f":"E10*J10","v":175},{"$f":"Data!$D$45","v":0.28000000000000003},98.000000000000014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Kids",2,{"$f":"E10*J10","v":175},{"$f":"Data!$D$46","v":0.37},129.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Medicine","Per Doe",null,{"$f":"E10","v":100},2,{"$f":"AJ255*AK255","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-------------","-------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VETERINARY & MEDICINE EXPENSES",null,null,null,null,{"$f":"SUM(AL247:AL255)","v":679.05}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE B8","MARKETING EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/",null,"YOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","HEAD","HEAD","TOTAL","FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auction Market Fee",{"$f":"E12+E16","v":132},{"$f":"Data!$D$49","v":5.5},{"$f":"AH265*AI265","v":726}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auction Market Hauling",{"$f":"E12+E16","v":132},{"$f":"Data!$D$50","v":1},{"$f":"AH266*AI266","v":132}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Sales Misc.Cost ",{"$f":"E14","v":29.75},{"$f":"Data!$D$51","v":4},119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Sales Hauling",{"$f":"E14","v":29.75},{"$f":"Data!$D$52","v":2},59.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Marketing",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-------------","-------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MARKETING EXPENSES",null,null,{"$f":"SUM(AJ265:AJ269)","v":1036.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table B9   BUILDING, EQUIPMENT, MACHINERY, AND LIVESTOCK FIXED EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUANTITY","COST","LIFE","DEPREC.","INTEREST","INTEREST","REPAIRS","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM",null,"UNIT ($)","(YEARS)","($/YEAR)","RATE","($/YEAR)","($/YEAR)","($/YEAR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buildings and Equipment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasture Shelters ",3,216,15,{"$f":"(AQ285*AR285)/AS285","v":43.2},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ285*AR285)*0.5)*AU285","v":16.2},{"$f":"(AQ285*AR285)*0.09","v":58.32},{"$f":"AT285+AV285+AW285","v":117.72}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeders ",5,42,5,{"$f":"(AQ286*AR286)/AS286","v":42},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ286*AR286)*0.5)*AU286","v":5.25},{"$f":"(AQ286*AR286)*0.05","v":10.5},57.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral Feeders",2,135,5,{"$f":"(AQ287*AR287)/AS287","v":54},{"$f":"Data!$D$60","v":0.05},6.75,13.5,74.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterers",3,50,5,{"$f":"(AQ288*AR288)/AS288","v":30},{"$f":"Data!$D$60","v":0.05},3.75,7.5,41.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Tensile Permanent Fence (feet)11",5903,1.1399999999999999,25,{"$f":"(AQ289*AR289)/AS289","v":269.17679999999996},{"$f":"Data!$D$60","v":0.05},168.2355,336.471,773.88329999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energizer",1,200,6,{"$f":"(AQ290*AR290)/AS290","v":33.333333333333336},{"$f":"Data!$D$60","v":0.05},5,10,48.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Cross Fence (feet)",2950,0.16,4,118,{"$f":"Data!$D$60","v":0.05},11.8,23.6,153.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BUILDLINGS AND EQUIPMENT",null,null,null,{"$f":"SUM(AT285:AT291)","v":589.71013333333326},null,{"$f":"SUM(AV285:AV291)","v":216.9855},459.89100000000002,{"$f":"SUM(AX285:AX291)","v":1266.5866333333333}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Terrain Vehicle",1,6000,15,{"$f":"(AQ296*AR296)/AS296","v":400},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ296*AR296)*0.5)*AU296","v":150},{"$f":"(AQ296*AR296)*0.04","v":240},{"$f":"AT296+AV296+AW296","v":790}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility Trailer",1,1000,15,66.666666666666671,{"$f":"Data!$D$60","v":0.05},25,{"$f":"(AQ297*AR297)*0.04","v":40},{"$f":"AT297+AV297+AW297","v":131.66666666666669}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MACHINERY",null,null,null,{"$f":"AT296+AT297","v":466.66666666666669},null,{"$f":"AV296+AV297","v":175},280,921.66666666666674]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buck",{"$f":"E11","v":2},175,2,{"$f":"(AQ302*AR302)/AS302","v":175},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ302*AR302))*AU302","v":17.5},"n. a.",{"$f":"AT302+AV302","v":192.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Does & Replacements13",{"$f":"E10+(E10*J16)","v":115},100,null,"n. a.",{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ303*AR303))*AU303","v":575},"n. a.",{"$f":"AV303","v":575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Guardian Dogs ",{"$f":"F43","v":2},400,8,100,{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ304*AR304))*AU304","v":40},"n. a.",{"$f":"AT304+AV304","v":140}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL LIVESTOCK",null,null,null,{"$f":"SUM(AT302:AT304)","v":275},null,{"$f":"SUM(AV302:AV304)","v":632.5},null,{"$f":"SUM(AX302:AX304)","v":907.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes - 100 Doe Budget"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.  The input table (Table B1) contains the parameters for which revenue and expenses are estimated.\n\n2.  The market price for kids sold at auction is based on auction prices from the Tennessee Livestock Producers graded sale for the years 2005 through 2009 assuming 20% were Selection 1, 70% Selection 2, and 10% Selection 3. For this budget, twenty percent of kids are assumed to be direct marketed.  Direct marketing refers to selling meat goats directly to consumers.  Examples of direct sales of meat goats could include (1) animals sold directly to consumers for custom harvesting and processing; (2) animals sold to other meat goat producers for breeding animals; and (3) animals sold to individuals for exhibition at fairs and livestock shows.  Additional costs could result from direct marketing.  Marketing expenses should be adjusted as needed.  Prices received for direct sales can be highly variable.\n\n3.  Feed hay with minimum 54% TDN and 10% crude protein.  This budget assumes purchased hay.\n\n4.  Detailed pasture expenses are contained in Tables B3, B4, B5, and B6.  Expenses are based on 70% of the pasture acres being of perennial cool-season vegetation and 30% perennial warm-season vegetation.  For this budget, the cool-season vegetation consists of chicory, orchardgrass, red clover and white clover.  The warm-season vegetation is sericea lespedeza and big bluestem.  These plant species were used for this example budget.  Other species and combinations can be used, but may require adjustments in pasture production cost.  Annual (or yearly) pasture costs (Tables B3 and B5) include cash variable expenses (annual seed, fertilizer, lime, and fuel and repairs for machinery to mow pastures).  Fixed expenses include depreciation and interest on the equipment and a pro-rated share of the establishment costs.  Establishment costs are outlined in Tables B4 and B6.\n\n5.  One livestock guardian dog is budgeted for every 50 does.  Feed and health expenses for the livestock guardian dogs are included as variable expenses in Table B2.  The purchase price of the dog is depreciated as a fixed cost as shown in Table B9.\n\n6.  Purchased utility water usage is based on breeding animals consuming 1.5 gallons per day year-round with kids consuming one-half gallon per day after weaning.\n\n7.  Variable machinery expenses include fuel and repairs for an all terrain vehicle and repairs for a utility trailer.  Fuel costs are calculated based on a use rate of 0.6 gallons of fuel per hour with fuel cost $2.50 per gallon.  Machinery fixed expenses are outlined in Table B9.  Machinery expenses for pasture production are included in the pasture budgets.\n\n8.  Fixed expenses for depreciation and repairs are outlined in Table B9.  Depreciation divides the initial purchase cost over the expected life of the item.  Repair costs represent an average repair cost per year over the life of the item.\n\n9.  Interest expenses reflect the fact that capital invested in goat production is costly, regardless of its source.  Borrowed capital entails a cash interest charge for repayment to lenders.  Capital provided by the owner results in a non-cash opportunity cost, due to the fact that the capital could have been invested elsewhere and earned interest when the capital was invested in goat production.  The foregone interest is a cost to the owner, but it is not a cash expense.  Interest expenses are included for buildings and equipment, fences, and machinery.  Interest expenses are also included for the value of the breeding livestock used in the enterprise.  These costs are outlined in Table B9.\n\n 10.  Labor expenses are also included in the budget to reflect the cost of hired and/or owner labor.  Again, labor provided by the owner results in a non-cash opportunity cost, due to the earnings foregone by the owner for employment in other agricultural enterprises or off-farm jobs.  Hired labor should be included in the budget as a cash expense.  \n\n11.  Permanent high-tensile fencing costs were based on the number of feet required for a perimeter fence around the entire pasture assuming the pasture is in the shape of a square.  Temporary fencing costs assumed two runs across width of pasture.  Fencing costs will vary with the shape of the pasture and also with the type of fencing material used. \n\n12.  Commercial breeding stock - Buck purchase price is $175 per head.  Buck is used for two years.  Doe value is $100 per head.\n\n13.  Depreciation expense for the does is not included since in the long run the doe herd will consist of raised replacements.\n"]

{"sheet":"180does","index":4,"n_rows":323,"n_cols":53,"rows_kept":323,"cut":false,"hidden":false,"merged":[[9,6,9,8],[11,6,11,8],[21,1,21,3],[19,1,19,2],[9,1,9,2],[13,1,13,2],[10,1,10,2],[11,1,11,3],[12,1,12,3],[20,6,20,8],[23,1,23,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[23,6,23,7],[22,6,22,7],[18,6,18,8],[21,6,21,8],[322,52,376,61]]}
[]
[]
[]
[null,null,null,null,null,"MEAT GOAT PRODUCTION (180 DOES AND 4 BUCKS)"]
[null,null,null,null,null,"40% OF KIDS DIRECT MARKETED"]
[null,null,null,null,null,"FORAGE BASE OF 100 ACRES, HIGH INTENSITY MANAGEMENT"]
[null,null,null,null,null,"ESTIMATED COSTS AND RETURNS TO LAND, MANAGEMENT AND RISK"]
[]
[null,"TABLE C1","INPUT PARAMETERS1"]
[null,"Herd Size (Does)",null,null,180,null,"Percent Weaned Kid Crop",null,null,2.1]
[null,"Bucks",null,null,4]
[null,"Kids Sold Auction Market (head)",null,null,{"$f":"J12*((E10*J10)-((E10*J10)*J16))","v":192.78},null,"Pct. Kids Auction Market",null,null,0.6]
[null,"Selling Weight Auction Market",null,null,65]
[null,"Kids Sold Direct (head)",null,null,{"$f":"J14*((E10*J10)-((E10*J10)*J16))","v":128.52000000000001},null,"Pct. Kids Direct Market",null,null,0.4]
[null,"Selling Weight Direct Market",null,null,65]
[null,"Number of Cull Stock Sold",null,null,{"$f":"(E10*J16)-E18","v":23.4},null,"Held for Replacements",null,null,0.15]
[null,"Selling Weight Cull Does",null,null,80]
[null,"Number of (Does) Died",null,null,{"$f":"E10*J18","v":3.6},null,"Doe Mortality Rate",null,null,0.02]
[null,"Lbs. Corn Doe/Day",null,null,0.5,null,"Days on Corn (Does)",null,null,90]
[null,"Lbs. Hay Doe/Day",null,null,2,null,"Days on Hay (Does)",null,null,120]
[null,"Lbs. Corn Kid/Day Pre-weaning",null,null,0.25,null,"Days Pre-Weaning (Kids)",null,null,21]
[null,"Lbs. Corn Kid/Day Post-weaning",null,null,0.75,null,"Days Post-weaning (Kids)",null,null,60]
[null,"Lbs. Hay Kid/Day",null,null,1,null,"Days on Hay (Kids)",null,null,60]
[null,"Oz Mineral/Day",null,null,0.33,null,"Acres in Forage",null,null,100]
[]
[null,"TABLE C2","ESTIMATED COSTS AND RETURNS"]
[null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","PER DOE","YOUR FARM"]
[null,"REVENUE"]
[null,"Kids Auction2",{"$f":"E12","v":192.78},"Head","cwt",{"$f":"(E12*E13)/100","v":125.307},122,{"$f":"F29*G29","v":15287.454},{"$f":"H29/$E$10","v":84.930300000000003}]
[null,"Kids Direct2",{"$f":"E14","v":128.52000000000001},"Head","cwt",{"$f":"(E14*E15)/100","v":83.538000000000011},200,{"$f":"F30*G30","v":16707.600000000002},{"$f":"H30/$E$10","v":92.820000000000007}]
[null,"Cull Doe ",{"$f":"E16","v":23.4},"Head","cwt",{"$f":"(E16*E17)/100","v":18.72},70,{"$f":"F31*G31","v":1310.3999999999999},7.2799999999999994]
[null,null,null,null,null,null,null,"----------------","----------------","  --------------"]
[null,null,null,null,"TOTAL REVENUE",null,null,{"$f":"SUM(H29:H31)","v":33305.454000000005},{"$f":"SUM(I29:I31)","v":185.03030000000001}]
[]
[null,"VARIABLE EXPENSES"]
[null,"Hay3",null,null,"ton",{"$f":"((J20*E20*(E10+E11+(E10*J16)))/2000)+((J23*E23*(E10*J10))/2000)","v":36.659999999999997},{"$f":"Data!$D$5","v":80},{"$f":"F36*G36","v":2932.7999999999997},{"$f":"H36/$E$10","v":16.293333333333333}]
[null,"Corn ",null,"Breeding","bushels",{"$f":"((E10+E11+(E10*J16))*E19*J19)/56","v":169.55357142857142},{"$f":"Data!$D$6","v":4},{"$f":"F37*G37","v":678.21428571428567},3.7678571428571428]
[null,"Corn ",null,"Kids","bushels",{"$f":"((J22*E22*(E10*J10))/56)+((J21*E21*(E10*J10))/56)","v":339.1875},{"$f":"Data!$D$6","v":4},{"$f":"F38*G38","v":1356.75},7.5374999999999996]
[null,"Cool-Season Pasture4",null,"Table C3","acre",{"$f":"J24*0.7","v":70},{"$f":"S118","v":91.835700000000017},{"$f":"F39*G39","v":6428.4990000000016},35.713883333333342]
[null,"Warm-Season Pasture4",null,"Table C5","acre",{"$f":"J24*0.3","v":30},{"$f":"AC196","v":64.780825000000007},{"$f":"F40*G40","v":1943.4247500000001},10.796804166666668]
[null,"Mineral Mix",null,null,"lb",{"$f":"(((E10+E11)*E24)/16)*365","v":1385.1750000000002},{"$f":"Data!$D$8","v":0.36},498.66300000000007,2.7703500000000005]
[null,"Vet & Med","Table C7",null,null,null,null,{"$f":"AL257","v":988.55},5.4919444444444441]
[null,"Guardian Dogs5","Feed & Health",null,"each",4,{"$f":"Data!$D$56","v":250},{"$f":"F43*G43","v":1000},5.5555555555555554]
[null,"Water6",null,null,"1,000 gal",132.57,{"$f":"Data!$D$57","v":6.6},874.96199999999988,4.8608999999999991]
[null,"Marketing","Table C8",null,null,null,null,{"$f":"AJ271","v":2176.29},12.0905]
[null,"Machinery7","Fuel",null,"hour",115,{"$f":"Data!$D$33","v":1.5},172.5,0.95833333333333337]
[null,"Machinery ","Repairs",null,null,null,null,{"$f":"AW299","v":280},1.5555555555555556]
[null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(H36:H47)","v":19330.653035714287},{"$f":"Data!$D$59","v":0.05},{"$f":"F48*(G48/2)","v":483.2663258928572},2.6848129216269845]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(H36:H48)","v":19813.919361607146},{"$f":"H50/$E$10","v":110.07732978670637}]
[null,null,null,"RETURN ABOVE VARIABLE EXPENSES",null,null,null,{"$f":"H33-H50","v":13491.534638392859},74.952970213293668]
[]
[null,"DEPRECIATION AND REPAIRS (FIXED COST)8"]
[null,"Depreciation ","Buildings, equipment",null,"Table C9",null,null,{"$f":"AT285+AT286+AT287+AT288","v":293},{"$f":"H54/$E$10","v":1.6277777777777778}]
[null,"Repairs","Buildings, equipment",null,"Table C9",null,null,{"$f":"AW285+AW286+AW287+AW288","v":168.29},0.93494444444444436]
[null,"Depreciation","Livestock",null,"Table C9",null,null,{"$f":"AT306","v":550},3.0555555555555554]
[null,"Depreciation","Fences",null,"Table C9",null,null,{"$f":"AT289+AT290+AT291","v":747.92213333333325},4.1551229629629622]
[null,"Repairs","Fences",null,"Table C9",null,null,{"$f":"AW289+AW290+AW291","v":552.62},3.0701111111111112]
[null,"Depreciation","Machinery",null,"Table C9",null,null,{"$f":"AT299","v":466.66666666666669},2.5925925925925926]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(H54:H59)","v":2778.4987999999998},{"$f":"H61/$E$10","v":15.436104444444444}]
[null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"H50+H61","v":22592.418161607147},125.51343423115082]
[null,"RETURN TO LAND, LABOR, CAPITAL,  MANAGEMENT, RISK",null,null,null,null,null,{"$f":"H51-H61","v":10713.03583839286},59.516865768849222]
[]
[null,"INTEREST (FIXED COST)9"]
[null,"Livestock","Table C9",null,null,null,null,{"$f":"AV306","v":1150},{"$f":"H66/$E$10","v":6.3888888888888893}]
[null,"Bldgs. & Equip","Table C9",null,null,null,null,{"$f":"AV285+AV286+AV287+AV288","v":58.225000000000001},0.32347222222222222]
[null,"Fences","Table C9",null,null,null,null,{"$f":"AV289+AV290+AV291","v":276.31},1.5350555555555556]
[null,"Machinery","Table C9",null,null,null,null,{"$f":"AV299","v":175},0.97222222222222221]
[null,null,null,null,null,null,null,"-","-","  --------------"]
[null,null,null,"TOTAL INTEREST EXPENSE",null,null,null,{"$f":"SUM(H66:H69)","v":1659.5349999999999},{"$f":"SUM(I66:I69)","v":9.2196388888888894}]
[null,null,"TOTAL VARIABLE, FIXED, INTEREST EXPENSE",null,null,null,null,{"$f":"H62+H71","v":24251.953161607147},{"$f":"H72/$E$10","v":134.73307312003971}]
[null,"NET RETURN TO LAND, LABOR, MANAGEMENT, RISK",null,null,null,null,null,{"$f":"H63-H71","v":9053.5008383928598},50.297226879960334]
[]
[null,"LABOR EXPENSES"]
[null,"LABOR10",null,null,"hour",470,{"$f":"Data!$D$58","v":10},{"$f":"F76*G76","v":4700},{"$f":"H76/$E$10","v":26.111111111111111}]
[]
[null,null,null,"TOTAL ALL EXPENSES",null,null,null,{"$f":"H72+H76","v":28951.953161607147},{"$f":"H78/$E$10","v":160.84418423115082}]
[null,null,"RETURN TO LAND, MANAGEMENT, RISK",null,null,null,null,{"$f":"H73-H76","v":4353.5008383928598},24.18611576884922]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TABLE C3","COOL-SEASON PASTURE, ANNUAL EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seed",null,null,"lb",0,0,{"$f":"Q91*R91","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",30,{"$f":"Data!$D$20","v":0.43},{"$f":"Q92*R92","v":12.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",30,{"$f":"Data!$D$21","v":0.52},{"$f":"Q93*R93","v":15.600000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",30,{"$f":"Data!$D$22","v":0.44},{"$f":"Q94*R94","v":13.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",0.2,{"$f":"Data!$D$24","v":34.5},6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$27","v":1.82},1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$28","v":0.27},0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$29","v":1.8},1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(S91:S99)","v":57.49},{"$f":"Data!$D$59","v":0.05},{"$f":"Q100*(R100/2)","v":1.4372500000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(S91:S100)","v":58.927250000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$36","v":0.46},{"$f":"Q106*R106","v":0.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$37","v":0.71},0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$38","v":0.09},0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,"Establishment","Pro-rated",null,"acre",1,{"$f":"S156","v":28.248450000000009},28.248450000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(S106:S109)","v":29.508450000000011}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"S102+S111","v":88.435700000000011}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",0.34,{"$f":"Data!$D$58","v":10},{"$f":"Q116*R116","v":3.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ALL ANNUAL EXPENSES",null,null,null,{"$f":"S102+S111+S116","v":91.835700000000017}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TABLE C4","COOL-SEASON PASTURE, ESTABLISHMENT EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Seed","Orchardgrass",null,"lb",10,{"$f":"Data!$D$12","v":4},{"$f":"Q125*R125","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Chicory",null,"lb",3,{"$f":"Data!$D$11","v":6},{"$f":"Q126*R126","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Clover",null,"lb",5,{"$f":"Data!$D$14","v":3.25},{"$f":"Q127*R127","v":16.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"White Clover",null,"lb",3,{"$f":"Data!$D$15","v":3.65},10.95]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",30,{"$f":"Data!$D$20","v":0.43},{"$f":"Q129*R129","v":12.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",30,{"$f":"Data!$D$21","v":0.52},{"$f":"Q130*R130","v":15.600000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",30,{"$f":"Data!$D$22","v":0.44},{"$f":"Q131*R131","v":13.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",2,{"$f":"Data!$D$24","v":34.5},69]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$30","v":20.239999999999998},20.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$31","v":3.04},3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$32","v":13.2},13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(S125:S136)","v":237.38000000000002},{"$f":"Data!$D$59","v":0.05},{"$f":"Q137*(R137/2)","v":5.9345000000000008}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(S125:S137)","v":243.31450000000004}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$39","v":6.08},{"$f":"Q143*R143","v":6.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$40","v":9.0299999999999994},9.0299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$41","v":0.96},0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(S143:S145)","v":16.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"S139+S147","v":259.38450000000006}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",2.31,{"$f":"Data!$D$58","v":10},{"$f":"Q152*R152","v":23.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ESTABLISHMENT EXPENSES",null,null,null,{"$f":"S139+S147+S152","v":282.48450000000008}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PRO-RATED SHARE ESTABLISHMENT ",null,null,"years",10,null,{"$f":"S154/Q156","v":28.248450000000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE C5","WARM-SEASON PASTURE, ANNUAL EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seed",null,null,"lb",0,0,{"$f":"AA169*AB169","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",0,{"$f":"Data!$D$20","v":0.43},{"$f":"AA170*AB170","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",20,{"$f":"Data!$D$21","v":0.52},{"$f":"AA171*AB171","v":10.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",20,{"$f":"Data!$D$22","v":0.44},{"$f":"AA172*AB172","v":8.8000000000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",0,{"$f":"Data!$D$24","v":34.5},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$27","v":1.82},1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$28","v":0.27},0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$29","v":1.8},1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(AC169:AC177)","v":28.090000000000003},{"$f":"Data!$D$59","v":0.05},{"$f":"AA178*(AB178/2)","v":0.70225000000000015}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(AC169:AC178)","v":28.792250000000003}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$36","v":0.46},{"$f":"AA184*AB184","v":0.46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$37","v":0.71},0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$38","v":0.09},0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Establishment","Pro-rated",null,"acre",1,{"$f":"AC234","v":31.328575000000001},31.328575000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(AC184:AC187)","v":32.588574999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"AC180+AC189","v":61.380825000000002}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",0.34,{"$f":"Data!$D$58","v":10},{"$f":"AA194*AB194","v":3.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ALL ANNUAL EXPENSES",null,null,null,{"$f":"AC180+AC189+AC194","v":64.780825000000007}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE C6","WARM-SEASON PASTURE ESTABLISHMENT EXPENSES PER ACRE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","    DESCRIPTION",null,"UNIT","QUANTITY","PRICE","TOTAL","YOUR FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seed","Sericea Lespedeza",null,"lb",15,{"$f":"Data!$D$16","v":6.25},{"$f":"AA203*AB203","v":93.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Bluestem",null,"lb",4,{"$f":"Data!$D$17","v":11},{"$f":"AA204*AB204","v":44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,0,{"$f":"AA205*AB205","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer","N",null,"lb",0,{"$f":"Data!$D$20","v":0.43},{"$f":"AA207*AB207","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2O5",null,"lb",20,{"$f":"Data!$D$21","v":0.52},{"$f":"AA208*AB208","v":10.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K2O",null,"lb",20,{"$f":"Data!$D$22","v":0.44},{"$f":"AA209*AB209","v":8.8000000000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Application",null,"acre",1,{"$f":"Data!$D$23","v":5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lime","Custom Application",null,"acre",2,{"$f":"Data!$D$24","v":34.5},69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery ","Fuel",null,"acre",1,{"$f":"Data!$D$30","v":20.239999999999998},20.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil & Filter",null,"acre",1,{"$f":"Data!$D$31","v":3.04},3.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs",null,"acre",1,{"$f":"Data!$D$32","v":13.2},13.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Interest - 6 months",null,null,null,{"$f":"SUM(AC203:AC214)","v":267.43},{"$f":"Data!$D$59","v":0.05},{"$f":"AA215*(AB215/2)","v":6.6857500000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE EXPENSES",null,null,{"$f":"SUM(AC203:AC215)","v":274.11574999999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIATION AND INTEREST (FIXED COST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery","Depreciation",null,"acre",1,{"$f":"Data!$D$39","v":6.08},{"$f":"AA221*AB221","v":6.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,"acre",1,{"$f":"Data!$D$40","v":9.0299999999999994},9.0299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Housing & Insurance",null,"acre",1,{"$f":"Data!$D$41","v":0.96},0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","  --------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FIXED EXPENSES",null,null,{"$f":"SUM(AC221:AC223)","v":16.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VARIABLE & FIXED EXPENSES",null,null,null,{"$f":"AC217+AC225","v":290.18574999999998}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR EXPENSES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR",null,null,"hour",2.31,{"$f":"Data!$D$58","v":10},{"$f":"AA230*AB230","v":23.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ESTABLISHMENT EXPENSES",null,null,null,{"$f":"AC217+AC225+AC230","v":313.28575000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRO-RATED SHARE ESTABLISHMENT",null,null,"years",10,null,{"$f":"AC232/AA234","v":31.328575000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE C7","VETERINARY AND MEDICINE EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/",null,"YOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","DESCRIP.","DOSES","HEAD","DOSE","TOTAL","FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deworming","Does/Bucks",0,{"$f":"E10+E11","v":184},{"$f":"Data!$D$44","v":0.5},{"$f":"AI247*AJ247*AK247","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Does/Bucks",1,{"$f":"E10+E11","v":184},{"$f":"Data!$D$45","v":0.28000000000000003},{"$f":"AI248*AJ248*AK248","v":51.52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Does/Bucks",1,{"$f":"E10+E11","v":184},{"$f":"Data!$D$46","v":0.37},68.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deworming","Replacements",0,{"$f":"E10*J16","v":27},{"$f":"Data!$D$44","v":0.5},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Replacements",1,{"$f":"E10*J16","v":27},{"$f":"Data!$D$45","v":0.28000000000000003},7.5600000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Replacements",1,{"$f":"E10*J16","v":27},{"$f":"Data!$D$46","v":0.37},9.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clostridium/Tetanus","Kids",2,{"$f":"E10*J10","v":378},{"$f":"Data!$D$45","v":0.28000000000000003},211.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lepto","Kids",2,{"$f":"E10*J10","v":378},{"$f":"Data!$D$46","v":0.37},279.71999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Medicine","Per Doe",null,{"$f":"E10","v":180},2,{"$f":"AJ255*AK255","v":360}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-------------","-------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL VETERINARY & MEDICINE EXPENSES",null,null,null,null,{"$f":"SUM(AL247:AL255)","v":988.55}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE C8","MARKETING EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/",null,"YOUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM","HEAD","HEAD","TOTAL","FARM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auction Market Fee",{"$f":"E12+E16","v":216.18},{"$f":"Data!$D$49","v":5.5},{"$f":"AH265*AI265","v":1188.99}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auction Market Hauling",{"$f":"E12+E16","v":216.18},{"$f":"Data!$D$50","v":1},{"$f":"AH266*AI266","v":216.18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Sales Misc.Cost ",{"$f":"E14","v":128.52000000000001},{"$f":"Data!$D$51","v":4},514.08000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Sales Hauling",{"$f":"E14","v":128.52000000000001},{"$f":"Data!$D$52","v":2},257.04000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Marketing",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-------------","-------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MARKETING EXPENSES",null,null,{"$f":"SUM(AJ265:AJ269)","v":2176.29}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table C9   BUILDING, EQUIPMENT, MACHINERY, AND LIVESTOCK FIXED EXPENSES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUANTITY","COST","LIFE","DEPREC.","INTEREST","INTEREST","REPAIRS","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM",null,"UNIT ($)","(YEARS)","($/YEAR)","RATE","($/YEAR)","($/YEAR)","($/YEAR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buildings and Equipment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasture Shelters ",6,216,15,{"$f":"(AQ285*AR285)/AS285","v":86.4},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ285*AR285)*0.5)*AU285","v":32.4},{"$f":"(AQ285*AR285)*0.09","v":116.64},{"$f":"AT285+AV285+AW285","v":235.44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeders ",9,42,5,{"$f":"(AQ286*AR286)/AS286","v":75.599999999999994},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ286*AR286)*0.5)*AU286","v":9.4500000000000011},{"$f":"(AQ286*AR286)*0.05","v":18.900000000000002},103.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral Feeders",3,135,5,{"$f":"(AQ287*AR287)/AS287","v":81},{"$f":"Data!$D$60","v":0.05},10.125,20.25,111.375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterers",5,50,5,{"$f":"(AQ288*AR288)/AS288","v":50},{"$f":"Data!$D$60","v":0.05},6.25,12.5,68.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Tensile Permanent Fence (feet)11",8348,1.1399999999999999,25,{"$f":"(AQ289*AR289)/AS289","v":380.66879999999998},{"$f":"Data!$D$60","v":0.05},237.91800000000001,475.83600000000001,1094.4228000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energizer",1,200,6,{"$f":"(AQ290*AR290)/AS290","v":33.333333333333336},{"$f":"Data!$D$60","v":0.05},5,10,48.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Cross Fence (feet)",8348,0.16,4,333.92,{"$f":"Data!$D$60","v":0.05},33.392000000000003,66.784000000000006,434.096]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BUILDLINGS AND EQUIPMENT",null,null,null,{"$f":"SUM(AT285:AT291)","v":1040.9221333333332},null,{"$f":"SUM(AV285:AV291)","v":334.53500000000003},720.91,{"$f":"SUM(AX285:AX291)","v":2096.3671333333332}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machinery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Terrain Vehicle",1,6000,15,{"$f":"(AQ296*AR296)/AS296","v":400},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ296*AR296)*0.5)*AU296","v":150},{"$f":"(AQ296*AR296)*0.04","v":240},{"$f":"AT296+AV296+AW296","v":790}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility Trailer",1,1000,15,66.666666666666671,{"$f":"Data!$D$60","v":0.05},25,{"$f":"(AQ297*AR297)*0.04","v":40},{"$f":"AT297+AV297+AW297","v":131.66666666666669}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MACHINERY",null,null,null,{"$f":"AT296+AT297","v":466.66666666666669},null,{"$f":"AV296+AV297","v":175},280,921.66666666666674]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buck",{"$f":"E11","v":4},175,2,{"$f":"(AQ302*AR302)/AS302","v":350},{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ302*AR302))*AU302","v":35},"n. a.",{"$f":"AT302+AV302","v":385}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Does & Replacements13",{"$f":"E10+(E10*J16)","v":207},100,null,"n. a.",{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ303*AR303))*AU303","v":1035},"n. a.",{"$f":"AV303","v":1035}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Guardian Dogs ",{"$f":"F43","v":4},400,8,200,{"$f":"Data!$D$60","v":0.05},{"$f":"((AQ304*AR304))*AU304","v":80},"n. a.",{"$f":"AT304+AV304","v":280}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL LIVESTOCK",null,null,null,{"$f":"SUM(AT302:AT304)","v":550},null,{"$f":"SUM(AV302:AV304)","v":1150},null,{"$f":"SUM(AX302:AX304)","v":1700}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes - 180 Doe Budget"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.  The input table (Table C1) contains the parameters for which revenue and expenses are estimated.\n\n2.  The market price for kids sold at auction is based on auction prices from the Tennessee Livestock Producers graded sale for the years 2005 through 2009 assuming 30% were Selection 1, 60% Selection 2, and 10% Selection 3.  For this budget, forty percent of kids are assumed to be direct marketed.  Direct marketing refers to selling meat goats directly to consumers.  Examples of direct sales of meat goats could include (1) animals sold directly to consumers for custom harvesting and processing; (2) animals sold to other meat goat producers for breeding animals; and (3) animals sold to individuals for exhibition at fairs and livestock shows.  Additional costs could result from direct marketing.  Marketing expenses should be adjusted as needed.  Prices received for direct sales can be highly variable.\n\n3.  Feed hay with minimum 54% TDN and 10% crude protein.  This budget assumes purchased hay.\n\n4.  Detailed pasture expenses are contained in Tables C3, C4, C5, and C6.  Expenses are based on 70% of the pasture acres being of perennial cool-season vegetation and 30% perennial warm-season vegetation.  For this budget, the cool-season vegetation consists of chicory, orchardgrass, red clover and white clover.  The warm-season vegetation is sericea lespedeza and big bluestem.  These plant species were used for this example budget.  Other species and combinations can be used, but may require adjustments in pasture production cost.  Annual (or yearly) pasture costs (Tables C3 and C5) include cash variable expenses (annual seed, fertilizer, lime, and fuel and repairs for machinery to mow pastures).  Fixed expenses include depreciation and interest on the equipment and a pro-rated share of the establishment costs.  Establishment costs are outlined in Tables C4 and C6.\n\n5.  One livestock guardian dog is budgeted for every 50 does.  Feed and health expenses for the livestock guardian dogs are included as variable expenses in Table C2.  The purchase price of the dog is depreciated as a fixed cost as shown in Table C9.\n\n6.  Purchased utility water usage is based on breeding animals consuming 1.5 gallons per day year-round with kids consuming one-half gallon per day after weaning.\n\n7.  Variable machinery expenses include fuel and repairs for a utility vehicle and repairs for a utility trailer.  Fuel costs are calculated based on a use rate of 0.6 gallons of fuel per hour with fuel cost $2.50 per gallon.  Machinery fixed expenses are outlined in Table C9.  Machinery expenses for pasture production are included in the pasture budgets.\n\n8.  Fixed expenses for depreciation and repairs are outlined in Table C9.  Depreciation divides the initial purchase cost over the expected life of the item.  Repair costs represent an average repair cost per year over the life of the item.\n\n9.  Interest expenses reflect the fact that capital invested in goat production is costly, regardless of its source.  Borrowed capital entails a cash interest charge for repayment to lenders.  Capital provided by the owner results in a non-cash opportunity cost, due to the fact that the capital could have been invested elsewhere and earned interest when the capital was invested in goat production.  The foregone interest is a cost to the owner, but it is not a cash expense.  Interest expenses are included for buildings and equipment, fences, and machinery.  Interest expenses are also included for the value of the breeding livestock used in the enterprise.  These costs are outlined in Table C9.\n\n 10.  Labor expenses are also included in the budget to reflect the cost of hired and/or owner labor.  Again, labor provided by the owner results in a non-cash opportunity cost, due to the earnings foregone by the owner for employment in other agricultural enterprises or off-farm jobs.  Hired labor should be included in the budget as a cash expense.  \n\n11.  Permanent high-tensile fencing costs were based on the number of feet required for a perimeter fence around the entire pasture assuming the pasture is in the shape of a square.  Temporary fencing costs assumed four runs across width of pasture.  Fencing costs will vary with the shape of the pasture and also with the type of fencing material used. \n\n12.  Commercial breeding stock - Buck purchase price is $175 per head.  Buck is used for two years.  Doe value is $100 per head.\n\n13.  Depreciation expense for the does is not included since in the long run the doe herd will consist of raised replacements.\n"]