Unit 7 / 11

Supply and Purchasing Analysis

Gains:

  • Ability to reduce and compare supplier offers in different formats into a common set of criteria
  • Ability to analyze total cost of ownership (TCO) including shipping, maturity and warranty
  • Ability to scan financial risks in contracts with AI and decide on them with human confirmation

The profit of a business is earned not only when selling but also when buying. Procurement and purchasing decisions directly affect the cost and cash cycle. Wrong supplier, hidden surcharges, bad payment terms... these all leak into profits. Artificial intelligence (AI) is a powerful assistant in comparing supplier offers, scanning contract terms and making savings opportunities visible. In this unit we will learn how to use AI at the buying table.

Comparing Apples to Apples

Supplier quotes rarely come in the same format. One gives a price including VAT, the other excluding; one writes the delivery time in days, the other in weeks; One offers a warranty, the other does not. AI's most valuable work is to distill these different formats into a common set of criteria (comparison fields) and put them side by side. This way, the "lowest total cost of ownership (TCO)" offer will be visible, not the "cheapest" one.

TCO (Total Cost of Ownership) includes not only the sticker price of a purchase; It refers to the whole life cost, including the cash cost of transportation, installation, maintenance, warranty and payment term.

Tip: Determine the comparison criteria in advance: unit price, delivery time, payment term, warranty, minimum order, shipping. If you allow the model to fit criteria, bids will be under-compared.

Step by Step: Quote Comparison

  1. Fix the criteria set. Write in advance which areas will be compared.
  2. Have all offers poured into the same template. Normalize different formats.
  3. Reveal hidden costs. Shipping, additional fees, exchange rate risk.
  4. Convert payment term into cash. 60 days maturity carries a discount value.
  5. Note separately what cannot be quantified. Relationship, reliability, reference; The decision includes these as well.

Weak Prompt / Strong Prompt

Poor prompt:Which of these three offers is best? [offers]

This gives an answer like “this is the cheapest” that is one-dimensional and misses hidden costs.

Powerful prompt:Your role: a procurement (procurement) analyst.Task: Compare the following 3 supplier quotes in one table.Criteria (columns): unit price (excluding VAT) | delivery time (days) | payment due date (days) | shipping | warranty | min. order | total costSteps:1) Normalize each quote to these criteria; Separate if VAT/shipping is included.2) Calculate the total cost for a sample order of 1000 units (show formula).3) Note the cash advantage of payment term (long term = advantage).4) Write down non-quantifiable factors (warranty coverage, reference) separately.5) Give advice but clearly list your rationale and assumptions.Constraint: Only use information in the data; write the missing field as "unspecified".<quotes> ... </quotes>

This prompt; may reveal that the bid with the lowest sticker price becomes the most expensive when shipping is added, and bases the decision on the actual total cost.

Comparison Chart Example

criterion

Supplier A

Supplier B

Supplier C

Unit price (excluding VAT)

42.00

39.50

41.00

Shipping (1000 pieces)

included

3,500 additional

included

Delivery time

7 days

21 days

10 days

Payment term

30 days

60 days

45 days

Total (1000 pieces)

42,000

43,000

41,000

In this table, although B appears cheapest in unit price, it turns out to be the most expensive with shipping; C is balanced. The decision is now data-driven.

Contract and Order Scanning

AI quickly scans risky items in long supply contracts: automatic renewal, unilateral right to increase, penalty conditions.

Scan the following supply contract for financial risk. List the following by item number:1) Clauses that allow price increases2) Automatic renewal and cancellation conditions3) Delay/penalty amounts4) Exchange rate or index based pricingWrite 1 sentence risk description for each item. Don't give legal advice; just point out points that need attention.

Caution: AI's contract screening is a pre-screening tool, not a legal opinion. In critical contracts, the final decision lies with the legal and purchasing unit. The model may miss or misinterpret an item.

Converting Payment Term into Money

