Excel for Purchasing Buyers: Quotes, Purchase Orders, Savings & Suppliers
20 hands-on labs for buyers and purchasing assistants: PO totals with freight and tax, RFQ comparison, total cost of ownership, price breaks, savings tracking, open PO follow-up, supplier scorecards, spend by category, EOQ, MOQ rounding, currency conversion, a buyer dashboard – then prices per base unit, freight allocation, last-price lookups, lead times, approval levels, blanket orders, a contract calendar and a quarterly supplier review.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
Twenty hands-on Excel labs for buyers and purchasing assistants at a small furniture maker. You check purchase orders with freight and tax, compare RFQ answers, calculate total cost of ownership, pick volume price breaks with XLOOKUP, track savings against the last price, follow up open and overdue POs, score suppliers, analyse spend by category, size order quantities with EOQ and MOQ rounding, convert foreign-currency quotes and build a spend-versus-budget dashboard. The second half adds daily buyer work: prices per kilogram or metre across pack sizes, freight split by value and by weight, the last price paid from a price log, quoted versus actual lead times, approval levels and split orders, blanket-order releases, notice deadlines with EDATE and a quarterly supplier review with a sorted chart. Every cell is checked instantly; all companies and prices are fictional.
Lessons
- 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
Learner reviews
Be the first to review this course.