FIFO and LIFO costs under perpetual inventory system

The following units of an item were available for sale during the year:

Beginning inventory	8,000	units at $170
Sale	4,800	units at $300
First purchase	15,200	units at $173
Sale	13,100	units at $300
Second purchase	16,200	units at $181
Sale	14,100	units at $300

The firm uses the perpetual inventory system, and there are 7,400 units of the item on hand at the end of the year.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

FIFO and LIFO costs under perpetual inventory system
The following units of an item were available for sale during the year:
	Quantity	Price
Beginning inventory	8,000	$170
Sale	4,800	$300
First purchase	15,200	$173
Sale	13,100	$300
Second purchase	16,200	$181
Sale	14,100	$300
Ending inventory	7,400
Using formulas and cell references, perform the required analysis, and input your answers into the Inventory Cost column. Transfer the numeric results for the green entry cells (B16:B17) into the appropriate fields in CNOWv2 for grading.
	Inventory Cost	Formulas
FIFO method
LIFO method

1. What is the total cost of the ending inventory according to FIFO? Round your answer to the nearest dollar.

   $

2. What is the total cost of the ending inventory according to LIFO? Round your answer to the nearest dollar.

   $