Balanced Scorecards and Operational Dashboards with Microsoft Excel
eBook - ePub

Balanced Scorecards and Operational Dashboards with Microsoft Excel

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Balanced Scorecards and Operational Dashboards with Microsoft Excel

About this book

Learn to maintain and update scorecards and dashboards with Excel

Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations.

  • Covers Excel 2010 back to Excel 2003
  • Shows how to develop consensus on strategy and operational plans with the executive teams
  • Details steps in creating tactical action plans
  • Gives step-by-step guidance in creating the most powerful management dashboards
  • Puts over ten years of experience in one book

Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.

Trusted by 375,005 students

Access to over 1.5 million titles for a fair monthly price.

Study more efficiently using our study tools.

Information

Publisher
Wiley
Year
2013
Print ISBN
9781118519653
eBook ISBN
9781118610848

Part I

Strategic Performance with Balanced Scorecards

In This Part
  • Chapter 1: Accelerating Strategic Performance
  • Chapter 2: Developing Your Strategic Foundation
  • Chapter 3: Preparing to Build Your Balanced Scorecard
  • Chapter 4: Step-by-Step to Building Your Strategy Map
  • Chapter 5: Step-by-Step from Strategy to Action
  • Chapter 6: Step-by-Step to Selecting Metrics and Setting Targets
  • Chapter 7: Step-by-Step to Developing Your Implementation Plan
  • Chapter 8: Step-by-Step to Rollout and Strategic Reviews

Chapter 1

Accelerating Strategic Performance

The essence of strategy is choosing what not to do.
—Michael Porter
The rate of change in the business world is accelerating. To get ahead—in fact, just to keep up—organizations of all types must accelerate their strategic performance.
They have to work with better performance, more precise focus, and better strategic alignment. For this to happen, all parts of the organization must clearly understand and be firmly aligned with strategic goals.
In the last two decades, a strategic management system has been developed that enables organizations to achieve the clarity and alignment necessary to accelerate strategic performance. That system is the Balanced Scorecard.

Managing with a 500-Year-Old System

Until recently, organizations have used the same accounting system to track assets and value production that was used 500 years ago in Venice, Italy. In 1494, Fra Luca Pacioli, Franciscan monk and friend of Leonardo da Vinci, wrote Everything about Arithmetic, Geometry, and Proportions (see Figure 1-1). It was the first best-selling business book to come off of Gutenberg’s printing press.
start figure
Figure 1-1: Over 500 years ago, Fra Luca Pacioli, on the left, documented the double-entry accounting system we still use today.
Luca Pacioli’s Portrait, Gallery of Museum of Capodimonte, Naples
c01f001.tif
end figure
What made his book a best-seller throughout Europe was that it contained detailed instructions on how the merchants of Venice kept their accounts using double-entry accounting. The book included sections on
  • Modern accounting cycles
  • Double-entry accounting
  • Journals and ledgers
  • Assets, liabilities, capital, income, and expenses
  • Closing
  • Trial balances
The book blazed through the halls of commerce in Europe because, for the first time, it gave business people a way to value their tangible assets and measure how they were producing value. But what is surprising is that we still use the same accounting system used by the merchants of Venice 500 years ago.

The Failure of Modern Management Systems

Research by Margaret Blair of the Brookings Institute into the market value of corporations listed in the Compustat database shows that the market value of U.S. corporations has shifted significantly from tangible to intangible assets. As shown in Table 1-1, in the ten years from 1982 to 1992, the contribution of intangible assets to market value rose from 32 percent to 68 percent. Subsequent studies from multiple sources estimate that since 1998, intangible assets’ contribution to corporate value is approximately 85 percent.1
Table 1-1: The Growth of Intangible Asset Contribution to Corporate Value
YearIntangible AssetsTangible Assets
198232%68%
199268%32%
199885%15%
More recent research reflected in the Ocean Tomo 300 Patent Index shows that 80 percent of the market value of companies in the United States’ Standard & Poor’s 500 Index is due to intangible assets for the period from 2005 to 2010.
How can intangible assets such as people, processes, patents, and data be monitored and managed effectively using a 500-year-old system designed for use with tangible assets?
Ram Charan, international consultant and coauthor of Execution,2 wrote an article in Fortune magazine titled “Why CEOs Fail.” In writing about highly experienced, well-known CEOs who lead their companies into failure, he said, “In the majority of cases—we estimate 70 percent—the real problem isn’t the high-concept boners the boffins love to talk about. It’s bad execution.”3
Charan goes on to write that most CEOs are hard-working, experienced, brilliant people. His research found one problem common to all the failures:
Yes, strategy matters. A good, clear strategy is necessary for success—but not sufficient for survival. So look again at all those derailed CEOs on the cover [of the magazine]. They’re smart people who worried deeply about a lot of things. They just weren’t worrying enough about the right things: execution, decisiveness, follow-through, delivering on commitments.
So executives and managers face two serious problems. First, the source of value production has switched from tangible assets that can be monitored with current accounting systems to intangible assets that are difficult to manage. Second, most corporations fail at executing their strategy.

