Perpetual inventory using FIFO The following units of a particular item were avalable for sale during the calendar veari This information has been collected in the Microsoft Excel Online fils, Open the spreadshect, perform the required analyais, and input rour answers in the quetion belbic. X= Open apreadsheset The firm maintains a pecpetual inventory system, Determine the cost of goods sold for each salo and the inventory balsnce after each sale, assuming the first in, first-out method. Aresent the da