ࡱ>   Worksheet&Tools&WindowChart&Tools&WindowVisual Basic Module&Tools&Window\psmitae Moore B AnalysisChartTableVDlg6__123Graph_ACHART 2; !6__123Graph_ACHART 2='''6__123Graph_BCHART 2; !6__123Graph_BCHART 2='''6__123Graph_CCHART 2= 6__123Graph_CCHART 2='''6__123Graph_DCHART 2; !6__123Graph_DCHART 2=''' __IntlFixup(Analysis:(BENEFITS:%Data1: &Data10: &Data11:&Data12:&Data13:&Data14: &Data15:&Data16:&Data17: &Data18:&Data19:%Data2: &Data20: &Data21:&Data22: &Data23:&Data24:&Data25:&Data26: %Data3:&Data31:&Data32:&Data33:&Data34: &Data35:"&Data38:#%Data4:&Data41:$&Data44:%&Data47:&%Data5:&Data50:'&Data53:(&Data54:,&Data55:,&Data56:)&Data59:*%Data6: &Data62:+&Data63:! %Data7:%Data8: %Data9: Macros.Nada!Macros.Village_But1!Macros.Village_But2!Macros.Village_But3/NameArea9;$9/NameArea9<9)PCHART;  $ ;1 $ ;  $ ;( )PRTCHT;  %Table:3 Village_But19CX%3 Village_But29D`03 Village_But39E`> ZoomFactord=b%f8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1hArial1 Arial1Arial1Arial1Arial1Arial1Arial1Times New Roman1Tahoma1QTahoma1Arial1Times New Roman1Arial1 Times New Roman1 Arial1 Arial1 Times New Roman1hTimes New Roman1Times New Roman1Times New Roman1Arial1Times New Roman1 Times New Roman1Times New Roman1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) dd\-mmm\-yy_) 0.00_)0_) 0.0000_);; dd\-mmm\-yy dd\-mmm mm/dd/yymm/yyGeneral;[Red]\-General;;; General_) mm/dd/yy_);8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)74_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)0.0%"$"#,##0.0_);\("$"#,##0.0\)#,##0\ "DM";\-#,##0\ "DM"!#,##0\ "DM";[Red]\-#,##0\ "DM""#,##0.00\ "DM";\-#,##0.00\ "DM"'$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM"<9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_-<9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-DA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-DA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_-"CHF"\ #,##0;"CHF"\ \-#,##0# "CHF"\ #,##0;[Red]"CHF"\ \-#,##0$!"CHF"\ #,##0.00;"CHF"\ \-#,##0.00)&"CHF"\ #,##0.00;[Red]"CHF"\ \-#,##0.00A>_ "CHF"\ * #,##0_ ;_ "CHF"\ * \-#,##0_ ;_ "CHF"\ * "-"_ ;_ @_ ,)_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ IF_ "CHF"\ * #,##0.00_ ;_ "CHF"\ * \-#,##0.00_ ;_ "CHF"\ * "-"??_ ;_ @_ 41_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ A>_("CHF"* #,##0.0_);_("CHF"* \(#,##0.0\);_("CHF"* "-"??_);_(@_)=:_("CHF"* #,##0_);_("CHF"* \(#,##0\);_("CHF"* "-"??_);_(@_)#,##0.00\ "DM"#,##0.00\ _D_M""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00!""#,##0.00;[Red]\-""#,##0.0030_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-*'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-;8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-2/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- ""\ #,##0.00%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\1%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\2%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\3%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\4%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\5%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\6%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\7%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\8%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\9%""CHF"\ #,##0.00;\-"CHF"\ #,##0.\10&#"CHF"\ #,##0.00;\-"CHF"\ #,##0.\1\1&#"CHF"\ #,##0.00;\-"CHF"\ #,##0.\1\2&##,##0.00_ "DM"\);\(#,##0.00\ "DM"\)$!#,##0.00_ "DM";\(#,##0.00\ "DM"\)&#"CHF"\ #,##0.00_;\("CHF"\ ###0.00\)%""CHF"\ #,##0.00;\("CHF"\ ###0.00\)&#"CHF"\ #,##0.00;\("CHF"\ #,##0.00\)'$"CHF"\ #,##0.00_ ;\("CHF"\ ###0.00\)&##,##0.00_ "CHF";\(#,##0.00\ "CHF"\)&##,##0.00\ "CHF";\(#,##0.00\ "CHF"\)(%"SFr."\ #,##0.00;\("SFr."\ #,##0.00\) "$"#,##0.002/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_).+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) :               :+ )   , *           :    :  :  :  :  :  :  :  :  :  : : :   :  :  :  : : :  :  :  :      :   :  :  :   :          :  :    :  :   :       #܉ : @  @   H   h    h &  h &   h &  h   h &  h   h A& hA& :A- :, ` A- ` ( ` A-& ` @  ` AE'  p ( p @  ?   : &p x (&x   &&  &   ؉     ؉ A&9& A&A&  ȉ  & A&   &  &   # !   @ ! @& A& A&@ x (@&x (@ ȉ   &&x &x &x "x#x ## !x "|""| ` A-f  h Af ` AEg  :Afx x *x x '&p '&x '&p ' x &p  &x '&x '&x ' &x &&x &&x & !x @  ȉ A&' #؉ ؉x x  `  `  `   `  `  `  &x '&x ' x &&x &&x &  ` ' ` ' ` ' !x @ !p @ x &x &x &p &p &p  &x '&p &&x &&p & x &x &x '&| '&x ' Comma [0]_Int. Data TableComma_Int. Data TableCurrency [0]_Int. Data TableCurrency_Int. Data Table'$Dezimal [0]_Compiling Utility MacrosDezimal [0]_FixerSetupDlg"Dezimal [0]_TemplateInformation# Dezimal_Compiling Utility MacrosDezimal_FixerSetupDlgDezimal_TemplateInformationNormal_About_Macros_EXCELNormal_ChgLoan Normal_Code!Normal_Customize!"Normal_Customize Your Budgeter #Normal_Customize Your Invoice$Normal_Int. Data Table%Normal_Int. Data Table_1&Normal_Int. Data Table_Lock 'Normal_Int. Data Table_Macros(Normal_Int. Data Table_VDlg) Normal_Lock* Normal_Lock_1+ Normal_Lock_2, Normal_Macros-Normal_Macros_1.Normal_Macros_2/Normal_Macros_EXCEL0Normal_Macros_VDlg1Normal_Maint_12Normal_Maint_1_13Normal_Maint_1_24Normal_Maint_25Normal_Maint_2_16Normal_Maint_2_27Normal_Maint_2_Macros8Normal_Maint_2_Maint_19Normal_Specifics:Normal_VBMacros; Normal_VDlg<Normal_VDlg (2)= Normal_VDlg_1> Normal_VDlg_2? Normal_VDlg_3%@"Normal_VDlg_Customize Your InvoiceANormal_VDlg_MacrosBNormal_VDlg_Macros_1CNormal_VDlg_VDlgDNormal_Village_Store!ENormal_Village_Store_CustomizeFNormal_Village_Store_Lock GNormal_Village_Store_VBMacrosH%I"Standard_Anpassen der AmortisationJ Standard_ATW$K!Standard_Compiling Utility MacrosLStandard_FixerSetupDlgMStandard_SperrenNStandard_Sperren_1OStandard_TemplateInformation!PStandard_TemplateInformation_1'Q$Whrung [0]_Compiling Utility MacrosRWhrung [0]_FixerSetupDlg"SWhrung [0]_TemplateInformation#T Whrung_Compiling Utility MacrosUWhrung_FixerSetupDlgVWhrung_TemplateInformation8 ``i̜̙3f3333f3ffff333ff333f33f33BBB6Analysis 5XChart wTable |VDlg  q8HOtRS  dMbP?_*+%&?'?(?)?MHP LaserJet 5PBT@g ,,b@MSUDOHP LaserJet 5P<d"[,,??ChartTableVDlgcU} @} `} } }  } }  ` } } `} sample1Microsoft CorporationVillage Software          JanuaryWidget350575071501200502001000 sample2Microsoft CorporationVillage Software "#$%&'(,,)*+! &Enter any necessary notes here such as(figures for calculating your revenue per unit figure.150 # current1 Jim Davidson#Created by Jim Davidson on 12/29/98          # current2 Jim Davidson#Created by Jim Davidson on 12/29/98 ,,"#$%&'()*+!  q$"T0@ "b@"*@b"@ "w@" @"@ "Jb "Jb  " @0 "x @ "@ "@"@"@ @ T0@ @ b@ 0@ @ @ @ @ b@ @@ @ T0@ b@T @ T0@  T0@bggeeeeeeegg hZYYYYYYYZj hZYYYYYYYZj hZYYYYYYYZj h7/Harvard ManageMentor - FINANCE ESSENTIALS TOOLSj hZYYYYYYYZj Breakeven AnalysisBqssssssmXXXXXXXXXXXXXXXXXXXXX!}Use this tool to determine a break-even volume, the point at which total contribution equals fixed costs for your initiative.  { sThis will be calculated automatically as you enter your fixed costs, variable costs, and pricing information below.   hZYYYYYYYZj  h_ttttuuuvj h`  Period:  n o wxxxyj h` z z {xxxyj h` Product: nozxxxyj h`|zzz|||yj h`|||||||yj h` Fixed Costs / Investment }~Variable Costs per Unit }~yj h`yj h`Item 1 Item 1 yj h`Item 2 Item 2 yj h`Item 3 Item 3 yj h`Item 4 Item 4 yj h`Item 5 Item 5 yj h`Item 6 Item 6 yj h`Item 7 Item 7 yj h`Item 8 Item 8 yj h`yj h`'Total Fixed Costs / Investment:! %&Total Variable Costs per Unit: ! # %   yj h`yj h`WWyj h`yj h` Notes:   Unit Revenue: yj D{ l a n Q>> w TTTTTTTT ! T0@" b@# @b$ @% @& @' @( b@) @b* @+  @, @"- @. @ / <@0 1 T0@"2 @3 b@4 0@5 @6 @7 @8 @9 b@: @@; @< T0@= b@T> @? T0@@$$T0@b!h`!Unit Contribution:! ! tri D D  ! yj "h`"Breakeven Volume /" yj #h`$#Incremental Volume Required:# U# L! ?DD D AA~DD D AB # yj $h`yj %h`yj &h`yj 'h`yj (h`yj )h`yj *h`yj +h`yj ,haj -hbj .hbj /icdddddddck 0hg0_ 1999 by the President and Fellows of Harvard College and its licensors. All rights reserved.0 +0 #Developed by Village Software, Inc.0 j1hZYYYYYYYZj 2fffffffffff DploF A$$T0@B$$b@C$$@bD$$@E$$@F$$@G$$@H$$b@I$$@bJ$$@K$$ @L$$@M$$@N$$@O$$@P$$@Q$$T0@R$$@S$$b@T$$0@U$$@V$$@W$$@X$$@Y$$b@Z$$@@[$$@\$$T0@]$$b@T^$$@_$$T0@`$$T0@bDla$$T0@b$$b@c$$@bd$$@e$$@f$$@g$$@h$$b@i$$@bj$$@k$$ @l$$@m$$@n$$@o$$@p$$@$@,]0  @u,Text 7cNote: Italic items are samples that should be replaced. Shaded cells contain formulas and should not be overwritten. u N\VAfter fixed cost data is entered the template will automatically calculate the total. Y SAfter variable cost per unit data is entered the template will calculate the total.B<Shaded cells contain formulas and should not be overwritten.=b%f8X> ????m0bQt TbEbVbhT0bbq0bb0bhTbAq0Fq0b mhT0(*xbb]l0bDl0(*bxbbblԭb0Bbbqq     " H@  "BZab  dMbP?_*+%&?'?(?)?MHP LaserJet 5P?@g ,,@MSUDOHP LaserJet 5P<d"d,,?? AnalysisTableVDlgcU} @} `} } @ }  ` } } ` "  T0@ b@  @b *@ @ h@  *@ Ob@  @b   @  i @   ,     0T  T b 0    _ p ,0b  l ,b  <0@  b@ggeeeeegg hZYYYYYZj hZYYYYYZj hZYYYYYZj h7/Harvard ManageMentor - FINANCE ESSENTIALS TOOLS h h  ! Breakeven Analysis: Chart   hZ RThis chart is automatically generated from the data entered on the analysis sheet.   hj  h`bbbbb\j  h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j h`[[[[[\j ha]]]]]^j hbbbbbbbj hbbbbbbbj  hg_ 1999 by the President and Fellows of Harvard College and its licensors. All rights reserved. + #Developed by Village Software, Inc. jhbbbbbbbj B,X]G  T0@ ! ,b hZYYYYYZj !fffffffff `]^ T 仝/@g<977g  &APage &P"Pag ??3 AnalysisTableVDlg 323   4 3Q:   Fixed CostsQ; !Q; !3      4E4 3Q:  Variable CostsQ; !Q; !3      4E4 3Q:  Total ContributionQ; !Q; !3     4E4D FA . 3Oe z3 & 43*"& 4%ZK3ON&Q Number of Units'4%I3O#&Q  Dollars'4523  43" I ",3OF %3O&Q423  44$%3O&Q443" $%3O&Q4444 * 0 0 0 NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE NONE   !!!"""###$$$%%%&&&'''((())) =b%f8X> ????m0bQt TbEbVbhT0bbq0bb0bhTbAq0Fq0b mhT0,xbb]l0b(*Dl0,bxbbbl"bbqq     CHART 2Number of UnitsDollars\D27\E27\F27\G27qqqq     Custom page 1" @  *y  dMbP?_*+%&?'?(?)?MIBM 4039 LaserPrinter@w,,@MSUDOIBM 4039 LaserPrinterd "b,,?? AnalysisChartVDlgcU} @} `} } } } ` *T0@b@ @b@ w@O@@ hb@ ,@b x@  ,  ; 0  bb  b 0    _ p 0b  @  @ bggeeeegg hZYYYYZj hZYYYYZj r7/Harvard ManageMentor - FINANCE ESSENTIALS TOOLS r !Breakeven Analysis: Table l]UThis table is automatically generated from information entered on the Analysis sheet.  l? 7It is only used to create the Chart on the Chart sheet. qqq 6 lXXXXXXXXXXXXXXXX h`bbbb\j h` Number of Units  Fixed Costs Variable Costs Total Contribution \j h`~ ( !Z- !D Z - !D Z  \j h`3DsZ  NONENZ(Z: ZL A BNONE(Z- DZ - DZ   \j h`38sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`,sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`3 sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`3sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONEN Z(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONEN Z(Z: ZL A BNONE(Z-DZ -DZ   \j h`fsZ  NONEN Z(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONEN Z(Z: ZL A BNONE(Z-DZ -DZ   \j h`3sZ  NONEN Z(Z: ZL A BNONE(Z-DZ -DZ   \j h`̨sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`3sZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`fsZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j h`xsZ  NONENZ(Z: ZL A BNONE(Z-DZ -DZ   \j B|X[Ec:AAAAAAAAAAAAAAAAA  T0! b" ,b # $ ,% <@& ' b@( @b ) , h` l sZ  NONENZ(Z: ZL A BNONE( Z- D Z - D Z  \j !h`!`!sZ  NONENZ(Z: ZL A BNONE(! Z-! D!Z -! D!Z  ! \j "ha]]]]^j #hbbbbbbj $hbbbbbbj % &hg&_ 1999 by the President and Fellows of Harvard College and its licensors. All rights reserved.&+& #Developed by Village Software, Inc.& j'hbbbbbbj (hZYYYYZj )ffffffff AA=b%f8X> ????m0bQt TbEbVbhT0bbq0bb0bhTbAq0Fq0b mhT0t/xbb]l0b/Dl0t/bxbbbl*Dbbqq     CHART 2Number of UnitsDollars\D27\E27\F27\G27qqqq     Custom page 1" @    dMbP?_*+%i&APage &PMHP LaserJet 5P/5MP (HP)&,&6ә@X"dhh?? AnalysisChartTableU} p ]l%JIA@@CREDVillage Software]H  n  A@ Picture 28CL%4    {C {{({  Rckcs191ΜRkJc{ZΥk{ffdUeefVVUfUfeUUUUUUfVeDLD[e[UFK[UUkEeVmfffekVUUeUeVVUVUU[ekVLDE[KLEUU[[HDk[[[Tf[e[f[UEDemffffUUU[[UeUeUVUUUUf侎ĴN[fKHUk[[[U[[UkUUUUUmmfffVUUUUVUUfVUVUfV[[ꪪʮTKkETD[U[ETUVeUUVfffmffVffUUVUefeUmVXHefVVefDfffVffUVTUeK[[UTUTKT[TEUemmfm]fffmffffeUV[HmmfeeUfmf[DDU[TUKKEKDdUUffffVfffHfek dNE[UEUEDE`˻KU[UTKUKUUUEKDETUUfffd̙UX]kEk[m ` E`KK[[[dTdFDDTTeEUfffmVSKʪHH`ֵFT[PDK[VHUDFTKDUEUmfffc̪HmUHeKK[UEUUU[[UEU[[UUeVmmf֎Kʪˈ k]λT[TdFeKDFTUKUefmmə̬̪䈄KDHKKTU[U[VDDUTUTEUff]fw̪ʪ踋ʪʪHȈH[[UUK[U[[ETETUUffmf\zʪʪʪ䄈Hwz̈KHD[eTUU[UEKUUUfm֊ʙyʪʬʪJ:>KHUEUD[[TUKDUUUUUffffmʙʬȸHDLUKUKKUTUEU[UETUdTUUVffffԬ̩xfeHHHH[[䴻HHXKHV[U[EUE[[[UUfnȻʪzfeVfeHH emNFmee` N봈HF[UT[TK[Tk[[UUfffʪyfVV[KS4TR興HU[ETUUKEKUTffemfeVkHU]32m[Un>HHHHKE[DU[UUFUVmfffȸȻeU[kK`UmS2-V2너HKHKVUKTU[[VeVVVfffkȻꪙxeVHe`DFU R介KD[H[DUKTVfefffffh̩w~TkHdKmdUffeHKHKKeTTXKHkKVUUffmfffeX닻ʙ~Tθʪ苶eee[[UDKHDHKKDK[EEDe[UfUfeff^˻ʙzd脌̄䈈KKk<TDEkUffVDmfed˻ʙwzdlEVVEKKUVffhUVDʙffVn˻X̩zeUe[脈HȈHHefff[HHTVke^fffn˻V̩zef` fĈKEffffXHKfVfUfVTmfen˻V̩seEfhVUfefffKUDkUVffUfTffhVXΩy~nfIw~X`PݸHKffff][ꚪVfNfffffh닻Vhʩwtif֎eۋΈHffmffffVXCfCfVffd˻U̩wifffkXUf[Hfffmffeh9Vfffe˻UΩwmffmmVLȈffmffVh闙EmfffLəw;mmffffm̬Dfmffffff[UꪙyzeeUFwwymmfmmDffmfmmfmmfk浃L꩙fhkhKwwxXꙙEfffmA8XHKVmfffmffffj[JəkfʗyyDwwwwffΈHHHffmfffmVꮶΗhK[[̪Ωy̩ywwwz3ffdHˈeVmfmmf]fIww~^왚KkKV[˻zΗywwwwmffոKDfmffffffffmmwwwwV[ꙗVVKʙ̧zꪙwwwwwsmDHEةywsm[VfVMywwwyyfUDȎ̩ʙy̪wwwwwww^̆ZwyJwwyʙwww|k[kyVffKǩyyʧwwwwwww~۶ꪧwwwwwwwwwwΗwwzV̙efU\˻w̩wwwwwwwwwzDHʚwwwwΙwwywwK[wwwɥVfəVeE[f˸yyی̩zwzwwwwyHzy˻ɗwywwy[˺ww˻[ʙfVVl廌kꪙy][ʩywwwwwʪwzwˋʧwyzfwwyeʙfefnk[舌yŻwwwwwww^̪~ʙʙwyzUwww|fΙff^yfk[Un˻w쩙wzwwwwrIʪ|̧|Ωzyewwwyefeeww^ʩʩwwwzLwwwwtG뼪wʧ[̪zΩwwwwwfVknwz̼Ϊ藚ʪwwwwwwwwrI̩wB[̩w~̩wwwwz[̩[DΪww˻ʞ闚wyzwwwwtJ~k̩yT庋w~̗yww̙KwəNʙwwwΗwwwtNʩzTDS̗ww˻wwww˻ʙkw2DB$2.ʩwwwywyw4NyUeVA>짜[ʗ|Lwww<wkʧw1KAEB>HTBɗwwwwzwDKw~.UDTDQ$ʣ뻸ʚΩwwwwtۼ̧wD!$mAU!.(]ww漗zwDL̗tDETEa%A33!EBD!$"#wyC&d94TDDDItNEDTaAʗefzw~ʪ̗""DDD"w{DDFTDTDDETCwtNFTQ13w{e\ʗ{w̪l~b!Eb!yy@DEFdKTDDTTNwtDDDDDR#̧wyUʗwta!"9ww5D4TUdDT[DHʗ~NDD1"Nww[ʙEw[TwuaE!+B"DDDBD!$A!we335C>>>wNH"!.zfeNwz[ɤTHsKdwyKRK!+DB!KR"wFS3T3311334̧TH!""wF[ʧwwzfeTn˧y$TBA.ABD"D"e34c3313̧wFHN^!+weʙwNFeVbJTDBA$B"D"KB"wd3#E13313"">wD""Kw~[wyT$EeDTDwwEDR""B4BB8DN"zD2$ns3233"#fMfK"#~wwyyUTFeddByVedDDDDDDDDFTDUDDDʧwy5S#3322#KVfURDKD")wzwwfNfddE̩wUEKDDHUTUUEUȨwwz332"3"9wP NR$DDDDBwzzwyVNV^dTw쩤ꪪ댩ywww"*wyFhB$UEE",wy>zUreR%fd4ew̩wXˌΙywwB,wwmNTTdeDw~nf#$eUDETUT""2$wLwyʮy݌̗wy~2KΧwzT̤HV^ʗt]HfHV"(DDDDTDDDḐDꙪꚪꩪꮮwꪻwwww>%θUΧffffUf"$KKD[ΞfeDMLw:㬧w LwHwywyE$˾nefUfVe"DKUU[^KMDTeFm^yCyNz#yyLwCK[w"MŅwM m<KPmm [V DDEb>$NH~ɓ] wPFfKmmm d-̧ww@TʔFmb-9TNk`]mmmmemf]mmmmmmfmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmfmmmmmmmmmmmmmmmmmmmmmfmmmmmmmmmfmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm m` mmm fmmKNKHKUDKNԎF :>mTKmkՄET]DݴmH]ԈDDDDDmmݙOuWKﭟyMe{EGuڙDFG4cmݏt~WFym]gTf_}p?]N`^tgu } 0w O}OuՕNw}Duw g}mm?Zz wm}g0OuVմX_mݵj ߭m[]o}PwEcz }ԽmOumuݯ֙mY]ՕmgEW}ݿt y}}}Mmݯ;_umm8_}O=XU7uZuOOg}NS=O9tWm@_umm?m݋O ^umi@OEJ_}]]u]5mm]_uݯ]mݸP_}<ݯ _`?UM}m_pMDw O}Mm P_vm?]wIEmm}w o}SO@S zOu]mg_um?Pmw wԦm z } ݯ]= }YVݿ}ԭ?{muݷݔZD7~{}~ݏ~NymݯmN]mݽd]]mt3^ZսX]ݎe]kzfmmmmm7W{mmyysmZy]mmm]mmmޚUmm]mmmm]mw~efmmmmmmmmmT]mmmmmmՔwmmmmmfmmݣw]mmmmmmfmmUm]ݺwmmm]mmmmmmmmmmU]]mmmm]]m]mm]]]mm]m]]mm]m]Vfm]m]m]mmmm]mmmmmmmmmVmmVm]Vm]mm]fmm]]mem]]]]m]m]]Ummmmmfmf]mm]emVm]m]]mmeme]em]VmmY @]`> H  t$ CRED_OKOK]>nHn  $CRED_SUPK987zSupport]]"! I;I% A@@3$ PNL1_TXT1Village Software provides a variety of business and financial desktop solutions for Excel and Office. For a free catalog, call 800-724-9332 or come to our Web site. (http://www.villagesoft.com)agesof]>H  H$CRED_LIC199T8iLicenseb]b  n< A@PNL1].  LN1] >H  |$CRED_WEB9:8iWebsiteb=b%f8X> "  Oh+'0TP `h  ,4Breakeven AnalysisoFinance Essentials Toolsall'Village Software - www.villagesoft.comtill Keith MacKayareMicrosoft Excel@prT@m[lGO'& ' &" WMFC 8X~'& EMF8L !" !" !" !" ! 3 '3H% Ml~!??Ml !??% (  % Ml * !?? 3'3H% Ml*~*!??Ml )!??% (   % Ml *) !?? 3 '3H% Ml) B)!??% (   % Ml )"B )!?? % Ml")~B")!?? 3 '3H% MlB nB-!??Mln n-!??% (   % Ml n* n-!?? 3 '3H% Ml  !??% (   % Ml "  !?? % Ml"*" !?? % Ml*~* !?? 3 '3H% Ml !??% (   % Ml " !?? % Ml"*" !?? % Ml**m!??Ml~~~l!?? 3 '3H% Ml !??% (   % Ml " !?? % Ml"*" !?? % Ml*~*!?? 3 '3H% Ml !??% (   % Ml " !?? % Ml"*" !?? % Ml**m!??Ml~~~l!?? 3 '3H% Ml 7!??% (   % Ml " 7!?? % Ml"*" 7!?? % Ml*~*7!??  y&% '% 6~Mly!??z% 6~Mlz!??{% 6~Ml{!??|% 6~Ml|!??}% 6~Ml}!??   % RLTimes New RomanΩ~C3333334DL̗www"@0FmIt ]mmmk333333>K[w"MŅwM mKPmm [VDDEb>$NH~ɓ] wPFfKmmmT% Th-~?@A@A-/LHarvard ManageMentor - FINANCE ESSENTIALS TOOLS       RLTimes New Romanmmmmmmmmmmmmmmmmmmmmmmmmm% TrL~f@A@ArLLpBreakeven Analysis    RLTimes New Romanmm:>VevaR>3+++9I\hp% T<Jq~@A@AJq}LHUse this tool to determine a break-even volume, the point at which total contribution equals fixed costs for your initiative.  h &WMFC8  Tg~@A@AgsL4This will be calculated automatically as you enter your fixed costs, variable costs, and pricing information below.     RLTimes New Roman`p@P#0%%%%Vv\''LL'''\hO=%% T\@A@A\ L`Period: % TT@A@AT L`Product: % % % " ! % Ml A /!?? % Ml!("B!(!?? % Ml B BY!?? ( &% ^p 0P (AU0CU00U}@U% 6Ml!??~% 6~Ml~~~!??% 6Ml!??~% 6~Ml~~~!??% (  % Ml  c!?? ' % Ml!C"!C!?? % ^p 0P (AU0CU00U}@U% 6Ml!??% (  % ( ~&% % 6~Ml~!??*% 6*Ml***!?? % Ml~q!?? % Ml#(~)#(]!??Ml#A~B#A]!?? #m% % 6mMl#m~m#m]!??#o% 6oMl#o~o#o]!??#% 6Ml#~#]!??#% 6Ml#~#]!?? % ( &% ^p 0P (AU0CU00U}@U% 6Ml~!??% 6Ml~!??% 6Ml~!??% 6Ml~!??% (  % ( +&% % 6Ml+~+T!??% % % " ! 0 K@0 % % "   ''',', 33H- @ ! @ !- - @ !  33H- @ !* @ !- - @ !  33H- @ !)- - @ !)  - @ !)" 33H- @ !-B @ !-n- - @ !-n  33H- @ ! - - @ !  - @ ! "- @ ! * 33H- @ !- - @ ! - @ ! "- @ !m* @ !l~ 33H- @ !- - @ ! - @ ! "- @ !* 33H- @ !- - @ ! - @ ! "- @ !m* @ !l~ 33H- @ !7- - @ !7 - @ !7 "- @ !7* y--~ @ !yz-~ @ !z{-~ @ !{|-~ @ !|}-~ @ !} -Times New Roman???????????????-N2 -/Harvard ManageMentor - FINANCE ESSENTIALS TOOLS       Times New Roman???????????????-"2 LrBreakeven Analysis    Times New Roman??????:>Vev-2 qJ}Use this tool to determine a break-even volume, the point at which total contribution equals fixed costs for your initiative.    2 gsThis will be calculated automatically as you enter your fixed costs, variable costs, and pricing information below.n     Times New Roman???-2 \ Period:  -2 T Product: --"SystemGOf$- ', - @ !/  - @ !(! - @ !YB  --B(AU0CU00U}@U-  @ !~-~ @ !~- @ !~-~ @ !~-   - @ !c   - @ !C! --B(AU0CU00U}@U-  @ !-   -~-- ~ @ !~*-* @ !* - @ !q - @ !](# @ !]A# m#-- m @ !]m#o#-o @ !]o##- @ !]##- @ !]# ---B(AU0CU00U}@U-  @ !- @ !- @ !- @ !-   -+--  @ !T+--- ' ,,,--'A/ @՜.+,D՜.+, 8@ lt | #Harvard Business School Publishingc  AnalysisChartTable  Worksheetsaiy )9 I U e q  Company NameCompany Address Company CityCompany State Company ZIPCompany Phone Company Fax Period Product#REF!tvital1#REF!vital2#REF!vital4#REF!vital5#REF!vital6#REF!vital8#REF!vital9itaData1ataData2  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgijklmnopqrstuvwxyz{|}~Root Entry% Ml *) F?`UI<Book 3 '3H% ) B)! SummaryInformation% (  % MhP)DocumentSummaryInformation8 % "