A home textiles factory has two questions every week: where is each order, and how much fabric and filling did we lose? The answers are usually scattered across a supervisor's notebook and a WhatsApp group.
This free Excel sheet gives you one register for the quantity leaving each stage and a dashboard that turns it into a status per order. The sheet and its page are in Arabic: home textiles production sheet. It is built on the garment version, production tracking sheet.
What is inside
- Stages: cutting, sewing, filling, upholstery, packing (change or extend to 12).
- Production orders: order, product, customer, quantity, delivery date, fabric type, fabric waste in metres, filling waste in kg.
- Stage log: each quantity leaving a stage, with its date.
- Dashboard: per order, quantity at each stage, completion, remaining, days to delivery, status and waste.
- Weekly report: enter the week start date; it totals each stage for the week, counts running, late and completed orders and the total waste. Printable on A4 landscape.
A worked example from the sheet's sample data
Sample numbers, not a real factory.
- PO-101, double mattress, 100 pcs: 60 packed, so 60% complete, 40 remaining.
- PO-102, curtain set, 60: all 60 packed, 100%, status done.
- PO-103, 6-piece bedspread, 200: all cut and sewn, 120 filled, none packed: 0% by the last stage, but the stage columns show it is well advanced.
- PO-104, 3-seat sofa, 25: only cut so far, 25 remaining.
- Waste across the four orders: 115 m of fabric and 27 kg of filling.
Limits
Waste is typed by you per order; the sheet adds it up but does not measure it. For several users with permissions, worker-level scanning and WhatsApp alerts, see our production management system.