Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Excel Budgets by fry81371

VIEWS: 15 PAGES: 2

Excel Budgets document sample

More Info
									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.

								
To top