{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CC6-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":"CC6-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],[19,2,19,3],[18,2,18,3],[20,2,20,3],[21,2,21,3]]}
[]
[null,"Table 1:  Cow-Calf Budget - Eastern Idaho, 250 Cow - 2021",null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC6-21"]
[null,"Summer on Federal & State Range, Winter Feeding Necessary",null,null,null,null,null,null,null,null,null,"No. of Cows:",250]
[]
[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",550,null,"lbs",null,110,null,1.67,null,{"$f":"D9*H9*J9","v":101035},{"$f":"L9/$M$3","v":404.14},null,null,null,null,250,"Cows"]
[null,null,"Heifer Calves",525,null,"lbs",null,76,null,1.62,null,{"$f":"D10*H10*J10","v":64638.000000000007},{"$f":"L10/$M$3","v":258.55200000000002},null,null,null,null,10,"Bulls"]
[null,null,"Cull Cows",1300,null,"lbs",null,25,null,0.67,null,{"$f":"D11*H11*J11","v":21775},{"$f":"L11/$M$3","v":87.1},null,null,null,null,4,"Horses"]
[null,null,"Cull Bulls",1800,null,"lbs",null,3,null,0.88,null,{"$f":"D12*H12*J12","v":4752},{"$f":"L12/$M$3","v":19.007999999999999},null,null,null,null,0.1,"Cow culling rate"]
[null,null,"Cull Replacement Heifers",850,null,"lbs",null,4,null,1.1200000000000001,null,{"$f":"D13*H13*J13","v":3808.0000000000005},{"$f":"L13/$M$3","v":15.232000000000001},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":196008},{"$f":"SUM(M9:M13)","v":784.03200000000004},null,null,null,null,0.9,"Calf crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11600000000000001,"Heifer culling rate"]
[null,null,"OPERATING COSTS"]
[null,null,"Alfalfa Hay",null,null,"ton",null,65,null,180.25,null,{"$f":"H17*J17","v":11716.25},{"$f":"L17/$M$3","v":46.865000000000002}]
[null,null,"Alfalfa/Grass Hay",null,null,"ton",null,635,null,145,null,92075,{"$f":"L18/$M$3","v":368.3}]
[null,null,"Protein Supplement",null,null,"cwt",null,450,null,34,null,15300,{"$f":"L19/$M$3","v":61.2}]
[null,null,"Federal Range",null,null,"AUM",null,1020,null,1.35,null,1377,{"$f":"L20/$M$3","v":5.508}]
[null,null,"State Range",null,null,"AUM",null,500,null,7.32,null,3660,{"$f":"L21/$M$3","v":14.64}]
[null,null,"Grazing Association Fees",null,null,"AUM",null,303,null,25,null,7575,{"$f":"L22/$M$3","v":30.3}]
[null,null,"Private Range",null,null,"AUM",null,303,null,26,null,{"$f":"H23*J23","v":7878},31.512]
[null,null,"Crop Aftermath",null,null,"AUM",null,303,null,19.5,null,5908.5,23.634]
[null,null,"Salt/Mineral",null,null,"cwt",null,60,null,11,null,660,2.64]
[null,null,"Veterinary/Medicine",null,null,"$",null,1,null,{"$f":"Vet!V32","v":6689.1137656249985},null,{"$f":"H26*J26","v":6689.1137656249985},26.756455062499995]
[null,null,"Freight/Trucking to Pasture",null,null,"head",null,250,null,{"$f":"0.125*30","v":3.75},null,937.5,3.75]
[null,null,"Commission",null,null,"head",null,{"$f":"SUM(H11:H13)","v":32},null,{"$f":"(L11+L12+L13)*0.03/(H11+H12+H13)","v":28.439062499999999},null,{"$f":"H28*J28","v":910.05},{"$f":"L28/$M$3","v":3.6401999999999997}]
[null,null,"Checkoff/Brand Inspection",null,null,"head",null,{"$f":"SUM(H9:H13)","v":218},null,2.96,null,{"$f":"H29*J29","v":645.28},{"$f":"L29/$M$3","v":2.5811199999999999}]
[null,null,"Hired Labor",null,null,"hour",null,1250,null,18.190000000000001,null,22737.5,90.95]
[null,null,"Owner Labor",null,null,"hour",null,1000,null,31.12,null,31120,124.48]
[null,null,"Machinery (Fuel, Oil, Repair)",null,null,"$",null,1,null,{"$f":"3000*(1+42.89%)","v":4286.7},null,{"$f":"H32*J32","v":4286.7},{"$f":"L32/$M$3","v":17.146799999999999}]
[null,null,"Vehicles (Fuel, Repair)",null,null,"$",null,1,null,{"$f":"6800*(1+43.23%)","v":9739.64},null,{"$f":"H33*J33","v":9739.64},{"$f":"L33/$M$3","v":38.958559999999999}]
[null,null,"Equipment (Repair)",null,null,"$",null,1,null,{"$f":"975*(1+6.37%)","v":1037.1075000000001},null,{"$f":"H34*J34","v":1037.1075000000001},{"$f":"L34/$M$3","v":4.1484300000000003}]
[null,null,"Buildings & Improvements (Repair)",null,null,"$",null,1,null,{"$f":"270*(1+6.37%)","v":287.19900000000001},null,287.19900000000001,1.1487960000000002]
[null,null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(L17:L35)*0.25","v":56134.960066406245},null,0.05,null,2806.7480033203124,11.226992013281249]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L17:L36)","v":227346.58826894528},909.38635307578113]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L14-L37","v":-31338.588268945285},{"$f":"L39/$M$3","v":-125.35435307578113}]
[]
[null,null,"OWNERSHIP COSTS"]
[null,null,"Capital Recovery:"]
[null,null,"     Purchased Livestock ",null,null,"$",null,1,null,{"$f":"Investment!I26","v":7801.119999999999},null,{"$f":"H43*J43","v":7801.119999999999},{"$f":"L43/$M$3","v":31.204479999999997}]
[null,null,"     Buildings & Improvements",null,null,"$",null,1,null,{"$f":"Investment!I7+Investment!I8+Investment!I10+Investment!I11+Investment!I12","v":5970},null,{"$f":"H44*J44","v":5970},{"$f":"L44/$M$3","v":23.88}]
[null,null,"     Machinery",null,null,"$",null,1,null,{"$f":"Investment!I37","v":2709},null,2709,{"$f":"L45/$M$3","v":10.836}]
[null,null,"     Equipment",null,null,"$",null,1,null,{"$f":"Investment!I9+Investment!I13+Investment!I14+Investment!I15+Investment!I17+Investment!I16","v":2058.5},null,2058.5,8.234]
[null,null,"     Vehicles",null,null,"$",null,1,null,{"$f":"Investment!I38+Investment!I39+Investment!I40","v":5595},null,5595,22.38]
[null,null,"Interest on Retained Livestock",null,null,"$",null,{"$f":"Investment!D33","v":426600},null,5.0599999999999999E-2,null,21585.96,86.34384]
[null,null,"Taxes & Insurance",null,null,"$",null,1,null,{"$f":"Investment!H42+Investment!H19","v":781.2},null,781.2,3.1248]
[null,null,"General Overhead",null,null,"$",null,1,null,5000,null,5000,20]
[null,null,"TOTAL OWNERSHIP COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L43:L50)","v":51500.78},206.00312]
[]
[null,null,"TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+L37+L51","v":278847.36826894525},{"$f":"L53/$M$3","v":1115.3894730757811}]
[]
[null,null,"NET RETURNS ABOVE TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+L14-L53","v":-82839.368268945254},{"$f":"L55/$M$3","v":-331.357473075781}]

