In: Accounting
Purchase Units Unit Cost Sold Units
Beg.nventory 3000 0.60$
Dec3 4000 0.74$
Dec5 4400
Dec17 2200 0.80$
Dec22 2100
Compute ending inventory and cost of goods sold using moving- average cost, assuming the Company uses the perpetual inventory system
First of all format of data is confusing. I am assuming the Dec 5 and Dec 22 units are sold units and other are purchases.
Calculation of ending inventory and cost of goods sold using moving- average cost, assuming the Company uses the perpetual inventory system
Perpetual Moving Average |
Goods Purchased |
Cost of Goods Sold |
Inventory Balance |
||||||
# of units |
Unit Cost |
Cost per unit |
# of units |
Cost per unit |
Cost of goods sold |
Total Cost of Goods (a) |
Total Available Units (b) |
Unit Average Cost (a/b) |
|
Beginning Inventory |
$1,800.00 |
3000 |
$0.6000 |
||||||
Purchases Dec.3 |
4000 |
$0.74 |
$2,960.00 |
$1,800.00 |
3000 |
||||
$2,960.00 |
4000 |
||||||||
$4,760.00 |
7000 |
$0.6800 |
|||||||
Sales Dec.5 |
4400 |
$0.68 |
$2,992.00 |
$1,768.00 |
2600 |
$0.6800 |
|||
Purchases Dec.17 |
2200 |
$0.80 |
$1,760.00 |
$1,768.00 |
2600 |
||||
$1,760.00 |
2200 |
||||||||
$3,528.00 |
4800 |
$0.7350 |
|||||||
Sales Dec.22 |
2100 |
$0.7350 |
$1,543.50 |
$1,984.50 |
2700 |
$0.7350 |
|||
TOTAL |
$4,535.50 |
Cost of Goods Sold = $4,535.50
Ending Inventory = $1,984.50
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you