Please use excel to solve. The problem and the data provided must be clearly laid out in the spreadsheet and cell referencing must be used.

6. A firm with sales of $500,000 has average inventory of $200,000. The industry aver- age for inventory turnover is four times a year. What would be the reduction in inven- tory if this firm were to achieve a turnover comparable to the industry average