Procurement & Spend Analytics

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn Alderbrook Foods' purchase-order lines into a spend cube (category × supplier), category totals and shares, and reconcile it to the PO total.
• Rank Alderbrook's suppliers by spend, build the cumulative %, count how many suppliers make up 80% of the spend, size the tail and draw the Pareto chart.
• Calculate the purchase price variance (PPV) against standard cost and split this year's negotiation results into hard cost reduction and cost avoidance.
• Turn raw supplier KPIs (on-time %, defect ppm, price index) into 0–100 scores, weight them with SUMPRODUCT and rank the six suppliers.
• Rebuild a supplier's price from materials, labour, machine time, overhead and margin, and measure how far the quote is above your should-cost.
• Compare three shrink-film suppliers on total cost of ownership: purchase, freight, duty, inventory carrying, quality and audit costs, and find the supplier with the lowest TCO per roll.
• Flag every invoice as on or off contract with XLOOKUP, then measure maverick spend, PO compliance and the savings that leak away.
• Evaluate four bids for Alderbrook's 3-year logistics contract: normalise prices, weight price and quality 40/60, find the winner and chart how each score is built.