Logistics Operations Dashboard with SLAs and Efficiency Metrics
Defines logistics KPIs with clear SLAs, penalty systems, and tracking dashboards for distribution operations.
Create a logistics metrics system covering the full supply chain (receiving, storage, picking, packing, shipping, transportation, last mile) with measurable SLAs and exception management.
At a glance
Access
Free prompt
Open to copy without upgrading.
Prompt objective
Create a logistics metrics system covering the full supply chain (receiving, storage, picking, packing, shipping, transportation, last mile) with measurable SLAs and exception management.
Real use case
A distribution center processing 3,500 orders/day across 8 states has recurring problems with late deliveries (28% out of SLA), damage (2.1%), and picking errors (1.8%) — needs a dashboard that identifies bottlenecks in real time.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Create a complete logistics KPIs system for [COMPANY NAME], processing [NUMBER] orders/day, [NUMBER] SKUs, and operations in [STATES/REGIONS].\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Stage 1 — Receiving and Storage:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| KPI | Formula | SLA | Frequency |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n|-----|---------|-----|------------|\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Unloading time | End time - start time | <= [N] min/truck | Per unload |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Receiving accuracy | Correct items / total received | >= [X%] | Daily |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Warehouse occupancy | m3 occupied / total m3 | 75-85% (ideal) | Weekly |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Inventory turnover | COGS / Average inventory | >= [X] times/year | Monthly |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Stage 2 — Picking and Packing:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| KPI | Formula | SLA | Frequency |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n|-----|---------|-----|------------|\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Orders/hour/picker | Total orders / hours worked / pickers | >= [N] | Per shift |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Picking error rate | Orders with error / total shipped | <= [X%] | Daily |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Average picking time | Sum of times / total orders | <= [N] min | Per shift |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Fill rate | Items fulfilled / items ordered | >= [X%] | Daily |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Stage 3 — Transportation and Last Mile:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| KPI | Formula | SLA | Frequency |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n|-----|---------|-----|------------|\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| OTIF (On Time In Full) | On-time complete deliveries / total | >= [X%] | Daily |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Freight cost/order | Total transportation cost / orders | <= $[AMOUNT] | Weekly |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Return/damage rate | Returns / deliveries | <= [X%] | Weekly |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Delivery attempts | Average attempts until success | <= [N] | Monthly |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n| Cost per mile | Total cost / miles driven | <= $[AMOUNT] | Monthly |\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Stage 4 — Logistics Financial Indicators:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Logistics cost / revenue (industry benchmark)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Storage cost per pallet/month\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Stockout cost (lost sales from inventory gaps)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Cost of poor quality (returns + redeliveries + damages)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**SLA System and Management:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Traffic light for each KPI: green (within), yellow (<=10% out), red (>10% out)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Escalation: red for [N] days -> alert to management\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Contractual penalties for carriers: discount table for non-compliance\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Mandatory action plan for red KPIs (5W2H)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Recommended Dashboard:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Tool: [Power BI/Metabase/Looker Studio]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Update frequency: WMS/TMS data refreshed every [N] minutes\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Views: operational (real-time), management (weekly), strategic (monthly)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Filters: warehouse, carrier, region, customer, period
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: COMPANY NAME, NUMBER, STATES/REGIONS, X%.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A guide for technical builders choosing between prompts, coding workflows, and agent-based implementation.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allKPI Framework for E-commerce with Metrics Tree Structure
Structure a complete metrics tree for e-commerce, connecting strategic KPIs to operational ones with realistic targets and benchmarks.
Best for
Create a hierarchical KPI framework for e-commerce that links business metrics (revenue, margin) to operational metrics (conversion, AOV, CAC), with targets grounded in industry benchmarks.
OKR System with Automated Tracking for Startups
Implement OKRs with weekly check-ins, scoring, and tracking dashboards integrated with your existing tools.
Best for
Build a complete OKR system (Objectives and Key Results) covering definition, cascading, weekly tracking, and quarterly scoring, with BI integration for automated progress monitoring.
Balanced Scorecard Adapted for Small and Medium Businesses
Adapt the Balanced Scorecard framework to small and medium business reality with practical, actionable metrics.
Best for
Create a simplified, actionable Balanced Scorecard for SMBs with specific metrics for each perspective (financial, customers, processes, learning) suited to your tax and operational context.
SaaS Metrics Hierarchy with Leading and Lagging Indicators
Maps the relationship between leading indicators (predictive) and lagging indicators (results-based) for a SaaS business, enabling preventive action before outcomes deteriorate.
Best for
Create a complete SaaS metrics hierarchy that differentiates leading indicators (which predict the future) from lagging indicators (which confirm the past), enabling intervention before results worsen.
Explore other prompt categories
Move sideways into adjacent libraries when the current category is not the full answer.
Free browsing stays open. Premium prompts unlock the reusable workflow layer.
Use the guides and role paths to validate the job first. Upgrade when you want the full prompt text, editable premium prompts, and the surrounding course paths in one place.
Free access
- Browse guides, role paths, and category pages.
- Preview prompts before you decide to upgrade.
- Find the right starting point without friction.
Membership access
- Unlock premium prompts and the full copy text.
- See more workflow paths and course connections.
- Keep the reusable templates in one place.
