{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CC4-Budget","Monthly Flows","Investment","Vet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":33,"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":"CC4-Budget","index":0,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[[7,17,7,18],[49,2,49,3],[23,2,23,3],[22,2,22,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[42,2,42,3],[44,2,44,3],[32,2,32,3],[31,2,31,3],[26,2,26,3],[35,2,35,3],[34,2,34,3],[28,2,28,3],[27,2,27,3],[1,1,1,10],[2,1,2,10],[48,2,48,3],[3,2,3,5],[30,2,30,3],[29,2,29,3],[33,2,33,3],[16,2,16,3],[25,2,25,3],[24,2,24,3],[43,2,43,3],[17,2,17,3],[20,2,20,3],[19,2,19,3],[21,2,21,3],[18,2,18,3]]}
[]
[null,"Table 1:  Cow-Calf Budget, 500 Cow - 2021",null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC4-21"]
[null,"Summer on Federal & State Range, Winter Feeding Necessary",null,null,null,null,null,null,null,null,null,"No. of Cows:",500]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES"]
[null,null,"Steer Calves",590,null,"lbs",null,220,null,1.78,null,{"$f":"D9*H9*J9","v":231044},{"$f":"L9/$M$3","v":462.08800000000002},null,null,null,null,500,"Cows"]
[null,null,"Heifer Calves",550,null,"lbs",null,125,null,1.73,null,{"$f":"D10*H10*J10","v":118937.5},{"$f":"L10/$M$3","v":237.875},null,null,null,null,20,"Bulls"]
[null,null,"Cull Cows",1450,null,"lbs",null,75,null,0.67,null,{"$f":"D11*H11*J11","v":72862.5},{"$f":"L11/$M$3","v":145.72499999999999},null,null,null,null,10,"Horses"]
[null,null,"Cull Bulls",1800,null,"lbs",null,6,null,0.88,null,{"$f":"D12*H12*J12","v":9504},{"$f":"L12/$M$3","v":19.007999999999999},null,null,null,null,0.12,"Cow culling rate"]
[null,null,"Cull Replacement Heifers",1000,null,"lbs",null,10,null,1.1200000000000001,null,{"$f":"D13*H13*J13","v":11200.000000000002},{"$f":"L13/$M$3","v":22.400000000000002},null,null,null,null,0.02,"Cow death loss"]
[null,null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L13)","v":443548},{"$f":"SUM(M9:M13)","v":887.096},null,null,null,null,0.91,"Calf crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,"Heifer culling rate"]
[null,null,"OPERATING COSTS"]
[null,null,"Alfalfa Hay",null,null,"ton",null,{"$f":"1107*0.25","v":276.75},null,180.25,null,{"$f":"H17*J17","v":49884.1875},{"$f":"L17/$M$3","v":99.768375000000006}]
[null,null,"Grass Hay",null,null,"ton",null,{"$f":"1107*0.75","v":830.25},null,145,null,{"$f":"H18*J18","v":120386.25},{"$f":"L18/$M$3","v":240.77250000000001}]
[null,null,"Corn Silage",null,null,"ton",null,18,null,50,null,{"$f":"H19*J19","v":900},{"$f":"L19/$M$3","v":1.8}]
[null,null,"Protein Supplement",null,null,"cwt",null,459,null,34,null,{"$f":"H20*J20","v":15606},{"$f":"L20/$M$3","v":31.212}]
[null,null,"Federal Range",null,null,"AUM",null,2592,null,1.41,null,3654.72,7.3094399999999995]
[null,null,"State Range",null,null,"AUM",null,379,null,8.02,null,3039.58,6.0791599999999999]
[null,null,"Private Range",null,null,"AUM",null,1030,null,21.67,null,{"$f":"H23*J23","v":22320.100000000002},44.640200000000007]
[null,null,"Crop Aftermath",null,null,"AUM",null,924,null,{"$f":"17*1.0833","v":18.4161},null,17016.4764,34.032952799999997]
[null,null,"Salt/Mineral",null,null,"cwt",null,108,null,11,null,1188,2.3759999999999999]
[null,null,"Veterinary/Medicine",null,null,"$",null,1,null,{"$f":"Vet!V35","v":13058.694492187498},null,{"$f":"H26*J26","v":13058.694492187498},26.117388984374998]
[null,null,"Freight/Trucking",null,null,"head",null,{"$f":"SUM(H11:H13)+95","v":186},null,13.75,null,2557.5,5.1150000000000002]
[null,null,"Commission",null,null,"head",null,{"$f":"SUM(H11:H13)","v":91},null,{"$f":"(0.03)*(L13+L12+L11)/H28","v":30.846098901098898},null,{"$f":"H28*J28","v":2806.9949999999999},{"$f":"L28/$M$3","v":5.6139899999999994}]
[null,null,"Checkoff/Brand Inspection",null,null,"head",null,438,null,2.96,null,{"$f":"H29*J29","v":1296.48},{"$f":"L29/$M$3","v":2.5929600000000002}]
[null,null,"Hired Labor",null,null,"hour",null,2730,null,18.190000000000001,null,{"$f":"H30*J30","v":49658.700000000004},{"$f":"L30/$M$3","v":99.317400000000006}]
[null,null,"Owner Labor",null,null,"hour",null,1540,null,31.12,null,{"$f":"H31*J31","v":47924.800000000003},{"$f":"L31/$M$3","v":95.849600000000009}]
[null,null,"Machinery (Fuel, Oil, Repair)",null,null,"$",null,1,null,{"$f":"2700*(1+42.89%)","v":3858.03},null,3858.03,7.7160600000000006]
[null,null,"Vehicles (Fuel, Repair)",null,null,"$",null,1,null,{"$f":"8600*(1+43.23%)","v":12317.779999999999},null,12317.779999999999,24.635559999999998]
[null,null,"Equipment (Repair)",null,null,"$",null,1,null,{"$f":"945*(1+6.37%)","v":1005.1965000000001},null,{"$f":"H34*J34","v":1005.1965000000001},2.0103930000000001]
[null,null,"Buildings & Improvements (Repair)",null,null,"$",null,1,null,{"$f":"6300*(1+6.37%)","v":6701.31},null,6701.31,13.402620000000001]
[null,null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(L17:L35)*0.25","v":93795.199973046896},null,0.05,null,4689.7599986523446,9.3795199973046888]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L17:L36)","v":379870.55989083991},759.7411197816798]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L14-L37","v":63677.440109160088},{"$f":"L39/$M$3","v":127.35488021832018}]
[]
[null,null,"OWNERSHIP COSTS"]
[null,null,"Capital Recovery:"]
[null,null,"     Purchased Livestock ",null,null,"$",null,1,null,{"$f":"Investment!I28","v":5313},null,{"$f":"H43*J43","v":5313},{"$f":"L43/$M$3","v":10.625999999999999}]
[null,null,"     Housing & Improvements",null,null,"$",null,1,null,{"$f":"Investment!I21-Investment!I19-Investment!I18-Investment!I17-Investment!I16-Investment!I15","v":19544},null,{"$f":"H44*J44","v":19544},{"$f":"L44/$M$3","v":39.088000000000001}]
[null,null,"     Machinery",null,null,"$",null,1,null,{"$f":"Investment!I39","v":2709},null,2709,{"$f":"L45/$M$3","v":5.4180000000000001}]
[null,null,"     Equipment",null,null,"$",null,1,null,{"$f":"Investment!I15+Investment!I16+Investment!I17+Investment!I18+Investment!I19","v":1572.5},null,1572.5,3.145]
[null,null,"     Vehicles",null,null,"$",null,1,null,{"$f":"Investment!I42+Investment!I43","v":6720},null,6720,13.44]
[null,null,"Interest on Retained Livestock",null,null,"$",null,{"$f":"Investment!D35","v":864000},null,5.0599999999999999E-2,null,43718.400000000001,87.436800000000005]
[null,null,"Taxes & Insurance",null,null,"$",null,1,null,{"$f":"Investment!H45+Investment!H21","v":1778.4},null,1778.4,3.5568]
[null,null,"General Overhead",null,null,"$",null,1,null,7000,null,7000,14]
[null,null,"TOTAL OWNERSHIP COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L43:L50)","v":88355.299999999988},176.71059999999997]
[]
[null,null,"TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+L37+L51","v":468225.8598908399},{"$f":"L53/$M$3","v":936.4517197816798}]
[]
[null,null,"NET RETURNS ABOVE TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+L14-L53","v":-24677.8598908399},{"$f":"L55/$M$3","v":-49.355719781679802}]

