Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    Blank Dna Format

    Uploaded by

    Dhruv Aryan
    This document summarizes sales data for various beverage products for a distributor named Shiv Kumar Pareek for April 2011. It shows the number of crates and amounts sold of different bottle sizes of glass bottles, CSD PET bottles, cans, sodas, nimbu paani, slices, Tropicana, Aquafina and BIB products. It also lists expenses incurred for various advertising and promotion schemes for the month. The total sales amount for the period was Rs. 257,506 and total advertising and promotion expenses amounted to Rs. 44,120.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Blank Dna Format

    Uploaded by

    Dhruv Aryan
    25 views15 pages
    This document summarizes sales data for various beverage products for a distributor named Shiv Kumar Pareek for April 2011. It shows the number of crates and amounts sold of different bottle sizes of glass bottles, CSD PET bottles, cans, sodas, nimbu paani, slices, Tropicana, Aquafina and BIB products. It also lists expenses incurred for various advertising and promotion schemes for the month. The total sales amount for the period was Rs. 257,506 and total advertising and promotion expenses amounted to Rs. 44,120.

    Original Title

    Blank Dna Format(1)

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes sales data for various beverage products for a distributor named Shiv Kumar Pareek for April 2011. It shows the number of crates and amounts sold of different bottle sizes of glass bottles, CSD PET bottles, cans, sodas, nimbu paani, slices, Tropicana, Aquafina and BIB products. It also lists expenses incurred for various advertising and promotion schemes for the month. The total sales amount for the period was Rs. 257,506 and total advertising and promotion expenses amounted to Rs. 44,120.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    25 views15 pages

    Blank Dna Format

    Uploaded by

    Dhruv Aryan
    This document summarizes sales data for various beverage products for a distributor named Shiv Kumar Pareek for April 2011. It shows the number of crates and amounts sold of different bottle sizes of glass bottles, CSD PET bottles, cans, sodas, nimbu paani, slices, Tropicana, Aquafina and BIB products. It also lists expenses incurred for various advertising and promotion schemes for the month. The total sales amount for the period was Rs. 257,506 and total advertising and promotion expenses amounted to Rs. 44,120.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 15

    Name Of TDM shiv kumar pareek

    For The Month of: APR 2011 1/4/2011 TO 17/4/2011

    Particulars Glass Bottle C


    SLICE 300 ML
    Pack Size/Product
    200ML 250ML 300ML Soda Total 500ML
    Detail in Crates
    Total Sale -Secondary - -
    Total Sale -Tertiary 3,993 - - - 3,993 -

    Expenses of D&A
    Scheme Amount 33,620 - - - 33,620 -
    DISCOUNT/KEY/MARKET/MODERN 10,500 - - - 10,500 -
    Dealer Incentive - -
    aqfina diff - -
    dirty c/s -
    -
    -
    Total D&A 44,120 - - - 44,120 -
    D&A PER C/S Secondary #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    D&A PER C/S Tertiary 11.04934 #DIV/0! #DIV/0! #DIV/0! 11.04934 #DIV/0!

    500ml sl 100 c/s for 2b/s a/f =4800


    5ooml sl 400 c/s for 12 b/s a/f 57600
    500 ml sl 110 c/s 4 b/s a/f 5280
    total 67680
    VARUN BEVERAGES LIM
    Monthly DNA Report by

    CSD PET CAN SODA

    600 ML 1.0 LTR 2 LTR. 2.25 LTR Total 250 ML 330ML Total 600ML 1.5LTR

    - -
    1,490 461 447 780 3,178 30 - 30 43 -

    -
    54,502 11,288 16,855 36,824 119,469 358 - 358 508 -
    2,800 1,050 1,400 1,750 7,000 105 105 70
    - -
    - -
    -
    - -
    - -
    57,302 12,338 18,255 38,574 126,469 463 - 463 578 -
    #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    38.45772 26.76356 40.83893 49.45385 39.79515 15.43333 #DIV/0! 15.43333 13.44186 #DIV/0!
    N BEVERAGES LIMITED
    hly DNA Report by TDM

    SODA Nimboo SLICE


    200ML 350
    Total 200ML TETRA 350ML 1.2LTR 200ML TETRA 500ML SLICE 1.2LTR

    - -
    43 - - 200 - 10 225 610 10 199

    -
    508 - - 4,280 - 189 4,270 67,680 117 7,365
    70 - - - 125 300 - 350
    -
    -
    -
    -
    -
    578 - - 4,280 - 189 4,395 67,980 117 7,715
    #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    13.44186 #DIV/0! #DIV/0! 21.4 #DIV/0! 18.9 19.53333 111.4426 11.7 38.76884
    TROPICANA AQUA FINA BIB GRAND

    Total 200ML T 1 L TETRA Total 500ML 750ML 1.0LTR Total TOTAL

    - - - -
    1,254 - - - - - 1,040 1,040 9,538
    - - -
    - - -
    83,901 - - - - - 1,200 1,200 239,056
    775 - - 18,450
    - - - - -
    - - - - -
    - - - -
    - - - -
    - - - -
    84,676 - - - - - 1,200 1,200 257,506
    #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    67.52472 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1.153846 1.153846 #DIV/0! 26.9979
    200ML 300ml 1 LTR 2 LTR
    TDM

    TOTAL TDM 0 0 0 0 0 0 0 0
    2 LTR 1.2 LTR 200 ML NIMBOOZ NTP NIMBOOZ 330 CAN 200 tropicana

    0 0 0 0 0 0 0 0 0 0
    200 tropicana 1000 tropicana 1200 nimbooz 600 500 SLICE 250 CAN

    0 0 0 0 0 0 0 0 0 0
    250 CAN 350 NIMBOOZ 600 SODA 1500 SODA TOTAL
    TOTAL AMOUNT
    0
    0
    0
    0
    0
    0 0 0 0 0 0 0 0 0
    0
    A&M SALE& AMOUT

    Glass Bottle
    TDM CITY OUTLET NAM 200 ML 250 SLICE ML
    SALE AMOUNT SALE AMOUNT
    Bottle CSD PET
    300 ML 300ML SODA 600 ML 1 LTR 2 LTR
    SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE
    D PET CAN SODA
    2 LTR 2.25 LTR 250 CAN 330 CAN 600ML SODA
    AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT
    SODA Nimboo
    1.5LTR SODA 200ML NIMBOOZ TETRA NIMBOOZ 350ML NIMBOOZ 1.2 LTRL NIMBOOZ
    SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE
    SLICE
    1.2 LTRL NIMBOOZ 200ML SLICE (RGB) TETRA SLICE 500 ML SLICE 350 SLICE
    AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT
    TROPICANA AQUA FINA
    1.2 LTR SLICE 200 ML TRO 1 LTR TRO 500ML 750ML
    SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE AMOUNT SALE
    AQUA FINA BIB
    750ML 1.0LTR PMX
    AMOUNT SALE AMOUNT SALE AMOUNT

    You might also like