QUARTER 1 U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States. Conada, and Europe. You have collected the following data relating the value of inventory in the U.S. Airfilter supply chain: QUARTER 2 QUARTER 4 (JANUARY (APRIL THROUGH (OCTOBER JUNE) All amounts in millions of 1.5 dollars Sales (total quarter): United states Canada Europe QUARTER 3 (JULY THROUGH SEPTEMBER) THROUGH MARCH THROUGH DECEMBER) 520 120 55 558 95 36 580 161 41 594 96 22 Cost of goods sold (total quarter) 516 596 678 621 56 72 23 160 126 126 155 Raw materials at the Louisville plant (end-of-quarter Work-in-process and finished goods at the Louisville plant (end of quarters Distribution center inventory (end of quarter) United states Canada Europe 26 12 7 43 15 39 25 7 35 17 8 a. What is the average inventory turnover for the firm? (Round your answer to 3 decimal places.) o. What is the average inventory turnover for the firm? (Round your answer to 3 decimal places.) Average mventory tumaver b. If you were given the assignment to increase inventory turnover, who would you focus on? Reduce the amount of inventory or reduce sales or both O Increase the amount of inventory or increase sales or both Reduce the amount of inventory or increase sales or both c. The company reported that it used $6297M worth of raw material during the year On average, how many weeks of supply of raw material are on hand at the factory? (Round your answer to 2 decimal places.) c. The company reported that it used $6297M worth of raw material during the year. On average, how many weeks of supply of rew material are on-hand at the factory? (Round your answer to 2 decimal places.) Works of supply