# Index and formula price inputs: commercial data & context template

> Commodity and energy indices, currency and surcharge tables, with the lag each formula uses, as governed inputs to formula pricing.

Source: https://revomo.ai/marketplace/templates/index-inputs/

---

[Marketplace](https://revomo.ai/marketplace/)[Explore](https://revomo.ai/marketplace/)[Templates](https://revomo.ai/marketplace/templates/)[Metrics](https://revomo.ai/marketplace/metrics/)

Marketplace
- [Explore](https://revomo.ai/marketplace/)
- [Templates](https://revomo.ai/marketplace/templates/)
- [Metrics](https://revomo.ai/marketplace/metrics/)

Business need
- [Margin Leakage](https://revomo.ai/marketplace/collections/margin-leakage/)
- [Cost Recovery](https://revomo.ai/marketplace/collections/cost-recovery/)
- [Price Increase](https://revomo.ai/marketplace/collections/annual-price-increase/)
- [Quote & Deal Performance](https://revomo.ai/marketplace/collections/quote-deal-performance/)
- [Contract Renewal](https://revomo.ai/marketplace/collections/contract-renewal/)
- [Rebates & Incentives](https://revomo.ai/marketplace/collections/rebates-incentives/)
- [Market Response](https://revomo.ai/marketplace/collections/market-response/)

Industry
- [Industrial distribution](https://revomo.ai/marketplace/templates/?industry=distribution)
- [Machinery & industrial products](https://revomo.ai/marketplace/templates/?industry=machinery)
- [Building products](https://revomo.ai/marketplace/templates/?industry=building)
- [Chemicals & materials](https://revomo.ai/marketplace/templates/?industry=chemicals)

Search Marketplace

- [Marketplace](https://revomo.ai/marketplace/)
- [Templates](https://revomo.ai/marketplace/templates/)
- [Commercial Data & Context](https://revomo.ai/marketplace/templates/?category=data)
- Template

## Index and formula price inputs

Commodity and energy indices, currency and surcharge tables, with the lag each formula uses, as governed inputs to formula pricing.
[See the Index and formula price inputs in Revomo →](https://revomo.ai/contact/?source=marketplace&type=template&artifact=index-inputs&name=Index+and+formula+price+inputs&collection=cost-recovery)

### The business question

Which index, at which lag, should each formula price read?

### What it does

Keeps commodity and energy indices, currency and surcharge tables as governed inputs, with the lag each contract specifies. Formula prices and surcharge triggers read one source instead of a spreadsheet per contract.

### What’s inside

Composed from the platform’s own objects, so it is a configuration you can open, not a document.
- Dataset: index series
- Dataset: surcharge tables
- View: index at the lag each contract specifies

### Commercial context required

What Revomo reads to run it. Everything else in the template is derived from these records.
- Dataset: index series
- Dataset: surcharge tables

### Relevant industries

[Chemicals & materials](https://revomo.ai/marketplace/templates/?industry=chemicals)[Machinery & industrial products](https://revomo.ai/marketplace/templates/?industry=machinery)

Type
Template

Category
[Commercial Data & Context](https://revomo.ai/marketplace/templates/?category=data)

Industries
Chemicals & materials, Machinery & industrial products

Business need
[Cost Recovery](https://revomo.ai/marketplace/collections/cost-recovery/), [Market Response](https://revomo.ai/marketplace/collections/market-response/)

Composed of
3 platform objects

[See this in Revomo →](https://revomo.ai/contact/?source=marketplace&type=template&artifact=index-inputs&name=Index+and+formula+price+inputs&collection=cost-recovery) On representative data, or a slice of your own.

### Related templates

- Commercial Data & Context #### [Landed cost model](https://revomo.ai/marketplace/templates/landed-cost/) Standard cost plus inbound freight, duty and handling, effective-dated, so margin is measured against what the unit actually cost. Distribution, Building products, Chemicals · Uses 4 metrics
- Planning & Scenarios #### [Cost pass-through scenario](https://revomo.ai/marketplace/templates/cost-pass-through/) A cost shock, the price response by segment and its timing, and the margin path in between. Chemicals, Machinery, Building products · Uses 4 metrics
- Analysis & Diagnostics #### [Freight recovery scorecard](https://revomo.ai/marketplace/templates/freight-scorecard/) Freight billed against freight paid by lane and account, and the delivered prices set before carrier rates moved. Distribution, Building products · Uses 1 metric

### See this template in Revomo.

We will show the Index and formula price inputs running on representative data, or on a slice of your own, and what it would take to run it on yours.
[See this on your commercial data →](https://revomo.ai/contact/?source=marketplace&type=template&artifact=index-inputs&name=Index+and+formula+price+inputs&collection=cost-recovery)[All templates](https://revomo.ai/marketplace/templates/)
