In: Accounting
Perpetual Inventory Using Weighted Average
Beginning inventory, purchases, and sales for WCS12 are as follows:
| Oct. 1 | Inventory | 300 units at $13 | |
| 13 | Sale | 170 units | |
| 22 | Purchase | 370 units at $14 | |
| 29 | Sale | 200 units |
a. Assuming a perpetual inventory system and
using the weighted average method, determine the weighted average
unit cost after the October 22 purchase. Round your answer to two
decimal places.
$per unit
b. Assuming a perpetual inventory system and
using the weighted average method, determine the cost of goods sold
on October 29. Round your "average unit cost" to two decimal
places.
$
c. Assuming a perpetual inventory system and
using the weighted average method, determine the inventory on
October 31. Round your "average unit cost" to two decimal
places.
$
| a. | $13.74 | ||||||||
| b. | $2,748 | ||||||||
| c. | $4,122 | ||||||||
| Working | |||||||||
| Average Cost - Perpetual | |||||||||
| Purchases | Cost of Goods Sold | Inventory Balance | |||||||
| Perpetual Average | # of units | Cost per unit | # of units sold | Cost per unit | Cost of goods sold | # of units | Cost per unit | Inventory Value | |
| October 1 | 300 | $13.00 | $3,900 | ||||||
| October 13 | 170 | $13.00 | $2,210 | 130 | $13.00 | $1,690 | |||
| Purchase - October 22 | 370 | $14.00 | 130 | $13.00 | $1,690 | ||||
| 370 | $14.00 | $5,180 | |||||||
| Average cost | 500 | $13.74 | $6,870 | ||||||
| Sale - October 29 | 200 | $13.74 | $2,748 | 300 | $13.74 | $4,122 | |||
| Average cost | 370 | $4,958 | 300 | $4,122 | |||||