A Modern Strategic Management System

In 1992 Harvard professor Robert Kaplan and consultant David Norton published the article “The Balanced Scorecard—Measures that Drive Performance” in the Harvard Business Review.4 The ideas in this article sowed the seeds of a strategic management system to translate strategy into action, to monitor strategic execution, and to align organizations around strategy.
Initial attempts to use the Balanced Scorecard seemed to either propel organizations to success or burden them with administrative overhead and dismal results. The difference between failure and success was often in the selection of metrics used to measure strategic execution. In 2000, Kaplan and Norton published another article in the Harvard Business Review titled “Having Trouble with Your Strategy? Then Map It.”5 This article outlined how to build a visual map that shows the objectives and causal links necessary to execute a strategy. These causal links enabled executives to identify the key metrics that drive success. These two ideas, the Strategy Map and the Balanced Scorecard, combined with more recent developments, have built a strategic management system that is an important part of modern business management.
The Strategy Map represents how an organization will execute its strategy. The Strategy Map shows the objectives needed to execute the strategy and the causal links between objectives. The Strategy Map is a tool for clear communication and helps identify the “critical few” metrics to monitor strategic execution. You can learn more about Strategy Maps in Chapter 4.
The Balanced Scorecard is part of a system that translates strategy into action. The Balanced Scorecard gives a balanced view in four perspectives of how well an organization is driving execution and how successful the results are. The four perspectives in the Balanced Scorecard and Strategy Map give executives a more balanced view of their organizations. They go beyond financial measures to include finance, customer and marketplace, internal operations, and learning and growth. These categories include people, culture, intellectual property, and IT infrastructure.
The Strategy Map and Balanced Scorecard can take one to three years to fully implement in an organization, but the results can be impressive. A Balanced Scorecard helps you do the following:
  • Clarify strategy. The discussions and thought that go into developing the Strategy Map bring clarity and understanding to the executive team in terms of the strategy and interplay between departmental silos. The graphical Strategy Map pinpoints for employees how they contribute to strategic success.
  • Translate strategy into action and execute it. The Strategy Map, combined with an Action Plan and Implementation Plan, give everyone a clear road map showing how the strategy will be translated into action. The Balanced Scorecard is used to stay on track and to monitor execution.
  • Align business units around the strategy. Most organizations develop “silos,” functional departments or divisions that are more concerned with their own success than they are with achieving success for the entire organization. But developing the Strategy Map and Action Plan requires that the walls between silos come down. Focusing on Strategic Themes that cross functional boundaries forces departments to work together, breaking down silos even more.
  • Communicate the strategy to all levels. The process of cascading the Balanced Scorecard through the organization gives each level the opportunity to contribute to organizational success. It allows executives to communicate with functional managers about how to achieve strategic goals. It allows functional managers to provide feedback to executives about capability and capacity.
  • Monitor and manage strategic execution. Research has shown that most executive staff members spend less than 10 percent of their time monitoring strategy and execution. Instead of leading through strategy, executive staff members often become embroiled in operational performance, something better left to managers. Using the Balanced Scorecard as an agenda gives executive meetings a central focus on strategic leadership.

Why Use a Balanced Scorecard?

Building a Strategy Map and Balanced Scorecard for an organization follows much the same process as taking a trip to a specific location. To take a trip you need to do the following:
  • Select a destination.
  • Agree on the type of trip.
  • Agree on the route.
  • Map the route.
  • Plan time and resources.
  • Travel.
  • Stay on course.
Leading a business in our high-speed world isn’t that different from flying a jet. Imagine boarding a small jet, pausing at the entry, and asking the pilot a few questions:
You: “What is our destination?”
Pilot: “The crew got together and talked about a destination. We couldn’t agree, so we decided to go somewher...

Table of contents

  1. Cover
  2. Part I: Strategic Performance with Balanced Scorecards
  3. Part II: Operational Performance with Dashboards
  4. Part III: Building Maps, Scorecards, and Dashboards
  5. Introduction

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.5M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1.5 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access Balanced Scorecards and Operational Dashboards with Microsoft Excel by Ron Person in PDF and/or ePUB format, as well as other popular books in Informatique & Applications de bureau. We have over 1.5 million books available in our catalogue for you to explore.