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 cost to display two decimal places.