A D E F G H Units purchased unit Cost per Total Cost Units Sold Selling of Purchase 1 Date Total Price per Sales unit 2 Dec. 1 Beginning inventory 850 $12 $10,200 3 Dec. 8 Purchase 1,050 14 14,700 4 Dec. 10 Sales 800 $30 24,000 5 Dec. 14 Purchase 1,100 15 16,500 6 Dec. 16 Sales 990 $30 29,700 7 Totals 3,000 $41,400 1,790 $53,700 8 9 10 11 Beginning inventory 12 +Purchases Perpetual FIFO LIFO $10,200 $10,200 31,200 31,200 13 Cost of goods available for sale $41,400 $41,400 14 Ending inventory 15 Cost of goods sold 16 17 18 19 Sales 31,800 30,200 $9,600 $11,200 Perpetual FIFO LIFO $53,700 $53,700 20 Cost of goods sold 21 Gross profit 9.600 $44,100 11,200 $42,500 Which formula in cell F14 accurately computes the cost of ending inventory using Perpetual LIFO? Multiple Choice -F7-G4E2 +F2+((D3-G4) E3)+F5 +(D7-G4)*E3 +G4'H4