Prompt Details
Model
(claude-5-opus)
Token size
642
Example input
[RAW_PROCUREMENT_DATA]: Transcript from Q3 Supply Chain Alignment. "We have six primary vendors for the new logic board. Vendor 1 (SiliconWafers Inc) is based in Hsinchu, Taiwan, shipping via the Port of Keelung, with a stated lead time of 45 days. Vendor 2 (LithoTech) is also located in Hsinchu, shipping via Keelung, demanding a 52-day lead. Vendor 3 (Shenzhen Assembly) is out of Guangdong, China, shipping via Yantian port, 38 days lead. Vendor 4 (CopperInterconnects) is in Taoyuan, Taiwan, but routes all freight through Keelung as well, taking 41 days. Vendor 5 (PackagingCorp) operates out of Penang, Malaysia, utilizing direct air freight via PEN, 14 days lead. Vendor 6 (TestLogistics) is in Johor, Malaysia, relying on cross-border trucking to the Port of Singapore for ocean freight, taking 44 days. All ocean freight converges at the Port of Oakland."
[MAX_LEAD_TIME]: 40 days.
[TARGET_CAPITAL_CONSTRAINTS]: Maximum Work-In-Progress (WIP) inventory cannot exceed $4,500,000. Daily holding cost penalty of $12,000 for delays. Target Cash Conversion Cycle (CCC) must remain strictly under 30 days to satisfy venture debt covenants.
Example output
Example 1: Enterprise Semiconductor Procurement & Assembly
[INPUTS]
Raw Procurement Data: Transcript from Q3 Supply Chain Alignment. "We have six primary vendors for the new logic board. Vendor 1 (SiliconWafers Inc) is based in Hsinchu, Taiwan, shipping via the Port of Keelung, with a stated lead time of 45 days. Vendor 2 (LithoTech) is also located in Hsinchu, shipping via Keelung, demanding a 52-day lead. Vendor 3 (Shenzhen Assembly) is out of Guangdong, China, shipping via Yantian port, 38 days lead. Vendor 4 (CopperInterconnects) is in Taoyuan, Taiwan, but routes all freight through Keelung as well, taking 41 days. Vendor 5 (PackagingCorp) operates out of Penang, Malaysia, utilizing direct air freight via PEN, 14 days lead. Vendor 6 (TestLogistics) is in Johor, Malaysia, relying on cross-border trucking to the Port of Singapore for ocean freight, taking 44 days. All ocean freight converges at the Port of Oakland."
Max Acceptable Lead Time: 40 days.
Target Capital Constraints: Maximum Work-In-Progress (WIP) inventory cannot exceed $4,500,000. Daily holding cost penalty of $12,000 for delays. Target Cash Conversion Cycle (CCC) must remain strictly under 30 days to satisfy venture debt covenants.
[SIMULATED OUTPUT]
Geographic Overlap Autopsy
Port of Keelung Export Choke Point: Vendor 1, Vendor 2, and Vendor 4 operate in distinct municipalities (Hsinchu and Taoyuan) but share the exact same maritime export node. A localized labor strike, seismic event, or customs software failure at Keelung simultaneously severs the supply of wafers, lithography components, and copper interconnects.
Hsinchu Manufacturing Corridor: Vendor 1 and Vendor 2 share the same localized power grid and infrastructure. This geographic concentration negates any corporate diversification; an industrial shock in Hsinchu halts 33% of the total supply chain.
Port of Oakland Inbound Dependency: 83% of the supplier base (Vendors 1, 2, 3, 4, and 6) relies exclusively on ocean transit terminating at a single West Coast port. This creates a systemic inbound bottleneck, subjecting the entire logic board assembly to localized California dockworker volatility.
Vendor Risk Matrix
Vendor 1 (SiliconWafers Inc): Location: Hsinchu, Taiwan (Port of Keelung) | Stated Lead Time: 45 Days | Breach Status: FAIL
Vendor 2 (LithoTech): Location: Hsinchu, Taiwan (Port of Keelung) | Stated Lead Time: 52 Days | Breach Status: FAIL
Vendor 3 (Shenzhen Assembly): Location: Guangdong, China (Port of Yantian) | Stated Lead Time: 38 Days | Breach Status: PASS
Vendor 4 (CopperInterconnects): Location: Taoyuan, Taiwan (Port of Keelung) | Stated Lead Time: 41 Days | Breach Status: FAIL
Vendor 5 (PackagingCorp): Location: Penang, Malaysia (Air via PEN) | Stated Lead Time: 14 Days | Breach Status: PASS
Vendor 6 (TestLogistics): Location: Johor, Malaysia (Port of Singapore) | Stated Lead Time: 44 Days | Breach Status: FAIL
Capital Buffer Impact
WIP Inventory Saturation: With four out of six vendors breaching the 40-day maximum lead time (peaking at 52 days for LithoTech), working capital is structurally trapped in maritime transit. Maintaining the $4,500,000 maximum WIP ceiling is mathematically impossible under these transit durations.
Cash Conversion Cycle (CCC) Violation: The 30-day CCC covenant is actively breached by 66% of the supply base. Capital is deployed to offshore fabricators up to 22 days before components clear the Port of Oakland, forcing the enterprise to absorb unmetered debt servicing costs.
Holding Cost Penalties: The baseline Transpacific routing mandates minimum delays for Vendors 1, 2, 4, and 6. Averaging 5 days over the acceptable maximum incurs an automatic, structural holding penalty of $60,000 per transit cycle, aggressively compressing operating margins.
Reallocation Protocol
The current procurement architecture operates under a geographic illusion. Despite engaging six distinct corporate entities across three nations, the supply chain is structurally dependent on the Port of Keelung and the Port of Oakland. Furthermore, four vendors actively breach the 40-day maximum acceptable lead time, guaranteeing the failure of the 30-day cash conversion cycle and the breach of the $4.5M WIP limit. To preserve operating capital, procurement must immediately transition Vendor 1 and Vendor 4 to air freight, or establish a nearshore redundant fabrication facility to bypass the West Coast maritime bottleneck.
Get this prompt + 9 more with SelectFrom $14/mo · Cancel anytimeFrom $14/mo · Cancel anytime
View SelectBy purchasing this prompt, you agree to our terms of service
CLAUDE-5-OPUS
Stop confusing vendor count with geographic sovereignty. This prompt analyzes your pasted procurement data and transit logs to output a structured summary of overlapping regional dependencies. It generates a clear vulnerability breakdown to expose transit delays and protect your working capital.
...more
Added 2 weeks ago
