{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ST3-Budget","Monthly Flows","Vet"],"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":"ST3-Budget","index":0,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,2,22,3],[24,2,24,3],[23,2,23,3],[1,1,1,10],[2,1,2,10],[3,2,3,5],[20,2,20,3],[19,2,19,3],[14,2,14,3],[16,2,16,3],[15,2,15,3],[21,2,21,3],[17,2,17,3],[18,2,18,3]]}
[]
[null,"Table 1:  Stocker Budget, 200 Head - 2018 ",null,null,null,null,null,null,null,null,null,null,null,null,"EBB-ST3-18"]
[null,"Bought in Spring & Sold in Fall",null,null,null,null,null,null,null,null,null,"No. of Head:",200]
[]
[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,"Steers",875,null,"lbs",null,198,null,1.35,null,{"$f":"D9*H9*J9","v":233887.50000000003},{"$f":"L9/$M$3","v":1169.4375000000002}]
[]
[null,null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L10)","v":233887.50000000003},{"$f":"SUM(M9:M10)","v":1169.4375000000002}]
[]
[null,null,"OPERATING COSTS"]
[null,null,"Purchased Steers",600,null,"lbs",null,200,null,1.65,null,{"$f":"D14*H14*J14","v":198000},{"$f":"L14/$M$3","v":990}]
[null,null,"Alfalfa Hay",null,null,"ton",null,22,null,150,null,{"$f":"H15*J15","v":3300},{"$f":"L15/$M$3","v":16.5}]
[null,null,"Private Range",null,null,"head",null,300,null,16,null,{"$f":"H16*J16","v":4800},{"$f":"L16/$M$3","v":24}]
[null,null,"Pasture",null,null,"head",null,900,null,18,null,16200,81]
[null,null,"Salt/Mineral",null,null,"cwt",null,12,null,25,null,{"$f":"H18*J18","v":300},{"$f":"L18/$M$3","v":1.5}]
[null,null,"Hauling",null,null,"head",null,200,null,10,null,2000,10]
[null,null,"Veterinary",null,null,"head",null,200,null,{"$f":"Vet!R12","v":4.75},null,{"$f":"H20*J20","v":950},4.75]
[null,null,"Hired Labor",null,null,"hour",null,20,null,17.5,null,{"$f":"H21*J21","v":350},1.75]
[null,null,"Marketing",null,null,"head",null,198,null,{"$f":"M9*0.025","v":29.235937500000006},null,5788.7156250000007,28.943578125000002]
[null,null,"Miscellaneous",null,null,"head",null,200,null,10,null,2000,10]
[]
[null,null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(L14:L24)*0.5","v":116844.35781250001},null,7.0000000000000007E-2,null,{"$f":"H25*J25","v":8179.1050468750009},40.895525234375008]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L25)","v":241867.820671875},1209.339103359375]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L11-L26","v":-7980.3206718749716},{"$f":"L28/$M$3","v":-39.90160335937486}]

