The following units of a particular item were available for sale during the calendar year:

DATA

$\backslash$table$[[,,$Quantity,Price,$],[$Jan$.1,$Inventory,$4,400,,],[$Apr$.19,$Sale,$2,600,,],[$June $30,$Purchase,$4,100,,],[$Sept$.2,$Sale,$4,800,$$$41,],[$Nov$.15,$Purchase,$2,400,,]]$

REQUIRED:

The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the first$-$in$,$ first$-$out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV$2$ for grading.

Data