{"sheet":"Monthly Flows","index":1,"n_rows":85,"n_cols":16,"rows_kept":85,"cut":false,"hidden":false,"merged":[[77,6,79,6],[76,2,76,5],[77,2,79,2],[77,5,79,5],[77,4,79,4],[77,3,79,3]]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC6-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":101035},null,{"$f":"'CC6-Budget'!L9","v":101035}]
[null,null,"Heifer Calves",null,null,null,null,null,null,null,null,null,{"$f":"P7","v":64638.000000000007},null,null,{"$f":"'CC6-Budget'!L10","v":64638.000000000007}]
[null,null,"Cull Cows",{"$f":"P8","v":21775},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CC6-Budget'!L11","v":21775}]
[null,null,"Cull Bulls",null,null,null,null,null,null,null,null,null,{"$f":"P9","v":4752},null,null,{"$f":"'CC6-Budget'!L12","v":4752}]
[null,null,"Cull Replacement Heifers",{"$f":"P10","v":3808.0000000000005},null,null,null,null,null,null,null,null,null,{"$f":"P10","v":3808.0000000000005},null,{"$f":"'CC6-Budget'!L13","v":3808.0000000000005}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D10)","v":25583},{"$f":"SUM(E6:E10)","v":0},0,0,0,0,0,0,0,69390,104843,0,{"$f":"'CC6-Budget'!L14","v":196008}]
[]
[]
[null,"Operating Inputs:"]
[null,null,"Alfalfa Hay",{"$f":"0.2*P16","v":2343.25},{"$f":"0.2*P16","v":2343.25},{"$f":"0.2*P16","v":2343.25},{"$f":"0.2*P16","v":2343.25},null,null,null,null,null,null,null,{"$f":"0.2*P16","v":2343.25},{"$f":"'CC6-Budget'!L17","v":11716.25}]
[null,null,"Alfalfa/Grass Hay",{"$f":"0.2*P17","v":18415},{"$f":"0.2*P17","v":18415},{"$f":"0.2*P17","v":18415},{"$f":"0.2*P17","v":18415},null,null,null,null,null,null,null,{"$f":"0.2*P17","v":18415},{"$f":"'CC6-Budget'!L18","v":92075}]
[null,null,"Protein Supplement",null,null,{"$f":"P18*0.5","v":7650},{"$f":"P18*0.5","v":7650},null,null,null,null,null,null,null,null,{"$f":"'CC6-Budget'!L19","v":15300}]
[null,null,"Federal Range",null,null,null,null,{"$f":"P19","v":1377},null,null,null,null,null,null,null,{"$f":"'CC6-Budget'!L20","v":1377}]
[null,null,"State Range",null,null,null,null,{"$f":"P20","v":3660},null,null,null,null,null,null,null,{"$f":"'CC6-Budget'!L21","v":3660}]
[null,null,"Grazing Association Fees",null,null,null,null,null,{"$f":"P21","v":7575},null,null,null,null,null,null,{"$f":"'CC6-Budget'!L22","v":7575}]
[null,null,"Private Range",null,null,null,null,null,null,null,null,null,null,{"$f":"P22","v":7878},null,{"$f":"'CC6-Budget'!L23","v":7878}]
[null,null,"Crop Aftermath",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P23","v":5908.5},{"$f":"'CC6-Budget'!L24","v":5908.5}]
[null,null,"Salt/Mineral",{"$f":"$P$24/12","v":55},{"$f":"$P$24/12","v":55},55,55,55,55,55,55,55,55,55,55,{"$f":"'CC6-Budget'!L25","v":660}]
[null,null,"Veterinary/Medicine",null,{"$f":"0.2*P25","v":1337.8227531249997},{"$f":"0.2*P25","v":1337.8227531249997},null,null,null,null,null,null,null,{"$f":"0.6*P25","v":4013.468259374999},null,{"$f":"'CC6-Budget'!L26","v":6689.1137656249985}]
[null,null,"Freight/Trucking",null,null,null,null,{"$f":"0.5*P26","v":468.75},null,null,null,{"$f":"0.5*P26","v":468.75},null,null,null,{"$f":"'CC6-Budget'!L27","v":937.5}]
[null,null,"Commission",null,null,null,null,null,null,null,null,null,null,{"$f":"P27","v":910.05},null,{"$f":"'CC6-Budget'!L28","v":910.05}]
[null,null,"Checkoff/Brand Inspection",null,null,null,null,null,null,null,null,null,null,{"$f":"P28","v":645.28},null,{"$f":"'CC6-Budget'!L29","v":645.28}]
[null,null,"Hired Labor",{"$f":"0.05*P29","v":1136.875},{"$f":"0.15*P29","v":3410.625},{"$f":"0.15*P29","v":3410.625},{"$f":"0.15*$P$29","v":3410.625},{"$f":"0.05*$P$29","v":1136.875},{"$f":"0.05*$P$29","v":1136.875},{"$f":"0.05*$P$29","v":1136.875},{"$f":"0.05*$P$29","v":1136.875},{"$f":"0.05*$P$29","v":1136.875},{"$f":"0.1*$P$29","v":2273.75},{"$f":"0.1*$P$29","v":2273.75},{"$f":"0.05*$P$29","v":1136.875},{"$f":"'CC6-Budget'!L30","v":22737.5}]
[null,null,"Owner Labor",{"$f":"$P$30/12","v":2593.3333333333335},{"$f":"$P$30/12","v":2593.3333333333335},2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,2593.3333333333335,{"$f":"'CC6-Budget'!L31","v":31120}]
[null,null,"Machinery (Fuel, Oil, Repair)",{"$f":"$P$26/12","v":78.125},{"$f":"$P$26/12","v":78.125},78.125,78.125,78.125,78.125,78.125,78.125,78.125,78.125,78.125,78.125,{"$f":"'CC6-Budget'!L32","v":4286.7}]
[null,null,"Vehicles (Fuel, Repair)",{"$f":"$P$31/12","v":357.22499999999997},{"$f":"$P$31/12","v":357.22499999999997},357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,357.22499999999997,{"$f":"'CC6-Budget'!L33","v":9739.64}]
[null,null,"Equipment (Repair)",{"$f":"$P$32/12","v":811.63666666666666},{"$f":"$P$32/12","v":811.63666666666666},811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,811.63666666666666,{"$f":"'CC6-Budget'!L34","v":1037.1075000000001}]
[null,null,"Buildings & Improvements (Repair)",{"$f":"$P$34/12","v":23.933250000000001},{"$f":"$P$34/12","v":23.933250000000001},23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,23.933250000000001,{"$f":"'CC6-Budget'!L35","v":287.19900000000001}]
[null,null,"Interest on Operating Capital",null,null,null,null,null,null,null,null,null,null,null,{"$f":"P35","v":2806.7480033203124},{"$f":"'CC6-Budget'!L36","v":2806.7480033203124}]
[]
[null,"Total Costs",null,{"$f":"SUM(D16:D35)","v":25814.378249999994},29425.951003124996,37075.951003125003,35738.128250000002,10561.878250000002,12631.128250000002,5056.1282499999998,5056.1282499999998,5524.8782500000007,6193.0032500000007,19639.801509374993,34529.626253320304,227346.58826894528]
[]
[]
[null,"Net Returns",null,{"$f":"D12-D37","v":-231.3782499999943},-29425.951003124996,-37075.951003125003,-35738.128250000002,-10561.878250000002,-12631.128250000002,-5056.1282499999998,-5056.1282499999998,-5524.8782500000007,63196.996749999998,85203.198490625015,-34529.626253320304,-31338.588268945285]
[]
[]
[]
[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",13,13,13,13,null,null,null,null,null,null,null,13]
[null,"Alfalfa/Grass Hay"]
[null,null,"Cows","ton",120,120,120,120,null,null,null,null,null,null,null,120]
[null,null,"Bulls","ton",5.4,5.4,5.4,5.4,null,null,null,null,null,null,null,5.4]
[null,null,"Horses","ton",1.5,1.5,1.5,1.5,null,null,null,null,null,null,null,1.5]
[null,"Protein Supplement"]
[null,null,"Cows","cwt",null,null,225,225]
[null,"Federal Range"]
[null,null,"Cows","AUM",null,null,null,null,125,125,125,125,125]
[null,null,"Replacement Heifers","AUM",null,null,null,null,22,22,22,22,22]
[null,null,"Bulls","AUM",null,null,null,null,5,5,5,5,5]
[null,"State Range"]
[null,null,"Cows","AUM",null,null,null,null,125,125,125,125,125]
[null,null,"Replacement Heifers","AUM",null,null,null,null,21,21,21,21,21]
[null,null,"Bulls","AUM",null,null,null,null,5,5,5,5,5]
[null,"Private Pasture"]
[null,null,"Cows","AUM",null,null,null,null,null,null,null,null,null,250]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,null,43]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,null,10]
[null,null,"Horses","AUM",null,null,null,null,null,null,null,null,null,4]
[null,"Crop Aftermath"]
[null,null,"Cows","AUM",null,null,null,null,null,null,null,null,null,null,250]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,null,null,43]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,null,null,10]
[null,null,"Horses","AUM",null,null,null,null,null,null,null,null,null,null,4]
[null,"Salt/Mineral",null,"cwt",5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[]
[null,null,"Daily Feed Requirements                                                              by Livestock Category (lb fed/head/day)"]
[null,null,"Livestock Category","Alfalfa - Grass Hay (lb)","Alfalfa Hay      (lb)","Protein Supplement (lb)","No. of Days"]
[]
[]
[null,null,"Replacement Heifers",null,20,null,150]
[null,null,"Cows",30,null,null,150]
[null,null,"Cows",null,null,3,60]
[null,null,"Bulls",36,null,null,150]
[null,null,"Horses",25,null,null,150]

{"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-CC6-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",20000,0,100,25,{"$f":"D7*0.0036","v":72},{"$f":"(D7-E7)*0.071","v":1419.9999999999998}]
[null,null,"Working Corrals & Pens",15000,3000,100,30,54,{"$f":"(D8-E8)*0.065","v":780}]
[null,null,"Panels",2000,1000,100,15,7.2,{"$f":"(D9-E9)*0.097","v":97}]
[null,null,"Barn",20000,3000,100,30,72,{"$f":"(D10-E10)*0.065","v":1105}]
[null,null,"Hay Shed",30000,5000,100,30,108,{"$f":"(D11-E11)*0.065","v":1625}]
[null,null,"Calving Shed",20000,4000,100,30,72,{"$f":"(D12-E12)*0.065","v":1040}]
[null,null,"Feed Wagon",2000,500,100,10,7.2,{"$f":"(D13-E13)*0.13","v":195}]
[null,null,"Squeeze Chute",3500,1000,100,10,12.6,{"$f":"(D14-E14)*0.13","v":325}]
[null,null,"Vet Equipment",1500,0,100,15,5.3999999999999995,{"$f":"(D15-E15)*0.097","v":145.5}]
[null,null,"Flatbed Trailer",6000,1000,100,20,21.599999999999998,{"$f":"(D16-E16)*0.081","v":405}]
[null,null,"Stock Trailer",12000,1000,100,20,43.199999999999996,{"$f":"(D17-E17)*0.081","v":891}]
[]
[null,"Total",null,{"$f":"SUM(D7:D17)","v":132000},null,null,null,{"$f":"SUM(H7:H17)","v":475.2},{"$f":"SUM(I7:I17)","v":8028.5}]
[]
[]
[null,"Purchased Livestock"]
[null,null,"Horses",{"$f":"2500*4","v":10000},{"$f":"600*4","v":2400},100,10,null,{"$f":"(D23-E23)*0.13","v":988}]
[null,null,"Bulls",{"$f":"10*4000","v":40000},{"$f":"'CC6-Budget'!D12*'CC6-Budget'!J12*10","v":15840},100,4,null,{"$f":"(D24-E24)*0.282","v":6813.119999999999}]
[]
[null,"Total",null,{"$f":"SUM(D23:D24)","v":50000},null,null,null,null,{"$f":"SUM(I23:I24)","v":7801.119999999999}]
[]
[]
[null,"Retained Livestock"]
[null,null,"Beef Replacement Heifers ",{"$f":"1200*43","v":51600},{"$f":"43*'CC6-Budget'!D13*'CC6-Budget'!J13","v":40936.000000000007},100,null,null,{"$f":"D30*$K$6","v":2610.96},2]
[null,null,"Beef Cows",{"$f":"250*1500","v":375000},{"$f":"250*'CC6-Budget'!D11*'CC6-Budget'!J11","v":217750},100,null,null,{"$f":"D31*$K$6","v":18975},2]
[]
[null,"Total",null,{"$f":"SUM(D30:D31)","v":426600},null,null,null,null,{"$f":"SUM(I30:I31)","v":21585.96}]
[]
[]
[null,"Machinery and Vehicles"]
[null,null,"80 hpTractor with Loader",40000,8500,100,18,{"$f":"D37*0.0036","v":144},{"$f":"(D37-E37)*0.086","v":2709}]
[null,null,"Pickup 4X4 3/4 ton",20000,5000,100,10,{"$f":"D38*0.0036","v":72},{"$f":"(D38-E38)*0.13","v":1950}]
[null,null,"Pickup 4X4 1 ton",25000,4000,100,8,{"$f":"D39*0.0036","v":90},{"$f":"(D39-E39)*0.155","v":3255}]
[null,null,"ATV",4000,1000,100,10,{"$f":"D40*0.0094","v":37.6},{"$f":"(D40-E40)*0.13","v":390}]
[]
[null,"Total",null,{"$f":"SUM(D37:D40)","v":89000},null,null,null,{"$f":"SUM(H37:H39)","v":306},{"$f":"SUM(I37:I40)","v":8304}]
[]
[]
[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."]
[]
[]
[null,null,"https://www.vcalc.com/wiki/vCalc/Capital+Recovery"]

{"sheet":"Vet","index":3,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,9,2,20]]}
[null,null,"Veterinary Expenses"]
[]
[null,null,null,null,null,null,null,null,null,"Monthly Allocation"]
[null,null,null,"Number of Head","Dosage","Price",null,"Units","$/Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Vaccine",null,"Steer Calves",110]
[null,null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",{"$f":"F6/E6","v":1.5497999999999998},null,null,null,null,1,null,null,null,null,null,1,null,{"$f":"SUM(J6:U6)*$D$5*I6","v":340.95599999999996}]
["Inforce 3",null,"8 Way",null,50,42.29,null,"dose",{"$f":"F7/E7","v":0.8458},null,null,null,null,1,null,null,null,null,null,1,null,{"$f":"SUM(J7:U7)*$D$5*I7","v":186.07599999999999}]
["Ultrabac 8",null,"Heifer Calves",110]
[null,null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",1.5497999999999998,null,null,null,null,1,null,null,null,null,null,1,null,{"$f":"SUM(J9:U9)*$D$8*I9","v":340.95599999999996}]
["Inforce 3",null,"8 Way",null,50,42.29,null,"dose",0.8458,null,null,null,null,1,null,null,null,null,null,1,null,{"$f":"SUM(J10:U10)*$D$8*I10","v":186.07599999999999}]
["Ultrabac 8",null,"Bangs",null,1,4,null,"dose",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J11:U11)*$D$8*I11","v":440}]
[null,null,"Cows",250]
["Pyramid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(J13:U13)*$D$12*I13","v":326.45000000000005}]
["Vira Shield 6 + VL5",null,"Pregnancy Viral",null,50,127.29,null,"dose",2.5458000000000003,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(J14:U14)*$D$12*I14","v":636.45000000000005}]
["Clean-Up 2",null,"Pour-On",null,384,432.5,null,"dose",1.1263020833333333,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(J15:U15)*$D$12*I15","v":281.57552083333331}]
["PYthon2",null,"Fly Tags",null,100,197.39,null,"head",1.9738999999999998,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(J16:U16)*$D$12*I16","v":493.47499999999997}]
[null,null,"Preg. Check",null,1,4,null,"head",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J17:U17)*$D$12*I17","v":1000}]
[null,null,"Replacement Heifers",34]
["Pyramid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,null,null,1,null,null,null,null,null,1,null,{"$f":"SUM(J19:U19)*$D$18*I19","v":88.79440000000001}]
["Vira Shield 6 + VL5",null,"Pregnancy Viral",null,50,127.29,null,"dose",2.5458000000000003,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(J20:U20)*$D$18*I20","v":86.557200000000009}]
["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,{"$f":"SUM(J21:U21)*$D$18*I21","v":38.294270833333329}]
["Python 2",null,"Fly Tags",null,100,197.39,null,"head",1.9738999999999998,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(J22:U22)*$D$18*I22","v":67.112599999999986}]
[null,null,"Preg. Check",null,1,4,null,"head",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J23:U23)*$D$18*I23","v":136}]
[null,null,"Bulls",10]
["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(J25:U25)*$D$24*I25","v":13.058}]
["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(J26:U26)*$D$24*I26","v":8.4580000000000002}]
["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,{"$f":"SUM(J27:U27)*$D$24*I27","v":11.263020833333332}]
[null,null,"Semen/Trich Test",null,1,65,null,"head",65,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(J28:U28)*$D$24*I28","v":650}]
[null,null,"Fly Tags",null,100,197.39,null,"head",1.9738999999999998,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(J29:U29)*$D$24*I29","v":19.738999999999997}]
["Python 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(V6:V29)","v":5351.2910124999989}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V30*1.25","v":6689.1137656249985}]