{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instructions","Main","Bermuda","Fescue","Winter_Grazing","Summer_Annual","Hay","Feed","Vet","Auction","Lvstk_Facil","Equipment","Fixed_Cost","Fixed_Payment","J","K","L","M","N","O"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":281,"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":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"       WELCOME TO THE NORTH GEORGIA",null,null,null,null,null,"REMEMBER"]
[null,null,"COW-CALF  BUDGET"]
[null,null,null,null,null,null,"  In order to Print a specific budget"]
[null,null,"Budget","Button",null,null,"  you must Calculate before you"]
[null,null," Type",null,null,null,"  Print that particular budget."]
[]
[null,null,"TOTAL","  "]
[null,null,"COST",null,null,null,null,"NOTE"]
[]
[null,null,"CASH ",null,null,null,"  All input in red and black is not to"]
[null,null,"FLOW",null,null,null,"  be tampered with! Only type into"]
[null,null,null,null,null,null,"  cells that contain green characters."]
[null,null," VARIABLE "]
[null,null,"COST"]
[]
[null,null,"Note: Be sure to enable all"]
[null,null,"macros on start-up."]

{"sheet":"Main","index":1,"n_rows":278,"n_cols":52,"rows_kept":278,"cut":false,"hidden":false,"merged":[[26,1,26,2],[74,1,74,2],[75,1,75,2],[83,1,83,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[67,1,67,2],[65,1,65,2],[66,1,66,2],[76,1,76,2],[55,1,55,2],[72,1,72,2],[31,1,31,2],[35,1,35,2],[36,1,36,2],[109,1,109,9],[107,1,107,9],[108,1,108,9],[106,1,106,9],[23,1,23,2],[24,1,24,2],[25,1,25,2],[73,1,73,2],[68,1,68,2],[63,1,63,2],[43,9,44,9],[43,8,44,8],[95,1,95,9],[46,1,46,2],[70,1,70,2],[64,1,64,2],[19,1,19,2],[20,1,20,2],[22,1,22,2],[21,1,21,2],[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[9,1,10,2],[12,1,12,11],[14,1,14,9],[13,1,13,9],[17,1,17,2],[18,1,18,2],[37,1,37,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[38,1,38,2],[39,1,39,2],[60,1,60,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[40,1,40,2],[51,1,51,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[92,1,92,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[61,1,61,2],[62,1,62,2],[36,14,36,17],[34,13,35,17],[126,1,126,2],[127,1,127,2],[117,5,117,8],[118,5,118,8],[119,5,119,8],[125,1,125,2],[76,3,76,4],[77,3,77,4],[78,3,78,4],[91,1,91,2],[87,1,87,2],[85,1,85,2],[84,1,84,2],[86,1,86,2]]}
[null," COW-CALF BUDGET (NORTH GEORGIA)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,3,null,null,null,3,2,1]
[null,"Revised by Levi Russell, 2018"]
[null,"Extension Agricultural Economics Department, University of Georgia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Total Cost Budget)"]
[null,"Based on Budgets Originally Developed by John C. McKissick",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Cash Cost 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,"(Variable Cost Budget)"]
[]
[]
[null,"INPUT DATA: Your values in the unprotected or highlighted cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECT FIXED COST"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL FIXED PAYMENT"]
[null,"Select Budget Types",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECT FIXED COST"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURNS OVER TOTAL COST ADJUSTED FOR RISK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,3,null,null,null,3,2,1]
[null," COW-CALF BUDGET (NORTH GEORGIA) - 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,3,null,null,null,3,2,1]
[null,{"$f":"+IF(bud_type=3,(Z3),IF(bud_type=2,(Z4),(Z5)))","v":"(Total Cost Budget)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURNS OVER CASH FLOW COST ADJUSTED FOR RISK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURNS OVER VARIABLE COST ADJUSTED FOR RISK"]
[]
[null,"NUMBER OF BROOD COWS",null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null," "]
[null,"PERCENT CALF CROP (DECIMAL)",null,null,null,null,null,0.85,null,null,null,null,null,null,null,null,null,null," "]
[null,"COW CULLING PERCENTAGE (DECIMAL)",null,null,null,null,null,0.15,null,null,"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF REPLACEMENT HEIFERS RAISED",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"          "]
[null,"REPLACEMENT HEIFER CULLING PERCENT",null,null,null,null,null,0.15]
[null,"SELLING WEIGHT OF CULL HEIFERS (CWT.)",null,null,null,null,null,7.5]
[null,"PRICE OF CULL HEIFERS ($/CWT.)",null,null,null,null,null,110]
[null,"NUMBER OF CALVES SOLD",null,null,null,null,null,{"$f":"H18*H19-H21","v":42.5},null,null,""]
[null,"BROOD COW DEATH LOSS (DECIMAL)",null,null,null,null,null,0.02]
[null,"SELLING WEIGHT OF CULL COWS (CWT.)",null,null,null,null,null,11,null,null,""]
[null,"PRICE OF CULL COWS ($/CWT.)",null,null,null,null,null,55]
[null,"NUMBER OF BULLS",null,null,null,null,null,2]
[null,"BULL CULLING PERCENTAGE (DECIMAL)",null,null,null,null,null,0.25]
[null,"SELLING WEIGHT OF CULL BULLS (CWT.)",null,null,null,null,null,18]
[null,"PRICE OF CULL BULLS ($/CWT.)",null,null,null,null,null,73,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"BEST","OPT.","MEDIAN"," PESS.","WORST"]
[null,"STEER WEANING/SALES  WEIGHT (CWT.)",null,null,null,6,{"$f":"+(F36+H36)/2","v":5.75},5.5,{"$f":"+(J36+H36)/2","v":5.2249999999999996},4.95]
[null,"HEIFER WEANING/SALES WEIGHT (CWT.)",null,null,null,{"$f":"+F36*0.9","v":5.4},{"$f":"+(F37+H37)/2","v":5.1750000000000007},{"$f":"+H36*0.9","v":4.95},{"$f":"+(J37+H37)/2","v":4.7025000000000006},{"$f":"+J36*0.9","v":4.4550000000000001},null,null,null,null,"Calf Crop %"]
[null,"AVERAGE WEANING/SALES WEIGHT (CWT.)",null,null,null,{"$f":"((H18*H19/2)*F36+(H18*H19/2-H21)*F37)/(H18*H19-H21)","v":5.7},{"$f":"((H18*H19/2)*G36+(H18*H19/2-H21)*G37)/(H18*H19-H21)","v":5.4625000000000004},{"$f":"((H18*H19/2)*H36+(H18*H19/2-H21)*H37)/(H18*H19-H21)","v":5.2249999999999996},{"$f":"((H18*H19/2)*I36+(H18*H19/2-H21)*I37)/(H18*H19-H21)","v":4.9637500000000001},{"$f":"((H18*H19/2)*J36+(H18*H19/2-H21)*J37)/(H18*H19-H21)","v":4.7024999999999997},null,null,null,"Avg. Weaning Wt.",0.6,0.75,0.85,0.9]
[null,"SELL PRICE OF STEERS($/CWT.)",null,null,null,130,132,134,136,138,null,null,null,5.75,{"$f":"+(cows*O$38*$N39*$G$101)-nvc","v":-2576.9838735745543},2997.489810635976,6713.8056001096593,8571.9634948465027,"           "]
[null,"SELL PRICE OF HEIFERS($/CWT)",null,null,null,{"$f":"+F39-10","v":120},{"$f":"+(F40+H40)/2","v":122},{"$f":"+H39-10","v":124},{"$f":"+(H40+J40)/2","v":126},{"$f":"+J39-10","v":128},null,null,null,5.5,-3546.457557785081,1785.6477053728158,{"$f":"+(cows*Q$38*$N40*$G$101)-nvc","v":5340.3845474780792},7117.7529685307127," "]
[null,"WEIGHTED AVE. SELLING PRICE",null,null,null,{"$f":"((H18*H19/2)*H36*F39+(H18*H19/2-H21)*H37*F40)/((H18*H19-H21)*H38)","v":125.26315789473686},{"$f":"((H18*H19/2)*H36*G39+(H18*H19/2-H21)*H37*G40)/((H18*H19-H21)*H38)","v":127.26315789473686},{"$f":"((H18*H19/2)*H36*H39+(H18*H19/2-H21)*H37*H40)/((H18*H19-H21)*H38)","v":129.26315789473685},{"$f":"((H18*H19/2)*H36*I39+(H18*H19/2-H21)*H37*I40)/((H18*H19-H21)*H38)","v":131.26315789473685},{"$f":"((H18*H19/2)*H36*J39+(H18*H19/2-H21)*H37*J40)/((H18*H19-H21)*H38)","v":133.26315789473685},null,null,null,5,-5485.4049262061344,-638.03650515350091,2593.5424422149226,4209.3319158991326," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4.5,-7424.3522946271878,-3061.7207156798177,-153.29966304823756,1300.9108632675525," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4.25,-8393.8259788377145,-4273.5628209429742,-1526.7207156798177,-153.29966304823756," "]
[null,"Item",null,"Unit","Units/Cow","Total Quantity","$/Unit","Total Amount","$/Cow","$/Cwt."]
[]
[null,"VARIABLE COSTS :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(Q43-P43)","v":2746.8421052631566},null," ",null,null,null,null,null,"       "]
["Bermuda Pasture  Detail","Bermuda Pasture",null,"Acre",0.5,{"$f":"+E47*H18","v":25},{"$f":"+bermuda","v":165.56},{"$f":"F47*G47","v":4139},{"$f":"+H47/$H$18","v":82.78},{"$f":"+H47/$E$103","v":18.666897052587043},null,null,null,"total Pasture",{"$f":"+I47+I48+I49","v":200.43037500000003}]
["Fescue Pasture  Detail","Fescue Pasture",null,"Acre",0.75,{"$f":"+E48*$H$18","v":37.5},{"$f":"+bahia","v":107.76250000000002},{"$f":"F48*G48","v":4041.0937500000005},{"$f":"+H48/$H$18","v":80.821875000000006},18.225339698261156,null,null,null,"Hay",{"$f":"+I52","v":165},{"$f":"0.133333333333333*100","v":13.3333333333333},{"$f":"+Q46/P48","v":206.01315789473725}]
["Winter Grazing Detail","Winter Annual Pasture",null,"Acre",0.2,{"$f":"+E49*$H$18","v":10},{"$f":"+winter","v":184.14250000000001},{"$f":"F49*G49","v":1841.4250000000002},36.828500000000005,8.3048298876685429,null,null,null,"Feed",{"$f":"+I53","v":136.10999999999999}]
["Summer Grazing Detail","Summer Annual Pasture",null,"Acre",0,{"$f":"+E50*$H$18","v":0},{"$f":"+summer","v":147.4},{"$f":"F50*G50","v":0},0,0,null,null,null,"Vet + mineral",{"$f":"+I58+I59","v":46.955000000000005}]
["Bermuda Hay Detail","Hay Production",null,"Acre",0,{"$f":"+E51*H18","v":0},{"$f":"+hay","v":401.43280000000004},{"$f":"F51*G51","v":0},0,0,null,null,null,"Repairs",{"$f":"+I64","v":9.2115104166666679}]
[null,"Purchased Hay",null,"Tons/Cow",1.5,{"$f":"+E52*cows","v":75},110,{"$f":"+G52*F52","v":8250},{"$f":"+H52/$H$18","v":165},37.207514057463904,null,null,null,"Labor"]
["Supplemental Feed  Detail","Total Supplemental Feed",null,"Cow Unit",null,null,null,{"$f":"+SUM(H54:H57)","v":6805.5},{"$f":"+SUM(I54:I57)","v":136.10999999999999},{"$f":"+SUM(J54:J57)","v":30.692816596129767},null,null,null,"Interest",{"$f":"+I69","v":33.582413125000002}]
[null," - Cow Herd",null,"Ton",{"$f":"+cowfeed_lbs/2000","v":0.36},{"$f":"+E54*$H$18","v":18},{"$f":"+H54/F54","v":275},{"$f":"+cowfeed_cost*cows","v":4950},{"$f":"+H54/cows","v":99},{"$f":"+H54/$E$103","v":22.324508434478343},null,null,null,"Marketing",{"$f":"+I70","v":33.648273666666675}]
[null," - Replacement Heifers",null,"Ton",{"$f":"+hfrfeed_lbs/2000","v":0},{"$f":"+E55*$H$18","v":0},{"$f":"+IF(F55<>0,(H55/F55),0)","v":0},{"$f":"+hfrfeed_cost*hfrs","v":0},{"$f":"+H55/cows","v":0},{"$f":"+H55/$E$103","v":0}]
[null," - Bulls",null,"Ton",{"$f":"+bullfeed_lbs/2000","v":0.36},{"$f":"+E56*$H$18","v":18},{"$f":"+IF(F56<>0,(H56/F56),0)","v":11},{"$f":"+bullfeed_cost*bulls","v":198},{"$f":"+H56/cows","v":3.96},{"$f":"+H56/$E$103","v":0.89298033737913363}]
[null," - Calves",null,"Ton",{"$f":"+calffeed_lbs/2000","v":0.12},{"$f":"+E57*$H$18","v":6},{"$f":"+IF(F57<>0,(H57/F57),0)","v":276.25},{"$f":"+calffeed_cost*(cows*calfcrop_pcnt)","v":1657.5},{"$f":"+H57/cows","v":33.15},{"$f":"+H57/$E$103","v":7.4753278242722931}]
[null,"Salt & Minerals",null,"Lbs./Cow",{"$f":"0.25*365","v":91.25},{"$f":"+E58*cows","v":4562.5},0.28000000000000003,{"$f":"F58*G58","v":1277.5000000000002},25.550000000000004,{"$f":"+H58/$E$103","v":5.7615271767769869}]
["Veterinary Detail","Total Vet & Medicine",null,"Cow Unit",null,null,null,{"$f":"SUM(H60:H63)","v":1070.25},21.405000000000001,4.8268293236364537]
[null," - Cow Herd",null,"Cow",1,{"$f":"+H18","v":50},{"$f":"+cow_vet","v":14},{"$f":"F60*G60","v":700},14,3.157001192754513]
[null," - Replacement Heifers",null,"Heifer",{"$f":"+H21/H18","v":0},{"$f":"+hfrs","v":0},{"$f":"+hfr_vet","v":16},0,0,0]
[null," - Bulls",null,"Bull",{"$f":"+H29/H18","v":0.04},{"$f":"+bulls","v":2},{"$f":"+bull_vet","v":47},94,1.88,0.42394016016989172]
[null," - Calves",null,"calf",{"$f":"+H19","v":0.85},{"$f":"+(cows*calfcrop_pcnt)","v":42.5},{"$f":"+calf_vet","v":6.5},276.25,5.5250000000000004,1.2458879707120489]
[null,"Fence & Facilties Repairs & Maintenance",null,"% of Facilities",null,{"$f":"+(facil_inv+Lvstk_Facil!lvstk_inv)","v":92115.104166666672},5.0000000000000001E-3,460.57552083333337,9.2115104166666679,{"$f":"+H64/$E$103","v":2.0771963837490923}]
[null,"Labor (including insurance, taxes, and SS)",null,"Hrs./Cow",7,{"$f":"+E65*H18","v":350},0,0,0,0]
[null,"Pasture Rent",null,"Acres",0,{"$f":"+E66*cows","v":0},20,{"$f":"F66*G66","v":0},0,0]
[null,"Machinery Rent",null,"Year",0,{"$f":"+E67*H20","v":0},0,{"$f":"F67*G67","v":0},0,0]
[null,"Other",null,"Cow",1,{"$f":"+E68*H18","v":50},2,100,2,0.45100017039350188]
[null,"Interest on Operating Capital (8 months)",null,"Percent",null,{"$f":"SUM(H47:H68)-H53-H59","v":27985.344270833339},0.09,{"$f":"(F69*G69)/12*8","v":1679.1206562500001},33.582413125000002,7.5728370207999873]
["Marketing Detail","Auction & Hauling",null,"Head",null,{"$f":"H25+(H20*H18)","v":50},{"$f":"+mktng_cst","v":33.648273666666675},{"$f":"F70*G70","v":1682.4136833333337},33.648273666666675,7.5876885785569259]
[null,"TOTAL VARIABLE COST",null,null,null,null,null,{"$f":"+SUM(H64:H70)+H59+H53+SUM(H47:H52)","v":30069.378610416665},601.38757220833327,135.61294876924634]
[]
[null,"FIXED COST SECTION"]
["Livestock  Detail",{"$f":"IF(bud_type=2,\" Annual Livestock Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Livestock Fixed Costs\"))","v":"Annual Livestock Fixed Costs"},null,null,null,null,null,{"$f":"IF(bud_type=3,Lvstk_Facil!lvstk_fc,IF(bud_type=2,(Lvstk_Facil!lvstk_pmt),0))","v":3490.92},{"$f":"+H74/cows","v":69.818399999999997},{"$f":"+H74/exp_wt","v":15.744055148300836}]
["Building & Facilities Detail",{"$f":"IF(bud_type=2,\" Annual Buildings & Facilities Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Buildings & Facilities Fixed Costs\"))","v":"Annual Buildings & Facilities Fixed Costs"},null,null,null,null,null,{"$f":"IF(bud_type=3,Lvstk_Facil!facil_fc,IF(bud_type=2,(Lvstk_Facil!facil_pmt),0))","v":3261.8981150793652},65.237962301587302,14.711166057070363]
["Equipment Detail",{"$f":"IF(bud_type=2,\" Annual Equipment Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Equipment Fixed Costs\"))","v":"Annual Equipment Fixed Costs"},null,null,null,null,null,{"$f":"IF(bud_type=3,equip_fc+cow_fc,IF(bud_type=2,(equip_pmt),0))","v":4214.3600000000006},84.287200000000013,19.006770780995588]
["Land Detail",{"$f":"IF(bud_type=2,\" Annual Land Debt Payment\",IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Land Fixed Costs Excluding Taxes\"))","v":"Annual Land Fixed Costs Excluding Taxes"},null,{"$f":"+IF(bud_type<>1,\"Percent of Land Value\",\"\")","v":"Percent of Land Value"},null,{"$f":"+IF(bud_type<>1,Lvstk_Facil!land_inv,\"\")","v":63000},0,{"$f":"+IF(bud_type=3,G77*F77,IF(bud_type=2,(Lvstk_Facil!LAND_PMT),0))","v":0},0,0]
[null,{"$f":"IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Real Estate Taxes\")","v":"Annual Real Estate Taxes"},null,{"$f":"+IF(bud_type<>1,\"Percent of Land Value\",\"\")","v":"Percent of Land Value"},null,{"$f":"+IF(bud_type<>1,Lvstk_Facil!land_inv,\"\")","v":63000},0.01,{"$f":"+IF(F78<>\"\",G78*F78,0)","v":630},12.6,2.8413010734790616]
[null,{"$f":"IF(bud_type=1,\"No Fixed Cost for Variable Cost Budget\",\"Annual Farm Insurance\")","v":"Annual Farm Insurance"},null,{"$f":"+IF(bud_type<>1,\"Pcnt. of Lvstk., Facl, & Eqp.\",\"\")","v":"Pcnt. of Lvstk., Facl, & Eqp."},null,{"$f":"+IF(bud_type<>1,Lvstk_Facil!lvstk_inv+facil_inv+Equipment!B21,\"\")","v":198865.10416666669},{"$f":"+IF(bud_type<>1,0.25%,0)","v":2.5000000000000001E-3},{"$f":"+IF(F79<>\"\",G79*F79,0)","v":497.16276041666674},9.9432552083333352,2.2422048966122046]
[null,{"$f":"IF(bud_type=2,\"TOTAL FIXED PAYMENTS\",IF(bud_type=1,\"TOTAL VARIABLE COST\",\"TOTAL FIXED COST\"))","v":"TOTAL FIXED COST"},null,null,null,null,null,{"$f":"SUM(H74:H79)","v":12094.340875496031},{"$f":"+H80/$H$18","v":241.88681750992063},54.545497956458043]
[]
[null,"                       EXPECTED BREAK-EVEN TABLE"]
[]
[null,"ITEM",null,"TOTAL",null,"$/Cwt.",null,"$/Cow"]
[null,"Variable Cost",null,{"$f":"H71","v":30069.378610416665},null,{"$f":"+D85/($H$25*$H$38)","v":135.40952934609251},null,{"$f":"+D85/$H$18","v":601.38757220833327}]
[null,"Less: Value of cull cows, bulls and heifers",null,{"$f":"+(H18*H20*H27*H28)+(H30*H29*H31*H32)+(H21*H22*H23*H24)","v":5194.5},null,{"$f":"-D86/($H$25*$H$38)","v":-23.392063045313822},null,{"$f":"+D86/$H$18","v":103.89}]
[null,"NET VARIABLE COST",null,{"$f":"D85-D86","v":24874.878610416665},null,{"$f":"+D87/($H$25*$H$38)","v":112.01746630077869},null,{"$f":"+D87/H18","v":497.49757220833328}]
[null,{"$f":"+IF(bud_type<>1,B74,\"\")","v":"Annual Livestock Fixed Costs"},null,{"$f":"+H74","v":3490.92},null,15.720439065578386,null,{"$f":"+D88/H18","v":69.818399999999997}]
[null,{"$f":"+IF(bud_type<>1,B75,\"\")","v":"Annual Buildings & Facilities Fixed Costs"},null,{"$f":"+H75","v":3261.8981150793652},null,14.68909930798476,null,{"$f":"+D89/H18","v":65.237962301587302},null," "]
[null,{"$f":"+IF(bud_type<>1,B76,\"\")","v":"Annual Equipment Fixed Costs"},null,{"$f":"+H76","v":4214.3600000000006},null,18.978260624824099,null,{"$f":"+D90/H18","v":84.287200000000013}]
[null,{"$f":"+IF(bud_type<>1,B77,\"\")","v":"Annual Land Fixed Costs Excluding Taxes"},null,{"$f":"+H77","v":0},null,0,null,{"$f":"+D91/H18","v":0}]
[null,{"$f":"+IF(bud_type<>1,B78,\"\")","v":"Annual Real Estate Taxes"},null,{"$f":"+H79","v":497.16276041666674},null,2.2388415892672864,null,{"$f":"+D92/cows","v":9.9432552083333352}]
[null," TOTAL COSTS",null,{"$f":"SUM(D87:D91)","v":35842.056725496033},null,{"$f":"D93/((H18*H19-H21)*H38)","v":161.40526529916593},null,{"$f":"+D93/H18","v":716.84113450992072}]
[]
[]
[null,"     EXPECTED RETURNS FROM CALF SALES TABLE"]
[null,null,null,null,{"$f":"H25","v":42.5}," CALVES SOLD"]
[]
[null,null,"EXP. WEIGHT",null,"TOTAL WEIGHT",null,"  EXP.PRICE",null,"TOTAL RETURN"]
[null,null,"(cwt./cow)",null,"  (cwt.)",null,"   ($/cwt.)"]
[null,null,{"$f":"(0.04*F38+0.25*G38+0.42*H38+0.25*I38+0.04*J38)*H25/H18","v":4.4345881250000003},null,{"$f":"(0.04*F38+0.25*G38+0.42*H38+0.25*I38+0.04*J38)*H25","v":221.72940625000001},null,{"$f":"(0.04*F41+0.25*G41+0.42*H41+0.25*I41+0.04*J41)","v":129.26315789473688},null,{"$f":"+G101*E101","v":28661.443250000011}]
[null,null,"(cwt./calf)",null,"  (cwt.)",null,"   ($/cwt.)"]
[null,null,{"$f":"(0.04*F38+0.25*G38+0.42*H38+0.25*I38+0.04*J38)","v":5.2171625000000006},null,{"$f":"+C103*calves_sold","v":221.72940625000001},null,{"$f":"(0.04*F41+0.25*G41+0.42*H41+0.25*I41+0.04*J41)","v":129.26315789473688},null,{"$f":"+G103*E103","v":28661.443250000011}]
[]
[]
[]
[null,"RETURNS OVER TOTAL COST ADJUSTED FOR RISK"]
[null,"Net return levels (TOP ROW);"]
[null,"The chances of obtaining this level or more (MIDDLE ROW); and"]
[null,"The chances of obtaining this level or less (BOTTOM ROW)."]
[]
[]
[null,null,null,null,"Optimistic",null,"Expected",null,"  Pessimistic"]
[null,"Returns",null,{"$f":"Q165:Q165+1.5*S164:S164","v":-5949.7347156040842},{"$f":"Q165:Q165+S164:S164","v":-6576.7940830849993},{"$f":"Q165:Q165+0.5*S164:S164","v":-7203.8534505659136},{"$f":"Q165:Q165","v":-7830.9128180468288},{"$f":"Q165:Q165-0.5*S165:S165","v":-8474.6843754856454},{"$f":"Q165:Q165-S165:S165","v":-9118.4559329244639},{"$f":"Q165:Q165-1.5*S165:S165","v":-9762.2274903632806},null,null,null,null,null,"*","*",null,null,null,"*",null,"          "," ",null,null,null,null,"       "]
[null,"Chances",null,{"$f":"IF(R167<1,IF(Q167,V167,1-V167),IF(Q167,V168,1-V168))","v":6.5526316374011281E-2},{"$f":"IF(X167<1,IF(W167,AB167,1-AB167),IF(W167,AB168,1-AB168))","v":0.15866559829648058},{"$f":"IF(AD167<1,IF(AC167,AH167,1-AH167),IF(AC167,AH168,1-AH168))","v":0.31202868239499915},{"$f":"IF(R169<1,IF(Q169,V169,1-V169),IF(Q169,V170,1-V170))","v":0.5034625545823147},{"$f":"IF(X169<1,IF(W169,AB169,1-AB169),IF(W169,AB170,1-AB170))","v":0.6948780952148349},{"$f":"IF(AD169<1,IF(AC169,AH169,1-AH169),IF(AC169,AH170,1-AH170))","v":0.84135470539433754},{"$f":"IF(R171<1,IF(Q171,V171,1-V171),IF(Q171,V172,1-V172))","v":0.93194297505951895},null,null,null,null,null,"*","    Must match budget Entries",null,null,null,"*"]
[null,"Chances",null,{"$f":"IF(R167<1,IF(Q167,1-V167,V167),IF(Q167,1-V168,V168))","v":0.9344736836259887},{"$f":"IF(X167<1,IF(W167,1-AB167,AB167),IF(W167,1-AB168,AB168))","v":0.84133440170351936},{"$f":"IF(AD167<1,IF(AC167,1-AH167,AH167),IF(AC167,1-AH168,AH168))","v":0.68797131760500085},{"$f":"IF(R169<1,IF(Q169,1-V169,V169),IF(Q169,1-V170,V170))","v":0.4965374454176853},{"$f":"IF(X169<1,IF(W169,1-AB169,AB169),IF(W169,1-AB170,AB170))","v":0.3051219047851651},{"$f":"IF(AD169<1,IF(AC169,1-AH169,AH169),IF(AC169,1-AH170,AH170))","v":0.15864529460566251},{"$f":"IF(R171<1,IF(Q171,1-V171,V171),IF(Q171,1-V172,V172))","v":6.8057024940481006E-2},null,null,null,null,null,"*","-",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",1,"UNIT",null,null,"*"]
[null,"  CHANCE FOR PROFIT ",null,null,{"$f":"IF(X171<1,IF(W171,AB171,1-AB171),IF(W171,AB172,1-AB172))","v":6.2096929158193597E-3},"  BASE BUDGETED NET REVENUE - TOTAL",null,null,null,{"$f":"+Q165","v":-7830.9128180468288},null,null,null,null,null,"*",{"$f":"+H25*F38+(H18*H20*H27)","v":324.75},"  Best Y",{"$f":"(((H18*H19/2)*H36*F39+(H18*H19/2-H21)*H37*F40)+((H28+(F41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":105.68848758465012},"  Best P","*","EXP.CULL WEIGHT",null,{"$f":"H18*H20*H27","v":82.5}]
[null,null,null,null,null,"  BASE BUDGETED NET REVENUE - $/HEAD MARKETED",null,null,null,{"$f":"+J118/calves_sold","v":-184.25677218933714},null,null,null,null,null,"*",{"$f":"+H25*G38+(H18*H20*H27)","v":314.65625},"  Opt. Y",{"$f":"(((H18*H19/2)*H36*G39+(H18*H19/2-H21)*H37*G40)+((H28+(G41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":107.4176072234763},"  Opt. P","*","EXP.CULL PRICE",null,{"$f":"0.04*(H28+0.5*(F41-H41))+0.25*(H28+0.5*(G41-H41))+0.42*H28+0.25*(H28-0.5*(H41-I41))+0.04*(H28-0.5*(H41-J41))","v":55}]
[null,null,null,null,null,"  BASE BUDGETED NET REVENUE - $/COW",null,null,null,{"$f":"+J118/cows","v":-156.61825636093658},null,null,null,null,null,"*",{"$f":"+H25*H38+(H18*H20*H27)","v":304.5625},"  Med. Y",{"$f":"(((H18*H19/2)*H36*H39+(H18*H19/2-H21)*H37*H40)+(H28*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":109.14672686230249},"  Med. P","*",{"$f":"+Q119*S119-D85-D88-D89-D90","v":-7236.9352525840704}]
[null,"PROFIT IS RETURN TO RISK AND ALL \"ZERO\" ITEMS IN THE BUDGET.",null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H25*I38+(H18*H20*H27)","v":293.45937500000002},"  Pess. Y",{"$f":"(((H18*H19/2)*H36*I39+(H18*H19/2-H21)*H37*I40)+((H28+(I41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":110.87584650112866},"  Pess. P","*",{"$f":"Q119*S119","v":33799.62147291196}]
[null,"MAY ENTER YOUR OWN VALUES.",null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H25*J38+(H18*H20*H27)","v":282.35624999999999},"  Worst Y",{"$f":"(((H18*H19/2)*H36*J39+(H18*H19/2-H21)*H37*J40)+((H28+(J41-H41)*0.5)*H18*H20*H27))/(((H18*H19-H21)*H38)+(H18*H20*H27))","v":112.60496613995485},"  Worst P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",0,"  H&MC",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"D85","v":30069.378610416665},"  T.C.",null,null,"*"]
[null,null,null,"Total Dollars","$/Cow","$/Calf Marketed",null,null,null,null,null,null,null,null,null,"*","*",null,null,null,"*"]
[null,"Returns to Land, Labor, Capital and Management",null,{"$f":"+Q164-(H71-H66-H65-H70)","v":4818.6789803658685},{"$f":"+D126/cows","v":96.373579607317367},{"$f":"+D126/calves_sold","v":113.38068189096161},null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,"Returns to Labor, Capital and Management",null,{"$f":"+D126-H77-H66-H70","v":3136.2652970325348},{"$f":"+D127/cows","v":62.725305940650699},{"$f":"+D127/calves_sold","v":73.794477577236108},null,null,null,null,null,null,null,null,null,":",null,"Calculations",null,null,":"]
[null,"Returns to Land, Capital and Management",null,{"$f":"+D126-H65-H70","v":3136.2652970325348},{"$f":"+D128/cows","v":62.725305940650699},{"$f":"+D128/calves_sold","v":73.794477577236108},null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.04*Q118+0.25*Q119+0.42*Q120+0.25*Q121+0.04*Q122","v":304.22940624999995},"  Exp. Y",{"$f":"0.04*S118+0.25*S119+0.42*S120+0.25*S121+0.04*S122","v":109.14672686230247},"  Exp. P",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,":",{"$f":"0.25*(Q118-Q129)+0.5*(Q119-Q129)","v":10.343570312500034},"  SYO",{"$f":"0.25*(S118-S129)+0.5*(S119-S129)","v":-1.7291196388261767},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(Q129-Q122)+0.5*(Q129-Q121)","v":10.853304687499957},"  SYP",{"$f":"0.25*(S129-S122)+0.5*(S129-S121)","v":-1.7291196388261909},"  SPP",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,":",{"$f":"Q130^2","v":106.98944680963206},"  VYO",{"$f":"S130^2","v":2.9898547253743679},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"Q131^2","v":117.79422263970854},"  VYP",{"$f":"S131^2","v":2.9898547253744168},"  VPP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"(Q129^2*S132)+(S129-Q123)^2*Q132","v":1551293.7277227696},"  VTRHH",{"$f":"(Q129^2*S133)+(S129-Q123)^2*Q133","v":1680011.1084599528},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(Q129^2*S132)+(S129-Q123)^2*Q133","v":1680011.1084599483},"  VTRHL",{"$f":"Q129^2*S133+(S129-Q123)^2*Q132","v":1551293.727722774},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(Q135)","v":1245.5094249835163},"  STRHH",{"$f":"SQRT(S135)","v":1296.1524248559476},"  STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(Q136)","v":1296.1524248559458},"  STRHL",{"$f":"SQRT(S136)","v":1245.5094249835181},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*Q137+0.17*Q138+0.17*S138","v":1254.1187349618297},"  STRO",{"$f":"0.66*S137+0.17*Q138+0.17*S138","v":1287.5431148776345},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","Calculation of NR and for Z values",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"S120","v":109.14672686230249},"  MP",{"$f":"+Q165-Q163","v":-11.030045372215682},"ENR_MNR",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",":",{"$f":"Q120","v":304.5625},"  MY",{"$f":"+Q137","v":1245.5094249835163},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+Q164+0.33*(S165-S164)","v":33216.673952821417},"  MTR",{"$f":"+S137","v":1296.1524248559476},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+D85","v":30069.378610416665},"  MTC",{"$f":"+Q138","v":1296.1524248559458},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"Q161-Q162-(SUM(D88:D91))","v":-7819.8827726746131},"  MNR",{"$f":"+S138","v":1245.5094249835181},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",":",{"$f":"Q129*S129","v":33205.643907449201},"  ETR",{"$f":"Q139","v":1254.1187349618297},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"Q164-Q162-(SUM(D88:D91))","v":-7830.9128180468288},"  ENR",{"$f":"S139","v":1287.5431148776345},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"+D114>=Q163","v":true},{"$f":"ABS((D114-Q165)/IF(Q167,S164,S165))","v":1.5},{"$f":"MIN(2.5,ABS((D114-(Q163+S159*ABS(D114-Q163)/ABS(IF(Q167,S164+S159,S165-S159))*MIN(1,R167)))/(MIN(1.52,R167)/1.52*IF(Q167,S160,S161)+(1.52-MIN(1.52,R167))/3.04*S162+(1.52-MIN(1.52,R167))/3.04*S163)))","v":1.514430519951631},{"$f":"1/(1+(0.2316419*S167))","v":0.74029899442743874},{"$f":"0.398942281*((2.71828)^((-(S167^2)/2)))","v":0.12673111265218853},{"$f":"U167*(0.31938153*T167-0.356563782*T167^2+1.781477937*T167^3-1.821255978*T167^4+1.330274429*T167^5)","v":6.4958415257606719E-2},{"$f":"+E114>=Q163","v":true},{"$f":"ABS((E114-Q165)/IF(W167,S164,S165))","v":0.99999999999999978},{"$f":"MIN(2.5,ABS((E114-(Q163+S159*ABS(E114-Q163)/ABS(IF(W167,S164+S159,S165-S159))*MIN(1,X167)))/(MIN(1.52,X167)/1.52*IF(W167,S160,S161)+(1.52-MIN(1.52,X167))/3.04*S162+(1.52-MIN(1.52,X167))/3.04*S163)))","v":0.99995749512899768},{"$f":"1/(1+(0.2316419*Y167))","v":0.8119308008251771},{"$f":"0.398942281*((2.71828)^((-(Y167^2)/2)))","v":0.24198109119432137},{"$f":"AA167*(0.31938153*Z167-0.356563782*Z167^2+1.781477937*Z167^3-1.821255978*Z167^4+1.330274429*Z167^5)","v":0.15866559829648058},{"$f":"+F114>=Q163","v":true},{"$f":"ABS((F114-Q165)/IF(AC167,S164,S165))","v":0.50000000000000022},{"$f":"MIN(2.5,ABS((F114-(Q163+S159*ABS(F114-Q163)/ABS(IF(AC167,S164+S159,S165-S159))*MIN(1,AD167)))/(MIN(1.52,AD167)/1.52*IF(AC167,S160,S161)+(1.52-MIN(1.52,AD167))/3.04*S162+(1.52-MIN(1.52,AD167))/3.04*S163)))","v":0.49010822843084662},{"$f":"1/(1+(0.2316419*AE167))","v":0.89804527772499509},{"$f":"0.398942281*((2.71828)^((-(AE167^2)/2)))","v":0.35379363468295438},{"$f":"AG167*(0.31938153*AF167-0.356563782*AF167^2+1.781477937*AF167^3-1.821255978*AF167^4+1.330274429*AF167^5)","v":0.31202868239499915}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((D114-Q165)/(MIN(1.52,R167)/1.52*IF(Q167,S160,S161)+(1.52-MIN(1.52,R167))/3.04*S162+(1.52-MIN(1.52,R167))/3.04*S163)))","v":1.5099644999258421},0.7408663885546769,0.12758988780349229,6.5526316374011281E-2,null,null,{"$f":"MIN(2.5,ABS((E114-Q165)/(MIN(1.52,X167)/1.52*IF(W167,S160,S161)+(1.52-MIN(1.52,X167))/3.04*S162+(1.52-MIN(1.52,X167))/3.04*S163)))","v":0.99995749512899768},0.8119308008251771,0.24198109119432137,0.15866559829648058,null,null,{"$f":"MIN(2.5,ABS((F114-Q165)/(MIN(1.52,AD167)/1.52*IF(AC167,S160,S161)+(1.52-MIN(1.52,AD167))/3.04*S162+(1.52-MIN(1.52,AD167))/3.04*S163)))","v":0.49668010323368245},{"$f":"1/(1+(0.2316419*AE168))","v":0.89681922388349511},{"$f":"0.398942281*((2.71828)^((-(AE168^2)/2)))","v":0.3526483087363666},{"$f":"AG168*(0.31938153*AF168-0.356563782*AF168^2+1.781477937*AF168^3-1.821255978*AF168^4+1.330274429*AF168^5)","v":0.30970734918448778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G114>=Q163","v":false},{"$f":"ABS((G114-Q165)/IF(Q169,S164,S165))","v":0},{"$f":"MIN(2.5,ABS((G114-(Q163+S159*ABS(G114-Q163)/ABS(IF(Q169,S164+S159,S165-S159))*MIN(1,R169)))/(MIN(1.52,R169)/1.52*IF(Q169,S160,S161)+(1.52-MIN(1.52,R169))/3.04*S162+(1.52-MIN(1.52,R169))/3.04*S163)))","v":8.6793964137380115E-3},0.99799352217137205,0.39892725474867957,0.4965374454176853,{"$f":"+H114>=Q163","v":false},{"$f":"ABS((H114-Q165)/IF(W169,S164,S165))","v":0.49999999999999956},{"$f":"MIN(2.5,ABS((H114-(Q163+S159*ABS(H114-Q163)/ABS(IF(W169,S164+S159,S165-S159))*MIN(1,X169)))/(MIN(1.52,X169)/1.52*IF(W169,S160,S161)+(1.52-MIN(1.52,X169))/3.04*S162+(1.52-MIN(1.52,X169))/3.04*S163)))","v":0.50972550958476248},0.89439535471810805,0.35034093736324096,0.3051219047851651,{"$f":"+I114>=Q163","v":false},{"$f":"ABS((I114-Q165)/IF(AC169,S164,S165))","v":1.0000000000000004},{"$f":"MIN(2.5,ABS((I114-(Q163+S159*ABS(I114-Q163)/ABS(IF(AC169,S164+S159,S165-S159))*MIN(1,AD169)))/(MIN(1.52,AD169)/1.52*IF(AC169,S160,S161)+(1.52-MIN(1.52,AD169))/3.04*S162+(1.52-MIN(1.52,AD169))/3.04*S163)))","v":1.000041404926588},{"$f":"1/(1+(0.2316419*AE169))","v":0.8119179875258461},{"$f":"0.398942281*((2.71828)^((-(AE169^2)/2)))","v":0.24196078748661429},{"$f":"AG169*(0.31938153*AF169-0.356563782*AF169^2+1.781477937*AF169^3-1.821255978*AF169^4+1.330274429*AF169^5)","v":0.15864529460566251}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"MIN(2.5,ABS((G114-Q165)/(MIN(1.52,R169)/1.52*IF(Q169,S160,S161)+(1.52-MIN(1.52,R169))/3.04*S162+(1.52-MIN(1.52,R169))/3.04*S163)))","v":0},1,0.39894228100000001,0.50000000022538427,null,null,{"$f":"MIN(2.5,ABS((H114-Q165)/(MIN(1.52,X169)/1.52*IF(W169,S160,S161)+(1.52-MIN(1.52,X169))/3.04*S162+(1.52-MIN(1.52,X169))/3.04*S163)))","v":0.5032766607746243},0.89559192722190362,0.35148714326994135,0.30738490498301951,null,null,{"$f":"MIN(2.5,ABS((I114-Q165)/(MIN(1.52,AD169)/1.52*IF(AC169,S160,S161)+(1.52-MIN(1.52,AD169))/3.04*S162+(1.52-MIN(1.52,AD169))/3.04*S163)))","v":1.000041404926588},{"$f":"1/(1+(0.2316419*AE170))","v":0.8119179875258461},{"$f":"0.398942281*((2.71828)^((-(AE170^2)/2)))","v":0.24196078748661429},{"$f":"AG170*(0.31938153*AF170-0.356563782*AF170^2+1.781477937*AF170^3-1.821255978*AF170^4+1.330274429*AF170^5)","v":0.15864529460566251}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J114>=Q163","v":false},{"$f":"ABS((J114-Q165)/IF(Q171,S164,S165))","v":1.5},{"$f":"MIN(2.5,ABS((J114-(Q163+S159*ABS(J114-Q163)/ABS(IF(Q171,S164+S159,S165-S159))*MIN(1,R171)))/(MIN(1.52,R171)/1.52*IF(Q171,S160,S161)+(1.52-MIN(1.52,R171))/3.04*S162+(1.52-MIN(1.52,R171))/3.04*S163)))","v":1.4861999450988821},0.74390028967129973,0.13221407004493782,6.8613203402501391E-2,{"$f":"0>=Q163","v":true},{"$f":"ABS((0-Q165)/IF(W171,S164,S165))","v":6.2441558360781286},{"$f":"MIN(2.5,ABS((0-(Q163+S159*ABS(0-Q163)/ABS(IF(W171,S164+S159,S165-S159))*MIN(1,X171)))/(MIN(1.52,X171)/1.52*IF(W171,S160,S161)+(1.52-MIN(1.52,X171))/3.04*S162+(1.52-MIN(1.52,X171))/3.04*S163)))","v":2.5},0.63327021212493984,1.7528337365090806E-2,6.2096929158193597E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((J114-Q165)/(MIN(1.52,R171)/1.52*IF(Q171,S160,S161)+(1.52-MIN(1.52,R171))/3.04*S162+(1.52-MIN(1.52,R171))/3.04*S163)))","v":1.4904198069692645},0.74335974807157124,0.13138630723345102,6.8057024940481006E-2,null,null,{"$f":"MIN(2.5,ABS((0-Q165)/(MIN(1.52,X171)/1.52*IF(W171,S160,S161)+(1.52-MIN(1.52,X171))/3.04*S162+(1.52-MIN(1.52,X171))/3.04*S163)))","v":2.5},0.63327021212493984,1.7528337365090806E-2,6.2096929158193597E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Bermuda","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,7],[9,0,9,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[4,0,4,3],[13,0,13,3],[14,0,14,3],[10,0,10,3],[12,0,12,3],[11,0,11,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Hybrid Bermuda Pasture Per Acre Cost Detail "]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Prorated Establishment Cost",null,null,null,"YRS.",10,0,{"$f":"+G6/F6","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",150,0.6,{"$f":"+G8*F8","v":90}]
[" Phosphorous (P205)",null,null,null,"LBS.",50,0.5,25]
[" Potassium (K20)",null,null,null,"LBS.",75,0.42,31.5]
["Lime",null,null,null,"TONS",0.25,40,10]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,1.74,1.74]
["Machinery Fuel",null,null,null,"Gallons",1.45,3,4.3499999999999996]
["Labor",null,null,null,"Hours",0.33,9,2.97]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H15)","v":165.56}]

{"sheet":"Fescue","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,3],[14,0,14,3],[4,0,4,3],[0,8,0,9],[9,0,9,3],[10,0,10,3],[12,0,12,3],[11,0,11,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[2,0,2,7]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Fescue Pasture Per Acre Cost Detail"]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Prorated Establishment Cost",null,null,null,"YRS.",10,0,{"$f":"+G6/F6","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",130,0.44,{"$f":"+G8*F8","v":57.2},"530 ton"]
[" Phosphorous (P2O5)",null,null,null,"LBS.",40,0.38,15.2]
[" Potash (K2O)",null,null,null,"LBS.",60,0.28999999999999998,17.399999999999999]
["Lime",null,null,null,"TONS",0.25,40,10]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,1.73,1.73]
["Machinery Fuel",null,null,null,"Gallons",1.45,2.25,3.2624999999999997]
["Labor",null,null,null,"Hours",0.33,9,2.97]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H15)","v":107.76250000000002}]

{"sheet":"Winter_Grazing","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,3],[4,0,4,3],[0,8,0,9],[12,0,12,3],[13,0,13,3],[15,0,15,3],[14,0,14,3],[6,0,6,3],[9,0,9,3],[7,0,7,3],[10,0,10,3],[11,0,11,3],[2,0,2,7],[16,0,16,3],[8,0,8,3],[5,0,5,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Winter Grazing Per Acre Cost Detail"]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Wheat",null,null,null,"Bushel",0,10.5,{"$f":"+G6*F6","v":0}]
["Rye",null,null,null,"Bushel",0,13.5,{"$f":"+G7*F7","v":0}]
["Ryegrass",null,null,null,"Lbs.",30,0.5,{"$f":"+G8*F8","v":15}]
["Clover",null,null,null,"Lbs.",0,1.35,{"$f":"+G9*F9","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",150,0.6,90]
[" Phosphorous (P2O5)",null,null,null,"LBS.",60,0.5,30]
[" Potash (K2O)",null,null,null,"LBS.",90,0.42,37.799999999999997]
["Lime",null,null,null,"TONS",0,40,0]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,2.68,2.68]
["Machinery Fuel",null,null,null,"Gallons",1.45,2.25,3.2624999999999997]
["Labor",null,null,null,"Hours",0.6,9,5.3999999999999995]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H7:H18)","v":184.14250000000001}]

{"sheet":"Summer_Annual","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,3],[4,0,4,3],[0,8,0,9],[12,0,12,3],[13,0,13,3],[15,0,15,3],[14,0,14,3],[6,0,6,3],[9,0,9,3],[7,0,7,3],[10,0,10,3],[11,0,11,3],[2,0,2,7],[16,0,16,3],[8,0,8,3],[5,0,5,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
[]
["Summer Annual Per Acre Cost Detail"]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Wheat",null,null,null,"Bushel",1,10.5,{"$f":"+G6*F6","v":10.5}]
["Rye",null,null,null,"Bushel",1,13.5,{"$f":"+G7*F7","v":13.5}]
["Ryegrass",null,null,null,"Lbs.",15,0.35,{"$f":"+G8*F8","v":5.25}]
["Clover",null,null,null,"Lbs.",0,1.35,{"$f":"+G9*F9","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",150,0.44,{"$f":"+G11*F11","v":66}]
[" Phosphorous (P2O5)",null,null,null,"LBS.",60,0.38,22.8]
[" Potash (K2O)",null,null,null,"LBS.",90,0.28999999999999998,26.099999999999998]
["Lime",null,null,null,"TONS",0,40,0]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",2,3.5,7]
["Machinery Fuel",null,null,null,"Gallons",3,2.25,6.75]
["Other",null,null,null,"Acre",0,2,0]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H7:H18)","v":147.4}]

{"sheet":"Hay","index":6,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,0,19,6],[20,0,20,6],[22,0,22,6],[17,0,17,3],[13,0,13,3],[0,8,0,9],[2,0,2,7],[9,0,9,3],[16,0,16,3],[10,0,10,3],[1,0,1,1],[4,0,4,3],[5,0,5,3],[14,0,14,3],[15,0,15,3],[12,0,12,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[11,0,11,3]]}
[null,null,null,null,null,null,null,null,"Return To Main"]
["Tons per Acre",null,6]
["Hybrid Bermuda Hay Per Acre Cost Detail "]
[]
["Item",null,null,null,"Unit","Quantity","Price","Total"]
["Prorated Establishment Cost",null,null,null,"YRS.",10,0,{"$f":"+G6/F6","v":0}]
["Fertilizer"]
[" Nitrogen",null,null,null,"LBS.",300,0.44,{"$f":"+G8*F8","v":132}]
[" Phosphorous (P2O5)",null,null,null,"LBS.",180,0.38,68.400000000000006]
[" Potash (K2O)",null,null,null,"LBS.",180,0.28999999999999998,52.199999999999996]
["Lime",null,null,null,"TONS",0.5,40,20]
["Herbicide",null,null,null,"Acre",1,6.24,{"$f":"+G12*F12","v":6.24}]
["Machinery Repairs & Maintenance",null,null,null,"ACRE",1,{"$f":"15.06+11.42","v":26.48},26.48]
["Machinery Fuel",null,null,null,"Gallons",25.6448,2.25,57.700800000000001]
["Labor",null,null,null,"Hours",4.2679999999999998,9,38.411999999999999]
["Other",null,null,null,"Acre",0,2,0]
["TOTAL COST PER ACRE",null,null,null,null,null,null,{"$f":"+SUM(H6:H16)","v":401.43280000000004}]
["TOTAL VARIABLE COST PER TON",null,null,null,null,null,null,{"$f":"+hay/hay_tons","v":66.905466666666669}]
[]
["TOTAL FIXED COSTS",null,null,null,null,null,null,{"$f":"+equip_fc","v":1984}]
["TOTAL FIXED COSTS PER TON",null,null,null,null,null,null,{"$f":"IF(Main!F51>0,H20/(hay_tons*Main!F51),\"N/A\")","v":"N/A"}]
[]
["TOTAL HAY COSTS PER TON",null,null,null,null,null,null,{"$f":"+IF(H21<>\"N/A\",H21+H18,\"N/A\")","v":"N/A"}]

{"sheet":"Feed","index":7,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[38,0,38,6],[0,7,0,8],[1,0,1,6],[14,0,14,6],[26,0,26,6]]}
[null,null,null,null,null,null,null,"Return To Main"]
["Supplemental Feed for Cows"]
[null,"Unit","Days fed","Pounds Fed per Day","Total Pounds Fed","$/unit","Cost/Cow"]
["50:50 Corn Gluten:Soy Hull Pellets","Tons",120,6,{"$f":"+D4*C4","v":720},275,{"$f":"+(E4/2000)*F4","v":99}]
[null,null,0,22,0,90,{"$f":"+(E5/2000)*F5","v":0}]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
["Total Feed for Cows","Tons",null,null,{"$f":"SUM(E4:E10)","v":720},{"$f":"+G11/E11","v":0.13750000000000001},{"$f":"SUM(G4:G10)","v":99}]
[]
[]
[]
["Supplemental Feed for Replacement Heifers"]
[null,"Unit","Days fed","Pounds Fed per Day","Total Pounds Fed","$/unit","Cost/Cow"]
["Corn gluten","Tons",0,6,{"$f":"+D17*C17","v":0},275,{"$f":"+(E17/2000)*F17","v":0}]
[null,null,0,22,0,90,{"$f":"+(E18/2000)*F18","v":0}]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
["Total Feed for Replacements","Tons",null,null,{"$f":"SUM(E17:E23)","v":0},{"$f":"+G24/E24","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G17:G23)","v":0}]
[]
[]
["Supplemental Feed for Herd Bulls"]
[null,"Unit","Days fed","Pounds Fed per Day","Total Pounds Fed","$/unit","Cost/Cow"]
["50:50 Corn Gluten:Soy Hull Pellets","Tons",120,6,{"$f":"+D29*C29","v":720},275,{"$f":"+(E29/2000)*F29","v":99}]
[null,null,0,22,0,90,{"$f":"+(E30/2000)*F30","v":0}]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
["Total Feed for Herd Bulls","Tons",null,null,{"$f":"SUM(E29:E35)","v":720},{"$f":"+G36/E36","v":0.13750000000000001},{"$f":"SUM(G29:G35)","v":99}]
[]
[]
["Supplemental Feed for Calves"]
[null,"Unit","Days fed","Pounds Fed per Day","Total Pounds Fed","$/unit","Cost/Cow"]
["Cracked Corn","Tons",120,2,{"$f":"+D41*C41","v":240},325,{"$f":"+(E41/2000)*F41","v":39}]
[null,null,0,22,0,90,{"$f":"+(E42/2000)*F42","v":0}]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
[null,null,null,0,0,0,0]
["Total Feed for Calves","Tons",null,null,{"$f":"SUM(E41:E47)","v":240},{"$f":"+G48/E48","v":0.16250000000000001},{"$f":"SUM(G41:G47)","v":39}]

{"sheet":"Vet","index":8,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[32,0,32,6],[1,7,1,10],[2,0,2,6],[12,0,12,6],[13,0,13,6],[23,0,23,6]]}
[]
[null,null,null,null,null,null,null,"Return to Main Page"]
["Veterinary Expenses for Cow Herd"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["IBR,BVD,5-way Lepto, Vibrio",2,{"$f":"+IF(B5=1,#REF!,IF(B5=2,#REF!,IF(B5=3,#REF!,IF(B5=4,#REF!,IF(B5=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,4,{"$f":"+F5*E5","v":4}]
["Deworm",1,{"$f":"+IF(B6=1,#REF!,IF(B6=2,#REF!,IF(B6=3,#REF!,IF(B6=4,#REF!,IF(B6=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,3,3]
["Delice",3,{"$f":"+IF(B7=1,#REF!,IF(B7=2,#REF!,IF(B7=3,#REF!,IF(B7=4,#REF!,IF(B7=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",2,2,4]
["Fly Tags",4,{"$f":"+IF(B8=1,#REF!,IF(B8=2,#REF!,IF(B8=3,#REF!,IF(B8=4,#REF!,IF(B8=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",2,0.5,1]
["Preg Check",5,{"$f":"+IF(B9=1,#REF!,IF(B9=2,#REF!,IF(B9=3,#REF!,IF(B9=4,#REF!,IF(B9=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,2,2]
["Other",5,{"$f":"+IF(B10=1,#REF!,IF(B10=2,#REF!,IF(B10=3,#REF!,IF(B10=4,#REF!,IF(B10=5,#REF!)))))","v":{"$error":"#REF!"}},"Cow",1,0,0]
["Total Vet Expenses for Cows",null,null,null,null,null,{"$f":"+SUM(G5:G9)","v":14}]
[]
[]
["Veterinary Expenses for Replacement Heifers"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["5-way Lepto",2,{"$f":"+IF(B16=1,#REF!,IF(B16=2,#REF!,IF(B16=3,#REF!,IF(B16=4,#REF!,IF(B16=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",2,2,{"$f":"+F16*E16","v":4}]
["Synchronization",1,{"$f":"+IF(B17=1,#REF!,IF(B17=2,#REF!,IF(B17=3,#REF!,IF(B17=4,#REF!,IF(B17=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",1,8,{"$f":"+F17*E17","v":8}]
[null,3,{"$f":"+IF(B18=1,#REF!,IF(B18=2,#REF!,IF(B18=3,#REF!,IF(B18=4,#REF!,IF(B18=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",0,1,{"$f":"+F18*E18","v":0}]
[null,4,{"$f":"+IF(B19=1,#REF!,IF(B19=2,#REF!,IF(B19=3,#REF!,IF(B19=4,#REF!,IF(B19=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",1,4,{"$f":"+F19*E19","v":4}]
[null,5,{"$f":"+IF(B20=1,#REF!,IF(B20=2,#REF!,IF(B20=3,#REF!,IF(B20=4,#REF!,IF(B20=5,#REF!)))))","v":{"$error":"#REF!"}},"Heifer",null,null,{"$f":"+F20*E20","v":0}]
["Total Vet Expenses for Replacements",null,null,null,null,null,{"$f":"+SUM(G16:G20)","v":16}]
[]
[]
["Veterinary Expenses for Herd Bulls"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["IBR,BVD,5-way Lepto, Vibrio",2,{"$f":"+IF(B26=1,#REF!,IF(B26=2,#REF!,IF(B26=3,#REF!,IF(B26=4,#REF!,IF(B26=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",1,4,{"$f":"+F26*E26","v":4}]
["Breeding Soundness Exam",1,{"$f":"+IF(B27=1,#REF!,IF(B27=2,#REF!,IF(B27=3,#REF!,IF(B27=4,#REF!,IF(B27=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",1,35,{"$f":"+F27*E27","v":35}]
["Deworm",3,{"$f":"+IF(B28=1,#REF!,IF(B28=2,#REF!,IF(B28=3,#REF!,IF(B28=4,#REF!,IF(B28=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",2,3,{"$f":"+F28*E28","v":6}]
["Delice",4,{"$f":"+IF(B29=1,#REF!,IF(B29=2,#REF!,IF(B29=3,#REF!,IF(B29=4,#REF!,IF(B29=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",1,2,{"$f":"+F29*E29","v":2}]
[null,5,{"$f":"+IF(B30=1,#REF!,IF(B30=2,#REF!,IF(B30=3,#REF!,IF(B30=4,#REF!,IF(B30=5,#REF!)))))","v":{"$error":"#REF!"}},"Bull",null,null,{"$f":"+F30*E30","v":0}]
["Total Vet Expenses for Bulls",null,null,null,null,null,{"$f":"+SUM(G26:G30)","v":47}]
[]
["Veterinary Expenses for Calves"]
["Item",null,"Item","Unit","Number Applications","$/Applic.","Total Cost/Cow"]
["Implant",2,{"$f":"+IF(B35=1,#REF!,IF(B35=2,#REF!,IF(B35=3,#REF!,IF(B35=4,#REF!,IF(B35=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",0.5,1,{"$f":"+F35*E35","v":0.5}]
["IBR,PI3,BVD,BRSV",1,{"$f":"+IF(B36=1,#REF!,IF(B36=2,#REF!,IF(B36=3,#REF!,IF(B36=4,#REF!,IF(B36=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",2,3,{"$f":"+F36*E36","v":6}]
[null,3,{"$f":"+IF(B37=1,#REF!,IF(B37=2,#REF!,IF(B37=3,#REF!,IF(B37=4,#REF!,IF(B37=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",0,1,{"$f":"+F37*E37","v":0}]
[null,4,{"$f":"+IF(B38=1,#REF!,IF(B38=2,#REF!,IF(B38=3,#REF!,IF(B38=4,#REF!,IF(B38=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",0,4,{"$f":"+F38*E38","v":0}]
[null,5,{"$f":"+IF(B39=1,#REF!,IF(B39=2,#REF!,IF(B39=3,#REF!,IF(B39=4,#REF!,IF(B39=5,#REF!)))))","v":{"$error":"#REF!"}},"Calf",null,null,{"$f":"+F39*E39","v":0}]
["Total Vet Expenses for Calves",null,null,null,null,null,{"$f":"+SUM(G35:G39)","v":6.5}]

{"sheet":"Auction","index":9,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,3],[5,1,5,3],[2,1,2,7],[2,8,2,10],[6,1,6,3],[9,1,9,3],[10,1,10,3],[7,1,7,3],[8,1,8,3]]}
[]
[]
[null,"Auction & Hauling Cost Detail",null,null,null,null,null,null,"Return to Main Budget"]
[]
[null,"     ITEM",null,null,"UNIT","QUANTITY","PRICE","AMOUNT"]
[null,"Commission",null,null,"%",{"$f":"+Main!C103*Main!G103","v":674.38690000000031},0.03,{"$f":"+G6*F6","v":20.231607000000007}]
[null,"Yardage",null,null,"Day",1,1,{"$f":"+G7*F7","v":1}]
[null,"Hauling",null,null,"MILES",100,2.5,{"$f":"+(F8*G8)/24","v":10.416666666666666}]
[null,"Checkoff",null,null,"Head",1,1,{"$f":"+G9*F9","v":1}]
[null,"Other",null,null,"Head",1,1,{"$f":"+G10*F10","v":1}]
[]
[null,"Total Auction & Hauling Cost",null,null,null,null,null,{"$f":"+SUM(H6:H10)","v":33.648273666666675}]

{"sheet":"Lvstk_Facil","index":10,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[33,1,33,3],[41,1,41,3],[32,1,32,3],[36,1,36,3],[37,1,37,3],[40,1,40,3],[42,1,42,3],[35,1,35,3],[23,1,23,2],[31,1,31,3],[11,1,11,2],[9,1,9,2],[30,1,30,8],[26,1,26,3],[8,1,8,2],[4,1,4,2],[2,1,2,13],[5,1,5,2],[6,1,6,2],[7,1,7,2]]}
[]
[]
[null,"INVESTMENT, ANNUAL FIXED COSTS, AND ANNUAL PAYMENTS"]
[null,null,null,null,null,null,null,null,null,""]
[null,"Return to Main Budget"]
[null,"Item",null,"Number","$/Unit","Total Cost","Salvage Value","Years of Useful Life","Annual Depreciation","Percent Financed","Amount Financed","Interest Rate","Years Financed","Annual Payment"]
[null,"LIVESTOCK"]
[null,"Purchased Females",null,50,1000,{"$f":"D8*E8","v":50000},{"$f":"+((cow_wt*cow_price)*(100%-cow_death))*D8","v":29645},{"$f":"1/cow_cull","v":6.666666666666667},{"$f":"+(F8-G8)/H8","v":3053.25},0.25,{"$f":"+J8*F8","v":12500},0.08,5,{"$f":"-PMT(L8,M8,K8)","v":3130.7056820854573}]
[null,"Bulls",null,2,2500,{"$f":"D9*E9","v":5000},{"$f":"+(bull_wt*bull_price)*bulls","v":2628},{"$f":"1/bull_cull","v":4},{"$f":"+(F9-G9)/H9","v":593},0.25,{"$f":"+J9*F9","v":1250},0.08,5,{"$f":"-PMT(L9,M9,K9)","v":313.07056820854575}]
[null,"TOTAL LIVESTOCK",null,null,null,{"$f":"+SUM(F8:F9)","v":55000},{"$f":"+SUM(G8:G9)","v":32273},null,{"$f":"+SUM(I8:I9)","v":3646.25},null,{"$f":"+SUM(K8:K9)","v":13750},null,null,{"$f":"SUM(N8:N9)","v":3443.7762502940031}]
[]
[null,"BUILDINGS & FACILITIES"]
[null,"Fences (Miles)",null,{"$f":"+(7379+9261+4174+2952+3704)/5280","v":5.2026515151515156},1925,{"$f":"+IF(D13<>0,(D13*E13),0)","v":10015.104166666668},0,30,{"$f":"+(F13-G13)/H13","v":333.8368055555556},0,{"$f":"+J13*F13","v":0},0.08,20,{"$f":"-PMT(L13,M13,K13)","v":0}]
[null,"Head Gate",null,1,400,{"$f":"+IF(D14<>0,(D14*E14),0)","v":400},0,10,{"$f":"F14/H14","v":40},0,0,0.08,20,0]
[null,"Chutes & Pens",null,1,8500,8500,{"$f":"+F15*0.2","v":1700},20,425,0,0,0.08,10,0]
[null,"Barn",null,1,15000,15000,3000,30,500,0,0,0.08,20,0]
[null,"Hay Racks",null,1,1000,1000,0,7,142.85714285714286,0,0,0.08,10,0]
[null,"Feed Troughs",null,1,1200,1200,240,15,80,0,0,0.08,10,0]
[null,"Miscellanous Equipment",null,1,1000,1000,200,20,50,0,0,0.08,15,0]
[null,"Other",null,0,null,0,0,15,0,0,0,0.08,10,0]
[null,"Other",null,0,"",0,0,15,0,0,0,0.08,10,0]
[null,"Other",null,0,"",0,0,20,0,0,0,0.08,15,0]
[null,"Other",null,null,"",0,0,5,0,0,0,0.08,5,0]
[null,"TOTAL BUILDINGS &  FACILITIES",null,null,null,{"$f":"+SUM(F13:F23)","v":37115.104166666672},{"$f":"+SUM(G13:G23)","v":5140},null,{"$f":"+SUM(I13:I23)","v":1571.6939484126985},null,{"$f":"+SUM(K13:K23)","v":0},null,null,{"$f":"+SUM(N13:N23)","v":0}]
[]
[]
[null,"LAND"]
[null,"LAND ",null,63,1000,{"$f":"+E28*D28","v":63000},0,null,0,0,{"$f":"+J28*F28","v":0},0.08,20,{"$f":"PMT(Lvstk_Facil!L28,Lvstk_Facil!M28,-K28)","v":0}]
[]
[]
[null,"TOTALS FOR FIXED COSTS"]
[null,"Average Purchased Livestock Investment",null,null,{"$f":"+((lvstk_inv+G10)/2)","v":43636.5}]
[null,"Interest to Charge on Average Livestock Investment",null,null,0.08]
[null,"Total Livestock Fixed Cost",null,null,{"$f":"+livestock_facil_print*E32","v":3490.92}]
[]
[null,"Average Buildings & Facilities Investment",null,null,{"$f":"+(F24+G24)/2","v":21127.552083333336}]
[null,"Interest on Average buildings & Facilities Investment",null,null,0.08,null,"",null,""]
[null,"Total Buildings & Facilities Fixed Cost",null,null,{"$f":"+(facil_int*facil_avginv)+build_dep","v":3261.8981150793652}]
[]
[null,null,null,"","","","",null,""]
[null,"Land Investment",null,null,{"$f":"+F28","v":63000}]
[null,"Interest on Land Investment",null,null,{"$f":"+land_int","v":0}]
[null,"Total Land Fixed Cost",null,null,{"$f":"+land_int*E41","v":0}]
[]
[null,"TOTAL ANNUAL FIXED COSTS",null,null,{"$f":"+lvstk_dep+build_dep+lvstk_fc+facil_fc+land_fc","v":11970.762063492064}]

{"sheet":"Equipment","index":11,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,0,29,2],[30,0,30,2],[1,0,1,15],[0,0,0,1],[23,0,23,2],[24,0,24,2],[25,0,25,2],[28,0,28,2]]}
["Return to Main"]
["DETAIL FOR EQUIPMENT USED IN COW-CALF AND HAY OPERATIONS"]
["Item","Cost","Salvage Value","Useful Life","Depreciation","% Used in Cow-Calf","%Used in Hay","Cow-Calf Avg Investment","Hay Investment","Cow-Calf Depreciation","Hay Depreciation","%Financed","Interest Rate","Years","Total Payment","% Cattle or Hay Payment"]
["75 hp Tractor-2wd",37000,{"$f":"+B4*0.2","v":7400},8,{"$f":"+(B4-C4)/D4","v":3700},0.25,0.25,{"$f":"+((B4+C4)/2)*F4","v":5550},{"$f":"+((B4+C4)/2)*G4","v":5550},{"$f":"+F4*E4","v":925},{"$f":"+G4*E4","v":925},0,0.08,5,{"$f":"-PMT(M4,N4,(B4*L4))","v":0},{"$f":"+O4*(F4+G4)","v":0}]
["130 hp Tractor-MFWD",40000,{"$f":"+B5*0.2","v":8000},8,{"$f":"+(B5-C5)/D5","v":4000},0.1,0.1,{"$f":"+((B5+C5)/2)*F5","v":2400},{"$f":"+((B5+C5)/2)*G5","v":2400},{"$f":"+F5*E5","v":400},{"$f":"+G5*E5","v":400},0.5,0.08,5,{"$f":"-PMT(M5,N5,(B5*L5))","v":5009.129091336732},{"$f":"+O5*(F5+G5)","v":1001.8258182673464}]
["Front-end loader w/spear",5500,1100,8,550,0.25,0.25,825,825,137.5,137.5,0,0.08,5,0,0]
["7' Rotary Mower",3500,700,8,{"$f":"+(B7-C7)/D7","v":350},0.25,0.25,525,525,{"$f":"+F7*E7","v":87.5},{"$f":"+G7*E7","v":87.5},0,0.08,5,{"$f":"-PMT(M7,N7,(B7*L7))","v":0},{"$f":"+O7*(F7+G7)","v":0}]
["14' Disk Harrow",9250,1850,10,740,0.1,0,555,0,74,0,0,0.08,5,0,0]
["12' Grain Drill",11500,2300,8,1150,0.1,0,690,0,115,0,0,0.08,5,0,0]
["8' Disc Mower",0,0,5,0,0.2,0.8,0,0,0,0,0,0.08,5,0,0]
["17' Double Hay Rake",0,0,8,0,0,1,0,0,0,0,0,0.08,5,0,0]
["17' Hay Tedder",0,0,8,0,0,1,0,0,0,0,0,0.08,5,0,0]
["20' Hay Trailer -2",0,0,8,0,0.5,0.5,0,0,0,0,0,0.08,5,0,0]
["Large Round Baler",0,0,5,{"$f":"+(B14-C14)/D14","v":0},0,1,0,0,{"$f":"+F14*E14","v":0},{"$f":"+G14*E14","v":0},0.5,0.08,5,{"$f":"-PMT(M14,N14,(B14*L14))","v":0},{"$f":"+O14*(F14+G14)","v":0}]
["Other 1",null,null,null,null,null,null,0,0]
["Other 2",null,null,null,null,null,null,0,0]
["Other 3",null,null,null,null,null,null,0,0]
["Other 4",null,null,null,null,null,null,0,0]
["Other 5",null,null,null,null,null,null,0,0]
["Other 6",null,null,null,null,null,null,0,0]
["Total",{"$f":"+SUM(B4:B20)","v":106750},{"$f":"+SUM(C4:C20)","v":21350},null,{"$f":"+SUM(E4:E20)","v":10490},null,null,{"$f":"+SUM(H4:H20)","v":10545},{"$f":"+SUM(I4:I20)","v":9300},{"$f":"+SUM(J4:J20)","v":1739},{"$f":"+SUM(K4:K20)","v":1550},null,null,null,{"$f":"+SUM(O4:O20)","v":5009.129091336732},{"$f":"+SUM(P4:P20)","v":1001.8258182673464}]
[]
[]
["Average Cow Equipment Investment",null,null,{"$f":"+(cow_inv+cow_dep)/2","v":6142}]
["Interest rate on Average Investment",null,null,0.08]
["Interest on Average Cow Equipment Investment",null,null,{"$f":"+D25*D24","v":491.36}]
["Total Cow Equipment Fixed Costs",null,null,{"$f":"+D26+cow_dep","v":2230.36}]
[]
["Average Hay Equipment Investment",null,null,{"$f":"+(hay_inv+Hay_dep)/2","v":5425}]
["Interest rate on Average Investment",null,null,0.08]
["Interest on Average Hay Equipment Investment",null,null,{"$f":"+D30*D29","v":434}]
["Total Hay Equipment Fixed Costs",null,null,{"$f":"+D31+Hay_dep","v":1984}]

{"sheet":"Fixed_Cost","index":12,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[[8,1,8,2]]}
[]
[]
[null,"INVESTMENT AND ANNUAL FIXED COST"]
[null,"(Check All Entries This Page)"]
[]
[null,"                                        NO. OF C0WS:",null,null,null,null,null,{"$f":"+Main!H18","v":50}]
[null,"                                        INTEREST RATE:",null,null,null,null,null,0.09]
[]
[null,"     ITEM",null,"NUMBER","COST/HEAD","NEW COST","SALVAGE","YEARS","DEPR."]
[null,"COWS",null,60,700,{"$f":"D10*E10","v":42000},{"$f":"Main!H27*Main!H28*D10","v":36300},{"$f":"1/Main!H20","v":6.666666666666667},{"$f":"+(F10-G10)/H10","v":855}]
[null,"Purchased HEIFERS",null,0,850,{"$f":"D11*E11","v":0},0,6,{"$f":"+(F11-G11)/H11","v":0}]
[null,"BULLS",null,{"$f":"+Main!H29","v":2},1500,{"$f":"D12*E12","v":3000},{"$f":"+(Main!H31*Main!H32)*Main!H29","v":2628},4,93]
[]
[]
[]
[]
[null,"CORRAL & LOADING CHUTE",null,null,null,1200,0,10,120]
[null,"FENCE (MI.)",null,2.5,1800,{"$f":"D18*E18","v":4500},0,15,300]
[null,"FEED RACKS",null,null,null,800,0,10,80]
[null,"MISC. EQUIPMENT",null,null,null,500,0,5,100]
[]
[null,"TOTAL INVESTMENT & DEPRECIATION",null,null,null,{"$f":"SUM(F10:F20)","v":52000},{"$f":"SUM(G10:G20)","v":38928},null,{"$f":"SUM(I12:I20)","v":693}]
[]
[null,"INTEREST ON INVESTMENT (AVE. INV. TIMES INT. RATE)",null,null,null,null,null,null,{"$f":"(F22+G22)/2*H7","v":4091.7599999999998}]
[]
[null,"TAXES AND INSURANCE",null,null,null,null,1.4E-2,null,{"$f":"(F22+G22)/2*G26","v":636.49599999999998}]
[]
[null,"TOTAL ANNUAL FIXED COST",null,null,null,null,null,null,{"$f":"SUM(I22:I26)","v":5421.2560000000003}]
[]
[null,"TOTAL ANNUAL FIXED COST PER BROOD COW",null,null,null,null,null,null,{"$f":"I28/H6","v":108.42512000000001}]

{"sheet":"Fixed_Payment","index":13,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"ANNUAL ENTERPRISE FIXED PAYMENTS"]
[null," (Check All Entries This Page)"]
[]
[null,null,null,null,"NO. OF ACRES:",null,{"$f":"+Main!F47+Main!F48+Main!F50","v":62.5}]
[null,null,null,null,"NO. OF COWS:",null,{"$f":"+Main!H18","v":50}]
[]
[null,"DEBT PAYMENT CALCULATION ON NEW INVESTMENT:"]
[null,"(For Use In Calculating Fixed Cash Outlays on New Investment)"]
[]
[null,null,null,"","UNIT","TOTAL","    ----FINANCING----"]
[null,"ITEM",null,"NUMBER","COST","COST","AMOUNT","YEARS","INT.RATE","PAYMENT"]
[null,"COWS",null,100,500,{"$f":"D14*E14","v":50000},0.5,7,0.11,{"$f":"PMT(I14,H14,-F14*G14)","v":5305.3817362524424}]
[null,"HEIFERS",null,20,400,{"$f":"D15*E15","v":8000},0.5,7,0.11,{"$f":"PMT(I15,H15,-F15*G15)","v":848.86107780039072}]
[null,"BULLS",null,3,1500,{"$f":"D16*E16","v":4500},0.5,7,0.11,477.48435626271976]
[null,"FENCE (MI.)",null,2.5,1800,{"$f":"D17*E17","v":4500},0.5,7,0.11,477.48435626271976]
[null,"CORRAL & LOADING CHUTE",null,null,null,1200,0.5,7,0.11,127.32916167005862]
[null,"FEED RACKS",null,null,null,800,0.5,7,0.11,84.886107780039069]
[null,"MISC. EQUIP.",null,null,"",500,0.5,7,0.11,53.05381736252442]
[null,null,null,null,"","","","",""]
[null,"LAND",null,0,500,{"$f":"D22*E22","v":0},1,30,0.1,{"$f":"PMT(I22,H22,-F22*G22)","v":0}]
[null,null,null,null,null,"","","",""]
[]
[]
[null,"CURRENT ANNUAL DEBT PAYMENTS:"]
[null,"(For Use In Totaling Debt Payments on Existing Investment)"]
[]
[null,"LOAN # 1",null,null,null,null,null,null,null,0]
[null,"LOAN # 2",null,null,null,null,null,null,null,0]
[null,"LOAN # 3",null,null,null,null,null,null,null,0]
[null,"LOAN # 4",null,null,null,null,null,null,null,0]
[null,"LOAN # 5",null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,"TOTAL ANNUAL DEBT PAYMENT",null,null,null,null,{"$f":"SUM(J14:J34)","v":7374.4806133908951}]
[null,null,null,null,"TAXES AND INSURANCE",null,null,null,null,{"$f":"+Fixed_Cost!I26","v":636.49599999999998}]
[]
[]
[null,null,null,null,"TOTAL ANNUAL FIXED OUTLAY",null,null,null,null,{"$f":"SUM(J37:J38)","v":8010.9766133908952}]
[null,null,null,null,"TOTAL ANNUAL FIXED PAYMENT PER COW",null,null,null,null,{"$f":"J41/G7","v":160.2195322678179}]

{"sheet":"J","index":14,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,-8941.9831759052358,2.2750092654188533E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-6741.1663194289249,6.6807279375848599E-2]
[1,null,null,null,null,null,null,null,null,null,null,null,null,-4540.349462952614,0.15865531316113057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-3439.9410347144585,0.22662732264844102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2339.5326064763035,0.3085375586179277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1239.1241782381483,0.40129373468325191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-138.71574999999302,0.49999999977461573]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-138.71574999999302,0.49999999977461573]
[null,null,null,null,null,null,null,null,null,null,null,null,null,961.69267823816199,0.59870626531674809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2062.101106476317,0.69146244138207225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3162.509534714472,0.77337267735155901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4262.917962952627,0.84134468683886943]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6463.734819428937,0.93319272062415137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8664.551675905248,0.97724990734581152]

{"sheet":"K","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"L","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"M","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"N","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"O","index":19,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[1,1]
[0]