mis report on pepsi updated

Upload: vipul-kanojia

Post on 03-Apr-2018

251 views

Category:

Documents


2 download

TRANSCRIPT

  • 7/28/2019 Mis Report on Pepsi Updated

    1/53

  • 7/28/2019 Mis Report on Pepsi Updated

    2/53

    VIPUL KANOJIA,

    MBA, A II SEM,

    ROLL NO :6036,

    PUNJABI UNIVERSITY

    SUBMITTED TO:

    MR SAHIL.

    Contents:

    TOPIC Page no.

    1. Product Mix ofPepsico. 3

    2. Pepsico in India .. 4

    3. Companys Background .. 5-9

    2 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    3/53

    4. Introduction to Channo Plant . 10

    5. Process of Potato .. 11-20Chips

    6. Process of Kurkure .. 21-25

    7. Stores andInventory Management .. 26-47

    8. Suggestions for 49

    Improvement

    9. SWOT analysis ofPepsico. . 50-53

    Product Mix of Pepsico

    3 | P a g e

    - Pepsi

    - Mirinda

    - M.Dew

    - 7up

    - Slice

    - Aquafina

    - Lays

    - Cheetos

    -Uncle chips

    - Kurkure

    - Twisteez

    - Tr. Pure

    Premium Juice.

    -Tr. Smoothies

    - Dole Juices

    - Twister Juice

    - Oatmeal

    - Square Cereals

    - Honey net

    Heaven- Instant oatmeal

    -Thirst

    Quencher

    - Xtremo

    - Propel FitnessWater.

    -Frost

  • 7/28/2019 Mis Report on Pepsi Updated

    4/53

    PepsiCo snacks division has classified its products broadly in three categories as

    Western, Extruded and Traditional. A new variety of biscuit is also launched with

    the brand name ALIVA.

    PepsiCo in INDIA

    PepsiCo entered India in 1989 and has grown to become one of the countrysleading food and beverage companies. One of the largest multinationalinvestors in the country, PepsiCo has established a business which aims toserve the long term dynamic needs of consumers in India.

    PepsiCo India and its partners have invested more than U.S.$1 billion sincethe company was established in the country. PepsiCo provides direct andindirect employment to 150,000 people including suppliers and distributors.

    PepsiCo nourishes consumers with a range of products from treats to healthyeats,that deliver joy as well as nutrition and always, good taste. PepsiCoIndias expansive portfolio includes iconic refreshment beverages Pepsi, 7UP, Mirinda and Mountain Dew, in addition to low calorie options such asDiet Pepsi, hydrating and nutritional beverages such as Aquafina drinking

    water, isotonic sports drinks - Gatorade, Tropicana100% fruit juices, andjuice based drinks Tropicana Nectars, Tropicana Twister and Slice

    4 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    5/53

    PepsiCos foods company, Frito-Lay, is the leader in the branded salty snackmarket and all Frito Lay products are free of trans-fat and MSG. Itmanufactures Lays Potato Chips, Cheetos extruded snacks, Uncle Chipps

    and traditional snacks under the Kurkure and Lehar brands. Thecompanys high fibre breakfast cereal, Quaker Oats, and low fat and roastedsnack options enhance the healthful choices available to consumers.

    The group has built an expansive beverage and foods business. To support itsoperations, PepsiCo has 43 bottling plants in India, of which 15 are companyowned and 28 are franchisee owned. In addition to this, PepsiCos Frito Layfoods division has 3 state-of-the-art plants.

    PepsiCos business is based on its sustainability vision of Makingtomorrow better than today.

    Companys Background

    Fritos Company:

    5 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    6/53

    In the summer of 1932, Elmer Doolin stopped for lunch in a small San Antonia caf,

    while waiting for his 5 cent sandwich; he noticed a plain package of corn chips on

    the counter. He spent 5 cents to buy the package that changed the course of his life

    forever.

    In 1938, a businessman was eager to sell the recipe for $100, which he had to

    borrow. Mr. Doolin bought the recipe and 19 retail accounts plus the manufacturing

    equipment, an old converted hand-operated potato ricer. The first manufacturing

    plant for FRITOS brand corn chips was the kitchen of Mr. Doolins mother.

    Production capacity was about 10 pounds per hour, with total sales, increased

    production was required. Mr. Doolin developed a press that was more efficient than

    the potato ricer with a hammer to cut strips of corn dough.

    After this the Frito Company experienced continuous expansions and the head

    quarters moved from San Antonio to Dollas. Before his death in 1959 Elmer

    Doolins Frito corn chips had become one of Americas most popular snack foods

    and the Frito Company was established as the leader in the snack food industry.

    H.W. Lay & Company:

    Herman Lay was founder of H.W. Lay & company in Atlanta. Herman Lay beganhis business by selling potato chips from an old touring car. By 1934, with six snack

    food routes, he was on his way to become a major distributor for an Atlanta potato

    chip manufacturer.

    In 1938, the Atlanta manufacturer developed financial problems, hence threatening

    his major source of potato chips and snack foods. Financial arrangement was made

    by Mr. Lay through business associates and his friends who allowed him to buy the

    business and changed its name to H.W. Lay & Co. By putting profits back into the

    business it helped business to expand. The H.W. Lay & Company soon became one

    of the largest snack and convenience food companies in the South East, with its

    primary product being LAYS brand potato chips.

    Merger of Fritos Co. and H.W. Lay & Co.:

    6 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    7/53

    In 1945 the Fritos Co. granted H.W. Lay & Company one of the first exclusive

    franchises to manufacture and distribute FRITOS CORN CHIPS in the south east.

    As the two companies worked towards national distribution, a close business

    affiliation developed which eventually resulted in a merger. Also, both companies

    were built on the same basic business philosophy, Make the best product possible;

    Sell it at a fair profit; and Make service a fundamental part of doing business. In

    September 1961, The Frito Co. and H.W. Lay & Co. merged to become Frito-Lays

    Inc.

    Frito-Lays and Pepsi-Cola Merger:

    In February 1965, the Board of Directors for Frito-Lays and Pepsi-Cola announceda plan for merger of the two companies. On June 8, 1965, the merger of bothcompanies was approved by shareholders of both companies and a new companycalled PepsiCo, Inc. was formed.

    At the time of merger, Frito-Lays owned 46 manufacturing plants nationwide andmore than 150 distribution centers across United States, and was listed on New York

    Stock Exchange.

    In 1998, PepsiCo, Inc. acquired Tropicana and in 2001 acquired The Quaker OatsCompany.

    Frito-lays India:

    7 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    8/53

  • 7/28/2019 Mis Report on Pepsi Updated

    9/53

    PepsiCo Countdown:

    1898

    Pepsi was born as BRANDS DRINK

    1903

    Caleb Bradhman sold 7968 gallons of syrup using the theme line Exhilarating,

    Invigorating, Acid Digestion.

    1932

    A young Texan, Elliot Doolin made new kind of snacks, a corn chips called Fritos,

    in San Antonio and established Fritos Company.

    1934

    H.W. Lays & Co. was established by Herman W. lay.

    1938Mr. Lay through his business associated H.W. Lay & Co. with its primary product

    being Lays brand potato chips.

    1945

    Fritos Co. offers the exclusive franchise H.W. Lays & Co. to manufacture and

    distribute Fritos corn chips.

    1961

    The Fritos Co. and the H. W. Lay & Co. merged to become Frito-Lays Inc.

    1965

    PepsiCo Inc. was founded Donald M. Kendall, President & CEO of Pepsi-Cola by

    merger of Pepsi-Cola and Frito-Lays Inc.

    9 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    10/53

    1972

    Agreement was made to sell PepsiCo products in USSR as first foreign product.

    1975

    PepsiCo entered restaurant business, acquired KFC.

    1985

    Pizza Hut came to be known as a PepsiCo Company.

    1989

    Entered in Indian market as the overall PepsiCo strategy under a joint venture

    between PCI and PFI, known as Pepsi Foods Pvt. Ltd.

    1990

    Snacks and concentrate plants were set up in Channo (Sangrur, Punjab).

    1997

    Lays became the brand leader in its market segment.

    PepsiCo acquired Smith Snacks Food Co. in Australia.

    1998

    PepsiCo acquired Tropicana.

    2001

    PepsiCo acquired the Quakers Oats Co. and became the worlds fifth largest Food

    and Beverage Company with 16 brands.

    10 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    11/53

  • 7/28/2019 Mis Report on Pepsi Updated

    12/53

    Processing of Potato Chips:

    12 | P a g e

    Receiving Potato from 3P

    Hopper Filling (400 Kg)

    Washing & Destoning

    Peeling (350-45-rpm)

    Inspection & trimming

    Slicer feeding

    Slicing

    Washing of slices (90 sec)

    Surface moisture removal

    Seasoning application

    Packaging

    Frying (185 0c for 3.15 min)

    Removal of unwanted chips

    Dispatch

  • 7/28/2019 Mis Report on Pepsi Updated

    13/53

    Receiving and Unloading: (At 3P)

    The potato used for the chips are bought from market or directly from the farmers. Sometime company does the contract farming in which the company gives the seeds to the

    farmer and bought potatoes from them. This is done to develop and get good quality potato.

    A grader is installed to sort the undersized and oversized potatoes. The range for potatoessize is 45 to 90mm and for % defects, (external defects: 20% Max, internal defects: 10%max)

    The grader sorts out the potatoes by size. It has the two sets of rollers one having thediameter less than 45mm and other set having diameter greater than 90mm so as toeliminate undersize as well as oversized.After grading the potatoes are put into wooden crates and brought to primary feed hopper

    by using forklift truck.

    Primary Feed Hopper:

    Each crate containing 400kg brought by forklift is lifted on to the crate dumper that dumpsthe potatoes into the primary feed hopper directly underneath it. A belt conveyor is locatedat the bottom of the hopper, which is used to feed potatoes to destoner at fixed set speed.

    Washing and Destoning:

    The Destoner removes the stones or other heavy foreign matter that may be mixed

    with the bulk potatoes. It also removes some and sand from the potato surface. The

    vertical auger turns, it causes agitation which helps to wash sand and dirt from the

    potatoes, while stones and other heavy material sink to bottom of the Destoner basin.

    Destoner separates stones, heavy foreign matter from potatoes to prevent damage to

    downstream equipment. From the destoner potatoes are uplifted by hydro lift and fedto peeler.

    13 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    14/53

  • 7/28/2019 Mis Report on Pepsi Updated

    15/53

    Surge hopper:

    This hopper is equipped with level control that starts/stops the out feed conveyor of

    the primary feed hopper, the peeler, as required to maintain s small reservoir of peel

    potatoes and allows a continuous, metered flow of potatoes to the slicer.

    15 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    16/53

    Slicer:

    Potatoes are removed from the surge hopper by a vertical lift conveyor and

    transported to the slicer by a screw auger. This auger enables separation of thepotatoes in to small groups so that they drop one at a time into the slicer impeller. As

    the impeller springs, the potatoes are thrown against the blades of the slicer head

    assembly by centrifugal force. Slicer consists of a stationary slicer head having eight

    blades that are mounted vertically on it and protrude outwards and a rotating

    impeller (265rpm). It cuts the potatoes into slices of required thickness and these

    slices are dropped form the slicer head into the washer.

    Drum Washer:

    Here the slices are washed in a rotating drum with a continuous flow of fresh

    water to remove the excess of starch and scrap. As the slices fall into the washer

    tank, rotation of drum propels and tumbles the slices into washer. Series of

    water sprays mounted over fryer infeed conveyor to remove any remaining

    surface starch and prevents the excessive clustering of chips in the fryer.

    16 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    17/53

    Air Knife & Air Sweep:

    These both are assembled at the washer take-off conveyor. Air knife is high

    velocity air curtain which is used to remove the surface moisture and the debris

    from the chips. It also prevents stacking of chips which may cause soft centers.

    Air sweep creates vacuum at the under the take off conveyor. This vacuum

    causes suction of water from the lower portion of the chips and also the debris.

    Waste water and scraps are then transferred to an air-water separator and

    discharged into waste cart.

    Frying:

    Slices from infeed conveyor are passed to fryer where they are uniformly fried togolden crispness using Palmolein oil at a temperature of 180C-185C, that are readyto be seasoned. As the potato slices are immersed in hot oil, thermal energy israpidly and efficiently transferred to the product. This heat causes three reactions todevelop:

    1. Development of chip texture2. Production of basic chip flavor3. Formation of chip color

    Raw potato slices are carried in a constant stream from washer to the infeed of thefryer. Fryer consists of three Conveyors:

    1. In feed Conveyor 2. Sub merger Conveyor3. Take out conveyor

    In fryer, the paddles propel the product towards the submerger, which holds the chipbelow the surface of oil to complete the cooking process. Submerger conveyortemporarily keeps the chips in the oil and paddles moves the chips forward. Thesefried chips are brought out by take out conveyor.

    The length of time that the chip spends in oil pan may be independently varied byadjusting the operating speed of paddles, submerger and takeout conveyor. Thesesettings regulate overall cooling time, color development and oil content of finished

    product.At the end of takeout conveyor a moisture-sensing device is installed to check themoisture and oil in the fried chips. This is shown on fryer control panel.

    17 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    18/53

    Optyx:

    This device is used to remove the unwanted chips from the good chips with the

    help of air jet. In this system all the defects, which are to be removed, are

    defined by the help of a sample of defect. The defects are such as greening,

    undesirable colour (due to browning reaction) with different levels, etc.

    18 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    19/53

    19 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    20/53

    Seasoning Station:

    Here seasoning is applied on the chips. It is done in seasoning tumbler. The

    seasoning tumbler consists of a rotating drum with internal longitudinal ridges. This

    structure inside the tumbler makes the chips to move forward. The rotating action of

    tumbler drum both tumbles the chips and brings each chip to bed surface, ensuring

    an even thorough coating of seasoning to product.

    An acrison seasoning applicator provides both a constant feed of seasoning to

    tumbler and a consistent distribution of seasoning across the product. The feed rate

    of acrison applicator may be adjusted to regulate the seasoning content of finished

    product. The seasoning application is checked every hour so as to ensure accurate

    seasoning application.

    Inspection Conveyor:

    After seasoning, chips reach to inspection conveyor. Here the pickers picks the

    remaining defective chips like brown chips, soft centers, clusters, oil soaks etc. and

    discard them to waste. After it chips goes to the packaging section.

    20 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    21/53

    Packaging:

    For the acceptability of any food product its packaging must be done. For properhandling and good looking proper packaging films are used. Nitrogen is filled in the

    packets for proper handling, to decrease browning reaction till consumption and to

    decrease the breakage of products. Firstly finished product from process drops in

    vibratory conveyor and moves continuously so as to avoid overflow. There are

    sensors on conveyor to open the sliding window above weigher. The weighers weigh

    the amount of product. VFFS packaging machine are used for packing. The packets

    are then arranged in cartons and sealed with BOPP tape. Than the cartons are

    arranged on wooden pellets and dispatched to the warehouse.

    Final Product:

    21 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    22/53

    Processing of Kurkure

    22 | P a g e

    Receiving raw meal

    Dry blending

    Wet blending

    Meal separator

    Feed hopper

    Random extrusion

    Removal of small fragments

    Removal of bits

    Frying

    Retention conveyor

    Packaging

    Seasoning application

    through oil slurry

    Dispatch

  • 7/28/2019 Mis Report on Pepsi Updated

    23/53

    Raw Material handling:

    The main raw materials being used are cornmeal, rice meal and gram meal. Raw

    materials for kurkure production are inspected, sampled and tested to ensure that

    they meet the quality specifications. Tests for particle size, moisture etc. is done on

    raw meal. After the raw materials are accepted they are unloaded.

    Blending:

    The dry ingredients (i.e. corn, rice and gram meals in the ratio of 60: 30: 10) are first

    blended in blender. The blending is done for proper mixing of the ingredients andfor proper distribution of the moisture content. Water is added to achieve the

    required moisture content (16 to 18 %) for extrusion and collet formation. The water

    is added according to the moisture content of dry blended meal.

    Two types of blending are done:

    1. Dry blending (before addition of water

    2. Wet blending (after addition of water)

    Extrusion:

    The blended raw material is put into extruder hopper manually. Here the fine meal

    (i.e. flour) is separated. The extruder used is Random Extruder. The random extruder

    differs from other extruder by lack of an external heat source and a type of die.

    Therefore the extruded collets have a little uniformity.

    There are basically three steps of extrusion:

    1. Meal heating (Viscous shearing friction

    2. Compression (Head gap due to restricted opening between rotor plates

    and auger)

    3. Collette formation: explosively vaporized, rapid cooling.

    Parts of Extruders: Rotor, Anger, Nose cone, fingers, Blade, Motor

    23 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    24/53

    Heating process:

    Mixture collects in channels in auger flights in the stator feed grooves and in space

    between auger and stator casing. During auger rotation portion of meal nearest to the

    auger is forced to spiral towards the rotor head. However, feed grooves in stator

    casing create a resistance that exerts an opposing relative force and heal on meal

    called shear stress and resulting tension is viscous shearing.

    Temperature generally during extrusion is about 350-400 0F, which is higher than

    the boiling point (212 0F) of water. At such high temperature water is vaporized, but

    this vaporization can be prevented by creating extreme pressure (500 to 800 psi)

    between rotor and stator heads therefore moisture still remains when temperature

    above 212 0F. But due to this high temperature the gelatinization of the starch

    content takes place, which binds the molecules of meal together.

    Meal compression:

    When heated meal is compacted under immense pressure in extruder head gap,

    pressure is produced by meal flow through restricted opening between stator and

    rotor heads.

    Collette formation:

    Collet formation occurs when moisture is allowed to explosively vaporization upon

    decompression, causing it to pop or puff. Collette shaping is enabled by rotor head

    nose cone swirls, the face scallops and rotor fingers. Rapid cooling occurs between

    the rotor and stator heads. Blades are used to cut the collets in standard length.

    Chaff Tumbler:

    Chaff tumbler is to remove the very small fragments from collect. Chaff tumbler is a

    perforated rotating drum, which moves the collets forward and removes the very tiny

    particles of meal from these collets. These small meal particles are collected in a

    catch pan, which is lying exactly under the chaff tumbler.

    24 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    25/53

    Vibrating Chaff Conveyor:

    A continuous flow of cleaned collets exit the chaff tumbler and goes to vibrating

    chaff conveyor. This vibrating conveyor contains a inch stainless steel meshsection that is designed to sift out additional small fines as the raw collets are

    transported to the fryer. Very small collets are removed here to make the quality of

    product better. This conveyor is also called fryer infeed conveyor as it provides feed

    to fryer.

    Collet Frying:

    The collets from the chaff conveyor are fed to fryer where they are fried in vegetableoil at a controlled temperature for a small interval of time. The objective of collet

    frying is to:

    1. Reduce moisture content to 1-2%

    2. Develop collet flavor through addition of cooking oil.

    3. Give the collet a light and crunchy texture.

    The time for which the collets are in the fryer is called dwell time. The paddles keepthe collets under the oil so as to fry the collets. Then collets get lifted on take out

    conveyor to get out from fryer.

    Vibrating Conveyor:

    The take out conveyor puts the fried collets on the vibrating conveyor, which feeds

    the collets to seasoning tumbler. The seasoning applied on Kurkure is wet seasoning.Here the mixture of oil and dry flavour powder is applied on product. The mixture is

    first mixed in slurry cattle at the temperature of 35 0C to ensure proper mixing.

    When the slurry is blended it is pumped to the transfer kettle. Here also the slurry is

    continuously mixed so that the mixture remains proper. The transfer kettle maintains

    the slurry solids in proper suspension at an even temperature. After this the

    seasoning goes to seasoning tumbler through a pipe. Here the uniform seasoning

    application is applied on the collets.

    25 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    26/53

    Retention Conveyor:

    After the tumbler the collets reach to retention conveyor. It allows the oil andseasoning to set up and to dry on collets. It moves the prepared collets to Z

    conveyor. Z conveyor takes these ready collets to packaging section.

    Packaging:

    The prepared collets are packed in the same way as used for the potato chips by the

    VFFS packaging machines. The only Difference is that here normal air is used in

    place of nitrogen gas, because the starch content in the final product less availabledue to gelatinization.

    Final Product:

    26 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    27/53

    Inventory Management

    Area of Project: Engg. Store, Pepsico. Holdings (P) ltd.Channo.

    Contents:

    Inventory

    Inventory and Stores Management

    Applied Techniques:

    ABC Analysis

    o Detailed description of ABC analysis

    o ABC Curve

    o Distinction b/w A, B and C class items.

    o Application of ABC in Engg.Store.

    Music 3-D Inventory Management Systemo Music 3-D Concept

    o Cost criticality chart

    o Interpretation of Music 3-D

    27 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    28/53

    Inventory Management

    What is Inventory

    Inventory is a list forgoods and materials, or those goods and materialsthemselves, held available in stock by abusiness. It is also used for a listof the contents of a household and for a list fortestamentary purposes ofthe possessions of someone who has died. In accounting inventory isconsidered an asset.

    Inventory Management

    A big trend is for organizations to blend their operational functions underthe umbrella known as supply chain management. Often, the first twofunctions to merge are purchasing and inventory management.

    So, as a purchasing professional, you must understand inventorymanagement principles to remain valuable.

    First, you must know how much inventory to have on hand to ensurecontinuity of supply in the event of an uncharacteristic increase in eitherdemand and/or lead time. This quantity of inventory is called the safetystock. There is no universally used formula for determining safety stockquantity, rather it depends upon the kind of store and value of inventory.

    Second, you must know when to reorder materials for inventory.Generally, this point in time is determined when the quantity of materialsin stock decreases to a certain level, called the reorder point. The reorder

    point is determined by the formula:

    28 | P a g e

    http://en.wikipedia.org/wiki/Good_(economics_and_accounting)http://en.wikipedia.org/wiki/Materialshttp://en.wikipedia.org/wiki/Businesshttp://en.wikipedia.org/wiki/Will_(law)http://en.wikipedia.org/wiki/Assethttp://en.wikipedia.org/wiki/Materialshttp://en.wikipedia.org/wiki/Businesshttp://en.wikipedia.org/wiki/Will_(law)http://en.wikipedia.org/wiki/Assethttp://en.wikipedia.org/wiki/Good_(economics_and_accounting)
  • 7/28/2019 Mis Report on Pepsi Updated

    29/53

  • 7/28/2019 Mis Report on Pepsi Updated

    30/53

    ABC ANALYSIS(PARETO ANALYSIS)

    ABC analysis (sometimes referred to as the 80/20 rule and asPareto analysis) is a method of classifying items, events, oractivities according to their relative importance. It is frequentlyused in inventory management where it is used to classify stockitems into groups based on the total annual expenditure for, ortotal stockholding cost of, each item. Organizations canconcentrate more detailed attention on the high value/important

    items. Pareto analysis is used to arrive at this prioritization.

    Taking inventory as an example, the first step in the analysis is

    to identify those criteria which make a significant level ofcontrol important for any item. Two possible factors are theusage rate for an item and its unit value.

    Close control is more important for fast moving items with a

    high unit value. Conversely, for slow moving, low unit valueitems the cost of the stock control system may exceed the

    benefits to be gained and simple methods of control should besubstituted.

    These two factors can be multiplied to give the annualrequirement value (ARV) - the total value of the annual usage.

    If the stock items are then listed in descending order of ARV,the most important items will appear at the top of the list. If thecumulative ARV is then plotted against number of items then agraph known as an ABC curve (Pareto curve) is obtained.

    30 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    31/53

    ABC/ Pareto Curve

    The precise shape of a ABC curve will differ for any analysis but thebroad shape remains similar - following 'the 80/20 rule'.

    In this case, typically, the first 20% of items in the list will

    account for approximately 80% of cumulative ARV. For acompany with a stock list of 1,000 different items this meansthat paying more attention to the top 200 items (with asophisticated stock control system) will give close control ofabout 80% of total stock investment.

    The next, say, 40% of items, will, typically, account for a further15% of cumulative ARV. These can be subject to less precise

    control methods.

    The last 40% of (low value of low usage) items then account fora mere 5% of ARV and can be controlled with a simple system.

    The term ABC analysis lays down the fact that the first 20% ofimportant items are known as Category A items, the next,typically 40% are Category B items and the relatively

    unimportant, though larger in number, 40% are Category C

    31 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    32/53

    items.

    Point of distinction between A, B, and C class items.

    A Class inventory B Class inventory C Class inventory

    Very Strict Control Moderate Control Least Control

    No Safety Stock Low Safety Stock High Safety Stock

    Max. follow up Periodic follow up Exceptional follow up

    Centralized storing Combined storing De-centralized storing

    Accurate Forecast Estimated Forecast Rough Estimates

    Weekly Reports Monthly Reports Quarterly Reports

    Must be handled by

    Superiors

    Can be handled by

    Middle mgt.

    Can be fully delegated.

    MAJOR AREA OF RESEARCH: ENGG. STORE

    32 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    33/53

    The project i.e. The ABC analysis was conducted for the area ofEngg. store of the Pepsico. Holdings. Its a unique store located at thechanno plant and has several credits to its name. It is considered to bethe most effective and efficient store among all the three plantslocated at Channo, Pune and Kolkatta, respectively. This is thecombine endeavor of Mr. Rajesh Misra and Mr. Rohit Batta, makingthis store no.1 all over India.

    It consists of 38 classified racks each having a separate number.These racks are classified in various shelves, and each shelf is furtherdivided into different columns. This is done to make available theinventory as early as possible, without wasting any time for finding

    the respective inventory. The store carries a huge stock of items thatare required to be used in the production machines like bearings,shafts, conveyer belts, heavy electric motors, gear box and manymore. Each item has provided with a separate code, which makes itvery easy to locate the item in the store. For e.g.

    ZZMPKCLP0216 Bridge Cylinder Mounting P#9652 15 127013.6 20.12.00

    The above example first tells the code of the item (ZZMPKCLP0216),then the name of the item (Bridge Cylinder Mounting P#9652). Afterthen, the available number of that item lying in the store (15), then thevalue of the item in rupees (127013.60) and in the end its location in thestore (20.12.00) i.e. rack no.20, shelf no. 12 and 00 column. Theinventory management techniques like FNSD, VED etc. have already

    been applied in the store. The detailed analysis of the store that areconducted as a part of the project are as under:

    A- class Inventory

    33 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    34/53

    Here is a list of the A class inventory lying in the Engg. store along withtheir respective material codes, values (Rs.), current stock and theirlocation in the store.

    Material Material Description STK Value Location

    ZZM10CNY0023 Conveyor Scoop 4 IN 1 610069.7 19.11.00

    ZZM10SLI0025 Shoe Slicer Shoe Flat P#22014 42 574415.6 12.02.00

    ZZMKKEXT0052 Finger Fcp Fingers P#RD_1272 246 556830.5 05.10.00

    ZZM10FRY0006 Belt Drain Fryer P#77_J4_2701_C7/2 2 460941.9 07.08.00

    ZZMPKCMD0023 Cell Load Cell 706_02 P# A15056T 12 425230.4 34.01.02

    ZZM10SLI0045 Shoe Slicer Shoe Crinkle P#22016 29 386532.1 12.07.00

    ZZMPKPLR0062 Cylinder Aro 2415_1009_040 P#13036 21 378599.4 34.04.10

    ZZEPKCLP0038 Motor Assy Servo Motor Assy. P00370148 2 373388.9 55.55.55

    ZZEPKPLR0031 Board Card Pwb Assy Cpu Chip 3 343897.8 34.02.05

    ZZCPKMEC0039 Character Brass Type (Markem) 3.2MM 2532 323719.3 38.17.00

    ZZM10CNY0012 SPROCKET SERIES 800 6.5_INTRALOX 112 296339 10.07.00

    ZZE10FPS0011 Cell Load (50 Ks) Mlc 26/50 2 293988.8 36.14.00

    ZZM10SLI0051 Impeller 5 Paddle 13.690 P#22020 3 287209.1 12.08.00

    ZZEPKISD0073 Card Pwb_5165D P#03_8451_08 3 281247.6 33.02.04

    ZZMPKAPX0087 Belt Habasit Pull P#062-1015-09 49 255418.9 38.14.00

    ZZEPKISD0036 Board Tower E09166 3 254670.8 33.01.02

    ZZMPKCOD0068 Ink Roll For Markem (950 Series) 48MM 876 253650.8 38.18.00

    ZZM10CPL0003 PUMP HYDRAULIC RACINE 42079_01_9 1 251415 11.08.00

    ZZMPKPLR0044 BELT PULL BELT URETHANE P#P0041767 21 251379.6 38.13.00

    ZZM10SLI0070 Head Assy Crinckle P#22166 2 249660 12.10.00

    ZZEPKISD0321 PWB:P_5481:1A/DSOFTP5185 1 240863.8 33.03.08

    ZZEPKISD0099 Display Fluorescent P#54_8832_06 3 234230.1 04.06.00

    ZZE10FPS0010 Drive Control Cd30 1 225420 36.15.00

    ZIMPKCLP0002 Cylinder Air P#2418-1089-010 17 222822.4 32.13.00

    ZZEPKPLR0093 Drive Assy Wiring Module P#370154 1.5 218849.5 36.03.00

    ZZMPKCNY0018 Arm Allen Drive Left P# A3523 5 218792.1 07.10.00

    ZZMPKCNY0005 Cylinder Cylinder Allen _A 44 218767.2 02.06.00

    ZZMPKDIS0014 DRIVE WEIGHT 493MM P#D21217-4 1 214500 07.07.00

    ZZMKKEXT0001 Sleeve Kke Hicap Augar C00279 7 202446.1 05.08.00

    34 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    35/53

    ZZEPKISD0171 Card _Pwb:P_5481 P#059_9061_01 1 198472.2 33.03.08

    ZZMPKCLP0067 Cylinder Jaw Cylinder P#A10246 16 197556 20.14.00

    ZZEPKSIM0012 Switch Vaccum Switch 27 196751.5 32.05.00

    ZZEPKPLR0044 Controller Smart A/D P#D14622 4 196123.3 34.04.10

    ZZM10SLI0071 Slicer Assy Head Assy #023145 1 195835.8 12.07.00

    ZZM10SLI0036 RING TOP SUPPORT RING P#22005 7 190909.8 12.04.00

    ZZMPKAPX0036 Coupling P# 076-1189-01 12 186555.5 04.01.00

    ZZEPKCMD0036 Assy smart A/D card P#A14058 1 181964.4 35.06.10

    ZZEPKPLR0092 Motor 1/6Hp 115/50 Ip56C P#37058 4 180925.6 36.06.00

    ZZEPKISD0068 CARD BOARD PWB P#00_7699_18 (P-5186) 7 173423 33.02.04

    ZZEPKCMD0003 Cable Ribbon Assy A12618B 5000N 26 7 170074.3 33.04.11

    ZZMKKEXT0019 Stator Kke Bronge RD1270 25 165682.8 05.14.00

    ZZEPKCMD0025 Motor Cone Motor A14790 1 163117.6 55.55.55

    ZZE10HEX0009 Motor Scr Dc Motor Hp=1 Rpm=1750 1 161695 10.10.00

    ZZMKKEXT0005 KKE KNIFE BLADE 14004 33 161314.2 00.00.00

    ZZTMP001 Board Card Cpu P#D14664A 1 160092.6 36.03.00

    ZZMKKEXT0003 KKE AUGERA00279 5 159233.4 05.11.00

    ZZEPKISD0098 Display Plasama 03_2358_02 1 158792.6 55.55.55

    ZZM10TNP0003 CHAIN CONVEYOR (TRIM & PARE) 40 158097.8 10.05.00

    ZZM10FPS0013ELECTRO MAGNET VIBRATOR CATREF40900003 2 153828.2 36.01.00

    ZIMPKCLP0001 Cylinder Air P#P0013037 12 153500 32.13.00

    ZZM10SLI0072 Holder Knief Holder Flat P#22181 102 153251.9 38.08.00

    ZZM10HEX0035 PUMP FUEL TA3C 4010_5W P#601051 1 152341 35.04.08

    ZZMKKEXT0021 Meter Actuator Air_O P#110423 2 150633.6 05.07.00

    ZZM10TNP0006 Belt OPB 23%, W-205mm,FH-76,S-200mm 51 147900 13.00.00

    ZZM10SLI0084 BLADE SLICER V_CUT P#22069 BOX 67 147340.2 38.07.00

    ZZEPKPLR0013 Pwb Assy Pwb Assy Ttl I /O P#14399 3 145854.2 34.02.06

    ZZMPKMEC0053 Valve Solenoid P#VZ5140_3DZ_02 26 145752.6 05.10.00

    ZZE10FPS0012 CD30 CATREF 58345 1 139933.2 36.15.00

    ZZC00MEC0025 ANTIFOAM TILOW 563A (50KG PACK) 580 138918.5 98.98.98ZZMPKMEC0102 Cylinder Rotary P#DSR_25_180_P 24 138410.4 32.17.00

    35 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    36/53

    ZZEPKAPX0001 Board Card Cpu D14618 1 137481.4 34.02.05

    ZZMPKMEC0051 Plate Kit Rebuild Auto Libe Sprmatc 1 136764.3 10.16.00

    ZZMKKEXT0009 KKE ROTOR BRONGE RD1271 21 134928.5 05.14.00

    ZZMPKCLP0101 Frame Carriage P#D09653A 1 131339.5 20.05.17

    ZZEPKISD0172 Board Card Cpu P_5156 P#07_6861_03 1 129438.4 33.03.09

    ZZEPKISD0100 Drive Drive Unit Th 00_6424_19 2 128763.2 55.55.55

    ZZEPKINS0001 Controller Plc Micrologic _1000 10 127944.2 35.04.08

    ZZMPKCLP0216 Bridge Cylinder Mounting P#9652 15 127013.6 20.12.00

    ZZEPKBOS0005 Terminal Box Bosch 8 101 851 231 1 123364.9 03.01.00

    ZZEPKISD0055 Cable Ribbon P#00906113 8 122117.8 33.04.11

    ZZM10SLI0065 Holder Knief Crinkle P#22182 58 120036 38.06.00

    ZZMUTACR0196RECOL COMPRES OILNON FOODGRADE)P#52569 175 120029.2 98.98.98

    ZZE00ELE0021 Ic Ic Different Sizes 1578 119952.2 32.05.00

    ZZEPKAPX0068 Controller Driver:Servo P# 064-9362-05 1 119204.8 05.16.05

    ZZMPKMEC0057 Seal Cylinder Air I_Cq2Kb 50F_40(S.Seal) 30 117170.4 32.09.00

    ZZM10HEX0052 REGULATOR PRESSURE 3/1 ID 50 PRES 1 116693.3 11.11.00

    ZZMKKEXT0059 Holder Knief Holder_Fcp 8 116174.1 35.01.02

    ZZMPKCLP0076 Crank Drive Crank P#5365 2 115397.2 20.10.00

    ZZMPKDIS0015 DRIVE WEIGHT 242MM P#D21212-4 1 115386.4 07.07.00

    ZZM00PMP0034 SEAL MEC609-SVT-SCP-32 PC10CORN 4RBF-1 1 114039.1 35.03.07

    ZZE10FPS0005 PROFACE 5.7" TSCREEN COLOUR WITHOUT E 1 113728 36.13.00

    ZZMPKAPX0020 BELT_HEATER P#096_5266_08 28 113407.8 38.13.00

    ZZMUTACR0089 Seprator Ssr75/100 P#39902382 12 112795.3 31.06.00

    ZZM10MEC0047 Belt Series 800 Flush Edge1 17.6 112745.6 19.01.00

    ZZM10SLI0037 RING BOTTOM SUPPORT RING P#22004 2 111754.7 12.04.00

    ZZC00CON0092 Prime Cip 1125 111150 98.98.98

    ZZEPKCLP0022 Encoder Optica 924_01039_47 924_01039_47 5 110010.7 55.55.55

    ZZMPKMEC0117 Valve Sol.Valve I_Vz314_4D_01 32 109187 05.10.00

    Classification of A-Class inventory on the basis ofControl percentage

    36 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    37/53

    TOTAL VALUE Rs. 2,94,26,676

    CONTROL

    PERCENTAGE90% 80% 70% 60%

    PERCENTAGE

    VALUE

    2,64,84,00

    8

    2,35,41,341 2,055,98,67

    3

    1,76,56,006

    ITEMS

    1 -- 202 1 157 1 -- 120 1 -- 89

    ORIGINAL

    VALUE

    2,64,78,88

    4

    2,35,27,762 2,05,81,522 1,75,97,595

    NO. OF

    ITEMS

    45 37 31 89

    B- class Inventory

    37 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    38/53

    Here is a list of the B- class inventory lying in the Engg.store along withtheir respective material codes, values (Rs.), current stock and theirlocation in the store.

    ZZMUTFLT0215 Fork Assy. For LPG F/L P# W2173300020 2 42107.22 25.00.00

    ZZCUTBLR0005 Chemical Maxtreat_3220 105 42078.52 13.08.00

    ZZM10FPS0017 Seal Ptfe Shaft Kit Mrv40 2 41962.61 36.14.00

    ZZMKKPMP0002 SEAL MECH. SEAL (FCP SLURRY PUMP) 21 41923.51 05.02.08

    ZZM10HEX0002 Plate Swirl 24Wh Ord #121365004/2 1 41568.99 11.03.00

    ZZE00INS0008 Controller Temp P#77_147E16031100 2 41542.44 35.03.07

    ZZE00INS0007 Controller Temo P#77_147_16011100 2 41542.42 35.03.07

    ZZMUTACR0086 ELEMENT AIR INLET(C.R.) P#39708466 13 41296.96 31.04.00

    ZZMPKDIS0027 Photo Eye Sensor Wt36-R210 P#90500060 2 41062.18 36.13.00

    ZZMPKPLR0118 Allen Weight Eccentric WEIGHT 9 1 40934.1 07.05.00

    ZZEUTSTK0038 Power Supply Type Q_120D_ Meanwell 7 40806.81 35.04.08

    ZZMKKCNY0027 MotorGearedAs55Dp190.3P90 B5 B3 Bn 90 1 40738.11 09.12.00

    ZZE10OPT0003 Mot Hp 1800 230/460 50/60P# 021808 1-1/2 1 40605.18 36.07.00

    ZZM10FPS0007 BADGER PROPORTIONING VALVE 1 40573.7 36.14.00

    ZZE00ELE0561 Switch Reed Smeo-1-B 32 40562.13 32.01.00

    ZZM10CNY0028 INTRALOX 38 40314.2 13.00.00

    ZZM00MEC0329 Chain M.S. Pitch 5/8 _Diamond 44.1 39919.39 37.03.00

    ZZE00ELE0265 Breaker Mpcb Gv2_M40 Telemecanqe 8 39914.87 06.05.00

    ZZE00ELE0494 Breaker Mccb 630A 2 39491 28.17.00

    ZZMUTSTK0060 ROLLER DRIVING P#8101867226 4 39228.38 28.18.00

    ZZMUTETP0011 CouplingFluidCentrifuge 206DTRIA-1001959 1 39074.36 22.01.00

    ZZMPKISD0009 Cam Follower P#01_0026_04_ISHIDA 81 38911 01.01.00

    ZZM10PTH0002 Gear Box Pc10 A_Potato Hopper 1 38905.73 11.04.00

    ZZE00ELE0365 BREAKER MCCB 250 AMP 3 38890.05 28.17.00

    ZZE00ELE0007 MOTOR 3 PH MOTOR 10HP(FRAME 1325) 2 38870.5 13.08.00

    ZZCPKCOD0001 Roller Markem 930 Black 32 MM 156 38477.98 32.03.00

    ZZMPKPLR0121 Tip Contact Assyembly P#502064800 144 38035.93 25.18.00

    ZZM10SLI0063 Nut Lock P#22047 102 37910.65 12.03.00

    ZZE10HEX0021 Sensor Flame Qra2 ORD#600501 3 37904.62 11.07.00

    ZZEPKCLP0037 Sensor Assy Prox. P#Y18352 2 37811.01 55.55.55

    38 | P a g e

    Material Material Description STK Value Location

    ZZE10FPS0020 Device Net Net Scanner Module P#1747-SDN 1 45395.51 06.06.00

    ZZMPKCLP0185 Knife Knife Perf (3 + 0.5 Mm) Clipper 24 45313.83 55.55.55

    ZZMUTDG10090 Cleaner Air Part# 4020551 7 45144.02 98.98.98

    ZZE00ELE0127 Clutch 12 V Dc 2Up P#0490826 2 44802.67 88.88.88

    ZZM10FPS0018 MotorO37WacGearBoxAgitatorCatrefMma0048 1 44717.13 36.14.00

    ZZM10HEX0046 Burner Nozzle W50 1 44621 34.03.09

    ZZM10FPS0010 Spring (Dcl) (A99826 AND A55827) 4 44508.22 36.14.00

    ZZMPKMEC0116 Cylinder Air Cyl. P#I_CD85N20_50 28 44020.89 32.14.00

    ZZE10HEX0026 Drive Servo Sqm 10 ORD#651418 1 43919.2 11.03.00

    ZZMPKCOD0005 CAM INKING CAM_MARKEM P#0721228 2 43654 04.01.00

    ZZM10SLI0066 Clamp Knife V_Cut P#22077 104 43590.23 38.06.00

    ZZE10OPT0006MDL MOMENTUM 16 IN/16OUT 24VDCP#019257 1 43570.22 36.11.00

    ZZE10CPL0002 Motor Hyd 22.6 Cid P#41315_01_9 2 43483.88 10.02.00

    ZZE10INS0003 Tem. Udc3200 PositionProportionalO/P 1 43160 06.06.00

    ZZMUTSTK0091 Wheel Assy 05.02_0024_C3 6 43066.08 25.14.00

    ZZEKKPMP0002 MotorBrushBm0015WatsonMarlowPump623SSer. 12 42853.7 22.05.00

    ZZM00MEC0462 Bearing Fafkp FAFNAIR _12A_ 38 42743.06 21.09.00

    ZZE10HEX0052INDICATOR & OPERATING UNIT ORDER660330 1 42704.02 11.01.00

    ZZE10HEX0040 Motor Modulation(Model:M6284F1013) 1 42432 10.09.00

    ZZM00MEC0461 Hose Pressure 61600 P#77_491214 4 42425 10.09.00

    ZZE00INS0003 PROBE THERMISTOR P#0231211 35 42307.01 88.88.88

    ZZMPKCLP0230 BRIDGE CYLINDER MOUNTING P#9652 5 42272.45 02.09.00

    ZZMUTACR0199 Oil Seperator P#1614905499 3 42238.45 03.00.00

    ZZMKKEXT0049 EDGE MODULAR CONVEYOR INTRALOX 4WD 206 42207.88 07.00.00

    ZZMUTFLT0215 Fork Assy. For LPG F/L P# W2173300020 2 42107.22 25.00.00

  • 7/28/2019 Mis Report on Pepsi Updated

    39/53

    ZZEPKCMD0004 Cable Assy Ribbon P#906123 5 37535.61 33.04.11

    ZZM10CNY0026 Belt Wide Mesh Top Intralox 203MM 10 37383 13.00.00

    ZZE00INS0012 Controller Speed AS220IF_01_06 82 37086.91 01.07.00ZZMPKCLP0121 Link Bridge Long P#A10238 18 36873.92 20.07.31

    ZZMPKMEC0058 Cylinder Air 1_Cdq2Ka32_35D_A733 9 36852.38 32.13.00

    ZZC00MIS0018 CHEMICAL SUPERFOAM 425 36523.73 13.07.00

    ZZM10SLI0040 Shoe Sli Shoe V Cut Bronze P# 22039 3 36465.97 38.08.00

    ZZMPKCLP0095 Seal S_500 Thomson Fs P#30511 114 36451.32 02.07.00

    ZZM10CNY0033 Geared Motor Washer take out conveyor 1 36360.83 37.16.00

    ZZCPKBOS0002 Cloth Teflon P#8101867125 208 36267.36 03.13.00

    ZZE10FPS0025 (2) ANLOG I/PANALOG CUR O/P P#1746-NI041 1 35996.85 06.06.00ZZEPKCLP0039 CARTRIDGE HEATER 35V 16W P#0231213 24 35962.06 88.88.88

    ZZMPKCLP0167 Pulley Timing Belt (Shaft) P#11728 41 35713.93 02.09.00

    ZZM10SLI0068 Clamp Knife Straight P#22074 140 35484.49 38.08.00

    ZZMUTACR0113 Filter Air Filter P#39903281 8 35475.7 31.00.00

    ZZMPKMEC0069 Valve Solonoid Mfh_3_1/4 P#9964 15 35299.5 01.16.00

    ZZM10OPT0011 Belt White Endless P#020541 26" X 180" 3 35024.25 36.16.00

    ZZMUTCTF0006 Deep Groove Ball Bearing 6222MA/C3 2 34876.86 11.00.00

    ZZE00ELE0259 Cable Caoe_Lapa 1MM SQ X 6 444 34788.26 09.14.00ZZEUTDG20004 Charger Turbo Holset 3521598 C 1 34727.84 23.02.00

    ZZMPKCLP0010 Milker Fixed P#Y05364 22 34722.98 02.05.00

    ZZE00ELE0245 Breaker Miniature Circuit 32A Tpn 37 34401.47 37.07.00

    ZZEPKAPX0058 EYE MARK AS:: P# 065-2572-02 1 34263 36.05.00

    ZZEPKISD0151 Power Supply P#02_5534_05 2 34044.55 33.01.03

    ZZM00MEC0486 Bearing Ball 3313A 4 34006.96 21.18.00

    ZZMPKCNY0020 Arm Allen Drive Right P# A3524 1 33815 07.09.00

    ZZMPKPLR0139 Bearing Fafnir Ra 1077 PP P#38048 13 33581 34.03.07

    ZZMPKMEC0047 CYLINDER AIR P#DNU_40_80_PPV 10 33521.9 32.14.00

    ZZMUTACR0082 Hose Mpv To Ac P#95313961xf60 5 33429.57 24.08.00

    ZZM10FPS0015 VIBTEC M20TR VIBRATOR MDA0027 1 33383.21 36.13.00

    ZZM08BPL0003 Bearing 22209 CK 12 33303.1 21.01.00

    ZZM10MEC0041 Gear As25P 40:29 Out Put Rpm_35 3 33238.1 23.08.00

    ZZE00LAB0004 Brush Less Motor Of Mm-55 2 33048.33 88.88.88

    ZZM10MEC0048 RING_MATING WITH PKGSEAL609SVT_P_40 1 32800 35.01.01

    ZZE00ELE0078 Contactor 440Vac A.R 160A 3Tf50 4 32687.52 28.13.00

    ZZM10TNP0004 GEARED MOTOR AS45 DP84.9P90 B5B3 BN 90 1 32476.73 09.04.00

    39 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    40/53

    Classification of B-Class inventory on the basis of

    Control percentage

    TOTAL VALUE Rs. 98,07,469

    CONTROL

    PERCENTAGE90% 80% 70% 60%

    PERCENTAGE

    VALUE

    88,26,721 78,45,974 68,65,227 58,84,481

    ITEMS

    260 -- 555 260 -- 509 260 -- 467 260 -- 429

    ORIGINAL

    VALUE

    88,09,264 78,29,695 68,41,182 58,67,545

    NO. OF

    ITEMS

    295 249 207 169

    40 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    41/53

    C- class Inventory

    Here is a list of the C-class inventory lying in the Engg. store along withtheir respective material codes, values (Rs.), current stock and theirlocation in the store.

    Material Material Description STK Value Location

    ZZMPKISD0094 BLADE MODIFIED FOR APEX LENGTH 152MM 27 18117.95 01.13.00

    ZZE00ELE0552 Contactor Model: Lc1-F115 M Telemecniqe 2 18113 29.17.00

    ZZC00CON0093 Su 120 275 18053.75 98.98.98

    ZZMPKBOS0267 Poker Cylinder (DNC-40-100-PPV-A) Festo 5 18036.15 28.18.00

    ZZMPKAPX0081 GEAR RACK P#091-4654-00 4 17940.5 36.07.00

    ZZM00NGP0001 FILTER ELEMENT FOR FIRST STAGE FILTER 1 17918.18 07.00.00

    ZZM00MEC0193 Bearing Ball YAR 206WITH FLANGED 16 17868.45 02.11.00

    ZZEKKPMP0006 PumpDig.Disp.Sd0058WatsonMarlow623SSer. 1 17855.83 22.05.00

    ZZMPKMEC0078 Fitting Elbow P#KQ2L10_U02 186 17802.96 37.11.00

    ZZMPKISD0033 Spring Coil Compress P# 02_3714_01 24 17733.68 04.05.00

    ZZCPKMEC0051 ROLLER INK ROLLER BLACK H.CODER 21 17671.53 38.15.00

    ZZM00MEC0197 Bearing UC205 25 17667.97 01.15.00

    ZZCPKMEC0038 Character Brass Character Feb 49 17640 38.17.00

    ZZE00ELE0564BREAKER,MPCB-GV 3 ME40(25-40A)TELEMECH 3 17571.15 06.05.00

    ZZMPKCLP0030 Bearing Bearg (ROD BRG FEMAL RF_07 28 17500 20.20.00

    ZZM08SAP0002 Casing Uhmwpe 3.0 Mt # 250 _ 1 17396.29 23.12.00

    ZZMPKCMD0013 Roller Hopper Commander 720 17387.56 38.05.00

    ZZMPKPLR0071 Pin Carriage Assy P#Y17331 52 17383.31 01.11.15

    ZZE00CLE0010 Vacumme P#6490-135 2 17356.32 27.16.00

    41 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    42/53

    ZZMPKCOD0052 HEATER BLOCK HOLDER P#0231179 1 17345.12 88.88.88

    ZZEPKCLP0001 Timer Perforator P#P0010687 1 17309.93 20.17.00

    ZZM00ETP0002 Bearing Taper Roller 30304 28 17307.3 21.17.00

    ZZKK2FRY0004 Scanner Uv (Protection Control Pc-Ii) 1 17274.5 11.06.00

    ZZEKKEXT0019 Contactor Lc1D 50 5 17271 28.10.00

    ZZCPKMEC0046 CHARACTER BRASS JAN 46 17230.14 38.17.00

    ZZMPKISD0012 Cover Water Proof P#02_3716_09 4 17219 04.13.00

    ZZM09FRY0003 MotorGearedAs30Dp120.9 P71 B5 B3 Bn71 A4 1 17182.51 09.05.00

    ZZEPKAPX0141 Seal Bracket: Jaw P# 069-1926-21 2 17108.3 03.14.00

    ZZM00MEC0194 Bearing UCF 204 43 17105.4 21.07.00

    ZIMKKEXT0004 GEAR BOX BOSTON F713B-20-B5-G 1 17089.42 05.11.00

    ZZMPKBOS0207 SGS-M16x1.5 ROD END BEARING (Festo) 20 17040.16 27.18.00

    ZZCUTACR0002 Lubricant Servo System Hlp_68 180 17015.24 98.98.98

    ZZMPKBOS0178 Belt Timing P# 8101208640 18 16920 27.09.00

    ZZM10HEX0043 Gauge Press.Manometer O#1513362678 2 16916.39 11.05.00

    ZZC00CON0100 Grease Food Grade Molykote Make P#G-4501 11 16901.97 23.00.00

    ZZEPKISD0063 CARD PWB P#74_4041_01 1 16863.21 04.05.00

    ZZMUTACR0175 Filter Aoil P#1613610500 12 16849.96 31.09.00

    ZZMPKAPX0077 Poker Arm P#064949901 2 16848 36.09.00

    ZZEPKAPX0042 VACUUM PRESSURE SWITCH P#I-ZSM1-121L 3 16846.48 03.05.00

    ZZE00ELE0529 Cell Load 250 Kg Model 1260 1 16839.6 29.14.00

    ZZM10PMP0005 Seal Mech.For W.Pump P#77_400251/C 2 16819.62 11.11.00

    ZZMTWHYD0009 VALVE DIRECTIONAL DG5S4068CH320AC 1 16814.37 07.03.00

    ZZEUTACR0008 Cable Ribbon Terminal Assy 1 16799.1 33.03.07

    ZZM00MEC0335 Bearing Ball UC206 17 16710.7 01.09.00

    ZZMPKCLP0178 Arm Idler Drive Arm P#D12682 6 16707.6 20.16.00

    ZZEPKPLR0007 Rod Assy Inner Carriage P#Y17334 2 16690.31 34.06.16

    ZZM10FPS0020 Belt V, Lir 100 22 X 7 X 567 2 16640 26.01.00

    ZZM00MEC0009 Bearing P Block SLIT TYPE UC_205 29 16634.95 21.09.00

    42 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    43/53

    ZZMTWHEX0010 PUMP_ OIL_ AJ6CC TWZ HEAT EXCHANGER 1 16603.6 36.02.00

    ZZMUTSTK0109 DRIVE WHEEL ASSEMBLY P#1648400 1 16591.74 25.09.00

    ZZCPKMEC0033 Charctor Characte Brass May 46 16560 38.17.00

    ZZM00MEC0411 BEARING 6312 C3 12 16552.98 21.02.00

    ZZE10HEX0051 Coil Solenoid Valve P#604556 3 16552.2 11.11.00

    ZZM10FRY0016 Motor 10HP 2800 RPM foot Mounted 1 16521.78 98.98.98

    ZZM10CPL0026 Conveyor Fines Removal 8 WIDE 1 16500 10.08.00

    ZIMKKEXT0010 SHAFT QUILL WARM FCP QUILL FCP C09035 1 16448.57 05.11.00

    ZZMPKMEC0092 Tubing Pu_10 (Blue ) 187 16432.18 32.07.00

    ZZE10BIN0003 Motor Roto Bin Indicator (LAR_110930) 1 16382.61 11.08.00

    ZZE00ELE0242 Fuse Hrc Fuse 100Amp Din Type 76 16364.87 30.08.01

    ZZMUTACR0172 Reducer D]Ptrans P#1089057520 1 16364.73 24.09.00

    ZZMUTACR0180 Pressure Translator P#1089057520 1 16364.73 24.09.00

    ZZE21WRT0004 Sensor Magnet Part # A4-E62-1-3 2 16334 36.13.00

    ZZEPKCLP0035 Cartridge Heater L_152MM OD 9.45MM 46 16276.9 38.02.00

    ZZE00ELE0291 Breaker Elcb 4Pole 63 Amp 415Vac 6 16260.3 08.07.00

    ZZEPKAPX0140 Accessory Sus:Protect P# 076-9243-09 4 16253.4 03.14.00

    ZZM10ACS0001 Gear Gear Set For Acrison Assly. 2 16224 10.04.00

    ZZMPKGMN0007 Shaft Drive For Polaris P#A14554 18 16200 23.06.00

    ZZE00ELE0063 Kit Spare Kit Ml_2 16 16087.24 37.10.00

    ZZMUTFLT0127 MAST ROLLER P#Z777200003 4 16064.59 25.03.00

    ZZEPKISD0064 Card Pwb P#75_8932_01 1 16060.2 04.05.00

    ZZMKKBLD0001 Grill Magnetic Grill 1 16000 05.06.00

    ZZM00MEC0233 Connector Power Ml_6 110Vac 3 15968.1 29.11.00

    43 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    44/53

    ZZMPKBOS0068 Link Front P#8101867007 13 15946.56 03.07.00

    ZZE00ELE0349 FUSE _HRC 16 AMP EIT TYPE 392 15940.68 30.06.00

    Classification of C- Class inventory on the basis ofControl percentage

    TOTAL VALUE Rs. 98,16,233

    CONTROL

    PERCENTAGE90% 80% 70% 60%

    PERCENTAGE

    VALUE

    88,34,610 78,52,986 68,71,363 58,89,740

    ITEMS

    608 --

    1699

    608 -- 1413 608 -- 1224 608 -- 1085

    ORIGINAL

    VALUE

    88,34,077 78,52,225 68,67,566 58,83,309

    NO. OF

    ITEMS

    1091 805 616 477

    44 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    45/53

    Music 3D Inventory Management

    Music-3D stands for multi unit spares inventory controlthree

    dimensional approach, the three dimensions being finance,

    maintenance and materials. By integrating the three functions of

    finance, user and material in a logical fashion, it provides a forum for

    cost reduction techniques. The traditional ABC approach or Paretos

    law or 80/20 approachcontrols only on the basis of annual usage

    value while the VED approach determines the criticality of a spare

    part on three phases. For better overall management, planning and

    control, MUSIC 3D combines not only the ABC and VED but also

    availability of a spare part, each of the three dimensions being

    restricted to only two level of the characteristics.

    Music 3-D Concept

    Music 3-D tries to integrate all the three types of analysis, viz.

    ABC/ VED/ SDE, and each dimension is taken at two levels. For

    instance, spare parts are classified into two categories: (a) high sales

    value (HSV), which accounts for the 80% of annual sales--, usage

    value accounts for 20% of the number of items, and (b) low sales

    value or low consumption value of about 20%; this accounts for the

    45 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    46/53

    remaining 80% of the items. Instead of three categories as vital,

    essential, desirable, the spares are separately classified as critical and

    non critical.

    The lead time also classified as long lead time or (LLT) with more

    than 12 months and short lead time (SLT) of less than one year.

    Combining the three dimensions we obtain cost-criticality

    availability, as shown in the table below, which classifies the items

    into eight categories after using the three dimensions.

    46 | P a g e

    Cost Criticality Availability

    High Sales Value (Rs.)

    Low Sales Value (Rs.)

    LLT SLT LLT SLT

    1 2 3 4

    5 6 7 8 Number 20% (small)

    Sales value Rs 80% large

    Number 80% (large)

    Sales value Rs 20% low

  • 7/28/2019 Mis Report on Pepsi Updated

    47/53

    Critical

    Non Critical

    Interpretation of Music 3-D

    In integrating, we have taken only two categories in each off the threedimensions, leading to eight categories. Otherwise, by conventionalmethods we get three categories in each dimension (ABC X VED XSDE), leading to 27 categories. Thus the separate part will fall into anyeight of the categories. For easy understanding of operators the bin cardsmay be in eight different colors. We may also able to know that itemsfalling in cells 3,4,7 and 8 account for 80% in terms of number but with alow sales value of 20% only. For items falling in cell 3, the inventory

    level should be highabout two years stock, there should be no stock outAt any cost, storage should be always nearest to the user, purchasershould be highly decentralized, with maximum possible service level of100% and minimum audit efforts.

    Similarly for items falling in cell 1, with LLT, HSV and high criticality,the planning should be perfect with maximum possible marketintelligence system, minimum margin of profit per item due to increased

    turnover, low inventory but minimum stock out by application of

    47 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    48/53

    mathematical formulae, scientific application of norms, and maximumfollow-up and records. Items falling in cell 2, will have treatment similarto that of items in 1, but to a lesser degree. Items falling in cell 6, willreceive treatment opposite to that in cell 3, namely low/zero inventory,storage for the entire industry in the form of a blank, purchase decisiontaken at the highest level with the unavoidable delays, very low servicelevels delivered at the last moment. It is not useful to visualize costreduction techniques like value engineering, value analysis, etc. for itemsin cell 3, 4, 7, 8 as the cost of application of these techniques will begreater than cost of the item and initially it is dangerous to apply for theitems in cells 1 and 2 as they are critical. The starting point of applicationof cost reduction techniques is for items in 5 and 6.

    48 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    49/53

    Suggestions for Improvement

    Application of Music 3-D system in Store:

    The application of Music 3-d system may help the store managerto maintain a better control over the flow of inventory. Thus the

    basic advantages of this system can be:

    Strict control over Inventory levels Prompt MIS ( Market Intelligence System)

    Low obsolescence

    Easy Audit

    Better Stock reviews

    Movement Analysis

    Reduction in lead time.

    Visibility of Lead time:

    From the analysis of the Engg.Store, it has been concluded thatbesides of application of all the latest techniques of Inventorymanagement, one aspect that is still missing --- is the visibility ofthe lead time. Although proper records are kept with thedepartmental heads but still a constrain for a stranger or any worker/

    employee not familiar with the store. So efforts should be made toshow the visibility of the lead time for different inventories lying inthe store so that one can easily know how much time the inventorytakes to get into the store from the time of placing the order. Hence,may lead to better control over the level of the inventory lying in thestore.

    Non carbonated drinks are the fastest growing part of the

    industry, so the company shall introduce new brands of non

    49 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    50/53

    carbonated drinks to the Indian customers, as is also favored by thesociety.

    Swot Analysis Of Pepsi Co.Below is one of our free research papers on Swot AnalysisOf Pepsi Co.. If the term paper below is not exactly whatyou're looking for, you can search our essay database forother topics ororder a custom essay.

    PepsiCo Inc. (PepsiCo) is one of the largest food andbeverages companies in the world. It manufactures,

    markets, and sells a variety of salty, sweet and grain-basedsnacks, carbonated and non-carbonated beverages. It owns18 mega brands which are known around the world andgenerate annual sales of over $1 billion each. Some of theseinclude: Pepsi-Cola, Diet Pepsi, Gatorade, Lay's andTropicana Pure Premium Orange Juice. The company isheadquartered in New York and employs 185,000 people as

    on 31st December, 2007 (FY2007). The company recordedrevenues of $39,474 million during the FY2007, an increaseof 12.3% over FY2006. The operating profit of the companywas $7,170 million during FY2007, an increase of 10.3%over FY2006. The net profit was $5,658 million in FY2007,an increase of 0.3% over FY2006.

    50 | P a g e

    http://search.php/http://www.writemyessay.com/custom-writing/?utm_source=oppapers.com&utm_medium=essay133694&utm_campaign=network_widehttp://search.php/http://www.writemyessay.com/custom-writing/?utm_source=oppapers.com&utm_medium=essay133694&utm_campaign=network_wide
  • 7/28/2019 Mis Report on Pepsi Updated

    51/53

    Swot Analysis Of Pepsi Co. Strength:

    Pepsi has a broader product line and outstandingreputation.Merger of Quaker Oats produced synergy across theboard.Record revenues and increasing market share.

    Lack of capital constraints (availability of large freecash flow).o Great brands, strong distribution, innovativecapabilitieso Number one maker of snacks, such as corn chipsand potato chipsPepsiCo sells three products through the same

    distribution channel.For example, combining the production capabilitiesof Pepsi, Gatorade and Tropicana is a bigopportunity to reduce costs, improve efficiency andsmooth out the impact of seasonal fluctuations indemand for particular product.

    51 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    52/53

    Weakness:

    Pepsi hard to inspire vision and direction for largeglobal company.

    Not all PepsiCo products bear the company namePepsiCo is far away from leader Coca-cola in theinternational market - demand is highly elastic.

    Opportunity:Food division should expand internationallyNoncarbonated drinks are the fastest-growing part

    of the industryThere are increasing trend toward healthy foodsFocus on most important customer trend -"Convenience".

    52 | P a g e

  • 7/28/2019 Mis Report on Pepsi Updated

    53/53

    Threats

    F&B industry is maturePepsi is blamed for pesticide residues in their

    products in one of their most promising emergingmarket e.g in IndiaOver 50 percent of the company's sales come fromFrito-Lay; this is a threat if the market takes adownturnPepsiCo now competes with Cadbury Schweppes,Coca-Cola, and Kraft foods (because of broader

    product line) which are well-run and financiallysound competitors.Size of company will demand a varied marketingprogram; Social, cultural, economic, political andgovernmental constrains.

    Strategies

    The purpose of the strategy is to increase the EPS by15% per annum and increase PepsiCo's...