Refer to the data and results of Problem 6.38. In small groups, complete the following.

Required

a. For each customer type (A, B, and C), estimate for the entire customer population the percentage of each type, average account balance, average number of trades, and average number of other services purchased. (Hint: This is easily done with Excel’s Pivot Table function wizard [look under the Data menu].)

b. FSB charges customers for other services based on the extent and quality of services used. Interest on account balances and trading fees are the same for each customer type. Fill in the following table and estimate FSB’s customer-level revenues.

Customer Revenue Data A B Cc Customer sample Percentages 0.00.0... eeeeere eee ? te @

Customer population (1,000,000) .......... eee ? Z ?

PVETAGEACCOUMEOAIANCE terse easter est: fe @ ?

EN CLAGeranmUAlthaGO St aninee scan menatsstecancenteenacn e @ ¥ eB AVElAGES OMEN SEIVICES «15. .004.e suum atnaeenee vedo ensenens ? @ ?

ACcountrevenuen(GoreaG)ine.e.. eyeen eenrain 2% 2% 2%

TACING TES! PEthadS A CA Ala ial, Acne tee as $13 SHS ours

@iheitees WSSeIVICER ecteteertt eset ore: $200 $100 $50