Balanced-Scorecard-Excel-Template

Balanced-Scorecard-Excel-Template.xlsx

Instructions

BSC Template: Instructions
Instructions
1. Enter your objectives in column E.
2. Enter your measures in column G.
3. Remember to adjust your merged cells b/t column E and G so that your measures align with your objectives.
4. Adjust your number format for actual and targets in columns I-W.
5. Enter your targets (for your annual target, it may roll up or be independent from your quarterly targets)
6. Enter you actuals each quarter (for annual, it may roll up in a sum or average).
7. Use the drop down in columns J, M, P, S, and V to show your color status for the quarter and for the year.  The following are the options for status:
On Target
Caution
Needs Help
No Data
8. Enter your initiatives in column Y.  Please note that some initiatives may repeat.

&”Helvetica,Regular”&12&K000000&P

Balanced Scorecard

Balanced Scorecard Template
Perspective Objective Measure Q1 Q2 Q3 Q4 Year-To-Date Initiatives
Actual Status Actual Status Actual Status Actual Status Total Status Target
Financial Objective 1 Measure 1 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00
Measure 2 $0.00 Caution $0.00 Caution $0.00 Caution $0.00 Caution $0.00 Caution $0.00
Objective 2 Measure 3 0.00 Needs Help 0.00 Needs Help 0.00 Needs Help 0.00 Needs Help 0.00 Needs Help 0.00
Measure 4 0.00 No Data 0.00 No Data 0.00 No Data 0.00 No Data 0.00 No Data 0.00
Objective 3 Measure 5 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00%
Measure 6 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00%
Customer Objective 4 Measure 7 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00
Measure 8 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00
Objective 5 Measure 9 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00
Measure 10 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00
Internal Business Processes Objective 6 Measure 11 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 Initiative 1
Measure 12 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00
Objective 7 Measure 13 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00
Measure 14 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00
Objective 8 Measure 15 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% Initiative 2 Initiative 3
Measure 16 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00
Measure 17 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00%
Objective 9 Measure 18 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 Initiative 4
Measure 19 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00%
Measure 20 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00%
Learning & Growth Objective 10 Measure 21 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 Initiative 5
Measure 22 $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00 On Target $0.00
Objective 11 Measure 23 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 Initiative 6 Initiative 7
Measure 24 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00 On Target 0.00
Objective 12 Measure 25 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% On Target 0.00% Initiative 8

&”Helvetica,Regular”&12&K000000&P

__MACOSX/._Balanced-Scorecard-Excel-Template.xlsx

Boston Lyric Opera.pdf

9-101-111 R E V : J U L Y 1 1 , 2 0 0 1

________________________________________________________________________________________________________________ Professor Robert S. Kaplan and doctoral student Dennis Campbell prepared this case. HBS cases are developed solely as the basis for class discussion. Cases are not intended to serve as endorsements, sources of primary data, or illustrations of effective or ineffective management. Copyright © 2001 President and Fellows of Harvard College. To order copies or request permission to reproduce materials, call 1-800-545-7685, write Harvard Business School Publishing, Boston, MA 02163, or go to http://www.hbsp.harvard.edu. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of Harvard Business School.

R O B E R T S . K A P L A N

Boston Lyric Opera

Mission

Loyal and Generous Contributors

National and International Opera Scene

Greater Boston Community

Janice Mancini Del Sesto, general director of the Boston Lyric Opera company, explained the writing on the white board in BLO’s conference room: “I write the three strategic themes from our Balanced Scorecard on the board before each weekly staff meeting. I want our conversations to relate to activities that support the themes. That way, we will stay focused on achieving our objectives.”

Opera and the Performing Arts

Opera was one of the fastest growing segments in the performing arts, increasing its audience from 4 million patrons in the 1970s to more than 20 million by CY 2000. Performing arts and other cultural institutions, such as museums and libraries, generated 3.5% of all jobs in the New England region and supported an annual payroll of $4.3 billion.

Over the past decade, arts organizations faced steeply rising operating costs—from salaries to building maintenance. At the same time, corporate donations for unrestricted operating funds have decreased and been replaced by company branding of specific events and programs. These trends have increased the pressure on cultural institutions to generate high donations from their board members. For example, the Los Angeles Philharmonic recently raised the annual minimum gift expected from directors from $10,000 to $25,000.1 Opera was the most expensive art form to produce. Fully-staged opera productions were multi-media, and required classically trained singers, a symphony orchestra, professional choreography, elaborate sets and costumes, and often a full chorus.

1 Wall Street Journal, May 7, 1999.

Distributed by The Case Centre North America Rest of the world www.thecasecentre.org t +1 781 239 5884 t +44 (0)1234 750903 All rights reserved e [email protected] e [email protected] centre