Start with the records you have.
Maintenance, repair and operations spending is often called MRO. An invoice folder, spreadsheet or purchasing export can be enough to start a review. You do not need to install software or complete a new template.
The most useful starting fields are purchase date, supplier, manufacturer and full part number, quantity, unit or pack size, line amount and currency. Freight, tax, condition, facility and lead-time context improve the comparison when available. Keep missing fields visible.
Try a small purchasing example.
The downloads contain 12 invented records arranged as six comparisons. Every supplier, item identifier, purchase date and price is fictional. These are examples of how to read purchasing data, not market observations or customer results.
Each row represents a separate order for one item type, so its freight belongs to that row. The examples use USD and new items; tax is excluded. An exact item match here only means the fictional manufacturer and full item number agree. It does not establish availability, acceptable delivery, warranty or suitability for a real purchase.
The source file keeps the original quantities and amounts. The result file shows the number of individual items, line amount per item, known cost including freight, and the question that prevents a comparison. Included freight is already bundled into the line amount; it cannot be separated into a product-only price from these records. Unknown numbers stay blank and are explained in words. There is no combined savings figure.
Count what is inside the case.
| Field | Record 01-A | Record 01-B |
|---|---|---|
| Full fictional item number | DEMO-WASHER-10-A | DEMO-WASHER-10-A |
| Quantity on the record | 2 cases | 80 individual items |
| Contents | 4 packs per case; 10 items per pack | 1 item per invoiced unit |
| Individual items | 2 × 4 × 10 = 80 | 80 |
| Line amount before tax | $960 | $1,040 |
| Line amount per item | $12.00 | $13.00 |
$960 ÷ (2 × 4 × 10) = $12 per item. The other record is $1,040 ÷ 80 = $13 per item. The recorded difference is $1 per item on the stated costs, not a confirmed saving on a future order.
For a case packed in inner packs, multiply cases by packs per case and items per pack. A case containing individual items directly uses cases × items per case. For a pack, multiply packs by items per pack. For individual items, use the item count directly. For a mixed case, count each item type separately; do not treat the whole case as one product.
GS1 distinguishes individual items, inner packs, cases and mixed cases. We checked its packaging definitions on September 9, 2026. That source supports the packaging distinction; it does not validate the fictional prices or item matches in this example.
Comparison 02 deliberately omits packs per case for record 02-A. Its $480 line amount cannot produce a price per item until that count is known. Record 02-B contains 4 packs of 12, so $576 ÷ 48 = $12 per item. Do not fill the missing count with 1 to make the first calculation work.
A similar item number is not an exact match.
| Comparison | What the records contain | What the result says |
|---|---|---|
| 03: different suffix | DEMO-FILTER-20-A and DEMO-FILTER-20-B | Different full identifiers. Do not compare them as the same item. |
| 04: missing suffix | DEMO-BELT-40, marked incomplete, and DEMO-BELT-40-X | One identity is incomplete. Get the full number before deciding whether it matches. |
You can calculate a price per item from a complete quantity and amount even when two records do not match. That arithmetic does not establish a useful price difference between the products.
Keep the manufacturer and full part number, including suffixes. Use a supplier's record or a clear product label to resolve missing details. A proposed equivalent still needs your facility's technical acceptance before you treat it as interchangeable.
Missing freight can change the answer.
| Comparison | Record A | Record B | Supported conclusion |
|---|---|---|---|
| 05: freight unknown | 10 items; $100 line amount; freight unknown | 10 items; $108 line amount; freight included | Line amounts are $10 and $10.80 per item. A's freight is unknown, so the total-cost comparison remains open. |
| 06: freight changes the order | 10 items; $300 line amount + $40 freight | 10 items; $320 line amount; freight included | $340 versus $320 before tax, or $34 versus $32 per item including stated freight. |
For comparison 05, a blank freight field is unknown, not free. The result file leaves record 05-A's cost including freight blank. It does not declare record A the cheaper purchase.
For comparison 06, ($300 + $40) ÷ 10 = $34 per item. The other record is $320 ÷ 10 = $32. Adding the separately stated freight reverses the order suggested by the line amounts alone.
Real invoices may contain several items under one freight charge. Keep that charge separate or state how you allocate it before calculating a cost per item. Do not add the full order freight to every line. These examples do not model tax, currency changes, rebates, returns or core deposits.
Show what each comparison can support.
| Comparison | What can be said | Next question |
|---|---|---|
| 01: complete pack counts | $12 versus $13 per item on the stated costs | Are current supply, delivery, warranty and other terms acceptable? |
| 02: incomplete case count | Record 02-A has no defensible price per item yet | How many packs are in that case? |
| 03: different suffix | The records do not identify the same item | Is either item an approved alternative for the actual requirement? |
| 04: incomplete identity | An exact match has not been established | What is the missing full part number? |
| 05: freight unknown | Line amounts per item are known; the total comparison is incomplete | What did transport for record 05-A cost? |
| 06: freight included | $34 versus $32 per item including stated freight, before tax | Do dates, condition and the other commercial terms allow a useful comparison? |
An observed lower cost is a lead for review. It is not proof that an acceptable item is available today on the required terms. Do not add differences across unmatched products or incomplete records into a savings total.
A useful review returns the original record, the matched item, the calculation, source and date, remaining differences and the next question. Where an exact match cannot be established, say so.
Use a blank sheet if it helps.
The optional blank sheet has columns for original amounts, pack contents, item identity, charges and open questions. It contains no automatic formulas or upload connection. Leave unknown numeric fields blank and explain what is missing in the notes.
You can also send your existing files unchanged. There is no required template. Keep your facility's information private; this page's sample records are all invented.
Keep the follow-up focused.
Send imperfect existing files through the private benchmark form. Installed View can identify what is comparable, what is missing and where follow-up may be worthwhile. We do not publish your facility's purchasing records.
Please review these purchases for possible pricing gaps. The files cover [period, if known] and [facility or location, if useful].
Please distinguish exact matches from possible equivalents and unmatched items. Show the comparison source/date, normalized unit, known freight or tax differences and missing terms.
Flag the categories or lines worth checking first. Do not treat an observed price difference as confirmed savings.
Send your purchasing records.
Send your existing purchasing records or describe what you want to review. We will identify what is comparable and what needs follow-up.
Send purchasing filesPrivate submission. No account required. How we handle your information
Questions about this guide? Send a correction.