ࡱ>  ~   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryFQ#@PerfectOffice_MAIN& SummaryInformation(8PerfectOffice_OBJECTS,Q#Q#)   solver_lhs6>   solver_lhs7>   solver_lhs8>  solver_lhs9'  solver_opt*dBY!_d<  ? xk($$  A   ? @      wY@W swW H H H (p lwwwwwwwwgt?ww@ H H H (p lwwwwwwwGpY@W swW X H X p lwwwwwwwwwwwwwwwwwwwwwwww>>w7 7 wwwwgpQpvww7 7 wwwwg!pQpvwwwwwwwG!pQpvwwwwwwwwwwwwwwww'!pQpvwgpwwwww lwwwwwH(%pww lww'ww'///////////////////o8pwww7|*`*``۞s.YAqwwwG!pQpvwg"x ZZuwxzxZ r'| z|sx|'OjUEhHZ HZ XMLhJ LLH OOh |wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwڂ*'""" "    $ $       Tq  d2X, X1Axis?  Ts  d2X, Y1Axis?   Tt  d2X, Y2Axis?  }j  d2X, 1PaneLeftWallRightWallBaseSeriesSeriesLabel?   Ym  d2X,  X1Title?  Yo  d2X,  Y1Title?  Yp  d2X,  Y2Title? L MTl  d2X, Legend?   }Z   Title? $Arial,Arial "]Z  . a%&'( 880d l X$ ArialZZ$ ArialZZ  LB  %&'( 0d  $ ArialZZ$ ArialZZ  B           ^ = @ ư>   ?' '  @5 5  , ,  ) )  % %  $ $    2@         / /  Q?0 0  ?@ @  ffffff?@ @  {Gz?@ @  Y@@@ )@@@ @@@ = ףp=?@@ (\?8 8 B B  =  &  Mb@?   #       f  g    i2      -./g  0d    LM/3$ ArialZ3Z3$ ArialZ3Z3$ ArialZ3Z3$ ArialZ3Z3$ ArialZ3Z3$ArialZ3Z3$ ArialZ3Z3$ArialZ3Z3$ Courier3Z3$ Arialr3Z3$ Arialr3Z3$ Arialr3Z3$ Arialr3Z3$ Arialr3Z3$ Arialr3Z3$ Arial NarrowZ3@ Normal Comma Comma0Comma_TM calculator CurrencyCurrency0 Normal_TM calculator  Percent0~33@ R033@ 833@ R033@ P033@ 033@I833@ 033@ 833@ 833@ 0~33@ @033@ 033@ A033@ 033@ 033@ 0W33@ 033@ 0,##D ̼##D 0,#3D 0.##D 0.#3D 0W33@ 0W33@ 0A33@ 0Q33@ @33@ 0S33@ 0S33@ 0S33@ 0@33@ 0B33@ 0.#3D 0.#3D 0.##D ̼##D 033@ 033@ 033@ 033@ 033@ 033@ 033@ 033@ 033@ @33@ @33@ @33@ @33@ 033@ @33@ 033@ B@33@ @33@ @33@ B033@ B033@ @ 33@ @033@ 033@ 033@ 0 33D 0 33@ 0$33@ 0"33@ 033@ 033@ 033@ 033@ 033@ 0 33@ 0R33@ @33@ 0R33@ 0 33@ 1 33D1 33D1 33D033@ 1E 33D1D 33D1T 33D1A 33D1@ 33D1P 33D0 33@ 033@ 0@ 33D 0P 33D 0 33@ 0D33D 0T33D 0E33D 033@ 033@ 033@  0 33@ 0(33@ `33@ 0E33D 0(33D 0833D 0Q833D 0A833D 0T 33D 0Q*33D 0Q 33D `E33D 0U*33D 0U 33D 0U*33D 0U 33D 0U*33D 0U 33D `33@ `33@ `33@ 033@ `33@ 0(33@ 033@ @6 33D@6 33D@f33D@633D@633D@6 33D@6A 33D@6@ 33D0@:33D @6P.33D@6 33D@633@@6 33@@6 33D0@33D 0@33D 0*33@ @6@33D@6P 33D0U33D 0U33D 0:33@ R0U33D P0U 33D 0:33@ 033@ 033@ @6E,33D@6D 33D@6T 33D033D R0U 33D Q033@ 0T(33D 0U(33D 0 33@ 0@33D 0@(33D 0@33D  0@ 33D 0(33@ 0U33D 0U(33D 0U833D 0U*33D B0E33D 0U33D 0833D 0*33@ B0*33@ 0U:33D 0,33D 0,33D `33D 033@ 0A,33D 0@,33D 0@>33D 0P.33D R0U33D P0U33D 0 33@ 0 33D 0 33D 0A(33D 0P33D Q0U 33D Q0U*33D @33@ `33@ `U33D 0Ey33D  0PK33D B`U33D `U33D 0DI33D 0TI33D 033@ 033@ 033@ 033@ 033@ 033@ 033@ 033@ 033@ B@33@ 033@ 033@ @33@ @33@ @33@ 0 33@ 0 33D A0C33@ @33@ 0B33@ 0P33@ 0P33@ 033@ 033@ @033@ @033@ @033@ @0~33@ 033@ 0 #3D 033@ @033@ h@33@ 033@ @33@ 033@ @0 ##D 0"#3D @033@ 0"##D 833@ 833@ 833@ B033@ @833@ C033@ @A033@ @ QFUNC1 -PUREAVG  Print_Area. a  solver_adj++  solver_lhs1+  solver_lhs10/  solver_lhs110  solver_lhs12>  solver_lhs2++  solver_lhs3(   solver_lhs4'   solver_lhs5/06KNAnswer Report 1$u<7~\i7;'ͅ7;'ͅ7*)Microsoft Excel 9.0 Answer ReportAWorksheet: [Ration calculator.xls]Feed Mixture Calculator*Report Created: 8/31/00 2:40:22 PM Target Cell (Min) Adjustable Cells Constraints Cell $G$43  Cell  $B$44  $C$44 $D$44 $E$44 $F$44 Cell $G$44 $G$41 $G$40 $G$42 $B$44 $C$44 $D$44 $E$44 $F$44 Namecost/lb. ration  Name lbs. milo lbs. bermudalbs. alfalfa, maturelbs. cornlbs. CSM Namelbs. rationNEg, Mcal rationME, Mcal rationprotein, % rationlbs. milolbs. bermudalbs. alfalfa, maturelbs. cornlbs. CSMOriginal Value? Original Value  Y@Cell ValueY@D?Lq?G&1?+ I@(H@<Final Valueɰrh? Final Value  + I@(H@<Formula$G$44=100$G$41>=0.4$G$40>=1.08$G$42>=0.094$B$44>=0$C$44>=0$D$44>=0$E$44>=0$F$44>=0StatusBindingBindingNot BindingNot BindingBindingNot BindingBindingNot BindingBinding Slack@Wz?+oMb@?+ I@(H@Feed Mixture Calculator$u<7~h7UUT3 +-++++       Feeding Rations %grain 4@ >@ D@ I@ N@ Q@ T@ @U@" % Fiber listed on feed tag @ @ @ @ @ @ @ "@ $@' ME, Mcal( NEg, Mcal) protein, %* cost/lb. + lbs.,iUse above matrix as starting point for doing least cost rations. Change values on Solver constraints (Under Tools) for ME (g40), NEg (g41), and protein (g42) to that desired for particular ration.m. Least Cost ration for ration containing 9.4% protein, .40 Mcal NEg/lb, and 1.08 Mcal ME is contained m/iin Answer Report 1. The ration contains 50 lbs. bermuda grass hay and 50 lbs. corn and costs .068/lb.0iTo balance for only daily requirements change c44 cell to 12.5 and under solver, g44 constraint to = 12.5 lbs. (expected daily dry matter intake from NRC tables) instead of g44=100 lbs. #22000 University of Arizona3Disclaimer: Neither the issuing individuals, originating unit, Arizona Cooperative Extension, nor the Arizona Board of Regents warrant or guarantee the use or results of this spreadsheet. %forage Y@ T@ Q@ N@ I@ D@ >@ 4@ .@{" *For 16% protein,deduct .5% TDN. For example a feed tag with 2% ash, 2% fiber, and 16% protein would be 86.1 % TDN.x# *For 10% protein,add .5% TDN. For example a feed tag with 2% ash, 2% fiber, and 10% protein would be 87.4 % TDN. & milo'?((\?)X9v?*sh|?? + bermuda grass hay  % CPsbX9ȶ? bermuda grass/corn  % CP6 !@"    6 GzG"@"    6 Q"@"    6 (\"@"    6 #@"    6 > ףp=#@"    6 {Gz#@"    6 Q#@"    6 أp= #@"    w Estimated TDN % in feeds containing 2% fat, 13% protein, and different levels of fiber as shown on feed labels*& bermuda'?(p= ף?)bX9ȶ?*? +dR- Least Cost Ration for 550 lb. medium frame heifer gaining 1.25 lbs. / day.  % TDNsq= ףp?  % TDN6 G@"    6 K@"    6 M@"    6 P@"    6 Q@"    6 @R@"    6 `S@"    6 T@"    6 U@"     @d U@P>d    ? 333333@ ?  #@ d fffffU@P>d    ? 333333@ ?  #@ d 43333SU@P>d    ? 333333@ ?  #@ d U@P>d    ? 333333@ ?  #@ d T@P>d    ? 333333@ ?  #@ d T@P>d    ? 333333@ ?  #@ d fffffT@P>d    ? 333333@ ?  #@ d 43333ST@P>d    ? 333333@ ?  #@ d T@P>d    ? 333333@ ?  #@  % LEAST COST SOLVER&ialfalfa, mature'333333?()\(?)Pn?*Q? +i alfalfa hay, mature  % CPsPn? bermuda grass/barley  % CP6 !@"    6 ffffff#@"    6 333333$@"    6 %@"    6 %@"    6 &@"    6 gfffff'@"    6 333333(@"    6 (@"    6 Different levels of ash + minerals on feed tag @d gffffFU@P>d    ? 333333@ ?  #@ d 33333U@P>d    ? 333333@ ?  #@ d T@P>d    ? 333333@ ?  #@ d ̬T@P>d    ? 333333@ ?  #@ d yT@P>d    ? 333333@ ?  #@ d gffffFT@P>d    ? 333333@ ?  #@ d 33333T@P>d    ? 333333@ ?  #@ d S@P>d    ? 333333@ ?  #@ d ̬S@P>d    ? 333333@ ?  #@   & corn'ףp= ?(q= ףp?)?*jt? + FEED MIXTURE CALCULATOR  % TDNs?  % TDN6 G@"     6 J@"     6 43333L@"     6 N@"     6 @P@"     6 333333Q@"     6 fffff&R@"     6 S@"     6 33333S@"      @d 33333T@P>d    ? 333333@ ?  #@ d T@P>d    ? 333333@ ?  #@ d lT@P>d    ? 333333@ ?  #@ d 9T@P>d    ? 333333@ ?  #@ d fffffT@P>d    ? 333333@ ?  #@ d 33333S@P>d    ? 333333@ ?  #@ d S@P>d    ? 333333@ ?  #@ d lS@P>d    ? 333333@ ?  #@ d 9S@P>d    ? 333333@ ?  #@   & CSM'Gz?(?)y&1?*v/? + corn  % CPsB`"۹? bermuda grass/oats  % CP6 !@"     6 Q#@"     6 Hz#@"     6 p= ףp$@"     6 %@"     6 (\%@"     6 Qk&@"     6 Gz'@"     6 (\h'@"      @d `T@P>d    ? 333333@ ?  #@ d ,T@P>d    ? 333333@ ?  #@ d S@P>d    ? 333333@ ?  #@ d fffffS@P>d    ? 333333@ ?  #@ d 33333S@P>d    ? 333333@ ?  #@ d `S@P>d    ? 333333@ ?  #@ d ,S@P>d    ? 333333@ ?  #@ d R@P>d    ? 333333@ ?  #@ d gffffR@P>d    ? 333333@ ?  #@  & rationr' ?^          ++++++r( p= ף?^          ++++++r) cX9ȶ?^          ++++++r* ?^          +<+ Y@(     * nutrient composition of feedstuffs  % TDNsQ? Feed Mixtures  % TDN6 G@"     6 J@"     6 K@"     6 M@"     6 N@"     6 P@"     6 P@"     6 Q@"     6 Q@"      $@d S@P>d    ? 333333@ ?  #@ d S@P>d    ? 333333@ ?  #@ d gffffS@P>d    ? 333333@ ?  #@ d 33333SS@P>d    ? 333333@ ?  #@ d S@P>d    ? 333333@ ?  #@ d R@P>d    ? 333333@ ?  #@ d R@P>d    ? 333333@ ?  #@ d fffffR@P>d    ? 333333@ ?  #@ d 33333SR@P>d    ? 333333@ ?  #@   barley  % CPsPn? alfalfa hay/corn  % CP6 )@"    6 Gz(@"    6 Q(@"    6 (\'@"    6 '@"    6 q= ףp&@"    6 zG%@"    6 RQ%@"    6 ףp= %@"     (@d yS@P>d    ? 333333@ ?  #@ d fffffFS@P>d    ? 333333@ ?  #@ d 43333S@P>d    ? 333333@ ?  #@ d R@P>d    ? 333333@ ?  #@ d ̬R@P>d    ? 333333@ ?  #@ d yR@P>d    ? 333333@ ?  #@ d fffffFR@P>d    ? 333333@ ?  #@ d 33333R@P>d    ? 333333@ ?  #@ d Q@P>d    ? 333333@ ?  #@    % TDN szG?  % TDN6  I@"    6  M@"    6  fffff&O@"    6  P@"    6  Q@"    6  fffffR@"    6  ̬S@"    6  33333T@"    6  gffff6U@"      oats  % CP sZd;?  alfalfa hay/barley  % CP6  )@"    6  )@"    6  )@"    6  )@"    6  )@"    6  )@"    6  )@"    6  )@"    6  )@"      % TDN sRQ?  % TDN6  I@"     6  ffffffL@"     6  N@"     6  O@"     6  P@"     6  Q@"     6  33333sR@"     6  LS@"     6  S@"       alfalfa hay/oats  % CP6  )@"     6  Q)@"     6  zGa)@"     6  > ףp=)@"     6  )@"     6  (\(@"     6  R(@"     6  Gz(@"     6  \((@"       % TDN6  I@"     6  K@"     6  fffffL@"     6  333333N@"     6  O@"     6  ffffffP@"     6  Q@"     6  33333Q@"     6  fffffR@"     Energy Calculator$u<7~ 7?      !"#$%&'()*+,-./ ?      !"#$%&'()*+,-./ $%%%       !"#$%&'()*+,-./yFeedstuff TDNSD@SE@SF@SG@SH@SI@SJ@SK@ SL@ SM@ SN@ SN@ SO@SO@SP@S@P@SP@SP@SQ@S@Q@SQ@[Qg`@ x Cow Wt.y@@@@@@ @ @@!0@"@#P@$@%p@ yME/kg6MIGp#?"d A`Т@ = ףp=? 6M$KK?"d A`Т@ = ףp=? 6MʸNs?"d A`Т@ = ףp=? 6MLR?"d A`Т@ = ףp=? 6M$U ?"d A`Т@ = ףp=? 6M[tYL?"d A`Т@ = ףp=? 6M]x?"d A`Т@ = ףp=? 6M`?@"d A`Т@ = ףp=? 6Me@"d A`Т@ = ףp=? Pasture Maintenance Mcal ME"@HzG%@zGa(@zGa+@333333.@0@ 2@!3333333@"4@#5@$7@%3333338@ yME/lb@M3?,&d A`Т@ p= ף@ = ףp=? @Mu^ ?,&d A`Т@ p= ף@ = ףp=? @MK?,&d A`Т@ p= ף@ = ףp=? @M Lȷ"?,&d A`Т@ p= ף@ = ףp=? @M{G/?,&d A`Т@ p= ף@ = ףp=? @Mɫ;?,&d A`Т@ p= ף@ = ףp=? @M\H?,&d A`Т@ p= ף@ = ףp=? @Mu 90U?,&d A`Т@ p= ף@ = ףp=? @ MH;a?,&d A`Т@ p= ף@ = ףp=? @ Mkvn?,&d A`Т@ p= ף@ = ףp=? @ M͡{?,&d A`Т@ p= ף@ = ףp=? @ Mn?,&d A`Т@ p= ף@ = ףp=? @ McTOC?,&d A`Т@ p= ף@ = ףp=? @MY?,&d A`Т@ p= ף@ = ףp=? @MN/?,&d A`Т@ p= ף@ = ףp=? @MC X ?,&d A`Т@ p= ף@ = ףp=? @M91LP?,&d A`Т@ p= ף@ = ףp=? @M-!h ?,&d A`Т@ p= ף@ = ףp=? @M#-?,&d A`Т@ p= ף@ = ףp=? @M9։?,&d A`Т@ p= ף@ = ףp=? @M E I$]?,&d A`Т@ p= ף@ = ףp=? @Mwi6@,&d A`Т@ p= ף@ = ףp=?   Lbs. TDN&=|k@ nBA? &=Eu@ nBA? &=). @ nBA? &={! @ nBA? &=Ϙ07k"@ nBA? &=hrLc $@ nBA? & =|k%@ nBA? &!=QMk'@ nBA? &"=$s)@ nBA? &#=Zʿe*@ nBA? &$=y,@ nBA? &%=t)Մ-@ nBA? yNEM/lbnMTŠ?ZHQ? Dl?   /$?   Q? p= ף@ nM*{5?ZHQ? Dl?   /$?   Q? p= ף@ nM΄hX?ZHQ? Dl?   /$?   Q? p= ף@ nMwE?ZHQ? Dl?   /$?   Q? p= ף@ nMUE;?ZHQ? Dl?   /$?   Q? p= ף@ nM?ZHQ? Dl?   /$?   Q? p= ף@ nMՖ?ZHQ? Dl?   /$?   Q? p= ף@ nMC?ZHQ? Dl?   /$?   Q? p= ף@ n M` ?ZHQ? Dl?   /$?   Q? p= ף@ n MV; ?ZHQ? Dl?   /$?   Q? p= ף@ n M5?ZHQ? Dl?   /$?   Q? p= ף@ n Mh%|?ZHQ? Dl?   /$?   Q? p= ף@ n M[~SK?ZHQ? Dl?   /$?   Q? p= ף@ nM%q?ZHQ? Dl?   /$?   Q? p= ף@ nMܺZ?ZHQ? Dl?   /$?   Q? p= ף@ nMtYRb?ZHQ? Dl?   /$?   Q? p= ף@ nM?ZHQ? Dl?   /$?   Q? p= ף@ nMγ:R?ZHQ? Dl?   /$?   Q? p= ף@ nMe`?ZHQ? Dl?   /$?   Q? p= ף@ nM%d{!??ZHQ? Dl?   /$?   Q? p= ף@ nM׫ٵ?ZHQ? Dl?   /$?   Q? p= ף@ nMlo?ZHQ? Dl?   /$?   Q? p= ף@  yNEg/lbnM˒š?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMF&?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM%עE?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM`J?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMb ?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMrg?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMbӉ1?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM͟ H?ZHQ? ʡE?   HP?   ffffff? p= ף@ n Mp?ZHQ? ʡE?   HP?   ffffff? p= ף@ n M˯?ZHQ? ʡE?   HP?   ffffff? p= ף@ n M%mE]?ZHQ? ʡE?   HP?   ffffff? p= ף@ n MEһK=?ZHQ? ʡE?   HP?   ffffff? p= ף@ n MN]s?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM ?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMC?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMꆫ?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMie?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM HX?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM)/ *,?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMa^i?ZHQ? ʡE?   HP?   ffffff? p= ף@ nM76x ?ZHQ? ʡE?   HP?   ffffff? p= ף@ nMy?ZHQ? ʡE?   HP?   ffffff? p= ף@    @1iBeef Milk:multiply by 12% for wet density hAnimal Req. - Feedlot Steer$u<7~78ͅ܅8ͅ܅< M=yuaTable 1. Nutrient requirements for growing and finishing cattle (nutrient concentration in diet dry matter, ) Weight (lb)!iMedium-frame steer calves r@ y@ @@ @! @( @/ @6 @@u>aTable 1. Nutrient requirements for growing and finishing cattle (nutrient concentration in diet dry matter, )? Weight (lb)O@iLarge-frame steer calves and compensating medium-frame yearling steers.A r@I y@Q @@Y @a @i @q @uzaTable 1. Nutrient requirements for growing and finishing cattle (nutrient concentration in diet dry matter, ){ Weight (lb)O|iLarge-frame steer calves and compensating medium-frame yearling steers.} @@ 0@Q Source: Adapted from feed tables in Nutrient Requirements of Beef Cattle,F 6th Revised Edition, 1984 by the National Academy of Science Daily Gain (lb);?;?;?;@ ;@ ;@  8 ;? ;?;?;@;@;@ 8;?;?;?;@;@;@ 8;?;?;?;@;@;@  8!;?";?#;?$;@%;@&;@ '8(;?);?*;?+;@,;@-;@ .8/;?0;?1;?2;@3;@4;@ 586;?7;?8;?9;@:;@;;@? Daily Gain (lb)A;?B;?C;?D;@E;@F;@G; @ H8I;?J;?K;?L;@M;@N;@O; @ P8Q;?R;?S;?T;@U;@V;@W; @ X8Y;?Z;?[;?\;@];@^;@_; @ `8a;?b;?c;?d;@e;@f;@g; @ h8i;?j;?k;?l;@m;@n;@o; @ p8q;?r;?s;?t;@u;@v;@w; @{ Daily Gain (lb)};?~;?;?;@;@;@; @ 8;?;?;?;@;@;@; @. NUTRIENT REQUIREMENTS OF BEEF CATTLE.  Dry Matter Intake (lb);333333@; @;gfffff!@;!@ ;!@ ; @  8 ;gfffff#@ ;$@;%@;&@;&@;$@ 8;'@;(@;)@;333333*@;*@;'@ 8;gfffff*@;333333,@;gfffff-@;.@;-@;+@  8!;-@";/@#;0@$;0@%;333330@&;gfffff.@ '8(;ffffff0@);1@*;3333332@+;2@,;2@-;0@ .8/;gffff1@0;3@1;gffff3@2;L4@3;3333334@4;L2@ 586;L3@7;333334@8;5@9;6@:;gffff5@;;3@.= NUTRIENT REQUIREMENTS OF BEEF CATTLE. ? Dry Matter Intake (lb)A;ffffff @B;gfffff!@C;333333"@D;"@E;333333#@F;333333#@G;"@ H8I;333333$@J;%@K;&@L;gfffff'@M;'@N;'@O;'@ P8Q;(@R;)@S;*@T;+@U;,@V;,@W;333333+@ X8Y;+@Z;333333-@[;.@\;/@];0@^;0@_;333333/@ `8a;.@b;ffffff0@c;3333331@d;1@e;2@f;2@g;1@ h8i;1@j;3333332@k;3@l;3@m;gffff3@n;gffff3@o;L3@ p8q;2@r;3@s;4@t;gfffff5@u;5@v;333335@w;5@.y NUTRIENT REQUIREMENTS OF BEEF CATTLE. { Dry Matter Intake (lb)} 3333334@~ 5@ 6@ 3333337@ 7@ 7@ 6@ 333335@ 7@ 8@ gffff8@ L9@ L9@ 8@ Protein Intake (lb)3?3gfffff?3> ףp=?3Q? 3Gz? 3?  0 3ףp= ? 3(\?3ףp= ?3(\?3(\?3gfffff? 03\(\?3(\?3HzG?3ףp= ?3Gz?3 ףp= ? 03HzG?3)\(?3Q?3Q?3 ףp= ?3Gz?  0!3zG?"3?#3?$3gfffff?%3?&3RQ? '0(3RQ?)3 ףp= ?*3HzG?+3Q?,3(\?-3(\? .0/3(\?03RQ?13(\?23p= ף?33Q?43? 5063333333?73?83ףp= ?93?:3Q?;3Gz?? Protein Intake (lb)A3p= ף?B3Gz?C3 ףp= ?D3Q?E3?F3Gz?G3Gz? H0I3{Gz?J3?K3?L3Q?M3> ףp=?N3(\?O3 ףp= ? P0Q3?R3\(\?S3gfffff?T3Q?U3Gz?V3Gz?W3@ X0Y3(\?Z3(\?[3?\3(\?]3(\?^3333333?_3ffffff@ `0a3\(\?b3(\?c3q= ףp?d3ףp= ?e3Gz?f3Gz@g3@ h0i3(\?j3)\(?k3zG?l3Q?m3\(\?n3(\@o3333333@ p0q3gfffff?r3?s3RQ?t3gfffff?u3> ףp=@v3 ףp= @w3Q@{ Protein Intake (lb)} ףp= ?~ ףp= ? ? Gz? Q@ Q@ Q@ HzG? RQ? zG? ffffff@ HzG@ @ > ףp=@ Protein (%);333333#@;&@;gfffff*@;-@ ;333330@ ;gffff3@  8 ;!@ ;$@;'@;gfffff)@;gfffff,@;0@ 8;!@;#@;%@;&@;)@;,@ 8;ffffff @;"@;#@;%@;&@;)@  8!;@";333333!@#;gfffff"@$;#@%;%@&;gfffff'@ '8(;@); @*;!@+;gfffff"@,;#@-;%@ .8/;gfffff@0; @1; @2;!@3;"@4;333333$@ 586;@7;333333@8;333333 @9; @:;!@;;#@? Protein (%)A;#@B;&@C;)@D;333333-@E;L0@F;2@G;L4@ H8I;!@J;gfffff$@K;&@L;gfffff)@M;+@N;gfffff.@O;fffff0@ P8Q;!@R;#@S;$@T;&@U;(@V;*@W;gfffff-@ X8Y;ffffff @Z;"@[;gfffff#@\;%@];&@^;333333(@_;gfffff*@ `8a;@b;333333!@c;gfffff"@d;#@e;%@f;333333&@g;(@ h8i;@j; @k;!@l;"@m;#@n;$@o;333333&@ p8q;gfffff@r; @s;!@t;!@u;"@v;#@w;$@{ Protein (%)};@~;333333@;ffffff @;333333!@;!@;"@;#@ 8;@;@; @; @;!@;!@;"@ NEm (Mcal/lb.)3?3> ףp=?3{Gz?3gfffff? 3HzG? 3gfffff?  0 3? 3> ףp=?3{Gz?3gfffff?3HzG?3gfffff? 03?3> ףp=?3{Gz?3gfffff?3HzG?3gfffff? 03?3> ףp=?3{Gz?3gfffff?3HzG?3gfffff?  0!3?"3> ףp=?#3{Gz?$3gfffff?%3HzG?&3gfffff? '0(3?)3> ףp=?*3{Gz?+3gfffff?,3HzG?-3gfffff? .0/3?03> ףp=?13{Gz?23gfffff?33HzG?43gfffff? 5063?73> ףp=?83{Gz?93gfffff?:3HzG?;3gfffff?? NEm (Mcal/lb.)A3Q?B3HzG?C3zG?D3{Gz?E3RQ?F3p= ף?G3Q? H0I3Q?J3HzG?K3zG?L3{Gz?M3RQ?N3p= ף?O3Q? P0Q3Q?R3HzG?S3zG?T3{Gz?U3RQ?V3p= ף?W3Q? X0Y3Q?Z3HzG?[3zG?\3{Gz?]3RQ?^3p= ף?_3Q? `0a3Q?b3HzG?c3zG?d3{Gz?e3RQ?f3p= ף?g3Q? h0i3Q?j3HzG?k3zG?l3{Gz?m3RQ?n3p= ף?o3Q? p0q3Q?r3HzG?s3zG?t3{Gz?u3RQ?v3p= ף?w3Q?{ NEm (Mcal/lb.)}3Q?~3HzG?3zG?3{Gz?3RQ?3p= ף?3Q? 03Q?3HzG?3zG?3{Gz?3RQ?3p= ף?3Q? NEg (Mcal/lb.)3?3ףp= ?3RQ?3)\(? 3RQ? 3{Gz?  0 3? 3ףp= ?3RQ?3)\(?3RQ?3{Gz? 03?3ףp= ?3RQ?3)\(?3RQ?3{Gz? 03?3ףp= ?3RQ?3)\(?3RQ?3{Gz?  0!3?"3ףp= ?#3RQ?$3)\(?%3RQ?&3{Gz? '0(3?)3ףp= ?*3RQ?+3)\(?,3RQ?-3{Gz? .0/3?03ףp= ?13RQ?23)\(?33RQ?43{Gz? 5063?73ףp= ?83RQ?93)\(?:3RQ?;3{Gz?? NEg (Mcal/lb.)A3q= ףp?B3Q?C3Q?D3RQ?E3)\(?F3\(\?G3> ףp=? H0I3q= ףp?J3Q?K3Q?L3RQ?M3)\(?N3\(\?O3> ףp=? P0Q3q= ףp?R3Q?S3Q?T3RQ?U3)\(?V3\(\?W3> ףp=? X0Y3q= ףp?Z3Q?[3Q?\3RQ?]3)\(?^3\(\?_3> ףp=? `0a3q= ףp?b3Q?c3Q?d3RQ?e3)\(?f3\(\?g3> ףp=? h0i3q= ףp?j3Q?k3Q?l3RQ?m3)\(?n3\(\?o3> ףp=? p0q3q= ףp?r3Q?s3Q?t3RQ?u3)\(?v3\(\?w3> ףp=?{ NEg (Mcal/lb.)}3q= ףp?~3Q?3Q?3RQ?3)\(?3\(\?3> ףp=? 03q= ףp?3Q?3Q?3RQ?3)\(?3\(\?3> ףp=? TDN (%);K@;@M@;O@;P@ ;`R@ ;@U@  8 ;K@ ;@M@;O@;P@;`R@;@U@ 8;K@;@M@;O@;P@;`R@;@U@ 8;K@;@M@;O@;P@;`R@;@U@  8!;K@";@M@#;O@$;P@%;`R@&;@U@ '8(;K@);@M@*;O@+;P@,;`R@-;@U@ .8/;K@0;@M@1;O@2;P@3;`R@4;@U@ 586;K@7;@M@8;O@9;P@:;`R@;;@U@? TDN (%)A;@J@B;L@C;M@D;O@E;P@F;R@G;S@ H8I;@J@J;L@K;M@L;O@M;P@N;R@O;S@ P8Q;@J@R;L@S;M@T;O@U;P@V;R@W;S@ X8Y;@J@Z;L@[;M@\;O@];P@^;R@_;S@ `8a;@J@b;L@c;M@d;O@e;P@f;R@g;S@ h8i;@J@j;L@k;M@l;O@m;P@n;R@o;S@ p8q;@J@r;L@s;M@t;O@u;P@v;R@w;S@{ TDN (%)};@J@~;L@;M@;O@;P@;R@;S@ 8;@J@;L@;M@;O@;P@;R@;S@ Ca (%)3ףp= ?3?3(\?3 ףp= ? 3ףp= ? 3Gz?  0 3HzG? 3RQ?3Gz?3Q?3(\?3Q? 03?3{Gz?3?3Gz?3Q?3Gz? 03q= ףp?3Q?3gfffff?3?3q= ףp?3> ףp=?  0!3)\(?"3HzG?#3ףp= ?$3(\?%3?&3\(\? '0(3)\(?)3Q?*3Q?+3ףp= ?,3gfffff?-3zG? .0/3zG?03q= ףp?13?23Q?33ףp= ?43Gz? 5063zG?73zG?83Q?93?:3HzG?;3{Gz?? Ca (%)A3333333?B3q= ףp?C3(\?D3gfffff?E3333333?F3Gz?G3(\? H0I3p= ף?J3Gz?K3Gz?L3> ףp=?M3?N3RQ?O3? P0Q3Q?R3Q?S3(\?T3q= ףp?U3?V3)\(?W3\(\? X0Y3)\(?Z3(\?[3gfffff?\3?]3Gz?^3p= ף?_3Q? `0a3zG?b3HzG?c3ףp= ?d3 ףp= ?e3?f3?g3p= ף? h0i3zG?j3Q?k3Q?l3{Gz?m3gfffff?n3?o3? p0 qqO.20r3q= ףp?s3HzG?t3(\?u3ףp= ?v3 ףp= ?w3?{ Ca (%)}3?~3q= ףp?3?3HzG?3(\?3{Gz?3gfffff? 03RQ?3zG?3q= ףp?3?3p= ף?3(\?3{Gz?  P (%) 3? 3Q? 3Q? 3{Gz?  3Gz?  3Gz?   0  3 ףp= ?  3zG? 3? 3p= ף? 3333333? 3Gz?  0 3(\? 3? 3)\(? 3Q? 3HzG? 3{Gz?  0 3 ףp= ? 3RQ? 3zG? 3)\(? 3Q? 3(\?   0 !3 ףp= ? "3 ףp= ? #3? $3zG? %3)\(? &3p= ף?  '0 (3(\? )3RQ? *3RQ? +3? ,3zG? -3?  .0 /3 ףp= ? 03 ףp= ? 13RQ? 23? 33? 43q= ףp?  50 63 ףp= ? 73 ףp= ? 83 ףp= ? 93RQ? :3RQ? ;3)\(? ? P (%) A3RQ? B3q= ףp? C3HzG? D3333333? E3(\? F3(\? G3?  H0 I3(\? J3? K3q= ףp? L3p= ף? M3333333? N3Q? O3 ףp= ?  P0 Q3(\? R3RQ? S3zG? T3Q? U3? V3Q? W3{Gz?  X0 Y3 ףp= ? Z3 ףp= ? [3? \3)\(? ]3q= ףp? ^3p= ף? _3Q?  `0 a3(\? b3RQ? c3RQ? d3zG? e3)\(? f3q= ףp? g3p= ף?  h0 i3 ףp= ? j3 ףp= ? k3RQ? l3? m3zG? n3)\(? o3Q?  p0 q3 ףp= ? r3 ףp= ? s3 ףp= ? t3? u3? v3zG? w3q= ףp? { P (%) }3(\? ~3(\? 3 ףp= ? 3 ףp= ? 3RQ? 3? 3zG?  0 3 ףp= ? 3 ףp= ? 3 ףp= ? 3 ףp= ? 3 ףp= ? 3RQ? 3zG?Show Steer Time Line$u<7~,7,)   saleweigh steerweigh steer$9full grain ration, 70% grain'final step up ration, 60% grain grower ration, 50% grain%be on 50% grain grower ration#11 lbs. grain LF; 8 lbs. MF"8 lbs. grain LF; 6 lbs. MF" 5 lbs. grain LF; 4 lbs. MF( 9change complete to alfalfa hay* * 3 lbs. grain unless preconditioned* 2 lbs. grain unless preconditioned% 9days until show from purchasehave steer purchased/Igrass hay for 3 d unless preconditionedPurchase WeightSale Weight}*Steers not used to alfalfa hay must be changed over from grass hay gradually; see AZ Cooperative Ext. Pub. # AZ1054.C @ 5@ -  5`@   5@   5@   5@   5 @   5 @   5`@    5@    5`@    5@@    5@  $ k@  5@   R& R~"!need to weigh 1100 to 1300;!monitor for 2.7 to 3.0 ADG, if not increase grain % 9need to weigh 700 to 900<9large frame steers weigh 800; medium frame weigh 600_!large frame steers 22 lbs. total feed/ day; medium frame steers 16 lbs. total feed /dayg!steers should be eating around 2.7% of body weight of total hay + grain each day (as fed basis) !ADG 2.0 to 2.2 9ADG needed J!large frame steers weigh 750 to 775; medium frame weigh 550 to 575- ]V.U.@   !until show or saleShow Steer Rations$u<7~7 [!A hr !@Arrow1 X {GX 7C? "!A ((-xxf@Arrow3 X {GX ? "\T<+<00     Feeding Rationsi%grain h 4@ >@ D@ I@ N@Q@T@@U@ [REVISED GRID WITH BUYING GOOD QUALITY MID-BLOOM ALFALFA HAY WITH 17% CRUDE PROTEIN.   TDN, %ME, McalNEg, McalNEm, Mcalprotein, %calcium, %phosphorus, %cost/lb. lbs.  !Use above matrix as starting point for doing least cost rations. Change values on Optimizer [under Tools; Numeric Tools] constraints !!for TDN (g 23), ME (g24), NEg (g25), NEm (g26), protein (g27), calcium (g28), and phosphorus as desired (g29) for a particular ration. D"!Max. & Min. grain constraints can also be set for h31 & i31. # $e%iBring steer up to grower ration according to directions in AZ Cooperative Ext. Pub. # AZ1054.\&iGrower ration to 750 to 800 lbs., 2.5 Average Daily Gain, purchase weight 575 lbs. '()lbs. milo))lbs. bermuda*)lbs. alfalfa, mid bloom+)lbs. corn,albs. CSM -.)lbs. alfalfa, mid bloom/)lbs. corn 0`F1PROVIDE FREE-CHOICE TM SALT BLOCK WITH THE ABOVE GROWER RATION 2B3!FEED THE FOLLOWING RATIONS WITH FREE-CHOICE TM SALT BLOCK 4!IN A SEPARATE FEEDER 5 c6!Step-up ration # 1 (after 800 lbs.), 60% grain for 7 to 10 days., 2.9 Average Daily Gain. 7)lbs. alfalfa, mid bloom8)lbs. corn 9v:!Finishing Ration, 70% grain until slaughter, 2.8 to 3.3 Average Daily Gain. Finishing weight 1100 to 1150 lbs.;)lbs. alfalfa, mid bloom<)lbs. corn =G>WITH FINISHING RATION, IT IS A GOOD IDEA TO FURNISH A SWEET-LIXB?MOLASSES BLOCK WITH RUMENSIN TO GUARD AGAINST GRAIN BLOAT. @FAAlso, avoid allowing the build up of "fines" in the feed bunk. B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ %forageY@ T@ Q@ N@ I@ D@>@4@.@ milo??(\?{Gz?sX9v?s-C6:?sF%uk?L7A`?P$!Least Cost Ration for 600 lb. medium frame steer gaining 2.5 lbs. / day.(+K]8&@)+*+H@++qC@,c0-!SO FOR SIMPLICITY SAKE USE THE FOLLOWING.kI@/kI@ 0` 3h 4h 5h7+C@8+ N@;>@<Q@ibermuda grass hay % CPbX9ȶ?bermuda grass/corn % CP6=!@"    6 =GzG"@"    6 =Q"@"    6 =(\"@"    6 =#@"    6 => ףp=#@"    6={Gz#@"    6=Q#@"    6=أp= #@"     bermudaq= ףp??p= ף?RQ?sbX9ȶ?sHPsr?sMb`?Q? +@ % TDNq= ףp? % TDN6=G@"    6 =K@"    6 =M@"    6 =P@"    6 = Q@"    6 =@R@"    6=`S@"    6=T@"    6=U@"    LEAST COST SOLVERialfalfa, mid blooms(\?gfffff?ףp= ?Q?sS?sS㥋?s/nb?{Gz?>@7(This requires processing by steam rolling, etc.*Cost/lb. feed+c I? -h .p/Cost/lb. feed0{~jt?7Cost/ lb. feed8UN@?;Cost/ lb. feed<Έ ? alfalfa hay % CP(\?bermuda grass/barley % CP6!@"    6 ffffff#@"    6 333333$@"    6 %@"    6 %@"    6 &@"    6gfffff'@"    6333333(@"    6(@"     cornQ?ףp= ?q= ףp?{Gz?s?s-C6*?sy&1l?;On?Q@ ,X 0p h % TDN(\? % TDN6=G@"     6 =J@"     6 =43333L@"     6 =N@"     6 =@P@"     6 =333333Q@"     6=fffff&R@"     6=S@"     6=33333S@"      CSM?Gz??p= ף?sy&1?s_Q[?s<,Ԋ?v/? 0p corn % CPB`"۹?bermuda grass/oats % CP6=!@"     6 =Q#@"     6 =Hz#@"     6 =p= ףp$@"     6 =%@"     6 =(\%@"     6=Qk&@"     6=Gz'@"     6=(\h'@"     rationrʡE?^          rsh|??^          rCl?^          r r?^          r:M ?^          ra)q?^          r|DL$zi?^          rΈ ?^          <Y@(     *nutrient composition of feedstuffs % TDNQ?Feed Mixtures % TDN6=G@"     6 =J@"     6 =K@"     6 =M@"     6 =N@"     6 =P@"     6=P@"     6=Q@"     6=Q@"     Max. grain,Q@   barley % CPPn?alfalfa hay/corn % CP6]1@"    6 ]> ףp=/@"    6 ]\(-@"    6 ]|Gz,@"    6 ]+@"    6 ]Q)@"    6]أp= W(@"    6](\&@"    6]QE&@"    Min. grain,Q@   % TDN zG? % TDN6 ]L@"    6  ]fffff&P@"    6  ]P@"    6  ]Q@"    6  ]R@"    6  ]33333sS@"    6 ]fffffFT@"    6 ]U@"    6 ]43333U@"      oats % CP Zd;? alfalfa hay/barley % CP6 1@"    6  Gz.0@"    6   ףp=/@"    6  Q.@"    6  fffff-@"    6  Gz-@"    6 (\B,@"    6 q= ףp+@"    6 Hz+@"     % TDN RQ? % TDN6 =L@"     6  =O@"     6  =33333sP@"     6  =Q@"     6  =Q@"     6  =ffffffR@"     6 = S@"     6 =33333S@"     6 =fffffT@"      i alfalfa hay/oats % CP6 =1@"     6  = ףp= 0@"     6  =Q/@"     6  =*\(.@"     6  =333333-@"     6  => ףp=,@"     6 =HzG+@"     6 =RQ*@"     6 =ףp= )@"      % TDN6 =L@"     6  =N@"     6  =23333O@"     6  =LP@"     6  =P@"     6  =333333Q@"     6 =fffffQ@"     6 =R@"     6 33333SR@"     Animal Req. - Feedlot Heifer$u<7~Ȭ78ͅW 8ͅW <heeeeeeee e M-uaTable 1. Nutrient requirements for growing and finishing cattle (nutrient concentration in diet dry matter, ) Weight (lb)"iMedium-frame heifer calves r@ y@ @@ @ @ @# @( @@u.aTable 1. Nutrient requirements for growing and finishing cattle (nutrient concentration in diet dry matter, )/ Weight (lb)Q0iLarge-frame heifer calves and compensating medium-frame yearling heifers.1 r@7 y@= @@C @I @O @U @[ @@a 0@Qg Source: Adapted from feed tables in Nutrient Requirements of Beef Cattle,Fh 6th Revised Edition, 1984 by the National Academy of Science Daily Gain (lb);?;?;?;@  8 ;? ;? ;? ;@ 8;?;?;?;@ 8;?;?;?;@ 8;?;?;?;@ 8;?;? ;?!;@ "8#;?$;?%;?&;@ '8(;?);?*;?+;@/ Daily Gain (lb)1;?2;?3;?4;@5;@ 687;?8;?9;?:;@;;@ <8=;?>;??;?@;@A;@ B8C;?D;?E;?F;@G;@ H8I;?J;?K;?L;@M;@ N8O;?P;?Q;?R;@S;@ T8U;?V;?W;?X;@Y;@ Z8[;?\;?];?^;@_;@ `8a;?b;?c;?d;@e;@. NUTRIENT REQUIREMENTS OF BEEF CATTLE.  Dry Matter Intake (lb);@; @;ffffff @; @  8 ;"@ ;#@ ;gfffff$@ ;$@ 8;&@;'@;333333(@;'@ 8;333333)@;+@;+@;+@ 8;333333,@;333333.@;/@;gfffff.@ 8;333333/@;333330@ ;3333331@!;0@ "8#;1@$;L2@%;2@&;L2@ '8(;2@);3@*;L4@+;3@.- NUTRIENT REQUIREMENTS OF BEEF CATTLE. / Dry Matter Intake (lb)1;333333@2; @3;!@4;!@5;gfffff!@ 687;gfffff#@8;%@9;%@:;333333&@;;%@ <8=;'@>;(@?;)@@;333333*@A;)@ B8C;gfffff*@D;333333,@E;-@F;.@G;333333-@ H8I;-@J;/@K;0@L;0@M;ffffff0@ N8O;ffffff0@P;1@Q;L2@R;2@S;2@ T8U;1@V;3333333@W;4@X;L4@Y;3@ Z8[;L3@\;4@];333335@^;6@_;5@ `8a;4@b;L6@c;L7@d;7@e;7@ Protein Intake (lb) \(\? Q? HzG? Q? zG? )\(? Q? p= ף? Gz? (\? ? ? p= ף? ףp= ? Q? (\? Gz? {Gz? > ףp=? \(\? Q? (\? \(\?! )\(?# (\?$ ףp= ?% {Gz?& (\?( > ףp=?) )\(?* q= ףp?+ (\?/ Protein Intake (lb)1 RQ?2 gfffff?3 Gz?43?5 333333?7 ףp= ?8 (\?9 Gz?: Gz?; )\(?= \(\?> (\?? Q?@ \(\?A Q?C HzG?D ?E (\?F p= ף?G Gz?I zG?J q= ףp?K ףp= ?L (\?M zG?O RQ?P zG?Q Q?R Q?S ףp= ?U (\?V RQ?W > ףp=?X ףp= ?Y {Gz?[ 333333?\3?] \(\?^3?_ HzG?a p= ף?b zG?c {Gz?d (\?e Gz? Protein (%);333333#@;&@;333333*@;333333.@  8 ;!@ ;gfffff$@ ;&@ ;)@ 8;!@;"@;$@;&@ 8;333333 @;!@;#@;$@ 8;@; @;"@;333333#@ 8;@;333333 @ ;!@!;"@ "8#;@$;333333@%;333333 @&;!@ '8(;@);gfffff@*;333333@+;333333 @/ Protein (%)1;#@2;&@3;*@4;333333-@5;333330@ 687;!@8;333333$@9;&@:;333333)@;;333333,@ <8=; @>;"@?;$@@;gfffff&@A;(@ B8C;333333 @D;!@E;333333#@F;$@G;gfffff&@ H8I;@J;!@K;"@L;333333#@M;$@ N8O;@P;ffffff @Q;333333!@R;"@S;333333#@ T8U;@V;@W;ffffff @X;333333!@Y;"@ Z8[;@\;@]; @^;ffffff @_;333333!@ `8a;333333@b;@c;@d;@e;ffffff @ NEm (Mcal/lb.) HzG? )\(? ףp= ? zG? 3HzG? 3)\(? 3 ףp= ? 3zG?3HzG?3)\(?3 ףp= ?3zG?3HzG?3)\(?3 ףp= ?3zG?3HzG?3)\(?3 ףp= ?3zG?3HzG?3)\(? 3 ףp= ?!3zG?#3HzG?$3)\(?%3 ףp= ?&3zG?(3HzG?)3)\(?*3 ףp= ?+3zG?/ NEm (Mcal/lb.)13?23(\?33?43Gz?53zG?73?83(\?93?:3Gz?;3zG?=3?>3(\??3?@3Gz?A3zG?C3?D3(\?E3?F3Gz?G3zG?I3?J3(\?K3?L3Gz?M3zG?O3?P3(\?Q3?R3Gz?S3zG?U3?V3(\?W3?X3Gz?Y3zG?[3?\3(\?]3?^3Gz?_3zG?a3?b3(\?c3?d3Gz?e3zG? NEg (Mcal/lb.) Q? ףp= ? )\(? ? 3Q? 3 ףp= ? 3)\(? 3?3Q?3 ףp= ?3)\(?3?3Q?3 ףp= ?3)\(?3?3Q?3 ףp= ?3)\(?3?3Q?3 ףp= ? 3)\(?!3?#3Q?$3 ףp= ?%3)\(?&3?(3Q?)3 ףp= ?*3)\(?+3?/ NEg (Mcal/lb.)13?23{Gz?33(\?43q= ףp?53?73?83{Gz?93(\?:3q= ףp?;3?=3?>3{Gz??3(\?@3q= ףp?A3?C3?D3{Gz?E3(\?F3q= ףp?G3?I3?J3{Gz?K3(\?L3q= ףp?M3?O3?P3{Gz?Q3(\?R3q= ףp?S3?U3?V3{Gz?W3(\?X3q= ףp?Y3?[3?\3{Gz?]3(\?^3q= ףp?_3?a3?b3{Gz?c3(\?d3q= ףp?e3? TDN (%);L@;O@; Q@;@S@  8 ;L@ ;O@ ; Q@ ;@S@ 8;L@;O@; Q@;@S@ 8;L@;O@; Q@;@S@ 8;L@;O@; Q@;@S@ 8;L@;O@ ; Q@!;@S@ "8#;L@$;O@%; Q@&;@S@ '8(;L@);O@*; Q@+;@S@/ TDN (%)1;K@2;M@3;P@4;`Q@5;@S@ 687;K@8;M@9;P@:;`Q@;;@S@ <8=;K@>;M@?;P@@;`Q@A;@S@ B8C;K@D;M@E;P@F;`Q@G;@S@ H8I;K@J;M@K;P@L;`Q@M;@S@ N8O;K@P;M@Q;P@R;`Q@S;@S@ T8U;K@V;M@W;P@X;`Q@Y;@S@ Z8[;K@\;M@];P@^;`Q@_;@S@ `8a;K@b;M@c;P@d;`Q@e;@S@ Ca (%) (\? )\(? zG? Gz? p= ף? ףp= ? ? > ףp=? Q?3333333? RQ? ? q= ףp? Q? {Gz? RQ? )\(? ? Q? {Gz? zG? )\(? Q?! Q?# zG?$ )\(?% )\(?& ?(3?)3?* zG?+ )\(?/ Ca (%)1 ףp= ?2 ?3 (\?43Gz?5 Q?7 HzG?8 ףp= ?9 ?: HzG?; ?= q= ףp?>3333333?? RQ?@ )\(?A (\?C )\(?D Q?E Q?F RQ?G )\(?I zG?J ?K (\?L Q?M RQ?O3?P Q?Q ?R Q?S Q?U3?V )\(?W q= ףp?X p= ף?Y (\?[ RQ?\3zG?]3zG?^3q= ףp?_3?a3RQ?b3?c3?d3zG?e3)\(?  P (%)  zG?  )\(?  HzG?  Q?  RQ?  3?  Q?  (\?  ףp= ? 3zG?  )\(?  Q?  ףp= ? 3?  zG?  q= ףp?  RQ?  RQ? 3?  )\(?  ףp= ?  ףp= ?  RQ? ! ? # ףp= ? $ ףp= ? % RQ? & RQ? (3RQ? )3 ףp= ? * ףp= ? + RQ? / P (%) 13? 2 Q? 3 ? 43333333? 5 gfffff? 7 ףp= ? 8 zG? 9 )\(? : p= ף? ; ףp= ? = (\? >3? ?3? @ Q? A p= ף? C ףp= ? D RQ? E RQ? F )\(? G Q? I ףp= ? J ףp= ? K RQ? L3? M )\(? O3(\? P ףp= ? Q ףp= ? R RQ? S zG? U3 ףp= ? V3 ףp= ? W3 ףp= ? X3 ףp= ? Y3? [3 ףp= ? \3 ףp= ? ]3 ףp= ? ^3 ףp= ? _3 ףp= ? a3 ףp= ? b3 ףp= ? c3 ףp= ? d3 ףp= ? e3 ףp= ?Animal Req. - Cowherd$u<7~7dgiڇpɉ4 d gi dgiڇpɉ4 d gi jaaaJa T Table 1. Nonlactating Range Cow TDN and Protein RequirementsYCow Wt. @ @ @@ 0@ @ P@ @ p@  Bulls YBull Weight P@ @ p@ @ @ @ @ @@dIForage Quality = 56% TDN; For Bulls Regaining BCS Add 2.1 lbs. TDN & .4 lbs. Crude Protein;UI1st Calf Heifers and Growing Bulls Add 2.1 lbs. TDN & .4 lbs. Crude Protein \ Table 2. Lactating Range Cow TDN and Protein RequirementsYCow Wt. @ @ @@ 0@ @ P@ @ p@3! Additional Requirements for Milk Production"YLbs. of Milk Production# @$ @% $@& (@' ,@( 0@) 2@* 4@+ 6@a,IForage Quality = 56% TDN; For 1st Calf Heifers Add 2.1 lbs. TDN & .4 lbs. CP to Top Req.Y. Table 3. Replacement Heifer TDN and Protein Requirements/QHeifer Weight0YPasture Repl. Heifers, "1YGaining .5 lb/day, 58% TDN2 y@3 @@4 @5 @!6YDrylotted Repl. Heifers,  7YGaining .5 lb/d, 58% TDN8 y@9 @@: @; @!<YDrylotted Repl. Heifers, !=YGaining 1.0 lb/d, 62% TDN> y@? @@@ @A @!BYDrylotted Repl. Heifers, !CYGaining 1.5 lb/d, 69% TDND y@E @@F @G @JYBody Condition ScoreK ?L @M @N @O @P @Q @R @S "@T *Forage = 56% TDNW MineralX ChromiumY CobaltZ Copper1H>Z8  Arial8[ Iodine \ Iron2H>\8  Arial8] Manganese^ Molybdenum3H>^8   Arial8_ Nickel` Selenium4H>`8  Arial8 a ZinccIAbove requirements are parts per million (ppm) or mg per kg of feed or forage. Above table adapted from 1996 NRC Requirements of Beef Cattle.da1Although Arizona is the copper state, many sites are deficient or marginally deficient in copper. Copper absorption can be negatively affected by H>d8Arial8eIhigh levels of molybdenum (if greater than 2 ppm), sulfur (if greater than .25%), and iron (if greater than 400 ppm). Researchers in Canada OfIsuggest increasing copper to 25 ppm in the last trimester of gestation.ga2Many areas of Arizona are already high in iron so that some nutritional consultants don't even put iron in the mineral supplement.H>g8Arial8dha3The ideal copper:molybdenum ratio is 6.0 to 10.0:1. The minimum acceptable ratio is 3.0:1. H>h8[Arial8ia4Selenium absorption is negatively affected by sulfur over .25%. Recently, allowable dietary selenium intake has been increased to H>i8Arial89jI.3 ppm/unit of feed or forage for cattle by FDA. YLbs. TDN;gfffff"@;333333$@;&@;gfffff'@;)@;*@;,@ ;-@ YLbs. TDN ;*@ ;,@;-@;/@;3333330@;1@;333331@;L2@YLbs. TDN gfffff"@ 333333$@ &@ gfffff'@ )@ *@ ,@ -@"YAddl. lbs. of TDN# ?$ gfffff@% 333333@& @' ffffff@( @) @* @+ @0Y% of Body Wt. 1YForage Intake2 ףp= @3 q= ףp@4 @5 Gz@6Y% of Body Wt. 7YForage Intake8 \(\@9 HzG@: Gz@; (\@<Y% of Body Wt. =YForage Intake> @? Q@@ (\@A > ףp=@BY% of Body Wt. CYForage IntakeD gfffff @E Q@F > ףp=@G (\@XI Table 4. Changing Body Condition Score (Daily Requirements for 1 lb. Daily Gain)JYPercentage Body FatK;@L;"@M;gfffff+@N;2@O;6@P;gffff:@Q;333333?@R;A@S;D@`V Table 5. Beef Cow Trace Mineral Requirements and Maximum Tolerable Levels in Forage, ppmWYGrowth & FinishingXY------------Y ?Z $@[ ?\ I@] 4@^Y------------_Y--------------` ?a >@YME, Mcal;333333.@;0@;2@;3333333@;4@;5@;7@ ;3333338@ YME, Mcal ;5@ ;7@;3333338@;gfffff9@;:@;;@;gffff<@;>@YME, Mcal 333333.@ 0@ 2@ 3333333@ 4@ 5@ 7@ 3333338@"YAddl. Mcal of ME# 333333@$ gfffff@% 333333@& 333333@' @( @) 333333!@* 333333#@+ 333333%@0YLbs. TDN 1X2 @3 !@4 "@5 $@6YLbs. TDN 7X8 @9 @: @; @<YLbs. TDN =X> @? !@@ gfffff"@A #@BYLbs. TDN CXD "@E #@F %@G gfffff&@JYNEg Required, Mcal*K \(\?L ?M Gz?N zG@O gfffff@P q= ףp@Q gfffff@R q= ףp @S (\ @WYGestationXY--------------Y ?Z $@[ ?\ I@] D@^Y--------------_Y------------` ?a >@YLbs. Protein;gfffff?;?;?;?;333333?;?;gfffff? ;@ YLbs. Protein ;? ;?;333333?;?;gfffff?;@;@;@YLbs. Protein gfffff? ? ? ? 333333? ? gfffff? @"YAddl. lbs. of protein# 333333?$ Q?% 333333?& ףp= ?' zG?( Q?) HzG?* 333333?+ Q?0YLbs. Protein 1X2 zG?3 Gz?4 p= ף?5 Gz?6YLbs. Protein 7X8 zG?9 Gz?: p= ף?; Gz?<YLbs. Protein =X> )\(?? (\?@ ףp= ?A {Gz?BYLbs. Protein CXD Q?E ?F Q?G > ףp=?JYTDN Required, lbs.*K @L @M @N @O gfffff@P @Q gfffff@R @S @WYEarly LactationXY--------------Y ?Z $@[ ?\ I@] D@^Y--------------_Y--------------` ?a >@#JYTotal Lbs. Forage for Gain*K @L 333333@M @N @O ffffff @P 333333#@Q %@R (@S )@WYMax. Tolerable LevelX ?Y $@Z Y@[ I@\ @@] @@^ @_ I@` @a @@Range Cow Forage Intake$u<7~O7܅̆܅̆:1.QTable 1. Estd. Forage Intake for Different TDN % for nonsupplemented cows Forage TDN, % Y<43 E@ F@ F@ G@ G@ H@ H@ I@ I@ J@ J@ K@ K@ L@ L@ M@ M@ N@ N@ O@ O@ P@ @P@ Y> 65i *There is a lag time for forage intake for lactating cows to catch up. See following suggestions: Month since calving ? @! @" @i$Table 2. Forage Intake Possible for Nonlactating Cows with Crude Protein Listed (Nonsupplemented)& Forage CP, %' @( @) @* @+ @, @- @. $@/ (@0 ,@1 0@l3 *For protein supplemented cows with forage CP < 7%, add 10 to 15% additional lbs. of forage intake.n4 Recently, researchers in Kansas concluded that protein supplementation with low quality forages could n5 increase forage intake by an average of 36%. They also concluded that high protein supplements caused <6 an increase in forage intake varying from 30 to 60%.#82000 University of Arizonao9Disclaimer: Neither the issuing individuals, originating unit, Arizona Cooperative Extension, nor the ]: Arizona Board of Regents warrant or guarantee the use or results of this spreadsheet.!)Forage Intake, % Body Wt.Lactating Cow*s9v?s9v?sy&1?sQ?s rh?s rh? s;On? s;On? s~jt? s{Gz? s/$?s/$?s/$?sI +?sZd;O?s~jt?s?s?s?s9v?sy&1?sV-?sQ?sMb?sMb?"&9Forage Intake, % Body Wt.*'s~jtx?(s;On?)s~jt?*s_vO?+sy):?,sl?-sl?.s~jt?/s+?0s{Gz?1s/$? 0NonLactating Cows9v?s9v?sy&1?sQ?s rh?s rh? s;On? s;On? s~jt? s{Gz? s{Gz?s{Gz?s{Gz?s/$?s/$?s/$?s/$?sI +?sZd;O?sZd;O?sZd;O?s~jt?s~jt?s?s?( Estd. Max. Intake, % of Body Wt. 2.2 to 2.5% 2.3 to 2.8%! 2.5 to 3.0%" Max. Intake possible &0W, At less than 6 to 7% CP, protein supplementation is usually economically sound.B. At CP > 10%, forage intake may increase above that listed. TM Forage Sampling Sheet$u<7~L7 a  a <          , iSamples collected on March 29, 1999  Remarks:    SPECIMEN  curley mesquite  side oats grama shrubby buckwheat  tobosa grass vine mesquite QAVERAGE iIS = insufficient sample; ND = not determined at LOQ (limit of quantitation) in parentheses; ppm = parts per million; all values reported on a dry matter basis.  h iMinimum Dietary recommendations: Copper (Cu) at 10 ppm if diet doesn't exceed 2 ppm Mo. Selenium (Se) at .1 to .3 ppm. Zinc (Zn) at 30 ppm.p Toxic levels of Se are 2 ppm. Toxic levels of Zn are 500 ppm. Toxic levels of Cu for cattle are 100 ppm. iPhosphorus (P) at .10 to .26% for 1000 lb. mature cows with peak milk production of 18 pounds, depending upon stage of lactation.  iPhosphorus (P) at .10 to .28% for 1000 lb. mature cows with peak milk production of 20 pounds, depending upon stage of lactation.R  Phosphorus (P) at .23% for pregnant replacement heifers in last trimester.O  Phosphorus (P) at .12 to .16% for growing yearling replacement heifers. iCalcium (Ca) at .13 to .40% for 1000 lb. mature cows with peak milk production of 18 pounds, depending upon stage of lactation.  iCalcium (Ca) at .13 to .43% for 1000 lb. mature cows with peak milk production of 20 pounds, depending upon stage of lactation.P iCalcium (Ca) at .32% for pregnant replacement heifers in last trimester.M iCalcium (Ca) at .19 to .30% for growing yearling replacement heifers.W iSulfur (S) at .15%. If over .25%, will negatively affect Cu and Se absorption.  iMolybdenum (Mo) requirements are not well established. If present at 20 ppm, can be toxic. Should probably not exceed 5 ppm.N If present at greater than 2 ppm, can negatively affect Cu absorption.S iIdeal Cu:Mo ratio is 6.0 to 10.0:1. The minimum acceptable ration is 3.0:1.g  Ideal Ca:P ratio is 1.5 to 2.0:1. Cattle can tolerate 4.0 to 7.0:1 ratio, but no less than 1:1.  Manganese requirement is 20 ppm for growth and finishing, 40 ppm for gestation, and 40 ppm for lactating. Max. tolerable level is 1000 ppm.3  Samples collected following long dry spell. Copper   ppm  @  ? @ @ @& ]Q@-  Selenium   ppm C{Gz? Ky&1? Cjt? CQ? C/$?& e46٬?-  Calcium   % 3)\(? 3Q? 3p= ף? 3{Gz? 3ףp= ?& mZd;?-  Sulfur   % C{Gzt? C~jtx? C~jtx? Cy&1? C~jt?& eI +?-   Mo   ppm 1ND (<0.5) 1ND (<0.5) 1ND (<0.5) 1ND (<0.5) 3zG?& mzG?-   Cu:Mo   Ratio$ = $ = $ = $ = $ =1 0 @ & ]-  Ca:P  Ratio$ 588@ $ 5c'vb'v@ $ 5*@ $ 5rq@ $ 5@ & m>'@-  Trace Mineral Calculator$u<7~77      G                       ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                                                                  7      G                       ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~                                                                                                                                  5dKB  PPPPPPPPP P P P P PPPPPPPPPPPPPPPPPPP P!P"P#P$P%P&P'P(P)P*P+P,P-P.P/P0P1P2P3P4P5P6P7P8P9P:P;P<P=P>P?P@PAPBPCPDPEPFPGPHPIPJPKPLPMPNPOPPPQPRPSPTPUPVPWPXPYPZP[P\P]P^P_P`PaPbPcPdPePfPgPhPiPjPkPlPmPnPoPpPqPrPsPtPuPvPwPxPyPzP{P|P}P~PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPM/@ iChange any of the following values in BLUE to obtain new3 levels of minerals for the salt/mineral mix  " Supplement calculator for:  8 Fill in the trace mineral values for your forage?  (leave blank or enter 0's for the ones you don't know)                 iCow weight, lbs )Cow weight, kg iDM intake, % bw )Forage intake, kg )Forage intake, pounds  5 !Approx. amount of salt eaten per cow per day:  = Composition of salt trace mineral mix to balance the 4  above forage at a salt consumption level of:                  !R "Mix Sheet for this trace mineral mix, using standard trace mineral sources  #  $  %  &  '  (  )  *  +  ,  -  .  / 0Supplement for:  10 2A. The following values were determined+ 3 for your range forage samples  4  5  6  7  8  9  :  ;  <  =  >  ?  @  A= BWe determined that your cattle will eat approximately  CA DqD. Composition of salt trace mineral mix to balance your. E forage at a salt consumption of:  F  G  H  I  J  K  L  M  N6 OqD. Sample Mix Sheet for this trace mineral mix1 P using standard trace mineral sources  Q  R  S  T  U  V  W  X  Y  Z  [ \E. Comments:b ]We determined that the amount of calcium that would have to be put into the mineral mix to) ^balance the trace mineral mix wase _We determined that the amount of phosphorus that would have to be put into the mineral mix to) `balance the trace mineral mix wase aIf these amounts are over 8% for calcium or over 6% for phosphorus, then program defaults to m b8% and 6% maximum. The amount of calcium and phosphorus in forage will increase when forage is green.m cNOTE: Palatability and intake of salt mix can be increased by adding feed byproducts to the salt mix.  d  e fDisclaimer: Neither the issuing individuals, originating unit, Arizona Cooperative Extension, nor the Arizona Board of Regents warrant < gor guarantee the use or results of this spreadsheet.  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~    p             Nutrient Calcium Phosphorus Copper Manganese Selenium  Zinc                        H ) Nutrient )Calcium )Phosphorus )Copper )Manganese )Selenium  )Zinc  !  "  # $) Nutrient  %)Salt &)Calcium carbonate ')Dicalcium phosphate ()Copper sulfate ))Manganese sulfate *)Sodium selenite +)Zinc sulfate  ,(  -  .  /  0  1  2  3  4 5yNutrient 6!Calcium 7IPhosphorus 8!Copper 9!Manganese :!Selenium  ;!Zinc  <  =  >  ?  @  A  B  C  Dx  E  FH G) Nutrient H)Calcium I)Phosphorus J)Copper K)Manganese L)Selenium  M)Zinc  N  O  PH  Q R) Nutrient  S)Salt T)Calcium carbonate U)Dicalcium phosphate V)Copper sulfate W)Manganese sulfate X)Sodium selenite Y)Zinc sulfate  Z(  [  \  ]  ^  _  `  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~    p              Value  333333? ? @   l? .@    h@& }tE]}@ @  #;On?$ .袋.!@ & fffff2@ @             H                !  "  #  $  %  &  '  (  )  *  +  ,Total  -  .  / 043. 0Example Ranchhhhhhhhhhhhh  1  2  3  4  5!Value 65333333? 75? 85@ 95 :5l? ;5.@  <  =X  >`  ?X  @  A  B  C  Dx  E  FH  G  H  I  J  K  L  M  N  O  PH  Q  R  S  T  U  V  W  X  Y  ZTotal  [  \  ]  ^  _  `  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~    p     Example Ranch          !%  !%  !ppm  !ppm  !ppm  !ppm    !lbs  kg    kg  lbs            H  qLevelT  @@" d  d ;;T @@" d  d ;;7 E]t@#  ;7 #  ;7 C]tJ@#  ;7 tE]@#  ;  !  "  #  $units  %ygm/kg  &ygm/kg  'ygm/kg  (ygm/kg  )ygm/kg  *ygm/kg  +ygm/kg  ,gm/kg  -  .  /  0  1  2  3  4  5qunits  6q%  7q%  8qppm  9qppm  :qppm  ;qppm  <  =  >  ?  @  A  B  C  Dx  E  FH  GqLevel H @ I@ JE]t@ K LC]tJ@ MtE]@  N  O  PH  Q  Rqunits  Sygm/kg  Tygm/kg  Uygm/kg  Vygm/kg  Wygm/kg  Xygm/kg  Yygm/kg  Zgm/kg  [  \  ]  ^  _  `  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~    p      0                                         ?  P  yUnits  q%  q%  qppm  qppm  qppm  qppm  !  "  # $qAmount& %|]@P O &--f@;) ףp= ?  (\?  ;* '.}+p@uV?  * ( *a@ h"lxz?  * )*:H?  * *W*?K7?  * +M6dM@Q?  " ,@@P  -  .  /  0H  1  2  3  4  5  6  7  8  9  :  ;  <  =  >  ?  @  A  B  C  Dx E?  FP  GqUnits  Hq%  Iq%  Jqppm  Kqppm  Lqppm  Mqppm  N  O  P  Q RqAmount& S|]@P O T--f@;) ףp= ?  (\?  ;* U.}+p@uV?  * V *a@ h"lxz?  * W*:H?  * XW*?K7?  * YM6dM@Q?  " Z@@P  [  \  ]@ ^Žx?,L<@  ;  _A `Žx?-L<@  ;  a  b  c  d  e  f  g  h  i  j  k  l  m  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~    x      8                     )Calcium, grams )Phosphorus, grams )Copper, mg )Manganese, mg )Selenium, mg )Zinc, mg   +?     !oz/day  XH NOTE: If calcium requirement is over 8%, program defaults to 8%.K NOTE: If phosphorus requirement is over 6%, program defaults to 6%.D YNOTE: 8% phosphorus may be near the upper palatability levelE NOTE: Palatability and intake of salt mix can be increased by/ adding feed byproducts to the salt mix.      !  "  #  $* %Should be at least 570 - 600 gm/kg  &  '  (  )  *H/3u]@    +  ,  -  .  /  0  1- 2B. The following values were used to2 3 determine feed intake by your cattle  4 5)Cow weight, lbs 6)Forage intake, lbs  7 8C. What's Missing 9 Calculations  : ;)Calcium, grams <)Phosphorus, grams =)Copper, mg >)Manganese, mg ?)Selenium, mg @)Zinc, mg  A Bm?  C  D Eoz/day  FX  GH HNOTE: If calcium requirement is over 8%, program defaults to 8%.K INOTE: If phosphorus requirement is over 6%, program defaults to 6%.D JYNOTE: 8% phosphorus may be near the upper palatability levelE KNOTE: Palatability and intake of salt mix can be increased by/ Ladding feed byproducts to the salt mix.  M  N  O  P  Q  R* SShould be at least 570 - 600 gm/kg  T  U  V  W  XH/3u]@    Y  Z  [  \