Suppose that a firm's cost of goods sold for the year is $$2\mathrm{.}0$ million, and beginning and ending inventories for the year are $$252,000$ and $$108,000,$ respectively. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.