In: Accounting
The following data represent the beginning inventory and, in order of occurrence, the purchases and sales of Las Lemus, Inc. for an operating period.
Units |
Unit Cost |
Total Cost |
Units Sold |
|||
Beginning Inventory |
32 |
$36 |
$1,152 |
|||
Sale No. 1 |
10 |
|||||
Purchase No. 1 |
28 |
40 |
1,120 |
|||
Sale No. 2 |
32 |
|||||
Purchase No. 2 |
20 |
38 |
760 |
|||
Totals |
80 |
$3,032 |
42 |
Assuming Las Lemus, Inc. uses weighted-average (periodic) inventory
procedures, the ending inventory cost is:
A. |
$1,444.00 |
|
B. |
$1,594.80 |
|
C. |
$1,442.00 |
|
D. |
$1,440.20 |
Option D | $1440.20 | is correct | answer | |||||||
Explanation: | ||||||||||
Calculation of Units of Ending Inventory | ||||||||||
Units available for sale | ||||||||||
Beginning Inventory | 32 | |||||||||
Purchases | ||||||||||
Purchase No. 1 | 28 | |||||||||
Purchase No. 2 | 20 | 48 | ||||||||
Units available for sale | 80 | |||||||||
Less: | Units sold | |||||||||
Sale No. 1 | 10 | |||||||||
Sale No. 2 | 32 | 42 | ||||||||
Units of Ending Inventory | 38 | |||||||||
Calculation of ending inventory under Weighted Average Cost - Periodic system:- | ||||||||||
Cost of Goods Available for Sale | Cost of Goods Sold - Average Cost | Ending inventory - Average Cost | ||||||||
# of Units | Cost of Goods Available for Sale | Cost of Goods Available for Sale | # of Units sold | Average Cost per Unit | Cost of Goods Sold | # of Units in Ending inventory | Average Cost per Unit | Ending inventory | ||
Beginning Inventory | 32 | $ 36.00 | $ 1,152.00 | |||||||
Purchases: | ||||||||||
Purchase No. 1 | 28 | $ 40.00 | $ 1,120.00 | |||||||
Purchase No. 2 | 20 | $ 38.00 | $ 760.00 | |||||||
Total | 80 | $ 37.90 | $ 3,032.00 | 42 | $ 37.90 | $ 1,591.80 | 38 | $ 37.90 | 1,440.20 |
Weighted Average Cost per unit | = | $ 3,032.00 | ||||||||
80 | ||||||||||
= | $ 37.90 |
Feel free to ask any clarification, if required. Please provide feedback by thumbs up, if satisfied. It will be highly appreciated. Thank you.