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.
Estimate whole workers for each separate work cell using six productive hours per worker in the fictional shift plan. The allowance already accounts for breaks and non-picking time.