{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["HFR-Budget","Monthly Flows","Vet&Breeding"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":24,"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":"HFR-Budget","index":0,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,2,25,3],[22,2,22,3],[27,2,27,3],[26,2,26,3],[23,2,23,3],[24,2,24,3],[1,1,1,10],[2,1,2,10],[3,2,3,5],[21,2,21,3],[19,2,19,3],[14,2,14,3],[16,2,16,3],[15,2,15,3],[18,2,18,3],[17,2,17,3],[20,2,20,3]]}
[]
[null,"Table 1:  Replacement Heifer Budget, 100 Head - 2020 ",null,null,null,null,null,null,null,null,null,null,null,null,"EBB-HFR-20"]
[null,"Wintered to Go to Grass, Bought in Fall, Sold in Winter",null,null,null,null,null,null,null,null,null,"No. of Head:",100]
[]
[null,null,null,null,null,null,null,"Total Number"]
[null,null,null,"Weight",null,null,null,"of Head",null,"Price or",null,"Total","Value or"]
[null,null,null,"Each",null,"Unit",null,"or Units",null,"Cost/Unit",null,"Value","Cost/Head",null,"Your Value"]
[null,null,"GROSS RETURNS"]
[null,null,"Bred Replacement Heifers",1100,null,"hd",null,90,null,1450,null,{"$f":"J9*H9","v":130500},{"$f":"L9/$M$3","v":1305}]
[null,null,"Cull Heifers",1000,null,"lbs",null,9,null,1,null,{"$f":"D10*H10*J10","v":9000},{"$f":"L10/$M$3","v":90}]
[null,null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L10)","v":139500},{"$f":"SUM(M9:M10)","v":1395}]
[]
[null,null,"OPERATING COSTS"]
[null,null,"Purchased/Transfered Heifers",500,null,"lbs",null,100,null,1.7,null,{"$f":"D14*H14*J14","v":85000},{"$f":"L14/$M$3","v":850}]
[null,null,"Alfalfa Hay",null,null,"ton",null,251,null,150,null,{"$f":"H15*J15","v":37650},{"$f":"L15/$M$3","v":376.5}]
[null,null,"Supplement",null,null,"cwt",null,0,null,13,null,{"$f":"H16*J16","v":0},{"$f":"L16/$M$3","v":0}]
[null,null,"Yardage",null,null,"hd-day",null,{"$f":"7*30*M3","v":21000},null,0.35,null,7349.9999999999991,73.499999999999986]
[null,null,"Pasture",null,null,"AUM",null,550,null,20,null,{"$f":"H18*J18","v":11000},110]
[null,null,"Hauling",null,null,"head",null,100,null,15,null,1500,15]
[null,null,"Veterinary",null,null,"head",null,100,null,{"$f":"'Vet&Breeding'!T16","v":29.125},null,2912.5,29.125]
[null,null,"Breeding",null,null,"head",null,100,null,{"$f":"'Vet&Breeding'!T31","v":69.900000000000006},null,{"$f":"H21*J21","v":6990.0000000000009},{"$f":"L21/$M$3","v":69.900000000000006}]
[null,null,"Hired Labor",null,null,"hour",null,200,null,17.5,null,{"$f":"H22*J22","v":3500},35]
[null,null,"Salt/Mineral",null,null,"cwt",null,27,null,18,null,486,4.8600000000000003]
[null,null,"Marketing",null,null,"head",null,99,null,2.96,null,293.04000000000002,2.9304000000000001]
[null,null,"Commision",null,null,"head",null,9,null,{"$f":"D10*J10*0.025","v":25},null,{"$f":"H25*J25","v":225},{"$f":"L25/$M$3","v":2.25}]
[null,null,"Miscellaneous",null,null,"head",null,100,null,10,null,1000,10]
[]
[null,null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(L14:L27)*0.75","v":118429.905},null,7.0000000000000007E-2,null,{"$f":"H28*J28*0.75","v":6217.5700125000003},62.175700125000006]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L28)","v":164124.11001250002},1641.2411001250002]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L11-L29","v":-24624.110012500023},{"$f":"L31/$M$3","v":-246.24110012500023}]

{"sheet":"Monthly Flows","index":1,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBB-HFR-20"]
[null,null,null,"Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Value"]
[]
[null,"Production:"]
[null,null,{"$f":"'HFR-Budget'!C9","v":"Bred Replacement Heifers"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R6","v":130500},{"$f":"'HFR-Budget'!L9","v":130500}]
[null,null,{"$f":"'HFR-Budget'!C10","v":"Cull Heifers"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":9000},null,{"$f":"'HFR-Budget'!L10","v":9000}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,9000,130500,{"$f":"'HFR-Budget'!L11","v":139500}]
[]
[]
[null,"Operating Inputs:"]
[null,null,{"$f":"'HFR-Budget'!C14","v":"Purchased/Transfered Heifers"},{"$f":"R13","v":85000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HFR-Budget'!L14","v":85000}]
[null,null,{"$f":"'HFR-Budget'!C15","v":"Alfalfa Hay"},{"$f":"$R$14*0.09","v":3388.5},{"$f":"$R$14*0.1","v":3765},{"$f":"$R$14*0.11","v":4141.5},{"$f":"$R$14*0.12","v":4518},{"$f":"$R$14*0.12","v":4518},{"$f":"$R$14*0.13","v":4894.5},{"$f":"$R$14*0.14","v":5271.0000000000009},null,null,null,null,null,{"$f":"$R$14*0.09","v":3388.5},{"$f":"$R$14*0.1","v":3765},{"$f":"'HFR-Budget'!L15","v":37650}]
[null,null,{"$f":"'HFR-Budget'!C16","v":"Supplement"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HFR-Budget'!L16","v":0}]
[null,null,{"$f":"'HFR-Budget'!C17","v":"Yardage"},{"$f":"0.125*$R$16","v":918.74999999999989},{"$f":"0.125*$R$16","v":918.74999999999989},918.74999999999989,918.74999999999989,918.74999999999989,918.74999999999989,918.74999999999989,null,null,null,null,null,{"$f":"0.0625*$R$16","v":459.37499999999994},{"$f":"0.0625*$R$16","v":459.37499999999994},{"$f":"'HFR-Budget'!L17","v":7349.9999999999991}]
[null,null,{"$f":"'HFR-Budget'!C18","v":"Pasture"},null,null,null,null,null,null,null,{"$f":"0.1818*$R$17","v":1999.8},{"$f":"0.1818*$R$17","v":1999.8},1999.8,1999.8,1999.8,{"$f":"0.0909*$R$17","v":999.9},null,{"$f":"'HFR-Budget'!L18","v":11000}]
[null,null,{"$f":"'HFR-Budget'!C19","v":"Hauling"},null,null,null,null,null,null,null,{"$f":"R18*0.5","v":750},null,null,null,null,{"$f":"R18*0.5","v":750},null,{"$f":"'HFR-Budget'!L19","v":1500}]
[null,null,{"$f":"'HFR-Budget'!C20","v":"Veterinary"},{"$f":"R19*0.3","v":873.75},null,null,null,null,{"$f":"R19*0.3","v":873.75},null,null,null,null,null,null,{"$f":"R19*0.4","v":1165},null,{"$f":"'HFR-Budget'!L20","v":2912.5}]
[null,null,{"$f":"'HFR-Budget'!C21","v":"Breeding"},null,null,null,null,null,null,{"$f":"R20","v":6990.0000000000009},null,null,null,null,null,null,null,{"$f":"'HFR-Budget'!L21","v":6990.0000000000009}]
[null,null,{"$f":"'HFR-Budget'!C22","v":"Hired Labor"},{"$f":"$R$21/14","v":250},{"$f":"$R$21/14","v":250},250,250,250,250,250,250,250,250,250,250,250,250,{"$f":"'HFR-Budget'!L22","v":3500}]
[null,null,{"$f":"'HFR-Budget'!C23","v":"Salt/Mineral"},{"$f":"$R$22/14","v":34.714285714285715},{"$f":"$R$22/14","v":34.714285714285715},34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,34.714285714285715,{"$f":"'HFR-Budget'!L23","v":486}]
[null,null,{"$f":"'HFR-Budget'!C24","v":"Marketing"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R23","v":293.04000000000002},{"$f":"'HFR-Budget'!L24","v":293.04000000000002}]
[null,null,{"$f":"'HFR-Budget'!C25","v":"Commision"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R24","v":225},null,{"$f":"'HFR-Budget'!L25","v":225}]
[null,null,{"$f":"'HFR-Budget'!C26","v":"Miscellaneous"},{"$f":"$R$25/14","v":71.428571428571431},{"$f":"$R$25/14","v":71.428571428571431},71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,71.428571428571431,{"$f":"'HFR-Budget'!L26","v":1000}]
[null,null,{"$f":"'HFR-Budget'!C28:D28","v":"Interest on Operating Capital"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R26","v":6217.5700125000003},{"$f":"'HFR-Budget'!L28","v":6217.5700125000003}]
[]
[null,"Total Costs",null,{"$f":"SUM(D13:D24)","v":90465.71428571429},4968.4642857142853,5344.9642857142853,5721.4642857142853,5721.4642857142853,6971.7142857142853,13464.464285714288,3034.514285714286,2284.514285714286,2284.514285714286,2284.514285714286,2284.514285714286,7272.489285714285,4802.1292857142853,{"$f":"SUM(R13:R26)","v":164124.11001250002}]
[]
[]
[null,"Net Returns",null,{"$f":"D9-D28","v":-90465.71428571429},-4968.4642857142853,-5344.9642857142853,-5721.4642857142853,-5721.4642857142853,-6971.7142857142853,-13464.464285714288,-3034.514285714286,-2284.514285714286,-2284.514285714286,-2284.514285714286,null,null,125697.87071428572,-24624.110012500023]
[]
[]
[]
[null,"Table 3:  Monthly Feed Requirements. "]
[null,"Feed",null,"Units","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[]
[null,"Alfalfa Hay",null,"ton",23,25,27,29,31,33,35,null,null,null,null,null,{"$f":"47/2","v":23.5},{"$f":"49/2","v":24.5}]
[null,"Supplement",null,"cwt"]
[null,"Pasture",null,"head",null,null,null,null,null,null,null,100,100,100,100,100,50]
[null,"Salt/Mineral",null,"cwt",2,2,2,2,2,2,2,2,2,2,2,2,2,1]
[]
[]
[]
[]
[]
[null,null,null,"Weight","Feed (ton)"]
[null,null,"Nov",500,{"$f":"D48*0.03*30*100/2000","v":22.5}]
[null,null,"Dec",{"$f":"D48+45","v":545},{"$f":"D49*0.03*30*100/2000","v":24.524999999999995}]
[null,null,"Jan",{"$f":"D49+45","v":590},26.55]
[null,null,"Feb",635,28.574999999999999]
[null,null,"Mar",680,30.6]
[null,null,"Apr",725,32.625]
[null,null,"May",770,34.649999999999991]
[null,null,"Jun",815,36.674999999999997]
[null,null,"Jul",860,38.700000000000003]
[null,null,"Aug",905,40.725000000000001]
[null,null,"Sep",950,42.75]
[null,null,"Oct",995,44.774999999999991]
[null,null,"Nov",1040,46.8]
[null,null,"Dec",1085,48.824999999999996]

{"sheet":"Vet&Breeding","index":2,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Veterinary Expenses"]
[]
[]
[null,"Number of Head",null,"Units","$/Unit","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Heifers",100]
["Respiratory Viral",null,null,"dose",1.8,1,null,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(F6:S6)*$B$5*E6","v":540}]
["Reproduction Viral",null,null,"dose",2.4,null,null,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(F7:S7)*$B$5*E7","v":480}]
["8 Way",null,null,"dose",0.9,1,null,null,null,1,null,null,null,null,null,null,null,1,null,270]
["Pour-On",null,null,"dose",0.8,1,null,null,null,1,null,null,null,null,null,null,null,1,null,240]
["Bangs",null,null,"head",4,1,null,null,null,null,null,null,null,null,null,null,null,null,null,400]
["Preg Check",null,null,"head",4,null,null,null,null,null,null,null,null,null,null,null,null,1,null,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(T6:T11)","v":2330}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/Hd",{"$f":"T12/B5","v":23.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus 25%",{"$f":"T14*1.25","v":29.125}]
["Breeding Expenses"]
[]
[]
[null,"Number of Head",null,"Units","$/Unit","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Heifers",100]
["GnRH (Cystorelin)",null,null,"dose",2.6,null,null,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"SUM(F22:S22)*$B$5*E22","v":520}]
["PG (Lutalyse)",null,null,"dose",2.9,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F23:S23)*$B$5*E23","v":290}]
["CIDR",null,null,"dose",12.8,null,null,null,null,null,null,1,null,null,null,null,null,null,null,1280]
["AI Supplies",null,null,"head",0.5,null,null,null,null,null,null,1,null,null,null,null,null,null,null,50]
["Semen",null,null,"dose",20,null,null,null,null,null,null,1,null,null,null,null,null,null,null,2000]
["AI Technician",null,null,"head",6,null,null,null,null,null,null,1,null,null,null,null,null,null,null,600]
["Clean up bull (ammortized per head cost)",null,null,"head",{"$f":"3*3000/4/B21","v":22.5},null,null,null,null,null,null,1,null,null,null,null,null,null,null,2250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(T22:T28)","v":6990}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/Hd",{"$f":"T29/B21","v":69.900000000000006}]