Product price analysis for our salesmen (template in Excel)
Budget: $10 – $30 USD
Hi,
I need a simple Price modelling template in Excel.
It should be able to count our products margins - we use Navision as ERP.
A simple template, where all the articles (products) are shown in a own sheet, I know the costs of the products, but in need of the price estimate.
For example: We sell product x for 200 euros, the customer is also interested in product b. How much do we need to sell to achieve gross margin x? Many estimates will impact the price – what package of products customer wants to buy but also discounts, freight etc.
The template should also be easy to use (and update), would be nice if it can show some KPI:s also.
Products are over 400.
I need a simple Price modelling template in Excel.
It should be able to count our products margins - we use Navision as ERP.
A simple template, where all the articles (products) are shown in a own sheet, I know the costs of the products, but in need of the price estimate.
For example: We sell product x for 200 euros, the customer is also interested in product b. How much do we need to sell to achieve gross margin x? Many estimates will impact the price – what package of products customer wants to buy but also discounts, freight etc.
The template should also be easy to use (and update), would be nice if it can show some KPI:s also.
Products are over 400.