Owner

Shop dashboard

RFP 3.2

Dave Bell · ASE Master · AERA member. The numbers you already manage against, in the language you already use.

Period

Showing Jul against Jun. Posted repair orders only.

Car count

198

-6.2% vs Jun

ARO

$983.70

-1.4% vs Jun

Close ratio

79.1%

-2.3% vs Jun

Comeback rate

3.1%

down from 4.2%

Total sold

Posted repair orders · trailing six months

$168k

Feb

$184k

Mar

$177k

Apr

$199k

May

$210k

Jun

$195k

Jul

Sold revenue by month. Written but unsold work is not shown here.

Close ratio

Approved against presented · trailing six months

Feb78.4%Mar79.6%Apr78.2%May80.0%Jun81.0%Jul79.1%

Share of presented work the customer approved.

Hours presented

830.8

-4.2% vs Jun

Hours sold

657.2

-6.4% vs Jun

Accounts receivable

What is owed, by age

Current
$18,420.50
1–30 days
$9,640.00
31–60 days
$3,180.25
61–90 days
$1,240.00
90+ days
$640.00

Total outstanding $33,120.75.

What is stuck

Nothing is moving on these

#4471 2015 Chevrolet Tahoe LT
Denise Alvarez
Waiting on Parts
#4469 2020 Ram 3500 Tradesman
Wasatch Landscaping (Fleet)
On Hold

These statuses exist in your board today and never reach the customer. That is the same gap the customer status screen closes.

Effective labour rate & gross profit per hour

Jul · every column derived from car count, ARO, close ratio and labour rate

Month	Car count	Total written	Total sold	ARO	Eff. labour rate	GP / hr
Jul	198	$246,235.90	$194,772.60	$983.70	$154.10	$164.54