The Marlow Distribution operations manager asked you to review logistics interview: foundations. The Operations sheet contains original fictional source records and the task brief contains the working policy. Deliver a linked workbook with all requested output columns, keep the source extract unchanged and identify the boundary rows before handoff.
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.