Cost Centers; The Finance Function; Spreadsheet Application The consulting firm A. T. Kearney analyzes and ranks the top offshore outsourcing locations for companies seeking to outsource the finance...

Cost Centers; The Finance Function; Spreadsheet Application The consulting firm A. T. Kearney analyzes and ranks the top offshore outsourcing locations for companies seeking to outsource the finance function. Kearney provides three measures of the attractiveness of the country as a location for outsourcing: financial attractiveness (low cost), skills availability, and business environment (that supports investment in the country). For each measure, a larger score is a better score; financial attractiveness is scored from 0 to 4, while skills availability and business environment are scored from 0 to 3. The A.T. Kearney measures are useful to a firm that is considering outsourcing its finance function and also considering outsourcing this function to a foreign country. A firm that considers the finance function as a cost center may wish to find a location where the work can be done reliably at the lowest possible cost. Note that outsourcing would not be considered if for any reason the finance function is considered strategically critical to the company; in that case the finance function would be retained close to top management. For example, a company with a stable, cost leadership-focused operation would be more likely to offshore the finance function than a company that operates in a dynamic competitive environment where financial skills are needed for many day-to-day decisions. Note: The countries below are listed in alphabetical order.

Required Using Excel, filter out any countries with a business environment score less than 1.5 or a skills availability score less than 1.0. Then compute a weighted average of the remaining countries using the following weights: 50% for financial attractiveness, 30% for skills availability, and 20% for business environment. Finally, rank the countries from highest to lowest using this weighted average measure.

1. Which country has the highest rank? a. Malalysia b. China c. Thailand d. Mexico

2. Describe some other possible strategies for ranking the countries. Explain why those strategies could be helplful.

3. What are some of the strategic and global issues to consider in outsourcing the finance function?