Calculations by 7a9APMg

VIEWS: 7 PAGES: 8

									                                                Calculations


                                                                                           $ 60.00
Stage        CP                 ADF         Ndf       Tdn
                      #sbom required to get as much protein          Price/unit Value/Ton Est yield T/A
V9             12.00%    503.14      25.20     55.50%          65%    $105.80     $29.36              5
V12            10.00%    419.29      26.50     58.60%          65%      $94.14    $26.12              7
V18             8.40%    352.20      27.00     53.70%          65%      $84.81    $23.54              9
VT              9.50%    398.32      25.60     51.40%          65%      $91.23    $25.32             11
R!              9.40%    394.13      33.20     54.60%          65%      $90.64    $25.15             13
Early Dent      7.50%    314.47      32.00     52.00%          65%      $79.56    $22.08             15
1/4 Milkline    7.30%    306.08      27.10     44.40%          68%      $80.05    $22.21             16
2/3 Milkline    7.10%    297.69      23.90     40.50%          70%      $79.99    $22.20             17
Black Layer     7.00%    293.50      24.20     41.30%          66%      $77.20    $21.42             18
135 RFV Hay/T  21.00%    880.50      31.35     44.65%          64%    $158.00                         0

                                                      Percent Spoilage              7.50%




Crude Protein % of Sample             0.12    65.00%
times 1.2                             0.14       20.8 times 32
Times SBOM price                      46.8       62.4
                                                109.2 times yield           0.3
                                                32.76




                                                  Page 1
Calculations




  Page 2
                                                Calculations


Harvesting Cost
Value/A                                      # protein sbom lost by removing
                                                         # tdn
                                 # tdn not covered by excess provided by corn SBOM
      $87 $109.20      ($3.40)          872          99        177        20         36          4.06
    $123 $101.40       ($7.26)          944         107        191        22         39          4.40
    $152     $95.16   ($10.35)         1001         114        203        23         41          4.66
    $218     $99.45    ($8.22)          961         109        195        22         39          4.48
    $267     $99.06    ($8.42)          965         110        195        22         40          4.50
    $271     $91.65   ($12.09)         1033         117        209        24         42          4.81
    $295     $93.75   ($13.70)         1100         125        223        25         45          5.12
    $317     $94.89   ($14.90)         1147         130        232        26         47          5.34
    $326     $90.66   ($13.46)         1071         122        217        25         44          4.99
            $143.80    $14.20           541          61        110        12         22          2.52

                1.2
                 32              Values to use in Regression
                                     Y           X!        X2
                                  $105.80         39.00     1.950           SUMMARY OUTPUT
                                   $94.14         32.50     1.950
                                   $84.81         27.30     1.950           Regression Statistics
                                   $91.23         30.88     1.950           Multiple R          1
                                   $90.64         30.55     1.950           R Square            1
                                   $79.56         24.38     1.950           Adjusted R Square 1
                                   $80.05         23.73     2.040                       2.13E-13
                                                                            Standard Error
                                   $79.99         23.08     2.100           Observations        9
                                   $77.20         22.75     1.980
                                  $158.00         68.25 1.934351            ANOVA
                                                                                            df
                                                                            Regression             2
                                                                            Residual               6
                                                                            Total                  8

                                                                                       Coefficients
                                                                            Intercept    8.25E-12
                                                                            X Variable 1 1.794203
                                                                            X Variable 2 18.374




                                                                            RESIDUAL OUTPUT

                                                                           ObservationPredicted Y
                                                                                    1 130.3177
                                                                                    2 117.7617
                                                                                    3 111.633
                                                                                    4 116.2868
                                                                                    5 108.4238
                                                                                    6 103.9877
                                                                                    7 108.2735
                                                                                    8 110.8667
                                                                                    9 110.2717
                                                                                   10 144.6436



                                                  Page 3
Calculations


               10 145.7966




  Page 4
                                                  Calculations




 SBOM Price/T                       $325.00    47.70%        85.00% 34.06709
 Corn Price/Bu                        $3.00    10.00%        88.00% 6.087662
                                                          .85 for dry shelled corn


                   250      $275      $300        $325
     $2.50    1.725026   1.806781   1.87491   1.932557
              20.84268   17.88027   14.9179   11.95544
     $2.75    1.635095   1.725026   1.79997    1.86338      1.97029
              23.53578   20.84268   18.1496   15.45647     9.733636
     $3.00    1.545165   1.643271   1.72503   1.794203     1.888535
              25.78003   23.31135   20.8427      18.374    14.25954
     $3.25    1.455235   1.561516   1.65008   1.725026     1.806781
              27.67901   25.40023   23.1215   20.84268     17.88027




    SS       MS             F Significance F
  689.3036 344.6518      7.62E+27 6.1E-83
  2.71E-25 4.52E-26
  689.3036

