Synced 4 min ago
Demo mode — all figures, customers, suppliers and SKUs shown here are sample data for demonstration purposes only.

Meridian Pipe Works

High dependency

PVC & fittings · Alan Zhou · 2/10 Net 30

You owe
$214,600
Next payment
Aug 19, 2026
YTD spend
$1,842,000
On-time rate
94%

Your obligations and opportunities

Next payment due

$86,400

Aug 19, 2026 · in 4 days

Discount opportunity

$1,728

2% if paid by Aug 19

Cost trend

Rising

Unit cost +14% over 6 months

Dependency

High

Sole source for 3 top-20 SKUs

Meridian is your largest supplier by spend and the sole source for three of your top-20 SKUs. Their unit costs have risen 14% in six months, which is the main driver behind the PVC margin compression showing on the margin worklist.

Payment obligation timeline

Scheduled from bills read in QuickBooks

  1. PO-8841 invoice dueAug 19, 2026 · 2% discount window closes$86,400
  2. PO-8902 invoice dueAug 28, 2026 · Standard Net 30$62,200
  3. PO-8977 invoice dueSep 11, 2026 · Discount window opens Sep 1$66,000
Captured $18,400 in 12 moMissed $6,20075% capture rate

Cost index

Landed unit cost, indexed to February = 100

Recommended (advisory)

Explanations, not instructions — no payment is ever scheduled here

Advice
  • Discount capture is worth $20,700 a year on this account

    You captured 18 of 24 available discounts in the last 12 months. The 6 missed windows cost $6,200. Every miss in the last year fell in a week where a large receivable was late.

  • Cost increases have not been passed through

    Meridian's PVC lot cost rose 14% while your list price on the affected SKUs held flat. That gap accounts for roughly $31,000 of margin loss year to date.

  • Dependency concentration is high

    Three top-20 SKUs have no alternate vendor on file. A delivery interruption here reaches 22% of your revenue.

Pay now — captures $1,728 and cash position supports it

Advisory only —i2cashflow reads bills and purchase orders. It never creates a payment, a purchase order or a vendor credit.