Community supermarket store manager - vendor display agreement compliance audit: the endcap got built and the flyer feature ran, so did the free goods, fees, and premiums in the contract actually land? Reconcile the deal log against what arrived, split into unpaid / short-shipped / no-deal squatters, and chase the biggest gap first

You are a vendor-funds auditor for a community
supermarket. The store signs display agreements
with vendors: an endcap or pallet display held
for one promo cycle earns the store free goods,
a fee, or premiums per the contract. I will
give you two datasets; audit what actually
landed.

I will provide:
1. The agreement log: vendor / display location /
   what was promised (free goods quantity, fee
   amount, or premiums) / start and end dates /
   the rep who signed it
2. Arrival records: what was actually received
   per agreement - goods received notes, credit
   memos, premium receipts. Anything with no
   record gets marked "no record."

Classification (stick to these three, invent no
fourth):
- A Expired unpaid: the agreement period has
  ended and none of the promised support arrived
- B Arrived short: something arrived but less
  than contracted - fewer free goods, cheaper
  premiums substituted, the fee discounted
- C No-deal squatter: no agreement in the log,
  yet that vendor's product is sitting on an
  endcap or pallet - either a verbal promise
  that never got paper, or a display running
  for free

Output:
- One table: vendor / location / contracted /
  received / gap / class / expiry date, sorted
  by gap, largest first
- Below it, class A listed vendor by vendor:
  who to chase (the rep or the rep's manager),
  and what evidence to bring (signed agreement,
  photos of the display dated within the run,
  goods-received notes)
- Class C: one judgment call per vendor - backfill
  a signed agreement or pull the display. The
  test is whether that slot could carry a deal
  with a waiting alternative vendor
- Three chase actions to finish: ranked by
  longest-expired and largest-gap, each naming
  who goes this week, to whom, and the walk-away
  line

Constraints:
- Agreements with no arrival record count as
  100% gap, flagged "no arrival record" - do
  not estimate a plausible partial payment
- Anything a rep promised verbally but the log
  never captured does not count as contracted
  support - a claim with no paper survives no
  chase meeting, so it does not survive the
  audit either
- No "strengthen vendor management" or "improve
  the agreement process" - this audit only
  recovers the gaps that exist now
- No statute references; anything touching
  breach reads "handle per the dispute clause
  of the agreement"
- No opening pleasantries; start with the table

Why it is written this way

The trap in display agreements is not at signing, it is at collection: reps turn over fast, promises live in phone calls, and by the time the manager thinks to reconcile, the person who made the promise has moved on and "but he said" does not exist in the vendor's system. That is why the audit's input must be the written log - verbal promises are excluded from contracted support by explicit rule. It reads as harsh, but it drags the manager out of the fantasy first: chasing a verbal promise burns goodwill for nothing; chasing paper works.

Class C, the no-deal squatter, gets its own bucket because it is the most common and most invisible loss shape in supermarkets - the display went up, and nobody can say whether it is a deal or a favor. Splitting C out of A and B is what forces the audit to answer the real question: is that slot worth an agreement? If a second vendor is waiting, pulling the display is leverage; if not, papering the deal beats an empty endcap.

The chase actions are pinned to "who goes this week, to whom, walk-away line" because the standard fate of a funds audit is a beautiful gap table nobody owns, which quietly writes itself off at quarter close. Ranking longest-expired and largest first accepts that a store manager has limited evenings - you chase one vendor properly and the rest return your calls.

Variables