Management Inventory Turnover Analysis
Executive Summary Assignment
Background: Inventory Turnover Analysis provides a metric for comparison of supply chain operations within the same industry. A higher ratio indicates higher inventory liquidity and higher efficiency of operations.
Inventory Turnover is calculated as Cost of Goods Sold divided by Inventory. Cost of Goods Sold is found on the Income Statement and Inventory is on the Balance Sheet. (See the section on Measuring Supply Chain Performance in Chapter 11: Supply Chain Management of our text.)
An improvement in operational efficiency, as indicated by a higher turnover ratio, yields two financial benefits. First, the reduced inventory results in a lower inventory carrying cost. Second, the reduced inventory results in a first year reduction in expenditures (you are operating off of already purchased inventory) and therefore, a positive cash flow impact equivalent to the reduction in inventory.
Compare the 2016 inventory turnover results for Walmart and Costco.
Write an executive summary (two page, double spaced, 12 pt Georgia or Tahoma font) detailing the respective inventory turnover ratios for the given period, giving the equivalent number of days of inventory for each company, and the potential financial impact if the under-performing company could match the inventory turnover ratio of the higher-performing company. Assume a 25% carrying cost ratio. Be careful to use the correct units for the financial impact. (Financial numbers in Income Statements and Balance Sheets are often in $millions.)
See the attached template for the summary below.