PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
(claude-5-opus)
Token size
681
Example input
[RAW_FULFILLMENT_DATA]: 3PL Invoice #88492-Q3 for account NUTRITION-CORE. Total orders processed: 42,500. Base pick-and-pack fee applied at $2.45 per primary SKU (WHEY-ISO-5LBS). Kitting and assembly surcharge for the 'New Subscriber Bundle' (adding the plastic shaker bottle and printed insert) billed at an additional $3.65 per order. Carrier shipping log indicates the WHEY-ISO-5LBS SKU has an actual physical weight of 5.2 lbs, but was billed at a Dimensional (DIM) weight of 9.4 lbs across 28,000 shipments due to the 12x12x10 box dimensions utilizing a 139 DIM divisor. Reverse logistics log shows 1,240 returned units. Return processing fees assessed at $4.50 per unit for quality assurance, plus a $1.50 restocking fee per unit. Storage fees for the quarter were $18,400 based on $45 per pallet space. [OPERATIONAL_CONSTRAINTS]: The absolute maximum base pick-and-pack fee must not exceed $1.85 per order. Kitting and assembly surcharges for promotional items (shaker/insert) are contractually capped at $1.50 per bundle per the Q1 Master Service Agreement (MSA). Carrier Dimensional Weight applied to 5lb tubs must not exceed 6.5 lbs; any deviation requires immediate packaging optimization. Total reverse logistics costs (processing + restocking) must not exceed $3.00 flat per unit to maintain subscription viability. Pallet storage rates must remain fixed at $35 per pallet space as negotiated. Any deviation from these metrics destroys our Customer Acquisition Cost (CAC) payback period.
Example output
Example 1: Tier-2 Nutraceutical Subscription Brand (High-Volume Kitting) [INPUTS] Raw Fulfillment Data: "3PL Invoice #88492-Q3 for account NUTRITION-CORE. Total orders processed: 42,500. Base pick-and-pack fee applied at $2.45 per primary SKU (WHEY-ISO-5LBS). Kitting and assembly surcharge for the 'New Subscriber Bundle' (adding the plastic shaker bottle and printed insert) billed at an additional $3.65 per order. Carrier shipping log indicates the WHEY-ISO-5LBS SKU has an actual physical weight of 5.2 lbs, but was billed at a Dimensional (DIM) weight of 9.4 lbs across 28,000 shipments due to the 12x12x10 box dimensions utilizing a 139 DIM divisor. Reverse logistics log shows 1,240 returned units. Return processing fees assessed at $4.50 per unit for quality assurance, plus a $1.50 restocking fee per unit. Storage fees for the quarter were $18,400 based on $45 per pallet space." Operational Constraints: "The absolute maximum base pick-and-pack fee must not exceed $1.85 per order. Kitting and assembly surcharges for promotional items (shaker/insert) are contractually capped at $1.50 per bundle per the Q1 Master Service Agreement (MSA). Carrier Dimensional Weight applied to 5lb tubs must not exceed 6.5 lbs; any deviation requires immediate packaging optimization. Total reverse logistics costs (processing + restocking) must not exceed $3.00 flat per unit to maintain subscription viability. Pallet storage rates must remain fixed at $35 per pallet space as negotiated. Any deviation from these metrics destroys our Customer Acquisition Cost (CAC) payback period." [SIMULATED OUTPUT] Unit Economics Extraction Base Pick-and-Pack Fee: $2.45 per primary SKU. Kitting Surcharge: $3.65 per bundle for shaker bottle and insert inclusion. Dimensional Weight Metrics: Billed at 9.4 lbs (using a 139 DIM divisor) against an actual physical weight of 5.2 lbs. Reverse Logistics Costs: $4.50 processing fee plus a $1.50 restocking fee, totaling $6.00 per returned unit. Storage Fees: Billed at $45 per pallet space. Margin Compression Analysis Pick-and-Pack Inflation: The extracted base fee of $2.45 violates the $1.85 constraint limit. This $0.60 per-order overcharge across 42,500 orders results in $25,500 of unauthorized operational friction. Kitting Surcharge Violation: The $3.65 kitting fee blatantly breaches the contractually capped $1.50 rate from the Q1 MSA. This unauthorized $2.15 premium destroys the promotional margin on all new subscriber bundles. Dimensional Weight Hemorrhage: Billing a 5.2 lb SKU at 9.4 lbs violates the 6.5 lb DIM cap constraint. Utilizing the 139 divisor on a 12x12x10 box creates 4.2 lbs of phantom weight per shipment, severely inflating outbound carrier costs across 28,000 orders. Reverse Logistics Deficit: The combined $6.00 return cost exceeds the $3.00 flat rate constraint by 100%. This mathematically invalidates the profitability of the return-to-inventory lifecycle. Storage Rate Discrepancy: The applied $45 per pallet rate violates the negotiated $35 fixed rate constraint, representing a 28% systemic overcharge on warehousing. Structural Risk Assessment The current fulfillment architecture is highly toxic and actively degrading your operating capital. The 3PL is unilaterally ignoring MSA caps on kitting and storage while allowing severe dimensional weight inefficiencies to dictate carrier pricing. These operational bottlenecks are masking themselves as standard logistics costs but are actually stripping the net margin from your customer acquisition model. Immediate structural realignment of the contract and packaging dimensions is mandatory to prevent insolvency. Mitigation Directive To the Account Management Team at [3PL Name], We have completed an internal audit of Invoice #88492-Q3. We have identified severe discrepancies between your applied billing rates and our executed Master Service Agreement. Specifically, the $3.65 kitting surcharge and the $45 pallet storage rate violate our contracted caps of $1.50 and $35, respectively. Furthermore, the base pick fee of $2.45 exceeds our threshold, and the 139 DIM divisor applied to our 12x12x10 packaging is generating unacceptable phantom weight penalties. We require an immediate credit for the overcharged kitting and storage fees, alongside a scheduled call this week to restructure the dimensional packaging protocols.
Claude

Fulfillment Margin Evaluator

Add to Cart
PromptBase Select
Get this prompt + 9 more with SelectFrom $14/mo · Cancel anytimeFrom $14/mo · Cancel anytime
View Select
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-OPUS
Tested icon
Guide icon
4 examples icon
Free credits icon
Stop treating top-line GMV as profit. You are bleeding capital through unoptimized 3PL fees and dimensional weight penalties. This prompt aggressively synthesizes your pasted fulfillment data and shipping CSV text to output a structured unit economics summary. It processes user-provided logistics data to flag margin compression and generates a structural mitigation plan to recover operating capital.
...more
Added 3 weeks ago
Report
Browse Marketplace