Overview
Style Arcade's new Range Plan costing calculator enables the complete product costing setup and tracking within the Range Plan. The feature enables custom creation of calculated fields with the ability to reference foreign exchange rates, custom formulas and lookup tables, allowing product costs to be tracked and updated over time.
How to Access
To access the range plan costing calculator, please go into Settings > Beta Features Toggle > Use Range Plan costing calculator โ
The following custom fields will be ready for you to set up under Settings > Hierarchy & attributes:
Exchange Rates
Calculations
Lookup rules
Exchange Rates
What is it?
The exchange rate page allows you to store exchange rates over time in a custom-built currency table. These stored rates can be applied to calculated fields within your Range Plan. Once set up, exchange rates can be stored, edited, or deleted.
Use cases
Convert pricing supplied in a foreign currency to your primary currency
Set up a global pricing list by automating currency conversions
How do you set up?
Your primary currency is base currency your conversion rates will be applied to. This is usually set up during onboarding.
Go to Settings > Hierarchy & Attributes > Exchange Rates
Add new currency
Select the currency to be added, add exchange rate & effective date
Click Add New to save this new currency to your exchange rate table.
Add new rate
Select the effective date your new exchange rate applies from & enter your new rates. Click the โ tick to apply the new rates.
The currency rate will be applied to all products in your Range Plan with a delivery date on and after the effective date.
Calculations
What is it?
A number of calculations can be required when building the cost of a product. The calculations page allows you to build custom formulas to generate calculated fields for products within your Range Plan.
Use cases
Calculate the landed cost price, target price, shipping, duty or freight costs for a product.
Convert a price from one currency to another
How do you set up?
1. Click 'New calculated field', name the field as you wish for it to appear within the Range Plan and define the field type.
Number: For all numerical fields
Price: For all currency-related fields which will also add a "spend @" metric.
Percentage %: For percentage fields
2. Start typing your custom formulas, some examples below:
Use cases | Formula |
Percentage |
|
Intake margin % | =(RRP / 1.1 (tax) - Landing Cost) / (RRP / 1.1 (tax)) |
Price |
|
Convert AU RRP to US RRP | =RRP * exchange_currency(AUD, USD) |
Round the price UP to the nearest whole number | =CEILING(RRP, $1) |
Round the price UP to the nearest 0.99 | =CEILING(RRP, $1) - $0.01 |
Round the price DOWN to the nearest whole number | =FLOOR(RRP, $1) |
Round the price DOWN to the nearest 0.99 | =FLOOR(RRP, $1) + 0.99 |
3. Once your formula is complete click 'Validate' and 'Save'.
You can also enable Manual edit in range plan to allow type over the output of this calculation.
The manual over-written figures will be highlighted in blue on the product card & can be reverted to calculated output using the revert arrow:
4. Once saved the calculated field will appear on your Range Plan product card.
โ
Lookup rules
What is it?
Lookup rules allow you to set custom fields based on a set of mapped fields & criteria.
E.g. if Category = Lipstick, Brand = YSL, then set RRP to $100
Use cases
To build freight, duty or shipping rates based on a mapped hierarchy
Set RRP or sell price based on lookup criteria
How do you set up?
1. Click 'New lookup rule', name the field as you wish for it to appear within the Range Plan and define the field type:
2. Click 'Add lookup rule' and select the first field this lookup should reference. Click the + button to add additional fields to add to your lookup rule.
3. Enter the output of the criteria and apply an effective date.
To duplicate the lookup row click the button below or click ' Add new row' to enter a new option for lookup.
Update the output value and effective date. Click + to update the output value and apply a new effective date.
Click + to update the output value and apply a new effective date.
4. Once your formula is complete click 'Validate' and 'Save'.
You can also enable Manual edit in range plan to allow others to type over the output of this calculation.
The manual over-written figures will be highlighted in blue on the product card & can be reverted to calculated output using the revert arrow:
Once saved the calculated field will appear on your Range Plan product card.
Costing Template
Once you have created all of your RP costing fields, create a template in rollups to help track, maintain and manage product costs.
FAQ ๐
Can I add free text fields as an output value?
Can I add free text fields as an output value?
The costing calculator allows only numerical values to be created at this stage.
Can I re-order the product fields in my Range Plan product card?
Can I re-order the product fields in my Range Plan product card?
Currently, the calculated fields appear in the Range Plan in order of creation.
Why are my fields not showing on the Range Plan product card?
Why are my fields not showing on the Range Plan product card?
Please check the following:
All inputs to the calculated formula have been entered for the specific product
Effective date applied if a lookup or exchange rate field is equal to or earlier than the product delivery date
Can I overwrite/edit my fields in Rollups?
Can I overwrite/edit my fields in Rollups?
Currently, all costs must be edited within the Plan view however this is being investigated and may be included in a later phase of the project.