Miller1 WIP Dashboard
Live operational WIP from SQL. Repair order drilldown includes jobs, labour lines, and parts.
WIP Count
7
Required Labour Hrs
93.8
Jobs
12
Order Total
$16,696.73
Labour Sale
$15,078.00
Parts Sale
$1,618.73
Labour Lines
13
Part Lines
12
| RO | Phase | Status | Customer | Vehicle | Promise | Labour | Sales | Lines | |
|---|---|---|---|---|---|---|---|---|---|
|
#2
Vehicle ID 2
|
RO |
Waiting for Pick up
|
Tester Testing |
2024
VIN: 3C6TR5CJXRG317889
|
2026-06-30 5:00 PM
Sched: 2026-06-19 9:04 AM
In: 2026-06-19 9:42 AM
|
38 hrs
3 jobs
|
$5,467.69
Labour: $4,755.00
Parts: $712.69
|
Labour: 4 Parts: 4 |
Details |
|
#9
Vehicle ID 4
|
EST |
Waiting For Approval
|
2010
VIN:
|
2026-06-23 5:00 PM
Sched: 2026-06-23 4:59 PM
|
0 hrs
2 jobs
|
$0.00
Labour: $0.00
Parts: $0.00
|
Labour: 0 Parts: 0 |
Details | |
|
#8
Vehicle ID 2
|
RO |
Waiting For Tech.
|
Tester Testing |
2024
VIN: 3C6TR5CJXRG317889
|
2026-06-23 5:00 PM
Sched: 2026-06-23 12:15 PM
In: 2026-06-23 12:16 PM
|
0 hrs
1 jobs
|
$209.00
Labour: $0.00
Parts: $209.00
|
Labour: 0 Parts: 2 |
Details |
|
#6
Vehicle ID 2
|
INV
Invoice Printed
|
Waiting For Service
|
Tester Testing |
2024
VIN: 3C6TR5CJXRG317889
|
2026-06-23 5:00 PM
Sched: 2026-06-23 11:45 AM
In: 2026-06-23 11:48 AM
|
0 hrs
1 jobs
|
$180.00
Labour: $0.00
Parts: $180.00
|
Labour: 0 Parts: 2 |
Details |
|
#4
Vehicle ID 3
|
RO |
Waiting For Parts
|
InnerCity Diesel |
2022 MP8055
VIN: MP8055
|
2026-06-22 5:00 PM
Sched: 2026-06-22 4:34 PM
|
24 hrs
1 jobs
|
$4,440.00
Labour: $4,440.00
Parts: $0.00
|
Labour: 3 Parts: 0 |
Details |
|
#3
Vehicle ID 1
|
RO |
Waiting For Service
|
Darren Henderson |
1992
VIN: 1G2FW238XNL207950
|
2026-06-19 5:00 PM
Sched: 2026-06-19 9:30 AM
In: 2026-06-19 9:36 AM
|
9.8 hrs
2 jobs
|
$2,330.04
Labour: $1,813.00
Parts: $517.04
|
Labour: 5 Parts: 4 |
Details |
|
#1
Vehicle ID 1
|
RO |
Customer Waiting
|
Darren Henderson |
1992
VIN: 1G2FW238XNL207950
|
2026-06-10 5:00 PM
Sched: 2026-06-10 11:30 PM
In: 2026-06-10 10:57 PM
|
22 hrs
2 jobs
|
$4,070.00
Labour: $4,070.00
Parts: $0.00
|
Labour: 1 Parts: 0 |
Details |