Total Optimal Performance Scores: A Practical Guide for Integrating Financial and Nonfinancial Measures in Performance Evaluation: Tops Uses Excel Solver, a Mathematical Optimization Tool, to Determine the Most Efficient or Top-Performing Division in an Organization and Then Score Other Divisions' Performance against It

By Briggs, John; Claiborne, M. Cathy et al. | Management Accounting Quarterly, Fall 2006 | Go to article overview

Total Optimal Performance Scores: A Practical Guide for Integrating Financial and Nonfinancial Measures in Performance Evaluation: Tops Uses Excel Solver, a Mathematical Optimization Tool, to Determine the Most Efficient or Top-Performing Division in an Organization and Then Score Other Divisions' Performance against It


Briggs, John, Claiborne, M. Cathy, Cole, Elizabeth, Management Accounting Quarterly


EXECUTIVE SUMMARY Most companies use multiple measures to evaluate employee, departmental, or divisional performance. Aggregating multiple measures is subjective and can lead to employee dissatisfaction and game playing. Now there is TOPS (Total Optimal Performance Scores), which uses an objective, mathematical way to aggregate multiple performance measures into a single performance score.

Today's competitive markets demand a robust performance evaluation. As organizations realize that profit-based models for evaluating performance are inadequate, models that incorporate both financial and nonfinancial measures of performance have started to appear. Although financial measures are generally lagging measures of performance, nonfinancial measures such as sustainability, learning and growth, and internal process improvements are leading measures of performance that can offer insight about future performance. Models that aggregate dissimilar performance measures typically assign targets or benchmarks to individual measures. Because judgment plays a large role in assigning benchmarks to the performance measures, employees may perceive the targets as arbitrary, and, if they do, employee dissatisfaction and game playing can result.

To address this issue, we will illustrate how to implement Total Optimal Performance Scores (TOPS). This mathematical optimization tool uses Excel Solver to determine the most efficient or top-performing division in an organization and, subsequently, scores all remaining divisions relative to the top-performing one. While true optimization finds the best possible outcome, provided all conditions are perfect, TOPS finds the best possible--or top--outcome observed in practice. TOPS evaluates dissimilar performance measures and aggregates the different measures, such as profit and customer satisfaction, into a single score. (1) This approach provides a constantly moving target that employees can strive toward, yet it seems obtainable because at least one unit obtains a top score. Let's begin with a simple performance evaluation model that does not use TOPS and then show one that does.

PERFORMANCE EVALUATION WITHOUT TOPS

Suppose Myers Company, a fictional company, has four divisions (North, South, East, and West) and uses a profit-based model to evaluate the divisions' performances. Myers Company establishes a target, or benchmark, that profit is expected to be 50% of labor costs, with the input being labor costs and the output being profit. Table 1 illustrates the labor costs and profit for the company.

Figure 1 presents each division's performance in comparison to the 50% benchmark. The top left corner of the figure, where profit is highest while labor costs are lowest, represents optimal performance, while the bottom right corner of the figure, where profit is lowest and labor costs are highest, represents the worst performance. The line represents the benchmark that profits should be 50% of labor costs. Any division with performance above the line has a positive performance evaluation, and any division with performance below the line has a negative evaluation. Distance from the line represents how much a division exceeded or missed the benchmark. Under this criterion North, West, and South divisions have profit exceeding the benchmark and positive performance evaluations. East has profit less than the benchmark and a negative performance evaluation. North's performance is the furthest distance from the benchmark line, which means North had the best performance relative to the benchmark.

[FIGURE 1 OMITTED]

In this scenario, North might be dissatisfied being evaluated the same as South and West. Although all three divisions have profit exceeding the benchmark, North's performance exceeds the performance of both South and West. Table 2 shows the performance of each division compared to the benchmark performance: profit as 50% of labor costs. …

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

Total Optimal Performance Scores: A Practical Guide for Integrating Financial and Nonfinancial Measures in Performance Evaluation: Tops Uses Excel Solver, a Mathematical Optimization Tool, to Determine the Most Efficient or Top-Performing Division in an Organization and Then Score Other Divisions' Performance against It
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Full screen

matching results for page

Cited passage

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.