This Basic Price Comparison Template for Excel will help you while purchasing goods or services at very reasonable prices. Thanks to this template, you will be able to compare prices from different vendors or shops.
How to Compare Prices from Different Vendors?
Basically, you will find multiple columns within the Price Comparison Template. Each column in comparison table should refer to a different vendor. Once you type price for specific shopping items, you will find the total amount of the basket at the top of each vendor column.
On the other hand, you will find two options for comparison: Simple Comparison and Weighted Comparison. You may choose one of two, it’s completely up to your preference!
According to Simple Price Comparison Method, you will type Shopping Basket Items and Prices of the items from different vendors. At the top of each column, you will find the total amount of your basket for different vendors. As to Weighted Price Comparison Method, you will be able to type Quantity for the items in your basket. Thus, the cost comparison template will give you a weighted total amount for each vendor.
At the end of the comparison sheet, you should not skip adding some extra expense details like shipping costs or the duties, for calculating the total amount of your basket. In other words, this Cost Comparison Template will ensure you to control prices from different vendors and catch the best offer!
Full Print Ready Cost Comparison Template
Vendor Comparison Sheet
Nicely designed – Easy to use
Works both on Windows and Mac
Compatible with Excel 2007 and later
No installation needed. Ready to use.
No Macros, just a basic spreadsheet