Blog · Procurement and supply chain · Procurement
Procurement cost analysis compares purchase prices with freight, handling, and transaction costs on the same basis. Build a supplier comparison from purchasing exports, apply exact spreadsheet formulas, and reconcile the result to its source records.
Procurement cost analysis compares the cost of buying and receiving equivalent goods, including the quoted price and the additional costs you choose to measure. A cheaper unit price can produce a more expensive purchase once freight, handling, and order processing are included. The useful answer is a supplier comparison with a stated scope and a total that ties back to its records.
Use the same item specification, accepted quantity, delivery location, period, and currency. Keep payment terms and delivery requirements comparable, or show their differences separately. Comparing a delivered price with a freight-excluded quote creates a false saving before any formula is entered.
This article measures the buyer's acquisition costs. In federal contracting, FAR 15.404-1 distinguishes price analysis from analysis of a supplier's separate cost elements and profit. Your purchasing files do not reveal a supplier's production costs. The separate guide to cost and price analysis in procurement explains that distinction.
Define your operating comparison as:
Scoped procurement cost = Net goods value + Inbound freight + Assigned handling cost + Assigned transaction cost
Cost per accepted unit = Scoped procurement cost / Accepted units
This is a management comparison, not an instruction to capitalize every component into inventory. IRS Publication 538 includes transportation and other acquisition charges in the cost of purchased merchandise; your accounting team should determine the treatment of particular costs. Keep the analytical scope and ledger classification distinct.
Start with invoice lines containing supplier ID, category, item, invoice and credit identifiers, purchase order, date, quantity, unit of measure, and net goods value. Bring freight bills and receiving records alongside them. Establish whether freight is already included in the goods invoice before adding anything.
Use supplier IDs to join the records. If the export contains aliases, normalize supplier names before grouping them. Retain the original identifiers so each total can be traced back to the original documents.
For transaction cost, use an approved rate from a documented purchasing cost pool. Count distinct purchase orders, rather than invoice lines. Handling may come from separately recorded charges or an approved allocation. Label those alternatives clearly; an allocation is evidence of resource use, not proof of an avoidable cash outlay.
A US industrial distributor is comparing two suppliers for the same motors, delivered to the same site during a quarter. Each supplied the accepted quantity below. Net prices include applicable purchase discounts; the freight figures are separate carrier charges. Handling and transaction costs are assigned management costs, excluded from goods and freight.
Put these inputs in columns A through H, with headers in row 1:
| A: Supplier | B: Category | C: Accepted units | D: Net unit price (USD) | E: Freight (USD) | F: Handling (USD) | G: Purchase orders | H: Cost per order (USD) |
|---|---|---|---|---|---|---|---|
| Lake | Motors | 1,000 | 48.00 | 3,000 | 1,000 | 20 | 40 |
| Mesa | Motors | 1,000 | 46.00 | 6,500 | 1,500 | 40 | 40 |
In Excel, add net goods value in I, transaction cost in J, scoped total in K, and cost per accepted unit in L. Enter these formulas in row 2 and fill down:
I2 = C2*D2
J2 = G2*H2
K2 = I2+E2+F2+J2
L2 = IF(C2=0,"",K2/C2)
Blank unit cost flags an undefined denominator; it does not mean the goods cost nothing. These formulas give:
| Supplier | I: Net goods (USD) | J: Transactions (USD) | K: Scoped total (USD) | L: Cost per accepted unit (USD) |
|---|---|---|---|---|
| Lake | 48,000 | 800 | 52,800 | 52.80 |
| Mesa | 46,000 | 1,600 | 55,600 | 55.60 |
| Total | 94,000 | 2,400 | 108,400 | 54.20 |
The combined unit figure divides total cost by total accepted units: =SUM(K2:K3)/SUM(C2:C3). Do not average supplier unit costs when their quantities differ. All dollar totals here are exact; unit costs are shown to two decimals.
For a larger file, sum the cost for the supplier in N2 and category in O2 with:
=SUMIFS($K$2:$K$1000,$A$2:$A$1000,N2,$B$2:$B$1000,O2)
Replace the final row with the end of your populated range. Microsoft documents SUMIFS as adding values that meet multiple criteria. Covirage is not affiliated with Microsoft.
Mesa's goods value is lower, but its overall cost is higher. Subtract Lake's component from Mesa's component, keeping the direction consistent throughout:
| Driver | Lake (USD) | Mesa (USD) | Mesa minus Lake (USD) |
|---|---|---|---|
| Net goods | 48,000 | 46,000 | -2,000 |
| Freight | 3,000 | 6,500 | 3,500 |
| Handling | 1,000 | 1,500 | 500 |
| Transactions | 800 | 1,600 | 800 |
| Scoped total | 52,800 | 55,600 | 2,800 |
The bridge proves the change: -2,000 + 3,500 + 500 + 800 = $2,800. Mesa costs 2,800 / 52,800 = 5.3% more on this scope, rounded to one decimal place. Freight is the largest offset to the purchase-price reduction.
That finding supports a question about shipment consolidation, delivery terms, or freight pricing. It does not establish that Lake should receive every order. Capacity, quality, and continuity remain part of the decision. A supplier switching business case also needs transition costs and any one-time disruption assumptions.
Tie $94,000 of net goods to the invoice register after credits, $9,500 of freight to the included carrier bills, and $2,500 of handling to the approved supporting schedule. The transaction assignment is (20 + 40) orders × $40 = $2,400. The full check is 94,000 + 9,500 + 2,500 + 2,400 = $108,400, matching the supplier totals.
Where handling or processing rates come from a shared cost pool, reconcile the entire allocation schedule to that pool. A supplier subset is only part of that reconciliation. Keep unallocated amounts and exclusions visible.
Separate the $2,800 comparison into its recorded and assigned components before presenting a cash-saving proposal. Fewer orders may release staff capacity while leaving payroll unchanged. Broader procurement analytics should preserve that distinction between a purchasing opportunity and a realized financial result.
Bring a sample of your own purchase export and the supporting freight, handling, and transaction-cost files. Covirage maps the columns; its tools compute and check comparisons by supplier, category, and driver, while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.
See cost variance analysis for the supporting approach to explaining what changed.
Start with net purchase value, inbound freight, receiving or handling, and purchasing transaction costs. Add other drivers only when relevant records support them. State whether each component is directly recorded or allocated, and use the same scope for every supplier being compared.
A lower unit price reduces the goods component at a fixed quantity, but freight, order frequency, or handling can offset it. Compare the complete scoped cost before calling the difference a saving. Also separate a reduction in allocated cost from spending that will actually stop.
Choose a driver that reflects the activity, such as purchase orders processed or receipts handled. Document the rate and reconcile allocated amounts to the cost pool. Keep shared fixed costs visible because allocating less to one supplier does not necessarily reduce company spending.
An internal purchasing analysis studies your company's costs of acquiring goods or services. An analysis of a supplier's proposal may examine that supplier's materials, labor, overhead, and profit. Your own invoice export alone cannot establish the supplier's underlying production costs or margin.