{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","Goat_Budget","mix_grass_budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
["Review the information in the green section – to change specific values, enter your own values in the dark green cells"]
["NUMBER OF DOES = the total number of does currently in your operation"]
["DOES PER ACRE = carrying capacity of your operation (total number of does divided by total number of pasture acres)"]
["CULLING RATE (DOES) = total number of does culled each year as a percent of total number of does (number of does culled each year divided by total number of does in operation)"]
["DEATH LOSS (DOES & KIDS) = total number of does and kids that die from birth through marketing"]
["LABOR (HOURS/DOE) = number of hours for paid labor per doe owned per year"]
["AVERAGE DOE WEIGHT (LBS) = the average body weight of does owned (pounds)"]
["NUMBER OF BUCKS = total number of bucks in the operation (recommended: 1 buck per 25 does)"]
["AVG. AMOUNT OF FEED FED/HEAD/DAY (BUCKS) = the average number of pounds of feed fed to bucks per day (breeding and confinement)"]
["AVG. AMOUNT OF HAY FED/HEAD/DAY (BUCKS) = the average number of pounds of hay fed to bucks per day (breeding and confinement)"]
["NUMBER OF DAYS FEED & HAY IS FED (BUCKS) = total number of days bucks are fed feed and hay during the year (breeding and confinement)"]
["DOES KEPT FOR REPLACEMENT = number of does kept from the kid crop for replacement in the operation"]
["AMOUNT FINANCED = total amount of money borrowed to fund the operation"]
["ANNUAL INTEREST RATE = annualized interest rate of money borrowed"]
["AVG. AMOUNT OF HAY FED/HEAD/DAY (DOES) = the average number of pounds of hay fed to does each day while hay is provided"]
["NUMBER OF DAYS HAY IS FED (DOES) = the number of days hay is fed to does during the year"]
["AVG. AMOUNT OF FEED FED/HEAD/DAY (DOES) = the average number of pounds of feed fed to does each day while feed is provided"]
["NUMBER OF DAYS FEED IS FED (DOES) = the number of days feed is fed to does during the year"]
["KIDS WEANED/DOE = average number of kids weaned per doe each year (total number of kids born divided by the total number of does)"]
["DAYS OF CREEP FEEDING (KIDS) = total number of days kids are provided creep feed during the year"]
["LBS CREEP FEED FED/HEAD/DAY (KIDS) = average pounds of feed provided to kids each day by way of creep feeding"]
["AVG. KID SALE WEIGHT (LBS) = average weight of kids sold at market"]
["DOE VALUE ($/HEAD) = average value of each doe in the operation"]
["BUCK VALUE ($/HEAD) = average value of each buck in the operation"]
["MARKET KID PRICE ($/LB) = average price per pound for all market kids sold"]
["CULL DOE PRICE ($/LB) = average price per pound for all does sold as culls"]
[]
["OPTIONAL: Review the prices in the orange cells under “Direct Expenses” section – to change specific prices, enter your own values in these cells"]
["Supplemental Feed (does) = cost per pound for the feed that is provided to does"]
["Creep Feed (kids) = cost per pound for the feed provided to kids (as a creep feed)"]
["Hay = cost per round bale for hay"]
["     -- If feeding square bales: one round bale equals approximately 17 square bales. To calculate hay cost multiply individual square bale cost times 17."]
["Salt & Mineral = cost per pound of salt and/or mineral provided during the year"]
["Vet & Medicine = cost per head of all vet and medical supplies provided to does and buck during the year"]
["Deworming – breeding stock = cost per single dose to deworm breeding stock"]
["Deworming –  kids = cost per single dose to deworm kids"]
["Vaccinations – breeding stock =  cost per single dose to vaccinate breeding stock"]
["Vaccinations –  kids = cost per single dose to vaccinate kids"]
["Hired Labor = cost per hour for hired help"]
["Marketing Expenses = cost per head to market all goats sold from the operation each year (include yardage and commission)"]

{"sheet":"Goat_Budget","index":1,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9]]}
["Meat Goat Production Budget"]
["Mississippi, 2013"]
[]
[]
["ASSUMPTIONS USED IN BUDGET:"]
[null,25,"NUMBER OF DOES",null,null,3.5,"AVG. AMOUNT OF HAY FED/HEAD/DAY (DOES)"]
[null,6,"DOES PER ACRE",null,null,150,"NUMBER OF DAYS HAY IS FED (DOES)"]
[null,0.15,"CULLING RATE (DOES)",null,null,0.8,"AVG. AMOUNT OF FEED FED/HEAD/DAY (DOES)"]
[null,0.18,"DEATH LOSS (DOES & KIDS)",null,null,60,"NUMBER OF DAYS FEED IS FED (DOES)"]
[null,0.5,"LABOR (HOURS/DOE)",null,null,1.5,"KIDS WEANED/DOE"]
[null,130,"AVG. DOE WEIGHT (LBS)",null,null,60,"DAYS OF CREEP FEEDING (KIDS)"]
[null,1,"NUMBER OF BUCKS",null,null,0.5,"LBS CREEP FEED FED/HEAD/DAY (KIDS)"]
[null,2,"AVG. AMOUNT OF FEED FED/HEAD/DAY (BUCKS)",null,null,75,"AVG. KID SALE WEIGHT (LBS)"]
[null,4,"AVG. AMOUNT OF HAY FED/HEAD/DAY (BUCKS)",null,null,120,"DOE VALUE ($/HEAD)"]
[null,250,"NUMBER OF DAYS FEED & HAY IS FED (BUCKS)",null,null,250,"BUCK VALUE ($/HEAD)"]
[null,0,"DOES KEPT FOR REPLACEMENT",null,null,1.5,"MARKET KID PRICE ($/LB)"]
[null,0,"AMOUNT FINANCED",null,null,0.6,"CULL DOE PRICE ($/LB)"]
[null,6.5000000000000002E-2,"ANNUAL INTEREST RATE"]
["CURRENT BREEDING STOCK VALUE"]
[null,"Doe Purchase",null,null,null,"head",{"$f":"B6","v":25},{"$f":"F14","v":120},{"$f":"H20*G20","v":3000}]
[null,"Buck Purchase",null,null,null,"head",{"$f":"B12","v":1},{"$f":"F15","v":250},{"$f":"H21*G21","v":250}]
[]
["TOTAL BREEDING VALUE",null,null,null,null,null,null,null,{"$f":"SUM(I20:I21)","v":3250}]
[]
[null,null,null,null,null,null,null,"Price or Cost","Total","Value/Cost"]
[null,null,null,null,"Head","Unit","Quantity","per Unit","Value/Cost","per Head"]
["INCOME"]
[null,"Market Kids",null,null,{"$f":"TRUNC(B6*F10,0)-B16","v":37},"lbs",{"$f":"E28*F13","v":2775},{"$f":"F16","v":1.5},{"$f":"H28*G28","v":4162.5},{"$f":"I28/E$28","v":112.5}]
[null,"Cull Does",null,null,{"$f":"TRUNC(B6*B8,0)","v":3},"lbs",{"$f":"E29*B11","v":390},{"$f":"F17","v":0.6},{"$f":"H29*G29","v":234},{"$f":"I29/E$28","v":6.3243243243243246}]
[]
["GROSS INCOME",null,null,null,null,null,null,null,{"$f":"SUM(I28:I29)","v":4396.5},{"$f":"I31/B$6","v":175.86}]
[]
["DIRECT EXPENSES"]
[null,"Pasture Cost",null,null,null,"acre",{"$f":"ROUNDUP((B6/B7),0)","v":5},{"$f":"mix_grass_budget!G31","v":162.66445800000002},{"$f":"H34*G34","v":813.32229000000007},{"$f":"I34/B$6","v":32.532891599999999}]
[null,"Supplemental Feed (does)",null,null,null,"lbs",{"$f":"B6*F8*F9","v":1200},0.3,{"$f":"H35*G35","v":360},{"$f":"I35/B$6","v":14.4}]
[null,"Creep Feed (kids)",null,null,null,"lbs",{"$f":"E28*(F11*F12)","v":1110},0.3,{"$f":"H36*G36","v":333},{"$f":"I36/B$6","v":13.32}]
[null,"Hay",null,null,null,"Round Bale",{"$f":"(F6*B6*F7)/1200","v":10.9375},50,546.875,21.875]
[null,"Salt & Mineral",null,null,null,"lbs",{"$f":"2*B6","v":50},0.56000000000000005,{"$f":"H38*G38","v":28.000000000000004},1.1200000000000001]
[null,"Vet & Medicine",null,null,null,"head",{"$f":"B6+B12","v":26},6,156,6.24]
[null,"   Deworming"]
[null,"      breeding stock",null,null,null,"doses",{"$f":"2*(B6+B12)","v":52},1,52,2.08]
[null,"      kids",null,null,null,"doses",{"$f":"3*ROUND((B6*F10),0)","v":114},0.25,28.5,1.1399999999999999]
[null,"   Vaccinations"]
[null,"      breeding stock",null,null,null,"doses",{"$f":"2*(B6+B12)","v":52},0.55000000000000004,28.6,1.1440000000000001]
[null,"      kids",null,null,null,"doses",{"$f":"2*ROUND((B6*F10),0)","v":76},0.6,45.6,1.8240000000000001]
[null,"Hired Labor",null,null,null,"hour",{"$f":"B10*B6","v":12.5},8,100,4]
[null,"Misc. Supplies",null,null,null,"head",{"$f":"B6","v":25},1.5,37.5,1.5]
[null,"Buck Maintenance Expense",null,null,null,"head",{"$f":"B12","v":1},{"$f":"(B12*B13*B15*H35)+((B12*B14*F7*H37)/1200)","v":175},{"$f":"H48*G48","v":175},7]
[null,"Repair & Maint. (Buildings/Equip.)",null,null,null,"dollars",null,null,{"$f":"M89","v":34.393333333333338},1.3757333333333335]
[null,"Vehicle Fuel & Oil",null,null,null,"dollars",null,null,{"$f":"M85+(15*12)","v":215.71428571428572},8.6285714285714281]
[null,"Buck Replacement",null,null,null,"head",{"$f":"B12/3","v":0.33333333333333331},{"$f":"F15","v":250},{"$f":"H51*G51","v":83.333333333333329},3.333333333333333]
[null,"Doe Replacement",null,null,null,"head",{"$f":"TRUNC(B6*B8,0)","v":3},{"$f":"F14","v":120},{"$f":"H52*G52","v":360},{"$f":"I52/B$6","v":14.4}]
[null,"Marketing Expenses",null,null,null,"head",{"$f":"E28+E29","v":40},4,{"$f":"H53*G53","v":160},6.4]
[null,"Yearly Financing Expenses",null,null,null,"%",{"$f":"B18","v":6.5000000000000002E-2},{"$f":"B17","v":0},{"$f":"H54*G54","v":0},0]
[]
["TOTAL DIRECT EXPENSES",null,null,null,null,null,null,null,{"$f":"SUM(I34:I54)","v":3557.8382423809526},{"$f":"I56/B$6","v":142.31352969523812}]
["RETURN OVER DIRECT EXPENSES",null,null,null,null,null,null,null,{"$f":"I31-I56","v":838.66175761904742},{"$f":"J31-J56","v":33.546470304761897}]
[]
["FIXED EXPENSES"]
[null,"General Overhead",null,null,null,"head",{"$f":"B6","v":25},1.25,{"$f":"H60*G60","v":31.25},{"$f":"I60/B$6","v":1.25}]
[null,"Interest on Buildings and Equip.",null,null,null,"%",{"$f":"G54","v":6.5000000000000002E-2},{"$f":"G89","v":3595},{"$f":"H61*(G61*(F9/365))","v":38.412328767123284},{"$f":"I61/B$6","v":1.5364931506849313}]
[null,"Depreciation",null,null,null,"dollars",null,null,{"$f":"L89","v":193.12619047619046},7.7250476190476185]
[null,"Taxes & Insurance",null,null,null,"dollars",null,null,{"$f":"N89","v":62.912499999999994},2.5164999999999997]
[]
["TOTAL FIXED EXPENSES",null,null,null,null,null,null,null,{"$f":"SUM(I60:I63)","v":325.70101924331379},{"$f":"I65/B$6","v":13.028040769732552}]
[]
["TOTAL SPECIFIED EXPENSES",null,null,null,null,null,null,null,{"$f":"I56+I65","v":3883.5392616242661},{"$f":"I67/B$6","v":155.34157046497066}]
[]
["RETURN OVER TOTAL SPECIFIED EXPENSES",null,null,null,null,null,null,null,{"$f":"I31-I67","v":512.96073837573385},{"$f":"I69/B$6","v":20.518429535029355}]
[]
[]
[]
[]
["FACILITIES AND EQUIPMENT USED IN DIRECT & FIXED EXPENSE SECTIONS: "]
[]
[null,"ITEM",null,"ESTIMATED",null,"PROPORTION","TOTAL"," SALVAGE","YEARS",null,"SALVAGE",null,null,"TAXES &"]
[null,null,null,"COST","NUMBER"," CHARGED"," CHARGED"," VALUE(%)"," OF LIFE",null,"VALUE","DEPREC.","REPAIRS","INS."]
[null,null,null,null,"",null,""]
[]
[null,"FENCING",null,2300,1,0.67,{"$f":"D80*E80*F80","v":1541},0,15,null,{"$f":"(G80*H80)","v":0},{"$f":"(AVERAGE(G80,K80)/I80)","v":51.366666666666667},{"$f":"(0.2*G80)/I80","v":20.54666666666667},{"$f":"0.0175*G80","v":26.967500000000001}]
[null,"CORRAL",null,500,1,0.67,{"$f":"D81*E81*F81","v":335},0,15,null,{"$f":"(G81*H81)","v":0},11.166666666666666,4.4666666666666668,5.8625000000000007]
[null,"FEED BUNK",null,250,1,0.67,167.5,0,10,null,0,8.375,3.35,2.9312500000000004]
[null,"WATER TANK, ETC.",null,250,1,0.67,167.5,0,10,null,0,8.375,3.35,2.9312500000000004]
[null,"MINERAL FEEDER",null,200,1,0.67,134,0,10,null,0,6.7,2.68,2.3450000000000002]
[null,"PICKUP",null,25000,1,0.05,1250,0.2,7,null,250,107.14285714285714,35.714285714285715,21.875000000000004]
[]
[]
[]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G80:G85)","v":3595},null,null,null,{"$f":"SUM(K80:K84)","v":0},{"$f":"SUM(L80:L85)","v":193.12619047619046},{"$f":"SUM(M80:M84)","v":34.393333333333338},{"$f":"SUM(N80:N85)","v":62.912499999999994}]

