1	Outlook Money	Finance	Outlook Publishing
2	Money Today	Finance	India Today Group
3	Dalal Street Invest  ment Journal	Finance	DSIJ Ltd
4	Microfinance Insights	Finance	Microfinance Insights
5	e-Gov	General Management	CSDMS
6	Business World	General Management	ABP Pvt Ltd
7	Fortune	General Management	Time Warner Company
8	Business & Economy	General Management	Planman Media Pvt Ltd
9	Business Week	General Management	McGraw-Hill companies Inc
10	Economic & Political Weekly	General Management	Economic & Political Weekly
11	Business Today	General Management	India Today Group
12	Outlook	General News, Politics, Current Affairs	Outlook Publishing India Pvt Ltd
13	India Today	General News, Politics, Current Affairs	India Today Group
14	Week	General News, Politics, Current Affairs	Malayala Manorama Group
15	Frontline	General News, Politics, Current Affairs	Kasturi & Sons
16	Economist	General News, Politics, Current Affairs	The Economist Newspaper Ltd
17	Newsweek	General News, Politics, Current Affairs	Newsweek Inc

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 1 of 8

MT 9013 Human Resource Development

Marketing Research for Entrepreneurs and Small

Business Managers

by David J. Snepenger, Montana State University College of Business

In a previous MontGuide, "Basics of Marketing for Small Businesses and Entrepreneurs" (MT 9012 HR)

four key steps for successful marketing are identified:

1) understanding the customer,

2) making value for your customer,

3) communicating your value to your target market, and

4) making it easy for the customer to buy.

Together these four steps comprise what is called the

marketing concept, the most accepted way for small

and large businesses to market successfully. In order to implement this marketing concept, firms need

specific information that helps determine which marketing activities are both customer driven as well as

profitable for the organization.

Marketing research can provide that information to the manager.

Studies indicate that small businesses are less likely than large businesses to use marketing research in their

decision making. Reasons cited include monetary and time expenses, skepticism about potential benefits of

marketing research, and the owner/manager's self-perceived inability to carry out the study.

Many small businesses avoid marketing research because they misunderstand what it is and what it can

accomplish. Following are sev eral questions commonly asked by small business managers and

entrepreneurs about marketing research. A basic answer is provided after each question. After you read these

questions and answers, you should have the necessary information to begin conducting marketing research

as part of your own marketing activities.

What is marketing research?

Business owners and entrepreneurs acquire information through marketing research that helps identify and

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 2 of 8

define marketing opportunities and problems; generate, refine and evaluate marketing actions; monitor

marketing performance; and improve the understanding of marketing as a process.

What is the purpose of marketing research?

One of the difficulties companies face with marketing occurs when the owner/manager thinks he or she

knows what the customer wants, how they want it, where they want it and when they want it. Not enough

customers, insufficient revenues and excessive inventories indicate that the customer's needs are not being

met. Marketing research can help find the problem and identify a solution. It helps managers to look outside

of themselves for solutions.

What are some common misconceptions about marketing research?

First, many think that a small business should only initiate marketing research when it is making a profit.

However, the need for information about customers or competitors is often greatest when the business is

not

profitable. Research can provide the information necessary for the firm to redirect its marketing efforts so as

to become profitable.

Sometimes managers believe that unless research provides a complete description of a situation it is of no

value. On the contrary, a little or some information can often help direct the firm to the appropriate course

of action. In addition, if the manager seeks perfect information, by the time the information is acquired it

may be irrelevant because the situation has changed.

The "big decision" myth also limits the use of marketing research. Marketing research can help with

both

big and small decisions.

Businesses often rely on surveys too much. There are many other ways to acquire information, such as

census data or observation of customers.

The misconception that market ing research requires big bucks often stymies research. Marketing research

can be done at many different levels both big and small. Many research projects can and are being

completed for $1000 or less.

Another misconception is that you can not do research unless you are a sophisticated researcher. You don't

need a Ph.D. in marketing or statistics to do marketing research. It is mostly just hard work. Consult a good

marketing research text and/or bring in a consultant for advice and then just dig in and do it.

Is marketing research worth the expense?

A survey of small business managers in Texas revealed that 84 percent of those who conducted formal

marketing research projects in the past three years felt that the information obtained was worth the money

spent. Overall, 58 percent said that they were able to incorporate the research findings into their decisionmaking

process. Only six percent reported that they were not able to implement the results. Consequently,

