{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ST1-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":"ST1-Budget","index":0,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,2,24,3],[22,2,22,3],[26,2,26,3],[25,2,25,3],[23,2,23,3],[1,1,1,10],[2,1,2,10],[3,2,3,5],[21,2,21,3],[20,2,20,3],[14,2,14,3],[16,2,16,3],[15,2,15,3],[17,2,17,3],[19,2,19,3],[18,2,18,3]]}
[]
[null,"Table 1:  Stocker Budget, 200 Head - 2020 ",null,null,null,null,null,null,null,null,null,null,null,null,"EBB-ST1-20"]
[null,"Wintered to Go to Grass, Bought in Winter, 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",900,null,"lbs",null,198,null,1.35,null,{"$f":"D9*H9*J9","v":240570.00000000003},{"$f":"L9/$M$3","v":1202.8500000000001}]
[]
[null,null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L10)","v":240570.00000000003},{"$f":"SUM(M9:M10)","v":1202.8500000000001}]
[]
[null,null,"OPERATING COSTS"]
[null,null,"Purchased Steers",500,null,"lbs",null,200,null,1.65,null,{"$f":"D14*H14*J14","v":165000},{"$f":"L14/$M$3","v":825}]
[null,null,"Alfalfa Hay",null,null,"ton",null,94,null,150,null,{"$f":"H15*J15","v":14100},{"$f":"L15/$M$3","v":70.5}]
[null,null,"Feed Barley",null,null,"cwt",null,825,null,13,null,{"$f":"H16*J16","v":10725},{"$f":"L16/$M$3","v":53.625}]
[null,null,"Yardage",null,null,"day",null,15000,null,0.35,null,5250,26.25]
[null,null,"Private Range",null,null,"head",null,300,null,16,null,4800,24]
[null,null,"Pasture",null,null,"head",null,900,null,20,null,{"$f":"H19*J19","v":18000},90]
[null,null,"Hauling",null,null,"head",null,200,null,15,null,3000,15]
[null,null,"Veterinary",null,null,"head",null,200,null,{"$f":"Vet!R12*1.25","v":6.5625},null,1312.5,6.5625]
[null,null,"Hired Labor",null,null,"hour",null,100,null,17.5,null,{"$f":"H22*J22","v":1750},8.75]
[null,null,"Salt/Mineral",null,null,"cwt",null,12,null,13,null,156,0.78]
[null,null,"Marketing",null,null,"head",null,198,null,{"$f":"M9*0.025","v":30.071250000000006},null,5954.107500000001,29.770537500000003]
[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:L26)*0.5","v":116023.80375000001},null,7.0000000000000007E-2,null,{"$f":"H27*J27*0.75","v":6091.2496968750002},30.456248484374999]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L27)","v":238138.857196875},1190.694285984375]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L11-L28","v":2431.1428031250252},{"$f":"L30/$M$3","v":12.155714015625126}]

{"sheet":"Monthly Flows","index":1,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[23,2,23,3]]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"EBB-ST1-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":240570.00000000003},null,null,null,{"$f":"'ST1-Budget'!L9","v":240570.00000000003}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D7)","v":0},0,0,0,0,0,0,0,240570.00000000003,0,0,0,{"$f":"'ST1-Budget'!L11","v":240570.00000000003}]
[]
[]
[null,"Operating Inputs:"]
[null,null,"Purchased Steers",{"$f":"P12","v":165000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ST1-Budget'!L14","v":165000}]
[null,null,"Alfalfa Hay",{"$f":"P13*0.2","v":2820},{"$f":"P13*0.4","v":5640},{"$f":"P13*0.4","v":5640},null,null,null,null,null,null,null,null,null,{"$f":"'ST1-Budget'!L15","v":14100}]
[null,null,"Feed Barley",{"$f":"P14*0.2","v":2145},{"$f":"P14*0.4","v":4290},{"$f":"P14*0.4","v":4290},null,null,null,null,null,null,null,null,null,{"$f":"'ST1-Budget'!L16","v":10725}]
[null,null,"Yardage",{"$f":"P15*0.2","v":1050},{"$f":"P15*0.4","v":2100},{"$f":"P15*0.4","v":2100},null,null,null,null,null,null,null,null,null,{"$f":"'ST1-Budget'!L17","v":5250}]
[null,null,"Private Range",null,null,null,{"$f":"P16*0.6666","v":3199.68},{"$f":"P16*0.3333","v":1599.84},null,null,null,null,null,null,null,{"$f":"'ST1-Budget'!L18","v":4800}]
[null,null,"Pasture",null,null,null,null,{"$f":"P17*0.1111","v":1999.8000000000002},{"$f":"P17*0.2222","v":3999.6000000000004},{"$f":"P17*0.2222","v":3999.6000000000004},{"$f":"P17*0.2222","v":3999.6000000000004},{"$f":"P17*0.2222","v":3999.6000000000004},null,null,null,{"$f":"'ST1-Budget'!L19","v":18000}]
[null,null,"Hauling",null,null,null,{"$f":"P18*0.5","v":1500},null,{"$f":"P18*0.5","v":1500},null,null,null,null,null,null,{"$f":"'ST1-Budget'!L20","v":3000}]
[null,null,"Veterinary",{"$f":"P19*0.5","v":656.25},null,{"$f":"P19*0.5","v":656.25},null,null,null,null,null,null,null,null,null,{"$f":"'ST1-Budget'!L21","v":1312.5}]
[null,null,"Hired Labor",{"$f":"0.5*P20","v":875},null,null,{"$f":"0.25*P20","v":437.5},null,{"$f":"0.25*P20","v":437.5},null,null,null,null,null,null,{"$f":"'ST1-Budget'!L22","v":1750}]
[null,null,"Salt/Mineral",null,null,null,{"$f":"$P$21*0.2","v":31.200000000000003},{"$f":"$P$21*0.2","v":31.200000000000003},31.200000000000003,31.200000000000003,31.200000000000003,null,null,null,null,{"$f":"'ST1-Budget'!L23","v":156}]
[null,null,"Marketing",null,null,null,null,null,null,null,null,{"$f":"P22","v":5954.107500000001},null,null,null,{"$f":"'ST1-Budget'!L24","v":5954.107500000001}]
[null,null,"Miscellaneous",null,{"$f":"$P$23*0.125","v":250},{"$f":"$P$23*0.125","v":250},250,250,250,250,250,250,null,null,null,{"$f":"'ST1-Budget'!L25","v":2000}]
[null,null,"Interest on Operating Capital",null,null,null,null,null,null,null,null,{"$f":"P24","v":6091.2496968750002},null,null,null,{"$f":"'ST1-Budget'!L27","v":6091.2496968750002}]
[]
[null,"Total Costs",null,{"$f":"SUM(D12:D23)","v":172546.25},12280,12936.25,5418.38,3880.84,6218.3,4280.8,4280.8,10203.7075,0,0,0,{"$f":"SUM(P12:P24)","v":238138.857196875}]
[]
[]
[null,"Net Returns",null,{"$f":"D8-D26","v":-172546.25},-12280,-12936.25,-5418.38,-3880.84,-6218.3,-4280.8,-4280.8,230366.29250000004,0,0,0,2431.1428031250252]
[]
[]
[]
[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",19,38,38]
[null,"Feed Barley",null,"cwt",165,330,330]
[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,1,null,null,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,1,null,null,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,1,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(F8:Q8)*$B$5*E8","v":200}]
["Implant",null,null,"head",1.55,1,null,null,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":1050}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/Hd",{"$f":"R10/B5","v":5.25}]