please solve in the same way

Units Sold LIFO Total Cost Conditional Formatting Jan 7 700 Jan. 1 (begin. inv.) Jan 10 500 Unit Units Cost 1,200 $ 3.00 600 $ 3.20 1,000 $ 3.30 1,300 $ 3.40 1,600 $ 3.50 5,700 Jan 18 Jan 23 Jan 28 Jan 13 Jan 18 Jan 20 Jan 26 300 1100 800 1300 Jan 31 Unit sold 4700 (1) Periodic LIFO (2) Perpetual LIFO Date Jan. 1 (begin. inv.) Jan 7 Units purchased unit cost 1,200 $ 3.00 unit sold balance unit Total cost 1,200 3600 700