1. Executive Summary & Core Purpose
The Job Turnaround Analytics dashboard provides real-time and historical visibility into Soundbox's sales cycle velocity, quoting lead times, and operational prep runways. By monitoring the exact velocity at which quotes transition from initial inquiry creation (Inquiry) to confirmed bookings (Confirmed), Soundbox executives, sales leadership, and warehouse operations can:
- Measure Sales Velocity: Identify how rapidly prospective deals convert into committed bookings across account managers and service tiers.
- Eliminate Quoting Bottlenecks: Pinpoint whether deals spend excessive time in initial client review (Inquiry → Tentative) or languish as tentative inventory holds (Tentative → Confirmed).
- Protect Warehouse Operations: Calculate the Prep Runway (lead time between confirmation and gear prep start) to prevent last-minute warehouse crunches and equipment scrambles.
- Drive Accurate Forecasts: Use 2+ years of historical conversion benchmarks (2,360+ jobs) to predict cash flow and equipment availability.
2. Executive KPIs & Metric Definitions
Median Turnaround
13.2 Days
Calendar days from initial quote creation directly to Confirmed status. Resilient to extreme outliers.
Average Turnaround
22.4 Days
Mean calendar duration across all closed jobs. Reflects enterprise long-tail quotes.
Median Prep Runway
14.0 Days
Lead time given to the warehouse between booking confirmation and prep start date.
Fast Conversion Rate
38.4%
Percentage of total jobs confirmed in 7 days or less from quote creation.
| Metric Name |
Calculation / Source |
Operational Significance |
Target Benchmark |
| Median Turnaround |
Confirmed Date − Inquiry Date (50th percentile) |
The true representative sales turnaround time. Unlike averages, median is unaffected by rare quotes opened 6 months in advance. |
≤ 14 Days |
| Average Turnaround |
Σ(Turnaround Days) ÷ Total Volume |
Useful for evaluating macro annual trends and comparing team-wide sales velocity quarter over quarter. |
≤ 21 Days |
| Median Prep Runway |
Prep Start Date − Confirmed Date |
Measures warehouse safety buffer. A runway under 3 days triggers emergency pull schedules and overtime risk. |
≥ 7 Days |
| Fast Conversion % |
(Jobs ≤ 7 Days ÷ Total Jobs) × 100 |
Measures agile sales responsiveness. Indicates strong client readiness and decisive quoting. |
≥ 35% |
| Inquiry → Tentative |
Tentative Date − Inquiry Date |
Time spent drafting proposal, scoping inventory, and presenting initial numbers to client. |
≤ 5 Days |
| Tentative → Confirmed |
Confirmed Date − Tentative Date |
Time client takes to review, sign contract, and provide deposit while holding gear off market. |
≤ 10 Days |
💡 Operational Insight: Why Median vs. Average Matters
A corporate client booking an annual festival 240 days in advance will heavily inflate the mathematical
Average, even though 70% of standard shows confirm within 10 days. Always rely on
Median Turnaround for realistic operational planning, and monitor
Average Turnaround to understand total quoting pipeline exposure.
3. The Two Core Operational Modes
At the top of the dashboard is the Mode Toggle. This switches the entire interface between high-level sales cycle duration and granular workflow bottleneck analysis:
Mode A: Total Turnaround Mode
Path: Inquiry → Confirmed (Default Mode)
Measures the complete net velocity from when an AM first creates a quote until the job is formally locked in as Confirmed.
Best for: Executive KPI reporting, quarterly sales velocity audits, evaluating overall client decision-making cycles, and general pipeline speed.
Mode B: Stage-by-Stage Breakdown
Path: Inquiry → Tentative → Confirmed
Separates quoting into two distinct sub-phases: time in Inquiry (quote drafting & review) vs. time in Tentative (holding gear pending contract/deposit).
Best for: Sales management coaching, identifying inventory hold gridlocks, and seeing whether delays originate internally or on the client side.
4. Dashboard Visual Charts & What They Reveal
📈 Chart 1: Monthly Turnaround Trend
What it displays: A dual-line trajectory tracking Average Days (Amber) and Median Days (Indigo) month-by-month over a rolling 24-month horizon.
Key takeaway: Reveals seasonal compression. During summer festival peaks (May–August), lead times compress drastically, demanding immediate equipment turnaround. In winter months, corporate planning horizons stretch out.
📊 Chart 2: Turnaround Duration Distribution
What it displays: Five distinct speed buckets: < 3 Days (green), 3–7 Days (blue), 8–14 Days (amber), 15–30 Days (orange), and 30+ Days (red).
Key takeaway: Shows the velocity profile of your pipeline. A healthy business has over 50% of jobs closing in under 14 days, with 30+ day deals reserved strictly for complex high-value tours.
👥 Chart 3: Account Manager Benchmarks
What it displays: Horizontal bar chart ranking all Account Managers by average turnaround velocity, with total job counts shown next to each AM's name.
Key takeaway: Highlights sales style differences. Enables leadership to recognize reps who close rapidly without excessive revisions, while providing coaching support for reps with stalled quotes.
💰 Chart 4: Value Tier Breakdown
What it displays: Compares Median and Average turnaround across revenue tiers: < $2.5k, $2.5k–$10k, $10k–$50k, and $50k+.
Key takeaway: Quantifies the natural correlation between job complexity and lead time. Small rentals close in days; $50k+ stadium shows require 4–8 weeks of engineering and client reviews.
🎯 Chart 5: Outlier Detection Scatter Plot (Prep Runway & Turnaround vs. Job Value)
Instantly isolates operational emergencies and quote traps against revenue. Toggle between Prep Runway (Days) and Turnaround Time (Days) on the X-axis against Job Value ($) on the Y-axis.
Risk Color Tiers: Red (< 3 days runway / Urgent Danger), Yellow (3–7 days runway / Moderate Notice), Green (> 7 days runway / Safe Advance Notice). Dot size dynamically scales with job revenue.
Zoom Presets: Quickly toggle between Core 80% (focus on jobs ≤ 60 days & ≤ $250k), Wide View (up to 180 days & $750k), and Full Max (all historical outliers up to $1.4M+). Or use + / − buttons for manual zoom.
Interactive Outlier Inspection: Clicking any bubble on the chart instantly scrolls down and highlights that specific job record in the table below with a direct link into Flex 5.
5. Prep Runway Triage (Warehouse Safety Alert)
The Prep Runway column in the data table is color-coded to provide instant visual risk alerts for warehouse leads and prep technicians:
| Runway Status |
Days to Prep Start |
Operational Impact |
Recommended Action |
| ⚠️ DANGER CRUNCH |
< 3 Days |
High probability of equipment shortages, dock congestion, and unplanned rush prep. |
Notify Warehouse Supervisor immediately. Triage pull list and verify sub-rentals. |
| ⚡ WARNING TIGHT |
3 to 7 Days |
Tight turnaround window. Gear may still be returning from preceding weekend shows. |
Review de-prep schedules. Ensure test-and-repair bench prioritizes required items. |
| ✅ HEALTHY BUFFER |
> 7 Days |
Normal operating buffer. Standard shop staging and preparation timelines apply. |
Standard shop queue scheduling. No special intervention required. |
6. Interactive Filtering & Power Features
The filter bar allows you to slice across thousands of historical and live milestone records in milliseconds:
1 Date Presets & Custom Windows
Choose from All History, Year to Date, Full Year 2026, Full Year 2025, Last 90 Days, or Last 30 Days. Selecting Custom Range... displays exact start and end date pickers.
2 Date Basis (Confirmed vs. Inquiry)
Filter by Confirmed Date to analyze jobs booked in a given fiscal month, or filter by Inquiry Date to analyze the cohort of inquiries generated during a specific marketing period.
3 Staff Segmentations (AM & PM)
Filter by individual Account Managers to isolate personal closing rates, or filter by Project Managers to review prep runways on specific production portfolios.
4 Labor Classification
Segment between Jobs With Labor (full-service concert/corporate productions) and Dry Hires Only (bare equipment rentals). Dry hires typically exhibit 3x faster turnaround times.
7. Practical Step-by-Step Workflows
Workflow A: Conducting a Quarterly Sales Audit (Sales Directors)
- Select Date Preset: Last 90 Days and ensure Date Basis: Confirmed Date is active.
- Observe the Median Turnaround and Fast Conversion Rate on the top KPI cards.
- Inspect the Account Manager Benchmark Chart to identify reps with above-average turnaround times.
- Toggle on Stage-by-Stage Breakdown: If the AM has high Inquiry → Tentative days, they need support drafting quotes faster. If they have high Tentative → Confirmed days, client follow-up sequences must be improved.
Workflow B: Preventing Warehouse Prep Surprises (Warehouse Operations)
- Set Date Preset: Last 30 Days and set Labor Type: Jobs With Labor.
- In the data table, click the Prep Runway header to sort ascending (smallest runway first).
- Review all rows highlighted with red ⚠️ Danger badges (< 3 days). Click the Doc # link to jump directly into the Flex 5 job card and verify gear lists with the assigned PM.
8. Underlying Data Pipeline & Integration
🔄 Permanent Milestone Architecture
All turnaround data is permanently recorded in the
Data_Job_Milestones sheet in Google Drive. When quote statuses change in Flex 5, our background synchronization triggers automatically capture timestamps into
Log_StatusChanges and update the milestone registry in real time. Historical quotes from 2025 and 2026 (2,360+ events) are fully backfilled.
Direct Flex 5 Integration
Every Doc # in the milestone table is an active hyperlink. Clicking any document number (e.g., 26-1796) immediately opens the live element inside Flex 5 (soundbox.flexrentalsolutions.com), enabling 1-click audit of equipment lists, quotes, and crew assignments.
One-Click CSV Export
Click the Export CSV button at any time to download the entire filtered dataset. The export file includes all raw dates, calculated turnaround days, runway days, revenue figures, labor flags, and client names for advanced modeling in Excel or Google Sheets.