Star Fleet — Night Shift Dashboard v2

Window: last 30 days Generated: 2/4/2026, 3:55:43 PM PT Billing days captured: 9
Total ROs
410
Across 28 nights
Completion rate
96.8%
397 complete / 13 incomplete
Collected (billing)
$76,063.48
From 3pm billing reports
Collected per completed RO
$191.60
(Collected $) / (Completed ROs)

Blockers (nights flagged, last 30d)

Access / keys
4/28
Parts issues
8/28
Tools / scanner
7/28
Time overrun
4/28
Not onsite / not found
0/28
These are keyword signals from dispatcher notes. Next step: tag blockers per RO (not just per night).

Repeat / stuck ROs (last 30d)

RO#AppearancesNotes
64773 nightsLast seen 2026-01-30
65283 nightsLast seen 2026-01-29
65963 nightsLast seen 2026-01-28
65223 nightsLast seen 2026-01-29
65673 nightsLast seen 2026-01-30
65452 nightsLast seen 2026-01-23
63622 nightsLast seen 2026-01-23
65812 nightsLast seen 2026-01-23
65522 nightsLast seen 2026-01-29
65832 nightsLast seen 2026-01-28
64182 nightsLast seen 2026-01-26
65252 nightsLast seen 2026-01-30
65512 nightsLast seen 2026-01-27
66052 nightsLast seen 2026-01-27
65442 nightsLast seen 2026-01-28
These are the highest-ROI targets: every repeat RO creates churn and delay.

Money (last 30d)

MetricValue
Collected$76,063.48
Approved total (workable + not)$212,022.49
Workable pre-approved$114,539.04
Not-workable pre-approved$97,483.45
Billing days captured9
If billing days captured is low, money totals are partial.

Mechanics — hours worked (last 30d)

TechHoursUnits
Aidan Burk116.25hrs
Alex Rodriguez104.18hrs
Alex Franco55.33hrs
Adoni Cerrato42.50hrs
Matt Sommerfeldt30.08hrs
Jennifer Walters21.17hrs
Clock-in/out hours from the night report roster (useful as denominator).

Mechanics — billable output (last 30d)

TechCombined hrsClocked hrsCombined/Clocked$ total$ / clockedRows
ALEX F.33.624.61.37$7,718.90$314.034
ALEX R.63.547.41.34$13,568.05$286.137
AIDAN47.736.21.32$18,233.21$503.547
ADIAN9.37.41.26$160.00$21.621
ADONI16.813.41.26$7,465.71$558.392
JEN5.75.80.99$1,164.51$202.521
JAYDEN11.111.30.98——2
JENN7.47.80.95——1
MATT19.430.70.63$941.41$30.624
JENNIFER6.016.70.36$531.31$31.762
Combined = Billed + Produced from the 3pm billing report. $ fields may be missing on some days; rows shows how many billing reports contributed.

Next actions (profit-first)

  1. Repeat RO kill list: assign an owner to the top 10 repeats and clear them (parts/approval/key/diag).
  2. Parts accuracy loop: log every wrong/missing part by RO + vendor + ordered-by and review weekly.
  3. Keys/access compliance: simple rule + escalation when keys are missing at dispatch time.
Generated from the collected night emails + billing reports. This HTML is read-only and shareable.