ࡱ>    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJLMNRoot EntryFHK@PerfectOffice_MAIN& SummaryInformation(8wwwwwwwG!pQpvwwwwwd2X,ww7!pQpvwwwww7Xpwwww o*?粚5dwwww lww UwUwwwwwՀ*www??w?wwwwwwVUՀդV?wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwڂ*'""" "    $ $       Tq  d2X, X1Axis?  Ts  d2X, Y1Axis?   Tt  d2X, Y2Axis?  }j  d2X, 1PaneLeftWallRightWallBaseSeriesSeriesLabel?   Ym  d2X,  X1Title?  Yo  d2X,  Y1Title?  Yp  d2X,  Y2Title? N Tl  d2X, Legend?  }Z    Title?  $ArialArial "]Z  %&'( 880[ @  $ Arial ZZ$ Arial ZZ  LB  %&'( 0d  $ Arial ZZ$ Arial ZZ  B           ^  ddư>   ?&  Mb@?   #       f  g    i2      -./g  0d    tNBT6 RO_BUDGET$u<7~Ȃ7fYx, ,#,0,=,?CSd,؄؄؄Ʌ؄؄؄ ؄ ؄ P4#0=?CSdfYx, ,#,0,=,?CSd,؄؄؄Ʌ؄؄؄ ؄ ؄ P4#0=?CSdT   L L    &CUSTOM FEEDING BUDGET TEMPLATE *****Input price and production information in the yellow fields below. Information in the blue fields illustrates *****|LM/3$ Times New Roman<Z3$ArialNew Roman<Z3$ ArialNew Roman<Z3$ ArialNew Roman<Z3$Times New Roman<Z3$ Times New Roman<Z3$ Times New Roman<Z3$ Times New Roman<Z3$Tahomaew Roman<Z3$Tahomaew Roman<Z3@ Normal Comma Comma0 CurrencyCurrency0 Date FixedHeading 1 Heading 2 Percent Total0~33@ R033@ P033@ 2033@ 0033@ 033@ 033@ 0 33@ 0 33@ B033@ 033D 0 33@ P033@ 0"33@ 2033@ 0A33@ 0$33@ 033@ P0&33@ R0&33@ R0g33@ 0033@ B0C33@ 0$33@ 033@ 0Q33@ 20S33@ 033@ 0$33@ 2033@ 20&33@ 2033@ 033@ 0p33@ 0@33@ 0D33@ 0P33@ 0P33@ 0T33@ 0d33@ 0`33@ 0@33@ A0j33@ 0h33@ 0l33@ A0b33@ 0f33@  0b33@ 0t33@ 0d33@ 0t33@ P0v33@ 20v33@ 0D33@ 0t33@ 20f33@ B0f33@ 40f33@ 0d33@ P0b33@ 20B33@ 20B33@ A0B33@ 0P33@ R0B33@ 20J33@ 0d33@ 20n33@ 20B33@ 20.33@ 20z33@ 0l33@ 0H33@ 20z33@ 20z33@ 6j33@ 6j33@26n33@6l33@P6n33@26~33@R6n33@26J33@6H33@26Z33@26z33@26z33@26z33@26^33@26.33@26>33@26~33@233@233@A33@33@33@ 33@33@33@33@A33@@33@233@233@233@0X33@ 0j33@ 0|33@ 20n33@ 0L33@ 20J33@ B0n33@ 20Z33@ P0n33@ 0l33@ 20~33@ 0H33@ P0j33@ 20J33@ A0J33@ 0X33@ 0L33@ 33@ 233@ R0J33@ 20^33@ 233@ 0l33@ 233@ 0n33@ 033@ 0,33@ 0,33@ P0.33@ 20>33@ B0K33@ 0I33@ 20 33@ 033@ 0 33@ 33@ 0,33@ 2033@ R0o33@ 0 33@ R0.33@ 0 33@ P0 33@ 20Z33@ 20 33@ 20[33@ 00 33@ 0(33@ 0*33@ 20~33@ 0P33@ 0P33@ 26J33@26^33@033@ 0D33@ 6H33@26J33@6h33@26J33@26Z33@2033@ 233@dBY!_d<  ? ($$  A   ?       wY@W swW H H H (p lwwwwwwwwgt?ww@ H H H (p lwwwwwwwGpt?wwG!pQpvwwwwwwwwwwwwwwwwwwwwwwwgC _pxxpwwww, lwwgxxpwwww lwwwwwwww lwwwwwwwwwwwwwwwww l*****how selected variables respond to changes in prices or production parameters. FIN_SUM sheet contains *****z*****a complete summary of costs and returns calculated using the inputs provided. RISK_MGT sheet contains ********** a worksheet for evaluating alternative risk management strategies. ***** )Budgeting Inputs1 Expense Items                 P#1 Production Information   H H H H H H H H  H !` "H#)Summary Statistics $ % & ' ( ) * + ,H -H .H /H 0H 1H 2H 3H 4H 5H 6H 7H 8H 9H :H ; <H =X >H ? @H AH BH C DH E FH GH HH I JH KH LH M  N  O  P  Q  R  S` T  Ux V  W  X  Y  Z  [  \  ]  ^  _  `  a           !Feeder Calf Price ACorn Price !Supplement  !Vet. !Trucking!Yardage!Enrollment Fee !Misc.!Interest RateAEquity in Cattle APortion of Feed Financed @ !Date Placed on FeedA# of Head!Feeder Purchase WeightASale Weight!Expected Sale PriceAAve. Daily GainAFeed ConversionAExpected Death LossA CornA Supplement AShrink @ Sale !h "@ #$ABreakeven Price %&AFeed Cost/lb gain'AOther costs(ATotal cost of gain ) *@ +@ , - .H /H 0X 1H 2H 3H 4H 5H 6H 7H 8H 9` :H ;H <H =H >H ?x @H AH BH CH Dx Ex Fx G H I J K( L( M0 N( O( P  Q0 R  S0 T U( V( W( X Y Z [ \ ] ^0 _( d( e f g h i j k        9price/unit P@ @ ? 2@ >@?"@{Gz?? ? X  @Q@#@+$@P@+ @+333333@3{Gz?;ףp= ?;p= ף? 3{Gz? !X " #($ GM@ d  %1&HF@@   d A'$X1.@-    d  $(kλuH@  ) *@ +@ ,@ -H .H /H 0H 1h 2H 3h 4h 5h 6h 7h 8H 9` :H ;H < =H >H ? @ A B C D E F G  H I J K0 L0 M0 N@ O PX Q0 R0 S T U V  W0 X Y Z [ \ ] ^  _ ` a b c d e@ f g@ h@ i@ j@ k@         9units  cwt; Ibu (as fed basis-14 % moisture-Dec. Futures +$0.10) lb (DM basis)  head  headhead/day head headpercent  H `  I(one load) Lbs.!IBefore shrink is Deducted $/cwtIlbs/day*ILbs of feed/ lb of gain (DM basis)IpercentI% of ration (DM basis)I% of ration (DM basis) Ipercent !H "@ #$I$/cwt (Sale Weight) %&I$/cwt OF GAIN'I$/cwt OF GAIN (H ) *@ +@ ,@ -H .H /H 0H 18 2H 3P 4X 5X 6P 7P 8H 9` :H ;H <H =H > ?H @H AH B CH DH EH FH G@ H I@ J@ K0 L0 M0 N0 O0 P0 Q0 Rh S0 TH U@ V@ W@ XH YH ZH [H \H ]H ^@ _@ ` a b c d e8 fH gP hX iX jP kP             H  H  H  H H H   H H ` ` ` ` ` ` H ` ` @ @ @  @ !p "@ # $H % &H ' ( )H *H + ,@ -@ .@ /H 0H 1H 2H 3` 4H 5` 6` 7` 8` 9` :H ;` <H =H >H ?H @ AH BH CH D EH FH GH HH I@ J@ K@ LH M0 N0 O0 PH Q0 R0 S0 Tp U V W0 X0 Y0 Z  [  \ ] ^  _ `0 a0 dx e f g` hH i` j` k` l` m`             H  H  H  H H H H H H H ` ` ` ` ` ` ` ` ` @ @ @  @ !@ "@ #H $ %H-&xgK?  G'a3:']@3 GzH@     (H )H * + ,@ -@ .@ /H 0H 1H 2H 3` 4H 5` 6H 7H 8` 9` :H ;` <H =H >H ?H @H AH BH CH DH EH Fx Gx Hx I@ J@ K@ L@ M0 N( O( P( Q0 R0 S0 T0 U0 V0 W0 X0 Y0 Z [  \  ]  ^  _ `0 a0 b f g` hH i` jH kH l` m`             H  H  H  H H H H H H H ` ` ` ` ` ` ` ` ` h p p  p !p "p #H $H %H&Ifeed cost /hd/day*'Iration cost/ton (dry matter basis) ( ) * + ,p -@ . /` 0` 1` 2` 3@ 4` 5P 6P 7` 8` 9H :H ;` <H =H >H ?H @H AH BH CH DH EH F G H I@ J@ K@ L@ M0 N O P0 QP R0 SP T0 U0 V0 W0 X0 Y0 Z  [  \  ]  ^  _ `0 a0 fH g@ h` iP jP k` l` m         ` ` ` ` ` ` ` ` h p p  p !p "p #p $p %p &p 'p (p )p *p +p ,p -@ . /` 0` 1` 2` 3` 4` 5` 6` 7H 8H 9H :H ;` <H =H >H ?H @H AH BH CH DH EH FH GH HH I@ J@ K@ L@ M0 N0 O0 P0 Q0 R0 S0 T0 U0 V0 W0 X0 Y0 Z  [  \  ]  ^  _ `0 a0 fH gH hH iH jH k l m         h h ` ` ` ` ` ` h p p  p !p "p #p $p %p &p 'p (p )p *p +p ,p - . / 0 1 2 3 4` 5` 6` 7H 8H 9H :H ;` <H =H >H ?x @H AH Bx CH DH EH FH GH HH I@ J K L M8 N8 O8 P8 Q8 R8 S8 T8 U8 V8 W8 X8 Y8 Z [ \ ] ^ _ `8 a8 bh ch dh eh                  X  X  H  H  H  H  H  H  H  H  H  H  !H  "H  #H  $H  %H  &H  'H  (H  )H  *H  +H  ,H  -H  .H  /H  0H  1H  2H  3H  4H  5H  6H  7H  8H  9H  :H  ;H  <H  =H  >H  ?H  @H  AH  B  C  D  EH  FH  GH  HH  IH  JH  KH  LH  M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z   [   \   ]   ^   _   `   a                   `  `  H  H  H  H  H  H  H  H  H  H  !H  "H  #H  $H  %H  &H  'H  (H  )H  *H  +H  ,H  -H  .H  /H  0H  1H  2  3  4  5H  6H  7H  8H  9H  :H  ;H  <H  =H  >H  ?H  @H  AH  BH  CH  DH  EH  FH  GH  HH  IH  JH  KH  LH  M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z   [   \   ]   ^   _   `   a                               H  H            H  H  H  H  H  H  H  H  X  H  H  H  !H  "H  #H  $H  %H  &H  'H  (H  )H  *H  +H  ,H  -H  .H  /H  0H  1H  2H  3  4H  5H  6H  7H  8H  9H  :H  ;H  <H  =  >  ?  @  A  B  C  D  E  F  G  H  I  J  K  L                                            H  H  H  H  H  H  H  H  H  x  H  x  !H  "x  #x  $x  %H  &x  'H  (H  )H  *H  +H  ,H  -H  .H  /H  0H  1H  2H  3H  4H  5H  6H  7H  8H  9H  :H  ;H  <H  =  >  ?  @  A  B  C  D  E  F  G  H  I  J  K  L                                            H  H  H  H  H  H  H  H  H    H    !H  "  #  $  %H  &  'H  (H  )H  *H  +H  ,H  -H  .H  /H  0H  1H  2H  3H  4H  5H  6H  7H  8H  9H  :H  ;H  <H  =  >  ?  @  A  B  C  D  E  F  G  H  I  J  K  LFIN_SUM$u<7~l7f,, ,,a@Ʌaaa ~ f,, ,,a@Ʌaaa ~ T& % % % %  )Financial Summary &1 Estimated Feeding Period                             $&Q---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- @  yDays on FeedAPounds to GainADate of Slaughter @Revenue)`@   ``   Expenses  Calf Death Loss  Vet.TruckingInterest*Enroll feeYardage Misc. Feed Corn Supplement =* Interest is charged on vet, trucking, & enroll fee9 as well as on the financed portion of feeder Q calves and feed.)Capital Requirements      ! " # $ % p  -e۶m۶-d@  ``$e @ $mm۶M@ `   lbs   price/unit @ ` {Gz?` 2@>@{Gz?`?"@ &Mb@ = ףp=? ?     !Feeder Calves !Feed Purchases  !!Trucking "!Vet.#!Yardage $"%!Total Capital Requirements H   H  H H P@`    units  lbs percent  head headpercent headhead/day head $/Bu (DM basis)$/lb. (DM basis)       Total@ $'1|@   !h@"<@#@ $"%Mb@P H H H H  H H  /cwt     P@          >::K@*  8Q?  ` `//$Qx@   ` `     Producer's  Share$%@  $%'1|۷@   (!5h@"5<@#5@ $("%=/ @P H H H H H H H        $/cwt          bu. dry cornlbs dry suppl.TOTAL COSTS NET INCOME    H ` H  ` !H "H #` $` % H H H H H H HPer head)uQ@  d   p  p) u33333{@  d $ u%u@  u2@u>@u\Q6@6  m      m      m   `````u$uI$I$ @ u"@ p$u*|`@ $uJtC@ "uIʹ@P x$j9M@  H H H ` @ ` P  P !` "` #H $ %H H H H H H H H Per Cwt.(uP@ d   p  p( uc}hB@ d ( uzGz? d ( uK+? d (uCc}h@ d (upK#? d (u d (uv:ы? d (uCc}? d  p(u`'@ d (u Lw @ d (u GM@ d  y (Dǽ@ d  H H H ` ` ` `  ` !H "H #H $ %H @ H H H H H H Total$u@ @  p  p$ u:@ @$ uX9v@ @$ u<@ @$uh@ @$ulliu@ @$u @$u@ @$u@ @ p$uSÉ@ @$u7A`F@ @$uج @ @ $`̎@       ` `  ` !H "H #H $ %H  p                                                                        !  "  #  $  %  H                                                                        !  "  #  $  %                                               !  "  #  $  %                                               !  "  #  $  %                                               !  "  #  $  % RISK_MGT$u<7~7f; Ʉ$ f; Ʉ$ H%***   BPrice floor is established as the current cash price plus any gains in a short position in the futures market with the strike price as the purchase price and the current futures price as the purchase price. Note that basis risk is not eliminated under options hedging. f Tahoma8Tahoma8")Risk Management Strategies ^*****Select a risk management strategy by entering a "y" in the appropriate cell.*****e*****Do not select more than one strategy at a time. Enter current price *****d*****information in yellow cells. Blue cells are calculated from these prices. ***** Forward Contracting H    Options Hedging  H Q Put Purchases     Q Call Sales     Futures Contract Hedging   Contract Sales " %         H!contracted price      H   !Strike price!Premium!Expected basis   Strike pricePremium Total premiums paidTotal premiums rec'd. Established price floor!Established price ceiling $Price floor at current basis     Contract sales price!Expected basis "( #$Established price floor %        HKO@         CO@C?K@   SS ( r@      , N@  =iO)  n/a;3n/aa s O@_        ;   0  C@P@!S@ "  #$$O@  %@         cwt          cwt cwt cwt   cwt cwt     cwt cwt  cwt   h   cwt !cwt "@ # $cwt %@                                   p   # %x & (` ) *                  x x x     0 ( ( (    &Futures Contract Hedge Summary #0 (` ) *       Contracting Summary!Total Revenue !Net Revenue   Options Hedge Summary !Min. Total Revenue !Min. Net Revenue&Total Revenue at current basis$Net Revenue at current basis        0   0   !Total Revenue !Net Revenue (` ) *        H(ףp= '@ d `$ U#G@  `    ( Q$@ d Oh+'0 `lx Cor JANDERSOroPigutoS JANDERSO1@@ jD@ mQuattro Pro for Windows 7 $ Gu+@  `(Gz@ d  $GкB@ `          (ףp= '@ d $ U#G@  (` ) *                      ! " #h $h %h &h 'h (p ) *              H                                H  H  H   H   H   H                                                               S d,#$# edGroup14Group1J:\ro_wM