when small businesses do engage in marketing research the benefits usually exceed the costs.

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 3 of 8

How large should your research budget be?

Many companies have marketing research budgets that range anywhere from .02 to 1 percent of company

sales. It is not unusual to spend 50 percent or more of the marketing research budget buying research from

consulting firms.

What topics are addressed through marketing research studies?

Marketing research can help small businesses answer the following ten crucial questions:

1. What should you market goods, services or both?

2. Should your marketing feature some sort of price advantage?

3. Should you emphasize your self, your quality offerings, your selection, your service or merely the

existence of your business?

4. Should you take on your competition or ignore all competitors?

5. Exactly who are your competitors?

6. What are your best prospects?

7. What income groups do they represent?

8. What motivates them to buy?

9. Where do they live?

10. What do they read or watch or listen to in the way of media?

What are the two basic types of marketing research?

The two basic types of marketing research are quantitative and qualitative. Quantitative research answers

questions that start with "how many" or "how much." Qualitative research addresses issues that deal with

"why" or "how." Quantitative research usually involves surveys, while qualitative studies rely on

observation or unstructured conversations with customers.

What is the process for quantitative studies?

The marketing research process consists of the planned, systematic gathering of market information to assist

in managerial decision making. The information gathering should not be approached haphazardly, but

should follow these steps.

Step 1. Define the Purpose and Objectives of the Research

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 4 of 8

The old saying, "it's more important to do the right thing than to do things right" applies to marketing

research. Exploring the wrong issue or asking the wrong questions, no matter how efficiently, will result in

useless information.

To avoid studying the wrong thing, state the purpose of the research in written form and refer to it during

each stage of the research process. For example, "The purpose of this study is to identify why local residents

prefer to shop in another community rather than in their home community." The purpose of a marketing

study relates to the specific problem, decision or question that necessitated the research. In addition, declare

specific objectives for the study and use them in the study design. A general public study might have the

following objectives:

Identify where potential customers go to purchase the goods or service in question.

Why do they choose to go there?

What is the size of the market? How much of it can the business capture?

How does the business compare with competitors'?

What impact does the business's promotion have on customers? What types of products or services do

potential customers desire?

Step 2. Determine Data Sources

Generally, data sources include secondary or published sources and primary sources (those requiring

original research such as surveys, experiments and observation). Secondary sources can provide a wide

range of information and should be consulted first. If they do not provide the information necessary to

address the research problem then primary data needs to be collected. Many useful sources are listed at the

end of this guide.

Step 3. Develop the Data Collection Instrument

If you need to collect primary data, you must construct a data collection instrument. In most cases this

consists of a questionnaire. Again, quality questionnaire construction requires reference to the purpose and

objectives of the study.

Usually a questionnaire consists of three sections. The first is generally a request for cooperation. This can

take a "help the sponsor" or a "help us serve you better" approach, or offer a small monetary or

nonmonetary incentive.

Next comes the main body of questions. This constitutes the major portion of the questionnaire. Keep to the

objective of the study.

The final section of the questionnaire usually contains classification questions. These questions ascertain

information on the characteristics of the respondent, such as age, sex, income, education, marital status and

any other information that may be of interest to the small business. Classification questions should offer

specific response categories rather than asking respondents to supply specific information. Respondents

usually are more willing to check a category such as 55-65 or $25,000-$35,000 than to report exact age or

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 5 of 8

income.

Consider the following criteria when developing a questionnaire:

1.

Relevancy: Does the question relate to the topic? Each question and each word in each question should

be viewed by the researcher and respondent as relevant.

2.

Brevity: Questions should be 20 words or less excluding answer categories.

3.

Objectivity: Questions should not suggest a particular answer by leading the respondent.

4.

Nonambiguity: Is the question expressed clearly? Avoid unfamiliar words and words with unfamiliar

meanings as well as words such as near, much, most, few, often and occasionally. Also avoid should, could

and might.

5.

Specificity: Can potential study participants answer the question? Does the question demand knowledge

and information that the respondent does not have? Respondents sometimes provide answers to questions

regardless of knowledge so that they do not appear ignorant.

6.

Vocabulary: Can potential study participants understand the question? Select words that the least

educated respondent can understand. The language should be natural and familiar.

7.

Question type: Should the information be gathered using an open or closed question?

Open-end questions are imperative when a researcher wants to assess top-of-the-mind awareness of a

product or brand through unaided recall. Open-end questions should be used when a researcher wants to