Standard Error t Stat    P-value Lower 95%Upper 95%          Upper 95.0%
                                                   Lower 95.0%
   3.64E-12 2.267119      0.06392 -7E-13 1.71E-11 -6.5E-13 1.71E-11
   1.67E-14 1.07E+14     4.42E-83 1.7942 1.794203 1.794203 1.794203
   1.69E-12 1.09E+13     4.09E-77 18.374     18.374    18.374    18.374




  Residuals
   4.55E-13
   1.14E-13
   -2.8E-14
   2.13E-13
   -7.2E-13
   -6.7E-13
   -7.1E-14
   3.13E-13
   2.56E-13
   -5.7E-14



                                                    Page 5
           Calculations


-1.15308




             Page 6
            Estimating the Value of Standing Corn for Corn Silage
                                                 Gary Frank, Center for Dairy Profitability, 2004
Step 1. Select the multiplier for SBOM (from Table 1) and corn (from Table 2) based on the current
         price of SBOM per ton and the current price of corn per bushel.            Table 1: SBOM Multipliers
                                                                                                Price of              Price of SBOM per ton
Step 2. Take the SBOM price times the SBOM multiplier                                      Corn per Bu.         $250     $275     $300        $325
         and take the result times the percent (as a decimal)                                   $2.50            1.73     1.81     1.87        1.93
         protein in this corn silage.                                                           $2.75            1.64     1.73     1.80        1.86
                                                                                                $3.00            1.55     1.64     1.73        1.79
                                                                                                $3.25            1.46     1.56     1.65        1.73
Step 3. Take the corn price times the corn multiplier
         and take the result times the percent (as a decimal)                                                  Table 2: Corn Multipliers
         TDN in this corn silage.                                                               Price of              Price of SBOM per ton
                                                                                          $250     $275
                                                                                           Corn per Bu.    $300                               $325
Step 4. Add the results from steps 2 & 3 and take                                $2.50     20.8     17.9    14.9                               12.0
         the sum times the percent dry matter in                                 $2.75     23.5     20.8    18.1                               15.5
         this corn silage.                                                       $3.00     25.8     23.3    20.8                               18.4
                                                                                 $3.25     27.7     25.4    23.1                               20.8
Step 5. Multiply result by (1 - ensile dry matter loss) and subtract the harvesting costs per wet ton and you have
         estimated the value of standing corn. Of course the price you pay will be determined by supply and
         demand conditions in your area and negotiations between you and the seller.

Example: The SBOM price is $200 per ton and the corn price is $2.00 per bushel. The corn silage is
        7.5% protein, 64% TDN, and 30% dry matter. The harvesting cost is $4.00 per ton.
                                 Example Values                Your Values
Step 2         SBOM Multiplier      1.73
             SBOM Price/ Ton       $200
       % Protein in Corn Silage   7.50%        25.95                    $    -
Step 3           Corn Multiplier                20.8
              Corn Price/Bushel               $2.00
       % TDN in Corn Silage ***                 64%          26.62                      + $          -           ***See back of this page for
Step 4                                Subtotal             $52.57                       = $          -              the correct % TDN to use.
     times percent dry matter (as a decimal)                 0.300                      x                0.3
  Value per ton of this corn silage in storage             $15.77                         $           - 0       * Ensile dry matter losses
     times (1.00 - % ensile dry matter loss)*                0.925                      x           0.925       range from 5 to 10% or more.
Step 5                     Value per wet ton               $14.59                       = $           -
         minus harvesting costs per wet ton                 $4.00                       - $         4.00
                 Value per ton as standing corn          $10.59                         = $     (4.00)
                                                                                                                                                                     "For a better estimate
 Table 3: Estimated value of standing corn if SBOM price is $200 per ton; the corn price is $2.00                                                                    use Terry Howard's