{"sheet":"Monthly Flows","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[21,2,21,3]]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"EBB-ST3-20"]
[null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Value"]
[]
[null,"Production:"]
[null,null,"Steers",null,null,null,null,null,null,null,null,{"$f":"P6","v":233887.50000000003},null,null,null,{"$f":"'ST3-Budget'!L9","v":233887.50000000003}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D7)","v":0},0,0,0,0,0,0,0,233887.50000000003,0,0,0,{"$f":"P6","v":233887.50000000003}]
[]
[]
[null,"Operating Inputs:"]
[null,null,{"$f":"'ST3-Budget'!C14","v":"Purchased Steers"},null,null,{"$f":"P12","v":198000},null,null,null,null,null,null,null,null,null,{"$f":"'ST3-Budget'!L14","v":198000}]
[null,null,{"$f":"'ST3-Budget'!C15:D15","v":"Alfalfa Hay"},null,null,{"$f":"P13","v":3300},null,null,null,null,null,null,null,null,null,{"$f":"'ST3-Budget'!L15","v":3300}]
[null,null,{"$f":"'ST3-Budget'!C16:D16","v":"Private Range"},null,null,null,{"$f":"P14*0.6667","v":3200.16},{"$f":"P14*0.3333","v":1599.84},null,null,null,null,null,null,null,{"$f":"'ST3-Budget'!L16","v":4800}]
[null,null,{"$f":"'ST3-Budget'!C17:D17","v":"Pasture"},null,null,null,null,{"$f":"P15*0.11111","v":1799.982},{"$f":"$P$15*0.22222","v":3599.9639999999999},{"$f":"$P$15*0.22222","v":3599.9639999999999},3599.9639999999999,3599.9639999999999,null,null,null,{"$f":"'ST3-Budget'!L17","v":16200}]
[null,null,{"$f":"'ST3-Budget'!C18:D18","v":"Salt/Mineral"},null,null,null,{"$f":"$P$16*0.1666","v":49.98},{"$f":"$P$16*0.1666","v":49.98},49.98,49.98,49.98,49.98,null,null,null,{"$f":"'ST3-Budget'!L18","v":300}]
[null,null,{"$f":"'ST3-Budget'!C19:D19","v":"Hauling"},null,null,null,{"$f":"P17*0.5","v":1000},null,{"$f":"P17*0.5","v":1000},null,null,null,null,null,null,{"$f":"'ST3-Budget'!L19","v":2000}]
[null,null,{"$f":"'ST3-Budget'!C20:D20","v":"Veterinary"},null,null,{"$f":"P18","v":950},null,null,null,null,null,null,null,null,null,{"$f":"'ST3-Budget'!L20","v":950}]
[null,null,{"$f":"'ST3-Budget'!C21:D21","v":"Hired Labor"},null,null,{"$f":"P19","v":350},null,null,null,null,null,null,null,null,null,{"$f":"'ST3-Budget'!L21","v":350}]
[null,null,{"$f":"'ST3-Budget'!C22:D22","v":"Marketing"},null,null,null,null,null,null,null,null,{"$f":"P20","v":5788.7156250000007},null,null,null,{"$f":"'ST3-Budget'!L22","v":5788.7156250000007}]
[null,null,{"$f":"'ST3-Budget'!C23:D23","v":"Miscellaneous"},null,null,{"$f":"$P$21*0.25","v":500},{"$f":"$P$21*0.25","v":500},500,500,null,null,null,null,null,null,{"$f":"'ST3-Budget'!L23","v":2000}]
[null,null,"Interest on Operating Capital",null,null,null,null,null,null,null,null,{"$f":"P22","v":8179.1050468750009},null,null,null,{"$f":"'ST3-Budget'!L25","v":8179.1050468750009}]
[]
[null,"Total Costs",null,{"$f":"SUM(D12:D21)","v":0},0,203100,4750.1399999999994,3949.8020000000001,5149.9439999999995,3649.944,3649.944,9438.6596250000002,0,0,0,{"$f":"SUM(P12:P22)","v":241867.820671875}]
[]
[]
[null,"Net Returns",null,{"$f":"D8-D24","v":0},0,-203100,-4750.1399999999994,-3949.8020000000001,-5149.9439999999995,-3649.944,-3649.944,224448.84037500003,0,0,0,-7980.3206718749716]
[]
[]
[]
[null,"Table 3:  Monthly Feed Requirements. "]
[null,"Feed",null,"Units","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[]
[null,"Alfalfa Hay",null,"ton",null,null,22]
[null,"Private Range",null,"head",null,null,null,200,100]
[null,"Pasture",null,"head",null,null,null,null,100,200,200,200,200]
[null,"Salt/Mineral",null,"cwt",null,null,null,2,2,2,2,2,2]

{"sheet":"Vet","index":2,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Veterinary Expenses"]
[]
[]
[null,"Number of Head",null,"Units","$/Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Steer Calves",200]
["Respiratory Viral",null,null,"dose",1.8,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F6:Q6)*$B$5*E6","v":360}]
["8 Way",null,null,"dose",0.9,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F7:Q7)*$B$5*E7","v":180}]
["Pour-On",null,null,"dose",0.5,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F8:Q8)*$B$5*E8","v":100}]
["Implant",null,null,"head",1.55,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F9:Q9)*$B$5*E9","v":310}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R6:R9)","v":950}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/Hd",{"$f":"R10/B5","v":4.75}]