Warehousing

In: Business and Management

Submitted By par123tha
Words 1128
Pages 5
McDonald’s India
Behind the golden arches – Building a robust supply chain

Some facts about who we are…


International
– First restaurant opened in 1955 in Des Plaines, Illinois USA – Single largest Food Service Retailer in the world – Serves around 50 million customers every day – Around than 30,000 Restaurants worldwide across 120+ countries



India
– Started in 1996 – Currently present in around 40 cities with around 180 restaurants – Serves around 500,000 customers daily – Unique menu with Vegetarian products and Nonvegetarian products (Fish, Chicken)

…World’s largest democracy
… 2nd largest population in the world …fastest growing middle class consumers

Incredible India

A land of huge opportunities


At 175 million tonnes per annum, India is the second largest producer of fruits and vegetables ……but more than 15 billion US$ worth fruits and vegetables wasted every year post harvest …. only 2.2% of the produce is processed 3rd largest producer of potatoes
…..but less than 5% of potatoes grown are process grade





World’s largest producer of milk
…however yield per lactation cycle of a buffalo is 1/10th of US

Supply Chain Challenges
Agriculture
•Outdated farming and irrigation practices

Logistics & Distribution
•Poor road and other infrastructure conditions •Cold chain – virtually non-existent

•Huge wastage of natural resources (water, electricity etc.)
•Lack of proper storage facility at farm level for storing post harvest produce •Crops like iceberg lettuce not commercially grown

•Only 200 refrigerated trucks in whole of India
•Specialized temperature controlled warehouses (e.g. for potato storage) not available

Food Processing
•Patty processing – No plant for patty processing (veg or non-veg) •Bakery – identified as small scale industry and bread making, hence limited investments. •Processed Potatoes – French fries not known to Indian…...

Similar Documents

Warehousing System

...and attaching compliance labels to the shipments you will want to make sure that the WMS can use this to automate your receiving process. In addition, if you have requirements to provide ASNs for customers, you will also want to verify this functionality. Cycle Counting. Most WMS will have some cycle counting functionality. Modifications to cycle counting systems are common to meet specific operational needs. Read my article on Cycle Counting and check out my book on Inventory Accuracy and Cycle Counting. Cross Docking. In its purest form cross-docking is the action of unloading materials from an incoming trailer or rail car and immediately loading these materials in outbound trailers or rail cars thus eliminating the need for warehousing (storage). In reality pure cross-docking is less common; most "cross-docking" operations require large staging areas where inbound materials are sorted, consolidated, and stored until the outbound shipment is complete and ready to ship. If cross docking is part of your operation you will need to verify the logic the WMS uses to facilitate this. Pick-to-Carton. For parcel shippers pick-to-carton logic uses item dimensions/weights to select the shipping carton prior to the order picking process. Items are then picked directly into the shipping carton. When picking is complete, dunnage is added and the carton sealed eliminating a formal packing operation. This logic works best when picking/packing products with similar size/weight......

Words: 4159 - Pages: 17

Warehousing

... Warehousing plays a vital part in a logistics system. In the past, we always thought that warehouse is used for storage of inventories. In today’s quick response, the growth of warehouse not only serves for storage, but also for movement, information transfer and valued added services. A good warehouse space and layout planning is a primary element for efficient warehouse. Tompkins and Harmelink (2004, p.240) state the purposes of warehouse layout are space usage efficiency; allowing for efficient material handling; cost efficiency; maximum flexibility and good housekeeping. Successful warehouse layout could maximize space utilization, minimize and control movement and location, and provide safety and security environment. The first step in warehouse layout planning is to consider the space requirement. Tompkins et al. (1996, p.430) state space conservation, space limitations, accessibility and orderliness are some factors on designing layout. In layout planning, as space will be limited by floor loads, truss, the height of ceiling, etc, it should be maximized utilization of concentration and cube and also minimized honeycombing. To optimize space utilization, it is not only developed by horizontally but also by vertically. Space concentration and cube utilization can benefit for the flexibility and ability for bulky receipts such as higher and thicker materials. Tompkins and Smiths (1998, p.243) describe honeycombing is storage space losing due to improper use of storage......

Words: 823 - Pages: 4

Data Warehousing

...head: SHORT TITLE OF PAPER (<= 50 CHARACTERS) Data Warehousing and Data Mining Bruce Nimo CIS 111 March 19, 2012. Prof Jones Data mining is a process of numerical analysis. Analysts use technical tools to query and sort through terabytes of data looking for patterns. Usually, the analyst will develop a hypothesis, such as customers who buy product X usually buy product Y within six months. Running a query on the relevant data to prove or disprove this theory is data mining. Data warehousing describes the process of designing how the data is stored in order to improve reporting and analysis. Data warehouse experts consider that the various stores of data are connected and related to each other conceptually as well as physically. A business's data is usually stored across a number of databases. However, to be able to analyze the broadest range of data, each of these databases needs to be connected in some way. This means that the data within them need a way of being related to other relevant data and that the physical databases themselves have a connection so their data can be looked at together for reporting purposes. Businesses then use this information to make better business decisions based on how they understand their customers' and suppliers' behaviors. Examples of businesses that use data warehousing and data mining are amason.com, Wal-Mart stores Inc etc. Both data mining and data warehousing are business intelligence tools that are used to turn......

