DO IT ON AN EXCEL SHEET

SoftWaire Inc., a Canadian software development company is contemplating outsourcing a portion of its operations to Bangalore, India. The primary attractions for SoftWaire Inc. are the lower salaries in India and availability of English-speaking engineers. The average salary of the 20 people they are thinking of replacing with an offshore operation is C$75,000 per year, while the salary of a comparable engineer in India is 600,000 rupees; (40 rupees per C$). The salary costs in India are about 20% of what they are in Canada. This could bring substantial savings to SoftWaire Inc.; however there appear to be numerous uncertainties associated with outsourcing. You have been asked to conduct an analysis so SoftWaire Inc. can better understand the potential benefits and risks of the outsourcing project. Based on your initial data gathering you have found the following information: 1. The salaries of software developers in India are indeed lower than those in Canada; however, demand from other local and international employers is strong and is causing salaries to increase at a rate of 10% to 15% per year, with some forecasts as high as 20% per year. By comparison, Canadian salaries are expected to grow at a rate of roughly 5% per year. 2. Due to the high level of competition for good software developers in India, there is a high turnover rate in the industry. Estimates run from 20% to 30%. The Canadian market is stable by comparison. 3. Most foreign companies use the services of a recruiter to find suitable employees. Recruiters typically charge a fee of about 30% of the salary of the successful employee. The charge covers the recruiters services to solicit applications, screen candidates, and present alternatives for final selection. 4. Training costs for new employees in their first year can be up to 70% of their salary for education in best practices and procedures used by the employer. Their productivity is typically about 50% of the trained employees due to the learning process. 5. For software development outsourcing to be successful, other firms report that they spend considerable time ensuring that software specifications are precise, that quality assurance procedures are clearly spelled out and followed, and that developers adhere to best practices. The cost of this additional project management has been estimated to add 10% to 20% to salary costs. 6. Periodic problems with infrastructure and cultural differences have been reported to reduce overall development productivity in India to about 70% of that in Canada. 7. Setting up an outsourced team can entail considerable start-up costs. Travel, recruiter, selection, facilities selection, and equipment installation for the team of 20 can range from C$300,000 to C$500,000. 8. SoftWaire Inc. would lay off 20 software engineers at the start of the project. This will cost one years salary per person. 9. Office space lease costs will be roughly the same whether SoftWaire Inc. outsources or not. 10.SoftWaire Inc. uses a MARR of 25%. 11.The Canadian dollar has fluctuated against the Indian rupee in recent years, and there is some concern that the rupee may strengthen against the dollar by as much as 10% in the coming years. You have decided to set up a spreadsheet to help with your analysis. From the information above, you plan to use the following as variables in the sensitivity analysis:

(1) Salary growth rates for both Canadian and overseas software developers.

(2) Turnover rates of overseas employees.

(3) Overseas recruiting costs, as a percent of salary.

(4) Training costs, as a percent of salary.

(5) Productivity rates of an employee in training. (6) Productivity rate of a trained employee.

(7) Additional project management costs, as a percent of salary.

(8) SoftWaire Inc. MARR (

9) The exchange rate between the rupees and the Canadian dollar.

(10) Start-up costs.

INSTRUCTIONS FOR COMPLETING THE REPORT (a) Construct a spreadsheet with the above variables to project the costs of outsourcing for a study period of 10 years. Start with the basic projected salaries, and adjust for recruiting and training costs, then for training and long-term productivity costs, and finally for project management, startup, and layoff costs. Assume that the overseas developers are hired at time zero. When a range of values have been given for a variable, use the midpoint as the base case.

(b) Determine the present worth of outsourcing. (c) Determine the present worth of insourcing that is using Canada based developers.

(d) What is the present worth of the benefits of outsourcing?

(e) Using the spreadsheet, conduct a sensitivity analysis for each of the uncertain factors, varying each factor by 10% to determine which has the greatest impact on the present worth of the benefits of outsourcing.

(f) What factors have the greatest impact on present worth of the benefits of outsourcing? What would you advise at this point?

(g) At what exchange rate would the present worth of outsourcing be zero?

(h) At what productivity rate would the present worth of outsourcing be zero?

(i) Formulate what you think would be the worst-case, most likely, and bestcase scenario, for SoftWaire Inc. in terms of whether outsourcing is economically a good decision or not. What are your recommendations based on the information you have? If you could invest in obtaining better parameter estimates, which ones would you pick? and why?