{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CC1-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":"CC1-Budget","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,16,6,17],[45,1,45,2],[18,1,18,2],[17,1,17,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[38,1,38,2],[40,1,40,2],[28,1,28,2],[27,1,27,2],[22,1,22,2],[31,1,31,2],[30,1,30,2],[24,1,24,2],[23,1,23,2],[0,0,0,9],[1,0,1,9],[44,1,44,2],[2,1,2,4],[26,1,26,2],[25,1,25,2],[29,1,29,2],[16,1,16,2],[15,1,15,2],[21,1,21,2],[20,1,20,2],[19,1,19,2],[39,1,39,2]]}
["Table 1:  Cow-Calf Budget, 250 Cow - 2020 ",null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC1-21"]
["Summer on Private Range, Winter Feeding Necessary",null,null,null,null,null,null,null,null,null,"No. of Cows:",250]
[]
[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",575,null,"lbs",null,113,null,1.67,null,{"$f":"C8*G8*I8","v":108508.25},{"$f":"K8/$L$2","v":434.03300000000002},null,null,null,null,250,"Cows"]
[null,"Heifer Calves",525,null,"lbs",null,55,null,1.62,null,{"$f":"C9*G9*I9","v":46777.5},{"$f":"K9/$L$2","v":187.11},null,null,null,null,10,"Bulls"]
[null,"Cull Cows",1200,null,"lbs",null,43,null,0.67,null,{"$f":"C10*G10*I10","v":34572},{"$f":"K10/$L$2","v":138.28800000000001},null,null,null,null,2,"Horses"]
[null,"Cull Bulls",1800,null,"lbs",null,3,null,0.88,null,{"$f":"C11*G11*I11","v":4752},{"$f":"K11/$L$2","v":19.007999999999999},null,null,null,null,0.17,"Cow culling rate"]
[null,"Cull Replacement Heifers",900,null,"lbs",null,10,null,1.1200000000000001,null,{"$f":"C12*G12*I12","v":10080.000000000002},{"$f":"K12/$L$2","v":40.320000000000007},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":204689.75},{"$f":"SUM(L8:L12)","v":818.75900000000013},null,null,null,null,0.9,"Calf crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17,"Heifer culling rate"]
[null,"OPERATING COSTS"]
[null,"Alfalfa/Grass Hay",null,null,"ton",null,434,null,180.25,null,{"$f":"G16*I16","v":78228.5},{"$f":"K16/$L$2","v":312.91399999999999}]
[null,"Feed Barley",null,null,"cwt",null,173,null,30.38,null,{"$f":"G17*I17","v":5255.74},21.022959999999998]
[null,"Private Range",null,null,"AUM",null,2134,null,26,null,55484,221.93600000000001]
[null,"Crop Aftermath",null,null,"AUM",null,303,null,19.5,null,5908.5,23.634]
[null,"Salt/Mineral",null,null,"cwt",null,60,null,15,null,900,3.6]
[null,"Veterinary/Medicine",null,null,"$",null,1,null,{"$f":"Vet!V32","v":7107.775828124999},null,{"$f":"G21*I21","v":7107.775828124999},28.431103312499996]
[null,"Trucking to & from Pasture",null,null,"head",null,250,null,18,null,4500,18]
[null,"Trucking to Market",null,null,"head",null,{"$f":"SUM(G10:G12)","v":56},null,10,null,560,2.2400000000000002]
[null,"Commission",null,null,"head",null,{"$f":"SUM(G10:G12)","v":56},null,{"$f":"(K10+K11+K12)*0.025/(G10+G11+G12)","v":22.055357142857144},null,1235.1000000000001,4.9404000000000003]
[null,"Checkoff/Brand Inspection",null,null,"head",null,{"$f":"SUM(G8:G12)","v":224},null,2.96,null,663.04,2.6521599999999999]
[null,"Hired Labor",null,null,"hour",null,1260,null,18.190000000000001,null,{"$f":"G26*I26","v":22919.4},{"$f":"K26/$L$2","v":91.677600000000012}]
[null,"Owner Labor",null,null,"hour",null,1000,null,30.1,null,{"$f":"G27*I27","v":30100},{"$f":"K27/$L$2","v":120.4}]
[null,"Machinery (Fuel, Oil, Repair)",null,null,"$",null,1,null,{"$f":"3050*(1+42.89%)","v":4358.1450000000004},null,{"$f":"G28*I28","v":4358.1450000000004},{"$f":"K28/$L$2","v":17.432580000000002}]
[null,"Vehicles (Fuel, Repair)",null,null,"$",null,1,null,{"$f":"7000*(1+43.23%)","v":10026.099999999999},null,{"$f":"G29*I29","v":10026.099999999999},{"$f":"K29/$L$2","v":40.104399999999991}]
[null,"Equipment (Repair)",null,null,"$",null,1,null,{"$f":"900*(1+6.37%)","v":957.33},null,{"$f":"G30*I30","v":957.33},{"$f":"K30/$L$2","v":3.8293200000000001}]
[null,"Buildings & Improvements (Repair)",null,null,"$",null,1,null,{"$f":"2700*(1+6.37%)","v":2871.9900000000002},null,2871.9900000000002,11.487960000000001]
[null,"Interest on Operating Capital",null,null,"$",null,{"$f":"SUM(K16:K31)*0.25","v":57768.905207031246},null,0.05,null,2888.4452603515624,11.55378104140625]
[null,"TOTAL OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(K16:K32)","v":233964.06608847654},935.85626435390611]
[]
[null,"NET RETURNS ABOVE OPERATING COSTS",null,null,null,null,null,null,null,null,{"$f":"K13-K33","v":-29274.316088476538},{"$f":"K35/$L$2","v":-117.09726435390616}]
[]
[null,"OWNERSHIP COSTS"]
[null,"Capital Recovery:"]
[null,"     Purchased Livestock ",null,null,"$",null,1,null,{"$f":"Investment!H24","v":7307.119999999999},null,{"$f":"G39*I39","v":7307.119999999999},{"$f":"K39/$L$2","v":29.228479999999998}]
[null,"     Housing & Improvements",null,null,"$",null,1,null,{"$f":"Investment!H17-Investment!H15-Investment!H14-Investment!H13-Investment!H12-Investment!H11","v":8966},null,{"$f":"G40*I40","v":8966},{"$f":"K40/$L$2","v":35.863999999999997}]
[null,"     Machinery",null,null,"$",null,1,null,{"$f":"Investment!H35","v":2709},null,2709,{"$f":"K41/$L$2","v":10.836}]
[null,"     Equipment",null,null,"$",null,1,null,{"$f":"Investment!H11+Investment!H12+Investment!H13+Investment!H14+Investment!H15","v":1572.5},null,1572.5,6.29]
[null,"     Vehicles",null,null,"$",null,1,null,{"$f":"Investment!H36+Investment!H37+Investment!H38","v":5285},null,5285,21.14]
[null,"Interest on Retained Livestock",null,null,"$",null,{"$f":"Investment!C31","v":438600},null,5.0599999999999999E-2,null,22193.16,88.772639999999996]
[null,"Taxes & Insurance",null,null,"$",null,1,null,{"$f":"Investment!G40+Investment!G17","v":1186.2},null,1186.2,4.7448000000000006]
[null,"General Overhead",null,null,"$",null,1,null,5235,null,5235,20.94]
[null,"TOTAL OWNERSHIP COSTS",null,null,null,null,null,null,null,null,{"$f":"SUM(K39:K46)","v":54453.979999999996},217.81591999999998]
[]
[null,"TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+K33+K47","v":288418.04608847655},{"$f":"K49/$L$2","v":1153.6721843539062}]
[]
[null,"NET RETURNS ABOVE TOTAL COSTS",null,null,null,null,null,null,null,null,{"$f":"+K13-K49","v":-83728.296088476549},{"$f":"K51/$L$2","v":-334.91318435390622}]

