In: Accounting
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 | |||
What is the total cost of the ending inventory according to FIFO? Round your answer to the nearest dollar.
$
What is the total cost of the ending inventory according to LIFO? Round your answer to the nearest dollar.
$
FIFO METHOD | PURHASES | COST OF GOODS SOLD | CLOSING BALANCE | |||||||
Date | Particulars | Units (A) | Rate | Total Cost | Units (A) | Rate | Total Cost | Units (A) | Rate | Total Cost |
--------- | Beginning inventory | 8000 | $ 170 | $1,360,000 | ||||||
--------- | Sales | 4800 | $ 170 | $ 816,000 | 3200 | $ 170 | $ 544,000 | |||
--------- | First Purchase | 15200 | $ 173 | $ 2,629,600 | 3200 | $ 170 | $ 544,000 | |||
15200 | $ 173 | $2,629,600 | ||||||||
--------- | Sales | 3200 | $ 170 | $ 544,000 | ||||||
9900 | $ 173 | $ 1,712,700 | 5300 | $ 173 | $ 916,900 | |||||
--------- | Second Purchase | 16200 | $ 181 | $ 2,932,200 | 5300 | $ 173 | $ 916,900 | |||
16200 | $ 181 | $2,932,200 | ||||||||
--------- | Sales | 5300 | $ 173 | $ 916,900 | ||||||
8800 | $ 181 | $ 1,592,800 | 7400 | $ 181 | $1,339,400 | |||||
Total | 31400 | $5,561,800 | 27200 | $5,582,400 | 7400 | $1,339,400 | ||||
LIFO METHOD | PURHASES | COST OF GOODS SOLD | CLOSING BALANCE | |||||||
Date | Particulars | Units (A) | Rate | Total Cost | Units (A) | Rate | Total Cost | Units (A) | Rate | Total Cost |
--------- | Beginning inventory | 8000 | $ 170 | $1,360,000 | ||||||
--------- | Sales | 4800 | $ 170 | $ 816,000 | 3200 | $ 170 | $ 544,000 | |||
--------- | First Purchase | 15200 | $ 173 | $ 2,629,600 | 3200 | $ 170 | $ 544,000 | |||
15200 | $ 173 | $2,629,600 | ||||||||
--------- | Sales | 13100 | $ 173 | $ 2,266,300 | 3200 | $ 170 | $ 544,000 | |||
2100 | $ 173 | $ 363,300 | ||||||||
--------- | Second Purchase | 16200 | $ 181 | $ 2,932,200 | 3200 | $ 170 | $ 544,000 | |||
2100 | $ 173 | $ 363,300 | ||||||||
16200 | $ 181 | $2,932,200 | ||||||||
--------- | Sales | 14100 | $ 181 | $ 2,552,100 | 3200 | $ 170 | $ 544,000 | |||
2100 | $ 173 | $ 363,300 | ||||||||
Related SolutionsFIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System The
following units of an item were available for sale during the year:
Beginning inventory 23 units at $44 Sale 8 units at $68 First
purchase 23 units at $46 Sale 23 units at $69 Second purchase 11
units at $47 Sale 11 units at $69 The firm uses the perpetual
inventory system, and there are 15 units of the item on hand at the
end of the year. a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
45 units at $42
Sale
42 units at $59
First purchase
27 units at $44
Sale
15 units at $61
Second purchase
24 units at $46
Sale
20 units at $62
The firm uses the perpetual inventory system, and there are 19
units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System The
following units of an item were available for sale during the
year:
Beginning inventory 20 units at $48
Sale 17 units at $72
First purchase 18 units at $51
Sale 6 units at $74
Second purchase 28 units at $53
Sale 13 units at $76
The firm uses the perpetual inventory system, and there are 30
units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
31 units at $42
Sale
24 units at $63
First purchase
39 units at $44
Sale
37 units at $64
Second purchase
28 units at $46
Sale
7 units at $65
The firm uses the perpetual inventory system, and there are 30
units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
8,100 units at $180
Sale
5,300 units at $300
First purchase
15,000 units at $185
Sale
13,000 units at $300
Second purchase
16,000 units at $192
Sale
14,000 units at $300
The firm uses the perpetual inventory system, and there are
6,800 units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
46 units at $41
Sale
32 units at $57
First purchase
40 units at $43
Sale
44 units at $58
Second purchase
16 units at $46
Sale
6 units at $59
The firm uses the perpetual inventory system, and there are 20
units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
24 units at $46
Sale
12 units at $74
First purchase
26 units at $48
Sale
25 units at $74
Second purchase
14 units at $51
Sale
13 units at $74
The firm uses the perpetual inventory system, and there are 14
units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
47 units at $44
Sale
16 units at $62
First purchase
24 units at $47
Sale
30 units at $62
Second purchase
19 units at $50
Sale
10 units at $62
The firm uses the perpetual inventory system, and there are 34
units of the item on hand at the end of the year.
a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System The
following units of an item were available for sale during the year:
Beginning inventory 20 units at $40 Sale 15 units at $62 First
purchase 37 units at $43 Sale 22 units at $63 Second purchase 13
units at $46 Sale 25 units at $63 The firm uses the perpetual
inventory system, and there are 8 units of the item on hand at the
end of the year. a. What is...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...FIFO and LIFO Costs Under Perpetual Inventory System
The following units of an item were available for sale during
the year:
Beginning inventory
49 units at $40
Sale
46 units at $60
First purchase
37 units at $41
Sale
35 units at $61
Second purchase
17 units at $43
Sale
11 units at $62
The firm uses the perpetual inventory system, and there are 11
units of the item on hand at the end of the year.
a. What is...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|