ATAR 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

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 processAs 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 this 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 formulaWhile 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

Related topics

Variations of the ATAR forecast – depending upon the business structure
The free Excel template for the ATAR forecast