Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionSept. $1$ Beginning inventory$10$ Purchase$20$ Sales$25$ PurchaseUnits Purchased at CostUnits Sold at Retail$400$ units $$12600$ units @ $$13680$ units $$22700$ units at $$15$Assume Tyler uses a perpetual inventory system.Required:Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.