.

3. A business process outsourcing has the following avoided costs, incurred costs, and other characteristics: . Costs avoided by outsourcing: o Salaries, wages, and benefits = $450,000 a year o Furniture and equipment = $100,000 a year o Supplies = $150,000 a year o Software = $10,000 a year o Facility rent/lease = $75,000 a year o Utilities and communications = $20,000 a year o Transition revenue now Sale of unused assets = $10,000 . Costs incurred by outsourcing: o Payments to supplier = $440,000 a year o Contract administration = $30,000 a year o Transition cost now Severance pay = $40,000 4-year time horizon . Discount rate = 4% per year . Assume all cash flows occur at the beginning of each year . Assume "now" is the beginning of Year 1. Use Excel to answer the following question. Based on the NPV of the cash flows, should this business process be outsourced? Upload your Excel workbook (containing this problem and Problem 1, each on a separate worksheet), together with this Word file (for problems 2 and 4) before the due time and date