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.
Convert order lines into required units by multiplying orders by units per order. The result becomes the common quantity used for labor planning and stock availability checks.