Project Analysis Parameters

image

The project analysis can be performed on several criteria and metrics which are described below.

Base value

image

This drop-down list lets you choose the main criteria to perform the project analysis.

image

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

image

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.

image

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.




PlanogramBuilder User Guide - © Copyright zVisuel, 2001-2022