Problem 5 (16 points) Solve this problem in Excel: The plant manager. Murat Kristal, at York Technologies makes Aircraft Navigation Systems. He expects you as the new OM analyst, to provide some insight for performance of the plant High on his list is an understanding of his inventory turnover based on the financial data provided in the following table. He expects you to provide him answers on the following questions, INote: You should be able to copy paste the data Into Excel] LAST THIS YEAR YEAR in (in $ SI Sales 315.000 328.000 Cost of Goods 181.000 186,000 Sold Gross Margin 134.000 142.000 Other 54,000 64.000 Expenses Net Income 80,000 78.000 Finished Goods 3,000 6.000 Inventory Work in Process 12.000 15.000 Inventory Raw Material 6.000 7.000 Inventory Total (inventory 21.000 28.000 Laverage for Year) Other Current 141.000 150.000 Assets Other Assets 11280.000 292.000 Total Assets 421,000 442.000 Other Current 141.000 150.000 Assets Other Assets 280.000 292.000 Total Assets 421,000 442.000 a) Based on total inventory, what is the inventory turnover for last year? [2 points) b) Based on total inventory. what is the inventory turnover for this year? 12 points) c) Has inventory turnover improved this year? (2 points) d. The company's percentage of assets committed to inventory last year. [2 points) el The company's percentage of assets committed to inventory this year. [2 points) f) The change in the percentage of assets committed to inventory. [2 points) g) How many weeks of finished goods were on hand at the end of last year. 12 points) h) How many weeks of finished goods were on hand at the end of this year. [2 points) Upload Choose a File