take special care not to influence question answers.

Closed-end questions will be aided by definition, since possible answers are provided. The possible answers

are known prior to data gathering. Only the frequency with which answers are given is unknown. Potential

limitations of closed-end questions include:

· position bias--the order of the responses can influence choice. This is particularly important for nonfactual,

e.g., "reasons why" questions.

·response categories need to be mutually exclusive (no overlapping categories) and collectively exhaustive

(all possible categories).

The only way to know if your data collection instrument is ready to use is to have several people try it. This

is known as

pretesting. Pretest your data collection instrument on people who are as similar as possible to

the research population with respect to age, education, knowledge of the market and other factors that could

influence the quality and quantity of data collected. When pretesting, ask your testers to fill out the

instrument in the same manner in which you anticipate collecting the data, i.e., if you plan a telephone

survey, personal interviews or mail survey, then pretest over the telephone, in an interview setting or have

people fill out the questionnaire without assistance. After the test group has completed the instrument, ask if

there were any questions they did not understand. In an effort to avoid looking stupid, respondents may fill

out a question even if they do not understand it. Also check to see if the response categories are appro

priate. Sometimes you will need to add another category or revise the wording of possible responses.

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 6 of 8

Step 4. Design the Sample

"The more, the better" is not true of sample size. Quality is more important than size. The goal of sampling

is to obtain responses from representatives of the entire population of interest. Simply interviewing friends

or those who only shop on Saturdays will probably not result in reliable data. Those not interviewed may

differ from those interviewed. Consult a marketing research text for more information on sampling designs.

Step 5. Data Collection

Data collection typically involves supervising those collecting the data. The first concern is to make sure

that interviewers adhere to the sampling design. Interviewers may be tempted for convenience's sake to

include individuals who do not meet the sample design requirements. Or they may not understand who they

should contact. In either case, the sample may not represent the population of interest.

Secondly, the manager needs to control for problems that may occur during the actual interview or data

collection activity, such as interviewers asking questions incorrectly or in any way that may elicit biased,

incorrect or incomplete responses.

Step 6. Data Analysis

The first step in data analysis is to record the answers for each question for every respondent. This can be

done by coding the information into a computer and then getting frequency distributions or tabulations, or it

can be done by hand. Determining the most frequent response or the average response may provide

additional insight. These summary calculations provide the small business manager with an overview of the

survey information.

Data analysis should not end with summary information. It should also include some cross tabulation of the

responses. Cross tabulation consists of analyzing the responses to one question separately for each category

of another question. For example, do responses of frequency of purchase vary between men and women, or

between younger and older respondents? These cross tabulations can provide valuable insights into the

subject of interest. In some cases data analysis may include more than descriptive information and cross

tabulation. It may also include statistical tests for differences in the answers given by different types of

respondents. The proper use of simple statistical tests such as the Chi-square test (for differences in

frequency distributions), the t-test (for differences in two means), and analysis of variance (for differences

in more than two means) can be found in a basic marketing research text. A good marketing research text is

listed at the end of this MontGuide.

Step 7. The Final Report

After completing the data analysis, a final report should summarize the results of the research project. In

some cases, a small business manager may not want to take the time to prepare an extensive report.

However, he or she should require the report if the research was conducted by someone outside of the firm.

Reports should summarize all the steps in the project and completely summarize the findings. Most

importantly, the report should specify the strategic implications of the findings.

Step 8. Take Action

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 7 of 8

After gaining an understanding of the research findings, establish a definite plan of action based on the

implications of the findings. The ultimate purpose of the marketing research project is to improve the

quality of managerial decision making and thereby improve business performance.

Where can I get help with marketing research?

Consulting services for marketing research are offered by private marketing research firms and advertising

agencies. Another useful source is to use marketing professors at a nearby university. Your local library will

often have a wealth of information for little or no cost to you. Not only is the use of reference librarians

inexpensive, but they can also direct you toward information you may never have considered. Specific

sources that you should consider using include:

The Statistical Abstract of the United States, a U.S. government publication containing information about

consumer markets, price levels, etc.

American Demographics magazine has several articles in each issue that identify social and economic

trends in our economy.

County and City Data Book and other government documents could provide useful information about your

market.

Also, libraries often have indexes that offer information on specific topics.

For company and industry information consult:

American Almanac of Jobs and Salaries,

Encyclopedia of Associations,

Moody's Complete Corporation Index,

