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 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 SoftWaire 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:

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 years salary per person. 9. Office space lease costs in Canada will remain roughly the same whether SoftWaire 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:

INSTRUCTIONS FOR COMPLETING THE REPORT (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

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?

I need the steps and if possible the screenshots of exel.. I need it asap please Help out

please solve and help out asap