B K M N D H 5 T U | Workbook last saved: Just now 2 2 H Hequirurrunt Preparawlery mardus FIFO, UFO, and will dinary conting methods, and din cast of and sale and widing and investory. Use cere from Data Table for quante ans un cost Use Fare formule for total costs and to quantes Format wegheader unt cost and total cost to display two decimal places. 3 4 7 Date Jan 1 Jan 3 Jan 6 Jan 15 Jan 22 DATA Description Inventory on hand Purchase Sale Purchase Sale Units 1,000 3,000 2.750 5,000 4,500 Per Unit S 4 $ 5 $ 10 S 6 $ 10 9 30 12 13 14 Purchases Unit cast FIFO COGS Unit cast Quantity Tatal Cost Quantity Tatal Cost Date Jan 1 Inventory an Hand Quantity Unit cost Tatal Cost 1,000 $ 4.00 $ 4,000.00 28 Jan 3 3,000 $ S$ 15,000 1,000 $ 3,000 $ 4.00 $ 5.00 $ 4,000.00 15,000.00 30 22 Jan 6 4 1,250.00 $ 5.00 $ 6,250.00 1,000 1,750 4,000S 8,750.00 04 5.00 $ Jan 15 5,000 $ 6 $ 30,000 27 28 1,250 5,000 5 6 6,250 30,000 39 ac Jan 22 1.750 6 10.500 al a2 1,250 3,250 5 6.00 $ 6.250 19,500.00 14 A B D E F G H K L M 25 26 27 Jan 15 5,000 $ 6$ 30,000 1,250 5,000 5 6 6,250 30,000 28 29 30 31 Jan 22 1,750 6 10,500 1,250 3,250 5 6.00 $ 6,250 19,500.00 32 33 34 35 8,000 $ 45,000 7,250 $ 38,500.00 1,750 $ 35.00 $ 10,500.00 36 37 38 LIFO 39 COGS Purchases Unit cost Inventory on Hand Unit cost Total Cost Quantity Total Cost Quantity Unit cost Date Jan 1 Total Cost 40 41 Quantity 42 43 44 Jan 3 45 46 47 Jan 6 48 49 50 51 52 Jan 15 53 54 55 56 57 Jan 22 58 59 60 A G H K L M 54 55 56 57 Jan 22 58 59 50 51 52 $ 8,250.00 53 54 55 56 Weighted-Average COGS Quantity Unit cost Inventory on Hand Purchases Unit cost 57 Quantity Total Cost Total Cost Date Jan 1 Quantity Unit cost Total Cost 68 59 70 Jan 3 71 72 73 74 75 Jan 6 76 77 Jan 15 78 79 30 81 B2 83 Jan 22 34 85 36 37 B8 B9