Standard and Poor's Register of Corporations,

Telephone directories, and

Ward's Business Directory.

There are also several good marketing research texts that can offer more detailed explanations of material

covered here. Consult your librarian for marketing research books or purchase a marketing research book.

One recommended text is:

Marketing Research in a Marketing Environment by Dillon, Madden and Firtle, Times Mirror/ Mosby

College Publishing, St. Louis, 1990. This book is more advanced and requires a basic understanding of

statistics.

The Internet can also be a useful source of market research information. Some helpful sites include:

The American Demographics Web site

Marketing Research for Entrepreneurs and Small Business Managers 04/05/2007 12:15 PM

http://www.montana.edu/wwwpb/pubs/mt9013.html Page 8 of 8

http://www. marketingtools.com

Excerpts from the Statistical Abstract of the United States

http://www.medaccess.com/ census/census_s.htm

An index of U.S. Government sites maintained by the U.S. Government Printing Office

http://www.access.gpo.gov/ su_docs/dpos/pathbrws.html

U.S. Census Bureau Home Page

http:/ /www.census.gov

Copyright 1997 MSU Extension Service

We encourage the use of this document for non-profit educational purposes. This document may be

reprinted if no endorsement of a commercial product, service or company is stated or implied, and if

appropriate credit is given to the author and the MSU Extension Service (or Experiment Station). To use

these documents in electronic formats, permission must be sought from the Ag/Extension Communications

Coordinator, Communications Services, 416 Culbertson Hall, Montana State University-Bozeman,

Bozeman, MT 59717; (406) 994-5132; E-mail -

publications@montana.edu

The programs of the MSU Extension Service are available to all people regardless of race, creed, color, sex,

disability or national origin. Issued in furtherance of cooperative extension work in agriculture and home

economics, acts of May 8 and June 30, 1914, in cooperation with the U.S. Department of Agriculture,

Charles Rust, Interim Dean and Director, Extension Service, Montana State University, Bozeman, MT

59717.

File under: Community Development

E-12 (Economic Development)

Revised April 1997 (2161000497 ST)

Council of American Survey Research Organizations® (CASRO®)

3 Upper Devon

Port Jefferson, New York 11777

(631) 928-6954 Fax: (631) 928-6041

www.casro.org • email: casro@casro.org Page 1 of 2

© 2001 CASRO - Council of American Survey Research Organizations. All Rights Reserved. This document is protected under the copyright laws

of the United States and other countries and may not be reprinted or reproduced without permission from CASRO, provided that it may be

referenced and quoted with attribution and credit given to CASRO.

Importance of Marketing Research

Below is a potpourri of ideas that writers can use to use to develop articles about research.

Philip Kotler, the acknowledged guru of marketing, defines marketing as: “

a social and managerial process by which

individuals and groups obtain what they need and want through creating, offering, and exchanging products of value

with others”.

Others have said that company marketing skills can launch a new era of high economic growth and living standards.

Both ideas are built upon the Marketing Concept that was introduced in the mid-1950s, which states: “

The marketing

concept holds that key to achieving organizational goals consists in determining the needs and wants of target

markets and delivering the desired satisfaction more effectively and efficiently than competitors”.

Again quoting Kotler, “

Marketing management is accomplished by carrying out marketing research, planning,

implementation, and control”.

Meaningful marketing and strategic planning relies on management’s ability to develop

and maintain a marketing information system and have the skills to carry out sound marketing research.

1. If marketing is the engine that drives the U.S. economy, then marketing research is the process that keeps the

engine tuned.

2. Classical marketing research, gathering data about goods and services

•

The emphasis on marketing is on the identification and satisfaction of customer needs.

•

In order to determine customer needs and the implement marketing strategies and programs aimed at

satisfying those needs, marketing managers need information. They need data about customers,

competitors, and other forces in the marketplace.

•

The task of marketing research is to assess the data needs and to provide management with relevant,

accurate, reliable, valid, and current data.

•

Recently research firms have been requested to analyze the data and provide marketing intelligence and

information.

•

Importance of research can be gauged by the wide range of organizations that use marketing research:

•

Small businesses

•

Large businesses

•

Manufacturing companies

•

Technology companies

•

On-line marketers

•

Policy makers

•

Professional services

•

Non profit organizations

•

Government Organizations

•

And marketing research is used for a wide range of purposes

•

New and improved products

•

More convenient delivery of products and services

•

Content research for television and movie production

•

