calculator by xiaoyounan

VIEWS: 9 PAGES: 14

									ncsu

       Agricultural and Resource Economics                                                                                  Agricultural and Resource Economics                                                                              Agricultural and Resource Economics
       P.O. Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: 919 515-3107                                       P.O. Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: 919 515-3107                                   P.O. Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: 919 515-3107
                                                 USING THIS COST & RETURNS CALCULATOR
                                                                                                                                               growth stages that are not sequential, e.g., stage1 (birth to weaning) and stage 4                               The budget shows the returns to land, overhead and management as the "bottom line"
                          Navigation: Buttons are provided for navigate around the dairy heifer cost calculator.                               (breeding to pre-calving) you should run these separately. DELETE the data for the                               because this is an enterprise budget, not a whole farm budget. A summary of cost per
                          Click on a button to select an individual component of the calculator. The Return Arrow in                           stages you are NOT interested in. This step is necessary for the summary budget to be                            head, per head per day and per pound of gain is provided, as an aid to decision making.
                          the top right corner of each page will return you to the main menu or to the previous                                accurate. Once this step is complete, return to the main menu. Use the buttons on the                            A blank Alt. (Alternative) Value column is provided along with the figures generated by this
                                screen. Please use the Print button at the top of each page if you wish to print that                                main menu to select the growth stages you are interested in. Each stage has an                                   cost calculator. This is intended to assist in making adjustments or notes using a
                                page. Do use the print command on your spreadsheet menu. The Question Mark                                           input worksheet and a budget for that stage. Also, select the "Buildings and                                     printed version of the output and it cannot be accessed by computer.
                                button at the top of a page will bring up a screen with additional information about                                 Equipment" button to enter information on the items needed for heifer raising.
                                that part of the cost calculator.                                                                                                                                                                                                     If you are creating budgets for more than one growth stage, repeat the input data
                                                                                                                                                     Enter your own information in worksheets identified as "Inputs for Stage….." The                                 entry for each stage. When all stages are complete, you can obtain a summary
                                Creating Your Own Heifer Budget.                                                                                     data entry sections have a brown background and white lettering. Enter your data in                              budget. Use the "Return" button to get back to the main menu and select the
                           Before making changes to the original version of this spreadsheet, you may wish to save                              the white cells with a blue font. Note that the descriptions of the items listed in these                        "Summary Budget." This summary budget can be viewed or printed. The "Sensitivity
                           it and use a different file name for all new budgets you develop.                                                    sections are protected and cannot be changed. Enter a zero for items that do not apply.                          Analysis" button at the top of the Summary Budget page will take you to a table that
                                                                                                                                                You may find it convenient to print this section to assist you in collecting the necessary                       shows the impact of a 10 percent change in revenue or cost on the total returns to land,
                           It is helpful to begin by naming, numbering and describing your budget. From the Main                                information. If so, use the Print button at the first row of the worksheet.                                      overhead and management. This information is useful in assessing the financial risk
                               Menu, click on the "Start" button to do this. Replace or edit the text in the white cells.                                                                                                                                           associated with variations from projected performance.
                               Next, identify the growth stages you plan to develop budgets for. You may select any                                A budget for a particular growth state is created once you have entered all the
                               number of stages as long as they are sequential. If you are interested in (continue…)                              necessary information. Use the "Enterprise Budget" button to see or print this budget.                                                                                Good Luck !!!!!!!
                        Agricultural and Resource Economics                                                                                                             Agricultural and Resource Economics
                        Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: (919) 515-3107                                                                     Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: (919) 515-3107

                                                       OVERVIEW
                                                       This cost calculator provides the user a tool to estimate the costs and returns of
                                                       raising dairy heifers. Costs and returns can be calculated for up to four stages of
                                                       growth. An example is provided for large dairy breeds raised on a corn silage and
                                                       hay based diet to calve at 24 months weighing 1,350 lb. There is a separate data input
                                                       section and budget for each growth stage. These tables can be printed separately.
                                                       The user can select one or more contiguous stages. Costs and returns for multiple
                                                       stages will be accumulated into a summary enterprise budget.

                                                       CAUTION. This budget spreadsheet is distributed on an "as is" basis and the
                                                       user must assume all responsibility for any budgets that are created using this
                                                       spreadsheet and for any decisions based on this information.




by Geoff Benson, Ph.D., and Brinton Hopkins, Ph.D.                                                                                              by Geoff Benson, Ph.D., and Brinton Hopkins, Ph.D.
           Agricultural and Resource Economics
           Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: (919) 515-3107

                                               Costs and returns can be calculated for up to four stages of growth. An example
                                               is provided for large dairy breeds raised on a corn silage and hay based diet to
                                               calve at 24 months weighing 1,350 lb. There is a separate data input section and
                                               budget for each growth stage. These tables can be printed separately. The user
                                               can select one or more contiguous stages. Clear the data from the example
                                               budget for any stages for which budget are NOT needed by clicking
                                               on the corresponding buttons. Costs and returns for multiple stages will be
                                               accumulated into a summary enterprise budget.

                                               Modify the budget name, number and description below.

                                               Name:        DAIRY HEIFERS              Budget #: 10-4


Estimated annual revenue, operating expenses, ownership expenses and returns to land, overhead and
management for rearing large breed dairy heifers to calve at 24-mo. at 1,350 lb., using corn silage and hay.
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     BUILDINGS & EQUIPMENT INVESTMENT                                                                                                                                       BUILDINGS & EQUIPMENT OWNERSHIP COST ALLOCATION
BUILDINGS & EQUIPMENT INVESTMENT                                                                                                                                  BUILDINGS & EQUIPMENT OWNERSHIP COST ALLOCATION                                                                                                            BUILDINGS & EQUIPMENT REPAIR COSTS & COST ALLOCATION                                                                                                    DAIRY HEIFERS                                                                                                                                            Budget 10-4   DAIRY HEIFERS                                                                                                                       Budget 10-4
DAIRY HEIFERS                                                                                                                                       Budget 10-4   DAIRY HEIFERS                                                                                                                                Budget 10-4   DAIRY HEIFERS                                                                                                                          Budget 10-4      Initial inv estment in specialized buildings and equipment, and annual ownership costs f or rearing dairy heif ers                                          ########   Allocation of annual ownership costs of specialized buildings and equipment to heif er growth stages.                                27-Dec-11
Initial inv estment in specialized buildings and equipment, and annual ownership costs f or rearing dairy heif ers                                   27/Dec/11    Allocation of annual ownership costs of specialized buildings and equipment to heif er growth stages.                                           ########   Repair costs f or specialized buildings and equipment f or rearing dairy heif ers                                                       27-Dec-11
GENERAL INFORMATION                                                                                                                                               GENERAL INFORMATION                                                                                                                                           ITEM                                              REPAIR REPAIR STAGE 1          STAGE 2   STAGE 3   STAGE 4    COMMENTS                                          This worksheet calculates the cost of owning specif ic items of equipment and building used in heif er raising. It also prov ides
    INTEREST RATE, Annual                      9.00%             INSURANCE, % of $Value                   1.00%      PROPERTY TAX, % of $Value            0.60%       INTEREST RATE:                               9.00%                  INSURANCE:               1.00%                    PROPERTY TAX:            0.60%                                                     % of cost   COST      SHARE       SHARE     SHARE     SHARE                                                     inf ormation f or estimating repair costs in a related worksheet. Enter y our inf ormation in the unprotected (white) cells. Note that                                         The total ownership cost f or each item is transf erred f rom the Buildings and Inv estment worksheet. The user
BUILDINGS & EQUIPMENT                                                                                                                                             BUILDINGS & EQUIPMENT                                                                                                                                      1   Calf housing                                     2%         $75        0%          0%       0%         0%                                                     some of the descriptions and all of the calculations are protected and cannot be changed. Enter a zero f or items that do not apply .                                      specif ies the percentage share to be allocated to the indiv idual growth stages of interest and the percentages
   ITEM                                     REPAIR HEIFER LIFE              INITIAL    SALVAGE       DEPREC- INTEREST          INSUR-      PROP.        TOTAL        ITEM                                           TOTAL    STAGE 1      STAGE 2      STAGE 3     STAGE 4     COMMENTS                              TOTAL   2   Cattle housing & f eed bunk                      2%        $300        0%          0%       0%         0%                                                     General Inf ormation:                                                                                                                                                      f or each row should add to 100%. The allocated share of these ownership cost is transf erred automatically to
                                            % of cost SHARE YEARS            COST       VALUE          IATION                    ANCE      TAXES                                                                    COST     SHARE        SHARE        SHARE       SHARE                                                     3   Fence-line f eed bunk with pad                   2%         $80        0%          0%       0%         0%     Based   on   day s of use                       Interest Rate -- If y ou borrow money to operate the f arm, use the current rate on borrowed money . Use the interest rate (earnings)                                      the appropriate budgets. The comment column allows the user to describe the basis f or making these
1   Calf housing                               2%      100%   10             $3,750         $0            $375    $169             $19        $11         $574    1   Calf housing                                   $574                                                                                              0%    4   Fencing                                          8%        $120        0%          0%       0%         0%     Based   on   day s on pasture                   f oregone on f arm inv estments if the enterprise is owner f inanced.                                                                                                      allocations, if desired.
2   Cattle housing & f eed bunk                2%      100%   15            $15,000         $0          $1,000    $675             $75        $45       $1,795    2   Cattle housing & f eed bunk                  $1,795                                                                                              0%    5   Water supply                                     4%         $30        0%          0%       0%         0%     Based   on   day s on pasture                   Insurance and property tax rates -- Use the current rates in ef f ect f or the f arm.
3   Fence-line f eed bunk with pad             2%      100%   15             $4,000         $0            $267    $180             $20        $12         $479    3   Fence-line f eed bunk with pad                 $479                                                      Based   on   day s of use               0%    6   Horizontal silo                                  2%        $140        0%          0%       0%         0%     Based   on   lbs silage f ed                    Main Table:
4   Fencing                                    8%      100%   15             $1,500         $0            $100     $68              $8         $5         $180    4   Fencing                                        $180                                                      Based   on   day s on pasture           0%    7   Hay storage                                      2%        $340        0%          0%       0%         0%     Based   on   lbs hay f ed                       List the items required f or the heif er enterprise, including specialized items used only f or heif ers and items that are shared with
5   Water supply                               4%      100%   15               $750         $0             $50     $34              $4         $2          $90    5   Water supply                                    $90                                                      Based   on   day s on pasture           0%    8   Corral                                           2%         $45        0%          0%       0%         0%     Based   on   day s in periods                   other f arm enterprises. Existing and planned new inv estment should be included to giv e a true cost of the heif er enterprise.
6   Horizontal silo                            2%       40%   15            $17,500         $0            $467    $315             $35        $21         $838    6   Horizontal silo                                $838                                                      Based   on   lbs silage f ed            0%    9   Pickup truck                                     4%        $192        0%          0%       0%         0%     Based   on   day s in periods                   Sev eral items are listed as a guide and the "Other" rows allow the user to include additional items.
7   Hay storage                                2%      100%   20            $17,000         $0            $850    $765             $85        $51       $1,751    7   Hay storage                                  $1,751                                                      Based   on   lbs hay f ed               0%    #   Tractor                                          4%        $670        0%          0%       0%         0%     Based   on   day s hay &silage f ed             Repair, % of cost: The percentages in this column are used to calculate the repair costs associated with these items. The
8   Corral                                     2%      100%   15             $2,250         $0            $150    $101             $11         $7         $269    8   Corral                                         $269                                                      Based   on   day s in periods           0%    #   Large round bale handler                         2%         $15        0%          0%       0%         0%     Based   on   day s hay f ed                     percentages shown are those proposed by the American society of Agricultural Engineers but the user can modif y these. The
9   Pickup truck                               4%       30%    8            $16,000     $4,034            $449    $270             $30        $18         $767    9   Pickup truck                                   $767                                                      Based   on   day s in periods           0%    #   Silage/f eeder wagon                             2%         $73        0%          0%       0%         0%     Based   on   day s silage f ed                  percentages are applied to the dollar v alue shown in the "Initial cost" column to estimate total annual repair costs.
#   Tractor                                    4%       60%   20            $27,900     $6,151            $652    $919            $102        $61       $1,735    #   Tractor                                      $1,735                                                      Based   on   day s hay &silage f ed     0%    #   Nutrient management                              2%         $60        0%          0%       0%         0%     Based   on   day s in periods                   Heif er Share: These percentages are used to allocate a portion of the y early ownership and repair costs to the heif ers. The user
#   Large round bale handler                   2%       50%   10             $1,500         $0             $75     $34              $4         $2         $115    #   Large round bale handler                       $115                                                      Based   on   day s hay f ed             0%    #   Other                                            0%         $0         0%          0%       0%         0%                                                     can modif y these percentages to f it the f arm situation.
#   Silage/f eeder wagon                       2%       35%   12            $10,400       $825            $279    $177             $20        $12         $487    #   Silage/f eeder wagon                           $487                                                      Based   on   day s silage f ed          0%    #   Other                                            0%         $0         0%          0%       0%         0%                                                     Lif e, Y ears: The y ears specif ied should relate to the economic lif e or planning horizon rather than the phy sical lif e, particularly f or
#   Nutrient management                        2%      100%   15             $3,000         $0            $200    $135             $15         $9         $359    #   Nutrient management                            $359                                                      Based   on   day s in periods           0%            Total                                                 $2,139       $0          $0        $0        $0                                                     buildings
#   Other                                      0%       0%     0                 $0         $0              $0      $0              $0         $0           $0    #   Other                                            $0                                                                                              0%                                                                                                                                                                      Cost: The initial cost should be the f ull cost of the item, including the v alue of any trade-in item. The salv age v alue is the estimated
#   Other                                      0%       0%     0                 $0         $0              $0      $0              $0         $0           $0    #   Other                                            $0                                                                                              0%                                                                                                                                                                      sale or market v alue at the end of the period specif ied as the lif e of the asset.
        Total                                                              $120,550    $11,010          $4,914  $3,842            $427       $256       $9,438            Total                                    $9,438        $0          $0           $0              $0                                                                                                                                                                                                                      The annual cost of owning each item is calculated f rom the data prov ided. Indiv idual columns show the Depreciation, Interest,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Insurance and Property tax costs. Depreciation is calculated as the dif f erence between the initial cost and the salv age v alue,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               div ided by the y ears of lif e. The interest charge is calculated on the av erage inv estment, i.e., on (Initial cost + Salv age v alue)/2.
BUILDINGS & EQUIPMENT REPAIR COSTS & COST ALLOCATION
DAIRY HEIFERS                                                                                                                    Budget 10-4
Repair costs f or specialized buildings and equipment f or rearing dairy heif ers                                                 27-Dec-11



                  The estimated repair cost f or each item is calculated f rom the inf ormation prov ided in the Buildings and
               Inv estment worksheet and the Buildings and Inv estment Ownership Cost Allocation worksheet. This
               worksheet is prov ided f or inf ormation only and cannot be directly modif ied by the user. Any changes
               must be made on the prev ious worksheets. The allocated share of the repair costs is transf erred
               automatically to the appropriate budgets.
INPUTS FOR STAGE 1: BIRTH TO WEANING                                                                                               BUDGET FOR STAGE 1: BIRTH TO WEANING                                                                                                         STAGE 1: BIRTH TO WEANING
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                 Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                           Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                                Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .      27-Dec-11    management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                 27-Dec-11   management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                     27-Dec-11
GENERAL INFORMATION                                                                                                                ITEM                                                           UNITS                   PRICE            QUANTITY      VALUE    ALT. VALUE
Date of budget                                  ########                      Breed of heif er
Number of animals in group at start                                           Number of day s in period                            GROSS REVENUE:                                                                                                                                                  The input worksheet is div ided into sections and the user must input data in all of the cells prov ided.
Value at start of period, $/head                                              Weight at start of period                            1. Weaned heif er calv es                                       Head                  $0.00                 0.0           $0    __________                  Existing data can be ov erwritten.
Value at end of period, $/head                                                Weight at end of period                              2. Cull heif ers                                                Head                  $0.00                 0.0           $0    __________                      The General Inf ormation section includes animal numbers and estimated weights, v alues, and death and
Value of cull, $/head                                                         Death loss this period, as decimal                                                                                                                                        _______                                culling losses. The av erage daily gain is calculated as a check that the assumed change in weight is
Av erage daily gain, lb. (Calculated)            #DIV/0!                      Culling rate this period, as decimal                 3.    Total rev enue                                                                                                      $0    __________                  reasonable f or the particular growth stage and ration. If the user is interested in a budget f or a single
MILK REPLACER & STARTER                                                                                                                                                                                                                                                                        growth stage, he or she should enter the number of head at the beginning of the stage. If the heif ers will be
Milk replacer f ed, lb/head/day                                               Calf starter eaten,lb/head/day                       OPERATING EXPENSES:                                                                                                                                         kept through an additional stage or stages, the Cost Calculator will carry f orward the liv estock numbers
Cost of replacer, $/lb.                                                       Cost of starter, $/lb.                               4. Day old calv es                                              Head                  $0.00                   0           $0    __________                  f rom one stage to the next automatically . Howev er, it cannot accommodate the addition of more animals
Number of day s replacer is f ed                                              Number of day s starter is f ed                      5. Milk replacer                                                lb.                   $0.00                   0           $0    __________                  with those being carried ov er.
CONCENTRATE, HAY & PASTURE                                                                                                         6. Calf starter f eed                                           lb.                   $0.00                   0           $0    __________                      There are two sections related to the heif er diet. These will accommodate dif f erent ty pes of supplementary
Other conc. eaten, lb/head/day                                                Number of day s on pasture                           7. Concentrate f eed                                            lb.                   $0.00                0.00           $0    __________                  f eeds and f orages. Enter zeros f or f eeds that do not apply . Note that the quantities asked f or are the
Cost of concentrates, $/lb                                                    Hay eaten, lb./head/day                              8. Hay                                                          Tons, as f ed         $0.00                0.00           $0    __________                  amounts eaten, not of f ered, and there is a separate entry f or an allowance f or waste.
Starter & conc. waste, % of amt of f ered                                     Cost of hay , $/ton as f ed                          9. Pasture                                                      Tons, as f ed         $0.00                0.00           $0    __________                      The Other section includes a v ariety of other costs, including interest and labor. Interest should be charged
Number of day s concentrate is f ed                                           Number of day s hay is f ed                          10. Other f eed                                                                                                           $0    __________                  at current loan rates if the f arm borrows money or at the interest rate f oregone on f arm inv estments if the
Pasture eaten, lb./head/day                                                   Hay waste, % of amount of f ered                     11. Bedding                                                     Cwt.                  $0.00                 0.0           $0    __________                  enterprise is owner f inanced. A labor charge is recommended ev en when the work is being perf ormed by
Cost of pasture, $/ton eaten.                                                                                                      12. Vet and medication                                          Head                  $0.00                 0.0           $0    __________                  unpaid f amily labor, using a rate that is comparable to the cost hired labor, including benef its.
OTHER                                                                                                                              13. Misc.                                                       Head                  $0.00                 0.0           $0    __________
Interest rate, percent per y ear                                              Labor, minutes/head/day                              14. Utilities, f uel and oil                                    Head                  $0.00                 0.0           $0    __________
Bedding used, cwt/head.                                                       Labor cost or charge, $ per hour                     15. Supplies                                                    Head                  $0.00                 0.0           $0    __________
Cost of bedding, $/cwt.                                                       Utilities, f uel and oil, $/head                     16. Repairs                                                                                                               $0    __________
Vet and medication, $/head                                                    Miscellaneous, $/head                                17. Death loss and culling                                                                                                $0    __________
Supplies, $/head                                                                                                                   18. Interest on operating capital                                                                                         $0    __________
                                                                                                                                                                                                                                                        _______
                                                                                                                                   19.    Total operating expense                                                                                            $0    __________
                                                                                                                                                                                                                                                        _______
                                                                                                                                   20. Returns ov er operating expenses                                                                                      $0    __________

                                                                                                                                   OWNERSHIP EXPENSES:
                                                                                                                                   21. Specialized cattle f acilities
                                                                                                                                       machinery and equipment                                                                                               $0    __________
                                                                                                                                                                                                                                                        _______
                                                                                                                                   22. Returns to land, ov erhead, labor and management                                                                      $0    __________

                                                                                                                                   23. Labor f or liv estock                                       Hours                 $0.00                 0.0           $0    __________
                                                                                                                                                                                                                                                        _______
                                                                                                                                   24.    Returns to land, ov erhead and management                                                                          $0    __________

                                                                                                                                   25. Total cost per head,this stage, including initial heif er v alue                                               #DIV/0!      __________
.                                                                                                                                  26. Cost per head excluding initial v alue of heif er                                                              #DIV/0!      __________
                                                                                                                                   27. Cost per pound of gain f or this stage                                                                         #DIV/0!      __________
                                                                                                                                   28. Cost per head per day f or this stage                                                                          #DIV/0!      __________
                                                                                                                                   Av erage daily gain, lb/head/day =                                #DIV/0!

                                                                                                                                   The example budget was prepared by
                                                                                                                                   G.A. Benson, Extension Economist, NCSU; Telephone: (919) 515-5184
                                                                                                                                   B.A. Hopkins, Extension Dairy Specialist, NCSU; Telephone (919) 515-7592
STAGE 1: BIRTH TO WEANING
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                             Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                    0-Jan-00



                  Use the print button in the top nav igation bar to print this budget.

                  The costs and returns in this budget are calculated f orm the inf ormation entered on the input screen. Note
               that the budget calculations include death losses as a cost.

                  The budget shows the returns to land, ov erhead and management as the "bottom line" because this is an
               enterprise budget, not a whole f arm budget. A summary of cost per head, per head per day and per pound
               of gain is prov ided, as an aid to decision making. A blank Alt. (Alternativ e) Value column is prov ided along
               with the f igures generated by this cost calculator. This is intended to assist in making adjustments or notes
                using a printed v ersion of the output and it cannot be accessed by computer.
INPUTS FOR STAGE 2: WEANING TO 6 MONTHS                                                                                                   BUDGET FOR STAGE 2: WEANING TO 6 MONTHS                                                                                                         STAGE 2: WEANING TO 6 MONTHS
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                        Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                              Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                                Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .             27-Dec-11    management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                    27-Dec-11   management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                     27-Dec-11
GENERAL INFORMATION                                                                                                                       ITEM                                                           UNITS                   PRICE            QUANTITY      VALUE       ALT. VALUE
Date of budget                                            12/27/2011                 Breed of heif er
Number of animals in group at start (sse f ootnotes):                                Number of day s in period                            GROSS REVENUE:                                                                                                                                                    The input worksheet is div ided into sections and the user must input data in all of the cells prov ided.
--Number of head carried f orward f rom prev . stage a              0               Weight at start of period                             1.    Heif er calv es                                           Head                  $0.00                 0.0              $0    __________                  Existing data can be ov erwritten.
--OR Number of animals in group at start b                                          Weight at end of period                               2. Cull heif ers                                                Head                  $0.00                 0.0           $0       __________                      The General Inf ormation section includes animal numbers and estimated weights, v alues, and death and
Value at start of period, $/head                                                    Death loss this period, as decimal                                                                                                                                         _______                                   culling losses. The av erage daily gain is calculated as a check that the assumed change in weight is
Value at end of period, $/head                                                      Culling rate this period, as decimal                  3.    Total rev enue                                                                                                      $0       __________                  reasonable f or the particular growth stage and ration. If the user is interested in a budget f or a single
Value of cull, $/head                                                               Av erage daily gain, lb. (Calculated)      #DIV/0!                                                                                                                                                                   growth stage, he or she should enter the number of head at the beginning of the stage. If the heif ers will be
CALF STARTER AND GROWER                                                                                                                   OPERATING EXPENSES:                                                                                                                                            kept through an additional stage or stages, the Cost Calculator will carry f orward the liv estock numbers
Calf starter eaten,lb/head/day                                                      Grower conc. eaten, lb./head/day                      4. Weaned calv es                                               Head                  $0.00                 0.0           $0       __________                  f rom one stage to the next automatically . Howev er, it cannot accommodate the addition of more animals
Cost of starter, $/lb.                                                              Cost of grower, $/ton                                 5. Calf starter f eed                                           lb.                   $0.00                   0           $0       __________                  with those being carried ov er.
Number of day s starter is f ed                                                     Number of day s grower is f ed                        6. Grower concentrate                                           Tons                  $0.00                 0.0           $0       __________                      There are two sections related to the heif er diet. These will accommodate dif f erent ty pes of supplementary
CONCENTRATE, HAY, SILAGE & PASTURE                                                                                                        7. Other concentrate f eed                                      Tons                  $0.00                 0.0           $0       __________                  f eeds and f orages. Enter zeros f or f eeds that do not apply . Note that the quantities asked f or are the
Other concentrates eaten, lb/head/day                                               Number of day s other hay is f ed                     8. Hay                                                          Tons, as f ed         $0.00                 0.0           $0       __________                  amounts eaten, not of f ered, and there is a separate entry f or an allowance f or waste.
Cost of other concentrates, $/ton                                                   Hay waste, % of amount of f ered                      9. Other Hay                                                    Tons, as f ed         $0.00                 0.0           $0       __________                      The Other section includes a v ariety of other costs, including interest and labor. Interest should be charged
Number of day s concentrate is f ed                                                 Silage eaten, lb./head/day                            10. Corn silage                                                 Tons, as f ed         $0.00                 0.0           $0       __________                  at current loan rates if the f arm borrows money or at the interest rate f oregone on f arm inv estments if the
Grain waste, % of amount of f ered                                                  Cost of silage, $/ton as f ed                         11. Pasture                                                     Tons, as f ed         $0.00                 0.0           $0       __________                  enterprise is owner f inanced. A labor charge is recommended ev en when the work is being perf ormed by
Hay eaten, lb./head/day                                                             Number of day s silage is f ed                        11. Bedding                                                     cwt.                  $0.00                 0.0           $0       __________                  unpaid f amily labor, using a rate that is comparable to the cost hired labor, including benef its.
Cost of hay , $/ton as f ed                                                         Silage waste, % of amount of f ered                   13. Vet and medication                                          Head                  $0.00                 0.0           $0       __________
Number of day s hay is f ed                                                         Pasture eaten, lb./head/day                           14. Misc                                                        Head                  $0.00                 0.0           $0       __________
Other hay eaten, lb./head/day                                                       Cost of pasture, $/ton eaten.                         15. Utilities, f uel and oil                                    Head                  $0.00                 0.0           $0       __________
Cost of other hay , $/ton as f ed                                                   Number of day s on pasture                            16. Supplies                                                    Head                  $0.00                 0.0           $0       __________
OTHER                                                                                                                                     17. Repairs                                                                                                               $0       __________
Interest rate, percent per y ear                                                    Labor, minutes/head/day                               18. Death loss and culling                                                                                                $0       __________
Bedding used, cwt/head.                                                             Labor cost or charge, $ per hour                      19. Interest on operating capital                                                                                         $0       __________
Cost of bedding, $/cwt.                                                             Utilities, f uel and oil, $/head                                                                                                                                           _______
Vet and medication, $/head                                                          Miscellaneous, $/head                                 20.     Total operating expense                                                                                           $0       __________
Supplies, $/head                                                                                                                                                                                                                                               _______
a
Number of head is transf erred automatically f rom the prev ious stage                                                                    21. Returns ov er operating expenses                                                                                         $0    __________
b
Enter number of head when there is no carry ov er f rom the prev ious stage.
                                                                                                                                          OWNERSHIP EXPENSES:
                                                                                                                                          22. Specialized cattle f acilities                                                                                                 __________
                                                                                                                                              machinery and equipment                                                                                               $0       __________
                                                                                                                                                                                                                                                               _______
                                                                                                                                          23. Returns to land, ov erhead, labor and management                                                                      $0       __________

                                                                                                                                          24. Labor f or liv estock                                       Hours                 $0.00                 0.0           $0       __________
                                                                                                                                                                                                                                                               _______
                                                                                                                                          25.     Returns to land, ov erhead and management                                                                         $0       __________

                                                                                                                                          25. Total cost per head, this stage, including initial heif er v alue                                              #DIV/0!         __________
                                                                                                                                          26. Cost per head excluding initial v alue of heif er                                                              #DIV/0!         __________
                                                                                                                                          27. Cost per pound of gain f or this stage                                                                         #DIV/0!         __________
                                                                                                                                          28. Cost per head per day f or this stage                                                                          #DIV/0!         __________
                                                                                                                                          Av erage daily gain, lb/head/day =                                #DIV/0!

                                                                                                                                          The example budget was prepared by
                                                                                                                                          G.A. Benson, Extension Economist, NCSU; Telephone: (919) 515-5184
                                                                                                                                          B.A. Hopkins, Extension Dairy Specialist, NCSU; Telephone (919) 515-7592
STAGE 2: WEANING TO 6 MONTHS
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                             Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                    0-Jan-00



                  Use the print button in the top nav igation bar to print this budget.


                  The costs and returns in this budget are calculated f orm the inf ormation entered on the input screen. Note
               that the budget calculations include death losses as a cost.

                  The budget shows the returns to land, ov erhead and management as the "bottom line" because this is an
               enterprise budget, not a whole f arm budget. A summary of cost per head, per head per day and per pound
               of gain is prov ided, as an aid to decision making. A blank Alt. (Alternativ e) Value column is prov ided along
               with the f igures generated by this cost calculator. This is intended to assist in making adjustments or notes
                using a printed v ersion of the output and it cannot be accessed by computer.
INPUTS FOR STAGE 3: SIX MONTHS TO PRE-BREEDING                                                                                               BUDGET FOR STAGE 3: SIX MONTHS TO PRE-BREEDING                                                                                                  STAGE 3: SIX MONTHS TO PRE-BREEDING
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                           Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                              Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                                Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                27-Dec-11    management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                    27-Dec-11   management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                     27-Dec-11
GENERAL INFORMATION                                                                                                                          ITEM                                                           UNITS                   PRICE            QUANTITY      VALUE       ALT. VALUE
Date of budget                                            12/27/2011                 Breed of heif er
Number of animals in group at start (sse f ootnotes):                                Number of day s in period                               GROSS REVENUE:                                                                                                                                                    The input worksheet is div ided into sections and the user must input data in all of the cells prov ided.
--Number of head carried f orward f rom prev . stage a            0.0               Weight at start of period                                1. Open heif ers                                                Head                  $0.00                 0.0              $0    __________                  Existing data can be ov erwritten.
--OR Number of animals in group at start b                                          Weight at end of period                                  2. Cull heif ers                                                Head                  $0.00                 0.0           $0       __________                      The General Inf ormation section includes animal numbers and estimated weights, v alues, and death and
Value at start of period, $/head                                                    Death loss this period, as decimal                                                                                                                                            _______                                   culling losses. The av erage daily gain is calculated as a check that the assumed change in weight is
Value at end of period, $/head                                                      Culling rate this period, as decimal                     3.    Total rev enue                                                                                                      $0       __________                  reasonable f or the particular growth stage and ration. If the user is interested in a budget f or a single
Value of cull, $/head                                                               Av erage daily gain, lb. (Calculated)         #DIV/0!                                                                                                                                                                   growth stage, he or she should enter the number of head at the beginning of the stage. If the heif ers will be
CONCENTRATE AND BYPRODUCT                                                                                                                    OPERATING EXPENSES:                                                                                                                                            kept through an additional stage or stages, the Cost Calculator will carry f orward the liv estock numbers
Concentrate mix eaten, lb./head/day                                                 Number of day s other conc. is f ed                      4. Growing heif ers                                             Head                  $0.00                 0.0           $0       __________                  f rom one stage to the next automatically . Howev er, it cannot accommodate the addition of more animals
Cost of conc. mix, $/ton                                                            By products eaten, lb./head/day                          5. Concentrate mix                                              Tons                  $0.00                 0.0           $0       __________                  with those being carried ov er.
Number of day s conc. mix is f ed                                                   Cost of by product f eed, $/ton                          6. Other concentrates                                           Tons                  $0.00                 0.0           $0       __________                      There are two sections related to the heif er diet. These will accommodate dif f erent ty pes of supplementary
Other concentrates eaten, lb/head/day                                               Number of day s by products are f ed                     7. By products f ed                                             Tons                  $0.00                 0.0           $0       __________                  f eeds and f orages. Enter zeros f or f eeds that do not apply . Note that the quantities asked f or are the
Cost of other concentrates, $/ton                                                   Conc & by prod waste, % of amt of f ered                 8. Hay                                                          Tons, as f ed         $0.00                 0.0           $0       __________                  amounts eaten, not of f ered, and there is a separate entry f or an allowance f or waste.
HAY, SILAGE & PASTURE                                                                                                                        9. Other Hay                                                    Tons, as f ed         $0.00                 0.0           $0       __________                      The Other section includes a v ariety of other costs, including interest and labor. Interest should be charged
Hay eaten, lb./head/day                                                             Silage eaten, lb./head/day                               10. Corn silage                                                 Tons, as f ed         $0.00                 0.0           $0       __________                  at current loan rates if the f arm borrows money or at the interest rate f oregone on f arm inv estments if the
Cost of hay , $/ton as f ed                                                         Cost of silage, $/ton as f ed                            11. Pasture                                                     Tons, as f ed         $0.00                 0.0           $0       __________                  enterprise is owner f inanced. A labor charge is recommended ev en when the work is being perf ormed by
Number of day s hay is f ed                                                         Number of day s silage is f ed                           11. Bedding                                                     cwt.                  $0.00                 0.0           $0       __________                  unpaid f amily labor, using a rate that is comparable to the cost hired labor, including benef its.
Other hay eaten, lb./head/day                                                       Silage waste, % of amount of f ered                      13. Vet and medication                                          Head                  $0.00                 0.0           $0       __________
Cost of other hay , $/ton as f ed                                                   Pasture eaten, lb./head/day                              14. Misc                                                        Head                  $0.00                 0.0           $0       __________
Number of day s other hay is f ed                                                   Cost of pasture, $/ton eaten.                            15. Utilities, f uel and oil                                    Head                  $0.00                 0.0           $0       __________
Hay waste, % of amount of f ered                                                    Number of day s on pasture                               16. Supplies                                                    Head                  $0.00                 0.0           $0       __________
OTHER                                                                                                                                        17. Repairs                                                                                                               $0       __________
Interest rate, percent per y ear                                                    Labor, minutes/head/day                                  18. Death loss and culling                                                                                                $0       __________
Bedding used, cwt.                                                                  Labor cost or charge, $ per hour                         19. Interest on operating capital                                                                                         $0       __________
Cost of bedding, $/cwt.                                                             Utilities, f uel and oil                                                                                                                                                      _______
Vet and medication, $/head                                                          Miscellaneous, $/head                                    20.    Total operating expense                                                                                            $0       __________
Supplies, $/head                                                                                                                                                                                                                                                  _______
a
Number of head is transf erred automatically f rom the prev ious stage                                                                       21. Returns ov er operating expenses                                                                                         $0    __________
b
Enter number of head when there is no carry ov er f rom the prev ious stage.
                                                                                                                                             OWNERSHIP EXPENSES:
                                                                                                                                             22. Specialized cattle f acilities                                                                                                 __________
                                                                                                                                                 machinery and equipment                                                                                               $0       __________
                                                                                                                                                                                                                                                                  _______
                                                                                                                                             23. Returns to land, ov erhead, labor and management                                                                      $0       __________

                                                                                                                                             24. Labor f or liv estock                                       Hours                 $0.00                 0.0           $0       __________
                                                                                                                                                                                                                                                                  _______
                                                                                                                                             25.    Returns to land, ov erhead and management                                                                          $0       __________

                                                                                                                                             25. Total cost per head, this stage, including initial heif er v alue                                              #DIV/0!         __________
                                                                                                                                             26. Cost per head excluding initial v alue of heif er                                                              #DIV/0!         __________
                                                                                                                                             27. Cost per pound of gain f or this stage                                                                         #DIV/0!         __________
                                                                                                                                             28. Cost per head per day f or this stage                                                                          #DIV/0!         __________
                                                                                                                                             Av erage daily gain, lb/head/day =                                #DIV/0!

                                                                                                                                             The example budget was prepared by
                                                                                                                                             G.A. Benson, Extension Economist, NCSU; Telephone: (919) 515-5184
                                                                                                                                             B.A. Hopkins, Extension Dairy Specialist, NCSU; Telephone (919) 515-7592
STAGE 3: SIX MONTHS TO PRE-BREEDING
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                             Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                    0-Jan-00



                  Use the print button in the top nav igation bar to print this budget.


                  The costs and returns in this budget are calculated f orm the inf ormation entered on the input screen. Note
               that the budget calculations include death losses as a cost.

                  The budget shows the returns to land, ov erhead and management as the "bottom line" because this is an
               enterprise budget, not a whole f arm budget. A summary of cost per head, per head per day and per pound
               of gain is prov ided, as an aid to decision making. A blank Alt. (Alternativ e) Value column is prov ided along
               with the f igures generated by this cost calculator. This is intended to assist in making adjustments or notes
                using a printed v ersion of the output and it cannot be accessed by computer.
