Two completed Excel spreadsheets using the provided template.
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 divisions 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 componentsfinancial, internal processes, customers/market, and learning and growththat 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:
Financial: Complete the financial section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
Explain your rationale for the KPIs chosen, with an explanation of the cause-and-effect relationship between the chosen KPIs.
Internal Processes: Complete the internal processes section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
Explain your rationale for the KPIs chosen, with an explanation of the cause-and-effect relationship between the chosen KPIs.
Customers/Market: Complete the customers/market section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
Explain your rationale for the KPIs chosen, with an explanation of the cause-and-effect relationship between the chosen KPIs.
Learning and Growth: Complete the customers/market section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
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:
Financial: Complete the financial section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
Explain your rationale for the KPIs chosen, with an explanation of the cause-and-effect relationship between the chosen KPIs.
Internal Processes: Complete the internal processes section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
Explain your rationale for the KPIs chosen, with an explanation of the cause-and-effect relationship between the chosen KPIs.
Customers/Market: Complete the customers/market section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
Explain your rationale for the KPIs chosen, with an explanation of the cause-and-effect relationship between the chosen KPIs.
Learning and Growth: Complete the customers/market section of the balanced scorecard template, identifying two of the most relevant key performance indicators.
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.
RUBRIC:
1. Company A Balanced Scorecard: Financial Component
Develops the balanced scorecards financial component for Company A with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
2. Company A Balanced Scorecard: Internal Process Component
Develops the balanced scorecards internal process component for Company A with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
3. Company A Balanced Scorecard: Customer/Market Component
Develops the balanced scorecards customer/market component for Company A with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
4. Company A Balanced Scorecard: Learning and Growth Component
Develops the balanced scorecards learning and growth component for Company A with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
5. Company B Balanced Scorecard: Financial Component
Develops the balanced scorecards financial component for Company B with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
6. Company B Balanced Scorecard: Internal Process Component
Develops the Balanced Scorecards internal process component for Company B with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
7. Company B Balanced Scorecard: Customer/Market Component
Develops the balanced scorecards customer/market component for Company B with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
8. Company B Balanced Scorecard: Learning and Growth Component
Develops the balanced scorecards learning and growth component for Company B with two of the most relevant key performance indicators in that component; shares the rationale for the choice of KPIs; identifies cause-effect relationships between chosen KPIs.