per bushel; and harvesting costs are $60 per acre.                                                                                                                   'Pricer' program."
                                                                              Estimated Value
                      Stage*             Protein %*         TDN %* per wet ton**            per Acre***
       10 - 12 leaves, no tassels             12.00%            65%          $19.01                  $35                                               $35.04    5
       14 - 15 leaves, no tassels             10.00%            65%          $17.09                  $60                                               $59.65    7
       14 - 15 leaves and tassels               8.40%           65%          $15.56                  $80                                               $80.05    9
     Tassels, plus main ear visible             9.50%           65%          $16.61                 $123                                              $122.76   11
           Silks and blisters                   9.40%           65%          $16.52                 $155                                              $154.74   13
               Early dent                       7.50%           65%          $14.70                 $160                                              $160.49   15
              1/4 milkline                      7.30%           68%          $14.85                 $178                                              $177.68   16
              2/3 milkline                      7.10%           70%          $14.89                 $193                                              $193.21   17
                Black layer                     7.00%           66%          $14.34               $198                                                $198.06   18
* Stages and the corresponding % protein and TDN adapted from work by P. Hoffman and R. Shaver.
** At 30 percent dry matter.
*** After subtracting harvesting cost and assuming a mature yield of 18 tons of corn silage per acre.
                                                      TDN adjustments
To obtain the correct TDN value for use when calculating the value of corn silage, select the lower
of the unadjusted and the adjusted TDN values based on the corn silage's Whole Plant (WP) ADF% and
WP DM%. Example 1: The corn silage has a WP ADF of 24% and WP DM of 30%, use a TDN value of
71%. Example 2: The corn silage has a WP ADF of 24% and WP DM of 40%, use a TDN of 66.4%.
            WP ADF% WP DM% Unadj. TDN Adj. TDN Lower of the two TDN values                            Unadj. Nel
                20         30             73.7        72.9           72.9                                  0.80
                20         33             73.7        71.0           71.0                                  0.80
                20         35             73.7        69.7           69.7                                  0.80
                20         38             73.7        67.7           67.7                                  0.80
                20         40             73.7        66.4           66.4                                  0.80
                20         45             73.7        63.1           63.1                                  0.80
                20         50             73.7        59.9           59.9                                  0.80
                22         30             72.4        72.9           72.4                                  0.77
                22         33             72.4        71.0           71.0                                  0.77
                22         35             72.4        69.7           69.7                                  0.77
                22         38             72.4        67.7           67.7                                  0.77
                22         40             72.4        66.4           66.4                                  0.77
                22         45             72.4        63.1           63.1                                  0.77
                22         50             72.4        59.9           59.9                                  0.77
                24         30             71.0        72.9           71.0 Example 1                        0.75
                24         33             71.0        71.0           71.0                                  0.75
                24         35             71.0        69.7           69.7                                  0.75
                24         38             71.0        67.7           67.7                                  0.75
                24         40             71.0        66.4           66.4 Example 2                        0.75
                24         45             71.0        63.1           63.1                                  0.75
                24         50             71.0        59.9           59.9                                  0.75
                26         30             69.7        72.9           69.7                                  0.72
                26         33             69.7        71.0           69.7                                  0.72
                26         35             69.7        69.7           69.7                                  0.72
                26         38             69.7        67.7           67.7                                  0.72
                26         40             69.7        66.4           66.4                                  0.72
                26         45             69.7        63.1           63.1                                  0.72
                26         50             69.7        59.9           59.9                                  0.72
                28         30             68.4        72.9           68.4                                  0.70
                28         33             68.4        71.0           68.4                                  0.70
                28         35             68.4        69.7           68.4                                  0.70
                28         38             68.4        67.7           67.7                                  0.70
                28         40             68.4        66.4           66.4                                  0.70
                28         45             68.4        63.1           63.1                                  0.70
                28         50             68.4        59.9           59.9                                  0.70
                30         30             67.1        72.9           67.1                                  0.67
                30         33             67.1        71.0           67.1                                  0.67
                30         35             67.1        69.7           67.1                                  0.67
                30         38             67.1        67.7           67.1                                  0.67
                30         40             67.1        66.4           66.4                                  0.67
                30         45             67.1        63.1           63.1                                  0.67
                30         50             67.1        59.9           59.9                                  0.67
                32         30             65.8        72.9           65.8                                  0.65
                32         33             65.8        71.0           65.8                                  0.65
                32         35             65.8        69.7           65.8                                  0.65
                32         38             65.8        67.7           65.8                                  0.65
                32         40             65.8        66.4           65.8                                  0.65
                32         45             65.8        63.1           63.1                                  0.65
                32         50             65.8        59.9           59.9                                  0.65

								
To top