# 4 evaluation criteria the main attributes are

• blkstar1
• 249
• 100% (1) 1 out of 1 people found this document helpful

This preview shows page 137 - 140 out of 249 pages.

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 toundertake a project. The data collected from the two phases of the evaluation process isrecorded in this database. When a participant wins the tender, the following information isrecorded: estimated starting date, estimated finish date, actual starting date, actual finishdate, estimated costs, actual cost, etc.28
Case Study 28Tender Evaluation Using a Decision Support System137Access Application DevelopmentThe following are some of the queries, forms, and reports one can create in order toincrease the functionality of the database:Queries:1.List the name, address, and telephone number of the companies that comply withISO9000 and 6-sigma process control.2.A number of criteria are used to identify the companies that have adequate technicalcapabilities to carry on the project. Each criterion has its own weight. The figure belowpresents the decision tree considered during this phase. The numbers in brackets arethe weights given to each criterion. The members of the project evaluation committeeevaluate each company on a scale of 1-100 (consider only leaf criteria). Create a querythat 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 followingweights to the evaluation criteria of this phase: weight of price is 50, weight of productquality is 30, and weight of technical competence is 20. Then, the companies areevaluated on a scale of 1-100 points. As price is a quantitative measure but quality andtechnical competence are subjective measures, a price equivalent is calculated usingthe following procedure:a.Calculate the fractional weighted sum of scores for product quality and technicalcompetence. For example, for each tender calculatep= 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 grouptogether tenders with a score more than the quadratic mean.c.Calculate the geometric mean of the score (p1) and price offer (C1) for the tendersin the first group and similarlyp2andC2for 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 28Tender Evaluation Using a Decision Support System138d.Calculate benchmark price:N= (C2-C1)/(p2-p1).

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 249 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
Housing Department