ATAR Forecast Model Formula

The ATAR Forecasting Model Formula

The ATAR forecasting model is generally used to help marketers forecast sales volumes, sales revenue and profit contribution – primarily for new products, but it can essentially be used for any marketing campaign or project.

The letters in the ATAR model stand for

  • A = Awareness
  • T = Trial
  • A = Availability
  • R = Rebuy or Repeat

Get the free ATAR forecasting model: Free Download: ATAR Model Excel Template


Expressed in percentages or decimals

These four main components of the ATAR model are presented in a percentage (or decimal) form.

For example, awareness of 60% of the new product, potentially trialed by 20% of consumers, 75% availability within stores, with 50% of consumers (trialing product at least once) and then continuing to rebuy/repurchase the product on a regular or occasional basis.

Multiplied together to determine size of ongoing customer base

The four components of the ATAR are multiplied together to generate the end percentage of target market consumers that will become the new product’s ongoing customer base.

Essentially, the size of the customer base is what the ATAR components should estimate, and along with the other data – see section below – profitability, sales units, sales revenue, and so on can be determined.

Using the example percentages above, if we started with a target market size of 10 million consumers, then ongoing customer base (in consumers, not sales) would be calculated as:

  • 10 million consumers (in the target market = buying units)
  • X 60% awareness
  • X 20% trial
  • X 75% availability
  • X 50% repeat/rebuy

By multiply each of these ATAR components, this would work out to be:

  • Start with 10,000,000 consumers
  • 6 million consumers aware of the new product(10m X 60%)
  • 1.2 million consumers willing to trial the products (6m X 20%)
  • 900,000 consumers finding the product “available” in a store and trailing the product (1.2 m X 75%)
  • And finally 450,000 ongoing customers (from light to heavy users) (900,000 X 50%)

atar process

 

As you can see, the ATAR forecasting model essentially breaks down the overall target market progressively, using the four inputs of awareness – trial – availability – repeat/rebuy – to estimate the size of the ongoing customer base.

For example: If we multiply the four ATAR components above, we would get 60% X 20% X 75% 50% = 4.5%.

This tells us that we expect to have 4.5% of the total target market (number of buying units) becoming our ongoing customer base, as shown in the above example (where 4.5% of the 10 million consumers = 450,000 customers).

This concept is illustrated in the above diagram.

Based on marketing assumptions

The reason that the ATAR formula and its components are attractive to marketers is because it produces a relatively robust financial projection that is primarily based on marketing inputs.

This then allows the marketing team to construct a launch program designed to meet these marketing goals. It also allows for beautification key marketing targets and a marketing “control contingency” plan to be put into place prior to the new product launch.

ATAR forecast requires several years of assumptions

The ATAR approach to new product forecasting, like most approaches to forecasting, requires a forecast over several years (usually 2 to 5 years)– depending on the type of product, the firm and the industry involved.

Obviously, at times, management would like to see forecasts further into the future, but sales and profit forecasts generally become more unreliable after a 5 year horizon due to the dynamic nature of markets, shifting consumer needs, new technology development and innovation, as well as competitive actions.

As you will see when you’re using the free Excel template for the ATAR forecast, you will need to enter your financial assumptions from year 0 to year 5.

Further data inputs required to complete the ATAR forecast

 

atar model formula

While these four letters (ATAR) these are the core assumptions and inputs into the sales forecasting model, the

ATAR model requires further inputs to calculate the sales and profit projections.

The additional information required is:

  • The number of consumers/buying units in the marketplace
  • The loyalty rate of your customer base over time
  • The average purchase quality per buying unit/consumer
  • The average price and cost per unit – to determine margin per unit
  • Expected promotional spend/budget
  • Likely product cannibalization rate, if applicable

What is the ATAR forecast model?

The ATAR forecast model is a marketing model that stands for Awareness, Trial, Availability, and Repeat. It is a framework used to forecast and analyze the potential success of a new product or service in the market.

Here’s a breakdown of each component:

1. Awareness: This refers to the level of consumer knowledge or recognition of a particular product or brand. It measures the extent to which the target market is aware of the product’s existence and its features.

2. Trial: Trial represents the initial purchase or usage of the product by consumers. It focuses on encouraging potential customers to try the product for the first time, often through promotional activities, free samples, or trial offers.

3. Availability: Availability refers to the accessibility and distribution of the product. It considers factors such as the product’s physical availability in stores or online, the ease of purchasing or obtaining it, and the overall convenience for customers.

4. Repeat: Repeat refers to the likelihood of customers repurchasing the product or becoming loyal to the brand. It measures the rate at which customers continue to buy the product after the initial trial, indicating their satisfaction and loyalty.


Find Out More About ATAR Forecasts

Scroll to Top