Skip to content

Cost Comparison Excel Template

4.73 (11 reviews)

Cost comparison spreadsheet in Excel. Compare prices from multiple vendors. Weighted cost analysis and printable dashboard with charts. Ready to use.

Download Free Version
One-Time Purchase
Business Subscription

Additional Services



Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

One-Time Purchase
Business Subscription
SOMEKA BUSINESS 99 $ /m

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

Get Inventory Management Bundle
someka-bundle-icon

This template is also included in bundle with special discount! See details >>

TEMPLATE DESCRIPTION

With the increasing number of available vendors in the marketplace, it is important to make sure many options are taken into consideration. So, with this Cost Comparison Excel Template, you may analyze the optimum options in whether weighted or unit-based approach.

Cost-Comparison-Template-Someka-S08

In addition, the template allows you to compare the costs between different months and reveals the monthly/yearly cost trends, with the help of customizable charts and graphs.

Cost Comparison Excel Template Features:

First of all, this template has five sections to compare the cost based on different approaches.

1. Dashboard

Particularly, you should start by specifying the vendor names, units, and currency to be used in the template. To point out, the yellow notes in the dashboard will explain to you the purpose of each section. In addition, you can choose whether or not to highlight the minimum unit cost from the “Highlight the min unit cost?” option.

Cost-Comparison-Template-Someka-S01

2. Weighted Cost Comparison in Excel

In this section, you can compare the total cost of purchasing the same items from different vendors. You should input the quantity and unit for that item first, and then the unit prices of the different vendors.

Cost-Comparison-Template-Someka-S02

The template will show the lowest total cost on the top, with a colored cell. Besides that, you can also determine the budget required for the job. You will see a warning message if the total cost of purchasing the specified items from that vendor exceeds the previously set budget.

Cost-Comparison-Template-Someka-S03

You can select the name of the desired vendor from the dropdown menu. Please do not try to delete or manually edit the grey calculation cells.

3. Unit-Based Cost Comparison

Significantly, this section allows you to compare the cost of the same item in various amounts and from different vendors. You should set the unit first, and then enter amounts and prices. You will see the lowest cost per unit and the vendor name on the right side, even if the amounts are different.

Cost-Comparison-Template-Someka-S04

Note! You can turn off highlighting the min-cost (green cells) from the dashboard section.

4. Two-Month Cost Comparison

Here, you can compare the cost of the same item in two different months. First, you should input the name of the item and units, then the unit price in different months. Thus, you can see the comparison graph, as the Cost Comparison template makes it easier to see the difference between prices in the selected months.

Cost-Comparison-Template-Someka-S05

To be able to make a successful comparison, remember to select the vendor name first. The aim is to compare the price changes of the same vendor and the same item, for two separate months.

Another key point, you can set the vendor and comparison month from the dropdown buttons.

5. Vendor-Based Bucket Cost Trend (Monthly)

This section allows you to compare the monthly cost changes of the same bucket from the same vendor, over a calendar year period. Besides that, the chart will show the minimum total cost of the current and the previous months.

Cost-Comparison-Template-Someka-S06

Item Cost Trend (Yearly)

This section shows the unit cost changes of the same item over the years. Besides that, you may also see the changes in the total cost of buying the same item list over the years. It provides you with a clear conclusion on the amount of money to be spent on the same products, across different years.

Cost-Comparison-Template-Someka-S07

Cost Comparison Template Features Summary

  • Compare the cost of the items from multiple vendors across different time periods.
  • Calculate the total cost and find the lowest option.
  • Informational notes included.
  • No installation needed. Ready to use.
  • Works both on Mac and Windows.
  • Compatible with Excel 2010 and later versions.
  • Does not include any VBA macros.

Cost Comparison Template is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

11 reviews for Cost Comparison Excel Template

  1. Narges

    super useful. it has a simple logic but sometimes we got lost using complex tolls for something easy. and this cost comparison excel template is easy and yet so helpful.

  2. Shanon S.

    This is the first time that i move to live in another country, I purchase your template and really helped me a lot. I was getting crazy just to save camera photos of items and wrote down each prices to compare.
    completely a life saver.

  3. CJ Parker

    It was 100% what I needed, and really great for those ones with low experience in pricing processes. I purchased the multi-user version and my team is really satisfied with it.

  4. Amelia Xu

    Super!

  5. Wilson Huang

    Can I change the item cost trend chart?? help

    • Someka

      Hello,
      Yes, you can change the color or the style of the chart to the desired shape of yourself.

  6. Jon Patterson

    Pls make a oninle version of this template, I need it, thanks.

    • Someka

      Hello, we are working on making the Google Sheets Version of all of Someka’s templates. We will inform you as soon as the online version gets ready.

  7. Ting Gao

    I liked the feature of showing you are over budget, it is a really nice heads-up for my clients.

  8. Samantha Soliman

    Can I add different units for my product costs?
    BTW nice job with this template.

    • Someka

      Hello, yes you can add different units from Dashboard Sheet and use the Unit table to define whatever unit that you like.
      Hope it helps you.
      If you need more help, please be in touch with us.

  9. nezih

    nice

  10. Charlie Quijano

    Thanks a lot I can used this in my work.

  11. Yamin Yu Shwe

    The best website for creating excellent excels and dashboards I have ever seen.

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES

Search