Refer to Table 1. Write the Excel formula for each cell marked with ? in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with Copy & paste. Label each formula clearly with cell reference position.

F G 1 BS BANK'S CALL CENTER OFF-SHORING DECISION 3 CONSTANTS 2019 2020 2021 2022 2023 2024 4 U.S. TELECOMM COSTS, PER EMPLOYEE (USS) NA 959086 80 75 5 U.S. COMPUTING COSTS, PER EMPLOYEE (USS) NA 390 380 370 360 350 6 REAL ESTATE COST, PER U.S. EMPLOYEE (USS) NA 1100 1200 1300 1400 1500 7 EMPLOYEE to SUPERVISOR RATIO in the U.S. NA 20 20 20 20 20 8 AVERAGE U.S. EMPLOYMENT COST PER EMPLOYEE (USS) NA 30000 31000 32000 33000 34000 9 AVERAGE EMPLOYMENT COST PER SUPERVISOR (USS) NA 52000 53000 54000 55000 56000 10 U.S. EMPLOYEE AVERAGE TURNOVER RATE NA 0.11 0.12 0.13 0.14 0.15 11 TRAINING COST PER U.S. EMPLOYEE (USS) NA 1100 1200 1300 1400 1500 12 TRAINING COST PER INDIAN EMPLOYEE (USS) NA 1600 1700 1800 1900 2000 13 LEGAL AND TECHNICAL CONSULTING in NDIA (USS 15000000 6000000 6500000 7000000 7500000 8000000 14 TOTAL NUMBER OF LIAISON EMPLOYEES NA 4 4 4 4 4 15 COST OF ONE LIAISON EMPLOYEE (USS) NA 200000 210000 220000 230000 240000 16 COST OF BACKGROUND CHECK PER EMPLOYEE in INDIA(USS) NA 1000 1100 1200 1300 1400 17 COST OF BACKGROUND CHECK PER EMPLOYEE in U.S. (USS) NA 20 25 30 35 40 18 DISCOUNT RATE FOR NPV 0.25 0.25 0.25 0.25 0.25 0.25 19 RISK FACTORS 2019 2020 2021 2022 2023 2024 NDIA LABOR MARKET RISK: F = FAVORABLE, F NA NA NA 20 N = NOT FAVORABLE (ALL 5 YEARS) NA NA 21 EXCHANGE RATE: U = UP, S = STEADY, D = DOWN LL CUDI VEES 23 CALCULATIONS 2019 2020 2021 2022 2023 2024 24 NUMBER OF U.S. EMPLOYEES 800 [? 1.5 marks] Copy & Paste Copy & paste Copy & paste Copy & paste 25 NUMBER OF NDIAN EMPLOYEES 800 [? 1.5 marks] Copy & paste Copy & paste Copy & paste Copy & paste 26 NEW U.S. EMPLOYEES NA [? 2.5 marks] Copy & paste Copy & paste Copy & paste Copy & paste 27 INDIAN EMPLOYEE TURNOVER RATE NA [? 2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 28 NEW INDIAN EMPLOYEES NA [?1 mark] [?2 marks] Copy & paste Copy & paste Copy & paste AVERAGE INDIAN EMPLOYMENT COST 29 PER EMPLOYEE(USS) 16000 [? 3 marks] Copy & paste Copy & paste Copy & paste Copy & paste 30 NUMBER OF RUPEES PER U.S. DOLLAR 45.85 [?3 marks] Copy & paste Copy & paste Copy & paste Copy & paste 31 INDIAN EMPLOYMENT COST: 32 NDIAN EMPLOYMENT COST (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 33 NDIAN EMPLOYMENT COST RUPEES) NA [?1 mark] Copy & paste Copy&paste Copy & paste Copy & paste ACTUAL USS NEEDED FOR INDIAN 34 EMPLOYMENT COST(USS) ** [? 2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 35 COST OF LIAISON EMPLOYEES in U.S. (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 36 NDIAN LIAISON EMPLOYEE COST: 37 COST OF LIAISON EMPLOYEES in INDIA (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 38 PAYMENT FOR INDIAN LIAISON EMPLOYEES (RUPEES) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 39 ACTUAL USS NEEDED FOR INDIAN LIAISON PAYMENTS NA 1?2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 40 INDIAN BACKGROUND CHECK COST: 41 COST OF BACKGROUND CHECKS in INDIA (USS) NA [? 1 mark] Copy & paste Copy&paste Copy & paste Copy & paste 42 PAYMENT OF INDIAN BACKGROUND CHECKS (RUPEES) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste ACTUAL USS NEEDED FOR INDIAN 25 NUMBER OF INDIAN EMPLOYEES 800 [? 1.5 marks] Copy & paste Copy & paste Copy & paste Copy & paste 26 NEW U.S. EMPLOYEES NA [? 2.5 marks] Copy & paste Copy & paste Copy & paste Copy & paste 27 INDIAN EMPLOYEE TURNOVER RATE NA 1?2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 28 NEW INDIAN EMPLOYEES NA [?1 mark] [? 2 marks] Copy & paste Copy & paste Copy & paste AVERAGE INDIAN EMPLOYMENT COST 29 PER EMPLOYEE(USS) 16000 [? 3 marks] Copy & paste Copy & paste Copy & paste Copy & paste 30 NUMBER OF RUPEES PER U.S. DOLLAR 45.85 [?3 marks] Copy & paste Copy & paste Copy & paste Copy & paste 31 NDIAN EMPLOYMENT COST: 32 INDIAN EMPLOYMENT COST (USS) NA [? 1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 33 INDIAN EMPLOYMENT COST (RUPEES) NA [? 1 mark] Copy & paste Copy & paste Copy & paste Copy & paste ACTUAL USS NEEDED FOR INDIAN 34 EMPLOYMENT COST(USS) "[?2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 35 COST OF LIAISON EMPLOYEES in U.S. (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 36 INDIAN LIAISON EMPLOYEE COST: 37 COST OF LIAISON EMPLOYEES in INDIA (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 38 PAYMENT FOR INDIAN LIAISON EMPLOYEES (RUPEES) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 39 ACTUAL USS NEEDED FOR INDIAN LIAISON PAYMENTS NA [?2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 40 NDIAN BACKGROUND CHECK COST: 41 COST OF BACKGROUND CHECKS in INDIA (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 42 PAYMENT OF INDIAN BACKGROUND CHECKS (RUPEES) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy&paste ACTUAL USS NEEDED FOR INDIAN 43 BACKGROUND CHECKS [?2 marks] Copy & paste Copy & paste Copy & paste Copy & paste 44 NDIAN TRANNG COST: 45 COST OF TRANNG INDIAN WORKERS (USS) NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 46 PAYMENT OF INDIAN TRAINING (RUPEES) NA [? 1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 47 ACTUAL USS NEEDED FOR INDIAN TRAINING NA [?2 marks] Copy&paste Copy & paste Copy & paste Copy&paste 48 COST OF BACKGROUND CHECKS IN U.S. (USS) NA (?1 mark] Copy & paste Copy & paste Copy & paste Copy&paste 49 U.S. TELECOMM COSTS NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 50 U.S. COMPUTER COSTS NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 51 U.S. REAL ESTATE COSTS NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 52 U.S. TRAINING COSTS NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 53 NUMBER OF U.S. SUPERVISORS NA [?1.5 marks] Copy & paste Copy & paste Copy & paste Copy & paste 54 U.S. SUPERVISORY COSTS NA [? 1 mark] Copy & paste Copy & paste Copy & paste Copy & paste 55 COST OF U.S. EMPLOYEES NA [?1 mark] Copy & paste Copy & paste Copy & paste Copy & paste A B C D E F G 57 NET CASH FLOW ANALYSIS 2019 2020 2021 2022 2023 2024 58 TOTAL BENEFTS (CASH NFLOWS): 0 :C48-C490860-254052C54C5 Coput paste Coute paster Copli paste Copoli paste 59 TOTAL COSTS (CASH OUTFLOWS) :33 :CO-C4C3%C3%C4047 Cogole peste Coposta peste Copyl paste Copyl paste 60 Net cash flow (BENEFITS-COSTS :B88B89 :050-089 Copyte peste Copy & paste Copy & paste Copy & paste 61 MPV OF OFF-SHORNG INVESTMENT - PYBER EROGAO NA NA NA NA NA