Answer using excel !

PT Andalan Utama is engaged in buying and selling electronic equipment. All transactions are made in cash and there are no damaged items for return transactions. Transactions related to inventory at PT Andalan Utama during December 2020 are as follows:

Date	Description	Number of Units	Price per Unit ($)
1/12/17	Beginning Stock	100	15
5/12/17	Purchase	150	20
10/12/17	Sales	140	50
15/12/17	Purchase	130	25
20/12/17	Sales	100	50
22/12/17	Purchase	150	30

REQUESTED: Calculate the value of ending inventory if the company uses the method: a. Perpetual First In First Out (FIFO) b. Periodic Average (Weighted Average)