Examples of how marketing research changed the landscape:

•

Harley Davidson’s comeback in the 1990s

•

Changing attitudes toward store brand jeans. JC Penny vs. Levi

Council of American Survey Research Organizations® (CASRO®)

3 Upper Devon

Port Jefferson, New York 11777

(631) 928-6954 Fax: (631) 928-6041

www.casro.org • email: casro@casro.org Page 2 of 2

© 2001 CASRO - Council of American Survey Research Organizations. All Rights Reserved. This document is protected under the copyright laws

of the United States and other countries and may not be reprinted or reproduced without permission from CASRO, provided that it may be

referenced and quoted with attribution and credit given to CASRO.

•

Oldsmobile sheds old image

•

Research helped Amtrak create high-speed, premium railroad service from Boston to DC.

•

Starbucks Coffee – capitalized on changes in consumer behavior to gain foothold in competitive coffee

market.

•

Making of a president – Bill Clinton

•

Marketing research gave Chrysler the confidence to enter the minivan market that GM and

Ford.considered too risky, and to seize a lucrative opportunity.

Marketing research, as a profession, has made many important contributions to the marketing process. Marketing

research has been used to hasten the introduction of successful new products and services to the market place.

New ideas and concepts have been screened before businesses make huge investments in plant and material on

products which consumers would not support. Product formulations have been improved by means of consumer

input through various research techniques. In fact, the industry has played a major role in managing every aspect of

the marketing mix, from pricing to promotion for the world’s leading manufacturers and service organizations.

3. More recently:

•

Customer Satisfaction Research

•

An example of how the industry has adapted to meet the expanding needs of marketing and business

managers.

•

When management became interested in the voice of the customer, it was marketing research that

enabled them to dialog.

•

Involvement in this type of research is preparing the industry to transition into other areas of business

management beyond just marketing.

•

We are starting to rub elbows with decision-makers form HR, Finance, etc.

4. In the Future:

•

We will be asked to become involved in the management of the overall value of the firm, as opposed to a

brand by brand approach.

•

Marketing research will become involved with more than just marketing type data. The marketing research

professional of the future will use information from many different areas to assist decision makers at the

highest levels within the organization to plan and manage the firm’s activities.

•

This will affect the type of skill sets that marketing research firms will need in the future.

•

In order to be considered a full-service firm in the future, marketing research firms will be required to hire

and train professionals from academic areas, such as Change Management, Industrial Psychology,

Finance, that are not currently represented in the firm.

•

Marketing research has kept the marketing engine well tuned and in the future it will be called upon to pull

information from all sectors of the firm to assist management grow the value of the enterprise.

For more information, please contact us.

Profit Value Analysis per Exel Business Centre

Management Information System (MIS)

July 2002

BG&S, along with Exel’s New Technologies Departments, has developed

the MIS information analysis system that allows the analysis of the

operating result and profit value per centre, volume and quality indicators,

transportation cost, invoicing and productivity per client.

Introduction

Troughout February, March and June of 2002, Exel and BG&S undertook the development of a

tool that allows information analysis per business centre according to specific guidelines issued

by the Head of the Systems Department.

Taking the system LMS (information system associated to the Management of Warehouses) as a

starting point, the requirements that should comply with the new system are defined. The aim is

focused on creating an efficient and accessible tool, so that the head of the organization can

make better decisions based on the data obtained.

Therefore, it is necessary develop a user-friendly tool that comprises all the pertinent information.

This tool is implemented in a new application accessible from the Exel Intranet.

Client Profile

Exel is the global leader in supply

chain management, providing

customer focused solutions to a

wide range of manufacturing and

retail industries. Exel’s

comprehensive range of

innovative logistics solutions

encompasses the complete

supply chain from design and

consulting through freight

forwarding, warehousing and

distribution services to integrated

information management and ecommerce

support.

Exel, a UK listed, FTSE 100

company, has turnover of over

£4.5 billion (US$6.5 billion) and

employs more than 60,000 people

in 1,300 locations in over 120

countries worldwide. Exel’s

customers include over two thirds

of the world’s largest, quoted nonfinancial

companies. More

information is available at

www.exel.com

.

Approach

Exel’s aim is to build flexible and

scalableplatform-based

information analysis tools that can

easily integrate with existing

applications.

Advantages

The solution developed by BG&S

has enabled Exel to benefit from:

-

Fast analysis of the

information by business

centre.

-

Scalability and integration

with the existing

