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- Enterprise Budget
Area: Northern Utah
Small-Scale Operation, lambs sold as feeders
This budget is designed for you to be able to easily adapt it to the specific conditions of your operation. 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.
Assumptions
Replacement Rate
USDA Sheep Auction Reports
Lambing Rate
American Sheep Association Prices
Death Loss Rate-Ewes
KSL Classified Prices
Death Loss Rate-Lambs
Sheep--One Ewe Unit
Returns
No. of Head
Weight
Unit
Price
Unit
Total Value
Lambs
lbs
cwt
Cull ewes
lbs
cwt
Wool
lbs
lb
Total Returns
Variable Operating Costs
Feed Costs
Pasture
acres
acre
Pasture fert, misc costs
acres
acre
Corn
bu
bu
Hay
tons
ton
Salt/Mineral
cwt
cwt
Other
Total Feed Costs
Other Variable Operating Costs
Veterinary and health routine expenses
Veterinary and health (other)
Machinery, equipment, fuel, and repairs
Marketing and miscellaneous
Interest on variable costs
months
Labor
hours
hour
Other
Total Variable Operating Costs
Net Return Over Operating Costs
Break Even Analysis
Breakeven Price
Required Premium
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