The value of inventory turnover may lie in benchmarking against competitors to be able to make apples-to-apples comparisons. Comparing companies that operate in different industries or sectors can be misleading and may not provide an accurate representation of a company's performance. For example, comparing Target and Honda, or Apple Inc and Home Depot, would not be meaningful as these companies operate in vastly different industries with different business models, inventory management practices, and supply chain structures. Therefore, comparing companies within the same industry or sector is crucial when benchmarking inventory turnover. Instructions for Analyzing Inventory Tumover in a Specific Industry 1. Download the provided CSV file Inventory Turnover- 1 xas & for benchmarking inventory turnover analysis for firms in the chosen industry. 2. Choose a pair of companies from the given industries, For example, Target vs Walmart, Lowe's vs Home Depot, or Honda vs GM. 3. Identify the columns for COST OF GOODS SOLD (COGS) and AVERAGE INVENTORY for the chosen companies. 4. Calculate inventory turnover ratio for each company by dividing COGS by AVERAGE INVENTORY, Inventory turnover ratio = COGS / AVERAGE INVENTORY. 5. Compare the inventory turnover ratios of the two companies. Which company has a higher inventory turnover ratio? 6. Compute inventory turnover in days for each company by using the formula 365 divided by the inventory turnover ratio. Inventory tumover in days =365 / Inventory Turnover Ratio. 7. Plot the imventory turnover in days for both companies on a line chart using Excel or any other soltware of your choice. 8. Interpret the resuits based on your analysis is inventory turnover higher the better? What do the inventory turnover ratios and days indicate about the efficiency of the companies inventory management practices? Submission Guideline: Upload your spreadsheet on Canvas. \begin{tabular}{|c|c|c|c|c|c|c|} \hline grkey & fyear & tic & Industry & Company & Cost_of_Goods_Sold & Average_Inventory \\ \hline & 3813 & 2009 TGT & Retail & TARGET CORP USO & 44062 & 7179 \\ \hline & 3813 & 2010 TGT & Retail & TARGET CORP USD & 46585 & 7596 \\ \hline & 3813 & 2011 TGT & Retail & TARGET CORP USO & 48306 & 7918 \\ \hline & 3813 & 2012 TGT & Retail & TAHGET CORP USD & 51035 & 7903 \\ \hline & 3813 & 2013 TGT & Retail & TARGET CORP USD & 51160 & 8766 \\ \hline & 3813 & 2014 TGT & Retail & TARGET CORP USD & 51278 & 8790 \\ \hline & 3813 & 2015 TGT & Retail & TARGET COAP USO & 51997 & 8601 \\ \hline & 3813 & 2016TGT & Retail & TARGET CORP USD & 48872 & 8309 \\ \hline & 3813 & 2017 TG & Retail & TARGET CORP USO & 50874 & 8657 \\ \hline & 4611 & 2009M & Retail & MACrSINC USO & 13973 & 4615 \\ \hline & 4611 & 2010M & Retail & MACrSINC USO & 14824 & 4758 \\ \hline & 4611 & 2011M & Metail & MACrs INC USD & 15738 & 5117 \\ \hline & 4611 & 2012M & Retail & MACr'S INC USD & 16538 & 5308 \\ \hline & 4611 & 2013M & Hetail & MACY'SINC USD & 16725 & 5557 \\ \hline & 4611 & 2014M & Retail & MACYSINC USD & 16863 & 5516 \\ \hline & 4611 & 2015M & Retail & MACYSINC USD & 16496 & 5506 \\ \hline & 4611 & 2016M & Retail & MACr's INC USO & 15621 & 5399 \\ \hline & 4611 & 2017M & Retail & MACrSINC USO & 14161 & 5178 \\ \hline & 4839 & 2010F & Automobile & FORD MOTOA USO & 100478 & 5917 \\ \hline & 4839 & 2011F & Automobile & FORD MOTOR USD & 109800 & 5901 \\ \hline & 4839 & 2012F & Automobile & FORD MOTORUSD & 108913 & 7362 \\ \hline & 4839 & 2013F & Automobile & FORO MOTORUSO & 121159 & 7708 \\ \hline & 4839 & 2014F & Automobile & FORO MOTORUSO & 119264 & 7866 \\ \hline & 4839 & 2015F & Automobile & FORD MOTOAUSD & 119688 & 8319 \\ \hline & 4839 & 2016F & Automobile & FORD MOTORUSD & 121891 & 8898 \\ \hline & 4839 & 2017F & Automobile & FORD MOTORUSO & 126345 & 10277 \\ \hline & 4839 & 2018F & Automobile & FORD MOTORUSD & 130081 & 11220 \\ \hline \end{tabular} The value of inventory turnover may lie in benchmarking against competitors to be able to make apples-to-apples comparisons. Comparing companies that operate in different industries or sectors can be misleading and may not provide an accurate representation of a company's performance. For example, comparing Target and Honda, or Apple Inc and Home Depot, would not be meaningful as these companies operate in vastly different industries with different business models, inventory management practices, and supply chain structures. Therefore, comparing companies within the same industry or sector is crucial when benchmarking inventory turnover. Instructions for Analyzing Inventory Tumover in a Specific Industry 1. Download the provided CSV file Inventory Turnover- 1 xas & for benchmarking inventory turnover analysis for firms in the chosen industry. 2. Choose a pair of companies from the given industries, For example, Target vs Walmart, Lowe's vs Home Depot, or Honda vs GM. 3. Identify the columns for COST OF GOODS SOLD (COGS) and AVERAGE INVENTORY for the chosen companies. 4. Calculate inventory turnover ratio for each company by dividing COGS by AVERAGE INVENTORY, Inventory turnover ratio = COGS / AVERAGE INVENTORY. 5. Compare the inventory turnover ratios of the two companies. Which company has a higher inventory turnover ratio? 6. Compute inventory turnover in days for each company by using the formula 365 divided by the inventory turnover ratio. Inventory tumover in days =365 / Inventory Turnover Ratio. 7. Plot the imventory turnover in days for both companies on a line chart using Excel or any other soltware of your choice. 8. Interpret the resuits based on your analysis is inventory turnover higher the better? What do the inventory turnover ratios and days indicate about the efficiency of the companies inventory management practices? Submission Guideline: Upload your spreadsheet on Canvas. \begin{tabular}{|c|c|c|c|c|c|c|} \hline grkey & fyear & tic & Industry & Company & Cost_of_Goods_Sold & Average_Inventory \\ \hline & 3813 & 2009 TGT & Retail & TARGET CORP USO & 44062 & 7179 \\ \hline & 3813 & 2010 TGT & Retail & TARGET CORP USD & 46585 & 7596 \\ \hline & 3813 & 2011 TGT & Retail & TARGET CORP USO & 48306 & 7918 \\ \hline & 3813 & 2012 TGT & Retail & TAHGET CORP USD & 51035 & 7903 \\ \hline & 3813 & 2013 TGT & Retail & TARGET CORP USD & 51160 & 8766 \\ \hline & 3813 & 2014 TGT & Retail & TARGET CORP USD & 51278 & 8790 \\ \hline & 3813 & 2015 TGT & Retail & TARGET COAP USO & 51997 & 8601 \\ \hline & 3813 & 2016TGT & Retail & TARGET CORP USD & 48872 & 8309 \\ \hline & 3813 & 2017 TG & Retail & TARGET CORP USO & 50874 & 8657 \\ \hline & 4611 & 2009M & Retail & MACrSINC USO & 13973 & 4615 \\ \hline & 4611 & 2010M & Retail & MACrSINC USO & 14824 & 4758 \\ \hline & 4611 & 2011M & Metail & MACrs INC USD & 15738 & 5117 \\ \hline & 4611 & 2012M & Retail & MACr'S INC USD & 16538 & 5308 \\ \hline & 4611 & 2013M & Hetail & MACY'SINC USD & 16725 & 5557 \\ \hline & 4611 & 2014M & Retail & MACYSINC USD & 16863 & 5516 \\ \hline & 4611 & 2015M & Retail & MACYSINC USD & 16496 & 5506 \\ \hline & 4611 & 2016M & Retail & MACr's INC USO & 15621 & 5399 \\ \hline & 4611 & 2017M & Retail & MACrSINC USO & 14161 & 5178 \\ \hline & 4839 & 2010F & Automobile & FORD MOTOA USO & 100478 & 5917 \\ \hline & 4839 & 2011F & Automobile & FORD MOTOR USD & 109800 & 5901 \\ \hline & 4839 & 2012F & Automobile & FORD MOTORUSD & 108913 & 7362 \\ \hline & 4839 & 2013F & Automobile & FORO MOTORUSO & 121159 & 7708 \\ \hline & 4839 & 2014F & Automobile & FORO MOTORUSO & 119264 & 7866 \\ \hline & 4839 & 2015F & Automobile & FORD MOTOAUSD & 119688 & 8319 \\ \hline & 4839 & 2016F & Automobile & FORD MOTORUSD & 121891 & 8898 \\ \hline & 4839 & 2017F & Automobile & FORD MOTORUSO & 126345 & 10277 \\ \hline & 4839 & 2018F & Automobile & FORD MOTORUSD & 130081 & 11220 \\ \hline \end{tabular}
