Job costing software tells you what each customer order actually costs to produce, covering the materials used, the hours worked and the share of rent, power and equipment that the job should carry. For many small manufacturers in Egypt, the answer is currently a guess made at quoting time and corrected months later, if at all. This guide explains what a job costing system must track, how the numbers fit together and what to look for when you choose or build one.
Why job costing matters for small manufacturers
When a workshop quotes a price from memory or from the last similar job, two things go wrong. Profitable jobs are underpriced, and unprofitable ones are accepted because nobody sees the loss. The owner usually notices only when cash runs short at the end of the quarter.
Job costing fixes this by recording cost against each order while the work happens. Once you can compare the estimate with the actual cost for every job, you can adjust prices, spot wasteful processes and decide which product lines deserve more capacity.
The three cost components you must capture
1. Direct materials
Materials are the easiest cost to measure and the easiest to lose track of. Each product should have a bill of materials (BOM) that lists the sheet metal, fasteners, paint, fabric or packaging needed per unit. The job costing system then issues materials from the store against a job number, not against a general pool.
Track three things for each material issue: the job, the quantity and the cost at the time of issue. If the store releases a 3-metre sheet to Job 1047 and the system does not record it, the job will look cheaper than it is and the stock count will drift.
2. Direct labour
Labour should be recorded as timesheets tied to jobs, not as a monthly payroll total divided by output. Workers clock hours or completed units against a job, and the system multiplies these by the agreed rate. Where workers are paid by piece rate, the same logic applies: each completed piece is logged to a job and valued at the piece rate.
If your payroll already runs separately, link the two so that a worker's paid hours and job hours reconcile each week. Unexplained differences are often the first sign that a job is absorbing time it should not.
3. Overheads
Overheads are the costs that do not belong to one job: rent, electricity, supervision, equipment depreciation, maintenance and the accountant's fee. They must still be allocated to jobs, or the jobs will look more profitable than the business really is.
The most practical method is a predetermined overhead rate. Divide the expected monthly overheads by an activity measure, such as machine hours or direct labour hours, and apply that rate to each job. A simple example with illustrative numbers:
- Expected monthly overheads: EGP 300,000
- Expected machine hours per month: 6,000
- Overhead rate: EGP 50 per machine hour
- A job that uses 40 machine hours carries EGP 2,000 of overhead
Review the rate every quarter. If the actual overheads or machine hours change significantly, the rate will drift and jobs will be mispriced.
What a job costing system must do
Whether you buy a module or commission custom software, these functions separate a useful job costing system from a spreadsheet with a new name:
- Job master record: customer, product, quantity, due date, status and the quote it came from.
- Estimate at quoting time: materials from the BOM, planned labour hours and the overhead allocation, producing a margin before the job starts.
- Material issues and returns: stock movements posted to the job and reflected in inventory.
- Time and piece-rate capture: entries from the shop floor, ideally from a tablet or phone, tied to the job and the worker.
- Automatic overhead allocation: the rule applied consistently, with the rate visible to management.
- Estimate versus actual reporting: variance by material, labour and overhead for each completed job.
- Link to invoicing and accounting: the final cost feeds the general ledger, and the invoice references the same job.
Estimate versus actual: the table that changes decisions
The variance report is where job costing pays for itself. It should show each completed job side by side with its estimate, so you can see where the error came from.
| Cost element | Estimated | Actual | Common cause of variance |
|---|---|---|---|
| Materials | Per BOM | Per store issues | Scrap, unrecorded issues, substitutions |
| Labour | Planned hours | Timesheet hours | Rework, waiting time, unclear drawings |
| Overheads | Rate times planned activity | Rate times actual activity | Jobs running longer on the same machines |
Over several months, the pattern shows which products are underpriced, which BOMs are out of date and which workers or machines are slowing production. That is information you cannot get from a monthly profit figure.
Off-the-shelf or custom?
Many accounting packages offer basic job or project costing. They work well when your jobs are simple and your shop floor data entry is light. They struggle when you need shop-floor time capture, piece-rate payroll, multiple warehouses or a custom quoting engine.
A custom build makes sense when your production process is specific, when you already use several disconnected tools, or when you need the job costing to feed a quote form and a client invoicing portal. Our ERP system service covers job costing as one module that connects to inventory, payroll and accounting, so the cost of a job flows into the rest of the business without re-entry. For a similar build in a field-heavy business, see our Earth Movers ERP project, which ties equipment, work orders and payroll together in one system.
If you are weighing options, the practical test is this: can you produce an estimate for a new job in under an hour, and can you show the actual margin for last month's jobs by Friday? If not, your current process is costing you money you cannot see.
Common mistakes to avoid
- Recording only material costs: labour and overheads are often larger than materials in small workshops.
- Using stale BOMs: a product changed by one component should trigger a BOM update before the next quote.
- Allocating overheads by revenue: this hides the cost of machine-heavy jobs that earn less per hour.
- Waiting for month-end: job costs are most useful while the job is still open, when you can still change the price or the process.
Where to start
Pick your ten best-selling products and write down their BOMs. Then track one month of material issues and labour hours against each job. Compare the result with the prices you quoted. That short exercise will show you whether you need a simple spreadsheet, a configured module or a custom system. If you want a second opinion on the scope, contact our team with your product list and monthly job volume, and we will tell you what a realistic first version would include. You can also read our other guides in the Narmar blog on ERP implementation and go-live planning.
