Inventory Flow Assumptions Prepare a perpetual inventory record using, FIFO, LIFO, and weighted-average inventory costing methods, and determine cost of goods sold and ending merchandise inventory Use cell references from Data Table for quantities and unit cost. Use Excel formulas for total costs and total quantities. Format weighted average unit cost and total costto DATA Units Per Unit Date Jan 1 Inventory on hand 1,000$4 Jan 3 Jan 6 Jan 15 Jan 22 Description Purchase Sale Purchase Sale 3,000 5 2,750 $ 10 5,000 $6 4,500 $ 10 FIFO Purchases COGS Inventory on Hand Date Quantit Unit cost Total Cost Quantit Unit cost Total Cost Quant Unit cost Total Cost