Which jobs make money?
You're busy all year, but you can't see which jobs paid you and which ones cost you.
This sheet costs you about $9,900 a year
JOBS_2024_master_v4_USE THIS ONE.xlsx
| A · Job | B · Bid | C · Labor | D · Materials | E · Equip/Trucking | F · Profit? | |
|---|---|---|---|---|---|---|
| 1 | Oak St Parking Lot | 48,500 | 14,200 | 21,800 | ??? | prob ok |
| 2 | Harbor Rd Patch | 22,000 | waiting on payroll | 16,400 | 3,100 | #REF! |
| 3 | Miller Driveway | 9,800 | 3,900 | 3,200 | 800 | good |
| 4 | Fairview Apt Lot | 61,200 (old bid) | 22,500 | receipts in truck | 5,400 | |
| 5 | Elm Ave Overlay | 35,000 | 11,000 | 14,700 | 4,200 | #REF! |
| 6 | ||||||
| 7 | ||||||
| 8 |
- That sheet costs you
- $9,900/yr
- Time back
- 3 hrs/week
- Each job's profit
- Known at close-out
The math: 3 hrs/week × 1 person × 50 weeks × $60/hr = $9,000, plus 10% for mistakes and rework = $9,900/yr.Starting point: A few hours a week piecing together receipts and hours per job, plus jobs underbid again because nobody saw the last one lose money. Adjust it to match your shop.
- One place for every cost. Labor, materials, and equipment go in against the job, not into three different piles of paper.
- Profit shows as you type. No formulas to break. Bid minus actual cost, and the margin, update live.
- Winners and losers, side by side. Every closed job sits in one list, so you can see which kinds of work lose money.