Wednesday, 12 November 2008

FMCG Market Smart Bridge Neeraj Nathani Smart Bridge



                                                                FMCG Market
Fast-moving consumer goods (FMCG) or consumer packaged goods (CPG) are products that are sold quickly and at relatively low cost. Examples include non-durable goods such as soft drinkstoiletries, and grocery items.[1][2] Though the absolute profit made on FMCG products is relatively small, they are generally sold in large quantities, and so the cumulative profit on such products can be substantial.
Fast-moving consumer electronics are a type of FMCG and are typically low priced generic or easily substitutable consumer electronics, including lower end mobile phonesMP3 playersgame players, and digital cameras, which have a short usage life, typically a year or less, and as such are disposable. Cheap FMCG electronics are often retained even after immediate failure, as the purchaser rationalizes the decision to not return the goods on the basis that the goods were cheap to begin with, and that the cost of return relative to the low cost of purchase is high. Thus low-quality electronic FMCG goods can be highly profitable for the vendors.
The term FMCGs refers to those retail goods that are generally replaced or fully used up over a short period of days, weeks, or months, and within one year. This contrasts with durable goods or major appliances such as kitchen appliances, which are generally replaced over a period of several years
FMCG have a short shelf life, either as a result of high consumer demand or because the product deteriorates rapidly. Some FMCGs—such as meat, fruits and vegetables, dairy products, and baked goods—are highly perishable. Other goods such as alcohol, toiletries, pre-packaged foods, soft drinks, and cleaning products have high turnover rates. An excellent example is a newspaper—every day's newspaper carries different content, making one useless just one day later, necessitating a new purchase every day.
The following are the main characteristics of FMCGs:[1]
  • From the consumers' perspective:
    • Frequent purchase
    • Low involvement (little or no effort to choose the item – products with strong brand loyalty are exceptions to this rule)
    • Low price
  • From the marketers' angle:
Source: Wikipedia.

Friday, 24 October 2008

Neeraj Nathani smart Bridge RETAILING



RETAILING

Retail is the sale of goods and services from individuals or businesses to the end-user. Retailers are part of an integrated system called the supply chain. A retailer purchases goods or products in large quantities from manufacturers directly or through a wholesale, and then sells smaller quantities to the consumer for a profit. Retailing can be done in either fixed locations like stores or markets, door-to-door or by delivery. Retailing includes subordinated services, such as delivery. The term "retailer" is also applied where a service provider services the needs of a large number of individuals, such as a public. Shops may be on residential streets, streets with few or no houses or in a shopping mall. Shopping streets may be for pedestrians only. Sometimes a shopping street has a partial or full roof to protect customers from precipitation. Online retailing, a type of electronic commerce used for business-to-consumer (B2C) transactions and mail order, are forms of non-shop retailing.
Shopping generally refers to the act of buying products. Sometimes this is done to obtain necessities such as food and clothing; sometimes it is done as a recreational activity. Recreational shopping often involves window shopping (just looking, not buying) and browsing and does not always result in a purchase
Types of retail outlets
marketplace is a location where goods and services are exchanged. The traditional market square is a city square where traders set up stalls and buyers browse the merchandise. This kind of market is very old, and countless such markets are still in operation around the whole world.
In some parts of the world, the retail business is still dominated by small family-run stores, but this market is increasingly being taken over by large retail chains.
Retail is usually classified by type of products as follows:
  • Food products
  • Hard goods or durable goods ("hardline retailers") - appliances, electronics, furniture, sporting goods, etc. Goods that do not quickly wear out and provide utility over time.
  • Soft goods or consumables - clothing, apparel, and other fabrics. Goods that are consumed after one use or have a limited period (typically under three years) in which you may use them.
