Information about Vinzant Company’s inventory of one item follows.
Answer 1)
Calculation of cost of ending inventory under Average Cost Method
Average Cost |
Merchandise Available for Sale |
Ending Inventory |
||||
Number of units |
Unit cost (in $) |
Total cost (in $) |
Number of units |
Average cost per unit (in $) |
Total Cost (in $) |
|
Beginning inventory |
135 |
270 |
36,450 |
|||
Purchases: |
||||||
April |
175 |
275 |
48,125 |
|||
August |
195 |
280 |
54,600 |
|||
October |
145 |
282 |
40,890 |
|||
Total |
650 |
180,065 |
135 |
277.02 |
37,398 |
Average Cost method: Under this method value of ending inventory is calculated by dividing the number of units in ending inventory by the average cost per unit. Average cost per unit is calculated by dividing the aggregate cost of units beginning inventory and units purchased during the period by the aggregate number of units in beginning inventory and units purchased during the said period.
Weighted Average cost = $ 180,065/ 650 units
= $ 277.02
Value of ending inventory = 135 units X $ 277.02
= $ 37,398 (approximately)
Therefore the value of ending inventory under Average cost method is $ 37,398.
Answer 2)
Calculation of cost of ending inventory under FIFO Method
FIFO Method |
Merchandise Available for Sale |
Ending Inventory |
||||
Number of units |
Unit cost (in $) |
Total cost (in $) |
Number of units |
Unit cost (in $) |
Total Cost (in $) |
|
Beginning inventory |
135 |
270 |
36,450 |
- |
- |
- |
Purchases: |
||||||
April |
175 |
275 |
48,125 |
- |
- |
- |
August |
195 |
280 |
54,600 |
- |
- |
- |
October |
145 |
282 |
40,890 |
135 |
282 |
38,070 |
Total |
650 |
1,80,065 |
135 |
38,070 |
FIFO Method: Under FIFO method, it is assumed that the units of inventory which are first bought will be sold first and so on. Thus the ending inventory will be units which are latest bought and moving backwards. In the given question, the company had 135 units in the ending inventory. Under FIFO method, the said inventory will be from the units bought in October at $ 282 per unit.
Therefore the value of ending inventory under FIFO method is $ 38,070.
Answer 3)
Calculation of cost of ending inventory under LIFO Method
LIFO Method |
Merchandise Available for Sale |
Ending Inventory |
||||
Number of units |
Unit cost (in $) |
Total cost (in $) |
Number of units |
Unit cost (in $) |
Total Cost (in $) |
|
Beginning inventory |
135 |
270 |
36,450 |
135 |
270 |
36,450 |
Purchases: |
||||||
April |
175 |
275 |
48,125 |
- |
- |
- |
August |
195 |
280 |
54,600 |
- |
- |
- |
October |
145 |
282 |
40,890 |
- |
- |
- |
Total |
650 |
1,80,065 |
135 |
36,450 |
LIFO Method: Under LIFO method, it is assumed that the units of inventory which are latest bought will be sold first and moving backwards. Thus the ending inventory will be units which are bought at the earliest and so on. In the given question, the company had 135 units in the ending inventory. Under LIFO method, the said inventory will be from the units in beginning inventory at $ 270 per unit.
Therefore the value of ending inventory under LIFO method is $ 36,450.
Information about Vinzant Company’s inventory of one item follows. Compute the cost of the ending inventory...
Exercise 17.1 Using the various costing methods of inventory valuation. LO 17-1 Information about Vinzant Company's inventory of one item follows. Number of eBook Explanation Units 165 Unit Cost Beginning inventory, January 1 Purchases: April August October Ending inventory, December 31 $300 eterences 205 305 225 310 175 165 312 1. Compute the cost of the ending inventory under the average cost method. 2. Compute the cost of the ending inventory under the FIFO method. 3. Compute the cost of...
Problem 17.1A Computing inventory costs under different valuation methods. LO 17-1 The following data concerns inventory and purchases at Muse Company. 95 units at $108 Inventory, January 1 Purchases: January 6 January 15 January 22 Inventory, January 31 65 units at $107 50 units at $107 40 units at $101 93 units a. Determine the cost of the ending inventory on January 31 under the average cost method. b. Determine the cost of the ending inventory on January 31 under...
E6A-26 Comparing ending merchandise inventory, cost of goods sold, and gross profit using the periodic inventory system-FIFO, LIFO, and weighted-average methods Assume that Jump Coffee Shop completed the following periodic inventory trans actions for a line of merchandise inventory: g Objective 7 Appendix 6A 2. COGS $513 53A G03 Jun. 1 Beginning merchandise inventory 17 units @ $ 15 each 12 Purchase 5 units @$19 each 20 Sale TO 14 units @$37 each 24 Purchase 11 units @ $ 23...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand—2,700 units; cost $6.00 each. 8 Purchased 13,500 units for $6.20 each. 14 Sold 10,800 units for $12.70 each. 18 Purchased 8,100 units for $6.30 each. 25 Sold 9,800 units for $11.70 each. 28 Purchased 4,700 units for $5.80 each. 31 Inventory on hand—8,400 units. Required: Using calculations based on a periodic inventory system, determine the inventory balance Altira would...
2) ) Beginning inventory, purchases, and sales for Item HM46 are as follows: August 1 Inventory 59 units @ $25 9 Sale 47 units 13 Purchase 42 units @ $28 28 Sale 19 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on August 28 and (b) the inventory on August 31. a. Cost of merchandise sold on August 28 b. Inventory on August 31 Beginning inventory, purchases, and...
Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 600 units from beginning inventory, 380 from the February 10 purchase, 120 from the March 13 purchase, 130 from the August 21 purchase, and 205 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.) Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases...
Daniel Company uses a periodic inventory system. Data for the current year: beginning merchandise inventory (ending inventory December 31, prior year), 2,000 units at $38; purchases, 8,000 units at $40; expenses (excluding income taxes), $184,500; ending inventory per physical count at December 31, current year, 1,800 units; sales, 8,200 units; sales price per unit, $75; and average income tax rate, 30 percent. Compute cost of goods sold under the FIFO, LIFO, and average cost inventory costing methods. (Do not round...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available: Aug.1 Inventory on hand-10,500 units: cost $8.40 each 8 Purchased 29,000 units for $7.40 each. 14 Sold 20, 500 units for $13.90 each. 18 Purchased 15, 500 units for $6.90 each 25 Sold 19, 500 units for $12.90 each. 31 Inventory on hand-15,000 units. Required: Determine the inventory balance Altira would report in its August 31, 2018,...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2016 is available: Aug.1 Inventory on hand—10,500 units; cost $8.80 each. 8 Purchased 30,000 units for $7.50 each. 14 Sold 21,000 units for $14.00 each. 18 Purchased 16,000 units for $7.00 each. 25 Sold 20,000 units for $13.00 each. 31 Inventory on hand—15,500 units. Required: Determine the inventory balance Altira would report in its August 31, 2016, balance sheet and...
AVERAGE COST METHOD LIFO METHOD Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021: Aug.1 Inventory on hand-3,200 units; cost $6.50 each. 8 Purchased 16,000 units for $6.70 each. 14 Sold 12,800 units for $13.20 each 18 Purchased 9,600 units for $6.80 each. 25 Sold 11,800 units for $12.20 each. 28 Purchased 5,200 units for $5.80 each. 31 Inventory on hand-9,400 units. Required: Using calculations based on a periodic inventory system, determine...