{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ST2-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":"ST2-Budget","index":0,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,2,20,3],[22,2,22,3],[21,2,21,3],[1,1,1,10],[2,1,2,10],[3,2,3,5],[18,2,18,3],[17,2,17,3],[14,2,14,3],[16,2,16,3],[15,2,15,3],[19,2,19,3]]}
[]
[null,"Table 1:  Stocker Budget, 200 Head - 2020 ",null,null,null,null,null,null,null,null,null,null,null,null,"EBB-ST2-20"]
[null,"Wintered to Go to Feedlot, Bought in Fall & Sold in Spring",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",725,null,"lbs",null,198,null,1.55,null,{"$f":"D9*H9*J9","v":222502.5},{"$f":"L9/$M$3","v":1112.5125}]
[]
[null,null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L10)","v":222502.5},{"$f":"SUM(M9:M10)","v":1112.5125}]
[]
[null,null,"OPERATING COSTS"]
[null,null,"Purchased Steers",425,null,"lbs",null,200,null,1.7,null,{"$f":"D14*H14*J14","v":144500},{"$f":"L14/$M$3","v":722.5}]
[null,null,"Alfalfa Hay",null,null,"ton",null,176,null,150,null,{"$f":"H15*J15","v":26400},{"$f":"L15/$M$3","v":132}]
[null,null,"Feed Barley",null,null,"cwt",null,1890,null,13,null,{"$f":"H16*J16","v":24570},{"$f":"L16/$M$3","v":122.85}]
[null,null,"Yardage",null,null,"day",null,30000,null,0.35,null,10500,52.5]
[null,null,"Veterinary",null,null,"head",null,200,null,{"$f":"Vet!R12*1.25","v":5.9375},null,{"$f":"H18*J18","v":1187.5},5.9375]
[null,null,"Hired Labor",null,null,"hour",null,20,null,17.5,null,{"$f":"H19*J19","v":350},1.75]
[null,null,"Marketing",null,null,"head",null,198,null,{"$f":"M9*0.025","v":27.812812500000003},null,5506.9368750000003,27.534684375000001]
[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:L22)*0.5","v":107507.21843750001},null,7.0000000000000007E-2,null,{"$f":"H23*J23","v":7525.5052906250012},37.627526453125007]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L23)","v":222539.94216562502},1112.699710828125]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L11-L24","v":-37.442165625019697},{"$f":"L26/$M$3","v":-0.18721082812509848}]

{"sheet":"Monthly Flows","index":1,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[19,2,19,3]]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"EBB-ST2-20"]
[null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Value"]
[]
[null,"Production:"]
[null,null,"Steers",null,null,{"$f":"P6","v":222502.5},null,null,null,null,null,null,null,null,null,{"$f":"'ST2-Budget'!L9","v":222502.5}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D7)","v":0},0,222502.5,0,0,0,0,0,0,0,0,0,{"$f":"'ST2-Budget'!L11","v":222502.5}]
[]
[]
[null,"Operating Inputs:"]
[null,null,"Purchased Steers",null,null,null,null,null,null,null,null,null,null,{"$f":"P12","v":144500},null,{"$f":"'ST2-Budget'!L14","v":144500}]
[null,null,"Alfalfa Hay",{"$f":"P13*0.25","v":6600},{"$f":"P13*0.25","v":6600},null,null,null,null,null,null,null,null,{"$f":"P13*0.25","v":6600},{"$f":"P13*0.25","v":6600},{"$f":"'ST2-Budget'!L15","v":26400}]
[null,null,"Feed Barley",{"$f":"P14*0.25","v":6142.5},{"$f":"P14*0.25","v":6142.5},null,null,null,null,null,null,null,null,{"$f":"P14*0.25","v":6142.5},{"$f":"P14*0.25","v":6142.5},{"$f":"'ST2-Budget'!L16","v":24570}]
[null,null,"Yardage",{"$f":"P15*0.25","v":2625},{"$f":"P15*0.25","v":2625},null,null,null,null,null,null,null,null,{"$f":"P15*0.25","v":2625},{"$f":"P15*0.25","v":2625},{"$f":"'ST2-Budget'!L17","v":10500}]
[null,null,"Veterinary",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ST2-Budget'!L18","v":1187.5}]
[null,null,"Hired Labor",null,null,null,null,null,null,null,null,null,null,{"$f":"P17","v":350},null,{"$f":"'ST2-Budget'!L19","v":350}]
[null,null,"Marketing",null,null,{"$f":"P18","v":5506.9368750000003},null,null,null,null,null,null,null,null,null,{"$f":"'ST2-Budget'!L20","v":5506.9368750000003}]
[null,null,"Miscellaneous",{"$f":"P19*0.2","v":400},{"$f":"P19*0.2","v":400},{"$f":"P19*0.2","v":400},null,null,null,null,null,null,null,{"$f":"P19*0.2","v":400},{"$f":"P19*0.2","v":400},{"$f":"'ST2-Budget'!L21","v":2000}]
[null,null,"Interest on Operating Capital",null,null,{"$f":"P20","v":7525.5052906250012},null,null,null,null,null,null,null,null,null,{"$f":"'ST2-Budget'!L23","v":7525.5052906250012}]
[]
[null,"Total Costs",null,{"$f":"SUM(D12:D19)","v":15767.5},15767.5,5906.9368750000003,0,0,0,0,0,0,0,160617.5,15767.5,{"$f":"SUM(P12:P20)","v":222539.94216562502}]
[]
[]
[null,"Net Returns",null,{"$f":"D8-D22","v":-15767.5},-15767.5,216595.56312499999,0,0,0,0,0,0,0,-160617.5,-15767.5,-37.442165625019697]
[]
[]
[]
[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",35,35,35,null,null,null,null,null,null,null,35,35]
[null,"Feed Barley",null,"cwt",378,378,378,null,null,null,null,null,null,null,378,378]

{"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,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(F6:Q6)*$B$5*E6","v":360}]
["8 Way",null,null,"dose",0.9,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(F7:Q7)*$B$5*E7","v":180}]
["Pour-On",null,null,"dose",0.5,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(F8:Q8)*$B$5*E8","v":100}]
["Implant",null,null,"head",1.55,null,null,null,null,null,null,null,null,null,null,1,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}]