In: Accounting
Riverbed Company was formed on December 1, 2016. The following
information is available from Riverbed’s inventory records for
Product BAP.
Units |
Unit Cost |
|||
January 1, 2017 (beginning inventory) |
732 |
$ 8.00 |
||
Purchases: |
||||
January 5, 2017 |
1,464 |
9.00 |
||
January 25, 2017 |
1,586 |
10.00 |
||
February 16, 2017 |
976 |
11.00 |
||
March 26, 2017 |
732 |
12.00 |
A physical inventory on March 31, 2017, shows 1,952 units on
hand.
Units |
Unit cost |
Total Cost |
|
Ending inventory |
Units |
Unit cost |
Total Cost |
|
Ending inventory |
3. Calculate average-cost per unit. (Round answer to 2 decimal places, e.g. 2.76.)
4. Compute the ending inventory at March 31, 2017, under Weighted-average inventory method. (Round answer to 0 decimal places, e.g. 2,760.)
Note : answer 4 may have approximation difference of $3. Let me know if you get any error in that part.
ans -1 | FIFO | |||||
Unit | Unit cost | Total cost | ||||
March 26, 2017 | 732 | 12 | 8784 | |||
February 16, 2017 | 976 | 11 | 10736 | |||
January 25, 2017 | 244 | 10 | 2440 | |||
Ending inventory | 1952 | 21960 | ||||
ans 2 | LIFO | |||||
Unit | Unit cost | Total cost | ||||
January 1, 2017 (beginning inventory) | 732 | 8 | 5856 | |||
January 5, 2017 | 1,220 | 9 | 10980 | |||
Ending inventory | 1952 | 16836 | ||||
ans 3 | Computation of average cost | |||||
Units | Unit Cost | total cost | ||||
January 1, 2017 (beginning inventory) | 732 | 8 | 5,856 | |||
January 5, 2017 | 1,464 | 9 | 13,176 | |||
January 25, 2017 | 1,586 | 10 | 15,860 | |||
February 16, 2017 | 976 | 11 | 10,736 | |||
March 26, 2017 | 732 | 12 | 8,784 | |||
Total | 5,490 | 54,412 | ||||
Average cost = 54412/5490 | 9.91 | |||||
ans 4 | Ending inventory using weighted average cost | |||||
Ending inventry =9.91*1952 | 19,346 | |||||