Question

ABC Company uses a periodic inventory system. Relevant inventory information for the year is: January 1...

ABC Company uses a periodic inventory system. Relevant inventory information for the year is: January 1 Beginning inventory 20 units @ $170 per unit May 23 Purchase 20 units @ $125 per unit November 5 Purchase 400 units @ $160 per unit November 18 Purchase 100 units @ $175 per unit At year-end, 50 units remain in inventory. What is the cost of the ending inventory on an Average Cost basis? Round average cost per unit to the nearest cent.  

Homework Answers

Answer #1
Date Particulars Units Cost per unit Total cost
January 1 Beginning inventory 20 170 3400
May 23 Purchase 20 125 2500
November 5 Purchase 400 160 64000
November 18 Purchase 100 175 17500
Goods available for sale 540 87400
Average cost per unit = Cost of goods available for sale / Units available for sale = 87400 / 540 161.85
Cost of ending inventory = Ending inventory units * Average cost per unit = 50 * 161.85 8092.50
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ABC Company uses a periodic inventory system. As of January 1, 2019, ABC Company has 1,100...
ABC Company uses a periodic inventory system. As of January 1, 2019, ABC Company has 1,100 units of a particular product at a cost of $7.35 per unit. At December 31, 2019, 1,500 units of the product remain on hand. The purchases of the product during the year are shown below: 1st purchase 1,450 units at $7.50 per unit 2nd purchase 1,600 units at $8.20 per unit 3rd purchase 1,000 units at $8.50 per unit What is cost of goods...
Torrey Company uses the periodic inventory system to account for inventories. Information related to Torrey Company's...
Torrey Company uses the periodic inventory system to account for inventories. Information related to Torrey Company's inventory at October 31 is given below: October 1 Beginning inventory 400 units x $10.00 = $4,000 8 Purchase 800 units x $10.40 = 8,320 16 Purchase 600 units x $10.80 = 6,480 24 Purchase 200 units x $11.60 = 2,320 Total units and cost 2,000 units $21,120 Value the ending inventory using the FIFO cost assumption if 500 units remain on hand at...
2. Average-Cost Method: Periodic Inventory System Assume the following data with regard to inventory for Vegan...
2. Average-Cost Method: Periodic Inventory System Assume the following data with regard to inventory for Vegan Company: Aug. 1 Inventory 40 units @ $10 per unit $ 400 8 Purchase 50 units @ $11 per unit 550 22 Purchase 35 units @ $12 per unit 420 Goods available for sale 125 units $1,370 Aug. 15 Sale 58 units 28 Sale 25 units Inventory, Aug. 31 42 units Calculate the cost of ending inventory and cost of goods sold according to...
Rogers Products uses a periodic inventory system. The company’s records show the beginning inventory of PH4...
Rogers Products uses a periodic inventory system. The company’s records show the beginning inventory of PH4 oil filters on January 1 and the purchases of this item during the current year to be as follows. Jan. 1 Beginning inventory 90 units @ $ 3.00 $ 270.00 Feb. 23 Purchase 120 units @ $ 3.50 420.00 Apr. 20 Purchase 300 units @ $ 3.80 1,140.00 May 4 Purchase 400 units @ $ 4.00 1,600.00 Nov. 30 Purchase 190 units @ $...
Vaughn Company uses a periodic inventory system. Details for the inventory account for the month of...
Vaughn Company uses a periodic inventory system. Details for the inventory account for the month of January, 2018 are as follows: Units Per unit price Total Balance, 1/1/18 170 $5.00 $850 Purchase, 1/15/18 130 5.10   663 Purchase, 1/28/18 130 5.40   702 An end of the month (1/31/18) inventory showed that 220 units were on hand. If the company uses FIFO, what is the value of the ending inventory? $1100 $1125 $1161 $1122
Rogers Products uses a periodic inventory system. The company’s records show the beginning inventory of PH4...
Rogers Products uses a periodic inventory system. The company’s records show the beginning inventory of PH4 oil filters on January 1 and the purchases of this item during the current year to be as follows. Jan. 1 Beginning inventory 12 units @ $ 3.00 $ 36.00 Feb. 23 Purchase 17 units @ $ 3.50 59.50 Apr. 20 Purchase 26 units @ $ 3.80 98.80 May 4 Purchase 44 units @ $ 4.00 176.00 Nov. 30 Purchase 18 units @ $...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are for an item in Merritt's inventory: May 1 Beginning inventory 310 units @ $30 per unit 12 Purchased 260 units @ $35 per unit 16 Sold 340 units @ 24 Purchased 160 units @ $36 per unit Calculate the cost of goods sold for May and ending inventory at May 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods....
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per...
ABC Company employs a periodic inventory system and sells its inventory to customers for $23 per unit. ABC Company had the following inventory information available for the month of May: May 1 Beginning inventory 1,600 units @ $12 cost per unit May 8 Sold 1,100 units May 13 Purchased 1,700 units @ $24 cost per unit May 18 Sold 1,000 units May 21 Purchased 1,500 units @ $18 cost per unit May 28 Sold 800 units May 30 Purchased 1,200...
Effie Company uses a periodic inventory system. Details for the inventory account for the month of...
Effie Company uses a periodic inventory system. Details for the inventory account for the month of January, 2020 are as follows: Units Per unit price Total Balance, 1/1/20 200 $5.00 $1,000 Purchase, 1/15/20 100 5.30 530 Purchase, 1/28/20 100 5.50 550 An end of the month (1/31/20) inventory showed that 160 units were on hand. If the company uses FIFO and sells the units for $10 each, what is the gross profit for the month? A. $1120 B. $1600 C....
Consider the following information for Maynor Company, which uses a periodic inventory system:        Transaction...
Consider the following information for Maynor Company, which uses a periodic inventory system:        Transaction Units Unit Cost Total Cost   January 1 Beginning Inventory 31 $ 81 $ 2,511   March 28 Purchase 41 87 3,567   August 22 Purchase 62 91 5,642   October 14 Purchase 67 97 6,499 Goods Available for Sale 201 $ 18,219    The company sold 67 units on May 1 and 62 units on October 28.     Required: Calculate the company's ending inventory and cost of...