• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to calculate the cost of each point in one scoring segment, in relation to another scoring segment?

3mk

New Member
The following formula scores a vendors proposal based on pricing:
Points Available (10) * [(Bid Price - Minimum Bid Price)/Minimum Bid Price]

I've added a price ceiling to the denominator, so that any submissions over this are scored 0 (the ceiling is a factor of the lowest priced submission).

I created the following model:
I'm now trying to determine the correct calculation for the premium (i.e. cost) paid for each quality point scored (Quality in this case being the Technical + Safety score). I originally did this as the Price to Quality Ratio, and the difference between the price being evaluated and the minimum. I'm unsure if this is a correct approach. Does anyone know how to model the relationship between the points in pricing, and the points in quality? (e.g. for each increase in quality points, the pricing score will by impacted by x%)
 

Attachments

  • Price Scoring Calculator 2.xlsx
    12.3 KB · Views: 9
Back
Top