Benchmark by KPI - Inventory / Total Assets
1
Inventory management for food, beverage & Tobacco in the USA has a median of 11% of it's assets in inventory and 42% of it's assets in the 90th percentile whereas China's inventory management in the food , beverage & Tobacco Industry is at a median of 13% of its assets in inventory and 31% of its assets inventory.
Capital goods in China seem to have a higher percentage of assets in inventory with a median of 14% and 28% in the 90th percentile as compared to the US with 13% and 3% respectively. The Health care industry in China has a median of 8% and 2% of the 90th percentile this indicates that inventory in this sector is not as important as compared to the US with 28% in the 90th percentile of its assets in inventory.
1/14
Industrial Comparison - Efficiency
3
Consumer staples is higher in both the the median payable days/ receivable days and Median Labor productivity.
Health care industry is the least in both median return on invested capital and median inventory turnover.
3/14
Industrial Comparison - Profitability
4
Total Revenue for Industrials is higher than that of Real Estates in China hence more profitable
4/14
Value Driver Analysis
6
As gross Margin Increases inventory turnover decreases for the year 217-2019. This may be due to the cost of goods sold
6/14
Value Driver Analysis
7
As asset turnover increases, inventory turnover increases in the consumer staples industry between 2017-2019 this may be due to large asset sales between 2017-2019
7/14
Enterprise Comparison - Key Indicators
10
In Enterprise comparison, Coca Cola Co. is bigger than Pepsi Co. in size. Coca-Cola Outshines Pepsi in 6 key indicators: Net Margin, Gross Margin, Return on Assets Total Revenue Growth Rate Payable days/Receivable days and Return on Equity. This shows that Pepsi take longer days to pay their suppliers as compared to Coca-cola. However, Pepsi outshines Coca-Cola in 3 indicators: Inventory Turnover, Current ratio and liability asset ratio. Pepsi therefore has a higher inventory turnover as compared to Coca-cola.
10/14
Enterprise Ranking - Total Revenue
11
In Enterprise Ranking, Pepsi out-performed the rest of the companies in terms of Total Revenue close to $70,000,000 in 2019 in the Food, Beverage & Tobacco industries. Coca-Cola came in 5th in terms of total revenue close to $40,000,000 in the year 2019.
11/14
Enterprise Trend - Efficiency
12
In terms of efficiency trends, Pepsi consistently out performs Coca -Cola in Inventory days, Labor Productivity, and Payable/Receiveable Days. This shows that Pepsi treats it,s suppliers and employees better than Coca-Cola. For Cash conversion cycle, both Pepsi and Coca-cola take a less time to convert their products into cash but took less than 90 days in 2018 and less than 60 days in 2019 while Coca-Cola would take less than 120-150 days.
12/14
KPI Examination
13
For profitability, we can see that coca-cola is highly profitable with a Gross margin of 95% an Operating Margin of 93%. In regards to Financial health Free cash flow/ total cost is at 94% this shows their growth rate is very good. On Operational efficiency they are not very efficient when we look at their inventory days, it take them 69 days to move their products.
13/14
KPI Examination
14
Gieven the same conditions, Pepsi in regards to profitability does quite well but Coca cola does way better than Pepsi.On financial Health, Coca cola is still better than it's counterpart Pepsiwhich also prforms relatively well. In regards to growth Pepsi performs below average as opposed to that of coca cola. On operational efficiency however, Pepsi performs beter than coca cola tha has longer inventory days compared to 23 inventory days of Pepsi which means Pepsi takes 23 days for their products before they are moved.
14/14