I have one more big project I'd like you to work on. As BankTen moves toward becoming an integrated services provider, we are investigating the feasibility of starting an insurance business (excluding health insurance) for a segment of our customers. There are about 80,000 bank customers in the target population. Ideally, we would have contacted every customer to directly assess the potential amount of insurance business from each customer. However, the process of contacting and interviewing customers is extremely expensive, and we only had enough money in the budget to interview 100 customers. With the help of branch mangers and information technology staff, we successfully obtained responses from 100 randomly selected customers from the target population.

I have provided you with a Customer Data Excel file, that contains information on the total dollars each customer spends on insurance and an indication of whether each is happy with the current insurance provider(s). In addition, we have been able to get an estimate of the annual income of these customers from the bank's own database. I'd like you to analyze the data and make a short report to the management that shows the estimated total market size of the insurance business for the target population (i.e., the total dollar volume of the insurance business done by the entire population of the bank's target customers), as well as the estimated number of customers who may be willing to do insurance business with BankTen.

In addition, a recent national study done by the American Banking Association showed that a typical customer in our target population spends about $5,000 per year and about 25 percent of the customers are dissatisfied with their insurance providers. You should compare the BankTen customer population to find out if it is different from the national population as a whole.

Finally, is it possible for us to estimate annual insurance expenses based on annual income of customers? How reliable would such an estimate be?

Thanks,

Cindy