ࡱ> WZ  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVYR FXWorkbookSummaryInformation(DocumentSummaryInformation8 ;e\pmjboeseross Ba==x($J.8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1 Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Calibri1Calibri1Calibri1Calibri1hCalibri1Calibri1Calibri1@Calibri1PCalibri1Calibri1Calibri1Calibri1Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0 0.00000 0.0000 0.000                                                                       ff + ) , *   !  " P # P $  $ % &   ' ` (      )   * + a> , -  .  "  @   @  /  0  +"  @   0"8 0 (      @       b@   b @  0"8  0 p 0  + (b@@  +  +# # 1     2  + (`     (@@  (@ +8  @ +8 `   @@   @   @@   !@@   !@   @@  3   (@@  ( @ + (`@  + (`  +8@ @ +8`@  +"8`@   @  @   @@  ` + (e@@   e@   `e@   `Pe @   @@   `Q@ @   `@J@  @@   `@  @  `Q@ @  `@@J@  `Q@ @   `V@@ J@  `V@ J@ + (V@@   V@   @ @   @ @   @   @   !@  @ @       4  5  6" 7  8" 9   @  @ @  @ @   @ @   @@    @   @@    @   !@@   ! @   @ @    5  5  "@ @   @   @   !@   !@ @   !@ @   !!@ @   Q@   Q@ @   Q@   Q@ @  Q@  + QV@ @  + @ @    ||8}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}+ 00\);_(*}-}, 00\);_(*}-}- 00\);_(*}-}. 00\);_(*}-}/ 00\);_(*}(}0  00\);_(*}A}1 a00\);_(*;_(@_) }A}2 00\);_(*;_(@_) }A}3 00\);_(*?;_(@_) }A}4 00\);_(*23;_(@_) }-}5 00\);_(*}(}6  00\);_(*}}7 ??v00\);_(*̙;_(@_)    }A}8 }00\);_(*;_(@_) }A}9 e00\);_(*;_(@_) }}: 00\);_(*;_(@_)    }}; ???00\);_(*;_(@_) ??? ??? ??? ???}-}< 00\);_(*}-}= 00\);_(*}U}> 00\);_(*;_(@_)  }-}? 00\);_(*}-}@ 00\);_(*}-}A 00\);_(*}-}B 00\);_(*}-}C 00\);_(*}-}D 00\);_(*}-}E 00\);_(*}-}F 00\);_(*}-}G 00\);_(*}-}H 00\);_(*}-}I 00\);_(*}-}J 00\);_(*}-}K 00\);_(*}-}L 00\);_(*}-}M 00\);_(*}-}N 00\);_(*}-}O 00\);_(*}-}P 00\);_(*}-}Q 00\);_(*}-}R 00\);_(*}-}S 00\);_(*}-}T 00\);_(*}-}U 00\);_(*}-}V 00\);_(*}-}W 00\);_(*}-}X 00\);_(*}-}Y 00\);_(*}-}Z 00\);_(*}-}[ 00\);_(*}-}\ 00\);_(*}-}] 00\);_(*}-}^ 00\);_(*}-}_ 00\);_(*}-}` 00\);_(*}-}a 00\);_(*}-}b 00\);_(*}-}c 00\);_(*}-}d 00\);_(*}-}e 00\);_(*}-}f 00\);_(*}-}g 00\);_(*}-}h 00\);_(*}-}i 00\);_(*}-}j 00\);_(*}-}k 00\);_(*}-}l 00\);_(*}-}m 00\);_(*}-}n 00\);_(*}-}o 00\);_(*}-}p 00\);_(*}-}q 00\);_(*}-}r 00\);_(*}-}s 00\);_(*}-}t 00\);_(*}A}u 00\);_(*;_(@_) }-}v 00\);_(*}-}w 00\);_(*}A}x 00\);_(*;_(@_) }A}y 00\);_(*;_(@_) }-}z 00\);_(*}A}{ 00\);_(*;_(@_) }A}| 00\);_(*;_(@_) }-}} 00\);_(*}A}~ 00\);_(*;_(@_) }-} 00\);_(*}A} 00\);_(*;_(@_) }A} 00\);_(*;_(@_) }A} 00\);_(*;_(@_) }A} 00\);_(*;_(@_) }A} 00\);_(*;_(@_) }-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*;_(@_) }-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*;_(@_) }A} 00\);_(*;_(@_) }A} 00\);_(*;_(@_) }-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*;_(@_) }-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*;_(@_) }-} 00\);_(*}-} 00\);_(*}A} 00\);_(*;_(@_) }A} 00\);_(*-E;_(@_)  20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 F Followed Hyperlink   1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%64 Hyperlink   7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%3Normal % :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168dq:F3ffff̙̙3f3fff3f3f33333f33333\`]Sheet1aSheet2Sheet3"<Preliminary Data:Animals:Animal 1Animal 2Feeds:v This template is designed to assist members, parents and leaders in gaining a better understanding of the varioussfactors which need to be considered if selecting a 4-H Market Livestock project. Youth can utilize technology in passessing various factors in developing a project budget, thereby gaining a realistic perspective of what theirsproject might actually cost. While the budgeting concepts contained within the template can be used for non-marketqlivestock projects, several of the template calculations are designed specifically for Market Livestock projects.y To effectively utilize the capabilities of this template, members will need to provide information regarding certainsparameters of the animal(s) they intend to purchase and the type/value of feeds that they will be using. This datazwill be utilized in helping to calculate figures for the Feeds section of the actual budget form, found on page 2. If youponly have one project animal, then there is no need to enter information under the "Animal 2" heading. {Note: *"yellow" fields contain calculated values}Goat (0.33 ADG) Beef (2.80 ADG) Sheep (0.75 ADG) Sheep (0.50 ADG) Swine (1.80 ADG) Feed ConversionGrain(%)HayC Average Feed Conversion & Grain:Hay Ratio Table -- Market Animals8 Total Pounds Weight Gained (all animals):)*7% Grain% Hay lbs. Grainlbs. Hay, Estimated Total Pounds of Feed Purchased:C Total Estimated Pounds of Feed Needed for Project (all animals):45U Projected Feed Conversion Ratio (select value from chart or enter your own value):## Estimated Purchase Weight (lbs):"' Estimated Final Market Weight (lbs): !&% Projected Net Weight Gained (lbs):$K {Enter value from table above, or your own values - must total 100}q Note: some complete feeds may require supplemental roughage (hay) -- check feed tag for details. x Note: If feasible (grains especially) should be purchased in 2-3 week supplies to avoid feed becoming stale. : Estimated Average Feed Cost per Pound (enter in cents):)9F {Enter values in decimal format as shown in the examples below} V Hay costs $130 per Ton; $130.00 / 2000 = 0.065; enter 0.065 in box for HayB Gm Examples: 50 lb bag of feed costs $12.00; $12.00 / 50 = 0.24; enter 0.24 in box for GrainX \3 Estimated Total Project Feed Costs (in dollars):&2$ Grain $ [ {Copy these values to the Grain and Hay sections of the Budget template, on page 2}" ', /OVER1 Average Percentage Composition of Ration from: Member Name: Fixed Costs:pFixed costs cover items that typically have multiple years of serviceable "life" within the project area. Whilenthe initial cost may all occur within one year, the impact of that expense can be spread out over the expectedo"life" of that item. While you may not have to pay directly for these expenses, they are important to considerAin gaining a realistic picture of your total project esxperience.ExistingCost for ImprovementsValueType Description Fences/Panels Shelter/BarnFeed EquipmentWater Equipment>Total Fixed Costs (inc. Existing Value and Improvement Costs):=HThese are the costs and receipts that occur within a given project year. Premiums/Awards Other Income FeedPasture Supplements Health Care / VeterinaryJGrain / Concentrates (see bottom of previous page or enter own estimates)3 5 Hauling / TransportationT Animal Sale Value (see #14 of Project Planning Worksheet or enter own value)A CW Animal Purchase Value (see #12-B of Project Planning Worksheet or enter own value)D F INCOME (Est.)EXPENSES (Est.)! Interest (on money borrowed) Show Equipment Supplies Other Expense Total IncomeTotal Expenses!Estimated Profit or Loss (Annual)Annual Income & Expenses:HOverall Budget (including projected Fixed Costs & Annual Income/Expense) [Your estimated overall project profitiability for this year (based on data provided above):<ZmFixed costs are prorated over the number of years the member will be in project, then added to Annual budget.$ Marketing / Sales / Commissions! Entry Fees / Inspection Fees Date Prepared:  Species:.P:4-H/Livestock/ProjectPlanning/BudgetTemplateEHay / Roughages (see bottom of previous page or enter own estimates). 0THow many more years (including this year) do you plan to take this species in 4-H?)- 4-H Market Livestock Budget Template, 4-H Market Livestock Budget Template*4-H Market Livestock "Break-even" Analysisg Congratulations. Having completed the "4-H Market Livestock Budget Template" you have taken a big-Qkstep in beginning to operate like a successful, real world livestock producer. The most effective large & csmall-scale producers know and have an excellent understanding of their production costs, projecteddmarket prices and understand how these factors ultimately influence what they can afford to pay for danimals coming into their feedlots. Successful producers frequently conduct various "break-even" hanalyses to determine how changes in purchase price, sales price, or operating practices (feed, health, 0marketing, etc.) impact overall profitability. f Just like a producer, most members want to achieve a profit from their 4-H market animal project bdata & budget information provided above) what they can afford to pay when purchasing their marketflikely are striving to make a profit, they would not want to spend the entire estimated purchase priceTabove, the "break-even" figures below will automatically adjust upward or downward.}Seallowance listed below. {Note: as you make adjustments to the preliminary data and/or budget figures0budget, the more accurate these results will be.j It is important to realize that the more accurate members are in projecting actual costs within their)Estimated Animal Purchase Price Allowance3Project Animal Purchase Price "Break-Even" Analysiswithout Fixed Costwithn/a#Divided by Purchase Price Allowance%Estimated Purchase Weight (Animal #1)%Estimated Purchase Weight (Animal #2)cexperience. This section's calculations will help guide youth in determining (based on preliminaryhlivestock project animals - if they were to simply "break-even" (make no profit; have no loss). As they%Break-Even Purchase Price (per pound)"Total Income"6less "Total Expense" (excluding Animal Purchase Value),less "Fixed Cost" (on average annual basis )`Purchasing two animals (per preliminary data, must have income value entered for Animal 2 above) dPurchasing one animal (per preliminary data, must have income value entered for only Animal 1 above) P TV [Xp[\b ]Z_ b_ dX hd fefOgi7l;opmrcc PK!pO[Content_Types].xmlj0Eжr(΢]yl#!MB;.n̨̽\A1&ҫ QWKvUbOX#&1`RT9<l#$>r `С-;c=1gѠԯٴ++2a,/$nECA6٥D-ʵ? dXiJF8,nx (MKoP(\HbWϿ})zg'8yV#x'˯?oOz3?^?O?~B,z_=yǿ~xPiL$M>7Ck9I#L nꎊ)f><|HL|3.ŅzI2O.&e>Ƈ8qBۙ5toG1sD1IB? }J^wi(#SKID ݠ1eBp{8yC]$f94^c>Y[XE>#{Sq c8 >;-&~ ..R(zy s^Fvԇ$*cߓqrB3' }'g7t4Kf"߇ފAV_] 2H7Hk;hIf;ZX_Fڲe}NM;SIvưõ[H5Dt(?]oQ|fNL{d׀O&kNa4%d8?L_H-Ak1h fx-jWBxlB -6j>},khxd׺rXg([x?eޓϲكkS1'|^=aѱnRvPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-!pO[Content_Types].xmlPK-!֧6 -_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0ktheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] ;e (uPDӤȥ  dMbP?_*+%&333333?'333333?(?)?"d,,333333?333333?cU } } } *} }  @GGGGG , ;G G G GG@ , ,E ,E ,E ,E @ , @  ,  ,@ @     , c G G G G G @ G G G G G @ HB H E" E# E$% DDa% DDa E% #DD @ WQQQQQR IJ KJ K KL IJ SJ S SL IJ~ T@JTR@T9@M IJ~ T@JTQ@T>@M IJ~ T@JTR@T9@M IJ~ U@JTI@TI@M NO~ V@OVY@VP@sD4""`7$LLPPPP  @! " @# $ @% & ' ( @) * + @, - . / @0 @1 2 3 @4 5 6 7 ]8 9 @: ; @< @= @> @? @ !!! # %# )DD!x %1% %G% % G &G% 'F& )*) 1D%dD#4 )G*) 1D%dD#44 ) G *F' ,(, ,G, , G -G) .F+ /* 1G, 1Y-%1D)D, 1Z.%1%D)D, 1 G 2G/ 4H0 5b5[ 6X^ 6 8X28 8] 8 :A3:j ;G4 <G5 =G6 >77>><@ _A X B ,@C ,@D ,@E ,@ F @G H @I J K @ L ,@0M @N @O @P @Q @R @ S ,@0T @U @V @W @X @Y @Z @[ @\ @] @^ @_ @@`akaaal @o8 @ b9 Aq< A^m^ A^= A^n Ap; A c: Bd?Be Cf>CC Df@DC EgAEh GB1G%BE%BE  IAW JGC LvNLwxxxxxxy MzLMeeeeeee{ N| NsN\\\\\\ O| OiOCCCCCC P}DPCCCCCCC Q}EQCCCCCCC R~uuuu RJT RJJ#R  %NQ x SvOSwxxxxxxy TMTJJJJJJJ U UtUDDDDDD V| ViVCCCCCC W}FWCCCCCCC X| XrJXJJJJJJ Y| Yi`YCCCCCC Z| ZiGZCCCCCC [| [iH[CCCCCC \}\\CCCCCCC ]}K]CCCCCCC ^}I^CCCCCCC _}P_CCCCCCC Dl4V((((C((00((W((00(0000(((` @a @b @c @d @ e ,@0f @g h @i @j k @l m @n prstuvwxyz{|}~ `}[`CCCCCCC a}QaCCCCCCC b}RbCCCCCCC c}ScCCCCCCC d~uuuu dJU dJJ#d R %Uc EXe eV e%e l DR Dd d gX hGZ ja j lY+l De DGDj e nF_ pd re sf tg uh vi wj xk yl z| {m |} }n ~p o@D((((WY=   h  @ @          , i@  @  @    , @   @  r q t uB w vB v DR A!DR A!  #G %Xc # %Xc    x%d DGDj   sXXXX%DD+DDD      zDA!DA!  y;%DO  $B;%DO  $B  X~%)DDe%DDe      z;%D $BDA! {;%D $BDA!  y;e %DO  $B;%DO  $B@KD&&\fO\tyy @   X~-DDD1,DDD>=@@j jj gg@&<3 ;e I  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?U } >&<3 ;e   dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?U } >&<3   Oh+'0HP`t 'jwilson Laura KrossMicrosoft Macintosh Excel@q @3~@` ՜.+,0 PXt | ' Sheet1Sheet2Sheet3  Worksheets F$Microsoft Excel 97 - 2004 Worksheet8FIBExcel.Sheet.8CompObj b