There are the following types of retailers by marketing strategy:
  • Department stores - very large stores offering a huge assortment of "soft" and "hard goods; often bear a resemblance to a collection of specialty stores. A retailer of such store carries variety of categories and has broad assortment at average price. They offer considerable customer service.
  • Discount stores - tend to offer a wide array of products and services, but they compete mainly on price offers extensive assortment of merchandise at affordable and cut-rate prices. Normally retailers sell less fashion-oriented brands.
  • Warehouse stores - warehouses that offer low-cost, often high-quantity goods piled on pallets or steel shelves; warehouse clubs charge a membership fee;
  • Variety stores - these offer extremely low-cost goods, with limited selection;
  • Demographic - retailers that aim at one particular segment (e.g., high-end retailers focusing on wealthy individuals).
  • Mom-And-Pop : is a retail outlet that is owned and operated by individuals. The range of products are very selective and few in numbers. These stores are seen in local community often are family-run businesses. The square feet area of the store depends on the store holder.
  • Specialty stores: A typical speciality store gives attention to a particular category and provides high level of service to the customers. A pet store that specializes in selling dog food would be regarded as a specialty store. However, branded stores also come under this format. For example if a customer visits a Reebok or Gap store then they find just Reebok and Gap products in the respective stores.
  • General store - a rural store that supplies the main needs for the local community;
  • Convenience stores: is essentially found in residential areas. They provide limited amount of merchandise at more than average prices with a speedy checkout. This store is ideal for emergency and immediate purchases as it often works with extended hours, stocking everyday;
  • Hypermarkets: provides variety and huge volumes of exclusive merchandise at low margins. The operating cost is comparatively less than other retail formats.
  • Supermarkets: is a self-service store consisting mainly of grocery and limited products on non food items. They may adopt a Hi-Lo or an EDLP strategy for pricing. The supermarkets can be anywhere between 20,000 and 40,000 square feet (3,700 m2). Example: SPAR supermarket.
  • Malls: has a range of retail shops at a single outlet. They endow with products, food and entertainment under a roof.
  • Category killers or Category Specialist: By supplying wide assortment in a single category for lower prices a retailer can "kill" that category for other retailers. For few categories, such as electronics, the products are displayed at the centre of the store and sales person will be available to address customer queries and give suggestions when required. Other retail format stores are forced to reduce the prices if a category specialist retail store is present in the vicinity.
  • E-tailers: The customer can shop and order through internet and the merchandise are dropped at the customer's doorstep. Here the retailers use drop shipping technique. They accept the payment for the product but the customer receives the product directly from the manufacturer or a wholesaler. This format is ideal for customers who do not want to travel to retail stores and are interested in home shopping. However it is important for the customer to be wary about defective products and non secure credit card transaction. Example: Amazon, Pennyful and eBay.
  • Vending Machines: This is an automated piece of equipment wherein customers can drop the money in the machine and acquire the products.
Some stores take a no frills approach, while others are "mid-range" or "high end", depending on what income level they target.
Other types of retail store include:
  • Automated Retail stores are self-service, robotic kiosks located in airports, malls and grocery stores. The stores accept credit cards and are usually open 24/7. Examples include ZoomShops and Redbox.
  • Big-box stores encompass larger department, discount, general merchandise, and warehouse stores.
Retailers can opt for a format as each provides different retail mix to its customers based on their customer demographics, lifestyle and purchase behaviour. A good format will lend a hand to display products well and entice the target customers to spawn sales.
Global Top Five Retailers
Worldwide Top Five Retailers[2]
Retail Sales Rank
Company
Country of Origin
2010 group revenue (US $mil)
1
US
$421,849
2
France
$121,519
3
UK
$94,244
4
Germany
$89,311
5
US
$82,189

Operations

Retail pricing

The pricing technique used by most retailers is cost-plus pricing. This involves adding a markup amount (or percentage) to the retailer's cost. Another common technique is suggested retail pricing. This simply involves charging the amount suggested by the manufacturer and usually printed on the product by the manufacturer.
In Western countries, retail prices are often called psychological prices or odd prices. Often prices are fixed and displayed on signs or labels. Alternatively, when prices are not clearly displayed, there can be price discrimination, where the sale price is dependent upon who the customer is. For example, a customer may have to pay more if the seller determines that he or she is willing and/or able to. Another example would be the practice of discounting for youths, students, or senior citizens..

Staffing

Because patronage at a retail outlet varies flexibility in scheduling is desirable. Employee scheduling software is sold which, using known patterns of customer patronage, more or less reliably predicts the need for staffing for various functions at times of the year, day of the month or week, and time of day. Usually needs vary widely. Conforming staff utilization to staffing needs requires a flexible workforce which is available when needed but does not have to be paid when they are not, part-time workers; as of 2012 70% of retail workers in the United States were part-time. This may result in financial problems for the workers, who while they are required to be available at all times if their work hours are to be maximized, may not have sufficient income to meet their family and other obligations.[3]

Transfer mechanisms

