In: Accounting
Given the following information, determine the journal entries:
(Note: When computing the cost of goods sold and ending inventory, please see Exhibits 5A.3, 5A.4 and 5A.5 to prepare a schedule to assist you in the computations. It is a good thing to show your computations in a schedule in case you make a mistake. I will give credit for the problem if it is set up properly and there is a math error as long as I can see the setup)
a. using the weighted average perpetual inventory method.
b. using the LIFO perpetual inventory method.
c. using the FIFO perpetual inventory method.
March beginning inventory is 5 units at $6 per unit.
March 3: 15 units were purchased at $7 per unit.
March 11: 10 units were purchased at $9 per unit.
March 15: 20 units were sold at $15 per unit.
March 18: 35 units were purchased at $10 per unit.
March 31: 30 units were sold at $20 per unit.
| Calculation of Ending Inventory: Weighted Average Cost | ||||||||||||||
| Date | Purchases | Sales | Balance | |||||||||||
| Units | PU | Total Cost | Units | PU | Total Cost | Units | PU | Total Cost | PU | |||||
| Opening Balance | 5.00 | 6.00 | 30.00 | |||||||||||
| Weighted Average Cost | ||||||||||||||
| 03-Mar | 15 | 7.00 | 105 | 20.00 | 6.75 | 135.00 | 135/20 | Opening Stock | 30 | |||||
| Add: Purchases | 545 | |||||||||||||
| 11-Mar | 10 | 9.00 | 90 | 30 | 7.50 | 225 | 225/30 | Less: Closing Inventory | 142 | |||||
| Cost of Goods Sold | 433 | |||||||||||||
| 15-Mar | 20 | 7.50 | 150 | 10 | 7.50 | 75 | ||||||||
| 18-Mar | 35 | 10 | 350 | 45 | 9.44 | 425 | 425/45 | |||||||
| 31-Mar | 30 | 9.44 | 283.33 | 15 | 9.44 | 142 | ||||||||
| Total | 65 | 575 | 50 | 433 | 15 | 142 | ||||||||
| Calculation of Ending Inventory: LIFO | ||||||||||||||
| Date | Purchases | Sales | Balance | |||||||||||
| Units | PU | Total Cost | Units | PU | Total Cost | Units | PU | Total Cost | ||||||
| Opening Balance | 5.00 | 6.00 | 30.00 | |||||||||||
| LIFO | ||||||||||||||
| 03-Mar | 15 | 7.00 | 105 | 5.00 | 6.00 | 30.00 | Opening Stock | 30.00 | ||||||
| 15 | 7.00 | 105 | Add: Purchases | 545.00 | ||||||||||
| Less: Closing Inventory | 115 | |||||||||||||
| 11-Mar | 10 | 9.00 | 90 | 5.00 | 6.00 | 30.00 | Cost of Goods Sold | 460 | ||||||
| 15.00 | 7.00 | 105.00 | ||||||||||||
| 10 | 9.00 | 90.00 | ||||||||||||
| 15-Mar | 10 | 9.00 | 90 | 5.00 | 6.00 | 30.00 | ||||||||
| 10 | 7.00 | 70 | 5.00 | 7.00 | 35.00 | |||||||||
| 18-Mar | 35 | 10 | 350 | 5.00 | 6.00 | 30.00 | ||||||||
| 5.00 | 7.00 | 35.00 | ||||||||||||
| 35 | 10.00 | 350.00 | ||||||||||||
| 31-Mar | 30 | 10.00 | 300.00 | 5.00 | 6.00 | 30.00 | ||||||||
| 5.00 | 7.00 | 35.00 | ||||||||||||
| 5.00 | 10.00 | 50.00 | ||||||||||||
| Total | 65 | 575 | 50 | 460 | 15 | 115 | ||||||||
| Calculation of Ending Inventory: FIFO | ||||||||||||||
| Date | Purchases | Sales | Balance | |||||||||||
| Units | PU | Total Cost | Units | PU | Total Cost | Units | PU | Total Cost | ||||||
| Opening Balance | 5.00 | 6.00 | 30.00 | |||||||||||
| FIFO | ||||||||||||||
| 03-Mar | 15 | 7.00 | 105 | 5.00 | 6.00 | 30.00 | Opening Stock | 30.00 | ||||||
| 15 | 7.00 | 105 | Add: Purchases | 545.00 | ||||||||||
| Less: Closing Inventory | 150.00 | |||||||||||||
| 11-Mar | 10 | 9.00 | 90 | 5.00 | 6.00 | 30.00 | Cost of Goods Sold | 425.00 | ||||||
| 15.00 | 7.00 | 105.00 | ||||||||||||
| 10.00 | 9.00 | 90.00 | ||||||||||||
| 15-Mar | 5.00 | 6.00 | 30.00 | 10.00 | 9.00 | 90.00 | ||||||||
| 15.00 | 7.00 | 105.00 | ||||||||||||
| 18-Mar | 35 | 10 | 350 | 10.00 | 9.00 | 90.00 | ||||||||
| 35.00 | 10.00 | 350.00 | ||||||||||||
| 31-Mar | 10 | 9.00 | 90.00 | 15.00 | 10.00 | 150.00 | ||||||||
| 20 | 10.00 | 200.00 | ||||||||||||
| Total | 65 | 575 | 50 | 425 | 15 | 150 | ||||||||