DataBrosFTW.
Sample — illustrative numbers

The Shop Friday Report

Week of Aug 10–16 · prepared for the owner of a ~$6M precision machine shop running defense work (fictional). Built from the shop system, the quality log, and QuickBooks. Every Friday at 4pm — nobody stays late compiling it.

Three things that need you this week

Make the 8am call to the anodize vendor — WO-4118's Aug 21 date holds only if the truck arrives Wednesday.Serious · ~$7,000

The vendor has slipped once already; the PO is attached. At the week's average lot value (~$7,000), that ship is what's riding on the call.

Confirm Lot 4126-B's traceability cert is filed in the lot record — it was missing at final inspection.Watch · ~$103K

The report caught it before pack-out; the cert is now scanned and attached. WO-4126 (ITAR) carries roughly a quarter of the $412,000 on the floor.

Take the freight miss up with the carrier before next week's bookings — the one true miss wasn't the shop.Watch · ~$6,600

Without the 4126-B catch, on-time would have read 89% this week. The lot the carrier delivered late is worth ~$6,600 at the week's average.

The week in four numbers — with the eight weeks behind them
$118,400▲ 6% shipped this week 8-wk shipped
94%▬ −2 pts on-time delivery (17 of 18 lots) 8-wk on-time
$412,000▲ 5% work in process on the floor 8-wk WIP
100%▬ 0 compliance evidence items current — 0 overdue 8-wk compliance
Work orders — due dates against the floor, margins from actuals
Work orderQtyDueMargin 25% targetStatus
WO-4118 · pump housings240Aug 21
31%
at anodize — see item 1 above
WO-4121 · actuator brackets480Aug 28
27%
in machining, on plan
WO-4126 · valve bodies (ITAR)120Sep 4
34%
material certs logged at receiving — see item 2 above
WO-4130 · repair kits60Sep 11
22%
quoted thin to keep the cell loaded
Compliance log — the upkeep, tracked like a job instead of a memory
Evidence itemLast doneNext dueStatus
Quarterly access reviewAug 8Nov 7done, filed
Security awareness training14 of 15Aug 221 new hire outstanding — reminder sent
Media & backup lognightlycurrent, checked automatically
Visitor log exportAug 15Aug 22files itself weekly
The floor — 900 pieces across four work orders
480WO-4121 · MACHINING
240WO-4118 · ANODIZE
120WO-4126
60WO-4130
  • $412,000 of work in process sits behind these four orders.
  • WO-4118's 240 housings are out at the anodize vendor (item 1).
  • WO-4126's material certs logged at receiving; 4126-B cert re-attached (item 2).
On-time — 18 lots shipped
17 on time · dark1 late · amber

The one late lot — ~$6,600 at the week's average — was the freight carrier, not the shop (item 3). Without the 4126-B cert catch, this bar would have read 89% (item 2).