AI Matrx Logo

Quality lab

Ravenshaw Green Testing Labs · Quality lab · Dayton, OH

Rosalind Kettleby is the quality manager at Ravenshaw Green Testing Labs, an incoming inspection lab in Dayton, and every Monday she opens this to read last week's inspections, hours, defects and fees by inspection type before she plans the bench schedule.

ManufacturingReportingDrill-down4 tables · 5 views · 1 form · 2 dimension sets · 2 drill-downs · 1 digest · 1 notification · 1 agent
Use this template

Result board

Inspections
Awaiting4
IN-26-3037Birchgrove Precision TurningBP-5521
IN-26-3038Kestrel Fold Sheet MetalKF-310
IN-26-3039Oldhollow Spring CompanyOS-044
IN-26-3040Birchgrove Precision TurningBP-5521
Pass24
IN-26-3001Sorrel Creek Fastener WorksSC-4415
IN-26-3003Tallowmere CastingsTC-7002
IN-26-3004Kestrel Fold Sheet MetalKF-310
IN-26-3005Birchgrove Precision TurningBP-5521
IN-26-3010Birchgrove Precision TurningBP-5521
19 more
Conditional pass5
IN-26-3009Wrenfield HydraulicsWH-882
IN-26-3012Kestrel Fold Sheet MetalKF-310
IN-26-3026Oldhollow Spring CompanyOS-044
IN-26-3030Sorrel Creek Fastener WorksSC-4410
IN-26-3036Birchgrove Precision TurningBP-5521
Reject7
IN-26-3002Marrowdale PlasticsMP-120
IN-26-3006Oldhollow Spring CompanyOS-044
IN-26-3007Marrowdale PlasticsMP-120
IN-26-3008Sorrel Creek Fastener WorksSC-4410
IN-26-3015Tallowmere CastingsTC-7018
2 more

Tables

Inspections

40 sample rows · 13 columns

Every incoming lot a customer sends in, the check run on it and how it came out.

InspectionCustomerPartLot numberInspection typePieces sentResult
IN-26-3040Birchgrove Precision TurningBP-5521L3950Visual and cosmetic5Awaiting
IN-26-3038Kestrel Fold Sheet MetalKF-310L5495Material certificate review32Awaiting
IN-26-3039Oldhollow Spring CompanyOS-044L8566Coating thickness8Awaiting
IN-26-3037Birchgrove Precision TurningBP-5521L5747Material certificate review50Awaiting
IN-26-3035Wrenfield HydraulicsWH-890L7670Hardness test13Pass
IN-26-3034Wrenfield HydraulicsWH-890L8224Visual and cosmetic5Pass
IN-26-3036Birchgrove Precision TurningBP-5521L6691Hardness test5Conditional pass
IN-26-3032Sorrel Creek Fastener WorksSC-4415L5365Thread and torque gauge5Pass
IN-26-3033Marrowdale PlasticsMP-120L3348Material certificate review8Pass
IN-26-3030Sorrel Creek Fastener WorksSC-4410L8436Coating thickness32Conditional pass
IN-26-3031Kestrel Fold Sheet MetalKF-310L3035Hardness test20Pass
IN-26-3028Wrenfield HydraulicsWH-890L3098Dimensional check5Pass

28 more rows

Customers

7 sample rows · 7 columns

The shops and plants that send material in for incoming inspection.

CustomerCustomer codeQuality contactPhoneInspections
Birchgrove Precision TurningCU-206Tobiah Ravensworth-Ng(937) 555-0126IN-26-3005, IN-26-3010, IN-26-3011, IN-26-3020, IN-26-3029, IN-26-3036, IN-26-3037, IN-26-3040
Kestrel Fold Sheet MetalCU-203Philippa Strandquist(937) 555-0123IN-26-3004, IN-26-3012, IN-26-3031, IN-26-3038
Marrowdale PlasticsCU-205Leopoldine Vasquez-Orr(937) 555-0125IN-26-3002, IN-26-3007, IN-26-3013, IN-26-3016, IN-26-3033
Oldhollow Spring CompanyCU-207Gwendolyn Faraday-Osei(937) 555-0127IN-26-3006, IN-26-3014, IN-26-3019, IN-26-3021, IN-26-3022, IN-26-3024, IN-26-3026, IN-26-3039
Sorrel Creek Fastener WorksCU-201Imogen Dellacroce(937) 555-0121IN-26-3001, IN-26-3008, IN-26-3017, IN-26-3023, IN-26-3027, IN-26-3030, IN-26-3032
Tallowmere CastingsCU-202Barnaby Oyelaran-Vitt(937) 555-0122IN-26-3003, IN-26-3015, IN-26-3025
Wrenfield HydraulicsCU-204Lazarus Ebbinghaus-Park(937) 555-0124IN-26-3009, IN-26-3018, IN-26-3028, IN-26-3034, IN-26-3035

Parts

10 sample rows · 5 columns

The part numbers customers send in, with the material each is made of.

Part numberDescriptionMaterialCustomerInspections
BP-5521Shaft pin 12 mmTool steelBirchgrove Precision TurningIN-26-3005, IN-26-3010, IN-26-3011, IN-26-3020, IN-26-3029, IN-26-3036, IN-26-3037, IN-26-3040
KF-310Control panel bracketAluminum 5052Kestrel Fold Sheet MetalIN-26-3004, IN-26-3012, IN-26-3031, IN-26-3038
MP-120Sensor housingGlass-filled nylonMarrowdale PlasticsIN-26-3002, IN-26-3007, IN-26-3013, IN-26-3016, IN-26-3033
OS-044Compression spring setMusic wireOldhollow Spring CompanyIN-26-3006, IN-26-3014, IN-26-3019, IN-26-3021, IN-26-3022, IN-26-3024, IN-26-3026, IN-26-3039
SC-4410Hex flange bolt M10 grade 10.9Alloy steelSorrel Creek Fastener WorksIN-26-3008, IN-26-3017, IN-26-3030
SC-4415Lock nut M10 nylon insertCarbon steelSorrel Creek Fastener WorksIN-26-3001, IN-26-3023, IN-26-3027, IN-26-3032
TC-7002Pump housing castingDuctile ironTallowmere CastingsIN-26-3003
TC-7018Valve body castingBronzeTallowmere CastingsIN-26-3015, IN-26-3025
WH-882Hydraulic fitting JIC 8Stainless 316Wrenfield HydraulicsIN-26-3009
WH-890Manifold blockAluminum 6061Wrenfield HydraulicsIN-26-3018, IN-26-3028, IN-26-3034, IN-26-3035

Also included

  • Inspections by week and typeDrill-down
  • Inspection type by resultDrill-down
  • Rejected lots each MondayDigest
  • Lot receivedNotificationTells the bench a new lot has been logged.

Related templates