SKY-HIGH INTERNET SERVICE

SKY-HIGH INTERNET SERVICES 

Situation:

Sky-High Internet Services is a leading Internet service provider in a metropolitan area. The new customer billing system has caused an increase in complaints. Tammy Jones, 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. 

Question 1:

Write a brief memo to Tammy explaining the importance of data validation during the input process.

ANSWER:

Question 2:

Suggest at least three specific data validation checks that might help reduce input errors.

ANSWER:

Question 3:

Would a batch input system offer any advantages? Write a brief memo to Tammy stating your views

ANSWER:

Hi Tammy, batch input system is useful and an advantage specially when dealing with a predefined schedule, such as determining the financial status or accounting. Online data entry is an advantage also in handling transactions that needs immediate response, so there should be an analysis of which system will be using in a particular component.

Question 4:

Suppose that Sky-High is predicting 25% annual growth, on a current base of 90,000 customers. If the growth pattern holds, how many customers will Sky-High 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.

ANSWER:

The customers most likely to be increased in the next three years. Since there is a time issue during customer data entry, there should be an additional entry operators to handle the growth each year.