The company has the policy of stating all inventory on hand at the lower of cost and net realizable value. The company uses the direct method for any adjustments to inventory.NOTE - on the income statement use "Cost of Goods Sold" from the trial balance - do not calculate the cost of goods sold.In the excel spreadsheet, see the tab "Inventory Detail" to perform any necessary calculated