{"sheet":"mix_grass_budget","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Table 7.B Estimated costs per acre"]
["Permanent summer pasture maintenance (i.e. bahia,"]
["bermuda, dallisgrass, mixed grasses),Mississippi, 2012"]
[]
[null,null,"ITEM"," UNIT"," PRICE"," QUANTITY"," AMOUNT"]
[]
["DIRECT EXPENSES"]
[null,"FERTILIZER"]
[null,null,"Fert. 33-0-0-12s","cwt",19,3,{"$f":"E9*F9","v":57}]
[null,null,"Phosphate (46% P2O5)","cwt",28.65,1,{"$f":"E10*F10","v":28.65}]
[null,null,"Potash (60% K2O)","cwt",29.19,1,{"$f":"E11*F11","v":29.19}]
[null,"HERBICIDE"]
[null,null,"GrazonNext","pt",4.5599999999999996,2,{"$f":"E13*F13","v":9.1199999999999992}]
[null,"CUSTOM FERT"]
[null,null,"Custom Spread(Truck)","appl",7,2,{"$f":"E15*F15","v":14}]
[null,"SERVICE FEE"]
[null,null,"Soil Testing","acre",0.6,1,0.6]
[null,"CUSTOM LIME"]
[null,null,"Lime (Spread)","ton",44,0.33,14.520000000000001]
[null,"OPERATOR LABOR"]
[null,null,"Tractors","hour",11.6,0.1608,1.8652799999999998]
[null,"HAND LABOR"]
[null,null,"Implements","hour",9.06,3.1300000000000001E-2,0.28357800000000005]
[null,"DIESEL FUEL"]
[null,null,"Tractors","gal",3.6,0.621,2.2356000000000003]
[null,"REPAIR & MAINTENANCE"]
[null,null,"Implements","acre",1.01,1,1.01]
[null,null,"Tractors","acre",0.18,1,0.18]
[null,"INTEREST ON OP. CAP.",null,"acre",4.01,1,4.01]
[]
["TOTAL DIRECT EXPENSES",null,null," ",null,null,{"$f":"SUM(G9:G29)","v":162.66445800000002}]
["FIXED EXPENSES"]
[null,null,"Implements","acre",0.8,1,{"$f":"E33*F33","v":0.8}]
[null,null,"Tractors","acre",1.1000000000000001,1,1.1000000000000001]
[null,null,"Prorated Est Cost","acre",25.99,1,25.99]
[]
["TOTAL FIXED EXPENSES",null,null,null,null,null,{"$f":"SUM(G33:G35)","v":27.889999999999997}]
[]
["TOTAL SPECIFIED EXPENSES",null,null,null,null,null,{"$f":"G31+G37","v":190.55445800000001}]
[]
["Note: Cost of production estimates are based on 2012 input prices."]