Direct cost
$66,665
Bid price
$86,091
Margin in bid
14%
Construction Cost Estimate
Itemised estimate by trade with quantities, unit rates, markup and contingency.
12 free cost expense templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 12 spreadsheets from Estimates & Bids, Specialized Inventory and Home Buying & Selling. Start with Construction Cost Estimate, Bill of Materials & Product Cost Sheet and Home Purchase Cost Planner: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Direct cost
$66,665
Bid price
$86,091
Margin in bid
14%
Itemised estimate by trade with quantities, unit rates, markup and contingency.
Cost per unit
$8
Gross margin
45%
Price for target margin
$19
List every component of a product with quantity, waste and cost to get a true unit cost and margin.
Cash needed in total
$56,854
Paid so far
$2,024
Still to pay
$54,830
Everything buying a home costs beyond the price: deposit, fees, moving and set-up, with paid and still to pay.
Budget
$621,000
Forecast at completion
$617,356
Projected over (−) or under budget
$3,644
Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.
Total labour cost
$1,843,105
Salary cost
$1,565,986
Taxes and benefits
$277,119
Forecast salary, employer taxes and benefits for every role by month and department, including new hires, leavers and merit.
Internal costs
$72,300
External costs
$59,050
Total hires
25
Add up internal and external recruiting costs, allocate shared costs and calculate cost per hire by role family.
Total costs
$687,000
Total benefits
$1,457,000
PV of costs
$613,577
Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.
Average shipping cost
$30
Net margin on shipping
-$146
Parcels billed on dim weight
3
Work out dimensional weight, billable weight and zone-based shipping cost per parcel, and see your margin on shipping charged.
Hours this period
97.5
Overtime share
10%
Labour cost
$5,247
Daily crew hours by worker and cost code with regular and overtime pay, labour burden, and hours against budget for every code.
Products
11
Average pour cost
20%
Above target
2
Cost per pour and pour cost % for every bottle and keg, weekly usage from counts, and variance against what the POS says you sold.
One-time costs
$53,300
Monthly costs
$13,090
Total funding needed
$151,616
Estimate one-time and monthly costs to launch and how much funding you need.
Trip total
$3,065
Share per person
$766
Expenses logged
8
Log who paid for what on a shared trip and see exactly who owes money and who is owed.