Question

In: Accounting

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,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.

    $  

Solutions

Expert Solution

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 Solutions

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 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
ADVERTISEMENT