CASE STUDY CONCEPT: Sales & Operations Planning (S&OP) with Simulations to Support Business Growth.
You connect your laptop to the boardroom projector, and the image shown below appears on the big screen at the front of the room. Conversation dies down as everybody turns to look at what you are showing them. What they see is the company’s supply chain drawn on a map of the world.
The supply chain model you show them is composed of products, facilities, vehicles and routes that you defined and placed on the map. With a few mouse clicks you call up information about these entities in dialog boxes where data can be reviewed and changed (data for one of the product categories is shown here).
(click on screenshot to see larger image)
Java Furniture Company is the largest business unit of a European furniture maker, and management is located partly in Europe and partly in Indonesia. The company makes stylish, high quality furniture from sustainably harvested teak and other exotic hardwoods. Its two furniture factories are located in Indonesia on the island of Java, and it sells to customers around the world.
[ Note: This case is based on work with a real company; some names and numbers have been changed for use in the model and simulation presented here. ]
PART I — THE “AS IS” SUPPLY CHAIN
The company put together a supply chain task force composed of people from different areas – operations, purchasing, sales, and finance. To start this project, the task force members have traveled to meet in person at headquarters in Amsterdam. Your job is to guide them through a process of analyzing different options, and help them make decisions about how to create a supply chain to support the next level of company growth.
From what you’ve heard in individual conversations over the last few days, you realize different groups in the company are fixating on different parts of the supply chain, and pressing for their own interests without understanding the overall effects of different courses of action. The finance people in Europe are focusing on how to increase productivity at the two factories in Indonesia. Operations people in Indonesia argue that the most important issue is to improve movement of products between the factory and the port where they are loaded onto cargo ships for delivery to customers. Purchasing people want to know if they should line up new suppliers or shippers. And sales managers in Europe and Indonesia just want to do whatever it takes to increase production and support rising worldwide sales.
Your objective in this first meeting is to provide a big-picture understanding of the company supply chain and the basic relationships between different parts of that supply chain. With that common understanding, people can collaborate to solve problems instead of just arguing and bargaining. Good things happen when people collaborate. You begin your remarks by pointing out that the factories and the port in Indonesia lie at the center of a global supply chain spanning four continents.
(click on screenshot to see larger image)
Then, zooming in on the map, you show more detail of the supply chain on the island of Java. People see the routes that connect the factory with the port and the sources of teak wood on the island. They also see the two company stores in Jakarta, and from the port they see the shipping routes that deliver the company’s products to customers.
You zoom in all the way to the port of Semarang and switch to the satellite view so people can see for themselves what the facility looks like, and see the amount of traffic that flows through this port. With this picture of the port onscreen, you pull up a dialog box showing relevant information about the port and the company’s products in the container storage yard there.
Using information you gathered in your initial research and conversations, you created a first version model of the company’s global supply chain. You made some simplifying assumptions, and employed some modeling techniques to capture the essence of the company’s supply chain (see the footnotes at end of this case study). The numbers used in this model can always be adjusted as you learn more, and other changes and additions can be made to the model as the project progresses. During the project you and the task force members will focus on improving the accuracy of the model, and using it to explore different supply chain design options for supporting company growth.
Running the First Simulation – the “As Is” Model
After reviewing various parts of the supply chain, you run a simulation to show people how this present supply chain operates. People watch the big screen as the simulation plays out. They see what happens. On day 27 the big showroom store in Singapore runs out of Furniture C. This is the category of larger and more profitable products that is experiencing the biggest sales growth. This simulation result gets people talking about the supply chain adjustments needed to support sales in Singapore and elsewhere.
[ We are glad to provide a free evaluation account to instructors and supply chain professionals interested in exploring SCM Globe simulations — click here to request an account — Free Trial Demo Account ]
You explain that a supply chain requires coordination between all the different parties and facilities. The better the coordination, the smoother the flow of products through the supply chain. The goal is for customers to get the products they want when they want them, and at the same time to enable manufacturers and distributors to maintain their profits by keeping their on-hand inventory and related storage and transportation costs as low as possible.
In looking through the simulation data, you can see what it says about how inventory flows through the company supply chain. You ask the task force members to imagine a supply chain as a network of pipes and reservoirs. Pipes are the product delivery routes and reservoirs are the warehouses. Think of inventory flowing through a supply chain as if it was water flowing through pipes and reservoirs to meet the demands of people when they want water. The water must flow smoothly and be available immediately when a person turns on the faucet, so you keep the reservoirs filled with enough water to meet demands. But you don’t want reservoirs to fill up with too much water because then the water would overflow and be wasted.
How Products Flow through this Supply Chain
The diagram below is created from the on-hand inventory graph displays for key facilities in the Java Furniture Company supply chain. When you click on a facility in the simulation, you can see its inventory graph. Suppliers of raw materials are shown on the left and bottom of the diagram, the Semarang Port and Main Factory are shown in the middle, and customers are shown on the right side. Grey arrows indicate the direction of inventory flow in the supply chain.
When you look at these graphs you watch for a few simple yet critical characteristics:
- Upward sloping lines mean more product is being delivered or manufactured than is demanded
- Downward sloping lines mean more product is being demanded than delivered
- Saw tooth patterns indicate deliveries happening every few days — on-hand product is drawn down by daily demand and then spikes up when deliveries are made
- Stair step patterns indicate missed deliveries that eat into safety stock
- (see more about this in online guide section “Analyzing Simulation Data“)
As you scan these inventory graphs you point out several things to the group:
- Downward sloping lines at the port show a need to import more raw material and deliver more finished product from the factory for shipping to customers.
- Relatively flat lines for on-hand inventory at the factory show supplies are pretty well balanced with demand for the current factory production levels.
- Two upward sloping lines at the factory attract your attention.
- The red line is Furniture B; while it’s rising at the factory, you see it’s dropping at the port. Need to ship more Furniture B from the factory to the port.
- The yellow line at the factory is Furniture C, and it too is going up while at the port it is dropping.
- The purple line at the factory, while fairly flat, is much higher than currently needed. It shows on-hand inventory for Lumber B which is needed to make Furniture B. But if the company plans to increase production of this product category it may need all that inventory and perhaps even more
Now you pose some questions to the group. You ask them what they think would happen if this existing supply chain tries to support sales increases of 20 to 40 percent. This generates a lively discussion with people offering different opinions about what would happen and why. Listening to this exchange of opinions, you realize that until people on the task force have a common understanding of the company’s supply chain, they will just continue arguing among themselves.
Modeling Different Supply Chain Scenarios
So you suggest the following approach as a way to model the sales increase and simulate what happens. You start by looking at the demand and production numbers at the factory as shown in the dialog box below. It shows how much of each type of lumber is needed to produce given amounts of the three product lines.
Three categories of lumber – A, B, and C are used to produce three lines of furniture – A, B and C. Lumber A is used to produce Furniture A; Lumber B is used to produce Furniture B; and Lumber C is used for Furniture C. By looking at the numbers you can see it takes 10 cases of Lumber A to produce 13 cases of Furniture A (case sizes and weights are different for lumber and furniture). You also see the same information for Furniture B and C.
Each line of furniture also needs hardware (hinges, bolts, screws, handles, etc.) as well as lumber and you can see the daily demand for hardware is 15 cases for 41 cases of all furniture lines. Assume the hardware is used equally by all lines of furniture, so each case of furniture requires about a third of a case of hardware. Use these ratios as you plan for increased production at the factory. Use these ratios to construct several scenarios that model different supply chain options you want to explore.
Simulations Create Common Understanding and Drive Sales & Operations Planning (S&OP)
To answer the question of what supply chain changes will be needed to support 20 and 40 percent sales increases, you put some new numbers into the supply chain model. You increase the daily lumber and hardware demand numbers, as well as the daily product production numbers at the factory. You increase the numbers for Furniture A and B by 20 percent, and increase the Furniture C numbers by 40 percent. You also increase demand numbers for the product categories at the stores and warehouses that products are delivered to. Then you run a simulation.
People see for themselves where inventory runs out and where inventory overstocks occur. They can also see causes for this and they start adjusting the supply chain design as needed to address these problems. You guide the group to play with a couple of different ideas and designs – you model them and simulate them to see what happens.
As more products start moving through the supply chain everyone sees the cost of transportation rise. This frames a conversation about the relationship between transport costs and production levels. In particular, you guide people to consider the increased trucking costs required to move additional products between the main factory and the port. Then you pose the question, “Do we have other transportation options beyond trucks and what are their costs?”
It also becomes clear to everyone that movement of products between the factory and the port, and the rate at which products can be loaded onto arriving container ships is a critical issue to be addressed. Disruptions at the port of Semarang could quickly become a crippling bottleneck that would slow down the entire supply chain. Even if the factory does produce more furniture, it is pointless unless that additional furniture can be delivered to customers in a timely manner. People see this quite clearly in the simulations you show them.
Sales & Operations Planning (S&OP) is a supply chain best practice used by Java Furniture Company. They use a rolling 60 day planning cycle to accommodate the long transit times for products that are shipped to and from Indonesia. S&OP provides a framework to guide people from different areas of the company as they work together to forecast product demand and create a demand plan and supply plan for the company. They follow the five-step process shown in the diagram below.
Data from the demand plan is used to define the products and facilities in the company’s supply chain model. And data from the supply plan is used to define production rates at factories plus vehicles and delivery routes in the model. Running simulations then finds the mismatches between the demand and supply plans and provides data to evaluate ways to fix those problems. Simulations let people try out different ideas and quickly see how well they work. See more about how Java Furniture company uses S&OP in the short video below.
You can download a short SlideShare presentation that documents the five-step S&OP process shown in the video:
FIRST CHALLENGE — Implement changes to the Java Furniture supply chain model described in the two sections above. Use the demand and production numbers above for the furniture factories, and increase the numbers by 20 and 40 percent as described. Also increase demand appropriately at the various stores and warehouses that products are delivered to. Do whatever you feel you need to do to get the resulting supply chain to run for 60 days.
Make a short report of findings that describes what you did to make the supply chain run for 60 days and support the increased sales targets. Use screenshots and simulation data to illustrate your report. Note the areas of greatest cost and facilities with most on-hand inventory and explain why that occurs. Note also where are the points of most risk in this supply chain. Suggest possible ways to manage cost, risks and inventory levels in this supply chain.
Here are some things to think about as you work through this first challenge:
- Assume you continue using the current transportation model of trucks and ocean shipping, Assume any size of truck from large to small can use the main coast highway between the factories and the Port of Semarang (change the existing model to eliminate the detour route used by large and medium trucks moving between the factories and the port).
- Identify the points of greatest risk in the supply chain. Points of risk are facilities, vehicles and/or routes where a disruption in operations would affect the largest number of other facilities in the supply chain. You will often find these risk points because they are facilities where products either run out or require too much storage space.
- Performance trends you see in simulations of the first 30 days will largely predict performance for the next 30 days. Focus first on getting the supply chain to run for 30 days and then it will be easier to extend its performance for 60 days.
- When you look at the simulation results, look for the large numbers and the overall trends. Which facilities generate the biggest costs and why? What can be done about them? Also appreciate that the Java Supply Chain model comes with default values originally estimated in 2014. You may want to do some quick research to see if prices have changed or if certain default values are unrealistic. The logic of this model remains the same, but different numbers used in the model will give different answers — see more about this in the Footnotes section below.
SAVE BACKUP COPIES of your supply chain model from time to time as you make changes. Click “Save” button next to your model in Account Management screen. There is no “undo”, but if a change doesn’t work out, you can restore from a saved copy. And sometimes supply chain model files (json files) become damaged and they no longer work, so you want backup copies of your supply chain to restore from when that happens.
PART II — THE “TO BE” SUPPLY CHAIN
By the end of that first day your big picture model and the simulations of the company supply chain have achieved that critical first objective of getting everybody on the same page with a common understanding of their company’s supply chain. People are starting to understand how the different parts of the supply chain work together, and appreciate the trade-offs involved in creating an effective supply chain to support the expected sales growth.
In the days ahead you guide them through a process of exploring options and creating new supply chain designs. People on the task force return to their respective offices, yet still collaborate online. People suggest ideas and run simulations to see for themselves what happens. They explore relationships and trade-offs between the four supply chain entities that make up the model – products, facilities, vehicles and routes.
When people on the task force come up with interesting new designs, they send around copies of their supply chain models for others to review and run for themselves. In this process several models evolve. They embody the most promising supply chain designs. The designs continue to get better as people review them and add their own ideas and changes to the models.
Expected and Unexpected Disruptions Raise Questions
As the project progresses, people on the task force discuss how traffic is becoming ever more congested in the city of Semarang and on the access roads to the port. This congestion is restricting the number of daily trips trucks can make between the factory and the port. People expect the port of Semarang will become a bottleneck in the company’s supply chain as production volumes increase.
And then unexpectedly, a bridge on the main coast highway linking the port and the factory is partially closed for repairs. Where there were once two eastbound lanes and two westbound lanes, there is presently only one lane available for traffic going in each direction. Large and medium trucks have been banned entirely. Only small trucks can use the bridge now, and other trucks have to take a different route. The supply chain needs to be redesigned.
In the model of the existing company supply chain you make the changes called for by this event. You create new routes for the large and medium trucks that were using the coast highway. The new detour route adds about two hours and another 125 km distance to each round trip. The simulation shows how these new expenses will add up, and how the flow of inventory will be affected.
The screenshot below shows the bridge where the lanes are closed for repair (red arrow). It is not clear how long this repair work will take. It may well require a year or more to complete. What other transportation options are available?
Note that in the screenshot there are two railroad bridges just below the highway bridges. You can see this by zooming in on the point where the main coast highway crosses a river just west of the city of Pekalongan in Central Java (type “Pekalongan” into the search location box in the upper left corner of the screen). What if it were possible to use rail transport to move products back and forth between the factory and the port? This generates a lot of discussion between task force members.
Evaluating Other Transportion Options
It turns out rail service is available. However, at present it is slow and unreliable due to lack of maintenance on infrastructure and rolling stock. But the Indonesian government is considering upgrades to this railroad infrastructure to keep the country competitive with other nations in the region.
You send around links to a couple of relevant presentations about the Indonesian transportation network (additional web searches will yield more information):
- Development of Freight Transport Options for Sustainability in Indonesia – Dr. Elly Sinaga, Deputy Director General, Research and Development, Ministry of Transportation; Republic of Indonesia — See document here
- Modal Competition for Freight in Land Transportation on Jakarta-Surabaya Corridor — Lita Sari Barusa, Sigit Pranowo Hadiwardoyoa, Hipolito Martell-Floresb, Jean-Louis Batozb, Department of Civil Engineering, Faculty of Engineering, University of Indonesia, and Department of Urban System Engineering, University of Technology of Compiegne — See document here
There is also potential for sea-going barge service between the factory and the Semarang Port. Zoom in and look more closely at the main factory. Switch to the satellite view and look around. What do you see on the coast nearby? Do the economics of using barges to transport products between the factories and the port look attractive?
If the Semarang port is reaching capacity, what about shipping out of Surabaya on the eastern end of the island, or out of Jakarta on the west end? What is the effect of these options on transportation costs and on-hand inventory levels at different facilities?
What if the rail road service were upgraded and it became dependable and ran every other day between the factory and the ports of Jakarta, Semarang and Surabaya? Transport by rail on routes of 100 km or more costs about one tenth the cost of using trucks. And transport by coastal barge or small freighter is about one fifth the cost of trucks. You ask people for ideas they may have on combining rail and/or ship transport with trucks to create a better supply chain. The map below shows the Java transportation network.
The company also wants to lower its overall carbon footprint. Rail and ship transportation have much lower carbon footprints than truck transportation. A little investigation of alternatives using railroad and ships to move products is needed. One way to start is to do web searches and look for freight forwarding and logistics companies that do business in Indonesia. See what you can learn from their websites (here is the website of one such company and there are others – http://ptcac.co.id/railfreight).
With a switch to rail or coastal barges would it be cost effective to import and export through Surabaya or Jakarta as well as Semarang? You make your best guesses about transport costs and work up supply chain models to explore possibilities in these areas.
Risk Analysis and Contingency Planning
The production level for teak lumber produced in Indonesia is fixed because that is the level that sustainable harvesting of trees will support. So the company needs to find supplies elsewhere to enable increased furniture production. But costs will go up because of transportation cost involved in importing wood from overseas sources such as Africa, North America and South America.
The potential bottleneck at the Semarang port will only become more critical as more teak and other exotic wood from overseas is imported for furniture production. And, of course, more furniture will also be exported back through the port to customers. Stoppages or delays at this port will quickly ripple through the entire supply chain.
You guide the task force in discussions about what they see as the biggest supply chain and business continuity risks, and you add your own insights. Then you facilitate discussions on ways to deal with these risks. You model some of the best ideas and see how well they work by running simulations (see more on balancing supply chain risk and performance).
For instance, a good way to respond to the risk of bottlenecks at Semarang is to also ship through one or two other ports. So you create a supply chain model that has shipping facilities in Surabaya and Jakarta (are there other ports with adequate facilities on the island?). You run simulations and try various mixes of trucks and railroad and barge transportation and see what happens to overall costs and inventory levels.
You also explore supply chain risks associated with other issues. What if actual demand is even higher than the marketing people currently project? Will the supply chain be able to support that increased business? And what if one or more suppliers were to stop supplying raw material? Where would inventory shortages develop? How much safety stock should you hold in reserve to guard against such events? You make model adjustments and run simulations to explore how best to respond to those events.
Recommended Supply Chain Improvements – the “To Be” Model
During the project you and others on the task force create several models of possible supply chains to support company growth. Task force members examine these models, make adjustments, and run simulations. Good ideas from all the models are combined into a final proposed supply chain model and presented along with task force recommendations to company senior management.
With company senior executives sitting around the boardroom table, you project the current and proposed supply chain models up on the big screen at the front of the room. You employ many of the same techniques you used when you showed your initial supply chain model to the task force members at the beginning of this project. Simulations are run to show how the current supply chain operates, and to show how the proposed new supply chain will support company growth. You combine simulation data with satellite views of actual facilities and routes to clarify the recommendations and answer questions. And members of the task force are there with you to provide further explanations of recommendations in their particular areas of expertise as needed.
By the end of the presentation people are smiling and nodding their heads. The “To Be” supply chain design and task force recommendations are well received. Everyone (even senior management 🙂 ) can understand what is involved, and see how they and the company will benefit. They ask you and your firm to stay on the project and help with the implementation.
SECOND CHALLENGE — Design your “To Be” supply chain model to support the company’s projected sales increases and manage risk. Show how you will use a mix of truck, railroad, barge and ocean shipping to move the increased flow of products while also lowering transportation costs. Show how you will schedule production at the factories to meet product demand at the stores and warehouses while also minimizing the cost and amount of on-hand inventory across the supply chain. Also identify the most critical supply chain risks and explain how your supply chain design manages these risks.
The port at Semerang is clearly a potential bottleneck and significant risk because any slow-down or stoppage there would quickly be felt across the entire supply chain. Expand the existing supply chain model to include shipping from at least one other port on the island of Java. Change some of the shipping routes that currently depart from port of Semarang to depart instead from the other port(s) you decide to ship from.
Make a live presentation using your “To Be” supply chain model to illustrate your recommendations. Accompany your model and simulation with a set of presentation slides containing your recommendations. Use screenshots and simulation data to illustrate your recommendations.
Explain how your “To Be” supply chain handles the flow of inventory needed to support sales growth, and how it manages cost and risk in the supply chain, all at a competitive cost. It is this combination of product flow, risk management, and competitive operating cost that makes a winning supply chain.
Here are some things to think about as you work through this second challenge:
- Assume large and medium trucks can no longer use the main coast highway between the factories and the port at Semarang (the Java Furniture supply chain model in the SCM Globe library has this assumption already built in as large and medium trucks use a detour route to move between the factories and the port).
- Do some research on different transportation options in Indonesia and their respective costs. Use the links provided above for relevant information and do your own Internet searches to see what you can find. Do the best you can with the time you have available to perform this research. As the saying goes, “Good is good enough.” Do your research, document your sources, make your best estimates, and move on.
- Once you have researched information for vehicles, routes and operating costs, develop at least two separate supply chain models that explore different mixes of transportation modes (truck, railroad, barge, ocean shipping). Select the model that delivers the best results.
- Explore options for lowering on-hand inventory and facility storage costs. Find ways to adjust delivery schedules and delivery amounts at each facility so as to smooth out the on-hand inventory levels and keep them as low as possible without running out. Then reduce storage capacity at facilities where you can to reduce operating costs.
- Find useful ideas for reducing inventory and for calculating optimum product delivery amounts and schedules by reading “Cutting Inventory and Operating Costs” in the online guide.
- Balance need to reduce on-hand inventory and facility operating costs with need to keep adequate safety stock inventory at various facilities as a hedge against missed deliveries of products
- Describe the trade-offs you make between managing risk and managing costs in your supply chain design. You cannot afford to manage all possible risks, and yet you must pick the most critical risks and make operating decisions to manage those risks that are not entirely driven by lowest cost considerations.
For ideas and techniques for how to work on this case see “Tips for Building Supply Chain Models” .
REMEMBER — There is a spreadsheet reporting template you can use to analyze downloaded simulation data. Import your simulation data into the template and create monthly profit & loss reports as well as generate key performance indicators. See more about this in the online guide section “Analyzing Simulation Data” – scroll down to the heading titled “Download Simulation Data to Spreadsheet Reporting Templates”. The sample template is set up for the Cincinnati Seasonings company, but look at how the reports read the simulation data and you will see how to change the spreadsheet as needed to accommodate this case study.
To share your changes and improvements to this model (json file) with other SCM Globe users see “Download and Share Supply Chain Models”
Several advanced techniques were used to build this supply chain model. These techniques are explained below (see more modeling tips and techniques in the online guide at Tips for Building Supply Chain Models) :
- Combined Facilities –The model uses three central facilities in Java to represent multiple locations where teak wood is harvested. Teak trees are selectively cut in many small locations within a 50 kilometer radius of the three central facilities; sometimes trucks pick up teak wood at individual cutting sites and sometimes they pick up the wood at these central facilities. There is no need to put all the detail of the multiple harvesting locations in this overall supply chain model (you can build another more detailed model of these logging operations later if that is needed).
- Product Categories – The company has about 200 different furniture items, and purchases many kinds of lumber and hardware fixtures, so this model groups these products into categories to manage complexity. For example, there are three categories or lines of furniture – A, B, and C. You calculated average volume, weight and cost numbers for a typical item in these three product categories. This models the flow of products through the supply chain well enough without overwhelming people with detail that would confuse and obscure a big picture understanding of the whole supply chain.
- Standard Shipping Containers – The company sends products to customers and receives products from suppliers in shipping container quantities. So to model the shipping of finished products to overseas customers and the importing of raw material and component parts from overseas suppliers, you define vehicles as multiples of 40 foot high capacity shipping containers (40’ HC) and 20 foot standard capacity containers (20’ Stnd). These containers can hold a mix of products.
- Weekly Delivery Schedules – With these shipping container vehicles you use a special technique to model the delivery schedules. Because the routes these shipping containers travel have travel times of two to three weeks at average ship speeds (about 30 km/hr), and because you want to show shipments being made and received every week or every other week, you increase the speed of these vehicles so the round trip time is reduced to one week or two weeks, and you set the delay between departures for these vehicles to be zero. Now your model accurately records a stream of shipments leaving and arriving each week.
- One-Way Shipping Costs – You also set the vehicle operating cost to be one half the normal cost. This models the use of one-way shipping containers to move products from one port to another on a regular schedule without worrying about when a particular container (vehicle) returns to its port of origin. You also cut the estimated carbon footprint for the vehicle by half for the same reason.
- Supply Chain Boundaries – The company owns and operates two stores in Indonesia’s capital city, Jakarta, so you include them in the model. Otherwise, the company operates or leases warehouse space in cities in Asia and Europe where the furniture is sold at wholesale to local retail outlets. So you do not include all the stores worldwide that sell the company’s furniture. The supply chain model just shows the warehouses. Demand is placed on those warehouses to represent sales to the stores those warehouses support. Two of the warehouses are also shown as producing hardware to represent hardware they purchase from outside suppliers. You show the suppliers of furniture wood used by the company, but you zeroed out the cost and carbon footprint data for those facilities because they are not owned or operated by the company.
Supply chain operations and related costs change all the time – The models in the SCM Globe library come with default values based on research and estimates done at one point in time. For greater accuracy, you can research any of the default values and enter more current numbers into your model. In the Edit screen select an entity you want to update (product, facility, vehicle, or route). Type over old numbers with new numbers that you find to be more current and accurate. Cite your data sources and estimating techniques for these new numbers when you present your simulation results.
Here is a good example of such research yielding better estimates for storage costs at Semarang Port and other facilities in this supply chain (comment came from a master’s student at Georgia College & State University, J. Whitney Bunting College of Business):
“Just wanted to give you a heads up on some changes we are making to our model… I did a quick analysis of the facility storage cost for our first run on the 60 days for a single facility, the Semarang Port.
Storage Cost Analysis Semarang Port Storage
Daily Rent Cost M3 $ 2.10
Daily Operating Cost $ –
Units Received 1,400
60 Day Cost – Keep it Running $ 2,520,000
Storage & Handling Cost Per Unit (2 Months) $ 1,800
“The total units received at this facility totaled 1,400 units for the two month period, yet the facility charge was $2,520,000, or $1,800 for every unit received.
“I then did a conversion comparing a standard 48 X 40 Pallet 5 foot high, with an average in and out storage handling charge per month of $12 which is a baseline rate. There are many variances in the actual rates depending on whether the product is racked or if it’s just floor loaded (eats up more cubic volume), but I think the $12 is in the ball park for a racked rate (which you would expect for these size units).
“If you use that $12 rate for a standard sized pallet and convert that rate to cubic meters, and assuming an average size unit of 1.5 Cubic Meters (Furniture B is 1.5 Cubic Meter versus 1 Cubic Meter for A and 2 Cubic Meters for C) you arrive at a daily storage rate of $0.16 per cubic meter versus the $2.10 in the original model.
“For this facility we adjusted the daily rate to $0.16, and will make similar adjustments to the other facilities. For sites with storage that don’t have a daily storage charge, we will use an estimated storage charge.
[ We completely agree — and used this research to update facility storage costs in the model – 24 Feb 17 ]
Register on SCM Globe to gain access to this and all other case studies. Click the blue “Register” button on the home page (app.scmglobe.com) and buy a subscription (if you haven’t already) using a credit card or PayPal account. Then go to the SCM Globe library and click the “Import” button next to this case study. Scan the “Getting Started” section (if you haven’t already), and you are ready to go.