Mytrii — Procurement Intelligence

PROCUREMENT INTELLIGENCE — HOW THIS TOOL WORKS

Most small and mid-size food operations run purchasing on one buyer's memory and a weekly meeting. This tool replaces that with five connected checks, run off the same demand and inventory data every time — so nothing depends on one person remembering to look.

1

Sets the contract

Annual Requirement

Explodes forecasted finished-goods sales back down to raw material, adjusted for seasonality, and nets off what's already sitting in stock. That number is what buyers contract against for the year (BPO) — never a guess, and never confirmed supply on its own.

2

Proves the number

Child (RM) Verification

Answers the question every buyer eventually asks: "why does this item show 26,000 bags a year?" Pick any raw material and see exactly which finished goods (the "parent" items) draw on it, and how much of the annual figure each one accounts for. If it doesn't reconcile back to the Annual Requirement number, the forecast is wrong somewhere — and this is where you'd catch it.

3

Schedules delivery

Releases (16-Week)

Breaks the annual contract into a rolling 16-week delivery schedule, projecting stock position week by week against seasonal demand. A buyer sees a stockout coming sixteen weeks out, not the week it happens — enough lead time to actually release a load.

4

Catches what changed

Weekly Adjustment

Every week, compares current stock against near-term demand and flags whether the next scheduled release should be pulled ahead, pushed back, or left alone. This is what catches a demand swing the annual plan couldn't have predicted — before it becomes a stockout or an overstock.

5

Last-resort cover

Spot Purchase

When a delayed shipment or a demand spike means contracted supply won't arrive in time, this identifies exactly which items are at risk, how many days short, and the minimum quantity needed to bridge the gap — so a spot buy is sized correctly instead of guessed at under pressure.

6

Frees up cash

Overstock

Flags raw material sitting well above what coverage actually requires, values the excess in dollars, and recommends whether to delay, cancel, or simply monitor the next incoming order. This is where working capital gets unlocked without touching a single sales number.

Every module above runs off the same ten raw-material items and the same demand assumptions — nothing here is a separate spreadsheet with its own version of the truth.

BPO COVERAGE % — BY RAW MATERIAL ITEM

ANNUAL REQUIREMENT — ALL TYPE 13 ITEMS

Demand shown is fully exploded from finished-good sales back to raw material, adjusted for seasonality and buyer overrides, net of child SKU inventory. Blanket orders (BPO) are contracts only — never counted as confirmed supply.

WHERE THIS RAW MATERIAL IS USED — BY FINISHED GOOD

Annual RM Consumed is each finished good's share of the Annual Requirement figure from Module 1. The total below always reconciles to that number — if a buyer's real-world usage doesn't tie out this way, the forecast assumption (not the raw material number) is what needs fixing.

PROJECTED INVENTORY POSITION — NEXT 16 WEEKS

Stockout Below Reorder Point Near Reorder (within 20%) OK

Each week's demand applies the seasonal index for the month it falls in — peak weeks (Oct–Dec) show higher draw automatically. Incoming POs land in the correct week on arrival.

WEEKLY ADJUSTMENT — STOCK POSITION & PULL/PUSH DECISIONS

Pull Ahead Days = advance next PO arrival by this many days. Push Back Days = delay next PO by this many days. Permanent forecast changes go through the Adjustments file, not this page.

SPOT PURCHASE — AT-RISK ITEMS

Spot Purchase Qty is rounded up to the nearest local load size (50 units). Sort by Days on Hand ascending — most urgent first.

60-DAY STOCK SIMULATION

Projected stock at Day 7 / 14 / 21 / 30 / 45 / 60, accounting for daily consumption and the next confirmed incoming shipment.

OVERSTOCK WEEKS — BY ITEM

OVERSTOCK INVENTORY — TYPE 13 ITEMS

Overstock Qty = (Current Stock + incoming within lead time) − Max Desired Stock, floored at 0. Follow the Action column recommendation; add remarks to document decisions.