A frequently overlooked fact in purchasing: a long payment term is a hidden discount. You will keep the money for the goods you purchased with a maturity of 60 days for two months; During this time, that money goes to work elsewhere or reduces your need for credit. AI can monetize this “maturity advantage” at an approximate financing cost, thus reducing price and maturity into a single comparable number.

Compare two offers including payment term:- Offer A: unit 40 TL, cash (0 days maturity)- Offer B: unit 41 TL, 60 days maturityAssume annual financing cost 40%. Calculate the cash advantage per unit of the 60-day maturity and find the "maturity adjusted" effective price of the two offers. Show the formula and assumption clearly.

This calculation often yields a surprising result: the unit price is slightly higher, but the long-term offer may actually be cheaper when the cost of financing is taken into account. The decision must be made on this actual cost; Just looking at the sticker price is misleading.

Tip: Use AI as a “scenario setter” in supplier negotiation: “What is more valuable to us, a 5% discount on price or an additional 30 days?” ask. The model compares the cash impact of two options and provides a numerical basis for the bargaining table.

Mini Cases

Case 1 — Cost of concealed transportation. A manufacturer was about to select the bid with the lowest unit price. AI comparison showed that this offer costs 3,500 TL shipping per 1000 pieces, making it more expensive than the others in total. The company returned to the second offer; saved approximately 42,000 TL annually.

Case 2 — Converting the maturity into cash. The two offers were equal in price, but one offered a maturity of 30 days and the other 60 days. AI calculated that a 60-day maturity carries the value of one month's additional financing in the cash cycle. A supplier with a long payment term was selected; In months when cash was tight, this difference eased the salary payment.

Case 3 — Silent raise clause in the contract. AI ticked the "annual PPI + 5% increase" clause in a three-year maintenance contract. It had escaped human eyes. The purchasing team renegotiated the clause as “PPI only”; A significant cumulative cost was avoided over three years. A simple calculation revealed the difference: an additional 5% compound raise on a 500,000 TL annual contract meant an additional burden of approximately 79,000 TL at the end of three years. The single item the AI ​​ticked in ten seconds saved that amount.

Case 4 — Maturity or discount? A company received the option of "either a 4% discount or an additional 45 days" from the supplier. AI calculated that an additional maturity of 45 days equates to a cash advantage of approximately 5%, assuming a 40% annual financing cost. The company chose maturity instead of discount; This decision reduced the need for credit in a cash-strapped quarter. Lesson: compare bargain options by cash value, not emotion.

Common mistakes

  • Just look at the sticker price. "Cheap" is misleading if shipping, additional fees and maturity are not included.
  • Having the criteria selected by the model. Comparison criteria are strategic; you decide.
  • Ignore payment due date. It is a measurable advantage in the long-term cash cycle.
  • Mistaking a contract scan for a legal opinion. AI pre-qualifies; The law must be in play in critical decisions.
  • Omitting the unquantifiable altogether. Credibility and reference enter into the decision; Number alone is not enough.

In summary

  • AI is powerful at collapsing supplier quotes in different formats into a common set of criteria and juxtaposing them.
  • The bidder with the lowest total cost of ownership (TCO) including shipping/term/warranty wins, not "cheapest".
  • You determine the comparison criteria; Take into account the cash advantage of the payment term.
  • AI quickly scans risky clauses in contracts, but this is a preliminary screening tool, not a legal opinion.
  • The final decision is made by the human being, who notes the non-quantifiable factors (reliability, reference) separately.

Application task

Prepare supplier proposals in three different formats (real or sample); Have at least one of them have discreet shipping or surcharges. Have them poured into a single comparison table with the powerful prompt template and calculate the total cost of 1000 units; manually verify at least one of them. Then, have a sample contract paragraph reviewed with the risk screening prompt and review the highlighted items yourself.

checklist

  • [ ] I determined the comparison criteria myself.
  • [ ] I had all quotes normalized to the same template.
  • [ ] I separated shipping, surcharge and VAT.
  • [ ] I have manually verified the total cost calculation in at least one quote.
  • [ ] I evaluated the cash advantage of the payment term.
  • [ ] I confirmed the contract scan with the human eye and noted what could not be quantified.