{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CC8-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":"CC8-Budget","index":0,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,10],[2,1,2,10],[46,2,46,3],[3,2,3,5],[28,2,28,3],[27,2,27,3],[31,2,31,3],[16,2,16,3],[23,2,23,3],[22,2,22,3],[41,2,41,3],[17,2,17,3],[19,2,19,3],[18,2,18,3],[7,17,7,18],[47,2,47,3],[21,2,21,3],[20,2,20,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[40,2,40,3],[42,2,42,3],[30,2,30,3],[29,2,29,3],[24,2,24,3],[33,2,33,3],[32,2,32,3],[26,2,26,3],[25,2,25,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-CC8-21"]
[null,"Fall Calving - Summer on Private Range & Pasture, 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,112,null,1.67,null,{"$f":"D9*H9*J9","v":102872},{"$f":"L9/$M$3","v":411.488},null,null,null,null,250,"Cows"]
[null,null,"Heifer Calves",525,null,"lbs",null,70,null,1.62,null,{"$f":"D10*H10*J10","v":59535.000000000007},{"$f":"L10/$M$3","v":238.14000000000004},null,null,null,null,10,"Bulls"]
[null,null,"Cull Cows",1300,null,"lbs",null,38,null,0.67,null,{"$f":"D11*H11*J11","v":33098},{"$f":"L11/$M$3","v":132.392},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.12,"Cow culling rate"]
[null,null,"Cull Replacement Heifers",850,null,"lbs",null,5,null,1.1200000000000001,null,{"$f":"D13*H13*J13","v":4760},{"$f":"L13/$M$3","v":19.04},null,null,null,null,0.03,"Cow death loss"]
[null,null,"TOTAL GROSS RETURNS",null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L13)","v":205017},{"$f":"SUM(M9:M13)","v":820.06799999999998},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,695,null,145,null,100775,{"$f":"L18/$M$3","v":403.1}]
[null,null,"Protein Supplement",null,null,"cwt",null,450,null,34,null,15300,{"$f":"L19/$M$3","v":61.2}]
[null,null,"Private Pasture",null,null,"AUM",null,630,null,30.33,null,19107.899999999998,{"$f":"L20/$M$3","v":76.431599999999989}]
[null,null,"Private Range",null,null,"AUM",null,1212,null,26,null,{"$f":"H21*J21","v":31512},126.048]
[null,null,"Crop Aftermath",null,null,"AUM",null,307,null,{"$f":"18*1.0833","v":19.499399999999998},null,5986.3157999999994,23.945263199999996]
[null,null,"Salt/Mineral",null,null,"cwt",null,55,null,11,null,605,2.42]
[null,null,"Veterinary/Medicine",null,null,"$",null,1,null,{"$f":"Vet!W32","v":6871.9567890624976},null,{"$f":"H24*J24","v":6871.9567890624976},27.487827156249992]
[null,null,"Freight/Trucking",null,null,"head",null,250,null,10,null,2500,10]
[null,null,"Commission",null,null,"head",null,{"$f":"SUM(H11:H13)","v":46},null,{"$f":"(L11+L12+L13)*0.025/(H11+H12+H13)","v":23.157608695652176},null,{"$f":"H26*J26","v":1065.25},{"$f":"L26/$M$3","v":4.2610000000000001}]
[null,null,"Checkoff/Brand Inspection",null,null,"head",null,{"$f":"SUM(H9:H13)","v":228},null,2.96,null,{"$f":"H27*J27","v":674.88},{"$f":"L27/$M$3","v":2.6995200000000001}]
[null,null,"Hired Labor",null,null,"hour",null,625,null,18.190000000000001,null,11368.75,45.475000000000001]
[null,null,"Owner Labor",null,null,"hour",null,750,null,31.12,null,23340,93.36]
[null,null,"Machinery (Fuel, Oil, Repair)",null,null,"$",null,1,null,{"$f":"3000*(1+42.89%)","v":4286.7},null,{"$f":"H30*J30","v":4286.7},{"$f":"L30/$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":"H31*J31","v":9739.64},{"$f":"L31/$M$3","v":38.958559999999999}]
[null,null,"Equipment (Repair)",null,null,"$",null,1,null,{"$f":"975*(1+6.37%)","v":1037.1075000000001},null,{"$f":"H32*J32","v":1037.1075000000001},{"$f":"L32/$M$3","v":4.1484300000000003}]
[null,null,"Buildings & Improvements (Repair)",null,null,"$",null,1,null,{"$f":"2700*(1+6.37%)","v":2871.9900000000002},null,2871.9900000000002,11.487960000000001]
[null,null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(L17:L33)*0.25","v":62189.685022265629},null,0.05,null,3109.4842511132815,12.437937004453126]
[null,null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(L17:L34)","v":251868.2243401758},1007.4728973607032]
[]
[null,null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"L14-L35","v":-46851.224340175802},{"$f":"L37/$M$3","v":-187.40489736070322}]
[]
[null,null,"OWNERSHIP COSTS"]
[null,null,"Capital Recovery:"]
[null,null,"     Purchased Livestock ",null,null,"$",null,1,null,{"$f":"Investment!I25","v":7801.119999999999},null,{"$f":"H41*J41","v":7801.119999999999},{"$f":"L41/$M$3","v":31.204479999999997}]
[null,null,"     Buildings & Improvements",null,null,"$",null,1,null,{"$f":"Investment!I18","v":8132.5},null,{"$f":"H42*J42","v":8132.5},{"$f":"L42/$M$3","v":32.53}]
[null,null,"     Machinery",null,null,"$",null,1,null,{"$f":"Investment!I36","v":2709},null,2709,{"$f":"L43/$M$3","v":10.836}]
[null,null,"     Equipment",null,null,"$",null,1,null,{"$f":"Investment!I9+Investment!I12+Investment!I13+Investment!I14+Investment!I15+Investment!I16","v":1782.5},null,1782.5,7.13]
[null,null,"     Vehicles",null,null,"$",null,1,null,{"$f":"Investment!I37+Investment!I38+Investment!I39","v":5595},null,5595,22.38]
[null,null,"Interest on Retained Livestock",null,null,"$",null,{"$f":"Investment!D32","v":426600},null,5.0599999999999999E-2,null,21585.96,86.34384]
[null,null,"Taxes & Insurance",null,null,"$",null,1,null,{"$f":"Investment!H41+Investment!H18","v":1026},null,1026,4.1040000000000001]
[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(L41:L48)","v":53632.08},214.52832000000001]
[]
[null,null,"TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+L35+L49","v":305500.30434017582},{"$f":"L51/$M$3","v":1222.0012173607033}]
[]
[null,null,"NET RETURNS ABOVE TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+L14-L51","v":-100483.30434017582},{"$f":"L53/$M$3","v":-401.93321736070328}]

{"sheet":"Monthly Flows","index":1,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[71,6,73,6],[70,2,70,5],[71,2,73,2],[71,5,73,5],[71,4,73,4],[71,3,73,3]]}
[]
[null,"Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC8-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,{"$f":"P6","v":102872},null,null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L9","v":102872}]
[null,null,"Heifer Calves",null,null,null,{"$f":"P7","v":59535.000000000007},null,null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L10","v":59535.000000000007}]
[null,null,"Cull Cows",null,null,null,null,{"$f":"P8","v":33098},null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L11","v":33098}]
[null,null,"Cull Bulls",null,{"$f":"P9","v":4752},null,null,null,null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L12","v":4752}]
[null,null,"Cull Replacement Heifers",null,{"$f":"P10","v":4760},null,null,null,null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L13","v":4760}]
[]
[null,"Total Receipts",null,{"$f":"SUM(D6:D10)","v":0},{"$f":"SUM(E6:E10)","v":9512},0,162407,33098,0,0,0,0,0,0,0,{"$f":"'CC8-Budget'!L14","v":205017}]
[]
[]
[null,"Operating Inputs:"]
[null,null,{"$f":"'CC8-Budget'!C17:D17","v":"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":"'CC8-Budget'!L17","v":11716.25}]
[null,null,{"$f":"'CC8-Budget'!C18:D18","v":"Alfalfa/Grass Hay"},{"$f":"0.2*P17","v":20155},{"$f":"0.2*P17","v":20155},{"$f":"0.2*P17","v":20155},{"$f":"0.2*P17","v":20155},null,null,null,null,null,null,null,{"$f":"0.2*P17","v":20155},{"$f":"'CC8-Budget'!L18","v":100775}]
[null,null,{"$f":"'CC8-Budget'!C19:D19","v":"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":"'CC8-Budget'!L19","v":15300}]
[null,null,{"$f":"'CC8-Budget'!C20:D20","v":"Private Pasture"},null,null,null,null,{"$f":"P19","v":19107.899999999998},null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L20","v":19107.899999999998}]
[null,null,{"$f":"'CC8-Budget'!C21:D21","v":"Private Range"},null,null,null,null,{"$f":"P20","v":31512},null,null,null,null,null,null,null,{"$f":"'CC8-Budget'!L21","v":31512}]
[null,null,{"$f":"'CC8-Budget'!C22:D22","v":"Crop Aftermath"},null,null,null,null,null,null,null,null,{"$f":"P21","v":5986.3157999999994},null,null,null,{"$f":"'CC8-Budget'!L22","v":5986.3157999999994}]
[null,null,{"$f":"'CC8-Budget'!C23:D23","v":"Salt/Mineral"},{"$f":"$P$22/12","v":50.416666666666664},{"$f":"$P$22/12","v":50.416666666666664},50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,50.416666666666664,{"$f":"'CC8-Budget'!L23","v":605}]
[null,null,{"$f":"'CC8-Budget'!C24:D24","v":"Veterinary/Medicine"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P23","v":6871.9567890624976},{"$f":"'CC8-Budget'!L24","v":6871.9567890624976}]
[null,null,{"$f":"'CC8-Budget'!C25:D25","v":"Freight/Trucking"},{"$f":"$P$24/12","v":208.33333333333334},{"$f":"$P$24/12","v":208.33333333333334},208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,208.33333333333334,{"$f":"'CC8-Budget'!L25","v":2500}]
[null,null,{"$f":"'CC8-Budget'!C26:D26","v":"Commission"},null,{"$f":"0.2*P25","v":213.05},{"$f":"0.2*P25","v":213.05},null,null,null,null,null,null,null,{"$f":"0.6*P25","v":639.15},null,{"$f":"'CC8-Budget'!L26","v":1065.25}]
[null,null,{"$f":"'CC8-Budget'!C27:D27","v":"Checkoff/Brand Inspection"},null,null,null,null,{"$f":"0.5*P26","v":337.44},null,null,null,{"$f":"0.5*P26","v":337.44},null,null,null,{"$f":"'CC8-Budget'!L27","v":674.88}]
[null,null,{"$f":"'CC8-Budget'!C28:D28","v":"Hired Labor"},{"$f":"$P$27/12","v":947.39583333333337},{"$f":"$P$27/12","v":947.39583333333337},947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,947.39583333333337,{"$f":"'CC8-Budget'!L28","v":11368.75}]
[null,null,{"$f":"'CC8-Budget'!C29:D29","v":"Owner Labor"},{"$f":"$P$28/12","v":1945},{"$f":"$P$28/12","v":1945},1945,1945,1945,1945,1945,1945,1945,1945,1945,1945,{"$f":"'CC8-Budget'!L29","v":23340}]
[null,null,{"$f":"'CC8-Budget'!C30:D30","v":"Machinery (Fuel, Oil, Repair)"},{"$f":"0.05*P29","v":214.33500000000001},{"$f":"0.15*P29","v":643.005},{"$f":"0.15*P29","v":643.005},{"$f":"0.15*$P$29","v":643.005},{"$f":"0.05*$P$29","v":214.33500000000001},{"$f":"0.05*$P$29","v":214.33500000000001},{"$f":"0.05*$P$29","v":214.33500000000001},{"$f":"0.05*$P$29","v":214.33500000000001},{"$f":"0.05*$P$29","v":214.33500000000001},{"$f":"0.1*$P$29","v":428.67},{"$f":"0.1*$P$29","v":428.67},{"$f":"0.05*$P$29","v":214.33500000000001},{"$f":"'CC8-Budget'!L30","v":4286.7}]
[null,null,{"$f":"'CC8-Budget'!C31:D31","v":"Vehicles (Fuel, Repair)"},{"$f":"$P$30/12","v":811.63666666666666},{"$f":"$P$30/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":"'CC8-Budget'!L31","v":9739.64}]
[null,null,{"$f":"'CC8-Budget'!C32:D32","v":"Equipment (Repair)"},{"$f":"$P$26/12","v":56.24},{"$f":"$P$26/12","v":56.24},56.24,56.24,56.24,56.24,56.24,56.24,56.24,56.24,56.24,56.24,{"$f":"'CC8-Budget'!L32","v":1037.1075000000001}]
[null,null,{"$f":"'CC8-Budget'!C33:D33","v":"Buildings & Improvements (Repair)"},{"$f":"$P$31/12","v":86.425625000000011},{"$f":"$P$31/12","v":86.425625000000011},86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,86.425625000000011,{"$f":"'CC8-Budget'!L33","v":2871.9900000000002}]
[null,null,{"$f":"'CC8-Budget'!C34:D34","v":"Interest on Operating Capital"},{"$f":"$P$32/12","v":239.33250000000001},{"$f":"$P$32/12","v":239.33250000000001},239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,{"$f":"'CC8-Budget'!L34","v":3109.4842511132815}]
[]
[null,"Total Costs",null,{"$f":"SUM(D16:D33)","v":27057.365624999999},27699.085625,35349.085624999992,35136.03562499999,55516.455624999995,4559.1156250000004,4559.1156250000004,4559.1156250000004,10882.871424999998,4773.4506250000004,5412.600625,33929.322414062495,251868.2243401758]
[]
[]
[null,"Net Returns",null,{"$f":"D12-D35","v":-27057.365624999999},-18187.085625,-35349.085624999992,127270.96437500001,-22418.455624999995,-4559.1156250000004,-4559.1156250000004,-4559.1156250000004,-10882.871424999998,-4773.4506250000004,-5412.600625,-33929.322414062495,-46851.224340175802]
[]
[]
[]
[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",132,132,132,132,null,null,null,null,null,null,null,132]
[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,null,null,null,null,null,null,null,225,225]
[null,"Private Range"]
[null,null,"Cows","AUM",null,null,null,null,250,250,250,250,null,null,null,null,null,{"$f":"SUM(E54:P54)","v":1000},{"$f":"SUM(R54:R57)","v":1212}]
[null,null,"Replacement Heifers","AUM",null,null,null,null,43,43,43,43,null,null,null,null,null,172]
[null,null,"Bulls","AUM",null,null,null,null,10,10,10,10,null,null,null,null,null,40]
[null,"Private Pasture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Cows","AUM",null,null,null,null,null,null,null,null,250,250,null,null,null,500,{"$f":"SUM(R58:R62)","v":630}]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,43,43,null,null,null,86]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,10,10,null,null,null,20]
[null,null,"Horses","AUM",null,null,null,null,4,4,4,4,4,4,null,null,null,24]
[null,"Crop Aftermath",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Cows","AUM",null,null,null,null,null,null,null,null,null,null,250,null,null,250,{"$f":"SUM(R63:R66)","v":307}]
[null,null,"Replacement Heifers","AUM",null,null,null,null,null,null,null,null,null,null,43,null,null,43]
[null,null,"Bulls","AUM",null,null,null,null,null,null,null,null,null,null,10,null,null,10]
[null,null,"Horses","AUM",null,null,null,null,null,null,null,null,null,null,4,null,null,4]
[null,"Salt/Mineral",null,"cwt",5,5,5,5,5,5,5,5,5,5,5,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[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",35,null,null,150]
[null,null,"Cows",null,null,3,60]
[null,null,"Bulls",40,null,null,150]
[null,null,"Horses",25,null,null,150]

{"sheet":"Investment","index":2,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 4:  Investment Summary. ",null,null,null,null,null,null,"CCB-CC8-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",40000,0,100,25,{"$f":"D7*0.0036","v":144},{"$f":"(D7-E7)*0.071","v":2839.9999999999995}]
[null,null,"Working Corrals & Pens",15000,3000,100,30,54,{"$f":"(D8-E8)*0.065","v":780}]
[null,null,"Pannels",2000,1000,100,15,7.2,{"$f":"(D9-E9)*0.096","v":96}]
[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,"Feed Wagon",2000,500,100,10,7.2,{"$f":"(D12-E12)*0.13","v":195}]
[null,null,"Calf Table",1500,500,100,10,5.3999999999999995,{"$f":"(D13-E13)*0.13","v":130}]
[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,"Stock Trailer",12000,1000,100,20,43.199999999999996,{"$f":"(D16-E16)*0.081","v":891}]
[]
[null,"Total",null,{"$f":"SUM(D7:D16)","v":127500},null,null,null,{"$f":"SUM(H7:H16)","v":458.99999999999994},{"$f":"SUM(I7:I16)","v":8132.5}]
[]
[]
[null,"Purchased Livestock"]
[null,null,"Horses",{"$f":"2500*4","v":10000},{"$f":"600*4","v":2400},100,10,null,{"$f":"(D22-E22)*0.13","v":988}]
[null,null,"Bulls",{"$f":"10*4000","v":40000},{"$f":"'CC8-Budget'!D12*'CC8-Budget'!J12*10","v":15840},100,4,null,{"$f":"(D23-E23)*0.282","v":6813.119999999999}]
[]
[null,"Total",null,{"$f":"SUM(D22:D23)","v":50000},null,null,null,null,{"$f":"SUM(I22:I23)","v":7801.119999999999}]
[]
[]
[null,"Retained Livestock"]
[null,null,"Beef Replacement Heifers",{"$f":"1200*43","v":51600},{"$f":"43*'CC8-Budget'!D13*'CC8-Budget'!J13","v":40936.000000000007},100,null,null,{"$f":"D29*$K$6","v":2610.96},2]
[null,null,"Beef Cows",{"$f":"250*1500","v":375000},{"$f":"250*'CC8-Budget'!D11*'CC8-Budget'!J11","v":217750},100,null,null,{"$f":"D30*$K$6","v":18975},2]
[]
[null,"Total",null,{"$f":"SUM(D29:D30)","v":426600},null,null,null,null,{"$f":"SUM(I29:I30)","v":21585.96}]
[]
[]
[null,"Machinery and Vehicles"]
[null,null,"80 hpTractor with Loader",40000,8500,100,18,{"$f":"D36*0.0036","v":144},{"$f":"(D36-E36)*0.086","v":2709}]
[null,null,"Pickup 4X4 3/4 ton",20000,5000,100,10,{"$f":"D37*0.0094","v":188},{"$f":"(D37-E37)*0.13","v":1950}]
[null,null,"Pickup 4X4 1 ton",25000,4000,100,8,{"$f":"D38*0.0094","v":235},{"$f":"(D38-E38)*0.155","v":3255}]
[null,null,"ATV",4000,1000,100,10,{"$f":"D39*0.0094","v":37.6},{"$f":"(D39-E39)*0.13","v":390}]
[]
[null,"Total",null,{"$f":"SUM(D36:D39)","v":89000},null,null,null,{"$f":"SUM(H36:H38)","v":567},{"$f":"SUM(I36: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."]

{"sheet":"Vet","index":3,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,"Veterinary Expenses"]
[]
[null,null,null,null,null,null,null,null,null,null,"Monthly Allocation"]
["Vaccine",null,null,"Number of Head","Dosage","Price",null,"Units","$/Unit","Quantity","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
[null,null,"Steer Calves",112]
["Inforce 3",null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",{"$f":"F6/E6","v":1.5497999999999998},null,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K6:V6)*$D$5*I6","v":347.15519999999998}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",{"$f":"F7/E7","v":0.8458},null,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K7:V7)*$D$5*I7","v":189.45920000000001}]
[null,null,"Heifer Calves",113]
["Inforce 3",null,"Respiratory Viral",null,50,77.489999999999995,null,"dose",1.5497999999999998,null,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K9:V9)*$D$8*I9","v":350.25479999999999}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",0.8458,null,null,null,1,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K10:V10)*$D$8*I10","v":191.1508}]
[null,null,"Bangs",null,1,4,null,"dose",4,null,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:V11)*$D$8*I11","v":452}]
[null,null,"Cows",250]
["Pyrfamid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K13:V13)*$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,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K14:V14)*$D$12*I14","v":636.45000000000005}]
["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(K15:V15)*$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,null,{"$f":"SUM(K16:V16)*$D$12*I16","v":493.47499999999997}]
[null,null,"Preg. Check",null,1,4,null,"head",4,null,null,null,null,1,null,null,null,null,null,null,null,null,1000]
[null,null,"Replacement Heifers",43]
["Pyramid 5",null,"Respiratory Viral",null,50,65.290000000000006,null,"dose",1.3058000000000001,null,null,null,null,1,null,null,null,null,null,null,1,null,{"$f":"SUM(K19:V19)*$D$18*I19","v":112.2988}]
["Vira Shield 6 + VL5",null,"Pregnancy Viral",null,50,127.29,null,"dose",2.5458000000000003,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(K20:V20)*$D$18*I20","v":109.46940000000001}]
["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,null,48.430989583333329]
["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,null,84.87769999999999]
[null,null,"Preg. Check",null,1,4,null,"head",4,null,null,null,null,1,null,null,null,null,null,null,null,null,172]
[null,null,"Bulls",10]
["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,null,{"$f":"SUM(K25:V25)*$D$24*I25","v":13.058}]
["Ultrabac 8",null,"8 Way",null,50,42.29,null,"dose",0.8458,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"SUM(K26:V26)*$D$24*I26","v":8.4580000000000002}]
["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,null,11.263020833333332]
[null,null,"Semen/Trich Test",null,1,65,null,"head",65,null,null,null,null,1,null,null,null,null,null,null,null,null,650]
["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,null,19.738999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W6:W29)","v":5497.5654312499983}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W30*1.25","v":6871.9567890624976}]