Perpetual inventery using FIFO The following units of a particular item nere avaliable for saie during the calendar vear: Jor1Aor.10June30Septi2Nov.15tnventorySolePurhoseSalePurchose4,200untsat$382,200units4,600untsat$405,500units2,500unitsot$42 This infermaties has been collected in the Miorosoft Excel Ooline file. Open the spreadiheet, perforn the required analysis, and ingut your answers in the quatition bolow. Open spieddeheet The fim maintans a perpetual ifventory svatem. Determine the cout of goods sold for cach sale and the inventsey balance after each ale, atsuming the first-1n, first-out mothos. Pretent the a Ws shates in Eutibit 3. Under firo, if units are in inventery as two different costs, enter the units wth the Lowtr unt cost first in the Cost of Goods Sold Unt Cost celumn and in the Inventory Schedule of Cost of Goeds Sold Firo Method