Question Completion Status Northeast utilities (NEU) is in the business of generating and distributing electricity to the customers in various North-eastern states in the USA. In order to address various issues related to customer service, NEU operates a full-fledge call center. To provide better training to its customer representatives, NEU records the chat of each customer call and use it extensively to analyze various customer service related issues. Currently, NEU employs 8 call analyzers. The cost of paying each analyzer is $50,000 this year Pay rate increases at 10% per year (i e, pay rate in each year is 110% of that in the previous year). For example, pay rates in the next two years will be 50000*(1+10%) and 50000"(1+10%)*(1.10%) respectively Developments in the data mining technologies have made it possible to use speech mining in order to analyze customer calls. NEU is planning to purchase such automated call analysis tool - Callminer from Cal Mining Inc. The cost of Callminer is $800000 and annual maintenance cost for Callminer is $150000. NEU deploys Callminer, it will need only one analyzer. Does it make sense to buy Callminer? If so, how long is the payback period for Caliminer? Here we want to compare two strategies. The one with lower cumulative cost is the better one Cumulative cost is influenced by how many years the software could be used For example, if we expect that the software can be used for 3 years, then cumulative cost is the sum of the costs incurred in the first three years Build an Excel model to answer this specific what if question. If the software can be used for n (n=1,2,3. 10) years, which strategy is better? We want to see how the decision is changed as n is changing (n=1,2,3, 19.10) What is payback period of Callminer? In the figure below, cumulative cost of Callminer is higher than cumulative cost of paying analyzers for the first 4 years, than lower afterwards. If so, payback period is 4 years. Attach your Excel workbook here. $2.500,000.00 52,000,000.00 $1.500.000.00 -Cumulative Cost of Callminer 51.000 DOO 00 o cumulative Cost of Paying Analyzen 3500.000 DO Click Save and Submit to save and submit. Click Save All Answers to save all artsters. Question Completion Status Northeast utilities (NEU) is in the business of generating and distributing electricity to the customers in various North-eastern states in the USA. In order to address various issues related to customer service, NEU operates a full-fledge call center. To provide better training to its customer representatives, NEU records the chat of each customer call and use it extensively to analyze various customer service related issues. Currently, NEU employs 8 call analyzers. The cost of paying each analyzer is $50,000 this year Pay rate increases at 10% per year (i e, pay rate in each year is 110% of that in the previous year). For example, pay rates in the next two years will be 50000*(1+10%) and 50000"(1+10%)*(1.10%) respectively Developments in the data mining technologies have made it possible to use speech mining in order to analyze customer calls. NEU is planning to purchase such automated call analysis tool - Callminer from Cal Mining Inc. The cost of Callminer is $800000 and annual maintenance cost for Callminer is $150000. NEU deploys Callminer, it will need only one analyzer. Does it make sense to buy Callminer? If so, how long is the payback period for Caliminer? Here we want to compare two strategies. The one with lower cumulative cost is the better one Cumulative cost is influenced by how many years the software could be used For example, if we expect that the software can be used for 3 years, then cumulative cost is the sum of the costs incurred in the first three years Build an Excel model to answer this specific what if question. If the software can be used for n (n=1,2,3. 10) years, which strategy is better? We want to see how the decision is changed as n is changing (n=1,2,3, 19.10) What is payback period of Callminer? In the figure below, cumulative cost of Callminer is higher than cumulative cost of paying analyzers for the first 4 years, than lower afterwards. If so, payback period is 4 years. Attach your Excel workbook here. $2.500,000.00 52,000,000.00 $1.500.000.00 -Cumulative Cost of Callminer 51.000 DOO 00 o cumulative Cost of Paying Analyzen 3500.000 DO Click Save and Submit to save and submit. Click Save All Answers to save all artsters