environments.

-

Global Implantation in its

Intranet.

Software and Services

Microsoft Visual Studio 6.0

Windows

 2000 Server with

Microsoft Internet Information

Services (IIS)

Microsoft SQL Server 2000

and OLAP services (Analysis

Services)

BG&S B

USSINES SOLUTIONS

The Solution

The information analysis system solution provided by BG&S is based on the use of both relational

and OLAP information systems. Relational systems are used to make detail level calculations,

while OLAP systems are utilized to consolidate information into aggregate levels.

This solution is based on various multidimensional models associated to the functional needs of

each area of the organization.

The project rollout is divided in the following phases:

Phase 1: Prior study:

Requirement evaluation and Functional analysis. After a

thorough analysis of the company and its information sources, a functional document is drafted in

which guidelines are set in order to follow a correct development of the system and it is approval

by the person in charge of Exel. This document can provide an approximation of the real data

models that will configure the final system, definition of report types and user functionalities of the

reports.

Phase 2: Oracle Interface Definition:

Definition of the primary procurement data

structure. Once the multidimensional models have been set, guidelines are established so that

the design of the Oracle Interface can be adapted to the previously defined functional needs.

The person in charge of the interface is responsible of obtaining the data from Exel’s

information systems.

Phase 3: User Interface:

It contains all the reports based upon which the user can

analyze the data contained in the multidimensional models.

There are four types of report:

1. Evolution Report:

analysis of dimension members in a selected period, showing

the evolution of each variable from past to the chosen periods.

2. Comparative Report

: comparison in values between measures in each model.

3. Ranking Report

: maximum number of members in a dimension depending on the

highest value of a measure. Allows the possibility of obtaining higher profit centers and

sectors

4. Free Analysis Report

: tailored reports according to each users needs.

Home screen:

Report Sample:

Phase 4: Data Transformation Services:

Transformation programs that load data into the

multidimensional models. The final multidimensional models are obtained from the Oracle

Interface according to the data obtained and the initial requirements. The models include the

following indicators:

1.

Transport: transported volumes per centre, client and province.

2.

Handling: volumes handled at each centre per client.

3.

Warehouse: warehouse volumes per centre and client, one of Exel’s key business lines.

4.

Administration: invoicing per client and centre.

5.

Financial: profit value per centre and client.

6.

Human Resources: productivity per centre and client.

7.

Quality of Service: service fulfilment and notice times agreed with each client, with the

possibility of evaluating if quality standards are reached.

8.

Indicators: calculated ratios of all the other multidimensional models.

The initial data load is carried out with one centre (A Coruña) and, after data validation, will serve

as the template for the other centres.

Phase 5: Integral tests:

Before the application goes live, Exel will carry out a full

validation of the system and will give final approval, thus guaranteeing that the requirements have

been fulfilled and allowing the loading of data for the remaining centers.

The Benefits

Flexibility, Scalability, Integration

The benefits rendered by the analysis tool are various. First of all, board members can easily

access and analyze the data generated by the organization and thus make better decisions.

Second, information is updated on a daily basis and its flexibility allows for information analysis

based upon new management criteria, opening/closing centres, etc., which is one of its major

advantages.

Finally, the system is fully scalable and can integrate with the existing information systems.

The Future

As a result of the recent merger with MSAS, Exel plans to unify all its systems. This initiative will

set the basis of a much larger project in which a Datawarehouse will integrate and unify all the

company data, in a client-detail level and with a daily information update.

For more information

For more information about BG&S’s products and services visit the Web site at

http://www.bgsonline.com

© 2002 BG&S. All rights are reserved.

This “practical solution” is published with an informative effect. BG&S does NOT OFFER, EXPRESS NOR

IMPLY GUARANTEES IN THIS SUMMARY. Microsoft, Visual Studio, Microsoft SQL Server are registered

commercial products of Microsoft Corporation. The company names and products mentioned in this

document may be registered products of its respective owners.

For more information

For more information about BG&S’s products and services visit the Web site at

http://www.bgsonline.com

© 2002 BG&S. All the rights are reserved.

This “practical solution” is published as an informative effect. BG&S does NOT OFFER NEITHER EXPRESS

NEITHER IMPLICITIES GUARANTIES, IN THIS SUMMARY. Microsoft, Visual Studio, Microsoft SQL Server

are registered commercial products of Microsoft Corporation. The company names and products mentioned

in this document can be registered products of its respective owners.