(精編)畢博-管理咨詢工具方法-Business-Scenario-Software-Chinese-JM-Case

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,利潤可行性分析PROFITPOSSIBILITIES,,,,,,,,,,

,,,,,,,,,,,,,

,,,,PROFITCHANGE………………,,,,,,"$2,401,920",,

,,,,利潤改變,,,,,,,,61%

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,當前狀況CURRENTPOSITION,,,,,可能狀況POTENTIALPOSITION,,,

,,,,估計ESTIMATE,,數(shù)值AMOUNT$,,,,估計ESTIMATE,,數(shù)值AMOUNT$

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,Beginningcustomercount,,"4,000",,,,,,,,"4,000"

,,初始客戶數(shù),,,,,,,,,,

,,,,,,,,,,,,,

,,Lesscustomerdefections……………..,,20%,,,,,,18%,,

,,減客戶流失率,,,,,,,,,,

,,,,,,,,,,,,,

,,Addcustomeradditions………………..,,20%,,,,,,22%,,

,,加客戶增加率,,,,,,,,,,

,,凈客戶數(shù)Netcustomers,,,,"4,000",,,,,,"4,160"

,,,,,,,,,,,,,

,,Averagesalespercustomerperyear..,,3,,,,,,3.3,,

,,平均每客戶每年的銷售次數(shù)…,,,,,,,,,,

,,交易數(shù)量Numberoftransactions,,,,"12,000",,,,,,"13,728"

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,平均銷售額Averagesalevalue…………,,4500.00,,,,,,5000.00,,

,,,,,,,,,,,,,

,,收入Revenue,,,,"54,000,000",,,,,,"68,640,000"

,,,,,,,,,,,,,

,,毛利潤GrossProfit……….,,15%,,"8,100,000",,,,15%,,"10,501,920"

,,,,,,,,,,,,,

,,變動成本VariableCosts,,0%,,0,,,,0%,,-

,,,,,,,,,,,,,

,,GrossProfitlessVariableCosts,,,,"8,100,000",,,,,,"10,501,920"

,,毛利潤減變動成本,,,,,,,,,,

,,管理費用Overheads………,,"4,147,000",,,,,,"4,147,000",,

,,凈利潤NetProfit,,7%,,"3,953,000",,,,9%,,"6,354,920"

,,,,,,,,,,4,x,倍數(shù)Multiple

,,,,,,,,,,,,,

,,,,,,企業(yè)價值改變BUSINESSVALUECHANGE,,,,"$9,607,680",,

,?McKessarTielemanAllrightsreserved,,,,,,,,,,,

,,,,,,,,,,,,,

,Usethisspreadsheettocalculatetheprofitchangethatoccurswhenyouchangethebusinesslevers.,,,,,,,,,,,

,Enteryourstartingpointdataintheleft-handsectionofthespreadsheet(orangecells).,,,,,,,,,,,

,Thespreadshee