Inventory Flow Assumptions Requirement Prepare a perpetual inventory record using LIFO and Weighted-Average inventory costing methods, and determine cost of goods sold and ending merchandise inventory (FIFO inventory record is completed and provided as a reference). Use cell references from the above Data Table for quantities and unit cost. Use Excel formulas to calculate total costs and total quantities. Format weighted average unit cost and total cost to display two decimal places. DATA Date Jan 1 Jan 3 Jan 6 Jan 15 Jan 22 Units Per Unit Inventory on hand Purchase Sale Purchase Sale 1,000 S 3,000 2,750 $ 5,000 $ 4,500 10 10