Results 1 to 4 of 4

Formula to calculate supplier evaluation scores based on their profit margin %

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2021
    Posts
    1,011

    Formula to calculate supplier evaluation scores based on their profit margin %

    Hi,

    I've been asked to create a formula to be used in some supplier evaluations. If the suppliers profit margin percentage is higher or lower than a pre-determined range they are either allocated full or no marks. However if the profit margin percentage falls within the bands then we would like to allocate points on a straight line sliding scale based on its relative position within the range, i.e. more points are allocated the closer it is to profit margin that scores maximum points.

    Hopefully the attached explains what I'm looking to achieve to if you have any queries just give me a shout.

    Thanks in advance,

    Snook
    Attached Files Attached Files
    Last edited by The_Snook; 01-09-2015 at 06:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  2. Need to have Excel calculate profit margin based on variable...stuck!
    By djbeatsent in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-09-2013, 11:21 AM
  3. Replies: 2
    Last Post: 01-09-2010, 04:06 AM
  4. Need Backwards Profit Margin Formula
    By waywrdchld in forum Excel General
    Replies: 7
    Last Post: 04-14-2009, 09:56 AM
  5. gross profit margin formula
    By julmcgrath in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1