Words: 1181 - Pages: 5

Data Warehousing

...Data warehousing: what is it, why do we want to do it, how is it done? How do data warehouses compare with operational databases? What do we want to consider when doing so, and what are our options in terms of implementation? In this article, I discuss data warehouses: what they are, how they compare to operational databases, and how they are designed, implemented and maintained. An operational database is one which is used by the enterprise to run its day to day operations. They are created to support fast transaction processing, with frequent updates. Speed is key to operational databases. They typically are used by clerical staff, and are on the order of megabytes of data to gigabytes. Database consistency is very important to operational databases, and consistency checks and constraints are rigidly enforced. They contain the most current set of data applicable to running enterprise operations. These are our sales and inventory databases. A data warehouse differs from this in many ways. They are used by management for making decisions, watching trends, and running reports. They are typically used offline, have few users and are very large: gigabytes to terabytes. They contain historical data, are read only, and are added to but rarely or never updated (the rows in the database are not changed, I mean). The data in the data warehouse is time sensitive – each row is the warehouse is timestamped so that trending of data versus time can be done. The kinds...

Words: 1530 - Pages: 7

Warehousing

...Solved Questions |1 |Distinguish between warehouses and distribution centers. | | | | | |Warehouses emphasize the storage of products and their primary purpose is to maximize the use of storage space. In | | |contrast, distribution centers emphasize the rapid movement of products through a facility and thus attempt to maximize| | |throughput (the amount of product entering and leaving a facility in a given time period). | |2 |Explain the four ways that warehousing facilitates the regrouping function. | | | | | |Regrouping involves rearranging the quantities of products as they move through the supply chain and it takes four | | |forms: accumulating (also referred to as bulk-making), allocating (also referred to as bulk-breaking), assorting, and | | |sorting. | | |Accumulating involves bringing together similar stocks from different sources, while allocating involves breaking ...

Words: 800 - Pages: 4

Warehousing Design

