I have a test on excel that is using Fifo, lifo, and weighted average. They are graphs which include costs of goods sold and cost of ending inventory. I can send you pics of the graph to show you how it look.