Overview
Style Arcade's new Margin Calculator enables the creation of custom fields to complete product costing setup and tracking within the Range Plan. There are 3 key segments of the tool;
Exchange Rates: Allow exchange rates to be stored over time in a custom-built currency table. These stored rates can be applied to calculated fields within your Range Plan.
Calculations: Allows you to build custom formulas and generate calculated fields to analyse costings within your Range Plan.
Lookup Rules: Allow you to create custom fields that auto populate in the Range Plan based on a set of mapped fields & criteria.
How to Access
To access, please ensure you have access to the Range Plan, Plan view.
Navigate to Settings > Hierachy & attributes. This is where you will see the 3x new pages that make up the Margin Calculator: Exchange rate, Calculations, Lookup rules.
Once you have created your custom formulas via the calculations and lookup rules pages, these fields will be visible in your Range Plan product cards and you can begin modelling your individual product costs.
If you don't have access to update role permissions, please contact an owner user within your business (you can view this information under Settings > Users). For more information, please visit this page.
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 the base currency your conversion rates will be applied. 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 or after the effective date.
Calculations
What is it?
Calculations allow you to build custom formulas to generate calculated fields for products within the Range Plan.
Use cases
Calculate the landed cost price, shipping, duty or freight costs
Convert a price from one currency to another
How do you set up?
Go into Settings > Hierarchies & Attributes > Calculations
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
Start typing your custom formulas, some examples below:
Note: When referencing currency fields in a formula, the $ symbol must be added before a number. E.g. RRP + $1
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 the range plan to allow typing over the output of this calculation.
The manually overwritten 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.
Calculations can be hidden if they are not required to be visible in the Range Plan product card. Tick/Un-tick the Visible box next to each calculation to save your preference
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 manually overwritten 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 Range Plan costing fields, create a template in Rollups to help track, maintain and manage product costs.
FAQ 🔍
Can I add text fields as part of my calculation/lookup rules?
Can I add text fields as part of my calculation/lookup rules?
The Range Plan currently only support numerical values to be created at this stage.
Can I rearrange how the fields appear on the Range Plan product card?
Can I rearrange how the fields appear on the Range Plan product card?
Unfortunately, no. 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:
Check if you've selected visible on card in Calculation or Lookup Rules.
All inputs to the calculated formula have been entered for the specific product
The effective date is 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?
Yes, you can enable manual editing when you create the calculation/lookup rules.
