Finance. FIFO & LIFO table

reported the f61i6wing Janiia/y&pukdhaies inventory system. For specific identification, ending inv o sts 18 January 20 purchase, and 15 units from beginning iHye Its nlyroduct. Th Company uses a perpetual' uri from 'the January 30 purchase, 5 units from the January I anuary 10 January 20 3anuary 25 Januar"j Required: Beginning inventory Sales purchase Sales Purchase Totals it 60 it unit S 80 u "t its I" Qnits 18 unitz IEC units | Isse @ $ 15 1. Complete the table to determine the cosi assigne to dii g in e tfVan Ost of goods sold using specific identification Sold! ing weighted average. 2. Determine the cost assigned to ending inverFory nd: co-t 3. Determine the cost assigned to ending inventori}nd c of? d? ing FIFO. 4. Determine the cost assigned to ending Inveniory?nd c t of qc.bde 'ol sing LIFO Navigation: 2. When finished in Excel, save ond Return to Assignment b right to return to Connect nuary 01 Januar 10 Januar 26 January 25 January 30 Begi in inv to 12 units 140 60 180 330 cost per unit $6.00 $5.00 $4.50 Total cost Units $840 100 300 Purcha Sales Purchase Totals Selling price per $15.00 15.00 Totl Sales $1,500 $1,200 $2, 700 810 $1,950 15 5 180 80 180 u.'For specific identification, ending inventory consif s of the following units: 14 i i 15 15 164 18 20 21 22 23 Units from beginning ityentcv,' Units from purchase of January 20 Units from purchase pf January 30 Trom oegnmng 'Units from purchasedf nua Units from purchase offinuaw Specific Identification available 140 units from beginning inventory 60 units purchased on Janua 20 180 units purchased on January 30 Total; . cp SC. 50 sp.oc Ending units , Cost per Total Cost ss.oo $5.00 sa.50 so.oo