Market Penetration Report- 3
| Cell | Cell Description |
Average Sale |
(A) Customer Qty |
(B) Customer % |
(C) Univ Qty |
(D) Univ % |
(E) Index Market |
(F) Index Avg Sale |
|---|---|---|---|---|---|---|---|---|
| 01 | SIC 5012 | $0-$250 | X | X | X | X | X | X |
| 01 | SIC 5012 | $251-$750 | X | X | X | X | X | X |
| 01 | SIC 5012 | $751-$2000 | X | X | X | X | X | X |
| 01 | SIC 5012 | $2001+ | X | X | X | X | X | X |
| 01 | SIC 5012 + Emp 1-4 | $0-$250 | X | X | X | X | X | X |
| 01 | SIC 5012 + Emp 1-4 | $251-$750 | X | X | X | X | X | X |
| 01 | SIC 5012 + Emp 1-4 | $751-$2000 | X | X | X | X | X | X |
| 01 | SIC 5012 + Emp 1-4 | $2000+ | X | X | X | X | X | X |
A= QUANTITY OF CUSTOMERS IN CELL
B= QUANTITY OF CUSTOMERS IN CELL/QUANTITY OF CUSTOMERS IN ALL CELLS
C= MARKET CELL UNIVERSE
D= MARKET CLL UNIVERSE/UNIVERSE FOR ALL CELLS
E= CUSTOMER CELL %/MARKET UNIVERSE CELL %
F= CELL AVERAGE SALE MARKET INDEX SCORE/OVERALL INDEX SCORE FOR RESPECTIVE AVERAGE-CELL GROUP
APPLICATION EXAMPLES
- MARKET INDEX:
Use when objective is to increase market penetration/share. - TOTAL SALES INDEX:
Use when objective is to maximize sales - AVERAGE SALE INDEX:
Use when objective is to increase average order size - FREQUENCY SALE INDEX:
Use when objective is to increase cross-selling
