# ERP Vendor Pricing Quote Normalizer Worksheet

> Source: https://netray.co/tools/erp-vendor-pricing-quote-normalizer-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Enter each vendor's quote lines by year and category to see a like-for-like five-year total across competing ERP proposals.

## Category

cost-finance

## Audience

- CIO
- ERP project lead
- Procurement
- Finance

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Vendor

**Key:** vendor

**Type:** text

#### Cost category

**Key:** category

**Type:** select

**Options:**

- Subscription or license
- Support and maintenance
- Implementation services
- Integration
- Data migration
- Training
- Infrastructure
- Other

#### Year 1

**Key:** y1

**Type:** number

**Format:** currency

#### Year 2

**Key:** y2

**Type:** number

**Format:** currency

#### Year 3

**Key:** y3

**Type:** number

**Format:** currency

#### Year 4

**Key:** y4

**Type:** number

**Format:** currency

#### Year 5

**Key:** y5

**Type:** number

**Format:** currency

#### Five-year total

**Key:** total

**Type:** number

**Expr:** y1 + y2 + y3 + y4 + y5

**Format:** currency

**Rows:**

**Vendor:** Vendor A

**Category:** Subscription or license

**Y1:** 120000

**Y2:** 126000

**Y3:** 132300

**Y4:** 138915

**Y5:** 145861

**Vendor:** Vendor A

**Category:** Implementation services

**Y1:** 380000

**Y2:** 0

**Y3:** 0

**Y4:** 0

**Y5:** 0

**Vendor:** Vendor A

**Category:** Integration

**Y1:** 60000

**Y2:** 12000

**Y3:** 12000

**Y4:** 12000

**Y5:** 12000

**Vendor:** Vendor B

**Category:** Subscription or license

**Y1:** 150000

**Y2:** 150000

**Y3:** 150000

**Y4:** 165000

**Y5:** 165000

**Vendor:** Vendor B

**Category:** Implementation services

**Y1:** 290000

**Y2:** 0

**Y3:** 0

**Y4:** 0

**Y5:** 0

**Vendor:** Vendor B

**Category:** Training

**Y1:** 25000

**Y2:** 8000

**Y3:** 8000

**Y4:** 8000

**Y5:** 8000

**Totals:**

#### Year 1 total

**Key:** y1

**Agg:** sum

**Format:** currency

#### Five-year total (all rows)

**Key:** total

**Agg:** sum

**Format:** currency

**Summary:**

#### Average annual cost (all rows)

**Key:** avg_year

**Expr:** sum_total / 5

**Format:** currency

**Notes:** Enter one row per vendor and category. To compare vendors, sort or filter in Excel after export and sum by vendor. Use the same assumptions for every vendor: user count, modules, sites and growth. Add escalators the vendor states, and test an unstated renewal uplift of 5 to 8 percent as a sensitivity.

## Content

**Intro:** ERP quotes arrive in different shapes: subscription versus perpetual, bundled services versus itemized, one year versus three. This worksheet puts them into one grid so the five-year cost is comparable.

**Sections:**

#### How to use the worksheet

**Body:** Add a row for each vendor and cost category, then fill in years one through five. If a vendor quotes only year one, ask for the escalation terms or apply a documented assumption and mark it in the notes. The sheet adds the five-year total per row and overall, and you can export to Excel to group by vendor and build a chart for the steering committee.

#### Normalizing the assumptions

**Body:** A fair comparison needs identical scope. Fix the number of users by type, the modules, the number of sites and the integrations, then ask each vendor to quote exactly that. If a vendor excludes something, such as non-production environments or data migration, add it as a row with your own estimate. A quote that looks cheap often leaves work outside the price.

**Bullets:**

- Same users, modules and sites for every vendor
- Include support, training and environments
- Show escalators and renewal uplifts explicitly
- Add internal staff time as a separate line

#### Reading the totals

**Body:** Compare year one, which reflects project cash needs, and the five-year total, which reflects lifetime cost. A vendor with high implementation cost and low subscription may win over five years, while the reverse may be cheaper upfront. Test sensitivity by raising escalators and user counts, because a small difference in growth assumptions can reverse the ranking.

#### Common mistakes

**Body:** Leaving out internal costs, comparing perpetual license cost to subscription without maintenance, and taking discounts as permanent when they expire at renewal are the typical errors. Another is ignoring currency: if quotes are in different currencies, convert at one agreed rate and state it. Keep a version history of quotes so you can show how final pricing changed.

**Cta:** If you want to pair this with a full total-cost model or a data-driven business case from your existing ERP, Netray can discuss it. The worksheet needs no sign-up.

**Faq:**

#### How many years should an ERP TCO comparison cover?

**Answer:** Five years is common because it captures implementation, stabilization and at least one renewal. Seven to ten years may suit on-premises deployments with hardware cycles. Use the same horizon for every vendor.

#### How do I compare perpetual and subscription quotes?

**Answer:** Put both on the same time horizon. For perpetual, include the license fee in year one and annual maintenance after that, plus infrastructure and upgrade projects. For subscription, include escalators and any renewal uplift.

#### Should internal staff time be included?

**Answer:** Yes. Backfill, project team time and super-user training are real costs that differ by vendor and deployment model. Add them as a row per vendor using a consistent hourly rate so the comparison is fair.

#### What escalator should I assume if unstated?

**Answer:** Test a range, such as 3 to 8 percent a year, and note it as an assumption. Then negotiate a contractual cap so the assumption becomes a commitment rather than a guess.

## Search terms

erp vendor quote comparison, erp pricing comparison excel, erp five year cost comparison, normalize vendor quotes, erp proposal cost comparison template, erp cost comparison spreadsheet, erp tco quote worksheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json