{"sheet":"Monthly Flows","index":1,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,2,69,3],[65,2,65,3],[62,5,64,5],[66,2,66,3],[67,2,67,3],[68,2,68,3],[62,6,64,6],[61,1,61,4],[62,1,64,1],[62,4,64,4],[62,2,64,3]]}
["Table 2:  Monthly Summary of Returns and Expenses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CCB-CC1-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":108508.25},null,{"$f":"'CC1-Budget'!K8","v":108508.25}]
[null,"Heifer Calves",null,null,null,null,null,null,null,null,null,null,{"$f":"O6","v":46777.5},null,{"$f":"'CC1-Budget'!K9","v":46777.5}]
[null,"Cull Cows",null,null,null,null,null,{"$f":"O7","v":34572},null,null,null,null,null,null,{"$f":"'CC1-Budget'!K10","v":34572}]
[null,"Cull Bulls",null,{"$f":"O8*0.6","v":2851.2},null,null,null,null,null,{"$f":"O8+0.4","v":4752.3999999999996},null,null,null,null,{"$f":"'CC1-Budget'!K11","v":4752}]
[null,"Cull Replacement Heifers",null,null,null,null,null,null,null,null,null,null,{"$f":"O9","v":10080.000000000002},null,{"$f":"'CC1-Budget'!K12","v":10080.000000000002}]
[]
["Total Receipts",null,{"$f":"SUM(C5:C9)","v":0},{"$f":"SUM(D5:D9)","v":2851.2},0,0,0,34572,0,4752.3999999999996,0,0,165365.75,0,{"$f":"'CC1-Budget'!K13","v":204689.75}]
[]
[]
["Operating Inputs:"]
[null,"Alfalfa/Grass Hay",{"$f":"$O$15*0.25","v":19557.125},{"$f":"$O$15*0.25","v":19557.125},19557.125,null,null,null,null,null,null,null,null,19557.125,{"$f":"'CC1-Budget'!K16","v":78228.5}]
[null,"Feed Barley",{"$f":"$O$16/6","v":875.95666666666659},{"$f":"$O$16/6","v":875.95666666666659},875.95666666666659,875.95666666666659,null,null,null,null,null,null,875.95666666666659,875.95666666666659,{"$f":"'CC1-Budget'!K17","v":5255.74}]
[null,"Private Range",null,null,null,{"$f":"$O$17/7","v":7926.2857142857147},{"$f":"'CC1-Budget'!$K$18/7","v":7926.2857142857147},{"$f":"'CC1-Budget'!$K$18/7","v":7926.2857142857147},{"$f":"'CC1-Budget'!$K$18/7","v":7926.2857142857147},{"$f":"'CC1-Budget'!$K$18/7","v":7926.2857142857147},{"$f":"'CC1-Budget'!$K$18/7","v":7926.2857142857147},{"$f":"'CC1-Budget'!$K$18/7","v":7926.2857142857147},null,null,{"$f":"'CC1-Budget'!K18","v":55484}]
[null,"Crop Aftermath",null,null,null,null,null,null,null,null,null,null,{"$f":"O18","v":5908.5},null,{"$f":"'CC1-Budget'!K19","v":5908.5}]
[null,"Salt/Mineral",{"$f":"$O$19/12","v":75},{"$f":"$O$19/12","v":75},75,75,75,75,75,75,75,75,75,75,{"$f":"'CC1-Budget'!K20","v":900}]
[null,"Veterinary/Medicine",{"$f":"O20*0.01","v":71.077758281249984},{"$f":"O20*0.05","v":355.38879140624999},null,{"$f":"O20*0.375","v":2665.4159355468746},{"$f":"O20*0.01","v":71.077758281249984},{"$f":"O20*0.05","v":355.38879140624999},null,{"$f":"O20*0.02","v":142.15551656249997},{"$f":"O20*0.11","v":781.85534109374987},{"$f":"O20*0.375","v":2665.4159355468746},null,null,{"$f":"'CC1-Budget'!K21","v":7107.775828124999}]
[null,"Trucking to & from Pasture",null,null,null,{"$f":"O21/2","v":2250},null,null,null,null,null,{"$f":"O21/2","v":2250},null,null,{"$f":"'CC1-Budget'!K22","v":4500}]
[null,"Trucking to Market",null,{"$f":"O22*0.03333","v":18.6648},null,null,null,{"$f":"O22*0.68","v":380.8},null,{"$f":"O22*0.016666","v":9.3329599999999999},null,null,{"$f":"O22*0.27","v":151.20000000000002},null,{"$f":"'CC1-Budget'!K23","v":560}]
[null,"Commission",null,{"$f":"O23*0.03333","v":41.165883000000001},null,null,null,{"$f":"O23*0.68","v":839.86800000000017},null,{"$f":"O23*0.016666","v":20.584176600000003},null,null,{"$f":"O23*0.27","v":333.47700000000003},null,{"$f":"'CC1-Budget'!K24","v":1235.1000000000001}]
[null,"Checkoff/Brand Inspection",null,5,null,null,null,103,null,3,null,null,496,null,{"$f":"'CC1-Budget'!K25","v":663.04}]
[null,"Hired Labor",{"$f":"$O$25/7","v":3274.2000000000003},{"$f":"$O$25/7","v":3274.2000000000003},{"$f":"$O$25/7","v":3274.2000000000003},{"$f":"$O$25/7","v":3274.2000000000003},null,null,null,null,null,{"$f":"$O$25/7","v":3274.2000000000003},{"$f":"$O$25/7","v":3274.2000000000003},{"$f":"$O$25/7","v":3274.2000000000003},{"$f":"'CC1-Budget'!K26","v":22919.4}]
[null,"Owner Labor",{"$f":"$O$26/12","v":2508.3333333333335},{"$f":"$O$26/12","v":2508.3333333333335},2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,2508.3333333333335,{"$f":"'CC1-Budget'!K27","v":30100}]
[null,"Machinery (Fuel, Oil, Repair)",{"$f":"$O$27/12","v":363.17875000000004},{"$f":"$O$27/12","v":363.17875000000004},363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,363.17875000000004,{"$f":"'CC1-Budget'!K28","v":4358.1450000000004}]
[null,"Vehicles (Fuel, Repair)",{"$f":"$O$28/12","v":835.50833333333321},{"$f":"$O$28/12","v":835.50833333333321},835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,835.50833333333321,{"$f":"'CC1-Budget'!K29","v":10026.099999999999}]
[null,"Equipment (Repair)",{"$f":"$O$29/12","v":79.777500000000003},{"$f":"$O$29/12","v":79.777500000000003},79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,79.777500000000003,{"$f":"'CC1-Budget'!K30","v":957.33}]
[null,"Buildings & Improvements (Repair)",{"$f":"$O$30/12","v":239.33250000000001},239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,239.33250000000001,{"$f":"'CC1-Budget'!K31","v":2871.9900000000002}]
[null,"Interest on Operating Capital",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O31","v":2888.4452603515624},{"$f":"'CC1-Budget'!K32","v":2888.4452603515624}]
[]
["Total Costs",null,{"$f":"SUM(C15:C31)","v":27879.489841614581},28228.63155773958,27808.412083333329,21092.988733165919,12098.49388923363,13706.472922358631,12027.416130952382,12202.488784114883,12809.271472046132,20217.032066499254,15140.464083333334,30696.857343684893,233964.06608847654]
[]
[]
["Net Returns",null,{"$f":"C11-C33","v":-27879.489841614581},-25377.431557739579,-27808.412083333329,-21092.988733165919,-12098.49388923363,20865.527077641367,-12027.416130952382,-7450.0887841148833,-12809.271472046132,-20217.032066499254,150225.28591666667,-30696.857343684893,-29274.316088476538]
[]
[]
[]
[]
[]
[]
["Table 3:  Monthly Feed Requirements. "]
["Feed",null,"Units","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[]
["Feed Barley",null,"cwt",29,29,29,29,null,null,null,null,null,null,29,29]
["Alfalfa/Grass Hay"]
[null,"Cows","ton",94,94,94,null,null,null,null,null,null,null,null,94]
[null,"Replacement Heifers","ton",9,9,9,null,null,null,null,null,null,null,null,9]
[null,"Bulls","ton",5,5,5,null,null,null,null,null,null,null,null,5]
[null,"Horses","ton",1,1,1,null,null,null,null,null,null,null,null,1]
["Private Range"]
[null,"Cows","AUM",null,null,null,250,250,250,250,250,250,250]
[null,"Replacement Heifers","AUM",null,null,null,38,38,38,38,38,38,38]
[null,"Bulls","AUM",null,null,null,14,14,14,14,14,14,14]
[null,"Horses","AUM",null,null,null,2,2,2,2,2,2,2]
["Crop Aftermath",null,"AUM",null,null,null,null,null,null,null,null,null,null,303]
["Salt/Mineral",null,"cwt",5,5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[]
[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,2,180]
[null,"Replacement Heifers",13,null,null,120]
[null,"Cows",25,null,null,120]
[null,"Bulls",30,null,null,120]
[null,"Horses",25,null,null,120]

{"sheet":"Investment","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Table 4:  Investment Summary. ",null,null,null,null,null,null,"CCB-CC1-22"]
[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",70000,0,100,25,{"$f":"C6*0.0036","v":252},{"$f":"(C6-D6)*0.071","v":4970}]
[null,"Hay Shed",30000,5000,100,40,108,{"$f":"(C7-D7)*0.058","v":1450}]
[null,"Grain Storage",8500,1500,100,30,30.599999999999998,{"$f":"(C8-D8)*0.065","v":455}]
[null,"Working Corrals & Pens",20000,3000,100,30,72,{"$f":"(C9-D9)*0.058","v":986}]
[null,"Barn",20000,3000,100,30,72,{"$f":"(C10-D10)*0.065","v":1105}]
[null,"Calf Table",1500,500,100,10,5.3999999999999995,{"$f":"(C11-D11)*0.13","v":130}]
[null,"Squeeze Chute",3500,1000,100,10,12.6,{"$f":"(C12-D12)*0.13","v":325}]
[null,"Vet Equipment",1500,0,100,15,5.3999999999999995,{"$f":"(C13-D13)*0.097","v":145.5}]
[null,"Stock Trailer",5000,1000,100,20,18,{"$f":"(C14-D14)*0.081","v":324}]
[null,"Gooseneck Trailer",12000,4000,100,20,43.199999999999996,{"$f":"(C15-D15)*0.081","v":648}]
[]
["Total",null,{"$f":"SUM(C6:C15)","v":172000},null,null,null,{"$f":"SUM(G6:G15)","v":619.20000000000005},{"$f":"SUM(H6:H15)","v":10538.5}]
[]
[]
["Purchased Livestock"]
[null,"Horses",5000,1200,100,10,null,{"$f":"(C21-D21)*0.13","v":494}]
[null,"Bulls",40000,{"$f":"'CC1-Budget'!Q9*'CC1-Budget'!C11*'CC1-Budget'!I11","v":15840},100,4,null,{"$f":"(C22-D22)*0.282","v":6813.119999999999}]
[]
["Total",null,{"$f":"SUM(C21:C22)","v":45000},null,null,null,null,{"$f":"SUM(H21:H22)","v":7307.119999999999}]
[]
[]
["Retained Livestock"]
[null,"Beef Replacement Heifers",{"$f":"1200*53","v":63600},{"$f":"1035*53","v":54855},100,null,null,{"$f":"C28*$J$5","v":3218.16},2]
[null,"Beef Cows",{"$f":"250*1500","v":375000},{"$f":"250*770","v":192500},100,null,null,{"$f":"C29*$J$5","v":18975},2]
[]
["Total",null,{"$f":"SUM(C28:C29)","v":438600},null,null,null,null,{"$f":"SUM(H28:H29)","v":22193.16}]
[]
[]
["Machinery and Vehicles"]
[null,"Tractor Loader",40000,8500,100,18,{"$f":"C35*0.0036","v":144},{"$f":"(C35-D35)*0.086","v":2709}]
[null,"Pickup 4X4 3/4 ton",20000,5000,100,10,{"$f":"C36*0.0094","v":188},{"$f":"(C36-D36)*0.13","v":1950}]
[null,"Pickup 4X4 1 ton",25000,6000,100,8,{"$f":"C37*0.0094","v":235},{"$f":"(C37-D37)*0.155","v":2945}]
[null,"ATV",4000,1000,100,10,{"$f":"C38*0.0094","v":37.6},{"$f":"(C38-D38)*0.13","v":390}]
[]
["Total",null,{"$f":"SUM(C35:C38)","v":89000},null,null,null,{"$f":"SUM(G35:G37)","v":567},{"$f":"SUM(H35:H38)","v":7994}]
[]
[]
[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."]
[]
[]
[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"]
["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",113]
["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":350.25479999999999}]
["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":191.1508}]
[null,null,"Heifer Calves",113]
["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":350.25479999999999}]
["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":191.1508}]
[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":452}]
[null,null,"Cows",250]
["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":326.45000000000005}]
["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":636.45000000000005}]
["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":281.57552083333331}]
["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":493.47499999999997}]
[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":1000}]
[null,null,"Replacement Heifers",58]
["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":151.47280000000001}]
["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":147.65640000000002}]
["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":65.325520833333329}]
["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":114.48619999999998}]
[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":232}]
[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,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":650}]
["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":19.738999999999997}]
[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":5686.220662499999}]
[]
[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":7107.775828124999}]