calculate cost of goods sold

Calculate Using Perpetual FIFO

Beginning balances as op 12/1/14 # of Units Purchase Date 4/17 Beginning Inventory 6/1 Beginning Inventory 8/22 Beginning Inventory 10/1 Beginning Inventory 12/6 Purchase 12/10 Purchase 12/18 Purchase 12/19 Purchase 12/24 Purchase 12/30 Purchase Totals Cost per Unit 335 340 346 350 360 365 $ 375 $ 376 $ 380 $ 385 Total Cost $ 167,500 $ 102,000 $ 69,200 $ 35,000 $ 180,000 $ 146,000 $ 150,000 $ 37,600 $ 76,000 $ 107,800 $ 1,071,100 400 100 200 280 2,980 # of Units 250 200 12/1 Sale 12/3 Sale 12/7 Sale 12/9 Sale 12/11 Sale 12/12 Sale 12/13 Sale 12/20 Sale 12/21 Sale 12/26 Sale 12/31 Sale Total units sold 250 310 320 235 180 2,700 Cost of Goods Sold (Perpetual FIFO): Date of Sale Units Sold: Cost per Unit Total Cost 12/1 12/3 12/7 12/7 12/9 12/9 12/11 12/11 12/11 12/12 12/13 12/13 12/20 12/21 12/21 12/26 12/26 12/26 12/31 Total COGS S . Updated Inventory Totals (after sales) Purchase Date # of Units Cost per Unit 4/17 Beginning Inventory 500 $ 335 6/1 Beginning Inventory 300 $ 340 8/22 Beginning Inventory 200 $ 346 10/1 Beginning Inventory 350 12/6 Purchase 360 12/10 Purchase 365 12/18 Purchase 375 12/19 Purchase 100 $ 376 12/24 Purchase 200 $ 380 12/30 Purchase 280 $ 385 Totals 2,700 Total Cost $ 167,500 $ 102,000 $ 69,200 $ 35,000 $ 180,000 $ 146,000 $ 150,000 $ 37,600 $ 76,000 $ 107,800 $ 1,071,100 Balanced? (if Oor -)