管理咨询麦肯锡-表格库

机密此报告仅供客户内部使用。未经麦肯锡公司的书面许可，其它任何机构不得擅自传阅、引用或复制。DocumentDate标题客户名客户名 客户所在地客户所在地日期日期此报告仅供客户内部使用。未经蓝程咨询公司的书面许可，其它任何机构或个人不得擅自传阅、引用或复制。本文只提供演示文稿纲要，需辅助以口头讲解和表达。芝加哥芝加哥 上海上海 新加坡新加坡2 0 0 2客户企标使用指引使用指引本工具文档包含了最常用的一些图表以帮助我们更为方便快捷地制作PowerPoint文件在应用这些图表之前，你需要首先在你所做的文档里应用蓝程的PPT模版，那么所有蓝程的报告文档可以统一模式如果你需要在你的演示中应用某图表，只需复制该图表在你的文档中，然后修改。一般有两种复制方法:在普通视图下，按 Ctrl-A选择所有对象，复制，然后切换到新文档中粘贴在幻灯片浏览视图下，选择你要复制的幻灯片单页，然后复制、粘贴到新的文档里，当然也是在浏览模式下2使用指引使用指引标题和正文在模版中已经预设，所以你只需要应用即可。应用时选择菜单中格式 中的幻灯片版式。你即可选择你需要的版式，再填入文字按增加缩进量，文字缩进一级后字体大小和粗细或工程符号会自动改变行间距也是预设的，不要按两次回车以增加行间距记住，复制是最有效而准确的方式将一个对象的格式应用到另一个上。所以如果你要插入一个新的对象如文本框，并且对格式不那么确定，请从工具文档中复制3使用指引使用指引一些“要和“不要不要在按照文本自动调整格式下输入文本，在编辑时会很难调整文本中排列间隔不要用空格，而用tab键：不要在一个文本框中输入太多的文本，以后将很难修改格式12The upper triangle controls the indentation of the first line of a paragraphThe bottom triangle controls the indentation of the second and the consequent line of a paragraphThese triangles control the level 2 textTable markTable mark controller4定制你的工具栏可以显著提高制作速度定制你的工具栏可以显著提高制作速度在菜单中选择工具栏定制，将出现如下的对话框，选择其中常用的图标置于在菜单中选择工具栏定制，将出现如下的对话框，选择其中常用的图标置于桌面的工具栏上：桌面的工具栏上：Rotate toolsPick up and apply formatGroup and ungroupOrder toolsColor toolsIndent toolsChange Font Size Font FormattingZoomBulletsRulerText Align ToolsFontFont SizeMost Frequently Used ShapesNew Text BoxLine Formatting ToolsShadow ToolsAlign Tools使用指引使用指引5以下的快捷键都是在左手操作的，当你右手使用鼠标时这些快捷键将极为方便。请经常使用以便记住：Ctrl-C:复制Ctrl-X:剪切Ctrl-V:粘贴Ctrl-S:保存Ctrl-A:全选Ctrl-Z:撤销Ctrl-D:复写用鼠标移动对象十分方便。但是需要垂直或水平移动的时候可同时按住Shift键如果你需要复制对象到指定地方，按住Ctrl移动即可复制。同时按 Ctrl 和 Shif可以使复制的对象和原对象垂直或水平使用指引使用指引6移动鼠标以选中对象。但是当对象没有填充内容是只有点中边框才能选中，而边框又不易看到。所以除了矩阵和表格一般可将对象填充颜色设为白色如果想选中分散的对象，按住 Shift 键然后选中一个一个对象按住鼠标左键拖动覆盖住你想选择的多个对象，你能选中拖动区域内所有的对象。结合Shift键可以十分方便地选中一些小的或隐藏的对象快捷键 Ctrl-A 可使你选中幻灯片中所有的对象或者文本框中所有的文本按住 shift 击中文本框的任一局部，你便能选中整个文本框在文本框中，按击鼠标左键三次可选中整个段落；两次选中词或词组。使用指引使用指引7Project name or document title(max.two lines)Type of document Client name(max.two lines)Location,date of presentation(month day,year)Project name or document title|Date(month day,year)8This document was created for the exclusive use of our clients.It is not complete unless supported by the underlying detailed analyses and oral presentation.It must not be passed on to third parties except with the explicit prior consent of RittenHouse&Partners.Content PageA.Chapter?1.Sub chapter?1.1 Section?B.Chapter?1.Sub chapter?1.1 Section?C.Chapter?1.Sub chapter?1.1 Section?9A.Chapter page(after chapter point:4 space bars)Action/reaction11Action/reaction12Action/reaction13Against the tide/with the tideAgainst the tideWith the tide.14Balance/imbalance 15Balance/imbalance 16Balance/imbalance 17Bar chartGraph Title18Chances/risks 19Change of directionMoment of directional change20China mapBox TitleLevel 1 textLevel 2 text-Level 3 text21Circulation(2 factors)22Circulation(3 factors)23Circulation(4 factors)24Circulation(5 factors)25Circulation(6 factors)26Circulation(7 factors)27Circulation(8 factors)28Client types$UnsureHesitantSuccessfulHopelessDrowningStrugglingEnsure survival in short termRestructuring or search for partnersActively initiate structural changeGrowing and positioning projectSecure futureStrategy projectStartout toward the futureSpecific imple-mentation projectClient typeNeedProject type29Columns and tablesColumn Title 1Category 1Type your phrases and sentences hereType your phrases and sentences hereColumn Title 2Type your phrases and sentences hereType your phrases and sentences hereColumn Title 3Type your phrases and sentences hereType your phrases and sentences hereCategory 2Type your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereCategory 3Type your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences here30Columns and tablesColumn Title 1Category 1Type your phrases and sentences hereType your phrases and sentences hereColumn Title 2Type your phrases and sentences hereType your phrases and sentences hereCategory 2Type your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereCategory 3Type your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences here31Columns and tablesCategory 1Category 2Category 3Category 1Category 2Category 3Category 1Category 2Category 3Category 1Category 2Category 332Columns and tablesColumn Title 1ItemItemItemItemItemItemItemItemItemColumn Title 1Column Title 1Column Title 1NumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumberNumber33Column chartGraph TitleUnitCAGR?%34Column chartGraph TitleUnitCAGR?%Top Level LabelTop Level Label0100200300400500600Optional35Column chartYou can put your points here in the header of the boxGraph TitleCAGR?%36Column chartHeaderGraph TitleHeaderGraph TitleUnitUnit37Column chartHeaderGraph TitleHeaderLevel 1 textLevel 2 text-Level 3 textUnit38Column chartGraph TitleHeaderLevel 1 textLevel 2 text-Level 3 textUnit39Column chartYou can put your points here like conclusionUnitCAGR?%40Column chartCategory 4Category 3Category 2Category 1Column 1000000000000000Graph TitleCategory 5000TotalUnit0000000000000000000000000000000000000000000000X,000X,000X,000X,000X,000X,000LabelLabelLabel000000000Series 1Column 2000000000000000000Series 2Series 1Series 241Column chartSub TitleSub TitleSub Title000000000000000000000000000LabelLabelLabel000000000000000000000000000LabelLabelLabel000000000000000000000000000LabelLabelLabel000000000000000000000000000LabelLabelLabel000000000000000000000000000LabelLabelLabel000000000000000000000000000LabelLabelLabelSub TitleSub TitleSub TitleSeries 1Series 2Series 3Dash Line42Conflict 43?Conflict44Consequences(2).45.Consequences(3)46Consequences(4).47Consequences(5).48Consequences(2)49 Consequences(3)50Consequences(4)51Consequences(5)52Consequences12345653 Consultants profil(English),Firstname LastnamePosition:.Year of birth:.Nationality:.Languages19901994Education Updated:MM/YYProfessional experienceMethodological competenceSince 10/1992 Industry competenceKey projects54Cooperation55Cooperation56Cost breakdown chartValueValueValueValueValueValueUnitGross MarginCostComponent(%)Component(%)Component(%)Component(%)Component(%)Component(%)57Dead end58Dependance59Development60Dice61Direction62Factors(2)63Factors(3)64Factors(3)65Factors(3)66Factors(4)67Factors(4)68Factors(4)69Factors(4)70Factors(6)71Factors(6)72Factors(8)73Factors(4)74Factors(5)75Factors(6)76Factors(4)Success factors77Factors(5)Success factors78Success factorsFactors(6)79Factors(3)80 Factors(4)81Factors(5)82Feedback 83Feedback 84Feedback85Feedback?!86Feedback87Filter 88FilterInitial situation1.Criterion2.Criterion3.CriterionResult89Flexibility90FlexibilityAbilityIntentionFlexibilty91Flexibility92Focus expansiontt93Growth94Guidelines95Harmony96Hurdles and brakesCompanyX97Impact.98Influence(1 factor)99Influence(2 factors)100Influence(2 factors)101Influence(4 factors)102Influence(4 factors)103Influence(6 factors)104Input/output.105Interaction106Margin chart100%?%Label?%Label?%Label?%Label?%LabelTotal in ValueIndexLabelLabelLabel LabelLabelLabel000000000?%?%?%000?%?%000000107Matrix108Matrix109MatrixDimension 2Dimension 1ScaleScaleScaleScaleLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 text110MatrixLabelLabelLabelLabelDimension IIContentDimension ILabelLabelContentContentContentContent111Measures plan planned activitiesOverview:ActivitiesWk.Wk.Wk.Wk.Wk.Wk.Wk.Wk.Wk.Wk.Comments112Measures plan planned measuresActivity:As of:Objective:Results:Responsible:Support:Measures:.113Measures plan planned individual stepsMeasure:.No.As of:1.Individual stepsResponsibleSupportForm of resultStartDura-tionDead-linePro-jectCom-pleted.114ModelsKey StepsType your phrases and sentences hereSourcesLevel 1 textLevel 2 textStep 1Step 2Step 3Step 4Type your phrases and sentences hereType your phrases and sentences hereType your phrases and sentences here115Moon chart11BarBallBarArrow116Multipliers.+.+=Projektteams117Multipliers118Mutuality119 Mutuality120Obstacle121Obstacle.122Obstacle123Organizational and flow chartTextTextTextTextTextTextTextTextTextTextTextText124Organizational and flow chartPanteneJiehuaNew BrandRejoiceHead&ShouldersUlanWhisperArielTideJV BrandsCrestProfessional MarketingSafeguardZest CamayAssistant Brand Manager,2-5 per BrandMedia&Commercial ProductionMarketing ManagerDimitri PanayatapolousSchool Program GroupNurses for School ProgramRandall BeardMarketing DirectorRene CoMarketing DirectorKen DoiMarketing DirectorRobin OxendineMarketing ManagerPeter FoystonMarketing ManagerLaundryHaircareToothpaste/SoapSkincare/PaperVacantGeneral ManagerBrad CasperGeneral Manager*VacantGeneral ManagerVirginia LeeVice President*Marketing Organization125Organizational and flow chartCompetitive ModelsMarket ResultsFeasible ScenariosIndiaChinaPhilippinesSuccess RequirementsBacardiStrategyAsia WhiskyOpportunityAssessmentMarketArchetypeModelSizingPricingBacardiStrategy OverlapDetermine Whether to Proceed FurtherExecuteWill whisky help to build Bacardi rum globally?Are there opportunities for whisky in the rest of the world?YesDevelop Objectives&StrategiesFinancial GoalsMarket PrioritiesAcquisition or Organic GrowthProduct/Marketing/Distribution StrategiesProcess Map126Option123127Option1234128Optionquitdevelope129Penetration130Pie chartHeaderChart TitleLabel%Label%Label%Label%Label%Series 1Series 2Series 3HeaderChart TitleLabel%Label%Label%Label%Label%100%=XXXX100%=XXXX131Pie chartChart TitleLabel%Label%Label%Label%Label%Series 1Series 2Series 3HeaderLevel 1 textLevel 2 text-Level 3 text100%=XXXX132Pie chartChart TitleLabel%Label%Label%Label%Label%Chart TitleLabel%Label%Label%Label%Series 1Series 2Series 3Chart TitleLabel%Label%Label%Label%Label%Chart TitleLabel%Label%Label%Label%100%=XXXX100%=XXXX100%=XXXX100%=XXXX133Plus/minus.134Plus/minus.135Plus/minus.+136Plus/minus137Plus/minus138Plus/minus139Portfolio+140Portfolio+141Pressure142Pressure143Pressure144PrioritizationPrioritization145Process146Process123412345147Process decrease12345148Process increase12345149Progress150ProjectPhase IPhase IIPhase III151Project weeks weeksPhase IPhase II4312152Project procedurePhasesTime requiredProject features.Phase I.Phase II.Phase III.weeksweeksweeks1234153Puzzle154Puzzle(for color presentations)155Puzzle3 parts123To apply color,ungroup the object,then regroup it afterwards=156Redesign(Cube)Redesign does not mean:But:Solving individual problemsCreating a comprehensive solution157RedesignShot gunMarksmanAutomatic pistolOpen fire in an uncontrolled mannerRather dissatisfactory resultLengthy sightingGood but rarely optimal resultNot appropriate for dynamic environment and targetRapid sightingSwift feedbackHit bulls eye after a few interactive shots!Target solutionActual situation158Resistance.159RestructuringImprovement of liquidityCost reductionReduction in personnelStructural changePositioning on the marketImprovement of liquidityCost reductionReduction in personnelStructural changePositioning on the marketRestructuring does not mean.But.160Rethink161Separation162Separation.163Separation.164Spinning off parts of a company165Storyboard166Storyboard167Strengths/weaknessesStrengthsWeaknessesWeaknessesStrengths.TodayTomorrow168Table169Table170Table171Table172Table173Table174Target(1 factor)175Target(2 factors)176Target(3 factors)177Team organization.ClientRittenHouseN.N.N.N.N.N.N.N.ClientRittenHouseN.N.N.N.N.N.N.N.178Text blocks(2).179Text blocks(3).180Text blocks(4).181Text blocks(5).182Text blocks(2).183Text blocks(3).184Text blocks(4).185Text blocks(5).186Text blocks(2+3).187Text blocks(3+3).188Text blocks(3+4).189Text in boxBox titleBox titleBox titleLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 text190Text in boxBox titleBox titleBox titleBox titleLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 text191Text in boxBox titleBox titleBox titleBox titleLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 text192Text in boxBox titleBox titleBox titleBox titleLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textLevel 1 textLevel 2 text-Level 3 textPhase IPhase Name(Title Case)Phase IIPhase Name193TimetableWkMonth.Issues194Value-added chainSupplierCustomerDevelopmentProductionSalesDistributionCompany195VisionVision196Waste of resources problemProblem 3Problem 1Problem 2Problem 4197Waste of resources solutionSolution to problem 3Solution to problem 1Solution to problem 2Solution to problem 4198199China is a market of great potential for GeberitFavorable macro-economic environmentRB&P expects a sales revenue of more than 150 million for Geberit China by year 20051):Economist Intelligence UnitDriven by continued strong fixed investment growth,the real annual GDP growth will be maintained at above 7%Product concept&standardBrand new product concept New industry standards and regulations are coming out to replace or modify the old onesBusiness opportunities for concealed cistern will be generated because of fat-growing medium to high end sanitary marketFirst mover advantagePromising market for concealed cisternEncouraging market potential for piping productsConstruction industry will undergo a strong annual growth rate of 8%,which presents potential for Geberits piping products200As a short-term cash-cow,more public products are expected to be sole in contributing to the early break evenProject selling onlyPurely import Doesnt take up much corporate capacityHigh unit priceHigh profit marginShort-term sales-up potentialStrong Swiss brand with original import conceptCurrent sales of public products account for 38%of Geberit gross sales turnoverSource:Geberit,RB&P analysisLong-term prospectThe market size for public products itself is limited and shrinkingLimited number of targeted high-end hotels and buildings for GeberitMany competitors within the industryLack of one-set solutionCombined selling approach is becoming difficult(e.g.Kohler to whom Geberit used to provide electronic produces and sell in projects has launched its own electronic productsMarket size for Geberit public products is limited201*资料来源：Unit of measure例子HighLowLegendLegendLegendTextTextTextTextTextTitlex+x+TextTextTextTextText202Modules and variations New graphics guidelinesDesign proposalsRoland Berger Hamburg,November 2001203ContentsPageA.Standard slides3B.Lists(1)Factors,no specific number7C.Lists(2)Factors,specific number13D.Matrix Factors,comparisons24E.Process(1)Factors,steps35F.Process(2)Factors,impact49G.Process(3)Factors,interlinked67Annex:Nine key changes compared to the old standards73204A.Standard slidesMethodological competenceKey projectsIndustry competenceProfessional experienceLanguagesEducationConsultant profile:first name,last namexxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxPosition:xxxxxxxxxxxxxxxxxxxxxxxxGermanxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxBorn:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNationality:xxxxxxxxxxxxxxxxxxxxxUpdated:mm/year206Organizational chart207Organizational chart(including headcount).208B.Lists(1)Factors,no specific numberLists horizontal(variations)HeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetailsHeadingDetails1234210Lists vertical(variations).1234211Schedule123456789101112Month 1Month 2Month 3ActivitiesA.B.C.123456789101112Month 1Month 2Month 3ActivitiesA.B.C.12212Sets of guidelines2345Guidelines 1Guidelines 2Guidelines 3Guidelines 4Guidelines 5Comments 1Comments 2Comments 3Comments 4Comments 51213214C.Lists(2)Factors,specific numberPyramid(3 or 4 levels)216Pyramid(5 levels/centered)2173 factors(interwoven).123218Common ground2194 factors(1)2204 factors(2)2214 factors(3)1234Factor 1Factor 2Factor 3Factor 42224 factors(3a weighted)234Factor 1Factor 2Factor 3Factor 42234 factors(3b dynamic)1234Factor 1Factor 2Factor 3Factor 4Four dynamicfactors2246 factors(variation)225D.Matrix Factors,comparisonsMatrix/table(Horizontal/vertical comparison of data variations)1234227Special types of matrix opportunities/threats Opportunities Threats Opportunities Threats Opportunities ThreatsOpportunitiesThreats 1234228Special types of matrix pros and cons 123229Special types of matrix controversy1234230Special types of matrix conflict/tension(1)231Special types of matrix conflict/tension(2)232Special types of matrix bottom up/top down(1)BOTTOM UPTOP DOWN.233Special types of matrix bottom up/top down(2).BOTTOMUPTOPDOWN12234Special types of matrix equilibrium 235Special types of matrix imbalance 236E.Process(1)Factors,stepsProcesses123238Process/phases12345Phase 1Phase 2Phase 3 Phase 1Phase 2Phase 3 Phase 1Phase 2Phase 3 1234239Cycles(1)(color presentation)240Cycles(2)241Spirals(orthogonal)12242Hurdles243Resistance/obstacles1257346244Filters124536245Change of mindset/direction1234246Nodes/interfaces143756892247Pressure12248Increase/decrease12345678249Various types of brackets(to be used instead of block arrows)1234567891011250F.Process 2 Factors,impactConsequences(1).252Consequences(1a).253Consequences(2)254Consequences(3).255Consequences(4).12256Impact(3 factors)QUALITYTIMECOST257Impact(4 and 6 factors)258Impact(4 factors)Factor 3Factor 2Factor 4Factor 1Generic description of the 4 factors259Impact(5 factors)Factor 3Factor 2Factor 4Factor 5Generic description of the 5 factorsFactor 1260Impact(6 factors)Factor 2Generic description of the 6 factorsFactor 3Factor 1Factor 5Factor 4Factor 6261Impact(7 factors)Factor 3Generic description of the 7 factorsFactor 2Factor 6Factor 4Factor 5Factor 7Factor 1262Impact(8 factors)Factor 3Generic description of the 8 factorsFactor 2Factor 6Factor 7Factor 4Factor 5Factor 1Factor 82636success factorsImpact and result(1)264Impact and result(2)5success factors265VisionVision266Action/reaction267Value chainCustomerSupplierDevelopmentProductionSalesDistributionCompany268G.Process 3 Factors,interlinkedAction/reaction(1)270Action/reaction(2)(transparent color presentation)271Interaction123272Jigsaw puzzle273Spiral274Annex:Nine key changes compared to the old standardsDo not use block arrowsUse variations instead12341234BackupBACKUPStufe 1Stufe 2Stufe 3New Content design Key changes regarding lean,linear,literalDo not use shading or bordersInstead,use unframed colored shapes in shades of key blue,for emphasis onlyDo not use ovalsInstead,use AutoShapes with corners completely rounded offDo not use stickers with linesInstead,use upper case stickers(13 point),(key blue shade 1),positioned in the header areaDo not put numbers in circlesInstead,put them in squares(key blue shade 1),white lettering,boldIf boxes are used,276There are obvious disadvantages to positioning text behind graphicsDo not position text behind graphicsPosition text to the side of graphics insteadArrow function can be switched on and off/positioned to the side Text is easy to read if not positioned behind graphicsDo not use speech bubblesInstead,use AutoShapes/callouts/third row(you can use the arrow function!)Do not use big multicolored cartoons/Clip ArtInstead,use pictograms(if not available:convert Clip Art to linear monochrome versions)Do not use miniature charts as navigatorsInste