There are several ways in which consumers can receive goods from a retailer:
  • Counter service, where goods are out of reach of buyers and must be obtained from the seller. This type of retail is common for small expensive items (e.g. jewelry) and controlled items like medicine and liquor. It was common before the 1900s in the United States and is more common in certain countries like India.[which?]
  • Delivery, where goods are shipped directly to consumer's homes or workplaces. Mail orderfrom a printed catalog was invented in 1744 and was common in the late 19th and early 20th centuries. Ordering by telephone is now common, either from a catalog, newspaper, television advertisement or a local restaurant menu, for immediate service (especially for pizza delivery). Direct marketing, including telemarketing and television shopping channels, are also used to generate telephone orders. started gaining significant market share in developed countries in the 2000s.
  • Door-to-door sales, where the salesperson sometimes travels with the goods for sale.
  • Self-service, where goods may be handled and examined prior to purchase

Source: Wikipedia.

Monday, 13 October 2008

nEERAJ nATHANI Smart Bridge ETL TOOLS USED IN BUSINESS INTELLIGENCE & DATAWAREHOUSING PROJECTS.



ETL TOOLS USED IN BUSINESS INTELLIGENCE & DATAWAREHOUSING PROJECTS.
EXTRACT
The first part of an ETL process involves extracting the data from the source systems. In many cases this is the most challenging aspect of ETL, since extracting data correctly sets the stage for how subsequent processes go further.
Most data warehousing projects consolidate data from different source systems. Each separate system may also use a different data organization/format. Common data source formats are relational databases and flat files, but may include non-relational database structures such as Information Management System (IMS) or other data structures such as Virtual Storage Access Method (VSAM) or Indexed Sequential Access Method (ISAM), or even fetching from outside sources such as through web spidering or screen-scraping. The streaming of the extracted data source and load on-the-fly to the destination database is another way of performing ETL when no intermediate data storage is required. In general, the goal of the extraction phase is to convert the data into a single format which is appropriate for transformation processing.
An intrinsic part of the extraction involves the parsing of extracted data, resulting in a check if the data meets an expected pattern or structure. If not, the data may be rejected entirely or in part

Transform

The transform stage applies a series of rules or functions to the extracted data from the source to derive the data for loading into the end target. Some data sources will require very little or even no manipulation of data. In other cases, one or more of the following transformation types may be required to meet the business and technical needs of the target database:
  • Selecting only certain columns to load (or selecting null columns not to load). For example, if the source data has three columns (also called attributes), for example roll_no, age, and salary, then the extraction may take only roll_no and salary. Similarly, the extraction mechanism may ignore all those records where salary is not present (salary = null).
  • Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
  • Encoding free-form values (e.g., mapping "Male" to "1")
  • Deriving a new calculated value (e.g., sale_amount = qty * unit_price)
  • Sorting
  • Joining data from multiple sources (e.g., lookup, merge) and deduplicating the data
  • Aggregation (for example, rollup — summarizing multiple rows of data — total sales for each store, and for each region, etc.)
  • Generating surrogate-key values
  • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
  • Splitting a column into multiple columns (e.g., converting a comma-separated list, specified as a string in one column, into individual values in different columns)
  • Disaggregation of repeating columns into a separate detail table (e.g., moving a series of addresses in one record into single addresses in a set of records in a linked address table)
  • Lookup and validate the relevant data from tables or referential files for slowly changing dimensions.
  • Applying any form of simple or complex data validation. If validation fails, it may result in a full, partial or no rejection of the data, and thus none, some or all the data is handed over to the next step, depending on the rule design and exception handling. Many of the above transformations may result in exceptions, for example, when a code translation parses an unknown code in the extracted data.

Load

The load phase loads the data into the end target, usually the data warehouse (DW). Depending on the requirements of the organization, this process varies widely. Some data warehouses may overwrite existing information with cumulative information, frequently updating extract data is done on daily, weekly or monthly basis. Other DW (or even other parts of the same DW) may add new data in a historical form, for example, hourly. To understand this, consider a DW that is required to maintain sales records of the last year. Then, the DW will overwrite any data that is older than a year with newer data. However, the entry of data for any one year window will be made in a historical manner. The timing and scope to replace or append are strategic design choices dependent on the time available and the business needs. More complex systems can maintain a history and audit trail of all changes to the data loaded in the DW.
As the load phase interacts with a database, the constraints defined in the database schema — as well as in triggers activated upon data load — apply (for example, uniqueness, referential integrity, mandatory fields), which also contribute to the overall data quality performance of the ETL process.
  • For example, a financial institution might have information on a customer in several departments and each department might have that customer's information listed in a different way. The membership department might list the customer by name, whereas the accounting department might list the customer by number. ETL can bundle all this data and consolidate it into a uniform presentation, such as for storing in a database or data warehouse.
  • Another way that companies use ETL is to move information to another application permanently. For instance, the new application might use another database vendor and most likely a very different database schema. ETL can be used to transform the data into a format suitable for the new application to use.

