Select 5 companies that sell products. Find their annual reports. Using EXCEL, develop a spreadsheet detailing their; Company Name, Sales $, Cost of Goods Sold $, Inventory Level $, Inventory Turnover Ratio, and Inventory Holding $ (use 25% of their inventory level $). The Inventory holding cost and Turnover Ratio calculations must be performed in Excel using a formula. Format your spreadsheet to look professional. Use data from 2018.

BE SURE TO INCLUDE ALL 000'S IN YOUR NUMBERS. OFTEN THE ANNUAL REPORT WILL LIST VALUES IN MILLIONS.

The point of this assignment is to see how much money is being held in Inventory. Supply Chain Management is a hot field with many well paying jobs, because the investment from the companies involved is so great.