Prompt Details
Model
(claude-5-opus)
Token size
752
Example input
[TRANSACTION_LOGS]: Exported from Shopify Plus / Inventory Planner sync (Trailing 30 Days). SKU: N-400 (Neuro-Optimization Blend). 08/20 to 08/26: 1,280 units sold. 08/27 to 09/02: 1,310 units sold. 09/03 to 09/09: 8,450 units sold (Note from Growth Marketing: Joe Rogan podcast integration went live on 09/04, driving massive traffic spike. Coupon code 'ROGAN20' accounted for 6,900 of these units. This campaign is over and will not be repeated this fiscal year). 09/10 to 09/16: 1,350 units sold. 09/17 to 09/20: 780 units sold. Current Physical Inventory Count (3PL Nevada): 4,120 units. Damaged/Quarantine Stock: 115 units (Unsellable). Total Usable Stock: 4,005 units.
[VENDOR_CONSTRAINTS]: Primary Manufacturer: Apex Botanical Labs (Utah). Standard SLA: 21 days for raw material blending. 7 days for bottling and label application. 4 days for domestic LTL freight to our Nevada 3PL. Current Friction: Apex account manager emailed yesterday stating that raw Lion's Mane mushroom extract is delayed at customs. Add a mandatory 9-day buffer to the blending phase for all Q4 purchase orders. Minimum Order Quantity (MOQ): 5,000 units. Product Shelf Life: 8 months from the date of bottling.
[CAPITAL_LIMITS]: Chief Financial Officer directive: Maximum allowable capital deployment for SKU N-400 in Q4 is $85,000 to preserve liquidity for Black Friday media buying. Cost of Goods Sold (COGS) per unit: $12.40. 3PL Climate-Controlled Storage Cost: $0.22 per unit, per month. Target Inventory Turnover Ratio: 4.0 (We cannot hold more than 90 days of inventory without severely degrading our EBITDA margin).
Example output
Example 1: High-Velocity D2C Nutraceuticals (Supply Chain Vulnerability & Expiry Constraints)
[INPUTS]
Transaction Logs:
Exported from Shopify Plus / Inventory Planner sync (Trailing 30 Days). SKU: N-400 (Neuro-Optimization Blend).
08/20 to 08/26: 1,280 units sold.
08/27 to 09/02: 1,310 units sold.
09/03 to 09/09: 8,450 units sold (Note from Growth Marketing: Joe Rogan podcast integration went live on 09/04, driving massive traffic spike. Coupon code 'ROGAN20' accounted for 6,900 of these units. This campaign is over and will not be repeated this fiscal year).
09/10 to 09/16: 1,350 units sold.
09/17 to 09/20: 780 units sold.
Current Physical Inventory Count (3PL Nevada): 4,120 units.
Damaged/Quarantine Stock: 115 units (Unsellable).
Total Usable Stock: 4,005 units.
Vendor Constraints:
Primary Manufacturer: Apex Botanical Labs (Utah).
Standard SLA: 21 days for raw material blending. 7 days for bottling and label application. 4 days for domestic LTL freight to our Nevada 3PL.
Current Friction: Apex account manager emailed yesterday stating that raw Lion's Mane mushroom extract is delayed at customs. Add a mandatory 9-day buffer to the blending phase for all Q4 purchase orders.
Minimum Order Quantity (MOQ): 5,000 units.
Product Shelf Life: 8 months from the date of bottling.
Capital Limits:
Chief Financial Officer directive: Maximum allowable capital deployment for SKU N-400 in Q4 is $85,000 to preserve liquidity for Black Friday media buying.
Cost of Goods Sold (COGS) per unit: $12.40.
3PL Climate-Controlled Storage Cost: $0.22 per unit, per month.
Target Inventory Turnover Ratio: 4.0 (We cannot hold more than 90 days of inventory without severely degrading our EBITDA margin).
[SIMULATED OUTPUT]
Velocity and Anomalies Extraction
Baseline Trajectory: Excluding the podcast anomaly, the trailing 30-day data indicates a highly stable, recurring sales velocity of approximately 188 units per day (calculated from the standard weekly volume of 1,280 to 1,350 units).
Anomaly Quarantine: The transaction spike between 09/03 and 09/09 (8,450 units) is structurally quarantined from the forecasting algorithm. The text explicitly links this to a non-recurring podcast integration. Factoring this into the baseline would artificially inflate the reorder metric by 230%, causing catastrophic over-purchasing and subsequent product expiration.
Active Inventory: Usable stock is strictly defined as 4,005 units, entirely discounting the 115 units currently in QA quarantine to prevent false security in stock depth.
Lead Time Friction Analysis
Adjusted Lead Time Calculation: The historical 32-day vendor lead time (21 days blending + 7 days bottling + 4 days freight) is mathematically obsolete. The text mandates a 9-day raw material delay. The new operational lead time is rigidly set at 41 days.
Stockout Velocity: At the baseline velocity of 188 units per day, the current usable inventory of 4,005 units will be completely exhausted in exactly 21.3 days.
Logistical Deficit: The vendor requires 41 days to deliver, but inventory will deplete in 21 days. The architecture confirms an unavoidable, mathematically guaranteed stockout window of 20 days.
Revenue Hemorrhage: Assuming an Average Order Value commensurate with standard D2C operations, 20 days of zero inventory at 188 units/day equates to 3,760 lost sales, severing the primary revenue artery for the quarter.
Capital Allocation Matrix
Budget Ceiling: The CFO's maximum capital deployment limit of $85,000, divided by the unit COGS of $12.40, establishes an absolute purchasing ceiling of 6,854 units.
MOQ Constraint Check: The maximum unit ceiling (6,854) successfully clears the manufacturer's Minimum Order Quantity of 5,000 units.
Holding Cost and Expiration Viability: Ordering the maximum allowable 6,854 units provides 36 days of stock (post-delivery). This aligns perfectly with the CFO's target inventory turnover ratio of 4.0 (sub-90 days) and neutralizes the 8-month product shelf-life risk.
Final Allocation: To minimize the impending stockout window while adhering to liquidity limits, the directive is to immediately authorize a purchase order for 6,850 units, deploying $84,940 of the $85,000 Q4 budget.
Purchase Order Directive
TO: Apex Botanical Labs (Account Management)
SUBJECT: URGENT PURCHASE ORDER - SKU N-400 (6,850 Units)
Please consider this an active and authorized Purchase Order for 6,850 units of SKU N-400 at our contracted COGS of $12.40 per unit. We acknowledge the current 9-day delay on Lion's Mane extract, bringing our total expected lead time to 41 days. Please schedule production immediately to mitigate our upcoming stockout window. Confirm receipt and provide the estimated LTL freight departure date.
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 subsidizing warehouse entropy with manual spreadsheets. This prompt aggressively synthesizes your pasted transaction logs and vendor lead times to calculate text-based restocking directives. It algorithmically structures user-provided supply chain data into a clinical capital allocation matrix and drafts precise purchase order communications.
...more
Added 2 weeks ago
