凱捷平衡計分卡CBABalancedScorecardPrototypeDocumentation

1、rbs balanced scorecard prototype documentationwednesday 4th of september, 2002table of contentsrbs balanced scorecard background3the balanced scorecard3rbs balanced scorecard user documentation5scorecard navigation main menu5b - main menu lists of values6d main menu help7scorecard navigation scoreca

2、rd views7balanced scorecard perspective8balanced scorecard all perspectives9balanced scorecard commentary11balanced scorecard measures12rbs balanced scorecard support documentation13monthly scorecard update process13scorecard maintenance17view tabs17list of values18path19period variance indicators19

3、conditional cell formatting20data sheet to display linkage21rbs balanced scorecard backgroundthe balanced scorecardan approach developed in the early 1990's by robert kaplan and david norton to bring a wholistic management system to the workplace. they named this system the 'balanced sc

4、orecard'.  recognising some of the weaknesses and vagueness of previous management approaches, the balanced scorecard approach provides a clear prescription as to what companies should measure in order to 'balance' the financial perspective.the balanced scorecard is a management sys

5、tem (not only a measurement system) that enables organisations to clarify their vision and strategy and translate them into action. it provides feedback around both the internal business processes and external outcomes in order to continuously improve strategic performance and results.  when fu

6、lly deployed, the balanced scorecard transforms strategic planning from an academic exercise into the nerve centre of an enterprise.kaplan and norton describe the innovation of the balanced scorecard as follows:"the balanced scorecard retains traditional financial measures. but financial m

7、easures tell the story of past events, an adequate story for industrial age companies for which investments in long-term capabilities and customer relationships were not critical for success. these financial measures are inadequate, however, for guiding and evaluating the journey that information ag

8、e companies must make to create future value through investment in customers, suppliers, employees, processes, technology, and innovation."the balanced scorecard suggests that we view the organisation from four perspectives covering: finance & risk; internal productivity; people & learn

9、ing, and customer reaction/perception.rbs balanced scorecard user documentationscorecard navigation main menuuser navigation is conducted through rbs balanced scorecard menu excel workbook as follows:the red capitals a, b, c, d and e represent the available navigation choices on the main menu as doc

10、umented below.· a a link to this documentation· b the main menu lists of values as below· c the user initiation button once the appropriate lists of values have been selected· d the help option as below· e exit option to close the main menub - main menu lists of valuesnaviga

11、tion is conducted through the appropriate selection of the drop down menus as follows:· group/division· scorecard perspective· period ending· viewgroup / divisionthis option provides access to the appropriate level scorecard, i.e. level v, vi, retail customer services or the stra

12、tegic management report.scorecard perspectivethis option provides navigation to the appropriate scorecard perspective based on the selected group/division, all perspectives or the corporate goals of the strategic management report. the scorecard perspectives are defined in the rbs balanced scorecard

13、 background above.period endingthis option provides navigation to the appropriate reporting period for the above scorecard perspective for the selected group/division. periods are either monthly based or represent the quarterly aspect of the strategic management report reporting cycle.viewthis optio

14、n controls the view of the above 3 selected options and covers the actual scorecard, measures (definitions, calculations etc) or the associated scorecard commentary.d main menu helpselection of the help option is performed through user selection of the help icon as highlighted by the red capital let

15、ter d on the above screenshot. a help file is provided for each of the main menu list of values giving detail of the content and usage of each.the help example above is that of the group/division list of values. return to the main menu is achieved through the selection of the main menu grey button (

16、top left).scorecard navigation scorecard viewsperspective navigation is controlled from the appropriate selections within the main menu screen. 4 principle rbs balanced scorecard views are available:· balanced scorecard perspective· balanced scorecard all perspectives· balanced scorec

17、ard commentary· balanced scorecard measuresthese will be discussed in more detail below.balanced scorecard perspectiveas discussed in the background section above, the rbs balanced scorecard captures the financial/risk, internal/productivity, people/learning and customer perspectives. each pers

18、pective has different measures, targets and actuals although the physical structure of the user display remains the same between each of the perspectives.the displayed business development (bd) people and learning perspective provides the foundation for the all perspectives sheet displayed next. aft

19、er reviewing the relevant detail, user navigation is provided to return to the main menu via the main menu button (grey button, top left).balanced scorecard all perspectivesthe all perspectives scorecard is a dynamic display of the underlying single perspectives discussed above.an important point to

20、 note is that the addition or deletion of measures to each of the underlying perspectives will not affect the sizing of the views within the all perspectives worksheet, as this is preset to ensure perspective visibility when printing. return to the main menu is achieved through the selection of the

21、main menu button (grey button, top left).the scorecard displays data in a columnar format with the following columns representing:descriptionrefthe identifier allocated to each measure. this represents the level v or vi functional units e.g. rbsf5 translates as a level vi (rbs) measure and is the fi

22、fth measure within the finance perspective (f).month and ytdmonthly and year to date variance indicators.the indicators use a combination of colour and symbol to display the measure variance as follows:· green positive variance beyond defined limit· amber - minimal or no variance and on tr

23、ack· red negative variance beyond defined limit (currently 10%) · - positive variance· - - minimal or no variance· x negative variancemeasure namebrief measure description or namebudget / target total yearthe budgeted figure for the year for the measureactual monththe actual resu

