SALES ANALYSIS REPORT

1
SALES ANAYLSIS REPORT

• DEALER WISE SALES ANYALSIS REPORT
• YEAR- 2019-2020
• REGION GHAZIABAD

2
CONTENTS OF SALES REPORT

• PRODUCT OFFERING
• STOCK SUMMARY REPORT
• LEAD RESPONSE TIME REPORT
• SALES REPORT
• SALES TREND
• MONTHLY SALES GRAPH
• SALES COMPARISON
• YEARLY SALES PERFORMANCE MEASURE DASHBOARD
• PIPELINE REPORT FOR NEXT FY
• SALES FORECASTING PROJECTION

3
PRODUCT OFFERINGS VIVO MOBILE PHONES
4
DEALER STOCK SUMMARY REPORT
DATE10/04/2020 DATE10/04/2020 DATE10/04/2020 DATE10/04/2020 DATE10/04/2020 DATE10/04/2020 DATE10/04/2020
DEALERWISE STOCK SUMMARY REPORT DEALERWISE STOCK SUMMARY REPORT DEALERWISE STOCK SUMMARY REPORT DEALERWISE STOCK SUMMARY REPORT DEALERWISE STOCK SUMMARY REPORT DEALERWISE STOCK SUMMARY REPORT DEALERWISE STOCK SUMMARY REPORT
FROM APRIL 2019 TO MARCH 2020 FROM APRIL 2019 TO MARCH 2020 FROM APRIL 2019 TO MARCH 2020 FROM APRIL 2019 TO MARCH 2020 FROM APRIL 2019 TO MARCH 2020 FROM APRIL 2019 TO MARCH 2020 FROM APRIL 2019 TO MARCH 2020
             
SR NO PRODUCT NAME OPENING STOCK PURCHASE BALANCE CONSUMPTION CLOSING STOCK
    QTY QTY QTY QTY QTY
1 VIVO MX1 550 600 1150 950 200
2 VIVO MX2 700 800 1500 1450 50
3 VIVO MX3 250 200 450 350 50
4 VIVO MX 4 900 200 1100 1050 50
5 VIVO MX 5 1000 500 1500 1350 150
  SIDDHI ENTERPRISES          
             
1 VIVO MX1 600 550 1150 950 200
2 VIVO MX2 800 700 1500 1400 100
3 VIVO MX3 200 250 450 400 50
4 VIVO MX 4 200 900 1100 950 150
5 VIVO MX 5 500 1000 1500 1450 50
  RIDDHI ENTERPRISES          
5
LEAD RESPONSE TIME REPORT

• TO CALCULATE THE LEAD RESPONSE TIME RATE,YOU TAKE
  THE TOTAL AMOUNT OF TIME BETWEEN LEAD
  CREATION,AND FIRST RESPONSE,FOR ALL THE LEADS
  THAT WERE ASSIGNED TO A DEALER,AND DIVIDE THAT BY
  THE TOTAL NUMBER OF LEADS RESPONDED TO.

6
DEALERWISE SALES FOR FY 2019-2020
SIDHHI ENTERPRISES SIDHHI ENTERPRISES RIDHHI ENTERPRISES RIDHHI ENTERPRISES
       
MONTHLY TARGET MONTH 2019-2020 MONTH 2019-2020 MONTH 2019-2020 MONTH 2019-2020
100000 APR 70000 APR 65000
100000 MAY 75000 MAY 70000
100000 JUNE 90000 JUNE 80000
100000 JULY 50000 JULY 100000
100000 AUGUST 100000 AUGUST 85000
100000 SEPTEMBER 60000 SEPTEMBER 90000
100000 OCTOBER 85000 OCTOBER 80000
100000 NOVEMBER 65000 NOVEMBER 75000
100000 DECEMBER 70000 DECEMBER 100000
100000 JANUARY 75000 JANUARY 70000
100000 FEBRUARY 100000 FEBRUARY 85000
100000 MARCH 80000 MARCH 75000
7
SALES TREND
8
SALES TREND
9
MONTHLY SALES GRAPH
10
(No Transcript)
11
YEARLY SALES PERFORMANCE MEASURE DASHBOARD

• SALES TARGET

• OF TARGET ACHIEVED DEFICIT

• 18,95,000 24,00,000

• 79
  5,05,000

12
PIPELINE REPORT FOR FY 2020-2021
FY 20-21          
PRODUCT DEALER NAME DEAL STAGE PRODUCT QTY PRODUCT PRICE EXPECTED BUSINESS
VIVO MX1 SIDDHI ENTERPRISES CONTACTED 1200 11500 13800000
VIVO MX2 SIDDHI ENTERPRISES PROPOSAL SENT 900 12500 11250000
VIVO MX3 SIDDHI ENTERPRISES DECISION MAKER BROUGHT IN 800 13000 10400000
VIVO MX4 SIDDHI ENTERPRISES NEGOTIATION 600 15000 9000000
VIVO MX5 SIDDHI ENTERPRISES DECISION PENDING 750 16500 12375000
          56825000
           
           
FY 20-21          
PRODUCT DEALER NAME DEAL STAGE PRODUCT QTY PRODUCT PRICE EXPECTED BUSINESS
VIVO MX1 RIDDHI ENTERPRISES CONTACTED 950 11500 10925000
VIVO MX2 RIDDHI ENTERPRISES PROPOSAL SENT 1050 12500 13125000
VIVO MX3 RIDDHI ENTERPRISES DECISION MAKER BROUGHT IN 850 13000 11050000
VIVO MX4 RIDDHI ENTERPRISES NEGOTIATION 550 15000 8250000
VIVO MX5 RIDDHI ENTERPRISES DECISION PENDING 650 16500 10725000
          54075000
13
SALES FORECASTING PROJECTION

• SIDDHI ENTERPRISES

• RIDDHI ENTERPRISES

• FUTURE PROJECTIONS OF THIS DEALER SHOWS THAT ITS
  A WORKABLE BUSINESS ENTITY AND IT HAS ENOUGH
  CUSTOMERS AND SATISFIES THEM WELL WITH ITS
  PRODUCTS AND SERVICES IN ORDER TO RETAIN
  THEM.WITH THE KIND OF BUSINESS PIPELINE THAT THIS
  DEALER HAS ,EASILY THEY CAN COVER LAST YEARS
  SHORTFALL AND WILL OVER ACHIEVE THIS YEARS
  REVENUE TARGET BY ALMOST BY 40 AS PREDICTED.

• FUTURE PROJECTIONS OF THIS DEALER SHOWS THAT ITS
  A WORKABLE BUSINESS ENTITY AND IT HAS ENOUGH
  CUSTOMERS AND SATISFIES THEM WELL WITH ITS
  PRODUCTS AND SERVICES IN ORDER TO RETAIN
  THEM.WITH THE KIND OF BUSINESS PIPELINE THAT THIS
  DEALER HAS ,EASILY THEY CAN COVER LAST YEARS
  SHORTFALL AND WILL OVER ACHIEVE THIS YEARS
  REVENUE TARGET BY ALMOST BY 35 AS PREDICTED.

14
THANK YOU