Open PO Tracker: Overdue Orders and Days Late
Lessons in this course
- Purchase Order: Line Totals, Freight and Sales TaxFree
- RFQ Comparison: Best Price per Item and Best Basket Locked
- Total Cost of Ownership: Price, Freight, Duty and Payment Terms Locked
- Volume Price Breaks: The Right Price with XLOOKUP Locked
- Savings Tracking: Price Variance against the Last Price Locked
- Open PO Tracker: Overdue Orders and Days Late Locked
- Supplier Scorecard: On-Time Delivery, Quality and a Weighted Score Locked
- Spend by Category and Supplier: SUMIFS and Shares Locked
- Economic Order Quantity: How Much to Order at a Time Locked
- Minimum Order Quantity and Pack Sizes: CEILING and MAX Locked
- Quotes in Foreign Currencies: Converting to USD Locked
- Buyer Dashboard: Spend vs Budget with a Chart and Highlights Locked
- Quotes in Different Pack Sizes: Price per Base Unit and the Real Cheapest Offer Locked
- Allocating Freight to PO Lines: By Value, by Weight & the Rounding Cent Locked
- Price History: The Last Price Paid with XLOOKUP from the Bottom, Lowest Prices & Price Drift Locked
- Lead Times: Quoted vs Actual Days per Supplier, the Longest Wait & a Realistic Arrival Date Locked
- Approval Levels: Routing Requisitions by Amount with XLOOKUP & Spotting Split Orders Locked
- Blanket Orders: Monthly Releases, Remaining Quantity & When the Agreement Runs Out Locked
- Contract Calendar: End Dates & Notice Deadlines with EDATE, Days Left and an Act-Now List Locked
- Final Project: Quarterly Supplier Review – Spend, Shares, On-Time Rates, Savings & the First Supplier to Call Locked