Question

In: Finance

A company sells 1,900 units during the year. In addition, the company uses a periodic inventory...

A company sells 1,900 units during the year. In addition, the company uses a periodic inventory system, has a beginning inventory of 600 units that were purchased at $10 per unit, and has the following purchases and sales. What is the company's ending inventory if it uses the FIFO method? Date Units purchased Cost per unit January 1,000 $11 May 900 $12 October 700 $14

Solutions

Expert Solution

Given Information:

Sales – 1900 units

Opening Inventory – 600 units or $6000 (600 units * $10)

Purchases made during the year:

(i) January – 1000 units at $11 per unit

(ii) May – 900 units at $12 per unit

(iii) October – 700 units at $14 per unit

Note: Periodic inventory system is a method of inventory valuation where businesses physically count their products at the end of specific periods. In this question, company valued its opening inventory in this method, which is given as 600 units at $10 per unit.

*FIFO Method – This is an inventory valuation method in which the assumption is, the oldest units in the inventory have been sold first. That is First in First out (FIFO). The products that are purchased first will be sold first.

Since the company uses FIFO Method for its inventory valuation, the computation will be as follows:

Total sales is 1900 units

As per FIFO method, the units sold will be the ones purchased first. That is 600 units of opening inventory, 1000 units purchased in January and 300 units purchased in May.

Therefore the closing inventory comprises of 600 units (that is 900 units – 300 units sold) and 700 units purchased in October.

Value of closing inventory as per FIFO Method:

600 units at $12 per unit = $7200

700 units at $14 per unit = $9800

Closing Inventory (units) = 1300 (600+700)

Closing Inventory ($) = $17000 ($7200 + $9800).


Related Solutions

Courtney Company uses a periodic inventory system. The following data were available: beginning inventory, 1,900 units...
Courtney Company uses a periodic inventory system. The following data were available: beginning inventory, 1,900 units at $20; purchases, 5,700 units at $25; operating expenses (excluding income taxes), $96,000; ending inventory per physical count at December 31, 1,200 units; sales price per unit, $50; and average income tax rate, 30%. Required: 1. Prepare income statements under the FIFO, LIFO, and weighted average costing methods. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Between FIFO...
Graczyk Company uses a periodic inventory system. During October, it sold 360 units of Product Z....
Graczyk Company uses a periodic inventory system. During October, it sold 360 units of Product Z. Its beginning inventory and purchases during the month were as follows: Oct. 1 Beginning inventory 100 units @ $20 5 Purchases 100 units @ $24 10 Purchases 100 units @ $22 15 Purchases 100 units @ $24 20 Purchases 100 units @ $28 25 Purchases 100 units @ $26 Compute the cost of goods sold under each of three methods: (a) average-cost, (b) LIFO,...
Cullumber Company uses the periodic inventory system and had 100 units in beginning inventory at a...
Cullumber Company uses the periodic inventory system and had 100 units in beginning inventory at a total cost of $10,000. The company purchased 200 units at a total cost of $26,000. At the end of the year, Cullumber had 60 units in ending inventory. Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-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....
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT