================================================================
  CREW COST DASHBOARD — by FieldTimesheet
  Free download from fieldtimesheet.com/templates/crew-cost-dashboard
================================================================

Thanks for downloading the Crew Cost Dashboard. This bundle contains
4 spreadsheets that work together to give you full visibility into
your crew's labor costs, job profitability, and monthly P&L.


FILES IN THIS BUNDLE
--------------------

  01-crew-roster.csv
    Your crew's info, rates, and fully loaded costs.
    Fill this out first — other tabs reference these rates.

  02-weekly-hours.csv
    Copy this tab every week. Enter daily hours per worker.
    Calculates regular pay, overtime, and total labor cost.

  03-job-cost-summary.csv
    One row per active job. Track estimated vs actual costs
    for labor, materials, and subs. See profit margin per job.

  04-monthly-pl.csv
    Revenue and expenses by month. Pull labor costs from
    Tab 2 totals and job costs from Tab 3.


HOW THEY CONNECT
----------------

  Crew Roster → rates feed into → Weekly Hours
  Weekly Hours → labor totals feed into → Job Cost Summary
  Job Cost Summary → project costs feed into → Monthly P&L

  Update in this order: Roster (when rates change) → Weekly Hours
  (every Friday) → Job Costs (weekly) → P&L (monthly).


TIPS
----

  - All files include sample data. Delete sample rows and enter
    your own — the structure and formulas will guide you.

  - The "Fully Loaded Rate" in the Crew Roster is your TRUE labor
    cost. It includes workers comp and burden (payroll taxes,
    benefits, admin). Most contractors underbid because they use
    the hourly rate instead of the loaded rate.

  - Open all 4 files in separate tabs in Excel or Google Sheets
    so you can cross-reference easily.


WHEN YOU OUTGROW THIS SPREADSHEET
----------------------------------

  These spreadsheets work. But they have limits:

  - Someone has to COPY the weekly hours tab every Friday
  - Someone has to RE-TYPE all of it into QuickBooks
  - Job costs are always a week behind reality
  - There's no mobile option for your crew in the field
  - Errors compound — one wrong cell breaks downstream math

  FieldTimesheet replaces all 4 of these spreadsheets with:

    * One-tap mobile clock-in for your crew
    * Automatic QuickBooks sync (hours flow as TimeActivities)
    * Real-time job costing (not last week's numbers)
    * GPS verification (know they're on the jobsite)
    * No copying, no re-typing, no lost timesheets

  Try it free for 14 days — no credit card required.
  https://fieldtimesheet.com/signup


================================================================
  Questions? Visit fieldtimesheet.com or call (682) 587-9876
================================================================
