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 the Margin Calculator, first 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?
A few calculations may 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:
Within the formula, you can reference previously built custom calculations, lookup fields, hierarchy and attributes and use any of the functions listed in the formula builder.
To convert a field from one currency to another you can reference the exchange rates stored in your Exchange Rates table by adding 'exchange_currency' and selecting the currencies you are converting.
For example:
When referencing currency fields in a formula the $ symbol must be added first
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 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 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 margin calculator allows only numerical values to be created at this stage.
Can I reorder the product fields in my Range Plan product card?
Can I reorder 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
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?
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.