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

• Homework Help
• 2

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 \$