INPUTS FOR STAGE 4: BREEDING TO PRE-CALVING                                                                                                   BUDGET FOR STAGE 4: BREEDING TO PRE-CALVING                                                                                                               Stage 4: BREEDING TO PRE-CALVING
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                            Budget 10-4   Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                                     Budget 10-4      Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                                Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                 27-Dec-11    management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                           27-Dec-11      management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                     27-Dec-11
ncsu                                                                                                                                          ITEM                                                           UNITS                   PRICE            QUANTITY             VALUE       ALT. VALUE
Date of budget                                            12/27/2011                 Breed of heif er
Number of animals in group at start (sse f ootnotes):                                Number of day s in period                                GROSS REVENUE:                                                                                                                                                              The input worksheet is div ided into sections and the user must input data in all of the cells prov ided.
--Number of head carried f orward f rom prev . stage a            0.0               Weight at start of period                                 1. Springing heif ers                                         Head                     $0.00                 0.0                  $0      __________                     Existing data can be ov erwritten.
--OR Number of animals in group at start b                                          Weight at end of period                                   2. Cull heif ers                                              Head                     $0.00                 0.0                 $0       __________                         The General Inf ormation section includes animal numbers and estimated weights, v alues, and death and
Value at start of period, $/head                                                    Death loss this period, as decimal                                                                                                                                                    _______                                      culling losses. The av erage daily gain is calculated as a check that the assumed change in weight is
Value at end of period, $/head                                                      Culling rate this period, as decimal                      3.    Total rev enue                                                                                                             $0       __________                     reasonable f or the particular growth stage and ration. If the user is interested in a budget f or a single
Value of cull, $/head                                                               Av erage daily gain, lb. (Calculated)          #DIV/0!                                                                                                                                                                             growth stage, he or she should enter the number of head at the beginning of the stage. If the heif ers will be
CONCENTRATE AND BYPRODUCT                                                                                                                     OPERATING EXPENSES:                                                                                                                                                      kept through an additional stage or stages, the Cost Calculator will carry f orward the liv estock numbers
Concentrate mix eaten, lb./head/day                                                 Number of day s other conc. is f ed                       4. Open heif ers                                              Head                     $0.00                 0.0                 $0       __________                     f rom one stage to the next automatically . Howev er, it cannot accommodate the addition of more animals
Cost of conc. mix, $/ton                                                            By products eaten, lb./head/day                           5. Concentrate mix                                            Tons                     $0.00                 0.0                 $0       __________                     with those being carried ov er.
Number of day s conc. mix is f ed                                                   Cost of by product f eed, $/ton                           6. Other concentrates                                         Tons                     $0.00                 0.0                 $0       __________                         There are two sections related to the heif er diet. These will accommodate dif f erent ty pes of supplementary
Other concentrates eaten, lb/head/day                                               Number of day s by products are f ed                      7. By products f ed                                           Tons                     $0.00                 0.0                 $0       __________                     f eeds and f orages. Enter zeros f or f eeds that do not apply . Note that the quantities asked f or are the
Cost of other concentrates, $/ton                                                   Conc. & by prod waste, % of amt of f ered                 8. Hay                                                        Tons, as f ed            $0.00                 0.0                 $0       __________                     amounts eaten, not of f ered, and there is a separate entry f or an allowance f or waste.
HAY, SILAGE & PASTURE                                                                                                                         9. Other Hay                                                  Tons, as f ed            $0.00                 0.0                 $0                                          The Other section includes a v ariety of other costs, including interest and labor. Interest should be charged
Hay eaten, lb./head/day                                                             Silage eaten, lb./head/day                                10. Corn silage                                               Tons, as f ed            $0.00                 0.0                 $0       __________                     at current loan rates if the f arm borrows money or at the interest rate f oregone on f arm inv estments if the
Cost of hay , $/ton as f ed                                                         Cost of silage, $/ton as f ed                             11. Pasture                                                   Tons, as f ed            $0.00                 0.0                 $0       __________                     enterprise is owner f inanced. A labor charge is recommended ev en when the work is being perf ormed by
Number of day s hay is f ed                                                         Number of day s silage is f ed                            11. Bedding                                                   cwt.                     $0.00                 0.0                 $0       __________                     unpaid f amily labor, using a rate that is comparable to the cost hired labor, including benef its.
Other hay eaten, lb./head/day                                                       Silage waste, % of amount of f ered                       13. Vet and medication                                        Head                     $0.00                 0.0                 $0       __________
Cost of other hay , $/ton as f ed                                                   Pasture eaten, lb./head/day                               14. Breeding                                                  Head                     $0.00                 0.0                 $0       __________
Number of day s other hay is f ed                                                   Cost of pasture, $/ton eaten.                             15. Utilities, f uel and oil                                  Head                     $0.00                 0.0                 $0       __________
Hay waste, % of amount of f ered                                                    Number of day s on pasture                                16. Supplies & misc.                                          Head                     $0.00                 0.0                 $0       __________
OTHER                                                                                                                                         17. Repairs                                                                                                                      $0       __________
Interest rate, percent per y ear                                                    Labor, minutes/head/day                                   18. Death loss and culling                                                                                                       $0       __________
Bedding used, cwt.                                                                  Labor cost or charge, $ per hour                          19. Interest on operating capital                                                                                                $0       __________
Cost of bedding, $/cwt.                                                             Utilities, f uel and oil, $/head                                                                                                                                                      _______
Vet and medication, $/head                                                          Supplies & Miscellaneous, $/head                          20.    Total operating expense                                                                                                   $0       __________
Breeding, $/head                                                                                                                                                                                                                                                          _______
a
Number of head is transf erred automatically f rom the prev ious stage                                                                        21. Returns ov er operating expenses                                                                                              $0      __________
b
Enter number of head when there is no carry ov er f rom the prev ious stage.
                                                                                                                                              OWNERSHIP EXPENSES:
                                                                                                                                              22. Specialized cattle f acilities                                                                                                        __________
                                                                                                                                                  machinery and equipment                                                                                                      $0       __________
                                                                                                                                                                                                                                                                          _______
                                                                                                                                              23. Returns to land, ov erhead, labor and management                                                                             $0       __________

                                                                                                                                              24. Labor f or liv estock                                     Hours                    $0.00                 0.0                 $0       __________
                                                                                                                                                                                                                                                                          _______
                                                                                                                                              25.    Returns to land, ov erhead and management                                                                                 $0       __________

                                                                                                                                              25. Total cost per head, this stage, including initial heif er v alue                                                      #DIV/0!          __________
                                                                                                                                              26. Cost per head excluding initial v alue of heif er                                                                      #DIV/0!          __________
                                                                                                                                              27. Cost per pound of gain f or this stage                                                                                 #DIV/0!          __________
                                                                                                                                              28. Cost per head per day f or this stage                                                                                  #DIV/0!          __________
                                                                                                                                              Av erage daily gain, lb/head/day =                                #DIV/0!
                                                                                                                                              This budget assumes that heif ers are transf erred to a transition f eeding group 3 weeks bef ore calv ing. These costs are not included in the budget.

                                                                                                                                              The example budget was prepared by
                                                                                                                                              G.A. Benson, Extension Economist, NCSU; Telephone: (919) 515-5184
                                                                                                                                              B.A. Hopkins, Extension Dairy Specialist, NCSU; Telephone (919) 515-7592
