Determine the value of ending inventory using average cost (weighted average), first in first out (FIFO), and last in first out (LIFO) and present scenarios in which each method is preferred.