Get documents about "Excel Budgets
Description
Excel Budgets document sample
Document Sample
Beef Cow-Calf (one cow unit)
Ag Decision Maker -- Iowa State University Extension
For more information see Information File B1-21, Livestock Enterprise Budgets.
Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.
Hay and Pasture Calves Fed
Production Efficiencies
Calf weaning rate 92%
Calf death loss 0%
Cow death loss 2%
Cow replacement rate 20%
Income Price Unit Quantity Unit Total
Heifer calves per lb x 1000 lbs x 0.26 head = $0.00
Steer calves per lb x 1100 lbs x 0.46 head = 0.00
Cull cows per lb x 1150 lbs x 0.18 head = 0.00
Gross Income $0.00
Variable Costs
Feed Costs Price Unit Quantity Unit
Pasture $35.00 per acre x 2.5 acres = $87.50
Pasture fert. & misc. costs $20.00 per acre x 2.5 acres = 50.00
Corn $3.50 per bu x 56 bu = 196.00
Modified distiller grain $60.00 per ton x 1.05 tons = 63.00
Salt and minerals $0.09 per lb x 60 lbs = 5.40
Supplement & minerals $0.16 per lb x 128 lbs = 20.48
Alfalfa - brome hay $85.00 per ton x 2.5 tons = 212.50
Corn stalks $3.00 per acre x 4 acres = 12.00
Other 0.00
Total Feed Costs $646.88
Veterinary & health $35.00
Machinery, equipment, fuel & repairs 26.00
Marketing & miscellaneous 25.00
Other 0.00
Interest on variable costs 9% x 9 months = 49.47
Labor $14.00 per hr x 10 hours = 140.00
Total Variable Costs $922.35
Income Over Variable Costs ($922.35)
Fixed Costs
Machinery, equipment, housing & fences $75.10
Interest & insurance on breeding herd 108.20
Bull depreciation/replacement 12.00
Total Fixed Costs $195.30
Total All Costs $1,117.65
Income Over all Costs ($1,117.65)
Breakeven selling price for variable costs (per lb) $1.21
Breakeven selling price for all costs (per lb) $1.47
Version 1.0
Contact: Shane Ellis
Date Printed:
2/2/2011
. . . and justice for all
The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual
orientation, and marital or family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of
discrimination, write USDA, Office of Civil Rights, Room 326-W, Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964.
Issued in furtherance of Cooperative Extension work, Acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture. Jack M. Payne, director, Cooperative Extension
Service, Iowa State University of Science and Technology, Ames, Iowa.
Beef Cow-Calf (one cow unit)
Ag Decision Maker -- Iowa State University Extension
For more information see Information File B1-21, Livestock Enterprise Budgets.
Place the cursor over cells with red triangles to read comments.
Enter your input values in shaded cells.
Hay and Pasture Calves Fed
Production Efficiencies
Calf weaning rate
Calf death loss
Cow death loss
Cow replacement rate
Income Price Unit Quantity Unit Total
Heifer calves per lb x lbs x 0.00 head = $0.00
Steer calves per lb x lbs x 0.00 head = 0.00
Cull cows per lb x lbs x 0.00 head = 0.00
Gross Income $0.00
Variable Costs
Feed Costs Price Unit Quantity Unit
Pasture per acre x acres = $0.00
Pasture fert. & misc. costs per acre x acres = 0.00
Corn per bu x bu = 0.00
Modified distiller grain per ton x tons = 0.00
Salt and minerals per lb x lbs = 0.00
Supplement & minerals per lb x lbs = 0.00
Alfalfa - brome hay per ton x tons = 0.00
Corn stalks per acre x acres = 0.00
Other
Total Feed Costs $0.00
Veterinary & health
Machinery, equipment, fuel & repairs
Marketing & miscellaneous
Other
Interest on variable costs x months = 0.00
Labor per hr x hours = 0.00
Total Variable Costs $0.00
Income Over Variable Costs $0.00
Fixed Costs
Machinery, equipment, housing & fences
Interest & insurance on breeding herd
Bull depreciation/replacement
Total Fixed Costs $0.00
Total All Costs $0.00
Income Over all Costs $0.00
Breakeven selling price for variable costs (per lb) --
Breakeven selling price for all costs (per lb) --
Version 1.0
Contact: Shane Ellis
Date Printed:
2/2/2011
. . . and justice for all
The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual
orientation, and marital or family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of
discrimination, write USDA, Office of Civil Rights, Room 326-W, Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964.
Issued in furtherance of Cooperative Extension work, Acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture. Jack M. Payne, director, Cooperative Extension
Service, Iowa State University of Science and Technology, Ames, Iowa.
Related docs
