The design of a cross docking system for Makro Malaysia’s fresh and frozen products and the economical analyses of this cross
docking system for Makro Malaysia.
Author: S.M. Lutke Holzik
Study: Industrial engineering and management science University: University of Groningen
Faculty of Management and Organization Groningen, The Netherlands
Primary supervisor: Drs. D. Vegter Secondary supervisor: Dr. J.T. van der Vaart
Graduation organisation: Makro Cash and Carry Malaysia Kuala Lumpur, Malaysia
Company supervisor: P. Boone
Copyright © 2005 Stephan M. Lutke Holzik. All rights reserved. No part of this publication may be
reproduced, stored in retrieval system, or transmitted, in any form or by any means, electronic, mechanical,
photocopying, recording or otherwise, without the prior permission of the author.
2
Management summary
Makro Malaysia operates a cross docking system for its dry foods. So far cross docking dry resulted in high implementation effort and poor results. Makro’s region office encouraged Makro Malaysia to introduce a cross docking system for its fresh and frozen products, since they expect many benefits from this cross docking system. The goal of this research is defined as:
’’Design a cross docking system for Makro Malaysia’s fresh and frozen products’’ and
’’Identify advantages and disadvantages and perform an economical analysis of this cross docking system for Makro Malaysia’’
This research showed that 2700 products of all fresh and frozen products qualify for cross docking. Qualified products were classified in fruit & vegetables, chilled and frozen products with temperature requirements of respectively (5
0C-10
0C), (0
0C-4
0C) and (- 18
0C/-24
0C). All suppliers of these qualified products were included, since no supplier statistics were available to select suitable suppliers.
A pre-allocated DC consolidation cross docking system was recommended, based on product characteristic and volume flows. Store orders will be consolidated in this system.
Products that arrive at the distribution centre will be assigned to stores and will be send to stores at the same day.
The cross docking facility will be located in Klang Valley with three different temperature segments, in which operations will be performed manually. A facility of 2000 m
2is required, based on the expected throughput in three years, including storage space for expected importing activities. Stores will be delivered daily with f&v products between 4 and 6 a.m. and chilled products will be send in same trucks as f&V, only twice a week. Frozen products will be delivered twice a week in separate trucks during daytime.
Current information systems suffice the requirements of cross docking. Labour equipments were defined and consist of: QC, processing, administration and management employees. Products will be handled by box or pallet with corresponding handling equipment as lift trucks and handpallets.
The economical analyses showed elements in Makro’s supply chain that will be affected
by introducing cross docking. These elements consist of: suppliers, facility, transport,
stores and head office. The expected cost influence of cross docking on these elements,
were analysed by a cost model for each affected element. The supplier cost model
showed that suppliers of f&v, chilled and frozen product will save respectively 0.13, 0.17
and 0.15 Malaysian Ringgit for each kilogram delivered product, mainly because of
lower transport costs. Facility and transport costs depend on throughput and are therefore
calculated in a scenario analyses. The operational costs of stores will be discussed and
seems to be unaffected by introducing cross docking. The head office will save invoice
costs as well as import expenses.
3
Three scenarios were performed to simulate a start up period, an operation period halfway the planning horizon and a full utilisation period. The results of the scenario analyses represent the facility and transport costs minus the supplier, import and invoice savings. Scenario ’’start up’’ showed monthly costs for Makro of RM 190.000, -.
Scenario two showed monthly costs of RM 30.000, -. The last scenario, in which the facilities capacity is utilised optimal, results in RM 20.000, - benefit. The scenario analyses showed that fixed facility costs and transport costs are the main cost elements.
Analysing customer shopping behaviour showed that, price, promotions, quality of products, assortment and availability of products, are important shopping criteria for Makro’s customers. The influence of cross docking on these criteria is therefore important.
Cross docking can result in:
• Increased product quality since products will be delivered more frequently to the stores. This is especially important for horeca customers.
• Increased assortment possibilities, since a standardised assortment throughout Malaysia will be possible, and value added activities in the DC can be performed
• Increased availability of products, since stores will be replenished daily. The system’s sensitivity however is an important disadvantage regarding to product availability
• More promotions, since the distribution centre offers possibilities to increase promotional activities.
• Less congestion of unloading trucks at stores, since lesser trucks will replenish the stores
• Supplier measurements
The main disadvantages of cross docking are:
• High implementation requirements of Makro. Besides, logistic providers in Malaysia are not experienced in cross docking, which results in even higher efforts.
• System sensitivity
• High operational costs in case of low utilisation of the capacity
This research showed that cross docking generates advantages, such as, more promotions,
increased quality and assortment. There was shown as well that operational costs are
high, especially if utilisation of the capacity is low. Cross docking however generates lots
of prospects that might result in cost benefits. Activities, such as, decreasing inventory,
buying from the source, negotiating lower cost price because of purchase power,
importing products, eliminating returnable products, picking up products from suppliers
and eliminating QC at stores, are feasible because of cross docking. This might result in
more financial benefits than costs of operating a cross docking system. This however will
only be the case, when Makro will take advantage of the prospects that originate from
cross docking. Implementing cross docking and not taking advantage of the prospects
will result in high costs for Makro Malaysia.
4
Preface
The first day of my internship at Makro Malaysia started at 5 a.m. Then, I realised I stepped into Malaysia. Hawker stalls started their business, the sun was shining, little children in school uniform with badminton rackets walked by and traffic was (of course) congested. Kuala Lumpur, I love that city! The memories of all nice people, twenty-four seven economy, all shopping malls, pool parties, Chinatown and the Malaysian food make me smile behind this computer. The report you’re reading now is the result of my internship at Makro Malaysia. The melancholic words above reveal the way I enjoyed my stay in Malaysia. This stay wouldn’t be that great without the following persons, who I really want to thank.
’’Just do the work, but more important enjoy your stay here’’ was the message of Pieter Boone when I entered Makro’s head office in Shah Alahm. I am really thankful for his way of supervision and the opportunity he offered me to do my internship at Makro Malaysia. Thanks to him, I had the opportunity to experience working abroad, explore Malaysia and Bangkok, and experience working in the logistic area.
Next to Pieter, I really want to thank Alex, Boni and Prakash for the delicious lunch places they brought me to.
Lunch was the highlight of the day.
They taught me the Malaysian way of living and recommended interesting places to visit. Best of all was just the fun we had and the marvellous food they ordered for me.
Furthermore, I want to thank David and Kittinan for explaining me all their logistic experience. Thanks to them, I had a pleasant stay in Bangkok and I learned a lot of cross docking in Asia.
Finally, I would like to thank Dennis Vegter and Taco van der Vaart for their valuable
advice and challenging comments. In particular I would like to thank Denis Vegter for his co-operation to overcome the distance between Kuala Lumpur and Groningen.
Stephan Lutke Holzik Groningen, 30 mei 2005
Thanks to Alex, Boni and Prakash for
all marvellous lunches
5
Table of contents
MANAGEMENT SUMMARY ... 1
PREFACE... 4
TABLE OF CONTENTS... 5
1 MAKRO CASH & CARRY MALAYSIA ... 7
1.1 I NTRODUCTION ... 7
1.2 SHV & M AKRO ... 7
1.3 M AKRO M ALAYSIA ... 8
1.4 F UTURE EXPECTATIONS ... 10
2 GENERAL PROBLEM DEFINITION ... 12
2.1 I NTRODUCTION ... 12
2.2 P ROBLEM IDENTIFICATION ... 12
2.3 P ROBLEM CONTEXT ... 14
2.4 P ROBLEM DEFINITION ... 14
2.4.1 Objective ... 14
2.4.2 Main question... 15
2.4.3 Sub questions... 15
2.5 R ESEARCH APPROACH ... 15
2.5.1 Approach for Designing a cross docking system ... 17
2.6 C ONDITIONS AND ASSUMPTIONS ... 20
2.7 D ATA COLLECTION ... 21
2.8 D ATA QUALITY ... 21
3 THEORY... 23
3.1 I NTRODUCTION ... 23
3.2 W HAT IS C ROSS D OCKING ? ... 23
3.3 I DEAL CONDITIONS FOR SUCCESS ... 25
3.4 T YPES OF CROSS DOCKING ... 28
3.4.1 Pre-allocated supplier consolidation ... 29
3.4.2 Pre-allocated DC consolidation... 29
3.4.3 Post-allocated DC consolidation ... 30
3.5 A DVANTAGES AND DISADVANTAGES OF C ROSS D OCKING ... 32
4 CUSTOMER NEEDS... 34
4.1 I NTRODUCTION ; ... 34
4.2 C URRENT C USTOMERS ... 34
4.3 C URRENT LOGISTIC PROCESS ... 36
4.4 S HOPPING CRITERIA ... 38
4.5 C RITICISM OF CUSTOMERS ON SHOPPING CRITERIA ... 40
4.6 C ONCLUSION ... 41
6
5 GENERATE SYSTEM DESIGN ... 43
5.1 I NTRODUCTION ... 43
5.2 A SSEMBLE THE DESIGN PARAMETERS ; ... 44
5.2.1 List of cross docked products and their suppliers ... 44
5.2.2 Product Characteristics ... 53
5.2.3 Project throughput rate per planning horizon ... 55
5.2.4 Recommended store delivery schedules, and recommended supplier schedules... 57
5.3 C ROSS DOCKING OPERATIONS REQUIREMENTS ... 59
5.4 L AY OUT THE CROSS DOCKING DESIGN ... 62
5.5 D EVELOP LABOUR AND EQUIPMENT REQUIREMENTS ... 63
5.6 L IST INFORMATION SYSTEMS REQUIREMENTS ... 65
5.7 C ONCLUSION ... 66
6 ECONOMICAL ANALYSES ... 68
6.1 I NTRODUCTION ... 68
6.2 A FFECTED COST ELEMENTS ... 68
6.3 C OLLECTED INFORMATION ... 69
6.4 S UPPLIER COSTS ... 70
6.5 F ACILITY C OSTS ... 72
6.6 T RANSPORTATION COSTS ... 76
6.7 S TORE COSTS ... 77
6.8 H EAD OFFICE COSTS ... 78
6.9 S CENARIO ’ S ... 79
6.10 R ELIABILITY OF ECONOMICAL ANALYSES ... 82
6.11 C ONCLUSION ... 83
7 ADVANTAGES AND DISADVANTAGES ... 85
7.1 I NTRODUCTION ... 85
7.2 P RICE ... 85
7.3 P ROMOTION ... 86
7.4 Q UALITY ... 87
7.5 A VAILABILITY ... 87
7.6 A SSORTMENT /P ACKAGING ... 87
7.7 O THER ... 88
8 CONCLUSION ... 90
8.1 I NTRODUCTION ... 90
8.2 R ECOMMENDED CROSS DOCKING DESIGN ... 90
8.3 A DVANTAGES AND DISADVANTAGES ... 91
9 REFERENCES ... 93
7
1 Makro Cash & Carry Malaysia
1.1 Introduction
This research will describe the introduction of a cross docking system for Makro Malaysia, a wholesaler selling food and non-food consumer articles to professional customers. An introduction of Makro Malaysia will therefore be given in this chapter.
Makro’s origin will be described in paragraph 1.2 where after its mission and markets will be described in paragraph 1.3. The last paragraph of chapter one will describe the future expectations of Makro Malaysia, since its expansion will highly affect the cross docking system.
1.2 SHV & Makro
Makro cash & carry is part of SHV Holdings N.V. A brief description of SHV and the origin of Makro will be discussed in this paragraph.
SHV Holdings N.V. is a Dutch company, which originated in 1896 from a merge between a number of large coal trading companies. SHV’s current activities are widespread, in spite of its coal trading history. Current activities involve:
- Trade in and distribution of LPG (SHV Gas)
- Trade in food and non-food consumer articles (Makro) - Provision of private equity (NPM Capital)
- Trade in and production of raw materials (Recycling) - Exploration and production of oil and gas (Dyas)
SHV is a privately held company, which gained sales of more then € 10 billion in 2003, employs more than 28000 persons, has operating industries around the world and is head quartered in Utrecht the Netherlands.
SHV’s strategy is directed at growth through performance, going for niche and market share, investing in people, managing change, looking for the unusual by learning and reacting and keep the things simple.
SHV’s trade in food and non-food consumer articles, going by the name of Makro cash &
carry, started in 1968 in Amsterdam and its fundamental business model is that of a wholesale cash and carrier. Makro used to operate in the European, South American and Asian market, but knocked of the European market a couple of years ago. Makro, in the year 2003, has 81 stores in South America and 60 stores in Asia, with a total sales up to € 2.8 billion.
A region office is situated in every continent in which Makro is operating. Its main goal is to support activities of the different Makro countries. The region office of Makro Asia is located in Bangkok, Thailand. This region office supports the following countries:
Thailand, Indonesia, China, The Philippines and Malaysia. Figure 1-1 provides a
8
geographical overview of Makro countries in Asia and mentions the number of stores that are operating in every country.
1.3 Makro Malaysia
Makro Malaysia, which originated in 1993 by a joint Venture between SHV and a local partner, will be described in this paragraph. Its mission and the markets in which it operates will be described here as well as its competitors.
Makro Malaysia has eight stores on peninsular Malaysia and its head office is situated in Shah Alam. Makro Malaysia’s sales reached up to € 180 million in 2003, the firm employs more then 1000 employees throughout Malaysia and formulated its mission as:
"Makro is a cash and carry wholesaler selling quality food and non food products providing the best buying conditions and solutions for our professional customers."
The company’s core product range is in food, fresh and dry, and complementary products that Makro’s customers use in their businesses on a day-to-day basis. Figure 1-2 provides an overview of sales and sales categories in 2003 of Makro Malaysia.
Figure 1-I Geographical overview of Makro countries
in Asia and number of stores
9
Makro’s core customers are small and medium enterprises like small retailers, hotels, restaurants and caterers, professionals, and institutions such as hospitals, schools etc. The company does not focus on the individual and family-end-users, although it continues to offer products, both food and non-food to this customer base. Makro’s customers will be described in chapter four.
Makro’s competitors are the wet markets and the traditional wholesalers. The company differentiates itself from these competitors by price, assortment and customer relationship management. The commercial strategies used to achieve this differentiation are:
• A balanced wide and not deep assortment.
• As less of number of suppliers.
• Space allocation based on efficiency/cost price.
• Prices always competitive with its markets.
• Operating as first or second source for customers.
• Buying prices based on volume.
Dry Food sales per category 2003 6%
18%
29%
38%
9% 0%
Snack & Confec.
Dry-basic Dry Grocery Drinks & Tobacco Detergents & Disposables Others
Fresh Food sales per category 2003 8%
22%
5%
23%
20%
22%
Bakery Fruit & Veg.
Fish Meat Chilled Frozen
Non Food sales per category 2003
20%
13%
30%
6%
16%
7%
4% 4%
Household Stationery/ Office Electro Clothing DIY Textile Sports Furnitures Sales per head group 2003 in RM
102166762
429071643 210424997
Fresh food
Dry food
Non food
Figure 1-II Overview of Sales and Sales categories of Makro Malaysia in 2003
10
1.4 Future expectations
Makro Malaysia expanded from one store in 1993 to eight stores in 2004 and is willing to expand more in the next view years. This expansion will influence Makro Malaysia’s activities and will therefore be discussed in this paragraph.
Currently Makro has eight stores in Malaysia and all are situated on the peninsular Malaysia. Makro’s management certified the next view years as the years of expansion and remodelling, which means that the number of stores will increase and the lay out of the stores will change with the intended goal to increase sales. The expected store expansion will be discussed first where after the remodelling will be described.
Makro plans to open two new stores in November and December of ’05, ’06 and 2007.
The geographical location of the stores and the expected new stores are shown in figure 1-3
Figure 1-III Location of current and expected
Makro stores in Malaysia
11
As a consequence of the store expansion it is expected that Makro Malaysia’s sales will increase.
A look inside Makro’s stores confirms the wholesaler approach. The stores are built like big warehouses with a large amount of stock available in the store and products are mainly presented in shelves and on pallets. Makro Malaysia decided in 2003 to focus on a specific group of customers, namely the Horeca customers. A consequence of this focus is a remodelling project set up in September 2004. This remodelling project involves a renovation of the interior of fresh food products in the stores with the intention to increase the fresh food product assortment, quality and at last increase the sales of the fresh food.
There is a big difference between stores in assortment and the way products are displayed. Some stores display fresh products in ice others display them in refrigerators and there are stores that do not sell fresh products. The remodelling process will standardise the display and availability of fresh products: fresh food products will be displayed in the same way as in a wet market and all stores will sell fresh products. The first stores of Makro Malaysia are renovated, with increased sales as consequence.
According to Makro’s planning all stores will be renovated in September 2005.
The sales growth of fresh food products is expected; because of the store expansion and remodelling. This paragraph can therefore conclude that the two described activities will increase the sales of Makro Malaysia
This chapter described Makro, its origin, competitors, markets and future expectations.
The company and its environment will affect the cross docking system that will be
designed in this research. The general problem definition will be described in the next
chapter.
12
2 General problem definition
2.1 Introduction
This chapter will clarify the reason and approach of this research at Makro Malaysia, based on research methods of de Leeuw
i. Paragraph 2.2 will describe the reason for this research, where after the environment in which this research will be conducted will be described in paragraph 2.3. The problem definition, which will be described in paragraph 2.4, consists of the objective, the main question and sub questions of this research. The steps that are performed to answer the main question will be explained in paragraph 2.5, where after paragraph 2.6 will describe the assumptions and conditions of this research.
The last paragraph of this chapter will describe the data collection of this research.
2.2 Problem identification
The region office of Makro is informed of the expected sales increase of Makro Malaysia’s fresh and frozen products. They expect cost advantages by introducing a new logistic system for these products, named cross docking, based on their experience.
Makro Malaysia operates a cross docking system for dry products, but a cross docking system for fresh and frozen products will be of great advantage for Makro Malaysia according to the region office. The expected advantages for Makro Malaysia will be described after outlining the proposed cross docking system. Since describing the proposed cross docking system will be necessary to understand the expected advantages.
Napolitano
iiidentified essential elements for cross docking, these elements are:
suppliers, products, product flow, information flow, people and costs. All elements will be discussed in chapter three extensively, but will be used here to explain the cross docking system, proposed by Makro’s region office.
Supplier
Makro’s head office should consolidate orders of all different stores, by using a computerised supply chain management system. The consolidated order should be send by e-mail to the supplier, where after the supplier delivers the articles for all stores to the distribution centre.
Product
Products in the distribution centre should be assigned to different store lanes where the products are physically stored until their departure. Trucks should be loaded from these store lanes and depart from the distribution centre when all incoming products are assigned or when there is a full truckload for a store. The time between arrival and departure of the products is kept as short as possible, normally within one day.
Information
A full truckload with different products should be delivered to the stores. An Electronic
Data Interchange (EDI) should be used. EDI is electronic communication of operational
data such as orders and invoices between organisations. This EDI system provides the
necessary information for the stores, suppliers, head office and distribution centre.
13
Product flow
Little stock space should be available in the distribution centre for imported products that will arrive in big quantities. These big quantities cannot be shipped to the stores on the same day because of storage capacity shortage in stores. No stock should be kept for other products, since the products should be dispatched shortly after receiving.
People
A long-term contract should be set up between Makro and a logistic provider. This third party should be responsible for the ownership and operations in the distribution centre as for the trucks that depart from the distribution centre to the stores.
Costs
Makro’s region office advises this system, since they expect Makro Malaysia to benefit from this cross docking system. This expectation is mainly based on experience in other countries. Some expected advantages according to the region office are:
• Products from suppliers will arrive at the distribution centre as a full truck load (FTL) shipment. At the distribution centre, the FTL shipments from various suppliers will be broken up and consolidated again to create FTL shipments that will go to the various stores. These FTL’s will result in lower transport costs, by which price competitiveness of Makro in the market can be improved.
• Cross docking creates a distribution network by which Makro will be able to store and ship products. Makro will therefore be able to import products in bulk, store them in the distribution centre and ship them gradually to the stores. The import of products will decrease the cost price of some products, since these products can be bought abroad low-priced. This will improve the price competitiveness in the market.
• The supplier receives one order, since orders of stores will be consolidated with cross docking. This results in processing fewer invoices. A decrease in operating costs due to fewer invoices can improve the price competitiveness of Makro in the market
• Quality and freshness of products in stores will be increased since the products will be delivered to the stores more frequently.
Makro Malaysia is informed of these benefits by the region office and is experiencing some of these advantages in its cross docking system for dry foods. Makro Malaysia is now willing to introduce cross docking for fresh and frozen products. But as literature provides: ’’Cross docking has many parameters that are often unique to a company or situation’’
iiiand ’’Many cross-dock practitioners say what is most overwhelming are the thousands of little details involved when making the move to cross docking’’
iiiand
’’Cross docking cuts across many interacting functions within and beyond the
warehouse…determining the most appropriate operation can be quagmire of details and
data’’
ii, copying and applying the proposed system is therefore impossible. It is therefore
difficult to determine the benefits of cross docking for Makro Malaysia’s fresh and frozen
products.
14
The above-mentioned problems are the motive for this research and can be divided in two major research reasons:
1) Makro Malaysia wants to know how a cross docking system for the fresh and frozen products works in their supply chain and
2) Makro Malaysia wants to know if the advantages, as mentioned by the region office, are feasible in Malaysia when costs are taken into consideration.
2.3 Problem context
The environment in which this research is conducted will be described in this section.
Activities, which influence this cross docking system, will be described here.
Opening new stores and remodelling project
Chapter one mentioned that the sales of fresh and frozen products should increase because of store expansion and the remodelling process. Increasing sales will affect the cross docking system, since the volume of cross docked products determines the warehouse size, type of carrier, number of employees etc.
Cross docking dry food
Makro Malaysia just launched a cross docking system for the product categories non- food and dry food, hereafter called cross docking dry. The awareness of complexity in cross docking as described in paragraph 2.2 and the poor results of cross docking dry are important reasons for this research.
Thailand
Makro Thailand already introduced a cross docking system for fruit & vegetables and seafood. The results were satisfying and are an important reason for Makro Malaysia to investigate the possibilities for cross docking fresh and frozen products in Malaysia.
2.4 Problem definition
This paragraph will describe the objective, the main question and the sub questions of this research. The sub questions correspond with the research approach, which will be discussed after this paragraph.
2.4.1 Objective
As mentioned before, the reason for this investigation is twofold and the objective is therefore formulated as:
-’’Design a cross docking system for Makro Malaysia’s fresh and frozen products’’ and
-’’Identify advantages and disadvantages and perform an economical analysis of
this cross docking system for Makro Malaysia’’
15 2.4.2 Main question
What cross docking design for the fresh and frozen food is recommended in Makro Malaysia’s environment, and what advantages and disadvantages can be identified by applying this cross docking system, taken into account the customer needs and costs of this operation?
2.4.3 Sub questions
This research will use the method of de Leeuw
ifor answering the main question. The main question will be divided in sub questions, according to this method. Answering the sub questions, answers gained by investigation, will be used to answer the main question.
The reason for formulating these sub-questions will be described in the research approach, which will be described after mentioning the sub questions of this research:
1) What is cross docking and what are its general advantages and disadvantages?
2) What are the customer needs?
3) Which products and suppliers qualify for cross docking?
4) What are the operational requirements?
5) What are the facility’s lay out requirements?
6) What are the labour and equipment requirements?
7) What are the information requirements?
8) What is the economic analysis?
9) What are the advantages and disadvantages of the designed cross docking system for Makro Malaysia’s fresh and frozen products?
2.5 Research approach
The steps that are performed to answer the main question will be explained in this
paragraph. The mentioned sub questions are formulated by analysing the research
approach, which is summarized in figure 2-1.
16 The sub-questions will successively be discussed:
1. What is cross docking and what are the general drawbacks and benefits of a cross docking system? (Chapter 3)
Chapter 3 will describe a theoretical review, in which a detailed description of cross docking will be provided. This chapter will describe the advantages and disadvantages of cross docking as discussed in theory as well.
2. What are the customer needs? (Chapter 4)
Makro’s mission is stated as follow; "Makro is a cash and carry wholesaler selling quality food and non food products providing the best buying conditions and solutions for our professional customers." It is Advantages and Disadvantages of
Applying Cross Docking Customer Needs
Theory
Cross Docking Design
Economic analysis
Chapter 3 Chapter 4
Chapter 6 Chapter 5
Chapter 7
Assemble design parameters
Develop alternative operational requirements
Lay out the Cross Docking Design
Develop Labour and equipment requirements
List information systems requirements