In: Accounting
12. Beech Soda, Inc. uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows:
Jan. 1 Beginning inventory = 16 units at a price of $10 each
Jan. 11 Purchased inventory = 14 units at a price of $11.95 each
Jan. 20 Purchased inventory = 23 units at a price of $15 each
On January 14, Beech Soda, Inc. sold 25 units of this product.
The other 28 units remained in inventory at January 31.
Assuming that Beech Soda uses the moving average cost flow assumption, the cost of goods sold to be recorded at January 14 (round cost per unit to nearest whole cent) is:
13. Beech Soda, Inc. uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows:
Jan. 1 Beginning inventory = 16 units at a price of $10 each
Jan. 11 Purchased inventory = 14 units at a price of $11.95 each
Jan. 20 Purchased inventory = 23 units at a price of $15 each
On January 14, Beech Soda, Inc. sold 25 units of this product.
The other 28 units remained in inventory at January 31.
Assuming that Beech Soda uses the moving average cost flow assumption, the ending inventory cost at January 31 to be reported is:
14. Harding Systems, Inc. uses a periodic inventory system. The acquisition of a particular product during the year are shown as follows:
Jan. 1 beginning inventory was 1,100 units at $7.25 each;
Feb. 7 purchased 1,450 units at $7.50 each;
July 10 purchased 1,600 units at $8.00 each;
Nov. 25 purchased 1,000 units at $8.50 each.
At December 31 a physical count determined that ending inventory consisted of 1,500 units.
Compute the cost (rounded to the nearest dollar) of the ending inventory based on the average-cost method of inventory valuation.
W. Avg | Purchases | Cost of Goods Sold | Ending Balance | |||||||
Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Jan. 1 | Beginning Inventory | 16 | $ 10.00 | $ 160.00 | ||||||
Jan. 11 | Purchase | 14 | $ 11.95 | $ 167.30 | 30 | $ 10.91 | $ 327.30 | |||
Jan. 14 | Sales | 25 | $ 10.91 | $ 272.75 | 5 | $ 10.91 | $ 54.55 | |||
Jan. 20 | Purchase | 23 | $ 15.00 | $ 345.00 | 28 | $ 14.27 | $ 399.55 | |||
Jan. 28 | Sales | 28 | $ 14.27 | $ 399.55 | 0 | $ - | ||||
Total | 37 | $ 512.30 | 53 | $ 672.30 | 0 | $ - |
12. Cost of Goods Sold = $272.75
13. Ending Inventory = 0
14.
Cost of Goods Available for Sale | |||
Activity | Units | Unit Price | Amount |
Beginning Inventory | 1100 | $ 7.25 | $ 7,975 |
Purchases Feb. 7 | 1450 | $ 7.50 | $ 10,875 |
Purchases Jul. 10 | 1600 | $ 8.00 | $ 12,800 |
Purchases Nov. 25 | 1000 | $ 8.50 | $ 8,500 |
Total | 5150 | $ 7.80 | $ 40,150 |
Ending Inventory = 1500 x $7.8 = $11700