BELOW ARE THE TOOLS USED:

A
B
D
E



I
L
M
O
P
S
T

Source: Wikipedia.

Saturday, 27 September 2008

Neeraj Nathani_Smart Bridge FMCG Market



                                                                FMCG Market
Fast-moving consumer goods (FMCG) or consumer packaged goods (CPG) are products that are sold quickly and at relatively low cost. Examples include non-durable goods such as soft drinkstoiletries, and grocery items.[1][2] Though the absolute profit made on FMCG products is relatively small, they are generally sold in large quantities, and so the cumulative profit on such products can be substantial.
Fast-moving consumer electronics are a type of FMCG and are typically low priced generic or easily substitutable consumer electronics, including lower end mobile phonesMP3 playersgame players, and digital cameras, which have a short usage life, typically a year or less, and as such are disposable. Cheap FMCG electronics are often retained even after immediate failure, as the purchaser rationalizes the decision to not return the goods on the basis that the goods were cheap to begin with, and that the cost of return relative to the low cost of purchase is high. Thus low-quality electronic FMCG goods can be highly profitable for the vendors.
The term FMCGs refers to those retail goods that are generally replaced or fully used up over a short period of days, weeks, or months, and within one year. This contrasts with durable goods or major appliances such as kitchen appliances, which are generally replaced over a period of several years
FMCG have a short shelf life, either as a result of high consumer demand or because the product deteriorates rapidly. Some FMCGs—such as meat, fruits and vegetables, dairy products, and baked goods—are highly perishable. Other goods such as alcohol, toiletries, pre-packaged foods, soft drinks, and cleaning products have high turnover rates. An excellent example is a newspaper—every day's newspaper carries different content, making one useless just one day later, necessitating a new purchase every day.
The following are the main characteristics of FMCGs:[1]
  • From the consumers' perspective:
    • Frequent purchase
    • Low involvement (little or no effort to choose the item – products with strong brand loyalty are exceptions to this rule)
    • Low price
  • From the marketers' angle:
Source: Wikipedia.

Wednesday, 24 September 2008

Category management Neeraj nathani smart bridge



Category management

Category management is a retailing and purchasing concept in which the range of products purchased by a business organization or sold by a retailer is broken down into discrete groups of similar or related products; these groups are known as product categories (examples of grocery categories might be: tinned fish, washing detergent, toothpastes). It is a systematic, disciplined approach to managing a product category as a strategic business unit.[1] The phrase "category management" was coined by Brian F. Harris.[n/a 1]

Category management in a retail context
Each category is run as a "mini business" (business unit) in its own right, with its own set of turnover and/or profitability targets and strategies. Introduction of Category Management in a business tends to alter the relationship between retailer and supplier: instead of the traditional adversarial relationship, the relationship moves to one of collaboration, with exchange of information, sharing of data and joint business building.
The focus of all supplier negotiations is the effect on turnover of the category as whole, not just the sales of individual products. Suppliers are expected, indeed in many cases mandated, to only suggest new product introductions, a new planogram or promotional activity if it is expected to have a beneficial effect on the turnover or profit of the total category and be beneficial to the shoppers of that category.
The concept originated in grocery (mass merchandising) retailing, and has since expanded to other retail sectors such as DIYcash and carrypharmacy, and book retailing.[2]


Definition of category management (retail)

