Scribd Logo
Upload

Welcome to Scribd!

  • 23 views

    Assignment 1 Tabulation Sheet

    Uploaded by

    KALIDAS MANU.M
    The document contains a tabulation of data collected for an assignment on supply chain management. It includes details of products selected, retailers surveyed, stock information, sales data, and calculations of supply chain length for each product at each retailer. Key observations are that supply chain length is lower for lower life span products and higher for higher life span products. Organized retailers have more sales, stocks, and larger inventories than unorganized retailers. Milk sales are higher everywhere due to it being an essential product. The unorganized sector has a higher supply chain length for Appy Fizz possibly due to lower demand.

    Copyright:

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

    Assignment 1 Tabulation Sheet

    Uploaded by

    KALIDAS MANU.M
    23 views10 pages
    The document contains a tabulation of data collected for an assignment on supply chain management. It includes details of products selected, retailers surveyed, stock information, sales data, and calculations of supply chain length for each product at each retailer. Key observations are that supply chain length is lower for lower life span products and higher for higher life span products. Organized retailers have more sales, stocks, and larger inventories than unorganized retailers. Milk sales are higher everywhere due to it being an essential product. The unorganized sector has a higher supply chain length for Appy Fizz possibly due to lower demand.

    Original Title

    Assignment 1 Tabulation sheet.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a tabulation of data collected for an assignment on supply chain management. It includes details of products selected, retailers surveyed, stock information, sales data, and calculations of supply chain length for each product at each retailer. Key observations are that supply chain length is lower for lower life span products and higher for higher life span products. Organized retailers have more sales, stocks, and larger inventories than unorganized retailers. Milk sales are higher everywhere due to it being an essential product. The unorganized sector has a higher supply chain length for Appy Fizz possibly due to lower demand.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    23 views10 pages

    Assignment 1 Tabulation Sheet

    Uploaded by

    KALIDAS MANU.M
    The document contains a tabulation of data collected for an assignment on supply chain management. It includes details of products selected, retailers surveyed, stock information, sales data, and calculations of supply chain length for each product at each retailer. Key observations are that supply chain length is lower for lower life span products and higher for higher life span products. Organized retailers have more sales, stocks, and larger inventories than unorganized retailers. Milk sales are higher everywhere due to it being an essential product. The unorganized sector has a higher supply chain length for Appy Fizz possibly due to lower demand.

    Copyright:

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

    ME3126D SUPPLY CHAIN MANAGEMENT

    Assignment 1
    Tabulation of data collected as a part of the Assignment

    Name of the Students:


    (1) KALIDAS MANU M Roll No. B190583PE
    (2) Vaishnav Krishnan MT Roll No. B190834ME

    FMCG Products selected


    Product 1: Milma Milk

    Product 2: Appy Fizz (Apple juice drink)

    Details of the Retailers (Provide the name and address/location)

    Retailer (R1) in the Organised sector (1): F. S store,8, Pandalam - Kaippattoor Road, Pandalam, Kerala 689501

    Retailer (R2) in the Organised sector (2): Ayyapa consumer supermarket,Kaveri Building, Pandalam, Pathanamthitta - 689501 (Near
    Manikandanalthara)

    Retailer (R3) in the Unorganised sector (1) : Babu store, Indirajunction,kadakkadu, pandalam,pathanamthitta, kerala,689501

    Retailer (R3) in the Unorganised sector (2): Prime Mart,between chitra hospital and estilo flat, Kurampala Rd, Pandalam, Kerala 689501
    (1) (2) (3) (4) (5) (6) (1) (2) (3) (4) (5) (6)
    Length
    Numb Length
    Number Numb Number of
    Date of er of Approx. of Date of Approx.
    of SKUs Location of er of of SKUs Location of Supply
    Packing/mf units sales/ for the
    Supply Packing/mf sales/ for the
    Item Manufacturer units in Manufacturer Chain
    g. in month product Chain g. month product
    stock (from A
    stock (A+B)
    to B)
    Retailer (R1) Retailer (R2)
    Product 22-1-2022 39 468 4 Pathanamthitta 0.2500 2-2-2022 30 420 3 Pathanamthitta 0.16901
    1 Diary,Mamoodu Diary,Mamoodu,
    , Nariyapuram
    Nariyapuram p.o,
    p.o, Pathanamthitta
    Pathanamthitta
    Product 31-12-2021 37 320 9 Parle Agro 0.9578 21-01-2022 25 250 10 Parle Agro 1.6187
    2 PVT.LTD,Srioer PVT.LTD,Srioer
    umudur-602105 umudur-602105
    ,Tamilnadu ,Tamilnadu

    Retailer (R3) Retailer (R4)


    Product 03-02-2022 19 238 1 Pathanamthitta 0.1399 20-1-2022 24 246 2 Pathanamthitta 0.28211
    1 Diary,Mamoodu Diary,Mamoodu,
    , Nariyapuram
    Nariyapuram p.o,
    p.o, Pathanamthitta
    Pathanamthitta
    Product 15-11-2021 10 30 4 Parle Agro 2.93336 11-12-2021 18 90 6 Parle Agro 2.622
    2 PVT.LTD,Srioer PVT.LTD,Srioer
    umudur-602105 umudur-602105
    ,Tamilnadu ,Tamilnadu
    Length of supply chain contains two components A and B. The component A can be estimated with the manufacturing/packing date and date on which you visit the
    retailer and see the product. The component B is time of sale and is to be estimated with the approx. sales/month and number of stocks available. This estimate provides
    the maximum time a product can be there on shelf.
    ● Insert the image of that part of the Product 1 which exhibits the date of packing/manufacturing
    and the details of the manufacturer.
    Sample calculation

    Retailer(1),product 1:

    for A,

    Date of manufacture: 31-12-2021

    Date of visit: 27-1-2022

    A = 5days = 0.1667 months

    for B,

    Approximate sales/month = 468

    No. of units of stock = 39

    B= (stock/sales)/2 =(39/468)/2 = 0.0833

    Therefore length of the supply chain = 0.25003 months

    Retailer(2),product 1:

    for A,

    Date of manufacture: 2-2-2022

    Date of visit: 06-02-2022

    A = 4days = 0.1333 months

    for B,

    Approximate sales/month = 420

    No. of units of stock = 30

    B= (stock/sales)/2 =(30/420)/2 = 0.03571

    Therefore length of the supply chain = 0.16901 months


    Retailer(3),product 1:

    for A,

    Date of manufacture: 03-02-2022

    Date of visit: 06-02-2022

    A = 3 days = 0.1 months

    for B,

    Approximate sales/month = 238

    No. of units of stock = 19

    B= (stock/sales)/2 =(19/238)/2 = 0.039915

    Therefore length of the supply chain =0.1399 months

    Retailer(4),product 1:

    for A,

    Date of manufacture: 20-1-2022

    Date of visit: 27-1-2022

    A = 7days = 0.2333 months

    for B,

    Approximate sales/month = 246

    No. of units of stock = 24

    B= (stock/sales)/2 =(24/246)/2 =0.0487

    Therefore length of the supply chain =0.28211


    ● Insert the image of that part of the Product 2 which exhibits the date of packing/manufacturing
    and the details of the manufacturer.
    Sample calculation

    Retailer(1),product 2:

    for A,

    Date of manufacture: 31-12-2021

    Date of visit: 27-1-2022

    A = 27days = 0.9 months

    for B,

    Approximate sales/month = 320

    No. of units of stock = 37

    B= (stock/sales)/2 =(37/320)/2 =0.0578125

    Therefore length of the supply chain = 0.9578 months

    Retailer(2),product 2:

    for A,

    Date of manufacture: 21-01-2022

    Date of visit: 06-02-2022

    A = 47days = 1.5667 months

    for B,

    Approximate sales/month = 250

    No. of units of stock = 26

    B= (stock/sales)/2 =(26/250)/2 =0.052

    Therefore length of the supply chain = 1.6187months


    Retailer(3),product 2:

    for A,

    Date of manufacture: 15-11-2021

    Date of visit: 06-02-2022

    A = 83 days = 2.7667 months

    for B,

    Approximate sales/month = 30

    No. of units of stock = 10

    B= (stock/sales)/2 =(10/30)/2 = 0.1667

    Therefore length of the supply chain = 2.93336 months

    Retailer(4),product 2:

    for A,

    Date of manufacture: 11-12-2021

    Date of visit: 27-1-2022

    A = 77days = 2.5667months

    for B,

    Approximate sales/month = 90

    No. of units of stock = 10

    B= (stock/sales)/2 =(10/90)/2 =0.0555

    Therefore length of the supply chain = 2.622 months


    List down your observations from the above tabulations.
    1. When compared to the lower life span products , their supply chain length is lower than the higher life
    span products.
    2. When comparing the organised and unorganised sectors, organised has more sales and stocks.
    3. Sales per month of milk is higher in every shop as it is an essential product in day to day life.
    4. Organized sectors are having large inventory compared to the unorganized sectors and so more
    stocks are there.
    5. In the case of Appy fizz the unorganised sector is having higher supply chain length, it could be
    because of the lack of demand there when compared with the organised sector. And in the case of
    milk this length is almost the same everywhere, as it is an essential commodity.

    You might also like