Stage 4: BREEDING TO PRE-CALVING
Estimated annual rev enue, operating expenses, ownership expenses and returns to land, ov erhead and                             Budget 10-4
management f or rearing large breed dairy heif ers to calv e at 24-mo. at 1,350 lb., using corn silage and hay .                    0-Jan-00



                  Use the print button in the top nav igation bar to print this budget.


                  The costs and returns in this budget are calculated f orm the inf ormation entered on the input screen. Note
               that the budget calculations include death losses as a cost.

                  The budget shows the returns to land, ov erhead and management as the "bottom line" because this is an
               enterprise budget, not a whole f arm budget. A summary of cost per head, per head per day and per pound
               of gain is prov ided, as an aid to decision making. A blank Alt. (Alternativ e) Value column is prov ided along
               with the f igures generated by this cost calculator. This is intended to assist in making adjustments or notes
                using a printed v ersion of the output and it cannot be accessed by computer.
SUMMARY DAIRY HEIFER BUDGET                                                                                                                               SUMMARY DAIRY HEIFER BUDGET                                                                                                                SUMMARY DAIRY HEIFER BUDGET
Estimated annual revenue, operating expenses, ow nership expenses and returns to land, overhead and                                       Budget 10-4     SENSITIVITY ANALYSIS                                                                                                         Budget 10-4   Estimated annual revenue, operating expenses, ow nership expenses and returns to land, overhead and                                 Budget 10-4
management for rearing large breed dairy heifers to calve at 24-mo. at 1,350 lb., using corn silage and hay.                               27-Dec-11                                                                                                                                    27-Dec-11    management for rearing large breed dairy heifers to calve at 24-mo. at 1,350 lb., using corn silage and hay.                           0-Jan-00
ITEM                                                           UNITS                      PRICE          QUANTITY             VALUE      ALT. VALUE
                                                                                                                                                          This table show s the returns to land, overhead and management (a measure of profit) under various assumptions about
GROSS REVENUE:                                                                                                                                            costs and returns. Specifically, the cost and returns show n in the enterprise budget are believed to be fairly                                             Use the print button in the top navigation bar to print this budget.
1. Springing heifers                                                                    $0.00                 0.0                 $0      __________      representative of conditions in North Carolina. How ever, there is a w ide variation in heifer raising systems and in farm
2. Cull heifers                                                                                               0.0                 $0      __________      performance among farms. Also, costs and the value of heifers change from year toyear. The table show s the effects                                          The costs and returns in this budget are a summary of the budgets developed for one or more consecutive
                                                                                                                             _______                      of returns that are 10 percent higher and low er than for the basic budget. Similarly, the table also show s the effects                                  individual grow th stages. For accuracy, data for the grow th stages that are NOT part of this enterprise should
3.    Total revenue                                                                                                               $0      __________      of total costs that are 10 percent higher and low er.                                                                                                     be deleted, either from the Start w orksheet or by using the Clear All Entries button on the appropriate input
                                                                                                                                                                                                                                                                                                                    screen for that grow th stage.
OPERATING EXPENSES:                                                                                                                                                                             RETURNS TO LAND, OVERHEAD AND MANAGEMENT:                                                                              The budget show s the returns to land, overhead and management as the "bottom line" because this is an
4. Day old calves                                             Head                      $0.00                 0.0                 $0      __________                                                                                                                                                                enterprise budget, not a w hole farm budget. A summary of cost per head, per head per day and per pound of
5. Milk replacer                                              lb.                       $0.00                 0.0                 $0      __________                                                                 REVENUE                                                                                        gain is provided, as an aid to decision making. A blank Alt. (Alternative) Value column is provided along w ith
6. Concentrates                                               Tons                      $0.00                 0.0                 $0      __________                 E                            10%                            Base                                 10%                                           the figures generated by this cost calculator. This is intended to assist in making adjustments or notes using a
7. Byproducts fed                                             Tons                      $0.00                 0.0                 $0      __________                 X                          Low er                          Budget                              Higher                                          printed version of the output and it cannot be accessed by computer.
8. Hay                                                        Tons, as fed              $0.00                 0.0                 $0      __________                 P      ###                     $0                               $0                                 $0                                             The "Sensitivity Analysis" button at the top of the Summary Budget screen w ill take you to a table that show s
9. Corn silage                                                Tons, as fed              $0.00                 0.0                 $0      __________                 E                                                                                                                                              the impact of a 10 percent change in revenue or cost on the total returns to land, overhead and management.
10. Pasture                                                   Tons, as fed              $0.00                 0.0                 $0      __________                 N    Base                      $0                               $0                                 $0                                          This information is useful in assessing the financial risk associated w ith variations from projected performance.
11. Bedding                                                                             $0.00                 0.0                 $0      __________                 S
12. Vet and medication                                        Head                                                                $0      __________                 E   + 10%                      $0                               $0                                 $0
13. Breeding                                                  Head                      $0.00                 0.0                 $0      __________
14. Utilities, fuel and oil                                   Head                                                                $0      __________
15. Supplies and Misc.                                                                                                            $0      __________
16. Repairs                                                                                                                       $0      __________
17. Death loss and culling                                                                                                        $0      __________
18. Interest on operating capital                                                                                                 $0      __________
                                                                                                                             _______
19.    Total operating expense                                                                                                    $0      __________
                                                                                                                             _______
20. Returns over operating expenses                                                                                               $0      __________

OWNERSHIP EXPENSES:
21. Specialized cattle facilities
    machinery and equipment                                                                                                       $0      __________
                                                                                                                             _______
22. Returns to land, overhead, labor and management                                                                               $0      __________

23. Labor for livestock                                       Hours                 #DIV/0!                   0.0                 $0      __________
                                                                                                                             _______
24.    Returns to land, overhead and management                                                                                   $0      __________

25. Total cost per head, including initial calf value                                                                       #DIV/0!          __________
26. Cost per head excluding initial value of calf                                                                           #DIV/0!          __________
27. Cost per pound of gain                                                                                                  #DIV/0!          __________
28. Cost per head per day                                                                                                   #DIV/0!          __________
This budget assumes that heifers are transferred to a transition feeding group 3 w eeks before calving. These costs are not included in the budget.

The example budget w as prepared by
G.A. Benson, Extension Economist, NCSU; Telephone: (919) 515-5184
B.A. Hopkins, Extension Dairy Specialist, NCSU; Telephone (919) 515-7592

								
To top