{"sheet":"Monthly Flows","index":1,"n_rows":87,"n_cols":16,"rows_kept":87,"cut":false,"hidden":false,"merged":[[86,3,86,4],[78,7,80,7],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[86,5,86,6],[78,8,80,8],[77,2,77,8],[78,2,80,2],[78,3,80,4],[85,3,85,4],[78,5,80,6],[81,5,81,6],[82,5,82,6],[83,5,83,6],[84,5,84,6],[85,5,85,6]]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC4-21"]
[null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Value"]
[]
[null,"Production:"]
[null,null,"Steer Calves",null,null,null,null,null,null,null,null,null,null,{"$f":"P6","v":231044},null,{"$f":"'CC4-Budget'!L9","v":231044}]
[null,null,"Heifer Calves",null,null,null,null,null,null,null,null,null,{"$f":"P7","v":118937.5},null,null,{"$f":"'CC4-Budget'!L10","v":118937.5}]
[null,null,"Cull Cows",{"$f":"P8","v":72862.5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CC4-Budget'!L11","v":72862.5}]
[null,null,"Cull Bulls",null,null,null,null,null,null,null,null,null,{"$f":"P9","v":9504},null,null,{"$f":"'CC4-Budget'!L12","v":9504}]
[null,null,"Cull Replacement Heifers",{"$f":"P10","v":11200.000000000002},null,null,null,null,null,null,null,null,null,{"$f":"P10","v":11200.000000000002},null,{"$f":"'CC4-Budget'!L13","v":11200.000000000002}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D10)","v":84062.5},{"$f":"SUM(E6:E10)","v":0},0,0,0,0,0,0,0,128441.5,242244,0,{"$f":"'CC4-Budget'!L14","v":443548}]
[]
[]
[null,"Operating Inputs:"]
[null,null,{"$f":"'CC4-Budget'!C17:D17","v":"Alfalfa Hay"},{"$f":"0.26*P16","v":12969.88875},{"$f":"0.24*P16","v":11972.205},{"$f":"0.26*P16","v":12969.88875},{"$f":"0.12*P16","v":5986.1025},null,null,null,null,null,null,null,{"$f":"0.12*P16","v":5986.1025},{"$f":"'CC4-Budget'!L17","v":49884.1875}]
[null,null,{"$f":"'CC4-Budget'!C18:D18","v":"Grass Hay"},{"$f":"0.26*P17","v":31300.424999999999},{"$f":"0.27*P17","v":32504.287500000002},{"$f":"0.24*P17","v":28892.7},{"$f":"0.12*P17","v":14446.35},null,null,null,null,null,null,null,{"$f":"0.11*P17","v":13242.487499999999},{"$f":"'CC4-Budget'!L18","v":120386.25}]
[null,null,{"$f":"'CC4-Budget'!C19:D19","v":"Corn Silage"},null,null,{"$f":"P18*0.6666666","v":599.99994000000004},{"$f":"P18*0.333333","v":299.99970000000002},null,null,null,null,null,null,null,null,{"$f":"'CC4-Budget'!L19","v":900}]
[null,null,{"$f":"'CC4-Budget'!C20:D20","v":"Protein Supplement"},{"$f":"$P$19/5","v":3121.2},3121.2,3121.2,3121.2,null,null,null,null,null,null,null,{"$f":"$P$19/5","v":3121.2},{"$f":"'CC4-Budget'!L20","v":15606}]
[null,null,{"$f":"'CC4-Budget'!C21:D21","v":"Federal Range"},null,{"$f":"0.12*P20","v":438.56639999999999},{"$f":"0.22*$P$20","v":804.03839999999991},{"$f":"0.22*$P$20","v":804.03839999999991},804.03839999999991,804.03839999999991,null,null,null,null,null,null,{"$f":"'CC4-Budget'!L21","v":3654.72}]
[null,null,{"$f":"'CC4-Budget'!C22:D22","v":"State Range"},null,null,null,{"$f":"0.04*P21","v":121.58320000000001},{"$f":"0.08*$P$21","v":243.16640000000001},{"$f":"0.08*$P$21","v":243.16640000000001},243.16640000000001,243.16640000000001,{"$f":"0.32*P21","v":972.66560000000004},{"$f":"0.32*P21","v":972.66560000000004},null,null,{"$f":"'CC4-Budget'!L22","v":3039.58}]
[null,null,{"$f":"'CC4-Budget'!C23:D23","v":"Private Range"},null,null,null,null,{"$f":"0.01*$P$22","v":223.20100000000002},{"$f":"0.01*$P$22","v":223.20100000000002},223.20100000000002,223.20100000000002,{"$f":"0.48*P22","v":10713.648000000001},{"$f":"0.48*P22","v":10713.648000000001},null,null,{"$f":"'CC4-Budget'!L23","v":22320.100000000002}]
[null,null,{"$f":"'CC4-Budget'!C24:D24","v":"Crop Aftermath"},null,null,null,null,null,null,null,null,null,null,{"$f":"P23*0.6666666","v":11344.316465568239},{"$f":"P23*0.3333333","v":5672.1582327841197},{"$f":"'CC4-Budget'!L24","v":17016.4764}]
[null,null,{"$f":"'CC4-Budget'!C25:D25","v":"Salt/Mineral"},{"$f":"$P$24/12","v":99},{"$f":"$P$24/12","v":99},99,99,99,99,99,99,99,99,99,99,{"$f":"'CC4-Budget'!L25","v":1188}]
[null,null,{"$f":"'CC4-Budget'!C26:D26","v":"Veterinary/Medicine"},null,{"$f":"0.2*P25","v":2611.7388984374998},{"$f":"0.2*P25","v":2611.7388984374998},null,null,null,null,null,null,null,{"$f":"0.6*P25","v":7835.2166953124988},null,{"$f":"'CC4-Budget'!L26","v":13058.694492187498}]
[null,null,{"$f":"'CC4-Budget'!C27:D27","v":"Freight/Trucking"},{"$f":"0.48*P26","v":1227.5999999999999},null,null,null,null,null,null,null,null,null,{"$f":"0.52*P26","v":1329.9},null,{"$f":"'CC4-Budget'!L27","v":2557.5}]
[null,null,{"$f":"'CC4-Budget'!C28:D28","v":"Commission"},{"$f":"0.93*P27","v":2610.5053499999999},null,null,null,null,null,null,null,null,null,null,{"$f":"0.07*P27","v":196.48965000000001},{"$f":"'CC4-Budget'!L28","v":2806.9949999999999}]
[null,null,{"$f":"'CC4-Budget'!C29:D29","v":"Checkoff/Brand Inspection"},{"$f":"0.2*P28","v":259.29599999999999},null,null,null,null,null,null,null,null,{"$f":"0.8*P28","v":1037.184},null,null,{"$f":"'CC4-Budget'!L29","v":1296.48}]
[null,null,{"$f":"'CC4-Budget'!C30:D30","v":"Hired Labor"},{"$f":"0.1*P29","v":4965.8700000000008},{"$f":"0.18*P29","v":8938.5660000000007},{"$f":"0.18*P29","v":8938.5660000000007},{"$f":"0.06*$P$29","v":2979.5219999999999},2979.5219999999999,2979.5219999999999,2979.5219999999999,2979.5219999999999,2979.5219999999999,2979.5219999999999,2979.5219999999999,2979.5219999999999,{"$f":"'CC4-Budget'!L30","v":49658.700000000004}]
[null,null,{"$f":"'CC4-Budget'!C31:D31","v":"Owner Labor"},{"$f":"$P$30/12","v":3993.7333333333336},3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,3993.7333333333336,{"$f":"$P$30/12","v":3993.7333333333336},{"$f":"'CC4-Budget'!L31","v":47924.800000000003}]
[null,null,{"$f":"'CC4-Budget'!C32:D32","v":"Machinery (Fuel, Oil, Repair)"},{"$f":"$P$26/12","v":213.125},{"$f":"$P$26/12","v":213.125},213.125,213.125,213.125,213.125,213.125,213.125,213.125,213.125,213.125,213.125,{"$f":"'CC4-Budget'!L32","v":3858.03}]
[null,null,{"$f":"'CC4-Budget'!C33:D33","v":"Vehicles (Fuel, Repair)"},{"$f":"$P$31/12","v":321.5025},{"$f":"$P$31/12","v":321.5025},321.5025,321.5025,321.5025,321.5025,321.5025,321.5025,321.5025,321.5025,321.5025,321.5025,{"$f":"'CC4-Budget'!L33","v":12317.779999999999}]
[null,null,{"$f":"'CC4-Budget'!C34:D34","v":"Equipment (Repair)"},{"$f":"$P$32/12","v":1026.4816666666666},{"$f":"$P$32/12","v":1026.4816666666666},1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,1026.4816666666666,{"$f":"'CC4-Budget'!L34","v":1005.1965000000001}]
[null,null,{"$f":"'CC4-Budget'!C35:D35","v":"Buildings & Improvements (Repair)"},{"$f":"$P$34/12","v":558.4425},{"$f":"$P$34/12","v":558.4425},558.4425,558.4425,558.4425,558.4425,558.4425,558.4425,558.4425,558.4425,558.4425,558.4425,{"$f":"'CC4-Budget'!L35","v":6701.31}]
[null,null,{"$f":"'CC4-Budget'!C36:D36","v":"Interest on Operating Capital"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P35","v":4689.7599986523446},{"$f":"'CC4-Budget'!L36","v":4689.7599986523446}]
[]
[null,"Total Costs",null,{"$f":"SUM(D16:D35)","v":62667.070099999997},65798.848798437495,64150.416988437501,33971.080800000003,10462.212799999999,10462.212799999999,9658.1743999999981,9658.1743999999981,20878.120600000002,21915.304599999999,29701.240160880741,42100.004881436464,{"$f":"SUM(P16:P35)","v":379870.55989083991}]
[]
[]
[null,"Net Returns",null,{"$f":"D12-D37","v":21395.429900000003},-65798.848798437495,-64150.416988437501,-33971.080800000003,-10462.212799999999,-10462.212799999999,-9658.1743999999981,-9658.1743999999981,-20878.120600000002,106526.1954,212542.75983911927,-42100.004881436464,63677.440109160088]
[]
[]
[]
[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,null,"Replacement Heifers","ton",29,29,29,14,null,null,null,null,null,null,null,14]
[null,"Grass Hay"]
[null,null,"Cows","ton",194,194,194,94,null,null,null,null,null,null,null,94]
[null,null,"Bulls","ton",14,14,null,null,null,null,null,null,null,null,null,7]
[null,null,"Horses","ton",4,4,4,2,null,null,null,null,null,null,null,4]
[null,"Corn Silage"]
[null,null,"Bulls","ton",null,null,38,19]
[null,"Federal Range"]
[null,null,"Cows","AUM",null,null,null,235,470,470,470,470]
[null,null,"Replacement Heifers","AUM",null,null,null,38,76,76,76,76]
[null,null,"Bulls","AUM",null,null,null,15,30,30,30,30]
[null,null,"Horses","AUM"]
[null,"State Range"]
[null,null,"Cows","AUM",null,null,null,15,30,30,30,30,100,100]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,15,15]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,6,6]
[null,"Private Range"]
[null,null,"Cows","AUM",null,null,null,null,null,null,null,null,400,400]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,61,61]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,24,24]
[null,null,"Horses","AUM",null,null,null,null,10,10,10,10,10,10]
[null,"Crop Aftermath"]
[null,null,"Cows","AUM",null,null,null,null,null,null,null,null,null,null,500,250]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,null,null,76,38]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,null,null,30,15]
[null,null,"Horses","AUM",null,null,null,null,null,null,null,null,null,null,10,5]
[null,"Salt/Mineral",null,"cwt",9,9,9,9,9,9,9,9,9,9,9,9]
[]
[]
[]
[null,null,"Daily Feed Requirements                                                                                                                 by Livestock Category (lb fed/head/day)"]
[null,null,"Livestock Category","Alfalfa or Grass Hay (lb)",null,"Protein Supplement      (lb)",null,"Silage (lbs)","No. of Days"]
[]
[]
[null,null,"Replacement Heifers",20,null,null,null,null,105]
[null,null,"Replacement Heifers",null,null,3,null,null,180]
[null,null,"Cows",30,null,null,null,null,120]
[null,null,"Bulls",36,null,null,null,null,75]
[null,null,"Bulls",20,null,null,null,30,60]
[null,null,"Horses",25,null,null,null,null,120]

