=============================================================================== TOAST PENDING SHIPMENTS ANALYSIS Complete Report Package Index Generated: October 30, 2025 =============================================================================== QUICK SUMMARY ------------------------------------------------------------------------------- Customer: Toast (Customer ID: 1) Total Backlog: 29,291 units remaining to ship Orders Pending: 67 purchase orders Oldest Order: January 20, 2023 (1,014 days old) Largest Order: PO 105719 - 6,619 units CRITICAL ALERTS ------------------------------------------------------------------------------- 🔴 URGENT: 3 orders from January 2023 are 1,000+ days old (4,889 units) 🔴 URGENT: PO 105719 has 6,619 units pending since December 2024 🟡 ACTIVE: 18 new orders from July 11, 2025 need production scheduling =============================================================================== REPORT FILES OVERVIEW =============================================================================== FILE 1: TOAST_SHIPMENT_SUMMARY.md ------------------------------------------------------------------------------- Type: Markdown Report (Executive Summary) Purpose: High-level overview for management Best For: Quick briefing, executive dashboard Key Sections: - Executive metrics and KPIs - Breakdown by year (2023, 2024, 2025) - Critical issues identified - Top 10 orders by volume - Actionable recommendations File Location: /var/www/html/TOAST_SHIPMENT_SUMMARY.md View Command: cat /var/www/html/TOAST_SHIPMENT_SUMMARY.md FILE 2: toast_pending_shipments_report.txt ------------------------------------------------------------------------------- Type: Detailed Text Report Purpose: Comprehensive order-by-order breakdown Best For: Production planning, detailed review Key Sections: - Full executive summary - Year-by-year breakdown (2025, 2024, 2023) - Individual PO details with line items - Style and colourway information - Key insights and recommendations File Location: /var/www/html/toast_pending_shipments_report.txt View Command: cat /var/www/html/toast_pending_shipments_report.txt FILE 3: toast_pending_shipments.csv ------------------------------------------------------------------------------- Type: CSV Export (Excel Compatible) Purpose: Data analysis and custom reporting Best For: Excel analysis, pivot tables, filtering Columns: - PO Number - Order Date - Style Ref - Design - Colourway - Ordered Qty - Shipped Qty - Remaining Qty - % Complete - Days Old Row Count: 118 line items File Location: /var/www/html/toast_pending_shipments.csv View Command: head -50 /var/www/html/toast_pending_shipments.csv Open in Excel: Download and open in spreadsheet application FILE 4: toast_pending_shipments_queries.sql ------------------------------------------------------------------------------- Type: SQL Query Collection Purpose: Database queries for ongoing analysis Best For: Database administrators, recurring reports Queries: 1. Grand Total Summary 2. Summary by Order (PO Level) 3. Breakdown by Year 4. Detailed Line Item View with Style Information 5. Detailed Size Breakdown (Most Granular) 6. Orders with Critical Aging (6+ Months Old) 7. Nearly Complete Orders (Less than 5% Remaining) File Location: /var/www/html/toast_pending_shipments_queries.sql View Command: cat /var/www/html/toast_pending_shipments_queries.sql Usage: Run queries in MySQL or via Laravel Tinker FILE 5: TOAST_ANALYSIS_INDEX.txt (This File) ------------------------------------------------------------------------------- Type: Index and Navigation Guide Purpose: Quick reference to all reports File Location: /var/www/html/TOAST_ANALYSIS_INDEX.txt =============================================================================== QUICK REFERENCE DATA =============================================================================== BACKLOG BY YEAR ------------------------------------------------------------------------------- 2025: 8,051 units (24 orders) - 27.5% of backlog 2024: 16,351 units (39 orders) - 55.8% of backlog ⚠️ HIGHEST 2023: 4,889 units (20 orders) - 16.7% of backlog ⚠️ OLDEST TOP 5 ORDERS BY REMAINING QUANTITY ------------------------------------------------------------------------------- 1. PO 105719 | Dec 10, 2024 | 6,619 units | 🔴 CRITICAL 2. PO 103223 | Jan 23, 2023 | 3,301 units | 🔴 CRITICAL (1,011 days old) 3. PO 105893 | Dec 12, 2024 | 1,825 units | 🔴 URGENT 4. PO 106781 | Jul 11, 2025 | 1,282 units | 🟡 RECENT 5. PO 106080 | Jan 31, 2025 | 990 units | 🟡 ACTIVE OLDEST ORDERS STILL PENDING ------------------------------------------------------------------------------- 1. PO 103210 | Jan 20, 2023 | 1,014 days old | 13 units remaining 2. PO 103204 | Jan 20, 2023 | 1,014 days old | 4 units remaining 3. PO 103206.01 | Jan 20, 2023 | 1,014 days old | 4 units remaining 4. PO 103223 | Jan 23, 2023 | 1,011 days old | 3,301 units remaining ⚠️ 5. PO 103288 | Jan 26, 2023 | 1,008 days old | 75 units remaining =============================================================================== HOW TO USE THESE REPORTS =============================================================================== FOR EXECUTIVES / MANAGEMENT ------------------------------------------------------------------------------- Start With: TOAST_SHIPMENT_SUMMARY.md (this provides KPIs) Then Review: toast_pending_shipments_report.txt (for details) Action Items: Focus on critical issues and recommendations sections FOR PRODUCTION MANAGERS ------------------------------------------------------------------------------- Start With: toast_pending_shipments.csv (open in Excel) Filter By: Days Old, Remaining Qty, or Design Action Items: Create production schedule for top 20 orders FOR CUSTOMER SERVICE ------------------------------------------------------------------------------- Start With: toast_pending_shipments_report.txt Reference: Individual PO numbers and expected quantities Action Items: Contact Toast regarding aged orders (6+ months) FOR DATABASE ADMINISTRATORS ------------------------------------------------------------------------------- Start With: toast_pending_shipments_queries.sql Run: Queries weekly to track progress Customize: Modify queries for specific reports needed =============================================================================== UPDATING THIS ANALYSIS =============================================================================== To refresh this analysis with current data, run: cd /var/www/html php artisan tinker --execute=" // Run any of the queries from toast_pending_shipments_queries.sql // Export new CSV or generate new reports as needed " Or simply re-request the analysis to regenerate all reports with fresh data. =============================================================================== CONTACT & SUPPORT =============================================================================== Database: knit (MySQL) Customer ID: 1 (Toast) Report Date: October 30, 2025 Generated By: Automated SQL Analysis For questions about this analysis or to request custom reports, contact your database administrator or development team. =============================================================================== END OF INDEX ===============================================================================