Loading...
HomeMy WebLinkAbout05 - Evaluation Criteria - CalcsEvaluation Criteria RFP 04-21 HQ Evaluation Criteria Tab Assignment A B C D Adjectival Rating 0 1 2 3 4 Lowest Bid Proposal Examples 42500 40000 35500 Category Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Maximum Total Points Unsatifactory Below Min Stds Marginal Satisfactory Excellent 35500 % Calc 0.835294117647059 0.8875 1 Rating % 0 0.25 0.5 0.75 1 example see calc below Max Point 10 10 10 Max Points 35 25 30 10 100 Points Applied 8.35294117647059 8.875 10 Committee Member 1 Example Calculations Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firms ABC Audit Firm XYZ Audit Firm 123 Audit Firm Commissioner Rob Elliott ABC Audit Firm Max Points 35 25 30 10 XYZ Audit Firm Max Points 35 25 30 10 123 Audit Firm Max Points 35 25 30 10 Members Elliott 74.6029411764706 83.875 76.25 Rating 2 3 4 8.35294117647059 Rating 3 3 4 8.875 Rating 2 3 4 10 Blake 75.8529411764706 83.875 68.75 Price 42500 Rating % 0.5 0.75 1 0.835294117647059 Price 40000 Rating % 0.75 0.75 1 0.8875 Price 35500 Rating % 0.5 0.75 1 1 Conroy 75.8529411764706 76.375 61.25 Score 17.5 18.75 30 8.35294117647059 74.6029411764706 Score 26.25 18.75 30 8.875 83.875 Score 17.5 18.75 30 10 76.25 Total Score 226.308823529412 244.125 206.25 Committee Member 2 Example Calculations Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score The information in this sheet is used for example puroses only Bid administrator will fill in the tan colored fields based on the information provided by the respondants. Yellow cells will be populated based on the scoring provided by each member for each respondant. Michael Blake (Pension BOT) ABC Audit Firm Max Points 35 25 30 10 XYZ Audit Firm Max Points 35 25 30 10 123 Audit Firm Max Points 35 25 30 10 Rating 3 3 3 8.35294117647059 Rating 3 3 4 8.875 Rating 2 3 3 10 Price 42500 Rating % 0.75 0.75 0.75 0.835294117647059 Price 40000 Rating % 0.75 0.75 1 0.8875 Price 35500 Rating % 0.5 0.75 0.75 1 Score 26.25 18.75 22.5 8.35294117647059 75.8529411764706 Score 26.25 18.75 30 8.875 83.875 Score 17.5 18.75 22.5 10 68.75 Committee Member 3 Example Calculations Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Carol Conroy (Fin Dir - Casselberry) ABC Audit Firm Max Points 35 25 30 10 XYZ Audit Firm Max Points 35 25 30 10 123 Audit Firm Max Points 35 25 30 10 Rating 3 3 3 8.35294117647059 Rating 3 3 3 8.875 Rating 2 3 2 10 Price 42500 Rating % 0.75 0.75 0.75 0.835294117647059 Price 40000 Rating % 0.75 0.75 0.75 0.8875 Price 35500 Rating % 0.5 0.75 0.5 1 Score 26.25 18.75 22.5 8.35294117647059 75.8529411764706 Score 26.25 18.75 22.5 8.875 76.375 Score 17.5 18.75 15 10 61.25 Evaluation Criteria RFP 04-21 HQ Bid administrator will fill in the tan colored fields based on the information provided by the respondants. Evaluation Criteria Tab Assignment A B C D Adjectival Rating 0 1 2 3 4 Lowest Bid Proposal 42500 40000 35500 0 Category Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Maximum Total Points Unsatifactory Below Min Stds Marginal Satisfactory Excellent 35500 % Calc 0.835294117647059 0.8875 1 Rating % 0 0.25 0.5 0.75 1 example see calc below Max Point 10 10 10 Max Points 35 25 30 10 100 Points Applied 8.35294117647059 8.875 10 Committee Member 1 Evaluation Calculations Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Firm Name Evaluation Criteria Firm’s Qualifications and Experience Similar Projects/References Project Approach Price Proposal/Fee Schedule Total Score Commissioner Rob Elliott Max Points 35 25 30 10 Max Points 35 25 30 10 Max Points 35 25 30 10 Rating 0 Rating 0 Rating 0 Price Rating % 0 0 0 0 Price Rating % 0 0 0 0 Price Rating % 0 0 0 0 Score 0 0 0 0 0 Score 0 0 0 0 0 Score 0 0 0 0 0 Proposer A B C Price Proposal 42500 40000 35500 Lowest Bid Applied Percentage 0.835294117647059 0.8875 1 35500 X X X Maximum Score 10 10 10 = = = Weighted Score 8.35294117647059 8.875 10