# Order production tracker: which stage ran late?

> Free Excel and PDF sheet to track orders in a gold workshop: days in casting, finishing, stone setting and polishing, total, delay and the longest stage.

Source: https://qintar.app/en/sheets/workshop-production-tracker.html
Language: English
قنطار (Qintar)، qintar.app

---

Free sheet for goldsmiths and shop owners · How many days did each order spend in each stage, and is it late against what was agreed?

The customer asks: is my order ready? The workshop asks: where did we fall behind? This sheet records the days each order spends in each stage and compares them with the time agreed.

[Download PDF134 KB](https://qintar.app/en/sheets/workshop-production-tracker.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-production-tracker.xlsx)

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. [Or try it online without downloading](https://qintar.app/en/tools/workshop-production-tracker.html).

![Preview of the first page of the "Order production tracker: which stage ran late?" sheet, with the table and the worked example](https://qintar.app/en/sheets/workshop-production-tracker.png)

## How to use it

1. **The order:** The number, the piece and the agreed time.
2. **The stages:** The days each stage took, once it is done.
3. **The total:** The sheet adds up the days.
4. **The delay:** Compared with the agreed time.
5. **Longest stage:** Where the time goes.

## Example The calculation with numbers

| Order | Piece | Agreed time (days) | Total days | Days late | Longest stage | Status |
| --- | --- | --- | --- | --- | --- | --- |
| Example: 701 | Wedding bands with names | 7 | 4 | 0 | Finishing | On time |
| Example: 702 | Set with stones | 10 | 11 | 1 | Stone setting | Late |
| Example: 703 | Bracelet | 5 | 5 | 0 | Finishing | On time |

| Result | Value |
| --- | --- |
| Total days late | 1 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

## The calculation

- Total days = the sum of the days in each stage.
- Days late = total − agreed time (when it is above zero).
- Longest stage = the stage that took the most days on that order.

## Terms used on this sheet

- **Casting:** Pouring molten gold into molds to form the pieces (صب).
- **Finishing:** Filing, assembling and cleaning up the cast pieces (تشطيب).
- **Stone setting:** Fixing stones into the piece (تركيب فصوص).
- **Polishing:** The last stage, which gives the piece its shine (تلميع).

## Read more

- [Tracking orders in a gold workshop: finding the delay](https://qintar.app/en/articles/workshop-production-delays.html)A step-by-step guide with a worked example.
- [Order production tracker for a gold workshop](https://qintar.app/en/tools/workshop-production-tracker.html)The same sheet online, with today's prices.

## Frequently asked questions

**Why days and not dates?**

So the calculation works in any spreadsheet program without date problems. Write the date in the piece column if you need it.

**My workshop has other stages. Can I change them?**

Rename any column to the stage you have; the calculation stays the same.

**What agreed time should I type?**

The time you agreed with the customer, or the one you set for the workshop.

**What if two stages took the same number of days?**

The sheet names the first of them, in the order casting, finishing, stone setting, polishing.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.

**Live prices in the app.** The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.html)If I split my buying over several prices, what will my average cost be?
- [Comparing suppliers: which making charge is cheaper?](https://qintar.app/en/sheets/shop-supplier-compare.html)For an order of a given weight, which supplier has the lowest real making charge after the discount?
- [Gold to silver ratio: a daily log](https://qintar.app/en/sheets/gold-silver-ratio-log.html)How many grams of silver does a gram of gold buy today, and how does that ratio move?

[All free sheets](https://qintar.app/en/sheets/)
