Score quality at seventy percent and delivery at thirty percent using the RFQ rule: delivery points are one hundred minus four times lead days, floored at zero. Record the weights before looking at the winner.
Work in the spreadsheet, keeping the source columns intact. Read each row before filling the output column: the extract includes a boundary case that can expose an attractive but incorrect formula. Start with the guided example, then repeat the calculation on a changed extract and an operational handoff. The workbook uses original fictional records. A result must still work when quantities and charges change, so use cell references rather than a typed total.
Score quality at seventy percent and delivery at thirty percent using the RFQ rule: delivery points are one hundred minus four times lead days, floored at zero. Record the weights before looking at the winner.