Marlow Distribution needs a workbook another analyst can review without reconstructing your calculations. Build the output one column at a time. Each step keeps the earlier work and adds a different measure, so the last workbook contains an operational report rather than a single answer. Keep source records unchanged. Review the zero, equality and excess cases before handing the result to the buyer or warehouse manager. All records and quoted amounts are fictional training data. The checker changes inputs behind the scenes to confirm that your formulas still respond to the source extract.
Apply the stated mandatory quality and lead-time limits before ranking price. One means both limits are met. A low offer can't compensate for a failed mandatory requirement in this exercise.