{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CC2-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":"CC2-Budget","index":0,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[45,1,45,2],[2,1,2,4],[27,1,27,2],[26,1,26,2],[30,1,30,2],[17,1,17,2],[15,1,15,2],[22,1,22,2],[21,1,21,2],[40,1,40,2],[16,1,16,2],[18,1,18,2],[6,16,6,17],[46,1,46,2],[20,1,20,2],[19,1,19,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[39,1,39,2],[41,1,41,2],[29,1,29,2],[28,1,28,2],[23,1,23,2],[32,1,32,2],[31,1,31,2],[25,1,25,2],[24,1,24,2]]}
["Table 1:  Cow-Calf Budget, 300 Cow - 2021 ",null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC2-21"]
["Summer on Private Pasture & Federal Range, Winter Feeding Necessary",null,null,null,null,null,null,null,null,null,"No. of Cows:",300]
[]
[null,null,null,null,null,null,"Total Number"]
[null,null,"Weight",null,null,null,"of Head",null,"Price or",null,"Total","Value or"]
[null,null,"Each",null,"Unit",null,"or Units",null,"Cost/Unit",null,"Value","Cost/Head",null,"Your Value"]
[null,"GROSS RETURNS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES"]
[null,"Steer Calves",550,null,"lbs",null,138,null,1.67,null,{"$f":"C8*G8*I8","v":126753},{"$f":"K8/$L$2","v":422.51},null,null,null,null,300,"Cows"]
[null,"Heifer Calves",525,null,"lbs",null,84,null,1.62,null,{"$f":"C9*G9*I9","v":71442},{"$f":"K9/$L$2","v":238.14},null,null,null,null,12,"Bulls"]
[null,"Cull Cows",1100,null,"lbs",null,42,null,0.67,null,{"$f":"C10*G10*I10","v":30954.000000000004},{"$f":"K10/$L$2","v":103.18},null,null,null,null,6,"Horses"]
[null,"Cull Bulls",1650,null,"lbs",null,3,null,0.88,null,{"$f":"C11*G11*I11","v":4356},{"$f":"K11/$L$2","v":14.52},null,null,null,null,0.14000000000000001,"Cow culling rate"]
[null,"Cull Replacement Heifers",900,null,"lbs",null,6,null,1.1200000000000001,null,{"$f":"C12*G12*I12","v":6048.0000000000009},{"$f":"K12/$L$2","v":20.160000000000004},null,null,null,null,0.02,"Cow death loss"]
[null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(K8:K12)","v":239553},{"$f":"SUM(L8:L12)","v":798.50999999999988},null,null,null,null,0.92,"Calf crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,"Heifer culling rate"]
[null,"OPERATING COSTS"]
[null,"Alfalfa/Grass Hay",null,null,"ton",null,379,null,180,null,{"$f":"G16*I16","v":68220},{"$f":"K16/$L$2","v":227.4}]
[null,"Meadow Hay",null,null,"ton",null,281,null,145,null,{"$f":"G17*I17","v":40745},{"$f":"K17/$L$2","v":135.81666666666666}]
[null,"Feed Barley",null,null,"cwt",null,150,null,30.38,null,{"$f":"G18*I18","v":4557},15.19]
[null,"Federal Range",null,null,"AUM",null,1121,null,1.35,null,{"$f":"G19*I19","v":1513.3500000000001},{"$f":"K19/$L$2","v":5.0445000000000002}]
[null,"Meadow Pasture",null,null,"AUM",null,713,null,26,null,18538,61.793333333333337]
[null,"Crop Aftermath",null,null,"AUM",null,484,null,19.5,null,9438,31.46]
[null,"Salt/Mineral",null,null,"cwt",null,156,null,34,null,5304,17.68]
[null,"Veterinary/Medicine",null,null,"$",null,1,null,{"$f":"Vet!V32","v":8331.0549531249999},null,{"$f":"G23*I23","v":8331.0549531249999},27.770183177083332]
[null,"Freight/Trucking",null,null,"head",null,{"$f":"SUM(G10:G12)","v":51},null,10,null,510,1.7]
[null,"Commission",null,null,"head",null,{"$f":"SUM(G10:G12)","v":51},null,{"$f":"(K10+K11+K12)*0.025/(G10+G11+G12)","v":20.273529411764706},null,{"$f":"G25*I25","v":1033.95},{"$f":"K25/$L$2","v":3.4465000000000003}]
[null,"Checkoff/Brand Inspection",null,null,"head",null,{"$f":"SUM(G8:G12)","v":273},null,2.96,null,{"$f":"G26*I26","v":808.08},{"$f":"K26/$L$2","v":2.6936}]
[null,"Hired Labor",null,null,"hour",null,2180,null,18.190000000000001,null,39654.200000000004,132.18066666666667]
[null,"Owner Labor",null,null,"hour",null,1000,null,31.12,null,31120,103.73333333333333]
[null,"Machinery (Fuel, Oil, Repair)",null,null,"$",null,1,null,{"$f":"3050*(1+42.89%)","v":4358.1450000000004},null,{"$f":"G29*I29","v":4358.1450000000004},{"$f":"K29/$L$2","v":14.527150000000001}]
[null,"Vehicles (Fuel, Repair)",null,null,"$",null,1,null,{"$f":"7000*(1+43.23%)","v":10026.099999999999},null,{"$f":"G30*I30","v":10026.099999999999},{"$f":"K30/$L$2","v":33.420333333333332}]
[null,"Equipment (Repair)",null,null,"$",null,1,null,{"$f":"850*(1+6.37%)","v":904.1450000000001},null,{"$f":"G31*I31","v":904.1450000000001},{"$f":"K31/$L$2","v":3.013816666666667}]
[null,"Buildings & Improvements (Repair)",null,null,"$",null,1,null,{"$f":"950*(1+6.37%)","v":1010.5150000000001},null,1010.5150000000001,3.3683833333333335]
[null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(K16:K32)*0.25","v":61517.88498828125},null,0.05,null,3075.8942494140629,10.25298083138021]
[null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(K16:K33)","v":249147.43420253907},830.49144734179686]
[]
[null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"K13-K34","v":-9594.4342025390652},{"$f":"K36/$L$2","v":-31.981447341796883}]
[]
[null,"OWNERSHIP COSTS"]
[null,"Capital Recovery:"]
[null,"     Purchased Livestock ",null,null,"$",null,1,null,{"$f":"Investment!H22","v":10104.431999999999},null,{"$f":"G40*I40","v":10104.431999999999},{"$f":"K40/$L$2","v":33.681439999999995}]
[null,"     Housing & Improvements",null,null,"$",null,1,null,{"$f":"Investment!H15-Investment!H13-Investment!H12-Investment!H11-Investment!H10-Investment!H9","v":3257},null,{"$f":"G41*I41","v":3257},{"$f":"K41/$L$2","v":10.856666666666667}]
[null,"     Machinery",null,null,"$",null,1,null,{"$f":"Investment!H33","v":2709},null,2709,{"$f":"K42/$L$2","v":9.0299999999999994}]
[null,"     Equipment",null,null,"$",null,1,null,{"$f":"Investment!H9+Investment!H10+Investment!H11+Investment!H12+Investment!H13","v":1572.5},null,1572.5,5.2416666666666663]
[null,"     Vehicles",null,null,"$",null,1,null,{"$f":"Investment!H34+Investment!H35+Investment!H36","v":3335},null,3335,11.116666666666667]
[null,"Interest on Retained Livestock",null,null,"$",null,{"$f":"Investment!C29","v":514800},null,5.0599999999999999E-2,null,26048.880000000001,86.829599999999999]
[null,"Taxes & Insurance",null,null,"$",null,1,null,{"$f":"Investment!G38+Investment!G15","v":845.84999999999991},null,845.84999999999991,2.8194999999999997]
[null,"General Overhead",null,null,"$",null,1,null,5000,null,5000,16.666666666666668]
[null,"TOTAL OWNERSHIP COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(K40:K47)","v":52872.662000000004},176.24220666666668]
[]
[null,"TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+K34+K48","v":302020.09620253905},{"$f":"K50/$L$2","v":1006.7336540084635}]
[]
[null,"NET RETURNS ABOVE TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+K13-K50","v":-62467.096202539047},{"$f":"K52/$L$2","v":-208.22365400846348}]

