1 | ||||||
Average cost | Merchandise available for sale | Ending inventory | ||||
Number of units | Unit cost | Total cost | Number of units | Unit cost | Total cost | |
Beginning inventory, January 1 | 95 | 108 | 10260 | |||
Purchases: | ||||||
January 6 | 65 | 107 | 6955 | |||
January 15 | 50 | 107 | 5350 | |||
January 22 | 40 | 101 | 4040 | |||
Total | 250 | 106.42 | 26605 | 93 | 106.42 | 9897 |
2 | ||||||
FIFO | Merchandise available for sale | Ending inventory | ||||
Number of units | Unit cost | Total cost | Number of units | Unit cost | Total cost | |
Beginning inventory, January 1 | 95 | 108 | 10260 | 0 | 108 | 0 |
Purchases: | ||||||
January 6 | 65 | 107 | 6955 | 3 | 107 | 321 |
January 15 | 50 | 107 | 5350 | 50 | 107 | 5350 |
January 22 | 40 | 101 | 4040 | 40 | 101 | 4040 |
Total | 250 | 26605 | 93 | 9711 | ||
3 | ||||||
LIFO | Merchandise available for sale | Ending inventory | ||||
Number of units | Unit cost | Total cost | Number of units | Unit cost | Total cost | |
Beginning inventory, January 1 | 95 | 108 | 10260 | 93 | 108 | 10044 |
Purchases: | ||||||
January 6 | 65 | 107 | 6955 | 0 | 107 | 0 |
January 15 | 50 | 107 | 5350 | 0 | 107 | 0 |
January 22 | 40 | 101 | 4040 | 0 | 101 | 0 |
Total | 250 | 26605 | 93 | 10044 | ||
4 | ||||||
LIFO resulted in highest ending inventory |
Problem 17.1A Computing inventory costs under different valuation methods. LO 17-1 The following data concerns inventory...
Problem 17.1A Computing inventory costs under different valuation methods. LO 17-1 The following data concerns inventory and purchases at Muse Company. bok 95 units at $108 int Inventory, January 1 Purchases: January 6 January 15 January 22 Inventory, January 31 ences 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...
Problem 17.2A Computing inventory costs under different valuation methods and applying the lower of cost or net realizable value rule. LO 17-1, 17-3 The following data pertains to Efficient Market Investment software packages in the inventory of the Investment Software division of Efficient Market Investment Outlets: 210 units at $115 Inventory, January 1 Purchases: May 10 August 18 October 1 Inventory, December 31 150 units at $113 220 units at $112 210 units at $113 1(a). Determine the cost of...
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...
The following data pertains to Efficient Market Investment software packages in the inventory of the Investment Software division of Efficient Market Investment Outlets: 1(a). Determine the cost of the inventory on December 31 and the cost of goods sold for the year ending on that date under the FIFO method. 1(b). Determine the cost of the inventory on December 31 and the cost of goods sold for the year ending on that date under the LIFO method. 1(c). Determine the...
Information about Vinzant Company’s inventory of one item follows. Compute the cost of the ending inventory under the average cost method. Compute the cost of the ending inventory under the FIFO method. Compute the cost of the ending inventory under the LIFO method. Number of Unit Units Cost 135 $ 270 Explanation Beginning inventory, January 1 Purchases: April August October Ending inventory, December 31 175 195 145 135 275 280 282 Complete this question by entering your answers in the...
Problem #1 Periodic Inventory Methods/Valuation Hyper Company had a beginning inventory on January 1 of 160 units of Product 4-18-19 at a cost of $20 per unit. During the year, the following purchases were made. Mar. 15 400 units at $23 Sept. 4 330 units at $26 July 20 250 units at $24 Dec. 2 100 units at $29 1,000 units were sold. Hyper Company uses a periodic inventory system. Instructions (a) Determine the cost of goods available for sale....
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $28 $420 Aug. 7 Purchase 18 units at $31 558 Dec. 11 Purchase 14 units at $33 462 47 units $1,440 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
The following data relates to the inventory and purchases of item 125 for Sanders Company during May: Inventory, May 1 520 units at $21.00 Purchases: May 10 380 units at $20.75 May 19 280 units at $20.35 May 25 320 units at $20.40 Inventory, May 31 460 units INSTRUCTIONS Determine the cost of the ending inventory on May 31 under each of the following methods: (a) average cost method; (b) first-in, first-out (FIFO) method; and (c) last-in, first-out (LIFO) method....
Beginning Inventory, purchases, and sales data for portable DVD players are as follows: Apr. 1 Inventory 50 units $66 10 Sale 37 units 15 Purchase 22 units $69 20 Sale 17 units Sale 11 units Purchase 36 units $73 The business maintains a perpetual inventory system, costing by the first-in, Erst out method Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form ustrated in Exhibit a....
Question 1 Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 49 units @ $53 10 Sale 34 units 64 units @ $56 15 20 Purchase Sale 36 units 24 Sale 9 units 30 Purchase 22 units @ $58 The business maintains a perpetual inventory system, costing by the last-in, first-out method. Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the...