A useful spreadsheet records textile groups, dry weights, arrival windows, deadlines, machine assignments and complete batch turnaround. Include operators, utility constraints and planned downtime. Keep assumptions in separate cells from measured observations. Check the output by hour as well as by day, because a daily total can conceal a queue that makes a customer's deadline impossible.
Separate input assumptions from measured values and show units clearly. This makes it easier to revise the model when a cycle time or customer workload changes.
Preparing your comparison
Useful columns include textile category, customer or batch reference, actual dry weight, required dispatch time, washer occupancy, dryer occupancy and finishing requirements. Put assumptions in clearly marked cells and keep measured observations in a separate record. Add a scenario for an unavailable machine if continuity matters to the business. The spreadsheet should expose a queue or missed deadline, not only produce an attractive total number of kilograms.
Back to news & insights