CASE STUDY CONCEPT: Managing Transportation and Operating Costs in a Growing Business.
Congratulations, you’ve just joined the S&J Trading Company. They have big plans for business expansion in Africa, and you’ll be the one to carry out those plans. This video gives you a quick introduction to the challenges ahead. It shows how you can use supply chain simulations to explore different ideas, and see what works best to help you meet those challenges.
[ S&J Trading Company introduces a global and local supply chain supporting a growing company. The instructor study guide for S&J Trading Company is structured as a sequence of five scenarios to explore different aspects of this supply chain. Instructors can request the study guide by contacting: info@scmglobe.com ]
Transportation infrastructure has a big effect on business activities. In the country of Angola, the rebuilding of their railway system opens up new business growth opportunities. The railway system was once one of the finest in Africa, but during the Angolan Civil War (1975 – 2002) it was mostly destroyed. Now this rail transportation infrastructure has been rebuilt and expanded (http://www.bbc.com/news/world-africa-11295533).
As the railway network becomes operational again, and expands to link up with previously isolated cities, it is possible to transport people and products quickly and inexpensively. This intermodal transportation network (ship, truck and rail) enables commerce to increase and businesses to grow.
[ Instructors, students and professionals can request a free SCM Globe trial demo ]
Powerful business interests (Angolan, Chinese and Swiss) are at the center of these infrastructure rebuilding projects. They are positioning themselves to profit from the petroleum and mining commodity trade in Angola and Central Africa that will be affected by this new infrastructure. See the article “Angola’s Chinese-built rail link and the scramble to access the region’s resources” https://africachinareporting.com/wp-content/uploads/2015/07/Trailblazers-2015-Angola-rail-link-Grobler.pdf . Yet regardless of the motives for building transportation infrastructure such as this, once it is built, it also enables the expansion of many other types of businesses, not only those related to the building of railroads or the mining of minerals.
This case study explores supply chain improvement and expansion opportunities from the perspective of one such company looking to grow their business and manage their operating and transportation costs as they grow.
S&J Trading Company – Growing the Business
You just graduated with an impressive degree in supply chain management and logistics, and this is your opportunity to prove yourself. You joined the family business, S&J Trading. The family has been in the import/export business for a long time, and they have a way of seeing opportunities early and getting in before everybody else.
Your father and uncle spent time in Angola opening up a distribution center in the capital and three stores in other cities. Now they are looking to you to keep growing the business and open more stores. This calls for long hours and lots of perseverance, but the potential rewards are well worth the effort.
The company imports products from North America and Europe and sells this merchandise through its three stores. There are three product categories imported in quantities large enough to fill a growing number of shipping containers. Those product categories are:
- Product A — Electronics such as laptops, printers, TV and home entertainment, sound systems, and related gear
- Product B — Appliances such as stoves, washing machines, air conditioners, refrigerators, and vacuum cleaners
- Product C — Furniture, beds, and related home decorating and cleaning supplies
You track inventory demand and product inventory at the shipping container level. Load the S&J Trading Company supply chain from the online library. In the Edit screen click on the tabs for the four entities and see more about the products, facilities, vehicles and routes that make up this supply chain.
NOTE: This is an advanced case. Work through the three online challenges of the beginning case, “Cincinnati Seasonings” before working with this case.
FIRST CHALLENGE — Make changes to get the supply chain to run for 30 days. Then add four new stores
There are problems with the existing supply chain, as you quickly find out when you run the first simulation. You need to make changes and improvements in your store delivery schedules routes and in other areas. As soon as you get your existing supply chain stabilized and able to run for 30 days, then you need to expand the business and open up four more stores. Pick locations for the four new stores, and figure out how to best deliver products to those new stores.
S&J Trading is going to open new stores in Lubango, Namibe, Haumbo, and Kuito. Here is the product demand information you need to start planning for these new stores. For each of these cities, zoom in and use the satellite view to explore the city layout. Find a suitable location for a store in each of these cities and plan to open each store with on-hand product inventory equal to 10 days demand:
| Daily Demand | Product A | Product B | Product C |
| Lubango | 4 | 3 | 3 |
| Namibe | 3 | 2 | 2 |
| Huambo | 2 | 4 | 2 |
| Kuito | 4 | 3 | 1 |
| Total Demand | 13 | 12 | 8 |
When you add the new facilities, zoom in and look at the four cities named above. Switch to the satellite view and look around. Select a location for each store that looks like a good retail location. Look for places on a main road, in the middle of a large concentration of population. Look for facilities that allow a large truck to drive up and park and unload products at the stores (an example of such a location is shown below).
Notice how the transportation and operating costs of this expanded supply chain change after you add the new stores and delivery routes to serve those stores. What costs rise by the largest amount?
Outline your findings and the main challenges you faced to this point in the case study in a short executive report. Use screenshots and simulation data to illustrate your findings and back up your decisions.
There is a reporting template for this case study. Import your simulation data into the template and create monthly profit & loss reports as well as generate key performance indicators (KPIs) for the S&J Trading Company supply chain. Please read the online guide section “Analyzing Simulation Data” for instructions on how to use the spreadsheet reporting templates. Scroll down on that page to the headings:
- “Export Simulation Data to Your Computer”
- “Import Simulation Data into Spreadsheet Reporting Template”
- “Modify P&L Reporting Template for New Facilities – A Short Tutorial”
The template (as shown below) is set up for the initial supply chain model as it comes from the library. As you add more facilities, add more columns to the template to handle the data for those facilities. An understanding of basic spreadsheet functions is required to use this reporting template – https://docs.google.com/spreadsheets/d/1LJjcdMIjbHzbOc3xkUmEnya9EL-5S9w-Zz-cf-E1R_Y/edit#gid=1352167925
[If you are using SCM Globe Professional version, these reports can be generated automatically by clicking on the “Generate P&L Report” button on the Simulate Screen]
TIP: SAVE BACKUP COPIES of your supply chain model from time to time as you make changes. 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 no longer work, so you want backup copies of your supply chain to restore from when that happens.
[ Instructors, students and professionals can request a free SCM Globe trial demo — NOTE: This is an advanced case. Work through the three online challenges of the beginning case, “Cincinnati Seasonings” before working with this case. ]
SECOND CHALLENGE — Use the new railway system to build a more cost efficient supply chain
Your existing supply chain uses trucks. As you start considering ways to extend your supply chain to supply these new stores you see how quickly transportation costs go up with trucks. Angola’s road system is not in good repair, and even if the roads were better, keeping stores supplied entirely by truck is expensive. As you think about what to do you notice there is another way to make deliveries to the stores. Your stores and facilities are all located in cities that have railroad service. You have a DC in Luanda, and you could also open a DC in one of the other cities. There are now, or soon will, be stores in the other cities highlighted with orange circles in the map below.
- Can you service all stores out of a single DC or do you need another DC, and if so then where should it be?
- What kind of delivery schedule would be best? What if you could deliver by rail every day?
- What if you could only deliver every second or third day?
- How does the delivery schedule affect inventory needed on-hand at stores?
- And how does amount of on-hand inventory affect store operating and rent costs?
- How much will the move to rail transportation reduce costs?
- Do reductions in transportation costs offset some increased costs elsewhere?
The answers to these and related questions will emerge as you model different supply chain options, and simulate their performance to see what works best.
Things to Think About Regarding Your Distribution Center
As you change from truck to rail for your main mode of transportation, look at the map of the Angolan Railway System above and locate nodes in the network where different rail lines (planned and existing) come together. Then use your SCM Globe account and zoom in and look at those places. Switch to satellite view and look for freight handling facilities that would indicate a good location for a new DC.
The screenshot below shows the Huambo railway station. Huambo is one of those nodes where different rail lines come together. Notice the size of the warehouse facilities and the presence of a rail yard that can handle several large trains simultaneously (red arrows). Notice also there is a potential facility for the Huambo store located right near the train station (yellow circle).
Note some other cities on the rail lines that might make good locations for a new distribution center. Then zoom in to view those other locations and switch to the satellite view. Find the railway stations in those cities. Look at the size of the stations and the size of warehouses and other freight handling facilities next to them. What do you see? How do those other stations compare to the one in Huambo regarding their freight storage and handling capabilities?
Also note how these freight handling facilities compare to those at the port in Luanda where your present DC is located (yellow circle on right side of screenshot below). Your present DC is located in a large warehouse near the container storage yards where the freight containers are stored after they are unloaded from cargo ships at the port. You can also see your DC is located on the rail line that runs along the south side of that facility. Follow the rail line to the left and see the railroad station (yellow circle in lower left of screen).
You have three options for the location of your DC:
- Maintain your Luanda DC and continue to serve the supply chain out of that DC
- Keep the Luanda DC and open another DC in another city
- Close the Luanda DC and serve the supply chain from products stored at a new DC.
What are the pros and cons for each of these options based on what you see by looking at the facilities involved? How do these different options affect transportation costs and why?
See useful techniques for expanding this supply chain and adding new facilities, vehicles and routes in the online guide section“Tips for Building Supply Chain Models”. See how to model railroad vehicles and routes under the headings for Vehicles and Routes. There are also ideas for reducing inventory and calculating optimum product delivery amounts and schedules in “Cutting Inventory and Operating Costs“.
Along with your new supply chain model create a short presentation explaining how you built your rail-based supply chain and why you choose the locations you chose for your facilities. Show how the costs and inventory levels compare to a truck-based supply chain.
To be even more realistic, do research on the Internet to find out what current commercial real-estate rental rates are in the cities in Angola where you have facilities. Rents have come down since this case study was originally written (2014). Do some web searches on key phrases and see what you can find. Look for websites of commercial real-estate brokers that have information about lease and rental rates in Angola. Here is one such website, Knight Frank, where you can see lease rates and purchase prices for property in Angola – https://www.knightfrank.com/africa/luanda
A Few Things You Should Not Do
SCM Globe is used to model and simulate real supply chains so all numbers in any model can be changed as needed to more accurately describe actual products, facilities, vehicles and routes. However, when using the simulations as a learning tool in a case study it does not make sense to change some default values even though the software will let you do so. You should not change certain default values listed below because it either doesn’t make business sense, or it doesn’t make logistics sense (see further explanation in the email a logistics professor sent to his students — Case Study Caveats and Taboos):
- Don’t reduce product demand or prices – that makes no business sense as business is about increasing demand and profits.
- Don’t increase or decrease initial on-hand inventory amounts at the start of a case study – that makes no logistics sense as inventory doesn’t simply appear or disappear.
- Don’t change default values for daily rent and operating costs at facilities, or default values for vehicle operating costs. Unless your instructor says otherwise, you can assume they are out of your control in this case study.
- NOTE: Default rent costs at facilities are set higher than current market rates. If your instructor does allow you to change rent costs, use commercial real-estate websites to research current rental rates in different cities and type in those rental rates in place of the default rates.
Apart from these few things, you can do anything else to address challenges and solve problems that arise in the simulations. You can:
- add or change types of delivery vehicles and delivery routes
- change delivery frequencies (delay between departures)
- change delivery amounts (drop qty)
- expand or reduce storage capacity at facilities
- change production rates at the factory
- experiment with different locations for new facilities added during the case study
- You can do anything that is not specifically prohibited!
This case study is not a multiple choice test. There is no single “right answer” — only better answers. Running simulations and downloading the results to create Profit & Loss Reports will show you the better answers. They are the ones that keep the supply chain running for 30 days at lower operating costs and lower inventory levels — they make the supply chain as responsive and efficient as possible.
REMEMBER — There is a reporting template for this case study. Import your simulation data into the template and create monthly profit & loss reports as well as generate key performance indicators for the S&J Trading Company supply chain. As you add more facilities, add more columns to the template to handle the data for those facilities – https://docs.google.com/spreadsheets/d/1LJjcdMIjbHzbOc3xkUmEnya9EL-5S9w-Zz-cf-E1R_Y/edit#gid=1352167925
To share your changes and improvements to this model (json file) with other SCM Globe users see “Download and Share Supply Chain Models”
Register on SCM Globe to gain access to this and all other case studies. Click the blue “Register” button on the Log In 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.