Scenario
You are a former Navy officer and fighter pilot who is now the controller of a division of
TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at several airports in the
southeast part of the United States. Your division’s private charter clients include several Fortune
500 companies in the region. The Chief Financial Officer (CFO) has informed you that the
company is considering the acquisition of two smaller aviation firms in the Caribbean
specializing in chartered flights for luxury vacations using light aircraft (60 passengers or less).
The CFO has tasked you with assessing the organizational benefits of acquiring these aviation
firms. The CFO intends to develop a new business plan for the organization if your analysis
recommends moving forward with the acquisition.
After an initial assessment, the company has shortlisted two airlines they want to examine further
for acquisition. To understand all aspects of the two airlines under consideration, you have
visited each proposed site to assess their performance. The assessment includes creating and
analyzing a balanced scorecard for each airline with all four components—financial, internal
processes, customers/market, and learning and growth—that will impact the acquisition.
In this milestone, you will use the given information to create balanced scorecards for Company
A and Company B.
Prompt
Use the Basic Balanced Scorecard Template to create a balanced scorecard for each company.
Specifically, you must address the following rubric criteria:
A. Use the data given in Company A Information and Company A Financials to create
a balanced scorecard for Company A. The balanced scorecard should highlight key
performance indicators, such as net profit, annual growth, and market share, and include
the four components:
a. Financial: Complete the financial section of the balanced scorecard template,
identifying two of the most relevant key performance indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
b. Internal Processes: Complete the internal processes section of the balanced
scorecard template, identifying two of the most relevant key performance
indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
c. Customers/Market: Complete the customers/market section of the balanced
scorecard template, identifying two of the most relevant key performance
indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
d. Learning and Growth: Complete the customers/market section of the balanced
scorecard template, identifying two of the most relevant key performance
indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
B. Use the data given in Company B Information and Company B Financials to create
a balanced scorecard for Company B. The balanced scorecard should highlight key
performance indicators, such as net profit, annual growth, and market share, and include
the four components:
a. Financial: Complete the financial section of the balanced scorecard template,
identifying two of the most relevant key performance indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
b. Internal Processes: Complete the internal processes section of the balanced
scorecard template, identifying two of the most relevant key performance
indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
c. Customers/Market: Complete the customers/market section of the balanced
scorecard template, identifying two of the most relevant key performance
indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
d. Learning and Growth: Complete the customers/market section of the balanced
scorecard template, identifying two of the most relevant key performance
indicators.
i. Explain your rationale for the KPIs chosen, with an explanation of the
cause-and-effect relationship between the chosen KPIs.
Guidelines for Submission:
Submit two completed Excel spreadsheets using the provided template.