24、lt for this measure per month/periodbudget monththe target or budget for this measure per month/periodvariance monththe variance/difference between the actual and budget aboveactual ytdthe actual result for this measure for the year to datebudget ytdthe target or budget for this measure for the year

25、 to datevariance ytd the variance/difference between the actual and budget above for the year to datebalanced scorecard commentarycommentary is provided the scorecard co-ordinators in conjunction with the scorecard data providers. commentary is intended to provide meaning and clarification of the re

26、sults displayed for each scorecard.commentary is provided on a monthly basis, as measure data is collected and entered by the scorecard coordinators and finance services. return to the main menu is achieved through the selection of the main menu button (grey button, top left).balanced scorecard meas

27、uresthe underlying measures are defined within this view, with measure reference, definition, calculation method and related comments displayed. this view is provided merely for display and information purposes only.return to the main menu is achieved through the selection of the main menu button (g

28、rey button, top left).rbs balanced scorecard support documentationmonthly scorecard update processthe key steps within the rbs balanced scorecard monthly information gathering cycle are detailed below. the intention of these steps is to ensure 3 primary activities: data capture, communication, and r

29、eview. the day column reflects the working day after month end, with the action representing the activity undertaken by the shared services and the scorecard coordinators. to accelerate the reporting process, it is important to note that scorecard data is updated by shared services on a daily basis

30、as it is received, a daily email of updates will be sent to scorecard coordinators.dayactivityscreenshot10general ledger (gl) data becomes available. shared services populate scorecard measures database with system (gl, data-warehouse, cubes) and non-system-sourced data. the completed file is then u

31、ploaded to the intranet.data is populated in the rbs measures excel worksheet.11 15shared services send e-mail notification (including link to scorecards) to scorecard co-ordinators advising that scorecards are available for review. the email will also contain a commentary template that can be updat

32、ed by the scorecard co-ordinators independent of the scorecard itself (given that the scorecard data may still be in the process of being finalised for the next few days). using the commentary template provided with the email, scorecard co-ordinators in each of the businesses are able to begin prepa

33、ring commentary for the measures where data is available. in most instances, where data isnt available through the initial release, the business in question will actually be providing the data (e.g. rcs and segment-based data) and will be in a position to form views on commentary required whilst dat

34、a is being finalised for provision to shared services.11-12where data isnt available for the first release of the scorecards, shared services will continue to source non-systems data from nominated data providers and update the database as the data is provided. updates to the database can then be vi

35、ewed through the refreshed scorecard on the intranet. 16scorecard co-ordinators send email confirmation to shared services that scorecards have been approved by relevant egm. at the same time, the finalised commentary file is returned to shared services for inclusion in central scorecard file. the c

36、ommentary should also be copied to the rbs finance services team (peter moloney / patrick walton) for use (where relevant) in the board report.17shared services send email notification to scorecard co-ordinators indicating that all scorecards have been finalised and are available through the intrane

37、t. this allows viewing / downloading for:· jfm (in preparation for monthly 1on1s with egms)· jke (in preparation for hosting rbs finance forums)· egms (in preparation for monthly 1on1s with jfm and for hosting allocated business forums)· rbs finance services (to consolidate comme

38、ntary from scorecards where relevant for use in board report)19rbs finance services team (peter moloney / patrick walton) update board report with commentary from scorecards (where required) and forward through to groupscorecard maintenanceview tabsthe rbs balanced scorecard workbook serves as the u

39、ser interface to the rbs balanced scorecard prototype, providing access to the underlying data sources, commentaries and scorecards. the navigation and the user help function are provided from with the rbs balanced scorecard workbook, with each function covered by a worksheet within the above workbo

40、ok. to provide a seamless user front-end, the worksheet tabs have been hidden and can be unhidden via the following:· open the rbs balanced scorecard menu workbook· from drop down menu select tools then options· an options form will open. in the window options (bottom right) tick the

41、sheet tabs box · click ok (bottom selection buttons)· the worksheet tabs will become visible at the bottom of the workbook.list of valuesthe main menu sheet has a number of drop down lists such as group/division or scorecard perspective etc. the values for each of these lists is stored wit

42、hin the listbox values worksheet within the rbs balanced scorecard menu workbook. · to provide visibility of the listbox values worksheet, follow the view tabs procedure above· select the listbox values tab · column a contains the title and contents of each list of values as follows:

43、group/divisions; scorecard perspective; period and view. headings that should not be changed are in bold type.· the values found beneath each of the list groupings can be altered to have a corresponding change in the visible list of values on the main menu page of the workbook.pathto minimise m

44、aintenance effort, all navigation within the rbs balanced scorecard prototype is conducted using a predefined url type path that allows a single change to this path to alter the navigation route from within each scorecard and main menu option. the path variable is stored in a hidden worksheet within

45、 the rbs balanced scorecard menu workbook.· to provide visibility of the path worksheet, follow the view tabs procedure above· in cell a2 type the full folder path where the rbs balanced scorecard menu and its related data and display sheets will reside.period variance indicatorswithin eac

46、h of the scorecard perspectives, variance indicators are used to highlight differences between the monthly actuals in comparison to budget. additional indication is provided by the inclusion of colour indicators as follows:the above indicator is produced from 2 separate excel functions, an if statement and conditional cell referencing. these can be maintained as follows:if statement· the tick, cross or neutral is a simple formula - =if(j7>=k7,"",if(j7<