B Periodic inventory by three methods The units of an item available for sale during the year were as follows: $3 $5 $7 $9 Quantity Price Jan. 1, beginning inventory 2,100 Feb. 17, purchase 3,600 Jul. 21, purchase 2,700 Nov. 23, purchase 1,600 2 Dec. 31, ending inventory 1,800 0 Using formulas and cell references, perform the required analysis, and input your answers into the Inventory Cost column. Transfer the numeric results for the green entry cells (B14:B16) into the 1 appropriate fields in CNOWV2 for grading. 12 13 Method Inventory Cost Formulas 14 FIFO 15 LIFO 16 Weighted average cost 17