The below lots of a particular commodity were available for sale during the year. The periodic inventory system is used.

Beginning Inventory $10$ units $$60$

First purchase $40$ units $$59$

Second purchase $35$ units $$62$

Third purchase $15$ units $$63$

Using the Excel file provided, calculate the ending inventory value using the FIFO, LIFO, and Weighted Average methods. There is a separate worksheet for each method within the Excel file. Please complete your calculations as if there are $25$ units in the ending inventory for each method.