Supplier price comparison Excel template

Actual file previews

The images below are the actual data entry and executive summary pages of the workbook to be downloaded.

Step by step usage

1. Prepare the file according to your business

   Enter the supplier, package quantity, package price, delivery charge, discount, maturity and quality score for the same product specification.

2. Run formulas and checks

   Actual unit cost is the net package cost plus the apportioned delivery expense divided by the available package quantity. Compare different packages only after converting them to the same unit of measurement.

3. Turn results into action

   Review the indicators on the summary page. Rate product quality and efficiency along with price. Include delivery and discount impact. Keep the offer date and validity period.

What does this Excel file solve?

Compare actual unit cost with package quantity, product price, delivery cost and maturity information. Enter the supplier, package quantity, package price, delivery charge, discount, maturity and quality score for the same product specification.

What's inside the file?

Package and unit conversion, Delivery cost, Net unit cost, Supplier score. The file contains sample rows, canned formulas, data validation fields, risk colorings, and executive summary.

Calculation and control logic

Actual unit cost is the net package cost plus the apportioned delivery expense divided by the available package quantity. Compare different packages only after converting them to the same unit of measurement.

Worked example: Cheese offer comparison

A: 5 kg / 1.950 TL / free delivery. B: 4 kg / 1.480 TL + 120 TL delivery. Result: unit cost A is 390 TL/kg, cost B is 400 TL/kg; Despite the lower package price, B is more expensive.

Decisions that can be taken as a result of this

Rate product quality and efficiency along with price. Include delivery and discount impact. Store offer date and validity period

Common usage mistakes

Compare package prices directly. Confusing VAT or delivery definition between suppliers. Considering products of different quality or weight as equivalent

Limits and proper use

The lowest unit cost is not always the best supplier; Quality, delivery reliability, minimum order and maturity should also be evaluated.

Compatibility and quality control

All 67 workbooks underwent formula error scanning, recalculation checking, and page-by-page visual inspection. Standard .xlsx file; Does not contain macros or external links. Formulas and data validation fields run inside the file. It is recommended that you keep the original file and work on a separate copy for your business.

Transitioning from Excel to automation

Use the file to solve restaurant operation needs immediately. When registration and approval traffic grows, move the same process to the Shiftmate workspace.

Frequently asked questions