Quick Formulas

  • Price Difference (new- original)/original X100
  • Max Score 100 100/ score X weighting
  • Max Score betwen 2 numbers score/max score or price/max price i.e A1/A2
  • Tender Score actual score/ max score X weighting
  • Price Score lowest price/tender price X weighting
  • Original Price from Discount % = price/(1- discount) or sale price/perecntage paid -to work out % paid add a pre-requsite calculation 1-% discount)
  • Increase by percentage = price X (1+percent increase)