Getting Started
This Fleet Job Cost Analysis tool has four tabs. Work through them in order for best results:
- Job Inputs — Enter your project name, client, dates, contract value, overhead rate, and target margin. All blue fields accept user input.
- Cost Breakdown — Add each line-item cost with a budgeted and actual amount. Use the "+ Add Row" button to expand the table.
- Dashboard — View your KPI summary, waterfall chart, cost distribution, and detailed variance table.
- Click ↻ Recalculate (top right or at the bottom of each input tab) after making changes.
Metric Definitions
Load Revenue
The total value agreed with the client, including any approved change orders.
Budgeted Cost
Sum of all estimated line-item costs plus overhead allocation.
Actual Cost
Sum of all actual spend entered in the Cost Breakdown tab.
Net Profit
Load Revenue minus Actual Cost (including overhead). Positive = profitable.
Profit Margin %
Net Profit ÷ Load Revenue × 100. Compare to your Target Margin in Inputs.
Variance
Budgeted Cost minus Actual Cost. Positive (green) = under budget. Negative (red) = over budget.
Overhead Rate
Applied as a % on top of direct costs to account for indirect expenses (admin, equipment, insurance).
Retainage
% of contract value held back by the client until project completion.
Color Guide
- ■ Green — Under budget / profitable
- ■ Red — Over budget / loss
- ■ Amber — Within 5% of budget (watch closely)
- ■ Blue — Informational / neutral
- Blue cell — User input field
Tips
- Use the Phase dropdown on each line item to group costs by project stage.
- Include overhead as a separate line item or use the Overhead Rate in the Inputs tab — not both.
- Use the Print Report button to generate a PDF of the dashboard for client or management review.
- The tool runs entirely in your browser — no data is sent anywhere. Save your work by using File → Save As in your browser, or keep this HTML file on your desktop.
💾 Your Data & Privacy
All project data is saved locally on your device and browser. EasyTrucking does not store, access, or back up your data. You are solely responsible for maintaining your own backups.
To back up your data:
- Use the ⬇ CSV Export button on any tab to save your data as a spreadsheet
- Or duplicate the HTML file after saving — the file contains your saved data
- Store backups in a safe location such as Google Drive, Dropbox, or an external drive
Browser Compatibility Note:
This tool works best in Firefox, Chrome Incognito, Safari, and Edge. If you experience slow performance or invisible input fields in Chrome, it is likely caused by a browser extension such as Grammarly, a password manager, an ad blocker, or a dark mode extension.
- To test without extensions: open Chrome and press Ctrl+Shift+N (Windows) or Cmd+Shift+N (Mac) for Incognito mode
- To find the problematic extension: go to chrome://extensions and disable them one by one
- For best experience: use Firefox or Chrome Incognito
⚠ Clearing your browser cache or using a different browser will result in loss of saved data. EasyTrucking accepts no liability for lost or corrupted data.