Soft Waire 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 the availability of English-speaking engineers. The average salary of the 20 Canadian people they are thinking of replacing with an offshore operation is C$85,000 per year, while the salary of a comparable engineer in India is 900,000 rupees; (54 rupees per C$). The salary costs in India are about 18% of what they are in Canada This could bring substantial savings to Soft Waire Inc., however, there appear to be numerous uncertainties associated with outsourcing. You have been asked to analyze 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 employee 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 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 off-shore team can entail considerable start-up costs Travel, selection, facilities selection, and equipment installation for the offshore team 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 year's salary per person. 9. Office space lease costs in Canada will remain roughly the same whether Software Inc. outsources or not. 10. SoftWaire Inc. uses a MARR of 25% for this project. 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 perform a sensitivity analysis using the following variables: (1) (2) (3) (4) (5) Salary growth rates for both Canadian and overseas software developers Turnover rates of overseas employees, Overseas recruiting costs, as a percent of salary Training costs, as a percent of salary. Productivity rates of an employee in training Productivity rate of a trained employee. Additional project management costs, as a percent of salary. SoftWaire Inc. MARR The exchange rate between the rupees and the Canadian dollar Start-up costs. (7) (8) (9) (10) (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, start-up, and layoff costs. Assume that the overseas developers are hired at time zero. When a range of values has been given for a variable, use the midpoint as the base case. (b) Determine the present worth of outsourcing of the benefits of outsourcing (e) Using the spreadsheet, conduct a sensitivity analysis for each of the potential 10 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 3 factors have the greatest impact on the 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 benefits be zero? (i) Indicate what you think would be the worst-case, most likely, and best- case scenario, for SoftWaire Inc. in terms of whether outsourcing is economically a good decision or not. Write a concluding paragraph to state: 1. what your recommendations are, based on the information you have? 2. If you could invest in obtaining better parameter estimates, which ones would you pick? and why? Soft Waire 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 the availability of English-speaking engineers. The average salary of the 20 Canadian people they are thinking of replacing with an offshore operation is C$85,000 per year, while the salary of a comparable engineer in India is 900,000 rupees; (54 rupees per C$). The salary costs in India are about 18% of what they are in Canada This could bring substantial savings to Soft Waire Inc., however, there appear to be numerous uncertainties associated with outsourcing. You have been asked to analyze 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 employee 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 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 off-shore team can entail considerable start-up costs Travel, selection, facilities selection, and equipment installation for the offshore team 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 year's salary per person. 9. Office space lease costs in Canada will remain roughly the same whether Software Inc. outsources or not. 10. SoftWaire Inc. uses a MARR of 25% for this project. 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 perform a sensitivity analysis using the following variables: (1) (2) (3) (4) (5) Salary growth rates for both Canadian and overseas software developers Turnover rates of overseas employees, Overseas recruiting costs, as a percent of salary Training costs, as a percent of salary. Productivity rates of an employee in training Productivity rate of a trained employee. Additional project management costs, as a percent of salary. SoftWaire Inc. MARR The exchange rate between the rupees and the Canadian dollar Start-up costs. (7) (8) (9) (10) (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, start-up, and layoff costs. Assume that the overseas developers are hired at time zero. When a range of values has been given for a variable, use the midpoint as the base case. (b) Determine the present worth of outsourcing of the benefits of outsourcing (e) Using the spreadsheet, conduct a sensitivity analysis for each of the potential 10 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 3 factors have the greatest impact on the 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 benefits be zero? (i) Indicate what you think would be the worst-case, most likely, and best- case scenario, for SoftWaire Inc. in terms of whether outsourcing is economically a good decision or not. Write a concluding paragraph to state: 1. what your recommendations are, based on the information you have? 2. If you could invest in obtaining better parameter estimates, which ones would you pick? and why