How to use Project Cost and Profit Worksheet
- Enter Estimated job revenue and Actual job revenue in one currency, then replace the sample Job costs with your own lines.
- Choose labour, materials or overhead for each group. Supply a description and both estimated and actual quantity/rate pairs. For a fixed cost or allocated overhead amount, use quantity 1 and put the total in its rate.
- Select Calculate result. Each quantity × rate rounds to cents before totals. Cost variance is actual cost minus estimated cost; a positive value means the cost exceeded its estimate.
- Review Profit, Actual profit margin and Actual markup separately. Margin divides actual profit by actual revenue; markup divides it by actual cost. A zero denominator is shown as undefined.
- Download calculation.csv for all cost lines and summary rows. The worksheet does not create invoices or retain a reusable project.
Example: Project Cost and Profit Worksheet
Estimated costs are $1,600 labour + $1,200 materials + $500 overhead = $3,300. Actual costs are $1,800 + $1,300 + $500 = $3,600, a $300 overrun. Actual revenue of $5,200 leaves $1,600 job profit.
Supported inputs and limits
- Use 1 to 100 cost lines and at most 100,000 characters.
- Each pipe-separated row needs six values; descriptions allow 80 characters and the group must be labour, materials or overhead.
- Quantities, rates and revenue are nonnegative and at most 1,000,000,000 each.
- Use plain decimals with up to 12 decimal places, without grouping commas or currency symbols.
- Estimated and actual line costs round half up to cents before totaling, as do the two revenue inputs.
More details
Margin and markup display four decimal places; they are undefined at zero revenue and zero cost respectively.
Negative profit is allowed as a result even though input costs and revenues are nonnegative.
Use one currency and compatible quantity/rate units per row.
Enter allocated overhead yourself.
Tax, financing, cash timing and revenue-recognition rules are not calculated.
CSV is a result record, not a complete editable project.
Processing is local without automatic saving.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Project Cost and Profit Worksheet
How should I enter a fixed overhead allowance?
Use quantity 1 and the total allowance as its rate. The worksheet does not choose an overhead allocation method for you.
What does positive cost variance mean?
Actual cost minus estimated cost is positive, so spending exceeded the estimate. A negative variance means actual cost was lower.
Why are margin and markup different?
Profit margin divides profit by revenue. Markup divides profit by cost. A zero denominator is shown as undefined rather than as a misleading percentage.