Problem
Suppose that a firm has an ending inventory of $124,000 as of December 31, 2012. The accounting information for 2013 has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Task
a) What is the monthly inventory turnover ratio for each of the twelve months for 2013?
b) What is the total cost of goods sold for the year?
c) What is the average monthly inventory?
d) What is the annual inventory turnover ratio? Do not round intermediate calculations.