In: Accounting
Exercise 6-8 Moath Company reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 560 $5 $ 2,800 12 Purchase 1,120 7 7,840 23 Purchase 840 10 8,400 30 Inventory 280 Calulate Weighted Average Unit Cost. (Round answer to 2 decimal places, e.g. 15.25.) Weighted Average Unit Cost $ Compute the cost of the ending inventory and the cost of goods sold using the average-cost method. (Round answers to 0 decimal places, e.g. 1,250.) The ending inventory $ The cost of goods sold $ LINK TO TEXT Will the results in (a) be higher or lower than the results under FIFO and LIFO? Ending inventory is than FIFO $ and than LIFO $. In contrast, cost of goods sold is than FIFO $ and than LIFO $.
| Ans.1 | Weighted average cost method: | |||||||||||||
| Date | Units | Unit cost | Total cost | |||||||||||
| 1-Jun | 560 | 5 | 2800 | |||||||||||
| 12-Jun | 1120 | 7 | 7840 | |||||||||||
| 23-Jun | 840 | 10 | 8400 | |||||||||||
| 2520 | 19040 | |||||||||||||
| Weighted average unit cost = Total cost / Total units | ||||||||||||||
| 19040 / 2520 | ||||||||||||||
| 7.55555 | ||||||||||||||
| or 7.56 | ||||||||||||||
| Cost of Ending inventory = Weighted average unit cost * Ending inventory units | ||||||||||||||
| 7.5555 * 280 | ||||||||||||||
| 2116 | ||||||||||||||
| Units sold = Units available for sale - Ending inventory units | ||||||||||||||
| 2520 - 280 | ||||||||||||||
| 2240 | ||||||||||||||
| Cost of goods sold = Weighted average unit cost * Units sold | ||||||||||||||
| 7.5555 * 2240 | ||||||||||||||
| 16924 | ||||||||||||||
| Ans.2 | FIFO: (Periodic) | |||||||||||||
| Ending inventory | ||||||||||||||
| Date | Units | Unit cost | Total cost | |||||||||||
| 23-Jun | 280 | 10 | 2800 | |||||||||||
| Cost of goods sold: | ||||||||||||||
| Date | Units | Unit cost | Total cost | |||||||||||
| 1-Jun | 560 | 5 | 2800 | |||||||||||
| 12-Jun | 1120 | 7 | 7840 | |||||||||||
| 23-Jun | 560 | 10 | 5600 | |||||||||||
| 2240 | 16240 | |||||||||||||
| *While using the FIFO the Ending inventory will be higher and the cost of goods sold will be lower than using the weighted average cost method. | ||||||||||||||
| LIFO: (Periodic) | ||||||||||||||
| Ending inventory | ||||||||||||||
| Date | Units | Unit cost | Total cost | |||||||||||
| 1-Jun | 280 | 5 | 1400 | |||||||||||
| Cost of goods sold: | ||||||||||||||
| Date | Units | Unit cost | Total cost | |||||||||||
| 23-Jun | 840 | 10 | 8400 | |||||||||||
| 12-Jun | 1120 | 7 | 7840 | |||||||||||
| 1-Jun | 280 | 5 | 1400 | |||||||||||
| 2240 | 17640 | |||||||||||||
| *While using the FIFO the Ending inventory will be lower and the cost of goods sold will be higher than using the weighted average cost method. | ||||||||||||||