Question

1 Approved Answer

Posted on Sep 07, 2024

The questions are the row 23-55 1 BS BANK'S CALL CENTER OFF-SHORING DECISION 3 CONSTANTS 2019 2020 2021 2022 2023 2024 4 U.S. TELECOMM COSTS,

The questions are the row 23-55

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 V.S. COMPUTING COSTS, PER EMPLOYEE (USS) NA 390 380 370 360 350 6 REAL ESTATE COST, PER V.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 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 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 [? 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 INDIAN 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 NDIA (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 TRAINING 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 57 NET CASH FLOW ANALYSIS 2019 2020 2021 2022 2023 2024 58 TOTAL BENEFITS (CASH NFLOWS): O 1:048.049.C50-C51052C54.056 Copy & paste Copy & paste Copy & paste Copy & paste 59 TOTAL COSTS (CASH OUTFLOWS) :33 :COC4C3%C3%C43047 Cogole peste Coposta peste Copyl paste Copyl paste 60 Net cash flow (BENEFITS. COSTS):5.589 1:58.19 Copyltpaste Copt paste Copy paste Copyl paste 61 MPV OF OFF-SHORNG NVESTMENT - PYBER EROGAO NA NA NA NA NA