Question

In: Accounting

eriodic Inventory by Three Methods The units of an item available for sale during the year...

eriodic Inventory by Three Methods

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

Jan. 1   Inventory 13 units at $41
Feb. 17   Purchase 5 units at $43
Jul. 21   Purchase 17 units at $46
Nov. 23   Purchase

20 units at $47

  1. There are 5 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to one decimal and final answers to the nearest whole dollar, if required.

    a. Determine the inventory cost by the first-in, first-out method.
    $

    b. Determine the inventory cost by the last-in, first-out method.
    $

    c. Determine the inventory cost by the weighted average cost method.
    $

Solutions

Expert Solution

a.
First-in, first-out (FIFO) : In this method those goods are sold first which are purchased first and the ending inventory is from the latest purchases.
Inventory cost = 5 units * $47 = $                 235
b.
Last-in, first-out (LIFO) : In this method those goods are sold first which are purchased last ( i.e. recently ) and the endign inventory is from beginning inventory and ealier purchases.
Inventory cost = 5 units * $41 = $                 205
c.
weighted average cost method
Date Particulars units Unit cost Total cost
Jan. 1 inventory 13 41 533
Feb. 17 Purchase 5 43 215
Jul. 21 Purchase 17 46 782
Nov. 23 Purchase 20 47 940
Goods available for sale 55 2470
Weighted average cost per unit =Cost of Goods available for sale / Units of Goods available for sale = 2470 / 55 = 44.9
Inventory cost = 5 units * $44.9 = $                 225

Related Solutions

Inventory by three methods: The units of an item available for sale during the year are...
Inventory by three methods: The units of an item available for sale during the year are as follows: Jan 1.        Inventory             21 units at 1,800 May 15       Purchase            28 units at 1,950 August 7     Purchase            10 units at 2,040 Nov. 20        Purchase           17 units at 2,100 There are 20 units of the item in the physical inventory at December 31. ROUND YOUR INTERMEDIATE CALCULATIONS AND FINAL ANSWER TO THE NEAREST DOLLAR 1. Using First in First Out Method calculate cost...
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1   Inventory 1,050 units @ $138 Feb. 17   Purchase 1,445 units @ $139 Jul. 21   Purchase 1,615 units @ $141 Nov. 23   Purchase 1,150 units @ $141 There are 1,225 units of the item in the physical inventory at December 31. The periodic inventory system is used. Do not round intermediate calculation and round final answer to nearest whole value.
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1   Inventory 6 units @ $50 Feb. 17   Purchase 14 units @ $52 Jul. 21   Purchase 13 units @ $53 Nov. 23   Purchase 10 units @ $54 There are 4 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to one decimal and final answers to the nearest...
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1   Inventory 1,080 units @ $122 Feb. 17   Purchase 1,390 units @ $124 Jul. 21   Purchase 1,625 units @ $125 Nov. 23   Purchase 1,135 units @ $126 There are 1,210 units of the item in the physical inventory at December 31. The periodic inventory system is used. Do not round intermediate calculation and round final answer to nearest whole value....
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 17 units at $48 Feb. 17 Purchase 20 units at $49 Jul. 21 Purchase 13 units at $51 Nov. 23 Purchase 7 units at $51 There are 11 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to the nearest cent and final answers to the...
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1   Inventory 1,060 units @ $134 Feb. 17   Purchase 1,375 units @ $135 Jul. 21   Purchase 1,580 units @ $136 Nov. 23   Purchase 1,140 units @ $137 There are 1,215 units of the item in the physical inventory at December 31. The periodic inventory system is used. Do not round intermediate calculation and round final answer to nearest whole value....
Inventory by Three Methods The units of an item available for sale during the year were...
Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan.1   Inventory 27 units at $400 Feb. 19   Purchase 54 units at $460 June 8   Purchase 63 units at $520 Oct. 7   Purchase 56 units at $550 There are 45 units of the item in the physical inventory at December 31. Determine the cost of ending inventory using (a) the first-in, first-out method, (b) the last-in, first-out method, and (c) the average...
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 1,060 units @ $128 Feb. 17 Purchase 1,440 units @ $129 Jul. 21 Purchase 1,575 units @ $130 Nov. 23 Purchase 1,150 units @ $131 There are 1,225 units of the item in the physical inventory at December 31. The periodic inventory system is used. Do not round intermediate calculation and round final answer to nearest whole value....
Periodic Inventory by Three Methods The units of an item available for sale during the year...
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1   Inventory 19 units at $29 Feb. 17   Purchase 9 units at $30 Jul. 21   Purchase 17 units at $31 Nov. 23   Purchase 10 units at $33 There are 11 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to the nearest cent and final answers to the...
Inventory by Three Methods The units of an item available for sale during the year were...
Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan.1   Inventory 25 units at $400 per unit Feb. 19   Purchase 56 units at $460 per unit June 8   Purchase 60 units at $540 per unit Oct. 7   Purchase 56 units at $550 per unit There are 47 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost under each of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT