Untangling the (Supply) Chains: Part 2

Untangling the (Supply) Chains: Part 1” covered popular databases for supply chain information. In Part 2, we highlight resources containing reports useful for supply chain research.

IBISWorld

The IBISWorld database is a popular resource for U.S., China, and global industry reports. Each Industry and Specialized Industry report on the IBISWorld platform includes a visual, interactive supply chain – click a buyer or supplier hyperlink on the supply chain to access a report for that industry.

Supply chain visual from IBISWorld's Solar Power in the U.S. report

The Products & Markets section of the report delves deeper into the industry supply chain, focusing on products and services, demand determinants, major markets, and international trade.

ProcurementIQ

Also from IBISWorld, ProcurementIQ features U.S.-focused procurement research reports covering more than 1,000 indirect products and services, designed to help business professionals make purchasing decisions. Coverage ranges from apparel and personal care products to travel, food, lodging, and entertainment services. Use these reports to evaluate the supply market, identify suppliers, and assess supply chain risk.

ProcurementIQ Telehealth Services report's Supply Chain & Vendors menu

EMIS

EMIS features country and global industry and market research reports, many of which include supply chain analysis. For example, a recent report on the global hand sanitizer market from provider Arizton includes an overview, detailed analysis, disruptions, and risk to the supply chain as well as discussion about ingredient suppliers, accompanied by visuals:

Raw material supply overview from Arizton's global hand sanitizer market research report
Supply chain analysis visual from Arizton's global hand sanitizer market research report

Fitch Solutions

Presented on the FitchConnect platform, this database contains country risk and industry research, Fitch Ratings data and research, fundamental data and analytics, and more. Included are Fitch Ratings articles focused on supply chains in various sectors, Country Operational Risk reports analyzing national and industry supply chain conditions, and special reports.

screenshot of sample headline from Fitch Ratings report regarding supply chain
screenshot of Fitch Solutions November 2020 Special Report titled "The Future of Supply Chains: Regionalisation, Not Globalisation"

Having access to supply chain data and reports makes it easy to become a supply chain expert, but Lippincott Librarians are also available to help whenever needed!

    

Untangling the (Supply) Chains: Part 1

From a business perspective, the global pandemic has exposed shortcomings in supply chains within and across industries throughout the world. Supply chain research reveals gaps that equate to opportunities for interested businesses. Lippincott Library offers several resources for supply chain research, each with unique features.

Capital IQ

Remotely accessible to full-time MBA students through the MBA Career Management portal and to all others through Penn Libraries, Capital IQ features current and historical business customer and supplier information for companies and their subsidiaries. Details include customer/supplier name, relationship type, primary industry, and link to the information source.

  • Search by company name to retrieve a Company Profile
  • In the left-side menu, navigate to Business Relationships and select Customers or Suppliers

Here is a partial list of Tesla’s Recently Disclosed Suppliers from Capital IQ:

Capital IQ screenshot of Tesla's Recently Disclosed Suppliers

FactSet

Visit Lippincott Library to access FactSet, a powerful financial and economic database that includes current supply chain information provided by Revere. Covering more than 150,000 relationships, this data provides insight into company supply chains, key customers, suppliers, competitors, and strategic partners. Annual review based on SEC filings keeps this information updated.

FactSet Revere Supply Chain Relationships data is also available on the Wharton Research Data Services (WRDS) platform. This data covers more than 25,000 publicly traded companies around the world and select subsidiaries, representing more than 144,000 business relationships, with historical data back to 2003.

Panjiva

Panjiva is a global supply chain intelligence database containing eight million companies and more than one billion shipment records, with more than 200 countries represented. Included transactional and macro data cover 35% and 95% of global trade flows, respectively. Information is sourced from bill of lading shipment records from U.S Customs and Border Protection, credit information providers, compliance organizations, trade associations, and more. Current and historical information is available.

Search for a company or product name and filter to buyers, suppliers, or shipments, or search product trends. Buyer and Supplier profiles feature top products, countries, shipment records, trading partners, ports and carriers, where applicable, and an Activity Feed featuring new supply chain activity. Corporate hierarchy and contact information are also provided.

To create a Trend report, select a country/region, trade direction (import or export), and a product’s Harmonized System (HS) code.

Panjiva Trends Report header: HS Code 9560.70.40.00
Panjiva Trends Report: Top Global Suppliers for HS Code 9560.70.40.00

Use the Macro tool to analyze trade flows of products between countries. Panjiva Macro data is sourced from UN Comtrade, which obtains the data from each country’s government.

Bloomberg

Bloomberg makes it possible to analyze current and historical supply chain relationships for approximately 23,000 public companies and 96,000 private companies worldwide, representing 900,000 global supply chain relationships. 

Data come from public sources including company reports, conference call transcripts, and regulatory filings, as well as customers and suppliers. This bi-directional data and estimates from industry analysts quantify company exposures from both production and demand sides of the supply chain. The resulting 200,000 quantified supplier-customer relationships include both revenue and cost percentages and links to company filings.

Use the function SPLC to access and analyze supply chain data on the Bloomberg Terminal. Below is an analysis of absolute projected sales growth for companies in Ford Motor Company’s supply chain:

screenshot of Bloomberg's supply chain analysis of Ford Motor Company reflecting absolute projected sales growth percentages

For additional recommendations, refer to our Business FAQ “Where can I find information on a company’s supply chain management?” or contact a Lippincott Librarian.

Stay tuned for Part 2 of this post highlighting reports useful for supply chain research.

It’s a buyer’s market: Using IBISWorld’s Procurement Reports

Whether you’re looking for a basic industry overview, for market research on a niche industry, or for the competitive landscape in a specialized market, you’ve probably looked at an IBISWorld  industry report.  IBISWorld doesn’t just offer market research through their industry reports collection – they also offer research on industry supply chains through their procurement reports. Here’s how you can use IBISWorld‘s procurement reports in your research.

procurement logo

To find procurement reports, go to IBISWorld and click the “Login” button to the right of the “Procurement Reports” banner. (Note: You can only access one of IBISWorld‘s collections at a time. You need to go back to IBISWorld‘s homepage to switch between the Procurement Reports and Industry Reports collections.) Now you can keyword search for a specific report or browse the full report collection.

wind power performanceIBISWorld‘s procurement reports are visually and structurally similar to their industry reports, and the procurement reports offer supply chain information that complements many of the available industry reports. For example, IBISWorld offers industry reports on several aspects of wind energy production, including “Wind Turbine Manufacturing in the US”. This report focuses on industry and company performance, covering industry growth and trends along with major companies operating in this industry.

However, a complementary procurement report on “Turbine Repair and Maintenance” focuses on pricing and buyers who are supporting this industry, covering the average cost of wind turbine repair services and analyzing whether buyers looking for this service are entering a buyer’s or seller’s market. In this case, growth is down in the wind turbine manufacturing industry so there aren’t many new turbines to maintain or repair. But there are a large number of turbine maintenance and repair companies competing for work, so prices for repair and maintenance services are being driven down. In other words, it’s a buyer’s market.

scorecardIBISWorld‘s procurement reports also cover the purchasing process for that industry at the end of each report. This is a valuable instructional section that covers lead time for purchasing a product or service, offers a “Buying-Decision Scorecard” to help decide how much to weight factors like cost and qualifications when choosing a supplier, and includes sample negotiation questions for vetting a potential supplier.

IBISWorld‘s Procurement Reports collection is a great resource for researching company and industry supply chains along with industry dynamics. Looking at a procurement report for an industry alongside its industry report is a great way to look at that industry from another perspective, or to see how different parts of an industry affect each other. Check out the Procurement Reports collection next time you’re looking for industry supply chain information.  If you’re not sure where to start, you can always ask a Lippincott Librarian for help.

What is Your Capital IQ?

SP_Capital_IQ_FINALS&P Capital IQ is a premier financial database used in the industry by leading financial institutions, advisory firms, and corporations. The database covers global public and private companies, investment firms, capital transactions, and people. You can customize reports and export them directly to Excel or use the API to extract data from the database.

We have 8 Capital IQ terminals here at the Lippincott Library. They are located in the Yablon Financial Resources Lab. You need a Wharton username and password to access the database and a librarian to log you in. Full-time Wharton MBAs have remote access to the database though MBA Career Management. Note that access is available only during the school year.

This post focuses on the information available for a single, publicly traded company. While this database does cover privately held companies, the data available for private companies is often minimal because private companies are not required to file with the SEC.

Search

Search by company name in the top toolbar. When you select the company, you will start on the company tearsheet which provides basic qualitative and quantitative information on the firm, including financials, key people, and equity pricing. The left-hand menu allows you to navigate to the different information segments that you can access for the company. Here are some highlights.

Financials/Valuation => Key Stats

The Key Stats page displays high-level financial information for the company you are viewing.  You can view historical financials as well as estimates for data like Total Revenues, Gross Profit, EBITDA, EBIT, Net Income and more. To view historical data (back to the late ’80’s early ’90s), adjust the timeline. Notice that you can easily jump to other financial statements from this screen. The financials can be easily exported to Excel. Select either the single page you are viewing or the entire set of financials. You can also link to the company’s 10-K and 10-Q directly from any financial statement. Continue reading

Bloomberg Highlights: Round 1

Bloomberg HighlightsBloomberg is a key source for current and historical pricing on equities, fixed income securities, foreign exchange and commodities, as well as indicative and fundamental data, customized analytics, and business news. Bloomberg has many supplementary modules that add to its value as a financial resource. This is our first installment of Bloomberg Highlights where we show off some of Bloomberg’s most interesting features.

Bloomberg’s Mapping Module (BMAP)

BMAP allows you to map world wide energy assets (oil, gas fields, pumping stations and pipe lines) and mines (coal, gold and other minerals) as well as individual vessels in ports. Energy assets can be displayed as points on a map or in table format. Below is a map of natural gas pipelines, shown in red, overlaid with US shale basins in blue.

For access, type BMAP and hit the green <GO> key

BMap1

Supply Chain Analysis

Bloomberg provides data (when available) on a company’s suppliers and customers. Use the SPLC function to locate a specific company’s supply chain.  For example, to find Merck’s suppliers, customers, and peers type the following into the command line: Continue reading