Sourcing Products for Your Brand: Supplier Quotes, MOQ Price Breaks, Samples, Inspection Sampling & Deposit Cash Flow

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 four differently built supplier quotes into the order total and the cost per unit at 1,200 bottles and see why the lowest unit price is not the cheapest offer.
• Price six order quantities from a price-break table with XLOOKUP, work out the order totals, the saving against the MOQ price and how many months each order lasts, and chart the price ladder.
• Cost four sample rounds, add up the development budget and use WORKDAY with the factory's closed days to find the approval date and the latest start for a target date.
• Chain a production timeline from the deposit to stock you can sell, mixing working days and calendar days, measure the lead time and find the date by which the next deposit must be paid.
• Look up the sample size and accept number for four lots in a fictional sampling table, decide accept or reject, estimate the faulty units in an accepted lot and what they cost you.
• Split three supplier orders into deposits and balances, place each payment in its week with SUMIFS and find the week-by-week low point of the cash balance.
• Split a season's order between two suppliers within their capacity, add purchase, fixed and expected delay costs and find the scenario with the lowest risk-weighted total.
• Build the full unit cost of the Ridge Bottle from per-unit and one-off lines, set the first-order budget with a contingency and chart where the money goes.