{"sheet":"Monthly Flows","index":1,"n_rows":79,"n_cols":15,"rows_kept":79,"cut":false,"hidden":false,"merged":[[71,5,73,5],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[70,1,70,4],[71,1,73,1],[71,4,73,4],[71,2,73,3]]}
["Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC2-21"]
[null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Value"]
[]
["Production:"]
[null,"Steer Calves",null,null,null,null,null,null,null,null,null,null,{"$f":"O5","v":126753},null,{"$f":"'CC2-Budget'!K8","v":126753}]
[null,"Heifer Calves",null,null,null,null,null,null,null,null,null,null,{"$f":"O6","v":71442},null,{"$f":"'CC2-Budget'!K9","v":71442}]
[null,"Cull Cows",null,null,null,null,{"$f":"0.25*O7","v":7738.5000000000009},null,null,null,null,null,{"$f":"0.75*O7","v":23215.500000000004},null,{"$f":"'CC2-Budget'!K10","v":30954.000000000004}]
[null,"Cull Bulls",null,null,null,null,null,null,null,null,null,null,{"$f":"O8","v":4356},null,{"$f":"'CC2-Budget'!K11","v":4356}]
[null,"Cull Replacement Heifers",null,null,null,null,null,null,null,null,null,null,{"$f":"O9","v":6048.0000000000009},null,{"$f":"'CC2-Budget'!K12","v":6048.0000000000009}]
[]
["Total Receipts",null,{"$f":"SUM(C5:C9)","v":0},{"$f":"SUM(D5:D9)","v":0},0,0,7738.5000000000009,0,0,0,0,0,231814.5,0,{"$f":"'CC2-Budget'!K13","v":239553}]
[]
[]
["Operating Inputs:"]
[null,{"$f":"'CC2-Budget'!B16:C16","v":"Alfalfa/Grass Hay"},{"$f":"$O$15/5","v":13644},{"$f":"$O$15/5","v":13644},{"$f":"$O$15/5","v":13644},13644,null,null,null,null,null,null,null,13644,{"$f":"'CC2-Budget'!K16","v":68220}]
[null,{"$f":"'CC2-Budget'!B17:C17","v":"Meadow Hay"},{"$f":"$O$16/5","v":8149},{"$f":"$O$16/5","v":8149},{"$f":"$O$16/5","v":8149},8149,null,null,null,null,null,null,null,8149,{"$f":"'CC2-Budget'!K17","v":40745}]
[null,{"$f":"'CC2-Budget'!B18:C18","v":"Feed Barley"},{"$f":"$O$17/5","v":911.4},{"$f":"$O$17/5","v":911.4},{"$f":"$O$17/5","v":911.4},911.4,null,null,null,null,null,null,null,911.4,{"$f":"'CC2-Budget'!K18","v":4557}]
[null,{"$f":"'CC2-Budget'!B19:C19","v":"Federal Range"},null,null,null,null,{"$f":"$O$18/5","v":302.67},{"$f":"$O$18/5","v":302.67},302.67,302.67,302.67,null,null,null,{"$f":"'CC2-Budget'!K19","v":1513.3500000000001}]
[null,{"$f":"'CC2-Budget'!B20:C20","v":"Meadow Pasture"},null,null,null,null,{"$f":"$O$19/5","v":3707.6},{"$f":"$O$19/5","v":3707.6},3707.6,3707.6,3707.6,null,null,null,{"$f":"'CC2-Budget'!K20","v":18538}]
[null,{"$f":"'CC2-Budget'!B21:C21","v":"Crop Aftermath"},null,null,null,null,null,null,null,null,null,null,{"$f":"$O$20/2","v":4719},{"$f":"$O$20/2","v":4719},{"$f":"'CC2-Budget'!K21","v":9438}]
[null,{"$f":"'CC2-Budget'!B22:C22","v":"Salt/Mineral"},null,{"$f":"$O$21/12","v":442},{"$f":"$O$21/12","v":442},442,442,442,442,442,442,442,442,442,{"$f":"'CC2-Budget'!K22","v":5304}]
[null,{"$f":"'CC2-Budget'!B23:C23","v":"Veterinary/Medicine"},null,{"$f":"0.05*O22","v":416.55274765625001},null,{"$f":"0.45*O22","v":3748.9747289062502},null,{"$f":"0.1*O22","v":833.10549531250001},null,null,{"$f":"0.1*O22","v":833.10549531250001},{"$f":"0.3*O22","v":2499.3164859374997},null,null,{"$f":"'CC2-Budget'!K23","v":8331.0549531249999}]
[null,{"$f":"'CC2-Budget'!B24:C24","v":"Freight/Trucking"},null,null,null,null,{"$f":"0.25*O23","v":127.5},null,null,null,null,null,{"$f":"0.75*O23","v":382.5},null,{"$f":"'CC2-Budget'!K24","v":510}]
[null,{"$f":"'CC2-Budget'!B25:C25","v":"Commission"},null,null,null,null,{"$f":"0.25*O24","v":258.48750000000001},null,null,null,null,null,{"$f":"O24*0.75","v":775.46250000000009},null,{"$f":"'CC2-Budget'!K25","v":1033.95}]
[null,{"$f":"'CC2-Budget'!B26:C26","v":"Checkoff/Brand Inspection"},null,null,null,null,{"$f":"0.25*O25","v":202.02},null,null,null,null,null,{"$f":"O25*0.75","v":606.06000000000006},null,{"$f":"'CC2-Budget'!K26","v":808.08}]
[null,{"$f":"'CC2-Budget'!B27:C27","v":"Hired Labor"},{"$f":"0.08*O26","v":3172.3360000000002},{"$f":"0.17*O26","v":6741.2140000000009},{"$f":"0.17*O26","v":6741.2140000000009},{"$f":"0.08*O26","v":3172.3360000000002},{"$f":"0.08*O26","v":3172.3360000000002},{"$f":"0.0225*$O$26","v":892.21950000000004},{"$f":"0.0225*$O$26","v":892.21950000000004},{"$f":"0.0225*$O$26","v":892.21950000000004},{"$f":"0.0225*$O$26","v":892.21950000000004},{"$f":"0.17*O26","v":6741.2140000000009},{"$f":"0.08*O26","v":3172.3360000000002},{"$f":"0.08*O26","v":3172.3360000000002},{"$f":"'CC2-Budget'!K27","v":39654.200000000004}]
[null,{"$f":"'CC2-Budget'!B28:C28","v":"Owner Labor"},{"$f":"$O$27/12","v":2593.3333333333335},{"$f":"$O$27/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":"'CC2-Budget'!K28","v":31120}]
[null,{"$f":"'CC2-Budget'!B29:C29","v":"Machinery (Fuel, Oil, Repair)"},{"$f":"$O$28/12","v":363.17875000000004},363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,{"$f":"'CC2-Budget'!K29","v":4358.1450000000004}]
[null,{"$f":"'CC2-Budget'!B30:C30","v":"Vehicles (Fuel, Repair)"},{"$f":"$O$29/12","v":835.50833333333321},835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,{"$f":"'CC2-Budget'!K30","v":10026.099999999999}]
[null,{"$f":"'CC2-Budget'!B31:C31","v":"Equipment (Repair)"},{"$f":"$O$30/12","v":75.345416666666679},{"$f":"$O$30/12","v":75.345416666666679},{"$f":"$O$30/12","v":75.345416666666679},75.345416666666679,75.345416666666679,75.345416666666679,75.345416666666679,75.345416666666679,75.345416666666679,75.345416666666679,75.345416666666679,75.345416666666679,{"$f":"'CC2-Budget'!K31","v":904.1450000000001}]
[null,{"$f":"'CC2-Budget'!B32:C32","v":"Buildings & Improvements (Repair)"},{"$f":"$O$31/12","v":84.209583333333342},{"$f":"$O$31/12","v":84.209583333333342},84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,84.209583333333342,{"$f":"'CC2-Budget'!K32","v":1010.5150000000001}]
[null,{"$f":"'CC2-Budget'!B33:C33","v":"Interest on Operating Capital"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"O32","v":3075.8942494140629},{"$f":"'CC2-Budget'!K33","v":3075.8942494140629}]
[]
["Total Costs",null,{"$f":"SUM(C15:C32)","v":29828.311416666664},34255.742164322917,33839.189416666668,34019.286145572914,12164.188916666668,10129.170411979167,9296.0649166666681,9296.0649166666681,10129.170411979167,13634.105902604168,14048.933916666667,38065.205666080728,249147.43420253907]
[]
[]
["Net Returns",null,{"$f":"C11-C34","v":-29828.311416666664},-34255.742164322917,-33839.189416666668,-34019.286145572914,-4425.688916666667,-10129.170411979167,-9296.0649166666681,-9296.0649166666681,-10129.170411979167,-13634.105902604168,217765.56608333334,-38065.205666080728,-9594.4342025390652]
[]
[]
[]
[]
[]
[]
["Table 3:  Monthly Feed Requirements. "]
["Feed",null,"Units","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[]
["Feed Barley"]
[null,"Replacement Heifers","cwt",30,30,30,30,null,null,null,null,null,null,null,30]
["Alfalfa/Grass Hay"]
[null,"Cows","ton",56,56,56,56,null,null,null,null,null,null,null,56]
[null,"Replacement Heifers","ton",11,11,11,11,null,null,null,null,null,null,null,11]
[null,"Bulls","ton",7,7,7,7,null,null,null,null,null,null,null,7]
[null,"Horses","ton",2,2,2,2,null,null,null,null,null,null,null,2]
["Meadow Hay"]
[null,"Cows","ton",56,56,56,56,null,null,null,null,null,null,null,56]
["Federal Range"]
[null,"Cows","AUM",null,null,null,null,183,183,183,183,183]
[null,"Replacement Heifers","AUM",null,null,null,null,26,26,26,26,26]
[null,"Bulls","AUM",null,null,null,null,11,11,11,11,11]
[null,"Horses","AUM",null,null,null,null,4,4,4,4,4]
["Meadow Pasture"]
[null,"Cows","AUM",null,null,null,null,116,116,116,116,116]
[null,"Replacement Heifers","AUM",null,null,null,null,17,17,17,17,17]
[null,"Bulls","AUM",null,null,null,null,7,7,7,7,7]
[null,"Horses","AUM",null,null,null,null,2,2,2,2,2]
["Crop Aftermath",null,"AUM",null,null,null,null,null,null,null,null,null,242,242]
["Salt/Mineral",null,"cwt",13,13,13,13,13,13,13,13,13,13,13,13]
[]
[]
[]
[null,"Daily Feed Requirements                                                              by Livestock Category (lb fed/head/day)"]
[null,"Livestock Category","Alfalfa or Grass Hay (lb)",null,"Feed Barley      (lb)","No. of Days"]
[]
[]
[null,"Replacement Heifers",null,null,1.8,150]
[null,"Replacement Heifers",13,null,null,150]
[null,"Cows",25,null,null,150]
[null,"Bulls",28,null,null,150]
[null,"Horses",20,null,null,150]

{"sheet":"Investment","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Table 4:  Investment Summary. ",null,null,null,null,null,null,"CCB-CC2-21"]
[null,null,"Total Value","Salvage/Cull Value","Livestock Share","Useful Life","Annual Taxes & Insurance","Annual Capital Recovery",1]
[]
["Buildings, Improvements",null,null,null,null,null,null,null,null,"Interest/Discount Rate"]
["and Equipment",null,null,null,null,null,null,null,null,5.0599999999999999E-2]
[null,"Fencing",24000,0,100,25,{"$f":"C6*0.0036","v":86.399999999999991},{"$f":"(C6-D6)*0.071","v":1703.9999999999998}]
[null,"Working Corrals & Pens",10000,3000,100,30,{"$f":"C7*0.0036","v":36},{"$f":"(C7-D7)*0.064","v":448}]
[null,"Barn",20000,3000,100,30,{"$f":"C8*0.0036","v":72},{"$f":"(C8-D8)*0.065","v":1105}]
[null,"Calf Table",1500,500,100,10,{"$f":"C9*0.0035","v":5.25},{"$f":"(C9-D9)*0.13","v":130}]
[null,"Squeeze Chute",3500,1000,100,10,{"$f":"C10*0.0036","v":12.6},{"$f":"(C10-D10)*0.13","v":325}]
[null,"Vet Equipment",1500,0,100,15,{"$f":"C11*0.0036","v":5.3999999999999995},{"$f":"(C11-D11)*0.097","v":145.5}]
[null,"Stock Trailer",5000,1000,100,20,{"$f":"C12*0.0036","v":18},{"$f":"(C12-D12)*0.081","v":324}]
[null,"Gooseneck Trailer",12000,4000,100,20,{"$f":"C13*0.0036","v":43.199999999999996},{"$f":"(C13-D13)*0.081","v":648}]
[]
["Total",null,{"$f":"SUM(C6:C13)","v":77500},null,null,null,{"$f":"SUM(G6:G13)","v":278.84999999999997},{"$f":"SUM(H6:H13)","v":4829.5}]
[]
[]
["Purchased Livestock"]
[null,"Horses",15000,3600,100,10,null,{"$f":"(C19-D19)*0.13","v":1482}]
[null,"Bulls",48000,{"$f":"'CC2-Budget'!Q9*'CC2-Budget'!C11*'CC2-Budget'!I11","v":17424},100,4,null,{"$f":"(C20-D20)*0.282","v":8622.4319999999989}]
[]
["Total",null,{"$f":"SUM(C19:C20)","v":63000},null,null,null,null,{"$f":"SUM(H19:H20)","v":10104.431999999999}]
[]
[]
["Retained Livestock"]
[null,"Beef Replacement Heifers",{"$f":"1200*54","v":64800},{"$f":"1035*54","v":55890},100,null,null,{"$f":"C26*$J$5","v":3278.88},2]
[null,"Beef Cows",{"$f":"300*1500","v":450000},{"$f":"300*770","v":231000},100,null,null,{"$f":"C27*$J$5","v":22770},2]
[]
["Total",null,{"$f":"SUM(C26:C27)","v":514800},null,null,null,null,{"$f":"SUM(H26:H27)","v":26048.880000000001}]
[]
[]
["Machinery and Vehicles"]
[null,"Tractor Loader",40000,8500,100,18,{"$f":"C33*0.0036","v":144},{"$f":"(C33-D33)*0.086","v":2709}]
[null,"Pickup 4X4 3/4 ton",20000,5000,100,10,{"$f":"C34*0.0094","v":188}]
[null,"Pickup 4X4 1 ton",25000,6000,100,8,{"$f":"C35*0.0094","v":235},{"$f":"(C35-D35)*0.155","v":2945}]
[null,"ATV",4000,1000,100,10,{"$f":"C36*0.0094","v":37.6},{"$f":"(C36-D36)*0.13","v":390}]
[]
["Total",null,{"$f":"SUM(C33:C36)","v":89000},null,null,null,{"$f":"SUM(G33:G35)","v":567},{"$f":"SUM(H33:H36)","v":6044}]
[]
[]
[1,"Annual capital recovery is the method of calculating depreciation and interest recommended by the National Task Force"]
[null,"on Commodity Costs and Returns Measurement Methods."]
[2,"Interest on average investment."]

{"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"]
["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",138]
["Inforce 3",null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",{"$f":"F6/E6","v":1.5497999999999998},null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J6:U6)*$D$5*I6","v":427.74479999999994}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",{"$f":"F7/E7","v":0.8458},null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J7:U7)*$D$5*I7","v":233.4408}]
[null,null,"Heifer Calves",138]
["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(J9:U9)*$D$8*I9","v":427.74479999999994}]
["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(J10:U10)*$D$8*I10","v":233.4408}]
[null,null,"Bangs",null,null,null,null,"dose",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J11:U11)*$D$8*I11","v":552}]
[null,null,"Cows",300]
["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(J13:U13)*$D$12*I13","v":391.74}]
["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(J14:U14)*$D$12*I14","v":763.74000000000012}]
["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(J15:U15)*$D$12*I15","v":337.890625}]
["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(J16:U16)*$D$12*I16","v":592.16999999999996}]
[null,null,"Preg. Check",null,null,null,null,"head",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J17:U17)*$D$12*I17","v":1200}]
[null,null,"Replacement Heifers",54]
["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(J19:U19)*$D$18*I19","v":141.0264}]
["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(J20:U20)*$D$18*I20","v":137.47320000000002}]
["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":60.820312499999993}]
["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,{"$f":"SUM(J22:U22)*$D$18*I22","v":106.59059999999998}]
[null,null,"Preg. Check",null,null,null,null,"head",4,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(J23:U23)*$D$18*I23","v":216}]
[null,null,"Bulls",12]
["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":15.669600000000001}]
["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":10.1496}]
["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":13.515625}]
[null,null,"Semen/Trich Test",null,null,null,null,"head",65,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(J28:U28)*$D$24*I28","v":780}]
["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,{"$f":"SUM(J29:U29)*$D$24*I29","v":23.686799999999998}]
[null,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":6664.8439625000001}]
[]
[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":8331.0549531249999}]