Prepare a balanced scorecard report for Mangee Corporation. For each of the specific objectives listed, place that objective under the appropriate perspective heading in the report. Select a KPI from the list of KPIs that would be appropriate to measure progress toward each objective. (There are two specific objectives for each perspective and one KPI for each of the specific objectives.) In the last column in the balanced scorecard report, select if the associated KPI goal has been achieved. (Enter in the objectives using the numbers provided in the popup. Abbreviation used
Prepare a balanced scorecard report for Mangee Corporation. For each of the specific objectives listed, place that objective under the appropriate perspective heading in the report. Select a KPI from the list of KPIs that would be appropriate to measure progress toward each objective. (There are two specific objectives for each perspective and one KPI for each of the specific objectives.) In the last column in the balanced scorecard report, select if the associated KPI goal has been achieved. (Enter in the objectives using the numbers provided in the popup. Abbreviation used
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question

Transcribed Image Text:More info
Through its strategic management planning process, Mangee Corporation has selected
two specific objectives for each of the four perspectives; these specific objectives are
listed in the following table.
Specific Objective
1. Increase profitability of core product line.
2. Increase plant safety
3. Improve employee product knowledge.
4. Increase number of customers.
5. Improve production efficiency.
6. Increase customer retention.
7. Increase sales of core product line.
8. Improve employee job satisfaction.
Get mo
Requirement
Prepare a balanced scorecard report for Mangee Corporation. For each of the
specific objectives listed, place that objective under the appropriate perspective
heading in the report. Select a KPI from the list of KPIs that would be appropriate
to measure progress toward each objective. (There are two specific objectives for
each perspective and one KPI for each of the specific objectives.) In the last
column in the balanced scorecard report, select if the associated KPI goal has
been achieved. (Enter in the objectives using the numbers provided in the popup.
Abbreviation used: #= number.)
Act
X
Data table
Mangee Corporation has collected key performance indicators (KPIs) to measure progress toward
achieving its specific objectives. The following table contains the KPIs and corresponding data that
Mangee Corporation has collected for the past quarter.
A
ΚΡΙ
1
2 Hours of employee training provided
3 Number of units produced per hour
Core product line profit as a percentage of core product line
4 sales
Employee turnover rate (# of employees leaving company = #
5 of total employees)
6 Sales revenue growth-core product line
7 Number of repeat customers
8 Number of plant accidents
9 Number of customers
Print
Done
B
Goal
2,250
7.3
15%
6%
4.0
C
Actual
115,000
2,375
6.5
19%
$2,000,000 $2,100,000
104,000 103,000
8%
3
135,000

Transcribed Image Text:Mangee Corporation is preparing its balanced scorecard for the past quarter. The balanced scorecard contains four perspectives: financial, customer, internal business process, and learning and growth.
(Click the icon to view the specific objectives.)
(Click the icon to view KPIs and corresponding data.)
Read the requirement.
Perspective:
Objective KPI
Financial:
Customer:
Mangee Corporation
Balanced Scorecard Report
For Quarter Ended December 31
Goal
Goal
Actual Achieved?
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.