skip to Main Content

Wholesale Price Calculator

3.67 (3 reviews)

Wholesale Price Calculator will help you to measure your profitability before submitting pricing quotes. Analyze each item and set prices in Excel.

Learn more about License Types

Buy Modifiable Version Buy Modifiable Version
PRODUCT DESCRIPTION

Wholesale Price Calculator Template is a tool to calculate your wholesale offer details once you set the inputs. The only thing you have to do is input all the products you or your business are providing into the database with its unit price and unit cost.

Once the details of the trade are also input, it will be much easier to check to see the price offer results.

wholesale-price-calculator-flow-1Also, the impact of a new product in the wholesale offer could be easily seen by the dynamic change in the top right corner.

Database:

This section helps you to register all your products with its unit price and unit cost which later you can use in the dashboard section. The products which have been input into the database could be chosen by a drop-down menu in the dashboard section.

Wholesale-Price-Calculator-Template-S01

Dashboard

The dashboard will give you access to choose the products that you input in the database section. You will be able to select items from the drop down menus under Product Description column. Once you choose, the Unit Price and Unit Cost will show up on the dashboard.

Wholesale-Price-Calculator-Template-S02

When you input all the details of the wholesale — the quantity of each product you sold and discount percentage for each product (if there is any), the template will give you the details of the trade such as Total Quantity, Revenue, Profit and Average Profit (%).

Wholesale Price Calculator Excel Template Features:

  • Easy to use Price Offer Template
  • Provides overview of average profitability
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

This Wholesale Price Calculator is 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.

USER REVIEWS

3 reviews for Wholesale Price Calculator

  1. Jenny Scott

    I purchased this template. But, when I tried to add more information to it, I realized that It doesn’t allow me to add more sheets and this is not what I expected. Also, I have to use the same template and save it per different projects individually instead of having a track of it in the same file.

    • Someka

      Hi Jenny, thanks for your review!
      Did you unlock the template with the password you received?

      Firstly, you should unlock the template to be able to add more sheets, rows/columns, etc. Please follow these steps: unlock the template > open the sheet tabs > display the headings. You should use the little plus sign on the left side of the template to add new rows. We have shown how to do it on Wholesale Calculator – product video, so please do not forget to have a look at it as well.

      Besides that, you can use one file if you would like to see the total offer summary for multiple projects at the same time. But, it is not possible to do each project separately in the same template. We recommend using the template for each project as a different name in such cases. Hope that helps!

    • Jenny

      I didn’t realize that I have to unlock it before modification. I unlocked it and added new sheets for my personal info and tables. It is more useful now with my changes. thanks!

  2. leung

    may i know how to do the following?
    1. add a column/ row inside the form
    2. Display like a normal excel table which has A to Z and 1-9999 axis and open some sheets underneath??

    • Someka

      Hi Leung,
      Let us answer your questions!
      To do all of the modifications, you need to unlock both worksheets and the workbook first: How can I unlock the sheets? What is the password?

      Q1: Now, you will be able to click the plus sign on the left side of the template to add more rows. Besides that, you can also add new columns by right click > insert.

      Q2: We guess you would like to open headings and display sheet tabs to make the sheet more like the original excel appearance.

      Hope that helps! We will be happy to answer if you have further questions.
      Regards,

  3. Abdu

    Nice!!!

Leave a customer review

Your email address will not be published. Required fields are marked *