Spreadsheet: 171da222-f59f-475c-a0d7-a457eaf86f0c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 | Cow/Calf Enterprise Budget
 | Livestock Data
 | Brood Cows |  |  | 300 | Head
 | Bulls |  |  | 12 | Head
 | Calves Weaned |  |  | 285 | Head
 | [NAME] |  |  | 40 | Head
 | Cows Culled Annually |  |  | 30 | Head
 | Bulls Culled Annually |  |  | 3 | Head
 | Cows Dead |  |  | 4 | Head
 | Replacement [NAME] |  |  | 1 | Head
 | [NAME] |  |  | 0 | Head
 | Years Cows Kept in Herd |  |  | 10 | Years
 | Replacement [NAME] |  |  | 5 | Head
 | Percent [NAME] |  |  | 95 | Percent
 | Cows per Bull Ratio |  |  | 25 | Cows
 | Days from Birth to Weaning |  |  | 160 | Days
 | Average Weaning Weight of Steers Calves |  |  | 500 | Lbs/Head
 | Average Weaning Weight of [NAME] |  |  | 460 | Lbs/Head
 | Average Weight of Steers Yearlings |  |  | 700 | Lbs/Head
 | Average Weight of [NAME] |  |  | 800 | Lbs/Head
 | Average Weight of Culled Heifers |  |  | 700 | Lbs/Head
 | Average Weight of Culled Cows |  |  | 1000 | Lbs/Head
 | Average Weight of Bull |  |  | 2000 | Lbs/Head
 | Years Bull Kept in Herd |  |  | 4 | Years
 | Replacement Bull Cost |  |  | 1200 | $/Head
 | Hay Cost per Ton |  |  | 150 | $/Ton
 | Price of Protein Supplement |  |  | 15 | $/CWT
 | Price of Salt and Minerals |  |  | 9 | $/CWT
 | Interest Paid on Loans |  |  | 6 | Percent
 | Price of Steer Calves |  |  | 1.3 | $/Lb
 | Price of Heifer Calves |  |  | 1.25 | $/Lb
 | Price of Steer Yearlings |  |  | 1.15 | $/Lb
 | Price of Heifer Yearlings |  |  | 1.1 | $/Lb
 | Price of Cull Cows |  |  | 0.9 | $/Lb
 | Price of Cull Bulls |  |  | 0.95 | $/Lb
 | Price of Cull Heifers |  |  | 1 | $/Lb
 | Hay Yield per Acre |  |  | 6 | Tons/Ac
 | Available Forage Sources and Production Estimates (AUMs/Acre)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUMs/
 | No. | Grazed Forage Source |  |  | Cost/Acre | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec | ACRE | Cost/AUM
 | 1 | Native Species Pasture |  |  | 5 | 0 | 0 | 0 | 0.08 | 0.1 | 0.15 | 0.2 | 0.15 | 0 | 0.15 | 0 | 0 | 0.8300000000000001 | 6.024096385542168
 | 2 | Tame Grass Pasture |  |  | 7 | 0 | 0 | 0 | 0 | 0.2 | 0.3 | 0.4 | 0.2 | 0 | 0.1 | 0 | 0 | 1.2 | 5.833333333333332
 | 3 | Grass/Legume Pasture |  |  | 9 | 0 | 0 | 0.2 | 0.3 | 0.4 | 0.5 | 0.3 | 0 | 0 | 0.2 | 0 | 0 | 1.9 | 4.736842105263158
 | 4 | Irrigated Pasture |  |  | 40 | 0 | 0 | 0 | 0.25 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.25 | 0.3 | 0 | 3.3 | 12.12121212121212
 | 5 | Crested Wheatgrass |  |  | 4 | 0 | 0 | 0 | 0.1 | 0.2 | 0.25 | 0.3 | 0.1 | 0 | 0.1 | 0.1 | 0 | 1.15 | 3.478260869565217
 | 6 | Juniper Rangeland |  |  | 2 | 0 | 0 | 0.15 | 0.2 | 0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 4
 | 7 | Mountain Rangeland |  |  | 4.25 | 0 | 0 | 0 | 0.1 | 0.1 | 0.1 | 0.15 | 0.1 | 0.1 | 0 | 0 | 0 | 0.65 | 6.538461538461538
 | 8 | [NAME] |  |  | 4 | 0 | 0 | 0 | 0.25 | 0.5 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 1.25 | 3.2
 | 9 | Grazed Forestland |  |  | 2.5 | 0 | 0 | 0 | 0 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0 | 0 | 0 | 0.5 | 5
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | Forage Sources Utilized
 | No. | Forage Type |  | Acres | Cost/Ac | Cost/AUM
 | 1 | Native Species Pasture |  | 640 | 5 | 6.024096385542168
 | 2 | Tame Grass Pasture |  | 180 | 7 | 5.833333333333332
 | 3 | Grass/Legume Pasture |  | 1500 | 9 | 4.736842105263158
 | 4 | Irrigated Pasture |  | 1280 | 40 | 12.12121212121212
 | Total Forage Cost: |  | 69160
 | Livestock Inventory, Head per Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Breeding Stock Value
 |  |  |  | AUM'S/ | Total |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | VALUE | TOTAL
 | TYPE ANIMAL |  |  | Head | Head/Year | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec | AUY'S | EACH | VALUE
 | Brood Cows |  |  | 1 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 1250 | 375000
 | Bulls |  |  | 1.2 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 1800 | 21600
 | Calves |  |  | 0 | 285 |  |  | 285 | 285 | 285 | 285 | 285 | 285 |  |  |  |  | 285
 | Steer Calves - Weaned |  |  | 0.4 | - |  |  |  |  |  |  |  |  | 142 | 140 |  |  | 142
 | [NAME] |  |  | 0.4 | - | 40 | 40 |  |  |  |  |  |  | 142 | 140 | 40 | 40 | 142
 | [NAME] |  |  | 0.8 | - |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME] |  |  | 0.7 | - |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Replacement Heifers |  |  | 0.8 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 | Horses |  |  | 1.25 | - | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Total AUs Per Month (Head * AU) |  |  |  |  | 366.15 | 366.15 | 350.15 | 350.15 | 350.15 | 350.15 | 350.15 | 350.15 | 463.75 | 462.15 | 366.15 | 366.15 | 921 |  | 396600
 | Forage Availability, AUM'S per Month
 |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | AUMs/AC
 | NO. | TYPE GRAZING |  | Acres |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec | Year
 | 1 | Native Species Pasture |  | 640 |  | 0 | 0 | 0 | 0.08 | 0.1 | 0.15 | 0.2 | 0.15 | 0 | 0.15 | 0 | 0 | 0.8300000000000001
 | 2 | Tame Grass Pasture |  | 180 |  | 0 | 0 | 0 | 0 | 0.2 | 0.3 | 0.4 | 0.2 | 0 | 0.1 | 0 | 0 | 1.2
 | 3 | Grass/Legume Pasture |  | 1500 |  | 0 | 0 | 0.2 | 0.3 | 0.4 | 0.5 | 0.3 | 0 | 0 | 0.2 | 0 | 0 | 1.9
 | 4 | Irrigated Pasture |  | 1280 |  | 0 | 0 | 0 | 0.25 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.25 | 0.3 | 0 | 3.3
 | Summary
 | Total Available AUMs |  |  |  |  | 0 | 0 | 300 | 821.2 | 1340 | 1540 | 1290 | 772 | 640 | 734 | 384 | 0 | 7821.2 | AUMs
 | AUMs Needed |  |  |  |  | 366.15 | 366.15 | 350.15 | 350.15 | 350.15 | 350.15 | 350.15 | 350.15 | 463.75 | 462.15 | 366.15 | 366.15 | 4491.4 | AUMs
 | AUMs Remaining |  |  |  |  | -366.15 | -366.15 | -50.14999999999998 | 471.0500000000001 | 989.85 | 1189.85 | 939.85 | 421.85 | 176.25 | 271.85 | 17.85000000000002 | -366.15
 | Hay Needed (tons) |  |  |  |  | 137.30625 | 137.30625 | 18.80624999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 137.30625 | 430.725 | [NAME]
 | Acres to [NAME] |  |  |  |  | 22.884375 | 22.884375 | 3.134374999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.884375 | 71.78750000000001 | Acres
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Value of an Additional AUM |  |  |  | 32.94924395727111
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Gross Income: |  |  |  | 187150
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Forage Costs: |  |  |  | 39161.76569031252
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AUMS Needed: |  |  |  | 4491.4
 | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Steer | Heifer | Steer | Heifer | Steer | Heifer | Steer | Heifer | Steer | Heifer | Steer | Heifer
 | Days | Weight | Weight | Price | Price | Value | Value | Cost | Cost | Returns | Returns | Days | Days
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 491.8000523010417 | 491.8000523010417 | -491.8000523010417 | -491.8000523010417
 | 40 | 125 | 115 | 0.325 | 0.3125 | 40.625 | 35.9375 | 491.8000523010417 | 491.8000523010417 | -451.1750523010417 | -455.8625523010417
 | 80 | 250 | 230 | 0.65 | 0.625 | 162.5 | 143.75 | 491.8000523010417 | 491.8000523010417 | -329.3000523010417 | -348.0500523010417
 | 120 | 375 | 345 | 0.9750000000000001 | 0.9375 | 365.6250000000001 | 323.4375 | 491.8000523010417 | 491.8000523010417 | -126.1750523010417 | -168.3625523010417
 | 160 | 500 | 460 | 1.3 | 1.25 | 650 | 575 | 491.8000523010417 | 491.8000523010417 | 158.1999476989583 | 83.19994769895828 | 160 | 160
 | 189.2857142857143 | 528.5714285714286 | 508.5714285714286 | 1.278571428571429 | 1.228571428571429 | 675.8163265306123 | 624.8163265306123 | 550.11433054375 | 550.11433054375 | 125.7019959868622 | 74.70199598686224
 | 218.5714285714286 | 557.1428571428571 | 557.1428571428571 | 1.257142857142857 | 1.207142857142857 | 700.408163265306 | 672.5510204081631 | 608.4286087864583 | 608.4286087864583 | 91.97955447884772 | 64.12241162170483
 | 247.8571428571428 | 585.7142857142857 | 605.7142857142857 | 1.235714285714286 | 1.185714285714286 | 723.7755102040816 | 718.204081632653 | 666.7428870291667 | 666.7428870291667 | 57.03262317491487 | 51.46119460348632
 | 277.1428571428571 | 614.2857142857142 | 654.2857142857142 | 1.214285714285714 | 1.164285714285714 | 745.9183673469387 | 761.7755102040816 | 725.057165271875 | 725.057165271875 | 20.86120207506372 | 36.71834493220661
 | 306.4285714285714 | 642.8571428571428 | 702.8571428571428 | 1.192857142857143 | 1.142857142857143 | 766.8367346938775 | 803.265306122449 | 783.3714435145832 | 783.3714435145832 | -16.53470882070576 | 19.8938626078658
 | 335.7142857142857 | 671.4285714285713 | 751.4285714285713 | 1.171428571428571 | 1.121428571428571 | 786.5306122448978 | 842.673469387755 | 841.6857217572915 | 841.6857217572915 | -55.15510951239366 | 0.9877476304634456
 | 365 | 700 | 800 | 1.15 | 1.1 | 804.9999999999999 | 880.0000000000001 | 900 | 900 | -95.00000000000011 | -19.99999999999989
 |  |  |  |  |  |  |  |  | [NAME]: | 158.1999476989583 | 83.19994769895828
 | COW/CALF BUDGET |  |  | 300 | [NAME] |  |  |  | 2014-04-14 00:00:00
 |  | Estimated Annual Costs and Returns
 |  | Oregon
 |  |  |  |  |  |  | Price or | Total | Per Cow
 |  |  |  | Number | Unit | Quantity | Cost/Unit | Amount | Amount
 |  | 1.  [NAME]
 |  | Steer Calves |  | 142 | CWT | 710 | 130 | 92300 | 307.6666666666667
 |  | Heifer Calves |  | 102 | CWT | 469.2 | 125 | 58650 | 195.5
 |  | Steer Yearlings |  | 0 | CWT | 0 | 115 | 0 | 0
 |  | Heifer Yearlings |  | 0 | CWT | 0 | 110 | 0 | 0
 |  | Cull Cows |  | 30 | CWT | 300 | 90 | 27000 | 90
 |  | Cull Heifers |  | 5 | CWT | 35 | 100 | 3500 | 11.66666666666667
 |  | Cull Bull |  | 3 | CWT | 60 | 95 | 5700 | 19
 |  | Total |  |  |  |  |  | 187150 | 623.8333333333334
 |  | 2. Variable Costs
 |  | Forage Grazing Costs |  |  | Ranch |  |  | 69160 | 230.5333333333333
 |  | Hay |  |  | [NAME] | 430.725 | 150 | 64608.75 | 215.3625
 |  | Protein Supplement |  |  | CWT | 215.3625 | 15 | 3230.4375 | 10.768125
 |  | Salt and Minerals |  |  | CWT | 21.53625 | 9 | 193.82625 | 0.6460875
 |  | Vet and Medicine |  |  | Head | 300 | 8 | 2400 | 8
 |  | Hauling |  |  | Head | 140 | 2.75 | 385 | 1.283333333333333
 |  | Sales Commission |  |  | CWT | 150950 | 0.01 | 1509.5 | 5.031666666666666
 |  | Bull Replacement |  |  | Head | 3 | 1200 | 3600 | 12
 |  | Equipment/Building Repair |  |  |  |  |  | 1755 | 5.85
 |  | Interest on Operating Capitol |  |  |  | 73421.256875 | 0.0095 | 697.5019403125001 | 2.325006467708334
 |  | Total Variable Costs |  |  |  |  |  | 147540.0156903125 | 491.8000523010417
 |  | 3.  Income Above Variable Costs |  |  |  |  |  | 39609.98430968748 | 132.0332810322917
 |  | 4.  Fixed Costs
 |  | General Overhead |  |  | Head | 300 | 2 | 600 | 2
 |  | Interest on Livestock Capital |  |  | Ranch | 396600 | 0.06 | 23796 | 79.32
 |  | Interest on Building & Equipment |  |  | Ranch | 3825 | 0.06 | 229.5 | 0.765
 |  | Deprecation on Buildings & Equipment |  |  | Ranch |  |  | 765 | 2.55
 |  | Total Fixed Costs |  |  |  |  |  | 25390.5 | 84.63499999999999
 |  | 5.  Total Costs (Excluding Land & Management) |  |  |  |  |  | 172930.5156903125 | 576.4350523010417
 |  | 6.  Net Returns to Land, Labor, & Management |  |  |  |  |  | 14219.48430968748 | 47.39828103229172
 |  | Investment Items
 |  |  |  |  | Price/ |  | O&M | Percent | Total
 |  | Item |  | Number | Unit | Cost | Factor | Charged | Charged
 |  | Fence |  | 2 | 3000 | 6000 | 0.2 | 50 | 3000
 |  | [NAME] |  | 1 | 4000 | 4000 | 0.2 | 75 | 3000
 |  | Well |  | 1 | 2000 | 2000 | 0.3 | 60 | 1200
 |  | Well Pump |  | 1 | 250 | 250 | 0.3 | 60 | 150
 |  | Mineral Feeders |  | 2 | 150 | 300 | 0.5 | 100 | 300
 |  | Total Buildings and Equipment |  |  |  |  |  |  | 7650
 |  | Total Livestock Investment |  |  |  |  |  |  | 396600
 |  | Total Investment |  |  |  |  |  |  | 404250
 |  | Investment Per Cow |  |  |  |  |  |  | 1347.5
 |  | Value of an Additional AUM |  |  |  |  |  |  | 32.94924395727111