Job Order Costing: Cost Sheet, Example and Calculator

Job order costing accumulates costs for an identifiable order, project or batch. It suits work where the job's materials, labor and support effort can be distinguished. A custom sign, installation project or client engagement can have its own cost sheet instead of receiving the average cost of every order.

For an owner, the sheet should explain what the job consumed and which overhead was assigned. It should also preserve the difference between an estimate used for a quotation and costs recorded as work happens. A quoted price alone does not show whether the job used more labor than expected.

What goes on a job cost sheet?

Identify the job, customer, scope, dates and output unit first. Record direct materials from issue records, direct labor from approved time records and overhead using a documented allocation rule. Separate traced amounts from estimates. A job sheet can be operationally useful without pretending that every assigned cost is individually avoidable.

Job order costing formula and overhead rate

Assigned job cost = direct materials + direct labor + applied overhead. Direct labor is job hours times the selected labor rate. A common predetermined overhead rate is budgeted period overhead divided by the budgeted allocation-base quantity. Applied overhead is that rate times the job's actual base usage. Keep the same unit in numerator interpretation and job usage: a dollars-per-machine-hour rate needs machine hours, not labor dollars.

Choose the base because it represents the support activity, then document its limitations. The cost-driver guide shows how different pools can use different bases. A single overhead rate is a simplified policy, not proof that all support costs move with labor hours.

Example: a custom order of ten units

A fictional studio completes ten comparable custom display units for $3,000 net revenue. Direct materials are $1,200 after returns. Approved job labor is 30 hours at $24 per hour, so labor costs $720. The period's budgeted overhead is $6,000 over 200 direct labor hours, giving a $30-per-hour predetermined rate. The job uses 30 of those base hours, so applied overhead is $900.

The assigned-cost margin is $180 ÷ $3,000 = 6%. That figure is before any selling, administration, financing or tax items excluded from the sheet. It is not the same as contribution margin because applied overhead can include fixed commitments. Do not enter the full $282 assigned unit cost as a variable cost in a break-even calculator and then add the same fixed pool again.

For an estimate-versus-actual review, suppose the quote allowed 25 labor hours but approved records show 30. At unchanged $24 labor and $30 applied-overhead rates, five extra hours add $120 of direct labor and $150 of applied overhead, a $270 assigned-cost increase. The underlying $150 does not necessarily represent a new cash payment. Investigate rework, scope changes, travel and rate assumptions separately.

Assigned job cost is not contribution margin

In this example, $1,200 materials plus $720 traced labor equals $1,920 before assigned overhead. Revenue less those two traced amounts is $1,080. After applying $900 overhead, revenue less assigned job cost is $180. Neither subtotal automatically equals total business profit.

If the $1,920 were entirely variable and the $900 represented only a share of unchanged fixed overhead, contribution under those additional assumptions would be $1,080. The sheet alone does not establish those behaviors: direct labor can be a commitment, and an overhead pool can contain variable costs. Classify the underlying bills before using either number in a break-even or make-or-buy decision. Keep selling and administration outside this production-cost sheet while including them in the business's operating result.

Job order costing versus process costing

A custom batch can still be one job even when it contains multiple units. Conversely, a continuous standard process does not become job costing merely because invoices have order numbers. Some businesses combine approaches. Evaluate how production and services actually happen before selecting the record structure. This guide introduces the distinction; it does not calculate process equivalent units or provide a full process-cost ledger.

Where the job appears in manufacturing accounts

For a manufacturing business, production costs normally accumulate in work in process while the job is incomplete, move to finished goods when completed and enter cost of goods sold when the product is sold. A job-sheet total is therefore not automatically the current period's expense. Inventory, revenue recognition and overhead adjustments require accounting records beyond this small calculator.

A practical control is to reconcile the supporting job sheets to the work-in-process control balance at a stated date. Do not include a closed job in both unfinished and completed lists. Keep selling and general administrative period costs outside production inventory unless the applicable accounting policy actually supports a different treatment; this guide is not a substitute for preparing compliant statements.

Applied overhead versus actual overhead

Predetermined rates permit costing before all actual overhead is known. At period end, compare total applied overhead with actual overhead. In an independent example, 190 base hours at the $30 rate apply $5,700. If actual overhead is $6,200, overhead is underapplied by $500. That is a period reconciliation, not a reason to retroactively call every job's initial assignment actual cash cost.

If actual overhead were $5,400 at the same 190 hours, applied overhead would exceed it by $300. The appropriate adjustment or allocation depends on the accounting policy and materiality; the embedded tool does not post journal entries, distribute a variance among inventory accounts or certify year-end valuation. Retain both the original rate and the reconciliation.

Controls that make the sheet useful

1. Assign a unique job identifier before work begins and record approved scope changes.
2. Reconcile materials issued and returned, and separate directly traced supplies from overhead.
3. Capture actual approved time rather than copying the estimate into the actual column.
4. Use one documented rate basis and avoid duplicating payroll burden in direct labor and the overhead pool.
5. Check job status and equivalent output before calculating unit cost or comparing revenue.
6. Review estimate variances, then reconcile total applied overhead to the period's actual pool.

For a detailed service application, use the existing landscaping estimate-versus-actual guide. For the operating statement, use contribution margin presentation. These pages answer related questions while preserving their different cost boundaries.

Download the editable job cost sheet

Download the formula-based job cost sheet CSV. Import into Excel or Google Sheets, replace the labeled input rows and recalculate. Incomplete, nonnumeric or invalid inputs leave results blank. This file follows the same fictional example and stated scope as the calculator; a CSV cannot preserve spreadsheet styling.

Check the imported sheet: retain the original row positions and column-B formulas. Defaults should produce $720 direct labor, $900 applied overhead, $2,820 assigned cost and $282 per completed unit. The margin result is a decimal fraction: format 0.06 as 6%. At zero revenue the margin remains blank; zero job output or a zero overhead-base denominator is invalid. Missing inputs must not be read as zero costs.

Build an estimate-to-actual bridge without losing the original quote

Extend the original ten-unit job with a clearly labeled estimate. The quotation assumed $1,100 materials, 25 labor hours at $24 and the same $30 per labor-hour overhead rate. Estimated assigned cost was $1,100 + $600 + $750 = $2,450. Actual records in the main example show $1,200 materials, 30 hours at $24 and $900 applied overhead, giving $2,820. The assigned-cost increase is $370.

At unchanged $3,000 revenue, the estimated revenue-less-assigned-cost result was $550, or 18.3333% of revenue. The actual result is $180, or 6%. The $370 reduction reconciles exactly to the three cost changes. It is a comparison within this sheet's scope, before excluded selling and administrative items. The $150 extra applied overhead is an assignment from the rate, not automatically an additional cash bill.

Separate customer changes, rework and estimating error

Suppose approved time records classify the five extra hours as two hours for a documented customer change and three hours of internal rework. At the unchanged rates, the change accounts for $48 labor plus $60 applied overhead, or $108 assigned cost. Rework accounts for $72 labor plus $90 applied overhead, or $162. Together the $270 hours-related increase matches the labor and applied-overhead bridge above. The separate $100 material increase still needs its own price, usage or scope evidence.

Do not assume a customer owes another $108 merely because that amount appears in a cost report. Additional billing requires the agreed scope and approval terms, and the selling price need not equal assigned cost. Keep the original estimate, approved change record, revised estimate and actual cost as separate versions. If a scope change raises revenue, show that revenue bridge as well rather than attributing the entire margin change to delivery efficiency.

Record rework once. If the three hours are already on the job time sheet, adding a separate $72 rework charge to the job would duplicate labor. Likewise, materials returned to stock should reduce the job's net issues under the chosen policy rather than remain as both job usage and available inventory. Different treatment of abnormal losses requires an explicit accounting policy; the simple widget does not make that policy decision.

Close the job before using its unit cost for the next quote

Confirm accepted output, remaining unfinished work, credits, returned materials and approved time through the reporting cutoff. The original $282 cost per unit assumes ten comparable completed units. If the same $2,820 relates to only nine accepted comparable units and no work remains in process, the assigned cost per accepted unit is $313.3333. If the tenth unit is unfinished, allocating every cost to the nine accepted units may be wrong: reconcile work in process instead. The denominator is an accounting and operational boundary, not a convenient number to make the margin look better.

Do not change revenue automatically when changing output quantity. The revenue field represents recognized net revenue under the example's stated scope. Partial acceptance, refunds and billing milestones require their own records. A completed cost sheet is useful evidence for the next estimate, but one unusual job is not a universal standard for materials or labor.

Reconcile the period after reconciling individual jobs

Retain the existing $30 predetermined rate for the job comparisons. Separately, the period example applies $5,700 overhead over 190 hours and incurs $6,200 actual overhead, leaving $500 underapplied. The difference can reflect the budgeted cost pool, the activity level or both. It is not necessarily $500 of operational waste, and it is not automatically an extra charge to this one ten-unit job.

Follow the documented period-end treatment for the relevant accounts and materiality. This guide does not prescribe a journal entry or automate allocation of an overhead adjustment between work in process, finished goods and cost of goods sold. Use the cost-driver guide to examine the rate basis and flexible-budget analysis to investigate comparable activity and spending. For an industry application, retain the separate landscaping estimate-versus-actual workflow.

The existing job-cost calculator and CSV reproduce the $2,820 actual assigned total. Enter the estimate inputs to obtain $2,450, then retain both versions outside the widget; it does not store an estimate-versus-actual history, approve change orders or post inventory entries. Keep those controls in the underlying job records.

Method and sources

OpenStax explains job order versus process costing and predetermined overhead and application. All job figures, comparisons and calculator defaults above are original fictional examples.