4 evaluation criteria the main attributes are

4. Evaluation Criteria : The main attributes are identification number, name, and weight.
Note that the evaluation criteria are used to identify the competency of a participant to
undertake a project. The data collected from the two phases of the evaluation process is
recorded in this database. When a participant wins the tender, the following information is
recorded: estimated starting date, estimated finish date, actual starting date, actual finish
date, estimated costs, actual cost, etc.
28

Case Study 28 Tender Evaluation Using a Decision Support System
137
Access Application Development
The following are some of the queries, forms, and reports one can create in order to
increase the functionality of the database:
Queries:
1. List the name, address, and telephone number of the companies that comply with ISO
9000 and 6-sigma process control.
2. A number of criteria are used to identify the companies that have adequate technical
capabilities to carry on the project. Each criterion has its own weight. The figure below
presents the decision tree considered during this phase. The numbers in brackets are
the weights given to each criterion. The members of the project evaluation committee
evaluate each company on a scale of 1-100 (consider only leaf criteria). Create a query
that calculates the total score for each company. Sort this information by total score.
3. In the second phase, companies are evaluated based on a cost/performance analysis.
Suppose that the members of the project evaluation committee give the following
weights to the evaluation criteria of this phase: weight of price is 50, weight of product
quality is 30, and weight of technical competence is 20. Then, the companies are
evaluated on a scale of 1-100 points. As price is a quantitative measure but quality and
technical competence are subjective measures, a price equivalent is calculated using
the following procedure:
a. Calculate the fractional weighted sum of scores for product quality and technical
competence. For example, for each tender calculate
p = score * percentage weight/100.
b. Calculate the harmonic mean and quadratic mean of the scores accumulated.
Group together tenders with a score less than the harmonic mean; and group
together tenders with a score more than the quadratic mean.
c. Calculate the geometric mean of the score ( p
1
) and price offer ( C
1
) for the tenders
in the first group and similarly p
2
and C
2
for the tenders in the second group.
◊ References (17)
1. Delivery record (67)
2. Length of relationship to the manufacturer (33)
◊ Services (42)
1. Network (25)
1. Commerce (27)
2. Maintenance (73)
2. Guarantee (24)
3. Information, training (14)
4. Maintenance (26)
1. Capital (46)
2. Provinces (54)
5. Consumer support (11)
◊ Manufacturing (24)
1. Delivery Capacity (42)
2. Quality assurance (58)
◊ Employee (17)

Case Study 28 Tender Evaluation Using a Decision Support System
138
d. Calculate benchmark price:
N = ( C
2
- C
1
)/( p
2
- p
1
).