Compute COGS and Ending inventory balances using the perpetual method and each of the following cost flow assumptions(FIBO &LIFO)

Search Write Up 23, Inventory (l)xla - Protected View Excel Page Layout Formulas Data Review View Help ful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 8 F G H K Write-Up Problem #2 for Test 2 (15 points total) Compute COGS and Ending Inventory balances using the Perpetual Method and each of the following ost flow assumptions (FIFO & LIFO): (The 4 bold boxes below will be graded!) Ending Inventory FIFO LIFO Units Unit Price Total Cost FIFO Bal LIFO Bal 1-Jun Beg Inventory 300 $ 10.00 $ 3,000 4-Jun Purchases 450 $ 12.00 $ 5,400 9-Jun Sales 500 14-Jun Purchases 250 $ 14.00 $ 3,500 15-Jun Purchases 250 $ 15.00 $ 3,750 23-Jun Sales 600 30-Jun Purchases 225 $ 16.00 $ 3,600 $ 19,250 Total Inven avail. For sale EOP (End of Period) inventory 1,475 375 $ COGS (Cost of Goods Sold) 1,100