Tabellab

RFQ Comparison: Best Price per Item and Best Basket

Lesson 2 of 20 Lab 🔒 Locked

Lessons in this course

  1. Purchase Order: Line Totals, Freight and Sales TaxLabFree
  2. RFQ Comparison: Best Price per Item and Best BasketLab Locked
  3. Total Cost of Ownership: Price, Freight, Duty and Payment TermsLab Locked
  4. Volume Price Breaks: The Right Price with XLOOKUPLab Locked
  5. Savings Tracking: Price Variance against the Last PriceLab Locked
  6. Open PO Tracker: Overdue Orders and Days LateLab Locked
  7. Supplier Scorecard: On-Time Delivery, Quality and a Weighted ScoreLab Locked
  8. Spend by Category and Supplier: SUMIFS and SharesLab Locked
  9. Economic Order Quantity: How Much to Order at a TimeLab Locked
  10. Minimum Order Quantity and Pack Sizes: CEILING and MAXLab Locked
  11. Quotes in Foreign Currencies: Converting to USDLab Locked
  12. Buyer Dashboard: Spend vs Budget with a Chart and HighlightsLab Locked
  13. Quotes in Different Pack Sizes: Price per Base Unit and the Real Cheapest OfferLab Locked
  14. Allocating Freight to PO Lines: By Value, by Weight & the Rounding CentLab Locked
  15. Price History: The Last Price Paid with XLOOKUP from the Bottom, Lowest Prices & Price DriftLab Locked
  16. Lead Times: Quoted vs Actual Days per Supplier, the Longest Wait & a Realistic Arrival DateLab Locked
  17. Approval Levels: Routing Requisitions by Amount with XLOOKUP & Spotting Split OrdersLab Locked
  18. Blanket Orders: Monthly Releases, Remaining Quantity & When the Agreement Runs OutLab Locked
  19. Contract Calendar: End Dates & Notice Deadlines with EDATE, Days Left and an Act-Now ListLab Locked
  20. Final Project: Quarterly Supplier Review – Spend, Shares, On-Time Rates, Savings & the First Supplier to CallLab Locked