Answered You can hire a professional tutor to get the answer.
See the attached file. Given the attached information, please answer the following questions: a. What is the average inventory turnover for the firm?...
See the attached file.Given the attached information, please answer the following questions:a. What is the average inventory turnover for the firm?b. If you were given the assignment to increase inventory turnover, what would you focus on? Why?c. The company reported that it used $500M worth of raw material during the year. On average, how many weeks of supply of raw material are on hand at the factory?The U.S. Airfilter company has hired you as a supply chain consultant.The company makes air filters for residential heating and airconditioning systems. These filters are made in a single plant locatedin Louisville, Kentucky, in the United States. They are distributed toretailers through wholesale centers in 100 locations in the UnitedStates, Canada, and Europe. You have collected the following datarelating to the value of inventory in the U.S. Airfilter supply chain:QUARTER 1(JANUARY THROUGHMARCH)QUARTER 2(APRIL THROUGH JUNE)QUARTER 3(JULY THROUGH SEPT)QUARTER 4(OCTOBER THROUGHDECEMBER)SALES (TOTAL QUARTER)UNITED STATES300350405375CANADA75607570EUROPE30332015COST OF GOODSSOLD (TOTAL QUARTER)280295340350QUARTER 1(JANUARY THROUGHMARCH)QUARTER 2(APRIL THROUGH JUNE)QUARTER 3(JULY THROUGH SEPT)QUARTER 4(OCTOBER THROUGHDECEMBER)Raw materials at the louisville plant (end of quarter)Work in progress and finished goods at the Louisville plant (end ofquarter)300350405375Distribution center inventoryUNITED STATES25272330CANADA10111516EUROPE5455All amounts in millions of US dollarsa. What is the average inventory turnover for the firm?b. If you were given the assignment to increase inventory turnover, whatwould you focus on? Why?c. The company reported that it used $500M worth of raw material duringthe year. On average, how many weeks of supply of raw material are onhand at the factory?
