Beef Cattle Breeding Herd by xiaopangnv

VIEWS: 2 PAGES: 3

									                                            Self Repalcing Beef Gross Margin
                                                                                                                        Date: ############
   Assumptions
                                            Number of Cows                   200       Cows
                                            Marking %                        85%       Cows Joined
                                            Cow Culling Rate %               15%       Total Cows
                                            Bull % of Cows                    3%       of Cows
                                            Overall Death Rate %              1%       of Stock
                                            Vealers Sold                       20%     % Steer Calves
                                            Bulls Replaced Every                 4.0   Years
                                            Bull Purchase Price            $ 2,500     per Bull
                                            Bull Salvage Value             $    800    per Bull
                                            DSE per Cow                          18    DSE per Cow
                                            Area Grazed                         500    Hectares


   Income:                                                                                                                    TOTALS

                    67   Steers @                300         Kg/Head @     $   1.30    per Kilo =       $     390   /Head =   $    26,189
                    52   Heifers @               275         Kg/Head @     $   1.30    per Kilo =       $     358   /Head =   $    18,644
                    30   Cull Cows @             450         Kg/Head @     $   1.30    per Kilo =       $     585   /Head =   $    17,550
                    17   Vealers @               250         Kg/Head @     $   1.30    per Kilo =       $     325   /Head =   $     5,525

                   166        Head           314.1085 Av. Kg/Head @ $ 1.30 Av. per Kilo =               Gross Income          $   67,907

           less:         Transaction Levy    $     5.83 per Head           $   970
                         Commission @              4.5% of Gross Sales     $ 3,056
                         Yard Dues @         $     2.20 per Head           $   366                      Selling Costs              $(4,391)
                                                                                                        Net Income            $   63,516

   Expenses
                         Drench - Heifers               85     Head @      $   0.75    per Dose *             1     doses     $        64
                         Drench - Steers                85     Head @      $   0.75    per Dose *             2     doses     $       128
                         Vaccine                       170     Head @      $   0.75    per Dose *             1     doses     $       128
                         Lice                          200     Head @      $   0.75    per Dose *             1     doses     $       150
                         Growth Promotant               67     Head @      $   0.75    per Dose *             0     doses     $       -
                         Pregnancy Test                200     Head @      $   3.00                                           $       600
                         Frieght                       166     Head @      $   7.00                                           $     1,164
                         Bull Cost                       6     Head @      $    425    Annual Cost per Bull                   $     2,550
                                                                                                        Total Costs           $    4,783

                                                                           Enterprise Gross Margin                            $ 58,733

                                             Gross Margin per Cow                      $     293.67
                                             Gross Margin per DSE                      $      16.31
                                             Gross Margin per Ha                       $     117.47


   Notes
           Assumes Steers & Heifers sold at 12-18 months
           Vealers Sold at 9-12 months
           Bull Cost is average depreciated cost per bull
           Heifer Replacements calculated on replacing culls and deaths




Strategic Business Development                                    10/21/2012                                                         Page 1
         Self Replacing Beef Gross Margin
                Sensitivity Analysis
To Be completed
                Self Replacing Beef Gross Margin
                  Instructions for Spreadsheet
Customise footer for Gross Margin Page using File, Page Setup, Header/Footer

Insert data only in the Yellow areas

Complete Assumptions Table
          Number of Cows is the number of breeding cows in the Herd.
          Marking % is the number of calves marked to Cows joined
          Cow culling rate is the % of cows culled in each year.
                     If cows are culled at 4yo = 25%
                     If cows are culled at 5yo = 20%
                     If cows are culled at 6yo = 16%

             Vealers Sold % is the percentage of steer calves sold post weaning as vealers
             Bulls replacement is how often are bulls replaced.
             Area Grazed is the estimated area grazed by the entire herd.

Insert Average Sale weights for all sale stock. (kg per Head)
Insert Average Sale prices for all sale stock. ($per Kg)
Sale weights & prices should be in the same units eg. Kg liveweight, Kg dressed weight.

Insert Selling Costs
Insert Expense costs

Calculate Gross Margin

Review Sensitivity Analysis

    Adjust    Yellow    variables for What If analysis

Any queries contact: Russell Cummings at MindShop Agribusiness

								
To top