Project Analysis Parameters
The project analysis can be performed on several criteria and metrics which are described below.
Base value
This drop-down list lets you choose the main criteria to perform the project analysis.
The available choices in the list depend on your loaded Price List File and Sales Figures File.
Front surface
The front area used by product, expressed in the selected Measurement unit.
|
|
Width used |
|
× |
Height used |
|
= |
Front surface |
Note: these values are based on the space taken by facings blocks including the gaps between facings if any. For example, a product measuring 10cm wide × 8cm high placed as 2 facings wide × 2 facings high, with a width gap of 1cm results in this front surface:
((10cm × 2 + 1cm) × (8cm × 2)) = 336cm2
Linear space
The width used by product, expressed in the selected Measurement unit.
For on shelf products (standard): linear space = facings block(s) width. (in the case of shelved products with multiple facings high, each row uses the same shelf and back panel slot, so we must count only the base row of the stack as using linear space)
|
|
Width used |
|
= |
Linear space |
For pegged products: linear space = facings block(s) width × facings high. (in the case of pegged products with multiple facings high, each row uses a separate backpanel slot, so we must count each row as using linear space)
|
|
Width used |
|
× |
Facings high |
|
= |
Linear space |
Note: these values are based on the space taken by each facings block including the width gaps between facings if any. For example, a product with a width of 10cm placed as 2 facings wide and a width gap of 1cm results in this linear space:
((10cm × 2) + 1cm) = 21cm
Markup forecast
The markup value by product, based on the quantity sold.
|
|
Markup (Retail price (tax excl.) - Wholesale price) |
|
× |
Quantity sold |
|
= |
Markup forecast |
Note: requires Price List File and Sales Figures File
Markup on shelf
The markup value by product, based on the number of facings (capacity).
|
|
Markup (Retail price (tax excl.) - Wholesale price) |
|
× |
Number of facings (W×D×H) |
|
= |
Markup forecast |
Note: requires Price List File
Markup percent
The markup percentage by product.
|
|
Markup (Retail price (tax excl.) - Wholesale price) |
|
/ |
wholesale price |
|
= |
Markup percent |
Note: requires Price List File
Profit margin
The profit percentage by product.
|
|
Markup (Retail price (tax excl.) - Wholesale price) |
|
/ |
Retail price (tax excl.) |
|
= |
Markup percent |
Note: requires Price List File
Quantity sold
The number of units sold by product as listed in your sales figures file.
Note: requires Sales Figures File
Retail price (tax excl.)
The selling price before tax by product.
Note: requires Price List File
Retail price (tax incl.)
The selling price with tax by product.
Note: requires Price List File
Retail value (tax excl.) forecast
The selling value before tax by product, based on the quantity sold.
|
|
Retail price (tax excl.) |
|
× |
Quantity sold |
|
= |
Retail value (tax excl.) forecast |
Note: requires Price List File and Sales Figures File
Retail value (tax excl.) on shelf
The selling value before tax by product, based on the number of facings (capacity).
|
|
Retail price (tax excl.) |
|
× |
Number of facings (W×D×H) |
|
= |
Retail value (tax excl.) on shelf |
Note: requires Price List File
Retail value (tax incl.) forecast
The selling value with tax by product, based on the quantity sold.
|
|
Retail price (tax incl.) |
|
× |
Quantity sold |
|
= |
Retail value (tax incl.) forecast |
Note: requires Price List File and Sales Figures File
Retail value (tax incl.) on shelf
The selling value with tax by product, based on the number of facings (capacity).
|
|
Retail price (tax incl.) |
|
× |
Number of facings (W×D×H) |
|
= |
Retail value (tax incl.) on shelf |
Note: requires Price List File
Sales tax rate
The sales tax by product.
Note: requires Price List File
Single item markup
The difference between buying and selling price before tax.
|
|
Retail price (tax excl.) |
|
- |
Wholesale price |
|
= |
Single item markup |
Volume used
The volume used by product, expressed in the selected Measurement unit.
Note: these values are based on the space taken by each facings block including the gaps between facings if any. For example, a product measuring 10cm wide × 8cm deep × 5cm high, placed as 2 facings wide × 3 facings deep × 2 facings high, with a depth gap of 1cm results in this volume:
((10cm × 2) × (8cm × 3 + 1cm × 2) × (5cm × 2)) = 5200cm3
|
|
Width used |
|
× |
Depth used |
|
× |
Height used |
|
= |
Volume used |
Wholesale price
The buying price by product.
Note: requires Price List File
Wholesale value forecast
The buying value by product, based on the quantity sold in your sales figures.
|
|
Wholesale price |
|
× |
Quantity sold |
|
= |
Wholesale value forecast |
Note: requires Price List File and Sales Figures File
Wholesale value on shelf
The buying value by product, based on the number of facings (capacity).
|
|
Wholesale price |
|
× |
Number of facings (W×D×H) |
|
= |
Wholesale value on shelf |
Note: requires Price List File
Modulation
Depending on the selected Base value, you can modulate the analysis result to take into account the number of facings or the space used by the products in your current project.
This is useful for example to perform space versus sales analysis.
None
Shows the direct results of the analysis selected in Base value.
Per front facing
Divides the results of the Base value analysis by the number of front facings of the product.
|
|
Base value result |
|
/ |
Number of front facings (W×H) |
|
= |
Per front facing result |
Per front surface
Divides the results of the Base value analysis by the front surface used by the product, expressed in the selected Measurement unit, squared.
|
|
Base value result |
|
/ |
Front surface used |
|
= |
Per front surface result |
Note: front surface includes the space taken by width and height gaps between facings if any.
Per linear space
Divides the results of the analysis by the linear space used by the product, expressed in the selected Measurement unit.
|
|
Base value result |
|
/ |
Linear space used |
|
= |
Per linear space result |
Note: linear space includes the space taken by width gaps between facings if any.
Per volume used
Divides the results of the analysis by the volume used by the product, expressed in the selected Measurement unit, cubed.
|
|
Base value result |
|
/ |
Volume used |
|
= |
Per volume used result |
Note: volume used includes the space taken by all gaps between facings if any.
