Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Order production tracker: which stage ran late?

Order production tracker: which stage ran late?

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 KBDownload Excel61 KB

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.

Preview of the first page of the "Order production tracker: which stage ran late?" sheet, with the table and the worked example

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

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.

The calculation

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

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.

More free sheets

All free sheets