new product forecasting
Nikhil_1806
ATARExample_April20211.xlsxATAR Example
| ATAR MODEL ILLUSTRATION | ||||||||
| Market Size | Awareness | Trial | Availability | Repeat | Quantity Purchased | |||
| 20000 | 20% | 10% | 50% | 200 | Trial Model | |||
| 20000 | 20% | 10% | 50% | 50% | 10 | 1000 | Repeat Model | |
| 1200 | Total Unit Sales | |||||||
| Financials | ||||||||
| ASSUMPTIONS | $4,428 | Retail Price | $3.69 | |||||
| Cleveland MSA Market Size | 2,000,000 | $2,214 | Trade Price | $1.85 | ||||
| % of Population Shops At Target Stores | 20% | $1,107 | Mfg Cost | $0.92 | ||||
| % of Target Shoppers Buying Reese's Mallow Cups | 5% |