{"sheet":"Investment","index":2,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 4:  Investment Summary. ",null,null,null,null,null,null,"CCB-CC4-21"]
[null,null,null,"Total Value","Salvage/Cull Value","Livestock Share","Useful Life","Annual Taxes & Insurance","Annual Capital Recovery",1]
[]
[null,"Buildings, Improvements",null,null,null,null,null,null,null,null,"Interest/Discount Rate"]
[null,"and Equipment",null,null,null,null,null,null,null,null,5.0599999999999999E-2]
[null,null,"Fencing",74000,0,100,25,{"$f":"D7*0.0036","v":266.39999999999998},{"$f":"(D7-E7)*0.071","v":5253.9999999999991}]
[null,null,"Working Corrals & Pens",20000,3000,100,30,72,{"$f":"(D8-E8)*0.065","v":1105}]
[null,null,"Barn",20000,3000,100,30,72,{"$f":"(D9-E9)*0.065","v":1105}]
[null,null,"Hay Shed",30000,5000,100,40,108,{"$f":"(D10-E10)*0.059","v":1475}]
[null,null,"Calving Shed",35000,4000,100,30,126,{"$f":"(D11-E11)*0.065","v":2015}]
[null,null,"Water Developments",45000,0,100,25,162,{"$f":"(D12-E12)*0.071","v":3194.9999999999995}]
[null,null,"Range Improvements",40000,0,100,10,144,{"$f":"(D13-E13)*0.13","v":5200}]
[null,null,"Feed Wagon",2000,500,100,10,7.2,{"$f":"(D14-E14)*0.13","v":195}]
[null,null,"Calf Table",1500,500,100,10,5.3999999999999995,{"$f":"(D15-E15)*0.13","v":130}]
[null,null,"Squeeze Chute",3500,1000,100,10,12.6,{"$f":"(D16-E16)*0.13","v":325}]
[null,null,"Vet Equipment",1500,0,100,15,5.3999999999999995,{"$f":"(D17-E17)*0.097","v":145.5}]
[null,null,"Stock Trailer",5000,1000,100,20,18,{"$f":"(D18-E18)*0.081","v":324}]
[null,null,"Gooseneck Trailer",12000,4000,100,20,43.199999999999996,{"$f":"(D19-E19)*0.081","v":648}]
[]
[null,"Total",null,{"$f":"SUM(D7:D19)","v":289500},null,null,null,{"$f":"SUM(H7:H19)","v":1042.2},{"$f":"SUM(I7:I19)","v":21116.5}]
[]
[]
[null,"Purchased Livestock"]
[null,null,"Horses",{"$f":"2500*10","v":25000},{"$f":"600*10","v":6000},100,10,null,{"$f":"D25*K6","v":1265},2]
[null,null,"Bulls",{"$f":"20*4000","v":80000},{"$f":"'CC4-Budget'!D12*'CC4-Budget'!J12*20","v":31680},100,4,null,{"$f":"D26*K6","v":4048},2]
[]
[null,"Total",null,{"$f":"SUM(D25:D26)","v":105000},null,null,null,null,{"$f":"SUM(I25:I26)","v":5313}]
[]
[]
[null,"Retained Livestock"]
[null,null,"Beef Replacement Heifers",{"$f":"1200*95","v":114000},{"$f":"95*'CC4-Budget'!D13*'CC4-Budget'!J13","v":106400.00000000001},100,null,null,{"$f":"D32*$K$6","v":5768.4}]
[null,null,"Beef Cows",{"$f":"500*1500","v":750000},{"$f":"500*'CC4-Budget'!D11*'CC4-Budget'!J11","v":485750},100,null,null,{"$f":"D33*$K$6","v":37950}]
[]
[null,"Total",null,{"$f":"SUM(D32:D33)","v":864000},null,null,null,null,{"$f":"SUM(I32:I33)","v":43718.400000000001}]
[]
[]
[null,"Machinery and Vehicles"]
[null,null,"Tractor Loader",40000,8500,100,18,{"$f":"D39*0.0036","v":144},{"$f":"(D39-E39)*0.086","v":2709}]
[null,null,"Tractor 80 hp",35000,7000,100,18,{"$f":"D40*0.0036","v":126},{"$f":"(D40-E40)*0.086","v":2408}]
[null,null,"Pickup 1/2 ton",12000,2500,100,6,{"$f":"D41*0.0036","v":43.199999999999996},{"$f":"(D41-E41)*0.197","v":1871.5}]
[null,null,"Pickup 4X4 3/4 ton",20000,5000,100,5,{"$f":"D42*0.0094","v":188},{"$f":"(D42-E42)*0.231","v":3465}]
[null,null,"Pickup 4X4 1 ton",25000,4000,100,8,{"$f":"D43*0.0094","v":235},{"$f":"(D43-E43)*0.155","v":3255}]
[]
[null,"Total",null,{"$f":"SUM(D39:D43)","v":132000},null,null,null,{"$f":"SUM(H39:H43)","v":736.2},{"$f":"SUM(I39:I43)","v":13708.5}]
[]
[]
[null,1,"Annual capital recovery is the method of calculating depreciation and interest recommended by the National Task Force"]
[null,null,"on Commodity Costs and Returns Measurement Methods."]
[null,2,"Interest on average investment."]

{"sheet":"Vet","index":3,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,9,4,20]]}
[]
[]
[null,null,"Veterinary Expenses"]
[]
[null,null,null,null,null,null,null,null,null,"Monthly Allocation"]
["Vaccine",null,null,"Number of Head","Dosage","Price",null,"Units","$/Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
[null,null,"Steer Calves",{"$f":"'CC4-Budget'!H9","v":220}]
["Inforce 3",null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",{"$f":"F8/E8","v":1.5497999999999998},null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J8:U8)*I8*$D$7","v":681.91199999999992}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",{"$f":"F9/E9","v":0.8458},null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J9:U9)*I9*$D$7","v":372.15199999999999}]
["Ralgro",null,"Implant",null,24,40.49,null,"dose",1.6870833333333335,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:U10)*I10*$D$7","v":371.15833333333336}]
[null,null,"Heifer Calves",{"$f":"'CC4-Budget'!H10","v":125}]
["Inforce 3",null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",1.5497999999999998,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J12:U12)*I12*$D$11","v":387.45}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",0.8458,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J13:U13)*I13*$D$11","v":211.45}]
[null,null,"Bangs",null,1,4,null,"dose",4,null,null,null,null,null,null,null,null,null,null,1,null,500]
[null,null,"Cows",{"$f":"'CC4-Budget'!M3","v":500}]
["Pyramid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J16:U16)*I16*$D$15","v":652.90000000000009}]
["Vira Shield 6 + VL5",null,"Pregnancy Viral",null,50,127.29,null,"dose",2.5458000000000003,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J17:U17)*I17*$D$15","v":1272.9000000000001}]
["Clean-Up 2",null,"Pour-On",null,384,432.5,null,"dose",1.1263020833333333,null,null,1," ",null,null,null,null,null,null,null,null,{"$f":"SUM(J18:U18)*I18*$D$15","v":563.15104166666663}]
["PYthon2",null,"Fly Tags",null,100,197.39,null,"head",1.9738999999999998,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:U19)*I19*$D$15","v":986.94999999999993}]
[null,null,"Preg. Check",null,1,4,null,"head",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J20:U20)*I20*$D$15","v":2000}]
[null,null,"Replacement Heifers",85]
["Pyramid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,null,1,null,null,null,null,null,null,1,null,{"$f":"SUM(J22:U22)*I22*$D$21","v":221.98600000000002}]
["Vira Shield 6 + VL5",null,"Pregnancy Viral",null,50,127.29,null,"dose",2.5458000000000003,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(J23:U23)*I23*$D$21","v":216.39300000000003}]
["Clean-Up 2",null,"Pour-On",null,384,432.5,null,"dose",1.1263020833333333,null,null,null,null,null,null,null,null,null,null,1,null,95.735677083333329]
["Python 2",null,"Fly Tags",null,100,197.39,null,"head",1.9738999999999998,null,null,null,1,null,null,null,null,null,null,null,null,167.78149999999999]
[null,null,"Preg. Check",null,1,4,null,"head",4,null,null,null,null,null,null,null,null,null,null,1,null,340]
[null,null,"Bulls",{"$f":"'CC4-Budget'!R10","v":20}]
["Pyramid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(J28:U28)*I28*$D$27","v":26.116}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",0.8458,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J29:U29)*I29*$D$27","v":16.916}]
["Clean-Up 2",null,"Pour-On",null,384,432.5,null,"dose",1.1263020833333333,null,null,null,1,null,null,null,null,null,null,null,null,22.526041666666664]
[null,null,"Semen/Trich Test",null,1,65,null,"head",65,null,null,null,1,null,null,null,null,null,null,null,null,1300]
["Python 2",null,"Fly Tags",null,100,197.39,null,"head",1.9738999999999998,null,null,null,1,null,null,null,null,null,null,null,null,39.477999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(V8:V32)","v":10446.955593749999}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V33*1.25","v":13058.694492187498}]