Basis & caveats: "Gross profit" is contribution before fixed overhead (rent, utilities) and card-processing fees — not net profit. Service contribution charges all staff wages for the day against service revenue, including time on non-billable tasks. Retail COGS uses each item's landed cost as a proxy; item margins are close estimates, not penny-exact.
Employee Performance & Hours
Employee
Sales
Revenue
Avg Ticket
Hours
Wage Cost
Clock-in
Tech A
8
$1,518.39
$189.80
6.71
$228.14
✓ Clocked
Owner Owner
4
$752.90
$188.23
—
$402.16*
Salary · exempt
Tech B
4
$633.26
$158.32
8.50
$280.50
✓ Clocked
*Owner wage cost is allocated salary, not a clocked figure. No clock-in exceptions — both hourly staff clocked in; salaried owner is exempt per payroll rules.
Service Department Snapshot
Open WO Age Distribution (64 open)
0–3 days16
4–7 days11
8–14 days11
15–30 days18
30+ days8
Industry best-practice is 1–2 day turnaround. 8 WOs aged 30+ days — oldest is 1,527 days (avg 346d in that bucket). 26 WOs sit at 15+ days; worth a queue sweep.
Top Open Statuses
Finished (awaiting pickup/pay)
16
Waiting — On Customer
9
Waiting — Parts on Order
8
MGT Requested Review
6
Order Parts
5
Waiting — OOS Parts Needed
4
Open
3
Tech-assigned
3
16 Finished orders await customer pickup/payment — collectible revenue sitting in the rack.
Items Sold Today — Margin & Inventory Alerts
Retail SKUs with revenue, COGS (units × landed cost), gross margin, and reorder status. Labor lines are summarized in the P&L above. Margins are estimates vs exact at-sale cost.
Item
Units
Revenue
COGS
Margin
%
Status
DT Swiss HE 1800 Front Wheel 700 12x100
1
$347.66
$222.01
$125.65
36.1%
New item — weekly analysis
Jagwire Sport Disc Brake Pads (Single)
8
$150.00
$56.25
$93.75
62.5%
OK — covered by box reorder
Schwalbe Pick-Up Tire 26x2.35 E-50
3
$132.50
$79.73
$52.78
39.8%
New item — weekly analysis
CLARKS Disc Rotor 6B CLE-180 2.3mm
4
$112.50
$40.46
$72.04
64.0%
Reorder — below ROP (~19/20)
CST Big Boat Tire 26x4.0
1
$93.75
$40.61
$53.14
56.7%
New item — weekly analysis
Aftermarket Rad Runner Headlight
3
$85.00
$44.98
$40.02
47.1%
New item — weekly analysis
Shimano Chain CN-HG901-11
1
$80.00
$60.03
$19.97
25.0%
OK (QOH ~8)
Shimano 105 CS-R7000 Cassette 11-32t
1
$71.24
$57.31
$13.93
19.5%
New item — weekly analysis
Shimano CL Rotor GRX SM-RT64 160mm
1
$50.00
$33.25
$16.75
33.5%
New item — weekly analysis
26 x 4.0 Schrader Tube
1
$37.50
$12.50
$25.00
66.7%
OK (QOH ~13)
12 x 1.75-2.25 Tube, Angled Valve
1
$12.50
$10.68
$1.82
14.6%
New item — weekly analysis
Teravail Presta Tube 700x20-28C
1
$12.49
$5.19
$7.30
58.5%
OK (QOH ~13)
Teravail Schrader Tube 26x1.75-2.35
1
$12.49
$5.00
$7.49
60.0%
OK (QOH ~23)
Slick SS MTB Brake Cable (single)
1
$6.24
$3.31
$2.93
46.9%
OK (QOH ~115)
Retail total
28
$1,203.86
$671.30
$532.56
44.2%
Margin flags: The two Shimano SKUs and the small tube are the thin ones — Shimano cassette 19.5%, chain 25.0%, house-brand tube 14.6%. Worth a price/cost check. Best margins: tubes & the CLARKS rotor (60–67%).
Reorder: CLARKS CLE-180 rotor dropped below reorder point — small top-up needed.
Several SKUs aren't in the velocity cache yet (Saturday's deep-dive will add them).
Payment Mix
Credit Card100%
Credit Card
19 charges
$3,952.71
All tendered payments were credit card. Gross tendered exceeds net day revenue because it includes work-order deposits and tax across multiple tickets. Card-processing fees (~2.6%, est. ~$75–100) are not yet subtracted in the P&L above.
New Customers
CRM Intake (created)
6
4 w/ email · 4 w/ phone
First Purchases
8
$1,206.84 · avg $150.86
8 first-time buyers converted today ($1,207 in first-purchase revenue). 2 of the 6 new records are missing both email and phone — a CRM data-quality gap worth a quick fix at the counter.
Open Special Orders
125 open special orders — many are severely stale "Ready For Pickup" items never collected. Showing the 12 oldest.
SO#
Age
Status
Customer
Item
Vendor
10590
4,732d
Ready For Pickup
Customer A
Avid G2 Clean Sweep 160mm Rotor
QBP
10790
4,705d
Ready For Pickup
Customer B
(item not resolved)
—
15329
4,299d
Ready For Pickup
Customer C
Hotrock 20 6spd Street
Specialized
32682
2,459d
Ready For Pickup
Internal Account
Zipp SL Speed Road Stem 100mm
QBP
32681
2,459d
Ready For Pickup
Internal Account
Shimano Ultegra 6800 50t Chainring
Shimano
32683
2,459d
Ready For Pickup
Internal Account
Shimano Road Optislick Cable/Housing Set
Shimano
32732
2,445d
Ready For Pickup
Internal Account
Shimano Ultegra 6800 34t Chainring
Shimano
32802
2,424d
Ready For Pickup
Internal Account
Lezyne Lite Drive 1000XL
QBP
32989
2,351d
Ready For Pickup
Internal Account
Wahoo KICKR Core Smart Trainer
Wahoo
32942
2,326d
Ready For Pickup
Internal Account
Stan's NoTubes Dart Tool
QBP
33699
2,208d
Ready For Pickup
Internal Account
Muc-Off Bike Care Kit
QBP
33697
2,208d
Ready For Pickup
Internal Account
Muc-Off Drivetrain Brush
QBP
Recommendation: These are an aged ledger, not live demand. A one-time cleanup — close/write off the internal-account backlog and the 4,000+ day stale orders — would make the open-SO count actionable again.