Module 8 Part c.xlsx - 1 Units available for sale = 100 400...

This preview shows page 1 - 2 out of 2 pages.

1 Units available for sale = 100 + 400 + 120 + 200 = 820 2 Units in ending inventory = 100 + 400 - 420 + 120 + 200 - 160 = 240 3 FIFO Date Purchases Cost of goods sold Balance 1-Mar 100 $ 50.00 $ 5,000.00 5-Mar 400 $ 55.00 22,000.00 100 $ 50.00 $ 5,000.00 400 $ 55.00 $ 22,000.00 500 $ 27,000.00 9-Mar 100 $ 50.00 $ 5,000.00 80 $ 55.00 $ 4,400.00 320 $ 55.00 $ 17,600.00 420 $ 22,600.00 80 $ 4,400.00 18-Mar 120 $ 60.00 7,200.00 80 $ 55.00 $ 4,400.00 120 $ 60.00 $ 7,200.00 200 $ 11,600.00 25-Mar 200 $ 62.00 12,400.00 80 $ 55.00 $ 4,400.00 120 $ 60.00 $ 7,200.00 200 $ 62.00 $ 12,400.00 400 $ 24,000.00 29-Mar 80 $ 55.00 $ 4,400.00 40 $ 60.00 $ 2,400.00 80 $ 60.00 $ 4,800.00 200 $ 62.00 $ 12,400.00 160 $ 9,200.00 240 $ 14,800.00 580 $ 31,800.00 240 $ 14,800.00 LIFO Date Purchases Cost of goods sold Balance 1-Mar 100 $ 50.00 $ 5,000.00 5-Mar 400 $ 55.00 $ 22,000.00 100 $ 50.00 $ 5,000.00 400 $ 55.00 $ 22,000.00 500 $ 27,000.00 9-Mar 400 $ 55.00 $ 22,000.00 80 $ 50.00 $ 4,000.00 20 $ 50.00 $ 1,000.00 420 $ 23,000.00 80 $ 4,000.00 18-Mar 120 $ 60.00 $ 7,200.00 80 $

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture