Scribd Logo
Upload

Welcome to Scribd!

  • 148 views

    Market Size Excel

    Uploaded by

    Arham
    The document provides a template for estimating the market size for a product called "Ashirwad Atta" in Pune City. It includes sections to input data on population demographics, product penetration rates, consumption habits, and pricing to calculate the total addressable market and sales potential in rupees on both a monthly and annual basis. The template also has a section for market mapping the potential customer segments of hotels, restaurants, and caterers in different areas of Pune City.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Market Size Excel

    Uploaded by

    Arham
    148 views3 pages
    The document provides a template for estimating the market size for a product called "Ashirwad Atta" in Pune City. It includes sections to input data on population demographics, product penetration rates, consumption habits, and pricing to calculate the total addressable market and sales potential in rupees on both a monthly and annual basis. The template also has a section for market mapping the potential customer segments of hotels, restaurants, and caterers in different areas of Pune City.

    Original Title

    Market Size Excel.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides a template for estimating the market size for a product called "Ashirwad Atta" in Pune City. It includes sections to input data on population demographics, product penetration rates, consumption habits, and pricing to calculate the total addressable market and sales potential in rupees on both a monthly and annual basis. The template also has a section for market mapping the potential customer segments of hotels, restaurants, and caterers in different areas of Pune City.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    148 views3 pages

    Market Size Excel

    Uploaded by

    Arham
    The document provides a template for estimating the market size for a product called "Ashirwad Atta" in Pune City. It includes sections to input data on population demographics, product penetration rates, consumption habits, and pricing to calculate the total addressable market and sales potential in rupees on both a monthly and annual basis. The template also has a section for market mapping the potential customer segments of hotels, restaurants, and caterers in different areas of Pune City.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    Market Size Exercise Templet

    Product Name :- Ashirwad Atta Population Things to do


    Actual No. Country/State/Town/Area --> Pune City
    Urban Rural
    % Ratio Of Urban / Rural --> 0 0
    Male Female Male Female
    % Ratio of Male/Female --> 52% 48% 0 0 0 0
    Penetration of product --> 0 0 0 0 You need to collect the
    Literacy Level 0 0 0 0 data /Ratio from web &
    Digital Literacy Level 0 0 0 0 put it in respective box
    up to 15 yaer 0 0 0 0
    % Ratio of Age Group 15 Year to 30 Year 0 0 0 0
    OR Income Group OR
    Working-Nonworking 30 Year to 50 Year 0 0 0 0
    etc. 50 Year to 70 Year 0 0 0 0
    70 Year ++ 0 0 0 0
    0 0 0 0
    Frequancy of Purchase in a month --> 0 0 0 0
    Yearly Consumption --> 0 0
    Avg.Price of Product Rs.--> Total
    Estimated Business size Value Rs. --> 0 0 0
    No of Units ---> #DIV/0! #DIV/0! #DIV/0!

    For Category (Idustry) Market Potential


    =
    No.of Max Potential Buyer *Avg.Selling Price *Avg.FrequancyPurchase

    TAM Total Addresseble Market

    For Specific Company Sales Potential


    Top Down Executive opinion Method & Delphi Method (Collect the forecast from agencies)
    Bottum up

    Moving Avg.Method
    Naiv Ratio Method Currant Year * Currant Year/Last Year
    Exponetial Method
    Smoothing Method
    Market Mapping
    Industry Type Retail Company :- CCD
    Industry Size B2B Town/Area Pune City
    Market Size Per Annum 121680000
    Region West Buying Process Sample/Complex

    1 Type HORECA 2 Average No of Consumers


    Who Hotels Restaurants Caterers Who Hotels Restaurants Caterers
    Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh
    How Many How Many
    Large 20 Large 300
    Medium 5 Medium 100
    Small 5 Small 50

    3 Total No of Consumers 4 Average Consumption Per Person in Cups (50 ml) per day
    Who Hotels Restaurants Caterers Who Hotels Restaurants Caterers
    Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh
    How Many How Many
    Large 6000 Large 3
    Medium 500 Medium 2
    Small 250 Small 2

    5 Total Consumption in Cups (50 ml) Per Person per Month 26 6 Total Market Consumption in Cups (50 ml) Per Person per Month 26
    Who Hotels Restaurants Caterers Who Hotels Restaurants Caterers
    Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh
    How Many How Many
    Large 78 Large 468000
    Medium 52 Medium 26000
    Small 52 Small 13000

    7 Avg. Ticket Size per Consumption per Cups (50 ml) Per Person/ Day 20 8 Avg. Ticket Size per Consumption per Cups (50 ml) Per Person/ Month 26
    Who Hotels Restaurants Caterers Who Hotels Restaurants Caterers
    Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh
    How Many How Many
    Large 60 Large 1560
    Medium 40 Medium 1040
    Small 40 Small 1040

    9 Total Market Size Per Month 25 10 Total Market Size Per Annum 12
    Who Hotels Restaurants Caterers Who Hotels Restaurants Caterers
    Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh Where Kothrud Baner Aundh Kothrud Baner Aundh Kothrud Baner Aundh
    How Many How Many
    Large 9360000 Large 112320000
    Medium 520000 Medium 6240000
    Small 260000 Small 3120000

    You might also like