Docstoc

calculator

Document Sample
calculator Powered By Docstoc
					ncsu

       Agricultural and Resource Economics
       P.O. Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: 919 515-3107
                                                USING THIS COST & RETURNS CALCULATOR

                          Navigation: Buttons are provided for navigate around the dairy heifer cost calculator.
                          Click on a button to select an individual component of the calculator. The Return Arrow in
                          the top right corner of each page will return you to the main menu or to the previous
                                screen. Please use the Print button at the top of each page if you wish to print that
                                page. Do use the print command on your spreadsheet menu. The Question Mark
                                button at the top of a page will bring up a screen with additional information about
                                that part of the cost calculator.

                                Creating Your Own Heifer Budget.
                           Before making changes to the original version of this spreadsheet, you may wish to save
                           it and use a different file name for all new budgets you develop.

                           It is helpful to begin by naming, numbering and describing your budget. From the Main
                               Menu, click on the "Start" button to do this. Replace or edit the text in the white cells.
                               Next, identify the growth stages you plan to develop budgets for. You may select any
                               number of stages as long as they are sequential. If you are interested in (continue…)
Agricultural and Resource Economics
P.O. Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: 919 515-3107


                   growth stages that are not sequential, e.g., stage1 (birth to weaning) and stage 4
                   (breeding to pre-calving) you should run these separately. DELETE the data for the
                   stages you are NOT interested in. This step is necessary for the summary budget to be
                   accurate. Once this step is complete, return to the main menu. Use the buttons on the
                        main menu to select the growth stages you are interested in. Each stage has an
                        input worksheet and a budget for that stage. Also, select the "Buildings and
                        Equipment" button to enter information on the items needed for heifer raising.

                         Enter your own information in worksheets identified as "Inputs for Stage….." The
                         data entry sections have a brown background and white lettering. Enter your data in
                    the white cells with a blue font. Note that the descriptions of the items listed in these
                    sections are protected and cannot be changed. Enter a zero for items that do not apply.
                    You may find it convenient to print this section to assist you in collecting the necessary
                    information. If so, use the Print button at the first row of the worksheet.

                       A budget for a particular growth state is created once you have entered all the
                      necessary information. Use the "Enterprise Budget" button to see or print this budget.
Agricultural and Resource Economics
P.O. Box 8109, NC State University, Raleigh, NC 27695-8109 Phone: 919 515-3107


                   The budget shows the returns to land, overhead and management as the "bottom line"
                   because this is an enterprise budget, not a whole farm budget. A summary of cost per
                   head, per head per day and per pound of gain is provided, as an aid to decision making.
                   A blank Alt. (Alternative) Value column is provided along with the figures generated by this
                         cost calculator. This is intended to assist in making adjustments or notes using a
                         printed version of the output and it cannot be accessed by computer.

                        If you are creating budgets for more than one growth stage, repeat the input data
                        entry for each stage. When all stages are complete, you can obtain a summary
                        budget. Use the "Return" button to get back to the main menu and select the
                    "Summary Budget." This summary budget can be viewed or printed. The "Sensitivity
                    Analysis" button at the top of the Summary Budget page will take you to a table that
                    shows the impact of a 10 percent change in revenue or cost on the total returns to land,
                    overhead and management. This information is useful in assessing the financial risk
                      associated with variations from projected performance.

                                                                           Good Luck !!!!!!!
                        Agricultural and Resource Economics
                        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.
            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 REPAIR COSTS & COST ALLOCATION
DAIRY HEIFERS                                                                                                                Budget 10-4
Repair costs for specialized buildings and equipment for rearing dairy heifers                                                 13-Jul-10



                  The estimated repair cost for each item is calculated from the information provided in the Buildings and
               Investment worksheet and the Buildings and Investment Ownership Cost Allocation worksheet. This
               worksheet is provided for information only and cannot be directly modified by the user. Any changes
               must be made on the previous worksheets. The allocated share of the repair costs is transferred
               automatically to the appropriate budgets.
STAGE 1: BIRTH TO WEANING
Estimated annual revenue, operating expenses, ownership 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.                      0-Jan-00



                 Use the print button in the top navigation bar to print this budget.

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

                  The budget shows the returns to land, overhead and management as the "bottom line" because this is an
               enterprise budget, not a whole farm budget. A summary of cost per head, per head per day and per pound
               of gain is provided, as an aid to decision making. A blank Alt. (Alternative) Value column is provided along
               with the figures generated by this cost calculator. This is intended to assist in making adjustments or notes
                using a printed version of the output and it cannot be accessed by computer.
STAGE 2: WEANING TO 6 MONTHS
Estimated annual revenue, operating expenses, ownership 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.                      0-Jan-00



                 Use the print button in the top navigation bar to print this budget.


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

                  The budget shows the returns to land, overhead and management as the "bottom line" because this is an
               enterprise budget, not a whole farm budget. A summary of cost per head, per head per day and per pound
               of gain is provided, as an aid to decision making. A blank Alt. (Alternative) Value column is provided along
               with the figures generated by this cost calculator. This is intended to assist in making adjustments or notes
               using a printed version of the output and it cannot be accessed by computer.
STAGE 3: SIX MONTHS TO PRE-BREEDING
Estimated annual revenue, operating expenses, ownership 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.                      0-Jan-00



                 Use the print button in the top navigation bar to print this budget.


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

                  The budget shows the returns to land, overhead and management as the "bottom line" because this is an
               enterprise budget, not a whole farm budget. A summary of cost per head, per head per day and per pound
               of gain is provided, as an aid to decision making. A blank Alt. (Alternative) Value column is provided along
               with the figures generated by this cost calculator. This is intended to assist in making adjustments or notes
               using a printed version of the output and it cannot be accessed by computer.
Stage 4: BREEDING TO PRE-CALVING
Estimated annual revenue, operating expenses, ownership 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.                      0-Jan-00



                 Use the print button in the top navigation bar to print this budget.


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

                  The budget shows the returns to land, overhead and management as the "bottom line" because this is an
               enterprise budget, not a whole farm budget. A summary of cost per head, per head per day and per pound
               of gain is provided, as an aid to decision making. A blank Alt. (Alternative) Value column is provided along
               with the figures generated by this cost calculator. This is intended to assist in making adjustments or notes
               using a printed version of the output and it cannot be accessed by computer.
SUMMARY DAIRY HEIFER BUDGET
Estimated annual revenue, operating expenses, ownership 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.                          0-Jan-00



                 Use the print button in the top navigation bar to print this budget.

                  The costs and returns in this budget are a summary of the budgets developed for one or more consecutive
               individual growth stages. For accuracy, data for the growth stages that are NOT part of this enterprise should
               be deleted, either from the Start worksheet or by using the Clear All Entries button on the appropriate input
               screen for that growth stage.
                  The budget shows the returns to land, overhead and management as the "bottom line" because this is an
               enterprise budget, not a whole farm budget. A summary of cost per head, per head per day and per pound of
               gain is provided, as an aid to decision making. A blank Alt. (Alternative) Value column is provided along with
               the figures generated by this cost calculator. This is intended to assist in making adjustments or notes using a
               printed version of the output and it cannot be accessed by computer.
                  The "Sensitivity Analysis" button at the top of the Summary Budget screen will take you to a table that shows
               the impact of a 10 percent change in revenue or cost on the total returns to land, overhead and management.
               This information is useful in assessing the financial risk associated with variations from projected performance.