Category management lacks a single definition thus leading to some ambiguity even among industry professionals as to its exact function. Three comparative mainstream definitions are as follows:
Category management is a process that involves managing product categories as business units and customizing them [on a store by store basis] to satisfy customer needs. (Nielsen)[3]
The strategic management of product groups through trade partnerships which aims to maximize sales and profit by satisfying consumer and shopper needs (Institute of Grocery Distribution)[4]
.. marketing strategy in which a full line of products (instead of the individual products or brands) is managed as a strategic business unit (SBU). (Business Dictionary)[5]
The Nielsen definition, published in 1992, was a little ahead of its time in that customising product offerings on a store by store basis is logistically difficult and is now not considered a necessary part of category management; it is a concept now referred to as micromarketing. Nevertheless, most grocery retailers will segment stores at least by size, and select product assortments accordingly. Wal*Mart's Store of the Community, implemented in North America is one of the few examples of where product offerings are tailored right down to the specific store.[6]
Definition of a category
The Nielsen definition of a category, used as the basic definition across the industry is that the products should meet a similar consumer need, or that the products should be inter-related or substitutable.[8] The Nielsen definition also includes a provision that products placed together in the same category should be logistically manageable in store (for example there may be issues in having room-temperature and chilled products together in the same category even though the initial two conditions are met).
However, this definition does not explain how the process often works in practical retailing situations, where demographic or marketing considerations take precedence.
The category management 8-step process (retail)
http://upload.wikimedia.org/wikipedia/en/thumb/b/b9/8-step-process.gif/220px-8-step-process.gif
http://bits.wikimedia.org/static-1.21wmf12/skins/common/images/magnify-clip.png
The category management 8-step process
The industry standard model for category management in retail is the 8-step process, or 8-step cycle developed by the Partnering Group.[9] The eight steps are shown in the diagram on the right; they are :
  1. Define the category (i.e. what products are included/excluded).
  2. Define the role of the category within the retailer.
  3. Assess the current performance.
  4. Set objectives and targets for the category.
  5. Devise an overall Strategy.
  6. Devise specific tactics.
  7. Implementation.
  8. The eighth step is one of review which takes us back to step 1.
The 8-step process, whilst being very comprehensive and thorough has been criticized for being rather too unwieldy and time-consuming in today's fast-moving sales environment; in one survey only 9% of supplier companies stated they used the full 8-step process.[10] The current industry trend is for supplier companies to use the standard process as a basis to develop their own more streamlined processes, tailored to their own particular products[11]
Market research company Nielsen has a similar process based on only 5 steps : reviewing the category, targeting consumers, planning merchandising, implementing strategy, evaluating results

Category captains

It is commonplace for one particular supplier into a category to be nominated by the retailer as a category captain. The category captain will be expected to have the closest and most regular contact with the retailer and will also be expected to invest time, effort, and often financial investment into the strategic development of the category within the retailer.
In return, the supplier will gain a more influential voice with the retailer. The category captain is often the supplier with the largest turnover in the category. Traditionally the job of category captain is given to a brand supplier, but in recent times the role has also gone to particularly switched-on private label suppliers.[12]
In order to do the job effectively, the supplier may be granted access to a greater wealth of data-sharing, e.g. more access to an internal sales database such as Walmart's Retail Link

Category management in purchasing
Category management can also be applied to purchasing within an organisation. Although the term is the same and there are many similarities with elements of retail category management including the use of similar tools and techniques applied in reverse, the methodology is fundamentally different. Applying Category Management in purchasing benefits organisations by providing an approach to reduce the cost of buying goods and services, reduce risk in the supply chain, increase overall value from the supply base and gain access to more innovation from suppliers. It is a strategic approach that focuses on the vast majority of organisational spend. If applied effectively throughout an entire organisation the results can be significantly greater than traditional transactional based purchasing negotiations.
The concept of Category Management in purchasing originated in the late 80's. There is no single founder or originator but the methodology first appeared in the automotive sector and has since been developed and adopted by organisations worldwide. Today Category Management is considered by many global companies as an essential strategic purchasing approach. Category Management has been defined as “an evolving methodology that drives sourcing strategy in progressive organisations today”.[15]
The Chartered Institute of Purchasing & Supply defines Category Management as:
"organising the resources of the procurement team in such a way as to focus externally onto the supply markets of an organisation (as against having a focus on the internal customers or on internal Procurement departmental functions) in order to fully leverage purchasing decisions”.[16]
Jonathan O'Brien, author of Category Management in Purchasing, defines Category Management as:
"the practice of segmenting the main areas of organisational spend on bought-in goods and services into discrete groups of products and services according to the function of those goods or services and, most importantly, to mirror how individual marketplaces are organised. Using this segmentation organisations work cross functionally on individual categories, examining the entire category spend, how the organisation uses the products or services within the category, the marketplace and individual suppliers.",[17]
Peter Hunt, partner at ADR International, writes
“the term category management can mean different things to different people, so a working definition is needed. A ‘category’ is the logical grouping of similar expenditure items, such as spend on advertising agency services or IT hardware. Category management is the sourcing process used to manage these categories to satisfy business needs while maximising the value delivered from the supply base”.[18]
Many public sector organisations have recently adopted category management as a strategic transformation tool. Sir Philip Green, in his “Efficiency Review” of UK government spending, recommended that “centralised procurement [should be] mandated for common categories to leverage this buying power and achieve best practice”.[19]
Source: Wikipedia.