Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| رقم الأمر | الموديل | الكمية | الخارج من آخر مرحلة | نسبة الإنجاز | المتبقي |
|---|---|---|---|---|---|
| PO-101 | مرتبة طبية مزدوجة | 100 | 60 | 60.0% | 40 |
| PO-102 | طقم ستائر | 60 | 60 | 100.0% | 0 |
| PO-103 | مفرش سرير 6 قطع | 200 | 0 | 0.0% | 200 |
| PO-104 | كنبة ثلاثية | 25 | 0 | 0.0% | 25 |
Example from the “لوحة المتابعة” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- "المراحل" (Stages): Cutting, sewing, filling, upholstery and packing. Up to 12 stages in your own order. The last one is the stage completion is measured against.
- "أوامر الإنتاج" (Production orders): Order number, product, customer, quantity, delivery date and fabric type, plus fabric waste in metres and filling waste in kilograms for each order.
- "حركة المراحل" (Stage log): Each quantity leaving a stage, with its date, choosing the order and the stage from a list.
- "لوحة المتابعة" (Tracking board): For each order: the quantity at each stage, completion percentage, remaining quantity, days left and status, along with the fabric type and waste.
- "تقرير أسبوعي" (Weekly report): Enter the week's start date and it shows the quantity that left each stage that week, the number of orders in progress, late and complete, and total waste. Set up to print on landscape A4.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
You record each movement once and the rest is calculated: completion from the last stage, lateness from today's date, and the weekly report from the date you enter. Fabric and filling waste sit beside each order, so you can see which order is using more than it should.
How to use it
- In "المراحل" (Stages) enter the names of your factory's stages in order (up to 12). The last stage you enter is treated as the final stage.
- In "أوامر الإنتاج" (Production orders) enter the order number, product, customer, quantity, delivery date and fabric type, and at the end of the order the fabric waste (metres) and filling waste (kg).
- In "حركة المراحل" (Stage log) record each day the quantity leaving each stage for each order, choosing the order number and the stage from the two lists.
- Open "تقرير أسبوعي" (Weekly report), enter the week's start date, then print it (it fits a landscape A4 page).
- Open "لوحة المتابعة" (Tracking board) to see the status of each order. A cell turns red if a stage's quantity is higher than the previous stage's quantity, so check the entry.
Before you start:
- Enter the stages in consecutive cells, with no empty cell between them.
- Status: "تم" (done) if the full quantity has left the last stage, "متأخر" (late) if the delivery date has passed, "قريب" (close) if three days or fewer remain, and otherwise "جارٍ" (in progress).
- Days remaining are calculated from today's date, so they change automatically every day.
Still running this on Excel?
This sheet depends on someone collecting the numbers from each stage and typing them in. In Production Manager every worker logs receiving and handing over with one tap, so the numbers appear the moment they happen.
| In this sheet | In Production Manager |
|---|---|
| You learn the quantities after someone collects them and types them into the sheet. | The worker confirms receipt and hands over to the next stage with one tap, so every piece gets an entry time and an exit time at each stage. |
| You find out about a delay when you review the sheet, often on delivery day. | You see how many days each stage takes, which products are stalled or late, and where the bottleneck is. |
| Workers ask what to work on, or wait for it. | Each worker sees only the products that have reached their stage, with the model photo, quantity and size. |
| Breakdowns and quality problems are passed on by word of mouth. | The worker reports the problem from their screen, it reaches the management dashboard, and it can be shared over WhatsApp. |
Frequently asked questions
Are the stages fixed?
No, the five stages are an example. Change their names or add up to 12 stages in the "المراحل" (Stages) sheet (for example: pattern making, frame welding, painting).
How do I calculate fabric waste?
You enter it for each order once it is finished (the difference between the fabric cut and the fabric used). The sheet adds it up and shows it on the board and in the report.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Factory management sheets: production, cost and quality
More free templates
- Fabric requirements and marker sheet
- Clothing shop inventory sheet by colour and size
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Delivery company sheet: shipments and cash collection
- Student attendance sheet
- Study planner and lesson tracker
- Journal entries, trial balance and financial statements sheet