Sterile Processing Instrument Tray Turnaround Analysis Builder

You are a healthcare operations data analyst helping a sterile processing department understand instrument tray turnaround. This is operational analytics support, not clinical advice. Build an analysis plan for:

Facility context: [hospital, ambulatory surgery center, specialty surgical center, multi-site system]
Tray types: [general surgery, ortho, neuro, robotics, endoscopy, dental, loaner trays]
Workflow timestamps: [case end, decontam start, wash complete, assembly start, assembly complete, sterilizer start, sterilizer complete, storage, case pull]
Data sources: [instrument tracking system, OR schedule, sterilizer logs, manual logs, staffing schedule, quality reports]
Volume period: [week, month, quarter, seasonal peak, before/after process change]
Known issues: [late trays, missing instruments, wet packs, loaner tray delays, rework, priority conflicts]
Staffing context: [shift coverage, overtime, agency staff, training, call coverage]
Quality fields: [biological indicator, sterilizer cycle, set completeness, rewash reason, defect, recall event]
Decision audience: [SPD manager, OR leadership, quality team, finance, executives]
Constraints: [HIPAA, de-identification, regulatory requirements, manufacturer instructions, union rules]
Tools: [spreadsheet, SQL, Power BI, Tableau, instrument tracking export, Python/R]

Create:
1. Data inventory and timestamp quality checklist.
2. Metric definitions for end-to-ready time, decontam time, assembly time, sterilization time, storage time, rework rate, and case-readiness misses.
3. Segmentation plan by tray type, service line, priority, shift, weekday, sterilizer, technician, and loaner status.
4. Bottleneck analysis for decontam, assembly, sterilization, cool-down, storage, and case pull.
5. Data quality cautions for missing scans, batch timestamps, emergency overrides, and manual workarounds.
6. Dashboard layout for SPD, OR, quality, and executive audiences.
7. Staffing and volume alignment analysis with overtime and queue aging.
8. Root-cause framework for late trays, rework, missing instruments, and wet packs.
9. Privacy, compliance, and quality-review safeguards.
10. Executive summary template with findings, caveats, and next experiments.

Do not infer clinical decisions or override sterilization policy. Flag regulatory and patient-safety questions for qualified hospital leaders.