...Future of Warehouse Design being shaped by Warehouse Science The current scenario of Indian warehousing design is optimistic as it is fast picking up the western practices and technology. However there is still a wide disparity across the whole of India. Some warehouses which are owned by rich MNCs are of high standards, on the other hand, there are also many warehouses which are of low standards. Many warehouses in India are constrained by small spaces. Unlike large warehouses owned by MNCs in the USA and Europe have area of 250,000 to 1-million-square-feet, generally the large of warehouses in India are quite small in comparison, between 5,000 and 25,000 square feet. This is due to less demand, expensive land at the outskirts of a major city in India and difficulty to acquire large piece of lands due to many owners of a small pieces of land. In addition, the demand for storage of products is much lesser than compared to western countries. The warehouse structures are not properly Inefficient space utilisation is also a huge problem as many warehouses in India don’t have proper shelving system and the floors are dirty because it is not cemented. In addition, considerable number of warehouses lack the basic semi-automated equipment such as MHEs, conveyors, dock levellers, for movement of goods inside the warehouse. Fully - automated machines and systems are very rare to be found in India. Automatic sorting and automatic packaging systems (which include pouching,......

Words: 442 - Pages: 2

Database and Data Warehousing Design

...Running head: DATABASE AND DATA WAREHOUSING DESIGN Database and Data Warehousing Design Yolanda McCollum Dr. Constance D. Blanson CIS499: Information Systems Capstone February 11, 2014 Database and Data Warehousing Design Why does one need data warehousing? According to Total Metrics (2013): 1. The prime purpose of a Data Warehouse is to store, in one system, data and information that originates from multiple applications within, or across, organizations. The data may be stored ‘as received’ from the source application, or it may be processed upon input to validate, translate, aggregate, or derive new data/information. 2. Most of the data load functions are processed in batch. There are few on-line data maintenance functions. The on-line functions that do exist tend to update the reference files and data translation tables. 3. A database alone does not constitute a Data Warehouse system. At a minimum, a Data Warehouse system must include the database and corresponding load functions. Data reporting functions are optional. They may, or may not be an integral part of the Data Warehouse system. 4. The prime purpose of storing the data is to support the information reporting requirements of an organization i.e. multiple users and multiple applications. 5. The Data Warehouse may, or may not, provide the required reporting functions. In some cases, external applications access the Data Warehouse files to generate their own reports and queries. 6. Data......

Words: 880 - Pages: 4

The Importance of Data Warehousing

...The Importance of Data Warehousing Brenda L Bach The Digital Firm and Business Communications/BU 204-8A November 15, 2014 Ron Rosalik Kenneth and Jane Laudon state that a data warehouse is a database that stores current and historical data that can be of potential interest to decision makers throughout the corporation (Laudon, 2011. p.225). They go on to explain that the data can originate from many core operational transaction systems and could include data from Web site transactions (Laudon, 2011 p.225). Data warehouse extract current along with historical data from all operational systems within an organization. The data warehouse makes the data it collects and stores available to anyone and can be accessed and viewed as needed but cannot be altered in any manner. These data warehouses also provide a large range of ad hoc as well as analytical tools and graphical reports that represent the data. Companies often build enterprise data warehouses and either uses a central data warehouse or a smaller decentralized warehouse called a data mart to preserve the data they collect through its many sources. A data mart is a subset of a data warehouse that summarizes on a highly focused portion of the organization’s data and is placed within a separate data based for a very specific population of users. For example, a car dealer that deals with car sales as well as service may use a data mart to develop marketing and sales data that are specifically focused on the data of......

Words: 774 - Pages: 4

Data Warehousing

...Business Objects Enterprise Training Curriculum Data Warehousing: • Introduction to Business Objects Enterprise Reporting • Fundamentals of Data warehouse Concepts • Introduction to Dimensional Modeling • Developing a Star Schema Reporting: • Building and editing queries with Web Intelligence • Performing on report analysis with Web Intelligence • Filtering Queries using conditions, prompts etc., • Using Combined Queries and merging dimensions • Displaying data in various formats (Ex: Tables, Charts etc.,) Advanced Reporting: • Calculations, Formulas and variables • Ranking Data, using Alerters to highlight data, Formatting numbers and Dates • Understanding Calculation Contexts • Web Intelligence Functions, Operators and Keywords • Calculating values with Smart Measures Universe Designer: • Designer and Universe Fundamentals • Creating a schema with Tables and Joins • Resolving Join problems in a schema • Defining Classes, Objects, hierarchies, using cascading list of values for hierarchies • Testing the universe • Working with OLAP universes Xcelsius 2008: • Application Overview • Creating and Updating Xcelsius visualizations • Using Xcelsius components ( Chart, Containers, Selectors etc.,) • Exporting Xcelsius visualizations to various applications (Power point, PDF, Flash • Creating templates, Alerts and Dynamic visibility • Using Data Manager ( Creating and configuring connections) • Live Office Connections, Query As A Web Service......

Words: 462 - Pages: 2

Data Warehousing

...Data warehousing is a fairly new but not so new development in the information systems field. Data warehousing can be traced back being in existence since the 1980’s when Teradata in 1983 introduced a database management system (DBMS) designed for decision support systems (Ponniah, 2010). The influence from the two Irish IBM architects Barry Devlin and Paul Murphy who in 1988 laid the foundations for what we call today a data warehouse in their original article “An Architecture for a Business and Information Systems” (Bouman & van Dongen, 2009). It was not long after that Bill Inmon, referred to as the father of data warehousing authored one of the most influential decision support books “Building the Data Warehouse” in 1991(Ponniah, 2010). Since then Prism Solutions in 1991 introduced the Prism Warehouse Manager software for developing data warehouses. The Data Warehousing Institute was also founded 1995 and has and continues to promote data warehousing by way of serving as the leading voice in the business world providing education, research, and support (Ponniah, 2010). With the business environment being more global, competitive, multifaceted and unpredictable there is a need for systems that would satisfy emerging business needs and new technological advances (Wixom & Watson, 2001). The enterprise for enhanced customer relations and e-commerce alone these days require large integrated repositories and advanced analytical repositories (Wixom & Watson, 2001). Data......

Words: 1682 - Pages: 7

Agricultural Warehousing & Marketting

...Policies towards Warehousing & Marketing Dr Murari Lal Gaur The warehousing and marketing facilities have important linkages that help farmers and traders gain from agricultural trade, where storage use to be an extremely vital function for success deciding success of agricultural marketing. It involves holding and preserving of agricultural commodities from the time they are produced until they are needed for consumption. Looking into prevailing socio economic scenario of Indian farmers there exists an inevitable need to provide the farming community with facilities for scientific storage, so that wastage and produce deterioration are avoided and also to enable it to meet its credit requirement without being compelled to sell the produce at a time when the prices are low. An improved policy framework accommodating modern infrastructure and smart management tools & techniques like IT, ICT , and e-trading may help in reduction of wastage and better marketing and will enable small & marginal farmers to enhance their holding capacity in order to sell their produce at remunerative prices and avoid distress sales. Agricultural activities in India are largely carried out by small and marginal farmers, where exists about 121 million operational holdings, over 80 % of which comprise marginal and small holdings (< 2 ha). There subsist variety of marketing services & facilities in the sectors of R&D, Extension, and other market intelligence services by Government sector,......

Words: 856 - Pages: 4

Data Warehousing

...time. Reports and queries, which can require a much greater range of limited server/disk resources than transaction processing, run on the servers/disks used by transaction processing systems can lower the probability that transactions complete in an acceptable amount of time. Or, running queries and reports, with their variable resource requirements, on the servers/disks used by transaction processing systems can make it quite complex to manage servers/disks so there is a high enough probability that acceptable response time can be achieved. Firms therefore may find that the least expensive and/or most organizationally expeditious way to obtain high probability of acceptable transaction processing response time is to implement a data warehousing architecture that uses separate servers/disks for some querying and reporting. To use data models and/or server technologies that speed up querying and reporting and that are not appropriate for transaction processing There are ways of modeling data that usually speed up querying and reporting (e.g., a star schema) and may not be appropriate for transaction processing because the modeling technique will slow down and complicate transaction processing. Also, there are server technologies that that may speed up query and reporting processing but may slow down transaction processing (e.g., bit-mapped indexing) and server technologies that may speed up transaction processing but slow down query and report processing (e.g., technology......

Words: 1160 - Pages: 5

Data Warehousing

...Data Warehousing Essay, Research Paper Contents 1. Introduction 2. What is a data warehouse 3. Past, Present and Future 4. Data Warehouses and Business Organisations 5. Conclusion 6. Bibliography 1.0 Introduction In recent years, data warehousing has emerged as the primary method of analysing sales and marketing data for a competitive advantage. As the number of knowledge workers using the data warehouse/data mart grows and the amount of data increases daily, performance problems have become a major concern of both the Information Systems staff and the users. Many options have been tried in an attempt to solve the performance problems – from bigger hardware to different software or database tuning and redesign using star schemas or snowflake data structures. However, all have limitations – either in functionality or in terms of cost – and their strengths are almost inevitably outstripped by users’ demands. During the past three years, data warehousing has emerged as one of the hottest trends in information technology for corporations seeking to utilise the massive amounts of data they are accumulating. Managers from all business disciplines want enterprise wide information access, as well as the ability to manipulate and analyse information that the company has gathered for a single purpose, to make more intelligent business decisions. Whether to increase customer value, identify new markets or improve the management of the firm’s assets, the data......

Words: 3367 - Pages: 14

Warehousing

...Warehousing plays a vital part in a logistics system. In the past, we always thought that warehouse is used for storage of inventories. In today’s quick response, the growth of warehouse not only serves for storage, but also for movement, information transfer and valued added services. A good warehouse space and layout planning is a primary element for efficient warehouse. Tompkins and Harmelink (2004, p.240) state the purposes of warehouse layout are space usage efficiency; allowing for efficient material handling; cost efficiency; maximum flexibility and good housekeeping. Successful warehouse layout could maximize space utilization, minimize and control movement and location, and provide safety and security environment. The first step in warehouse layout planning is to consider the space requirement. Tompkins et al. (1996, p.430) state space conservation, space limitations, accessibility and orderliness are some factors on designing layout. In layout planning, as space will be limited by floor loads, truss, the height of ceiling, etc, it should be maximized utilization of concentration and cube and also minimized honeycombing. To optimize space utilization, it is not only developed by horizontally but also by vertically. Space concentration and cube utilization can benefit for the flexibility and ability for bulky receipts such as higher and thicker materials. Tompkins and Smiths (1998, p.243) describe honeycombing is storage space losing due to improper use of......

Words: 295 - Pages: 2

Data Warehousing

...Data Warehousing Saikrishna Burugula IST 7000 Data Management Wilmington University Abstract A data storage could be a subject-oriented, integrated, time-variant, non-updateable assortment of knowledge utilized in business intelligence and support of organizing decision-making method (Inmon, Strauss & Neushloss, 2008). In data warehousing when the data is stored it is not updated, commonly data warehousing intended for evaluation connected with data source in addition to addressing queries it can be called copy of addressing data (Prabhu, 2002). The key intention with this paper is typically to target on the actual design connected with data warehouse in addition to modeling techniques like ER modeling and Dimensional modeling. Introduction A Data Warehouse is not just a new combination of all of the in business databases in an organization. Because of its attention on business intelligence, exterior data, and time variant information, a data warehouse is usually a special type of database. The good thing is, you should not learn another number of database abilities to do business with a new information storage place. Most data warehouses tend to be relational databases designed in many ways optimized pertaining to selection assistance, definitely not in business information running. Facts warehousing could be the procedure whereby organizations create and gaze after information...

Words: 1513 - Pages: 7