Able Communications

Able Communications is a leading cable service provider in a metropolitan area. The new customer billing system has caused an increase in complaints. Zoe Valine, the office manager, asked you to investigate the situation. After interviewing data entry operators and observing the online data input process, you are fairly certain that most errors occur when data is entered.

Tasks

using Excel, Suppose that Able Communications is predicting 25% annual growth, on a current base of 90,000 customers. If the growth pattern holds, how many customers will Able have in three years? If it takes about 12 minutes to enter a new customer into the system, how many additional data entry operators will be needed to handle the growth next year? Assume that an operator works about 2,000 hours per year. Also assume a 30% annual attrition rate for existing customers. NOTE: create this task using Microsoft Excel and show the formulas.