Compute:

a$)$ Cost of ending inventory;

b$)$ Cost of goods sold;

c$)$ Gross profit.

$4.$ Assuming LIFO

$5.$ Assuming FIFO

$6.$ Assuming Weighted Average

Questions are gonna be answered in excel :$)$