This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Budget
Budget
Sensitivity
Sheep-Range Enterprise Budget
Lambing on range, lambs sold as feeders
This budget is designed for you to be able to easily adapt it to your specific ranch conditions. You can change any of the values in the blue cells. As you change a value, the budget will automatically update to reflect that change. As market price expectations change, or as costs change, you can alslo update the budget. Clicking on the Sensitivity tab above will display a sensitivity analysis.
Basic Assumptions
Number of ewes and replacement ewes to lamb
Head
Percentage of ewes to wean a lamb
Percent
Percent death loss of ewes
Percent
Cull ewe rate
Percent
Ram replacement rate
Percent
Ewes per ram
Head
Ewes per dog
Head
Number of months grazed
Federal (BLM FS)
Months
Private
Months
Number of months dry lotted
Months
Feed costs at market value
All lambs sold. Some may be sold to another enterprise (Replacement Ewes)
Cost of replacement stock (ewes and rams) @market value
Returns
No. of Head
Weight
Unit
$/lb.
Return/Head
Total Value
Feeder lambs
lbs
Cull ewes
lbs
Cull rams
lbs
Wool - ram, fine wool
lbs
Wool - ram, meat breed
lbs
Wool - ewe
lbs
Total Returns
Operating Costs
Units
Cost per Unit
Units/Head
Total Units
Cost/Head
Total Cost
Feed costs
Alfalfa hay
ton
Feed barley
cwt
Corn
cwt
Salt and minerals
lb
Grazing
*
Federal range
AUM
Private Pasture
AUM
Replacements
Yearling Rams
head
Replacement Ewes
**
head
Other Operating Costs
Hauling
head
Marketing
head
Shearing - ewe
head
Shearing -ram
head
Wool assessment
head
Camp supplies
head
Dogs (food and vet)
dogs/month
ASI lamb checkoff
lb
Veterinary Medicine
head
1.00
Machinery (fuel, lubrication, repair)
total
Vehicles (fuel, repair)
total
Equipment (repair)
total
Housing and Improvements (repair)
total
Hired Labor
month/worker
Interest on Operating Capital
***
Percent
Total Operating Costs
NET RETURN Over Operating Costs
*
The unites per head include rame grazing
**
Ewes are replaced at the cull ewe rate plus death loss rate
***
Interest is calculated at 1/2 of operating cost times the interest rate
Sensitivity Analysis
Net Return Over Operating Costs
$/Head
Returns
10% Lower
5 % Lower
Expected
5% Higher
10% Higher
10% Lower
5 % Lower
Costs
Expected
5% Higher
10% Higher
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print All
Submit