Blackberry
MARKETING ENGINEERING FOR EXCEL
•
CASE
•
VERSION 2.0.3
Case
ABB Electric Segmentation
By Gary L. Lilien & Arvind Rangaswamy
1. Before beginning any case, students should familiarize themselves with the model being used. Marketing Engineering for Excel comes with tutorials that demonstrate the capability of each model. The tutorial can be found under each model within the ME►XL menu after starting Excel. These tutorials are designed to work with our OfficeStar examples which are located in the My Marketing Engineering directory, usually installed in My Documents during software installation. The data required for this case is located in the My Marketing Engineering directory (usually located within My Documents): ABB Electric Data (Customer Choice).xls
2.
ABB Electric History
In March 1970, ABB Electric was incorporated as a Wisconsin-chartered corporation with initial capital provided by ASEA-ABB Sweden and RTE Corporation. The new firm’s management was to operate independently of the parent company. The company mission was to design and manufacture a line of medium-sized power transformers to market in North America. The firm produced such electrical equipment as transformers, breakers, switchgears and relays used in distributing and transmitting electrical energy. Four main types of customers buy this electrical equipment: (1) investor-owner electrical utilities (IOUs), the largest segment; (2) rural electrification cooperatives (RECs); (3) municipalities; and (4) industrial firms. Most of ABB Electric’s customers were electrical utilities.
Situation in 1974
After three years of operation, ABB Electric was approaching the breakeven point when it encountered a serious problem. Its market share in 1974 was around six percent. In 1974, total industry sales of electrical equipment dropped 50 percent compared to 1973. Further, ABB Electric was a small player in an industry dominated by large competitors such as General Electric,
•
CASE
•
VERSION 2.0.3
Case
ABB Electric Segmentation
By Gary L. Lilien & Arvind Rangaswamy
1. Before beginning any case, students should familiarize themselves with the model being used. Marketing Engineering for Excel comes with tutorials that demonstrate the capability of each model. The tutorial can be found under each model within the ME►XL menu after starting Excel. These tutorials are designed to work with our OfficeStar examples which are located in the My Marketing Engineering directory, usually installed in My Documents during software installation. The data required for this case is located in the My Marketing Engineering directory (usually located within My Documents): ABB Electric Data (Customer Choice).xls
2.
ABB Electric History
In March 1970, ABB Electric was incorporated as a Wisconsin-chartered corporation with initial capital provided by ASEA-ABB Sweden and RTE Corporation. The new firm’s management was to operate independently of the parent company. The company mission was to design and manufacture a line of medium-sized power transformers to market in North America. The firm produced such electrical equipment as transformers, breakers, switchgears and relays used in distributing and transmitting electrical energy. Four main types of customers buy this electrical equipment: (1) investor-owner electrical utilities (IOUs), the largest segment; (2) rural electrification cooperatives (RECs); (3) municipalities; and (4) industrial firms. Most of ABB Electric’s customers were electrical utilities.
Situation in 1974
After three years of operation, ABB Electric was approaching the breakeven point when it encountered a serious problem. Its market share in 1974 was around six percent. In 1974, total industry sales of electrical equipment dropped 50 percent compared to 1973. Further, ABB Electric was a small player in an industry dominated by large competitors such as General Electric,