BSC Spredsheet -- 平衡记分卡电子数据表

P 3 : P r o c e s s O b j e c t i v e 3PeopleFinancialInternalProcessesCustomerrV i s i o n S t a t e m e n tM i s s i o n :P e o p l e s t a t e m e n tS t r a t e g i c T h e m e 2S t r a t e g i c T h e m e 4S t r a t e g i c T h e m e 1S t r a t e g i c T h e m e 3F 1 : F i n a n c i a l O b j e c t i v e 1F 3 : F i n a n c i a l O b j e c t i v e 3F 2 : F i n a n c i a l O b j e c t i v e 2L 1 : L e a r n i n g / P e o p l e O b j e c t i v eL 2 : L e a r n i n g / P e o p l e O b j e c t i v eL 4 : L e a r n i n g / P e o p l e O b j e c t i v eL 5 : L e a r n i n g / P e o p l e O b j e c t i v eL 3 : L e a r n i n g / P e o p l e O b j e c t i v eF 0 : T o p F i n a n c i a l O b j e c t i v e ( T a b F 0 _ 1 ,C 1 : C u s t o m e r O b j e c t i v e 1P 2 : P r o c e s s O b j e c t i v eP 1 : P r o c e s s O b j e c t i v eC 3 : C u s t o m e r O b j e c t i v e 3P 8 : P r o c e s s O b j e c t i v eP 9 : P r o c e s s O b j e c t i v eP 1 0 : P r o c e s s O b j e c t i v eP 7 : P r o c e s s O b j e c t i v eP 4 : P r o c e s s O b j e c t i v eC 2 : C u s t o m e r O b j e c t i v e 2P 6 : P r o c e s s O b j e c t i v eP 5 : P r o c e s s O b j e c t i v eP 1 1 : P r o c e s s O b j e c t i v eC 4 : C u s t o m e r O b j e c t i v e 4 .Navigation: Click globe to return to strategy mapF0 - Financial Measures As of: Nov-03Next Update: Dec-03Owner:Objective: >Measure:KeyInitiatives:Year Savings* Measure: NotesQ1 2002 9.2% 10.2% **BASELINEQ1 2003 9.6% 10.2%Q2 2003 9.6% 10.3%Q3 2003 9.5% 10.4%Q4 2003Q1 2004Q2 2004Q3 2004Q4 2004F 0 : F in a n c ia l M e a s u reM e a s u r eQ 1 2 0 0 2Q 1 2 0 0 3Q 2 2 0 0 3Q 3 2 0 0 3Q 4 2 0 0 3Q 1 2 0 0 4Q 2 2 0 0 4Q 3 2 0 0 4Q 4 2 0 0 40 . 0 %2 . 0 %4 . 0 %6 . 0 %8 . 0 %1 0 . 0 %1 2 . 0 %1 4 . 0 %1 6 . 0 %1 8 . 0 %2 0 . 0 %S a v i n g s * M e a s u r e :- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------T a rg e t - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------T a rg e t F 0 .2 M e a s u reF 0 .1M e a s u reNavigation: Click globe to return to strategy mapF0 - Financial Measures As of: Sep-03Next Update: Dec-03Owner:Objective: >Measure:KeyInitiatives:YearAggregateTargetAggregateActuals Notes NotesYE 2002 3.27% **BASELINEQ1 2003 3.18% 3.29% Mainly due to less than expected CU net incomeQ2 2003 3.19% 3.23%Q3 2003 3.34%Q4 2003 3.41%Q1 2004Q2 2004Q3 2004Q4 2004F 0 : F in a c ia l M e a s u r e eC M G N e t In c o m e Im p a c t o n C U sY E 2 0 0 2Q 1 2 0 0 3Q 2 2 0 0 3Q 3 2 0 0 3Q 4 2 0 0 3Q 1 2 0 0 4Q 2 2 0 0 4Q 3 2 0 0 4Q 4 2 0 0 40 . 0 0 %0 . 5 0 %1 . 0 0 %1 . 5 0 %2 . 0 0 %2 . 5 0 %3 . 0 0 %3 . 5 0 %4 . 0 0 %4 . 5 0 %5 . 0 0 %A g g r e g a t e T a r g e t A g g r e g a t e A c t u a l sL o n g T e r mT a r g e t- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 %F 0 .1M e a s u reF 0 .2 M e a s u reNavigation: Click globe to return to strategy mapF1 - Financial Measures As of: Oct-03Next Update: Nov-03Owner: Objective:Measure: KeyInitiatives:Date Target Actual NotesJan-03 No specific data for JanuaryFeb-03 1.0 1.0 Cumulative figure for Jan&FebMar-03 2.0 2.0 Cumulative figure for Jan,Feb,MarApr-03 3.0 3.0 Cumulative figure for Jan - AprMay-03 4.0 4.0 Cumulative figure for Jan - MayJun-03 5.0 5.0 Cumulative figure for Jan - JunJul-03 6.0 6.0 Cumulative figure for Jan - JulAug-03 7.0 7.0 Cumulative figure for Jan - AugSep-03 8.0 8.0 Cumulative figure for Jan - SepOct-03 9.0 9.0 Cumulative figure for Jan - OctNov-03 10.0 10.0Dec-03 11.0 12.0What do the results of this quarter/month indicate?Why did we meet or miss the target?What is the trend?Why are we seeing this trend?What plans do we have to meet the target?F 1 .2 M e a s u reF 1 .1M e a s u reF 1 : F in a n c ia l M e a s u r eF in a n c ia l M e a s u r eF e b - 0 3 M a r - 0 3 A p r - 0 3 M a y - 0 3 J u n - 0 3 J u l- 0 3 A u g - 0 3 S e p - 0 3 O c t - 0 3 N o v - 0 3 D e c - 0 30 . 02 . 04 . 06 . 08 . 01 0 . 01 2 . 01 4 . 0$MillionsT a r g e t A c t u a lNavigation: Click globe to return to strategy mapF1 - Financial Measures As of: Sep-03Next Update: Dec-03Owner: Objective:Measure: KeyInitiatives:Date Target Actual Notes1999 1.0% 2.00%2000 1.0% 2.00%2001 1.0% 2.00%2002 1.0% 2.00%2003 1.0% 2.00% Updated qtly based on forecasted2004 1.0% operating gain.2005 1.0%2006 1.0%2007 1.0%What do the results of this quarter/month indicate?Why did we meet or miss the target?What is the trend?Why are we seeing this trend?What plans do we have to meet the target?F 1 .1O p G a inF 1 : F in a n c ia l M e a s u r eO p e r a tin g R O E