Food traceability/Supplier cost control

Restaurant supplier price comparison: delivered cost and usable yield

Compare restaurant supplier prices with a downloadable CSV: pack sizes, freight, usable yield, whole-case rounding and a worked 5 kg versus 12 kg example.

Kivloo editorial teamUpdated November 1, 2026

4 min read

Compare restaurant supplier prices with a downloadable CSV: pack sizes, freight, usable yield, whole-case rounding and a worked 5 kg versus 12 kg example. — AI-generated editorial illustration

At a glance

Compare supplier offers on the same product specification and usable quantity. Divide the complete order cost, including delivery once, by the usable kilograms that order supplies. Check whole packs, minimums, shelf life and arrival before choosing. A lower cost per usable kilogram can still require more cash and leave more stock than another offer.

Start with comparable quotes

Record the supplier, dated offer reference, product specification and currency. Match grade, preparation, net pack weight and quality requirements before comparing numbers. A case, kilogram and individual item are different units. BCcampus describes purchase specifications and supplier terms; verify the current quote rather than treating a catalogue price as an accepted offer. Use the same tax basis throughout. The fictional example below excludes applicable tax and labour from both offers. Those exclusions are assumptions, not accounting advice.

BCcampus · Purchasing

Calculate two complete orders

Assume 10 usable kg are needed after checking usable stock and incoming orders. Offer A is 5 kg per pack at 21, with an assumed usable yield of 80%. Each pack supplies 4 usable kg. Round 10 ÷ 4 upward to three packs: 15 purchased kg, 12 usable kg and 63 product cost. Add delivery of 3 once: 66 total. Offer B is 12 kg per pack at 48 and 90% yield. One pack supplies 10.8 usable kg. Add delivery of 12 once: 60 total. Both offers have an assumed minimum of one pack.

Example record and review decision

A costs 66 ÷ 12 = 5.50 per usable kg; B costs 60 ÷ 10.8 ≈ 5.56. B has the lower quoted purchase price per kg, 4.00 versus 4.20, and needs less cash for this order. A has the lower usable unit cost but leaves 2 usable kg above the need, compared with B’s 0.8 kg. The decision remains open until storage, shelf life, preparation time and delivery are checked. Do not label the extra quantity as waste or guaranteed future usage. Neither unit cost is a total cost for exactly 10 kg consumed.

Test the yield assumption

Yield means usable weight divided by purchased weight for a defined preparation. BCcampus explains measuring it through yield tests. The 80% and 90% values here are fictional assumptions, not supplier performance. Record the test date, batch and preparation method before using your own yield. If B instead yields 92%, the same 60 buys 11.04 usable kg and costs about 5.43 per usable kg, reversing the unit-cost order. A small unverified assumption can change the decision; an unknown yield must stay unresolved.

BCcampus · Yield Testing

Keep freight and missing terms visible

For this single-item order, all freight belongs to that item. For a mixed basket, document an allocation rule and make the item charges sum to the one actual delivery charge. Do not add the full basket freight to every line. Confirm minimum spend, surcharges, substitutions, offer expiry and the required delivery window. A late or unsuitable product is not equivalent to an available one. Unknown fees are not zero. These two offers do not establish the best supplier across a whole basket, a month or every purchasing constraint.

Use the CSV and review a purchase draft

Download the CSV for two fictional offers and two blank offer columns. It contains plain evaluated values, not automatic formulas: recalculate yield, pack rounding, freight and totals after editing. The product-price field is per pack; Kivloo supplier offers use a price per base unit, so convert 21 ÷ 5 = 4.20 and 48 ÷ 12 = 4.00 before entry. The procurement beta supports pack/minimum/freight/lead-time fields, reviewed drafts, internal approval, exports and actual receiving. This manual yield comparison is not an automatic usable-yield optimizer. Web setup and connection are required; scans and invoices are web-only. Send supplier orders outside the app.

Kivloo · Procurement beta