# Order production tracker for a gold workshop

> Production tracker for a gold workshop: days per stage for each order, the total against the agreed time, days late and the stage that took longest.

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

---

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. This calculator is the same as the ["Order production tracker: which stage ran late?" sheet](https://qintar.app/en/sheets/workshop-production-tracker.html). It runs in your browser and saves no data.

## Who this calculator is for

This is the online version of the "Order production tracker: which stage ran late?" sheet, made for goldsmiths and shop owners. A sheet to follow orders through the workshop: the days in each stage (casting, finishing, stone setting, polishing), the total, the agreed time, the delay, and the longest stage.

The question it answers: How many days did each order spend in each stage, and is it late against what was agreed?

## 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.

## Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

## 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 (تلميع).

Want to keep your work? [Download the sheet as Excel or PDF](https://qintar.app/en/sheets/workshop-production-tracker.html). For a step-by-step explanation: [Tracking orders in a gold workshop: finding the delay](https://qintar.app/en/articles/workshop-production-delays.html).

## 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.

## Related calculators

- [Gold alloying calculator: how much alloy for 21K or 18K?](https://qintar.app/en/tools/workshop-alloying.html)I have gold of a given karat: how much alloy do I add to make it 21K or 18K?
- [Craftsman account: loss, allowance and wages](https://qintar.app/en/tools/workshop-job-orders.html)How much gold did the craftsman take and return? Is the loss within the allowance? What are the wages?
- [Casting loss calculator: each batch and its allowance](https://qintar.app/en/tools/workshop-casting-batch.html)How much gold did this casting batch lose, and is it within the allowance?
- [Piece cost calculator for a gold workshop](https://qintar.app/en/tools/workshop-piece-costing.html)What does this piece cost the workshop, and what is the real cost of the work per gram?
- [Gold loss calculator for each manufacturing stage](https://qintar.app/en/tools/workshop-process-wastage.html)At which stage does the gold loss happen: casting, filing or polishing?

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