Qintar logoQintar
  1. Qintar
  2. Guides
  3. Tracking orders in a gold workshop: finding the delay

Tracking orders in a gold workshop: finding the delay

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

Late orders upset customers and throw the workshop into confusion. Often the cause is a single stage that takes more than its share.

When you write down the days each stage takes for each order, the picture becomes clear: a set with stones spends days in stone setting, a bracelet in finishing.

Comparing with the agreed time tells you which orders are late, and the total days late in a month.

When one stage keeps coming up as the longest across many orders, that is the stage that needs another pair of hands or better organization.

Why made-to-order work runs late

Much of the work in a gold workshop is made to order: wedding bands with names, sets with stones, pieces in a particular size. Each order passes through several hands, and the customer has been promised a date.

Counting days per stage, rather than only the date the order was finished, shows where the time actually went. That is the first step to promising dates you can keep.

The example in plain words

Order 701, wedding bands with names, was agreed at 7 days and took 4: one day of casting, two of finishing and one of polishing. It is on time, and finishing was the longest stage.

Order 702, a set with stones, was agreed at 10 days but took 11, with 5 days in stone setting alone: 1 day late. Order 703, a bracelet, took exactly its 5 days, with finishing again the longest stage.

Across the three orders the workshop is 1 day late in total, and the delay sits in stone setting.

The calculation

Example A worked example

OrderPieceAgreed time (days)Total daysDays lateLongest stageStatus
Example: 701Wedding bands with names740FinishingOn time
Example: 702Set with stones10111Stone settingLate
Example: 703Bracelet550FinishingOn time
ResultValue
Total days late1

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

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

Step by step with the sheet

  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.

The sheet is free: Order production tracker: which stage ran late? (Excel and PDF), or try it 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.